DBA Data[Home] [Help]

APPS.PER_PGV_UPD dependencies on HR_API

Line 154: When hr_api.check_integrity_violated Then

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

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

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

Line 159: When hr_api.parent_integrity_violated Then

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

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

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

Line 164: When hr_api.unique_integrity_violated Then

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

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

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

Line 561: when hr_api.cannot_find_prog_unit then

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

Line 563: hr_api.cannot_find_prog_unit_error

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

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

622: -- p_rec plsql record structure
623: -- to see if a system default is being used. If a system default
624: -- is being used then we must set to the 'current' argument value.
625: --
626: If (p_rec.business_group_id = hr_api.g_number) then
627: p_rec.business_group_id :=
628: per_pgv_shd.g_old_rec.business_group_id;
629: End If;
630: If (p_rec.version_number = hr_api.g_number) then

Line 630: If (p_rec.version_number = hr_api.g_number) then

626: If (p_rec.business_group_id = hr_api.g_number) then
627: p_rec.business_group_id :=
628: per_pgv_shd.g_old_rec.business_group_id;
629: End If;
630: If (p_rec.version_number = hr_api.g_number) then
631: p_rec.version_number :=
632: per_pgv_shd.g_old_rec.version_number;
633: End If;
634: If (p_rec.hierarchy_id = hr_api.g_number) then

Line 634: If (p_rec.hierarchy_id = hr_api.g_number) then

630: If (p_rec.version_number = hr_api.g_number) then
631: p_rec.version_number :=
632: per_pgv_shd.g_old_rec.version_number;
633: End If;
634: If (p_rec.hierarchy_id = hr_api.g_number) then
635: p_rec.hierarchy_id :=
636: per_pgv_shd.g_old_rec.hierarchy_id;
637: End If;
638: If (p_rec.date_from = hr_api.g_date) then

Line 638: If (p_rec.date_from = hr_api.g_date) then

634: If (p_rec.hierarchy_id = hr_api.g_number) then
635: p_rec.hierarchy_id :=
636: per_pgv_shd.g_old_rec.hierarchy_id;
637: End If;
638: If (p_rec.date_from = hr_api.g_date) then
639: p_rec.date_from :=
640: per_pgv_shd.g_old_rec.date_from;
641: End If;
642: If (p_rec.date_to = hr_api.g_date) then

Line 642: If (p_rec.date_to = hr_api.g_date) then

638: If (p_rec.date_from = hr_api.g_date) then
639: p_rec.date_from :=
640: per_pgv_shd.g_old_rec.date_from;
641: End If;
642: If (p_rec.date_to = hr_api.g_date) then
643: p_rec.date_to :=
644: per_pgv_shd.g_old_rec.date_to;
645: End If;
646: If (p_rec.status = hr_api.g_varchar2) then

Line 646: If (p_rec.status = hr_api.g_varchar2) then

642: If (p_rec.date_to = hr_api.g_date) then
643: p_rec.date_to :=
644: per_pgv_shd.g_old_rec.date_to;
645: End If;
646: If (p_rec.status = hr_api.g_varchar2) then
647: p_rec.status :=
648: per_pgv_shd.g_old_rec.status;
649: End If;
650: If (p_rec.validate_flag = hr_api.g_varchar2) then

Line 650: If (p_rec.validate_flag = hr_api.g_varchar2) then

646: If (p_rec.status = hr_api.g_varchar2) then
647: p_rec.status :=
648: per_pgv_shd.g_old_rec.status;
649: End If;
650: If (p_rec.validate_flag = hr_api.g_varchar2) then
651: p_rec.validate_flag :=
652: per_pgv_shd.g_old_rec.validate_flag;
653: End If;
654: If (p_rec.request_id = hr_api.g_number) then

Line 654: If (p_rec.request_id = hr_api.g_number) then

650: If (p_rec.validate_flag = hr_api.g_varchar2) then
651: p_rec.validate_flag :=
652: per_pgv_shd.g_old_rec.validate_flag;
653: End If;
654: If (p_rec.request_id = hr_api.g_number) then
655: p_rec.request_id :=
656: per_pgv_shd.g_old_rec.request_id;
657: End If;
658: If (p_rec.program_application_id = hr_api.g_number) then

Line 658: If (p_rec.program_application_id = hr_api.g_number) then

654: If (p_rec.request_id = hr_api.g_number) then
655: p_rec.request_id :=
656: per_pgv_shd.g_old_rec.request_id;
657: End If;
658: If (p_rec.program_application_id = hr_api.g_number) then
659: p_rec.program_application_id :=
660: per_pgv_shd.g_old_rec.program_application_id;
661: End If;
662: If (p_rec.program_id = hr_api.g_number) then

Line 662: If (p_rec.program_id = hr_api.g_number) then

658: If (p_rec.program_application_id = hr_api.g_number) then
659: p_rec.program_application_id :=
660: per_pgv_shd.g_old_rec.program_application_id;
661: End If;
662: If (p_rec.program_id = hr_api.g_number) then
663: p_rec.program_id :=
664: per_pgv_shd.g_old_rec.program_id;
665: End If;
666: If (p_rec.program_update_date = hr_api.g_date) then

Line 666: If (p_rec.program_update_date = hr_api.g_date) then

662: If (p_rec.program_id = hr_api.g_number) then
663: p_rec.program_id :=
664: per_pgv_shd.g_old_rec.program_id;
665: End If;
666: If (p_rec.program_update_date = hr_api.g_date) then
667: p_rec.program_update_date :=
668: per_pgv_shd.g_old_rec.program_update_date;
669: End If;
670: If (p_rec.attribute_category = hr_api.g_varchar2) then

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

666: If (p_rec.program_update_date = hr_api.g_date) then
667: p_rec.program_update_date :=
668: per_pgv_shd.g_old_rec.program_update_date;
669: End If;
670: If (p_rec.attribute_category = hr_api.g_varchar2) then
671: p_rec.attribute_category :=
672: per_pgv_shd.g_old_rec.attribute_category;
673: End If;
674: If (p_rec.attribute1 = hr_api.g_varchar2) then

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

670: If (p_rec.attribute_category = hr_api.g_varchar2) then
671: p_rec.attribute_category :=
672: per_pgv_shd.g_old_rec.attribute_category;
673: End If;
674: If (p_rec.attribute1 = hr_api.g_varchar2) then
675: p_rec.attribute1 :=
676: per_pgv_shd.g_old_rec.attribute1;
677: End If;
678: If (p_rec.attribute2 = hr_api.g_varchar2) then

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

674: If (p_rec.attribute1 = hr_api.g_varchar2) then
675: p_rec.attribute1 :=
676: per_pgv_shd.g_old_rec.attribute1;
677: End If;
678: If (p_rec.attribute2 = hr_api.g_varchar2) then
679: p_rec.attribute2 :=
680: per_pgv_shd.g_old_rec.attribute2;
681: End If;
682: If (p_rec.attribute3 = hr_api.g_varchar2) then

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

678: If (p_rec.attribute2 = hr_api.g_varchar2) then
679: p_rec.attribute2 :=
680: per_pgv_shd.g_old_rec.attribute2;
681: End If;
682: If (p_rec.attribute3 = hr_api.g_varchar2) then
683: p_rec.attribute3 :=
684: per_pgv_shd.g_old_rec.attribute3;
685: End If;
686: If (p_rec.attribute4 = hr_api.g_varchar2) then

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

682: If (p_rec.attribute3 = hr_api.g_varchar2) then
683: p_rec.attribute3 :=
684: per_pgv_shd.g_old_rec.attribute3;
685: End If;
686: If (p_rec.attribute4 = hr_api.g_varchar2) then
687: p_rec.attribute4 :=
688: per_pgv_shd.g_old_rec.attribute4;
689: End If;
690: If (p_rec.attribute5 = hr_api.g_varchar2) then

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

686: If (p_rec.attribute4 = hr_api.g_varchar2) then
687: p_rec.attribute4 :=
688: per_pgv_shd.g_old_rec.attribute4;
689: End If;
690: If (p_rec.attribute5 = hr_api.g_varchar2) then
691: p_rec.attribute5 :=
692: per_pgv_shd.g_old_rec.attribute5;
693: End If;
694: If (p_rec.attribute6 = hr_api.g_varchar2) then

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

690: If (p_rec.attribute5 = hr_api.g_varchar2) then
691: p_rec.attribute5 :=
692: per_pgv_shd.g_old_rec.attribute5;
693: End If;
694: If (p_rec.attribute6 = hr_api.g_varchar2) then
695: p_rec.attribute6 :=
696: per_pgv_shd.g_old_rec.attribute6;
697: End If;
698: If (p_rec.attribute7 = hr_api.g_varchar2) then

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

694: If (p_rec.attribute6 = hr_api.g_varchar2) then
695: p_rec.attribute6 :=
696: per_pgv_shd.g_old_rec.attribute6;
697: End If;
698: If (p_rec.attribute7 = hr_api.g_varchar2) then
699: p_rec.attribute7 :=
700: per_pgv_shd.g_old_rec.attribute7;
701: End If;
702: If (p_rec.attribute8 = hr_api.g_varchar2) then

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

698: If (p_rec.attribute7 = hr_api.g_varchar2) then
699: p_rec.attribute7 :=
700: per_pgv_shd.g_old_rec.attribute7;
701: End If;
702: If (p_rec.attribute8 = hr_api.g_varchar2) then
703: p_rec.attribute8 :=
704: per_pgv_shd.g_old_rec.attribute8;
705: End If;
706: If (p_rec.attribute9 = hr_api.g_varchar2) then

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

702: If (p_rec.attribute8 = hr_api.g_varchar2) then
703: p_rec.attribute8 :=
704: per_pgv_shd.g_old_rec.attribute8;
705: End If;
706: If (p_rec.attribute9 = hr_api.g_varchar2) then
707: p_rec.attribute9 :=
708: per_pgv_shd.g_old_rec.attribute9;
709: End If;
710: If (p_rec.attribute10 = hr_api.g_varchar2) then

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

706: If (p_rec.attribute9 = hr_api.g_varchar2) then
707: p_rec.attribute9 :=
708: per_pgv_shd.g_old_rec.attribute9;
709: End If;
710: If (p_rec.attribute10 = hr_api.g_varchar2) then
711: p_rec.attribute10 :=
712: per_pgv_shd.g_old_rec.attribute10;
713: End If;
714: If (p_rec.attribute11 = hr_api.g_varchar2) then

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

710: If (p_rec.attribute10 = hr_api.g_varchar2) then
711: p_rec.attribute10 :=
712: per_pgv_shd.g_old_rec.attribute10;
713: End If;
714: If (p_rec.attribute11 = hr_api.g_varchar2) then
715: p_rec.attribute11 :=
716: per_pgv_shd.g_old_rec.attribute11;
717: End If;
718: If (p_rec.attribute12 = hr_api.g_varchar2) then

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

714: If (p_rec.attribute11 = hr_api.g_varchar2) then
715: p_rec.attribute11 :=
716: per_pgv_shd.g_old_rec.attribute11;
717: End If;
718: If (p_rec.attribute12 = hr_api.g_varchar2) then
719: p_rec.attribute12 :=
720: per_pgv_shd.g_old_rec.attribute12;
721: End If;
722: If (p_rec.attribute13 = hr_api.g_varchar2) then

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

718: If (p_rec.attribute12 = hr_api.g_varchar2) then
719: p_rec.attribute12 :=
720: per_pgv_shd.g_old_rec.attribute12;
721: End If;
722: If (p_rec.attribute13 = hr_api.g_varchar2) then
723: p_rec.attribute13 :=
724: per_pgv_shd.g_old_rec.attribute13;
725: End If;
726: If (p_rec.attribute14 = hr_api.g_varchar2) then

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

722: If (p_rec.attribute13 = hr_api.g_varchar2) then
723: p_rec.attribute13 :=
724: per_pgv_shd.g_old_rec.attribute13;
725: End If;
726: If (p_rec.attribute14 = hr_api.g_varchar2) then
727: p_rec.attribute14 :=
728: per_pgv_shd.g_old_rec.attribute14;
729: End If;
730: If (p_rec.attribute15 = hr_api.g_varchar2) then

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

726: If (p_rec.attribute14 = hr_api.g_varchar2) then
727: p_rec.attribute14 :=
728: per_pgv_shd.g_old_rec.attribute14;
729: End If;
730: If (p_rec.attribute15 = hr_api.g_varchar2) then
731: p_rec.attribute15 :=
732: per_pgv_shd.g_old_rec.attribute15;
733: End If;
734: If (p_rec.attribute16 = hr_api.g_varchar2) then

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

730: If (p_rec.attribute15 = hr_api.g_varchar2) then
731: p_rec.attribute15 :=
732: per_pgv_shd.g_old_rec.attribute15;
733: End If;
734: If (p_rec.attribute16 = hr_api.g_varchar2) then
735: p_rec.attribute16 :=
736: per_pgv_shd.g_old_rec.attribute16;
737: End If;
738: If (p_rec.attribute17 = hr_api.g_varchar2) then

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

734: If (p_rec.attribute16 = hr_api.g_varchar2) then
735: p_rec.attribute16 :=
736: per_pgv_shd.g_old_rec.attribute16;
737: End If;
738: If (p_rec.attribute17 = hr_api.g_varchar2) then
739: p_rec.attribute17 :=
740: per_pgv_shd.g_old_rec.attribute17;
741: End If;
742: If (p_rec.attribute18 = hr_api.g_varchar2) then

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

738: If (p_rec.attribute17 = hr_api.g_varchar2) then
739: p_rec.attribute17 :=
740: per_pgv_shd.g_old_rec.attribute17;
741: End If;
742: If (p_rec.attribute18 = hr_api.g_varchar2) then
743: p_rec.attribute18 :=
744: per_pgv_shd.g_old_rec.attribute18;
745: End If;
746: If (p_rec.attribute19 = hr_api.g_varchar2) then

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

742: If (p_rec.attribute18 = hr_api.g_varchar2) then
743: p_rec.attribute18 :=
744: per_pgv_shd.g_old_rec.attribute18;
745: End If;
746: If (p_rec.attribute19 = hr_api.g_varchar2) then
747: p_rec.attribute19 :=
748: per_pgv_shd.g_old_rec.attribute19;
749: End If;
750: If (p_rec.attribute20 = hr_api.g_varchar2) then

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

746: If (p_rec.attribute19 = hr_api.g_varchar2) then
747: p_rec.attribute19 :=
748: per_pgv_shd.g_old_rec.attribute19;
749: End If;
750: If (p_rec.attribute20 = hr_api.g_varchar2) then
751: p_rec.attribute20 :=
752: per_pgv_shd.g_old_rec.attribute20;
753: End If;
754: If (p_rec.attribute21 = hr_api.g_varchar2) then

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

750: If (p_rec.attribute20 = hr_api.g_varchar2) then
751: p_rec.attribute20 :=
752: per_pgv_shd.g_old_rec.attribute20;
753: End If;
754: If (p_rec.attribute21 = hr_api.g_varchar2) then
755: p_rec.attribute21 :=
756: per_pgv_shd.g_old_rec.attribute21;
757: End If;
758: If (p_rec.attribute22 = hr_api.g_varchar2) then

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

754: If (p_rec.attribute21 = hr_api.g_varchar2) then
755: p_rec.attribute21 :=
756: per_pgv_shd.g_old_rec.attribute21;
757: End If;
758: If (p_rec.attribute22 = hr_api.g_varchar2) then
759: p_rec.attribute22 :=
760: per_pgv_shd.g_old_rec.attribute22;
761: End If;
762: If (p_rec.attribute23 = hr_api.g_varchar2) then

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

758: If (p_rec.attribute22 = hr_api.g_varchar2) then
759: p_rec.attribute22 :=
760: per_pgv_shd.g_old_rec.attribute22;
761: End If;
762: If (p_rec.attribute23 = hr_api.g_varchar2) then
763: p_rec.attribute23 :=
764: per_pgv_shd.g_old_rec.attribute23;
765: End If;
766: If (p_rec.attribute24 = hr_api.g_varchar2) then

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

762: If (p_rec.attribute23 = hr_api.g_varchar2) then
763: p_rec.attribute23 :=
764: per_pgv_shd.g_old_rec.attribute23;
765: End If;
766: If (p_rec.attribute24 = hr_api.g_varchar2) then
767: p_rec.attribute24 :=
768: per_pgv_shd.g_old_rec.attribute24;
769: End If;
770: If (p_rec.attribute25 = hr_api.g_varchar2) then

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

766: If (p_rec.attribute24 = hr_api.g_varchar2) then
767: p_rec.attribute24 :=
768: per_pgv_shd.g_old_rec.attribute24;
769: End If;
770: If (p_rec.attribute25 = hr_api.g_varchar2) then
771: p_rec.attribute25 :=
772: per_pgv_shd.g_old_rec.attribute25;
773: End If;
774: If (p_rec.attribute26 = hr_api.g_varchar2) then

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

770: If (p_rec.attribute25 = hr_api.g_varchar2) then
771: p_rec.attribute25 :=
772: per_pgv_shd.g_old_rec.attribute25;
773: End If;
774: If (p_rec.attribute26 = hr_api.g_varchar2) then
775: p_rec.attribute26 :=
776: per_pgv_shd.g_old_rec.attribute26;
777: End If;
778: If (p_rec.attribute27 = hr_api.g_varchar2) then

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

774: If (p_rec.attribute26 = hr_api.g_varchar2) then
775: p_rec.attribute26 :=
776: per_pgv_shd.g_old_rec.attribute26;
777: End If;
778: If (p_rec.attribute27 = hr_api.g_varchar2) then
779: p_rec.attribute27 :=
780: per_pgv_shd.g_old_rec.attribute27;
781: End If;
782: If (p_rec.attribute28 = hr_api.g_varchar2) then

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

778: If (p_rec.attribute27 = hr_api.g_varchar2) then
779: p_rec.attribute27 :=
780: per_pgv_shd.g_old_rec.attribute27;
781: End If;
782: If (p_rec.attribute28 = hr_api.g_varchar2) then
783: p_rec.attribute28 :=
784: per_pgv_shd.g_old_rec.attribute28;
785: End If;
786: If (p_rec.attribute29 = hr_api.g_varchar2) then

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

782: If (p_rec.attribute28 = hr_api.g_varchar2) then
783: p_rec.attribute28 :=
784: per_pgv_shd.g_old_rec.attribute28;
785: End If;
786: If (p_rec.attribute29 = hr_api.g_varchar2) then
787: p_rec.attribute29 :=
788: per_pgv_shd.g_old_rec.attribute29;
789: End If;
790: If (p_rec.attribute30 = hr_api.g_varchar2) then

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

786: If (p_rec.attribute29 = hr_api.g_varchar2) then
787: p_rec.attribute29 :=
788: per_pgv_shd.g_old_rec.attribute29;
789: End If;
790: If (p_rec.attribute30 = hr_api.g_varchar2) then
791: p_rec.attribute30 :=
792: per_pgv_shd.g_old_rec.attribute30;
793: End If;
794: If (p_rec.information_category = hr_api.g_varchar2) then

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

790: If (p_rec.attribute30 = hr_api.g_varchar2) then
791: p_rec.attribute30 :=
792: per_pgv_shd.g_old_rec.attribute30;
793: End If;
794: If (p_rec.information_category = hr_api.g_varchar2) then
795: p_rec.information_category :=
796: per_pgn_shd.g_old_rec.information_category;
797: End If;
798: If (p_rec.information1 = hr_api.g_varchar2) then

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

794: If (p_rec.information_category = hr_api.g_varchar2) then
795: p_rec.information_category :=
796: per_pgn_shd.g_old_rec.information_category;
797: End If;
798: If (p_rec.information1 = hr_api.g_varchar2) then
799: p_rec.information1 :=
800: per_pgn_shd.g_old_rec.information1;
801: End If;
802: If (p_rec.information2 = hr_api.g_varchar2) then

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

798: If (p_rec.information1 = hr_api.g_varchar2) then
799: p_rec.information1 :=
800: per_pgn_shd.g_old_rec.information1;
801: End If;
802: If (p_rec.information2 = hr_api.g_varchar2) then
803: p_rec.information2 :=
804: per_pgn_shd.g_old_rec.information2;
805: End If;
806: If (p_rec.information3 = hr_api.g_varchar2) then

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

802: If (p_rec.information2 = hr_api.g_varchar2) then
803: p_rec.information2 :=
804: per_pgn_shd.g_old_rec.information2;
805: End If;
806: If (p_rec.information3 = hr_api.g_varchar2) then
807: p_rec.information3 :=
808: per_pgn_shd.g_old_rec.information3;
809: End If;
810: If (p_rec.information4 = hr_api.g_varchar2) then

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

806: If (p_rec.information3 = hr_api.g_varchar2) then
807: p_rec.information3 :=
808: per_pgn_shd.g_old_rec.information3;
809: End If;
810: If (p_rec.information4 = hr_api.g_varchar2) then
811: p_rec.information4 :=
812: per_pgn_shd.g_old_rec.information4;
813: End If;
814: If (p_rec.information5 = hr_api.g_varchar2) then

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

810: If (p_rec.information4 = hr_api.g_varchar2) then
811: p_rec.information4 :=
812: per_pgn_shd.g_old_rec.information4;
813: End If;
814: If (p_rec.information5 = hr_api.g_varchar2) then
815: p_rec.information5 :=
816: per_pgn_shd.g_old_rec.information5;
817: End If;
818: If (p_rec.information6 = hr_api.g_varchar2) then

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

814: If (p_rec.information5 = hr_api.g_varchar2) then
815: p_rec.information5 :=
816: per_pgn_shd.g_old_rec.information5;
817: End If;
818: If (p_rec.information6 = hr_api.g_varchar2) then
819: p_rec.information6 :=
820: per_pgn_shd.g_old_rec.information6;
821: End If;
822: If (p_rec.information7 = hr_api.g_varchar2) then

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

818: If (p_rec.information6 = hr_api.g_varchar2) then
819: p_rec.information6 :=
820: per_pgn_shd.g_old_rec.information6;
821: End If;
822: If (p_rec.information7 = hr_api.g_varchar2) then
823: p_rec.information7 :=
824: per_pgn_shd.g_old_rec.information7;
825: End If;
826: If (p_rec.information8 = hr_api.g_varchar2) then

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

822: If (p_rec.information7 = hr_api.g_varchar2) then
823: p_rec.information7 :=
824: per_pgn_shd.g_old_rec.information7;
825: End If;
826: If (p_rec.information8 = hr_api.g_varchar2) then
827: p_rec.information8 :=
828: per_pgn_shd.g_old_rec.information8;
829: End If;
830: If (p_rec.information9 = hr_api.g_varchar2) then

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

826: If (p_rec.information8 = hr_api.g_varchar2) then
827: p_rec.information8 :=
828: per_pgn_shd.g_old_rec.information8;
829: End If;
830: If (p_rec.information9 = hr_api.g_varchar2) then
831: p_rec.information9 :=
832: per_pgn_shd.g_old_rec.information9;
833: End If;
834: If (p_rec.information10 = hr_api.g_varchar2) then

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

830: If (p_rec.information9 = hr_api.g_varchar2) then
831: p_rec.information9 :=
832: per_pgn_shd.g_old_rec.information9;
833: End If;
834: If (p_rec.information10 = hr_api.g_varchar2) then
835: p_rec.information10 :=
836: per_pgn_shd.g_old_rec.information10;
837: End If;
838: If (p_rec.information11 = hr_api.g_varchar2) then

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

834: If (p_rec.information10 = hr_api.g_varchar2) then
835: p_rec.information10 :=
836: per_pgn_shd.g_old_rec.information10;
837: End If;
838: If (p_rec.information11 = hr_api.g_varchar2) then
839: p_rec.information11 :=
840: per_pgn_shd.g_old_rec.information11;
841: End If;
842: If (p_rec.information12 = hr_api.g_varchar2) then

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

838: If (p_rec.information11 = hr_api.g_varchar2) then
839: p_rec.information11 :=
840: per_pgn_shd.g_old_rec.information11;
841: End If;
842: If (p_rec.information12 = hr_api.g_varchar2) then
843: p_rec.information12 :=
844: per_pgn_shd.g_old_rec.information12;
845: End If;
846: If (p_rec.information13 = hr_api.g_varchar2) then

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

842: If (p_rec.information12 = hr_api.g_varchar2) then
843: p_rec.information12 :=
844: per_pgn_shd.g_old_rec.information12;
845: End If;
846: If (p_rec.information13 = hr_api.g_varchar2) then
847: p_rec.information13 :=
848: per_pgn_shd.g_old_rec.information13;
849: End If;
850: If (p_rec.information14 = hr_api.g_varchar2) then

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

846: If (p_rec.information13 = hr_api.g_varchar2) then
847: p_rec.information13 :=
848: per_pgn_shd.g_old_rec.information13;
849: End If;
850: If (p_rec.information14 = hr_api.g_varchar2) then
851: p_rec.information14 :=
852: per_pgn_shd.g_old_rec.information14;
853: End If;
854: If (p_rec.information15 = hr_api.g_varchar2) then

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

850: If (p_rec.information14 = hr_api.g_varchar2) then
851: p_rec.information14 :=
852: per_pgn_shd.g_old_rec.information14;
853: End If;
854: If (p_rec.information15 = hr_api.g_varchar2) then
855: p_rec.information15 :=
856: per_pgn_shd.g_old_rec.information15;
857: End If;
858: If (p_rec.information16 = hr_api.g_varchar2) then

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

854: If (p_rec.information15 = hr_api.g_varchar2) then
855: p_rec.information15 :=
856: per_pgn_shd.g_old_rec.information15;
857: End If;
858: If (p_rec.information16 = hr_api.g_varchar2) then
859: p_rec.information16 :=
860: per_pgn_shd.g_old_rec.information16;
861: End If;
862: If (p_rec.information17 = hr_api.g_varchar2) then

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

858: If (p_rec.information16 = hr_api.g_varchar2) then
859: p_rec.information16 :=
860: per_pgn_shd.g_old_rec.information16;
861: End If;
862: If (p_rec.information17 = hr_api.g_varchar2) then
863: p_rec.information17 :=
864: per_pgn_shd.g_old_rec.information17;
865: End If;
866: If (p_rec.information18 = hr_api.g_varchar2) then

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

862: If (p_rec.information17 = hr_api.g_varchar2) then
863: p_rec.information17 :=
864: per_pgn_shd.g_old_rec.information17;
865: End If;
866: If (p_rec.information18 = hr_api.g_varchar2) then
867: p_rec.information18 :=
868: per_pgn_shd.g_old_rec.information18;
869: End If;
870: If (p_rec.information19 = hr_api.g_varchar2) then

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

866: If (p_rec.information18 = hr_api.g_varchar2) then
867: p_rec.information18 :=
868: per_pgn_shd.g_old_rec.information18;
869: End If;
870: If (p_rec.information19 = hr_api.g_varchar2) then
871: p_rec.information19 :=
872: per_pgn_shd.g_old_rec.information19;
873: End If;
874: If (p_rec.information20 = hr_api.g_varchar2) then

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

870: If (p_rec.information19 = hr_api.g_varchar2) then
871: p_rec.information19 :=
872: per_pgn_shd.g_old_rec.information19;
873: End If;
874: If (p_rec.information20 = hr_api.g_varchar2) then
875: p_rec.information20 :=
876: per_pgn_shd.g_old_rec.information20;
877: End If;
878: If (p_rec.information21 = hr_api.g_varchar2) then

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

874: If (p_rec.information20 = hr_api.g_varchar2) then
875: p_rec.information20 :=
876: per_pgn_shd.g_old_rec.information20;
877: End If;
878: If (p_rec.information21 = hr_api.g_varchar2) then
879: p_rec.information21 :=
880: per_pgn_shd.g_old_rec.information21;
881: End If;
882: If (p_rec.information22 = hr_api.g_varchar2) then

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

878: If (p_rec.information21 = hr_api.g_varchar2) then
879: p_rec.information21 :=
880: per_pgn_shd.g_old_rec.information21;
881: End If;
882: If (p_rec.information22 = hr_api.g_varchar2) then
883: p_rec.information22 :=
884: per_pgn_shd.g_old_rec.information22;
885: End If;
886: If (p_rec.information23 = hr_api.g_varchar2) then

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

882: If (p_rec.information22 = hr_api.g_varchar2) then
883: p_rec.information22 :=
884: per_pgn_shd.g_old_rec.information22;
885: End If;
886: If (p_rec.information23 = hr_api.g_varchar2) then
887: p_rec.information23 :=
888: per_pgn_shd.g_old_rec.information23;
889: End If;
890: If (p_rec.information24 = hr_api.g_varchar2) then

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

886: If (p_rec.information23 = hr_api.g_varchar2) then
887: p_rec.information23 :=
888: per_pgn_shd.g_old_rec.information23;
889: End If;
890: If (p_rec.information24 = hr_api.g_varchar2) then
891: p_rec.information24 :=
892: per_pgn_shd.g_old_rec.information24;
893: End If;
894: If (p_rec.information25 = hr_api.g_varchar2) then

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

890: If (p_rec.information24 = hr_api.g_varchar2) then
891: p_rec.information24 :=
892: per_pgn_shd.g_old_rec.information24;
893: End If;
894: If (p_rec.information25 = hr_api.g_varchar2) then
895: p_rec.information25 :=
896: per_pgn_shd.g_old_rec.information25;
897: End If;
898: If (p_rec.information26 = hr_api.g_varchar2) then

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

894: If (p_rec.information25 = hr_api.g_varchar2) then
895: p_rec.information25 :=
896: per_pgn_shd.g_old_rec.information25;
897: End If;
898: If (p_rec.information26 = hr_api.g_varchar2) then
899: p_rec.information26 :=
900: per_pgn_shd.g_old_rec.information26;
901: End If;
902: If (p_rec.information27 = hr_api.g_varchar2) then

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

898: If (p_rec.information26 = hr_api.g_varchar2) then
899: p_rec.information26 :=
900: per_pgn_shd.g_old_rec.information26;
901: End If;
902: If (p_rec.information27 = hr_api.g_varchar2) then
903: p_rec.information27 :=
904: per_pgn_shd.g_old_rec.information27;
905: End If;
906: If (p_rec.information28 = hr_api.g_varchar2) then

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

902: If (p_rec.information27 = hr_api.g_varchar2) then
903: p_rec.information27 :=
904: per_pgn_shd.g_old_rec.information27;
905: End If;
906: If (p_rec.information28 = hr_api.g_varchar2) then
907: p_rec.information28 :=
908: per_pgn_shd.g_old_rec.information28;
909: End If;
910: If (p_rec.information29 = hr_api.g_varchar2) then

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

906: If (p_rec.information28 = hr_api.g_varchar2) then
907: p_rec.information28 :=
908: per_pgn_shd.g_old_rec.information28;
909: End If;
910: If (p_rec.information29 = hr_api.g_varchar2) then
911: p_rec.information29 :=
912: per_pgn_shd.g_old_rec.information29;
913: End If;
914: If (p_rec.information30 = hr_api.g_varchar2) then

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

910: If (p_rec.information29 = hr_api.g_varchar2) then
911: p_rec.information29 :=
912: per_pgn_shd.g_old_rec.information29;
913: End If;
914: If (p_rec.information30 = hr_api.g_varchar2) then
915: p_rec.information30 :=
916: per_pgn_shd.g_old_rec.information30;
917: End If;
918: --

Line 976: ,p_version_number in number default hr_api.g_number

972: Procedure upd
973: (p_effective_date in date
974: ,p_hierarchy_version_id in number
975: ,p_object_version_number in out nocopy number
976: ,p_version_number in number default hr_api.g_number
977: ,p_date_from in date default hr_api.g_date
978: ,p_status in varchar2 default hr_api.g_varchar2
979: ,p_validate_flag in varchar2 default hr_api.g_varchar2
980: ,p_date_to in date default hr_api.g_date

Line 977: ,p_date_from in date default hr_api.g_date

973: (p_effective_date in date
974: ,p_hierarchy_version_id in number
975: ,p_object_version_number in out nocopy number
976: ,p_version_number in number default hr_api.g_number
977: ,p_date_from in date default hr_api.g_date
978: ,p_status in varchar2 default hr_api.g_varchar2
979: ,p_validate_flag in varchar2 default hr_api.g_varchar2
980: ,p_date_to in date default hr_api.g_date
981: ,p_request_id in number default hr_api.g_number

Line 978: ,p_status in varchar2 default hr_api.g_varchar2

974: ,p_hierarchy_version_id in number
975: ,p_object_version_number in out nocopy number
976: ,p_version_number in number default hr_api.g_number
977: ,p_date_from in date default hr_api.g_date
978: ,p_status in varchar2 default hr_api.g_varchar2
979: ,p_validate_flag in varchar2 default hr_api.g_varchar2
980: ,p_date_to in date default hr_api.g_date
981: ,p_request_id in number default hr_api.g_number
982: ,p_program_application_id in number default hr_api.g_number

Line 979: ,p_validate_flag in varchar2 default hr_api.g_varchar2

975: ,p_object_version_number in out nocopy number
976: ,p_version_number in number default hr_api.g_number
977: ,p_date_from in date default hr_api.g_date
978: ,p_status in varchar2 default hr_api.g_varchar2
979: ,p_validate_flag in varchar2 default hr_api.g_varchar2
980: ,p_date_to in date default hr_api.g_date
981: ,p_request_id in number default hr_api.g_number
982: ,p_program_application_id in number default hr_api.g_number
983: ,p_program_id in number default hr_api.g_number

Line 980: ,p_date_to in date default hr_api.g_date

976: ,p_version_number in number default hr_api.g_number
977: ,p_date_from in date default hr_api.g_date
978: ,p_status in varchar2 default hr_api.g_varchar2
979: ,p_validate_flag in varchar2 default hr_api.g_varchar2
980: ,p_date_to in date default hr_api.g_date
981: ,p_request_id in number default hr_api.g_number
982: ,p_program_application_id in number default hr_api.g_number
983: ,p_program_id in number default hr_api.g_number
984: ,p_program_update_date in date default hr_api.g_date

Line 981: ,p_request_id in number default hr_api.g_number

977: ,p_date_from in date default hr_api.g_date
978: ,p_status in varchar2 default hr_api.g_varchar2
979: ,p_validate_flag in varchar2 default hr_api.g_varchar2
980: ,p_date_to in date default hr_api.g_date
981: ,p_request_id in number default hr_api.g_number
982: ,p_program_application_id in number default hr_api.g_number
983: ,p_program_id in number default hr_api.g_number
984: ,p_program_update_date in date default hr_api.g_date
985: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 982: ,p_program_application_id in number default hr_api.g_number

978: ,p_status in varchar2 default hr_api.g_varchar2
979: ,p_validate_flag in varchar2 default hr_api.g_varchar2
980: ,p_date_to in date default hr_api.g_date
981: ,p_request_id in number default hr_api.g_number
982: ,p_program_application_id in number default hr_api.g_number
983: ,p_program_id in number default hr_api.g_number
984: ,p_program_update_date in date default hr_api.g_date
985: ,p_attribute_category in varchar2 default hr_api.g_varchar2
986: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 983: ,p_program_id in number default hr_api.g_number

979: ,p_validate_flag in varchar2 default hr_api.g_varchar2
980: ,p_date_to in date default hr_api.g_date
981: ,p_request_id in number default hr_api.g_number
982: ,p_program_application_id in number default hr_api.g_number
983: ,p_program_id in number default hr_api.g_number
984: ,p_program_update_date in date default hr_api.g_date
985: ,p_attribute_category in varchar2 default hr_api.g_varchar2
986: ,p_attribute1 in varchar2 default hr_api.g_varchar2
987: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 984: ,p_program_update_date in date default hr_api.g_date

980: ,p_date_to in date default hr_api.g_date
981: ,p_request_id in number default hr_api.g_number
982: ,p_program_application_id in number default hr_api.g_number
983: ,p_program_id in number default hr_api.g_number
984: ,p_program_update_date in date default hr_api.g_date
985: ,p_attribute_category in varchar2 default hr_api.g_varchar2
986: ,p_attribute1 in varchar2 default hr_api.g_varchar2
987: ,p_attribute2 in varchar2 default hr_api.g_varchar2
988: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 985: ,p_attribute_category in varchar2 default hr_api.g_varchar2

981: ,p_request_id in number default hr_api.g_number
982: ,p_program_application_id in number default hr_api.g_number
983: ,p_program_id in number default hr_api.g_number
984: ,p_program_update_date in date default hr_api.g_date
985: ,p_attribute_category in varchar2 default hr_api.g_varchar2
986: ,p_attribute1 in varchar2 default hr_api.g_varchar2
987: ,p_attribute2 in varchar2 default hr_api.g_varchar2
988: ,p_attribute3 in varchar2 default hr_api.g_varchar2
989: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 986: ,p_attribute1 in varchar2 default hr_api.g_varchar2

982: ,p_program_application_id in number default hr_api.g_number
983: ,p_program_id in number default hr_api.g_number
984: ,p_program_update_date in date default hr_api.g_date
985: ,p_attribute_category in varchar2 default hr_api.g_varchar2
986: ,p_attribute1 in varchar2 default hr_api.g_varchar2
987: ,p_attribute2 in varchar2 default hr_api.g_varchar2
988: ,p_attribute3 in varchar2 default hr_api.g_varchar2
989: ,p_attribute4 in varchar2 default hr_api.g_varchar2
990: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 987: ,p_attribute2 in varchar2 default hr_api.g_varchar2

983: ,p_program_id in number default hr_api.g_number
984: ,p_program_update_date in date default hr_api.g_date
985: ,p_attribute_category in varchar2 default hr_api.g_varchar2
986: ,p_attribute1 in varchar2 default hr_api.g_varchar2
987: ,p_attribute2 in varchar2 default hr_api.g_varchar2
988: ,p_attribute3 in varchar2 default hr_api.g_varchar2
989: ,p_attribute4 in varchar2 default hr_api.g_varchar2
990: ,p_attribute5 in varchar2 default hr_api.g_varchar2
991: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 988: ,p_attribute3 in varchar2 default hr_api.g_varchar2

984: ,p_program_update_date in date default hr_api.g_date
985: ,p_attribute_category in varchar2 default hr_api.g_varchar2
986: ,p_attribute1 in varchar2 default hr_api.g_varchar2
987: ,p_attribute2 in varchar2 default hr_api.g_varchar2
988: ,p_attribute3 in varchar2 default hr_api.g_varchar2
989: ,p_attribute4 in varchar2 default hr_api.g_varchar2
990: ,p_attribute5 in varchar2 default hr_api.g_varchar2
991: ,p_attribute6 in varchar2 default hr_api.g_varchar2
992: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 989: ,p_attribute4 in varchar2 default hr_api.g_varchar2

985: ,p_attribute_category in varchar2 default hr_api.g_varchar2
986: ,p_attribute1 in varchar2 default hr_api.g_varchar2
987: ,p_attribute2 in varchar2 default hr_api.g_varchar2
988: ,p_attribute3 in varchar2 default hr_api.g_varchar2
989: ,p_attribute4 in varchar2 default hr_api.g_varchar2
990: ,p_attribute5 in varchar2 default hr_api.g_varchar2
991: ,p_attribute6 in varchar2 default hr_api.g_varchar2
992: ,p_attribute7 in varchar2 default hr_api.g_varchar2
993: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 990: ,p_attribute5 in varchar2 default hr_api.g_varchar2

986: ,p_attribute1 in varchar2 default hr_api.g_varchar2
987: ,p_attribute2 in varchar2 default hr_api.g_varchar2
988: ,p_attribute3 in varchar2 default hr_api.g_varchar2
989: ,p_attribute4 in varchar2 default hr_api.g_varchar2
990: ,p_attribute5 in varchar2 default hr_api.g_varchar2
991: ,p_attribute6 in varchar2 default hr_api.g_varchar2
992: ,p_attribute7 in varchar2 default hr_api.g_varchar2
993: ,p_attribute8 in varchar2 default hr_api.g_varchar2
994: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 991: ,p_attribute6 in varchar2 default hr_api.g_varchar2

987: ,p_attribute2 in varchar2 default hr_api.g_varchar2
988: ,p_attribute3 in varchar2 default hr_api.g_varchar2
989: ,p_attribute4 in varchar2 default hr_api.g_varchar2
990: ,p_attribute5 in varchar2 default hr_api.g_varchar2
991: ,p_attribute6 in varchar2 default hr_api.g_varchar2
992: ,p_attribute7 in varchar2 default hr_api.g_varchar2
993: ,p_attribute8 in varchar2 default hr_api.g_varchar2
994: ,p_attribute9 in varchar2 default hr_api.g_varchar2
995: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 992: ,p_attribute7 in varchar2 default hr_api.g_varchar2

988: ,p_attribute3 in varchar2 default hr_api.g_varchar2
989: ,p_attribute4 in varchar2 default hr_api.g_varchar2
990: ,p_attribute5 in varchar2 default hr_api.g_varchar2
991: ,p_attribute6 in varchar2 default hr_api.g_varchar2
992: ,p_attribute7 in varchar2 default hr_api.g_varchar2
993: ,p_attribute8 in varchar2 default hr_api.g_varchar2
994: ,p_attribute9 in varchar2 default hr_api.g_varchar2
995: ,p_attribute10 in varchar2 default hr_api.g_varchar2
996: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 993: ,p_attribute8 in varchar2 default hr_api.g_varchar2

989: ,p_attribute4 in varchar2 default hr_api.g_varchar2
990: ,p_attribute5 in varchar2 default hr_api.g_varchar2
991: ,p_attribute6 in varchar2 default hr_api.g_varchar2
992: ,p_attribute7 in varchar2 default hr_api.g_varchar2
993: ,p_attribute8 in varchar2 default hr_api.g_varchar2
994: ,p_attribute9 in varchar2 default hr_api.g_varchar2
995: ,p_attribute10 in varchar2 default hr_api.g_varchar2
996: ,p_attribute11 in varchar2 default hr_api.g_varchar2
997: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 994: ,p_attribute9 in varchar2 default hr_api.g_varchar2

990: ,p_attribute5 in varchar2 default hr_api.g_varchar2
991: ,p_attribute6 in varchar2 default hr_api.g_varchar2
992: ,p_attribute7 in varchar2 default hr_api.g_varchar2
993: ,p_attribute8 in varchar2 default hr_api.g_varchar2
994: ,p_attribute9 in varchar2 default hr_api.g_varchar2
995: ,p_attribute10 in varchar2 default hr_api.g_varchar2
996: ,p_attribute11 in varchar2 default hr_api.g_varchar2
997: ,p_attribute12 in varchar2 default hr_api.g_varchar2
998: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 995: ,p_attribute10 in varchar2 default hr_api.g_varchar2

991: ,p_attribute6 in varchar2 default hr_api.g_varchar2
992: ,p_attribute7 in varchar2 default hr_api.g_varchar2
993: ,p_attribute8 in varchar2 default hr_api.g_varchar2
994: ,p_attribute9 in varchar2 default hr_api.g_varchar2
995: ,p_attribute10 in varchar2 default hr_api.g_varchar2
996: ,p_attribute11 in varchar2 default hr_api.g_varchar2
997: ,p_attribute12 in varchar2 default hr_api.g_varchar2
998: ,p_attribute13 in varchar2 default hr_api.g_varchar2
999: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 996: ,p_attribute11 in varchar2 default hr_api.g_varchar2

992: ,p_attribute7 in varchar2 default hr_api.g_varchar2
993: ,p_attribute8 in varchar2 default hr_api.g_varchar2
994: ,p_attribute9 in varchar2 default hr_api.g_varchar2
995: ,p_attribute10 in varchar2 default hr_api.g_varchar2
996: ,p_attribute11 in varchar2 default hr_api.g_varchar2
997: ,p_attribute12 in varchar2 default hr_api.g_varchar2
998: ,p_attribute13 in varchar2 default hr_api.g_varchar2
999: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1000: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 997: ,p_attribute12 in varchar2 default hr_api.g_varchar2

993: ,p_attribute8 in varchar2 default hr_api.g_varchar2
994: ,p_attribute9 in varchar2 default hr_api.g_varchar2
995: ,p_attribute10 in varchar2 default hr_api.g_varchar2
996: ,p_attribute11 in varchar2 default hr_api.g_varchar2
997: ,p_attribute12 in varchar2 default hr_api.g_varchar2
998: ,p_attribute13 in varchar2 default hr_api.g_varchar2
999: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1000: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1001: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 998: ,p_attribute13 in varchar2 default hr_api.g_varchar2

994: ,p_attribute9 in varchar2 default hr_api.g_varchar2
995: ,p_attribute10 in varchar2 default hr_api.g_varchar2
996: ,p_attribute11 in varchar2 default hr_api.g_varchar2
997: ,p_attribute12 in varchar2 default hr_api.g_varchar2
998: ,p_attribute13 in varchar2 default hr_api.g_varchar2
999: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1000: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1001: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1002: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 999: ,p_attribute14 in varchar2 default hr_api.g_varchar2

995: ,p_attribute10 in varchar2 default hr_api.g_varchar2
996: ,p_attribute11 in varchar2 default hr_api.g_varchar2
997: ,p_attribute12 in varchar2 default hr_api.g_varchar2
998: ,p_attribute13 in varchar2 default hr_api.g_varchar2
999: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1000: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1001: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1002: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1003: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 1000: ,p_attribute15 in varchar2 default hr_api.g_varchar2

996: ,p_attribute11 in varchar2 default hr_api.g_varchar2
997: ,p_attribute12 in varchar2 default hr_api.g_varchar2
998: ,p_attribute13 in varchar2 default hr_api.g_varchar2
999: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1000: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1001: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1002: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1003: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1004: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 1001: ,p_attribute16 in varchar2 default hr_api.g_varchar2

997: ,p_attribute12 in varchar2 default hr_api.g_varchar2
998: ,p_attribute13 in varchar2 default hr_api.g_varchar2
999: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1000: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1001: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1002: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1003: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1004: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1005: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 1002: ,p_attribute17 in varchar2 default hr_api.g_varchar2

998: ,p_attribute13 in varchar2 default hr_api.g_varchar2
999: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1000: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1001: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1002: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1003: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1004: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1005: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1006: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 1003: ,p_attribute18 in varchar2 default hr_api.g_varchar2

999: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1000: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1001: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1002: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1003: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1004: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1005: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1006: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1007: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 1004: ,p_attribute19 in varchar2 default hr_api.g_varchar2

1000: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1001: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1002: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1003: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1004: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1005: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1006: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1007: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1008: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 1005: ,p_attribute20 in varchar2 default hr_api.g_varchar2

1001: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1002: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1003: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1004: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1005: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1006: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1007: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1008: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1009: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 1006: ,p_attribute21 in varchar2 default hr_api.g_varchar2

1002: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1003: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1004: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1005: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1006: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1007: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1008: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1009: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1010: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 1007: ,p_attribute22 in varchar2 default hr_api.g_varchar2

1003: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1004: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1005: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1006: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1007: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1008: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1009: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1010: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1011: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 1008: ,p_attribute23 in varchar2 default hr_api.g_varchar2

1004: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1005: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1006: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1007: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1008: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1009: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1010: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1011: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1012: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 1009: ,p_attribute24 in varchar2 default hr_api.g_varchar2

1005: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1006: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1007: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1008: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1009: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1010: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1011: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1012: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1013: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 1010: ,p_attribute25 in varchar2 default hr_api.g_varchar2

1006: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1007: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1008: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1009: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1010: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1011: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1012: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1013: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1014: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 1011: ,p_attribute26 in varchar2 default hr_api.g_varchar2

1007: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1008: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1009: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1010: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1011: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1012: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1013: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1014: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1015: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 1012: ,p_attribute27 in varchar2 default hr_api.g_varchar2

1008: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1009: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1010: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1011: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1012: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1013: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1014: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1015: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1016: ,p_information_category in varchar2 default hr_api.g_varchar2

Line 1013: ,p_attribute28 in varchar2 default hr_api.g_varchar2

1009: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1010: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1011: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1012: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1013: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1014: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1015: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1016: ,p_information_category in varchar2 default hr_api.g_varchar2
1017: ,p_information1 in varchar2 default hr_api.g_varchar2

Line 1014: ,p_attribute29 in varchar2 default hr_api.g_varchar2

1010: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1011: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1012: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1013: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1014: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1015: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1016: ,p_information_category in varchar2 default hr_api.g_varchar2
1017: ,p_information1 in varchar2 default hr_api.g_varchar2
1018: ,p_information2 in varchar2 default hr_api.g_varchar2

Line 1015: ,p_attribute30 in varchar2 default hr_api.g_varchar2

1011: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1012: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1013: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1014: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1015: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1016: ,p_information_category in varchar2 default hr_api.g_varchar2
1017: ,p_information1 in varchar2 default hr_api.g_varchar2
1018: ,p_information2 in varchar2 default hr_api.g_varchar2
1019: ,p_information3 in varchar2 default hr_api.g_varchar2

Line 1016: ,p_information_category in varchar2 default hr_api.g_varchar2

1012: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1013: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1014: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1015: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1016: ,p_information_category in varchar2 default hr_api.g_varchar2
1017: ,p_information1 in varchar2 default hr_api.g_varchar2
1018: ,p_information2 in varchar2 default hr_api.g_varchar2
1019: ,p_information3 in varchar2 default hr_api.g_varchar2
1020: ,p_information4 in varchar2 default hr_api.g_varchar2

Line 1017: ,p_information1 in varchar2 default hr_api.g_varchar2

1013: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1014: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1015: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1016: ,p_information_category in varchar2 default hr_api.g_varchar2
1017: ,p_information1 in varchar2 default hr_api.g_varchar2
1018: ,p_information2 in varchar2 default hr_api.g_varchar2
1019: ,p_information3 in varchar2 default hr_api.g_varchar2
1020: ,p_information4 in varchar2 default hr_api.g_varchar2
1021: ,p_information5 in varchar2 default hr_api.g_varchar2

Line 1018: ,p_information2 in varchar2 default hr_api.g_varchar2

1014: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1015: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1016: ,p_information_category in varchar2 default hr_api.g_varchar2
1017: ,p_information1 in varchar2 default hr_api.g_varchar2
1018: ,p_information2 in varchar2 default hr_api.g_varchar2
1019: ,p_information3 in varchar2 default hr_api.g_varchar2
1020: ,p_information4 in varchar2 default hr_api.g_varchar2
1021: ,p_information5 in varchar2 default hr_api.g_varchar2
1022: ,p_information6 in varchar2 default hr_api.g_varchar2

Line 1019: ,p_information3 in varchar2 default hr_api.g_varchar2

1015: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1016: ,p_information_category in varchar2 default hr_api.g_varchar2
1017: ,p_information1 in varchar2 default hr_api.g_varchar2
1018: ,p_information2 in varchar2 default hr_api.g_varchar2
1019: ,p_information3 in varchar2 default hr_api.g_varchar2
1020: ,p_information4 in varchar2 default hr_api.g_varchar2
1021: ,p_information5 in varchar2 default hr_api.g_varchar2
1022: ,p_information6 in varchar2 default hr_api.g_varchar2
1023: ,p_information7 in varchar2 default hr_api.g_varchar2

Line 1020: ,p_information4 in varchar2 default hr_api.g_varchar2

1016: ,p_information_category in varchar2 default hr_api.g_varchar2
1017: ,p_information1 in varchar2 default hr_api.g_varchar2
1018: ,p_information2 in varchar2 default hr_api.g_varchar2
1019: ,p_information3 in varchar2 default hr_api.g_varchar2
1020: ,p_information4 in varchar2 default hr_api.g_varchar2
1021: ,p_information5 in varchar2 default hr_api.g_varchar2
1022: ,p_information6 in varchar2 default hr_api.g_varchar2
1023: ,p_information7 in varchar2 default hr_api.g_varchar2
1024: ,p_information8 in varchar2 default hr_api.g_varchar2

Line 1021: ,p_information5 in varchar2 default hr_api.g_varchar2

1017: ,p_information1 in varchar2 default hr_api.g_varchar2
1018: ,p_information2 in varchar2 default hr_api.g_varchar2
1019: ,p_information3 in varchar2 default hr_api.g_varchar2
1020: ,p_information4 in varchar2 default hr_api.g_varchar2
1021: ,p_information5 in varchar2 default hr_api.g_varchar2
1022: ,p_information6 in varchar2 default hr_api.g_varchar2
1023: ,p_information7 in varchar2 default hr_api.g_varchar2
1024: ,p_information8 in varchar2 default hr_api.g_varchar2
1025: ,p_information9 in varchar2 default hr_api.g_varchar2

Line 1022: ,p_information6 in varchar2 default hr_api.g_varchar2

1018: ,p_information2 in varchar2 default hr_api.g_varchar2
1019: ,p_information3 in varchar2 default hr_api.g_varchar2
1020: ,p_information4 in varchar2 default hr_api.g_varchar2
1021: ,p_information5 in varchar2 default hr_api.g_varchar2
1022: ,p_information6 in varchar2 default hr_api.g_varchar2
1023: ,p_information7 in varchar2 default hr_api.g_varchar2
1024: ,p_information8 in varchar2 default hr_api.g_varchar2
1025: ,p_information9 in varchar2 default hr_api.g_varchar2
1026: ,p_information10 in varchar2 default hr_api.g_varchar2

Line 1023: ,p_information7 in varchar2 default hr_api.g_varchar2

1019: ,p_information3 in varchar2 default hr_api.g_varchar2
1020: ,p_information4 in varchar2 default hr_api.g_varchar2
1021: ,p_information5 in varchar2 default hr_api.g_varchar2
1022: ,p_information6 in varchar2 default hr_api.g_varchar2
1023: ,p_information7 in varchar2 default hr_api.g_varchar2
1024: ,p_information8 in varchar2 default hr_api.g_varchar2
1025: ,p_information9 in varchar2 default hr_api.g_varchar2
1026: ,p_information10 in varchar2 default hr_api.g_varchar2
1027: ,p_information11 in varchar2 default hr_api.g_varchar2

Line 1024: ,p_information8 in varchar2 default hr_api.g_varchar2

1020: ,p_information4 in varchar2 default hr_api.g_varchar2
1021: ,p_information5 in varchar2 default hr_api.g_varchar2
1022: ,p_information6 in varchar2 default hr_api.g_varchar2
1023: ,p_information7 in varchar2 default hr_api.g_varchar2
1024: ,p_information8 in varchar2 default hr_api.g_varchar2
1025: ,p_information9 in varchar2 default hr_api.g_varchar2
1026: ,p_information10 in varchar2 default hr_api.g_varchar2
1027: ,p_information11 in varchar2 default hr_api.g_varchar2
1028: ,p_information12 in varchar2 default hr_api.g_varchar2

Line 1025: ,p_information9 in varchar2 default hr_api.g_varchar2

1021: ,p_information5 in varchar2 default hr_api.g_varchar2
1022: ,p_information6 in varchar2 default hr_api.g_varchar2
1023: ,p_information7 in varchar2 default hr_api.g_varchar2
1024: ,p_information8 in varchar2 default hr_api.g_varchar2
1025: ,p_information9 in varchar2 default hr_api.g_varchar2
1026: ,p_information10 in varchar2 default hr_api.g_varchar2
1027: ,p_information11 in varchar2 default hr_api.g_varchar2
1028: ,p_information12 in varchar2 default hr_api.g_varchar2
1029: ,p_information13 in varchar2 default hr_api.g_varchar2

Line 1026: ,p_information10 in varchar2 default hr_api.g_varchar2

1022: ,p_information6 in varchar2 default hr_api.g_varchar2
1023: ,p_information7 in varchar2 default hr_api.g_varchar2
1024: ,p_information8 in varchar2 default hr_api.g_varchar2
1025: ,p_information9 in varchar2 default hr_api.g_varchar2
1026: ,p_information10 in varchar2 default hr_api.g_varchar2
1027: ,p_information11 in varchar2 default hr_api.g_varchar2
1028: ,p_information12 in varchar2 default hr_api.g_varchar2
1029: ,p_information13 in varchar2 default hr_api.g_varchar2
1030: ,p_information14 in varchar2 default hr_api.g_varchar2

Line 1027: ,p_information11 in varchar2 default hr_api.g_varchar2

1023: ,p_information7 in varchar2 default hr_api.g_varchar2
1024: ,p_information8 in varchar2 default hr_api.g_varchar2
1025: ,p_information9 in varchar2 default hr_api.g_varchar2
1026: ,p_information10 in varchar2 default hr_api.g_varchar2
1027: ,p_information11 in varchar2 default hr_api.g_varchar2
1028: ,p_information12 in varchar2 default hr_api.g_varchar2
1029: ,p_information13 in varchar2 default hr_api.g_varchar2
1030: ,p_information14 in varchar2 default hr_api.g_varchar2
1031: ,p_information15 in varchar2 default hr_api.g_varchar2

Line 1028: ,p_information12 in varchar2 default hr_api.g_varchar2

1024: ,p_information8 in varchar2 default hr_api.g_varchar2
1025: ,p_information9 in varchar2 default hr_api.g_varchar2
1026: ,p_information10 in varchar2 default hr_api.g_varchar2
1027: ,p_information11 in varchar2 default hr_api.g_varchar2
1028: ,p_information12 in varchar2 default hr_api.g_varchar2
1029: ,p_information13 in varchar2 default hr_api.g_varchar2
1030: ,p_information14 in varchar2 default hr_api.g_varchar2
1031: ,p_information15 in varchar2 default hr_api.g_varchar2
1032: ,p_information16 in varchar2 default hr_api.g_varchar2

Line 1029: ,p_information13 in varchar2 default hr_api.g_varchar2

1025: ,p_information9 in varchar2 default hr_api.g_varchar2
1026: ,p_information10 in varchar2 default hr_api.g_varchar2
1027: ,p_information11 in varchar2 default hr_api.g_varchar2
1028: ,p_information12 in varchar2 default hr_api.g_varchar2
1029: ,p_information13 in varchar2 default hr_api.g_varchar2
1030: ,p_information14 in varchar2 default hr_api.g_varchar2
1031: ,p_information15 in varchar2 default hr_api.g_varchar2
1032: ,p_information16 in varchar2 default hr_api.g_varchar2
1033: ,p_information17 in varchar2 default hr_api.g_varchar2

Line 1030: ,p_information14 in varchar2 default hr_api.g_varchar2

1026: ,p_information10 in varchar2 default hr_api.g_varchar2
1027: ,p_information11 in varchar2 default hr_api.g_varchar2
1028: ,p_information12 in varchar2 default hr_api.g_varchar2
1029: ,p_information13 in varchar2 default hr_api.g_varchar2
1030: ,p_information14 in varchar2 default hr_api.g_varchar2
1031: ,p_information15 in varchar2 default hr_api.g_varchar2
1032: ,p_information16 in varchar2 default hr_api.g_varchar2
1033: ,p_information17 in varchar2 default hr_api.g_varchar2
1034: ,p_information18 in varchar2 default hr_api.g_varchar2

Line 1031: ,p_information15 in varchar2 default hr_api.g_varchar2

1027: ,p_information11 in varchar2 default hr_api.g_varchar2
1028: ,p_information12 in varchar2 default hr_api.g_varchar2
1029: ,p_information13 in varchar2 default hr_api.g_varchar2
1030: ,p_information14 in varchar2 default hr_api.g_varchar2
1031: ,p_information15 in varchar2 default hr_api.g_varchar2
1032: ,p_information16 in varchar2 default hr_api.g_varchar2
1033: ,p_information17 in varchar2 default hr_api.g_varchar2
1034: ,p_information18 in varchar2 default hr_api.g_varchar2
1035: ,p_information19 in varchar2 default hr_api.g_varchar2

Line 1032: ,p_information16 in varchar2 default hr_api.g_varchar2

1028: ,p_information12 in varchar2 default hr_api.g_varchar2
1029: ,p_information13 in varchar2 default hr_api.g_varchar2
1030: ,p_information14 in varchar2 default hr_api.g_varchar2
1031: ,p_information15 in varchar2 default hr_api.g_varchar2
1032: ,p_information16 in varchar2 default hr_api.g_varchar2
1033: ,p_information17 in varchar2 default hr_api.g_varchar2
1034: ,p_information18 in varchar2 default hr_api.g_varchar2
1035: ,p_information19 in varchar2 default hr_api.g_varchar2
1036: ,p_information20 in varchar2 default hr_api.g_varchar2

Line 1033: ,p_information17 in varchar2 default hr_api.g_varchar2

1029: ,p_information13 in varchar2 default hr_api.g_varchar2
1030: ,p_information14 in varchar2 default hr_api.g_varchar2
1031: ,p_information15 in varchar2 default hr_api.g_varchar2
1032: ,p_information16 in varchar2 default hr_api.g_varchar2
1033: ,p_information17 in varchar2 default hr_api.g_varchar2
1034: ,p_information18 in varchar2 default hr_api.g_varchar2
1035: ,p_information19 in varchar2 default hr_api.g_varchar2
1036: ,p_information20 in varchar2 default hr_api.g_varchar2
1037: ,p_information21 in varchar2 default hr_api.g_varchar2

Line 1034: ,p_information18 in varchar2 default hr_api.g_varchar2

1030: ,p_information14 in varchar2 default hr_api.g_varchar2
1031: ,p_information15 in varchar2 default hr_api.g_varchar2
1032: ,p_information16 in varchar2 default hr_api.g_varchar2
1033: ,p_information17 in varchar2 default hr_api.g_varchar2
1034: ,p_information18 in varchar2 default hr_api.g_varchar2
1035: ,p_information19 in varchar2 default hr_api.g_varchar2
1036: ,p_information20 in varchar2 default hr_api.g_varchar2
1037: ,p_information21 in varchar2 default hr_api.g_varchar2
1038: ,p_information22 in varchar2 default hr_api.g_varchar2

Line 1035: ,p_information19 in varchar2 default hr_api.g_varchar2

1031: ,p_information15 in varchar2 default hr_api.g_varchar2
1032: ,p_information16 in varchar2 default hr_api.g_varchar2
1033: ,p_information17 in varchar2 default hr_api.g_varchar2
1034: ,p_information18 in varchar2 default hr_api.g_varchar2
1035: ,p_information19 in varchar2 default hr_api.g_varchar2
1036: ,p_information20 in varchar2 default hr_api.g_varchar2
1037: ,p_information21 in varchar2 default hr_api.g_varchar2
1038: ,p_information22 in varchar2 default hr_api.g_varchar2
1039: ,p_information23 in varchar2 default hr_api.g_varchar2

Line 1036: ,p_information20 in varchar2 default hr_api.g_varchar2

1032: ,p_information16 in varchar2 default hr_api.g_varchar2
1033: ,p_information17 in varchar2 default hr_api.g_varchar2
1034: ,p_information18 in varchar2 default hr_api.g_varchar2
1035: ,p_information19 in varchar2 default hr_api.g_varchar2
1036: ,p_information20 in varchar2 default hr_api.g_varchar2
1037: ,p_information21 in varchar2 default hr_api.g_varchar2
1038: ,p_information22 in varchar2 default hr_api.g_varchar2
1039: ,p_information23 in varchar2 default hr_api.g_varchar2
1040: ,p_information24 in varchar2 default hr_api.g_varchar2

Line 1037: ,p_information21 in varchar2 default hr_api.g_varchar2

1033: ,p_information17 in varchar2 default hr_api.g_varchar2
1034: ,p_information18 in varchar2 default hr_api.g_varchar2
1035: ,p_information19 in varchar2 default hr_api.g_varchar2
1036: ,p_information20 in varchar2 default hr_api.g_varchar2
1037: ,p_information21 in varchar2 default hr_api.g_varchar2
1038: ,p_information22 in varchar2 default hr_api.g_varchar2
1039: ,p_information23 in varchar2 default hr_api.g_varchar2
1040: ,p_information24 in varchar2 default hr_api.g_varchar2
1041: ,p_information25 in varchar2 default hr_api.g_varchar2

Line 1038: ,p_information22 in varchar2 default hr_api.g_varchar2

1034: ,p_information18 in varchar2 default hr_api.g_varchar2
1035: ,p_information19 in varchar2 default hr_api.g_varchar2
1036: ,p_information20 in varchar2 default hr_api.g_varchar2
1037: ,p_information21 in varchar2 default hr_api.g_varchar2
1038: ,p_information22 in varchar2 default hr_api.g_varchar2
1039: ,p_information23 in varchar2 default hr_api.g_varchar2
1040: ,p_information24 in varchar2 default hr_api.g_varchar2
1041: ,p_information25 in varchar2 default hr_api.g_varchar2
1042: ,p_information26 in varchar2 default hr_api.g_varchar2

Line 1039: ,p_information23 in varchar2 default hr_api.g_varchar2

1035: ,p_information19 in varchar2 default hr_api.g_varchar2
1036: ,p_information20 in varchar2 default hr_api.g_varchar2
1037: ,p_information21 in varchar2 default hr_api.g_varchar2
1038: ,p_information22 in varchar2 default hr_api.g_varchar2
1039: ,p_information23 in varchar2 default hr_api.g_varchar2
1040: ,p_information24 in varchar2 default hr_api.g_varchar2
1041: ,p_information25 in varchar2 default hr_api.g_varchar2
1042: ,p_information26 in varchar2 default hr_api.g_varchar2
1043: ,p_information27 in varchar2 default hr_api.g_varchar2

Line 1040: ,p_information24 in varchar2 default hr_api.g_varchar2

1036: ,p_information20 in varchar2 default hr_api.g_varchar2
1037: ,p_information21 in varchar2 default hr_api.g_varchar2
1038: ,p_information22 in varchar2 default hr_api.g_varchar2
1039: ,p_information23 in varchar2 default hr_api.g_varchar2
1040: ,p_information24 in varchar2 default hr_api.g_varchar2
1041: ,p_information25 in varchar2 default hr_api.g_varchar2
1042: ,p_information26 in varchar2 default hr_api.g_varchar2
1043: ,p_information27 in varchar2 default hr_api.g_varchar2
1044: ,p_information28 in varchar2 default hr_api.g_varchar2

Line 1041: ,p_information25 in varchar2 default hr_api.g_varchar2

1037: ,p_information21 in varchar2 default hr_api.g_varchar2
1038: ,p_information22 in varchar2 default hr_api.g_varchar2
1039: ,p_information23 in varchar2 default hr_api.g_varchar2
1040: ,p_information24 in varchar2 default hr_api.g_varchar2
1041: ,p_information25 in varchar2 default hr_api.g_varchar2
1042: ,p_information26 in varchar2 default hr_api.g_varchar2
1043: ,p_information27 in varchar2 default hr_api.g_varchar2
1044: ,p_information28 in varchar2 default hr_api.g_varchar2
1045: ,p_information29 in varchar2 default hr_api.g_varchar2

Line 1042: ,p_information26 in varchar2 default hr_api.g_varchar2

1038: ,p_information22 in varchar2 default hr_api.g_varchar2
1039: ,p_information23 in varchar2 default hr_api.g_varchar2
1040: ,p_information24 in varchar2 default hr_api.g_varchar2
1041: ,p_information25 in varchar2 default hr_api.g_varchar2
1042: ,p_information26 in varchar2 default hr_api.g_varchar2
1043: ,p_information27 in varchar2 default hr_api.g_varchar2
1044: ,p_information28 in varchar2 default hr_api.g_varchar2
1045: ,p_information29 in varchar2 default hr_api.g_varchar2
1046: ,p_information30 in varchar2 default hr_api.g_varchar2

Line 1043: ,p_information27 in varchar2 default hr_api.g_varchar2

1039: ,p_information23 in varchar2 default hr_api.g_varchar2
1040: ,p_information24 in varchar2 default hr_api.g_varchar2
1041: ,p_information25 in varchar2 default hr_api.g_varchar2
1042: ,p_information26 in varchar2 default hr_api.g_varchar2
1043: ,p_information27 in varchar2 default hr_api.g_varchar2
1044: ,p_information28 in varchar2 default hr_api.g_varchar2
1045: ,p_information29 in varchar2 default hr_api.g_varchar2
1046: ,p_information30 in varchar2 default hr_api.g_varchar2
1047: ) is

Line 1044: ,p_information28 in varchar2 default hr_api.g_varchar2

1040: ,p_information24 in varchar2 default hr_api.g_varchar2
1041: ,p_information25 in varchar2 default hr_api.g_varchar2
1042: ,p_information26 in varchar2 default hr_api.g_varchar2
1043: ,p_information27 in varchar2 default hr_api.g_varchar2
1044: ,p_information28 in varchar2 default hr_api.g_varchar2
1045: ,p_information29 in varchar2 default hr_api.g_varchar2
1046: ,p_information30 in varchar2 default hr_api.g_varchar2
1047: ) is
1048: --

Line 1045: ,p_information29 in varchar2 default hr_api.g_varchar2

1041: ,p_information25 in varchar2 default hr_api.g_varchar2
1042: ,p_information26 in varchar2 default hr_api.g_varchar2
1043: ,p_information27 in varchar2 default hr_api.g_varchar2
1044: ,p_information28 in varchar2 default hr_api.g_varchar2
1045: ,p_information29 in varchar2 default hr_api.g_varchar2
1046: ,p_information30 in varchar2 default hr_api.g_varchar2
1047: ) is
1048: --
1049: l_rec per_pgv_shd.g_rec_type;

Line 1046: ,p_information30 in varchar2 default hr_api.g_varchar2

1042: ,p_information26 in varchar2 default hr_api.g_varchar2
1043: ,p_information27 in varchar2 default hr_api.g_varchar2
1044: ,p_information28 in varchar2 default hr_api.g_varchar2
1045: ,p_information29 in varchar2 default hr_api.g_varchar2
1046: ,p_information30 in varchar2 default hr_api.g_varchar2
1047: ) is
1048: --
1049: l_rec per_pgv_shd.g_rec_type;
1050: l_proc varchar2(72) := g_package||'upd';

Line 1061: ,hr_api.g_number

1057: --
1058: l_rec :=
1059: per_pgv_shd.convert_args
1060: (p_hierarchy_version_id
1061: ,hr_api.g_number
1062: ,p_version_number
1063: ,hr_api.g_number
1064: ,p_date_from
1065: ,p_date_to

Line 1063: ,hr_api.g_number

1059: per_pgv_shd.convert_args
1060: (p_hierarchy_version_id
1061: ,hr_api.g_number
1062: ,p_version_number
1063: ,hr_api.g_number
1064: ,p_date_from
1065: ,p_date_to
1066: ,p_status
1067: ,p_validate_flag