APPS.CSM_HA_EVENT_PKG dependencies on CSM_HA_RESP_MAPPINGS

Line 386: Activate all HA responsibilities mentioned in CSM_HA_RESP_MAPPINGS table

382: PROCEDURE ASSIGN_HA_RESPONSIBILITIES
383: IS
384: BEGIN
385: /*
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

Line 392: FROM CSM_HA_RESP_MAPPINGS)

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:
395: UPDATE FND_RESPONSIBILITY SET START_DATE=sysdate-1
396: WHERE (APPLICATION_ID,RESPONSIBILITY_ID) IN (SELECT HA_APPLICATION_ID,HA_RESPONSIBILITY_ID

Line 397: 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:
400:
401: /*

Line 406: CSM_HA_RESP_MAPPINGS mapp,

402: Assign HA responsibility to users mapped to corresponding non-HA responsibility
403: */
404: FOR rec IN (SELECT usr.USER_NAME,app.APPLICATION_SHORT_NAME app_name,mapp.HA_RESP_KEY resp_key
405: FROM FND_USER_RESP_GROUPS usr_rsp,
406: CSM_HA_RESP_MAPPINGS mapp,
407: FND_APPLICATION app,
408: FND_USER usr
409: WHERE SYSDATE BETWEEN nvl(usr_rsp.START_DATE,SYSDATE-1) AND nvl(usr_rsp.END_DATE,SYSDATE+1)
410: AND usr_rsp.USER_ID=usr.USER_ID

Line 430: FROM CSM_HA_RESP_MAPPINGS)

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);
433:
434: END DEACTIVATE_NON_HA_RESPS;