DBA Data[Home] [Help]

APPS.CSM_TXN_BILL_TYPES_EVENT_PKG dependencies on CSM_BUS_PROCESS_TXNS_ACC

Line 6: Refreshes the CSM_BUS_PROCESS_TXNS_ACC table by comparing with the

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.
8: Refreshes for all the users
9: Also adds corresponding entries in to SDQ
10:

Line 26: l_access_id CSM_BUS_PROCESS_TXNS_ACC.ACCESS_ID%TYPE;

22: l_dsql varchar2(2048);
23: l_pub_item varchar2(30) := 'CSF_M_TXN_BILLING_TYPES';
24: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
25: l_mark_dirty boolean;
26: l_access_id CSM_BUS_PROCESS_TXNS_ACC.ACCESS_ID%TYPE;
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;