APPS.CSM_SR_TYPE_MAP_EVENT_PKG dependencies on CSM_SR_TYPE_MAPPING_ACC

Line 40: SELECT CSM_SR_TYPE_MAPPING_ACC_S.nextval,

36: --Cursor Declarations
37: --Insert Cursor
38: CURSOR csr_sr_type_map_ins
39: IS
40: SELECT CSM_SR_TYPE_MAPPING_ACC_S.nextval,
41: usr.user_id,
42: b.incident_type_id,
43: b.responsibility_id
44: FROM CS_SR_TYPE_MAPPING b,

Line 51: FROM CSM_SR_TYPE_MAPPING_ACC acc

47: AND usr.user_id = usr.owner_id
48: AND NOT EXISTS
49: (
50: SELECT 1
51: FROM CSM_SR_TYPE_MAPPING_ACC acc
52: WHERE acc.incident_type_id = b.incident_type_id
53: AND acc.responsibility_id = b.responsibility_id
54: AND acc.user_id = usr.user_id
55: );

Line 60: FROM CSM_SR_TYPE_MAPPING_ACC acc,

56: --update cursor
57: CURSOR csr_sr_type_map_upd(p_lastrundate IN date)
58: IS
59: SELECT access_id,user_id
60: FROM CSM_SR_TYPE_MAPPING_ACC acc,
61: CS_SR_TYPE_MAPPING b
62: WHERE acc.incident_type_id = b.incident_type_id
63: AND acc.responsibility_id = b.responsibility_id
64: AND b.last_update_Date >= p_lastrundate;

Line 70: FROM CSM_SR_TYPE_MAPPING_ACC acc

66: --Delete cursor
67: CURSOR csr_sr_type_map_del
68: IS
69: SELECT access_id,user_id
70: FROM CSM_SR_TYPE_MAPPING_ACC acc
71: WHERE NOT EXISTS
72: (SELECT 1
73: FROM CS_SR_TYPE_MAPPING b
74: WHERE b.incident_type_id = acc.incident_type_id

Line 122: DELETE FROM CSM_SR_TYPE_MAPPING_ACC WHERE access_id = l_map_access_list(i) AND user_id = l_user_list(i) ;

118: END LOOP;
119:
120: -- bulk delete from acc table
121: FORALL i IN 1..l_map_access_list.count
122: DELETE FROM CSM_SR_TYPE_MAPPING_ACC WHERE access_id = l_map_access_list(i) AND user_id = l_user_list(i) ;
123:
124: l_map_access_list.delete;
125: l_user_list.delete;
126: END IF; -- end of process deletes

Line 176: INSERT INTO CSM_SR_TYPE_MAPPING_ACC

172:
173: END LOOP;
174:
175: FORALL i IN 1..l_map_access_list.count
176: INSERT INTO CSM_SR_TYPE_MAPPING_ACC
177: (access_id,
178: user_id,
179: incident_type_id,
180: responsibility_id,