APPS.BEN_AVR_DEL SQL Statements

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

Line: 53

Procedure dt_delete_dml
    (p_rec           in out nocopy ben_avr_shd.g_rec_type,
     p_effective_date    in date,
     p_datetrack_mode    in varchar2,
     p_validation_start_date in date,
     p_validation_end_date   in date) is
--
  l_proc    varchar2(72) := g_package||'dt_delete_dml';

Line: 64

  If (p_datetrack_mode = 'DELETE_NEXT_CHANGE') then
    hr_utility.set_location(l_proc, 10);

Line: 71

    delete from ben_acty_vrbl_rt_f
    where       acty_vrbl_rt_id = p_rec.acty_vrbl_rt_id
    and   effective_start_date = p_validation_start_date;

Line: 83

    delete from ben_acty_vrbl_rt_f
    where        acty_vrbl_rt_id = p_rec.acty_vrbl_rt_id
    and   effective_start_date >= p_validation_start_date;

Line: 96

End dt_delete_dml;

Line: 101

Procedure delete_dml
    (p_rec           in out nocopy ben_avr_shd.g_rec_type,
     p_effective_date    in date,
     p_datetrack_mode    in varchar2,
     p_validation_start_date in date,
     p_validation_end_date   in date) is
--
  l_proc    varchar2(72) := g_package||'delete_dml';

Line: 113

  dt_delete_dml(p_rec           => p_rec,
        p_effective_date    => p_effective_date,
        p_datetrack_mode    => p_datetrack_mode,
            p_validation_start_date => p_validation_start_date,
        p_validation_end_date   => p_validation_end_date);

Line: 120

End delete_dml;

Line: 155

Procedure dt_pre_delete
    (p_rec           in out nocopy ben_avr_shd.g_rec_type,
     p_effective_date    in date,
     p_datetrack_mode    in varchar2,
     p_validation_start_date in date,
     p_validation_end_date   in date) is
--
  l_proc    varchar2(72) := g_package||'dt_pre_delete';

Line: 171

    If (p_datetrack_mode = 'DELETE') then
      p_rec.effective_end_date := p_validation_start_date - 1;

Line: 191

End dt_pre_delete;

Line: 226

Procedure pre_delete
    (p_rec           in out nocopy ben_avr_shd.g_rec_type,
     p_effective_date    in date,
     p_datetrack_mode    in varchar2,
     p_validation_start_date in date,
     p_validation_end_date   in date) is
--
  l_proc    varchar2(72) := g_package||'pre_delete';

Line: 242

  dt_pre_delete
    (p_rec           => p_rec,
     p_effective_date        => p_effective_date,
     p_datetrack_mode        => p_datetrack_mode,
     p_validation_start_date => p_validation_start_date,
     p_validation_end_date   => p_validation_end_date);

Line: 250

End pre_delete;

Line: 284

Procedure post_delete
    (p_rec           in ben_avr_shd.g_rec_type,
     p_effective_date    in date,
     p_datetrack_mode    in varchar2,
     p_validation_start_date in date,
     p_validation_end_date   in date) is
--
  l_proc    varchar2(72) := g_package||'post_delete';

Line: 301

    ben_avr_rkd.after_delete
      (
  p_acty_vrbl_rt_id               =>p_rec.acty_vrbl_rt_id
 ,p_datetrack_mode                =>p_datetrack_mode
 ,p_validation_start_date         =>p_validation_start_date
 ,p_validation_end_date           =>p_validation_end_date
 ,p_effective_start_date          =>p_rec.effective_start_date
 ,p_effective_end_date            =>p_rec.effective_end_date
 ,p_effective_start_date_o        =>ben_avr_shd.g_old_rec.effective_start_date
 ,p_effective_end_date_o          =>ben_avr_shd.g_old_rec.effective_end_date
 ,p_acty_base_rt_id_o             =>ben_avr_shd.g_old_rec.acty_base_rt_id
 ,p_vrbl_rt_prfl_id_o             =>ben_avr_shd.g_old_rec.vrbl_rt_prfl_id
 ,p_ordr_num_o                    =>ben_avr_shd.g_old_rec.ordr_num
 ,p_business_group_id_o           =>ben_avr_shd.g_old_rec.business_group_id
 ,p_avr_attribute_category_o      =>ben_avr_shd.g_old_rec.avr_attribute_category
 ,p_avr_attribute1_o              =>ben_avr_shd.g_old_rec.avr_attribute1
 ,p_avr_attribute2_o              =>ben_avr_shd.g_old_rec.avr_attribute2
 ,p_avr_attribute3_o              =>ben_avr_shd.g_old_rec.avr_attribute3
 ,p_avr_attribute4_o              =>ben_avr_shd.g_old_rec.avr_attribute4
 ,p_avr_attribute5_o              =>ben_avr_shd.g_old_rec.avr_attribute5
 ,p_avr_attribute6_o              =>ben_avr_shd.g_old_rec.avr_attribute6
 ,p_avr_attribute7_o              =>ben_avr_shd.g_old_rec.avr_attribute7
 ,p_avr_attribute8_o              =>ben_avr_shd.g_old_rec.avr_attribute8
 ,p_avr_attribute9_o              =>ben_avr_shd.g_old_rec.avr_attribute9
 ,p_avr_attribute10_o             =>ben_avr_shd.g_old_rec.avr_attribute10
 ,p_avr_attribute11_o             =>ben_avr_shd.g_old_rec.avr_attribute11
 ,p_avr_attribute12_o             =>ben_avr_shd.g_old_rec.avr_attribute12
 ,p_avr_attribute13_o             =>ben_avr_shd.g_old_rec.avr_attribute13
 ,p_avr_attribute14_o             =>ben_avr_shd.g_old_rec.avr_attribute14
 ,p_avr_attribute15_o             =>ben_avr_shd.g_old_rec.avr_attribute15
 ,p_avr_attribute16_o             =>ben_avr_shd.g_old_rec.avr_attribute16
 ,p_avr_attribute17_o             =>ben_avr_shd.g_old_rec.avr_attribute17
 ,p_avr_attribute18_o             =>ben_avr_shd.g_old_rec.avr_attribute18
 ,p_avr_attribute19_o             =>ben_avr_shd.g_old_rec.avr_attribute19
 ,p_avr_attribute20_o             =>ben_avr_shd.g_old_rec.avr_attribute20
 ,p_avr_attribute21_o             =>ben_avr_shd.g_old_rec.avr_attribute21
 ,p_avr_attribute22_o             =>ben_avr_shd.g_old_rec.avr_attribute22
 ,p_avr_attribute23_o             =>ben_avr_shd.g_old_rec.avr_attribute23
 ,p_avr_attribute24_o             =>ben_avr_shd.g_old_rec.avr_attribute24
 ,p_avr_attribute25_o             =>ben_avr_shd.g_old_rec.avr_attribute25
 ,p_avr_attribute26_o             =>ben_avr_shd.g_old_rec.avr_attribute26
 ,p_avr_attribute27_o             =>ben_avr_shd.g_old_rec.avr_attribute27
 ,p_avr_attribute28_o             =>ben_avr_shd.g_old_rec.avr_attribute28
 ,p_avr_attribute29_o             =>ben_avr_shd.g_old_rec.avr_attribute29
 ,p_avr_attribute30_o             =>ben_avr_shd.g_old_rec.avr_attribute30
 ,p_object_version_number_o       =>ben_avr_shd.g_old_rec.object_version_number
      );

Line: 363

End post_delete;

Line: 398

  ben_avr_bus.delete_validate
    (p_rec           => p_rec,
     p_effective_date    => p_effective_date,
     p_datetrack_mode    => p_datetrack_mode,
     p_validation_start_date => l_validation_start_date,
     p_validation_end_date   => l_validation_end_date);

Line: 407

  pre_delete
    (p_rec           => p_rec,
     p_effective_date    => p_effective_date,
     p_datetrack_mode    => p_datetrack_mode,
     p_validation_start_date => l_validation_start_date,
     p_validation_end_date   => l_validation_end_date);

Line: 416

  delete_dml
    (p_rec           => p_rec,
     p_effective_date    => p_effective_date,
     p_datetrack_mode    => p_datetrack_mode,
     p_validation_start_date => l_validation_start_date,
     p_validation_end_date   => l_validation_end_date);

Line: 425

  post_delete
    (p_rec           => p_rec,
     p_effective_date    => p_effective_date,
     p_datetrack_mode    => p_datetrack_mode,
     p_validation_start_date => l_validation_start_date,
     p_validation_end_date   => l_validation_end_date);