APPS.PQH_BDGT_POOL_REALLOCTIONS_API SQL Statements

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

Line: 144

procedure update_realloc_txn_dtl
(
   p_validate                       in  boolean
  ,p_effective_date                 in  date
  ,p_transaction_id                 in  number
  ,p_transaction_type               in  varchar2
  ,p_entity_id                      in  number
  ,p_budget_detail_id               in  number
  ,p_txn_detail_id            in  number
  ,p_object_version_number          in out nocopy number
) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_realloc_txn_dtl';

Line: 167

  savepoint update_realloc_txn_dtl;

Line: 179

    pqh_bdgt_pool_realloctions_bk2.update_realloc_txn_dtl_b
      (
       p_transaction_id                =>  p_transaction_id
      ,p_transaction_type              =>  p_transaction_type
      ,p_entity_id                     =>  p_entity_id
      ,p_budget_detail_id              =>  p_budget_detail_id
      ,p_txn_detail_id           =>  p_txn_detail_id
      ,p_object_version_number         =>  l_object_version_number
      );

Line: 191

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

Line: 214

    pqh_bdgt_pool_realloctions_bk2.update_realloc_txn_dtl_a
      (
     p_transaction_id               => p_transaction_id
    ,p_transaction_type             => p_transaction_type
    ,p_entity_id                    => p_entity_id
    ,p_budget_detail_id             => p_budget_detail_id
    ,p_txn_detail_id          => p_txn_detail_id
    ,p_object_version_number        => l_object_version_number
      );

Line: 226

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

Line: 255

    ROLLBACK TO update_realloc_txn_dtl;

Line: 267

    ROLLBACK TO update_realloc_txn_dtl;

Line: 270

end update_realloc_txn_dtl;

Line: 275

procedure delete_realloc_txn_dtl
  (p_validate                       in  boolean
  ,p_txn_detail_id            in  number
  ,p_object_version_number          in  number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'delete_realloc_txn_dtl';

Line: 292

  savepoint delete_realloc_txn_dtl;

Line: 305

    pqh_bdgt_pool_realloctions_bk3.delete_realloc_txn_dtl_b
      (
       p_txn_detail_id            =>  p_txn_detail_id
      ,p_object_version_number          =>  p_object_version_number
      );

Line: 313

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

Line: 331

    pqh_bdgt_pool_realloctions_bk3.delete_realloc_txn_dtl_a
      (
       p_txn_detail_id            =>  p_txn_detail_id
      ,p_object_version_number          =>  l_object_version_number
      );

Line: 339

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

Line: 364

    ROLLBACK TO delete_realloc_txn_dtl;

Line: 375

    ROLLBACK TO delete_realloc_txn_dtl;

Line: 378

end delete_realloc_txn_dtl;

Line: 408

   SELECT pool_id
   FROM   pqh_bdgt_pool_realloctions txndtl
   WHERE  txndtl.reallocation_id = p_txn_detail_id;

Line: 413

   SELECT 1
   FROM   pqh_budget_pools txn,
          pqh_bdgt_pool_realloctions txndtl,
          pqh_bdgt_pool_realloctions txnprd
   WHERE  txn.pool_id = p_transaction_id
     AND  txndtl.pool_id = txn.pool_id
     AND  txndtl.reallocation_id = txnprd.txn_detail_id
     AND  NVL(txnprd.entity_id,-1) = NVL(p_entity_id,-1)
 --    AND  NVL(txnprd.start_date,sysdate) = NVL(p_start_date,sysdate)
 --    AND  NVL(txnprd.end_date,sysdate) = NVL(p_end_date,sysdate);

Line: 568

procedure update_realloc_txn_period
(
   p_validate                       in  boolean
  ,p_effective_date                 in  date
  ,p_txn_detail_id            in  number
  ,p_transaction_type               in  varchar2
  ,p_entity_id                      in  number
  ,p_budget_period_id               in  number
  ,p_start_date                     in  date
  ,p_end_date                       in  date
  ,p_reallocation_amt               in  number
  ,p_reserved_amt                   in  number
  ,p_reallocation_period_id            in  number
  ,p_object_version_number          in out nocopy number
) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_realloc_txn_period';

Line: 590

   SELECT pool_id
   FROM   pqh_bdgt_pool_realloctions txndtl
   WHERE  txndtl.reallocation_id = p_txn_detail_id;

Line: 595

   SELECT 1
   FROM   pqh_budget_pools txn,
          pqh_bdgt_pool_realloctions txndtl,
          pqh_bdgt_pool_realloctions txnprd
   WHERE  txn.pool_id = p_transaction_id
     AND  txndtl.pool_id = txn.pool_id
     AND  txndtl.reallocation_id = txnprd.txn_detail_id
     AND  NVL(txnprd.entity_id,-1) = NVL(p_entity_id,-1)
 --    AND  NVL(txnprd.start_date,sysdate) = NVL(p_start_date,sysdate)
 --    AND  NVL(txnprd.end_date,sysdate) = NVL(p_end_date,sysdate);

Line: 614

  savepoint update_realloc_txn_period;

Line: 641

    pqh_bdgt_pool_realloctions_bk5.update_realloc_txn_period_b
      (
       p_txn_detail_id   => p_txn_detail_id
      ,p_transaction_type      => p_transaction_type
      ,p_entity_id             => p_entity_id
      ,p_budget_period_id      => p_budget_period_id
      ,p_start_date            => p_start_date
      ,p_end_date              => p_end_date
      ,p_reallocation_amt      => p_reallocation_amt
      ,p_reserved_amt          => p_reserved_amt
      ,p_reallocation_period_id      => p_reallocation_period_id
      ,p_object_version_number => l_object_version_number
      );

Line: 657

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

Line: 684

    pqh_bdgt_pool_realloctions_bk5.update_realloc_txn_period_a
      (
       p_txn_detail_id   => p_txn_detail_id
      ,p_transaction_type      => p_transaction_type
      ,p_entity_id             => p_entity_id
      ,p_budget_period_id      => p_budget_period_id
      ,p_start_date            => p_start_date
      ,p_end_date              => p_end_date
      ,p_reallocation_amt      => p_reallocation_amt
      ,p_reserved_amt          => p_reserved_amt
      ,p_reallocation_period_id      => p_reallocation_period_id
      ,p_object_version_number => l_object_version_number
      );

Line: 700

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

Line: 729

    ROLLBACK TO update_realloc_txn_period;

Line: 741

    ROLLBACK TO update_realloc_txn_period;

Line: 744

end update_realloc_txn_period;

Line: 749

procedure delete_realloc_txn_period
  (p_validate                       in  boolean
  ,p_reallocation_period_id            in  number
  ,p_object_version_number          in  number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'delete_realloc_txn_period';

Line: 766

  savepoint delete_realloc_txn_period;

Line: 779

    pqh_bdgt_pool_realloctions_bk6.delete_realloc_txn_period_b
      (
       p_reallocation_period_id            =>  p_reallocation_period_id
      ,p_object_version_number       =>  p_object_version_number
      );

Line: 787

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

Line: 805

    pqh_bdgt_pool_realloctions_bk6.delete_realloc_txn_period_a
      (
       p_reallocation_period_id                =>  p_reallocation_period_id
      ,p_object_version_number          =>  l_object_version_number
      );

Line: 813

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

Line: 838

    ROLLBACK TO delete_realloc_txn_period;

Line: 849

    ROLLBACK TO delete_realloc_txn_period;

Line: 852

end delete_realloc_txn_period;