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

Line 145: When hr_api.check_integrity_violated Then

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

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

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

Line 150: When hr_api.parent_integrity_violated Then

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

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

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

Line 155: When hr_api.unique_integrity_violated Then

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

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

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

Line 520: when hr_api.cannot_find_prog_unit then

516: );
517: --
518: exception
519: --
520: when hr_api.cannot_find_prog_unit then
521: --
522: hr_api.cannot_find_prog_unit_error
523: (p_module_name => 'PQH_CORPS_EXTRA_INFO'
524: ,p_hook_type => 'AU');

Line 522: hr_api.cannot_find_prog_unit_error

518: exception
519: --
520: when hr_api.cannot_find_prog_unit then
521: --
522: hr_api.cannot_find_prog_unit_error
523: (p_module_name => 'PQH_CORPS_EXTRA_INFO'
524: ,p_hook_type => 'AU');
525: --
526: end;

Line 585: If (p_rec.corps_definition_id = hr_api.g_number) then

581: -- p_rec plsql record structure
582: -- to see if a system default is being used. If a system default
583: -- is being used then we must set to the 'current' argument value.
584: --
585: If (p_rec.corps_definition_id = hr_api.g_number) then
586: p_rec.corps_definition_id :=
587: pqh_cei_shd.g_old_rec.corps_definition_id;
588: End If;
589: If (p_rec.information_type = hr_api.g_varchar2) then

Line 589: If (p_rec.information_type = hr_api.g_varchar2) then

585: If (p_rec.corps_definition_id = hr_api.g_number) then
586: p_rec.corps_definition_id :=
587: pqh_cei_shd.g_old_rec.corps_definition_id;
588: End If;
589: If (p_rec.information_type = hr_api.g_varchar2) then
590: p_rec.information_type :=
591: pqh_cei_shd.g_old_rec.information_type;
592: End If;
593: If (p_rec.information1 = hr_api.g_varchar2) then

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

589: If (p_rec.information_type = hr_api.g_varchar2) then
590: p_rec.information_type :=
591: pqh_cei_shd.g_old_rec.information_type;
592: End If;
593: If (p_rec.information1 = hr_api.g_varchar2) then
594: p_rec.information1 :=
595: pqh_cei_shd.g_old_rec.information1;
596: End If;
597: If (p_rec.information2 = hr_api.g_varchar2) then

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

593: If (p_rec.information1 = hr_api.g_varchar2) then
594: p_rec.information1 :=
595: pqh_cei_shd.g_old_rec.information1;
596: End If;
597: If (p_rec.information2 = hr_api.g_varchar2) then
598: p_rec.information2 :=
599: pqh_cei_shd.g_old_rec.information2;
600: End If;
601: If (p_rec.information3 = hr_api.g_varchar2) then

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

597: If (p_rec.information2 = hr_api.g_varchar2) then
598: p_rec.information2 :=
599: pqh_cei_shd.g_old_rec.information2;
600: End If;
601: If (p_rec.information3 = hr_api.g_varchar2) then
602: p_rec.information3 :=
603: pqh_cei_shd.g_old_rec.information3;
604: End If;
605: If (p_rec.information4 = hr_api.g_varchar2) then

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

601: If (p_rec.information3 = hr_api.g_varchar2) then
602: p_rec.information3 :=
603: pqh_cei_shd.g_old_rec.information3;
604: End If;
605: If (p_rec.information4 = hr_api.g_varchar2) then
606: p_rec.information4 :=
607: pqh_cei_shd.g_old_rec.information4;
608: End If;
609: If (p_rec.information5 = hr_api.g_varchar2) then

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

605: If (p_rec.information4 = hr_api.g_varchar2) then
606: p_rec.information4 :=
607: pqh_cei_shd.g_old_rec.information4;
608: End If;
609: If (p_rec.information5 = hr_api.g_varchar2) then
610: p_rec.information5 :=
611: pqh_cei_shd.g_old_rec.information5;
612: End If;
613: If (p_rec.information6 = hr_api.g_varchar2) then

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

609: If (p_rec.information5 = hr_api.g_varchar2) then
610: p_rec.information5 :=
611: pqh_cei_shd.g_old_rec.information5;
612: End If;
613: If (p_rec.information6 = hr_api.g_varchar2) then
614: p_rec.information6 :=
615: pqh_cei_shd.g_old_rec.information6;
616: End If;
617: If (p_rec.information7 = hr_api.g_varchar2) then

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

613: If (p_rec.information6 = hr_api.g_varchar2) then
614: p_rec.information6 :=
615: pqh_cei_shd.g_old_rec.information6;
616: End If;
617: If (p_rec.information7 = hr_api.g_varchar2) then
618: p_rec.information7 :=
619: pqh_cei_shd.g_old_rec.information7;
620: End If;
621: If (p_rec.information8 = hr_api.g_varchar2) then

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

617: If (p_rec.information7 = hr_api.g_varchar2) then
618: p_rec.information7 :=
619: pqh_cei_shd.g_old_rec.information7;
620: End If;
621: If (p_rec.information8 = hr_api.g_varchar2) then
622: p_rec.information8 :=
623: pqh_cei_shd.g_old_rec.information8;
624: End If;
625: If (p_rec.information9 = hr_api.g_varchar2) then

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

621: If (p_rec.information8 = hr_api.g_varchar2) then
622: p_rec.information8 :=
623: pqh_cei_shd.g_old_rec.information8;
624: End If;
625: If (p_rec.information9 = hr_api.g_varchar2) then
626: p_rec.information9 :=
627: pqh_cei_shd.g_old_rec.information9;
628: End If;
629: If (p_rec.information10 = hr_api.g_varchar2) then

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

625: If (p_rec.information9 = hr_api.g_varchar2) then
626: p_rec.information9 :=
627: pqh_cei_shd.g_old_rec.information9;
628: End If;
629: If (p_rec.information10 = hr_api.g_varchar2) then
630: p_rec.information10 :=
631: pqh_cei_shd.g_old_rec.information10;
632: End If;
633: If (p_rec.information11 = hr_api.g_varchar2) then

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

629: If (p_rec.information10 = hr_api.g_varchar2) then
630: p_rec.information10 :=
631: pqh_cei_shd.g_old_rec.information10;
632: End If;
633: If (p_rec.information11 = hr_api.g_varchar2) then
634: p_rec.information11 :=
635: pqh_cei_shd.g_old_rec.information11;
636: End If;
637: If (p_rec.information12 = hr_api.g_varchar2) then

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

633: If (p_rec.information11 = hr_api.g_varchar2) then
634: p_rec.information11 :=
635: pqh_cei_shd.g_old_rec.information11;
636: End If;
637: If (p_rec.information12 = hr_api.g_varchar2) then
638: p_rec.information12 :=
639: pqh_cei_shd.g_old_rec.information12;
640: End If;
641: If (p_rec.information13 = hr_api.g_varchar2) then

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

637: If (p_rec.information12 = hr_api.g_varchar2) then
638: p_rec.information12 :=
639: pqh_cei_shd.g_old_rec.information12;
640: End If;
641: If (p_rec.information13 = hr_api.g_varchar2) then
642: p_rec.information13 :=
643: pqh_cei_shd.g_old_rec.information13;
644: End If;
645: If (p_rec.information14 = hr_api.g_varchar2) then

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

641: If (p_rec.information13 = hr_api.g_varchar2) then
642: p_rec.information13 :=
643: pqh_cei_shd.g_old_rec.information13;
644: End If;
645: If (p_rec.information14 = hr_api.g_varchar2) then
646: p_rec.information14 :=
647: pqh_cei_shd.g_old_rec.information14;
648: End If;
649: If (p_rec.information15 = hr_api.g_varchar2) then

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

645: If (p_rec.information14 = hr_api.g_varchar2) then
646: p_rec.information14 :=
647: pqh_cei_shd.g_old_rec.information14;
648: End If;
649: If (p_rec.information15 = hr_api.g_varchar2) then
650: p_rec.information15 :=
651: pqh_cei_shd.g_old_rec.information15;
652: End If;
653: If (p_rec.information16 = hr_api.g_varchar2) then

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

649: If (p_rec.information15 = hr_api.g_varchar2) then
650: p_rec.information15 :=
651: pqh_cei_shd.g_old_rec.information15;
652: End If;
653: If (p_rec.information16 = hr_api.g_varchar2) then
654: p_rec.information16 :=
655: pqh_cei_shd.g_old_rec.information16;
656: End If;
657: If (p_rec.information17 = hr_api.g_varchar2) then

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

653: If (p_rec.information16 = hr_api.g_varchar2) then
654: p_rec.information16 :=
655: pqh_cei_shd.g_old_rec.information16;
656: End If;
657: If (p_rec.information17 = hr_api.g_varchar2) then
658: p_rec.information17 :=
659: pqh_cei_shd.g_old_rec.information17;
660: End If;
661: If (p_rec.information18 = hr_api.g_varchar2) then

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

657: If (p_rec.information17 = hr_api.g_varchar2) then
658: p_rec.information17 :=
659: pqh_cei_shd.g_old_rec.information17;
660: End If;
661: If (p_rec.information18 = hr_api.g_varchar2) then
662: p_rec.information18 :=
663: pqh_cei_shd.g_old_rec.information18;
664: End If;
665: If (p_rec.information19 = hr_api.g_varchar2) then

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

661: If (p_rec.information18 = hr_api.g_varchar2) then
662: p_rec.information18 :=
663: pqh_cei_shd.g_old_rec.information18;
664: End If;
665: If (p_rec.information19 = hr_api.g_varchar2) then
666: p_rec.information19 :=
667: pqh_cei_shd.g_old_rec.information19;
668: End If;
669: If (p_rec.information20 = hr_api.g_varchar2) then

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

665: If (p_rec.information19 = hr_api.g_varchar2) then
666: p_rec.information19 :=
667: pqh_cei_shd.g_old_rec.information19;
668: End If;
669: If (p_rec.information20 = hr_api.g_varchar2) then
670: p_rec.information20 :=
671: pqh_cei_shd.g_old_rec.information20;
672: End If;
673: If (p_rec.information21 = hr_api.g_varchar2) then

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

669: If (p_rec.information20 = hr_api.g_varchar2) then
670: p_rec.information20 :=
671: pqh_cei_shd.g_old_rec.information20;
672: End If;
673: If (p_rec.information21 = hr_api.g_varchar2) then
674: p_rec.information21 :=
675: pqh_cei_shd.g_old_rec.information21;
676: End If;
677: If (p_rec.information22 = hr_api.g_varchar2) then

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

673: If (p_rec.information21 = hr_api.g_varchar2) then
674: p_rec.information21 :=
675: pqh_cei_shd.g_old_rec.information21;
676: End If;
677: If (p_rec.information22 = hr_api.g_varchar2) then
678: p_rec.information22 :=
679: pqh_cei_shd.g_old_rec.information22;
680: End If;
681: If (p_rec.information23 = hr_api.g_varchar2) then

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

677: If (p_rec.information22 = hr_api.g_varchar2) then
678: p_rec.information22 :=
679: pqh_cei_shd.g_old_rec.information22;
680: End If;
681: If (p_rec.information23 = hr_api.g_varchar2) then
682: p_rec.information23 :=
683: pqh_cei_shd.g_old_rec.information23;
684: End If;
685: If (p_rec.information24 = hr_api.g_varchar2) then

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

681: If (p_rec.information23 = hr_api.g_varchar2) then
682: p_rec.information23 :=
683: pqh_cei_shd.g_old_rec.information23;
684: End If;
685: If (p_rec.information24 = hr_api.g_varchar2) then
686: p_rec.information24 :=
687: pqh_cei_shd.g_old_rec.information24;
688: End If;
689: If (p_rec.information25 = hr_api.g_varchar2) then

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

685: If (p_rec.information24 = hr_api.g_varchar2) then
686: p_rec.information24 :=
687: pqh_cei_shd.g_old_rec.information24;
688: End If;
689: If (p_rec.information25 = hr_api.g_varchar2) then
690: p_rec.information25 :=
691: pqh_cei_shd.g_old_rec.information25;
692: End If;
693: If (p_rec.information26 = hr_api.g_varchar2) then

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

689: If (p_rec.information25 = hr_api.g_varchar2) then
690: p_rec.information25 :=
691: pqh_cei_shd.g_old_rec.information25;
692: End If;
693: If (p_rec.information26 = hr_api.g_varchar2) then
694: p_rec.information26 :=
695: pqh_cei_shd.g_old_rec.information26;
696: End If;
697: If (p_rec.information27 = hr_api.g_varchar2) then

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

693: If (p_rec.information26 = hr_api.g_varchar2) then
694: p_rec.information26 :=
695: pqh_cei_shd.g_old_rec.information26;
696: End If;
697: If (p_rec.information27 = hr_api.g_varchar2) then
698: p_rec.information27 :=
699: pqh_cei_shd.g_old_rec.information27;
700: End If;
701: If (p_rec.information28 = hr_api.g_varchar2) then

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

697: If (p_rec.information27 = hr_api.g_varchar2) then
698: p_rec.information27 :=
699: pqh_cei_shd.g_old_rec.information27;
700: End If;
701: If (p_rec.information28 = hr_api.g_varchar2) then
702: p_rec.information28 :=
703: pqh_cei_shd.g_old_rec.information28;
704: End If;
705: If (p_rec.information29 = hr_api.g_varchar2) then

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

701: If (p_rec.information28 = hr_api.g_varchar2) then
702: p_rec.information28 :=
703: pqh_cei_shd.g_old_rec.information28;
704: End If;
705: If (p_rec.information29 = hr_api.g_varchar2) then
706: p_rec.information29 :=
707: pqh_cei_shd.g_old_rec.information29;
708: End If;
709: If (p_rec.information30 = hr_api.g_varchar2) then

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

705: If (p_rec.information29 = hr_api.g_varchar2) then
706: p_rec.information29 :=
707: pqh_cei_shd.g_old_rec.information29;
708: End If;
709: If (p_rec.information30 = hr_api.g_varchar2) then
710: p_rec.information30 :=
711: pqh_cei_shd.g_old_rec.information30;
712: End If;
713: If (p_rec.information_category = hr_api.g_varchar2) then

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

709: If (p_rec.information30 = hr_api.g_varchar2) then
710: p_rec.information30 :=
711: pqh_cei_shd.g_old_rec.information30;
712: End If;
713: If (p_rec.information_category = hr_api.g_varchar2) then
714: p_rec.information_category :=
715: pqh_cei_shd.g_old_rec.information_category;
716: End If;
717: If (p_rec.attribute1 = hr_api.g_varchar2) then

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

713: If (p_rec.information_category = hr_api.g_varchar2) then
714: p_rec.information_category :=
715: pqh_cei_shd.g_old_rec.information_category;
716: End If;
717: If (p_rec.attribute1 = hr_api.g_varchar2) then
718: p_rec.attribute1 :=
719: pqh_cei_shd.g_old_rec.attribute1;
720: End If;
721: If (p_rec.attribute2 = hr_api.g_varchar2) then

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

717: If (p_rec.attribute1 = hr_api.g_varchar2) then
718: p_rec.attribute1 :=
719: pqh_cei_shd.g_old_rec.attribute1;
720: End If;
721: If (p_rec.attribute2 = hr_api.g_varchar2) then
722: p_rec.attribute2 :=
723: pqh_cei_shd.g_old_rec.attribute2;
724: End If;
725: If (p_rec.attribute3 = hr_api.g_varchar2) then

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

721: If (p_rec.attribute2 = hr_api.g_varchar2) then
722: p_rec.attribute2 :=
723: pqh_cei_shd.g_old_rec.attribute2;
724: End If;
725: If (p_rec.attribute3 = hr_api.g_varchar2) then
726: p_rec.attribute3 :=
727: pqh_cei_shd.g_old_rec.attribute3;
728: End If;
729: If (p_rec.attribute4 = hr_api.g_varchar2) then

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

725: If (p_rec.attribute3 = hr_api.g_varchar2) then
726: p_rec.attribute3 :=
727: pqh_cei_shd.g_old_rec.attribute3;
728: End If;
729: If (p_rec.attribute4 = hr_api.g_varchar2) then
730: p_rec.attribute4 :=
731: pqh_cei_shd.g_old_rec.attribute4;
732: End If;
733: If (p_rec.attribute5 = hr_api.g_varchar2) then

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

729: If (p_rec.attribute4 = hr_api.g_varchar2) then
730: p_rec.attribute4 :=
731: pqh_cei_shd.g_old_rec.attribute4;
732: End If;
733: If (p_rec.attribute5 = hr_api.g_varchar2) then
734: p_rec.attribute5 :=
735: pqh_cei_shd.g_old_rec.attribute5;
736: End If;
737: If (p_rec.attribute6 = hr_api.g_varchar2) then

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

733: If (p_rec.attribute5 = hr_api.g_varchar2) then
734: p_rec.attribute5 :=
735: pqh_cei_shd.g_old_rec.attribute5;
736: End If;
737: If (p_rec.attribute6 = hr_api.g_varchar2) then
738: p_rec.attribute6 :=
739: pqh_cei_shd.g_old_rec.attribute6;
740: End If;
741: If (p_rec.attribute7 = hr_api.g_varchar2) then

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

737: If (p_rec.attribute6 = hr_api.g_varchar2) then
738: p_rec.attribute6 :=
739: pqh_cei_shd.g_old_rec.attribute6;
740: End If;
741: If (p_rec.attribute7 = hr_api.g_varchar2) then
742: p_rec.attribute7 :=
743: pqh_cei_shd.g_old_rec.attribute7;
744: End If;
745: If (p_rec.attribute8 = hr_api.g_varchar2) then

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

741: If (p_rec.attribute7 = hr_api.g_varchar2) then
742: p_rec.attribute7 :=
743: pqh_cei_shd.g_old_rec.attribute7;
744: End If;
745: If (p_rec.attribute8 = hr_api.g_varchar2) then
746: p_rec.attribute8 :=
747: pqh_cei_shd.g_old_rec.attribute8;
748: End If;
749: If (p_rec.attribute9 = hr_api.g_varchar2) then

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

745: If (p_rec.attribute8 = hr_api.g_varchar2) then
746: p_rec.attribute8 :=
747: pqh_cei_shd.g_old_rec.attribute8;
748: End If;
749: If (p_rec.attribute9 = hr_api.g_varchar2) then
750: p_rec.attribute9 :=
751: pqh_cei_shd.g_old_rec.attribute9;
752: End If;
753: If (p_rec.attribute10 = hr_api.g_varchar2) then

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

749: If (p_rec.attribute9 = hr_api.g_varchar2) then
750: p_rec.attribute9 :=
751: pqh_cei_shd.g_old_rec.attribute9;
752: End If;
753: If (p_rec.attribute10 = hr_api.g_varchar2) then
754: p_rec.attribute10 :=
755: pqh_cei_shd.g_old_rec.attribute10;
756: End If;
757: If (p_rec.attribute11 = hr_api.g_varchar2) then

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

753: If (p_rec.attribute10 = hr_api.g_varchar2) then
754: p_rec.attribute10 :=
755: pqh_cei_shd.g_old_rec.attribute10;
756: End If;
757: If (p_rec.attribute11 = hr_api.g_varchar2) then
758: p_rec.attribute11 :=
759: pqh_cei_shd.g_old_rec.attribute11;
760: End If;
761: If (p_rec.attribute12 = hr_api.g_varchar2) then

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

757: If (p_rec.attribute11 = hr_api.g_varchar2) then
758: p_rec.attribute11 :=
759: pqh_cei_shd.g_old_rec.attribute11;
760: End If;
761: If (p_rec.attribute12 = hr_api.g_varchar2) then
762: p_rec.attribute12 :=
763: pqh_cei_shd.g_old_rec.attribute12;
764: End If;
765: If (p_rec.attribute13 = hr_api.g_varchar2) then

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

761: If (p_rec.attribute12 = hr_api.g_varchar2) then
762: p_rec.attribute12 :=
763: pqh_cei_shd.g_old_rec.attribute12;
764: End If;
765: If (p_rec.attribute13 = hr_api.g_varchar2) then
766: p_rec.attribute13 :=
767: pqh_cei_shd.g_old_rec.attribute13;
768: End If;
769: If (p_rec.attribute14 = hr_api.g_varchar2) then

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

765: If (p_rec.attribute13 = hr_api.g_varchar2) then
766: p_rec.attribute13 :=
767: pqh_cei_shd.g_old_rec.attribute13;
768: End If;
769: If (p_rec.attribute14 = hr_api.g_varchar2) then
770: p_rec.attribute14 :=
771: pqh_cei_shd.g_old_rec.attribute14;
772: End If;
773: If (p_rec.attribute15 = hr_api.g_varchar2) then

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

769: If (p_rec.attribute14 = hr_api.g_varchar2) then
770: p_rec.attribute14 :=
771: pqh_cei_shd.g_old_rec.attribute14;
772: End If;
773: If (p_rec.attribute15 = hr_api.g_varchar2) then
774: p_rec.attribute15 :=
775: pqh_cei_shd.g_old_rec.attribute15;
776: End If;
777: If (p_rec.attribute16 = hr_api.g_varchar2) then

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

773: If (p_rec.attribute15 = hr_api.g_varchar2) then
774: p_rec.attribute15 :=
775: pqh_cei_shd.g_old_rec.attribute15;
776: End If;
777: If (p_rec.attribute16 = hr_api.g_varchar2) then
778: p_rec.attribute16 :=
779: pqh_cei_shd.g_old_rec.attribute16;
780: End If;
781: If (p_rec.attribute17 = hr_api.g_varchar2) then

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

777: If (p_rec.attribute16 = hr_api.g_varchar2) then
778: p_rec.attribute16 :=
779: pqh_cei_shd.g_old_rec.attribute16;
780: End If;
781: If (p_rec.attribute17 = hr_api.g_varchar2) then
782: p_rec.attribute17 :=
783: pqh_cei_shd.g_old_rec.attribute17;
784: End If;
785: If (p_rec.attribute18 = hr_api.g_varchar2) then

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

781: If (p_rec.attribute17 = hr_api.g_varchar2) then
782: p_rec.attribute17 :=
783: pqh_cei_shd.g_old_rec.attribute17;
784: End If;
785: If (p_rec.attribute18 = hr_api.g_varchar2) then
786: p_rec.attribute18 :=
787: pqh_cei_shd.g_old_rec.attribute18;
788: End If;
789: If (p_rec.attribute19 = hr_api.g_varchar2) then

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

785: If (p_rec.attribute18 = hr_api.g_varchar2) then
786: p_rec.attribute18 :=
787: pqh_cei_shd.g_old_rec.attribute18;
788: End If;
789: If (p_rec.attribute19 = hr_api.g_varchar2) then
790: p_rec.attribute19 :=
791: pqh_cei_shd.g_old_rec.attribute19;
792: End If;
793: If (p_rec.attribute20 = hr_api.g_varchar2) then

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

789: If (p_rec.attribute19 = hr_api.g_varchar2) then
790: p_rec.attribute19 :=
791: pqh_cei_shd.g_old_rec.attribute19;
792: End If;
793: If (p_rec.attribute20 = hr_api.g_varchar2) then
794: p_rec.attribute20 :=
795: pqh_cei_shd.g_old_rec.attribute20;
796: End If;
797: If (p_rec.attribute21 = hr_api.g_varchar2) then

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

793: If (p_rec.attribute20 = hr_api.g_varchar2) then
794: p_rec.attribute20 :=
795: pqh_cei_shd.g_old_rec.attribute20;
796: End If;
797: If (p_rec.attribute21 = hr_api.g_varchar2) then
798: p_rec.attribute21 :=
799: pqh_cei_shd.g_old_rec.attribute21;
800: End If;
801: If (p_rec.attribute22 = hr_api.g_varchar2) then

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

797: If (p_rec.attribute21 = hr_api.g_varchar2) then
798: p_rec.attribute21 :=
799: pqh_cei_shd.g_old_rec.attribute21;
800: End If;
801: If (p_rec.attribute22 = hr_api.g_varchar2) then
802: p_rec.attribute22 :=
803: pqh_cei_shd.g_old_rec.attribute22;
804: End If;
805: If (p_rec.attribute23 = hr_api.g_varchar2) then

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

801: If (p_rec.attribute22 = hr_api.g_varchar2) then
802: p_rec.attribute22 :=
803: pqh_cei_shd.g_old_rec.attribute22;
804: End If;
805: If (p_rec.attribute23 = hr_api.g_varchar2) then
806: p_rec.attribute23 :=
807: pqh_cei_shd.g_old_rec.attribute23;
808: End If;
809: If (p_rec.attribute24 = hr_api.g_varchar2) then

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

805: If (p_rec.attribute23 = hr_api.g_varchar2) then
806: p_rec.attribute23 :=
807: pqh_cei_shd.g_old_rec.attribute23;
808: End If;
809: If (p_rec.attribute24 = hr_api.g_varchar2) then
810: p_rec.attribute24 :=
811: pqh_cei_shd.g_old_rec.attribute24;
812: End If;
813: If (p_rec.attribute25 = hr_api.g_varchar2) then

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

809: If (p_rec.attribute24 = hr_api.g_varchar2) then
810: p_rec.attribute24 :=
811: pqh_cei_shd.g_old_rec.attribute24;
812: End If;
813: If (p_rec.attribute25 = hr_api.g_varchar2) then
814: p_rec.attribute25 :=
815: pqh_cei_shd.g_old_rec.attribute25;
816: End If;
817: If (p_rec.attribute26 = hr_api.g_varchar2) then

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

813: If (p_rec.attribute25 = hr_api.g_varchar2) then
814: p_rec.attribute25 :=
815: pqh_cei_shd.g_old_rec.attribute25;
816: End If;
817: If (p_rec.attribute26 = hr_api.g_varchar2) then
818: p_rec.attribute26 :=
819: pqh_cei_shd.g_old_rec.attribute26;
820: End If;
821: If (p_rec.attribute27 = hr_api.g_varchar2) then

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

817: If (p_rec.attribute26 = hr_api.g_varchar2) then
818: p_rec.attribute26 :=
819: pqh_cei_shd.g_old_rec.attribute26;
820: End If;
821: If (p_rec.attribute27 = hr_api.g_varchar2) then
822: p_rec.attribute27 :=
823: pqh_cei_shd.g_old_rec.attribute27;
824: End If;
825: If (p_rec.attribute28 = hr_api.g_varchar2) then

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

821: If (p_rec.attribute27 = hr_api.g_varchar2) then
822: p_rec.attribute27 :=
823: pqh_cei_shd.g_old_rec.attribute27;
824: End If;
825: If (p_rec.attribute28 = hr_api.g_varchar2) then
826: p_rec.attribute28 :=
827: pqh_cei_shd.g_old_rec.attribute28;
828: End If;
829: If (p_rec.attribute29 = hr_api.g_varchar2) then

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

825: If (p_rec.attribute28 = hr_api.g_varchar2) then
826: p_rec.attribute28 :=
827: pqh_cei_shd.g_old_rec.attribute28;
828: End If;
829: If (p_rec.attribute29 = hr_api.g_varchar2) then
830: p_rec.attribute29 :=
831: pqh_cei_shd.g_old_rec.attribute29;
832: End If;
833: If (p_rec.attribute30 = hr_api.g_varchar2) then

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

829: If (p_rec.attribute29 = hr_api.g_varchar2) then
830: p_rec.attribute29 :=
831: pqh_cei_shd.g_old_rec.attribute29;
832: End If;
833: If (p_rec.attribute30 = hr_api.g_varchar2) then
834: p_rec.attribute30 :=
835: pqh_cei_shd.g_old_rec.attribute30;
836: End If;
837: If (p_rec.attribute_category = hr_api.g_varchar2) then

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

833: If (p_rec.attribute30 = hr_api.g_varchar2) then
834: p_rec.attribute30 :=
835: pqh_cei_shd.g_old_rec.attribute30;
836: End If;
837: If (p_rec.attribute_category = hr_api.g_varchar2) then
838: p_rec.attribute_category :=
839: pqh_cei_shd.g_old_rec.attribute_category;
840: End If;
841: --

Line 905: ,p_corps_definition_id in number default hr_api.g_number

901: Procedure upd
902: (p_effective_date in date
903: ,p_corps_extra_info_id in number
904: ,p_object_version_number in out nocopy number
905: ,p_corps_definition_id in number default hr_api.g_number
906: ,p_information_type in varchar2 default hr_api.g_varchar2
907: ,p_information1 in varchar2 default hr_api.g_varchar2
908: ,p_information2 in varchar2 default hr_api.g_varchar2
909: ,p_information3 in varchar2 default hr_api.g_varchar2

Line 906: ,p_information_type in varchar2 default hr_api.g_varchar2

902: (p_effective_date in date
903: ,p_corps_extra_info_id in number
904: ,p_object_version_number in out nocopy number
905: ,p_corps_definition_id in number default hr_api.g_number
906: ,p_information_type in varchar2 default hr_api.g_varchar2
907: ,p_information1 in varchar2 default hr_api.g_varchar2
908: ,p_information2 in varchar2 default hr_api.g_varchar2
909: ,p_information3 in varchar2 default hr_api.g_varchar2
910: ,p_information4 in varchar2 default hr_api.g_varchar2

Line 907: ,p_information1 in varchar2 default hr_api.g_varchar2

903: ,p_corps_extra_info_id in number
904: ,p_object_version_number in out nocopy number
905: ,p_corps_definition_id in number default hr_api.g_number
906: ,p_information_type in varchar2 default hr_api.g_varchar2
907: ,p_information1 in varchar2 default hr_api.g_varchar2
908: ,p_information2 in varchar2 default hr_api.g_varchar2
909: ,p_information3 in varchar2 default hr_api.g_varchar2
910: ,p_information4 in varchar2 default hr_api.g_varchar2
911: ,p_information5 in varchar2 default hr_api.g_varchar2

Line 908: ,p_information2 in varchar2 default hr_api.g_varchar2

904: ,p_object_version_number in out nocopy number
905: ,p_corps_definition_id in number default hr_api.g_number
906: ,p_information_type in varchar2 default hr_api.g_varchar2
907: ,p_information1 in varchar2 default hr_api.g_varchar2
908: ,p_information2 in varchar2 default hr_api.g_varchar2
909: ,p_information3 in varchar2 default hr_api.g_varchar2
910: ,p_information4 in varchar2 default hr_api.g_varchar2
911: ,p_information5 in varchar2 default hr_api.g_varchar2
912: ,p_information6 in varchar2 default hr_api.g_varchar2

Line 909: ,p_information3 in varchar2 default hr_api.g_varchar2

905: ,p_corps_definition_id in number default hr_api.g_number
906: ,p_information_type in varchar2 default hr_api.g_varchar2
907: ,p_information1 in varchar2 default hr_api.g_varchar2
908: ,p_information2 in varchar2 default hr_api.g_varchar2
909: ,p_information3 in varchar2 default hr_api.g_varchar2
910: ,p_information4 in varchar2 default hr_api.g_varchar2
911: ,p_information5 in varchar2 default hr_api.g_varchar2
912: ,p_information6 in varchar2 default hr_api.g_varchar2
913: ,p_information7 in varchar2 default hr_api.g_varchar2

Line 910: ,p_information4 in varchar2 default hr_api.g_varchar2

906: ,p_information_type in varchar2 default hr_api.g_varchar2
907: ,p_information1 in varchar2 default hr_api.g_varchar2
908: ,p_information2 in varchar2 default hr_api.g_varchar2
909: ,p_information3 in varchar2 default hr_api.g_varchar2
910: ,p_information4 in varchar2 default hr_api.g_varchar2
911: ,p_information5 in varchar2 default hr_api.g_varchar2
912: ,p_information6 in varchar2 default hr_api.g_varchar2
913: ,p_information7 in varchar2 default hr_api.g_varchar2
914: ,p_information8 in varchar2 default hr_api.g_varchar2

Line 911: ,p_information5 in varchar2 default hr_api.g_varchar2

907: ,p_information1 in varchar2 default hr_api.g_varchar2
908: ,p_information2 in varchar2 default hr_api.g_varchar2
909: ,p_information3 in varchar2 default hr_api.g_varchar2
910: ,p_information4 in varchar2 default hr_api.g_varchar2
911: ,p_information5 in varchar2 default hr_api.g_varchar2
912: ,p_information6 in varchar2 default hr_api.g_varchar2
913: ,p_information7 in varchar2 default hr_api.g_varchar2
914: ,p_information8 in varchar2 default hr_api.g_varchar2
915: ,p_information9 in varchar2 default hr_api.g_varchar2

Line 912: ,p_information6 in varchar2 default hr_api.g_varchar2

908: ,p_information2 in varchar2 default hr_api.g_varchar2
909: ,p_information3 in varchar2 default hr_api.g_varchar2
910: ,p_information4 in varchar2 default hr_api.g_varchar2
911: ,p_information5 in varchar2 default hr_api.g_varchar2
912: ,p_information6 in varchar2 default hr_api.g_varchar2
913: ,p_information7 in varchar2 default hr_api.g_varchar2
914: ,p_information8 in varchar2 default hr_api.g_varchar2
915: ,p_information9 in varchar2 default hr_api.g_varchar2
916: ,p_information10 in varchar2 default hr_api.g_varchar2

Line 913: ,p_information7 in varchar2 default hr_api.g_varchar2

909: ,p_information3 in varchar2 default hr_api.g_varchar2
910: ,p_information4 in varchar2 default hr_api.g_varchar2
911: ,p_information5 in varchar2 default hr_api.g_varchar2
912: ,p_information6 in varchar2 default hr_api.g_varchar2
913: ,p_information7 in varchar2 default hr_api.g_varchar2
914: ,p_information8 in varchar2 default hr_api.g_varchar2
915: ,p_information9 in varchar2 default hr_api.g_varchar2
916: ,p_information10 in varchar2 default hr_api.g_varchar2
917: ,p_information11 in varchar2 default hr_api.g_varchar2

Line 914: ,p_information8 in varchar2 default hr_api.g_varchar2

910: ,p_information4 in varchar2 default hr_api.g_varchar2
911: ,p_information5 in varchar2 default hr_api.g_varchar2
912: ,p_information6 in varchar2 default hr_api.g_varchar2
913: ,p_information7 in varchar2 default hr_api.g_varchar2
914: ,p_information8 in varchar2 default hr_api.g_varchar2
915: ,p_information9 in varchar2 default hr_api.g_varchar2
916: ,p_information10 in varchar2 default hr_api.g_varchar2
917: ,p_information11 in varchar2 default hr_api.g_varchar2
918: ,p_information12 in varchar2 default hr_api.g_varchar2

Line 915: ,p_information9 in varchar2 default hr_api.g_varchar2

911: ,p_information5 in varchar2 default hr_api.g_varchar2
912: ,p_information6 in varchar2 default hr_api.g_varchar2
913: ,p_information7 in varchar2 default hr_api.g_varchar2
914: ,p_information8 in varchar2 default hr_api.g_varchar2
915: ,p_information9 in varchar2 default hr_api.g_varchar2
916: ,p_information10 in varchar2 default hr_api.g_varchar2
917: ,p_information11 in varchar2 default hr_api.g_varchar2
918: ,p_information12 in varchar2 default hr_api.g_varchar2
919: ,p_information13 in varchar2 default hr_api.g_varchar2

Line 916: ,p_information10 in varchar2 default hr_api.g_varchar2

912: ,p_information6 in varchar2 default hr_api.g_varchar2
913: ,p_information7 in varchar2 default hr_api.g_varchar2
914: ,p_information8 in varchar2 default hr_api.g_varchar2
915: ,p_information9 in varchar2 default hr_api.g_varchar2
916: ,p_information10 in varchar2 default hr_api.g_varchar2
917: ,p_information11 in varchar2 default hr_api.g_varchar2
918: ,p_information12 in varchar2 default hr_api.g_varchar2
919: ,p_information13 in varchar2 default hr_api.g_varchar2
920: ,p_information14 in varchar2 default hr_api.g_varchar2

Line 917: ,p_information11 in varchar2 default hr_api.g_varchar2

913: ,p_information7 in varchar2 default hr_api.g_varchar2
914: ,p_information8 in varchar2 default hr_api.g_varchar2
915: ,p_information9 in varchar2 default hr_api.g_varchar2
916: ,p_information10 in varchar2 default hr_api.g_varchar2
917: ,p_information11 in varchar2 default hr_api.g_varchar2
918: ,p_information12 in varchar2 default hr_api.g_varchar2
919: ,p_information13 in varchar2 default hr_api.g_varchar2
920: ,p_information14 in varchar2 default hr_api.g_varchar2
921: ,p_information15 in varchar2 default hr_api.g_varchar2

Line 918: ,p_information12 in varchar2 default hr_api.g_varchar2

914: ,p_information8 in varchar2 default hr_api.g_varchar2
915: ,p_information9 in varchar2 default hr_api.g_varchar2
916: ,p_information10 in varchar2 default hr_api.g_varchar2
917: ,p_information11 in varchar2 default hr_api.g_varchar2
918: ,p_information12 in varchar2 default hr_api.g_varchar2
919: ,p_information13 in varchar2 default hr_api.g_varchar2
920: ,p_information14 in varchar2 default hr_api.g_varchar2
921: ,p_information15 in varchar2 default hr_api.g_varchar2
922: ,p_information16 in varchar2 default hr_api.g_varchar2

Line 919: ,p_information13 in varchar2 default hr_api.g_varchar2

915: ,p_information9 in varchar2 default hr_api.g_varchar2
916: ,p_information10 in varchar2 default hr_api.g_varchar2
917: ,p_information11 in varchar2 default hr_api.g_varchar2
918: ,p_information12 in varchar2 default hr_api.g_varchar2
919: ,p_information13 in varchar2 default hr_api.g_varchar2
920: ,p_information14 in varchar2 default hr_api.g_varchar2
921: ,p_information15 in varchar2 default hr_api.g_varchar2
922: ,p_information16 in varchar2 default hr_api.g_varchar2
923: ,p_information17 in varchar2 default hr_api.g_varchar2

Line 920: ,p_information14 in varchar2 default hr_api.g_varchar2

916: ,p_information10 in varchar2 default hr_api.g_varchar2
917: ,p_information11 in varchar2 default hr_api.g_varchar2
918: ,p_information12 in varchar2 default hr_api.g_varchar2
919: ,p_information13 in varchar2 default hr_api.g_varchar2
920: ,p_information14 in varchar2 default hr_api.g_varchar2
921: ,p_information15 in varchar2 default hr_api.g_varchar2
922: ,p_information16 in varchar2 default hr_api.g_varchar2
923: ,p_information17 in varchar2 default hr_api.g_varchar2
924: ,p_information18 in varchar2 default hr_api.g_varchar2

Line 921: ,p_information15 in varchar2 default hr_api.g_varchar2

917: ,p_information11 in varchar2 default hr_api.g_varchar2
918: ,p_information12 in varchar2 default hr_api.g_varchar2
919: ,p_information13 in varchar2 default hr_api.g_varchar2
920: ,p_information14 in varchar2 default hr_api.g_varchar2
921: ,p_information15 in varchar2 default hr_api.g_varchar2
922: ,p_information16 in varchar2 default hr_api.g_varchar2
923: ,p_information17 in varchar2 default hr_api.g_varchar2
924: ,p_information18 in varchar2 default hr_api.g_varchar2
925: ,p_information19 in varchar2 default hr_api.g_varchar2

Line 922: ,p_information16 in varchar2 default hr_api.g_varchar2

918: ,p_information12 in varchar2 default hr_api.g_varchar2
919: ,p_information13 in varchar2 default hr_api.g_varchar2
920: ,p_information14 in varchar2 default hr_api.g_varchar2
921: ,p_information15 in varchar2 default hr_api.g_varchar2
922: ,p_information16 in varchar2 default hr_api.g_varchar2
923: ,p_information17 in varchar2 default hr_api.g_varchar2
924: ,p_information18 in varchar2 default hr_api.g_varchar2
925: ,p_information19 in varchar2 default hr_api.g_varchar2
926: ,p_information20 in varchar2 default hr_api.g_varchar2

Line 923: ,p_information17 in varchar2 default hr_api.g_varchar2

919: ,p_information13 in varchar2 default hr_api.g_varchar2
920: ,p_information14 in varchar2 default hr_api.g_varchar2
921: ,p_information15 in varchar2 default hr_api.g_varchar2
922: ,p_information16 in varchar2 default hr_api.g_varchar2
923: ,p_information17 in varchar2 default hr_api.g_varchar2
924: ,p_information18 in varchar2 default hr_api.g_varchar2
925: ,p_information19 in varchar2 default hr_api.g_varchar2
926: ,p_information20 in varchar2 default hr_api.g_varchar2
927: ,p_information21 in varchar2 default hr_api.g_varchar2

Line 924: ,p_information18 in varchar2 default hr_api.g_varchar2

920: ,p_information14 in varchar2 default hr_api.g_varchar2
921: ,p_information15 in varchar2 default hr_api.g_varchar2
922: ,p_information16 in varchar2 default hr_api.g_varchar2
923: ,p_information17 in varchar2 default hr_api.g_varchar2
924: ,p_information18 in varchar2 default hr_api.g_varchar2
925: ,p_information19 in varchar2 default hr_api.g_varchar2
926: ,p_information20 in varchar2 default hr_api.g_varchar2
927: ,p_information21 in varchar2 default hr_api.g_varchar2
928: ,p_information22 in varchar2 default hr_api.g_varchar2

Line 925: ,p_information19 in varchar2 default hr_api.g_varchar2

921: ,p_information15 in varchar2 default hr_api.g_varchar2
922: ,p_information16 in varchar2 default hr_api.g_varchar2
923: ,p_information17 in varchar2 default hr_api.g_varchar2
924: ,p_information18 in varchar2 default hr_api.g_varchar2
925: ,p_information19 in varchar2 default hr_api.g_varchar2
926: ,p_information20 in varchar2 default hr_api.g_varchar2
927: ,p_information21 in varchar2 default hr_api.g_varchar2
928: ,p_information22 in varchar2 default hr_api.g_varchar2
929: ,p_information23 in varchar2 default hr_api.g_varchar2

Line 926: ,p_information20 in varchar2 default hr_api.g_varchar2

922: ,p_information16 in varchar2 default hr_api.g_varchar2
923: ,p_information17 in varchar2 default hr_api.g_varchar2
924: ,p_information18 in varchar2 default hr_api.g_varchar2
925: ,p_information19 in varchar2 default hr_api.g_varchar2
926: ,p_information20 in varchar2 default hr_api.g_varchar2
927: ,p_information21 in varchar2 default hr_api.g_varchar2
928: ,p_information22 in varchar2 default hr_api.g_varchar2
929: ,p_information23 in varchar2 default hr_api.g_varchar2
930: ,p_information24 in varchar2 default hr_api.g_varchar2

Line 927: ,p_information21 in varchar2 default hr_api.g_varchar2

923: ,p_information17 in varchar2 default hr_api.g_varchar2
924: ,p_information18 in varchar2 default hr_api.g_varchar2
925: ,p_information19 in varchar2 default hr_api.g_varchar2
926: ,p_information20 in varchar2 default hr_api.g_varchar2
927: ,p_information21 in varchar2 default hr_api.g_varchar2
928: ,p_information22 in varchar2 default hr_api.g_varchar2
929: ,p_information23 in varchar2 default hr_api.g_varchar2
930: ,p_information24 in varchar2 default hr_api.g_varchar2
931: ,p_information25 in varchar2 default hr_api.g_varchar2

Line 928: ,p_information22 in varchar2 default hr_api.g_varchar2

924: ,p_information18 in varchar2 default hr_api.g_varchar2
925: ,p_information19 in varchar2 default hr_api.g_varchar2
926: ,p_information20 in varchar2 default hr_api.g_varchar2
927: ,p_information21 in varchar2 default hr_api.g_varchar2
928: ,p_information22 in varchar2 default hr_api.g_varchar2
929: ,p_information23 in varchar2 default hr_api.g_varchar2
930: ,p_information24 in varchar2 default hr_api.g_varchar2
931: ,p_information25 in varchar2 default hr_api.g_varchar2
932: ,p_information26 in varchar2 default hr_api.g_varchar2

Line 929: ,p_information23 in varchar2 default hr_api.g_varchar2

925: ,p_information19 in varchar2 default hr_api.g_varchar2
926: ,p_information20 in varchar2 default hr_api.g_varchar2
927: ,p_information21 in varchar2 default hr_api.g_varchar2
928: ,p_information22 in varchar2 default hr_api.g_varchar2
929: ,p_information23 in varchar2 default hr_api.g_varchar2
930: ,p_information24 in varchar2 default hr_api.g_varchar2
931: ,p_information25 in varchar2 default hr_api.g_varchar2
932: ,p_information26 in varchar2 default hr_api.g_varchar2
933: ,p_information27 in varchar2 default hr_api.g_varchar2

Line 930: ,p_information24 in varchar2 default hr_api.g_varchar2

926: ,p_information20 in varchar2 default hr_api.g_varchar2
927: ,p_information21 in varchar2 default hr_api.g_varchar2
928: ,p_information22 in varchar2 default hr_api.g_varchar2
929: ,p_information23 in varchar2 default hr_api.g_varchar2
930: ,p_information24 in varchar2 default hr_api.g_varchar2
931: ,p_information25 in varchar2 default hr_api.g_varchar2
932: ,p_information26 in varchar2 default hr_api.g_varchar2
933: ,p_information27 in varchar2 default hr_api.g_varchar2
934: ,p_information28 in varchar2 default hr_api.g_varchar2

Line 931: ,p_information25 in varchar2 default hr_api.g_varchar2

927: ,p_information21 in varchar2 default hr_api.g_varchar2
928: ,p_information22 in varchar2 default hr_api.g_varchar2
929: ,p_information23 in varchar2 default hr_api.g_varchar2
930: ,p_information24 in varchar2 default hr_api.g_varchar2
931: ,p_information25 in varchar2 default hr_api.g_varchar2
932: ,p_information26 in varchar2 default hr_api.g_varchar2
933: ,p_information27 in varchar2 default hr_api.g_varchar2
934: ,p_information28 in varchar2 default hr_api.g_varchar2
935: ,p_information29 in varchar2 default hr_api.g_varchar2

Line 932: ,p_information26 in varchar2 default hr_api.g_varchar2

928: ,p_information22 in varchar2 default hr_api.g_varchar2
929: ,p_information23 in varchar2 default hr_api.g_varchar2
930: ,p_information24 in varchar2 default hr_api.g_varchar2
931: ,p_information25 in varchar2 default hr_api.g_varchar2
932: ,p_information26 in varchar2 default hr_api.g_varchar2
933: ,p_information27 in varchar2 default hr_api.g_varchar2
934: ,p_information28 in varchar2 default hr_api.g_varchar2
935: ,p_information29 in varchar2 default hr_api.g_varchar2
936: ,p_information30 in varchar2 default hr_api.g_varchar2

Line 933: ,p_information27 in varchar2 default hr_api.g_varchar2

929: ,p_information23 in varchar2 default hr_api.g_varchar2
930: ,p_information24 in varchar2 default hr_api.g_varchar2
931: ,p_information25 in varchar2 default hr_api.g_varchar2
932: ,p_information26 in varchar2 default hr_api.g_varchar2
933: ,p_information27 in varchar2 default hr_api.g_varchar2
934: ,p_information28 in varchar2 default hr_api.g_varchar2
935: ,p_information29 in varchar2 default hr_api.g_varchar2
936: ,p_information30 in varchar2 default hr_api.g_varchar2
937: ,p_information_category in varchar2 default hr_api.g_varchar2

Line 934: ,p_information28 in varchar2 default hr_api.g_varchar2

930: ,p_information24 in varchar2 default hr_api.g_varchar2
931: ,p_information25 in varchar2 default hr_api.g_varchar2
932: ,p_information26 in varchar2 default hr_api.g_varchar2
933: ,p_information27 in varchar2 default hr_api.g_varchar2
934: ,p_information28 in varchar2 default hr_api.g_varchar2
935: ,p_information29 in varchar2 default hr_api.g_varchar2
936: ,p_information30 in varchar2 default hr_api.g_varchar2
937: ,p_information_category in varchar2 default hr_api.g_varchar2
938: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 935: ,p_information29 in varchar2 default hr_api.g_varchar2

931: ,p_information25 in varchar2 default hr_api.g_varchar2
932: ,p_information26 in varchar2 default hr_api.g_varchar2
933: ,p_information27 in varchar2 default hr_api.g_varchar2
934: ,p_information28 in varchar2 default hr_api.g_varchar2
935: ,p_information29 in varchar2 default hr_api.g_varchar2
936: ,p_information30 in varchar2 default hr_api.g_varchar2
937: ,p_information_category in varchar2 default hr_api.g_varchar2
938: ,p_attribute1 in varchar2 default hr_api.g_varchar2
939: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 936: ,p_information30 in varchar2 default hr_api.g_varchar2

932: ,p_information26 in varchar2 default hr_api.g_varchar2
933: ,p_information27 in varchar2 default hr_api.g_varchar2
934: ,p_information28 in varchar2 default hr_api.g_varchar2
935: ,p_information29 in varchar2 default hr_api.g_varchar2
936: ,p_information30 in varchar2 default hr_api.g_varchar2
937: ,p_information_category in varchar2 default hr_api.g_varchar2
938: ,p_attribute1 in varchar2 default hr_api.g_varchar2
939: ,p_attribute2 in varchar2 default hr_api.g_varchar2
940: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 937: ,p_information_category in varchar2 default hr_api.g_varchar2

933: ,p_information27 in varchar2 default hr_api.g_varchar2
934: ,p_information28 in varchar2 default hr_api.g_varchar2
935: ,p_information29 in varchar2 default hr_api.g_varchar2
936: ,p_information30 in varchar2 default hr_api.g_varchar2
937: ,p_information_category in varchar2 default hr_api.g_varchar2
938: ,p_attribute1 in varchar2 default hr_api.g_varchar2
939: ,p_attribute2 in varchar2 default hr_api.g_varchar2
940: ,p_attribute3 in varchar2 default hr_api.g_varchar2
941: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 938: ,p_attribute1 in varchar2 default hr_api.g_varchar2

934: ,p_information28 in varchar2 default hr_api.g_varchar2
935: ,p_information29 in varchar2 default hr_api.g_varchar2
936: ,p_information30 in varchar2 default hr_api.g_varchar2
937: ,p_information_category in varchar2 default hr_api.g_varchar2
938: ,p_attribute1 in varchar2 default hr_api.g_varchar2
939: ,p_attribute2 in varchar2 default hr_api.g_varchar2
940: ,p_attribute3 in varchar2 default hr_api.g_varchar2
941: ,p_attribute4 in varchar2 default hr_api.g_varchar2
942: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 939: ,p_attribute2 in varchar2 default hr_api.g_varchar2

935: ,p_information29 in varchar2 default hr_api.g_varchar2
936: ,p_information30 in varchar2 default hr_api.g_varchar2
937: ,p_information_category in varchar2 default hr_api.g_varchar2
938: ,p_attribute1 in varchar2 default hr_api.g_varchar2
939: ,p_attribute2 in varchar2 default hr_api.g_varchar2
940: ,p_attribute3 in varchar2 default hr_api.g_varchar2
941: ,p_attribute4 in varchar2 default hr_api.g_varchar2
942: ,p_attribute5 in varchar2 default hr_api.g_varchar2
943: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 940: ,p_attribute3 in varchar2 default hr_api.g_varchar2

936: ,p_information30 in varchar2 default hr_api.g_varchar2
937: ,p_information_category in varchar2 default hr_api.g_varchar2
938: ,p_attribute1 in varchar2 default hr_api.g_varchar2
939: ,p_attribute2 in varchar2 default hr_api.g_varchar2
940: ,p_attribute3 in varchar2 default hr_api.g_varchar2
941: ,p_attribute4 in varchar2 default hr_api.g_varchar2
942: ,p_attribute5 in varchar2 default hr_api.g_varchar2
943: ,p_attribute6 in varchar2 default hr_api.g_varchar2
944: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 941: ,p_attribute4 in varchar2 default hr_api.g_varchar2

937: ,p_information_category in varchar2 default hr_api.g_varchar2
938: ,p_attribute1 in varchar2 default hr_api.g_varchar2
939: ,p_attribute2 in varchar2 default hr_api.g_varchar2
940: ,p_attribute3 in varchar2 default hr_api.g_varchar2
941: ,p_attribute4 in varchar2 default hr_api.g_varchar2
942: ,p_attribute5 in varchar2 default hr_api.g_varchar2
943: ,p_attribute6 in varchar2 default hr_api.g_varchar2
944: ,p_attribute7 in varchar2 default hr_api.g_varchar2
945: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 942: ,p_attribute5 in varchar2 default hr_api.g_varchar2

938: ,p_attribute1 in varchar2 default hr_api.g_varchar2
939: ,p_attribute2 in varchar2 default hr_api.g_varchar2
940: ,p_attribute3 in varchar2 default hr_api.g_varchar2
941: ,p_attribute4 in varchar2 default hr_api.g_varchar2
942: ,p_attribute5 in varchar2 default hr_api.g_varchar2
943: ,p_attribute6 in varchar2 default hr_api.g_varchar2
944: ,p_attribute7 in varchar2 default hr_api.g_varchar2
945: ,p_attribute8 in varchar2 default hr_api.g_varchar2
946: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 943: ,p_attribute6 in varchar2 default hr_api.g_varchar2

939: ,p_attribute2 in varchar2 default hr_api.g_varchar2
940: ,p_attribute3 in varchar2 default hr_api.g_varchar2
941: ,p_attribute4 in varchar2 default hr_api.g_varchar2
942: ,p_attribute5 in varchar2 default hr_api.g_varchar2
943: ,p_attribute6 in varchar2 default hr_api.g_varchar2
944: ,p_attribute7 in varchar2 default hr_api.g_varchar2
945: ,p_attribute8 in varchar2 default hr_api.g_varchar2
946: ,p_attribute9 in varchar2 default hr_api.g_varchar2
947: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 944: ,p_attribute7 in varchar2 default hr_api.g_varchar2

940: ,p_attribute3 in varchar2 default hr_api.g_varchar2
941: ,p_attribute4 in varchar2 default hr_api.g_varchar2
942: ,p_attribute5 in varchar2 default hr_api.g_varchar2
943: ,p_attribute6 in varchar2 default hr_api.g_varchar2
944: ,p_attribute7 in varchar2 default hr_api.g_varchar2
945: ,p_attribute8 in varchar2 default hr_api.g_varchar2
946: ,p_attribute9 in varchar2 default hr_api.g_varchar2
947: ,p_attribute10 in varchar2 default hr_api.g_varchar2
948: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 945: ,p_attribute8 in varchar2 default hr_api.g_varchar2

941: ,p_attribute4 in varchar2 default hr_api.g_varchar2
942: ,p_attribute5 in varchar2 default hr_api.g_varchar2
943: ,p_attribute6 in varchar2 default hr_api.g_varchar2
944: ,p_attribute7 in varchar2 default hr_api.g_varchar2
945: ,p_attribute8 in varchar2 default hr_api.g_varchar2
946: ,p_attribute9 in varchar2 default hr_api.g_varchar2
947: ,p_attribute10 in varchar2 default hr_api.g_varchar2
948: ,p_attribute11 in varchar2 default hr_api.g_varchar2
949: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 946: ,p_attribute9 in varchar2 default hr_api.g_varchar2

942: ,p_attribute5 in varchar2 default hr_api.g_varchar2
943: ,p_attribute6 in varchar2 default hr_api.g_varchar2
944: ,p_attribute7 in varchar2 default hr_api.g_varchar2
945: ,p_attribute8 in varchar2 default hr_api.g_varchar2
946: ,p_attribute9 in varchar2 default hr_api.g_varchar2
947: ,p_attribute10 in varchar2 default hr_api.g_varchar2
948: ,p_attribute11 in varchar2 default hr_api.g_varchar2
949: ,p_attribute12 in varchar2 default hr_api.g_varchar2
950: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 947: ,p_attribute10 in varchar2 default hr_api.g_varchar2

943: ,p_attribute6 in varchar2 default hr_api.g_varchar2
944: ,p_attribute7 in varchar2 default hr_api.g_varchar2
945: ,p_attribute8 in varchar2 default hr_api.g_varchar2
946: ,p_attribute9 in varchar2 default hr_api.g_varchar2
947: ,p_attribute10 in varchar2 default hr_api.g_varchar2
948: ,p_attribute11 in varchar2 default hr_api.g_varchar2
949: ,p_attribute12 in varchar2 default hr_api.g_varchar2
950: ,p_attribute13 in varchar2 default hr_api.g_varchar2
951: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 948: ,p_attribute11 in varchar2 default hr_api.g_varchar2

944: ,p_attribute7 in varchar2 default hr_api.g_varchar2
945: ,p_attribute8 in varchar2 default hr_api.g_varchar2
946: ,p_attribute9 in varchar2 default hr_api.g_varchar2
947: ,p_attribute10 in varchar2 default hr_api.g_varchar2
948: ,p_attribute11 in varchar2 default hr_api.g_varchar2
949: ,p_attribute12 in varchar2 default hr_api.g_varchar2
950: ,p_attribute13 in varchar2 default hr_api.g_varchar2
951: ,p_attribute14 in varchar2 default hr_api.g_varchar2
952: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 949: ,p_attribute12 in varchar2 default hr_api.g_varchar2

945: ,p_attribute8 in varchar2 default hr_api.g_varchar2
946: ,p_attribute9 in varchar2 default hr_api.g_varchar2
947: ,p_attribute10 in varchar2 default hr_api.g_varchar2
948: ,p_attribute11 in varchar2 default hr_api.g_varchar2
949: ,p_attribute12 in varchar2 default hr_api.g_varchar2
950: ,p_attribute13 in varchar2 default hr_api.g_varchar2
951: ,p_attribute14 in varchar2 default hr_api.g_varchar2
952: ,p_attribute15 in varchar2 default hr_api.g_varchar2
953: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 950: ,p_attribute13 in varchar2 default hr_api.g_varchar2

946: ,p_attribute9 in varchar2 default hr_api.g_varchar2
947: ,p_attribute10 in varchar2 default hr_api.g_varchar2
948: ,p_attribute11 in varchar2 default hr_api.g_varchar2
949: ,p_attribute12 in varchar2 default hr_api.g_varchar2
950: ,p_attribute13 in varchar2 default hr_api.g_varchar2
951: ,p_attribute14 in varchar2 default hr_api.g_varchar2
952: ,p_attribute15 in varchar2 default hr_api.g_varchar2
953: ,p_attribute16 in varchar2 default hr_api.g_varchar2
954: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 951: ,p_attribute14 in varchar2 default hr_api.g_varchar2

947: ,p_attribute10 in varchar2 default hr_api.g_varchar2
948: ,p_attribute11 in varchar2 default hr_api.g_varchar2
949: ,p_attribute12 in varchar2 default hr_api.g_varchar2
950: ,p_attribute13 in varchar2 default hr_api.g_varchar2
951: ,p_attribute14 in varchar2 default hr_api.g_varchar2
952: ,p_attribute15 in varchar2 default hr_api.g_varchar2
953: ,p_attribute16 in varchar2 default hr_api.g_varchar2
954: ,p_attribute17 in varchar2 default hr_api.g_varchar2
955: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 952: ,p_attribute15 in varchar2 default hr_api.g_varchar2

948: ,p_attribute11 in varchar2 default hr_api.g_varchar2
949: ,p_attribute12 in varchar2 default hr_api.g_varchar2
950: ,p_attribute13 in varchar2 default hr_api.g_varchar2
951: ,p_attribute14 in varchar2 default hr_api.g_varchar2
952: ,p_attribute15 in varchar2 default hr_api.g_varchar2
953: ,p_attribute16 in varchar2 default hr_api.g_varchar2
954: ,p_attribute17 in varchar2 default hr_api.g_varchar2
955: ,p_attribute18 in varchar2 default hr_api.g_varchar2
956: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 953: ,p_attribute16 in varchar2 default hr_api.g_varchar2

949: ,p_attribute12 in varchar2 default hr_api.g_varchar2
950: ,p_attribute13 in varchar2 default hr_api.g_varchar2
951: ,p_attribute14 in varchar2 default hr_api.g_varchar2
952: ,p_attribute15 in varchar2 default hr_api.g_varchar2
953: ,p_attribute16 in varchar2 default hr_api.g_varchar2
954: ,p_attribute17 in varchar2 default hr_api.g_varchar2
955: ,p_attribute18 in varchar2 default hr_api.g_varchar2
956: ,p_attribute19 in varchar2 default hr_api.g_varchar2
957: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 954: ,p_attribute17 in varchar2 default hr_api.g_varchar2

950: ,p_attribute13 in varchar2 default hr_api.g_varchar2
951: ,p_attribute14 in varchar2 default hr_api.g_varchar2
952: ,p_attribute15 in varchar2 default hr_api.g_varchar2
953: ,p_attribute16 in varchar2 default hr_api.g_varchar2
954: ,p_attribute17 in varchar2 default hr_api.g_varchar2
955: ,p_attribute18 in varchar2 default hr_api.g_varchar2
956: ,p_attribute19 in varchar2 default hr_api.g_varchar2
957: ,p_attribute20 in varchar2 default hr_api.g_varchar2
958: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 955: ,p_attribute18 in varchar2 default hr_api.g_varchar2

951: ,p_attribute14 in varchar2 default hr_api.g_varchar2
952: ,p_attribute15 in varchar2 default hr_api.g_varchar2
953: ,p_attribute16 in varchar2 default hr_api.g_varchar2
954: ,p_attribute17 in varchar2 default hr_api.g_varchar2
955: ,p_attribute18 in varchar2 default hr_api.g_varchar2
956: ,p_attribute19 in varchar2 default hr_api.g_varchar2
957: ,p_attribute20 in varchar2 default hr_api.g_varchar2
958: ,p_attribute21 in varchar2 default hr_api.g_varchar2
959: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 956: ,p_attribute19 in varchar2 default hr_api.g_varchar2

952: ,p_attribute15 in varchar2 default hr_api.g_varchar2
953: ,p_attribute16 in varchar2 default hr_api.g_varchar2
954: ,p_attribute17 in varchar2 default hr_api.g_varchar2
955: ,p_attribute18 in varchar2 default hr_api.g_varchar2
956: ,p_attribute19 in varchar2 default hr_api.g_varchar2
957: ,p_attribute20 in varchar2 default hr_api.g_varchar2
958: ,p_attribute21 in varchar2 default hr_api.g_varchar2
959: ,p_attribute22 in varchar2 default hr_api.g_varchar2
960: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 957: ,p_attribute20 in varchar2 default hr_api.g_varchar2

953: ,p_attribute16 in varchar2 default hr_api.g_varchar2
954: ,p_attribute17 in varchar2 default hr_api.g_varchar2
955: ,p_attribute18 in varchar2 default hr_api.g_varchar2
956: ,p_attribute19 in varchar2 default hr_api.g_varchar2
957: ,p_attribute20 in varchar2 default hr_api.g_varchar2
958: ,p_attribute21 in varchar2 default hr_api.g_varchar2
959: ,p_attribute22 in varchar2 default hr_api.g_varchar2
960: ,p_attribute23 in varchar2 default hr_api.g_varchar2
961: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 958: ,p_attribute21 in varchar2 default hr_api.g_varchar2

954: ,p_attribute17 in varchar2 default hr_api.g_varchar2
955: ,p_attribute18 in varchar2 default hr_api.g_varchar2
956: ,p_attribute19 in varchar2 default hr_api.g_varchar2
957: ,p_attribute20 in varchar2 default hr_api.g_varchar2
958: ,p_attribute21 in varchar2 default hr_api.g_varchar2
959: ,p_attribute22 in varchar2 default hr_api.g_varchar2
960: ,p_attribute23 in varchar2 default hr_api.g_varchar2
961: ,p_attribute24 in varchar2 default hr_api.g_varchar2
962: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 959: ,p_attribute22 in varchar2 default hr_api.g_varchar2

955: ,p_attribute18 in varchar2 default hr_api.g_varchar2
956: ,p_attribute19 in varchar2 default hr_api.g_varchar2
957: ,p_attribute20 in varchar2 default hr_api.g_varchar2
958: ,p_attribute21 in varchar2 default hr_api.g_varchar2
959: ,p_attribute22 in varchar2 default hr_api.g_varchar2
960: ,p_attribute23 in varchar2 default hr_api.g_varchar2
961: ,p_attribute24 in varchar2 default hr_api.g_varchar2
962: ,p_attribute25 in varchar2 default hr_api.g_varchar2
963: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 960: ,p_attribute23 in varchar2 default hr_api.g_varchar2

956: ,p_attribute19 in varchar2 default hr_api.g_varchar2
957: ,p_attribute20 in varchar2 default hr_api.g_varchar2
958: ,p_attribute21 in varchar2 default hr_api.g_varchar2
959: ,p_attribute22 in varchar2 default hr_api.g_varchar2
960: ,p_attribute23 in varchar2 default hr_api.g_varchar2
961: ,p_attribute24 in varchar2 default hr_api.g_varchar2
962: ,p_attribute25 in varchar2 default hr_api.g_varchar2
963: ,p_attribute26 in varchar2 default hr_api.g_varchar2
964: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 961: ,p_attribute24 in varchar2 default hr_api.g_varchar2

957: ,p_attribute20 in varchar2 default hr_api.g_varchar2
958: ,p_attribute21 in varchar2 default hr_api.g_varchar2
959: ,p_attribute22 in varchar2 default hr_api.g_varchar2
960: ,p_attribute23 in varchar2 default hr_api.g_varchar2
961: ,p_attribute24 in varchar2 default hr_api.g_varchar2
962: ,p_attribute25 in varchar2 default hr_api.g_varchar2
963: ,p_attribute26 in varchar2 default hr_api.g_varchar2
964: ,p_attribute27 in varchar2 default hr_api.g_varchar2
965: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 962: ,p_attribute25 in varchar2 default hr_api.g_varchar2

958: ,p_attribute21 in varchar2 default hr_api.g_varchar2
959: ,p_attribute22 in varchar2 default hr_api.g_varchar2
960: ,p_attribute23 in varchar2 default hr_api.g_varchar2
961: ,p_attribute24 in varchar2 default hr_api.g_varchar2
962: ,p_attribute25 in varchar2 default hr_api.g_varchar2
963: ,p_attribute26 in varchar2 default hr_api.g_varchar2
964: ,p_attribute27 in varchar2 default hr_api.g_varchar2
965: ,p_attribute28 in varchar2 default hr_api.g_varchar2
966: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 963: ,p_attribute26 in varchar2 default hr_api.g_varchar2

959: ,p_attribute22 in varchar2 default hr_api.g_varchar2
960: ,p_attribute23 in varchar2 default hr_api.g_varchar2
961: ,p_attribute24 in varchar2 default hr_api.g_varchar2
962: ,p_attribute25 in varchar2 default hr_api.g_varchar2
963: ,p_attribute26 in varchar2 default hr_api.g_varchar2
964: ,p_attribute27 in varchar2 default hr_api.g_varchar2
965: ,p_attribute28 in varchar2 default hr_api.g_varchar2
966: ,p_attribute29 in varchar2 default hr_api.g_varchar2
967: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 964: ,p_attribute27 in varchar2 default hr_api.g_varchar2

960: ,p_attribute23 in varchar2 default hr_api.g_varchar2
961: ,p_attribute24 in varchar2 default hr_api.g_varchar2
962: ,p_attribute25 in varchar2 default hr_api.g_varchar2
963: ,p_attribute26 in varchar2 default hr_api.g_varchar2
964: ,p_attribute27 in varchar2 default hr_api.g_varchar2
965: ,p_attribute28 in varchar2 default hr_api.g_varchar2
966: ,p_attribute29 in varchar2 default hr_api.g_varchar2
967: ,p_attribute30 in varchar2 default hr_api.g_varchar2
968: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 965: ,p_attribute28 in varchar2 default hr_api.g_varchar2

961: ,p_attribute24 in varchar2 default hr_api.g_varchar2
962: ,p_attribute25 in varchar2 default hr_api.g_varchar2
963: ,p_attribute26 in varchar2 default hr_api.g_varchar2
964: ,p_attribute27 in varchar2 default hr_api.g_varchar2
965: ,p_attribute28 in varchar2 default hr_api.g_varchar2
966: ,p_attribute29 in varchar2 default hr_api.g_varchar2
967: ,p_attribute30 in varchar2 default hr_api.g_varchar2
968: ,p_attribute_category in varchar2 default hr_api.g_varchar2
969: ) is

Line 966: ,p_attribute29 in varchar2 default hr_api.g_varchar2

962: ,p_attribute25 in varchar2 default hr_api.g_varchar2
963: ,p_attribute26 in varchar2 default hr_api.g_varchar2
964: ,p_attribute27 in varchar2 default hr_api.g_varchar2
965: ,p_attribute28 in varchar2 default hr_api.g_varchar2
966: ,p_attribute29 in varchar2 default hr_api.g_varchar2
967: ,p_attribute30 in varchar2 default hr_api.g_varchar2
968: ,p_attribute_category in varchar2 default hr_api.g_varchar2
969: ) is
970: --

Line 967: ,p_attribute30 in varchar2 default hr_api.g_varchar2

963: ,p_attribute26 in varchar2 default hr_api.g_varchar2
964: ,p_attribute27 in varchar2 default hr_api.g_varchar2
965: ,p_attribute28 in varchar2 default hr_api.g_varchar2
966: ,p_attribute29 in varchar2 default hr_api.g_varchar2
967: ,p_attribute30 in varchar2 default hr_api.g_varchar2
968: ,p_attribute_category in varchar2 default hr_api.g_varchar2
969: ) is
970: --
971: l_rec pqh_cei_shd.g_rec_type;

Line 968: ,p_attribute_category in varchar2 default hr_api.g_varchar2

964: ,p_attribute27 in varchar2 default hr_api.g_varchar2
965: ,p_attribute28 in varchar2 default hr_api.g_varchar2
966: ,p_attribute29 in varchar2 default hr_api.g_varchar2
967: ,p_attribute30 in varchar2 default hr_api.g_varchar2
968: ,p_attribute_category in varchar2 default hr_api.g_varchar2
969: ) is
970: --
971: l_rec pqh_cei_shd.g_rec_type;
972: l_proc varchar2(72) := g_package||'upd';