[Home] [Help]
50: -- Internal Row Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy ben_enp_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin
61: -- Increment the object version
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;
64: --
65: ben_enp_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the ben_enrt_perd Row
68: --
69: update ben_enrt_perd
146: reinstate_ovrdn_cd = p_rec.reinstate_ovrdn_cd,
147: defer_deenrol_flag = p_rec.defer_deenrol_flag
148: where enrt_perd_id = p_rec.enrt_perd_id;
149: --
150: ben_enp_shd.g_api_dml := false; -- Unset the api dml status
151: --
152: hr_utility.set_location(' Leaving:'||l_proc, 10);
153: --
154: Exception
153: --
154: Exception
155: When hr_api.check_integrity_violated Then
156: -- A check constraint has been violated
157: ben_enp_shd.g_api_dml := false; -- Unset the api dml status
158: ben_enp_shd.constraint_error
159: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
160: When hr_api.parent_integrity_violated Then
161: -- Parent integrity has been violated
154: Exception
155: When hr_api.check_integrity_violated Then
156: -- A check constraint has been violated
157: ben_enp_shd.g_api_dml := false; -- Unset the api dml status
158: ben_enp_shd.constraint_error
159: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
160: When hr_api.parent_integrity_violated Then
161: -- Parent integrity has been violated
162: ben_enp_shd.g_api_dml := false; -- Unset the api dml status
158: ben_enp_shd.constraint_error
159: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
160: When hr_api.parent_integrity_violated Then
161: -- Parent integrity has been violated
162: ben_enp_shd.g_api_dml := false; -- Unset the api dml status
163: ben_enp_shd.constraint_error
164: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
165: When hr_api.unique_integrity_violated Then
166: -- Unique integrity has been violated
159: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
160: When hr_api.parent_integrity_violated Then
161: -- Parent integrity has been violated
162: ben_enp_shd.g_api_dml := false; -- Unset the api dml status
163: ben_enp_shd.constraint_error
164: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
165: When hr_api.unique_integrity_violated Then
166: -- Unique integrity has been violated
167: ben_enp_shd.g_api_dml := false; -- Unset the api dml status
163: ben_enp_shd.constraint_error
164: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
165: When hr_api.unique_integrity_violated Then
166: -- Unique integrity has been violated
167: ben_enp_shd.g_api_dml := false; -- Unset the api dml status
168: ben_enp_shd.constraint_error
169: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
170: When Others Then
171: ben_enp_shd.g_api_dml := false; -- Unset the api dml status
164: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
165: When hr_api.unique_integrity_violated Then
166: -- Unique integrity has been violated
167: ben_enp_shd.g_api_dml := false; -- Unset the api dml status
168: ben_enp_shd.constraint_error
169: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
170: When Others Then
171: ben_enp_shd.g_api_dml := false; -- Unset the api dml status
172: Raise;
167: ben_enp_shd.g_api_dml := false; -- Unset the api dml status
168: ben_enp_shd.constraint_error
169: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
170: When Others Then
171: ben_enp_shd.g_api_dml := false; -- Unset the api dml status
172: Raise;
173: End update_dml;
174: --
175: -- ----------------------------------------------------------------------------
203: -- Internal Row Handler Use Only.
204: --
205: -- {End Of Comments}
206: -- ----------------------------------------------------------------------------
207: Procedure pre_update(p_rec in ben_enp_shd.g_rec_type) is
208: --
209: l_proc varchar2(72) := g_package||'pre_update';
210: --
211: Begin
246: --
247: -- {End Of Comments}
248: -- ----------------------------------------------------------------------------
249: Procedure post_update(
250: p_effective_date in date,p_rec in ben_enp_shd.g_rec_type) is
251: --
252: l_proc varchar2(72) := g_package||'post_update';
253: --
254: Begin
338: ,p_reinstate_cd => p_rec.reinstate_cd
339: ,p_reinstate_ovrdn_cd => p_rec.reinstate_ovrdn_cd
340: ,p_effective_date =>p_effective_date
341: ,p_defer_deenrol_flag => p_rec.defer_deenrol_flag
342: ,p_business_group_id_o =>ben_enp_shd.g_old_rec.business_group_id
343: ,p_yr_perd_id_o =>ben_enp_shd.g_old_rec.yr_perd_id
344: ,p_popl_enrt_typ_cycl_id_o =>ben_enp_shd.g_old_rec.popl_enrt_typ_cycl_id
345: ,p_end_dt_o =>ben_enp_shd.g_old_rec.end_dt
346: ,p_strt_dt_o =>ben_enp_shd.g_old_rec.strt_dt
339: ,p_reinstate_ovrdn_cd => p_rec.reinstate_ovrdn_cd
340: ,p_effective_date =>p_effective_date
341: ,p_defer_deenrol_flag => p_rec.defer_deenrol_flag
342: ,p_business_group_id_o =>ben_enp_shd.g_old_rec.business_group_id
343: ,p_yr_perd_id_o =>ben_enp_shd.g_old_rec.yr_perd_id
344: ,p_popl_enrt_typ_cycl_id_o =>ben_enp_shd.g_old_rec.popl_enrt_typ_cycl_id
345: ,p_end_dt_o =>ben_enp_shd.g_old_rec.end_dt
346: ,p_strt_dt_o =>ben_enp_shd.g_old_rec.strt_dt
347: ,p_asnd_lf_evt_dt_o =>ben_enp_shd.g_old_rec.asnd_lf_evt_dt
340: ,p_effective_date =>p_effective_date
341: ,p_defer_deenrol_flag => p_rec.defer_deenrol_flag
342: ,p_business_group_id_o =>ben_enp_shd.g_old_rec.business_group_id
343: ,p_yr_perd_id_o =>ben_enp_shd.g_old_rec.yr_perd_id
344: ,p_popl_enrt_typ_cycl_id_o =>ben_enp_shd.g_old_rec.popl_enrt_typ_cycl_id
345: ,p_end_dt_o =>ben_enp_shd.g_old_rec.end_dt
346: ,p_strt_dt_o =>ben_enp_shd.g_old_rec.strt_dt
347: ,p_asnd_lf_evt_dt_o =>ben_enp_shd.g_old_rec.asnd_lf_evt_dt
348: ,p_cls_enrt_dt_to_use_cd_o =>ben_enp_shd.g_old_rec.cls_enrt_dt_to_use_cd
341: ,p_defer_deenrol_flag => p_rec.defer_deenrol_flag
342: ,p_business_group_id_o =>ben_enp_shd.g_old_rec.business_group_id
343: ,p_yr_perd_id_o =>ben_enp_shd.g_old_rec.yr_perd_id
344: ,p_popl_enrt_typ_cycl_id_o =>ben_enp_shd.g_old_rec.popl_enrt_typ_cycl_id
345: ,p_end_dt_o =>ben_enp_shd.g_old_rec.end_dt
346: ,p_strt_dt_o =>ben_enp_shd.g_old_rec.strt_dt
347: ,p_asnd_lf_evt_dt_o =>ben_enp_shd.g_old_rec.asnd_lf_evt_dt
348: ,p_cls_enrt_dt_to_use_cd_o =>ben_enp_shd.g_old_rec.cls_enrt_dt_to_use_cd
349: ,p_dflt_enrt_dt_o =>ben_enp_shd.g_old_rec.dflt_enrt_dt
342: ,p_business_group_id_o =>ben_enp_shd.g_old_rec.business_group_id
343: ,p_yr_perd_id_o =>ben_enp_shd.g_old_rec.yr_perd_id
344: ,p_popl_enrt_typ_cycl_id_o =>ben_enp_shd.g_old_rec.popl_enrt_typ_cycl_id
345: ,p_end_dt_o =>ben_enp_shd.g_old_rec.end_dt
346: ,p_strt_dt_o =>ben_enp_shd.g_old_rec.strt_dt
347: ,p_asnd_lf_evt_dt_o =>ben_enp_shd.g_old_rec.asnd_lf_evt_dt
348: ,p_cls_enrt_dt_to_use_cd_o =>ben_enp_shd.g_old_rec.cls_enrt_dt_to_use_cd
349: ,p_dflt_enrt_dt_o =>ben_enp_shd.g_old_rec.dflt_enrt_dt
350: ,p_enrt_cvg_strt_dt_cd_o =>ben_enp_shd.g_old_rec.enrt_cvg_strt_dt_cd
343: ,p_yr_perd_id_o =>ben_enp_shd.g_old_rec.yr_perd_id
344: ,p_popl_enrt_typ_cycl_id_o =>ben_enp_shd.g_old_rec.popl_enrt_typ_cycl_id
345: ,p_end_dt_o =>ben_enp_shd.g_old_rec.end_dt
346: ,p_strt_dt_o =>ben_enp_shd.g_old_rec.strt_dt
347: ,p_asnd_lf_evt_dt_o =>ben_enp_shd.g_old_rec.asnd_lf_evt_dt
348: ,p_cls_enrt_dt_to_use_cd_o =>ben_enp_shd.g_old_rec.cls_enrt_dt_to_use_cd
349: ,p_dflt_enrt_dt_o =>ben_enp_shd.g_old_rec.dflt_enrt_dt
350: ,p_enrt_cvg_strt_dt_cd_o =>ben_enp_shd.g_old_rec.enrt_cvg_strt_dt_cd
351: ,p_rt_strt_dt_rl_o =>ben_enp_shd.g_old_rec.rt_strt_dt_rl
344: ,p_popl_enrt_typ_cycl_id_o =>ben_enp_shd.g_old_rec.popl_enrt_typ_cycl_id
345: ,p_end_dt_o =>ben_enp_shd.g_old_rec.end_dt
346: ,p_strt_dt_o =>ben_enp_shd.g_old_rec.strt_dt
347: ,p_asnd_lf_evt_dt_o =>ben_enp_shd.g_old_rec.asnd_lf_evt_dt
348: ,p_cls_enrt_dt_to_use_cd_o =>ben_enp_shd.g_old_rec.cls_enrt_dt_to_use_cd
349: ,p_dflt_enrt_dt_o =>ben_enp_shd.g_old_rec.dflt_enrt_dt
350: ,p_enrt_cvg_strt_dt_cd_o =>ben_enp_shd.g_old_rec.enrt_cvg_strt_dt_cd
351: ,p_rt_strt_dt_rl_o =>ben_enp_shd.g_old_rec.rt_strt_dt_rl
352: ,p_enrt_cvg_end_dt_cd_o =>ben_enp_shd.g_old_rec.enrt_cvg_end_dt_cd
345: ,p_end_dt_o =>ben_enp_shd.g_old_rec.end_dt
346: ,p_strt_dt_o =>ben_enp_shd.g_old_rec.strt_dt
347: ,p_asnd_lf_evt_dt_o =>ben_enp_shd.g_old_rec.asnd_lf_evt_dt
348: ,p_cls_enrt_dt_to_use_cd_o =>ben_enp_shd.g_old_rec.cls_enrt_dt_to_use_cd
349: ,p_dflt_enrt_dt_o =>ben_enp_shd.g_old_rec.dflt_enrt_dt
350: ,p_enrt_cvg_strt_dt_cd_o =>ben_enp_shd.g_old_rec.enrt_cvg_strt_dt_cd
351: ,p_rt_strt_dt_rl_o =>ben_enp_shd.g_old_rec.rt_strt_dt_rl
352: ,p_enrt_cvg_end_dt_cd_o =>ben_enp_shd.g_old_rec.enrt_cvg_end_dt_cd
353: ,p_enrt_cvg_strt_dt_rl_o =>ben_enp_shd.g_old_rec.enrt_cvg_strt_dt_rl
346: ,p_strt_dt_o =>ben_enp_shd.g_old_rec.strt_dt
347: ,p_asnd_lf_evt_dt_o =>ben_enp_shd.g_old_rec.asnd_lf_evt_dt
348: ,p_cls_enrt_dt_to_use_cd_o =>ben_enp_shd.g_old_rec.cls_enrt_dt_to_use_cd
349: ,p_dflt_enrt_dt_o =>ben_enp_shd.g_old_rec.dflt_enrt_dt
350: ,p_enrt_cvg_strt_dt_cd_o =>ben_enp_shd.g_old_rec.enrt_cvg_strt_dt_cd
351: ,p_rt_strt_dt_rl_o =>ben_enp_shd.g_old_rec.rt_strt_dt_rl
352: ,p_enrt_cvg_end_dt_cd_o =>ben_enp_shd.g_old_rec.enrt_cvg_end_dt_cd
353: ,p_enrt_cvg_strt_dt_rl_o =>ben_enp_shd.g_old_rec.enrt_cvg_strt_dt_rl
354: ,p_enrt_cvg_end_dt_rl_o =>ben_enp_shd.g_old_rec.enrt_cvg_end_dt_rl
347: ,p_asnd_lf_evt_dt_o =>ben_enp_shd.g_old_rec.asnd_lf_evt_dt
348: ,p_cls_enrt_dt_to_use_cd_o =>ben_enp_shd.g_old_rec.cls_enrt_dt_to_use_cd
349: ,p_dflt_enrt_dt_o =>ben_enp_shd.g_old_rec.dflt_enrt_dt
350: ,p_enrt_cvg_strt_dt_cd_o =>ben_enp_shd.g_old_rec.enrt_cvg_strt_dt_cd
351: ,p_rt_strt_dt_rl_o =>ben_enp_shd.g_old_rec.rt_strt_dt_rl
352: ,p_enrt_cvg_end_dt_cd_o =>ben_enp_shd.g_old_rec.enrt_cvg_end_dt_cd
353: ,p_enrt_cvg_strt_dt_rl_o =>ben_enp_shd.g_old_rec.enrt_cvg_strt_dt_rl
354: ,p_enrt_cvg_end_dt_rl_o =>ben_enp_shd.g_old_rec.enrt_cvg_end_dt_rl
355: ,p_procg_end_dt_o =>ben_enp_shd.g_old_rec.procg_end_dt
348: ,p_cls_enrt_dt_to_use_cd_o =>ben_enp_shd.g_old_rec.cls_enrt_dt_to_use_cd
349: ,p_dflt_enrt_dt_o =>ben_enp_shd.g_old_rec.dflt_enrt_dt
350: ,p_enrt_cvg_strt_dt_cd_o =>ben_enp_shd.g_old_rec.enrt_cvg_strt_dt_cd
351: ,p_rt_strt_dt_rl_o =>ben_enp_shd.g_old_rec.rt_strt_dt_rl
352: ,p_enrt_cvg_end_dt_cd_o =>ben_enp_shd.g_old_rec.enrt_cvg_end_dt_cd
353: ,p_enrt_cvg_strt_dt_rl_o =>ben_enp_shd.g_old_rec.enrt_cvg_strt_dt_rl
354: ,p_enrt_cvg_end_dt_rl_o =>ben_enp_shd.g_old_rec.enrt_cvg_end_dt_rl
355: ,p_procg_end_dt_o =>ben_enp_shd.g_old_rec.procg_end_dt
356: ,p_rt_strt_dt_cd_o =>ben_enp_shd.g_old_rec.rt_strt_dt_cd
349: ,p_dflt_enrt_dt_o =>ben_enp_shd.g_old_rec.dflt_enrt_dt
350: ,p_enrt_cvg_strt_dt_cd_o =>ben_enp_shd.g_old_rec.enrt_cvg_strt_dt_cd
351: ,p_rt_strt_dt_rl_o =>ben_enp_shd.g_old_rec.rt_strt_dt_rl
352: ,p_enrt_cvg_end_dt_cd_o =>ben_enp_shd.g_old_rec.enrt_cvg_end_dt_cd
353: ,p_enrt_cvg_strt_dt_rl_o =>ben_enp_shd.g_old_rec.enrt_cvg_strt_dt_rl
354: ,p_enrt_cvg_end_dt_rl_o =>ben_enp_shd.g_old_rec.enrt_cvg_end_dt_rl
355: ,p_procg_end_dt_o =>ben_enp_shd.g_old_rec.procg_end_dt
356: ,p_rt_strt_dt_cd_o =>ben_enp_shd.g_old_rec.rt_strt_dt_cd
357: ,p_rt_end_dt_cd_o =>ben_enp_shd.g_old_rec.rt_end_dt_cd
350: ,p_enrt_cvg_strt_dt_cd_o =>ben_enp_shd.g_old_rec.enrt_cvg_strt_dt_cd
351: ,p_rt_strt_dt_rl_o =>ben_enp_shd.g_old_rec.rt_strt_dt_rl
352: ,p_enrt_cvg_end_dt_cd_o =>ben_enp_shd.g_old_rec.enrt_cvg_end_dt_cd
353: ,p_enrt_cvg_strt_dt_rl_o =>ben_enp_shd.g_old_rec.enrt_cvg_strt_dt_rl
354: ,p_enrt_cvg_end_dt_rl_o =>ben_enp_shd.g_old_rec.enrt_cvg_end_dt_rl
355: ,p_procg_end_dt_o =>ben_enp_shd.g_old_rec.procg_end_dt
356: ,p_rt_strt_dt_cd_o =>ben_enp_shd.g_old_rec.rt_strt_dt_cd
357: ,p_rt_end_dt_cd_o =>ben_enp_shd.g_old_rec.rt_end_dt_cd
358: ,p_rt_end_dt_rl_o =>ben_enp_shd.g_old_rec.rt_end_dt_rl
351: ,p_rt_strt_dt_rl_o =>ben_enp_shd.g_old_rec.rt_strt_dt_rl
352: ,p_enrt_cvg_end_dt_cd_o =>ben_enp_shd.g_old_rec.enrt_cvg_end_dt_cd
353: ,p_enrt_cvg_strt_dt_rl_o =>ben_enp_shd.g_old_rec.enrt_cvg_strt_dt_rl
354: ,p_enrt_cvg_end_dt_rl_o =>ben_enp_shd.g_old_rec.enrt_cvg_end_dt_rl
355: ,p_procg_end_dt_o =>ben_enp_shd.g_old_rec.procg_end_dt
356: ,p_rt_strt_dt_cd_o =>ben_enp_shd.g_old_rec.rt_strt_dt_cd
357: ,p_rt_end_dt_cd_o =>ben_enp_shd.g_old_rec.rt_end_dt_cd
358: ,p_rt_end_dt_rl_o =>ben_enp_shd.g_old_rec.rt_end_dt_rl
359: ,p_bdgt_upd_strt_dt_o =>ben_enp_shd.g_old_rec.bdgt_upd_strt_dt
352: ,p_enrt_cvg_end_dt_cd_o =>ben_enp_shd.g_old_rec.enrt_cvg_end_dt_cd
353: ,p_enrt_cvg_strt_dt_rl_o =>ben_enp_shd.g_old_rec.enrt_cvg_strt_dt_rl
354: ,p_enrt_cvg_end_dt_rl_o =>ben_enp_shd.g_old_rec.enrt_cvg_end_dt_rl
355: ,p_procg_end_dt_o =>ben_enp_shd.g_old_rec.procg_end_dt
356: ,p_rt_strt_dt_cd_o =>ben_enp_shd.g_old_rec.rt_strt_dt_cd
357: ,p_rt_end_dt_cd_o =>ben_enp_shd.g_old_rec.rt_end_dt_cd
358: ,p_rt_end_dt_rl_o =>ben_enp_shd.g_old_rec.rt_end_dt_rl
359: ,p_bdgt_upd_strt_dt_o =>ben_enp_shd.g_old_rec.bdgt_upd_strt_dt
360: ,p_bdgt_upd_end_dt_o =>ben_enp_shd.g_old_rec.bdgt_upd_end_dt
353: ,p_enrt_cvg_strt_dt_rl_o =>ben_enp_shd.g_old_rec.enrt_cvg_strt_dt_rl
354: ,p_enrt_cvg_end_dt_rl_o =>ben_enp_shd.g_old_rec.enrt_cvg_end_dt_rl
355: ,p_procg_end_dt_o =>ben_enp_shd.g_old_rec.procg_end_dt
356: ,p_rt_strt_dt_cd_o =>ben_enp_shd.g_old_rec.rt_strt_dt_cd
357: ,p_rt_end_dt_cd_o =>ben_enp_shd.g_old_rec.rt_end_dt_cd
358: ,p_rt_end_dt_rl_o =>ben_enp_shd.g_old_rec.rt_end_dt_rl
359: ,p_bdgt_upd_strt_dt_o =>ben_enp_shd.g_old_rec.bdgt_upd_strt_dt
360: ,p_bdgt_upd_end_dt_o =>ben_enp_shd.g_old_rec.bdgt_upd_end_dt
361: ,p_ws_upd_strt_dt_o =>ben_enp_shd.g_old_rec.ws_upd_strt_dt
354: ,p_enrt_cvg_end_dt_rl_o =>ben_enp_shd.g_old_rec.enrt_cvg_end_dt_rl
355: ,p_procg_end_dt_o =>ben_enp_shd.g_old_rec.procg_end_dt
356: ,p_rt_strt_dt_cd_o =>ben_enp_shd.g_old_rec.rt_strt_dt_cd
357: ,p_rt_end_dt_cd_o =>ben_enp_shd.g_old_rec.rt_end_dt_cd
358: ,p_rt_end_dt_rl_o =>ben_enp_shd.g_old_rec.rt_end_dt_rl
359: ,p_bdgt_upd_strt_dt_o =>ben_enp_shd.g_old_rec.bdgt_upd_strt_dt
360: ,p_bdgt_upd_end_dt_o =>ben_enp_shd.g_old_rec.bdgt_upd_end_dt
361: ,p_ws_upd_strt_dt_o =>ben_enp_shd.g_old_rec.ws_upd_strt_dt
362: ,p_ws_upd_end_dt_o =>ben_enp_shd.g_old_rec.ws_upd_end_dt
355: ,p_procg_end_dt_o =>ben_enp_shd.g_old_rec.procg_end_dt
356: ,p_rt_strt_dt_cd_o =>ben_enp_shd.g_old_rec.rt_strt_dt_cd
357: ,p_rt_end_dt_cd_o =>ben_enp_shd.g_old_rec.rt_end_dt_cd
358: ,p_rt_end_dt_rl_o =>ben_enp_shd.g_old_rec.rt_end_dt_rl
359: ,p_bdgt_upd_strt_dt_o =>ben_enp_shd.g_old_rec.bdgt_upd_strt_dt
360: ,p_bdgt_upd_end_dt_o =>ben_enp_shd.g_old_rec.bdgt_upd_end_dt
361: ,p_ws_upd_strt_dt_o =>ben_enp_shd.g_old_rec.ws_upd_strt_dt
362: ,p_ws_upd_end_dt_o =>ben_enp_shd.g_old_rec.ws_upd_end_dt
363: ,p_dflt_ws_acc_cd_o =>ben_enp_shd.g_old_rec.dflt_ws_acc_cd
356: ,p_rt_strt_dt_cd_o =>ben_enp_shd.g_old_rec.rt_strt_dt_cd
357: ,p_rt_end_dt_cd_o =>ben_enp_shd.g_old_rec.rt_end_dt_cd
358: ,p_rt_end_dt_rl_o =>ben_enp_shd.g_old_rec.rt_end_dt_rl
359: ,p_bdgt_upd_strt_dt_o =>ben_enp_shd.g_old_rec.bdgt_upd_strt_dt
360: ,p_bdgt_upd_end_dt_o =>ben_enp_shd.g_old_rec.bdgt_upd_end_dt
361: ,p_ws_upd_strt_dt_o =>ben_enp_shd.g_old_rec.ws_upd_strt_dt
362: ,p_ws_upd_end_dt_o =>ben_enp_shd.g_old_rec.ws_upd_end_dt
363: ,p_dflt_ws_acc_cd_o =>ben_enp_shd.g_old_rec.dflt_ws_acc_cd
364: ,p_prsvr_bdgt_cd_o =>ben_enp_shd.g_old_rec.prsvr_bdgt_cd
357: ,p_rt_end_dt_cd_o =>ben_enp_shd.g_old_rec.rt_end_dt_cd
358: ,p_rt_end_dt_rl_o =>ben_enp_shd.g_old_rec.rt_end_dt_rl
359: ,p_bdgt_upd_strt_dt_o =>ben_enp_shd.g_old_rec.bdgt_upd_strt_dt
360: ,p_bdgt_upd_end_dt_o =>ben_enp_shd.g_old_rec.bdgt_upd_end_dt
361: ,p_ws_upd_strt_dt_o =>ben_enp_shd.g_old_rec.ws_upd_strt_dt
362: ,p_ws_upd_end_dt_o =>ben_enp_shd.g_old_rec.ws_upd_end_dt
363: ,p_dflt_ws_acc_cd_o =>ben_enp_shd.g_old_rec.dflt_ws_acc_cd
364: ,p_prsvr_bdgt_cd_o =>ben_enp_shd.g_old_rec.prsvr_bdgt_cd
365: ,p_uses_bdgt_flag_o =>ben_enp_shd.g_old_rec.uses_bdgt_flag
358: ,p_rt_end_dt_rl_o =>ben_enp_shd.g_old_rec.rt_end_dt_rl
359: ,p_bdgt_upd_strt_dt_o =>ben_enp_shd.g_old_rec.bdgt_upd_strt_dt
360: ,p_bdgt_upd_end_dt_o =>ben_enp_shd.g_old_rec.bdgt_upd_end_dt
361: ,p_ws_upd_strt_dt_o =>ben_enp_shd.g_old_rec.ws_upd_strt_dt
362: ,p_ws_upd_end_dt_o =>ben_enp_shd.g_old_rec.ws_upd_end_dt
363: ,p_dflt_ws_acc_cd_o =>ben_enp_shd.g_old_rec.dflt_ws_acc_cd
364: ,p_prsvr_bdgt_cd_o =>ben_enp_shd.g_old_rec.prsvr_bdgt_cd
365: ,p_uses_bdgt_flag_o =>ben_enp_shd.g_old_rec.uses_bdgt_flag
366: ,p_auto_distr_flag_o =>ben_enp_shd.g_old_rec.auto_distr_flag
359: ,p_bdgt_upd_strt_dt_o =>ben_enp_shd.g_old_rec.bdgt_upd_strt_dt
360: ,p_bdgt_upd_end_dt_o =>ben_enp_shd.g_old_rec.bdgt_upd_end_dt
361: ,p_ws_upd_strt_dt_o =>ben_enp_shd.g_old_rec.ws_upd_strt_dt
362: ,p_ws_upd_end_dt_o =>ben_enp_shd.g_old_rec.ws_upd_end_dt
363: ,p_dflt_ws_acc_cd_o =>ben_enp_shd.g_old_rec.dflt_ws_acc_cd
364: ,p_prsvr_bdgt_cd_o =>ben_enp_shd.g_old_rec.prsvr_bdgt_cd
365: ,p_uses_bdgt_flag_o =>ben_enp_shd.g_old_rec.uses_bdgt_flag
366: ,p_auto_distr_flag_o =>ben_enp_shd.g_old_rec.auto_distr_flag
367: ,p_hrchy_to_use_cd_o =>ben_enp_shd.g_old_rec.hrchy_to_use_cd
360: ,p_bdgt_upd_end_dt_o =>ben_enp_shd.g_old_rec.bdgt_upd_end_dt
361: ,p_ws_upd_strt_dt_o =>ben_enp_shd.g_old_rec.ws_upd_strt_dt
362: ,p_ws_upd_end_dt_o =>ben_enp_shd.g_old_rec.ws_upd_end_dt
363: ,p_dflt_ws_acc_cd_o =>ben_enp_shd.g_old_rec.dflt_ws_acc_cd
364: ,p_prsvr_bdgt_cd_o =>ben_enp_shd.g_old_rec.prsvr_bdgt_cd
365: ,p_uses_bdgt_flag_o =>ben_enp_shd.g_old_rec.uses_bdgt_flag
366: ,p_auto_distr_flag_o =>ben_enp_shd.g_old_rec.auto_distr_flag
367: ,p_hrchy_to_use_cd_o =>ben_enp_shd.g_old_rec.hrchy_to_use_cd
368: ,p_pos_structure_version_id_o =>ben_enp_shd.g_old_rec.pos_structure_version_id
361: ,p_ws_upd_strt_dt_o =>ben_enp_shd.g_old_rec.ws_upd_strt_dt
362: ,p_ws_upd_end_dt_o =>ben_enp_shd.g_old_rec.ws_upd_end_dt
363: ,p_dflt_ws_acc_cd_o =>ben_enp_shd.g_old_rec.dflt_ws_acc_cd
364: ,p_prsvr_bdgt_cd_o =>ben_enp_shd.g_old_rec.prsvr_bdgt_cd
365: ,p_uses_bdgt_flag_o =>ben_enp_shd.g_old_rec.uses_bdgt_flag
366: ,p_auto_distr_flag_o =>ben_enp_shd.g_old_rec.auto_distr_flag
367: ,p_hrchy_to_use_cd_o =>ben_enp_shd.g_old_rec.hrchy_to_use_cd
368: ,p_pos_structure_version_id_o =>ben_enp_shd.g_old_rec.pos_structure_version_id
369: ,p_emp_interview_type_cd_o =>ben_enp_shd.g_old_rec.emp_interview_type_cd
362: ,p_ws_upd_end_dt_o =>ben_enp_shd.g_old_rec.ws_upd_end_dt
363: ,p_dflt_ws_acc_cd_o =>ben_enp_shd.g_old_rec.dflt_ws_acc_cd
364: ,p_prsvr_bdgt_cd_o =>ben_enp_shd.g_old_rec.prsvr_bdgt_cd
365: ,p_uses_bdgt_flag_o =>ben_enp_shd.g_old_rec.uses_bdgt_flag
366: ,p_auto_distr_flag_o =>ben_enp_shd.g_old_rec.auto_distr_flag
367: ,p_hrchy_to_use_cd_o =>ben_enp_shd.g_old_rec.hrchy_to_use_cd
368: ,p_pos_structure_version_id_o =>ben_enp_shd.g_old_rec.pos_structure_version_id
369: ,p_emp_interview_type_cd_o =>ben_enp_shd.g_old_rec.emp_interview_type_cd
370: ,p_wthn_yr_perd_id_o =>ben_enp_shd.g_old_rec.wthn_yr_perd_id
363: ,p_dflt_ws_acc_cd_o =>ben_enp_shd.g_old_rec.dflt_ws_acc_cd
364: ,p_prsvr_bdgt_cd_o =>ben_enp_shd.g_old_rec.prsvr_bdgt_cd
365: ,p_uses_bdgt_flag_o =>ben_enp_shd.g_old_rec.uses_bdgt_flag
366: ,p_auto_distr_flag_o =>ben_enp_shd.g_old_rec.auto_distr_flag
367: ,p_hrchy_to_use_cd_o =>ben_enp_shd.g_old_rec.hrchy_to_use_cd
368: ,p_pos_structure_version_id_o =>ben_enp_shd.g_old_rec.pos_structure_version_id
369: ,p_emp_interview_type_cd_o =>ben_enp_shd.g_old_rec.emp_interview_type_cd
370: ,p_wthn_yr_perd_id_o =>ben_enp_shd.g_old_rec.wthn_yr_perd_id
371: ,p_ler_id_o =>ben_enp_shd.g_old_rec.ler_id
364: ,p_prsvr_bdgt_cd_o =>ben_enp_shd.g_old_rec.prsvr_bdgt_cd
365: ,p_uses_bdgt_flag_o =>ben_enp_shd.g_old_rec.uses_bdgt_flag
366: ,p_auto_distr_flag_o =>ben_enp_shd.g_old_rec.auto_distr_flag
367: ,p_hrchy_to_use_cd_o =>ben_enp_shd.g_old_rec.hrchy_to_use_cd
368: ,p_pos_structure_version_id_o =>ben_enp_shd.g_old_rec.pos_structure_version_id
369: ,p_emp_interview_type_cd_o =>ben_enp_shd.g_old_rec.emp_interview_type_cd
370: ,p_wthn_yr_perd_id_o =>ben_enp_shd.g_old_rec.wthn_yr_perd_id
371: ,p_ler_id_o =>ben_enp_shd.g_old_rec.ler_id
372: ,p_perf_revw_strt_dt_o =>ben_enp_shd.g_old_rec.perf_revw_strt_dt
365: ,p_uses_bdgt_flag_o =>ben_enp_shd.g_old_rec.uses_bdgt_flag
366: ,p_auto_distr_flag_o =>ben_enp_shd.g_old_rec.auto_distr_flag
367: ,p_hrchy_to_use_cd_o =>ben_enp_shd.g_old_rec.hrchy_to_use_cd
368: ,p_pos_structure_version_id_o =>ben_enp_shd.g_old_rec.pos_structure_version_id
369: ,p_emp_interview_type_cd_o =>ben_enp_shd.g_old_rec.emp_interview_type_cd
370: ,p_wthn_yr_perd_id_o =>ben_enp_shd.g_old_rec.wthn_yr_perd_id
371: ,p_ler_id_o =>ben_enp_shd.g_old_rec.ler_id
372: ,p_perf_revw_strt_dt_o =>ben_enp_shd.g_old_rec.perf_revw_strt_dt
373: ,p_asg_updt_eff_date_o =>ben_enp_shd.g_old_rec.asg_updt_eff_date
366: ,p_auto_distr_flag_o =>ben_enp_shd.g_old_rec.auto_distr_flag
367: ,p_hrchy_to_use_cd_o =>ben_enp_shd.g_old_rec.hrchy_to_use_cd
368: ,p_pos_structure_version_id_o =>ben_enp_shd.g_old_rec.pos_structure_version_id
369: ,p_emp_interview_type_cd_o =>ben_enp_shd.g_old_rec.emp_interview_type_cd
370: ,p_wthn_yr_perd_id_o =>ben_enp_shd.g_old_rec.wthn_yr_perd_id
371: ,p_ler_id_o =>ben_enp_shd.g_old_rec.ler_id
372: ,p_perf_revw_strt_dt_o =>ben_enp_shd.g_old_rec.perf_revw_strt_dt
373: ,p_asg_updt_eff_date_o =>ben_enp_shd.g_old_rec.asg_updt_eff_date
374: ,p_enp_attribute_category_o =>ben_enp_shd.g_old_rec.enp_attribute_category
367: ,p_hrchy_to_use_cd_o =>ben_enp_shd.g_old_rec.hrchy_to_use_cd
368: ,p_pos_structure_version_id_o =>ben_enp_shd.g_old_rec.pos_structure_version_id
369: ,p_emp_interview_type_cd_o =>ben_enp_shd.g_old_rec.emp_interview_type_cd
370: ,p_wthn_yr_perd_id_o =>ben_enp_shd.g_old_rec.wthn_yr_perd_id
371: ,p_ler_id_o =>ben_enp_shd.g_old_rec.ler_id
372: ,p_perf_revw_strt_dt_o =>ben_enp_shd.g_old_rec.perf_revw_strt_dt
373: ,p_asg_updt_eff_date_o =>ben_enp_shd.g_old_rec.asg_updt_eff_date
374: ,p_enp_attribute_category_o =>ben_enp_shd.g_old_rec.enp_attribute_category
375: ,p_enp_attribute1_o =>ben_enp_shd.g_old_rec.enp_attribute1
368: ,p_pos_structure_version_id_o =>ben_enp_shd.g_old_rec.pos_structure_version_id
369: ,p_emp_interview_type_cd_o =>ben_enp_shd.g_old_rec.emp_interview_type_cd
370: ,p_wthn_yr_perd_id_o =>ben_enp_shd.g_old_rec.wthn_yr_perd_id
371: ,p_ler_id_o =>ben_enp_shd.g_old_rec.ler_id
372: ,p_perf_revw_strt_dt_o =>ben_enp_shd.g_old_rec.perf_revw_strt_dt
373: ,p_asg_updt_eff_date_o =>ben_enp_shd.g_old_rec.asg_updt_eff_date
374: ,p_enp_attribute_category_o =>ben_enp_shd.g_old_rec.enp_attribute_category
375: ,p_enp_attribute1_o =>ben_enp_shd.g_old_rec.enp_attribute1
376: ,p_enp_attribute2_o =>ben_enp_shd.g_old_rec.enp_attribute2
369: ,p_emp_interview_type_cd_o =>ben_enp_shd.g_old_rec.emp_interview_type_cd
370: ,p_wthn_yr_perd_id_o =>ben_enp_shd.g_old_rec.wthn_yr_perd_id
371: ,p_ler_id_o =>ben_enp_shd.g_old_rec.ler_id
372: ,p_perf_revw_strt_dt_o =>ben_enp_shd.g_old_rec.perf_revw_strt_dt
373: ,p_asg_updt_eff_date_o =>ben_enp_shd.g_old_rec.asg_updt_eff_date
374: ,p_enp_attribute_category_o =>ben_enp_shd.g_old_rec.enp_attribute_category
375: ,p_enp_attribute1_o =>ben_enp_shd.g_old_rec.enp_attribute1
376: ,p_enp_attribute2_o =>ben_enp_shd.g_old_rec.enp_attribute2
377: ,p_enp_attribute3_o =>ben_enp_shd.g_old_rec.enp_attribute3
370: ,p_wthn_yr_perd_id_o =>ben_enp_shd.g_old_rec.wthn_yr_perd_id
371: ,p_ler_id_o =>ben_enp_shd.g_old_rec.ler_id
372: ,p_perf_revw_strt_dt_o =>ben_enp_shd.g_old_rec.perf_revw_strt_dt
373: ,p_asg_updt_eff_date_o =>ben_enp_shd.g_old_rec.asg_updt_eff_date
374: ,p_enp_attribute_category_o =>ben_enp_shd.g_old_rec.enp_attribute_category
375: ,p_enp_attribute1_o =>ben_enp_shd.g_old_rec.enp_attribute1
376: ,p_enp_attribute2_o =>ben_enp_shd.g_old_rec.enp_attribute2
377: ,p_enp_attribute3_o =>ben_enp_shd.g_old_rec.enp_attribute3
378: ,p_enp_attribute4_o =>ben_enp_shd.g_old_rec.enp_attribute4
371: ,p_ler_id_o =>ben_enp_shd.g_old_rec.ler_id
372: ,p_perf_revw_strt_dt_o =>ben_enp_shd.g_old_rec.perf_revw_strt_dt
373: ,p_asg_updt_eff_date_o =>ben_enp_shd.g_old_rec.asg_updt_eff_date
374: ,p_enp_attribute_category_o =>ben_enp_shd.g_old_rec.enp_attribute_category
375: ,p_enp_attribute1_o =>ben_enp_shd.g_old_rec.enp_attribute1
376: ,p_enp_attribute2_o =>ben_enp_shd.g_old_rec.enp_attribute2
377: ,p_enp_attribute3_o =>ben_enp_shd.g_old_rec.enp_attribute3
378: ,p_enp_attribute4_o =>ben_enp_shd.g_old_rec.enp_attribute4
379: ,p_enp_attribute5_o =>ben_enp_shd.g_old_rec.enp_attribute5
372: ,p_perf_revw_strt_dt_o =>ben_enp_shd.g_old_rec.perf_revw_strt_dt
373: ,p_asg_updt_eff_date_o =>ben_enp_shd.g_old_rec.asg_updt_eff_date
374: ,p_enp_attribute_category_o =>ben_enp_shd.g_old_rec.enp_attribute_category
375: ,p_enp_attribute1_o =>ben_enp_shd.g_old_rec.enp_attribute1
376: ,p_enp_attribute2_o =>ben_enp_shd.g_old_rec.enp_attribute2
377: ,p_enp_attribute3_o =>ben_enp_shd.g_old_rec.enp_attribute3
378: ,p_enp_attribute4_o =>ben_enp_shd.g_old_rec.enp_attribute4
379: ,p_enp_attribute5_o =>ben_enp_shd.g_old_rec.enp_attribute5
380: ,p_enp_attribute6_o =>ben_enp_shd.g_old_rec.enp_attribute6
373: ,p_asg_updt_eff_date_o =>ben_enp_shd.g_old_rec.asg_updt_eff_date
374: ,p_enp_attribute_category_o =>ben_enp_shd.g_old_rec.enp_attribute_category
375: ,p_enp_attribute1_o =>ben_enp_shd.g_old_rec.enp_attribute1
376: ,p_enp_attribute2_o =>ben_enp_shd.g_old_rec.enp_attribute2
377: ,p_enp_attribute3_o =>ben_enp_shd.g_old_rec.enp_attribute3
378: ,p_enp_attribute4_o =>ben_enp_shd.g_old_rec.enp_attribute4
379: ,p_enp_attribute5_o =>ben_enp_shd.g_old_rec.enp_attribute5
380: ,p_enp_attribute6_o =>ben_enp_shd.g_old_rec.enp_attribute6
381: ,p_enp_attribute7_o =>ben_enp_shd.g_old_rec.enp_attribute7
374: ,p_enp_attribute_category_o =>ben_enp_shd.g_old_rec.enp_attribute_category
375: ,p_enp_attribute1_o =>ben_enp_shd.g_old_rec.enp_attribute1
376: ,p_enp_attribute2_o =>ben_enp_shd.g_old_rec.enp_attribute2
377: ,p_enp_attribute3_o =>ben_enp_shd.g_old_rec.enp_attribute3
378: ,p_enp_attribute4_o =>ben_enp_shd.g_old_rec.enp_attribute4
379: ,p_enp_attribute5_o =>ben_enp_shd.g_old_rec.enp_attribute5
380: ,p_enp_attribute6_o =>ben_enp_shd.g_old_rec.enp_attribute6
381: ,p_enp_attribute7_o =>ben_enp_shd.g_old_rec.enp_attribute7
382: ,p_enp_attribute8_o =>ben_enp_shd.g_old_rec.enp_attribute8
375: ,p_enp_attribute1_o =>ben_enp_shd.g_old_rec.enp_attribute1
376: ,p_enp_attribute2_o =>ben_enp_shd.g_old_rec.enp_attribute2
377: ,p_enp_attribute3_o =>ben_enp_shd.g_old_rec.enp_attribute3
378: ,p_enp_attribute4_o =>ben_enp_shd.g_old_rec.enp_attribute4
379: ,p_enp_attribute5_o =>ben_enp_shd.g_old_rec.enp_attribute5
380: ,p_enp_attribute6_o =>ben_enp_shd.g_old_rec.enp_attribute6
381: ,p_enp_attribute7_o =>ben_enp_shd.g_old_rec.enp_attribute7
382: ,p_enp_attribute8_o =>ben_enp_shd.g_old_rec.enp_attribute8
383: ,p_enp_attribute9_o =>ben_enp_shd.g_old_rec.enp_attribute9
376: ,p_enp_attribute2_o =>ben_enp_shd.g_old_rec.enp_attribute2
377: ,p_enp_attribute3_o =>ben_enp_shd.g_old_rec.enp_attribute3
378: ,p_enp_attribute4_o =>ben_enp_shd.g_old_rec.enp_attribute4
379: ,p_enp_attribute5_o =>ben_enp_shd.g_old_rec.enp_attribute5
380: ,p_enp_attribute6_o =>ben_enp_shd.g_old_rec.enp_attribute6
381: ,p_enp_attribute7_o =>ben_enp_shd.g_old_rec.enp_attribute7
382: ,p_enp_attribute8_o =>ben_enp_shd.g_old_rec.enp_attribute8
383: ,p_enp_attribute9_o =>ben_enp_shd.g_old_rec.enp_attribute9
384: ,p_enp_attribute10_o =>ben_enp_shd.g_old_rec.enp_attribute10
377: ,p_enp_attribute3_o =>ben_enp_shd.g_old_rec.enp_attribute3
378: ,p_enp_attribute4_o =>ben_enp_shd.g_old_rec.enp_attribute4
379: ,p_enp_attribute5_o =>ben_enp_shd.g_old_rec.enp_attribute5
380: ,p_enp_attribute6_o =>ben_enp_shd.g_old_rec.enp_attribute6
381: ,p_enp_attribute7_o =>ben_enp_shd.g_old_rec.enp_attribute7
382: ,p_enp_attribute8_o =>ben_enp_shd.g_old_rec.enp_attribute8
383: ,p_enp_attribute9_o =>ben_enp_shd.g_old_rec.enp_attribute9
384: ,p_enp_attribute10_o =>ben_enp_shd.g_old_rec.enp_attribute10
385: ,p_enp_attribute11_o =>ben_enp_shd.g_old_rec.enp_attribute11
378: ,p_enp_attribute4_o =>ben_enp_shd.g_old_rec.enp_attribute4
379: ,p_enp_attribute5_o =>ben_enp_shd.g_old_rec.enp_attribute5
380: ,p_enp_attribute6_o =>ben_enp_shd.g_old_rec.enp_attribute6
381: ,p_enp_attribute7_o =>ben_enp_shd.g_old_rec.enp_attribute7
382: ,p_enp_attribute8_o =>ben_enp_shd.g_old_rec.enp_attribute8
383: ,p_enp_attribute9_o =>ben_enp_shd.g_old_rec.enp_attribute9
384: ,p_enp_attribute10_o =>ben_enp_shd.g_old_rec.enp_attribute10
385: ,p_enp_attribute11_o =>ben_enp_shd.g_old_rec.enp_attribute11
386: ,p_enp_attribute12_o =>ben_enp_shd.g_old_rec.enp_attribute12
379: ,p_enp_attribute5_o =>ben_enp_shd.g_old_rec.enp_attribute5
380: ,p_enp_attribute6_o =>ben_enp_shd.g_old_rec.enp_attribute6
381: ,p_enp_attribute7_o =>ben_enp_shd.g_old_rec.enp_attribute7
382: ,p_enp_attribute8_o =>ben_enp_shd.g_old_rec.enp_attribute8
383: ,p_enp_attribute9_o =>ben_enp_shd.g_old_rec.enp_attribute9
384: ,p_enp_attribute10_o =>ben_enp_shd.g_old_rec.enp_attribute10
385: ,p_enp_attribute11_o =>ben_enp_shd.g_old_rec.enp_attribute11
386: ,p_enp_attribute12_o =>ben_enp_shd.g_old_rec.enp_attribute12
387: ,p_enp_attribute13_o =>ben_enp_shd.g_old_rec.enp_attribute13
380: ,p_enp_attribute6_o =>ben_enp_shd.g_old_rec.enp_attribute6
381: ,p_enp_attribute7_o =>ben_enp_shd.g_old_rec.enp_attribute7
382: ,p_enp_attribute8_o =>ben_enp_shd.g_old_rec.enp_attribute8
383: ,p_enp_attribute9_o =>ben_enp_shd.g_old_rec.enp_attribute9
384: ,p_enp_attribute10_o =>ben_enp_shd.g_old_rec.enp_attribute10
385: ,p_enp_attribute11_o =>ben_enp_shd.g_old_rec.enp_attribute11
386: ,p_enp_attribute12_o =>ben_enp_shd.g_old_rec.enp_attribute12
387: ,p_enp_attribute13_o =>ben_enp_shd.g_old_rec.enp_attribute13
388: ,p_enp_attribute14_o =>ben_enp_shd.g_old_rec.enp_attribute14
381: ,p_enp_attribute7_o =>ben_enp_shd.g_old_rec.enp_attribute7
382: ,p_enp_attribute8_o =>ben_enp_shd.g_old_rec.enp_attribute8
383: ,p_enp_attribute9_o =>ben_enp_shd.g_old_rec.enp_attribute9
384: ,p_enp_attribute10_o =>ben_enp_shd.g_old_rec.enp_attribute10
385: ,p_enp_attribute11_o =>ben_enp_shd.g_old_rec.enp_attribute11
386: ,p_enp_attribute12_o =>ben_enp_shd.g_old_rec.enp_attribute12
387: ,p_enp_attribute13_o =>ben_enp_shd.g_old_rec.enp_attribute13
388: ,p_enp_attribute14_o =>ben_enp_shd.g_old_rec.enp_attribute14
389: ,p_enp_attribute15_o =>ben_enp_shd.g_old_rec.enp_attribute15
382: ,p_enp_attribute8_o =>ben_enp_shd.g_old_rec.enp_attribute8
383: ,p_enp_attribute9_o =>ben_enp_shd.g_old_rec.enp_attribute9
384: ,p_enp_attribute10_o =>ben_enp_shd.g_old_rec.enp_attribute10
385: ,p_enp_attribute11_o =>ben_enp_shd.g_old_rec.enp_attribute11
386: ,p_enp_attribute12_o =>ben_enp_shd.g_old_rec.enp_attribute12
387: ,p_enp_attribute13_o =>ben_enp_shd.g_old_rec.enp_attribute13
388: ,p_enp_attribute14_o =>ben_enp_shd.g_old_rec.enp_attribute14
389: ,p_enp_attribute15_o =>ben_enp_shd.g_old_rec.enp_attribute15
390: ,p_enp_attribute16_o =>ben_enp_shd.g_old_rec.enp_attribute16
383: ,p_enp_attribute9_o =>ben_enp_shd.g_old_rec.enp_attribute9
384: ,p_enp_attribute10_o =>ben_enp_shd.g_old_rec.enp_attribute10
385: ,p_enp_attribute11_o =>ben_enp_shd.g_old_rec.enp_attribute11
386: ,p_enp_attribute12_o =>ben_enp_shd.g_old_rec.enp_attribute12
387: ,p_enp_attribute13_o =>ben_enp_shd.g_old_rec.enp_attribute13
388: ,p_enp_attribute14_o =>ben_enp_shd.g_old_rec.enp_attribute14
389: ,p_enp_attribute15_o =>ben_enp_shd.g_old_rec.enp_attribute15
390: ,p_enp_attribute16_o =>ben_enp_shd.g_old_rec.enp_attribute16
391: ,p_enp_attribute17_o =>ben_enp_shd.g_old_rec.enp_attribute17
384: ,p_enp_attribute10_o =>ben_enp_shd.g_old_rec.enp_attribute10
385: ,p_enp_attribute11_o =>ben_enp_shd.g_old_rec.enp_attribute11
386: ,p_enp_attribute12_o =>ben_enp_shd.g_old_rec.enp_attribute12
387: ,p_enp_attribute13_o =>ben_enp_shd.g_old_rec.enp_attribute13
388: ,p_enp_attribute14_o =>ben_enp_shd.g_old_rec.enp_attribute14
389: ,p_enp_attribute15_o =>ben_enp_shd.g_old_rec.enp_attribute15
390: ,p_enp_attribute16_o =>ben_enp_shd.g_old_rec.enp_attribute16
391: ,p_enp_attribute17_o =>ben_enp_shd.g_old_rec.enp_attribute17
392: ,p_enp_attribute18_o =>ben_enp_shd.g_old_rec.enp_attribute18
385: ,p_enp_attribute11_o =>ben_enp_shd.g_old_rec.enp_attribute11
386: ,p_enp_attribute12_o =>ben_enp_shd.g_old_rec.enp_attribute12
387: ,p_enp_attribute13_o =>ben_enp_shd.g_old_rec.enp_attribute13
388: ,p_enp_attribute14_o =>ben_enp_shd.g_old_rec.enp_attribute14
389: ,p_enp_attribute15_o =>ben_enp_shd.g_old_rec.enp_attribute15
390: ,p_enp_attribute16_o =>ben_enp_shd.g_old_rec.enp_attribute16
391: ,p_enp_attribute17_o =>ben_enp_shd.g_old_rec.enp_attribute17
392: ,p_enp_attribute18_o =>ben_enp_shd.g_old_rec.enp_attribute18
393: ,p_enp_attribute19_o =>ben_enp_shd.g_old_rec.enp_attribute19
386: ,p_enp_attribute12_o =>ben_enp_shd.g_old_rec.enp_attribute12
387: ,p_enp_attribute13_o =>ben_enp_shd.g_old_rec.enp_attribute13
388: ,p_enp_attribute14_o =>ben_enp_shd.g_old_rec.enp_attribute14
389: ,p_enp_attribute15_o =>ben_enp_shd.g_old_rec.enp_attribute15
390: ,p_enp_attribute16_o =>ben_enp_shd.g_old_rec.enp_attribute16
391: ,p_enp_attribute17_o =>ben_enp_shd.g_old_rec.enp_attribute17
392: ,p_enp_attribute18_o =>ben_enp_shd.g_old_rec.enp_attribute18
393: ,p_enp_attribute19_o =>ben_enp_shd.g_old_rec.enp_attribute19
394: ,p_enp_attribute20_o =>ben_enp_shd.g_old_rec.enp_attribute20
387: ,p_enp_attribute13_o =>ben_enp_shd.g_old_rec.enp_attribute13
388: ,p_enp_attribute14_o =>ben_enp_shd.g_old_rec.enp_attribute14
389: ,p_enp_attribute15_o =>ben_enp_shd.g_old_rec.enp_attribute15
390: ,p_enp_attribute16_o =>ben_enp_shd.g_old_rec.enp_attribute16
391: ,p_enp_attribute17_o =>ben_enp_shd.g_old_rec.enp_attribute17
392: ,p_enp_attribute18_o =>ben_enp_shd.g_old_rec.enp_attribute18
393: ,p_enp_attribute19_o =>ben_enp_shd.g_old_rec.enp_attribute19
394: ,p_enp_attribute20_o =>ben_enp_shd.g_old_rec.enp_attribute20
395: ,p_enp_attribute21_o =>ben_enp_shd.g_old_rec.enp_attribute21
388: ,p_enp_attribute14_o =>ben_enp_shd.g_old_rec.enp_attribute14
389: ,p_enp_attribute15_o =>ben_enp_shd.g_old_rec.enp_attribute15
390: ,p_enp_attribute16_o =>ben_enp_shd.g_old_rec.enp_attribute16
391: ,p_enp_attribute17_o =>ben_enp_shd.g_old_rec.enp_attribute17
392: ,p_enp_attribute18_o =>ben_enp_shd.g_old_rec.enp_attribute18
393: ,p_enp_attribute19_o =>ben_enp_shd.g_old_rec.enp_attribute19
394: ,p_enp_attribute20_o =>ben_enp_shd.g_old_rec.enp_attribute20
395: ,p_enp_attribute21_o =>ben_enp_shd.g_old_rec.enp_attribute21
396: ,p_enp_attribute22_o =>ben_enp_shd.g_old_rec.enp_attribute22
389: ,p_enp_attribute15_o =>ben_enp_shd.g_old_rec.enp_attribute15
390: ,p_enp_attribute16_o =>ben_enp_shd.g_old_rec.enp_attribute16
391: ,p_enp_attribute17_o =>ben_enp_shd.g_old_rec.enp_attribute17
392: ,p_enp_attribute18_o =>ben_enp_shd.g_old_rec.enp_attribute18
393: ,p_enp_attribute19_o =>ben_enp_shd.g_old_rec.enp_attribute19
394: ,p_enp_attribute20_o =>ben_enp_shd.g_old_rec.enp_attribute20
395: ,p_enp_attribute21_o =>ben_enp_shd.g_old_rec.enp_attribute21
396: ,p_enp_attribute22_o =>ben_enp_shd.g_old_rec.enp_attribute22
397: ,p_enp_attribute23_o =>ben_enp_shd.g_old_rec.enp_attribute23
390: ,p_enp_attribute16_o =>ben_enp_shd.g_old_rec.enp_attribute16
391: ,p_enp_attribute17_o =>ben_enp_shd.g_old_rec.enp_attribute17
392: ,p_enp_attribute18_o =>ben_enp_shd.g_old_rec.enp_attribute18
393: ,p_enp_attribute19_o =>ben_enp_shd.g_old_rec.enp_attribute19
394: ,p_enp_attribute20_o =>ben_enp_shd.g_old_rec.enp_attribute20
395: ,p_enp_attribute21_o =>ben_enp_shd.g_old_rec.enp_attribute21
396: ,p_enp_attribute22_o =>ben_enp_shd.g_old_rec.enp_attribute22
397: ,p_enp_attribute23_o =>ben_enp_shd.g_old_rec.enp_attribute23
398: ,p_enp_attribute24_o =>ben_enp_shd.g_old_rec.enp_attribute24
391: ,p_enp_attribute17_o =>ben_enp_shd.g_old_rec.enp_attribute17
392: ,p_enp_attribute18_o =>ben_enp_shd.g_old_rec.enp_attribute18
393: ,p_enp_attribute19_o =>ben_enp_shd.g_old_rec.enp_attribute19
394: ,p_enp_attribute20_o =>ben_enp_shd.g_old_rec.enp_attribute20
395: ,p_enp_attribute21_o =>ben_enp_shd.g_old_rec.enp_attribute21
396: ,p_enp_attribute22_o =>ben_enp_shd.g_old_rec.enp_attribute22
397: ,p_enp_attribute23_o =>ben_enp_shd.g_old_rec.enp_attribute23
398: ,p_enp_attribute24_o =>ben_enp_shd.g_old_rec.enp_attribute24
399: ,p_enp_attribute25_o =>ben_enp_shd.g_old_rec.enp_attribute25
392: ,p_enp_attribute18_o =>ben_enp_shd.g_old_rec.enp_attribute18
393: ,p_enp_attribute19_o =>ben_enp_shd.g_old_rec.enp_attribute19
394: ,p_enp_attribute20_o =>ben_enp_shd.g_old_rec.enp_attribute20
395: ,p_enp_attribute21_o =>ben_enp_shd.g_old_rec.enp_attribute21
396: ,p_enp_attribute22_o =>ben_enp_shd.g_old_rec.enp_attribute22
397: ,p_enp_attribute23_o =>ben_enp_shd.g_old_rec.enp_attribute23
398: ,p_enp_attribute24_o =>ben_enp_shd.g_old_rec.enp_attribute24
399: ,p_enp_attribute25_o =>ben_enp_shd.g_old_rec.enp_attribute25
400: ,p_enp_attribute26_o =>ben_enp_shd.g_old_rec.enp_attribute26
393: ,p_enp_attribute19_o =>ben_enp_shd.g_old_rec.enp_attribute19
394: ,p_enp_attribute20_o =>ben_enp_shd.g_old_rec.enp_attribute20
395: ,p_enp_attribute21_o =>ben_enp_shd.g_old_rec.enp_attribute21
396: ,p_enp_attribute22_o =>ben_enp_shd.g_old_rec.enp_attribute22
397: ,p_enp_attribute23_o =>ben_enp_shd.g_old_rec.enp_attribute23
398: ,p_enp_attribute24_o =>ben_enp_shd.g_old_rec.enp_attribute24
399: ,p_enp_attribute25_o =>ben_enp_shd.g_old_rec.enp_attribute25
400: ,p_enp_attribute26_o =>ben_enp_shd.g_old_rec.enp_attribute26
401: ,p_enp_attribute27_o =>ben_enp_shd.g_old_rec.enp_attribute27
394: ,p_enp_attribute20_o =>ben_enp_shd.g_old_rec.enp_attribute20
395: ,p_enp_attribute21_o =>ben_enp_shd.g_old_rec.enp_attribute21
396: ,p_enp_attribute22_o =>ben_enp_shd.g_old_rec.enp_attribute22
397: ,p_enp_attribute23_o =>ben_enp_shd.g_old_rec.enp_attribute23
398: ,p_enp_attribute24_o =>ben_enp_shd.g_old_rec.enp_attribute24
399: ,p_enp_attribute25_o =>ben_enp_shd.g_old_rec.enp_attribute25
400: ,p_enp_attribute26_o =>ben_enp_shd.g_old_rec.enp_attribute26
401: ,p_enp_attribute27_o =>ben_enp_shd.g_old_rec.enp_attribute27
402: ,p_enp_attribute28_o =>ben_enp_shd.g_old_rec.enp_attribute28
395: ,p_enp_attribute21_o =>ben_enp_shd.g_old_rec.enp_attribute21
396: ,p_enp_attribute22_o =>ben_enp_shd.g_old_rec.enp_attribute22
397: ,p_enp_attribute23_o =>ben_enp_shd.g_old_rec.enp_attribute23
398: ,p_enp_attribute24_o =>ben_enp_shd.g_old_rec.enp_attribute24
399: ,p_enp_attribute25_o =>ben_enp_shd.g_old_rec.enp_attribute25
400: ,p_enp_attribute26_o =>ben_enp_shd.g_old_rec.enp_attribute26
401: ,p_enp_attribute27_o =>ben_enp_shd.g_old_rec.enp_attribute27
402: ,p_enp_attribute28_o =>ben_enp_shd.g_old_rec.enp_attribute28
403: ,p_enp_attribute29_o =>ben_enp_shd.g_old_rec.enp_attribute29
396: ,p_enp_attribute22_o =>ben_enp_shd.g_old_rec.enp_attribute22
397: ,p_enp_attribute23_o =>ben_enp_shd.g_old_rec.enp_attribute23
398: ,p_enp_attribute24_o =>ben_enp_shd.g_old_rec.enp_attribute24
399: ,p_enp_attribute25_o =>ben_enp_shd.g_old_rec.enp_attribute25
400: ,p_enp_attribute26_o =>ben_enp_shd.g_old_rec.enp_attribute26
401: ,p_enp_attribute27_o =>ben_enp_shd.g_old_rec.enp_attribute27
402: ,p_enp_attribute28_o =>ben_enp_shd.g_old_rec.enp_attribute28
403: ,p_enp_attribute29_o =>ben_enp_shd.g_old_rec.enp_attribute29
404: ,p_enp_attribute30_o =>ben_enp_shd.g_old_rec.enp_attribute30
397: ,p_enp_attribute23_o =>ben_enp_shd.g_old_rec.enp_attribute23
398: ,p_enp_attribute24_o =>ben_enp_shd.g_old_rec.enp_attribute24
399: ,p_enp_attribute25_o =>ben_enp_shd.g_old_rec.enp_attribute25
400: ,p_enp_attribute26_o =>ben_enp_shd.g_old_rec.enp_attribute26
401: ,p_enp_attribute27_o =>ben_enp_shd.g_old_rec.enp_attribute27
402: ,p_enp_attribute28_o =>ben_enp_shd.g_old_rec.enp_attribute28
403: ,p_enp_attribute29_o =>ben_enp_shd.g_old_rec.enp_attribute29
404: ,p_enp_attribute30_o =>ben_enp_shd.g_old_rec.enp_attribute30
405: --,p_enrt_perd_det_ovrlp_bckdt_cd_o =>ben_enp_shd.g_old_rec.enrt_perd_det_ovrlp_bckdt_cd
398: ,p_enp_attribute24_o =>ben_enp_shd.g_old_rec.enp_attribute24
399: ,p_enp_attribute25_o =>ben_enp_shd.g_old_rec.enp_attribute25
400: ,p_enp_attribute26_o =>ben_enp_shd.g_old_rec.enp_attribute26
401: ,p_enp_attribute27_o =>ben_enp_shd.g_old_rec.enp_attribute27
402: ,p_enp_attribute28_o =>ben_enp_shd.g_old_rec.enp_attribute28
403: ,p_enp_attribute29_o =>ben_enp_shd.g_old_rec.enp_attribute29
404: ,p_enp_attribute30_o =>ben_enp_shd.g_old_rec.enp_attribute30
405: --,p_enrt_perd_det_ovrlp_bckdt_cd_o =>ben_enp_shd.g_old_rec.enrt_perd_det_ovrlp_bckdt_cd
406: ,p_enrt_perd_det_ovrlp_cd_o =>ben_enp_shd.g_old_rec.enrt_perd_det_ovrlp_bckdt_cd
399: ,p_enp_attribute25_o =>ben_enp_shd.g_old_rec.enp_attribute25
400: ,p_enp_attribute26_o =>ben_enp_shd.g_old_rec.enp_attribute26
401: ,p_enp_attribute27_o =>ben_enp_shd.g_old_rec.enp_attribute27
402: ,p_enp_attribute28_o =>ben_enp_shd.g_old_rec.enp_attribute28
403: ,p_enp_attribute29_o =>ben_enp_shd.g_old_rec.enp_attribute29
404: ,p_enp_attribute30_o =>ben_enp_shd.g_old_rec.enp_attribute30
405: --,p_enrt_perd_det_ovrlp_bckdt_cd_o =>ben_enp_shd.g_old_rec.enrt_perd_det_ovrlp_bckdt_cd
406: ,p_enrt_perd_det_ovrlp_cd_o =>ben_enp_shd.g_old_rec.enrt_perd_det_ovrlp_bckdt_cd
407: --cwb
400: ,p_enp_attribute26_o =>ben_enp_shd.g_old_rec.enp_attribute26
401: ,p_enp_attribute27_o =>ben_enp_shd.g_old_rec.enp_attribute27
402: ,p_enp_attribute28_o =>ben_enp_shd.g_old_rec.enp_attribute28
403: ,p_enp_attribute29_o =>ben_enp_shd.g_old_rec.enp_attribute29
404: ,p_enp_attribute30_o =>ben_enp_shd.g_old_rec.enp_attribute30
405: --,p_enrt_perd_det_ovrlp_bckdt_cd_o =>ben_enp_shd.g_old_rec.enrt_perd_det_ovrlp_bckdt_cd
406: ,p_enrt_perd_det_ovrlp_cd_o =>ben_enp_shd.g_old_rec.enrt_perd_det_ovrlp_bckdt_cd
407: --cwb
408: ,p_data_freeze_date_o =>ben_enp_shd.g_old_rec.data_freeze_date
401: ,p_enp_attribute27_o =>ben_enp_shd.g_old_rec.enp_attribute27
402: ,p_enp_attribute28_o =>ben_enp_shd.g_old_rec.enp_attribute28
403: ,p_enp_attribute29_o =>ben_enp_shd.g_old_rec.enp_attribute29
404: ,p_enp_attribute30_o =>ben_enp_shd.g_old_rec.enp_attribute30
405: --,p_enrt_perd_det_ovrlp_bckdt_cd_o =>ben_enp_shd.g_old_rec.enrt_perd_det_ovrlp_bckdt_cd
406: ,p_enrt_perd_det_ovrlp_cd_o =>ben_enp_shd.g_old_rec.enrt_perd_det_ovrlp_bckdt_cd
407: --cwb
408: ,p_data_freeze_date_o =>ben_enp_shd.g_old_rec.data_freeze_date
409: ,p_Sal_chg_reason_cd_o =>ben_enp_shd.g_old_rec.Sal_chg_reason_cd
402: ,p_enp_attribute28_o =>ben_enp_shd.g_old_rec.enp_attribute28
403: ,p_enp_attribute29_o =>ben_enp_shd.g_old_rec.enp_attribute29
404: ,p_enp_attribute30_o =>ben_enp_shd.g_old_rec.enp_attribute30
405: --,p_enrt_perd_det_ovrlp_bckdt_cd_o =>ben_enp_shd.g_old_rec.enrt_perd_det_ovrlp_bckdt_cd
406: ,p_enrt_perd_det_ovrlp_cd_o =>ben_enp_shd.g_old_rec.enrt_perd_det_ovrlp_bckdt_cd
407: --cwb
408: ,p_data_freeze_date_o =>ben_enp_shd.g_old_rec.data_freeze_date
409: ,p_Sal_chg_reason_cd_o =>ben_enp_shd.g_old_rec.Sal_chg_reason_cd
410: ,p_Approval_mode_cd_o =>ben_enp_shd.g_old_rec.Approval_mode_cd
404: ,p_enp_attribute30_o =>ben_enp_shd.g_old_rec.enp_attribute30
405: --,p_enrt_perd_det_ovrlp_bckdt_cd_o =>ben_enp_shd.g_old_rec.enrt_perd_det_ovrlp_bckdt_cd
406: ,p_enrt_perd_det_ovrlp_cd_o =>ben_enp_shd.g_old_rec.enrt_perd_det_ovrlp_bckdt_cd
407: --cwb
408: ,p_data_freeze_date_o =>ben_enp_shd.g_old_rec.data_freeze_date
409: ,p_Sal_chg_reason_cd_o =>ben_enp_shd.g_old_rec.Sal_chg_reason_cd
410: ,p_Approval_mode_cd_o =>ben_enp_shd.g_old_rec.Approval_mode_cd
411: ,p_hrchy_ame_trn_cd_o =>ben_enp_shd.g_old_rec.hrchy_ame_trn_cd
412: ,p_hrchy_rl_o =>ben_enp_shd.g_old_rec.hrchy_rl
405: --,p_enrt_perd_det_ovrlp_bckdt_cd_o =>ben_enp_shd.g_old_rec.enrt_perd_det_ovrlp_bckdt_cd
406: ,p_enrt_perd_det_ovrlp_cd_o =>ben_enp_shd.g_old_rec.enrt_perd_det_ovrlp_bckdt_cd
407: --cwb
408: ,p_data_freeze_date_o =>ben_enp_shd.g_old_rec.data_freeze_date
409: ,p_Sal_chg_reason_cd_o =>ben_enp_shd.g_old_rec.Sal_chg_reason_cd
410: ,p_Approval_mode_cd_o =>ben_enp_shd.g_old_rec.Approval_mode_cd
411: ,p_hrchy_ame_trn_cd_o =>ben_enp_shd.g_old_rec.hrchy_ame_trn_cd
412: ,p_hrchy_rl_o =>ben_enp_shd.g_old_rec.hrchy_rl
413: ,p_hrchy_ame_app_id_o =>ben_enp_shd.g_old_rec.hrchy_ame_app_id
406: ,p_enrt_perd_det_ovrlp_cd_o =>ben_enp_shd.g_old_rec.enrt_perd_det_ovrlp_bckdt_cd
407: --cwb
408: ,p_data_freeze_date_o =>ben_enp_shd.g_old_rec.data_freeze_date
409: ,p_Sal_chg_reason_cd_o =>ben_enp_shd.g_old_rec.Sal_chg_reason_cd
410: ,p_Approval_mode_cd_o =>ben_enp_shd.g_old_rec.Approval_mode_cd
411: ,p_hrchy_ame_trn_cd_o =>ben_enp_shd.g_old_rec.hrchy_ame_trn_cd
412: ,p_hrchy_rl_o =>ben_enp_shd.g_old_rec.hrchy_rl
413: ,p_hrchy_ame_app_id_o =>ben_enp_shd.g_old_rec.hrchy_ame_app_id
414: --
407: --cwb
408: ,p_data_freeze_date_o =>ben_enp_shd.g_old_rec.data_freeze_date
409: ,p_Sal_chg_reason_cd_o =>ben_enp_shd.g_old_rec.Sal_chg_reason_cd
410: ,p_Approval_mode_cd_o =>ben_enp_shd.g_old_rec.Approval_mode_cd
411: ,p_hrchy_ame_trn_cd_o =>ben_enp_shd.g_old_rec.hrchy_ame_trn_cd
412: ,p_hrchy_rl_o =>ben_enp_shd.g_old_rec.hrchy_rl
413: ,p_hrchy_ame_app_id_o =>ben_enp_shd.g_old_rec.hrchy_ame_app_id
414: --
415: ,p_object_version_number_o =>ben_enp_shd.g_old_rec.object_version_number
408: ,p_data_freeze_date_o =>ben_enp_shd.g_old_rec.data_freeze_date
409: ,p_Sal_chg_reason_cd_o =>ben_enp_shd.g_old_rec.Sal_chg_reason_cd
410: ,p_Approval_mode_cd_o =>ben_enp_shd.g_old_rec.Approval_mode_cd
411: ,p_hrchy_ame_trn_cd_o =>ben_enp_shd.g_old_rec.hrchy_ame_trn_cd
412: ,p_hrchy_rl_o =>ben_enp_shd.g_old_rec.hrchy_rl
413: ,p_hrchy_ame_app_id_o =>ben_enp_shd.g_old_rec.hrchy_ame_app_id
414: --
415: ,p_object_version_number_o =>ben_enp_shd.g_old_rec.object_version_number
416: ,p_reinstate_cd_o => ben_enp_shd.g_old_rec.reinstate_cd
409: ,p_Sal_chg_reason_cd_o =>ben_enp_shd.g_old_rec.Sal_chg_reason_cd
410: ,p_Approval_mode_cd_o =>ben_enp_shd.g_old_rec.Approval_mode_cd
411: ,p_hrchy_ame_trn_cd_o =>ben_enp_shd.g_old_rec.hrchy_ame_trn_cd
412: ,p_hrchy_rl_o =>ben_enp_shd.g_old_rec.hrchy_rl
413: ,p_hrchy_ame_app_id_o =>ben_enp_shd.g_old_rec.hrchy_ame_app_id
414: --
415: ,p_object_version_number_o =>ben_enp_shd.g_old_rec.object_version_number
416: ,p_reinstate_cd_o => ben_enp_shd.g_old_rec.reinstate_cd
417: ,p_reinstate_ovrdn_cd_o => ben_enp_shd.g_old_rec.reinstate_ovrdn_cd
411: ,p_hrchy_ame_trn_cd_o =>ben_enp_shd.g_old_rec.hrchy_ame_trn_cd
412: ,p_hrchy_rl_o =>ben_enp_shd.g_old_rec.hrchy_rl
413: ,p_hrchy_ame_app_id_o =>ben_enp_shd.g_old_rec.hrchy_ame_app_id
414: --
415: ,p_object_version_number_o =>ben_enp_shd.g_old_rec.object_version_number
416: ,p_reinstate_cd_o => ben_enp_shd.g_old_rec.reinstate_cd
417: ,p_reinstate_ovrdn_cd_o => ben_enp_shd.g_old_rec.reinstate_ovrdn_cd
418: ,p_defer_deenrol_flag_o => ben_enp_shd.g_old_rec.defer_deenrol_flag
419:
412: ,p_hrchy_rl_o =>ben_enp_shd.g_old_rec.hrchy_rl
413: ,p_hrchy_ame_app_id_o =>ben_enp_shd.g_old_rec.hrchy_ame_app_id
414: --
415: ,p_object_version_number_o =>ben_enp_shd.g_old_rec.object_version_number
416: ,p_reinstate_cd_o => ben_enp_shd.g_old_rec.reinstate_cd
417: ,p_reinstate_ovrdn_cd_o => ben_enp_shd.g_old_rec.reinstate_ovrdn_cd
418: ,p_defer_deenrol_flag_o => ben_enp_shd.g_old_rec.defer_deenrol_flag
419:
420: );
413: ,p_hrchy_ame_app_id_o =>ben_enp_shd.g_old_rec.hrchy_ame_app_id
414: --
415: ,p_object_version_number_o =>ben_enp_shd.g_old_rec.object_version_number
416: ,p_reinstate_cd_o => ben_enp_shd.g_old_rec.reinstate_cd
417: ,p_reinstate_ovrdn_cd_o => ben_enp_shd.g_old_rec.reinstate_ovrdn_cd
418: ,p_defer_deenrol_flag_o => ben_enp_shd.g_old_rec.defer_deenrol_flag
419:
420: );
421: --
414: --
415: ,p_object_version_number_o =>ben_enp_shd.g_old_rec.object_version_number
416: ,p_reinstate_cd_o => ben_enp_shd.g_old_rec.reinstate_cd
417: ,p_reinstate_ovrdn_cd_o => ben_enp_shd.g_old_rec.reinstate_ovrdn_cd
418: ,p_defer_deenrol_flag_o => ben_enp_shd.g_old_rec.defer_deenrol_flag
419:
420: );
421: --
422: exception
477: -- Internal Row Handler Use Only.
478: --
479: -- {End Of Comments}
480: -- ----------------------------------------------------------------------------
481: Procedure convert_defs(p_rec in out nocopy ben_enp_shd.g_rec_type) is
482: --
483: l_proc varchar2(72) := g_package||'convert_defs';
484: --
485: Begin
492: -- is being used then we must set to the 'current' argument value.
493: --
494: If (p_rec.business_group_id = hr_api.g_number) then
495: p_rec.business_group_id :=
496: ben_enp_shd.g_old_rec.business_group_id;
497: End If;
498: If (p_rec.yr_perd_id = hr_api.g_number) then
499: p_rec.yr_perd_id :=
500: ben_enp_shd.g_old_rec.yr_perd_id;
496: ben_enp_shd.g_old_rec.business_group_id;
497: End If;
498: If (p_rec.yr_perd_id = hr_api.g_number) then
499: p_rec.yr_perd_id :=
500: ben_enp_shd.g_old_rec.yr_perd_id;
501: End If;
502: If (p_rec.popl_enrt_typ_cycl_id = hr_api.g_number) then
503: p_rec.popl_enrt_typ_cycl_id :=
504: ben_enp_shd.g_old_rec.popl_enrt_typ_cycl_id;
500: ben_enp_shd.g_old_rec.yr_perd_id;
501: End If;
502: If (p_rec.popl_enrt_typ_cycl_id = hr_api.g_number) then
503: p_rec.popl_enrt_typ_cycl_id :=
504: ben_enp_shd.g_old_rec.popl_enrt_typ_cycl_id;
505: End If;
506: If (p_rec.end_dt = hr_api.g_date) then
507: p_rec.end_dt :=
508: ben_enp_shd.g_old_rec.end_dt;
504: ben_enp_shd.g_old_rec.popl_enrt_typ_cycl_id;
505: End If;
506: If (p_rec.end_dt = hr_api.g_date) then
507: p_rec.end_dt :=
508: ben_enp_shd.g_old_rec.end_dt;
509: End If;
510: If (p_rec.strt_dt = hr_api.g_date) then
511: p_rec.strt_dt :=
512: ben_enp_shd.g_old_rec.strt_dt;
508: ben_enp_shd.g_old_rec.end_dt;
509: End If;
510: If (p_rec.strt_dt = hr_api.g_date) then
511: p_rec.strt_dt :=
512: ben_enp_shd.g_old_rec.strt_dt;
513: End If;
514: If (p_rec.asnd_lf_evt_dt = hr_api.g_date) then
515: p_rec.asnd_lf_evt_dt :=
516: ben_enp_shd.g_old_rec.asnd_lf_evt_dt;
512: ben_enp_shd.g_old_rec.strt_dt;
513: End If;
514: If (p_rec.asnd_lf_evt_dt = hr_api.g_date) then
515: p_rec.asnd_lf_evt_dt :=
516: ben_enp_shd.g_old_rec.asnd_lf_evt_dt;
517: End If;
518: If (p_rec.cls_enrt_dt_to_use_cd = hr_api.g_varchar2) then
519: p_rec.cls_enrt_dt_to_use_cd :=
520: ben_enp_shd.g_old_rec.cls_enrt_dt_to_use_cd;
516: ben_enp_shd.g_old_rec.asnd_lf_evt_dt;
517: End If;
518: If (p_rec.cls_enrt_dt_to_use_cd = hr_api.g_varchar2) then
519: p_rec.cls_enrt_dt_to_use_cd :=
520: ben_enp_shd.g_old_rec.cls_enrt_dt_to_use_cd;
521: End If;
522: If (p_rec.dflt_enrt_dt = hr_api.g_date) then
523: p_rec.dflt_enrt_dt :=
524: ben_enp_shd.g_old_rec.dflt_enrt_dt;
520: ben_enp_shd.g_old_rec.cls_enrt_dt_to_use_cd;
521: End If;
522: If (p_rec.dflt_enrt_dt = hr_api.g_date) then
523: p_rec.dflt_enrt_dt :=
524: ben_enp_shd.g_old_rec.dflt_enrt_dt;
525: End If;
526: If (p_rec.enrt_cvg_strt_dt_cd = hr_api.g_varchar2) then
527: p_rec.enrt_cvg_strt_dt_cd :=
528: ben_enp_shd.g_old_rec.enrt_cvg_strt_dt_cd;
524: ben_enp_shd.g_old_rec.dflt_enrt_dt;
525: End If;
526: If (p_rec.enrt_cvg_strt_dt_cd = hr_api.g_varchar2) then
527: p_rec.enrt_cvg_strt_dt_cd :=
528: ben_enp_shd.g_old_rec.enrt_cvg_strt_dt_cd;
529: End If;
530: If (p_rec.rt_strt_dt_rl = hr_api.g_number) then
531: p_rec.rt_strt_dt_rl :=
532: ben_enp_shd.g_old_rec.rt_strt_dt_rl;
528: ben_enp_shd.g_old_rec.enrt_cvg_strt_dt_cd;
529: End If;
530: If (p_rec.rt_strt_dt_rl = hr_api.g_number) then
531: p_rec.rt_strt_dt_rl :=
532: ben_enp_shd.g_old_rec.rt_strt_dt_rl;
533: End If;
534: If (p_rec.enrt_cvg_end_dt_cd = hr_api.g_varchar2) then
535: p_rec.enrt_cvg_end_dt_cd :=
536: ben_enp_shd.g_old_rec.enrt_cvg_end_dt_cd;
532: ben_enp_shd.g_old_rec.rt_strt_dt_rl;
533: End If;
534: If (p_rec.enrt_cvg_end_dt_cd = hr_api.g_varchar2) then
535: p_rec.enrt_cvg_end_dt_cd :=
536: ben_enp_shd.g_old_rec.enrt_cvg_end_dt_cd;
537: End If;
538: If (p_rec.enrt_cvg_strt_dt_rl = hr_api.g_number) then
539: p_rec.enrt_cvg_strt_dt_rl :=
540: ben_enp_shd.g_old_rec.enrt_cvg_strt_dt_rl;
536: ben_enp_shd.g_old_rec.enrt_cvg_end_dt_cd;
537: End If;
538: If (p_rec.enrt_cvg_strt_dt_rl = hr_api.g_number) then
539: p_rec.enrt_cvg_strt_dt_rl :=
540: ben_enp_shd.g_old_rec.enrt_cvg_strt_dt_rl;
541: End If;
542: If (p_rec.enrt_cvg_end_dt_rl = hr_api.g_number) then
543: p_rec.enrt_cvg_end_dt_rl :=
544: ben_enp_shd.g_old_rec.enrt_cvg_end_dt_rl;
540: ben_enp_shd.g_old_rec.enrt_cvg_strt_dt_rl;
541: End If;
542: If (p_rec.enrt_cvg_end_dt_rl = hr_api.g_number) then
543: p_rec.enrt_cvg_end_dt_rl :=
544: ben_enp_shd.g_old_rec.enrt_cvg_end_dt_rl;
545: End If;
546: If (p_rec.procg_end_dt = hr_api.g_date) then
547: p_rec.procg_end_dt :=
548: ben_enp_shd.g_old_rec.procg_end_dt;
544: ben_enp_shd.g_old_rec.enrt_cvg_end_dt_rl;
545: End If;
546: If (p_rec.procg_end_dt = hr_api.g_date) then
547: p_rec.procg_end_dt :=
548: ben_enp_shd.g_old_rec.procg_end_dt;
549: End If;
550: If (p_rec.rt_strt_dt_cd = hr_api.g_varchar2) then
551: p_rec.rt_strt_dt_cd :=
552: ben_enp_shd.g_old_rec.rt_strt_dt_cd;
548: ben_enp_shd.g_old_rec.procg_end_dt;
549: End If;
550: If (p_rec.rt_strt_dt_cd = hr_api.g_varchar2) then
551: p_rec.rt_strt_dt_cd :=
552: ben_enp_shd.g_old_rec.rt_strt_dt_cd;
553: End If;
554: If (p_rec.rt_end_dt_cd = hr_api.g_varchar2) then
555: p_rec.rt_end_dt_cd :=
556: ben_enp_shd.g_old_rec.rt_end_dt_cd;
552: ben_enp_shd.g_old_rec.rt_strt_dt_cd;
553: End If;
554: If (p_rec.rt_end_dt_cd = hr_api.g_varchar2) then
555: p_rec.rt_end_dt_cd :=
556: ben_enp_shd.g_old_rec.rt_end_dt_cd;
557: End If;
558: If (p_rec.rt_end_dt_rl = hr_api.g_number) then
559: p_rec.rt_end_dt_rl :=
560: ben_enp_shd.g_old_rec.rt_end_dt_rl;
556: ben_enp_shd.g_old_rec.rt_end_dt_cd;
557: End If;
558: If (p_rec.rt_end_dt_rl = hr_api.g_number) then
559: p_rec.rt_end_dt_rl :=
560: ben_enp_shd.g_old_rec.rt_end_dt_rl;
561: End If;
562: -- CompWorkBench Additions
563: If (p_rec.bdgt_upd_strt_dt = hr_api.g_date) then
564: p_rec.bdgt_upd_strt_dt :=
561: End If;
562: -- CompWorkBench Additions
563: If (p_rec.bdgt_upd_strt_dt = hr_api.g_date) then
564: p_rec.bdgt_upd_strt_dt :=
565: ben_enp_shd.g_old_rec.bdgt_upd_strt_dt;
566: End If;
567: If (p_rec.bdgt_upd_end_dt= hr_api.g_date) then
568: p_rec.bdgt_upd_end_dt :=
569: ben_enp_shd.g_old_rec.bdgt_upd_end_dt;
565: ben_enp_shd.g_old_rec.bdgt_upd_strt_dt;
566: End If;
567: If (p_rec.bdgt_upd_end_dt= hr_api.g_date) then
568: p_rec.bdgt_upd_end_dt :=
569: ben_enp_shd.g_old_rec.bdgt_upd_end_dt;
570: End If;
571: If (p_rec.ws_upd_strt_dt= hr_api.g_date) then
572: p_rec.ws_upd_strt_dt :=
573: ben_enp_shd.g_old_rec.ws_upd_strt_dt;
569: ben_enp_shd.g_old_rec.bdgt_upd_end_dt;
570: End If;
571: If (p_rec.ws_upd_strt_dt= hr_api.g_date) then
572: p_rec.ws_upd_strt_dt :=
573: ben_enp_shd.g_old_rec.ws_upd_strt_dt;
574: End If;
575: If (p_rec.ws_upd_end_dt = hr_api.g_date) then
576: p_rec.ws_upd_end_dt :=
577: ben_enp_shd.g_old_rec.ws_upd_end_dt;
573: ben_enp_shd.g_old_rec.ws_upd_strt_dt;
574: End If;
575: If (p_rec.ws_upd_end_dt = hr_api.g_date) then
576: p_rec.ws_upd_end_dt :=
577: ben_enp_shd.g_old_rec.ws_upd_end_dt;
578: End If;
579: If (p_rec.dflt_ws_acc_cd= hr_api.g_varchar2) then
580: p_rec.dflt_ws_acc_cd :=
581: ben_enp_shd.g_old_rec.dflt_ws_acc_cd;
577: ben_enp_shd.g_old_rec.ws_upd_end_dt;
578: End If;
579: If (p_rec.dflt_ws_acc_cd= hr_api.g_varchar2) then
580: p_rec.dflt_ws_acc_cd :=
581: ben_enp_shd.g_old_rec.dflt_ws_acc_cd;
582: End If;
583: If (p_rec.prsvr_bdgt_cd = hr_api.g_varchar2) then
584: p_rec.prsvr_bdgt_cd :=
585: ben_enp_shd.g_old_rec.prsvr_bdgt_cd;
581: ben_enp_shd.g_old_rec.dflt_ws_acc_cd;
582: End If;
583: If (p_rec.prsvr_bdgt_cd = hr_api.g_varchar2) then
584: p_rec.prsvr_bdgt_cd :=
585: ben_enp_shd.g_old_rec.prsvr_bdgt_cd;
586: End If;
587: If (p_rec.uses_bdgt_flag = hr_api.g_varchar2) then
588: p_rec.uses_bdgt_flag :=
589: ben_enp_shd.g_old_rec.uses_bdgt_flag;
585: ben_enp_shd.g_old_rec.prsvr_bdgt_cd;
586: End If;
587: If (p_rec.uses_bdgt_flag = hr_api.g_varchar2) then
588: p_rec.uses_bdgt_flag :=
589: ben_enp_shd.g_old_rec.uses_bdgt_flag;
590: End If;
591: If (p_rec.auto_distr_flag = hr_api.g_varchar2) then
592: p_rec.auto_distr_flag :=
593: ben_enp_shd.g_old_rec.auto_distr_flag;
589: ben_enp_shd.g_old_rec.uses_bdgt_flag;
590: End If;
591: If (p_rec.auto_distr_flag = hr_api.g_varchar2) then
592: p_rec.auto_distr_flag :=
593: ben_enp_shd.g_old_rec.auto_distr_flag;
594: End If;
595: If (p_rec.hrchy_to_use_cd = hr_api.g_varchar2) then
596: p_rec.hrchy_to_use_cd :=
597: ben_enp_shd.g_old_rec.hrchy_to_use_cd;
593: ben_enp_shd.g_old_rec.auto_distr_flag;
594: End If;
595: If (p_rec.hrchy_to_use_cd = hr_api.g_varchar2) then
596: p_rec.hrchy_to_use_cd :=
597: ben_enp_shd.g_old_rec.hrchy_to_use_cd;
598: End If;
599: If (p_rec.pos_structure_version_id = hr_api.g_number) then
600: p_rec.pos_structure_version_id :=
601: ben_enp_shd.g_old_rec.pos_structure_version_id;
597: ben_enp_shd.g_old_rec.hrchy_to_use_cd;
598: End If;
599: If (p_rec.pos_structure_version_id = hr_api.g_number) then
600: p_rec.pos_structure_version_id :=
601: ben_enp_shd.g_old_rec.pos_structure_version_id;
602: End If;
603: If (p_rec.emp_interview_type_cd = hr_api.g_varchar2) then
604: p_rec.emp_interview_type_cd :=
605: ben_enp_shd.g_old_rec.emp_interview_type_cd;
601: ben_enp_shd.g_old_rec.pos_structure_version_id;
602: End If;
603: If (p_rec.emp_interview_type_cd = hr_api.g_varchar2) then
604: p_rec.emp_interview_type_cd :=
605: ben_enp_shd.g_old_rec.emp_interview_type_cd;
606: End If;
607: If (p_rec.wthn_yr_perd_id = hr_api.g_number) then
608: p_rec.wthn_yr_perd_id :=
609: ben_enp_shd.g_old_rec.wthn_yr_perd_id;
605: ben_enp_shd.g_old_rec.emp_interview_type_cd;
606: End If;
607: If (p_rec.wthn_yr_perd_id = hr_api.g_number) then
608: p_rec.wthn_yr_perd_id :=
609: ben_enp_shd.g_old_rec.wthn_yr_perd_id;
610: End If;
611: If (p_rec.ler_id = hr_api.g_number) then
612: p_rec.ler_id :=
613: ben_enp_shd.g_old_rec.ler_id;
609: ben_enp_shd.g_old_rec.wthn_yr_perd_id;
610: End If;
611: If (p_rec.ler_id = hr_api.g_number) then
612: p_rec.ler_id :=
613: ben_enp_shd.g_old_rec.ler_id;
614: End If;
615: If (p_rec.perf_revw_strt_dt = hr_api.g_date) then
616: p_rec.perf_revw_strt_dt :=
617: ben_enp_shd.g_old_rec.perf_revw_strt_dt;
613: ben_enp_shd.g_old_rec.ler_id;
614: End If;
615: If (p_rec.perf_revw_strt_dt = hr_api.g_date) then
616: p_rec.perf_revw_strt_dt :=
617: ben_enp_shd.g_old_rec.perf_revw_strt_dt;
618: End If;
619: If (p_rec.asg_updt_eff_date = hr_api.g_date) then
620: p_rec.asg_updt_eff_date :=
621: ben_enp_shd.g_old_rec.asg_updt_eff_date;
617: ben_enp_shd.g_old_rec.perf_revw_strt_dt;
618: End If;
619: If (p_rec.asg_updt_eff_date = hr_api.g_date) then
620: p_rec.asg_updt_eff_date :=
621: ben_enp_shd.g_old_rec.asg_updt_eff_date;
622: End If;
623: -- end CompWorkBench additions
624: If (p_rec.enp_attribute_category = hr_api.g_varchar2) then
625: p_rec.enp_attribute_category :=
622: End If;
623: -- end CompWorkBench additions
624: If (p_rec.enp_attribute_category = hr_api.g_varchar2) then
625: p_rec.enp_attribute_category :=
626: ben_enp_shd.g_old_rec.enp_attribute_category;
627: End If;
628: If (p_rec.enp_attribute1 = hr_api.g_varchar2) then
629: p_rec.enp_attribute1 :=
630: ben_enp_shd.g_old_rec.enp_attribute1;
626: ben_enp_shd.g_old_rec.enp_attribute_category;
627: End If;
628: If (p_rec.enp_attribute1 = hr_api.g_varchar2) then
629: p_rec.enp_attribute1 :=
630: ben_enp_shd.g_old_rec.enp_attribute1;
631: End If;
632: If (p_rec.enp_attribute2 = hr_api.g_varchar2) then
633: p_rec.enp_attribute2 :=
634: ben_enp_shd.g_old_rec.enp_attribute2;
630: ben_enp_shd.g_old_rec.enp_attribute1;
631: End If;
632: If (p_rec.enp_attribute2 = hr_api.g_varchar2) then
633: p_rec.enp_attribute2 :=
634: ben_enp_shd.g_old_rec.enp_attribute2;
635: End If;
636: If (p_rec.enp_attribute3 = hr_api.g_varchar2) then
637: p_rec.enp_attribute3 :=
638: ben_enp_shd.g_old_rec.enp_attribute3;
634: ben_enp_shd.g_old_rec.enp_attribute2;
635: End If;
636: If (p_rec.enp_attribute3 = hr_api.g_varchar2) then
637: p_rec.enp_attribute3 :=
638: ben_enp_shd.g_old_rec.enp_attribute3;
639: End If;
640: If (p_rec.enp_attribute4 = hr_api.g_varchar2) then
641: p_rec.enp_attribute4 :=
642: ben_enp_shd.g_old_rec.enp_attribute4;
638: ben_enp_shd.g_old_rec.enp_attribute3;
639: End If;
640: If (p_rec.enp_attribute4 = hr_api.g_varchar2) then
641: p_rec.enp_attribute4 :=
642: ben_enp_shd.g_old_rec.enp_attribute4;
643: End If;
644: If (p_rec.enp_attribute5 = hr_api.g_varchar2) then
645: p_rec.enp_attribute5 :=
646: ben_enp_shd.g_old_rec.enp_attribute5;
642: ben_enp_shd.g_old_rec.enp_attribute4;
643: End If;
644: If (p_rec.enp_attribute5 = hr_api.g_varchar2) then
645: p_rec.enp_attribute5 :=
646: ben_enp_shd.g_old_rec.enp_attribute5;
647: End If;
648: If (p_rec.enp_attribute6 = hr_api.g_varchar2) then
649: p_rec.enp_attribute6 :=
650: ben_enp_shd.g_old_rec.enp_attribute6;
646: ben_enp_shd.g_old_rec.enp_attribute5;
647: End If;
648: If (p_rec.enp_attribute6 = hr_api.g_varchar2) then
649: p_rec.enp_attribute6 :=
650: ben_enp_shd.g_old_rec.enp_attribute6;
651: End If;
652: If (p_rec.enp_attribute7 = hr_api.g_varchar2) then
653: p_rec.enp_attribute7 :=
654: ben_enp_shd.g_old_rec.enp_attribute7;
650: ben_enp_shd.g_old_rec.enp_attribute6;
651: End If;
652: If (p_rec.enp_attribute7 = hr_api.g_varchar2) then
653: p_rec.enp_attribute7 :=
654: ben_enp_shd.g_old_rec.enp_attribute7;
655: End If;
656: If (p_rec.enp_attribute8 = hr_api.g_varchar2) then
657: p_rec.enp_attribute8 :=
658: ben_enp_shd.g_old_rec.enp_attribute8;
654: ben_enp_shd.g_old_rec.enp_attribute7;
655: End If;
656: If (p_rec.enp_attribute8 = hr_api.g_varchar2) then
657: p_rec.enp_attribute8 :=
658: ben_enp_shd.g_old_rec.enp_attribute8;
659: End If;
660: If (p_rec.enp_attribute9 = hr_api.g_varchar2) then
661: p_rec.enp_attribute9 :=
662: ben_enp_shd.g_old_rec.enp_attribute9;
658: ben_enp_shd.g_old_rec.enp_attribute8;
659: End If;
660: If (p_rec.enp_attribute9 = hr_api.g_varchar2) then
661: p_rec.enp_attribute9 :=
662: ben_enp_shd.g_old_rec.enp_attribute9;
663: End If;
664: If (p_rec.enp_attribute10 = hr_api.g_varchar2) then
665: p_rec.enp_attribute10 :=
666: ben_enp_shd.g_old_rec.enp_attribute10;
662: ben_enp_shd.g_old_rec.enp_attribute9;
663: End If;
664: If (p_rec.enp_attribute10 = hr_api.g_varchar2) then
665: p_rec.enp_attribute10 :=
666: ben_enp_shd.g_old_rec.enp_attribute10;
667: End If;
668: If (p_rec.enp_attribute11 = hr_api.g_varchar2) then
669: p_rec.enp_attribute11 :=
670: ben_enp_shd.g_old_rec.enp_attribute11;
666: ben_enp_shd.g_old_rec.enp_attribute10;
667: End If;
668: If (p_rec.enp_attribute11 = hr_api.g_varchar2) then
669: p_rec.enp_attribute11 :=
670: ben_enp_shd.g_old_rec.enp_attribute11;
671: End If;
672: If (p_rec.enp_attribute12 = hr_api.g_varchar2) then
673: p_rec.enp_attribute12 :=
674: ben_enp_shd.g_old_rec.enp_attribute12;
670: ben_enp_shd.g_old_rec.enp_attribute11;
671: End If;
672: If (p_rec.enp_attribute12 = hr_api.g_varchar2) then
673: p_rec.enp_attribute12 :=
674: ben_enp_shd.g_old_rec.enp_attribute12;
675: End If;
676: If (p_rec.enp_attribute13 = hr_api.g_varchar2) then
677: p_rec.enp_attribute13 :=
678: ben_enp_shd.g_old_rec.enp_attribute13;
674: ben_enp_shd.g_old_rec.enp_attribute12;
675: End If;
676: If (p_rec.enp_attribute13 = hr_api.g_varchar2) then
677: p_rec.enp_attribute13 :=
678: ben_enp_shd.g_old_rec.enp_attribute13;
679: End If;
680: If (p_rec.enp_attribute14 = hr_api.g_varchar2) then
681: p_rec.enp_attribute14 :=
682: ben_enp_shd.g_old_rec.enp_attribute14;
678: ben_enp_shd.g_old_rec.enp_attribute13;
679: End If;
680: If (p_rec.enp_attribute14 = hr_api.g_varchar2) then
681: p_rec.enp_attribute14 :=
682: ben_enp_shd.g_old_rec.enp_attribute14;
683: End If;
684: If (p_rec.enp_attribute15 = hr_api.g_varchar2) then
685: p_rec.enp_attribute15 :=
686: ben_enp_shd.g_old_rec.enp_attribute15;
682: ben_enp_shd.g_old_rec.enp_attribute14;
683: End If;
684: If (p_rec.enp_attribute15 = hr_api.g_varchar2) then
685: p_rec.enp_attribute15 :=
686: ben_enp_shd.g_old_rec.enp_attribute15;
687: End If;
688: If (p_rec.enp_attribute16 = hr_api.g_varchar2) then
689: p_rec.enp_attribute16 :=
690: ben_enp_shd.g_old_rec.enp_attribute16;
686: ben_enp_shd.g_old_rec.enp_attribute15;
687: End If;
688: If (p_rec.enp_attribute16 = hr_api.g_varchar2) then
689: p_rec.enp_attribute16 :=
690: ben_enp_shd.g_old_rec.enp_attribute16;
691: End If;
692: If (p_rec.enp_attribute17 = hr_api.g_varchar2) then
693: p_rec.enp_attribute17 :=
694: ben_enp_shd.g_old_rec.enp_attribute17;
690: ben_enp_shd.g_old_rec.enp_attribute16;
691: End If;
692: If (p_rec.enp_attribute17 = hr_api.g_varchar2) then
693: p_rec.enp_attribute17 :=
694: ben_enp_shd.g_old_rec.enp_attribute17;
695: End If;
696: If (p_rec.enp_attribute18 = hr_api.g_varchar2) then
697: p_rec.enp_attribute18 :=
698: ben_enp_shd.g_old_rec.enp_attribute18;
694: ben_enp_shd.g_old_rec.enp_attribute17;
695: End If;
696: If (p_rec.enp_attribute18 = hr_api.g_varchar2) then
697: p_rec.enp_attribute18 :=
698: ben_enp_shd.g_old_rec.enp_attribute18;
699: End If;
700: If (p_rec.enp_attribute19 = hr_api.g_varchar2) then
701: p_rec.enp_attribute19 :=
702: ben_enp_shd.g_old_rec.enp_attribute19;
698: ben_enp_shd.g_old_rec.enp_attribute18;
699: End If;
700: If (p_rec.enp_attribute19 = hr_api.g_varchar2) then
701: p_rec.enp_attribute19 :=
702: ben_enp_shd.g_old_rec.enp_attribute19;
703: End If;
704: If (p_rec.enp_attribute20 = hr_api.g_varchar2) then
705: p_rec.enp_attribute20 :=
706: ben_enp_shd.g_old_rec.enp_attribute20;
702: ben_enp_shd.g_old_rec.enp_attribute19;
703: End If;
704: If (p_rec.enp_attribute20 = hr_api.g_varchar2) then
705: p_rec.enp_attribute20 :=
706: ben_enp_shd.g_old_rec.enp_attribute20;
707: End If;
708: If (p_rec.enp_attribute21 = hr_api.g_varchar2) then
709: p_rec.enp_attribute21 :=
710: ben_enp_shd.g_old_rec.enp_attribute21;
706: ben_enp_shd.g_old_rec.enp_attribute20;
707: End If;
708: If (p_rec.enp_attribute21 = hr_api.g_varchar2) then
709: p_rec.enp_attribute21 :=
710: ben_enp_shd.g_old_rec.enp_attribute21;
711: End If;
712: If (p_rec.enp_attribute22 = hr_api.g_varchar2) then
713: p_rec.enp_attribute22 :=
714: ben_enp_shd.g_old_rec.enp_attribute22;
710: ben_enp_shd.g_old_rec.enp_attribute21;
711: End If;
712: If (p_rec.enp_attribute22 = hr_api.g_varchar2) then
713: p_rec.enp_attribute22 :=
714: ben_enp_shd.g_old_rec.enp_attribute22;
715: End If;
716: If (p_rec.enp_attribute23 = hr_api.g_varchar2) then
717: p_rec.enp_attribute23 :=
718: ben_enp_shd.g_old_rec.enp_attribute23;
714: ben_enp_shd.g_old_rec.enp_attribute22;
715: End If;
716: If (p_rec.enp_attribute23 = hr_api.g_varchar2) then
717: p_rec.enp_attribute23 :=
718: ben_enp_shd.g_old_rec.enp_attribute23;
719: End If;
720: If (p_rec.enp_attribute24 = hr_api.g_varchar2) then
721: p_rec.enp_attribute24 :=
722: ben_enp_shd.g_old_rec.enp_attribute24;
718: ben_enp_shd.g_old_rec.enp_attribute23;
719: End If;
720: If (p_rec.enp_attribute24 = hr_api.g_varchar2) then
721: p_rec.enp_attribute24 :=
722: ben_enp_shd.g_old_rec.enp_attribute24;
723: End If;
724: If (p_rec.enp_attribute25 = hr_api.g_varchar2) then
725: p_rec.enp_attribute25 :=
726: ben_enp_shd.g_old_rec.enp_attribute25;
722: ben_enp_shd.g_old_rec.enp_attribute24;
723: End If;
724: If (p_rec.enp_attribute25 = hr_api.g_varchar2) then
725: p_rec.enp_attribute25 :=
726: ben_enp_shd.g_old_rec.enp_attribute25;
727: End If;
728: If (p_rec.enp_attribute26 = hr_api.g_varchar2) then
729: p_rec.enp_attribute26 :=
730: ben_enp_shd.g_old_rec.enp_attribute26;
726: ben_enp_shd.g_old_rec.enp_attribute25;
727: End If;
728: If (p_rec.enp_attribute26 = hr_api.g_varchar2) then
729: p_rec.enp_attribute26 :=
730: ben_enp_shd.g_old_rec.enp_attribute26;
731: End If;
732: If (p_rec.enp_attribute27 = hr_api.g_varchar2) then
733: p_rec.enp_attribute27 :=
734: ben_enp_shd.g_old_rec.enp_attribute27;
730: ben_enp_shd.g_old_rec.enp_attribute26;
731: End If;
732: If (p_rec.enp_attribute27 = hr_api.g_varchar2) then
733: p_rec.enp_attribute27 :=
734: ben_enp_shd.g_old_rec.enp_attribute27;
735: End If;
736: If (p_rec.enp_attribute28 = hr_api.g_varchar2) then
737: p_rec.enp_attribute28 :=
738: ben_enp_shd.g_old_rec.enp_attribute28;
734: ben_enp_shd.g_old_rec.enp_attribute27;
735: End If;
736: If (p_rec.enp_attribute28 = hr_api.g_varchar2) then
737: p_rec.enp_attribute28 :=
738: ben_enp_shd.g_old_rec.enp_attribute28;
739: End If;
740: If (p_rec.enp_attribute29 = hr_api.g_varchar2) then
741: p_rec.enp_attribute29 :=
742: ben_enp_shd.g_old_rec.enp_attribute29;
738: ben_enp_shd.g_old_rec.enp_attribute28;
739: End If;
740: If (p_rec.enp_attribute29 = hr_api.g_varchar2) then
741: p_rec.enp_attribute29 :=
742: ben_enp_shd.g_old_rec.enp_attribute29;
743: End If;
744: If (p_rec.enp_attribute30 = hr_api.g_varchar2) then
745: p_rec.enp_attribute30 :=
746: ben_enp_shd.g_old_rec.enp_attribute30;
742: ben_enp_shd.g_old_rec.enp_attribute29;
743: End If;
744: If (p_rec.enp_attribute30 = hr_api.g_varchar2) then
745: p_rec.enp_attribute30 :=
746: ben_enp_shd.g_old_rec.enp_attribute30;
747: End If;
748: --
749: If (p_rec.enrt_perd_det_ovrlp_bckdt_cd = hr_api.g_varchar2) then
750: p_rec.enrt_perd_det_ovrlp_bckdt_cd :=
747: End If;
748: --
749: If (p_rec.enrt_perd_det_ovrlp_bckdt_cd = hr_api.g_varchar2) then
750: p_rec.enrt_perd_det_ovrlp_bckdt_cd :=
751: ben_enp_shd.g_old_rec.enrt_perd_det_ovrlp_bckdt_cd;
752: End if;
753:
754: --- cwb
755: If (p_rec.data_freeze_date = hr_api.g_date) then
753:
754: --- cwb
755: If (p_rec.data_freeze_date = hr_api.g_date) then
756: p_rec.data_freeze_date :=
757: ben_enp_shd.g_old_rec.data_freeze_date;
758: End If;
759:
760: If (p_rec.Sal_chg_reason_cd = hr_api.g_varchar2) then
761: p_rec.Sal_chg_reason_cd :=
758: End If;
759:
760: If (p_rec.Sal_chg_reason_cd = hr_api.g_varchar2) then
761: p_rec.Sal_chg_reason_cd :=
762: ben_enp_shd.g_old_rec.Sal_chg_reason_cd;
763: End if;
764:
765: If (p_rec.Approval_mode_cd = hr_api.g_varchar2) then
766: p_rec.Approval_mode_cd :=
763: End if;
764:
765: If (p_rec.Approval_mode_cd = hr_api.g_varchar2) then
766: p_rec.Approval_mode_cd :=
767: ben_enp_shd.g_old_rec.Approval_mode_cd;
768: End if;
769:
770: If (p_rec.hrchy_ame_trn_cd = hr_api.g_varchar2) then
771: p_rec.hrchy_ame_trn_cd :=
768: End if;
769:
770: If (p_rec.hrchy_ame_trn_cd = hr_api.g_varchar2) then
771: p_rec.hrchy_ame_trn_cd :=
772: ben_enp_shd.g_old_rec.hrchy_ame_trn_cd;
773: End if;
774:
775: If (p_rec.hrchy_rl = hr_api.g_number) then
776: p_rec.hrchy_rl :=
773: End if;
774:
775: If (p_rec.hrchy_rl = hr_api.g_number) then
776: p_rec.hrchy_rl :=
777: ben_enp_shd.g_old_rec.hrchy_rl;
778: End If;
779:
780: If (p_rec.hrchy_ame_app_id = hr_api.g_number) then
781: p_rec.hrchy_ame_app_id :=
778: End If;
779:
780: If (p_rec.hrchy_ame_app_id = hr_api.g_number) then
781: p_rec.hrchy_ame_app_id :=
782: ben_enp_shd.g_old_rec.hrchy_ame_app_id;
783: End If;
784:
785: If (p_rec.reinstate_cd = hr_api.g_varchar2) then
786: p_rec.reinstate_cd :=
783: End If;
784:
785: If (p_rec.reinstate_cd = hr_api.g_varchar2) then
786: p_rec.reinstate_cd :=
787: ben_enp_shd.g_old_rec.reinstate_cd;
788: End if;
789:
790: If (p_rec.reinstate_ovrdn_cd = hr_api.g_varchar2) then
791: p_rec.reinstate_ovrdn_cd :=
788: End if;
789:
790: If (p_rec.reinstate_ovrdn_cd = hr_api.g_varchar2) then
791: p_rec.reinstate_ovrdn_cd :=
792: ben_enp_shd.g_old_rec.reinstate_ovrdn_cd;
793: End if;
794:
795: If (p_rec.defer_deenrol_flag = hr_api.g_varchar2) then
796: p_rec.defer_deenrol_flag :=
793: End if;
794:
795: If (p_rec.defer_deenrol_flag = hr_api.g_varchar2) then
796: p_rec.defer_deenrol_flag :=
797: ben_enp_shd.g_old_rec.defer_deenrol_flag;
798: End if;
799: --
800: hr_utility.set_location(' Leaving:'||l_proc, 10);
801: --
806: -- ----------------------------------------------------------------------------
807: Procedure upd
808: (
809: p_effective_date in date,
810: p_rec in out nocopy ben_enp_shd.g_rec_type
811: ) is
812: --
813: l_proc varchar2(72) := g_package||'upd';
814: --
816: hr_utility.set_location('Entering:'||l_proc, 5);
817: --
818: -- We must lock the row which we need to update.
819: --
820: ben_enp_shd.lck
821: (
822: p_rec.enrt_perd_id,
823: p_rec.object_version_number
824: );
931: p_reinstate_ovrdn_cd in varchar2,
932: p_defer_deenrol_flag in varchar2
933: ) is
934: --
935: l_rec ben_enp_shd.g_rec_type;
936: l_proc varchar2(72) := g_package||'upd';
937: --
938: Begin
939: hr_utility.set_location('Entering:'||l_proc, 5);
941: -- Call conversion function to turn arguments into the
942: -- l_rec structure.
943: --
944: l_rec :=
945: ben_enp_shd.convert_args
946: (
947: p_enrt_perd_id,
948: p_business_group_id,
949: p_yr_perd_id,