APPS.JAI_AR_RCTA_ARIUD_T1 dependencies on FND_CONCURRENT

Line 122: From Fnd_Concurrent_Programs FCP,

118:
119: CURSOR get_max_request_id_cur(pn_customer_transaction_id NUMBER)
120: IS
121: Select nvl(Max(Request_ID),-1)
122: From Fnd_Concurrent_Programs FCP,
123: Fnd_Application FA ,
124: Fnd_Concurrent_Requests FCR
125: Where FCR.Program_Application_ID = FA.Application_ID
126: AND FCR.Concurrent_Program_ID = FCP.Concurrent_Program_ID

Line 124: Fnd_Concurrent_Requests FCR

120: IS
121: Select nvl(Max(Request_ID),-1)
122: From Fnd_Concurrent_Programs FCP,
123: Fnd_Application FA ,
124: Fnd_Concurrent_Requests FCR
125: Where FCR.Program_Application_ID = FA.Application_ID
126: AND FCR.Concurrent_Program_ID = FCP.Concurrent_Program_ID
127: AND FA.Application_ID = FCP.Application_ID
128: AND Concurrent_Program_Name = cv_process_program

Line 150: From Fnd_Concurrent_Programs FCP,

146:
147: CURSOR get_gst_max_request_id_cur(pn_customer_transaction_id NUMBER)
148: IS
149: Select nvl(Max(Request_ID),-1)
150: From Fnd_Concurrent_Programs FCP,
151: Fnd_Application FA ,
152: Fnd_Concurrent_Requests FCR
153: Where FCR.Program_Application_ID = FA.Application_ID
154: AND FCR.Concurrent_Program_ID = FCP.Concurrent_Program_ID

Line 152: Fnd_Concurrent_Requests FCR

148: IS
149: Select nvl(Max(Request_ID),-1)
150: From Fnd_Concurrent_Programs FCP,
151: Fnd_Application FA ,
152: Fnd_Concurrent_Requests FCR
153: Where FCR.Program_Application_ID = FA.Application_ID
154: AND FCR.Concurrent_Program_ID = FCP.Concurrent_Program_ID
155: AND FA.Application_ID = FCP.Application_ID
156: AND Concurrent_Program_Name = cv_gst_process_program

Line 809: lb_call_status :=FND_CONCURRENT.GET_REQUEST_STATUS(request_id =>ln_max_req_id,

805: CLOSE get_max_request_id_cur;
806:
807: IF ( ln_max_req_id <> -1)
808: THEN
809: lb_call_status :=FND_CONCURRENT.GET_REQUEST_STATUS(request_id =>ln_max_req_id,
810: appl_shortname =>'JA',
811: program =>cv_process_program,
812: phase =>lv_rphase,
813: status =>lv_rstatus,

Line 875: lb_call_status :=FND_CONCURRENT.GET_REQUEST_STATUS(request_id =>ln_max_req_id,

871: CLOSE get_gst_max_request_id_cur;
872:
873: IF ( ln_max_req_id <> -1)
874: THEN
875: lb_call_status :=FND_CONCURRENT.GET_REQUEST_STATUS(request_id =>ln_max_req_id,
876: appl_shortname =>'JA',
877: program =>cv_gst_process_program,
878: phase =>lv_rphase,
879: status =>lv_rstatus,