APPS.CSM_RESOURCE_EXTNS_EVENT_PKG dependencies on CSM_RS_RESOURCE_EXTNS_ACC

Line 5: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_RS_RESOURCE_EXTNS_ACC';

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');
9: g_pk1_name1 CONSTANT VARCHAR2(30) := 'RESOURCE_ID';

Line 6: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_RS_RESOURCE_EXTNS_ACC_S';

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');
9: g_pk1_name1 CONSTANT VARCHAR2(30) := 'RESOURCE_ID';
10:

Line 89: FROM CSM_RS_RESOURCE_EXTNS_ACC

85: WHERE useR_id=b_user_id;
86:
87: Cursor c_delete(b_resource_id NUMBER) IS
88: SELECT user_id
89: FROM CSM_RS_RESOURCE_EXTNS_ACC
90: WHERE resource_id=b_resource_id;
91:
92: l_sqlerrno VARCHAR2(20);
93: l_sqlerrmsg VARCHAR2(4000);

Line 113: DELETE FROM CSM_RS_RESOURCE_EXTNS_ACC WHERE resource_id=l_resource_id;

109: RESOURCE_EXTNS_ACC_D(l_resource_id,rec.user_id);
110: END LOOP;
111:
112: --to remove old bad data from access table
113: DELETE FROM CSM_RS_RESOURCE_EXTNS_ACC WHERE resource_id=l_resource_id;
114:
115: CSM_UTIL_PKG.LOG('Leaving RESOURCE_EXTNS_ACC_CLEANUP for resource_id: ' || p_user_id,
116: 'CSM_RESOURCE_EXTNS_EVENT_PKG.RESOURCE_EXTNS_ACC_CLEANUP',FND_LOG.LEVEL_PROCEDURE);
117: EXCEPTION

Line 154: FROM CSM_RS_RESOURCE_EXTNS_ACC ACC

150: IS
151:
152: CURSOR c_delete_prof0(p_resource_id NUMBER,p_user_id NUMBER) IS
153: SELECT resource_id
154: FROM CSM_RS_RESOURCE_EXTNS_ACC ACC
155: WHERE user_id=p_user_id
156: AND resource_id <> p_resource_id
157: AND NOT EXISTS (SELECT 1
158: FROM ASG_USER AU,

Line 173: AND NOT EXISTS(SELECT 1 FROM CSM_RS_RESOURCE_EXTNS_ACC ACC

169: WHERE AU.enabled='Y'
170: AND AU.user_name=AUPR.user_name
171: AND AUPR.pub_name='SERVICEP'
172: AND AU.user_id <> p_user_id
173: AND NOT EXISTS(SELECT 1 FROM CSM_RS_RESOURCE_EXTNS_ACC ACC
174: WHERE ACC.USER_ID=p_user_ID
175: AND ACC.RESOURCE_ID=AU.RESOURCE_ID);
176:
177: --12.1

Line 193: AND NOT EXISTS(SELECT 1 FROM CSM_RS_RESOURCE_EXTNS_ACC ACC

189: AND jtf_rs.resource_id <> p_resource_id
190: AND sysdate BETWEEN jtf_rs.start_date_active AND NVL(jtf_rs.end_date_active,sysdate)
191: AND jtf_rs.USER_ID IS NOT NULL
192: AND jtf_rs.USER_NAME IS NOT NULL
193: AND NOT EXISTS(SELECT 1 FROM CSM_RS_RESOURCE_EXTNS_ACC ACC
194: WHERE USER_ID=p_user_ID
195: AND ACC.RESOURCE_ID=jtf_rs.resource_id);
196:
197: --12.1

Line 200: FROM CSM_RS_RESOURCE_EXTNS_ACC ACC

196:
197: --12.1
198: CURSOR c_delete_prof2(p_resource_id NUMBER,p_user_id NUMBER) IS --delete prof2
199: SELECT resource_id
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