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.2 2011/01/10 10:37:02 saradhak ship $ */
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.2 2011/01/10 10:37:02 saradhak ship $ */
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 181: FROM csm_party_sites_acc acc

177:
178: CURSOR l_party_site_acc_csr (p_party_site_id hz_party_sites.party_site_id%TYPE)
179: IS
180: SELECT acc.access_id, acc.user_id
181: FROM csm_party_sites_acc acc
182: WHERE party_site_id = p_party_site_id;
183:
184: BEGIN
185: CSM_UTIL_PKG.LOG('Entering PARTY_SITES_ACC_U for party_site_id: ' || p_party_site_id,

Line 225: csm_party_sites_acc acc

221: IS
222: SELECT acc.access_id,
223: acc.user_id
224: FROM hz_party_sites ps,
225: csm_party_sites_acc acc
226: WHERE ps.location_id = p_location_id
227: AND acc.party_site_id = ps.party_site_id;
228:
229: BEGIN

Line 276: FROM csm_party_sites_acc

272:
273: CURSOR l_party_site_csr (p_party_site_id hz_party_sites.party_site_id%TYPE)
274: IS
275: SELECT access_id, user_id
276: FROM csm_party_sites_acc
277: WHERE party_site_id = p_party_site_id;
278:
279: BEGIN
280: CSM_UTIL_PKG.LOG('Entering PARTY_SITE_UPD_WF_EVENT_SUB',