APPS.PER_PTU_DEL SQL Statements

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

Line: 47

Procedure dt_delete_dml
   (p_rec          in out nocopy per_ptu_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: 58

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

Line: 64

    delete from per_person_type_usages_f
    where       person_type_usage_id = p_rec.person_type_usage_id
    and    effective_start_date = p_validation_start_date;

Line: 74

    delete from per_person_type_usages_f
    where        person_type_usage_id = p_rec.person_type_usage_id
    and    effective_start_date >= p_validation_start_date;

Line: 85

End dt_delete_dml;

Line: 90

Procedure delete_dml
   (p_rec          in out nocopy per_ptu_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: 102

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

End delete_dml;

Line: 144

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

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

Line: 180

End dt_pre_delete;

Line: 215

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

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

End pre_delete;

Line: 273

Procedure post_delete
   (p_rec          in per_ptu_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: 288

    per_ptu_rkd.after_delete
      (
           p_person_type_usage_id   => p_rec.person_type_usage_id,
           p_person_id_o        => per_ptu_shd.g_old_rec.person_id,
           p_person_type_id_o    => per_ptu_shd.g_old_rec.person_type_id,
           p_effective_start_date_o
                         => per_ptu_shd.g_old_rec.effective_start_date,
           p_effective_end_date_o => per_ptu_shd.g_old_rec.effective_end_date,
           p_object_version_number_o
                         => per_ptu_shd.g_old_rec.object_version_number,
           p_request_id_o         => per_ptu_shd.g_old_rec.request_id,
           p_program_application_id_o
                      => per_ptu_shd.g_old_rec.program_application_id,
           p_program_id_o     => per_ptu_shd.g_old_rec.program_id,
           p_program_update_date_o => per_ptu_shd.g_old_rec.program_update_date
     ,p_attribute_category_o  => per_ptu_shd.g_old_rec.attribute_category
     ,p_attribute1_o          => per_ptu_shd.g_old_rec.attribute1
     ,p_attribute2_o          => per_ptu_shd.g_old_rec.attribute2
     ,p_attribute3_o          => per_ptu_shd.g_old_rec.attribute3
     ,p_attribute4_o          => per_ptu_shd.g_old_rec.attribute4
     ,p_attribute5_o          => per_ptu_shd.g_old_rec.attribute5
     ,p_attribute6_o          => per_ptu_shd.g_old_rec.attribute6
     ,p_attribute7_o          => per_ptu_shd.g_old_rec.attribute7
     ,p_attribute8_o          => per_ptu_shd.g_old_rec.attribute8
     ,p_attribute9_o          => per_ptu_shd.g_old_rec.attribute9
     ,p_attribute10_o         => per_ptu_shd.g_old_rec.attribute10
     ,p_attribute11_o         => per_ptu_shd.g_old_rec.attribute11
     ,p_attribute12_o         => per_ptu_shd.g_old_rec.attribute12
     ,p_attribute13_o         => per_ptu_shd.g_old_rec.attribute13
     ,p_attribute14_o         => per_ptu_shd.g_old_rec.attribute14
     ,p_attribute15_o         => per_ptu_shd.g_old_rec.attribute15
     ,p_attribute16_o         => per_ptu_shd.g_old_rec.attribute16
     ,p_attribute17_o         => per_ptu_shd.g_old_rec.attribute17
     ,p_attribute18_o         => per_ptu_shd.g_old_rec.attribute18
     ,p_attribute19_o         => per_ptu_shd.g_old_rec.attribute19
     ,p_attribute20_o         => per_ptu_shd.g_old_rec.attribute20
     ,p_attribute21_o         => per_ptu_shd.g_old_rec.attribute21
     ,p_attribute22_o         => per_ptu_shd.g_old_rec.attribute22
     ,p_attribute23_o         => per_ptu_shd.g_old_rec.attribute23
     ,p_attribute24_o         => per_ptu_shd.g_old_rec.attribute24
     ,p_attribute25_o         => per_ptu_shd.g_old_rec.attribute25
     ,p_attribute26_o         => per_ptu_shd.g_old_rec.attribute26
     ,p_attribute27_o         => per_ptu_shd.g_old_rec.attribute27
     ,p_attribute28_o         => per_ptu_shd.g_old_rec.attribute28
     ,p_attribute29_o         => per_ptu_shd.g_old_rec.attribute29
     ,p_attribute30_o         => per_ptu_shd.g_old_rec.attribute30,
           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_effective_start_date  => p_rec.effective_start_date,
           p_effective_end_date    => p_rec.effective_end_date,
           p_object_version_number => p_rec.object_version_number
      );

Line: 352

End post_delete;

Line: 387

  per_ptu_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: 396

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

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

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