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 2352: FROM hz_phone_country_codes pcc, hz_phone_formats pf

2348: -- Query all the format styles along with other flags
2349: CURSOR c_formats IS
2350: SELECT pf.phone_format_style, pf.country_code_display_flag,
2351: pf.area_code_size, pcc.phone_country_code
2352: FROM hz_phone_country_codes pcc, hz_phone_formats pf
2353: WHERE pcc.territory_code = p_territory_code
2354: AND pcc.territory_code = pf.territory_code;
2355:
2356: l_phone_format_style hz_phone_formats.phone_format_style%TYPE;

Line 2356: l_phone_format_style hz_phone_formats.phone_format_style%TYPE;

2352: FROM hz_phone_country_codes pcc, hz_phone_formats pf
2353: WHERE pcc.territory_code = p_territory_code
2354: AND pcc.territory_code = pf.territory_code;
2355:
2356: l_phone_format_style hz_phone_formats.phone_format_style%TYPE;
2357: l_area_code_size NUMBER;
2358: l_phone_country_code hz_phone_country_codes.phone_country_code%TYPE;
2359: l_country_code_display_flag hz_phone_formats.country_code_display_flag%TYPE;
2360: l_debug_prefix VARCHAR2(30) := '';

Line 2359: l_country_code_display_flag hz_phone_formats.country_code_display_flag%TYPE;

2355:
2356: l_phone_format_style hz_phone_formats.phone_format_style%TYPE;
2357: l_area_code_size NUMBER;
2358: l_phone_country_code hz_phone_country_codes.phone_country_code%TYPE;
2359: l_country_code_display_flag hz_phone_formats.country_code_display_flag%TYPE;
2360: l_debug_prefix VARCHAR2(30) := '';
2361:
2362: BEGIN
2363: