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.PAY_ACTION_INFORMATION_API SQL Statements

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

Line: 308


procedure update_action_information
  (p_validate                       in     boolean   default false
  ,p_action_information_id          in     number
  ,p_object_version_number          in out nocopy number
  ,p_action_information1            in     varchar2  default hr_api.g_varchar2
  ,p_action_information2            in     varchar2  default hr_api.g_varchar2
  ,p_action_information3            in     varchar2  default hr_api.g_varchar2
  ,p_action_information4            in     varchar2  default hr_api.g_varchar2
  ,p_action_information5            in     varchar2  default hr_api.g_varchar2
  ,p_action_information6            in     varchar2  default hr_api.g_varchar2
  ,p_action_information7            in     varchar2  default hr_api.g_varchar2
  ,p_action_information8            in     varchar2  default hr_api.g_varchar2
  ,p_action_information9            in     varchar2  default hr_api.g_varchar2
  ,p_action_information10           in     varchar2  default hr_api.g_varchar2
  ,p_action_information11           in     varchar2  default hr_api.g_varchar2
  ,p_action_information12           in     varchar2  default hr_api.g_varchar2
  ,p_action_information13           in     varchar2  default hr_api.g_varchar2
  ,p_action_information14           in     varchar2  default hr_api.g_varchar2
  ,p_action_information15           in     varchar2  default hr_api.g_varchar2
  ,p_action_information16           in     varchar2  default hr_api.g_varchar2
  ,p_action_information17           in     varchar2  default hr_api.g_varchar2
  ,p_action_information18           in     varchar2  default hr_api.g_varchar2
  ,p_action_information19           in     varchar2  default hr_api.g_varchar2
  ,p_action_information20           in     varchar2  default hr_api.g_varchar2
  ,p_action_information21           in     varchar2  default hr_api.g_varchar2
  ,p_action_information22           in     varchar2  default hr_api.g_varchar2
  ,p_action_information23           in     varchar2  default hr_api.g_varchar2
  ,p_action_information24           in     varchar2  default hr_api.g_varchar2
  ,p_action_information25           in     varchar2  default hr_api.g_varchar2
  ,p_action_information26           in     varchar2  default hr_api.g_varchar2
  ,p_action_information27           in     varchar2  default hr_api.g_varchar2
  ,p_action_information28           in     varchar2  default hr_api.g_varchar2
  ,p_action_information29           in     varchar2  default hr_api.g_varchar2
  ,p_action_information30           in     varchar2  default hr_api.g_varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                  varchar2(72);

Line: 353


     l_proc := g_package||'update_action_information';

Line: 359


  savepoint update_action_information;

Line: 373


    pay_action_information_bk2.update_action_information_b
      (
       p_action_information_id          =>  p_action_information_id
      ,p_object_version_number          =>  p_object_version_number
      ,p_action_information1            =>  p_action_information1
      ,p_action_information2            =>  p_action_information2
      ,p_action_information3            =>  p_action_information3
      ,p_action_information4            =>  p_action_information4
      ,p_action_information5            =>  p_action_information5
      ,p_action_information6            =>  p_action_information6
      ,p_action_information7            =>  p_action_information7
      ,p_action_information8            =>  p_action_information8
      ,p_action_information9            =>  p_action_information9
      ,p_action_information10           =>  p_action_information10
      ,p_action_information11           =>  p_action_information11
      ,p_action_information12           =>  p_action_information12
      ,p_action_information13           =>  p_action_information13
      ,p_action_information14           =>  p_action_information14
      ,p_action_information15           =>  p_action_information15
      ,p_action_information16           =>  p_action_information16
      ,p_action_information17           =>  p_action_information17
      ,p_action_information18           =>  p_action_information18
      ,p_action_information19           =>  p_action_information19
      ,p_action_information20           =>  p_action_information20
      ,p_action_information21           =>  p_action_information21
      ,p_action_information22           =>  p_action_information22
      ,p_action_information23           =>  p_action_information23
      ,p_action_information24           =>  p_action_information24
      ,p_action_information25           =>  p_action_information25
      ,p_action_information26           =>  p_action_information26
      ,p_action_information27           =>  p_action_information27
      ,p_action_information28           =>  p_action_information28
      ,p_action_information29           =>  p_action_information29
      ,p_action_information30           =>  p_action_information30
      );

Line: 411


        (p_module_name => 'UPDATE_action_information'
        ,p_hook_type   => 'BP'
        );

Line: 459


    pay_action_information_bk2.update_action_information_a
      (
       p_action_information_id          =>  p_action_information_id
      ,p_object_version_number          =>  l_object_version_number
      ,p_action_information1            =>  p_action_information1
      ,p_action_information2            =>  p_action_information2
      ,p_action_information3            =>  p_action_information3
      ,p_action_information4            =>  p_action_information4
      ,p_action_information5            =>  p_action_information5
      ,p_action_information6            =>  p_action_information6
      ,p_action_information7            =>  p_action_information7
      ,p_action_information8            =>  p_action_information8
      ,p_action_information9            =>  p_action_information9
      ,p_action_information10           =>  p_action_information10
      ,p_action_information11           =>  p_action_information11
      ,p_action_information12           =>  p_action_information12
      ,p_action_information13           =>  p_action_information13
      ,p_action_information14           =>  p_action_information14
      ,p_action_information15           =>  p_action_information15
      ,p_action_information16           =>  p_action_information16
      ,p_action_information17           =>  p_action_information17
      ,p_action_information18           =>  p_action_information18
      ,p_action_information19           =>  p_action_information19
      ,p_action_information20           =>  p_action_information20
      ,p_action_information21           =>  p_action_information21
      ,p_action_information22           =>  p_action_information22
      ,p_action_information23           =>  p_action_information23
      ,p_action_information24           =>  p_action_information24
      ,p_action_information25           =>  p_action_information25
      ,p_action_information26           =>  p_action_information26
      ,p_action_information27           =>  p_action_information27
      ,p_action_information28           =>  p_action_information28
      ,p_action_information29           =>  p_action_information29
      ,p_action_information30           =>  p_action_information30
      );

Line: 497


        (p_module_name => 'UPDATE_action_information'
        ,p_hook_type   => 'AP'
        );

Line: 530


    ROLLBACK TO update_action_information;

Line: 544


    ROLLBACK TO update_action_information;

Line: 548


end update_action_information;

Line: 553


procedure delete_action_information
  (p_validate                       in     boolean  default false
  ,p_action_information_id          in     number
  ,p_object_version_number          in out nocopy number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72);

Line: 568


     l_proc := g_package||'update_action_information';

Line: 574


  savepoint delete_action_information;

Line: 589


    pay_action_information_bk3.delete_action_information_b
      (
       p_action_information_id          =>  p_action_information_id
      ,p_object_version_number          =>  p_object_version_number
      );

Line: 597


        (p_module_name => 'DELETE_action_information'
        ,p_hook_type   => 'BP'
        );

Line: 615


    pay_action_information_bk3.delete_action_information_a
      (
       p_action_information_id          =>  p_action_information_id
      ,p_object_version_number          =>  l_object_version_number
      );

Line: 623


        (p_module_name => 'DELETE_action_information'
        ,p_hook_type   => 'AP'
        );

Line: 652


    ROLLBACK TO delete_action_information;

Line: 663


    ROLLBACK TO delete_action_information;

Line: 667


end delete_action_information;