APPS.HR_ADI_DOCUMENT_API SQL Statements

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

Line: 90

procedure UPDATE_DOCUMENT
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_file_id                       in     number
  ,p_mime_type                     in     varchar2
  ,p_file_name                     in     varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                  varchar2(72) := g_package||'UPDATE_DOCUMENT';

Line: 107

  savepoint UPDATE_DOCUMENT;

Line: 137

    rollback to UPDATE_DOCUMENT;

Line: 148

    rollback to UPDATE_DOCUMENT;

Line: 151

end UPDATE_DOCUMENT;

Line: 158

procedure DELETE_DOCUMENT
  (p_validate                      in     boolean  default false
  ,p_file_id                       in     number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                  varchar2(72) := g_package||'DELETE_DOCUMENT';

Line: 171

  savepoint DELETE_DOCUMENT;

Line: 192

    rollback to DELETE_DOCUMENT;

Line: 198

    rollback to DELETE_DOCUMENT;

Line: 201

end DELETE_DOCUMENT;

Line: 215

  select rowid
  from fnd_lobs
  where file_id = p_file_id;

Line: 266

  select file_id
  from fnd_lobs
  where program_name = 'HRMS_ADI'
    and program_tag  = upper(nvl(p_file_type, program_tag));