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 2033: l_business_group_id per_all_vacancies.business_group_id%type;

2029: l_previous_last_name per_all_people_f.last_name%type;
2030: l_middle_name per_all_people_f.middle_names%type;
2031: l_name_suffix per_all_people_f.suffix%type;
2032: l_known_as per_all_people_f.known_as%type;
2033: l_business_group_id per_all_vacancies.business_group_id%type;
2034: l_organization_id per_all_vacancies.organization_id%type;
2035: l_job_id per_all_vacancies.job_id%type;
2036: l_position_id per_all_vacancies.position_id%type;
2037: l_manager_id per_all_vacancies.manager_id%type;

Line 2034: l_organization_id per_all_vacancies.organization_id%type;

2030: l_middle_name per_all_people_f.middle_names%type;
2031: l_name_suffix per_all_people_f.suffix%type;
2032: l_known_as per_all_people_f.known_as%type;
2033: l_business_group_id per_all_vacancies.business_group_id%type;
2034: l_organization_id per_all_vacancies.organization_id%type;
2035: l_job_id per_all_vacancies.job_id%type;
2036: l_position_id per_all_vacancies.position_id%type;
2037: l_manager_id per_all_vacancies.manager_id%type;
2038: l_grade_id per_all_vacancies.grade_id%type;

Line 2035: l_job_id per_all_vacancies.job_id%type;

2031: l_name_suffix per_all_people_f.suffix%type;
2032: l_known_as per_all_people_f.known_as%type;
2033: l_business_group_id per_all_vacancies.business_group_id%type;
2034: l_organization_id per_all_vacancies.organization_id%type;
2035: l_job_id per_all_vacancies.job_id%type;
2036: l_position_id per_all_vacancies.position_id%type;
2037: l_manager_id per_all_vacancies.manager_id%type;
2038: l_grade_id per_all_vacancies.grade_id%type;
2039: l_location_id per_all_vacancies.location_id%type;

Line 2036: l_position_id per_all_vacancies.position_id%type;

2032: l_known_as per_all_people_f.known_as%type;
2033: l_business_group_id per_all_vacancies.business_group_id%type;
2034: l_organization_id per_all_vacancies.organization_id%type;
2035: l_job_id per_all_vacancies.job_id%type;
2036: l_position_id per_all_vacancies.position_id%type;
2037: l_manager_id per_all_vacancies.manager_id%type;
2038: l_grade_id per_all_vacancies.grade_id%type;
2039: l_location_id per_all_vacancies.location_id%type;
2040: l_recruiter_id per_all_vacancies.recruiter_id%type;

Line 2037: l_manager_id per_all_vacancies.manager_id%type;

2033: l_business_group_id per_all_vacancies.business_group_id%type;
2034: l_organization_id per_all_vacancies.organization_id%type;
2035: l_job_id per_all_vacancies.job_id%type;
2036: l_position_id per_all_vacancies.position_id%type;
2037: l_manager_id per_all_vacancies.manager_id%type;
2038: l_grade_id per_all_vacancies.grade_id%type;
2039: l_location_id per_all_vacancies.location_id%type;
2040: l_recruiter_id per_all_vacancies.recruiter_id%type;
2041: l_people_group_id per_all_vacancies.people_group_id%type;

Line 2038: l_grade_id per_all_vacancies.grade_id%type;

2034: l_organization_id per_all_vacancies.organization_id%type;
2035: l_job_id per_all_vacancies.job_id%type;
2036: l_position_id per_all_vacancies.position_id%type;
2037: l_manager_id per_all_vacancies.manager_id%type;
2038: l_grade_id per_all_vacancies.grade_id%type;
2039: l_location_id per_all_vacancies.location_id%type;
2040: l_recruiter_id per_all_vacancies.recruiter_id%type;
2041: l_people_group_id per_all_vacancies.people_group_id%type;
2042: l_legislation_code per_business_groups.legislation_code%type;

Line 2039: l_location_id per_all_vacancies.location_id%type;

2035: l_job_id per_all_vacancies.job_id%type;
2036: l_position_id per_all_vacancies.position_id%type;
2037: l_manager_id per_all_vacancies.manager_id%type;
2038: l_grade_id per_all_vacancies.grade_id%type;
2039: l_location_id per_all_vacancies.location_id%type;
2040: l_recruiter_id per_all_vacancies.recruiter_id%type;
2041: l_people_group_id per_all_vacancies.people_group_id%type;
2042: l_legislation_code per_business_groups.legislation_code%type;
2043: --

Line 2040: l_recruiter_id per_all_vacancies.recruiter_id%type;

2036: l_position_id per_all_vacancies.position_id%type;
2037: l_manager_id per_all_vacancies.manager_id%type;
2038: l_grade_id per_all_vacancies.grade_id%type;
2039: l_location_id per_all_vacancies.location_id%type;
2040: l_recruiter_id per_all_vacancies.recruiter_id%type;
2041: l_people_group_id per_all_vacancies.people_group_id%type;
2042: l_legislation_code per_business_groups.legislation_code%type;
2043: --
2044: -- variables for hr_person_api.update_person

Line 2041: l_people_group_id per_all_vacancies.people_group_id%type;

2037: l_manager_id per_all_vacancies.manager_id%type;
2038: l_grade_id per_all_vacancies.grade_id%type;
2039: l_location_id per_all_vacancies.location_id%type;
2040: l_recruiter_id per_all_vacancies.recruiter_id%type;
2041: l_people_group_id per_all_vacancies.people_group_id%type;
2042: l_legislation_code per_business_groups.legislation_code%type;
2043: --
2044: -- variables for hr_person_api.update_person
2045: --

Line 2142: from per_all_vacancies

2138: ,people_group_id
2139: ,location_id
2140: ,recruiter_id
2141: ,manager_id
2142: from per_all_vacancies
2143: where vacancy_id = p_vacancy_id;
2144: --
2145: cursor get_new_asg(p_person_id number, p_effective_date date) is
2146: select assignment_id,object_version_number