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_PSP_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_psp_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'update_dml';

Line: 70


  update per_spinal_points
    set
     spinal_point_id                 = p_rec.spinal_point_id
    ,business_group_id               = p_rec.business_group_id
    ,parent_spine_id                 = p_rec.parent_spine_id
    ,sequence                        = p_rec.sequence
    ,spinal_point                    = p_rec.spinal_point
    ,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
    ,object_version_number           = p_rec.object_version_number
    ,information_category              = p_rec.information_category
    ,information1                      = p_rec.information1
    ,information2                      = p_rec.information2
    ,information3                      = p_rec.information3
    ,information4                      = p_rec.information4
    ,information5                      = p_rec.information5
    ,information6                      = p_rec.information6
    ,information7                      = p_rec.information7
    ,information8                      = p_rec.information8
    ,information9                      = p_rec.information9
    ,information10                     = p_rec.information10
    ,information11                     = p_rec.information11
    ,information12                     = p_rec.information12
    ,information13                     = p_rec.information13
    ,information14                     = p_rec.information14
    ,information15                     = p_rec.information15
    ,information16                     = p_rec.information16
    ,information17                     = p_rec.information17
    ,information18                     = p_rec.information18
    ,information19                     = p_rec.information19
    ,information20                     = p_rec.information20
    ,information21                     = p_rec.information21
    ,information22                     = p_rec.information22
    ,information23                     = p_rec.information23
    ,information24                     = p_rec.information24
    ,information25                     = p_rec.information25
    ,information26                     = p_rec.information26
    ,information27                     = p_rec.information27
    ,information28                     = p_rec.information28
    ,information29                     = p_rec.information29
    ,information30                     = p_rec.information30
    where spinal_point_id = p_rec.spinal_point_id;

Line: 138


End update_dml;

Line: 172


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

Line: 182


End pre_update;

Line: 216


Procedure post_update
  (p_effective_date               in date
  ,p_rec                          in per_psp_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'post_update';

Line: 227


    per_psp_rku.after_update
      (p_effective_date              => p_effective_date
      ,p_spinal_point_id
      => p_rec.spinal_point_id
      ,p_business_group_id
      => p_rec.business_group_id
      ,p_parent_spine_id
      => p_rec.parent_spine_id
      ,p_sequence
      => p_rec.sequence
      ,p_spinal_point
      => p_rec.spinal_point
      ,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_object_version_number
      => p_rec.object_version_number
      ,p_information_category
      => p_rec.information_category
      ,p_information1
      => p_rec.information1
      ,p_information2
      => p_rec.information2
      ,p_information3
      => p_rec.information3
      ,p_information4
      => p_rec.information4
      ,p_information5
      => p_rec.information5
      ,p_information6
      => p_rec.information6
      ,p_information7
      => p_rec.information7
      ,p_information8
      => p_rec.information8
      ,p_information9
      => p_rec.information9
      ,p_information10
      => p_rec.information10
      ,p_information11
      => p_rec.information11
      ,p_information12
      => p_rec.information12
      ,p_information13
      => p_rec.information13
      ,p_information14
      => p_rec.information14
      ,p_information15
      => p_rec.information15
      ,p_information16
      => p_rec.information16
      ,p_information17
      => p_rec.information17
      ,p_information18
      => p_rec.information18
      ,p_information19
      => p_rec.information19
      ,p_information20
      => p_rec.information20
      ,p_information21
      => p_rec.information21
      ,p_information22
      => p_rec.information22
      ,p_information23
      => p_rec.information23
      ,p_information24
      => p_rec.information24
      ,p_information25
      => p_rec.information25
      ,p_information26
      => p_rec.information26
      ,p_information27
      => p_rec.information27
      ,p_information28
      => p_rec.information28
      ,p_information29
      => p_rec.information29
      ,p_information30
      => p_rec.information30
      ,p_business_group_id_o
      => per_psp_shd.g_old_rec.business_group_id
      ,p_parent_spine_id_o
      => per_psp_shd.g_old_rec.parent_spine_id
      ,p_sequence_o
      => per_psp_shd.g_old_rec.sequence
      ,p_spinal_point_o
      => per_psp_shd.g_old_rec.spinal_point
      ,p_request_id_o
      => per_psp_shd.g_old_rec.request_id
      ,p_program_application_id_o
      => per_psp_shd.g_old_rec.program_application_id
      ,p_program_id_o
      => per_psp_shd.g_old_rec.program_id
      ,p_program_update_date_o
      => per_psp_shd.g_old_rec.program_update_date
      ,p_object_version_number_o
      => per_psp_shd.g_old_rec.object_version_number
      ,p_information_category_o
      => per_psp_shd.g_old_rec.information_category
      ,p_information1_o
      => per_psp_shd.g_old_rec.information1
      ,p_information2_o
      => per_psp_shd.g_old_rec.information2
      ,p_information3_o
      => per_psp_shd.g_old_rec.information3
      ,p_information4_o
      => per_psp_shd.g_old_rec.information4
      ,p_information5_o
      => per_psp_shd.g_old_rec.information5
      ,p_information6_o
      => per_psp_shd.g_old_rec.information6
      ,p_information7_o
      => per_psp_shd.g_old_rec.information7
      ,p_information8_o
      => per_psp_shd.g_old_rec.information8
      ,p_information9_o
      => per_psp_shd.g_old_rec.information9
      ,p_information10_o
      => per_psp_shd.g_old_rec.information10
      ,p_information11_o
      => per_psp_shd.g_old_rec.information11
      ,p_information12_o
      => per_psp_shd.g_old_rec.information12
      ,p_information13_o
      => per_psp_shd.g_old_rec.information13
      ,p_information14_o
      => per_psp_shd.g_old_rec.information14
      ,p_information15_o
      => per_psp_shd.g_old_rec.information15
      ,p_information16_o
      => per_psp_shd.g_old_rec.information16
      ,p_information17_o
      => per_psp_shd.g_old_rec.information17
      ,p_information18_o
      => per_psp_shd.g_old_rec.information18
      ,p_information19_o
      => per_psp_shd.g_old_rec.information19
      ,p_information20_o
      => per_psp_shd.g_old_rec.information20
      ,p_information21_o
      => per_psp_shd.g_old_rec.information21
      ,p_information22_o
      => per_psp_shd.g_old_rec.information22
      ,p_information23_o
      => per_psp_shd.g_old_rec.information23
      ,p_information24_o
      => per_psp_shd.g_old_rec.information24
      ,p_information25_o
      => per_psp_shd.g_old_rec.information25
      ,p_information26_o
      => per_psp_shd.g_old_rec.information26
      ,p_information27_o
      => per_psp_shd.g_old_rec.information27
      ,p_information28_o
      => per_psp_shd.g_old_rec.information28
      ,p_information29_o
      => per_psp_shd.g_old_rec.information29
      ,p_information30_o
      => per_psp_shd.g_old_rec.information30
      );

Line: 404


End post_update;

Line: 488


  If (p_rec.program_update_date = hr_api.g_date) then
    p_rec.program_update_date :=
    per_psp_shd.g_old_rec.program_update_date;

Line: 647


  per_psp_bus.update_validate
     (p_effective_date
     ,p_rec
     );

Line: 657


  per_psp_upd.pre_update(p_rec);

Line: 661


  per_psp_upd.update_dml(p_rec);

Line: 665


  per_psp_upd.post_update
     (p_effective_date
     ,p_rec
     );

Line: 688


  ,p_program_update_date          in     date      default hr_api.g_date
  ,p_information_category          in     varchar2 default hr_api.g_varchar2
  ,p_information1                  in     varchar2 default hr_api.g_varchar2
  ,p_information2                  in     varchar2 default hr_api.g_varchar2
  ,p_information3                  in     varchar2 default hr_api.g_varchar2
  ,p_information4                  in     varchar2 default hr_api.g_varchar2
  ,p_information5                  in     varchar2 default hr_api.g_varchar2
  ,p_information6                  in     varchar2 default hr_api.g_varchar2
  ,p_information7                  in     varchar2 default hr_api.g_varchar2
  ,p_information8                  in     varchar2 default hr_api.g_varchar2
  ,p_information9                  in     varchar2 default hr_api.g_varchar2
  ,p_information10                 in     varchar2 default hr_api.g_varchar2
  ,p_information11                 in     varchar2 default hr_api.g_varchar2
  ,p_information12                 in     varchar2 default hr_api.g_varchar2
  ,p_information13                 in     varchar2 default hr_api.g_varchar2
  ,p_information14                 in     varchar2 default hr_api.g_varchar2
  ,p_information15                 in     varchar2 default hr_api.g_varchar2
  ,p_information16                 in     varchar2 default hr_api.g_varchar2
  ,p_information17                 in     varchar2 default hr_api.g_varchar2
  ,p_information18                 in     varchar2 default hr_api.g_varchar2
  ,p_information19                 in     varchar2 default hr_api.g_varchar2
  ,p_information20                 in     varchar2 default hr_api.g_varchar2
  ,p_information21                 in     varchar2 default hr_api.g_varchar2
  ,p_information22                 in     varchar2 default hr_api.g_varchar2
  ,p_information23                 in     varchar2 default hr_api.g_varchar2
  ,p_information24                 in     varchar2 default hr_api.g_varchar2
  ,p_information25                 in     varchar2 default hr_api.g_varchar2
  ,p_information26                 in     varchar2 default hr_api.g_varchar2
  ,p_information27                 in     varchar2 default hr_api.g_varchar2
  ,p_information28                 in     varchar2 default hr_api.g_varchar2
  ,p_information29                 in     varchar2 default hr_api.g_varchar2
  ,p_information30                 in     varchar2 default hr_api.g_varchar2
  ) is
--
  l_rec   per_psp_shd.g_rec_type;

Line: 741


  ,p_program_update_date
  ,p_object_version_number
    ,p_information_category
    ,p_information1
    ,p_information2
    ,p_information3
    ,p_information4
    ,p_information5
    ,p_information6
    ,p_information7
    ,p_information8
    ,p_information9
    ,p_information10
    ,p_information11
    ,p_information12
    ,p_information13
    ,p_information14
    ,p_information15
    ,p_information16
    ,p_information17
    ,p_information18
    ,p_information19
    ,p_information20
    ,p_information21
    ,p_information22
    ,p_information23
    ,p_information24
    ,p_information25
    ,p_information26
    ,p_information27
    ,p_information28
    ,p_information29
    ,p_information30
  );