eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_SPS_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 per_sps_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: 65


  If (p_datetrack_mode = hr_api.g_delete_next_change) then
    per_sps_shd.g_api_dml := true;  -- Set the api dml status

Line: 71


    delete from per_spinal_point_steps_f
    where       step_id = p_rec.step_id
    and   effective_start_date = p_validation_start_date;

Line: 82


    delete from per_spinal_point_steps_f
    where        step_id = p_rec.step_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 per_sps_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: 114


  per_sps_del.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: 123


End delete_dml;

Line: 158


Procedure dt_pre_delete
  (p_rec                     in out nocopy per_sps_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: 173


        select spine.grade_id
              ,step.spinal_point_id
        from per_grade_spines_f spine
            ,per_spinal_point_steps_f step
        where step.step_id = p_rec.step_id
        and   p_effective_date between
              step.effective_start_date and step.effective_end_date
        and   step.grade_spine_id = spine.grade_spine_id
        and   p_effective_date between
              spine.effective_start_date and spine.effective_end_date;

Line: 198


    l_return := pqh_gsp_sync_compensation_obj.delete_oipl_for_step
      (p_grade_id                => l_grade_id
      ,p_spinal_point_id         => l_spinal_point_id
      ,p_step_id                 => p_rec.step_id
      ,p_effective_date          => p_effective_date
      ,p_datetrack_mode          => p_datetrack_mode
      );

Line: 206


    hr_utility.trace('pqh_gsp_sync_compensation_obj.delete_oipl_for_step : '
                  || l_return);

Line: 227


    If (p_datetrack_mode = hr_api.g_delete) then
      p_rec.effective_end_date := p_validation_start_date - 1;

Line: 248


End dt_pre_delete;

Line: 283


Procedure pre_delete
  (p_rec                   in out nocopy per_sps_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: 300


  per_sps_del.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: 309


End pre_delete;

Line: 343


Procedure post_delete
  (p_rec                   in per_sps_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: 357


    per_sps_rkd.after_delete
      (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
      ,p_step_id
      => p_rec.step_id
      ,p_effective_start_date
      => p_rec.effective_start_date
      ,p_effective_end_date
      => p_rec.effective_end_date
      ,p_effective_start_date_o
      => per_sps_shd.g_old_rec.effective_start_date
      ,p_effective_end_date_o
      => per_sps_shd.g_old_rec.effective_end_date
      ,p_business_group_id_o
      => per_sps_shd.g_old_rec.business_group_id
      ,p_spinal_point_id_o
      => per_sps_shd.g_old_rec.spinal_point_id
      ,p_grade_spine_id_o
      => per_sps_shd.g_old_rec.grade_spine_id
      ,p_sequence_o
      => per_sps_shd.g_old_rec.sequence
      ,p_request_id_o
      => per_sps_shd.g_old_rec.request_id
      ,p_program_application_id_o
      => per_sps_shd.g_old_rec.program_application_id
      ,p_program_id_o
      => per_sps_shd.g_old_rec.program_id
      ,p_program_update_date_o
      => per_sps_shd.g_old_rec.program_update_date
      ,p_information1_o
      => per_sps_shd.g_old_rec.information1
      ,p_information2_o
      => per_sps_shd.g_old_rec.information2
      ,p_information3_o
      => per_sps_shd.g_old_rec.information3
      ,p_information4_o
      => per_sps_shd.g_old_rec.information4
      ,p_information5_o
      => per_sps_shd.g_old_rec.information5
      ,p_information6_o
      => per_sps_shd.g_old_rec.information6
      ,p_information7_o
      => per_sps_shd.g_old_rec.information7
      ,p_information8_o
      => per_sps_shd.g_old_rec.information8
      ,p_information9_o
      => per_sps_shd.g_old_rec.information9
      ,p_information10_o
      => per_sps_shd.g_old_rec.information10
      ,p_information11_o
      => per_sps_shd.g_old_rec.information11
      ,p_information12_o
      => per_sps_shd.g_old_rec.information12
      ,p_information13_o
      => per_sps_shd.g_old_rec.information13
      ,p_information14_o
      => per_sps_shd.g_old_rec.information14
      ,p_information15_o
      => per_sps_shd.g_old_rec.information15
      ,p_information16_o
      => per_sps_shd.g_old_rec.information16
      ,p_information17_o
      => per_sps_shd.g_old_rec.information17
      ,p_information18_o
      => per_sps_shd.g_old_rec.information18
      ,p_information19_o
      => per_sps_shd.g_old_rec.information19
      ,p_information20_o
      => per_sps_shd.g_old_rec.information20
      ,p_information21_o
      => per_sps_shd.g_old_rec.information21
      ,p_information22_o
      => per_sps_shd.g_old_rec.information22
      ,p_information23_o
      => per_sps_shd.g_old_rec.information23
      ,p_information24_o
      => per_sps_shd.g_old_rec.information24
      ,p_information25_o
      => per_sps_shd.g_old_rec.information25
      ,p_information26_o
      => per_sps_shd.g_old_rec.information26
      ,p_information27_o
      => per_sps_shd.g_old_rec.information27
      ,p_information28_o
      => per_sps_shd.g_old_rec.information28
      ,p_information29_o
      => per_sps_shd.g_old_rec.information29
      ,p_information30_o
      => per_sps_shd.g_old_rec.information30
      ,p_information_category_o
      => per_sps_shd.g_old_rec.information_category
      ,p_object_version_number_o
      => per_sps_shd.g_old_rec.object_version_number
      );

Line: 469


End post_delete;

Line: 492


  per_sps_bus.chk_delete
    (p_step_id              => p_rec.step_id
    ,p_spinal_point_id      => p_rec.spinal_point_id
    ,p_grade_spine_id       => p_rec.grade_spine_id
    ,p_effective_date       => p_effective_date
    ,p_datetrack_mode       => p_datetrack_mode
    ,p_called_from_del_grd_scale  => p_called_from_del_grd_scale -- bug 4096238
    );

Line: 513


  per_sps_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
    ,p_called_from_del_grd_scale        => p_called_from_del_grd_scale --bug 4096238
    );

Line: 527


  per_sps_del.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: 537


  per_sps_del.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: 546


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