APPS.CSM_HA_EVENT_PKG dependencies on FND_PROGRAM

Line 458: FND_PROGRAM.enable_program(rec.CONCURRENT_PROGRAM_NAME,rec.APP_NAME,'N');

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');
459: END LOOP;
460: */
461:
462: --direct update

Line 471: IF NOT FND_PROGRAM.request_group_exists('CSM_HA_REQUEST_GROUP','CSM') THEN

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
471: IF NOT FND_PROGRAM.request_group_exists('CSM_HA_REQUEST_GROUP','CSM') THEN
472: FND_PROGRAM.request_group('CSM_HA_REQUEST_GROUP','CSM');
473: END IF;
474:
475: SELECT application_id,request_group_id INTO l_app_id,l_grp_id from fnd_request_groups

Line 472: FND_PROGRAM.request_group('CSM_HA_REQUEST_GROUP','CSM');

468:
469:
470: --create a resp group and assign all active concurrent programs to it
471: IF NOT FND_PROGRAM.request_group_exists('CSM_HA_REQUEST_GROUP','CSM') THEN
472: FND_PROGRAM.request_group('CSM_HA_REQUEST_GROUP','CSM');
473: END IF;
474:
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';

Line 488: FND_PROGRAM.add_to_group(rec.CONCURRENT_PROGRAM_NAME,rec.APP_NAME,'CSM_HA_REQUEST_GROUP','CSM');

484: AND REQUEST_UNIT_ID=a.CONCURRENT_PROGRAM_ID
485: AND APPLICATION_ID=l_app_id
486: AND REQUEST_GROUP_ID=l_grp_id))
487: LOOP
488: FND_PROGRAM.add_to_group(rec.CONCURRENT_PROGRAM_NAME,rec.APP_NAME,'CSM_HA_REQUEST_GROUP','CSM');
489: END LOOP;
490:
491: --assign this request grp to all active non-FND resps
492: UPDATE FND_RESPONSIBILITY SET GROUP_APPLICATION_ID=l_app_id, REQUEST_GROUP_ID=l_grp_id