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

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

Line: 217


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

Line: 230


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

Line: 236


  savepoint delete_element_extra_info_swi;

Line: 256


  pay_element_eit_mig.delete_element_extra_info
    (p_validate                     => l_validate
    ,p_element_type_extra_info_id   => p_element_type_extra_info_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 283


    rollback to delete_element_extra_info_swi;

Line: 297


    rollback to delete_element_extra_info_swi;

Line: 307


end delete_element_extra_info;

Line: 311


PROCEDURE update_element_extra_info
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_element_type_extra_info_id   in     number
  ,p_object_version_number        in out nocopy number
  ,p_eei_attribute_category       in     varchar2  default hr_api.g_varchar2
  ,p_eei_attribute1               in     varchar2  default hr_api.g_varchar2
  ,p_eei_attribute2               in     varchar2  default hr_api.g_varchar2
  ,p_eei_attribute3               in     varchar2  default hr_api.g_varchar2
  ,p_eei_attribute4               in     varchar2  default hr_api.g_varchar2
  ,p_eei_attribute5               in     varchar2  default hr_api.g_varchar2
  ,p_eei_attribute6               in     varchar2  default hr_api.g_varchar2
  ,p_eei_attribute7               in     varchar2  default hr_api.g_varchar2
  ,p_eei_attribute8               in     varchar2  default hr_api.g_varchar2
  ,p_eei_attribute9               in     varchar2  default hr_api.g_varchar2
  ,p_eei_attribute10              in     varchar2  default hr_api.g_varchar2
  ,p_eei_attribute11              in     varchar2  default hr_api.g_varchar2
  ,p_eei_attribute12              in     varchar2  default hr_api.g_varchar2
  ,p_eei_attribute13              in     varchar2  default hr_api.g_varchar2
  ,p_eei_attribute14              in     varchar2  default hr_api.g_varchar2
  ,p_eei_attribute15              in     varchar2  default hr_api.g_varchar2
  ,p_eei_attribute16              in     varchar2  default hr_api.g_varchar2
  ,p_eei_attribute17              in     varchar2  default hr_api.g_varchar2
  ,p_eei_attribute18              in     varchar2  default hr_api.g_varchar2
  ,p_eei_attribute19              in     varchar2  default hr_api.g_varchar2
  ,p_eei_attribute20              in     varchar2  default hr_api.g_varchar2
  ,p_eei_information_category     in     varchar2  default hr_api.g_varchar2
  ,p_eei_information1             in     varchar2  default hr_api.g_varchar2
  ,p_eei_information2             in     varchar2  default hr_api.g_varchar2
  ,p_eei_information3             in     varchar2  default hr_api.g_varchar2
  ,p_eei_information4             in     varchar2  default hr_api.g_varchar2
  ,p_eei_information5             in     varchar2  default hr_api.g_varchar2
  ,p_eei_information6             in     varchar2  default hr_api.g_varchar2
  ,p_eei_information7             in     varchar2  default hr_api.g_varchar2
  ,p_eei_information8             in     varchar2  default hr_api.g_varchar2
  ,p_eei_information9             in     varchar2  default hr_api.g_varchar2
  ,p_eei_information10            in     varchar2  default hr_api.g_varchar2
  ,p_eei_information11            in     varchar2  default hr_api.g_varchar2
  ,p_eei_information12            in     varchar2  default hr_api.g_varchar2
  ,p_eei_information13            in     varchar2  default hr_api.g_varchar2
  ,p_eei_information14            in     varchar2  default hr_api.g_varchar2
  ,p_eei_information15            in     varchar2  default hr_api.g_varchar2
  ,p_eei_information16            in     varchar2  default hr_api.g_varchar2
  ,p_eei_information17            in     varchar2  default hr_api.g_varchar2
  ,p_eei_information18            in     varchar2  default hr_api.g_varchar2
  ,p_eei_information19            in     varchar2  default hr_api.g_varchar2
  ,p_eei_information20            in     varchar2  default hr_api.g_varchar2
  ,p_eei_information21            in     varchar2  default hr_api.g_varchar2
  ,p_eei_information22            in     varchar2  default hr_api.g_varchar2
  ,p_eei_information23            in     varchar2  default hr_api.g_varchar2
  ,p_eei_information24            in     varchar2  default hr_api.g_varchar2
  ,p_eei_information25            in     varchar2  default hr_api.g_varchar2
  ,p_eei_information26            in     varchar2  default hr_api.g_varchar2
  ,p_eei_information27            in     varchar2  default hr_api.g_varchar2
  ,p_eei_information28            in     varchar2  default hr_api.g_varchar2
  ,p_eei_information29            in     varchar2  default hr_api.g_varchar2
  ,p_eei_information30            in     varchar2  default hr_api.g_varchar2
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 377


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

Line: 383


  savepoint update_element_extra_info_swi;

Line: 404


  pay_element_eit_mig.update_element_extra_info
    (p_validate                     => l_validate
    ,p_element_type_extra_info_id   => p_element_type_extra_info_id
    ,p_object_version_number        => p_object_version_number
    ,p_eei_attribute_category       => p_eei_attribute_category
    ,p_eei_attribute1               => p_eei_attribute1
    ,p_eei_attribute2               => p_eei_attribute2
    ,p_eei_attribute3               => p_eei_attribute3
    ,p_eei_attribute4               => p_eei_attribute4
    ,p_eei_attribute5               => p_eei_attribute5
    ,p_eei_attribute6               => p_eei_attribute6
    ,p_eei_attribute7               => p_eei_attribute7
    ,p_eei_attribute8               => p_eei_attribute8
    ,p_eei_attribute9               => p_eei_attribute9
    ,p_eei_attribute10              => p_eei_attribute10
    ,p_eei_attribute11              => p_eei_attribute11
    ,p_eei_attribute12              => p_eei_attribute12
    ,p_eei_attribute13              => p_eei_attribute13
    ,p_eei_attribute14              => p_eei_attribute14
    ,p_eei_attribute15              => p_eei_attribute15
    ,p_eei_attribute16              => p_eei_attribute16
    ,p_eei_attribute17              => p_eei_attribute17
    ,p_eei_attribute18              => p_eei_attribute18
    ,p_eei_attribute19              => p_eei_attribute19
    ,p_eei_attribute20              => p_eei_attribute20
    ,p_eei_information_category     => p_eei_information_category
    ,p_eei_information1             => p_eei_information1
    ,p_eei_information2             => p_eei_information2
    ,p_eei_information3             => p_eei_information3
    ,p_eei_information4             => p_eei_information4
    ,p_eei_information5             => p_eei_information5
    ,p_eei_information6             => p_eei_information6
    ,p_eei_information7             => p_eei_information7
    ,p_eei_information8             => p_eei_information8
    ,p_eei_information9             => p_eei_information9
    ,p_eei_information10            => p_eei_information10
    ,p_eei_information11            => p_eei_information11
    ,p_eei_information12            => p_eei_information12
    ,p_eei_information13            => p_eei_information13
    ,p_eei_information14            => p_eei_information14
    ,p_eei_information15            => p_eei_information15
    ,p_eei_information16            => p_eei_information16
    ,p_eei_information17            => p_eei_information17
    ,p_eei_information18            => p_eei_information18
    ,p_eei_information19            => p_eei_information19
    ,p_eei_information20            => p_eei_information20
    ,p_eei_information21            => p_eei_information21
    ,p_eei_information22            => p_eei_information22
    ,p_eei_information23            => p_eei_information23
    ,p_eei_information24            => p_eei_information24
    ,p_eei_information25            => p_eei_information25
    ,p_eei_information26            => p_eei_information26
    ,p_eei_information27            => p_eei_information27
    ,p_eei_information28            => p_eei_information28
    ,p_eei_information29            => p_eei_information29
    ,p_eei_information30            => p_eei_information30
    );

Line: 483


    rollback to update_element_extra_info_swi;

Line: 498


    rollback to update_element_extra_info_swi;

Line: 509


end update_element_extra_info;