50: -- Internal Row Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy ben_pel_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_pel_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the ben_pil_elctbl_chc_popl Row
68: --
69: update ben_pil_elctbl_chc_popl
148: defer_deenrol_flag = p_rec.defer_deenrol_flag,
149: deenrol_made_dt = p_rec.deenrol_made_dt
150: where pil_elctbl_chc_popl_id = p_rec.pil_elctbl_chc_popl_id;
151: --
152: ben_pel_shd.g_api_dml := false; -- Unset the api dml status
153: --
154: hr_utility.set_location(' Leaving:'||l_proc, 10);
155: --
156: Exception
155: --
156: Exception
157: When hr_api.check_integrity_violated Then
158: -- A check constraint has been violated
159: ben_pel_shd.g_api_dml := false; -- Unset the api dml status
160: ben_pel_shd.constraint_error
161: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
162: When hr_api.parent_integrity_violated Then
163: -- Parent integrity has been violated
156: Exception
157: When hr_api.check_integrity_violated Then
158: -- A check constraint has been violated
159: ben_pel_shd.g_api_dml := false; -- Unset the api dml status
160: ben_pel_shd.constraint_error
161: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
162: When hr_api.parent_integrity_violated Then
163: -- Parent integrity has been violated
164: ben_pel_shd.g_api_dml := false; -- Unset the api dml status
160: ben_pel_shd.constraint_error
161: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
162: When hr_api.parent_integrity_violated Then
163: -- Parent integrity has been violated
164: ben_pel_shd.g_api_dml := false; -- Unset the api dml status
165: ben_pel_shd.constraint_error
166: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
167: When hr_api.unique_integrity_violated Then
168: -- Unique integrity has been violated
161: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
162: When hr_api.parent_integrity_violated Then
163: -- Parent integrity has been violated
164: ben_pel_shd.g_api_dml := false; -- Unset the api dml status
165: ben_pel_shd.constraint_error
166: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
167: When hr_api.unique_integrity_violated Then
168: -- Unique integrity has been violated
169: ben_pel_shd.g_api_dml := false; -- Unset the api dml status
165: ben_pel_shd.constraint_error
166: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
167: When hr_api.unique_integrity_violated Then
168: -- Unique integrity has been violated
169: ben_pel_shd.g_api_dml := false; -- Unset the api dml status
170: ben_pel_shd.constraint_error
171: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
172: When Others Then
173: ben_pel_shd.g_api_dml := false; -- Unset the api dml status
166: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
167: When hr_api.unique_integrity_violated Then
168: -- Unique integrity has been violated
169: ben_pel_shd.g_api_dml := false; -- Unset the api dml status
170: ben_pel_shd.constraint_error
171: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
172: When Others Then
173: ben_pel_shd.g_api_dml := false; -- Unset the api dml status
174: Raise;
169: ben_pel_shd.g_api_dml := false; -- Unset the api dml status
170: ben_pel_shd.constraint_error
171: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
172: When Others Then
173: ben_pel_shd.g_api_dml := false; -- Unset the api dml status
174: Raise;
175: End update_dml;
176: --
177: -- ----------------------------------------------------------------------------
205: -- Internal Row Handler Use Only.
206: --
207: -- {End Of Comments}
208: -- ----------------------------------------------------------------------------
209: Procedure pre_update(p_rec in ben_pel_shd.g_rec_type) is
210: --
211: l_proc varchar2(72) := g_package||'pre_update';
212: --
213: Begin
248: --
249: -- {End Of Comments}
250: -- ----------------------------------------------------------------------------
251: Procedure post_update(
252: p_effective_date in date,p_rec in ben_pel_shd.g_rec_type) is
253: --
254: l_proc varchar2(72) := g_package||'post_update';
255: --
256: Begin
342: ,p_object_version_number =>p_rec.object_version_number
343: ,p_effective_date =>p_effective_date
344: ,p_defer_deenrol_flag =>p_rec.defer_deenrol_flag
345: ,p_deenrol_made_dt =>p_rec.deenrol_made_dt
346: ,p_dflt_enrt_dt_o =>ben_pel_shd.g_old_rec.dflt_enrt_dt
347: ,p_dflt_asnd_dt_o =>ben_pel_shd.g_old_rec.dflt_asnd_dt
348: ,p_elcns_made_dt_o =>ben_pel_shd.g_old_rec.elcns_made_dt
349: ,p_cls_enrt_dt_to_use_cd_o =>ben_pel_shd.g_old_rec.cls_enrt_dt_to_use_cd
350: ,p_enrt_typ_cycl_cd_o =>ben_pel_shd.g_old_rec.enrt_typ_cycl_cd
343: ,p_effective_date =>p_effective_date
344: ,p_defer_deenrol_flag =>p_rec.defer_deenrol_flag
345: ,p_deenrol_made_dt =>p_rec.deenrol_made_dt
346: ,p_dflt_enrt_dt_o =>ben_pel_shd.g_old_rec.dflt_enrt_dt
347: ,p_dflt_asnd_dt_o =>ben_pel_shd.g_old_rec.dflt_asnd_dt
348: ,p_elcns_made_dt_o =>ben_pel_shd.g_old_rec.elcns_made_dt
349: ,p_cls_enrt_dt_to_use_cd_o =>ben_pel_shd.g_old_rec.cls_enrt_dt_to_use_cd
350: ,p_enrt_typ_cycl_cd_o =>ben_pel_shd.g_old_rec.enrt_typ_cycl_cd
351: ,p_enrt_perd_end_dt_o =>ben_pel_shd.g_old_rec.enrt_perd_end_dt
344: ,p_defer_deenrol_flag =>p_rec.defer_deenrol_flag
345: ,p_deenrol_made_dt =>p_rec.deenrol_made_dt
346: ,p_dflt_enrt_dt_o =>ben_pel_shd.g_old_rec.dflt_enrt_dt
347: ,p_dflt_asnd_dt_o =>ben_pel_shd.g_old_rec.dflt_asnd_dt
348: ,p_elcns_made_dt_o =>ben_pel_shd.g_old_rec.elcns_made_dt
349: ,p_cls_enrt_dt_to_use_cd_o =>ben_pel_shd.g_old_rec.cls_enrt_dt_to_use_cd
350: ,p_enrt_typ_cycl_cd_o =>ben_pel_shd.g_old_rec.enrt_typ_cycl_cd
351: ,p_enrt_perd_end_dt_o =>ben_pel_shd.g_old_rec.enrt_perd_end_dt
352: ,p_enrt_perd_strt_dt_o =>ben_pel_shd.g_old_rec.enrt_perd_strt_dt
345: ,p_deenrol_made_dt =>p_rec.deenrol_made_dt
346: ,p_dflt_enrt_dt_o =>ben_pel_shd.g_old_rec.dflt_enrt_dt
347: ,p_dflt_asnd_dt_o =>ben_pel_shd.g_old_rec.dflt_asnd_dt
348: ,p_elcns_made_dt_o =>ben_pel_shd.g_old_rec.elcns_made_dt
349: ,p_cls_enrt_dt_to_use_cd_o =>ben_pel_shd.g_old_rec.cls_enrt_dt_to_use_cd
350: ,p_enrt_typ_cycl_cd_o =>ben_pel_shd.g_old_rec.enrt_typ_cycl_cd
351: ,p_enrt_perd_end_dt_o =>ben_pel_shd.g_old_rec.enrt_perd_end_dt
352: ,p_enrt_perd_strt_dt_o =>ben_pel_shd.g_old_rec.enrt_perd_strt_dt
353: ,p_procg_end_dt_o =>ben_pel_shd.g_old_rec.procg_end_dt
346: ,p_dflt_enrt_dt_o =>ben_pel_shd.g_old_rec.dflt_enrt_dt
347: ,p_dflt_asnd_dt_o =>ben_pel_shd.g_old_rec.dflt_asnd_dt
348: ,p_elcns_made_dt_o =>ben_pel_shd.g_old_rec.elcns_made_dt
349: ,p_cls_enrt_dt_to_use_cd_o =>ben_pel_shd.g_old_rec.cls_enrt_dt_to_use_cd
350: ,p_enrt_typ_cycl_cd_o =>ben_pel_shd.g_old_rec.enrt_typ_cycl_cd
351: ,p_enrt_perd_end_dt_o =>ben_pel_shd.g_old_rec.enrt_perd_end_dt
352: ,p_enrt_perd_strt_dt_o =>ben_pel_shd.g_old_rec.enrt_perd_strt_dt
353: ,p_procg_end_dt_o =>ben_pel_shd.g_old_rec.procg_end_dt
354: ,p_pil_elctbl_popl_stat_cd_o =>ben_pel_shd.g_old_rec.pil_elctbl_popl_stat_cd
347: ,p_dflt_asnd_dt_o =>ben_pel_shd.g_old_rec.dflt_asnd_dt
348: ,p_elcns_made_dt_o =>ben_pel_shd.g_old_rec.elcns_made_dt
349: ,p_cls_enrt_dt_to_use_cd_o =>ben_pel_shd.g_old_rec.cls_enrt_dt_to_use_cd
350: ,p_enrt_typ_cycl_cd_o =>ben_pel_shd.g_old_rec.enrt_typ_cycl_cd
351: ,p_enrt_perd_end_dt_o =>ben_pel_shd.g_old_rec.enrt_perd_end_dt
352: ,p_enrt_perd_strt_dt_o =>ben_pel_shd.g_old_rec.enrt_perd_strt_dt
353: ,p_procg_end_dt_o =>ben_pel_shd.g_old_rec.procg_end_dt
354: ,p_pil_elctbl_popl_stat_cd_o =>ben_pel_shd.g_old_rec.pil_elctbl_popl_stat_cd
355: ,p_acty_ref_perd_cd_o =>ben_pel_shd.g_old_rec.acty_ref_perd_cd
348: ,p_elcns_made_dt_o =>ben_pel_shd.g_old_rec.elcns_made_dt
349: ,p_cls_enrt_dt_to_use_cd_o =>ben_pel_shd.g_old_rec.cls_enrt_dt_to_use_cd
350: ,p_enrt_typ_cycl_cd_o =>ben_pel_shd.g_old_rec.enrt_typ_cycl_cd
351: ,p_enrt_perd_end_dt_o =>ben_pel_shd.g_old_rec.enrt_perd_end_dt
352: ,p_enrt_perd_strt_dt_o =>ben_pel_shd.g_old_rec.enrt_perd_strt_dt
353: ,p_procg_end_dt_o =>ben_pel_shd.g_old_rec.procg_end_dt
354: ,p_pil_elctbl_popl_stat_cd_o =>ben_pel_shd.g_old_rec.pil_elctbl_popl_stat_cd
355: ,p_acty_ref_perd_cd_o =>ben_pel_shd.g_old_rec.acty_ref_perd_cd
356: ,p_uom_o =>ben_pel_shd.g_old_rec.uom
349: ,p_cls_enrt_dt_to_use_cd_o =>ben_pel_shd.g_old_rec.cls_enrt_dt_to_use_cd
350: ,p_enrt_typ_cycl_cd_o =>ben_pel_shd.g_old_rec.enrt_typ_cycl_cd
351: ,p_enrt_perd_end_dt_o =>ben_pel_shd.g_old_rec.enrt_perd_end_dt
352: ,p_enrt_perd_strt_dt_o =>ben_pel_shd.g_old_rec.enrt_perd_strt_dt
353: ,p_procg_end_dt_o =>ben_pel_shd.g_old_rec.procg_end_dt
354: ,p_pil_elctbl_popl_stat_cd_o =>ben_pel_shd.g_old_rec.pil_elctbl_popl_stat_cd
355: ,p_acty_ref_perd_cd_o =>ben_pel_shd.g_old_rec.acty_ref_perd_cd
356: ,p_uom_o =>ben_pel_shd.g_old_rec.uom
357: ,p_comments_o =>ben_pel_shd.g_old_rec.comments
350: ,p_enrt_typ_cycl_cd_o =>ben_pel_shd.g_old_rec.enrt_typ_cycl_cd
351: ,p_enrt_perd_end_dt_o =>ben_pel_shd.g_old_rec.enrt_perd_end_dt
352: ,p_enrt_perd_strt_dt_o =>ben_pel_shd.g_old_rec.enrt_perd_strt_dt
353: ,p_procg_end_dt_o =>ben_pel_shd.g_old_rec.procg_end_dt
354: ,p_pil_elctbl_popl_stat_cd_o =>ben_pel_shd.g_old_rec.pil_elctbl_popl_stat_cd
355: ,p_acty_ref_perd_cd_o =>ben_pel_shd.g_old_rec.acty_ref_perd_cd
356: ,p_uom_o =>ben_pel_shd.g_old_rec.uom
357: ,p_comments_o =>ben_pel_shd.g_old_rec.comments
358: ,p_mgr_ovrid_dt_o =>ben_pel_shd.g_old_rec.mgr_ovrid_dt
351: ,p_enrt_perd_end_dt_o =>ben_pel_shd.g_old_rec.enrt_perd_end_dt
352: ,p_enrt_perd_strt_dt_o =>ben_pel_shd.g_old_rec.enrt_perd_strt_dt
353: ,p_procg_end_dt_o =>ben_pel_shd.g_old_rec.procg_end_dt
354: ,p_pil_elctbl_popl_stat_cd_o =>ben_pel_shd.g_old_rec.pil_elctbl_popl_stat_cd
355: ,p_acty_ref_perd_cd_o =>ben_pel_shd.g_old_rec.acty_ref_perd_cd
356: ,p_uom_o =>ben_pel_shd.g_old_rec.uom
357: ,p_comments_o =>ben_pel_shd.g_old_rec.comments
358: ,p_mgr_ovrid_dt_o =>ben_pel_shd.g_old_rec.mgr_ovrid_dt
359: ,p_ws_mgr_id_o =>ben_pel_shd.g_old_rec.ws_mgr_id
352: ,p_enrt_perd_strt_dt_o =>ben_pel_shd.g_old_rec.enrt_perd_strt_dt
353: ,p_procg_end_dt_o =>ben_pel_shd.g_old_rec.procg_end_dt
354: ,p_pil_elctbl_popl_stat_cd_o =>ben_pel_shd.g_old_rec.pil_elctbl_popl_stat_cd
355: ,p_acty_ref_perd_cd_o =>ben_pel_shd.g_old_rec.acty_ref_perd_cd
356: ,p_uom_o =>ben_pel_shd.g_old_rec.uom
357: ,p_comments_o =>ben_pel_shd.g_old_rec.comments
358: ,p_mgr_ovrid_dt_o =>ben_pel_shd.g_old_rec.mgr_ovrid_dt
359: ,p_ws_mgr_id_o =>ben_pel_shd.g_old_rec.ws_mgr_id
360: ,p_mgr_ovrid_person_id_o =>ben_pel_shd.g_old_rec.mgr_ovrid_person_id
353: ,p_procg_end_dt_o =>ben_pel_shd.g_old_rec.procg_end_dt
354: ,p_pil_elctbl_popl_stat_cd_o =>ben_pel_shd.g_old_rec.pil_elctbl_popl_stat_cd
355: ,p_acty_ref_perd_cd_o =>ben_pel_shd.g_old_rec.acty_ref_perd_cd
356: ,p_uom_o =>ben_pel_shd.g_old_rec.uom
357: ,p_comments_o =>ben_pel_shd.g_old_rec.comments
358: ,p_mgr_ovrid_dt_o =>ben_pel_shd.g_old_rec.mgr_ovrid_dt
359: ,p_ws_mgr_id_o =>ben_pel_shd.g_old_rec.ws_mgr_id
360: ,p_mgr_ovrid_person_id_o =>ben_pel_shd.g_old_rec.mgr_ovrid_person_id
361: ,p_assignment_id_o =>ben_pel_shd.g_old_rec.assignment_id
354: ,p_pil_elctbl_popl_stat_cd_o =>ben_pel_shd.g_old_rec.pil_elctbl_popl_stat_cd
355: ,p_acty_ref_perd_cd_o =>ben_pel_shd.g_old_rec.acty_ref_perd_cd
356: ,p_uom_o =>ben_pel_shd.g_old_rec.uom
357: ,p_comments_o =>ben_pel_shd.g_old_rec.comments
358: ,p_mgr_ovrid_dt_o =>ben_pel_shd.g_old_rec.mgr_ovrid_dt
359: ,p_ws_mgr_id_o =>ben_pel_shd.g_old_rec.ws_mgr_id
360: ,p_mgr_ovrid_person_id_o =>ben_pel_shd.g_old_rec.mgr_ovrid_person_id
361: ,p_assignment_id_o =>ben_pel_shd.g_old_rec.assignment_id
362: --cwb
355: ,p_acty_ref_perd_cd_o =>ben_pel_shd.g_old_rec.acty_ref_perd_cd
356: ,p_uom_o =>ben_pel_shd.g_old_rec.uom
357: ,p_comments_o =>ben_pel_shd.g_old_rec.comments
358: ,p_mgr_ovrid_dt_o =>ben_pel_shd.g_old_rec.mgr_ovrid_dt
359: ,p_ws_mgr_id_o =>ben_pel_shd.g_old_rec.ws_mgr_id
360: ,p_mgr_ovrid_person_id_o =>ben_pel_shd.g_old_rec.mgr_ovrid_person_id
361: ,p_assignment_id_o =>ben_pel_shd.g_old_rec.assignment_id
362: --cwb
363: ,p_bdgt_acc_cd_o =>ben_pel_shd.g_old_rec.bdgt_acc_cd
356: ,p_uom_o =>ben_pel_shd.g_old_rec.uom
357: ,p_comments_o =>ben_pel_shd.g_old_rec.comments
358: ,p_mgr_ovrid_dt_o =>ben_pel_shd.g_old_rec.mgr_ovrid_dt
359: ,p_ws_mgr_id_o =>ben_pel_shd.g_old_rec.ws_mgr_id
360: ,p_mgr_ovrid_person_id_o =>ben_pel_shd.g_old_rec.mgr_ovrid_person_id
361: ,p_assignment_id_o =>ben_pel_shd.g_old_rec.assignment_id
362: --cwb
363: ,p_bdgt_acc_cd_o =>ben_pel_shd.g_old_rec.bdgt_acc_cd
364: ,p_pop_cd_o =>ben_pel_shd.g_old_rec.pop_cd
357: ,p_comments_o =>ben_pel_shd.g_old_rec.comments
358: ,p_mgr_ovrid_dt_o =>ben_pel_shd.g_old_rec.mgr_ovrid_dt
359: ,p_ws_mgr_id_o =>ben_pel_shd.g_old_rec.ws_mgr_id
360: ,p_mgr_ovrid_person_id_o =>ben_pel_shd.g_old_rec.mgr_ovrid_person_id
361: ,p_assignment_id_o =>ben_pel_shd.g_old_rec.assignment_id
362: --cwb
363: ,p_bdgt_acc_cd_o =>ben_pel_shd.g_old_rec.bdgt_acc_cd
364: ,p_pop_cd_o =>ben_pel_shd.g_old_rec.pop_cd
365: ,p_bdgt_due_dt_o =>ben_pel_shd.g_old_rec.bdgt_due_dt
359: ,p_ws_mgr_id_o =>ben_pel_shd.g_old_rec.ws_mgr_id
360: ,p_mgr_ovrid_person_id_o =>ben_pel_shd.g_old_rec.mgr_ovrid_person_id
361: ,p_assignment_id_o =>ben_pel_shd.g_old_rec.assignment_id
362: --cwb
363: ,p_bdgt_acc_cd_o =>ben_pel_shd.g_old_rec.bdgt_acc_cd
364: ,p_pop_cd_o =>ben_pel_shd.g_old_rec.pop_cd
365: ,p_bdgt_due_dt_o =>ben_pel_shd.g_old_rec.bdgt_due_dt
366: ,p_bdgt_export_flag_o =>ben_pel_shd.g_old_rec.bdgt_export_flag
367: ,p_bdgt_iss_dt_o =>ben_pel_shd.g_old_rec.bdgt_iss_dt
360: ,p_mgr_ovrid_person_id_o =>ben_pel_shd.g_old_rec.mgr_ovrid_person_id
361: ,p_assignment_id_o =>ben_pel_shd.g_old_rec.assignment_id
362: --cwb
363: ,p_bdgt_acc_cd_o =>ben_pel_shd.g_old_rec.bdgt_acc_cd
364: ,p_pop_cd_o =>ben_pel_shd.g_old_rec.pop_cd
365: ,p_bdgt_due_dt_o =>ben_pel_shd.g_old_rec.bdgt_due_dt
366: ,p_bdgt_export_flag_o =>ben_pel_shd.g_old_rec.bdgt_export_flag
367: ,p_bdgt_iss_dt_o =>ben_pel_shd.g_old_rec.bdgt_iss_dt
368: ,p_bdgt_stat_cd_o =>ben_pel_shd.g_old_rec.bdgt_stat_cd
361: ,p_assignment_id_o =>ben_pel_shd.g_old_rec.assignment_id
362: --cwb
363: ,p_bdgt_acc_cd_o =>ben_pel_shd.g_old_rec.bdgt_acc_cd
364: ,p_pop_cd_o =>ben_pel_shd.g_old_rec.pop_cd
365: ,p_bdgt_due_dt_o =>ben_pel_shd.g_old_rec.bdgt_due_dt
366: ,p_bdgt_export_flag_o =>ben_pel_shd.g_old_rec.bdgt_export_flag
367: ,p_bdgt_iss_dt_o =>ben_pel_shd.g_old_rec.bdgt_iss_dt
368: ,p_bdgt_stat_cd_o =>ben_pel_shd.g_old_rec.bdgt_stat_cd
369: ,p_ws_acc_cd_o =>ben_pel_shd.g_old_rec.ws_acc_cd
362: --cwb
363: ,p_bdgt_acc_cd_o =>ben_pel_shd.g_old_rec.bdgt_acc_cd
364: ,p_pop_cd_o =>ben_pel_shd.g_old_rec.pop_cd
365: ,p_bdgt_due_dt_o =>ben_pel_shd.g_old_rec.bdgt_due_dt
366: ,p_bdgt_export_flag_o =>ben_pel_shd.g_old_rec.bdgt_export_flag
367: ,p_bdgt_iss_dt_o =>ben_pel_shd.g_old_rec.bdgt_iss_dt
368: ,p_bdgt_stat_cd_o =>ben_pel_shd.g_old_rec.bdgt_stat_cd
369: ,p_ws_acc_cd_o =>ben_pel_shd.g_old_rec.ws_acc_cd
370: ,p_ws_due_dt_o =>ben_pel_shd.g_old_rec.ws_due_dt
363: ,p_bdgt_acc_cd_o =>ben_pel_shd.g_old_rec.bdgt_acc_cd
364: ,p_pop_cd_o =>ben_pel_shd.g_old_rec.pop_cd
365: ,p_bdgt_due_dt_o =>ben_pel_shd.g_old_rec.bdgt_due_dt
366: ,p_bdgt_export_flag_o =>ben_pel_shd.g_old_rec.bdgt_export_flag
367: ,p_bdgt_iss_dt_o =>ben_pel_shd.g_old_rec.bdgt_iss_dt
368: ,p_bdgt_stat_cd_o =>ben_pel_shd.g_old_rec.bdgt_stat_cd
369: ,p_ws_acc_cd_o =>ben_pel_shd.g_old_rec.ws_acc_cd
370: ,p_ws_due_dt_o =>ben_pel_shd.g_old_rec.ws_due_dt
371: ,p_ws_export_flag_o =>ben_pel_shd.g_old_rec.ws_export_flag
364: ,p_pop_cd_o =>ben_pel_shd.g_old_rec.pop_cd
365: ,p_bdgt_due_dt_o =>ben_pel_shd.g_old_rec.bdgt_due_dt
366: ,p_bdgt_export_flag_o =>ben_pel_shd.g_old_rec.bdgt_export_flag
367: ,p_bdgt_iss_dt_o =>ben_pel_shd.g_old_rec.bdgt_iss_dt
368: ,p_bdgt_stat_cd_o =>ben_pel_shd.g_old_rec.bdgt_stat_cd
369: ,p_ws_acc_cd_o =>ben_pel_shd.g_old_rec.ws_acc_cd
370: ,p_ws_due_dt_o =>ben_pel_shd.g_old_rec.ws_due_dt
371: ,p_ws_export_flag_o =>ben_pel_shd.g_old_rec.ws_export_flag
372: ,p_ws_iss_dt_o =>ben_pel_shd.g_old_rec.ws_iss_dt
365: ,p_bdgt_due_dt_o =>ben_pel_shd.g_old_rec.bdgt_due_dt
366: ,p_bdgt_export_flag_o =>ben_pel_shd.g_old_rec.bdgt_export_flag
367: ,p_bdgt_iss_dt_o =>ben_pel_shd.g_old_rec.bdgt_iss_dt
368: ,p_bdgt_stat_cd_o =>ben_pel_shd.g_old_rec.bdgt_stat_cd
369: ,p_ws_acc_cd_o =>ben_pel_shd.g_old_rec.ws_acc_cd
370: ,p_ws_due_dt_o =>ben_pel_shd.g_old_rec.ws_due_dt
371: ,p_ws_export_flag_o =>ben_pel_shd.g_old_rec.ws_export_flag
372: ,p_ws_iss_dt_o =>ben_pel_shd.g_old_rec.ws_iss_dt
373: ,p_ws_stat_cd_o =>ben_pel_shd.g_old_rec.ws_stat_cd
366: ,p_bdgt_export_flag_o =>ben_pel_shd.g_old_rec.bdgt_export_flag
367: ,p_bdgt_iss_dt_o =>ben_pel_shd.g_old_rec.bdgt_iss_dt
368: ,p_bdgt_stat_cd_o =>ben_pel_shd.g_old_rec.bdgt_stat_cd
369: ,p_ws_acc_cd_o =>ben_pel_shd.g_old_rec.ws_acc_cd
370: ,p_ws_due_dt_o =>ben_pel_shd.g_old_rec.ws_due_dt
371: ,p_ws_export_flag_o =>ben_pel_shd.g_old_rec.ws_export_flag
372: ,p_ws_iss_dt_o =>ben_pel_shd.g_old_rec.ws_iss_dt
373: ,p_ws_stat_cd_o =>ben_pel_shd.g_old_rec.ws_stat_cd
374: --cwb
367: ,p_bdgt_iss_dt_o =>ben_pel_shd.g_old_rec.bdgt_iss_dt
368: ,p_bdgt_stat_cd_o =>ben_pel_shd.g_old_rec.bdgt_stat_cd
369: ,p_ws_acc_cd_o =>ben_pel_shd.g_old_rec.ws_acc_cd
370: ,p_ws_due_dt_o =>ben_pel_shd.g_old_rec.ws_due_dt
371: ,p_ws_export_flag_o =>ben_pel_shd.g_old_rec.ws_export_flag
372: ,p_ws_iss_dt_o =>ben_pel_shd.g_old_rec.ws_iss_dt
373: ,p_ws_stat_cd_o =>ben_pel_shd.g_old_rec.ws_stat_cd
374: --cwb
375: ,p_reinstate_cd_o =>ben_pel_shd.g_old_rec.reinstate_cd
368: ,p_bdgt_stat_cd_o =>ben_pel_shd.g_old_rec.bdgt_stat_cd
369: ,p_ws_acc_cd_o =>ben_pel_shd.g_old_rec.ws_acc_cd
370: ,p_ws_due_dt_o =>ben_pel_shd.g_old_rec.ws_due_dt
371: ,p_ws_export_flag_o =>ben_pel_shd.g_old_rec.ws_export_flag
372: ,p_ws_iss_dt_o =>ben_pel_shd.g_old_rec.ws_iss_dt
373: ,p_ws_stat_cd_o =>ben_pel_shd.g_old_rec.ws_stat_cd
374: --cwb
375: ,p_reinstate_cd_o =>ben_pel_shd.g_old_rec.reinstate_cd
376: ,p_reinstate_ovrdn_cd_o =>ben_pel_shd.g_old_rec.reinstate_ovrdn_cd
369: ,p_ws_acc_cd_o =>ben_pel_shd.g_old_rec.ws_acc_cd
370: ,p_ws_due_dt_o =>ben_pel_shd.g_old_rec.ws_due_dt
371: ,p_ws_export_flag_o =>ben_pel_shd.g_old_rec.ws_export_flag
372: ,p_ws_iss_dt_o =>ben_pel_shd.g_old_rec.ws_iss_dt
373: ,p_ws_stat_cd_o =>ben_pel_shd.g_old_rec.ws_stat_cd
374: --cwb
375: ,p_reinstate_cd_o =>ben_pel_shd.g_old_rec.reinstate_cd
376: ,p_reinstate_ovrdn_cd_o =>ben_pel_shd.g_old_rec.reinstate_ovrdn_cd
377: ,p_auto_asnd_dt_o =>ben_pel_shd.g_old_rec.auto_asnd_dt
371: ,p_ws_export_flag_o =>ben_pel_shd.g_old_rec.ws_export_flag
372: ,p_ws_iss_dt_o =>ben_pel_shd.g_old_rec.ws_iss_dt
373: ,p_ws_stat_cd_o =>ben_pel_shd.g_old_rec.ws_stat_cd
374: --cwb
375: ,p_reinstate_cd_o =>ben_pel_shd.g_old_rec.reinstate_cd
376: ,p_reinstate_ovrdn_cd_o =>ben_pel_shd.g_old_rec.reinstate_ovrdn_cd
377: ,p_auto_asnd_dt_o =>ben_pel_shd.g_old_rec.auto_asnd_dt
378: ,p_cbr_elig_perd_strt_dt_o =>ben_pel_shd.g_old_rec.cbr_elig_perd_strt_dt
379: ,p_cbr_elig_perd_end_dt_o =>ben_pel_shd.g_old_rec.cbr_elig_perd_end_dt
372: ,p_ws_iss_dt_o =>ben_pel_shd.g_old_rec.ws_iss_dt
373: ,p_ws_stat_cd_o =>ben_pel_shd.g_old_rec.ws_stat_cd
374: --cwb
375: ,p_reinstate_cd_o =>ben_pel_shd.g_old_rec.reinstate_cd
376: ,p_reinstate_ovrdn_cd_o =>ben_pel_shd.g_old_rec.reinstate_ovrdn_cd
377: ,p_auto_asnd_dt_o =>ben_pel_shd.g_old_rec.auto_asnd_dt
378: ,p_cbr_elig_perd_strt_dt_o =>ben_pel_shd.g_old_rec.cbr_elig_perd_strt_dt
379: ,p_cbr_elig_perd_end_dt_o =>ben_pel_shd.g_old_rec.cbr_elig_perd_end_dt
380: ,p_lee_rsn_id_o =>ben_pel_shd.g_old_rec.lee_rsn_id
373: ,p_ws_stat_cd_o =>ben_pel_shd.g_old_rec.ws_stat_cd
374: --cwb
375: ,p_reinstate_cd_o =>ben_pel_shd.g_old_rec.reinstate_cd
376: ,p_reinstate_ovrdn_cd_o =>ben_pel_shd.g_old_rec.reinstate_ovrdn_cd
377: ,p_auto_asnd_dt_o =>ben_pel_shd.g_old_rec.auto_asnd_dt
378: ,p_cbr_elig_perd_strt_dt_o =>ben_pel_shd.g_old_rec.cbr_elig_perd_strt_dt
379: ,p_cbr_elig_perd_end_dt_o =>ben_pel_shd.g_old_rec.cbr_elig_perd_end_dt
380: ,p_lee_rsn_id_o =>ben_pel_shd.g_old_rec.lee_rsn_id
381: ,p_enrt_perd_id_o =>ben_pel_shd.g_old_rec.enrt_perd_id
374: --cwb
375: ,p_reinstate_cd_o =>ben_pel_shd.g_old_rec.reinstate_cd
376: ,p_reinstate_ovrdn_cd_o =>ben_pel_shd.g_old_rec.reinstate_ovrdn_cd
377: ,p_auto_asnd_dt_o =>ben_pel_shd.g_old_rec.auto_asnd_dt
378: ,p_cbr_elig_perd_strt_dt_o =>ben_pel_shd.g_old_rec.cbr_elig_perd_strt_dt
379: ,p_cbr_elig_perd_end_dt_o =>ben_pel_shd.g_old_rec.cbr_elig_perd_end_dt
380: ,p_lee_rsn_id_o =>ben_pel_shd.g_old_rec.lee_rsn_id
381: ,p_enrt_perd_id_o =>ben_pel_shd.g_old_rec.enrt_perd_id
382: ,p_per_in_ler_id_o =>ben_pel_shd.g_old_rec.per_in_ler_id
375: ,p_reinstate_cd_o =>ben_pel_shd.g_old_rec.reinstate_cd
376: ,p_reinstate_ovrdn_cd_o =>ben_pel_shd.g_old_rec.reinstate_ovrdn_cd
377: ,p_auto_asnd_dt_o =>ben_pel_shd.g_old_rec.auto_asnd_dt
378: ,p_cbr_elig_perd_strt_dt_o =>ben_pel_shd.g_old_rec.cbr_elig_perd_strt_dt
379: ,p_cbr_elig_perd_end_dt_o =>ben_pel_shd.g_old_rec.cbr_elig_perd_end_dt
380: ,p_lee_rsn_id_o =>ben_pel_shd.g_old_rec.lee_rsn_id
381: ,p_enrt_perd_id_o =>ben_pel_shd.g_old_rec.enrt_perd_id
382: ,p_per_in_ler_id_o =>ben_pel_shd.g_old_rec.per_in_ler_id
383: ,p_pgm_id_o =>ben_pel_shd.g_old_rec.pgm_id
376: ,p_reinstate_ovrdn_cd_o =>ben_pel_shd.g_old_rec.reinstate_ovrdn_cd
377: ,p_auto_asnd_dt_o =>ben_pel_shd.g_old_rec.auto_asnd_dt
378: ,p_cbr_elig_perd_strt_dt_o =>ben_pel_shd.g_old_rec.cbr_elig_perd_strt_dt
379: ,p_cbr_elig_perd_end_dt_o =>ben_pel_shd.g_old_rec.cbr_elig_perd_end_dt
380: ,p_lee_rsn_id_o =>ben_pel_shd.g_old_rec.lee_rsn_id
381: ,p_enrt_perd_id_o =>ben_pel_shd.g_old_rec.enrt_perd_id
382: ,p_per_in_ler_id_o =>ben_pel_shd.g_old_rec.per_in_ler_id
383: ,p_pgm_id_o =>ben_pel_shd.g_old_rec.pgm_id
384: ,p_pl_id_o =>ben_pel_shd.g_old_rec.pl_id
377: ,p_auto_asnd_dt_o =>ben_pel_shd.g_old_rec.auto_asnd_dt
378: ,p_cbr_elig_perd_strt_dt_o =>ben_pel_shd.g_old_rec.cbr_elig_perd_strt_dt
379: ,p_cbr_elig_perd_end_dt_o =>ben_pel_shd.g_old_rec.cbr_elig_perd_end_dt
380: ,p_lee_rsn_id_o =>ben_pel_shd.g_old_rec.lee_rsn_id
381: ,p_enrt_perd_id_o =>ben_pel_shd.g_old_rec.enrt_perd_id
382: ,p_per_in_ler_id_o =>ben_pel_shd.g_old_rec.per_in_ler_id
383: ,p_pgm_id_o =>ben_pel_shd.g_old_rec.pgm_id
384: ,p_pl_id_o =>ben_pel_shd.g_old_rec.pl_id
385: ,p_business_group_id_o =>ben_pel_shd.g_old_rec.business_group_id
378: ,p_cbr_elig_perd_strt_dt_o =>ben_pel_shd.g_old_rec.cbr_elig_perd_strt_dt
379: ,p_cbr_elig_perd_end_dt_o =>ben_pel_shd.g_old_rec.cbr_elig_perd_end_dt
380: ,p_lee_rsn_id_o =>ben_pel_shd.g_old_rec.lee_rsn_id
381: ,p_enrt_perd_id_o =>ben_pel_shd.g_old_rec.enrt_perd_id
382: ,p_per_in_ler_id_o =>ben_pel_shd.g_old_rec.per_in_ler_id
383: ,p_pgm_id_o =>ben_pel_shd.g_old_rec.pgm_id
384: ,p_pl_id_o =>ben_pel_shd.g_old_rec.pl_id
385: ,p_business_group_id_o =>ben_pel_shd.g_old_rec.business_group_id
386: ,p_pel_attribute_category_o =>ben_pel_shd.g_old_rec.pel_attribute_category
379: ,p_cbr_elig_perd_end_dt_o =>ben_pel_shd.g_old_rec.cbr_elig_perd_end_dt
380: ,p_lee_rsn_id_o =>ben_pel_shd.g_old_rec.lee_rsn_id
381: ,p_enrt_perd_id_o =>ben_pel_shd.g_old_rec.enrt_perd_id
382: ,p_per_in_ler_id_o =>ben_pel_shd.g_old_rec.per_in_ler_id
383: ,p_pgm_id_o =>ben_pel_shd.g_old_rec.pgm_id
384: ,p_pl_id_o =>ben_pel_shd.g_old_rec.pl_id
385: ,p_business_group_id_o =>ben_pel_shd.g_old_rec.business_group_id
386: ,p_pel_attribute_category_o =>ben_pel_shd.g_old_rec.pel_attribute_category
387: ,p_pel_attribute1_o =>ben_pel_shd.g_old_rec.pel_attribute1
380: ,p_lee_rsn_id_o =>ben_pel_shd.g_old_rec.lee_rsn_id
381: ,p_enrt_perd_id_o =>ben_pel_shd.g_old_rec.enrt_perd_id
382: ,p_per_in_ler_id_o =>ben_pel_shd.g_old_rec.per_in_ler_id
383: ,p_pgm_id_o =>ben_pel_shd.g_old_rec.pgm_id
384: ,p_pl_id_o =>ben_pel_shd.g_old_rec.pl_id
385: ,p_business_group_id_o =>ben_pel_shd.g_old_rec.business_group_id
386: ,p_pel_attribute_category_o =>ben_pel_shd.g_old_rec.pel_attribute_category
387: ,p_pel_attribute1_o =>ben_pel_shd.g_old_rec.pel_attribute1
388: ,p_pel_attribute2_o =>ben_pel_shd.g_old_rec.pel_attribute2
381: ,p_enrt_perd_id_o =>ben_pel_shd.g_old_rec.enrt_perd_id
382: ,p_per_in_ler_id_o =>ben_pel_shd.g_old_rec.per_in_ler_id
383: ,p_pgm_id_o =>ben_pel_shd.g_old_rec.pgm_id
384: ,p_pl_id_o =>ben_pel_shd.g_old_rec.pl_id
385: ,p_business_group_id_o =>ben_pel_shd.g_old_rec.business_group_id
386: ,p_pel_attribute_category_o =>ben_pel_shd.g_old_rec.pel_attribute_category
387: ,p_pel_attribute1_o =>ben_pel_shd.g_old_rec.pel_attribute1
388: ,p_pel_attribute2_o =>ben_pel_shd.g_old_rec.pel_attribute2
389: ,p_pel_attribute3_o =>ben_pel_shd.g_old_rec.pel_attribute3
382: ,p_per_in_ler_id_o =>ben_pel_shd.g_old_rec.per_in_ler_id
383: ,p_pgm_id_o =>ben_pel_shd.g_old_rec.pgm_id
384: ,p_pl_id_o =>ben_pel_shd.g_old_rec.pl_id
385: ,p_business_group_id_o =>ben_pel_shd.g_old_rec.business_group_id
386: ,p_pel_attribute_category_o =>ben_pel_shd.g_old_rec.pel_attribute_category
387: ,p_pel_attribute1_o =>ben_pel_shd.g_old_rec.pel_attribute1
388: ,p_pel_attribute2_o =>ben_pel_shd.g_old_rec.pel_attribute2
389: ,p_pel_attribute3_o =>ben_pel_shd.g_old_rec.pel_attribute3
390: ,p_pel_attribute4_o =>ben_pel_shd.g_old_rec.pel_attribute4
383: ,p_pgm_id_o =>ben_pel_shd.g_old_rec.pgm_id
384: ,p_pl_id_o =>ben_pel_shd.g_old_rec.pl_id
385: ,p_business_group_id_o =>ben_pel_shd.g_old_rec.business_group_id
386: ,p_pel_attribute_category_o =>ben_pel_shd.g_old_rec.pel_attribute_category
387: ,p_pel_attribute1_o =>ben_pel_shd.g_old_rec.pel_attribute1
388: ,p_pel_attribute2_o =>ben_pel_shd.g_old_rec.pel_attribute2
389: ,p_pel_attribute3_o =>ben_pel_shd.g_old_rec.pel_attribute3
390: ,p_pel_attribute4_o =>ben_pel_shd.g_old_rec.pel_attribute4
391: ,p_pel_attribute5_o =>ben_pel_shd.g_old_rec.pel_attribute5
384: ,p_pl_id_o =>ben_pel_shd.g_old_rec.pl_id
385: ,p_business_group_id_o =>ben_pel_shd.g_old_rec.business_group_id
386: ,p_pel_attribute_category_o =>ben_pel_shd.g_old_rec.pel_attribute_category
387: ,p_pel_attribute1_o =>ben_pel_shd.g_old_rec.pel_attribute1
388: ,p_pel_attribute2_o =>ben_pel_shd.g_old_rec.pel_attribute2
389: ,p_pel_attribute3_o =>ben_pel_shd.g_old_rec.pel_attribute3
390: ,p_pel_attribute4_o =>ben_pel_shd.g_old_rec.pel_attribute4
391: ,p_pel_attribute5_o =>ben_pel_shd.g_old_rec.pel_attribute5
392: ,p_pel_attribute6_o =>ben_pel_shd.g_old_rec.pel_attribute6
385: ,p_business_group_id_o =>ben_pel_shd.g_old_rec.business_group_id
386: ,p_pel_attribute_category_o =>ben_pel_shd.g_old_rec.pel_attribute_category
387: ,p_pel_attribute1_o =>ben_pel_shd.g_old_rec.pel_attribute1
388: ,p_pel_attribute2_o =>ben_pel_shd.g_old_rec.pel_attribute2
389: ,p_pel_attribute3_o =>ben_pel_shd.g_old_rec.pel_attribute3
390: ,p_pel_attribute4_o =>ben_pel_shd.g_old_rec.pel_attribute4
391: ,p_pel_attribute5_o =>ben_pel_shd.g_old_rec.pel_attribute5
392: ,p_pel_attribute6_o =>ben_pel_shd.g_old_rec.pel_attribute6
393: ,p_pel_attribute7_o =>ben_pel_shd.g_old_rec.pel_attribute7
386: ,p_pel_attribute_category_o =>ben_pel_shd.g_old_rec.pel_attribute_category
387: ,p_pel_attribute1_o =>ben_pel_shd.g_old_rec.pel_attribute1
388: ,p_pel_attribute2_o =>ben_pel_shd.g_old_rec.pel_attribute2
389: ,p_pel_attribute3_o =>ben_pel_shd.g_old_rec.pel_attribute3
390: ,p_pel_attribute4_o =>ben_pel_shd.g_old_rec.pel_attribute4
391: ,p_pel_attribute5_o =>ben_pel_shd.g_old_rec.pel_attribute5
392: ,p_pel_attribute6_o =>ben_pel_shd.g_old_rec.pel_attribute6
393: ,p_pel_attribute7_o =>ben_pel_shd.g_old_rec.pel_attribute7
394: ,p_pel_attribute8_o =>ben_pel_shd.g_old_rec.pel_attribute8
387: ,p_pel_attribute1_o =>ben_pel_shd.g_old_rec.pel_attribute1
388: ,p_pel_attribute2_o =>ben_pel_shd.g_old_rec.pel_attribute2
389: ,p_pel_attribute3_o =>ben_pel_shd.g_old_rec.pel_attribute3
390: ,p_pel_attribute4_o =>ben_pel_shd.g_old_rec.pel_attribute4
391: ,p_pel_attribute5_o =>ben_pel_shd.g_old_rec.pel_attribute5
392: ,p_pel_attribute6_o =>ben_pel_shd.g_old_rec.pel_attribute6
393: ,p_pel_attribute7_o =>ben_pel_shd.g_old_rec.pel_attribute7
394: ,p_pel_attribute8_o =>ben_pel_shd.g_old_rec.pel_attribute8
395: ,p_pel_attribute9_o =>ben_pel_shd.g_old_rec.pel_attribute9
388: ,p_pel_attribute2_o =>ben_pel_shd.g_old_rec.pel_attribute2
389: ,p_pel_attribute3_o =>ben_pel_shd.g_old_rec.pel_attribute3
390: ,p_pel_attribute4_o =>ben_pel_shd.g_old_rec.pel_attribute4
391: ,p_pel_attribute5_o =>ben_pel_shd.g_old_rec.pel_attribute5
392: ,p_pel_attribute6_o =>ben_pel_shd.g_old_rec.pel_attribute6
393: ,p_pel_attribute7_o =>ben_pel_shd.g_old_rec.pel_attribute7
394: ,p_pel_attribute8_o =>ben_pel_shd.g_old_rec.pel_attribute8
395: ,p_pel_attribute9_o =>ben_pel_shd.g_old_rec.pel_attribute9
396: ,p_pel_attribute10_o =>ben_pel_shd.g_old_rec.pel_attribute10
389: ,p_pel_attribute3_o =>ben_pel_shd.g_old_rec.pel_attribute3
390: ,p_pel_attribute4_o =>ben_pel_shd.g_old_rec.pel_attribute4
391: ,p_pel_attribute5_o =>ben_pel_shd.g_old_rec.pel_attribute5
392: ,p_pel_attribute6_o =>ben_pel_shd.g_old_rec.pel_attribute6
393: ,p_pel_attribute7_o =>ben_pel_shd.g_old_rec.pel_attribute7
394: ,p_pel_attribute8_o =>ben_pel_shd.g_old_rec.pel_attribute8
395: ,p_pel_attribute9_o =>ben_pel_shd.g_old_rec.pel_attribute9
396: ,p_pel_attribute10_o =>ben_pel_shd.g_old_rec.pel_attribute10
397: ,p_pel_attribute11_o =>ben_pel_shd.g_old_rec.pel_attribute11
390: ,p_pel_attribute4_o =>ben_pel_shd.g_old_rec.pel_attribute4
391: ,p_pel_attribute5_o =>ben_pel_shd.g_old_rec.pel_attribute5
392: ,p_pel_attribute6_o =>ben_pel_shd.g_old_rec.pel_attribute6
393: ,p_pel_attribute7_o =>ben_pel_shd.g_old_rec.pel_attribute7
394: ,p_pel_attribute8_o =>ben_pel_shd.g_old_rec.pel_attribute8
395: ,p_pel_attribute9_o =>ben_pel_shd.g_old_rec.pel_attribute9
396: ,p_pel_attribute10_o =>ben_pel_shd.g_old_rec.pel_attribute10
397: ,p_pel_attribute11_o =>ben_pel_shd.g_old_rec.pel_attribute11
398: ,p_pel_attribute12_o =>ben_pel_shd.g_old_rec.pel_attribute12
391: ,p_pel_attribute5_o =>ben_pel_shd.g_old_rec.pel_attribute5
392: ,p_pel_attribute6_o =>ben_pel_shd.g_old_rec.pel_attribute6
393: ,p_pel_attribute7_o =>ben_pel_shd.g_old_rec.pel_attribute7
394: ,p_pel_attribute8_o =>ben_pel_shd.g_old_rec.pel_attribute8
395: ,p_pel_attribute9_o =>ben_pel_shd.g_old_rec.pel_attribute9
396: ,p_pel_attribute10_o =>ben_pel_shd.g_old_rec.pel_attribute10
397: ,p_pel_attribute11_o =>ben_pel_shd.g_old_rec.pel_attribute11
398: ,p_pel_attribute12_o =>ben_pel_shd.g_old_rec.pel_attribute12
399: ,p_pel_attribute13_o =>ben_pel_shd.g_old_rec.pel_attribute13
392: ,p_pel_attribute6_o =>ben_pel_shd.g_old_rec.pel_attribute6
393: ,p_pel_attribute7_o =>ben_pel_shd.g_old_rec.pel_attribute7
394: ,p_pel_attribute8_o =>ben_pel_shd.g_old_rec.pel_attribute8
395: ,p_pel_attribute9_o =>ben_pel_shd.g_old_rec.pel_attribute9
396: ,p_pel_attribute10_o =>ben_pel_shd.g_old_rec.pel_attribute10
397: ,p_pel_attribute11_o =>ben_pel_shd.g_old_rec.pel_attribute11
398: ,p_pel_attribute12_o =>ben_pel_shd.g_old_rec.pel_attribute12
399: ,p_pel_attribute13_o =>ben_pel_shd.g_old_rec.pel_attribute13
400: ,p_pel_attribute14_o =>ben_pel_shd.g_old_rec.pel_attribute14
393: ,p_pel_attribute7_o =>ben_pel_shd.g_old_rec.pel_attribute7
394: ,p_pel_attribute8_o =>ben_pel_shd.g_old_rec.pel_attribute8
395: ,p_pel_attribute9_o =>ben_pel_shd.g_old_rec.pel_attribute9
396: ,p_pel_attribute10_o =>ben_pel_shd.g_old_rec.pel_attribute10
397: ,p_pel_attribute11_o =>ben_pel_shd.g_old_rec.pel_attribute11
398: ,p_pel_attribute12_o =>ben_pel_shd.g_old_rec.pel_attribute12
399: ,p_pel_attribute13_o =>ben_pel_shd.g_old_rec.pel_attribute13
400: ,p_pel_attribute14_o =>ben_pel_shd.g_old_rec.pel_attribute14
401: ,p_pel_attribute15_o =>ben_pel_shd.g_old_rec.pel_attribute15
394: ,p_pel_attribute8_o =>ben_pel_shd.g_old_rec.pel_attribute8
395: ,p_pel_attribute9_o =>ben_pel_shd.g_old_rec.pel_attribute9
396: ,p_pel_attribute10_o =>ben_pel_shd.g_old_rec.pel_attribute10
397: ,p_pel_attribute11_o =>ben_pel_shd.g_old_rec.pel_attribute11
398: ,p_pel_attribute12_o =>ben_pel_shd.g_old_rec.pel_attribute12
399: ,p_pel_attribute13_o =>ben_pel_shd.g_old_rec.pel_attribute13
400: ,p_pel_attribute14_o =>ben_pel_shd.g_old_rec.pel_attribute14
401: ,p_pel_attribute15_o =>ben_pel_shd.g_old_rec.pel_attribute15
402: ,p_pel_attribute16_o =>ben_pel_shd.g_old_rec.pel_attribute16
395: ,p_pel_attribute9_o =>ben_pel_shd.g_old_rec.pel_attribute9
396: ,p_pel_attribute10_o =>ben_pel_shd.g_old_rec.pel_attribute10
397: ,p_pel_attribute11_o =>ben_pel_shd.g_old_rec.pel_attribute11
398: ,p_pel_attribute12_o =>ben_pel_shd.g_old_rec.pel_attribute12
399: ,p_pel_attribute13_o =>ben_pel_shd.g_old_rec.pel_attribute13
400: ,p_pel_attribute14_o =>ben_pel_shd.g_old_rec.pel_attribute14
401: ,p_pel_attribute15_o =>ben_pel_shd.g_old_rec.pel_attribute15
402: ,p_pel_attribute16_o =>ben_pel_shd.g_old_rec.pel_attribute16
403: ,p_pel_attribute17_o =>ben_pel_shd.g_old_rec.pel_attribute17
396: ,p_pel_attribute10_o =>ben_pel_shd.g_old_rec.pel_attribute10
397: ,p_pel_attribute11_o =>ben_pel_shd.g_old_rec.pel_attribute11
398: ,p_pel_attribute12_o =>ben_pel_shd.g_old_rec.pel_attribute12
399: ,p_pel_attribute13_o =>ben_pel_shd.g_old_rec.pel_attribute13
400: ,p_pel_attribute14_o =>ben_pel_shd.g_old_rec.pel_attribute14
401: ,p_pel_attribute15_o =>ben_pel_shd.g_old_rec.pel_attribute15
402: ,p_pel_attribute16_o =>ben_pel_shd.g_old_rec.pel_attribute16
403: ,p_pel_attribute17_o =>ben_pel_shd.g_old_rec.pel_attribute17
404: ,p_pel_attribute18_o =>ben_pel_shd.g_old_rec.pel_attribute18
397: ,p_pel_attribute11_o =>ben_pel_shd.g_old_rec.pel_attribute11
398: ,p_pel_attribute12_o =>ben_pel_shd.g_old_rec.pel_attribute12
399: ,p_pel_attribute13_o =>ben_pel_shd.g_old_rec.pel_attribute13
400: ,p_pel_attribute14_o =>ben_pel_shd.g_old_rec.pel_attribute14
401: ,p_pel_attribute15_o =>ben_pel_shd.g_old_rec.pel_attribute15
402: ,p_pel_attribute16_o =>ben_pel_shd.g_old_rec.pel_attribute16
403: ,p_pel_attribute17_o =>ben_pel_shd.g_old_rec.pel_attribute17
404: ,p_pel_attribute18_o =>ben_pel_shd.g_old_rec.pel_attribute18
405: ,p_pel_attribute19_o =>ben_pel_shd.g_old_rec.pel_attribute19
398: ,p_pel_attribute12_o =>ben_pel_shd.g_old_rec.pel_attribute12
399: ,p_pel_attribute13_o =>ben_pel_shd.g_old_rec.pel_attribute13
400: ,p_pel_attribute14_o =>ben_pel_shd.g_old_rec.pel_attribute14
401: ,p_pel_attribute15_o =>ben_pel_shd.g_old_rec.pel_attribute15
402: ,p_pel_attribute16_o =>ben_pel_shd.g_old_rec.pel_attribute16
403: ,p_pel_attribute17_o =>ben_pel_shd.g_old_rec.pel_attribute17
404: ,p_pel_attribute18_o =>ben_pel_shd.g_old_rec.pel_attribute18
405: ,p_pel_attribute19_o =>ben_pel_shd.g_old_rec.pel_attribute19
406: ,p_pel_attribute20_o =>ben_pel_shd.g_old_rec.pel_attribute20
399: ,p_pel_attribute13_o =>ben_pel_shd.g_old_rec.pel_attribute13
400: ,p_pel_attribute14_o =>ben_pel_shd.g_old_rec.pel_attribute14
401: ,p_pel_attribute15_o =>ben_pel_shd.g_old_rec.pel_attribute15
402: ,p_pel_attribute16_o =>ben_pel_shd.g_old_rec.pel_attribute16
403: ,p_pel_attribute17_o =>ben_pel_shd.g_old_rec.pel_attribute17
404: ,p_pel_attribute18_o =>ben_pel_shd.g_old_rec.pel_attribute18
405: ,p_pel_attribute19_o =>ben_pel_shd.g_old_rec.pel_attribute19
406: ,p_pel_attribute20_o =>ben_pel_shd.g_old_rec.pel_attribute20
407: ,p_pel_attribute21_o =>ben_pel_shd.g_old_rec.pel_attribute21
400: ,p_pel_attribute14_o =>ben_pel_shd.g_old_rec.pel_attribute14
401: ,p_pel_attribute15_o =>ben_pel_shd.g_old_rec.pel_attribute15
402: ,p_pel_attribute16_o =>ben_pel_shd.g_old_rec.pel_attribute16
403: ,p_pel_attribute17_o =>ben_pel_shd.g_old_rec.pel_attribute17
404: ,p_pel_attribute18_o =>ben_pel_shd.g_old_rec.pel_attribute18
405: ,p_pel_attribute19_o =>ben_pel_shd.g_old_rec.pel_attribute19
406: ,p_pel_attribute20_o =>ben_pel_shd.g_old_rec.pel_attribute20
407: ,p_pel_attribute21_o =>ben_pel_shd.g_old_rec.pel_attribute21
408: ,p_pel_attribute22_o =>ben_pel_shd.g_old_rec.pel_attribute22
401: ,p_pel_attribute15_o =>ben_pel_shd.g_old_rec.pel_attribute15
402: ,p_pel_attribute16_o =>ben_pel_shd.g_old_rec.pel_attribute16
403: ,p_pel_attribute17_o =>ben_pel_shd.g_old_rec.pel_attribute17
404: ,p_pel_attribute18_o =>ben_pel_shd.g_old_rec.pel_attribute18
405: ,p_pel_attribute19_o =>ben_pel_shd.g_old_rec.pel_attribute19
406: ,p_pel_attribute20_o =>ben_pel_shd.g_old_rec.pel_attribute20
407: ,p_pel_attribute21_o =>ben_pel_shd.g_old_rec.pel_attribute21
408: ,p_pel_attribute22_o =>ben_pel_shd.g_old_rec.pel_attribute22
409: ,p_pel_attribute23_o =>ben_pel_shd.g_old_rec.pel_attribute23
402: ,p_pel_attribute16_o =>ben_pel_shd.g_old_rec.pel_attribute16
403: ,p_pel_attribute17_o =>ben_pel_shd.g_old_rec.pel_attribute17
404: ,p_pel_attribute18_o =>ben_pel_shd.g_old_rec.pel_attribute18
405: ,p_pel_attribute19_o =>ben_pel_shd.g_old_rec.pel_attribute19
406: ,p_pel_attribute20_o =>ben_pel_shd.g_old_rec.pel_attribute20
407: ,p_pel_attribute21_o =>ben_pel_shd.g_old_rec.pel_attribute21
408: ,p_pel_attribute22_o =>ben_pel_shd.g_old_rec.pel_attribute22
409: ,p_pel_attribute23_o =>ben_pel_shd.g_old_rec.pel_attribute23
410: ,p_pel_attribute24_o =>ben_pel_shd.g_old_rec.pel_attribute24
403: ,p_pel_attribute17_o =>ben_pel_shd.g_old_rec.pel_attribute17
404: ,p_pel_attribute18_o =>ben_pel_shd.g_old_rec.pel_attribute18
405: ,p_pel_attribute19_o =>ben_pel_shd.g_old_rec.pel_attribute19
406: ,p_pel_attribute20_o =>ben_pel_shd.g_old_rec.pel_attribute20
407: ,p_pel_attribute21_o =>ben_pel_shd.g_old_rec.pel_attribute21
408: ,p_pel_attribute22_o =>ben_pel_shd.g_old_rec.pel_attribute22
409: ,p_pel_attribute23_o =>ben_pel_shd.g_old_rec.pel_attribute23
410: ,p_pel_attribute24_o =>ben_pel_shd.g_old_rec.pel_attribute24
411: ,p_pel_attribute25_o =>ben_pel_shd.g_old_rec.pel_attribute25
404: ,p_pel_attribute18_o =>ben_pel_shd.g_old_rec.pel_attribute18
405: ,p_pel_attribute19_o =>ben_pel_shd.g_old_rec.pel_attribute19
406: ,p_pel_attribute20_o =>ben_pel_shd.g_old_rec.pel_attribute20
407: ,p_pel_attribute21_o =>ben_pel_shd.g_old_rec.pel_attribute21
408: ,p_pel_attribute22_o =>ben_pel_shd.g_old_rec.pel_attribute22
409: ,p_pel_attribute23_o =>ben_pel_shd.g_old_rec.pel_attribute23
410: ,p_pel_attribute24_o =>ben_pel_shd.g_old_rec.pel_attribute24
411: ,p_pel_attribute25_o =>ben_pel_shd.g_old_rec.pel_attribute25
412: ,p_pel_attribute26_o =>ben_pel_shd.g_old_rec.pel_attribute26
405: ,p_pel_attribute19_o =>ben_pel_shd.g_old_rec.pel_attribute19
406: ,p_pel_attribute20_o =>ben_pel_shd.g_old_rec.pel_attribute20
407: ,p_pel_attribute21_o =>ben_pel_shd.g_old_rec.pel_attribute21
408: ,p_pel_attribute22_o =>ben_pel_shd.g_old_rec.pel_attribute22
409: ,p_pel_attribute23_o =>ben_pel_shd.g_old_rec.pel_attribute23
410: ,p_pel_attribute24_o =>ben_pel_shd.g_old_rec.pel_attribute24
411: ,p_pel_attribute25_o =>ben_pel_shd.g_old_rec.pel_attribute25
412: ,p_pel_attribute26_o =>ben_pel_shd.g_old_rec.pel_attribute26
413: ,p_pel_attribute27_o =>ben_pel_shd.g_old_rec.pel_attribute27
406: ,p_pel_attribute20_o =>ben_pel_shd.g_old_rec.pel_attribute20
407: ,p_pel_attribute21_o =>ben_pel_shd.g_old_rec.pel_attribute21
408: ,p_pel_attribute22_o =>ben_pel_shd.g_old_rec.pel_attribute22
409: ,p_pel_attribute23_o =>ben_pel_shd.g_old_rec.pel_attribute23
410: ,p_pel_attribute24_o =>ben_pel_shd.g_old_rec.pel_attribute24
411: ,p_pel_attribute25_o =>ben_pel_shd.g_old_rec.pel_attribute25
412: ,p_pel_attribute26_o =>ben_pel_shd.g_old_rec.pel_attribute26
413: ,p_pel_attribute27_o =>ben_pel_shd.g_old_rec.pel_attribute27
414: ,p_pel_attribute28_o =>ben_pel_shd.g_old_rec.pel_attribute28
407: ,p_pel_attribute21_o =>ben_pel_shd.g_old_rec.pel_attribute21
408: ,p_pel_attribute22_o =>ben_pel_shd.g_old_rec.pel_attribute22
409: ,p_pel_attribute23_o =>ben_pel_shd.g_old_rec.pel_attribute23
410: ,p_pel_attribute24_o =>ben_pel_shd.g_old_rec.pel_attribute24
411: ,p_pel_attribute25_o =>ben_pel_shd.g_old_rec.pel_attribute25
412: ,p_pel_attribute26_o =>ben_pel_shd.g_old_rec.pel_attribute26
413: ,p_pel_attribute27_o =>ben_pel_shd.g_old_rec.pel_attribute27
414: ,p_pel_attribute28_o =>ben_pel_shd.g_old_rec.pel_attribute28
415: ,p_pel_attribute29_o =>ben_pel_shd.g_old_rec.pel_attribute29
408: ,p_pel_attribute22_o =>ben_pel_shd.g_old_rec.pel_attribute22
409: ,p_pel_attribute23_o =>ben_pel_shd.g_old_rec.pel_attribute23
410: ,p_pel_attribute24_o =>ben_pel_shd.g_old_rec.pel_attribute24
411: ,p_pel_attribute25_o =>ben_pel_shd.g_old_rec.pel_attribute25
412: ,p_pel_attribute26_o =>ben_pel_shd.g_old_rec.pel_attribute26
413: ,p_pel_attribute27_o =>ben_pel_shd.g_old_rec.pel_attribute27
414: ,p_pel_attribute28_o =>ben_pel_shd.g_old_rec.pel_attribute28
415: ,p_pel_attribute29_o =>ben_pel_shd.g_old_rec.pel_attribute29
416: ,p_pel_attribute30_o =>ben_pel_shd.g_old_rec.pel_attribute30
409: ,p_pel_attribute23_o =>ben_pel_shd.g_old_rec.pel_attribute23
410: ,p_pel_attribute24_o =>ben_pel_shd.g_old_rec.pel_attribute24
411: ,p_pel_attribute25_o =>ben_pel_shd.g_old_rec.pel_attribute25
412: ,p_pel_attribute26_o =>ben_pel_shd.g_old_rec.pel_attribute26
413: ,p_pel_attribute27_o =>ben_pel_shd.g_old_rec.pel_attribute27
414: ,p_pel_attribute28_o =>ben_pel_shd.g_old_rec.pel_attribute28
415: ,p_pel_attribute29_o =>ben_pel_shd.g_old_rec.pel_attribute29
416: ,p_pel_attribute30_o =>ben_pel_shd.g_old_rec.pel_attribute30
417: ,p_request_id_o =>ben_pel_shd.g_old_rec.request_id
410: ,p_pel_attribute24_o =>ben_pel_shd.g_old_rec.pel_attribute24
411: ,p_pel_attribute25_o =>ben_pel_shd.g_old_rec.pel_attribute25
412: ,p_pel_attribute26_o =>ben_pel_shd.g_old_rec.pel_attribute26
413: ,p_pel_attribute27_o =>ben_pel_shd.g_old_rec.pel_attribute27
414: ,p_pel_attribute28_o =>ben_pel_shd.g_old_rec.pel_attribute28
415: ,p_pel_attribute29_o =>ben_pel_shd.g_old_rec.pel_attribute29
416: ,p_pel_attribute30_o =>ben_pel_shd.g_old_rec.pel_attribute30
417: ,p_request_id_o =>ben_pel_shd.g_old_rec.request_id
418: ,p_program_application_id_o =>ben_pel_shd.g_old_rec.program_application_id
411: ,p_pel_attribute25_o =>ben_pel_shd.g_old_rec.pel_attribute25
412: ,p_pel_attribute26_o =>ben_pel_shd.g_old_rec.pel_attribute26
413: ,p_pel_attribute27_o =>ben_pel_shd.g_old_rec.pel_attribute27
414: ,p_pel_attribute28_o =>ben_pel_shd.g_old_rec.pel_attribute28
415: ,p_pel_attribute29_o =>ben_pel_shd.g_old_rec.pel_attribute29
416: ,p_pel_attribute30_o =>ben_pel_shd.g_old_rec.pel_attribute30
417: ,p_request_id_o =>ben_pel_shd.g_old_rec.request_id
418: ,p_program_application_id_o =>ben_pel_shd.g_old_rec.program_application_id
419: ,p_program_id_o =>ben_pel_shd.g_old_rec.program_id
412: ,p_pel_attribute26_o =>ben_pel_shd.g_old_rec.pel_attribute26
413: ,p_pel_attribute27_o =>ben_pel_shd.g_old_rec.pel_attribute27
414: ,p_pel_attribute28_o =>ben_pel_shd.g_old_rec.pel_attribute28
415: ,p_pel_attribute29_o =>ben_pel_shd.g_old_rec.pel_attribute29
416: ,p_pel_attribute30_o =>ben_pel_shd.g_old_rec.pel_attribute30
417: ,p_request_id_o =>ben_pel_shd.g_old_rec.request_id
418: ,p_program_application_id_o =>ben_pel_shd.g_old_rec.program_application_id
419: ,p_program_id_o =>ben_pel_shd.g_old_rec.program_id
420: ,p_program_update_date_o =>ben_pel_shd.g_old_rec.program_update_date
413: ,p_pel_attribute27_o =>ben_pel_shd.g_old_rec.pel_attribute27
414: ,p_pel_attribute28_o =>ben_pel_shd.g_old_rec.pel_attribute28
415: ,p_pel_attribute29_o =>ben_pel_shd.g_old_rec.pel_attribute29
416: ,p_pel_attribute30_o =>ben_pel_shd.g_old_rec.pel_attribute30
417: ,p_request_id_o =>ben_pel_shd.g_old_rec.request_id
418: ,p_program_application_id_o =>ben_pel_shd.g_old_rec.program_application_id
419: ,p_program_id_o =>ben_pel_shd.g_old_rec.program_id
420: ,p_program_update_date_o =>ben_pel_shd.g_old_rec.program_update_date
421: ,p_object_version_number_o =>ben_pel_shd.g_old_rec.object_version_number
414: ,p_pel_attribute28_o =>ben_pel_shd.g_old_rec.pel_attribute28
415: ,p_pel_attribute29_o =>ben_pel_shd.g_old_rec.pel_attribute29
416: ,p_pel_attribute30_o =>ben_pel_shd.g_old_rec.pel_attribute30
417: ,p_request_id_o =>ben_pel_shd.g_old_rec.request_id
418: ,p_program_application_id_o =>ben_pel_shd.g_old_rec.program_application_id
419: ,p_program_id_o =>ben_pel_shd.g_old_rec.program_id
420: ,p_program_update_date_o =>ben_pel_shd.g_old_rec.program_update_date
421: ,p_object_version_number_o =>ben_pel_shd.g_old_rec.object_version_number
422: ,p_defer_deenrol_flag_o =>ben_pel_shd.g_old_rec.defer_deenrol_flag
415: ,p_pel_attribute29_o =>ben_pel_shd.g_old_rec.pel_attribute29
416: ,p_pel_attribute30_o =>ben_pel_shd.g_old_rec.pel_attribute30
417: ,p_request_id_o =>ben_pel_shd.g_old_rec.request_id
418: ,p_program_application_id_o =>ben_pel_shd.g_old_rec.program_application_id
419: ,p_program_id_o =>ben_pel_shd.g_old_rec.program_id
420: ,p_program_update_date_o =>ben_pel_shd.g_old_rec.program_update_date
421: ,p_object_version_number_o =>ben_pel_shd.g_old_rec.object_version_number
422: ,p_defer_deenrol_flag_o =>ben_pel_shd.g_old_rec.defer_deenrol_flag
423: ,p_deenrol_made_dt_o =>ben_pel_shd.g_old_rec.deenrol_made_dt
416: ,p_pel_attribute30_o =>ben_pel_shd.g_old_rec.pel_attribute30
417: ,p_request_id_o =>ben_pel_shd.g_old_rec.request_id
418: ,p_program_application_id_o =>ben_pel_shd.g_old_rec.program_application_id
419: ,p_program_id_o =>ben_pel_shd.g_old_rec.program_id
420: ,p_program_update_date_o =>ben_pel_shd.g_old_rec.program_update_date
421: ,p_object_version_number_o =>ben_pel_shd.g_old_rec.object_version_number
422: ,p_defer_deenrol_flag_o =>ben_pel_shd.g_old_rec.defer_deenrol_flag
423: ,p_deenrol_made_dt_o =>ben_pel_shd.g_old_rec.deenrol_made_dt
424: );
417: ,p_request_id_o =>ben_pel_shd.g_old_rec.request_id
418: ,p_program_application_id_o =>ben_pel_shd.g_old_rec.program_application_id
419: ,p_program_id_o =>ben_pel_shd.g_old_rec.program_id
420: ,p_program_update_date_o =>ben_pel_shd.g_old_rec.program_update_date
421: ,p_object_version_number_o =>ben_pel_shd.g_old_rec.object_version_number
422: ,p_defer_deenrol_flag_o =>ben_pel_shd.g_old_rec.defer_deenrol_flag
423: ,p_deenrol_made_dt_o =>ben_pel_shd.g_old_rec.deenrol_made_dt
424: );
425: --
418: ,p_program_application_id_o =>ben_pel_shd.g_old_rec.program_application_id
419: ,p_program_id_o =>ben_pel_shd.g_old_rec.program_id
420: ,p_program_update_date_o =>ben_pel_shd.g_old_rec.program_update_date
421: ,p_object_version_number_o =>ben_pel_shd.g_old_rec.object_version_number
422: ,p_defer_deenrol_flag_o =>ben_pel_shd.g_old_rec.defer_deenrol_flag
423: ,p_deenrol_made_dt_o =>ben_pel_shd.g_old_rec.deenrol_made_dt
424: );
425: --
426: exception
419: ,p_program_id_o =>ben_pel_shd.g_old_rec.program_id
420: ,p_program_update_date_o =>ben_pel_shd.g_old_rec.program_update_date
421: ,p_object_version_number_o =>ben_pel_shd.g_old_rec.object_version_number
422: ,p_defer_deenrol_flag_o =>ben_pel_shd.g_old_rec.defer_deenrol_flag
423: ,p_deenrol_made_dt_o =>ben_pel_shd.g_old_rec.deenrol_made_dt
424: );
425: --
426: exception
427: --
481: -- Internal Row Handler Use Only.
482: --
483: -- {End Of Comments}
484: -- ----------------------------------------------------------------------------
485: Procedure convert_defs(p_rec in out nocopy ben_pel_shd.g_rec_type) is
486: --
487: l_proc varchar2(72) := g_package||'convert_defs';
488: --
489: Begin
496: -- is being used then we must set to the 'current' argument value.
497: --
498: If (p_rec.dflt_enrt_dt = hr_api.g_date) then
499: p_rec.dflt_enrt_dt :=
500: ben_pel_shd.g_old_rec.dflt_enrt_dt;
501: End If;
502: If (p_rec.dflt_asnd_dt = hr_api.g_date) then
503: p_rec.dflt_asnd_dt :=
504: ben_pel_shd.g_old_rec.dflt_asnd_dt;
500: ben_pel_shd.g_old_rec.dflt_enrt_dt;
501: End If;
502: If (p_rec.dflt_asnd_dt = hr_api.g_date) then
503: p_rec.dflt_asnd_dt :=
504: ben_pel_shd.g_old_rec.dflt_asnd_dt;
505: End If;
506: If (p_rec.elcns_made_dt = hr_api.g_date) then
507: p_rec.elcns_made_dt :=
508: ben_pel_shd.g_old_rec.elcns_made_dt;
504: ben_pel_shd.g_old_rec.dflt_asnd_dt;
505: End If;
506: If (p_rec.elcns_made_dt = hr_api.g_date) then
507: p_rec.elcns_made_dt :=
508: ben_pel_shd.g_old_rec.elcns_made_dt;
509: End If;
510: If (p_rec.cls_enrt_dt_to_use_cd = hr_api.g_varchar2) then
511: p_rec.cls_enrt_dt_to_use_cd :=
512: ben_pel_shd.g_old_rec.cls_enrt_dt_to_use_cd;
508: ben_pel_shd.g_old_rec.elcns_made_dt;
509: End If;
510: If (p_rec.cls_enrt_dt_to_use_cd = hr_api.g_varchar2) then
511: p_rec.cls_enrt_dt_to_use_cd :=
512: ben_pel_shd.g_old_rec.cls_enrt_dt_to_use_cd;
513: End If;
514: If (p_rec.enrt_typ_cycl_cd = hr_api.g_varchar2) then
515: p_rec.enrt_typ_cycl_cd :=
516: ben_pel_shd.g_old_rec.enrt_typ_cycl_cd;
512: ben_pel_shd.g_old_rec.cls_enrt_dt_to_use_cd;
513: End If;
514: If (p_rec.enrt_typ_cycl_cd = hr_api.g_varchar2) then
515: p_rec.enrt_typ_cycl_cd :=
516: ben_pel_shd.g_old_rec.enrt_typ_cycl_cd;
517: End If;
518: If (p_rec.enrt_perd_end_dt = hr_api.g_date) then
519: p_rec.enrt_perd_end_dt :=
520: ben_pel_shd.g_old_rec.enrt_perd_end_dt;
516: ben_pel_shd.g_old_rec.enrt_typ_cycl_cd;
517: End If;
518: If (p_rec.enrt_perd_end_dt = hr_api.g_date) then
519: p_rec.enrt_perd_end_dt :=
520: ben_pel_shd.g_old_rec.enrt_perd_end_dt;
521: End If;
522: If (p_rec.enrt_perd_strt_dt = hr_api.g_date) then
523: p_rec.enrt_perd_strt_dt :=
524: ben_pel_shd.g_old_rec.enrt_perd_strt_dt;
520: ben_pel_shd.g_old_rec.enrt_perd_end_dt;
521: End If;
522: If (p_rec.enrt_perd_strt_dt = hr_api.g_date) then
523: p_rec.enrt_perd_strt_dt :=
524: ben_pel_shd.g_old_rec.enrt_perd_strt_dt;
525: End If;
526: If (p_rec.procg_end_dt = hr_api.g_date) then
527: p_rec.procg_end_dt :=
528: ben_pel_shd.g_old_rec.procg_end_dt;
524: ben_pel_shd.g_old_rec.enrt_perd_strt_dt;
525: End If;
526: If (p_rec.procg_end_dt = hr_api.g_date) then
527: p_rec.procg_end_dt :=
528: ben_pel_shd.g_old_rec.procg_end_dt;
529: End If;
530: If (p_rec.pil_elctbl_popl_stat_cd = hr_api.g_varchar2) then
531: p_rec.pil_elctbl_popl_stat_cd :=
532: ben_pel_shd.g_old_rec.pil_elctbl_popl_stat_cd;
528: ben_pel_shd.g_old_rec.procg_end_dt;
529: End If;
530: If (p_rec.pil_elctbl_popl_stat_cd = hr_api.g_varchar2) then
531: p_rec.pil_elctbl_popl_stat_cd :=
532: ben_pel_shd.g_old_rec.pil_elctbl_popl_stat_cd;
533: End If;
534: If (p_rec.acty_ref_perd_cd = hr_api.g_varchar2) then
535: p_rec.acty_ref_perd_cd :=
536: ben_pel_shd.g_old_rec.acty_ref_perd_cd;
532: ben_pel_shd.g_old_rec.pil_elctbl_popl_stat_cd;
533: End If;
534: If (p_rec.acty_ref_perd_cd = hr_api.g_varchar2) then
535: p_rec.acty_ref_perd_cd :=
536: ben_pel_shd.g_old_rec.acty_ref_perd_cd;
537: End If;
538:
539: If (p_rec.uom = hr_api.g_varchar2) then
540: p_rec.uom :=
537: End If;
538:
539: If (p_rec.uom = hr_api.g_varchar2) then
540: p_rec.uom :=
541: ben_pel_shd.g_old_rec.uom;
542: End If;
543:
544: If (p_rec.comments = hr_api.g_varchar2) then
545: p_rec.comments :=
542: End If;
543:
544: If (p_rec.comments = hr_api.g_varchar2) then
545: p_rec.comments :=
546: ben_pel_shd.g_old_rec.comments;
547: End If;
548:
549: If (p_rec.mgr_ovrid_dt = hr_api.g_date) then
550: p_rec.mgr_ovrid_dt :=
547: End If;
548:
549: If (p_rec.mgr_ovrid_dt = hr_api.g_date) then
550: p_rec.mgr_ovrid_dt :=
551: ben_pel_shd.g_old_rec.mgr_ovrid_dt;
552: End If;
553:
554: If (p_rec.ws_mgr_id = hr_api.g_number) then
555: p_rec.ws_mgr_id :=
552: End If;
553:
554: If (p_rec.ws_mgr_id = hr_api.g_number) then
555: p_rec.ws_mgr_id :=
556: ben_pel_shd.g_old_rec.ws_mgr_id;
557: End If;
558:
559: If (p_rec.mgr_ovrid_person_id = hr_api.g_number) then
560: p_rec.mgr_ovrid_person_id :=
557: End If;
558:
559: If (p_rec.mgr_ovrid_person_id = hr_api.g_number) then
560: p_rec.mgr_ovrid_person_id :=
561: ben_pel_shd.g_old_rec.mgr_ovrid_person_id;
562: End If;
563:
564: If (p_rec.assignment_id = hr_api.g_number) then
565: p_rec.assignment_id :=
562: End If;
563:
564: If (p_rec.assignment_id = hr_api.g_number) then
565: p_rec.assignment_id :=
566: ben_pel_shd.g_old_rec.assignment_id;
567: End If;
568:
569: If (p_rec.mgr_ovrid_person_id = hr_api.g_number) then
570: p_rec.mgr_ovrid_person_id :=
567: End If;
568:
569: If (p_rec.mgr_ovrid_person_id = hr_api.g_number) then
570: p_rec.mgr_ovrid_person_id :=
571: ben_pel_shd.g_old_rec.mgr_ovrid_person_id;
572: End If;
573:
574:
575: -- cwb
574:
575: -- cwb
576: If (p_rec.bdgt_acc_cd = hr_api.g_varchar2) then
577: p_rec.bdgt_acc_cd :=
578: ben_pel_shd.g_old_rec.bdgt_acc_cd;
579: End If;
580: If (p_rec.pop_cd = hr_api.g_varchar2) then
581: p_rec.pop_cd :=
582: ben_pel_shd.g_old_rec.pop_cd;
578: ben_pel_shd.g_old_rec.bdgt_acc_cd;
579: End If;
580: If (p_rec.pop_cd = hr_api.g_varchar2) then
581: p_rec.pop_cd :=
582: ben_pel_shd.g_old_rec.pop_cd;
583: End If;
584: If (p_rec.bdgt_due_dt = hr_api.g_date) then
585: p_rec.bdgt_due_dt :=
586: ben_pel_shd.g_old_rec.bdgt_due_dt;
582: ben_pel_shd.g_old_rec.pop_cd;
583: End If;
584: If (p_rec.bdgt_due_dt = hr_api.g_date) then
585: p_rec.bdgt_due_dt :=
586: ben_pel_shd.g_old_rec.bdgt_due_dt;
587: End If;
588: If (p_rec.bdgt_export_flag = hr_api.g_varchar2) then
589: p_rec.bdgt_export_flag :=
590: ben_pel_shd.g_old_rec.bdgt_export_flag;
586: ben_pel_shd.g_old_rec.bdgt_due_dt;
587: End If;
588: If (p_rec.bdgt_export_flag = hr_api.g_varchar2) then
589: p_rec.bdgt_export_flag :=
590: ben_pel_shd.g_old_rec.bdgt_export_flag;
591: End If;
592: If (p_rec.bdgt_iss_dt = hr_api.g_date) then
593: p_rec.bdgt_iss_dt :=
594: ben_pel_shd.g_old_rec.bdgt_iss_dt;
590: ben_pel_shd.g_old_rec.bdgt_export_flag;
591: End If;
592: If (p_rec.bdgt_iss_dt = hr_api.g_date) then
593: p_rec.bdgt_iss_dt :=
594: ben_pel_shd.g_old_rec.bdgt_iss_dt;
595: End If;
596: If (p_rec.bdgt_stat_cd = hr_api.g_varchar2) then
597: p_rec.bdgt_stat_cd :=
598: ben_pel_shd.g_old_rec.bdgt_stat_cd;
594: ben_pel_shd.g_old_rec.bdgt_iss_dt;
595: End If;
596: If (p_rec.bdgt_stat_cd = hr_api.g_varchar2) then
597: p_rec.bdgt_stat_cd :=
598: ben_pel_shd.g_old_rec.bdgt_stat_cd;
599: End If;
600: If (p_rec.ws_acc_cd = hr_api.g_varchar2) then
601: p_rec.ws_acc_cd :=
602: ben_pel_shd.g_old_rec.ws_acc_cd;
598: ben_pel_shd.g_old_rec.bdgt_stat_cd;
599: End If;
600: If (p_rec.ws_acc_cd = hr_api.g_varchar2) then
601: p_rec.ws_acc_cd :=
602: ben_pel_shd.g_old_rec.ws_acc_cd;
603: End If;
604: If (p_rec.ws_due_dt = hr_api.g_date) then
605: p_rec.ws_due_dt :=
606: ben_pel_shd.g_old_rec.ws_due_dt;
602: ben_pel_shd.g_old_rec.ws_acc_cd;
603: End If;
604: If (p_rec.ws_due_dt = hr_api.g_date) then
605: p_rec.ws_due_dt :=
606: ben_pel_shd.g_old_rec.ws_due_dt;
607: End If;
608: If (p_rec.ws_export_flag = hr_api.g_varchar2) then
609: p_rec.ws_export_flag :=
610: ben_pel_shd.g_old_rec.ws_export_flag;
606: ben_pel_shd.g_old_rec.ws_due_dt;
607: End If;
608: If (p_rec.ws_export_flag = hr_api.g_varchar2) then
609: p_rec.ws_export_flag :=
610: ben_pel_shd.g_old_rec.ws_export_flag;
611: End If;
612: If (p_rec.ws_iss_dt = hr_api.g_date) then
613: p_rec.ws_iss_dt :=
614: ben_pel_shd.g_old_rec.ws_iss_dt;
610: ben_pel_shd.g_old_rec.ws_export_flag;
611: End If;
612: If (p_rec.ws_iss_dt = hr_api.g_date) then
613: p_rec.ws_iss_dt :=
614: ben_pel_shd.g_old_rec.ws_iss_dt;
615: End If;
616: If (p_rec.ws_stat_cd = hr_api.g_varchar2) then
617: p_rec.ws_stat_cd :=
618: ben_pel_shd.g_old_rec.ws_stat_cd;
614: ben_pel_shd.g_old_rec.ws_iss_dt;
615: End If;
616: If (p_rec.ws_stat_cd = hr_api.g_varchar2) then
617: p_rec.ws_stat_cd :=
618: ben_pel_shd.g_old_rec.ws_stat_cd;
619: End If;
620: -- cwb
621: If (p_rec.reinstate_cd = hr_api.g_varchar2) then
622: p_rec.reinstate_cd :=
619: End If;
620: -- cwb
621: If (p_rec.reinstate_cd = hr_api.g_varchar2) then
622: p_rec.reinstate_cd :=
623: ben_pel_shd.g_old_rec.reinstate_cd;
624: End If;
625: If (p_rec.reinstate_ovrdn_cd = hr_api.g_varchar2) then
626: p_rec.reinstate_ovrdn_cd :=
627: ben_pel_shd.g_old_rec.reinstate_ovrdn_cd;
623: ben_pel_shd.g_old_rec.reinstate_cd;
624: End If;
625: If (p_rec.reinstate_ovrdn_cd = hr_api.g_varchar2) then
626: p_rec.reinstate_ovrdn_cd :=
627: ben_pel_shd.g_old_rec.reinstate_ovrdn_cd;
628: End If;
629: If (p_rec.auto_asnd_dt = hr_api.g_date) then
630: p_rec.auto_asnd_dt :=
631: ben_pel_shd.g_old_rec.auto_asnd_dt;
627: ben_pel_shd.g_old_rec.reinstate_ovrdn_cd;
628: End If;
629: If (p_rec.auto_asnd_dt = hr_api.g_date) then
630: p_rec.auto_asnd_dt :=
631: ben_pel_shd.g_old_rec.auto_asnd_dt;
632: End If;
633: If (p_rec.cbr_elig_perd_strt_dt = hr_api.g_date) then
634: p_rec.cbr_elig_perd_strt_dt :=
635: ben_pel_shd.g_old_rec.cbr_elig_perd_strt_dt;
631: ben_pel_shd.g_old_rec.auto_asnd_dt;
632: End If;
633: If (p_rec.cbr_elig_perd_strt_dt = hr_api.g_date) then
634: p_rec.cbr_elig_perd_strt_dt :=
635: ben_pel_shd.g_old_rec.cbr_elig_perd_strt_dt;
636: End If;
637: If (p_rec.cbr_elig_perd_end_dt = hr_api.g_date) then
638: p_rec.cbr_elig_perd_end_dt :=
639: ben_pel_shd.g_old_rec.cbr_elig_perd_end_dt;
635: ben_pel_shd.g_old_rec.cbr_elig_perd_strt_dt;
636: End If;
637: If (p_rec.cbr_elig_perd_end_dt = hr_api.g_date) then
638: p_rec.cbr_elig_perd_end_dt :=
639: ben_pel_shd.g_old_rec.cbr_elig_perd_end_dt;
640: End If;
641: If (p_rec.lee_rsn_id = hr_api.g_number) then
642: p_rec.lee_rsn_id :=
643: ben_pel_shd.g_old_rec.lee_rsn_id;
639: ben_pel_shd.g_old_rec.cbr_elig_perd_end_dt;
640: End If;
641: If (p_rec.lee_rsn_id = hr_api.g_number) then
642: p_rec.lee_rsn_id :=
643: ben_pel_shd.g_old_rec.lee_rsn_id;
644: End If;
645: If (p_rec.enrt_perd_id = hr_api.g_number) then
646: p_rec.enrt_perd_id :=
647: ben_pel_shd.g_old_rec.enrt_perd_id;
643: ben_pel_shd.g_old_rec.lee_rsn_id;
644: End If;
645: If (p_rec.enrt_perd_id = hr_api.g_number) then
646: p_rec.enrt_perd_id :=
647: ben_pel_shd.g_old_rec.enrt_perd_id;
648: End If;
649: If (p_rec.per_in_ler_id = hr_api.g_number) then
650: p_rec.per_in_ler_id :=
651: ben_pel_shd.g_old_rec.per_in_ler_id;
647: ben_pel_shd.g_old_rec.enrt_perd_id;
648: End If;
649: If (p_rec.per_in_ler_id = hr_api.g_number) then
650: p_rec.per_in_ler_id :=
651: ben_pel_shd.g_old_rec.per_in_ler_id;
652: End If;
653: If (p_rec.pgm_id = hr_api.g_number) then
654: p_rec.pgm_id :=
655: ben_pel_shd.g_old_rec.pgm_id;
651: ben_pel_shd.g_old_rec.per_in_ler_id;
652: End If;
653: If (p_rec.pgm_id = hr_api.g_number) then
654: p_rec.pgm_id :=
655: ben_pel_shd.g_old_rec.pgm_id;
656: End If;
657: If (p_rec.pl_id = hr_api.g_number) then
658: p_rec.pl_id :=
659: ben_pel_shd.g_old_rec.pl_id;
655: ben_pel_shd.g_old_rec.pgm_id;
656: End If;
657: If (p_rec.pl_id = hr_api.g_number) then
658: p_rec.pl_id :=
659: ben_pel_shd.g_old_rec.pl_id;
660: End If;
661: If (p_rec.business_group_id = hr_api.g_number) then
662: p_rec.business_group_id :=
663: ben_pel_shd.g_old_rec.business_group_id;
659: ben_pel_shd.g_old_rec.pl_id;
660: End If;
661: If (p_rec.business_group_id = hr_api.g_number) then
662: p_rec.business_group_id :=
663: ben_pel_shd.g_old_rec.business_group_id;
664: End If;
665: If (p_rec.pel_attribute_category = hr_api.g_varchar2) then
666: p_rec.pel_attribute_category :=
667: ben_pel_shd.g_old_rec.pel_attribute_category;
663: ben_pel_shd.g_old_rec.business_group_id;
664: End If;
665: If (p_rec.pel_attribute_category = hr_api.g_varchar2) then
666: p_rec.pel_attribute_category :=
667: ben_pel_shd.g_old_rec.pel_attribute_category;
668: End If;
669: If (p_rec.pel_attribute1 = hr_api.g_varchar2) then
670: p_rec.pel_attribute1 :=
671: ben_pel_shd.g_old_rec.pel_attribute1;
667: ben_pel_shd.g_old_rec.pel_attribute_category;
668: End If;
669: If (p_rec.pel_attribute1 = hr_api.g_varchar2) then
670: p_rec.pel_attribute1 :=
671: ben_pel_shd.g_old_rec.pel_attribute1;
672: End If;
673: If (p_rec.pel_attribute2 = hr_api.g_varchar2) then
674: p_rec.pel_attribute2 :=
675: ben_pel_shd.g_old_rec.pel_attribute2;
671: ben_pel_shd.g_old_rec.pel_attribute1;
672: End If;
673: If (p_rec.pel_attribute2 = hr_api.g_varchar2) then
674: p_rec.pel_attribute2 :=
675: ben_pel_shd.g_old_rec.pel_attribute2;
676: End If;
677: If (p_rec.pel_attribute3 = hr_api.g_varchar2) then
678: p_rec.pel_attribute3 :=
679: ben_pel_shd.g_old_rec.pel_attribute3;
675: ben_pel_shd.g_old_rec.pel_attribute2;
676: End If;
677: If (p_rec.pel_attribute3 = hr_api.g_varchar2) then
678: p_rec.pel_attribute3 :=
679: ben_pel_shd.g_old_rec.pel_attribute3;
680: End If;
681: If (p_rec.pel_attribute4 = hr_api.g_varchar2) then
682: p_rec.pel_attribute4 :=
683: ben_pel_shd.g_old_rec.pel_attribute4;
679: ben_pel_shd.g_old_rec.pel_attribute3;
680: End If;
681: If (p_rec.pel_attribute4 = hr_api.g_varchar2) then
682: p_rec.pel_attribute4 :=
683: ben_pel_shd.g_old_rec.pel_attribute4;
684: End If;
685: If (p_rec.pel_attribute5 = hr_api.g_varchar2) then
686: p_rec.pel_attribute5 :=
687: ben_pel_shd.g_old_rec.pel_attribute5;
683: ben_pel_shd.g_old_rec.pel_attribute4;
684: End If;
685: If (p_rec.pel_attribute5 = hr_api.g_varchar2) then
686: p_rec.pel_attribute5 :=
687: ben_pel_shd.g_old_rec.pel_attribute5;
688: End If;
689: If (p_rec.pel_attribute6 = hr_api.g_varchar2) then
690: p_rec.pel_attribute6 :=
691: ben_pel_shd.g_old_rec.pel_attribute6;
687: ben_pel_shd.g_old_rec.pel_attribute5;
688: End If;
689: If (p_rec.pel_attribute6 = hr_api.g_varchar2) then
690: p_rec.pel_attribute6 :=
691: ben_pel_shd.g_old_rec.pel_attribute6;
692: End If;
693: If (p_rec.pel_attribute7 = hr_api.g_varchar2) then
694: p_rec.pel_attribute7 :=
695: ben_pel_shd.g_old_rec.pel_attribute7;
691: ben_pel_shd.g_old_rec.pel_attribute6;
692: End If;
693: If (p_rec.pel_attribute7 = hr_api.g_varchar2) then
694: p_rec.pel_attribute7 :=
695: ben_pel_shd.g_old_rec.pel_attribute7;
696: End If;
697: If (p_rec.pel_attribute8 = hr_api.g_varchar2) then
698: p_rec.pel_attribute8 :=
699: ben_pel_shd.g_old_rec.pel_attribute8;
695: ben_pel_shd.g_old_rec.pel_attribute7;
696: End If;
697: If (p_rec.pel_attribute8 = hr_api.g_varchar2) then
698: p_rec.pel_attribute8 :=
699: ben_pel_shd.g_old_rec.pel_attribute8;
700: End If;
701: If (p_rec.pel_attribute9 = hr_api.g_varchar2) then
702: p_rec.pel_attribute9 :=
703: ben_pel_shd.g_old_rec.pel_attribute9;
699: ben_pel_shd.g_old_rec.pel_attribute8;
700: End If;
701: If (p_rec.pel_attribute9 = hr_api.g_varchar2) then
702: p_rec.pel_attribute9 :=
703: ben_pel_shd.g_old_rec.pel_attribute9;
704: End If;
705: If (p_rec.pel_attribute10 = hr_api.g_varchar2) then
706: p_rec.pel_attribute10 :=
707: ben_pel_shd.g_old_rec.pel_attribute10;
703: ben_pel_shd.g_old_rec.pel_attribute9;
704: End If;
705: If (p_rec.pel_attribute10 = hr_api.g_varchar2) then
706: p_rec.pel_attribute10 :=
707: ben_pel_shd.g_old_rec.pel_attribute10;
708: End If;
709: If (p_rec.pel_attribute11 = hr_api.g_varchar2) then
710: p_rec.pel_attribute11 :=
711: ben_pel_shd.g_old_rec.pel_attribute11;
707: ben_pel_shd.g_old_rec.pel_attribute10;
708: End If;
709: If (p_rec.pel_attribute11 = hr_api.g_varchar2) then
710: p_rec.pel_attribute11 :=
711: ben_pel_shd.g_old_rec.pel_attribute11;
712: End If;
713: If (p_rec.pel_attribute12 = hr_api.g_varchar2) then
714: p_rec.pel_attribute12 :=
715: ben_pel_shd.g_old_rec.pel_attribute12;
711: ben_pel_shd.g_old_rec.pel_attribute11;
712: End If;
713: If (p_rec.pel_attribute12 = hr_api.g_varchar2) then
714: p_rec.pel_attribute12 :=
715: ben_pel_shd.g_old_rec.pel_attribute12;
716: End If;
717: If (p_rec.pel_attribute13 = hr_api.g_varchar2) then
718: p_rec.pel_attribute13 :=
719: ben_pel_shd.g_old_rec.pel_attribute13;
715: ben_pel_shd.g_old_rec.pel_attribute12;
716: End If;
717: If (p_rec.pel_attribute13 = hr_api.g_varchar2) then
718: p_rec.pel_attribute13 :=
719: ben_pel_shd.g_old_rec.pel_attribute13;
720: End If;
721: If (p_rec.pel_attribute14 = hr_api.g_varchar2) then
722: p_rec.pel_attribute14 :=
723: ben_pel_shd.g_old_rec.pel_attribute14;
719: ben_pel_shd.g_old_rec.pel_attribute13;
720: End If;
721: If (p_rec.pel_attribute14 = hr_api.g_varchar2) then
722: p_rec.pel_attribute14 :=
723: ben_pel_shd.g_old_rec.pel_attribute14;
724: End If;
725: If (p_rec.pel_attribute15 = hr_api.g_varchar2) then
726: p_rec.pel_attribute15 :=
727: ben_pel_shd.g_old_rec.pel_attribute15;
723: ben_pel_shd.g_old_rec.pel_attribute14;
724: End If;
725: If (p_rec.pel_attribute15 = hr_api.g_varchar2) then
726: p_rec.pel_attribute15 :=
727: ben_pel_shd.g_old_rec.pel_attribute15;
728: End If;
729: If (p_rec.pel_attribute16 = hr_api.g_varchar2) then
730: p_rec.pel_attribute16 :=
731: ben_pel_shd.g_old_rec.pel_attribute16;
727: ben_pel_shd.g_old_rec.pel_attribute15;
728: End If;
729: If (p_rec.pel_attribute16 = hr_api.g_varchar2) then
730: p_rec.pel_attribute16 :=
731: ben_pel_shd.g_old_rec.pel_attribute16;
732: End If;
733: If (p_rec.pel_attribute17 = hr_api.g_varchar2) then
734: p_rec.pel_attribute17 :=
735: ben_pel_shd.g_old_rec.pel_attribute17;
731: ben_pel_shd.g_old_rec.pel_attribute16;
732: End If;
733: If (p_rec.pel_attribute17 = hr_api.g_varchar2) then
734: p_rec.pel_attribute17 :=
735: ben_pel_shd.g_old_rec.pel_attribute17;
736: End If;
737: If (p_rec.pel_attribute18 = hr_api.g_varchar2) then
738: p_rec.pel_attribute18 :=
739: ben_pel_shd.g_old_rec.pel_attribute18;
735: ben_pel_shd.g_old_rec.pel_attribute17;
736: End If;
737: If (p_rec.pel_attribute18 = hr_api.g_varchar2) then
738: p_rec.pel_attribute18 :=
739: ben_pel_shd.g_old_rec.pel_attribute18;
740: End If;
741: If (p_rec.pel_attribute19 = hr_api.g_varchar2) then
742: p_rec.pel_attribute19 :=
743: ben_pel_shd.g_old_rec.pel_attribute19;
739: ben_pel_shd.g_old_rec.pel_attribute18;
740: End If;
741: If (p_rec.pel_attribute19 = hr_api.g_varchar2) then
742: p_rec.pel_attribute19 :=
743: ben_pel_shd.g_old_rec.pel_attribute19;
744: End If;
745: If (p_rec.pel_attribute20 = hr_api.g_varchar2) then
746: p_rec.pel_attribute20 :=
747: ben_pel_shd.g_old_rec.pel_attribute20;
743: ben_pel_shd.g_old_rec.pel_attribute19;
744: End If;
745: If (p_rec.pel_attribute20 = hr_api.g_varchar2) then
746: p_rec.pel_attribute20 :=
747: ben_pel_shd.g_old_rec.pel_attribute20;
748: End If;
749: If (p_rec.pel_attribute21 = hr_api.g_varchar2) then
750: p_rec.pel_attribute21 :=
751: ben_pel_shd.g_old_rec.pel_attribute21;
747: ben_pel_shd.g_old_rec.pel_attribute20;
748: End If;
749: If (p_rec.pel_attribute21 = hr_api.g_varchar2) then
750: p_rec.pel_attribute21 :=
751: ben_pel_shd.g_old_rec.pel_attribute21;
752: End If;
753: If (p_rec.pel_attribute22 = hr_api.g_varchar2) then
754: p_rec.pel_attribute22 :=
755: ben_pel_shd.g_old_rec.pel_attribute22;
751: ben_pel_shd.g_old_rec.pel_attribute21;
752: End If;
753: If (p_rec.pel_attribute22 = hr_api.g_varchar2) then
754: p_rec.pel_attribute22 :=
755: ben_pel_shd.g_old_rec.pel_attribute22;
756: End If;
757: If (p_rec.pel_attribute23 = hr_api.g_varchar2) then
758: p_rec.pel_attribute23 :=
759: ben_pel_shd.g_old_rec.pel_attribute23;
755: ben_pel_shd.g_old_rec.pel_attribute22;
756: End If;
757: If (p_rec.pel_attribute23 = hr_api.g_varchar2) then
758: p_rec.pel_attribute23 :=
759: ben_pel_shd.g_old_rec.pel_attribute23;
760: End If;
761: If (p_rec.pel_attribute24 = hr_api.g_varchar2) then
762: p_rec.pel_attribute24 :=
763: ben_pel_shd.g_old_rec.pel_attribute24;
759: ben_pel_shd.g_old_rec.pel_attribute23;
760: End If;
761: If (p_rec.pel_attribute24 = hr_api.g_varchar2) then
762: p_rec.pel_attribute24 :=
763: ben_pel_shd.g_old_rec.pel_attribute24;
764: End If;
765: If (p_rec.pel_attribute25 = hr_api.g_varchar2) then
766: p_rec.pel_attribute25 :=
767: ben_pel_shd.g_old_rec.pel_attribute25;
763: ben_pel_shd.g_old_rec.pel_attribute24;
764: End If;
765: If (p_rec.pel_attribute25 = hr_api.g_varchar2) then
766: p_rec.pel_attribute25 :=
767: ben_pel_shd.g_old_rec.pel_attribute25;
768: End If;
769: If (p_rec.pel_attribute26 = hr_api.g_varchar2) then
770: p_rec.pel_attribute26 :=
771: ben_pel_shd.g_old_rec.pel_attribute26;
767: ben_pel_shd.g_old_rec.pel_attribute25;
768: End If;
769: If (p_rec.pel_attribute26 = hr_api.g_varchar2) then
770: p_rec.pel_attribute26 :=
771: ben_pel_shd.g_old_rec.pel_attribute26;
772: End If;
773: If (p_rec.pel_attribute27 = hr_api.g_varchar2) then
774: p_rec.pel_attribute27 :=
775: ben_pel_shd.g_old_rec.pel_attribute27;
771: ben_pel_shd.g_old_rec.pel_attribute26;
772: End If;
773: If (p_rec.pel_attribute27 = hr_api.g_varchar2) then
774: p_rec.pel_attribute27 :=
775: ben_pel_shd.g_old_rec.pel_attribute27;
776: End If;
777: If (p_rec.pel_attribute28 = hr_api.g_varchar2) then
778: p_rec.pel_attribute28 :=
779: ben_pel_shd.g_old_rec.pel_attribute28;
775: ben_pel_shd.g_old_rec.pel_attribute27;
776: End If;
777: If (p_rec.pel_attribute28 = hr_api.g_varchar2) then
778: p_rec.pel_attribute28 :=
779: ben_pel_shd.g_old_rec.pel_attribute28;
780: End If;
781: If (p_rec.pel_attribute29 = hr_api.g_varchar2) then
782: p_rec.pel_attribute29 :=
783: ben_pel_shd.g_old_rec.pel_attribute29;
779: ben_pel_shd.g_old_rec.pel_attribute28;
780: End If;
781: If (p_rec.pel_attribute29 = hr_api.g_varchar2) then
782: p_rec.pel_attribute29 :=
783: ben_pel_shd.g_old_rec.pel_attribute29;
784: End If;
785: If (p_rec.pel_attribute30 = hr_api.g_varchar2) then
786: p_rec.pel_attribute30 :=
787: ben_pel_shd.g_old_rec.pel_attribute30;
783: ben_pel_shd.g_old_rec.pel_attribute29;
784: End If;
785: If (p_rec.pel_attribute30 = hr_api.g_varchar2) then
786: p_rec.pel_attribute30 :=
787: ben_pel_shd.g_old_rec.pel_attribute30;
788: End If;
789: If (p_rec.request_id = hr_api.g_number) then
790: p_rec.request_id :=
791: ben_pel_shd.g_old_rec.request_id;
787: ben_pel_shd.g_old_rec.pel_attribute30;
788: End If;
789: If (p_rec.request_id = hr_api.g_number) then
790: p_rec.request_id :=
791: ben_pel_shd.g_old_rec.request_id;
792: End If;
793: If (p_rec.program_application_id = hr_api.g_number) then
794: p_rec.program_application_id :=
795: ben_pel_shd.g_old_rec.program_application_id;
791: ben_pel_shd.g_old_rec.request_id;
792: End If;
793: If (p_rec.program_application_id = hr_api.g_number) then
794: p_rec.program_application_id :=
795: ben_pel_shd.g_old_rec.program_application_id;
796: End If;
797: If (p_rec.program_id = hr_api.g_number) then
798: p_rec.program_id :=
799: ben_pel_shd.g_old_rec.program_id;
795: ben_pel_shd.g_old_rec.program_application_id;
796: End If;
797: If (p_rec.program_id = hr_api.g_number) then
798: p_rec.program_id :=
799: ben_pel_shd.g_old_rec.program_id;
800: End If;
801: If (p_rec.program_update_date = hr_api.g_date) then
802: p_rec.program_update_date :=
803: ben_pel_shd.g_old_rec.program_update_date;
799: ben_pel_shd.g_old_rec.program_id;
800: End If;
801: If (p_rec.program_update_date = hr_api.g_date) then
802: p_rec.program_update_date :=
803: ben_pel_shd.g_old_rec.program_update_date;
804: End If;
805: If (p_rec.defer_deenrol_flag = hr_api.g_varchar2) then
806: p_rec.defer_deenrol_flag :=
807: ben_pel_shd.g_old_rec.defer_deenrol_flag;
803: ben_pel_shd.g_old_rec.program_update_date;
804: End If;
805: If (p_rec.defer_deenrol_flag = hr_api.g_varchar2) then
806: p_rec.defer_deenrol_flag :=
807: ben_pel_shd.g_old_rec.defer_deenrol_flag;
808: End If;
809: If (p_rec.deenrol_made_dt = hr_api.g_date) then
810: p_rec.deenrol_made_dt :=
811: ben_pel_shd.g_old_rec.deenrol_made_dt;
807: ben_pel_shd.g_old_rec.defer_deenrol_flag;
808: End If;
809: If (p_rec.deenrol_made_dt = hr_api.g_date) then
810: p_rec.deenrol_made_dt :=
811: ben_pel_shd.g_old_rec.deenrol_made_dt;
812: End If;
813: --
814: hr_utility.set_location(' Leaving:'||l_proc, 10);
815: --
820: -- ----------------------------------------------------------------------------
821: Procedure upd
822: (
823: p_effective_date in date,
824: p_rec in out nocopy ben_pel_shd.g_rec_type
825: ) is
826: --
827: l_proc varchar2(72) := g_package||'upd';
828: --
830: hr_utility.set_location('Entering:'||l_proc, 5);
831: --
832: -- We must lock the row which we need to update.
833: --
834: ben_pel_shd.lck
835: (
836: p_rec.pil_elctbl_chc_popl_id,
837: p_rec.object_version_number
838: );
958: p_defer_deenrol_flag in varchar2 default hr_api.g_varchar2,
959: p_deenrol_made_dt in date default hr_api.g_date
960: ) is
961: --
962: l_rec ben_pel_shd.g_rec_type;
963: l_proc varchar2(72) := g_package||'upd';
964: --
965: Begin
966: hr_utility.set_location('Entering:'||l_proc, 5);
968: -- Call conversion function to turn arguments into the
969: -- l_rec structure.
970: --
971: l_rec :=
972: ben_pel_shd.convert_args
973: (
974: p_pil_elctbl_chc_popl_id,
975: p_dflt_enrt_dt,
976: p_dflt_asnd_dt,