[Home] [Help]
3053: -- Set the object version number for the insert
3054: --
3055: l_object_version_number := 1;
3056: --
3057: ben_epo_shd.g_api_dml := true; -- Set the api dml status
3058: --
3059: -- Select the next sequence number
3060: --
3061: Open C_Sel1;
3259: l_last_update_login
3260: );
3261: hr_utility.set_location('Dn Insert: '||l_proc, 5);
3262: --
3263: ben_epo_shd.g_api_dml := false; -- Unset the api dml status
3264: --
3265: -- When in validation only mode raise the Validate_Enabled exception
3266: --
3267: if p_validate then
3460: --
3461: -- We must select and lock the current row.
3462: --
3463: Open C_Sel1;
3464: Fetch C_Sel1 Into ben_epo_shd.g_old_rec;
3465: If C_Sel1%notfound then
3466: Close C_Sel1;
3467: --
3468: -- The primary key is invalid therefore we must error
3470: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
3471: fnd_message.raise_error;
3472: End If;
3473: Close C_Sel1;
3474: If (p_object_version_number <> ben_epo_shd.g_old_rec.object_version_number) Then
3475: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
3476: fnd_message.raise_error;
3477: End If;
3478: hr_utility.set_location(l_proc, 15);
3493: p_parent_key_value1 => g_old_rec.elig_per_id,
3494: */
3495: p_parent_table_name2 => 'ben_opt_f',
3496: p_parent_key_column2 => 'opt_id',
3497: p_parent_key_value2 => ben_epo_shd.g_old_rec.opt_id,
3498: p_enforce_foreign_locking => false,
3499: p_validation_start_date => l_validation_start_date,
3500: p_validation_end_date => l_validation_end_date);
3501: --
3541: -- |---------------------------< epo_convert_defs >---------------------------|
3542: -- ----------------------------------------------------------------------------
3543: --
3544: Procedure epo_convert_defs
3545: (p_rec in out nocopy ben_epo_shd.g_rec_type
3546: )
3547: is
3548: --
3549: l_proc varchar2(72) := g_package||'epo_convert_defs';
3558: -- is being used then we must set to the 'current' argument value.
3559: --
3560: If (p_rec.elig_per_id = hr_api.g_number) then
3561: p_rec.elig_per_id :=
3562: ben_epo_shd.g_old_rec.elig_per_id;
3563: End If;
3564: If (p_rec.prtn_ovridn_flag = hr_api.g_varchar2) then
3565: p_rec.prtn_ovridn_flag :=
3566: ben_epo_shd.g_old_rec.prtn_ovridn_flag;
3562: ben_epo_shd.g_old_rec.elig_per_id;
3563: End If;
3564: If (p_rec.prtn_ovridn_flag = hr_api.g_varchar2) then
3565: p_rec.prtn_ovridn_flag :=
3566: ben_epo_shd.g_old_rec.prtn_ovridn_flag;
3567: End If;
3568: If (p_rec.prtn_ovridn_thru_dt = hr_api.g_date) then
3569: p_rec.prtn_ovridn_thru_dt :=
3570: ben_epo_shd.g_old_rec.prtn_ovridn_thru_dt;
3566: ben_epo_shd.g_old_rec.prtn_ovridn_flag;
3567: End If;
3568: If (p_rec.prtn_ovridn_thru_dt = hr_api.g_date) then
3569: p_rec.prtn_ovridn_thru_dt :=
3570: ben_epo_shd.g_old_rec.prtn_ovridn_thru_dt;
3571: End If;
3572: If (p_rec.no_mx_prtn_ovrid_thru_flag = hr_api.g_varchar2) then
3573: p_rec.no_mx_prtn_ovrid_thru_flag :=
3574: ben_epo_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag;
3570: ben_epo_shd.g_old_rec.prtn_ovridn_thru_dt;
3571: End If;
3572: If (p_rec.no_mx_prtn_ovrid_thru_flag = hr_api.g_varchar2) then
3573: p_rec.no_mx_prtn_ovrid_thru_flag :=
3574: ben_epo_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag;
3575: End If;
3576: If (p_rec.elig_flag = hr_api.g_varchar2) then
3577: p_rec.elig_flag :=
3578: ben_epo_shd.g_old_rec.elig_flag;
3574: ben_epo_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag;
3575: End If;
3576: If (p_rec.elig_flag = hr_api.g_varchar2) then
3577: p_rec.elig_flag :=
3578: ben_epo_shd.g_old_rec.elig_flag;
3579: End If;
3580: If (p_rec.prtn_strt_dt = hr_api.g_date) then
3581: p_rec.prtn_strt_dt :=
3582: ben_epo_shd.g_old_rec.prtn_strt_dt;
3578: ben_epo_shd.g_old_rec.elig_flag;
3579: End If;
3580: If (p_rec.prtn_strt_dt = hr_api.g_date) then
3581: p_rec.prtn_strt_dt :=
3582: ben_epo_shd.g_old_rec.prtn_strt_dt;
3583: End If;
3584: If (p_rec.prtn_end_dt = hr_api.g_date) then
3585: p_rec.prtn_end_dt :=
3586: ben_epo_shd.g_old_rec.prtn_end_dt;
3582: ben_epo_shd.g_old_rec.prtn_strt_dt;
3583: End If;
3584: If (p_rec.prtn_end_dt = hr_api.g_date) then
3585: p_rec.prtn_end_dt :=
3586: ben_epo_shd.g_old_rec.prtn_end_dt;
3587: End If;
3588: /*
3589: If (p_rec.wait_perd_cmpltn_dt = hr_api.g_date) then
3590: p_rec.wait_perd_cmpltn_dt :=
3587: End If;
3588: /*
3589: If (p_rec.wait_perd_cmpltn_dt = hr_api.g_date) then
3590: p_rec.wait_perd_cmpltn_dt :=
3591: ben_epo_shd.g_old_rec.wait_perd_cmpltn_dt;
3592: End If;
3593: */
3594: If (p_rec.wait_perd_cmpltn_date = hr_api.g_date) then
3595: p_rec.wait_perd_cmpltn_date :=
3592: End If;
3593: */
3594: If (p_rec.wait_perd_cmpltn_date = hr_api.g_date) then
3595: p_rec.wait_perd_cmpltn_date :=
3596: ben_epo_shd.g_old_rec.wait_perd_cmpltn_date;
3597: End If;
3598: If (p_rec.wait_perd_strt_dt = hr_api.g_date) then
3599: p_rec.wait_perd_strt_dt :=
3600: ben_epo_shd.g_old_rec.wait_perd_strt_dt;
3596: ben_epo_shd.g_old_rec.wait_perd_cmpltn_date;
3597: End If;
3598: If (p_rec.wait_perd_strt_dt = hr_api.g_date) then
3599: p_rec.wait_perd_strt_dt :=
3600: ben_epo_shd.g_old_rec.wait_perd_strt_dt;
3601: End If;
3602: If (p_rec.prtn_ovridn_rsn_cd = hr_api.g_varchar2) then
3603: p_rec.prtn_ovridn_rsn_cd :=
3604: ben_epo_shd.g_old_rec.prtn_ovridn_rsn_cd;
3600: ben_epo_shd.g_old_rec.wait_perd_strt_dt;
3601: End If;
3602: If (p_rec.prtn_ovridn_rsn_cd = hr_api.g_varchar2) then
3603: p_rec.prtn_ovridn_rsn_cd :=
3604: ben_epo_shd.g_old_rec.prtn_ovridn_rsn_cd;
3605: End If;
3606: If (p_rec.pct_fl_tm_val = hr_api.g_number) then
3607: p_rec.pct_fl_tm_val :=
3608: ben_epo_shd.g_old_rec.pct_fl_tm_val;
3604: ben_epo_shd.g_old_rec.prtn_ovridn_rsn_cd;
3605: End If;
3606: If (p_rec.pct_fl_tm_val = hr_api.g_number) then
3607: p_rec.pct_fl_tm_val :=
3608: ben_epo_shd.g_old_rec.pct_fl_tm_val;
3609: End If;
3610: If (p_rec.opt_id = hr_api.g_number) then
3611: p_rec.opt_id :=
3612: ben_epo_shd.g_old_rec.opt_id;
3608: ben_epo_shd.g_old_rec.pct_fl_tm_val;
3609: End If;
3610: If (p_rec.opt_id = hr_api.g_number) then
3611: p_rec.opt_id :=
3612: ben_epo_shd.g_old_rec.opt_id;
3613: End If;
3614: If (p_rec.per_in_ler_id = hr_api.g_number) then
3615: p_rec.per_in_ler_id :=
3616: ben_epo_shd.g_old_rec.per_in_ler_id;
3612: ben_epo_shd.g_old_rec.opt_id;
3613: End If;
3614: If (p_rec.per_in_ler_id = hr_api.g_number) then
3615: p_rec.per_in_ler_id :=
3616: ben_epo_shd.g_old_rec.per_in_ler_id;
3617: End If;
3618: If (p_rec.rt_comp_ref_amt = hr_api.g_number) then
3619: p_rec.rt_comp_ref_amt :=
3620: ben_epo_shd.g_old_rec.rt_comp_ref_amt;
3616: ben_epo_shd.g_old_rec.per_in_ler_id;
3617: End If;
3618: If (p_rec.rt_comp_ref_amt = hr_api.g_number) then
3619: p_rec.rt_comp_ref_amt :=
3620: ben_epo_shd.g_old_rec.rt_comp_ref_amt;
3621: End If;
3622: If (p_rec.rt_cmbn_age_n_los_val = hr_api.g_number) then
3623: p_rec.rt_cmbn_age_n_los_val :=
3624: ben_epo_shd.g_old_rec.rt_cmbn_age_n_los_val;
3620: ben_epo_shd.g_old_rec.rt_comp_ref_amt;
3621: End If;
3622: If (p_rec.rt_cmbn_age_n_los_val = hr_api.g_number) then
3623: p_rec.rt_cmbn_age_n_los_val :=
3624: ben_epo_shd.g_old_rec.rt_cmbn_age_n_los_val;
3625: End If;
3626: If (p_rec.rt_comp_ref_uom = hr_api.g_varchar2) then
3627: p_rec.rt_comp_ref_uom :=
3628: ben_epo_shd.g_old_rec.rt_comp_ref_uom;
3624: ben_epo_shd.g_old_rec.rt_cmbn_age_n_los_val;
3625: End If;
3626: If (p_rec.rt_comp_ref_uom = hr_api.g_varchar2) then
3627: p_rec.rt_comp_ref_uom :=
3628: ben_epo_shd.g_old_rec.rt_comp_ref_uom;
3629: End If;
3630: If (p_rec.rt_age_val = hr_api.g_number) then
3631: p_rec.rt_age_val :=
3632: ben_epo_shd.g_old_rec.rt_age_val;
3628: ben_epo_shd.g_old_rec.rt_comp_ref_uom;
3629: End If;
3630: If (p_rec.rt_age_val = hr_api.g_number) then
3631: p_rec.rt_age_val :=
3632: ben_epo_shd.g_old_rec.rt_age_val;
3633: End If;
3634: If (p_rec.rt_los_val = hr_api.g_number) then
3635: p_rec.rt_los_val :=
3636: ben_epo_shd.g_old_rec.rt_los_val;
3632: ben_epo_shd.g_old_rec.rt_age_val;
3633: End If;
3634: If (p_rec.rt_los_val = hr_api.g_number) then
3635: p_rec.rt_los_val :=
3636: ben_epo_shd.g_old_rec.rt_los_val;
3637: End If;
3638: If (p_rec.rt_hrs_wkd_val = hr_api.g_number) then
3639: p_rec.rt_hrs_wkd_val :=
3640: ben_epo_shd.g_old_rec.rt_hrs_wkd_val;
3636: ben_epo_shd.g_old_rec.rt_los_val;
3637: End If;
3638: If (p_rec.rt_hrs_wkd_val = hr_api.g_number) then
3639: p_rec.rt_hrs_wkd_val :=
3640: ben_epo_shd.g_old_rec.rt_hrs_wkd_val;
3641: End If;
3642: If (p_rec.rt_hrs_wkd_bndry_perd_cd = hr_api.g_varchar2) then
3643: p_rec.rt_hrs_wkd_bndry_perd_cd :=
3644: ben_epo_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd;
3640: ben_epo_shd.g_old_rec.rt_hrs_wkd_val;
3641: End If;
3642: If (p_rec.rt_hrs_wkd_bndry_perd_cd = hr_api.g_varchar2) then
3643: p_rec.rt_hrs_wkd_bndry_perd_cd :=
3644: ben_epo_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd;
3645: End If;
3646: If (p_rec.rt_age_uom = hr_api.g_varchar2) then
3647: p_rec.rt_age_uom :=
3648: ben_epo_shd.g_old_rec.rt_age_uom;
3644: ben_epo_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd;
3645: End If;
3646: If (p_rec.rt_age_uom = hr_api.g_varchar2) then
3647: p_rec.rt_age_uom :=
3648: ben_epo_shd.g_old_rec.rt_age_uom;
3649: End If;
3650: If (p_rec.rt_los_uom = hr_api.g_varchar2) then
3651: p_rec.rt_los_uom :=
3652: ben_epo_shd.g_old_rec.rt_los_uom;
3648: ben_epo_shd.g_old_rec.rt_age_uom;
3649: End If;
3650: If (p_rec.rt_los_uom = hr_api.g_varchar2) then
3651: p_rec.rt_los_uom :=
3652: ben_epo_shd.g_old_rec.rt_los_uom;
3653: End If;
3654: If (p_rec.rt_pct_fl_tm_val = hr_api.g_number) then
3655: p_rec.rt_pct_fl_tm_val :=
3656: ben_epo_shd.g_old_rec.rt_pct_fl_tm_val;
3652: ben_epo_shd.g_old_rec.rt_los_uom;
3653: End If;
3654: If (p_rec.rt_pct_fl_tm_val = hr_api.g_number) then
3655: p_rec.rt_pct_fl_tm_val :=
3656: ben_epo_shd.g_old_rec.rt_pct_fl_tm_val;
3657: End If;
3658: If (p_rec.rt_frz_los_flag = hr_api.g_varchar2) then
3659: p_rec.rt_frz_los_flag :=
3660: ben_epo_shd.g_old_rec.rt_frz_los_flag;
3656: ben_epo_shd.g_old_rec.rt_pct_fl_tm_val;
3657: End If;
3658: If (p_rec.rt_frz_los_flag = hr_api.g_varchar2) then
3659: p_rec.rt_frz_los_flag :=
3660: ben_epo_shd.g_old_rec.rt_frz_los_flag;
3661: End If;
3662: If (p_rec.rt_frz_age_flag = hr_api.g_varchar2) then
3663: p_rec.rt_frz_age_flag :=
3664: ben_epo_shd.g_old_rec.rt_frz_age_flag;
3660: ben_epo_shd.g_old_rec.rt_frz_los_flag;
3661: End If;
3662: If (p_rec.rt_frz_age_flag = hr_api.g_varchar2) then
3663: p_rec.rt_frz_age_flag :=
3664: ben_epo_shd.g_old_rec.rt_frz_age_flag;
3665: End If;
3666: If (p_rec.rt_frz_cmp_lvl_flag = hr_api.g_varchar2) then
3667: p_rec.rt_frz_cmp_lvl_flag :=
3668: ben_epo_shd.g_old_rec.rt_frz_cmp_lvl_flag;
3664: ben_epo_shd.g_old_rec.rt_frz_age_flag;
3665: End If;
3666: If (p_rec.rt_frz_cmp_lvl_flag = hr_api.g_varchar2) then
3667: p_rec.rt_frz_cmp_lvl_flag :=
3668: ben_epo_shd.g_old_rec.rt_frz_cmp_lvl_flag;
3669: End If;
3670: If (p_rec.rt_frz_pct_fl_tm_flag = hr_api.g_varchar2) then
3671: p_rec.rt_frz_pct_fl_tm_flag :=
3672: ben_epo_shd.g_old_rec.rt_frz_pct_fl_tm_flag;
3668: ben_epo_shd.g_old_rec.rt_frz_cmp_lvl_flag;
3669: End If;
3670: If (p_rec.rt_frz_pct_fl_tm_flag = hr_api.g_varchar2) then
3671: p_rec.rt_frz_pct_fl_tm_flag :=
3672: ben_epo_shd.g_old_rec.rt_frz_pct_fl_tm_flag;
3673: End If;
3674: If (p_rec.rt_frz_hrs_wkd_flag = hr_api.g_varchar2) then
3675: p_rec.rt_frz_hrs_wkd_flag :=
3676: ben_epo_shd.g_old_rec.rt_frz_hrs_wkd_flag;
3672: ben_epo_shd.g_old_rec.rt_frz_pct_fl_tm_flag;
3673: End If;
3674: If (p_rec.rt_frz_hrs_wkd_flag = hr_api.g_varchar2) then
3675: p_rec.rt_frz_hrs_wkd_flag :=
3676: ben_epo_shd.g_old_rec.rt_frz_hrs_wkd_flag;
3677: End If;
3678: If (p_rec.rt_frz_comb_age_and_los_flag = hr_api.g_varchar2) then
3679: p_rec.rt_frz_comb_age_and_los_flag :=
3680: ben_epo_shd.g_old_rec.rt_frz_comb_age_and_los_flag;
3676: ben_epo_shd.g_old_rec.rt_frz_hrs_wkd_flag;
3677: End If;
3678: If (p_rec.rt_frz_comb_age_and_los_flag = hr_api.g_varchar2) then
3679: p_rec.rt_frz_comb_age_and_los_flag :=
3680: ben_epo_shd.g_old_rec.rt_frz_comb_age_and_los_flag;
3681: End If;
3682: If (p_rec.comp_ref_amt = hr_api.g_number) then
3683: p_rec.comp_ref_amt :=
3684: ben_epo_shd.g_old_rec.comp_ref_amt;
3680: ben_epo_shd.g_old_rec.rt_frz_comb_age_and_los_flag;
3681: End If;
3682: If (p_rec.comp_ref_amt = hr_api.g_number) then
3683: p_rec.comp_ref_amt :=
3684: ben_epo_shd.g_old_rec.comp_ref_amt;
3685: End If;
3686: If (p_rec.cmbn_age_n_los_val = hr_api.g_number) then
3687: p_rec.cmbn_age_n_los_val :=
3688: ben_epo_shd.g_old_rec.cmbn_age_n_los_val;
3684: ben_epo_shd.g_old_rec.comp_ref_amt;
3685: End If;
3686: If (p_rec.cmbn_age_n_los_val = hr_api.g_number) then
3687: p_rec.cmbn_age_n_los_val :=
3688: ben_epo_shd.g_old_rec.cmbn_age_n_los_val;
3689: End If;
3690: If (p_rec.comp_ref_uom = hr_api.g_varchar2) then
3691: p_rec.comp_ref_uom :=
3692: ben_epo_shd.g_old_rec.comp_ref_uom;
3688: ben_epo_shd.g_old_rec.cmbn_age_n_los_val;
3689: End If;
3690: If (p_rec.comp_ref_uom = hr_api.g_varchar2) then
3691: p_rec.comp_ref_uom :=
3692: ben_epo_shd.g_old_rec.comp_ref_uom;
3693: End If;
3694: If (p_rec.age_val = hr_api.g_number) then
3695: p_rec.age_val :=
3696: ben_epo_shd.g_old_rec.age_val;
3692: ben_epo_shd.g_old_rec.comp_ref_uom;
3693: End If;
3694: If (p_rec.age_val = hr_api.g_number) then
3695: p_rec.age_val :=
3696: ben_epo_shd.g_old_rec.age_val;
3697: End If;
3698: If (p_rec.los_val = hr_api.g_number) then
3699: p_rec.los_val :=
3700: ben_epo_shd.g_old_rec.los_val;
3696: ben_epo_shd.g_old_rec.age_val;
3697: End If;
3698: If (p_rec.los_val = hr_api.g_number) then
3699: p_rec.los_val :=
3700: ben_epo_shd.g_old_rec.los_val;
3701: End If;
3702: If (p_rec.hrs_wkd_val = hr_api.g_number) then
3703: p_rec.hrs_wkd_val :=
3704: ben_epo_shd.g_old_rec.hrs_wkd_val;
3700: ben_epo_shd.g_old_rec.los_val;
3701: End If;
3702: If (p_rec.hrs_wkd_val = hr_api.g_number) then
3703: p_rec.hrs_wkd_val :=
3704: ben_epo_shd.g_old_rec.hrs_wkd_val;
3705: End If;
3706: If (p_rec.hrs_wkd_bndry_perd_cd = hr_api.g_varchar2) then
3707: p_rec.hrs_wkd_bndry_perd_cd :=
3708: ben_epo_shd.g_old_rec.hrs_wkd_bndry_perd_cd;
3704: ben_epo_shd.g_old_rec.hrs_wkd_val;
3705: End If;
3706: If (p_rec.hrs_wkd_bndry_perd_cd = hr_api.g_varchar2) then
3707: p_rec.hrs_wkd_bndry_perd_cd :=
3708: ben_epo_shd.g_old_rec.hrs_wkd_bndry_perd_cd;
3709: End If;
3710: If (p_rec.age_uom = hr_api.g_varchar2) then
3711: p_rec.age_uom :=
3712: ben_epo_shd.g_old_rec.age_uom;
3708: ben_epo_shd.g_old_rec.hrs_wkd_bndry_perd_cd;
3709: End If;
3710: If (p_rec.age_uom = hr_api.g_varchar2) then
3711: p_rec.age_uom :=
3712: ben_epo_shd.g_old_rec.age_uom;
3713: End If;
3714: If (p_rec.los_uom = hr_api.g_varchar2) then
3715: p_rec.los_uom :=
3716: ben_epo_shd.g_old_rec.los_uom;
3712: ben_epo_shd.g_old_rec.age_uom;
3713: End If;
3714: If (p_rec.los_uom = hr_api.g_varchar2) then
3715: p_rec.los_uom :=
3716: ben_epo_shd.g_old_rec.los_uom;
3717: End If;
3718: If (p_rec.frz_los_flag = hr_api.g_varchar2) then
3719: p_rec.frz_los_flag :=
3720: ben_epo_shd.g_old_rec.frz_los_flag;
3716: ben_epo_shd.g_old_rec.los_uom;
3717: End If;
3718: If (p_rec.frz_los_flag = hr_api.g_varchar2) then
3719: p_rec.frz_los_flag :=
3720: ben_epo_shd.g_old_rec.frz_los_flag;
3721: End If;
3722: If (p_rec.frz_age_flag = hr_api.g_varchar2) then
3723: p_rec.frz_age_flag :=
3724: ben_epo_shd.g_old_rec.frz_age_flag;
3720: ben_epo_shd.g_old_rec.frz_los_flag;
3721: End If;
3722: If (p_rec.frz_age_flag = hr_api.g_varchar2) then
3723: p_rec.frz_age_flag :=
3724: ben_epo_shd.g_old_rec.frz_age_flag;
3725: End If;
3726: If (p_rec.frz_cmp_lvl_flag = hr_api.g_varchar2) then
3727: p_rec.frz_cmp_lvl_flag :=
3728: ben_epo_shd.g_old_rec.frz_cmp_lvl_flag;
3724: ben_epo_shd.g_old_rec.frz_age_flag;
3725: End If;
3726: If (p_rec.frz_cmp_lvl_flag = hr_api.g_varchar2) then
3727: p_rec.frz_cmp_lvl_flag :=
3728: ben_epo_shd.g_old_rec.frz_cmp_lvl_flag;
3729: End If;
3730: If (p_rec.frz_pct_fl_tm_flag = hr_api.g_varchar2) then
3731: p_rec.frz_pct_fl_tm_flag :=
3732: ben_epo_shd.g_old_rec.frz_pct_fl_tm_flag;
3728: ben_epo_shd.g_old_rec.frz_cmp_lvl_flag;
3729: End If;
3730: If (p_rec.frz_pct_fl_tm_flag = hr_api.g_varchar2) then
3731: p_rec.frz_pct_fl_tm_flag :=
3732: ben_epo_shd.g_old_rec.frz_pct_fl_tm_flag;
3733: End If;
3734: If (p_rec.frz_hrs_wkd_flag = hr_api.g_varchar2) then
3735: p_rec.frz_hrs_wkd_flag :=
3736: ben_epo_shd.g_old_rec.frz_hrs_wkd_flag;
3732: ben_epo_shd.g_old_rec.frz_pct_fl_tm_flag;
3733: End If;
3734: If (p_rec.frz_hrs_wkd_flag = hr_api.g_varchar2) then
3735: p_rec.frz_hrs_wkd_flag :=
3736: ben_epo_shd.g_old_rec.frz_hrs_wkd_flag;
3737: End If;
3738: If (p_rec.frz_comb_age_and_los_flag = hr_api.g_varchar2) then
3739: p_rec.frz_comb_age_and_los_flag :=
3740: ben_epo_shd.g_old_rec.frz_comb_age_and_los_flag;
3736: ben_epo_shd.g_old_rec.frz_hrs_wkd_flag;
3737: End If;
3738: If (p_rec.frz_comb_age_and_los_flag = hr_api.g_varchar2) then
3739: p_rec.frz_comb_age_and_los_flag :=
3740: ben_epo_shd.g_old_rec.frz_comb_age_and_los_flag;
3741: End If;
3742: If (p_rec.ovrid_svc_dt = hr_api.g_date) then
3743: p_rec.ovrid_svc_dt :=
3744: ben_epo_shd.g_old_rec.ovrid_svc_dt;
3740: ben_epo_shd.g_old_rec.frz_comb_age_and_los_flag;
3741: End If;
3742: If (p_rec.ovrid_svc_dt = hr_api.g_date) then
3743: p_rec.ovrid_svc_dt :=
3744: ben_epo_shd.g_old_rec.ovrid_svc_dt;
3745: End If;
3746: If (p_rec.inelg_rsn_cd = hr_api.g_varchar2) then
3747: p_rec.inelg_rsn_cd :=
3748: ben_epo_shd.g_old_rec.inelg_rsn_cd;
3744: ben_epo_shd.g_old_rec.ovrid_svc_dt;
3745: End If;
3746: If (p_rec.inelg_rsn_cd = hr_api.g_varchar2) then
3747: p_rec.inelg_rsn_cd :=
3748: ben_epo_shd.g_old_rec.inelg_rsn_cd;
3749: End If;
3750: If (p_rec.once_r_cntug_cd = hr_api.g_varchar2) then
3751: p_rec.once_r_cntug_cd :=
3752: ben_epo_shd.g_old_rec.once_r_cntug_cd;
3748: ben_epo_shd.g_old_rec.inelg_rsn_cd;
3749: End If;
3750: If (p_rec.once_r_cntug_cd = hr_api.g_varchar2) then
3751: p_rec.once_r_cntug_cd :=
3752: ben_epo_shd.g_old_rec.once_r_cntug_cd;
3753: End If;
3754: If (p_rec.oipl_ordr_num = hr_api.g_number) then
3755: p_rec.oipl_ordr_num :=
3756: ben_epo_shd.g_old_rec.oipl_ordr_num;
3752: ben_epo_shd.g_old_rec.once_r_cntug_cd;
3753: End If;
3754: If (p_rec.oipl_ordr_num = hr_api.g_number) then
3755: p_rec.oipl_ordr_num :=
3756: ben_epo_shd.g_old_rec.oipl_ordr_num;
3757: End If;
3758: If (p_rec.business_group_id = hr_api.g_number) then
3759: p_rec.business_group_id :=
3760: ben_epo_shd.g_old_rec.business_group_id;
3756: ben_epo_shd.g_old_rec.oipl_ordr_num;
3757: End If;
3758: If (p_rec.business_group_id = hr_api.g_number) then
3759: p_rec.business_group_id :=
3760: ben_epo_shd.g_old_rec.business_group_id;
3761: End If;
3762: If (p_rec.epo_attribute_category = hr_api.g_varchar2) then
3763: p_rec.epo_attribute_category :=
3764: ben_epo_shd.g_old_rec.epo_attribute_category;
3760: ben_epo_shd.g_old_rec.business_group_id;
3761: End If;
3762: If (p_rec.epo_attribute_category = hr_api.g_varchar2) then
3763: p_rec.epo_attribute_category :=
3764: ben_epo_shd.g_old_rec.epo_attribute_category;
3765: End If;
3766: If (p_rec.epo_attribute1 = hr_api.g_varchar2) then
3767: p_rec.epo_attribute1 :=
3768: ben_epo_shd.g_old_rec.epo_attribute1;
3764: ben_epo_shd.g_old_rec.epo_attribute_category;
3765: End If;
3766: If (p_rec.epo_attribute1 = hr_api.g_varchar2) then
3767: p_rec.epo_attribute1 :=
3768: ben_epo_shd.g_old_rec.epo_attribute1;
3769: End If;
3770: If (p_rec.epo_attribute2 = hr_api.g_varchar2) then
3771: p_rec.epo_attribute2 :=
3772: ben_epo_shd.g_old_rec.epo_attribute2;
3768: ben_epo_shd.g_old_rec.epo_attribute1;
3769: End If;
3770: If (p_rec.epo_attribute2 = hr_api.g_varchar2) then
3771: p_rec.epo_attribute2 :=
3772: ben_epo_shd.g_old_rec.epo_attribute2;
3773: End If;
3774: If (p_rec.epo_attribute3 = hr_api.g_varchar2) then
3775: p_rec.epo_attribute3 :=
3776: ben_epo_shd.g_old_rec.epo_attribute3;
3772: ben_epo_shd.g_old_rec.epo_attribute2;
3773: End If;
3774: If (p_rec.epo_attribute3 = hr_api.g_varchar2) then
3775: p_rec.epo_attribute3 :=
3776: ben_epo_shd.g_old_rec.epo_attribute3;
3777: End If;
3778: If (p_rec.epo_attribute4 = hr_api.g_varchar2) then
3779: p_rec.epo_attribute4 :=
3780: ben_epo_shd.g_old_rec.epo_attribute4;
3776: ben_epo_shd.g_old_rec.epo_attribute3;
3777: End If;
3778: If (p_rec.epo_attribute4 = hr_api.g_varchar2) then
3779: p_rec.epo_attribute4 :=
3780: ben_epo_shd.g_old_rec.epo_attribute4;
3781: End If;
3782: If (p_rec.epo_attribute5 = hr_api.g_varchar2) then
3783: p_rec.epo_attribute5 :=
3784: ben_epo_shd.g_old_rec.epo_attribute5;
3780: ben_epo_shd.g_old_rec.epo_attribute4;
3781: End If;
3782: If (p_rec.epo_attribute5 = hr_api.g_varchar2) then
3783: p_rec.epo_attribute5 :=
3784: ben_epo_shd.g_old_rec.epo_attribute5;
3785: End If;
3786: If (p_rec.epo_attribute6 = hr_api.g_varchar2) then
3787: p_rec.epo_attribute6 :=
3788: ben_epo_shd.g_old_rec.epo_attribute6;
3784: ben_epo_shd.g_old_rec.epo_attribute5;
3785: End If;
3786: If (p_rec.epo_attribute6 = hr_api.g_varchar2) then
3787: p_rec.epo_attribute6 :=
3788: ben_epo_shd.g_old_rec.epo_attribute6;
3789: End If;
3790: If (p_rec.epo_attribute7 = hr_api.g_varchar2) then
3791: p_rec.epo_attribute7 :=
3792: ben_epo_shd.g_old_rec.epo_attribute7;
3788: ben_epo_shd.g_old_rec.epo_attribute6;
3789: End If;
3790: If (p_rec.epo_attribute7 = hr_api.g_varchar2) then
3791: p_rec.epo_attribute7 :=
3792: ben_epo_shd.g_old_rec.epo_attribute7;
3793: End If;
3794: If (p_rec.epo_attribute8 = hr_api.g_varchar2) then
3795: p_rec.epo_attribute8 :=
3796: ben_epo_shd.g_old_rec.epo_attribute8;
3792: ben_epo_shd.g_old_rec.epo_attribute7;
3793: End If;
3794: If (p_rec.epo_attribute8 = hr_api.g_varchar2) then
3795: p_rec.epo_attribute8 :=
3796: ben_epo_shd.g_old_rec.epo_attribute8;
3797: End If;
3798: If (p_rec.epo_attribute9 = hr_api.g_varchar2) then
3799: p_rec.epo_attribute9 :=
3800: ben_epo_shd.g_old_rec.epo_attribute9;
3796: ben_epo_shd.g_old_rec.epo_attribute8;
3797: End If;
3798: If (p_rec.epo_attribute9 = hr_api.g_varchar2) then
3799: p_rec.epo_attribute9 :=
3800: ben_epo_shd.g_old_rec.epo_attribute9;
3801: End If;
3802: If (p_rec.epo_attribute10 = hr_api.g_varchar2) then
3803: p_rec.epo_attribute10 :=
3804: ben_epo_shd.g_old_rec.epo_attribute10;
3800: ben_epo_shd.g_old_rec.epo_attribute9;
3801: End If;
3802: If (p_rec.epo_attribute10 = hr_api.g_varchar2) then
3803: p_rec.epo_attribute10 :=
3804: ben_epo_shd.g_old_rec.epo_attribute10;
3805: End If;
3806: If (p_rec.epo_attribute11 = hr_api.g_varchar2) then
3807: p_rec.epo_attribute11 :=
3808: ben_epo_shd.g_old_rec.epo_attribute11;
3804: ben_epo_shd.g_old_rec.epo_attribute10;
3805: End If;
3806: If (p_rec.epo_attribute11 = hr_api.g_varchar2) then
3807: p_rec.epo_attribute11 :=
3808: ben_epo_shd.g_old_rec.epo_attribute11;
3809: End If;
3810: If (p_rec.epo_attribute12 = hr_api.g_varchar2) then
3811: p_rec.epo_attribute12 :=
3812: ben_epo_shd.g_old_rec.epo_attribute12;
3808: ben_epo_shd.g_old_rec.epo_attribute11;
3809: End If;
3810: If (p_rec.epo_attribute12 = hr_api.g_varchar2) then
3811: p_rec.epo_attribute12 :=
3812: ben_epo_shd.g_old_rec.epo_attribute12;
3813: End If;
3814: If (p_rec.epo_attribute13 = hr_api.g_varchar2) then
3815: p_rec.epo_attribute13 :=
3816: ben_epo_shd.g_old_rec.epo_attribute13;
3812: ben_epo_shd.g_old_rec.epo_attribute12;
3813: End If;
3814: If (p_rec.epo_attribute13 = hr_api.g_varchar2) then
3815: p_rec.epo_attribute13 :=
3816: ben_epo_shd.g_old_rec.epo_attribute13;
3817: End If;
3818: If (p_rec.epo_attribute14 = hr_api.g_varchar2) then
3819: p_rec.epo_attribute14 :=
3820: ben_epo_shd.g_old_rec.epo_attribute14;
3816: ben_epo_shd.g_old_rec.epo_attribute13;
3817: End If;
3818: If (p_rec.epo_attribute14 = hr_api.g_varchar2) then
3819: p_rec.epo_attribute14 :=
3820: ben_epo_shd.g_old_rec.epo_attribute14;
3821: End If;
3822: If (p_rec.epo_attribute15 = hr_api.g_varchar2) then
3823: p_rec.epo_attribute15 :=
3824: ben_epo_shd.g_old_rec.epo_attribute15;
3820: ben_epo_shd.g_old_rec.epo_attribute14;
3821: End If;
3822: If (p_rec.epo_attribute15 = hr_api.g_varchar2) then
3823: p_rec.epo_attribute15 :=
3824: ben_epo_shd.g_old_rec.epo_attribute15;
3825: End If;
3826: If (p_rec.epo_attribute16 = hr_api.g_varchar2) then
3827: p_rec.epo_attribute16 :=
3828: ben_epo_shd.g_old_rec.epo_attribute16;
3824: ben_epo_shd.g_old_rec.epo_attribute15;
3825: End If;
3826: If (p_rec.epo_attribute16 = hr_api.g_varchar2) then
3827: p_rec.epo_attribute16 :=
3828: ben_epo_shd.g_old_rec.epo_attribute16;
3829: End If;
3830: If (p_rec.epo_attribute17 = hr_api.g_varchar2) then
3831: p_rec.epo_attribute17 :=
3832: ben_epo_shd.g_old_rec.epo_attribute17;
3828: ben_epo_shd.g_old_rec.epo_attribute16;
3829: End If;
3830: If (p_rec.epo_attribute17 = hr_api.g_varchar2) then
3831: p_rec.epo_attribute17 :=
3832: ben_epo_shd.g_old_rec.epo_attribute17;
3833: End If;
3834: If (p_rec.epo_attribute18 = hr_api.g_varchar2) then
3835: p_rec.epo_attribute18 :=
3836: ben_epo_shd.g_old_rec.epo_attribute18;
3832: ben_epo_shd.g_old_rec.epo_attribute17;
3833: End If;
3834: If (p_rec.epo_attribute18 = hr_api.g_varchar2) then
3835: p_rec.epo_attribute18 :=
3836: ben_epo_shd.g_old_rec.epo_attribute18;
3837: End If;
3838: If (p_rec.epo_attribute19 = hr_api.g_varchar2) then
3839: p_rec.epo_attribute19 :=
3840: ben_epo_shd.g_old_rec.epo_attribute19;
3836: ben_epo_shd.g_old_rec.epo_attribute18;
3837: End If;
3838: If (p_rec.epo_attribute19 = hr_api.g_varchar2) then
3839: p_rec.epo_attribute19 :=
3840: ben_epo_shd.g_old_rec.epo_attribute19;
3841: End If;
3842: If (p_rec.epo_attribute20 = hr_api.g_varchar2) then
3843: p_rec.epo_attribute20 :=
3844: ben_epo_shd.g_old_rec.epo_attribute20;
3840: ben_epo_shd.g_old_rec.epo_attribute19;
3841: End If;
3842: If (p_rec.epo_attribute20 = hr_api.g_varchar2) then
3843: p_rec.epo_attribute20 :=
3844: ben_epo_shd.g_old_rec.epo_attribute20;
3845: End If;
3846: If (p_rec.epo_attribute21 = hr_api.g_varchar2) then
3847: p_rec.epo_attribute21 :=
3848: ben_epo_shd.g_old_rec.epo_attribute21;
3844: ben_epo_shd.g_old_rec.epo_attribute20;
3845: End If;
3846: If (p_rec.epo_attribute21 = hr_api.g_varchar2) then
3847: p_rec.epo_attribute21 :=
3848: ben_epo_shd.g_old_rec.epo_attribute21;
3849: End If;
3850: If (p_rec.epo_attribute22 = hr_api.g_varchar2) then
3851: p_rec.epo_attribute22 :=
3852: ben_epo_shd.g_old_rec.epo_attribute22;
3848: ben_epo_shd.g_old_rec.epo_attribute21;
3849: End If;
3850: If (p_rec.epo_attribute22 = hr_api.g_varchar2) then
3851: p_rec.epo_attribute22 :=
3852: ben_epo_shd.g_old_rec.epo_attribute22;
3853: End If;
3854: If (p_rec.epo_attribute23 = hr_api.g_varchar2) then
3855: p_rec.epo_attribute23 :=
3856: ben_epo_shd.g_old_rec.epo_attribute23;
3852: ben_epo_shd.g_old_rec.epo_attribute22;
3853: End If;
3854: If (p_rec.epo_attribute23 = hr_api.g_varchar2) then
3855: p_rec.epo_attribute23 :=
3856: ben_epo_shd.g_old_rec.epo_attribute23;
3857: End If;
3858: If (p_rec.epo_attribute24 = hr_api.g_varchar2) then
3859: p_rec.epo_attribute24 :=
3860: ben_epo_shd.g_old_rec.epo_attribute24;
3856: ben_epo_shd.g_old_rec.epo_attribute23;
3857: End If;
3858: If (p_rec.epo_attribute24 = hr_api.g_varchar2) then
3859: p_rec.epo_attribute24 :=
3860: ben_epo_shd.g_old_rec.epo_attribute24;
3861: End If;
3862: If (p_rec.epo_attribute25 = hr_api.g_varchar2) then
3863: p_rec.epo_attribute25 :=
3864: ben_epo_shd.g_old_rec.epo_attribute25;
3860: ben_epo_shd.g_old_rec.epo_attribute24;
3861: End If;
3862: If (p_rec.epo_attribute25 = hr_api.g_varchar2) then
3863: p_rec.epo_attribute25 :=
3864: ben_epo_shd.g_old_rec.epo_attribute25;
3865: End If;
3866: If (p_rec.epo_attribute26 = hr_api.g_varchar2) then
3867: p_rec.epo_attribute26 :=
3868: ben_epo_shd.g_old_rec.epo_attribute26;
3864: ben_epo_shd.g_old_rec.epo_attribute25;
3865: End If;
3866: If (p_rec.epo_attribute26 = hr_api.g_varchar2) then
3867: p_rec.epo_attribute26 :=
3868: ben_epo_shd.g_old_rec.epo_attribute26;
3869: End If;
3870: If (p_rec.epo_attribute27 = hr_api.g_varchar2) then
3871: p_rec.epo_attribute27 :=
3872: ben_epo_shd.g_old_rec.epo_attribute27;
3868: ben_epo_shd.g_old_rec.epo_attribute26;
3869: End If;
3870: If (p_rec.epo_attribute27 = hr_api.g_varchar2) then
3871: p_rec.epo_attribute27 :=
3872: ben_epo_shd.g_old_rec.epo_attribute27;
3873: End If;
3874: If (p_rec.epo_attribute28 = hr_api.g_varchar2) then
3875: p_rec.epo_attribute28 :=
3876: ben_epo_shd.g_old_rec.epo_attribute28;
3872: ben_epo_shd.g_old_rec.epo_attribute27;
3873: End If;
3874: If (p_rec.epo_attribute28 = hr_api.g_varchar2) then
3875: p_rec.epo_attribute28 :=
3876: ben_epo_shd.g_old_rec.epo_attribute28;
3877: End If;
3878: If (p_rec.epo_attribute29 = hr_api.g_varchar2) then
3879: p_rec.epo_attribute29 :=
3880: ben_epo_shd.g_old_rec.epo_attribute29;
3876: ben_epo_shd.g_old_rec.epo_attribute28;
3877: End If;
3878: If (p_rec.epo_attribute29 = hr_api.g_varchar2) then
3879: p_rec.epo_attribute29 :=
3880: ben_epo_shd.g_old_rec.epo_attribute29;
3881: End If;
3882: If (p_rec.epo_attribute30 = hr_api.g_varchar2) then
3883: p_rec.epo_attribute30 :=
3884: ben_epo_shd.g_old_rec.epo_attribute30;
3880: ben_epo_shd.g_old_rec.epo_attribute29;
3881: End If;
3882: If (p_rec.epo_attribute30 = hr_api.g_varchar2) then
3883: p_rec.epo_attribute30 :=
3884: ben_epo_shd.g_old_rec.epo_attribute30;
3885: End If;
3886: If (p_rec.request_id= hr_api.g_number) then
3887: p_rec.request_id :=
3888: ben_epo_shd.g_old_rec.request_id;
3884: ben_epo_shd.g_old_rec.epo_attribute30;
3885: End If;
3886: If (p_rec.request_id= hr_api.g_number) then
3887: p_rec.request_id :=
3888: ben_epo_shd.g_old_rec.request_id;
3889: End If;
3890: If (p_rec.program_application_id = hr_api.g_number) then
3891: p_rec.program_application_id :=
3892: ben_epo_shd.g_old_rec.program_application_id;
3888: ben_epo_shd.g_old_rec.request_id;
3889: End If;
3890: If (p_rec.program_application_id = hr_api.g_number) then
3891: p_rec.program_application_id :=
3892: ben_epo_shd.g_old_rec.program_application_id;
3893: End If;
3894: If (p_rec.program_id = hr_api.g_number) then
3895: p_rec.program_id :=
3896: ben_epo_shd.g_old_rec.program_id;
3892: ben_epo_shd.g_old_rec.program_application_id;
3893: End If;
3894: If (p_rec.program_id = hr_api.g_number) then
3895: p_rec.program_id :=
3896: ben_epo_shd.g_old_rec.program_id;
3897: End If;
3898: If (p_rec.program_update_date = hr_api.g_date) then
3899: p_rec.program_update_date :=
3900: ben_epo_shd.g_old_rec.program_update_date;
3896: ben_epo_shd.g_old_rec.program_id;
3897: End If;
3898: If (p_rec.program_update_date = hr_api.g_date) then
3899: p_rec.program_update_date :=
3900: ben_epo_shd.g_old_rec.program_update_date;
3901: End If;
3902:
3903: --
3904: hr_utility.set_location(' Leaving:'||l_proc, 10);
3908: -- |----------------------------< dt_pre_update >-----------------------------|
3909: -- ----------------------------------------------------------------------------
3910: --
3911: Procedure dt_pre_update
3912: (p_rec in out nocopy ben_epo_shd.g_rec_type
3913: ,p_effective_date in date
3914: ,p_datetrack_mode in varchar2
3915: ,p_validation_start_date in date
3916: ,p_validation_end_date in date
3926: hr_utility.set_location(l_proc, 10);
3927: --
3928: -- Update the current effective end date
3929: --
3930: ben_epo_shd.upd_effective_end_date
3931: (p_effective_date => p_effective_date,
3932: p_base_key_value => p_rec.elig_per_opt_id,
3933: p_new_effective_end_date => (p_validation_start_date - 1),
3934: p_validation_start_date => p_validation_start_date,
3965: -- ----------------------------------------------------------------------------
3966: -- |------------------------------< pre_update >------------------------------|
3967: -- ----------------------------------------------------------------------------
3968: Procedure pre_update
3969: (p_rec in out nocopy ben_epo_shd.g_rec_type
3970: ,p_effective_date in date
3971: ,p_datetrack_mode in varchar2
3972: ,p_validation_start_date in date
3973: ,p_validation_end_date in date
3994: -- |----------------------------< dt_update_dml >-----------------------------|
3995: -- ----------------------------------------------------------------------------
3996: --
3997: Procedure dt_update_dml
3998: (p_rec in out nocopy ben_epo_shd.g_rec_type
3999: ,p_effective_date in date
4000: ,p_datetrack_mode in varchar2
4001: ,p_validation_start_date in date
4002: ,p_validation_end_date in date
4019: (p_base_table_name => 'ben_elig_per_opt_f',
4020: p_base_key_column => 'elig_per_opt_id',
4021: p_base_key_value => p_rec.elig_per_opt_id);
4022: --
4023: ben_epo_shd.g_api_dml := true; -- Set the api dml status
4024: --
4025: -- Update the ben_elig_per_opt_f Row
4026: --
4027: update ben_elig_per_opt_f
4116: where elig_per_opt_id = p_rec.elig_per_opt_id
4117: and effective_start_date = p_validation_start_date
4118: and effective_end_date = p_validation_end_date;
4119: --
4120: ben_epo_shd.g_api_dml := false; -- Unset the api dml status
4121: --
4122: -- Set the effective start and end dates
4123: --
4124: p_rec.effective_start_date := p_validation_start_date;
4128: hr_utility.set_location(' Leaving:'||l_proc, 15);
4129: Exception
4130: When hr_api.check_integrity_violated Then
4131: -- A check constraint has been violated
4132: ben_epo_shd.g_api_dml := false; -- Unset the api dml status
4133: ben_epo_shd.constraint_error
4134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
4135: When hr_api.unique_integrity_violated Then
4136: -- Unique integrity has been violated
4129: Exception
4130: When hr_api.check_integrity_violated Then
4131: -- A check constraint has been violated
4132: ben_epo_shd.g_api_dml := false; -- Unset the api dml status
4133: ben_epo_shd.constraint_error
4134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
4135: When hr_api.unique_integrity_violated Then
4136: -- Unique integrity has been violated
4137: ben_epo_shd.g_api_dml := false; -- Unset the api dml status
4133: ben_epo_shd.constraint_error
4134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
4135: When hr_api.unique_integrity_violated Then
4136: -- Unique integrity has been violated
4137: ben_epo_shd.g_api_dml := false; -- Unset the api dml status
4138: ben_epo_shd.constraint_error
4139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
4140: When Others Then
4141: ben_epo_shd.g_api_dml := false; -- Unset the api dml status
4134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
4135: When hr_api.unique_integrity_violated Then
4136: -- Unique integrity has been violated
4137: ben_epo_shd.g_api_dml := false; -- Unset the api dml status
4138: ben_epo_shd.constraint_error
4139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
4140: When Others Then
4141: ben_epo_shd.g_api_dml := false; -- Unset the api dml status
4142: Raise;
4137: ben_epo_shd.g_api_dml := false; -- Unset the api dml status
4138: ben_epo_shd.constraint_error
4139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
4140: When Others Then
4141: ben_epo_shd.g_api_dml := false; -- Unset the api dml status
4142: Raise;
4143: End dt_update_dml;
4144: --
4145: -- ----------------------------------------------------------------------------
4146: -- |------------------------------< update_dml >------------------------------|
4147: -- ----------------------------------------------------------------------------
4148: --
4149: Procedure update_dml
4150: (p_rec in out nocopy ben_epo_shd.g_rec_type
4151: ,p_effective_date in date
4152: ,p_datetrack_mode in varchar2
4153: ,p_validation_start_date in date
4154: ,p_validation_end_date in date
4172: -- ----------------------------------------------------------------------------
4173: -- |---------------------------------< upd >----------------------------------|
4174: -- ----------------------------------------------------------------------------
4175: Procedure upd
4176: (p_rec in out nocopy ben_epo_shd.g_rec_type
4177: ,p_effective_date in date
4178: ,p_datetrack_mode in varchar2
4179: )
4180: is
4207: --
4208: if ben_manage_life_events.g_modified_mode in ('U','S','D') then
4209: -- compare the values and if there is no difference come out
4210: if (
4211: nvl(p_rec.per_in_ler_id,-1) <> nvl(ben_epo_shd.g_old_rec.per_in_ler_id,-1) or -- bug 5478994 epo to be updated first-time by unrestricted run
4212: nvl(p_rec.opt_id,-1) <> nvl(ben_epo_shd.g_old_rec.opt_id,-1) or
4213: nvl(p_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy'))<>
4214: nvl(ben_epo_shd.g_old_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy')) or
4215: nvl(p_rec.elig_flag,'N') <> nvl(ben_epo_shd.g_old_rec.elig_flag,'N') or
4208: if ben_manage_life_events.g_modified_mode in ('U','S','D') then
4209: -- compare the values and if there is no difference come out
4210: if (
4211: nvl(p_rec.per_in_ler_id,-1) <> nvl(ben_epo_shd.g_old_rec.per_in_ler_id,-1) or -- bug 5478994 epo to be updated first-time by unrestricted run
4212: nvl(p_rec.opt_id,-1) <> nvl(ben_epo_shd.g_old_rec.opt_id,-1) or
4213: nvl(p_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy'))<>
4214: nvl(ben_epo_shd.g_old_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy')) or
4215: nvl(p_rec.elig_flag,'N') <> nvl(ben_epo_shd.g_old_rec.elig_flag,'N') or
4216: nvl(p_rec.comp_ref_amt,-1) <> nvl(ben_epo_shd.g_old_rec.comp_ref_amt,-1) or
4210: if (
4211: nvl(p_rec.per_in_ler_id,-1) <> nvl(ben_epo_shd.g_old_rec.per_in_ler_id,-1) or -- bug 5478994 epo to be updated first-time by unrestricted run
4212: nvl(p_rec.opt_id,-1) <> nvl(ben_epo_shd.g_old_rec.opt_id,-1) or
4213: nvl(p_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy'))<>
4214: nvl(ben_epo_shd.g_old_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy')) or
4215: nvl(p_rec.elig_flag,'N') <> nvl(ben_epo_shd.g_old_rec.elig_flag,'N') or
4216: nvl(p_rec.comp_ref_amt,-1) <> nvl(ben_epo_shd.g_old_rec.comp_ref_amt,-1) or
4217: nvl(p_rec.cmbn_age_n_los_val, -1) <> nvl(ben_epo_shd.g_old_rec.cmbn_age_n_los_val, -1) or
4218: nvl(p_rec.comp_ref_uom,'X') <> nvl(ben_epo_shd.g_old_rec.comp_ref_uom,'X') or
4211: nvl(p_rec.per_in_ler_id,-1) <> nvl(ben_epo_shd.g_old_rec.per_in_ler_id,-1) or -- bug 5478994 epo to be updated first-time by unrestricted run
4212: nvl(p_rec.opt_id,-1) <> nvl(ben_epo_shd.g_old_rec.opt_id,-1) or
4213: nvl(p_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy'))<>
4214: nvl(ben_epo_shd.g_old_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy')) or
4215: nvl(p_rec.elig_flag,'N') <> nvl(ben_epo_shd.g_old_rec.elig_flag,'N') or
4216: nvl(p_rec.comp_ref_amt,-1) <> nvl(ben_epo_shd.g_old_rec.comp_ref_amt,-1) or
4217: nvl(p_rec.cmbn_age_n_los_val, -1) <> nvl(ben_epo_shd.g_old_rec.cmbn_age_n_los_val, -1) or
4218: nvl(p_rec.comp_ref_uom,'X') <> nvl(ben_epo_shd.g_old_rec.comp_ref_uom,'X') or
4219: nvl(p_rec.age_val, -1) <> nvl(ben_epo_shd.g_old_rec.age_val, -1) or
4212: nvl(p_rec.opt_id,-1) <> nvl(ben_epo_shd.g_old_rec.opt_id,-1) or
4213: nvl(p_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy'))<>
4214: nvl(ben_epo_shd.g_old_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy')) or
4215: nvl(p_rec.elig_flag,'N') <> nvl(ben_epo_shd.g_old_rec.elig_flag,'N') or
4216: nvl(p_rec.comp_ref_amt,-1) <> nvl(ben_epo_shd.g_old_rec.comp_ref_amt,-1) or
4217: nvl(p_rec.cmbn_age_n_los_val, -1) <> nvl(ben_epo_shd.g_old_rec.cmbn_age_n_los_val, -1) or
4218: nvl(p_rec.comp_ref_uom,'X') <> nvl(ben_epo_shd.g_old_rec.comp_ref_uom,'X') or
4219: nvl(p_rec.age_val, -1) <> nvl(ben_epo_shd.g_old_rec.age_val, -1) or
4220: nvl(p_rec.los_val, -1) <> nvl(ben_epo_shd.g_old_rec.los_val, -1) or
4213: nvl(p_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy'))<>
4214: nvl(ben_epo_shd.g_old_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy')) or
4215: nvl(p_rec.elig_flag,'N') <> nvl(ben_epo_shd.g_old_rec.elig_flag,'N') or
4216: nvl(p_rec.comp_ref_amt,-1) <> nvl(ben_epo_shd.g_old_rec.comp_ref_amt,-1) or
4217: nvl(p_rec.cmbn_age_n_los_val, -1) <> nvl(ben_epo_shd.g_old_rec.cmbn_age_n_los_val, -1) or
4218: nvl(p_rec.comp_ref_uom,'X') <> nvl(ben_epo_shd.g_old_rec.comp_ref_uom,'X') or
4219: nvl(p_rec.age_val, -1) <> nvl(ben_epo_shd.g_old_rec.age_val, -1) or
4220: nvl(p_rec.los_val, -1) <> nvl(ben_epo_shd.g_old_rec.los_val, -1) or
4221: nvl(p_rec.prtn_end_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
4214: nvl(ben_epo_shd.g_old_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy')) or
4215: nvl(p_rec.elig_flag,'N') <> nvl(ben_epo_shd.g_old_rec.elig_flag,'N') or
4216: nvl(p_rec.comp_ref_amt,-1) <> nvl(ben_epo_shd.g_old_rec.comp_ref_amt,-1) or
4217: nvl(p_rec.cmbn_age_n_los_val, -1) <> nvl(ben_epo_shd.g_old_rec.cmbn_age_n_los_val, -1) or
4218: nvl(p_rec.comp_ref_uom,'X') <> nvl(ben_epo_shd.g_old_rec.comp_ref_uom,'X') or
4219: nvl(p_rec.age_val, -1) <> nvl(ben_epo_shd.g_old_rec.age_val, -1) or
4220: nvl(p_rec.los_val, -1) <> nvl(ben_epo_shd.g_old_rec.los_val, -1) or
4221: nvl(p_rec.prtn_end_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
4222: nvl(ben_epo_shd.g_old_rec.prtn_end_dt,to_date('01-01-1001','dd-mm-yyyy')) or
4215: nvl(p_rec.elig_flag,'N') <> nvl(ben_epo_shd.g_old_rec.elig_flag,'N') or
4216: nvl(p_rec.comp_ref_amt,-1) <> nvl(ben_epo_shd.g_old_rec.comp_ref_amt,-1) or
4217: nvl(p_rec.cmbn_age_n_los_val, -1) <> nvl(ben_epo_shd.g_old_rec.cmbn_age_n_los_val, -1) or
4218: nvl(p_rec.comp_ref_uom,'X') <> nvl(ben_epo_shd.g_old_rec.comp_ref_uom,'X') or
4219: nvl(p_rec.age_val, -1) <> nvl(ben_epo_shd.g_old_rec.age_val, -1) or
4220: nvl(p_rec.los_val, -1) <> nvl(ben_epo_shd.g_old_rec.los_val, -1) or
4221: nvl(p_rec.prtn_end_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
4222: nvl(ben_epo_shd.g_old_rec.prtn_end_dt,to_date('01-01-1001','dd-mm-yyyy')) or
4223: nvl(p_rec.wait_perd_cmpltn_date,to_date('01-01-1001','dd-mm-yyyy')) <>
4216: nvl(p_rec.comp_ref_amt,-1) <> nvl(ben_epo_shd.g_old_rec.comp_ref_amt,-1) or
4217: nvl(p_rec.cmbn_age_n_los_val, -1) <> nvl(ben_epo_shd.g_old_rec.cmbn_age_n_los_val, -1) or
4218: nvl(p_rec.comp_ref_uom,'X') <> nvl(ben_epo_shd.g_old_rec.comp_ref_uom,'X') or
4219: nvl(p_rec.age_val, -1) <> nvl(ben_epo_shd.g_old_rec.age_val, -1) or
4220: nvl(p_rec.los_val, -1) <> nvl(ben_epo_shd.g_old_rec.los_val, -1) or
4221: nvl(p_rec.prtn_end_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
4222: nvl(ben_epo_shd.g_old_rec.prtn_end_dt,to_date('01-01-1001','dd-mm-yyyy')) or
4223: nvl(p_rec.wait_perd_cmpltn_date,to_date('01-01-1001','dd-mm-yyyy')) <>
4224: nvl(ben_epo_shd.g_old_rec.wait_perd_cmpltn_date,to_date('01-01-1001','dd-mm-yyyy')) or
4218: nvl(p_rec.comp_ref_uom,'X') <> nvl(ben_epo_shd.g_old_rec.comp_ref_uom,'X') or
4219: nvl(p_rec.age_val, -1) <> nvl(ben_epo_shd.g_old_rec.age_val, -1) or
4220: nvl(p_rec.los_val, -1) <> nvl(ben_epo_shd.g_old_rec.los_val, -1) or
4221: nvl(p_rec.prtn_end_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
4222: nvl(ben_epo_shd.g_old_rec.prtn_end_dt,to_date('01-01-1001','dd-mm-yyyy')) or
4223: nvl(p_rec.wait_perd_cmpltn_date,to_date('01-01-1001','dd-mm-yyyy')) <>
4224: nvl(ben_epo_shd.g_old_rec.wait_perd_cmpltn_date,to_date('01-01-1001','dd-mm-yyyy')) or
4225: nvl(p_rec.wait_perd_strt_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
4226: nvl(ben_epo_shd.g_old_rec.wait_perd_strt_dt,to_date('01-01-1001','dd-mm-yyyy')) or
4220: nvl(p_rec.los_val, -1) <> nvl(ben_epo_shd.g_old_rec.los_val, -1) or
4221: nvl(p_rec.prtn_end_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
4222: nvl(ben_epo_shd.g_old_rec.prtn_end_dt,to_date('01-01-1001','dd-mm-yyyy')) or
4223: nvl(p_rec.wait_perd_cmpltn_date,to_date('01-01-1001','dd-mm-yyyy')) <>
4224: nvl(ben_epo_shd.g_old_rec.wait_perd_cmpltn_date,to_date('01-01-1001','dd-mm-yyyy')) or
4225: nvl(p_rec.wait_perd_strt_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
4226: nvl(ben_epo_shd.g_old_rec.wait_perd_strt_dt,to_date('01-01-1001','dd-mm-yyyy')) or
4227: nvl(p_rec.hrs_wkd_val,-1) <> nvl(ben_epo_shd.g_old_rec.hrs_wkd_val,-1) or
4228: nvl(p_rec.hrs_wkd_bndry_perd_cd,'X') <> nvl(ben_epo_shd.g_old_rec.hrs_wkd_bndry_perd_cd,'X') or
4222: nvl(ben_epo_shd.g_old_rec.prtn_end_dt,to_date('01-01-1001','dd-mm-yyyy')) or
4223: nvl(p_rec.wait_perd_cmpltn_date,to_date('01-01-1001','dd-mm-yyyy')) <>
4224: nvl(ben_epo_shd.g_old_rec.wait_perd_cmpltn_date,to_date('01-01-1001','dd-mm-yyyy')) or
4225: nvl(p_rec.wait_perd_strt_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
4226: nvl(ben_epo_shd.g_old_rec.wait_perd_strt_dt,to_date('01-01-1001','dd-mm-yyyy')) or
4227: nvl(p_rec.hrs_wkd_val,-1) <> nvl(ben_epo_shd.g_old_rec.hrs_wkd_val,-1) or
4228: nvl(p_rec.hrs_wkd_bndry_perd_cd,'X') <> nvl(ben_epo_shd.g_old_rec.hrs_wkd_bndry_perd_cd,'X') or
4229: nvl(p_rec.prtn_ovridn_flag,'N') <> nvl(ben_epo_shd.g_old_rec.prtn_ovridn_flag,'N') or
4230: nvl(p_rec.no_mx_prtn_ovrid_thru_flag,'N') <>
4223: nvl(p_rec.wait_perd_cmpltn_date,to_date('01-01-1001','dd-mm-yyyy')) <>
4224: nvl(ben_epo_shd.g_old_rec.wait_perd_cmpltn_date,to_date('01-01-1001','dd-mm-yyyy')) or
4225: nvl(p_rec.wait_perd_strt_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
4226: nvl(ben_epo_shd.g_old_rec.wait_perd_strt_dt,to_date('01-01-1001','dd-mm-yyyy')) or
4227: nvl(p_rec.hrs_wkd_val,-1) <> nvl(ben_epo_shd.g_old_rec.hrs_wkd_val,-1) or
4228: nvl(p_rec.hrs_wkd_bndry_perd_cd,'X') <> nvl(ben_epo_shd.g_old_rec.hrs_wkd_bndry_perd_cd,'X') or
4229: nvl(p_rec.prtn_ovridn_flag,'N') <> nvl(ben_epo_shd.g_old_rec.prtn_ovridn_flag,'N') or
4230: nvl(p_rec.no_mx_prtn_ovrid_thru_flag,'N') <>
4231: nvl(ben_epo_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag,'N') or
4224: nvl(ben_epo_shd.g_old_rec.wait_perd_cmpltn_date,to_date('01-01-1001','dd-mm-yyyy')) or
4225: nvl(p_rec.wait_perd_strt_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
4226: nvl(ben_epo_shd.g_old_rec.wait_perd_strt_dt,to_date('01-01-1001','dd-mm-yyyy')) or
4227: nvl(p_rec.hrs_wkd_val,-1) <> nvl(ben_epo_shd.g_old_rec.hrs_wkd_val,-1) or
4228: nvl(p_rec.hrs_wkd_bndry_perd_cd,'X') <> nvl(ben_epo_shd.g_old_rec.hrs_wkd_bndry_perd_cd,'X') or
4229: nvl(p_rec.prtn_ovridn_flag,'N') <> nvl(ben_epo_shd.g_old_rec.prtn_ovridn_flag,'N') or
4230: nvl(p_rec.no_mx_prtn_ovrid_thru_flag,'N') <>
4231: nvl(ben_epo_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag,'N') or
4232: nvl(p_rec.prtn_ovridn_rsn_cd, 'X') <>
4225: nvl(p_rec.wait_perd_strt_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
4226: nvl(ben_epo_shd.g_old_rec.wait_perd_strt_dt,to_date('01-01-1001','dd-mm-yyyy')) or
4227: nvl(p_rec.hrs_wkd_val,-1) <> nvl(ben_epo_shd.g_old_rec.hrs_wkd_val,-1) or
4228: nvl(p_rec.hrs_wkd_bndry_perd_cd,'X') <> nvl(ben_epo_shd.g_old_rec.hrs_wkd_bndry_perd_cd,'X') or
4229: nvl(p_rec.prtn_ovridn_flag,'N') <> nvl(ben_epo_shd.g_old_rec.prtn_ovridn_flag,'N') or
4230: nvl(p_rec.no_mx_prtn_ovrid_thru_flag,'N') <>
4231: nvl(ben_epo_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag,'N') or
4232: nvl(p_rec.prtn_ovridn_rsn_cd, 'X') <>
4233: nvl(ben_epo_shd.g_old_rec.prtn_ovridn_rsn_cd, 'X') or
4227: nvl(p_rec.hrs_wkd_val,-1) <> nvl(ben_epo_shd.g_old_rec.hrs_wkd_val,-1) or
4228: nvl(p_rec.hrs_wkd_bndry_perd_cd,'X') <> nvl(ben_epo_shd.g_old_rec.hrs_wkd_bndry_perd_cd,'X') or
4229: nvl(p_rec.prtn_ovridn_flag,'N') <> nvl(ben_epo_shd.g_old_rec.prtn_ovridn_flag,'N') or
4230: nvl(p_rec.no_mx_prtn_ovrid_thru_flag,'N') <>
4231: nvl(ben_epo_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag,'N') or
4232: nvl(p_rec.prtn_ovridn_rsn_cd, 'X') <>
4233: nvl(ben_epo_shd.g_old_rec.prtn_ovridn_rsn_cd, 'X') or
4234: nvl(p_rec.age_uom,'X') <> nvl(ben_epo_shd.g_old_rec.age_uom,'X') or
4235: nvl(p_rec.los_uom,'X') <> nvl(ben_epo_shd.g_old_rec.los_uom,'X') or
4229: nvl(p_rec.prtn_ovridn_flag,'N') <> nvl(ben_epo_shd.g_old_rec.prtn_ovridn_flag,'N') or
4230: nvl(p_rec.no_mx_prtn_ovrid_thru_flag,'N') <>
4231: nvl(ben_epo_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag,'N') or
4232: nvl(p_rec.prtn_ovridn_rsn_cd, 'X') <>
4233: nvl(ben_epo_shd.g_old_rec.prtn_ovridn_rsn_cd, 'X') or
4234: nvl(p_rec.age_uom,'X') <> nvl(ben_epo_shd.g_old_rec.age_uom,'X') or
4235: nvl(p_rec.los_uom,'X') <> nvl(ben_epo_shd.g_old_rec.los_uom,'X') or
4236: nvl(p_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
4237: nvl(ben_epo_shd.g_old_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) or
4230: nvl(p_rec.no_mx_prtn_ovrid_thru_flag,'N') <>
4231: nvl(ben_epo_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag,'N') or
4232: nvl(p_rec.prtn_ovridn_rsn_cd, 'X') <>
4233: nvl(ben_epo_shd.g_old_rec.prtn_ovridn_rsn_cd, 'X') or
4234: nvl(p_rec.age_uom,'X') <> nvl(ben_epo_shd.g_old_rec.age_uom,'X') or
4235: nvl(p_rec.los_uom,'X') <> nvl(ben_epo_shd.g_old_rec.los_uom,'X') or
4236: nvl(p_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
4237: nvl(ben_epo_shd.g_old_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) or
4238: nvl(p_rec.inelg_rsn_cd,'X') <> nvl(ben_epo_shd.g_old_rec.inelg_rsn_cd,'X') or
4231: nvl(ben_epo_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag,'N') or
4232: nvl(p_rec.prtn_ovridn_rsn_cd, 'X') <>
4233: nvl(ben_epo_shd.g_old_rec.prtn_ovridn_rsn_cd, 'X') or
4234: nvl(p_rec.age_uom,'X') <> nvl(ben_epo_shd.g_old_rec.age_uom,'X') or
4235: nvl(p_rec.los_uom,'X') <> nvl(ben_epo_shd.g_old_rec.los_uom,'X') or
4236: nvl(p_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
4237: nvl(ben_epo_shd.g_old_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) or
4238: nvl(p_rec.inelg_rsn_cd,'X') <> nvl(ben_epo_shd.g_old_rec.inelg_rsn_cd,'X') or
4239: nvl(p_rec.frz_los_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_los_flag,'N') or
4233: nvl(ben_epo_shd.g_old_rec.prtn_ovridn_rsn_cd, 'X') or
4234: nvl(p_rec.age_uom,'X') <> nvl(ben_epo_shd.g_old_rec.age_uom,'X') or
4235: nvl(p_rec.los_uom,'X') <> nvl(ben_epo_shd.g_old_rec.los_uom,'X') or
4236: nvl(p_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
4237: nvl(ben_epo_shd.g_old_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) or
4238: nvl(p_rec.inelg_rsn_cd,'X') <> nvl(ben_epo_shd.g_old_rec.inelg_rsn_cd,'X') or
4239: nvl(p_rec.frz_los_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_los_flag,'N') or
4240: nvl(p_rec.frz_age_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_age_flag,'N') or
4241: nvl(p_rec.frz_cmp_lvl_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_cmp_lvl_flag,'N') or
4234: nvl(p_rec.age_uom,'X') <> nvl(ben_epo_shd.g_old_rec.age_uom,'X') or
4235: nvl(p_rec.los_uom,'X') <> nvl(ben_epo_shd.g_old_rec.los_uom,'X') or
4236: nvl(p_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
4237: nvl(ben_epo_shd.g_old_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) or
4238: nvl(p_rec.inelg_rsn_cd,'X') <> nvl(ben_epo_shd.g_old_rec.inelg_rsn_cd,'X') or
4239: nvl(p_rec.frz_los_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_los_flag,'N') or
4240: nvl(p_rec.frz_age_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_age_flag,'N') or
4241: nvl(p_rec.frz_cmp_lvl_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_cmp_lvl_flag,'N') or
4242: nvl(p_rec.frz_pct_fl_tm_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_pct_fl_tm_flag,'N') or
4235: nvl(p_rec.los_uom,'X') <> nvl(ben_epo_shd.g_old_rec.los_uom,'X') or
4236: nvl(p_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
4237: nvl(ben_epo_shd.g_old_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) or
4238: nvl(p_rec.inelg_rsn_cd,'X') <> nvl(ben_epo_shd.g_old_rec.inelg_rsn_cd,'X') or
4239: nvl(p_rec.frz_los_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_los_flag,'N') or
4240: nvl(p_rec.frz_age_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_age_flag,'N') or
4241: nvl(p_rec.frz_cmp_lvl_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_cmp_lvl_flag,'N') or
4242: nvl(p_rec.frz_pct_fl_tm_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_pct_fl_tm_flag,'N') or
4243: nvl(p_rec.frz_hrs_wkd_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_hrs_wkd_flag,'N') or
4236: nvl(p_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
4237: nvl(ben_epo_shd.g_old_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) or
4238: nvl(p_rec.inelg_rsn_cd,'X') <> nvl(ben_epo_shd.g_old_rec.inelg_rsn_cd,'X') or
4239: nvl(p_rec.frz_los_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_los_flag,'N') or
4240: nvl(p_rec.frz_age_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_age_flag,'N') or
4241: nvl(p_rec.frz_cmp_lvl_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_cmp_lvl_flag,'N') or
4242: nvl(p_rec.frz_pct_fl_tm_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_pct_fl_tm_flag,'N') or
4243: nvl(p_rec.frz_hrs_wkd_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_hrs_wkd_flag,'N') or
4244: nvl(p_rec.frz_comb_age_and_los_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_comb_age_and_los_flag,'N') or
4237: nvl(ben_epo_shd.g_old_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) or
4238: nvl(p_rec.inelg_rsn_cd,'X') <> nvl(ben_epo_shd.g_old_rec.inelg_rsn_cd,'X') or
4239: nvl(p_rec.frz_los_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_los_flag,'N') or
4240: nvl(p_rec.frz_age_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_age_flag,'N') or
4241: nvl(p_rec.frz_cmp_lvl_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_cmp_lvl_flag,'N') or
4242: nvl(p_rec.frz_pct_fl_tm_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_pct_fl_tm_flag,'N') or
4243: nvl(p_rec.frz_hrs_wkd_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_hrs_wkd_flag,'N') or
4244: nvl(p_rec.frz_comb_age_and_los_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_comb_age_and_los_flag,'N') or
4245: nvl(p_rec.pct_fl_tm_val,-1) <> nvl(ben_epo_shd.g_old_rec.pct_fl_tm_val,-1) or
4238: nvl(p_rec.inelg_rsn_cd,'X') <> nvl(ben_epo_shd.g_old_rec.inelg_rsn_cd,'X') or
4239: nvl(p_rec.frz_los_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_los_flag,'N') or
4240: nvl(p_rec.frz_age_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_age_flag,'N') or
4241: nvl(p_rec.frz_cmp_lvl_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_cmp_lvl_flag,'N') or
4242: nvl(p_rec.frz_pct_fl_tm_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_pct_fl_tm_flag,'N') or
4243: nvl(p_rec.frz_hrs_wkd_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_hrs_wkd_flag,'N') or
4244: nvl(p_rec.frz_comb_age_and_los_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_comb_age_and_los_flag,'N') or
4245: nvl(p_rec.pct_fl_tm_val,-1) <> nvl(ben_epo_shd.g_old_rec.pct_fl_tm_val,-1) or
4246: nvl(p_rec.rt_comp_ref_amt,-1) <> nvl(ben_epo_shd.g_old_rec.rt_comp_ref_amt,-1) or
4239: nvl(p_rec.frz_los_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_los_flag,'N') or
4240: nvl(p_rec.frz_age_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_age_flag,'N') or
4241: nvl(p_rec.frz_cmp_lvl_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_cmp_lvl_flag,'N') or
4242: nvl(p_rec.frz_pct_fl_tm_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_pct_fl_tm_flag,'N') or
4243: nvl(p_rec.frz_hrs_wkd_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_hrs_wkd_flag,'N') or
4244: nvl(p_rec.frz_comb_age_and_los_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_comb_age_and_los_flag,'N') or
4245: nvl(p_rec.pct_fl_tm_val,-1) <> nvl(ben_epo_shd.g_old_rec.pct_fl_tm_val,-1) or
4246: nvl(p_rec.rt_comp_ref_amt,-1) <> nvl(ben_epo_shd.g_old_rec.rt_comp_ref_amt,-1) or
4247: nvl(p_rec.rt_cmbn_age_n_los_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_cmbn_age_n_los_val,-1) or
4240: nvl(p_rec.frz_age_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_age_flag,'N') or
4241: nvl(p_rec.frz_cmp_lvl_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_cmp_lvl_flag,'N') or
4242: nvl(p_rec.frz_pct_fl_tm_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_pct_fl_tm_flag,'N') or
4243: nvl(p_rec.frz_hrs_wkd_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_hrs_wkd_flag,'N') or
4244: nvl(p_rec.frz_comb_age_and_los_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_comb_age_and_los_flag,'N') or
4245: nvl(p_rec.pct_fl_tm_val,-1) <> nvl(ben_epo_shd.g_old_rec.pct_fl_tm_val,-1) or
4246: nvl(p_rec.rt_comp_ref_amt,-1) <> nvl(ben_epo_shd.g_old_rec.rt_comp_ref_amt,-1) or
4247: nvl(p_rec.rt_cmbn_age_n_los_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_cmbn_age_n_los_val,-1) or
4248: nvl(p_rec.rt_comp_ref_uom,'X') <> nvl(ben_epo_shd.g_old_rec.rt_comp_ref_uom,'X') or
4241: nvl(p_rec.frz_cmp_lvl_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_cmp_lvl_flag,'N') or
4242: nvl(p_rec.frz_pct_fl_tm_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_pct_fl_tm_flag,'N') or
4243: nvl(p_rec.frz_hrs_wkd_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_hrs_wkd_flag,'N') or
4244: nvl(p_rec.frz_comb_age_and_los_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_comb_age_and_los_flag,'N') or
4245: nvl(p_rec.pct_fl_tm_val,-1) <> nvl(ben_epo_shd.g_old_rec.pct_fl_tm_val,-1) or
4246: nvl(p_rec.rt_comp_ref_amt,-1) <> nvl(ben_epo_shd.g_old_rec.rt_comp_ref_amt,-1) or
4247: nvl(p_rec.rt_cmbn_age_n_los_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_cmbn_age_n_los_val,-1) or
4248: nvl(p_rec.rt_comp_ref_uom,'X') <> nvl(ben_epo_shd.g_old_rec.rt_comp_ref_uom,'X') or
4249: nvl(p_rec.rt_age_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_age_val,-1) or
4242: nvl(p_rec.frz_pct_fl_tm_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_pct_fl_tm_flag,'N') or
4243: nvl(p_rec.frz_hrs_wkd_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_hrs_wkd_flag,'N') or
4244: nvl(p_rec.frz_comb_age_and_los_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_comb_age_and_los_flag,'N') or
4245: nvl(p_rec.pct_fl_tm_val,-1) <> nvl(ben_epo_shd.g_old_rec.pct_fl_tm_val,-1) or
4246: nvl(p_rec.rt_comp_ref_amt,-1) <> nvl(ben_epo_shd.g_old_rec.rt_comp_ref_amt,-1) or
4247: nvl(p_rec.rt_cmbn_age_n_los_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_cmbn_age_n_los_val,-1) or
4248: nvl(p_rec.rt_comp_ref_uom,'X') <> nvl(ben_epo_shd.g_old_rec.rt_comp_ref_uom,'X') or
4249: nvl(p_rec.rt_age_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_age_val,-1) or
4250: nvl(p_rec.rt_los_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_los_val,-1) or
4243: nvl(p_rec.frz_hrs_wkd_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_hrs_wkd_flag,'N') or
4244: nvl(p_rec.frz_comb_age_and_los_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_comb_age_and_los_flag,'N') or
4245: nvl(p_rec.pct_fl_tm_val,-1) <> nvl(ben_epo_shd.g_old_rec.pct_fl_tm_val,-1) or
4246: nvl(p_rec.rt_comp_ref_amt,-1) <> nvl(ben_epo_shd.g_old_rec.rt_comp_ref_amt,-1) or
4247: nvl(p_rec.rt_cmbn_age_n_los_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_cmbn_age_n_los_val,-1) or
4248: nvl(p_rec.rt_comp_ref_uom,'X') <> nvl(ben_epo_shd.g_old_rec.rt_comp_ref_uom,'X') or
4249: nvl(p_rec.rt_age_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_age_val,-1) or
4250: nvl(p_rec.rt_los_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_los_val,-1) or
4251: nvl(p_rec.rt_hrs_wkd_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_hrs_wkd_val,-1) or
4244: nvl(p_rec.frz_comb_age_and_los_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_comb_age_and_los_flag,'N') or
4245: nvl(p_rec.pct_fl_tm_val,-1) <> nvl(ben_epo_shd.g_old_rec.pct_fl_tm_val,-1) or
4246: nvl(p_rec.rt_comp_ref_amt,-1) <> nvl(ben_epo_shd.g_old_rec.rt_comp_ref_amt,-1) or
4247: nvl(p_rec.rt_cmbn_age_n_los_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_cmbn_age_n_los_val,-1) or
4248: nvl(p_rec.rt_comp_ref_uom,'X') <> nvl(ben_epo_shd.g_old_rec.rt_comp_ref_uom,'X') or
4249: nvl(p_rec.rt_age_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_age_val,-1) or
4250: nvl(p_rec.rt_los_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_los_val,-1) or
4251: nvl(p_rec.rt_hrs_wkd_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_hrs_wkd_val,-1) or
4252: nvl(p_rec.rt_hrs_wkd_bndry_perd_cd,'X') <>
4245: nvl(p_rec.pct_fl_tm_val,-1) <> nvl(ben_epo_shd.g_old_rec.pct_fl_tm_val,-1) or
4246: nvl(p_rec.rt_comp_ref_amt,-1) <> nvl(ben_epo_shd.g_old_rec.rt_comp_ref_amt,-1) or
4247: nvl(p_rec.rt_cmbn_age_n_los_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_cmbn_age_n_los_val,-1) or
4248: nvl(p_rec.rt_comp_ref_uom,'X') <> nvl(ben_epo_shd.g_old_rec.rt_comp_ref_uom,'X') or
4249: nvl(p_rec.rt_age_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_age_val,-1) or
4250: nvl(p_rec.rt_los_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_los_val,-1) or
4251: nvl(p_rec.rt_hrs_wkd_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_hrs_wkd_val,-1) or
4252: nvl(p_rec.rt_hrs_wkd_bndry_perd_cd,'X') <>
4253: nvl(ben_epo_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd,'X') or
4246: nvl(p_rec.rt_comp_ref_amt,-1) <> nvl(ben_epo_shd.g_old_rec.rt_comp_ref_amt,-1) or
4247: nvl(p_rec.rt_cmbn_age_n_los_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_cmbn_age_n_los_val,-1) or
4248: nvl(p_rec.rt_comp_ref_uom,'X') <> nvl(ben_epo_shd.g_old_rec.rt_comp_ref_uom,'X') or
4249: nvl(p_rec.rt_age_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_age_val,-1) or
4250: nvl(p_rec.rt_los_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_los_val,-1) or
4251: nvl(p_rec.rt_hrs_wkd_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_hrs_wkd_val,-1) or
4252: nvl(p_rec.rt_hrs_wkd_bndry_perd_cd,'X') <>
4253: nvl(ben_epo_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd,'X') or
4254: nvl(p_rec.rt_age_uom,'X') <> nvl(ben_epo_shd.g_old_rec.rt_age_uom,'X') or
4247: nvl(p_rec.rt_cmbn_age_n_los_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_cmbn_age_n_los_val,-1) or
4248: nvl(p_rec.rt_comp_ref_uom,'X') <> nvl(ben_epo_shd.g_old_rec.rt_comp_ref_uom,'X') or
4249: nvl(p_rec.rt_age_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_age_val,-1) or
4250: nvl(p_rec.rt_los_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_los_val,-1) or
4251: nvl(p_rec.rt_hrs_wkd_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_hrs_wkd_val,-1) or
4252: nvl(p_rec.rt_hrs_wkd_bndry_perd_cd,'X') <>
4253: nvl(ben_epo_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd,'X') or
4254: nvl(p_rec.rt_age_uom,'X') <> nvl(ben_epo_shd.g_old_rec.rt_age_uom,'X') or
4255: nvl(p_rec.rt_los_uom,'X') <> nvl(ben_epo_shd.g_old_rec.rt_los_uom,'X') or
4249: nvl(p_rec.rt_age_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_age_val,-1) or
4250: nvl(p_rec.rt_los_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_los_val,-1) or
4251: nvl(p_rec.rt_hrs_wkd_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_hrs_wkd_val,-1) or
4252: nvl(p_rec.rt_hrs_wkd_bndry_perd_cd,'X') <>
4253: nvl(ben_epo_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd,'X') or
4254: nvl(p_rec.rt_age_uom,'X') <> nvl(ben_epo_shd.g_old_rec.rt_age_uom,'X') or
4255: nvl(p_rec.rt_los_uom,'X') <> nvl(ben_epo_shd.g_old_rec.rt_los_uom,'X') or
4256: nvl(p_rec.rt_pct_fl_tm_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_pct_fl_tm_val,-1) or
4257: nvl(p_rec.rt_frz_los_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_los_flag,'N') or
4250: nvl(p_rec.rt_los_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_los_val,-1) or
4251: nvl(p_rec.rt_hrs_wkd_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_hrs_wkd_val,-1) or
4252: nvl(p_rec.rt_hrs_wkd_bndry_perd_cd,'X') <>
4253: nvl(ben_epo_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd,'X') or
4254: nvl(p_rec.rt_age_uom,'X') <> nvl(ben_epo_shd.g_old_rec.rt_age_uom,'X') or
4255: nvl(p_rec.rt_los_uom,'X') <> nvl(ben_epo_shd.g_old_rec.rt_los_uom,'X') or
4256: nvl(p_rec.rt_pct_fl_tm_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_pct_fl_tm_val,-1) or
4257: nvl(p_rec.rt_frz_los_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_los_flag,'N') or
4258: nvl(p_rec.rt_frz_age_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_age_flag,'N') or
4251: nvl(p_rec.rt_hrs_wkd_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_hrs_wkd_val,-1) or
4252: nvl(p_rec.rt_hrs_wkd_bndry_perd_cd,'X') <>
4253: nvl(ben_epo_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd,'X') or
4254: nvl(p_rec.rt_age_uom,'X') <> nvl(ben_epo_shd.g_old_rec.rt_age_uom,'X') or
4255: nvl(p_rec.rt_los_uom,'X') <> nvl(ben_epo_shd.g_old_rec.rt_los_uom,'X') or
4256: nvl(p_rec.rt_pct_fl_tm_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_pct_fl_tm_val,-1) or
4257: nvl(p_rec.rt_frz_los_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_los_flag,'N') or
4258: nvl(p_rec.rt_frz_age_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_age_flag,'N') or
4259: nvl(p_rec.rt_frz_cmp_lvl_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_cmp_lvl_flag,'N') or
4252: nvl(p_rec.rt_hrs_wkd_bndry_perd_cd,'X') <>
4253: nvl(ben_epo_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd,'X') or
4254: nvl(p_rec.rt_age_uom,'X') <> nvl(ben_epo_shd.g_old_rec.rt_age_uom,'X') or
4255: nvl(p_rec.rt_los_uom,'X') <> nvl(ben_epo_shd.g_old_rec.rt_los_uom,'X') or
4256: nvl(p_rec.rt_pct_fl_tm_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_pct_fl_tm_val,-1) or
4257: nvl(p_rec.rt_frz_los_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_los_flag,'N') or
4258: nvl(p_rec.rt_frz_age_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_age_flag,'N') or
4259: nvl(p_rec.rt_frz_cmp_lvl_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_cmp_lvl_flag,'N') or
4260: nvl(p_rec.rt_frz_pct_fl_tm_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_pct_fl_tm_flag,'N') or
4253: nvl(ben_epo_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd,'X') or
4254: nvl(p_rec.rt_age_uom,'X') <> nvl(ben_epo_shd.g_old_rec.rt_age_uom,'X') or
4255: nvl(p_rec.rt_los_uom,'X') <> nvl(ben_epo_shd.g_old_rec.rt_los_uom,'X') or
4256: nvl(p_rec.rt_pct_fl_tm_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_pct_fl_tm_val,-1) or
4257: nvl(p_rec.rt_frz_los_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_los_flag,'N') or
4258: nvl(p_rec.rt_frz_age_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_age_flag,'N') or
4259: nvl(p_rec.rt_frz_cmp_lvl_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_cmp_lvl_flag,'N') or
4260: nvl(p_rec.rt_frz_pct_fl_tm_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_pct_fl_tm_flag,'N') or
4261: nvl(p_rec.rt_frz_hrs_wkd_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_hrs_wkd_flag,'N') or
4254: nvl(p_rec.rt_age_uom,'X') <> nvl(ben_epo_shd.g_old_rec.rt_age_uom,'X') or
4255: nvl(p_rec.rt_los_uom,'X') <> nvl(ben_epo_shd.g_old_rec.rt_los_uom,'X') or
4256: nvl(p_rec.rt_pct_fl_tm_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_pct_fl_tm_val,-1) or
4257: nvl(p_rec.rt_frz_los_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_los_flag,'N') or
4258: nvl(p_rec.rt_frz_age_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_age_flag,'N') or
4259: nvl(p_rec.rt_frz_cmp_lvl_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_cmp_lvl_flag,'N') or
4260: nvl(p_rec.rt_frz_pct_fl_tm_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_pct_fl_tm_flag,'N') or
4261: nvl(p_rec.rt_frz_hrs_wkd_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_hrs_wkd_flag,'N') or
4262: nvl(p_rec.rt_frz_comb_age_and_los_flag,'N') <>
4255: nvl(p_rec.rt_los_uom,'X') <> nvl(ben_epo_shd.g_old_rec.rt_los_uom,'X') or
4256: nvl(p_rec.rt_pct_fl_tm_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_pct_fl_tm_val,-1) or
4257: nvl(p_rec.rt_frz_los_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_los_flag,'N') or
4258: nvl(p_rec.rt_frz_age_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_age_flag,'N') or
4259: nvl(p_rec.rt_frz_cmp_lvl_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_cmp_lvl_flag,'N') or
4260: nvl(p_rec.rt_frz_pct_fl_tm_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_pct_fl_tm_flag,'N') or
4261: nvl(p_rec.rt_frz_hrs_wkd_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_hrs_wkd_flag,'N') or
4262: nvl(p_rec.rt_frz_comb_age_and_los_flag,'N') <>
4263: nvl(ben_epo_shd.g_old_rec.rt_frz_comb_age_and_los_flag,'N') or
4256: nvl(p_rec.rt_pct_fl_tm_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_pct_fl_tm_val,-1) or
4257: nvl(p_rec.rt_frz_los_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_los_flag,'N') or
4258: nvl(p_rec.rt_frz_age_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_age_flag,'N') or
4259: nvl(p_rec.rt_frz_cmp_lvl_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_cmp_lvl_flag,'N') or
4260: nvl(p_rec.rt_frz_pct_fl_tm_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_pct_fl_tm_flag,'N') or
4261: nvl(p_rec.rt_frz_hrs_wkd_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_hrs_wkd_flag,'N') or
4262: nvl(p_rec.rt_frz_comb_age_and_los_flag,'N') <>
4263: nvl(ben_epo_shd.g_old_rec.rt_frz_comb_age_and_los_flag,'N') or
4264: nvl(p_rec.once_r_cntug_cd,'X') <> nvl(ben_epo_shd.g_old_rec.once_r_cntug_cd,'X') or
4257: nvl(p_rec.rt_frz_los_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_los_flag,'N') or
4258: nvl(p_rec.rt_frz_age_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_age_flag,'N') or
4259: nvl(p_rec.rt_frz_cmp_lvl_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_cmp_lvl_flag,'N') or
4260: nvl(p_rec.rt_frz_pct_fl_tm_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_pct_fl_tm_flag,'N') or
4261: nvl(p_rec.rt_frz_hrs_wkd_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_hrs_wkd_flag,'N') or
4262: nvl(p_rec.rt_frz_comb_age_and_los_flag,'N') <>
4263: nvl(ben_epo_shd.g_old_rec.rt_frz_comb_age_and_los_flag,'N') or
4264: nvl(p_rec.once_r_cntug_cd,'X') <> nvl(ben_epo_shd.g_old_rec.once_r_cntug_cd,'X') or
4265: nvl(p_rec.oipl_ordr_num,-1) <> nvl(ben_epo_shd.g_old_rec.oipl_ordr_num,-1) or
4259: nvl(p_rec.rt_frz_cmp_lvl_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_cmp_lvl_flag,'N') or
4260: nvl(p_rec.rt_frz_pct_fl_tm_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_pct_fl_tm_flag,'N') or
4261: nvl(p_rec.rt_frz_hrs_wkd_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_hrs_wkd_flag,'N') or
4262: nvl(p_rec.rt_frz_comb_age_and_los_flag,'N') <>
4263: nvl(ben_epo_shd.g_old_rec.rt_frz_comb_age_and_los_flag,'N') or
4264: nvl(p_rec.once_r_cntug_cd,'X') <> nvl(ben_epo_shd.g_old_rec.once_r_cntug_cd,'X') or
4265: nvl(p_rec.oipl_ordr_num,-1) <> nvl(ben_epo_shd.g_old_rec.oipl_ordr_num,-1) or
4266: nvl(l_new_ler_id,-1) <> nvl(l_old_ler_id,-1) -- Bug 12964414
4267: ) then
4260: nvl(p_rec.rt_frz_pct_fl_tm_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_pct_fl_tm_flag,'N') or
4261: nvl(p_rec.rt_frz_hrs_wkd_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_hrs_wkd_flag,'N') or
4262: nvl(p_rec.rt_frz_comb_age_and_los_flag,'N') <>
4263: nvl(ben_epo_shd.g_old_rec.rt_frz_comb_age_and_los_flag,'N') or
4264: nvl(p_rec.once_r_cntug_cd,'X') <> nvl(ben_epo_shd.g_old_rec.once_r_cntug_cd,'X') or
4265: nvl(p_rec.oipl_ordr_num,-1) <> nvl(ben_epo_shd.g_old_rec.oipl_ordr_num,-1) or
4266: nvl(l_new_ler_id,-1) <> nvl(l_old_ler_id,-1) -- Bug 12964414
4267: ) then
4268: --
4261: nvl(p_rec.rt_frz_hrs_wkd_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_hrs_wkd_flag,'N') or
4262: nvl(p_rec.rt_frz_comb_age_and_los_flag,'N') <>
4263: nvl(ben_epo_shd.g_old_rec.rt_frz_comb_age_and_los_flag,'N') or
4264: nvl(p_rec.once_r_cntug_cd,'X') <> nvl(ben_epo_shd.g_old_rec.once_r_cntug_cd,'X') or
4265: nvl(p_rec.oipl_ordr_num,-1) <> nvl(ben_epo_shd.g_old_rec.oipl_ordr_num,-1) or
4266: nvl(l_new_ler_id,-1) <> nvl(l_old_ler_id,-1) -- Bug 12964414
4267: ) then
4268: --
4269: null;
4389: p_effective_date in date,
4390: p_datetrack_mode in varchar2
4391: ) is
4392: --
4393: l_rec ben_epo_shd.g_rec_type;
4394: l_proc varchar2(72) := g_package||'upd';
4395: --
4396: Begin
4397: hr_utility.set_location('Entering:'||l_proc, 5);
4399: -- Call conversion function to turn arguments into the
4400: -- l_rec structure.
4401: --
4402: l_rec :=
4403: ben_epo_shd.convert_args
4404: (
4405: p_elig_per_opt_id,
4406: p_elig_per_id,
4407: null,