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_PARTY_API dependencies on PER_ALL_VACANCIES

Line 2059: l_business_group_id per_all_vacancies.business_group_id%type;

2055: l_previous_last_name per_all_people_f.last_name%type;
2056: l_middle_name per_all_people_f.middle_names%type;
2057: l_name_suffix per_all_people_f.suffix%type;
2058: l_known_as per_all_people_f.known_as%type;
2059: l_business_group_id per_all_vacancies.business_group_id%type;
2060: l_organization_id per_all_vacancies.organization_id%type;
2061: l_job_id per_all_vacancies.job_id%type;
2062: l_position_id per_all_vacancies.position_id%type;
2063: l_manager_id per_all_vacancies.manager_id%type;

Line 2060: l_organization_id per_all_vacancies.organization_id%type;

2056: l_middle_name per_all_people_f.middle_names%type;
2057: l_name_suffix per_all_people_f.suffix%type;
2058: l_known_as per_all_people_f.known_as%type;
2059: l_business_group_id per_all_vacancies.business_group_id%type;
2060: l_organization_id per_all_vacancies.organization_id%type;
2061: l_job_id per_all_vacancies.job_id%type;
2062: l_position_id per_all_vacancies.position_id%type;
2063: l_manager_id per_all_vacancies.manager_id%type;
2064: l_grade_id per_all_vacancies.grade_id%type;

Line 2061: l_job_id per_all_vacancies.job_id%type;

2057: l_name_suffix per_all_people_f.suffix%type;
2058: l_known_as per_all_people_f.known_as%type;
2059: l_business_group_id per_all_vacancies.business_group_id%type;
2060: l_organization_id per_all_vacancies.organization_id%type;
2061: l_job_id per_all_vacancies.job_id%type;
2062: l_position_id per_all_vacancies.position_id%type;
2063: l_manager_id per_all_vacancies.manager_id%type;
2064: l_grade_id per_all_vacancies.grade_id%type;
2065: l_location_id per_all_vacancies.location_id%type;

Line 2062: l_position_id per_all_vacancies.position_id%type;

2058: l_known_as per_all_people_f.known_as%type;
2059: l_business_group_id per_all_vacancies.business_group_id%type;
2060: l_organization_id per_all_vacancies.organization_id%type;
2061: l_job_id per_all_vacancies.job_id%type;
2062: l_position_id per_all_vacancies.position_id%type;
2063: l_manager_id per_all_vacancies.manager_id%type;
2064: l_grade_id per_all_vacancies.grade_id%type;
2065: l_location_id per_all_vacancies.location_id%type;
2066: l_recruiter_id per_all_vacancies.recruiter_id%type;

Line 2063: l_manager_id per_all_vacancies.manager_id%type;

2059: l_business_group_id per_all_vacancies.business_group_id%type;
2060: l_organization_id per_all_vacancies.organization_id%type;
2061: l_job_id per_all_vacancies.job_id%type;
2062: l_position_id per_all_vacancies.position_id%type;
2063: l_manager_id per_all_vacancies.manager_id%type;
2064: l_grade_id per_all_vacancies.grade_id%type;
2065: l_location_id per_all_vacancies.location_id%type;
2066: l_recruiter_id per_all_vacancies.recruiter_id%type;
2067: l_people_group_id per_all_vacancies.people_group_id%type;

Line 2064: l_grade_id per_all_vacancies.grade_id%type;

2060: l_organization_id per_all_vacancies.organization_id%type;
2061: l_job_id per_all_vacancies.job_id%type;
2062: l_position_id per_all_vacancies.position_id%type;
2063: l_manager_id per_all_vacancies.manager_id%type;
2064: l_grade_id per_all_vacancies.grade_id%type;
2065: l_location_id per_all_vacancies.location_id%type;
2066: l_recruiter_id per_all_vacancies.recruiter_id%type;
2067: l_people_group_id per_all_vacancies.people_group_id%type;
2068: l_legislation_code per_business_groups.legislation_code%type;

Line 2065: l_location_id per_all_vacancies.location_id%type;

2061: l_job_id per_all_vacancies.job_id%type;
2062: l_position_id per_all_vacancies.position_id%type;
2063: l_manager_id per_all_vacancies.manager_id%type;
2064: l_grade_id per_all_vacancies.grade_id%type;
2065: l_location_id per_all_vacancies.location_id%type;
2066: l_recruiter_id per_all_vacancies.recruiter_id%type;
2067: l_people_group_id per_all_vacancies.people_group_id%type;
2068: l_legislation_code per_business_groups.legislation_code%type;
2069: --

Line 2066: l_recruiter_id per_all_vacancies.recruiter_id%type;

2062: l_position_id per_all_vacancies.position_id%type;
2063: l_manager_id per_all_vacancies.manager_id%type;
2064: l_grade_id per_all_vacancies.grade_id%type;
2065: l_location_id per_all_vacancies.location_id%type;
2066: l_recruiter_id per_all_vacancies.recruiter_id%type;
2067: l_people_group_id per_all_vacancies.people_group_id%type;
2068: l_legislation_code per_business_groups.legislation_code%type;
2069: --
2070: -- variables for hr_person_api.update_person

Line 2067: l_people_group_id per_all_vacancies.people_group_id%type;

2063: l_manager_id per_all_vacancies.manager_id%type;
2064: l_grade_id per_all_vacancies.grade_id%type;
2065: l_location_id per_all_vacancies.location_id%type;
2066: l_recruiter_id per_all_vacancies.recruiter_id%type;
2067: l_people_group_id per_all_vacancies.people_group_id%type;
2068: l_legislation_code per_business_groups.legislation_code%type;
2069: --
2070: -- variables for hr_person_api.update_person
2071: --

Line 2173: from per_all_vacancies

2169: ,people_group_id
2170: ,location_id
2171: ,recruiter_id
2172: ,manager_id
2173: from per_all_vacancies
2174: where vacancy_id = p_vacancy_id;
2175: --
2176: cursor get_new_asg(p_person_id number, p_effective_date date) is
2177: select assignment_id,object_version_number

Line 5723: per_all_vacancies pav

5719: Cursor csr_view_all_apl_count is
5720: select count(pav.vacancy_id)
5721: from per_all_people_f ppf,
5722: per_all_assignments_f paf,
5723: per_all_vacancies pav
5724: where ppf.party_id = p_party_id
5725: and paf.person_id = ppf.person_id
5726: and trunc(sysdate) between paf.effective_start_date and paf.effective_end_date
5727: and trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date

Line 6194: l_job_id per_all_vacancies.job_id%type;

6190: l_previous_last_name per_all_people_f.last_name%type;
6191: l_middle_name per_all_people_f.middle_names%type;
6192: l_name_suffix per_all_people_f.suffix%type;
6193: l_known_as per_all_people_f.known_as%type;
6194: l_job_id per_all_vacancies.job_id%type;
6195: l_position_id per_all_vacancies.position_id%type;
6196: l_grade_id per_all_vacancies.grade_id%type;
6197: l_location_id per_all_vacancies.location_id%type;
6198: l_recruiter_id per_all_vacancies.recruiter_id%type;

Line 6195: l_position_id per_all_vacancies.position_id%type;

6191: l_middle_name per_all_people_f.middle_names%type;
6192: l_name_suffix per_all_people_f.suffix%type;
6193: l_known_as per_all_people_f.known_as%type;
6194: l_job_id per_all_vacancies.job_id%type;
6195: l_position_id per_all_vacancies.position_id%type;
6196: l_grade_id per_all_vacancies.grade_id%type;
6197: l_location_id per_all_vacancies.location_id%type;
6198: l_recruiter_id per_all_vacancies.recruiter_id%type;
6199: l_people_group_id per_all_vacancies.people_group_id%type;

Line 6196: l_grade_id per_all_vacancies.grade_id%type;

6192: l_name_suffix per_all_people_f.suffix%type;
6193: l_known_as per_all_people_f.known_as%type;
6194: l_job_id per_all_vacancies.job_id%type;
6195: l_position_id per_all_vacancies.position_id%type;
6196: l_grade_id per_all_vacancies.grade_id%type;
6197: l_location_id per_all_vacancies.location_id%type;
6198: l_recruiter_id per_all_vacancies.recruiter_id%type;
6199: l_people_group_id per_all_vacancies.people_group_id%type;
6200: l_legislation_code per_business_groups.legislation_code%type;

Line 6197: l_location_id per_all_vacancies.location_id%type;

6193: l_known_as per_all_people_f.known_as%type;
6194: l_job_id per_all_vacancies.job_id%type;
6195: l_position_id per_all_vacancies.position_id%type;
6196: l_grade_id per_all_vacancies.grade_id%type;
6197: l_location_id per_all_vacancies.location_id%type;
6198: l_recruiter_id per_all_vacancies.recruiter_id%type;
6199: l_people_group_id per_all_vacancies.people_group_id%type;
6200: l_legislation_code per_business_groups.legislation_code%type;
6201: l_effective_date date;

Line 6198: l_recruiter_id per_all_vacancies.recruiter_id%type;

6194: l_job_id per_all_vacancies.job_id%type;
6195: l_position_id per_all_vacancies.position_id%type;
6196: l_grade_id per_all_vacancies.grade_id%type;
6197: l_location_id per_all_vacancies.location_id%type;
6198: l_recruiter_id per_all_vacancies.recruiter_id%type;
6199: l_people_group_id per_all_vacancies.people_group_id%type;
6200: l_legislation_code per_business_groups.legislation_code%type;
6201: l_effective_date date;
6202: --

Line 6199: l_people_group_id per_all_vacancies.people_group_id%type;

6195: l_position_id per_all_vacancies.position_id%type;
6196: l_grade_id per_all_vacancies.grade_id%type;
6197: l_location_id per_all_vacancies.location_id%type;
6198: l_recruiter_id per_all_vacancies.recruiter_id%type;
6199: l_people_group_id per_all_vacancies.people_group_id%type;
6200: l_legislation_code per_business_groups.legislation_code%type;
6201: l_effective_date date;
6202: --
6203: -- variables for hr_person_api.update_person