APPS.PQH_TXN_CAT_DOCUMENTS_API SQL Statements

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

Line: 131

procedure update_txn_cat_document
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_document_id                   in     number
  ,p_transaction_category_id       in     number
  ,p_type_code                     in     varchar2 default hr_api.g_varchar2
  ,p_object_version_number         in out nocopy   number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_effective_date      date;

Line: 143

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

Line: 150

  savepoint update_txn_cat_document;

Line: 163

    pqh_txn_cat_documents_bk2.update_txn_cat_document_b
      (p_effective_date                => l_effective_date
      ,p_document_id                   => p_document_id
      ,p_transaction_category_id       => p_transaction_category_id
      ,p_type_code                     => p_type_code
      ,p_object_version_number         => p_object_version_number
      );

Line: 173

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

Line: 194

    pqh_txn_cat_documents_bk2.update_txn_cat_document_a
      (p_effective_date                => l_effective_date
      ,p_document_id                   => p_document_id
      ,p_transaction_category_id       => p_transaction_category_id
      ,p_type_code                     => p_type_code
      ,p_object_version_number         => l_object_version_number
      );

Line: 204

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

Line: 226

    rollback to update_txn_cat_document;

Line: 238

    rollback to update_txn_cat_document;

Line: 246

end update_txn_cat_document;

Line: 252

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

Line: 267

  savepoint delete_txn_cat_document;

Line: 275

    pqh_txn_cat_documents_bk3.delete_txn_cat_document_b
      (p_document_id                   => p_document_id
      ,p_transaction_category_id       => p_transaction_category_id
      ,p_object_version_number         => p_object_version_number
      );

Line: 283

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

Line: 302

    pqh_txn_cat_documents_bk3.delete_txn_cat_document_a
      (p_document_id                   => p_document_id
      ,p_transaction_category_id       => p_transaction_category_id
      ,p_object_version_number         => p_object_version_number
      );

Line: 310

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

Line: 331

    rollback to delete_txn_cat_document;

Line: 342

    rollback to delete_txn_cat_document;

Line: 349

end delete_txn_cat_document;