APPS.IRC_ISS_BUS dependencies on PER_ALL_VACANCIES

Line 91: -- Verifies that the vacancy_id exists in PER_ALL_VACANCIES_F.

87: -- |---------------------------< chk_vacancy_id >-----------------------------|
88: -- ----------------------------------------------------------------------------
89: --
90: -- Description:
91: -- Verifies that the vacancy_id exists in PER_ALL_VACANCIES_F.
92: --
93: -- Prerequisites:
94: -- Must be called as the first step in insert_validate.
95: --

Line 100: -- If vacancy_id exists in PER_ALL_VACANCIES_F, then continue.

96: -- In Arguments:
97: -- p_vacancy_id
98: --
99: -- Post Success:
100: -- If vacancy_id exists in PER_ALL_VACANCIES_F, then continue.
101: --
102: -- Post Failure:
103: -- If the p_vacancy_id does not exists in PER_ALL_VACANCIES_F, then throw
104: -- an error indicating the same.

Line 103: -- If the p_vacancy_id does not exists in PER_ALL_VACANCIES_F, then throw

99: -- Post Success:
100: -- If vacancy_id exists in PER_ALL_VACANCIES_F, then continue.
101: --
102: -- Post Failure:
103: -- If the p_vacancy_id does not exists in PER_ALL_VACANCIES_F, then throw
104: -- an error indicating the same.
105: --
106: -- Access Status:
107: -- Internal Row Handler Use Only.

Line 124: from per_all_vacancies

120: l_dummy varchar2(1);
121: --
122: cursor vacancy_exists(p_vacancy_id number) is
123: select null
124: from per_all_vacancies
125: where vacancy_id = p_vacancy_id;
126: --
127: Begin
128: --

Line 146: -- p_vacancy_id must exist in PER_ALL_VACANCIES_F

142: -- Check if p_vacancy_id is not null
143: --
144: if p_vacancy_id IS NOT NULL then
145: --
146: -- p_vacancy_id must exist in PER_ALL_VACANCIES_F
147: --
148: open vacancy_exists(p_vacancy_id);
149: fetch vacancy_exists into l_dummy;
150: --