159: End If;
160: --
161: hr_utility.set_location(' Leaving:'||l_proc, 15);
162: Exception
163: When hr_api.check_integrity_violated Then
164: -- A check constraint has been violated
165: ben_ccm_shd.g_api_dml := false; -- Unset the api dml status
166: ben_ccm_shd.constraint_error
167: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
163: When hr_api.check_integrity_violated Then
164: -- A check constraint has been violated
165: ben_ccm_shd.g_api_dml := false; -- Unset the api dml status
166: ben_ccm_shd.constraint_error
167: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
168: When hr_api.unique_integrity_violated Then
169: -- Unique integrity has been violated
170: ben_ccm_shd.g_api_dml := false; -- Unset the api dml status
171: ben_ccm_shd.constraint_error
164: -- A check constraint has been violated
165: ben_ccm_shd.g_api_dml := false; -- Unset the api dml status
166: ben_ccm_shd.constraint_error
167: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
168: When hr_api.unique_integrity_violated Then
169: -- Unique integrity has been violated
170: ben_ccm_shd.g_api_dml := false; -- Unset the api dml status
171: ben_ccm_shd.constraint_error
172: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
168: When hr_api.unique_integrity_violated Then
169: -- Unique integrity has been violated
170: ben_ccm_shd.g_api_dml := false; -- Unset the api dml status
171: ben_ccm_shd.constraint_error
172: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
173: When Others Then
174: ben_ccm_shd.g_api_dml := false; -- Unset the api dml status
175: Raise;
176: End dt_update_dml;
564: );
565: --
566: exception
567: --
568: when hr_api.cannot_find_prog_unit then
569: --
570: hr_api.cannot_find_prog_unit_error
571: (p_module_name => 'ben_cvg_amt_calc_mthd_f'
572: ,p_hook_type => 'AU');
566: exception
567: --
568: when hr_api.cannot_find_prog_unit then
569: --
570: hr_api.cannot_find_prog_unit_error
571: (p_module_name => 'ben_cvg_amt_calc_mthd_f'
572: ,p_hook_type => 'AU');
573: --
574: end;
634: -- p_rec plsql record structure
635: -- to see if a system default is being used. If a system default
636: -- is being used then we must set to the 'current' argument value.
637: --
638: If (p_rec.name = hr_api.g_varchar2) then
639: p_rec.name :=
640: ben_ccm_shd.g_old_rec.name;
641: End If;
642: If (p_rec.incrmt_val = hr_api.g_number) then
638: If (p_rec.name = hr_api.g_varchar2) then
639: p_rec.name :=
640: ben_ccm_shd.g_old_rec.name;
641: End If;
642: If (p_rec.incrmt_val = hr_api.g_number) then
643: p_rec.incrmt_val :=
644: ben_ccm_shd.g_old_rec.incrmt_val;
645: End If;
646: If (p_rec.mx_val = hr_api.g_number) then
642: If (p_rec.incrmt_val = hr_api.g_number) then
643: p_rec.incrmt_val :=
644: ben_ccm_shd.g_old_rec.incrmt_val;
645: End If;
646: If (p_rec.mx_val = hr_api.g_number) then
647: p_rec.mx_val :=
648: ben_ccm_shd.g_old_rec.mx_val;
649: End If;
650: If (p_rec.mn_val = hr_api.g_number) then
646: If (p_rec.mx_val = hr_api.g_number) then
647: p_rec.mx_val :=
648: ben_ccm_shd.g_old_rec.mx_val;
649: End If;
650: If (p_rec.mn_val = hr_api.g_number) then
651: p_rec.mn_val :=
652: ben_ccm_shd.g_old_rec.mn_val;
653: End If;
654: If (p_rec.no_mx_val_dfnd_flag = hr_api.g_varchar2) then
650: If (p_rec.mn_val = hr_api.g_number) then
651: p_rec.mn_val :=
652: ben_ccm_shd.g_old_rec.mn_val;
653: End If;
654: If (p_rec.no_mx_val_dfnd_flag = hr_api.g_varchar2) then
655: p_rec.no_mx_val_dfnd_flag :=
656: ben_ccm_shd.g_old_rec.no_mx_val_dfnd_flag;
657: End If;
658: If (p_rec.no_mn_val_dfnd_flag = hr_api.g_varchar2) then
654: If (p_rec.no_mx_val_dfnd_flag = hr_api.g_varchar2) then
655: p_rec.no_mx_val_dfnd_flag :=
656: ben_ccm_shd.g_old_rec.no_mx_val_dfnd_flag;
657: End If;
658: If (p_rec.no_mn_val_dfnd_flag = hr_api.g_varchar2) then
659: p_rec.no_mn_val_dfnd_flag :=
660: ben_ccm_shd.g_old_rec.no_mn_val_dfnd_flag;
661: End If;
662: If (p_rec.rndg_cd = hr_api.g_varchar2) then
658: If (p_rec.no_mn_val_dfnd_flag = hr_api.g_varchar2) then
659: p_rec.no_mn_val_dfnd_flag :=
660: ben_ccm_shd.g_old_rec.no_mn_val_dfnd_flag;
661: End If;
662: If (p_rec.rndg_cd = hr_api.g_varchar2) then
663: p_rec.rndg_cd :=
664: ben_ccm_shd.g_old_rec.rndg_cd;
665: End If;
666: If (p_rec.rndg_rl = hr_api.g_number) then
662: If (p_rec.rndg_cd = hr_api.g_varchar2) then
663: p_rec.rndg_cd :=
664: ben_ccm_shd.g_old_rec.rndg_cd;
665: End If;
666: If (p_rec.rndg_rl = hr_api.g_number) then
667: p_rec.rndg_rl :=
668: ben_ccm_shd.g_old_rec.rndg_rl;
669: End If;
670: If (p_rec.lwr_lmt_val = hr_api.g_number) then
666: If (p_rec.rndg_rl = hr_api.g_number) then
667: p_rec.rndg_rl :=
668: ben_ccm_shd.g_old_rec.rndg_rl;
669: End If;
670: If (p_rec.lwr_lmt_val = hr_api.g_number) then
671: p_rec.lwr_lmt_val :=
672: ben_ccm_shd.g_old_rec.lwr_lmt_val;
673: End If;
674: If (p_rec.lwr_lmt_calc_rl = hr_api.g_number) then
670: If (p_rec.lwr_lmt_val = hr_api.g_number) then
671: p_rec.lwr_lmt_val :=
672: ben_ccm_shd.g_old_rec.lwr_lmt_val;
673: End If;
674: If (p_rec.lwr_lmt_calc_rl = hr_api.g_number) then
675: p_rec.lwr_lmt_calc_rl :=
676: ben_ccm_shd.g_old_rec.lwr_lmt_calc_rl;
677: End If;
678: If (p_rec.upr_lmt_val = hr_api.g_number) then
674: If (p_rec.lwr_lmt_calc_rl = hr_api.g_number) then
675: p_rec.lwr_lmt_calc_rl :=
676: ben_ccm_shd.g_old_rec.lwr_lmt_calc_rl;
677: End If;
678: If (p_rec.upr_lmt_val = hr_api.g_number) then
679: p_rec.upr_lmt_val :=
680: ben_ccm_shd.g_old_rec.upr_lmt_val;
681: End If;
682: If (p_rec.upr_lmt_calc_rl = hr_api.g_number) then
678: If (p_rec.upr_lmt_val = hr_api.g_number) then
679: p_rec.upr_lmt_val :=
680: ben_ccm_shd.g_old_rec.upr_lmt_val;
681: End If;
682: If (p_rec.upr_lmt_calc_rl = hr_api.g_number) then
683: p_rec.upr_lmt_calc_rl :=
684: ben_ccm_shd.g_old_rec.upr_lmt_calc_rl;
685: End If;
686: If (p_rec.val = hr_api.g_number) then
682: If (p_rec.upr_lmt_calc_rl = hr_api.g_number) then
683: p_rec.upr_lmt_calc_rl :=
684: ben_ccm_shd.g_old_rec.upr_lmt_calc_rl;
685: End If;
686: If (p_rec.val = hr_api.g_number) then
687: p_rec.val :=
688: ben_ccm_shd.g_old_rec.val;
689: End If;
690: If (p_rec.val_ovrid_alwd_flag = hr_api.g_varchar2) then
686: If (p_rec.val = hr_api.g_number) then
687: p_rec.val :=
688: ben_ccm_shd.g_old_rec.val;
689: End If;
690: If (p_rec.val_ovrid_alwd_flag = hr_api.g_varchar2) then
691: p_rec.val_ovrid_alwd_flag :=
692: ben_ccm_shd.g_old_rec.val_ovrid_alwd_flag;
693: End If;
694: If (p_rec.val_calc_rl = hr_api.g_number) then
690: If (p_rec.val_ovrid_alwd_flag = hr_api.g_varchar2) then
691: p_rec.val_ovrid_alwd_flag :=
692: ben_ccm_shd.g_old_rec.val_ovrid_alwd_flag;
693: End If;
694: If (p_rec.val_calc_rl = hr_api.g_number) then
695: p_rec.val_calc_rl :=
696: ben_ccm_shd.g_old_rec.val_calc_rl;
697: End If;
698: If (p_rec.uom = hr_api.g_varchar2) then
694: If (p_rec.val_calc_rl = hr_api.g_number) then
695: p_rec.val_calc_rl :=
696: ben_ccm_shd.g_old_rec.val_calc_rl;
697: End If;
698: If (p_rec.uom = hr_api.g_varchar2) then
699: p_rec.uom :=
700: ben_ccm_shd.g_old_rec.uom;
701: End If;
702: If (p_rec.nnmntry_uom = hr_api.g_varchar2) then
698: If (p_rec.uom = hr_api.g_varchar2) then
699: p_rec.uom :=
700: ben_ccm_shd.g_old_rec.uom;
701: End If;
702: If (p_rec.nnmntry_uom = hr_api.g_varchar2) then
703: p_rec.nnmntry_uom :=
704: ben_ccm_shd.g_old_rec.nnmntry_uom;
705: End If;
706: If (p_rec.bndry_perd_cd = hr_api.g_varchar2) then
702: If (p_rec.nnmntry_uom = hr_api.g_varchar2) then
703: p_rec.nnmntry_uom :=
704: ben_ccm_shd.g_old_rec.nnmntry_uom;
705: End If;
706: If (p_rec.bndry_perd_cd = hr_api.g_varchar2) then
707: p_rec.bndry_perd_cd :=
708: ben_ccm_shd.g_old_rec.bndry_perd_cd;
709: End If;
710: If (p_rec.bnft_typ_cd = hr_api.g_varchar2) then
706: If (p_rec.bndry_perd_cd = hr_api.g_varchar2) then
707: p_rec.bndry_perd_cd :=
708: ben_ccm_shd.g_old_rec.bndry_perd_cd;
709: End If;
710: If (p_rec.bnft_typ_cd = hr_api.g_varchar2) then
711: p_rec.bnft_typ_cd :=
712: ben_ccm_shd.g_old_rec.bnft_typ_cd;
713: End If;
714: If (p_rec.cvg_mlt_cd = hr_api.g_varchar2) then
710: If (p_rec.bnft_typ_cd = hr_api.g_varchar2) then
711: p_rec.bnft_typ_cd :=
712: ben_ccm_shd.g_old_rec.bnft_typ_cd;
713: End If;
714: If (p_rec.cvg_mlt_cd = hr_api.g_varchar2) then
715: p_rec.cvg_mlt_cd :=
716: ben_ccm_shd.g_old_rec.cvg_mlt_cd;
717: End If;
718: If (p_rec.rt_typ_cd = hr_api.g_varchar2) then
714: If (p_rec.cvg_mlt_cd = hr_api.g_varchar2) then
715: p_rec.cvg_mlt_cd :=
716: ben_ccm_shd.g_old_rec.cvg_mlt_cd;
717: End If;
718: If (p_rec.rt_typ_cd = hr_api.g_varchar2) then
719: p_rec.rt_typ_cd :=
720: ben_ccm_shd.g_old_rec.rt_typ_cd;
721: End If;
722:
719: p_rec.rt_typ_cd :=
720: ben_ccm_shd.g_old_rec.rt_typ_cd;
721: End If;
722:
723: If (p_rec.dflt_val = hr_api.g_number) then
724: p_rec.dflt_val :=
725: ben_ccm_shd.g_old_rec.dflt_val ;
726: End If;
727: If (p_rec.entr_val_at_enrt_flag = hr_api.g_varchar2) then
723: If (p_rec.dflt_val = hr_api.g_number) then
724: p_rec.dflt_val :=
725: ben_ccm_shd.g_old_rec.dflt_val ;
726: End If;
727: If (p_rec.entr_val_at_enrt_flag = hr_api.g_varchar2) then
728: p_rec.entr_val_at_enrt_flag :=
729: ben_ccm_shd.g_old_rec.entr_val_at_enrt_flag ;
730: End If;
731: If (p_rec.dflt_flag = hr_api.g_varchar2) then
727: If (p_rec.entr_val_at_enrt_flag = hr_api.g_varchar2) then
728: p_rec.entr_val_at_enrt_flag :=
729: ben_ccm_shd.g_old_rec.entr_val_at_enrt_flag ;
730: End If;
731: If (p_rec.dflt_flag = hr_api.g_varchar2) then
732: p_rec.dflt_flag :=
733: ben_ccm_shd.g_old_rec.dflt_flag ;
734: End If;
735: If (p_rec.comp_lvl_fctr_id = hr_api.g_number) then
731: If (p_rec.dflt_flag = hr_api.g_varchar2) then
732: p_rec.dflt_flag :=
733: ben_ccm_shd.g_old_rec.dflt_flag ;
734: End If;
735: If (p_rec.comp_lvl_fctr_id = hr_api.g_number) then
736: p_rec.comp_lvl_fctr_id :=
737: ben_ccm_shd.g_old_rec.comp_lvl_fctr_id;
738: End If;
739: If (p_rec.oipl_id = hr_api.g_number) then
735: If (p_rec.comp_lvl_fctr_id = hr_api.g_number) then
736: p_rec.comp_lvl_fctr_id :=
737: ben_ccm_shd.g_old_rec.comp_lvl_fctr_id;
738: End If;
739: If (p_rec.oipl_id = hr_api.g_number) then
740: p_rec.oipl_id :=
741: ben_ccm_shd.g_old_rec.oipl_id;
742: End If;
743: If (p_rec.pl_id = hr_api.g_number) then
739: If (p_rec.oipl_id = hr_api.g_number) then
740: p_rec.oipl_id :=
741: ben_ccm_shd.g_old_rec.oipl_id;
742: End If;
743: If (p_rec.pl_id = hr_api.g_number) then
744: p_rec.pl_id :=
745: ben_ccm_shd.g_old_rec.pl_id;
746: End If;
747: If (p_rec.plip_id = hr_api.g_number) then
743: If (p_rec.pl_id = hr_api.g_number) then
744: p_rec.pl_id :=
745: ben_ccm_shd.g_old_rec.pl_id;
746: End If;
747: If (p_rec.plip_id = hr_api.g_number) then
748: p_rec.plip_id :=
749: ben_ccm_shd.g_old_rec.plip_id;
750: End If;
751: If (p_rec.business_group_id = hr_api.g_number) then
747: If (p_rec.plip_id = hr_api.g_number) then
748: p_rec.plip_id :=
749: ben_ccm_shd.g_old_rec.plip_id;
750: End If;
751: If (p_rec.business_group_id = hr_api.g_number) then
752: p_rec.business_group_id :=
753: ben_ccm_shd.g_old_rec.business_group_id;
754: End If;
755: If (p_rec.ccm_attribute_category = hr_api.g_varchar2) then
751: If (p_rec.business_group_id = hr_api.g_number) then
752: p_rec.business_group_id :=
753: ben_ccm_shd.g_old_rec.business_group_id;
754: End If;
755: If (p_rec.ccm_attribute_category = hr_api.g_varchar2) then
756: p_rec.ccm_attribute_category :=
757: ben_ccm_shd.g_old_rec.ccm_attribute_category;
758: End If;
759: If (p_rec.ccm_attribute1 = hr_api.g_varchar2) then
755: If (p_rec.ccm_attribute_category = hr_api.g_varchar2) then
756: p_rec.ccm_attribute_category :=
757: ben_ccm_shd.g_old_rec.ccm_attribute_category;
758: End If;
759: If (p_rec.ccm_attribute1 = hr_api.g_varchar2) then
760: p_rec.ccm_attribute1 :=
761: ben_ccm_shd.g_old_rec.ccm_attribute1;
762: End If;
763: If (p_rec.ccm_attribute2 = hr_api.g_varchar2) then
759: If (p_rec.ccm_attribute1 = hr_api.g_varchar2) then
760: p_rec.ccm_attribute1 :=
761: ben_ccm_shd.g_old_rec.ccm_attribute1;
762: End If;
763: If (p_rec.ccm_attribute2 = hr_api.g_varchar2) then
764: p_rec.ccm_attribute2 :=
765: ben_ccm_shd.g_old_rec.ccm_attribute2;
766: End If;
767: If (p_rec.ccm_attribute3 = hr_api.g_varchar2) then
763: If (p_rec.ccm_attribute2 = hr_api.g_varchar2) then
764: p_rec.ccm_attribute2 :=
765: ben_ccm_shd.g_old_rec.ccm_attribute2;
766: End If;
767: If (p_rec.ccm_attribute3 = hr_api.g_varchar2) then
768: p_rec.ccm_attribute3 :=
769: ben_ccm_shd.g_old_rec.ccm_attribute3;
770: End If;
771: If (p_rec.ccm_attribute4 = hr_api.g_varchar2) then
767: If (p_rec.ccm_attribute3 = hr_api.g_varchar2) then
768: p_rec.ccm_attribute3 :=
769: ben_ccm_shd.g_old_rec.ccm_attribute3;
770: End If;
771: If (p_rec.ccm_attribute4 = hr_api.g_varchar2) then
772: p_rec.ccm_attribute4 :=
773: ben_ccm_shd.g_old_rec.ccm_attribute4;
774: End If;
775: If (p_rec.ccm_attribute5 = hr_api.g_varchar2) then
771: If (p_rec.ccm_attribute4 = hr_api.g_varchar2) then
772: p_rec.ccm_attribute4 :=
773: ben_ccm_shd.g_old_rec.ccm_attribute4;
774: End If;
775: If (p_rec.ccm_attribute5 = hr_api.g_varchar2) then
776: p_rec.ccm_attribute5 :=
777: ben_ccm_shd.g_old_rec.ccm_attribute5;
778: End If;
779: If (p_rec.ccm_attribute6 = hr_api.g_varchar2) then
775: If (p_rec.ccm_attribute5 = hr_api.g_varchar2) then
776: p_rec.ccm_attribute5 :=
777: ben_ccm_shd.g_old_rec.ccm_attribute5;
778: End If;
779: If (p_rec.ccm_attribute6 = hr_api.g_varchar2) then
780: p_rec.ccm_attribute6 :=
781: ben_ccm_shd.g_old_rec.ccm_attribute6;
782: End If;
783: If (p_rec.ccm_attribute7 = hr_api.g_varchar2) then
779: If (p_rec.ccm_attribute6 = hr_api.g_varchar2) then
780: p_rec.ccm_attribute6 :=
781: ben_ccm_shd.g_old_rec.ccm_attribute6;
782: End If;
783: If (p_rec.ccm_attribute7 = hr_api.g_varchar2) then
784: p_rec.ccm_attribute7 :=
785: ben_ccm_shd.g_old_rec.ccm_attribute7;
786: End If;
787: If (p_rec.ccm_attribute8 = hr_api.g_varchar2) then
783: If (p_rec.ccm_attribute7 = hr_api.g_varchar2) then
784: p_rec.ccm_attribute7 :=
785: ben_ccm_shd.g_old_rec.ccm_attribute7;
786: End If;
787: If (p_rec.ccm_attribute8 = hr_api.g_varchar2) then
788: p_rec.ccm_attribute8 :=
789: ben_ccm_shd.g_old_rec.ccm_attribute8;
790: End If;
791: If (p_rec.ccm_attribute9 = hr_api.g_varchar2) then
787: If (p_rec.ccm_attribute8 = hr_api.g_varchar2) then
788: p_rec.ccm_attribute8 :=
789: ben_ccm_shd.g_old_rec.ccm_attribute8;
790: End If;
791: If (p_rec.ccm_attribute9 = hr_api.g_varchar2) then
792: p_rec.ccm_attribute9 :=
793: ben_ccm_shd.g_old_rec.ccm_attribute9;
794: End If;
795: If (p_rec.ccm_attribute10 = hr_api.g_varchar2) then
791: If (p_rec.ccm_attribute9 = hr_api.g_varchar2) then
792: p_rec.ccm_attribute9 :=
793: ben_ccm_shd.g_old_rec.ccm_attribute9;
794: End If;
795: If (p_rec.ccm_attribute10 = hr_api.g_varchar2) then
796: p_rec.ccm_attribute10 :=
797: ben_ccm_shd.g_old_rec.ccm_attribute10;
798: End If;
799: If (p_rec.ccm_attribute11 = hr_api.g_varchar2) then
795: If (p_rec.ccm_attribute10 = hr_api.g_varchar2) then
796: p_rec.ccm_attribute10 :=
797: ben_ccm_shd.g_old_rec.ccm_attribute10;
798: End If;
799: If (p_rec.ccm_attribute11 = hr_api.g_varchar2) then
800: p_rec.ccm_attribute11 :=
801: ben_ccm_shd.g_old_rec.ccm_attribute11;
802: End If;
803: If (p_rec.ccm_attribute12 = hr_api.g_varchar2) then
799: If (p_rec.ccm_attribute11 = hr_api.g_varchar2) then
800: p_rec.ccm_attribute11 :=
801: ben_ccm_shd.g_old_rec.ccm_attribute11;
802: End If;
803: If (p_rec.ccm_attribute12 = hr_api.g_varchar2) then
804: p_rec.ccm_attribute12 :=
805: ben_ccm_shd.g_old_rec.ccm_attribute12;
806: End If;
807: If (p_rec.ccm_attribute13 = hr_api.g_varchar2) then
803: If (p_rec.ccm_attribute12 = hr_api.g_varchar2) then
804: p_rec.ccm_attribute12 :=
805: ben_ccm_shd.g_old_rec.ccm_attribute12;
806: End If;
807: If (p_rec.ccm_attribute13 = hr_api.g_varchar2) then
808: p_rec.ccm_attribute13 :=
809: ben_ccm_shd.g_old_rec.ccm_attribute13;
810: End If;
811: If (p_rec.ccm_attribute14 = hr_api.g_varchar2) then
807: If (p_rec.ccm_attribute13 = hr_api.g_varchar2) then
808: p_rec.ccm_attribute13 :=
809: ben_ccm_shd.g_old_rec.ccm_attribute13;
810: End If;
811: If (p_rec.ccm_attribute14 = hr_api.g_varchar2) then
812: p_rec.ccm_attribute14 :=
813: ben_ccm_shd.g_old_rec.ccm_attribute14;
814: End If;
815: If (p_rec.ccm_attribute15 = hr_api.g_varchar2) then
811: If (p_rec.ccm_attribute14 = hr_api.g_varchar2) then
812: p_rec.ccm_attribute14 :=
813: ben_ccm_shd.g_old_rec.ccm_attribute14;
814: End If;
815: If (p_rec.ccm_attribute15 = hr_api.g_varchar2) then
816: p_rec.ccm_attribute15 :=
817: ben_ccm_shd.g_old_rec.ccm_attribute15;
818: End If;
819: If (p_rec.ccm_attribute16 = hr_api.g_varchar2) then
815: If (p_rec.ccm_attribute15 = hr_api.g_varchar2) then
816: p_rec.ccm_attribute15 :=
817: ben_ccm_shd.g_old_rec.ccm_attribute15;
818: End If;
819: If (p_rec.ccm_attribute16 = hr_api.g_varchar2) then
820: p_rec.ccm_attribute16 :=
821: ben_ccm_shd.g_old_rec.ccm_attribute16;
822: End If;
823: If (p_rec.ccm_attribute17 = hr_api.g_varchar2) then
819: If (p_rec.ccm_attribute16 = hr_api.g_varchar2) then
820: p_rec.ccm_attribute16 :=
821: ben_ccm_shd.g_old_rec.ccm_attribute16;
822: End If;
823: If (p_rec.ccm_attribute17 = hr_api.g_varchar2) then
824: p_rec.ccm_attribute17 :=
825: ben_ccm_shd.g_old_rec.ccm_attribute17;
826: End If;
827: If (p_rec.ccm_attribute18 = hr_api.g_varchar2) then
823: If (p_rec.ccm_attribute17 = hr_api.g_varchar2) then
824: p_rec.ccm_attribute17 :=
825: ben_ccm_shd.g_old_rec.ccm_attribute17;
826: End If;
827: If (p_rec.ccm_attribute18 = hr_api.g_varchar2) then
828: p_rec.ccm_attribute18 :=
829: ben_ccm_shd.g_old_rec.ccm_attribute18;
830: End If;
831: If (p_rec.ccm_attribute19 = hr_api.g_varchar2) then
827: If (p_rec.ccm_attribute18 = hr_api.g_varchar2) then
828: p_rec.ccm_attribute18 :=
829: ben_ccm_shd.g_old_rec.ccm_attribute18;
830: End If;
831: If (p_rec.ccm_attribute19 = hr_api.g_varchar2) then
832: p_rec.ccm_attribute19 :=
833: ben_ccm_shd.g_old_rec.ccm_attribute19;
834: End If;
835: If (p_rec.ccm_attribute20 = hr_api.g_varchar2) then
831: If (p_rec.ccm_attribute19 = hr_api.g_varchar2) then
832: p_rec.ccm_attribute19 :=
833: ben_ccm_shd.g_old_rec.ccm_attribute19;
834: End If;
835: If (p_rec.ccm_attribute20 = hr_api.g_varchar2) then
836: p_rec.ccm_attribute20 :=
837: ben_ccm_shd.g_old_rec.ccm_attribute20;
838: End If;
839: If (p_rec.ccm_attribute21 = hr_api.g_varchar2) then
835: If (p_rec.ccm_attribute20 = hr_api.g_varchar2) then
836: p_rec.ccm_attribute20 :=
837: ben_ccm_shd.g_old_rec.ccm_attribute20;
838: End If;
839: If (p_rec.ccm_attribute21 = hr_api.g_varchar2) then
840: p_rec.ccm_attribute21 :=
841: ben_ccm_shd.g_old_rec.ccm_attribute21;
842: End If;
843: If (p_rec.ccm_attribute22 = hr_api.g_varchar2) then
839: If (p_rec.ccm_attribute21 = hr_api.g_varchar2) then
840: p_rec.ccm_attribute21 :=
841: ben_ccm_shd.g_old_rec.ccm_attribute21;
842: End If;
843: If (p_rec.ccm_attribute22 = hr_api.g_varchar2) then
844: p_rec.ccm_attribute22 :=
845: ben_ccm_shd.g_old_rec.ccm_attribute22;
846: End If;
847: If (p_rec.ccm_attribute23 = hr_api.g_varchar2) then
843: If (p_rec.ccm_attribute22 = hr_api.g_varchar2) then
844: p_rec.ccm_attribute22 :=
845: ben_ccm_shd.g_old_rec.ccm_attribute22;
846: End If;
847: If (p_rec.ccm_attribute23 = hr_api.g_varchar2) then
848: p_rec.ccm_attribute23 :=
849: ben_ccm_shd.g_old_rec.ccm_attribute23;
850: End If;
851: If (p_rec.ccm_attribute24 = hr_api.g_varchar2) then
847: If (p_rec.ccm_attribute23 = hr_api.g_varchar2) then
848: p_rec.ccm_attribute23 :=
849: ben_ccm_shd.g_old_rec.ccm_attribute23;
850: End If;
851: If (p_rec.ccm_attribute24 = hr_api.g_varchar2) then
852: p_rec.ccm_attribute24 :=
853: ben_ccm_shd.g_old_rec.ccm_attribute24;
854: End If;
855: If (p_rec.ccm_attribute25 = hr_api.g_varchar2) then
851: If (p_rec.ccm_attribute24 = hr_api.g_varchar2) then
852: p_rec.ccm_attribute24 :=
853: ben_ccm_shd.g_old_rec.ccm_attribute24;
854: End If;
855: If (p_rec.ccm_attribute25 = hr_api.g_varchar2) then
856: p_rec.ccm_attribute25 :=
857: ben_ccm_shd.g_old_rec.ccm_attribute25;
858: End If;
859: If (p_rec.ccm_attribute26 = hr_api.g_varchar2) then
855: If (p_rec.ccm_attribute25 = hr_api.g_varchar2) then
856: p_rec.ccm_attribute25 :=
857: ben_ccm_shd.g_old_rec.ccm_attribute25;
858: End If;
859: If (p_rec.ccm_attribute26 = hr_api.g_varchar2) then
860: p_rec.ccm_attribute26 :=
861: ben_ccm_shd.g_old_rec.ccm_attribute26;
862: End If;
863: If (p_rec.ccm_attribute27 = hr_api.g_varchar2) then
859: If (p_rec.ccm_attribute26 = hr_api.g_varchar2) then
860: p_rec.ccm_attribute26 :=
861: ben_ccm_shd.g_old_rec.ccm_attribute26;
862: End If;
863: If (p_rec.ccm_attribute27 = hr_api.g_varchar2) then
864: p_rec.ccm_attribute27 :=
865: ben_ccm_shd.g_old_rec.ccm_attribute27;
866: End If;
867: If (p_rec.ccm_attribute28 = hr_api.g_varchar2) then
863: If (p_rec.ccm_attribute27 = hr_api.g_varchar2) then
864: p_rec.ccm_attribute27 :=
865: ben_ccm_shd.g_old_rec.ccm_attribute27;
866: End If;
867: If (p_rec.ccm_attribute28 = hr_api.g_varchar2) then
868: p_rec.ccm_attribute28 :=
869: ben_ccm_shd.g_old_rec.ccm_attribute28;
870: End If;
871: If (p_rec.ccm_attribute29 = hr_api.g_varchar2) then
867: If (p_rec.ccm_attribute28 = hr_api.g_varchar2) then
868: p_rec.ccm_attribute28 :=
869: ben_ccm_shd.g_old_rec.ccm_attribute28;
870: End If;
871: If (p_rec.ccm_attribute29 = hr_api.g_varchar2) then
872: p_rec.ccm_attribute29 :=
873: ben_ccm_shd.g_old_rec.ccm_attribute29;
874: End If;
875: If (p_rec.ccm_attribute30 = hr_api.g_varchar2) then
871: If (p_rec.ccm_attribute29 = hr_api.g_varchar2) then
872: p_rec.ccm_attribute29 :=
873: ben_ccm_shd.g_old_rec.ccm_attribute29;
874: End If;
875: If (p_rec.ccm_attribute30 = hr_api.g_varchar2) then
876: p_rec.ccm_attribute30 :=
877: ben_ccm_shd.g_old_rec.ccm_attribute30;
878: End If;
879:
962: (
963: p_cvg_amt_calc_mthd_id in number,
964: p_effective_start_date out nocopy date,
965: p_effective_end_date out nocopy date,
966: p_name in varchar2 default hr_api.g_varchar2,
967: p_incrmt_val in number default hr_api.g_number,
968: p_mx_val in number default hr_api.g_number,
969: p_mn_val in number default hr_api.g_number,
970: p_no_mx_val_dfnd_flag in varchar2 default hr_api.g_varchar2,
963: p_cvg_amt_calc_mthd_id in number,
964: p_effective_start_date out nocopy date,
965: p_effective_end_date out nocopy date,
966: p_name in varchar2 default hr_api.g_varchar2,
967: p_incrmt_val in number default hr_api.g_number,
968: p_mx_val in number default hr_api.g_number,
969: p_mn_val in number default hr_api.g_number,
970: p_no_mx_val_dfnd_flag in varchar2 default hr_api.g_varchar2,
971: p_no_mn_val_dfnd_flag in varchar2 default hr_api.g_varchar2,
964: p_effective_start_date out nocopy date,
965: p_effective_end_date out nocopy date,
966: p_name in varchar2 default hr_api.g_varchar2,
967: p_incrmt_val in number default hr_api.g_number,
968: p_mx_val in number default hr_api.g_number,
969: p_mn_val in number default hr_api.g_number,
970: p_no_mx_val_dfnd_flag in varchar2 default hr_api.g_varchar2,
971: p_no_mn_val_dfnd_flag in varchar2 default hr_api.g_varchar2,
972: p_rndg_cd in varchar2 default hr_api.g_varchar2,
965: p_effective_end_date out nocopy date,
966: p_name in varchar2 default hr_api.g_varchar2,
967: p_incrmt_val in number default hr_api.g_number,
968: p_mx_val in number default hr_api.g_number,
969: p_mn_val in number default hr_api.g_number,
970: p_no_mx_val_dfnd_flag in varchar2 default hr_api.g_varchar2,
971: p_no_mn_val_dfnd_flag in varchar2 default hr_api.g_varchar2,
972: p_rndg_cd in varchar2 default hr_api.g_varchar2,
973: p_rndg_rl in number default hr_api.g_number,
966: p_name in varchar2 default hr_api.g_varchar2,
967: p_incrmt_val in number default hr_api.g_number,
968: p_mx_val in number default hr_api.g_number,
969: p_mn_val in number default hr_api.g_number,
970: p_no_mx_val_dfnd_flag in varchar2 default hr_api.g_varchar2,
971: p_no_mn_val_dfnd_flag in varchar2 default hr_api.g_varchar2,
972: p_rndg_cd in varchar2 default hr_api.g_varchar2,
973: p_rndg_rl in number default hr_api.g_number,
974: p_lwr_lmt_val in number default hr_api.g_number,
967: p_incrmt_val in number default hr_api.g_number,
968: p_mx_val in number default hr_api.g_number,
969: p_mn_val in number default hr_api.g_number,
970: p_no_mx_val_dfnd_flag in varchar2 default hr_api.g_varchar2,
971: p_no_mn_val_dfnd_flag in varchar2 default hr_api.g_varchar2,
972: p_rndg_cd in varchar2 default hr_api.g_varchar2,
973: p_rndg_rl in number default hr_api.g_number,
974: p_lwr_lmt_val in number default hr_api.g_number,
975: p_lwr_lmt_calc_rl in number default hr_api.g_number,
968: p_mx_val in number default hr_api.g_number,
969: p_mn_val in number default hr_api.g_number,
970: p_no_mx_val_dfnd_flag in varchar2 default hr_api.g_varchar2,
971: p_no_mn_val_dfnd_flag in varchar2 default hr_api.g_varchar2,
972: p_rndg_cd in varchar2 default hr_api.g_varchar2,
973: p_rndg_rl in number default hr_api.g_number,
974: p_lwr_lmt_val in number default hr_api.g_number,
975: p_lwr_lmt_calc_rl in number default hr_api.g_number,
976: p_upr_lmt_val in number default hr_api.g_number,
969: p_mn_val in number default hr_api.g_number,
970: p_no_mx_val_dfnd_flag in varchar2 default hr_api.g_varchar2,
971: p_no_mn_val_dfnd_flag in varchar2 default hr_api.g_varchar2,
972: p_rndg_cd in varchar2 default hr_api.g_varchar2,
973: p_rndg_rl in number default hr_api.g_number,
974: p_lwr_lmt_val in number default hr_api.g_number,
975: p_lwr_lmt_calc_rl in number default hr_api.g_number,
976: p_upr_lmt_val in number default hr_api.g_number,
977: p_upr_lmt_calc_rl in number default hr_api.g_number,
970: p_no_mx_val_dfnd_flag in varchar2 default hr_api.g_varchar2,
971: p_no_mn_val_dfnd_flag in varchar2 default hr_api.g_varchar2,
972: p_rndg_cd in varchar2 default hr_api.g_varchar2,
973: p_rndg_rl in number default hr_api.g_number,
974: p_lwr_lmt_val in number default hr_api.g_number,
975: p_lwr_lmt_calc_rl in number default hr_api.g_number,
976: p_upr_lmt_val in number default hr_api.g_number,
977: p_upr_lmt_calc_rl in number default hr_api.g_number,
978: p_val in number default hr_api.g_number,
971: p_no_mn_val_dfnd_flag in varchar2 default hr_api.g_varchar2,
972: p_rndg_cd in varchar2 default hr_api.g_varchar2,
973: p_rndg_rl in number default hr_api.g_number,
974: p_lwr_lmt_val in number default hr_api.g_number,
975: p_lwr_lmt_calc_rl in number default hr_api.g_number,
976: p_upr_lmt_val in number default hr_api.g_number,
977: p_upr_lmt_calc_rl in number default hr_api.g_number,
978: p_val in number default hr_api.g_number,
979: p_val_ovrid_alwd_flag in varchar2 default hr_api.g_varchar2,
972: p_rndg_cd in varchar2 default hr_api.g_varchar2,
973: p_rndg_rl in number default hr_api.g_number,
974: p_lwr_lmt_val in number default hr_api.g_number,
975: p_lwr_lmt_calc_rl in number default hr_api.g_number,
976: p_upr_lmt_val in number default hr_api.g_number,
977: p_upr_lmt_calc_rl in number default hr_api.g_number,
978: p_val in number default hr_api.g_number,
979: p_val_ovrid_alwd_flag in varchar2 default hr_api.g_varchar2,
980: p_val_calc_rl in number default hr_api.g_number,
973: p_rndg_rl in number default hr_api.g_number,
974: p_lwr_lmt_val in number default hr_api.g_number,
975: p_lwr_lmt_calc_rl in number default hr_api.g_number,
976: p_upr_lmt_val in number default hr_api.g_number,
977: p_upr_lmt_calc_rl in number default hr_api.g_number,
978: p_val in number default hr_api.g_number,
979: p_val_ovrid_alwd_flag in varchar2 default hr_api.g_varchar2,
980: p_val_calc_rl in number default hr_api.g_number,
981: p_uom in varchar2 default hr_api.g_varchar2,
974: p_lwr_lmt_val in number default hr_api.g_number,
975: p_lwr_lmt_calc_rl in number default hr_api.g_number,
976: p_upr_lmt_val in number default hr_api.g_number,
977: p_upr_lmt_calc_rl in number default hr_api.g_number,
978: p_val in number default hr_api.g_number,
979: p_val_ovrid_alwd_flag in varchar2 default hr_api.g_varchar2,
980: p_val_calc_rl in number default hr_api.g_number,
981: p_uom in varchar2 default hr_api.g_varchar2,
982: p_nnmntry_uom in varchar2 default hr_api.g_varchar2,
975: p_lwr_lmt_calc_rl in number default hr_api.g_number,
976: p_upr_lmt_val in number default hr_api.g_number,
977: p_upr_lmt_calc_rl in number default hr_api.g_number,
978: p_val in number default hr_api.g_number,
979: p_val_ovrid_alwd_flag in varchar2 default hr_api.g_varchar2,
980: p_val_calc_rl in number default hr_api.g_number,
981: p_uom in varchar2 default hr_api.g_varchar2,
982: p_nnmntry_uom in varchar2 default hr_api.g_varchar2,
983: p_bndry_perd_cd in varchar2 default hr_api.g_varchar2,
976: p_upr_lmt_val in number default hr_api.g_number,
977: p_upr_lmt_calc_rl in number default hr_api.g_number,
978: p_val in number default hr_api.g_number,
979: p_val_ovrid_alwd_flag in varchar2 default hr_api.g_varchar2,
980: p_val_calc_rl in number default hr_api.g_number,
981: p_uom in varchar2 default hr_api.g_varchar2,
982: p_nnmntry_uom in varchar2 default hr_api.g_varchar2,
983: p_bndry_perd_cd in varchar2 default hr_api.g_varchar2,
984: p_bnft_typ_cd in varchar2 default hr_api.g_varchar2,
977: p_upr_lmt_calc_rl in number default hr_api.g_number,
978: p_val in number default hr_api.g_number,
979: p_val_ovrid_alwd_flag in varchar2 default hr_api.g_varchar2,
980: p_val_calc_rl in number default hr_api.g_number,
981: p_uom in varchar2 default hr_api.g_varchar2,
982: p_nnmntry_uom in varchar2 default hr_api.g_varchar2,
983: p_bndry_perd_cd in varchar2 default hr_api.g_varchar2,
984: p_bnft_typ_cd in varchar2 default hr_api.g_varchar2,
985: p_cvg_mlt_cd in varchar2 default hr_api.g_varchar2,
978: p_val in number default hr_api.g_number,
979: p_val_ovrid_alwd_flag in varchar2 default hr_api.g_varchar2,
980: p_val_calc_rl in number default hr_api.g_number,
981: p_uom in varchar2 default hr_api.g_varchar2,
982: p_nnmntry_uom in varchar2 default hr_api.g_varchar2,
983: p_bndry_perd_cd in varchar2 default hr_api.g_varchar2,
984: p_bnft_typ_cd in varchar2 default hr_api.g_varchar2,
985: p_cvg_mlt_cd in varchar2 default hr_api.g_varchar2,
986: p_rt_typ_cd in varchar2 default hr_api.g_varchar2,
979: p_val_ovrid_alwd_flag in varchar2 default hr_api.g_varchar2,
980: p_val_calc_rl in number default hr_api.g_number,
981: p_uom in varchar2 default hr_api.g_varchar2,
982: p_nnmntry_uom in varchar2 default hr_api.g_varchar2,
983: p_bndry_perd_cd in varchar2 default hr_api.g_varchar2,
984: p_bnft_typ_cd in varchar2 default hr_api.g_varchar2,
985: p_cvg_mlt_cd in varchar2 default hr_api.g_varchar2,
986: p_rt_typ_cd in varchar2 default hr_api.g_varchar2,
987: p_dflt_val in number default hr_api.g_number,
980: p_val_calc_rl in number default hr_api.g_number,
981: p_uom in varchar2 default hr_api.g_varchar2,
982: p_nnmntry_uom in varchar2 default hr_api.g_varchar2,
983: p_bndry_perd_cd in varchar2 default hr_api.g_varchar2,
984: p_bnft_typ_cd in varchar2 default hr_api.g_varchar2,
985: p_cvg_mlt_cd in varchar2 default hr_api.g_varchar2,
986: p_rt_typ_cd in varchar2 default hr_api.g_varchar2,
987: p_dflt_val in number default hr_api.g_number,
988: p_entr_val_at_enrt_flag in varchar2 default hr_api.g_varchar2,
981: p_uom in varchar2 default hr_api.g_varchar2,
982: p_nnmntry_uom in varchar2 default hr_api.g_varchar2,
983: p_bndry_perd_cd in varchar2 default hr_api.g_varchar2,
984: p_bnft_typ_cd in varchar2 default hr_api.g_varchar2,
985: p_cvg_mlt_cd in varchar2 default hr_api.g_varchar2,
986: p_rt_typ_cd in varchar2 default hr_api.g_varchar2,
987: p_dflt_val in number default hr_api.g_number,
988: p_entr_val_at_enrt_flag in varchar2 default hr_api.g_varchar2,
989: p_dflt_flag in varchar2 default hr_api.g_varchar2,
982: p_nnmntry_uom in varchar2 default hr_api.g_varchar2,
983: p_bndry_perd_cd in varchar2 default hr_api.g_varchar2,
984: p_bnft_typ_cd in varchar2 default hr_api.g_varchar2,
985: p_cvg_mlt_cd in varchar2 default hr_api.g_varchar2,
986: p_rt_typ_cd in varchar2 default hr_api.g_varchar2,
987: p_dflt_val in number default hr_api.g_number,
988: p_entr_val_at_enrt_flag in varchar2 default hr_api.g_varchar2,
989: p_dflt_flag in varchar2 default hr_api.g_varchar2,
990: p_comp_lvl_fctr_id in number default hr_api.g_number,
983: p_bndry_perd_cd in varchar2 default hr_api.g_varchar2,
984: p_bnft_typ_cd in varchar2 default hr_api.g_varchar2,
985: p_cvg_mlt_cd in varchar2 default hr_api.g_varchar2,
986: p_rt_typ_cd in varchar2 default hr_api.g_varchar2,
987: p_dflt_val in number default hr_api.g_number,
988: p_entr_val_at_enrt_flag in varchar2 default hr_api.g_varchar2,
989: p_dflt_flag in varchar2 default hr_api.g_varchar2,
990: p_comp_lvl_fctr_id in number default hr_api.g_number,
991: p_oipl_id in number default hr_api.g_number,
984: p_bnft_typ_cd in varchar2 default hr_api.g_varchar2,
985: p_cvg_mlt_cd in varchar2 default hr_api.g_varchar2,
986: p_rt_typ_cd in varchar2 default hr_api.g_varchar2,
987: p_dflt_val in number default hr_api.g_number,
988: p_entr_val_at_enrt_flag in varchar2 default hr_api.g_varchar2,
989: p_dflt_flag in varchar2 default hr_api.g_varchar2,
990: p_comp_lvl_fctr_id in number default hr_api.g_number,
991: p_oipl_id in number default hr_api.g_number,
992: p_pl_id in number default hr_api.g_number,
985: p_cvg_mlt_cd in varchar2 default hr_api.g_varchar2,
986: p_rt_typ_cd in varchar2 default hr_api.g_varchar2,
987: p_dflt_val in number default hr_api.g_number,
988: p_entr_val_at_enrt_flag in varchar2 default hr_api.g_varchar2,
989: p_dflt_flag in varchar2 default hr_api.g_varchar2,
990: p_comp_lvl_fctr_id in number default hr_api.g_number,
991: p_oipl_id in number default hr_api.g_number,
992: p_pl_id in number default hr_api.g_number,
993: p_plip_id in number default hr_api.g_number,
986: p_rt_typ_cd in varchar2 default hr_api.g_varchar2,
987: p_dflt_val in number default hr_api.g_number,
988: p_entr_val_at_enrt_flag in varchar2 default hr_api.g_varchar2,
989: p_dflt_flag in varchar2 default hr_api.g_varchar2,
990: p_comp_lvl_fctr_id in number default hr_api.g_number,
991: p_oipl_id in number default hr_api.g_number,
992: p_pl_id in number default hr_api.g_number,
993: p_plip_id in number default hr_api.g_number,
994: p_business_group_id in number default hr_api.g_number,
987: p_dflt_val in number default hr_api.g_number,
988: p_entr_val_at_enrt_flag in varchar2 default hr_api.g_varchar2,
989: p_dflt_flag in varchar2 default hr_api.g_varchar2,
990: p_comp_lvl_fctr_id in number default hr_api.g_number,
991: p_oipl_id in number default hr_api.g_number,
992: p_pl_id in number default hr_api.g_number,
993: p_plip_id in number default hr_api.g_number,
994: p_business_group_id in number default hr_api.g_number,
995: p_ccm_attribute_category in varchar2 default hr_api.g_varchar2,
988: p_entr_val_at_enrt_flag in varchar2 default hr_api.g_varchar2,
989: p_dflt_flag in varchar2 default hr_api.g_varchar2,
990: p_comp_lvl_fctr_id in number default hr_api.g_number,
991: p_oipl_id in number default hr_api.g_number,
992: p_pl_id in number default hr_api.g_number,
993: p_plip_id in number default hr_api.g_number,
994: p_business_group_id in number default hr_api.g_number,
995: p_ccm_attribute_category in varchar2 default hr_api.g_varchar2,
996: p_ccm_attribute1 in varchar2 default hr_api.g_varchar2,
989: p_dflt_flag in varchar2 default hr_api.g_varchar2,
990: p_comp_lvl_fctr_id in number default hr_api.g_number,
991: p_oipl_id in number default hr_api.g_number,
992: p_pl_id in number default hr_api.g_number,
993: p_plip_id in number default hr_api.g_number,
994: p_business_group_id in number default hr_api.g_number,
995: p_ccm_attribute_category in varchar2 default hr_api.g_varchar2,
996: p_ccm_attribute1 in varchar2 default hr_api.g_varchar2,
997: p_ccm_attribute2 in varchar2 default hr_api.g_varchar2,
990: p_comp_lvl_fctr_id in number default hr_api.g_number,
991: p_oipl_id in number default hr_api.g_number,
992: p_pl_id in number default hr_api.g_number,
993: p_plip_id in number default hr_api.g_number,
994: p_business_group_id in number default hr_api.g_number,
995: p_ccm_attribute_category in varchar2 default hr_api.g_varchar2,
996: p_ccm_attribute1 in varchar2 default hr_api.g_varchar2,
997: p_ccm_attribute2 in varchar2 default hr_api.g_varchar2,
998: p_ccm_attribute3 in varchar2 default hr_api.g_varchar2,
991: p_oipl_id in number default hr_api.g_number,
992: p_pl_id in number default hr_api.g_number,
993: p_plip_id in number default hr_api.g_number,
994: p_business_group_id in number default hr_api.g_number,
995: p_ccm_attribute_category in varchar2 default hr_api.g_varchar2,
996: p_ccm_attribute1 in varchar2 default hr_api.g_varchar2,
997: p_ccm_attribute2 in varchar2 default hr_api.g_varchar2,
998: p_ccm_attribute3 in varchar2 default hr_api.g_varchar2,
999: p_ccm_attribute4 in varchar2 default hr_api.g_varchar2,
992: p_pl_id in number default hr_api.g_number,
993: p_plip_id in number default hr_api.g_number,
994: p_business_group_id in number default hr_api.g_number,
995: p_ccm_attribute_category in varchar2 default hr_api.g_varchar2,
996: p_ccm_attribute1 in varchar2 default hr_api.g_varchar2,
997: p_ccm_attribute2 in varchar2 default hr_api.g_varchar2,
998: p_ccm_attribute3 in varchar2 default hr_api.g_varchar2,
999: p_ccm_attribute4 in varchar2 default hr_api.g_varchar2,
1000: p_ccm_attribute5 in varchar2 default hr_api.g_varchar2,
993: p_plip_id in number default hr_api.g_number,
994: p_business_group_id in number default hr_api.g_number,
995: p_ccm_attribute_category in varchar2 default hr_api.g_varchar2,
996: p_ccm_attribute1 in varchar2 default hr_api.g_varchar2,
997: p_ccm_attribute2 in varchar2 default hr_api.g_varchar2,
998: p_ccm_attribute3 in varchar2 default hr_api.g_varchar2,
999: p_ccm_attribute4 in varchar2 default hr_api.g_varchar2,
1000: p_ccm_attribute5 in varchar2 default hr_api.g_varchar2,
1001: p_ccm_attribute6 in varchar2 default hr_api.g_varchar2,
994: p_business_group_id in number default hr_api.g_number,
995: p_ccm_attribute_category in varchar2 default hr_api.g_varchar2,
996: p_ccm_attribute1 in varchar2 default hr_api.g_varchar2,
997: p_ccm_attribute2 in varchar2 default hr_api.g_varchar2,
998: p_ccm_attribute3 in varchar2 default hr_api.g_varchar2,
999: p_ccm_attribute4 in varchar2 default hr_api.g_varchar2,
1000: p_ccm_attribute5 in varchar2 default hr_api.g_varchar2,
1001: p_ccm_attribute6 in varchar2 default hr_api.g_varchar2,
1002: p_ccm_attribute7 in varchar2 default hr_api.g_varchar2,
995: p_ccm_attribute_category in varchar2 default hr_api.g_varchar2,
996: p_ccm_attribute1 in varchar2 default hr_api.g_varchar2,
997: p_ccm_attribute2 in varchar2 default hr_api.g_varchar2,
998: p_ccm_attribute3 in varchar2 default hr_api.g_varchar2,
999: p_ccm_attribute4 in varchar2 default hr_api.g_varchar2,
1000: p_ccm_attribute5 in varchar2 default hr_api.g_varchar2,
1001: p_ccm_attribute6 in varchar2 default hr_api.g_varchar2,
1002: p_ccm_attribute7 in varchar2 default hr_api.g_varchar2,
1003: p_ccm_attribute8 in varchar2 default hr_api.g_varchar2,
996: p_ccm_attribute1 in varchar2 default hr_api.g_varchar2,
997: p_ccm_attribute2 in varchar2 default hr_api.g_varchar2,
998: p_ccm_attribute3 in varchar2 default hr_api.g_varchar2,
999: p_ccm_attribute4 in varchar2 default hr_api.g_varchar2,
1000: p_ccm_attribute5 in varchar2 default hr_api.g_varchar2,
1001: p_ccm_attribute6 in varchar2 default hr_api.g_varchar2,
1002: p_ccm_attribute7 in varchar2 default hr_api.g_varchar2,
1003: p_ccm_attribute8 in varchar2 default hr_api.g_varchar2,
1004: p_ccm_attribute9 in varchar2 default hr_api.g_varchar2,
997: p_ccm_attribute2 in varchar2 default hr_api.g_varchar2,
998: p_ccm_attribute3 in varchar2 default hr_api.g_varchar2,
999: p_ccm_attribute4 in varchar2 default hr_api.g_varchar2,
1000: p_ccm_attribute5 in varchar2 default hr_api.g_varchar2,
1001: p_ccm_attribute6 in varchar2 default hr_api.g_varchar2,
1002: p_ccm_attribute7 in varchar2 default hr_api.g_varchar2,
1003: p_ccm_attribute8 in varchar2 default hr_api.g_varchar2,
1004: p_ccm_attribute9 in varchar2 default hr_api.g_varchar2,
1005: p_ccm_attribute10 in varchar2 default hr_api.g_varchar2,
998: p_ccm_attribute3 in varchar2 default hr_api.g_varchar2,
999: p_ccm_attribute4 in varchar2 default hr_api.g_varchar2,
1000: p_ccm_attribute5 in varchar2 default hr_api.g_varchar2,
1001: p_ccm_attribute6 in varchar2 default hr_api.g_varchar2,
1002: p_ccm_attribute7 in varchar2 default hr_api.g_varchar2,
1003: p_ccm_attribute8 in varchar2 default hr_api.g_varchar2,
1004: p_ccm_attribute9 in varchar2 default hr_api.g_varchar2,
1005: p_ccm_attribute10 in varchar2 default hr_api.g_varchar2,
1006: p_ccm_attribute11 in varchar2 default hr_api.g_varchar2,
999: p_ccm_attribute4 in varchar2 default hr_api.g_varchar2,
1000: p_ccm_attribute5 in varchar2 default hr_api.g_varchar2,
1001: p_ccm_attribute6 in varchar2 default hr_api.g_varchar2,
1002: p_ccm_attribute7 in varchar2 default hr_api.g_varchar2,
1003: p_ccm_attribute8 in varchar2 default hr_api.g_varchar2,
1004: p_ccm_attribute9 in varchar2 default hr_api.g_varchar2,
1005: p_ccm_attribute10 in varchar2 default hr_api.g_varchar2,
1006: p_ccm_attribute11 in varchar2 default hr_api.g_varchar2,
1007: p_ccm_attribute12 in varchar2 default hr_api.g_varchar2,
1000: p_ccm_attribute5 in varchar2 default hr_api.g_varchar2,
1001: p_ccm_attribute6 in varchar2 default hr_api.g_varchar2,
1002: p_ccm_attribute7 in varchar2 default hr_api.g_varchar2,
1003: p_ccm_attribute8 in varchar2 default hr_api.g_varchar2,
1004: p_ccm_attribute9 in varchar2 default hr_api.g_varchar2,
1005: p_ccm_attribute10 in varchar2 default hr_api.g_varchar2,
1006: p_ccm_attribute11 in varchar2 default hr_api.g_varchar2,
1007: p_ccm_attribute12 in varchar2 default hr_api.g_varchar2,
1008: p_ccm_attribute13 in varchar2 default hr_api.g_varchar2,
1001: p_ccm_attribute6 in varchar2 default hr_api.g_varchar2,
1002: p_ccm_attribute7 in varchar2 default hr_api.g_varchar2,
1003: p_ccm_attribute8 in varchar2 default hr_api.g_varchar2,
1004: p_ccm_attribute9 in varchar2 default hr_api.g_varchar2,
1005: p_ccm_attribute10 in varchar2 default hr_api.g_varchar2,
1006: p_ccm_attribute11 in varchar2 default hr_api.g_varchar2,
1007: p_ccm_attribute12 in varchar2 default hr_api.g_varchar2,
1008: p_ccm_attribute13 in varchar2 default hr_api.g_varchar2,
1009: p_ccm_attribute14 in varchar2 default hr_api.g_varchar2,
1002: p_ccm_attribute7 in varchar2 default hr_api.g_varchar2,
1003: p_ccm_attribute8 in varchar2 default hr_api.g_varchar2,
1004: p_ccm_attribute9 in varchar2 default hr_api.g_varchar2,
1005: p_ccm_attribute10 in varchar2 default hr_api.g_varchar2,
1006: p_ccm_attribute11 in varchar2 default hr_api.g_varchar2,
1007: p_ccm_attribute12 in varchar2 default hr_api.g_varchar2,
1008: p_ccm_attribute13 in varchar2 default hr_api.g_varchar2,
1009: p_ccm_attribute14 in varchar2 default hr_api.g_varchar2,
1010: p_ccm_attribute15 in varchar2 default hr_api.g_varchar2,
1003: p_ccm_attribute8 in varchar2 default hr_api.g_varchar2,
1004: p_ccm_attribute9 in varchar2 default hr_api.g_varchar2,
1005: p_ccm_attribute10 in varchar2 default hr_api.g_varchar2,
1006: p_ccm_attribute11 in varchar2 default hr_api.g_varchar2,
1007: p_ccm_attribute12 in varchar2 default hr_api.g_varchar2,
1008: p_ccm_attribute13 in varchar2 default hr_api.g_varchar2,
1009: p_ccm_attribute14 in varchar2 default hr_api.g_varchar2,
1010: p_ccm_attribute15 in varchar2 default hr_api.g_varchar2,
1011: p_ccm_attribute16 in varchar2 default hr_api.g_varchar2,
1004: p_ccm_attribute9 in varchar2 default hr_api.g_varchar2,
1005: p_ccm_attribute10 in varchar2 default hr_api.g_varchar2,
1006: p_ccm_attribute11 in varchar2 default hr_api.g_varchar2,
1007: p_ccm_attribute12 in varchar2 default hr_api.g_varchar2,
1008: p_ccm_attribute13 in varchar2 default hr_api.g_varchar2,
1009: p_ccm_attribute14 in varchar2 default hr_api.g_varchar2,
1010: p_ccm_attribute15 in varchar2 default hr_api.g_varchar2,
1011: p_ccm_attribute16 in varchar2 default hr_api.g_varchar2,
1012: p_ccm_attribute17 in varchar2 default hr_api.g_varchar2,
1005: p_ccm_attribute10 in varchar2 default hr_api.g_varchar2,
1006: p_ccm_attribute11 in varchar2 default hr_api.g_varchar2,
1007: p_ccm_attribute12 in varchar2 default hr_api.g_varchar2,
1008: p_ccm_attribute13 in varchar2 default hr_api.g_varchar2,
1009: p_ccm_attribute14 in varchar2 default hr_api.g_varchar2,
1010: p_ccm_attribute15 in varchar2 default hr_api.g_varchar2,
1011: p_ccm_attribute16 in varchar2 default hr_api.g_varchar2,
1012: p_ccm_attribute17 in varchar2 default hr_api.g_varchar2,
1013: p_ccm_attribute18 in varchar2 default hr_api.g_varchar2,
1006: p_ccm_attribute11 in varchar2 default hr_api.g_varchar2,
1007: p_ccm_attribute12 in varchar2 default hr_api.g_varchar2,
1008: p_ccm_attribute13 in varchar2 default hr_api.g_varchar2,
1009: p_ccm_attribute14 in varchar2 default hr_api.g_varchar2,
1010: p_ccm_attribute15 in varchar2 default hr_api.g_varchar2,
1011: p_ccm_attribute16 in varchar2 default hr_api.g_varchar2,
1012: p_ccm_attribute17 in varchar2 default hr_api.g_varchar2,
1013: p_ccm_attribute18 in varchar2 default hr_api.g_varchar2,
1014: p_ccm_attribute19 in varchar2 default hr_api.g_varchar2,
1007: p_ccm_attribute12 in varchar2 default hr_api.g_varchar2,
1008: p_ccm_attribute13 in varchar2 default hr_api.g_varchar2,
1009: p_ccm_attribute14 in varchar2 default hr_api.g_varchar2,
1010: p_ccm_attribute15 in varchar2 default hr_api.g_varchar2,
1011: p_ccm_attribute16 in varchar2 default hr_api.g_varchar2,
1012: p_ccm_attribute17 in varchar2 default hr_api.g_varchar2,
1013: p_ccm_attribute18 in varchar2 default hr_api.g_varchar2,
1014: p_ccm_attribute19 in varchar2 default hr_api.g_varchar2,
1015: p_ccm_attribute20 in varchar2 default hr_api.g_varchar2,
1008: p_ccm_attribute13 in varchar2 default hr_api.g_varchar2,
1009: p_ccm_attribute14 in varchar2 default hr_api.g_varchar2,
1010: p_ccm_attribute15 in varchar2 default hr_api.g_varchar2,
1011: p_ccm_attribute16 in varchar2 default hr_api.g_varchar2,
1012: p_ccm_attribute17 in varchar2 default hr_api.g_varchar2,
1013: p_ccm_attribute18 in varchar2 default hr_api.g_varchar2,
1014: p_ccm_attribute19 in varchar2 default hr_api.g_varchar2,
1015: p_ccm_attribute20 in varchar2 default hr_api.g_varchar2,
1016: p_ccm_attribute21 in varchar2 default hr_api.g_varchar2,
1009: p_ccm_attribute14 in varchar2 default hr_api.g_varchar2,
1010: p_ccm_attribute15 in varchar2 default hr_api.g_varchar2,
1011: p_ccm_attribute16 in varchar2 default hr_api.g_varchar2,
1012: p_ccm_attribute17 in varchar2 default hr_api.g_varchar2,
1013: p_ccm_attribute18 in varchar2 default hr_api.g_varchar2,
1014: p_ccm_attribute19 in varchar2 default hr_api.g_varchar2,
1015: p_ccm_attribute20 in varchar2 default hr_api.g_varchar2,
1016: p_ccm_attribute21 in varchar2 default hr_api.g_varchar2,
1017: p_ccm_attribute22 in varchar2 default hr_api.g_varchar2,
1010: p_ccm_attribute15 in varchar2 default hr_api.g_varchar2,
1011: p_ccm_attribute16 in varchar2 default hr_api.g_varchar2,
1012: p_ccm_attribute17 in varchar2 default hr_api.g_varchar2,
1013: p_ccm_attribute18 in varchar2 default hr_api.g_varchar2,
1014: p_ccm_attribute19 in varchar2 default hr_api.g_varchar2,
1015: p_ccm_attribute20 in varchar2 default hr_api.g_varchar2,
1016: p_ccm_attribute21 in varchar2 default hr_api.g_varchar2,
1017: p_ccm_attribute22 in varchar2 default hr_api.g_varchar2,
1018: p_ccm_attribute23 in varchar2 default hr_api.g_varchar2,
1011: p_ccm_attribute16 in varchar2 default hr_api.g_varchar2,
1012: p_ccm_attribute17 in varchar2 default hr_api.g_varchar2,
1013: p_ccm_attribute18 in varchar2 default hr_api.g_varchar2,
1014: p_ccm_attribute19 in varchar2 default hr_api.g_varchar2,
1015: p_ccm_attribute20 in varchar2 default hr_api.g_varchar2,
1016: p_ccm_attribute21 in varchar2 default hr_api.g_varchar2,
1017: p_ccm_attribute22 in varchar2 default hr_api.g_varchar2,
1018: p_ccm_attribute23 in varchar2 default hr_api.g_varchar2,
1019: p_ccm_attribute24 in varchar2 default hr_api.g_varchar2,
1012: p_ccm_attribute17 in varchar2 default hr_api.g_varchar2,
1013: p_ccm_attribute18 in varchar2 default hr_api.g_varchar2,
1014: p_ccm_attribute19 in varchar2 default hr_api.g_varchar2,
1015: p_ccm_attribute20 in varchar2 default hr_api.g_varchar2,
1016: p_ccm_attribute21 in varchar2 default hr_api.g_varchar2,
1017: p_ccm_attribute22 in varchar2 default hr_api.g_varchar2,
1018: p_ccm_attribute23 in varchar2 default hr_api.g_varchar2,
1019: p_ccm_attribute24 in varchar2 default hr_api.g_varchar2,
1020: p_ccm_attribute25 in varchar2 default hr_api.g_varchar2,
1013: p_ccm_attribute18 in varchar2 default hr_api.g_varchar2,
1014: p_ccm_attribute19 in varchar2 default hr_api.g_varchar2,
1015: p_ccm_attribute20 in varchar2 default hr_api.g_varchar2,
1016: p_ccm_attribute21 in varchar2 default hr_api.g_varchar2,
1017: p_ccm_attribute22 in varchar2 default hr_api.g_varchar2,
1018: p_ccm_attribute23 in varchar2 default hr_api.g_varchar2,
1019: p_ccm_attribute24 in varchar2 default hr_api.g_varchar2,
1020: p_ccm_attribute25 in varchar2 default hr_api.g_varchar2,
1021: p_ccm_attribute26 in varchar2 default hr_api.g_varchar2,
1014: p_ccm_attribute19 in varchar2 default hr_api.g_varchar2,
1015: p_ccm_attribute20 in varchar2 default hr_api.g_varchar2,
1016: p_ccm_attribute21 in varchar2 default hr_api.g_varchar2,
1017: p_ccm_attribute22 in varchar2 default hr_api.g_varchar2,
1018: p_ccm_attribute23 in varchar2 default hr_api.g_varchar2,
1019: p_ccm_attribute24 in varchar2 default hr_api.g_varchar2,
1020: p_ccm_attribute25 in varchar2 default hr_api.g_varchar2,
1021: p_ccm_attribute26 in varchar2 default hr_api.g_varchar2,
1022: p_ccm_attribute27 in varchar2 default hr_api.g_varchar2,
1015: p_ccm_attribute20 in varchar2 default hr_api.g_varchar2,
1016: p_ccm_attribute21 in varchar2 default hr_api.g_varchar2,
1017: p_ccm_attribute22 in varchar2 default hr_api.g_varchar2,
1018: p_ccm_attribute23 in varchar2 default hr_api.g_varchar2,
1019: p_ccm_attribute24 in varchar2 default hr_api.g_varchar2,
1020: p_ccm_attribute25 in varchar2 default hr_api.g_varchar2,
1021: p_ccm_attribute26 in varchar2 default hr_api.g_varchar2,
1022: p_ccm_attribute27 in varchar2 default hr_api.g_varchar2,
1023: p_ccm_attribute28 in varchar2 default hr_api.g_varchar2,
1016: p_ccm_attribute21 in varchar2 default hr_api.g_varchar2,
1017: p_ccm_attribute22 in varchar2 default hr_api.g_varchar2,
1018: p_ccm_attribute23 in varchar2 default hr_api.g_varchar2,
1019: p_ccm_attribute24 in varchar2 default hr_api.g_varchar2,
1020: p_ccm_attribute25 in varchar2 default hr_api.g_varchar2,
1021: p_ccm_attribute26 in varchar2 default hr_api.g_varchar2,
1022: p_ccm_attribute27 in varchar2 default hr_api.g_varchar2,
1023: p_ccm_attribute28 in varchar2 default hr_api.g_varchar2,
1024: p_ccm_attribute29 in varchar2 default hr_api.g_varchar2,
1017: p_ccm_attribute22 in varchar2 default hr_api.g_varchar2,
1018: p_ccm_attribute23 in varchar2 default hr_api.g_varchar2,
1019: p_ccm_attribute24 in varchar2 default hr_api.g_varchar2,
1020: p_ccm_attribute25 in varchar2 default hr_api.g_varchar2,
1021: p_ccm_attribute26 in varchar2 default hr_api.g_varchar2,
1022: p_ccm_attribute27 in varchar2 default hr_api.g_varchar2,
1023: p_ccm_attribute28 in varchar2 default hr_api.g_varchar2,
1024: p_ccm_attribute29 in varchar2 default hr_api.g_varchar2,
1025: p_ccm_attribute30 in varchar2 default hr_api.g_varchar2,
1018: p_ccm_attribute23 in varchar2 default hr_api.g_varchar2,
1019: p_ccm_attribute24 in varchar2 default hr_api.g_varchar2,
1020: p_ccm_attribute25 in varchar2 default hr_api.g_varchar2,
1021: p_ccm_attribute26 in varchar2 default hr_api.g_varchar2,
1022: p_ccm_attribute27 in varchar2 default hr_api.g_varchar2,
1023: p_ccm_attribute28 in varchar2 default hr_api.g_varchar2,
1024: p_ccm_attribute29 in varchar2 default hr_api.g_varchar2,
1025: p_ccm_attribute30 in varchar2 default hr_api.g_varchar2,
1026: p_object_version_number in out nocopy number,
1019: p_ccm_attribute24 in varchar2 default hr_api.g_varchar2,
1020: p_ccm_attribute25 in varchar2 default hr_api.g_varchar2,
1021: p_ccm_attribute26 in varchar2 default hr_api.g_varchar2,
1022: p_ccm_attribute27 in varchar2 default hr_api.g_varchar2,
1023: p_ccm_attribute28 in varchar2 default hr_api.g_varchar2,
1024: p_ccm_attribute29 in varchar2 default hr_api.g_varchar2,
1025: p_ccm_attribute30 in varchar2 default hr_api.g_varchar2,
1026: p_object_version_number in out nocopy number,
1027: p_effective_date in date,
1020: p_ccm_attribute25 in varchar2 default hr_api.g_varchar2,
1021: p_ccm_attribute26 in varchar2 default hr_api.g_varchar2,
1022: p_ccm_attribute27 in varchar2 default hr_api.g_varchar2,
1023: p_ccm_attribute28 in varchar2 default hr_api.g_varchar2,
1024: p_ccm_attribute29 in varchar2 default hr_api.g_varchar2,
1025: p_ccm_attribute30 in varchar2 default hr_api.g_varchar2,
1026: p_object_version_number in out nocopy number,
1027: p_effective_date in date,
1028: p_datetrack_mode in varchar2
1021: p_ccm_attribute26 in varchar2 default hr_api.g_varchar2,
1022: p_ccm_attribute27 in varchar2 default hr_api.g_varchar2,
1023: p_ccm_attribute28 in varchar2 default hr_api.g_varchar2,
1024: p_ccm_attribute29 in varchar2 default hr_api.g_varchar2,
1025: p_ccm_attribute30 in varchar2 default hr_api.g_varchar2,
1026: p_object_version_number in out nocopy number,
1027: p_effective_date in date,
1028: p_datetrack_mode in varchar2
1029: ) is