eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_ORD_BUS dependencies on HR_ORD_SHD

Line 692: (p_rec in hr_ord_shd.g_rec_type

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: --

Line 701: nvl(hr_ord_shd.g_old_rec.org_link_information_category, hr_api.g_varchar2) <>

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) <>

Line 703: nvl(hr_ord_shd.g_old_rec.org_link_information1, 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) <>

Line 705: nvl(hr_ord_shd.g_old_rec.org_link_information2, 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) <>

Line 707: nvl(hr_ord_shd.g_old_rec.org_link_information3, 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) <>

Line 709: nvl(hr_ord_shd.g_old_rec.org_link_information4, 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) <>

Line 711: nvl(hr_ord_shd.g_old_rec.org_link_information5, 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) <>

Line 713: nvl(hr_ord_shd.g_old_rec.org_link_information6, 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) <>

Line 715: nvl(hr_ord_shd.g_old_rec.org_link_information7, 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) <>

Line 717: nvl(hr_ord_shd.g_old_rec.org_link_information8, 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) <>

Line 719: nvl(hr_ord_shd.g_old_rec.org_link_information9, 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) <>

Line 721: nvl(hr_ord_shd.g_old_rec.org_link_information10, 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) <>

Line 723: nvl(hr_ord_shd.g_old_rec.org_link_information11, 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) <>

Line 725: nvl(hr_ord_shd.g_old_rec.org_link_information12, 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) <>

Line 727: nvl(hr_ord_shd.g_old_rec.org_link_information13, 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) <>

Line 729: nvl(hr_ord_shd.g_old_rec.org_link_information14, 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) <>

Line 731: nvl(hr_ord_shd.g_old_rec.org_link_information15, 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) <>

Line 733: nvl(hr_ord_shd.g_old_rec.org_link_information16, 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) <>

Line 735: nvl(hr_ord_shd.g_old_rec.org_link_information17, 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) <>

Line 737: nvl(hr_ord_shd.g_old_rec.org_link_information18, 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) <>

Line 739: nvl(hr_ord_shd.g_old_rec.org_link_information19, 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) <>

Line 741: nvl(hr_ord_shd.g_old_rec.org_link_information20, 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) <>

Line 743: nvl(hr_ord_shd.g_old_rec.org_link_information21, 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) <>

Line 745: nvl(hr_ord_shd.g_old_rec.org_link_information22, 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) <>

Line 747: nvl(hr_ord_shd.g_old_rec.org_link_information23, 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) <>

Line 749: nvl(hr_ord_shd.g_old_rec.org_link_information24, 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) <>

Line 751: nvl(hr_ord_shd.g_old_rec.org_link_information25, 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) <>

Line 753: nvl(hr_ord_shd.g_old_rec.org_link_information26, 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) <>

Line 755: nvl(hr_ord_shd.g_old_rec.org_link_information27, 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) <>

Line 757: nvl(hr_ord_shd.g_old_rec.org_link_information28, 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) <>

Line 759: nvl(hr_ord_shd.g_old_rec.org_link_information29, 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

Line 761: nvl(hr_ord_shd.g_old_rec.org_link_information30, hr_api.g_varchar2) <>

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:

Line 869: (p_rec in hr_ord_shd.g_rec_type

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: --

Line 878: nvl(hr_ord_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

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) <>

Line 880: nvl(hr_ord_shd.g_old_rec.attribute1, 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) <>

Line 882: nvl(hr_ord_shd.g_old_rec.attribute2, 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) <>

Line 884: nvl(hr_ord_shd.g_old_rec.attribute3, 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) <>

Line 886: nvl(hr_ord_shd.g_old_rec.attribute4, 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) <>

Line 888: nvl(hr_ord_shd.g_old_rec.attribute5, 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) <>

Line 890: nvl(hr_ord_shd.g_old_rec.attribute6, 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) <>

Line 892: nvl(hr_ord_shd.g_old_rec.attribute7, 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) <>

Line 894: nvl(hr_ord_shd.g_old_rec.attribute8, 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) <>

Line 896: nvl(hr_ord_shd.g_old_rec.attribute9, 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) <>

Line 898: nvl(hr_ord_shd.g_old_rec.attribute10, 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) <>

Line 900: nvl(hr_ord_shd.g_old_rec.attribute11, 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) <>

Line 902: nvl(hr_ord_shd.g_old_rec.attribute12, 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) <>

Line 904: nvl(hr_ord_shd.g_old_rec.attribute13, 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) <>

Line 906: nvl(hr_ord_shd.g_old_rec.attribute14, 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) <>

Line 908: nvl(hr_ord_shd.g_old_rec.attribute15, 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) <>

Line 910: nvl(hr_ord_shd.g_old_rec.attribute16, 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) <>

Line 912: nvl(hr_ord_shd.g_old_rec.attribute17, 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) <>

Line 914: nvl(hr_ord_shd.g_old_rec.attribute18, 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) <>

Line 916: nvl(hr_ord_shd.g_old_rec.attribute19, 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) <>

Line 918: nvl(hr_ord_shd.g_old_rec.attribute20, 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) <>

Line 920: nvl(hr_ord_shd.g_old_rec.attribute21, 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) <>

Line 922: nvl(hr_ord_shd.g_old_rec.attribute22, 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) <>

Line 924: nvl(hr_ord_shd.g_old_rec.attribute23, 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) <>

Line 926: nvl(hr_ord_shd.g_old_rec.attribute24, 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) <>

Line 928: nvl(hr_ord_shd.g_old_rec.attribute25, 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) <>

Line 930: nvl(hr_ord_shd.g_old_rec.attribute26, 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) <>

Line 932: nvl(hr_ord_shd.g_old_rec.attribute27, 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) <>

Line 934: nvl(hr_ord_shd.g_old_rec.attribute28, 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) <>

Line 936: nvl(hr_ord_shd.g_old_rec.attribute29, 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

Line 938: nvl(hr_ord_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

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:

Line 1046: ,p_rec in hr_ord_shd.g_rec_type

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;

Line 1058: IF NOT hr_ord_shd.api_updating

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');

Line 1069: nvl(hr_ord_shd.g_old_rec.business_group_id, hr_api.g_number) then

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: --

Line 1075: nvl(hr_ord_shd.g_old_rec.parent_organization_id, hr_api.g_number) then

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: --

Line 1081: nvl(hr_ord_shd.g_old_rec.child_organization_id, hr_api.g_number) then

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: --

Line 1087: nvl(hr_ord_shd.g_old_rec.org_link_type, hr_api.g_varchar2) then

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: --

Line 1093: nvl(hr_ord_shd.g_old_rec.org_link_information_category, hr_api.g_varchar2) then

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: --

Line 1112: ,p_rec in hr_ord_shd.g_rec_type) is

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: --

Line 1169: ,p_rec in hr_ord_shd.g_rec_type) is

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: --

Line 1206: (p_rec in hr_ord_shd.g_rec_type

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: --