The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure delete_dml(p_rec in ben_bft_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'delete_dml';
delete from ben_benefit_actions
where benefit_action_id = p_rec.benefit_action_id;
End delete_dml;
Procedure pre_delete(p_rec in ben_bft_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'pre_delete';
End pre_delete;
Procedure post_delete(p_effective_date in date,
p_rec in ben_bft_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'post_delete';
ben_bft_rkd.after_delete
(
p_benefit_action_id =>p_rec.benefit_action_id
,p_process_date_o =>ben_bft_shd.g_old_rec.process_date
,p_uneai_effective_date_o =>ben_bft_shd.g_old_rec.uneai_effective_date
,p_mode_cd_o =>ben_bft_shd.g_old_rec.mode_cd
,p_derivable_factors_flag_o =>ben_bft_shd.g_old_rec.derivable_factors_flag
,p_close_uneai_flag_o =>ben_bft_shd.g_old_rec.close_uneai_flag
,p_validate_flag_o =>ben_bft_shd.g_old_rec.validate_flag
,p_person_id_o =>ben_bft_shd.g_old_rec.person_id
,p_person_type_id_o =>ben_bft_shd.g_old_rec.person_type_id
,p_pgm_id_o =>ben_bft_shd.g_old_rec.pgm_id
,p_business_group_id_o =>ben_bft_shd.g_old_rec.business_group_id
,p_pl_id_o =>ben_bft_shd.g_old_rec.pl_id
,p_popl_enrt_typ_cycl_id_o =>ben_bft_shd.g_old_rec.popl_enrt_typ_cycl_id
,p_no_programs_flag_o =>ben_bft_shd.g_old_rec.no_programs_flag
,p_no_plans_flag_o =>ben_bft_shd.g_old_rec.no_plans_flag
,p_comp_selection_rl_o =>ben_bft_shd.g_old_rec.comp_selection_rl
,p_person_selection_rl_o =>ben_bft_shd.g_old_rec.person_selection_rl
,p_ler_id_o =>ben_bft_shd.g_old_rec.ler_id
,p_organization_id_o =>ben_bft_shd.g_old_rec.organization_id
,p_benfts_grp_id_o =>ben_bft_shd.g_old_rec.benfts_grp_id
,p_location_id_o =>ben_bft_shd.g_old_rec.location_id
,p_pstl_zip_rng_id_o =>ben_bft_shd.g_old_rec.pstl_zip_rng_id
,p_rptg_grp_id_o =>ben_bft_shd.g_old_rec.rptg_grp_id
,p_pl_typ_id_o =>ben_bft_shd.g_old_rec.pl_typ_id
,p_opt_id_o =>ben_bft_shd.g_old_rec.opt_id
,p_eligy_prfl_id_o =>ben_bft_shd.g_old_rec.eligy_prfl_id
,p_vrbl_rt_prfl_id_o =>ben_bft_shd.g_old_rec.vrbl_rt_prfl_id
,p_legal_entity_id_o =>ben_bft_shd.g_old_rec.legal_entity_id
,p_payroll_id_o =>ben_bft_shd.g_old_rec.payroll_id
,p_debug_messages_flag_o =>ben_bft_shd.g_old_rec.debug_messages_flag
,p_cm_trgr_typ_cd_o =>ben_bft_shd.g_old_rec.cm_trgr_typ_cd
,p_cm_typ_id_o =>ben_bft_shd.g_old_rec.cm_typ_id
,p_age_fctr_id_o =>ben_bft_shd.g_old_rec.age_fctr_id
,p_min_age_o =>ben_bft_shd.g_old_rec.min_age
,p_max_age_o =>ben_bft_shd.g_old_rec.max_age
,p_los_fctr_id_o =>ben_bft_shd.g_old_rec.los_fctr_id
,p_min_los_o =>ben_bft_shd.g_old_rec.min_los
,p_max_los_o =>ben_bft_shd.g_old_rec.max_los
,p_cmbn_age_los_fctr_id_o =>ben_bft_shd.g_old_rec.cmbn_age_los_fctr_id
,p_min_cmbn_o =>ben_bft_shd.g_old_rec.min_cmbn
,p_max_cmbn_o =>ben_bft_shd.g_old_rec.max_cmbn
,p_date_from_o =>ben_bft_shd.g_old_rec.date_from
,p_elig_enrol_cd_o =>ben_bft_shd.g_old_rec.elig_enrol_cd
,p_actn_typ_id_o =>ben_bft_shd.g_old_rec.actn_typ_id
,p_use_fctr_to_sel_flag_o =>ben_bft_shd.g_old_rec.use_fctr_to_sel_flag
,p_los_det_to_use_cd_o =>ben_bft_shd.g_old_rec.los_det_to_use_cd
,p_audit_log_flag_o =>ben_bft_shd.g_old_rec.audit_log_flag
,p_lmt_prpnip_by_org_flag_o =>ben_bft_shd.g_old_rec.lmt_prpnip_by_org_flag
,p_lf_evt_ocrd_dt_o =>ben_bft_shd.g_old_rec.lf_evt_ocrd_dt
,p_ptnl_ler_for_per_stat_cd_o =>ben_bft_shd.g_old_rec.ptnl_ler_for_per_stat_cd
,p_bft_attribute_category_o =>ben_bft_shd.g_old_rec.bft_attribute_category
,p_bft_attribute1_o =>ben_bft_shd.g_old_rec.bft_attribute1
,p_bft_attribute3_o =>ben_bft_shd.g_old_rec.bft_attribute3
,p_bft_attribute4_o =>ben_bft_shd.g_old_rec.bft_attribute4
,p_bft_attribute5_o =>ben_bft_shd.g_old_rec.bft_attribute5
,p_bft_attribute6_o =>ben_bft_shd.g_old_rec.bft_attribute6
,p_bft_attribute7_o =>ben_bft_shd.g_old_rec.bft_attribute7
,p_bft_attribute8_o =>ben_bft_shd.g_old_rec.bft_attribute8
,p_bft_attribute9_o =>ben_bft_shd.g_old_rec.bft_attribute9
,p_bft_attribute10_o =>ben_bft_shd.g_old_rec.bft_attribute10
,p_bft_attribute11_o =>ben_bft_shd.g_old_rec.bft_attribute11
,p_bft_attribute12_o =>ben_bft_shd.g_old_rec.bft_attribute12
,p_bft_attribute13_o =>ben_bft_shd.g_old_rec.bft_attribute13
,p_bft_attribute14_o =>ben_bft_shd.g_old_rec.bft_attribute14
,p_bft_attribute15_o =>ben_bft_shd.g_old_rec.bft_attribute15
,p_bft_attribute16_o =>ben_bft_shd.g_old_rec.bft_attribute16
,p_bft_attribute17_o =>ben_bft_shd.g_old_rec.bft_attribute17
,p_bft_attribute18_o =>ben_bft_shd.g_old_rec.bft_attribute18
,p_bft_attribute19_o =>ben_bft_shd.g_old_rec.bft_attribute19
,p_bft_attribute20_o =>ben_bft_shd.g_old_rec.bft_attribute20
,p_bft_attribute21_o =>ben_bft_shd.g_old_rec.bft_attribute21
,p_bft_attribute22_o =>ben_bft_shd.g_old_rec.bft_attribute22
,p_bft_attribute23_o =>ben_bft_shd.g_old_rec.bft_attribute23
,p_bft_attribute24_o =>ben_bft_shd.g_old_rec.bft_attribute24
,p_bft_attribute25_o =>ben_bft_shd.g_old_rec.bft_attribute25
,p_bft_attribute26_o =>ben_bft_shd.g_old_rec.bft_attribute26
,p_bft_attribute27_o =>ben_bft_shd.g_old_rec.bft_attribute27
,p_bft_attribute28_o =>ben_bft_shd.g_old_rec.bft_attribute28
,p_bft_attribute29_o =>ben_bft_shd.g_old_rec.bft_attribute29
,p_bft_attribute30_o =>ben_bft_shd.g_old_rec.bft_attribute30
,p_object_version_number_o =>ben_bft_shd.g_old_rec.object_version_number
,p_enrt_perd_id_o =>ben_bft_shd.g_old_rec.enrt_perd_id
,p_inelg_action_cd_o =>ben_bft_shd.g_old_rec.inelg_action_cd
,p_org_hierarchy_id_o =>ben_bft_shd.g_old_rec.org_hierarchy_id
,p_org_starting_node_id_o =>ben_bft_shd.g_old_rec.org_starting_node_id
,p_grade_ladder_id_o =>ben_bft_shd.g_old_rec.grade_ladder_id
,p_asg_events_to_all_sel_dt_o =>ben_bft_shd.g_old_rec.asg_events_to_all_sel_dt
,p_rate_id_o =>ben_bft_shd.g_old_rec.rate_id
,p_per_sel_dt_cd_o =>ben_bft_shd.g_old_rec.per_sel_dt_cd
,p_per_sel_freq_cd_o =>ben_bft_shd.g_old_rec.per_sel_freq_cd
,p_per_sel_dt_from_o =>ben_bft_shd.g_old_rec.per_sel_dt_from
,p_per_sel_dt_to_o =>ben_bft_shd.g_old_rec.per_sel_dt_to
,p_year_from_o =>ben_bft_shd.g_old_rec.year_from
,p_year_to_o =>ben_bft_shd.g_old_rec.year_to
,p_cagr_id_o =>ben_bft_shd.g_old_rec.cagr_id
,p_qual_type_o =>ben_bft_shd.g_old_rec.qual_type
,p_qual_status_o =>ben_bft_shd.g_old_rec.qual_status
,p_concat_segs_o =>ben_bft_shd.g_old_rec.concat_segs
,p_grant_price_val_o =>ben_bft_shd.g_old_rec.grant_price_val
);
End post_delete;
ben_bft_bus.delete_validate(p_rec,p_effective_date);
pre_delete(p_rec);
delete_dml(p_rec);
post_delete(p_effective_date,p_rec);