APPS.IRC_CMP_BUS dependencies on PER_ALL_VACANCIES

Line 767: -- 1) that object_id exists in PER_ALL_VACANCIES

763: -- {Start Of Comments}
764: --
765: -- Description:
766: -- This procedure is used to ensure-
767: -- 1) that object_id exists in PER_ALL_VACANCIES
768: -- when the object_type is 'VACANCY'
769: -- 2) that combination of (object_id,object_type) is
770: -- unique.
771:

Line 796: from per_all_vacancies pav

792: l_object_type varchar2(1);
793: --
794: cursor csr_object_id is
795: select null
796: from per_all_vacancies pav
797: where pav.vacancy_id = p_object_id ;
798: --
799: cursor csr_object_type is
800: select null

Line 813: -- Check that object_id exists in per_all_vacancies

809: (p_api_name => l_proc
810: ,p_argument => 'OBJECT_ID'
811: ,p_argument_value => p_object_id
812: );
813: -- Check that object_id exists in per_all_vacancies
814: hr_utility.set_location(l_proc,20);
815: open csr_object_id;
816: fetch csr_object_id into l_object_id;
817: hr_utility.set_location(l_proc,30);