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_UPD dependencies on HR_API

Line 147: When hr_api.check_integrity_violated Then

143: --
144: hr_utility.set_location(' Leaving:'||l_proc, 10);
145: --
146: Exception
147: When hr_api.check_integrity_violated Then
148: -- A check constraint has been violated
149: --
150: hr_ord_shd.constraint_error
151: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 151: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

147: When hr_api.check_integrity_violated Then
148: -- A check constraint has been violated
149: --
150: hr_ord_shd.constraint_error
151: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
152: When hr_api.parent_integrity_violated Then
153: -- Parent integrity has been violated
154: --
155: hr_ord_shd.constraint_error

Line 152: When hr_api.parent_integrity_violated Then

148: -- A check constraint has been violated
149: --
150: hr_ord_shd.constraint_error
151: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
152: When hr_api.parent_integrity_violated Then
153: -- Parent integrity has been violated
154: --
155: hr_ord_shd.constraint_error
156: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 156: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

152: When hr_api.parent_integrity_violated Then
153: -- Parent integrity has been violated
154: --
155: hr_ord_shd.constraint_error
156: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
157: When hr_api.unique_integrity_violated Then
158: -- Unique integrity has been violated
159: --
160: hr_ord_shd.constraint_error

Line 157: When hr_api.unique_integrity_violated Then

153: -- Parent integrity has been violated
154: --
155: hr_ord_shd.constraint_error
156: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
157: When hr_api.unique_integrity_violated Then
158: -- Unique integrity has been violated
159: --
160: hr_ord_shd.constraint_error
161: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 161: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

157: When hr_api.unique_integrity_violated Then
158: -- Unique integrity has been violated
159: --
160: hr_ord_shd.constraint_error
161: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
162: When Others Then
163: --
164: Raise;
165: End update_dml;

Line 530: when hr_api.cannot_find_prog_unit then

526: );
527: --
528: exception
529: --
530: when hr_api.cannot_find_prog_unit then
531: --
532: hr_api.cannot_find_prog_unit_error
533: (p_module_name => 'HR_DE_ORGANIZATION_LINKS'
534: ,p_hook_type => 'AU');

Line 532: hr_api.cannot_find_prog_unit_error

528: exception
529: --
530: when hr_api.cannot_find_prog_unit then
531: --
532: hr_api.cannot_find_prog_unit_error
533: (p_module_name => 'HR_DE_ORGANIZATION_LINKS'
534: ,p_hook_type => 'AU');
535: --
536: end;

Line 595: If (p_rec.parent_organization_id = hr_api.g_number) then

591: -- p_rec plsql record structure
592: -- to see if a system default is being used. If a system default
593: -- is being used then we must set to the 'current' argument value.
594: --
595: If (p_rec.parent_organization_id = hr_api.g_number) then
596: p_rec.parent_organization_id :=
597: hr_ord_shd.g_old_rec.parent_organization_id;
598: End If;
599: If (p_rec.child_organization_id = hr_api.g_number) then

Line 599: If (p_rec.child_organization_id = hr_api.g_number) then

595: If (p_rec.parent_organization_id = hr_api.g_number) then
596: p_rec.parent_organization_id :=
597: hr_ord_shd.g_old_rec.parent_organization_id;
598: End If;
599: If (p_rec.child_organization_id = hr_api.g_number) then
600: p_rec.child_organization_id :=
601: hr_ord_shd.g_old_rec.child_organization_id;
602: End If;
603: If (p_rec.business_group_id = hr_api.g_number) then

Line 603: If (p_rec.business_group_id = hr_api.g_number) then

599: If (p_rec.child_organization_id = hr_api.g_number) then
600: p_rec.child_organization_id :=
601: hr_ord_shd.g_old_rec.child_organization_id;
602: End If;
603: If (p_rec.business_group_id = hr_api.g_number) then
604: p_rec.business_group_id :=
605: hr_ord_shd.g_old_rec.business_group_id;
606: End If;
607: If (p_rec.org_link_information_category = hr_api.g_varchar2) then

Line 607: If (p_rec.org_link_information_category = hr_api.g_varchar2) then

603: If (p_rec.business_group_id = hr_api.g_number) then
604: p_rec.business_group_id :=
605: hr_ord_shd.g_old_rec.business_group_id;
606: End If;
607: If (p_rec.org_link_information_category = hr_api.g_varchar2) then
608: p_rec.org_link_information_category :=
609: hr_ord_shd.g_old_rec.org_link_information_category;
610: End If;
611: If (p_rec.org_link_information1 = hr_api.g_varchar2) then

Line 611: If (p_rec.org_link_information1 = hr_api.g_varchar2) then

607: If (p_rec.org_link_information_category = hr_api.g_varchar2) then
608: p_rec.org_link_information_category :=
609: hr_ord_shd.g_old_rec.org_link_information_category;
610: End If;
611: If (p_rec.org_link_information1 = hr_api.g_varchar2) then
612: p_rec.org_link_information1 :=
613: hr_ord_shd.g_old_rec.org_link_information1;
614: End If;
615: If (p_rec.org_link_information2 = hr_api.g_varchar2) then

Line 615: If (p_rec.org_link_information2 = hr_api.g_varchar2) then

611: If (p_rec.org_link_information1 = hr_api.g_varchar2) then
612: p_rec.org_link_information1 :=
613: hr_ord_shd.g_old_rec.org_link_information1;
614: End If;
615: If (p_rec.org_link_information2 = hr_api.g_varchar2) then
616: p_rec.org_link_information2 :=
617: hr_ord_shd.g_old_rec.org_link_information2;
618: End If;
619: If (p_rec.org_link_information3 = hr_api.g_varchar2) then

Line 619: If (p_rec.org_link_information3 = hr_api.g_varchar2) then

615: If (p_rec.org_link_information2 = hr_api.g_varchar2) then
616: p_rec.org_link_information2 :=
617: hr_ord_shd.g_old_rec.org_link_information2;
618: End If;
619: If (p_rec.org_link_information3 = hr_api.g_varchar2) then
620: p_rec.org_link_information3 :=
621: hr_ord_shd.g_old_rec.org_link_information3;
622: End If;
623: If (p_rec.org_link_information4 = hr_api.g_varchar2) then

Line 623: If (p_rec.org_link_information4 = hr_api.g_varchar2) then

619: If (p_rec.org_link_information3 = hr_api.g_varchar2) then
620: p_rec.org_link_information3 :=
621: hr_ord_shd.g_old_rec.org_link_information3;
622: End If;
623: If (p_rec.org_link_information4 = hr_api.g_varchar2) then
624: p_rec.org_link_information4 :=
625: hr_ord_shd.g_old_rec.org_link_information4;
626: End If;
627: If (p_rec.org_link_information5 = hr_api.g_varchar2) then

Line 627: If (p_rec.org_link_information5 = hr_api.g_varchar2) then

623: If (p_rec.org_link_information4 = hr_api.g_varchar2) then
624: p_rec.org_link_information4 :=
625: hr_ord_shd.g_old_rec.org_link_information4;
626: End If;
627: If (p_rec.org_link_information5 = hr_api.g_varchar2) then
628: p_rec.org_link_information5 :=
629: hr_ord_shd.g_old_rec.org_link_information5;
630: End If;
631: If (p_rec.org_link_information6 = hr_api.g_varchar2) then

Line 631: If (p_rec.org_link_information6 = hr_api.g_varchar2) then

627: If (p_rec.org_link_information5 = hr_api.g_varchar2) then
628: p_rec.org_link_information5 :=
629: hr_ord_shd.g_old_rec.org_link_information5;
630: End If;
631: If (p_rec.org_link_information6 = hr_api.g_varchar2) then
632: p_rec.org_link_information6 :=
633: hr_ord_shd.g_old_rec.org_link_information6;
634: End If;
635: If (p_rec.org_link_information7 = hr_api.g_varchar2) then

Line 635: If (p_rec.org_link_information7 = hr_api.g_varchar2) then

631: If (p_rec.org_link_information6 = hr_api.g_varchar2) then
632: p_rec.org_link_information6 :=
633: hr_ord_shd.g_old_rec.org_link_information6;
634: End If;
635: If (p_rec.org_link_information7 = hr_api.g_varchar2) then
636: p_rec.org_link_information7 :=
637: hr_ord_shd.g_old_rec.org_link_information7;
638: End If;
639: If (p_rec.org_link_information8 = hr_api.g_varchar2) then

Line 639: If (p_rec.org_link_information8 = hr_api.g_varchar2) then

635: If (p_rec.org_link_information7 = hr_api.g_varchar2) then
636: p_rec.org_link_information7 :=
637: hr_ord_shd.g_old_rec.org_link_information7;
638: End If;
639: If (p_rec.org_link_information8 = hr_api.g_varchar2) then
640: p_rec.org_link_information8 :=
641: hr_ord_shd.g_old_rec.org_link_information8;
642: End If;
643: If (p_rec.org_link_information9 = hr_api.g_varchar2) then

Line 643: If (p_rec.org_link_information9 = hr_api.g_varchar2) then

639: If (p_rec.org_link_information8 = hr_api.g_varchar2) then
640: p_rec.org_link_information8 :=
641: hr_ord_shd.g_old_rec.org_link_information8;
642: End If;
643: If (p_rec.org_link_information9 = hr_api.g_varchar2) then
644: p_rec.org_link_information9 :=
645: hr_ord_shd.g_old_rec.org_link_information9;
646: End If;
647: If (p_rec.org_link_information10 = hr_api.g_varchar2) then

Line 647: If (p_rec.org_link_information10 = hr_api.g_varchar2) then

643: If (p_rec.org_link_information9 = hr_api.g_varchar2) then
644: p_rec.org_link_information9 :=
645: hr_ord_shd.g_old_rec.org_link_information9;
646: End If;
647: If (p_rec.org_link_information10 = hr_api.g_varchar2) then
648: p_rec.org_link_information10 :=
649: hr_ord_shd.g_old_rec.org_link_information10;
650: End If;
651: If (p_rec.org_link_information11 = hr_api.g_varchar2) then

Line 651: If (p_rec.org_link_information11 = hr_api.g_varchar2) then

647: If (p_rec.org_link_information10 = hr_api.g_varchar2) then
648: p_rec.org_link_information10 :=
649: hr_ord_shd.g_old_rec.org_link_information10;
650: End If;
651: If (p_rec.org_link_information11 = hr_api.g_varchar2) then
652: p_rec.org_link_information11 :=
653: hr_ord_shd.g_old_rec.org_link_information11;
654: End If;
655: If (p_rec.org_link_information12 = hr_api.g_varchar2) then

Line 655: If (p_rec.org_link_information12 = hr_api.g_varchar2) then

651: If (p_rec.org_link_information11 = hr_api.g_varchar2) then
652: p_rec.org_link_information11 :=
653: hr_ord_shd.g_old_rec.org_link_information11;
654: End If;
655: If (p_rec.org_link_information12 = hr_api.g_varchar2) then
656: p_rec.org_link_information12 :=
657: hr_ord_shd.g_old_rec.org_link_information12;
658: End If;
659: If (p_rec.org_link_information13 = hr_api.g_varchar2) then

Line 659: If (p_rec.org_link_information13 = hr_api.g_varchar2) then

655: If (p_rec.org_link_information12 = hr_api.g_varchar2) then
656: p_rec.org_link_information12 :=
657: hr_ord_shd.g_old_rec.org_link_information12;
658: End If;
659: If (p_rec.org_link_information13 = hr_api.g_varchar2) then
660: p_rec.org_link_information13 :=
661: hr_ord_shd.g_old_rec.org_link_information13;
662: End If;
663: If (p_rec.org_link_information14 = hr_api.g_varchar2) then

Line 663: If (p_rec.org_link_information14 = hr_api.g_varchar2) then

659: If (p_rec.org_link_information13 = hr_api.g_varchar2) then
660: p_rec.org_link_information13 :=
661: hr_ord_shd.g_old_rec.org_link_information13;
662: End If;
663: If (p_rec.org_link_information14 = hr_api.g_varchar2) then
664: p_rec.org_link_information14 :=
665: hr_ord_shd.g_old_rec.org_link_information14;
666: End If;
667: If (p_rec.org_link_information15 = hr_api.g_varchar2) then

Line 667: If (p_rec.org_link_information15 = hr_api.g_varchar2) then

663: If (p_rec.org_link_information14 = hr_api.g_varchar2) then
664: p_rec.org_link_information14 :=
665: hr_ord_shd.g_old_rec.org_link_information14;
666: End If;
667: If (p_rec.org_link_information15 = hr_api.g_varchar2) then
668: p_rec.org_link_information15 :=
669: hr_ord_shd.g_old_rec.org_link_information15;
670: End If;
671: If (p_rec.org_link_information16 = hr_api.g_varchar2) then

Line 671: If (p_rec.org_link_information16 = hr_api.g_varchar2) then

667: If (p_rec.org_link_information15 = hr_api.g_varchar2) then
668: p_rec.org_link_information15 :=
669: hr_ord_shd.g_old_rec.org_link_information15;
670: End If;
671: If (p_rec.org_link_information16 = hr_api.g_varchar2) then
672: p_rec.org_link_information16 :=
673: hr_ord_shd.g_old_rec.org_link_information16;
674: End If;
675: If (p_rec.org_link_information17 = hr_api.g_varchar2) then

Line 675: If (p_rec.org_link_information17 = hr_api.g_varchar2) then

671: If (p_rec.org_link_information16 = hr_api.g_varchar2) then
672: p_rec.org_link_information16 :=
673: hr_ord_shd.g_old_rec.org_link_information16;
674: End If;
675: If (p_rec.org_link_information17 = hr_api.g_varchar2) then
676: p_rec.org_link_information17 :=
677: hr_ord_shd.g_old_rec.org_link_information17;
678: End If;
679: If (p_rec.org_link_information18 = hr_api.g_varchar2) then

Line 679: If (p_rec.org_link_information18 = hr_api.g_varchar2) then

675: If (p_rec.org_link_information17 = hr_api.g_varchar2) then
676: p_rec.org_link_information17 :=
677: hr_ord_shd.g_old_rec.org_link_information17;
678: End If;
679: If (p_rec.org_link_information18 = hr_api.g_varchar2) then
680: p_rec.org_link_information18 :=
681: hr_ord_shd.g_old_rec.org_link_information18;
682: End If;
683: If (p_rec.org_link_information19 = hr_api.g_varchar2) then

Line 683: If (p_rec.org_link_information19 = hr_api.g_varchar2) then

679: If (p_rec.org_link_information18 = hr_api.g_varchar2) then
680: p_rec.org_link_information18 :=
681: hr_ord_shd.g_old_rec.org_link_information18;
682: End If;
683: If (p_rec.org_link_information19 = hr_api.g_varchar2) then
684: p_rec.org_link_information19 :=
685: hr_ord_shd.g_old_rec.org_link_information19;
686: End If;
687: If (p_rec.org_link_information20 = hr_api.g_varchar2) then

Line 687: If (p_rec.org_link_information20 = hr_api.g_varchar2) then

683: If (p_rec.org_link_information19 = hr_api.g_varchar2) then
684: p_rec.org_link_information19 :=
685: hr_ord_shd.g_old_rec.org_link_information19;
686: End If;
687: If (p_rec.org_link_information20 = hr_api.g_varchar2) then
688: p_rec.org_link_information20 :=
689: hr_ord_shd.g_old_rec.org_link_information20;
690: End If;
691: If (p_rec.org_link_information21 = hr_api.g_varchar2) then

Line 691: If (p_rec.org_link_information21 = hr_api.g_varchar2) then

687: If (p_rec.org_link_information20 = hr_api.g_varchar2) then
688: p_rec.org_link_information20 :=
689: hr_ord_shd.g_old_rec.org_link_information20;
690: End If;
691: If (p_rec.org_link_information21 = hr_api.g_varchar2) then
692: p_rec.org_link_information21 :=
693: hr_ord_shd.g_old_rec.org_link_information21;
694: End If;
695: If (p_rec.org_link_information22 = hr_api.g_varchar2) then

Line 695: If (p_rec.org_link_information22 = hr_api.g_varchar2) then

691: If (p_rec.org_link_information21 = hr_api.g_varchar2) then
692: p_rec.org_link_information21 :=
693: hr_ord_shd.g_old_rec.org_link_information21;
694: End If;
695: If (p_rec.org_link_information22 = hr_api.g_varchar2) then
696: p_rec.org_link_information22 :=
697: hr_ord_shd.g_old_rec.org_link_information22;
698: End If;
699: If (p_rec.org_link_information23 = hr_api.g_varchar2) then

Line 699: If (p_rec.org_link_information23 = hr_api.g_varchar2) then

695: If (p_rec.org_link_information22 = hr_api.g_varchar2) then
696: p_rec.org_link_information22 :=
697: hr_ord_shd.g_old_rec.org_link_information22;
698: End If;
699: If (p_rec.org_link_information23 = hr_api.g_varchar2) then
700: p_rec.org_link_information23 :=
701: hr_ord_shd.g_old_rec.org_link_information23;
702: End If;
703: If (p_rec.org_link_information24 = hr_api.g_varchar2) then

Line 703: If (p_rec.org_link_information24 = hr_api.g_varchar2) then

699: If (p_rec.org_link_information23 = hr_api.g_varchar2) then
700: p_rec.org_link_information23 :=
701: hr_ord_shd.g_old_rec.org_link_information23;
702: End If;
703: If (p_rec.org_link_information24 = hr_api.g_varchar2) then
704: p_rec.org_link_information24 :=
705: hr_ord_shd.g_old_rec.org_link_information24;
706: End If;
707: If (p_rec.org_link_information25 = hr_api.g_varchar2) then

Line 707: If (p_rec.org_link_information25 = hr_api.g_varchar2) then

703: If (p_rec.org_link_information24 = hr_api.g_varchar2) then
704: p_rec.org_link_information24 :=
705: hr_ord_shd.g_old_rec.org_link_information24;
706: End If;
707: If (p_rec.org_link_information25 = hr_api.g_varchar2) then
708: p_rec.org_link_information25 :=
709: hr_ord_shd.g_old_rec.org_link_information25;
710: End If;
711: If (p_rec.org_link_information26 = hr_api.g_varchar2) then

Line 711: If (p_rec.org_link_information26 = hr_api.g_varchar2) then

707: If (p_rec.org_link_information25 = hr_api.g_varchar2) then
708: p_rec.org_link_information25 :=
709: hr_ord_shd.g_old_rec.org_link_information25;
710: End If;
711: If (p_rec.org_link_information26 = hr_api.g_varchar2) then
712: p_rec.org_link_information26 :=
713: hr_ord_shd.g_old_rec.org_link_information26;
714: End If;
715: If (p_rec.org_link_information27 = hr_api.g_varchar2) then

Line 715: If (p_rec.org_link_information27 = hr_api.g_varchar2) then

711: If (p_rec.org_link_information26 = hr_api.g_varchar2) then
712: p_rec.org_link_information26 :=
713: hr_ord_shd.g_old_rec.org_link_information26;
714: End If;
715: If (p_rec.org_link_information27 = hr_api.g_varchar2) then
716: p_rec.org_link_information27 :=
717: hr_ord_shd.g_old_rec.org_link_information27;
718: End If;
719: If (p_rec.org_link_information28 = hr_api.g_varchar2) then

Line 719: If (p_rec.org_link_information28 = hr_api.g_varchar2) then

715: If (p_rec.org_link_information27 = hr_api.g_varchar2) then
716: p_rec.org_link_information27 :=
717: hr_ord_shd.g_old_rec.org_link_information27;
718: End If;
719: If (p_rec.org_link_information28 = hr_api.g_varchar2) then
720: p_rec.org_link_information28 :=
721: hr_ord_shd.g_old_rec.org_link_information28;
722: End If;
723: If (p_rec.org_link_information29 = hr_api.g_varchar2) then

Line 723: If (p_rec.org_link_information29 = hr_api.g_varchar2) then

719: If (p_rec.org_link_information28 = hr_api.g_varchar2) then
720: p_rec.org_link_information28 :=
721: hr_ord_shd.g_old_rec.org_link_information28;
722: End If;
723: If (p_rec.org_link_information29 = hr_api.g_varchar2) then
724: p_rec.org_link_information29 :=
725: hr_ord_shd.g_old_rec.org_link_information29;
726: End If;
727: If (p_rec.org_link_information30 = hr_api.g_varchar2) then

Line 727: If (p_rec.org_link_information30 = hr_api.g_varchar2) then

723: If (p_rec.org_link_information29 = hr_api.g_varchar2) then
724: p_rec.org_link_information29 :=
725: hr_ord_shd.g_old_rec.org_link_information29;
726: End If;
727: If (p_rec.org_link_information30 = hr_api.g_varchar2) then
728: p_rec.org_link_information30 :=
729: hr_ord_shd.g_old_rec.org_link_information30;
730: End If;
731: If (p_rec.attribute_category = hr_api.g_varchar2) then

Line 731: If (p_rec.attribute_category = hr_api.g_varchar2) then

727: If (p_rec.org_link_information30 = hr_api.g_varchar2) then
728: p_rec.org_link_information30 :=
729: hr_ord_shd.g_old_rec.org_link_information30;
730: End If;
731: If (p_rec.attribute_category = hr_api.g_varchar2) then
732: p_rec.attribute_category :=
733: hr_ord_shd.g_old_rec.attribute_category;
734: End If;
735: If (p_rec.attribute1 = hr_api.g_varchar2) then

Line 735: If (p_rec.attribute1 = hr_api.g_varchar2) then

731: If (p_rec.attribute_category = hr_api.g_varchar2) then
732: p_rec.attribute_category :=
733: hr_ord_shd.g_old_rec.attribute_category;
734: End If;
735: If (p_rec.attribute1 = hr_api.g_varchar2) then
736: p_rec.attribute1 :=
737: hr_ord_shd.g_old_rec.attribute1;
738: End If;
739: If (p_rec.attribute2 = hr_api.g_varchar2) then

Line 739: If (p_rec.attribute2 = hr_api.g_varchar2) then

735: If (p_rec.attribute1 = hr_api.g_varchar2) then
736: p_rec.attribute1 :=
737: hr_ord_shd.g_old_rec.attribute1;
738: End If;
739: If (p_rec.attribute2 = hr_api.g_varchar2) then
740: p_rec.attribute2 :=
741: hr_ord_shd.g_old_rec.attribute2;
742: End If;
743: If (p_rec.attribute3 = hr_api.g_varchar2) then

Line 743: If (p_rec.attribute3 = hr_api.g_varchar2) then

739: If (p_rec.attribute2 = hr_api.g_varchar2) then
740: p_rec.attribute2 :=
741: hr_ord_shd.g_old_rec.attribute2;
742: End If;
743: If (p_rec.attribute3 = hr_api.g_varchar2) then
744: p_rec.attribute3 :=
745: hr_ord_shd.g_old_rec.attribute3;
746: End If;
747: If (p_rec.attribute4 = hr_api.g_varchar2) then

Line 747: If (p_rec.attribute4 = hr_api.g_varchar2) then

743: If (p_rec.attribute3 = hr_api.g_varchar2) then
744: p_rec.attribute3 :=
745: hr_ord_shd.g_old_rec.attribute3;
746: End If;
747: If (p_rec.attribute4 = hr_api.g_varchar2) then
748: p_rec.attribute4 :=
749: hr_ord_shd.g_old_rec.attribute4;
750: End If;
751: If (p_rec.attribute5 = hr_api.g_varchar2) then

Line 751: If (p_rec.attribute5 = hr_api.g_varchar2) then

747: If (p_rec.attribute4 = hr_api.g_varchar2) then
748: p_rec.attribute4 :=
749: hr_ord_shd.g_old_rec.attribute4;
750: End If;
751: If (p_rec.attribute5 = hr_api.g_varchar2) then
752: p_rec.attribute5 :=
753: hr_ord_shd.g_old_rec.attribute5;
754: End If;
755: If (p_rec.attribute6 = hr_api.g_varchar2) then

Line 755: If (p_rec.attribute6 = hr_api.g_varchar2) then

751: If (p_rec.attribute5 = hr_api.g_varchar2) then
752: p_rec.attribute5 :=
753: hr_ord_shd.g_old_rec.attribute5;
754: End If;
755: If (p_rec.attribute6 = hr_api.g_varchar2) then
756: p_rec.attribute6 :=
757: hr_ord_shd.g_old_rec.attribute6;
758: End If;
759: If (p_rec.attribute7 = hr_api.g_varchar2) then

Line 759: If (p_rec.attribute7 = hr_api.g_varchar2) then

755: If (p_rec.attribute6 = hr_api.g_varchar2) then
756: p_rec.attribute6 :=
757: hr_ord_shd.g_old_rec.attribute6;
758: End If;
759: If (p_rec.attribute7 = hr_api.g_varchar2) then
760: p_rec.attribute7 :=
761: hr_ord_shd.g_old_rec.attribute7;
762: End If;
763: If (p_rec.attribute8 = hr_api.g_varchar2) then

Line 763: If (p_rec.attribute8 = hr_api.g_varchar2) then

759: If (p_rec.attribute7 = hr_api.g_varchar2) then
760: p_rec.attribute7 :=
761: hr_ord_shd.g_old_rec.attribute7;
762: End If;
763: If (p_rec.attribute8 = hr_api.g_varchar2) then
764: p_rec.attribute8 :=
765: hr_ord_shd.g_old_rec.attribute8;
766: End If;
767: If (p_rec.attribute9 = hr_api.g_varchar2) then

Line 767: If (p_rec.attribute9 = hr_api.g_varchar2) then

763: If (p_rec.attribute8 = hr_api.g_varchar2) then
764: p_rec.attribute8 :=
765: hr_ord_shd.g_old_rec.attribute8;
766: End If;
767: If (p_rec.attribute9 = hr_api.g_varchar2) then
768: p_rec.attribute9 :=
769: hr_ord_shd.g_old_rec.attribute9;
770: End If;
771: If (p_rec.attribute10 = hr_api.g_varchar2) then

Line 771: If (p_rec.attribute10 = hr_api.g_varchar2) then

767: If (p_rec.attribute9 = hr_api.g_varchar2) then
768: p_rec.attribute9 :=
769: hr_ord_shd.g_old_rec.attribute9;
770: End If;
771: If (p_rec.attribute10 = hr_api.g_varchar2) then
772: p_rec.attribute10 :=
773: hr_ord_shd.g_old_rec.attribute10;
774: End If;
775: If (p_rec.attribute11 = hr_api.g_varchar2) then

Line 775: If (p_rec.attribute11 = hr_api.g_varchar2) then

771: If (p_rec.attribute10 = hr_api.g_varchar2) then
772: p_rec.attribute10 :=
773: hr_ord_shd.g_old_rec.attribute10;
774: End If;
775: If (p_rec.attribute11 = hr_api.g_varchar2) then
776: p_rec.attribute11 :=
777: hr_ord_shd.g_old_rec.attribute11;
778: End If;
779: If (p_rec.attribute12 = hr_api.g_varchar2) then

Line 779: If (p_rec.attribute12 = hr_api.g_varchar2) then

775: If (p_rec.attribute11 = hr_api.g_varchar2) then
776: p_rec.attribute11 :=
777: hr_ord_shd.g_old_rec.attribute11;
778: End If;
779: If (p_rec.attribute12 = hr_api.g_varchar2) then
780: p_rec.attribute12 :=
781: hr_ord_shd.g_old_rec.attribute12;
782: End If;
783: If (p_rec.attribute13 = hr_api.g_varchar2) then

Line 783: If (p_rec.attribute13 = hr_api.g_varchar2) then

779: If (p_rec.attribute12 = hr_api.g_varchar2) then
780: p_rec.attribute12 :=
781: hr_ord_shd.g_old_rec.attribute12;
782: End If;
783: If (p_rec.attribute13 = hr_api.g_varchar2) then
784: p_rec.attribute13 :=
785: hr_ord_shd.g_old_rec.attribute13;
786: End If;
787: If (p_rec.attribute14 = hr_api.g_varchar2) then

Line 787: If (p_rec.attribute14 = hr_api.g_varchar2) then

783: If (p_rec.attribute13 = hr_api.g_varchar2) then
784: p_rec.attribute13 :=
785: hr_ord_shd.g_old_rec.attribute13;
786: End If;
787: If (p_rec.attribute14 = hr_api.g_varchar2) then
788: p_rec.attribute14 :=
789: hr_ord_shd.g_old_rec.attribute14;
790: End If;
791: If (p_rec.attribute15 = hr_api.g_varchar2) then

Line 791: If (p_rec.attribute15 = hr_api.g_varchar2) then

787: If (p_rec.attribute14 = hr_api.g_varchar2) then
788: p_rec.attribute14 :=
789: hr_ord_shd.g_old_rec.attribute14;
790: End If;
791: If (p_rec.attribute15 = hr_api.g_varchar2) then
792: p_rec.attribute15 :=
793: hr_ord_shd.g_old_rec.attribute15;
794: End If;
795: If (p_rec.attribute16 = hr_api.g_varchar2) then

Line 795: If (p_rec.attribute16 = hr_api.g_varchar2) then

791: If (p_rec.attribute15 = hr_api.g_varchar2) then
792: p_rec.attribute15 :=
793: hr_ord_shd.g_old_rec.attribute15;
794: End If;
795: If (p_rec.attribute16 = hr_api.g_varchar2) then
796: p_rec.attribute16 :=
797: hr_ord_shd.g_old_rec.attribute16;
798: End If;
799: If (p_rec.attribute17 = hr_api.g_varchar2) then

Line 799: If (p_rec.attribute17 = hr_api.g_varchar2) then

795: If (p_rec.attribute16 = hr_api.g_varchar2) then
796: p_rec.attribute16 :=
797: hr_ord_shd.g_old_rec.attribute16;
798: End If;
799: If (p_rec.attribute17 = hr_api.g_varchar2) then
800: p_rec.attribute17 :=
801: hr_ord_shd.g_old_rec.attribute17;
802: End If;
803: If (p_rec.attribute18 = hr_api.g_varchar2) then

Line 803: If (p_rec.attribute18 = hr_api.g_varchar2) then

799: If (p_rec.attribute17 = hr_api.g_varchar2) then
800: p_rec.attribute17 :=
801: hr_ord_shd.g_old_rec.attribute17;
802: End If;
803: If (p_rec.attribute18 = hr_api.g_varchar2) then
804: p_rec.attribute18 :=
805: hr_ord_shd.g_old_rec.attribute18;
806: End If;
807: If (p_rec.attribute19 = hr_api.g_varchar2) then

Line 807: If (p_rec.attribute19 = hr_api.g_varchar2) then

803: If (p_rec.attribute18 = hr_api.g_varchar2) then
804: p_rec.attribute18 :=
805: hr_ord_shd.g_old_rec.attribute18;
806: End If;
807: If (p_rec.attribute19 = hr_api.g_varchar2) then
808: p_rec.attribute19 :=
809: hr_ord_shd.g_old_rec.attribute19;
810: End If;
811: If (p_rec.attribute20 = hr_api.g_varchar2) then

Line 811: If (p_rec.attribute20 = hr_api.g_varchar2) then

807: If (p_rec.attribute19 = hr_api.g_varchar2) then
808: p_rec.attribute19 :=
809: hr_ord_shd.g_old_rec.attribute19;
810: End If;
811: If (p_rec.attribute20 = hr_api.g_varchar2) then
812: p_rec.attribute20 :=
813: hr_ord_shd.g_old_rec.attribute20;
814: End If;
815: If (p_rec.attribute21 = hr_api.g_varchar2) then

Line 815: If (p_rec.attribute21 = hr_api.g_varchar2) then

811: If (p_rec.attribute20 = hr_api.g_varchar2) then
812: p_rec.attribute20 :=
813: hr_ord_shd.g_old_rec.attribute20;
814: End If;
815: If (p_rec.attribute21 = hr_api.g_varchar2) then
816: p_rec.attribute21 :=
817: hr_ord_shd.g_old_rec.attribute21;
818: End If;
819: If (p_rec.attribute22 = hr_api.g_varchar2) then

Line 819: If (p_rec.attribute22 = hr_api.g_varchar2) then

815: If (p_rec.attribute21 = hr_api.g_varchar2) then
816: p_rec.attribute21 :=
817: hr_ord_shd.g_old_rec.attribute21;
818: End If;
819: If (p_rec.attribute22 = hr_api.g_varchar2) then
820: p_rec.attribute22 :=
821: hr_ord_shd.g_old_rec.attribute22;
822: End If;
823: If (p_rec.attribute23 = hr_api.g_varchar2) then

Line 823: If (p_rec.attribute23 = hr_api.g_varchar2) then

819: If (p_rec.attribute22 = hr_api.g_varchar2) then
820: p_rec.attribute22 :=
821: hr_ord_shd.g_old_rec.attribute22;
822: End If;
823: If (p_rec.attribute23 = hr_api.g_varchar2) then
824: p_rec.attribute23 :=
825: hr_ord_shd.g_old_rec.attribute23;
826: End If;
827: If (p_rec.attribute24 = hr_api.g_varchar2) then

Line 827: If (p_rec.attribute24 = hr_api.g_varchar2) then

823: If (p_rec.attribute23 = hr_api.g_varchar2) then
824: p_rec.attribute23 :=
825: hr_ord_shd.g_old_rec.attribute23;
826: End If;
827: If (p_rec.attribute24 = hr_api.g_varchar2) then
828: p_rec.attribute24 :=
829: hr_ord_shd.g_old_rec.attribute24;
830: End If;
831: If (p_rec.attribute25 = hr_api.g_varchar2) then

Line 831: If (p_rec.attribute25 = hr_api.g_varchar2) then

827: If (p_rec.attribute24 = hr_api.g_varchar2) then
828: p_rec.attribute24 :=
829: hr_ord_shd.g_old_rec.attribute24;
830: End If;
831: If (p_rec.attribute25 = hr_api.g_varchar2) then
832: p_rec.attribute25 :=
833: hr_ord_shd.g_old_rec.attribute25;
834: End If;
835: If (p_rec.attribute26 = hr_api.g_varchar2) then

Line 835: If (p_rec.attribute26 = hr_api.g_varchar2) then

831: If (p_rec.attribute25 = hr_api.g_varchar2) then
832: p_rec.attribute25 :=
833: hr_ord_shd.g_old_rec.attribute25;
834: End If;
835: If (p_rec.attribute26 = hr_api.g_varchar2) then
836: p_rec.attribute26 :=
837: hr_ord_shd.g_old_rec.attribute26;
838: End If;
839: If (p_rec.attribute27 = hr_api.g_varchar2) then

Line 839: If (p_rec.attribute27 = hr_api.g_varchar2) then

835: If (p_rec.attribute26 = hr_api.g_varchar2) then
836: p_rec.attribute26 :=
837: hr_ord_shd.g_old_rec.attribute26;
838: End If;
839: If (p_rec.attribute27 = hr_api.g_varchar2) then
840: p_rec.attribute27 :=
841: hr_ord_shd.g_old_rec.attribute27;
842: End If;
843: If (p_rec.attribute28 = hr_api.g_varchar2) then

Line 843: If (p_rec.attribute28 = hr_api.g_varchar2) then

839: If (p_rec.attribute27 = hr_api.g_varchar2) then
840: p_rec.attribute27 :=
841: hr_ord_shd.g_old_rec.attribute27;
842: End If;
843: If (p_rec.attribute28 = hr_api.g_varchar2) then
844: p_rec.attribute28 :=
845: hr_ord_shd.g_old_rec.attribute28;
846: End If;
847: If (p_rec.attribute29 = hr_api.g_varchar2) then

Line 847: If (p_rec.attribute29 = hr_api.g_varchar2) then

843: If (p_rec.attribute28 = hr_api.g_varchar2) then
844: p_rec.attribute28 :=
845: hr_ord_shd.g_old_rec.attribute28;
846: End If;
847: If (p_rec.attribute29 = hr_api.g_varchar2) then
848: p_rec.attribute29 :=
849: hr_ord_shd.g_old_rec.attribute29;
850: End If;
851: If (p_rec.attribute30 = hr_api.g_varchar2) then

Line 851: If (p_rec.attribute30 = hr_api.g_varchar2) then

847: If (p_rec.attribute29 = hr_api.g_varchar2) then
848: p_rec.attribute29 :=
849: hr_ord_shd.g_old_rec.attribute29;
850: End If;
851: If (p_rec.attribute30 = hr_api.g_varchar2) then
852: p_rec.attribute30 :=
853: hr_ord_shd.g_old_rec.attribute30;
854: End If;
855: If (p_rec.org_link_type = hr_api.g_varchar2) then

Line 855: If (p_rec.org_link_type = hr_api.g_varchar2) then

851: If (p_rec.attribute30 = hr_api.g_varchar2) then
852: p_rec.attribute30 :=
853: hr_ord_shd.g_old_rec.attribute30;
854: End If;
855: If (p_rec.org_link_type = hr_api.g_varchar2) then
856: p_rec.org_link_type :=
857: hr_ord_shd.g_old_rec.org_link_type;
858: End If;
859: --

Line 917: ,p_parent_organization_id in number default hr_api.g_number

913: Procedure upd
914: (p_effective_date in date
915: ,p_organization_link_id in number
916: ,p_object_version_number in out nocopy number
917: ,p_parent_organization_id in number default hr_api.g_number
918: ,p_child_organization_id in number default hr_api.g_number
919: ,p_business_group_id in number default hr_api.g_number
920: ,p_org_link_type in varchar2 default hr_api.g_varchar2
921: ,p_org_link_information_categor in varchar2 default hr_api.g_varchar2

Line 918: ,p_child_organization_id in number default hr_api.g_number

914: (p_effective_date in date
915: ,p_organization_link_id in number
916: ,p_object_version_number in out nocopy number
917: ,p_parent_organization_id in number default hr_api.g_number
918: ,p_child_organization_id in number default hr_api.g_number
919: ,p_business_group_id in number default hr_api.g_number
920: ,p_org_link_type in varchar2 default hr_api.g_varchar2
921: ,p_org_link_information_categor in varchar2 default hr_api.g_varchar2
922: ,p_org_link_information1 in varchar2 default hr_api.g_varchar2

Line 919: ,p_business_group_id in number default hr_api.g_number

915: ,p_organization_link_id in number
916: ,p_object_version_number in out nocopy number
917: ,p_parent_organization_id in number default hr_api.g_number
918: ,p_child_organization_id in number default hr_api.g_number
919: ,p_business_group_id in number default hr_api.g_number
920: ,p_org_link_type in varchar2 default hr_api.g_varchar2
921: ,p_org_link_information_categor in varchar2 default hr_api.g_varchar2
922: ,p_org_link_information1 in varchar2 default hr_api.g_varchar2
923: ,p_org_link_information2 in varchar2 default hr_api.g_varchar2

Line 920: ,p_org_link_type in varchar2 default hr_api.g_varchar2

916: ,p_object_version_number in out nocopy number
917: ,p_parent_organization_id in number default hr_api.g_number
918: ,p_child_organization_id in number default hr_api.g_number
919: ,p_business_group_id in number default hr_api.g_number
920: ,p_org_link_type in varchar2 default hr_api.g_varchar2
921: ,p_org_link_information_categor in varchar2 default hr_api.g_varchar2
922: ,p_org_link_information1 in varchar2 default hr_api.g_varchar2
923: ,p_org_link_information2 in varchar2 default hr_api.g_varchar2
924: ,p_org_link_information3 in varchar2 default hr_api.g_varchar2

Line 921: ,p_org_link_information_categor in varchar2 default hr_api.g_varchar2

917: ,p_parent_organization_id in number default hr_api.g_number
918: ,p_child_organization_id in number default hr_api.g_number
919: ,p_business_group_id in number default hr_api.g_number
920: ,p_org_link_type in varchar2 default hr_api.g_varchar2
921: ,p_org_link_information_categor in varchar2 default hr_api.g_varchar2
922: ,p_org_link_information1 in varchar2 default hr_api.g_varchar2
923: ,p_org_link_information2 in varchar2 default hr_api.g_varchar2
924: ,p_org_link_information3 in varchar2 default hr_api.g_varchar2
925: ,p_org_link_information4 in varchar2 default hr_api.g_varchar2

Line 922: ,p_org_link_information1 in varchar2 default hr_api.g_varchar2

918: ,p_child_organization_id in number default hr_api.g_number
919: ,p_business_group_id in number default hr_api.g_number
920: ,p_org_link_type in varchar2 default hr_api.g_varchar2
921: ,p_org_link_information_categor in varchar2 default hr_api.g_varchar2
922: ,p_org_link_information1 in varchar2 default hr_api.g_varchar2
923: ,p_org_link_information2 in varchar2 default hr_api.g_varchar2
924: ,p_org_link_information3 in varchar2 default hr_api.g_varchar2
925: ,p_org_link_information4 in varchar2 default hr_api.g_varchar2
926: ,p_org_link_information5 in varchar2 default hr_api.g_varchar2

Line 923: ,p_org_link_information2 in varchar2 default hr_api.g_varchar2

919: ,p_business_group_id in number default hr_api.g_number
920: ,p_org_link_type in varchar2 default hr_api.g_varchar2
921: ,p_org_link_information_categor in varchar2 default hr_api.g_varchar2
922: ,p_org_link_information1 in varchar2 default hr_api.g_varchar2
923: ,p_org_link_information2 in varchar2 default hr_api.g_varchar2
924: ,p_org_link_information3 in varchar2 default hr_api.g_varchar2
925: ,p_org_link_information4 in varchar2 default hr_api.g_varchar2
926: ,p_org_link_information5 in varchar2 default hr_api.g_varchar2
927: ,p_org_link_information6 in varchar2 default hr_api.g_varchar2

Line 924: ,p_org_link_information3 in varchar2 default hr_api.g_varchar2

920: ,p_org_link_type in varchar2 default hr_api.g_varchar2
921: ,p_org_link_information_categor in varchar2 default hr_api.g_varchar2
922: ,p_org_link_information1 in varchar2 default hr_api.g_varchar2
923: ,p_org_link_information2 in varchar2 default hr_api.g_varchar2
924: ,p_org_link_information3 in varchar2 default hr_api.g_varchar2
925: ,p_org_link_information4 in varchar2 default hr_api.g_varchar2
926: ,p_org_link_information5 in varchar2 default hr_api.g_varchar2
927: ,p_org_link_information6 in varchar2 default hr_api.g_varchar2
928: ,p_org_link_information7 in varchar2 default hr_api.g_varchar2

Line 925: ,p_org_link_information4 in varchar2 default hr_api.g_varchar2

921: ,p_org_link_information_categor in varchar2 default hr_api.g_varchar2
922: ,p_org_link_information1 in varchar2 default hr_api.g_varchar2
923: ,p_org_link_information2 in varchar2 default hr_api.g_varchar2
924: ,p_org_link_information3 in varchar2 default hr_api.g_varchar2
925: ,p_org_link_information4 in varchar2 default hr_api.g_varchar2
926: ,p_org_link_information5 in varchar2 default hr_api.g_varchar2
927: ,p_org_link_information6 in varchar2 default hr_api.g_varchar2
928: ,p_org_link_information7 in varchar2 default hr_api.g_varchar2
929: ,p_org_link_information8 in varchar2 default hr_api.g_varchar2

Line 926: ,p_org_link_information5 in varchar2 default hr_api.g_varchar2

922: ,p_org_link_information1 in varchar2 default hr_api.g_varchar2
923: ,p_org_link_information2 in varchar2 default hr_api.g_varchar2
924: ,p_org_link_information3 in varchar2 default hr_api.g_varchar2
925: ,p_org_link_information4 in varchar2 default hr_api.g_varchar2
926: ,p_org_link_information5 in varchar2 default hr_api.g_varchar2
927: ,p_org_link_information6 in varchar2 default hr_api.g_varchar2
928: ,p_org_link_information7 in varchar2 default hr_api.g_varchar2
929: ,p_org_link_information8 in varchar2 default hr_api.g_varchar2
930: ,p_org_link_information9 in varchar2 default hr_api.g_varchar2

Line 927: ,p_org_link_information6 in varchar2 default hr_api.g_varchar2

923: ,p_org_link_information2 in varchar2 default hr_api.g_varchar2
924: ,p_org_link_information3 in varchar2 default hr_api.g_varchar2
925: ,p_org_link_information4 in varchar2 default hr_api.g_varchar2
926: ,p_org_link_information5 in varchar2 default hr_api.g_varchar2
927: ,p_org_link_information6 in varchar2 default hr_api.g_varchar2
928: ,p_org_link_information7 in varchar2 default hr_api.g_varchar2
929: ,p_org_link_information8 in varchar2 default hr_api.g_varchar2
930: ,p_org_link_information9 in varchar2 default hr_api.g_varchar2
931: ,p_org_link_information10 in varchar2 default hr_api.g_varchar2

Line 928: ,p_org_link_information7 in varchar2 default hr_api.g_varchar2

924: ,p_org_link_information3 in varchar2 default hr_api.g_varchar2
925: ,p_org_link_information4 in varchar2 default hr_api.g_varchar2
926: ,p_org_link_information5 in varchar2 default hr_api.g_varchar2
927: ,p_org_link_information6 in varchar2 default hr_api.g_varchar2
928: ,p_org_link_information7 in varchar2 default hr_api.g_varchar2
929: ,p_org_link_information8 in varchar2 default hr_api.g_varchar2
930: ,p_org_link_information9 in varchar2 default hr_api.g_varchar2
931: ,p_org_link_information10 in varchar2 default hr_api.g_varchar2
932: ,p_org_link_information11 in varchar2 default hr_api.g_varchar2

Line 929: ,p_org_link_information8 in varchar2 default hr_api.g_varchar2

925: ,p_org_link_information4 in varchar2 default hr_api.g_varchar2
926: ,p_org_link_information5 in varchar2 default hr_api.g_varchar2
927: ,p_org_link_information6 in varchar2 default hr_api.g_varchar2
928: ,p_org_link_information7 in varchar2 default hr_api.g_varchar2
929: ,p_org_link_information8 in varchar2 default hr_api.g_varchar2
930: ,p_org_link_information9 in varchar2 default hr_api.g_varchar2
931: ,p_org_link_information10 in varchar2 default hr_api.g_varchar2
932: ,p_org_link_information11 in varchar2 default hr_api.g_varchar2
933: ,p_org_link_information12 in varchar2 default hr_api.g_varchar2

Line 930: ,p_org_link_information9 in varchar2 default hr_api.g_varchar2

926: ,p_org_link_information5 in varchar2 default hr_api.g_varchar2
927: ,p_org_link_information6 in varchar2 default hr_api.g_varchar2
928: ,p_org_link_information7 in varchar2 default hr_api.g_varchar2
929: ,p_org_link_information8 in varchar2 default hr_api.g_varchar2
930: ,p_org_link_information9 in varchar2 default hr_api.g_varchar2
931: ,p_org_link_information10 in varchar2 default hr_api.g_varchar2
932: ,p_org_link_information11 in varchar2 default hr_api.g_varchar2
933: ,p_org_link_information12 in varchar2 default hr_api.g_varchar2
934: ,p_org_link_information13 in varchar2 default hr_api.g_varchar2

Line 931: ,p_org_link_information10 in varchar2 default hr_api.g_varchar2

927: ,p_org_link_information6 in varchar2 default hr_api.g_varchar2
928: ,p_org_link_information7 in varchar2 default hr_api.g_varchar2
929: ,p_org_link_information8 in varchar2 default hr_api.g_varchar2
930: ,p_org_link_information9 in varchar2 default hr_api.g_varchar2
931: ,p_org_link_information10 in varchar2 default hr_api.g_varchar2
932: ,p_org_link_information11 in varchar2 default hr_api.g_varchar2
933: ,p_org_link_information12 in varchar2 default hr_api.g_varchar2
934: ,p_org_link_information13 in varchar2 default hr_api.g_varchar2
935: ,p_org_link_information14 in varchar2 default hr_api.g_varchar2

Line 932: ,p_org_link_information11 in varchar2 default hr_api.g_varchar2

928: ,p_org_link_information7 in varchar2 default hr_api.g_varchar2
929: ,p_org_link_information8 in varchar2 default hr_api.g_varchar2
930: ,p_org_link_information9 in varchar2 default hr_api.g_varchar2
931: ,p_org_link_information10 in varchar2 default hr_api.g_varchar2
932: ,p_org_link_information11 in varchar2 default hr_api.g_varchar2
933: ,p_org_link_information12 in varchar2 default hr_api.g_varchar2
934: ,p_org_link_information13 in varchar2 default hr_api.g_varchar2
935: ,p_org_link_information14 in varchar2 default hr_api.g_varchar2
936: ,p_org_link_information15 in varchar2 default hr_api.g_varchar2

Line 933: ,p_org_link_information12 in varchar2 default hr_api.g_varchar2

929: ,p_org_link_information8 in varchar2 default hr_api.g_varchar2
930: ,p_org_link_information9 in varchar2 default hr_api.g_varchar2
931: ,p_org_link_information10 in varchar2 default hr_api.g_varchar2
932: ,p_org_link_information11 in varchar2 default hr_api.g_varchar2
933: ,p_org_link_information12 in varchar2 default hr_api.g_varchar2
934: ,p_org_link_information13 in varchar2 default hr_api.g_varchar2
935: ,p_org_link_information14 in varchar2 default hr_api.g_varchar2
936: ,p_org_link_information15 in varchar2 default hr_api.g_varchar2
937: ,p_org_link_information16 in varchar2 default hr_api.g_varchar2

Line 934: ,p_org_link_information13 in varchar2 default hr_api.g_varchar2

930: ,p_org_link_information9 in varchar2 default hr_api.g_varchar2
931: ,p_org_link_information10 in varchar2 default hr_api.g_varchar2
932: ,p_org_link_information11 in varchar2 default hr_api.g_varchar2
933: ,p_org_link_information12 in varchar2 default hr_api.g_varchar2
934: ,p_org_link_information13 in varchar2 default hr_api.g_varchar2
935: ,p_org_link_information14 in varchar2 default hr_api.g_varchar2
936: ,p_org_link_information15 in varchar2 default hr_api.g_varchar2
937: ,p_org_link_information16 in varchar2 default hr_api.g_varchar2
938: ,p_org_link_information17 in varchar2 default hr_api.g_varchar2

Line 935: ,p_org_link_information14 in varchar2 default hr_api.g_varchar2

931: ,p_org_link_information10 in varchar2 default hr_api.g_varchar2
932: ,p_org_link_information11 in varchar2 default hr_api.g_varchar2
933: ,p_org_link_information12 in varchar2 default hr_api.g_varchar2
934: ,p_org_link_information13 in varchar2 default hr_api.g_varchar2
935: ,p_org_link_information14 in varchar2 default hr_api.g_varchar2
936: ,p_org_link_information15 in varchar2 default hr_api.g_varchar2
937: ,p_org_link_information16 in varchar2 default hr_api.g_varchar2
938: ,p_org_link_information17 in varchar2 default hr_api.g_varchar2
939: ,p_org_link_information18 in varchar2 default hr_api.g_varchar2

Line 936: ,p_org_link_information15 in varchar2 default hr_api.g_varchar2

932: ,p_org_link_information11 in varchar2 default hr_api.g_varchar2
933: ,p_org_link_information12 in varchar2 default hr_api.g_varchar2
934: ,p_org_link_information13 in varchar2 default hr_api.g_varchar2
935: ,p_org_link_information14 in varchar2 default hr_api.g_varchar2
936: ,p_org_link_information15 in varchar2 default hr_api.g_varchar2
937: ,p_org_link_information16 in varchar2 default hr_api.g_varchar2
938: ,p_org_link_information17 in varchar2 default hr_api.g_varchar2
939: ,p_org_link_information18 in varchar2 default hr_api.g_varchar2
940: ,p_org_link_information19 in varchar2 default hr_api.g_varchar2

Line 937: ,p_org_link_information16 in varchar2 default hr_api.g_varchar2

933: ,p_org_link_information12 in varchar2 default hr_api.g_varchar2
934: ,p_org_link_information13 in varchar2 default hr_api.g_varchar2
935: ,p_org_link_information14 in varchar2 default hr_api.g_varchar2
936: ,p_org_link_information15 in varchar2 default hr_api.g_varchar2
937: ,p_org_link_information16 in varchar2 default hr_api.g_varchar2
938: ,p_org_link_information17 in varchar2 default hr_api.g_varchar2
939: ,p_org_link_information18 in varchar2 default hr_api.g_varchar2
940: ,p_org_link_information19 in varchar2 default hr_api.g_varchar2
941: ,p_org_link_information20 in varchar2 default hr_api.g_varchar2

Line 938: ,p_org_link_information17 in varchar2 default hr_api.g_varchar2

934: ,p_org_link_information13 in varchar2 default hr_api.g_varchar2
935: ,p_org_link_information14 in varchar2 default hr_api.g_varchar2
936: ,p_org_link_information15 in varchar2 default hr_api.g_varchar2
937: ,p_org_link_information16 in varchar2 default hr_api.g_varchar2
938: ,p_org_link_information17 in varchar2 default hr_api.g_varchar2
939: ,p_org_link_information18 in varchar2 default hr_api.g_varchar2
940: ,p_org_link_information19 in varchar2 default hr_api.g_varchar2
941: ,p_org_link_information20 in varchar2 default hr_api.g_varchar2
942: ,p_org_link_information21 in varchar2 default hr_api.g_varchar2

Line 939: ,p_org_link_information18 in varchar2 default hr_api.g_varchar2

935: ,p_org_link_information14 in varchar2 default hr_api.g_varchar2
936: ,p_org_link_information15 in varchar2 default hr_api.g_varchar2
937: ,p_org_link_information16 in varchar2 default hr_api.g_varchar2
938: ,p_org_link_information17 in varchar2 default hr_api.g_varchar2
939: ,p_org_link_information18 in varchar2 default hr_api.g_varchar2
940: ,p_org_link_information19 in varchar2 default hr_api.g_varchar2
941: ,p_org_link_information20 in varchar2 default hr_api.g_varchar2
942: ,p_org_link_information21 in varchar2 default hr_api.g_varchar2
943: ,p_org_link_information22 in varchar2 default hr_api.g_varchar2

Line 940: ,p_org_link_information19 in varchar2 default hr_api.g_varchar2

936: ,p_org_link_information15 in varchar2 default hr_api.g_varchar2
937: ,p_org_link_information16 in varchar2 default hr_api.g_varchar2
938: ,p_org_link_information17 in varchar2 default hr_api.g_varchar2
939: ,p_org_link_information18 in varchar2 default hr_api.g_varchar2
940: ,p_org_link_information19 in varchar2 default hr_api.g_varchar2
941: ,p_org_link_information20 in varchar2 default hr_api.g_varchar2
942: ,p_org_link_information21 in varchar2 default hr_api.g_varchar2
943: ,p_org_link_information22 in varchar2 default hr_api.g_varchar2
944: ,p_org_link_information23 in varchar2 default hr_api.g_varchar2

Line 941: ,p_org_link_information20 in varchar2 default hr_api.g_varchar2

937: ,p_org_link_information16 in varchar2 default hr_api.g_varchar2
938: ,p_org_link_information17 in varchar2 default hr_api.g_varchar2
939: ,p_org_link_information18 in varchar2 default hr_api.g_varchar2
940: ,p_org_link_information19 in varchar2 default hr_api.g_varchar2
941: ,p_org_link_information20 in varchar2 default hr_api.g_varchar2
942: ,p_org_link_information21 in varchar2 default hr_api.g_varchar2
943: ,p_org_link_information22 in varchar2 default hr_api.g_varchar2
944: ,p_org_link_information23 in varchar2 default hr_api.g_varchar2
945: ,p_org_link_information24 in varchar2 default hr_api.g_varchar2

Line 942: ,p_org_link_information21 in varchar2 default hr_api.g_varchar2

938: ,p_org_link_information17 in varchar2 default hr_api.g_varchar2
939: ,p_org_link_information18 in varchar2 default hr_api.g_varchar2
940: ,p_org_link_information19 in varchar2 default hr_api.g_varchar2
941: ,p_org_link_information20 in varchar2 default hr_api.g_varchar2
942: ,p_org_link_information21 in varchar2 default hr_api.g_varchar2
943: ,p_org_link_information22 in varchar2 default hr_api.g_varchar2
944: ,p_org_link_information23 in varchar2 default hr_api.g_varchar2
945: ,p_org_link_information24 in varchar2 default hr_api.g_varchar2
946: ,p_org_link_information25 in varchar2 default hr_api.g_varchar2

Line 943: ,p_org_link_information22 in varchar2 default hr_api.g_varchar2

939: ,p_org_link_information18 in varchar2 default hr_api.g_varchar2
940: ,p_org_link_information19 in varchar2 default hr_api.g_varchar2
941: ,p_org_link_information20 in varchar2 default hr_api.g_varchar2
942: ,p_org_link_information21 in varchar2 default hr_api.g_varchar2
943: ,p_org_link_information22 in varchar2 default hr_api.g_varchar2
944: ,p_org_link_information23 in varchar2 default hr_api.g_varchar2
945: ,p_org_link_information24 in varchar2 default hr_api.g_varchar2
946: ,p_org_link_information25 in varchar2 default hr_api.g_varchar2
947: ,p_org_link_information26 in varchar2 default hr_api.g_varchar2

Line 944: ,p_org_link_information23 in varchar2 default hr_api.g_varchar2

940: ,p_org_link_information19 in varchar2 default hr_api.g_varchar2
941: ,p_org_link_information20 in varchar2 default hr_api.g_varchar2
942: ,p_org_link_information21 in varchar2 default hr_api.g_varchar2
943: ,p_org_link_information22 in varchar2 default hr_api.g_varchar2
944: ,p_org_link_information23 in varchar2 default hr_api.g_varchar2
945: ,p_org_link_information24 in varchar2 default hr_api.g_varchar2
946: ,p_org_link_information25 in varchar2 default hr_api.g_varchar2
947: ,p_org_link_information26 in varchar2 default hr_api.g_varchar2
948: ,p_org_link_information27 in varchar2 default hr_api.g_varchar2

Line 945: ,p_org_link_information24 in varchar2 default hr_api.g_varchar2

941: ,p_org_link_information20 in varchar2 default hr_api.g_varchar2
942: ,p_org_link_information21 in varchar2 default hr_api.g_varchar2
943: ,p_org_link_information22 in varchar2 default hr_api.g_varchar2
944: ,p_org_link_information23 in varchar2 default hr_api.g_varchar2
945: ,p_org_link_information24 in varchar2 default hr_api.g_varchar2
946: ,p_org_link_information25 in varchar2 default hr_api.g_varchar2
947: ,p_org_link_information26 in varchar2 default hr_api.g_varchar2
948: ,p_org_link_information27 in varchar2 default hr_api.g_varchar2
949: ,p_org_link_information28 in varchar2 default hr_api.g_varchar2

Line 946: ,p_org_link_information25 in varchar2 default hr_api.g_varchar2

942: ,p_org_link_information21 in varchar2 default hr_api.g_varchar2
943: ,p_org_link_information22 in varchar2 default hr_api.g_varchar2
944: ,p_org_link_information23 in varchar2 default hr_api.g_varchar2
945: ,p_org_link_information24 in varchar2 default hr_api.g_varchar2
946: ,p_org_link_information25 in varchar2 default hr_api.g_varchar2
947: ,p_org_link_information26 in varchar2 default hr_api.g_varchar2
948: ,p_org_link_information27 in varchar2 default hr_api.g_varchar2
949: ,p_org_link_information28 in varchar2 default hr_api.g_varchar2
950: ,p_org_link_information29 in varchar2 default hr_api.g_varchar2

Line 947: ,p_org_link_information26 in varchar2 default hr_api.g_varchar2

943: ,p_org_link_information22 in varchar2 default hr_api.g_varchar2
944: ,p_org_link_information23 in varchar2 default hr_api.g_varchar2
945: ,p_org_link_information24 in varchar2 default hr_api.g_varchar2
946: ,p_org_link_information25 in varchar2 default hr_api.g_varchar2
947: ,p_org_link_information26 in varchar2 default hr_api.g_varchar2
948: ,p_org_link_information27 in varchar2 default hr_api.g_varchar2
949: ,p_org_link_information28 in varchar2 default hr_api.g_varchar2
950: ,p_org_link_information29 in varchar2 default hr_api.g_varchar2
951: ,p_org_link_information30 in varchar2 default hr_api.g_varchar2

Line 948: ,p_org_link_information27 in varchar2 default hr_api.g_varchar2

944: ,p_org_link_information23 in varchar2 default hr_api.g_varchar2
945: ,p_org_link_information24 in varchar2 default hr_api.g_varchar2
946: ,p_org_link_information25 in varchar2 default hr_api.g_varchar2
947: ,p_org_link_information26 in varchar2 default hr_api.g_varchar2
948: ,p_org_link_information27 in varchar2 default hr_api.g_varchar2
949: ,p_org_link_information28 in varchar2 default hr_api.g_varchar2
950: ,p_org_link_information29 in varchar2 default hr_api.g_varchar2
951: ,p_org_link_information30 in varchar2 default hr_api.g_varchar2
952: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 949: ,p_org_link_information28 in varchar2 default hr_api.g_varchar2

945: ,p_org_link_information24 in varchar2 default hr_api.g_varchar2
946: ,p_org_link_information25 in varchar2 default hr_api.g_varchar2
947: ,p_org_link_information26 in varchar2 default hr_api.g_varchar2
948: ,p_org_link_information27 in varchar2 default hr_api.g_varchar2
949: ,p_org_link_information28 in varchar2 default hr_api.g_varchar2
950: ,p_org_link_information29 in varchar2 default hr_api.g_varchar2
951: ,p_org_link_information30 in varchar2 default hr_api.g_varchar2
952: ,p_attribute_category in varchar2 default hr_api.g_varchar2
953: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 950: ,p_org_link_information29 in varchar2 default hr_api.g_varchar2

946: ,p_org_link_information25 in varchar2 default hr_api.g_varchar2
947: ,p_org_link_information26 in varchar2 default hr_api.g_varchar2
948: ,p_org_link_information27 in varchar2 default hr_api.g_varchar2
949: ,p_org_link_information28 in varchar2 default hr_api.g_varchar2
950: ,p_org_link_information29 in varchar2 default hr_api.g_varchar2
951: ,p_org_link_information30 in varchar2 default hr_api.g_varchar2
952: ,p_attribute_category in varchar2 default hr_api.g_varchar2
953: ,p_attribute1 in varchar2 default hr_api.g_varchar2
954: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 951: ,p_org_link_information30 in varchar2 default hr_api.g_varchar2

947: ,p_org_link_information26 in varchar2 default hr_api.g_varchar2
948: ,p_org_link_information27 in varchar2 default hr_api.g_varchar2
949: ,p_org_link_information28 in varchar2 default hr_api.g_varchar2
950: ,p_org_link_information29 in varchar2 default hr_api.g_varchar2
951: ,p_org_link_information30 in varchar2 default hr_api.g_varchar2
952: ,p_attribute_category in varchar2 default hr_api.g_varchar2
953: ,p_attribute1 in varchar2 default hr_api.g_varchar2
954: ,p_attribute2 in varchar2 default hr_api.g_varchar2
955: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 952: ,p_attribute_category in varchar2 default hr_api.g_varchar2

948: ,p_org_link_information27 in varchar2 default hr_api.g_varchar2
949: ,p_org_link_information28 in varchar2 default hr_api.g_varchar2
950: ,p_org_link_information29 in varchar2 default hr_api.g_varchar2
951: ,p_org_link_information30 in varchar2 default hr_api.g_varchar2
952: ,p_attribute_category in varchar2 default hr_api.g_varchar2
953: ,p_attribute1 in varchar2 default hr_api.g_varchar2
954: ,p_attribute2 in varchar2 default hr_api.g_varchar2
955: ,p_attribute3 in varchar2 default hr_api.g_varchar2
956: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 953: ,p_attribute1 in varchar2 default hr_api.g_varchar2

949: ,p_org_link_information28 in varchar2 default hr_api.g_varchar2
950: ,p_org_link_information29 in varchar2 default hr_api.g_varchar2
951: ,p_org_link_information30 in varchar2 default hr_api.g_varchar2
952: ,p_attribute_category in varchar2 default hr_api.g_varchar2
953: ,p_attribute1 in varchar2 default hr_api.g_varchar2
954: ,p_attribute2 in varchar2 default hr_api.g_varchar2
955: ,p_attribute3 in varchar2 default hr_api.g_varchar2
956: ,p_attribute4 in varchar2 default hr_api.g_varchar2
957: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 954: ,p_attribute2 in varchar2 default hr_api.g_varchar2

950: ,p_org_link_information29 in varchar2 default hr_api.g_varchar2
951: ,p_org_link_information30 in varchar2 default hr_api.g_varchar2
952: ,p_attribute_category in varchar2 default hr_api.g_varchar2
953: ,p_attribute1 in varchar2 default hr_api.g_varchar2
954: ,p_attribute2 in varchar2 default hr_api.g_varchar2
955: ,p_attribute3 in varchar2 default hr_api.g_varchar2
956: ,p_attribute4 in varchar2 default hr_api.g_varchar2
957: ,p_attribute5 in varchar2 default hr_api.g_varchar2
958: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 955: ,p_attribute3 in varchar2 default hr_api.g_varchar2

951: ,p_org_link_information30 in varchar2 default hr_api.g_varchar2
952: ,p_attribute_category in varchar2 default hr_api.g_varchar2
953: ,p_attribute1 in varchar2 default hr_api.g_varchar2
954: ,p_attribute2 in varchar2 default hr_api.g_varchar2
955: ,p_attribute3 in varchar2 default hr_api.g_varchar2
956: ,p_attribute4 in varchar2 default hr_api.g_varchar2
957: ,p_attribute5 in varchar2 default hr_api.g_varchar2
958: ,p_attribute6 in varchar2 default hr_api.g_varchar2
959: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 956: ,p_attribute4 in varchar2 default hr_api.g_varchar2

952: ,p_attribute_category in varchar2 default hr_api.g_varchar2
953: ,p_attribute1 in varchar2 default hr_api.g_varchar2
954: ,p_attribute2 in varchar2 default hr_api.g_varchar2
955: ,p_attribute3 in varchar2 default hr_api.g_varchar2
956: ,p_attribute4 in varchar2 default hr_api.g_varchar2
957: ,p_attribute5 in varchar2 default hr_api.g_varchar2
958: ,p_attribute6 in varchar2 default hr_api.g_varchar2
959: ,p_attribute7 in varchar2 default hr_api.g_varchar2
960: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 957: ,p_attribute5 in varchar2 default hr_api.g_varchar2

953: ,p_attribute1 in varchar2 default hr_api.g_varchar2
954: ,p_attribute2 in varchar2 default hr_api.g_varchar2
955: ,p_attribute3 in varchar2 default hr_api.g_varchar2
956: ,p_attribute4 in varchar2 default hr_api.g_varchar2
957: ,p_attribute5 in varchar2 default hr_api.g_varchar2
958: ,p_attribute6 in varchar2 default hr_api.g_varchar2
959: ,p_attribute7 in varchar2 default hr_api.g_varchar2
960: ,p_attribute8 in varchar2 default hr_api.g_varchar2
961: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 958: ,p_attribute6 in varchar2 default hr_api.g_varchar2

954: ,p_attribute2 in varchar2 default hr_api.g_varchar2
955: ,p_attribute3 in varchar2 default hr_api.g_varchar2
956: ,p_attribute4 in varchar2 default hr_api.g_varchar2
957: ,p_attribute5 in varchar2 default hr_api.g_varchar2
958: ,p_attribute6 in varchar2 default hr_api.g_varchar2
959: ,p_attribute7 in varchar2 default hr_api.g_varchar2
960: ,p_attribute8 in varchar2 default hr_api.g_varchar2
961: ,p_attribute9 in varchar2 default hr_api.g_varchar2
962: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 959: ,p_attribute7 in varchar2 default hr_api.g_varchar2

955: ,p_attribute3 in varchar2 default hr_api.g_varchar2
956: ,p_attribute4 in varchar2 default hr_api.g_varchar2
957: ,p_attribute5 in varchar2 default hr_api.g_varchar2
958: ,p_attribute6 in varchar2 default hr_api.g_varchar2
959: ,p_attribute7 in varchar2 default hr_api.g_varchar2
960: ,p_attribute8 in varchar2 default hr_api.g_varchar2
961: ,p_attribute9 in varchar2 default hr_api.g_varchar2
962: ,p_attribute10 in varchar2 default hr_api.g_varchar2
963: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 960: ,p_attribute8 in varchar2 default hr_api.g_varchar2

956: ,p_attribute4 in varchar2 default hr_api.g_varchar2
957: ,p_attribute5 in varchar2 default hr_api.g_varchar2
958: ,p_attribute6 in varchar2 default hr_api.g_varchar2
959: ,p_attribute7 in varchar2 default hr_api.g_varchar2
960: ,p_attribute8 in varchar2 default hr_api.g_varchar2
961: ,p_attribute9 in varchar2 default hr_api.g_varchar2
962: ,p_attribute10 in varchar2 default hr_api.g_varchar2
963: ,p_attribute11 in varchar2 default hr_api.g_varchar2
964: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 961: ,p_attribute9 in varchar2 default hr_api.g_varchar2

957: ,p_attribute5 in varchar2 default hr_api.g_varchar2
958: ,p_attribute6 in varchar2 default hr_api.g_varchar2
959: ,p_attribute7 in varchar2 default hr_api.g_varchar2
960: ,p_attribute8 in varchar2 default hr_api.g_varchar2
961: ,p_attribute9 in varchar2 default hr_api.g_varchar2
962: ,p_attribute10 in varchar2 default hr_api.g_varchar2
963: ,p_attribute11 in varchar2 default hr_api.g_varchar2
964: ,p_attribute12 in varchar2 default hr_api.g_varchar2
965: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 962: ,p_attribute10 in varchar2 default hr_api.g_varchar2

958: ,p_attribute6 in varchar2 default hr_api.g_varchar2
959: ,p_attribute7 in varchar2 default hr_api.g_varchar2
960: ,p_attribute8 in varchar2 default hr_api.g_varchar2
961: ,p_attribute9 in varchar2 default hr_api.g_varchar2
962: ,p_attribute10 in varchar2 default hr_api.g_varchar2
963: ,p_attribute11 in varchar2 default hr_api.g_varchar2
964: ,p_attribute12 in varchar2 default hr_api.g_varchar2
965: ,p_attribute13 in varchar2 default hr_api.g_varchar2
966: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 963: ,p_attribute11 in varchar2 default hr_api.g_varchar2

959: ,p_attribute7 in varchar2 default hr_api.g_varchar2
960: ,p_attribute8 in varchar2 default hr_api.g_varchar2
961: ,p_attribute9 in varchar2 default hr_api.g_varchar2
962: ,p_attribute10 in varchar2 default hr_api.g_varchar2
963: ,p_attribute11 in varchar2 default hr_api.g_varchar2
964: ,p_attribute12 in varchar2 default hr_api.g_varchar2
965: ,p_attribute13 in varchar2 default hr_api.g_varchar2
966: ,p_attribute14 in varchar2 default hr_api.g_varchar2
967: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 964: ,p_attribute12 in varchar2 default hr_api.g_varchar2

960: ,p_attribute8 in varchar2 default hr_api.g_varchar2
961: ,p_attribute9 in varchar2 default hr_api.g_varchar2
962: ,p_attribute10 in varchar2 default hr_api.g_varchar2
963: ,p_attribute11 in varchar2 default hr_api.g_varchar2
964: ,p_attribute12 in varchar2 default hr_api.g_varchar2
965: ,p_attribute13 in varchar2 default hr_api.g_varchar2
966: ,p_attribute14 in varchar2 default hr_api.g_varchar2
967: ,p_attribute15 in varchar2 default hr_api.g_varchar2
968: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 965: ,p_attribute13 in varchar2 default hr_api.g_varchar2

961: ,p_attribute9 in varchar2 default hr_api.g_varchar2
962: ,p_attribute10 in varchar2 default hr_api.g_varchar2
963: ,p_attribute11 in varchar2 default hr_api.g_varchar2
964: ,p_attribute12 in varchar2 default hr_api.g_varchar2
965: ,p_attribute13 in varchar2 default hr_api.g_varchar2
966: ,p_attribute14 in varchar2 default hr_api.g_varchar2
967: ,p_attribute15 in varchar2 default hr_api.g_varchar2
968: ,p_attribute16 in varchar2 default hr_api.g_varchar2
969: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 966: ,p_attribute14 in varchar2 default hr_api.g_varchar2

962: ,p_attribute10 in varchar2 default hr_api.g_varchar2
963: ,p_attribute11 in varchar2 default hr_api.g_varchar2
964: ,p_attribute12 in varchar2 default hr_api.g_varchar2
965: ,p_attribute13 in varchar2 default hr_api.g_varchar2
966: ,p_attribute14 in varchar2 default hr_api.g_varchar2
967: ,p_attribute15 in varchar2 default hr_api.g_varchar2
968: ,p_attribute16 in varchar2 default hr_api.g_varchar2
969: ,p_attribute17 in varchar2 default hr_api.g_varchar2
970: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 967: ,p_attribute15 in varchar2 default hr_api.g_varchar2

963: ,p_attribute11 in varchar2 default hr_api.g_varchar2
964: ,p_attribute12 in varchar2 default hr_api.g_varchar2
965: ,p_attribute13 in varchar2 default hr_api.g_varchar2
966: ,p_attribute14 in varchar2 default hr_api.g_varchar2
967: ,p_attribute15 in varchar2 default hr_api.g_varchar2
968: ,p_attribute16 in varchar2 default hr_api.g_varchar2
969: ,p_attribute17 in varchar2 default hr_api.g_varchar2
970: ,p_attribute18 in varchar2 default hr_api.g_varchar2
971: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 968: ,p_attribute16 in varchar2 default hr_api.g_varchar2

964: ,p_attribute12 in varchar2 default hr_api.g_varchar2
965: ,p_attribute13 in varchar2 default hr_api.g_varchar2
966: ,p_attribute14 in varchar2 default hr_api.g_varchar2
967: ,p_attribute15 in varchar2 default hr_api.g_varchar2
968: ,p_attribute16 in varchar2 default hr_api.g_varchar2
969: ,p_attribute17 in varchar2 default hr_api.g_varchar2
970: ,p_attribute18 in varchar2 default hr_api.g_varchar2
971: ,p_attribute19 in varchar2 default hr_api.g_varchar2
972: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 969: ,p_attribute17 in varchar2 default hr_api.g_varchar2

965: ,p_attribute13 in varchar2 default hr_api.g_varchar2
966: ,p_attribute14 in varchar2 default hr_api.g_varchar2
967: ,p_attribute15 in varchar2 default hr_api.g_varchar2
968: ,p_attribute16 in varchar2 default hr_api.g_varchar2
969: ,p_attribute17 in varchar2 default hr_api.g_varchar2
970: ,p_attribute18 in varchar2 default hr_api.g_varchar2
971: ,p_attribute19 in varchar2 default hr_api.g_varchar2
972: ,p_attribute20 in varchar2 default hr_api.g_varchar2
973: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 970: ,p_attribute18 in varchar2 default hr_api.g_varchar2

966: ,p_attribute14 in varchar2 default hr_api.g_varchar2
967: ,p_attribute15 in varchar2 default hr_api.g_varchar2
968: ,p_attribute16 in varchar2 default hr_api.g_varchar2
969: ,p_attribute17 in varchar2 default hr_api.g_varchar2
970: ,p_attribute18 in varchar2 default hr_api.g_varchar2
971: ,p_attribute19 in varchar2 default hr_api.g_varchar2
972: ,p_attribute20 in varchar2 default hr_api.g_varchar2
973: ,p_attribute21 in varchar2 default hr_api.g_varchar2
974: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 971: ,p_attribute19 in varchar2 default hr_api.g_varchar2

967: ,p_attribute15 in varchar2 default hr_api.g_varchar2
968: ,p_attribute16 in varchar2 default hr_api.g_varchar2
969: ,p_attribute17 in varchar2 default hr_api.g_varchar2
970: ,p_attribute18 in varchar2 default hr_api.g_varchar2
971: ,p_attribute19 in varchar2 default hr_api.g_varchar2
972: ,p_attribute20 in varchar2 default hr_api.g_varchar2
973: ,p_attribute21 in varchar2 default hr_api.g_varchar2
974: ,p_attribute22 in varchar2 default hr_api.g_varchar2
975: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 972: ,p_attribute20 in varchar2 default hr_api.g_varchar2

968: ,p_attribute16 in varchar2 default hr_api.g_varchar2
969: ,p_attribute17 in varchar2 default hr_api.g_varchar2
970: ,p_attribute18 in varchar2 default hr_api.g_varchar2
971: ,p_attribute19 in varchar2 default hr_api.g_varchar2
972: ,p_attribute20 in varchar2 default hr_api.g_varchar2
973: ,p_attribute21 in varchar2 default hr_api.g_varchar2
974: ,p_attribute22 in varchar2 default hr_api.g_varchar2
975: ,p_attribute23 in varchar2 default hr_api.g_varchar2
976: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 973: ,p_attribute21 in varchar2 default hr_api.g_varchar2

969: ,p_attribute17 in varchar2 default hr_api.g_varchar2
970: ,p_attribute18 in varchar2 default hr_api.g_varchar2
971: ,p_attribute19 in varchar2 default hr_api.g_varchar2
972: ,p_attribute20 in varchar2 default hr_api.g_varchar2
973: ,p_attribute21 in varchar2 default hr_api.g_varchar2
974: ,p_attribute22 in varchar2 default hr_api.g_varchar2
975: ,p_attribute23 in varchar2 default hr_api.g_varchar2
976: ,p_attribute24 in varchar2 default hr_api.g_varchar2
977: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 974: ,p_attribute22 in varchar2 default hr_api.g_varchar2

970: ,p_attribute18 in varchar2 default hr_api.g_varchar2
971: ,p_attribute19 in varchar2 default hr_api.g_varchar2
972: ,p_attribute20 in varchar2 default hr_api.g_varchar2
973: ,p_attribute21 in varchar2 default hr_api.g_varchar2
974: ,p_attribute22 in varchar2 default hr_api.g_varchar2
975: ,p_attribute23 in varchar2 default hr_api.g_varchar2
976: ,p_attribute24 in varchar2 default hr_api.g_varchar2
977: ,p_attribute25 in varchar2 default hr_api.g_varchar2
978: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 975: ,p_attribute23 in varchar2 default hr_api.g_varchar2

971: ,p_attribute19 in varchar2 default hr_api.g_varchar2
972: ,p_attribute20 in varchar2 default hr_api.g_varchar2
973: ,p_attribute21 in varchar2 default hr_api.g_varchar2
974: ,p_attribute22 in varchar2 default hr_api.g_varchar2
975: ,p_attribute23 in varchar2 default hr_api.g_varchar2
976: ,p_attribute24 in varchar2 default hr_api.g_varchar2
977: ,p_attribute25 in varchar2 default hr_api.g_varchar2
978: ,p_attribute26 in varchar2 default hr_api.g_varchar2
979: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 976: ,p_attribute24 in varchar2 default hr_api.g_varchar2

972: ,p_attribute20 in varchar2 default hr_api.g_varchar2
973: ,p_attribute21 in varchar2 default hr_api.g_varchar2
974: ,p_attribute22 in varchar2 default hr_api.g_varchar2
975: ,p_attribute23 in varchar2 default hr_api.g_varchar2
976: ,p_attribute24 in varchar2 default hr_api.g_varchar2
977: ,p_attribute25 in varchar2 default hr_api.g_varchar2
978: ,p_attribute26 in varchar2 default hr_api.g_varchar2
979: ,p_attribute27 in varchar2 default hr_api.g_varchar2
980: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 977: ,p_attribute25 in varchar2 default hr_api.g_varchar2

973: ,p_attribute21 in varchar2 default hr_api.g_varchar2
974: ,p_attribute22 in varchar2 default hr_api.g_varchar2
975: ,p_attribute23 in varchar2 default hr_api.g_varchar2
976: ,p_attribute24 in varchar2 default hr_api.g_varchar2
977: ,p_attribute25 in varchar2 default hr_api.g_varchar2
978: ,p_attribute26 in varchar2 default hr_api.g_varchar2
979: ,p_attribute27 in varchar2 default hr_api.g_varchar2
980: ,p_attribute28 in varchar2 default hr_api.g_varchar2
981: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 978: ,p_attribute26 in varchar2 default hr_api.g_varchar2

974: ,p_attribute22 in varchar2 default hr_api.g_varchar2
975: ,p_attribute23 in varchar2 default hr_api.g_varchar2
976: ,p_attribute24 in varchar2 default hr_api.g_varchar2
977: ,p_attribute25 in varchar2 default hr_api.g_varchar2
978: ,p_attribute26 in varchar2 default hr_api.g_varchar2
979: ,p_attribute27 in varchar2 default hr_api.g_varchar2
980: ,p_attribute28 in varchar2 default hr_api.g_varchar2
981: ,p_attribute29 in varchar2 default hr_api.g_varchar2
982: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 979: ,p_attribute27 in varchar2 default hr_api.g_varchar2

975: ,p_attribute23 in varchar2 default hr_api.g_varchar2
976: ,p_attribute24 in varchar2 default hr_api.g_varchar2
977: ,p_attribute25 in varchar2 default hr_api.g_varchar2
978: ,p_attribute26 in varchar2 default hr_api.g_varchar2
979: ,p_attribute27 in varchar2 default hr_api.g_varchar2
980: ,p_attribute28 in varchar2 default hr_api.g_varchar2
981: ,p_attribute29 in varchar2 default hr_api.g_varchar2
982: ,p_attribute30 in varchar2 default hr_api.g_varchar2
983: ) is

Line 980: ,p_attribute28 in varchar2 default hr_api.g_varchar2

976: ,p_attribute24 in varchar2 default hr_api.g_varchar2
977: ,p_attribute25 in varchar2 default hr_api.g_varchar2
978: ,p_attribute26 in varchar2 default hr_api.g_varchar2
979: ,p_attribute27 in varchar2 default hr_api.g_varchar2
980: ,p_attribute28 in varchar2 default hr_api.g_varchar2
981: ,p_attribute29 in varchar2 default hr_api.g_varchar2
982: ,p_attribute30 in varchar2 default hr_api.g_varchar2
983: ) is
984: --

Line 981: ,p_attribute29 in varchar2 default hr_api.g_varchar2

977: ,p_attribute25 in varchar2 default hr_api.g_varchar2
978: ,p_attribute26 in varchar2 default hr_api.g_varchar2
979: ,p_attribute27 in varchar2 default hr_api.g_varchar2
980: ,p_attribute28 in varchar2 default hr_api.g_varchar2
981: ,p_attribute29 in varchar2 default hr_api.g_varchar2
982: ,p_attribute30 in varchar2 default hr_api.g_varchar2
983: ) is
984: --
985: l_rec hr_ord_shd.g_rec_type;

Line 982: ,p_attribute30 in varchar2 default hr_api.g_varchar2

978: ,p_attribute26 in varchar2 default hr_api.g_varchar2
979: ,p_attribute27 in varchar2 default hr_api.g_varchar2
980: ,p_attribute28 in varchar2 default hr_api.g_varchar2
981: ,p_attribute29 in varchar2 default hr_api.g_varchar2
982: ,p_attribute30 in varchar2 default hr_api.g_varchar2
983: ) is
984: --
985: l_rec hr_ord_shd.g_rec_type;
986: l_proc varchar2(72) := g_package||'upd';