APPS.PER_CKL_BUS dependencies on PER_CKL_SHD

Line 197: l_api_updating := per_ckl_shd.api_updating

193: -- a) The current g_old_rec is current and
194: -- b) The checklist name value has changed
195: -- c) a record is being inserted
196: --
197: l_api_updating := per_ckl_shd.api_updating
198: (p_checklist_id => p_checklist_id
199: ,p_object_version_number => p_object_version_number
200: );
201:

Line 203: and nvl(per_ckl_shd.g_old_rec.name, hr_api.g_varchar2) = nvl(p_name,hr_api.g_varchar2)

199: ,p_object_version_number => p_object_version_number
200: );
201:
202: IF (l_api_updating
203: and nvl(per_ckl_shd.g_old_rec.name, hr_api.g_varchar2) = nvl(p_name,hr_api.g_varchar2)
204: )
205: THEN
206: RETURN;
207: END IF;

Line 364: (nvl(per_ckl_shd.g_old_rec.checklist_category,hr_api.g_varchar2) <> nvl(p_ckl_category,hr_api.g_varchar2)))) then

360: -- b) The value for category has changed
361: --
362: if ((p_checklist_id is null) or
363: ((p_checklist_id is not null) and
364: (nvl(per_ckl_shd.g_old_rec.checklist_category,hr_api.g_varchar2) <> nvl(p_ckl_category,hr_api.g_varchar2)))) then
365: --
366: if hr_api.not_exists_in_leg_lookups
367: (p_effective_date => p_effective_date
368: ,p_lookup_type => 'CHECKLIST_CATEGORY'

Line 422: (p_rec in per_ckl_shd.g_rec_type

418: -- Internal Row Handler Use Only.
419: --
420: -- ----------------------------------------------------------------------------
421: procedure chk_ddf
422: (p_rec in per_ckl_shd.g_rec_type
423: ) is
424: --
425: l_proc varchar2(72) := g_package || 'chk_ddf';
426: --

Line 431: nvl(per_ckl_shd.g_old_rec.information_category, hr_api.g_varchar2) <>

427: begin
428: hr_utility.set_location('Entering:'||l_proc,10);
429: --
430: if ((p_rec.checklist_id is not null) and (
431: nvl(per_ckl_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
432: nvl(p_rec.information_category, hr_api.g_varchar2) or
433: nvl(per_ckl_shd.g_old_rec.information1, hr_api.g_varchar2) <>
434: nvl(p_rec.information1, hr_api.g_varchar2) or
435: nvl(per_ckl_shd.g_old_rec.information2, hr_api.g_varchar2) <>

Line 433: nvl(per_ckl_shd.g_old_rec.information1, hr_api.g_varchar2) <>

429: --
430: if ((p_rec.checklist_id is not null) and (
431: nvl(per_ckl_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
432: nvl(p_rec.information_category, hr_api.g_varchar2) or
433: nvl(per_ckl_shd.g_old_rec.information1, hr_api.g_varchar2) <>
434: nvl(p_rec.information1, hr_api.g_varchar2) or
435: nvl(per_ckl_shd.g_old_rec.information2, hr_api.g_varchar2) <>
436: nvl(p_rec.information2, hr_api.g_varchar2) or
437: nvl(per_ckl_shd.g_old_rec.information3, hr_api.g_varchar2) <>

Line 435: nvl(per_ckl_shd.g_old_rec.information2, hr_api.g_varchar2) <>

431: nvl(per_ckl_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
432: nvl(p_rec.information_category, hr_api.g_varchar2) or
433: nvl(per_ckl_shd.g_old_rec.information1, hr_api.g_varchar2) <>
434: nvl(p_rec.information1, hr_api.g_varchar2) or
435: nvl(per_ckl_shd.g_old_rec.information2, hr_api.g_varchar2) <>
436: nvl(p_rec.information2, hr_api.g_varchar2) or
437: nvl(per_ckl_shd.g_old_rec.information3, hr_api.g_varchar2) <>
438: nvl(p_rec.information3, hr_api.g_varchar2) or
439: nvl(per_ckl_shd.g_old_rec.information4, hr_api.g_varchar2) <>

Line 437: nvl(per_ckl_shd.g_old_rec.information3, hr_api.g_varchar2) <>

433: nvl(per_ckl_shd.g_old_rec.information1, hr_api.g_varchar2) <>
434: nvl(p_rec.information1, hr_api.g_varchar2) or
435: nvl(per_ckl_shd.g_old_rec.information2, hr_api.g_varchar2) <>
436: nvl(p_rec.information2, hr_api.g_varchar2) or
437: nvl(per_ckl_shd.g_old_rec.information3, hr_api.g_varchar2) <>
438: nvl(p_rec.information3, hr_api.g_varchar2) or
439: nvl(per_ckl_shd.g_old_rec.information4, hr_api.g_varchar2) <>
440: nvl(p_rec.information4, hr_api.g_varchar2) or
441: nvl(per_ckl_shd.g_old_rec.information5, hr_api.g_varchar2) <>

Line 439: nvl(per_ckl_shd.g_old_rec.information4, hr_api.g_varchar2) <>

435: nvl(per_ckl_shd.g_old_rec.information2, hr_api.g_varchar2) <>
436: nvl(p_rec.information2, hr_api.g_varchar2) or
437: nvl(per_ckl_shd.g_old_rec.information3, hr_api.g_varchar2) <>
438: nvl(p_rec.information3, hr_api.g_varchar2) or
439: nvl(per_ckl_shd.g_old_rec.information4, hr_api.g_varchar2) <>
440: nvl(p_rec.information4, hr_api.g_varchar2) or
441: nvl(per_ckl_shd.g_old_rec.information5, hr_api.g_varchar2) <>
442: nvl(p_rec.information5, hr_api.g_varchar2) or
443: nvl(per_ckl_shd.g_old_rec.information6, hr_api.g_varchar2) <>

Line 441: nvl(per_ckl_shd.g_old_rec.information5, hr_api.g_varchar2) <>

437: nvl(per_ckl_shd.g_old_rec.information3, hr_api.g_varchar2) <>
438: nvl(p_rec.information3, hr_api.g_varchar2) or
439: nvl(per_ckl_shd.g_old_rec.information4, hr_api.g_varchar2) <>
440: nvl(p_rec.information4, hr_api.g_varchar2) or
441: nvl(per_ckl_shd.g_old_rec.information5, hr_api.g_varchar2) <>
442: nvl(p_rec.information5, hr_api.g_varchar2) or
443: nvl(per_ckl_shd.g_old_rec.information6, hr_api.g_varchar2) <>
444: nvl(p_rec.information6, hr_api.g_varchar2) or
445: nvl(per_ckl_shd.g_old_rec.information7, hr_api.g_varchar2) <>

Line 443: nvl(per_ckl_shd.g_old_rec.information6, hr_api.g_varchar2) <>

439: nvl(per_ckl_shd.g_old_rec.information4, hr_api.g_varchar2) <>
440: nvl(p_rec.information4, hr_api.g_varchar2) or
441: nvl(per_ckl_shd.g_old_rec.information5, hr_api.g_varchar2) <>
442: nvl(p_rec.information5, hr_api.g_varchar2) or
443: nvl(per_ckl_shd.g_old_rec.information6, hr_api.g_varchar2) <>
444: nvl(p_rec.information6, hr_api.g_varchar2) or
445: nvl(per_ckl_shd.g_old_rec.information7, hr_api.g_varchar2) <>
446: nvl(p_rec.information7, hr_api.g_varchar2) or
447: nvl(per_ckl_shd.g_old_rec.information8, hr_api.g_varchar2) <>

Line 445: nvl(per_ckl_shd.g_old_rec.information7, hr_api.g_varchar2) <>

441: nvl(per_ckl_shd.g_old_rec.information5, hr_api.g_varchar2) <>
442: nvl(p_rec.information5, hr_api.g_varchar2) or
443: nvl(per_ckl_shd.g_old_rec.information6, hr_api.g_varchar2) <>
444: nvl(p_rec.information6, hr_api.g_varchar2) or
445: nvl(per_ckl_shd.g_old_rec.information7, hr_api.g_varchar2) <>
446: nvl(p_rec.information7, hr_api.g_varchar2) or
447: nvl(per_ckl_shd.g_old_rec.information8, hr_api.g_varchar2) <>
448: nvl(p_rec.information8, hr_api.g_varchar2) or
449: nvl(per_ckl_shd.g_old_rec.information9, hr_api.g_varchar2) <>

Line 447: nvl(per_ckl_shd.g_old_rec.information8, hr_api.g_varchar2) <>

443: nvl(per_ckl_shd.g_old_rec.information6, hr_api.g_varchar2) <>
444: nvl(p_rec.information6, hr_api.g_varchar2) or
445: nvl(per_ckl_shd.g_old_rec.information7, hr_api.g_varchar2) <>
446: nvl(p_rec.information7, hr_api.g_varchar2) or
447: nvl(per_ckl_shd.g_old_rec.information8, hr_api.g_varchar2) <>
448: nvl(p_rec.information8, hr_api.g_varchar2) or
449: nvl(per_ckl_shd.g_old_rec.information9, hr_api.g_varchar2) <>
450: nvl(p_rec.information9, hr_api.g_varchar2) or
451: nvl(per_ckl_shd.g_old_rec.information10, hr_api.g_varchar2) <>

Line 449: nvl(per_ckl_shd.g_old_rec.information9, hr_api.g_varchar2) <>

445: nvl(per_ckl_shd.g_old_rec.information7, hr_api.g_varchar2) <>
446: nvl(p_rec.information7, hr_api.g_varchar2) or
447: nvl(per_ckl_shd.g_old_rec.information8, hr_api.g_varchar2) <>
448: nvl(p_rec.information8, hr_api.g_varchar2) or
449: nvl(per_ckl_shd.g_old_rec.information9, hr_api.g_varchar2) <>
450: nvl(p_rec.information9, hr_api.g_varchar2) or
451: nvl(per_ckl_shd.g_old_rec.information10, hr_api.g_varchar2) <>
452: nvl(p_rec.information10, hr_api.g_varchar2) or
453: nvl(per_ckl_shd.g_old_rec.information11, hr_api.g_varchar2) <>

Line 451: nvl(per_ckl_shd.g_old_rec.information10, hr_api.g_varchar2) <>

447: nvl(per_ckl_shd.g_old_rec.information8, hr_api.g_varchar2) <>
448: nvl(p_rec.information8, hr_api.g_varchar2) or
449: nvl(per_ckl_shd.g_old_rec.information9, hr_api.g_varchar2) <>
450: nvl(p_rec.information9, hr_api.g_varchar2) or
451: nvl(per_ckl_shd.g_old_rec.information10, hr_api.g_varchar2) <>
452: nvl(p_rec.information10, hr_api.g_varchar2) or
453: nvl(per_ckl_shd.g_old_rec.information11, hr_api.g_varchar2) <>
454: nvl(p_rec.information11, hr_api.g_varchar2) or
455: nvl(per_ckl_shd.g_old_rec.information12, hr_api.g_varchar2) <>

Line 453: nvl(per_ckl_shd.g_old_rec.information11, hr_api.g_varchar2) <>

449: nvl(per_ckl_shd.g_old_rec.information9, hr_api.g_varchar2) <>
450: nvl(p_rec.information9, hr_api.g_varchar2) or
451: nvl(per_ckl_shd.g_old_rec.information10, hr_api.g_varchar2) <>
452: nvl(p_rec.information10, hr_api.g_varchar2) or
453: nvl(per_ckl_shd.g_old_rec.information11, hr_api.g_varchar2) <>
454: nvl(p_rec.information11, hr_api.g_varchar2) or
455: nvl(per_ckl_shd.g_old_rec.information12, hr_api.g_varchar2) <>
456: nvl(p_rec.information12, hr_api.g_varchar2) or
457: nvl(per_ckl_shd.g_old_rec.information13, hr_api.g_varchar2) <>

Line 455: nvl(per_ckl_shd.g_old_rec.information12, hr_api.g_varchar2) <>

451: nvl(per_ckl_shd.g_old_rec.information10, hr_api.g_varchar2) <>
452: nvl(p_rec.information10, hr_api.g_varchar2) or
453: nvl(per_ckl_shd.g_old_rec.information11, hr_api.g_varchar2) <>
454: nvl(p_rec.information11, hr_api.g_varchar2) or
455: nvl(per_ckl_shd.g_old_rec.information12, hr_api.g_varchar2) <>
456: nvl(p_rec.information12, hr_api.g_varchar2) or
457: nvl(per_ckl_shd.g_old_rec.information13, hr_api.g_varchar2) <>
458: nvl(p_rec.information13, hr_api.g_varchar2) or
459: nvl(per_ckl_shd.g_old_rec.information14, hr_api.g_varchar2) <>

Line 457: nvl(per_ckl_shd.g_old_rec.information13, hr_api.g_varchar2) <>

453: nvl(per_ckl_shd.g_old_rec.information11, hr_api.g_varchar2) <>
454: nvl(p_rec.information11, hr_api.g_varchar2) or
455: nvl(per_ckl_shd.g_old_rec.information12, hr_api.g_varchar2) <>
456: nvl(p_rec.information12, hr_api.g_varchar2) or
457: nvl(per_ckl_shd.g_old_rec.information13, hr_api.g_varchar2) <>
458: nvl(p_rec.information13, hr_api.g_varchar2) or
459: nvl(per_ckl_shd.g_old_rec.information14, hr_api.g_varchar2) <>
460: nvl(p_rec.information14, hr_api.g_varchar2) or
461: nvl(per_ckl_shd.g_old_rec.information15, hr_api.g_varchar2) <>

Line 459: nvl(per_ckl_shd.g_old_rec.information14, hr_api.g_varchar2) <>

455: nvl(per_ckl_shd.g_old_rec.information12, hr_api.g_varchar2) <>
456: nvl(p_rec.information12, hr_api.g_varchar2) or
457: nvl(per_ckl_shd.g_old_rec.information13, hr_api.g_varchar2) <>
458: nvl(p_rec.information13, hr_api.g_varchar2) or
459: nvl(per_ckl_shd.g_old_rec.information14, hr_api.g_varchar2) <>
460: nvl(p_rec.information14, hr_api.g_varchar2) or
461: nvl(per_ckl_shd.g_old_rec.information15, hr_api.g_varchar2) <>
462: nvl(p_rec.information15, hr_api.g_varchar2) or
463: nvl(per_ckl_shd.g_old_rec.information16, hr_api.g_varchar2) <>

Line 461: nvl(per_ckl_shd.g_old_rec.information15, hr_api.g_varchar2) <>

457: nvl(per_ckl_shd.g_old_rec.information13, hr_api.g_varchar2) <>
458: nvl(p_rec.information13, hr_api.g_varchar2) or
459: nvl(per_ckl_shd.g_old_rec.information14, hr_api.g_varchar2) <>
460: nvl(p_rec.information14, hr_api.g_varchar2) or
461: nvl(per_ckl_shd.g_old_rec.information15, hr_api.g_varchar2) <>
462: nvl(p_rec.information15, hr_api.g_varchar2) or
463: nvl(per_ckl_shd.g_old_rec.information16, hr_api.g_varchar2) <>
464: nvl(p_rec.information16, hr_api.g_varchar2) or
465: nvl(per_ckl_shd.g_old_rec.information17, hr_api.g_varchar2) <>

Line 463: nvl(per_ckl_shd.g_old_rec.information16, hr_api.g_varchar2) <>

459: nvl(per_ckl_shd.g_old_rec.information14, hr_api.g_varchar2) <>
460: nvl(p_rec.information14, hr_api.g_varchar2) or
461: nvl(per_ckl_shd.g_old_rec.information15, hr_api.g_varchar2) <>
462: nvl(p_rec.information15, hr_api.g_varchar2) or
463: nvl(per_ckl_shd.g_old_rec.information16, hr_api.g_varchar2) <>
464: nvl(p_rec.information16, hr_api.g_varchar2) or
465: nvl(per_ckl_shd.g_old_rec.information17, hr_api.g_varchar2) <>
466: nvl(p_rec.information17, hr_api.g_varchar2) or
467: nvl(per_ckl_shd.g_old_rec.information18, hr_api.g_varchar2) <>

Line 465: nvl(per_ckl_shd.g_old_rec.information17, hr_api.g_varchar2) <>

461: nvl(per_ckl_shd.g_old_rec.information15, hr_api.g_varchar2) <>
462: nvl(p_rec.information15, hr_api.g_varchar2) or
463: nvl(per_ckl_shd.g_old_rec.information16, hr_api.g_varchar2) <>
464: nvl(p_rec.information16, hr_api.g_varchar2) or
465: nvl(per_ckl_shd.g_old_rec.information17, hr_api.g_varchar2) <>
466: nvl(p_rec.information17, hr_api.g_varchar2) or
467: nvl(per_ckl_shd.g_old_rec.information18, hr_api.g_varchar2) <>
468: nvl(p_rec.information18, hr_api.g_varchar2) or
469: nvl(per_ckl_shd.g_old_rec.information19, hr_api.g_varchar2) <>

Line 467: nvl(per_ckl_shd.g_old_rec.information18, hr_api.g_varchar2) <>

463: nvl(per_ckl_shd.g_old_rec.information16, hr_api.g_varchar2) <>
464: nvl(p_rec.information16, hr_api.g_varchar2) or
465: nvl(per_ckl_shd.g_old_rec.information17, hr_api.g_varchar2) <>
466: nvl(p_rec.information17, hr_api.g_varchar2) or
467: nvl(per_ckl_shd.g_old_rec.information18, hr_api.g_varchar2) <>
468: nvl(p_rec.information18, hr_api.g_varchar2) or
469: nvl(per_ckl_shd.g_old_rec.information19, hr_api.g_varchar2) <>
470: nvl(p_rec.information19, hr_api.g_varchar2) or
471: nvl(per_ckl_shd.g_old_rec.information20, hr_api.g_varchar2) <>

Line 469: nvl(per_ckl_shd.g_old_rec.information19, hr_api.g_varchar2) <>

465: nvl(per_ckl_shd.g_old_rec.information17, hr_api.g_varchar2) <>
466: nvl(p_rec.information17, hr_api.g_varchar2) or
467: nvl(per_ckl_shd.g_old_rec.information18, hr_api.g_varchar2) <>
468: nvl(p_rec.information18, hr_api.g_varchar2) or
469: nvl(per_ckl_shd.g_old_rec.information19, hr_api.g_varchar2) <>
470: nvl(p_rec.information19, hr_api.g_varchar2) or
471: nvl(per_ckl_shd.g_old_rec.information20, hr_api.g_varchar2) <>
472: nvl(p_rec.information20, hr_api.g_varchar2) ))
473: or (p_rec.checklist_id is null) then

Line 471: nvl(per_ckl_shd.g_old_rec.information20, hr_api.g_varchar2) <>

467: nvl(per_ckl_shd.g_old_rec.information18, hr_api.g_varchar2) <>
468: nvl(p_rec.information18, hr_api.g_varchar2) or
469: nvl(per_ckl_shd.g_old_rec.information19, hr_api.g_varchar2) <>
470: nvl(p_rec.information19, hr_api.g_varchar2) or
471: nvl(per_ckl_shd.g_old_rec.information20, hr_api.g_varchar2) <>
472: nvl(p_rec.information20, hr_api.g_varchar2) ))
473: or (p_rec.checklist_id is null) then
474: --
475: -- Only execute the validation if absolutely necessary:

Line 559: (p_rec in per_ckl_shd.g_rec_type

555: -- Internal Row Handler Use Only.
556: --
557: -- ----------------------------------------------------------------------------
558: procedure chk_df
559: (p_rec in per_ckl_shd.g_rec_type
560: ) is
561: --
562: l_proc varchar2(72) := g_package || 'chk_df';
563: --

Line 568: nvl(per_ckl_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

564: begin
565: hr_utility.set_location('Entering:'||l_proc,10);
566: --
567: if ((p_rec.checklist_id is not null) and (
568: nvl(per_ckl_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
569: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
570: nvl(per_ckl_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
571: nvl(p_rec.attribute1, hr_api.g_varchar2) or
572: nvl(per_ckl_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 570: nvl(per_ckl_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

566: --
567: if ((p_rec.checklist_id is not null) and (
568: nvl(per_ckl_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
569: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
570: nvl(per_ckl_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
571: nvl(p_rec.attribute1, hr_api.g_varchar2) or
572: nvl(per_ckl_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
573: nvl(p_rec.attribute2, hr_api.g_varchar2) or
574: nvl(per_ckl_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 572: nvl(per_ckl_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

568: nvl(per_ckl_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
569: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
570: nvl(per_ckl_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
571: nvl(p_rec.attribute1, hr_api.g_varchar2) or
572: nvl(per_ckl_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
573: nvl(p_rec.attribute2, hr_api.g_varchar2) or
574: nvl(per_ckl_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
575: nvl(p_rec.attribute3, hr_api.g_varchar2) or
576: nvl(per_ckl_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 574: nvl(per_ckl_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

570: nvl(per_ckl_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
571: nvl(p_rec.attribute1, hr_api.g_varchar2) or
572: nvl(per_ckl_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
573: nvl(p_rec.attribute2, hr_api.g_varchar2) or
574: nvl(per_ckl_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
575: nvl(p_rec.attribute3, hr_api.g_varchar2) or
576: nvl(per_ckl_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
577: nvl(p_rec.attribute4, hr_api.g_varchar2) or
578: nvl(per_ckl_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 576: nvl(per_ckl_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

572: nvl(per_ckl_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
573: nvl(p_rec.attribute2, hr_api.g_varchar2) or
574: nvl(per_ckl_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
575: nvl(p_rec.attribute3, hr_api.g_varchar2) or
576: nvl(per_ckl_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
577: nvl(p_rec.attribute4, hr_api.g_varchar2) or
578: nvl(per_ckl_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
579: nvl(p_rec.attribute5, hr_api.g_varchar2) or
580: nvl(per_ckl_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 578: nvl(per_ckl_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

574: nvl(per_ckl_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
575: nvl(p_rec.attribute3, hr_api.g_varchar2) or
576: nvl(per_ckl_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
577: nvl(p_rec.attribute4, hr_api.g_varchar2) or
578: nvl(per_ckl_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
579: nvl(p_rec.attribute5, hr_api.g_varchar2) or
580: nvl(per_ckl_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
581: nvl(p_rec.attribute6, hr_api.g_varchar2) or
582: nvl(per_ckl_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 580: nvl(per_ckl_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

576: nvl(per_ckl_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
577: nvl(p_rec.attribute4, hr_api.g_varchar2) or
578: nvl(per_ckl_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
579: nvl(p_rec.attribute5, hr_api.g_varchar2) or
580: nvl(per_ckl_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
581: nvl(p_rec.attribute6, hr_api.g_varchar2) or
582: nvl(per_ckl_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
583: nvl(p_rec.attribute7, hr_api.g_varchar2) or
584: nvl(per_ckl_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 582: nvl(per_ckl_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

578: nvl(per_ckl_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
579: nvl(p_rec.attribute5, hr_api.g_varchar2) or
580: nvl(per_ckl_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
581: nvl(p_rec.attribute6, hr_api.g_varchar2) or
582: nvl(per_ckl_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
583: nvl(p_rec.attribute7, hr_api.g_varchar2) or
584: nvl(per_ckl_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
585: nvl(p_rec.attribute8, hr_api.g_varchar2) or
586: nvl(per_ckl_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 584: nvl(per_ckl_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

580: nvl(per_ckl_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
581: nvl(p_rec.attribute6, hr_api.g_varchar2) or
582: nvl(per_ckl_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
583: nvl(p_rec.attribute7, hr_api.g_varchar2) or
584: nvl(per_ckl_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
585: nvl(p_rec.attribute8, hr_api.g_varchar2) or
586: nvl(per_ckl_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
587: nvl(p_rec.attribute9, hr_api.g_varchar2) or
588: nvl(per_ckl_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 586: nvl(per_ckl_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

582: nvl(per_ckl_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
583: nvl(p_rec.attribute7, hr_api.g_varchar2) or
584: nvl(per_ckl_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
585: nvl(p_rec.attribute8, hr_api.g_varchar2) or
586: nvl(per_ckl_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
587: nvl(p_rec.attribute9, hr_api.g_varchar2) or
588: nvl(per_ckl_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
589: nvl(p_rec.attribute10, hr_api.g_varchar2) or
590: nvl(per_ckl_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 588: nvl(per_ckl_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

584: nvl(per_ckl_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
585: nvl(p_rec.attribute8, hr_api.g_varchar2) or
586: nvl(per_ckl_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
587: nvl(p_rec.attribute9, hr_api.g_varchar2) or
588: nvl(per_ckl_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
589: nvl(p_rec.attribute10, hr_api.g_varchar2) or
590: nvl(per_ckl_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
591: nvl(p_rec.attribute11, hr_api.g_varchar2) or
592: nvl(per_ckl_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 590: nvl(per_ckl_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

586: nvl(per_ckl_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
587: nvl(p_rec.attribute9, hr_api.g_varchar2) or
588: nvl(per_ckl_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
589: nvl(p_rec.attribute10, hr_api.g_varchar2) or
590: nvl(per_ckl_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
591: nvl(p_rec.attribute11, hr_api.g_varchar2) or
592: nvl(per_ckl_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
593: nvl(p_rec.attribute12, hr_api.g_varchar2) or
594: nvl(per_ckl_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 592: nvl(per_ckl_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

588: nvl(per_ckl_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
589: nvl(p_rec.attribute10, hr_api.g_varchar2) or
590: nvl(per_ckl_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
591: nvl(p_rec.attribute11, hr_api.g_varchar2) or
592: nvl(per_ckl_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
593: nvl(p_rec.attribute12, hr_api.g_varchar2) or
594: nvl(per_ckl_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
595: nvl(p_rec.attribute13, hr_api.g_varchar2) or
596: nvl(per_ckl_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 594: nvl(per_ckl_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

590: nvl(per_ckl_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
591: nvl(p_rec.attribute11, hr_api.g_varchar2) or
592: nvl(per_ckl_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
593: nvl(p_rec.attribute12, hr_api.g_varchar2) or
594: nvl(per_ckl_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
595: nvl(p_rec.attribute13, hr_api.g_varchar2) or
596: nvl(per_ckl_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
597: nvl(p_rec.attribute14, hr_api.g_varchar2) or
598: nvl(per_ckl_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 596: nvl(per_ckl_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

592: nvl(per_ckl_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
593: nvl(p_rec.attribute12, hr_api.g_varchar2) or
594: nvl(per_ckl_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
595: nvl(p_rec.attribute13, hr_api.g_varchar2) or
596: nvl(per_ckl_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
597: nvl(p_rec.attribute14, hr_api.g_varchar2) or
598: nvl(per_ckl_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
599: nvl(p_rec.attribute15, hr_api.g_varchar2) or
600: nvl(per_ckl_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 598: nvl(per_ckl_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

594: nvl(per_ckl_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
595: nvl(p_rec.attribute13, hr_api.g_varchar2) or
596: nvl(per_ckl_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
597: nvl(p_rec.attribute14, hr_api.g_varchar2) or
598: nvl(per_ckl_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
599: nvl(p_rec.attribute15, hr_api.g_varchar2) or
600: nvl(per_ckl_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
601: nvl(p_rec.attribute16, hr_api.g_varchar2) or
602: nvl(per_ckl_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 600: nvl(per_ckl_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

596: nvl(per_ckl_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
597: nvl(p_rec.attribute14, hr_api.g_varchar2) or
598: nvl(per_ckl_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
599: nvl(p_rec.attribute15, hr_api.g_varchar2) or
600: nvl(per_ckl_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
601: nvl(p_rec.attribute16, hr_api.g_varchar2) or
602: nvl(per_ckl_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
603: nvl(p_rec.attribute17, hr_api.g_varchar2) or
604: nvl(per_ckl_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 602: nvl(per_ckl_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

598: nvl(per_ckl_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
599: nvl(p_rec.attribute15, hr_api.g_varchar2) or
600: nvl(per_ckl_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
601: nvl(p_rec.attribute16, hr_api.g_varchar2) or
602: nvl(per_ckl_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
603: nvl(p_rec.attribute17, hr_api.g_varchar2) or
604: nvl(per_ckl_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
605: nvl(p_rec.attribute18, hr_api.g_varchar2) or
606: nvl(per_ckl_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 604: nvl(per_ckl_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

600: nvl(per_ckl_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
601: nvl(p_rec.attribute16, hr_api.g_varchar2) or
602: nvl(per_ckl_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
603: nvl(p_rec.attribute17, hr_api.g_varchar2) or
604: nvl(per_ckl_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
605: nvl(p_rec.attribute18, hr_api.g_varchar2) or
606: nvl(per_ckl_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
607: nvl(p_rec.attribute19, hr_api.g_varchar2) or
608: nvl(per_ckl_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 606: nvl(per_ckl_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

602: nvl(per_ckl_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
603: nvl(p_rec.attribute17, hr_api.g_varchar2) or
604: nvl(per_ckl_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
605: nvl(p_rec.attribute18, hr_api.g_varchar2) or
606: nvl(per_ckl_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
607: nvl(p_rec.attribute19, hr_api.g_varchar2) or
608: nvl(per_ckl_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
609: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
610: or (p_rec.checklist_id is null) then

Line 608: nvl(per_ckl_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

604: nvl(per_ckl_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
605: nvl(p_rec.attribute18, hr_api.g_varchar2) or
606: nvl(per_ckl_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
607: nvl(p_rec.attribute19, hr_api.g_varchar2) or
608: nvl(per_ckl_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
609: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
610: or (p_rec.checklist_id is null) then
611: --
612: -- Only execute the validation if absolutely necessary:

Line 696: ,p_rec in per_ckl_shd.g_rec_type

692: -- {End Of Comments}
693: -- ----------------------------------------------------------------------------
694: Procedure chk_non_updateable_args
695: (p_effective_date in date
696: ,p_rec in per_ckl_shd.g_rec_type
697: ) IS
698: --
699: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
700: --

Line 706: IF NOT per_ckl_shd.api_updating

702: --
703: -- Only proceed with the validation if a row exists for the current
704: -- record in the HR Schema.
705: --
706: IF NOT per_ckl_shd.api_updating
707: (p_checklist_id => p_rec.checklist_id
708: ,p_object_version_number => p_rec.object_version_number
709: ) THEN
710: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 726: ,p_rec in per_ckl_shd.g_rec_type

722: -- |---------------------------< insert_validate >----------------------------|
723: -- ----------------------------------------------------------------------------
724: Procedure insert_validate
725: (p_effective_date in date
726: ,p_rec in per_ckl_shd.g_rec_type
727: ) is
728: --
729: l_proc varchar2(72) := g_package||'insert_validate';
730: --

Line 738: ,p_associated_column1 => per_ckl_shd.g_tab_nam

734: -- Call all supporting business operations
735: --
736: hr_api.validate_bus_grp_id
737: (p_business_group_id => p_rec.business_group_id
738: ,p_associated_column1 => per_ckl_shd.g_tab_nam
739: || '.BUSINESS_GROUP_ID');
740: --
741: per_ckl_bus.chk_name
742: (p_name => p_rec.name

Line 782: ,p_rec in per_ckl_shd.g_rec_type

778: -- |---------------------------< update_validate >----------------------------|
779: -- ----------------------------------------------------------------------------
780: Procedure update_validate
781: (p_effective_date in date
782: ,p_rec in per_ckl_shd.g_rec_type
783: ) is
784: --
785: l_proc varchar2(72) := g_package||'update_validate';
786: --

Line 794: ,p_associated_column1 => per_ckl_shd.g_tab_nam

790: -- Call all supporting business operations
791: --
792: hr_api.validate_bus_grp_id
793: (p_business_group_id => p_rec.business_group_id
794: ,p_associated_column1 => per_ckl_shd.g_tab_nam
795: || '.BUSINESS_GROUP_ID');
796: --
797: --
798: per_ckl_bus.chk_name

Line 845: (p_rec in per_ckl_shd.g_rec_type

841: -- ----------------------------------------------------------------------------
842: -- |---------------------------< delete_validate >----------------------------|
843: -- ----------------------------------------------------------------------------
844: Procedure delete_validate
845: (p_rec in per_ckl_shd.g_rec_type
846: ) is
847: --
848: l_proc varchar2(72) := g_package||'delete_validate';
849: --