APPS.CSM_HA_EVENT_PKG dependencies on FND_RESPONSIBILITY

Line 390: UPDATE FND_RESPONSIBILITY SET END_DATE=null

386: Activate all HA responsibilities mentioned in CSM_HA_RESP_MAPPINGS table
387: -> remove the end-date if present
388: -> reset future start_dates back to sysdate-1
389: */
390: UPDATE FND_RESPONSIBILITY SET END_DATE=null
391: WHERE (APPLICATION_ID,RESPONSIBILITY_ID) IN (SELECT HA_APPLICATION_ID,HA_RESPONSIBILITY_ID
392: FROM CSM_HA_RESP_MAPPINGS)
393: AND END_DATE IS NOT NULL;
394:

Line 395: UPDATE FND_RESPONSIBILITY SET START_DATE=sysdate-1

391: WHERE (APPLICATION_ID,RESPONSIBILITY_ID) IN (SELECT HA_APPLICATION_ID,HA_RESPONSIBILITY_ID
392: FROM CSM_HA_RESP_MAPPINGS)
393: AND END_DATE IS NOT NULL;
394:
395: UPDATE FND_RESPONSIBILITY SET START_DATE=sysdate-1
396: WHERE (APPLICATION_ID,RESPONSIBILITY_ID) IN (SELECT HA_APPLICATION_ID,HA_RESPONSIBILITY_ID
397: FROM CSM_HA_RESP_MAPPINGS)
398: AND NVL(START_DATE,SYSDATE-1) > SYSDATE;
399:

Line 428: UPDATE FND_RESPONSIBILITY SET END_DATE=SYSDATE-1

424: PROCEDURE DEACTIVATE_NON_HA_RESPS
425: IS
426: BEGIN
427:
428: UPDATE FND_RESPONSIBILITY SET END_DATE=SYSDATE-1
429: WHERE (APPLICATION_ID,RESPONSIBILITY_ID) NOT IN (SELECT HA_APPLICATION_ID,HA_RESPONSIBILITY_ID
430: FROM CSM_HA_RESP_MAPPINGS)
431: AND NVL(END_DATE, SYSDATE+1) > SYSDATE-1
432: AND APPLICATION_ID not in (0,1);

Line 492: UPDATE FND_RESPONSIBILITY SET GROUP_APPLICATION_ID=l_app_id, REQUEST_GROUP_ID=l_grp_id

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
493: WHERE APPLICATION_ID NOT IN (0,1)
494: AND SYSDATE BETWEEN nvl(START_DATE,SYSDATE-1) AND nvl(END_DATE,SYSDATE+1)
495: AND REQUEST_GROUP_ID<>l_grp_id;
496: