APPS.IRC_ISC_BUS dependencies on PER_ALL_VACANCIES

Line 1146: -- This procedure ensures that vacancy_id exists in per_all_vacancies.

1142: -- ----------------------------------------------------------------------------
1143: -- {Start Of Comments}
1144: --
1145: -- Description:
1146: -- This procedure ensures that vacancy_id exists in per_all_vacancies.
1147: --
1148: -- Pre Conditions:
1149: -- g_old_rec has been populated with details of the values currently in
1150: -- the database.

Line 1173: select null from per_all_vacancies pav

1169: l_proc varchar2(72) := g_package || 'chk_vacancy_id';
1170: l_vacancy_id varchar2(1);
1171: --
1172: cursor csr_vacancy_id is
1173: select null from per_all_vacancies pav
1174: where pav.vacancy_id = p_vacancy_id;
1175: --
1176: begin
1177: hr_utility.set_location('Entering:'||l_proc,10);

Line 1184: -- Check that vacancy_id exists in per_all_vacancies.

1180: (p_api_name => l_proc
1181: ,p_argument => 'VACANCY_ID'
1182: ,p_argument_value => p_vacancy_id
1183: );
1184: -- Check that vacancy_id exists in per_all_vacancies.
1185: hr_utility.set_location(l_proc,20);
1186: open csr_vacancy_id;
1187: fetch csr_vacancy_id into l_vacancy_id;
1188: hr_utility.set_location(l_proc,30);