APPS.PQH_DOCUMENT_ATTRIBUTES_API SQL Statements

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

Line: 152

procedure update_document_attribute
 (p_validate                     in     boolean  default false
    ,p_effective_date               in     date
    ,p_datetrack_mode               in     varchar2
    ,p_document_attribute_id        in     number
    ,p_object_version_number        in out NOCOPY number
    ,p_document_id                  in     number    default hr_api.g_number
    ,p_attribute_id                 in     number    default hr_api.g_number
    ,p_tag_name                     in     varchar2  default hr_api.g_varchar2
    ,p_effective_start_date            out NOCOPY date
    ,p_effective_end_date              out NOCOPY date
    ) is

  --
  -- Declare cursors and local variables
  --

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

Line: 180

  savepoint UPDATE_DOCUMENT_ATTRIBUTE;

Line: 188

    PQH_DOCUMENT_ATTRIBUTES_BK2.update_document_attribute_b
	(p_effective_date           => p_effective_date
        ,p_datetrack_mode           => p_datetrack_mode
        ,p_document_attribute_id    => p_document_attribute_id
        ,p_object_version_number    => p_object_version_number
        ,p_document_id              => p_document_id
        ,p_attribute_id             => p_attribute_id
        ,p_tag_name                 => p_tag_name
        );

Line: 201

        (p_module_name => 'UPDATE_DOCUMENT_ATTRIBUTE'
        ,p_hook_type   => 'BP'
        );

Line: 227

    PQH_DOCUMENT_ATTRIBUTES_BK2.update_document_attribute_a
	(p_effective_date           => p_effective_date
        ,p_datetrack_mode           => p_datetrack_mode
        ,p_document_attribute_id    => p_document_attribute_id
        ,p_object_version_number    => p_object_version_number
        ,p_document_id              => p_document_id
        ,p_attribute_id             => p_attribute_id
        ,p_tag_name                 => p_tag_name
	,p_effective_start_date       => l_effective_start_date
        ,p_effective_end_date         => l_effective_end_date
	);

Line: 243

        (p_module_name => 'UPDATE_DOCUMENT_ATTRIBUTE'
        ,p_hook_type   => 'AP'
        );

Line: 268

    rollback to UPDATE_DOCUMENT_ATTRIBUTE;

Line: 289

    rollback to UPDATE_DOCUMENT_ATTRIBUTE;

Line: 292

end update_document_attribute;

Line: 323

procedure delete_document_attribute
  (p_validate                       in     boolean  default false
  ,p_effective_date                 in     date
  ,p_datetrack_mode                 in     varchar2
  ,p_document_attribute_id          in     number
  ,p_object_version_number          in OUT NOCOPY     number
  ,p_effective_start_date           OUT    NOCOPY     date
  ,p_effective_end_date     	    OUT    NOCOPY     date
  )
  is
    --
    -- Declare cursors and local variables
    --

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

Line: 347

    savepoint DELETE_DOCUMENT_ATTRIBUTE;

Line: 356

   PQH_DOCUMENT_ATTRIBUTES_BK3.delete_document_attribute_b
    (p_effective_date            => p_effective_date
    ,p_datetrack_mode            => p_datetrack_mode
    ,p_document_attribute_id     => p_document_attribute_id
    ,p_object_version_number     => p_object_version_number
    );

Line: 365

           (p_module_name => 'DELETE_DOCUMENT_ATTRIBUTE'
           ,p_hook_type   => 'BP'
           );

Line: 387

   PQH_DOCUMENT_ATTRIBUTES_BK3.delete_document_attribute_a
       (p_effective_date            => p_effective_date
       ,p_datetrack_mode            => p_datetrack_mode
       ,p_document_attribute_id     => p_document_attribute_id
       ,p_object_version_number     => p_object_version_number
       ,p_effective_start_date      => l_effective_start_date
       ,p_effective_end_date        => l_effective_end_date
    );

Line: 398

            (p_module_name => 'DELETE_DOCUMENT_ATTRIBUTE'
            ,p_hook_type   => 'AP'
            );

Line: 421

      rollback to DELETE_DOCUMENT_ATTRIBUTE;

Line: 440

      rollback to DELETE_DOCUMENT_ATTRIBUTE;

Line: 444

 end delete_document_attribute;