APPS.CSM_HA_EVENT_PKG dependencies on FND_CONCURRENT_PROGRAMS

Line 444: UPDATE FND_CONCURRENT_PROGRAMS SET ENABLED_FLAG='Y'

440: BEGIN
441:
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:

Line 452: FROM FND_CONCURRENT_PROGRAMS a, FND_APPLICATION b

448:
449: /*
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)

Line 464: UPDATE FND_CONCURRENT_PROGRAMS SET ENABLED_FLAG='N'

460: */
461:
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: