APPS.PAY_ACTION_INFORMATION_SWI SQL Statements

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

Line: 191

PROCEDURE delete_action_information
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_action_information_id        in     number
  ,p_object_version_number        in out nocopy number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 205

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

Line: 211

  savepoint delete_action_information_swi;

Line: 232

  pay_action_information_api.delete_action_information
    (p_validate                     => l_validate
    ,p_action_information_id        => p_action_information_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 259

    rollback to delete_action_information_swi;

Line: 274

    rollback to delete_action_information_swi;

Line: 285

end delete_action_information;

Line: 289

PROCEDURE update_action_information
  (p_validate                     in     number    default hr_api.g_false_num
  ,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
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 333

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

Line: 339

  savepoint update_action_information_swi;

Line: 360

  pay_action_information_api.update_action_information
    (p_validate                     => l_validate
    ,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: 417

    rollback to update_action_information_swi;

Line: 432

    rollback to update_action_information_swi;

Line: 443

end update_action_information;