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_COUNTRY_CODES

Line 37: g_user_territory_code HZ_PHONE_COUNTRY_CODES.TERRITORY_CODE%TYPE:=

33: format_phone_country_tab var_indexed_table;
34:
35: g_debug_count NUMBER := 0;
36: g_international_flag VARCHAR2(1):= fnd_api.g_miss_char;
37: g_user_territory_code HZ_PHONE_COUNTRY_CODES.TERRITORY_CODE%TYPE:=
38: fnd_api.g_miss_char;
39: g_user_phone_country_code HZ_PHONE_COUNTRY_CODES.PHONE_COUNTRY_CODE%TYPE :=
40: fnd_api.g_miss_char;
41:

Line 39: g_user_phone_country_code HZ_PHONE_COUNTRY_CODES.PHONE_COUNTRY_CODE%TYPE :=

35: g_debug_count NUMBER := 0;
36: g_international_flag VARCHAR2(1):= fnd_api.g_miss_char;
37: g_user_territory_code HZ_PHONE_COUNTRY_CODES.TERRITORY_CODE%TYPE:=
38: fnd_api.g_miss_char;
39: g_user_phone_country_code HZ_PHONE_COUNTRY_CODES.PHONE_COUNTRY_CODE%TYPE :=
40: fnd_api.g_miss_char;
41:
42: --------------------------------------
43: -- declaration of private procedures

Line 158: i_territory_code HZ_PHONE_COUNTRY_CODES.TERRITORY_CODE%TYPE;

154: ) IS
155: l_customer_id NUMBER;
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:

Line 180: x_parsed_country_code HZ_PHONE_COUNTRY_CODES.PHONE_COUNTRY_CODE%TYPE;

176: x_without_intl_prefix HZ_CONTACT_POINTS.RAW_PHONE_NUMBER%TYPE;
177: x_trunk_prefix VARCHAR2(5);
178: x_without_trunk_prefix HZ_CONTACT_POINTS.RAW_PHONE_NUMBER%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;

Line 192: FROM hz_phone_country_codes

188: l_msg_data VARCHAR2(2000):= NULL;
189:
190: CURSOR c_phone_country_code(i_territory_code varchar2) IS
191: SELECT phone_country_code
192: FROM hz_phone_country_codes
193: WHERE territory_code = i_territory_code;
194:
195: CURSOR c_get_format_length IS
196: SELECT PHONE_FORMAT_STYLE

Line 584: FROM hz_phone_country_codes

580: l_empty BOOLEAN;
581:
582: CURSOR c_territory(p_country_code VARCHAR2) IS
583: SELECT territory_code
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;

Line 589: l_phone_country_code hz_phone_country_codes.phone_country_code%TYPE;

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);
593:

Line 594: l_format_cntry_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);
593:
594: l_format_cntry_code hz_phone_country_codes.phone_country_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;

Line 605: l_phone_intl_prefix HZ_PHONE_COUNTRY_CODES.INTL_PREFIX%TYPE;

601: l_display_area_code VARCHAR2(1);
602: l_display_all_prefixes VARCHAR2(1);
603: l_pabx_prefix VARCHAR2(1);
604:
605: l_phone_intl_prefix HZ_PHONE_COUNTRY_CODES.INTL_PREFIX%TYPE;
606: l_phone_trunk_prefix HZ_PHONE_COUNTRY_CODES.TRUNK_PREFIX%TYPE;
607: l_prefix VARCHAR2(1) := null;
608:
609: l_msg_name VARCHAR2(100):= NULL;

Line 606: l_phone_trunk_prefix HZ_PHONE_COUNTRY_CODES.TRUNK_PREFIX%TYPE;

602: l_display_all_prefixes VARCHAR2(1);
603: l_pabx_prefix VARCHAR2(1);
604:
605: l_phone_intl_prefix HZ_PHONE_COUNTRY_CODES.INTL_PREFIX%TYPE;
606: l_phone_trunk_prefix HZ_PHONE_COUNTRY_CODES.TRUNK_PREFIX%TYPE;
607: l_prefix VARCHAR2(1) := null;
608:
609: l_msg_name VARCHAR2(100):= NULL;
610: l_area_code_size NUMBER;

Line 696: from hz_phone_country_codes

692:
693: if l_user_territory_code is not null then
694: select phone_country_code , intl_prefix, trunk_prefix
695: into l_user_country_code, l_phone_intl_prefix, l_phone_trunk_prefix
696: from hz_phone_country_codes
697: where territory_code = l_user_territory_code;
698: else
699: l_user_country_code := null;
700: end if;

Line 736: from hz_phone_country_codes pc

732: else
733: begin
734: select pc.territory_code
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)

Line 1017: l_phone_intl_prefix HZ_PHONE_COUNTRY_CODES.INTL_PREFIX%TYPE;

1013: l_display_area_code VARCHAR2(1);
1014: l_display_all_prefixes VARCHAR2(1);
1015: l_pabx_prefix VARCHAR2(1);
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;

Line 1018: l_phone_trunk_prefix HZ_PHONE_COUNTRY_CODES.TRUNK_PREFIX%TYPE;

1014: l_display_all_prefixes VARCHAR2(1);
1015: l_pabx_prefix VARCHAR2(1);
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;

Line 1023: l_format_cntry_code hz_phone_country_codes.phone_country_code%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;
1025: l_empty BOOLEAN;
1026: --3865843
1027: l_formatted_phone_number VARCHAR2(120);

Line 1650: FROM hz_phone_country_codes

1646: CURSOR c_phone_country IS
1647: SELECT phone_country_code,
1648: trunk_prefix,
1649: intl_prefix
1650: FROM hz_phone_country_codes
1651: WHERE territory_code = p_territory_code;
1652:
1653: BEGIN
1654:

Line 1687: FROM hz_phone_country_codes pc

1683: ) IS
1684:
1685: CURSOR c_territory IS
1686: SELECT pc.territory_code
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

Line 1744: from hz_phone_country_codes

1740:
1741: ---Get the International prefix for the country
1742: select intl_prefix
1743: into l_intl_prefix
1744: from hz_phone_country_codes
1745: where territory_code = p_territory_code;
1746:
1747: l_length_with_iprefix := LENGTH(l_with_iprefix);
1748: l_length_of_iprefix := LENGTH(l_intl_prefix);

Line 1826: from hz_phone_country_codes

1822:
1823: ---Get the trunk prefix for the country
1824: select trunk_prefix
1825: into l_trunk_prefix
1826: from hz_phone_country_codes
1827: where territory_code = p_territory_code;
1828:
1829: l_length_with_tprefix := LENGTH(l_with_tprefix);
1830: l_length_of_tprefix := LENGTH(l_trunk_prefix);

Line 1912: from hz_phone_country_codes

1908:
1909: --row num =1 to eliminate where 2 countries with same country_code
1910: select phone_country_code
1911: into l_phone_country_code
1912: from hz_phone_country_codes
1913: where phone_country_code = l_country_code_check
1914: and rownum = 1;
1915:
1916:

Line 1992: from hz_phone_country_codes

1988: ----First see if the length of the area code is fixed
1989: SELECT area_code_length,
1990: phone_length
1991: into l_area_code_length, l_phone_length
1992: from hz_phone_country_codes
1993: where phone_country_code = l_country_code_for_area_code
1994: and rownum = 1;
1995:
1996:

Line 2142: FROM hz_phone_country_codes pcc,

2138: CURSOR c_formats IS
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: