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

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

Line: 54


Procedure update_dml
  (p_rec in out nocopy per_pji_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'update_dml';

Line: 68


  update per_prev_job_extra_info
    set
     previous_job_extra_info_id      = p_rec.previous_job_extra_info_id
    ,previous_job_id                 = p_rec.previous_job_id
    ,information_type                = p_rec.information_type
    ,pji_attribute_category          = p_rec.pji_attribute_category
    ,pji_attribute1                  = p_rec.pji_attribute1
    ,pji_attribute2                  = p_rec.pji_attribute2
    ,pji_attribute3                  = p_rec.pji_attribute3
    ,pji_attribute4                  = p_rec.pji_attribute4
    ,pji_attribute5                  = p_rec.pji_attribute5
    ,pji_attribute6                  = p_rec.pji_attribute6
    ,pji_attribute7                  = p_rec.pji_attribute7
    ,pji_attribute8                  = p_rec.pji_attribute8
    ,pji_attribute9                  = p_rec.pji_attribute9
    ,pji_attribute10                 = p_rec.pji_attribute10
    ,pji_attribute11                 = p_rec.pji_attribute11
    ,pji_attribute12                 = p_rec.pji_attribute12
    ,pji_attribute13                 = p_rec.pji_attribute13
    ,pji_attribute14                 = p_rec.pji_attribute14
    ,pji_attribute15                 = p_rec.pji_attribute15
    ,pji_attribute16                 = p_rec.pji_attribute16
    ,pji_attribute17                 = p_rec.pji_attribute17
    ,pji_attribute18                 = p_rec.pji_attribute18
    ,pji_attribute19                 = p_rec.pji_attribute19
    ,pji_attribute20                 = p_rec.pji_attribute20
    ,pji_attribute21                 = p_rec.pji_attribute21
    ,pji_attribute22                 = p_rec.pji_attribute22
    ,pji_attribute23                 = p_rec.pji_attribute23
    ,pji_attribute24                 = p_rec.pji_attribute24
    ,pji_attribute25                 = p_rec.pji_attribute25
    ,pji_attribute26                 = p_rec.pji_attribute26
    ,pji_attribute27                 = p_rec.pji_attribute27
    ,pji_attribute28                 = p_rec.pji_attribute28
    ,pji_attribute29                 = p_rec.pji_attribute29
    ,pji_attribute30                 = p_rec.pji_attribute30
    ,pji_information_category        = p_rec.pji_information_category
    ,pji_information1                = p_rec.pji_information1
    ,pji_information2                = p_rec.pji_information2
    ,pji_information3                = p_rec.pji_information3
    ,pji_information4                = p_rec.pji_information4
    ,pji_information5                = p_rec.pji_information5
    ,pji_information6                = p_rec.pji_information6
    ,pji_information7                = p_rec.pji_information7
    ,pji_information8                = p_rec.pji_information8
    ,pji_information9                = p_rec.pji_information9
    ,pji_information10               = p_rec.pji_information10
    ,pji_information11               = p_rec.pji_information11
    ,pji_information12               = p_rec.pji_information12
    ,pji_information13               = p_rec.pji_information13
    ,pji_information14               = p_rec.pji_information14
    ,pji_information15               = p_rec.pji_information15
    ,pji_information16               = p_rec.pji_information16
    ,pji_information17               = p_rec.pji_information17
    ,pji_information18               = p_rec.pji_information18
    ,pji_information19               = p_rec.pji_information19
    ,pji_information20               = p_rec.pji_information20
    ,pji_information21               = p_rec.pji_information21
    ,pji_information22               = p_rec.pji_information22
    ,pji_information23               = p_rec.pji_information23
    ,pji_information24               = p_rec.pji_information24
    ,pji_information25               = p_rec.pji_information25
    ,pji_information26               = p_rec.pji_information26
    ,pji_information27               = p_rec.pji_information27
    ,pji_information28               = p_rec.pji_information28
    ,pji_information29               = p_rec.pji_information29
    ,pji_information30               = p_rec.pji_information30
    ,object_version_number           = p_rec.object_version_number
    where previous_job_extra_info_id = p_rec.previous_job_extra_info_id;

Line: 161


End update_dml;

Line: 195


Procedure pre_update
  (p_rec in per_pji_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'pre_update';

Line: 205


End pre_update;

Line: 239


Procedure post_update
  (p_rec                          in per_pji_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'post_update';

Line: 249


    per_pji_rku.after_update
      (p_previous_job_extra_info_id
      => p_rec.previous_job_extra_info_id
      ,p_previous_job_id
      => p_rec.previous_job_id
      ,p_information_type
      => p_rec.information_type
      ,p_pji_attribute_category
      => p_rec.pji_attribute_category
      ,p_pji_attribute1
      => p_rec.pji_attribute1
      ,p_pji_attribute2
      => p_rec.pji_attribute2
      ,p_pji_attribute3
      => p_rec.pji_attribute3
      ,p_pji_attribute4
      => p_rec.pji_attribute4
      ,p_pji_attribute5
      => p_rec.pji_attribute5
      ,p_pji_attribute6
      => p_rec.pji_attribute6
      ,p_pji_attribute7
      => p_rec.pji_attribute7
      ,p_pji_attribute8
      => p_rec.pji_attribute8
      ,p_pji_attribute9
      => p_rec.pji_attribute9
      ,p_pji_attribute10
      => p_rec.pji_attribute10
      ,p_pji_attribute11
      => p_rec.pji_attribute11
      ,p_pji_attribute12
      => p_rec.pji_attribute12
      ,p_pji_attribute13
      => p_rec.pji_attribute13
      ,p_pji_attribute14
      => p_rec.pji_attribute14
      ,p_pji_attribute15
      => p_rec.pji_attribute15
      ,p_pji_attribute16
      => p_rec.pji_attribute16
      ,p_pji_attribute17
      => p_rec.pji_attribute17
      ,p_pji_attribute18
      => p_rec.pji_attribute18
      ,p_pji_attribute19
      => p_rec.pji_attribute19
      ,p_pji_attribute20
      => p_rec.pji_attribute20
      ,p_pji_attribute21
      => p_rec.pji_attribute21
      ,p_pji_attribute22
      => p_rec.pji_attribute22
      ,p_pji_attribute23
      => p_rec.pji_attribute23
      ,p_pji_attribute24
      => p_rec.pji_attribute24
      ,p_pji_attribute25
      => p_rec.pji_attribute25
      ,p_pji_attribute26
      => p_rec.pji_attribute26
      ,p_pji_attribute27
      => p_rec.pji_attribute27
      ,p_pji_attribute28
      => p_rec.pji_attribute28
      ,p_pji_attribute29
      => p_rec.pji_attribute29
      ,p_pji_attribute30
      => p_rec.pji_attribute30
      ,p_pji_information_category
      => p_rec.pji_information_category
      ,p_pji_information1
      => p_rec.pji_information1
      ,p_pji_information2
      => p_rec.pji_information2
      ,p_pji_information3
      => p_rec.pji_information3
      ,p_pji_information4
      => p_rec.pji_information4
      ,p_pji_information5
      => p_rec.pji_information5
      ,p_pji_information6
      => p_rec.pji_information6
      ,p_pji_information7
      => p_rec.pji_information7
      ,p_pji_information8
      => p_rec.pji_information8
      ,p_pji_information9
      => p_rec.pji_information9
      ,p_pji_information10
      => p_rec.pji_information10
      ,p_pji_information11
      => p_rec.pji_information11
      ,p_pji_information12
      => p_rec.pji_information12
      ,p_pji_information13
      => p_rec.pji_information13
      ,p_pji_information14
      => p_rec.pji_information14
      ,p_pji_information15
      => p_rec.pji_information15
      ,p_pji_information16
      => p_rec.pji_information16
      ,p_pji_information17
      => p_rec.pji_information17
      ,p_pji_information18
      => p_rec.pji_information18
      ,p_pji_information19
      => p_rec.pji_information19
      ,p_pji_information20
      => p_rec.pji_information20
      ,p_pji_information21
      => p_rec.pji_information21
      ,p_pji_information22
      => p_rec.pji_information22
      ,p_pji_information23
      => p_rec.pji_information23
      ,p_pji_information24
      => p_rec.pji_information24
      ,p_pji_information25
      => p_rec.pji_information25
      ,p_pji_information26
      => p_rec.pji_information26
      ,p_pji_information27
      => p_rec.pji_information27
      ,p_pji_information28
      => p_rec.pji_information28
      ,p_pji_information29
      => p_rec.pji_information29
      ,p_pji_information30
      => p_rec.pji_information30
      ,p_object_version_number
      => p_rec.object_version_number
      );

Line: 395


End post_update;

Line: 736


  per_pji_bus.update_validate
     (p_rec
     );

Line: 742


  per_pji_upd.pre_update(p_rec);

Line: 746


  per_pji_upd.update_dml(p_rec);

Line: 750


  per_pji_upd.post_update
     (p_rec
     );