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

Line 153: When hr_api.check_integrity_violated Then

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

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

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

Line 158: When hr_api.parent_integrity_violated Then

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

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

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

Line 163: When hr_api.unique_integrity_violated Then

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

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

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

Line 558: when hr_api.cannot_find_prog_unit then

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

Line 560: hr_api.cannot_find_prog_unit_error

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

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

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

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

623: If (p_rec.effective_start_date = hr_api.g_date) then
624: p_rec.effective_start_date :=
625: pay_prf_shd.g_old_rec.effective_start_date;
626: End If;
627: If (p_rec.effective_end_date = hr_api.g_date) then
628: p_rec.effective_end_date :=
629: pay_prf_shd.g_old_rec.effective_end_date;
630: End If;
631: If (p_rec.range_table_number = hr_api.g_number) then

Line 631: If (p_rec.range_table_number = hr_api.g_number) then

627: If (p_rec.effective_end_date = hr_api.g_date) then
628: p_rec.effective_end_date :=
629: pay_prf_shd.g_old_rec.effective_end_date;
630: End If;
631: If (p_rec.range_table_number = hr_api.g_number) then
632: p_rec.range_table_number :=
633: pay_prf_shd.g_old_rec.range_table_number;
634: End If;
635: If (p_rec.row_value_uom = hr_api.g_varchar2) then

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

631: If (p_rec.range_table_number = hr_api.g_number) then
632: p_rec.range_table_number :=
633: pay_prf_shd.g_old_rec.range_table_number;
634: End If;
635: If (p_rec.row_value_uom = hr_api.g_varchar2) then
636: p_rec.row_value_uom :=
637: pay_prf_shd.g_old_rec.row_value_uom;
638: End If;
639: If (p_rec.period_frequency = hr_api.g_varchar2) then

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

635: If (p_rec.row_value_uom = hr_api.g_varchar2) then
636: p_rec.row_value_uom :=
637: pay_prf_shd.g_old_rec.row_value_uom;
638: End If;
639: If (p_rec.period_frequency = hr_api.g_varchar2) then
640: p_rec.period_frequency :=
641: pay_prf_shd.g_old_rec.period_frequency;
642: End If;
643: If (p_rec.earnings_type = hr_api.g_varchar2) then

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

639: If (p_rec.period_frequency = hr_api.g_varchar2) then
640: p_rec.period_frequency :=
641: pay_prf_shd.g_old_rec.period_frequency;
642: End If;
643: If (p_rec.earnings_type = hr_api.g_varchar2) then
644: p_rec.earnings_type :=
645: pay_prf_shd.g_old_rec.earnings_type;
646: End If;
647: If (p_rec.business_group_id = hr_api.g_number) then

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

643: If (p_rec.earnings_type = hr_api.g_varchar2) then
644: p_rec.earnings_type :=
645: pay_prf_shd.g_old_rec.earnings_type;
646: End If;
647: If (p_rec.business_group_id = hr_api.g_number) then
648: p_rec.business_group_id :=
649: pay_prf_shd.g_old_rec.business_group_id;
650: End If;
651: If (p_rec.legislation_code = hr_api.g_varchar2) then

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

647: If (p_rec.business_group_id = hr_api.g_number) then
648: p_rec.business_group_id :=
649: pay_prf_shd.g_old_rec.business_group_id;
650: End If;
651: If (p_rec.legislation_code = hr_api.g_varchar2) then
652: p_rec.legislation_code :=
653: pay_prf_shd.g_old_rec.legislation_code;
654: End If;
655: If (p_rec.last_updated_login = hr_api.g_number) then

Line 655: If (p_rec.last_updated_login = hr_api.g_number) then

651: If (p_rec.legislation_code = hr_api.g_varchar2) then
652: p_rec.legislation_code :=
653: pay_prf_shd.g_old_rec.legislation_code;
654: End If;
655: If (p_rec.last_updated_login = hr_api.g_number) then
656: p_rec.last_updated_login :=
657: pay_prf_shd.g_old_rec.last_updated_login;
658: End If;
659: If (p_rec.created_date = hr_api.g_date) then

Line 659: If (p_rec.created_date = hr_api.g_date) then

655: If (p_rec.last_updated_login = hr_api.g_number) then
656: p_rec.last_updated_login :=
657: pay_prf_shd.g_old_rec.last_updated_login;
658: End If;
659: If (p_rec.created_date = hr_api.g_date) then
660: p_rec.created_date :=
661: pay_prf_shd.g_old_rec.created_date;
662: End If;
663: If (p_rec.attribute_category = hr_api.g_varchar2) then

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

659: If (p_rec.created_date = hr_api.g_date) then
660: p_rec.created_date :=
661: pay_prf_shd.g_old_rec.created_date;
662: End If;
663: If (p_rec.attribute_category = hr_api.g_varchar2) then
664: p_rec.attribute_category :=
665: pay_prf_shd.g_old_rec.attribute_category;
666: End If;
667: If (p_rec.attribute1 = hr_api.g_varchar2) then

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

663: If (p_rec.attribute_category = hr_api.g_varchar2) then
664: p_rec.attribute_category :=
665: pay_prf_shd.g_old_rec.attribute_category;
666: End If;
667: If (p_rec.attribute1 = hr_api.g_varchar2) then
668: p_rec.attribute1 :=
669: pay_prf_shd.g_old_rec.attribute1;
670: End If;
671: If (p_rec.attribute2 = hr_api.g_varchar2) then

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

667: If (p_rec.attribute1 = hr_api.g_varchar2) then
668: p_rec.attribute1 :=
669: pay_prf_shd.g_old_rec.attribute1;
670: End If;
671: If (p_rec.attribute2 = hr_api.g_varchar2) then
672: p_rec.attribute2 :=
673: pay_prf_shd.g_old_rec.attribute2;
674: End If;
675: If (p_rec.attribute3 = hr_api.g_varchar2) then

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

671: If (p_rec.attribute2 = hr_api.g_varchar2) then
672: p_rec.attribute2 :=
673: pay_prf_shd.g_old_rec.attribute2;
674: End If;
675: If (p_rec.attribute3 = hr_api.g_varchar2) then
676: p_rec.attribute3 :=
677: pay_prf_shd.g_old_rec.attribute3;
678: End If;
679: If (p_rec.attribute4 = hr_api.g_varchar2) then

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

675: If (p_rec.attribute3 = hr_api.g_varchar2) then
676: p_rec.attribute3 :=
677: pay_prf_shd.g_old_rec.attribute3;
678: End If;
679: If (p_rec.attribute4 = hr_api.g_varchar2) then
680: p_rec.attribute4 :=
681: pay_prf_shd.g_old_rec.attribute4;
682: End If;
683: If (p_rec.attribute5 = hr_api.g_varchar2) then

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

679: If (p_rec.attribute4 = hr_api.g_varchar2) then
680: p_rec.attribute4 :=
681: pay_prf_shd.g_old_rec.attribute4;
682: End If;
683: If (p_rec.attribute5 = hr_api.g_varchar2) then
684: p_rec.attribute5 :=
685: pay_prf_shd.g_old_rec.attribute5;
686: End If;
687: If (p_rec.attribute6 = hr_api.g_varchar2) then

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

683: If (p_rec.attribute5 = hr_api.g_varchar2) then
684: p_rec.attribute5 :=
685: pay_prf_shd.g_old_rec.attribute5;
686: End If;
687: If (p_rec.attribute6 = hr_api.g_varchar2) then
688: p_rec.attribute6 :=
689: pay_prf_shd.g_old_rec.attribute6;
690: End If;
691: If (p_rec.attribute7 = hr_api.g_varchar2) then

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

687: If (p_rec.attribute6 = hr_api.g_varchar2) then
688: p_rec.attribute6 :=
689: pay_prf_shd.g_old_rec.attribute6;
690: End If;
691: If (p_rec.attribute7 = hr_api.g_varchar2) then
692: p_rec.attribute7 :=
693: pay_prf_shd.g_old_rec.attribute7;
694: End If;
695: If (p_rec.attribute8 = hr_api.g_varchar2) then

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

691: If (p_rec.attribute7 = hr_api.g_varchar2) then
692: p_rec.attribute7 :=
693: pay_prf_shd.g_old_rec.attribute7;
694: End If;
695: If (p_rec.attribute8 = hr_api.g_varchar2) then
696: p_rec.attribute8 :=
697: pay_prf_shd.g_old_rec.attribute8;
698: End If;
699: If (p_rec.attribute9 = hr_api.g_varchar2) then

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

695: If (p_rec.attribute8 = hr_api.g_varchar2) then
696: p_rec.attribute8 :=
697: pay_prf_shd.g_old_rec.attribute8;
698: End If;
699: If (p_rec.attribute9 = hr_api.g_varchar2) then
700: p_rec.attribute9 :=
701: pay_prf_shd.g_old_rec.attribute9;
702: End If;
703: If (p_rec.attribute10 = hr_api.g_varchar2) then

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

699: If (p_rec.attribute9 = hr_api.g_varchar2) then
700: p_rec.attribute9 :=
701: pay_prf_shd.g_old_rec.attribute9;
702: End If;
703: If (p_rec.attribute10 = hr_api.g_varchar2) then
704: p_rec.attribute10 :=
705: pay_prf_shd.g_old_rec.attribute10;
706: End If;
707: If (p_rec.attribute11 = hr_api.g_varchar2) then

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

703: If (p_rec.attribute10 = hr_api.g_varchar2) then
704: p_rec.attribute10 :=
705: pay_prf_shd.g_old_rec.attribute10;
706: End If;
707: If (p_rec.attribute11 = hr_api.g_varchar2) then
708: p_rec.attribute11 :=
709: pay_prf_shd.g_old_rec.attribute11;
710: End If;
711: If (p_rec.attribute12 = hr_api.g_varchar2) then

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

707: If (p_rec.attribute11 = hr_api.g_varchar2) then
708: p_rec.attribute11 :=
709: pay_prf_shd.g_old_rec.attribute11;
710: End If;
711: If (p_rec.attribute12 = hr_api.g_varchar2) then
712: p_rec.attribute12 :=
713: pay_prf_shd.g_old_rec.attribute12;
714: End If;
715: If (p_rec.attribute13 = hr_api.g_varchar2) then

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

711: If (p_rec.attribute12 = hr_api.g_varchar2) then
712: p_rec.attribute12 :=
713: pay_prf_shd.g_old_rec.attribute12;
714: End If;
715: If (p_rec.attribute13 = hr_api.g_varchar2) then
716: p_rec.attribute13 :=
717: pay_prf_shd.g_old_rec.attribute13;
718: End If;
719: If (p_rec.attribute14 = hr_api.g_varchar2) then

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

715: If (p_rec.attribute13 = hr_api.g_varchar2) then
716: p_rec.attribute13 :=
717: pay_prf_shd.g_old_rec.attribute13;
718: End If;
719: If (p_rec.attribute14 = hr_api.g_varchar2) then
720: p_rec.attribute14 :=
721: pay_prf_shd.g_old_rec.attribute14;
722: End If;
723: If (p_rec.attribute15 = hr_api.g_varchar2) then

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

719: If (p_rec.attribute14 = hr_api.g_varchar2) then
720: p_rec.attribute14 :=
721: pay_prf_shd.g_old_rec.attribute14;
722: End If;
723: If (p_rec.attribute15 = hr_api.g_varchar2) then
724: p_rec.attribute15 :=
725: pay_prf_shd.g_old_rec.attribute15;
726: End If;
727: If (p_rec.attribute16 = hr_api.g_varchar2) then

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

723: If (p_rec.attribute15 = hr_api.g_varchar2) then
724: p_rec.attribute15 :=
725: pay_prf_shd.g_old_rec.attribute15;
726: End If;
727: If (p_rec.attribute16 = hr_api.g_varchar2) then
728: p_rec.attribute16 :=
729: pay_prf_shd.g_old_rec.attribute16;
730: End If;
731: If (p_rec.attribute17 = hr_api.g_varchar2) then

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

727: If (p_rec.attribute16 = hr_api.g_varchar2) then
728: p_rec.attribute16 :=
729: pay_prf_shd.g_old_rec.attribute16;
730: End If;
731: If (p_rec.attribute17 = hr_api.g_varchar2) then
732: p_rec.attribute17 :=
733: pay_prf_shd.g_old_rec.attribute17;
734: End If;
735: If (p_rec.attribute18 = hr_api.g_varchar2) then

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

731: If (p_rec.attribute17 = hr_api.g_varchar2) then
732: p_rec.attribute17 :=
733: pay_prf_shd.g_old_rec.attribute17;
734: End If;
735: If (p_rec.attribute18 = hr_api.g_varchar2) then
736: p_rec.attribute18 :=
737: pay_prf_shd.g_old_rec.attribute18;
738: End If;
739: If (p_rec.attribute19 = hr_api.g_varchar2) then

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

735: If (p_rec.attribute18 = hr_api.g_varchar2) then
736: p_rec.attribute18 :=
737: pay_prf_shd.g_old_rec.attribute18;
738: End If;
739: If (p_rec.attribute19 = hr_api.g_varchar2) then
740: p_rec.attribute19 :=
741: pay_prf_shd.g_old_rec.attribute19;
742: End If;
743: If (p_rec.attribute20 = hr_api.g_varchar2) then

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

739: If (p_rec.attribute19 = hr_api.g_varchar2) then
740: p_rec.attribute19 :=
741: pay_prf_shd.g_old_rec.attribute19;
742: End If;
743: If (p_rec.attribute20 = hr_api.g_varchar2) then
744: p_rec.attribute20 :=
745: pay_prf_shd.g_old_rec.attribute20;
746: End If;
747: If (p_rec.attribute21 = hr_api.g_varchar2) then

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

743: If (p_rec.attribute20 = hr_api.g_varchar2) then
744: p_rec.attribute20 :=
745: pay_prf_shd.g_old_rec.attribute20;
746: End If;
747: If (p_rec.attribute21 = hr_api.g_varchar2) then
748: p_rec.attribute21 :=
749: pay_prf_shd.g_old_rec.attribute21;
750: End If;
751: If (p_rec.attribute22 = hr_api.g_varchar2) then

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

747: If (p_rec.attribute21 = hr_api.g_varchar2) then
748: p_rec.attribute21 :=
749: pay_prf_shd.g_old_rec.attribute21;
750: End If;
751: If (p_rec.attribute22 = hr_api.g_varchar2) then
752: p_rec.attribute22 :=
753: pay_prf_shd.g_old_rec.attribute22;
754: End If;
755: If (p_rec.attribute23 = hr_api.g_varchar2) then

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

751: If (p_rec.attribute22 = hr_api.g_varchar2) then
752: p_rec.attribute22 :=
753: pay_prf_shd.g_old_rec.attribute22;
754: End If;
755: If (p_rec.attribute23 = hr_api.g_varchar2) then
756: p_rec.attribute23 :=
757: pay_prf_shd.g_old_rec.attribute23;
758: End If;
759: If (p_rec.attribute24 = hr_api.g_varchar2) then

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

755: If (p_rec.attribute23 = hr_api.g_varchar2) then
756: p_rec.attribute23 :=
757: pay_prf_shd.g_old_rec.attribute23;
758: End If;
759: If (p_rec.attribute24 = hr_api.g_varchar2) then
760: p_rec.attribute24 :=
761: pay_prf_shd.g_old_rec.attribute24;
762: End If;
763: If (p_rec.attribute25 = hr_api.g_varchar2) then

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

759: If (p_rec.attribute24 = hr_api.g_varchar2) then
760: p_rec.attribute24 :=
761: pay_prf_shd.g_old_rec.attribute24;
762: End If;
763: If (p_rec.attribute25 = hr_api.g_varchar2) then
764: p_rec.attribute25 :=
765: pay_prf_shd.g_old_rec.attribute25;
766: End If;
767: If (p_rec.attribute26 = hr_api.g_varchar2) then

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

763: If (p_rec.attribute25 = hr_api.g_varchar2) then
764: p_rec.attribute25 :=
765: pay_prf_shd.g_old_rec.attribute25;
766: End If;
767: If (p_rec.attribute26 = hr_api.g_varchar2) then
768: p_rec.attribute26 :=
769: pay_prf_shd.g_old_rec.attribute26;
770: End If;
771: If (p_rec.attribute27 = hr_api.g_varchar2) then

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

767: If (p_rec.attribute26 = hr_api.g_varchar2) then
768: p_rec.attribute26 :=
769: pay_prf_shd.g_old_rec.attribute26;
770: End If;
771: If (p_rec.attribute27 = hr_api.g_varchar2) then
772: p_rec.attribute27 :=
773: pay_prf_shd.g_old_rec.attribute27;
774: End If;
775: If (p_rec.attribute28 = hr_api.g_varchar2) then

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

771: If (p_rec.attribute27 = hr_api.g_varchar2) then
772: p_rec.attribute27 :=
773: pay_prf_shd.g_old_rec.attribute27;
774: End If;
775: If (p_rec.attribute28 = hr_api.g_varchar2) then
776: p_rec.attribute28 :=
777: pay_prf_shd.g_old_rec.attribute28;
778: End If;
779: If (p_rec.attribute29 = hr_api.g_varchar2) then

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

775: If (p_rec.attribute28 = hr_api.g_varchar2) then
776: p_rec.attribute28 :=
777: pay_prf_shd.g_old_rec.attribute28;
778: End If;
779: If (p_rec.attribute29 = hr_api.g_varchar2) then
780: p_rec.attribute29 :=
781: pay_prf_shd.g_old_rec.attribute29;
782: End If;
783: If (p_rec.attribute30 = hr_api.g_varchar2) then

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

779: If (p_rec.attribute29 = hr_api.g_varchar2) then
780: p_rec.attribute29 :=
781: pay_prf_shd.g_old_rec.attribute29;
782: End If;
783: If (p_rec.attribute30 = hr_api.g_varchar2) then
784: p_rec.attribute30 :=
785: pay_prf_shd.g_old_rec.attribute30;
786: End If;
787: If (p_rec.ran_information_category = hr_api.g_varchar2) then

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

783: If (p_rec.attribute30 = hr_api.g_varchar2) then
784: p_rec.attribute30 :=
785: pay_prf_shd.g_old_rec.attribute30;
786: End If;
787: If (p_rec.ran_information_category = hr_api.g_varchar2) then
788: p_rec.ran_information_category :=
789: pay_prf_shd.g_old_rec.ran_information_category;
790: End If;
791: If (p_rec.ran_information1 = hr_api.g_varchar2) then

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

787: If (p_rec.ran_information_category = hr_api.g_varchar2) then
788: p_rec.ran_information_category :=
789: pay_prf_shd.g_old_rec.ran_information_category;
790: End If;
791: If (p_rec.ran_information1 = hr_api.g_varchar2) then
792: p_rec.ran_information1 :=
793: pay_prf_shd.g_old_rec.ran_information1;
794: End If;
795: If (p_rec.ran_information2 = hr_api.g_varchar2) then

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

791: If (p_rec.ran_information1 = hr_api.g_varchar2) then
792: p_rec.ran_information1 :=
793: pay_prf_shd.g_old_rec.ran_information1;
794: End If;
795: If (p_rec.ran_information2 = hr_api.g_varchar2) then
796: p_rec.ran_information2 :=
797: pay_prf_shd.g_old_rec.ran_information2;
798: End If;
799: If (p_rec.ran_information3 = hr_api.g_varchar2) then

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

795: If (p_rec.ran_information2 = hr_api.g_varchar2) then
796: p_rec.ran_information2 :=
797: pay_prf_shd.g_old_rec.ran_information2;
798: End If;
799: If (p_rec.ran_information3 = hr_api.g_varchar2) then
800: p_rec.ran_information3 :=
801: pay_prf_shd.g_old_rec.ran_information3;
802: End If;
803: If (p_rec.ran_information4 = hr_api.g_varchar2) then

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

799: If (p_rec.ran_information3 = hr_api.g_varchar2) then
800: p_rec.ran_information3 :=
801: pay_prf_shd.g_old_rec.ran_information3;
802: End If;
803: If (p_rec.ran_information4 = hr_api.g_varchar2) then
804: p_rec.ran_information4 :=
805: pay_prf_shd.g_old_rec.ran_information4;
806: End If;
807: If (p_rec.ran_information5 = hr_api.g_varchar2) then

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

803: If (p_rec.ran_information4 = hr_api.g_varchar2) then
804: p_rec.ran_information4 :=
805: pay_prf_shd.g_old_rec.ran_information4;
806: End If;
807: If (p_rec.ran_information5 = hr_api.g_varchar2) then
808: p_rec.ran_information5 :=
809: pay_prf_shd.g_old_rec.ran_information5;
810: End If;
811: If (p_rec.ran_information6 = hr_api.g_varchar2) then

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

807: If (p_rec.ran_information5 = hr_api.g_varchar2) then
808: p_rec.ran_information5 :=
809: pay_prf_shd.g_old_rec.ran_information5;
810: End If;
811: If (p_rec.ran_information6 = hr_api.g_varchar2) then
812: p_rec.ran_information6 :=
813: pay_prf_shd.g_old_rec.ran_information6;
814: End If;
815: If (p_rec.ran_information7 = hr_api.g_varchar2) then

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

811: If (p_rec.ran_information6 = hr_api.g_varchar2) then
812: p_rec.ran_information6 :=
813: pay_prf_shd.g_old_rec.ran_information6;
814: End If;
815: If (p_rec.ran_information7 = hr_api.g_varchar2) then
816: p_rec.ran_information7 :=
817: pay_prf_shd.g_old_rec.ran_information7;
818: End If;
819: If (p_rec.ran_information8 = hr_api.g_varchar2) then

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

815: If (p_rec.ran_information7 = hr_api.g_varchar2) then
816: p_rec.ran_information7 :=
817: pay_prf_shd.g_old_rec.ran_information7;
818: End If;
819: If (p_rec.ran_information8 = hr_api.g_varchar2) then
820: p_rec.ran_information8 :=
821: pay_prf_shd.g_old_rec.ran_information8;
822: End If;
823: If (p_rec.ran_information9 = hr_api.g_varchar2) then

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

819: If (p_rec.ran_information8 = hr_api.g_varchar2) then
820: p_rec.ran_information8 :=
821: pay_prf_shd.g_old_rec.ran_information8;
822: End If;
823: If (p_rec.ran_information9 = hr_api.g_varchar2) then
824: p_rec.ran_information9 :=
825: pay_prf_shd.g_old_rec.ran_information9;
826: End If;
827: If (p_rec.ran_information10 = hr_api.g_varchar2) then

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

823: If (p_rec.ran_information9 = hr_api.g_varchar2) then
824: p_rec.ran_information9 :=
825: pay_prf_shd.g_old_rec.ran_information9;
826: End If;
827: If (p_rec.ran_information10 = hr_api.g_varchar2) then
828: p_rec.ran_information10 :=
829: pay_prf_shd.g_old_rec.ran_information10;
830: End If;
831: If (p_rec.ran_information11 = hr_api.g_varchar2) then

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

827: If (p_rec.ran_information10 = hr_api.g_varchar2) then
828: p_rec.ran_information10 :=
829: pay_prf_shd.g_old_rec.ran_information10;
830: End If;
831: If (p_rec.ran_information11 = hr_api.g_varchar2) then
832: p_rec.ran_information11 :=
833: pay_prf_shd.g_old_rec.ran_information11;
834: End If;
835: If (p_rec.ran_information12 = hr_api.g_varchar2) then

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

831: If (p_rec.ran_information11 = hr_api.g_varchar2) then
832: p_rec.ran_information11 :=
833: pay_prf_shd.g_old_rec.ran_information11;
834: End If;
835: If (p_rec.ran_information12 = hr_api.g_varchar2) then
836: p_rec.ran_information12 :=
837: pay_prf_shd.g_old_rec.ran_information12;
838: End If;
839: If (p_rec.ran_information13 = hr_api.g_varchar2) then

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

835: If (p_rec.ran_information12 = hr_api.g_varchar2) then
836: p_rec.ran_information12 :=
837: pay_prf_shd.g_old_rec.ran_information12;
838: End If;
839: If (p_rec.ran_information13 = hr_api.g_varchar2) then
840: p_rec.ran_information13 :=
841: pay_prf_shd.g_old_rec.ran_information13;
842: End If;
843: If (p_rec.ran_information14 = hr_api.g_varchar2) then

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

839: If (p_rec.ran_information13 = hr_api.g_varchar2) then
840: p_rec.ran_information13 :=
841: pay_prf_shd.g_old_rec.ran_information13;
842: End If;
843: If (p_rec.ran_information14 = hr_api.g_varchar2) then
844: p_rec.ran_information14 :=
845: pay_prf_shd.g_old_rec.ran_information14;
846: End If;
847: If (p_rec.ran_information15 = hr_api.g_varchar2) then

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

843: If (p_rec.ran_information14 = hr_api.g_varchar2) then
844: p_rec.ran_information14 :=
845: pay_prf_shd.g_old_rec.ran_information14;
846: End If;
847: If (p_rec.ran_information15 = hr_api.g_varchar2) then
848: p_rec.ran_information15 :=
849: pay_prf_shd.g_old_rec.ran_information15;
850: End If;
851: If (p_rec.ran_information16 = hr_api.g_varchar2) then

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

847: If (p_rec.ran_information15 = hr_api.g_varchar2) then
848: p_rec.ran_information15 :=
849: pay_prf_shd.g_old_rec.ran_information15;
850: End If;
851: If (p_rec.ran_information16 = hr_api.g_varchar2) then
852: p_rec.ran_information16 :=
853: pay_prf_shd.g_old_rec.ran_information16;
854: End If;
855: If (p_rec.ran_information17 = hr_api.g_varchar2) then

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

851: If (p_rec.ran_information16 = hr_api.g_varchar2) then
852: p_rec.ran_information16 :=
853: pay_prf_shd.g_old_rec.ran_information16;
854: End If;
855: If (p_rec.ran_information17 = hr_api.g_varchar2) then
856: p_rec.ran_information17 :=
857: pay_prf_shd.g_old_rec.ran_information17;
858: End If;
859: If (p_rec.ran_information18 = hr_api.g_varchar2) then

Line 859: If (p_rec.ran_information18 = hr_api.g_varchar2) then

855: If (p_rec.ran_information17 = hr_api.g_varchar2) then
856: p_rec.ran_information17 :=
857: pay_prf_shd.g_old_rec.ran_information17;
858: End If;
859: If (p_rec.ran_information18 = hr_api.g_varchar2) then
860: p_rec.ran_information18 :=
861: pay_prf_shd.g_old_rec.ran_information18;
862: End If;
863: If (p_rec.ran_information19 = hr_api.g_varchar2) then

Line 863: If (p_rec.ran_information19 = hr_api.g_varchar2) then

859: If (p_rec.ran_information18 = hr_api.g_varchar2) then
860: p_rec.ran_information18 :=
861: pay_prf_shd.g_old_rec.ran_information18;
862: End If;
863: If (p_rec.ran_information19 = hr_api.g_varchar2) then
864: p_rec.ran_information19 :=
865: pay_prf_shd.g_old_rec.ran_information19;
866: End If;
867: If (p_rec.ran_information20 = hr_api.g_varchar2) then

Line 867: If (p_rec.ran_information20 = hr_api.g_varchar2) then

863: If (p_rec.ran_information19 = hr_api.g_varchar2) then
864: p_rec.ran_information19 :=
865: pay_prf_shd.g_old_rec.ran_information19;
866: End If;
867: If (p_rec.ran_information20 = hr_api.g_varchar2) then
868: p_rec.ran_information20 :=
869: pay_prf_shd.g_old_rec.ran_information20;
870: End If;
871: If (p_rec.ran_information21 = hr_api.g_varchar2) then

Line 871: If (p_rec.ran_information21 = hr_api.g_varchar2) then

867: If (p_rec.ran_information20 = hr_api.g_varchar2) then
868: p_rec.ran_information20 :=
869: pay_prf_shd.g_old_rec.ran_information20;
870: End If;
871: If (p_rec.ran_information21 = hr_api.g_varchar2) then
872: p_rec.ran_information21 :=
873: pay_prf_shd.g_old_rec.ran_information21;
874: End If;
875: If (p_rec.ran_information22 = hr_api.g_varchar2) then

Line 875: If (p_rec.ran_information22 = hr_api.g_varchar2) then

871: If (p_rec.ran_information21 = hr_api.g_varchar2) then
872: p_rec.ran_information21 :=
873: pay_prf_shd.g_old_rec.ran_information21;
874: End If;
875: If (p_rec.ran_information22 = hr_api.g_varchar2) then
876: p_rec.ran_information22 :=
877: pay_prf_shd.g_old_rec.ran_information22;
878: End If;
879: If (p_rec.ran_information23 = hr_api.g_varchar2) then

Line 879: If (p_rec.ran_information23 = hr_api.g_varchar2) then

875: If (p_rec.ran_information22 = hr_api.g_varchar2) then
876: p_rec.ran_information22 :=
877: pay_prf_shd.g_old_rec.ran_information22;
878: End If;
879: If (p_rec.ran_information23 = hr_api.g_varchar2) then
880: p_rec.ran_information23 :=
881: pay_prf_shd.g_old_rec.ran_information23;
882: End If;
883: If (p_rec.ran_information24 = hr_api.g_varchar2) then

Line 883: If (p_rec.ran_information24 = hr_api.g_varchar2) then

879: If (p_rec.ran_information23 = hr_api.g_varchar2) then
880: p_rec.ran_information23 :=
881: pay_prf_shd.g_old_rec.ran_information23;
882: End If;
883: If (p_rec.ran_information24 = hr_api.g_varchar2) then
884: p_rec.ran_information24 :=
885: pay_prf_shd.g_old_rec.ran_information24;
886: End If;
887: If (p_rec.ran_information25 = hr_api.g_varchar2) then

Line 887: If (p_rec.ran_information25 = hr_api.g_varchar2) then

883: If (p_rec.ran_information24 = hr_api.g_varchar2) then
884: p_rec.ran_information24 :=
885: pay_prf_shd.g_old_rec.ran_information24;
886: End If;
887: If (p_rec.ran_information25 = hr_api.g_varchar2) then
888: p_rec.ran_information25 :=
889: pay_prf_shd.g_old_rec.ran_information25;
890: End If;
891: If (p_rec.ran_information26 = hr_api.g_varchar2) then

Line 891: If (p_rec.ran_information26 = hr_api.g_varchar2) then

887: If (p_rec.ran_information25 = hr_api.g_varchar2) then
888: p_rec.ran_information25 :=
889: pay_prf_shd.g_old_rec.ran_information25;
890: End If;
891: If (p_rec.ran_information26 = hr_api.g_varchar2) then
892: p_rec.ran_information26 :=
893: pay_prf_shd.g_old_rec.ran_information26;
894: End If;
895: If (p_rec.ran_information27 = hr_api.g_varchar2) then

Line 895: If (p_rec.ran_information27 = hr_api.g_varchar2) then

891: If (p_rec.ran_information26 = hr_api.g_varchar2) then
892: p_rec.ran_information26 :=
893: pay_prf_shd.g_old_rec.ran_information26;
894: End If;
895: If (p_rec.ran_information27 = hr_api.g_varchar2) then
896: p_rec.ran_information27 :=
897: pay_prf_shd.g_old_rec.ran_information27;
898: End If;
899: If (p_rec.ran_information28 = hr_api.g_varchar2) then

Line 899: If (p_rec.ran_information28 = hr_api.g_varchar2) then

895: If (p_rec.ran_information27 = hr_api.g_varchar2) then
896: p_rec.ran_information27 :=
897: pay_prf_shd.g_old_rec.ran_information27;
898: End If;
899: If (p_rec.ran_information28 = hr_api.g_varchar2) then
900: p_rec.ran_information28 :=
901: pay_prf_shd.g_old_rec.ran_information28;
902: End If;
903: If (p_rec.ran_information29 = hr_api.g_varchar2) then

Line 903: If (p_rec.ran_information29 = hr_api.g_varchar2) then

899: If (p_rec.ran_information28 = hr_api.g_varchar2) then
900: p_rec.ran_information28 :=
901: pay_prf_shd.g_old_rec.ran_information28;
902: End If;
903: If (p_rec.ran_information29 = hr_api.g_varchar2) then
904: p_rec.ran_information29 :=
905: pay_prf_shd.g_old_rec.ran_information29;
906: End If;
907: If (p_rec.ran_information30 = hr_api.g_varchar2) then

Line 907: If (p_rec.ran_information30 = hr_api.g_varchar2) then

903: If (p_rec.ran_information29 = hr_api.g_varchar2) then
904: p_rec.ran_information29 :=
905: pay_prf_shd.g_old_rec.ran_information29;
906: End If;
907: If (p_rec.ran_information30 = hr_api.g_varchar2) then
908: p_rec.ran_information30 :=
909: pay_prf_shd.g_old_rec.ran_information30;
910: End If;
911: --

Line 975: ,p_range_table_number in number default hr_api.g_number

971: -- ----------------------------------------------------------------------------
972: Procedure upd
973: (p_range_table_id in number
974: ,p_object_version_number in out nocopy number
975: ,p_range_table_number in number default hr_api.g_number
976: ,p_period_frequency in varchar2 default hr_api.g_varchar2
977: ,p_effective_start_date in date default hr_api.g_date
978: ,p_effective_end_date in date default hr_api.g_date
979: ,p_row_value_uom in varchar2 default hr_api.g_varchar2

Line 976: ,p_period_frequency in varchar2 default hr_api.g_varchar2

972: Procedure upd
973: (p_range_table_id in number
974: ,p_object_version_number in out nocopy number
975: ,p_range_table_number in number default hr_api.g_number
976: ,p_period_frequency in varchar2 default hr_api.g_varchar2
977: ,p_effective_start_date in date default hr_api.g_date
978: ,p_effective_end_date in date default hr_api.g_date
979: ,p_row_value_uom in varchar2 default hr_api.g_varchar2
980: ,p_earnings_type in varchar2 default hr_api.g_varchar2

Line 977: ,p_effective_start_date in date default hr_api.g_date

973: (p_range_table_id in number
974: ,p_object_version_number in out nocopy number
975: ,p_range_table_number in number default hr_api.g_number
976: ,p_period_frequency in varchar2 default hr_api.g_varchar2
977: ,p_effective_start_date in date default hr_api.g_date
978: ,p_effective_end_date in date default hr_api.g_date
979: ,p_row_value_uom in varchar2 default hr_api.g_varchar2
980: ,p_earnings_type in varchar2 default hr_api.g_varchar2
981: ,p_business_group_id in number default hr_api.g_number

Line 978: ,p_effective_end_date in date default hr_api.g_date

974: ,p_object_version_number in out nocopy number
975: ,p_range_table_number in number default hr_api.g_number
976: ,p_period_frequency in varchar2 default hr_api.g_varchar2
977: ,p_effective_start_date in date default hr_api.g_date
978: ,p_effective_end_date in date default hr_api.g_date
979: ,p_row_value_uom in varchar2 default hr_api.g_varchar2
980: ,p_earnings_type in varchar2 default hr_api.g_varchar2
981: ,p_business_group_id in number default hr_api.g_number
982: ,p_legislation_code in varchar2 default hr_api.g_varchar2

Line 979: ,p_row_value_uom in varchar2 default hr_api.g_varchar2

975: ,p_range_table_number in number default hr_api.g_number
976: ,p_period_frequency in varchar2 default hr_api.g_varchar2
977: ,p_effective_start_date in date default hr_api.g_date
978: ,p_effective_end_date in date default hr_api.g_date
979: ,p_row_value_uom in varchar2 default hr_api.g_varchar2
980: ,p_earnings_type in varchar2 default hr_api.g_varchar2
981: ,p_business_group_id in number default hr_api.g_number
982: ,p_legislation_code in varchar2 default hr_api.g_varchar2
983: ,p_last_updated_login in number default hr_api.g_number

Line 980: ,p_earnings_type in varchar2 default hr_api.g_varchar2

976: ,p_period_frequency in varchar2 default hr_api.g_varchar2
977: ,p_effective_start_date in date default hr_api.g_date
978: ,p_effective_end_date in date default hr_api.g_date
979: ,p_row_value_uom in varchar2 default hr_api.g_varchar2
980: ,p_earnings_type in varchar2 default hr_api.g_varchar2
981: ,p_business_group_id in number default hr_api.g_number
982: ,p_legislation_code in varchar2 default hr_api.g_varchar2
983: ,p_last_updated_login in number default hr_api.g_number
984: ,p_created_date in date default hr_api.g_date

Line 981: ,p_business_group_id in number default hr_api.g_number

977: ,p_effective_start_date in date default hr_api.g_date
978: ,p_effective_end_date in date default hr_api.g_date
979: ,p_row_value_uom in varchar2 default hr_api.g_varchar2
980: ,p_earnings_type in varchar2 default hr_api.g_varchar2
981: ,p_business_group_id in number default hr_api.g_number
982: ,p_legislation_code in varchar2 default hr_api.g_varchar2
983: ,p_last_updated_login in number default hr_api.g_number
984: ,p_created_date in date default hr_api.g_date
985: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 982: ,p_legislation_code in varchar2 default hr_api.g_varchar2

978: ,p_effective_end_date in date default hr_api.g_date
979: ,p_row_value_uom in varchar2 default hr_api.g_varchar2
980: ,p_earnings_type in varchar2 default hr_api.g_varchar2
981: ,p_business_group_id in number default hr_api.g_number
982: ,p_legislation_code in varchar2 default hr_api.g_varchar2
983: ,p_last_updated_login in number default hr_api.g_number
984: ,p_created_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_last_updated_login in number default hr_api.g_number

979: ,p_row_value_uom in varchar2 default hr_api.g_varchar2
980: ,p_earnings_type in varchar2 default hr_api.g_varchar2
981: ,p_business_group_id in number default hr_api.g_number
982: ,p_legislation_code in varchar2 default hr_api.g_varchar2
983: ,p_last_updated_login in number default hr_api.g_number
984: ,p_created_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_created_date in date default hr_api.g_date

980: ,p_earnings_type in varchar2 default hr_api.g_varchar2
981: ,p_business_group_id in number default hr_api.g_number
982: ,p_legislation_code in varchar2 default hr_api.g_varchar2
983: ,p_last_updated_login in number default hr_api.g_number
984: ,p_created_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_business_group_id in number default hr_api.g_number
982: ,p_legislation_code in varchar2 default hr_api.g_varchar2
983: ,p_last_updated_login in number default hr_api.g_number
984: ,p_created_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_legislation_code in varchar2 default hr_api.g_varchar2
983: ,p_last_updated_login in number default hr_api.g_number
984: ,p_created_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_last_updated_login in number default hr_api.g_number
984: ,p_created_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_created_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_ran_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_ran_information_category in varchar2 default hr_api.g_varchar2
1017: ,p_ran_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_ran_information_category in varchar2 default hr_api.g_varchar2
1017: ,p_ran_information1 in varchar2 default hr_api.g_varchar2
1018: ,p_ran_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_ran_information_category in varchar2 default hr_api.g_varchar2
1017: ,p_ran_information1 in varchar2 default hr_api.g_varchar2
1018: ,p_ran_information2 in varchar2 default hr_api.g_varchar2
1019: ,p_ran_information3 in varchar2 default hr_api.g_varchar2

Line 1016: ,p_ran_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_ran_information_category in varchar2 default hr_api.g_varchar2
1017: ,p_ran_information1 in varchar2 default hr_api.g_varchar2
1018: ,p_ran_information2 in varchar2 default hr_api.g_varchar2
1019: ,p_ran_information3 in varchar2 default hr_api.g_varchar2
1020: ,p_ran_information4 in varchar2 default hr_api.g_varchar2

Line 1017: ,p_ran_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_ran_information_category in varchar2 default hr_api.g_varchar2
1017: ,p_ran_information1 in varchar2 default hr_api.g_varchar2
1018: ,p_ran_information2 in varchar2 default hr_api.g_varchar2
1019: ,p_ran_information3 in varchar2 default hr_api.g_varchar2
1020: ,p_ran_information4 in varchar2 default hr_api.g_varchar2
1021: ,p_ran_information5 in varchar2 default hr_api.g_varchar2

Line 1018: ,p_ran_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_ran_information_category in varchar2 default hr_api.g_varchar2
1017: ,p_ran_information1 in varchar2 default hr_api.g_varchar2
1018: ,p_ran_information2 in varchar2 default hr_api.g_varchar2
1019: ,p_ran_information3 in varchar2 default hr_api.g_varchar2
1020: ,p_ran_information4 in varchar2 default hr_api.g_varchar2
1021: ,p_ran_information5 in varchar2 default hr_api.g_varchar2
1022: ,p_ran_information6 in varchar2 default hr_api.g_varchar2

Line 1019: ,p_ran_information3 in varchar2 default hr_api.g_varchar2

1015: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1016: ,p_ran_information_category in varchar2 default hr_api.g_varchar2
1017: ,p_ran_information1 in varchar2 default hr_api.g_varchar2
1018: ,p_ran_information2 in varchar2 default hr_api.g_varchar2
1019: ,p_ran_information3 in varchar2 default hr_api.g_varchar2
1020: ,p_ran_information4 in varchar2 default hr_api.g_varchar2
1021: ,p_ran_information5 in varchar2 default hr_api.g_varchar2
1022: ,p_ran_information6 in varchar2 default hr_api.g_varchar2
1023: ,p_ran_information7 in varchar2 default hr_api.g_varchar2

Line 1020: ,p_ran_information4 in varchar2 default hr_api.g_varchar2

1016: ,p_ran_information_category in varchar2 default hr_api.g_varchar2
1017: ,p_ran_information1 in varchar2 default hr_api.g_varchar2
1018: ,p_ran_information2 in varchar2 default hr_api.g_varchar2
1019: ,p_ran_information3 in varchar2 default hr_api.g_varchar2
1020: ,p_ran_information4 in varchar2 default hr_api.g_varchar2
1021: ,p_ran_information5 in varchar2 default hr_api.g_varchar2
1022: ,p_ran_information6 in varchar2 default hr_api.g_varchar2
1023: ,p_ran_information7 in varchar2 default hr_api.g_varchar2
1024: ,p_ran_information8 in varchar2 default hr_api.g_varchar2

Line 1021: ,p_ran_information5 in varchar2 default hr_api.g_varchar2

1017: ,p_ran_information1 in varchar2 default hr_api.g_varchar2
1018: ,p_ran_information2 in varchar2 default hr_api.g_varchar2
1019: ,p_ran_information3 in varchar2 default hr_api.g_varchar2
1020: ,p_ran_information4 in varchar2 default hr_api.g_varchar2
1021: ,p_ran_information5 in varchar2 default hr_api.g_varchar2
1022: ,p_ran_information6 in varchar2 default hr_api.g_varchar2
1023: ,p_ran_information7 in varchar2 default hr_api.g_varchar2
1024: ,p_ran_information8 in varchar2 default hr_api.g_varchar2
1025: ,p_ran_information9 in varchar2 default hr_api.g_varchar2

Line 1022: ,p_ran_information6 in varchar2 default hr_api.g_varchar2

1018: ,p_ran_information2 in varchar2 default hr_api.g_varchar2
1019: ,p_ran_information3 in varchar2 default hr_api.g_varchar2
1020: ,p_ran_information4 in varchar2 default hr_api.g_varchar2
1021: ,p_ran_information5 in varchar2 default hr_api.g_varchar2
1022: ,p_ran_information6 in varchar2 default hr_api.g_varchar2
1023: ,p_ran_information7 in varchar2 default hr_api.g_varchar2
1024: ,p_ran_information8 in varchar2 default hr_api.g_varchar2
1025: ,p_ran_information9 in varchar2 default hr_api.g_varchar2
1026: ,p_ran_information10 in varchar2 default hr_api.g_varchar2

Line 1023: ,p_ran_information7 in varchar2 default hr_api.g_varchar2

1019: ,p_ran_information3 in varchar2 default hr_api.g_varchar2
1020: ,p_ran_information4 in varchar2 default hr_api.g_varchar2
1021: ,p_ran_information5 in varchar2 default hr_api.g_varchar2
1022: ,p_ran_information6 in varchar2 default hr_api.g_varchar2
1023: ,p_ran_information7 in varchar2 default hr_api.g_varchar2
1024: ,p_ran_information8 in varchar2 default hr_api.g_varchar2
1025: ,p_ran_information9 in varchar2 default hr_api.g_varchar2
1026: ,p_ran_information10 in varchar2 default hr_api.g_varchar2
1027: ,p_ran_information11 in varchar2 default hr_api.g_varchar2

Line 1024: ,p_ran_information8 in varchar2 default hr_api.g_varchar2

1020: ,p_ran_information4 in varchar2 default hr_api.g_varchar2
1021: ,p_ran_information5 in varchar2 default hr_api.g_varchar2
1022: ,p_ran_information6 in varchar2 default hr_api.g_varchar2
1023: ,p_ran_information7 in varchar2 default hr_api.g_varchar2
1024: ,p_ran_information8 in varchar2 default hr_api.g_varchar2
1025: ,p_ran_information9 in varchar2 default hr_api.g_varchar2
1026: ,p_ran_information10 in varchar2 default hr_api.g_varchar2
1027: ,p_ran_information11 in varchar2 default hr_api.g_varchar2
1028: ,p_ran_information12 in varchar2 default hr_api.g_varchar2

Line 1025: ,p_ran_information9 in varchar2 default hr_api.g_varchar2

1021: ,p_ran_information5 in varchar2 default hr_api.g_varchar2
1022: ,p_ran_information6 in varchar2 default hr_api.g_varchar2
1023: ,p_ran_information7 in varchar2 default hr_api.g_varchar2
1024: ,p_ran_information8 in varchar2 default hr_api.g_varchar2
1025: ,p_ran_information9 in varchar2 default hr_api.g_varchar2
1026: ,p_ran_information10 in varchar2 default hr_api.g_varchar2
1027: ,p_ran_information11 in varchar2 default hr_api.g_varchar2
1028: ,p_ran_information12 in varchar2 default hr_api.g_varchar2
1029: ,p_ran_information13 in varchar2 default hr_api.g_varchar2

Line 1026: ,p_ran_information10 in varchar2 default hr_api.g_varchar2

1022: ,p_ran_information6 in varchar2 default hr_api.g_varchar2
1023: ,p_ran_information7 in varchar2 default hr_api.g_varchar2
1024: ,p_ran_information8 in varchar2 default hr_api.g_varchar2
1025: ,p_ran_information9 in varchar2 default hr_api.g_varchar2
1026: ,p_ran_information10 in varchar2 default hr_api.g_varchar2
1027: ,p_ran_information11 in varchar2 default hr_api.g_varchar2
1028: ,p_ran_information12 in varchar2 default hr_api.g_varchar2
1029: ,p_ran_information13 in varchar2 default hr_api.g_varchar2
1030: ,p_ran_information14 in varchar2 default hr_api.g_varchar2

Line 1027: ,p_ran_information11 in varchar2 default hr_api.g_varchar2

1023: ,p_ran_information7 in varchar2 default hr_api.g_varchar2
1024: ,p_ran_information8 in varchar2 default hr_api.g_varchar2
1025: ,p_ran_information9 in varchar2 default hr_api.g_varchar2
1026: ,p_ran_information10 in varchar2 default hr_api.g_varchar2
1027: ,p_ran_information11 in varchar2 default hr_api.g_varchar2
1028: ,p_ran_information12 in varchar2 default hr_api.g_varchar2
1029: ,p_ran_information13 in varchar2 default hr_api.g_varchar2
1030: ,p_ran_information14 in varchar2 default hr_api.g_varchar2
1031: ,p_ran_information15 in varchar2 default hr_api.g_varchar2

Line 1028: ,p_ran_information12 in varchar2 default hr_api.g_varchar2

1024: ,p_ran_information8 in varchar2 default hr_api.g_varchar2
1025: ,p_ran_information9 in varchar2 default hr_api.g_varchar2
1026: ,p_ran_information10 in varchar2 default hr_api.g_varchar2
1027: ,p_ran_information11 in varchar2 default hr_api.g_varchar2
1028: ,p_ran_information12 in varchar2 default hr_api.g_varchar2
1029: ,p_ran_information13 in varchar2 default hr_api.g_varchar2
1030: ,p_ran_information14 in varchar2 default hr_api.g_varchar2
1031: ,p_ran_information15 in varchar2 default hr_api.g_varchar2
1032: ,p_ran_information16 in varchar2 default hr_api.g_varchar2

Line 1029: ,p_ran_information13 in varchar2 default hr_api.g_varchar2

1025: ,p_ran_information9 in varchar2 default hr_api.g_varchar2
1026: ,p_ran_information10 in varchar2 default hr_api.g_varchar2
1027: ,p_ran_information11 in varchar2 default hr_api.g_varchar2
1028: ,p_ran_information12 in varchar2 default hr_api.g_varchar2
1029: ,p_ran_information13 in varchar2 default hr_api.g_varchar2
1030: ,p_ran_information14 in varchar2 default hr_api.g_varchar2
1031: ,p_ran_information15 in varchar2 default hr_api.g_varchar2
1032: ,p_ran_information16 in varchar2 default hr_api.g_varchar2
1033: ,p_ran_information17 in varchar2 default hr_api.g_varchar2

Line 1030: ,p_ran_information14 in varchar2 default hr_api.g_varchar2

1026: ,p_ran_information10 in varchar2 default hr_api.g_varchar2
1027: ,p_ran_information11 in varchar2 default hr_api.g_varchar2
1028: ,p_ran_information12 in varchar2 default hr_api.g_varchar2
1029: ,p_ran_information13 in varchar2 default hr_api.g_varchar2
1030: ,p_ran_information14 in varchar2 default hr_api.g_varchar2
1031: ,p_ran_information15 in varchar2 default hr_api.g_varchar2
1032: ,p_ran_information16 in varchar2 default hr_api.g_varchar2
1033: ,p_ran_information17 in varchar2 default hr_api.g_varchar2
1034: ,p_ran_information18 in varchar2 default hr_api.g_varchar2

Line 1031: ,p_ran_information15 in varchar2 default hr_api.g_varchar2

1027: ,p_ran_information11 in varchar2 default hr_api.g_varchar2
1028: ,p_ran_information12 in varchar2 default hr_api.g_varchar2
1029: ,p_ran_information13 in varchar2 default hr_api.g_varchar2
1030: ,p_ran_information14 in varchar2 default hr_api.g_varchar2
1031: ,p_ran_information15 in varchar2 default hr_api.g_varchar2
1032: ,p_ran_information16 in varchar2 default hr_api.g_varchar2
1033: ,p_ran_information17 in varchar2 default hr_api.g_varchar2
1034: ,p_ran_information18 in varchar2 default hr_api.g_varchar2
1035: ,p_ran_information19 in varchar2 default hr_api.g_varchar2

Line 1032: ,p_ran_information16 in varchar2 default hr_api.g_varchar2

1028: ,p_ran_information12 in varchar2 default hr_api.g_varchar2
1029: ,p_ran_information13 in varchar2 default hr_api.g_varchar2
1030: ,p_ran_information14 in varchar2 default hr_api.g_varchar2
1031: ,p_ran_information15 in varchar2 default hr_api.g_varchar2
1032: ,p_ran_information16 in varchar2 default hr_api.g_varchar2
1033: ,p_ran_information17 in varchar2 default hr_api.g_varchar2
1034: ,p_ran_information18 in varchar2 default hr_api.g_varchar2
1035: ,p_ran_information19 in varchar2 default hr_api.g_varchar2
1036: ,p_ran_information20 in varchar2 default hr_api.g_varchar2

Line 1033: ,p_ran_information17 in varchar2 default hr_api.g_varchar2

1029: ,p_ran_information13 in varchar2 default hr_api.g_varchar2
1030: ,p_ran_information14 in varchar2 default hr_api.g_varchar2
1031: ,p_ran_information15 in varchar2 default hr_api.g_varchar2
1032: ,p_ran_information16 in varchar2 default hr_api.g_varchar2
1033: ,p_ran_information17 in varchar2 default hr_api.g_varchar2
1034: ,p_ran_information18 in varchar2 default hr_api.g_varchar2
1035: ,p_ran_information19 in varchar2 default hr_api.g_varchar2
1036: ,p_ran_information20 in varchar2 default hr_api.g_varchar2
1037: ,p_ran_information21 in varchar2 default hr_api.g_varchar2

Line 1034: ,p_ran_information18 in varchar2 default hr_api.g_varchar2

1030: ,p_ran_information14 in varchar2 default hr_api.g_varchar2
1031: ,p_ran_information15 in varchar2 default hr_api.g_varchar2
1032: ,p_ran_information16 in varchar2 default hr_api.g_varchar2
1033: ,p_ran_information17 in varchar2 default hr_api.g_varchar2
1034: ,p_ran_information18 in varchar2 default hr_api.g_varchar2
1035: ,p_ran_information19 in varchar2 default hr_api.g_varchar2
1036: ,p_ran_information20 in varchar2 default hr_api.g_varchar2
1037: ,p_ran_information21 in varchar2 default hr_api.g_varchar2
1038: ,p_ran_information22 in varchar2 default hr_api.g_varchar2

Line 1035: ,p_ran_information19 in varchar2 default hr_api.g_varchar2

1031: ,p_ran_information15 in varchar2 default hr_api.g_varchar2
1032: ,p_ran_information16 in varchar2 default hr_api.g_varchar2
1033: ,p_ran_information17 in varchar2 default hr_api.g_varchar2
1034: ,p_ran_information18 in varchar2 default hr_api.g_varchar2
1035: ,p_ran_information19 in varchar2 default hr_api.g_varchar2
1036: ,p_ran_information20 in varchar2 default hr_api.g_varchar2
1037: ,p_ran_information21 in varchar2 default hr_api.g_varchar2
1038: ,p_ran_information22 in varchar2 default hr_api.g_varchar2
1039: ,p_ran_information23 in varchar2 default hr_api.g_varchar2

Line 1036: ,p_ran_information20 in varchar2 default hr_api.g_varchar2

1032: ,p_ran_information16 in varchar2 default hr_api.g_varchar2
1033: ,p_ran_information17 in varchar2 default hr_api.g_varchar2
1034: ,p_ran_information18 in varchar2 default hr_api.g_varchar2
1035: ,p_ran_information19 in varchar2 default hr_api.g_varchar2
1036: ,p_ran_information20 in varchar2 default hr_api.g_varchar2
1037: ,p_ran_information21 in varchar2 default hr_api.g_varchar2
1038: ,p_ran_information22 in varchar2 default hr_api.g_varchar2
1039: ,p_ran_information23 in varchar2 default hr_api.g_varchar2
1040: ,p_ran_information24 in varchar2 default hr_api.g_varchar2

Line 1037: ,p_ran_information21 in varchar2 default hr_api.g_varchar2

1033: ,p_ran_information17 in varchar2 default hr_api.g_varchar2
1034: ,p_ran_information18 in varchar2 default hr_api.g_varchar2
1035: ,p_ran_information19 in varchar2 default hr_api.g_varchar2
1036: ,p_ran_information20 in varchar2 default hr_api.g_varchar2
1037: ,p_ran_information21 in varchar2 default hr_api.g_varchar2
1038: ,p_ran_information22 in varchar2 default hr_api.g_varchar2
1039: ,p_ran_information23 in varchar2 default hr_api.g_varchar2
1040: ,p_ran_information24 in varchar2 default hr_api.g_varchar2
1041: ,p_ran_information25 in varchar2 default hr_api.g_varchar2

Line 1038: ,p_ran_information22 in varchar2 default hr_api.g_varchar2

1034: ,p_ran_information18 in varchar2 default hr_api.g_varchar2
1035: ,p_ran_information19 in varchar2 default hr_api.g_varchar2
1036: ,p_ran_information20 in varchar2 default hr_api.g_varchar2
1037: ,p_ran_information21 in varchar2 default hr_api.g_varchar2
1038: ,p_ran_information22 in varchar2 default hr_api.g_varchar2
1039: ,p_ran_information23 in varchar2 default hr_api.g_varchar2
1040: ,p_ran_information24 in varchar2 default hr_api.g_varchar2
1041: ,p_ran_information25 in varchar2 default hr_api.g_varchar2
1042: ,p_ran_information26 in varchar2 default hr_api.g_varchar2

Line 1039: ,p_ran_information23 in varchar2 default hr_api.g_varchar2

1035: ,p_ran_information19 in varchar2 default hr_api.g_varchar2
1036: ,p_ran_information20 in varchar2 default hr_api.g_varchar2
1037: ,p_ran_information21 in varchar2 default hr_api.g_varchar2
1038: ,p_ran_information22 in varchar2 default hr_api.g_varchar2
1039: ,p_ran_information23 in varchar2 default hr_api.g_varchar2
1040: ,p_ran_information24 in varchar2 default hr_api.g_varchar2
1041: ,p_ran_information25 in varchar2 default hr_api.g_varchar2
1042: ,p_ran_information26 in varchar2 default hr_api.g_varchar2
1043: ,p_ran_information27 in varchar2 default hr_api.g_varchar2

Line 1040: ,p_ran_information24 in varchar2 default hr_api.g_varchar2

1036: ,p_ran_information20 in varchar2 default hr_api.g_varchar2
1037: ,p_ran_information21 in varchar2 default hr_api.g_varchar2
1038: ,p_ran_information22 in varchar2 default hr_api.g_varchar2
1039: ,p_ran_information23 in varchar2 default hr_api.g_varchar2
1040: ,p_ran_information24 in varchar2 default hr_api.g_varchar2
1041: ,p_ran_information25 in varchar2 default hr_api.g_varchar2
1042: ,p_ran_information26 in varchar2 default hr_api.g_varchar2
1043: ,p_ran_information27 in varchar2 default hr_api.g_varchar2
1044: ,p_ran_information28 in varchar2 default hr_api.g_varchar2

Line 1041: ,p_ran_information25 in varchar2 default hr_api.g_varchar2

1037: ,p_ran_information21 in varchar2 default hr_api.g_varchar2
1038: ,p_ran_information22 in varchar2 default hr_api.g_varchar2
1039: ,p_ran_information23 in varchar2 default hr_api.g_varchar2
1040: ,p_ran_information24 in varchar2 default hr_api.g_varchar2
1041: ,p_ran_information25 in varchar2 default hr_api.g_varchar2
1042: ,p_ran_information26 in varchar2 default hr_api.g_varchar2
1043: ,p_ran_information27 in varchar2 default hr_api.g_varchar2
1044: ,p_ran_information28 in varchar2 default hr_api.g_varchar2
1045: ,p_ran_information29 in varchar2 default hr_api.g_varchar2

Line 1042: ,p_ran_information26 in varchar2 default hr_api.g_varchar2

1038: ,p_ran_information22 in varchar2 default hr_api.g_varchar2
1039: ,p_ran_information23 in varchar2 default hr_api.g_varchar2
1040: ,p_ran_information24 in varchar2 default hr_api.g_varchar2
1041: ,p_ran_information25 in varchar2 default hr_api.g_varchar2
1042: ,p_ran_information26 in varchar2 default hr_api.g_varchar2
1043: ,p_ran_information27 in varchar2 default hr_api.g_varchar2
1044: ,p_ran_information28 in varchar2 default hr_api.g_varchar2
1045: ,p_ran_information29 in varchar2 default hr_api.g_varchar2
1046: ,p_ran_information30 in varchar2 default hr_api.g_varchar2

Line 1043: ,p_ran_information27 in varchar2 default hr_api.g_varchar2

1039: ,p_ran_information23 in varchar2 default hr_api.g_varchar2
1040: ,p_ran_information24 in varchar2 default hr_api.g_varchar2
1041: ,p_ran_information25 in varchar2 default hr_api.g_varchar2
1042: ,p_ran_information26 in varchar2 default hr_api.g_varchar2
1043: ,p_ran_information27 in varchar2 default hr_api.g_varchar2
1044: ,p_ran_information28 in varchar2 default hr_api.g_varchar2
1045: ,p_ran_information29 in varchar2 default hr_api.g_varchar2
1046: ,p_ran_information30 in varchar2 default hr_api.g_varchar2
1047: ) is

Line 1044: ,p_ran_information28 in varchar2 default hr_api.g_varchar2

1040: ,p_ran_information24 in varchar2 default hr_api.g_varchar2
1041: ,p_ran_information25 in varchar2 default hr_api.g_varchar2
1042: ,p_ran_information26 in varchar2 default hr_api.g_varchar2
1043: ,p_ran_information27 in varchar2 default hr_api.g_varchar2
1044: ,p_ran_information28 in varchar2 default hr_api.g_varchar2
1045: ,p_ran_information29 in varchar2 default hr_api.g_varchar2
1046: ,p_ran_information30 in varchar2 default hr_api.g_varchar2
1047: ) is
1048: --

Line 1045: ,p_ran_information29 in varchar2 default hr_api.g_varchar2

1041: ,p_ran_information25 in varchar2 default hr_api.g_varchar2
1042: ,p_ran_information26 in varchar2 default hr_api.g_varchar2
1043: ,p_ran_information27 in varchar2 default hr_api.g_varchar2
1044: ,p_ran_information28 in varchar2 default hr_api.g_varchar2
1045: ,p_ran_information29 in varchar2 default hr_api.g_varchar2
1046: ,p_ran_information30 in varchar2 default hr_api.g_varchar2
1047: ) is
1048: --
1049: l_rec pay_prf_shd.g_rec_type;

Line 1046: ,p_ran_information30 in varchar2 default hr_api.g_varchar2

1042: ,p_ran_information26 in varchar2 default hr_api.g_varchar2
1043: ,p_ran_information27 in varchar2 default hr_api.g_varchar2
1044: ,p_ran_information28 in varchar2 default hr_api.g_varchar2
1045: ,p_ran_information29 in varchar2 default hr_api.g_varchar2
1046: ,p_ran_information30 in varchar2 default hr_api.g_varchar2
1047: ) is
1048: --
1049: l_rec pay_prf_shd.g_rec_type;
1050: l_proc varchar2(72) := g_package||'upd';