DBA Data[Home] [Help]

APPS.PJI_LAUNCH_UPP_MAIN dependencies on FND_CONCURRENT_REQUESTS

Line 212: ( select 'x' from fnd_concurrent_requests x where x.request_id = curr_request_id );

208: SET curr_request_status = 'ERRORED'
209: WHERE nvl(curr_request_id,-1) > 0
210: and curr_request_status = 'COMPLETED'
211: and not exists
212: ( select 'x' from fnd_concurrent_requests x where x.request_id = curr_request_id );
213:
214: EXCEPTION
215: WHEN no_data_found THEN
216: null;

Line 297: From Fnd_Concurrent_Requests a, Fnd_Concurrent_Programs P, Fnd_Application c

293: commit;
294: -- Need to check if any stage 3 program has been submitted and running. If so, error out.
295: Select count(*)
296: Into l_req_count
297: From Fnd_Concurrent_Requests a, Fnd_Concurrent_Programs P, Fnd_Application c
298: Where a.Program_Application_ID = P.Application_ID
299: And a.Concurrent_Program_ID = P.Concurrent_Program_ID
300: AND P.Concurrent_Program_Name in ('PJI_PJP_SUMMARIZE_RBS', 'PJI_PJP_SUMMARIZE_PRTL',
301: 'PJI_PJP_SUMMARIZE_INCR', 'PJI_PJP_SUMMARIZE_FULL','PJI_PJP_SUM_CLEANALL')