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_CONTACT_POINTS

Line 159: lp_phone_country_code HZ_CONTACT_POINTS.PHONE_country_code%TYPE;

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:
163: l_filtered_number HZ_CONTACT_POINTS.RAW_PHONE_NUMBER%TYPE;

Line 161: l_phone_number HZ_CONTACT_POINTS.PHONE_NUMBER%TYPE;

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;
165:

Line 163: l_filtered_number HZ_CONTACT_POINTS.RAW_PHONE_NUMBER%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;
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;

Line 164: l_raw_phone_number HZ_CONTACT_POINTS.RAW_PHONE_NUMBER%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;
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;

Line 176: x_without_intl_prefix HZ_CONTACT_POINTS.RAW_PHONE_NUMBER%TYPE;

172: l_p_country_code_check VARCHAR2(20);
173: l_length_cntry_code NUMBER;
174:
175: x_intl_prefix VARCHAR2(5);
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;

Line 178: x_without_trunk_prefix HZ_CONTACT_POINTS.RAW_PHONE_NUMBER%TYPE;

174:
175: x_intl_prefix VARCHAR2(5);
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:

Line 181: x_without_country_code 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;
185:

Line 184: x_parsed_phone_number HZ_CONTACT_POINTS.PHONE_NUMBER%TYPE;

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;
188: l_msg_data VARCHAR2(2000):= NULL;

Line 590: l_raw_phone_number HZ_CONTACT_POINTS.raw_phone_number%type;

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:
594: l_format_cntry_code hz_phone_country_codes.phone_country_code%TYPE;

Line 598: l_user_country_code HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%TYPE;

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

Line 600: l_default_area_code HZ_CONTACT_POINTS.PHONE_AREA_CODE%TYPE;

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

Line 611: l_contact_point_type HZ_CONTACT_POINTS.CONTACT_POINT_TYPE%TYPE;

607: l_prefix VARCHAR2(1) := null;
608:
609: l_msg_name VARCHAR2(100):= NULL;
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';

Line 612: l_phone_area_code HZ_CONTACT_POINTS.PHONE_AREA_CODE%TYPE;

608:
609: l_msg_name VARCHAR2(100):= NULL;
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) := '';

Line 613: l_phone_number HZ_CONTACT_POINTS.PHONE_NUMBER%TYPE;

609: l_msg_name VARCHAR2(100):= NULL;
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

Line 653: from HZ_CONTACT_POINTS

649: --If the contact_point_is of wrong type raise the error
650: BEGIN
651: select contact_point_type
652: into l_contact_point_type
653: from HZ_CONTACT_POINTS
654: where CONTACT_POINT_ID = p_contact_point_id;
655: EXCEPTION
656: WHEN NO_DATA_FOUND THEN
657: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');

Line 706: from HZ_CONTACT_POINTS

702: ---Get the phone number info from the contact_point_id
703: BEGIN
704: select phone_country_code,phone_area_code, phone_number
705: into l_phone_country_code ,l_phone_area_code, l_phone_number
706: from HZ_CONTACT_POINTS
707: where CONTACT_POINT_ID = p_contact_point_id
708: and CONTACT_POINT_TYPE = 'PHONE';
709: EXCEPTION
710: WHEN NO_DATA_FOUND THEN

Line 1003: l_phone_country_code HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%TYPE;

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;
1007: --3865843

Line 1004: l_phone_area_code HZ_CONTACT_POINTS.PHONE_AREA_CODE%TYPE;

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;
1007: --3865843
1008: l_formatted_phone_area_code VARCHAR2(12);

Line 1005: l_phone_number HZ_CONTACT_POINTS.PHONE_NUMBER%TYPE;

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;
1007: --3865843
1008: l_formatted_phone_area_code VARCHAR2(12);
1009: --User Preferences

Line 1012: l_default_area_code HZ_CONTACT_POINTS.PHONE_AREA_CODE%TYPE;

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);
1016: l_user_country_code HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%TYPE;

Line 1016: l_user_country_code HZ_CONTACT_POINTS.PHONE_COUNTRY_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);
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;

Line 1019: l_raw_phone_number HZ_CONTACT_POINTS.raw_phone_number%type;

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;
1023: l_format_cntry_code hz_phone_country_codes.phone_country_code%TYPE;

Line 2309: FROM hz_contact_points

2305: x_msg_data);
2306:
2307: SELECT phone_extension, hz_utility_v2pub.get_lookupmeaning('AR_LOOKUPS', 'PHONE_LINE_TYPE', phone_line_type)
2308: INTO x_phone_extension, x_phone_line_type
2309: FROM hz_contact_points
2310: WHERE contact_point_id = p_contact_point_id;
2311:
2312: IF x_phone_extension IS NOT NULL THEN
2313: x_formatted_phone_number := x_formatted_phone_number || ' x' || x_phone_extension;