APPS.PER_CTK_BUS dependencies on PER_CTK_SHD

Line 258: l_api_updating := per_ctk_shd.api_updating

254: -- a) The current g_old_rec is current and
255: -- b) The party value has changed
256: -- c) a record is being inserted
257: --
258: l_api_updating := per_ctk_shd.api_updating
259: (p_task_in_checklist_id => p_task_in_checklist_id
260: ,p_object_version_number => p_object_version_number
261: );
262: IF (l_api_updating

Line 263: and nvl(per_ctk_shd.g_old_rec.checklist_task_name, hr_api.g_varchar2)

259: (p_task_in_checklist_id => p_task_in_checklist_id
260: ,p_object_version_number => p_object_version_number
261: );
262: IF (l_api_updating
263: and nvl(per_ctk_shd.g_old_rec.checklist_task_name, hr_api.g_varchar2)
264: = nvl(p_checklist_task_name,hr_api.g_varchar2))
265: THEN
266: RETURN;
267: END IF;

Line 331: l_api_updating := per_ctk_shd.api_updating

327: -- Only proceed with validation if:
328: -- a) The current g_old_rec is current and
329: -- b) The duration_units or duration_units_uom values are changed
330: --
331: l_api_updating := per_ctk_shd.api_updating
332: (p_task_in_checklist_id => p_task_in_checklist_id
333: ,p_object_version_number => p_object_version_number
334: );
335: --

Line 337: and ( (nvl(per_ctk_shd.g_old_rec.target_duration, hr_api.g_number) = nvl(p_target_duration,hr_api.g_number))

333: ,p_object_version_number => p_object_version_number
334: );
335: --
336: IF (l_api_updating
337: and ( (nvl(per_ctk_shd.g_old_rec.target_duration, hr_api.g_number) = nvl(p_target_duration,hr_api.g_number))
338: AND
339: (nvl(per_ctk_shd.g_old_rec.target_duration_UOM, hr_api.g_varchar2) = nvl(p_target_duration_uom,hr_api.g_varchar2))
340: )
341: )

Line 339: (nvl(per_ctk_shd.g_old_rec.target_duration_UOM, hr_api.g_varchar2) = nvl(p_target_duration_uom,hr_api.g_varchar2))

335: --
336: IF (l_api_updating
337: and ( (nvl(per_ctk_shd.g_old_rec.target_duration, hr_api.g_number) = nvl(p_target_duration,hr_api.g_number))
338: AND
339: (nvl(per_ctk_shd.g_old_rec.target_duration_UOM, hr_api.g_varchar2) = nvl(p_target_duration_uom,hr_api.g_varchar2))
340: )
341: )
342: THEN
343: RETURN;

Line 562: (p_rec in per_ctk_shd.g_rec_type

558: -- Internal Row Handler Use Only.
559: --
560: -- ----------------------------------------------------------------------------
561: procedure chk_ddf
562: (p_rec in per_ctk_shd.g_rec_type
563: ) is
564: --
565: l_proc varchar2(72) := g_package || 'chk_ddf';
566: --

Line 571: nvl(per_ctk_shd.g_old_rec.information_category, hr_api.g_varchar2) <>

567: begin
568: hr_utility.set_location('Entering:'||l_proc,10);
569: --
570: if ((p_rec.task_in_checklist_id is not null) and (
571: nvl(per_ctk_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
572: nvl(p_rec.information_category, hr_api.g_varchar2) or
573: nvl(per_ctk_shd.g_old_rec.information1, hr_api.g_varchar2) <>
574: nvl(p_rec.information1, hr_api.g_varchar2) or
575: nvl(per_ctk_shd.g_old_rec.information2, hr_api.g_varchar2) <>

Line 573: nvl(per_ctk_shd.g_old_rec.information1, hr_api.g_varchar2) <>

569: --
570: if ((p_rec.task_in_checklist_id is not null) and (
571: nvl(per_ctk_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
572: nvl(p_rec.information_category, hr_api.g_varchar2) or
573: nvl(per_ctk_shd.g_old_rec.information1, hr_api.g_varchar2) <>
574: nvl(p_rec.information1, hr_api.g_varchar2) or
575: nvl(per_ctk_shd.g_old_rec.information2, hr_api.g_varchar2) <>
576: nvl(p_rec.information2, hr_api.g_varchar2) or
577: nvl(per_ctk_shd.g_old_rec.information3, hr_api.g_varchar2) <>

Line 575: nvl(per_ctk_shd.g_old_rec.information2, hr_api.g_varchar2) <>

571: nvl(per_ctk_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
572: nvl(p_rec.information_category, hr_api.g_varchar2) or
573: nvl(per_ctk_shd.g_old_rec.information1, hr_api.g_varchar2) <>
574: nvl(p_rec.information1, hr_api.g_varchar2) or
575: nvl(per_ctk_shd.g_old_rec.information2, hr_api.g_varchar2) <>
576: nvl(p_rec.information2, hr_api.g_varchar2) or
577: nvl(per_ctk_shd.g_old_rec.information3, hr_api.g_varchar2) <>
578: nvl(p_rec.information3, hr_api.g_varchar2) or
579: nvl(per_ctk_shd.g_old_rec.information4, hr_api.g_varchar2) <>

Line 577: nvl(per_ctk_shd.g_old_rec.information3, hr_api.g_varchar2) <>

573: nvl(per_ctk_shd.g_old_rec.information1, hr_api.g_varchar2) <>
574: nvl(p_rec.information1, hr_api.g_varchar2) or
575: nvl(per_ctk_shd.g_old_rec.information2, hr_api.g_varchar2) <>
576: nvl(p_rec.information2, hr_api.g_varchar2) or
577: nvl(per_ctk_shd.g_old_rec.information3, hr_api.g_varchar2) <>
578: nvl(p_rec.information3, hr_api.g_varchar2) or
579: nvl(per_ctk_shd.g_old_rec.information4, hr_api.g_varchar2) <>
580: nvl(p_rec.information4, hr_api.g_varchar2) or
581: nvl(per_ctk_shd.g_old_rec.information5, hr_api.g_varchar2) <>

Line 579: nvl(per_ctk_shd.g_old_rec.information4, hr_api.g_varchar2) <>

575: nvl(per_ctk_shd.g_old_rec.information2, hr_api.g_varchar2) <>
576: nvl(p_rec.information2, hr_api.g_varchar2) or
577: nvl(per_ctk_shd.g_old_rec.information3, hr_api.g_varchar2) <>
578: nvl(p_rec.information3, hr_api.g_varchar2) or
579: nvl(per_ctk_shd.g_old_rec.information4, hr_api.g_varchar2) <>
580: nvl(p_rec.information4, hr_api.g_varchar2) or
581: nvl(per_ctk_shd.g_old_rec.information5, hr_api.g_varchar2) <>
582: nvl(p_rec.information5, hr_api.g_varchar2) or
583: nvl(per_ctk_shd.g_old_rec.information6, hr_api.g_varchar2) <>

Line 581: nvl(per_ctk_shd.g_old_rec.information5, hr_api.g_varchar2) <>

577: nvl(per_ctk_shd.g_old_rec.information3, hr_api.g_varchar2) <>
578: nvl(p_rec.information3, hr_api.g_varchar2) or
579: nvl(per_ctk_shd.g_old_rec.information4, hr_api.g_varchar2) <>
580: nvl(p_rec.information4, hr_api.g_varchar2) or
581: nvl(per_ctk_shd.g_old_rec.information5, hr_api.g_varchar2) <>
582: nvl(p_rec.information5, hr_api.g_varchar2) or
583: nvl(per_ctk_shd.g_old_rec.information6, hr_api.g_varchar2) <>
584: nvl(p_rec.information6, hr_api.g_varchar2) or
585: nvl(per_ctk_shd.g_old_rec.information7, hr_api.g_varchar2) <>

Line 583: nvl(per_ctk_shd.g_old_rec.information6, hr_api.g_varchar2) <>

579: nvl(per_ctk_shd.g_old_rec.information4, hr_api.g_varchar2) <>
580: nvl(p_rec.information4, hr_api.g_varchar2) or
581: nvl(per_ctk_shd.g_old_rec.information5, hr_api.g_varchar2) <>
582: nvl(p_rec.information5, hr_api.g_varchar2) or
583: nvl(per_ctk_shd.g_old_rec.information6, hr_api.g_varchar2) <>
584: nvl(p_rec.information6, hr_api.g_varchar2) or
585: nvl(per_ctk_shd.g_old_rec.information7, hr_api.g_varchar2) <>
586: nvl(p_rec.information7, hr_api.g_varchar2) or
587: nvl(per_ctk_shd.g_old_rec.information8, hr_api.g_varchar2) <>

Line 585: nvl(per_ctk_shd.g_old_rec.information7, hr_api.g_varchar2) <>

581: nvl(per_ctk_shd.g_old_rec.information5, hr_api.g_varchar2) <>
582: nvl(p_rec.information5, hr_api.g_varchar2) or
583: nvl(per_ctk_shd.g_old_rec.information6, hr_api.g_varchar2) <>
584: nvl(p_rec.information6, hr_api.g_varchar2) or
585: nvl(per_ctk_shd.g_old_rec.information7, hr_api.g_varchar2) <>
586: nvl(p_rec.information7, hr_api.g_varchar2) or
587: nvl(per_ctk_shd.g_old_rec.information8, hr_api.g_varchar2) <>
588: nvl(p_rec.information8, hr_api.g_varchar2) or
589: nvl(per_ctk_shd.g_old_rec.information9, hr_api.g_varchar2) <>

Line 587: nvl(per_ctk_shd.g_old_rec.information8, hr_api.g_varchar2) <>

583: nvl(per_ctk_shd.g_old_rec.information6, hr_api.g_varchar2) <>
584: nvl(p_rec.information6, hr_api.g_varchar2) or
585: nvl(per_ctk_shd.g_old_rec.information7, hr_api.g_varchar2) <>
586: nvl(p_rec.information7, hr_api.g_varchar2) or
587: nvl(per_ctk_shd.g_old_rec.information8, hr_api.g_varchar2) <>
588: nvl(p_rec.information8, hr_api.g_varchar2) or
589: nvl(per_ctk_shd.g_old_rec.information9, hr_api.g_varchar2) <>
590: nvl(p_rec.information9, hr_api.g_varchar2) or
591: nvl(per_ctk_shd.g_old_rec.information10, hr_api.g_varchar2) <>

Line 589: nvl(per_ctk_shd.g_old_rec.information9, hr_api.g_varchar2) <>

585: nvl(per_ctk_shd.g_old_rec.information7, hr_api.g_varchar2) <>
586: nvl(p_rec.information7, hr_api.g_varchar2) or
587: nvl(per_ctk_shd.g_old_rec.information8, hr_api.g_varchar2) <>
588: nvl(p_rec.information8, hr_api.g_varchar2) or
589: nvl(per_ctk_shd.g_old_rec.information9, hr_api.g_varchar2) <>
590: nvl(p_rec.information9, hr_api.g_varchar2) or
591: nvl(per_ctk_shd.g_old_rec.information10, hr_api.g_varchar2) <>
592: nvl(p_rec.information10, hr_api.g_varchar2) or
593: nvl(per_ctk_shd.g_old_rec.information11, hr_api.g_varchar2) <>

Line 591: nvl(per_ctk_shd.g_old_rec.information10, hr_api.g_varchar2) <>

587: nvl(per_ctk_shd.g_old_rec.information8, hr_api.g_varchar2) <>
588: nvl(p_rec.information8, hr_api.g_varchar2) or
589: nvl(per_ctk_shd.g_old_rec.information9, hr_api.g_varchar2) <>
590: nvl(p_rec.information9, hr_api.g_varchar2) or
591: nvl(per_ctk_shd.g_old_rec.information10, hr_api.g_varchar2) <>
592: nvl(p_rec.information10, hr_api.g_varchar2) or
593: nvl(per_ctk_shd.g_old_rec.information11, hr_api.g_varchar2) <>
594: nvl(p_rec.information11, hr_api.g_varchar2) or
595: nvl(per_ctk_shd.g_old_rec.information12, hr_api.g_varchar2) <>

Line 593: nvl(per_ctk_shd.g_old_rec.information11, hr_api.g_varchar2) <>

589: nvl(per_ctk_shd.g_old_rec.information9, hr_api.g_varchar2) <>
590: nvl(p_rec.information9, hr_api.g_varchar2) or
591: nvl(per_ctk_shd.g_old_rec.information10, hr_api.g_varchar2) <>
592: nvl(p_rec.information10, hr_api.g_varchar2) or
593: nvl(per_ctk_shd.g_old_rec.information11, hr_api.g_varchar2) <>
594: nvl(p_rec.information11, hr_api.g_varchar2) or
595: nvl(per_ctk_shd.g_old_rec.information12, hr_api.g_varchar2) <>
596: nvl(p_rec.information12, hr_api.g_varchar2) or
597: nvl(per_ctk_shd.g_old_rec.information13, hr_api.g_varchar2) <>

Line 595: nvl(per_ctk_shd.g_old_rec.information12, hr_api.g_varchar2) <>

591: nvl(per_ctk_shd.g_old_rec.information10, hr_api.g_varchar2) <>
592: nvl(p_rec.information10, hr_api.g_varchar2) or
593: nvl(per_ctk_shd.g_old_rec.information11, hr_api.g_varchar2) <>
594: nvl(p_rec.information11, hr_api.g_varchar2) or
595: nvl(per_ctk_shd.g_old_rec.information12, hr_api.g_varchar2) <>
596: nvl(p_rec.information12, hr_api.g_varchar2) or
597: nvl(per_ctk_shd.g_old_rec.information13, hr_api.g_varchar2) <>
598: nvl(p_rec.information13, hr_api.g_varchar2) or
599: nvl(per_ctk_shd.g_old_rec.information14, hr_api.g_varchar2) <>

Line 597: nvl(per_ctk_shd.g_old_rec.information13, hr_api.g_varchar2) <>

593: nvl(per_ctk_shd.g_old_rec.information11, hr_api.g_varchar2) <>
594: nvl(p_rec.information11, hr_api.g_varchar2) or
595: nvl(per_ctk_shd.g_old_rec.information12, hr_api.g_varchar2) <>
596: nvl(p_rec.information12, hr_api.g_varchar2) or
597: nvl(per_ctk_shd.g_old_rec.information13, hr_api.g_varchar2) <>
598: nvl(p_rec.information13, hr_api.g_varchar2) or
599: nvl(per_ctk_shd.g_old_rec.information14, hr_api.g_varchar2) <>
600: nvl(p_rec.information14, hr_api.g_varchar2) or
601: nvl(per_ctk_shd.g_old_rec.information15, hr_api.g_varchar2) <>

Line 599: nvl(per_ctk_shd.g_old_rec.information14, hr_api.g_varchar2) <>

595: nvl(per_ctk_shd.g_old_rec.information12, hr_api.g_varchar2) <>
596: nvl(p_rec.information12, hr_api.g_varchar2) or
597: nvl(per_ctk_shd.g_old_rec.information13, hr_api.g_varchar2) <>
598: nvl(p_rec.information13, hr_api.g_varchar2) or
599: nvl(per_ctk_shd.g_old_rec.information14, hr_api.g_varchar2) <>
600: nvl(p_rec.information14, hr_api.g_varchar2) or
601: nvl(per_ctk_shd.g_old_rec.information15, hr_api.g_varchar2) <>
602: nvl(p_rec.information15, hr_api.g_varchar2) or
603: nvl(per_ctk_shd.g_old_rec.information16, hr_api.g_varchar2) <>

Line 601: nvl(per_ctk_shd.g_old_rec.information15, hr_api.g_varchar2) <>

597: nvl(per_ctk_shd.g_old_rec.information13, hr_api.g_varchar2) <>
598: nvl(p_rec.information13, hr_api.g_varchar2) or
599: nvl(per_ctk_shd.g_old_rec.information14, hr_api.g_varchar2) <>
600: nvl(p_rec.information14, hr_api.g_varchar2) or
601: nvl(per_ctk_shd.g_old_rec.information15, hr_api.g_varchar2) <>
602: nvl(p_rec.information15, hr_api.g_varchar2) or
603: nvl(per_ctk_shd.g_old_rec.information16, hr_api.g_varchar2) <>
604: nvl(p_rec.information16, hr_api.g_varchar2) or
605: nvl(per_ctk_shd.g_old_rec.information17, hr_api.g_varchar2) <>

Line 603: nvl(per_ctk_shd.g_old_rec.information16, hr_api.g_varchar2) <>

599: nvl(per_ctk_shd.g_old_rec.information14, hr_api.g_varchar2) <>
600: nvl(p_rec.information14, hr_api.g_varchar2) or
601: nvl(per_ctk_shd.g_old_rec.information15, hr_api.g_varchar2) <>
602: nvl(p_rec.information15, hr_api.g_varchar2) or
603: nvl(per_ctk_shd.g_old_rec.information16, hr_api.g_varchar2) <>
604: nvl(p_rec.information16, hr_api.g_varchar2) or
605: nvl(per_ctk_shd.g_old_rec.information17, hr_api.g_varchar2) <>
606: nvl(p_rec.information17, hr_api.g_varchar2) or
607: nvl(per_ctk_shd.g_old_rec.information18, hr_api.g_varchar2) <>

Line 605: nvl(per_ctk_shd.g_old_rec.information17, hr_api.g_varchar2) <>

601: nvl(per_ctk_shd.g_old_rec.information15, hr_api.g_varchar2) <>
602: nvl(p_rec.information15, hr_api.g_varchar2) or
603: nvl(per_ctk_shd.g_old_rec.information16, hr_api.g_varchar2) <>
604: nvl(p_rec.information16, hr_api.g_varchar2) or
605: nvl(per_ctk_shd.g_old_rec.information17, hr_api.g_varchar2) <>
606: nvl(p_rec.information17, hr_api.g_varchar2) or
607: nvl(per_ctk_shd.g_old_rec.information18, hr_api.g_varchar2) <>
608: nvl(p_rec.information18, hr_api.g_varchar2) or
609: nvl(per_ctk_shd.g_old_rec.information19, hr_api.g_varchar2) <>

Line 607: nvl(per_ctk_shd.g_old_rec.information18, hr_api.g_varchar2) <>

603: nvl(per_ctk_shd.g_old_rec.information16, hr_api.g_varchar2) <>
604: nvl(p_rec.information16, hr_api.g_varchar2) or
605: nvl(per_ctk_shd.g_old_rec.information17, hr_api.g_varchar2) <>
606: nvl(p_rec.information17, hr_api.g_varchar2) or
607: nvl(per_ctk_shd.g_old_rec.information18, hr_api.g_varchar2) <>
608: nvl(p_rec.information18, hr_api.g_varchar2) or
609: nvl(per_ctk_shd.g_old_rec.information19, hr_api.g_varchar2) <>
610: nvl(p_rec.information19, hr_api.g_varchar2) or
611: nvl(per_ctk_shd.g_old_rec.information20, hr_api.g_varchar2) <>

Line 609: nvl(per_ctk_shd.g_old_rec.information19, hr_api.g_varchar2) <>

605: nvl(per_ctk_shd.g_old_rec.information17, hr_api.g_varchar2) <>
606: nvl(p_rec.information17, hr_api.g_varchar2) or
607: nvl(per_ctk_shd.g_old_rec.information18, hr_api.g_varchar2) <>
608: nvl(p_rec.information18, hr_api.g_varchar2) or
609: nvl(per_ctk_shd.g_old_rec.information19, hr_api.g_varchar2) <>
610: nvl(p_rec.information19, hr_api.g_varchar2) or
611: nvl(per_ctk_shd.g_old_rec.information20, hr_api.g_varchar2) <>
612: nvl(p_rec.information20, hr_api.g_varchar2) ))
613: or (p_rec.task_in_checklist_id is null) then

Line 611: nvl(per_ctk_shd.g_old_rec.information20, hr_api.g_varchar2) <>

607: nvl(per_ctk_shd.g_old_rec.information18, hr_api.g_varchar2) <>
608: nvl(p_rec.information18, hr_api.g_varchar2) or
609: nvl(per_ctk_shd.g_old_rec.information19, hr_api.g_varchar2) <>
610: nvl(p_rec.information19, hr_api.g_varchar2) or
611: nvl(per_ctk_shd.g_old_rec.information20, hr_api.g_varchar2) <>
612: nvl(p_rec.information20, hr_api.g_varchar2) ))
613: or (p_rec.task_in_checklist_id is null) then
614: --
615: -- Only execute the validation if absolutely necessary:

Line 699: (p_rec in per_ctk_shd.g_rec_type

695: -- Internal Row Handler Use Only.
696: --
697: -- ----------------------------------------------------------------------------
698: procedure chk_df
699: (p_rec in per_ctk_shd.g_rec_type
700: ) is
701: --
702: l_proc varchar2(72) := g_package || 'chk_df';
703: --

Line 708: nvl(per_ctk_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

704: begin
705: hr_utility.set_location('Entering:'||l_proc,10);
706: --
707: if ((p_rec.task_in_checklist_id is not null) and (
708: nvl(per_ctk_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
709: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
710: nvl(per_ctk_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
711: nvl(p_rec.attribute1, hr_api.g_varchar2) or
712: nvl(per_ctk_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 710: nvl(per_ctk_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

706: --
707: if ((p_rec.task_in_checklist_id is not null) and (
708: nvl(per_ctk_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
709: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
710: nvl(per_ctk_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
711: nvl(p_rec.attribute1, hr_api.g_varchar2) or
712: nvl(per_ctk_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
713: nvl(p_rec.attribute2, hr_api.g_varchar2) or
714: nvl(per_ctk_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 712: nvl(per_ctk_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

708: nvl(per_ctk_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
709: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
710: nvl(per_ctk_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
711: nvl(p_rec.attribute1, hr_api.g_varchar2) or
712: nvl(per_ctk_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
713: nvl(p_rec.attribute2, hr_api.g_varchar2) or
714: nvl(per_ctk_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
715: nvl(p_rec.attribute3, hr_api.g_varchar2) or
716: nvl(per_ctk_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 714: nvl(per_ctk_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

710: nvl(per_ctk_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
711: nvl(p_rec.attribute1, hr_api.g_varchar2) or
712: nvl(per_ctk_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
713: nvl(p_rec.attribute2, hr_api.g_varchar2) or
714: nvl(per_ctk_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
715: nvl(p_rec.attribute3, hr_api.g_varchar2) or
716: nvl(per_ctk_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
717: nvl(p_rec.attribute4, hr_api.g_varchar2) or
718: nvl(per_ctk_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 716: nvl(per_ctk_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

712: nvl(per_ctk_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
713: nvl(p_rec.attribute2, hr_api.g_varchar2) or
714: nvl(per_ctk_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
715: nvl(p_rec.attribute3, hr_api.g_varchar2) or
716: nvl(per_ctk_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
717: nvl(p_rec.attribute4, hr_api.g_varchar2) or
718: nvl(per_ctk_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
719: nvl(p_rec.attribute5, hr_api.g_varchar2) or
720: nvl(per_ctk_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 718: nvl(per_ctk_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

714: nvl(per_ctk_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
715: nvl(p_rec.attribute3, hr_api.g_varchar2) or
716: nvl(per_ctk_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
717: nvl(p_rec.attribute4, hr_api.g_varchar2) or
718: nvl(per_ctk_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
719: nvl(p_rec.attribute5, hr_api.g_varchar2) or
720: nvl(per_ctk_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
721: nvl(p_rec.attribute6, hr_api.g_varchar2) or
722: nvl(per_ctk_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 720: nvl(per_ctk_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

716: nvl(per_ctk_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
717: nvl(p_rec.attribute4, hr_api.g_varchar2) or
718: nvl(per_ctk_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
719: nvl(p_rec.attribute5, hr_api.g_varchar2) or
720: nvl(per_ctk_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
721: nvl(p_rec.attribute6, hr_api.g_varchar2) or
722: nvl(per_ctk_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
723: nvl(p_rec.attribute7, hr_api.g_varchar2) or
724: nvl(per_ctk_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 722: nvl(per_ctk_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

718: nvl(per_ctk_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
719: nvl(p_rec.attribute5, hr_api.g_varchar2) or
720: nvl(per_ctk_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
721: nvl(p_rec.attribute6, hr_api.g_varchar2) or
722: nvl(per_ctk_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
723: nvl(p_rec.attribute7, hr_api.g_varchar2) or
724: nvl(per_ctk_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
725: nvl(p_rec.attribute8, hr_api.g_varchar2) or
726: nvl(per_ctk_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 724: nvl(per_ctk_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

720: nvl(per_ctk_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
721: nvl(p_rec.attribute6, hr_api.g_varchar2) or
722: nvl(per_ctk_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
723: nvl(p_rec.attribute7, hr_api.g_varchar2) or
724: nvl(per_ctk_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
725: nvl(p_rec.attribute8, hr_api.g_varchar2) or
726: nvl(per_ctk_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
727: nvl(p_rec.attribute9, hr_api.g_varchar2) or
728: nvl(per_ctk_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 726: nvl(per_ctk_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

722: nvl(per_ctk_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
723: nvl(p_rec.attribute7, hr_api.g_varchar2) or
724: nvl(per_ctk_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
725: nvl(p_rec.attribute8, hr_api.g_varchar2) or
726: nvl(per_ctk_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
727: nvl(p_rec.attribute9, hr_api.g_varchar2) or
728: nvl(per_ctk_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
729: nvl(p_rec.attribute10, hr_api.g_varchar2) or
730: nvl(per_ctk_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 728: nvl(per_ctk_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

724: nvl(per_ctk_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
725: nvl(p_rec.attribute8, hr_api.g_varchar2) or
726: nvl(per_ctk_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
727: nvl(p_rec.attribute9, hr_api.g_varchar2) or
728: nvl(per_ctk_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
729: nvl(p_rec.attribute10, hr_api.g_varchar2) or
730: nvl(per_ctk_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
731: nvl(p_rec.attribute11, hr_api.g_varchar2) or
732: nvl(per_ctk_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 730: nvl(per_ctk_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

726: nvl(per_ctk_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
727: nvl(p_rec.attribute9, hr_api.g_varchar2) or
728: nvl(per_ctk_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
729: nvl(p_rec.attribute10, hr_api.g_varchar2) or
730: nvl(per_ctk_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
731: nvl(p_rec.attribute11, hr_api.g_varchar2) or
732: nvl(per_ctk_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
733: nvl(p_rec.attribute12, hr_api.g_varchar2) or
734: nvl(per_ctk_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 732: nvl(per_ctk_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

728: nvl(per_ctk_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
729: nvl(p_rec.attribute10, hr_api.g_varchar2) or
730: nvl(per_ctk_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
731: nvl(p_rec.attribute11, hr_api.g_varchar2) or
732: nvl(per_ctk_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
733: nvl(p_rec.attribute12, hr_api.g_varchar2) or
734: nvl(per_ctk_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
735: nvl(p_rec.attribute13, hr_api.g_varchar2) or
736: nvl(per_ctk_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 734: nvl(per_ctk_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

730: nvl(per_ctk_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
731: nvl(p_rec.attribute11, hr_api.g_varchar2) or
732: nvl(per_ctk_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
733: nvl(p_rec.attribute12, hr_api.g_varchar2) or
734: nvl(per_ctk_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
735: nvl(p_rec.attribute13, hr_api.g_varchar2) or
736: nvl(per_ctk_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
737: nvl(p_rec.attribute14, hr_api.g_varchar2) or
738: nvl(per_ctk_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 736: nvl(per_ctk_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

732: nvl(per_ctk_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
733: nvl(p_rec.attribute12, hr_api.g_varchar2) or
734: nvl(per_ctk_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
735: nvl(p_rec.attribute13, hr_api.g_varchar2) or
736: nvl(per_ctk_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
737: nvl(p_rec.attribute14, hr_api.g_varchar2) or
738: nvl(per_ctk_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
739: nvl(p_rec.attribute15, hr_api.g_varchar2) or
740: nvl(per_ctk_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 738: nvl(per_ctk_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

734: nvl(per_ctk_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
735: nvl(p_rec.attribute13, hr_api.g_varchar2) or
736: nvl(per_ctk_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
737: nvl(p_rec.attribute14, hr_api.g_varchar2) or
738: nvl(per_ctk_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
739: nvl(p_rec.attribute15, hr_api.g_varchar2) or
740: nvl(per_ctk_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
741: nvl(p_rec.attribute16, hr_api.g_varchar2) or
742: nvl(per_ctk_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 740: nvl(per_ctk_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

736: nvl(per_ctk_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
737: nvl(p_rec.attribute14, hr_api.g_varchar2) or
738: nvl(per_ctk_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
739: nvl(p_rec.attribute15, hr_api.g_varchar2) or
740: nvl(per_ctk_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
741: nvl(p_rec.attribute16, hr_api.g_varchar2) or
742: nvl(per_ctk_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
743: nvl(p_rec.attribute17, hr_api.g_varchar2) or
744: nvl(per_ctk_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 742: nvl(per_ctk_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

738: nvl(per_ctk_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
739: nvl(p_rec.attribute15, hr_api.g_varchar2) or
740: nvl(per_ctk_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
741: nvl(p_rec.attribute16, hr_api.g_varchar2) or
742: nvl(per_ctk_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
743: nvl(p_rec.attribute17, hr_api.g_varchar2) or
744: nvl(per_ctk_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
745: nvl(p_rec.attribute18, hr_api.g_varchar2) or
746: nvl(per_ctk_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 744: nvl(per_ctk_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

740: nvl(per_ctk_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
741: nvl(p_rec.attribute16, hr_api.g_varchar2) or
742: nvl(per_ctk_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
743: nvl(p_rec.attribute17, hr_api.g_varchar2) or
744: nvl(per_ctk_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
745: nvl(p_rec.attribute18, hr_api.g_varchar2) or
746: nvl(per_ctk_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
747: nvl(p_rec.attribute19, hr_api.g_varchar2) or
748: nvl(per_ctk_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 746: nvl(per_ctk_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

742: nvl(per_ctk_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
743: nvl(p_rec.attribute17, hr_api.g_varchar2) or
744: nvl(per_ctk_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
745: nvl(p_rec.attribute18, hr_api.g_varchar2) or
746: nvl(per_ctk_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
747: nvl(p_rec.attribute19, hr_api.g_varchar2) or
748: nvl(per_ctk_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
749: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
750: or (p_rec.task_in_checklist_id is null) then

Line 748: nvl(per_ctk_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

744: nvl(per_ctk_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
745: nvl(p_rec.attribute18, hr_api.g_varchar2) or
746: nvl(per_ctk_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
747: nvl(p_rec.attribute19, hr_api.g_varchar2) or
748: nvl(per_ctk_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
749: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
750: or (p_rec.task_in_checklist_id is null) then
751: --
752: -- Only execute the validation if absolutely necessary:

Line 836: ,p_rec in per_ctk_shd.g_rec_type

832: -- {End Of Comments}
833: -- ----------------------------------------------------------------------------
834: Procedure chk_non_updateable_args
835: (p_effective_date in date
836: ,p_rec in per_ctk_shd.g_rec_type
837: ) IS
838: --
839: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
840: --

Line 846: IF NOT per_ctk_shd.api_updating

842: --
843: -- Only proceed with the validation if a row exists for the current
844: -- record in the HR Schema.
845: --
846: IF NOT per_ctk_shd.api_updating
847: (p_task_in_checklist_id => p_rec.task_in_checklist_id
848: ,p_object_version_number => p_rec.object_version_number
849: ) THEN
850: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 864: ,p_rec in per_ctk_shd.g_rec_type

860: -- |---------------------------< insert_validate >----------------------------|
861: -- ----------------------------------------------------------------------------
862: Procedure insert_validate
863: (p_effective_date in date
864: ,p_rec in per_ctk_shd.g_rec_type
865: ) is
866: --
867: l_proc varchar2(72) := g_package||'insert_validate';
868: --

Line 942: ,p_rec in per_ctk_shd.g_rec_type

938: -- |---------------------------< update_validate >----------------------------|
939: -- ----------------------------------------------------------------------------
940: Procedure update_validate
941: (p_effective_date in date
942: ,p_rec in per_ctk_shd.g_rec_type
943: ) is
944: --
945: l_proc varchar2(72) := g_package||'update_validate';
946: --

Line 1022: (p_rec in per_ctk_shd.g_rec_type

1018: -- ----------------------------------------------------------------------------
1019: -- |---------------------------< delete_validate >----------------------------|
1020: -- ----------------------------------------------------------------------------
1021: Procedure delete_validate
1022: (p_rec in per_ctk_shd.g_rec_type
1023: ) is
1024: --
1025: l_proc varchar2(72) := g_package||'delete_validate';
1026: --