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

122: OPEN l_party_sites_csr(p_party_site_id);
123: FETCH l_party_sites_csr into l_party_id;
124: CLOSE l_party_sites_csr;
125:
126: CSM_ACC_PKG.Delete_Acc
127: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
128: ,P_ACC_TABLE_NAME => g_acc_table_name1
129: ,P_PK1_NAME => g_pk1_name1
130: ,P_PK1_NUM_VALUE => p_party_site_id

Line 180: CSM_ACC_PKG.Update_Acc

176: 'CSM_PARTY_SITE_EVENT_PKG.PARTY_SITES_ACC_U',FND_LOG.LEVEL_PROCEDURE);
177:
178: FOR r_party_site_acc_rec IN l_party_site_acc_csr(p_party_site_id) LOOP
179: -- Call Update
180: CSM_ACC_PKG.Update_Acc
181: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
182: ,P_ACC_TABLE_NAME => g_acc_table_name1
183: ,P_USER_ID => r_party_site_acc_rec.user_id
184: ,P_ACCESS_ID => r_party_site_acc_rec.access_id

Line 231: CSM_ACC_PKG.Update_Acc

227: l_location_id := p_event.GetValueForParameter('LOCATION_ID');
228:
229: FOR r_party_site_rec IN l_party_site_csr(l_location_id) LOOP
230: -- Call Update
231: CSM_ACC_PKG.Update_Acc
232: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
233: ,P_ACC_TABLE_NAME => g_acc_table_name1
234: ,P_USER_ID => r_party_site_rec.user_id
235: ,P_ACCESS_ID => r_party_site_rec.access_id

Line 282: CSM_ACC_PKG.Update_Acc

278:
279: -- get users who have access to this PARTY_SITE_ID
280: FOR r_party_site_rec IN l_party_site_csr(l_party_site_id) LOOP
281: -- Call Update
282: CSM_ACC_PKG.Update_Acc
283: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
284: ,P_ACC_TABLE_NAME => g_acc_table_name1
285: ,P_USER_ID => r_party_site_rec.user_id
286: ,P_ACCESS_ID => r_party_site_rec.access_id