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 PER_ALL_VACANCIES

Line 179: , location_id per_all_vacancies.location_id%TYPE

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

Line 182: , business_group_id per_all_vacancies.business_group_id%TYPE

178: , geometry hr_locations_all.geometry%TYPE
179: , location_id per_all_vacancies.location_id%TYPE
180: , derived_locale hr_locations_all.derived_locale%TYPE
181: , posting_content_id irc_posting_contents_tl.posting_content_id%TYPE
182: , business_group_id per_all_vacancies.business_group_id%TYPE
183: , name per_all_vacancies.name%TYPE
184: , recruiter_id per_all_vacancies.recruiter_id%type
185: );
186:

Line 183: , name per_all_vacancies.name%TYPE

179: , location_id per_all_vacancies.location_id%TYPE
180: , derived_locale hr_locations_all.derived_locale%TYPE
181: , posting_content_id irc_posting_contents_tl.posting_content_id%TYPE
182: , business_group_id per_all_vacancies.business_group_id%TYPE
183: , name per_all_vacancies.name%TYPE
184: , recruiter_id per_all_vacancies.recruiter_id%type
185: );
186:
187: TYPE g_posting_details_rec_type

Line 184: , recruiter_id per_all_vacancies.recruiter_id%type

180: , derived_locale hr_locations_all.derived_locale%TYPE
181: , posting_content_id irc_posting_contents_tl.posting_content_id%TYPE
182: , business_group_id per_all_vacancies.business_group_id%TYPE
183: , name per_all_vacancies.name%TYPE
184: , recruiter_id per_all_vacancies.recruiter_id%type
185: );
186:
187: TYPE g_posting_details_rec_type
188: IS RECORD ( posting_content_id irc_posting_contents.posting_content_id%TYPE

Line 208: IS RECORD ( recruiter_id per_all_vacancies.recruiter_id%TYPE

204: g_seeker_details_rec_type
205: INDEX BY BINARY_INTEGER;
206:
207: TYPE g_recruiter_problem_rec_type
208: IS RECORD ( recruiter_id per_all_vacancies.recruiter_id%TYPE
209: , vacancy_id per_all_vacancies.vacancy_id%TYPE
210: , vacancy_name per_all_vacancies.name%TYPE
211: , sqlerrm varchar2(2000)
212: , message varchar2(2000)

Line 209: , vacancy_id per_all_vacancies.vacancy_id%TYPE

205: INDEX BY BINARY_INTEGER;
206:
207: TYPE g_recruiter_problem_rec_type
208: IS RECORD ( recruiter_id per_all_vacancies.recruiter_id%TYPE
209: , vacancy_id per_all_vacancies.vacancy_id%TYPE
210: , vacancy_name per_all_vacancies.name%TYPE
211: , sqlerrm varchar2(2000)
212: , message varchar2(2000)
213: );

Line 210: , vacancy_name per_all_vacancies.name%TYPE

206:
207: TYPE g_recruiter_problem_rec_type
208: IS RECORD ( recruiter_id per_all_vacancies.recruiter_id%TYPE
209: , vacancy_id per_all_vacancies.vacancy_id%TYPE
210: , vacancy_name per_all_vacancies.name%TYPE
211: , sqlerrm varchar2(2000)
212: , message varchar2(2000)
213: );
214: