APPS.CSM_RESOURCE_EXTNS_EVENT_PKG dependencies on JTF_RS_RESOURCE_EXTNS

Line 4: g_table_name1 CONSTANT VARCHAR2(30) := 'JTF_RS_RESOURCE_EXTNS';

1: PACKAGE BODY CSM_RESOURCE_EXTNS_EVENT_PKG AS
2: /* $Header: csmeresb.pls 120.7 2008/02/07 10:39:55 anaraman ship $ */
3:
4: g_table_name1 CONSTANT VARCHAR2(30) := 'JTF_RS_RESOURCE_EXTNS';
5: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_RS_RESOURCE_EXTNS_ACC';
6: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_RS_RESOURCE_EXTNS_ACC_S';
7: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
8: CSM_ACC_PKG.t_publication_item_list('CSF_M_EMPLOYEES');

Line 182: jtf_rs_resource_extns jtf_rs

178: CURSOR c_grp_members(p_resource_id NUMBER, p_user_id NUMBER) IS --insert prof2
179: SELECT DISTINCT jtf_rs.user_id,
180: jtf_rs.resource_id
181: FROM jtf_rs_group_members jtf_rs_grp,
182: jtf_rs_resource_extns jtf_rs
183: WHERE EXISTS (SELECT 1
184: FROM jtf_rs_group_members
185: WHERE group_id = jtf_rs_grp.group_id
186: AND resource_id = p_resource_id

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 423: FROM JTF_RS_RESOURCE_EXTNS

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 );
427:

Line 429: CURSOR l_resource_csr(p_resource_id jtf_rs_resource_extns.resource_id%TYPE)

425: AND USER_NAME IS NOT NULL
426: AND USER_ID IS NOT NULL );
427:
428:
429: CURSOR l_resource_csr(p_resource_id jtf_rs_resource_extns.resource_id%TYPE)
430: IS
431: SELECT au.user_id
432: FROM asg_user au,
433: asg_user_pub_resps aupr

Line 503: FROM JTF_RS_RESOURCE_EXTNS

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);
507:

Line 509: CURSOR l_resource_csr(p_resource_id jtf_rs_resource_extns.resource_id%TYPE)

505: AND USER_NAME IS NOT NULL
506: AND USER_ID IS NOT NULL);
507:
508:
509: CURSOR l_resource_csr(p_resource_id jtf_rs_resource_extns.resource_id%TYPE)
510: IS
511: SELECT au.user_id
512: FROM asg_user au,
513: asg_user_pub_resps aupr