DBA Data[Home] [Help]

APPS.CSM_COUNTER_READING_EVENT_PKG dependencies on ASG_DOWNLOAD

Line 28: l_access_list asg_download.access_list;

24: l_sqlerrno VARCHAR2(20);
25: l_sqlerrmsg varchar2(2000);
26: l_mark_dirty boolean;
27: l_pub_item varchar2(30) := 'CSF_M_COUNTER_VALUES';
28: l_access_list asg_download.access_list;
29: l_user_list asg_download.user_list;
30: l_all_omfs_resource_list asg_download.user_list;
31: l_null_omfs_resource_list asg_download.user_list;
32: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;

Line 29: l_user_list asg_download.user_list;

25: l_sqlerrmsg varchar2(2000);
26: l_mark_dirty boolean;
27: l_pub_item varchar2(30) := 'CSF_M_COUNTER_VALUES';
28: l_access_list asg_download.access_list;
29: l_user_list asg_download.user_list;
30: l_all_omfs_resource_list asg_download.user_list;
31: l_null_omfs_resource_list asg_download.user_list;
32: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
33: l_counter_value_id_tbl counter_value_tbl_typ;

Line 30: l_all_omfs_resource_list asg_download.user_list;

26: l_mark_dirty boolean;
27: l_pub_item varchar2(30) := 'CSF_M_COUNTER_VALUES';
28: l_access_list asg_download.access_list;
29: l_user_list asg_download.user_list;
30: l_all_omfs_resource_list asg_download.user_list;
31: l_null_omfs_resource_list asg_download.user_list;
32: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
33: l_counter_value_id_tbl counter_value_tbl_typ;
34: l_counter_id_tbl counter_tbl_typ;

Line 31: l_null_omfs_resource_list asg_download.user_list;

27: l_pub_item varchar2(30) := 'CSF_M_COUNTER_VALUES';
28: l_access_list asg_download.access_list;
29: l_user_list asg_download.user_list;
30: l_all_omfs_resource_list asg_download.user_list;
31: l_null_omfs_resource_list asg_download.user_list;
32: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
33: l_counter_value_id_tbl counter_value_tbl_typ;
34: l_counter_id_tbl counter_tbl_typ;
35:

Line 115: asg_download.del,

111: FOR i IN 1..l_access_list.count LOOP
112: l_mark_dirty := csm_util_pkg.MakeDirtyForUser(l_pub_item,
113: l_access_list(i),
114: l_user_list(i),
115: asg_download.del,
116: sysdate);
117:
118: END LOOP;
119:

Line 140: asg_download.upd,

136: FOR i IN 1..l_access_list.count LOOP
137: l_mark_dirty := csm_util_pkg.MakeDirtyForUser(l_pub_item,
138: l_access_list(i),
139: l_user_list(i),
140: asg_download.upd,
141: sysdate);
142:
143: END LOOP;
144:

Line 176: asg_download.ins,

172: FOR i IN 1..l_access_list.count LOOP
173: l_mark_dirty := csm_util_pkg.MakeDirtyForUser(l_pub_item,
174: l_access_list(i),
175: l_user_list(i),
176: asg_download.ins,
177: sysdate);
178:
179: END LOOP;
180:

Line 250: l_access_list asg_download.access_list;

246: l_sqlerrno VARCHAR2(20);
247: l_sqlerrmsg varchar2(2000);
248: l_mark_dirty boolean;
249: l_pub_item varchar2(30) := 'CSF_M_COUNTER_VALUES';
250: l_access_list asg_download.access_list;
251: l_user_list asg_download.user_list;
252: l_counter_value_id_tbl counter_value_tbl_typ;
253: l_counter_id_tbl counter_tbl_typ;
254:

Line 251: l_user_list asg_download.user_list;

247: l_sqlerrmsg varchar2(2000);
248: l_mark_dirty boolean;
249: l_pub_item varchar2(30) := 'CSF_M_COUNTER_VALUES';
250: l_access_list asg_download.access_list;
251: l_user_list asg_download.user_list;
252: l_counter_value_id_tbl counter_value_tbl_typ;
253: l_counter_id_tbl counter_tbl_typ;
254:
255: --Cursor Declarations

Line 298: asg_download.ins,

294: FOR i IN 1..l_access_list.count LOOP
295: l_mark_dirty := csm_util_pkg.MakeDirtyForUser(l_pub_item,
296: l_access_list(i),
297: l_user_list(i),
298: asg_download.ins,
299: sysdate);
300:
301: END LOOP;
302:

Line 365: l_access_list asg_download.access_list;

361: l_sqlerrno VARCHAR2(20);
362: l_sqlerrmsg varchar2(2000);
363: l_mark_dirty boolean;
364: l_pub_item varchar2(30) := 'CSF_M_COUNTER_VALUES';
365: l_access_list asg_download.access_list;
366: l_user_list asg_download.user_list;
367:
368: --Cursor Declarations
369: --Update Cursor

Line 366: l_user_list asg_download.user_list;

362: l_sqlerrmsg varchar2(2000);
363: l_mark_dirty boolean;
364: l_pub_item varchar2(30) := 'CSF_M_COUNTER_VALUES';
365: l_access_list asg_download.access_list;
366: l_user_list asg_download.user_list;
367:
368: --Cursor Declarations
369: --Update Cursor
370: CURSOR csr_ctr_reading_upd(c_counter_value_id NUMBER)

Line 400: asg_download.ins,

396: FOR i IN 1..l_access_list.count LOOP
397: l_mark_dirty := csm_util_pkg.MakeDirtyForUser(l_pub_item,
398: l_access_list(i),
399: l_user_list(i),
400: asg_download.ins,
401: sysdate);
402:
403: END LOOP;
404: l_user_list.delete;