152: --
153: hr_utility.set_location(' Leaving:'||l_proc, 10);
154: --
155: Exception
156: When hr_api.check_integrity_violated Then
157: -- A check constraint has been violated
158: ben_enp_shd.g_api_dml := false; -- Unset the api dml status
159: ben_enp_shd.constraint_error
160: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
156: When hr_api.check_integrity_violated Then
157: -- A check constraint has been violated
158: ben_enp_shd.g_api_dml := false; -- Unset the api dml status
159: ben_enp_shd.constraint_error
160: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
161: When hr_api.parent_integrity_violated Then
162: -- Parent integrity has been violated
163: ben_enp_shd.g_api_dml := false; -- Unset the api dml status
164: ben_enp_shd.constraint_error
157: -- A check constraint has been violated
158: ben_enp_shd.g_api_dml := false; -- Unset the api dml status
159: ben_enp_shd.constraint_error
160: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
161: When hr_api.parent_integrity_violated Then
162: -- Parent integrity has been violated
163: ben_enp_shd.g_api_dml := false; -- Unset the api dml status
164: ben_enp_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
161: When hr_api.parent_integrity_violated Then
162: -- Parent integrity has been violated
163: ben_enp_shd.g_api_dml := false; -- Unset the api dml status
164: ben_enp_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When hr_api.unique_integrity_violated Then
167: -- Unique integrity has been violated
168: ben_enp_shd.g_api_dml := false; -- Unset the api dml status
169: ben_enp_shd.constraint_error
162: -- Parent integrity has been violated
163: ben_enp_shd.g_api_dml := false; -- Unset the api dml status
164: ben_enp_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When hr_api.unique_integrity_violated Then
167: -- Unique integrity has been violated
168: ben_enp_shd.g_api_dml := false; -- Unset the api dml status
169: ben_enp_shd.constraint_error
170: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When hr_api.unique_integrity_violated Then
167: -- Unique integrity has been violated
168: ben_enp_shd.g_api_dml := false; -- Unset the api dml status
169: ben_enp_shd.constraint_error
170: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
171: When Others Then
172: ben_enp_shd.g_api_dml := false; -- Unset the api dml status
173: Raise;
174: End update_dml;
423: );
424: --
425: exception
426: --
427: when hr_api.cannot_find_prog_unit then
428: --
429: hr_api.cannot_find_prog_unit_error
430: (p_module_name => 'ben_enrt_perd'
431: ,p_hook_type => 'AU');
425: exception
426: --
427: when hr_api.cannot_find_prog_unit then
428: --
429: hr_api.cannot_find_prog_unit_error
430: (p_module_name => 'ben_enrt_perd'
431: ,p_hook_type => 'AU');
432: --
433: end;
493: -- p_rec plsql record structure
494: -- to see if a system default is being used. If a system default
495: -- is being used then we must set to the 'current' argument value.
496: --
497: If (p_rec.business_group_id = hr_api.g_number) then
498: p_rec.business_group_id :=
499: ben_enp_shd.g_old_rec.business_group_id;
500: End If;
501: If (p_rec.yr_perd_id = hr_api.g_number) then
497: If (p_rec.business_group_id = hr_api.g_number) then
498: p_rec.business_group_id :=
499: ben_enp_shd.g_old_rec.business_group_id;
500: End If;
501: If (p_rec.yr_perd_id = hr_api.g_number) then
502: p_rec.yr_perd_id :=
503: ben_enp_shd.g_old_rec.yr_perd_id;
504: End If;
505: If (p_rec.popl_enrt_typ_cycl_id = hr_api.g_number) then
501: If (p_rec.yr_perd_id = hr_api.g_number) then
502: p_rec.yr_perd_id :=
503: ben_enp_shd.g_old_rec.yr_perd_id;
504: End If;
505: If (p_rec.popl_enrt_typ_cycl_id = hr_api.g_number) then
506: p_rec.popl_enrt_typ_cycl_id :=
507: ben_enp_shd.g_old_rec.popl_enrt_typ_cycl_id;
508: End If;
509: If (p_rec.end_dt = hr_api.g_date) then
505: If (p_rec.popl_enrt_typ_cycl_id = hr_api.g_number) then
506: p_rec.popl_enrt_typ_cycl_id :=
507: ben_enp_shd.g_old_rec.popl_enrt_typ_cycl_id;
508: End If;
509: If (p_rec.end_dt = hr_api.g_date) then
510: p_rec.end_dt :=
511: ben_enp_shd.g_old_rec.end_dt;
512: End If;
513: If (p_rec.strt_dt = hr_api.g_date) then
509: If (p_rec.end_dt = hr_api.g_date) then
510: p_rec.end_dt :=
511: ben_enp_shd.g_old_rec.end_dt;
512: End If;
513: If (p_rec.strt_dt = hr_api.g_date) then
514: p_rec.strt_dt :=
515: ben_enp_shd.g_old_rec.strt_dt;
516: End If;
517: If (p_rec.asnd_lf_evt_dt = hr_api.g_date) then
513: If (p_rec.strt_dt = hr_api.g_date) then
514: p_rec.strt_dt :=
515: ben_enp_shd.g_old_rec.strt_dt;
516: End If;
517: If (p_rec.asnd_lf_evt_dt = hr_api.g_date) then
518: p_rec.asnd_lf_evt_dt :=
519: ben_enp_shd.g_old_rec.asnd_lf_evt_dt;
520: End If;
521: If (p_rec.cls_enrt_dt_to_use_cd = hr_api.g_varchar2) then
517: If (p_rec.asnd_lf_evt_dt = hr_api.g_date) then
518: p_rec.asnd_lf_evt_dt :=
519: ben_enp_shd.g_old_rec.asnd_lf_evt_dt;
520: End If;
521: If (p_rec.cls_enrt_dt_to_use_cd = hr_api.g_varchar2) then
522: p_rec.cls_enrt_dt_to_use_cd :=
523: ben_enp_shd.g_old_rec.cls_enrt_dt_to_use_cd;
524: End If;
525: If (p_rec.dflt_enrt_dt = hr_api.g_date) then
521: If (p_rec.cls_enrt_dt_to_use_cd = hr_api.g_varchar2) then
522: p_rec.cls_enrt_dt_to_use_cd :=
523: ben_enp_shd.g_old_rec.cls_enrt_dt_to_use_cd;
524: End If;
525: If (p_rec.dflt_enrt_dt = hr_api.g_date) then
526: p_rec.dflt_enrt_dt :=
527: ben_enp_shd.g_old_rec.dflt_enrt_dt;
528: End If;
529: If (p_rec.enrt_cvg_strt_dt_cd = hr_api.g_varchar2) then
525: If (p_rec.dflt_enrt_dt = hr_api.g_date) then
526: p_rec.dflt_enrt_dt :=
527: ben_enp_shd.g_old_rec.dflt_enrt_dt;
528: End If;
529: If (p_rec.enrt_cvg_strt_dt_cd = hr_api.g_varchar2) then
530: p_rec.enrt_cvg_strt_dt_cd :=
531: ben_enp_shd.g_old_rec.enrt_cvg_strt_dt_cd;
532: End If;
533: If (p_rec.rt_strt_dt_rl = hr_api.g_number) then
529: If (p_rec.enrt_cvg_strt_dt_cd = hr_api.g_varchar2) then
530: p_rec.enrt_cvg_strt_dt_cd :=
531: ben_enp_shd.g_old_rec.enrt_cvg_strt_dt_cd;
532: End If;
533: If (p_rec.rt_strt_dt_rl = hr_api.g_number) then
534: p_rec.rt_strt_dt_rl :=
535: ben_enp_shd.g_old_rec.rt_strt_dt_rl;
536: End If;
537: If (p_rec.enrt_cvg_end_dt_cd = hr_api.g_varchar2) then
533: If (p_rec.rt_strt_dt_rl = hr_api.g_number) then
534: p_rec.rt_strt_dt_rl :=
535: ben_enp_shd.g_old_rec.rt_strt_dt_rl;
536: End If;
537: If (p_rec.enrt_cvg_end_dt_cd = hr_api.g_varchar2) then
538: p_rec.enrt_cvg_end_dt_cd :=
539: ben_enp_shd.g_old_rec.enrt_cvg_end_dt_cd;
540: End If;
541: If (p_rec.enrt_cvg_strt_dt_rl = hr_api.g_number) then
537: If (p_rec.enrt_cvg_end_dt_cd = hr_api.g_varchar2) then
538: p_rec.enrt_cvg_end_dt_cd :=
539: ben_enp_shd.g_old_rec.enrt_cvg_end_dt_cd;
540: End If;
541: If (p_rec.enrt_cvg_strt_dt_rl = hr_api.g_number) then
542: p_rec.enrt_cvg_strt_dt_rl :=
543: ben_enp_shd.g_old_rec.enrt_cvg_strt_dt_rl;
544: End If;
545: If (p_rec.enrt_cvg_end_dt_rl = hr_api.g_number) then
541: If (p_rec.enrt_cvg_strt_dt_rl = hr_api.g_number) then
542: p_rec.enrt_cvg_strt_dt_rl :=
543: ben_enp_shd.g_old_rec.enrt_cvg_strt_dt_rl;
544: End If;
545: If (p_rec.enrt_cvg_end_dt_rl = hr_api.g_number) then
546: p_rec.enrt_cvg_end_dt_rl :=
547: ben_enp_shd.g_old_rec.enrt_cvg_end_dt_rl;
548: End If;
549: If (p_rec.procg_end_dt = hr_api.g_date) then
545: If (p_rec.enrt_cvg_end_dt_rl = hr_api.g_number) then
546: p_rec.enrt_cvg_end_dt_rl :=
547: ben_enp_shd.g_old_rec.enrt_cvg_end_dt_rl;
548: End If;
549: If (p_rec.procg_end_dt = hr_api.g_date) then
550: p_rec.procg_end_dt :=
551: ben_enp_shd.g_old_rec.procg_end_dt;
552: End If;
553: If (p_rec.rt_strt_dt_cd = hr_api.g_varchar2) then
549: If (p_rec.procg_end_dt = hr_api.g_date) then
550: p_rec.procg_end_dt :=
551: ben_enp_shd.g_old_rec.procg_end_dt;
552: End If;
553: If (p_rec.rt_strt_dt_cd = hr_api.g_varchar2) then
554: p_rec.rt_strt_dt_cd :=
555: ben_enp_shd.g_old_rec.rt_strt_dt_cd;
556: End If;
557: If (p_rec.rt_end_dt_cd = hr_api.g_varchar2) then
553: If (p_rec.rt_strt_dt_cd = hr_api.g_varchar2) then
554: p_rec.rt_strt_dt_cd :=
555: ben_enp_shd.g_old_rec.rt_strt_dt_cd;
556: End If;
557: If (p_rec.rt_end_dt_cd = hr_api.g_varchar2) then
558: p_rec.rt_end_dt_cd :=
559: ben_enp_shd.g_old_rec.rt_end_dt_cd;
560: End If;
561: If (p_rec.rt_end_dt_rl = hr_api.g_number) then
557: If (p_rec.rt_end_dt_cd = hr_api.g_varchar2) then
558: p_rec.rt_end_dt_cd :=
559: ben_enp_shd.g_old_rec.rt_end_dt_cd;
560: End If;
561: If (p_rec.rt_end_dt_rl = hr_api.g_number) then
562: p_rec.rt_end_dt_rl :=
563: ben_enp_shd.g_old_rec.rt_end_dt_rl;
564: End If;
565: -- CompWorkBench Additions
562: p_rec.rt_end_dt_rl :=
563: ben_enp_shd.g_old_rec.rt_end_dt_rl;
564: End If;
565: -- CompWorkBench Additions
566: If (p_rec.bdgt_upd_strt_dt = hr_api.g_date) then
567: p_rec.bdgt_upd_strt_dt :=
568: ben_enp_shd.g_old_rec.bdgt_upd_strt_dt;
569: End If;
570: If (p_rec.bdgt_upd_end_dt= hr_api.g_date) then
566: If (p_rec.bdgt_upd_strt_dt = hr_api.g_date) then
567: p_rec.bdgt_upd_strt_dt :=
568: ben_enp_shd.g_old_rec.bdgt_upd_strt_dt;
569: End If;
570: If (p_rec.bdgt_upd_end_dt= hr_api.g_date) then
571: p_rec.bdgt_upd_end_dt :=
572: ben_enp_shd.g_old_rec.bdgt_upd_end_dt;
573: End If;
574: If (p_rec.ws_upd_strt_dt= hr_api.g_date) then
570: If (p_rec.bdgt_upd_end_dt= hr_api.g_date) then
571: p_rec.bdgt_upd_end_dt :=
572: ben_enp_shd.g_old_rec.bdgt_upd_end_dt;
573: End If;
574: If (p_rec.ws_upd_strt_dt= hr_api.g_date) then
575: p_rec.ws_upd_strt_dt :=
576: ben_enp_shd.g_old_rec.ws_upd_strt_dt;
577: End If;
578: If (p_rec.ws_upd_end_dt = hr_api.g_date) then
574: If (p_rec.ws_upd_strt_dt= hr_api.g_date) then
575: p_rec.ws_upd_strt_dt :=
576: ben_enp_shd.g_old_rec.ws_upd_strt_dt;
577: End If;
578: If (p_rec.ws_upd_end_dt = hr_api.g_date) then
579: p_rec.ws_upd_end_dt :=
580: ben_enp_shd.g_old_rec.ws_upd_end_dt;
581: End If;
582: If (p_rec.dflt_ws_acc_cd= hr_api.g_varchar2) then
578: If (p_rec.ws_upd_end_dt = hr_api.g_date) then
579: p_rec.ws_upd_end_dt :=
580: ben_enp_shd.g_old_rec.ws_upd_end_dt;
581: End If;
582: If (p_rec.dflt_ws_acc_cd= hr_api.g_varchar2) then
583: p_rec.dflt_ws_acc_cd :=
584: ben_enp_shd.g_old_rec.dflt_ws_acc_cd;
585: End If;
586: If (p_rec.prsvr_bdgt_cd = hr_api.g_varchar2) then
582: If (p_rec.dflt_ws_acc_cd= hr_api.g_varchar2) then
583: p_rec.dflt_ws_acc_cd :=
584: ben_enp_shd.g_old_rec.dflt_ws_acc_cd;
585: End If;
586: If (p_rec.prsvr_bdgt_cd = hr_api.g_varchar2) then
587: p_rec.prsvr_bdgt_cd :=
588: ben_enp_shd.g_old_rec.prsvr_bdgt_cd;
589: End If;
590: If (p_rec.uses_bdgt_flag = hr_api.g_varchar2) then
586: If (p_rec.prsvr_bdgt_cd = hr_api.g_varchar2) then
587: p_rec.prsvr_bdgt_cd :=
588: ben_enp_shd.g_old_rec.prsvr_bdgt_cd;
589: End If;
590: If (p_rec.uses_bdgt_flag = hr_api.g_varchar2) then
591: p_rec.uses_bdgt_flag :=
592: ben_enp_shd.g_old_rec.uses_bdgt_flag;
593: End If;
594: If (p_rec.auto_distr_flag = hr_api.g_varchar2) then
590: If (p_rec.uses_bdgt_flag = hr_api.g_varchar2) then
591: p_rec.uses_bdgt_flag :=
592: ben_enp_shd.g_old_rec.uses_bdgt_flag;
593: End If;
594: If (p_rec.auto_distr_flag = hr_api.g_varchar2) then
595: p_rec.auto_distr_flag :=
596: ben_enp_shd.g_old_rec.auto_distr_flag;
597: End If;
598: If (p_rec.hrchy_to_use_cd = hr_api.g_varchar2) then
594: If (p_rec.auto_distr_flag = hr_api.g_varchar2) then
595: p_rec.auto_distr_flag :=
596: ben_enp_shd.g_old_rec.auto_distr_flag;
597: End If;
598: If (p_rec.hrchy_to_use_cd = hr_api.g_varchar2) then
599: p_rec.hrchy_to_use_cd :=
600: ben_enp_shd.g_old_rec.hrchy_to_use_cd;
601: End If;
602: If (p_rec.pos_structure_version_id = hr_api.g_number) then
598: If (p_rec.hrchy_to_use_cd = hr_api.g_varchar2) then
599: p_rec.hrchy_to_use_cd :=
600: ben_enp_shd.g_old_rec.hrchy_to_use_cd;
601: End If;
602: If (p_rec.pos_structure_version_id = hr_api.g_number) then
603: p_rec.pos_structure_version_id :=
604: ben_enp_shd.g_old_rec.pos_structure_version_id;
605: End If;
606: If (p_rec.emp_interview_type_cd = hr_api.g_varchar2) then
602: If (p_rec.pos_structure_version_id = hr_api.g_number) then
603: p_rec.pos_structure_version_id :=
604: ben_enp_shd.g_old_rec.pos_structure_version_id;
605: End If;
606: If (p_rec.emp_interview_type_cd = hr_api.g_varchar2) then
607: p_rec.emp_interview_type_cd :=
608: ben_enp_shd.g_old_rec.emp_interview_type_cd;
609: End If;
610: If (p_rec.wthn_yr_perd_id = hr_api.g_number) then
606: If (p_rec.emp_interview_type_cd = hr_api.g_varchar2) then
607: p_rec.emp_interview_type_cd :=
608: ben_enp_shd.g_old_rec.emp_interview_type_cd;
609: End If;
610: If (p_rec.wthn_yr_perd_id = hr_api.g_number) then
611: p_rec.wthn_yr_perd_id :=
612: ben_enp_shd.g_old_rec.wthn_yr_perd_id;
613: End If;
614: If (p_rec.ler_id = hr_api.g_number) then
610: If (p_rec.wthn_yr_perd_id = hr_api.g_number) then
611: p_rec.wthn_yr_perd_id :=
612: ben_enp_shd.g_old_rec.wthn_yr_perd_id;
613: End If;
614: If (p_rec.ler_id = hr_api.g_number) then
615: p_rec.ler_id :=
616: ben_enp_shd.g_old_rec.ler_id;
617: End If;
618: If (p_rec.perf_revw_strt_dt = hr_api.g_date) then
614: If (p_rec.ler_id = hr_api.g_number) then
615: p_rec.ler_id :=
616: ben_enp_shd.g_old_rec.ler_id;
617: End If;
618: If (p_rec.perf_revw_strt_dt = hr_api.g_date) then
619: p_rec.perf_revw_strt_dt :=
620: ben_enp_shd.g_old_rec.perf_revw_strt_dt;
621: End If;
622: If (p_rec.asg_updt_eff_date = hr_api.g_date) then
618: If (p_rec.perf_revw_strt_dt = hr_api.g_date) then
619: p_rec.perf_revw_strt_dt :=
620: ben_enp_shd.g_old_rec.perf_revw_strt_dt;
621: End If;
622: If (p_rec.asg_updt_eff_date = hr_api.g_date) then
623: p_rec.asg_updt_eff_date :=
624: ben_enp_shd.g_old_rec.asg_updt_eff_date;
625: End If;
626: -- end CompWorkBench additions
623: p_rec.asg_updt_eff_date :=
624: ben_enp_shd.g_old_rec.asg_updt_eff_date;
625: End If;
626: -- end CompWorkBench additions
627: If (p_rec.enp_attribute_category = hr_api.g_varchar2) then
628: p_rec.enp_attribute_category :=
629: ben_enp_shd.g_old_rec.enp_attribute_category;
630: End If;
631: If (p_rec.enp_attribute1 = hr_api.g_varchar2) then
627: If (p_rec.enp_attribute_category = hr_api.g_varchar2) then
628: p_rec.enp_attribute_category :=
629: ben_enp_shd.g_old_rec.enp_attribute_category;
630: End If;
631: If (p_rec.enp_attribute1 = hr_api.g_varchar2) then
632: p_rec.enp_attribute1 :=
633: ben_enp_shd.g_old_rec.enp_attribute1;
634: End If;
635: If (p_rec.enp_attribute2 = hr_api.g_varchar2) then
631: If (p_rec.enp_attribute1 = hr_api.g_varchar2) then
632: p_rec.enp_attribute1 :=
633: ben_enp_shd.g_old_rec.enp_attribute1;
634: End If;
635: If (p_rec.enp_attribute2 = hr_api.g_varchar2) then
636: p_rec.enp_attribute2 :=
637: ben_enp_shd.g_old_rec.enp_attribute2;
638: End If;
639: If (p_rec.enp_attribute3 = hr_api.g_varchar2) then
635: If (p_rec.enp_attribute2 = hr_api.g_varchar2) then
636: p_rec.enp_attribute2 :=
637: ben_enp_shd.g_old_rec.enp_attribute2;
638: End If;
639: If (p_rec.enp_attribute3 = hr_api.g_varchar2) then
640: p_rec.enp_attribute3 :=
641: ben_enp_shd.g_old_rec.enp_attribute3;
642: End If;
643: If (p_rec.enp_attribute4 = hr_api.g_varchar2) then
639: If (p_rec.enp_attribute3 = hr_api.g_varchar2) then
640: p_rec.enp_attribute3 :=
641: ben_enp_shd.g_old_rec.enp_attribute3;
642: End If;
643: If (p_rec.enp_attribute4 = hr_api.g_varchar2) then
644: p_rec.enp_attribute4 :=
645: ben_enp_shd.g_old_rec.enp_attribute4;
646: End If;
647: If (p_rec.enp_attribute5 = hr_api.g_varchar2) then
643: If (p_rec.enp_attribute4 = hr_api.g_varchar2) then
644: p_rec.enp_attribute4 :=
645: ben_enp_shd.g_old_rec.enp_attribute4;
646: End If;
647: If (p_rec.enp_attribute5 = hr_api.g_varchar2) then
648: p_rec.enp_attribute5 :=
649: ben_enp_shd.g_old_rec.enp_attribute5;
650: End If;
651: If (p_rec.enp_attribute6 = hr_api.g_varchar2) then
647: If (p_rec.enp_attribute5 = hr_api.g_varchar2) then
648: p_rec.enp_attribute5 :=
649: ben_enp_shd.g_old_rec.enp_attribute5;
650: End If;
651: If (p_rec.enp_attribute6 = hr_api.g_varchar2) then
652: p_rec.enp_attribute6 :=
653: ben_enp_shd.g_old_rec.enp_attribute6;
654: End If;
655: If (p_rec.enp_attribute7 = hr_api.g_varchar2) then
651: If (p_rec.enp_attribute6 = hr_api.g_varchar2) then
652: p_rec.enp_attribute6 :=
653: ben_enp_shd.g_old_rec.enp_attribute6;
654: End If;
655: If (p_rec.enp_attribute7 = hr_api.g_varchar2) then
656: p_rec.enp_attribute7 :=
657: ben_enp_shd.g_old_rec.enp_attribute7;
658: End If;
659: If (p_rec.enp_attribute8 = hr_api.g_varchar2) then
655: If (p_rec.enp_attribute7 = hr_api.g_varchar2) then
656: p_rec.enp_attribute7 :=
657: ben_enp_shd.g_old_rec.enp_attribute7;
658: End If;
659: If (p_rec.enp_attribute8 = hr_api.g_varchar2) then
660: p_rec.enp_attribute8 :=
661: ben_enp_shd.g_old_rec.enp_attribute8;
662: End If;
663: If (p_rec.enp_attribute9 = hr_api.g_varchar2) then
659: If (p_rec.enp_attribute8 = hr_api.g_varchar2) then
660: p_rec.enp_attribute8 :=
661: ben_enp_shd.g_old_rec.enp_attribute8;
662: End If;
663: If (p_rec.enp_attribute9 = hr_api.g_varchar2) then
664: p_rec.enp_attribute9 :=
665: ben_enp_shd.g_old_rec.enp_attribute9;
666: End If;
667: If (p_rec.enp_attribute10 = hr_api.g_varchar2) then
663: If (p_rec.enp_attribute9 = hr_api.g_varchar2) then
664: p_rec.enp_attribute9 :=
665: ben_enp_shd.g_old_rec.enp_attribute9;
666: End If;
667: If (p_rec.enp_attribute10 = hr_api.g_varchar2) then
668: p_rec.enp_attribute10 :=
669: ben_enp_shd.g_old_rec.enp_attribute10;
670: End If;
671: If (p_rec.enp_attribute11 = hr_api.g_varchar2) then
667: If (p_rec.enp_attribute10 = hr_api.g_varchar2) then
668: p_rec.enp_attribute10 :=
669: ben_enp_shd.g_old_rec.enp_attribute10;
670: End If;
671: If (p_rec.enp_attribute11 = hr_api.g_varchar2) then
672: p_rec.enp_attribute11 :=
673: ben_enp_shd.g_old_rec.enp_attribute11;
674: End If;
675: If (p_rec.enp_attribute12 = hr_api.g_varchar2) then
671: If (p_rec.enp_attribute11 = hr_api.g_varchar2) then
672: p_rec.enp_attribute11 :=
673: ben_enp_shd.g_old_rec.enp_attribute11;
674: End If;
675: If (p_rec.enp_attribute12 = hr_api.g_varchar2) then
676: p_rec.enp_attribute12 :=
677: ben_enp_shd.g_old_rec.enp_attribute12;
678: End If;
679: If (p_rec.enp_attribute13 = hr_api.g_varchar2) then
675: If (p_rec.enp_attribute12 = hr_api.g_varchar2) then
676: p_rec.enp_attribute12 :=
677: ben_enp_shd.g_old_rec.enp_attribute12;
678: End If;
679: If (p_rec.enp_attribute13 = hr_api.g_varchar2) then
680: p_rec.enp_attribute13 :=
681: ben_enp_shd.g_old_rec.enp_attribute13;
682: End If;
683: If (p_rec.enp_attribute14 = hr_api.g_varchar2) then
679: If (p_rec.enp_attribute13 = hr_api.g_varchar2) then
680: p_rec.enp_attribute13 :=
681: ben_enp_shd.g_old_rec.enp_attribute13;
682: End If;
683: If (p_rec.enp_attribute14 = hr_api.g_varchar2) then
684: p_rec.enp_attribute14 :=
685: ben_enp_shd.g_old_rec.enp_attribute14;
686: End If;
687: If (p_rec.enp_attribute15 = hr_api.g_varchar2) then
683: If (p_rec.enp_attribute14 = hr_api.g_varchar2) then
684: p_rec.enp_attribute14 :=
685: ben_enp_shd.g_old_rec.enp_attribute14;
686: End If;
687: If (p_rec.enp_attribute15 = hr_api.g_varchar2) then
688: p_rec.enp_attribute15 :=
689: ben_enp_shd.g_old_rec.enp_attribute15;
690: End If;
691: If (p_rec.enp_attribute16 = hr_api.g_varchar2) then
687: If (p_rec.enp_attribute15 = hr_api.g_varchar2) then
688: p_rec.enp_attribute15 :=
689: ben_enp_shd.g_old_rec.enp_attribute15;
690: End If;
691: If (p_rec.enp_attribute16 = hr_api.g_varchar2) then
692: p_rec.enp_attribute16 :=
693: ben_enp_shd.g_old_rec.enp_attribute16;
694: End If;
695: If (p_rec.enp_attribute17 = hr_api.g_varchar2) then
691: If (p_rec.enp_attribute16 = hr_api.g_varchar2) then
692: p_rec.enp_attribute16 :=
693: ben_enp_shd.g_old_rec.enp_attribute16;
694: End If;
695: If (p_rec.enp_attribute17 = hr_api.g_varchar2) then
696: p_rec.enp_attribute17 :=
697: ben_enp_shd.g_old_rec.enp_attribute17;
698: End If;
699: If (p_rec.enp_attribute18 = hr_api.g_varchar2) then
695: If (p_rec.enp_attribute17 = hr_api.g_varchar2) then
696: p_rec.enp_attribute17 :=
697: ben_enp_shd.g_old_rec.enp_attribute17;
698: End If;
699: If (p_rec.enp_attribute18 = hr_api.g_varchar2) then
700: p_rec.enp_attribute18 :=
701: ben_enp_shd.g_old_rec.enp_attribute18;
702: End If;
703: If (p_rec.enp_attribute19 = hr_api.g_varchar2) then
699: If (p_rec.enp_attribute18 = hr_api.g_varchar2) then
700: p_rec.enp_attribute18 :=
701: ben_enp_shd.g_old_rec.enp_attribute18;
702: End If;
703: If (p_rec.enp_attribute19 = hr_api.g_varchar2) then
704: p_rec.enp_attribute19 :=
705: ben_enp_shd.g_old_rec.enp_attribute19;
706: End If;
707: If (p_rec.enp_attribute20 = hr_api.g_varchar2) then
703: If (p_rec.enp_attribute19 = hr_api.g_varchar2) then
704: p_rec.enp_attribute19 :=
705: ben_enp_shd.g_old_rec.enp_attribute19;
706: End If;
707: If (p_rec.enp_attribute20 = hr_api.g_varchar2) then
708: p_rec.enp_attribute20 :=
709: ben_enp_shd.g_old_rec.enp_attribute20;
710: End If;
711: If (p_rec.enp_attribute21 = hr_api.g_varchar2) then
707: If (p_rec.enp_attribute20 = hr_api.g_varchar2) then
708: p_rec.enp_attribute20 :=
709: ben_enp_shd.g_old_rec.enp_attribute20;
710: End If;
711: If (p_rec.enp_attribute21 = hr_api.g_varchar2) then
712: p_rec.enp_attribute21 :=
713: ben_enp_shd.g_old_rec.enp_attribute21;
714: End If;
715: If (p_rec.enp_attribute22 = hr_api.g_varchar2) then
711: If (p_rec.enp_attribute21 = hr_api.g_varchar2) then
712: p_rec.enp_attribute21 :=
713: ben_enp_shd.g_old_rec.enp_attribute21;
714: End If;
715: If (p_rec.enp_attribute22 = hr_api.g_varchar2) then
716: p_rec.enp_attribute22 :=
717: ben_enp_shd.g_old_rec.enp_attribute22;
718: End If;
719: If (p_rec.enp_attribute23 = hr_api.g_varchar2) then
715: If (p_rec.enp_attribute22 = hr_api.g_varchar2) then
716: p_rec.enp_attribute22 :=
717: ben_enp_shd.g_old_rec.enp_attribute22;
718: End If;
719: If (p_rec.enp_attribute23 = hr_api.g_varchar2) then
720: p_rec.enp_attribute23 :=
721: ben_enp_shd.g_old_rec.enp_attribute23;
722: End If;
723: If (p_rec.enp_attribute24 = hr_api.g_varchar2) then
719: If (p_rec.enp_attribute23 = hr_api.g_varchar2) then
720: p_rec.enp_attribute23 :=
721: ben_enp_shd.g_old_rec.enp_attribute23;
722: End If;
723: If (p_rec.enp_attribute24 = hr_api.g_varchar2) then
724: p_rec.enp_attribute24 :=
725: ben_enp_shd.g_old_rec.enp_attribute24;
726: End If;
727: If (p_rec.enp_attribute25 = hr_api.g_varchar2) then
723: If (p_rec.enp_attribute24 = hr_api.g_varchar2) then
724: p_rec.enp_attribute24 :=
725: ben_enp_shd.g_old_rec.enp_attribute24;
726: End If;
727: If (p_rec.enp_attribute25 = hr_api.g_varchar2) then
728: p_rec.enp_attribute25 :=
729: ben_enp_shd.g_old_rec.enp_attribute25;
730: End If;
731: If (p_rec.enp_attribute26 = hr_api.g_varchar2) then
727: If (p_rec.enp_attribute25 = hr_api.g_varchar2) then
728: p_rec.enp_attribute25 :=
729: ben_enp_shd.g_old_rec.enp_attribute25;
730: End If;
731: If (p_rec.enp_attribute26 = hr_api.g_varchar2) then
732: p_rec.enp_attribute26 :=
733: ben_enp_shd.g_old_rec.enp_attribute26;
734: End If;
735: If (p_rec.enp_attribute27 = hr_api.g_varchar2) then
731: If (p_rec.enp_attribute26 = hr_api.g_varchar2) then
732: p_rec.enp_attribute26 :=
733: ben_enp_shd.g_old_rec.enp_attribute26;
734: End If;
735: If (p_rec.enp_attribute27 = hr_api.g_varchar2) then
736: p_rec.enp_attribute27 :=
737: ben_enp_shd.g_old_rec.enp_attribute27;
738: End If;
739: If (p_rec.enp_attribute28 = hr_api.g_varchar2) then
735: If (p_rec.enp_attribute27 = hr_api.g_varchar2) then
736: p_rec.enp_attribute27 :=
737: ben_enp_shd.g_old_rec.enp_attribute27;
738: End If;
739: If (p_rec.enp_attribute28 = hr_api.g_varchar2) then
740: p_rec.enp_attribute28 :=
741: ben_enp_shd.g_old_rec.enp_attribute28;
742: End If;
743: If (p_rec.enp_attribute29 = hr_api.g_varchar2) then
739: If (p_rec.enp_attribute28 = hr_api.g_varchar2) then
740: p_rec.enp_attribute28 :=
741: ben_enp_shd.g_old_rec.enp_attribute28;
742: End If;
743: If (p_rec.enp_attribute29 = hr_api.g_varchar2) then
744: p_rec.enp_attribute29 :=
745: ben_enp_shd.g_old_rec.enp_attribute29;
746: End If;
747: If (p_rec.enp_attribute30 = hr_api.g_varchar2) then
743: If (p_rec.enp_attribute29 = hr_api.g_varchar2) then
744: p_rec.enp_attribute29 :=
745: ben_enp_shd.g_old_rec.enp_attribute29;
746: End If;
747: If (p_rec.enp_attribute30 = hr_api.g_varchar2) then
748: p_rec.enp_attribute30 :=
749: ben_enp_shd.g_old_rec.enp_attribute30;
750: End If;
751: --
748: p_rec.enp_attribute30 :=
749: ben_enp_shd.g_old_rec.enp_attribute30;
750: End If;
751: --
752: If (p_rec.enrt_perd_det_ovrlp_bckdt_cd = hr_api.g_varchar2) then
753: p_rec.enrt_perd_det_ovrlp_bckdt_cd :=
754: ben_enp_shd.g_old_rec.enrt_perd_det_ovrlp_bckdt_cd;
755: End if;
756:
754: ben_enp_shd.g_old_rec.enrt_perd_det_ovrlp_bckdt_cd;
755: End if;
756:
757: --- cwb
758: If (p_rec.data_freeze_date = hr_api.g_date) then
759: p_rec.data_freeze_date :=
760: ben_enp_shd.g_old_rec.data_freeze_date;
761: End If;
762:
759: p_rec.data_freeze_date :=
760: ben_enp_shd.g_old_rec.data_freeze_date;
761: End If;
762:
763: If (p_rec.Sal_chg_reason_cd = hr_api.g_varchar2) then
764: p_rec.Sal_chg_reason_cd :=
765: ben_enp_shd.g_old_rec.Sal_chg_reason_cd;
766: End if;
767:
764: p_rec.Sal_chg_reason_cd :=
765: ben_enp_shd.g_old_rec.Sal_chg_reason_cd;
766: End if;
767:
768: If (p_rec.Approval_mode_cd = hr_api.g_varchar2) then
769: p_rec.Approval_mode_cd :=
770: ben_enp_shd.g_old_rec.Approval_mode_cd;
771: End if;
772:
769: p_rec.Approval_mode_cd :=
770: ben_enp_shd.g_old_rec.Approval_mode_cd;
771: End if;
772:
773: If (p_rec.hrchy_ame_trn_cd = hr_api.g_varchar2) then
774: p_rec.hrchy_ame_trn_cd :=
775: ben_enp_shd.g_old_rec.hrchy_ame_trn_cd;
776: End if;
777:
774: p_rec.hrchy_ame_trn_cd :=
775: ben_enp_shd.g_old_rec.hrchy_ame_trn_cd;
776: End if;
777:
778: If (p_rec.hrchy_rl = hr_api.g_number) then
779: p_rec.hrchy_rl :=
780: ben_enp_shd.g_old_rec.hrchy_rl;
781: End If;
782:
779: p_rec.hrchy_rl :=
780: ben_enp_shd.g_old_rec.hrchy_rl;
781: End If;
782:
783: If (p_rec.hrchy_ame_app_id = hr_api.g_number) then
784: p_rec.hrchy_ame_app_id :=
785: ben_enp_shd.g_old_rec.hrchy_ame_app_id;
786: End If;
787:
784: p_rec.hrchy_ame_app_id :=
785: ben_enp_shd.g_old_rec.hrchy_ame_app_id;
786: End If;
787:
788: If (p_rec.reinstate_cd = hr_api.g_varchar2) then
789: p_rec.reinstate_cd :=
790: ben_enp_shd.g_old_rec.reinstate_cd;
791: End if;
792:
789: p_rec.reinstate_cd :=
790: ben_enp_shd.g_old_rec.reinstate_cd;
791: End if;
792:
793: If (p_rec.reinstate_ovrdn_cd = hr_api.g_varchar2) then
794: p_rec.reinstate_ovrdn_cd :=
795: ben_enp_shd.g_old_rec.reinstate_ovrdn_cd;
796: End if;
797:
794: p_rec.reinstate_ovrdn_cd :=
795: ben_enp_shd.g_old_rec.reinstate_ovrdn_cd;
796: End if;
797:
798: If (p_rec.defer_deenrol_flag = hr_api.g_varchar2) then
799: p_rec.defer_deenrol_flag :=
800: ben_enp_shd.g_old_rec.defer_deenrol_flag;
801: End if;
802:
799: p_rec.defer_deenrol_flag :=
800: ben_enp_shd.g_old_rec.defer_deenrol_flag;
801: End if;
802:
803: If (p_rec.reopen_le_on_reprocess = hr_api.g_varchar2) then
804: p_rec.reopen_le_on_reprocess :=
805: ben_enp_shd.g_old_rec.reopen_le_on_reprocess;
806: End if;
807: