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.IRC_SEEKER_VAC_MATCHING_PKG dependencies on HR_LOCATIONS_ALL

Line 179: , geometry hr_locations_all.geometry%TYPE

175: , isc_information27 irc_search_criteria.isc_information27%TYPE
176: , isc_information28 irc_search_criteria.isc_information28%TYPE
177: , isc_information29 irc_search_criteria.isc_information29%TYPE
178: , isc_information30 irc_search_criteria.isc_information30%TYPE
179: , geometry hr_locations_all.geometry%TYPE
180: , location_id per_all_vacancies.location_id%TYPE
181: , derived_locale hr_locations_all.derived_locale%TYPE
182: , posting_content_id irc_posting_contents_tl.posting_content_id%TYPE
183: , business_group_id per_all_vacancies.business_group_id%TYPE

Line 181: , derived_locale hr_locations_all.derived_locale%TYPE

177: , isc_information29 irc_search_criteria.isc_information29%TYPE
178: , isc_information30 irc_search_criteria.isc_information30%TYPE
179: , geometry hr_locations_all.geometry%TYPE
180: , location_id per_all_vacancies.location_id%TYPE
181: , derived_locale hr_locations_all.derived_locale%TYPE
182: , posting_content_id irc_posting_contents_tl.posting_content_id%TYPE
183: , business_group_id per_all_vacancies.business_group_id%TYPE
184: , name per_all_vacancies.name%TYPE
185: , recruiter_id per_all_vacancies.recruiter_id%type

Line 229: p_location_id IN hr_locations_all.LOCATION_ID%TYPE)

225: -- FUNCTIONS
226: -- ----------------------------------------------------------------------------
227: FUNCTION get_location_match
228: ( p_location_to_match IN varchar2,
229: p_location_id IN hr_locations_all.LOCATION_ID%TYPE)
230: RETURN number;
231:
232: FUNCTION convert_vacancy_amount
233: (p_from_currency IN VARCHAR2