APPS.HR_ADI_DOCUMENT_SWI SQL Statements

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

Line: 115

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

Line: 127

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

Line: 133

  savepoint delete_document_swi;

Line: 153

  hr_adi_document_api.delete_document
    (p_validate                     => l_validate
    ,p_file_id                      => p_file_id
    );

Line: 179

    rollback to delete_document_swi;

Line: 193

    rollback to delete_document_swi;

Line: 203

end delete_document;

Line: 207

PROCEDURE update_document
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date
  ,p_file_id                      in     number
  ,p_mime_type                    in     varchar2
  ,p_file_name                    in     varchar2
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 222

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

Line: 228

  savepoint update_document_swi;

Line: 248

  hr_adi_document_api.update_document
    (p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    ,p_file_id                      => p_file_id
    ,p_mime_type                    => p_mime_type
    ,p_file_name                    => p_file_name
    );

Line: 277

    rollback to update_document_swi;

Line: 291

    rollback to update_document_swi;

Line: 301

end update_document;