APPS.CSM_HA_EVENT_PKG dependencies on CSM_HA_ACTIVE_CONC_DATA

Line 446: (SELECT APPLICATION_ID,CONCURRENT_PROGRAM_ID FROM CSM_HA_ACTIVE_CONC_DATA);

442: /*following SQL used only while development as new HA conc progs can be added*/
443: --------------------------------------------------------
444: UPDATE FND_CONCURRENT_PROGRAMS SET ENABLED_FLAG='Y'
445: WHERE (APPLICATION_ID,CONCURRENT_PROGRAM_ID) IN
446: (SELECT APPLICATION_ID,CONCURRENT_PROGRAM_ID FROM CSM_HA_ACTIVE_CONC_DATA);
447: ------------------------------------------------------
448:
449: /*
450: --Choose: Api call or the below direct update

Line 454: (SELECT APPLICATION_ID,CONCURRENT_PROGRAM_ID FROM CSM_HA_ACTIVE_CONC_DATA)

450: --Choose: Api call or the below direct update
451: FOR rec in (SELECT B.APPLICATION_SHORT_NAME APP_NAME, CONCURRENT_PROGRAM_NAME
452: FROM FND_CONCURRENT_PROGRAMS a, FND_APPLICATION b
453: WHERE (APPLICATION_ID,CONCURRENT_PROGRAM_ID) NOT IN
454: (SELECT APPLICATION_ID,CONCURRENT_PROGRAM_ID FROM CSM_HA_ACTIVE_CONC_DATA)
455: AND APPLICATION_ID NOT IN (0,1) -- non AOL
456: AND a.APPLICATION_ID = b.APPLICATION_ID)
457: LOOP
458: FND_PROGRAM.enable_program(rec.CONCURRENT_PROGRAM_NAME,rec.APP_NAME,'N');

Line 466: (SELECT APPLICATION_ID,CONCURRENT_PROGRAM_ID FROM CSM_HA_ACTIVE_CONC_DATA)

462: --direct update
463:
464: UPDATE FND_CONCURRENT_PROGRAMS SET ENABLED_FLAG='N'
465: WHERE (APPLICATION_ID,CONCURRENT_PROGRAM_ID) NOT IN
466: (SELECT APPLICATION_ID,CONCURRENT_PROGRAM_ID FROM CSM_HA_ACTIVE_CONC_DATA)
467: AND APPLICATION_ID NOT IN (0,1); -- non AOL
468:
469:
470: --create a resp group and assign all active concurrent programs to it

Line 479: FROM CSM_HA_ACTIVE_CONC_DATA a, FND_APPLICATION b

475: SELECT application_id,request_group_id INTO l_app_id,l_grp_id from fnd_request_groups
476: where request_group_name='CSM_HA_REQUEST_GROUP';
477:
478: FOR rec in (SELECT B.APPLICATION_SHORT_NAME APP_NAME, CONCURRENT_PROGRAM_NAME
479: FROM CSM_HA_ACTIVE_CONC_DATA a, FND_APPLICATION b
480: WHERE a.APPLICATION_ID = b.APPLICATION_ID
481: AND a.APPLICATION_ID NOT IN (0,1)
482: AND NOT EXISTS (SELECT 1 FROM FND_REQUEST_GROUP_UNITS
483: WHERE UNIT_APPLICATION_ID=a.APPLICATION_ID