47: -- Internal Row Handler Use Only.
48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml(p_rec in ben_pel_shd.g_rec_type) is
52: --
53: l_proc varchar2(72) := g_package||'delete_dml';
54: --
55: Begin
54: --
55: Begin
56: hr_utility.set_location('Entering:'||l_proc, 5);
57: --
58: ben_pel_shd.g_api_dml := true; -- Set the api dml status
59: --
60: -- Delete the ben_pil_elctbl_chc_popl row.
61: --
62: delete from ben_pil_elctbl_chc_popl
61: --
62: delete from ben_pil_elctbl_chc_popl
63: where pil_elctbl_chc_popl_id = p_rec.pil_elctbl_chc_popl_id;
64: --
65: ben_pel_shd.g_api_dml := false; -- Unset the api dml status
66: --
67: hr_utility.set_location(' Leaving:'||l_proc, 10);
68: --
69: Exception
68: --
69: Exception
70: When hr_api.child_integrity_violated then
71: -- Child integrity has been violated
72: ben_pel_shd.g_api_dml := false; -- Unset the api dml status
73: ben_pel_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_pel_shd.g_api_dml := false; -- Unset the api dml status
69: Exception
70: When hr_api.child_integrity_violated then
71: -- Child integrity has been violated
72: ben_pel_shd.g_api_dml := false; -- Unset the api dml status
73: ben_pel_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_pel_shd.g_api_dml := false; -- Unset the api dml status
77: Raise;
72: ben_pel_shd.g_api_dml := false; -- Unset the api dml status
73: ben_pel_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_pel_shd.g_api_dml := false; -- Unset the api dml status
77: Raise;
78: End delete_dml;
79: --
80: -- ----------------------------------------------------------------------------
108: -- Internal Row Handler Use Only.
109: --
110: -- {End Of Comments}
111: -- ----------------------------------------------------------------------------
112: Procedure pre_delete(p_rec in ben_pel_shd.g_rec_type) is
113: --
114: l_proc varchar2(72) := g_package||'pre_delete';
115: --
116: Begin
151: --
152: -- {End Of Comments}
153: -- ----------------------------------------------------------------------------
154: Procedure post_delete(
155: p_effective_date in date,p_rec in ben_pel_shd.g_rec_type) is
156: --
157: l_proc varchar2(72) := g_package||'post_delete';
158: --
159: Begin
166: --
167: ben_pel_rkd.after_delete
168: (
169: p_pil_elctbl_chc_popl_id =>p_rec.pil_elctbl_chc_popl_id
170: ,p_dflt_enrt_dt_o =>ben_pel_shd.g_old_rec.dflt_enrt_dt
171: ,p_dflt_asnd_dt_o =>ben_pel_shd.g_old_rec.dflt_asnd_dt
172: ,p_elcns_made_dt_o =>ben_pel_shd.g_old_rec.elcns_made_dt
173: ,p_cls_enrt_dt_to_use_cd_o =>ben_pel_shd.g_old_rec.cls_enrt_dt_to_use_cd
174: ,p_enrt_typ_cycl_cd_o =>ben_pel_shd.g_old_rec.enrt_typ_cycl_cd
167: ben_pel_rkd.after_delete
168: (
169: p_pil_elctbl_chc_popl_id =>p_rec.pil_elctbl_chc_popl_id
170: ,p_dflt_enrt_dt_o =>ben_pel_shd.g_old_rec.dflt_enrt_dt
171: ,p_dflt_asnd_dt_o =>ben_pel_shd.g_old_rec.dflt_asnd_dt
172: ,p_elcns_made_dt_o =>ben_pel_shd.g_old_rec.elcns_made_dt
173: ,p_cls_enrt_dt_to_use_cd_o =>ben_pel_shd.g_old_rec.cls_enrt_dt_to_use_cd
174: ,p_enrt_typ_cycl_cd_o =>ben_pel_shd.g_old_rec.enrt_typ_cycl_cd
175: ,p_enrt_perd_end_dt_o =>ben_pel_shd.g_old_rec.enrt_perd_end_dt
168: (
169: p_pil_elctbl_chc_popl_id =>p_rec.pil_elctbl_chc_popl_id
170: ,p_dflt_enrt_dt_o =>ben_pel_shd.g_old_rec.dflt_enrt_dt
171: ,p_dflt_asnd_dt_o =>ben_pel_shd.g_old_rec.dflt_asnd_dt
172: ,p_elcns_made_dt_o =>ben_pel_shd.g_old_rec.elcns_made_dt
173: ,p_cls_enrt_dt_to_use_cd_o =>ben_pel_shd.g_old_rec.cls_enrt_dt_to_use_cd
174: ,p_enrt_typ_cycl_cd_o =>ben_pel_shd.g_old_rec.enrt_typ_cycl_cd
175: ,p_enrt_perd_end_dt_o =>ben_pel_shd.g_old_rec.enrt_perd_end_dt
176: ,p_enrt_perd_strt_dt_o =>ben_pel_shd.g_old_rec.enrt_perd_strt_dt
169: p_pil_elctbl_chc_popl_id =>p_rec.pil_elctbl_chc_popl_id
170: ,p_dflt_enrt_dt_o =>ben_pel_shd.g_old_rec.dflt_enrt_dt
171: ,p_dflt_asnd_dt_o =>ben_pel_shd.g_old_rec.dflt_asnd_dt
172: ,p_elcns_made_dt_o =>ben_pel_shd.g_old_rec.elcns_made_dt
173: ,p_cls_enrt_dt_to_use_cd_o =>ben_pel_shd.g_old_rec.cls_enrt_dt_to_use_cd
174: ,p_enrt_typ_cycl_cd_o =>ben_pel_shd.g_old_rec.enrt_typ_cycl_cd
175: ,p_enrt_perd_end_dt_o =>ben_pel_shd.g_old_rec.enrt_perd_end_dt
176: ,p_enrt_perd_strt_dt_o =>ben_pel_shd.g_old_rec.enrt_perd_strt_dt
177: ,p_procg_end_dt_o =>ben_pel_shd.g_old_rec.procg_end_dt
170: ,p_dflt_enrt_dt_o =>ben_pel_shd.g_old_rec.dflt_enrt_dt
171: ,p_dflt_asnd_dt_o =>ben_pel_shd.g_old_rec.dflt_asnd_dt
172: ,p_elcns_made_dt_o =>ben_pel_shd.g_old_rec.elcns_made_dt
173: ,p_cls_enrt_dt_to_use_cd_o =>ben_pel_shd.g_old_rec.cls_enrt_dt_to_use_cd
174: ,p_enrt_typ_cycl_cd_o =>ben_pel_shd.g_old_rec.enrt_typ_cycl_cd
175: ,p_enrt_perd_end_dt_o =>ben_pel_shd.g_old_rec.enrt_perd_end_dt
176: ,p_enrt_perd_strt_dt_o =>ben_pel_shd.g_old_rec.enrt_perd_strt_dt
177: ,p_procg_end_dt_o =>ben_pel_shd.g_old_rec.procg_end_dt
178: ,p_pil_elctbl_popl_stat_cd_o =>ben_pel_shd.g_old_rec.pil_elctbl_popl_stat_cd
171: ,p_dflt_asnd_dt_o =>ben_pel_shd.g_old_rec.dflt_asnd_dt
172: ,p_elcns_made_dt_o =>ben_pel_shd.g_old_rec.elcns_made_dt
173: ,p_cls_enrt_dt_to_use_cd_o =>ben_pel_shd.g_old_rec.cls_enrt_dt_to_use_cd
174: ,p_enrt_typ_cycl_cd_o =>ben_pel_shd.g_old_rec.enrt_typ_cycl_cd
175: ,p_enrt_perd_end_dt_o =>ben_pel_shd.g_old_rec.enrt_perd_end_dt
176: ,p_enrt_perd_strt_dt_o =>ben_pel_shd.g_old_rec.enrt_perd_strt_dt
177: ,p_procg_end_dt_o =>ben_pel_shd.g_old_rec.procg_end_dt
178: ,p_pil_elctbl_popl_stat_cd_o =>ben_pel_shd.g_old_rec.pil_elctbl_popl_stat_cd
179: ,p_acty_ref_perd_cd_o =>ben_pel_shd.g_old_rec.acty_ref_perd_cd
172: ,p_elcns_made_dt_o =>ben_pel_shd.g_old_rec.elcns_made_dt
173: ,p_cls_enrt_dt_to_use_cd_o =>ben_pel_shd.g_old_rec.cls_enrt_dt_to_use_cd
174: ,p_enrt_typ_cycl_cd_o =>ben_pel_shd.g_old_rec.enrt_typ_cycl_cd
175: ,p_enrt_perd_end_dt_o =>ben_pel_shd.g_old_rec.enrt_perd_end_dt
176: ,p_enrt_perd_strt_dt_o =>ben_pel_shd.g_old_rec.enrt_perd_strt_dt
177: ,p_procg_end_dt_o =>ben_pel_shd.g_old_rec.procg_end_dt
178: ,p_pil_elctbl_popl_stat_cd_o =>ben_pel_shd.g_old_rec.pil_elctbl_popl_stat_cd
179: ,p_acty_ref_perd_cd_o =>ben_pel_shd.g_old_rec.acty_ref_perd_cd
180: ,p_uom_o =>ben_pel_shd.g_old_rec.uom
173: ,p_cls_enrt_dt_to_use_cd_o =>ben_pel_shd.g_old_rec.cls_enrt_dt_to_use_cd
174: ,p_enrt_typ_cycl_cd_o =>ben_pel_shd.g_old_rec.enrt_typ_cycl_cd
175: ,p_enrt_perd_end_dt_o =>ben_pel_shd.g_old_rec.enrt_perd_end_dt
176: ,p_enrt_perd_strt_dt_o =>ben_pel_shd.g_old_rec.enrt_perd_strt_dt
177: ,p_procg_end_dt_o =>ben_pel_shd.g_old_rec.procg_end_dt
178: ,p_pil_elctbl_popl_stat_cd_o =>ben_pel_shd.g_old_rec.pil_elctbl_popl_stat_cd
179: ,p_acty_ref_perd_cd_o =>ben_pel_shd.g_old_rec.acty_ref_perd_cd
180: ,p_uom_o =>ben_pel_shd.g_old_rec.uom
181: ,p_comments_o =>ben_pel_shd.g_old_rec.comments
174: ,p_enrt_typ_cycl_cd_o =>ben_pel_shd.g_old_rec.enrt_typ_cycl_cd
175: ,p_enrt_perd_end_dt_o =>ben_pel_shd.g_old_rec.enrt_perd_end_dt
176: ,p_enrt_perd_strt_dt_o =>ben_pel_shd.g_old_rec.enrt_perd_strt_dt
177: ,p_procg_end_dt_o =>ben_pel_shd.g_old_rec.procg_end_dt
178: ,p_pil_elctbl_popl_stat_cd_o =>ben_pel_shd.g_old_rec.pil_elctbl_popl_stat_cd
179: ,p_acty_ref_perd_cd_o =>ben_pel_shd.g_old_rec.acty_ref_perd_cd
180: ,p_uom_o =>ben_pel_shd.g_old_rec.uom
181: ,p_comments_o =>ben_pel_shd.g_old_rec.comments
182: ,p_mgr_ovrid_dt_o =>ben_pel_shd.g_old_rec.mgr_ovrid_dt
175: ,p_enrt_perd_end_dt_o =>ben_pel_shd.g_old_rec.enrt_perd_end_dt
176: ,p_enrt_perd_strt_dt_o =>ben_pel_shd.g_old_rec.enrt_perd_strt_dt
177: ,p_procg_end_dt_o =>ben_pel_shd.g_old_rec.procg_end_dt
178: ,p_pil_elctbl_popl_stat_cd_o =>ben_pel_shd.g_old_rec.pil_elctbl_popl_stat_cd
179: ,p_acty_ref_perd_cd_o =>ben_pel_shd.g_old_rec.acty_ref_perd_cd
180: ,p_uom_o =>ben_pel_shd.g_old_rec.uom
181: ,p_comments_o =>ben_pel_shd.g_old_rec.comments
182: ,p_mgr_ovrid_dt_o =>ben_pel_shd.g_old_rec.mgr_ovrid_dt
183: ,p_ws_mgr_id_o =>ben_pel_shd.g_old_rec.ws_mgr_id
176: ,p_enrt_perd_strt_dt_o =>ben_pel_shd.g_old_rec.enrt_perd_strt_dt
177: ,p_procg_end_dt_o =>ben_pel_shd.g_old_rec.procg_end_dt
178: ,p_pil_elctbl_popl_stat_cd_o =>ben_pel_shd.g_old_rec.pil_elctbl_popl_stat_cd
179: ,p_acty_ref_perd_cd_o =>ben_pel_shd.g_old_rec.acty_ref_perd_cd
180: ,p_uom_o =>ben_pel_shd.g_old_rec.uom
181: ,p_comments_o =>ben_pel_shd.g_old_rec.comments
182: ,p_mgr_ovrid_dt_o =>ben_pel_shd.g_old_rec.mgr_ovrid_dt
183: ,p_ws_mgr_id_o =>ben_pel_shd.g_old_rec.ws_mgr_id
184: ,p_mgr_ovrid_person_id_o =>ben_pel_shd.g_old_rec.mgr_ovrid_person_id
177: ,p_procg_end_dt_o =>ben_pel_shd.g_old_rec.procg_end_dt
178: ,p_pil_elctbl_popl_stat_cd_o =>ben_pel_shd.g_old_rec.pil_elctbl_popl_stat_cd
179: ,p_acty_ref_perd_cd_o =>ben_pel_shd.g_old_rec.acty_ref_perd_cd
180: ,p_uom_o =>ben_pel_shd.g_old_rec.uom
181: ,p_comments_o =>ben_pel_shd.g_old_rec.comments
182: ,p_mgr_ovrid_dt_o =>ben_pel_shd.g_old_rec.mgr_ovrid_dt
183: ,p_ws_mgr_id_o =>ben_pel_shd.g_old_rec.ws_mgr_id
184: ,p_mgr_ovrid_person_id_o =>ben_pel_shd.g_old_rec.mgr_ovrid_person_id
185: ,p_assignment_id_o =>ben_pel_shd.g_old_rec.assignment_id
178: ,p_pil_elctbl_popl_stat_cd_o =>ben_pel_shd.g_old_rec.pil_elctbl_popl_stat_cd
179: ,p_acty_ref_perd_cd_o =>ben_pel_shd.g_old_rec.acty_ref_perd_cd
180: ,p_uom_o =>ben_pel_shd.g_old_rec.uom
181: ,p_comments_o =>ben_pel_shd.g_old_rec.comments
182: ,p_mgr_ovrid_dt_o =>ben_pel_shd.g_old_rec.mgr_ovrid_dt
183: ,p_ws_mgr_id_o =>ben_pel_shd.g_old_rec.ws_mgr_id
184: ,p_mgr_ovrid_person_id_o =>ben_pel_shd.g_old_rec.mgr_ovrid_person_id
185: ,p_assignment_id_o =>ben_pel_shd.g_old_rec.assignment_id
186: --cwb
179: ,p_acty_ref_perd_cd_o =>ben_pel_shd.g_old_rec.acty_ref_perd_cd
180: ,p_uom_o =>ben_pel_shd.g_old_rec.uom
181: ,p_comments_o =>ben_pel_shd.g_old_rec.comments
182: ,p_mgr_ovrid_dt_o =>ben_pel_shd.g_old_rec.mgr_ovrid_dt
183: ,p_ws_mgr_id_o =>ben_pel_shd.g_old_rec.ws_mgr_id
184: ,p_mgr_ovrid_person_id_o =>ben_pel_shd.g_old_rec.mgr_ovrid_person_id
185: ,p_assignment_id_o =>ben_pel_shd.g_old_rec.assignment_id
186: --cwb
187: ,p_bdgt_acc_cd_o => ben_pel_shd.g_old_rec.bdgt_acc_cd
180: ,p_uom_o =>ben_pel_shd.g_old_rec.uom
181: ,p_comments_o =>ben_pel_shd.g_old_rec.comments
182: ,p_mgr_ovrid_dt_o =>ben_pel_shd.g_old_rec.mgr_ovrid_dt
183: ,p_ws_mgr_id_o =>ben_pel_shd.g_old_rec.ws_mgr_id
184: ,p_mgr_ovrid_person_id_o =>ben_pel_shd.g_old_rec.mgr_ovrid_person_id
185: ,p_assignment_id_o =>ben_pel_shd.g_old_rec.assignment_id
186: --cwb
187: ,p_bdgt_acc_cd_o => ben_pel_shd.g_old_rec.bdgt_acc_cd
188: ,p_pop_cd_o => ben_pel_shd.g_old_rec.pop_cd
181: ,p_comments_o =>ben_pel_shd.g_old_rec.comments
182: ,p_mgr_ovrid_dt_o =>ben_pel_shd.g_old_rec.mgr_ovrid_dt
183: ,p_ws_mgr_id_o =>ben_pel_shd.g_old_rec.ws_mgr_id
184: ,p_mgr_ovrid_person_id_o =>ben_pel_shd.g_old_rec.mgr_ovrid_person_id
185: ,p_assignment_id_o =>ben_pel_shd.g_old_rec.assignment_id
186: --cwb
187: ,p_bdgt_acc_cd_o => ben_pel_shd.g_old_rec.bdgt_acc_cd
188: ,p_pop_cd_o => ben_pel_shd.g_old_rec.pop_cd
189: ,p_bdgt_due_dt_o => ben_pel_shd.g_old_rec.bdgt_due_dt
183: ,p_ws_mgr_id_o =>ben_pel_shd.g_old_rec.ws_mgr_id
184: ,p_mgr_ovrid_person_id_o =>ben_pel_shd.g_old_rec.mgr_ovrid_person_id
185: ,p_assignment_id_o =>ben_pel_shd.g_old_rec.assignment_id
186: --cwb
187: ,p_bdgt_acc_cd_o => ben_pel_shd.g_old_rec.bdgt_acc_cd
188: ,p_pop_cd_o => ben_pel_shd.g_old_rec.pop_cd
189: ,p_bdgt_due_dt_o => ben_pel_shd.g_old_rec.bdgt_due_dt
190: ,p_bdgt_export_flag_o => ben_pel_shd.g_old_rec.bdgt_export_flag
191: ,p_bdgt_iss_dt_o => ben_pel_shd.g_old_rec.bdgt_iss_dt
184: ,p_mgr_ovrid_person_id_o =>ben_pel_shd.g_old_rec.mgr_ovrid_person_id
185: ,p_assignment_id_o =>ben_pel_shd.g_old_rec.assignment_id
186: --cwb
187: ,p_bdgt_acc_cd_o => ben_pel_shd.g_old_rec.bdgt_acc_cd
188: ,p_pop_cd_o => ben_pel_shd.g_old_rec.pop_cd
189: ,p_bdgt_due_dt_o => ben_pel_shd.g_old_rec.bdgt_due_dt
190: ,p_bdgt_export_flag_o => ben_pel_shd.g_old_rec.bdgt_export_flag
191: ,p_bdgt_iss_dt_o => ben_pel_shd.g_old_rec.bdgt_iss_dt
192: ,p_bdgt_stat_cd_o => ben_pel_shd.g_old_rec.bdgt_stat_cd
185: ,p_assignment_id_o =>ben_pel_shd.g_old_rec.assignment_id
186: --cwb
187: ,p_bdgt_acc_cd_o => ben_pel_shd.g_old_rec.bdgt_acc_cd
188: ,p_pop_cd_o => ben_pel_shd.g_old_rec.pop_cd
189: ,p_bdgt_due_dt_o => ben_pel_shd.g_old_rec.bdgt_due_dt
190: ,p_bdgt_export_flag_o => ben_pel_shd.g_old_rec.bdgt_export_flag
191: ,p_bdgt_iss_dt_o => ben_pel_shd.g_old_rec.bdgt_iss_dt
192: ,p_bdgt_stat_cd_o => ben_pel_shd.g_old_rec.bdgt_stat_cd
193: ,p_ws_acc_cd_o => ben_pel_shd.g_old_rec.ws_acc_cd
186: --cwb
187: ,p_bdgt_acc_cd_o => ben_pel_shd.g_old_rec.bdgt_acc_cd
188: ,p_pop_cd_o => ben_pel_shd.g_old_rec.pop_cd
189: ,p_bdgt_due_dt_o => ben_pel_shd.g_old_rec.bdgt_due_dt
190: ,p_bdgt_export_flag_o => ben_pel_shd.g_old_rec.bdgt_export_flag
191: ,p_bdgt_iss_dt_o => ben_pel_shd.g_old_rec.bdgt_iss_dt
192: ,p_bdgt_stat_cd_o => ben_pel_shd.g_old_rec.bdgt_stat_cd
193: ,p_ws_acc_cd_o => ben_pel_shd.g_old_rec.ws_acc_cd
194: ,p_ws_due_dt_o => ben_pel_shd.g_old_rec.ws_due_dt
187: ,p_bdgt_acc_cd_o => ben_pel_shd.g_old_rec.bdgt_acc_cd
188: ,p_pop_cd_o => ben_pel_shd.g_old_rec.pop_cd
189: ,p_bdgt_due_dt_o => ben_pel_shd.g_old_rec.bdgt_due_dt
190: ,p_bdgt_export_flag_o => ben_pel_shd.g_old_rec.bdgt_export_flag
191: ,p_bdgt_iss_dt_o => ben_pel_shd.g_old_rec.bdgt_iss_dt
192: ,p_bdgt_stat_cd_o => ben_pel_shd.g_old_rec.bdgt_stat_cd
193: ,p_ws_acc_cd_o => ben_pel_shd.g_old_rec.ws_acc_cd
194: ,p_ws_due_dt_o => ben_pel_shd.g_old_rec.ws_due_dt
195: ,p_ws_export_flag_o => ben_pel_shd.g_old_rec.ws_export_flag
188: ,p_pop_cd_o => ben_pel_shd.g_old_rec.pop_cd
189: ,p_bdgt_due_dt_o => ben_pel_shd.g_old_rec.bdgt_due_dt
190: ,p_bdgt_export_flag_o => ben_pel_shd.g_old_rec.bdgt_export_flag
191: ,p_bdgt_iss_dt_o => ben_pel_shd.g_old_rec.bdgt_iss_dt
192: ,p_bdgt_stat_cd_o => ben_pel_shd.g_old_rec.bdgt_stat_cd
193: ,p_ws_acc_cd_o => ben_pel_shd.g_old_rec.ws_acc_cd
194: ,p_ws_due_dt_o => ben_pel_shd.g_old_rec.ws_due_dt
195: ,p_ws_export_flag_o => ben_pel_shd.g_old_rec.ws_export_flag
196: ,p_ws_iss_dt_o => ben_pel_shd.g_old_rec.ws_iss_dt
189: ,p_bdgt_due_dt_o => ben_pel_shd.g_old_rec.bdgt_due_dt
190: ,p_bdgt_export_flag_o => ben_pel_shd.g_old_rec.bdgt_export_flag
191: ,p_bdgt_iss_dt_o => ben_pel_shd.g_old_rec.bdgt_iss_dt
192: ,p_bdgt_stat_cd_o => ben_pel_shd.g_old_rec.bdgt_stat_cd
193: ,p_ws_acc_cd_o => ben_pel_shd.g_old_rec.ws_acc_cd
194: ,p_ws_due_dt_o => ben_pel_shd.g_old_rec.ws_due_dt
195: ,p_ws_export_flag_o => ben_pel_shd.g_old_rec.ws_export_flag
196: ,p_ws_iss_dt_o => ben_pel_shd.g_old_rec.ws_iss_dt
197: ,p_ws_stat_cd_o => ben_pel_shd.g_old_rec.ws_stat_cd
190: ,p_bdgt_export_flag_o => ben_pel_shd.g_old_rec.bdgt_export_flag
191: ,p_bdgt_iss_dt_o => ben_pel_shd.g_old_rec.bdgt_iss_dt
192: ,p_bdgt_stat_cd_o => ben_pel_shd.g_old_rec.bdgt_stat_cd
193: ,p_ws_acc_cd_o => ben_pel_shd.g_old_rec.ws_acc_cd
194: ,p_ws_due_dt_o => ben_pel_shd.g_old_rec.ws_due_dt
195: ,p_ws_export_flag_o => ben_pel_shd.g_old_rec.ws_export_flag
196: ,p_ws_iss_dt_o => ben_pel_shd.g_old_rec.ws_iss_dt
197: ,p_ws_stat_cd_o => ben_pel_shd.g_old_rec.ws_stat_cd
198: --cwb
191: ,p_bdgt_iss_dt_o => ben_pel_shd.g_old_rec.bdgt_iss_dt
192: ,p_bdgt_stat_cd_o => ben_pel_shd.g_old_rec.bdgt_stat_cd
193: ,p_ws_acc_cd_o => ben_pel_shd.g_old_rec.ws_acc_cd
194: ,p_ws_due_dt_o => ben_pel_shd.g_old_rec.ws_due_dt
195: ,p_ws_export_flag_o => ben_pel_shd.g_old_rec.ws_export_flag
196: ,p_ws_iss_dt_o => ben_pel_shd.g_old_rec.ws_iss_dt
197: ,p_ws_stat_cd_o => ben_pel_shd.g_old_rec.ws_stat_cd
198: --cwb
199: ,p_reinstate_cd_o =>ben_pel_shd.g_old_rec.reinstate_cd
192: ,p_bdgt_stat_cd_o => ben_pel_shd.g_old_rec.bdgt_stat_cd
193: ,p_ws_acc_cd_o => ben_pel_shd.g_old_rec.ws_acc_cd
194: ,p_ws_due_dt_o => ben_pel_shd.g_old_rec.ws_due_dt
195: ,p_ws_export_flag_o => ben_pel_shd.g_old_rec.ws_export_flag
196: ,p_ws_iss_dt_o => ben_pel_shd.g_old_rec.ws_iss_dt
197: ,p_ws_stat_cd_o => ben_pel_shd.g_old_rec.ws_stat_cd
198: --cwb
199: ,p_reinstate_cd_o =>ben_pel_shd.g_old_rec.reinstate_cd
200: ,p_reinstate_ovrdn_cd_o =>ben_pel_shd.g_old_rec.reinstate_ovrdn_cd
193: ,p_ws_acc_cd_o => ben_pel_shd.g_old_rec.ws_acc_cd
194: ,p_ws_due_dt_o => ben_pel_shd.g_old_rec.ws_due_dt
195: ,p_ws_export_flag_o => ben_pel_shd.g_old_rec.ws_export_flag
196: ,p_ws_iss_dt_o => ben_pel_shd.g_old_rec.ws_iss_dt
197: ,p_ws_stat_cd_o => ben_pel_shd.g_old_rec.ws_stat_cd
198: --cwb
199: ,p_reinstate_cd_o =>ben_pel_shd.g_old_rec.reinstate_cd
200: ,p_reinstate_ovrdn_cd_o =>ben_pel_shd.g_old_rec.reinstate_ovrdn_cd
201: ,p_auto_asnd_dt_o =>ben_pel_shd.g_old_rec.auto_asnd_dt
195: ,p_ws_export_flag_o => ben_pel_shd.g_old_rec.ws_export_flag
196: ,p_ws_iss_dt_o => ben_pel_shd.g_old_rec.ws_iss_dt
197: ,p_ws_stat_cd_o => ben_pel_shd.g_old_rec.ws_stat_cd
198: --cwb
199: ,p_reinstate_cd_o =>ben_pel_shd.g_old_rec.reinstate_cd
200: ,p_reinstate_ovrdn_cd_o =>ben_pel_shd.g_old_rec.reinstate_ovrdn_cd
201: ,p_auto_asnd_dt_o =>ben_pel_shd.g_old_rec.auto_asnd_dt
202: ,p_cbr_elig_perd_strt_dt_o =>ben_pel_shd.g_old_rec.cbr_elig_perd_strt_dt
203: ,p_cbr_elig_perd_end_dt_o =>ben_pel_shd.g_old_rec.cbr_elig_perd_end_dt
196: ,p_ws_iss_dt_o => ben_pel_shd.g_old_rec.ws_iss_dt
197: ,p_ws_stat_cd_o => ben_pel_shd.g_old_rec.ws_stat_cd
198: --cwb
199: ,p_reinstate_cd_o =>ben_pel_shd.g_old_rec.reinstate_cd
200: ,p_reinstate_ovrdn_cd_o =>ben_pel_shd.g_old_rec.reinstate_ovrdn_cd
201: ,p_auto_asnd_dt_o =>ben_pel_shd.g_old_rec.auto_asnd_dt
202: ,p_cbr_elig_perd_strt_dt_o =>ben_pel_shd.g_old_rec.cbr_elig_perd_strt_dt
203: ,p_cbr_elig_perd_end_dt_o =>ben_pel_shd.g_old_rec.cbr_elig_perd_end_dt
204: ,p_lee_rsn_id_o =>ben_pel_shd.g_old_rec.lee_rsn_id
197: ,p_ws_stat_cd_o => ben_pel_shd.g_old_rec.ws_stat_cd
198: --cwb
199: ,p_reinstate_cd_o =>ben_pel_shd.g_old_rec.reinstate_cd
200: ,p_reinstate_ovrdn_cd_o =>ben_pel_shd.g_old_rec.reinstate_ovrdn_cd
201: ,p_auto_asnd_dt_o =>ben_pel_shd.g_old_rec.auto_asnd_dt
202: ,p_cbr_elig_perd_strt_dt_o =>ben_pel_shd.g_old_rec.cbr_elig_perd_strt_dt
203: ,p_cbr_elig_perd_end_dt_o =>ben_pel_shd.g_old_rec.cbr_elig_perd_end_dt
204: ,p_lee_rsn_id_o =>ben_pel_shd.g_old_rec.lee_rsn_id
205: ,p_enrt_perd_id_o =>ben_pel_shd.g_old_rec.enrt_perd_id
198: --cwb
199: ,p_reinstate_cd_o =>ben_pel_shd.g_old_rec.reinstate_cd
200: ,p_reinstate_ovrdn_cd_o =>ben_pel_shd.g_old_rec.reinstate_ovrdn_cd
201: ,p_auto_asnd_dt_o =>ben_pel_shd.g_old_rec.auto_asnd_dt
202: ,p_cbr_elig_perd_strt_dt_o =>ben_pel_shd.g_old_rec.cbr_elig_perd_strt_dt
203: ,p_cbr_elig_perd_end_dt_o =>ben_pel_shd.g_old_rec.cbr_elig_perd_end_dt
204: ,p_lee_rsn_id_o =>ben_pel_shd.g_old_rec.lee_rsn_id
205: ,p_enrt_perd_id_o =>ben_pel_shd.g_old_rec.enrt_perd_id
206: ,p_per_in_ler_id_o =>ben_pel_shd.g_old_rec.per_in_ler_id
199: ,p_reinstate_cd_o =>ben_pel_shd.g_old_rec.reinstate_cd
200: ,p_reinstate_ovrdn_cd_o =>ben_pel_shd.g_old_rec.reinstate_ovrdn_cd
201: ,p_auto_asnd_dt_o =>ben_pel_shd.g_old_rec.auto_asnd_dt
202: ,p_cbr_elig_perd_strt_dt_o =>ben_pel_shd.g_old_rec.cbr_elig_perd_strt_dt
203: ,p_cbr_elig_perd_end_dt_o =>ben_pel_shd.g_old_rec.cbr_elig_perd_end_dt
204: ,p_lee_rsn_id_o =>ben_pel_shd.g_old_rec.lee_rsn_id
205: ,p_enrt_perd_id_o =>ben_pel_shd.g_old_rec.enrt_perd_id
206: ,p_per_in_ler_id_o =>ben_pel_shd.g_old_rec.per_in_ler_id
207: ,p_pgm_id_o =>ben_pel_shd.g_old_rec.pgm_id
200: ,p_reinstate_ovrdn_cd_o =>ben_pel_shd.g_old_rec.reinstate_ovrdn_cd
201: ,p_auto_asnd_dt_o =>ben_pel_shd.g_old_rec.auto_asnd_dt
202: ,p_cbr_elig_perd_strt_dt_o =>ben_pel_shd.g_old_rec.cbr_elig_perd_strt_dt
203: ,p_cbr_elig_perd_end_dt_o =>ben_pel_shd.g_old_rec.cbr_elig_perd_end_dt
204: ,p_lee_rsn_id_o =>ben_pel_shd.g_old_rec.lee_rsn_id
205: ,p_enrt_perd_id_o =>ben_pel_shd.g_old_rec.enrt_perd_id
206: ,p_per_in_ler_id_o =>ben_pel_shd.g_old_rec.per_in_ler_id
207: ,p_pgm_id_o =>ben_pel_shd.g_old_rec.pgm_id
208: ,p_pl_id_o =>ben_pel_shd.g_old_rec.pl_id
201: ,p_auto_asnd_dt_o =>ben_pel_shd.g_old_rec.auto_asnd_dt
202: ,p_cbr_elig_perd_strt_dt_o =>ben_pel_shd.g_old_rec.cbr_elig_perd_strt_dt
203: ,p_cbr_elig_perd_end_dt_o =>ben_pel_shd.g_old_rec.cbr_elig_perd_end_dt
204: ,p_lee_rsn_id_o =>ben_pel_shd.g_old_rec.lee_rsn_id
205: ,p_enrt_perd_id_o =>ben_pel_shd.g_old_rec.enrt_perd_id
206: ,p_per_in_ler_id_o =>ben_pel_shd.g_old_rec.per_in_ler_id
207: ,p_pgm_id_o =>ben_pel_shd.g_old_rec.pgm_id
208: ,p_pl_id_o =>ben_pel_shd.g_old_rec.pl_id
209: ,p_business_group_id_o =>ben_pel_shd.g_old_rec.business_group_id
202: ,p_cbr_elig_perd_strt_dt_o =>ben_pel_shd.g_old_rec.cbr_elig_perd_strt_dt
203: ,p_cbr_elig_perd_end_dt_o =>ben_pel_shd.g_old_rec.cbr_elig_perd_end_dt
204: ,p_lee_rsn_id_o =>ben_pel_shd.g_old_rec.lee_rsn_id
205: ,p_enrt_perd_id_o =>ben_pel_shd.g_old_rec.enrt_perd_id
206: ,p_per_in_ler_id_o =>ben_pel_shd.g_old_rec.per_in_ler_id
207: ,p_pgm_id_o =>ben_pel_shd.g_old_rec.pgm_id
208: ,p_pl_id_o =>ben_pel_shd.g_old_rec.pl_id
209: ,p_business_group_id_o =>ben_pel_shd.g_old_rec.business_group_id
210: ,p_pel_attribute_category_o =>ben_pel_shd.g_old_rec.pel_attribute_category
203: ,p_cbr_elig_perd_end_dt_o =>ben_pel_shd.g_old_rec.cbr_elig_perd_end_dt
204: ,p_lee_rsn_id_o =>ben_pel_shd.g_old_rec.lee_rsn_id
205: ,p_enrt_perd_id_o =>ben_pel_shd.g_old_rec.enrt_perd_id
206: ,p_per_in_ler_id_o =>ben_pel_shd.g_old_rec.per_in_ler_id
207: ,p_pgm_id_o =>ben_pel_shd.g_old_rec.pgm_id
208: ,p_pl_id_o =>ben_pel_shd.g_old_rec.pl_id
209: ,p_business_group_id_o =>ben_pel_shd.g_old_rec.business_group_id
210: ,p_pel_attribute_category_o =>ben_pel_shd.g_old_rec.pel_attribute_category
211: ,p_pel_attribute1_o =>ben_pel_shd.g_old_rec.pel_attribute1
204: ,p_lee_rsn_id_o =>ben_pel_shd.g_old_rec.lee_rsn_id
205: ,p_enrt_perd_id_o =>ben_pel_shd.g_old_rec.enrt_perd_id
206: ,p_per_in_ler_id_o =>ben_pel_shd.g_old_rec.per_in_ler_id
207: ,p_pgm_id_o =>ben_pel_shd.g_old_rec.pgm_id
208: ,p_pl_id_o =>ben_pel_shd.g_old_rec.pl_id
209: ,p_business_group_id_o =>ben_pel_shd.g_old_rec.business_group_id
210: ,p_pel_attribute_category_o =>ben_pel_shd.g_old_rec.pel_attribute_category
211: ,p_pel_attribute1_o =>ben_pel_shd.g_old_rec.pel_attribute1
212: ,p_pel_attribute2_o =>ben_pel_shd.g_old_rec.pel_attribute2
205: ,p_enrt_perd_id_o =>ben_pel_shd.g_old_rec.enrt_perd_id
206: ,p_per_in_ler_id_o =>ben_pel_shd.g_old_rec.per_in_ler_id
207: ,p_pgm_id_o =>ben_pel_shd.g_old_rec.pgm_id
208: ,p_pl_id_o =>ben_pel_shd.g_old_rec.pl_id
209: ,p_business_group_id_o =>ben_pel_shd.g_old_rec.business_group_id
210: ,p_pel_attribute_category_o =>ben_pel_shd.g_old_rec.pel_attribute_category
211: ,p_pel_attribute1_o =>ben_pel_shd.g_old_rec.pel_attribute1
212: ,p_pel_attribute2_o =>ben_pel_shd.g_old_rec.pel_attribute2
213: ,p_pel_attribute3_o =>ben_pel_shd.g_old_rec.pel_attribute3
206: ,p_per_in_ler_id_o =>ben_pel_shd.g_old_rec.per_in_ler_id
207: ,p_pgm_id_o =>ben_pel_shd.g_old_rec.pgm_id
208: ,p_pl_id_o =>ben_pel_shd.g_old_rec.pl_id
209: ,p_business_group_id_o =>ben_pel_shd.g_old_rec.business_group_id
210: ,p_pel_attribute_category_o =>ben_pel_shd.g_old_rec.pel_attribute_category
211: ,p_pel_attribute1_o =>ben_pel_shd.g_old_rec.pel_attribute1
212: ,p_pel_attribute2_o =>ben_pel_shd.g_old_rec.pel_attribute2
213: ,p_pel_attribute3_o =>ben_pel_shd.g_old_rec.pel_attribute3
214: ,p_pel_attribute4_o =>ben_pel_shd.g_old_rec.pel_attribute4
207: ,p_pgm_id_o =>ben_pel_shd.g_old_rec.pgm_id
208: ,p_pl_id_o =>ben_pel_shd.g_old_rec.pl_id
209: ,p_business_group_id_o =>ben_pel_shd.g_old_rec.business_group_id
210: ,p_pel_attribute_category_o =>ben_pel_shd.g_old_rec.pel_attribute_category
211: ,p_pel_attribute1_o =>ben_pel_shd.g_old_rec.pel_attribute1
212: ,p_pel_attribute2_o =>ben_pel_shd.g_old_rec.pel_attribute2
213: ,p_pel_attribute3_o =>ben_pel_shd.g_old_rec.pel_attribute3
214: ,p_pel_attribute4_o =>ben_pel_shd.g_old_rec.pel_attribute4
215: ,p_pel_attribute5_o =>ben_pel_shd.g_old_rec.pel_attribute5
208: ,p_pl_id_o =>ben_pel_shd.g_old_rec.pl_id
209: ,p_business_group_id_o =>ben_pel_shd.g_old_rec.business_group_id
210: ,p_pel_attribute_category_o =>ben_pel_shd.g_old_rec.pel_attribute_category
211: ,p_pel_attribute1_o =>ben_pel_shd.g_old_rec.pel_attribute1
212: ,p_pel_attribute2_o =>ben_pel_shd.g_old_rec.pel_attribute2
213: ,p_pel_attribute3_o =>ben_pel_shd.g_old_rec.pel_attribute3
214: ,p_pel_attribute4_o =>ben_pel_shd.g_old_rec.pel_attribute4
215: ,p_pel_attribute5_o =>ben_pel_shd.g_old_rec.pel_attribute5
216: ,p_pel_attribute6_o =>ben_pel_shd.g_old_rec.pel_attribute6
209: ,p_business_group_id_o =>ben_pel_shd.g_old_rec.business_group_id
210: ,p_pel_attribute_category_o =>ben_pel_shd.g_old_rec.pel_attribute_category
211: ,p_pel_attribute1_o =>ben_pel_shd.g_old_rec.pel_attribute1
212: ,p_pel_attribute2_o =>ben_pel_shd.g_old_rec.pel_attribute2
213: ,p_pel_attribute3_o =>ben_pel_shd.g_old_rec.pel_attribute3
214: ,p_pel_attribute4_o =>ben_pel_shd.g_old_rec.pel_attribute4
215: ,p_pel_attribute5_o =>ben_pel_shd.g_old_rec.pel_attribute5
216: ,p_pel_attribute6_o =>ben_pel_shd.g_old_rec.pel_attribute6
217: ,p_pel_attribute7_o =>ben_pel_shd.g_old_rec.pel_attribute7
210: ,p_pel_attribute_category_o =>ben_pel_shd.g_old_rec.pel_attribute_category
211: ,p_pel_attribute1_o =>ben_pel_shd.g_old_rec.pel_attribute1
212: ,p_pel_attribute2_o =>ben_pel_shd.g_old_rec.pel_attribute2
213: ,p_pel_attribute3_o =>ben_pel_shd.g_old_rec.pel_attribute3
214: ,p_pel_attribute4_o =>ben_pel_shd.g_old_rec.pel_attribute4
215: ,p_pel_attribute5_o =>ben_pel_shd.g_old_rec.pel_attribute5
216: ,p_pel_attribute6_o =>ben_pel_shd.g_old_rec.pel_attribute6
217: ,p_pel_attribute7_o =>ben_pel_shd.g_old_rec.pel_attribute7
218: ,p_pel_attribute8_o =>ben_pel_shd.g_old_rec.pel_attribute8
211: ,p_pel_attribute1_o =>ben_pel_shd.g_old_rec.pel_attribute1
212: ,p_pel_attribute2_o =>ben_pel_shd.g_old_rec.pel_attribute2
213: ,p_pel_attribute3_o =>ben_pel_shd.g_old_rec.pel_attribute3
214: ,p_pel_attribute4_o =>ben_pel_shd.g_old_rec.pel_attribute4
215: ,p_pel_attribute5_o =>ben_pel_shd.g_old_rec.pel_attribute5
216: ,p_pel_attribute6_o =>ben_pel_shd.g_old_rec.pel_attribute6
217: ,p_pel_attribute7_o =>ben_pel_shd.g_old_rec.pel_attribute7
218: ,p_pel_attribute8_o =>ben_pel_shd.g_old_rec.pel_attribute8
219: ,p_pel_attribute9_o =>ben_pel_shd.g_old_rec.pel_attribute9
212: ,p_pel_attribute2_o =>ben_pel_shd.g_old_rec.pel_attribute2
213: ,p_pel_attribute3_o =>ben_pel_shd.g_old_rec.pel_attribute3
214: ,p_pel_attribute4_o =>ben_pel_shd.g_old_rec.pel_attribute4
215: ,p_pel_attribute5_o =>ben_pel_shd.g_old_rec.pel_attribute5
216: ,p_pel_attribute6_o =>ben_pel_shd.g_old_rec.pel_attribute6
217: ,p_pel_attribute7_o =>ben_pel_shd.g_old_rec.pel_attribute7
218: ,p_pel_attribute8_o =>ben_pel_shd.g_old_rec.pel_attribute8
219: ,p_pel_attribute9_o =>ben_pel_shd.g_old_rec.pel_attribute9
220: ,p_pel_attribute10_o =>ben_pel_shd.g_old_rec.pel_attribute10
213: ,p_pel_attribute3_o =>ben_pel_shd.g_old_rec.pel_attribute3
214: ,p_pel_attribute4_o =>ben_pel_shd.g_old_rec.pel_attribute4
215: ,p_pel_attribute5_o =>ben_pel_shd.g_old_rec.pel_attribute5
216: ,p_pel_attribute6_o =>ben_pel_shd.g_old_rec.pel_attribute6
217: ,p_pel_attribute7_o =>ben_pel_shd.g_old_rec.pel_attribute7
218: ,p_pel_attribute8_o =>ben_pel_shd.g_old_rec.pel_attribute8
219: ,p_pel_attribute9_o =>ben_pel_shd.g_old_rec.pel_attribute9
220: ,p_pel_attribute10_o =>ben_pel_shd.g_old_rec.pel_attribute10
221: ,p_pel_attribute11_o =>ben_pel_shd.g_old_rec.pel_attribute11
214: ,p_pel_attribute4_o =>ben_pel_shd.g_old_rec.pel_attribute4
215: ,p_pel_attribute5_o =>ben_pel_shd.g_old_rec.pel_attribute5
216: ,p_pel_attribute6_o =>ben_pel_shd.g_old_rec.pel_attribute6
217: ,p_pel_attribute7_o =>ben_pel_shd.g_old_rec.pel_attribute7
218: ,p_pel_attribute8_o =>ben_pel_shd.g_old_rec.pel_attribute8
219: ,p_pel_attribute9_o =>ben_pel_shd.g_old_rec.pel_attribute9
220: ,p_pel_attribute10_o =>ben_pel_shd.g_old_rec.pel_attribute10
221: ,p_pel_attribute11_o =>ben_pel_shd.g_old_rec.pel_attribute11
222: ,p_pel_attribute12_o =>ben_pel_shd.g_old_rec.pel_attribute12
215: ,p_pel_attribute5_o =>ben_pel_shd.g_old_rec.pel_attribute5
216: ,p_pel_attribute6_o =>ben_pel_shd.g_old_rec.pel_attribute6
217: ,p_pel_attribute7_o =>ben_pel_shd.g_old_rec.pel_attribute7
218: ,p_pel_attribute8_o =>ben_pel_shd.g_old_rec.pel_attribute8
219: ,p_pel_attribute9_o =>ben_pel_shd.g_old_rec.pel_attribute9
220: ,p_pel_attribute10_o =>ben_pel_shd.g_old_rec.pel_attribute10
221: ,p_pel_attribute11_o =>ben_pel_shd.g_old_rec.pel_attribute11
222: ,p_pel_attribute12_o =>ben_pel_shd.g_old_rec.pel_attribute12
223: ,p_pel_attribute13_o =>ben_pel_shd.g_old_rec.pel_attribute13
216: ,p_pel_attribute6_o =>ben_pel_shd.g_old_rec.pel_attribute6
217: ,p_pel_attribute7_o =>ben_pel_shd.g_old_rec.pel_attribute7
218: ,p_pel_attribute8_o =>ben_pel_shd.g_old_rec.pel_attribute8
219: ,p_pel_attribute9_o =>ben_pel_shd.g_old_rec.pel_attribute9
220: ,p_pel_attribute10_o =>ben_pel_shd.g_old_rec.pel_attribute10
221: ,p_pel_attribute11_o =>ben_pel_shd.g_old_rec.pel_attribute11
222: ,p_pel_attribute12_o =>ben_pel_shd.g_old_rec.pel_attribute12
223: ,p_pel_attribute13_o =>ben_pel_shd.g_old_rec.pel_attribute13
224: ,p_pel_attribute14_o =>ben_pel_shd.g_old_rec.pel_attribute14
217: ,p_pel_attribute7_o =>ben_pel_shd.g_old_rec.pel_attribute7
218: ,p_pel_attribute8_o =>ben_pel_shd.g_old_rec.pel_attribute8
219: ,p_pel_attribute9_o =>ben_pel_shd.g_old_rec.pel_attribute9
220: ,p_pel_attribute10_o =>ben_pel_shd.g_old_rec.pel_attribute10
221: ,p_pel_attribute11_o =>ben_pel_shd.g_old_rec.pel_attribute11
222: ,p_pel_attribute12_o =>ben_pel_shd.g_old_rec.pel_attribute12
223: ,p_pel_attribute13_o =>ben_pel_shd.g_old_rec.pel_attribute13
224: ,p_pel_attribute14_o =>ben_pel_shd.g_old_rec.pel_attribute14
225: ,p_pel_attribute15_o =>ben_pel_shd.g_old_rec.pel_attribute15
218: ,p_pel_attribute8_o =>ben_pel_shd.g_old_rec.pel_attribute8
219: ,p_pel_attribute9_o =>ben_pel_shd.g_old_rec.pel_attribute9
220: ,p_pel_attribute10_o =>ben_pel_shd.g_old_rec.pel_attribute10
221: ,p_pel_attribute11_o =>ben_pel_shd.g_old_rec.pel_attribute11
222: ,p_pel_attribute12_o =>ben_pel_shd.g_old_rec.pel_attribute12
223: ,p_pel_attribute13_o =>ben_pel_shd.g_old_rec.pel_attribute13
224: ,p_pel_attribute14_o =>ben_pel_shd.g_old_rec.pel_attribute14
225: ,p_pel_attribute15_o =>ben_pel_shd.g_old_rec.pel_attribute15
226: ,p_pel_attribute16_o =>ben_pel_shd.g_old_rec.pel_attribute16
219: ,p_pel_attribute9_o =>ben_pel_shd.g_old_rec.pel_attribute9
220: ,p_pel_attribute10_o =>ben_pel_shd.g_old_rec.pel_attribute10
221: ,p_pel_attribute11_o =>ben_pel_shd.g_old_rec.pel_attribute11
222: ,p_pel_attribute12_o =>ben_pel_shd.g_old_rec.pel_attribute12
223: ,p_pel_attribute13_o =>ben_pel_shd.g_old_rec.pel_attribute13
224: ,p_pel_attribute14_o =>ben_pel_shd.g_old_rec.pel_attribute14
225: ,p_pel_attribute15_o =>ben_pel_shd.g_old_rec.pel_attribute15
226: ,p_pel_attribute16_o =>ben_pel_shd.g_old_rec.pel_attribute16
227: ,p_pel_attribute17_o =>ben_pel_shd.g_old_rec.pel_attribute17
220: ,p_pel_attribute10_o =>ben_pel_shd.g_old_rec.pel_attribute10
221: ,p_pel_attribute11_o =>ben_pel_shd.g_old_rec.pel_attribute11
222: ,p_pel_attribute12_o =>ben_pel_shd.g_old_rec.pel_attribute12
223: ,p_pel_attribute13_o =>ben_pel_shd.g_old_rec.pel_attribute13
224: ,p_pel_attribute14_o =>ben_pel_shd.g_old_rec.pel_attribute14
225: ,p_pel_attribute15_o =>ben_pel_shd.g_old_rec.pel_attribute15
226: ,p_pel_attribute16_o =>ben_pel_shd.g_old_rec.pel_attribute16
227: ,p_pel_attribute17_o =>ben_pel_shd.g_old_rec.pel_attribute17
228: ,p_pel_attribute18_o =>ben_pel_shd.g_old_rec.pel_attribute18
221: ,p_pel_attribute11_o =>ben_pel_shd.g_old_rec.pel_attribute11
222: ,p_pel_attribute12_o =>ben_pel_shd.g_old_rec.pel_attribute12
223: ,p_pel_attribute13_o =>ben_pel_shd.g_old_rec.pel_attribute13
224: ,p_pel_attribute14_o =>ben_pel_shd.g_old_rec.pel_attribute14
225: ,p_pel_attribute15_o =>ben_pel_shd.g_old_rec.pel_attribute15
226: ,p_pel_attribute16_o =>ben_pel_shd.g_old_rec.pel_attribute16
227: ,p_pel_attribute17_o =>ben_pel_shd.g_old_rec.pel_attribute17
228: ,p_pel_attribute18_o =>ben_pel_shd.g_old_rec.pel_attribute18
229: ,p_pel_attribute19_o =>ben_pel_shd.g_old_rec.pel_attribute19
222: ,p_pel_attribute12_o =>ben_pel_shd.g_old_rec.pel_attribute12
223: ,p_pel_attribute13_o =>ben_pel_shd.g_old_rec.pel_attribute13
224: ,p_pel_attribute14_o =>ben_pel_shd.g_old_rec.pel_attribute14
225: ,p_pel_attribute15_o =>ben_pel_shd.g_old_rec.pel_attribute15
226: ,p_pel_attribute16_o =>ben_pel_shd.g_old_rec.pel_attribute16
227: ,p_pel_attribute17_o =>ben_pel_shd.g_old_rec.pel_attribute17
228: ,p_pel_attribute18_o =>ben_pel_shd.g_old_rec.pel_attribute18
229: ,p_pel_attribute19_o =>ben_pel_shd.g_old_rec.pel_attribute19
230: ,p_pel_attribute20_o =>ben_pel_shd.g_old_rec.pel_attribute20
223: ,p_pel_attribute13_o =>ben_pel_shd.g_old_rec.pel_attribute13
224: ,p_pel_attribute14_o =>ben_pel_shd.g_old_rec.pel_attribute14
225: ,p_pel_attribute15_o =>ben_pel_shd.g_old_rec.pel_attribute15
226: ,p_pel_attribute16_o =>ben_pel_shd.g_old_rec.pel_attribute16
227: ,p_pel_attribute17_o =>ben_pel_shd.g_old_rec.pel_attribute17
228: ,p_pel_attribute18_o =>ben_pel_shd.g_old_rec.pel_attribute18
229: ,p_pel_attribute19_o =>ben_pel_shd.g_old_rec.pel_attribute19
230: ,p_pel_attribute20_o =>ben_pel_shd.g_old_rec.pel_attribute20
231: ,p_pel_attribute21_o =>ben_pel_shd.g_old_rec.pel_attribute21
224: ,p_pel_attribute14_o =>ben_pel_shd.g_old_rec.pel_attribute14
225: ,p_pel_attribute15_o =>ben_pel_shd.g_old_rec.pel_attribute15
226: ,p_pel_attribute16_o =>ben_pel_shd.g_old_rec.pel_attribute16
227: ,p_pel_attribute17_o =>ben_pel_shd.g_old_rec.pel_attribute17
228: ,p_pel_attribute18_o =>ben_pel_shd.g_old_rec.pel_attribute18
229: ,p_pel_attribute19_o =>ben_pel_shd.g_old_rec.pel_attribute19
230: ,p_pel_attribute20_o =>ben_pel_shd.g_old_rec.pel_attribute20
231: ,p_pel_attribute21_o =>ben_pel_shd.g_old_rec.pel_attribute21
232: ,p_pel_attribute22_o =>ben_pel_shd.g_old_rec.pel_attribute22
225: ,p_pel_attribute15_o =>ben_pel_shd.g_old_rec.pel_attribute15
226: ,p_pel_attribute16_o =>ben_pel_shd.g_old_rec.pel_attribute16
227: ,p_pel_attribute17_o =>ben_pel_shd.g_old_rec.pel_attribute17
228: ,p_pel_attribute18_o =>ben_pel_shd.g_old_rec.pel_attribute18
229: ,p_pel_attribute19_o =>ben_pel_shd.g_old_rec.pel_attribute19
230: ,p_pel_attribute20_o =>ben_pel_shd.g_old_rec.pel_attribute20
231: ,p_pel_attribute21_o =>ben_pel_shd.g_old_rec.pel_attribute21
232: ,p_pel_attribute22_o =>ben_pel_shd.g_old_rec.pel_attribute22
233: ,p_pel_attribute23_o =>ben_pel_shd.g_old_rec.pel_attribute23
226: ,p_pel_attribute16_o =>ben_pel_shd.g_old_rec.pel_attribute16
227: ,p_pel_attribute17_o =>ben_pel_shd.g_old_rec.pel_attribute17
228: ,p_pel_attribute18_o =>ben_pel_shd.g_old_rec.pel_attribute18
229: ,p_pel_attribute19_o =>ben_pel_shd.g_old_rec.pel_attribute19
230: ,p_pel_attribute20_o =>ben_pel_shd.g_old_rec.pel_attribute20
231: ,p_pel_attribute21_o =>ben_pel_shd.g_old_rec.pel_attribute21
232: ,p_pel_attribute22_o =>ben_pel_shd.g_old_rec.pel_attribute22
233: ,p_pel_attribute23_o =>ben_pel_shd.g_old_rec.pel_attribute23
234: ,p_pel_attribute24_o =>ben_pel_shd.g_old_rec.pel_attribute24
227: ,p_pel_attribute17_o =>ben_pel_shd.g_old_rec.pel_attribute17
228: ,p_pel_attribute18_o =>ben_pel_shd.g_old_rec.pel_attribute18
229: ,p_pel_attribute19_o =>ben_pel_shd.g_old_rec.pel_attribute19
230: ,p_pel_attribute20_o =>ben_pel_shd.g_old_rec.pel_attribute20
231: ,p_pel_attribute21_o =>ben_pel_shd.g_old_rec.pel_attribute21
232: ,p_pel_attribute22_o =>ben_pel_shd.g_old_rec.pel_attribute22
233: ,p_pel_attribute23_o =>ben_pel_shd.g_old_rec.pel_attribute23
234: ,p_pel_attribute24_o =>ben_pel_shd.g_old_rec.pel_attribute24
235: ,p_pel_attribute25_o =>ben_pel_shd.g_old_rec.pel_attribute25
228: ,p_pel_attribute18_o =>ben_pel_shd.g_old_rec.pel_attribute18
229: ,p_pel_attribute19_o =>ben_pel_shd.g_old_rec.pel_attribute19
230: ,p_pel_attribute20_o =>ben_pel_shd.g_old_rec.pel_attribute20
231: ,p_pel_attribute21_o =>ben_pel_shd.g_old_rec.pel_attribute21
232: ,p_pel_attribute22_o =>ben_pel_shd.g_old_rec.pel_attribute22
233: ,p_pel_attribute23_o =>ben_pel_shd.g_old_rec.pel_attribute23
234: ,p_pel_attribute24_o =>ben_pel_shd.g_old_rec.pel_attribute24
235: ,p_pel_attribute25_o =>ben_pel_shd.g_old_rec.pel_attribute25
236: ,p_pel_attribute26_o =>ben_pel_shd.g_old_rec.pel_attribute26
229: ,p_pel_attribute19_o =>ben_pel_shd.g_old_rec.pel_attribute19
230: ,p_pel_attribute20_o =>ben_pel_shd.g_old_rec.pel_attribute20
231: ,p_pel_attribute21_o =>ben_pel_shd.g_old_rec.pel_attribute21
232: ,p_pel_attribute22_o =>ben_pel_shd.g_old_rec.pel_attribute22
233: ,p_pel_attribute23_o =>ben_pel_shd.g_old_rec.pel_attribute23
234: ,p_pel_attribute24_o =>ben_pel_shd.g_old_rec.pel_attribute24
235: ,p_pel_attribute25_o =>ben_pel_shd.g_old_rec.pel_attribute25
236: ,p_pel_attribute26_o =>ben_pel_shd.g_old_rec.pel_attribute26
237: ,p_pel_attribute27_o =>ben_pel_shd.g_old_rec.pel_attribute27
230: ,p_pel_attribute20_o =>ben_pel_shd.g_old_rec.pel_attribute20
231: ,p_pel_attribute21_o =>ben_pel_shd.g_old_rec.pel_attribute21
232: ,p_pel_attribute22_o =>ben_pel_shd.g_old_rec.pel_attribute22
233: ,p_pel_attribute23_o =>ben_pel_shd.g_old_rec.pel_attribute23
234: ,p_pel_attribute24_o =>ben_pel_shd.g_old_rec.pel_attribute24
235: ,p_pel_attribute25_o =>ben_pel_shd.g_old_rec.pel_attribute25
236: ,p_pel_attribute26_o =>ben_pel_shd.g_old_rec.pel_attribute26
237: ,p_pel_attribute27_o =>ben_pel_shd.g_old_rec.pel_attribute27
238: ,p_pel_attribute28_o =>ben_pel_shd.g_old_rec.pel_attribute28
231: ,p_pel_attribute21_o =>ben_pel_shd.g_old_rec.pel_attribute21
232: ,p_pel_attribute22_o =>ben_pel_shd.g_old_rec.pel_attribute22
233: ,p_pel_attribute23_o =>ben_pel_shd.g_old_rec.pel_attribute23
234: ,p_pel_attribute24_o =>ben_pel_shd.g_old_rec.pel_attribute24
235: ,p_pel_attribute25_o =>ben_pel_shd.g_old_rec.pel_attribute25
236: ,p_pel_attribute26_o =>ben_pel_shd.g_old_rec.pel_attribute26
237: ,p_pel_attribute27_o =>ben_pel_shd.g_old_rec.pel_attribute27
238: ,p_pel_attribute28_o =>ben_pel_shd.g_old_rec.pel_attribute28
239: ,p_pel_attribute29_o =>ben_pel_shd.g_old_rec.pel_attribute29
232: ,p_pel_attribute22_o =>ben_pel_shd.g_old_rec.pel_attribute22
233: ,p_pel_attribute23_o =>ben_pel_shd.g_old_rec.pel_attribute23
234: ,p_pel_attribute24_o =>ben_pel_shd.g_old_rec.pel_attribute24
235: ,p_pel_attribute25_o =>ben_pel_shd.g_old_rec.pel_attribute25
236: ,p_pel_attribute26_o =>ben_pel_shd.g_old_rec.pel_attribute26
237: ,p_pel_attribute27_o =>ben_pel_shd.g_old_rec.pel_attribute27
238: ,p_pel_attribute28_o =>ben_pel_shd.g_old_rec.pel_attribute28
239: ,p_pel_attribute29_o =>ben_pel_shd.g_old_rec.pel_attribute29
240: ,p_pel_attribute30_o =>ben_pel_shd.g_old_rec.pel_attribute30
233: ,p_pel_attribute23_o =>ben_pel_shd.g_old_rec.pel_attribute23
234: ,p_pel_attribute24_o =>ben_pel_shd.g_old_rec.pel_attribute24
235: ,p_pel_attribute25_o =>ben_pel_shd.g_old_rec.pel_attribute25
236: ,p_pel_attribute26_o =>ben_pel_shd.g_old_rec.pel_attribute26
237: ,p_pel_attribute27_o =>ben_pel_shd.g_old_rec.pel_attribute27
238: ,p_pel_attribute28_o =>ben_pel_shd.g_old_rec.pel_attribute28
239: ,p_pel_attribute29_o =>ben_pel_shd.g_old_rec.pel_attribute29
240: ,p_pel_attribute30_o =>ben_pel_shd.g_old_rec.pel_attribute30
241: ,p_request_id_o =>ben_pel_shd.g_old_rec.request_id
234: ,p_pel_attribute24_o =>ben_pel_shd.g_old_rec.pel_attribute24
235: ,p_pel_attribute25_o =>ben_pel_shd.g_old_rec.pel_attribute25
236: ,p_pel_attribute26_o =>ben_pel_shd.g_old_rec.pel_attribute26
237: ,p_pel_attribute27_o =>ben_pel_shd.g_old_rec.pel_attribute27
238: ,p_pel_attribute28_o =>ben_pel_shd.g_old_rec.pel_attribute28
239: ,p_pel_attribute29_o =>ben_pel_shd.g_old_rec.pel_attribute29
240: ,p_pel_attribute30_o =>ben_pel_shd.g_old_rec.pel_attribute30
241: ,p_request_id_o =>ben_pel_shd.g_old_rec.request_id
242: ,p_program_application_id_o =>ben_pel_shd.g_old_rec.program_application_id
235: ,p_pel_attribute25_o =>ben_pel_shd.g_old_rec.pel_attribute25
236: ,p_pel_attribute26_o =>ben_pel_shd.g_old_rec.pel_attribute26
237: ,p_pel_attribute27_o =>ben_pel_shd.g_old_rec.pel_attribute27
238: ,p_pel_attribute28_o =>ben_pel_shd.g_old_rec.pel_attribute28
239: ,p_pel_attribute29_o =>ben_pel_shd.g_old_rec.pel_attribute29
240: ,p_pel_attribute30_o =>ben_pel_shd.g_old_rec.pel_attribute30
241: ,p_request_id_o =>ben_pel_shd.g_old_rec.request_id
242: ,p_program_application_id_o =>ben_pel_shd.g_old_rec.program_application_id
243: ,p_program_id_o =>ben_pel_shd.g_old_rec.program_id
236: ,p_pel_attribute26_o =>ben_pel_shd.g_old_rec.pel_attribute26
237: ,p_pel_attribute27_o =>ben_pel_shd.g_old_rec.pel_attribute27
238: ,p_pel_attribute28_o =>ben_pel_shd.g_old_rec.pel_attribute28
239: ,p_pel_attribute29_o =>ben_pel_shd.g_old_rec.pel_attribute29
240: ,p_pel_attribute30_o =>ben_pel_shd.g_old_rec.pel_attribute30
241: ,p_request_id_o =>ben_pel_shd.g_old_rec.request_id
242: ,p_program_application_id_o =>ben_pel_shd.g_old_rec.program_application_id
243: ,p_program_id_o =>ben_pel_shd.g_old_rec.program_id
244: ,p_program_update_date_o =>ben_pel_shd.g_old_rec.program_update_date
237: ,p_pel_attribute27_o =>ben_pel_shd.g_old_rec.pel_attribute27
238: ,p_pel_attribute28_o =>ben_pel_shd.g_old_rec.pel_attribute28
239: ,p_pel_attribute29_o =>ben_pel_shd.g_old_rec.pel_attribute29
240: ,p_pel_attribute30_o =>ben_pel_shd.g_old_rec.pel_attribute30
241: ,p_request_id_o =>ben_pel_shd.g_old_rec.request_id
242: ,p_program_application_id_o =>ben_pel_shd.g_old_rec.program_application_id
243: ,p_program_id_o =>ben_pel_shd.g_old_rec.program_id
244: ,p_program_update_date_o =>ben_pel_shd.g_old_rec.program_update_date
245: ,p_object_version_number_o =>ben_pel_shd.g_old_rec.object_version_number
238: ,p_pel_attribute28_o =>ben_pel_shd.g_old_rec.pel_attribute28
239: ,p_pel_attribute29_o =>ben_pel_shd.g_old_rec.pel_attribute29
240: ,p_pel_attribute30_o =>ben_pel_shd.g_old_rec.pel_attribute30
241: ,p_request_id_o =>ben_pel_shd.g_old_rec.request_id
242: ,p_program_application_id_o =>ben_pel_shd.g_old_rec.program_application_id
243: ,p_program_id_o =>ben_pel_shd.g_old_rec.program_id
244: ,p_program_update_date_o =>ben_pel_shd.g_old_rec.program_update_date
245: ,p_object_version_number_o =>ben_pel_shd.g_old_rec.object_version_number
246: ,p_defer_deenrol_flag_o =>ben_pel_shd.g_old_rec.defer_deenrol_flag
239: ,p_pel_attribute29_o =>ben_pel_shd.g_old_rec.pel_attribute29
240: ,p_pel_attribute30_o =>ben_pel_shd.g_old_rec.pel_attribute30
241: ,p_request_id_o =>ben_pel_shd.g_old_rec.request_id
242: ,p_program_application_id_o =>ben_pel_shd.g_old_rec.program_application_id
243: ,p_program_id_o =>ben_pel_shd.g_old_rec.program_id
244: ,p_program_update_date_o =>ben_pel_shd.g_old_rec.program_update_date
245: ,p_object_version_number_o =>ben_pel_shd.g_old_rec.object_version_number
246: ,p_defer_deenrol_flag_o =>ben_pel_shd.g_old_rec.defer_deenrol_flag
247: ,p_deenrol_made_dt_o =>ben_pel_shd.g_old_rec.deenrol_made_dt
240: ,p_pel_attribute30_o =>ben_pel_shd.g_old_rec.pel_attribute30
241: ,p_request_id_o =>ben_pel_shd.g_old_rec.request_id
242: ,p_program_application_id_o =>ben_pel_shd.g_old_rec.program_application_id
243: ,p_program_id_o =>ben_pel_shd.g_old_rec.program_id
244: ,p_program_update_date_o =>ben_pel_shd.g_old_rec.program_update_date
245: ,p_object_version_number_o =>ben_pel_shd.g_old_rec.object_version_number
246: ,p_defer_deenrol_flag_o =>ben_pel_shd.g_old_rec.defer_deenrol_flag
247: ,p_deenrol_made_dt_o =>ben_pel_shd.g_old_rec.deenrol_made_dt
248: );
241: ,p_request_id_o =>ben_pel_shd.g_old_rec.request_id
242: ,p_program_application_id_o =>ben_pel_shd.g_old_rec.program_application_id
243: ,p_program_id_o =>ben_pel_shd.g_old_rec.program_id
244: ,p_program_update_date_o =>ben_pel_shd.g_old_rec.program_update_date
245: ,p_object_version_number_o =>ben_pel_shd.g_old_rec.object_version_number
246: ,p_defer_deenrol_flag_o =>ben_pel_shd.g_old_rec.defer_deenrol_flag
247: ,p_deenrol_made_dt_o =>ben_pel_shd.g_old_rec.deenrol_made_dt
248: );
249: --
242: ,p_program_application_id_o =>ben_pel_shd.g_old_rec.program_application_id
243: ,p_program_id_o =>ben_pel_shd.g_old_rec.program_id
244: ,p_program_update_date_o =>ben_pel_shd.g_old_rec.program_update_date
245: ,p_object_version_number_o =>ben_pel_shd.g_old_rec.object_version_number
246: ,p_defer_deenrol_flag_o =>ben_pel_shd.g_old_rec.defer_deenrol_flag
247: ,p_deenrol_made_dt_o =>ben_pel_shd.g_old_rec.deenrol_made_dt
248: );
249: --
250: exception
243: ,p_program_id_o =>ben_pel_shd.g_old_rec.program_id
244: ,p_program_update_date_o =>ben_pel_shd.g_old_rec.program_update_date
245: ,p_object_version_number_o =>ben_pel_shd.g_old_rec.object_version_number
246: ,p_defer_deenrol_flag_o =>ben_pel_shd.g_old_rec.defer_deenrol_flag
247: ,p_deenrol_made_dt_o =>ben_pel_shd.g_old_rec.deenrol_made_dt
248: );
249: --
250: exception
251: --
268: -- ----------------------------------------------------------------------------
269: Procedure del
270: (
271: p_effective_date in date,
272: p_rec in ben_pel_shd.g_rec_type
273: ) is
274: --
275: l_proc varchar2(72) := g_package||'del';
276: --
278: hr_utility.set_location('Entering:'||l_proc, 5);
279: --
280: -- We must lock the row which we need to delete.
281: --
282: ben_pel_shd.lck
283: (
284: p_rec.pil_elctbl_chc_popl_id,
285: p_rec.object_version_number
286: );
313: p_pil_elctbl_chc_popl_id in number,
314: p_object_version_number in number
315: ) is
316: --
317: l_rec ben_pel_shd.g_rec_type;
318: l_proc varchar2(72) := g_package||'del';
319: --
320: Begin
321: hr_utility.set_location('Entering:'||l_proc, 5);