eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_ELIGIBLE_PERSON_PERF_API dependencies on BEN_EPO_SHD

Line 3027: ben_epo_shd.g_api_dml := true; -- Set the api dml status

3023: -- Set the object version number for the insert
3024: --
3025: l_object_version_number := 1;
3026: --
3027: ben_epo_shd.g_api_dml := true; -- Set the api dml status
3028: --
3029: -- Select the next sequence number
3030: --
3031: Open C_Sel1;

Line 3233: ben_epo_shd.g_api_dml := false; -- Unset the api dml status

3229: l_last_update_login
3230: );
3231: hr_utility.set_location('Dn Insert: '||l_proc, 5);
3232: --
3233: ben_epo_shd.g_api_dml := false; -- Unset the api dml status
3234: --
3235: -- When in validation only mode raise the Validate_Enabled exception
3236: --
3237: if p_validate then

Line 3434: Fetch C_Sel1 Into ben_epo_shd.g_old_rec;

3430: --
3431: -- We must select and lock the current row.
3432: --
3433: Open C_Sel1;
3434: Fetch C_Sel1 Into ben_epo_shd.g_old_rec;
3435: If C_Sel1%notfound then
3436: Close C_Sel1;
3437: --
3438: -- The primary key is invalid therefore we must error

Line 3444: If (p_object_version_number <> ben_epo_shd.g_old_rec.object_version_number) Then

3440: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
3441: fnd_message.raise_error;
3442: End If;
3443: Close C_Sel1;
3444: If (p_object_version_number <> ben_epo_shd.g_old_rec.object_version_number) Then
3445: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
3446: fnd_message.raise_error;
3447: End If;
3448: hr_utility.set_location(l_proc, 15);

Line 3467: p_parent_key_value2 => ben_epo_shd.g_old_rec.opt_id,

3463: p_parent_key_value1 => g_old_rec.elig_per_id,
3464: */
3465: p_parent_table_name2 => 'ben_opt_f',
3466: p_parent_key_column2 => 'opt_id',
3467: p_parent_key_value2 => ben_epo_shd.g_old_rec.opt_id,
3468: p_enforce_foreign_locking => false,
3469: p_validation_start_date => l_validation_start_date,
3470: p_validation_end_date => l_validation_end_date);
3471: --

Line 3515: (p_rec in out nocopy ben_epo_shd.g_rec_type

3511: -- |---------------------------< epo_convert_defs >---------------------------|
3512: -- ----------------------------------------------------------------------------
3513: --
3514: Procedure epo_convert_defs
3515: (p_rec in out nocopy ben_epo_shd.g_rec_type
3516: )
3517: is
3518: --
3519: l_proc varchar2(72) := g_package||'epo_convert_defs';

Line 3532: ben_epo_shd.g_old_rec.elig_per_id;

3528: -- is being used then we must set to the 'current' argument value.
3529: --
3530: If (p_rec.elig_per_id = hr_api.g_number) then
3531: p_rec.elig_per_id :=
3532: ben_epo_shd.g_old_rec.elig_per_id;
3533: End If;
3534: If (p_rec.prtn_ovridn_flag = hr_api.g_varchar2) then
3535: p_rec.prtn_ovridn_flag :=
3536: ben_epo_shd.g_old_rec.prtn_ovridn_flag;

Line 3536: ben_epo_shd.g_old_rec.prtn_ovridn_flag;

3532: ben_epo_shd.g_old_rec.elig_per_id;
3533: End If;
3534: If (p_rec.prtn_ovridn_flag = hr_api.g_varchar2) then
3535: p_rec.prtn_ovridn_flag :=
3536: ben_epo_shd.g_old_rec.prtn_ovridn_flag;
3537: End If;
3538: If (p_rec.prtn_ovridn_thru_dt = hr_api.g_date) then
3539: p_rec.prtn_ovridn_thru_dt :=
3540: ben_epo_shd.g_old_rec.prtn_ovridn_thru_dt;

Line 3540: ben_epo_shd.g_old_rec.prtn_ovridn_thru_dt;

3536: ben_epo_shd.g_old_rec.prtn_ovridn_flag;
3537: End If;
3538: If (p_rec.prtn_ovridn_thru_dt = hr_api.g_date) then
3539: p_rec.prtn_ovridn_thru_dt :=
3540: ben_epo_shd.g_old_rec.prtn_ovridn_thru_dt;
3541: End If;
3542: If (p_rec.no_mx_prtn_ovrid_thru_flag = hr_api.g_varchar2) then
3543: p_rec.no_mx_prtn_ovrid_thru_flag :=
3544: ben_epo_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag;

Line 3544: ben_epo_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag;

3540: ben_epo_shd.g_old_rec.prtn_ovridn_thru_dt;
3541: End If;
3542: If (p_rec.no_mx_prtn_ovrid_thru_flag = hr_api.g_varchar2) then
3543: p_rec.no_mx_prtn_ovrid_thru_flag :=
3544: ben_epo_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag;
3545: End If;
3546: If (p_rec.elig_flag = hr_api.g_varchar2) then
3547: p_rec.elig_flag :=
3548: ben_epo_shd.g_old_rec.elig_flag;

Line 3548: ben_epo_shd.g_old_rec.elig_flag;

3544: ben_epo_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag;
3545: End If;
3546: If (p_rec.elig_flag = hr_api.g_varchar2) then
3547: p_rec.elig_flag :=
3548: ben_epo_shd.g_old_rec.elig_flag;
3549: End If;
3550: If (p_rec.prtn_strt_dt = hr_api.g_date) then
3551: p_rec.prtn_strt_dt :=
3552: ben_epo_shd.g_old_rec.prtn_strt_dt;

Line 3552: ben_epo_shd.g_old_rec.prtn_strt_dt;

3548: ben_epo_shd.g_old_rec.elig_flag;
3549: End If;
3550: If (p_rec.prtn_strt_dt = hr_api.g_date) then
3551: p_rec.prtn_strt_dt :=
3552: ben_epo_shd.g_old_rec.prtn_strt_dt;
3553: End If;
3554: If (p_rec.prtn_end_dt = hr_api.g_date) then
3555: p_rec.prtn_end_dt :=
3556: ben_epo_shd.g_old_rec.prtn_end_dt;

Line 3556: ben_epo_shd.g_old_rec.prtn_end_dt;

3552: ben_epo_shd.g_old_rec.prtn_strt_dt;
3553: End If;
3554: If (p_rec.prtn_end_dt = hr_api.g_date) then
3555: p_rec.prtn_end_dt :=
3556: ben_epo_shd.g_old_rec.prtn_end_dt;
3557: End If;
3558: /*
3559: If (p_rec.wait_perd_cmpltn_dt = hr_api.g_date) then
3560: p_rec.wait_perd_cmpltn_dt :=

Line 3561: ben_epo_shd.g_old_rec.wait_perd_cmpltn_dt;

3557: End If;
3558: /*
3559: If (p_rec.wait_perd_cmpltn_dt = hr_api.g_date) then
3560: p_rec.wait_perd_cmpltn_dt :=
3561: ben_epo_shd.g_old_rec.wait_perd_cmpltn_dt;
3562: End If;
3563: */
3564: If (p_rec.wait_perd_cmpltn_date = hr_api.g_date) then
3565: p_rec.wait_perd_cmpltn_date :=

Line 3566: ben_epo_shd.g_old_rec.wait_perd_cmpltn_date;

3562: End If;
3563: */
3564: If (p_rec.wait_perd_cmpltn_date = hr_api.g_date) then
3565: p_rec.wait_perd_cmpltn_date :=
3566: ben_epo_shd.g_old_rec.wait_perd_cmpltn_date;
3567: End If;
3568: If (p_rec.wait_perd_strt_dt = hr_api.g_date) then
3569: p_rec.wait_perd_strt_dt :=
3570: ben_epo_shd.g_old_rec.wait_perd_strt_dt;

Line 3570: ben_epo_shd.g_old_rec.wait_perd_strt_dt;

3566: ben_epo_shd.g_old_rec.wait_perd_cmpltn_date;
3567: End If;
3568: If (p_rec.wait_perd_strt_dt = hr_api.g_date) then
3569: p_rec.wait_perd_strt_dt :=
3570: ben_epo_shd.g_old_rec.wait_perd_strt_dt;
3571: End If;
3572: If (p_rec.prtn_ovridn_rsn_cd = hr_api.g_varchar2) then
3573: p_rec.prtn_ovridn_rsn_cd :=
3574: ben_epo_shd.g_old_rec.prtn_ovridn_rsn_cd;

Line 3574: ben_epo_shd.g_old_rec.prtn_ovridn_rsn_cd;

3570: ben_epo_shd.g_old_rec.wait_perd_strt_dt;
3571: End If;
3572: If (p_rec.prtn_ovridn_rsn_cd = hr_api.g_varchar2) then
3573: p_rec.prtn_ovridn_rsn_cd :=
3574: ben_epo_shd.g_old_rec.prtn_ovridn_rsn_cd;
3575: End If;
3576: If (p_rec.pct_fl_tm_val = hr_api.g_number) then
3577: p_rec.pct_fl_tm_val :=
3578: ben_epo_shd.g_old_rec.pct_fl_tm_val;

Line 3578: ben_epo_shd.g_old_rec.pct_fl_tm_val;

3574: ben_epo_shd.g_old_rec.prtn_ovridn_rsn_cd;
3575: End If;
3576: If (p_rec.pct_fl_tm_val = hr_api.g_number) then
3577: p_rec.pct_fl_tm_val :=
3578: ben_epo_shd.g_old_rec.pct_fl_tm_val;
3579: End If;
3580: If (p_rec.opt_id = hr_api.g_number) then
3581: p_rec.opt_id :=
3582: ben_epo_shd.g_old_rec.opt_id;

Line 3582: ben_epo_shd.g_old_rec.opt_id;

3578: ben_epo_shd.g_old_rec.pct_fl_tm_val;
3579: End If;
3580: If (p_rec.opt_id = hr_api.g_number) then
3581: p_rec.opt_id :=
3582: ben_epo_shd.g_old_rec.opt_id;
3583: End If;
3584: If (p_rec.per_in_ler_id = hr_api.g_number) then
3585: p_rec.per_in_ler_id :=
3586: ben_epo_shd.g_old_rec.per_in_ler_id;

Line 3586: ben_epo_shd.g_old_rec.per_in_ler_id;

3582: ben_epo_shd.g_old_rec.opt_id;
3583: End If;
3584: If (p_rec.per_in_ler_id = hr_api.g_number) then
3585: p_rec.per_in_ler_id :=
3586: ben_epo_shd.g_old_rec.per_in_ler_id;
3587: End If;
3588: If (p_rec.rt_comp_ref_amt = hr_api.g_number) then
3589: p_rec.rt_comp_ref_amt :=
3590: ben_epo_shd.g_old_rec.rt_comp_ref_amt;

Line 3590: ben_epo_shd.g_old_rec.rt_comp_ref_amt;

3586: ben_epo_shd.g_old_rec.per_in_ler_id;
3587: End If;
3588: If (p_rec.rt_comp_ref_amt = hr_api.g_number) then
3589: p_rec.rt_comp_ref_amt :=
3590: ben_epo_shd.g_old_rec.rt_comp_ref_amt;
3591: End If;
3592: If (p_rec.rt_cmbn_age_n_los_val = hr_api.g_number) then
3593: p_rec.rt_cmbn_age_n_los_val :=
3594: ben_epo_shd.g_old_rec.rt_cmbn_age_n_los_val;

Line 3594: ben_epo_shd.g_old_rec.rt_cmbn_age_n_los_val;

3590: ben_epo_shd.g_old_rec.rt_comp_ref_amt;
3591: End If;
3592: If (p_rec.rt_cmbn_age_n_los_val = hr_api.g_number) then
3593: p_rec.rt_cmbn_age_n_los_val :=
3594: ben_epo_shd.g_old_rec.rt_cmbn_age_n_los_val;
3595: End If;
3596: If (p_rec.rt_comp_ref_uom = hr_api.g_varchar2) then
3597: p_rec.rt_comp_ref_uom :=
3598: ben_epo_shd.g_old_rec.rt_comp_ref_uom;

Line 3598: ben_epo_shd.g_old_rec.rt_comp_ref_uom;

3594: ben_epo_shd.g_old_rec.rt_cmbn_age_n_los_val;
3595: End If;
3596: If (p_rec.rt_comp_ref_uom = hr_api.g_varchar2) then
3597: p_rec.rt_comp_ref_uom :=
3598: ben_epo_shd.g_old_rec.rt_comp_ref_uom;
3599: End If;
3600: If (p_rec.rt_age_val = hr_api.g_number) then
3601: p_rec.rt_age_val :=
3602: ben_epo_shd.g_old_rec.rt_age_val;

Line 3602: ben_epo_shd.g_old_rec.rt_age_val;

3598: ben_epo_shd.g_old_rec.rt_comp_ref_uom;
3599: End If;
3600: If (p_rec.rt_age_val = hr_api.g_number) then
3601: p_rec.rt_age_val :=
3602: ben_epo_shd.g_old_rec.rt_age_val;
3603: End If;
3604: If (p_rec.rt_los_val = hr_api.g_number) then
3605: p_rec.rt_los_val :=
3606: ben_epo_shd.g_old_rec.rt_los_val;

Line 3606: ben_epo_shd.g_old_rec.rt_los_val;

3602: ben_epo_shd.g_old_rec.rt_age_val;
3603: End If;
3604: If (p_rec.rt_los_val = hr_api.g_number) then
3605: p_rec.rt_los_val :=
3606: ben_epo_shd.g_old_rec.rt_los_val;
3607: End If;
3608: If (p_rec.rt_hrs_wkd_val = hr_api.g_number) then
3609: p_rec.rt_hrs_wkd_val :=
3610: ben_epo_shd.g_old_rec.rt_hrs_wkd_val;

Line 3610: ben_epo_shd.g_old_rec.rt_hrs_wkd_val;

3606: ben_epo_shd.g_old_rec.rt_los_val;
3607: End If;
3608: If (p_rec.rt_hrs_wkd_val = hr_api.g_number) then
3609: p_rec.rt_hrs_wkd_val :=
3610: ben_epo_shd.g_old_rec.rt_hrs_wkd_val;
3611: End If;
3612: If (p_rec.rt_hrs_wkd_bndry_perd_cd = hr_api.g_varchar2) then
3613: p_rec.rt_hrs_wkd_bndry_perd_cd :=
3614: ben_epo_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd;

Line 3614: ben_epo_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd;

3610: ben_epo_shd.g_old_rec.rt_hrs_wkd_val;
3611: End If;
3612: If (p_rec.rt_hrs_wkd_bndry_perd_cd = hr_api.g_varchar2) then
3613: p_rec.rt_hrs_wkd_bndry_perd_cd :=
3614: ben_epo_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd;
3615: End If;
3616: If (p_rec.rt_age_uom = hr_api.g_varchar2) then
3617: p_rec.rt_age_uom :=
3618: ben_epo_shd.g_old_rec.rt_age_uom;

Line 3618: ben_epo_shd.g_old_rec.rt_age_uom;

3614: ben_epo_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd;
3615: End If;
3616: If (p_rec.rt_age_uom = hr_api.g_varchar2) then
3617: p_rec.rt_age_uom :=
3618: ben_epo_shd.g_old_rec.rt_age_uom;
3619: End If;
3620: If (p_rec.rt_los_uom = hr_api.g_varchar2) then
3621: p_rec.rt_los_uom :=
3622: ben_epo_shd.g_old_rec.rt_los_uom;

Line 3622: ben_epo_shd.g_old_rec.rt_los_uom;

3618: ben_epo_shd.g_old_rec.rt_age_uom;
3619: End If;
3620: If (p_rec.rt_los_uom = hr_api.g_varchar2) then
3621: p_rec.rt_los_uom :=
3622: ben_epo_shd.g_old_rec.rt_los_uom;
3623: End If;
3624: If (p_rec.rt_pct_fl_tm_val = hr_api.g_number) then
3625: p_rec.rt_pct_fl_tm_val :=
3626: ben_epo_shd.g_old_rec.rt_pct_fl_tm_val;

Line 3626: ben_epo_shd.g_old_rec.rt_pct_fl_tm_val;

3622: ben_epo_shd.g_old_rec.rt_los_uom;
3623: End If;
3624: If (p_rec.rt_pct_fl_tm_val = hr_api.g_number) then
3625: p_rec.rt_pct_fl_tm_val :=
3626: ben_epo_shd.g_old_rec.rt_pct_fl_tm_val;
3627: End If;
3628: If (p_rec.rt_frz_los_flag = hr_api.g_varchar2) then
3629: p_rec.rt_frz_los_flag :=
3630: ben_epo_shd.g_old_rec.rt_frz_los_flag;

Line 3630: ben_epo_shd.g_old_rec.rt_frz_los_flag;

3626: ben_epo_shd.g_old_rec.rt_pct_fl_tm_val;
3627: End If;
3628: If (p_rec.rt_frz_los_flag = hr_api.g_varchar2) then
3629: p_rec.rt_frz_los_flag :=
3630: ben_epo_shd.g_old_rec.rt_frz_los_flag;
3631: End If;
3632: If (p_rec.rt_frz_age_flag = hr_api.g_varchar2) then
3633: p_rec.rt_frz_age_flag :=
3634: ben_epo_shd.g_old_rec.rt_frz_age_flag;

Line 3634: ben_epo_shd.g_old_rec.rt_frz_age_flag;

3630: ben_epo_shd.g_old_rec.rt_frz_los_flag;
3631: End If;
3632: If (p_rec.rt_frz_age_flag = hr_api.g_varchar2) then
3633: p_rec.rt_frz_age_flag :=
3634: ben_epo_shd.g_old_rec.rt_frz_age_flag;
3635: End If;
3636: If (p_rec.rt_frz_cmp_lvl_flag = hr_api.g_varchar2) then
3637: p_rec.rt_frz_cmp_lvl_flag :=
3638: ben_epo_shd.g_old_rec.rt_frz_cmp_lvl_flag;

Line 3638: ben_epo_shd.g_old_rec.rt_frz_cmp_lvl_flag;

3634: ben_epo_shd.g_old_rec.rt_frz_age_flag;
3635: End If;
3636: If (p_rec.rt_frz_cmp_lvl_flag = hr_api.g_varchar2) then
3637: p_rec.rt_frz_cmp_lvl_flag :=
3638: ben_epo_shd.g_old_rec.rt_frz_cmp_lvl_flag;
3639: End If;
3640: If (p_rec.rt_frz_pct_fl_tm_flag = hr_api.g_varchar2) then
3641: p_rec.rt_frz_pct_fl_tm_flag :=
3642: ben_epo_shd.g_old_rec.rt_frz_pct_fl_tm_flag;

Line 3642: ben_epo_shd.g_old_rec.rt_frz_pct_fl_tm_flag;

3638: ben_epo_shd.g_old_rec.rt_frz_cmp_lvl_flag;
3639: End If;
3640: If (p_rec.rt_frz_pct_fl_tm_flag = hr_api.g_varchar2) then
3641: p_rec.rt_frz_pct_fl_tm_flag :=
3642: ben_epo_shd.g_old_rec.rt_frz_pct_fl_tm_flag;
3643: End If;
3644: If (p_rec.rt_frz_hrs_wkd_flag = hr_api.g_varchar2) then
3645: p_rec.rt_frz_hrs_wkd_flag :=
3646: ben_epo_shd.g_old_rec.rt_frz_hrs_wkd_flag;

Line 3646: ben_epo_shd.g_old_rec.rt_frz_hrs_wkd_flag;

3642: ben_epo_shd.g_old_rec.rt_frz_pct_fl_tm_flag;
3643: End If;
3644: If (p_rec.rt_frz_hrs_wkd_flag = hr_api.g_varchar2) then
3645: p_rec.rt_frz_hrs_wkd_flag :=
3646: ben_epo_shd.g_old_rec.rt_frz_hrs_wkd_flag;
3647: End If;
3648: If (p_rec.rt_frz_comb_age_and_los_flag = hr_api.g_varchar2) then
3649: p_rec.rt_frz_comb_age_and_los_flag :=
3650: ben_epo_shd.g_old_rec.rt_frz_comb_age_and_los_flag;

Line 3650: ben_epo_shd.g_old_rec.rt_frz_comb_age_and_los_flag;

3646: ben_epo_shd.g_old_rec.rt_frz_hrs_wkd_flag;
3647: End If;
3648: If (p_rec.rt_frz_comb_age_and_los_flag = hr_api.g_varchar2) then
3649: p_rec.rt_frz_comb_age_and_los_flag :=
3650: ben_epo_shd.g_old_rec.rt_frz_comb_age_and_los_flag;
3651: End If;
3652: If (p_rec.comp_ref_amt = hr_api.g_number) then
3653: p_rec.comp_ref_amt :=
3654: ben_epo_shd.g_old_rec.comp_ref_amt;

Line 3654: ben_epo_shd.g_old_rec.comp_ref_amt;

3650: ben_epo_shd.g_old_rec.rt_frz_comb_age_and_los_flag;
3651: End If;
3652: If (p_rec.comp_ref_amt = hr_api.g_number) then
3653: p_rec.comp_ref_amt :=
3654: ben_epo_shd.g_old_rec.comp_ref_amt;
3655: End If;
3656: If (p_rec.cmbn_age_n_los_val = hr_api.g_number) then
3657: p_rec.cmbn_age_n_los_val :=
3658: ben_epo_shd.g_old_rec.cmbn_age_n_los_val;

Line 3658: ben_epo_shd.g_old_rec.cmbn_age_n_los_val;

3654: ben_epo_shd.g_old_rec.comp_ref_amt;
3655: End If;
3656: If (p_rec.cmbn_age_n_los_val = hr_api.g_number) then
3657: p_rec.cmbn_age_n_los_val :=
3658: ben_epo_shd.g_old_rec.cmbn_age_n_los_val;
3659: End If;
3660: If (p_rec.comp_ref_uom = hr_api.g_varchar2) then
3661: p_rec.comp_ref_uom :=
3662: ben_epo_shd.g_old_rec.comp_ref_uom;

Line 3662: ben_epo_shd.g_old_rec.comp_ref_uom;

3658: ben_epo_shd.g_old_rec.cmbn_age_n_los_val;
3659: End If;
3660: If (p_rec.comp_ref_uom = hr_api.g_varchar2) then
3661: p_rec.comp_ref_uom :=
3662: ben_epo_shd.g_old_rec.comp_ref_uom;
3663: End If;
3664: If (p_rec.age_val = hr_api.g_number) then
3665: p_rec.age_val :=
3666: ben_epo_shd.g_old_rec.age_val;

Line 3666: ben_epo_shd.g_old_rec.age_val;

3662: ben_epo_shd.g_old_rec.comp_ref_uom;
3663: End If;
3664: If (p_rec.age_val = hr_api.g_number) then
3665: p_rec.age_val :=
3666: ben_epo_shd.g_old_rec.age_val;
3667: End If;
3668: If (p_rec.los_val = hr_api.g_number) then
3669: p_rec.los_val :=
3670: ben_epo_shd.g_old_rec.los_val;

Line 3670: ben_epo_shd.g_old_rec.los_val;

3666: ben_epo_shd.g_old_rec.age_val;
3667: End If;
3668: If (p_rec.los_val = hr_api.g_number) then
3669: p_rec.los_val :=
3670: ben_epo_shd.g_old_rec.los_val;
3671: End If;
3672: If (p_rec.hrs_wkd_val = hr_api.g_number) then
3673: p_rec.hrs_wkd_val :=
3674: ben_epo_shd.g_old_rec.hrs_wkd_val;

Line 3674: ben_epo_shd.g_old_rec.hrs_wkd_val;

3670: ben_epo_shd.g_old_rec.los_val;
3671: End If;
3672: If (p_rec.hrs_wkd_val = hr_api.g_number) then
3673: p_rec.hrs_wkd_val :=
3674: ben_epo_shd.g_old_rec.hrs_wkd_val;
3675: End If;
3676: If (p_rec.hrs_wkd_bndry_perd_cd = hr_api.g_varchar2) then
3677: p_rec.hrs_wkd_bndry_perd_cd :=
3678: ben_epo_shd.g_old_rec.hrs_wkd_bndry_perd_cd;

Line 3678: ben_epo_shd.g_old_rec.hrs_wkd_bndry_perd_cd;

3674: ben_epo_shd.g_old_rec.hrs_wkd_val;
3675: End If;
3676: If (p_rec.hrs_wkd_bndry_perd_cd = hr_api.g_varchar2) then
3677: p_rec.hrs_wkd_bndry_perd_cd :=
3678: ben_epo_shd.g_old_rec.hrs_wkd_bndry_perd_cd;
3679: End If;
3680: If (p_rec.age_uom = hr_api.g_varchar2) then
3681: p_rec.age_uom :=
3682: ben_epo_shd.g_old_rec.age_uom;

Line 3682: ben_epo_shd.g_old_rec.age_uom;

3678: ben_epo_shd.g_old_rec.hrs_wkd_bndry_perd_cd;
3679: End If;
3680: If (p_rec.age_uom = hr_api.g_varchar2) then
3681: p_rec.age_uom :=
3682: ben_epo_shd.g_old_rec.age_uom;
3683: End If;
3684: If (p_rec.los_uom = hr_api.g_varchar2) then
3685: p_rec.los_uom :=
3686: ben_epo_shd.g_old_rec.los_uom;

Line 3686: ben_epo_shd.g_old_rec.los_uom;

3682: ben_epo_shd.g_old_rec.age_uom;
3683: End If;
3684: If (p_rec.los_uom = hr_api.g_varchar2) then
3685: p_rec.los_uom :=
3686: ben_epo_shd.g_old_rec.los_uom;
3687: End If;
3688: If (p_rec.frz_los_flag = hr_api.g_varchar2) then
3689: p_rec.frz_los_flag :=
3690: ben_epo_shd.g_old_rec.frz_los_flag;

Line 3690: ben_epo_shd.g_old_rec.frz_los_flag;

3686: ben_epo_shd.g_old_rec.los_uom;
3687: End If;
3688: If (p_rec.frz_los_flag = hr_api.g_varchar2) then
3689: p_rec.frz_los_flag :=
3690: ben_epo_shd.g_old_rec.frz_los_flag;
3691: End If;
3692: If (p_rec.frz_age_flag = hr_api.g_varchar2) then
3693: p_rec.frz_age_flag :=
3694: ben_epo_shd.g_old_rec.frz_age_flag;

Line 3694: ben_epo_shd.g_old_rec.frz_age_flag;

3690: ben_epo_shd.g_old_rec.frz_los_flag;
3691: End If;
3692: If (p_rec.frz_age_flag = hr_api.g_varchar2) then
3693: p_rec.frz_age_flag :=
3694: ben_epo_shd.g_old_rec.frz_age_flag;
3695: End If;
3696: If (p_rec.frz_cmp_lvl_flag = hr_api.g_varchar2) then
3697: p_rec.frz_cmp_lvl_flag :=
3698: ben_epo_shd.g_old_rec.frz_cmp_lvl_flag;

Line 3698: ben_epo_shd.g_old_rec.frz_cmp_lvl_flag;

3694: ben_epo_shd.g_old_rec.frz_age_flag;
3695: End If;
3696: If (p_rec.frz_cmp_lvl_flag = hr_api.g_varchar2) then
3697: p_rec.frz_cmp_lvl_flag :=
3698: ben_epo_shd.g_old_rec.frz_cmp_lvl_flag;
3699: End If;
3700: If (p_rec.frz_pct_fl_tm_flag = hr_api.g_varchar2) then
3701: p_rec.frz_pct_fl_tm_flag :=
3702: ben_epo_shd.g_old_rec.frz_pct_fl_tm_flag;

Line 3702: ben_epo_shd.g_old_rec.frz_pct_fl_tm_flag;

3698: ben_epo_shd.g_old_rec.frz_cmp_lvl_flag;
3699: End If;
3700: If (p_rec.frz_pct_fl_tm_flag = hr_api.g_varchar2) then
3701: p_rec.frz_pct_fl_tm_flag :=
3702: ben_epo_shd.g_old_rec.frz_pct_fl_tm_flag;
3703: End If;
3704: If (p_rec.frz_hrs_wkd_flag = hr_api.g_varchar2) then
3705: p_rec.frz_hrs_wkd_flag :=
3706: ben_epo_shd.g_old_rec.frz_hrs_wkd_flag;

Line 3706: ben_epo_shd.g_old_rec.frz_hrs_wkd_flag;

3702: ben_epo_shd.g_old_rec.frz_pct_fl_tm_flag;
3703: End If;
3704: If (p_rec.frz_hrs_wkd_flag = hr_api.g_varchar2) then
3705: p_rec.frz_hrs_wkd_flag :=
3706: ben_epo_shd.g_old_rec.frz_hrs_wkd_flag;
3707: End If;
3708: If (p_rec.frz_comb_age_and_los_flag = hr_api.g_varchar2) then
3709: p_rec.frz_comb_age_and_los_flag :=
3710: ben_epo_shd.g_old_rec.frz_comb_age_and_los_flag;

Line 3710: ben_epo_shd.g_old_rec.frz_comb_age_and_los_flag;

3706: ben_epo_shd.g_old_rec.frz_hrs_wkd_flag;
3707: End If;
3708: If (p_rec.frz_comb_age_and_los_flag = hr_api.g_varchar2) then
3709: p_rec.frz_comb_age_and_los_flag :=
3710: ben_epo_shd.g_old_rec.frz_comb_age_and_los_flag;
3711: End If;
3712: If (p_rec.ovrid_svc_dt = hr_api.g_date) then
3713: p_rec.ovrid_svc_dt :=
3714: ben_epo_shd.g_old_rec.ovrid_svc_dt;

Line 3714: ben_epo_shd.g_old_rec.ovrid_svc_dt;

3710: ben_epo_shd.g_old_rec.frz_comb_age_and_los_flag;
3711: End If;
3712: If (p_rec.ovrid_svc_dt = hr_api.g_date) then
3713: p_rec.ovrid_svc_dt :=
3714: ben_epo_shd.g_old_rec.ovrid_svc_dt;
3715: End If;
3716: If (p_rec.inelg_rsn_cd = hr_api.g_varchar2) then
3717: p_rec.inelg_rsn_cd :=
3718: ben_epo_shd.g_old_rec.inelg_rsn_cd;

Line 3718: ben_epo_shd.g_old_rec.inelg_rsn_cd;

3714: ben_epo_shd.g_old_rec.ovrid_svc_dt;
3715: End If;
3716: If (p_rec.inelg_rsn_cd = hr_api.g_varchar2) then
3717: p_rec.inelg_rsn_cd :=
3718: ben_epo_shd.g_old_rec.inelg_rsn_cd;
3719: End If;
3720: If (p_rec.once_r_cntug_cd = hr_api.g_varchar2) then
3721: p_rec.once_r_cntug_cd :=
3722: ben_epo_shd.g_old_rec.once_r_cntug_cd;

Line 3722: ben_epo_shd.g_old_rec.once_r_cntug_cd;

3718: ben_epo_shd.g_old_rec.inelg_rsn_cd;
3719: End If;
3720: If (p_rec.once_r_cntug_cd = hr_api.g_varchar2) then
3721: p_rec.once_r_cntug_cd :=
3722: ben_epo_shd.g_old_rec.once_r_cntug_cd;
3723: End If;
3724: If (p_rec.oipl_ordr_num = hr_api.g_number) then
3725: p_rec.oipl_ordr_num :=
3726: ben_epo_shd.g_old_rec.oipl_ordr_num;

Line 3726: ben_epo_shd.g_old_rec.oipl_ordr_num;

3722: ben_epo_shd.g_old_rec.once_r_cntug_cd;
3723: End If;
3724: If (p_rec.oipl_ordr_num = hr_api.g_number) then
3725: p_rec.oipl_ordr_num :=
3726: ben_epo_shd.g_old_rec.oipl_ordr_num;
3727: End If;
3728: If (p_rec.business_group_id = hr_api.g_number) then
3729: p_rec.business_group_id :=
3730: ben_epo_shd.g_old_rec.business_group_id;

Line 3730: ben_epo_shd.g_old_rec.business_group_id;

3726: ben_epo_shd.g_old_rec.oipl_ordr_num;
3727: End If;
3728: If (p_rec.business_group_id = hr_api.g_number) then
3729: p_rec.business_group_id :=
3730: ben_epo_shd.g_old_rec.business_group_id;
3731: End If;
3732: If (p_rec.epo_attribute_category = hr_api.g_varchar2) then
3733: p_rec.epo_attribute_category :=
3734: ben_epo_shd.g_old_rec.epo_attribute_category;

Line 3734: ben_epo_shd.g_old_rec.epo_attribute_category;

3730: ben_epo_shd.g_old_rec.business_group_id;
3731: End If;
3732: If (p_rec.epo_attribute_category = hr_api.g_varchar2) then
3733: p_rec.epo_attribute_category :=
3734: ben_epo_shd.g_old_rec.epo_attribute_category;
3735: End If;
3736: If (p_rec.epo_attribute1 = hr_api.g_varchar2) then
3737: p_rec.epo_attribute1 :=
3738: ben_epo_shd.g_old_rec.epo_attribute1;

Line 3738: ben_epo_shd.g_old_rec.epo_attribute1;

3734: ben_epo_shd.g_old_rec.epo_attribute_category;
3735: End If;
3736: If (p_rec.epo_attribute1 = hr_api.g_varchar2) then
3737: p_rec.epo_attribute1 :=
3738: ben_epo_shd.g_old_rec.epo_attribute1;
3739: End If;
3740: If (p_rec.epo_attribute2 = hr_api.g_varchar2) then
3741: p_rec.epo_attribute2 :=
3742: ben_epo_shd.g_old_rec.epo_attribute2;

Line 3742: ben_epo_shd.g_old_rec.epo_attribute2;

3738: ben_epo_shd.g_old_rec.epo_attribute1;
3739: End If;
3740: If (p_rec.epo_attribute2 = hr_api.g_varchar2) then
3741: p_rec.epo_attribute2 :=
3742: ben_epo_shd.g_old_rec.epo_attribute2;
3743: End If;
3744: If (p_rec.epo_attribute3 = hr_api.g_varchar2) then
3745: p_rec.epo_attribute3 :=
3746: ben_epo_shd.g_old_rec.epo_attribute3;

Line 3746: ben_epo_shd.g_old_rec.epo_attribute3;

3742: ben_epo_shd.g_old_rec.epo_attribute2;
3743: End If;
3744: If (p_rec.epo_attribute3 = hr_api.g_varchar2) then
3745: p_rec.epo_attribute3 :=
3746: ben_epo_shd.g_old_rec.epo_attribute3;
3747: End If;
3748: If (p_rec.epo_attribute4 = hr_api.g_varchar2) then
3749: p_rec.epo_attribute4 :=
3750: ben_epo_shd.g_old_rec.epo_attribute4;

Line 3750: ben_epo_shd.g_old_rec.epo_attribute4;

3746: ben_epo_shd.g_old_rec.epo_attribute3;
3747: End If;
3748: If (p_rec.epo_attribute4 = hr_api.g_varchar2) then
3749: p_rec.epo_attribute4 :=
3750: ben_epo_shd.g_old_rec.epo_attribute4;
3751: End If;
3752: If (p_rec.epo_attribute5 = hr_api.g_varchar2) then
3753: p_rec.epo_attribute5 :=
3754: ben_epo_shd.g_old_rec.epo_attribute5;

Line 3754: ben_epo_shd.g_old_rec.epo_attribute5;

3750: ben_epo_shd.g_old_rec.epo_attribute4;
3751: End If;
3752: If (p_rec.epo_attribute5 = hr_api.g_varchar2) then
3753: p_rec.epo_attribute5 :=
3754: ben_epo_shd.g_old_rec.epo_attribute5;
3755: End If;
3756: If (p_rec.epo_attribute6 = hr_api.g_varchar2) then
3757: p_rec.epo_attribute6 :=
3758: ben_epo_shd.g_old_rec.epo_attribute6;

Line 3758: ben_epo_shd.g_old_rec.epo_attribute6;

3754: ben_epo_shd.g_old_rec.epo_attribute5;
3755: End If;
3756: If (p_rec.epo_attribute6 = hr_api.g_varchar2) then
3757: p_rec.epo_attribute6 :=
3758: ben_epo_shd.g_old_rec.epo_attribute6;
3759: End If;
3760: If (p_rec.epo_attribute7 = hr_api.g_varchar2) then
3761: p_rec.epo_attribute7 :=
3762: ben_epo_shd.g_old_rec.epo_attribute7;

Line 3762: ben_epo_shd.g_old_rec.epo_attribute7;

3758: ben_epo_shd.g_old_rec.epo_attribute6;
3759: End If;
3760: If (p_rec.epo_attribute7 = hr_api.g_varchar2) then
3761: p_rec.epo_attribute7 :=
3762: ben_epo_shd.g_old_rec.epo_attribute7;
3763: End If;
3764: If (p_rec.epo_attribute8 = hr_api.g_varchar2) then
3765: p_rec.epo_attribute8 :=
3766: ben_epo_shd.g_old_rec.epo_attribute8;

Line 3766: ben_epo_shd.g_old_rec.epo_attribute8;

3762: ben_epo_shd.g_old_rec.epo_attribute7;
3763: End If;
3764: If (p_rec.epo_attribute8 = hr_api.g_varchar2) then
3765: p_rec.epo_attribute8 :=
3766: ben_epo_shd.g_old_rec.epo_attribute8;
3767: End If;
3768: If (p_rec.epo_attribute9 = hr_api.g_varchar2) then
3769: p_rec.epo_attribute9 :=
3770: ben_epo_shd.g_old_rec.epo_attribute9;

Line 3770: ben_epo_shd.g_old_rec.epo_attribute9;

3766: ben_epo_shd.g_old_rec.epo_attribute8;
3767: End If;
3768: If (p_rec.epo_attribute9 = hr_api.g_varchar2) then
3769: p_rec.epo_attribute9 :=
3770: ben_epo_shd.g_old_rec.epo_attribute9;
3771: End If;
3772: If (p_rec.epo_attribute10 = hr_api.g_varchar2) then
3773: p_rec.epo_attribute10 :=
3774: ben_epo_shd.g_old_rec.epo_attribute10;

Line 3774: ben_epo_shd.g_old_rec.epo_attribute10;

3770: ben_epo_shd.g_old_rec.epo_attribute9;
3771: End If;
3772: If (p_rec.epo_attribute10 = hr_api.g_varchar2) then
3773: p_rec.epo_attribute10 :=
3774: ben_epo_shd.g_old_rec.epo_attribute10;
3775: End If;
3776: If (p_rec.epo_attribute11 = hr_api.g_varchar2) then
3777: p_rec.epo_attribute11 :=
3778: ben_epo_shd.g_old_rec.epo_attribute11;

Line 3778: ben_epo_shd.g_old_rec.epo_attribute11;

3774: ben_epo_shd.g_old_rec.epo_attribute10;
3775: End If;
3776: If (p_rec.epo_attribute11 = hr_api.g_varchar2) then
3777: p_rec.epo_attribute11 :=
3778: ben_epo_shd.g_old_rec.epo_attribute11;
3779: End If;
3780: If (p_rec.epo_attribute12 = hr_api.g_varchar2) then
3781: p_rec.epo_attribute12 :=
3782: ben_epo_shd.g_old_rec.epo_attribute12;

Line 3782: ben_epo_shd.g_old_rec.epo_attribute12;

3778: ben_epo_shd.g_old_rec.epo_attribute11;
3779: End If;
3780: If (p_rec.epo_attribute12 = hr_api.g_varchar2) then
3781: p_rec.epo_attribute12 :=
3782: ben_epo_shd.g_old_rec.epo_attribute12;
3783: End If;
3784: If (p_rec.epo_attribute13 = hr_api.g_varchar2) then
3785: p_rec.epo_attribute13 :=
3786: ben_epo_shd.g_old_rec.epo_attribute13;

Line 3786: ben_epo_shd.g_old_rec.epo_attribute13;

3782: ben_epo_shd.g_old_rec.epo_attribute12;
3783: End If;
3784: If (p_rec.epo_attribute13 = hr_api.g_varchar2) then
3785: p_rec.epo_attribute13 :=
3786: ben_epo_shd.g_old_rec.epo_attribute13;
3787: End If;
3788: If (p_rec.epo_attribute14 = hr_api.g_varchar2) then
3789: p_rec.epo_attribute14 :=
3790: ben_epo_shd.g_old_rec.epo_attribute14;

Line 3790: ben_epo_shd.g_old_rec.epo_attribute14;

3786: ben_epo_shd.g_old_rec.epo_attribute13;
3787: End If;
3788: If (p_rec.epo_attribute14 = hr_api.g_varchar2) then
3789: p_rec.epo_attribute14 :=
3790: ben_epo_shd.g_old_rec.epo_attribute14;
3791: End If;
3792: If (p_rec.epo_attribute15 = hr_api.g_varchar2) then
3793: p_rec.epo_attribute15 :=
3794: ben_epo_shd.g_old_rec.epo_attribute15;

Line 3794: ben_epo_shd.g_old_rec.epo_attribute15;

3790: ben_epo_shd.g_old_rec.epo_attribute14;
3791: End If;
3792: If (p_rec.epo_attribute15 = hr_api.g_varchar2) then
3793: p_rec.epo_attribute15 :=
3794: ben_epo_shd.g_old_rec.epo_attribute15;
3795: End If;
3796: If (p_rec.epo_attribute16 = hr_api.g_varchar2) then
3797: p_rec.epo_attribute16 :=
3798: ben_epo_shd.g_old_rec.epo_attribute16;

Line 3798: ben_epo_shd.g_old_rec.epo_attribute16;

3794: ben_epo_shd.g_old_rec.epo_attribute15;
3795: End If;
3796: If (p_rec.epo_attribute16 = hr_api.g_varchar2) then
3797: p_rec.epo_attribute16 :=
3798: ben_epo_shd.g_old_rec.epo_attribute16;
3799: End If;
3800: If (p_rec.epo_attribute17 = hr_api.g_varchar2) then
3801: p_rec.epo_attribute17 :=
3802: ben_epo_shd.g_old_rec.epo_attribute17;

Line 3802: ben_epo_shd.g_old_rec.epo_attribute17;

3798: ben_epo_shd.g_old_rec.epo_attribute16;
3799: End If;
3800: If (p_rec.epo_attribute17 = hr_api.g_varchar2) then
3801: p_rec.epo_attribute17 :=
3802: ben_epo_shd.g_old_rec.epo_attribute17;
3803: End If;
3804: If (p_rec.epo_attribute18 = hr_api.g_varchar2) then
3805: p_rec.epo_attribute18 :=
3806: ben_epo_shd.g_old_rec.epo_attribute18;

Line 3806: ben_epo_shd.g_old_rec.epo_attribute18;

3802: ben_epo_shd.g_old_rec.epo_attribute17;
3803: End If;
3804: If (p_rec.epo_attribute18 = hr_api.g_varchar2) then
3805: p_rec.epo_attribute18 :=
3806: ben_epo_shd.g_old_rec.epo_attribute18;
3807: End If;
3808: If (p_rec.epo_attribute19 = hr_api.g_varchar2) then
3809: p_rec.epo_attribute19 :=
3810: ben_epo_shd.g_old_rec.epo_attribute19;

Line 3810: ben_epo_shd.g_old_rec.epo_attribute19;

3806: ben_epo_shd.g_old_rec.epo_attribute18;
3807: End If;
3808: If (p_rec.epo_attribute19 = hr_api.g_varchar2) then
3809: p_rec.epo_attribute19 :=
3810: ben_epo_shd.g_old_rec.epo_attribute19;
3811: End If;
3812: If (p_rec.epo_attribute20 = hr_api.g_varchar2) then
3813: p_rec.epo_attribute20 :=
3814: ben_epo_shd.g_old_rec.epo_attribute20;

Line 3814: ben_epo_shd.g_old_rec.epo_attribute20;

3810: ben_epo_shd.g_old_rec.epo_attribute19;
3811: End If;
3812: If (p_rec.epo_attribute20 = hr_api.g_varchar2) then
3813: p_rec.epo_attribute20 :=
3814: ben_epo_shd.g_old_rec.epo_attribute20;
3815: End If;
3816: If (p_rec.epo_attribute21 = hr_api.g_varchar2) then
3817: p_rec.epo_attribute21 :=
3818: ben_epo_shd.g_old_rec.epo_attribute21;

Line 3818: ben_epo_shd.g_old_rec.epo_attribute21;

3814: ben_epo_shd.g_old_rec.epo_attribute20;
3815: End If;
3816: If (p_rec.epo_attribute21 = hr_api.g_varchar2) then
3817: p_rec.epo_attribute21 :=
3818: ben_epo_shd.g_old_rec.epo_attribute21;
3819: End If;
3820: If (p_rec.epo_attribute22 = hr_api.g_varchar2) then
3821: p_rec.epo_attribute22 :=
3822: ben_epo_shd.g_old_rec.epo_attribute22;

Line 3822: ben_epo_shd.g_old_rec.epo_attribute22;

3818: ben_epo_shd.g_old_rec.epo_attribute21;
3819: End If;
3820: If (p_rec.epo_attribute22 = hr_api.g_varchar2) then
3821: p_rec.epo_attribute22 :=
3822: ben_epo_shd.g_old_rec.epo_attribute22;
3823: End If;
3824: If (p_rec.epo_attribute23 = hr_api.g_varchar2) then
3825: p_rec.epo_attribute23 :=
3826: ben_epo_shd.g_old_rec.epo_attribute23;

Line 3826: ben_epo_shd.g_old_rec.epo_attribute23;

3822: ben_epo_shd.g_old_rec.epo_attribute22;
3823: End If;
3824: If (p_rec.epo_attribute23 = hr_api.g_varchar2) then
3825: p_rec.epo_attribute23 :=
3826: ben_epo_shd.g_old_rec.epo_attribute23;
3827: End If;
3828: If (p_rec.epo_attribute24 = hr_api.g_varchar2) then
3829: p_rec.epo_attribute24 :=
3830: ben_epo_shd.g_old_rec.epo_attribute24;

Line 3830: ben_epo_shd.g_old_rec.epo_attribute24;

3826: ben_epo_shd.g_old_rec.epo_attribute23;
3827: End If;
3828: If (p_rec.epo_attribute24 = hr_api.g_varchar2) then
3829: p_rec.epo_attribute24 :=
3830: ben_epo_shd.g_old_rec.epo_attribute24;
3831: End If;
3832: If (p_rec.epo_attribute25 = hr_api.g_varchar2) then
3833: p_rec.epo_attribute25 :=
3834: ben_epo_shd.g_old_rec.epo_attribute25;

Line 3834: ben_epo_shd.g_old_rec.epo_attribute25;

3830: ben_epo_shd.g_old_rec.epo_attribute24;
3831: End If;
3832: If (p_rec.epo_attribute25 = hr_api.g_varchar2) then
3833: p_rec.epo_attribute25 :=
3834: ben_epo_shd.g_old_rec.epo_attribute25;
3835: End If;
3836: If (p_rec.epo_attribute26 = hr_api.g_varchar2) then
3837: p_rec.epo_attribute26 :=
3838: ben_epo_shd.g_old_rec.epo_attribute26;

Line 3838: ben_epo_shd.g_old_rec.epo_attribute26;

3834: ben_epo_shd.g_old_rec.epo_attribute25;
3835: End If;
3836: If (p_rec.epo_attribute26 = hr_api.g_varchar2) then
3837: p_rec.epo_attribute26 :=
3838: ben_epo_shd.g_old_rec.epo_attribute26;
3839: End If;
3840: If (p_rec.epo_attribute27 = hr_api.g_varchar2) then
3841: p_rec.epo_attribute27 :=
3842: ben_epo_shd.g_old_rec.epo_attribute27;

Line 3842: ben_epo_shd.g_old_rec.epo_attribute27;

3838: ben_epo_shd.g_old_rec.epo_attribute26;
3839: End If;
3840: If (p_rec.epo_attribute27 = hr_api.g_varchar2) then
3841: p_rec.epo_attribute27 :=
3842: ben_epo_shd.g_old_rec.epo_attribute27;
3843: End If;
3844: If (p_rec.epo_attribute28 = hr_api.g_varchar2) then
3845: p_rec.epo_attribute28 :=
3846: ben_epo_shd.g_old_rec.epo_attribute28;

Line 3846: ben_epo_shd.g_old_rec.epo_attribute28;

3842: ben_epo_shd.g_old_rec.epo_attribute27;
3843: End If;
3844: If (p_rec.epo_attribute28 = hr_api.g_varchar2) then
3845: p_rec.epo_attribute28 :=
3846: ben_epo_shd.g_old_rec.epo_attribute28;
3847: End If;
3848: If (p_rec.epo_attribute29 = hr_api.g_varchar2) then
3849: p_rec.epo_attribute29 :=
3850: ben_epo_shd.g_old_rec.epo_attribute29;

Line 3850: ben_epo_shd.g_old_rec.epo_attribute29;

3846: ben_epo_shd.g_old_rec.epo_attribute28;
3847: End If;
3848: If (p_rec.epo_attribute29 = hr_api.g_varchar2) then
3849: p_rec.epo_attribute29 :=
3850: ben_epo_shd.g_old_rec.epo_attribute29;
3851: End If;
3852: If (p_rec.epo_attribute30 = hr_api.g_varchar2) then
3853: p_rec.epo_attribute30 :=
3854: ben_epo_shd.g_old_rec.epo_attribute30;

Line 3854: ben_epo_shd.g_old_rec.epo_attribute30;

3850: ben_epo_shd.g_old_rec.epo_attribute29;
3851: End If;
3852: If (p_rec.epo_attribute30 = hr_api.g_varchar2) then
3853: p_rec.epo_attribute30 :=
3854: ben_epo_shd.g_old_rec.epo_attribute30;
3855: End If;
3856: If (p_rec.request_id= hr_api.g_number) then
3857: p_rec.request_id :=
3858: ben_epo_shd.g_old_rec.request_id;

Line 3858: ben_epo_shd.g_old_rec.request_id;

3854: ben_epo_shd.g_old_rec.epo_attribute30;
3855: End If;
3856: If (p_rec.request_id= hr_api.g_number) then
3857: p_rec.request_id :=
3858: ben_epo_shd.g_old_rec.request_id;
3859: End If;
3860: If (p_rec.program_application_id = hr_api.g_number) then
3861: p_rec.program_application_id :=
3862: ben_epo_shd.g_old_rec.program_application_id;

Line 3862: ben_epo_shd.g_old_rec.program_application_id;

3858: ben_epo_shd.g_old_rec.request_id;
3859: End If;
3860: If (p_rec.program_application_id = hr_api.g_number) then
3861: p_rec.program_application_id :=
3862: ben_epo_shd.g_old_rec.program_application_id;
3863: End If;
3864: If (p_rec.program_id = hr_api.g_number) then
3865: p_rec.program_id :=
3866: ben_epo_shd.g_old_rec.program_id;

Line 3866: ben_epo_shd.g_old_rec.program_id;

3862: ben_epo_shd.g_old_rec.program_application_id;
3863: End If;
3864: If (p_rec.program_id = hr_api.g_number) then
3865: p_rec.program_id :=
3866: ben_epo_shd.g_old_rec.program_id;
3867: End If;
3868: If (p_rec.program_update_date = hr_api.g_date) then
3869: p_rec.program_update_date :=
3870: ben_epo_shd.g_old_rec.program_update_date;

Line 3870: ben_epo_shd.g_old_rec.program_update_date;

3866: ben_epo_shd.g_old_rec.program_id;
3867: End If;
3868: If (p_rec.program_update_date = hr_api.g_date) then
3869: p_rec.program_update_date :=
3870: ben_epo_shd.g_old_rec.program_update_date;
3871: End If;
3872:
3873: --
3874: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 3882: (p_rec in out nocopy ben_epo_shd.g_rec_type

3878: -- |----------------------------< dt_pre_update >-----------------------------|
3879: -- ----------------------------------------------------------------------------
3880: --
3881: Procedure dt_pre_update
3882: (p_rec in out nocopy ben_epo_shd.g_rec_type
3883: ,p_effective_date in date
3884: ,p_datetrack_mode in varchar2
3885: ,p_validation_start_date in date
3886: ,p_validation_end_date in date

Line 3900: ben_epo_shd.upd_effective_end_date

3896: hr_utility.set_location(l_proc, 10);
3897: --
3898: -- Update the current effective end date
3899: --
3900: ben_epo_shd.upd_effective_end_date
3901: (p_effective_date => p_effective_date,
3902: p_base_key_value => p_rec.elig_per_opt_id,
3903: p_new_effective_end_date => (p_validation_start_date - 1),
3904: p_validation_start_date => p_validation_start_date,

Line 3939: (p_rec in out nocopy ben_epo_shd.g_rec_type

3935: -- ----------------------------------------------------------------------------
3936: -- |------------------------------< pre_update >------------------------------|
3937: -- ----------------------------------------------------------------------------
3938: Procedure pre_update
3939: (p_rec in out nocopy ben_epo_shd.g_rec_type
3940: ,p_effective_date in date
3941: ,p_datetrack_mode in varchar2
3942: ,p_validation_start_date in date
3943: ,p_validation_end_date in date

Line 3968: (p_rec in out nocopy ben_epo_shd.g_rec_type

3964: -- |----------------------------< dt_update_dml >-----------------------------|
3965: -- ----------------------------------------------------------------------------
3966: --
3967: Procedure dt_update_dml
3968: (p_rec in out nocopy ben_epo_shd.g_rec_type
3969: ,p_effective_date in date
3970: ,p_datetrack_mode in varchar2
3971: ,p_validation_start_date in date
3972: ,p_validation_end_date in date

Line 3993: ben_epo_shd.g_api_dml := true; -- Set the api dml status

3989: (p_base_table_name => 'ben_elig_per_opt_f',
3990: p_base_key_column => 'elig_per_opt_id',
3991: p_base_key_value => p_rec.elig_per_opt_id);
3992: --
3993: ben_epo_shd.g_api_dml := true; -- Set the api dml status
3994: --
3995: -- Update the ben_elig_per_opt_f Row
3996: --
3997: update ben_elig_per_opt_f

Line 4090: ben_epo_shd.g_api_dml := false; -- Unset the api dml status

4086: where elig_per_opt_id = p_rec.elig_per_opt_id
4087: and effective_start_date = p_validation_start_date
4088: and effective_end_date = p_validation_end_date;
4089: --
4090: ben_epo_shd.g_api_dml := false; -- Unset the api dml status
4091: --
4092: -- Set the effective start and end dates
4093: --
4094: p_rec.effective_start_date := p_validation_start_date;

Line 4102: ben_epo_shd.g_api_dml := false; -- Unset the api dml status

4098: hr_utility.set_location(' Leaving:'||l_proc, 15);
4099: Exception
4100: When hr_api.check_integrity_violated Then
4101: -- A check constraint has been violated
4102: ben_epo_shd.g_api_dml := false; -- Unset the api dml status
4103: ben_epo_shd.constraint_error
4104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
4105: When hr_api.unique_integrity_violated Then
4106: -- Unique integrity has been violated

Line 4103: ben_epo_shd.constraint_error

4099: Exception
4100: When hr_api.check_integrity_violated Then
4101: -- A check constraint has been violated
4102: ben_epo_shd.g_api_dml := false; -- Unset the api dml status
4103: ben_epo_shd.constraint_error
4104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
4105: When hr_api.unique_integrity_violated Then
4106: -- Unique integrity has been violated
4107: ben_epo_shd.g_api_dml := false; -- Unset the api dml status

Line 4107: ben_epo_shd.g_api_dml := false; -- Unset the api dml status

4103: ben_epo_shd.constraint_error
4104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
4105: When hr_api.unique_integrity_violated Then
4106: -- Unique integrity has been violated
4107: ben_epo_shd.g_api_dml := false; -- Unset the api dml status
4108: ben_epo_shd.constraint_error
4109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
4110: When Others Then
4111: ben_epo_shd.g_api_dml := false; -- Unset the api dml status

Line 4108: ben_epo_shd.constraint_error

4104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
4105: When hr_api.unique_integrity_violated Then
4106: -- Unique integrity has been violated
4107: ben_epo_shd.g_api_dml := false; -- Unset the api dml status
4108: ben_epo_shd.constraint_error
4109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
4110: When Others Then
4111: ben_epo_shd.g_api_dml := false; -- Unset the api dml status
4112: Raise;

Line 4111: ben_epo_shd.g_api_dml := false; -- Unset the api dml status

4107: ben_epo_shd.g_api_dml := false; -- Unset the api dml status
4108: ben_epo_shd.constraint_error
4109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
4110: When Others Then
4111: ben_epo_shd.g_api_dml := false; -- Unset the api dml status
4112: Raise;
4113: End dt_update_dml;
4114: --
4115: -- ----------------------------------------------------------------------------

Line 4120: (p_rec in out nocopy ben_epo_shd.g_rec_type

4116: -- |------------------------------< update_dml >------------------------------|
4117: -- ----------------------------------------------------------------------------
4118: --
4119: Procedure update_dml
4120: (p_rec in out nocopy ben_epo_shd.g_rec_type
4121: ,p_effective_date in date
4122: ,p_datetrack_mode in varchar2
4123: ,p_validation_start_date in date
4124: ,p_validation_end_date in date

Line 4146: (p_rec in out nocopy ben_epo_shd.g_rec_type

4142: -- ----------------------------------------------------------------------------
4143: -- |---------------------------------< upd >----------------------------------|
4144: -- ----------------------------------------------------------------------------
4145: Procedure upd
4146: (p_rec in out nocopy ben_epo_shd.g_rec_type
4147: ,p_effective_date in date
4148: ,p_datetrack_mode in varchar2
4149: )
4150: is

Line 4181: 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

4177: --
4178: if ben_manage_life_events.g_modified_mode in ('U','S','D') then
4179: -- compare the values and if there is no difference come out
4180: if (
4181: 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
4182: nvl(p_rec.opt_id,-1) <> nvl(ben_epo_shd.g_old_rec.opt_id,-1) or
4183: nvl(p_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy'))<>
4184: nvl(ben_epo_shd.g_old_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy')) or
4185: nvl(p_rec.elig_flag,'N') <> nvl(ben_epo_shd.g_old_rec.elig_flag,'N') or

Line 4182: nvl(p_rec.opt_id,-1) <> nvl(ben_epo_shd.g_old_rec.opt_id,-1) or

4178: if ben_manage_life_events.g_modified_mode in ('U','S','D') then
4179: -- compare the values and if there is no difference come out
4180: if (
4181: 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
4182: nvl(p_rec.opt_id,-1) <> nvl(ben_epo_shd.g_old_rec.opt_id,-1) or
4183: nvl(p_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy'))<>
4184: nvl(ben_epo_shd.g_old_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy')) or
4185: nvl(p_rec.elig_flag,'N') <> nvl(ben_epo_shd.g_old_rec.elig_flag,'N') or
4186: nvl(p_rec.comp_ref_amt,-1) <> nvl(ben_epo_shd.g_old_rec.comp_ref_amt,-1) or

Line 4184: nvl(ben_epo_shd.g_old_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy')) or

4180: if (
4181: 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
4182: nvl(p_rec.opt_id,-1) <> nvl(ben_epo_shd.g_old_rec.opt_id,-1) or
4183: nvl(p_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy'))<>
4184: nvl(ben_epo_shd.g_old_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy')) or
4185: nvl(p_rec.elig_flag,'N') <> nvl(ben_epo_shd.g_old_rec.elig_flag,'N') or
4186: nvl(p_rec.comp_ref_amt,-1) <> nvl(ben_epo_shd.g_old_rec.comp_ref_amt,-1) or
4187: nvl(p_rec.cmbn_age_n_los_val, -1) <> nvl(ben_epo_shd.g_old_rec.cmbn_age_n_los_val, -1) or
4188: nvl(p_rec.comp_ref_uom,'X') <> nvl(ben_epo_shd.g_old_rec.comp_ref_uom,'X') or

Line 4185: nvl(p_rec.elig_flag,'N') <> nvl(ben_epo_shd.g_old_rec.elig_flag,'N') or

4181: 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
4182: nvl(p_rec.opt_id,-1) <> nvl(ben_epo_shd.g_old_rec.opt_id,-1) or
4183: nvl(p_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy'))<>
4184: nvl(ben_epo_shd.g_old_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy')) or
4185: nvl(p_rec.elig_flag,'N') <> nvl(ben_epo_shd.g_old_rec.elig_flag,'N') or
4186: nvl(p_rec.comp_ref_amt,-1) <> nvl(ben_epo_shd.g_old_rec.comp_ref_amt,-1) or
4187: nvl(p_rec.cmbn_age_n_los_val, -1) <> nvl(ben_epo_shd.g_old_rec.cmbn_age_n_los_val, -1) or
4188: nvl(p_rec.comp_ref_uom,'X') <> nvl(ben_epo_shd.g_old_rec.comp_ref_uom,'X') or
4189: nvl(p_rec.age_val, -1) <> nvl(ben_epo_shd.g_old_rec.age_val, -1) or

Line 4186: nvl(p_rec.comp_ref_amt,-1) <> nvl(ben_epo_shd.g_old_rec.comp_ref_amt,-1) or

4182: nvl(p_rec.opt_id,-1) <> nvl(ben_epo_shd.g_old_rec.opt_id,-1) or
4183: nvl(p_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy'))<>
4184: nvl(ben_epo_shd.g_old_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy')) or
4185: nvl(p_rec.elig_flag,'N') <> nvl(ben_epo_shd.g_old_rec.elig_flag,'N') or
4186: nvl(p_rec.comp_ref_amt,-1) <> nvl(ben_epo_shd.g_old_rec.comp_ref_amt,-1) or
4187: nvl(p_rec.cmbn_age_n_los_val, -1) <> nvl(ben_epo_shd.g_old_rec.cmbn_age_n_los_val, -1) or
4188: nvl(p_rec.comp_ref_uom,'X') <> nvl(ben_epo_shd.g_old_rec.comp_ref_uom,'X') or
4189: nvl(p_rec.age_val, -1) <> nvl(ben_epo_shd.g_old_rec.age_val, -1) or
4190: nvl(p_rec.los_val, -1) <> nvl(ben_epo_shd.g_old_rec.los_val, -1) or

Line 4187: nvl(p_rec.cmbn_age_n_los_val, -1) <> nvl(ben_epo_shd.g_old_rec.cmbn_age_n_los_val, -1) or

4183: nvl(p_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy'))<>
4184: nvl(ben_epo_shd.g_old_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy')) or
4185: nvl(p_rec.elig_flag,'N') <> nvl(ben_epo_shd.g_old_rec.elig_flag,'N') or
4186: nvl(p_rec.comp_ref_amt,-1) <> nvl(ben_epo_shd.g_old_rec.comp_ref_amt,-1) or
4187: nvl(p_rec.cmbn_age_n_los_val, -1) <> nvl(ben_epo_shd.g_old_rec.cmbn_age_n_los_val, -1) or
4188: nvl(p_rec.comp_ref_uom,'X') <> nvl(ben_epo_shd.g_old_rec.comp_ref_uom,'X') or
4189: nvl(p_rec.age_val, -1) <> nvl(ben_epo_shd.g_old_rec.age_val, -1) or
4190: nvl(p_rec.los_val, -1) <> nvl(ben_epo_shd.g_old_rec.los_val, -1) or
4191: nvl(p_rec.prtn_end_dt,to_date('01-01-1001','dd-mm-yyyy')) <>

Line 4188: nvl(p_rec.comp_ref_uom,'X') <> nvl(ben_epo_shd.g_old_rec.comp_ref_uom,'X') or

4184: nvl(ben_epo_shd.g_old_rec.prtn_ovridn_thru_dt,to_date('01-01-1001','dd-mm-yyyy')) or
4185: nvl(p_rec.elig_flag,'N') <> nvl(ben_epo_shd.g_old_rec.elig_flag,'N') or
4186: nvl(p_rec.comp_ref_amt,-1) <> nvl(ben_epo_shd.g_old_rec.comp_ref_amt,-1) or
4187: nvl(p_rec.cmbn_age_n_los_val, -1) <> nvl(ben_epo_shd.g_old_rec.cmbn_age_n_los_val, -1) or
4188: nvl(p_rec.comp_ref_uom,'X') <> nvl(ben_epo_shd.g_old_rec.comp_ref_uom,'X') or
4189: nvl(p_rec.age_val, -1) <> nvl(ben_epo_shd.g_old_rec.age_val, -1) or
4190: nvl(p_rec.los_val, -1) <> nvl(ben_epo_shd.g_old_rec.los_val, -1) or
4191: nvl(p_rec.prtn_end_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
4192: nvl(ben_epo_shd.g_old_rec.prtn_end_dt,to_date('01-01-1001','dd-mm-yyyy')) or

Line 4189: nvl(p_rec.age_val, -1) <> nvl(ben_epo_shd.g_old_rec.age_val, -1) or

4185: nvl(p_rec.elig_flag,'N') <> nvl(ben_epo_shd.g_old_rec.elig_flag,'N') or
4186: nvl(p_rec.comp_ref_amt,-1) <> nvl(ben_epo_shd.g_old_rec.comp_ref_amt,-1) or
4187: nvl(p_rec.cmbn_age_n_los_val, -1) <> nvl(ben_epo_shd.g_old_rec.cmbn_age_n_los_val, -1) or
4188: nvl(p_rec.comp_ref_uom,'X') <> nvl(ben_epo_shd.g_old_rec.comp_ref_uom,'X') or
4189: nvl(p_rec.age_val, -1) <> nvl(ben_epo_shd.g_old_rec.age_val, -1) or
4190: nvl(p_rec.los_val, -1) <> nvl(ben_epo_shd.g_old_rec.los_val, -1) or
4191: nvl(p_rec.prtn_end_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
4192: nvl(ben_epo_shd.g_old_rec.prtn_end_dt,to_date('01-01-1001','dd-mm-yyyy')) or
4193: nvl(p_rec.wait_perd_cmpltn_date,to_date('01-01-1001','dd-mm-yyyy')) <>

Line 4190: nvl(p_rec.los_val, -1) <> nvl(ben_epo_shd.g_old_rec.los_val, -1) or

4186: nvl(p_rec.comp_ref_amt,-1) <> nvl(ben_epo_shd.g_old_rec.comp_ref_amt,-1) or
4187: nvl(p_rec.cmbn_age_n_los_val, -1) <> nvl(ben_epo_shd.g_old_rec.cmbn_age_n_los_val, -1) or
4188: nvl(p_rec.comp_ref_uom,'X') <> nvl(ben_epo_shd.g_old_rec.comp_ref_uom,'X') or
4189: nvl(p_rec.age_val, -1) <> nvl(ben_epo_shd.g_old_rec.age_val, -1) or
4190: nvl(p_rec.los_val, -1) <> nvl(ben_epo_shd.g_old_rec.los_val, -1) or
4191: nvl(p_rec.prtn_end_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
4192: nvl(ben_epo_shd.g_old_rec.prtn_end_dt,to_date('01-01-1001','dd-mm-yyyy')) or
4193: nvl(p_rec.wait_perd_cmpltn_date,to_date('01-01-1001','dd-mm-yyyy')) <>
4194: nvl(ben_epo_shd.g_old_rec.wait_perd_cmpltn_date,to_date('01-01-1001','dd-mm-yyyy')) or

Line 4192: nvl(ben_epo_shd.g_old_rec.prtn_end_dt,to_date('01-01-1001','dd-mm-yyyy')) or

4188: nvl(p_rec.comp_ref_uom,'X') <> nvl(ben_epo_shd.g_old_rec.comp_ref_uom,'X') or
4189: nvl(p_rec.age_val, -1) <> nvl(ben_epo_shd.g_old_rec.age_val, -1) or
4190: nvl(p_rec.los_val, -1) <> nvl(ben_epo_shd.g_old_rec.los_val, -1) or
4191: nvl(p_rec.prtn_end_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
4192: nvl(ben_epo_shd.g_old_rec.prtn_end_dt,to_date('01-01-1001','dd-mm-yyyy')) or
4193: nvl(p_rec.wait_perd_cmpltn_date,to_date('01-01-1001','dd-mm-yyyy')) <>
4194: nvl(ben_epo_shd.g_old_rec.wait_perd_cmpltn_date,to_date('01-01-1001','dd-mm-yyyy')) or
4195: nvl(p_rec.wait_perd_strt_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
4196: nvl(ben_epo_shd.g_old_rec.wait_perd_strt_dt,to_date('01-01-1001','dd-mm-yyyy')) or

Line 4194: nvl(ben_epo_shd.g_old_rec.wait_perd_cmpltn_date,to_date('01-01-1001','dd-mm-yyyy')) or

4190: nvl(p_rec.los_val, -1) <> nvl(ben_epo_shd.g_old_rec.los_val, -1) or
4191: nvl(p_rec.prtn_end_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
4192: nvl(ben_epo_shd.g_old_rec.prtn_end_dt,to_date('01-01-1001','dd-mm-yyyy')) or
4193: nvl(p_rec.wait_perd_cmpltn_date,to_date('01-01-1001','dd-mm-yyyy')) <>
4194: nvl(ben_epo_shd.g_old_rec.wait_perd_cmpltn_date,to_date('01-01-1001','dd-mm-yyyy')) or
4195: nvl(p_rec.wait_perd_strt_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
4196: nvl(ben_epo_shd.g_old_rec.wait_perd_strt_dt,to_date('01-01-1001','dd-mm-yyyy')) or
4197: nvl(p_rec.hrs_wkd_val,-1) <> nvl(ben_epo_shd.g_old_rec.hrs_wkd_val,-1) or
4198: nvl(p_rec.hrs_wkd_bndry_perd_cd,'X') <> nvl(ben_epo_shd.g_old_rec.hrs_wkd_bndry_perd_cd,'X') or

Line 4196: nvl(ben_epo_shd.g_old_rec.wait_perd_strt_dt,to_date('01-01-1001','dd-mm-yyyy')) or

4192: nvl(ben_epo_shd.g_old_rec.prtn_end_dt,to_date('01-01-1001','dd-mm-yyyy')) or
4193: nvl(p_rec.wait_perd_cmpltn_date,to_date('01-01-1001','dd-mm-yyyy')) <>
4194: nvl(ben_epo_shd.g_old_rec.wait_perd_cmpltn_date,to_date('01-01-1001','dd-mm-yyyy')) or
4195: nvl(p_rec.wait_perd_strt_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
4196: nvl(ben_epo_shd.g_old_rec.wait_perd_strt_dt,to_date('01-01-1001','dd-mm-yyyy')) or
4197: nvl(p_rec.hrs_wkd_val,-1) <> nvl(ben_epo_shd.g_old_rec.hrs_wkd_val,-1) or
4198: nvl(p_rec.hrs_wkd_bndry_perd_cd,'X') <> nvl(ben_epo_shd.g_old_rec.hrs_wkd_bndry_perd_cd,'X') or
4199: nvl(p_rec.prtn_ovridn_flag,'N') <> nvl(ben_epo_shd.g_old_rec.prtn_ovridn_flag,'N') or
4200: nvl(p_rec.no_mx_prtn_ovrid_thru_flag,'N') <>

Line 4197: nvl(p_rec.hrs_wkd_val,-1) <> nvl(ben_epo_shd.g_old_rec.hrs_wkd_val,-1) or

4193: nvl(p_rec.wait_perd_cmpltn_date,to_date('01-01-1001','dd-mm-yyyy')) <>
4194: nvl(ben_epo_shd.g_old_rec.wait_perd_cmpltn_date,to_date('01-01-1001','dd-mm-yyyy')) or
4195: nvl(p_rec.wait_perd_strt_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
4196: nvl(ben_epo_shd.g_old_rec.wait_perd_strt_dt,to_date('01-01-1001','dd-mm-yyyy')) or
4197: nvl(p_rec.hrs_wkd_val,-1) <> nvl(ben_epo_shd.g_old_rec.hrs_wkd_val,-1) or
4198: nvl(p_rec.hrs_wkd_bndry_perd_cd,'X') <> nvl(ben_epo_shd.g_old_rec.hrs_wkd_bndry_perd_cd,'X') or
4199: nvl(p_rec.prtn_ovridn_flag,'N') <> nvl(ben_epo_shd.g_old_rec.prtn_ovridn_flag,'N') or
4200: nvl(p_rec.no_mx_prtn_ovrid_thru_flag,'N') <>
4201: nvl(ben_epo_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag,'N') or

Line 4198: nvl(p_rec.hrs_wkd_bndry_perd_cd,'X') <> nvl(ben_epo_shd.g_old_rec.hrs_wkd_bndry_perd_cd,'X') or

4194: nvl(ben_epo_shd.g_old_rec.wait_perd_cmpltn_date,to_date('01-01-1001','dd-mm-yyyy')) or
4195: nvl(p_rec.wait_perd_strt_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
4196: nvl(ben_epo_shd.g_old_rec.wait_perd_strt_dt,to_date('01-01-1001','dd-mm-yyyy')) or
4197: nvl(p_rec.hrs_wkd_val,-1) <> nvl(ben_epo_shd.g_old_rec.hrs_wkd_val,-1) or
4198: nvl(p_rec.hrs_wkd_bndry_perd_cd,'X') <> nvl(ben_epo_shd.g_old_rec.hrs_wkd_bndry_perd_cd,'X') or
4199: nvl(p_rec.prtn_ovridn_flag,'N') <> nvl(ben_epo_shd.g_old_rec.prtn_ovridn_flag,'N') or
4200: nvl(p_rec.no_mx_prtn_ovrid_thru_flag,'N') <>
4201: nvl(ben_epo_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag,'N') or
4202: nvl(p_rec.prtn_ovridn_rsn_cd, 'X') <>

Line 4199: nvl(p_rec.prtn_ovridn_flag,'N') <> nvl(ben_epo_shd.g_old_rec.prtn_ovridn_flag,'N') or

4195: nvl(p_rec.wait_perd_strt_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
4196: nvl(ben_epo_shd.g_old_rec.wait_perd_strt_dt,to_date('01-01-1001','dd-mm-yyyy')) or
4197: nvl(p_rec.hrs_wkd_val,-1) <> nvl(ben_epo_shd.g_old_rec.hrs_wkd_val,-1) or
4198: nvl(p_rec.hrs_wkd_bndry_perd_cd,'X') <> nvl(ben_epo_shd.g_old_rec.hrs_wkd_bndry_perd_cd,'X') or
4199: nvl(p_rec.prtn_ovridn_flag,'N') <> nvl(ben_epo_shd.g_old_rec.prtn_ovridn_flag,'N') or
4200: nvl(p_rec.no_mx_prtn_ovrid_thru_flag,'N') <>
4201: nvl(ben_epo_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag,'N') or
4202: nvl(p_rec.prtn_ovridn_rsn_cd, 'X') <>
4203: nvl(ben_epo_shd.g_old_rec.prtn_ovridn_rsn_cd, 'X') or

Line 4201: nvl(ben_epo_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag,'N') or

4197: nvl(p_rec.hrs_wkd_val,-1) <> nvl(ben_epo_shd.g_old_rec.hrs_wkd_val,-1) or
4198: nvl(p_rec.hrs_wkd_bndry_perd_cd,'X') <> nvl(ben_epo_shd.g_old_rec.hrs_wkd_bndry_perd_cd,'X') or
4199: nvl(p_rec.prtn_ovridn_flag,'N') <> nvl(ben_epo_shd.g_old_rec.prtn_ovridn_flag,'N') or
4200: nvl(p_rec.no_mx_prtn_ovrid_thru_flag,'N') <>
4201: nvl(ben_epo_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag,'N') or
4202: nvl(p_rec.prtn_ovridn_rsn_cd, 'X') <>
4203: nvl(ben_epo_shd.g_old_rec.prtn_ovridn_rsn_cd, 'X') or
4204: nvl(p_rec.age_uom,'X') <> nvl(ben_epo_shd.g_old_rec.age_uom,'X') or
4205: nvl(p_rec.los_uom,'X') <> nvl(ben_epo_shd.g_old_rec.los_uom,'X') or

Line 4203: nvl(ben_epo_shd.g_old_rec.prtn_ovridn_rsn_cd, 'X') or

4199: nvl(p_rec.prtn_ovridn_flag,'N') <> nvl(ben_epo_shd.g_old_rec.prtn_ovridn_flag,'N') or
4200: nvl(p_rec.no_mx_prtn_ovrid_thru_flag,'N') <>
4201: nvl(ben_epo_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag,'N') or
4202: nvl(p_rec.prtn_ovridn_rsn_cd, 'X') <>
4203: nvl(ben_epo_shd.g_old_rec.prtn_ovridn_rsn_cd, 'X') or
4204: nvl(p_rec.age_uom,'X') <> nvl(ben_epo_shd.g_old_rec.age_uom,'X') or
4205: nvl(p_rec.los_uom,'X') <> nvl(ben_epo_shd.g_old_rec.los_uom,'X') or
4206: nvl(p_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
4207: nvl(ben_epo_shd.g_old_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) or

Line 4204: nvl(p_rec.age_uom,'X') <> nvl(ben_epo_shd.g_old_rec.age_uom,'X') or

4200: nvl(p_rec.no_mx_prtn_ovrid_thru_flag,'N') <>
4201: nvl(ben_epo_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag,'N') or
4202: nvl(p_rec.prtn_ovridn_rsn_cd, 'X') <>
4203: nvl(ben_epo_shd.g_old_rec.prtn_ovridn_rsn_cd, 'X') or
4204: nvl(p_rec.age_uom,'X') <> nvl(ben_epo_shd.g_old_rec.age_uom,'X') or
4205: nvl(p_rec.los_uom,'X') <> nvl(ben_epo_shd.g_old_rec.los_uom,'X') or
4206: nvl(p_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
4207: nvl(ben_epo_shd.g_old_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) or
4208: nvl(p_rec.inelg_rsn_cd,'X') <> nvl(ben_epo_shd.g_old_rec.inelg_rsn_cd,'X') or

Line 4205: nvl(p_rec.los_uom,'X') <> nvl(ben_epo_shd.g_old_rec.los_uom,'X') or

4201: nvl(ben_epo_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag,'N') or
4202: nvl(p_rec.prtn_ovridn_rsn_cd, 'X') <>
4203: nvl(ben_epo_shd.g_old_rec.prtn_ovridn_rsn_cd, 'X') or
4204: nvl(p_rec.age_uom,'X') <> nvl(ben_epo_shd.g_old_rec.age_uom,'X') or
4205: nvl(p_rec.los_uom,'X') <> nvl(ben_epo_shd.g_old_rec.los_uom,'X') or
4206: nvl(p_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
4207: nvl(ben_epo_shd.g_old_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) or
4208: nvl(p_rec.inelg_rsn_cd,'X') <> nvl(ben_epo_shd.g_old_rec.inelg_rsn_cd,'X') or
4209: nvl(p_rec.frz_los_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_los_flag,'N') or

Line 4207: nvl(ben_epo_shd.g_old_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) or

4203: nvl(ben_epo_shd.g_old_rec.prtn_ovridn_rsn_cd, 'X') or
4204: nvl(p_rec.age_uom,'X') <> nvl(ben_epo_shd.g_old_rec.age_uom,'X') or
4205: nvl(p_rec.los_uom,'X') <> nvl(ben_epo_shd.g_old_rec.los_uom,'X') or
4206: nvl(p_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
4207: nvl(ben_epo_shd.g_old_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) or
4208: nvl(p_rec.inelg_rsn_cd,'X') <> nvl(ben_epo_shd.g_old_rec.inelg_rsn_cd,'X') or
4209: nvl(p_rec.frz_los_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_los_flag,'N') or
4210: nvl(p_rec.frz_age_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_age_flag,'N') or
4211: nvl(p_rec.frz_cmp_lvl_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_cmp_lvl_flag,'N') or

Line 4208: nvl(p_rec.inelg_rsn_cd,'X') <> nvl(ben_epo_shd.g_old_rec.inelg_rsn_cd,'X') or

4204: nvl(p_rec.age_uom,'X') <> nvl(ben_epo_shd.g_old_rec.age_uom,'X') or
4205: nvl(p_rec.los_uom,'X') <> nvl(ben_epo_shd.g_old_rec.los_uom,'X') or
4206: nvl(p_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
4207: nvl(ben_epo_shd.g_old_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) or
4208: nvl(p_rec.inelg_rsn_cd,'X') <> nvl(ben_epo_shd.g_old_rec.inelg_rsn_cd,'X') or
4209: nvl(p_rec.frz_los_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_los_flag,'N') or
4210: nvl(p_rec.frz_age_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_age_flag,'N') or
4211: nvl(p_rec.frz_cmp_lvl_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_cmp_lvl_flag,'N') or
4212: nvl(p_rec.frz_pct_fl_tm_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_pct_fl_tm_flag,'N') or

Line 4209: nvl(p_rec.frz_los_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_los_flag,'N') or

4205: nvl(p_rec.los_uom,'X') <> nvl(ben_epo_shd.g_old_rec.los_uom,'X') or
4206: nvl(p_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
4207: nvl(ben_epo_shd.g_old_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) or
4208: nvl(p_rec.inelg_rsn_cd,'X') <> nvl(ben_epo_shd.g_old_rec.inelg_rsn_cd,'X') or
4209: nvl(p_rec.frz_los_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_los_flag,'N') or
4210: nvl(p_rec.frz_age_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_age_flag,'N') or
4211: nvl(p_rec.frz_cmp_lvl_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_cmp_lvl_flag,'N') or
4212: nvl(p_rec.frz_pct_fl_tm_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_pct_fl_tm_flag,'N') or
4213: nvl(p_rec.frz_hrs_wkd_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_hrs_wkd_flag,'N') or

Line 4210: nvl(p_rec.frz_age_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_age_flag,'N') or

4206: nvl(p_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) <>
4207: nvl(ben_epo_shd.g_old_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) or
4208: nvl(p_rec.inelg_rsn_cd,'X') <> nvl(ben_epo_shd.g_old_rec.inelg_rsn_cd,'X') or
4209: nvl(p_rec.frz_los_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_los_flag,'N') or
4210: nvl(p_rec.frz_age_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_age_flag,'N') or
4211: nvl(p_rec.frz_cmp_lvl_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_cmp_lvl_flag,'N') or
4212: nvl(p_rec.frz_pct_fl_tm_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_pct_fl_tm_flag,'N') or
4213: nvl(p_rec.frz_hrs_wkd_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_hrs_wkd_flag,'N') or
4214: 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

Line 4211: nvl(p_rec.frz_cmp_lvl_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_cmp_lvl_flag,'N') or

4207: nvl(ben_epo_shd.g_old_rec.ovrid_svc_dt,to_date('01-01-1001','dd-mm-yyyy')) or
4208: nvl(p_rec.inelg_rsn_cd,'X') <> nvl(ben_epo_shd.g_old_rec.inelg_rsn_cd,'X') or
4209: nvl(p_rec.frz_los_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_los_flag,'N') or
4210: nvl(p_rec.frz_age_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_age_flag,'N') or
4211: nvl(p_rec.frz_cmp_lvl_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_cmp_lvl_flag,'N') or
4212: nvl(p_rec.frz_pct_fl_tm_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_pct_fl_tm_flag,'N') or
4213: nvl(p_rec.frz_hrs_wkd_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_hrs_wkd_flag,'N') or
4214: 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
4215: nvl(p_rec.pct_fl_tm_val,-1) <> nvl(ben_epo_shd.g_old_rec.pct_fl_tm_val,-1) or

Line 4212: nvl(p_rec.frz_pct_fl_tm_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_pct_fl_tm_flag,'N') or

4208: nvl(p_rec.inelg_rsn_cd,'X') <> nvl(ben_epo_shd.g_old_rec.inelg_rsn_cd,'X') or
4209: nvl(p_rec.frz_los_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_los_flag,'N') or
4210: nvl(p_rec.frz_age_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_age_flag,'N') or
4211: nvl(p_rec.frz_cmp_lvl_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_cmp_lvl_flag,'N') or
4212: nvl(p_rec.frz_pct_fl_tm_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_pct_fl_tm_flag,'N') or
4213: nvl(p_rec.frz_hrs_wkd_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_hrs_wkd_flag,'N') or
4214: 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
4215: nvl(p_rec.pct_fl_tm_val,-1) <> nvl(ben_epo_shd.g_old_rec.pct_fl_tm_val,-1) or
4216: nvl(p_rec.rt_comp_ref_amt,-1) <> nvl(ben_epo_shd.g_old_rec.rt_comp_ref_amt,-1) or

Line 4213: nvl(p_rec.frz_hrs_wkd_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_hrs_wkd_flag,'N') or

4209: nvl(p_rec.frz_los_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_los_flag,'N') or
4210: nvl(p_rec.frz_age_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_age_flag,'N') or
4211: nvl(p_rec.frz_cmp_lvl_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_cmp_lvl_flag,'N') or
4212: nvl(p_rec.frz_pct_fl_tm_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_pct_fl_tm_flag,'N') or
4213: nvl(p_rec.frz_hrs_wkd_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_hrs_wkd_flag,'N') or
4214: 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
4215: nvl(p_rec.pct_fl_tm_val,-1) <> nvl(ben_epo_shd.g_old_rec.pct_fl_tm_val,-1) or
4216: nvl(p_rec.rt_comp_ref_amt,-1) <> nvl(ben_epo_shd.g_old_rec.rt_comp_ref_amt,-1) or
4217: 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

Line 4214: 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

4210: nvl(p_rec.frz_age_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_age_flag,'N') or
4211: nvl(p_rec.frz_cmp_lvl_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_cmp_lvl_flag,'N') or
4212: nvl(p_rec.frz_pct_fl_tm_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_pct_fl_tm_flag,'N') or
4213: nvl(p_rec.frz_hrs_wkd_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_hrs_wkd_flag,'N') or
4214: 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
4215: nvl(p_rec.pct_fl_tm_val,-1) <> nvl(ben_epo_shd.g_old_rec.pct_fl_tm_val,-1) or
4216: nvl(p_rec.rt_comp_ref_amt,-1) <> nvl(ben_epo_shd.g_old_rec.rt_comp_ref_amt,-1) or
4217: 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
4218: nvl(p_rec.rt_comp_ref_uom,'X') <> nvl(ben_epo_shd.g_old_rec.rt_comp_ref_uom,'X') or

Line 4215: nvl(p_rec.pct_fl_tm_val,-1) <> nvl(ben_epo_shd.g_old_rec.pct_fl_tm_val,-1) or

4211: nvl(p_rec.frz_cmp_lvl_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_cmp_lvl_flag,'N') or
4212: nvl(p_rec.frz_pct_fl_tm_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_pct_fl_tm_flag,'N') or
4213: nvl(p_rec.frz_hrs_wkd_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_hrs_wkd_flag,'N') or
4214: 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
4215: nvl(p_rec.pct_fl_tm_val,-1) <> nvl(ben_epo_shd.g_old_rec.pct_fl_tm_val,-1) or
4216: nvl(p_rec.rt_comp_ref_amt,-1) <> nvl(ben_epo_shd.g_old_rec.rt_comp_ref_amt,-1) or
4217: 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
4218: nvl(p_rec.rt_comp_ref_uom,'X') <> nvl(ben_epo_shd.g_old_rec.rt_comp_ref_uom,'X') or
4219: nvl(p_rec.rt_age_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_age_val,-1) or

Line 4216: nvl(p_rec.rt_comp_ref_amt,-1) <> nvl(ben_epo_shd.g_old_rec.rt_comp_ref_amt,-1) or

4212: nvl(p_rec.frz_pct_fl_tm_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_pct_fl_tm_flag,'N') or
4213: nvl(p_rec.frz_hrs_wkd_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_hrs_wkd_flag,'N') or
4214: 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
4215: nvl(p_rec.pct_fl_tm_val,-1) <> nvl(ben_epo_shd.g_old_rec.pct_fl_tm_val,-1) or
4216: nvl(p_rec.rt_comp_ref_amt,-1) <> nvl(ben_epo_shd.g_old_rec.rt_comp_ref_amt,-1) or
4217: 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
4218: nvl(p_rec.rt_comp_ref_uom,'X') <> nvl(ben_epo_shd.g_old_rec.rt_comp_ref_uom,'X') or
4219: nvl(p_rec.rt_age_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_age_val,-1) or
4220: nvl(p_rec.rt_los_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_los_val,-1) or

Line 4217: 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

4213: nvl(p_rec.frz_hrs_wkd_flag,'N') <> nvl(ben_epo_shd.g_old_rec.frz_hrs_wkd_flag,'N') or
4214: 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
4215: nvl(p_rec.pct_fl_tm_val,-1) <> nvl(ben_epo_shd.g_old_rec.pct_fl_tm_val,-1) or
4216: nvl(p_rec.rt_comp_ref_amt,-1) <> nvl(ben_epo_shd.g_old_rec.rt_comp_ref_amt,-1) or
4217: 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
4218: nvl(p_rec.rt_comp_ref_uom,'X') <> nvl(ben_epo_shd.g_old_rec.rt_comp_ref_uom,'X') or
4219: nvl(p_rec.rt_age_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_age_val,-1) or
4220: nvl(p_rec.rt_los_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_los_val,-1) or
4221: nvl(p_rec.rt_hrs_wkd_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_hrs_wkd_val,-1) or

Line 4218: nvl(p_rec.rt_comp_ref_uom,'X') <> nvl(ben_epo_shd.g_old_rec.rt_comp_ref_uom,'X') or

4214: 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
4215: nvl(p_rec.pct_fl_tm_val,-1) <> nvl(ben_epo_shd.g_old_rec.pct_fl_tm_val,-1) or
4216: nvl(p_rec.rt_comp_ref_amt,-1) <> nvl(ben_epo_shd.g_old_rec.rt_comp_ref_amt,-1) or
4217: 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
4218: nvl(p_rec.rt_comp_ref_uom,'X') <> nvl(ben_epo_shd.g_old_rec.rt_comp_ref_uom,'X') or
4219: nvl(p_rec.rt_age_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_age_val,-1) or
4220: nvl(p_rec.rt_los_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_los_val,-1) or
4221: nvl(p_rec.rt_hrs_wkd_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_hrs_wkd_val,-1) or
4222: nvl(p_rec.rt_hrs_wkd_bndry_perd_cd,'X') <>

Line 4219: nvl(p_rec.rt_age_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_age_val,-1) or

4215: nvl(p_rec.pct_fl_tm_val,-1) <> nvl(ben_epo_shd.g_old_rec.pct_fl_tm_val,-1) or
4216: nvl(p_rec.rt_comp_ref_amt,-1) <> nvl(ben_epo_shd.g_old_rec.rt_comp_ref_amt,-1) or
4217: 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
4218: nvl(p_rec.rt_comp_ref_uom,'X') <> nvl(ben_epo_shd.g_old_rec.rt_comp_ref_uom,'X') or
4219: nvl(p_rec.rt_age_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_age_val,-1) or
4220: nvl(p_rec.rt_los_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_los_val,-1) or
4221: nvl(p_rec.rt_hrs_wkd_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_hrs_wkd_val,-1) or
4222: nvl(p_rec.rt_hrs_wkd_bndry_perd_cd,'X') <>
4223: nvl(ben_epo_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd,'X') or

Line 4220: nvl(p_rec.rt_los_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_los_val,-1) or

4216: nvl(p_rec.rt_comp_ref_amt,-1) <> nvl(ben_epo_shd.g_old_rec.rt_comp_ref_amt,-1) or
4217: 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
4218: nvl(p_rec.rt_comp_ref_uom,'X') <> nvl(ben_epo_shd.g_old_rec.rt_comp_ref_uom,'X') or
4219: nvl(p_rec.rt_age_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_age_val,-1) or
4220: nvl(p_rec.rt_los_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_los_val,-1) or
4221: nvl(p_rec.rt_hrs_wkd_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_hrs_wkd_val,-1) or
4222: nvl(p_rec.rt_hrs_wkd_bndry_perd_cd,'X') <>
4223: nvl(ben_epo_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd,'X') or
4224: nvl(p_rec.rt_age_uom,'X') <> nvl(ben_epo_shd.g_old_rec.rt_age_uom,'X') or

Line 4221: nvl(p_rec.rt_hrs_wkd_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_hrs_wkd_val,-1) or

4217: 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
4218: nvl(p_rec.rt_comp_ref_uom,'X') <> nvl(ben_epo_shd.g_old_rec.rt_comp_ref_uom,'X') or
4219: nvl(p_rec.rt_age_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_age_val,-1) or
4220: nvl(p_rec.rt_los_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_los_val,-1) or
4221: nvl(p_rec.rt_hrs_wkd_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_hrs_wkd_val,-1) or
4222: nvl(p_rec.rt_hrs_wkd_bndry_perd_cd,'X') <>
4223: nvl(ben_epo_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd,'X') or
4224: nvl(p_rec.rt_age_uom,'X') <> nvl(ben_epo_shd.g_old_rec.rt_age_uom,'X') or
4225: nvl(p_rec.rt_los_uom,'X') <> nvl(ben_epo_shd.g_old_rec.rt_los_uom,'X') or

Line 4223: nvl(ben_epo_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd,'X') or

4219: nvl(p_rec.rt_age_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_age_val,-1) or
4220: nvl(p_rec.rt_los_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_los_val,-1) or
4221: nvl(p_rec.rt_hrs_wkd_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_hrs_wkd_val,-1) or
4222: nvl(p_rec.rt_hrs_wkd_bndry_perd_cd,'X') <>
4223: nvl(ben_epo_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd,'X') or
4224: nvl(p_rec.rt_age_uom,'X') <> nvl(ben_epo_shd.g_old_rec.rt_age_uom,'X') or
4225: nvl(p_rec.rt_los_uom,'X') <> nvl(ben_epo_shd.g_old_rec.rt_los_uom,'X') or
4226: nvl(p_rec.rt_pct_fl_tm_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_pct_fl_tm_val,-1) or
4227: nvl(p_rec.rt_frz_los_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_los_flag,'N') or

Line 4224: nvl(p_rec.rt_age_uom,'X') <> nvl(ben_epo_shd.g_old_rec.rt_age_uom,'X') or

4220: nvl(p_rec.rt_los_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_los_val,-1) or
4221: nvl(p_rec.rt_hrs_wkd_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_hrs_wkd_val,-1) or
4222: nvl(p_rec.rt_hrs_wkd_bndry_perd_cd,'X') <>
4223: nvl(ben_epo_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd,'X') or
4224: nvl(p_rec.rt_age_uom,'X') <> nvl(ben_epo_shd.g_old_rec.rt_age_uom,'X') or
4225: nvl(p_rec.rt_los_uom,'X') <> nvl(ben_epo_shd.g_old_rec.rt_los_uom,'X') or
4226: nvl(p_rec.rt_pct_fl_tm_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_pct_fl_tm_val,-1) or
4227: nvl(p_rec.rt_frz_los_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_los_flag,'N') or
4228: nvl(p_rec.rt_frz_age_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_age_flag,'N') or

Line 4225: nvl(p_rec.rt_los_uom,'X') <> nvl(ben_epo_shd.g_old_rec.rt_los_uom,'X') or

4221: nvl(p_rec.rt_hrs_wkd_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_hrs_wkd_val,-1) or
4222: nvl(p_rec.rt_hrs_wkd_bndry_perd_cd,'X') <>
4223: nvl(ben_epo_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd,'X') or
4224: nvl(p_rec.rt_age_uom,'X') <> nvl(ben_epo_shd.g_old_rec.rt_age_uom,'X') or
4225: nvl(p_rec.rt_los_uom,'X') <> nvl(ben_epo_shd.g_old_rec.rt_los_uom,'X') or
4226: nvl(p_rec.rt_pct_fl_tm_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_pct_fl_tm_val,-1) or
4227: nvl(p_rec.rt_frz_los_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_los_flag,'N') or
4228: nvl(p_rec.rt_frz_age_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_age_flag,'N') or
4229: nvl(p_rec.rt_frz_cmp_lvl_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_cmp_lvl_flag,'N') or

Line 4226: nvl(p_rec.rt_pct_fl_tm_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_pct_fl_tm_val,-1) or

4222: nvl(p_rec.rt_hrs_wkd_bndry_perd_cd,'X') <>
4223: nvl(ben_epo_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd,'X') or
4224: nvl(p_rec.rt_age_uom,'X') <> nvl(ben_epo_shd.g_old_rec.rt_age_uom,'X') or
4225: nvl(p_rec.rt_los_uom,'X') <> nvl(ben_epo_shd.g_old_rec.rt_los_uom,'X') or
4226: nvl(p_rec.rt_pct_fl_tm_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_pct_fl_tm_val,-1) or
4227: nvl(p_rec.rt_frz_los_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_los_flag,'N') or
4228: nvl(p_rec.rt_frz_age_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_age_flag,'N') or
4229: nvl(p_rec.rt_frz_cmp_lvl_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_cmp_lvl_flag,'N') or
4230: 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

Line 4227: nvl(p_rec.rt_frz_los_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_los_flag,'N') or

4223: nvl(ben_epo_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd,'X') or
4224: nvl(p_rec.rt_age_uom,'X') <> nvl(ben_epo_shd.g_old_rec.rt_age_uom,'X') or
4225: nvl(p_rec.rt_los_uom,'X') <> nvl(ben_epo_shd.g_old_rec.rt_los_uom,'X') or
4226: nvl(p_rec.rt_pct_fl_tm_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_pct_fl_tm_val,-1) or
4227: nvl(p_rec.rt_frz_los_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_los_flag,'N') or
4228: nvl(p_rec.rt_frz_age_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_age_flag,'N') or
4229: nvl(p_rec.rt_frz_cmp_lvl_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_cmp_lvl_flag,'N') or
4230: 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
4231: nvl(p_rec.rt_frz_hrs_wkd_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_hrs_wkd_flag,'N') or

Line 4228: nvl(p_rec.rt_frz_age_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_age_flag,'N') or

4224: nvl(p_rec.rt_age_uom,'X') <> nvl(ben_epo_shd.g_old_rec.rt_age_uom,'X') or
4225: nvl(p_rec.rt_los_uom,'X') <> nvl(ben_epo_shd.g_old_rec.rt_los_uom,'X') or
4226: nvl(p_rec.rt_pct_fl_tm_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_pct_fl_tm_val,-1) or
4227: nvl(p_rec.rt_frz_los_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_los_flag,'N') or
4228: nvl(p_rec.rt_frz_age_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_age_flag,'N') or
4229: nvl(p_rec.rt_frz_cmp_lvl_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_cmp_lvl_flag,'N') or
4230: 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
4231: nvl(p_rec.rt_frz_hrs_wkd_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_hrs_wkd_flag,'N') or
4232: nvl(p_rec.rt_frz_comb_age_and_los_flag,'N') <>

Line 4229: nvl(p_rec.rt_frz_cmp_lvl_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_cmp_lvl_flag,'N') or

4225: nvl(p_rec.rt_los_uom,'X') <> nvl(ben_epo_shd.g_old_rec.rt_los_uom,'X') or
4226: nvl(p_rec.rt_pct_fl_tm_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_pct_fl_tm_val,-1) or
4227: nvl(p_rec.rt_frz_los_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_los_flag,'N') or
4228: nvl(p_rec.rt_frz_age_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_age_flag,'N') or
4229: nvl(p_rec.rt_frz_cmp_lvl_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_cmp_lvl_flag,'N') or
4230: 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
4231: nvl(p_rec.rt_frz_hrs_wkd_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_hrs_wkd_flag,'N') or
4232: nvl(p_rec.rt_frz_comb_age_and_los_flag,'N') <>
4233: nvl(ben_epo_shd.g_old_rec.rt_frz_comb_age_and_los_flag,'N') or

Line 4230: 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

4226: nvl(p_rec.rt_pct_fl_tm_val,-1) <> nvl(ben_epo_shd.g_old_rec.rt_pct_fl_tm_val,-1) or
4227: nvl(p_rec.rt_frz_los_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_los_flag,'N') or
4228: nvl(p_rec.rt_frz_age_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_age_flag,'N') or
4229: nvl(p_rec.rt_frz_cmp_lvl_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_cmp_lvl_flag,'N') or
4230: 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
4231: nvl(p_rec.rt_frz_hrs_wkd_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_hrs_wkd_flag,'N') or
4232: nvl(p_rec.rt_frz_comb_age_and_los_flag,'N') <>
4233: nvl(ben_epo_shd.g_old_rec.rt_frz_comb_age_and_los_flag,'N') or
4234: nvl(p_rec.once_r_cntug_cd,'X') <> nvl(ben_epo_shd.g_old_rec.once_r_cntug_cd,'X') or

Line 4231: nvl(p_rec.rt_frz_hrs_wkd_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_hrs_wkd_flag,'N') or

4227: nvl(p_rec.rt_frz_los_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_los_flag,'N') or
4228: nvl(p_rec.rt_frz_age_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_age_flag,'N') or
4229: nvl(p_rec.rt_frz_cmp_lvl_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_cmp_lvl_flag,'N') or
4230: 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
4231: nvl(p_rec.rt_frz_hrs_wkd_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_hrs_wkd_flag,'N') or
4232: nvl(p_rec.rt_frz_comb_age_and_los_flag,'N') <>
4233: nvl(ben_epo_shd.g_old_rec.rt_frz_comb_age_and_los_flag,'N') or
4234: nvl(p_rec.once_r_cntug_cd,'X') <> nvl(ben_epo_shd.g_old_rec.once_r_cntug_cd,'X') or
4235: nvl(p_rec.oipl_ordr_num,-1) <> nvl(ben_epo_shd.g_old_rec.oipl_ordr_num,-1)

Line 4233: nvl(ben_epo_shd.g_old_rec.rt_frz_comb_age_and_los_flag,'N') or

4229: nvl(p_rec.rt_frz_cmp_lvl_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_cmp_lvl_flag,'N') or
4230: 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
4231: nvl(p_rec.rt_frz_hrs_wkd_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_hrs_wkd_flag,'N') or
4232: nvl(p_rec.rt_frz_comb_age_and_los_flag,'N') <>
4233: nvl(ben_epo_shd.g_old_rec.rt_frz_comb_age_and_los_flag,'N') or
4234: nvl(p_rec.once_r_cntug_cd,'X') <> nvl(ben_epo_shd.g_old_rec.once_r_cntug_cd,'X') or
4235: nvl(p_rec.oipl_ordr_num,-1) <> nvl(ben_epo_shd.g_old_rec.oipl_ordr_num,-1)
4236: ) then
4237: --

Line 4234: nvl(p_rec.once_r_cntug_cd,'X') <> nvl(ben_epo_shd.g_old_rec.once_r_cntug_cd,'X') or

4230: 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
4231: nvl(p_rec.rt_frz_hrs_wkd_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_hrs_wkd_flag,'N') or
4232: nvl(p_rec.rt_frz_comb_age_and_los_flag,'N') <>
4233: nvl(ben_epo_shd.g_old_rec.rt_frz_comb_age_and_los_flag,'N') or
4234: nvl(p_rec.once_r_cntug_cd,'X') <> nvl(ben_epo_shd.g_old_rec.once_r_cntug_cd,'X') or
4235: nvl(p_rec.oipl_ordr_num,-1) <> nvl(ben_epo_shd.g_old_rec.oipl_ordr_num,-1)
4236: ) then
4237: --
4238: null;

Line 4235: nvl(p_rec.oipl_ordr_num,-1) <> nvl(ben_epo_shd.g_old_rec.oipl_ordr_num,-1)

4231: nvl(p_rec.rt_frz_hrs_wkd_flag,'N') <> nvl(ben_epo_shd.g_old_rec.rt_frz_hrs_wkd_flag,'N') or
4232: nvl(p_rec.rt_frz_comb_age_and_los_flag,'N') <>
4233: nvl(ben_epo_shd.g_old_rec.rt_frz_comb_age_and_los_flag,'N') or
4234: nvl(p_rec.once_r_cntug_cd,'X') <> nvl(ben_epo_shd.g_old_rec.once_r_cntug_cd,'X') or
4235: nvl(p_rec.oipl_ordr_num,-1) <> nvl(ben_epo_shd.g_old_rec.oipl_ordr_num,-1)
4236: ) then
4237: --
4238: null;
4239: else

Line 4362: l_rec ben_epo_shd.g_rec_type;

4358: p_effective_date in date,
4359: p_datetrack_mode in varchar2
4360: ) is
4361: --
4362: l_rec ben_epo_shd.g_rec_type;
4363: l_proc varchar2(72) := g_package||'upd';
4364: --
4365: Begin
4366: hr_utility.set_location('Entering:'||l_proc, 5);

Line 4372: ben_epo_shd.convert_args

4368: -- Call conversion function to turn arguments into the
4369: -- l_rec structure.
4370: --
4371: l_rec :=
4372: ben_epo_shd.convert_args
4373: (
4374: p_elig_per_opt_id,
4375: p_elig_per_id,
4376: null,