APPS.OTA_MANDATORY_ENROLL_UTIL dependencies on FND_CONCURRENT_REQUESTS

Line 138: cursor csr_check_mand_multi_running(c_conc_req_id fnd_concurrent_requests.REQUEST_ID%type) is

134: user_group_id dbms_sql.number_table,
135: requestor_id dbms_sql.number_table
136: );
137:
138: cursor csr_check_mand_multi_running(c_conc_req_id fnd_concurrent_requests.REQUEST_ID%type) is
139: select 1 from fnd_concurrent_requests fcr, fnd_concurrent_programs fcp
140: where fcp.CONCURRENT_PROGRAM_NAME = 'OTA_MAND_ENR_MULTI'
141: and fcp.CONCURRENT_PROGRAM_ID = fcr.CONCURRENT_PROGRAM_ID
142: and fcr.STATUS_CODE = 'R' and nvl(PARENT_REQUEST_ID,-1) = -1

Line 139: select 1 from fnd_concurrent_requests fcr, fnd_concurrent_programs fcp

135: requestor_id dbms_sql.number_table
136: );
137:
138: cursor csr_check_mand_multi_running(c_conc_req_id fnd_concurrent_requests.REQUEST_ID%type) is
139: select 1 from fnd_concurrent_requests fcr, fnd_concurrent_programs fcp
140: where fcp.CONCURRENT_PROGRAM_NAME = 'OTA_MAND_ENR_MULTI'
141: and fcp.CONCURRENT_PROGRAM_ID = fcr.CONCURRENT_PROGRAM_ID
142: and fcr.STATUS_CODE = 'R' and nvl(PARENT_REQUEST_ID,-1) = -1
143: and fcr.REQUEST_ID <> c_conc_req_id;

Line 3273: From fnd_concurrent_requests fnd

3269: l_actn varchar2(80);
3270: --
3271: Cursor c_slaves(p_request_id number) is
3272: Select null
3273: From fnd_concurrent_requests fnd
3274: Where fnd.phase_code <> 'C'
3275: And fnd.request_id = p_request_id;
3276: Begin
3277: hr_utility.set_location ('Entering '||l_proc,5);

Line 3319: from OTA_MAND_MULTI_ENR_REQUESTS omr, fnd_concurrent_requests fcr

3315: hr_utility.set_location ('Entering '||l_proc,5);
3316: dbms_lock.sleep(5);
3317: select omr.CONC_PROGRAM_REQUEST_ID, omr.MANDATORY_ENR_REQUEST_ID
3318: bulk collect into mand_enr_req_rec
3319: from OTA_MAND_MULTI_ENR_REQUESTS omr, fnd_concurrent_requests fcr
3320: where fcr.REQUEST_ID (+) = omr.CONC_PROGRAM_REQUEST_ID
3321: and nvl(fcr.STATUS_CODE,'C') in ('C','E');
3322:
3323: if mand_enr_req_rec.count <= 0 then