[Home] [Help]
54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy ben_epo_shd.g_rec_type,
59: p_effective_date in date,
60: p_datetrack_mode in varchar2,
61: p_validation_start_date in date,
62: p_validation_end_date in date) is
77: (p_base_table_name => 'ben_elig_per_opt_f',
78: p_base_key_column => 'elig_per_opt_id',
79: p_base_key_value => p_rec.elig_per_opt_id);
80: --
81: ben_epo_shd.g_api_dml := true; -- Set the api dml status
82: --
83: -- Update the ben_elig_per_opt_f Row
84: --
85: update ben_elig_per_opt_f
173: where elig_per_opt_id = p_rec.elig_per_opt_id
174: and effective_start_date = p_validation_start_date
175: and effective_end_date = p_validation_end_date;
176: --
177: ben_epo_shd.g_api_dml := false; -- Unset the api dml status
178: --
179: -- Set the effective start and end dates
180: --
181: p_rec.effective_start_date := p_validation_start_date;
185: hr_utility.set_location(' Leaving:'||l_proc, 15);
186: Exception
187: When hr_api.check_integrity_violated Then
188: -- A check constraint has been violated
189: ben_epo_shd.g_api_dml := false; -- Unset the api dml status
190: ben_epo_shd.constraint_error
191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
192: When hr_api.unique_integrity_violated Then
193: -- Unique integrity has been violated
186: Exception
187: When hr_api.check_integrity_violated Then
188: -- A check constraint has been violated
189: ben_epo_shd.g_api_dml := false; -- Unset the api dml status
190: ben_epo_shd.constraint_error
191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
192: When hr_api.unique_integrity_violated Then
193: -- Unique integrity has been violated
194: ben_epo_shd.g_api_dml := false; -- Unset the api dml status
190: ben_epo_shd.constraint_error
191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
192: When hr_api.unique_integrity_violated Then
193: -- Unique integrity has been violated
194: ben_epo_shd.g_api_dml := false; -- Unset the api dml status
195: ben_epo_shd.constraint_error
196: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
197: When Others Then
198: ben_epo_shd.g_api_dml := false; -- Unset the api dml status
191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
192: When hr_api.unique_integrity_violated Then
193: -- Unique integrity has been violated
194: ben_epo_shd.g_api_dml := false; -- Unset the api dml status
195: ben_epo_shd.constraint_error
196: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
197: When Others Then
198: ben_epo_shd.g_api_dml := false; -- Unset the api dml status
199: Raise;
194: ben_epo_shd.g_api_dml := false; -- Unset the api dml status
195: ben_epo_shd.constraint_error
196: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
197: When Others Then
198: ben_epo_shd.g_api_dml := false; -- Unset the api dml status
199: Raise;
200: End dt_update_dml;
201: --
202: -- ----------------------------------------------------------------------------
230: --
231: -- {End Of Comments}
232: -- ----------------------------------------------------------------------------
233: Procedure update_dml
234: (p_rec in out nocopy ben_epo_shd.g_rec_type,
235: p_effective_date in date,
236: p_datetrack_mode in varchar2,
237: p_validation_start_date in date,
238: p_validation_end_date in date) is
294: --
295: -- {End Of Comments}
296: -- ----------------------------------------------------------------------------
297: Procedure dt_pre_update
298: (p_rec in out nocopy ben_epo_shd.g_rec_type,
299: p_effective_date in date,
300: p_datetrack_mode in varchar2,
301: p_validation_start_date in date,
302: p_validation_end_date in date) is
310: hr_utility.set_location(l_proc, 10);
311: --
312: -- Update the current effective end date
313: --
314: ben_epo_shd.upd_effective_end_date
315: (p_effective_date => p_effective_date,
316: p_base_key_value => p_rec.elig_per_opt_id,
317: p_new_effective_end_date => (p_validation_start_date - 1),
318: p_validation_start_date => p_validation_start_date,
379: --
380: -- {End Of Comments}
381: -- ----------------------------------------------------------------------------
382: Procedure pre_update
383: (p_rec in out nocopy ben_epo_shd.g_rec_type,
384: p_effective_date in date,
385: p_datetrack_mode in varchar2,
386: p_validation_start_date in date,
387: p_validation_end_date in date) is
435: --
436: -- {End Of Comments}
437: -- ----------------------------------------------------------------------------
438: Procedure post_update
439: (p_rec in ben_epo_shd.g_rec_type,
440: p_effective_date in date,
441: p_datetrack_mode in varchar2,
442: p_validation_start_date in date,
443: p_validation_end_date in date) is
545: ,p_effective_date =>p_effective_date
546: ,p_datetrack_mode =>p_datetrack_mode
547: ,p_validation_start_date =>p_validation_start_date
548: ,p_validation_end_date =>p_validation_end_date
549: ,p_elig_per_id_o =>ben_epo_shd.g_old_rec.elig_per_id
550: ,p_effective_start_date_o =>ben_epo_shd.g_old_rec.effective_start_date
551: ,p_effective_end_date_o =>ben_epo_shd.g_old_rec.effective_end_date
552: ,p_prtn_ovridn_flag_o =>ben_epo_shd.g_old_rec.prtn_ovridn_flag
553: ,p_prtn_ovridn_thru_dt_o =>ben_epo_shd.g_old_rec.prtn_ovridn_thru_dt
546: ,p_datetrack_mode =>p_datetrack_mode
547: ,p_validation_start_date =>p_validation_start_date
548: ,p_validation_end_date =>p_validation_end_date
549: ,p_elig_per_id_o =>ben_epo_shd.g_old_rec.elig_per_id
550: ,p_effective_start_date_o =>ben_epo_shd.g_old_rec.effective_start_date
551: ,p_effective_end_date_o =>ben_epo_shd.g_old_rec.effective_end_date
552: ,p_prtn_ovridn_flag_o =>ben_epo_shd.g_old_rec.prtn_ovridn_flag
553: ,p_prtn_ovridn_thru_dt_o =>ben_epo_shd.g_old_rec.prtn_ovridn_thru_dt
554: ,p_no_mx_prtn_ovrid_thru_flag_o =>ben_epo_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag
547: ,p_validation_start_date =>p_validation_start_date
548: ,p_validation_end_date =>p_validation_end_date
549: ,p_elig_per_id_o =>ben_epo_shd.g_old_rec.elig_per_id
550: ,p_effective_start_date_o =>ben_epo_shd.g_old_rec.effective_start_date
551: ,p_effective_end_date_o =>ben_epo_shd.g_old_rec.effective_end_date
552: ,p_prtn_ovridn_flag_o =>ben_epo_shd.g_old_rec.prtn_ovridn_flag
553: ,p_prtn_ovridn_thru_dt_o =>ben_epo_shd.g_old_rec.prtn_ovridn_thru_dt
554: ,p_no_mx_prtn_ovrid_thru_flag_o =>ben_epo_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag
555: ,p_elig_flag_o =>ben_epo_shd.g_old_rec.elig_flag
548: ,p_validation_end_date =>p_validation_end_date
549: ,p_elig_per_id_o =>ben_epo_shd.g_old_rec.elig_per_id
550: ,p_effective_start_date_o =>ben_epo_shd.g_old_rec.effective_start_date
551: ,p_effective_end_date_o =>ben_epo_shd.g_old_rec.effective_end_date
552: ,p_prtn_ovridn_flag_o =>ben_epo_shd.g_old_rec.prtn_ovridn_flag
553: ,p_prtn_ovridn_thru_dt_o =>ben_epo_shd.g_old_rec.prtn_ovridn_thru_dt
554: ,p_no_mx_prtn_ovrid_thru_flag_o =>ben_epo_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag
555: ,p_elig_flag_o =>ben_epo_shd.g_old_rec.elig_flag
556: ,p_prtn_strt_dt_o =>ben_epo_shd.g_old_rec.prtn_strt_dt
549: ,p_elig_per_id_o =>ben_epo_shd.g_old_rec.elig_per_id
550: ,p_effective_start_date_o =>ben_epo_shd.g_old_rec.effective_start_date
551: ,p_effective_end_date_o =>ben_epo_shd.g_old_rec.effective_end_date
552: ,p_prtn_ovridn_flag_o =>ben_epo_shd.g_old_rec.prtn_ovridn_flag
553: ,p_prtn_ovridn_thru_dt_o =>ben_epo_shd.g_old_rec.prtn_ovridn_thru_dt
554: ,p_no_mx_prtn_ovrid_thru_flag_o =>ben_epo_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag
555: ,p_elig_flag_o =>ben_epo_shd.g_old_rec.elig_flag
556: ,p_prtn_strt_dt_o =>ben_epo_shd.g_old_rec.prtn_strt_dt
557: ,p_prtn_end_dt_o =>ben_epo_shd.g_old_rec.prtn_end_dt
550: ,p_effective_start_date_o =>ben_epo_shd.g_old_rec.effective_start_date
551: ,p_effective_end_date_o =>ben_epo_shd.g_old_rec.effective_end_date
552: ,p_prtn_ovridn_flag_o =>ben_epo_shd.g_old_rec.prtn_ovridn_flag
553: ,p_prtn_ovridn_thru_dt_o =>ben_epo_shd.g_old_rec.prtn_ovridn_thru_dt
554: ,p_no_mx_prtn_ovrid_thru_flag_o =>ben_epo_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag
555: ,p_elig_flag_o =>ben_epo_shd.g_old_rec.elig_flag
556: ,p_prtn_strt_dt_o =>ben_epo_shd.g_old_rec.prtn_strt_dt
557: ,p_prtn_end_dt_o =>ben_epo_shd.g_old_rec.prtn_end_dt
558: ,p_wait_perd_cmpltn_date_o =>ben_epo_shd.g_old_rec.wait_perd_cmpltn_date
551: ,p_effective_end_date_o =>ben_epo_shd.g_old_rec.effective_end_date
552: ,p_prtn_ovridn_flag_o =>ben_epo_shd.g_old_rec.prtn_ovridn_flag
553: ,p_prtn_ovridn_thru_dt_o =>ben_epo_shd.g_old_rec.prtn_ovridn_thru_dt
554: ,p_no_mx_prtn_ovrid_thru_flag_o =>ben_epo_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag
555: ,p_elig_flag_o =>ben_epo_shd.g_old_rec.elig_flag
556: ,p_prtn_strt_dt_o =>ben_epo_shd.g_old_rec.prtn_strt_dt
557: ,p_prtn_end_dt_o =>ben_epo_shd.g_old_rec.prtn_end_dt
558: ,p_wait_perd_cmpltn_date_o =>ben_epo_shd.g_old_rec.wait_perd_cmpltn_date
559: ,p_wait_perd_strt_dt_o =>ben_epo_shd.g_old_rec.wait_perd_strt_dt
552: ,p_prtn_ovridn_flag_o =>ben_epo_shd.g_old_rec.prtn_ovridn_flag
553: ,p_prtn_ovridn_thru_dt_o =>ben_epo_shd.g_old_rec.prtn_ovridn_thru_dt
554: ,p_no_mx_prtn_ovrid_thru_flag_o =>ben_epo_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag
555: ,p_elig_flag_o =>ben_epo_shd.g_old_rec.elig_flag
556: ,p_prtn_strt_dt_o =>ben_epo_shd.g_old_rec.prtn_strt_dt
557: ,p_prtn_end_dt_o =>ben_epo_shd.g_old_rec.prtn_end_dt
558: ,p_wait_perd_cmpltn_date_o =>ben_epo_shd.g_old_rec.wait_perd_cmpltn_date
559: ,p_wait_perd_strt_dt_o =>ben_epo_shd.g_old_rec.wait_perd_strt_dt
560: ,p_prtn_ovridn_rsn_cd_o =>ben_epo_shd.g_old_rec.prtn_ovridn_rsn_cd
553: ,p_prtn_ovridn_thru_dt_o =>ben_epo_shd.g_old_rec.prtn_ovridn_thru_dt
554: ,p_no_mx_prtn_ovrid_thru_flag_o =>ben_epo_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag
555: ,p_elig_flag_o =>ben_epo_shd.g_old_rec.elig_flag
556: ,p_prtn_strt_dt_o =>ben_epo_shd.g_old_rec.prtn_strt_dt
557: ,p_prtn_end_dt_o =>ben_epo_shd.g_old_rec.prtn_end_dt
558: ,p_wait_perd_cmpltn_date_o =>ben_epo_shd.g_old_rec.wait_perd_cmpltn_date
559: ,p_wait_perd_strt_dt_o =>ben_epo_shd.g_old_rec.wait_perd_strt_dt
560: ,p_prtn_ovridn_rsn_cd_o =>ben_epo_shd.g_old_rec.prtn_ovridn_rsn_cd
561: ,p_pct_fl_tm_val_o =>ben_epo_shd.g_old_rec.pct_fl_tm_val
554: ,p_no_mx_prtn_ovrid_thru_flag_o =>ben_epo_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag
555: ,p_elig_flag_o =>ben_epo_shd.g_old_rec.elig_flag
556: ,p_prtn_strt_dt_o =>ben_epo_shd.g_old_rec.prtn_strt_dt
557: ,p_prtn_end_dt_o =>ben_epo_shd.g_old_rec.prtn_end_dt
558: ,p_wait_perd_cmpltn_date_o =>ben_epo_shd.g_old_rec.wait_perd_cmpltn_date
559: ,p_wait_perd_strt_dt_o =>ben_epo_shd.g_old_rec.wait_perd_strt_dt
560: ,p_prtn_ovridn_rsn_cd_o =>ben_epo_shd.g_old_rec.prtn_ovridn_rsn_cd
561: ,p_pct_fl_tm_val_o =>ben_epo_shd.g_old_rec.pct_fl_tm_val
562: ,p_opt_id_o =>ben_epo_shd.g_old_rec.opt_id
555: ,p_elig_flag_o =>ben_epo_shd.g_old_rec.elig_flag
556: ,p_prtn_strt_dt_o =>ben_epo_shd.g_old_rec.prtn_strt_dt
557: ,p_prtn_end_dt_o =>ben_epo_shd.g_old_rec.prtn_end_dt
558: ,p_wait_perd_cmpltn_date_o =>ben_epo_shd.g_old_rec.wait_perd_cmpltn_date
559: ,p_wait_perd_strt_dt_o =>ben_epo_shd.g_old_rec.wait_perd_strt_dt
560: ,p_prtn_ovridn_rsn_cd_o =>ben_epo_shd.g_old_rec.prtn_ovridn_rsn_cd
561: ,p_pct_fl_tm_val_o =>ben_epo_shd.g_old_rec.pct_fl_tm_val
562: ,p_opt_id_o =>ben_epo_shd.g_old_rec.opt_id
563: ,p_per_in_ler_id_o =>ben_epo_shd.g_old_rec.per_in_ler_id
556: ,p_prtn_strt_dt_o =>ben_epo_shd.g_old_rec.prtn_strt_dt
557: ,p_prtn_end_dt_o =>ben_epo_shd.g_old_rec.prtn_end_dt
558: ,p_wait_perd_cmpltn_date_o =>ben_epo_shd.g_old_rec.wait_perd_cmpltn_date
559: ,p_wait_perd_strt_dt_o =>ben_epo_shd.g_old_rec.wait_perd_strt_dt
560: ,p_prtn_ovridn_rsn_cd_o =>ben_epo_shd.g_old_rec.prtn_ovridn_rsn_cd
561: ,p_pct_fl_tm_val_o =>ben_epo_shd.g_old_rec.pct_fl_tm_val
562: ,p_opt_id_o =>ben_epo_shd.g_old_rec.opt_id
563: ,p_per_in_ler_id_o =>ben_epo_shd.g_old_rec.per_in_ler_id
564: ,p_rt_comp_ref_amt_o =>ben_epo_shd.g_old_rec.rt_comp_ref_amt
557: ,p_prtn_end_dt_o =>ben_epo_shd.g_old_rec.prtn_end_dt
558: ,p_wait_perd_cmpltn_date_o =>ben_epo_shd.g_old_rec.wait_perd_cmpltn_date
559: ,p_wait_perd_strt_dt_o =>ben_epo_shd.g_old_rec.wait_perd_strt_dt
560: ,p_prtn_ovridn_rsn_cd_o =>ben_epo_shd.g_old_rec.prtn_ovridn_rsn_cd
561: ,p_pct_fl_tm_val_o =>ben_epo_shd.g_old_rec.pct_fl_tm_val
562: ,p_opt_id_o =>ben_epo_shd.g_old_rec.opt_id
563: ,p_per_in_ler_id_o =>ben_epo_shd.g_old_rec.per_in_ler_id
564: ,p_rt_comp_ref_amt_o =>ben_epo_shd.g_old_rec.rt_comp_ref_amt
565: ,p_rt_cmbn_age_n_los_val_o =>ben_epo_shd.g_old_rec.rt_cmbn_age_n_los_val
558: ,p_wait_perd_cmpltn_date_o =>ben_epo_shd.g_old_rec.wait_perd_cmpltn_date
559: ,p_wait_perd_strt_dt_o =>ben_epo_shd.g_old_rec.wait_perd_strt_dt
560: ,p_prtn_ovridn_rsn_cd_o =>ben_epo_shd.g_old_rec.prtn_ovridn_rsn_cd
561: ,p_pct_fl_tm_val_o =>ben_epo_shd.g_old_rec.pct_fl_tm_val
562: ,p_opt_id_o =>ben_epo_shd.g_old_rec.opt_id
563: ,p_per_in_ler_id_o =>ben_epo_shd.g_old_rec.per_in_ler_id
564: ,p_rt_comp_ref_amt_o =>ben_epo_shd.g_old_rec.rt_comp_ref_amt
565: ,p_rt_cmbn_age_n_los_val_o =>ben_epo_shd.g_old_rec.rt_cmbn_age_n_los_val
566: ,p_rt_comp_ref_uom_o =>ben_epo_shd.g_old_rec.rt_comp_ref_uom
559: ,p_wait_perd_strt_dt_o =>ben_epo_shd.g_old_rec.wait_perd_strt_dt
560: ,p_prtn_ovridn_rsn_cd_o =>ben_epo_shd.g_old_rec.prtn_ovridn_rsn_cd
561: ,p_pct_fl_tm_val_o =>ben_epo_shd.g_old_rec.pct_fl_tm_val
562: ,p_opt_id_o =>ben_epo_shd.g_old_rec.opt_id
563: ,p_per_in_ler_id_o =>ben_epo_shd.g_old_rec.per_in_ler_id
564: ,p_rt_comp_ref_amt_o =>ben_epo_shd.g_old_rec.rt_comp_ref_amt
565: ,p_rt_cmbn_age_n_los_val_o =>ben_epo_shd.g_old_rec.rt_cmbn_age_n_los_val
566: ,p_rt_comp_ref_uom_o =>ben_epo_shd.g_old_rec.rt_comp_ref_uom
567: ,p_rt_age_val_o =>ben_epo_shd.g_old_rec.rt_age_val
560: ,p_prtn_ovridn_rsn_cd_o =>ben_epo_shd.g_old_rec.prtn_ovridn_rsn_cd
561: ,p_pct_fl_tm_val_o =>ben_epo_shd.g_old_rec.pct_fl_tm_val
562: ,p_opt_id_o =>ben_epo_shd.g_old_rec.opt_id
563: ,p_per_in_ler_id_o =>ben_epo_shd.g_old_rec.per_in_ler_id
564: ,p_rt_comp_ref_amt_o =>ben_epo_shd.g_old_rec.rt_comp_ref_amt
565: ,p_rt_cmbn_age_n_los_val_o =>ben_epo_shd.g_old_rec.rt_cmbn_age_n_los_val
566: ,p_rt_comp_ref_uom_o =>ben_epo_shd.g_old_rec.rt_comp_ref_uom
567: ,p_rt_age_val_o =>ben_epo_shd.g_old_rec.rt_age_val
568: ,p_rt_los_val_o =>ben_epo_shd.g_old_rec.rt_los_val
561: ,p_pct_fl_tm_val_o =>ben_epo_shd.g_old_rec.pct_fl_tm_val
562: ,p_opt_id_o =>ben_epo_shd.g_old_rec.opt_id
563: ,p_per_in_ler_id_o =>ben_epo_shd.g_old_rec.per_in_ler_id
564: ,p_rt_comp_ref_amt_o =>ben_epo_shd.g_old_rec.rt_comp_ref_amt
565: ,p_rt_cmbn_age_n_los_val_o =>ben_epo_shd.g_old_rec.rt_cmbn_age_n_los_val
566: ,p_rt_comp_ref_uom_o =>ben_epo_shd.g_old_rec.rt_comp_ref_uom
567: ,p_rt_age_val_o =>ben_epo_shd.g_old_rec.rt_age_val
568: ,p_rt_los_val_o =>ben_epo_shd.g_old_rec.rt_los_val
569: ,p_rt_hrs_wkd_val_o =>ben_epo_shd.g_old_rec.rt_hrs_wkd_val
562: ,p_opt_id_o =>ben_epo_shd.g_old_rec.opt_id
563: ,p_per_in_ler_id_o =>ben_epo_shd.g_old_rec.per_in_ler_id
564: ,p_rt_comp_ref_amt_o =>ben_epo_shd.g_old_rec.rt_comp_ref_amt
565: ,p_rt_cmbn_age_n_los_val_o =>ben_epo_shd.g_old_rec.rt_cmbn_age_n_los_val
566: ,p_rt_comp_ref_uom_o =>ben_epo_shd.g_old_rec.rt_comp_ref_uom
567: ,p_rt_age_val_o =>ben_epo_shd.g_old_rec.rt_age_val
568: ,p_rt_los_val_o =>ben_epo_shd.g_old_rec.rt_los_val
569: ,p_rt_hrs_wkd_val_o =>ben_epo_shd.g_old_rec.rt_hrs_wkd_val
570: ,p_rt_hrs_wkd_bndry_perd_cd_o =>ben_epo_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd
563: ,p_per_in_ler_id_o =>ben_epo_shd.g_old_rec.per_in_ler_id
564: ,p_rt_comp_ref_amt_o =>ben_epo_shd.g_old_rec.rt_comp_ref_amt
565: ,p_rt_cmbn_age_n_los_val_o =>ben_epo_shd.g_old_rec.rt_cmbn_age_n_los_val
566: ,p_rt_comp_ref_uom_o =>ben_epo_shd.g_old_rec.rt_comp_ref_uom
567: ,p_rt_age_val_o =>ben_epo_shd.g_old_rec.rt_age_val
568: ,p_rt_los_val_o =>ben_epo_shd.g_old_rec.rt_los_val
569: ,p_rt_hrs_wkd_val_o =>ben_epo_shd.g_old_rec.rt_hrs_wkd_val
570: ,p_rt_hrs_wkd_bndry_perd_cd_o =>ben_epo_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd
571: ,p_rt_age_uom_o =>ben_epo_shd.g_old_rec.rt_age_uom
564: ,p_rt_comp_ref_amt_o =>ben_epo_shd.g_old_rec.rt_comp_ref_amt
565: ,p_rt_cmbn_age_n_los_val_o =>ben_epo_shd.g_old_rec.rt_cmbn_age_n_los_val
566: ,p_rt_comp_ref_uom_o =>ben_epo_shd.g_old_rec.rt_comp_ref_uom
567: ,p_rt_age_val_o =>ben_epo_shd.g_old_rec.rt_age_val
568: ,p_rt_los_val_o =>ben_epo_shd.g_old_rec.rt_los_val
569: ,p_rt_hrs_wkd_val_o =>ben_epo_shd.g_old_rec.rt_hrs_wkd_val
570: ,p_rt_hrs_wkd_bndry_perd_cd_o =>ben_epo_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd
571: ,p_rt_age_uom_o =>ben_epo_shd.g_old_rec.rt_age_uom
572: ,p_rt_los_uom_o =>ben_epo_shd.g_old_rec.rt_los_uom
565: ,p_rt_cmbn_age_n_los_val_o =>ben_epo_shd.g_old_rec.rt_cmbn_age_n_los_val
566: ,p_rt_comp_ref_uom_o =>ben_epo_shd.g_old_rec.rt_comp_ref_uom
567: ,p_rt_age_val_o =>ben_epo_shd.g_old_rec.rt_age_val
568: ,p_rt_los_val_o =>ben_epo_shd.g_old_rec.rt_los_val
569: ,p_rt_hrs_wkd_val_o =>ben_epo_shd.g_old_rec.rt_hrs_wkd_val
570: ,p_rt_hrs_wkd_bndry_perd_cd_o =>ben_epo_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd
571: ,p_rt_age_uom_o =>ben_epo_shd.g_old_rec.rt_age_uom
572: ,p_rt_los_uom_o =>ben_epo_shd.g_old_rec.rt_los_uom
573: ,p_rt_pct_fl_tm_val_o =>ben_epo_shd.g_old_rec.rt_pct_fl_tm_val
566: ,p_rt_comp_ref_uom_o =>ben_epo_shd.g_old_rec.rt_comp_ref_uom
567: ,p_rt_age_val_o =>ben_epo_shd.g_old_rec.rt_age_val
568: ,p_rt_los_val_o =>ben_epo_shd.g_old_rec.rt_los_val
569: ,p_rt_hrs_wkd_val_o =>ben_epo_shd.g_old_rec.rt_hrs_wkd_val
570: ,p_rt_hrs_wkd_bndry_perd_cd_o =>ben_epo_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd
571: ,p_rt_age_uom_o =>ben_epo_shd.g_old_rec.rt_age_uom
572: ,p_rt_los_uom_o =>ben_epo_shd.g_old_rec.rt_los_uom
573: ,p_rt_pct_fl_tm_val_o =>ben_epo_shd.g_old_rec.rt_pct_fl_tm_val
574: ,p_rt_frz_los_flag_o =>ben_epo_shd.g_old_rec.rt_frz_los_flag
567: ,p_rt_age_val_o =>ben_epo_shd.g_old_rec.rt_age_val
568: ,p_rt_los_val_o =>ben_epo_shd.g_old_rec.rt_los_val
569: ,p_rt_hrs_wkd_val_o =>ben_epo_shd.g_old_rec.rt_hrs_wkd_val
570: ,p_rt_hrs_wkd_bndry_perd_cd_o =>ben_epo_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd
571: ,p_rt_age_uom_o =>ben_epo_shd.g_old_rec.rt_age_uom
572: ,p_rt_los_uom_o =>ben_epo_shd.g_old_rec.rt_los_uom
573: ,p_rt_pct_fl_tm_val_o =>ben_epo_shd.g_old_rec.rt_pct_fl_tm_val
574: ,p_rt_frz_los_flag_o =>ben_epo_shd.g_old_rec.rt_frz_los_flag
575: ,p_rt_frz_age_flag_o =>ben_epo_shd.g_old_rec.rt_frz_age_flag
568: ,p_rt_los_val_o =>ben_epo_shd.g_old_rec.rt_los_val
569: ,p_rt_hrs_wkd_val_o =>ben_epo_shd.g_old_rec.rt_hrs_wkd_val
570: ,p_rt_hrs_wkd_bndry_perd_cd_o =>ben_epo_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd
571: ,p_rt_age_uom_o =>ben_epo_shd.g_old_rec.rt_age_uom
572: ,p_rt_los_uom_o =>ben_epo_shd.g_old_rec.rt_los_uom
573: ,p_rt_pct_fl_tm_val_o =>ben_epo_shd.g_old_rec.rt_pct_fl_tm_val
574: ,p_rt_frz_los_flag_o =>ben_epo_shd.g_old_rec.rt_frz_los_flag
575: ,p_rt_frz_age_flag_o =>ben_epo_shd.g_old_rec.rt_frz_age_flag
576: ,p_rt_frz_cmp_lvl_flag_o =>ben_epo_shd.g_old_rec.rt_frz_cmp_lvl_flag
569: ,p_rt_hrs_wkd_val_o =>ben_epo_shd.g_old_rec.rt_hrs_wkd_val
570: ,p_rt_hrs_wkd_bndry_perd_cd_o =>ben_epo_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd
571: ,p_rt_age_uom_o =>ben_epo_shd.g_old_rec.rt_age_uom
572: ,p_rt_los_uom_o =>ben_epo_shd.g_old_rec.rt_los_uom
573: ,p_rt_pct_fl_tm_val_o =>ben_epo_shd.g_old_rec.rt_pct_fl_tm_val
574: ,p_rt_frz_los_flag_o =>ben_epo_shd.g_old_rec.rt_frz_los_flag
575: ,p_rt_frz_age_flag_o =>ben_epo_shd.g_old_rec.rt_frz_age_flag
576: ,p_rt_frz_cmp_lvl_flag_o =>ben_epo_shd.g_old_rec.rt_frz_cmp_lvl_flag
577: ,p_rt_frz_pct_fl_tm_flag_o =>ben_epo_shd.g_old_rec.rt_frz_pct_fl_tm_flag
570: ,p_rt_hrs_wkd_bndry_perd_cd_o =>ben_epo_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd
571: ,p_rt_age_uom_o =>ben_epo_shd.g_old_rec.rt_age_uom
572: ,p_rt_los_uom_o =>ben_epo_shd.g_old_rec.rt_los_uom
573: ,p_rt_pct_fl_tm_val_o =>ben_epo_shd.g_old_rec.rt_pct_fl_tm_val
574: ,p_rt_frz_los_flag_o =>ben_epo_shd.g_old_rec.rt_frz_los_flag
575: ,p_rt_frz_age_flag_o =>ben_epo_shd.g_old_rec.rt_frz_age_flag
576: ,p_rt_frz_cmp_lvl_flag_o =>ben_epo_shd.g_old_rec.rt_frz_cmp_lvl_flag
577: ,p_rt_frz_pct_fl_tm_flag_o =>ben_epo_shd.g_old_rec.rt_frz_pct_fl_tm_flag
578: ,p_rt_frz_hrs_wkd_flag_o =>ben_epo_shd.g_old_rec.rt_frz_hrs_wkd_flag
571: ,p_rt_age_uom_o =>ben_epo_shd.g_old_rec.rt_age_uom
572: ,p_rt_los_uom_o =>ben_epo_shd.g_old_rec.rt_los_uom
573: ,p_rt_pct_fl_tm_val_o =>ben_epo_shd.g_old_rec.rt_pct_fl_tm_val
574: ,p_rt_frz_los_flag_o =>ben_epo_shd.g_old_rec.rt_frz_los_flag
575: ,p_rt_frz_age_flag_o =>ben_epo_shd.g_old_rec.rt_frz_age_flag
576: ,p_rt_frz_cmp_lvl_flag_o =>ben_epo_shd.g_old_rec.rt_frz_cmp_lvl_flag
577: ,p_rt_frz_pct_fl_tm_flag_o =>ben_epo_shd.g_old_rec.rt_frz_pct_fl_tm_flag
578: ,p_rt_frz_hrs_wkd_flag_o =>ben_epo_shd.g_old_rec.rt_frz_hrs_wkd_flag
579: ,p_rt_frz_comb_age_and_los_fl_o =>ben_epo_shd.g_old_rec.rt_frz_comb_age_and_los_flag
572: ,p_rt_los_uom_o =>ben_epo_shd.g_old_rec.rt_los_uom
573: ,p_rt_pct_fl_tm_val_o =>ben_epo_shd.g_old_rec.rt_pct_fl_tm_val
574: ,p_rt_frz_los_flag_o =>ben_epo_shd.g_old_rec.rt_frz_los_flag
575: ,p_rt_frz_age_flag_o =>ben_epo_shd.g_old_rec.rt_frz_age_flag
576: ,p_rt_frz_cmp_lvl_flag_o =>ben_epo_shd.g_old_rec.rt_frz_cmp_lvl_flag
577: ,p_rt_frz_pct_fl_tm_flag_o =>ben_epo_shd.g_old_rec.rt_frz_pct_fl_tm_flag
578: ,p_rt_frz_hrs_wkd_flag_o =>ben_epo_shd.g_old_rec.rt_frz_hrs_wkd_flag
579: ,p_rt_frz_comb_age_and_los_fl_o =>ben_epo_shd.g_old_rec.rt_frz_comb_age_and_los_flag
580: ,p_comp_ref_amt_o =>ben_epo_shd.g_old_rec.comp_ref_amt
573: ,p_rt_pct_fl_tm_val_o =>ben_epo_shd.g_old_rec.rt_pct_fl_tm_val
574: ,p_rt_frz_los_flag_o =>ben_epo_shd.g_old_rec.rt_frz_los_flag
575: ,p_rt_frz_age_flag_o =>ben_epo_shd.g_old_rec.rt_frz_age_flag
576: ,p_rt_frz_cmp_lvl_flag_o =>ben_epo_shd.g_old_rec.rt_frz_cmp_lvl_flag
577: ,p_rt_frz_pct_fl_tm_flag_o =>ben_epo_shd.g_old_rec.rt_frz_pct_fl_tm_flag
578: ,p_rt_frz_hrs_wkd_flag_o =>ben_epo_shd.g_old_rec.rt_frz_hrs_wkd_flag
579: ,p_rt_frz_comb_age_and_los_fl_o =>ben_epo_shd.g_old_rec.rt_frz_comb_age_and_los_flag
580: ,p_comp_ref_amt_o =>ben_epo_shd.g_old_rec.comp_ref_amt
581: ,p_cmbn_age_n_los_val_o =>ben_epo_shd.g_old_rec.cmbn_age_n_los_val
574: ,p_rt_frz_los_flag_o =>ben_epo_shd.g_old_rec.rt_frz_los_flag
575: ,p_rt_frz_age_flag_o =>ben_epo_shd.g_old_rec.rt_frz_age_flag
576: ,p_rt_frz_cmp_lvl_flag_o =>ben_epo_shd.g_old_rec.rt_frz_cmp_lvl_flag
577: ,p_rt_frz_pct_fl_tm_flag_o =>ben_epo_shd.g_old_rec.rt_frz_pct_fl_tm_flag
578: ,p_rt_frz_hrs_wkd_flag_o =>ben_epo_shd.g_old_rec.rt_frz_hrs_wkd_flag
579: ,p_rt_frz_comb_age_and_los_fl_o =>ben_epo_shd.g_old_rec.rt_frz_comb_age_and_los_flag
580: ,p_comp_ref_amt_o =>ben_epo_shd.g_old_rec.comp_ref_amt
581: ,p_cmbn_age_n_los_val_o =>ben_epo_shd.g_old_rec.cmbn_age_n_los_val
582: ,p_comp_ref_uom_o =>ben_epo_shd.g_old_rec.comp_ref_uom
575: ,p_rt_frz_age_flag_o =>ben_epo_shd.g_old_rec.rt_frz_age_flag
576: ,p_rt_frz_cmp_lvl_flag_o =>ben_epo_shd.g_old_rec.rt_frz_cmp_lvl_flag
577: ,p_rt_frz_pct_fl_tm_flag_o =>ben_epo_shd.g_old_rec.rt_frz_pct_fl_tm_flag
578: ,p_rt_frz_hrs_wkd_flag_o =>ben_epo_shd.g_old_rec.rt_frz_hrs_wkd_flag
579: ,p_rt_frz_comb_age_and_los_fl_o =>ben_epo_shd.g_old_rec.rt_frz_comb_age_and_los_flag
580: ,p_comp_ref_amt_o =>ben_epo_shd.g_old_rec.comp_ref_amt
581: ,p_cmbn_age_n_los_val_o =>ben_epo_shd.g_old_rec.cmbn_age_n_los_val
582: ,p_comp_ref_uom_o =>ben_epo_shd.g_old_rec.comp_ref_uom
583: ,p_age_val_o =>ben_epo_shd.g_old_rec.age_val
576: ,p_rt_frz_cmp_lvl_flag_o =>ben_epo_shd.g_old_rec.rt_frz_cmp_lvl_flag
577: ,p_rt_frz_pct_fl_tm_flag_o =>ben_epo_shd.g_old_rec.rt_frz_pct_fl_tm_flag
578: ,p_rt_frz_hrs_wkd_flag_o =>ben_epo_shd.g_old_rec.rt_frz_hrs_wkd_flag
579: ,p_rt_frz_comb_age_and_los_fl_o =>ben_epo_shd.g_old_rec.rt_frz_comb_age_and_los_flag
580: ,p_comp_ref_amt_o =>ben_epo_shd.g_old_rec.comp_ref_amt
581: ,p_cmbn_age_n_los_val_o =>ben_epo_shd.g_old_rec.cmbn_age_n_los_val
582: ,p_comp_ref_uom_o =>ben_epo_shd.g_old_rec.comp_ref_uom
583: ,p_age_val_o =>ben_epo_shd.g_old_rec.age_val
584: ,p_los_val_o =>ben_epo_shd.g_old_rec.los_val
577: ,p_rt_frz_pct_fl_tm_flag_o =>ben_epo_shd.g_old_rec.rt_frz_pct_fl_tm_flag
578: ,p_rt_frz_hrs_wkd_flag_o =>ben_epo_shd.g_old_rec.rt_frz_hrs_wkd_flag
579: ,p_rt_frz_comb_age_and_los_fl_o =>ben_epo_shd.g_old_rec.rt_frz_comb_age_and_los_flag
580: ,p_comp_ref_amt_o =>ben_epo_shd.g_old_rec.comp_ref_amt
581: ,p_cmbn_age_n_los_val_o =>ben_epo_shd.g_old_rec.cmbn_age_n_los_val
582: ,p_comp_ref_uom_o =>ben_epo_shd.g_old_rec.comp_ref_uom
583: ,p_age_val_o =>ben_epo_shd.g_old_rec.age_val
584: ,p_los_val_o =>ben_epo_shd.g_old_rec.los_val
585: ,p_hrs_wkd_val_o =>ben_epo_shd.g_old_rec.hrs_wkd_val
578: ,p_rt_frz_hrs_wkd_flag_o =>ben_epo_shd.g_old_rec.rt_frz_hrs_wkd_flag
579: ,p_rt_frz_comb_age_and_los_fl_o =>ben_epo_shd.g_old_rec.rt_frz_comb_age_and_los_flag
580: ,p_comp_ref_amt_o =>ben_epo_shd.g_old_rec.comp_ref_amt
581: ,p_cmbn_age_n_los_val_o =>ben_epo_shd.g_old_rec.cmbn_age_n_los_val
582: ,p_comp_ref_uom_o =>ben_epo_shd.g_old_rec.comp_ref_uom
583: ,p_age_val_o =>ben_epo_shd.g_old_rec.age_val
584: ,p_los_val_o =>ben_epo_shd.g_old_rec.los_val
585: ,p_hrs_wkd_val_o =>ben_epo_shd.g_old_rec.hrs_wkd_val
586: ,p_hrs_wkd_bndry_perd_cd_o =>ben_epo_shd.g_old_rec.hrs_wkd_bndry_perd_cd
579: ,p_rt_frz_comb_age_and_los_fl_o =>ben_epo_shd.g_old_rec.rt_frz_comb_age_and_los_flag
580: ,p_comp_ref_amt_o =>ben_epo_shd.g_old_rec.comp_ref_amt
581: ,p_cmbn_age_n_los_val_o =>ben_epo_shd.g_old_rec.cmbn_age_n_los_val
582: ,p_comp_ref_uom_o =>ben_epo_shd.g_old_rec.comp_ref_uom
583: ,p_age_val_o =>ben_epo_shd.g_old_rec.age_val
584: ,p_los_val_o =>ben_epo_shd.g_old_rec.los_val
585: ,p_hrs_wkd_val_o =>ben_epo_shd.g_old_rec.hrs_wkd_val
586: ,p_hrs_wkd_bndry_perd_cd_o =>ben_epo_shd.g_old_rec.hrs_wkd_bndry_perd_cd
587: ,p_age_uom_o =>ben_epo_shd.g_old_rec.age_uom
580: ,p_comp_ref_amt_o =>ben_epo_shd.g_old_rec.comp_ref_amt
581: ,p_cmbn_age_n_los_val_o =>ben_epo_shd.g_old_rec.cmbn_age_n_los_val
582: ,p_comp_ref_uom_o =>ben_epo_shd.g_old_rec.comp_ref_uom
583: ,p_age_val_o =>ben_epo_shd.g_old_rec.age_val
584: ,p_los_val_o =>ben_epo_shd.g_old_rec.los_val
585: ,p_hrs_wkd_val_o =>ben_epo_shd.g_old_rec.hrs_wkd_val
586: ,p_hrs_wkd_bndry_perd_cd_o =>ben_epo_shd.g_old_rec.hrs_wkd_bndry_perd_cd
587: ,p_age_uom_o =>ben_epo_shd.g_old_rec.age_uom
588: ,p_los_uom_o =>ben_epo_shd.g_old_rec.los_uom
581: ,p_cmbn_age_n_los_val_o =>ben_epo_shd.g_old_rec.cmbn_age_n_los_val
582: ,p_comp_ref_uom_o =>ben_epo_shd.g_old_rec.comp_ref_uom
583: ,p_age_val_o =>ben_epo_shd.g_old_rec.age_val
584: ,p_los_val_o =>ben_epo_shd.g_old_rec.los_val
585: ,p_hrs_wkd_val_o =>ben_epo_shd.g_old_rec.hrs_wkd_val
586: ,p_hrs_wkd_bndry_perd_cd_o =>ben_epo_shd.g_old_rec.hrs_wkd_bndry_perd_cd
587: ,p_age_uom_o =>ben_epo_shd.g_old_rec.age_uom
588: ,p_los_uom_o =>ben_epo_shd.g_old_rec.los_uom
589: ,p_frz_los_flag_o =>ben_epo_shd.g_old_rec.frz_los_flag
582: ,p_comp_ref_uom_o =>ben_epo_shd.g_old_rec.comp_ref_uom
583: ,p_age_val_o =>ben_epo_shd.g_old_rec.age_val
584: ,p_los_val_o =>ben_epo_shd.g_old_rec.los_val
585: ,p_hrs_wkd_val_o =>ben_epo_shd.g_old_rec.hrs_wkd_val
586: ,p_hrs_wkd_bndry_perd_cd_o =>ben_epo_shd.g_old_rec.hrs_wkd_bndry_perd_cd
587: ,p_age_uom_o =>ben_epo_shd.g_old_rec.age_uom
588: ,p_los_uom_o =>ben_epo_shd.g_old_rec.los_uom
589: ,p_frz_los_flag_o =>ben_epo_shd.g_old_rec.frz_los_flag
590: ,p_frz_age_flag_o =>ben_epo_shd.g_old_rec.frz_age_flag
583: ,p_age_val_o =>ben_epo_shd.g_old_rec.age_val
584: ,p_los_val_o =>ben_epo_shd.g_old_rec.los_val
585: ,p_hrs_wkd_val_o =>ben_epo_shd.g_old_rec.hrs_wkd_val
586: ,p_hrs_wkd_bndry_perd_cd_o =>ben_epo_shd.g_old_rec.hrs_wkd_bndry_perd_cd
587: ,p_age_uom_o =>ben_epo_shd.g_old_rec.age_uom
588: ,p_los_uom_o =>ben_epo_shd.g_old_rec.los_uom
589: ,p_frz_los_flag_o =>ben_epo_shd.g_old_rec.frz_los_flag
590: ,p_frz_age_flag_o =>ben_epo_shd.g_old_rec.frz_age_flag
591: ,p_frz_cmp_lvl_flag_o =>ben_epo_shd.g_old_rec.frz_cmp_lvl_flag
584: ,p_los_val_o =>ben_epo_shd.g_old_rec.los_val
585: ,p_hrs_wkd_val_o =>ben_epo_shd.g_old_rec.hrs_wkd_val
586: ,p_hrs_wkd_bndry_perd_cd_o =>ben_epo_shd.g_old_rec.hrs_wkd_bndry_perd_cd
587: ,p_age_uom_o =>ben_epo_shd.g_old_rec.age_uom
588: ,p_los_uom_o =>ben_epo_shd.g_old_rec.los_uom
589: ,p_frz_los_flag_o =>ben_epo_shd.g_old_rec.frz_los_flag
590: ,p_frz_age_flag_o =>ben_epo_shd.g_old_rec.frz_age_flag
591: ,p_frz_cmp_lvl_flag_o =>ben_epo_shd.g_old_rec.frz_cmp_lvl_flag
592: ,p_frz_pct_fl_tm_flag_o =>ben_epo_shd.g_old_rec.frz_pct_fl_tm_flag
585: ,p_hrs_wkd_val_o =>ben_epo_shd.g_old_rec.hrs_wkd_val
586: ,p_hrs_wkd_bndry_perd_cd_o =>ben_epo_shd.g_old_rec.hrs_wkd_bndry_perd_cd
587: ,p_age_uom_o =>ben_epo_shd.g_old_rec.age_uom
588: ,p_los_uom_o =>ben_epo_shd.g_old_rec.los_uom
589: ,p_frz_los_flag_o =>ben_epo_shd.g_old_rec.frz_los_flag
590: ,p_frz_age_flag_o =>ben_epo_shd.g_old_rec.frz_age_flag
591: ,p_frz_cmp_lvl_flag_o =>ben_epo_shd.g_old_rec.frz_cmp_lvl_flag
592: ,p_frz_pct_fl_tm_flag_o =>ben_epo_shd.g_old_rec.frz_pct_fl_tm_flag
593: ,p_frz_hrs_wkd_flag_o =>ben_epo_shd.g_old_rec.frz_hrs_wkd_flag
586: ,p_hrs_wkd_bndry_perd_cd_o =>ben_epo_shd.g_old_rec.hrs_wkd_bndry_perd_cd
587: ,p_age_uom_o =>ben_epo_shd.g_old_rec.age_uom
588: ,p_los_uom_o =>ben_epo_shd.g_old_rec.los_uom
589: ,p_frz_los_flag_o =>ben_epo_shd.g_old_rec.frz_los_flag
590: ,p_frz_age_flag_o =>ben_epo_shd.g_old_rec.frz_age_flag
591: ,p_frz_cmp_lvl_flag_o =>ben_epo_shd.g_old_rec.frz_cmp_lvl_flag
592: ,p_frz_pct_fl_tm_flag_o =>ben_epo_shd.g_old_rec.frz_pct_fl_tm_flag
593: ,p_frz_hrs_wkd_flag_o =>ben_epo_shd.g_old_rec.frz_hrs_wkd_flag
594: ,p_frz_comb_age_and_los_flag_o =>ben_epo_shd.g_old_rec.frz_comb_age_and_los_flag
587: ,p_age_uom_o =>ben_epo_shd.g_old_rec.age_uom
588: ,p_los_uom_o =>ben_epo_shd.g_old_rec.los_uom
589: ,p_frz_los_flag_o =>ben_epo_shd.g_old_rec.frz_los_flag
590: ,p_frz_age_flag_o =>ben_epo_shd.g_old_rec.frz_age_flag
591: ,p_frz_cmp_lvl_flag_o =>ben_epo_shd.g_old_rec.frz_cmp_lvl_flag
592: ,p_frz_pct_fl_tm_flag_o =>ben_epo_shd.g_old_rec.frz_pct_fl_tm_flag
593: ,p_frz_hrs_wkd_flag_o =>ben_epo_shd.g_old_rec.frz_hrs_wkd_flag
594: ,p_frz_comb_age_and_los_flag_o =>ben_epo_shd.g_old_rec.frz_comb_age_and_los_flag
595: ,p_ovrid_svc_dt_o =>ben_epo_shd.g_old_rec.ovrid_svc_dt
588: ,p_los_uom_o =>ben_epo_shd.g_old_rec.los_uom
589: ,p_frz_los_flag_o =>ben_epo_shd.g_old_rec.frz_los_flag
590: ,p_frz_age_flag_o =>ben_epo_shd.g_old_rec.frz_age_flag
591: ,p_frz_cmp_lvl_flag_o =>ben_epo_shd.g_old_rec.frz_cmp_lvl_flag
592: ,p_frz_pct_fl_tm_flag_o =>ben_epo_shd.g_old_rec.frz_pct_fl_tm_flag
593: ,p_frz_hrs_wkd_flag_o =>ben_epo_shd.g_old_rec.frz_hrs_wkd_flag
594: ,p_frz_comb_age_and_los_flag_o =>ben_epo_shd.g_old_rec.frz_comb_age_and_los_flag
595: ,p_ovrid_svc_dt_o =>ben_epo_shd.g_old_rec.ovrid_svc_dt
596: ,p_inelg_rsn_cd_o =>ben_epo_shd.g_old_rec.inelg_rsn_cd
589: ,p_frz_los_flag_o =>ben_epo_shd.g_old_rec.frz_los_flag
590: ,p_frz_age_flag_o =>ben_epo_shd.g_old_rec.frz_age_flag
591: ,p_frz_cmp_lvl_flag_o =>ben_epo_shd.g_old_rec.frz_cmp_lvl_flag
592: ,p_frz_pct_fl_tm_flag_o =>ben_epo_shd.g_old_rec.frz_pct_fl_tm_flag
593: ,p_frz_hrs_wkd_flag_o =>ben_epo_shd.g_old_rec.frz_hrs_wkd_flag
594: ,p_frz_comb_age_and_los_flag_o =>ben_epo_shd.g_old_rec.frz_comb_age_and_los_flag
595: ,p_ovrid_svc_dt_o =>ben_epo_shd.g_old_rec.ovrid_svc_dt
596: ,p_inelg_rsn_cd_o =>ben_epo_shd.g_old_rec.inelg_rsn_cd
597: ,p_once_r_cntug_cd_o =>ben_epo_shd.g_old_rec.once_r_cntug_cd
590: ,p_frz_age_flag_o =>ben_epo_shd.g_old_rec.frz_age_flag
591: ,p_frz_cmp_lvl_flag_o =>ben_epo_shd.g_old_rec.frz_cmp_lvl_flag
592: ,p_frz_pct_fl_tm_flag_o =>ben_epo_shd.g_old_rec.frz_pct_fl_tm_flag
593: ,p_frz_hrs_wkd_flag_o =>ben_epo_shd.g_old_rec.frz_hrs_wkd_flag
594: ,p_frz_comb_age_and_los_flag_o =>ben_epo_shd.g_old_rec.frz_comb_age_and_los_flag
595: ,p_ovrid_svc_dt_o =>ben_epo_shd.g_old_rec.ovrid_svc_dt
596: ,p_inelg_rsn_cd_o =>ben_epo_shd.g_old_rec.inelg_rsn_cd
597: ,p_once_r_cntug_cd_o =>ben_epo_shd.g_old_rec.once_r_cntug_cd
598: ,p_oipl_ordr_num_o =>ben_epo_shd.g_old_rec.oipl_ordr_num
591: ,p_frz_cmp_lvl_flag_o =>ben_epo_shd.g_old_rec.frz_cmp_lvl_flag
592: ,p_frz_pct_fl_tm_flag_o =>ben_epo_shd.g_old_rec.frz_pct_fl_tm_flag
593: ,p_frz_hrs_wkd_flag_o =>ben_epo_shd.g_old_rec.frz_hrs_wkd_flag
594: ,p_frz_comb_age_and_los_flag_o =>ben_epo_shd.g_old_rec.frz_comb_age_and_los_flag
595: ,p_ovrid_svc_dt_o =>ben_epo_shd.g_old_rec.ovrid_svc_dt
596: ,p_inelg_rsn_cd_o =>ben_epo_shd.g_old_rec.inelg_rsn_cd
597: ,p_once_r_cntug_cd_o =>ben_epo_shd.g_old_rec.once_r_cntug_cd
598: ,p_oipl_ordr_num_o =>ben_epo_shd.g_old_rec.oipl_ordr_num
599: ,p_business_group_id_o =>ben_epo_shd.g_old_rec.business_group_id
592: ,p_frz_pct_fl_tm_flag_o =>ben_epo_shd.g_old_rec.frz_pct_fl_tm_flag
593: ,p_frz_hrs_wkd_flag_o =>ben_epo_shd.g_old_rec.frz_hrs_wkd_flag
594: ,p_frz_comb_age_and_los_flag_o =>ben_epo_shd.g_old_rec.frz_comb_age_and_los_flag
595: ,p_ovrid_svc_dt_o =>ben_epo_shd.g_old_rec.ovrid_svc_dt
596: ,p_inelg_rsn_cd_o =>ben_epo_shd.g_old_rec.inelg_rsn_cd
597: ,p_once_r_cntug_cd_o =>ben_epo_shd.g_old_rec.once_r_cntug_cd
598: ,p_oipl_ordr_num_o =>ben_epo_shd.g_old_rec.oipl_ordr_num
599: ,p_business_group_id_o =>ben_epo_shd.g_old_rec.business_group_id
600: ,p_epo_attribute_category_o =>ben_epo_shd.g_old_rec.epo_attribute_category
593: ,p_frz_hrs_wkd_flag_o =>ben_epo_shd.g_old_rec.frz_hrs_wkd_flag
594: ,p_frz_comb_age_and_los_flag_o =>ben_epo_shd.g_old_rec.frz_comb_age_and_los_flag
595: ,p_ovrid_svc_dt_o =>ben_epo_shd.g_old_rec.ovrid_svc_dt
596: ,p_inelg_rsn_cd_o =>ben_epo_shd.g_old_rec.inelg_rsn_cd
597: ,p_once_r_cntug_cd_o =>ben_epo_shd.g_old_rec.once_r_cntug_cd
598: ,p_oipl_ordr_num_o =>ben_epo_shd.g_old_rec.oipl_ordr_num
599: ,p_business_group_id_o =>ben_epo_shd.g_old_rec.business_group_id
600: ,p_epo_attribute_category_o =>ben_epo_shd.g_old_rec.epo_attribute_category
601: ,p_epo_attribute1_o =>ben_epo_shd.g_old_rec.epo_attribute1
594: ,p_frz_comb_age_and_los_flag_o =>ben_epo_shd.g_old_rec.frz_comb_age_and_los_flag
595: ,p_ovrid_svc_dt_o =>ben_epo_shd.g_old_rec.ovrid_svc_dt
596: ,p_inelg_rsn_cd_o =>ben_epo_shd.g_old_rec.inelg_rsn_cd
597: ,p_once_r_cntug_cd_o =>ben_epo_shd.g_old_rec.once_r_cntug_cd
598: ,p_oipl_ordr_num_o =>ben_epo_shd.g_old_rec.oipl_ordr_num
599: ,p_business_group_id_o =>ben_epo_shd.g_old_rec.business_group_id
600: ,p_epo_attribute_category_o =>ben_epo_shd.g_old_rec.epo_attribute_category
601: ,p_epo_attribute1_o =>ben_epo_shd.g_old_rec.epo_attribute1
602: ,p_epo_attribute2_o =>ben_epo_shd.g_old_rec.epo_attribute2
595: ,p_ovrid_svc_dt_o =>ben_epo_shd.g_old_rec.ovrid_svc_dt
596: ,p_inelg_rsn_cd_o =>ben_epo_shd.g_old_rec.inelg_rsn_cd
597: ,p_once_r_cntug_cd_o =>ben_epo_shd.g_old_rec.once_r_cntug_cd
598: ,p_oipl_ordr_num_o =>ben_epo_shd.g_old_rec.oipl_ordr_num
599: ,p_business_group_id_o =>ben_epo_shd.g_old_rec.business_group_id
600: ,p_epo_attribute_category_o =>ben_epo_shd.g_old_rec.epo_attribute_category
601: ,p_epo_attribute1_o =>ben_epo_shd.g_old_rec.epo_attribute1
602: ,p_epo_attribute2_o =>ben_epo_shd.g_old_rec.epo_attribute2
603: ,p_epo_attribute3_o =>ben_epo_shd.g_old_rec.epo_attribute3
596: ,p_inelg_rsn_cd_o =>ben_epo_shd.g_old_rec.inelg_rsn_cd
597: ,p_once_r_cntug_cd_o =>ben_epo_shd.g_old_rec.once_r_cntug_cd
598: ,p_oipl_ordr_num_o =>ben_epo_shd.g_old_rec.oipl_ordr_num
599: ,p_business_group_id_o =>ben_epo_shd.g_old_rec.business_group_id
600: ,p_epo_attribute_category_o =>ben_epo_shd.g_old_rec.epo_attribute_category
601: ,p_epo_attribute1_o =>ben_epo_shd.g_old_rec.epo_attribute1
602: ,p_epo_attribute2_o =>ben_epo_shd.g_old_rec.epo_attribute2
603: ,p_epo_attribute3_o =>ben_epo_shd.g_old_rec.epo_attribute3
604: ,p_epo_attribute4_o =>ben_epo_shd.g_old_rec.epo_attribute4
597: ,p_once_r_cntug_cd_o =>ben_epo_shd.g_old_rec.once_r_cntug_cd
598: ,p_oipl_ordr_num_o =>ben_epo_shd.g_old_rec.oipl_ordr_num
599: ,p_business_group_id_o =>ben_epo_shd.g_old_rec.business_group_id
600: ,p_epo_attribute_category_o =>ben_epo_shd.g_old_rec.epo_attribute_category
601: ,p_epo_attribute1_o =>ben_epo_shd.g_old_rec.epo_attribute1
602: ,p_epo_attribute2_o =>ben_epo_shd.g_old_rec.epo_attribute2
603: ,p_epo_attribute3_o =>ben_epo_shd.g_old_rec.epo_attribute3
604: ,p_epo_attribute4_o =>ben_epo_shd.g_old_rec.epo_attribute4
605: ,p_epo_attribute5_o =>ben_epo_shd.g_old_rec.epo_attribute5
598: ,p_oipl_ordr_num_o =>ben_epo_shd.g_old_rec.oipl_ordr_num
599: ,p_business_group_id_o =>ben_epo_shd.g_old_rec.business_group_id
600: ,p_epo_attribute_category_o =>ben_epo_shd.g_old_rec.epo_attribute_category
601: ,p_epo_attribute1_o =>ben_epo_shd.g_old_rec.epo_attribute1
602: ,p_epo_attribute2_o =>ben_epo_shd.g_old_rec.epo_attribute2
603: ,p_epo_attribute3_o =>ben_epo_shd.g_old_rec.epo_attribute3
604: ,p_epo_attribute4_o =>ben_epo_shd.g_old_rec.epo_attribute4
605: ,p_epo_attribute5_o =>ben_epo_shd.g_old_rec.epo_attribute5
606: ,p_epo_attribute6_o =>ben_epo_shd.g_old_rec.epo_attribute6
599: ,p_business_group_id_o =>ben_epo_shd.g_old_rec.business_group_id
600: ,p_epo_attribute_category_o =>ben_epo_shd.g_old_rec.epo_attribute_category
601: ,p_epo_attribute1_o =>ben_epo_shd.g_old_rec.epo_attribute1
602: ,p_epo_attribute2_o =>ben_epo_shd.g_old_rec.epo_attribute2
603: ,p_epo_attribute3_o =>ben_epo_shd.g_old_rec.epo_attribute3
604: ,p_epo_attribute4_o =>ben_epo_shd.g_old_rec.epo_attribute4
605: ,p_epo_attribute5_o =>ben_epo_shd.g_old_rec.epo_attribute5
606: ,p_epo_attribute6_o =>ben_epo_shd.g_old_rec.epo_attribute6
607: ,p_epo_attribute7_o =>ben_epo_shd.g_old_rec.epo_attribute7
600: ,p_epo_attribute_category_o =>ben_epo_shd.g_old_rec.epo_attribute_category
601: ,p_epo_attribute1_o =>ben_epo_shd.g_old_rec.epo_attribute1
602: ,p_epo_attribute2_o =>ben_epo_shd.g_old_rec.epo_attribute2
603: ,p_epo_attribute3_o =>ben_epo_shd.g_old_rec.epo_attribute3
604: ,p_epo_attribute4_o =>ben_epo_shd.g_old_rec.epo_attribute4
605: ,p_epo_attribute5_o =>ben_epo_shd.g_old_rec.epo_attribute5
606: ,p_epo_attribute6_o =>ben_epo_shd.g_old_rec.epo_attribute6
607: ,p_epo_attribute7_o =>ben_epo_shd.g_old_rec.epo_attribute7
608: ,p_epo_attribute8_o =>ben_epo_shd.g_old_rec.epo_attribute8
601: ,p_epo_attribute1_o =>ben_epo_shd.g_old_rec.epo_attribute1
602: ,p_epo_attribute2_o =>ben_epo_shd.g_old_rec.epo_attribute2
603: ,p_epo_attribute3_o =>ben_epo_shd.g_old_rec.epo_attribute3
604: ,p_epo_attribute4_o =>ben_epo_shd.g_old_rec.epo_attribute4
605: ,p_epo_attribute5_o =>ben_epo_shd.g_old_rec.epo_attribute5
606: ,p_epo_attribute6_o =>ben_epo_shd.g_old_rec.epo_attribute6
607: ,p_epo_attribute7_o =>ben_epo_shd.g_old_rec.epo_attribute7
608: ,p_epo_attribute8_o =>ben_epo_shd.g_old_rec.epo_attribute8
609: ,p_epo_attribute9_o =>ben_epo_shd.g_old_rec.epo_attribute9
602: ,p_epo_attribute2_o =>ben_epo_shd.g_old_rec.epo_attribute2
603: ,p_epo_attribute3_o =>ben_epo_shd.g_old_rec.epo_attribute3
604: ,p_epo_attribute4_o =>ben_epo_shd.g_old_rec.epo_attribute4
605: ,p_epo_attribute5_o =>ben_epo_shd.g_old_rec.epo_attribute5
606: ,p_epo_attribute6_o =>ben_epo_shd.g_old_rec.epo_attribute6
607: ,p_epo_attribute7_o =>ben_epo_shd.g_old_rec.epo_attribute7
608: ,p_epo_attribute8_o =>ben_epo_shd.g_old_rec.epo_attribute8
609: ,p_epo_attribute9_o =>ben_epo_shd.g_old_rec.epo_attribute9
610: ,p_epo_attribute10_o =>ben_epo_shd.g_old_rec.epo_attribute10
603: ,p_epo_attribute3_o =>ben_epo_shd.g_old_rec.epo_attribute3
604: ,p_epo_attribute4_o =>ben_epo_shd.g_old_rec.epo_attribute4
605: ,p_epo_attribute5_o =>ben_epo_shd.g_old_rec.epo_attribute5
606: ,p_epo_attribute6_o =>ben_epo_shd.g_old_rec.epo_attribute6
607: ,p_epo_attribute7_o =>ben_epo_shd.g_old_rec.epo_attribute7
608: ,p_epo_attribute8_o =>ben_epo_shd.g_old_rec.epo_attribute8
609: ,p_epo_attribute9_o =>ben_epo_shd.g_old_rec.epo_attribute9
610: ,p_epo_attribute10_o =>ben_epo_shd.g_old_rec.epo_attribute10
611: ,p_epo_attribute11_o =>ben_epo_shd.g_old_rec.epo_attribute11
604: ,p_epo_attribute4_o =>ben_epo_shd.g_old_rec.epo_attribute4
605: ,p_epo_attribute5_o =>ben_epo_shd.g_old_rec.epo_attribute5
606: ,p_epo_attribute6_o =>ben_epo_shd.g_old_rec.epo_attribute6
607: ,p_epo_attribute7_o =>ben_epo_shd.g_old_rec.epo_attribute7
608: ,p_epo_attribute8_o =>ben_epo_shd.g_old_rec.epo_attribute8
609: ,p_epo_attribute9_o =>ben_epo_shd.g_old_rec.epo_attribute9
610: ,p_epo_attribute10_o =>ben_epo_shd.g_old_rec.epo_attribute10
611: ,p_epo_attribute11_o =>ben_epo_shd.g_old_rec.epo_attribute11
612: ,p_epo_attribute12_o =>ben_epo_shd.g_old_rec.epo_attribute12
605: ,p_epo_attribute5_o =>ben_epo_shd.g_old_rec.epo_attribute5
606: ,p_epo_attribute6_o =>ben_epo_shd.g_old_rec.epo_attribute6
607: ,p_epo_attribute7_o =>ben_epo_shd.g_old_rec.epo_attribute7
608: ,p_epo_attribute8_o =>ben_epo_shd.g_old_rec.epo_attribute8
609: ,p_epo_attribute9_o =>ben_epo_shd.g_old_rec.epo_attribute9
610: ,p_epo_attribute10_o =>ben_epo_shd.g_old_rec.epo_attribute10
611: ,p_epo_attribute11_o =>ben_epo_shd.g_old_rec.epo_attribute11
612: ,p_epo_attribute12_o =>ben_epo_shd.g_old_rec.epo_attribute12
613: ,p_epo_attribute13_o =>ben_epo_shd.g_old_rec.epo_attribute13
606: ,p_epo_attribute6_o =>ben_epo_shd.g_old_rec.epo_attribute6
607: ,p_epo_attribute7_o =>ben_epo_shd.g_old_rec.epo_attribute7
608: ,p_epo_attribute8_o =>ben_epo_shd.g_old_rec.epo_attribute8
609: ,p_epo_attribute9_o =>ben_epo_shd.g_old_rec.epo_attribute9
610: ,p_epo_attribute10_o =>ben_epo_shd.g_old_rec.epo_attribute10
611: ,p_epo_attribute11_o =>ben_epo_shd.g_old_rec.epo_attribute11
612: ,p_epo_attribute12_o =>ben_epo_shd.g_old_rec.epo_attribute12
613: ,p_epo_attribute13_o =>ben_epo_shd.g_old_rec.epo_attribute13
614: ,p_epo_attribute14_o =>ben_epo_shd.g_old_rec.epo_attribute14
607: ,p_epo_attribute7_o =>ben_epo_shd.g_old_rec.epo_attribute7
608: ,p_epo_attribute8_o =>ben_epo_shd.g_old_rec.epo_attribute8
609: ,p_epo_attribute9_o =>ben_epo_shd.g_old_rec.epo_attribute9
610: ,p_epo_attribute10_o =>ben_epo_shd.g_old_rec.epo_attribute10
611: ,p_epo_attribute11_o =>ben_epo_shd.g_old_rec.epo_attribute11
612: ,p_epo_attribute12_o =>ben_epo_shd.g_old_rec.epo_attribute12
613: ,p_epo_attribute13_o =>ben_epo_shd.g_old_rec.epo_attribute13
614: ,p_epo_attribute14_o =>ben_epo_shd.g_old_rec.epo_attribute14
615: ,p_epo_attribute15_o =>ben_epo_shd.g_old_rec.epo_attribute15
608: ,p_epo_attribute8_o =>ben_epo_shd.g_old_rec.epo_attribute8
609: ,p_epo_attribute9_o =>ben_epo_shd.g_old_rec.epo_attribute9
610: ,p_epo_attribute10_o =>ben_epo_shd.g_old_rec.epo_attribute10
611: ,p_epo_attribute11_o =>ben_epo_shd.g_old_rec.epo_attribute11
612: ,p_epo_attribute12_o =>ben_epo_shd.g_old_rec.epo_attribute12
613: ,p_epo_attribute13_o =>ben_epo_shd.g_old_rec.epo_attribute13
614: ,p_epo_attribute14_o =>ben_epo_shd.g_old_rec.epo_attribute14
615: ,p_epo_attribute15_o =>ben_epo_shd.g_old_rec.epo_attribute15
616: ,p_epo_attribute16_o =>ben_epo_shd.g_old_rec.epo_attribute16
609: ,p_epo_attribute9_o =>ben_epo_shd.g_old_rec.epo_attribute9
610: ,p_epo_attribute10_o =>ben_epo_shd.g_old_rec.epo_attribute10
611: ,p_epo_attribute11_o =>ben_epo_shd.g_old_rec.epo_attribute11
612: ,p_epo_attribute12_o =>ben_epo_shd.g_old_rec.epo_attribute12
613: ,p_epo_attribute13_o =>ben_epo_shd.g_old_rec.epo_attribute13
614: ,p_epo_attribute14_o =>ben_epo_shd.g_old_rec.epo_attribute14
615: ,p_epo_attribute15_o =>ben_epo_shd.g_old_rec.epo_attribute15
616: ,p_epo_attribute16_o =>ben_epo_shd.g_old_rec.epo_attribute16
617: ,p_epo_attribute17_o =>ben_epo_shd.g_old_rec.epo_attribute17
610: ,p_epo_attribute10_o =>ben_epo_shd.g_old_rec.epo_attribute10
611: ,p_epo_attribute11_o =>ben_epo_shd.g_old_rec.epo_attribute11
612: ,p_epo_attribute12_o =>ben_epo_shd.g_old_rec.epo_attribute12
613: ,p_epo_attribute13_o =>ben_epo_shd.g_old_rec.epo_attribute13
614: ,p_epo_attribute14_o =>ben_epo_shd.g_old_rec.epo_attribute14
615: ,p_epo_attribute15_o =>ben_epo_shd.g_old_rec.epo_attribute15
616: ,p_epo_attribute16_o =>ben_epo_shd.g_old_rec.epo_attribute16
617: ,p_epo_attribute17_o =>ben_epo_shd.g_old_rec.epo_attribute17
618: ,p_epo_attribute18_o =>ben_epo_shd.g_old_rec.epo_attribute18
611: ,p_epo_attribute11_o =>ben_epo_shd.g_old_rec.epo_attribute11
612: ,p_epo_attribute12_o =>ben_epo_shd.g_old_rec.epo_attribute12
613: ,p_epo_attribute13_o =>ben_epo_shd.g_old_rec.epo_attribute13
614: ,p_epo_attribute14_o =>ben_epo_shd.g_old_rec.epo_attribute14
615: ,p_epo_attribute15_o =>ben_epo_shd.g_old_rec.epo_attribute15
616: ,p_epo_attribute16_o =>ben_epo_shd.g_old_rec.epo_attribute16
617: ,p_epo_attribute17_o =>ben_epo_shd.g_old_rec.epo_attribute17
618: ,p_epo_attribute18_o =>ben_epo_shd.g_old_rec.epo_attribute18
619: ,p_epo_attribute19_o =>ben_epo_shd.g_old_rec.epo_attribute19
612: ,p_epo_attribute12_o =>ben_epo_shd.g_old_rec.epo_attribute12
613: ,p_epo_attribute13_o =>ben_epo_shd.g_old_rec.epo_attribute13
614: ,p_epo_attribute14_o =>ben_epo_shd.g_old_rec.epo_attribute14
615: ,p_epo_attribute15_o =>ben_epo_shd.g_old_rec.epo_attribute15
616: ,p_epo_attribute16_o =>ben_epo_shd.g_old_rec.epo_attribute16
617: ,p_epo_attribute17_o =>ben_epo_shd.g_old_rec.epo_attribute17
618: ,p_epo_attribute18_o =>ben_epo_shd.g_old_rec.epo_attribute18
619: ,p_epo_attribute19_o =>ben_epo_shd.g_old_rec.epo_attribute19
620: ,p_epo_attribute20_o =>ben_epo_shd.g_old_rec.epo_attribute20
613: ,p_epo_attribute13_o =>ben_epo_shd.g_old_rec.epo_attribute13
614: ,p_epo_attribute14_o =>ben_epo_shd.g_old_rec.epo_attribute14
615: ,p_epo_attribute15_o =>ben_epo_shd.g_old_rec.epo_attribute15
616: ,p_epo_attribute16_o =>ben_epo_shd.g_old_rec.epo_attribute16
617: ,p_epo_attribute17_o =>ben_epo_shd.g_old_rec.epo_attribute17
618: ,p_epo_attribute18_o =>ben_epo_shd.g_old_rec.epo_attribute18
619: ,p_epo_attribute19_o =>ben_epo_shd.g_old_rec.epo_attribute19
620: ,p_epo_attribute20_o =>ben_epo_shd.g_old_rec.epo_attribute20
621: ,p_epo_attribute21_o =>ben_epo_shd.g_old_rec.epo_attribute21
614: ,p_epo_attribute14_o =>ben_epo_shd.g_old_rec.epo_attribute14
615: ,p_epo_attribute15_o =>ben_epo_shd.g_old_rec.epo_attribute15
616: ,p_epo_attribute16_o =>ben_epo_shd.g_old_rec.epo_attribute16
617: ,p_epo_attribute17_o =>ben_epo_shd.g_old_rec.epo_attribute17
618: ,p_epo_attribute18_o =>ben_epo_shd.g_old_rec.epo_attribute18
619: ,p_epo_attribute19_o =>ben_epo_shd.g_old_rec.epo_attribute19
620: ,p_epo_attribute20_o =>ben_epo_shd.g_old_rec.epo_attribute20
621: ,p_epo_attribute21_o =>ben_epo_shd.g_old_rec.epo_attribute21
622: ,p_epo_attribute22_o =>ben_epo_shd.g_old_rec.epo_attribute22
615: ,p_epo_attribute15_o =>ben_epo_shd.g_old_rec.epo_attribute15
616: ,p_epo_attribute16_o =>ben_epo_shd.g_old_rec.epo_attribute16
617: ,p_epo_attribute17_o =>ben_epo_shd.g_old_rec.epo_attribute17
618: ,p_epo_attribute18_o =>ben_epo_shd.g_old_rec.epo_attribute18
619: ,p_epo_attribute19_o =>ben_epo_shd.g_old_rec.epo_attribute19
620: ,p_epo_attribute20_o =>ben_epo_shd.g_old_rec.epo_attribute20
621: ,p_epo_attribute21_o =>ben_epo_shd.g_old_rec.epo_attribute21
622: ,p_epo_attribute22_o =>ben_epo_shd.g_old_rec.epo_attribute22
623: ,p_epo_attribute23_o =>ben_epo_shd.g_old_rec.epo_attribute23
616: ,p_epo_attribute16_o =>ben_epo_shd.g_old_rec.epo_attribute16
617: ,p_epo_attribute17_o =>ben_epo_shd.g_old_rec.epo_attribute17
618: ,p_epo_attribute18_o =>ben_epo_shd.g_old_rec.epo_attribute18
619: ,p_epo_attribute19_o =>ben_epo_shd.g_old_rec.epo_attribute19
620: ,p_epo_attribute20_o =>ben_epo_shd.g_old_rec.epo_attribute20
621: ,p_epo_attribute21_o =>ben_epo_shd.g_old_rec.epo_attribute21
622: ,p_epo_attribute22_o =>ben_epo_shd.g_old_rec.epo_attribute22
623: ,p_epo_attribute23_o =>ben_epo_shd.g_old_rec.epo_attribute23
624: ,p_epo_attribute24_o =>ben_epo_shd.g_old_rec.epo_attribute24
617: ,p_epo_attribute17_o =>ben_epo_shd.g_old_rec.epo_attribute17
618: ,p_epo_attribute18_o =>ben_epo_shd.g_old_rec.epo_attribute18
619: ,p_epo_attribute19_o =>ben_epo_shd.g_old_rec.epo_attribute19
620: ,p_epo_attribute20_o =>ben_epo_shd.g_old_rec.epo_attribute20
621: ,p_epo_attribute21_o =>ben_epo_shd.g_old_rec.epo_attribute21
622: ,p_epo_attribute22_o =>ben_epo_shd.g_old_rec.epo_attribute22
623: ,p_epo_attribute23_o =>ben_epo_shd.g_old_rec.epo_attribute23
624: ,p_epo_attribute24_o =>ben_epo_shd.g_old_rec.epo_attribute24
625: ,p_epo_attribute25_o =>ben_epo_shd.g_old_rec.epo_attribute25
618: ,p_epo_attribute18_o =>ben_epo_shd.g_old_rec.epo_attribute18
619: ,p_epo_attribute19_o =>ben_epo_shd.g_old_rec.epo_attribute19
620: ,p_epo_attribute20_o =>ben_epo_shd.g_old_rec.epo_attribute20
621: ,p_epo_attribute21_o =>ben_epo_shd.g_old_rec.epo_attribute21
622: ,p_epo_attribute22_o =>ben_epo_shd.g_old_rec.epo_attribute22
623: ,p_epo_attribute23_o =>ben_epo_shd.g_old_rec.epo_attribute23
624: ,p_epo_attribute24_o =>ben_epo_shd.g_old_rec.epo_attribute24
625: ,p_epo_attribute25_o =>ben_epo_shd.g_old_rec.epo_attribute25
626: ,p_epo_attribute26_o =>ben_epo_shd.g_old_rec.epo_attribute26
619: ,p_epo_attribute19_o =>ben_epo_shd.g_old_rec.epo_attribute19
620: ,p_epo_attribute20_o =>ben_epo_shd.g_old_rec.epo_attribute20
621: ,p_epo_attribute21_o =>ben_epo_shd.g_old_rec.epo_attribute21
622: ,p_epo_attribute22_o =>ben_epo_shd.g_old_rec.epo_attribute22
623: ,p_epo_attribute23_o =>ben_epo_shd.g_old_rec.epo_attribute23
624: ,p_epo_attribute24_o =>ben_epo_shd.g_old_rec.epo_attribute24
625: ,p_epo_attribute25_o =>ben_epo_shd.g_old_rec.epo_attribute25
626: ,p_epo_attribute26_o =>ben_epo_shd.g_old_rec.epo_attribute26
627: ,p_epo_attribute27_o =>ben_epo_shd.g_old_rec.epo_attribute27
620: ,p_epo_attribute20_o =>ben_epo_shd.g_old_rec.epo_attribute20
621: ,p_epo_attribute21_o =>ben_epo_shd.g_old_rec.epo_attribute21
622: ,p_epo_attribute22_o =>ben_epo_shd.g_old_rec.epo_attribute22
623: ,p_epo_attribute23_o =>ben_epo_shd.g_old_rec.epo_attribute23
624: ,p_epo_attribute24_o =>ben_epo_shd.g_old_rec.epo_attribute24
625: ,p_epo_attribute25_o =>ben_epo_shd.g_old_rec.epo_attribute25
626: ,p_epo_attribute26_o =>ben_epo_shd.g_old_rec.epo_attribute26
627: ,p_epo_attribute27_o =>ben_epo_shd.g_old_rec.epo_attribute27
628: ,p_epo_attribute28_o =>ben_epo_shd.g_old_rec.epo_attribute28
621: ,p_epo_attribute21_o =>ben_epo_shd.g_old_rec.epo_attribute21
622: ,p_epo_attribute22_o =>ben_epo_shd.g_old_rec.epo_attribute22
623: ,p_epo_attribute23_o =>ben_epo_shd.g_old_rec.epo_attribute23
624: ,p_epo_attribute24_o =>ben_epo_shd.g_old_rec.epo_attribute24
625: ,p_epo_attribute25_o =>ben_epo_shd.g_old_rec.epo_attribute25
626: ,p_epo_attribute26_o =>ben_epo_shd.g_old_rec.epo_attribute26
627: ,p_epo_attribute27_o =>ben_epo_shd.g_old_rec.epo_attribute27
628: ,p_epo_attribute28_o =>ben_epo_shd.g_old_rec.epo_attribute28
629: ,p_epo_attribute29_o =>ben_epo_shd.g_old_rec.epo_attribute29
622: ,p_epo_attribute22_o =>ben_epo_shd.g_old_rec.epo_attribute22
623: ,p_epo_attribute23_o =>ben_epo_shd.g_old_rec.epo_attribute23
624: ,p_epo_attribute24_o =>ben_epo_shd.g_old_rec.epo_attribute24
625: ,p_epo_attribute25_o =>ben_epo_shd.g_old_rec.epo_attribute25
626: ,p_epo_attribute26_o =>ben_epo_shd.g_old_rec.epo_attribute26
627: ,p_epo_attribute27_o =>ben_epo_shd.g_old_rec.epo_attribute27
628: ,p_epo_attribute28_o =>ben_epo_shd.g_old_rec.epo_attribute28
629: ,p_epo_attribute29_o =>ben_epo_shd.g_old_rec.epo_attribute29
630: ,p_epo_attribute30_o =>ben_epo_shd.g_old_rec.epo_attribute30
623: ,p_epo_attribute23_o =>ben_epo_shd.g_old_rec.epo_attribute23
624: ,p_epo_attribute24_o =>ben_epo_shd.g_old_rec.epo_attribute24
625: ,p_epo_attribute25_o =>ben_epo_shd.g_old_rec.epo_attribute25
626: ,p_epo_attribute26_o =>ben_epo_shd.g_old_rec.epo_attribute26
627: ,p_epo_attribute27_o =>ben_epo_shd.g_old_rec.epo_attribute27
628: ,p_epo_attribute28_o =>ben_epo_shd.g_old_rec.epo_attribute28
629: ,p_epo_attribute29_o =>ben_epo_shd.g_old_rec.epo_attribute29
630: ,p_epo_attribute30_o =>ben_epo_shd.g_old_rec.epo_attribute30
631: ,p_request_id_o =>ben_epo_shd.g_old_rec.request_id
624: ,p_epo_attribute24_o =>ben_epo_shd.g_old_rec.epo_attribute24
625: ,p_epo_attribute25_o =>ben_epo_shd.g_old_rec.epo_attribute25
626: ,p_epo_attribute26_o =>ben_epo_shd.g_old_rec.epo_attribute26
627: ,p_epo_attribute27_o =>ben_epo_shd.g_old_rec.epo_attribute27
628: ,p_epo_attribute28_o =>ben_epo_shd.g_old_rec.epo_attribute28
629: ,p_epo_attribute29_o =>ben_epo_shd.g_old_rec.epo_attribute29
630: ,p_epo_attribute30_o =>ben_epo_shd.g_old_rec.epo_attribute30
631: ,p_request_id_o =>ben_epo_shd.g_old_rec.request_id
632: ,p_program_application_id_o =>ben_epo_shd.g_old_rec.program_application_id
625: ,p_epo_attribute25_o =>ben_epo_shd.g_old_rec.epo_attribute25
626: ,p_epo_attribute26_o =>ben_epo_shd.g_old_rec.epo_attribute26
627: ,p_epo_attribute27_o =>ben_epo_shd.g_old_rec.epo_attribute27
628: ,p_epo_attribute28_o =>ben_epo_shd.g_old_rec.epo_attribute28
629: ,p_epo_attribute29_o =>ben_epo_shd.g_old_rec.epo_attribute29
630: ,p_epo_attribute30_o =>ben_epo_shd.g_old_rec.epo_attribute30
631: ,p_request_id_o =>ben_epo_shd.g_old_rec.request_id
632: ,p_program_application_id_o =>ben_epo_shd.g_old_rec.program_application_id
633: ,p_program_id_o =>ben_epo_shd.g_old_rec.program_id
626: ,p_epo_attribute26_o =>ben_epo_shd.g_old_rec.epo_attribute26
627: ,p_epo_attribute27_o =>ben_epo_shd.g_old_rec.epo_attribute27
628: ,p_epo_attribute28_o =>ben_epo_shd.g_old_rec.epo_attribute28
629: ,p_epo_attribute29_o =>ben_epo_shd.g_old_rec.epo_attribute29
630: ,p_epo_attribute30_o =>ben_epo_shd.g_old_rec.epo_attribute30
631: ,p_request_id_o =>ben_epo_shd.g_old_rec.request_id
632: ,p_program_application_id_o =>ben_epo_shd.g_old_rec.program_application_id
633: ,p_program_id_o =>ben_epo_shd.g_old_rec.program_id
634: ,p_program_update_date_o =>ben_epo_shd.g_old_rec.program_update_date
627: ,p_epo_attribute27_o =>ben_epo_shd.g_old_rec.epo_attribute27
628: ,p_epo_attribute28_o =>ben_epo_shd.g_old_rec.epo_attribute28
629: ,p_epo_attribute29_o =>ben_epo_shd.g_old_rec.epo_attribute29
630: ,p_epo_attribute30_o =>ben_epo_shd.g_old_rec.epo_attribute30
631: ,p_request_id_o =>ben_epo_shd.g_old_rec.request_id
632: ,p_program_application_id_o =>ben_epo_shd.g_old_rec.program_application_id
633: ,p_program_id_o =>ben_epo_shd.g_old_rec.program_id
634: ,p_program_update_date_o =>ben_epo_shd.g_old_rec.program_update_date
635: ,p_object_version_number_o =>ben_epo_shd.g_old_rec.object_version_number
628: ,p_epo_attribute28_o =>ben_epo_shd.g_old_rec.epo_attribute28
629: ,p_epo_attribute29_o =>ben_epo_shd.g_old_rec.epo_attribute29
630: ,p_epo_attribute30_o =>ben_epo_shd.g_old_rec.epo_attribute30
631: ,p_request_id_o =>ben_epo_shd.g_old_rec.request_id
632: ,p_program_application_id_o =>ben_epo_shd.g_old_rec.program_application_id
633: ,p_program_id_o =>ben_epo_shd.g_old_rec.program_id
634: ,p_program_update_date_o =>ben_epo_shd.g_old_rec.program_update_date
635: ,p_object_version_number_o =>ben_epo_shd.g_old_rec.object_version_number
636: );
629: ,p_epo_attribute29_o =>ben_epo_shd.g_old_rec.epo_attribute29
630: ,p_epo_attribute30_o =>ben_epo_shd.g_old_rec.epo_attribute30
631: ,p_request_id_o =>ben_epo_shd.g_old_rec.request_id
632: ,p_program_application_id_o =>ben_epo_shd.g_old_rec.program_application_id
633: ,p_program_id_o =>ben_epo_shd.g_old_rec.program_id
634: ,p_program_update_date_o =>ben_epo_shd.g_old_rec.program_update_date
635: ,p_object_version_number_o =>ben_epo_shd.g_old_rec.object_version_number
636: );
637: --
630: ,p_epo_attribute30_o =>ben_epo_shd.g_old_rec.epo_attribute30
631: ,p_request_id_o =>ben_epo_shd.g_old_rec.request_id
632: ,p_program_application_id_o =>ben_epo_shd.g_old_rec.program_application_id
633: ,p_program_id_o =>ben_epo_shd.g_old_rec.program_id
634: ,p_program_update_date_o =>ben_epo_shd.g_old_rec.program_update_date
635: ,p_object_version_number_o =>ben_epo_shd.g_old_rec.object_version_number
636: );
637: --
638: exception
631: ,p_request_id_o =>ben_epo_shd.g_old_rec.request_id
632: ,p_program_application_id_o =>ben_epo_shd.g_old_rec.program_application_id
633: ,p_program_id_o =>ben_epo_shd.g_old_rec.program_id
634: ,p_program_update_date_o =>ben_epo_shd.g_old_rec.program_update_date
635: ,p_object_version_number_o =>ben_epo_shd.g_old_rec.object_version_number
636: );
637: --
638: exception
639: --
693: -- Internal Row Handler Use Only.
694: --
695: -- {End Of Comments}
696: -- ----------------------------------------------------------------------------
697: Procedure convert_defs(p_rec in out nocopy ben_epo_shd.g_rec_type) is
698: --
699: l_proc varchar2(72) := g_package||'convert_defs';
700: --
701: Begin
708: -- is being used then we must set to the 'current' argument value.
709: --
710: If (p_rec.elig_per_id = hr_api.g_number) then
711: p_rec.elig_per_id :=
712: ben_epo_shd.g_old_rec.elig_per_id;
713: End If;
714: If (p_rec.prtn_ovridn_flag = hr_api.g_varchar2) then
715: p_rec.prtn_ovridn_flag :=
716: ben_epo_shd.g_old_rec.prtn_ovridn_flag;
712: ben_epo_shd.g_old_rec.elig_per_id;
713: End If;
714: If (p_rec.prtn_ovridn_flag = hr_api.g_varchar2) then
715: p_rec.prtn_ovridn_flag :=
716: ben_epo_shd.g_old_rec.prtn_ovridn_flag;
717: End If;
718: If (p_rec.prtn_ovridn_thru_dt = hr_api.g_date) then
719: p_rec.prtn_ovridn_thru_dt :=
720: ben_epo_shd.g_old_rec.prtn_ovridn_thru_dt;
716: ben_epo_shd.g_old_rec.prtn_ovridn_flag;
717: End If;
718: If (p_rec.prtn_ovridn_thru_dt = hr_api.g_date) then
719: p_rec.prtn_ovridn_thru_dt :=
720: ben_epo_shd.g_old_rec.prtn_ovridn_thru_dt;
721: End If;
722: If (p_rec.no_mx_prtn_ovrid_thru_flag = hr_api.g_varchar2) then
723: p_rec.no_mx_prtn_ovrid_thru_flag :=
724: ben_epo_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag;
720: ben_epo_shd.g_old_rec.prtn_ovridn_thru_dt;
721: End If;
722: If (p_rec.no_mx_prtn_ovrid_thru_flag = hr_api.g_varchar2) then
723: p_rec.no_mx_prtn_ovrid_thru_flag :=
724: ben_epo_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag;
725: End If;
726: If (p_rec.elig_flag = hr_api.g_varchar2) then
727: p_rec.elig_flag :=
728: ben_epo_shd.g_old_rec.elig_flag;
724: ben_epo_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag;
725: End If;
726: If (p_rec.elig_flag = hr_api.g_varchar2) then
727: p_rec.elig_flag :=
728: ben_epo_shd.g_old_rec.elig_flag;
729: End If;
730: If (p_rec.prtn_strt_dt = hr_api.g_date) then
731: p_rec.prtn_strt_dt :=
732: ben_epo_shd.g_old_rec.prtn_strt_dt;
728: ben_epo_shd.g_old_rec.elig_flag;
729: End If;
730: If (p_rec.prtn_strt_dt = hr_api.g_date) then
731: p_rec.prtn_strt_dt :=
732: ben_epo_shd.g_old_rec.prtn_strt_dt;
733: End If;
734: If (p_rec.prtn_end_dt = hr_api.g_date) then
735: p_rec.prtn_end_dt :=
736: ben_epo_shd.g_old_rec.prtn_end_dt;
732: ben_epo_shd.g_old_rec.prtn_strt_dt;
733: End If;
734: If (p_rec.prtn_end_dt = hr_api.g_date) then
735: p_rec.prtn_end_dt :=
736: ben_epo_shd.g_old_rec.prtn_end_dt;
737: End If;
738: If (p_rec.wait_perd_cmpltn_date = hr_api.g_date) then
739: p_rec.wait_perd_cmpltn_date :=
740: ben_epo_shd.g_old_rec.wait_perd_cmpltn_date;
736: ben_epo_shd.g_old_rec.prtn_end_dt;
737: End If;
738: If (p_rec.wait_perd_cmpltn_date = hr_api.g_date) then
739: p_rec.wait_perd_cmpltn_date :=
740: ben_epo_shd.g_old_rec.wait_perd_cmpltn_date;
741: End If;
742: If (p_rec.wait_perd_strt_dt = hr_api.g_date) then
743: p_rec.wait_perd_strt_dt :=
744: ben_epo_shd.g_old_rec.wait_perd_strt_dt;
740: ben_epo_shd.g_old_rec.wait_perd_cmpltn_date;
741: End If;
742: If (p_rec.wait_perd_strt_dt = hr_api.g_date) then
743: p_rec.wait_perd_strt_dt :=
744: ben_epo_shd.g_old_rec.wait_perd_strt_dt;
745: End If;
746: If (p_rec.prtn_ovridn_rsn_cd = hr_api.g_varchar2) then
747: p_rec.prtn_ovridn_rsn_cd :=
748: ben_epo_shd.g_old_rec.prtn_ovridn_rsn_cd;
744: ben_epo_shd.g_old_rec.wait_perd_strt_dt;
745: End If;
746: If (p_rec.prtn_ovridn_rsn_cd = hr_api.g_varchar2) then
747: p_rec.prtn_ovridn_rsn_cd :=
748: ben_epo_shd.g_old_rec.prtn_ovridn_rsn_cd;
749: End If;
750: If (p_rec.pct_fl_tm_val = hr_api.g_number) then
751: p_rec.pct_fl_tm_val :=
752: ben_epo_shd.g_old_rec.pct_fl_tm_val;
748: ben_epo_shd.g_old_rec.prtn_ovridn_rsn_cd;
749: End If;
750: If (p_rec.pct_fl_tm_val = hr_api.g_number) then
751: p_rec.pct_fl_tm_val :=
752: ben_epo_shd.g_old_rec.pct_fl_tm_val;
753: End If;
754: If (p_rec.opt_id = hr_api.g_number) then
755: p_rec.opt_id :=
756: ben_epo_shd.g_old_rec.opt_id;
752: ben_epo_shd.g_old_rec.pct_fl_tm_val;
753: End If;
754: If (p_rec.opt_id = hr_api.g_number) then
755: p_rec.opt_id :=
756: ben_epo_shd.g_old_rec.opt_id;
757: End If;
758: If (p_rec.per_in_ler_id = hr_api.g_number) then
759: p_rec.per_in_ler_id :=
760: ben_epo_shd.g_old_rec.per_in_ler_id;
756: ben_epo_shd.g_old_rec.opt_id;
757: End If;
758: If (p_rec.per_in_ler_id = hr_api.g_number) then
759: p_rec.per_in_ler_id :=
760: ben_epo_shd.g_old_rec.per_in_ler_id;
761: End If;
762: If (p_rec.rt_comp_ref_amt = hr_api.g_number) then
763: p_rec.rt_comp_ref_amt :=
764: ben_epo_shd.g_old_rec.rt_comp_ref_amt;
760: ben_epo_shd.g_old_rec.per_in_ler_id;
761: End If;
762: If (p_rec.rt_comp_ref_amt = hr_api.g_number) then
763: p_rec.rt_comp_ref_amt :=
764: ben_epo_shd.g_old_rec.rt_comp_ref_amt;
765: End If;
766: If (p_rec.rt_cmbn_age_n_los_val = hr_api.g_number) then
767: p_rec.rt_cmbn_age_n_los_val :=
768: ben_epo_shd.g_old_rec.rt_cmbn_age_n_los_val;
764: ben_epo_shd.g_old_rec.rt_comp_ref_amt;
765: End If;
766: If (p_rec.rt_cmbn_age_n_los_val = hr_api.g_number) then
767: p_rec.rt_cmbn_age_n_los_val :=
768: ben_epo_shd.g_old_rec.rt_cmbn_age_n_los_val;
769: End If;
770: If (p_rec.rt_comp_ref_uom = hr_api.g_varchar2) then
771: p_rec.rt_comp_ref_uom :=
772: ben_epo_shd.g_old_rec.rt_comp_ref_uom;
768: ben_epo_shd.g_old_rec.rt_cmbn_age_n_los_val;
769: End If;
770: If (p_rec.rt_comp_ref_uom = hr_api.g_varchar2) then
771: p_rec.rt_comp_ref_uom :=
772: ben_epo_shd.g_old_rec.rt_comp_ref_uom;
773: End If;
774: If (p_rec.rt_age_val = hr_api.g_number) then
775: p_rec.rt_age_val :=
776: ben_epo_shd.g_old_rec.rt_age_val;
772: ben_epo_shd.g_old_rec.rt_comp_ref_uom;
773: End If;
774: If (p_rec.rt_age_val = hr_api.g_number) then
775: p_rec.rt_age_val :=
776: ben_epo_shd.g_old_rec.rt_age_val;
777: End If;
778: If (p_rec.rt_los_val = hr_api.g_number) then
779: p_rec.rt_los_val :=
780: ben_epo_shd.g_old_rec.rt_los_val;
776: ben_epo_shd.g_old_rec.rt_age_val;
777: End If;
778: If (p_rec.rt_los_val = hr_api.g_number) then
779: p_rec.rt_los_val :=
780: ben_epo_shd.g_old_rec.rt_los_val;
781: End If;
782: If (p_rec.rt_hrs_wkd_val = hr_api.g_number) then
783: p_rec.rt_hrs_wkd_val :=
784: ben_epo_shd.g_old_rec.rt_hrs_wkd_val;
780: ben_epo_shd.g_old_rec.rt_los_val;
781: End If;
782: If (p_rec.rt_hrs_wkd_val = hr_api.g_number) then
783: p_rec.rt_hrs_wkd_val :=
784: ben_epo_shd.g_old_rec.rt_hrs_wkd_val;
785: End If;
786: If (p_rec.rt_hrs_wkd_bndry_perd_cd = hr_api.g_varchar2) then
787: p_rec.rt_hrs_wkd_bndry_perd_cd :=
788: ben_epo_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd;
784: ben_epo_shd.g_old_rec.rt_hrs_wkd_val;
785: End If;
786: If (p_rec.rt_hrs_wkd_bndry_perd_cd = hr_api.g_varchar2) then
787: p_rec.rt_hrs_wkd_bndry_perd_cd :=
788: ben_epo_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd;
789: End If;
790: If (p_rec.rt_age_uom = hr_api.g_varchar2) then
791: p_rec.rt_age_uom :=
792: ben_epo_shd.g_old_rec.rt_age_uom;
788: ben_epo_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd;
789: End If;
790: If (p_rec.rt_age_uom = hr_api.g_varchar2) then
791: p_rec.rt_age_uom :=
792: ben_epo_shd.g_old_rec.rt_age_uom;
793: End If;
794: If (p_rec.rt_los_uom = hr_api.g_varchar2) then
795: p_rec.rt_los_uom :=
796: ben_epo_shd.g_old_rec.rt_los_uom;
792: ben_epo_shd.g_old_rec.rt_age_uom;
793: End If;
794: If (p_rec.rt_los_uom = hr_api.g_varchar2) then
795: p_rec.rt_los_uom :=
796: ben_epo_shd.g_old_rec.rt_los_uom;
797: End If;
798: If (p_rec.rt_pct_fl_tm_val = hr_api.g_number) then
799: p_rec.rt_pct_fl_tm_val :=
800: ben_epo_shd.g_old_rec.rt_pct_fl_tm_val;
796: ben_epo_shd.g_old_rec.rt_los_uom;
797: End If;
798: If (p_rec.rt_pct_fl_tm_val = hr_api.g_number) then
799: p_rec.rt_pct_fl_tm_val :=
800: ben_epo_shd.g_old_rec.rt_pct_fl_tm_val;
801: End If;
802: If (p_rec.rt_frz_los_flag = hr_api.g_varchar2) then
803: p_rec.rt_frz_los_flag :=
804: ben_epo_shd.g_old_rec.rt_frz_los_flag;
800: ben_epo_shd.g_old_rec.rt_pct_fl_tm_val;
801: End If;
802: If (p_rec.rt_frz_los_flag = hr_api.g_varchar2) then
803: p_rec.rt_frz_los_flag :=
804: ben_epo_shd.g_old_rec.rt_frz_los_flag;
805: End If;
806: If (p_rec.rt_frz_age_flag = hr_api.g_varchar2) then
807: p_rec.rt_frz_age_flag :=
808: ben_epo_shd.g_old_rec.rt_frz_age_flag;
804: ben_epo_shd.g_old_rec.rt_frz_los_flag;
805: End If;
806: If (p_rec.rt_frz_age_flag = hr_api.g_varchar2) then
807: p_rec.rt_frz_age_flag :=
808: ben_epo_shd.g_old_rec.rt_frz_age_flag;
809: End If;
810: If (p_rec.rt_frz_cmp_lvl_flag = hr_api.g_varchar2) then
811: p_rec.rt_frz_cmp_lvl_flag :=
812: ben_epo_shd.g_old_rec.rt_frz_cmp_lvl_flag;
808: ben_epo_shd.g_old_rec.rt_frz_age_flag;
809: End If;
810: If (p_rec.rt_frz_cmp_lvl_flag = hr_api.g_varchar2) then
811: p_rec.rt_frz_cmp_lvl_flag :=
812: ben_epo_shd.g_old_rec.rt_frz_cmp_lvl_flag;
813: End If;
814: If (p_rec.rt_frz_pct_fl_tm_flag = hr_api.g_varchar2) then
815: p_rec.rt_frz_pct_fl_tm_flag :=
816: ben_epo_shd.g_old_rec.rt_frz_pct_fl_tm_flag;
812: ben_epo_shd.g_old_rec.rt_frz_cmp_lvl_flag;
813: End If;
814: If (p_rec.rt_frz_pct_fl_tm_flag = hr_api.g_varchar2) then
815: p_rec.rt_frz_pct_fl_tm_flag :=
816: ben_epo_shd.g_old_rec.rt_frz_pct_fl_tm_flag;
817: End If;
818: If (p_rec.rt_frz_hrs_wkd_flag = hr_api.g_varchar2) then
819: p_rec.rt_frz_hrs_wkd_flag :=
820: ben_epo_shd.g_old_rec.rt_frz_hrs_wkd_flag;
816: ben_epo_shd.g_old_rec.rt_frz_pct_fl_tm_flag;
817: End If;
818: If (p_rec.rt_frz_hrs_wkd_flag = hr_api.g_varchar2) then
819: p_rec.rt_frz_hrs_wkd_flag :=
820: ben_epo_shd.g_old_rec.rt_frz_hrs_wkd_flag;
821: End If;
822: If (p_rec.rt_frz_comb_age_and_los_flag = hr_api.g_varchar2) then
823: p_rec.rt_frz_comb_age_and_los_flag :=
824: ben_epo_shd.g_old_rec.rt_frz_comb_age_and_los_flag;
820: ben_epo_shd.g_old_rec.rt_frz_hrs_wkd_flag;
821: End If;
822: If (p_rec.rt_frz_comb_age_and_los_flag = hr_api.g_varchar2) then
823: p_rec.rt_frz_comb_age_and_los_flag :=
824: ben_epo_shd.g_old_rec.rt_frz_comb_age_and_los_flag;
825: End If;
826: If (p_rec.comp_ref_amt = hr_api.g_number) then
827: p_rec.comp_ref_amt :=
828: ben_epo_shd.g_old_rec.comp_ref_amt;
824: ben_epo_shd.g_old_rec.rt_frz_comb_age_and_los_flag;
825: End If;
826: If (p_rec.comp_ref_amt = hr_api.g_number) then
827: p_rec.comp_ref_amt :=
828: ben_epo_shd.g_old_rec.comp_ref_amt;
829: End If;
830: If (p_rec.cmbn_age_n_los_val = hr_api.g_number) then
831: p_rec.cmbn_age_n_los_val :=
832: ben_epo_shd.g_old_rec.cmbn_age_n_los_val;
828: ben_epo_shd.g_old_rec.comp_ref_amt;
829: End If;
830: If (p_rec.cmbn_age_n_los_val = hr_api.g_number) then
831: p_rec.cmbn_age_n_los_val :=
832: ben_epo_shd.g_old_rec.cmbn_age_n_los_val;
833: End If;
834: If (p_rec.comp_ref_uom = hr_api.g_varchar2) then
835: p_rec.comp_ref_uom :=
836: ben_epo_shd.g_old_rec.comp_ref_uom;
832: ben_epo_shd.g_old_rec.cmbn_age_n_los_val;
833: End If;
834: If (p_rec.comp_ref_uom = hr_api.g_varchar2) then
835: p_rec.comp_ref_uom :=
836: ben_epo_shd.g_old_rec.comp_ref_uom;
837: End If;
838: If (p_rec.age_val = hr_api.g_number) then
839: p_rec.age_val :=
840: ben_epo_shd.g_old_rec.age_val;
836: ben_epo_shd.g_old_rec.comp_ref_uom;
837: End If;
838: If (p_rec.age_val = hr_api.g_number) then
839: p_rec.age_val :=
840: ben_epo_shd.g_old_rec.age_val;
841: End If;
842: If (p_rec.los_val = hr_api.g_number) then
843: p_rec.los_val :=
844: ben_epo_shd.g_old_rec.los_val;
840: ben_epo_shd.g_old_rec.age_val;
841: End If;
842: If (p_rec.los_val = hr_api.g_number) then
843: p_rec.los_val :=
844: ben_epo_shd.g_old_rec.los_val;
845: End If;
846: If (p_rec.hrs_wkd_val = hr_api.g_number) then
847: p_rec.hrs_wkd_val :=
848: ben_epo_shd.g_old_rec.hrs_wkd_val;
844: ben_epo_shd.g_old_rec.los_val;
845: End If;
846: If (p_rec.hrs_wkd_val = hr_api.g_number) then
847: p_rec.hrs_wkd_val :=
848: ben_epo_shd.g_old_rec.hrs_wkd_val;
849: End If;
850: If (p_rec.hrs_wkd_bndry_perd_cd = hr_api.g_varchar2) then
851: p_rec.hrs_wkd_bndry_perd_cd :=
852: ben_epo_shd.g_old_rec.hrs_wkd_bndry_perd_cd;
848: ben_epo_shd.g_old_rec.hrs_wkd_val;
849: End If;
850: If (p_rec.hrs_wkd_bndry_perd_cd = hr_api.g_varchar2) then
851: p_rec.hrs_wkd_bndry_perd_cd :=
852: ben_epo_shd.g_old_rec.hrs_wkd_bndry_perd_cd;
853: End If;
854: If (p_rec.age_uom = hr_api.g_varchar2) then
855: p_rec.age_uom :=
856: ben_epo_shd.g_old_rec.age_uom;
852: ben_epo_shd.g_old_rec.hrs_wkd_bndry_perd_cd;
853: End If;
854: If (p_rec.age_uom = hr_api.g_varchar2) then
855: p_rec.age_uom :=
856: ben_epo_shd.g_old_rec.age_uom;
857: End If;
858: If (p_rec.los_uom = hr_api.g_varchar2) then
859: p_rec.los_uom :=
860: ben_epo_shd.g_old_rec.los_uom;
856: ben_epo_shd.g_old_rec.age_uom;
857: End If;
858: If (p_rec.los_uom = hr_api.g_varchar2) then
859: p_rec.los_uom :=
860: ben_epo_shd.g_old_rec.los_uom;
861: End If;
862: If (p_rec.frz_los_flag = hr_api.g_varchar2) then
863: p_rec.frz_los_flag :=
864: ben_epo_shd.g_old_rec.frz_los_flag;
860: ben_epo_shd.g_old_rec.los_uom;
861: End If;
862: If (p_rec.frz_los_flag = hr_api.g_varchar2) then
863: p_rec.frz_los_flag :=
864: ben_epo_shd.g_old_rec.frz_los_flag;
865: End If;
866: If (p_rec.frz_age_flag = hr_api.g_varchar2) then
867: p_rec.frz_age_flag :=
868: ben_epo_shd.g_old_rec.frz_age_flag;
864: ben_epo_shd.g_old_rec.frz_los_flag;
865: End If;
866: If (p_rec.frz_age_flag = hr_api.g_varchar2) then
867: p_rec.frz_age_flag :=
868: ben_epo_shd.g_old_rec.frz_age_flag;
869: End If;
870: If (p_rec.frz_cmp_lvl_flag = hr_api.g_varchar2) then
871: p_rec.frz_cmp_lvl_flag :=
872: ben_epo_shd.g_old_rec.frz_cmp_lvl_flag;
868: ben_epo_shd.g_old_rec.frz_age_flag;
869: End If;
870: If (p_rec.frz_cmp_lvl_flag = hr_api.g_varchar2) then
871: p_rec.frz_cmp_lvl_flag :=
872: ben_epo_shd.g_old_rec.frz_cmp_lvl_flag;
873: End If;
874: If (p_rec.frz_pct_fl_tm_flag = hr_api.g_varchar2) then
875: p_rec.frz_pct_fl_tm_flag :=
876: ben_epo_shd.g_old_rec.frz_pct_fl_tm_flag;
872: ben_epo_shd.g_old_rec.frz_cmp_lvl_flag;
873: End If;
874: If (p_rec.frz_pct_fl_tm_flag = hr_api.g_varchar2) then
875: p_rec.frz_pct_fl_tm_flag :=
876: ben_epo_shd.g_old_rec.frz_pct_fl_tm_flag;
877: End If;
878: If (p_rec.frz_hrs_wkd_flag = hr_api.g_varchar2) then
879: p_rec.frz_hrs_wkd_flag :=
880: ben_epo_shd.g_old_rec.frz_hrs_wkd_flag;
876: ben_epo_shd.g_old_rec.frz_pct_fl_tm_flag;
877: End If;
878: If (p_rec.frz_hrs_wkd_flag = hr_api.g_varchar2) then
879: p_rec.frz_hrs_wkd_flag :=
880: ben_epo_shd.g_old_rec.frz_hrs_wkd_flag;
881: End If;
882: If (p_rec.frz_comb_age_and_los_flag = hr_api.g_varchar2) then
883: p_rec.frz_comb_age_and_los_flag :=
884: ben_epo_shd.g_old_rec.frz_comb_age_and_los_flag;
880: ben_epo_shd.g_old_rec.frz_hrs_wkd_flag;
881: End If;
882: If (p_rec.frz_comb_age_and_los_flag = hr_api.g_varchar2) then
883: p_rec.frz_comb_age_and_los_flag :=
884: ben_epo_shd.g_old_rec.frz_comb_age_and_los_flag;
885: End If;
886: If (p_rec.ovrid_svc_dt = hr_api.g_date) then
887: p_rec.ovrid_svc_dt :=
888: ben_epo_shd.g_old_rec.ovrid_svc_dt;
884: ben_epo_shd.g_old_rec.frz_comb_age_and_los_flag;
885: End If;
886: If (p_rec.ovrid_svc_dt = hr_api.g_date) then
887: p_rec.ovrid_svc_dt :=
888: ben_epo_shd.g_old_rec.ovrid_svc_dt;
889: End If;
890: If (p_rec.inelg_rsn_cd = hr_api.g_varchar2) then
891: p_rec.inelg_rsn_cd :=
892: ben_epo_shd.g_old_rec.inelg_rsn_cd;
888: ben_epo_shd.g_old_rec.ovrid_svc_dt;
889: End If;
890: If (p_rec.inelg_rsn_cd = hr_api.g_varchar2) then
891: p_rec.inelg_rsn_cd :=
892: ben_epo_shd.g_old_rec.inelg_rsn_cd;
893: End If;
894: If (p_rec.once_r_cntug_cd = hr_api.g_varchar2) then
895: p_rec.once_r_cntug_cd :=
896: ben_epo_shd.g_old_rec.once_r_cntug_cd;
892: ben_epo_shd.g_old_rec.inelg_rsn_cd;
893: End If;
894: If (p_rec.once_r_cntug_cd = hr_api.g_varchar2) then
895: p_rec.once_r_cntug_cd :=
896: ben_epo_shd.g_old_rec.once_r_cntug_cd;
897: End If;
898: If (p_rec.oipl_ordr_num = hr_api.g_number) then
899: p_rec.oipl_ordr_num :=
900: ben_epo_shd.g_old_rec.oipl_ordr_num;
896: ben_epo_shd.g_old_rec.once_r_cntug_cd;
897: End If;
898: If (p_rec.oipl_ordr_num = hr_api.g_number) then
899: p_rec.oipl_ordr_num :=
900: ben_epo_shd.g_old_rec.oipl_ordr_num;
901: End If;
902: If (p_rec.business_group_id = hr_api.g_number) then
903: p_rec.business_group_id :=
904: ben_epo_shd.g_old_rec.business_group_id;
900: ben_epo_shd.g_old_rec.oipl_ordr_num;
901: End If;
902: If (p_rec.business_group_id = hr_api.g_number) then
903: p_rec.business_group_id :=
904: ben_epo_shd.g_old_rec.business_group_id;
905: End If;
906: If (p_rec.epo_attribute_category = hr_api.g_varchar2) then
907: p_rec.epo_attribute_category :=
908: ben_epo_shd.g_old_rec.epo_attribute_category;
904: ben_epo_shd.g_old_rec.business_group_id;
905: End If;
906: If (p_rec.epo_attribute_category = hr_api.g_varchar2) then
907: p_rec.epo_attribute_category :=
908: ben_epo_shd.g_old_rec.epo_attribute_category;
909: End If;
910: If (p_rec.epo_attribute1 = hr_api.g_varchar2) then
911: p_rec.epo_attribute1 :=
912: ben_epo_shd.g_old_rec.epo_attribute1;
908: ben_epo_shd.g_old_rec.epo_attribute_category;
909: End If;
910: If (p_rec.epo_attribute1 = hr_api.g_varchar2) then
911: p_rec.epo_attribute1 :=
912: ben_epo_shd.g_old_rec.epo_attribute1;
913: End If;
914: If (p_rec.epo_attribute2 = hr_api.g_varchar2) then
915: p_rec.epo_attribute2 :=
916: ben_epo_shd.g_old_rec.epo_attribute2;
912: ben_epo_shd.g_old_rec.epo_attribute1;
913: End If;
914: If (p_rec.epo_attribute2 = hr_api.g_varchar2) then
915: p_rec.epo_attribute2 :=
916: ben_epo_shd.g_old_rec.epo_attribute2;
917: End If;
918: If (p_rec.epo_attribute3 = hr_api.g_varchar2) then
919: p_rec.epo_attribute3 :=
920: ben_epo_shd.g_old_rec.epo_attribute3;
916: ben_epo_shd.g_old_rec.epo_attribute2;
917: End If;
918: If (p_rec.epo_attribute3 = hr_api.g_varchar2) then
919: p_rec.epo_attribute3 :=
920: ben_epo_shd.g_old_rec.epo_attribute3;
921: End If;
922: If (p_rec.epo_attribute4 = hr_api.g_varchar2) then
923: p_rec.epo_attribute4 :=
924: ben_epo_shd.g_old_rec.epo_attribute4;
920: ben_epo_shd.g_old_rec.epo_attribute3;
921: End If;
922: If (p_rec.epo_attribute4 = hr_api.g_varchar2) then
923: p_rec.epo_attribute4 :=
924: ben_epo_shd.g_old_rec.epo_attribute4;
925: End If;
926: If (p_rec.epo_attribute5 = hr_api.g_varchar2) then
927: p_rec.epo_attribute5 :=
928: ben_epo_shd.g_old_rec.epo_attribute5;
924: ben_epo_shd.g_old_rec.epo_attribute4;
925: End If;
926: If (p_rec.epo_attribute5 = hr_api.g_varchar2) then
927: p_rec.epo_attribute5 :=
928: ben_epo_shd.g_old_rec.epo_attribute5;
929: End If;
930: If (p_rec.epo_attribute6 = hr_api.g_varchar2) then
931: p_rec.epo_attribute6 :=
932: ben_epo_shd.g_old_rec.epo_attribute6;
928: ben_epo_shd.g_old_rec.epo_attribute5;
929: End If;
930: If (p_rec.epo_attribute6 = hr_api.g_varchar2) then
931: p_rec.epo_attribute6 :=
932: ben_epo_shd.g_old_rec.epo_attribute6;
933: End If;
934: If (p_rec.epo_attribute7 = hr_api.g_varchar2) then
935: p_rec.epo_attribute7 :=
936: ben_epo_shd.g_old_rec.epo_attribute7;
932: ben_epo_shd.g_old_rec.epo_attribute6;
933: End If;
934: If (p_rec.epo_attribute7 = hr_api.g_varchar2) then
935: p_rec.epo_attribute7 :=
936: ben_epo_shd.g_old_rec.epo_attribute7;
937: End If;
938: If (p_rec.epo_attribute8 = hr_api.g_varchar2) then
939: p_rec.epo_attribute8 :=
940: ben_epo_shd.g_old_rec.epo_attribute8;
936: ben_epo_shd.g_old_rec.epo_attribute7;
937: End If;
938: If (p_rec.epo_attribute8 = hr_api.g_varchar2) then
939: p_rec.epo_attribute8 :=
940: ben_epo_shd.g_old_rec.epo_attribute8;
941: End If;
942: If (p_rec.epo_attribute9 = hr_api.g_varchar2) then
943: p_rec.epo_attribute9 :=
944: ben_epo_shd.g_old_rec.epo_attribute9;
940: ben_epo_shd.g_old_rec.epo_attribute8;
941: End If;
942: If (p_rec.epo_attribute9 = hr_api.g_varchar2) then
943: p_rec.epo_attribute9 :=
944: ben_epo_shd.g_old_rec.epo_attribute9;
945: End If;
946: If (p_rec.epo_attribute10 = hr_api.g_varchar2) then
947: p_rec.epo_attribute10 :=
948: ben_epo_shd.g_old_rec.epo_attribute10;
944: ben_epo_shd.g_old_rec.epo_attribute9;
945: End If;
946: If (p_rec.epo_attribute10 = hr_api.g_varchar2) then
947: p_rec.epo_attribute10 :=
948: ben_epo_shd.g_old_rec.epo_attribute10;
949: End If;
950: If (p_rec.epo_attribute11 = hr_api.g_varchar2) then
951: p_rec.epo_attribute11 :=
952: ben_epo_shd.g_old_rec.epo_attribute11;
948: ben_epo_shd.g_old_rec.epo_attribute10;
949: End If;
950: If (p_rec.epo_attribute11 = hr_api.g_varchar2) then
951: p_rec.epo_attribute11 :=
952: ben_epo_shd.g_old_rec.epo_attribute11;
953: End If;
954: If (p_rec.epo_attribute12 = hr_api.g_varchar2) then
955: p_rec.epo_attribute12 :=
956: ben_epo_shd.g_old_rec.epo_attribute12;
952: ben_epo_shd.g_old_rec.epo_attribute11;
953: End If;
954: If (p_rec.epo_attribute12 = hr_api.g_varchar2) then
955: p_rec.epo_attribute12 :=
956: ben_epo_shd.g_old_rec.epo_attribute12;
957: End If;
958: If (p_rec.epo_attribute13 = hr_api.g_varchar2) then
959: p_rec.epo_attribute13 :=
960: ben_epo_shd.g_old_rec.epo_attribute13;
956: ben_epo_shd.g_old_rec.epo_attribute12;
957: End If;
958: If (p_rec.epo_attribute13 = hr_api.g_varchar2) then
959: p_rec.epo_attribute13 :=
960: ben_epo_shd.g_old_rec.epo_attribute13;
961: End If;
962: If (p_rec.epo_attribute14 = hr_api.g_varchar2) then
963: p_rec.epo_attribute14 :=
964: ben_epo_shd.g_old_rec.epo_attribute14;
960: ben_epo_shd.g_old_rec.epo_attribute13;
961: End If;
962: If (p_rec.epo_attribute14 = hr_api.g_varchar2) then
963: p_rec.epo_attribute14 :=
964: ben_epo_shd.g_old_rec.epo_attribute14;
965: End If;
966: If (p_rec.epo_attribute15 = hr_api.g_varchar2) then
967: p_rec.epo_attribute15 :=
968: ben_epo_shd.g_old_rec.epo_attribute15;
964: ben_epo_shd.g_old_rec.epo_attribute14;
965: End If;
966: If (p_rec.epo_attribute15 = hr_api.g_varchar2) then
967: p_rec.epo_attribute15 :=
968: ben_epo_shd.g_old_rec.epo_attribute15;
969: End If;
970: If (p_rec.epo_attribute16 = hr_api.g_varchar2) then
971: p_rec.epo_attribute16 :=
972: ben_epo_shd.g_old_rec.epo_attribute16;
968: ben_epo_shd.g_old_rec.epo_attribute15;
969: End If;
970: If (p_rec.epo_attribute16 = hr_api.g_varchar2) then
971: p_rec.epo_attribute16 :=
972: ben_epo_shd.g_old_rec.epo_attribute16;
973: End If;
974: If (p_rec.epo_attribute17 = hr_api.g_varchar2) then
975: p_rec.epo_attribute17 :=
976: ben_epo_shd.g_old_rec.epo_attribute17;
972: ben_epo_shd.g_old_rec.epo_attribute16;
973: End If;
974: If (p_rec.epo_attribute17 = hr_api.g_varchar2) then
975: p_rec.epo_attribute17 :=
976: ben_epo_shd.g_old_rec.epo_attribute17;
977: End If;
978: If (p_rec.epo_attribute18 = hr_api.g_varchar2) then
979: p_rec.epo_attribute18 :=
980: ben_epo_shd.g_old_rec.epo_attribute18;
976: ben_epo_shd.g_old_rec.epo_attribute17;
977: End If;
978: If (p_rec.epo_attribute18 = hr_api.g_varchar2) then
979: p_rec.epo_attribute18 :=
980: ben_epo_shd.g_old_rec.epo_attribute18;
981: End If;
982: If (p_rec.epo_attribute19 = hr_api.g_varchar2) then
983: p_rec.epo_attribute19 :=
984: ben_epo_shd.g_old_rec.epo_attribute19;
980: ben_epo_shd.g_old_rec.epo_attribute18;
981: End If;
982: If (p_rec.epo_attribute19 = hr_api.g_varchar2) then
983: p_rec.epo_attribute19 :=
984: ben_epo_shd.g_old_rec.epo_attribute19;
985: End If;
986: If (p_rec.epo_attribute20 = hr_api.g_varchar2) then
987: p_rec.epo_attribute20 :=
988: ben_epo_shd.g_old_rec.epo_attribute20;
984: ben_epo_shd.g_old_rec.epo_attribute19;
985: End If;
986: If (p_rec.epo_attribute20 = hr_api.g_varchar2) then
987: p_rec.epo_attribute20 :=
988: ben_epo_shd.g_old_rec.epo_attribute20;
989: End If;
990: If (p_rec.epo_attribute21 = hr_api.g_varchar2) then
991: p_rec.epo_attribute21 :=
992: ben_epo_shd.g_old_rec.epo_attribute21;
988: ben_epo_shd.g_old_rec.epo_attribute20;
989: End If;
990: If (p_rec.epo_attribute21 = hr_api.g_varchar2) then
991: p_rec.epo_attribute21 :=
992: ben_epo_shd.g_old_rec.epo_attribute21;
993: End If;
994: If (p_rec.epo_attribute22 = hr_api.g_varchar2) then
995: p_rec.epo_attribute22 :=
996: ben_epo_shd.g_old_rec.epo_attribute22;
992: ben_epo_shd.g_old_rec.epo_attribute21;
993: End If;
994: If (p_rec.epo_attribute22 = hr_api.g_varchar2) then
995: p_rec.epo_attribute22 :=
996: ben_epo_shd.g_old_rec.epo_attribute22;
997: End If;
998: If (p_rec.epo_attribute23 = hr_api.g_varchar2) then
999: p_rec.epo_attribute23 :=
1000: ben_epo_shd.g_old_rec.epo_attribute23;
996: ben_epo_shd.g_old_rec.epo_attribute22;
997: End If;
998: If (p_rec.epo_attribute23 = hr_api.g_varchar2) then
999: p_rec.epo_attribute23 :=
1000: ben_epo_shd.g_old_rec.epo_attribute23;
1001: End If;
1002: If (p_rec.epo_attribute24 = hr_api.g_varchar2) then
1003: p_rec.epo_attribute24 :=
1004: ben_epo_shd.g_old_rec.epo_attribute24;
1000: ben_epo_shd.g_old_rec.epo_attribute23;
1001: End If;
1002: If (p_rec.epo_attribute24 = hr_api.g_varchar2) then
1003: p_rec.epo_attribute24 :=
1004: ben_epo_shd.g_old_rec.epo_attribute24;
1005: End If;
1006: If (p_rec.epo_attribute25 = hr_api.g_varchar2) then
1007: p_rec.epo_attribute25 :=
1008: ben_epo_shd.g_old_rec.epo_attribute25;
1004: ben_epo_shd.g_old_rec.epo_attribute24;
1005: End If;
1006: If (p_rec.epo_attribute25 = hr_api.g_varchar2) then
1007: p_rec.epo_attribute25 :=
1008: ben_epo_shd.g_old_rec.epo_attribute25;
1009: End If;
1010: If (p_rec.epo_attribute26 = hr_api.g_varchar2) then
1011: p_rec.epo_attribute26 :=
1012: ben_epo_shd.g_old_rec.epo_attribute26;
1008: ben_epo_shd.g_old_rec.epo_attribute25;
1009: End If;
1010: If (p_rec.epo_attribute26 = hr_api.g_varchar2) then
1011: p_rec.epo_attribute26 :=
1012: ben_epo_shd.g_old_rec.epo_attribute26;
1013: End If;
1014: If (p_rec.epo_attribute27 = hr_api.g_varchar2) then
1015: p_rec.epo_attribute27 :=
1016: ben_epo_shd.g_old_rec.epo_attribute27;
1012: ben_epo_shd.g_old_rec.epo_attribute26;
1013: End If;
1014: If (p_rec.epo_attribute27 = hr_api.g_varchar2) then
1015: p_rec.epo_attribute27 :=
1016: ben_epo_shd.g_old_rec.epo_attribute27;
1017: End If;
1018: If (p_rec.epo_attribute28 = hr_api.g_varchar2) then
1019: p_rec.epo_attribute28 :=
1020: ben_epo_shd.g_old_rec.epo_attribute28;
1016: ben_epo_shd.g_old_rec.epo_attribute27;
1017: End If;
1018: If (p_rec.epo_attribute28 = hr_api.g_varchar2) then
1019: p_rec.epo_attribute28 :=
1020: ben_epo_shd.g_old_rec.epo_attribute28;
1021: End If;
1022: If (p_rec.epo_attribute29 = hr_api.g_varchar2) then
1023: p_rec.epo_attribute29 :=
1024: ben_epo_shd.g_old_rec.epo_attribute29;
1020: ben_epo_shd.g_old_rec.epo_attribute28;
1021: End If;
1022: If (p_rec.epo_attribute29 = hr_api.g_varchar2) then
1023: p_rec.epo_attribute29 :=
1024: ben_epo_shd.g_old_rec.epo_attribute29;
1025: End If;
1026: If (p_rec.epo_attribute30 = hr_api.g_varchar2) then
1027: p_rec.epo_attribute30 :=
1028: ben_epo_shd.g_old_rec.epo_attribute30;
1024: ben_epo_shd.g_old_rec.epo_attribute29;
1025: End If;
1026: If (p_rec.epo_attribute30 = hr_api.g_varchar2) then
1027: p_rec.epo_attribute30 :=
1028: ben_epo_shd.g_old_rec.epo_attribute30;
1029: End If;
1030: If (p_rec.request_id= hr_api.g_number) then
1031: p_rec.request_id :=
1032: ben_epo_shd.g_old_rec.request_id;
1028: ben_epo_shd.g_old_rec.epo_attribute30;
1029: End If;
1030: If (p_rec.request_id= hr_api.g_number) then
1031: p_rec.request_id :=
1032: ben_epo_shd.g_old_rec.request_id;
1033: End If;
1034: If (p_rec.program_application_id = hr_api.g_number) then
1035: p_rec.program_application_id :=
1036: ben_epo_shd.g_old_rec.program_application_id;
1032: ben_epo_shd.g_old_rec.request_id;
1033: End If;
1034: If (p_rec.program_application_id = hr_api.g_number) then
1035: p_rec.program_application_id :=
1036: ben_epo_shd.g_old_rec.program_application_id;
1037: End If;
1038: If (p_rec.program_id = hr_api.g_number) then
1039: p_rec.program_id :=
1040: ben_epo_shd.g_old_rec.program_id;
1036: ben_epo_shd.g_old_rec.program_application_id;
1037: End If;
1038: If (p_rec.program_id = hr_api.g_number) then
1039: p_rec.program_id :=
1040: ben_epo_shd.g_old_rec.program_id;
1041: End If;
1042: If (p_rec.program_update_date = hr_api.g_date) then
1043: p_rec.program_update_date :=
1044: ben_epo_shd.g_old_rec.program_update_date;
1040: ben_epo_shd.g_old_rec.program_id;
1041: End If;
1042: If (p_rec.program_update_date = hr_api.g_date) then
1043: p_rec.program_update_date :=
1044: ben_epo_shd.g_old_rec.program_update_date;
1045: End If;
1046:
1047: --
1048: hr_utility.set_location(' Leaving:'||l_proc, 10);
1053: -- |---------------------------------< upd >----------------------------------|
1054: -- ----------------------------------------------------------------------------
1055: Procedure upd
1056: (
1057: p_rec in out nocopy ben_epo_shd.g_rec_type,
1058: p_effective_date in date,
1059: p_datetrack_mode in varchar2
1060: ) is
1061: --
1071: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
1072: --
1073: -- We must lock the row which we need to update.
1074: --
1075: ben_epo_shd.lck
1076: (p_effective_date => p_effective_date,
1077: p_datetrack_mode => p_datetrack_mode,
1078: p_elig_per_opt_id => p_rec.elig_per_opt_id,
1079: p_object_version_number => p_rec.object_version_number,
1218: p_effective_date in date,
1219: p_datetrack_mode in varchar2
1220: ) is
1221: --
1222: l_rec ben_epo_shd.g_rec_type;
1223: l_proc varchar2(72) := g_package||'upd';
1224: --
1225: Begin
1226: hr_utility.set_location('Entering:'||l_proc, 5);
1228: -- Call conversion function to turn arguments into the
1229: -- l_rec structure.
1230: --
1231: l_rec :=
1232: ben_epo_shd.convert_args
1233: (
1234: p_elig_per_opt_id,
1235: p_elig_per_id,
1236: null,