DBA Data[Home] [Help]

APPS.BEN_EPA_UPD dependencies on BEN_EPA_SHD

Line 58: (p_rec in out nocopy ben_epa_shd.g_rec_type,

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy ben_epa_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

Line 81: ben_epa_shd.g_api_dml := true; -- Set the api dml status

77: (p_base_table_name => 'ben_prtn_elig_f',
78: p_base_key_column => 'prtn_elig_id',
79: p_base_key_value => p_rec.prtn_elig_id);
80: --
81: ben_epa_shd.g_api_dml := true; -- Set the api dml status
82: --
83: -- Update the ben_prtn_elig_f Row
84: --
85: update ben_prtn_elig_f

Line 146: ben_epa_shd.g_api_dml := false; -- Unset the api dml status

142: where prtn_elig_id = p_rec.prtn_elig_id
143: and effective_start_date = p_validation_start_date
144: and effective_end_date = p_validation_end_date;
145: --
146: ben_epa_shd.g_api_dml := false; -- Unset the api dml status
147: --
148: -- Set the effective start and end dates
149: --
150: p_rec.effective_start_date := p_validation_start_date;

Line 158: ben_epa_shd.g_api_dml := false; -- Unset the api dml status

154: hr_utility.set_location(' Leaving:'||l_proc, 15);
155: Exception
156: When hr_api.check_integrity_violated Then
157: -- A check constraint has been violated
158: ben_epa_shd.g_api_dml := false; -- Unset the api dml status
159: ben_epa_shd.constraint_error
160: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
161: When hr_api.unique_integrity_violated Then
162: -- Unique integrity has been violated

Line 159: ben_epa_shd.constraint_error

155: Exception
156: When hr_api.check_integrity_violated Then
157: -- A check constraint has been violated
158: ben_epa_shd.g_api_dml := false; -- Unset the api dml status
159: ben_epa_shd.constraint_error
160: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
161: When hr_api.unique_integrity_violated Then
162: -- Unique integrity has been violated
163: ben_epa_shd.g_api_dml := false; -- Unset the api dml status

Line 163: ben_epa_shd.g_api_dml := false; -- Unset the api dml status

159: ben_epa_shd.constraint_error
160: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
161: When hr_api.unique_integrity_violated Then
162: -- Unique integrity has been violated
163: ben_epa_shd.g_api_dml := false; -- Unset the api dml status
164: ben_epa_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When Others Then
167: ben_epa_shd.g_api_dml := false; -- Unset the api dml status

Line 164: ben_epa_shd.constraint_error

160: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
161: When hr_api.unique_integrity_violated Then
162: -- Unique integrity has been violated
163: ben_epa_shd.g_api_dml := false; -- Unset the api dml status
164: ben_epa_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When Others Then
167: ben_epa_shd.g_api_dml := false; -- Unset the api dml status
168: Raise;

Line 167: ben_epa_shd.g_api_dml := false; -- Unset the api dml status

163: ben_epa_shd.g_api_dml := false; -- Unset the api dml status
164: ben_epa_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When Others Then
167: ben_epa_shd.g_api_dml := false; -- Unset the api dml status
168: Raise;
169: End dt_update_dml;
170: --
171: -- ----------------------------------------------------------------------------

Line 203: (p_rec in out nocopy ben_epa_shd.g_rec_type,

199: --
200: -- {End Of Comments}
201: -- ----------------------------------------------------------------------------
202: Procedure update_dml
203: (p_rec in out nocopy ben_epa_shd.g_rec_type,
204: p_effective_date in date,
205: p_datetrack_mode in varchar2,
206: p_validation_start_date in date,
207: p_validation_end_date in date) is

Line 267: (p_rec in out nocopy ben_epa_shd.g_rec_type,

263: --
264: -- {End Of Comments}
265: -- ----------------------------------------------------------------------------
266: Procedure dt_pre_update
267: (p_rec in out nocopy ben_epa_shd.g_rec_type,
268: p_effective_date in date,
269: p_datetrack_mode in varchar2,
270: p_validation_start_date in date,
271: p_validation_end_date in date) is

Line 283: ben_epa_shd.upd_effective_end_date

279: hr_utility.set_location(l_proc, 10);
280: --
281: -- Update the current effective end date
282: --
283: ben_epa_shd.upd_effective_end_date
284: (p_effective_date => p_effective_date,
285: p_base_key_value => p_rec.prtn_elig_id,
286: p_new_effective_end_date => (p_validation_start_date - 1),
287: p_validation_start_date => p_validation_start_date,

Line 352: (p_rec in out nocopy ben_epa_shd.g_rec_type,

348: --
349: -- {End Of Comments}
350: -- ----------------------------------------------------------------------------
351: Procedure pre_update
352: (p_rec in out nocopy ben_epa_shd.g_rec_type,
353: p_effective_date in date,
354: p_datetrack_mode in varchar2,
355: p_validation_start_date in date,
356: p_validation_end_date in date) is

Line 408: (p_rec in ben_epa_shd.g_rec_type,

404: --
405: -- {End Of Comments}
406: -- ----------------------------------------------------------------------------
407: Procedure post_update
408: (p_rec in ben_epa_shd.g_rec_type,
409: p_effective_date in date,
410: p_datetrack_mode in varchar2,
411: p_validation_start_date in date,
412: p_validation_end_date in date) is

Line 487: ,p_effective_start_date_o =>ben_epa_shd.g_old_rec.effective_start_date

483: ,p_effective_date =>p_effective_date
484: ,p_datetrack_mode =>p_datetrack_mode
485: ,p_validation_start_date =>p_validation_start_date
486: ,p_validation_end_date =>p_validation_end_date
487: ,p_effective_start_date_o =>ben_epa_shd.g_old_rec.effective_start_date
488: ,p_effective_end_date_o =>ben_epa_shd.g_old_rec.effective_end_date
489: ,p_business_group_id_o =>ben_epa_shd.g_old_rec.business_group_id
490: ,p_pgm_id_o =>ben_epa_shd.g_old_rec.pgm_id
491: ,p_pl_id_o =>ben_epa_shd.g_old_rec.pl_id

Line 488: ,p_effective_end_date_o =>ben_epa_shd.g_old_rec.effective_end_date

484: ,p_datetrack_mode =>p_datetrack_mode
485: ,p_validation_start_date =>p_validation_start_date
486: ,p_validation_end_date =>p_validation_end_date
487: ,p_effective_start_date_o =>ben_epa_shd.g_old_rec.effective_start_date
488: ,p_effective_end_date_o =>ben_epa_shd.g_old_rec.effective_end_date
489: ,p_business_group_id_o =>ben_epa_shd.g_old_rec.business_group_id
490: ,p_pgm_id_o =>ben_epa_shd.g_old_rec.pgm_id
491: ,p_pl_id_o =>ben_epa_shd.g_old_rec.pl_id
492: ,p_oipl_id_o =>ben_epa_shd.g_old_rec.oipl_id

Line 489: ,p_business_group_id_o =>ben_epa_shd.g_old_rec.business_group_id

485: ,p_validation_start_date =>p_validation_start_date
486: ,p_validation_end_date =>p_validation_end_date
487: ,p_effective_start_date_o =>ben_epa_shd.g_old_rec.effective_start_date
488: ,p_effective_end_date_o =>ben_epa_shd.g_old_rec.effective_end_date
489: ,p_business_group_id_o =>ben_epa_shd.g_old_rec.business_group_id
490: ,p_pgm_id_o =>ben_epa_shd.g_old_rec.pgm_id
491: ,p_pl_id_o =>ben_epa_shd.g_old_rec.pl_id
492: ,p_oipl_id_o =>ben_epa_shd.g_old_rec.oipl_id
493: ,p_ptip_id_o =>ben_epa_shd.g_old_rec.ptip_id

Line 490: ,p_pgm_id_o =>ben_epa_shd.g_old_rec.pgm_id

486: ,p_validation_end_date =>p_validation_end_date
487: ,p_effective_start_date_o =>ben_epa_shd.g_old_rec.effective_start_date
488: ,p_effective_end_date_o =>ben_epa_shd.g_old_rec.effective_end_date
489: ,p_business_group_id_o =>ben_epa_shd.g_old_rec.business_group_id
490: ,p_pgm_id_o =>ben_epa_shd.g_old_rec.pgm_id
491: ,p_pl_id_o =>ben_epa_shd.g_old_rec.pl_id
492: ,p_oipl_id_o =>ben_epa_shd.g_old_rec.oipl_id
493: ,p_ptip_id_o =>ben_epa_shd.g_old_rec.ptip_id
494: ,p_plip_id_o =>ben_epa_shd.g_old_rec.plip_id

Line 491: ,p_pl_id_o =>ben_epa_shd.g_old_rec.pl_id

487: ,p_effective_start_date_o =>ben_epa_shd.g_old_rec.effective_start_date
488: ,p_effective_end_date_o =>ben_epa_shd.g_old_rec.effective_end_date
489: ,p_business_group_id_o =>ben_epa_shd.g_old_rec.business_group_id
490: ,p_pgm_id_o =>ben_epa_shd.g_old_rec.pgm_id
491: ,p_pl_id_o =>ben_epa_shd.g_old_rec.pl_id
492: ,p_oipl_id_o =>ben_epa_shd.g_old_rec.oipl_id
493: ,p_ptip_id_o =>ben_epa_shd.g_old_rec.ptip_id
494: ,p_plip_id_o =>ben_epa_shd.g_old_rec.plip_id
495: ,p_trk_scr_for_inelg_flag_o =>ben_epa_shd.g_old_rec.trk_scr_for_inelg_flag

Line 492: ,p_oipl_id_o =>ben_epa_shd.g_old_rec.oipl_id

488: ,p_effective_end_date_o =>ben_epa_shd.g_old_rec.effective_end_date
489: ,p_business_group_id_o =>ben_epa_shd.g_old_rec.business_group_id
490: ,p_pgm_id_o =>ben_epa_shd.g_old_rec.pgm_id
491: ,p_pl_id_o =>ben_epa_shd.g_old_rec.pl_id
492: ,p_oipl_id_o =>ben_epa_shd.g_old_rec.oipl_id
493: ,p_ptip_id_o =>ben_epa_shd.g_old_rec.ptip_id
494: ,p_plip_id_o =>ben_epa_shd.g_old_rec.plip_id
495: ,p_trk_scr_for_inelg_flag_o =>ben_epa_shd.g_old_rec.trk_scr_for_inelg_flag
496: ,p_prtn_eff_strt_dt_cd_o =>ben_epa_shd.g_old_rec.prtn_eff_strt_dt_cd

Line 493: ,p_ptip_id_o =>ben_epa_shd.g_old_rec.ptip_id

489: ,p_business_group_id_o =>ben_epa_shd.g_old_rec.business_group_id
490: ,p_pgm_id_o =>ben_epa_shd.g_old_rec.pgm_id
491: ,p_pl_id_o =>ben_epa_shd.g_old_rec.pl_id
492: ,p_oipl_id_o =>ben_epa_shd.g_old_rec.oipl_id
493: ,p_ptip_id_o =>ben_epa_shd.g_old_rec.ptip_id
494: ,p_plip_id_o =>ben_epa_shd.g_old_rec.plip_id
495: ,p_trk_scr_for_inelg_flag_o =>ben_epa_shd.g_old_rec.trk_scr_for_inelg_flag
496: ,p_prtn_eff_strt_dt_cd_o =>ben_epa_shd.g_old_rec.prtn_eff_strt_dt_cd
497: ,p_prtn_eff_end_dt_cd_o =>ben_epa_shd.g_old_rec.prtn_eff_end_dt_cd

Line 494: ,p_plip_id_o =>ben_epa_shd.g_old_rec.plip_id

490: ,p_pgm_id_o =>ben_epa_shd.g_old_rec.pgm_id
491: ,p_pl_id_o =>ben_epa_shd.g_old_rec.pl_id
492: ,p_oipl_id_o =>ben_epa_shd.g_old_rec.oipl_id
493: ,p_ptip_id_o =>ben_epa_shd.g_old_rec.ptip_id
494: ,p_plip_id_o =>ben_epa_shd.g_old_rec.plip_id
495: ,p_trk_scr_for_inelg_flag_o =>ben_epa_shd.g_old_rec.trk_scr_for_inelg_flag
496: ,p_prtn_eff_strt_dt_cd_o =>ben_epa_shd.g_old_rec.prtn_eff_strt_dt_cd
497: ,p_prtn_eff_end_dt_cd_o =>ben_epa_shd.g_old_rec.prtn_eff_end_dt_cd
498: ,p_prtn_eff_strt_dt_rl_o =>ben_epa_shd.g_old_rec.prtn_eff_strt_dt_rl

Line 495: ,p_trk_scr_for_inelg_flag_o =>ben_epa_shd.g_old_rec.trk_scr_for_inelg_flag

491: ,p_pl_id_o =>ben_epa_shd.g_old_rec.pl_id
492: ,p_oipl_id_o =>ben_epa_shd.g_old_rec.oipl_id
493: ,p_ptip_id_o =>ben_epa_shd.g_old_rec.ptip_id
494: ,p_plip_id_o =>ben_epa_shd.g_old_rec.plip_id
495: ,p_trk_scr_for_inelg_flag_o =>ben_epa_shd.g_old_rec.trk_scr_for_inelg_flag
496: ,p_prtn_eff_strt_dt_cd_o =>ben_epa_shd.g_old_rec.prtn_eff_strt_dt_cd
497: ,p_prtn_eff_end_dt_cd_o =>ben_epa_shd.g_old_rec.prtn_eff_end_dt_cd
498: ,p_prtn_eff_strt_dt_rl_o =>ben_epa_shd.g_old_rec.prtn_eff_strt_dt_rl
499: ,p_prtn_eff_end_dt_rl_o =>ben_epa_shd.g_old_rec.prtn_eff_end_dt_rl

Line 496: ,p_prtn_eff_strt_dt_cd_o =>ben_epa_shd.g_old_rec.prtn_eff_strt_dt_cd

492: ,p_oipl_id_o =>ben_epa_shd.g_old_rec.oipl_id
493: ,p_ptip_id_o =>ben_epa_shd.g_old_rec.ptip_id
494: ,p_plip_id_o =>ben_epa_shd.g_old_rec.plip_id
495: ,p_trk_scr_for_inelg_flag_o =>ben_epa_shd.g_old_rec.trk_scr_for_inelg_flag
496: ,p_prtn_eff_strt_dt_cd_o =>ben_epa_shd.g_old_rec.prtn_eff_strt_dt_cd
497: ,p_prtn_eff_end_dt_cd_o =>ben_epa_shd.g_old_rec.prtn_eff_end_dt_cd
498: ,p_prtn_eff_strt_dt_rl_o =>ben_epa_shd.g_old_rec.prtn_eff_strt_dt_rl
499: ,p_prtn_eff_end_dt_rl_o =>ben_epa_shd.g_old_rec.prtn_eff_end_dt_rl
500: ,p_wait_perd_dt_to_use_cd_o =>ben_epa_shd.g_old_rec.wait_perd_dt_to_use_cd

Line 497: ,p_prtn_eff_end_dt_cd_o =>ben_epa_shd.g_old_rec.prtn_eff_end_dt_cd

493: ,p_ptip_id_o =>ben_epa_shd.g_old_rec.ptip_id
494: ,p_plip_id_o =>ben_epa_shd.g_old_rec.plip_id
495: ,p_trk_scr_for_inelg_flag_o =>ben_epa_shd.g_old_rec.trk_scr_for_inelg_flag
496: ,p_prtn_eff_strt_dt_cd_o =>ben_epa_shd.g_old_rec.prtn_eff_strt_dt_cd
497: ,p_prtn_eff_end_dt_cd_o =>ben_epa_shd.g_old_rec.prtn_eff_end_dt_cd
498: ,p_prtn_eff_strt_dt_rl_o =>ben_epa_shd.g_old_rec.prtn_eff_strt_dt_rl
499: ,p_prtn_eff_end_dt_rl_o =>ben_epa_shd.g_old_rec.prtn_eff_end_dt_rl
500: ,p_wait_perd_dt_to_use_cd_o =>ben_epa_shd.g_old_rec.wait_perd_dt_to_use_cd
501: ,p_wait_perd_dt_to_use_rl_o =>ben_epa_shd.g_old_rec.wait_perd_dt_to_use_rl

Line 498: ,p_prtn_eff_strt_dt_rl_o =>ben_epa_shd.g_old_rec.prtn_eff_strt_dt_rl

494: ,p_plip_id_o =>ben_epa_shd.g_old_rec.plip_id
495: ,p_trk_scr_for_inelg_flag_o =>ben_epa_shd.g_old_rec.trk_scr_for_inelg_flag
496: ,p_prtn_eff_strt_dt_cd_o =>ben_epa_shd.g_old_rec.prtn_eff_strt_dt_cd
497: ,p_prtn_eff_end_dt_cd_o =>ben_epa_shd.g_old_rec.prtn_eff_end_dt_cd
498: ,p_prtn_eff_strt_dt_rl_o =>ben_epa_shd.g_old_rec.prtn_eff_strt_dt_rl
499: ,p_prtn_eff_end_dt_rl_o =>ben_epa_shd.g_old_rec.prtn_eff_end_dt_rl
500: ,p_wait_perd_dt_to_use_cd_o =>ben_epa_shd.g_old_rec.wait_perd_dt_to_use_cd
501: ,p_wait_perd_dt_to_use_rl_o =>ben_epa_shd.g_old_rec.wait_perd_dt_to_use_rl
502: ,p_wait_perd_val_o =>ben_epa_shd.g_old_rec.wait_perd_val

Line 499: ,p_prtn_eff_end_dt_rl_o =>ben_epa_shd.g_old_rec.prtn_eff_end_dt_rl

495: ,p_trk_scr_for_inelg_flag_o =>ben_epa_shd.g_old_rec.trk_scr_for_inelg_flag
496: ,p_prtn_eff_strt_dt_cd_o =>ben_epa_shd.g_old_rec.prtn_eff_strt_dt_cd
497: ,p_prtn_eff_end_dt_cd_o =>ben_epa_shd.g_old_rec.prtn_eff_end_dt_cd
498: ,p_prtn_eff_strt_dt_rl_o =>ben_epa_shd.g_old_rec.prtn_eff_strt_dt_rl
499: ,p_prtn_eff_end_dt_rl_o =>ben_epa_shd.g_old_rec.prtn_eff_end_dt_rl
500: ,p_wait_perd_dt_to_use_cd_o =>ben_epa_shd.g_old_rec.wait_perd_dt_to_use_cd
501: ,p_wait_perd_dt_to_use_rl_o =>ben_epa_shd.g_old_rec.wait_perd_dt_to_use_rl
502: ,p_wait_perd_val_o =>ben_epa_shd.g_old_rec.wait_perd_val
503: ,p_wait_perd_uom_o =>ben_epa_shd.g_old_rec.wait_perd_uom

Line 500: ,p_wait_perd_dt_to_use_cd_o =>ben_epa_shd.g_old_rec.wait_perd_dt_to_use_cd

496: ,p_prtn_eff_strt_dt_cd_o =>ben_epa_shd.g_old_rec.prtn_eff_strt_dt_cd
497: ,p_prtn_eff_end_dt_cd_o =>ben_epa_shd.g_old_rec.prtn_eff_end_dt_cd
498: ,p_prtn_eff_strt_dt_rl_o =>ben_epa_shd.g_old_rec.prtn_eff_strt_dt_rl
499: ,p_prtn_eff_end_dt_rl_o =>ben_epa_shd.g_old_rec.prtn_eff_end_dt_rl
500: ,p_wait_perd_dt_to_use_cd_o =>ben_epa_shd.g_old_rec.wait_perd_dt_to_use_cd
501: ,p_wait_perd_dt_to_use_rl_o =>ben_epa_shd.g_old_rec.wait_perd_dt_to_use_rl
502: ,p_wait_perd_val_o =>ben_epa_shd.g_old_rec.wait_perd_val
503: ,p_wait_perd_uom_o =>ben_epa_shd.g_old_rec.wait_perd_uom
504: ,p_wait_perd_rl_o =>ben_epa_shd.g_old_rec.wait_perd_rl

Line 501: ,p_wait_perd_dt_to_use_rl_o =>ben_epa_shd.g_old_rec.wait_perd_dt_to_use_rl

497: ,p_prtn_eff_end_dt_cd_o =>ben_epa_shd.g_old_rec.prtn_eff_end_dt_cd
498: ,p_prtn_eff_strt_dt_rl_o =>ben_epa_shd.g_old_rec.prtn_eff_strt_dt_rl
499: ,p_prtn_eff_end_dt_rl_o =>ben_epa_shd.g_old_rec.prtn_eff_end_dt_rl
500: ,p_wait_perd_dt_to_use_cd_o =>ben_epa_shd.g_old_rec.wait_perd_dt_to_use_cd
501: ,p_wait_perd_dt_to_use_rl_o =>ben_epa_shd.g_old_rec.wait_perd_dt_to_use_rl
502: ,p_wait_perd_val_o =>ben_epa_shd.g_old_rec.wait_perd_val
503: ,p_wait_perd_uom_o =>ben_epa_shd.g_old_rec.wait_perd_uom
504: ,p_wait_perd_rl_o =>ben_epa_shd.g_old_rec.wait_perd_rl
505: ,p_mx_poe_det_dt_cd_o =>ben_epa_shd.g_old_rec.mx_poe_det_dt_cd

Line 502: ,p_wait_perd_val_o =>ben_epa_shd.g_old_rec.wait_perd_val

498: ,p_prtn_eff_strt_dt_rl_o =>ben_epa_shd.g_old_rec.prtn_eff_strt_dt_rl
499: ,p_prtn_eff_end_dt_rl_o =>ben_epa_shd.g_old_rec.prtn_eff_end_dt_rl
500: ,p_wait_perd_dt_to_use_cd_o =>ben_epa_shd.g_old_rec.wait_perd_dt_to_use_cd
501: ,p_wait_perd_dt_to_use_rl_o =>ben_epa_shd.g_old_rec.wait_perd_dt_to_use_rl
502: ,p_wait_perd_val_o =>ben_epa_shd.g_old_rec.wait_perd_val
503: ,p_wait_perd_uom_o =>ben_epa_shd.g_old_rec.wait_perd_uom
504: ,p_wait_perd_rl_o =>ben_epa_shd.g_old_rec.wait_perd_rl
505: ,p_mx_poe_det_dt_cd_o =>ben_epa_shd.g_old_rec.mx_poe_det_dt_cd
506: ,p_mx_poe_det_dt_rl_o =>ben_epa_shd.g_old_rec.mx_poe_det_dt_rl

Line 503: ,p_wait_perd_uom_o =>ben_epa_shd.g_old_rec.wait_perd_uom

499: ,p_prtn_eff_end_dt_rl_o =>ben_epa_shd.g_old_rec.prtn_eff_end_dt_rl
500: ,p_wait_perd_dt_to_use_cd_o =>ben_epa_shd.g_old_rec.wait_perd_dt_to_use_cd
501: ,p_wait_perd_dt_to_use_rl_o =>ben_epa_shd.g_old_rec.wait_perd_dt_to_use_rl
502: ,p_wait_perd_val_o =>ben_epa_shd.g_old_rec.wait_perd_val
503: ,p_wait_perd_uom_o =>ben_epa_shd.g_old_rec.wait_perd_uom
504: ,p_wait_perd_rl_o =>ben_epa_shd.g_old_rec.wait_perd_rl
505: ,p_mx_poe_det_dt_cd_o =>ben_epa_shd.g_old_rec.mx_poe_det_dt_cd
506: ,p_mx_poe_det_dt_rl_o =>ben_epa_shd.g_old_rec.mx_poe_det_dt_rl
507: ,p_mx_poe_val_o =>ben_epa_shd.g_old_rec.mx_poe_val

Line 504: ,p_wait_perd_rl_o =>ben_epa_shd.g_old_rec.wait_perd_rl

500: ,p_wait_perd_dt_to_use_cd_o =>ben_epa_shd.g_old_rec.wait_perd_dt_to_use_cd
501: ,p_wait_perd_dt_to_use_rl_o =>ben_epa_shd.g_old_rec.wait_perd_dt_to_use_rl
502: ,p_wait_perd_val_o =>ben_epa_shd.g_old_rec.wait_perd_val
503: ,p_wait_perd_uom_o =>ben_epa_shd.g_old_rec.wait_perd_uom
504: ,p_wait_perd_rl_o =>ben_epa_shd.g_old_rec.wait_perd_rl
505: ,p_mx_poe_det_dt_cd_o =>ben_epa_shd.g_old_rec.mx_poe_det_dt_cd
506: ,p_mx_poe_det_dt_rl_o =>ben_epa_shd.g_old_rec.mx_poe_det_dt_rl
507: ,p_mx_poe_val_o =>ben_epa_shd.g_old_rec.mx_poe_val
508: ,p_mx_poe_uom_o =>ben_epa_shd.g_old_rec.mx_poe_uom

Line 505: ,p_mx_poe_det_dt_cd_o =>ben_epa_shd.g_old_rec.mx_poe_det_dt_cd

501: ,p_wait_perd_dt_to_use_rl_o =>ben_epa_shd.g_old_rec.wait_perd_dt_to_use_rl
502: ,p_wait_perd_val_o =>ben_epa_shd.g_old_rec.wait_perd_val
503: ,p_wait_perd_uom_o =>ben_epa_shd.g_old_rec.wait_perd_uom
504: ,p_wait_perd_rl_o =>ben_epa_shd.g_old_rec.wait_perd_rl
505: ,p_mx_poe_det_dt_cd_o =>ben_epa_shd.g_old_rec.mx_poe_det_dt_cd
506: ,p_mx_poe_det_dt_rl_o =>ben_epa_shd.g_old_rec.mx_poe_det_dt_rl
507: ,p_mx_poe_val_o =>ben_epa_shd.g_old_rec.mx_poe_val
508: ,p_mx_poe_uom_o =>ben_epa_shd.g_old_rec.mx_poe_uom
509: ,p_mx_poe_rl_o =>ben_epa_shd.g_old_rec.mx_poe_rl

Line 506: ,p_mx_poe_det_dt_rl_o =>ben_epa_shd.g_old_rec.mx_poe_det_dt_rl

502: ,p_wait_perd_val_o =>ben_epa_shd.g_old_rec.wait_perd_val
503: ,p_wait_perd_uom_o =>ben_epa_shd.g_old_rec.wait_perd_uom
504: ,p_wait_perd_rl_o =>ben_epa_shd.g_old_rec.wait_perd_rl
505: ,p_mx_poe_det_dt_cd_o =>ben_epa_shd.g_old_rec.mx_poe_det_dt_cd
506: ,p_mx_poe_det_dt_rl_o =>ben_epa_shd.g_old_rec.mx_poe_det_dt_rl
507: ,p_mx_poe_val_o =>ben_epa_shd.g_old_rec.mx_poe_val
508: ,p_mx_poe_uom_o =>ben_epa_shd.g_old_rec.mx_poe_uom
509: ,p_mx_poe_rl_o =>ben_epa_shd.g_old_rec.mx_poe_rl
510: ,p_mx_poe_apls_cd_o =>ben_epa_shd.g_old_rec.mx_poe_apls_cd

Line 507: ,p_mx_poe_val_o =>ben_epa_shd.g_old_rec.mx_poe_val

503: ,p_wait_perd_uom_o =>ben_epa_shd.g_old_rec.wait_perd_uom
504: ,p_wait_perd_rl_o =>ben_epa_shd.g_old_rec.wait_perd_rl
505: ,p_mx_poe_det_dt_cd_o =>ben_epa_shd.g_old_rec.mx_poe_det_dt_cd
506: ,p_mx_poe_det_dt_rl_o =>ben_epa_shd.g_old_rec.mx_poe_det_dt_rl
507: ,p_mx_poe_val_o =>ben_epa_shd.g_old_rec.mx_poe_val
508: ,p_mx_poe_uom_o =>ben_epa_shd.g_old_rec.mx_poe_uom
509: ,p_mx_poe_rl_o =>ben_epa_shd.g_old_rec.mx_poe_rl
510: ,p_mx_poe_apls_cd_o =>ben_epa_shd.g_old_rec.mx_poe_apls_cd
511: ,p_epa_attribute_category_o =>ben_epa_shd.g_old_rec.epa_attribute_category

Line 508: ,p_mx_poe_uom_o =>ben_epa_shd.g_old_rec.mx_poe_uom

504: ,p_wait_perd_rl_o =>ben_epa_shd.g_old_rec.wait_perd_rl
505: ,p_mx_poe_det_dt_cd_o =>ben_epa_shd.g_old_rec.mx_poe_det_dt_cd
506: ,p_mx_poe_det_dt_rl_o =>ben_epa_shd.g_old_rec.mx_poe_det_dt_rl
507: ,p_mx_poe_val_o =>ben_epa_shd.g_old_rec.mx_poe_val
508: ,p_mx_poe_uom_o =>ben_epa_shd.g_old_rec.mx_poe_uom
509: ,p_mx_poe_rl_o =>ben_epa_shd.g_old_rec.mx_poe_rl
510: ,p_mx_poe_apls_cd_o =>ben_epa_shd.g_old_rec.mx_poe_apls_cd
511: ,p_epa_attribute_category_o =>ben_epa_shd.g_old_rec.epa_attribute_category
512: ,p_epa_attribute1_o =>ben_epa_shd.g_old_rec.epa_attribute1

Line 509: ,p_mx_poe_rl_o =>ben_epa_shd.g_old_rec.mx_poe_rl

505: ,p_mx_poe_det_dt_cd_o =>ben_epa_shd.g_old_rec.mx_poe_det_dt_cd
506: ,p_mx_poe_det_dt_rl_o =>ben_epa_shd.g_old_rec.mx_poe_det_dt_rl
507: ,p_mx_poe_val_o =>ben_epa_shd.g_old_rec.mx_poe_val
508: ,p_mx_poe_uom_o =>ben_epa_shd.g_old_rec.mx_poe_uom
509: ,p_mx_poe_rl_o =>ben_epa_shd.g_old_rec.mx_poe_rl
510: ,p_mx_poe_apls_cd_o =>ben_epa_shd.g_old_rec.mx_poe_apls_cd
511: ,p_epa_attribute_category_o =>ben_epa_shd.g_old_rec.epa_attribute_category
512: ,p_epa_attribute1_o =>ben_epa_shd.g_old_rec.epa_attribute1
513: ,p_epa_attribute2_o =>ben_epa_shd.g_old_rec.epa_attribute2

Line 510: ,p_mx_poe_apls_cd_o =>ben_epa_shd.g_old_rec.mx_poe_apls_cd

506: ,p_mx_poe_det_dt_rl_o =>ben_epa_shd.g_old_rec.mx_poe_det_dt_rl
507: ,p_mx_poe_val_o =>ben_epa_shd.g_old_rec.mx_poe_val
508: ,p_mx_poe_uom_o =>ben_epa_shd.g_old_rec.mx_poe_uom
509: ,p_mx_poe_rl_o =>ben_epa_shd.g_old_rec.mx_poe_rl
510: ,p_mx_poe_apls_cd_o =>ben_epa_shd.g_old_rec.mx_poe_apls_cd
511: ,p_epa_attribute_category_o =>ben_epa_shd.g_old_rec.epa_attribute_category
512: ,p_epa_attribute1_o =>ben_epa_shd.g_old_rec.epa_attribute1
513: ,p_epa_attribute2_o =>ben_epa_shd.g_old_rec.epa_attribute2
514: ,p_epa_attribute3_o =>ben_epa_shd.g_old_rec.epa_attribute3

Line 511: ,p_epa_attribute_category_o =>ben_epa_shd.g_old_rec.epa_attribute_category

507: ,p_mx_poe_val_o =>ben_epa_shd.g_old_rec.mx_poe_val
508: ,p_mx_poe_uom_o =>ben_epa_shd.g_old_rec.mx_poe_uom
509: ,p_mx_poe_rl_o =>ben_epa_shd.g_old_rec.mx_poe_rl
510: ,p_mx_poe_apls_cd_o =>ben_epa_shd.g_old_rec.mx_poe_apls_cd
511: ,p_epa_attribute_category_o =>ben_epa_shd.g_old_rec.epa_attribute_category
512: ,p_epa_attribute1_o =>ben_epa_shd.g_old_rec.epa_attribute1
513: ,p_epa_attribute2_o =>ben_epa_shd.g_old_rec.epa_attribute2
514: ,p_epa_attribute3_o =>ben_epa_shd.g_old_rec.epa_attribute3
515: ,p_epa_attribute4_o =>ben_epa_shd.g_old_rec.epa_attribute4

Line 512: ,p_epa_attribute1_o =>ben_epa_shd.g_old_rec.epa_attribute1

508: ,p_mx_poe_uom_o =>ben_epa_shd.g_old_rec.mx_poe_uom
509: ,p_mx_poe_rl_o =>ben_epa_shd.g_old_rec.mx_poe_rl
510: ,p_mx_poe_apls_cd_o =>ben_epa_shd.g_old_rec.mx_poe_apls_cd
511: ,p_epa_attribute_category_o =>ben_epa_shd.g_old_rec.epa_attribute_category
512: ,p_epa_attribute1_o =>ben_epa_shd.g_old_rec.epa_attribute1
513: ,p_epa_attribute2_o =>ben_epa_shd.g_old_rec.epa_attribute2
514: ,p_epa_attribute3_o =>ben_epa_shd.g_old_rec.epa_attribute3
515: ,p_epa_attribute4_o =>ben_epa_shd.g_old_rec.epa_attribute4
516: ,p_epa_attribute5_o =>ben_epa_shd.g_old_rec.epa_attribute5

Line 513: ,p_epa_attribute2_o =>ben_epa_shd.g_old_rec.epa_attribute2

509: ,p_mx_poe_rl_o =>ben_epa_shd.g_old_rec.mx_poe_rl
510: ,p_mx_poe_apls_cd_o =>ben_epa_shd.g_old_rec.mx_poe_apls_cd
511: ,p_epa_attribute_category_o =>ben_epa_shd.g_old_rec.epa_attribute_category
512: ,p_epa_attribute1_o =>ben_epa_shd.g_old_rec.epa_attribute1
513: ,p_epa_attribute2_o =>ben_epa_shd.g_old_rec.epa_attribute2
514: ,p_epa_attribute3_o =>ben_epa_shd.g_old_rec.epa_attribute3
515: ,p_epa_attribute4_o =>ben_epa_shd.g_old_rec.epa_attribute4
516: ,p_epa_attribute5_o =>ben_epa_shd.g_old_rec.epa_attribute5
517: ,p_epa_attribute6_o =>ben_epa_shd.g_old_rec.epa_attribute6

Line 514: ,p_epa_attribute3_o =>ben_epa_shd.g_old_rec.epa_attribute3

510: ,p_mx_poe_apls_cd_o =>ben_epa_shd.g_old_rec.mx_poe_apls_cd
511: ,p_epa_attribute_category_o =>ben_epa_shd.g_old_rec.epa_attribute_category
512: ,p_epa_attribute1_o =>ben_epa_shd.g_old_rec.epa_attribute1
513: ,p_epa_attribute2_o =>ben_epa_shd.g_old_rec.epa_attribute2
514: ,p_epa_attribute3_o =>ben_epa_shd.g_old_rec.epa_attribute3
515: ,p_epa_attribute4_o =>ben_epa_shd.g_old_rec.epa_attribute4
516: ,p_epa_attribute5_o =>ben_epa_shd.g_old_rec.epa_attribute5
517: ,p_epa_attribute6_o =>ben_epa_shd.g_old_rec.epa_attribute6
518: ,p_epa_attribute7_o =>ben_epa_shd.g_old_rec.epa_attribute7

Line 515: ,p_epa_attribute4_o =>ben_epa_shd.g_old_rec.epa_attribute4

511: ,p_epa_attribute_category_o =>ben_epa_shd.g_old_rec.epa_attribute_category
512: ,p_epa_attribute1_o =>ben_epa_shd.g_old_rec.epa_attribute1
513: ,p_epa_attribute2_o =>ben_epa_shd.g_old_rec.epa_attribute2
514: ,p_epa_attribute3_o =>ben_epa_shd.g_old_rec.epa_attribute3
515: ,p_epa_attribute4_o =>ben_epa_shd.g_old_rec.epa_attribute4
516: ,p_epa_attribute5_o =>ben_epa_shd.g_old_rec.epa_attribute5
517: ,p_epa_attribute6_o =>ben_epa_shd.g_old_rec.epa_attribute6
518: ,p_epa_attribute7_o =>ben_epa_shd.g_old_rec.epa_attribute7
519: ,p_epa_attribute8_o =>ben_epa_shd.g_old_rec.epa_attribute8

Line 516: ,p_epa_attribute5_o =>ben_epa_shd.g_old_rec.epa_attribute5

512: ,p_epa_attribute1_o =>ben_epa_shd.g_old_rec.epa_attribute1
513: ,p_epa_attribute2_o =>ben_epa_shd.g_old_rec.epa_attribute2
514: ,p_epa_attribute3_o =>ben_epa_shd.g_old_rec.epa_attribute3
515: ,p_epa_attribute4_o =>ben_epa_shd.g_old_rec.epa_attribute4
516: ,p_epa_attribute5_o =>ben_epa_shd.g_old_rec.epa_attribute5
517: ,p_epa_attribute6_o =>ben_epa_shd.g_old_rec.epa_attribute6
518: ,p_epa_attribute7_o =>ben_epa_shd.g_old_rec.epa_attribute7
519: ,p_epa_attribute8_o =>ben_epa_shd.g_old_rec.epa_attribute8
520: ,p_epa_attribute9_o =>ben_epa_shd.g_old_rec.epa_attribute9

Line 517: ,p_epa_attribute6_o =>ben_epa_shd.g_old_rec.epa_attribute6

513: ,p_epa_attribute2_o =>ben_epa_shd.g_old_rec.epa_attribute2
514: ,p_epa_attribute3_o =>ben_epa_shd.g_old_rec.epa_attribute3
515: ,p_epa_attribute4_o =>ben_epa_shd.g_old_rec.epa_attribute4
516: ,p_epa_attribute5_o =>ben_epa_shd.g_old_rec.epa_attribute5
517: ,p_epa_attribute6_o =>ben_epa_shd.g_old_rec.epa_attribute6
518: ,p_epa_attribute7_o =>ben_epa_shd.g_old_rec.epa_attribute7
519: ,p_epa_attribute8_o =>ben_epa_shd.g_old_rec.epa_attribute8
520: ,p_epa_attribute9_o =>ben_epa_shd.g_old_rec.epa_attribute9
521: ,p_epa_attribute10_o =>ben_epa_shd.g_old_rec.epa_attribute10

Line 518: ,p_epa_attribute7_o =>ben_epa_shd.g_old_rec.epa_attribute7

514: ,p_epa_attribute3_o =>ben_epa_shd.g_old_rec.epa_attribute3
515: ,p_epa_attribute4_o =>ben_epa_shd.g_old_rec.epa_attribute4
516: ,p_epa_attribute5_o =>ben_epa_shd.g_old_rec.epa_attribute5
517: ,p_epa_attribute6_o =>ben_epa_shd.g_old_rec.epa_attribute6
518: ,p_epa_attribute7_o =>ben_epa_shd.g_old_rec.epa_attribute7
519: ,p_epa_attribute8_o =>ben_epa_shd.g_old_rec.epa_attribute8
520: ,p_epa_attribute9_o =>ben_epa_shd.g_old_rec.epa_attribute9
521: ,p_epa_attribute10_o =>ben_epa_shd.g_old_rec.epa_attribute10
522: ,p_epa_attribute11_o =>ben_epa_shd.g_old_rec.epa_attribute11

Line 519: ,p_epa_attribute8_o =>ben_epa_shd.g_old_rec.epa_attribute8

515: ,p_epa_attribute4_o =>ben_epa_shd.g_old_rec.epa_attribute4
516: ,p_epa_attribute5_o =>ben_epa_shd.g_old_rec.epa_attribute5
517: ,p_epa_attribute6_o =>ben_epa_shd.g_old_rec.epa_attribute6
518: ,p_epa_attribute7_o =>ben_epa_shd.g_old_rec.epa_attribute7
519: ,p_epa_attribute8_o =>ben_epa_shd.g_old_rec.epa_attribute8
520: ,p_epa_attribute9_o =>ben_epa_shd.g_old_rec.epa_attribute9
521: ,p_epa_attribute10_o =>ben_epa_shd.g_old_rec.epa_attribute10
522: ,p_epa_attribute11_o =>ben_epa_shd.g_old_rec.epa_attribute11
523: ,p_epa_attribute12_o =>ben_epa_shd.g_old_rec.epa_attribute12

Line 520: ,p_epa_attribute9_o =>ben_epa_shd.g_old_rec.epa_attribute9

516: ,p_epa_attribute5_o =>ben_epa_shd.g_old_rec.epa_attribute5
517: ,p_epa_attribute6_o =>ben_epa_shd.g_old_rec.epa_attribute6
518: ,p_epa_attribute7_o =>ben_epa_shd.g_old_rec.epa_attribute7
519: ,p_epa_attribute8_o =>ben_epa_shd.g_old_rec.epa_attribute8
520: ,p_epa_attribute9_o =>ben_epa_shd.g_old_rec.epa_attribute9
521: ,p_epa_attribute10_o =>ben_epa_shd.g_old_rec.epa_attribute10
522: ,p_epa_attribute11_o =>ben_epa_shd.g_old_rec.epa_attribute11
523: ,p_epa_attribute12_o =>ben_epa_shd.g_old_rec.epa_attribute12
524: ,p_epa_attribute13_o =>ben_epa_shd.g_old_rec.epa_attribute13

Line 521: ,p_epa_attribute10_o =>ben_epa_shd.g_old_rec.epa_attribute10

517: ,p_epa_attribute6_o =>ben_epa_shd.g_old_rec.epa_attribute6
518: ,p_epa_attribute7_o =>ben_epa_shd.g_old_rec.epa_attribute7
519: ,p_epa_attribute8_o =>ben_epa_shd.g_old_rec.epa_attribute8
520: ,p_epa_attribute9_o =>ben_epa_shd.g_old_rec.epa_attribute9
521: ,p_epa_attribute10_o =>ben_epa_shd.g_old_rec.epa_attribute10
522: ,p_epa_attribute11_o =>ben_epa_shd.g_old_rec.epa_attribute11
523: ,p_epa_attribute12_o =>ben_epa_shd.g_old_rec.epa_attribute12
524: ,p_epa_attribute13_o =>ben_epa_shd.g_old_rec.epa_attribute13
525: ,p_epa_attribute14_o =>ben_epa_shd.g_old_rec.epa_attribute14

Line 522: ,p_epa_attribute11_o =>ben_epa_shd.g_old_rec.epa_attribute11

518: ,p_epa_attribute7_o =>ben_epa_shd.g_old_rec.epa_attribute7
519: ,p_epa_attribute8_o =>ben_epa_shd.g_old_rec.epa_attribute8
520: ,p_epa_attribute9_o =>ben_epa_shd.g_old_rec.epa_attribute9
521: ,p_epa_attribute10_o =>ben_epa_shd.g_old_rec.epa_attribute10
522: ,p_epa_attribute11_o =>ben_epa_shd.g_old_rec.epa_attribute11
523: ,p_epa_attribute12_o =>ben_epa_shd.g_old_rec.epa_attribute12
524: ,p_epa_attribute13_o =>ben_epa_shd.g_old_rec.epa_attribute13
525: ,p_epa_attribute14_o =>ben_epa_shd.g_old_rec.epa_attribute14
526: ,p_epa_attribute15_o =>ben_epa_shd.g_old_rec.epa_attribute15

Line 523: ,p_epa_attribute12_o =>ben_epa_shd.g_old_rec.epa_attribute12

519: ,p_epa_attribute8_o =>ben_epa_shd.g_old_rec.epa_attribute8
520: ,p_epa_attribute9_o =>ben_epa_shd.g_old_rec.epa_attribute9
521: ,p_epa_attribute10_o =>ben_epa_shd.g_old_rec.epa_attribute10
522: ,p_epa_attribute11_o =>ben_epa_shd.g_old_rec.epa_attribute11
523: ,p_epa_attribute12_o =>ben_epa_shd.g_old_rec.epa_attribute12
524: ,p_epa_attribute13_o =>ben_epa_shd.g_old_rec.epa_attribute13
525: ,p_epa_attribute14_o =>ben_epa_shd.g_old_rec.epa_attribute14
526: ,p_epa_attribute15_o =>ben_epa_shd.g_old_rec.epa_attribute15
527: ,p_epa_attribute16_o =>ben_epa_shd.g_old_rec.epa_attribute16

Line 524: ,p_epa_attribute13_o =>ben_epa_shd.g_old_rec.epa_attribute13

520: ,p_epa_attribute9_o =>ben_epa_shd.g_old_rec.epa_attribute9
521: ,p_epa_attribute10_o =>ben_epa_shd.g_old_rec.epa_attribute10
522: ,p_epa_attribute11_o =>ben_epa_shd.g_old_rec.epa_attribute11
523: ,p_epa_attribute12_o =>ben_epa_shd.g_old_rec.epa_attribute12
524: ,p_epa_attribute13_o =>ben_epa_shd.g_old_rec.epa_attribute13
525: ,p_epa_attribute14_o =>ben_epa_shd.g_old_rec.epa_attribute14
526: ,p_epa_attribute15_o =>ben_epa_shd.g_old_rec.epa_attribute15
527: ,p_epa_attribute16_o =>ben_epa_shd.g_old_rec.epa_attribute16
528: ,p_epa_attribute17_o =>ben_epa_shd.g_old_rec.epa_attribute17

Line 525: ,p_epa_attribute14_o =>ben_epa_shd.g_old_rec.epa_attribute14

521: ,p_epa_attribute10_o =>ben_epa_shd.g_old_rec.epa_attribute10
522: ,p_epa_attribute11_o =>ben_epa_shd.g_old_rec.epa_attribute11
523: ,p_epa_attribute12_o =>ben_epa_shd.g_old_rec.epa_attribute12
524: ,p_epa_attribute13_o =>ben_epa_shd.g_old_rec.epa_attribute13
525: ,p_epa_attribute14_o =>ben_epa_shd.g_old_rec.epa_attribute14
526: ,p_epa_attribute15_o =>ben_epa_shd.g_old_rec.epa_attribute15
527: ,p_epa_attribute16_o =>ben_epa_shd.g_old_rec.epa_attribute16
528: ,p_epa_attribute17_o =>ben_epa_shd.g_old_rec.epa_attribute17
529: ,p_epa_attribute18_o =>ben_epa_shd.g_old_rec.epa_attribute18

Line 526: ,p_epa_attribute15_o =>ben_epa_shd.g_old_rec.epa_attribute15

522: ,p_epa_attribute11_o =>ben_epa_shd.g_old_rec.epa_attribute11
523: ,p_epa_attribute12_o =>ben_epa_shd.g_old_rec.epa_attribute12
524: ,p_epa_attribute13_o =>ben_epa_shd.g_old_rec.epa_attribute13
525: ,p_epa_attribute14_o =>ben_epa_shd.g_old_rec.epa_attribute14
526: ,p_epa_attribute15_o =>ben_epa_shd.g_old_rec.epa_attribute15
527: ,p_epa_attribute16_o =>ben_epa_shd.g_old_rec.epa_attribute16
528: ,p_epa_attribute17_o =>ben_epa_shd.g_old_rec.epa_attribute17
529: ,p_epa_attribute18_o =>ben_epa_shd.g_old_rec.epa_attribute18
530: ,p_epa_attribute19_o =>ben_epa_shd.g_old_rec.epa_attribute19

Line 527: ,p_epa_attribute16_o =>ben_epa_shd.g_old_rec.epa_attribute16

523: ,p_epa_attribute12_o =>ben_epa_shd.g_old_rec.epa_attribute12
524: ,p_epa_attribute13_o =>ben_epa_shd.g_old_rec.epa_attribute13
525: ,p_epa_attribute14_o =>ben_epa_shd.g_old_rec.epa_attribute14
526: ,p_epa_attribute15_o =>ben_epa_shd.g_old_rec.epa_attribute15
527: ,p_epa_attribute16_o =>ben_epa_shd.g_old_rec.epa_attribute16
528: ,p_epa_attribute17_o =>ben_epa_shd.g_old_rec.epa_attribute17
529: ,p_epa_attribute18_o =>ben_epa_shd.g_old_rec.epa_attribute18
530: ,p_epa_attribute19_o =>ben_epa_shd.g_old_rec.epa_attribute19
531: ,p_epa_attribute20_o =>ben_epa_shd.g_old_rec.epa_attribute20

Line 528: ,p_epa_attribute17_o =>ben_epa_shd.g_old_rec.epa_attribute17

524: ,p_epa_attribute13_o =>ben_epa_shd.g_old_rec.epa_attribute13
525: ,p_epa_attribute14_o =>ben_epa_shd.g_old_rec.epa_attribute14
526: ,p_epa_attribute15_o =>ben_epa_shd.g_old_rec.epa_attribute15
527: ,p_epa_attribute16_o =>ben_epa_shd.g_old_rec.epa_attribute16
528: ,p_epa_attribute17_o =>ben_epa_shd.g_old_rec.epa_attribute17
529: ,p_epa_attribute18_o =>ben_epa_shd.g_old_rec.epa_attribute18
530: ,p_epa_attribute19_o =>ben_epa_shd.g_old_rec.epa_attribute19
531: ,p_epa_attribute20_o =>ben_epa_shd.g_old_rec.epa_attribute20
532: ,p_epa_attribute21_o =>ben_epa_shd.g_old_rec.epa_attribute21

Line 529: ,p_epa_attribute18_o =>ben_epa_shd.g_old_rec.epa_attribute18

525: ,p_epa_attribute14_o =>ben_epa_shd.g_old_rec.epa_attribute14
526: ,p_epa_attribute15_o =>ben_epa_shd.g_old_rec.epa_attribute15
527: ,p_epa_attribute16_o =>ben_epa_shd.g_old_rec.epa_attribute16
528: ,p_epa_attribute17_o =>ben_epa_shd.g_old_rec.epa_attribute17
529: ,p_epa_attribute18_o =>ben_epa_shd.g_old_rec.epa_attribute18
530: ,p_epa_attribute19_o =>ben_epa_shd.g_old_rec.epa_attribute19
531: ,p_epa_attribute20_o =>ben_epa_shd.g_old_rec.epa_attribute20
532: ,p_epa_attribute21_o =>ben_epa_shd.g_old_rec.epa_attribute21
533: ,p_epa_attribute22_o =>ben_epa_shd.g_old_rec.epa_attribute22

Line 530: ,p_epa_attribute19_o =>ben_epa_shd.g_old_rec.epa_attribute19

526: ,p_epa_attribute15_o =>ben_epa_shd.g_old_rec.epa_attribute15
527: ,p_epa_attribute16_o =>ben_epa_shd.g_old_rec.epa_attribute16
528: ,p_epa_attribute17_o =>ben_epa_shd.g_old_rec.epa_attribute17
529: ,p_epa_attribute18_o =>ben_epa_shd.g_old_rec.epa_attribute18
530: ,p_epa_attribute19_o =>ben_epa_shd.g_old_rec.epa_attribute19
531: ,p_epa_attribute20_o =>ben_epa_shd.g_old_rec.epa_attribute20
532: ,p_epa_attribute21_o =>ben_epa_shd.g_old_rec.epa_attribute21
533: ,p_epa_attribute22_o =>ben_epa_shd.g_old_rec.epa_attribute22
534: ,p_epa_attribute23_o =>ben_epa_shd.g_old_rec.epa_attribute23

Line 531: ,p_epa_attribute20_o =>ben_epa_shd.g_old_rec.epa_attribute20

527: ,p_epa_attribute16_o =>ben_epa_shd.g_old_rec.epa_attribute16
528: ,p_epa_attribute17_o =>ben_epa_shd.g_old_rec.epa_attribute17
529: ,p_epa_attribute18_o =>ben_epa_shd.g_old_rec.epa_attribute18
530: ,p_epa_attribute19_o =>ben_epa_shd.g_old_rec.epa_attribute19
531: ,p_epa_attribute20_o =>ben_epa_shd.g_old_rec.epa_attribute20
532: ,p_epa_attribute21_o =>ben_epa_shd.g_old_rec.epa_attribute21
533: ,p_epa_attribute22_o =>ben_epa_shd.g_old_rec.epa_attribute22
534: ,p_epa_attribute23_o =>ben_epa_shd.g_old_rec.epa_attribute23
535: ,p_epa_attribute24_o =>ben_epa_shd.g_old_rec.epa_attribute24

Line 532: ,p_epa_attribute21_o =>ben_epa_shd.g_old_rec.epa_attribute21

528: ,p_epa_attribute17_o =>ben_epa_shd.g_old_rec.epa_attribute17
529: ,p_epa_attribute18_o =>ben_epa_shd.g_old_rec.epa_attribute18
530: ,p_epa_attribute19_o =>ben_epa_shd.g_old_rec.epa_attribute19
531: ,p_epa_attribute20_o =>ben_epa_shd.g_old_rec.epa_attribute20
532: ,p_epa_attribute21_o =>ben_epa_shd.g_old_rec.epa_attribute21
533: ,p_epa_attribute22_o =>ben_epa_shd.g_old_rec.epa_attribute22
534: ,p_epa_attribute23_o =>ben_epa_shd.g_old_rec.epa_attribute23
535: ,p_epa_attribute24_o =>ben_epa_shd.g_old_rec.epa_attribute24
536: ,p_epa_attribute25_o =>ben_epa_shd.g_old_rec.epa_attribute25

Line 533: ,p_epa_attribute22_o =>ben_epa_shd.g_old_rec.epa_attribute22

529: ,p_epa_attribute18_o =>ben_epa_shd.g_old_rec.epa_attribute18
530: ,p_epa_attribute19_o =>ben_epa_shd.g_old_rec.epa_attribute19
531: ,p_epa_attribute20_o =>ben_epa_shd.g_old_rec.epa_attribute20
532: ,p_epa_attribute21_o =>ben_epa_shd.g_old_rec.epa_attribute21
533: ,p_epa_attribute22_o =>ben_epa_shd.g_old_rec.epa_attribute22
534: ,p_epa_attribute23_o =>ben_epa_shd.g_old_rec.epa_attribute23
535: ,p_epa_attribute24_o =>ben_epa_shd.g_old_rec.epa_attribute24
536: ,p_epa_attribute25_o =>ben_epa_shd.g_old_rec.epa_attribute25
537: ,p_epa_attribute26_o =>ben_epa_shd.g_old_rec.epa_attribute26

Line 534: ,p_epa_attribute23_o =>ben_epa_shd.g_old_rec.epa_attribute23

530: ,p_epa_attribute19_o =>ben_epa_shd.g_old_rec.epa_attribute19
531: ,p_epa_attribute20_o =>ben_epa_shd.g_old_rec.epa_attribute20
532: ,p_epa_attribute21_o =>ben_epa_shd.g_old_rec.epa_attribute21
533: ,p_epa_attribute22_o =>ben_epa_shd.g_old_rec.epa_attribute22
534: ,p_epa_attribute23_o =>ben_epa_shd.g_old_rec.epa_attribute23
535: ,p_epa_attribute24_o =>ben_epa_shd.g_old_rec.epa_attribute24
536: ,p_epa_attribute25_o =>ben_epa_shd.g_old_rec.epa_attribute25
537: ,p_epa_attribute26_o =>ben_epa_shd.g_old_rec.epa_attribute26
538: ,p_epa_attribute27_o =>ben_epa_shd.g_old_rec.epa_attribute27

Line 535: ,p_epa_attribute24_o =>ben_epa_shd.g_old_rec.epa_attribute24

531: ,p_epa_attribute20_o =>ben_epa_shd.g_old_rec.epa_attribute20
532: ,p_epa_attribute21_o =>ben_epa_shd.g_old_rec.epa_attribute21
533: ,p_epa_attribute22_o =>ben_epa_shd.g_old_rec.epa_attribute22
534: ,p_epa_attribute23_o =>ben_epa_shd.g_old_rec.epa_attribute23
535: ,p_epa_attribute24_o =>ben_epa_shd.g_old_rec.epa_attribute24
536: ,p_epa_attribute25_o =>ben_epa_shd.g_old_rec.epa_attribute25
537: ,p_epa_attribute26_o =>ben_epa_shd.g_old_rec.epa_attribute26
538: ,p_epa_attribute27_o =>ben_epa_shd.g_old_rec.epa_attribute27
539: ,p_epa_attribute28_o =>ben_epa_shd.g_old_rec.epa_attribute28

Line 536: ,p_epa_attribute25_o =>ben_epa_shd.g_old_rec.epa_attribute25

532: ,p_epa_attribute21_o =>ben_epa_shd.g_old_rec.epa_attribute21
533: ,p_epa_attribute22_o =>ben_epa_shd.g_old_rec.epa_attribute22
534: ,p_epa_attribute23_o =>ben_epa_shd.g_old_rec.epa_attribute23
535: ,p_epa_attribute24_o =>ben_epa_shd.g_old_rec.epa_attribute24
536: ,p_epa_attribute25_o =>ben_epa_shd.g_old_rec.epa_attribute25
537: ,p_epa_attribute26_o =>ben_epa_shd.g_old_rec.epa_attribute26
538: ,p_epa_attribute27_o =>ben_epa_shd.g_old_rec.epa_attribute27
539: ,p_epa_attribute28_o =>ben_epa_shd.g_old_rec.epa_attribute28
540: ,p_epa_attribute29_o =>ben_epa_shd.g_old_rec.epa_attribute29

Line 537: ,p_epa_attribute26_o =>ben_epa_shd.g_old_rec.epa_attribute26

533: ,p_epa_attribute22_o =>ben_epa_shd.g_old_rec.epa_attribute22
534: ,p_epa_attribute23_o =>ben_epa_shd.g_old_rec.epa_attribute23
535: ,p_epa_attribute24_o =>ben_epa_shd.g_old_rec.epa_attribute24
536: ,p_epa_attribute25_o =>ben_epa_shd.g_old_rec.epa_attribute25
537: ,p_epa_attribute26_o =>ben_epa_shd.g_old_rec.epa_attribute26
538: ,p_epa_attribute27_o =>ben_epa_shd.g_old_rec.epa_attribute27
539: ,p_epa_attribute28_o =>ben_epa_shd.g_old_rec.epa_attribute28
540: ,p_epa_attribute29_o =>ben_epa_shd.g_old_rec.epa_attribute29
541: ,p_epa_attribute30_o =>ben_epa_shd.g_old_rec.epa_attribute30

Line 538: ,p_epa_attribute27_o =>ben_epa_shd.g_old_rec.epa_attribute27

534: ,p_epa_attribute23_o =>ben_epa_shd.g_old_rec.epa_attribute23
535: ,p_epa_attribute24_o =>ben_epa_shd.g_old_rec.epa_attribute24
536: ,p_epa_attribute25_o =>ben_epa_shd.g_old_rec.epa_attribute25
537: ,p_epa_attribute26_o =>ben_epa_shd.g_old_rec.epa_attribute26
538: ,p_epa_attribute27_o =>ben_epa_shd.g_old_rec.epa_attribute27
539: ,p_epa_attribute28_o =>ben_epa_shd.g_old_rec.epa_attribute28
540: ,p_epa_attribute29_o =>ben_epa_shd.g_old_rec.epa_attribute29
541: ,p_epa_attribute30_o =>ben_epa_shd.g_old_rec.epa_attribute30
542: ,p_object_version_number_o =>ben_epa_shd.g_old_rec.object_version_number

Line 539: ,p_epa_attribute28_o =>ben_epa_shd.g_old_rec.epa_attribute28

535: ,p_epa_attribute24_o =>ben_epa_shd.g_old_rec.epa_attribute24
536: ,p_epa_attribute25_o =>ben_epa_shd.g_old_rec.epa_attribute25
537: ,p_epa_attribute26_o =>ben_epa_shd.g_old_rec.epa_attribute26
538: ,p_epa_attribute27_o =>ben_epa_shd.g_old_rec.epa_attribute27
539: ,p_epa_attribute28_o =>ben_epa_shd.g_old_rec.epa_attribute28
540: ,p_epa_attribute29_o =>ben_epa_shd.g_old_rec.epa_attribute29
541: ,p_epa_attribute30_o =>ben_epa_shd.g_old_rec.epa_attribute30
542: ,p_object_version_number_o =>ben_epa_shd.g_old_rec.object_version_number
543: );

Line 540: ,p_epa_attribute29_o =>ben_epa_shd.g_old_rec.epa_attribute29

536: ,p_epa_attribute25_o =>ben_epa_shd.g_old_rec.epa_attribute25
537: ,p_epa_attribute26_o =>ben_epa_shd.g_old_rec.epa_attribute26
538: ,p_epa_attribute27_o =>ben_epa_shd.g_old_rec.epa_attribute27
539: ,p_epa_attribute28_o =>ben_epa_shd.g_old_rec.epa_attribute28
540: ,p_epa_attribute29_o =>ben_epa_shd.g_old_rec.epa_attribute29
541: ,p_epa_attribute30_o =>ben_epa_shd.g_old_rec.epa_attribute30
542: ,p_object_version_number_o =>ben_epa_shd.g_old_rec.object_version_number
543: );
544: --

Line 541: ,p_epa_attribute30_o =>ben_epa_shd.g_old_rec.epa_attribute30

537: ,p_epa_attribute26_o =>ben_epa_shd.g_old_rec.epa_attribute26
538: ,p_epa_attribute27_o =>ben_epa_shd.g_old_rec.epa_attribute27
539: ,p_epa_attribute28_o =>ben_epa_shd.g_old_rec.epa_attribute28
540: ,p_epa_attribute29_o =>ben_epa_shd.g_old_rec.epa_attribute29
541: ,p_epa_attribute30_o =>ben_epa_shd.g_old_rec.epa_attribute30
542: ,p_object_version_number_o =>ben_epa_shd.g_old_rec.object_version_number
543: );
544: --
545: exception

Line 542: ,p_object_version_number_o =>ben_epa_shd.g_old_rec.object_version_number

538: ,p_epa_attribute27_o =>ben_epa_shd.g_old_rec.epa_attribute27
539: ,p_epa_attribute28_o =>ben_epa_shd.g_old_rec.epa_attribute28
540: ,p_epa_attribute29_o =>ben_epa_shd.g_old_rec.epa_attribute29
541: ,p_epa_attribute30_o =>ben_epa_shd.g_old_rec.epa_attribute30
542: ,p_object_version_number_o =>ben_epa_shd.g_old_rec.object_version_number
543: );
544: --
545: exception
546: --

Line 603: Procedure convert_defs(p_rec in out nocopy ben_epa_shd.g_rec_type) is

599: -- Internal Row Handler Use Only.
600: --
601: -- {End Of Comments}
602: -- ----------------------------------------------------------------------------
603: Procedure convert_defs(p_rec in out nocopy ben_epa_shd.g_rec_type) is
604: --
605: l_proc varchar2(72) := g_package||'convert_defs';
606: --
607: Begin

Line 618: ben_epa_shd.g_old_rec.business_group_id;

614: -- is being used then we must set to the 'current' argument value.
615: --
616: If (p_rec.business_group_id = hr_api.g_number) then
617: p_rec.business_group_id :=
618: ben_epa_shd.g_old_rec.business_group_id;
619: End If;
620: If (p_rec.pgm_id = hr_api.g_number) then
621: p_rec.pgm_id :=
622: ben_epa_shd.g_old_rec.pgm_id;

Line 622: ben_epa_shd.g_old_rec.pgm_id;

618: ben_epa_shd.g_old_rec.business_group_id;
619: End If;
620: If (p_rec.pgm_id = hr_api.g_number) then
621: p_rec.pgm_id :=
622: ben_epa_shd.g_old_rec.pgm_id;
623: End If;
624: If (p_rec.pl_id = hr_api.g_number) then
625: p_rec.pl_id :=
626: ben_epa_shd.g_old_rec.pl_id;

Line 626: ben_epa_shd.g_old_rec.pl_id;

622: ben_epa_shd.g_old_rec.pgm_id;
623: End If;
624: If (p_rec.pl_id = hr_api.g_number) then
625: p_rec.pl_id :=
626: ben_epa_shd.g_old_rec.pl_id;
627: End If;
628: If (p_rec.oipl_id = hr_api.g_number) then
629: p_rec.oipl_id :=
630: ben_epa_shd.g_old_rec.oipl_id;

Line 630: ben_epa_shd.g_old_rec.oipl_id;

626: ben_epa_shd.g_old_rec.pl_id;
627: End If;
628: If (p_rec.oipl_id = hr_api.g_number) then
629: p_rec.oipl_id :=
630: ben_epa_shd.g_old_rec.oipl_id;
631: End If;
632: If (p_rec.ptip_id = hr_api.g_number) then
633: p_rec.ptip_id :=
634: ben_epa_shd.g_old_rec.ptip_id;

Line 634: ben_epa_shd.g_old_rec.ptip_id;

630: ben_epa_shd.g_old_rec.oipl_id;
631: End If;
632: If (p_rec.ptip_id = hr_api.g_number) then
633: p_rec.ptip_id :=
634: ben_epa_shd.g_old_rec.ptip_id;
635: End If;
636: If (p_rec.plip_id = hr_api.g_number) then
637: p_rec.plip_id :=
638: ben_epa_shd.g_old_rec.plip_id;

Line 638: ben_epa_shd.g_old_rec.plip_id;

634: ben_epa_shd.g_old_rec.ptip_id;
635: End If;
636: If (p_rec.plip_id = hr_api.g_number) then
637: p_rec.plip_id :=
638: ben_epa_shd.g_old_rec.plip_id;
639: End If;
640: If (p_rec.prtn_eff_strt_dt_cd = hr_api.g_varchar2) then
641: p_rec.prtn_eff_strt_dt_cd :=
642: ben_epa_shd.g_old_rec.prtn_eff_strt_dt_cd;

Line 642: ben_epa_shd.g_old_rec.prtn_eff_strt_dt_cd;

638: ben_epa_shd.g_old_rec.plip_id;
639: End If;
640: If (p_rec.prtn_eff_strt_dt_cd = hr_api.g_varchar2) then
641: p_rec.prtn_eff_strt_dt_cd :=
642: ben_epa_shd.g_old_rec.prtn_eff_strt_dt_cd;
643: End If;
644: If (p_rec.trk_scr_for_inelg_flag = hr_api.g_varchar2) then
645: p_rec.trk_scr_for_inelg_flag :=
646: ben_epa_shd.g_old_rec.trk_scr_for_inelg_flag;

Line 646: ben_epa_shd.g_old_rec.trk_scr_for_inelg_flag;

642: ben_epa_shd.g_old_rec.prtn_eff_strt_dt_cd;
643: End If;
644: If (p_rec.trk_scr_for_inelg_flag = hr_api.g_varchar2) then
645: p_rec.trk_scr_for_inelg_flag :=
646: ben_epa_shd.g_old_rec.trk_scr_for_inelg_flag;
647: End If;
648: If (p_rec.prtn_eff_end_dt_cd = hr_api.g_varchar2) then
649: p_rec.prtn_eff_end_dt_cd :=
650: ben_epa_shd.g_old_rec.prtn_eff_end_dt_cd;

Line 650: ben_epa_shd.g_old_rec.prtn_eff_end_dt_cd;

646: ben_epa_shd.g_old_rec.trk_scr_for_inelg_flag;
647: End If;
648: If (p_rec.prtn_eff_end_dt_cd = hr_api.g_varchar2) then
649: p_rec.prtn_eff_end_dt_cd :=
650: ben_epa_shd.g_old_rec.prtn_eff_end_dt_cd;
651: End If;
652: If (p_rec.prtn_eff_strt_dt_rl = hr_api.g_number) then
653: p_rec.prtn_eff_strt_dt_rl :=
654: ben_epa_shd.g_old_rec.prtn_eff_strt_dt_rl;

Line 654: ben_epa_shd.g_old_rec.prtn_eff_strt_dt_rl;

650: ben_epa_shd.g_old_rec.prtn_eff_end_dt_cd;
651: End If;
652: If (p_rec.prtn_eff_strt_dt_rl = hr_api.g_number) then
653: p_rec.prtn_eff_strt_dt_rl :=
654: ben_epa_shd.g_old_rec.prtn_eff_strt_dt_rl;
655: End If;
656: If (p_rec.prtn_eff_end_dt_rl = hr_api.g_number) then
657: p_rec.prtn_eff_end_dt_rl :=
658: ben_epa_shd.g_old_rec.prtn_eff_end_dt_rl;

Line 658: ben_epa_shd.g_old_rec.prtn_eff_end_dt_rl;

654: ben_epa_shd.g_old_rec.prtn_eff_strt_dt_rl;
655: End If;
656: If (p_rec.prtn_eff_end_dt_rl = hr_api.g_number) then
657: p_rec.prtn_eff_end_dt_rl :=
658: ben_epa_shd.g_old_rec.prtn_eff_end_dt_rl;
659: End If;
660: If (p_rec.wait_perd_dt_to_use_cd = hr_api.g_varchar2) then
661: p_rec.wait_perd_dt_to_use_cd :=
662: ben_epa_shd.g_old_rec.wait_perd_dt_to_use_cd;

Line 662: ben_epa_shd.g_old_rec.wait_perd_dt_to_use_cd;

658: ben_epa_shd.g_old_rec.prtn_eff_end_dt_rl;
659: End If;
660: If (p_rec.wait_perd_dt_to_use_cd = hr_api.g_varchar2) then
661: p_rec.wait_perd_dt_to_use_cd :=
662: ben_epa_shd.g_old_rec.wait_perd_dt_to_use_cd;
663: End If;
664: If (p_rec.wait_perd_dt_to_use_rl = hr_api.g_number) then
665: p_rec.wait_perd_dt_to_use_rl :=
666: ben_epa_shd.g_old_rec.wait_perd_dt_to_use_rl;

Line 666: ben_epa_shd.g_old_rec.wait_perd_dt_to_use_rl;

662: ben_epa_shd.g_old_rec.wait_perd_dt_to_use_cd;
663: End If;
664: If (p_rec.wait_perd_dt_to_use_rl = hr_api.g_number) then
665: p_rec.wait_perd_dt_to_use_rl :=
666: ben_epa_shd.g_old_rec.wait_perd_dt_to_use_rl;
667: End If;
668: If (p_rec.wait_perd_val = hr_api.g_number) then
669: p_rec.wait_perd_val :=
670: ben_epa_shd.g_old_rec.wait_perd_val;

Line 670: ben_epa_shd.g_old_rec.wait_perd_val;

666: ben_epa_shd.g_old_rec.wait_perd_dt_to_use_rl;
667: End If;
668: If (p_rec.wait_perd_val = hr_api.g_number) then
669: p_rec.wait_perd_val :=
670: ben_epa_shd.g_old_rec.wait_perd_val;
671: End If;
672: If (p_rec.wait_perd_uom = hr_api.g_varchar2) then
673: p_rec.wait_perd_uom :=
674: ben_epa_shd.g_old_rec.wait_perd_uom;

Line 674: ben_epa_shd.g_old_rec.wait_perd_uom;

670: ben_epa_shd.g_old_rec.wait_perd_val;
671: End If;
672: If (p_rec.wait_perd_uom = hr_api.g_varchar2) then
673: p_rec.wait_perd_uom :=
674: ben_epa_shd.g_old_rec.wait_perd_uom;
675: End If;
676: If (p_rec.wait_perd_rl = hr_api.g_number) then
677: p_rec.wait_perd_rl :=
678: ben_epa_shd.g_old_rec.wait_perd_rl;

Line 678: ben_epa_shd.g_old_rec.wait_perd_rl;

674: ben_epa_shd.g_old_rec.wait_perd_uom;
675: End If;
676: If (p_rec.wait_perd_rl = hr_api.g_number) then
677: p_rec.wait_perd_rl :=
678: ben_epa_shd.g_old_rec.wait_perd_rl;
679: End If;
680: If (p_rec.mx_poe_det_dt_cd = hr_api.g_varchar2) then
681: p_rec.mx_poe_det_dt_cd :=
682: ben_epa_shd.g_old_rec.mx_poe_det_dt_cd;

Line 682: ben_epa_shd.g_old_rec.mx_poe_det_dt_cd;

678: ben_epa_shd.g_old_rec.wait_perd_rl;
679: End If;
680: If (p_rec.mx_poe_det_dt_cd = hr_api.g_varchar2) then
681: p_rec.mx_poe_det_dt_cd :=
682: ben_epa_shd.g_old_rec.mx_poe_det_dt_cd;
683: End If;
684: If (p_rec.mx_poe_det_dt_rl = hr_api.g_number) then
685: p_rec.mx_poe_det_dt_rl :=
686: ben_epa_shd.g_old_rec.mx_poe_det_dt_rl;

Line 686: ben_epa_shd.g_old_rec.mx_poe_det_dt_rl;

682: ben_epa_shd.g_old_rec.mx_poe_det_dt_cd;
683: End If;
684: If (p_rec.mx_poe_det_dt_rl = hr_api.g_number) then
685: p_rec.mx_poe_det_dt_rl :=
686: ben_epa_shd.g_old_rec.mx_poe_det_dt_rl;
687: End If;
688: If (p_rec.mx_poe_val = hr_api.g_number) then
689: p_rec.mx_poe_val :=
690: ben_epa_shd.g_old_rec.mx_poe_val;

Line 690: ben_epa_shd.g_old_rec.mx_poe_val;

686: ben_epa_shd.g_old_rec.mx_poe_det_dt_rl;
687: End If;
688: If (p_rec.mx_poe_val = hr_api.g_number) then
689: p_rec.mx_poe_val :=
690: ben_epa_shd.g_old_rec.mx_poe_val;
691: End If;
692: If (p_rec.mx_poe_uom = hr_api.g_varchar2) then
693: p_rec.mx_poe_uom :=
694: ben_epa_shd.g_old_rec.mx_poe_uom;

Line 694: ben_epa_shd.g_old_rec.mx_poe_uom;

690: ben_epa_shd.g_old_rec.mx_poe_val;
691: End If;
692: If (p_rec.mx_poe_uom = hr_api.g_varchar2) then
693: p_rec.mx_poe_uom :=
694: ben_epa_shd.g_old_rec.mx_poe_uom;
695: End If;
696: If (p_rec.mx_poe_rl = hr_api.g_number) then
697: p_rec.mx_poe_rl :=
698: ben_epa_shd.g_old_rec.mx_poe_rl;

Line 698: ben_epa_shd.g_old_rec.mx_poe_rl;

694: ben_epa_shd.g_old_rec.mx_poe_uom;
695: End If;
696: If (p_rec.mx_poe_rl = hr_api.g_number) then
697: p_rec.mx_poe_rl :=
698: ben_epa_shd.g_old_rec.mx_poe_rl;
699: End If;
700: If (p_rec.mx_poe_apls_cd = hr_api.g_varchar2) then
701: p_rec.mx_poe_apls_cd :=
702: ben_epa_shd.g_old_rec.mx_poe_apls_cd;

Line 702: ben_epa_shd.g_old_rec.mx_poe_apls_cd;

698: ben_epa_shd.g_old_rec.mx_poe_rl;
699: End If;
700: If (p_rec.mx_poe_apls_cd = hr_api.g_varchar2) then
701: p_rec.mx_poe_apls_cd :=
702: ben_epa_shd.g_old_rec.mx_poe_apls_cd;
703: End If;
704: If (p_rec.epa_attribute_category = hr_api.g_varchar2) then
705: p_rec.epa_attribute_category :=
706: ben_epa_shd.g_old_rec.epa_attribute_category;

Line 706: ben_epa_shd.g_old_rec.epa_attribute_category;

702: ben_epa_shd.g_old_rec.mx_poe_apls_cd;
703: End If;
704: If (p_rec.epa_attribute_category = hr_api.g_varchar2) then
705: p_rec.epa_attribute_category :=
706: ben_epa_shd.g_old_rec.epa_attribute_category;
707: End If;
708: If (p_rec.epa_attribute1 = hr_api.g_varchar2) then
709: p_rec.epa_attribute1 :=
710: ben_epa_shd.g_old_rec.epa_attribute1;

Line 710: ben_epa_shd.g_old_rec.epa_attribute1;

706: ben_epa_shd.g_old_rec.epa_attribute_category;
707: End If;
708: If (p_rec.epa_attribute1 = hr_api.g_varchar2) then
709: p_rec.epa_attribute1 :=
710: ben_epa_shd.g_old_rec.epa_attribute1;
711: End If;
712: If (p_rec.epa_attribute2 = hr_api.g_varchar2) then
713: p_rec.epa_attribute2 :=
714: ben_epa_shd.g_old_rec.epa_attribute2;

Line 714: ben_epa_shd.g_old_rec.epa_attribute2;

710: ben_epa_shd.g_old_rec.epa_attribute1;
711: End If;
712: If (p_rec.epa_attribute2 = hr_api.g_varchar2) then
713: p_rec.epa_attribute2 :=
714: ben_epa_shd.g_old_rec.epa_attribute2;
715: End If;
716: If (p_rec.epa_attribute3 = hr_api.g_varchar2) then
717: p_rec.epa_attribute3 :=
718: ben_epa_shd.g_old_rec.epa_attribute3;

Line 718: ben_epa_shd.g_old_rec.epa_attribute3;

714: ben_epa_shd.g_old_rec.epa_attribute2;
715: End If;
716: If (p_rec.epa_attribute3 = hr_api.g_varchar2) then
717: p_rec.epa_attribute3 :=
718: ben_epa_shd.g_old_rec.epa_attribute3;
719: End If;
720: If (p_rec.epa_attribute4 = hr_api.g_varchar2) then
721: p_rec.epa_attribute4 :=
722: ben_epa_shd.g_old_rec.epa_attribute4;

Line 722: ben_epa_shd.g_old_rec.epa_attribute4;

718: ben_epa_shd.g_old_rec.epa_attribute3;
719: End If;
720: If (p_rec.epa_attribute4 = hr_api.g_varchar2) then
721: p_rec.epa_attribute4 :=
722: ben_epa_shd.g_old_rec.epa_attribute4;
723: End If;
724: If (p_rec.epa_attribute5 = hr_api.g_varchar2) then
725: p_rec.epa_attribute5 :=
726: ben_epa_shd.g_old_rec.epa_attribute5;

Line 726: ben_epa_shd.g_old_rec.epa_attribute5;

722: ben_epa_shd.g_old_rec.epa_attribute4;
723: End If;
724: If (p_rec.epa_attribute5 = hr_api.g_varchar2) then
725: p_rec.epa_attribute5 :=
726: ben_epa_shd.g_old_rec.epa_attribute5;
727: End If;
728: If (p_rec.epa_attribute6 = hr_api.g_varchar2) then
729: p_rec.epa_attribute6 :=
730: ben_epa_shd.g_old_rec.epa_attribute6;

Line 730: ben_epa_shd.g_old_rec.epa_attribute6;

726: ben_epa_shd.g_old_rec.epa_attribute5;
727: End If;
728: If (p_rec.epa_attribute6 = hr_api.g_varchar2) then
729: p_rec.epa_attribute6 :=
730: ben_epa_shd.g_old_rec.epa_attribute6;
731: End If;
732: If (p_rec.epa_attribute7 = hr_api.g_varchar2) then
733: p_rec.epa_attribute7 :=
734: ben_epa_shd.g_old_rec.epa_attribute7;

Line 734: ben_epa_shd.g_old_rec.epa_attribute7;

730: ben_epa_shd.g_old_rec.epa_attribute6;
731: End If;
732: If (p_rec.epa_attribute7 = hr_api.g_varchar2) then
733: p_rec.epa_attribute7 :=
734: ben_epa_shd.g_old_rec.epa_attribute7;
735: End If;
736: If (p_rec.epa_attribute8 = hr_api.g_varchar2) then
737: p_rec.epa_attribute8 :=
738: ben_epa_shd.g_old_rec.epa_attribute8;

Line 738: ben_epa_shd.g_old_rec.epa_attribute8;

734: ben_epa_shd.g_old_rec.epa_attribute7;
735: End If;
736: If (p_rec.epa_attribute8 = hr_api.g_varchar2) then
737: p_rec.epa_attribute8 :=
738: ben_epa_shd.g_old_rec.epa_attribute8;
739: End If;
740: If (p_rec.epa_attribute9 = hr_api.g_varchar2) then
741: p_rec.epa_attribute9 :=
742: ben_epa_shd.g_old_rec.epa_attribute9;

Line 742: ben_epa_shd.g_old_rec.epa_attribute9;

738: ben_epa_shd.g_old_rec.epa_attribute8;
739: End If;
740: If (p_rec.epa_attribute9 = hr_api.g_varchar2) then
741: p_rec.epa_attribute9 :=
742: ben_epa_shd.g_old_rec.epa_attribute9;
743: End If;
744: If (p_rec.epa_attribute10 = hr_api.g_varchar2) then
745: p_rec.epa_attribute10 :=
746: ben_epa_shd.g_old_rec.epa_attribute10;

Line 746: ben_epa_shd.g_old_rec.epa_attribute10;

742: ben_epa_shd.g_old_rec.epa_attribute9;
743: End If;
744: If (p_rec.epa_attribute10 = hr_api.g_varchar2) then
745: p_rec.epa_attribute10 :=
746: ben_epa_shd.g_old_rec.epa_attribute10;
747: End If;
748: If (p_rec.epa_attribute11 = hr_api.g_varchar2) then
749: p_rec.epa_attribute11 :=
750: ben_epa_shd.g_old_rec.epa_attribute11;

Line 750: ben_epa_shd.g_old_rec.epa_attribute11;

746: ben_epa_shd.g_old_rec.epa_attribute10;
747: End If;
748: If (p_rec.epa_attribute11 = hr_api.g_varchar2) then
749: p_rec.epa_attribute11 :=
750: ben_epa_shd.g_old_rec.epa_attribute11;
751: End If;
752: If (p_rec.epa_attribute12 = hr_api.g_varchar2) then
753: p_rec.epa_attribute12 :=
754: ben_epa_shd.g_old_rec.epa_attribute12;

Line 754: ben_epa_shd.g_old_rec.epa_attribute12;

750: ben_epa_shd.g_old_rec.epa_attribute11;
751: End If;
752: If (p_rec.epa_attribute12 = hr_api.g_varchar2) then
753: p_rec.epa_attribute12 :=
754: ben_epa_shd.g_old_rec.epa_attribute12;
755: End If;
756: If (p_rec.epa_attribute13 = hr_api.g_varchar2) then
757: p_rec.epa_attribute13 :=
758: ben_epa_shd.g_old_rec.epa_attribute13;

Line 758: ben_epa_shd.g_old_rec.epa_attribute13;

754: ben_epa_shd.g_old_rec.epa_attribute12;
755: End If;
756: If (p_rec.epa_attribute13 = hr_api.g_varchar2) then
757: p_rec.epa_attribute13 :=
758: ben_epa_shd.g_old_rec.epa_attribute13;
759: End If;
760: If (p_rec.epa_attribute14 = hr_api.g_varchar2) then
761: p_rec.epa_attribute14 :=
762: ben_epa_shd.g_old_rec.epa_attribute14;

Line 762: ben_epa_shd.g_old_rec.epa_attribute14;

758: ben_epa_shd.g_old_rec.epa_attribute13;
759: End If;
760: If (p_rec.epa_attribute14 = hr_api.g_varchar2) then
761: p_rec.epa_attribute14 :=
762: ben_epa_shd.g_old_rec.epa_attribute14;
763: End If;
764: If (p_rec.epa_attribute15 = hr_api.g_varchar2) then
765: p_rec.epa_attribute15 :=
766: ben_epa_shd.g_old_rec.epa_attribute15;

Line 766: ben_epa_shd.g_old_rec.epa_attribute15;

762: ben_epa_shd.g_old_rec.epa_attribute14;
763: End If;
764: If (p_rec.epa_attribute15 = hr_api.g_varchar2) then
765: p_rec.epa_attribute15 :=
766: ben_epa_shd.g_old_rec.epa_attribute15;
767: End If;
768: If (p_rec.epa_attribute16 = hr_api.g_varchar2) then
769: p_rec.epa_attribute16 :=
770: ben_epa_shd.g_old_rec.epa_attribute16;

Line 770: ben_epa_shd.g_old_rec.epa_attribute16;

766: ben_epa_shd.g_old_rec.epa_attribute15;
767: End If;
768: If (p_rec.epa_attribute16 = hr_api.g_varchar2) then
769: p_rec.epa_attribute16 :=
770: ben_epa_shd.g_old_rec.epa_attribute16;
771: End If;
772: If (p_rec.epa_attribute17 = hr_api.g_varchar2) then
773: p_rec.epa_attribute17 :=
774: ben_epa_shd.g_old_rec.epa_attribute17;

Line 774: ben_epa_shd.g_old_rec.epa_attribute17;

770: ben_epa_shd.g_old_rec.epa_attribute16;
771: End If;
772: If (p_rec.epa_attribute17 = hr_api.g_varchar2) then
773: p_rec.epa_attribute17 :=
774: ben_epa_shd.g_old_rec.epa_attribute17;
775: End If;
776: If (p_rec.epa_attribute18 = hr_api.g_varchar2) then
777: p_rec.epa_attribute18 :=
778: ben_epa_shd.g_old_rec.epa_attribute18;

Line 778: ben_epa_shd.g_old_rec.epa_attribute18;

774: ben_epa_shd.g_old_rec.epa_attribute17;
775: End If;
776: If (p_rec.epa_attribute18 = hr_api.g_varchar2) then
777: p_rec.epa_attribute18 :=
778: ben_epa_shd.g_old_rec.epa_attribute18;
779: End If;
780: If (p_rec.epa_attribute19 = hr_api.g_varchar2) then
781: p_rec.epa_attribute19 :=
782: ben_epa_shd.g_old_rec.epa_attribute19;

Line 782: ben_epa_shd.g_old_rec.epa_attribute19;

778: ben_epa_shd.g_old_rec.epa_attribute18;
779: End If;
780: If (p_rec.epa_attribute19 = hr_api.g_varchar2) then
781: p_rec.epa_attribute19 :=
782: ben_epa_shd.g_old_rec.epa_attribute19;
783: End If;
784: If (p_rec.epa_attribute20 = hr_api.g_varchar2) then
785: p_rec.epa_attribute20 :=
786: ben_epa_shd.g_old_rec.epa_attribute20;

Line 786: ben_epa_shd.g_old_rec.epa_attribute20;

782: ben_epa_shd.g_old_rec.epa_attribute19;
783: End If;
784: If (p_rec.epa_attribute20 = hr_api.g_varchar2) then
785: p_rec.epa_attribute20 :=
786: ben_epa_shd.g_old_rec.epa_attribute20;
787: End If;
788: If (p_rec.epa_attribute21 = hr_api.g_varchar2) then
789: p_rec.epa_attribute21 :=
790: ben_epa_shd.g_old_rec.epa_attribute21;

Line 790: ben_epa_shd.g_old_rec.epa_attribute21;

786: ben_epa_shd.g_old_rec.epa_attribute20;
787: End If;
788: If (p_rec.epa_attribute21 = hr_api.g_varchar2) then
789: p_rec.epa_attribute21 :=
790: ben_epa_shd.g_old_rec.epa_attribute21;
791: End If;
792: If (p_rec.epa_attribute22 = hr_api.g_varchar2) then
793: p_rec.epa_attribute22 :=
794: ben_epa_shd.g_old_rec.epa_attribute22;

Line 794: ben_epa_shd.g_old_rec.epa_attribute22;

790: ben_epa_shd.g_old_rec.epa_attribute21;
791: End If;
792: If (p_rec.epa_attribute22 = hr_api.g_varchar2) then
793: p_rec.epa_attribute22 :=
794: ben_epa_shd.g_old_rec.epa_attribute22;
795: End If;
796: If (p_rec.epa_attribute23 = hr_api.g_varchar2) then
797: p_rec.epa_attribute23 :=
798: ben_epa_shd.g_old_rec.epa_attribute23;

Line 798: ben_epa_shd.g_old_rec.epa_attribute23;

794: ben_epa_shd.g_old_rec.epa_attribute22;
795: End If;
796: If (p_rec.epa_attribute23 = hr_api.g_varchar2) then
797: p_rec.epa_attribute23 :=
798: ben_epa_shd.g_old_rec.epa_attribute23;
799: End If;
800: If (p_rec.epa_attribute24 = hr_api.g_varchar2) then
801: p_rec.epa_attribute24 :=
802: ben_epa_shd.g_old_rec.epa_attribute24;

Line 802: ben_epa_shd.g_old_rec.epa_attribute24;

798: ben_epa_shd.g_old_rec.epa_attribute23;
799: End If;
800: If (p_rec.epa_attribute24 = hr_api.g_varchar2) then
801: p_rec.epa_attribute24 :=
802: ben_epa_shd.g_old_rec.epa_attribute24;
803: End If;
804: If (p_rec.epa_attribute25 = hr_api.g_varchar2) then
805: p_rec.epa_attribute25 :=
806: ben_epa_shd.g_old_rec.epa_attribute25;

Line 806: ben_epa_shd.g_old_rec.epa_attribute25;

802: ben_epa_shd.g_old_rec.epa_attribute24;
803: End If;
804: If (p_rec.epa_attribute25 = hr_api.g_varchar2) then
805: p_rec.epa_attribute25 :=
806: ben_epa_shd.g_old_rec.epa_attribute25;
807: End If;
808: If (p_rec.epa_attribute26 = hr_api.g_varchar2) then
809: p_rec.epa_attribute26 :=
810: ben_epa_shd.g_old_rec.epa_attribute26;

Line 810: ben_epa_shd.g_old_rec.epa_attribute26;

806: ben_epa_shd.g_old_rec.epa_attribute25;
807: End If;
808: If (p_rec.epa_attribute26 = hr_api.g_varchar2) then
809: p_rec.epa_attribute26 :=
810: ben_epa_shd.g_old_rec.epa_attribute26;
811: End If;
812: If (p_rec.epa_attribute27 = hr_api.g_varchar2) then
813: p_rec.epa_attribute27 :=
814: ben_epa_shd.g_old_rec.epa_attribute27;

Line 814: ben_epa_shd.g_old_rec.epa_attribute27;

810: ben_epa_shd.g_old_rec.epa_attribute26;
811: End If;
812: If (p_rec.epa_attribute27 = hr_api.g_varchar2) then
813: p_rec.epa_attribute27 :=
814: ben_epa_shd.g_old_rec.epa_attribute27;
815: End If;
816: If (p_rec.epa_attribute28 = hr_api.g_varchar2) then
817: p_rec.epa_attribute28 :=
818: ben_epa_shd.g_old_rec.epa_attribute28;

Line 818: ben_epa_shd.g_old_rec.epa_attribute28;

814: ben_epa_shd.g_old_rec.epa_attribute27;
815: End If;
816: If (p_rec.epa_attribute28 = hr_api.g_varchar2) then
817: p_rec.epa_attribute28 :=
818: ben_epa_shd.g_old_rec.epa_attribute28;
819: End If;
820: If (p_rec.epa_attribute29 = hr_api.g_varchar2) then
821: p_rec.epa_attribute29 :=
822: ben_epa_shd.g_old_rec.epa_attribute29;

Line 822: ben_epa_shd.g_old_rec.epa_attribute29;

818: ben_epa_shd.g_old_rec.epa_attribute28;
819: End If;
820: If (p_rec.epa_attribute29 = hr_api.g_varchar2) then
821: p_rec.epa_attribute29 :=
822: ben_epa_shd.g_old_rec.epa_attribute29;
823: End If;
824: If (p_rec.epa_attribute30 = hr_api.g_varchar2) then
825: p_rec.epa_attribute30 :=
826: ben_epa_shd.g_old_rec.epa_attribute30;

Line 826: ben_epa_shd.g_old_rec.epa_attribute30;

822: ben_epa_shd.g_old_rec.epa_attribute29;
823: End If;
824: If (p_rec.epa_attribute30 = hr_api.g_varchar2) then
825: p_rec.epa_attribute30 :=
826: ben_epa_shd.g_old_rec.epa_attribute30;
827: End If;
828:
829: --
830: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 839: p_rec in out nocopy ben_epa_shd.g_rec_type,

835: -- |---------------------------------< upd >----------------------------------|
836: -- ----------------------------------------------------------------------------
837: Procedure upd
838: (
839: p_rec in out nocopy ben_epa_shd.g_rec_type,
840: p_effective_date in date,
841: p_datetrack_mode in varchar2
842: ) is
843: --

Line 857: ben_epa_shd.lck

853: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
854: --
855: -- We must lock the row which we need to update.
856: --
857: ben_epa_shd.lck
858: (p_effective_date => p_effective_date,
859: p_datetrack_mode => p_datetrack_mode,
860: p_prtn_elig_id => p_rec.prtn_elig_id,
861: p_object_version_number => p_rec.object_version_number,

Line 973: l_rec ben_epa_shd.g_rec_type;

969: p_effective_date in date,
970: p_datetrack_mode in varchar2
971: ) is
972: --
973: l_rec ben_epa_shd.g_rec_type;
974: l_proc varchar2(72) := g_package||'upd';
975: --
976: Begin
977: hr_utility.set_location('Entering:'||l_proc, 5);

Line 983: ben_epa_shd.convert_args

979: -- Call conversion function to turn arguments into the
980: -- l_rec structure.
981: --
982: l_rec :=
983: ben_epa_shd.convert_args
984: (
985: p_prtn_elig_id,
986: null,
987: null,