eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_CONTACT_POINT_V2PUB dependencies on HZ_PHONE_FORMATS

Line 2199: FROM hz_phone_country_codes pcc, hz_phone_formats pf

2195: -- Query all the format styles along with other flags
2196: CURSOR c_formats IS
2197: SELECT pf.phone_format_style, pf.country_code_display_flag,
2198: pf.area_code_size, pcc.phone_country_code
2199: FROM hz_phone_country_codes pcc, hz_phone_formats pf
2200: WHERE pcc.territory_code = p_territory_code
2201: AND pcc.territory_code = pf.territory_code;
2202:
2203: l_phone_format_style hz_phone_formats.phone_format_style%TYPE;

Line 2203: l_phone_format_style hz_phone_formats.phone_format_style%TYPE;

2199: FROM hz_phone_country_codes pcc, hz_phone_formats pf
2200: WHERE pcc.territory_code = p_territory_code
2201: AND pcc.territory_code = pf.territory_code;
2202:
2203: l_phone_format_style hz_phone_formats.phone_format_style%TYPE;
2204: l_area_code_size NUMBER;
2205: l_phone_country_code hz_phone_country_codes.phone_country_code%TYPE;
2206: l_country_code_display_flag hz_phone_formats.country_code_display_flag%TYPE;
2207: l_debug_prefix VARCHAR2(30) := '';

Line 2206: l_country_code_display_flag hz_phone_formats.country_code_display_flag%TYPE;

2202:
2203: l_phone_format_style hz_phone_formats.phone_format_style%TYPE;
2204: l_area_code_size NUMBER;
2205: l_phone_country_code hz_phone_country_codes.phone_country_code%TYPE;
2206: l_country_code_display_flag hz_phone_formats.country_code_display_flag%TYPE;
2207: l_debug_prefix VARCHAR2(30) := '';
2208:
2209: BEGIN
2210: