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_FORMAT_PHONE_V2PUB dependencies on HZ_PHONE_FORMATS

Line 166: l_phone_format_style HZ_PHONE_FORMATS.PHONE_FORMAT_STYLE%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;
165:
166: l_phone_format_style HZ_PHONE_FORMATS.PHONE_FORMAT_STYLE%TYPE;
167: l_filtered_phone_format_style HZ_PHONE_FORMATS.PHONE_FORMAT_STYLE%TYPE;
168: l_length_style NUMBER;
169: l_length_matches VARCHAR2(1);
170: l_initial_sign VARCHAR2(1);

Line 167: l_filtered_phone_format_style HZ_PHONE_FORMATS.PHONE_FORMAT_STYLE%TYPE;

163: l_filtered_number HZ_CONTACT_POINTS.RAW_PHONE_NUMBER%TYPE;
164: l_raw_phone_number HZ_CONTACT_POINTS.RAW_PHONE_NUMBER%TYPE;
165:
166: l_phone_format_style HZ_PHONE_FORMATS.PHONE_FORMAT_STYLE%TYPE;
167: l_filtered_phone_format_style HZ_PHONE_FORMATS.PHONE_FORMAT_STYLE%TYPE;
168: l_length_style NUMBER;
169: l_length_matches VARCHAR2(1);
170: l_initial_sign VARCHAR2(1);
171:

Line 197: FROM hz_phone_formats

193: WHERE territory_code = i_territory_code;
194:
195: CURSOR c_get_format_length IS
196: SELECT PHONE_FORMAT_STYLE
197: FROM hz_phone_formats
198: WHERE territory_code = g_user_territory_code;
199: l_debug_prefix VARCHAR2(30) := '';
200:
201: BEGIN

Line 547: -- HZ_PHONE_FORMATS or default format

543: -- p_contact_point_id Contact point id of TYPE PHONE
544: -- territory code of the Phone No.
545: -- OUT:
546: -- x_formatted_number Number formatted acc. to defaults set in
547: -- HZ_PHONE_FORMATS or default format
548: -- x_return_status Return status after the call. The status can
549: -- be fnd_api.g_ret_sts_success (success),
550: -- fnd_api.g_ret_sts_error (error),
551: -- fnd_api.g_ret_sts_unexp_error

Line 578: x_phone_format_style HZ_PHONE_FORMATS.PHONE_FORMAT_STYLE%TYPE;

574: x_return_status OUT NOCOPY VARCHAR2,
575: x_msg_count OUT NOCOPY NUMBER,
576: x_msg_data OUT NOCOPY VARCHAR2 ) IS
577:
578: x_phone_format_style HZ_PHONE_FORMATS.PHONE_FORMAT_STYLE%TYPE;
579: l_default_prefix VARCHAR2(30) := ''; -- get_phone_format
580: l_empty BOOLEAN;
581:
582: CURSOR c_territory(p_country_code VARCHAR2) IS

Line 588: l_phone_format_style hz_phone_formats.phone_format_style%TYPE;

584: FROM hz_phone_country_codes
585: WHERE phone_country_code = p_country_code;
586:
587: l_customer_id NUMBER;
588: l_phone_format_style hz_phone_formats.phone_format_style%TYPE;
589: l_phone_country_code hz_phone_country_codes.phone_country_code%TYPE;
590: l_raw_phone_number HZ_CONTACT_POINTS.raw_phone_number%type;
591: --3865843
592: l_formatted_phone_number VARCHAR2(120);

Line 599: l_user_territory_code HZ_PHONE_FORMATS.TERRITORY_CODE%TYPE;

595:
596: --User Preferences
597: x_user_phone_preferences_rec user_phone_preferences_rec;
598: l_user_country_code HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%TYPE;
599: l_user_territory_code HZ_PHONE_FORMATS.TERRITORY_CODE%TYPE;
600: l_default_area_code HZ_CONTACT_POINTS.PHONE_AREA_CODE%TYPE;
601: l_display_area_code VARCHAR2(1);
602: l_display_all_prefixes VARCHAR2(1);
603: l_pabx_prefix VARCHAR2(1);

Line 614: l_phone_territory_code HZ_PHONE_FORMATS.TERRITORY_CODE%TYPE;

610: l_area_code_size NUMBER;
611: l_contact_point_type HZ_CONTACT_POINTS.CONTACT_POINT_TYPE%TYPE;
612: l_phone_area_code HZ_CONTACT_POINTS.PHONE_AREA_CODE%TYPE;
613: l_phone_number HZ_CONTACT_POINTS.PHONE_NUMBER%TYPE;
614: l_phone_territory_code HZ_PHONE_FORMATS.TERRITORY_CODE%TYPE;
615: l_default_format VARCHAR2(1):= 'N';
616: l_debug_prefix VARCHAR2(30) := '';
617: --3865843
618: l_formatted_phone_area_code VARCHAR2(12);

Line 739: from hz_phone_formats pf

735: into l_phone_territory_code
736: from hz_phone_country_codes pc
737: where phone_country_code = l_phone_country_code
738: AND exists (select phone_format_style
739: from hz_phone_formats pf
740: where pf.territory_code = pc.territory_code)
741: AND rownum =1;
742:
743: exception

Line 970: -- HZ_PHONE_FORMATS or default format

966: -- p_phone_number Phone Number
967: --
968: -- OUT:
969: -- x_formatted_number Number formatted acc. to defaults set in
970: -- HZ_PHONE_FORMATS or default format
971: -- x_return_status Return status after the call. The status can
972: -- be fnd_api.g_ret_sts_success (success),
973: -- fnd_api.g_ret_sts_error (error),
974: -- fnd_api.g_ret_sts_unexp_error

Line 1002: x_phone_format_style HZ_PHONE_FORMATS.PHONE_FORMAT_STYLE%TYPE;

998: x_msg_data OUT NOCOPY VARCHAR2
999: ) IS
1000:
1001: l_default_prefix VARCHAR2(30) := ''; -- get_phone_format
1002: x_phone_format_style HZ_PHONE_FORMATS.PHONE_FORMAT_STYLE%TYPE;
1003: l_phone_country_code HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%TYPE;
1004: l_phone_area_code HZ_CONTACT_POINTS.PHONE_AREA_CODE%TYPE;
1005: l_phone_number HZ_CONTACT_POINTS.PHONE_NUMBER%TYPE;
1006: l_customer_id NUMBER;

Line 1011: l_user_territory_code HZ_PHONE_FORMATS.TERRITORY_CODE%TYPE;

1007: --3865843
1008: l_formatted_phone_area_code VARCHAR2(12);
1009: --User Preferences
1010: x_user_phone_preferences_rec user_phone_preferences_rec := NULL;
1011: l_user_territory_code HZ_PHONE_FORMATS.TERRITORY_CODE%TYPE;
1012: l_default_area_code HZ_CONTACT_POINTS.PHONE_AREA_CODE%TYPE;
1013: l_display_area_code VARCHAR2(1);
1014: l_display_all_prefixes VARCHAR2(1);
1015: l_pabx_prefix VARCHAR2(1);

Line 1020: l_phone_territory_code HZ_PHONE_FORMATS.TERRITORY_CODE%TYPE;

1016: l_user_country_code HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%TYPE;
1017: l_phone_intl_prefix HZ_PHONE_COUNTRY_CODES.INTL_PREFIX%TYPE;
1018: l_phone_trunk_prefix HZ_PHONE_COUNTRY_CODES.TRUNK_PREFIX%TYPE;
1019: l_raw_phone_number HZ_CONTACT_POINTS.raw_phone_number%type;
1020: l_phone_territory_code HZ_PHONE_FORMATS.TERRITORY_CODE%TYPE;
1021: l_msg_name VARCHAR2(100):= NULL;
1022: l_area_code_size NUMBER;
1023: l_format_cntry_code hz_phone_country_codes.phone_country_code%TYPE;
1024: l_phone_format_style hz_phone_formats.phone_format_style%TYPE;

Line 1024: l_phone_format_style hz_phone_formats.phone_format_style%TYPE;

1020: l_phone_territory_code HZ_PHONE_FORMATS.TERRITORY_CODE%TYPE;
1021: l_msg_name VARCHAR2(100):= NULL;
1022: l_area_code_size NUMBER;
1023: l_format_cntry_code hz_phone_country_codes.phone_country_code%TYPE;
1024: l_phone_format_style hz_phone_formats.phone_format_style%TYPE;
1025: l_empty BOOLEAN;
1026: --3865843
1027: l_formatted_phone_number VARCHAR2(120);
1028: l_prefix VARCHAR2(1);

Line 1336: -- HZ_PHONE_FORMATS or default format

1332: -- p_phone_number Phone Number
1333: --
1334: -- OUT:
1335: -- x_mobile_flag Flag indicating if the number is mobile
1336: -- HZ_PHONE_FORMATS or default format
1337: -- x_return_status Return status after the call. The status can
1338: -- be fnd_api.g_ret_sts_success (success),
1339: -- fnd_api.g_ret_sts_error (error),
1340: -- fnd_api.g_ret_sts_unexp_error

Line 1691: FROM hz_phone_formats pf

1687: FROM hz_phone_country_codes pc
1688: WHERE phone_country_code = p_phone_country_code
1689: AND EXISTS (
1690: SELECT null
1691: FROM hz_phone_formats pf
1692: WHERE pf.territory_code = pc.territory_code)
1693: AND ROWNUM =1;
1694:
1695: BEGIN

Line 2143: hz_phone_formats pf

2139: SELECT pf.phone_format_style,
2140: pf.area_code_size,
2141: pcc.phone_country_code
2142: FROM hz_phone_country_codes pcc,
2143: hz_phone_formats pf
2144: WHERE pcc.territory_code = p_territory_code
2145: AND pcc.territory_code = pf.territory_code;
2146:
2147: BEGIN