APPS.PQH_TXN_CAT_DOCUMENTS_SWI SQL Statements

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

Line: 113

PROCEDURE delete_txn_cat_document
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_document_id                  in     number
  ,p_transaction_category_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: 127

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

Line: 133

  savepoint delete_txn_cat_document_swi;

Line: 153

  pqh_txn_cat_documents_api.delete_txn_cat_document
    (p_validate                     => l_validate
    ,p_document_id                  => p_document_id
    ,p_transaction_category_id      => p_transaction_category_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 181

    rollback to delete_txn_cat_document_swi;

Line: 195

    rollback to delete_txn_cat_document_swi;

Line: 205

end delete_txn_cat_document;

Line: 211

PROCEDURE delete_group
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_transaction_category_id      in     number
  ,p_object_version_number        in     number
  ,p_effective_date               in     date      default sysdate
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 225

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

Line: 229

  Select document_id , object_version_number
  from pqh_txn_category_documents
  where transaction_category_id = p_transaction_category_id;

Line: 238

  savepoint delete_txn_cat_document_swi;

Line: 261

		pqh_txn_cat_documents_api.delete_txn_cat_document
    		(p_validate                     => l_validate
    		,p_document_id                  => l_rec.document_id
    		,p_transaction_category_id      => p_transaction_category_id
    		,p_object_version_number        => l_rec.object_version_number
    		);

Line: 273

  pqh_tran_category_api.delete_tran_category
    (p_validate                     => l_validate
    ,p_transaction_category_id      => p_transaction_category_id
    ,p_object_version_number        => p_object_version_number
    ,p_effective_date               => trunc(p_effective_date)
    );

Line: 301

    rollback to delete_txn_cat_document_swi;

Line: 315

    rollback to delete_txn_cat_document_swi;

Line: 325

end delete_group;

Line: 333

PROCEDURE update_txn_cat_document
  (p_validate                     in     number    default hr_api.g_false_num
  ,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
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 350

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

Line: 356

  savepoint update_txn_cat_document_swi;

Line: 377

  pqh_txn_cat_documents_api.update_txn_cat_document
    (p_validate                     => l_validate
    ,p_effective_date               => p_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: 407

    rollback to update_txn_cat_document_swi;

Line: 422

    rollback to update_txn_cat_document_swi;

Line: 433

end update_txn_cat_document;