APPS.BEN_ENB_DEL SQL Statements

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

Line: 51

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

Line: 62

  delete from ben_enrt_bnft
  where enrt_bnft_id = p_rec.enrt_bnft_id;

Line: 78

End delete_dml;

Line: 112

Procedure pre_delete(p_rec in ben_enb_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_enb_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'post_delete';

Line: 167

  ben_enb_rkd.after_delete
(
  p_enrt_bnft_id                =>p_rec.enrt_bnft_id
 ,p_dflt_flag_o                 =>ben_enb_shd.g_old_rec.dflt_flag
 ,p_val_has_bn_prortd_flag_o    =>ben_enb_shd.g_old_rec.val_has_bn_prortd_flag
 ,p_bndry_perd_cd_o             =>ben_enb_shd.g_old_rec.bndry_perd_cd
 ,p_val_o                       =>ben_enb_shd.g_old_rec.val
 ,p_nnmntry_uom_o               =>ben_enb_shd.g_old_rec.nnmntry_uom
 ,p_bnft_typ_cd_o               =>ben_enb_shd.g_old_rec.bnft_typ_cd
 ,p_entr_val_at_enrt_flag_o     =>ben_enb_shd.g_old_rec.entr_val_at_enrt_flag
 ,p_mn_val_o                    =>ben_enb_shd.g_old_rec.mn_val
 ,p_mx_val_o                    =>ben_enb_shd.g_old_rec.mx_val
 ,p_incrmt_val_o                =>ben_enb_shd.g_old_rec.incrmt_val
 ,p_dflt_val_o                  =>ben_enb_shd.g_old_rec.dflt_val
 ,p_rt_typ_cd_o                 =>ben_enb_shd.g_old_rec.rt_typ_cd
 ,p_cvg_mlt_cd_o                =>ben_enb_shd.g_old_rec.cvg_mlt_cd
 ,p_ctfn_rqd_flag_o             =>ben_enb_shd.g_old_rec.ctfn_rqd_flag
 ,p_ordr_num_o                  =>ben_enb_shd.g_old_rec.ordr_num
 ,p_crntly_enrld_flag_o         =>ben_enb_shd.g_old_rec.crntly_enrld_flag
 ,p_elig_per_elctbl_chc_id_o    =>ben_enb_shd.g_old_rec.elig_per_elctbl_chc_id
 ,p_prtt_enrt_rslt_id_o         =>ben_enb_shd.g_old_rec.prtt_enrt_rslt_id
 ,p_comp_lvl_fctr_id_o          =>ben_enb_shd.g_old_rec.comp_lvl_fctr_id
 ,p_business_group_id_o         =>ben_enb_shd.g_old_rec.business_group_id
 ,p_enb_attribute_category_o    =>ben_enb_shd.g_old_rec.enb_attribute_category
 ,p_enb_attribute1_o            =>ben_enb_shd.g_old_rec.enb_attribute1
 ,p_enb_attribute2_o            =>ben_enb_shd.g_old_rec.enb_attribute2
 ,p_enb_attribute3_o            =>ben_enb_shd.g_old_rec.enb_attribute3
 ,p_enb_attribute4_o            =>ben_enb_shd.g_old_rec.enb_attribute4
 ,p_enb_attribute5_o            =>ben_enb_shd.g_old_rec.enb_attribute5
 ,p_enb_attribute6_o            =>ben_enb_shd.g_old_rec.enb_attribute6
 ,p_enb_attribute7_o            =>ben_enb_shd.g_old_rec.enb_attribute7
 ,p_enb_attribute8_o            =>ben_enb_shd.g_old_rec.enb_attribute8
 ,p_enb_attribute9_o            =>ben_enb_shd.g_old_rec.enb_attribute9
 ,p_enb_attribute10_o           =>ben_enb_shd.g_old_rec.enb_attribute10
 ,p_enb_attribute11_o           =>ben_enb_shd.g_old_rec.enb_attribute11
 ,p_enb_attribute12_o           =>ben_enb_shd.g_old_rec.enb_attribute12
 ,p_enb_attribute13_o           =>ben_enb_shd.g_old_rec.enb_attribute13
 ,p_enb_attribute14_o           =>ben_enb_shd.g_old_rec.enb_attribute14
 ,p_enb_attribute15_o           =>ben_enb_shd.g_old_rec.enb_attribute15
 ,p_enb_attribute16_o           =>ben_enb_shd.g_old_rec.enb_attribute16
 ,p_enb_attribute17_o           =>ben_enb_shd.g_old_rec.enb_attribute17
 ,p_enb_attribute18_o           =>ben_enb_shd.g_old_rec.enb_attribute18
 ,p_enb_attribute19_o           =>ben_enb_shd.g_old_rec.enb_attribute19
 ,p_enb_attribute20_o           =>ben_enb_shd.g_old_rec.enb_attribute20
 ,p_enb_attribute21_o           =>ben_enb_shd.g_old_rec.enb_attribute21
 ,p_enb_attribute22_o           =>ben_enb_shd.g_old_rec.enb_attribute22
 ,p_enb_attribute23_o           =>ben_enb_shd.g_old_rec.enb_attribute23
 ,p_enb_attribute24_o           =>ben_enb_shd.g_old_rec.enb_attribute24
 ,p_enb_attribute25_o           =>ben_enb_shd.g_old_rec.enb_attribute25
 ,p_enb_attribute26_o           =>ben_enb_shd.g_old_rec.enb_attribute26
 ,p_enb_attribute27_o           =>ben_enb_shd.g_old_rec.enb_attribute27
 ,p_enb_attribute28_o           =>ben_enb_shd.g_old_rec.enb_attribute28
 ,p_enb_attribute29_o           =>ben_enb_shd.g_old_rec.enb_attribute29
 ,p_enb_attribute30_o           =>ben_enb_shd.g_old_rec.enb_attribute30
 ,p_request_id_o                =>ben_enb_shd.g_old_rec.request_id
 ,p_program_application_id_o    =>ben_enb_shd.g_old_rec.program_application_id
 ,p_program_id_o                =>ben_enb_shd.g_old_rec.program_id
 ,p_mx_wout_ctfn_val_o          =>ben_enb_shd.g_old_rec.mx_wout_ctfn_val
 ,p_mx_wo_ctfn_flag_o           =>ben_enb_shd.g_old_rec.mx_wo_ctfn_flag
 ,p_program_update_date_o       =>ben_enb_shd.g_old_rec.program_update_date
 ,p_object_version_number_o     =>ben_enb_shd.g_old_rec.object_version_number
);

Line: 244

End post_delete;

Line: 270

  ben_enb_bus.delete_validate(p_rec
  ,p_effective_date);

Line: 275

  pre_delete(p_rec);

Line: 279

  delete_dml(p_rec);

Line: 283

  post_delete(
p_effective_date,p_rec);