APPS.PER_VACANCY_API dependencies on PER_VAC_SHD

Line 574: if (p_organization_id <> per_vac_shd.g_old_rec.organization_id)

570: -- look to see if the assignment needs updating
571: --
572: l_ASSIGNMENT_CHANGED := FALSE;
573: --
574: if (p_organization_id <> per_vac_shd.g_old_rec.organization_id)
575: and (p_organization_id <> hr_api.g_number)
576: then
577: l_ASSIGNMENT_CHANGED := TRUE;
578: l_organization_id := p_organization_id;

Line 582: if (p_job_id <> per_vac_shd.g_old_rec.job_id)

578: l_organization_id := p_organization_id;
579: l_position_id := p_position_id;
580: end if;
581: --
582: if (p_job_id <> per_vac_shd.g_old_rec.job_id)
583: and (p_job_id <> hr_api.g_number)
584: then
585: l_ASSIGNMENT_CHANGED := TRUE;
586: l_job_id := p_job_id;

Line 590: if (p_grade_id <> per_vac_shd.g_old_rec.grade_id)

586: l_job_id := p_job_id;
587: l_position_id := p_position_id;
588: end if;
589: --
590: if (p_grade_id <> per_vac_shd.g_old_rec.grade_id)
591: and (p_grade_id <> hr_api.g_number)
592: then
593: l_ASSIGNMENT_CHANGED := TRUE;
594: l_grade_id := p_grade_id;

Line 597: if (p_people_group_id <> per_vac_shd.g_old_rec.people_group_id)

593: l_ASSIGNMENT_CHANGED := TRUE;
594: l_grade_id := p_grade_id;
595: end if;
596: --
597: if (p_people_group_id <> per_vac_shd.g_old_rec.people_group_id)
598: and (p_people_group_id <> hr_api.g_number)
599: then
600: l_ASSIGNMENT_CHANGED := TRUE;
601: l_people_group_id := p_people_group_id;

Line 604: if (p_position_id <> per_vac_shd.g_old_rec.position_id)

600: l_ASSIGNMENT_CHANGED := TRUE;
601: l_people_group_id := p_people_group_id;
602: end if;
603: --
604: if (p_position_id <> per_vac_shd.g_old_rec.position_id)
605: and (p_position_id <> hr_api.g_number)
606: then
607: l_ASSIGNMENT_CHANGED := TRUE;
608: l_position_id := p_position_id;

Line 611: if (p_location_id <> per_vac_shd.g_old_rec.location_id)

607: l_ASSIGNMENT_CHANGED := TRUE;
608: l_position_id := p_position_id;
609: end if;
610: --
611: if (p_location_id <> per_vac_shd.g_old_rec.location_id)
612: and (p_location_id <> hr_api.g_number)
613: then
614: l_ASSIGNMENT_CHANGED := TRUE;
615: l_location_id := p_location_id;

Line 618: if (p_recruiter_id <> per_vac_shd.g_old_rec.recruiter_id)

614: l_ASSIGNMENT_CHANGED := TRUE;
615: l_location_id := p_location_id;
616: end if;
617: --
618: if (p_recruiter_id <> per_vac_shd.g_old_rec.recruiter_id)
619: and (p_recruiter_id <> hr_api.g_number)
620: then
621: l_ASSIGNMENT_CHANGED := TRUE;
622: l_recruiter_id := p_recruiter_id;

Line 625: if (p_manager_id <> per_vac_shd.g_old_rec.manager_id)

621: l_ASSIGNMENT_CHANGED := TRUE;
622: l_recruiter_id := p_recruiter_id;
623: end if;
624: --
625: if (p_manager_id <> per_vac_shd.g_old_rec.manager_id)
626: and (p_manager_id <> hr_api.g_number)
627: then
628: l_ASSIGNMENT_CHANGED := TRUE;
629: l_manager_id := p_manager_id;

Line 648: per_vac_shd.g_old_rec.organization_id||'.'||per_vac_shd.g_old_rec.job_id,

644: ,asg.recruiter_id = nvl(l_recruiter_id, asg.recruiter_id)
645: ,asg.supervisor_id = nvl(l_manager_id, asg.supervisor_id)
646: ,asg.position_id = decode
647: (l_organization_id||'.'||l_job_id,
648: per_vac_shd.g_old_rec.organization_id||'.'||per_vac_shd.g_old_rec.job_id,
649: nvl(l_position_id, asg.position_id),
650: l_position_id)
651: where asg.assignment_type = 'A'
652: and asg.vacancy_id = p_vacancy_id