APPS.CSM_IB_TXN_SUB_TYPES_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: PROCEDURE Refresh_Acc (p_status OUT NOCOPY VARCHAR2,
17: p_message OUT NOCOPY VARCHAR2)
18: IS

Line 30: l_tl_omfs_palm_resource_list asg_download.user_list;

26: l_access_id CSM_IB_TXN_TYPES_ACC.ACCESS_ID%TYPE;
27: l_language cs_transaction_types_tl.language%TYPE;
28: l_sub_type_id csi_ib_txn_types.sub_type_id%TYPE;
29:
30: l_tl_omfs_palm_resource_list asg_download.user_list;
31: l_single_access_id_list asg_download.access_list;
32: --a null list
33: l_null_access_list asg_download.access_list;
34: l_null_resource_list asg_download.user_list;

Line 31: l_single_access_id_list asg_download.access_list;

27: l_language cs_transaction_types_tl.language%TYPE;
28: l_sub_type_id csi_ib_txn_types.sub_type_id%TYPE;
29:
30: l_tl_omfs_palm_resource_list asg_download.user_list;
31: l_single_access_id_list asg_download.access_list;
32: --a null list
33: l_null_access_list asg_download.access_list;
34: l_null_resource_list asg_download.user_list;
35: l_run_date DATE;

Line 33: l_null_access_list asg_download.access_list;

29:
30: l_tl_omfs_palm_resource_list asg_download.user_list;
31: l_single_access_id_list asg_download.access_list;
32: --a null list
33: l_null_access_list asg_download.access_list;
34: l_null_resource_list asg_download.user_list;
35: l_run_date DATE;
36: l_sqlerrno varchar2(20);
37: l_sqlerrmsg varchar2(2000);

Line 34: l_null_resource_list asg_download.user_list;

30: l_tl_omfs_palm_resource_list asg_download.user_list;
31: l_single_access_id_list asg_download.access_list;
32: --a null list
33: l_null_access_list asg_download.access_list;
34: l_null_resource_list asg_download.user_list;
35: l_run_date DATE;
36: l_sqlerrno varchar2(20);
37: l_sqlerrmsg varchar2(2000);
38:

Line 137: ASG_DOWNLOAD.DEL,

133: FOR i IN 1 .. g_all_palm_res_list.COUNT LOOP
134: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource(l_pub_item,
135: l_access_id,
136: g_all_palm_res_list(i),
137: ASG_DOWNLOAD.DEL,
138: SYSDATE);
139: END LOOP;
140:
141: --remove from ACC

Line 222: ASG_DOWNLOAD.UPD, sysdate);

218: --mark dirty the SDQ for all users
219: IF l_single_access_id_list.count > 0 then
220: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource(l_pub_item,
221: l_single_access_id_list, g_all_palm_res_list,
222: ASG_DOWNLOAD.UPD, sysdate);
223: END IF;
224:
225: --update ACC
226: UPDATE CSM_IB_TXN_TYPES_ACC

Line 304: ASG_DOWNLOAD.INS, sysdate);

300: --mark dirty the SDQ for all users
301: IF l_single_access_id_list.count > 0 then
302: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource(l_pub_item,
303: l_single_access_id_list, g_all_palm_res_list,
304: ASG_DOWNLOAD.INS, sysdate);
305: END IF;
306:
307: --insert into
308: --check if the record exists