APPS.PQH_BUDGET_POOLS_API SQL Statements

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

Line: 182

procedure update_reallocation_folder
  (
   p_validate                       in boolean
  ,p_effective_date                 in  date
  ,p_folder_id                      in  number
  ,p_name                           in  varchar2
  ,p_budget_version_id              in  number
  ,p_budget_unit_id                 in  number
  ,p_entity_type                    in  varchar2
  ,p_approval_status                in  varchar2
  ,p_object_version_number          in out nocopy  number
  ,p_business_group_id              in  number
  ,p_wf_transaction_category_id     in number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_reallocation_folder';

Line: 208

  savepoint update_reallocation_folder;

Line: 220

    pqh_budget_pools_bk2.update_reallocation_folder_b
      (
       p_folder_id                      =>  p_folder_id
      ,p_name                           =>  p_name
      ,p_budget_version_id              =>  p_budget_version_id
      ,p_budget_unit_id                 =>  p_budget_unit_id
      ,p_entity_type                    =>  p_entity_type
      ,p_approval_status                =>  p_approval_status
      ,p_object_version_number          =>  p_object_version_number
      ,p_effective_date                 => trunc(p_effective_date)
      ,p_business_group_id              =>  p_business_group_id
      ,p_wf_transaction_category_id     =>  p_wf_transaction_category_id
      );

Line: 236

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

Line: 262

    pqh_budget_pools_bk2.update_reallocation_folder_a
      (
       p_folder_id                      =>  p_folder_id
      ,p_name                           =>  p_name
      ,p_budget_version_id              =>  p_budget_version_id
      ,p_budget_unit_id                 =>  p_budget_unit_id
      ,p_approval_status                =>  p_approval_status
      ,p_entity_type                    =>  p_entity_type
      ,p_object_version_number          =>  l_object_version_number
      ,p_effective_date                 => trunc(p_effective_date)
      ,p_business_group_id             =>  p_business_group_id
      ,p_wf_transaction_category_id    =>  p_wf_transaction_category_id
      );

Line: 278

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

Line: 307

    ROLLBACK TO update_reallocation_flolder;

Line: 319

    ROLLBACK TO update_reallocation_folder;

Line: 322

end update_reallocation_folder;

Line: 327

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

Line: 345

  savepoint delete_reallocation_folder;

Line: 358

    pqh_budget_pools_bk3.delete_reallocation_folder_b
      (
       p_folder_id                      =>  p_folder_id
      ,p_object_version_number          =>  p_object_version_number
      ,p_effective_date                   => trunc(p_effective_date)
      );

Line: 367

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

Line: 385

    pqh_budget_pools_bk3.delete_reallocation_folder_a
      (
       p_folder_id                      =>  p_folder_id
      ,p_object_version_number          =>  l_object_version_number
      ,p_effective_date                 => trunc(p_effective_date)
      );

Line: 394

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

Line: 419

    ROLLBACK TO delete_reallocation_folder;

Line: 430

    ROLLBACK TO delete_reallocation_folder;

Line: 433

end delete_reallocation_folder;

Line: 580

procedure update_reallocation_txn
  (
   p_validate                       in      boolean
  ,p_effective_date                 in      date
  ,p_transaction_id                 in      number
  ,p_name                           in      varchar2
  ,p_parent_folder_id               in      number
  ,p_object_version_number          in out  nocopy  number
  ,p_business_group_id              in      number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_reallocation_txn';

Line: 602

  savepoint update_reallocation_txn;

Line: 614

     pqh_budget_pools_bk5.update_reallocation_txn_b
      (
       p_transaction_id                 =>  p_transaction_id
      ,p_name                           =>  p_name
      ,p_parent_folder_id               =>  p_parent_folder_id
      ,p_object_version_number          =>  p_object_version_number
      ,p_effective_date                 =>  trunc(p_effective_date)
      ,p_business_group_id              =>  p_business_group_id
      );

Line: 626

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

Line: 648

    pqh_budget_pools_bk5.update_reallocation_txn_a
      (
       p_transaction_id                 =>  p_transaction_id
      ,p_name                           =>  p_name
      ,p_parent_folder_id               =>  p_parent_folder_id
      ,p_object_version_number          =>  p_object_version_number
      ,p_effective_date                 =>  trunc(p_effective_date)
      ,p_business_group_id             => p_business_group_id
      );

Line: 660

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

Line: 689

    ROLLBACK TO update_reallocation_txn;

Line: 701

    ROLLBACK TO update_reallocation_txn;

Line: 704

end update_reallocation_txn;

Line: 709

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

Line: 727

  savepoint delete_reallocation_txn;

Line: 740

    pqh_budget_pools_bk6.delete_reallocation_txn_b
      (
       p_transaction_id                 =>  p_transaction_id
      ,p_object_version_number          =>  p_object_version_number
      ,p_effective_date                 => trunc(p_effective_date)
      );

Line: 749

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

Line: 767

    pqh_budget_pools_bk6.delete_reallocation_txn_a
      (
       p_transaction_id                 =>  p_transaction_id
      ,p_object_version_number          =>  l_object_version_number
      ,p_effective_date                 => trunc(p_effective_date)
      );

Line: 776

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

Line: 801

    ROLLBACK TO delete_reallocation_txn;

Line: 812

    ROLLBACK TO delete_reallocation_txn;

Line: 815

end delete_reallocation_txn;