APPS.CSM_PARTY_EVENT_PKG dependencies on HZ_PARTY_SITES

Line 13: g_table_name2 CONSTANT VARCHAR2(30) := 'HZ_PARTY_SITES';

9: g_pk1_name1 CONSTANT VARCHAR2(30) := 'PARTY_ID';
10:
11: g_pub_item CONSTANT varchar(30) := 'CSF_M_PARTIES';
12:
13: g_table_name2 CONSTANT VARCHAR2(30) := 'HZ_PARTY_SITES';
14: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'CSM_PARTY_SITES_ACC';
15: g_acc_sequence_name2 CONSTANT VARCHAR2(30) := 'CSM_PARTY_SITES_ACC_S';
16: g_publication_item_name2 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
17: CSM_ACC_PKG.t_publication_item_list('CSF_M_PARTY_SITES');

Line 237: l_party_site_id hz_party_sites.party_site_id%TYPE;

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
241: SELECT access_id, user_id