eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSM_RESOURCE_EXTNS_EVENT_PKG dependencies on FND_USER

Line 204: jtf_rs_resource_extns valid_fnd_user

200: FROM CSM_RS_RESOURCE_EXTNS_ACC ACC
201: WHERE acc.user_id=p_user_id
202: AND NOT EXISTS ( SELECT 1
203: FROM jtf_rs_group_members jtf_rs_grp,
204: jtf_rs_resource_extns valid_fnd_user
205: WHERE EXISTS (SELECT 1
206: FROM jtf_rs_group_members
207: WHERE group_id = jtf_rs_grp.group_id
208: AND resource_id = p_resource_id

Line 211: AND valid_fnd_user.resource_id=Acc.resource_id

207: WHERE group_id = jtf_rs_grp.group_id
208: AND resource_id = p_resource_id
209: AND delete_flag = 'N')
210: AND jtf_rs_grp.resource_id= Acc.resource_id
211: AND valid_fnd_user.resource_id=Acc.resource_id
212: AND valid_fnd_user.USER_ID IS NOT NULL
213: AND valid_fnd_user.USER_NAME IS NOT NULL);
214:
215: l_sqlerrno VARCHAR2(20);

Line 212: AND valid_fnd_user.USER_ID IS NOT NULL

208: AND resource_id = p_resource_id
209: AND delete_flag = 'N')
210: AND jtf_rs_grp.resource_id= Acc.resource_id
211: AND valid_fnd_user.resource_id=Acc.resource_id
212: AND valid_fnd_user.USER_ID IS NOT NULL
213: AND valid_fnd_user.USER_NAME IS NOT NULL);
214:
215: l_sqlerrno VARCHAR2(20);
216: l_sqlerrmsg VARCHAR2(4000);

Line 213: AND valid_fnd_user.USER_NAME IS NOT NULL);

209: AND delete_flag = 'N')
210: AND jtf_rs_grp.resource_id= Acc.resource_id
211: AND valid_fnd_user.resource_id=Acc.resource_id
212: AND valid_fnd_user.USER_ID IS NOT NULL
213: AND valid_fnd_user.USER_NAME IS NOT NULL);
214:
215: l_sqlerrno VARCHAR2(20);
216: l_sqlerrmsg VARCHAR2(4000);
217: l_error_msg VARCHAR2(4000);

Line 422: AND EXISTS (SELECT 1 --12.1 -SHD BE A VALID FND USER

418: AND au.enabled='Y'
419: AND au.USER_NAME=aupr.USER_NAME
420: AND aupr.PUB_NAME='SERVICEP'
421: AND grp.resource_id <> p_resource_id
422: AND EXISTS (SELECT 1 --12.1 -SHD BE A VALID FND USER
423: FROM JTF_RS_RESOURCE_EXTNS
424: WHERE RESOURCE_ID=p_resource_id
425: AND USER_NAME IS NOT NULL
426: AND USER_ID IS NOT NULL );

Line 444: l_user_id fnd_user.user_id%TYPE := NULL;

440: l_sqlerrmsg VARCHAR2(4000);
441: l_error_msg VARCHAR2(4000);
442: l_return_status VARCHAR2(2000);
443:
444: l_user_id fnd_user.user_id%TYPE := NULL;
445: BEGIN
446: CSM_UTIL_PKG.LOG('Entering RS_GROUP_MEMBERS_INS_INIT for resource_id: ' || to_char(p_resource_id) || ' and group_id: '
447: || TO_CHAR(p_group_id), 'CSM_RESOURCE_EXTNS_EVENT_PKG.RS_GROUP_MEMBERS_INS_INIT',FND_LOG.LEVEL_PROCEDURE);
448:

Line 502: AND EXISTS (SELECT 1 --12.1 -SHD BE A VALID FND USER

498: AND au.enabled='Y'
499: AND au.USER_NAME=aupr.USER_NAME
500: AND aupr.PUB_NAME='SERVICEP'
501: AND grp.resource_id <> p_resource_id
502: AND EXISTS (SELECT 1 --12.1 -SHD BE A VALID FND USER
503: FROM JTF_RS_RESOURCE_EXTNS
504: WHERE RESOURCE_ID=p_resource_id
505: AND USER_NAME IS NOT NULL
506: AND USER_ID IS NOT NULL);

Line 524: l_user_id fnd_user.user_id%TYPE := NULL;

520: l_sqlerrmsg VARCHAR2(4000);
521: l_error_msg VARCHAR2(4000);
522: l_return_status VARCHAR2(2000);
523:
524: l_user_id fnd_user.user_id%TYPE := NULL;
525:
526: BEGIN
527: CSM_UTIL_PKG.LOG('Entering RS_GROUP_MEMBERS_DEL_INIT for resource_id: ' || to_char(p_resource_id) || ' and group_id: '
528: || TO_CHAR(p_group_id), 'CSM_RESOURCE_EXTNS_EVENT_PKG.RS_GROUP_MEMBERS_DEL_INIT',FND_LOG.LEVEL_PROCEDURE);