DBA Data[Home] [Help]

APPS.HR_EMPLOYEE_API dependencies on PER_VACANCIES

Line 3324: l_recruiter_id per_vacancies.recruiter_id%type;

3320: l_default_start_time per_business_groups.default_start_time%type;
3321: l_default_end_time per_business_groups.default_end_time%type;
3322: l_normal_hours number;
3323: l_frequency per_business_groups.frequency%type;
3324: l_recruiter_id per_vacancies.recruiter_id%type;
3325: l_grade_id per_vacancies.grade_id%type;
3326: l_position_id per_vacancies.position_id%type;
3327: l_job_id per_vacancies.job_id%type;
3328: l_location_id per_vacancies.location_id%type;

Line 3325: l_grade_id per_vacancies.grade_id%type;

3321: l_default_end_time per_business_groups.default_end_time%type;
3322: l_normal_hours number;
3323: l_frequency per_business_groups.frequency%type;
3324: l_recruiter_id per_vacancies.recruiter_id%type;
3325: l_grade_id per_vacancies.grade_id%type;
3326: l_position_id per_vacancies.position_id%type;
3327: l_job_id per_vacancies.job_id%type;
3328: l_location_id per_vacancies.location_id%type;
3329: l_people_group_id per_vacancies.people_group_id%type;

Line 3326: l_position_id per_vacancies.position_id%type;

3322: l_normal_hours number;
3323: l_frequency per_business_groups.frequency%type;
3324: l_recruiter_id per_vacancies.recruiter_id%type;
3325: l_grade_id per_vacancies.grade_id%type;
3326: l_position_id per_vacancies.position_id%type;
3327: l_job_id per_vacancies.job_id%type;
3328: l_location_id per_vacancies.location_id%type;
3329: l_people_group_id per_vacancies.people_group_id%type;
3330: l_vac_organization_id per_vacancies.organization_id%type;

Line 3327: l_job_id per_vacancies.job_id%type;

3323: l_frequency per_business_groups.frequency%type;
3324: l_recruiter_id per_vacancies.recruiter_id%type;
3325: l_grade_id per_vacancies.grade_id%type;
3326: l_position_id per_vacancies.position_id%type;
3327: l_job_id per_vacancies.job_id%type;
3328: l_location_id per_vacancies.location_id%type;
3329: l_people_group_id per_vacancies.people_group_id%type;
3330: l_vac_organization_id per_vacancies.organization_id%type;
3331: l_vac_business_group_id per_vacancies.business_group_id%type;

Line 3328: l_location_id per_vacancies.location_id%type;

3324: l_recruiter_id per_vacancies.recruiter_id%type;
3325: l_grade_id per_vacancies.grade_id%type;
3326: l_position_id per_vacancies.position_id%type;
3327: l_job_id per_vacancies.job_id%type;
3328: l_location_id per_vacancies.location_id%type;
3329: l_people_group_id per_vacancies.people_group_id%type;
3330: l_vac_organization_id per_vacancies.organization_id%type;
3331: l_vac_business_group_id per_vacancies.business_group_id%type;
3332: l_group_name pay_people_groups.group_name%type;

Line 3329: l_people_group_id per_vacancies.people_group_id%type;

3325: l_grade_id per_vacancies.grade_id%type;
3326: l_position_id per_vacancies.position_id%type;
3327: l_job_id per_vacancies.job_id%type;
3328: l_location_id per_vacancies.location_id%type;
3329: l_people_group_id per_vacancies.people_group_id%type;
3330: l_vac_organization_id per_vacancies.organization_id%type;
3331: l_vac_business_group_id per_vacancies.business_group_id%type;
3332: l_group_name pay_people_groups.group_name%type;
3333: l_appl_override_warning boolean;

Line 3330: l_vac_organization_id per_vacancies.organization_id%type;

3326: l_position_id per_vacancies.position_id%type;
3327: l_job_id per_vacancies.job_id%type;
3328: l_location_id per_vacancies.location_id%type;
3329: l_people_group_id per_vacancies.people_group_id%type;
3330: l_vac_organization_id per_vacancies.organization_id%type;
3331: l_vac_business_group_id per_vacancies.business_group_id%type;
3332: l_group_name pay_people_groups.group_name%type;
3333: l_appl_override_warning boolean;
3334: --

Line 3331: l_vac_business_group_id per_vacancies.business_group_id%type;

3327: l_job_id per_vacancies.job_id%type;
3328: l_location_id per_vacancies.location_id%type;
3329: l_people_group_id per_vacancies.people_group_id%type;
3330: l_vac_organization_id per_vacancies.organization_id%type;
3331: l_vac_business_group_id per_vacancies.business_group_id%type;
3332: l_group_name pay_people_groups.group_name%type;
3333: l_appl_override_warning boolean;
3334: --
3335: -- Local variable added for the before and after business process

Line 3395: from per_vacancies

3391: ,location_id
3392: ,people_group_id
3393: ,organization_id -- added org id to cursor. thayden 7/10.
3394: ,business_group_id -- added business_group_id to cursor lma 7/11
3395: from per_vacancies
3396: where vacancy_id = p_vacancy_id;
3397: --
3398: begin
3399: -- Bug 665566 Savepoint issued before validations start