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: --PROCEDURE IMPLEMENTATION DETAILS
12: --This procedure will insert account id into the access table only for the party

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: --PROCEDURE IMPLEMENTATION DETAILS
12: --This procedure will insert account id into the access table only for the party
13: --which is passed to this procedure and which is not already present in the CUST ACcount Access table

Line 45: CSM_ACC_PKG.Insert_Acc

41:
42: FOR l_cust_accnt_rec IN c_cust_accnt_ins(p_party_id,p_user_id)
43: LOOP
44:
45: CSM_ACC_PKG.Insert_Acc
46: (P_PUBLICATION_ITEM_NAMES => g_accnt_pubi_name
47: ,P_ACC_TABLE_NAME => g_cst_accnt_acc_table_name
48: ,P_SEQ_NAME => g_cst_accnt_seq_name
49: ,P_PK1_NAME => g_cst_accnt_pk1_name

Line 184: CSM_ACC_PKG.Delete_Acc

180: --take all teh cust_account_id for the party which doesnot exists for the user_id
181: FOR l_cust_accnt_rec IN c_cust_accnt_del(p_party_id,p_user_id)
182: LOOP
183: l_access_id := l_cust_accnt_rec.access_id;
184: CSM_ACC_PKG.Delete_Acc
185: (P_PUBLICATION_ITEM_NAMES => g_accnt_pubi_name
186: ,P_ACC_TABLE_NAME => g_cst_accnt_acc_table_name
187: ,P_PK1_NAME => g_cst_accnt_pk1_name
188: ,P_PK1_NUM_VALUE => l_cust_accnt_rec.CUST_ACCOUNT_ID