APPS.HRI_OPL_MULTI_THREAD dependencies on FND_CONCURRENT_REQUESTS

Line 219: ,fnd_concurrent_requests req

215: CURSOR mtmasters_cur IS
216: SELECT count(req.request_id) count
217: FROM fnd_concurrent_programs cp
218: ,fnd_executables ex
219: ,fnd_concurrent_requests req
220: WHERE ex.executable_id = cp.executable_id
221: AND cp.concurrent_program_id = req.concurrent_program_id
222: AND ex.application_id = cp.EXECUTABLE_APPLICATION_ID
223: AND cp.application_id = req.PROGRAM_APPLICATION_ID

Line 230: FROM fnd_concurrent_requests req1

226: AND req.PHASE_CODE <> 'C'
227: -- Requests previously submitted within the same request set
228: AND req.request_id IN
229: (SELECT req1.request_id
230: FROM fnd_concurrent_requests req1
231: WHERE req1.priority_request_id =
232: -- Subquery for requests in request set
233: (SELECT req2.priority_request_id
234: FROM fnd_concurrent_requests req2

Line 234: FROM fnd_concurrent_requests req2

230: FROM fnd_concurrent_requests req1
231: WHERE req1.priority_request_id =
232: -- Subquery for requests in request set
233: (SELECT req2.priority_request_id
234: FROM fnd_concurrent_requests req2
235: WHERE req2.request_id = fnd_global.conc_request_id)
236: -- Filter on previously submitted requests only
237: AND req1.request_id < fnd_global.conc_request_id);
238:

Line 479: fnd_concurrent_requests req

475: --
476: CURSOR c_process_name IS
477: SELECT concurrent_program_name
478: FROM fnd_concurrent_programs prg,
479: fnd_concurrent_requests req
480: WHERE prg.concurrent_program_id = req.concurrent_program_id
481: AND req.request_id = fnd_global.conc_request_id;
482: --
483: l_process_name VARCHAR2(30);

Line 1126: FROM fnd_concurrent_requests fnd

1122: --
1123: CURSOR c_slaves (c_request_id number) IS
1124: SELECT phase_code,
1125: status_code
1126: FROM fnd_concurrent_requests fnd
1127: WHERE fnd.request_id = c_request_id;
1128: --
1129: l_slaves c_slaves%rowtype;
1130: --

Line 1177: -- Pause to avoid over polling of fnd_concurrent_requests

1173: END IF;
1174: --
1175: END LOOP;
1176: --
1177: -- Pause to avoid over polling of fnd_concurrent_requests
1178: --
1179: l_sleep := dbms_pipe.receive_message
1180: (pipename => 'non-existant pipe to force timeout',
1181: timeout => 10);

Line 1798: fnd_concurrent_requests req

1794: CURSOR worker_csr IS
1795: SELECT
1796: req.argument4
1797: FROM
1798: fnd_concurrent_requests req
1799: ,fnd_concurrent_programs prg
1800: WHERE req.concurrent_program_id = prg.concurrent_program_id
1801: AND req.program_application_id = prg.application_id
1802: AND prg.concurrent_program_name = 'HRI_MTHD_CHILD_PROCESS'