APPS.BEN_BPI_DEL SQL Statements

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

Line: 51

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

Line: 62

  delete from ben_batch_proc_info
  where batch_proc_id = p_rec.batch_proc_id;

Line: 78

End delete_dml;

Line: 112

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

Line: 120

End pre_delete;

Line: 154

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

Line: 166

    ben_bpi_rkd.after_delete
      (p_batch_proc_id           =>p_rec.batch_proc_id
      ,p_benefit_action_id_o     =>ben_bpi_shd.g_old_rec.benefit_action_id
      ,p_strt_dt_o               =>ben_bpi_shd.g_old_rec.strt_dt
      ,p_end_dt_o                =>ben_bpi_shd.g_old_rec.end_dt
      ,p_strt_tm_o               =>ben_bpi_shd.g_old_rec.strt_tm
      ,p_end_tm_o                =>ben_bpi_shd.g_old_rec.end_tm
      ,p_elpsd_tm_o              =>ben_bpi_shd.g_old_rec.elpsd_tm
      ,p_per_slctd_o             =>ben_bpi_shd.g_old_rec.per_slctd
      ,p_per_proc_o              =>ben_bpi_shd.g_old_rec.per_proc
      ,p_per_unproc_o            =>ben_bpi_shd.g_old_rec.per_unproc
      ,p_per_proc_succ_o         =>ben_bpi_shd.g_old_rec.per_proc_succ
      ,p_per_err_o               =>ben_bpi_shd.g_old_rec.per_err
      ,p_business_group_id_o     =>ben_bpi_shd.g_old_rec.business_group_id
      ,p_object_version_number_o =>ben_bpi_shd.g_old_rec.object_version_number
      );

Line: 197

End post_delete;

Line: 222

  ben_bpi_bus.delete_validate(p_rec);

Line: 226

  pre_delete(p_rec);

Line: 230

  delete_dml(p_rec);

Line: 234

  post_delete(p_rec);