APPS.CSM_MESSAGES_EVENT_PKG dependencies on CSM_MESSAGES_ACC

Line 52: FROM csm_messages_acc acc

48: AND msg.message_name like 'CSF_M_%')
49: OR msg.application_id = 883) -- CSM application
50: AND NOT EXISTS
51: (SELECT 1
52: FROM csm_messages_acc acc
53: WHERE acc.application_id = msg.application_id
54: AND acc.message_name = msg.message_name
55: AND acc.language_code = msg.language_code
56: );

Line 63: csm_messages_acc acc

59: CURSOR l_messages_upd_csr(p_last_upd_date date)
60: IS
61: SELECT acc.access_id, msg.application_id, msg.message_name, msg.language_code
62: FROM fnd_new_messages msg,
63: csm_messages_acc acc
64: WHERE (msg.creation_date < p_last_upd_date AND msg.last_update_date > p_last_upd_date)
65:
66: AND ((msg.application_id = 513 -- CSF application
67: AND msg.message_name like 'CSF_M_%')

Line 77: FROM csm_messages_acc acc

73: -- deletes cur
74: CURSOR l_messages_del_csr
75: IS
76: SELECT acc.access_id, acc.language_code
77: FROM csm_messages_acc acc
78: WHERE NOT EXISTS
79: (SELECT 1
80: FROM fnd_new_messages msg
81: WHERE ((msg.application_id = 513 -- CSF application

Line 121: DELETE FROM csm_messages_acc WHERE access_id = l_access_id;

117: ASG_DOWNLOAD.DEL, sysdate);
118: END IF;
119:
120: -- delete from acc table
121: DELETE FROM csm_messages_acc WHERE access_id = l_access_id;
122: END LOOP;
123:
124: -- process all updates
125: FOR r_messages_upd_rec IN l_messages_upd_csr(l_prog_update_date) LOOP

Line 155: SELECT csm_messages_acc_s.nextval

151: --get the users with this language
152: l_tl_omfs_palm_resource_list := l_null_resource_list;
153: l_tl_omfs_palm_resource_list := csm_util_pkg.get_tl_omfs_palm_resources(r_messages_ins_rec.language_code);
154:
155: SELECT csm_messages_acc_s.nextval
156: INTO l_access_id
157: FROM dual;
158:
159: --nullify the access list

Line 172: INSERT INTO csm_messages_acc (access_id,

168: l_single_access_id_list, l_tl_omfs_palm_resource_list,
169: ASG_DOWNLOAD.INS, sysdate);
170: END IF;
171:
172: INSERT INTO csm_messages_acc (access_id,
173: application_id,
174: message_name,
175: language_code,
176: created_by,