APPS.BEN_BFT_DEL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 51

Procedure delete_dml(p_rec in ben_bft_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'delete_dml';

Line: 62

  delete from ben_benefit_actions
  where benefit_action_id = p_rec.benefit_action_id;

Line: 78

End delete_dml;

Line: 112

Procedure pre_delete(p_rec in ben_bft_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'pre_delete';

Line: 120

End pre_delete;

Line: 154

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';

Line: 167

    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
      );

Line: 284

End post_delete;

Line: 310

  ben_bft_bus.delete_validate(p_rec,p_effective_date);

Line: 314

  pre_delete(p_rec);

Line: 318

  delete_dml(p_rec);

Line: 322

  post_delete(p_effective_date,p_rec);