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.1 2005/07/25 00:18:48 trajasek noship $ */
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 191: l_party_id hz_parties.party_id%TYPE;

187: l_sqlerrmsg VARCHAR2(4000);
188: l_error_msg VARCHAR2(4000);
189: l_return_status VARCHAR2(2000);
190:
191: l_party_id hz_parties.party_id%TYPE;
192: l_party_site_id hz_party_sites.party_site_id%TYPE;
193:
194: CURSOR l_parties_csr (p_party_id hz_parties.party_id%TYPE)
195: IS

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

190:
191: l_party_id hz_parties.party_id%TYPE;
192: l_party_site_id hz_party_sites.party_site_id%TYPE;
193:
194: CURSOR l_parties_csr (p_party_id hz_parties.party_id%TYPE)
195: IS
196: SELECT access_id, user_id
197: FROM csm_parties_acc
198: WHERE party_id = p_party_id;

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

196: SELECT access_id, user_id
197: FROM csm_parties_acc
198: WHERE party_id = p_party_id;
199:
200: CURSOR l_party_sites_csr (p_party_id hz_parties.party_id%TYPE)
201: IS
202: SELECT access_id, user_id
203: FROM csm_party_sites_acc
204: WHERE party_id = p_party_id;