APPS.HZ_FORMAT_PHONE_V2PUB dependencies on HZ_PHONE_AREA_CODES

Line 160: l_phone_area_code HZ_PHONE_AREA_CODES.AREA_CODE%TYPE;

156: x_user_phone_preferences_rec user_phone_preferences_rec;
157:
158: i_territory_code HZ_PHONE_COUNTRY_CODES.TERRITORY_CODE%TYPE;
159: lp_phone_country_code HZ_CONTACT_POINTS.PHONE_country_code%TYPE;
160: l_phone_area_code HZ_PHONE_AREA_CODES.AREA_CODE%TYPE;
161: l_phone_number HZ_CONTACT_POINTS.PHONE_NUMBER%TYPE;
162:
163: l_filtered_number HZ_CONTACT_POINTS.RAW_PHONE_NUMBER%TYPE;
164: l_raw_phone_number HZ_CONTACT_POINTS.RAW_PHONE_NUMBER%TYPE;

Line 183: x_parsed_area_code HZ_PHONE_AREA_CODES.AREA_CODE%TYPE;

179:
180: x_parsed_country_code HZ_PHONE_COUNTRY_CODES.PHONE_COUNTRY_CODE%TYPE;
181: x_without_country_code HZ_CONTACT_POINTS.RAW_PHONE_NUMBER%TYPE;
182:
183: x_parsed_area_code HZ_PHONE_AREA_CODES.AREA_CODE%TYPE;
184: x_parsed_phone_number HZ_CONTACT_POINTS.PHONE_NUMBER%TYPE;
185:
186: l_msg_name VARCHAR2(50) := NULL;
187: l_msg_count NUMBER :=0;

Line 2016: from hz_phone_area_codes

2012: ELSE
2013:
2014: select count(area_code)
2015: into l_count_area_code
2016: from hz_phone_area_codes
2017: where phone_country_code = l_country_code_for_area_code;
2018:
2019: IF l_count_area_code > 0 then
2020:

Line 2029: from hz_phone_area_codes

2025: l_area_code_check := SUBSTR(l_with_area_code,1,i);
2026:
2027: select area_code
2028: into l_area_code
2029: from hz_phone_area_codes
2030: where area_code = l_area_code_check
2031: and phone_country_code = l_country_code_for_area_code;
2032:
2033: