APPS.CSM_LOOKUP_EVENT_PKG dependencies on ASG_DOWNLOAD

Line 14: g_all_palm_res_list asg_download.user_list;

10: -- Person Date Comments
11: -- --------- ------ ------------------------------------------
12: -- Enter procedure, function bodies as shown below
13:
14: g_all_palm_res_list asg_download.user_list;
15:
16: /**
17: Refreshes the CSM_LOOKUP_TYPES_ACC table, and marks dirty for users accordingly
18: -- MODIFICATION HISTORY

Line 35: l_tl_omfs_palm_resource_list asg_download.user_list;

31: l_run_date date;
32: l_sqlerrno VARCHAR2(20);
33: l_sqlerrmsg varchar2(2000);
34: l_pub_item varchar2(30) := 'CSF_M_LOOKUPS';
35: l_tl_omfs_palm_resource_list asg_download.user_list;
36: l_null_resource_list asg_download.user_list;
37: l_single_access_id_list asg_download.access_list;
38: --a null list
39: l_null_access_list asg_download.access_list;

Line 36: l_null_resource_list asg_download.user_list;

32: l_sqlerrno VARCHAR2(20);
33: l_sqlerrmsg varchar2(2000);
34: l_pub_item varchar2(30) := 'CSF_M_LOOKUPS';
35: l_tl_omfs_palm_resource_list asg_download.user_list;
36: l_null_resource_list asg_download.user_list;
37: l_single_access_id_list asg_download.access_list;
38: --a null list
39: l_null_access_list asg_download.access_list;
40:

Line 37: l_single_access_id_list asg_download.access_list;

33: l_sqlerrmsg varchar2(2000);
34: l_pub_item varchar2(30) := 'CSF_M_LOOKUPS';
35: l_tl_omfs_palm_resource_list asg_download.user_list;
36: l_null_resource_list asg_download.user_list;
37: l_single_access_id_list asg_download.access_list;
38: --a null list
39: l_null_access_list asg_download.access_list;
40:
41: CURSOR l_last_run_date_csr(p_pub_item IN varchar2)

Line 39: l_null_access_list asg_download.access_list;

35: l_tl_omfs_palm_resource_list asg_download.user_list;
36: l_null_resource_list asg_download.user_list;
37: l_single_access_id_list asg_download.access_list;
38: --a null list
39: l_null_access_list asg_download.access_list;
40:
41: CURSOR l_last_run_date_csr(p_pub_item IN varchar2)
42: IS
43: SELECT nvl(last_run_date, (sysdate - 365*50))

Line 180: ASG_DOWNLOAD.DEL, sysdate);

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:
183: -- delete from acc table
184: DELETE FROM csm_lookups_acc WHERE access_id = l_access_id;

Line 206: ASG_DOWNLOAD.UPD, sysdate);

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:
209: END LOOP;
210:

Line 232: ASG_DOWNLOAD.INS, sysdate);

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:
235: INSERT INTO csm_lookups_acc (access_id,
236: lookup_type,