DBA Data[Home] [Help]

APPS.CSM_CTR_PROP_READ_EVENT_PKG dependencies on ASG_DOWNLOAD

Line 202: l_access_list asg_download.access_list;

198: l_sqlerrno VARCHAR2(20);
199: l_sqlerrmsg varchar2(2000);
200: l_mark_dirty boolean;
201: l_pub_item varchar2(30) := 'CSM_COUNTER_PROP_VALUES';
202: l_access_list asg_download.access_list;
203: l_user_list asg_download.user_list;
204: l_all_omfs_resource_list asg_download.user_list;
205: l_null_omfs_resource_list asg_download.user_list;
206: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;

Line 203: l_user_list asg_download.user_list;

199: l_sqlerrmsg varchar2(2000);
200: l_mark_dirty boolean;
201: l_pub_item varchar2(30) := 'CSM_COUNTER_PROP_VALUES';
202: l_access_list asg_download.access_list;
203: l_user_list asg_download.user_list;
204: l_all_omfs_resource_list asg_download.user_list;
205: l_null_omfs_resource_list asg_download.user_list;
206: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
207: l_counter_prop_value_id_tbl counter_prop_val_tbl_typ;

Line 204: l_all_omfs_resource_list asg_download.user_list;

200: l_mark_dirty boolean;
201: l_pub_item varchar2(30) := 'CSM_COUNTER_PROP_VALUES';
202: l_access_list asg_download.access_list;
203: l_user_list asg_download.user_list;
204: l_all_omfs_resource_list asg_download.user_list;
205: l_null_omfs_resource_list asg_download.user_list;
206: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
207: l_counter_prop_value_id_tbl counter_prop_val_tbl_typ;
208:

Line 205: l_null_omfs_resource_list asg_download.user_list;

201: l_pub_item varchar2(30) := 'CSM_COUNTER_PROP_VALUES';
202: l_access_list asg_download.access_list;
203: l_user_list asg_download.user_list;
204: l_all_omfs_resource_list asg_download.user_list;
205: l_null_omfs_resource_list asg_download.user_list;
206: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
207: l_counter_prop_value_id_tbl counter_prop_val_tbl_typ;
208:
209: --Cursor Declarations

Line 280: asg_download.del,

276: FOR i IN 1..l_access_list.count LOOP
277: l_mark_dirty := csm_util_pkg.MakeDirtyForUser(l_pub_item,
278: l_access_list(i),
279: l_user_list(i),
280: asg_download.del,
281: sysdate);
282:
283: END LOOP;
284:

Line 305: asg_download.ins,

301: FOR i IN 1..l_access_list.count LOOP
302: l_mark_dirty := csm_util_pkg.MakeDirtyForUser(l_pub_item,
303: l_access_list(i),
304: l_user_list(i),
305: asg_download.ins,
306: sysdate);
307:
308: END LOOP;
309: