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

Line 70: If (p_datetrack_mode = hr_api.g_correction) then

66: --
67: Begin
68: hr_utility.set_location('Entering:'||l_proc, 5);
69: --
70: If (p_datetrack_mode = hr_api.g_correction) then
71: hr_utility.set_location(l_proc, 10);
72: --
73: -- Because we are updating a row we must get the next object
74: -- version number.

Line 144: When hr_api.check_integrity_violated Then

140: End If;
141: --
142: hr_utility.set_location(' Leaving:'||l_proc, 15);
143: Exception
144: When hr_api.check_integrity_violated Then
145: -- A check constraint has been violated
146: ben_otp_shd.g_api_dml := false; -- Unset the api dml status
147: ben_otp_shd.constraint_error
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

144: When hr_api.check_integrity_violated Then
145: -- A check constraint has been violated
146: ben_otp_shd.g_api_dml := false; -- Unset the api dml status
147: ben_otp_shd.constraint_error
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
149: When hr_api.unique_integrity_violated Then
150: -- Unique integrity has been violated
151: ben_otp_shd.g_api_dml := false; -- Unset the api dml status
152: ben_otp_shd.constraint_error

Line 149: When hr_api.unique_integrity_violated Then

145: -- A check constraint has been violated
146: ben_otp_shd.g_api_dml := false; -- Unset the api dml status
147: ben_otp_shd.constraint_error
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
149: When hr_api.unique_integrity_violated Then
150: -- Unique integrity has been violated
151: ben_otp_shd.g_api_dml := false; -- Unset the api dml status
152: ben_otp_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

149: When hr_api.unique_integrity_violated Then
150: -- Unique integrity has been violated
151: ben_otp_shd.g_api_dml := false; -- Unset the api dml status
152: ben_otp_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: When Others Then
155: ben_otp_shd.g_api_dml := false; -- Unset the api dml status
156: Raise;
157: End dt_update_dml;

Line 270: If (p_datetrack_mode <> hr_api.g_correction) then

266: l_dummy_version_number number;
267: --
268: Begin
269: hr_utility.set_location('Entering:'||l_proc, 5);
270: If (p_datetrack_mode <> hr_api.g_correction) then
271: --
272: -- Update the current effective end date
273: --
274: ben_otp_shd.upd_effective_end_date

Line 283: If (p_datetrack_mode = hr_api.g_update_override) then

279: ,p_validation_end_date => p_validation_end_date
280: ,p_object_version_number => l_dummy_version_number
281: );
282: --
283: If (p_datetrack_mode = hr_api.g_update_override) then
284: --
285: -- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
286: -- delete any future rows
287: --

Line 598: when hr_api.cannot_find_prog_unit then

594: );
595: --
596: exception
597: --
598: when hr_api.cannot_find_prog_unit then
599: --
600: hr_api.cannot_find_prog_unit_error
601: (p_module_name => 'BEN_OPTIP_F'
602: ,p_hook_type => 'AU');

Line 600: hr_api.cannot_find_prog_unit_error

596: exception
597: --
598: when hr_api.cannot_find_prog_unit then
599: --
600: hr_api.cannot_find_prog_unit_error
601: (p_module_name => 'BEN_OPTIP_F'
602: ,p_hook_type => 'AU');
603: --
604: end;

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

659: -- p_rec plsql record structure
660: -- to see if a system default is being used. If a system default
661: -- is being used then we must set to the 'current' argument value.
662: --
663: If (p_rec.business_group_id = hr_api.g_number) then
664: p_rec.business_group_id :=
665: ben_otp_shd.g_old_rec.business_group_id;
666: End If;
667: If (p_rec.pgm_id = hr_api.g_number) then

Line 667: If (p_rec.pgm_id = hr_api.g_number) then

663: If (p_rec.business_group_id = hr_api.g_number) then
664: p_rec.business_group_id :=
665: ben_otp_shd.g_old_rec.business_group_id;
666: End If;
667: If (p_rec.pgm_id = hr_api.g_number) then
668: p_rec.pgm_id :=
669: ben_otp_shd.g_old_rec.pgm_id;
670: End If;
671: If (p_rec.ptip_id = hr_api.g_number) then

Line 671: If (p_rec.ptip_id = hr_api.g_number) then

667: If (p_rec.pgm_id = hr_api.g_number) then
668: p_rec.pgm_id :=
669: ben_otp_shd.g_old_rec.pgm_id;
670: End If;
671: If (p_rec.ptip_id = hr_api.g_number) then
672: p_rec.ptip_id :=
673: ben_otp_shd.g_old_rec.ptip_id;
674: End If;
675: If (p_rec.pl_typ_id = hr_api.g_number) then

Line 675: If (p_rec.pl_typ_id = hr_api.g_number) then

671: If (p_rec.ptip_id = hr_api.g_number) then
672: p_rec.ptip_id :=
673: ben_otp_shd.g_old_rec.ptip_id;
674: End If;
675: If (p_rec.pl_typ_id = hr_api.g_number) then
676: p_rec.pl_typ_id :=
677: ben_otp_shd.g_old_rec.pl_typ_id;
678: End If;
679: If (p_rec.opt_id = hr_api.g_number) then

Line 679: If (p_rec.opt_id = hr_api.g_number) then

675: If (p_rec.pl_typ_id = hr_api.g_number) then
676: p_rec.pl_typ_id :=
677: ben_otp_shd.g_old_rec.pl_typ_id;
678: End If;
679: If (p_rec.opt_id = hr_api.g_number) then
680: p_rec.opt_id :=
681: ben_otp_shd.g_old_rec.opt_id;
682: End If;
683: If (p_rec.cmbn_ptip_opt_id = hr_api.g_number) then

Line 683: If (p_rec.cmbn_ptip_opt_id = hr_api.g_number) then

679: If (p_rec.opt_id = hr_api.g_number) then
680: p_rec.opt_id :=
681: ben_otp_shd.g_old_rec.opt_id;
682: End If;
683: If (p_rec.cmbn_ptip_opt_id = hr_api.g_number) then
684: p_rec.cmbn_ptip_opt_id :=
685: ben_otp_shd.g_old_rec.cmbn_ptip_opt_id;
686: End If;
687: If (p_rec.legislation_code = hr_api.g_varchar2) then

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

683: If (p_rec.cmbn_ptip_opt_id = hr_api.g_number) then
684: p_rec.cmbn_ptip_opt_id :=
685: ben_otp_shd.g_old_rec.cmbn_ptip_opt_id;
686: End If;
687: If (p_rec.legislation_code = hr_api.g_varchar2) then
688: p_rec.legislation_code :=
689: ben_otp_shd.g_old_rec.legislation_code;
690: End If;
691: If (p_rec.legislation_subgroup = hr_api.g_varchar2) then

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

687: If (p_rec.legislation_code = hr_api.g_varchar2) then
688: p_rec.legislation_code :=
689: ben_otp_shd.g_old_rec.legislation_code;
690: End If;
691: If (p_rec.legislation_subgroup = hr_api.g_varchar2) then
692: p_rec.legislation_subgroup :=
693: ben_otp_shd.g_old_rec.legislation_subgroup;
694: End If;
695: If (p_rec.otp_attribute_category = hr_api.g_varchar2) then

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

691: If (p_rec.legislation_subgroup = hr_api.g_varchar2) then
692: p_rec.legislation_subgroup :=
693: ben_otp_shd.g_old_rec.legislation_subgroup;
694: End If;
695: If (p_rec.otp_attribute_category = hr_api.g_varchar2) then
696: p_rec.otp_attribute_category :=
697: ben_otp_shd.g_old_rec.otp_attribute_category;
698: End If;
699: If (p_rec.otp_attribute1 = hr_api.g_varchar2) then

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

695: If (p_rec.otp_attribute_category = hr_api.g_varchar2) then
696: p_rec.otp_attribute_category :=
697: ben_otp_shd.g_old_rec.otp_attribute_category;
698: End If;
699: If (p_rec.otp_attribute1 = hr_api.g_varchar2) then
700: p_rec.otp_attribute1 :=
701: ben_otp_shd.g_old_rec.otp_attribute1;
702: End If;
703: If (p_rec.otp_attribute2 = hr_api.g_varchar2) then

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

699: If (p_rec.otp_attribute1 = hr_api.g_varchar2) then
700: p_rec.otp_attribute1 :=
701: ben_otp_shd.g_old_rec.otp_attribute1;
702: End If;
703: If (p_rec.otp_attribute2 = hr_api.g_varchar2) then
704: p_rec.otp_attribute2 :=
705: ben_otp_shd.g_old_rec.otp_attribute2;
706: End If;
707: If (p_rec.otp_attribute3 = hr_api.g_varchar2) then

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

703: If (p_rec.otp_attribute2 = hr_api.g_varchar2) then
704: p_rec.otp_attribute2 :=
705: ben_otp_shd.g_old_rec.otp_attribute2;
706: End If;
707: If (p_rec.otp_attribute3 = hr_api.g_varchar2) then
708: p_rec.otp_attribute3 :=
709: ben_otp_shd.g_old_rec.otp_attribute3;
710: End If;
711: If (p_rec.otp_attribute4 = hr_api.g_varchar2) then

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

707: If (p_rec.otp_attribute3 = hr_api.g_varchar2) then
708: p_rec.otp_attribute3 :=
709: ben_otp_shd.g_old_rec.otp_attribute3;
710: End If;
711: If (p_rec.otp_attribute4 = hr_api.g_varchar2) then
712: p_rec.otp_attribute4 :=
713: ben_otp_shd.g_old_rec.otp_attribute4;
714: End If;
715: If (p_rec.otp_attribute5 = hr_api.g_varchar2) then

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

711: If (p_rec.otp_attribute4 = hr_api.g_varchar2) then
712: p_rec.otp_attribute4 :=
713: ben_otp_shd.g_old_rec.otp_attribute4;
714: End If;
715: If (p_rec.otp_attribute5 = hr_api.g_varchar2) then
716: p_rec.otp_attribute5 :=
717: ben_otp_shd.g_old_rec.otp_attribute5;
718: End If;
719: If (p_rec.otp_attribute6 = hr_api.g_varchar2) then

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

715: If (p_rec.otp_attribute5 = hr_api.g_varchar2) then
716: p_rec.otp_attribute5 :=
717: ben_otp_shd.g_old_rec.otp_attribute5;
718: End If;
719: If (p_rec.otp_attribute6 = hr_api.g_varchar2) then
720: p_rec.otp_attribute6 :=
721: ben_otp_shd.g_old_rec.otp_attribute6;
722: End If;
723: If (p_rec.otp_attribute7 = hr_api.g_varchar2) then

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

719: If (p_rec.otp_attribute6 = hr_api.g_varchar2) then
720: p_rec.otp_attribute6 :=
721: ben_otp_shd.g_old_rec.otp_attribute6;
722: End If;
723: If (p_rec.otp_attribute7 = hr_api.g_varchar2) then
724: p_rec.otp_attribute7 :=
725: ben_otp_shd.g_old_rec.otp_attribute7;
726: End If;
727: If (p_rec.otp_attribute8 = hr_api.g_varchar2) then

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

723: If (p_rec.otp_attribute7 = hr_api.g_varchar2) then
724: p_rec.otp_attribute7 :=
725: ben_otp_shd.g_old_rec.otp_attribute7;
726: End If;
727: If (p_rec.otp_attribute8 = hr_api.g_varchar2) then
728: p_rec.otp_attribute8 :=
729: ben_otp_shd.g_old_rec.otp_attribute8;
730: End If;
731: If (p_rec.otp_attribute9 = hr_api.g_varchar2) then

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

727: If (p_rec.otp_attribute8 = hr_api.g_varchar2) then
728: p_rec.otp_attribute8 :=
729: ben_otp_shd.g_old_rec.otp_attribute8;
730: End If;
731: If (p_rec.otp_attribute9 = hr_api.g_varchar2) then
732: p_rec.otp_attribute9 :=
733: ben_otp_shd.g_old_rec.otp_attribute9;
734: End If;
735: If (p_rec.otp_attribute10 = hr_api.g_varchar2) then

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

731: If (p_rec.otp_attribute9 = hr_api.g_varchar2) then
732: p_rec.otp_attribute9 :=
733: ben_otp_shd.g_old_rec.otp_attribute9;
734: End If;
735: If (p_rec.otp_attribute10 = hr_api.g_varchar2) then
736: p_rec.otp_attribute10 :=
737: ben_otp_shd.g_old_rec.otp_attribute10;
738: End If;
739: If (p_rec.otp_attribute11 = hr_api.g_varchar2) then

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

735: If (p_rec.otp_attribute10 = hr_api.g_varchar2) then
736: p_rec.otp_attribute10 :=
737: ben_otp_shd.g_old_rec.otp_attribute10;
738: End If;
739: If (p_rec.otp_attribute11 = hr_api.g_varchar2) then
740: p_rec.otp_attribute11 :=
741: ben_otp_shd.g_old_rec.otp_attribute11;
742: End If;
743: If (p_rec.otp_attribute12 = hr_api.g_varchar2) then

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

739: If (p_rec.otp_attribute11 = hr_api.g_varchar2) then
740: p_rec.otp_attribute11 :=
741: ben_otp_shd.g_old_rec.otp_attribute11;
742: End If;
743: If (p_rec.otp_attribute12 = hr_api.g_varchar2) then
744: p_rec.otp_attribute12 :=
745: ben_otp_shd.g_old_rec.otp_attribute12;
746: End If;
747: If (p_rec.otp_attribute13 = hr_api.g_varchar2) then

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

743: If (p_rec.otp_attribute12 = hr_api.g_varchar2) then
744: p_rec.otp_attribute12 :=
745: ben_otp_shd.g_old_rec.otp_attribute12;
746: End If;
747: If (p_rec.otp_attribute13 = hr_api.g_varchar2) then
748: p_rec.otp_attribute13 :=
749: ben_otp_shd.g_old_rec.otp_attribute13;
750: End If;
751: If (p_rec.otp_attribute14 = hr_api.g_varchar2) then

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

747: If (p_rec.otp_attribute13 = hr_api.g_varchar2) then
748: p_rec.otp_attribute13 :=
749: ben_otp_shd.g_old_rec.otp_attribute13;
750: End If;
751: If (p_rec.otp_attribute14 = hr_api.g_varchar2) then
752: p_rec.otp_attribute14 :=
753: ben_otp_shd.g_old_rec.otp_attribute14;
754: End If;
755: If (p_rec.otp_attribute15 = hr_api.g_varchar2) then

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

751: If (p_rec.otp_attribute14 = hr_api.g_varchar2) then
752: p_rec.otp_attribute14 :=
753: ben_otp_shd.g_old_rec.otp_attribute14;
754: End If;
755: If (p_rec.otp_attribute15 = hr_api.g_varchar2) then
756: p_rec.otp_attribute15 :=
757: ben_otp_shd.g_old_rec.otp_attribute15;
758: End If;
759: If (p_rec.otp_attribute16 = hr_api.g_varchar2) then

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

755: If (p_rec.otp_attribute15 = hr_api.g_varchar2) then
756: p_rec.otp_attribute15 :=
757: ben_otp_shd.g_old_rec.otp_attribute15;
758: End If;
759: If (p_rec.otp_attribute16 = hr_api.g_varchar2) then
760: p_rec.otp_attribute16 :=
761: ben_otp_shd.g_old_rec.otp_attribute16;
762: End If;
763: If (p_rec.otp_attribute17 = hr_api.g_varchar2) then

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

759: If (p_rec.otp_attribute16 = hr_api.g_varchar2) then
760: p_rec.otp_attribute16 :=
761: ben_otp_shd.g_old_rec.otp_attribute16;
762: End If;
763: If (p_rec.otp_attribute17 = hr_api.g_varchar2) then
764: p_rec.otp_attribute17 :=
765: ben_otp_shd.g_old_rec.otp_attribute17;
766: End If;
767: If (p_rec.otp_attribute18 = hr_api.g_varchar2) then

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

763: If (p_rec.otp_attribute17 = hr_api.g_varchar2) then
764: p_rec.otp_attribute17 :=
765: ben_otp_shd.g_old_rec.otp_attribute17;
766: End If;
767: If (p_rec.otp_attribute18 = hr_api.g_varchar2) then
768: p_rec.otp_attribute18 :=
769: ben_otp_shd.g_old_rec.otp_attribute18;
770: End If;
771: If (p_rec.otp_attribute19 = hr_api.g_varchar2) then

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

767: If (p_rec.otp_attribute18 = hr_api.g_varchar2) then
768: p_rec.otp_attribute18 :=
769: ben_otp_shd.g_old_rec.otp_attribute18;
770: End If;
771: If (p_rec.otp_attribute19 = hr_api.g_varchar2) then
772: p_rec.otp_attribute19 :=
773: ben_otp_shd.g_old_rec.otp_attribute19;
774: End If;
775: If (p_rec.otp_attribute20 = hr_api.g_varchar2) then

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

771: If (p_rec.otp_attribute19 = hr_api.g_varchar2) then
772: p_rec.otp_attribute19 :=
773: ben_otp_shd.g_old_rec.otp_attribute19;
774: End If;
775: If (p_rec.otp_attribute20 = hr_api.g_varchar2) then
776: p_rec.otp_attribute20 :=
777: ben_otp_shd.g_old_rec.otp_attribute20;
778: End If;
779: If (p_rec.otp_attribute21 = hr_api.g_varchar2) then

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

775: If (p_rec.otp_attribute20 = hr_api.g_varchar2) then
776: p_rec.otp_attribute20 :=
777: ben_otp_shd.g_old_rec.otp_attribute20;
778: End If;
779: If (p_rec.otp_attribute21 = hr_api.g_varchar2) then
780: p_rec.otp_attribute21 :=
781: ben_otp_shd.g_old_rec.otp_attribute21;
782: End If;
783: If (p_rec.otp_attribute22 = hr_api.g_varchar2) then

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

779: If (p_rec.otp_attribute21 = hr_api.g_varchar2) then
780: p_rec.otp_attribute21 :=
781: ben_otp_shd.g_old_rec.otp_attribute21;
782: End If;
783: If (p_rec.otp_attribute22 = hr_api.g_varchar2) then
784: p_rec.otp_attribute22 :=
785: ben_otp_shd.g_old_rec.otp_attribute22;
786: End If;
787: If (p_rec.otp_attribute23 = hr_api.g_varchar2) then

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

783: If (p_rec.otp_attribute22 = hr_api.g_varchar2) then
784: p_rec.otp_attribute22 :=
785: ben_otp_shd.g_old_rec.otp_attribute22;
786: End If;
787: If (p_rec.otp_attribute23 = hr_api.g_varchar2) then
788: p_rec.otp_attribute23 :=
789: ben_otp_shd.g_old_rec.otp_attribute23;
790: End If;
791: If (p_rec.otp_attribute24 = hr_api.g_varchar2) then

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

787: If (p_rec.otp_attribute23 = hr_api.g_varchar2) then
788: p_rec.otp_attribute23 :=
789: ben_otp_shd.g_old_rec.otp_attribute23;
790: End If;
791: If (p_rec.otp_attribute24 = hr_api.g_varchar2) then
792: p_rec.otp_attribute24 :=
793: ben_otp_shd.g_old_rec.otp_attribute24;
794: End If;
795: If (p_rec.otp_attribute25 = hr_api.g_varchar2) then

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

791: If (p_rec.otp_attribute24 = hr_api.g_varchar2) then
792: p_rec.otp_attribute24 :=
793: ben_otp_shd.g_old_rec.otp_attribute24;
794: End If;
795: If (p_rec.otp_attribute25 = hr_api.g_varchar2) then
796: p_rec.otp_attribute25 :=
797: ben_otp_shd.g_old_rec.otp_attribute25;
798: End If;
799: If (p_rec.otp_attribute26 = hr_api.g_varchar2) then

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

795: If (p_rec.otp_attribute25 = hr_api.g_varchar2) then
796: p_rec.otp_attribute25 :=
797: ben_otp_shd.g_old_rec.otp_attribute25;
798: End If;
799: If (p_rec.otp_attribute26 = hr_api.g_varchar2) then
800: p_rec.otp_attribute26 :=
801: ben_otp_shd.g_old_rec.otp_attribute26;
802: End If;
803: If (p_rec.otp_attribute27 = hr_api.g_varchar2) then

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

799: If (p_rec.otp_attribute26 = hr_api.g_varchar2) then
800: p_rec.otp_attribute26 :=
801: ben_otp_shd.g_old_rec.otp_attribute26;
802: End If;
803: If (p_rec.otp_attribute27 = hr_api.g_varchar2) then
804: p_rec.otp_attribute27 :=
805: ben_otp_shd.g_old_rec.otp_attribute27;
806: End If;
807: If (p_rec.otp_attribute28 = hr_api.g_varchar2) then

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

803: If (p_rec.otp_attribute27 = hr_api.g_varchar2) then
804: p_rec.otp_attribute27 :=
805: ben_otp_shd.g_old_rec.otp_attribute27;
806: End If;
807: If (p_rec.otp_attribute28 = hr_api.g_varchar2) then
808: p_rec.otp_attribute28 :=
809: ben_otp_shd.g_old_rec.otp_attribute28;
810: End If;
811: If (p_rec.otp_attribute29 = hr_api.g_varchar2) then

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

807: If (p_rec.otp_attribute28 = hr_api.g_varchar2) then
808: p_rec.otp_attribute28 :=
809: ben_otp_shd.g_old_rec.otp_attribute28;
810: End If;
811: If (p_rec.otp_attribute29 = hr_api.g_varchar2) then
812: p_rec.otp_attribute29 :=
813: ben_otp_shd.g_old_rec.otp_attribute29;
814: End If;
815: If (p_rec.otp_attribute30 = hr_api.g_varchar2) then

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

811: If (p_rec.otp_attribute29 = hr_api.g_varchar2) then
812: p_rec.otp_attribute29 :=
813: ben_otp_shd.g_old_rec.otp_attribute29;
814: End If;
815: If (p_rec.otp_attribute30 = hr_api.g_varchar2) then
816: p_rec.otp_attribute30 :=
817: ben_otp_shd.g_old_rec.otp_attribute30;
818: End If;
819: --

Line 908: ,p_business_group_id in number default hr_api.g_number

904: (p_effective_date in date
905: ,p_datetrack_mode in varchar2
906: ,p_optip_id in number
907: ,p_object_version_number in out nocopy number
908: ,p_business_group_id in number default hr_api.g_number
909: ,p_pgm_id in number default hr_api.g_number
910: ,p_ptip_id in number default hr_api.g_number
911: ,p_pl_typ_id in number default hr_api.g_number
912: ,p_opt_id in number default hr_api.g_number

Line 909: ,p_pgm_id in number default hr_api.g_number

905: ,p_datetrack_mode in varchar2
906: ,p_optip_id in number
907: ,p_object_version_number in out nocopy number
908: ,p_business_group_id in number default hr_api.g_number
909: ,p_pgm_id in number default hr_api.g_number
910: ,p_ptip_id in number default hr_api.g_number
911: ,p_pl_typ_id in number default hr_api.g_number
912: ,p_opt_id in number default hr_api.g_number
913: ,p_cmbn_ptip_opt_id in number default hr_api.g_number

Line 910: ,p_ptip_id in number default hr_api.g_number

906: ,p_optip_id in number
907: ,p_object_version_number in out nocopy number
908: ,p_business_group_id in number default hr_api.g_number
909: ,p_pgm_id in number default hr_api.g_number
910: ,p_ptip_id in number default hr_api.g_number
911: ,p_pl_typ_id in number default hr_api.g_number
912: ,p_opt_id in number default hr_api.g_number
913: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
914: ,p_legislation_code in varchar2 default hr_api.g_varchar2

Line 911: ,p_pl_typ_id in number default hr_api.g_number

907: ,p_object_version_number in out nocopy number
908: ,p_business_group_id in number default hr_api.g_number
909: ,p_pgm_id in number default hr_api.g_number
910: ,p_ptip_id in number default hr_api.g_number
911: ,p_pl_typ_id in number default hr_api.g_number
912: ,p_opt_id in number default hr_api.g_number
913: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
914: ,p_legislation_code in varchar2 default hr_api.g_varchar2
915: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2

Line 912: ,p_opt_id in number default hr_api.g_number

908: ,p_business_group_id in number default hr_api.g_number
909: ,p_pgm_id in number default hr_api.g_number
910: ,p_ptip_id in number default hr_api.g_number
911: ,p_pl_typ_id in number default hr_api.g_number
912: ,p_opt_id in number default hr_api.g_number
913: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
914: ,p_legislation_code in varchar2 default hr_api.g_varchar2
915: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
916: ,p_otp_attribute_category in varchar2 default hr_api.g_varchar2

Line 913: ,p_cmbn_ptip_opt_id in number default hr_api.g_number

909: ,p_pgm_id in number default hr_api.g_number
910: ,p_ptip_id in number default hr_api.g_number
911: ,p_pl_typ_id in number default hr_api.g_number
912: ,p_opt_id in number default hr_api.g_number
913: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
914: ,p_legislation_code in varchar2 default hr_api.g_varchar2
915: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
916: ,p_otp_attribute_category in varchar2 default hr_api.g_varchar2
917: ,p_otp_attribute1 in varchar2 default hr_api.g_varchar2

Line 914: ,p_legislation_code in varchar2 default hr_api.g_varchar2

910: ,p_ptip_id in number default hr_api.g_number
911: ,p_pl_typ_id in number default hr_api.g_number
912: ,p_opt_id in number default hr_api.g_number
913: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
914: ,p_legislation_code in varchar2 default hr_api.g_varchar2
915: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
916: ,p_otp_attribute_category in varchar2 default hr_api.g_varchar2
917: ,p_otp_attribute1 in varchar2 default hr_api.g_varchar2
918: ,p_otp_attribute2 in varchar2 default hr_api.g_varchar2

Line 915: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2

911: ,p_pl_typ_id in number default hr_api.g_number
912: ,p_opt_id in number default hr_api.g_number
913: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
914: ,p_legislation_code in varchar2 default hr_api.g_varchar2
915: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
916: ,p_otp_attribute_category in varchar2 default hr_api.g_varchar2
917: ,p_otp_attribute1 in varchar2 default hr_api.g_varchar2
918: ,p_otp_attribute2 in varchar2 default hr_api.g_varchar2
919: ,p_otp_attribute3 in varchar2 default hr_api.g_varchar2

Line 916: ,p_otp_attribute_category in varchar2 default hr_api.g_varchar2

912: ,p_opt_id in number default hr_api.g_number
913: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
914: ,p_legislation_code in varchar2 default hr_api.g_varchar2
915: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
916: ,p_otp_attribute_category in varchar2 default hr_api.g_varchar2
917: ,p_otp_attribute1 in varchar2 default hr_api.g_varchar2
918: ,p_otp_attribute2 in varchar2 default hr_api.g_varchar2
919: ,p_otp_attribute3 in varchar2 default hr_api.g_varchar2
920: ,p_otp_attribute4 in varchar2 default hr_api.g_varchar2

Line 917: ,p_otp_attribute1 in varchar2 default hr_api.g_varchar2

913: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
914: ,p_legislation_code in varchar2 default hr_api.g_varchar2
915: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
916: ,p_otp_attribute_category in varchar2 default hr_api.g_varchar2
917: ,p_otp_attribute1 in varchar2 default hr_api.g_varchar2
918: ,p_otp_attribute2 in varchar2 default hr_api.g_varchar2
919: ,p_otp_attribute3 in varchar2 default hr_api.g_varchar2
920: ,p_otp_attribute4 in varchar2 default hr_api.g_varchar2
921: ,p_otp_attribute5 in varchar2 default hr_api.g_varchar2

Line 918: ,p_otp_attribute2 in varchar2 default hr_api.g_varchar2

914: ,p_legislation_code in varchar2 default hr_api.g_varchar2
915: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
916: ,p_otp_attribute_category in varchar2 default hr_api.g_varchar2
917: ,p_otp_attribute1 in varchar2 default hr_api.g_varchar2
918: ,p_otp_attribute2 in varchar2 default hr_api.g_varchar2
919: ,p_otp_attribute3 in varchar2 default hr_api.g_varchar2
920: ,p_otp_attribute4 in varchar2 default hr_api.g_varchar2
921: ,p_otp_attribute5 in varchar2 default hr_api.g_varchar2
922: ,p_otp_attribute6 in varchar2 default hr_api.g_varchar2

Line 919: ,p_otp_attribute3 in varchar2 default hr_api.g_varchar2

915: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
916: ,p_otp_attribute_category in varchar2 default hr_api.g_varchar2
917: ,p_otp_attribute1 in varchar2 default hr_api.g_varchar2
918: ,p_otp_attribute2 in varchar2 default hr_api.g_varchar2
919: ,p_otp_attribute3 in varchar2 default hr_api.g_varchar2
920: ,p_otp_attribute4 in varchar2 default hr_api.g_varchar2
921: ,p_otp_attribute5 in varchar2 default hr_api.g_varchar2
922: ,p_otp_attribute6 in varchar2 default hr_api.g_varchar2
923: ,p_otp_attribute7 in varchar2 default hr_api.g_varchar2

Line 920: ,p_otp_attribute4 in varchar2 default hr_api.g_varchar2

916: ,p_otp_attribute_category in varchar2 default hr_api.g_varchar2
917: ,p_otp_attribute1 in varchar2 default hr_api.g_varchar2
918: ,p_otp_attribute2 in varchar2 default hr_api.g_varchar2
919: ,p_otp_attribute3 in varchar2 default hr_api.g_varchar2
920: ,p_otp_attribute4 in varchar2 default hr_api.g_varchar2
921: ,p_otp_attribute5 in varchar2 default hr_api.g_varchar2
922: ,p_otp_attribute6 in varchar2 default hr_api.g_varchar2
923: ,p_otp_attribute7 in varchar2 default hr_api.g_varchar2
924: ,p_otp_attribute8 in varchar2 default hr_api.g_varchar2

Line 921: ,p_otp_attribute5 in varchar2 default hr_api.g_varchar2

917: ,p_otp_attribute1 in varchar2 default hr_api.g_varchar2
918: ,p_otp_attribute2 in varchar2 default hr_api.g_varchar2
919: ,p_otp_attribute3 in varchar2 default hr_api.g_varchar2
920: ,p_otp_attribute4 in varchar2 default hr_api.g_varchar2
921: ,p_otp_attribute5 in varchar2 default hr_api.g_varchar2
922: ,p_otp_attribute6 in varchar2 default hr_api.g_varchar2
923: ,p_otp_attribute7 in varchar2 default hr_api.g_varchar2
924: ,p_otp_attribute8 in varchar2 default hr_api.g_varchar2
925: ,p_otp_attribute9 in varchar2 default hr_api.g_varchar2

Line 922: ,p_otp_attribute6 in varchar2 default hr_api.g_varchar2

918: ,p_otp_attribute2 in varchar2 default hr_api.g_varchar2
919: ,p_otp_attribute3 in varchar2 default hr_api.g_varchar2
920: ,p_otp_attribute4 in varchar2 default hr_api.g_varchar2
921: ,p_otp_attribute5 in varchar2 default hr_api.g_varchar2
922: ,p_otp_attribute6 in varchar2 default hr_api.g_varchar2
923: ,p_otp_attribute7 in varchar2 default hr_api.g_varchar2
924: ,p_otp_attribute8 in varchar2 default hr_api.g_varchar2
925: ,p_otp_attribute9 in varchar2 default hr_api.g_varchar2
926: ,p_otp_attribute10 in varchar2 default hr_api.g_varchar2

Line 923: ,p_otp_attribute7 in varchar2 default hr_api.g_varchar2

919: ,p_otp_attribute3 in varchar2 default hr_api.g_varchar2
920: ,p_otp_attribute4 in varchar2 default hr_api.g_varchar2
921: ,p_otp_attribute5 in varchar2 default hr_api.g_varchar2
922: ,p_otp_attribute6 in varchar2 default hr_api.g_varchar2
923: ,p_otp_attribute7 in varchar2 default hr_api.g_varchar2
924: ,p_otp_attribute8 in varchar2 default hr_api.g_varchar2
925: ,p_otp_attribute9 in varchar2 default hr_api.g_varchar2
926: ,p_otp_attribute10 in varchar2 default hr_api.g_varchar2
927: ,p_otp_attribute11 in varchar2 default hr_api.g_varchar2

Line 924: ,p_otp_attribute8 in varchar2 default hr_api.g_varchar2

920: ,p_otp_attribute4 in varchar2 default hr_api.g_varchar2
921: ,p_otp_attribute5 in varchar2 default hr_api.g_varchar2
922: ,p_otp_attribute6 in varchar2 default hr_api.g_varchar2
923: ,p_otp_attribute7 in varchar2 default hr_api.g_varchar2
924: ,p_otp_attribute8 in varchar2 default hr_api.g_varchar2
925: ,p_otp_attribute9 in varchar2 default hr_api.g_varchar2
926: ,p_otp_attribute10 in varchar2 default hr_api.g_varchar2
927: ,p_otp_attribute11 in varchar2 default hr_api.g_varchar2
928: ,p_otp_attribute12 in varchar2 default hr_api.g_varchar2

Line 925: ,p_otp_attribute9 in varchar2 default hr_api.g_varchar2

921: ,p_otp_attribute5 in varchar2 default hr_api.g_varchar2
922: ,p_otp_attribute6 in varchar2 default hr_api.g_varchar2
923: ,p_otp_attribute7 in varchar2 default hr_api.g_varchar2
924: ,p_otp_attribute8 in varchar2 default hr_api.g_varchar2
925: ,p_otp_attribute9 in varchar2 default hr_api.g_varchar2
926: ,p_otp_attribute10 in varchar2 default hr_api.g_varchar2
927: ,p_otp_attribute11 in varchar2 default hr_api.g_varchar2
928: ,p_otp_attribute12 in varchar2 default hr_api.g_varchar2
929: ,p_otp_attribute13 in varchar2 default hr_api.g_varchar2

Line 926: ,p_otp_attribute10 in varchar2 default hr_api.g_varchar2

922: ,p_otp_attribute6 in varchar2 default hr_api.g_varchar2
923: ,p_otp_attribute7 in varchar2 default hr_api.g_varchar2
924: ,p_otp_attribute8 in varchar2 default hr_api.g_varchar2
925: ,p_otp_attribute9 in varchar2 default hr_api.g_varchar2
926: ,p_otp_attribute10 in varchar2 default hr_api.g_varchar2
927: ,p_otp_attribute11 in varchar2 default hr_api.g_varchar2
928: ,p_otp_attribute12 in varchar2 default hr_api.g_varchar2
929: ,p_otp_attribute13 in varchar2 default hr_api.g_varchar2
930: ,p_otp_attribute14 in varchar2 default hr_api.g_varchar2

Line 927: ,p_otp_attribute11 in varchar2 default hr_api.g_varchar2

923: ,p_otp_attribute7 in varchar2 default hr_api.g_varchar2
924: ,p_otp_attribute8 in varchar2 default hr_api.g_varchar2
925: ,p_otp_attribute9 in varchar2 default hr_api.g_varchar2
926: ,p_otp_attribute10 in varchar2 default hr_api.g_varchar2
927: ,p_otp_attribute11 in varchar2 default hr_api.g_varchar2
928: ,p_otp_attribute12 in varchar2 default hr_api.g_varchar2
929: ,p_otp_attribute13 in varchar2 default hr_api.g_varchar2
930: ,p_otp_attribute14 in varchar2 default hr_api.g_varchar2
931: ,p_otp_attribute15 in varchar2 default hr_api.g_varchar2

Line 928: ,p_otp_attribute12 in varchar2 default hr_api.g_varchar2

924: ,p_otp_attribute8 in varchar2 default hr_api.g_varchar2
925: ,p_otp_attribute9 in varchar2 default hr_api.g_varchar2
926: ,p_otp_attribute10 in varchar2 default hr_api.g_varchar2
927: ,p_otp_attribute11 in varchar2 default hr_api.g_varchar2
928: ,p_otp_attribute12 in varchar2 default hr_api.g_varchar2
929: ,p_otp_attribute13 in varchar2 default hr_api.g_varchar2
930: ,p_otp_attribute14 in varchar2 default hr_api.g_varchar2
931: ,p_otp_attribute15 in varchar2 default hr_api.g_varchar2
932: ,p_otp_attribute16 in varchar2 default hr_api.g_varchar2

Line 929: ,p_otp_attribute13 in varchar2 default hr_api.g_varchar2

925: ,p_otp_attribute9 in varchar2 default hr_api.g_varchar2
926: ,p_otp_attribute10 in varchar2 default hr_api.g_varchar2
927: ,p_otp_attribute11 in varchar2 default hr_api.g_varchar2
928: ,p_otp_attribute12 in varchar2 default hr_api.g_varchar2
929: ,p_otp_attribute13 in varchar2 default hr_api.g_varchar2
930: ,p_otp_attribute14 in varchar2 default hr_api.g_varchar2
931: ,p_otp_attribute15 in varchar2 default hr_api.g_varchar2
932: ,p_otp_attribute16 in varchar2 default hr_api.g_varchar2
933: ,p_otp_attribute17 in varchar2 default hr_api.g_varchar2

Line 930: ,p_otp_attribute14 in varchar2 default hr_api.g_varchar2

926: ,p_otp_attribute10 in varchar2 default hr_api.g_varchar2
927: ,p_otp_attribute11 in varchar2 default hr_api.g_varchar2
928: ,p_otp_attribute12 in varchar2 default hr_api.g_varchar2
929: ,p_otp_attribute13 in varchar2 default hr_api.g_varchar2
930: ,p_otp_attribute14 in varchar2 default hr_api.g_varchar2
931: ,p_otp_attribute15 in varchar2 default hr_api.g_varchar2
932: ,p_otp_attribute16 in varchar2 default hr_api.g_varchar2
933: ,p_otp_attribute17 in varchar2 default hr_api.g_varchar2
934: ,p_otp_attribute18 in varchar2 default hr_api.g_varchar2

Line 931: ,p_otp_attribute15 in varchar2 default hr_api.g_varchar2

927: ,p_otp_attribute11 in varchar2 default hr_api.g_varchar2
928: ,p_otp_attribute12 in varchar2 default hr_api.g_varchar2
929: ,p_otp_attribute13 in varchar2 default hr_api.g_varchar2
930: ,p_otp_attribute14 in varchar2 default hr_api.g_varchar2
931: ,p_otp_attribute15 in varchar2 default hr_api.g_varchar2
932: ,p_otp_attribute16 in varchar2 default hr_api.g_varchar2
933: ,p_otp_attribute17 in varchar2 default hr_api.g_varchar2
934: ,p_otp_attribute18 in varchar2 default hr_api.g_varchar2
935: ,p_otp_attribute19 in varchar2 default hr_api.g_varchar2

Line 932: ,p_otp_attribute16 in varchar2 default hr_api.g_varchar2

928: ,p_otp_attribute12 in varchar2 default hr_api.g_varchar2
929: ,p_otp_attribute13 in varchar2 default hr_api.g_varchar2
930: ,p_otp_attribute14 in varchar2 default hr_api.g_varchar2
931: ,p_otp_attribute15 in varchar2 default hr_api.g_varchar2
932: ,p_otp_attribute16 in varchar2 default hr_api.g_varchar2
933: ,p_otp_attribute17 in varchar2 default hr_api.g_varchar2
934: ,p_otp_attribute18 in varchar2 default hr_api.g_varchar2
935: ,p_otp_attribute19 in varchar2 default hr_api.g_varchar2
936: ,p_otp_attribute20 in varchar2 default hr_api.g_varchar2

Line 933: ,p_otp_attribute17 in varchar2 default hr_api.g_varchar2

929: ,p_otp_attribute13 in varchar2 default hr_api.g_varchar2
930: ,p_otp_attribute14 in varchar2 default hr_api.g_varchar2
931: ,p_otp_attribute15 in varchar2 default hr_api.g_varchar2
932: ,p_otp_attribute16 in varchar2 default hr_api.g_varchar2
933: ,p_otp_attribute17 in varchar2 default hr_api.g_varchar2
934: ,p_otp_attribute18 in varchar2 default hr_api.g_varchar2
935: ,p_otp_attribute19 in varchar2 default hr_api.g_varchar2
936: ,p_otp_attribute20 in varchar2 default hr_api.g_varchar2
937: ,p_otp_attribute21 in varchar2 default hr_api.g_varchar2

Line 934: ,p_otp_attribute18 in varchar2 default hr_api.g_varchar2

930: ,p_otp_attribute14 in varchar2 default hr_api.g_varchar2
931: ,p_otp_attribute15 in varchar2 default hr_api.g_varchar2
932: ,p_otp_attribute16 in varchar2 default hr_api.g_varchar2
933: ,p_otp_attribute17 in varchar2 default hr_api.g_varchar2
934: ,p_otp_attribute18 in varchar2 default hr_api.g_varchar2
935: ,p_otp_attribute19 in varchar2 default hr_api.g_varchar2
936: ,p_otp_attribute20 in varchar2 default hr_api.g_varchar2
937: ,p_otp_attribute21 in varchar2 default hr_api.g_varchar2
938: ,p_otp_attribute22 in varchar2 default hr_api.g_varchar2

Line 935: ,p_otp_attribute19 in varchar2 default hr_api.g_varchar2

931: ,p_otp_attribute15 in varchar2 default hr_api.g_varchar2
932: ,p_otp_attribute16 in varchar2 default hr_api.g_varchar2
933: ,p_otp_attribute17 in varchar2 default hr_api.g_varchar2
934: ,p_otp_attribute18 in varchar2 default hr_api.g_varchar2
935: ,p_otp_attribute19 in varchar2 default hr_api.g_varchar2
936: ,p_otp_attribute20 in varchar2 default hr_api.g_varchar2
937: ,p_otp_attribute21 in varchar2 default hr_api.g_varchar2
938: ,p_otp_attribute22 in varchar2 default hr_api.g_varchar2
939: ,p_otp_attribute23 in varchar2 default hr_api.g_varchar2

Line 936: ,p_otp_attribute20 in varchar2 default hr_api.g_varchar2

932: ,p_otp_attribute16 in varchar2 default hr_api.g_varchar2
933: ,p_otp_attribute17 in varchar2 default hr_api.g_varchar2
934: ,p_otp_attribute18 in varchar2 default hr_api.g_varchar2
935: ,p_otp_attribute19 in varchar2 default hr_api.g_varchar2
936: ,p_otp_attribute20 in varchar2 default hr_api.g_varchar2
937: ,p_otp_attribute21 in varchar2 default hr_api.g_varchar2
938: ,p_otp_attribute22 in varchar2 default hr_api.g_varchar2
939: ,p_otp_attribute23 in varchar2 default hr_api.g_varchar2
940: ,p_otp_attribute24 in varchar2 default hr_api.g_varchar2

Line 937: ,p_otp_attribute21 in varchar2 default hr_api.g_varchar2

933: ,p_otp_attribute17 in varchar2 default hr_api.g_varchar2
934: ,p_otp_attribute18 in varchar2 default hr_api.g_varchar2
935: ,p_otp_attribute19 in varchar2 default hr_api.g_varchar2
936: ,p_otp_attribute20 in varchar2 default hr_api.g_varchar2
937: ,p_otp_attribute21 in varchar2 default hr_api.g_varchar2
938: ,p_otp_attribute22 in varchar2 default hr_api.g_varchar2
939: ,p_otp_attribute23 in varchar2 default hr_api.g_varchar2
940: ,p_otp_attribute24 in varchar2 default hr_api.g_varchar2
941: ,p_otp_attribute25 in varchar2 default hr_api.g_varchar2

Line 938: ,p_otp_attribute22 in varchar2 default hr_api.g_varchar2

934: ,p_otp_attribute18 in varchar2 default hr_api.g_varchar2
935: ,p_otp_attribute19 in varchar2 default hr_api.g_varchar2
936: ,p_otp_attribute20 in varchar2 default hr_api.g_varchar2
937: ,p_otp_attribute21 in varchar2 default hr_api.g_varchar2
938: ,p_otp_attribute22 in varchar2 default hr_api.g_varchar2
939: ,p_otp_attribute23 in varchar2 default hr_api.g_varchar2
940: ,p_otp_attribute24 in varchar2 default hr_api.g_varchar2
941: ,p_otp_attribute25 in varchar2 default hr_api.g_varchar2
942: ,p_otp_attribute26 in varchar2 default hr_api.g_varchar2

Line 939: ,p_otp_attribute23 in varchar2 default hr_api.g_varchar2

935: ,p_otp_attribute19 in varchar2 default hr_api.g_varchar2
936: ,p_otp_attribute20 in varchar2 default hr_api.g_varchar2
937: ,p_otp_attribute21 in varchar2 default hr_api.g_varchar2
938: ,p_otp_attribute22 in varchar2 default hr_api.g_varchar2
939: ,p_otp_attribute23 in varchar2 default hr_api.g_varchar2
940: ,p_otp_attribute24 in varchar2 default hr_api.g_varchar2
941: ,p_otp_attribute25 in varchar2 default hr_api.g_varchar2
942: ,p_otp_attribute26 in varchar2 default hr_api.g_varchar2
943: ,p_otp_attribute27 in varchar2 default hr_api.g_varchar2

Line 940: ,p_otp_attribute24 in varchar2 default hr_api.g_varchar2

936: ,p_otp_attribute20 in varchar2 default hr_api.g_varchar2
937: ,p_otp_attribute21 in varchar2 default hr_api.g_varchar2
938: ,p_otp_attribute22 in varchar2 default hr_api.g_varchar2
939: ,p_otp_attribute23 in varchar2 default hr_api.g_varchar2
940: ,p_otp_attribute24 in varchar2 default hr_api.g_varchar2
941: ,p_otp_attribute25 in varchar2 default hr_api.g_varchar2
942: ,p_otp_attribute26 in varchar2 default hr_api.g_varchar2
943: ,p_otp_attribute27 in varchar2 default hr_api.g_varchar2
944: ,p_otp_attribute28 in varchar2 default hr_api.g_varchar2

Line 941: ,p_otp_attribute25 in varchar2 default hr_api.g_varchar2

937: ,p_otp_attribute21 in varchar2 default hr_api.g_varchar2
938: ,p_otp_attribute22 in varchar2 default hr_api.g_varchar2
939: ,p_otp_attribute23 in varchar2 default hr_api.g_varchar2
940: ,p_otp_attribute24 in varchar2 default hr_api.g_varchar2
941: ,p_otp_attribute25 in varchar2 default hr_api.g_varchar2
942: ,p_otp_attribute26 in varchar2 default hr_api.g_varchar2
943: ,p_otp_attribute27 in varchar2 default hr_api.g_varchar2
944: ,p_otp_attribute28 in varchar2 default hr_api.g_varchar2
945: ,p_otp_attribute29 in varchar2 default hr_api.g_varchar2

Line 942: ,p_otp_attribute26 in varchar2 default hr_api.g_varchar2

938: ,p_otp_attribute22 in varchar2 default hr_api.g_varchar2
939: ,p_otp_attribute23 in varchar2 default hr_api.g_varchar2
940: ,p_otp_attribute24 in varchar2 default hr_api.g_varchar2
941: ,p_otp_attribute25 in varchar2 default hr_api.g_varchar2
942: ,p_otp_attribute26 in varchar2 default hr_api.g_varchar2
943: ,p_otp_attribute27 in varchar2 default hr_api.g_varchar2
944: ,p_otp_attribute28 in varchar2 default hr_api.g_varchar2
945: ,p_otp_attribute29 in varchar2 default hr_api.g_varchar2
946: ,p_otp_attribute30 in varchar2 default hr_api.g_varchar2

Line 943: ,p_otp_attribute27 in varchar2 default hr_api.g_varchar2

939: ,p_otp_attribute23 in varchar2 default hr_api.g_varchar2
940: ,p_otp_attribute24 in varchar2 default hr_api.g_varchar2
941: ,p_otp_attribute25 in varchar2 default hr_api.g_varchar2
942: ,p_otp_attribute26 in varchar2 default hr_api.g_varchar2
943: ,p_otp_attribute27 in varchar2 default hr_api.g_varchar2
944: ,p_otp_attribute28 in varchar2 default hr_api.g_varchar2
945: ,p_otp_attribute29 in varchar2 default hr_api.g_varchar2
946: ,p_otp_attribute30 in varchar2 default hr_api.g_varchar2
947: ,p_effective_start_date out nocopy date

Line 944: ,p_otp_attribute28 in varchar2 default hr_api.g_varchar2

940: ,p_otp_attribute24 in varchar2 default hr_api.g_varchar2
941: ,p_otp_attribute25 in varchar2 default hr_api.g_varchar2
942: ,p_otp_attribute26 in varchar2 default hr_api.g_varchar2
943: ,p_otp_attribute27 in varchar2 default hr_api.g_varchar2
944: ,p_otp_attribute28 in varchar2 default hr_api.g_varchar2
945: ,p_otp_attribute29 in varchar2 default hr_api.g_varchar2
946: ,p_otp_attribute30 in varchar2 default hr_api.g_varchar2
947: ,p_effective_start_date out nocopy date
948: ,p_effective_end_date out nocopy date

Line 945: ,p_otp_attribute29 in varchar2 default hr_api.g_varchar2

941: ,p_otp_attribute25 in varchar2 default hr_api.g_varchar2
942: ,p_otp_attribute26 in varchar2 default hr_api.g_varchar2
943: ,p_otp_attribute27 in varchar2 default hr_api.g_varchar2
944: ,p_otp_attribute28 in varchar2 default hr_api.g_varchar2
945: ,p_otp_attribute29 in varchar2 default hr_api.g_varchar2
946: ,p_otp_attribute30 in varchar2 default hr_api.g_varchar2
947: ,p_effective_start_date out nocopy date
948: ,p_effective_end_date out nocopy date
949: ) is

Line 946: ,p_otp_attribute30 in varchar2 default hr_api.g_varchar2

942: ,p_otp_attribute26 in varchar2 default hr_api.g_varchar2
943: ,p_otp_attribute27 in varchar2 default hr_api.g_varchar2
944: ,p_otp_attribute28 in varchar2 default hr_api.g_varchar2
945: ,p_otp_attribute29 in varchar2 default hr_api.g_varchar2
946: ,p_otp_attribute30 in varchar2 default hr_api.g_varchar2
947: ,p_effective_start_date out nocopy date
948: ,p_effective_end_date out nocopy date
949: ) is
950: --