APPS.CSM_MTL_TXN_REASONS_EVENT_PKG dependencies on ASG_DOWNLOAD

Line 15: g_all_palm_res_list asg_download.user_list;

11: -- Person Date Comments
12: -- --------- ------ ------------------------------------------
13: -- Enter procedure, function bodies as shown below
14:
15: g_all_palm_res_list asg_download.user_list;
16: g_pub_item varchar2(30) := 'CSM_MTL_TXN_REASONS';
17:
18: PROCEDURE Refresh_mtl_txn_reasons_acc(p_status OUT NOCOPY VARCHAR2,
19: p_message OUT NOCOPY VARCHAR2)

Line 23: l_null_resource_list asg_download.user_list;

19: p_message OUT NOCOPY VARCHAR2)
20: IS
21: PRAGMA AUTONOMOUS_TRANSACTION;
22:
23: l_null_resource_list asg_download.user_list;
24: l_single_access_id_list asg_download.access_list;
25: --a null list
26: l_null_access_list asg_download.access_list;
27: l_all_omfs_palm_resource_list asg_download.user_list;

Line 24: l_single_access_id_list asg_download.access_list;

20: IS
21: PRAGMA AUTONOMOUS_TRANSACTION;
22:
23: l_null_resource_list asg_download.user_list;
24: l_single_access_id_list asg_download.access_list;
25: --a null list
26: l_null_access_list asg_download.access_list;
27: l_all_omfs_palm_resource_list asg_download.user_list;
28: l_null_palm_omfs_resource_list asg_download.user_list;

Line 26: l_null_access_list asg_download.access_list;

22:
23: l_null_resource_list asg_download.user_list;
24: l_single_access_id_list asg_download.access_list;
25: --a null list
26: l_null_access_list asg_download.access_list;
27: l_all_omfs_palm_resource_list asg_download.user_list;
28: l_null_palm_omfs_resource_list asg_download.user_list;
29: l_run_date date;
30: l_sqlerrno VARCHAR2(20);

Line 27: l_all_omfs_palm_resource_list asg_download.user_list;

23: l_null_resource_list asg_download.user_list;
24: l_single_access_id_list asg_download.access_list;
25: --a null list
26: l_null_access_list asg_download.access_list;
27: l_all_omfs_palm_resource_list asg_download.user_list;
28: l_null_palm_omfs_resource_list asg_download.user_list;
29: l_run_date date;
30: l_sqlerrno VARCHAR2(20);
31: l_sqlerrmsg varchar2(2000);

Line 28: l_null_palm_omfs_resource_list asg_download.user_list;

24: l_single_access_id_list asg_download.access_list;
25: --a null list
26: l_null_access_list asg_download.access_list;
27: l_all_omfs_palm_resource_list asg_download.user_list;
28: l_null_palm_omfs_resource_list asg_download.user_list;
29: l_run_date date;
30: l_sqlerrno VARCHAR2(20);
31: l_sqlerrmsg varchar2(2000);
32: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;

Line 121: asg_download.del,

117: FOR j IN 1..l_all_omfs_palm_resource_list.count LOOP
118: l_mark_dirty := csm_util_pkg.MakeDirtyForResource(g_pub_item,
119: l_access_id_tbl(i),
120: l_all_omfs_palm_resource_list(j),
121: asg_download.del,
122: l_run_date);
123:
124: END LOOP;
125: END LOOP;

Line 147: asg_download.upd,

143: FOR j IN 1..l_all_omfs_palm_resource_list.count LOOP
144: l_mark_dirty := csm_util_pkg.MakeDirtyForResource(g_pub_item,
145: l_access_id_tbl(i),
146: l_all_omfs_palm_resource_list(j),
147: asg_download.upd,
148: l_run_date);
149:
150: END LOOP;
151: END LOOP;

Line 175: asg_download.ins,

171: FOR j IN 1..l_all_omfs_palm_resource_list.count LOOP
172: l_mark_dirty := csm_util_pkg.MakeDirtyForResource(g_pub_item,
173: l_access_id_tbl(i),
174: l_all_omfs_palm_resource_list(j),
175: asg_download.ins,
176: l_run_date);
177:
178: END LOOP;
179: END LOOP;