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 165: CSM_ACC_PKG.Delete_Acc

161: FETCH c_get_party_count INTO l_count ;
162: CLOSE c_get_party_count;
163:
164: IF l_count >1 THEN
165: CSM_ACC_PKG.Delete_Acc
166: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
167: ,P_ACC_TABLE_NAME => g_acc_table_name1
168: ,P_PK1_NAME => g_pk1_name1
169: ,P_PK1_NUM_VALUE => p_party_id

Line 194: CSM_ACC_PKG.Delete_Acc

190: l_ref_exists := 0 ;
191: END IF ;
192: CLOSE l_check_party_ref ;
193: IF l_ref_exists = 1 THEN
194: CSM_ACC_PKG.Delete_Acc
195: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
196: ,P_ACC_TABLE_NAME => g_acc_table_name1
197: ,P_PK1_NAME => g_pk1_name1
198: ,P_PK1_NUM_VALUE => p_party_id

Line 264: CSM_ACC_PKG.Update_Acc

260:
261: -- get users who have access to this PARTY_ID
262: FOR r_parties_rec IN l_parties_csr(l_party_id) LOOP
263: -- Call Update
264: CSM_ACC_PKG.Update_Acc
265: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
266: ,P_ACC_TABLE_NAME => g_acc_table_name1
267: ,P_USER_ID => r_parties_rec.user_id
268: ,P_ACCESS_ID => r_parties_rec.access_id

Line 275: CSM_ACC_PKG.Update_Acc

271:
272: -- update party_sites pub item
273: FOR r_party_sites_rec IN l_party_sites_csr(l_party_id) LOOP
274: -- Call Update
275: CSM_ACC_PKG.Update_Acc
276: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name2
277: ,P_ACC_TABLE_NAME => g_acc_table_name2
278: ,P_USER_ID => r_party_sites_rec.user_id
279: ,P_ACCESS_ID => r_party_sites_rec.access_id