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_PTU_INS SQL Statements

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

Line: 51


Procedure dt_insert_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
--
-- Cursor to select 'old' created AOL who column values
--
  Cursor C_Sel1 Is
    select t.created_by,
           t.creation_date
    from   per_person_type_usages_f t
    where  t.person_type_usage_id       = p_rec.person_type_usage_id
    and    t.effective_start_date =
             per_ptu_shd.g_old_rec.effective_start_date
    and    t.effective_end_date   = (p_validation_start_date - 1);

Line: 69


  l_proc    varchar2(72) := g_package||'dt_insert_dml';

Line: 72


  l_last_update_date    per_person_type_usages_f.last_update_date%TYPE;

Line: 73


  l_last_updated_by     per_person_type_usages_f.last_updated_by%TYPE;

Line: 74


  l_last_update_login   per_person_type_usages_f.last_update_login%TYPE;

Line: 96


  If (p_datetrack_mode <> 'INSERT') then
    hr_utility.set_location(l_proc, 10);

Line: 118


    l_last_update_date   := sysdate;

Line: 119


    l_last_updated_by    := fnd_global.user_id;

Line: 120


    l_last_update_login  := fnd_global.login_id;

Line: 126


  insert into per_person_type_usages_f
  (   person_type_usage_id,
   person_id,
   person_type_id,
   effective_start_date,
   effective_end_date,
   object_version_number,
   request_id,
   program_application_id,
   program_id,
   program_update_date,
   attribute_category,
   attribute1,
   attribute2,
   attribute3,
   attribute4,
   attribute5,
   attribute6,
   attribute7,
   attribute8,
   attribute9,
   attribute10,
   attribute11,
   attribute12,
   attribute13,
   attribute14,
   attribute15,
   attribute16,
   attribute17,
   attribute18,
   attribute19,
   attribute20,
   attribute21,
   attribute22,
   attribute23,
   attribute24,
   attribute25,
   attribute26,
   attribute27,
   attribute28,
   attribute29,
   attribute30,
   created_by,
   creation_date,
   last_update_date,
   last_updated_by,
   last_update_login
  )
  Values
  (   p_rec.person_type_usage_id,
   p_rec.person_id,
   p_rec.person_type_id,
   p_rec.effective_start_date,
   p_rec.effective_end_date,
   p_rec.object_version_number,
   p_rec.request_id,
   p_rec.program_application_id,
   p_rec.program_id,
   p_rec.program_update_date,
   p_rec.attribute_category,
   p_rec.attribute1,
   p_rec.attribute2,
   p_rec.attribute3,
   p_rec.attribute4,
   p_rec.attribute5,
   p_rec.attribute6,
   p_rec.attribute7,
   p_rec.attribute8,
   p_rec.attribute9,
   p_rec.attribute10,
   p_rec.attribute11,
   p_rec.attribute12,
   p_rec.attribute13,
   p_rec.attribute14,
   p_rec.attribute15,
   p_rec.attribute16,
   p_rec.attribute17,
   p_rec.attribute18,
   p_rec.attribute19,
   p_rec.attribute20,
   p_rec.attribute21,
   p_rec.attribute22,
   p_rec.attribute23,
   p_rec.attribute24,
   p_rec.attribute25,
   p_rec.attribute26,
   p_rec.attribute27,
   p_rec.attribute28,
   p_rec.attribute29,
   p_rec.attribute30,
   l_created_by,
   l_creation_date,
   l_last_update_date,
   l_last_updated_by,
   l_last_update_login
  );

Line: 236


End dt_insert_dml;

Line: 241


Procedure insert_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||'insert_dml';

Line: 253


  dt_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: 260


End insert_dml;

Line: 301


Procedure pre_insert
   (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_insert';

Line: 310


  Cursor C_Sel1 is select per_person_type_usages_s.nextval from sys.dual;

Line: 324


End pre_insert;

Line: 358


Procedure post_insert
   (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_insert';

Line: 381


    per_ptu_rki.after_insert
          (
           p_person_type_usage_id  => p_rec.person_type_usage_id,
           p_person_id             => p_rec.person_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 );

Line: 458


End post_insert;

Line: 546


  l_datetrack_mode      varchar2(30) := 'INSERT';

Line: 564


  per_ptu_bus.insert_validate
   (p_rec          => p_rec,
    p_effective_date  => p_effective_date,
    p_datetrack_mode  => l_datetrack_mode,
    p_validation_start_date => l_validation_start_date,
    p_validation_end_date   => l_validation_end_date);

Line: 573


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

Line: 582


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

Line: 591


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

Line: 613


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

Line: 669


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