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.PQH_LOS_UPD dependencies on HR_API

Line 153: When hr_api.check_integrity_violated Then

149: --
150: hr_utility.set_location(' Leaving:'||l_proc, 10);
151: --
152: Exception
153: When hr_api.check_integrity_violated Then
154: -- A check constraint has been violated
155: --
156: pqh_los_shd.constraint_error
157: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

153: When hr_api.check_integrity_violated Then
154: -- A check constraint has been violated
155: --
156: pqh_los_shd.constraint_error
157: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
158: When hr_api.parent_integrity_violated Then
159: -- Parent integrity has been violated
160: --
161: pqh_los_shd.constraint_error

Line 158: When hr_api.parent_integrity_violated Then

154: -- A check constraint has been violated
155: --
156: pqh_los_shd.constraint_error
157: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
158: When hr_api.parent_integrity_violated Then
159: -- Parent integrity has been violated
160: --
161: pqh_los_shd.constraint_error
162: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

158: When hr_api.parent_integrity_violated Then
159: -- Parent integrity has been violated
160: --
161: pqh_los_shd.constraint_error
162: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
163: When hr_api.unique_integrity_violated Then
164: -- Unique integrity has been violated
165: --
166: pqh_los_shd.constraint_error

Line 163: When hr_api.unique_integrity_violated Then

159: -- Parent integrity has been violated
160: --
161: pqh_los_shd.constraint_error
162: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
163: When hr_api.unique_integrity_violated Then
164: -- Unique integrity has been violated
165: --
166: pqh_los_shd.constraint_error
167: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

163: When hr_api.unique_integrity_violated Then
164: -- Unique integrity has been violated
165: --
166: pqh_los_shd.constraint_error
167: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
168: When Others Then
169: --
170: Raise;
171: End update_dml;

Line 560: when hr_api.cannot_find_prog_unit then

556: );
557: --
558: exception
559: --
560: when hr_api.cannot_find_prog_unit then
561: --
562: hr_api.cannot_find_prog_unit_error
563: (p_module_name => 'PQH_SITUATIONS'
564: ,p_hook_type => 'AU');

Line 562: hr_api.cannot_find_prog_unit_error

558: exception
559: --
560: when hr_api.cannot_find_prog_unit then
561: --
562: hr_api.cannot_find_prog_unit_error
563: (p_module_name => 'PQH_SITUATIONS'
564: ,p_hook_type => 'AU');
565: --
566: end;

Line 625: If (p_rec.situation = hr_api.g_varchar2) then

621: -- p_rec plsql record structure
622: -- to see if a system default is being used. If a system default
623: -- is being used then we must set to the 'current' argument value.
624: --
625: If (p_rec.situation = hr_api.g_varchar2) then
626: p_rec.situation :=
627: pqh_los_shd.g_old_rec.situation;
628: End If;
629: If (p_rec.effective_start_date = hr_api.g_date) then

Line 629: If (p_rec.effective_start_date = hr_api.g_date) then

625: If (p_rec.situation = hr_api.g_varchar2) then
626: p_rec.situation :=
627: pqh_los_shd.g_old_rec.situation;
628: End If;
629: If (p_rec.effective_start_date = hr_api.g_date) then
630: p_rec.effective_start_date :=
631: pqh_los_shd.g_old_rec.effective_start_date;
632: End If;
633: If (p_rec.effective_end_date = hr_api.g_date) then

Line 633: If (p_rec.effective_end_date = hr_api.g_date) then

629: If (p_rec.effective_start_date = hr_api.g_date) then
630: p_rec.effective_start_date :=
631: pqh_los_shd.g_old_rec.effective_start_date;
632: End If;
633: If (p_rec.effective_end_date = hr_api.g_date) then
634: p_rec.effective_end_date :=
635: pqh_los_shd.g_old_rec.effective_end_date;
636: End If;
637: If (p_rec.business_group_id = hr_api.g_number) then

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

633: If (p_rec.effective_end_date = hr_api.g_date) then
634: p_rec.effective_end_date :=
635: pqh_los_shd.g_old_rec.effective_end_date;
636: End If;
637: If (p_rec.business_group_id = hr_api.g_number) then
638: p_rec.business_group_id :=
639: pqh_los_shd.g_old_rec.business_group_id;
640: End If;
641: If (p_rec.situation_type = hr_api.g_varchar2) then

Line 641: If (p_rec.situation_type = hr_api.g_varchar2) then

637: If (p_rec.business_group_id = hr_api.g_number) then
638: p_rec.business_group_id :=
639: pqh_los_shd.g_old_rec.business_group_id;
640: End If;
641: If (p_rec.situation_type = hr_api.g_varchar2) then
642: p_rec.situation_type :=
643: pqh_los_shd.g_old_rec.situation_type;
644: End If;
645: If (p_rec.length_of_service = hr_api.g_varchar2) then

Line 645: If (p_rec.length_of_service = hr_api.g_varchar2) then

641: If (p_rec.situation_type = hr_api.g_varchar2) then
642: p_rec.situation_type :=
643: pqh_los_shd.g_old_rec.situation_type;
644: End If;
645: If (p_rec.length_of_service = hr_api.g_varchar2) then
646: p_rec.length_of_service :=
647: pqh_los_shd.g_old_rec.length_of_service;
648: End If;
649: If (p_rec.employee_type = hr_api.g_varchar2) then

Line 649: If (p_rec.employee_type = hr_api.g_varchar2) then

645: If (p_rec.length_of_service = hr_api.g_varchar2) then
646: p_rec.length_of_service :=
647: pqh_los_shd.g_old_rec.length_of_service;
648: End If;
649: If (p_rec.employee_type = hr_api.g_varchar2) then
650: p_rec.employee_type :=
651: pqh_los_shd.g_old_rec.employee_type;
652: End If;
653: If (p_rec.entitlement_flag = hr_api.g_varchar2) then

Line 653: If (p_rec.entitlement_flag = hr_api.g_varchar2) then

649: If (p_rec.employee_type = hr_api.g_varchar2) then
650: p_rec.employee_type :=
651: pqh_los_shd.g_old_rec.employee_type;
652: End If;
653: If (p_rec.entitlement_flag = hr_api.g_varchar2) then
654: p_rec.entitlement_flag :=
655: pqh_los_shd.g_old_rec.entitlement_flag;
656: End If;
657: If (p_rec.worktime_proportional = hr_api.g_varchar2) then

Line 657: If (p_rec.worktime_proportional = hr_api.g_varchar2) then

653: If (p_rec.entitlement_flag = hr_api.g_varchar2) then
654: p_rec.entitlement_flag :=
655: pqh_los_shd.g_old_rec.entitlement_flag;
656: End If;
657: If (p_rec.worktime_proportional = hr_api.g_varchar2) then
658: p_rec.worktime_proportional :=
659: pqh_los_shd.g_old_rec.worktime_proportional;
660: End If;
661: If (p_rec.entitlement_value = hr_api.g_number) then

Line 661: If (p_rec.entitlement_value = hr_api.g_number) then

657: If (p_rec.worktime_proportional = hr_api.g_varchar2) then
658: p_rec.worktime_proportional :=
659: pqh_los_shd.g_old_rec.worktime_proportional;
660: End If;
661: If (p_rec.entitlement_value = hr_api.g_number) then
662: p_rec.entitlement_value :=
663: pqh_los_shd.g_old_rec.entitlement_value;
664: End If;
665: If (p_rec.information_category = hr_api.g_varchar2) then

Line 665: If (p_rec.information_category = hr_api.g_varchar2) then

661: If (p_rec.entitlement_value = hr_api.g_number) then
662: p_rec.entitlement_value :=
663: pqh_los_shd.g_old_rec.entitlement_value;
664: End If;
665: If (p_rec.information_category = hr_api.g_varchar2) then
666: p_rec.information_category :=
667: pqh_los_shd.g_old_rec.information_category;
668: End If;
669: If (p_rec.information1 = hr_api.g_varchar2) then

Line 669: If (p_rec.information1 = hr_api.g_varchar2) then

665: If (p_rec.information_category = hr_api.g_varchar2) then
666: p_rec.information_category :=
667: pqh_los_shd.g_old_rec.information_category;
668: End If;
669: If (p_rec.information1 = hr_api.g_varchar2) then
670: p_rec.information1 :=
671: pqh_los_shd.g_old_rec.information1;
672: End If;
673: If (p_rec.information2 = hr_api.g_varchar2) then

Line 673: If (p_rec.information2 = hr_api.g_varchar2) then

669: If (p_rec.information1 = hr_api.g_varchar2) then
670: p_rec.information1 :=
671: pqh_los_shd.g_old_rec.information1;
672: End If;
673: If (p_rec.information2 = hr_api.g_varchar2) then
674: p_rec.information2 :=
675: pqh_los_shd.g_old_rec.information2;
676: End If;
677: If (p_rec.information3 = hr_api.g_varchar2) then

Line 677: If (p_rec.information3 = hr_api.g_varchar2) then

673: If (p_rec.information2 = hr_api.g_varchar2) then
674: p_rec.information2 :=
675: pqh_los_shd.g_old_rec.information2;
676: End If;
677: If (p_rec.information3 = hr_api.g_varchar2) then
678: p_rec.information3 :=
679: pqh_los_shd.g_old_rec.information3;
680: End If;
681: If (p_rec.information4 = hr_api.g_varchar2) then

Line 681: If (p_rec.information4 = hr_api.g_varchar2) then

677: If (p_rec.information3 = hr_api.g_varchar2) then
678: p_rec.information3 :=
679: pqh_los_shd.g_old_rec.information3;
680: End If;
681: If (p_rec.information4 = hr_api.g_varchar2) then
682: p_rec.information4 :=
683: pqh_los_shd.g_old_rec.information4;
684: End If;
685: If (p_rec.information5 = hr_api.g_varchar2) then

Line 685: If (p_rec.information5 = hr_api.g_varchar2) then

681: If (p_rec.information4 = hr_api.g_varchar2) then
682: p_rec.information4 :=
683: pqh_los_shd.g_old_rec.information4;
684: End If;
685: If (p_rec.information5 = hr_api.g_varchar2) then
686: p_rec.information5 :=
687: pqh_los_shd.g_old_rec.information5;
688: End If;
689: If (p_rec.information6 = hr_api.g_varchar2) then

Line 689: If (p_rec.information6 = hr_api.g_varchar2) then

685: If (p_rec.information5 = hr_api.g_varchar2) then
686: p_rec.information5 :=
687: pqh_los_shd.g_old_rec.information5;
688: End If;
689: If (p_rec.information6 = hr_api.g_varchar2) then
690: p_rec.information6 :=
691: pqh_los_shd.g_old_rec.information6;
692: End If;
693: If (p_rec.information7 = hr_api.g_varchar2) then

Line 693: If (p_rec.information7 = hr_api.g_varchar2) then

689: If (p_rec.information6 = hr_api.g_varchar2) then
690: p_rec.information6 :=
691: pqh_los_shd.g_old_rec.information6;
692: End If;
693: If (p_rec.information7 = hr_api.g_varchar2) then
694: p_rec.information7 :=
695: pqh_los_shd.g_old_rec.information7;
696: End If;
697: If (p_rec.information8 = hr_api.g_varchar2) then

Line 697: If (p_rec.information8 = hr_api.g_varchar2) then

693: If (p_rec.information7 = hr_api.g_varchar2) then
694: p_rec.information7 :=
695: pqh_los_shd.g_old_rec.information7;
696: End If;
697: If (p_rec.information8 = hr_api.g_varchar2) then
698: p_rec.information8 :=
699: pqh_los_shd.g_old_rec.information8;
700: End If;
701: If (p_rec.information9 = hr_api.g_varchar2) then

Line 701: If (p_rec.information9 = hr_api.g_varchar2) then

697: If (p_rec.information8 = hr_api.g_varchar2) then
698: p_rec.information8 :=
699: pqh_los_shd.g_old_rec.information8;
700: End If;
701: If (p_rec.information9 = hr_api.g_varchar2) then
702: p_rec.information9 :=
703: pqh_los_shd.g_old_rec.information9;
704: End If;
705: If (p_rec.information10 = hr_api.g_varchar2) then

Line 705: If (p_rec.information10 = hr_api.g_varchar2) then

701: If (p_rec.information9 = hr_api.g_varchar2) then
702: p_rec.information9 :=
703: pqh_los_shd.g_old_rec.information9;
704: End If;
705: If (p_rec.information10 = hr_api.g_varchar2) then
706: p_rec.information10 :=
707: pqh_los_shd.g_old_rec.information10;
708: End If;
709: If (p_rec.information11 = hr_api.g_varchar2) then

Line 709: If (p_rec.information11 = hr_api.g_varchar2) then

705: If (p_rec.information10 = hr_api.g_varchar2) then
706: p_rec.information10 :=
707: pqh_los_shd.g_old_rec.information10;
708: End If;
709: If (p_rec.information11 = hr_api.g_varchar2) then
710: p_rec.information11 :=
711: pqh_los_shd.g_old_rec.information11;
712: End If;
713: If (p_rec.information12 = hr_api.g_varchar2) then

Line 713: If (p_rec.information12 = hr_api.g_varchar2) then

709: If (p_rec.information11 = hr_api.g_varchar2) then
710: p_rec.information11 :=
711: pqh_los_shd.g_old_rec.information11;
712: End If;
713: If (p_rec.information12 = hr_api.g_varchar2) then
714: p_rec.information12 :=
715: pqh_los_shd.g_old_rec.information12;
716: End If;
717: If (p_rec.information13 = hr_api.g_varchar2) then

Line 717: If (p_rec.information13 = hr_api.g_varchar2) then

713: If (p_rec.information12 = hr_api.g_varchar2) then
714: p_rec.information12 :=
715: pqh_los_shd.g_old_rec.information12;
716: End If;
717: If (p_rec.information13 = hr_api.g_varchar2) then
718: p_rec.information13 :=
719: pqh_los_shd.g_old_rec.information13;
720: End If;
721: If (p_rec.information14 = hr_api.g_varchar2) then

Line 721: If (p_rec.information14 = hr_api.g_varchar2) then

717: If (p_rec.information13 = hr_api.g_varchar2) then
718: p_rec.information13 :=
719: pqh_los_shd.g_old_rec.information13;
720: End If;
721: If (p_rec.information14 = hr_api.g_varchar2) then
722: p_rec.information14 :=
723: pqh_los_shd.g_old_rec.information14;
724: End If;
725: If (p_rec.information15 = hr_api.g_varchar2) then

Line 725: If (p_rec.information15 = hr_api.g_varchar2) then

721: If (p_rec.information14 = hr_api.g_varchar2) then
722: p_rec.information14 :=
723: pqh_los_shd.g_old_rec.information14;
724: End If;
725: If (p_rec.information15 = hr_api.g_varchar2) then
726: p_rec.information15 :=
727: pqh_los_shd.g_old_rec.information15;
728: End If;
729: If (p_rec.information16 = hr_api.g_varchar2) then

Line 729: If (p_rec.information16 = hr_api.g_varchar2) then

725: If (p_rec.information15 = hr_api.g_varchar2) then
726: p_rec.information15 :=
727: pqh_los_shd.g_old_rec.information15;
728: End If;
729: If (p_rec.information16 = hr_api.g_varchar2) then
730: p_rec.information16 :=
731: pqh_los_shd.g_old_rec.information16;
732: End If;
733: If (p_rec.information17 = hr_api.g_varchar2) then

Line 733: If (p_rec.information17 = hr_api.g_varchar2) then

729: If (p_rec.information16 = hr_api.g_varchar2) then
730: p_rec.information16 :=
731: pqh_los_shd.g_old_rec.information16;
732: End If;
733: If (p_rec.information17 = hr_api.g_varchar2) then
734: p_rec.information17 :=
735: pqh_los_shd.g_old_rec.information17;
736: End If;
737: If (p_rec.information18 = hr_api.g_varchar2) then

Line 737: If (p_rec.information18 = hr_api.g_varchar2) then

733: If (p_rec.information17 = hr_api.g_varchar2) then
734: p_rec.information17 :=
735: pqh_los_shd.g_old_rec.information17;
736: End If;
737: If (p_rec.information18 = hr_api.g_varchar2) then
738: p_rec.information18 :=
739: pqh_los_shd.g_old_rec.information18;
740: End If;
741: If (p_rec.information19 = hr_api.g_varchar2) then

Line 741: If (p_rec.information19 = hr_api.g_varchar2) then

737: If (p_rec.information18 = hr_api.g_varchar2) then
738: p_rec.information18 :=
739: pqh_los_shd.g_old_rec.information18;
740: End If;
741: If (p_rec.information19 = hr_api.g_varchar2) then
742: p_rec.information19 :=
743: pqh_los_shd.g_old_rec.information19;
744: End If;
745: If (p_rec.information20 = hr_api.g_varchar2) then

Line 745: If (p_rec.information20 = hr_api.g_varchar2) then

741: If (p_rec.information19 = hr_api.g_varchar2) then
742: p_rec.information19 :=
743: pqh_los_shd.g_old_rec.information19;
744: End If;
745: If (p_rec.information20 = hr_api.g_varchar2) then
746: p_rec.information20 :=
747: pqh_los_shd.g_old_rec.information20;
748: End If;
749: If (p_rec.information21 = hr_api.g_varchar2) then

Line 749: If (p_rec.information21 = hr_api.g_varchar2) then

745: If (p_rec.information20 = hr_api.g_varchar2) then
746: p_rec.information20 :=
747: pqh_los_shd.g_old_rec.information20;
748: End If;
749: If (p_rec.information21 = hr_api.g_varchar2) then
750: p_rec.information21 :=
751: pqh_los_shd.g_old_rec.information21;
752: End If;
753: If (p_rec.information22 = hr_api.g_varchar2) then

Line 753: If (p_rec.information22 = hr_api.g_varchar2) then

749: If (p_rec.information21 = hr_api.g_varchar2) then
750: p_rec.information21 :=
751: pqh_los_shd.g_old_rec.information21;
752: End If;
753: If (p_rec.information22 = hr_api.g_varchar2) then
754: p_rec.information22 :=
755: pqh_los_shd.g_old_rec.information22;
756: End If;
757: If (p_rec.information23 = hr_api.g_varchar2) then

Line 757: If (p_rec.information23 = hr_api.g_varchar2) then

753: If (p_rec.information22 = hr_api.g_varchar2) then
754: p_rec.information22 :=
755: pqh_los_shd.g_old_rec.information22;
756: End If;
757: If (p_rec.information23 = hr_api.g_varchar2) then
758: p_rec.information23 :=
759: pqh_los_shd.g_old_rec.information23;
760: End If;
761: If (p_rec.information24 = hr_api.g_varchar2) then

Line 761: If (p_rec.information24 = hr_api.g_varchar2) then

757: If (p_rec.information23 = hr_api.g_varchar2) then
758: p_rec.information23 :=
759: pqh_los_shd.g_old_rec.information23;
760: End If;
761: If (p_rec.information24 = hr_api.g_varchar2) then
762: p_rec.information24 :=
763: pqh_los_shd.g_old_rec.information24;
764: End If;
765: If (p_rec.information25 = hr_api.g_varchar2) then

Line 765: If (p_rec.information25 = hr_api.g_varchar2) then

761: If (p_rec.information24 = hr_api.g_varchar2) then
762: p_rec.information24 :=
763: pqh_los_shd.g_old_rec.information24;
764: End If;
765: If (p_rec.information25 = hr_api.g_varchar2) then
766: p_rec.information25 :=
767: pqh_los_shd.g_old_rec.information25;
768: End If;
769: If (p_rec.information26 = hr_api.g_varchar2) then

Line 769: If (p_rec.information26 = hr_api.g_varchar2) then

765: If (p_rec.information25 = hr_api.g_varchar2) then
766: p_rec.information25 :=
767: pqh_los_shd.g_old_rec.information25;
768: End If;
769: If (p_rec.information26 = hr_api.g_varchar2) then
770: p_rec.information26 :=
771: pqh_los_shd.g_old_rec.information26;
772: End If;
773: If (p_rec.information27 = hr_api.g_varchar2) then

Line 773: If (p_rec.information27 = hr_api.g_varchar2) then

769: If (p_rec.information26 = hr_api.g_varchar2) then
770: p_rec.information26 :=
771: pqh_los_shd.g_old_rec.information26;
772: End If;
773: If (p_rec.information27 = hr_api.g_varchar2) then
774: p_rec.information27 :=
775: pqh_los_shd.g_old_rec.information27;
776: End If;
777: If (p_rec.information28 = hr_api.g_varchar2) then

Line 777: If (p_rec.information28 = hr_api.g_varchar2) then

773: If (p_rec.information27 = hr_api.g_varchar2) then
774: p_rec.information27 :=
775: pqh_los_shd.g_old_rec.information27;
776: End If;
777: If (p_rec.information28 = hr_api.g_varchar2) then
778: p_rec.information28 :=
779: pqh_los_shd.g_old_rec.information28;
780: End If;
781: If (p_rec.information29 = hr_api.g_varchar2) then

Line 781: If (p_rec.information29 = hr_api.g_varchar2) then

777: If (p_rec.information28 = hr_api.g_varchar2) then
778: p_rec.information28 :=
779: pqh_los_shd.g_old_rec.information28;
780: End If;
781: If (p_rec.information29 = hr_api.g_varchar2) then
782: p_rec.information29 :=
783: pqh_los_shd.g_old_rec.information29;
784: End If;
785: If (p_rec.information30 = hr_api.g_varchar2) then

Line 785: If (p_rec.information30 = hr_api.g_varchar2) then

781: If (p_rec.information29 = hr_api.g_varchar2) then
782: p_rec.information29 :=
783: pqh_los_shd.g_old_rec.information29;
784: End If;
785: If (p_rec.information30 = hr_api.g_varchar2) then
786: p_rec.information30 :=
787: pqh_los_shd.g_old_rec.information30;
788: End If;
789: If (p_rec.attribute_category = hr_api.g_varchar2) then

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

785: If (p_rec.information30 = hr_api.g_varchar2) then
786: p_rec.information30 :=
787: pqh_los_shd.g_old_rec.information30;
788: End If;
789: If (p_rec.attribute_category = hr_api.g_varchar2) then
790: p_rec.attribute_category :=
791: pqh_los_shd.g_old_rec.attribute_category;
792: End If;
793: If (p_rec.attribute1 = hr_api.g_varchar2) then

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

789: If (p_rec.attribute_category = hr_api.g_varchar2) then
790: p_rec.attribute_category :=
791: pqh_los_shd.g_old_rec.attribute_category;
792: End If;
793: If (p_rec.attribute1 = hr_api.g_varchar2) then
794: p_rec.attribute1 :=
795: pqh_los_shd.g_old_rec.attribute1;
796: End If;
797: If (p_rec.attribute2 = hr_api.g_varchar2) then

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

793: If (p_rec.attribute1 = hr_api.g_varchar2) then
794: p_rec.attribute1 :=
795: pqh_los_shd.g_old_rec.attribute1;
796: End If;
797: If (p_rec.attribute2 = hr_api.g_varchar2) then
798: p_rec.attribute2 :=
799: pqh_los_shd.g_old_rec.attribute2;
800: End If;
801: If (p_rec.attribute3 = hr_api.g_varchar2) then

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

797: If (p_rec.attribute2 = hr_api.g_varchar2) then
798: p_rec.attribute2 :=
799: pqh_los_shd.g_old_rec.attribute2;
800: End If;
801: If (p_rec.attribute3 = hr_api.g_varchar2) then
802: p_rec.attribute3 :=
803: pqh_los_shd.g_old_rec.attribute3;
804: End If;
805: If (p_rec.attribute4 = hr_api.g_varchar2) then

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

801: If (p_rec.attribute3 = hr_api.g_varchar2) then
802: p_rec.attribute3 :=
803: pqh_los_shd.g_old_rec.attribute3;
804: End If;
805: If (p_rec.attribute4 = hr_api.g_varchar2) then
806: p_rec.attribute4 :=
807: pqh_los_shd.g_old_rec.attribute4;
808: End If;
809: If (p_rec.attribute5 = hr_api.g_varchar2) then

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

805: If (p_rec.attribute4 = hr_api.g_varchar2) then
806: p_rec.attribute4 :=
807: pqh_los_shd.g_old_rec.attribute4;
808: End If;
809: If (p_rec.attribute5 = hr_api.g_varchar2) then
810: p_rec.attribute5 :=
811: pqh_los_shd.g_old_rec.attribute5;
812: End If;
813: If (p_rec.attribute6 = hr_api.g_varchar2) then

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

809: If (p_rec.attribute5 = hr_api.g_varchar2) then
810: p_rec.attribute5 :=
811: pqh_los_shd.g_old_rec.attribute5;
812: End If;
813: If (p_rec.attribute6 = hr_api.g_varchar2) then
814: p_rec.attribute6 :=
815: pqh_los_shd.g_old_rec.attribute6;
816: End If;
817: If (p_rec.attribute7 = hr_api.g_varchar2) then

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

813: If (p_rec.attribute6 = hr_api.g_varchar2) then
814: p_rec.attribute6 :=
815: pqh_los_shd.g_old_rec.attribute6;
816: End If;
817: If (p_rec.attribute7 = hr_api.g_varchar2) then
818: p_rec.attribute7 :=
819: pqh_los_shd.g_old_rec.attribute7;
820: End If;
821: If (p_rec.attribute8 = hr_api.g_varchar2) then

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

817: If (p_rec.attribute7 = hr_api.g_varchar2) then
818: p_rec.attribute7 :=
819: pqh_los_shd.g_old_rec.attribute7;
820: End If;
821: If (p_rec.attribute8 = hr_api.g_varchar2) then
822: p_rec.attribute8 :=
823: pqh_los_shd.g_old_rec.attribute8;
824: End If;
825: If (p_rec.attribute9 = hr_api.g_varchar2) then

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

821: If (p_rec.attribute8 = hr_api.g_varchar2) then
822: p_rec.attribute8 :=
823: pqh_los_shd.g_old_rec.attribute8;
824: End If;
825: If (p_rec.attribute9 = hr_api.g_varchar2) then
826: p_rec.attribute9 :=
827: pqh_los_shd.g_old_rec.attribute9;
828: End If;
829: If (p_rec.attribute10 = hr_api.g_varchar2) then

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

825: If (p_rec.attribute9 = hr_api.g_varchar2) then
826: p_rec.attribute9 :=
827: pqh_los_shd.g_old_rec.attribute9;
828: End If;
829: If (p_rec.attribute10 = hr_api.g_varchar2) then
830: p_rec.attribute10 :=
831: pqh_los_shd.g_old_rec.attribute10;
832: End If;
833: If (p_rec.attribute11 = hr_api.g_varchar2) then

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

829: If (p_rec.attribute10 = hr_api.g_varchar2) then
830: p_rec.attribute10 :=
831: pqh_los_shd.g_old_rec.attribute10;
832: End If;
833: If (p_rec.attribute11 = hr_api.g_varchar2) then
834: p_rec.attribute11 :=
835: pqh_los_shd.g_old_rec.attribute11;
836: End If;
837: If (p_rec.attribute12 = hr_api.g_varchar2) then

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

833: If (p_rec.attribute11 = hr_api.g_varchar2) then
834: p_rec.attribute11 :=
835: pqh_los_shd.g_old_rec.attribute11;
836: End If;
837: If (p_rec.attribute12 = hr_api.g_varchar2) then
838: p_rec.attribute12 :=
839: pqh_los_shd.g_old_rec.attribute12;
840: End If;
841: If (p_rec.attribute13 = hr_api.g_varchar2) then

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

837: If (p_rec.attribute12 = hr_api.g_varchar2) then
838: p_rec.attribute12 :=
839: pqh_los_shd.g_old_rec.attribute12;
840: End If;
841: If (p_rec.attribute13 = hr_api.g_varchar2) then
842: p_rec.attribute13 :=
843: pqh_los_shd.g_old_rec.attribute13;
844: End If;
845: If (p_rec.attribute14 = hr_api.g_varchar2) then

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

841: If (p_rec.attribute13 = hr_api.g_varchar2) then
842: p_rec.attribute13 :=
843: pqh_los_shd.g_old_rec.attribute13;
844: End If;
845: If (p_rec.attribute14 = hr_api.g_varchar2) then
846: p_rec.attribute14 :=
847: pqh_los_shd.g_old_rec.attribute14;
848: End If;
849: If (p_rec.attribute15 = hr_api.g_varchar2) then

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

845: If (p_rec.attribute14 = hr_api.g_varchar2) then
846: p_rec.attribute14 :=
847: pqh_los_shd.g_old_rec.attribute14;
848: End If;
849: If (p_rec.attribute15 = hr_api.g_varchar2) then
850: p_rec.attribute15 :=
851: pqh_los_shd.g_old_rec.attribute15;
852: End If;
853: If (p_rec.attribute16 = hr_api.g_varchar2) then

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

849: If (p_rec.attribute15 = hr_api.g_varchar2) then
850: p_rec.attribute15 :=
851: pqh_los_shd.g_old_rec.attribute15;
852: End If;
853: If (p_rec.attribute16 = hr_api.g_varchar2) then
854: p_rec.attribute16 :=
855: pqh_los_shd.g_old_rec.attribute16;
856: End If;
857: If (p_rec.attribute17 = hr_api.g_varchar2) then

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

853: If (p_rec.attribute16 = hr_api.g_varchar2) then
854: p_rec.attribute16 :=
855: pqh_los_shd.g_old_rec.attribute16;
856: End If;
857: If (p_rec.attribute17 = hr_api.g_varchar2) then
858: p_rec.attribute17 :=
859: pqh_los_shd.g_old_rec.attribute17;
860: End If;
861: If (p_rec.attribute18 = hr_api.g_varchar2) then

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

857: If (p_rec.attribute17 = hr_api.g_varchar2) then
858: p_rec.attribute17 :=
859: pqh_los_shd.g_old_rec.attribute17;
860: End If;
861: If (p_rec.attribute18 = hr_api.g_varchar2) then
862: p_rec.attribute18 :=
863: pqh_los_shd.g_old_rec.attribute18;
864: End If;
865: If (p_rec.attribute19 = hr_api.g_varchar2) then

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

861: If (p_rec.attribute18 = hr_api.g_varchar2) then
862: p_rec.attribute18 :=
863: pqh_los_shd.g_old_rec.attribute18;
864: End If;
865: If (p_rec.attribute19 = hr_api.g_varchar2) then
866: p_rec.attribute19 :=
867: pqh_los_shd.g_old_rec.attribute19;
868: End If;
869: If (p_rec.attribute20 = hr_api.g_varchar2) then

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

865: If (p_rec.attribute19 = hr_api.g_varchar2) then
866: p_rec.attribute19 :=
867: pqh_los_shd.g_old_rec.attribute19;
868: End If;
869: If (p_rec.attribute20 = hr_api.g_varchar2) then
870: p_rec.attribute20 :=
871: pqh_los_shd.g_old_rec.attribute20;
872: End If;
873: If (p_rec.attribute21 = hr_api.g_varchar2) then

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

869: If (p_rec.attribute20 = hr_api.g_varchar2) then
870: p_rec.attribute20 :=
871: pqh_los_shd.g_old_rec.attribute20;
872: End If;
873: If (p_rec.attribute21 = hr_api.g_varchar2) then
874: p_rec.attribute21 :=
875: pqh_los_shd.g_old_rec.attribute21;
876: End If;
877: If (p_rec.attribute22 = hr_api.g_varchar2) then

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

873: If (p_rec.attribute21 = hr_api.g_varchar2) then
874: p_rec.attribute21 :=
875: pqh_los_shd.g_old_rec.attribute21;
876: End If;
877: If (p_rec.attribute22 = hr_api.g_varchar2) then
878: p_rec.attribute22 :=
879: pqh_los_shd.g_old_rec.attribute22;
880: End If;
881: If (p_rec.attribute23 = hr_api.g_varchar2) then

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

877: If (p_rec.attribute22 = hr_api.g_varchar2) then
878: p_rec.attribute22 :=
879: pqh_los_shd.g_old_rec.attribute22;
880: End If;
881: If (p_rec.attribute23 = hr_api.g_varchar2) then
882: p_rec.attribute23 :=
883: pqh_los_shd.g_old_rec.attribute23;
884: End If;
885: If (p_rec.attribute24 = hr_api.g_varchar2) then

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

881: If (p_rec.attribute23 = hr_api.g_varchar2) then
882: p_rec.attribute23 :=
883: pqh_los_shd.g_old_rec.attribute23;
884: End If;
885: If (p_rec.attribute24 = hr_api.g_varchar2) then
886: p_rec.attribute24 :=
887: pqh_los_shd.g_old_rec.attribute24;
888: End If;
889: If (p_rec.attribute25 = hr_api.g_varchar2) then

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

885: If (p_rec.attribute24 = hr_api.g_varchar2) then
886: p_rec.attribute24 :=
887: pqh_los_shd.g_old_rec.attribute24;
888: End If;
889: If (p_rec.attribute25 = hr_api.g_varchar2) then
890: p_rec.attribute25 :=
891: pqh_los_shd.g_old_rec.attribute25;
892: End If;
893: If (p_rec.attribute26 = hr_api.g_varchar2) then

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

889: If (p_rec.attribute25 = hr_api.g_varchar2) then
890: p_rec.attribute25 :=
891: pqh_los_shd.g_old_rec.attribute25;
892: End If;
893: If (p_rec.attribute26 = hr_api.g_varchar2) then
894: p_rec.attribute26 :=
895: pqh_los_shd.g_old_rec.attribute26;
896: End If;
897: If (p_rec.attribute27 = hr_api.g_varchar2) then

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

893: If (p_rec.attribute26 = hr_api.g_varchar2) then
894: p_rec.attribute26 :=
895: pqh_los_shd.g_old_rec.attribute26;
896: End If;
897: If (p_rec.attribute27 = hr_api.g_varchar2) then
898: p_rec.attribute27 :=
899: pqh_los_shd.g_old_rec.attribute27;
900: End If;
901: If (p_rec.attribute28 = hr_api.g_varchar2) then

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

897: If (p_rec.attribute27 = hr_api.g_varchar2) then
898: p_rec.attribute27 :=
899: pqh_los_shd.g_old_rec.attribute27;
900: End If;
901: If (p_rec.attribute28 = hr_api.g_varchar2) then
902: p_rec.attribute28 :=
903: pqh_los_shd.g_old_rec.attribute28;
904: End If;
905: If (p_rec.attribute29 = hr_api.g_varchar2) then

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

901: If (p_rec.attribute28 = hr_api.g_varchar2) then
902: p_rec.attribute28 :=
903: pqh_los_shd.g_old_rec.attribute28;
904: End If;
905: If (p_rec.attribute29 = hr_api.g_varchar2) then
906: p_rec.attribute29 :=
907: pqh_los_shd.g_old_rec.attribute29;
908: End If;
909: If (p_rec.attribute30 = hr_api.g_varchar2) then

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

905: If (p_rec.attribute29 = hr_api.g_varchar2) then
906: p_rec.attribute29 :=
907: pqh_los_shd.g_old_rec.attribute29;
908: End If;
909: If (p_rec.attribute30 = hr_api.g_varchar2) then
910: p_rec.attribute30 :=
911: pqh_los_shd.g_old_rec.attribute30;
912: End If;
913: --

Line 977: ,p_situation in varchar2 default hr_api.g_varchar2

973: Procedure upd
974: (p_effective_date in date
975: ,p_situation_id in number
976: ,p_object_version_number in out nocopy number
977: ,p_situation in varchar2 default hr_api.g_varchar2
978: ,p_effective_start_date in date default hr_api.g_date
979: ,p_business_group_id in number default hr_api.g_number
980: ,p_situation_type in varchar2 default hr_api.g_varchar2
981: ,p_length_of_service in varchar2 default hr_api.g_varchar2

Line 978: ,p_effective_start_date in date default hr_api.g_date

974: (p_effective_date in date
975: ,p_situation_id in number
976: ,p_object_version_number in out nocopy number
977: ,p_situation in varchar2 default hr_api.g_varchar2
978: ,p_effective_start_date in date default hr_api.g_date
979: ,p_business_group_id in number default hr_api.g_number
980: ,p_situation_type in varchar2 default hr_api.g_varchar2
981: ,p_length_of_service in varchar2 default hr_api.g_varchar2
982: ,p_effective_end_date in date default hr_api.g_date

Line 979: ,p_business_group_id in number default hr_api.g_number

975: ,p_situation_id in number
976: ,p_object_version_number in out nocopy number
977: ,p_situation in varchar2 default hr_api.g_varchar2
978: ,p_effective_start_date in date default hr_api.g_date
979: ,p_business_group_id in number default hr_api.g_number
980: ,p_situation_type in varchar2 default hr_api.g_varchar2
981: ,p_length_of_service in varchar2 default hr_api.g_varchar2
982: ,p_effective_end_date in date default hr_api.g_date
983: ,p_employee_type in varchar2 default hr_api.g_varchar2

Line 980: ,p_situation_type in varchar2 default hr_api.g_varchar2

976: ,p_object_version_number in out nocopy number
977: ,p_situation in varchar2 default hr_api.g_varchar2
978: ,p_effective_start_date in date default hr_api.g_date
979: ,p_business_group_id in number default hr_api.g_number
980: ,p_situation_type in varchar2 default hr_api.g_varchar2
981: ,p_length_of_service in varchar2 default hr_api.g_varchar2
982: ,p_effective_end_date in date default hr_api.g_date
983: ,p_employee_type in varchar2 default hr_api.g_varchar2
984: ,p_entitlement_flag in varchar2 default hr_api.g_varchar2

Line 981: ,p_length_of_service in varchar2 default hr_api.g_varchar2

977: ,p_situation in varchar2 default hr_api.g_varchar2
978: ,p_effective_start_date in date default hr_api.g_date
979: ,p_business_group_id in number default hr_api.g_number
980: ,p_situation_type in varchar2 default hr_api.g_varchar2
981: ,p_length_of_service in varchar2 default hr_api.g_varchar2
982: ,p_effective_end_date in date default hr_api.g_date
983: ,p_employee_type in varchar2 default hr_api.g_varchar2
984: ,p_entitlement_flag in varchar2 default hr_api.g_varchar2
985: ,p_worktime_proportional in varchar2 default hr_api.g_varchar2

Line 982: ,p_effective_end_date in date default hr_api.g_date

978: ,p_effective_start_date in date default hr_api.g_date
979: ,p_business_group_id in number default hr_api.g_number
980: ,p_situation_type in varchar2 default hr_api.g_varchar2
981: ,p_length_of_service in varchar2 default hr_api.g_varchar2
982: ,p_effective_end_date in date default hr_api.g_date
983: ,p_employee_type in varchar2 default hr_api.g_varchar2
984: ,p_entitlement_flag in varchar2 default hr_api.g_varchar2
985: ,p_worktime_proportional in varchar2 default hr_api.g_varchar2
986: ,p_entitlement_value in number default hr_api.g_number

Line 983: ,p_employee_type in varchar2 default hr_api.g_varchar2

979: ,p_business_group_id in number default hr_api.g_number
980: ,p_situation_type in varchar2 default hr_api.g_varchar2
981: ,p_length_of_service in varchar2 default hr_api.g_varchar2
982: ,p_effective_end_date in date default hr_api.g_date
983: ,p_employee_type in varchar2 default hr_api.g_varchar2
984: ,p_entitlement_flag in varchar2 default hr_api.g_varchar2
985: ,p_worktime_proportional in varchar2 default hr_api.g_varchar2
986: ,p_entitlement_value in number default hr_api.g_number
987: ,p_information_category in varchar2 default hr_api.g_varchar2

Line 984: ,p_entitlement_flag in varchar2 default hr_api.g_varchar2

980: ,p_situation_type in varchar2 default hr_api.g_varchar2
981: ,p_length_of_service in varchar2 default hr_api.g_varchar2
982: ,p_effective_end_date in date default hr_api.g_date
983: ,p_employee_type in varchar2 default hr_api.g_varchar2
984: ,p_entitlement_flag in varchar2 default hr_api.g_varchar2
985: ,p_worktime_proportional in varchar2 default hr_api.g_varchar2
986: ,p_entitlement_value in number default hr_api.g_number
987: ,p_information_category in varchar2 default hr_api.g_varchar2
988: ,p_information1 in varchar2 default hr_api.g_varchar2

Line 985: ,p_worktime_proportional in varchar2 default hr_api.g_varchar2

981: ,p_length_of_service in varchar2 default hr_api.g_varchar2
982: ,p_effective_end_date in date default hr_api.g_date
983: ,p_employee_type in varchar2 default hr_api.g_varchar2
984: ,p_entitlement_flag in varchar2 default hr_api.g_varchar2
985: ,p_worktime_proportional in varchar2 default hr_api.g_varchar2
986: ,p_entitlement_value in number default hr_api.g_number
987: ,p_information_category in varchar2 default hr_api.g_varchar2
988: ,p_information1 in varchar2 default hr_api.g_varchar2
989: ,p_information2 in varchar2 default hr_api.g_varchar2

Line 986: ,p_entitlement_value in number default hr_api.g_number

982: ,p_effective_end_date in date default hr_api.g_date
983: ,p_employee_type in varchar2 default hr_api.g_varchar2
984: ,p_entitlement_flag in varchar2 default hr_api.g_varchar2
985: ,p_worktime_proportional in varchar2 default hr_api.g_varchar2
986: ,p_entitlement_value in number default hr_api.g_number
987: ,p_information_category in varchar2 default hr_api.g_varchar2
988: ,p_information1 in varchar2 default hr_api.g_varchar2
989: ,p_information2 in varchar2 default hr_api.g_varchar2
990: ,p_information3 in varchar2 default hr_api.g_varchar2

Line 987: ,p_information_category in varchar2 default hr_api.g_varchar2

983: ,p_employee_type in varchar2 default hr_api.g_varchar2
984: ,p_entitlement_flag in varchar2 default hr_api.g_varchar2
985: ,p_worktime_proportional in varchar2 default hr_api.g_varchar2
986: ,p_entitlement_value in number default hr_api.g_number
987: ,p_information_category in varchar2 default hr_api.g_varchar2
988: ,p_information1 in varchar2 default hr_api.g_varchar2
989: ,p_information2 in varchar2 default hr_api.g_varchar2
990: ,p_information3 in varchar2 default hr_api.g_varchar2
991: ,p_information4 in varchar2 default hr_api.g_varchar2

Line 988: ,p_information1 in varchar2 default hr_api.g_varchar2

984: ,p_entitlement_flag in varchar2 default hr_api.g_varchar2
985: ,p_worktime_proportional in varchar2 default hr_api.g_varchar2
986: ,p_entitlement_value in number default hr_api.g_number
987: ,p_information_category in varchar2 default hr_api.g_varchar2
988: ,p_information1 in varchar2 default hr_api.g_varchar2
989: ,p_information2 in varchar2 default hr_api.g_varchar2
990: ,p_information3 in varchar2 default hr_api.g_varchar2
991: ,p_information4 in varchar2 default hr_api.g_varchar2
992: ,p_information5 in varchar2 default hr_api.g_varchar2

Line 989: ,p_information2 in varchar2 default hr_api.g_varchar2

985: ,p_worktime_proportional in varchar2 default hr_api.g_varchar2
986: ,p_entitlement_value in number default hr_api.g_number
987: ,p_information_category in varchar2 default hr_api.g_varchar2
988: ,p_information1 in varchar2 default hr_api.g_varchar2
989: ,p_information2 in varchar2 default hr_api.g_varchar2
990: ,p_information3 in varchar2 default hr_api.g_varchar2
991: ,p_information4 in varchar2 default hr_api.g_varchar2
992: ,p_information5 in varchar2 default hr_api.g_varchar2
993: ,p_information6 in varchar2 default hr_api.g_varchar2

Line 990: ,p_information3 in varchar2 default hr_api.g_varchar2

986: ,p_entitlement_value in number default hr_api.g_number
987: ,p_information_category in varchar2 default hr_api.g_varchar2
988: ,p_information1 in varchar2 default hr_api.g_varchar2
989: ,p_information2 in varchar2 default hr_api.g_varchar2
990: ,p_information3 in varchar2 default hr_api.g_varchar2
991: ,p_information4 in varchar2 default hr_api.g_varchar2
992: ,p_information5 in varchar2 default hr_api.g_varchar2
993: ,p_information6 in varchar2 default hr_api.g_varchar2
994: ,p_information7 in varchar2 default hr_api.g_varchar2

Line 991: ,p_information4 in varchar2 default hr_api.g_varchar2

987: ,p_information_category in varchar2 default hr_api.g_varchar2
988: ,p_information1 in varchar2 default hr_api.g_varchar2
989: ,p_information2 in varchar2 default hr_api.g_varchar2
990: ,p_information3 in varchar2 default hr_api.g_varchar2
991: ,p_information4 in varchar2 default hr_api.g_varchar2
992: ,p_information5 in varchar2 default hr_api.g_varchar2
993: ,p_information6 in varchar2 default hr_api.g_varchar2
994: ,p_information7 in varchar2 default hr_api.g_varchar2
995: ,p_information8 in varchar2 default hr_api.g_varchar2

Line 992: ,p_information5 in varchar2 default hr_api.g_varchar2

988: ,p_information1 in varchar2 default hr_api.g_varchar2
989: ,p_information2 in varchar2 default hr_api.g_varchar2
990: ,p_information3 in varchar2 default hr_api.g_varchar2
991: ,p_information4 in varchar2 default hr_api.g_varchar2
992: ,p_information5 in varchar2 default hr_api.g_varchar2
993: ,p_information6 in varchar2 default hr_api.g_varchar2
994: ,p_information7 in varchar2 default hr_api.g_varchar2
995: ,p_information8 in varchar2 default hr_api.g_varchar2
996: ,p_information9 in varchar2 default hr_api.g_varchar2

Line 993: ,p_information6 in varchar2 default hr_api.g_varchar2

989: ,p_information2 in varchar2 default hr_api.g_varchar2
990: ,p_information3 in varchar2 default hr_api.g_varchar2
991: ,p_information4 in varchar2 default hr_api.g_varchar2
992: ,p_information5 in varchar2 default hr_api.g_varchar2
993: ,p_information6 in varchar2 default hr_api.g_varchar2
994: ,p_information7 in varchar2 default hr_api.g_varchar2
995: ,p_information8 in varchar2 default hr_api.g_varchar2
996: ,p_information9 in varchar2 default hr_api.g_varchar2
997: ,p_information10 in varchar2 default hr_api.g_varchar2

Line 994: ,p_information7 in varchar2 default hr_api.g_varchar2

990: ,p_information3 in varchar2 default hr_api.g_varchar2
991: ,p_information4 in varchar2 default hr_api.g_varchar2
992: ,p_information5 in varchar2 default hr_api.g_varchar2
993: ,p_information6 in varchar2 default hr_api.g_varchar2
994: ,p_information7 in varchar2 default hr_api.g_varchar2
995: ,p_information8 in varchar2 default hr_api.g_varchar2
996: ,p_information9 in varchar2 default hr_api.g_varchar2
997: ,p_information10 in varchar2 default hr_api.g_varchar2
998: ,p_information11 in varchar2 default hr_api.g_varchar2

Line 995: ,p_information8 in varchar2 default hr_api.g_varchar2

991: ,p_information4 in varchar2 default hr_api.g_varchar2
992: ,p_information5 in varchar2 default hr_api.g_varchar2
993: ,p_information6 in varchar2 default hr_api.g_varchar2
994: ,p_information7 in varchar2 default hr_api.g_varchar2
995: ,p_information8 in varchar2 default hr_api.g_varchar2
996: ,p_information9 in varchar2 default hr_api.g_varchar2
997: ,p_information10 in varchar2 default hr_api.g_varchar2
998: ,p_information11 in varchar2 default hr_api.g_varchar2
999: ,p_information12 in varchar2 default hr_api.g_varchar2

Line 996: ,p_information9 in varchar2 default hr_api.g_varchar2

992: ,p_information5 in varchar2 default hr_api.g_varchar2
993: ,p_information6 in varchar2 default hr_api.g_varchar2
994: ,p_information7 in varchar2 default hr_api.g_varchar2
995: ,p_information8 in varchar2 default hr_api.g_varchar2
996: ,p_information9 in varchar2 default hr_api.g_varchar2
997: ,p_information10 in varchar2 default hr_api.g_varchar2
998: ,p_information11 in varchar2 default hr_api.g_varchar2
999: ,p_information12 in varchar2 default hr_api.g_varchar2
1000: ,p_information13 in varchar2 default hr_api.g_varchar2

Line 997: ,p_information10 in varchar2 default hr_api.g_varchar2

993: ,p_information6 in varchar2 default hr_api.g_varchar2
994: ,p_information7 in varchar2 default hr_api.g_varchar2
995: ,p_information8 in varchar2 default hr_api.g_varchar2
996: ,p_information9 in varchar2 default hr_api.g_varchar2
997: ,p_information10 in varchar2 default hr_api.g_varchar2
998: ,p_information11 in varchar2 default hr_api.g_varchar2
999: ,p_information12 in varchar2 default hr_api.g_varchar2
1000: ,p_information13 in varchar2 default hr_api.g_varchar2
1001: ,p_information14 in varchar2 default hr_api.g_varchar2

Line 998: ,p_information11 in varchar2 default hr_api.g_varchar2

994: ,p_information7 in varchar2 default hr_api.g_varchar2
995: ,p_information8 in varchar2 default hr_api.g_varchar2
996: ,p_information9 in varchar2 default hr_api.g_varchar2
997: ,p_information10 in varchar2 default hr_api.g_varchar2
998: ,p_information11 in varchar2 default hr_api.g_varchar2
999: ,p_information12 in varchar2 default hr_api.g_varchar2
1000: ,p_information13 in varchar2 default hr_api.g_varchar2
1001: ,p_information14 in varchar2 default hr_api.g_varchar2
1002: ,p_information15 in varchar2 default hr_api.g_varchar2

Line 999: ,p_information12 in varchar2 default hr_api.g_varchar2

995: ,p_information8 in varchar2 default hr_api.g_varchar2
996: ,p_information9 in varchar2 default hr_api.g_varchar2
997: ,p_information10 in varchar2 default hr_api.g_varchar2
998: ,p_information11 in varchar2 default hr_api.g_varchar2
999: ,p_information12 in varchar2 default hr_api.g_varchar2
1000: ,p_information13 in varchar2 default hr_api.g_varchar2
1001: ,p_information14 in varchar2 default hr_api.g_varchar2
1002: ,p_information15 in varchar2 default hr_api.g_varchar2
1003: ,p_information16 in varchar2 default hr_api.g_varchar2

Line 1000: ,p_information13 in varchar2 default hr_api.g_varchar2

996: ,p_information9 in varchar2 default hr_api.g_varchar2
997: ,p_information10 in varchar2 default hr_api.g_varchar2
998: ,p_information11 in varchar2 default hr_api.g_varchar2
999: ,p_information12 in varchar2 default hr_api.g_varchar2
1000: ,p_information13 in varchar2 default hr_api.g_varchar2
1001: ,p_information14 in varchar2 default hr_api.g_varchar2
1002: ,p_information15 in varchar2 default hr_api.g_varchar2
1003: ,p_information16 in varchar2 default hr_api.g_varchar2
1004: ,p_information17 in varchar2 default hr_api.g_varchar2

Line 1001: ,p_information14 in varchar2 default hr_api.g_varchar2

997: ,p_information10 in varchar2 default hr_api.g_varchar2
998: ,p_information11 in varchar2 default hr_api.g_varchar2
999: ,p_information12 in varchar2 default hr_api.g_varchar2
1000: ,p_information13 in varchar2 default hr_api.g_varchar2
1001: ,p_information14 in varchar2 default hr_api.g_varchar2
1002: ,p_information15 in varchar2 default hr_api.g_varchar2
1003: ,p_information16 in varchar2 default hr_api.g_varchar2
1004: ,p_information17 in varchar2 default hr_api.g_varchar2
1005: ,p_information18 in varchar2 default hr_api.g_varchar2

Line 1002: ,p_information15 in varchar2 default hr_api.g_varchar2

998: ,p_information11 in varchar2 default hr_api.g_varchar2
999: ,p_information12 in varchar2 default hr_api.g_varchar2
1000: ,p_information13 in varchar2 default hr_api.g_varchar2
1001: ,p_information14 in varchar2 default hr_api.g_varchar2
1002: ,p_information15 in varchar2 default hr_api.g_varchar2
1003: ,p_information16 in varchar2 default hr_api.g_varchar2
1004: ,p_information17 in varchar2 default hr_api.g_varchar2
1005: ,p_information18 in varchar2 default hr_api.g_varchar2
1006: ,p_information19 in varchar2 default hr_api.g_varchar2

Line 1003: ,p_information16 in varchar2 default hr_api.g_varchar2

999: ,p_information12 in varchar2 default hr_api.g_varchar2
1000: ,p_information13 in varchar2 default hr_api.g_varchar2
1001: ,p_information14 in varchar2 default hr_api.g_varchar2
1002: ,p_information15 in varchar2 default hr_api.g_varchar2
1003: ,p_information16 in varchar2 default hr_api.g_varchar2
1004: ,p_information17 in varchar2 default hr_api.g_varchar2
1005: ,p_information18 in varchar2 default hr_api.g_varchar2
1006: ,p_information19 in varchar2 default hr_api.g_varchar2
1007: ,p_information20 in varchar2 default hr_api.g_varchar2

Line 1004: ,p_information17 in varchar2 default hr_api.g_varchar2

1000: ,p_information13 in varchar2 default hr_api.g_varchar2
1001: ,p_information14 in varchar2 default hr_api.g_varchar2
1002: ,p_information15 in varchar2 default hr_api.g_varchar2
1003: ,p_information16 in varchar2 default hr_api.g_varchar2
1004: ,p_information17 in varchar2 default hr_api.g_varchar2
1005: ,p_information18 in varchar2 default hr_api.g_varchar2
1006: ,p_information19 in varchar2 default hr_api.g_varchar2
1007: ,p_information20 in varchar2 default hr_api.g_varchar2
1008: ,p_information21 in varchar2 default hr_api.g_varchar2

Line 1005: ,p_information18 in varchar2 default hr_api.g_varchar2

1001: ,p_information14 in varchar2 default hr_api.g_varchar2
1002: ,p_information15 in varchar2 default hr_api.g_varchar2
1003: ,p_information16 in varchar2 default hr_api.g_varchar2
1004: ,p_information17 in varchar2 default hr_api.g_varchar2
1005: ,p_information18 in varchar2 default hr_api.g_varchar2
1006: ,p_information19 in varchar2 default hr_api.g_varchar2
1007: ,p_information20 in varchar2 default hr_api.g_varchar2
1008: ,p_information21 in varchar2 default hr_api.g_varchar2
1009: ,p_information22 in varchar2 default hr_api.g_varchar2

Line 1006: ,p_information19 in varchar2 default hr_api.g_varchar2

1002: ,p_information15 in varchar2 default hr_api.g_varchar2
1003: ,p_information16 in varchar2 default hr_api.g_varchar2
1004: ,p_information17 in varchar2 default hr_api.g_varchar2
1005: ,p_information18 in varchar2 default hr_api.g_varchar2
1006: ,p_information19 in varchar2 default hr_api.g_varchar2
1007: ,p_information20 in varchar2 default hr_api.g_varchar2
1008: ,p_information21 in varchar2 default hr_api.g_varchar2
1009: ,p_information22 in varchar2 default hr_api.g_varchar2
1010: ,p_information23 in varchar2 default hr_api.g_varchar2

Line 1007: ,p_information20 in varchar2 default hr_api.g_varchar2

1003: ,p_information16 in varchar2 default hr_api.g_varchar2
1004: ,p_information17 in varchar2 default hr_api.g_varchar2
1005: ,p_information18 in varchar2 default hr_api.g_varchar2
1006: ,p_information19 in varchar2 default hr_api.g_varchar2
1007: ,p_information20 in varchar2 default hr_api.g_varchar2
1008: ,p_information21 in varchar2 default hr_api.g_varchar2
1009: ,p_information22 in varchar2 default hr_api.g_varchar2
1010: ,p_information23 in varchar2 default hr_api.g_varchar2
1011: ,p_information24 in varchar2 default hr_api.g_varchar2

Line 1008: ,p_information21 in varchar2 default hr_api.g_varchar2

1004: ,p_information17 in varchar2 default hr_api.g_varchar2
1005: ,p_information18 in varchar2 default hr_api.g_varchar2
1006: ,p_information19 in varchar2 default hr_api.g_varchar2
1007: ,p_information20 in varchar2 default hr_api.g_varchar2
1008: ,p_information21 in varchar2 default hr_api.g_varchar2
1009: ,p_information22 in varchar2 default hr_api.g_varchar2
1010: ,p_information23 in varchar2 default hr_api.g_varchar2
1011: ,p_information24 in varchar2 default hr_api.g_varchar2
1012: ,p_information25 in varchar2 default hr_api.g_varchar2

Line 1009: ,p_information22 in varchar2 default hr_api.g_varchar2

1005: ,p_information18 in varchar2 default hr_api.g_varchar2
1006: ,p_information19 in varchar2 default hr_api.g_varchar2
1007: ,p_information20 in varchar2 default hr_api.g_varchar2
1008: ,p_information21 in varchar2 default hr_api.g_varchar2
1009: ,p_information22 in varchar2 default hr_api.g_varchar2
1010: ,p_information23 in varchar2 default hr_api.g_varchar2
1011: ,p_information24 in varchar2 default hr_api.g_varchar2
1012: ,p_information25 in varchar2 default hr_api.g_varchar2
1013: ,p_information26 in varchar2 default hr_api.g_varchar2

Line 1010: ,p_information23 in varchar2 default hr_api.g_varchar2

1006: ,p_information19 in varchar2 default hr_api.g_varchar2
1007: ,p_information20 in varchar2 default hr_api.g_varchar2
1008: ,p_information21 in varchar2 default hr_api.g_varchar2
1009: ,p_information22 in varchar2 default hr_api.g_varchar2
1010: ,p_information23 in varchar2 default hr_api.g_varchar2
1011: ,p_information24 in varchar2 default hr_api.g_varchar2
1012: ,p_information25 in varchar2 default hr_api.g_varchar2
1013: ,p_information26 in varchar2 default hr_api.g_varchar2
1014: ,p_information27 in varchar2 default hr_api.g_varchar2

Line 1011: ,p_information24 in varchar2 default hr_api.g_varchar2

1007: ,p_information20 in varchar2 default hr_api.g_varchar2
1008: ,p_information21 in varchar2 default hr_api.g_varchar2
1009: ,p_information22 in varchar2 default hr_api.g_varchar2
1010: ,p_information23 in varchar2 default hr_api.g_varchar2
1011: ,p_information24 in varchar2 default hr_api.g_varchar2
1012: ,p_information25 in varchar2 default hr_api.g_varchar2
1013: ,p_information26 in varchar2 default hr_api.g_varchar2
1014: ,p_information27 in varchar2 default hr_api.g_varchar2
1015: ,p_information28 in varchar2 default hr_api.g_varchar2

Line 1012: ,p_information25 in varchar2 default hr_api.g_varchar2

1008: ,p_information21 in varchar2 default hr_api.g_varchar2
1009: ,p_information22 in varchar2 default hr_api.g_varchar2
1010: ,p_information23 in varchar2 default hr_api.g_varchar2
1011: ,p_information24 in varchar2 default hr_api.g_varchar2
1012: ,p_information25 in varchar2 default hr_api.g_varchar2
1013: ,p_information26 in varchar2 default hr_api.g_varchar2
1014: ,p_information27 in varchar2 default hr_api.g_varchar2
1015: ,p_information28 in varchar2 default hr_api.g_varchar2
1016: ,p_information29 in varchar2 default hr_api.g_varchar2

Line 1013: ,p_information26 in varchar2 default hr_api.g_varchar2

1009: ,p_information22 in varchar2 default hr_api.g_varchar2
1010: ,p_information23 in varchar2 default hr_api.g_varchar2
1011: ,p_information24 in varchar2 default hr_api.g_varchar2
1012: ,p_information25 in varchar2 default hr_api.g_varchar2
1013: ,p_information26 in varchar2 default hr_api.g_varchar2
1014: ,p_information27 in varchar2 default hr_api.g_varchar2
1015: ,p_information28 in varchar2 default hr_api.g_varchar2
1016: ,p_information29 in varchar2 default hr_api.g_varchar2
1017: ,p_information30 in varchar2 default hr_api.g_varchar2

Line 1014: ,p_information27 in varchar2 default hr_api.g_varchar2

1010: ,p_information23 in varchar2 default hr_api.g_varchar2
1011: ,p_information24 in varchar2 default hr_api.g_varchar2
1012: ,p_information25 in varchar2 default hr_api.g_varchar2
1013: ,p_information26 in varchar2 default hr_api.g_varchar2
1014: ,p_information27 in varchar2 default hr_api.g_varchar2
1015: ,p_information28 in varchar2 default hr_api.g_varchar2
1016: ,p_information29 in varchar2 default hr_api.g_varchar2
1017: ,p_information30 in varchar2 default hr_api.g_varchar2
1018: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 1015: ,p_information28 in varchar2 default hr_api.g_varchar2

1011: ,p_information24 in varchar2 default hr_api.g_varchar2
1012: ,p_information25 in varchar2 default hr_api.g_varchar2
1013: ,p_information26 in varchar2 default hr_api.g_varchar2
1014: ,p_information27 in varchar2 default hr_api.g_varchar2
1015: ,p_information28 in varchar2 default hr_api.g_varchar2
1016: ,p_information29 in varchar2 default hr_api.g_varchar2
1017: ,p_information30 in varchar2 default hr_api.g_varchar2
1018: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1019: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 1016: ,p_information29 in varchar2 default hr_api.g_varchar2

1012: ,p_information25 in varchar2 default hr_api.g_varchar2
1013: ,p_information26 in varchar2 default hr_api.g_varchar2
1014: ,p_information27 in varchar2 default hr_api.g_varchar2
1015: ,p_information28 in varchar2 default hr_api.g_varchar2
1016: ,p_information29 in varchar2 default hr_api.g_varchar2
1017: ,p_information30 in varchar2 default hr_api.g_varchar2
1018: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1019: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1020: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 1017: ,p_information30 in varchar2 default hr_api.g_varchar2

1013: ,p_information26 in varchar2 default hr_api.g_varchar2
1014: ,p_information27 in varchar2 default hr_api.g_varchar2
1015: ,p_information28 in varchar2 default hr_api.g_varchar2
1016: ,p_information29 in varchar2 default hr_api.g_varchar2
1017: ,p_information30 in varchar2 default hr_api.g_varchar2
1018: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1019: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1020: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1021: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 1018: ,p_attribute_category in varchar2 default hr_api.g_varchar2

1014: ,p_information27 in varchar2 default hr_api.g_varchar2
1015: ,p_information28 in varchar2 default hr_api.g_varchar2
1016: ,p_information29 in varchar2 default hr_api.g_varchar2
1017: ,p_information30 in varchar2 default hr_api.g_varchar2
1018: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1019: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1020: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1021: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1022: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 1019: ,p_attribute1 in varchar2 default hr_api.g_varchar2

1015: ,p_information28 in varchar2 default hr_api.g_varchar2
1016: ,p_information29 in varchar2 default hr_api.g_varchar2
1017: ,p_information30 in varchar2 default hr_api.g_varchar2
1018: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1019: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1020: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1021: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1022: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1023: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 1020: ,p_attribute2 in varchar2 default hr_api.g_varchar2

1016: ,p_information29 in varchar2 default hr_api.g_varchar2
1017: ,p_information30 in varchar2 default hr_api.g_varchar2
1018: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1019: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1020: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1021: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1022: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1023: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1024: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 1021: ,p_attribute3 in varchar2 default hr_api.g_varchar2

1017: ,p_information30 in varchar2 default hr_api.g_varchar2
1018: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1019: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1020: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1021: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1022: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1023: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1024: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1025: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 1022: ,p_attribute4 in varchar2 default hr_api.g_varchar2

1018: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1019: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1020: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1021: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1022: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1023: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1024: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1025: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1026: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 1023: ,p_attribute5 in varchar2 default hr_api.g_varchar2

1019: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1020: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1021: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1022: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1023: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1024: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1025: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1026: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1027: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 1024: ,p_attribute6 in varchar2 default hr_api.g_varchar2

1020: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1021: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1022: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1023: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1024: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1025: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1026: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1027: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1028: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 1025: ,p_attribute7 in varchar2 default hr_api.g_varchar2

1021: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1022: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1023: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1024: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1025: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1026: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1027: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1028: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1029: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 1026: ,p_attribute8 in varchar2 default hr_api.g_varchar2

1022: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1023: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1024: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1025: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1026: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1027: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1028: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1029: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1030: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 1027: ,p_attribute9 in varchar2 default hr_api.g_varchar2

1023: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1024: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1025: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1026: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1027: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1028: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1029: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1030: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1031: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 1028: ,p_attribute10 in varchar2 default hr_api.g_varchar2

1024: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1025: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1026: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1027: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1028: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1029: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1030: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1031: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1032: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 1029: ,p_attribute11 in varchar2 default hr_api.g_varchar2

1025: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1026: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1027: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1028: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1029: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1030: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1031: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1032: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1033: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 1030: ,p_attribute12 in varchar2 default hr_api.g_varchar2

1026: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1027: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1028: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1029: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1030: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1031: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1032: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1033: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1034: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 1031: ,p_attribute13 in varchar2 default hr_api.g_varchar2

1027: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1028: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1029: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1030: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1031: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1032: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1033: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1034: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1035: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 1032: ,p_attribute14 in varchar2 default hr_api.g_varchar2

1028: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1029: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1030: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1031: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1032: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1033: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1034: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1035: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1036: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 1033: ,p_attribute15 in varchar2 default hr_api.g_varchar2

1029: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1030: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1031: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1032: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1033: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1034: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1035: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1036: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1037: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 1034: ,p_attribute16 in varchar2 default hr_api.g_varchar2

1030: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1031: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1032: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1033: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1034: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1035: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1036: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1037: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1038: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 1035: ,p_attribute17 in varchar2 default hr_api.g_varchar2

1031: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1032: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1033: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1034: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1035: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1036: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1037: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1038: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1039: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 1036: ,p_attribute18 in varchar2 default hr_api.g_varchar2

1032: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1033: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1034: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1035: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1036: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1037: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1038: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1039: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1040: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 1037: ,p_attribute19 in varchar2 default hr_api.g_varchar2

1033: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1034: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1035: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1036: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1037: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1038: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1039: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1040: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1041: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 1038: ,p_attribute20 in varchar2 default hr_api.g_varchar2

1034: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1035: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1036: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1037: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1038: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1039: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1040: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1041: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1042: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 1039: ,p_attribute21 in varchar2 default hr_api.g_varchar2

1035: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1036: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1037: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1038: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1039: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1040: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1041: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1042: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1043: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 1040: ,p_attribute22 in varchar2 default hr_api.g_varchar2

1036: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1037: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1038: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1039: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1040: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1041: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1042: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1043: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1044: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 1041: ,p_attribute23 in varchar2 default hr_api.g_varchar2

1037: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1038: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1039: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1040: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1041: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1042: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1043: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1044: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1045: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 1042: ,p_attribute24 in varchar2 default hr_api.g_varchar2

1038: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1039: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1040: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1041: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1042: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1043: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1044: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1045: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1046: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 1043: ,p_attribute25 in varchar2 default hr_api.g_varchar2

1039: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1040: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1041: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1042: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1043: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1044: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1045: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1046: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1047: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 1044: ,p_attribute26 in varchar2 default hr_api.g_varchar2

1040: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1041: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1042: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1043: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1044: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1045: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1046: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1047: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1048: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 1045: ,p_attribute27 in varchar2 default hr_api.g_varchar2

1041: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1042: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1043: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1044: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1045: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1046: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1047: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1048: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1049: ) is

Line 1046: ,p_attribute28 in varchar2 default hr_api.g_varchar2

1042: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1043: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1044: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1045: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1046: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1047: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1048: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1049: ) is
1050: --

Line 1047: ,p_attribute29 in varchar2 default hr_api.g_varchar2

1043: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1044: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1045: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1046: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1047: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1048: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1049: ) is
1050: --
1051: l_rec pqh_los_shd.g_rec_type;

Line 1048: ,p_attribute30 in varchar2 default hr_api.g_varchar2

1044: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1045: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1046: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1047: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1048: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1049: ) is
1050: --
1051: l_rec pqh_los_shd.g_rec_type;
1052: l_proc varchar2(72) := g_package||'upd';