189: End If;
190: --
191: hr_utility.set_location(' Leaving:'||l_proc, 15);
192: Exception
193: When hr_api.check_integrity_violated Then
194: -- A check constraint has been violated
195: ben_cpp_shd.g_api_dml := false; -- Unset the api dml status
196: ben_cpp_shd.constraint_error
197: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
193: When hr_api.check_integrity_violated Then
194: -- A check constraint has been violated
195: ben_cpp_shd.g_api_dml := false; -- Unset the api dml status
196: ben_cpp_shd.constraint_error
197: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
198: When hr_api.unique_integrity_violated Then
199: -- Unique integrity has been violated
200: ben_cpp_shd.g_api_dml := false; -- Unset the api dml status
201: ben_cpp_shd.constraint_error
194: -- A check constraint has been violated
195: ben_cpp_shd.g_api_dml := false; -- Unset the api dml status
196: ben_cpp_shd.constraint_error
197: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
198: When hr_api.unique_integrity_violated Then
199: -- Unique integrity has been violated
200: ben_cpp_shd.g_api_dml := false; -- Unset the api dml status
201: ben_cpp_shd.constraint_error
202: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
198: When hr_api.unique_integrity_violated Then
199: -- Unique integrity has been violated
200: ben_cpp_shd.g_api_dml := false; -- Unset the api dml status
201: ben_cpp_shd.constraint_error
202: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
203: When Others Then
204: ben_cpp_shd.g_api_dml := false; -- Unset the api dml status
205: Raise;
206: End dt_update_dml;
663: );
664: --
665: exception
666: --
667: when hr_api.cannot_find_prog_unit then
668: --
669: hr_api.cannot_find_prog_unit_error
670: (p_module_name => 'ben_plip_f'
671: ,p_hook_type => 'AU');
665: exception
666: --
667: when hr_api.cannot_find_prog_unit then
668: --
669: hr_api.cannot_find_prog_unit_error
670: (p_module_name => 'ben_plip_f'
671: ,p_hook_type => 'AU');
672: --
673: end;
733: -- p_rec plsql record structure
734: -- to see if a system default is being used. If a system default
735: -- is being used then we must set to the 'current' argument value.
736: --
737: If (p_rec.business_group_id = hr_api.g_number) then
738: p_rec.business_group_id :=
739: ben_cpp_shd.g_old_rec.business_group_id;
740: End If;
741: If (p_rec.pgm_id = hr_api.g_number) then
737: If (p_rec.business_group_id = hr_api.g_number) then
738: p_rec.business_group_id :=
739: ben_cpp_shd.g_old_rec.business_group_id;
740: End If;
741: If (p_rec.pgm_id = hr_api.g_number) then
742: p_rec.pgm_id :=
743: ben_cpp_shd.g_old_rec.pgm_id;
744: End If;
745: If (p_rec.pl_id = hr_api.g_number) then
741: If (p_rec.pgm_id = hr_api.g_number) then
742: p_rec.pgm_id :=
743: ben_cpp_shd.g_old_rec.pgm_id;
744: End If;
745: If (p_rec.pl_id = hr_api.g_number) then
746: p_rec.pl_id :=
747: ben_cpp_shd.g_old_rec.pl_id;
748: End If;
749: If (p_rec.cmbn_plip_id = hr_api.g_number) then
745: If (p_rec.pl_id = hr_api.g_number) then
746: p_rec.pl_id :=
747: ben_cpp_shd.g_old_rec.pl_id;
748: End If;
749: If (p_rec.cmbn_plip_id = hr_api.g_number) then
750: p_rec.cmbn_plip_id :=
751: ben_cpp_shd.g_old_rec.cmbn_plip_id;
752: End If;
753: If (p_rec.dflt_flag = hr_api.g_varchar2) then
749: If (p_rec.cmbn_plip_id = hr_api.g_number) then
750: p_rec.cmbn_plip_id :=
751: ben_cpp_shd.g_old_rec.cmbn_plip_id;
752: End If;
753: If (p_rec.dflt_flag = hr_api.g_varchar2) then
754: p_rec.dflt_flag :=
755: ben_cpp_shd.g_old_rec.dflt_flag;
756: End If;
757: If (p_rec.plip_stat_cd = hr_api.g_varchar2) then
753: If (p_rec.dflt_flag = hr_api.g_varchar2) then
754: p_rec.dflt_flag :=
755: ben_cpp_shd.g_old_rec.dflt_flag;
756: End If;
757: If (p_rec.plip_stat_cd = hr_api.g_varchar2) then
758: p_rec.plip_stat_cd :=
759: ben_cpp_shd.g_old_rec.plip_stat_cd;
760: End If;
761: If (p_rec.dflt_enrt_cd = hr_api.g_varchar2) then
757: If (p_rec.plip_stat_cd = hr_api.g_varchar2) then
758: p_rec.plip_stat_cd :=
759: ben_cpp_shd.g_old_rec.plip_stat_cd;
760: End If;
761: If (p_rec.dflt_enrt_cd = hr_api.g_varchar2) then
762: p_rec.dflt_enrt_cd :=
763: ben_cpp_shd.g_old_rec.dflt_enrt_cd;
764: End If;
765: If (p_rec.dflt_enrt_det_rl = hr_api.g_number) then
761: If (p_rec.dflt_enrt_cd = hr_api.g_varchar2) then
762: p_rec.dflt_enrt_cd :=
763: ben_cpp_shd.g_old_rec.dflt_enrt_cd;
764: End If;
765: If (p_rec.dflt_enrt_det_rl = hr_api.g_number) then
766: p_rec.dflt_enrt_det_rl :=
767: ben_cpp_shd.g_old_rec.dflt_enrt_det_rl;
768: End If;
769: If (p_rec.ordr_num = hr_api.g_number) then
765: If (p_rec.dflt_enrt_det_rl = hr_api.g_number) then
766: p_rec.dflt_enrt_det_rl :=
767: ben_cpp_shd.g_old_rec.dflt_enrt_det_rl;
768: End If;
769: If (p_rec.ordr_num = hr_api.g_number) then
770: p_rec.ordr_num :=
771: ben_cpp_shd.g_old_rec.ordr_num;
772: End If;
773: If (p_rec.alws_unrstrctd_enrt_flag = hr_api.g_varchar2) then
769: If (p_rec.ordr_num = hr_api.g_number) then
770: p_rec.ordr_num :=
771: ben_cpp_shd.g_old_rec.ordr_num;
772: End If;
773: If (p_rec.alws_unrstrctd_enrt_flag = hr_api.g_varchar2) then
774: p_rec.alws_unrstrctd_enrt_flag :=
775: ben_cpp_shd.g_old_rec.alws_unrstrctd_enrt_flag;
776: End If;
777: If (p_rec.auto_enrt_mthd_rl = hr_api.g_number) then
773: If (p_rec.alws_unrstrctd_enrt_flag = hr_api.g_varchar2) then
774: p_rec.alws_unrstrctd_enrt_flag :=
775: ben_cpp_shd.g_old_rec.alws_unrstrctd_enrt_flag;
776: End If;
777: If (p_rec.auto_enrt_mthd_rl = hr_api.g_number) then
778: p_rec.auto_enrt_mthd_rl :=
779: ben_cpp_shd.g_old_rec.auto_enrt_mthd_rl;
780: End If;
781: If (p_rec.enrt_cd = hr_api.g_varchar2) then
777: If (p_rec.auto_enrt_mthd_rl = hr_api.g_number) then
778: p_rec.auto_enrt_mthd_rl :=
779: ben_cpp_shd.g_old_rec.auto_enrt_mthd_rl;
780: End If;
781: If (p_rec.enrt_cd = hr_api.g_varchar2) then
782: p_rec.enrt_cd :=
783: ben_cpp_shd.g_old_rec.enrt_cd;
784: End If;
785: If (p_rec.enrt_mthd_cd = hr_api.g_varchar2) then
781: If (p_rec.enrt_cd = hr_api.g_varchar2) then
782: p_rec.enrt_cd :=
783: ben_cpp_shd.g_old_rec.enrt_cd;
784: End If;
785: If (p_rec.enrt_mthd_cd = hr_api.g_varchar2) then
786: p_rec.enrt_mthd_cd :=
787: ben_cpp_shd.g_old_rec.enrt_mthd_cd;
788: End If;
789: If (p_rec.enrt_rl = hr_api.g_number) then
785: If (p_rec.enrt_mthd_cd = hr_api.g_varchar2) then
786: p_rec.enrt_mthd_cd :=
787: ben_cpp_shd.g_old_rec.enrt_mthd_cd;
788: End If;
789: If (p_rec.enrt_rl = hr_api.g_number) then
790: p_rec.enrt_rl :=
791: ben_cpp_shd.g_old_rec.enrt_rl;
792: End If;
793: If (p_rec.ivr_ident = hr_api.g_varchar2) then
789: If (p_rec.enrt_rl = hr_api.g_number) then
790: p_rec.enrt_rl :=
791: ben_cpp_shd.g_old_rec.enrt_rl;
792: End If;
793: If (p_rec.ivr_ident = hr_api.g_varchar2) then
794: p_rec.ivr_ident :=
795: ben_cpp_shd.g_old_rec.ivr_ident;
796: End If;
797: If (p_rec.url_ref_name = hr_api.g_varchar2) then
793: If (p_rec.ivr_ident = hr_api.g_varchar2) then
794: p_rec.ivr_ident :=
795: ben_cpp_shd.g_old_rec.ivr_ident;
796: End If;
797: If (p_rec.url_ref_name = hr_api.g_varchar2) then
798: p_rec.url_ref_name :=
799: ben_cpp_shd.g_old_rec.url_ref_name;
800: End If;
801: If (p_rec.enrt_cvg_strt_dt_cd = hr_api.g_varchar2) then
797: If (p_rec.url_ref_name = hr_api.g_varchar2) then
798: p_rec.url_ref_name :=
799: ben_cpp_shd.g_old_rec.url_ref_name;
800: End If;
801: If (p_rec.enrt_cvg_strt_dt_cd = hr_api.g_varchar2) then
802: p_rec.enrt_cvg_strt_dt_cd :=
803: ben_cpp_shd.g_old_rec.enrt_cvg_strt_dt_cd;
804: End If;
805: If (p_rec.enrt_cvg_strt_dt_rl = hr_api.g_number) then
801: If (p_rec.enrt_cvg_strt_dt_cd = hr_api.g_varchar2) then
802: p_rec.enrt_cvg_strt_dt_cd :=
803: ben_cpp_shd.g_old_rec.enrt_cvg_strt_dt_cd;
804: End If;
805: If (p_rec.enrt_cvg_strt_dt_rl = hr_api.g_number) then
806: p_rec.enrt_cvg_strt_dt_rl :=
807: ben_cpp_shd.g_old_rec.enrt_cvg_strt_dt_rl;
808: End If;
809: If (p_rec.enrt_cvg_end_dt_cd = hr_api.g_varchar2) then
805: If (p_rec.enrt_cvg_strt_dt_rl = hr_api.g_number) then
806: p_rec.enrt_cvg_strt_dt_rl :=
807: ben_cpp_shd.g_old_rec.enrt_cvg_strt_dt_rl;
808: End If;
809: If (p_rec.enrt_cvg_end_dt_cd = hr_api.g_varchar2) then
810: p_rec.enrt_cvg_end_dt_cd :=
811: ben_cpp_shd.g_old_rec.enrt_cvg_end_dt_cd;
812: End If;
813: If (p_rec.enrt_cvg_end_dt_rl = hr_api.g_number) then
809: If (p_rec.enrt_cvg_end_dt_cd = hr_api.g_varchar2) then
810: p_rec.enrt_cvg_end_dt_cd :=
811: ben_cpp_shd.g_old_rec.enrt_cvg_end_dt_cd;
812: End If;
813: If (p_rec.enrt_cvg_end_dt_rl = hr_api.g_number) then
814: p_rec.enrt_cvg_end_dt_rl :=
815: ben_cpp_shd.g_old_rec.enrt_cvg_end_dt_rl;
816: End If;
817: If (p_rec.rt_strt_dt_cd = hr_api.g_varchar2) then
813: If (p_rec.enrt_cvg_end_dt_rl = hr_api.g_number) then
814: p_rec.enrt_cvg_end_dt_rl :=
815: ben_cpp_shd.g_old_rec.enrt_cvg_end_dt_rl;
816: End If;
817: If (p_rec.rt_strt_dt_cd = hr_api.g_varchar2) then
818: p_rec.rt_strt_dt_cd :=
819: ben_cpp_shd.g_old_rec.rt_strt_dt_cd;
820: End If;
821: If (p_rec.rt_strt_dt_rl = hr_api.g_number) then
817: If (p_rec.rt_strt_dt_cd = hr_api.g_varchar2) then
818: p_rec.rt_strt_dt_cd :=
819: ben_cpp_shd.g_old_rec.rt_strt_dt_cd;
820: End If;
821: If (p_rec.rt_strt_dt_rl = hr_api.g_number) then
822: p_rec.rt_strt_dt_rl :=
823: ben_cpp_shd.g_old_rec.rt_strt_dt_rl;
824: End If;
825: If (p_rec.rt_end_dt_cd = hr_api.g_varchar2) then
821: If (p_rec.rt_strt_dt_rl = hr_api.g_number) then
822: p_rec.rt_strt_dt_rl :=
823: ben_cpp_shd.g_old_rec.rt_strt_dt_rl;
824: End If;
825: If (p_rec.rt_end_dt_cd = hr_api.g_varchar2) then
826: p_rec.rt_end_dt_cd :=
827: ben_cpp_shd.g_old_rec.rt_end_dt_cd;
828: End If;
829: If (p_rec.rt_end_dt_rl = hr_api.g_number) then
825: If (p_rec.rt_end_dt_cd = hr_api.g_varchar2) then
826: p_rec.rt_end_dt_cd :=
827: ben_cpp_shd.g_old_rec.rt_end_dt_cd;
828: End If;
829: If (p_rec.rt_end_dt_rl = hr_api.g_number) then
830: p_rec.rt_end_dt_rl :=
831: ben_cpp_shd.g_old_rec.rt_end_dt_rl;
832: End If;
833: If (p_rec.drvbl_fctr_apls_rts_flag = hr_api.g_varchar2) then
829: If (p_rec.rt_end_dt_rl = hr_api.g_number) then
830: p_rec.rt_end_dt_rl :=
831: ben_cpp_shd.g_old_rec.rt_end_dt_rl;
832: End If;
833: If (p_rec.drvbl_fctr_apls_rts_flag = hr_api.g_varchar2) then
834: p_rec.drvbl_fctr_apls_rts_flag :=
835: ben_cpp_shd.g_old_rec.drvbl_fctr_apls_rts_flag;
836: End If;
837: If (p_rec.drvbl_fctr_prtn_elig_flag = hr_api.g_varchar2) then
833: If (p_rec.drvbl_fctr_apls_rts_flag = hr_api.g_varchar2) then
834: p_rec.drvbl_fctr_apls_rts_flag :=
835: ben_cpp_shd.g_old_rec.drvbl_fctr_apls_rts_flag;
836: End If;
837: If (p_rec.drvbl_fctr_prtn_elig_flag = hr_api.g_varchar2) then
838: p_rec.drvbl_fctr_prtn_elig_flag :=
839: ben_cpp_shd.g_old_rec.drvbl_fctr_prtn_elig_flag;
840: End If;
841: If (p_rec.elig_apls_flag = hr_api.g_varchar2) then
837: If (p_rec.drvbl_fctr_prtn_elig_flag = hr_api.g_varchar2) then
838: p_rec.drvbl_fctr_prtn_elig_flag :=
839: ben_cpp_shd.g_old_rec.drvbl_fctr_prtn_elig_flag;
840: End If;
841: If (p_rec.elig_apls_flag = hr_api.g_varchar2) then
842: p_rec.elig_apls_flag :=
843: ben_cpp_shd.g_old_rec.elig_apls_flag;
844: End If;
845: If (p_rec.prtn_elig_ovrid_alwd_flag = hr_api.g_varchar2) then
841: If (p_rec.elig_apls_flag = hr_api.g_varchar2) then
842: p_rec.elig_apls_flag :=
843: ben_cpp_shd.g_old_rec.elig_apls_flag;
844: End If;
845: If (p_rec.prtn_elig_ovrid_alwd_flag = hr_api.g_varchar2) then
846: p_rec.prtn_elig_ovrid_alwd_flag :=
847: ben_cpp_shd.g_old_rec.prtn_elig_ovrid_alwd_flag;
848: End If;
849: If (p_rec.trk_inelig_per_flag = hr_api.g_varchar2) then
845: If (p_rec.prtn_elig_ovrid_alwd_flag = hr_api.g_varchar2) then
846: p_rec.prtn_elig_ovrid_alwd_flag :=
847: ben_cpp_shd.g_old_rec.prtn_elig_ovrid_alwd_flag;
848: End If;
849: If (p_rec.trk_inelig_per_flag = hr_api.g_varchar2) then
850: p_rec.trk_inelig_per_flag :=
851: ben_cpp_shd.g_old_rec.trk_inelig_per_flag;
852: End If;
853: If (p_rec.postelcn_edit_rl = hr_api.g_number) then
849: If (p_rec.trk_inelig_per_flag = hr_api.g_varchar2) then
850: p_rec.trk_inelig_per_flag :=
851: ben_cpp_shd.g_old_rec.trk_inelig_per_flag;
852: End If;
853: If (p_rec.postelcn_edit_rl = hr_api.g_number) then
854: p_rec.postelcn_edit_rl :=
855: ben_cpp_shd.g_old_rec.postelcn_edit_rl;
856: End If;
857: If (p_rec.dflt_to_asn_pndg_ctfn_cd = hr_api.g_varchar2) then
853: If (p_rec.postelcn_edit_rl = hr_api.g_number) then
854: p_rec.postelcn_edit_rl :=
855: ben_cpp_shd.g_old_rec.postelcn_edit_rl;
856: End If;
857: If (p_rec.dflt_to_asn_pndg_ctfn_cd = hr_api.g_varchar2) then
858: p_rec.dflt_to_asn_pndg_ctfn_cd :=
859: ben_cpp_shd.g_old_rec.dflt_to_asn_pndg_ctfn_cd;
860: End If;
861:
858: p_rec.dflt_to_asn_pndg_ctfn_cd :=
859: ben_cpp_shd.g_old_rec.dflt_to_asn_pndg_ctfn_cd;
860: End If;
861:
862: If (p_rec.dflt_to_asn_pndg_ctfn_rl = hr_api.g_number) then
863: p_rec.dflt_to_asn_pndg_ctfn_rl :=
864: ben_cpp_shd.g_old_rec.dflt_to_asn_pndg_ctfn_rl;
865: End If;
866:
863: p_rec.dflt_to_asn_pndg_ctfn_rl :=
864: ben_cpp_shd.g_old_rec.dflt_to_asn_pndg_ctfn_rl;
865: End If;
866:
867: If (p_rec.mn_cvg_amt = hr_api.g_number) then
868: p_rec.mn_cvg_amt :=
869: ben_cpp_shd.g_old_rec.mn_cvg_amt;
870: End If;
871:
868: p_rec.mn_cvg_amt :=
869: ben_cpp_shd.g_old_rec.mn_cvg_amt;
870: End If;
871:
872: If (p_rec.mn_cvg_rl = hr_api.g_number) then
873: p_rec.mn_cvg_rl :=
874: ben_cpp_shd.g_old_rec.mn_cvg_rl;
875: End If;
876:
873: p_rec.mn_cvg_rl :=
874: ben_cpp_shd.g_old_rec.mn_cvg_rl;
875: End If;
876:
877: If (p_rec.mx_cvg_alwd_amt = hr_api.g_number) then
878: p_rec.mx_cvg_alwd_amt :=
879: ben_cpp_shd.g_old_rec.mx_cvg_alwd_amt;
880: End If;
881:
879: ben_cpp_shd.g_old_rec.mx_cvg_alwd_amt;
880: End If;
881:
882:
883: If (p_rec.mx_cvg_incr_alwd_amt = hr_api.g_number) then
884: p_rec.mx_cvg_incr_alwd_amt :=
885: ben_cpp_shd.g_old_rec.mx_cvg_incr_alwd_amt;
886: End If;
887:
884: p_rec.mx_cvg_incr_alwd_amt :=
885: ben_cpp_shd.g_old_rec.mx_cvg_incr_alwd_amt;
886: End If;
887:
888: If (p_rec.mx_cvg_incr_wcf_alwd_amt = hr_api.g_number) then
889: p_rec.mx_cvg_incr_wcf_alwd_amt :=
890: ben_cpp_shd.g_old_rec.mx_cvg_incr_wcf_alwd_amt;
891: End If;
892:
889: p_rec.mx_cvg_incr_wcf_alwd_amt :=
890: ben_cpp_shd.g_old_rec.mx_cvg_incr_wcf_alwd_amt;
891: End If;
892:
893: If (p_rec.mx_cvg_mlt_incr_num = hr_api.g_number) then
894: p_rec.mx_cvg_mlt_incr_num :=
895: ben_cpp_shd.g_old_rec.mx_cvg_mlt_incr_num;
896: End If;
897:
894: p_rec.mx_cvg_mlt_incr_num :=
895: ben_cpp_shd.g_old_rec.mx_cvg_mlt_incr_num;
896: End If;
897:
898: If (p_rec.mx_cvg_mlt_incr_wcf_num = hr_api.g_number) then
899: p_rec.mx_cvg_mlt_incr_wcf_num :=
900: ben_cpp_shd.g_old_rec.mx_cvg_mlt_incr_wcf_num;
901: End If;
902:
899: p_rec.mx_cvg_mlt_incr_wcf_num :=
900: ben_cpp_shd.g_old_rec.mx_cvg_mlt_incr_wcf_num;
901: End If;
902:
903: If (p_rec.mx_cvg_rl = hr_api.g_number) then
904: p_rec.mx_cvg_rl :=
905: ben_cpp_shd.g_old_rec.mx_cvg_rl;
906: End If;
907:
904: p_rec.mx_cvg_rl :=
905: ben_cpp_shd.g_old_rec.mx_cvg_rl;
906: End If;
907:
908: If (p_rec.mx_cvg_wcfn_amt = hr_api.g_number) then
909: p_rec.mx_cvg_wcfn_amt :=
910: ben_cpp_shd.g_old_rec.mx_cvg_wcfn_amt;
911: End If;
912:
909: p_rec.mx_cvg_wcfn_amt :=
910: ben_cpp_shd.g_old_rec.mx_cvg_wcfn_amt;
911: End If;
912:
913: If (p_rec.mx_cvg_wcfn_mlt_num = hr_api.g_number) then
914: p_rec.mx_cvg_wcfn_mlt_num :=
915: ben_cpp_shd.g_old_rec.mx_cvg_wcfn_mlt_num;
916: End If;
917:
914: p_rec.mx_cvg_wcfn_mlt_num :=
915: ben_cpp_shd.g_old_rec.mx_cvg_wcfn_mlt_num;
916: End If;
917:
918: If (p_rec.no_mn_cvg_amt_apls_flag = hr_api.g_varchar2) then
919: p_rec.no_mn_cvg_amt_apls_flag :=
920: ben_cpp_shd.g_old_rec.no_mn_cvg_amt_apls_flag;
921: End If;
922:
919: p_rec.no_mn_cvg_amt_apls_flag :=
920: ben_cpp_shd.g_old_rec.no_mn_cvg_amt_apls_flag;
921: End If;
922:
923: If (p_rec.no_mn_cvg_incr_apls_flag = hr_api.g_varchar2) then
924: p_rec.no_mn_cvg_incr_apls_flag :=
925: ben_cpp_shd.g_old_rec.no_mn_cvg_incr_apls_flag;
926: End If;
927:
924: p_rec.no_mn_cvg_incr_apls_flag :=
925: ben_cpp_shd.g_old_rec.no_mn_cvg_incr_apls_flag;
926: End If;
927:
928: If (p_rec.no_mx_cvg_amt_apls_flag = hr_api.g_varchar2) then
929: p_rec.no_mx_cvg_amt_apls_flag :=
930: ben_cpp_shd.g_old_rec.no_mx_cvg_amt_apls_flag;
931: End If;
932:
929: p_rec.no_mx_cvg_amt_apls_flag :=
930: ben_cpp_shd.g_old_rec.no_mx_cvg_amt_apls_flag;
931: End If;
932:
933: If (p_rec.no_mx_cvg_incr_apls_flag = hr_api.g_varchar2) then
934: p_rec.no_mx_cvg_incr_apls_flag :=
935: ben_cpp_shd.g_old_rec.no_mx_cvg_incr_apls_flag;
936: End If;
937:
934: p_rec.no_mx_cvg_incr_apls_flag :=
935: ben_cpp_shd.g_old_rec.no_mx_cvg_incr_apls_flag;
936: End If;
937:
938: If (p_rec.unsspnd_enrt_cd = hr_api.g_varchar2) then
939: p_rec.unsspnd_enrt_cd :=
940: ben_cpp_shd.g_old_rec.unsspnd_enrt_cd;
941: End If;
942:
939: p_rec.unsspnd_enrt_cd :=
940: ben_cpp_shd.g_old_rec.unsspnd_enrt_cd;
941: End If;
942:
943: If (p_rec.prort_prtl_yr_cvg_rstrn_cd = hr_api.g_varchar2) then
944: p_rec.prort_prtl_yr_cvg_rstrn_cd :=
945: ben_cpp_shd.g_old_rec.prort_prtl_yr_cvg_rstrn_cd;
946: End If;
947:
944: p_rec.prort_prtl_yr_cvg_rstrn_cd :=
945: ben_cpp_shd.g_old_rec.prort_prtl_yr_cvg_rstrn_cd;
946: End If;
947:
948: If (p_rec.prort_prtl_yr_cvg_rstrn_rl = hr_api.g_number) then
949: p_rec.prort_prtl_yr_cvg_rstrn_rl :=
950: ben_cpp_shd.g_old_rec.prort_prtl_yr_cvg_rstrn_rl;
951: End If;
952:
949: p_rec.prort_prtl_yr_cvg_rstrn_rl :=
950: ben_cpp_shd.g_old_rec.prort_prtl_yr_cvg_rstrn_rl;
951: End If;
952:
953: If (p_rec.cvg_incr_r_decr_only_cd = hr_api.g_varchar2) then
954: p_rec.cvg_incr_r_decr_only_cd :=
955: ben_cpp_shd.g_old_rec.cvg_incr_r_decr_only_cd;
956: End If;
957: If (p_rec.bnft_or_option_rstrctn_cd = hr_api.g_varchar2) then
953: If (p_rec.cvg_incr_r_decr_only_cd = hr_api.g_varchar2) then
954: p_rec.cvg_incr_r_decr_only_cd :=
955: ben_cpp_shd.g_old_rec.cvg_incr_r_decr_only_cd;
956: End If;
957: If (p_rec.bnft_or_option_rstrctn_cd = hr_api.g_varchar2) then
958: p_rec.bnft_or_option_rstrctn_cd :=
959: ben_cpp_shd.g_old_rec.bnft_or_option_rstrctn_cd;
960: End If;
961:
958: p_rec.bnft_or_option_rstrctn_cd :=
959: ben_cpp_shd.g_old_rec.bnft_or_option_rstrctn_cd;
960: End If;
961:
962: If (p_rec.per_cvrd_cd = hr_api.g_varchar2) then
963: p_rec.per_cvrd_cd :=
964: ben_pgm_shd.g_old_rec.per_cvrd_cd;
965: End If;
966:
963: p_rec.per_cvrd_cd :=
964: ben_pgm_shd.g_old_rec.per_cvrd_cd;
965: End If;
966:
967: If (p_rec.short_name = hr_api.g_varchar2) then
968: p_rec.short_name :=
969: ben_pgm_shd.g_old_rec.short_name;
970: End If;
971:
968: p_rec.short_name :=
969: ben_pgm_shd.g_old_rec.short_name;
970: End If;
971:
972: If (p_rec.short_code = hr_api.g_varchar2) then
973: p_rec.short_code :=
974: ben_pgm_shd.g_old_rec.short_code;
975: End If;
976:
973: p_rec.short_code :=
974: ben_pgm_shd.g_old_rec.short_code;
975: End If;
976:
977: If (p_rec.legislation_code = hr_api.g_varchar2) then
978: p_rec.legislation_code :=
979: ben_pgm_shd.g_old_rec.legislation_code;
980: End If;
981: If (p_rec.legislation_subgroup = hr_api.g_varchar2) then
977: If (p_rec.legislation_code = hr_api.g_varchar2) then
978: p_rec.legislation_code :=
979: ben_pgm_shd.g_old_rec.legislation_code;
980: End If;
981: If (p_rec.legislation_subgroup = hr_api.g_varchar2) then
982: p_rec.legislation_subgroup :=
983: ben_pgm_shd.g_old_rec.legislation_subgroup;
984: End If;
985:
982: p_rec.legislation_subgroup :=
983: ben_pgm_shd.g_old_rec.legislation_subgroup;
984: End If;
985:
986: If (p_rec.vrfy_fmly_mmbr_rl = hr_api.g_number) then
987: p_rec.vrfy_fmly_mmbr_rl :=
988: ben_pgm_shd.g_old_rec.vrfy_fmly_mmbr_rl;
989: End If;
990:
987: p_rec.vrfy_fmly_mmbr_rl :=
988: ben_pgm_shd.g_old_rec.vrfy_fmly_mmbr_rl;
989: End If;
990:
991: If (p_rec.vrfy_fmly_mmbr_cd = hr_api.g_varchar2) then
992: p_rec.vrfy_fmly_mmbr_cd :=
993: ben_pgm_shd.g_old_rec.vrfy_fmly_mmbr_cd;
994: End If;
995:
993: ben_pgm_shd.g_old_rec.vrfy_fmly_mmbr_cd;
994: End If;
995:
996:
997: If (p_rec.use_csd_rsd_prccng_cd = hr_api.g_varchar2) then
998: p_rec.use_csd_rsd_prccng_cd :=
999: ben_cpp_shd.g_old_rec.use_csd_rsd_prccng_cd;
1000: End If;
1001:
998: p_rec.use_csd_rsd_prccng_cd :=
999: ben_cpp_shd.g_old_rec.use_csd_rsd_prccng_cd;
1000: End If;
1001:
1002: If (p_rec.cpp_attribute_category = hr_api.g_varchar2) then
1003: p_rec.cpp_attribute_category :=
1004: ben_cpp_shd.g_old_rec.cpp_attribute_category;
1005: End If;
1006: If (p_rec.cpp_attribute1 = hr_api.g_varchar2) then
1002: If (p_rec.cpp_attribute_category = hr_api.g_varchar2) then
1003: p_rec.cpp_attribute_category :=
1004: ben_cpp_shd.g_old_rec.cpp_attribute_category;
1005: End If;
1006: If (p_rec.cpp_attribute1 = hr_api.g_varchar2) then
1007: p_rec.cpp_attribute1 :=
1008: ben_cpp_shd.g_old_rec.cpp_attribute1;
1009: End If;
1010: If (p_rec.cpp_attribute2 = hr_api.g_varchar2) then
1006: If (p_rec.cpp_attribute1 = hr_api.g_varchar2) then
1007: p_rec.cpp_attribute1 :=
1008: ben_cpp_shd.g_old_rec.cpp_attribute1;
1009: End If;
1010: If (p_rec.cpp_attribute2 = hr_api.g_varchar2) then
1011: p_rec.cpp_attribute2 :=
1012: ben_cpp_shd.g_old_rec.cpp_attribute2;
1013: End If;
1014: If (p_rec.cpp_attribute3 = hr_api.g_varchar2) then
1010: If (p_rec.cpp_attribute2 = hr_api.g_varchar2) then
1011: p_rec.cpp_attribute2 :=
1012: ben_cpp_shd.g_old_rec.cpp_attribute2;
1013: End If;
1014: If (p_rec.cpp_attribute3 = hr_api.g_varchar2) then
1015: p_rec.cpp_attribute3 :=
1016: ben_cpp_shd.g_old_rec.cpp_attribute3;
1017: End If;
1018: If (p_rec.cpp_attribute4 = hr_api.g_varchar2) then
1014: If (p_rec.cpp_attribute3 = hr_api.g_varchar2) then
1015: p_rec.cpp_attribute3 :=
1016: ben_cpp_shd.g_old_rec.cpp_attribute3;
1017: End If;
1018: If (p_rec.cpp_attribute4 = hr_api.g_varchar2) then
1019: p_rec.cpp_attribute4 :=
1020: ben_cpp_shd.g_old_rec.cpp_attribute4;
1021: End If;
1022: If (p_rec.cpp_attribute5 = hr_api.g_varchar2) then
1018: If (p_rec.cpp_attribute4 = hr_api.g_varchar2) then
1019: p_rec.cpp_attribute4 :=
1020: ben_cpp_shd.g_old_rec.cpp_attribute4;
1021: End If;
1022: If (p_rec.cpp_attribute5 = hr_api.g_varchar2) then
1023: p_rec.cpp_attribute5 :=
1024: ben_cpp_shd.g_old_rec.cpp_attribute5;
1025: End If;
1026: If (p_rec.cpp_attribute6 = hr_api.g_varchar2) then
1022: If (p_rec.cpp_attribute5 = hr_api.g_varchar2) then
1023: p_rec.cpp_attribute5 :=
1024: ben_cpp_shd.g_old_rec.cpp_attribute5;
1025: End If;
1026: If (p_rec.cpp_attribute6 = hr_api.g_varchar2) then
1027: p_rec.cpp_attribute6 :=
1028: ben_cpp_shd.g_old_rec.cpp_attribute6;
1029: End If;
1030: If (p_rec.cpp_attribute7 = hr_api.g_varchar2) then
1026: If (p_rec.cpp_attribute6 = hr_api.g_varchar2) then
1027: p_rec.cpp_attribute6 :=
1028: ben_cpp_shd.g_old_rec.cpp_attribute6;
1029: End If;
1030: If (p_rec.cpp_attribute7 = hr_api.g_varchar2) then
1031: p_rec.cpp_attribute7 :=
1032: ben_cpp_shd.g_old_rec.cpp_attribute7;
1033: End If;
1034: If (p_rec.cpp_attribute8 = hr_api.g_varchar2) then
1030: If (p_rec.cpp_attribute7 = hr_api.g_varchar2) then
1031: p_rec.cpp_attribute7 :=
1032: ben_cpp_shd.g_old_rec.cpp_attribute7;
1033: End If;
1034: If (p_rec.cpp_attribute8 = hr_api.g_varchar2) then
1035: p_rec.cpp_attribute8 :=
1036: ben_cpp_shd.g_old_rec.cpp_attribute8;
1037: End If;
1038: If (p_rec.cpp_attribute9 = hr_api.g_varchar2) then
1034: If (p_rec.cpp_attribute8 = hr_api.g_varchar2) then
1035: p_rec.cpp_attribute8 :=
1036: ben_cpp_shd.g_old_rec.cpp_attribute8;
1037: End If;
1038: If (p_rec.cpp_attribute9 = hr_api.g_varchar2) then
1039: p_rec.cpp_attribute9 :=
1040: ben_cpp_shd.g_old_rec.cpp_attribute9;
1041: End If;
1042: If (p_rec.cpp_attribute10 = hr_api.g_varchar2) then
1038: If (p_rec.cpp_attribute9 = hr_api.g_varchar2) then
1039: p_rec.cpp_attribute9 :=
1040: ben_cpp_shd.g_old_rec.cpp_attribute9;
1041: End If;
1042: If (p_rec.cpp_attribute10 = hr_api.g_varchar2) then
1043: p_rec.cpp_attribute10 :=
1044: ben_cpp_shd.g_old_rec.cpp_attribute10;
1045: End If;
1046: If (p_rec.cpp_attribute11 = hr_api.g_varchar2) then
1042: If (p_rec.cpp_attribute10 = hr_api.g_varchar2) then
1043: p_rec.cpp_attribute10 :=
1044: ben_cpp_shd.g_old_rec.cpp_attribute10;
1045: End If;
1046: If (p_rec.cpp_attribute11 = hr_api.g_varchar2) then
1047: p_rec.cpp_attribute11 :=
1048: ben_cpp_shd.g_old_rec.cpp_attribute11;
1049: End If;
1050: If (p_rec.cpp_attribute12 = hr_api.g_varchar2) then
1046: If (p_rec.cpp_attribute11 = hr_api.g_varchar2) then
1047: p_rec.cpp_attribute11 :=
1048: ben_cpp_shd.g_old_rec.cpp_attribute11;
1049: End If;
1050: If (p_rec.cpp_attribute12 = hr_api.g_varchar2) then
1051: p_rec.cpp_attribute12 :=
1052: ben_cpp_shd.g_old_rec.cpp_attribute12;
1053: End If;
1054: If (p_rec.cpp_attribute13 = hr_api.g_varchar2) then
1050: If (p_rec.cpp_attribute12 = hr_api.g_varchar2) then
1051: p_rec.cpp_attribute12 :=
1052: ben_cpp_shd.g_old_rec.cpp_attribute12;
1053: End If;
1054: If (p_rec.cpp_attribute13 = hr_api.g_varchar2) then
1055: p_rec.cpp_attribute13 :=
1056: ben_cpp_shd.g_old_rec.cpp_attribute13;
1057: End If;
1058: If (p_rec.cpp_attribute14 = hr_api.g_varchar2) then
1054: If (p_rec.cpp_attribute13 = hr_api.g_varchar2) then
1055: p_rec.cpp_attribute13 :=
1056: ben_cpp_shd.g_old_rec.cpp_attribute13;
1057: End If;
1058: If (p_rec.cpp_attribute14 = hr_api.g_varchar2) then
1059: p_rec.cpp_attribute14 :=
1060: ben_cpp_shd.g_old_rec.cpp_attribute14;
1061: End If;
1062: If (p_rec.cpp_attribute15 = hr_api.g_varchar2) then
1058: If (p_rec.cpp_attribute14 = hr_api.g_varchar2) then
1059: p_rec.cpp_attribute14 :=
1060: ben_cpp_shd.g_old_rec.cpp_attribute14;
1061: End If;
1062: If (p_rec.cpp_attribute15 = hr_api.g_varchar2) then
1063: p_rec.cpp_attribute15 :=
1064: ben_cpp_shd.g_old_rec.cpp_attribute15;
1065: End If;
1066: If (p_rec.cpp_attribute16 = hr_api.g_varchar2) then
1062: If (p_rec.cpp_attribute15 = hr_api.g_varchar2) then
1063: p_rec.cpp_attribute15 :=
1064: ben_cpp_shd.g_old_rec.cpp_attribute15;
1065: End If;
1066: If (p_rec.cpp_attribute16 = hr_api.g_varchar2) then
1067: p_rec.cpp_attribute16 :=
1068: ben_cpp_shd.g_old_rec.cpp_attribute16;
1069: End If;
1070: If (p_rec.cpp_attribute17 = hr_api.g_varchar2) then
1066: If (p_rec.cpp_attribute16 = hr_api.g_varchar2) then
1067: p_rec.cpp_attribute16 :=
1068: ben_cpp_shd.g_old_rec.cpp_attribute16;
1069: End If;
1070: If (p_rec.cpp_attribute17 = hr_api.g_varchar2) then
1071: p_rec.cpp_attribute17 :=
1072: ben_cpp_shd.g_old_rec.cpp_attribute17;
1073: End If;
1074: If (p_rec.cpp_attribute18 = hr_api.g_varchar2) then
1070: If (p_rec.cpp_attribute17 = hr_api.g_varchar2) then
1071: p_rec.cpp_attribute17 :=
1072: ben_cpp_shd.g_old_rec.cpp_attribute17;
1073: End If;
1074: If (p_rec.cpp_attribute18 = hr_api.g_varchar2) then
1075: p_rec.cpp_attribute18 :=
1076: ben_cpp_shd.g_old_rec.cpp_attribute18;
1077: End If;
1078: If (p_rec.cpp_attribute19 = hr_api.g_varchar2) then
1074: If (p_rec.cpp_attribute18 = hr_api.g_varchar2) then
1075: p_rec.cpp_attribute18 :=
1076: ben_cpp_shd.g_old_rec.cpp_attribute18;
1077: End If;
1078: If (p_rec.cpp_attribute19 = hr_api.g_varchar2) then
1079: p_rec.cpp_attribute19 :=
1080: ben_cpp_shd.g_old_rec.cpp_attribute19;
1081: End If;
1082: If (p_rec.cpp_attribute20 = hr_api.g_varchar2) then
1078: If (p_rec.cpp_attribute19 = hr_api.g_varchar2) then
1079: p_rec.cpp_attribute19 :=
1080: ben_cpp_shd.g_old_rec.cpp_attribute19;
1081: End If;
1082: If (p_rec.cpp_attribute20 = hr_api.g_varchar2) then
1083: p_rec.cpp_attribute20 :=
1084: ben_cpp_shd.g_old_rec.cpp_attribute20;
1085: End If;
1086: If (p_rec.cpp_attribute21 = hr_api.g_varchar2) then
1082: If (p_rec.cpp_attribute20 = hr_api.g_varchar2) then
1083: p_rec.cpp_attribute20 :=
1084: ben_cpp_shd.g_old_rec.cpp_attribute20;
1085: End If;
1086: If (p_rec.cpp_attribute21 = hr_api.g_varchar2) then
1087: p_rec.cpp_attribute21 :=
1088: ben_cpp_shd.g_old_rec.cpp_attribute21;
1089: End If;
1090: If (p_rec.cpp_attribute22 = hr_api.g_varchar2) then
1086: If (p_rec.cpp_attribute21 = hr_api.g_varchar2) then
1087: p_rec.cpp_attribute21 :=
1088: ben_cpp_shd.g_old_rec.cpp_attribute21;
1089: End If;
1090: If (p_rec.cpp_attribute22 = hr_api.g_varchar2) then
1091: p_rec.cpp_attribute22 :=
1092: ben_cpp_shd.g_old_rec.cpp_attribute22;
1093: End If;
1094: If (p_rec.cpp_attribute23 = hr_api.g_varchar2) then
1090: If (p_rec.cpp_attribute22 = hr_api.g_varchar2) then
1091: p_rec.cpp_attribute22 :=
1092: ben_cpp_shd.g_old_rec.cpp_attribute22;
1093: End If;
1094: If (p_rec.cpp_attribute23 = hr_api.g_varchar2) then
1095: p_rec.cpp_attribute23 :=
1096: ben_cpp_shd.g_old_rec.cpp_attribute23;
1097: End If;
1098: If (p_rec.cpp_attribute24 = hr_api.g_varchar2) then
1094: If (p_rec.cpp_attribute23 = hr_api.g_varchar2) then
1095: p_rec.cpp_attribute23 :=
1096: ben_cpp_shd.g_old_rec.cpp_attribute23;
1097: End If;
1098: If (p_rec.cpp_attribute24 = hr_api.g_varchar2) then
1099: p_rec.cpp_attribute24 :=
1100: ben_cpp_shd.g_old_rec.cpp_attribute24;
1101: End If;
1102: If (p_rec.cpp_attribute25 = hr_api.g_varchar2) then
1098: If (p_rec.cpp_attribute24 = hr_api.g_varchar2) then
1099: p_rec.cpp_attribute24 :=
1100: ben_cpp_shd.g_old_rec.cpp_attribute24;
1101: End If;
1102: If (p_rec.cpp_attribute25 = hr_api.g_varchar2) then
1103: p_rec.cpp_attribute25 :=
1104: ben_cpp_shd.g_old_rec.cpp_attribute25;
1105: End If;
1106: If (p_rec.cpp_attribute26 = hr_api.g_varchar2) then
1102: If (p_rec.cpp_attribute25 = hr_api.g_varchar2) then
1103: p_rec.cpp_attribute25 :=
1104: ben_cpp_shd.g_old_rec.cpp_attribute25;
1105: End If;
1106: If (p_rec.cpp_attribute26 = hr_api.g_varchar2) then
1107: p_rec.cpp_attribute26 :=
1108: ben_cpp_shd.g_old_rec.cpp_attribute26;
1109: End If;
1110: If (p_rec.cpp_attribute27 = hr_api.g_varchar2) then
1106: If (p_rec.cpp_attribute26 = hr_api.g_varchar2) then
1107: p_rec.cpp_attribute26 :=
1108: ben_cpp_shd.g_old_rec.cpp_attribute26;
1109: End If;
1110: If (p_rec.cpp_attribute27 = hr_api.g_varchar2) then
1111: p_rec.cpp_attribute27 :=
1112: ben_cpp_shd.g_old_rec.cpp_attribute27;
1113: End If;
1114: If (p_rec.cpp_attribute28 = hr_api.g_varchar2) then
1110: If (p_rec.cpp_attribute27 = hr_api.g_varchar2) then
1111: p_rec.cpp_attribute27 :=
1112: ben_cpp_shd.g_old_rec.cpp_attribute27;
1113: End If;
1114: If (p_rec.cpp_attribute28 = hr_api.g_varchar2) then
1115: p_rec.cpp_attribute28 :=
1116: ben_cpp_shd.g_old_rec.cpp_attribute28;
1117: End If;
1118: If (p_rec.cpp_attribute29 = hr_api.g_varchar2) then
1114: If (p_rec.cpp_attribute28 = hr_api.g_varchar2) then
1115: p_rec.cpp_attribute28 :=
1116: ben_cpp_shd.g_old_rec.cpp_attribute28;
1117: End If;
1118: If (p_rec.cpp_attribute29 = hr_api.g_varchar2) then
1119: p_rec.cpp_attribute29 :=
1120: ben_cpp_shd.g_old_rec.cpp_attribute29;
1121: End If;
1122: If (p_rec.cpp_attribute30 = hr_api.g_varchar2) then
1118: If (p_rec.cpp_attribute29 = hr_api.g_varchar2) then
1119: p_rec.cpp_attribute29 :=
1120: ben_cpp_shd.g_old_rec.cpp_attribute29;
1121: End If;
1122: If (p_rec.cpp_attribute30 = hr_api.g_varchar2) then
1123: p_rec.cpp_attribute30 :=
1124: ben_cpp_shd.g_old_rec.cpp_attribute30;
1125: End If;
1126: