DBA Data[Home] [Help]

APPS.CSM_CUSTOMER_ACCOUNT_EVENT_PKG dependencies on CSM_ACC_PKG

Line 8: g_accnt_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=

4: g_cst_accnt_table_name CONSTANT VARCHAR2(30) := 'HZ_CUST_ACCOUNTS';
5: g_cst_accnt_seq_name CONSTANT VARCHAR2(30) := 'CSM_HZ_CUST_ACCOUNTS_ACC_S' ;
6: g_cst_accnt_pk1_name CONSTANT VARCHAR2(30) := 'CUST_ACCOUNT_ID';
7: g_pub_item CONSTANT VARCHAR2(30) := 'CSM_HZ_CUST_ACCOUNTS';
8: g_accnt_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
9: CSM_ACC_PKG.t_publication_item_list('CSM_HZ_CUST_ACCOUNTS');
10:
11:
12: TYPE l_num_tab_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 9: CSM_ACC_PKG.t_publication_item_list('CSM_HZ_CUST_ACCOUNTS');

5: g_cst_accnt_seq_name CONSTANT VARCHAR2(30) := 'CSM_HZ_CUST_ACCOUNTS_ACC_S' ;
6: g_cst_accnt_pk1_name CONSTANT VARCHAR2(30) := 'CUST_ACCOUNT_ID';
7: g_pub_item CONSTANT VARCHAR2(30) := 'CSM_HZ_CUST_ACCOUNTS';
8: g_accnt_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
9: CSM_ACC_PKG.t_publication_item_list('CSM_HZ_CUST_ACCOUNTS');
10:
11:
12: TYPE l_num_tab_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
13:

Line 206: CSM_ACC_PKG.Insert_Acc

202:
203:
204: FOR l_cust_accnt_rec IN c_cust_accnt_ins(p_party_id,p_user_id)
205: LOOP
206: CSM_ACC_PKG.Insert_Acc
207: (P_PUBLICATION_ITEM_NAMES => g_accnt_pubi_name
208: ,P_ACC_TABLE_NAME => g_cst_accnt_acc_table_name
209: ,P_SEQ_NAME => g_cst_accnt_seq_name
210: ,P_PK1_NAME => g_cst_accnt_pk1_name

Line 353: CSM_ACC_PKG.Delete_Acc

349: --take all teh cust_account_id for the party which doesnot exists for the user_id
350: FOR l_cust_accnt_rec IN c_cust_accnt_del(p_party_id,p_user_id)
351: LOOP
352: l_access_id := l_cust_accnt_rec.access_id;
353: CSM_ACC_PKG.Delete_Acc
354: (P_PUBLICATION_ITEM_NAMES => g_accnt_pubi_name
355: ,P_ACC_TABLE_NAME => g_cst_accnt_acc_table_name
356: ,P_PK1_NAME => g_cst_accnt_pk1_name
357: ,P_PK1_NUM_VALUE => l_cust_accnt_rec.CUST_ACCOUNT_ID