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