Open the request interface in EBS Form

In some cases, it is necessary to open the request submission interface within the EBS Form interface, as shown below:

Fnd_function.execute (

Function_name = > 'FND_FNDRSRUN'

Other_params = > 'PROGRAM_APPL_SHORT_NAME= "CUX" CONCURRENT_PROGRAM_NAME= "XXXXX" CHAR1= "' | | XXXX |'" SUBMIT_ONCE= "Y"'

);

The above operation can directly open the submission interface of a concurrent request with parameters.

If the menu of the current responsibility does not have the function of "FND_FNDRSRUN" mounted, it can only be opened through open_form or call_form.

Both of these are form built-in functions, and you can consult the help manual for detailed instructions.

The following code is used to open the request query interface according to the request ID:

PROCEDURE View_Request_Id (Vn_Request_Id IN NUMBER) IS Param Paramlist; Vv_Conc_Prog_Name VARCHAR2 (30): = 'CUXXXXXX';BEGIN IF Vn_Request_Id IS NULL THEN RETURN; END IF; Param: = Get_Parameter_List (Vv_Conc_Prog_Name); IF NOT Id_Null (Param) THEN Destroy_Parameter_List (Param); END IF Param: = Create_Parameter_List (Vv_Conc_Prog_Name); Add_Parameter (Param, 'mode', Text_Parameter,' VIEW'); Add_Parameter (Param, 'use_org', Text_Parameter,' N'); Add_Parameter (Param, 'DODT_REQ_ID', Text_Parameter, To_Char (Vn_Request_Id)) Open_Form (Fnd_Navigate.Formpath ('FND',' FNDRSRUN'), Activate, Session, Param); END View_Request