APPS.HZ_CONTACT_POINT_V2PUB dependencies on HZ_LOCATIONS

Line 297: l_country_code hz_locations.country%TYPE;

293: l_msg_count NUMBER;
294: l_msg_data VARCHAR2(2000);
295:
296: l_formatted_phone_number VARCHAR2(100);
297: l_country_code hz_locations.country%TYPE;
298: l_transposed_phone_number hz_contact_points.transposed_phone_number%TYPE;
299:
300: l_edi_rec edi_rec_type;
301: l_email_rec email_rec_type;

Line 320: FROM hz_locations

316: -- Applications PL/SQL standards.
317:
318: CURSOR c_country (p_site_id IN NUMBER) IS
319: SELECT country
320: FROM hz_locations
321: WHERE location_id = (SELECT location_id
322: FROM hz_party_sites
323: WHERE party_site_id = p_site_id);
324:

Line 467: --was passed in else get it from hz_locations for owner_table_name HZ_PARTY_SITES

463: p_msg_level=>fnd_log.level_statement);
464: END IF;
465:
466: --To get territory code to pass to phone_format, first check if country code
467: --was passed in else get it from hz_locations for owner_table_name HZ_PARTY_SITES
468:
469: IF p_contact_point_rec.contact_point_type = 'PHONE' THEN
470: IF l_phone_rec.raw_phone_number IS NOT NULL AND
471: l_phone_rec.raw_phone_number <> fnd_api.g_miss_char

Line 981: l_country_code hz_locations.country%TYPE;

977: l_msg_count NUMBER;
978: l_msg_data VARCHAR2(2000);
979:
980: l_formatted_phone_number VARCHAR2(100);
981: l_country_code hz_locations.country%TYPE;
982: l_owner_table_name hz_contact_points.owner_table_name%TYPE;
983: l_owner_table_id NUMBER;
984: l_contact_point_type hz_contact_points.contact_point_type%TYPE :=
985: p_contact_point_rec.contact_point_type;

Line 1018: FROM hz_locations

1014: -- Bug 2117973: defined the following cursors for PL/SQL coding standards
1015: -- compliance.
1016: CURSOR c_country (p_owner_table_id IN NUMBER) IS
1017: SELECT country
1018: FROM hz_locations
1019: WHERE location_id = (SELECT location_id
1020: FROM hz_party_sites
1021: WHERE party_site_id = p_owner_table_id);
1022: