APPS.PER_PAT_BUS dependencies on PER_PAT_SHD

Line 209: l_api_updating := per_pat_shd.api_updating

205: -- a) The current g_old_rec is current and
206: -- b) The checklist name value has changed
207: -- c) a record is being inserted
208: --
209: l_api_updating := per_pat_shd.api_updating
210: (p_allocated_task_id => p_allocated_task_id
211: ,p_object_version_number => p_object_version_number
212: );
213:

Line 215: AND NVL(per_pat_shd.g_old_rec.task_name, hr_api.g_varchar2) = nvl(p_task_name,hr_api.g_varchar2)

211: ,p_object_version_number => p_object_version_number
212: );
213:
214: IF (l_api_updating
215: AND NVL(per_pat_shd.g_old_rec.task_name, hr_api.g_varchar2) = nvl(p_task_name,hr_api.g_varchar2)
216: )
217: THEN
218: RETURN;
219: END IF;

Line 345: (p_rec in per_pat_shd.g_rec_type

341: -- Internal Row Handler Use Only.
342: --
343: -- ----------------------------------------------------------------------------
344: procedure chk_ddf
345: (p_rec in per_pat_shd.g_rec_type
346: ) is
347: --
348: l_proc varchar2(72) := g_package || 'chk_ddf';
349: --

Line 355: nvl(per_pat_shd.g_old_rec.information_category, hr_api.g_varchar2) <>

351: hr_utility.set_location('Entering:'||l_proc,10);
352: --
353: /*
354: if ((p_rec.allocated_task_id is not null) and (
355: nvl(per_pat_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
356: nvl(p_rec.information_category, hr_api.g_varchar2) or
357: nvl(per_pat_shd.g_old_rec.information1, hr_api.g_varchar2) <>
358: nvl(p_rec.information1, hr_api.g_varchar2) or
359: nvl(per_pat_shd.g_old_rec.information2, hr_api.g_varchar2) <>

Line 357: nvl(per_pat_shd.g_old_rec.information1, hr_api.g_varchar2) <>

353: /*
354: if ((p_rec.allocated_task_id is not null) and (
355: nvl(per_pat_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
356: nvl(p_rec.information_category, hr_api.g_varchar2) or
357: nvl(per_pat_shd.g_old_rec.information1, hr_api.g_varchar2) <>
358: nvl(p_rec.information1, hr_api.g_varchar2) or
359: nvl(per_pat_shd.g_old_rec.information2, hr_api.g_varchar2) <>
360: nvl(p_rec.information2, hr_api.g_varchar2) or
361: nvl(per_pat_shd.g_old_rec.information3, hr_api.g_varchar2) <>

Line 359: nvl(per_pat_shd.g_old_rec.information2, hr_api.g_varchar2) <>

355: nvl(per_pat_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
356: nvl(p_rec.information_category, hr_api.g_varchar2) or
357: nvl(per_pat_shd.g_old_rec.information1, hr_api.g_varchar2) <>
358: nvl(p_rec.information1, hr_api.g_varchar2) or
359: nvl(per_pat_shd.g_old_rec.information2, hr_api.g_varchar2) <>
360: nvl(p_rec.information2, hr_api.g_varchar2) or
361: nvl(per_pat_shd.g_old_rec.information3, hr_api.g_varchar2) <>
362: nvl(p_rec.information3, hr_api.g_varchar2) or
363: nvl(per_pat_shd.g_old_rec.information4, hr_api.g_varchar2) <>

Line 361: nvl(per_pat_shd.g_old_rec.information3, hr_api.g_varchar2) <>

357: nvl(per_pat_shd.g_old_rec.information1, hr_api.g_varchar2) <>
358: nvl(p_rec.information1, hr_api.g_varchar2) or
359: nvl(per_pat_shd.g_old_rec.information2, hr_api.g_varchar2) <>
360: nvl(p_rec.information2, hr_api.g_varchar2) or
361: nvl(per_pat_shd.g_old_rec.information3, hr_api.g_varchar2) <>
362: nvl(p_rec.information3, hr_api.g_varchar2) or
363: nvl(per_pat_shd.g_old_rec.information4, hr_api.g_varchar2) <>
364: nvl(p_rec.information4, hr_api.g_varchar2) or
365: nvl(per_pat_shd.g_old_rec.information5, hr_api.g_varchar2) <>

Line 363: nvl(per_pat_shd.g_old_rec.information4, hr_api.g_varchar2) <>

359: nvl(per_pat_shd.g_old_rec.information2, hr_api.g_varchar2) <>
360: nvl(p_rec.information2, hr_api.g_varchar2) or
361: nvl(per_pat_shd.g_old_rec.information3, hr_api.g_varchar2) <>
362: nvl(p_rec.information3, hr_api.g_varchar2) or
363: nvl(per_pat_shd.g_old_rec.information4, hr_api.g_varchar2) <>
364: nvl(p_rec.information4, hr_api.g_varchar2) or
365: nvl(per_pat_shd.g_old_rec.information5, hr_api.g_varchar2) <>
366: nvl(p_rec.information5, hr_api.g_varchar2) or
367: nvl(per_pat_shd.g_old_rec.information6, hr_api.g_varchar2) <>

Line 365: nvl(per_pat_shd.g_old_rec.information5, hr_api.g_varchar2) <>

361: nvl(per_pat_shd.g_old_rec.information3, hr_api.g_varchar2) <>
362: nvl(p_rec.information3, hr_api.g_varchar2) or
363: nvl(per_pat_shd.g_old_rec.information4, hr_api.g_varchar2) <>
364: nvl(p_rec.information4, hr_api.g_varchar2) or
365: nvl(per_pat_shd.g_old_rec.information5, hr_api.g_varchar2) <>
366: nvl(p_rec.information5, hr_api.g_varchar2) or
367: nvl(per_pat_shd.g_old_rec.information6, hr_api.g_varchar2) <>
368: nvl(p_rec.information6, hr_api.g_varchar2) or
369: nvl(per_pat_shd.g_old_rec.information7, hr_api.g_varchar2) <>

Line 367: nvl(per_pat_shd.g_old_rec.information6, hr_api.g_varchar2) <>

363: nvl(per_pat_shd.g_old_rec.information4, hr_api.g_varchar2) <>
364: nvl(p_rec.information4, hr_api.g_varchar2) or
365: nvl(per_pat_shd.g_old_rec.information5, hr_api.g_varchar2) <>
366: nvl(p_rec.information5, hr_api.g_varchar2) or
367: nvl(per_pat_shd.g_old_rec.information6, hr_api.g_varchar2) <>
368: nvl(p_rec.information6, hr_api.g_varchar2) or
369: nvl(per_pat_shd.g_old_rec.information7, hr_api.g_varchar2) <>
370: nvl(p_rec.information7, hr_api.g_varchar2) or
371: nvl(per_pat_shd.g_old_rec.information8, hr_api.g_varchar2) <>

Line 369: nvl(per_pat_shd.g_old_rec.information7, hr_api.g_varchar2) <>

365: nvl(per_pat_shd.g_old_rec.information5, hr_api.g_varchar2) <>
366: nvl(p_rec.information5, hr_api.g_varchar2) or
367: nvl(per_pat_shd.g_old_rec.information6, hr_api.g_varchar2) <>
368: nvl(p_rec.information6, hr_api.g_varchar2) or
369: nvl(per_pat_shd.g_old_rec.information7, hr_api.g_varchar2) <>
370: nvl(p_rec.information7, hr_api.g_varchar2) or
371: nvl(per_pat_shd.g_old_rec.information8, hr_api.g_varchar2) <>
372: nvl(p_rec.information8, hr_api.g_varchar2) or
373: nvl(per_pat_shd.g_old_rec.information9, hr_api.g_varchar2) <>

Line 371: nvl(per_pat_shd.g_old_rec.information8, hr_api.g_varchar2) <>

367: nvl(per_pat_shd.g_old_rec.information6, hr_api.g_varchar2) <>
368: nvl(p_rec.information6, hr_api.g_varchar2) or
369: nvl(per_pat_shd.g_old_rec.information7, hr_api.g_varchar2) <>
370: nvl(p_rec.information7, hr_api.g_varchar2) or
371: nvl(per_pat_shd.g_old_rec.information8, hr_api.g_varchar2) <>
372: nvl(p_rec.information8, hr_api.g_varchar2) or
373: nvl(per_pat_shd.g_old_rec.information9, hr_api.g_varchar2) <>
374: nvl(p_rec.information9, hr_api.g_varchar2) or
375: nvl(per_pat_shd.g_old_rec.information10, hr_api.g_varchar2) <>

Line 373: nvl(per_pat_shd.g_old_rec.information9, hr_api.g_varchar2) <>

369: nvl(per_pat_shd.g_old_rec.information7, hr_api.g_varchar2) <>
370: nvl(p_rec.information7, hr_api.g_varchar2) or
371: nvl(per_pat_shd.g_old_rec.information8, hr_api.g_varchar2) <>
372: nvl(p_rec.information8, hr_api.g_varchar2) or
373: nvl(per_pat_shd.g_old_rec.information9, hr_api.g_varchar2) <>
374: nvl(p_rec.information9, hr_api.g_varchar2) or
375: nvl(per_pat_shd.g_old_rec.information10, hr_api.g_varchar2) <>
376: nvl(p_rec.information10, hr_api.g_varchar2) or
377: nvl(per_pat_shd.g_old_rec.information11, hr_api.g_varchar2) <>

Line 375: nvl(per_pat_shd.g_old_rec.information10, hr_api.g_varchar2) <>

371: nvl(per_pat_shd.g_old_rec.information8, hr_api.g_varchar2) <>
372: nvl(p_rec.information8, hr_api.g_varchar2) or
373: nvl(per_pat_shd.g_old_rec.information9, hr_api.g_varchar2) <>
374: nvl(p_rec.information9, hr_api.g_varchar2) or
375: nvl(per_pat_shd.g_old_rec.information10, hr_api.g_varchar2) <>
376: nvl(p_rec.information10, hr_api.g_varchar2) or
377: nvl(per_pat_shd.g_old_rec.information11, hr_api.g_varchar2) <>
378: nvl(p_rec.information11, hr_api.g_varchar2) or
379: nvl(per_pat_shd.g_old_rec.information12, hr_api.g_varchar2) <>

Line 377: nvl(per_pat_shd.g_old_rec.information11, hr_api.g_varchar2) <>

373: nvl(per_pat_shd.g_old_rec.information9, hr_api.g_varchar2) <>
374: nvl(p_rec.information9, hr_api.g_varchar2) or
375: nvl(per_pat_shd.g_old_rec.information10, hr_api.g_varchar2) <>
376: nvl(p_rec.information10, hr_api.g_varchar2) or
377: nvl(per_pat_shd.g_old_rec.information11, hr_api.g_varchar2) <>
378: nvl(p_rec.information11, hr_api.g_varchar2) or
379: nvl(per_pat_shd.g_old_rec.information12, hr_api.g_varchar2) <>
380: nvl(p_rec.information12, hr_api.g_varchar2) or
381: nvl(per_pat_shd.g_old_rec.information13, hr_api.g_varchar2) <>

Line 379: nvl(per_pat_shd.g_old_rec.information12, hr_api.g_varchar2) <>

375: nvl(per_pat_shd.g_old_rec.information10, hr_api.g_varchar2) <>
376: nvl(p_rec.information10, hr_api.g_varchar2) or
377: nvl(per_pat_shd.g_old_rec.information11, hr_api.g_varchar2) <>
378: nvl(p_rec.information11, hr_api.g_varchar2) or
379: nvl(per_pat_shd.g_old_rec.information12, hr_api.g_varchar2) <>
380: nvl(p_rec.information12, hr_api.g_varchar2) or
381: nvl(per_pat_shd.g_old_rec.information13, hr_api.g_varchar2) <>
382: nvl(p_rec.information13, hr_api.g_varchar2) or
383: nvl(per_pat_shd.g_old_rec.information14, hr_api.g_varchar2) <>

Line 381: nvl(per_pat_shd.g_old_rec.information13, hr_api.g_varchar2) <>

377: nvl(per_pat_shd.g_old_rec.information11, hr_api.g_varchar2) <>
378: nvl(p_rec.information11, hr_api.g_varchar2) or
379: nvl(per_pat_shd.g_old_rec.information12, hr_api.g_varchar2) <>
380: nvl(p_rec.information12, hr_api.g_varchar2) or
381: nvl(per_pat_shd.g_old_rec.information13, hr_api.g_varchar2) <>
382: nvl(p_rec.information13, hr_api.g_varchar2) or
383: nvl(per_pat_shd.g_old_rec.information14, hr_api.g_varchar2) <>
384: nvl(p_rec.information14, hr_api.g_varchar2) or
385: nvl(per_pat_shd.g_old_rec.information15, hr_api.g_varchar2) <>

Line 383: nvl(per_pat_shd.g_old_rec.information14, hr_api.g_varchar2) <>

379: nvl(per_pat_shd.g_old_rec.information12, hr_api.g_varchar2) <>
380: nvl(p_rec.information12, hr_api.g_varchar2) or
381: nvl(per_pat_shd.g_old_rec.information13, hr_api.g_varchar2) <>
382: nvl(p_rec.information13, hr_api.g_varchar2) or
383: nvl(per_pat_shd.g_old_rec.information14, hr_api.g_varchar2) <>
384: nvl(p_rec.information14, hr_api.g_varchar2) or
385: nvl(per_pat_shd.g_old_rec.information15, hr_api.g_varchar2) <>
386: nvl(p_rec.information15, hr_api.g_varchar2) or
387: nvl(per_pat_shd.g_old_rec.information16, hr_api.g_varchar2) <>

Line 385: nvl(per_pat_shd.g_old_rec.information15, hr_api.g_varchar2) <>

381: nvl(per_pat_shd.g_old_rec.information13, hr_api.g_varchar2) <>
382: nvl(p_rec.information13, hr_api.g_varchar2) or
383: nvl(per_pat_shd.g_old_rec.information14, hr_api.g_varchar2) <>
384: nvl(p_rec.information14, hr_api.g_varchar2) or
385: nvl(per_pat_shd.g_old_rec.information15, hr_api.g_varchar2) <>
386: nvl(p_rec.information15, hr_api.g_varchar2) or
387: nvl(per_pat_shd.g_old_rec.information16, hr_api.g_varchar2) <>
388: nvl(p_rec.information16, hr_api.g_varchar2) or
389: nvl(per_pat_shd.g_old_rec.information17, hr_api.g_varchar2) <>

Line 387: nvl(per_pat_shd.g_old_rec.information16, hr_api.g_varchar2) <>

383: nvl(per_pat_shd.g_old_rec.information14, hr_api.g_varchar2) <>
384: nvl(p_rec.information14, hr_api.g_varchar2) or
385: nvl(per_pat_shd.g_old_rec.information15, hr_api.g_varchar2) <>
386: nvl(p_rec.information15, hr_api.g_varchar2) or
387: nvl(per_pat_shd.g_old_rec.information16, hr_api.g_varchar2) <>
388: nvl(p_rec.information16, hr_api.g_varchar2) or
389: nvl(per_pat_shd.g_old_rec.information17, hr_api.g_varchar2) <>
390: nvl(p_rec.information17, hr_api.g_varchar2) or
391: nvl(per_pat_shd.g_old_rec.information18, hr_api.g_varchar2) <>

Line 389: nvl(per_pat_shd.g_old_rec.information17, hr_api.g_varchar2) <>

385: nvl(per_pat_shd.g_old_rec.information15, hr_api.g_varchar2) <>
386: nvl(p_rec.information15, hr_api.g_varchar2) or
387: nvl(per_pat_shd.g_old_rec.information16, hr_api.g_varchar2) <>
388: nvl(p_rec.information16, hr_api.g_varchar2) or
389: nvl(per_pat_shd.g_old_rec.information17, hr_api.g_varchar2) <>
390: nvl(p_rec.information17, hr_api.g_varchar2) or
391: nvl(per_pat_shd.g_old_rec.information18, hr_api.g_varchar2) <>
392: nvl(p_rec.information18, hr_api.g_varchar2) or
393: nvl(per_pat_shd.g_old_rec.information19, hr_api.g_varchar2) <>

Line 391: nvl(per_pat_shd.g_old_rec.information18, hr_api.g_varchar2) <>

387: nvl(per_pat_shd.g_old_rec.information16, hr_api.g_varchar2) <>
388: nvl(p_rec.information16, hr_api.g_varchar2) or
389: nvl(per_pat_shd.g_old_rec.information17, hr_api.g_varchar2) <>
390: nvl(p_rec.information17, hr_api.g_varchar2) or
391: nvl(per_pat_shd.g_old_rec.information18, hr_api.g_varchar2) <>
392: nvl(p_rec.information18, hr_api.g_varchar2) or
393: nvl(per_pat_shd.g_old_rec.information19, hr_api.g_varchar2) <>
394: nvl(p_rec.information19, hr_api.g_varchar2) or
395: nvl(per_pat_shd.g_old_rec.information20, hr_api.g_varchar2) <>

Line 393: nvl(per_pat_shd.g_old_rec.information19, hr_api.g_varchar2) <>

389: nvl(per_pat_shd.g_old_rec.information17, hr_api.g_varchar2) <>
390: nvl(p_rec.information17, hr_api.g_varchar2) or
391: nvl(per_pat_shd.g_old_rec.information18, hr_api.g_varchar2) <>
392: nvl(p_rec.information18, hr_api.g_varchar2) or
393: nvl(per_pat_shd.g_old_rec.information19, hr_api.g_varchar2) <>
394: nvl(p_rec.information19, hr_api.g_varchar2) or
395: nvl(per_pat_shd.g_old_rec.information20, hr_api.g_varchar2) <>
396: nvl(p_rec.information20, hr_api.g_varchar2) ))
397: or (p_rec.allocated_task_id is null) then

Line 395: nvl(per_pat_shd.g_old_rec.information20, hr_api.g_varchar2) <>

391: nvl(per_pat_shd.g_old_rec.information18, hr_api.g_varchar2) <>
392: nvl(p_rec.information18, hr_api.g_varchar2) or
393: nvl(per_pat_shd.g_old_rec.information19, hr_api.g_varchar2) <>
394: nvl(p_rec.information19, hr_api.g_varchar2) or
395: nvl(per_pat_shd.g_old_rec.information20, hr_api.g_varchar2) <>
396: nvl(p_rec.information20, hr_api.g_varchar2) ))
397: or (p_rec.allocated_task_id is null) then
398: --
399: -- Only execute the validation if absolutely necessary:

Line 484: (p_rec in per_pat_shd.g_rec_type

480: -- Internal Row Handler Use Only.
481: --
482: -- ----------------------------------------------------------------------------
483: procedure chk_df
484: (p_rec in per_pat_shd.g_rec_type
485: ) is
486: --
487: l_proc varchar2(72) := g_package || 'chk_df';
488: --

Line 494: nvl(per_pat_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

490: hr_utility.set_location('Entering:'||l_proc,10);
491: --
492:
493: /* if ((p_rec.allocated_task_id is not null) and (
494: nvl(per_pat_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
495: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
496: nvl(per_pat_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
497: nvl(p_rec.attribute1, hr_api.g_varchar2) or
498: nvl(per_pat_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 496: nvl(per_pat_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

492:
493: /* if ((p_rec.allocated_task_id is not null) and (
494: nvl(per_pat_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
495: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
496: nvl(per_pat_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
497: nvl(p_rec.attribute1, hr_api.g_varchar2) or
498: nvl(per_pat_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
499: nvl(p_rec.attribute2, hr_api.g_varchar2) or
500: nvl(per_pat_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 498: nvl(per_pat_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

494: nvl(per_pat_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
495: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
496: nvl(per_pat_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
497: nvl(p_rec.attribute1, hr_api.g_varchar2) or
498: nvl(per_pat_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
499: nvl(p_rec.attribute2, hr_api.g_varchar2) or
500: nvl(per_pat_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
501: nvl(p_rec.attribute3, hr_api.g_varchar2) or
502: nvl(per_pat_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 500: nvl(per_pat_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

496: nvl(per_pat_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
497: nvl(p_rec.attribute1, hr_api.g_varchar2) or
498: nvl(per_pat_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
499: nvl(p_rec.attribute2, hr_api.g_varchar2) or
500: nvl(per_pat_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
501: nvl(p_rec.attribute3, hr_api.g_varchar2) or
502: nvl(per_pat_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
503: nvl(p_rec.attribute4, hr_api.g_varchar2) or
504: nvl(per_pat_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 502: nvl(per_pat_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

498: nvl(per_pat_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
499: nvl(p_rec.attribute2, hr_api.g_varchar2) or
500: nvl(per_pat_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
501: nvl(p_rec.attribute3, hr_api.g_varchar2) or
502: nvl(per_pat_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
503: nvl(p_rec.attribute4, hr_api.g_varchar2) or
504: nvl(per_pat_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
505: nvl(p_rec.attribute5, hr_api.g_varchar2) or
506: nvl(per_pat_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 504: nvl(per_pat_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

500: nvl(per_pat_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
501: nvl(p_rec.attribute3, hr_api.g_varchar2) or
502: nvl(per_pat_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
503: nvl(p_rec.attribute4, hr_api.g_varchar2) or
504: nvl(per_pat_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
505: nvl(p_rec.attribute5, hr_api.g_varchar2) or
506: nvl(per_pat_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
507: nvl(p_rec.attribute6, hr_api.g_varchar2) or
508: nvl(per_pat_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 506: nvl(per_pat_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

502: nvl(per_pat_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
503: nvl(p_rec.attribute4, hr_api.g_varchar2) or
504: nvl(per_pat_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
505: nvl(p_rec.attribute5, hr_api.g_varchar2) or
506: nvl(per_pat_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
507: nvl(p_rec.attribute6, hr_api.g_varchar2) or
508: nvl(per_pat_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
509: nvl(p_rec.attribute7, hr_api.g_varchar2) or
510: nvl(per_pat_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 508: nvl(per_pat_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

504: nvl(per_pat_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
505: nvl(p_rec.attribute5, hr_api.g_varchar2) or
506: nvl(per_pat_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
507: nvl(p_rec.attribute6, hr_api.g_varchar2) or
508: nvl(per_pat_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
509: nvl(p_rec.attribute7, hr_api.g_varchar2) or
510: nvl(per_pat_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
511: nvl(p_rec.attribute8, hr_api.g_varchar2) or
512: nvl(per_pat_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 510: nvl(per_pat_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

506: nvl(per_pat_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
507: nvl(p_rec.attribute6, hr_api.g_varchar2) or
508: nvl(per_pat_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
509: nvl(p_rec.attribute7, hr_api.g_varchar2) or
510: nvl(per_pat_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
511: nvl(p_rec.attribute8, hr_api.g_varchar2) or
512: nvl(per_pat_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
513: nvl(p_rec.attribute9, hr_api.g_varchar2) or
514: nvl(per_pat_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 512: nvl(per_pat_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

508: nvl(per_pat_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
509: nvl(p_rec.attribute7, hr_api.g_varchar2) or
510: nvl(per_pat_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
511: nvl(p_rec.attribute8, hr_api.g_varchar2) or
512: nvl(per_pat_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
513: nvl(p_rec.attribute9, hr_api.g_varchar2) or
514: nvl(per_pat_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
515: nvl(p_rec.attribute10, hr_api.g_varchar2) or
516: nvl(per_pat_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 514: nvl(per_pat_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

510: nvl(per_pat_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
511: nvl(p_rec.attribute8, hr_api.g_varchar2) or
512: nvl(per_pat_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
513: nvl(p_rec.attribute9, hr_api.g_varchar2) or
514: nvl(per_pat_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
515: nvl(p_rec.attribute10, hr_api.g_varchar2) or
516: nvl(per_pat_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
517: nvl(p_rec.attribute11, hr_api.g_varchar2) or
518: nvl(per_pat_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 516: nvl(per_pat_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

512: nvl(per_pat_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
513: nvl(p_rec.attribute9, hr_api.g_varchar2) or
514: nvl(per_pat_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
515: nvl(p_rec.attribute10, hr_api.g_varchar2) or
516: nvl(per_pat_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
517: nvl(p_rec.attribute11, hr_api.g_varchar2) or
518: nvl(per_pat_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
519: nvl(p_rec.attribute12, hr_api.g_varchar2) or
520: nvl(per_pat_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 518: nvl(per_pat_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

514: nvl(per_pat_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
515: nvl(p_rec.attribute10, hr_api.g_varchar2) or
516: nvl(per_pat_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
517: nvl(p_rec.attribute11, hr_api.g_varchar2) or
518: nvl(per_pat_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
519: nvl(p_rec.attribute12, hr_api.g_varchar2) or
520: nvl(per_pat_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
521: nvl(p_rec.attribute13, hr_api.g_varchar2) or
522: nvl(per_pat_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 520: nvl(per_pat_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

516: nvl(per_pat_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
517: nvl(p_rec.attribute11, hr_api.g_varchar2) or
518: nvl(per_pat_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
519: nvl(p_rec.attribute12, hr_api.g_varchar2) or
520: nvl(per_pat_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
521: nvl(p_rec.attribute13, hr_api.g_varchar2) or
522: nvl(per_pat_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
523: nvl(p_rec.attribute14, hr_api.g_varchar2) or
524: nvl(per_pat_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 522: nvl(per_pat_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

518: nvl(per_pat_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
519: nvl(p_rec.attribute12, hr_api.g_varchar2) or
520: nvl(per_pat_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
521: nvl(p_rec.attribute13, hr_api.g_varchar2) or
522: nvl(per_pat_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
523: nvl(p_rec.attribute14, hr_api.g_varchar2) or
524: nvl(per_pat_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
525: nvl(p_rec.attribute15, hr_api.g_varchar2) or
526: nvl(per_pat_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 524: nvl(per_pat_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

520: nvl(per_pat_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
521: nvl(p_rec.attribute13, hr_api.g_varchar2) or
522: nvl(per_pat_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
523: nvl(p_rec.attribute14, hr_api.g_varchar2) or
524: nvl(per_pat_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
525: nvl(p_rec.attribute15, hr_api.g_varchar2) or
526: nvl(per_pat_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
527: nvl(p_rec.attribute16, hr_api.g_varchar2) or
528: nvl(per_pat_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 526: nvl(per_pat_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

522: nvl(per_pat_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
523: nvl(p_rec.attribute14, hr_api.g_varchar2) or
524: nvl(per_pat_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
525: nvl(p_rec.attribute15, hr_api.g_varchar2) or
526: nvl(per_pat_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
527: nvl(p_rec.attribute16, hr_api.g_varchar2) or
528: nvl(per_pat_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
529: nvl(p_rec.attribute17, hr_api.g_varchar2) or
530: nvl(per_pat_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 528: nvl(per_pat_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

524: nvl(per_pat_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
525: nvl(p_rec.attribute15, hr_api.g_varchar2) or
526: nvl(per_pat_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
527: nvl(p_rec.attribute16, hr_api.g_varchar2) or
528: nvl(per_pat_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
529: nvl(p_rec.attribute17, hr_api.g_varchar2) or
530: nvl(per_pat_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
531: nvl(p_rec.attribute18, hr_api.g_varchar2) or
532: nvl(per_pat_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 530: nvl(per_pat_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

526: nvl(per_pat_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
527: nvl(p_rec.attribute16, hr_api.g_varchar2) or
528: nvl(per_pat_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
529: nvl(p_rec.attribute17, hr_api.g_varchar2) or
530: nvl(per_pat_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
531: nvl(p_rec.attribute18, hr_api.g_varchar2) or
532: nvl(per_pat_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
533: nvl(p_rec.attribute19, hr_api.g_varchar2) or
534: nvl(per_pat_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 532: nvl(per_pat_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

528: nvl(per_pat_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
529: nvl(p_rec.attribute17, hr_api.g_varchar2) or
530: nvl(per_pat_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
531: nvl(p_rec.attribute18, hr_api.g_varchar2) or
532: nvl(per_pat_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
533: nvl(p_rec.attribute19, hr_api.g_varchar2) or
534: nvl(per_pat_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
535: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
536: or (p_rec.allocated_task_id is null) then

Line 534: nvl(per_pat_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

530: nvl(per_pat_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
531: nvl(p_rec.attribute18, hr_api.g_varchar2) or
532: nvl(per_pat_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
533: nvl(p_rec.attribute19, hr_api.g_varchar2) or
534: nvl(per_pat_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
535: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
536: or (p_rec.allocated_task_id is null) then
537: --
538: -- Only execute the validation if absolutely necessary:

Line 623: ,p_rec in per_pat_shd.g_rec_type

619: -- {End Of Comments}
620: -- ----------------------------------------------------------------------------
621: Procedure chk_non_updateable_args
622: (p_effective_date in date
623: ,p_rec in per_pat_shd.g_rec_type
624: ) IS
625: --
626: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
627: --

Line 633: IF NOT per_pat_shd.api_updating

629: --
630: -- Only proceed with the validation if a row exists for the current
631: -- record in the HR Schema.
632: --
633: IF NOT per_pat_shd.api_updating
634: (p_allocated_task_id => p_rec.allocated_task_id
635: ,p_object_version_number => p_rec.object_version_number
636: ) THEN
637: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 653: ,p_rec in per_pat_shd.g_rec_type

649: -- |---------------------------< insert_validate >----------------------------|
650: -- ----------------------------------------------------------------------------
651: Procedure insert_validate
652: (p_effective_date in date
653: ,p_rec in per_pat_shd.g_rec_type
654: ) is
655: --
656: l_proc varchar2(72) := g_package||'insert_validate';
657: --

Line 691: ,p_rec in per_pat_shd.g_rec_type

687: -- |---------------------------< update_validate >----------------------------|
688: -- ----------------------------------------------------------------------------
689: Procedure update_validate
690: (p_effective_date in date
691: ,p_rec in per_pat_shd.g_rec_type
692: ) is
693: --
694: l_proc varchar2(72) := g_package||'update_validate';
695: --

Line 734: (p_rec in per_pat_shd.g_rec_type

730: -- ----------------------------------------------------------------------------
731: -- |---------------------------< delete_validate >----------------------------|
732: -- ----------------------------------------------------------------------------
733: Procedure delete_validate
734: (p_rec in per_pat_shd.g_rec_type
735: ) is
736: --
737: l_proc varchar2(72) := g_package||'delete_validate';
738: --