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 180: , location_id per_all_vacancies.location_id%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
184: , name per_all_vacancies.name%TYPE

Line 183: , business_group_id per_all_vacancies.business_group_id%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
186: );
187:

Line 184: , name per_all_vacancies.name%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
186: );
187:
188: TYPE g_posting_details_rec_type

Line 185: , recruiter_id per_all_vacancies.recruiter_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
186: );
187:
188: TYPE g_posting_details_rec_type
189: IS RECORD ( posting_content_id irc_posting_contents.posting_content_id%TYPE

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

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

Line 210: , vacancy_id per_all_vacancies.vacancy_id%TYPE

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

Line 211: , vacancy_name per_all_vacancies.name%TYPE

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