APPS.PER_VAC_BUS dependencies on PER_VAC_SHD

Line 180: (p_rec in per_vac_shd.g_rec_type

176: -- Internal Row Handler Use Only.
177: --
178: -- ----------------------------------------------------------------------------
179: procedure chk_df
180: (p_rec in per_vac_shd.g_rec_type
181: ) is
182: --
183: l_proc varchar2(72) := g_package || 'chk_df';
184: --

Line 189: nvl(per_vac_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

185: begin
186: hr_utility.set_location('Entering:'||l_proc,10);
187: --
188: if ((p_rec.vacancy_id is not null) and (
189: nvl(per_vac_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
190: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
191: nvl(per_vac_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute1, hr_api.g_varchar2) or
193: nvl(per_vac_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 191: nvl(per_vac_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

187: --
188: if ((p_rec.vacancy_id is not null) and (
189: nvl(per_vac_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
190: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
191: nvl(per_vac_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute1, hr_api.g_varchar2) or
193: nvl(per_vac_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute2, hr_api.g_varchar2) or
195: nvl(per_vac_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 193: nvl(per_vac_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

189: nvl(per_vac_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
190: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
191: nvl(per_vac_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute1, hr_api.g_varchar2) or
193: nvl(per_vac_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute2, hr_api.g_varchar2) or
195: nvl(per_vac_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute3, hr_api.g_varchar2) or
197: nvl(per_vac_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 195: nvl(per_vac_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

191: nvl(per_vac_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute1, hr_api.g_varchar2) or
193: nvl(per_vac_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute2, hr_api.g_varchar2) or
195: nvl(per_vac_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute3, hr_api.g_varchar2) or
197: nvl(per_vac_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute4, hr_api.g_varchar2) or
199: nvl(per_vac_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 197: nvl(per_vac_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

193: nvl(per_vac_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute2, hr_api.g_varchar2) or
195: nvl(per_vac_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute3, hr_api.g_varchar2) or
197: nvl(per_vac_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute4, hr_api.g_varchar2) or
199: nvl(per_vac_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute5, hr_api.g_varchar2) or
201: nvl(per_vac_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 199: nvl(per_vac_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

195: nvl(per_vac_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute3, hr_api.g_varchar2) or
197: nvl(per_vac_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute4, hr_api.g_varchar2) or
199: nvl(per_vac_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute5, hr_api.g_varchar2) or
201: nvl(per_vac_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute6, hr_api.g_varchar2) or
203: nvl(per_vac_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 201: nvl(per_vac_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

197: nvl(per_vac_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute4, hr_api.g_varchar2) or
199: nvl(per_vac_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute5, hr_api.g_varchar2) or
201: nvl(per_vac_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute6, hr_api.g_varchar2) or
203: nvl(per_vac_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute7, hr_api.g_varchar2) or
205: nvl(per_vac_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 203: nvl(per_vac_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

199: nvl(per_vac_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute5, hr_api.g_varchar2) or
201: nvl(per_vac_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute6, hr_api.g_varchar2) or
203: nvl(per_vac_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute7, hr_api.g_varchar2) or
205: nvl(per_vac_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute8, hr_api.g_varchar2) or
207: nvl(per_vac_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 205: nvl(per_vac_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

201: nvl(per_vac_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute6, hr_api.g_varchar2) or
203: nvl(per_vac_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute7, hr_api.g_varchar2) or
205: nvl(per_vac_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute8, hr_api.g_varchar2) or
207: nvl(per_vac_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute9, hr_api.g_varchar2) or
209: nvl(per_vac_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 207: nvl(per_vac_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

203: nvl(per_vac_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute7, hr_api.g_varchar2) or
205: nvl(per_vac_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute8, hr_api.g_varchar2) or
207: nvl(per_vac_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute9, hr_api.g_varchar2) or
209: nvl(per_vac_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute10, hr_api.g_varchar2) or
211: nvl(per_vac_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 209: nvl(per_vac_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

205: nvl(per_vac_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute8, hr_api.g_varchar2) or
207: nvl(per_vac_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute9, hr_api.g_varchar2) or
209: nvl(per_vac_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute10, hr_api.g_varchar2) or
211: nvl(per_vac_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute11, hr_api.g_varchar2) or
213: nvl(per_vac_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 211: nvl(per_vac_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

207: nvl(per_vac_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute9, hr_api.g_varchar2) or
209: nvl(per_vac_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute10, hr_api.g_varchar2) or
211: nvl(per_vac_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute11, hr_api.g_varchar2) or
213: nvl(per_vac_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute12, hr_api.g_varchar2) or
215: nvl(per_vac_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 213: nvl(per_vac_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

209: nvl(per_vac_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute10, hr_api.g_varchar2) or
211: nvl(per_vac_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute11, hr_api.g_varchar2) or
213: nvl(per_vac_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute12, hr_api.g_varchar2) or
215: nvl(per_vac_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute13, hr_api.g_varchar2) or
217: nvl(per_vac_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 215: nvl(per_vac_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

211: nvl(per_vac_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute11, hr_api.g_varchar2) or
213: nvl(per_vac_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute12, hr_api.g_varchar2) or
215: nvl(per_vac_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute13, hr_api.g_varchar2) or
217: nvl(per_vac_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute14, hr_api.g_varchar2) or
219: nvl(per_vac_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 217: nvl(per_vac_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

213: nvl(per_vac_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute12, hr_api.g_varchar2) or
215: nvl(per_vac_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute13, hr_api.g_varchar2) or
217: nvl(per_vac_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute14, hr_api.g_varchar2) or
219: nvl(per_vac_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute15, hr_api.g_varchar2) or
221: nvl(per_vac_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 219: nvl(per_vac_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

215: nvl(per_vac_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute13, hr_api.g_varchar2) or
217: nvl(per_vac_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute14, hr_api.g_varchar2) or
219: nvl(per_vac_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute15, hr_api.g_varchar2) or
221: nvl(per_vac_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute16, hr_api.g_varchar2) or
223: nvl(per_vac_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 221: nvl(per_vac_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

217: nvl(per_vac_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute14, hr_api.g_varchar2) or
219: nvl(per_vac_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute15, hr_api.g_varchar2) or
221: nvl(per_vac_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute16, hr_api.g_varchar2) or
223: nvl(per_vac_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute17, hr_api.g_varchar2) or
225: nvl(per_vac_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 223: nvl(per_vac_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

219: nvl(per_vac_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute15, hr_api.g_varchar2) or
221: nvl(per_vac_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute16, hr_api.g_varchar2) or
223: nvl(per_vac_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute17, hr_api.g_varchar2) or
225: nvl(per_vac_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute18, hr_api.g_varchar2) or
227: nvl(per_vac_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 225: nvl(per_vac_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

221: nvl(per_vac_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute16, hr_api.g_varchar2) or
223: nvl(per_vac_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute17, hr_api.g_varchar2) or
225: nvl(per_vac_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute18, hr_api.g_varchar2) or
227: nvl(per_vac_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute19, hr_api.g_varchar2) or
229: nvl(per_vac_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 227: nvl(per_vac_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

223: nvl(per_vac_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute17, hr_api.g_varchar2) or
225: nvl(per_vac_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute18, hr_api.g_varchar2) or
227: nvl(per_vac_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute19, hr_api.g_varchar2) or
229: nvl(per_vac_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
231: or (p_rec.vacancy_id is null) then

Line 229: nvl(per_vac_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

225: nvl(per_vac_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute18, hr_api.g_varchar2) or
227: nvl(per_vac_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute19, hr_api.g_varchar2) or
229: nvl(per_vac_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
231: or (p_rec.vacancy_id is null) then
232: --
233: -- Only execute the validation if absolutely necessary:

Line 316: (p_rec in per_vac_shd.g_rec_type

312: --
313: -- {End Of Comments}
314: -- ----------------------------------------------------------------------------
315: Procedure chk_non_updateable_args
316: (p_rec in per_vac_shd.g_rec_type
317: ) IS
318: --
319: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
320: --

Line 326: if not per_vac_shd.api_updating

322: --
323: -- Only proceed with the validation if a row exists for the current
324: -- record in the HR Schema.
325: --
326: if not per_vac_shd.api_updating
327: (p_vacancy_id => p_rec.vacancy_id
328: ,p_object_version_number => p_rec.object_version_number
329: ) then
330: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 337: if per_vac_shd.g_old_rec.business_group_id <> p_rec.business_group_id

333: fnd_message.raise_error;
334: end if;
335:
336:
337: if per_vac_shd.g_old_rec.business_group_id <> p_rec.business_group_id
338: then
339: hr_api.argument_changed_error
340: (p_api_name => l_proc
341: ,p_argument => 'business_group_id'

Line 342: ,p_base_table => per_vac_shd.g_tab_name

338: then
339: hr_api.argument_changed_error
340: (p_api_name => l_proc
341: ,p_argument => 'business_group_id'
342: ,p_base_table => per_vac_shd.g_tab_name
343: );
344: end if;
345:
346: if per_vac_shd.g_old_rec.vacancy_id <> p_rec.vacancy_id then

Line 346: if per_vac_shd.g_old_rec.vacancy_id <> p_rec.vacancy_id then

342: ,p_base_table => per_vac_shd.g_tab_name
343: );
344: end if;
345:
346: if per_vac_shd.g_old_rec.vacancy_id <> p_rec.vacancy_id then
347: hr_api.argument_changed_error
348: (p_api_name => l_proc
349: ,p_argument => 'vacancy_id'
350: ,p_base_table => per_vac_shd.g_tab_name

Line 350: ,p_base_table => per_vac_shd.g_tab_name

346: if per_vac_shd.g_old_rec.vacancy_id <> p_rec.vacancy_id then
347: hr_api.argument_changed_error
348: (p_api_name => l_proc
349: ,p_argument => 'vacancy_id'
350: ,p_base_table => per_vac_shd.g_tab_name
351: );
352: end if;
353:
354: if per_vac_shd.g_old_rec.name <> p_rec.name then

Line 354: if per_vac_shd.g_old_rec.name <> p_rec.name then

350: ,p_base_table => per_vac_shd.g_tab_name
351: );
352: end if;
353:
354: if per_vac_shd.g_old_rec.name <> p_rec.name then
355: hr_api.argument_changed_error
356: (p_api_name => l_proc
357: ,p_argument => 'name'
358: ,p_base_table => per_vac_shd.g_tab_name

Line 358: ,p_base_table => per_vac_shd.g_tab_name

354: if per_vac_shd.g_old_rec.name <> p_rec.name then
355: hr_api.argument_changed_error
356: (p_api_name => l_proc
357: ,p_argument => 'name'
358: ,p_base_table => per_vac_shd.g_tab_name
359: );
360: end if;
361: --
362: End chk_non_updateable_args;

Line 474: l_api_updating := per_vac_shd.api_updating

470: l_api_updating boolean;
471: --
472: Begin
473: hr_utility.set_location('Entering:'||l_proc,10);
474: l_api_updating := per_vac_shd.api_updating
475: (p_vacancy_id => p_vacancy_id
476: ,p_object_version_number => p_object_version_number);
477: --
478: hr_utility.set_location(l_proc,20);

Line 481: (nvl(per_vac_shd.g_old_rec.date_from, hr_api.g_date) <>

477: --
478: hr_utility.set_location(l_proc,20);
479: if ((l_api_updating
480: and
481: (nvl(per_vac_shd.g_old_rec.date_from, hr_api.g_date) <>
482: nvl(p_date_from, hr_api.g_date) or
483: nvl(per_vac_shd.g_old_rec.date_to, hr_api.g_date) <>
484: nvl(p_date_to, hr_api.g_date)))
485: or

Line 483: nvl(per_vac_shd.g_old_rec.date_to, hr_api.g_date) <>

479: if ((l_api_updating
480: and
481: (nvl(per_vac_shd.g_old_rec.date_from, hr_api.g_date) <>
482: nvl(p_date_from, hr_api.g_date) or
483: nvl(per_vac_shd.g_old_rec.date_to, hr_api.g_date) <>
484: nvl(p_date_to, hr_api.g_date)))
485: or
486: (NOT l_api_updating)) then
487: --

Line 551: l_api_updating := per_vac_shd.api_updating

547: --
548: Begin
549: --
550: hr_utility.set_location('Entering:'||l_proc,10);
551: l_api_updating := per_vac_shd.api_updating
552: (p_vacancy_id => p_vacancy_id
553: ,p_object_version_number => p_object_version_number);
554: --
555: hr_utility.set_location(l_proc,20);

Line 558: nvl(per_vac_shd.g_old_rec.status, hr_api.g_varchar2) <>

554: --
555: hr_utility.set_location(l_proc,20);
556: if ((l_api_updating
557: and
558: nvl(per_vac_shd.g_old_rec.status, hr_api.g_varchar2) <>
559: nvl(p_status, hr_api.g_varchar2))
560: or
561: (NOT l_api_updating)) then
562: if (p_status is not null)

Line 629: l_api_updating := per_vac_shd.api_updating

625: --
626: Begin
627: hr_utility.set_location('Entering:'||l_proc,10);
628: --
629: l_api_updating := per_vac_shd.api_updating
630: (p_vacancy_id => p_vacancy_id
631: ,p_object_version_number => p_object_version_number);
632: --
633: hr_utility.set_location(l_proc,20);

Line 636: nvl(per_vac_shd.g_old_rec.budget_measurement_type,hr_api.g_varchar2) <>

632: --
633: hr_utility.set_location(l_proc,20);
634: if ((l_api_updating
635: and
636: nvl(per_vac_shd.g_old_rec.budget_measurement_type,hr_api.g_varchar2) <>
637: nvl(p_budget_measurement_type, hr_api.g_varchar2))
638: or
639: (NOT l_api_updating)) then
640: --

Line 705: l_api_updating := per_vac_shd.api_updating

701: --
702: Begin
703: hr_utility.set_location('Entering:'||l_proc,10);
704: --
705: l_api_updating := per_vac_shd.api_updating
706: (p_vacancy_id => p_vacancy_id
707: ,p_object_version_number => p_object_version_number);
708: --
709: hr_utility.set_location(l_proc,20);

Line 712: nvl(per_vac_shd.g_old_rec.security_method,hr_api.g_varchar2) <>

708: --
709: hr_utility.set_location(l_proc,20);
710: if ((l_api_updating
711: and
712: nvl(per_vac_shd.g_old_rec.security_method,hr_api.g_varchar2) <>
713: nvl(p_security_method, hr_api.g_varchar2))
714: or
715: (NOT l_api_updating)) then
716: --

Line 849: l_api_updating := per_vac_shd.api_updating

845: -- Only proceed with validation if :
846: -- a) The current g_old_rec is current and
847: -- b) The value for position_id has changed
848: --
849: l_api_updating := per_vac_shd.api_updating
850: (p_vacancy_id => p_vacancy_id
851: ,p_object_version_number => p_object_version_number);
852: --
853: hr_utility.set_location(l_proc,20);

Line 856: nvl(per_vac_shd.g_old_rec.position_id, hr_api.g_number) <>

852: --
853: hr_utility.set_location(l_proc,20);
854: if ((l_api_updating
855: and
856: nvl(per_vac_shd.g_old_rec.position_id, hr_api.g_number) <>
857: nvl(p_position_id, hr_api.g_number))
858: or
859: (NOT l_api_updating)) then
860: hr_utility.set_location(l_proc, 30);

Line 945: l_api_updating := per_vac_shd.api_updating

941: -- Only proceed with validation if :
942: -- a) The current g_old_rec is current and
943: -- b) The value for position_id or grade_id has changed
944: --
945: l_api_updating := per_vac_shd.api_updating
946: (p_vacancy_id => p_vacancy_id
947: ,p_object_version_number => p_object_version_number);
948: --
949: if (l_api_updating and

Line 950: ((nvl(per_vac_shd.g_old_rec.position_id, hr_api.g_number) <>

946: (p_vacancy_id => p_vacancy_id
947: ,p_object_version_number => p_object_version_number);
948: --
949: if (l_api_updating and
950: ((nvl(per_vac_shd.g_old_rec.position_id, hr_api.g_number) <>
951: nvl(p_position_id, hr_api.g_number))
952: or
953: (nvl(per_vac_shd.g_old_rec.grade_id, hr_api.g_number) <>
954: nvl(p_grade_id, hr_api.g_number))

Line 953: (nvl(per_vac_shd.g_old_rec.grade_id, hr_api.g_number) <>

949: if (l_api_updating and
950: ((nvl(per_vac_shd.g_old_rec.position_id, hr_api.g_number) <>
951: nvl(p_position_id, hr_api.g_number))
952: or
953: (nvl(per_vac_shd.g_old_rec.grade_id, hr_api.g_number) <>
954: nvl(p_grade_id, hr_api.g_number))
955: ))
956: or
957: (NOT l_api_updating) then

Line 1025: l_api_updating := per_vac_shd.api_updating

1021: -- Only proceed with validation if :
1022: -- a) The current g_old_rec is current and
1023: -- b) The value for position_id or grade_id has changed
1024: --
1025: l_api_updating := per_vac_shd.api_updating
1026: (p_vacancy_id => p_vacancy_id
1027: ,p_object_version_number => p_object_version_number);
1028: --
1029: if (l_api_updating and

Line 1030: ((nvl(per_vac_shd.g_old_rec.position_id, hr_api.g_number) <>

1026: (p_vacancy_id => p_vacancy_id
1027: ,p_object_version_number => p_object_version_number);
1028: --
1029: if (l_api_updating and
1030: ((nvl(per_vac_shd.g_old_rec.position_id, hr_api.g_number) <>
1031: nvl(p_position_id, hr_api.g_number))
1032: or
1033: (nvl(per_vac_shd.g_old_rec.organization_id, hr_api.g_number) <>
1034: nvl(p_organization_id, hr_api.g_number))

Line 1033: (nvl(per_vac_shd.g_old_rec.organization_id, hr_api.g_number) <>

1029: if (l_api_updating and
1030: ((nvl(per_vac_shd.g_old_rec.position_id, hr_api.g_number) <>
1031: nvl(p_position_id, hr_api.g_number))
1032: or
1033: (nvl(per_vac_shd.g_old_rec.organization_id, hr_api.g_number) <>
1034: nvl(p_organization_id, hr_api.g_number))
1035: ))
1036: or
1037: (NOT l_api_updating) then

Line 1113: l_api_updating := per_vac_shd.api_updating

1109: -- Only proceed with validation if :
1110: -- a) The current g_old_rec is current and
1111: -- b) The value for position or job has changed
1112: --
1113: l_api_updating := per_vac_shd.api_updating
1114: (p_vacancy_id => p_vacancy_id
1115: ,p_object_version_number => p_object_version_number);
1116: hr_utility.set_location(l_proc, 30);
1117: --

Line 1119: ((nvl(per_vac_shd.g_old_rec.position_id, hr_api.g_number) <>

1115: ,p_object_version_number => p_object_version_number);
1116: hr_utility.set_location(l_proc, 30);
1117: --
1118: if (l_api_updating and
1119: ((nvl(per_vac_shd.g_old_rec.position_id, hr_api.g_number) <>
1120: nvl(p_position_id, hr_api.g_number))
1121: or
1122: (nvl(per_vac_shd.g_old_rec.job_id, hr_api.g_number) <>
1123: nvl(p_job_id, hr_api.g_number))

Line 1122: (nvl(per_vac_shd.g_old_rec.job_id, hr_api.g_number) <>

1118: if (l_api_updating and
1119: ((nvl(per_vac_shd.g_old_rec.position_id, hr_api.g_number) <>
1120: nvl(p_position_id, hr_api.g_number))
1121: or
1122: (nvl(per_vac_shd.g_old_rec.job_id, hr_api.g_number) <>
1123: nvl(p_job_id, hr_api.g_number))
1124: ))
1125: or
1126: (NOT l_api_updating)

Line 1220: l_api_updating := per_vac_shd.api_updating

1216: Begin
1217: --
1218: hr_utility.set_location('Entering:'||l_proc,10);
1219: --
1220: l_api_updating := per_vac_shd.api_updating
1221: (p_vacancy_id => p_vacancy_id
1222: ,p_object_version_number => p_object_version_number);
1223: --
1224: hr_utility.set_location(l_proc,20);

Line 1227: nvl(per_vac_shd.g_old_rec.job_id,hr_api.g_number) <>

1223: --
1224: hr_utility.set_location(l_proc,20);
1225: if ((l_api_updating
1226: and
1227: nvl(per_vac_shd.g_old_rec.job_id,hr_api.g_number) <>
1228: nvl(p_job_id, hr_api.g_number))
1229: or
1230: (NOT l_api_updating)) then
1231: --

Line 1297: l_api_updating := per_vac_shd.api_updating

1293: ) then
1294: --
1295: -- Check if the vacancy is being updated.
1296: --
1297: l_api_updating := per_vac_shd.api_updating
1298: (p_vacancy_id => p_vacancy_id
1299: ,p_object_version_number => p_object_version_number
1300: );
1301: hr_utility.set_location(l_proc, 30);

Line 1309: ((nvl(per_vac_shd.g_old_rec.job_id, hr_api.g_number)

1305: -- b) The value for job or grade has changed.
1306: --
1307: if (l_api_updating
1308: and
1309: ((nvl(per_vac_shd.g_old_rec.job_id, hr_api.g_number)
1310: <> nvl(p_job_id, hr_api.g_number))
1311: or
1312: (nvl(per_vac_shd.g_old_rec.grade_id, hr_api.g_number)
1313: <> nvl(p_grade_id, hr_api.g_number))))

Line 1312: (nvl(per_vac_shd.g_old_rec.grade_id, hr_api.g_number)

1308: and
1309: ((nvl(per_vac_shd.g_old_rec.job_id, hr_api.g_number)
1310: <> nvl(p_job_id, hr_api.g_number))
1311: or
1312: (nvl(per_vac_shd.g_old_rec.grade_id, hr_api.g_number)
1313: <> nvl(p_grade_id, hr_api.g_number))))
1314: or
1315: NOT l_api_updating then
1316: hr_utility.set_location(l_proc, 40);

Line 1399: l_api_updating := per_vac_shd.api_updating

1395: --
1396: Begin
1397: hr_utility.set_location('Entering:'||l_proc,10);
1398: --
1399: l_api_updating := per_vac_shd.api_updating
1400: (p_vacancy_id => p_vacancy_id
1401: ,p_object_version_number => p_object_version_number);
1402: --
1403: hr_utility.set_location(l_proc,20);

Line 1406: nvl(per_vac_shd.g_old_rec.grade_id,hr_api.g_number) <>

1402: --
1403: hr_utility.set_location(l_proc,20);
1404: if ((l_api_updating
1405: and
1406: nvl(per_vac_shd.g_old_rec.grade_id,hr_api.g_number) <>
1407: nvl(p_grade_id, hr_api.g_number))
1408: or
1409: (NOT l_api_updating)) then
1410: -- --

Line 1489: l_api_updating := per_vac_shd.api_updating

1485: --
1486: Begin
1487: hr_utility.set_location('Entering:'||l_proc,10);
1488: --
1489: l_api_updating := per_vac_shd.api_updating
1490: (p_vacancy_id => p_vacancy_id
1491: ,p_object_version_number => p_object_version_number);
1492: --
1493: hr_utility.set_location(l_proc,20);

Line 1496: nvl(per_vac_shd.g_old_rec.organization_id,hr_api.g_number) <>

1492: --
1493: hr_utility.set_location(l_proc,20);
1494: if ((l_api_updating
1495: and
1496: nvl(per_vac_shd.g_old_rec.organization_id,hr_api.g_number) <>
1497: nvl(p_organization_id, hr_api.g_number))
1498: or
1499: (NOT l_api_updating)) then
1500: --

Line 1574: l_api_updating := per_vac_shd.api_updating

1570: --
1571: Begin
1572: hr_utility.set_location('Entering:'||l_proc,10);
1573: --
1574: l_api_updating := per_vac_shd.api_updating
1575: (p_vacancy_id => p_vacancy_id
1576: ,p_object_version_number => p_object_version_number);
1577: --
1578: hr_utility.set_location(l_proc,20);

Line 1581: nvl(per_vac_shd.g_old_rec.people_group_id,hr_api.g_number) <>

1577: --
1578: hr_utility.set_location(l_proc,20);
1579: if ((l_api_updating
1580: and
1581: nvl(per_vac_shd.g_old_rec.people_group_id,hr_api.g_number) <>
1582: nvl(p_people_group_id, hr_api.g_number))
1583: or
1584: (NOT l_api_updating)) then
1585: --

Line 1657: l_api_updating := per_vac_shd.api_updating

1653: --
1654: Begin
1655: hr_utility.set_location('Entering:'||l_proc,10);
1656: --
1657: l_api_updating := per_vac_shd.api_updating
1658: (p_vacancy_id => p_vacancy_id
1659: ,p_object_version_number => p_object_version_number);
1660: --
1661: hr_utility.set_location(l_proc,20);

Line 1664: nvl(per_vac_shd.g_old_rec.location_id,hr_api.g_number) <>

1660: --
1661: hr_utility.set_location(l_proc,20);
1662: if ((l_api_updating
1663: and
1664: nvl(per_vac_shd.g_old_rec.location_id,hr_api.g_number) <>
1665: nvl(p_location_id, hr_api.g_number))
1666: or
1667: (NOT l_api_updating)) then
1668: --

Line 1751: l_api_updating := per_vac_shd.api_updating

1747: --
1748: Begin
1749: hr_utility.set_location('Entering:'||l_proc,10);
1750: --
1751: l_api_updating := per_vac_shd.api_updating
1752: (p_vacancy_id => p_vacancy_id
1753: ,p_object_version_number => p_object_version_number);
1754: --
1755: hr_utility.set_location(l_proc,20);

Line 1758: nvl(per_vac_shd.g_old_rec.recruiter_id,hr_api.g_number) <>

1754: --
1755: hr_utility.set_location(l_proc,20);
1756: if ((l_api_updating
1757: and
1758: nvl(per_vac_shd.g_old_rec.recruiter_id,hr_api.g_number) <>
1759: nvl(p_recruiter_id, hr_api.g_number))
1760: or
1761: (NOT l_api_updating)) then
1762: --

Line 1966: l_api_updating := per_vac_shd.api_updating

1962: --
1963: Begin
1964: hr_utility.set_location('Entering:'||l_proc,10);
1965: --
1966: l_api_updating := per_vac_shd.api_updating
1967: (p_vacancy_id => p_vacancy_id
1968: ,p_object_version_number => p_object_version_number);
1969: --
1970: hr_utility.set_location(l_proc,20);

Line 1973: nvl(per_vac_shd.g_old_rec.manager_id,hr_api.g_number) <>

1969: --
1970: hr_utility.set_location(l_proc,20);
1971: if ((l_api_updating
1972: and
1973: nvl(per_vac_shd.g_old_rec.manager_id,hr_api.g_number) <>
1974: nvl(p_manager_id, hr_api.g_number))
1975: or
1976: (NOT l_api_updating)) then
1977: --

Line 2063: l_api_updating := per_vac_shd.api_updating

2059: --
2060: Begin
2061: hr_utility.set_location('Entering:'||l_proc,10);
2062: --
2063: l_api_updating := per_vac_shd.api_updating
2064: (p_vacancy_id => p_vacancy_id
2065: ,p_object_version_number => p_object_version_number);
2066: --
2067: hr_utility.set_location(l_proc,20);

Line 2070: nvl(per_vac_shd.g_old_rec.manager_id,hr_api.g_number) <>

2066: --
2067: hr_utility.set_location(l_proc,20);
2068: if ((l_api_updating
2069: and
2070: nvl(per_vac_shd.g_old_rec.manager_id,hr_api.g_number) <>
2071: nvl(p_manager_id, hr_api.g_number))
2072: or
2073: (NOT l_api_updating)) then
2074: --

Line 2143: l_api_updating := per_vac_shd.api_updating

2139: --
2140: Begin
2141: hr_utility.set_location('Entering:'||l_proc,10);
2142: --
2143: l_api_updating := per_vac_shd.api_updating
2144: (p_vacancy_id => p_vacancy_id
2145: ,p_object_version_number => p_object_version_number);
2146: --
2147: hr_utility.set_location(l_proc,20);

Line 2150: nvl(per_vac_shd.g_old_rec.primary_posting_id,hr_api.g_number) <>

2146: --
2147: hr_utility.set_location(l_proc,20);
2148: if ((l_api_updating
2149: and
2150: nvl(per_vac_shd.g_old_rec.primary_posting_id,hr_api.g_number) <>
2151: nvl(p_primary_posting_id, hr_api.g_number))
2152: or
2153: (NOT l_api_updating)) then
2154: --

Line 2220: l_api_updating := per_vac_shd.api_updating

2216: --
2217: Begin
2218: hr_utility.set_location('Entering:'||l_proc,10);
2219: --
2220: l_api_updating := per_vac_shd.api_updating
2221: (p_vacancy_id => p_vacancy_id
2222: ,p_object_version_number => p_object_version_number);
2223: --
2224: hr_utility.set_location(l_proc,20);

Line 2227: nvl(per_vac_shd.g_old_rec.assessment_id,hr_api.g_number) <>

2223: --
2224: hr_utility.set_location(l_proc,20);
2225: if ((l_api_updating
2226: and
2227: nvl(per_vac_shd.g_old_rec.assessment_id,hr_api.g_number) <>
2228: nvl(p_assessment_id, hr_api.g_number))
2229: or
2230: (NOT l_api_updating)) then
2231: --

Line 2257: (p_rec in per_vac_shd.g_rec_type

2253: -- ----------------------------------------------------------------------------
2254: -- |---------------------------< insert_validate >----------------------------|
2255: -- ----------------------------------------------------------------------------
2256: Procedure insert_validate
2257: (p_rec in per_vac_shd.g_rec_type
2258: ,p_effective_date in date
2259: ,p_inv_pos_grade_warning out nocopy boolean
2260: ,p_inv_job_grade_warning out nocopy boolean
2261: ) is

Line 2273: ,p_associated_column1 => per_vac_shd.g_tab_name||'.BUSINESS_GROUP_ID');

2269: --
2270: -- Call all supporting business operations
2271: --
2272: hr_api.validate_bus_grp_id(p_rec.business_group_id
2273: ,p_associated_column1 => per_vac_shd.g_tab_name||'.BUSINESS_GROUP_ID');
2274: --
2275: hr_utility.set_location(l_proc, 10);
2276: --
2277: chk_vacancy_dates

Line 2495: (p_rec in per_vac_shd.g_rec_type

2491: -- ----------------------------------------------------------------------------
2492: -- |---------------------------< update_validate >----------------------------|
2493: -- ----------------------------------------------------------------------------
2494: Procedure update_validate
2495: (p_rec in per_vac_shd.g_rec_type
2496: ,p_effective_date in date
2497: ,p_inv_pos_grade_warning out nocopy boolean
2498: ,p_inv_job_grade_warning out nocopy boolean
2499: ) is

Line 2519: ,p_associated_column1 => per_vac_shd.g_tab_name||'.BUSINESS_GROUP_ID');

2515: );
2516: --
2517: --
2518: hr_api.validate_bus_grp_id(p_rec.business_group_id
2519: ,p_associated_column1 => per_vac_shd.g_tab_name||'.BUSINESS_GROUP_ID');
2520: --
2521: hr_utility.set_location(l_proc, 20);
2522: --
2523: chk_vacancy_dates

Line 2555: ,p_business_group_id => per_vac_shd.g_old_rec.business_group_id

2551: (p_vacancy_id => p_rec.vacancy_id
2552: ,p_object_version_number => p_rec.object_version_number
2553: ,p_organization_id => p_rec.organization_id
2554: ,p_effective_date => p_effective_date
2555: ,p_business_group_id => per_vac_shd.g_old_rec.business_group_id
2556: );
2557: --
2558: hr_utility.set_location(l_proc, 60);
2559: --

Line 2565: ,p_business_group_id => per_vac_shd.g_old_rec.business_group_id

2561: (p_vacancy_id => p_rec.vacancy_id
2562: ,p_object_version_number => p_rec.object_version_number
2563: ,p_job_id => p_rec.job_id
2564: ,p_effective_date => p_effective_date
2565: ,p_business_group_id => per_vac_shd.g_old_rec.business_group_id
2566: );
2567: --
2568: hr_utility.set_location(l_proc, 70);
2569: --

Line 2605: ,p_business_group_id => per_vac_shd.g_old_rec.business_group_id

2601: (p_vacancy_id => p_rec.vacancy_id
2602: ,p_object_version_number => p_rec.object_version_number
2603: ,p_grade_id => p_rec.grade_id
2604: ,p_effective_date => p_effective_date
2605: ,p_business_group_id => per_vac_shd.g_old_rec.business_group_id
2606: );
2607: --
2608: hr_utility.set_location(l_proc, 110);
2609: --

Line 2654: ,p_business_group_id => per_vac_shd.g_old_rec.business_group_id

2650: (p_vacancy_id => p_rec.vacancy_id
2651: ,p_object_version_number => p_rec.object_version_number
2652: ,p_recruiter_id => p_rec.recruiter_id
2653: ,p_effective_date => p_effective_date
2654: ,p_business_group_id => per_vac_shd.g_old_rec.business_group_id
2655: );
2656: --
2657: hr_utility.set_location(l_proc, 160);
2658: --

Line 2680: ,p_business_group_id => per_vac_shd.g_old_rec.business_group_id

2676: (p_vacancy_id => p_rec.vacancy_id
2677: ,p_object_version_number => p_rec.object_version_number
2678: ,p_manager_id => p_rec.manager_id
2679: ,p_effective_date => p_effective_date
2680: ,p_business_group_id => per_vac_shd.g_old_rec.business_group_id
2681: );
2682: --
2683: hr_utility.set_location(l_proc, 190);
2684: --

Line 2722: (p_rec in per_vac_shd.g_rec_type

2718: -- ----------------------------------------------------------------------------
2719: -- |---------------------------< delete_validate >----------------------------|
2720: -- ----------------------------------------------------------------------------
2721: Procedure delete_validate
2722: (p_rec in per_vac_shd.g_rec_type
2723: ) is
2724: --
2725: l_proc varchar2(72) := g_package||'delete_validate';
2726: --