APPS.CSM_LOOKUP_EVENT_PKG dependencies on CSM_UTIL_PKG

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

151: FOR r_lookups_del_rec IN l_lookups_del_csr(l_prog_update_date) LOOP
152:
153: --get the users with this language
154: l_tl_omfs_palm_resource_list := l_null_resource_list;
155: l_tl_omfs_palm_resource_list := csm_util_pkg.get_tl_omfs_palm_resources(r_lookups_del_rec.language);
156:
157: l_access_id := r_lookups_del_rec.access_id;
158:
159: --nullify the access list

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

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_LOOKUPS',
168: l_single_access_id_list, l_tl_omfs_palm_resource_list,
169: ASG_DOWNLOAD.DEL, sysdate);
170: END IF;
171:

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

177: FOR r_lookups_upd_rec IN l_lookups_upd_csr(l_prog_update_date) LOOP
178:
179: --get the users with this language
180: l_tl_omfs_palm_resource_list := l_null_resource_list;
181: l_tl_omfs_palm_resource_list := csm_util_pkg.get_tl_omfs_palm_resources(r_lookups_upd_rec.language);
182:
183: l_access_id := r_lookups_upd_rec.access_id;
184:
185: --nullify the access list

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

189: END LOOP;
190:
191: --mark dirty the SDQ for all users
192: IF l_single_access_id_list.count > 0 then
193: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource('CSF_M_LOOKUPS',
194: l_single_access_id_list, l_tl_omfs_palm_resource_list,
195: ASG_DOWNLOAD.UPD, sysdate);
196: END IF;
197:

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

201: FOR r_lookups_ins_rec IN l_lookups_ins_csr(l_prog_update_date) LOOP
202:
203: --get the users with this language
204: l_tl_omfs_palm_resource_list := l_null_resource_list;
205: l_tl_omfs_palm_resource_list := csm_util_pkg.get_tl_omfs_palm_resources(r_lookups_ins_rec.language);
206:
207: SELECT csm_lookups_acc_s.nextval
208: INTO l_access_id
209: FROM dual;

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

215: END LOOP;
216:
217: --mark dirty the SDQ for all users
218: IF l_single_access_id_list.count > 0 THEN
219: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource('CSF_M_LOOKUPS',
220: l_single_access_id_list, l_tl_omfs_palm_resource_list,
221: ASG_DOWNLOAD.INS, sysdate);
222: END IF;
223: