[Home] [Help]
155: -- To check for running concurrent pgms
156: -- --------------------------------------
157: CURSOR cnt_csr (p_conc_pgm1 VARCHAR2, p_conc_pgm2 VARCHAR2) IS
158: select count(*)
159: from fnd_concurrent_requests req,
160: fnd_concurrent_programs_vl pgm
161: where pgm.USER_CONCURRENT_PROGRAM_NAME
162: IN ( p_conc_pgm1, p_conc_pgm2)
163: and req.concurrent_program_id = pgm.concurrent_program_id
256: where OBJECT_TYPE = 'CONTRACT'
257: and org_id = l_org_id
258: and request_id in (
259: select req.request_id
260: from fnd_concurrent_requests req,
261: fnd_concurrent_programs_vl pgm
262: where pgm.USER_CONCURRENT_PROGRAM_NAME IN ( 'Master Program -- Process Billable Streams',
263: 'Process Billable Streams')
264: and req.concurrent_program_id = pgm.concurrent_program_id
309: where OBJECT_TYPE = 'CUSTOMER'
310: and org_id = l_org_id
311: and request_id in (
312: select req.request_id
313: from fnd_concurrent_requests req,
314: fnd_concurrent_programs_vl pgm
315: where pgm.USER_CONCURRENT_PROGRAM_NAME IN ( 'Master Program -- Receivables Bills Consolidation',
316: 'Receivables Bills Consolidation')
317: and req.concurrent_program_id = pgm.concurrent_program_id
360: where OBJECT_TYPE = 'XTRX_CONTRACT'
361: and org_id = l_org_id
362: and request_id in (
363: select req.request_id
364: from fnd_concurrent_requests req,
365: fnd_concurrent_programs_vl pgm
366: where pgm.USER_CONCURRENT_PROGRAM_NAME IN ( 'Master Program -- Receivables Invoice Transfer',
367: 'Receivables Invoice Transfer to AR')
368: and req.concurrent_program_id = pgm.concurrent_program_id
413: WHERE OBJECT_TYPE = 'PREP_CONTRACT'
414: AND org_id = l_org_id
415: AND request_id IN (
416: SELECT req.request_id
417: FROM fnd_concurrent_requests req,
418: fnd_concurrent_programs_vl pgm
419: WHERE pgm.USER_CONCURRENT_PROGRAM_NAME IN ( 'Master Program -- Prepare Receivables',
420: 'Prepare Receivables Bills')
421: AND req.concurrent_program_id = pgm.concurrent_program_id
470: where OBJECT_TYPE = 'CONTRACT'
471: and org_id = l_org_id
472: and request_id in (
473: select req.request_id
474: from fnd_concurrent_requests req,
475: fnd_concurrent_programs_vl pgm
476: where pgm.USER_CONCURRENT_PROGRAM_NAME IN ( 'Master Program -- Process Billable Streams',
477: 'Process Billable Streams')
478: and req.concurrent_program_id = pgm.concurrent_program_id
522: where OBJECT_TYPE = 'CUSTOMER'
523: and org_id = l_org_id
524: and request_id in (
525: select req.request_id
526: from fnd_concurrent_requests req,
527: fnd_concurrent_programs_vl pgm
528: where pgm.USER_CONCURRENT_PROGRAM_NAME IN ( 'Master Program -- Receivables Bills Consolidation',
529: 'Receivables Bills Consolidation')
530: and req.concurrent_program_id = pgm.concurrent_program_id
575: where OBJECT_TYPE = 'XTRX_CONTRACT'
576: and org_id = l_org_id
577: and request_id in (
578: select req.request_id
579: from fnd_concurrent_requests req,
580: fnd_concurrent_programs_vl pgm
581: where pgm.USER_CONCURRENT_PROGRAM_NAME IN ( 'Master Program -- Receivables Invoice Transfer',
582: 'Receivables Invoice Transfer to AR')
583: and req.concurrent_program_id = pgm.concurrent_program_id
633: WHERE OBJECT_TYPE = 'PREP_CONTRACT'
634: AND org_id = l_org_id
635: AND request_id IN (
636: SELECT req.request_id
637: FROM fnd_concurrent_requests req,
638: fnd_concurrent_programs_vl pgm
639: WHERE pgm.USER_CONCURRENT_PROGRAM_NAME IN ( 'Master Program -- Prepare Receivables',
640: 'Prepare Receivables Bills')
641: AND req.concurrent_program_id = pgm.concurrent_program_id
1162: --
1163: cursor parent_sts_csr(p_request_id NUMBER) IS
1164: --start modified abhsaxen for performance SQLID 20562749
1165: select count(*)
1166: from fnd_concurrent_requests req,
1167: fnd_concurrent_programs pgm
1168: where req.PRIORITY_REQUEST_ID = p_request_id
1169: and req.concurrent_program_id = pgm.concurrent_program_id
1170: and req.PHASE_CODE = 'C'
1179: -- Start Bug 4581177;
1180: cursor parent_warn_sts_csr(p_request_id NUMBER) IS
1181: --start modified abhsaxen for performance SQLID 20562754
1182: select count(*)
1183: from fnd_concurrent_requests req,
1184: fnd_concurrent_programs pgm
1185: where req.priority_request_id = p_request_id
1186: and req.concurrent_program_id = pgm.concurrent_program_id
1187: and req.phase_code = 'C'