APPS.CSM_LOOKUP_EVENT_PKG dependencies on CSM_UTIL_PKG

Line 166: l_tl_omfs_palm_resource_list := csm_util_pkg.get_tl_omfs_palm_resources(r_lookups_del_rec.language);

162: FOR r_lookups_del_rec IN l_lookups_del_csr(l_prog_update_date) LOOP
163:
164: --get the users with this language
165: l_tl_omfs_palm_resource_list := l_null_resource_list;
166: l_tl_omfs_palm_resource_list := csm_util_pkg.get_tl_omfs_palm_resources(r_lookups_del_rec.language);
167:
168: l_access_id := r_lookups_del_rec.access_id;
169:
170: --nullify the access list

Line 178: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource('CSF_M_LOOKUPS',

174: END LOOP;
175:
176: --mark dirty the SDQ for all users
177: IF l_single_access_id_list.count > 0 THEN
178: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource('CSF_M_LOOKUPS',
179: l_single_access_id_list, l_tl_omfs_palm_resource_list,
180: ASG_DOWNLOAD.DEL, sysdate);
181: END IF;
182:

Line 192: l_tl_omfs_palm_resource_list := csm_util_pkg.get_tl_omfs_palm_resources(r_lookups_upd_rec.language);

188: FOR r_lookups_upd_rec IN l_lookups_upd_csr(l_prog_update_date) LOOP
189:
190: --get the users with this language
191: l_tl_omfs_palm_resource_list := l_null_resource_list;
192: l_tl_omfs_palm_resource_list := csm_util_pkg.get_tl_omfs_palm_resources(r_lookups_upd_rec.language);
193:
194: l_access_id := r_lookups_upd_rec.access_id;
195:
196: --nullify the access list

Line 204: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource('CSF_M_LOOKUPS',

200: END LOOP;
201:
202: --mark dirty the SDQ for all users
203: IF l_single_access_id_list.count > 0 then
204: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource('CSF_M_LOOKUPS',
205: l_single_access_id_list, l_tl_omfs_palm_resource_list,
206: ASG_DOWNLOAD.UPD, sysdate);
207: END IF;
208:

Line 216: l_tl_omfs_palm_resource_list := csm_util_pkg.get_tl_omfs_palm_resources(r_lookups_ins_rec.language);

212: FOR r_lookups_ins_rec IN l_lookups_ins_csr(l_prog_update_date) LOOP
213:
214: --get the users with this language
215: l_tl_omfs_palm_resource_list := l_null_resource_list;
216: l_tl_omfs_palm_resource_list := csm_util_pkg.get_tl_omfs_palm_resources(r_lookups_ins_rec.language);
217:
218: SELECT csm_lookups_acc_s.nextval
219: INTO l_access_id
220: FROM dual;

Line 230: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource('CSF_M_LOOKUPS',

226: END LOOP;
227:
228: --mark dirty the SDQ for all users
229: IF l_single_access_id_list.count > 0 THEN
230: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource('CSF_M_LOOKUPS',
231: l_single_access_id_list, l_tl_omfs_palm_resource_list,
232: ASG_DOWNLOAD.INS, sysdate);
233: END IF;
234: