APPS.BEN_PEI_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_pei_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_pl_extract_identifier_f
    where pl_extract_identifier_id = p_rec.pl_extract_identifier_id
    and   effective_start_date = p_validation_start_date;

Line: 83

    delete from ben_pl_extract_identifier_f
    where pl_extract_identifier_id = p_rec.pl_extract_identifier_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_pei_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_pei_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_pei_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_pei_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_pei_rkd.after_delete
      (
      p_pl_extract_identifier_id     => p_rec.pl_extract_identifier_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_pl_id_o                      => ben_pei_shd.g_old_rec.pl_id
     ,p_plip_id_o                    => ben_pei_shd.g_old_rec.plip_id
     ,p_oipl_id_o                    => ben_pei_shd.g_old_rec.oipl_id
     ,p_third_party_identifier_o     => ben_pei_shd.g_old_rec.third_party_identifier
     ,p_organization_id_o            => ben_pei_shd.g_old_rec.organization_id
     ,p_job_id_o                     => ben_pei_shd.g_old_rec.job_id
     ,p_position_id_o                => ben_pei_shd.g_old_rec.position_id
     ,p_people_group_id_o            => ben_pei_shd.g_old_rec.people_group_id
     ,p_grade_id_o                   => ben_pei_shd.g_old_rec.grade_id
     ,p_payroll_id_o                 => ben_pei_shd.g_old_rec.payroll_id
     ,p_home_state_o                 => ben_pei_shd.g_old_rec.home_state
     ,p_home_zip_o                   => ben_pei_shd.g_old_rec.home_zip
     ,p_effective_start_date_o       => ben_pei_shd.g_old_rec.effective_start_date
     ,p_effective_end_date_o         => ben_pei_shd.g_old_rec.effective_end_date
     ,p_object_version_number_o      => ben_pei_shd.g_old_rec.object_version_number
     ,p_business_group_id_o          => ben_pei_shd.g_old_rec.business_group_id
      );

Line: 340

End post_delete;

Line: 375

  ben_pei_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: 384

  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: 393

  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: 402

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