APPS.CSM_PARTY_EVENT_PKG dependencies on CSM_ACC_PKG

Line 7: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=

3:
4: g_table_name1 CONSTANT VARCHAR2(30) := 'HZ_PARTIES';
5: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_PARTIES_ACC';
6: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_PARTIES_ACC_S';
7: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
8: CSM_ACC_PKG.t_publication_item_list('CSF_M_PARTIES');
9: g_pk1_name1 CONSTANT VARCHAR2(30) := 'PARTY_ID';
10:
11: g_pub_item CONSTANT varchar(30) := 'CSF_M_PARTIES';

Line 8: CSM_ACC_PKG.t_publication_item_list('CSF_M_PARTIES');

4: g_table_name1 CONSTANT VARCHAR2(30) := 'HZ_PARTIES';
5: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_PARTIES_ACC';
6: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_PARTIES_ACC_S';
7: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
8: CSM_ACC_PKG.t_publication_item_list('CSF_M_PARTIES');
9: g_pk1_name1 CONSTANT VARCHAR2(30) := 'PARTY_ID';
10:
11: g_pub_item CONSTANT varchar(30) := 'CSF_M_PARTIES';
12:

Line 16: g_publication_item_name2 CONSTANT CSM_ACC_PKG.t_publication_item_list :=

12:
13: g_table_name2 CONSTANT VARCHAR2(30) := 'HZ_PARTY_SITES';
14: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'CSM_PARTY_SITES_ACC';
15: g_acc_sequence_name2 CONSTANT VARCHAR2(30) := 'CSM_PARTY_SITES_ACC_S';
16: g_publication_item_name2 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
17: CSM_ACC_PKG.t_publication_item_list('CSF_M_PARTY_SITES');
18: g_pk1_name2 CONSTANT VARCHAR2(30) := 'PARTY_SITE_ID';
19: g_pk2_name2 CONSTANT VARCHAR2(30) := 'PARTY_ID';
20:

Line 17: CSM_ACC_PKG.t_publication_item_list('CSF_M_PARTY_SITES');

13: g_table_name2 CONSTANT VARCHAR2(30) := 'HZ_PARTY_SITES';
14: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'CSM_PARTY_SITES_ACC';
15: g_acc_sequence_name2 CONSTANT VARCHAR2(30) := 'CSM_PARTY_SITES_ACC_S';
16: g_publication_item_name2 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
17: CSM_ACC_PKG.t_publication_item_list('CSF_M_PARTY_SITES');
18: g_pk1_name2 CONSTANT VARCHAR2(30) := 'PARTY_SITE_ID';
19: g_pk2_name2 CONSTANT VARCHAR2(30) := 'PARTY_ID';
20:
21: PROCEDURE INSERT_PARTIES_ACC (p_party_id hz_parties.party_id%TYPE,

Line 71: CSM_ACC_PKG.Insert_Acc

67: BEGIN
68: x_return_status := FND_API.G_RET_STS_SUCCESS;
69: p_error_msg := 'Entering CSM_PARTY_EVENT_PKG.PARTY_ACC_I' || ' for party_id ' || to_char(p_party_id);
70:
71: CSM_ACC_PKG.Insert_Acc
72: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
73: ,P_ACC_TABLE_NAME => g_acc_table_name1
74: ,P_SEQ_NAME => g_acc_sequence_name1
75: ,P_PK1_NAME => g_pk1_name1

Line 141: CSM_ACC_PKG.Delete_Acc

137: END IF ;
138: CLOSE l_check_party_ref ;
139:
140: IF L_REF_EXISTS <> 1 THEN
141: CSM_ACC_PKG.Delete_Acc
142: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
143: ,P_ACC_TABLE_NAME => g_acc_table_name1
144: ,P_PK1_NAME => g_pk1_name1
145: ,P_PK1_NUM_VALUE => p_party_id

Line 151: CSM_ACC_PKG.Delete_Acc

147: );
148: END IF;
149: */
150: -- commented the above..as such cases should not occur
151: CSM_ACC_PKG.Delete_Acc
152: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
153: ,P_ACC_TABLE_NAME => g_acc_table_name1
154: ,P_PK1_NAME => g_pk1_name1
155: ,P_PK1_NUM_VALUE => p_party_id

Line 219: CSM_ACC_PKG.Update_Acc

215:
216: -- get users who have access to this PARTY_ID
217: FOR r_parties_rec IN l_parties_csr(l_party_id) LOOP
218: -- Call Update
219: CSM_ACC_PKG.Update_Acc
220: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
221: ,P_ACC_TABLE_NAME => g_acc_table_name1
222: ,P_USER_ID => r_parties_rec.user_id
223: ,P_ACCESS_ID => r_parties_rec.access_id

Line 230: CSM_ACC_PKG.Update_Acc

226:
227: -- update party_sites pub item
228: FOR r_party_sites_rec IN l_party_sites_csr(l_party_id) LOOP
229: -- Call Update
230: CSM_ACC_PKG.Update_Acc
231: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name2
232: ,P_ACC_TABLE_NAME => g_acc_table_name2
233: ,P_USER_ID => r_party_sites_rec.user_id
234: ,P_ACCESS_ID => r_party_sites_rec.access_id