APPS.IEX_CUST_OVERVIEW_PVT dependencies on HZ_PARTY_SITES

Line 2562: FROM HZ_PARTY_SITES

2558: l_call_api BOOLEAN;
2559:
2560: CURSOR c_CheckPartySite(p_partyid number,p_location_id Number) IS
2561: SELECT party_site_id,party_site_number
2562: FROM HZ_PARTY_SITES
2563: where party_id = p_partyid
2564: AND location_id = p_location_id;
2565:
2566: BEGIN

Line 2888: SELECT hz_party_sites_s.nextval

2884:
2885: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':HZ_GENERATE_PARTY_SITE_NUMBER=' || fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER'));
2886:
2887: IF NVL(fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER'), 'Y') = 'N' THEN
2888: SELECT hz_party_sites_s.nextval
2889: INTO l_Party_Site_Create_rec.Party_Site_Number
2890: FROM dual;
2891: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_party_site_number=' || l_party_site_create_rec.party_site_number);
2892: ELSE

Line 2955: SELECT hz_party_sites_s.nextval

2951:
2952: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':HZ_GENERATE_PARTY_SITE_NUMBER=' || fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER'));
2953:
2954: IF NVL(fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER'), 'Y') = 'N' THEN
2955: SELECT hz_party_sites_s.nextval
2956: INTO l_Party_Site_Create_rec.Party_Site_Number
2957: FROM dual;
2958: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_party_site_number=' || l_party_site_create_rec.party_site_number);
2959: ELSE