APPS.CSM_TXN_BILL_TYPES_EVENT_PKG dependencies on ASG_DOWNLOAD

Line 3: g_all_palm_res_list asg_download.user_list;

1: PACKAGE BODY CSM_TXN_BILL_TYPES_EVENT_PKG AS
2: /* $Header: csmetbtb.pls 120.1 2005/07/25 00:26:50 trajasek noship $ */
3: g_all_palm_res_list asg_download.user_list;
4:
5: /**
6: Refreshes the CSM_BUS_PROCESS_TXNS_ACC table by comparing with the
7: backend table for deletes, updates and inserts.

Line 31: l_tl_omfs_palm_resource_list asg_download.user_list;

27: l_language cs_transaction_types_tl.language%TYPE;
28: l_business_process_id CS_BUS_PROCESS_TXNS.BUSINESS_PROCESS_ID%TYPE;
29: l_txn_billing_type_id cs_txn_billing_types.txn_billing_type_id%TYPE;
30: l_transaction_type_id cs_txn_billing_types.transaction_type_id%TYPE;
31: l_tl_omfs_palm_resource_list asg_download.user_list;
32: l_single_access_id_list asg_download.access_list;
33: --a null list
34: l_null_access_list asg_download.access_list;
35: l_null_resource_list asg_download.user_list;

Line 32: l_single_access_id_list asg_download.access_list;

28: l_business_process_id CS_BUS_PROCESS_TXNS.BUSINESS_PROCESS_ID%TYPE;
29: l_txn_billing_type_id cs_txn_billing_types.txn_billing_type_id%TYPE;
30: l_transaction_type_id cs_txn_billing_types.transaction_type_id%TYPE;
31: l_tl_omfs_palm_resource_list asg_download.user_list;
32: l_single_access_id_list asg_download.access_list;
33: --a null list
34: l_null_access_list asg_download.access_list;
35: l_null_resource_list asg_download.user_list;
36: l_run_date DATE;

Line 34: l_null_access_list asg_download.access_list;

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

Line 35: l_null_resource_list asg_download.user_list;

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

Line 115: ASG_DOWNLOAD.DEL,

111: FOR i IN 1 .. g_all_palm_res_list.COUNT LOOP
112: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource(l_pub_item,
113: l_access_id,
114: g_all_palm_res_list(i),
115: ASG_DOWNLOAD.DEL,
116: SYSDATE);
117: END LOOP;
118:
119: --remove from ACC

Line 177: ASG_DOWNLOAD.UPD, sysdate);

173: --mark dirty the SDQ for all users
174: IF l_single_access_id_list.count > 0 then
175: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource(l_pub_item,
176: l_single_access_id_list, l_tl_omfs_palm_resource_list,
177: ASG_DOWNLOAD.UPD, sysdate);
178: END IF;
179:
180: --update ACC
181: UPDATE csm_txn_billing_types_acc

Line 241: ASG_DOWNLOAD.INS, sysdate);

237: --mark dirty the SDQ for all users
238: IF l_single_access_id_list.count > 0 THEN
239: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForResource('CSF_M_TXN_BILLING_TYPES',
240: l_single_access_id_list, l_tl_omfs_palm_resource_list,
241: ASG_DOWNLOAD.INS, sysdate);
242: END IF;
243:
244: --insert into
245: --check if the record exists