DBA Data[Home] [Help]

APPS.PER_PTU_UPD SQL Statements

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

Line: 51

Procedure dt_update_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_update_dml';
Line: 78

    update  per_person_type_usages_f
    set
        person_type_usage_id            = p_rec.person_type_usage_id,
    person_id                       = p_rec.person_id,
    person_type_id                  = p_rec.person_type_id,
    object_version_number           = p_rec.object_version_number,
    request_id                      = p_rec.request_id,
    program_application_id          = p_rec.program_application_id,
    program_id                      = p_rec.program_id,
    program_update_date             = p_rec.program_update_date,
    attribute_category              = p_rec.attribute_category,
    attribute1                      = p_rec.attribute1,
    attribute2                      = p_rec.attribute2,
    attribute3                      = p_rec.attribute3,
    attribute4                      = p_rec.attribute4,
    attribute5                      = p_rec.attribute5,
    attribute6                      = p_rec.attribute6,
    attribute7                      = p_rec.attribute7,
    attribute8                      = p_rec.attribute8,
    attribute9                      = p_rec.attribute9,
    attribute10                     = p_rec.attribute10,
    attribute11                     = p_rec.attribute11,
    attribute12                     = p_rec.attribute12,
    attribute13                     = p_rec.attribute13,
    attribute14                     = p_rec.attribute14,
    attribute15                     = p_rec.attribute15,
    attribute16                     = p_rec.attribute16,
    attribute17                     = p_rec.attribute17,
    attribute18                     = p_rec.attribute18,
    attribute19                     = p_rec.attribute19,
    attribute20                     = p_rec.attribute20,
    attribute21                     = p_rec.attribute21,
    attribute22                     = p_rec.attribute22,
    attribute23                     = p_rec.attribute23,
    attribute24                     = p_rec.attribute24,
    attribute25                     = p_rec.attribute25,
    attribute26                     = p_rec.attribute26,
    attribute27                     = p_rec.attribute27,
    attribute28                     = p_rec.attribute28,
    attribute29                     = p_rec.attribute29,
    attribute30                     = p_rec.attribute30
    where   person_type_usage_id = p_rec.person_type_usage_id
    and     effective_start_date = p_validation_start_date
    and     effective_end_date   = p_validation_end_date;
Line: 142

End dt_update_dml;
Line: 175

Procedure update_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||'update_dml';
Line: 187

  dt_update_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: 194

End update_dml;
Line: 239

Procedure dt_pre_update
   (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_update';
Line: 264

    If (p_datetrack_mode = 'UPDATE_OVERRIDE') then
      hr_utility.set_location(l_proc, 15);
Line: 270

      per_ptu_del.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: 281

    per_ptu_ins.insert_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: 289

End dt_pre_update;
Line: 324

Procedure pre_update
   (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_update';
Line: 338

  dt_pre_update
    (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: 346

End pre_update;
Line: 380

Procedure post_update
   (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_update';
Line: 403

    per_ptu_rku.after_update
          (
           p_person_type_usage_id  => p_rec.person_type_usage_id,
           p_person_type_id        => p_rec.person_type_id,
           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,
           p_request_id             => p_rec.request_id,
           p_program_application_id  => p_rec.program_application_id,
           p_program_id              => p_rec.program_id,
           p_program_update_date     => p_rec.program_update_date,
           p_attribute_category      => p_rec.attribute_category
          ,p_attribute1          => p_rec.attribute1
     ,p_attribute2          => p_rec.attribute2
     ,p_attribute3          => p_rec.attribute3
     ,p_attribute4          => p_rec.attribute4
     ,p_attribute5          => p_rec.attribute5
     ,p_attribute6          => p_rec.attribute6
     ,p_attribute7          => p_rec.attribute7
     ,p_attribute8          => p_rec.attribute8
     ,p_attribute9          => p_rec.attribute9
     ,p_attribute10         => p_rec.attribute10
     ,p_attribute11         => p_rec.attribute11
     ,p_attribute12         => p_rec.attribute12
     ,p_attribute13         => p_rec.attribute13
     ,p_attribute14         => p_rec.attribute14
     ,p_attribute15         => p_rec.attribute15
     ,p_attribute16         => p_rec.attribute16
     ,p_attribute17         => p_rec.attribute17
     ,p_attribute18         => p_rec.attribute18
     ,p_attribute19         => p_rec.attribute19
     ,p_attribute20         => p_rec.attribute20
     ,p_attribute21         => p_rec.attribute21
     ,p_attribute22         => p_rec.attribute22
     ,p_attribute23         => p_rec.attribute23
     ,p_attribute24         => p_rec.attribute24
     ,p_attribute25         => p_rec.attribute25
     ,p_attribute26         => p_rec.attribute26
     ,p_attribute27         => p_rec.attribute27
     ,p_attribute28         => p_rec.attribute28
     ,p_attribute29         => p_rec.attribute29
     ,p_attribute30         => p_rec.attribute30
          ,p_effective_date    => p_effective_date
          ,p_validation_start_date => p_validation_start_date
          ,p_validation_end_date   => p_validation_end_date
          ,p_datetrack_mode        => p_datetrack_mode
          ,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
      );
Line: 523

End post_update;
Line: 601

  If (p_rec.program_update_date = hr_api.g_date) then
    p_rec.program_update_date :=
    per_ptu_shd.g_old_rec.program_update_date;
Line: 772

  per_ptu_bus.update_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: 781

  pre_update
   (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: 790

  update_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: 799

  post_update
   (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: 820

  p_program_update_date          in date             default hr_api.g_date,
  p_attribute_category           in varchar2         default hr_api.g_varchar2,
  p_attribute1                   in varchar2         default hr_api.g_varchar2,
  p_attribute2                   in varchar2         default hr_api.g_varchar2,
  p_attribute3                   in varchar2         default hr_api.g_varchar2,
  p_attribute4                   in varchar2         default hr_api.g_varchar2,
  p_attribute5                   in varchar2         default hr_api.g_varchar2,
  p_attribute6                   in varchar2         default hr_api.g_varchar2,
  p_attribute7                   in varchar2         default hr_api.g_varchar2,
  p_attribute8                   in varchar2         default hr_api.g_varchar2,
  p_attribute9                   in varchar2         default hr_api.g_varchar2,
  p_attribute10                  in varchar2         default hr_api.g_varchar2,
  p_attribute11                  in varchar2         default hr_api.g_varchar2,
  p_attribute12                  in varchar2         default hr_api.g_varchar2,
  p_attribute13                  in varchar2         default hr_api.g_varchar2,
  p_attribute14                  in varchar2         default hr_api.g_varchar2,
  p_attribute15                  in varchar2         default hr_api.g_varchar2,
  p_attribute16                  in varchar2         default hr_api.g_varchar2,
  p_attribute17                  in varchar2         default hr_api.g_varchar2,
  p_attribute18                  in varchar2         default hr_api.g_varchar2,
  p_attribute19                  in varchar2         default hr_api.g_varchar2,
  p_attribute20                  in varchar2         default hr_api.g_varchar2,
  p_attribute21                  in varchar2         default hr_api.g_varchar2,
  p_attribute22                  in varchar2         default hr_api.g_varchar2,
  p_attribute23                  in varchar2         default hr_api.g_varchar2,
  p_attribute24                  in varchar2         default hr_api.g_varchar2,
  p_attribute25                  in varchar2         default hr_api.g_varchar2,
  p_attribute26                  in varchar2         default hr_api.g_varchar2,
  p_attribute27                  in varchar2         default hr_api.g_varchar2,
  p_attribute28                  in varchar2         default hr_api.g_varchar2,
  p_attribute29                  in varchar2         default hr_api.g_varchar2,
  p_attribute30                  in varchar2         default hr_api.g_varchar2,
  p_effective_date       in date,
  p_datetrack_mode       in varchar2
  ) is
--
  l_rec     per_ptu_shd.g_rec_type;
Line: 877

  p_program_update_date,
  p_attribute_category,
  p_attribute1,
  p_attribute2,
  p_attribute3,
  p_attribute4,
  p_attribute5,
  p_attribute6,
  p_attribute7,
  p_attribute8,
  p_attribute9,
  p_attribute10,
  p_attribute11,
  p_attribute12,
  p_attribute13,
  p_attribute14,
  p_attribute15,
  p_attribute16,
  p_attribute17,
  p_attribute18,
  p_attribute19,
  p_attribute20,
  p_attribute21,
  p_attribute22,
  p_attribute23,
  p_attribute24,
  p_attribute25,
  p_attribute26,
  p_attribute27,
  p_attribute28,
  p_attribute29,
  p_attribute30
  );