APPS.CSM_PARTY_SITE_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_PARTY_SITES';
5: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_PARTY_SITES_ACC';
6: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_PARTY_SITES_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_PARTY_SITES');
9: g_pk1_name1 CONSTANT VARCHAR2(30) := 'PARTY_SITE_ID';
10: g_pk2_name1 CONSTANT VARCHAR2(30) := 'PARTY_ID';
11:

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

4: g_table_name1 CONSTANT VARCHAR2(30) := 'HZ_PARTY_SITES';
5: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_PARTY_SITES_ACC';
6: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_PARTY_SITES_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_PARTY_SITES');
9: g_pk1_name1 CONSTANT VARCHAR2(30) := 'PARTY_SITE_ID';
10: g_pk2_name1 CONSTANT VARCHAR2(30) := 'PARTY_ID';
11:
12: procedure insert_party_sites_acc (p_party_site_id hz_party_sites.party_site_id%type,

Line 70: CSM_ACC_PKG.Insert_Acc

66: OPEN l_party_sites_csr(p_party_site_id);
67: FETCH l_party_sites_csr into l_party_id;
68: CLOSE l_party_sites_csr;
69:
70: CSM_ACC_PKG.Insert_Acc
71: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
72: ,P_ACC_TABLE_NAME => g_acc_table_name1
73: ,P_SEQ_NAME => g_acc_sequence_name1
74: ,P_PK1_NAME => g_pk1_name1

Line 136: CSM_ACC_PKG.Delete_Acc

132: FETCH l_party_sites_csr into l_party_id;
133: CLOSE l_party_sites_csr;
134:
135: IF l_party_id IS NOT NULL THEN
136: CSM_ACC_PKG.Delete_Acc
137: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
138: ,P_ACC_TABLE_NAME => g_acc_table_name1
139: ,P_PK1_NAME => g_pk1_name1
140: ,P_PK1_NUM_VALUE => p_party_site_id

Line 190: CSM_ACC_PKG.Update_Acc

186: 'CSM_PARTY_SITE_EVENT_PKG.PARTY_SITES_ACC_U',FND_LOG.LEVEL_PROCEDURE);
187:
188: FOR r_party_site_acc_rec IN l_party_site_acc_csr(p_party_site_id) LOOP
189: -- Call Update
190: CSM_ACC_PKG.Update_Acc
191: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
192: ,P_ACC_TABLE_NAME => g_acc_table_name1
193: ,P_USER_ID => r_party_site_acc_rec.user_id
194: ,P_ACCESS_ID => r_party_site_acc_rec.access_id

Line 241: CSM_ACC_PKG.Update_Acc

237: l_location_id := p_event.GetValueForParameter('LOCATION_ID');
238:
239: FOR r_party_site_rec IN l_party_site_csr(l_location_id) LOOP
240: -- Call Update
241: CSM_ACC_PKG.Update_Acc
242: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
243: ,P_ACC_TABLE_NAME => g_acc_table_name1
244: ,P_USER_ID => r_party_site_rec.user_id
245: ,P_ACCESS_ID => r_party_site_rec.access_id

Line 292: CSM_ACC_PKG.Update_Acc

288:
289: -- get users who have access to this PARTY_SITE_ID
290: FOR r_party_site_rec IN l_party_site_csr(l_party_site_id) LOOP
291: -- Call Update
292: CSM_ACC_PKG.Update_Acc
293: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
294: ,P_ACC_TABLE_NAME => g_acc_table_name1
295: ,P_USER_ID => r_party_site_rec.user_id
296: ,P_ACCESS_ID => r_party_site_rec.access_id