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_reopen_le_on_reprocess_o =>ben_pel_shd.g_old_rec.reopen_le_on_reprocess
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_reopen_le_on_reprocess_o =>ben_pel_shd.g_old_rec.reopen_le_on_reprocess
202: ,p_auto_asnd_dt_o =>ben_pel_shd.g_old_rec.auto_asnd_dt
203: ,p_cbr_elig_perd_strt_dt_o =>ben_pel_shd.g_old_rec.cbr_elig_perd_strt_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_reopen_le_on_reprocess_o =>ben_pel_shd.g_old_rec.reopen_le_on_reprocess
202: ,p_auto_asnd_dt_o =>ben_pel_shd.g_old_rec.auto_asnd_dt
203: ,p_cbr_elig_perd_strt_dt_o =>ben_pel_shd.g_old_rec.cbr_elig_perd_strt_dt
204: ,p_cbr_elig_perd_end_dt_o =>ben_pel_shd.g_old_rec.cbr_elig_perd_end_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_reopen_le_on_reprocess_o =>ben_pel_shd.g_old_rec.reopen_le_on_reprocess
202: ,p_auto_asnd_dt_o =>ben_pel_shd.g_old_rec.auto_asnd_dt
203: ,p_cbr_elig_perd_strt_dt_o =>ben_pel_shd.g_old_rec.cbr_elig_perd_strt_dt
204: ,p_cbr_elig_perd_end_dt_o =>ben_pel_shd.g_old_rec.cbr_elig_perd_end_dt
205: ,p_lee_rsn_id_o =>ben_pel_shd.g_old_rec.lee_rsn_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_reopen_le_on_reprocess_o =>ben_pel_shd.g_old_rec.reopen_le_on_reprocess
202: ,p_auto_asnd_dt_o =>ben_pel_shd.g_old_rec.auto_asnd_dt
203: ,p_cbr_elig_perd_strt_dt_o =>ben_pel_shd.g_old_rec.cbr_elig_perd_strt_dt
204: ,p_cbr_elig_perd_end_dt_o =>ben_pel_shd.g_old_rec.cbr_elig_perd_end_dt
205: ,p_lee_rsn_id_o =>ben_pel_shd.g_old_rec.lee_rsn_id
206: ,p_enrt_perd_id_o =>ben_pel_shd.g_old_rec.enrt_perd_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_reopen_le_on_reprocess_o =>ben_pel_shd.g_old_rec.reopen_le_on_reprocess
202: ,p_auto_asnd_dt_o =>ben_pel_shd.g_old_rec.auto_asnd_dt
203: ,p_cbr_elig_perd_strt_dt_o =>ben_pel_shd.g_old_rec.cbr_elig_perd_strt_dt
204: ,p_cbr_elig_perd_end_dt_o =>ben_pel_shd.g_old_rec.cbr_elig_perd_end_dt
205: ,p_lee_rsn_id_o =>ben_pel_shd.g_old_rec.lee_rsn_id
206: ,p_enrt_perd_id_o =>ben_pel_shd.g_old_rec.enrt_perd_id
207: ,p_per_in_ler_id_o =>ben_pel_shd.g_old_rec.per_in_ler_id
200: ,p_reinstate_ovrdn_cd_o =>ben_pel_shd.g_old_rec.reinstate_ovrdn_cd
201: ,p_reopen_le_on_reprocess_o =>ben_pel_shd.g_old_rec.reopen_le_on_reprocess
202: ,p_auto_asnd_dt_o =>ben_pel_shd.g_old_rec.auto_asnd_dt
203: ,p_cbr_elig_perd_strt_dt_o =>ben_pel_shd.g_old_rec.cbr_elig_perd_strt_dt
204: ,p_cbr_elig_perd_end_dt_o =>ben_pel_shd.g_old_rec.cbr_elig_perd_end_dt
205: ,p_lee_rsn_id_o =>ben_pel_shd.g_old_rec.lee_rsn_id
206: ,p_enrt_perd_id_o =>ben_pel_shd.g_old_rec.enrt_perd_id
207: ,p_per_in_ler_id_o =>ben_pel_shd.g_old_rec.per_in_ler_id
208: ,p_pgm_id_o =>ben_pel_shd.g_old_rec.pgm_id
201: ,p_reopen_le_on_reprocess_o =>ben_pel_shd.g_old_rec.reopen_le_on_reprocess
202: ,p_auto_asnd_dt_o =>ben_pel_shd.g_old_rec.auto_asnd_dt
203: ,p_cbr_elig_perd_strt_dt_o =>ben_pel_shd.g_old_rec.cbr_elig_perd_strt_dt
204: ,p_cbr_elig_perd_end_dt_o =>ben_pel_shd.g_old_rec.cbr_elig_perd_end_dt
205: ,p_lee_rsn_id_o =>ben_pel_shd.g_old_rec.lee_rsn_id
206: ,p_enrt_perd_id_o =>ben_pel_shd.g_old_rec.enrt_perd_id
207: ,p_per_in_ler_id_o =>ben_pel_shd.g_old_rec.per_in_ler_id
208: ,p_pgm_id_o =>ben_pel_shd.g_old_rec.pgm_id
209: ,p_pl_id_o =>ben_pel_shd.g_old_rec.pl_id
202: ,p_auto_asnd_dt_o =>ben_pel_shd.g_old_rec.auto_asnd_dt
203: ,p_cbr_elig_perd_strt_dt_o =>ben_pel_shd.g_old_rec.cbr_elig_perd_strt_dt
204: ,p_cbr_elig_perd_end_dt_o =>ben_pel_shd.g_old_rec.cbr_elig_perd_end_dt
205: ,p_lee_rsn_id_o =>ben_pel_shd.g_old_rec.lee_rsn_id
206: ,p_enrt_perd_id_o =>ben_pel_shd.g_old_rec.enrt_perd_id
207: ,p_per_in_ler_id_o =>ben_pel_shd.g_old_rec.per_in_ler_id
208: ,p_pgm_id_o =>ben_pel_shd.g_old_rec.pgm_id
209: ,p_pl_id_o =>ben_pel_shd.g_old_rec.pl_id
210: ,p_business_group_id_o =>ben_pel_shd.g_old_rec.business_group_id
203: ,p_cbr_elig_perd_strt_dt_o =>ben_pel_shd.g_old_rec.cbr_elig_perd_strt_dt
204: ,p_cbr_elig_perd_end_dt_o =>ben_pel_shd.g_old_rec.cbr_elig_perd_end_dt
205: ,p_lee_rsn_id_o =>ben_pel_shd.g_old_rec.lee_rsn_id
206: ,p_enrt_perd_id_o =>ben_pel_shd.g_old_rec.enrt_perd_id
207: ,p_per_in_ler_id_o =>ben_pel_shd.g_old_rec.per_in_ler_id
208: ,p_pgm_id_o =>ben_pel_shd.g_old_rec.pgm_id
209: ,p_pl_id_o =>ben_pel_shd.g_old_rec.pl_id
210: ,p_business_group_id_o =>ben_pel_shd.g_old_rec.business_group_id
211: ,p_pel_attribute_category_o =>ben_pel_shd.g_old_rec.pel_attribute_category
204: ,p_cbr_elig_perd_end_dt_o =>ben_pel_shd.g_old_rec.cbr_elig_perd_end_dt
205: ,p_lee_rsn_id_o =>ben_pel_shd.g_old_rec.lee_rsn_id
206: ,p_enrt_perd_id_o =>ben_pel_shd.g_old_rec.enrt_perd_id
207: ,p_per_in_ler_id_o =>ben_pel_shd.g_old_rec.per_in_ler_id
208: ,p_pgm_id_o =>ben_pel_shd.g_old_rec.pgm_id
209: ,p_pl_id_o =>ben_pel_shd.g_old_rec.pl_id
210: ,p_business_group_id_o =>ben_pel_shd.g_old_rec.business_group_id
211: ,p_pel_attribute_category_o =>ben_pel_shd.g_old_rec.pel_attribute_category
212: ,p_pel_attribute1_o =>ben_pel_shd.g_old_rec.pel_attribute1
205: ,p_lee_rsn_id_o =>ben_pel_shd.g_old_rec.lee_rsn_id
206: ,p_enrt_perd_id_o =>ben_pel_shd.g_old_rec.enrt_perd_id
207: ,p_per_in_ler_id_o =>ben_pel_shd.g_old_rec.per_in_ler_id
208: ,p_pgm_id_o =>ben_pel_shd.g_old_rec.pgm_id
209: ,p_pl_id_o =>ben_pel_shd.g_old_rec.pl_id
210: ,p_business_group_id_o =>ben_pel_shd.g_old_rec.business_group_id
211: ,p_pel_attribute_category_o =>ben_pel_shd.g_old_rec.pel_attribute_category
212: ,p_pel_attribute1_o =>ben_pel_shd.g_old_rec.pel_attribute1
213: ,p_pel_attribute2_o =>ben_pel_shd.g_old_rec.pel_attribute2
206: ,p_enrt_perd_id_o =>ben_pel_shd.g_old_rec.enrt_perd_id
207: ,p_per_in_ler_id_o =>ben_pel_shd.g_old_rec.per_in_ler_id
208: ,p_pgm_id_o =>ben_pel_shd.g_old_rec.pgm_id
209: ,p_pl_id_o =>ben_pel_shd.g_old_rec.pl_id
210: ,p_business_group_id_o =>ben_pel_shd.g_old_rec.business_group_id
211: ,p_pel_attribute_category_o =>ben_pel_shd.g_old_rec.pel_attribute_category
212: ,p_pel_attribute1_o =>ben_pel_shd.g_old_rec.pel_attribute1
213: ,p_pel_attribute2_o =>ben_pel_shd.g_old_rec.pel_attribute2
214: ,p_pel_attribute3_o =>ben_pel_shd.g_old_rec.pel_attribute3
207: ,p_per_in_ler_id_o =>ben_pel_shd.g_old_rec.per_in_ler_id
208: ,p_pgm_id_o =>ben_pel_shd.g_old_rec.pgm_id
209: ,p_pl_id_o =>ben_pel_shd.g_old_rec.pl_id
210: ,p_business_group_id_o =>ben_pel_shd.g_old_rec.business_group_id
211: ,p_pel_attribute_category_o =>ben_pel_shd.g_old_rec.pel_attribute_category
212: ,p_pel_attribute1_o =>ben_pel_shd.g_old_rec.pel_attribute1
213: ,p_pel_attribute2_o =>ben_pel_shd.g_old_rec.pel_attribute2
214: ,p_pel_attribute3_o =>ben_pel_shd.g_old_rec.pel_attribute3
215: ,p_pel_attribute4_o =>ben_pel_shd.g_old_rec.pel_attribute4
208: ,p_pgm_id_o =>ben_pel_shd.g_old_rec.pgm_id
209: ,p_pl_id_o =>ben_pel_shd.g_old_rec.pl_id
210: ,p_business_group_id_o =>ben_pel_shd.g_old_rec.business_group_id
211: ,p_pel_attribute_category_o =>ben_pel_shd.g_old_rec.pel_attribute_category
212: ,p_pel_attribute1_o =>ben_pel_shd.g_old_rec.pel_attribute1
213: ,p_pel_attribute2_o =>ben_pel_shd.g_old_rec.pel_attribute2
214: ,p_pel_attribute3_o =>ben_pel_shd.g_old_rec.pel_attribute3
215: ,p_pel_attribute4_o =>ben_pel_shd.g_old_rec.pel_attribute4
216: ,p_pel_attribute5_o =>ben_pel_shd.g_old_rec.pel_attribute5
209: ,p_pl_id_o =>ben_pel_shd.g_old_rec.pl_id
210: ,p_business_group_id_o =>ben_pel_shd.g_old_rec.business_group_id
211: ,p_pel_attribute_category_o =>ben_pel_shd.g_old_rec.pel_attribute_category
212: ,p_pel_attribute1_o =>ben_pel_shd.g_old_rec.pel_attribute1
213: ,p_pel_attribute2_o =>ben_pel_shd.g_old_rec.pel_attribute2
214: ,p_pel_attribute3_o =>ben_pel_shd.g_old_rec.pel_attribute3
215: ,p_pel_attribute4_o =>ben_pel_shd.g_old_rec.pel_attribute4
216: ,p_pel_attribute5_o =>ben_pel_shd.g_old_rec.pel_attribute5
217: ,p_pel_attribute6_o =>ben_pel_shd.g_old_rec.pel_attribute6
210: ,p_business_group_id_o =>ben_pel_shd.g_old_rec.business_group_id
211: ,p_pel_attribute_category_o =>ben_pel_shd.g_old_rec.pel_attribute_category
212: ,p_pel_attribute1_o =>ben_pel_shd.g_old_rec.pel_attribute1
213: ,p_pel_attribute2_o =>ben_pel_shd.g_old_rec.pel_attribute2
214: ,p_pel_attribute3_o =>ben_pel_shd.g_old_rec.pel_attribute3
215: ,p_pel_attribute4_o =>ben_pel_shd.g_old_rec.pel_attribute4
216: ,p_pel_attribute5_o =>ben_pel_shd.g_old_rec.pel_attribute5
217: ,p_pel_attribute6_o =>ben_pel_shd.g_old_rec.pel_attribute6
218: ,p_pel_attribute7_o =>ben_pel_shd.g_old_rec.pel_attribute7
211: ,p_pel_attribute_category_o =>ben_pel_shd.g_old_rec.pel_attribute_category
212: ,p_pel_attribute1_o =>ben_pel_shd.g_old_rec.pel_attribute1
213: ,p_pel_attribute2_o =>ben_pel_shd.g_old_rec.pel_attribute2
214: ,p_pel_attribute3_o =>ben_pel_shd.g_old_rec.pel_attribute3
215: ,p_pel_attribute4_o =>ben_pel_shd.g_old_rec.pel_attribute4
216: ,p_pel_attribute5_o =>ben_pel_shd.g_old_rec.pel_attribute5
217: ,p_pel_attribute6_o =>ben_pel_shd.g_old_rec.pel_attribute6
218: ,p_pel_attribute7_o =>ben_pel_shd.g_old_rec.pel_attribute7
219: ,p_pel_attribute8_o =>ben_pel_shd.g_old_rec.pel_attribute8
212: ,p_pel_attribute1_o =>ben_pel_shd.g_old_rec.pel_attribute1
213: ,p_pel_attribute2_o =>ben_pel_shd.g_old_rec.pel_attribute2
214: ,p_pel_attribute3_o =>ben_pel_shd.g_old_rec.pel_attribute3
215: ,p_pel_attribute4_o =>ben_pel_shd.g_old_rec.pel_attribute4
216: ,p_pel_attribute5_o =>ben_pel_shd.g_old_rec.pel_attribute5
217: ,p_pel_attribute6_o =>ben_pel_shd.g_old_rec.pel_attribute6
218: ,p_pel_attribute7_o =>ben_pel_shd.g_old_rec.pel_attribute7
219: ,p_pel_attribute8_o =>ben_pel_shd.g_old_rec.pel_attribute8
220: ,p_pel_attribute9_o =>ben_pel_shd.g_old_rec.pel_attribute9
213: ,p_pel_attribute2_o =>ben_pel_shd.g_old_rec.pel_attribute2
214: ,p_pel_attribute3_o =>ben_pel_shd.g_old_rec.pel_attribute3
215: ,p_pel_attribute4_o =>ben_pel_shd.g_old_rec.pel_attribute4
216: ,p_pel_attribute5_o =>ben_pel_shd.g_old_rec.pel_attribute5
217: ,p_pel_attribute6_o =>ben_pel_shd.g_old_rec.pel_attribute6
218: ,p_pel_attribute7_o =>ben_pel_shd.g_old_rec.pel_attribute7
219: ,p_pel_attribute8_o =>ben_pel_shd.g_old_rec.pel_attribute8
220: ,p_pel_attribute9_o =>ben_pel_shd.g_old_rec.pel_attribute9
221: ,p_pel_attribute10_o =>ben_pel_shd.g_old_rec.pel_attribute10
214: ,p_pel_attribute3_o =>ben_pel_shd.g_old_rec.pel_attribute3
215: ,p_pel_attribute4_o =>ben_pel_shd.g_old_rec.pel_attribute4
216: ,p_pel_attribute5_o =>ben_pel_shd.g_old_rec.pel_attribute5
217: ,p_pel_attribute6_o =>ben_pel_shd.g_old_rec.pel_attribute6
218: ,p_pel_attribute7_o =>ben_pel_shd.g_old_rec.pel_attribute7
219: ,p_pel_attribute8_o =>ben_pel_shd.g_old_rec.pel_attribute8
220: ,p_pel_attribute9_o =>ben_pel_shd.g_old_rec.pel_attribute9
221: ,p_pel_attribute10_o =>ben_pel_shd.g_old_rec.pel_attribute10
222: ,p_pel_attribute11_o =>ben_pel_shd.g_old_rec.pel_attribute11
215: ,p_pel_attribute4_o =>ben_pel_shd.g_old_rec.pel_attribute4
216: ,p_pel_attribute5_o =>ben_pel_shd.g_old_rec.pel_attribute5
217: ,p_pel_attribute6_o =>ben_pel_shd.g_old_rec.pel_attribute6
218: ,p_pel_attribute7_o =>ben_pel_shd.g_old_rec.pel_attribute7
219: ,p_pel_attribute8_o =>ben_pel_shd.g_old_rec.pel_attribute8
220: ,p_pel_attribute9_o =>ben_pel_shd.g_old_rec.pel_attribute9
221: ,p_pel_attribute10_o =>ben_pel_shd.g_old_rec.pel_attribute10
222: ,p_pel_attribute11_o =>ben_pel_shd.g_old_rec.pel_attribute11
223: ,p_pel_attribute12_o =>ben_pel_shd.g_old_rec.pel_attribute12
216: ,p_pel_attribute5_o =>ben_pel_shd.g_old_rec.pel_attribute5
217: ,p_pel_attribute6_o =>ben_pel_shd.g_old_rec.pel_attribute6
218: ,p_pel_attribute7_o =>ben_pel_shd.g_old_rec.pel_attribute7
219: ,p_pel_attribute8_o =>ben_pel_shd.g_old_rec.pel_attribute8
220: ,p_pel_attribute9_o =>ben_pel_shd.g_old_rec.pel_attribute9
221: ,p_pel_attribute10_o =>ben_pel_shd.g_old_rec.pel_attribute10
222: ,p_pel_attribute11_o =>ben_pel_shd.g_old_rec.pel_attribute11
223: ,p_pel_attribute12_o =>ben_pel_shd.g_old_rec.pel_attribute12
224: ,p_pel_attribute13_o =>ben_pel_shd.g_old_rec.pel_attribute13
217: ,p_pel_attribute6_o =>ben_pel_shd.g_old_rec.pel_attribute6
218: ,p_pel_attribute7_o =>ben_pel_shd.g_old_rec.pel_attribute7
219: ,p_pel_attribute8_o =>ben_pel_shd.g_old_rec.pel_attribute8
220: ,p_pel_attribute9_o =>ben_pel_shd.g_old_rec.pel_attribute9
221: ,p_pel_attribute10_o =>ben_pel_shd.g_old_rec.pel_attribute10
222: ,p_pel_attribute11_o =>ben_pel_shd.g_old_rec.pel_attribute11
223: ,p_pel_attribute12_o =>ben_pel_shd.g_old_rec.pel_attribute12
224: ,p_pel_attribute13_o =>ben_pel_shd.g_old_rec.pel_attribute13
225: ,p_pel_attribute14_o =>ben_pel_shd.g_old_rec.pel_attribute14
218: ,p_pel_attribute7_o =>ben_pel_shd.g_old_rec.pel_attribute7
219: ,p_pel_attribute8_o =>ben_pel_shd.g_old_rec.pel_attribute8
220: ,p_pel_attribute9_o =>ben_pel_shd.g_old_rec.pel_attribute9
221: ,p_pel_attribute10_o =>ben_pel_shd.g_old_rec.pel_attribute10
222: ,p_pel_attribute11_o =>ben_pel_shd.g_old_rec.pel_attribute11
223: ,p_pel_attribute12_o =>ben_pel_shd.g_old_rec.pel_attribute12
224: ,p_pel_attribute13_o =>ben_pel_shd.g_old_rec.pel_attribute13
225: ,p_pel_attribute14_o =>ben_pel_shd.g_old_rec.pel_attribute14
226: ,p_pel_attribute15_o =>ben_pel_shd.g_old_rec.pel_attribute15
219: ,p_pel_attribute8_o =>ben_pel_shd.g_old_rec.pel_attribute8
220: ,p_pel_attribute9_o =>ben_pel_shd.g_old_rec.pel_attribute9
221: ,p_pel_attribute10_o =>ben_pel_shd.g_old_rec.pel_attribute10
222: ,p_pel_attribute11_o =>ben_pel_shd.g_old_rec.pel_attribute11
223: ,p_pel_attribute12_o =>ben_pel_shd.g_old_rec.pel_attribute12
224: ,p_pel_attribute13_o =>ben_pel_shd.g_old_rec.pel_attribute13
225: ,p_pel_attribute14_o =>ben_pel_shd.g_old_rec.pel_attribute14
226: ,p_pel_attribute15_o =>ben_pel_shd.g_old_rec.pel_attribute15
227: ,p_pel_attribute16_o =>ben_pel_shd.g_old_rec.pel_attribute16
220: ,p_pel_attribute9_o =>ben_pel_shd.g_old_rec.pel_attribute9
221: ,p_pel_attribute10_o =>ben_pel_shd.g_old_rec.pel_attribute10
222: ,p_pel_attribute11_o =>ben_pel_shd.g_old_rec.pel_attribute11
223: ,p_pel_attribute12_o =>ben_pel_shd.g_old_rec.pel_attribute12
224: ,p_pel_attribute13_o =>ben_pel_shd.g_old_rec.pel_attribute13
225: ,p_pel_attribute14_o =>ben_pel_shd.g_old_rec.pel_attribute14
226: ,p_pel_attribute15_o =>ben_pel_shd.g_old_rec.pel_attribute15
227: ,p_pel_attribute16_o =>ben_pel_shd.g_old_rec.pel_attribute16
228: ,p_pel_attribute17_o =>ben_pel_shd.g_old_rec.pel_attribute17
221: ,p_pel_attribute10_o =>ben_pel_shd.g_old_rec.pel_attribute10
222: ,p_pel_attribute11_o =>ben_pel_shd.g_old_rec.pel_attribute11
223: ,p_pel_attribute12_o =>ben_pel_shd.g_old_rec.pel_attribute12
224: ,p_pel_attribute13_o =>ben_pel_shd.g_old_rec.pel_attribute13
225: ,p_pel_attribute14_o =>ben_pel_shd.g_old_rec.pel_attribute14
226: ,p_pel_attribute15_o =>ben_pel_shd.g_old_rec.pel_attribute15
227: ,p_pel_attribute16_o =>ben_pel_shd.g_old_rec.pel_attribute16
228: ,p_pel_attribute17_o =>ben_pel_shd.g_old_rec.pel_attribute17
229: ,p_pel_attribute18_o =>ben_pel_shd.g_old_rec.pel_attribute18
222: ,p_pel_attribute11_o =>ben_pel_shd.g_old_rec.pel_attribute11
223: ,p_pel_attribute12_o =>ben_pel_shd.g_old_rec.pel_attribute12
224: ,p_pel_attribute13_o =>ben_pel_shd.g_old_rec.pel_attribute13
225: ,p_pel_attribute14_o =>ben_pel_shd.g_old_rec.pel_attribute14
226: ,p_pel_attribute15_o =>ben_pel_shd.g_old_rec.pel_attribute15
227: ,p_pel_attribute16_o =>ben_pel_shd.g_old_rec.pel_attribute16
228: ,p_pel_attribute17_o =>ben_pel_shd.g_old_rec.pel_attribute17
229: ,p_pel_attribute18_o =>ben_pel_shd.g_old_rec.pel_attribute18
230: ,p_pel_attribute19_o =>ben_pel_shd.g_old_rec.pel_attribute19
223: ,p_pel_attribute12_o =>ben_pel_shd.g_old_rec.pel_attribute12
224: ,p_pel_attribute13_o =>ben_pel_shd.g_old_rec.pel_attribute13
225: ,p_pel_attribute14_o =>ben_pel_shd.g_old_rec.pel_attribute14
226: ,p_pel_attribute15_o =>ben_pel_shd.g_old_rec.pel_attribute15
227: ,p_pel_attribute16_o =>ben_pel_shd.g_old_rec.pel_attribute16
228: ,p_pel_attribute17_o =>ben_pel_shd.g_old_rec.pel_attribute17
229: ,p_pel_attribute18_o =>ben_pel_shd.g_old_rec.pel_attribute18
230: ,p_pel_attribute19_o =>ben_pel_shd.g_old_rec.pel_attribute19
231: ,p_pel_attribute20_o =>ben_pel_shd.g_old_rec.pel_attribute20
224: ,p_pel_attribute13_o =>ben_pel_shd.g_old_rec.pel_attribute13
225: ,p_pel_attribute14_o =>ben_pel_shd.g_old_rec.pel_attribute14
226: ,p_pel_attribute15_o =>ben_pel_shd.g_old_rec.pel_attribute15
227: ,p_pel_attribute16_o =>ben_pel_shd.g_old_rec.pel_attribute16
228: ,p_pel_attribute17_o =>ben_pel_shd.g_old_rec.pel_attribute17
229: ,p_pel_attribute18_o =>ben_pel_shd.g_old_rec.pel_attribute18
230: ,p_pel_attribute19_o =>ben_pel_shd.g_old_rec.pel_attribute19
231: ,p_pel_attribute20_o =>ben_pel_shd.g_old_rec.pel_attribute20
232: ,p_pel_attribute21_o =>ben_pel_shd.g_old_rec.pel_attribute21
225: ,p_pel_attribute14_o =>ben_pel_shd.g_old_rec.pel_attribute14
226: ,p_pel_attribute15_o =>ben_pel_shd.g_old_rec.pel_attribute15
227: ,p_pel_attribute16_o =>ben_pel_shd.g_old_rec.pel_attribute16
228: ,p_pel_attribute17_o =>ben_pel_shd.g_old_rec.pel_attribute17
229: ,p_pel_attribute18_o =>ben_pel_shd.g_old_rec.pel_attribute18
230: ,p_pel_attribute19_o =>ben_pel_shd.g_old_rec.pel_attribute19
231: ,p_pel_attribute20_o =>ben_pel_shd.g_old_rec.pel_attribute20
232: ,p_pel_attribute21_o =>ben_pel_shd.g_old_rec.pel_attribute21
233: ,p_pel_attribute22_o =>ben_pel_shd.g_old_rec.pel_attribute22
226: ,p_pel_attribute15_o =>ben_pel_shd.g_old_rec.pel_attribute15
227: ,p_pel_attribute16_o =>ben_pel_shd.g_old_rec.pel_attribute16
228: ,p_pel_attribute17_o =>ben_pel_shd.g_old_rec.pel_attribute17
229: ,p_pel_attribute18_o =>ben_pel_shd.g_old_rec.pel_attribute18
230: ,p_pel_attribute19_o =>ben_pel_shd.g_old_rec.pel_attribute19
231: ,p_pel_attribute20_o =>ben_pel_shd.g_old_rec.pel_attribute20
232: ,p_pel_attribute21_o =>ben_pel_shd.g_old_rec.pel_attribute21
233: ,p_pel_attribute22_o =>ben_pel_shd.g_old_rec.pel_attribute22
234: ,p_pel_attribute23_o =>ben_pel_shd.g_old_rec.pel_attribute23
227: ,p_pel_attribute16_o =>ben_pel_shd.g_old_rec.pel_attribute16
228: ,p_pel_attribute17_o =>ben_pel_shd.g_old_rec.pel_attribute17
229: ,p_pel_attribute18_o =>ben_pel_shd.g_old_rec.pel_attribute18
230: ,p_pel_attribute19_o =>ben_pel_shd.g_old_rec.pel_attribute19
231: ,p_pel_attribute20_o =>ben_pel_shd.g_old_rec.pel_attribute20
232: ,p_pel_attribute21_o =>ben_pel_shd.g_old_rec.pel_attribute21
233: ,p_pel_attribute22_o =>ben_pel_shd.g_old_rec.pel_attribute22
234: ,p_pel_attribute23_o =>ben_pel_shd.g_old_rec.pel_attribute23
235: ,p_pel_attribute24_o =>ben_pel_shd.g_old_rec.pel_attribute24
228: ,p_pel_attribute17_o =>ben_pel_shd.g_old_rec.pel_attribute17
229: ,p_pel_attribute18_o =>ben_pel_shd.g_old_rec.pel_attribute18
230: ,p_pel_attribute19_o =>ben_pel_shd.g_old_rec.pel_attribute19
231: ,p_pel_attribute20_o =>ben_pel_shd.g_old_rec.pel_attribute20
232: ,p_pel_attribute21_o =>ben_pel_shd.g_old_rec.pel_attribute21
233: ,p_pel_attribute22_o =>ben_pel_shd.g_old_rec.pel_attribute22
234: ,p_pel_attribute23_o =>ben_pel_shd.g_old_rec.pel_attribute23
235: ,p_pel_attribute24_o =>ben_pel_shd.g_old_rec.pel_attribute24
236: ,p_pel_attribute25_o =>ben_pel_shd.g_old_rec.pel_attribute25
229: ,p_pel_attribute18_o =>ben_pel_shd.g_old_rec.pel_attribute18
230: ,p_pel_attribute19_o =>ben_pel_shd.g_old_rec.pel_attribute19
231: ,p_pel_attribute20_o =>ben_pel_shd.g_old_rec.pel_attribute20
232: ,p_pel_attribute21_o =>ben_pel_shd.g_old_rec.pel_attribute21
233: ,p_pel_attribute22_o =>ben_pel_shd.g_old_rec.pel_attribute22
234: ,p_pel_attribute23_o =>ben_pel_shd.g_old_rec.pel_attribute23
235: ,p_pel_attribute24_o =>ben_pel_shd.g_old_rec.pel_attribute24
236: ,p_pel_attribute25_o =>ben_pel_shd.g_old_rec.pel_attribute25
237: ,p_pel_attribute26_o =>ben_pel_shd.g_old_rec.pel_attribute26
230: ,p_pel_attribute19_o =>ben_pel_shd.g_old_rec.pel_attribute19
231: ,p_pel_attribute20_o =>ben_pel_shd.g_old_rec.pel_attribute20
232: ,p_pel_attribute21_o =>ben_pel_shd.g_old_rec.pel_attribute21
233: ,p_pel_attribute22_o =>ben_pel_shd.g_old_rec.pel_attribute22
234: ,p_pel_attribute23_o =>ben_pel_shd.g_old_rec.pel_attribute23
235: ,p_pel_attribute24_o =>ben_pel_shd.g_old_rec.pel_attribute24
236: ,p_pel_attribute25_o =>ben_pel_shd.g_old_rec.pel_attribute25
237: ,p_pel_attribute26_o =>ben_pel_shd.g_old_rec.pel_attribute26
238: ,p_pel_attribute27_o =>ben_pel_shd.g_old_rec.pel_attribute27
231: ,p_pel_attribute20_o =>ben_pel_shd.g_old_rec.pel_attribute20
232: ,p_pel_attribute21_o =>ben_pel_shd.g_old_rec.pel_attribute21
233: ,p_pel_attribute22_o =>ben_pel_shd.g_old_rec.pel_attribute22
234: ,p_pel_attribute23_o =>ben_pel_shd.g_old_rec.pel_attribute23
235: ,p_pel_attribute24_o =>ben_pel_shd.g_old_rec.pel_attribute24
236: ,p_pel_attribute25_o =>ben_pel_shd.g_old_rec.pel_attribute25
237: ,p_pel_attribute26_o =>ben_pel_shd.g_old_rec.pel_attribute26
238: ,p_pel_attribute27_o =>ben_pel_shd.g_old_rec.pel_attribute27
239: ,p_pel_attribute28_o =>ben_pel_shd.g_old_rec.pel_attribute28
232: ,p_pel_attribute21_o =>ben_pel_shd.g_old_rec.pel_attribute21
233: ,p_pel_attribute22_o =>ben_pel_shd.g_old_rec.pel_attribute22
234: ,p_pel_attribute23_o =>ben_pel_shd.g_old_rec.pel_attribute23
235: ,p_pel_attribute24_o =>ben_pel_shd.g_old_rec.pel_attribute24
236: ,p_pel_attribute25_o =>ben_pel_shd.g_old_rec.pel_attribute25
237: ,p_pel_attribute26_o =>ben_pel_shd.g_old_rec.pel_attribute26
238: ,p_pel_attribute27_o =>ben_pel_shd.g_old_rec.pel_attribute27
239: ,p_pel_attribute28_o =>ben_pel_shd.g_old_rec.pel_attribute28
240: ,p_pel_attribute29_o =>ben_pel_shd.g_old_rec.pel_attribute29
233: ,p_pel_attribute22_o =>ben_pel_shd.g_old_rec.pel_attribute22
234: ,p_pel_attribute23_o =>ben_pel_shd.g_old_rec.pel_attribute23
235: ,p_pel_attribute24_o =>ben_pel_shd.g_old_rec.pel_attribute24
236: ,p_pel_attribute25_o =>ben_pel_shd.g_old_rec.pel_attribute25
237: ,p_pel_attribute26_o =>ben_pel_shd.g_old_rec.pel_attribute26
238: ,p_pel_attribute27_o =>ben_pel_shd.g_old_rec.pel_attribute27
239: ,p_pel_attribute28_o =>ben_pel_shd.g_old_rec.pel_attribute28
240: ,p_pel_attribute29_o =>ben_pel_shd.g_old_rec.pel_attribute29
241: ,p_pel_attribute30_o =>ben_pel_shd.g_old_rec.pel_attribute30
234: ,p_pel_attribute23_o =>ben_pel_shd.g_old_rec.pel_attribute23
235: ,p_pel_attribute24_o =>ben_pel_shd.g_old_rec.pel_attribute24
236: ,p_pel_attribute25_o =>ben_pel_shd.g_old_rec.pel_attribute25
237: ,p_pel_attribute26_o =>ben_pel_shd.g_old_rec.pel_attribute26
238: ,p_pel_attribute27_o =>ben_pel_shd.g_old_rec.pel_attribute27
239: ,p_pel_attribute28_o =>ben_pel_shd.g_old_rec.pel_attribute28
240: ,p_pel_attribute29_o =>ben_pel_shd.g_old_rec.pel_attribute29
241: ,p_pel_attribute30_o =>ben_pel_shd.g_old_rec.pel_attribute30
242: ,p_request_id_o =>ben_pel_shd.g_old_rec.request_id
235: ,p_pel_attribute24_o =>ben_pel_shd.g_old_rec.pel_attribute24
236: ,p_pel_attribute25_o =>ben_pel_shd.g_old_rec.pel_attribute25
237: ,p_pel_attribute26_o =>ben_pel_shd.g_old_rec.pel_attribute26
238: ,p_pel_attribute27_o =>ben_pel_shd.g_old_rec.pel_attribute27
239: ,p_pel_attribute28_o =>ben_pel_shd.g_old_rec.pel_attribute28
240: ,p_pel_attribute29_o =>ben_pel_shd.g_old_rec.pel_attribute29
241: ,p_pel_attribute30_o =>ben_pel_shd.g_old_rec.pel_attribute30
242: ,p_request_id_o =>ben_pel_shd.g_old_rec.request_id
243: ,p_program_application_id_o =>ben_pel_shd.g_old_rec.program_application_id
236: ,p_pel_attribute25_o =>ben_pel_shd.g_old_rec.pel_attribute25
237: ,p_pel_attribute26_o =>ben_pel_shd.g_old_rec.pel_attribute26
238: ,p_pel_attribute27_o =>ben_pel_shd.g_old_rec.pel_attribute27
239: ,p_pel_attribute28_o =>ben_pel_shd.g_old_rec.pel_attribute28
240: ,p_pel_attribute29_o =>ben_pel_shd.g_old_rec.pel_attribute29
241: ,p_pel_attribute30_o =>ben_pel_shd.g_old_rec.pel_attribute30
242: ,p_request_id_o =>ben_pel_shd.g_old_rec.request_id
243: ,p_program_application_id_o =>ben_pel_shd.g_old_rec.program_application_id
244: ,p_program_id_o =>ben_pel_shd.g_old_rec.program_id
237: ,p_pel_attribute26_o =>ben_pel_shd.g_old_rec.pel_attribute26
238: ,p_pel_attribute27_o =>ben_pel_shd.g_old_rec.pel_attribute27
239: ,p_pel_attribute28_o =>ben_pel_shd.g_old_rec.pel_attribute28
240: ,p_pel_attribute29_o =>ben_pel_shd.g_old_rec.pel_attribute29
241: ,p_pel_attribute30_o =>ben_pel_shd.g_old_rec.pel_attribute30
242: ,p_request_id_o =>ben_pel_shd.g_old_rec.request_id
243: ,p_program_application_id_o =>ben_pel_shd.g_old_rec.program_application_id
244: ,p_program_id_o =>ben_pel_shd.g_old_rec.program_id
245: ,p_program_update_date_o =>ben_pel_shd.g_old_rec.program_update_date
238: ,p_pel_attribute27_o =>ben_pel_shd.g_old_rec.pel_attribute27
239: ,p_pel_attribute28_o =>ben_pel_shd.g_old_rec.pel_attribute28
240: ,p_pel_attribute29_o =>ben_pel_shd.g_old_rec.pel_attribute29
241: ,p_pel_attribute30_o =>ben_pel_shd.g_old_rec.pel_attribute30
242: ,p_request_id_o =>ben_pel_shd.g_old_rec.request_id
243: ,p_program_application_id_o =>ben_pel_shd.g_old_rec.program_application_id
244: ,p_program_id_o =>ben_pel_shd.g_old_rec.program_id
245: ,p_program_update_date_o =>ben_pel_shd.g_old_rec.program_update_date
246: ,p_object_version_number_o =>ben_pel_shd.g_old_rec.object_version_number
239: ,p_pel_attribute28_o =>ben_pel_shd.g_old_rec.pel_attribute28
240: ,p_pel_attribute29_o =>ben_pel_shd.g_old_rec.pel_attribute29
241: ,p_pel_attribute30_o =>ben_pel_shd.g_old_rec.pel_attribute30
242: ,p_request_id_o =>ben_pel_shd.g_old_rec.request_id
243: ,p_program_application_id_o =>ben_pel_shd.g_old_rec.program_application_id
244: ,p_program_id_o =>ben_pel_shd.g_old_rec.program_id
245: ,p_program_update_date_o =>ben_pel_shd.g_old_rec.program_update_date
246: ,p_object_version_number_o =>ben_pel_shd.g_old_rec.object_version_number
247: ,p_defer_deenrol_flag_o =>ben_pel_shd.g_old_rec.defer_deenrol_flag
240: ,p_pel_attribute29_o =>ben_pel_shd.g_old_rec.pel_attribute29
241: ,p_pel_attribute30_o =>ben_pel_shd.g_old_rec.pel_attribute30
242: ,p_request_id_o =>ben_pel_shd.g_old_rec.request_id
243: ,p_program_application_id_o =>ben_pel_shd.g_old_rec.program_application_id
244: ,p_program_id_o =>ben_pel_shd.g_old_rec.program_id
245: ,p_program_update_date_o =>ben_pel_shd.g_old_rec.program_update_date
246: ,p_object_version_number_o =>ben_pel_shd.g_old_rec.object_version_number
247: ,p_defer_deenrol_flag_o =>ben_pel_shd.g_old_rec.defer_deenrol_flag
248: ,p_deenrol_made_dt_o =>ben_pel_shd.g_old_rec.deenrol_made_dt
241: ,p_pel_attribute30_o =>ben_pel_shd.g_old_rec.pel_attribute30
242: ,p_request_id_o =>ben_pel_shd.g_old_rec.request_id
243: ,p_program_application_id_o =>ben_pel_shd.g_old_rec.program_application_id
244: ,p_program_id_o =>ben_pel_shd.g_old_rec.program_id
245: ,p_program_update_date_o =>ben_pel_shd.g_old_rec.program_update_date
246: ,p_object_version_number_o =>ben_pel_shd.g_old_rec.object_version_number
247: ,p_defer_deenrol_flag_o =>ben_pel_shd.g_old_rec.defer_deenrol_flag
248: ,p_deenrol_made_dt_o =>ben_pel_shd.g_old_rec.deenrol_made_dt
249: );
242: ,p_request_id_o =>ben_pel_shd.g_old_rec.request_id
243: ,p_program_application_id_o =>ben_pel_shd.g_old_rec.program_application_id
244: ,p_program_id_o =>ben_pel_shd.g_old_rec.program_id
245: ,p_program_update_date_o =>ben_pel_shd.g_old_rec.program_update_date
246: ,p_object_version_number_o =>ben_pel_shd.g_old_rec.object_version_number
247: ,p_defer_deenrol_flag_o =>ben_pel_shd.g_old_rec.defer_deenrol_flag
248: ,p_deenrol_made_dt_o =>ben_pel_shd.g_old_rec.deenrol_made_dt
249: );
250: --
243: ,p_program_application_id_o =>ben_pel_shd.g_old_rec.program_application_id
244: ,p_program_id_o =>ben_pel_shd.g_old_rec.program_id
245: ,p_program_update_date_o =>ben_pel_shd.g_old_rec.program_update_date
246: ,p_object_version_number_o =>ben_pel_shd.g_old_rec.object_version_number
247: ,p_defer_deenrol_flag_o =>ben_pel_shd.g_old_rec.defer_deenrol_flag
248: ,p_deenrol_made_dt_o =>ben_pel_shd.g_old_rec.deenrol_made_dt
249: );
250: --
251: exception
244: ,p_program_id_o =>ben_pel_shd.g_old_rec.program_id
245: ,p_program_update_date_o =>ben_pel_shd.g_old_rec.program_update_date
246: ,p_object_version_number_o =>ben_pel_shd.g_old_rec.object_version_number
247: ,p_defer_deenrol_flag_o =>ben_pel_shd.g_old_rec.defer_deenrol_flag
248: ,p_deenrol_made_dt_o =>ben_pel_shd.g_old_rec.deenrol_made_dt
249: );
250: --
251: exception
252: --
269: -- ----------------------------------------------------------------------------
270: Procedure del
271: (
272: p_effective_date in date,
273: p_rec in ben_pel_shd.g_rec_type
274: ) is
275: --
276: l_proc varchar2(72) := g_package||'del';
277: --
279: hr_utility.set_location('Entering:'||l_proc, 5);
280: --
281: -- We must lock the row which we need to delete.
282: --
283: ben_pel_shd.lck
284: (
285: p_rec.pil_elctbl_chc_popl_id,
286: p_rec.object_version_number
287: );
314: p_pil_elctbl_chc_popl_id in number,
315: p_object_version_number in number
316: ) is
317: --
318: l_rec ben_pel_shd.g_rec_type;
319: l_proc varchar2(72) := g_package||'del';
320: --
321: Begin
322: hr_utility.set_location('Entering:'||l_proc, 5);