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 169: ASG_DOWNLOAD.DEL, sysdate);

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

Line 195: ASG_DOWNLOAD.UPD, sysdate);

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:
198: END LOOP;
199:

Line 221: ASG_DOWNLOAD.INS, sysdate);

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