DBA Data[Home] [Help]

APPS.CSM_HA_EVENT_PKG dependencies on FND_USER

Line 405: FROM FND_USER_RESP_GROUPS usr_rsp,

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

Line 408: FND_USER usr

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
411: AND usr_rsp.RESPONSIBILITY_ID=mapp.RESPONSIBILITY_ID
412: AND usr_rsp.RESPONSIBILITY_APPLICATION_ID= mapp.APPLICATION_ID

Line 414: AND NOT EXISTS (SELECT 1 FROM FND_USER_RESP_GROUPS

410: AND usr_rsp.USER_ID=usr.USER_ID
411: AND usr_rsp.RESPONSIBILITY_ID=mapp.RESPONSIBILITY_ID
412: AND usr_rsp.RESPONSIBILITY_APPLICATION_ID= mapp.APPLICATION_ID
413: AND mapp.HA_APPLICATION_ID=app.APPLICATION_ID
414: AND NOT EXISTS (SELECT 1 FROM FND_USER_RESP_GROUPS
415: WHERE USER_ID=usr.USER_ID
416: AND RESPONSIBILITY_ID=mapp.HA_RESPONSIBILITY_ID
417: AND RESPONSIBILITY_APPLICATION_ID=mapp.HA_APPLICATION_ID))
418: LOOP

Line 419: FND_USER_PKG.ADDRESP(rec.USER_NAME,rec.APP_NAME,rec.RESP_KEY,'STANDARD',NULL,sysdate,null);

415: WHERE USER_ID=usr.USER_ID
416: AND RESPONSIBILITY_ID=mapp.HA_RESPONSIBILITY_ID
417: AND RESPONSIBILITY_APPLICATION_ID=mapp.HA_APPLICATION_ID))
418: LOOP
419: FND_USER_PKG.ADDRESP(rec.USER_NAME,rec.APP_NAME,rec.RESP_KEY,'STANDARD',NULL,sysdate,null);
420: END LOOP;
421:
422: END ASSIGN_HA_RESPONSIBILITIES;
423:

Line 1073: CSM_UTIL_PKG.LOG( 'Assigning HA Responsibilities to FND Users with non-HA responsibilities',

1069: l_module := 'Setting HA profile to Record';
1070: SET_HA_PROFILE('HA_RECORD');
1071:
1072: /* SetUp recording*/
1073: CSM_UTIL_PKG.LOG( 'Assigning HA Responsibilities to FND Users with non-HA responsibilities',
1074: 'CSM_HA_EVENT_PKG.BEGIN_HA_TRACKING', FND_LOG.LEVEL_PROCEDURE);
1075: l_module := 'Assigning HA Responsibilities';
1076:
1077: ASSIGN_HA_RESPONSIBILITIES;