APPS.AD_PATCH_IMPACT_API dependencies on FND_CONCURRENT_REQUESTS

Line 24: select priority_request_id into req_id from fnd_concurrent_requests where

20: Rows_Exceeded Exception;
21: BEGIN
22: --Get the request ID of currently running Request Set
23: --fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> request ID of currently before...');
24: select priority_request_id into req_id from fnd_concurrent_requests where
25: request_id = fnd_global.conc_request_id;
26: --fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> request ID of currently After...');
27: --Get the request ID of the AD CP within the Request Set
28:

Line 33: fnd_concurrent_requests fcr,

29: SELECT
30: fcr.request_id into anal_req_id
31: FROM
32: fnd_application fa,
33: fnd_concurrent_requests fcr,
34: fnd_concurrent_programs fcp
35: WHERE
36: fcr.priority_request_id = req_id and
37: fcr.program_application_id = fcp.application_id and

Line 91: FROM fnd_concurrent_requests

87:
88: --Get the request ID of currently running Request Set
89: SELECT priority_request_id
90: INTO req_id
91: FROM fnd_concurrent_requests
92: WHERE request_id = fnd_global.conc_request_id;
93:
94: --Get the request ID of the AD CP within the Request Set
95: SELECT

Line 99: fnd_concurrent_requests fcr,

95: SELECT
96: fcr.request_id into anal_req_id
97: FROM
98: fnd_application fa,
99: fnd_concurrent_requests fcr,
100: fnd_concurrent_programs fcp
101: WHERE
102: fcr.priority_request_id = req_id
103: AND fcr.program_application_id = fcp.application_id

Line 194: fnd_concurrent_requests

190:
191: SELECT
192: priority_request_id INTO req_id
193: FROM
194: fnd_concurrent_requests
195: WHERE
196: request_id = fnd_global.conc_request_id;
197:
198: --Get the request ID of the AD CP within the Request Set

Line 203: fnd_concurrent_requests fcr,

199: SELECT
200: fcr.request_id INTO anal_req_id
201: FROM
202: fnd_application fa,
203: fnd_concurrent_requests fcr,
204: fnd_concurrent_programs fcp
205: WHERE
206: fcr.priority_request_id = req_id and
207: fcr.program_application_id = fcp.application_id and