688: -- Internal Row Handler Use Only.
689: --
690: -- ----------------------------------------------------------------------------
691: procedure chk_ddf
692: (p_rec in hr_ord_shd.g_rec_type
693: ) is
694: --
695: l_proc varchar2(72) := g_package || 'chk_ddf';
696: --
697: begin
698: hr_utility.set_location('Entering:'||l_proc,10);
699: --
700: if ((p_rec.organization_link_id is not null) and (
701: nvl(hr_ord_shd.g_old_rec.org_link_information_category, hr_api.g_varchar2) <>
702: nvl(p_rec.org_link_information_category, hr_api.g_varchar2) or
703: nvl(hr_ord_shd.g_old_rec.org_link_information1, hr_api.g_varchar2) <>
704: nvl(p_rec.org_link_information1, hr_api.g_varchar2) or
705: nvl(hr_ord_shd.g_old_rec.org_link_information2, hr_api.g_varchar2) <>
699: --
700: if ((p_rec.organization_link_id is not null) and (
701: nvl(hr_ord_shd.g_old_rec.org_link_information_category, hr_api.g_varchar2) <>
702: nvl(p_rec.org_link_information_category, hr_api.g_varchar2) or
703: nvl(hr_ord_shd.g_old_rec.org_link_information1, hr_api.g_varchar2) <>
704: nvl(p_rec.org_link_information1, hr_api.g_varchar2) or
705: nvl(hr_ord_shd.g_old_rec.org_link_information2, hr_api.g_varchar2) <>
706: nvl(p_rec.org_link_information2, hr_api.g_varchar2) or
707: nvl(hr_ord_shd.g_old_rec.org_link_information3, hr_api.g_varchar2) <>
701: nvl(hr_ord_shd.g_old_rec.org_link_information_category, hr_api.g_varchar2) <>
702: nvl(p_rec.org_link_information_category, hr_api.g_varchar2) or
703: nvl(hr_ord_shd.g_old_rec.org_link_information1, hr_api.g_varchar2) <>
704: nvl(p_rec.org_link_information1, hr_api.g_varchar2) or
705: nvl(hr_ord_shd.g_old_rec.org_link_information2, hr_api.g_varchar2) <>
706: nvl(p_rec.org_link_information2, hr_api.g_varchar2) or
707: nvl(hr_ord_shd.g_old_rec.org_link_information3, hr_api.g_varchar2) <>
708: nvl(p_rec.org_link_information3, hr_api.g_varchar2) or
709: nvl(hr_ord_shd.g_old_rec.org_link_information4, hr_api.g_varchar2) <>
703: nvl(hr_ord_shd.g_old_rec.org_link_information1, hr_api.g_varchar2) <>
704: nvl(p_rec.org_link_information1, hr_api.g_varchar2) or
705: nvl(hr_ord_shd.g_old_rec.org_link_information2, hr_api.g_varchar2) <>
706: nvl(p_rec.org_link_information2, hr_api.g_varchar2) or
707: nvl(hr_ord_shd.g_old_rec.org_link_information3, hr_api.g_varchar2) <>
708: nvl(p_rec.org_link_information3, hr_api.g_varchar2) or
709: nvl(hr_ord_shd.g_old_rec.org_link_information4, hr_api.g_varchar2) <>
710: nvl(p_rec.org_link_information4, hr_api.g_varchar2) or
711: nvl(hr_ord_shd.g_old_rec.org_link_information5, hr_api.g_varchar2) <>
705: nvl(hr_ord_shd.g_old_rec.org_link_information2, hr_api.g_varchar2) <>
706: nvl(p_rec.org_link_information2, hr_api.g_varchar2) or
707: nvl(hr_ord_shd.g_old_rec.org_link_information3, hr_api.g_varchar2) <>
708: nvl(p_rec.org_link_information3, hr_api.g_varchar2) or
709: nvl(hr_ord_shd.g_old_rec.org_link_information4, hr_api.g_varchar2) <>
710: nvl(p_rec.org_link_information4, hr_api.g_varchar2) or
711: nvl(hr_ord_shd.g_old_rec.org_link_information5, hr_api.g_varchar2) <>
712: nvl(p_rec.org_link_information5, hr_api.g_varchar2) or
713: nvl(hr_ord_shd.g_old_rec.org_link_information6, hr_api.g_varchar2) <>
707: nvl(hr_ord_shd.g_old_rec.org_link_information3, hr_api.g_varchar2) <>
708: nvl(p_rec.org_link_information3, hr_api.g_varchar2) or
709: nvl(hr_ord_shd.g_old_rec.org_link_information4, hr_api.g_varchar2) <>
710: nvl(p_rec.org_link_information4, hr_api.g_varchar2) or
711: nvl(hr_ord_shd.g_old_rec.org_link_information5, hr_api.g_varchar2) <>
712: nvl(p_rec.org_link_information5, hr_api.g_varchar2) or
713: nvl(hr_ord_shd.g_old_rec.org_link_information6, hr_api.g_varchar2) <>
714: nvl(p_rec.org_link_information6, hr_api.g_varchar2) or
715: nvl(hr_ord_shd.g_old_rec.org_link_information7, hr_api.g_varchar2) <>
709: nvl(hr_ord_shd.g_old_rec.org_link_information4, hr_api.g_varchar2) <>
710: nvl(p_rec.org_link_information4, hr_api.g_varchar2) or
711: nvl(hr_ord_shd.g_old_rec.org_link_information5, hr_api.g_varchar2) <>
712: nvl(p_rec.org_link_information5, hr_api.g_varchar2) or
713: nvl(hr_ord_shd.g_old_rec.org_link_information6, hr_api.g_varchar2) <>
714: nvl(p_rec.org_link_information6, hr_api.g_varchar2) or
715: nvl(hr_ord_shd.g_old_rec.org_link_information7, hr_api.g_varchar2) <>
716: nvl(p_rec.org_link_information7, hr_api.g_varchar2) or
717: nvl(hr_ord_shd.g_old_rec.org_link_information8, hr_api.g_varchar2) <>
711: nvl(hr_ord_shd.g_old_rec.org_link_information5, hr_api.g_varchar2) <>
712: nvl(p_rec.org_link_information5, hr_api.g_varchar2) or
713: nvl(hr_ord_shd.g_old_rec.org_link_information6, hr_api.g_varchar2) <>
714: nvl(p_rec.org_link_information6, hr_api.g_varchar2) or
715: nvl(hr_ord_shd.g_old_rec.org_link_information7, hr_api.g_varchar2) <>
716: nvl(p_rec.org_link_information7, hr_api.g_varchar2) or
717: nvl(hr_ord_shd.g_old_rec.org_link_information8, hr_api.g_varchar2) <>
718: nvl(p_rec.org_link_information8, hr_api.g_varchar2) or
719: nvl(hr_ord_shd.g_old_rec.org_link_information9, hr_api.g_varchar2) <>
713: nvl(hr_ord_shd.g_old_rec.org_link_information6, hr_api.g_varchar2) <>
714: nvl(p_rec.org_link_information6, hr_api.g_varchar2) or
715: nvl(hr_ord_shd.g_old_rec.org_link_information7, hr_api.g_varchar2) <>
716: nvl(p_rec.org_link_information7, hr_api.g_varchar2) or
717: nvl(hr_ord_shd.g_old_rec.org_link_information8, hr_api.g_varchar2) <>
718: nvl(p_rec.org_link_information8, hr_api.g_varchar2) or
719: nvl(hr_ord_shd.g_old_rec.org_link_information9, hr_api.g_varchar2) <>
720: nvl(p_rec.org_link_information9, hr_api.g_varchar2) or
721: nvl(hr_ord_shd.g_old_rec.org_link_information10, hr_api.g_varchar2) <>
715: nvl(hr_ord_shd.g_old_rec.org_link_information7, hr_api.g_varchar2) <>
716: nvl(p_rec.org_link_information7, hr_api.g_varchar2) or
717: nvl(hr_ord_shd.g_old_rec.org_link_information8, hr_api.g_varchar2) <>
718: nvl(p_rec.org_link_information8, hr_api.g_varchar2) or
719: nvl(hr_ord_shd.g_old_rec.org_link_information9, hr_api.g_varchar2) <>
720: nvl(p_rec.org_link_information9, hr_api.g_varchar2) or
721: nvl(hr_ord_shd.g_old_rec.org_link_information10, hr_api.g_varchar2) <>
722: nvl(p_rec.org_link_information10, hr_api.g_varchar2) or
723: nvl(hr_ord_shd.g_old_rec.org_link_information11, hr_api.g_varchar2) <>
717: nvl(hr_ord_shd.g_old_rec.org_link_information8, hr_api.g_varchar2) <>
718: nvl(p_rec.org_link_information8, hr_api.g_varchar2) or
719: nvl(hr_ord_shd.g_old_rec.org_link_information9, hr_api.g_varchar2) <>
720: nvl(p_rec.org_link_information9, hr_api.g_varchar2) or
721: nvl(hr_ord_shd.g_old_rec.org_link_information10, hr_api.g_varchar2) <>
722: nvl(p_rec.org_link_information10, hr_api.g_varchar2) or
723: nvl(hr_ord_shd.g_old_rec.org_link_information11, hr_api.g_varchar2) <>
724: nvl(p_rec.org_link_information11, hr_api.g_varchar2) or
725: nvl(hr_ord_shd.g_old_rec.org_link_information12, hr_api.g_varchar2) <>
719: nvl(hr_ord_shd.g_old_rec.org_link_information9, hr_api.g_varchar2) <>
720: nvl(p_rec.org_link_information9, hr_api.g_varchar2) or
721: nvl(hr_ord_shd.g_old_rec.org_link_information10, hr_api.g_varchar2) <>
722: nvl(p_rec.org_link_information10, hr_api.g_varchar2) or
723: nvl(hr_ord_shd.g_old_rec.org_link_information11, hr_api.g_varchar2) <>
724: nvl(p_rec.org_link_information11, hr_api.g_varchar2) or
725: nvl(hr_ord_shd.g_old_rec.org_link_information12, hr_api.g_varchar2) <>
726: nvl(p_rec.org_link_information12, hr_api.g_varchar2) or
727: nvl(hr_ord_shd.g_old_rec.org_link_information13, hr_api.g_varchar2) <>
721: nvl(hr_ord_shd.g_old_rec.org_link_information10, hr_api.g_varchar2) <>
722: nvl(p_rec.org_link_information10, hr_api.g_varchar2) or
723: nvl(hr_ord_shd.g_old_rec.org_link_information11, hr_api.g_varchar2) <>
724: nvl(p_rec.org_link_information11, hr_api.g_varchar2) or
725: nvl(hr_ord_shd.g_old_rec.org_link_information12, hr_api.g_varchar2) <>
726: nvl(p_rec.org_link_information12, hr_api.g_varchar2) or
727: nvl(hr_ord_shd.g_old_rec.org_link_information13, hr_api.g_varchar2) <>
728: nvl(p_rec.org_link_information13, hr_api.g_varchar2) or
729: nvl(hr_ord_shd.g_old_rec.org_link_information14, hr_api.g_varchar2) <>
723: nvl(hr_ord_shd.g_old_rec.org_link_information11, hr_api.g_varchar2) <>
724: nvl(p_rec.org_link_information11, hr_api.g_varchar2) or
725: nvl(hr_ord_shd.g_old_rec.org_link_information12, hr_api.g_varchar2) <>
726: nvl(p_rec.org_link_information12, hr_api.g_varchar2) or
727: nvl(hr_ord_shd.g_old_rec.org_link_information13, hr_api.g_varchar2) <>
728: nvl(p_rec.org_link_information13, hr_api.g_varchar2) or
729: nvl(hr_ord_shd.g_old_rec.org_link_information14, hr_api.g_varchar2) <>
730: nvl(p_rec.org_link_information14, hr_api.g_varchar2) or
731: nvl(hr_ord_shd.g_old_rec.org_link_information15, hr_api.g_varchar2) <>
725: nvl(hr_ord_shd.g_old_rec.org_link_information12, hr_api.g_varchar2) <>
726: nvl(p_rec.org_link_information12, hr_api.g_varchar2) or
727: nvl(hr_ord_shd.g_old_rec.org_link_information13, hr_api.g_varchar2) <>
728: nvl(p_rec.org_link_information13, hr_api.g_varchar2) or
729: nvl(hr_ord_shd.g_old_rec.org_link_information14, hr_api.g_varchar2) <>
730: nvl(p_rec.org_link_information14, hr_api.g_varchar2) or
731: nvl(hr_ord_shd.g_old_rec.org_link_information15, hr_api.g_varchar2) <>
732: nvl(p_rec.org_link_information15, hr_api.g_varchar2) or
733: nvl(hr_ord_shd.g_old_rec.org_link_information16, hr_api.g_varchar2) <>
727: nvl(hr_ord_shd.g_old_rec.org_link_information13, hr_api.g_varchar2) <>
728: nvl(p_rec.org_link_information13, hr_api.g_varchar2) or
729: nvl(hr_ord_shd.g_old_rec.org_link_information14, hr_api.g_varchar2) <>
730: nvl(p_rec.org_link_information14, hr_api.g_varchar2) or
731: nvl(hr_ord_shd.g_old_rec.org_link_information15, hr_api.g_varchar2) <>
732: nvl(p_rec.org_link_information15, hr_api.g_varchar2) or
733: nvl(hr_ord_shd.g_old_rec.org_link_information16, hr_api.g_varchar2) <>
734: nvl(p_rec.org_link_information16, hr_api.g_varchar2) or
735: nvl(hr_ord_shd.g_old_rec.org_link_information17, hr_api.g_varchar2) <>
729: nvl(hr_ord_shd.g_old_rec.org_link_information14, hr_api.g_varchar2) <>
730: nvl(p_rec.org_link_information14, hr_api.g_varchar2) or
731: nvl(hr_ord_shd.g_old_rec.org_link_information15, hr_api.g_varchar2) <>
732: nvl(p_rec.org_link_information15, hr_api.g_varchar2) or
733: nvl(hr_ord_shd.g_old_rec.org_link_information16, hr_api.g_varchar2) <>
734: nvl(p_rec.org_link_information16, hr_api.g_varchar2) or
735: nvl(hr_ord_shd.g_old_rec.org_link_information17, hr_api.g_varchar2) <>
736: nvl(p_rec.org_link_information17, hr_api.g_varchar2) or
737: nvl(hr_ord_shd.g_old_rec.org_link_information18, hr_api.g_varchar2) <>
731: nvl(hr_ord_shd.g_old_rec.org_link_information15, hr_api.g_varchar2) <>
732: nvl(p_rec.org_link_information15, hr_api.g_varchar2) or
733: nvl(hr_ord_shd.g_old_rec.org_link_information16, hr_api.g_varchar2) <>
734: nvl(p_rec.org_link_information16, hr_api.g_varchar2) or
735: nvl(hr_ord_shd.g_old_rec.org_link_information17, hr_api.g_varchar2) <>
736: nvl(p_rec.org_link_information17, hr_api.g_varchar2) or
737: nvl(hr_ord_shd.g_old_rec.org_link_information18, hr_api.g_varchar2) <>
738: nvl(p_rec.org_link_information18, hr_api.g_varchar2) or
739: nvl(hr_ord_shd.g_old_rec.org_link_information19, hr_api.g_varchar2) <>
733: nvl(hr_ord_shd.g_old_rec.org_link_information16, hr_api.g_varchar2) <>
734: nvl(p_rec.org_link_information16, hr_api.g_varchar2) or
735: nvl(hr_ord_shd.g_old_rec.org_link_information17, hr_api.g_varchar2) <>
736: nvl(p_rec.org_link_information17, hr_api.g_varchar2) or
737: nvl(hr_ord_shd.g_old_rec.org_link_information18, hr_api.g_varchar2) <>
738: nvl(p_rec.org_link_information18, hr_api.g_varchar2) or
739: nvl(hr_ord_shd.g_old_rec.org_link_information19, hr_api.g_varchar2) <>
740: nvl(p_rec.org_link_information19, hr_api.g_varchar2) or
741: nvl(hr_ord_shd.g_old_rec.org_link_information20, hr_api.g_varchar2) <>
735: nvl(hr_ord_shd.g_old_rec.org_link_information17, hr_api.g_varchar2) <>
736: nvl(p_rec.org_link_information17, hr_api.g_varchar2) or
737: nvl(hr_ord_shd.g_old_rec.org_link_information18, hr_api.g_varchar2) <>
738: nvl(p_rec.org_link_information18, hr_api.g_varchar2) or
739: nvl(hr_ord_shd.g_old_rec.org_link_information19, hr_api.g_varchar2) <>
740: nvl(p_rec.org_link_information19, hr_api.g_varchar2) or
741: nvl(hr_ord_shd.g_old_rec.org_link_information20, hr_api.g_varchar2) <>
742: nvl(p_rec.org_link_information20, hr_api.g_varchar2) or
743: nvl(hr_ord_shd.g_old_rec.org_link_information21, hr_api.g_varchar2) <>
737: nvl(hr_ord_shd.g_old_rec.org_link_information18, hr_api.g_varchar2) <>
738: nvl(p_rec.org_link_information18, hr_api.g_varchar2) or
739: nvl(hr_ord_shd.g_old_rec.org_link_information19, hr_api.g_varchar2) <>
740: nvl(p_rec.org_link_information19, hr_api.g_varchar2) or
741: nvl(hr_ord_shd.g_old_rec.org_link_information20, hr_api.g_varchar2) <>
742: nvl(p_rec.org_link_information20, hr_api.g_varchar2) or
743: nvl(hr_ord_shd.g_old_rec.org_link_information21, hr_api.g_varchar2) <>
744: nvl(p_rec.org_link_information21, hr_api.g_varchar2) or
745: nvl(hr_ord_shd.g_old_rec.org_link_information22, hr_api.g_varchar2) <>
739: nvl(hr_ord_shd.g_old_rec.org_link_information19, hr_api.g_varchar2) <>
740: nvl(p_rec.org_link_information19, hr_api.g_varchar2) or
741: nvl(hr_ord_shd.g_old_rec.org_link_information20, hr_api.g_varchar2) <>
742: nvl(p_rec.org_link_information20, hr_api.g_varchar2) or
743: nvl(hr_ord_shd.g_old_rec.org_link_information21, hr_api.g_varchar2) <>
744: nvl(p_rec.org_link_information21, hr_api.g_varchar2) or
745: nvl(hr_ord_shd.g_old_rec.org_link_information22, hr_api.g_varchar2) <>
746: nvl(p_rec.org_link_information22, hr_api.g_varchar2) or
747: nvl(hr_ord_shd.g_old_rec.org_link_information23, hr_api.g_varchar2) <>
741: nvl(hr_ord_shd.g_old_rec.org_link_information20, hr_api.g_varchar2) <>
742: nvl(p_rec.org_link_information20, hr_api.g_varchar2) or
743: nvl(hr_ord_shd.g_old_rec.org_link_information21, hr_api.g_varchar2) <>
744: nvl(p_rec.org_link_information21, hr_api.g_varchar2) or
745: nvl(hr_ord_shd.g_old_rec.org_link_information22, hr_api.g_varchar2) <>
746: nvl(p_rec.org_link_information22, hr_api.g_varchar2) or
747: nvl(hr_ord_shd.g_old_rec.org_link_information23, hr_api.g_varchar2) <>
748: nvl(p_rec.org_link_information23, hr_api.g_varchar2) or
749: nvl(hr_ord_shd.g_old_rec.org_link_information24, hr_api.g_varchar2) <>
743: nvl(hr_ord_shd.g_old_rec.org_link_information21, hr_api.g_varchar2) <>
744: nvl(p_rec.org_link_information21, hr_api.g_varchar2) or
745: nvl(hr_ord_shd.g_old_rec.org_link_information22, hr_api.g_varchar2) <>
746: nvl(p_rec.org_link_information22, hr_api.g_varchar2) or
747: nvl(hr_ord_shd.g_old_rec.org_link_information23, hr_api.g_varchar2) <>
748: nvl(p_rec.org_link_information23, hr_api.g_varchar2) or
749: nvl(hr_ord_shd.g_old_rec.org_link_information24, hr_api.g_varchar2) <>
750: nvl(p_rec.org_link_information24, hr_api.g_varchar2) or
751: nvl(hr_ord_shd.g_old_rec.org_link_information25, hr_api.g_varchar2) <>
745: nvl(hr_ord_shd.g_old_rec.org_link_information22, hr_api.g_varchar2) <>
746: nvl(p_rec.org_link_information22, hr_api.g_varchar2) or
747: nvl(hr_ord_shd.g_old_rec.org_link_information23, hr_api.g_varchar2) <>
748: nvl(p_rec.org_link_information23, hr_api.g_varchar2) or
749: nvl(hr_ord_shd.g_old_rec.org_link_information24, hr_api.g_varchar2) <>
750: nvl(p_rec.org_link_information24, hr_api.g_varchar2) or
751: nvl(hr_ord_shd.g_old_rec.org_link_information25, hr_api.g_varchar2) <>
752: nvl(p_rec.org_link_information25, hr_api.g_varchar2) or
753: nvl(hr_ord_shd.g_old_rec.org_link_information26, hr_api.g_varchar2) <>
747: nvl(hr_ord_shd.g_old_rec.org_link_information23, hr_api.g_varchar2) <>
748: nvl(p_rec.org_link_information23, hr_api.g_varchar2) or
749: nvl(hr_ord_shd.g_old_rec.org_link_information24, hr_api.g_varchar2) <>
750: nvl(p_rec.org_link_information24, hr_api.g_varchar2) or
751: nvl(hr_ord_shd.g_old_rec.org_link_information25, hr_api.g_varchar2) <>
752: nvl(p_rec.org_link_information25, hr_api.g_varchar2) or
753: nvl(hr_ord_shd.g_old_rec.org_link_information26, hr_api.g_varchar2) <>
754: nvl(p_rec.org_link_information26, hr_api.g_varchar2) or
755: nvl(hr_ord_shd.g_old_rec.org_link_information27, hr_api.g_varchar2) <>
749: nvl(hr_ord_shd.g_old_rec.org_link_information24, hr_api.g_varchar2) <>
750: nvl(p_rec.org_link_information24, hr_api.g_varchar2) or
751: nvl(hr_ord_shd.g_old_rec.org_link_information25, hr_api.g_varchar2) <>
752: nvl(p_rec.org_link_information25, hr_api.g_varchar2) or
753: nvl(hr_ord_shd.g_old_rec.org_link_information26, hr_api.g_varchar2) <>
754: nvl(p_rec.org_link_information26, hr_api.g_varchar2) or
755: nvl(hr_ord_shd.g_old_rec.org_link_information27, hr_api.g_varchar2) <>
756: nvl(p_rec.org_link_information27, hr_api.g_varchar2) or
757: nvl(hr_ord_shd.g_old_rec.org_link_information28, hr_api.g_varchar2) <>
751: nvl(hr_ord_shd.g_old_rec.org_link_information25, hr_api.g_varchar2) <>
752: nvl(p_rec.org_link_information25, hr_api.g_varchar2) or
753: nvl(hr_ord_shd.g_old_rec.org_link_information26, hr_api.g_varchar2) <>
754: nvl(p_rec.org_link_information26, hr_api.g_varchar2) or
755: nvl(hr_ord_shd.g_old_rec.org_link_information27, hr_api.g_varchar2) <>
756: nvl(p_rec.org_link_information27, hr_api.g_varchar2) or
757: nvl(hr_ord_shd.g_old_rec.org_link_information28, hr_api.g_varchar2) <>
758: nvl(p_rec.org_link_information28, hr_api.g_varchar2) or
759: nvl(hr_ord_shd.g_old_rec.org_link_information29, hr_api.g_varchar2) <>
753: nvl(hr_ord_shd.g_old_rec.org_link_information26, hr_api.g_varchar2) <>
754: nvl(p_rec.org_link_information26, hr_api.g_varchar2) or
755: nvl(hr_ord_shd.g_old_rec.org_link_information27, hr_api.g_varchar2) <>
756: nvl(p_rec.org_link_information27, hr_api.g_varchar2) or
757: nvl(hr_ord_shd.g_old_rec.org_link_information28, hr_api.g_varchar2) <>
758: nvl(p_rec.org_link_information28, hr_api.g_varchar2) or
759: nvl(hr_ord_shd.g_old_rec.org_link_information29, hr_api.g_varchar2) <>
760: nvl(p_rec.org_link_information29, hr_api.g_varchar2) or
761: nvl(hr_ord_shd.g_old_rec.org_link_information30, hr_api.g_varchar2) <>
755: nvl(hr_ord_shd.g_old_rec.org_link_information27, hr_api.g_varchar2) <>
756: nvl(p_rec.org_link_information27, hr_api.g_varchar2) or
757: nvl(hr_ord_shd.g_old_rec.org_link_information28, hr_api.g_varchar2) <>
758: nvl(p_rec.org_link_information28, hr_api.g_varchar2) or
759: nvl(hr_ord_shd.g_old_rec.org_link_information29, hr_api.g_varchar2) <>
760: nvl(p_rec.org_link_information29, hr_api.g_varchar2) or
761: nvl(hr_ord_shd.g_old_rec.org_link_information30, hr_api.g_varchar2) <>
762: nvl(p_rec.org_link_information30, hr_api.g_varchar2) ))
763: or (p_rec.organization_link_id is null) then
757: nvl(hr_ord_shd.g_old_rec.org_link_information28, hr_api.g_varchar2) <>
758: nvl(p_rec.org_link_information28, hr_api.g_varchar2) or
759: nvl(hr_ord_shd.g_old_rec.org_link_information29, hr_api.g_varchar2) <>
760: nvl(p_rec.org_link_information29, hr_api.g_varchar2) or
761: nvl(hr_ord_shd.g_old_rec.org_link_information30, hr_api.g_varchar2) <>
762: nvl(p_rec.org_link_information30, hr_api.g_varchar2) ))
763: or (p_rec.organization_link_id is null) then
764: --
765: -- Only execute the validation if absolutely necessary:
865: -- Internal Row Handler Use Only.
866: --
867: -- ----------------------------------------------------------------------------
868: procedure chk_df
869: (p_rec in hr_ord_shd.g_rec_type
870: ) is
871: --
872: l_proc varchar2(72) := g_package || 'chk_df';
873: --
874: begin
875: hr_utility.set_location('Entering:'||l_proc,10);
876: --
877: if ((p_rec.organization_link_id is not null) and (
878: nvl(hr_ord_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
879: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
880: nvl(hr_ord_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
881: nvl(p_rec.attribute1, hr_api.g_varchar2) or
882: nvl(hr_ord_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
876: --
877: if ((p_rec.organization_link_id is not null) and (
878: nvl(hr_ord_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
879: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
880: nvl(hr_ord_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
881: nvl(p_rec.attribute1, hr_api.g_varchar2) or
882: nvl(hr_ord_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
883: nvl(p_rec.attribute2, hr_api.g_varchar2) or
884: nvl(hr_ord_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
878: nvl(hr_ord_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
879: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
880: nvl(hr_ord_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
881: nvl(p_rec.attribute1, hr_api.g_varchar2) or
882: nvl(hr_ord_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
883: nvl(p_rec.attribute2, hr_api.g_varchar2) or
884: nvl(hr_ord_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
885: nvl(p_rec.attribute3, hr_api.g_varchar2) or
886: nvl(hr_ord_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
880: nvl(hr_ord_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
881: nvl(p_rec.attribute1, hr_api.g_varchar2) or
882: nvl(hr_ord_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
883: nvl(p_rec.attribute2, hr_api.g_varchar2) or
884: nvl(hr_ord_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
885: nvl(p_rec.attribute3, hr_api.g_varchar2) or
886: nvl(hr_ord_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
887: nvl(p_rec.attribute4, hr_api.g_varchar2) or
888: nvl(hr_ord_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
882: nvl(hr_ord_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
883: nvl(p_rec.attribute2, hr_api.g_varchar2) or
884: nvl(hr_ord_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
885: nvl(p_rec.attribute3, hr_api.g_varchar2) or
886: nvl(hr_ord_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
887: nvl(p_rec.attribute4, hr_api.g_varchar2) or
888: nvl(hr_ord_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
889: nvl(p_rec.attribute5, hr_api.g_varchar2) or
890: nvl(hr_ord_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
884: nvl(hr_ord_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
885: nvl(p_rec.attribute3, hr_api.g_varchar2) or
886: nvl(hr_ord_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
887: nvl(p_rec.attribute4, hr_api.g_varchar2) or
888: nvl(hr_ord_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
889: nvl(p_rec.attribute5, hr_api.g_varchar2) or
890: nvl(hr_ord_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
891: nvl(p_rec.attribute6, hr_api.g_varchar2) or
892: nvl(hr_ord_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
886: nvl(hr_ord_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
887: nvl(p_rec.attribute4, hr_api.g_varchar2) or
888: nvl(hr_ord_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
889: nvl(p_rec.attribute5, hr_api.g_varchar2) or
890: nvl(hr_ord_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
891: nvl(p_rec.attribute6, hr_api.g_varchar2) or
892: nvl(hr_ord_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
893: nvl(p_rec.attribute7, hr_api.g_varchar2) or
894: nvl(hr_ord_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
888: nvl(hr_ord_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
889: nvl(p_rec.attribute5, hr_api.g_varchar2) or
890: nvl(hr_ord_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
891: nvl(p_rec.attribute6, hr_api.g_varchar2) or
892: nvl(hr_ord_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
893: nvl(p_rec.attribute7, hr_api.g_varchar2) or
894: nvl(hr_ord_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
895: nvl(p_rec.attribute8, hr_api.g_varchar2) or
896: nvl(hr_ord_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
890: nvl(hr_ord_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
891: nvl(p_rec.attribute6, hr_api.g_varchar2) or
892: nvl(hr_ord_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
893: nvl(p_rec.attribute7, hr_api.g_varchar2) or
894: nvl(hr_ord_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
895: nvl(p_rec.attribute8, hr_api.g_varchar2) or
896: nvl(hr_ord_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
897: nvl(p_rec.attribute9, hr_api.g_varchar2) or
898: nvl(hr_ord_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
892: nvl(hr_ord_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
893: nvl(p_rec.attribute7, hr_api.g_varchar2) or
894: nvl(hr_ord_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
895: nvl(p_rec.attribute8, hr_api.g_varchar2) or
896: nvl(hr_ord_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
897: nvl(p_rec.attribute9, hr_api.g_varchar2) or
898: nvl(hr_ord_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
899: nvl(p_rec.attribute10, hr_api.g_varchar2) or
900: nvl(hr_ord_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
894: nvl(hr_ord_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
895: nvl(p_rec.attribute8, hr_api.g_varchar2) or
896: nvl(hr_ord_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
897: nvl(p_rec.attribute9, hr_api.g_varchar2) or
898: nvl(hr_ord_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
899: nvl(p_rec.attribute10, hr_api.g_varchar2) or
900: nvl(hr_ord_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
901: nvl(p_rec.attribute11, hr_api.g_varchar2) or
902: nvl(hr_ord_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
896: nvl(hr_ord_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
897: nvl(p_rec.attribute9, hr_api.g_varchar2) or
898: nvl(hr_ord_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
899: nvl(p_rec.attribute10, hr_api.g_varchar2) or
900: nvl(hr_ord_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
901: nvl(p_rec.attribute11, hr_api.g_varchar2) or
902: nvl(hr_ord_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
903: nvl(p_rec.attribute12, hr_api.g_varchar2) or
904: nvl(hr_ord_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
898: nvl(hr_ord_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
899: nvl(p_rec.attribute10, hr_api.g_varchar2) or
900: nvl(hr_ord_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
901: nvl(p_rec.attribute11, hr_api.g_varchar2) or
902: nvl(hr_ord_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
903: nvl(p_rec.attribute12, hr_api.g_varchar2) or
904: nvl(hr_ord_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
905: nvl(p_rec.attribute13, hr_api.g_varchar2) or
906: nvl(hr_ord_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
900: nvl(hr_ord_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
901: nvl(p_rec.attribute11, hr_api.g_varchar2) or
902: nvl(hr_ord_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
903: nvl(p_rec.attribute12, hr_api.g_varchar2) or
904: nvl(hr_ord_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
905: nvl(p_rec.attribute13, hr_api.g_varchar2) or
906: nvl(hr_ord_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
907: nvl(p_rec.attribute14, hr_api.g_varchar2) or
908: nvl(hr_ord_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
902: nvl(hr_ord_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
903: nvl(p_rec.attribute12, hr_api.g_varchar2) or
904: nvl(hr_ord_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
905: nvl(p_rec.attribute13, hr_api.g_varchar2) or
906: nvl(hr_ord_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
907: nvl(p_rec.attribute14, hr_api.g_varchar2) or
908: nvl(hr_ord_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
909: nvl(p_rec.attribute15, hr_api.g_varchar2) or
910: nvl(hr_ord_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
904: nvl(hr_ord_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
905: nvl(p_rec.attribute13, hr_api.g_varchar2) or
906: nvl(hr_ord_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
907: nvl(p_rec.attribute14, hr_api.g_varchar2) or
908: nvl(hr_ord_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
909: nvl(p_rec.attribute15, hr_api.g_varchar2) or
910: nvl(hr_ord_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
911: nvl(p_rec.attribute16, hr_api.g_varchar2) or
912: nvl(hr_ord_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
906: nvl(hr_ord_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
907: nvl(p_rec.attribute14, hr_api.g_varchar2) or
908: nvl(hr_ord_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
909: nvl(p_rec.attribute15, hr_api.g_varchar2) or
910: nvl(hr_ord_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
911: nvl(p_rec.attribute16, hr_api.g_varchar2) or
912: nvl(hr_ord_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute17, hr_api.g_varchar2) or
914: nvl(hr_ord_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
908: nvl(hr_ord_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
909: nvl(p_rec.attribute15, hr_api.g_varchar2) or
910: nvl(hr_ord_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
911: nvl(p_rec.attribute16, hr_api.g_varchar2) or
912: nvl(hr_ord_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute17, hr_api.g_varchar2) or
914: nvl(hr_ord_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute18, hr_api.g_varchar2) or
916: nvl(hr_ord_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
910: nvl(hr_ord_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
911: nvl(p_rec.attribute16, hr_api.g_varchar2) or
912: nvl(hr_ord_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute17, hr_api.g_varchar2) or
914: nvl(hr_ord_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute18, hr_api.g_varchar2) or
916: nvl(hr_ord_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute19, hr_api.g_varchar2) or
918: nvl(hr_ord_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
912: nvl(hr_ord_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute17, hr_api.g_varchar2) or
914: nvl(hr_ord_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute18, hr_api.g_varchar2) or
916: nvl(hr_ord_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute19, hr_api.g_varchar2) or
918: nvl(hr_ord_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute20, hr_api.g_varchar2) or
920: nvl(hr_ord_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
914: nvl(hr_ord_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute18, hr_api.g_varchar2) or
916: nvl(hr_ord_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute19, hr_api.g_varchar2) or
918: nvl(hr_ord_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute20, hr_api.g_varchar2) or
920: nvl(hr_ord_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute21, hr_api.g_varchar2) or
922: nvl(hr_ord_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
916: nvl(hr_ord_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute19, hr_api.g_varchar2) or
918: nvl(hr_ord_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute20, hr_api.g_varchar2) or
920: nvl(hr_ord_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute21, hr_api.g_varchar2) or
922: nvl(hr_ord_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute22, hr_api.g_varchar2) or
924: nvl(hr_ord_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
918: nvl(hr_ord_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute20, hr_api.g_varchar2) or
920: nvl(hr_ord_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute21, hr_api.g_varchar2) or
922: nvl(hr_ord_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute22, hr_api.g_varchar2) or
924: nvl(hr_ord_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute23, hr_api.g_varchar2) or
926: nvl(hr_ord_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
920: nvl(hr_ord_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute21, hr_api.g_varchar2) or
922: nvl(hr_ord_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute22, hr_api.g_varchar2) or
924: nvl(hr_ord_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute23, hr_api.g_varchar2) or
926: nvl(hr_ord_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute24, hr_api.g_varchar2) or
928: nvl(hr_ord_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
922: nvl(hr_ord_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute22, hr_api.g_varchar2) or
924: nvl(hr_ord_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute23, hr_api.g_varchar2) or
926: nvl(hr_ord_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute24, hr_api.g_varchar2) or
928: nvl(hr_ord_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute25, hr_api.g_varchar2) or
930: nvl(hr_ord_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
924: nvl(hr_ord_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute23, hr_api.g_varchar2) or
926: nvl(hr_ord_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute24, hr_api.g_varchar2) or
928: nvl(hr_ord_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute25, hr_api.g_varchar2) or
930: nvl(hr_ord_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute26, hr_api.g_varchar2) or
932: nvl(hr_ord_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
926: nvl(hr_ord_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute24, hr_api.g_varchar2) or
928: nvl(hr_ord_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute25, hr_api.g_varchar2) or
930: nvl(hr_ord_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute26, hr_api.g_varchar2) or
932: nvl(hr_ord_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute27, hr_api.g_varchar2) or
934: nvl(hr_ord_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
928: nvl(hr_ord_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute25, hr_api.g_varchar2) or
930: nvl(hr_ord_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute26, hr_api.g_varchar2) or
932: nvl(hr_ord_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute27, hr_api.g_varchar2) or
934: nvl(hr_ord_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute28, hr_api.g_varchar2) or
936: nvl(hr_ord_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
930: nvl(hr_ord_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute26, hr_api.g_varchar2) or
932: nvl(hr_ord_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute27, hr_api.g_varchar2) or
934: nvl(hr_ord_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute28, hr_api.g_varchar2) or
936: nvl(hr_ord_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
937: nvl(p_rec.attribute29, hr_api.g_varchar2) or
938: nvl(hr_ord_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
932: nvl(hr_ord_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute27, hr_api.g_varchar2) or
934: nvl(hr_ord_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute28, hr_api.g_varchar2) or
936: nvl(hr_ord_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
937: nvl(p_rec.attribute29, hr_api.g_varchar2) or
938: nvl(hr_ord_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
939: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
940: or (p_rec.organization_link_id is null) then
934: nvl(hr_ord_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute28, hr_api.g_varchar2) or
936: nvl(hr_ord_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
937: nvl(p_rec.attribute29, hr_api.g_varchar2) or
938: nvl(hr_ord_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
939: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
940: or (p_rec.organization_link_id is null) then
941: --
942: -- Only execute the validation if absolutely necessary:
1042: -- {End Of Comments}
1043: -- ----------------------------------------------------------------------------
1044: Procedure chk_non_updateable_args
1045: (p_effective_date in date
1046: ,p_rec in hr_ord_shd.g_rec_type
1047: ) IS
1048: --
1049: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
1050: l_error EXCEPTION;
1054: --
1055: -- Only proceed with the validation if a row exists for the current
1056: -- record in the HR Schema.
1057: --
1058: IF NOT hr_ord_shd.api_updating
1059: (p_organization_link_id => p_rec.organization_link_id
1060: ,p_object_version_number => p_rec.object_version_number
1061: ) THEN
1062: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
1065: fnd_message.raise_error;
1066: END IF;
1067: --
1068: if nvl(p_rec.business_group_id, hr_api.g_number) <>
1069: nvl(hr_ord_shd.g_old_rec.business_group_id, hr_api.g_number) then
1070: l_argument := 'business_group_id';
1071: raise l_error;
1072: end if;
1073: --
1071: raise l_error;
1072: end if;
1073: --
1074: if nvl(p_rec.parent_organization_id, hr_api.g_number) <>
1075: nvl(hr_ord_shd.g_old_rec.parent_organization_id, hr_api.g_number) then
1076: l_argument := 'parent_organization_id';
1077: raise l_error;
1078: end if;
1079: --
1077: raise l_error;
1078: end if;
1079: --
1080: if nvl(p_rec.child_organization_id, hr_api.g_number) <>
1081: nvl(hr_ord_shd.g_old_rec.child_organization_id, hr_api.g_number) then
1082: l_argument := 'child_organization_id';
1083: raise l_error;
1084: end if;
1085: --
1083: raise l_error;
1084: end if;
1085: --
1086: if nvl(p_rec.org_link_type, hr_api.g_varchar2) <>
1087: nvl(hr_ord_shd.g_old_rec.org_link_type, hr_api.g_varchar2) then
1088: l_argument := 'org_link_type';
1089: raise l_error;
1090: end if;
1091: --
1089: raise l_error;
1090: end if;
1091: --
1092: if nvl(p_rec.org_link_information_category, hr_api.g_varchar2) <>
1093: nvl(hr_ord_shd.g_old_rec.org_link_information_category, hr_api.g_varchar2) then
1094: l_argument := 'org_link_information_category';
1095: raise l_error;
1096: end if;
1097: --
1108: -- |---------------------------< insert_validate >----------------------------|
1109: -- ----------------------------------------------------------------------------
1110: Procedure insert_validate
1111: (p_effective_date in date
1112: ,p_rec in hr_ord_shd.g_rec_type) is
1113: --
1114: --
1115: -- Local Variables.
1116: --
1165: -- |---------------------------< update_validate >----------------------------|
1166: -- ----------------------------------------------------------------------------
1167: Procedure update_validate
1168: (p_effective_date in date
1169: ,p_rec in hr_ord_shd.g_rec_type) is
1170: --
1171: --
1172: -- Local Variables.
1173: --
1202: -- ----------------------------------------------------------------------------
1203: -- |---------------------------< delete_validate >----------------------------|
1204: -- ----------------------------------------------------------------------------
1205: Procedure delete_validate
1206: (p_rec in hr_ord_shd.g_rec_type
1207: ) is
1208: --
1209: l_proc varchar2(72) := g_package||'delete_validate';
1210: --