APPS.CSM_PARTY_SITE_EVENT_PKG dependencies on CSM_PARTY_SITES_ACC

Line 5: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_PARTY_SITES_ACC';

1: PACKAGE BODY CSM_PARTY_SITE_EVENT_PKG AS
2: /* $Header: csmeptsb.pls 120.1 2005/07/25 00:18:18 trajasek noship $ */
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';

Line 6: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_PARTY_SITES_ACC_S';

2: /* $Header: csmeptsb.pls 120.1 2005/07/25 00:18:18 trajasek noship $ */
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';

Line 20: insert into csm_party_sites_acc (party_site_id,

16: l_sysdate date;
17: begin
18: l_sysdate := sysdate;
19:
20: insert into csm_party_sites_acc (party_site_id,
21: party_id,
22: user_id,
23: created_by,
24: creation_date,

Line 171: FROM csm_party_sites_acc acc

167:
168: CURSOR l_party_site_acc_csr (p_party_site_id hz_party_sites.party_site_id%TYPE)
169: IS
170: SELECT acc.access_id, acc.user_id
171: FROM csm_party_sites_acc acc
172: WHERE party_site_id = p_party_site_id;
173:
174: BEGIN
175: CSM_UTIL_PKG.LOG('Entering PARTY_SITES_ACC_U for party_site_id: ' || p_party_site_id,

Line 215: csm_party_sites_acc acc

211: IS
212: SELECT acc.access_id,
213: acc.user_id
214: FROM hz_party_sites ps,
215: csm_party_sites_acc acc
216: WHERE ps.location_id = p_location_id
217: AND acc.party_site_id = ps.party_site_id;
218:
219: BEGIN

Line 266: FROM csm_party_sites_acc

262:
263: CURSOR l_party_site_csr (p_party_site_id hz_party_sites.party_site_id%TYPE)
264: IS
265: SELECT access_id, user_id
266: FROM csm_party_sites_acc
267: WHERE party_site_id = p_party_site_id;
268:
269: BEGIN
270: CSM_UTIL_PKG.LOG('Entering PARTY_SITE_UPD_WF_EVENT_SUB',