163: End If;
164: --
165: hr_utility.set_location(' Leaving:'||l_proc, 15);
166: Exception
167: When hr_api.check_integrity_violated Then
168: -- A check constraint has been violated
169: ben_apr_shd.g_api_dml := false; -- Unset the api dml status
170: ben_apr_shd.constraint_error
171: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
167: When hr_api.check_integrity_violated Then
168: -- A check constraint has been violated
169: ben_apr_shd.g_api_dml := false; -- Unset the api dml status
170: ben_apr_shd.constraint_error
171: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
172: When hr_api.unique_integrity_violated Then
173: -- Unique integrity has been violated
174: ben_apr_shd.g_api_dml := false; -- Unset the api dml status
175: ben_apr_shd.constraint_error
168: -- A check constraint has been violated
169: ben_apr_shd.g_api_dml := false; -- Unset the api dml status
170: ben_apr_shd.constraint_error
171: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
172: When hr_api.unique_integrity_violated Then
173: -- Unique integrity has been violated
174: ben_apr_shd.g_api_dml := false; -- Unset the api dml status
175: ben_apr_shd.constraint_error
176: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
172: When hr_api.unique_integrity_violated Then
173: -- Unique integrity has been violated
174: ben_apr_shd.g_api_dml := false; -- Unset the api dml status
175: ben_apr_shd.constraint_error
176: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
177: When Others Then
178: ben_apr_shd.g_api_dml := false; -- Unset the api dml status
179: Raise;
180: End dt_update_dml;
576: );
577: --
578: exception
579: --
580: when hr_api.cannot_find_prog_unit then
581: --
582: hr_api.cannot_find_prog_unit_error
583: (p_module_name => 'ben_actl_prem_f'
584: ,p_hook_type => 'AU');
578: exception
579: --
580: when hr_api.cannot_find_prog_unit then
581: --
582: hr_api.cannot_find_prog_unit_error
583: (p_module_name => 'ben_actl_prem_f'
584: ,p_hook_type => 'AU');
585: --
586: end;
646: -- p_rec plsql record structure
647: -- to see if a system default is being used. If a system default
648: -- is being used then we must set to the 'current' argument value.
649: --
650: If (p_rec.name = hr_api.g_varchar2) then
651: p_rec.name :=
652: ben_apr_shd.g_old_rec.name;
653: End If;
654: If (p_rec.acty_ref_perd_cd = hr_api.g_varchar2) then
650: If (p_rec.name = hr_api.g_varchar2) then
651: p_rec.name :=
652: ben_apr_shd.g_old_rec.name;
653: End If;
654: If (p_rec.acty_ref_perd_cd = hr_api.g_varchar2) then
655: p_rec.acty_ref_perd_cd :=
656: ben_apr_shd.g_old_rec.acty_ref_perd_cd;
657: End If;
658: If (p_rec.uom = hr_api.g_varchar2) then
654: If (p_rec.acty_ref_perd_cd = hr_api.g_varchar2) then
655: p_rec.acty_ref_perd_cd :=
656: ben_apr_shd.g_old_rec.acty_ref_perd_cd;
657: End If;
658: If (p_rec.uom = hr_api.g_varchar2) then
659: p_rec.uom :=
660: ben_apr_shd.g_old_rec.uom;
661: End If;
662: If (p_rec.rt_typ_cd = hr_api.g_varchar2) then
658: If (p_rec.uom = hr_api.g_varchar2) then
659: p_rec.uom :=
660: ben_apr_shd.g_old_rec.uom;
661: End If;
662: If (p_rec.rt_typ_cd = hr_api.g_varchar2) then
663: p_rec.rt_typ_cd :=
664: ben_apr_shd.g_old_rec.rt_typ_cd;
665: End If;
666: If (p_rec.bnft_rt_typ_cd = hr_api.g_varchar2) then
662: If (p_rec.rt_typ_cd = hr_api.g_varchar2) then
663: p_rec.rt_typ_cd :=
664: ben_apr_shd.g_old_rec.rt_typ_cd;
665: End If;
666: If (p_rec.bnft_rt_typ_cd = hr_api.g_varchar2) then
667: p_rec.bnft_rt_typ_cd :=
668: ben_apr_shd.g_old_rec.bnft_rt_typ_cd;
669: End If;
670: If (p_rec.val = hr_api.g_number) then
666: If (p_rec.bnft_rt_typ_cd = hr_api.g_varchar2) then
667: p_rec.bnft_rt_typ_cd :=
668: ben_apr_shd.g_old_rec.bnft_rt_typ_cd;
669: End If;
670: If (p_rec.val = hr_api.g_number) then
671: p_rec.val :=
672: ben_apr_shd.g_old_rec.val;
673: End If;
674: If (p_rec.mlt_cd = hr_api.g_varchar2) then
670: If (p_rec.val = hr_api.g_number) then
671: p_rec.val :=
672: ben_apr_shd.g_old_rec.val;
673: End If;
674: If (p_rec.mlt_cd = hr_api.g_varchar2) then
675: p_rec.mlt_cd :=
676: ben_apr_shd.g_old_rec.mlt_cd;
677: End If;
678: If (p_rec.prdct_cd = hr_api.g_varchar2) then
674: If (p_rec.mlt_cd = hr_api.g_varchar2) then
675: p_rec.mlt_cd :=
676: ben_apr_shd.g_old_rec.mlt_cd;
677: End If;
678: If (p_rec.prdct_cd = hr_api.g_varchar2) then
679: p_rec.prdct_cd :=
680: ben_apr_shd.g_old_rec.prdct_cd;
681: End If;
682: If (p_rec.rndg_cd = hr_api.g_varchar2) then
678: If (p_rec.prdct_cd = hr_api.g_varchar2) then
679: p_rec.prdct_cd :=
680: ben_apr_shd.g_old_rec.prdct_cd;
681: End If;
682: If (p_rec.rndg_cd = hr_api.g_varchar2) then
683: p_rec.rndg_cd :=
684: ben_apr_shd.g_old_rec.rndg_cd;
685: End If;
686: If (p_rec.rndg_rl = hr_api.g_number) then
682: If (p_rec.rndg_cd = hr_api.g_varchar2) then
683: p_rec.rndg_cd :=
684: ben_apr_shd.g_old_rec.rndg_cd;
685: End If;
686: If (p_rec.rndg_rl = hr_api.g_number) then
687: p_rec.rndg_rl :=
688: ben_apr_shd.g_old_rec.rndg_rl;
689: End If;
690: If (p_rec.comp_lvl_fctr_id = hr_api.g_number) then
686: If (p_rec.rndg_rl = hr_api.g_number) then
687: p_rec.rndg_rl :=
688: ben_apr_shd.g_old_rec.rndg_rl;
689: End If;
690: If (p_rec.comp_lvl_fctr_id = hr_api.g_number) then
691: p_rec.comp_lvl_fctr_id :=
692: ben_apr_shd.g_old_rec.comp_lvl_fctr_id;
693: End If;
694: If (p_rec.organization_id = hr_api.g_number) then
690: If (p_rec.comp_lvl_fctr_id = hr_api.g_number) then
691: p_rec.comp_lvl_fctr_id :=
692: ben_apr_shd.g_old_rec.comp_lvl_fctr_id;
693: End If;
694: If (p_rec.organization_id = hr_api.g_number) then
695: p_rec.organization_id :=
696: ben_apr_shd.g_old_rec.organization_id;
697: End If;
698: If (p_rec.business_group_id = hr_api.g_number) then
694: If (p_rec.organization_id = hr_api.g_number) then
695: p_rec.organization_id :=
696: ben_apr_shd.g_old_rec.organization_id;
697: End If;
698: If (p_rec.business_group_id = hr_api.g_number) then
699: p_rec.business_group_id :=
700: ben_apr_shd.g_old_rec.business_group_id;
701: End If;
702: If (p_rec.val_calc_rl = hr_api.g_number) then
698: If (p_rec.business_group_id = hr_api.g_number) then
699: p_rec.business_group_id :=
700: ben_apr_shd.g_old_rec.business_group_id;
701: End If;
702: If (p_rec.val_calc_rl = hr_api.g_number) then
703: p_rec.val_calc_rl :=
704: ben_apr_shd.g_old_rec.val_calc_rl;
705: End If;
706: If (p_rec.prtl_mo_det_mthd_cd = hr_api.g_varchar2) then
702: If (p_rec.val_calc_rl = hr_api.g_number) then
703: p_rec.val_calc_rl :=
704: ben_apr_shd.g_old_rec.val_calc_rl;
705: End If;
706: If (p_rec.prtl_mo_det_mthd_cd = hr_api.g_varchar2) then
707: p_rec.prtl_mo_det_mthd_cd :=
708: ben_apr_shd.g_old_rec.prtl_mo_det_mthd_cd;
709: End If;
710: If (p_rec.prtl_mo_det_mthd_rl = hr_api.g_number) then
706: If (p_rec.prtl_mo_det_mthd_cd = hr_api.g_varchar2) then
707: p_rec.prtl_mo_det_mthd_cd :=
708: ben_apr_shd.g_old_rec.prtl_mo_det_mthd_cd;
709: End If;
710: If (p_rec.prtl_mo_det_mthd_rl = hr_api.g_number) then
711: p_rec.prtl_mo_det_mthd_rl :=
712: ben_apr_shd.g_old_rec.prtl_mo_det_mthd_rl;
713: End If;
714: If (p_rec.wsh_rl_dy_mo_num = hr_api.g_number) then
710: If (p_rec.prtl_mo_det_mthd_rl = hr_api.g_number) then
711: p_rec.prtl_mo_det_mthd_rl :=
712: ben_apr_shd.g_old_rec.prtl_mo_det_mthd_rl;
713: End If;
714: If (p_rec.wsh_rl_dy_mo_num = hr_api.g_number) then
715: p_rec.wsh_rl_dy_mo_num :=
716: ben_apr_shd.g_old_rec.wsh_rl_dy_mo_num;
717: End If;
718: If (p_rec.vrbl_rt_add_on_calc_rl = hr_api.g_number) then
714: If (p_rec.wsh_rl_dy_mo_num = hr_api.g_number) then
715: p_rec.wsh_rl_dy_mo_num :=
716: ben_apr_shd.g_old_rec.wsh_rl_dy_mo_num;
717: End If;
718: If (p_rec.vrbl_rt_add_on_calc_rl = hr_api.g_number) then
719: p_rec.vrbl_rt_add_on_calc_rl :=
720: ben_apr_shd.g_old_rec.vrbl_rt_add_on_calc_rl;
721: End If;
722: If (p_rec.apr_attribute_category = hr_api.g_varchar2) then
718: If (p_rec.vrbl_rt_add_on_calc_rl = hr_api.g_number) then
719: p_rec.vrbl_rt_add_on_calc_rl :=
720: ben_apr_shd.g_old_rec.vrbl_rt_add_on_calc_rl;
721: End If;
722: If (p_rec.apr_attribute_category = hr_api.g_varchar2) then
723: p_rec.apr_attribute_category :=
724: ben_apr_shd.g_old_rec.apr_attribute_category;
725: End If;
726: If (p_rec.apr_attribute1 = hr_api.g_varchar2) then
722: If (p_rec.apr_attribute_category = hr_api.g_varchar2) then
723: p_rec.apr_attribute_category :=
724: ben_apr_shd.g_old_rec.apr_attribute_category;
725: End If;
726: If (p_rec.apr_attribute1 = hr_api.g_varchar2) then
727: p_rec.apr_attribute1 :=
728: ben_apr_shd.g_old_rec.apr_attribute1;
729: End If;
730: If (p_rec.apr_attribute2 = hr_api.g_varchar2) then
726: If (p_rec.apr_attribute1 = hr_api.g_varchar2) then
727: p_rec.apr_attribute1 :=
728: ben_apr_shd.g_old_rec.apr_attribute1;
729: End If;
730: If (p_rec.apr_attribute2 = hr_api.g_varchar2) then
731: p_rec.apr_attribute2 :=
732: ben_apr_shd.g_old_rec.apr_attribute2;
733: End If;
734: If (p_rec.apr_attribute3 = hr_api.g_varchar2) then
730: If (p_rec.apr_attribute2 = hr_api.g_varchar2) then
731: p_rec.apr_attribute2 :=
732: ben_apr_shd.g_old_rec.apr_attribute2;
733: End If;
734: If (p_rec.apr_attribute3 = hr_api.g_varchar2) then
735: p_rec.apr_attribute3 :=
736: ben_apr_shd.g_old_rec.apr_attribute3;
737: End If;
738: If (p_rec.apr_attribute4 = hr_api.g_varchar2) then
734: If (p_rec.apr_attribute3 = hr_api.g_varchar2) then
735: p_rec.apr_attribute3 :=
736: ben_apr_shd.g_old_rec.apr_attribute3;
737: End If;
738: If (p_rec.apr_attribute4 = hr_api.g_varchar2) then
739: p_rec.apr_attribute4 :=
740: ben_apr_shd.g_old_rec.apr_attribute4;
741: End If;
742: If (p_rec.apr_attribute5 = hr_api.g_varchar2) then
738: If (p_rec.apr_attribute4 = hr_api.g_varchar2) then
739: p_rec.apr_attribute4 :=
740: ben_apr_shd.g_old_rec.apr_attribute4;
741: End If;
742: If (p_rec.apr_attribute5 = hr_api.g_varchar2) then
743: p_rec.apr_attribute5 :=
744: ben_apr_shd.g_old_rec.apr_attribute5;
745: End If;
746: If (p_rec.apr_attribute6 = hr_api.g_varchar2) then
742: If (p_rec.apr_attribute5 = hr_api.g_varchar2) then
743: p_rec.apr_attribute5 :=
744: ben_apr_shd.g_old_rec.apr_attribute5;
745: End If;
746: If (p_rec.apr_attribute6 = hr_api.g_varchar2) then
747: p_rec.apr_attribute6 :=
748: ben_apr_shd.g_old_rec.apr_attribute6;
749: End If;
750: If (p_rec.apr_attribute7 = hr_api.g_varchar2) then
746: If (p_rec.apr_attribute6 = hr_api.g_varchar2) then
747: p_rec.apr_attribute6 :=
748: ben_apr_shd.g_old_rec.apr_attribute6;
749: End If;
750: If (p_rec.apr_attribute7 = hr_api.g_varchar2) then
751: p_rec.apr_attribute7 :=
752: ben_apr_shd.g_old_rec.apr_attribute7;
753: End If;
754: If (p_rec.apr_attribute8 = hr_api.g_varchar2) then
750: If (p_rec.apr_attribute7 = hr_api.g_varchar2) then
751: p_rec.apr_attribute7 :=
752: ben_apr_shd.g_old_rec.apr_attribute7;
753: End If;
754: If (p_rec.apr_attribute8 = hr_api.g_varchar2) then
755: p_rec.apr_attribute8 :=
756: ben_apr_shd.g_old_rec.apr_attribute8;
757: End If;
758: If (p_rec.apr_attribute9 = hr_api.g_varchar2) then
754: If (p_rec.apr_attribute8 = hr_api.g_varchar2) then
755: p_rec.apr_attribute8 :=
756: ben_apr_shd.g_old_rec.apr_attribute8;
757: End If;
758: If (p_rec.apr_attribute9 = hr_api.g_varchar2) then
759: p_rec.apr_attribute9 :=
760: ben_apr_shd.g_old_rec.apr_attribute9;
761: End If;
762: If (p_rec.apr_attribute10 = hr_api.g_varchar2) then
758: If (p_rec.apr_attribute9 = hr_api.g_varchar2) then
759: p_rec.apr_attribute9 :=
760: ben_apr_shd.g_old_rec.apr_attribute9;
761: End If;
762: If (p_rec.apr_attribute10 = hr_api.g_varchar2) then
763: p_rec.apr_attribute10 :=
764: ben_apr_shd.g_old_rec.apr_attribute10;
765: End If;
766: If (p_rec.apr_attribute11 = hr_api.g_varchar2) then
762: If (p_rec.apr_attribute10 = hr_api.g_varchar2) then
763: p_rec.apr_attribute10 :=
764: ben_apr_shd.g_old_rec.apr_attribute10;
765: End If;
766: If (p_rec.apr_attribute11 = hr_api.g_varchar2) then
767: p_rec.apr_attribute11 :=
768: ben_apr_shd.g_old_rec.apr_attribute11;
769: End If;
770: If (p_rec.apr_attribute12 = hr_api.g_varchar2) then
766: If (p_rec.apr_attribute11 = hr_api.g_varchar2) then
767: p_rec.apr_attribute11 :=
768: ben_apr_shd.g_old_rec.apr_attribute11;
769: End If;
770: If (p_rec.apr_attribute12 = hr_api.g_varchar2) then
771: p_rec.apr_attribute12 :=
772: ben_apr_shd.g_old_rec.apr_attribute12;
773: End If;
774: If (p_rec.apr_attribute13 = hr_api.g_varchar2) then
770: If (p_rec.apr_attribute12 = hr_api.g_varchar2) then
771: p_rec.apr_attribute12 :=
772: ben_apr_shd.g_old_rec.apr_attribute12;
773: End If;
774: If (p_rec.apr_attribute13 = hr_api.g_varchar2) then
775: p_rec.apr_attribute13 :=
776: ben_apr_shd.g_old_rec.apr_attribute13;
777: End If;
778: If (p_rec.apr_attribute14 = hr_api.g_varchar2) then
774: If (p_rec.apr_attribute13 = hr_api.g_varchar2) then
775: p_rec.apr_attribute13 :=
776: ben_apr_shd.g_old_rec.apr_attribute13;
777: End If;
778: If (p_rec.apr_attribute14 = hr_api.g_varchar2) then
779: p_rec.apr_attribute14 :=
780: ben_apr_shd.g_old_rec.apr_attribute14;
781: End If;
782: If (p_rec.apr_attribute15 = hr_api.g_varchar2) then
778: If (p_rec.apr_attribute14 = hr_api.g_varchar2) then
779: p_rec.apr_attribute14 :=
780: ben_apr_shd.g_old_rec.apr_attribute14;
781: End If;
782: If (p_rec.apr_attribute15 = hr_api.g_varchar2) then
783: p_rec.apr_attribute15 :=
784: ben_apr_shd.g_old_rec.apr_attribute15;
785: End If;
786: If (p_rec.apr_attribute16 = hr_api.g_varchar2) then
782: If (p_rec.apr_attribute15 = hr_api.g_varchar2) then
783: p_rec.apr_attribute15 :=
784: ben_apr_shd.g_old_rec.apr_attribute15;
785: End If;
786: If (p_rec.apr_attribute16 = hr_api.g_varchar2) then
787: p_rec.apr_attribute16 :=
788: ben_apr_shd.g_old_rec.apr_attribute16;
789: End If;
790: If (p_rec.apr_attribute17 = hr_api.g_varchar2) then
786: If (p_rec.apr_attribute16 = hr_api.g_varchar2) then
787: p_rec.apr_attribute16 :=
788: ben_apr_shd.g_old_rec.apr_attribute16;
789: End If;
790: If (p_rec.apr_attribute17 = hr_api.g_varchar2) then
791: p_rec.apr_attribute17 :=
792: ben_apr_shd.g_old_rec.apr_attribute17;
793: End If;
794: If (p_rec.apr_attribute18 = hr_api.g_varchar2) then
790: If (p_rec.apr_attribute17 = hr_api.g_varchar2) then
791: p_rec.apr_attribute17 :=
792: ben_apr_shd.g_old_rec.apr_attribute17;
793: End If;
794: If (p_rec.apr_attribute18 = hr_api.g_varchar2) then
795: p_rec.apr_attribute18 :=
796: ben_apr_shd.g_old_rec.apr_attribute18;
797: End If;
798: If (p_rec.apr_attribute19 = hr_api.g_varchar2) then
794: If (p_rec.apr_attribute18 = hr_api.g_varchar2) then
795: p_rec.apr_attribute18 :=
796: ben_apr_shd.g_old_rec.apr_attribute18;
797: End If;
798: If (p_rec.apr_attribute19 = hr_api.g_varchar2) then
799: p_rec.apr_attribute19 :=
800: ben_apr_shd.g_old_rec.apr_attribute19;
801: End If;
802: If (p_rec.apr_attribute20 = hr_api.g_varchar2) then
798: If (p_rec.apr_attribute19 = hr_api.g_varchar2) then
799: p_rec.apr_attribute19 :=
800: ben_apr_shd.g_old_rec.apr_attribute19;
801: End If;
802: If (p_rec.apr_attribute20 = hr_api.g_varchar2) then
803: p_rec.apr_attribute20 :=
804: ben_apr_shd.g_old_rec.apr_attribute20;
805: End If;
806: If (p_rec.apr_attribute21 = hr_api.g_varchar2) then
802: If (p_rec.apr_attribute20 = hr_api.g_varchar2) then
803: p_rec.apr_attribute20 :=
804: ben_apr_shd.g_old_rec.apr_attribute20;
805: End If;
806: If (p_rec.apr_attribute21 = hr_api.g_varchar2) then
807: p_rec.apr_attribute21 :=
808: ben_apr_shd.g_old_rec.apr_attribute21;
809: End If;
810: If (p_rec.apr_attribute22 = hr_api.g_varchar2) then
806: If (p_rec.apr_attribute21 = hr_api.g_varchar2) then
807: p_rec.apr_attribute21 :=
808: ben_apr_shd.g_old_rec.apr_attribute21;
809: End If;
810: If (p_rec.apr_attribute22 = hr_api.g_varchar2) then
811: p_rec.apr_attribute22 :=
812: ben_apr_shd.g_old_rec.apr_attribute22;
813: End If;
814: If (p_rec.apr_attribute23 = hr_api.g_varchar2) then
810: If (p_rec.apr_attribute22 = hr_api.g_varchar2) then
811: p_rec.apr_attribute22 :=
812: ben_apr_shd.g_old_rec.apr_attribute22;
813: End If;
814: If (p_rec.apr_attribute23 = hr_api.g_varchar2) then
815: p_rec.apr_attribute23 :=
816: ben_apr_shd.g_old_rec.apr_attribute23;
817: End If;
818: If (p_rec.apr_attribute24 = hr_api.g_varchar2) then
814: If (p_rec.apr_attribute23 = hr_api.g_varchar2) then
815: p_rec.apr_attribute23 :=
816: ben_apr_shd.g_old_rec.apr_attribute23;
817: End If;
818: If (p_rec.apr_attribute24 = hr_api.g_varchar2) then
819: p_rec.apr_attribute24 :=
820: ben_apr_shd.g_old_rec.apr_attribute24;
821: End If;
822: If (p_rec.apr_attribute25 = hr_api.g_varchar2) then
818: If (p_rec.apr_attribute24 = hr_api.g_varchar2) then
819: p_rec.apr_attribute24 :=
820: ben_apr_shd.g_old_rec.apr_attribute24;
821: End If;
822: If (p_rec.apr_attribute25 = hr_api.g_varchar2) then
823: p_rec.apr_attribute25 :=
824: ben_apr_shd.g_old_rec.apr_attribute25;
825: End If;
826: If (p_rec.apr_attribute26 = hr_api.g_varchar2) then
822: If (p_rec.apr_attribute25 = hr_api.g_varchar2) then
823: p_rec.apr_attribute25 :=
824: ben_apr_shd.g_old_rec.apr_attribute25;
825: End If;
826: If (p_rec.apr_attribute26 = hr_api.g_varchar2) then
827: p_rec.apr_attribute26 :=
828: ben_apr_shd.g_old_rec.apr_attribute26;
829: End If;
830: If (p_rec.apr_attribute27 = hr_api.g_varchar2) then
826: If (p_rec.apr_attribute26 = hr_api.g_varchar2) then
827: p_rec.apr_attribute26 :=
828: ben_apr_shd.g_old_rec.apr_attribute26;
829: End If;
830: If (p_rec.apr_attribute27 = hr_api.g_varchar2) then
831: p_rec.apr_attribute27 :=
832: ben_apr_shd.g_old_rec.apr_attribute27;
833: End If;
834: If (p_rec.apr_attribute28 = hr_api.g_varchar2) then
830: If (p_rec.apr_attribute27 = hr_api.g_varchar2) then
831: p_rec.apr_attribute27 :=
832: ben_apr_shd.g_old_rec.apr_attribute27;
833: End If;
834: If (p_rec.apr_attribute28 = hr_api.g_varchar2) then
835: p_rec.apr_attribute28 :=
836: ben_apr_shd.g_old_rec.apr_attribute28;
837: End If;
838: If (p_rec.apr_attribute29 = hr_api.g_varchar2) then
834: If (p_rec.apr_attribute28 = hr_api.g_varchar2) then
835: p_rec.apr_attribute28 :=
836: ben_apr_shd.g_old_rec.apr_attribute28;
837: End If;
838: If (p_rec.apr_attribute29 = hr_api.g_varchar2) then
839: p_rec.apr_attribute29 :=
840: ben_apr_shd.g_old_rec.apr_attribute29;
841: End If;
842: If (p_rec.apr_attribute30 = hr_api.g_varchar2) then
838: If (p_rec.apr_attribute29 = hr_api.g_varchar2) then
839: p_rec.apr_attribute29 :=
840: ben_apr_shd.g_old_rec.apr_attribute29;
841: End If;
842: If (p_rec.apr_attribute30 = hr_api.g_varchar2) then
843: p_rec.apr_attribute30 :=
844: ben_apr_shd.g_old_rec.apr_attribute30;
845: End If;
846:
929: (
930: p_actl_prem_id in number,
931: p_effective_start_date out nocopy date,
932: p_effective_end_date out nocopy date,
933: p_name in varchar2 default hr_api.g_varchar2,
934: p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2,
935: p_uom in varchar2 default hr_api.g_varchar2,
936: p_rt_typ_cd in varchar2 default hr_api.g_varchar2,
937: p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2,
930: p_actl_prem_id in number,
931: p_effective_start_date out nocopy date,
932: p_effective_end_date out nocopy date,
933: p_name in varchar2 default hr_api.g_varchar2,
934: p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2,
935: p_uom in varchar2 default hr_api.g_varchar2,
936: p_rt_typ_cd in varchar2 default hr_api.g_varchar2,
937: p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2,
938: p_val in number default hr_api.g_number,
931: p_effective_start_date out nocopy date,
932: p_effective_end_date out nocopy date,
933: p_name in varchar2 default hr_api.g_varchar2,
934: p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2,
935: p_uom in varchar2 default hr_api.g_varchar2,
936: p_rt_typ_cd in varchar2 default hr_api.g_varchar2,
937: p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2,
938: p_val in number default hr_api.g_number,
939: p_mlt_cd in varchar2 default hr_api.g_varchar2,
932: p_effective_end_date out nocopy date,
933: p_name in varchar2 default hr_api.g_varchar2,
934: p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2,
935: p_uom in varchar2 default hr_api.g_varchar2,
936: p_rt_typ_cd in varchar2 default hr_api.g_varchar2,
937: p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2,
938: p_val in number default hr_api.g_number,
939: p_mlt_cd in varchar2 default hr_api.g_varchar2,
940: p_prdct_cd in varchar2 default hr_api.g_varchar2,
933: p_name in varchar2 default hr_api.g_varchar2,
934: p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2,
935: p_uom in varchar2 default hr_api.g_varchar2,
936: p_rt_typ_cd in varchar2 default hr_api.g_varchar2,
937: p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2,
938: p_val in number default hr_api.g_number,
939: p_mlt_cd in varchar2 default hr_api.g_varchar2,
940: p_prdct_cd in varchar2 default hr_api.g_varchar2,
941: p_rndg_cd in varchar2 default hr_api.g_varchar2,
934: p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2,
935: p_uom in varchar2 default hr_api.g_varchar2,
936: p_rt_typ_cd in varchar2 default hr_api.g_varchar2,
937: p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2,
938: p_val in number default hr_api.g_number,
939: p_mlt_cd in varchar2 default hr_api.g_varchar2,
940: p_prdct_cd in varchar2 default hr_api.g_varchar2,
941: p_rndg_cd in varchar2 default hr_api.g_varchar2,
942: p_rndg_rl in number default hr_api.g_number,
935: p_uom in varchar2 default hr_api.g_varchar2,
936: p_rt_typ_cd in varchar2 default hr_api.g_varchar2,
937: p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2,
938: p_val in number default hr_api.g_number,
939: p_mlt_cd in varchar2 default hr_api.g_varchar2,
940: p_prdct_cd in varchar2 default hr_api.g_varchar2,
941: p_rndg_cd in varchar2 default hr_api.g_varchar2,
942: p_rndg_rl in number default hr_api.g_number,
943: p_val_calc_rl in number default hr_api.g_number,
936: p_rt_typ_cd in varchar2 default hr_api.g_varchar2,
937: p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2,
938: p_val in number default hr_api.g_number,
939: p_mlt_cd in varchar2 default hr_api.g_varchar2,
940: p_prdct_cd in varchar2 default hr_api.g_varchar2,
941: p_rndg_cd in varchar2 default hr_api.g_varchar2,
942: p_rndg_rl in number default hr_api.g_number,
943: p_val_calc_rl in number default hr_api.g_number,
944: p_prem_asnmt_cd in varchar2 default hr_api.g_varchar2,
937: p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2,
938: p_val in number default hr_api.g_number,
939: p_mlt_cd in varchar2 default hr_api.g_varchar2,
940: p_prdct_cd in varchar2 default hr_api.g_varchar2,
941: p_rndg_cd in varchar2 default hr_api.g_varchar2,
942: p_rndg_rl in number default hr_api.g_number,
943: p_val_calc_rl in number default hr_api.g_number,
944: p_prem_asnmt_cd in varchar2 default hr_api.g_varchar2,
945: p_prem_asnmt_lvl_cd in varchar2 default hr_api.g_varchar2,
938: p_val in number default hr_api.g_number,
939: p_mlt_cd in varchar2 default hr_api.g_varchar2,
940: p_prdct_cd in varchar2 default hr_api.g_varchar2,
941: p_rndg_cd in varchar2 default hr_api.g_varchar2,
942: p_rndg_rl in number default hr_api.g_number,
943: p_val_calc_rl in number default hr_api.g_number,
944: p_prem_asnmt_cd in varchar2 default hr_api.g_varchar2,
945: p_prem_asnmt_lvl_cd in varchar2 default hr_api.g_varchar2,
946: p_actl_prem_typ_cd in varchar2 default hr_api.g_varchar2,
939: p_mlt_cd in varchar2 default hr_api.g_varchar2,
940: p_prdct_cd in varchar2 default hr_api.g_varchar2,
941: p_rndg_cd in varchar2 default hr_api.g_varchar2,
942: p_rndg_rl in number default hr_api.g_number,
943: p_val_calc_rl in number default hr_api.g_number,
944: p_prem_asnmt_cd in varchar2 default hr_api.g_varchar2,
945: p_prem_asnmt_lvl_cd in varchar2 default hr_api.g_varchar2,
946: p_actl_prem_typ_cd in varchar2 default hr_api.g_varchar2,
947: p_prem_pyr_cd in varchar2 default hr_api.g_varchar2,
940: p_prdct_cd in varchar2 default hr_api.g_varchar2,
941: p_rndg_cd in varchar2 default hr_api.g_varchar2,
942: p_rndg_rl in number default hr_api.g_number,
943: p_val_calc_rl in number default hr_api.g_number,
944: p_prem_asnmt_cd in varchar2 default hr_api.g_varchar2,
945: p_prem_asnmt_lvl_cd in varchar2 default hr_api.g_varchar2,
946: p_actl_prem_typ_cd in varchar2 default hr_api.g_varchar2,
947: p_prem_pyr_cd in varchar2 default hr_api.g_varchar2,
948: p_cr_lkbk_val in number default hr_api.g_number,
941: p_rndg_cd in varchar2 default hr_api.g_varchar2,
942: p_rndg_rl in number default hr_api.g_number,
943: p_val_calc_rl in number default hr_api.g_number,
944: p_prem_asnmt_cd in varchar2 default hr_api.g_varchar2,
945: p_prem_asnmt_lvl_cd in varchar2 default hr_api.g_varchar2,
946: p_actl_prem_typ_cd in varchar2 default hr_api.g_varchar2,
947: p_prem_pyr_cd in varchar2 default hr_api.g_varchar2,
948: p_cr_lkbk_val in number default hr_api.g_number,
949: p_cr_lkbk_uom in varchar2 default hr_api.g_varchar2,
942: p_rndg_rl in number default hr_api.g_number,
943: p_val_calc_rl in number default hr_api.g_number,
944: p_prem_asnmt_cd in varchar2 default hr_api.g_varchar2,
945: p_prem_asnmt_lvl_cd in varchar2 default hr_api.g_varchar2,
946: p_actl_prem_typ_cd in varchar2 default hr_api.g_varchar2,
947: p_prem_pyr_cd in varchar2 default hr_api.g_varchar2,
948: p_cr_lkbk_val in number default hr_api.g_number,
949: p_cr_lkbk_uom in varchar2 default hr_api.g_varchar2,
950: p_cr_lkbk_crnt_py_only_flag in varchar2,
943: p_val_calc_rl in number default hr_api.g_number,
944: p_prem_asnmt_cd in varchar2 default hr_api.g_varchar2,
945: p_prem_asnmt_lvl_cd in varchar2 default hr_api.g_varchar2,
946: p_actl_prem_typ_cd in varchar2 default hr_api.g_varchar2,
947: p_prem_pyr_cd in varchar2 default hr_api.g_varchar2,
948: p_cr_lkbk_val in number default hr_api.g_number,
949: p_cr_lkbk_uom in varchar2 default hr_api.g_varchar2,
950: p_cr_lkbk_crnt_py_only_flag in varchar2,
951: p_prsptv_r_rtsptv_cd in varchar2 default hr_api.g_varchar2,
944: p_prem_asnmt_cd in varchar2 default hr_api.g_varchar2,
945: p_prem_asnmt_lvl_cd in varchar2 default hr_api.g_varchar2,
946: p_actl_prem_typ_cd in varchar2 default hr_api.g_varchar2,
947: p_prem_pyr_cd in varchar2 default hr_api.g_varchar2,
948: p_cr_lkbk_val in number default hr_api.g_number,
949: p_cr_lkbk_uom in varchar2 default hr_api.g_varchar2,
950: p_cr_lkbk_crnt_py_only_flag in varchar2,
951: p_prsptv_r_rtsptv_cd in varchar2 default hr_api.g_varchar2,
952: p_upr_lmt_val in number default hr_api.g_number,
945: p_prem_asnmt_lvl_cd in varchar2 default hr_api.g_varchar2,
946: p_actl_prem_typ_cd in varchar2 default hr_api.g_varchar2,
947: p_prem_pyr_cd in varchar2 default hr_api.g_varchar2,
948: p_cr_lkbk_val in number default hr_api.g_number,
949: p_cr_lkbk_uom in varchar2 default hr_api.g_varchar2,
950: p_cr_lkbk_crnt_py_only_flag in varchar2,
951: p_prsptv_r_rtsptv_cd in varchar2 default hr_api.g_varchar2,
952: p_upr_lmt_val in number default hr_api.g_number,
953: p_upr_lmt_calc_rl in number default hr_api.g_number,
947: p_prem_pyr_cd in varchar2 default hr_api.g_varchar2,
948: p_cr_lkbk_val in number default hr_api.g_number,
949: p_cr_lkbk_uom in varchar2 default hr_api.g_varchar2,
950: p_cr_lkbk_crnt_py_only_flag in varchar2,
951: p_prsptv_r_rtsptv_cd in varchar2 default hr_api.g_varchar2,
952: p_upr_lmt_val in number default hr_api.g_number,
953: p_upr_lmt_calc_rl in number default hr_api.g_number,
954: p_lwr_lmt_val in number default hr_api.g_number,
955: p_lwr_lmt_calc_rl in number default hr_api.g_number,
948: p_cr_lkbk_val in number default hr_api.g_number,
949: p_cr_lkbk_uom in varchar2 default hr_api.g_varchar2,
950: p_cr_lkbk_crnt_py_only_flag in varchar2,
951: p_prsptv_r_rtsptv_cd in varchar2 default hr_api.g_varchar2,
952: p_upr_lmt_val in number default hr_api.g_number,
953: p_upr_lmt_calc_rl in number default hr_api.g_number,
954: p_lwr_lmt_val in number default hr_api.g_number,
955: p_lwr_lmt_calc_rl in number default hr_api.g_number,
956: p_cost_allocation_keyflex_id in number default hr_api.g_number,
949: p_cr_lkbk_uom in varchar2 default hr_api.g_varchar2,
950: p_cr_lkbk_crnt_py_only_flag in varchar2,
951: p_prsptv_r_rtsptv_cd in varchar2 default hr_api.g_varchar2,
952: p_upr_lmt_val in number default hr_api.g_number,
953: p_upr_lmt_calc_rl in number default hr_api.g_number,
954: p_lwr_lmt_val in number default hr_api.g_number,
955: p_lwr_lmt_calc_rl in number default hr_api.g_number,
956: p_cost_allocation_keyflex_id in number default hr_api.g_number,
957: p_organization_id in number default hr_api.g_number,
950: p_cr_lkbk_crnt_py_only_flag in varchar2,
951: p_prsptv_r_rtsptv_cd in varchar2 default hr_api.g_varchar2,
952: p_upr_lmt_val in number default hr_api.g_number,
953: p_upr_lmt_calc_rl in number default hr_api.g_number,
954: p_lwr_lmt_val in number default hr_api.g_number,
955: p_lwr_lmt_calc_rl in number default hr_api.g_number,
956: p_cost_allocation_keyflex_id in number default hr_api.g_number,
957: p_organization_id in number default hr_api.g_number,
958: p_oipl_id in number default hr_api.g_number,
951: p_prsptv_r_rtsptv_cd in varchar2 default hr_api.g_varchar2,
952: p_upr_lmt_val in number default hr_api.g_number,
953: p_upr_lmt_calc_rl in number default hr_api.g_number,
954: p_lwr_lmt_val in number default hr_api.g_number,
955: p_lwr_lmt_calc_rl in number default hr_api.g_number,
956: p_cost_allocation_keyflex_id in number default hr_api.g_number,
957: p_organization_id in number default hr_api.g_number,
958: p_oipl_id in number default hr_api.g_number,
959: p_pl_id in number default hr_api.g_number,
952: p_upr_lmt_val in number default hr_api.g_number,
953: p_upr_lmt_calc_rl in number default hr_api.g_number,
954: p_lwr_lmt_val in number default hr_api.g_number,
955: p_lwr_lmt_calc_rl in number default hr_api.g_number,
956: p_cost_allocation_keyflex_id in number default hr_api.g_number,
957: p_organization_id in number default hr_api.g_number,
958: p_oipl_id in number default hr_api.g_number,
959: p_pl_id in number default hr_api.g_number,
960: p_comp_lvl_fctr_id in number default hr_api.g_number,
953: p_upr_lmt_calc_rl in number default hr_api.g_number,
954: p_lwr_lmt_val in number default hr_api.g_number,
955: p_lwr_lmt_calc_rl in number default hr_api.g_number,
956: p_cost_allocation_keyflex_id in number default hr_api.g_number,
957: p_organization_id in number default hr_api.g_number,
958: p_oipl_id in number default hr_api.g_number,
959: p_pl_id in number default hr_api.g_number,
960: p_comp_lvl_fctr_id in number default hr_api.g_number,
961: p_business_group_id in number default hr_api.g_number,
954: p_lwr_lmt_val in number default hr_api.g_number,
955: p_lwr_lmt_calc_rl in number default hr_api.g_number,
956: p_cost_allocation_keyflex_id in number default hr_api.g_number,
957: p_organization_id in number default hr_api.g_number,
958: p_oipl_id in number default hr_api.g_number,
959: p_pl_id in number default hr_api.g_number,
960: p_comp_lvl_fctr_id in number default hr_api.g_number,
961: p_business_group_id in number default hr_api.g_number,
962: p_prtl_mo_det_mthd_cd in varchar2 default hr_api.g_varchar2,
955: p_lwr_lmt_calc_rl in number default hr_api.g_number,
956: p_cost_allocation_keyflex_id in number default hr_api.g_number,
957: p_organization_id in number default hr_api.g_number,
958: p_oipl_id in number default hr_api.g_number,
959: p_pl_id in number default hr_api.g_number,
960: p_comp_lvl_fctr_id in number default hr_api.g_number,
961: p_business_group_id in number default hr_api.g_number,
962: p_prtl_mo_det_mthd_cd in varchar2 default hr_api.g_varchar2,
963: p_prtl_mo_det_mthd_rl in number default hr_api.g_number,
956: p_cost_allocation_keyflex_id in number default hr_api.g_number,
957: p_organization_id in number default hr_api.g_number,
958: p_oipl_id in number default hr_api.g_number,
959: p_pl_id in number default hr_api.g_number,
960: p_comp_lvl_fctr_id in number default hr_api.g_number,
961: p_business_group_id in number default hr_api.g_number,
962: p_prtl_mo_det_mthd_cd in varchar2 default hr_api.g_varchar2,
963: p_prtl_mo_det_mthd_rl in number default hr_api.g_number,
964: p_wsh_rl_dy_mo_num in number default hr_api.g_number,
957: p_organization_id in number default hr_api.g_number,
958: p_oipl_id in number default hr_api.g_number,
959: p_pl_id in number default hr_api.g_number,
960: p_comp_lvl_fctr_id in number default hr_api.g_number,
961: p_business_group_id in number default hr_api.g_number,
962: p_prtl_mo_det_mthd_cd in varchar2 default hr_api.g_varchar2,
963: p_prtl_mo_det_mthd_rl in number default hr_api.g_number,
964: p_wsh_rl_dy_mo_num in number default hr_api.g_number,
965: p_vrbl_rt_add_on_calc_rl in number default hr_api.g_number,
958: p_oipl_id in number default hr_api.g_number,
959: p_pl_id in number default hr_api.g_number,
960: p_comp_lvl_fctr_id in number default hr_api.g_number,
961: p_business_group_id in number default hr_api.g_number,
962: p_prtl_mo_det_mthd_cd in varchar2 default hr_api.g_varchar2,
963: p_prtl_mo_det_mthd_rl in number default hr_api.g_number,
964: p_wsh_rl_dy_mo_num in number default hr_api.g_number,
965: p_vrbl_rt_add_on_calc_rl in number default hr_api.g_number,
966: p_apr_attribute_category in varchar2 default hr_api.g_varchar2,
959: p_pl_id in number default hr_api.g_number,
960: p_comp_lvl_fctr_id in number default hr_api.g_number,
961: p_business_group_id in number default hr_api.g_number,
962: p_prtl_mo_det_mthd_cd in varchar2 default hr_api.g_varchar2,
963: p_prtl_mo_det_mthd_rl in number default hr_api.g_number,
964: p_wsh_rl_dy_mo_num in number default hr_api.g_number,
965: p_vrbl_rt_add_on_calc_rl in number default hr_api.g_number,
966: p_apr_attribute_category in varchar2 default hr_api.g_varchar2,
967: p_apr_attribute1 in varchar2 default hr_api.g_varchar2,
960: p_comp_lvl_fctr_id in number default hr_api.g_number,
961: p_business_group_id in number default hr_api.g_number,
962: p_prtl_mo_det_mthd_cd in varchar2 default hr_api.g_varchar2,
963: p_prtl_mo_det_mthd_rl in number default hr_api.g_number,
964: p_wsh_rl_dy_mo_num in number default hr_api.g_number,
965: p_vrbl_rt_add_on_calc_rl in number default hr_api.g_number,
966: p_apr_attribute_category in varchar2 default hr_api.g_varchar2,
967: p_apr_attribute1 in varchar2 default hr_api.g_varchar2,
968: p_apr_attribute2 in varchar2 default hr_api.g_varchar2,
961: p_business_group_id in number default hr_api.g_number,
962: p_prtl_mo_det_mthd_cd in varchar2 default hr_api.g_varchar2,
963: p_prtl_mo_det_mthd_rl in number default hr_api.g_number,
964: p_wsh_rl_dy_mo_num in number default hr_api.g_number,
965: p_vrbl_rt_add_on_calc_rl in number default hr_api.g_number,
966: p_apr_attribute_category in varchar2 default hr_api.g_varchar2,
967: p_apr_attribute1 in varchar2 default hr_api.g_varchar2,
968: p_apr_attribute2 in varchar2 default hr_api.g_varchar2,
969: p_apr_attribute3 in varchar2 default hr_api.g_varchar2,
962: p_prtl_mo_det_mthd_cd in varchar2 default hr_api.g_varchar2,
963: p_prtl_mo_det_mthd_rl in number default hr_api.g_number,
964: p_wsh_rl_dy_mo_num in number default hr_api.g_number,
965: p_vrbl_rt_add_on_calc_rl in number default hr_api.g_number,
966: p_apr_attribute_category in varchar2 default hr_api.g_varchar2,
967: p_apr_attribute1 in varchar2 default hr_api.g_varchar2,
968: p_apr_attribute2 in varchar2 default hr_api.g_varchar2,
969: p_apr_attribute3 in varchar2 default hr_api.g_varchar2,
970: p_apr_attribute4 in varchar2 default hr_api.g_varchar2,
963: p_prtl_mo_det_mthd_rl in number default hr_api.g_number,
964: p_wsh_rl_dy_mo_num in number default hr_api.g_number,
965: p_vrbl_rt_add_on_calc_rl in number default hr_api.g_number,
966: p_apr_attribute_category in varchar2 default hr_api.g_varchar2,
967: p_apr_attribute1 in varchar2 default hr_api.g_varchar2,
968: p_apr_attribute2 in varchar2 default hr_api.g_varchar2,
969: p_apr_attribute3 in varchar2 default hr_api.g_varchar2,
970: p_apr_attribute4 in varchar2 default hr_api.g_varchar2,
971: p_apr_attribute5 in varchar2 default hr_api.g_varchar2,
964: p_wsh_rl_dy_mo_num in number default hr_api.g_number,
965: p_vrbl_rt_add_on_calc_rl in number default hr_api.g_number,
966: p_apr_attribute_category in varchar2 default hr_api.g_varchar2,
967: p_apr_attribute1 in varchar2 default hr_api.g_varchar2,
968: p_apr_attribute2 in varchar2 default hr_api.g_varchar2,
969: p_apr_attribute3 in varchar2 default hr_api.g_varchar2,
970: p_apr_attribute4 in varchar2 default hr_api.g_varchar2,
971: p_apr_attribute5 in varchar2 default hr_api.g_varchar2,
972: p_apr_attribute6 in varchar2 default hr_api.g_varchar2,
965: p_vrbl_rt_add_on_calc_rl in number default hr_api.g_number,
966: p_apr_attribute_category in varchar2 default hr_api.g_varchar2,
967: p_apr_attribute1 in varchar2 default hr_api.g_varchar2,
968: p_apr_attribute2 in varchar2 default hr_api.g_varchar2,
969: p_apr_attribute3 in varchar2 default hr_api.g_varchar2,
970: p_apr_attribute4 in varchar2 default hr_api.g_varchar2,
971: p_apr_attribute5 in varchar2 default hr_api.g_varchar2,
972: p_apr_attribute6 in varchar2 default hr_api.g_varchar2,
973: p_apr_attribute7 in varchar2 default hr_api.g_varchar2,
966: p_apr_attribute_category in varchar2 default hr_api.g_varchar2,
967: p_apr_attribute1 in varchar2 default hr_api.g_varchar2,
968: p_apr_attribute2 in varchar2 default hr_api.g_varchar2,
969: p_apr_attribute3 in varchar2 default hr_api.g_varchar2,
970: p_apr_attribute4 in varchar2 default hr_api.g_varchar2,
971: p_apr_attribute5 in varchar2 default hr_api.g_varchar2,
972: p_apr_attribute6 in varchar2 default hr_api.g_varchar2,
973: p_apr_attribute7 in varchar2 default hr_api.g_varchar2,
974: p_apr_attribute8 in varchar2 default hr_api.g_varchar2,
967: p_apr_attribute1 in varchar2 default hr_api.g_varchar2,
968: p_apr_attribute2 in varchar2 default hr_api.g_varchar2,
969: p_apr_attribute3 in varchar2 default hr_api.g_varchar2,
970: p_apr_attribute4 in varchar2 default hr_api.g_varchar2,
971: p_apr_attribute5 in varchar2 default hr_api.g_varchar2,
972: p_apr_attribute6 in varchar2 default hr_api.g_varchar2,
973: p_apr_attribute7 in varchar2 default hr_api.g_varchar2,
974: p_apr_attribute8 in varchar2 default hr_api.g_varchar2,
975: p_apr_attribute9 in varchar2 default hr_api.g_varchar2,
968: p_apr_attribute2 in varchar2 default hr_api.g_varchar2,
969: p_apr_attribute3 in varchar2 default hr_api.g_varchar2,
970: p_apr_attribute4 in varchar2 default hr_api.g_varchar2,
971: p_apr_attribute5 in varchar2 default hr_api.g_varchar2,
972: p_apr_attribute6 in varchar2 default hr_api.g_varchar2,
973: p_apr_attribute7 in varchar2 default hr_api.g_varchar2,
974: p_apr_attribute8 in varchar2 default hr_api.g_varchar2,
975: p_apr_attribute9 in varchar2 default hr_api.g_varchar2,
976: p_apr_attribute10 in varchar2 default hr_api.g_varchar2,
969: p_apr_attribute3 in varchar2 default hr_api.g_varchar2,
970: p_apr_attribute4 in varchar2 default hr_api.g_varchar2,
971: p_apr_attribute5 in varchar2 default hr_api.g_varchar2,
972: p_apr_attribute6 in varchar2 default hr_api.g_varchar2,
973: p_apr_attribute7 in varchar2 default hr_api.g_varchar2,
974: p_apr_attribute8 in varchar2 default hr_api.g_varchar2,
975: p_apr_attribute9 in varchar2 default hr_api.g_varchar2,
976: p_apr_attribute10 in varchar2 default hr_api.g_varchar2,
977: p_apr_attribute11 in varchar2 default hr_api.g_varchar2,
970: p_apr_attribute4 in varchar2 default hr_api.g_varchar2,
971: p_apr_attribute5 in varchar2 default hr_api.g_varchar2,
972: p_apr_attribute6 in varchar2 default hr_api.g_varchar2,
973: p_apr_attribute7 in varchar2 default hr_api.g_varchar2,
974: p_apr_attribute8 in varchar2 default hr_api.g_varchar2,
975: p_apr_attribute9 in varchar2 default hr_api.g_varchar2,
976: p_apr_attribute10 in varchar2 default hr_api.g_varchar2,
977: p_apr_attribute11 in varchar2 default hr_api.g_varchar2,
978: p_apr_attribute12 in varchar2 default hr_api.g_varchar2,
971: p_apr_attribute5 in varchar2 default hr_api.g_varchar2,
972: p_apr_attribute6 in varchar2 default hr_api.g_varchar2,
973: p_apr_attribute7 in varchar2 default hr_api.g_varchar2,
974: p_apr_attribute8 in varchar2 default hr_api.g_varchar2,
975: p_apr_attribute9 in varchar2 default hr_api.g_varchar2,
976: p_apr_attribute10 in varchar2 default hr_api.g_varchar2,
977: p_apr_attribute11 in varchar2 default hr_api.g_varchar2,
978: p_apr_attribute12 in varchar2 default hr_api.g_varchar2,
979: p_apr_attribute13 in varchar2 default hr_api.g_varchar2,
972: p_apr_attribute6 in varchar2 default hr_api.g_varchar2,
973: p_apr_attribute7 in varchar2 default hr_api.g_varchar2,
974: p_apr_attribute8 in varchar2 default hr_api.g_varchar2,
975: p_apr_attribute9 in varchar2 default hr_api.g_varchar2,
976: p_apr_attribute10 in varchar2 default hr_api.g_varchar2,
977: p_apr_attribute11 in varchar2 default hr_api.g_varchar2,
978: p_apr_attribute12 in varchar2 default hr_api.g_varchar2,
979: p_apr_attribute13 in varchar2 default hr_api.g_varchar2,
980: p_apr_attribute14 in varchar2 default hr_api.g_varchar2,
973: p_apr_attribute7 in varchar2 default hr_api.g_varchar2,
974: p_apr_attribute8 in varchar2 default hr_api.g_varchar2,
975: p_apr_attribute9 in varchar2 default hr_api.g_varchar2,
976: p_apr_attribute10 in varchar2 default hr_api.g_varchar2,
977: p_apr_attribute11 in varchar2 default hr_api.g_varchar2,
978: p_apr_attribute12 in varchar2 default hr_api.g_varchar2,
979: p_apr_attribute13 in varchar2 default hr_api.g_varchar2,
980: p_apr_attribute14 in varchar2 default hr_api.g_varchar2,
981: p_apr_attribute15 in varchar2 default hr_api.g_varchar2,
974: p_apr_attribute8 in varchar2 default hr_api.g_varchar2,
975: p_apr_attribute9 in varchar2 default hr_api.g_varchar2,
976: p_apr_attribute10 in varchar2 default hr_api.g_varchar2,
977: p_apr_attribute11 in varchar2 default hr_api.g_varchar2,
978: p_apr_attribute12 in varchar2 default hr_api.g_varchar2,
979: p_apr_attribute13 in varchar2 default hr_api.g_varchar2,
980: p_apr_attribute14 in varchar2 default hr_api.g_varchar2,
981: p_apr_attribute15 in varchar2 default hr_api.g_varchar2,
982: p_apr_attribute16 in varchar2 default hr_api.g_varchar2,
975: p_apr_attribute9 in varchar2 default hr_api.g_varchar2,
976: p_apr_attribute10 in varchar2 default hr_api.g_varchar2,
977: p_apr_attribute11 in varchar2 default hr_api.g_varchar2,
978: p_apr_attribute12 in varchar2 default hr_api.g_varchar2,
979: p_apr_attribute13 in varchar2 default hr_api.g_varchar2,
980: p_apr_attribute14 in varchar2 default hr_api.g_varchar2,
981: p_apr_attribute15 in varchar2 default hr_api.g_varchar2,
982: p_apr_attribute16 in varchar2 default hr_api.g_varchar2,
983: p_apr_attribute17 in varchar2 default hr_api.g_varchar2,
976: p_apr_attribute10 in varchar2 default hr_api.g_varchar2,
977: p_apr_attribute11 in varchar2 default hr_api.g_varchar2,
978: p_apr_attribute12 in varchar2 default hr_api.g_varchar2,
979: p_apr_attribute13 in varchar2 default hr_api.g_varchar2,
980: p_apr_attribute14 in varchar2 default hr_api.g_varchar2,
981: p_apr_attribute15 in varchar2 default hr_api.g_varchar2,
982: p_apr_attribute16 in varchar2 default hr_api.g_varchar2,
983: p_apr_attribute17 in varchar2 default hr_api.g_varchar2,
984: p_apr_attribute18 in varchar2 default hr_api.g_varchar2,
977: p_apr_attribute11 in varchar2 default hr_api.g_varchar2,
978: p_apr_attribute12 in varchar2 default hr_api.g_varchar2,
979: p_apr_attribute13 in varchar2 default hr_api.g_varchar2,
980: p_apr_attribute14 in varchar2 default hr_api.g_varchar2,
981: p_apr_attribute15 in varchar2 default hr_api.g_varchar2,
982: p_apr_attribute16 in varchar2 default hr_api.g_varchar2,
983: p_apr_attribute17 in varchar2 default hr_api.g_varchar2,
984: p_apr_attribute18 in varchar2 default hr_api.g_varchar2,
985: p_apr_attribute19 in varchar2 default hr_api.g_varchar2,
978: p_apr_attribute12 in varchar2 default hr_api.g_varchar2,
979: p_apr_attribute13 in varchar2 default hr_api.g_varchar2,
980: p_apr_attribute14 in varchar2 default hr_api.g_varchar2,
981: p_apr_attribute15 in varchar2 default hr_api.g_varchar2,
982: p_apr_attribute16 in varchar2 default hr_api.g_varchar2,
983: p_apr_attribute17 in varchar2 default hr_api.g_varchar2,
984: p_apr_attribute18 in varchar2 default hr_api.g_varchar2,
985: p_apr_attribute19 in varchar2 default hr_api.g_varchar2,
986: p_apr_attribute20 in varchar2 default hr_api.g_varchar2,
979: p_apr_attribute13 in varchar2 default hr_api.g_varchar2,
980: p_apr_attribute14 in varchar2 default hr_api.g_varchar2,
981: p_apr_attribute15 in varchar2 default hr_api.g_varchar2,
982: p_apr_attribute16 in varchar2 default hr_api.g_varchar2,
983: p_apr_attribute17 in varchar2 default hr_api.g_varchar2,
984: p_apr_attribute18 in varchar2 default hr_api.g_varchar2,
985: p_apr_attribute19 in varchar2 default hr_api.g_varchar2,
986: p_apr_attribute20 in varchar2 default hr_api.g_varchar2,
987: p_apr_attribute21 in varchar2 default hr_api.g_varchar2,
980: p_apr_attribute14 in varchar2 default hr_api.g_varchar2,
981: p_apr_attribute15 in varchar2 default hr_api.g_varchar2,
982: p_apr_attribute16 in varchar2 default hr_api.g_varchar2,
983: p_apr_attribute17 in varchar2 default hr_api.g_varchar2,
984: p_apr_attribute18 in varchar2 default hr_api.g_varchar2,
985: p_apr_attribute19 in varchar2 default hr_api.g_varchar2,
986: p_apr_attribute20 in varchar2 default hr_api.g_varchar2,
987: p_apr_attribute21 in varchar2 default hr_api.g_varchar2,
988: p_apr_attribute22 in varchar2 default hr_api.g_varchar2,
981: p_apr_attribute15 in varchar2 default hr_api.g_varchar2,
982: p_apr_attribute16 in varchar2 default hr_api.g_varchar2,
983: p_apr_attribute17 in varchar2 default hr_api.g_varchar2,
984: p_apr_attribute18 in varchar2 default hr_api.g_varchar2,
985: p_apr_attribute19 in varchar2 default hr_api.g_varchar2,
986: p_apr_attribute20 in varchar2 default hr_api.g_varchar2,
987: p_apr_attribute21 in varchar2 default hr_api.g_varchar2,
988: p_apr_attribute22 in varchar2 default hr_api.g_varchar2,
989: p_apr_attribute23 in varchar2 default hr_api.g_varchar2,
982: p_apr_attribute16 in varchar2 default hr_api.g_varchar2,
983: p_apr_attribute17 in varchar2 default hr_api.g_varchar2,
984: p_apr_attribute18 in varchar2 default hr_api.g_varchar2,
985: p_apr_attribute19 in varchar2 default hr_api.g_varchar2,
986: p_apr_attribute20 in varchar2 default hr_api.g_varchar2,
987: p_apr_attribute21 in varchar2 default hr_api.g_varchar2,
988: p_apr_attribute22 in varchar2 default hr_api.g_varchar2,
989: p_apr_attribute23 in varchar2 default hr_api.g_varchar2,
990: p_apr_attribute24 in varchar2 default hr_api.g_varchar2,
983: p_apr_attribute17 in varchar2 default hr_api.g_varchar2,
984: p_apr_attribute18 in varchar2 default hr_api.g_varchar2,
985: p_apr_attribute19 in varchar2 default hr_api.g_varchar2,
986: p_apr_attribute20 in varchar2 default hr_api.g_varchar2,
987: p_apr_attribute21 in varchar2 default hr_api.g_varchar2,
988: p_apr_attribute22 in varchar2 default hr_api.g_varchar2,
989: p_apr_attribute23 in varchar2 default hr_api.g_varchar2,
990: p_apr_attribute24 in varchar2 default hr_api.g_varchar2,
991: p_apr_attribute25 in varchar2 default hr_api.g_varchar2,
984: p_apr_attribute18 in varchar2 default hr_api.g_varchar2,
985: p_apr_attribute19 in varchar2 default hr_api.g_varchar2,
986: p_apr_attribute20 in varchar2 default hr_api.g_varchar2,
987: p_apr_attribute21 in varchar2 default hr_api.g_varchar2,
988: p_apr_attribute22 in varchar2 default hr_api.g_varchar2,
989: p_apr_attribute23 in varchar2 default hr_api.g_varchar2,
990: p_apr_attribute24 in varchar2 default hr_api.g_varchar2,
991: p_apr_attribute25 in varchar2 default hr_api.g_varchar2,
992: p_apr_attribute26 in varchar2 default hr_api.g_varchar2,
985: p_apr_attribute19 in varchar2 default hr_api.g_varchar2,
986: p_apr_attribute20 in varchar2 default hr_api.g_varchar2,
987: p_apr_attribute21 in varchar2 default hr_api.g_varchar2,
988: p_apr_attribute22 in varchar2 default hr_api.g_varchar2,
989: p_apr_attribute23 in varchar2 default hr_api.g_varchar2,
990: p_apr_attribute24 in varchar2 default hr_api.g_varchar2,
991: p_apr_attribute25 in varchar2 default hr_api.g_varchar2,
992: p_apr_attribute26 in varchar2 default hr_api.g_varchar2,
993: p_apr_attribute27 in varchar2 default hr_api.g_varchar2,
986: p_apr_attribute20 in varchar2 default hr_api.g_varchar2,
987: p_apr_attribute21 in varchar2 default hr_api.g_varchar2,
988: p_apr_attribute22 in varchar2 default hr_api.g_varchar2,
989: p_apr_attribute23 in varchar2 default hr_api.g_varchar2,
990: p_apr_attribute24 in varchar2 default hr_api.g_varchar2,
991: p_apr_attribute25 in varchar2 default hr_api.g_varchar2,
992: p_apr_attribute26 in varchar2 default hr_api.g_varchar2,
993: p_apr_attribute27 in varchar2 default hr_api.g_varchar2,
994: p_apr_attribute28 in varchar2 default hr_api.g_varchar2,
987: p_apr_attribute21 in varchar2 default hr_api.g_varchar2,
988: p_apr_attribute22 in varchar2 default hr_api.g_varchar2,
989: p_apr_attribute23 in varchar2 default hr_api.g_varchar2,
990: p_apr_attribute24 in varchar2 default hr_api.g_varchar2,
991: p_apr_attribute25 in varchar2 default hr_api.g_varchar2,
992: p_apr_attribute26 in varchar2 default hr_api.g_varchar2,
993: p_apr_attribute27 in varchar2 default hr_api.g_varchar2,
994: p_apr_attribute28 in varchar2 default hr_api.g_varchar2,
995: p_apr_attribute29 in varchar2 default hr_api.g_varchar2,
988: p_apr_attribute22 in varchar2 default hr_api.g_varchar2,
989: p_apr_attribute23 in varchar2 default hr_api.g_varchar2,
990: p_apr_attribute24 in varchar2 default hr_api.g_varchar2,
991: p_apr_attribute25 in varchar2 default hr_api.g_varchar2,
992: p_apr_attribute26 in varchar2 default hr_api.g_varchar2,
993: p_apr_attribute27 in varchar2 default hr_api.g_varchar2,
994: p_apr_attribute28 in varchar2 default hr_api.g_varchar2,
995: p_apr_attribute29 in varchar2 default hr_api.g_varchar2,
996: p_apr_attribute30 in varchar2 default hr_api.g_varchar2,
989: p_apr_attribute23 in varchar2 default hr_api.g_varchar2,
990: p_apr_attribute24 in varchar2 default hr_api.g_varchar2,
991: p_apr_attribute25 in varchar2 default hr_api.g_varchar2,
992: p_apr_attribute26 in varchar2 default hr_api.g_varchar2,
993: p_apr_attribute27 in varchar2 default hr_api.g_varchar2,
994: p_apr_attribute28 in varchar2 default hr_api.g_varchar2,
995: p_apr_attribute29 in varchar2 default hr_api.g_varchar2,
996: p_apr_attribute30 in varchar2 default hr_api.g_varchar2,
997: p_object_version_number in out nocopy number,
990: p_apr_attribute24 in varchar2 default hr_api.g_varchar2,
991: p_apr_attribute25 in varchar2 default hr_api.g_varchar2,
992: p_apr_attribute26 in varchar2 default hr_api.g_varchar2,
993: p_apr_attribute27 in varchar2 default hr_api.g_varchar2,
994: p_apr_attribute28 in varchar2 default hr_api.g_varchar2,
995: p_apr_attribute29 in varchar2 default hr_api.g_varchar2,
996: p_apr_attribute30 in varchar2 default hr_api.g_varchar2,
997: p_object_version_number in out nocopy number,
998: p_effective_date in date,
991: p_apr_attribute25 in varchar2 default hr_api.g_varchar2,
992: p_apr_attribute26 in varchar2 default hr_api.g_varchar2,
993: p_apr_attribute27 in varchar2 default hr_api.g_varchar2,
994: p_apr_attribute28 in varchar2 default hr_api.g_varchar2,
995: p_apr_attribute29 in varchar2 default hr_api.g_varchar2,
996: p_apr_attribute30 in varchar2 default hr_api.g_varchar2,
997: p_object_version_number in out nocopy number,
998: p_effective_date in date,
999: p_datetrack_mode in varchar2
992: p_apr_attribute26 in varchar2 default hr_api.g_varchar2,
993: p_apr_attribute27 in varchar2 default hr_api.g_varchar2,
994: p_apr_attribute28 in varchar2 default hr_api.g_varchar2,
995: p_apr_attribute29 in varchar2 default hr_api.g_varchar2,
996: p_apr_attribute30 in varchar2 default hr_api.g_varchar2,
997: p_object_version_number in out nocopy number,
998: p_effective_date in date,
999: p_datetrack_mode in varchar2
1000: ) is