APPS.BEN_CPY_DEL SQL Statements

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

Line: 51

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

Line: 62

  delete from ben_popl_yr_perd
  where popl_yr_perd_id = p_rec.popl_yr_perd_id;

Line: 78

End delete_dml;

Line: 112

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

Line: 166

    ben_cpy_rkd.after_delete
      (
       p_popl_yr_perd_id               =>p_rec.popl_yr_perd_id
      ,p_yr_perd_id_o                  =>ben_cpy_shd.g_old_rec.yr_perd_id
      ,p_business_group_id_o           =>ben_cpy_shd.g_old_rec.business_group_id
      ,p_pl_id_o                       =>ben_cpy_shd.g_old_rec.pl_id
      ,p_pgm_id_o                      =>ben_cpy_shd.g_old_rec.pgm_id
      ,p_ordr_num_o                    =>ben_cpy_shd.g_old_rec.ordr_num
      ,p_acpt_clm_rqsts_thru_dt_o      =>ben_cpy_shd.g_old_rec.acpt_clm_rqsts_thru_dt
      ,p_py_clms_thru_dt_o             =>ben_cpy_shd.g_old_rec.py_clms_thru_dt
      ,p_cpy_attribute_category_o      =>ben_cpy_shd.g_old_rec.cpy_attribute_category
      ,p_cpy_attribute1_o              =>ben_cpy_shd.g_old_rec.cpy_attribute1
      ,p_cpy_attribute2_o              =>ben_cpy_shd.g_old_rec.cpy_attribute2
      ,p_cpy_attribute3_o              =>ben_cpy_shd.g_old_rec.cpy_attribute3
      ,p_cpy_attribute4_o              =>ben_cpy_shd.g_old_rec.cpy_attribute4
      ,p_cpy_attribute5_o              =>ben_cpy_shd.g_old_rec.cpy_attribute5
      ,p_cpy_attribute6_o              =>ben_cpy_shd.g_old_rec.cpy_attribute6
      ,p_cpy_attribute7_o              =>ben_cpy_shd.g_old_rec.cpy_attribute7
      ,p_cpy_attribute8_o              =>ben_cpy_shd.g_old_rec.cpy_attribute8
      ,p_cpy_attribute9_o              =>ben_cpy_shd.g_old_rec.cpy_attribute9
      ,p_cpy_attribute10_o             =>ben_cpy_shd.g_old_rec.cpy_attribute10
      ,p_cpy_attribute11_o             =>ben_cpy_shd.g_old_rec.cpy_attribute11
      ,p_cpy_attribute12_o             =>ben_cpy_shd.g_old_rec.cpy_attribute12
      ,p_cpy_attribute13_o             =>ben_cpy_shd.g_old_rec.cpy_attribute13
      ,p_cpy_attribute14_o             =>ben_cpy_shd.g_old_rec.cpy_attribute14
      ,p_cpy_attribute15_o             =>ben_cpy_shd.g_old_rec.cpy_attribute15
      ,p_cpy_attribute16_o             =>ben_cpy_shd.g_old_rec.cpy_attribute16
      ,p_cpy_attribute17_o             =>ben_cpy_shd.g_old_rec.cpy_attribute17
      ,p_cpy_attribute18_o             =>ben_cpy_shd.g_old_rec.cpy_attribute18
      ,p_cpy_attribute19_o             =>ben_cpy_shd.g_old_rec.cpy_attribute19
      ,p_cpy_attribute20_o             =>ben_cpy_shd.g_old_rec.cpy_attribute20
      ,p_cpy_attribute21_o             =>ben_cpy_shd.g_old_rec.cpy_attribute21
      ,p_cpy_attribute22_o             =>ben_cpy_shd.g_old_rec.cpy_attribute22
      ,p_cpy_attribute23_o             =>ben_cpy_shd.g_old_rec.cpy_attribute23
      ,p_cpy_attribute24_o             =>ben_cpy_shd.g_old_rec.cpy_attribute24
      ,p_cpy_attribute25_o             =>ben_cpy_shd.g_old_rec.cpy_attribute25
      ,p_cpy_attribute26_o             =>ben_cpy_shd.g_old_rec.cpy_attribute26
      ,p_cpy_attribute27_o             =>ben_cpy_shd.g_old_rec.cpy_attribute27
      ,p_cpy_attribute28_o             =>ben_cpy_shd.g_old_rec.cpy_attribute28
      ,p_cpy_attribute29_o             =>ben_cpy_shd.g_old_rec.cpy_attribute29
      ,p_cpy_attribute30_o             =>ben_cpy_shd.g_old_rec.cpy_attribute30
      ,p_object_version_number_o       =>ben_cpy_shd.g_old_rec.object_version_number
      );

Line: 224

End post_delete;

Line: 249

  ben_cpy_bus.delete_validate(p_rec);

Line: 253

  pre_delete(p_rec);

Line: 257

  delete_dml(p_rec);

Line: 261

  post_delete(p_rec);