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

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

Line: 92


  ,p_program_update_date          in     date      default null
  ,p_document_extra_info_id       in     number
  ,p_object_version_number           out nocopy number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 215


    ,p_program_update_date          => p_program_update_date
    ,p_document_extra_info_id       => l_document_extra_info_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 271


PROCEDURE update_doc_extra_info
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_document_extra_info_id       in     number
  ,p_person_id                    in     number
  ,p_document_type_id             in     number
  ,p_date_from                    in     date
  ,p_date_to                      in     date
  ,p_document_number              in     varchar2  default hr_api.g_varchar2
  ,p_issued_by                    in     varchar2  default hr_api.g_varchar2
  ,p_issued_at                    in     varchar2  default hr_api.g_varchar2
  ,p_issued_date                  in     date      default hr_api.g_date
  ,p_issuing_authority            in     varchar2  default hr_api.g_varchar2
  ,p_verified_by                  in     number    default hr_api.g_number
  ,p_verified_date                in     date      default hr_api.g_date
  ,p_related_object_name          in     varchar2  default hr_api.g_varchar2
  ,p_related_object_id_col        in     varchar2  default hr_api.g_varchar2
  ,p_related_object_id            in     number    default hr_api.g_number
  ,p_dei_attribute_category       in     varchar2  default hr_api.g_varchar2
  ,p_dei_attribute1               in     varchar2  default hr_api.g_varchar2
  ,p_dei_attribute2               in     varchar2  default hr_api.g_varchar2
  ,p_dei_attribute3               in     varchar2  default hr_api.g_varchar2
  ,p_dei_attribute4               in     varchar2  default hr_api.g_varchar2
  ,p_dei_attribute5               in     varchar2  default hr_api.g_varchar2
  ,p_dei_attribute6               in     varchar2  default hr_api.g_varchar2
  ,p_dei_attribute7               in     varchar2  default hr_api.g_varchar2
  ,p_dei_attribute8               in     varchar2  default hr_api.g_varchar2
  ,p_dei_attribute9               in     varchar2  default hr_api.g_varchar2
  ,p_dei_attribute10              in     varchar2  default hr_api.g_varchar2
  ,p_dei_attribute11              in     varchar2  default hr_api.g_varchar2
  ,p_dei_attribute12              in     varchar2  default hr_api.g_varchar2
  ,p_dei_attribute13              in     varchar2  default hr_api.g_varchar2
  ,p_dei_attribute14              in     varchar2  default hr_api.g_varchar2
  ,p_dei_attribute15              in     varchar2  default hr_api.g_varchar2
  ,p_dei_attribute16              in     varchar2  default hr_api.g_varchar2
  ,p_dei_attribute17              in     varchar2  default hr_api.g_varchar2
  ,p_dei_attribute18              in     varchar2  default hr_api.g_varchar2
  ,p_dei_attribute19              in     varchar2  default hr_api.g_varchar2
  ,p_dei_attribute20              in     varchar2  default hr_api.g_varchar2
  ,p_dei_attribute21              in     varchar2  default hr_api.g_varchar2
  ,p_dei_attribute22              in     varchar2  default hr_api.g_varchar2
  ,p_dei_attribute23              in     varchar2  default hr_api.g_varchar2
  ,p_dei_attribute24              in     varchar2  default hr_api.g_varchar2
  ,p_dei_attribute25              in     varchar2  default hr_api.g_varchar2
  ,p_dei_attribute26              in     varchar2  default hr_api.g_varchar2
  ,p_dei_attribute27              in     varchar2  default hr_api.g_varchar2
  ,p_dei_attribute28              in     varchar2  default hr_api.g_varchar2
  ,p_dei_attribute29              in     varchar2  default hr_api.g_varchar2
  ,p_dei_attribute30              in     varchar2  default hr_api.g_varchar2
  ,p_dei_information_category     in     varchar2  default hr_api.g_varchar2
  ,p_dei_information1             in     varchar2  default hr_api.g_varchar2
  ,p_dei_information2             in     varchar2  default hr_api.g_varchar2
  ,p_dei_information3             in     varchar2  default hr_api.g_varchar2
  ,p_dei_information4             in     varchar2  default hr_api.g_varchar2
  ,p_dei_information5             in     varchar2  default hr_api.g_varchar2
  ,p_dei_information6             in     varchar2  default hr_api.g_varchar2
  ,p_dei_information7             in     varchar2  default hr_api.g_varchar2
  ,p_dei_information8             in     varchar2  default hr_api.g_varchar2
  ,p_dei_information9             in     varchar2  default hr_api.g_varchar2
  ,p_dei_information10            in     varchar2  default hr_api.g_varchar2
  ,p_dei_information11            in     varchar2  default hr_api.g_varchar2
  ,p_dei_information12            in     varchar2  default hr_api.g_varchar2
  ,p_dei_information13            in     varchar2  default hr_api.g_varchar2
  ,p_dei_information14            in     varchar2  default hr_api.g_varchar2
  ,p_dei_information15            in     varchar2  default hr_api.g_varchar2
  ,p_dei_information16            in     varchar2  default hr_api.g_varchar2
  ,p_dei_information17            in     varchar2  default hr_api.g_varchar2
  ,p_dei_information18            in     varchar2  default hr_api.g_varchar2
  ,p_dei_information19            in     varchar2  default hr_api.g_varchar2
  ,p_dei_information20            in     varchar2  default hr_api.g_varchar2
  ,p_dei_information21            in     varchar2  default hr_api.g_varchar2
  ,p_dei_information22            in     varchar2  default hr_api.g_varchar2
  ,p_dei_information23            in     varchar2  default hr_api.g_varchar2
  ,p_dei_information24            in     varchar2  default hr_api.g_varchar2
  ,p_dei_information25            in     varchar2  default hr_api.g_varchar2
  ,p_dei_information26            in     varchar2  default hr_api.g_varchar2
  ,p_dei_information27            in     varchar2  default hr_api.g_varchar2
  ,p_dei_information28            in     varchar2  default hr_api.g_varchar2
  ,p_dei_information29            in     varchar2  default hr_api.g_varchar2
  ,p_dei_information30            in     varchar2  default hr_api.g_varchar2
  ,p_request_id                   in     number    default hr_api.g_number
  ,p_program_application_id       in     number    default hr_api.g_number
  ,p_program_id                   in     number    default hr_api.g_number
  ,p_program_update_date          in     date      default hr_api.g_date
  ,p_object_version_number        in out nocopy number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 365


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

Line: 371


  savepoint update_doc_extra_info_swi;

Line: 392


  hr_document_extra_info_api.update_doc_extra_info
    (p_validate                     => l_validate
    ,p_document_extra_info_id       => p_document_extra_info_id
    ,p_person_id                    => p_person_id
    ,p_document_type_id             => p_document_type_id
    ,p_date_from                    => p_date_from
    ,p_date_to                      => p_date_to
    ,p_document_number              => p_document_number
    ,p_issued_by                    => p_issued_by
    ,p_issued_at                    => p_issued_at
    ,p_issued_date                  => p_issued_date
    ,p_issuing_authority            => p_issuing_authority
    ,p_verified_by                  => p_verified_by
    ,p_verified_date                => p_verified_date
    ,p_related_object_name          => p_related_object_name
    ,p_related_object_id_col        => p_related_object_id_col
    ,p_related_object_id            => p_related_object_id
    ,p_dei_attribute_category       => p_dei_attribute_category
    ,p_dei_attribute1               => p_dei_attribute1
    ,p_dei_attribute2               => p_dei_attribute2
    ,p_dei_attribute3               => p_dei_attribute3
    ,p_dei_attribute4               => p_dei_attribute4
    ,p_dei_attribute5               => p_dei_attribute5
    ,p_dei_attribute6               => p_dei_attribute6
    ,p_dei_attribute7               => p_dei_attribute7
    ,p_dei_attribute8               => p_dei_attribute8
    ,p_dei_attribute9               => p_dei_attribute9
    ,p_dei_attribute10              => p_dei_attribute10
    ,p_dei_attribute11              => p_dei_attribute11
    ,p_dei_attribute12              => p_dei_attribute12
    ,p_dei_attribute13              => p_dei_attribute13
    ,p_dei_attribute14              => p_dei_attribute14
    ,p_dei_attribute15              => p_dei_attribute15
    ,p_dei_attribute16              => p_dei_attribute16
    ,p_dei_attribute17              => p_dei_attribute17
    ,p_dei_attribute18              => p_dei_attribute18
    ,p_dei_attribute19              => p_dei_attribute19
    ,p_dei_attribute20              => p_dei_attribute20
    ,p_dei_attribute21              => p_dei_attribute21
    ,p_dei_attribute22              => p_dei_attribute22
    ,p_dei_attribute23              => p_dei_attribute23
    ,p_dei_attribute24              => p_dei_attribute24
    ,p_dei_attribute25              => p_dei_attribute25
    ,p_dei_attribute26              => p_dei_attribute26
    ,p_dei_attribute27              => p_dei_attribute27
    ,p_dei_attribute28              => p_dei_attribute28
    ,p_dei_attribute29              => p_dei_attribute29
    ,p_dei_attribute30              => p_dei_attribute30
    ,p_dei_information_category     => p_dei_information_category
    ,p_dei_information1             => p_dei_information1
    ,p_dei_information2             => p_dei_information2
    ,p_dei_information3             => p_dei_information3
    ,p_dei_information4             => p_dei_information4
    ,p_dei_information5             => p_dei_information5
    ,p_dei_information6             => p_dei_information6
    ,p_dei_information7             => p_dei_information7
    ,p_dei_information8             => p_dei_information8
    ,p_dei_information9             => p_dei_information9
    ,p_dei_information10            => p_dei_information10
    ,p_dei_information11            => p_dei_information11
    ,p_dei_information12            => p_dei_information12
    ,p_dei_information13            => p_dei_information13
    ,p_dei_information14            => p_dei_information14
    ,p_dei_information15            => p_dei_information15
    ,p_dei_information16            => p_dei_information16
    ,p_dei_information17            => p_dei_information17
    ,p_dei_information18            => p_dei_information18
    ,p_dei_information19            => p_dei_information19
    ,p_dei_information20            => p_dei_information20
    ,p_dei_information21            => p_dei_information21
    ,p_dei_information22            => p_dei_information22
    ,p_dei_information23            => p_dei_information23
    ,p_dei_information24            => p_dei_information24
    ,p_dei_information25            => p_dei_information25
    ,p_dei_information26            => p_dei_information26
    ,p_dei_information27            => p_dei_information27
    ,p_dei_information28            => p_dei_information28
    ,p_dei_information29            => p_dei_information29
    ,p_dei_information30            => p_dei_information30
    ,p_request_id                   => p_request_id
    ,p_program_application_id       => p_program_application_id
    ,p_program_id                   => p_program_id
    ,p_program_update_date          => p_program_update_date
    ,p_object_version_number        => p_object_version_number
    );

Line: 499


    rollback to update_doc_extra_info_swi;

Line: 514


    rollback to update_doc_extra_info_swi;

Line: 525


end update_doc_extra_info;

Line: 529


PROCEDURE delete_doc_extra_info
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_document_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: 542


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

Line: 548


  savepoint delete_doc_extra_info_swi;

Line: 568


  hr_document_extra_info_api.delete_doc_extra_info
    (p_validate                     => l_validate
    ,p_document_extra_info_id       => p_document_extra_info_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 595


    rollback to delete_doc_extra_info_swi;

Line: 609


    rollback to delete_doc_extra_info_swi;

Line: 619


end delete_doc_extra_info;