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.ARPT_SQL_FUNC_UTIL dependencies on HZ_CONTACT_POINTS

Line 193: (phone_number hz_contact_points.phone_number%TYPE,

189: FUNCTION get_address_details (p_address_id IN NUMBER,
190: p_detail_type IN VARCHAR2)
191: RETURN VARCHAR2;
192: TYPE phone_rec_type IS RECORD
193: (phone_number hz_contact_points.phone_number%TYPE,
194: area_code hz_contact_points.phone_area_code%TYPE,
195: extension hz_contact_points.phone_extension%TYPE);
196:
197: TYPE t_phone_table IS TABLE OF phone_rec_type

Line 194: area_code hz_contact_points.phone_area_code%TYPE,

190: p_detail_type IN VARCHAR2)
191: RETURN VARCHAR2;
192: TYPE phone_rec_type IS RECORD
193: (phone_number hz_contact_points.phone_number%TYPE,
194: area_code hz_contact_points.phone_area_code%TYPE,
195: extension hz_contact_points.phone_extension%TYPE);
196:
197: TYPE t_phone_table IS TABLE OF phone_rec_type
198: INDEX BY BINARY_INTEGER;

Line 195: extension hz_contact_points.phone_extension%TYPE);

191: RETURN VARCHAR2;
192: TYPE phone_rec_type IS RECORD
193: (phone_number hz_contact_points.phone_number%TYPE,
194: area_code hz_contact_points.phone_area_code%TYPE,
195: extension hz_contact_points.phone_extension%TYPE);
196:
197: TYPE t_phone_table IS TABLE OF phone_rec_type
198: INDEX BY BINARY_INTEGER;
199: