APPS.HZ_CONTACT_POINT_V2PUB dependencies on HZ_LOCATIONS

Line 307: l_country_code hz_locations.country%TYPE;

303: l_msg_count NUMBER;
304: l_msg_data VARCHAR2(2000);
305:
306: l_formatted_phone_number VARCHAR2(100);
307: l_country_code hz_locations.country%TYPE;
308: l_transposed_phone_number hz_contact_points.transposed_phone_number%TYPE;
309:
310: l_edi_rec edi_rec_type;
311: l_email_rec email_rec_type;

Line 330: FROM hz_locations

326: -- Applications PL/SQL standards.
327:
328: CURSOR c_country (p_site_id IN NUMBER) IS
329: SELECT country
330: FROM hz_locations
331: WHERE location_id = (SELECT location_id
332: FROM hz_party_sites
333: WHERE party_site_id = p_site_id);
334:

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

473: p_msg_level=>fnd_log.level_statement);
474: END IF;
475:
476: --To get territory code to pass to phone_format, first check if country code
477: --was passed in else get it from hz_locations for owner_table_name HZ_PARTY_SITES
478:
479: IF p_contact_point_rec.contact_point_type = 'PHONE' THEN
480: IF l_phone_rec.raw_phone_number IS NOT NULL AND
481: l_phone_rec.raw_phone_number <> fnd_api.g_miss_char

Line 994: l_country_code hz_locations.country%TYPE;

990: l_msg_count NUMBER;
991: l_msg_data VARCHAR2(2000);
992:
993: l_formatted_phone_number VARCHAR2(100);
994: l_country_code hz_locations.country%TYPE;
995: l_owner_table_name hz_contact_points.owner_table_name%TYPE;
996: l_owner_table_id NUMBER;
997: l_contact_point_type hz_contact_points.contact_point_type%TYPE :=
998: p_contact_point_rec.contact_point_type;

Line 1031: FROM hz_locations

1027: -- Bug 2117973: defined the following cursors for PL/SQL coding standards
1028: -- compliance.
1029: CURSOR c_country (p_owner_table_id IN NUMBER) IS
1030: SELECT country
1031: FROM hz_locations
1032: WHERE location_id = (SELECT location_id
1033: FROM hz_party_sites
1034: WHERE party_site_id = p_owner_table_id);
1035: