APPS.CSM_PARTY_EVENT_PKG dependencies on HZ_PARTIES

Line 4: g_table_name1 CONSTANT VARCHAR2(30) := 'HZ_PARTIES';

1: PACKAGE BODY CSM_PARTY_EVENT_PKG AS
2: /* $Header: csmeptyb.pls 120.2 2011/01/10 10:37:24 saradhak ship $ */
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');

Line 21: PROCEDURE INSERT_PARTIES_ACC (p_party_id hz_parties.party_id%TYPE,

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,
22: p_user_id fnd_user.user_id%TYPE,
23: x_access_id OUT NOCOPY number)
24: IS
25: l_sysdate date;

Line 236: l_party_id hz_parties.party_id%TYPE;

232: l_sqlerrmsg VARCHAR2(4000);
233: l_error_msg VARCHAR2(4000);
234: l_return_status VARCHAR2(2000);
235:
236: l_party_id hz_parties.party_id%TYPE;
237: l_party_site_id hz_party_sites.party_site_id%TYPE;
238:
239: CURSOR l_parties_csr (p_party_id hz_parties.party_id%TYPE)
240: IS

Line 239: CURSOR l_parties_csr (p_party_id hz_parties.party_id%TYPE)

235:
236: l_party_id hz_parties.party_id%TYPE;
237: l_party_site_id hz_party_sites.party_site_id%TYPE;
238:
239: CURSOR l_parties_csr (p_party_id hz_parties.party_id%TYPE)
240: IS
241: SELECT access_id, user_id
242: FROM csm_parties_acc
243: WHERE party_id = p_party_id;

Line 245: CURSOR l_party_sites_csr (p_party_id hz_parties.party_id%TYPE)

241: SELECT access_id, user_id
242: FROM csm_parties_acc
243: WHERE party_id = p_party_id;
244:
245: CURSOR l_party_sites_csr (p_party_id hz_parties.party_id%TYPE)
246: IS
247: SELECT access_id, user_id
248: FROM csm_party_sites_acc
249: WHERE party_id = p_party_id;