APPS.CSM_MESSAGES_EVENT_PKG dependencies on ASG_DOWNLOAD

Line 25: l_tl_omfs_palm_resource_list asg_download.user_list;

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;
24: l_mark_dirty boolean;
25: l_tl_omfs_palm_resource_list asg_download.user_list;
26: l_null_resource_list asg_download.user_list;
27: l_single_access_id_list asg_download.access_list;
28: --a null list
29: l_null_access_list asg_download.access_list;

Line 26: l_null_resource_list asg_download.user_list;

22: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
23: l_access_id jtm_fnd_lookups_acc.access_id%TYPE;
24: l_mark_dirty boolean;
25: l_tl_omfs_palm_resource_list asg_download.user_list;
26: l_null_resource_list asg_download.user_list;
27: l_single_access_id_list asg_download.access_list;
28: --a null list
29: l_null_access_list asg_download.access_list;
30: l_run_date date;

Line 27: l_single_access_id_list asg_download.access_list;

23: l_access_id jtm_fnd_lookups_acc.access_id%TYPE;
24: l_mark_dirty boolean;
25: l_tl_omfs_palm_resource_list asg_download.user_list;
26: l_null_resource_list asg_download.user_list;
27: l_single_access_id_list asg_download.access_list;
28: --a null list
29: l_null_access_list asg_download.access_list;
30: l_run_date date;
31: l_sqlerrno varchar2(20);

Line 29: l_null_access_list asg_download.access_list;

25: l_tl_omfs_palm_resource_list asg_download.user_list;
26: l_null_resource_list asg_download.user_list;
27: l_single_access_id_list asg_download.access_list;
28: --a null list
29: l_null_access_list asg_download.access_list;
30: l_run_date date;
31: l_sqlerrno varchar2(20);
32: l_sqlerrmsg varchar2(2000);
33:

Line 117: ASG_DOWNLOAD.DEL, sysdate);

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:
120: -- delete from acc table
121: DELETE FROM csm_messages_acc WHERE access_id = l_access_id;

Line 143: ASG_DOWNLOAD.UPD, sysdate);

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:
146: END LOOP;
147:

Line 169: ASG_DOWNLOAD.INS, 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_MESSAGES',
168: l_single_access_id_list, l_tl_omfs_palm_resource_list,
169: ASG_DOWNLOAD.INS, sysdate);
170: END IF;
171:
172: INSERT INTO csm_messages_acc (access_id,
173: application_id,