47: -- Internal Row Handler Use Only.
48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml(p_rec in ben_bft_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_bft_shd.g_api_dml := true; -- Set the api dml status
59: --
60: -- Delete the ben_benefit_actions row.
61: --
62: delete from ben_benefit_actions
61: --
62: delete from ben_benefit_actions
63: where benefit_action_id = p_rec.benefit_action_id;
64: --
65: ben_bft_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_bft_shd.g_api_dml := false; -- Unset the api dml status
73: ben_bft_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_bft_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_bft_shd.g_api_dml := false; -- Unset the api dml status
73: ben_bft_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_bft_shd.g_api_dml := false; -- Unset the api dml status
77: Raise;
72: ben_bft_shd.g_api_dml := false; -- Unset the api dml status
73: ben_bft_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ben_bft_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_bft_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(p_effective_date in date,
155: p_rec in ben_bft_shd.g_rec_type) is
156: --
157: l_proc varchar2(72) := g_package||'post_delete';
158: --
159: Begin
166: --
167: ben_bft_rkd.after_delete
168: (
169: p_benefit_action_id =>p_rec.benefit_action_id
170: ,p_process_date_o =>ben_bft_shd.g_old_rec.process_date
171: ,p_uneai_effective_date_o =>ben_bft_shd.g_old_rec.uneai_effective_date
172: ,p_mode_cd_o =>ben_bft_shd.g_old_rec.mode_cd
173: ,p_derivable_factors_flag_o =>ben_bft_shd.g_old_rec.derivable_factors_flag
174: ,p_close_uneai_flag_o =>ben_bft_shd.g_old_rec.close_uneai_flag
167: ben_bft_rkd.after_delete
168: (
169: p_benefit_action_id =>p_rec.benefit_action_id
170: ,p_process_date_o =>ben_bft_shd.g_old_rec.process_date
171: ,p_uneai_effective_date_o =>ben_bft_shd.g_old_rec.uneai_effective_date
172: ,p_mode_cd_o =>ben_bft_shd.g_old_rec.mode_cd
173: ,p_derivable_factors_flag_o =>ben_bft_shd.g_old_rec.derivable_factors_flag
174: ,p_close_uneai_flag_o =>ben_bft_shd.g_old_rec.close_uneai_flag
175: ,p_validate_flag_o =>ben_bft_shd.g_old_rec.validate_flag
168: (
169: p_benefit_action_id =>p_rec.benefit_action_id
170: ,p_process_date_o =>ben_bft_shd.g_old_rec.process_date
171: ,p_uneai_effective_date_o =>ben_bft_shd.g_old_rec.uneai_effective_date
172: ,p_mode_cd_o =>ben_bft_shd.g_old_rec.mode_cd
173: ,p_derivable_factors_flag_o =>ben_bft_shd.g_old_rec.derivable_factors_flag
174: ,p_close_uneai_flag_o =>ben_bft_shd.g_old_rec.close_uneai_flag
175: ,p_validate_flag_o =>ben_bft_shd.g_old_rec.validate_flag
176: ,p_person_id_o =>ben_bft_shd.g_old_rec.person_id
169: p_benefit_action_id =>p_rec.benefit_action_id
170: ,p_process_date_o =>ben_bft_shd.g_old_rec.process_date
171: ,p_uneai_effective_date_o =>ben_bft_shd.g_old_rec.uneai_effective_date
172: ,p_mode_cd_o =>ben_bft_shd.g_old_rec.mode_cd
173: ,p_derivable_factors_flag_o =>ben_bft_shd.g_old_rec.derivable_factors_flag
174: ,p_close_uneai_flag_o =>ben_bft_shd.g_old_rec.close_uneai_flag
175: ,p_validate_flag_o =>ben_bft_shd.g_old_rec.validate_flag
176: ,p_person_id_o =>ben_bft_shd.g_old_rec.person_id
177: ,p_person_type_id_o =>ben_bft_shd.g_old_rec.person_type_id
170: ,p_process_date_o =>ben_bft_shd.g_old_rec.process_date
171: ,p_uneai_effective_date_o =>ben_bft_shd.g_old_rec.uneai_effective_date
172: ,p_mode_cd_o =>ben_bft_shd.g_old_rec.mode_cd
173: ,p_derivable_factors_flag_o =>ben_bft_shd.g_old_rec.derivable_factors_flag
174: ,p_close_uneai_flag_o =>ben_bft_shd.g_old_rec.close_uneai_flag
175: ,p_validate_flag_o =>ben_bft_shd.g_old_rec.validate_flag
176: ,p_person_id_o =>ben_bft_shd.g_old_rec.person_id
177: ,p_person_type_id_o =>ben_bft_shd.g_old_rec.person_type_id
178: ,p_pgm_id_o =>ben_bft_shd.g_old_rec.pgm_id
171: ,p_uneai_effective_date_o =>ben_bft_shd.g_old_rec.uneai_effective_date
172: ,p_mode_cd_o =>ben_bft_shd.g_old_rec.mode_cd
173: ,p_derivable_factors_flag_o =>ben_bft_shd.g_old_rec.derivable_factors_flag
174: ,p_close_uneai_flag_o =>ben_bft_shd.g_old_rec.close_uneai_flag
175: ,p_validate_flag_o =>ben_bft_shd.g_old_rec.validate_flag
176: ,p_person_id_o =>ben_bft_shd.g_old_rec.person_id
177: ,p_person_type_id_o =>ben_bft_shd.g_old_rec.person_type_id
178: ,p_pgm_id_o =>ben_bft_shd.g_old_rec.pgm_id
179: ,p_business_group_id_o =>ben_bft_shd.g_old_rec.business_group_id
172: ,p_mode_cd_o =>ben_bft_shd.g_old_rec.mode_cd
173: ,p_derivable_factors_flag_o =>ben_bft_shd.g_old_rec.derivable_factors_flag
174: ,p_close_uneai_flag_o =>ben_bft_shd.g_old_rec.close_uneai_flag
175: ,p_validate_flag_o =>ben_bft_shd.g_old_rec.validate_flag
176: ,p_person_id_o =>ben_bft_shd.g_old_rec.person_id
177: ,p_person_type_id_o =>ben_bft_shd.g_old_rec.person_type_id
178: ,p_pgm_id_o =>ben_bft_shd.g_old_rec.pgm_id
179: ,p_business_group_id_o =>ben_bft_shd.g_old_rec.business_group_id
180: ,p_pl_id_o =>ben_bft_shd.g_old_rec.pl_id
173: ,p_derivable_factors_flag_o =>ben_bft_shd.g_old_rec.derivable_factors_flag
174: ,p_close_uneai_flag_o =>ben_bft_shd.g_old_rec.close_uneai_flag
175: ,p_validate_flag_o =>ben_bft_shd.g_old_rec.validate_flag
176: ,p_person_id_o =>ben_bft_shd.g_old_rec.person_id
177: ,p_person_type_id_o =>ben_bft_shd.g_old_rec.person_type_id
178: ,p_pgm_id_o =>ben_bft_shd.g_old_rec.pgm_id
179: ,p_business_group_id_o =>ben_bft_shd.g_old_rec.business_group_id
180: ,p_pl_id_o =>ben_bft_shd.g_old_rec.pl_id
181: ,p_popl_enrt_typ_cycl_id_o =>ben_bft_shd.g_old_rec.popl_enrt_typ_cycl_id
174: ,p_close_uneai_flag_o =>ben_bft_shd.g_old_rec.close_uneai_flag
175: ,p_validate_flag_o =>ben_bft_shd.g_old_rec.validate_flag
176: ,p_person_id_o =>ben_bft_shd.g_old_rec.person_id
177: ,p_person_type_id_o =>ben_bft_shd.g_old_rec.person_type_id
178: ,p_pgm_id_o =>ben_bft_shd.g_old_rec.pgm_id
179: ,p_business_group_id_o =>ben_bft_shd.g_old_rec.business_group_id
180: ,p_pl_id_o =>ben_bft_shd.g_old_rec.pl_id
181: ,p_popl_enrt_typ_cycl_id_o =>ben_bft_shd.g_old_rec.popl_enrt_typ_cycl_id
182: ,p_no_programs_flag_o =>ben_bft_shd.g_old_rec.no_programs_flag
175: ,p_validate_flag_o =>ben_bft_shd.g_old_rec.validate_flag
176: ,p_person_id_o =>ben_bft_shd.g_old_rec.person_id
177: ,p_person_type_id_o =>ben_bft_shd.g_old_rec.person_type_id
178: ,p_pgm_id_o =>ben_bft_shd.g_old_rec.pgm_id
179: ,p_business_group_id_o =>ben_bft_shd.g_old_rec.business_group_id
180: ,p_pl_id_o =>ben_bft_shd.g_old_rec.pl_id
181: ,p_popl_enrt_typ_cycl_id_o =>ben_bft_shd.g_old_rec.popl_enrt_typ_cycl_id
182: ,p_no_programs_flag_o =>ben_bft_shd.g_old_rec.no_programs_flag
183: ,p_no_plans_flag_o =>ben_bft_shd.g_old_rec.no_plans_flag
176: ,p_person_id_o =>ben_bft_shd.g_old_rec.person_id
177: ,p_person_type_id_o =>ben_bft_shd.g_old_rec.person_type_id
178: ,p_pgm_id_o =>ben_bft_shd.g_old_rec.pgm_id
179: ,p_business_group_id_o =>ben_bft_shd.g_old_rec.business_group_id
180: ,p_pl_id_o =>ben_bft_shd.g_old_rec.pl_id
181: ,p_popl_enrt_typ_cycl_id_o =>ben_bft_shd.g_old_rec.popl_enrt_typ_cycl_id
182: ,p_no_programs_flag_o =>ben_bft_shd.g_old_rec.no_programs_flag
183: ,p_no_plans_flag_o =>ben_bft_shd.g_old_rec.no_plans_flag
184: ,p_comp_selection_rl_o =>ben_bft_shd.g_old_rec.comp_selection_rl
177: ,p_person_type_id_o =>ben_bft_shd.g_old_rec.person_type_id
178: ,p_pgm_id_o =>ben_bft_shd.g_old_rec.pgm_id
179: ,p_business_group_id_o =>ben_bft_shd.g_old_rec.business_group_id
180: ,p_pl_id_o =>ben_bft_shd.g_old_rec.pl_id
181: ,p_popl_enrt_typ_cycl_id_o =>ben_bft_shd.g_old_rec.popl_enrt_typ_cycl_id
182: ,p_no_programs_flag_o =>ben_bft_shd.g_old_rec.no_programs_flag
183: ,p_no_plans_flag_o =>ben_bft_shd.g_old_rec.no_plans_flag
184: ,p_comp_selection_rl_o =>ben_bft_shd.g_old_rec.comp_selection_rl
185: ,p_person_selection_rl_o =>ben_bft_shd.g_old_rec.person_selection_rl
178: ,p_pgm_id_o =>ben_bft_shd.g_old_rec.pgm_id
179: ,p_business_group_id_o =>ben_bft_shd.g_old_rec.business_group_id
180: ,p_pl_id_o =>ben_bft_shd.g_old_rec.pl_id
181: ,p_popl_enrt_typ_cycl_id_o =>ben_bft_shd.g_old_rec.popl_enrt_typ_cycl_id
182: ,p_no_programs_flag_o =>ben_bft_shd.g_old_rec.no_programs_flag
183: ,p_no_plans_flag_o =>ben_bft_shd.g_old_rec.no_plans_flag
184: ,p_comp_selection_rl_o =>ben_bft_shd.g_old_rec.comp_selection_rl
185: ,p_person_selection_rl_o =>ben_bft_shd.g_old_rec.person_selection_rl
186: ,p_ler_id_o =>ben_bft_shd.g_old_rec.ler_id
179: ,p_business_group_id_o =>ben_bft_shd.g_old_rec.business_group_id
180: ,p_pl_id_o =>ben_bft_shd.g_old_rec.pl_id
181: ,p_popl_enrt_typ_cycl_id_o =>ben_bft_shd.g_old_rec.popl_enrt_typ_cycl_id
182: ,p_no_programs_flag_o =>ben_bft_shd.g_old_rec.no_programs_flag
183: ,p_no_plans_flag_o =>ben_bft_shd.g_old_rec.no_plans_flag
184: ,p_comp_selection_rl_o =>ben_bft_shd.g_old_rec.comp_selection_rl
185: ,p_person_selection_rl_o =>ben_bft_shd.g_old_rec.person_selection_rl
186: ,p_ler_id_o =>ben_bft_shd.g_old_rec.ler_id
187: ,p_organization_id_o =>ben_bft_shd.g_old_rec.organization_id
180: ,p_pl_id_o =>ben_bft_shd.g_old_rec.pl_id
181: ,p_popl_enrt_typ_cycl_id_o =>ben_bft_shd.g_old_rec.popl_enrt_typ_cycl_id
182: ,p_no_programs_flag_o =>ben_bft_shd.g_old_rec.no_programs_flag
183: ,p_no_plans_flag_o =>ben_bft_shd.g_old_rec.no_plans_flag
184: ,p_comp_selection_rl_o =>ben_bft_shd.g_old_rec.comp_selection_rl
185: ,p_person_selection_rl_o =>ben_bft_shd.g_old_rec.person_selection_rl
186: ,p_ler_id_o =>ben_bft_shd.g_old_rec.ler_id
187: ,p_organization_id_o =>ben_bft_shd.g_old_rec.organization_id
188: ,p_benfts_grp_id_o =>ben_bft_shd.g_old_rec.benfts_grp_id
181: ,p_popl_enrt_typ_cycl_id_o =>ben_bft_shd.g_old_rec.popl_enrt_typ_cycl_id
182: ,p_no_programs_flag_o =>ben_bft_shd.g_old_rec.no_programs_flag
183: ,p_no_plans_flag_o =>ben_bft_shd.g_old_rec.no_plans_flag
184: ,p_comp_selection_rl_o =>ben_bft_shd.g_old_rec.comp_selection_rl
185: ,p_person_selection_rl_o =>ben_bft_shd.g_old_rec.person_selection_rl
186: ,p_ler_id_o =>ben_bft_shd.g_old_rec.ler_id
187: ,p_organization_id_o =>ben_bft_shd.g_old_rec.organization_id
188: ,p_benfts_grp_id_o =>ben_bft_shd.g_old_rec.benfts_grp_id
189: ,p_location_id_o =>ben_bft_shd.g_old_rec.location_id
182: ,p_no_programs_flag_o =>ben_bft_shd.g_old_rec.no_programs_flag
183: ,p_no_plans_flag_o =>ben_bft_shd.g_old_rec.no_plans_flag
184: ,p_comp_selection_rl_o =>ben_bft_shd.g_old_rec.comp_selection_rl
185: ,p_person_selection_rl_o =>ben_bft_shd.g_old_rec.person_selection_rl
186: ,p_ler_id_o =>ben_bft_shd.g_old_rec.ler_id
187: ,p_organization_id_o =>ben_bft_shd.g_old_rec.organization_id
188: ,p_benfts_grp_id_o =>ben_bft_shd.g_old_rec.benfts_grp_id
189: ,p_location_id_o =>ben_bft_shd.g_old_rec.location_id
190: ,p_pstl_zip_rng_id_o =>ben_bft_shd.g_old_rec.pstl_zip_rng_id
183: ,p_no_plans_flag_o =>ben_bft_shd.g_old_rec.no_plans_flag
184: ,p_comp_selection_rl_o =>ben_bft_shd.g_old_rec.comp_selection_rl
185: ,p_person_selection_rl_o =>ben_bft_shd.g_old_rec.person_selection_rl
186: ,p_ler_id_o =>ben_bft_shd.g_old_rec.ler_id
187: ,p_organization_id_o =>ben_bft_shd.g_old_rec.organization_id
188: ,p_benfts_grp_id_o =>ben_bft_shd.g_old_rec.benfts_grp_id
189: ,p_location_id_o =>ben_bft_shd.g_old_rec.location_id
190: ,p_pstl_zip_rng_id_o =>ben_bft_shd.g_old_rec.pstl_zip_rng_id
191: ,p_rptg_grp_id_o =>ben_bft_shd.g_old_rec.rptg_grp_id
184: ,p_comp_selection_rl_o =>ben_bft_shd.g_old_rec.comp_selection_rl
185: ,p_person_selection_rl_o =>ben_bft_shd.g_old_rec.person_selection_rl
186: ,p_ler_id_o =>ben_bft_shd.g_old_rec.ler_id
187: ,p_organization_id_o =>ben_bft_shd.g_old_rec.organization_id
188: ,p_benfts_grp_id_o =>ben_bft_shd.g_old_rec.benfts_grp_id
189: ,p_location_id_o =>ben_bft_shd.g_old_rec.location_id
190: ,p_pstl_zip_rng_id_o =>ben_bft_shd.g_old_rec.pstl_zip_rng_id
191: ,p_rptg_grp_id_o =>ben_bft_shd.g_old_rec.rptg_grp_id
192: ,p_pl_typ_id_o =>ben_bft_shd.g_old_rec.pl_typ_id
185: ,p_person_selection_rl_o =>ben_bft_shd.g_old_rec.person_selection_rl
186: ,p_ler_id_o =>ben_bft_shd.g_old_rec.ler_id
187: ,p_organization_id_o =>ben_bft_shd.g_old_rec.organization_id
188: ,p_benfts_grp_id_o =>ben_bft_shd.g_old_rec.benfts_grp_id
189: ,p_location_id_o =>ben_bft_shd.g_old_rec.location_id
190: ,p_pstl_zip_rng_id_o =>ben_bft_shd.g_old_rec.pstl_zip_rng_id
191: ,p_rptg_grp_id_o =>ben_bft_shd.g_old_rec.rptg_grp_id
192: ,p_pl_typ_id_o =>ben_bft_shd.g_old_rec.pl_typ_id
193: ,p_opt_id_o =>ben_bft_shd.g_old_rec.opt_id
186: ,p_ler_id_o =>ben_bft_shd.g_old_rec.ler_id
187: ,p_organization_id_o =>ben_bft_shd.g_old_rec.organization_id
188: ,p_benfts_grp_id_o =>ben_bft_shd.g_old_rec.benfts_grp_id
189: ,p_location_id_o =>ben_bft_shd.g_old_rec.location_id
190: ,p_pstl_zip_rng_id_o =>ben_bft_shd.g_old_rec.pstl_zip_rng_id
191: ,p_rptg_grp_id_o =>ben_bft_shd.g_old_rec.rptg_grp_id
192: ,p_pl_typ_id_o =>ben_bft_shd.g_old_rec.pl_typ_id
193: ,p_opt_id_o =>ben_bft_shd.g_old_rec.opt_id
194: ,p_eligy_prfl_id_o =>ben_bft_shd.g_old_rec.eligy_prfl_id
187: ,p_organization_id_o =>ben_bft_shd.g_old_rec.organization_id
188: ,p_benfts_grp_id_o =>ben_bft_shd.g_old_rec.benfts_grp_id
189: ,p_location_id_o =>ben_bft_shd.g_old_rec.location_id
190: ,p_pstl_zip_rng_id_o =>ben_bft_shd.g_old_rec.pstl_zip_rng_id
191: ,p_rptg_grp_id_o =>ben_bft_shd.g_old_rec.rptg_grp_id
192: ,p_pl_typ_id_o =>ben_bft_shd.g_old_rec.pl_typ_id
193: ,p_opt_id_o =>ben_bft_shd.g_old_rec.opt_id
194: ,p_eligy_prfl_id_o =>ben_bft_shd.g_old_rec.eligy_prfl_id
195: ,p_vrbl_rt_prfl_id_o =>ben_bft_shd.g_old_rec.vrbl_rt_prfl_id
188: ,p_benfts_grp_id_o =>ben_bft_shd.g_old_rec.benfts_grp_id
189: ,p_location_id_o =>ben_bft_shd.g_old_rec.location_id
190: ,p_pstl_zip_rng_id_o =>ben_bft_shd.g_old_rec.pstl_zip_rng_id
191: ,p_rptg_grp_id_o =>ben_bft_shd.g_old_rec.rptg_grp_id
192: ,p_pl_typ_id_o =>ben_bft_shd.g_old_rec.pl_typ_id
193: ,p_opt_id_o =>ben_bft_shd.g_old_rec.opt_id
194: ,p_eligy_prfl_id_o =>ben_bft_shd.g_old_rec.eligy_prfl_id
195: ,p_vrbl_rt_prfl_id_o =>ben_bft_shd.g_old_rec.vrbl_rt_prfl_id
196: ,p_legal_entity_id_o =>ben_bft_shd.g_old_rec.legal_entity_id
189: ,p_location_id_o =>ben_bft_shd.g_old_rec.location_id
190: ,p_pstl_zip_rng_id_o =>ben_bft_shd.g_old_rec.pstl_zip_rng_id
191: ,p_rptg_grp_id_o =>ben_bft_shd.g_old_rec.rptg_grp_id
192: ,p_pl_typ_id_o =>ben_bft_shd.g_old_rec.pl_typ_id
193: ,p_opt_id_o =>ben_bft_shd.g_old_rec.opt_id
194: ,p_eligy_prfl_id_o =>ben_bft_shd.g_old_rec.eligy_prfl_id
195: ,p_vrbl_rt_prfl_id_o =>ben_bft_shd.g_old_rec.vrbl_rt_prfl_id
196: ,p_legal_entity_id_o =>ben_bft_shd.g_old_rec.legal_entity_id
197: ,p_payroll_id_o =>ben_bft_shd.g_old_rec.payroll_id
190: ,p_pstl_zip_rng_id_o =>ben_bft_shd.g_old_rec.pstl_zip_rng_id
191: ,p_rptg_grp_id_o =>ben_bft_shd.g_old_rec.rptg_grp_id
192: ,p_pl_typ_id_o =>ben_bft_shd.g_old_rec.pl_typ_id
193: ,p_opt_id_o =>ben_bft_shd.g_old_rec.opt_id
194: ,p_eligy_prfl_id_o =>ben_bft_shd.g_old_rec.eligy_prfl_id
195: ,p_vrbl_rt_prfl_id_o =>ben_bft_shd.g_old_rec.vrbl_rt_prfl_id
196: ,p_legal_entity_id_o =>ben_bft_shd.g_old_rec.legal_entity_id
197: ,p_payroll_id_o =>ben_bft_shd.g_old_rec.payroll_id
198: ,p_debug_messages_flag_o =>ben_bft_shd.g_old_rec.debug_messages_flag
191: ,p_rptg_grp_id_o =>ben_bft_shd.g_old_rec.rptg_grp_id
192: ,p_pl_typ_id_o =>ben_bft_shd.g_old_rec.pl_typ_id
193: ,p_opt_id_o =>ben_bft_shd.g_old_rec.opt_id
194: ,p_eligy_prfl_id_o =>ben_bft_shd.g_old_rec.eligy_prfl_id
195: ,p_vrbl_rt_prfl_id_o =>ben_bft_shd.g_old_rec.vrbl_rt_prfl_id
196: ,p_legal_entity_id_o =>ben_bft_shd.g_old_rec.legal_entity_id
197: ,p_payroll_id_o =>ben_bft_shd.g_old_rec.payroll_id
198: ,p_debug_messages_flag_o =>ben_bft_shd.g_old_rec.debug_messages_flag
199: ,p_cm_trgr_typ_cd_o =>ben_bft_shd.g_old_rec.cm_trgr_typ_cd
192: ,p_pl_typ_id_o =>ben_bft_shd.g_old_rec.pl_typ_id
193: ,p_opt_id_o =>ben_bft_shd.g_old_rec.opt_id
194: ,p_eligy_prfl_id_o =>ben_bft_shd.g_old_rec.eligy_prfl_id
195: ,p_vrbl_rt_prfl_id_o =>ben_bft_shd.g_old_rec.vrbl_rt_prfl_id
196: ,p_legal_entity_id_o =>ben_bft_shd.g_old_rec.legal_entity_id
197: ,p_payroll_id_o =>ben_bft_shd.g_old_rec.payroll_id
198: ,p_debug_messages_flag_o =>ben_bft_shd.g_old_rec.debug_messages_flag
199: ,p_cm_trgr_typ_cd_o =>ben_bft_shd.g_old_rec.cm_trgr_typ_cd
200: ,p_cm_typ_id_o =>ben_bft_shd.g_old_rec.cm_typ_id
193: ,p_opt_id_o =>ben_bft_shd.g_old_rec.opt_id
194: ,p_eligy_prfl_id_o =>ben_bft_shd.g_old_rec.eligy_prfl_id
195: ,p_vrbl_rt_prfl_id_o =>ben_bft_shd.g_old_rec.vrbl_rt_prfl_id
196: ,p_legal_entity_id_o =>ben_bft_shd.g_old_rec.legal_entity_id
197: ,p_payroll_id_o =>ben_bft_shd.g_old_rec.payroll_id
198: ,p_debug_messages_flag_o =>ben_bft_shd.g_old_rec.debug_messages_flag
199: ,p_cm_trgr_typ_cd_o =>ben_bft_shd.g_old_rec.cm_trgr_typ_cd
200: ,p_cm_typ_id_o =>ben_bft_shd.g_old_rec.cm_typ_id
201: ,p_age_fctr_id_o =>ben_bft_shd.g_old_rec.age_fctr_id
194: ,p_eligy_prfl_id_o =>ben_bft_shd.g_old_rec.eligy_prfl_id
195: ,p_vrbl_rt_prfl_id_o =>ben_bft_shd.g_old_rec.vrbl_rt_prfl_id
196: ,p_legal_entity_id_o =>ben_bft_shd.g_old_rec.legal_entity_id
197: ,p_payroll_id_o =>ben_bft_shd.g_old_rec.payroll_id
198: ,p_debug_messages_flag_o =>ben_bft_shd.g_old_rec.debug_messages_flag
199: ,p_cm_trgr_typ_cd_o =>ben_bft_shd.g_old_rec.cm_trgr_typ_cd
200: ,p_cm_typ_id_o =>ben_bft_shd.g_old_rec.cm_typ_id
201: ,p_age_fctr_id_o =>ben_bft_shd.g_old_rec.age_fctr_id
202: ,p_min_age_o =>ben_bft_shd.g_old_rec.min_age
195: ,p_vrbl_rt_prfl_id_o =>ben_bft_shd.g_old_rec.vrbl_rt_prfl_id
196: ,p_legal_entity_id_o =>ben_bft_shd.g_old_rec.legal_entity_id
197: ,p_payroll_id_o =>ben_bft_shd.g_old_rec.payroll_id
198: ,p_debug_messages_flag_o =>ben_bft_shd.g_old_rec.debug_messages_flag
199: ,p_cm_trgr_typ_cd_o =>ben_bft_shd.g_old_rec.cm_trgr_typ_cd
200: ,p_cm_typ_id_o =>ben_bft_shd.g_old_rec.cm_typ_id
201: ,p_age_fctr_id_o =>ben_bft_shd.g_old_rec.age_fctr_id
202: ,p_min_age_o =>ben_bft_shd.g_old_rec.min_age
203: ,p_max_age_o =>ben_bft_shd.g_old_rec.max_age
196: ,p_legal_entity_id_o =>ben_bft_shd.g_old_rec.legal_entity_id
197: ,p_payroll_id_o =>ben_bft_shd.g_old_rec.payroll_id
198: ,p_debug_messages_flag_o =>ben_bft_shd.g_old_rec.debug_messages_flag
199: ,p_cm_trgr_typ_cd_o =>ben_bft_shd.g_old_rec.cm_trgr_typ_cd
200: ,p_cm_typ_id_o =>ben_bft_shd.g_old_rec.cm_typ_id
201: ,p_age_fctr_id_o =>ben_bft_shd.g_old_rec.age_fctr_id
202: ,p_min_age_o =>ben_bft_shd.g_old_rec.min_age
203: ,p_max_age_o =>ben_bft_shd.g_old_rec.max_age
204: ,p_los_fctr_id_o =>ben_bft_shd.g_old_rec.los_fctr_id
197: ,p_payroll_id_o =>ben_bft_shd.g_old_rec.payroll_id
198: ,p_debug_messages_flag_o =>ben_bft_shd.g_old_rec.debug_messages_flag
199: ,p_cm_trgr_typ_cd_o =>ben_bft_shd.g_old_rec.cm_trgr_typ_cd
200: ,p_cm_typ_id_o =>ben_bft_shd.g_old_rec.cm_typ_id
201: ,p_age_fctr_id_o =>ben_bft_shd.g_old_rec.age_fctr_id
202: ,p_min_age_o =>ben_bft_shd.g_old_rec.min_age
203: ,p_max_age_o =>ben_bft_shd.g_old_rec.max_age
204: ,p_los_fctr_id_o =>ben_bft_shd.g_old_rec.los_fctr_id
205: ,p_min_los_o =>ben_bft_shd.g_old_rec.min_los
198: ,p_debug_messages_flag_o =>ben_bft_shd.g_old_rec.debug_messages_flag
199: ,p_cm_trgr_typ_cd_o =>ben_bft_shd.g_old_rec.cm_trgr_typ_cd
200: ,p_cm_typ_id_o =>ben_bft_shd.g_old_rec.cm_typ_id
201: ,p_age_fctr_id_o =>ben_bft_shd.g_old_rec.age_fctr_id
202: ,p_min_age_o =>ben_bft_shd.g_old_rec.min_age
203: ,p_max_age_o =>ben_bft_shd.g_old_rec.max_age
204: ,p_los_fctr_id_o =>ben_bft_shd.g_old_rec.los_fctr_id
205: ,p_min_los_o =>ben_bft_shd.g_old_rec.min_los
206: ,p_max_los_o =>ben_bft_shd.g_old_rec.max_los
199: ,p_cm_trgr_typ_cd_o =>ben_bft_shd.g_old_rec.cm_trgr_typ_cd
200: ,p_cm_typ_id_o =>ben_bft_shd.g_old_rec.cm_typ_id
201: ,p_age_fctr_id_o =>ben_bft_shd.g_old_rec.age_fctr_id
202: ,p_min_age_o =>ben_bft_shd.g_old_rec.min_age
203: ,p_max_age_o =>ben_bft_shd.g_old_rec.max_age
204: ,p_los_fctr_id_o =>ben_bft_shd.g_old_rec.los_fctr_id
205: ,p_min_los_o =>ben_bft_shd.g_old_rec.min_los
206: ,p_max_los_o =>ben_bft_shd.g_old_rec.max_los
207: ,p_cmbn_age_los_fctr_id_o =>ben_bft_shd.g_old_rec.cmbn_age_los_fctr_id
200: ,p_cm_typ_id_o =>ben_bft_shd.g_old_rec.cm_typ_id
201: ,p_age_fctr_id_o =>ben_bft_shd.g_old_rec.age_fctr_id
202: ,p_min_age_o =>ben_bft_shd.g_old_rec.min_age
203: ,p_max_age_o =>ben_bft_shd.g_old_rec.max_age
204: ,p_los_fctr_id_o =>ben_bft_shd.g_old_rec.los_fctr_id
205: ,p_min_los_o =>ben_bft_shd.g_old_rec.min_los
206: ,p_max_los_o =>ben_bft_shd.g_old_rec.max_los
207: ,p_cmbn_age_los_fctr_id_o =>ben_bft_shd.g_old_rec.cmbn_age_los_fctr_id
208: ,p_min_cmbn_o =>ben_bft_shd.g_old_rec.min_cmbn
201: ,p_age_fctr_id_o =>ben_bft_shd.g_old_rec.age_fctr_id
202: ,p_min_age_o =>ben_bft_shd.g_old_rec.min_age
203: ,p_max_age_o =>ben_bft_shd.g_old_rec.max_age
204: ,p_los_fctr_id_o =>ben_bft_shd.g_old_rec.los_fctr_id
205: ,p_min_los_o =>ben_bft_shd.g_old_rec.min_los
206: ,p_max_los_o =>ben_bft_shd.g_old_rec.max_los
207: ,p_cmbn_age_los_fctr_id_o =>ben_bft_shd.g_old_rec.cmbn_age_los_fctr_id
208: ,p_min_cmbn_o =>ben_bft_shd.g_old_rec.min_cmbn
209: ,p_max_cmbn_o =>ben_bft_shd.g_old_rec.max_cmbn
202: ,p_min_age_o =>ben_bft_shd.g_old_rec.min_age
203: ,p_max_age_o =>ben_bft_shd.g_old_rec.max_age
204: ,p_los_fctr_id_o =>ben_bft_shd.g_old_rec.los_fctr_id
205: ,p_min_los_o =>ben_bft_shd.g_old_rec.min_los
206: ,p_max_los_o =>ben_bft_shd.g_old_rec.max_los
207: ,p_cmbn_age_los_fctr_id_o =>ben_bft_shd.g_old_rec.cmbn_age_los_fctr_id
208: ,p_min_cmbn_o =>ben_bft_shd.g_old_rec.min_cmbn
209: ,p_max_cmbn_o =>ben_bft_shd.g_old_rec.max_cmbn
210: ,p_date_from_o =>ben_bft_shd.g_old_rec.date_from
203: ,p_max_age_o =>ben_bft_shd.g_old_rec.max_age
204: ,p_los_fctr_id_o =>ben_bft_shd.g_old_rec.los_fctr_id
205: ,p_min_los_o =>ben_bft_shd.g_old_rec.min_los
206: ,p_max_los_o =>ben_bft_shd.g_old_rec.max_los
207: ,p_cmbn_age_los_fctr_id_o =>ben_bft_shd.g_old_rec.cmbn_age_los_fctr_id
208: ,p_min_cmbn_o =>ben_bft_shd.g_old_rec.min_cmbn
209: ,p_max_cmbn_o =>ben_bft_shd.g_old_rec.max_cmbn
210: ,p_date_from_o =>ben_bft_shd.g_old_rec.date_from
211: ,p_elig_enrol_cd_o =>ben_bft_shd.g_old_rec.elig_enrol_cd
204: ,p_los_fctr_id_o =>ben_bft_shd.g_old_rec.los_fctr_id
205: ,p_min_los_o =>ben_bft_shd.g_old_rec.min_los
206: ,p_max_los_o =>ben_bft_shd.g_old_rec.max_los
207: ,p_cmbn_age_los_fctr_id_o =>ben_bft_shd.g_old_rec.cmbn_age_los_fctr_id
208: ,p_min_cmbn_o =>ben_bft_shd.g_old_rec.min_cmbn
209: ,p_max_cmbn_o =>ben_bft_shd.g_old_rec.max_cmbn
210: ,p_date_from_o =>ben_bft_shd.g_old_rec.date_from
211: ,p_elig_enrol_cd_o =>ben_bft_shd.g_old_rec.elig_enrol_cd
212: ,p_actn_typ_id_o =>ben_bft_shd.g_old_rec.actn_typ_id
205: ,p_min_los_o =>ben_bft_shd.g_old_rec.min_los
206: ,p_max_los_o =>ben_bft_shd.g_old_rec.max_los
207: ,p_cmbn_age_los_fctr_id_o =>ben_bft_shd.g_old_rec.cmbn_age_los_fctr_id
208: ,p_min_cmbn_o =>ben_bft_shd.g_old_rec.min_cmbn
209: ,p_max_cmbn_o =>ben_bft_shd.g_old_rec.max_cmbn
210: ,p_date_from_o =>ben_bft_shd.g_old_rec.date_from
211: ,p_elig_enrol_cd_o =>ben_bft_shd.g_old_rec.elig_enrol_cd
212: ,p_actn_typ_id_o =>ben_bft_shd.g_old_rec.actn_typ_id
213: ,p_use_fctr_to_sel_flag_o =>ben_bft_shd.g_old_rec.use_fctr_to_sel_flag
206: ,p_max_los_o =>ben_bft_shd.g_old_rec.max_los
207: ,p_cmbn_age_los_fctr_id_o =>ben_bft_shd.g_old_rec.cmbn_age_los_fctr_id
208: ,p_min_cmbn_o =>ben_bft_shd.g_old_rec.min_cmbn
209: ,p_max_cmbn_o =>ben_bft_shd.g_old_rec.max_cmbn
210: ,p_date_from_o =>ben_bft_shd.g_old_rec.date_from
211: ,p_elig_enrol_cd_o =>ben_bft_shd.g_old_rec.elig_enrol_cd
212: ,p_actn_typ_id_o =>ben_bft_shd.g_old_rec.actn_typ_id
213: ,p_use_fctr_to_sel_flag_o =>ben_bft_shd.g_old_rec.use_fctr_to_sel_flag
214: ,p_los_det_to_use_cd_o =>ben_bft_shd.g_old_rec.los_det_to_use_cd
207: ,p_cmbn_age_los_fctr_id_o =>ben_bft_shd.g_old_rec.cmbn_age_los_fctr_id
208: ,p_min_cmbn_o =>ben_bft_shd.g_old_rec.min_cmbn
209: ,p_max_cmbn_o =>ben_bft_shd.g_old_rec.max_cmbn
210: ,p_date_from_o =>ben_bft_shd.g_old_rec.date_from
211: ,p_elig_enrol_cd_o =>ben_bft_shd.g_old_rec.elig_enrol_cd
212: ,p_actn_typ_id_o =>ben_bft_shd.g_old_rec.actn_typ_id
213: ,p_use_fctr_to_sel_flag_o =>ben_bft_shd.g_old_rec.use_fctr_to_sel_flag
214: ,p_los_det_to_use_cd_o =>ben_bft_shd.g_old_rec.los_det_to_use_cd
215: ,p_audit_log_flag_o =>ben_bft_shd.g_old_rec.audit_log_flag
208: ,p_min_cmbn_o =>ben_bft_shd.g_old_rec.min_cmbn
209: ,p_max_cmbn_o =>ben_bft_shd.g_old_rec.max_cmbn
210: ,p_date_from_o =>ben_bft_shd.g_old_rec.date_from
211: ,p_elig_enrol_cd_o =>ben_bft_shd.g_old_rec.elig_enrol_cd
212: ,p_actn_typ_id_o =>ben_bft_shd.g_old_rec.actn_typ_id
213: ,p_use_fctr_to_sel_flag_o =>ben_bft_shd.g_old_rec.use_fctr_to_sel_flag
214: ,p_los_det_to_use_cd_o =>ben_bft_shd.g_old_rec.los_det_to_use_cd
215: ,p_audit_log_flag_o =>ben_bft_shd.g_old_rec.audit_log_flag
216: ,p_lmt_prpnip_by_org_flag_o =>ben_bft_shd.g_old_rec.lmt_prpnip_by_org_flag
209: ,p_max_cmbn_o =>ben_bft_shd.g_old_rec.max_cmbn
210: ,p_date_from_o =>ben_bft_shd.g_old_rec.date_from
211: ,p_elig_enrol_cd_o =>ben_bft_shd.g_old_rec.elig_enrol_cd
212: ,p_actn_typ_id_o =>ben_bft_shd.g_old_rec.actn_typ_id
213: ,p_use_fctr_to_sel_flag_o =>ben_bft_shd.g_old_rec.use_fctr_to_sel_flag
214: ,p_los_det_to_use_cd_o =>ben_bft_shd.g_old_rec.los_det_to_use_cd
215: ,p_audit_log_flag_o =>ben_bft_shd.g_old_rec.audit_log_flag
216: ,p_lmt_prpnip_by_org_flag_o =>ben_bft_shd.g_old_rec.lmt_prpnip_by_org_flag
217: ,p_lf_evt_ocrd_dt_o =>ben_bft_shd.g_old_rec.lf_evt_ocrd_dt
210: ,p_date_from_o =>ben_bft_shd.g_old_rec.date_from
211: ,p_elig_enrol_cd_o =>ben_bft_shd.g_old_rec.elig_enrol_cd
212: ,p_actn_typ_id_o =>ben_bft_shd.g_old_rec.actn_typ_id
213: ,p_use_fctr_to_sel_flag_o =>ben_bft_shd.g_old_rec.use_fctr_to_sel_flag
214: ,p_los_det_to_use_cd_o =>ben_bft_shd.g_old_rec.los_det_to_use_cd
215: ,p_audit_log_flag_o =>ben_bft_shd.g_old_rec.audit_log_flag
216: ,p_lmt_prpnip_by_org_flag_o =>ben_bft_shd.g_old_rec.lmt_prpnip_by_org_flag
217: ,p_lf_evt_ocrd_dt_o =>ben_bft_shd.g_old_rec.lf_evt_ocrd_dt
218: ,p_ptnl_ler_for_per_stat_cd_o =>ben_bft_shd.g_old_rec.ptnl_ler_for_per_stat_cd
211: ,p_elig_enrol_cd_o =>ben_bft_shd.g_old_rec.elig_enrol_cd
212: ,p_actn_typ_id_o =>ben_bft_shd.g_old_rec.actn_typ_id
213: ,p_use_fctr_to_sel_flag_o =>ben_bft_shd.g_old_rec.use_fctr_to_sel_flag
214: ,p_los_det_to_use_cd_o =>ben_bft_shd.g_old_rec.los_det_to_use_cd
215: ,p_audit_log_flag_o =>ben_bft_shd.g_old_rec.audit_log_flag
216: ,p_lmt_prpnip_by_org_flag_o =>ben_bft_shd.g_old_rec.lmt_prpnip_by_org_flag
217: ,p_lf_evt_ocrd_dt_o =>ben_bft_shd.g_old_rec.lf_evt_ocrd_dt
218: ,p_ptnl_ler_for_per_stat_cd_o =>ben_bft_shd.g_old_rec.ptnl_ler_for_per_stat_cd
219: ,p_bft_attribute_category_o =>ben_bft_shd.g_old_rec.bft_attribute_category
212: ,p_actn_typ_id_o =>ben_bft_shd.g_old_rec.actn_typ_id
213: ,p_use_fctr_to_sel_flag_o =>ben_bft_shd.g_old_rec.use_fctr_to_sel_flag
214: ,p_los_det_to_use_cd_o =>ben_bft_shd.g_old_rec.los_det_to_use_cd
215: ,p_audit_log_flag_o =>ben_bft_shd.g_old_rec.audit_log_flag
216: ,p_lmt_prpnip_by_org_flag_o =>ben_bft_shd.g_old_rec.lmt_prpnip_by_org_flag
217: ,p_lf_evt_ocrd_dt_o =>ben_bft_shd.g_old_rec.lf_evt_ocrd_dt
218: ,p_ptnl_ler_for_per_stat_cd_o =>ben_bft_shd.g_old_rec.ptnl_ler_for_per_stat_cd
219: ,p_bft_attribute_category_o =>ben_bft_shd.g_old_rec.bft_attribute_category
220: ,p_bft_attribute1_o =>ben_bft_shd.g_old_rec.bft_attribute1
213: ,p_use_fctr_to_sel_flag_o =>ben_bft_shd.g_old_rec.use_fctr_to_sel_flag
214: ,p_los_det_to_use_cd_o =>ben_bft_shd.g_old_rec.los_det_to_use_cd
215: ,p_audit_log_flag_o =>ben_bft_shd.g_old_rec.audit_log_flag
216: ,p_lmt_prpnip_by_org_flag_o =>ben_bft_shd.g_old_rec.lmt_prpnip_by_org_flag
217: ,p_lf_evt_ocrd_dt_o =>ben_bft_shd.g_old_rec.lf_evt_ocrd_dt
218: ,p_ptnl_ler_for_per_stat_cd_o =>ben_bft_shd.g_old_rec.ptnl_ler_for_per_stat_cd
219: ,p_bft_attribute_category_o =>ben_bft_shd.g_old_rec.bft_attribute_category
220: ,p_bft_attribute1_o =>ben_bft_shd.g_old_rec.bft_attribute1
221: ,p_bft_attribute3_o =>ben_bft_shd.g_old_rec.bft_attribute3
214: ,p_los_det_to_use_cd_o =>ben_bft_shd.g_old_rec.los_det_to_use_cd
215: ,p_audit_log_flag_o =>ben_bft_shd.g_old_rec.audit_log_flag
216: ,p_lmt_prpnip_by_org_flag_o =>ben_bft_shd.g_old_rec.lmt_prpnip_by_org_flag
217: ,p_lf_evt_ocrd_dt_o =>ben_bft_shd.g_old_rec.lf_evt_ocrd_dt
218: ,p_ptnl_ler_for_per_stat_cd_o =>ben_bft_shd.g_old_rec.ptnl_ler_for_per_stat_cd
219: ,p_bft_attribute_category_o =>ben_bft_shd.g_old_rec.bft_attribute_category
220: ,p_bft_attribute1_o =>ben_bft_shd.g_old_rec.bft_attribute1
221: ,p_bft_attribute3_o =>ben_bft_shd.g_old_rec.bft_attribute3
222: ,p_bft_attribute4_o =>ben_bft_shd.g_old_rec.bft_attribute4
215: ,p_audit_log_flag_o =>ben_bft_shd.g_old_rec.audit_log_flag
216: ,p_lmt_prpnip_by_org_flag_o =>ben_bft_shd.g_old_rec.lmt_prpnip_by_org_flag
217: ,p_lf_evt_ocrd_dt_o =>ben_bft_shd.g_old_rec.lf_evt_ocrd_dt
218: ,p_ptnl_ler_for_per_stat_cd_o =>ben_bft_shd.g_old_rec.ptnl_ler_for_per_stat_cd
219: ,p_bft_attribute_category_o =>ben_bft_shd.g_old_rec.bft_attribute_category
220: ,p_bft_attribute1_o =>ben_bft_shd.g_old_rec.bft_attribute1
221: ,p_bft_attribute3_o =>ben_bft_shd.g_old_rec.bft_attribute3
222: ,p_bft_attribute4_o =>ben_bft_shd.g_old_rec.bft_attribute4
223: ,p_bft_attribute5_o =>ben_bft_shd.g_old_rec.bft_attribute5
216: ,p_lmt_prpnip_by_org_flag_o =>ben_bft_shd.g_old_rec.lmt_prpnip_by_org_flag
217: ,p_lf_evt_ocrd_dt_o =>ben_bft_shd.g_old_rec.lf_evt_ocrd_dt
218: ,p_ptnl_ler_for_per_stat_cd_o =>ben_bft_shd.g_old_rec.ptnl_ler_for_per_stat_cd
219: ,p_bft_attribute_category_o =>ben_bft_shd.g_old_rec.bft_attribute_category
220: ,p_bft_attribute1_o =>ben_bft_shd.g_old_rec.bft_attribute1
221: ,p_bft_attribute3_o =>ben_bft_shd.g_old_rec.bft_attribute3
222: ,p_bft_attribute4_o =>ben_bft_shd.g_old_rec.bft_attribute4
223: ,p_bft_attribute5_o =>ben_bft_shd.g_old_rec.bft_attribute5
224: ,p_bft_attribute6_o =>ben_bft_shd.g_old_rec.bft_attribute6
217: ,p_lf_evt_ocrd_dt_o =>ben_bft_shd.g_old_rec.lf_evt_ocrd_dt
218: ,p_ptnl_ler_for_per_stat_cd_o =>ben_bft_shd.g_old_rec.ptnl_ler_for_per_stat_cd
219: ,p_bft_attribute_category_o =>ben_bft_shd.g_old_rec.bft_attribute_category
220: ,p_bft_attribute1_o =>ben_bft_shd.g_old_rec.bft_attribute1
221: ,p_bft_attribute3_o =>ben_bft_shd.g_old_rec.bft_attribute3
222: ,p_bft_attribute4_o =>ben_bft_shd.g_old_rec.bft_attribute4
223: ,p_bft_attribute5_o =>ben_bft_shd.g_old_rec.bft_attribute5
224: ,p_bft_attribute6_o =>ben_bft_shd.g_old_rec.bft_attribute6
225: ,p_bft_attribute7_o =>ben_bft_shd.g_old_rec.bft_attribute7
218: ,p_ptnl_ler_for_per_stat_cd_o =>ben_bft_shd.g_old_rec.ptnl_ler_for_per_stat_cd
219: ,p_bft_attribute_category_o =>ben_bft_shd.g_old_rec.bft_attribute_category
220: ,p_bft_attribute1_o =>ben_bft_shd.g_old_rec.bft_attribute1
221: ,p_bft_attribute3_o =>ben_bft_shd.g_old_rec.bft_attribute3
222: ,p_bft_attribute4_o =>ben_bft_shd.g_old_rec.bft_attribute4
223: ,p_bft_attribute5_o =>ben_bft_shd.g_old_rec.bft_attribute5
224: ,p_bft_attribute6_o =>ben_bft_shd.g_old_rec.bft_attribute6
225: ,p_bft_attribute7_o =>ben_bft_shd.g_old_rec.bft_attribute7
226: ,p_bft_attribute8_o =>ben_bft_shd.g_old_rec.bft_attribute8
219: ,p_bft_attribute_category_o =>ben_bft_shd.g_old_rec.bft_attribute_category
220: ,p_bft_attribute1_o =>ben_bft_shd.g_old_rec.bft_attribute1
221: ,p_bft_attribute3_o =>ben_bft_shd.g_old_rec.bft_attribute3
222: ,p_bft_attribute4_o =>ben_bft_shd.g_old_rec.bft_attribute4
223: ,p_bft_attribute5_o =>ben_bft_shd.g_old_rec.bft_attribute5
224: ,p_bft_attribute6_o =>ben_bft_shd.g_old_rec.bft_attribute6
225: ,p_bft_attribute7_o =>ben_bft_shd.g_old_rec.bft_attribute7
226: ,p_bft_attribute8_o =>ben_bft_shd.g_old_rec.bft_attribute8
227: ,p_bft_attribute9_o =>ben_bft_shd.g_old_rec.bft_attribute9
220: ,p_bft_attribute1_o =>ben_bft_shd.g_old_rec.bft_attribute1
221: ,p_bft_attribute3_o =>ben_bft_shd.g_old_rec.bft_attribute3
222: ,p_bft_attribute4_o =>ben_bft_shd.g_old_rec.bft_attribute4
223: ,p_bft_attribute5_o =>ben_bft_shd.g_old_rec.bft_attribute5
224: ,p_bft_attribute6_o =>ben_bft_shd.g_old_rec.bft_attribute6
225: ,p_bft_attribute7_o =>ben_bft_shd.g_old_rec.bft_attribute7
226: ,p_bft_attribute8_o =>ben_bft_shd.g_old_rec.bft_attribute8
227: ,p_bft_attribute9_o =>ben_bft_shd.g_old_rec.bft_attribute9
228: ,p_bft_attribute10_o =>ben_bft_shd.g_old_rec.bft_attribute10
221: ,p_bft_attribute3_o =>ben_bft_shd.g_old_rec.bft_attribute3
222: ,p_bft_attribute4_o =>ben_bft_shd.g_old_rec.bft_attribute4
223: ,p_bft_attribute5_o =>ben_bft_shd.g_old_rec.bft_attribute5
224: ,p_bft_attribute6_o =>ben_bft_shd.g_old_rec.bft_attribute6
225: ,p_bft_attribute7_o =>ben_bft_shd.g_old_rec.bft_attribute7
226: ,p_bft_attribute8_o =>ben_bft_shd.g_old_rec.bft_attribute8
227: ,p_bft_attribute9_o =>ben_bft_shd.g_old_rec.bft_attribute9
228: ,p_bft_attribute10_o =>ben_bft_shd.g_old_rec.bft_attribute10
229: ,p_bft_attribute11_o =>ben_bft_shd.g_old_rec.bft_attribute11
222: ,p_bft_attribute4_o =>ben_bft_shd.g_old_rec.bft_attribute4
223: ,p_bft_attribute5_o =>ben_bft_shd.g_old_rec.bft_attribute5
224: ,p_bft_attribute6_o =>ben_bft_shd.g_old_rec.bft_attribute6
225: ,p_bft_attribute7_o =>ben_bft_shd.g_old_rec.bft_attribute7
226: ,p_bft_attribute8_o =>ben_bft_shd.g_old_rec.bft_attribute8
227: ,p_bft_attribute9_o =>ben_bft_shd.g_old_rec.bft_attribute9
228: ,p_bft_attribute10_o =>ben_bft_shd.g_old_rec.bft_attribute10
229: ,p_bft_attribute11_o =>ben_bft_shd.g_old_rec.bft_attribute11
230: ,p_bft_attribute12_o =>ben_bft_shd.g_old_rec.bft_attribute12
223: ,p_bft_attribute5_o =>ben_bft_shd.g_old_rec.bft_attribute5
224: ,p_bft_attribute6_o =>ben_bft_shd.g_old_rec.bft_attribute6
225: ,p_bft_attribute7_o =>ben_bft_shd.g_old_rec.bft_attribute7
226: ,p_bft_attribute8_o =>ben_bft_shd.g_old_rec.bft_attribute8
227: ,p_bft_attribute9_o =>ben_bft_shd.g_old_rec.bft_attribute9
228: ,p_bft_attribute10_o =>ben_bft_shd.g_old_rec.bft_attribute10
229: ,p_bft_attribute11_o =>ben_bft_shd.g_old_rec.bft_attribute11
230: ,p_bft_attribute12_o =>ben_bft_shd.g_old_rec.bft_attribute12
231: ,p_bft_attribute13_o =>ben_bft_shd.g_old_rec.bft_attribute13
224: ,p_bft_attribute6_o =>ben_bft_shd.g_old_rec.bft_attribute6
225: ,p_bft_attribute7_o =>ben_bft_shd.g_old_rec.bft_attribute7
226: ,p_bft_attribute8_o =>ben_bft_shd.g_old_rec.bft_attribute8
227: ,p_bft_attribute9_o =>ben_bft_shd.g_old_rec.bft_attribute9
228: ,p_bft_attribute10_o =>ben_bft_shd.g_old_rec.bft_attribute10
229: ,p_bft_attribute11_o =>ben_bft_shd.g_old_rec.bft_attribute11
230: ,p_bft_attribute12_o =>ben_bft_shd.g_old_rec.bft_attribute12
231: ,p_bft_attribute13_o =>ben_bft_shd.g_old_rec.bft_attribute13
232: ,p_bft_attribute14_o =>ben_bft_shd.g_old_rec.bft_attribute14
225: ,p_bft_attribute7_o =>ben_bft_shd.g_old_rec.bft_attribute7
226: ,p_bft_attribute8_o =>ben_bft_shd.g_old_rec.bft_attribute8
227: ,p_bft_attribute9_o =>ben_bft_shd.g_old_rec.bft_attribute9
228: ,p_bft_attribute10_o =>ben_bft_shd.g_old_rec.bft_attribute10
229: ,p_bft_attribute11_o =>ben_bft_shd.g_old_rec.bft_attribute11
230: ,p_bft_attribute12_o =>ben_bft_shd.g_old_rec.bft_attribute12
231: ,p_bft_attribute13_o =>ben_bft_shd.g_old_rec.bft_attribute13
232: ,p_bft_attribute14_o =>ben_bft_shd.g_old_rec.bft_attribute14
233: ,p_bft_attribute15_o =>ben_bft_shd.g_old_rec.bft_attribute15
226: ,p_bft_attribute8_o =>ben_bft_shd.g_old_rec.bft_attribute8
227: ,p_bft_attribute9_o =>ben_bft_shd.g_old_rec.bft_attribute9
228: ,p_bft_attribute10_o =>ben_bft_shd.g_old_rec.bft_attribute10
229: ,p_bft_attribute11_o =>ben_bft_shd.g_old_rec.bft_attribute11
230: ,p_bft_attribute12_o =>ben_bft_shd.g_old_rec.bft_attribute12
231: ,p_bft_attribute13_o =>ben_bft_shd.g_old_rec.bft_attribute13
232: ,p_bft_attribute14_o =>ben_bft_shd.g_old_rec.bft_attribute14
233: ,p_bft_attribute15_o =>ben_bft_shd.g_old_rec.bft_attribute15
234: ,p_bft_attribute16_o =>ben_bft_shd.g_old_rec.bft_attribute16
227: ,p_bft_attribute9_o =>ben_bft_shd.g_old_rec.bft_attribute9
228: ,p_bft_attribute10_o =>ben_bft_shd.g_old_rec.bft_attribute10
229: ,p_bft_attribute11_o =>ben_bft_shd.g_old_rec.bft_attribute11
230: ,p_bft_attribute12_o =>ben_bft_shd.g_old_rec.bft_attribute12
231: ,p_bft_attribute13_o =>ben_bft_shd.g_old_rec.bft_attribute13
232: ,p_bft_attribute14_o =>ben_bft_shd.g_old_rec.bft_attribute14
233: ,p_bft_attribute15_o =>ben_bft_shd.g_old_rec.bft_attribute15
234: ,p_bft_attribute16_o =>ben_bft_shd.g_old_rec.bft_attribute16
235: ,p_bft_attribute17_o =>ben_bft_shd.g_old_rec.bft_attribute17
228: ,p_bft_attribute10_o =>ben_bft_shd.g_old_rec.bft_attribute10
229: ,p_bft_attribute11_o =>ben_bft_shd.g_old_rec.bft_attribute11
230: ,p_bft_attribute12_o =>ben_bft_shd.g_old_rec.bft_attribute12
231: ,p_bft_attribute13_o =>ben_bft_shd.g_old_rec.bft_attribute13
232: ,p_bft_attribute14_o =>ben_bft_shd.g_old_rec.bft_attribute14
233: ,p_bft_attribute15_o =>ben_bft_shd.g_old_rec.bft_attribute15
234: ,p_bft_attribute16_o =>ben_bft_shd.g_old_rec.bft_attribute16
235: ,p_bft_attribute17_o =>ben_bft_shd.g_old_rec.bft_attribute17
236: ,p_bft_attribute18_o =>ben_bft_shd.g_old_rec.bft_attribute18
229: ,p_bft_attribute11_o =>ben_bft_shd.g_old_rec.bft_attribute11
230: ,p_bft_attribute12_o =>ben_bft_shd.g_old_rec.bft_attribute12
231: ,p_bft_attribute13_o =>ben_bft_shd.g_old_rec.bft_attribute13
232: ,p_bft_attribute14_o =>ben_bft_shd.g_old_rec.bft_attribute14
233: ,p_bft_attribute15_o =>ben_bft_shd.g_old_rec.bft_attribute15
234: ,p_bft_attribute16_o =>ben_bft_shd.g_old_rec.bft_attribute16
235: ,p_bft_attribute17_o =>ben_bft_shd.g_old_rec.bft_attribute17
236: ,p_bft_attribute18_o =>ben_bft_shd.g_old_rec.bft_attribute18
237: ,p_bft_attribute19_o =>ben_bft_shd.g_old_rec.bft_attribute19
230: ,p_bft_attribute12_o =>ben_bft_shd.g_old_rec.bft_attribute12
231: ,p_bft_attribute13_o =>ben_bft_shd.g_old_rec.bft_attribute13
232: ,p_bft_attribute14_o =>ben_bft_shd.g_old_rec.bft_attribute14
233: ,p_bft_attribute15_o =>ben_bft_shd.g_old_rec.bft_attribute15
234: ,p_bft_attribute16_o =>ben_bft_shd.g_old_rec.bft_attribute16
235: ,p_bft_attribute17_o =>ben_bft_shd.g_old_rec.bft_attribute17
236: ,p_bft_attribute18_o =>ben_bft_shd.g_old_rec.bft_attribute18
237: ,p_bft_attribute19_o =>ben_bft_shd.g_old_rec.bft_attribute19
238: ,p_bft_attribute20_o =>ben_bft_shd.g_old_rec.bft_attribute20
231: ,p_bft_attribute13_o =>ben_bft_shd.g_old_rec.bft_attribute13
232: ,p_bft_attribute14_o =>ben_bft_shd.g_old_rec.bft_attribute14
233: ,p_bft_attribute15_o =>ben_bft_shd.g_old_rec.bft_attribute15
234: ,p_bft_attribute16_o =>ben_bft_shd.g_old_rec.bft_attribute16
235: ,p_bft_attribute17_o =>ben_bft_shd.g_old_rec.bft_attribute17
236: ,p_bft_attribute18_o =>ben_bft_shd.g_old_rec.bft_attribute18
237: ,p_bft_attribute19_o =>ben_bft_shd.g_old_rec.bft_attribute19
238: ,p_bft_attribute20_o =>ben_bft_shd.g_old_rec.bft_attribute20
239: ,p_bft_attribute21_o =>ben_bft_shd.g_old_rec.bft_attribute21
232: ,p_bft_attribute14_o =>ben_bft_shd.g_old_rec.bft_attribute14
233: ,p_bft_attribute15_o =>ben_bft_shd.g_old_rec.bft_attribute15
234: ,p_bft_attribute16_o =>ben_bft_shd.g_old_rec.bft_attribute16
235: ,p_bft_attribute17_o =>ben_bft_shd.g_old_rec.bft_attribute17
236: ,p_bft_attribute18_o =>ben_bft_shd.g_old_rec.bft_attribute18
237: ,p_bft_attribute19_o =>ben_bft_shd.g_old_rec.bft_attribute19
238: ,p_bft_attribute20_o =>ben_bft_shd.g_old_rec.bft_attribute20
239: ,p_bft_attribute21_o =>ben_bft_shd.g_old_rec.bft_attribute21
240: ,p_bft_attribute22_o =>ben_bft_shd.g_old_rec.bft_attribute22
233: ,p_bft_attribute15_o =>ben_bft_shd.g_old_rec.bft_attribute15
234: ,p_bft_attribute16_o =>ben_bft_shd.g_old_rec.bft_attribute16
235: ,p_bft_attribute17_o =>ben_bft_shd.g_old_rec.bft_attribute17
236: ,p_bft_attribute18_o =>ben_bft_shd.g_old_rec.bft_attribute18
237: ,p_bft_attribute19_o =>ben_bft_shd.g_old_rec.bft_attribute19
238: ,p_bft_attribute20_o =>ben_bft_shd.g_old_rec.bft_attribute20
239: ,p_bft_attribute21_o =>ben_bft_shd.g_old_rec.bft_attribute21
240: ,p_bft_attribute22_o =>ben_bft_shd.g_old_rec.bft_attribute22
241: ,p_bft_attribute23_o =>ben_bft_shd.g_old_rec.bft_attribute23
234: ,p_bft_attribute16_o =>ben_bft_shd.g_old_rec.bft_attribute16
235: ,p_bft_attribute17_o =>ben_bft_shd.g_old_rec.bft_attribute17
236: ,p_bft_attribute18_o =>ben_bft_shd.g_old_rec.bft_attribute18
237: ,p_bft_attribute19_o =>ben_bft_shd.g_old_rec.bft_attribute19
238: ,p_bft_attribute20_o =>ben_bft_shd.g_old_rec.bft_attribute20
239: ,p_bft_attribute21_o =>ben_bft_shd.g_old_rec.bft_attribute21
240: ,p_bft_attribute22_o =>ben_bft_shd.g_old_rec.bft_attribute22
241: ,p_bft_attribute23_o =>ben_bft_shd.g_old_rec.bft_attribute23
242: ,p_bft_attribute24_o =>ben_bft_shd.g_old_rec.bft_attribute24
235: ,p_bft_attribute17_o =>ben_bft_shd.g_old_rec.bft_attribute17
236: ,p_bft_attribute18_o =>ben_bft_shd.g_old_rec.bft_attribute18
237: ,p_bft_attribute19_o =>ben_bft_shd.g_old_rec.bft_attribute19
238: ,p_bft_attribute20_o =>ben_bft_shd.g_old_rec.bft_attribute20
239: ,p_bft_attribute21_o =>ben_bft_shd.g_old_rec.bft_attribute21
240: ,p_bft_attribute22_o =>ben_bft_shd.g_old_rec.bft_attribute22
241: ,p_bft_attribute23_o =>ben_bft_shd.g_old_rec.bft_attribute23
242: ,p_bft_attribute24_o =>ben_bft_shd.g_old_rec.bft_attribute24
243: ,p_bft_attribute25_o =>ben_bft_shd.g_old_rec.bft_attribute25
236: ,p_bft_attribute18_o =>ben_bft_shd.g_old_rec.bft_attribute18
237: ,p_bft_attribute19_o =>ben_bft_shd.g_old_rec.bft_attribute19
238: ,p_bft_attribute20_o =>ben_bft_shd.g_old_rec.bft_attribute20
239: ,p_bft_attribute21_o =>ben_bft_shd.g_old_rec.bft_attribute21
240: ,p_bft_attribute22_o =>ben_bft_shd.g_old_rec.bft_attribute22
241: ,p_bft_attribute23_o =>ben_bft_shd.g_old_rec.bft_attribute23
242: ,p_bft_attribute24_o =>ben_bft_shd.g_old_rec.bft_attribute24
243: ,p_bft_attribute25_o =>ben_bft_shd.g_old_rec.bft_attribute25
244: ,p_bft_attribute26_o =>ben_bft_shd.g_old_rec.bft_attribute26
237: ,p_bft_attribute19_o =>ben_bft_shd.g_old_rec.bft_attribute19
238: ,p_bft_attribute20_o =>ben_bft_shd.g_old_rec.bft_attribute20
239: ,p_bft_attribute21_o =>ben_bft_shd.g_old_rec.bft_attribute21
240: ,p_bft_attribute22_o =>ben_bft_shd.g_old_rec.bft_attribute22
241: ,p_bft_attribute23_o =>ben_bft_shd.g_old_rec.bft_attribute23
242: ,p_bft_attribute24_o =>ben_bft_shd.g_old_rec.bft_attribute24
243: ,p_bft_attribute25_o =>ben_bft_shd.g_old_rec.bft_attribute25
244: ,p_bft_attribute26_o =>ben_bft_shd.g_old_rec.bft_attribute26
245: ,p_bft_attribute27_o =>ben_bft_shd.g_old_rec.bft_attribute27
238: ,p_bft_attribute20_o =>ben_bft_shd.g_old_rec.bft_attribute20
239: ,p_bft_attribute21_o =>ben_bft_shd.g_old_rec.bft_attribute21
240: ,p_bft_attribute22_o =>ben_bft_shd.g_old_rec.bft_attribute22
241: ,p_bft_attribute23_o =>ben_bft_shd.g_old_rec.bft_attribute23
242: ,p_bft_attribute24_o =>ben_bft_shd.g_old_rec.bft_attribute24
243: ,p_bft_attribute25_o =>ben_bft_shd.g_old_rec.bft_attribute25
244: ,p_bft_attribute26_o =>ben_bft_shd.g_old_rec.bft_attribute26
245: ,p_bft_attribute27_o =>ben_bft_shd.g_old_rec.bft_attribute27
246: ,p_bft_attribute28_o =>ben_bft_shd.g_old_rec.bft_attribute28
239: ,p_bft_attribute21_o =>ben_bft_shd.g_old_rec.bft_attribute21
240: ,p_bft_attribute22_o =>ben_bft_shd.g_old_rec.bft_attribute22
241: ,p_bft_attribute23_o =>ben_bft_shd.g_old_rec.bft_attribute23
242: ,p_bft_attribute24_o =>ben_bft_shd.g_old_rec.bft_attribute24
243: ,p_bft_attribute25_o =>ben_bft_shd.g_old_rec.bft_attribute25
244: ,p_bft_attribute26_o =>ben_bft_shd.g_old_rec.bft_attribute26
245: ,p_bft_attribute27_o =>ben_bft_shd.g_old_rec.bft_attribute27
246: ,p_bft_attribute28_o =>ben_bft_shd.g_old_rec.bft_attribute28
247: ,p_bft_attribute29_o =>ben_bft_shd.g_old_rec.bft_attribute29
240: ,p_bft_attribute22_o =>ben_bft_shd.g_old_rec.bft_attribute22
241: ,p_bft_attribute23_o =>ben_bft_shd.g_old_rec.bft_attribute23
242: ,p_bft_attribute24_o =>ben_bft_shd.g_old_rec.bft_attribute24
243: ,p_bft_attribute25_o =>ben_bft_shd.g_old_rec.bft_attribute25
244: ,p_bft_attribute26_o =>ben_bft_shd.g_old_rec.bft_attribute26
245: ,p_bft_attribute27_o =>ben_bft_shd.g_old_rec.bft_attribute27
246: ,p_bft_attribute28_o =>ben_bft_shd.g_old_rec.bft_attribute28
247: ,p_bft_attribute29_o =>ben_bft_shd.g_old_rec.bft_attribute29
248: ,p_bft_attribute30_o =>ben_bft_shd.g_old_rec.bft_attribute30
241: ,p_bft_attribute23_o =>ben_bft_shd.g_old_rec.bft_attribute23
242: ,p_bft_attribute24_o =>ben_bft_shd.g_old_rec.bft_attribute24
243: ,p_bft_attribute25_o =>ben_bft_shd.g_old_rec.bft_attribute25
244: ,p_bft_attribute26_o =>ben_bft_shd.g_old_rec.bft_attribute26
245: ,p_bft_attribute27_o =>ben_bft_shd.g_old_rec.bft_attribute27
246: ,p_bft_attribute28_o =>ben_bft_shd.g_old_rec.bft_attribute28
247: ,p_bft_attribute29_o =>ben_bft_shd.g_old_rec.bft_attribute29
248: ,p_bft_attribute30_o =>ben_bft_shd.g_old_rec.bft_attribute30
249: ,p_object_version_number_o =>ben_bft_shd.g_old_rec.object_version_number
242: ,p_bft_attribute24_o =>ben_bft_shd.g_old_rec.bft_attribute24
243: ,p_bft_attribute25_o =>ben_bft_shd.g_old_rec.bft_attribute25
244: ,p_bft_attribute26_o =>ben_bft_shd.g_old_rec.bft_attribute26
245: ,p_bft_attribute27_o =>ben_bft_shd.g_old_rec.bft_attribute27
246: ,p_bft_attribute28_o =>ben_bft_shd.g_old_rec.bft_attribute28
247: ,p_bft_attribute29_o =>ben_bft_shd.g_old_rec.bft_attribute29
248: ,p_bft_attribute30_o =>ben_bft_shd.g_old_rec.bft_attribute30
249: ,p_object_version_number_o =>ben_bft_shd.g_old_rec.object_version_number
250: ,p_enrt_perd_id_o =>ben_bft_shd.g_old_rec.enrt_perd_id
243: ,p_bft_attribute25_o =>ben_bft_shd.g_old_rec.bft_attribute25
244: ,p_bft_attribute26_o =>ben_bft_shd.g_old_rec.bft_attribute26
245: ,p_bft_attribute27_o =>ben_bft_shd.g_old_rec.bft_attribute27
246: ,p_bft_attribute28_o =>ben_bft_shd.g_old_rec.bft_attribute28
247: ,p_bft_attribute29_o =>ben_bft_shd.g_old_rec.bft_attribute29
248: ,p_bft_attribute30_o =>ben_bft_shd.g_old_rec.bft_attribute30
249: ,p_object_version_number_o =>ben_bft_shd.g_old_rec.object_version_number
250: ,p_enrt_perd_id_o =>ben_bft_shd.g_old_rec.enrt_perd_id
251: ,p_inelg_action_cd_o =>ben_bft_shd.g_old_rec.inelg_action_cd
244: ,p_bft_attribute26_o =>ben_bft_shd.g_old_rec.bft_attribute26
245: ,p_bft_attribute27_o =>ben_bft_shd.g_old_rec.bft_attribute27
246: ,p_bft_attribute28_o =>ben_bft_shd.g_old_rec.bft_attribute28
247: ,p_bft_attribute29_o =>ben_bft_shd.g_old_rec.bft_attribute29
248: ,p_bft_attribute30_o =>ben_bft_shd.g_old_rec.bft_attribute30
249: ,p_object_version_number_o =>ben_bft_shd.g_old_rec.object_version_number
250: ,p_enrt_perd_id_o =>ben_bft_shd.g_old_rec.enrt_perd_id
251: ,p_inelg_action_cd_o =>ben_bft_shd.g_old_rec.inelg_action_cd
252: ,p_org_hierarchy_id_o =>ben_bft_shd.g_old_rec.org_hierarchy_id
245: ,p_bft_attribute27_o =>ben_bft_shd.g_old_rec.bft_attribute27
246: ,p_bft_attribute28_o =>ben_bft_shd.g_old_rec.bft_attribute28
247: ,p_bft_attribute29_o =>ben_bft_shd.g_old_rec.bft_attribute29
248: ,p_bft_attribute30_o =>ben_bft_shd.g_old_rec.bft_attribute30
249: ,p_object_version_number_o =>ben_bft_shd.g_old_rec.object_version_number
250: ,p_enrt_perd_id_o =>ben_bft_shd.g_old_rec.enrt_perd_id
251: ,p_inelg_action_cd_o =>ben_bft_shd.g_old_rec.inelg_action_cd
252: ,p_org_hierarchy_id_o =>ben_bft_shd.g_old_rec.org_hierarchy_id
253: ,p_org_starting_node_id_o =>ben_bft_shd.g_old_rec.org_starting_node_id
246: ,p_bft_attribute28_o =>ben_bft_shd.g_old_rec.bft_attribute28
247: ,p_bft_attribute29_o =>ben_bft_shd.g_old_rec.bft_attribute29
248: ,p_bft_attribute30_o =>ben_bft_shd.g_old_rec.bft_attribute30
249: ,p_object_version_number_o =>ben_bft_shd.g_old_rec.object_version_number
250: ,p_enrt_perd_id_o =>ben_bft_shd.g_old_rec.enrt_perd_id
251: ,p_inelg_action_cd_o =>ben_bft_shd.g_old_rec.inelg_action_cd
252: ,p_org_hierarchy_id_o =>ben_bft_shd.g_old_rec.org_hierarchy_id
253: ,p_org_starting_node_id_o =>ben_bft_shd.g_old_rec.org_starting_node_id
254: ,p_grade_ladder_id_o =>ben_bft_shd.g_old_rec.grade_ladder_id
247: ,p_bft_attribute29_o =>ben_bft_shd.g_old_rec.bft_attribute29
248: ,p_bft_attribute30_o =>ben_bft_shd.g_old_rec.bft_attribute30
249: ,p_object_version_number_o =>ben_bft_shd.g_old_rec.object_version_number
250: ,p_enrt_perd_id_o =>ben_bft_shd.g_old_rec.enrt_perd_id
251: ,p_inelg_action_cd_o =>ben_bft_shd.g_old_rec.inelg_action_cd
252: ,p_org_hierarchy_id_o =>ben_bft_shd.g_old_rec.org_hierarchy_id
253: ,p_org_starting_node_id_o =>ben_bft_shd.g_old_rec.org_starting_node_id
254: ,p_grade_ladder_id_o =>ben_bft_shd.g_old_rec.grade_ladder_id
255: ,p_asg_events_to_all_sel_dt_o =>ben_bft_shd.g_old_rec.asg_events_to_all_sel_dt
248: ,p_bft_attribute30_o =>ben_bft_shd.g_old_rec.bft_attribute30
249: ,p_object_version_number_o =>ben_bft_shd.g_old_rec.object_version_number
250: ,p_enrt_perd_id_o =>ben_bft_shd.g_old_rec.enrt_perd_id
251: ,p_inelg_action_cd_o =>ben_bft_shd.g_old_rec.inelg_action_cd
252: ,p_org_hierarchy_id_o =>ben_bft_shd.g_old_rec.org_hierarchy_id
253: ,p_org_starting_node_id_o =>ben_bft_shd.g_old_rec.org_starting_node_id
254: ,p_grade_ladder_id_o =>ben_bft_shd.g_old_rec.grade_ladder_id
255: ,p_asg_events_to_all_sel_dt_o =>ben_bft_shd.g_old_rec.asg_events_to_all_sel_dt
256: ,p_rate_id_o =>ben_bft_shd.g_old_rec.rate_id
249: ,p_object_version_number_o =>ben_bft_shd.g_old_rec.object_version_number
250: ,p_enrt_perd_id_o =>ben_bft_shd.g_old_rec.enrt_perd_id
251: ,p_inelg_action_cd_o =>ben_bft_shd.g_old_rec.inelg_action_cd
252: ,p_org_hierarchy_id_o =>ben_bft_shd.g_old_rec.org_hierarchy_id
253: ,p_org_starting_node_id_o =>ben_bft_shd.g_old_rec.org_starting_node_id
254: ,p_grade_ladder_id_o =>ben_bft_shd.g_old_rec.grade_ladder_id
255: ,p_asg_events_to_all_sel_dt_o =>ben_bft_shd.g_old_rec.asg_events_to_all_sel_dt
256: ,p_rate_id_o =>ben_bft_shd.g_old_rec.rate_id
257: ,p_per_sel_dt_cd_o =>ben_bft_shd.g_old_rec.per_sel_dt_cd
250: ,p_enrt_perd_id_o =>ben_bft_shd.g_old_rec.enrt_perd_id
251: ,p_inelg_action_cd_o =>ben_bft_shd.g_old_rec.inelg_action_cd
252: ,p_org_hierarchy_id_o =>ben_bft_shd.g_old_rec.org_hierarchy_id
253: ,p_org_starting_node_id_o =>ben_bft_shd.g_old_rec.org_starting_node_id
254: ,p_grade_ladder_id_o =>ben_bft_shd.g_old_rec.grade_ladder_id
255: ,p_asg_events_to_all_sel_dt_o =>ben_bft_shd.g_old_rec.asg_events_to_all_sel_dt
256: ,p_rate_id_o =>ben_bft_shd.g_old_rec.rate_id
257: ,p_per_sel_dt_cd_o =>ben_bft_shd.g_old_rec.per_sel_dt_cd
258: ,p_per_sel_freq_cd_o =>ben_bft_shd.g_old_rec.per_sel_freq_cd
251: ,p_inelg_action_cd_o =>ben_bft_shd.g_old_rec.inelg_action_cd
252: ,p_org_hierarchy_id_o =>ben_bft_shd.g_old_rec.org_hierarchy_id
253: ,p_org_starting_node_id_o =>ben_bft_shd.g_old_rec.org_starting_node_id
254: ,p_grade_ladder_id_o =>ben_bft_shd.g_old_rec.grade_ladder_id
255: ,p_asg_events_to_all_sel_dt_o =>ben_bft_shd.g_old_rec.asg_events_to_all_sel_dt
256: ,p_rate_id_o =>ben_bft_shd.g_old_rec.rate_id
257: ,p_per_sel_dt_cd_o =>ben_bft_shd.g_old_rec.per_sel_dt_cd
258: ,p_per_sel_freq_cd_o =>ben_bft_shd.g_old_rec.per_sel_freq_cd
259: ,p_per_sel_dt_from_o =>ben_bft_shd.g_old_rec.per_sel_dt_from
252: ,p_org_hierarchy_id_o =>ben_bft_shd.g_old_rec.org_hierarchy_id
253: ,p_org_starting_node_id_o =>ben_bft_shd.g_old_rec.org_starting_node_id
254: ,p_grade_ladder_id_o =>ben_bft_shd.g_old_rec.grade_ladder_id
255: ,p_asg_events_to_all_sel_dt_o =>ben_bft_shd.g_old_rec.asg_events_to_all_sel_dt
256: ,p_rate_id_o =>ben_bft_shd.g_old_rec.rate_id
257: ,p_per_sel_dt_cd_o =>ben_bft_shd.g_old_rec.per_sel_dt_cd
258: ,p_per_sel_freq_cd_o =>ben_bft_shd.g_old_rec.per_sel_freq_cd
259: ,p_per_sel_dt_from_o =>ben_bft_shd.g_old_rec.per_sel_dt_from
260: ,p_per_sel_dt_to_o =>ben_bft_shd.g_old_rec.per_sel_dt_to
253: ,p_org_starting_node_id_o =>ben_bft_shd.g_old_rec.org_starting_node_id
254: ,p_grade_ladder_id_o =>ben_bft_shd.g_old_rec.grade_ladder_id
255: ,p_asg_events_to_all_sel_dt_o =>ben_bft_shd.g_old_rec.asg_events_to_all_sel_dt
256: ,p_rate_id_o =>ben_bft_shd.g_old_rec.rate_id
257: ,p_per_sel_dt_cd_o =>ben_bft_shd.g_old_rec.per_sel_dt_cd
258: ,p_per_sel_freq_cd_o =>ben_bft_shd.g_old_rec.per_sel_freq_cd
259: ,p_per_sel_dt_from_o =>ben_bft_shd.g_old_rec.per_sel_dt_from
260: ,p_per_sel_dt_to_o =>ben_bft_shd.g_old_rec.per_sel_dt_to
261: ,p_year_from_o =>ben_bft_shd.g_old_rec.year_from
254: ,p_grade_ladder_id_o =>ben_bft_shd.g_old_rec.grade_ladder_id
255: ,p_asg_events_to_all_sel_dt_o =>ben_bft_shd.g_old_rec.asg_events_to_all_sel_dt
256: ,p_rate_id_o =>ben_bft_shd.g_old_rec.rate_id
257: ,p_per_sel_dt_cd_o =>ben_bft_shd.g_old_rec.per_sel_dt_cd
258: ,p_per_sel_freq_cd_o =>ben_bft_shd.g_old_rec.per_sel_freq_cd
259: ,p_per_sel_dt_from_o =>ben_bft_shd.g_old_rec.per_sel_dt_from
260: ,p_per_sel_dt_to_o =>ben_bft_shd.g_old_rec.per_sel_dt_to
261: ,p_year_from_o =>ben_bft_shd.g_old_rec.year_from
262: ,p_year_to_o =>ben_bft_shd.g_old_rec.year_to
255: ,p_asg_events_to_all_sel_dt_o =>ben_bft_shd.g_old_rec.asg_events_to_all_sel_dt
256: ,p_rate_id_o =>ben_bft_shd.g_old_rec.rate_id
257: ,p_per_sel_dt_cd_o =>ben_bft_shd.g_old_rec.per_sel_dt_cd
258: ,p_per_sel_freq_cd_o =>ben_bft_shd.g_old_rec.per_sel_freq_cd
259: ,p_per_sel_dt_from_o =>ben_bft_shd.g_old_rec.per_sel_dt_from
260: ,p_per_sel_dt_to_o =>ben_bft_shd.g_old_rec.per_sel_dt_to
261: ,p_year_from_o =>ben_bft_shd.g_old_rec.year_from
262: ,p_year_to_o =>ben_bft_shd.g_old_rec.year_to
263: ,p_cagr_id_o =>ben_bft_shd.g_old_rec.cagr_id
256: ,p_rate_id_o =>ben_bft_shd.g_old_rec.rate_id
257: ,p_per_sel_dt_cd_o =>ben_bft_shd.g_old_rec.per_sel_dt_cd
258: ,p_per_sel_freq_cd_o =>ben_bft_shd.g_old_rec.per_sel_freq_cd
259: ,p_per_sel_dt_from_o =>ben_bft_shd.g_old_rec.per_sel_dt_from
260: ,p_per_sel_dt_to_o =>ben_bft_shd.g_old_rec.per_sel_dt_to
261: ,p_year_from_o =>ben_bft_shd.g_old_rec.year_from
262: ,p_year_to_o =>ben_bft_shd.g_old_rec.year_to
263: ,p_cagr_id_o =>ben_bft_shd.g_old_rec.cagr_id
264: ,p_qual_type_o =>ben_bft_shd.g_old_rec.qual_type
257: ,p_per_sel_dt_cd_o =>ben_bft_shd.g_old_rec.per_sel_dt_cd
258: ,p_per_sel_freq_cd_o =>ben_bft_shd.g_old_rec.per_sel_freq_cd
259: ,p_per_sel_dt_from_o =>ben_bft_shd.g_old_rec.per_sel_dt_from
260: ,p_per_sel_dt_to_o =>ben_bft_shd.g_old_rec.per_sel_dt_to
261: ,p_year_from_o =>ben_bft_shd.g_old_rec.year_from
262: ,p_year_to_o =>ben_bft_shd.g_old_rec.year_to
263: ,p_cagr_id_o =>ben_bft_shd.g_old_rec.cagr_id
264: ,p_qual_type_o =>ben_bft_shd.g_old_rec.qual_type
265: ,p_qual_status_o =>ben_bft_shd.g_old_rec.qual_status
258: ,p_per_sel_freq_cd_o =>ben_bft_shd.g_old_rec.per_sel_freq_cd
259: ,p_per_sel_dt_from_o =>ben_bft_shd.g_old_rec.per_sel_dt_from
260: ,p_per_sel_dt_to_o =>ben_bft_shd.g_old_rec.per_sel_dt_to
261: ,p_year_from_o =>ben_bft_shd.g_old_rec.year_from
262: ,p_year_to_o =>ben_bft_shd.g_old_rec.year_to
263: ,p_cagr_id_o =>ben_bft_shd.g_old_rec.cagr_id
264: ,p_qual_type_o =>ben_bft_shd.g_old_rec.qual_type
265: ,p_qual_status_o =>ben_bft_shd.g_old_rec.qual_status
266: ,p_concat_segs_o =>ben_bft_shd.g_old_rec.concat_segs
259: ,p_per_sel_dt_from_o =>ben_bft_shd.g_old_rec.per_sel_dt_from
260: ,p_per_sel_dt_to_o =>ben_bft_shd.g_old_rec.per_sel_dt_to
261: ,p_year_from_o =>ben_bft_shd.g_old_rec.year_from
262: ,p_year_to_o =>ben_bft_shd.g_old_rec.year_to
263: ,p_cagr_id_o =>ben_bft_shd.g_old_rec.cagr_id
264: ,p_qual_type_o =>ben_bft_shd.g_old_rec.qual_type
265: ,p_qual_status_o =>ben_bft_shd.g_old_rec.qual_status
266: ,p_concat_segs_o =>ben_bft_shd.g_old_rec.concat_segs
267: ,p_grant_price_val_o =>ben_bft_shd.g_old_rec.grant_price_val
260: ,p_per_sel_dt_to_o =>ben_bft_shd.g_old_rec.per_sel_dt_to
261: ,p_year_from_o =>ben_bft_shd.g_old_rec.year_from
262: ,p_year_to_o =>ben_bft_shd.g_old_rec.year_to
263: ,p_cagr_id_o =>ben_bft_shd.g_old_rec.cagr_id
264: ,p_qual_type_o =>ben_bft_shd.g_old_rec.qual_type
265: ,p_qual_status_o =>ben_bft_shd.g_old_rec.qual_status
266: ,p_concat_segs_o =>ben_bft_shd.g_old_rec.concat_segs
267: ,p_grant_price_val_o =>ben_bft_shd.g_old_rec.grant_price_val
268: );
261: ,p_year_from_o =>ben_bft_shd.g_old_rec.year_from
262: ,p_year_to_o =>ben_bft_shd.g_old_rec.year_to
263: ,p_cagr_id_o =>ben_bft_shd.g_old_rec.cagr_id
264: ,p_qual_type_o =>ben_bft_shd.g_old_rec.qual_type
265: ,p_qual_status_o =>ben_bft_shd.g_old_rec.qual_status
266: ,p_concat_segs_o =>ben_bft_shd.g_old_rec.concat_segs
267: ,p_grant_price_val_o =>ben_bft_shd.g_old_rec.grant_price_val
268: );
269: --
262: ,p_year_to_o =>ben_bft_shd.g_old_rec.year_to
263: ,p_cagr_id_o =>ben_bft_shd.g_old_rec.cagr_id
264: ,p_qual_type_o =>ben_bft_shd.g_old_rec.qual_type
265: ,p_qual_status_o =>ben_bft_shd.g_old_rec.qual_status
266: ,p_concat_segs_o =>ben_bft_shd.g_old_rec.concat_segs
267: ,p_grant_price_val_o =>ben_bft_shd.g_old_rec.grant_price_val
268: );
269: --
270: exception
263: ,p_cagr_id_o =>ben_bft_shd.g_old_rec.cagr_id
264: ,p_qual_type_o =>ben_bft_shd.g_old_rec.qual_type
265: ,p_qual_status_o =>ben_bft_shd.g_old_rec.qual_status
266: ,p_concat_segs_o =>ben_bft_shd.g_old_rec.concat_segs
267: ,p_grant_price_val_o =>ben_bft_shd.g_old_rec.grant_price_val
268: );
269: --
270: exception
271: --
288: -- ----------------------------------------------------------------------------
289: Procedure del
290: (
291: p_effective_date in date,
292: p_rec in ben_bft_shd.g_rec_type
293: ) is
294: --
295: l_proc varchar2(72) := g_package||'del';
296: --
298: hr_utility.set_location('Entering:'||l_proc, 5);
299: --
300: -- We must lock the row which we need to delete.
301: --
302: ben_bft_shd.lck
303: (
304: p_rec.benefit_action_id,
305: p_rec.object_version_number
306: );
331: p_benefit_action_id in number,
332: p_object_version_number in number
333: ) is
334: --
335: l_rec ben_bft_shd.g_rec_type;
336: l_proc varchar2(72) := g_package||'del';
337: --
338: Begin
339: hr_utility.set_location('Entering:'||l_proc, 5);