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