eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IRC_IVC_BUS dependencies on PER_ALL_VACANCIES

Line 168: -- If the vacancy id is not found in per_all_vacancies an error is generated.

164: -- {Start Of Comments}
165: --
166: -- Description:
167: -- This procedure is used to ensure that mandatory parameters have been set.
168: -- If the vacancy id is not found in per_all_vacancies an error is generated.
169: --
170: -- Pre Conditions:
171: -- g_old_rec has been populated with details of the values currently in
172: -- the database.

Line 195: l_date_from per_all_vacancies.date_from%type;

191: ,p_effective_date date
192: ) IS
193: --
194: l_proc varchar2(72) := g_package || 'chk_vacancy_id';
195: l_date_from per_all_vacancies.date_from%type;
196: l_date_to per_all_vacancies.date_to%type;
197: --
198: --
199: -- Cursor to check if the vacancy is future-dated or past-dated

Line 196: l_date_to per_all_vacancies.date_to%type;

192: ) IS
193: --
194: l_proc varchar2(72) := g_package || 'chk_vacancy_id';
195: l_date_from per_all_vacancies.date_from%type;
196: l_date_to per_all_vacancies.date_to%type;
197: --
198: --
199: -- Cursor to check if the vacancy is future-dated or past-dated
200: -- and display the appropriate error messages

Line 205: from per_all_vacancies

201: --
202: cursor csr_vacancy_dates is
203: select date_from
204: ,date_to
205: from per_all_vacancies
206: where vacancy_id = p_vacancy_id;
207: --
208: --
209: Begin