APPS.CSM_MESSAGES_EVENT_PKG dependencies on CSM_UTIL_PKG

Line 18: l_updates_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;

14: PROCEDURE Refresh_Acc (p_status OUT NOCOPY VARCHAR2,
15: p_message OUT NOCOPY VARCHAR2)
16: IS
17: PRAGMA AUTONOMOUS_TRANSACTION;
18: l_updates_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;
19: l_inserts_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;
20: l_dsql varchar2(2048);
21: l_pub_item varchar2(30) := 'CSF_M_MESSAGES';
22: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;

Line 19: l_inserts_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;

15: p_message OUT NOCOPY VARCHAR2)
16: IS
17: PRAGMA AUTONOMOUS_TRANSACTION;
18: l_updates_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;
19: l_inserts_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;
20: l_dsql varchar2(2048);
21: l_pub_item varchar2(30) := 'CSF_M_MESSAGES';
22: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
23: l_access_id jtm_fnd_lookups_acc.access_id%TYPE;

Line 103: l_tl_omfs_palm_resource_list := csm_util_pkg.get_tl_omfs_palm_resources(r_messages_del_rec.language_code);

99: FOR r_messages_del_rec IN l_messages_del_csr LOOP
100:
101: --get the users with this language
102: l_tl_omfs_palm_resource_list := l_null_resource_list;
103: l_tl_omfs_palm_resource_list := csm_util_pkg.get_tl_omfs_palm_resources(r_messages_del_rec.language_code);
104:
105: l_access_id := r_messages_del_rec.access_id;
106:
107: --nullify the access list

Line 115: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource('CSF_M_MESSAGES',

111: END LOOP;
112:
113: --mark dirty the SDQ for all users
114: IF l_single_access_id_list.count > 0 THEN
115: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource('CSF_M_MESSAGES',
116: l_single_access_id_list, l_tl_omfs_palm_resource_list,
117: ASG_DOWNLOAD.DEL, sysdate);
118: END IF;
119:

Line 129: l_tl_omfs_palm_resource_list := csm_util_pkg.get_tl_omfs_palm_resources(r_messages_upd_rec.language_code);

125: FOR r_messages_upd_rec IN l_messages_upd_csr(l_prog_update_date) LOOP
126:
127: --get the users with this language
128: l_tl_omfs_palm_resource_list := l_null_resource_list;
129: l_tl_omfs_palm_resource_list := csm_util_pkg.get_tl_omfs_palm_resources(r_messages_upd_rec.language_code);
130:
131: l_access_id := r_messages_upd_rec.access_id;
132:
133: --nullify the access list

Line 141: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource('CSF_M_MESSAGES',

137: END LOOP;
138:
139: --mark dirty the SDQ for all users
140: IF l_single_access_id_list.count > 0 THEN
141: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource('CSF_M_MESSAGES',
142: l_single_access_id_list, l_tl_omfs_palm_resource_list,
143: ASG_DOWNLOAD.UPD, sysdate);
144: END IF;
145:

Line 153: l_tl_omfs_palm_resource_list := csm_util_pkg.get_tl_omfs_palm_resources(r_messages_ins_rec.language_code);

149: FOR r_messages_ins_rec IN l_messages_ins_csr(l_prog_update_date) LOOP
150:
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;

Line 167: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource('CSF_M_MESSAGES',

163: END LOOP;
164:
165: --mark dirty the SDQ for all users
166: IF l_single_access_id_list.count > 0 THEN
167: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource('CSF_M_MESSAGES',
168: l_single_access_id_list, l_tl_omfs_palm_resource_list,
169: ASG_DOWNLOAD.INS, sysdate);
170: END IF;
171: