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.HR_EMPLOYEE_API dependencies on PER_VACANCIES

Line 3636: l_recruiter_id per_vacancies.recruiter_id%type;

3632: l_default_start_time per_business_groups.default_start_time%type;
3633: l_default_end_time per_business_groups.default_end_time%type;
3634: l_normal_hours number;
3635: l_frequency per_business_groups.frequency%type;
3636: l_recruiter_id per_vacancies.recruiter_id%type;
3637: l_grade_id per_vacancies.grade_id%type;
3638: l_position_id per_vacancies.position_id%type;
3639: l_job_id per_vacancies.job_id%type;
3640: l_location_id per_vacancies.location_id%type;

Line 3637: l_grade_id per_vacancies.grade_id%type;

3633: l_default_end_time per_business_groups.default_end_time%type;
3634: l_normal_hours number;
3635: l_frequency per_business_groups.frequency%type;
3636: l_recruiter_id per_vacancies.recruiter_id%type;
3637: l_grade_id per_vacancies.grade_id%type;
3638: l_position_id per_vacancies.position_id%type;
3639: l_job_id per_vacancies.job_id%type;
3640: l_location_id per_vacancies.location_id%type;
3641: l_people_group_id per_vacancies.people_group_id%type;

Line 3638: l_position_id per_vacancies.position_id%type;

3634: l_normal_hours number;
3635: l_frequency per_business_groups.frequency%type;
3636: l_recruiter_id per_vacancies.recruiter_id%type;
3637: l_grade_id per_vacancies.grade_id%type;
3638: l_position_id per_vacancies.position_id%type;
3639: l_job_id per_vacancies.job_id%type;
3640: l_location_id per_vacancies.location_id%type;
3641: l_people_group_id per_vacancies.people_group_id%type;
3642: l_vac_organization_id per_vacancies.organization_id%type;

Line 3639: l_job_id per_vacancies.job_id%type;

3635: l_frequency per_business_groups.frequency%type;
3636: l_recruiter_id per_vacancies.recruiter_id%type;
3637: l_grade_id per_vacancies.grade_id%type;
3638: l_position_id per_vacancies.position_id%type;
3639: l_job_id per_vacancies.job_id%type;
3640: l_location_id per_vacancies.location_id%type;
3641: l_people_group_id per_vacancies.people_group_id%type;
3642: l_vac_organization_id per_vacancies.organization_id%type;
3643: l_vac_business_group_id per_vacancies.business_group_id%type;

Line 3640: l_location_id per_vacancies.location_id%type;

3636: l_recruiter_id per_vacancies.recruiter_id%type;
3637: l_grade_id per_vacancies.grade_id%type;
3638: l_position_id per_vacancies.position_id%type;
3639: l_job_id per_vacancies.job_id%type;
3640: l_location_id per_vacancies.location_id%type;
3641: l_people_group_id per_vacancies.people_group_id%type;
3642: l_vac_organization_id per_vacancies.organization_id%type;
3643: l_vac_business_group_id per_vacancies.business_group_id%type;
3644: l_group_name pay_people_groups.group_name%type;

Line 3641: l_people_group_id per_vacancies.people_group_id%type;

3637: l_grade_id per_vacancies.grade_id%type;
3638: l_position_id per_vacancies.position_id%type;
3639: l_job_id per_vacancies.job_id%type;
3640: l_location_id per_vacancies.location_id%type;
3641: l_people_group_id per_vacancies.people_group_id%type;
3642: l_vac_organization_id per_vacancies.organization_id%type;
3643: l_vac_business_group_id per_vacancies.business_group_id%type;
3644: l_group_name pay_people_groups.group_name%type;
3645: l_appl_override_warning boolean;

Line 3642: l_vac_organization_id per_vacancies.organization_id%type;

3638: l_position_id per_vacancies.position_id%type;
3639: l_job_id per_vacancies.job_id%type;
3640: l_location_id per_vacancies.location_id%type;
3641: l_people_group_id per_vacancies.people_group_id%type;
3642: l_vac_organization_id per_vacancies.organization_id%type;
3643: l_vac_business_group_id per_vacancies.business_group_id%type;
3644: l_group_name pay_people_groups.group_name%type;
3645: l_appl_override_warning boolean;
3646: --

Line 3643: l_vac_business_group_id per_vacancies.business_group_id%type;

3639: l_job_id per_vacancies.job_id%type;
3640: l_location_id per_vacancies.location_id%type;
3641: l_people_group_id per_vacancies.people_group_id%type;
3642: l_vac_organization_id per_vacancies.organization_id%type;
3643: l_vac_business_group_id per_vacancies.business_group_id%type;
3644: l_group_name pay_people_groups.group_name%type;
3645: l_appl_override_warning boolean;
3646: --
3647: -- Local variable added for the before and after business process

Line 3707: from per_vacancies

3703: ,location_id
3704: ,people_group_id
3705: ,organization_id -- added org id to cursor. thayden 7/10.
3706: ,business_group_id -- added business_group_id to cursor lma 7/11
3707: from per_vacancies
3708: where vacancy_id = p_vacancy_id;
3709: --
3710: begin
3711: -- Bug 665566 Savepoint issued before validations start