APPS.PQH_BUDGET_POOLS_SWI SQL Statements

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

Line: 9

PROCEDURE delete_trxn_amts(p_transaction_type in varchar2 , p_bdgt_trnx_amount_id in number) is

/*

This is a private function which deletes Donor / Receiver Transaction Amount
for a given bdgt_trnx_amount_id

Transaction Type :
=================
DD - Donor Details
RD - Receiver Details

*/
cursor csr_bdgt_trnx_amt is
select reallocation_id, object_version_number
from   pqh_bdgt_pool_realloctions
where  reallocation_id = p_bdgt_trnx_amount_id
and    transaction_type = p_transaction_type;

Line: 29

select nvl(count(reallocation_id),0)
from pqh_bdgt_pool_realloctions
where txn_detail_id in (select txn_detail_id
                        from pqh_bdgt_pool_realloctions
                        where reallocation_id = p_bdgt_trnx_amount_id
                        and transaction_type = 'RD');

Line: 43

select txn_detail_id, object_version_number
from pqh_bdgt_pool_realloctions
where reallocation_id = p_bdgt_trnx_amount_id
and transaction_type = 'RD';

Line: 50

select reallocation_id, object_version_number
from pqh_bdgt_pool_realloctions
where reallocation_id in ( select TXN_DETAIL_ID
                           from pqh_bdgt_pool_realloctions
                           where reallocation_id = p_bdgt_trnx_amount_id
                           and transaction_type = 'RD');

Line: 62

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

Line: 67

      If the Receiver has only one period then delete receiver and receiver period.
      If the reciver has more than one receiver periods then delete only the given receiver period.
   */
 hr_utility.set_location(' Entering:' || l_proc,10);

Line: 91

   pqh_bdgt_pool_realloctions_api.delete_realloc_txn_period
     (p_validate   		=> false
     ,p_reallocation_period_id     => l_bdgt_trnx_amount_id
     ,p_object_version_number      => l_ovn
     );

Line: 98

    pqh_bdgt_pool_realloctions_api.delete_realloc_txn_dtl
          ( p_validate   		 => false
           ,p_txn_detail_id              => l_receiver_id
           ,p_object_version_number      => l_receiver_ovn
           );

Line: 105

END delete_trxn_amts;

Line: 107

PROCEDURE delete_trxn_dtls(p_transaction_type in varchar2 , p_bdgt_trnx_detail_id in number) is

/*
This is a private function which Deletes Donor / Receiver  Transaction Details
for a given bdgt_trnx_detail_id
Transaction Type :
=================
D - Donor
R - Receiver
*/

cursor csr_donor_receiver_details is
select reallocation_id,transaction_type
from pqh_bdgt_pool_realloctions
where txn_detail_id = p_bdgt_trnx_detail_id;

Line: 124

select reallocation_id,object_version_number
from   pqh_bdgt_pool_realloctions
where  reallocation_id = p_bdgt_trnx_detail_id
and    transaction_type = p_transaction_type;

Line: 133

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

Line: 144

      /* Delete all Donor/Receiver Amount Details */
      hr_utility.set_location(' l_bdgt_trnx_amt_id:' || l_bdgt_trnx_amt_id,15);

Line: 147

      delete_trxn_amts
        (p_transaction_type    => l_transaction_type,
         p_bdgt_trnx_amount_id => l_bdgt_trnx_amt_id);

Line: 154

   /* Delete Donor/Receiver Details */
     open csr_bdgt_trnx_dtl;

Line: 161

      pqh_bdgt_pool_realloctions_api.delete_realloc_txn_dtl
          ( p_validate   		 => false
           ,p_txn_detail_id        => l_bdgt_trnx_detail_id
           ,p_object_version_number      => l_ovn
           );

Line: 169

END delete_trxn_dtls;

Line: 172

PROCEDURE delete_bgt_transaction (p_transaction_id in number) is

/*
This is a private function which Deletes Budget Transaction for
a given Budget Transaction Id
*/

cursor csr_bdgt_trnx_details  is
select reallocation_id ,transaction_type
from pqh_bdgt_pool_realloctions
where pool_id = p_transaction_id;

Line: 185

select pool_id,object_version_number
from   pqh_budget_pools
where  pool_id = p_transaction_id;

Line: 192

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

Line: 203

  delete_trxn_dtls
    (p_transaction_type    => l_transaction_type
    ,p_bdgt_trnx_detail_id => l_transaction_id );

Line: 215

  pqh_budget_pools_api.delete_reallocation_txn
    (p_validate   		=> false
    ,p_transaction_id             => l_transaction_id
    ,p_object_version_number      => l_ovn
    ,p_effective_date             => sysdate
    );

Line: 223

END delete_bgt_transaction;

Line: 227

PROCEDURE delete_bgt_folder(p_folder_id in number) is
/*
This is a private function which Deletes Budget Transaction for a
given Budget Folder Id
*/

cursor csr_bdgt_transaction is
select pool_id
from   pqh_budget_pools
where  parent_pool_id = p_folder_id;

Line: 240

select pool_id,object_version_number
from   pqh_budget_pools
where  pool_id = p_folder_id;

Line: 247

SELECT process_log_id,object_version_number
FROM   pqh_process_log
WHERE    module_cd = 'BUDGET_REALLOCATION'
START WITH process_log_id = (SELECT process_log_id
                             FROM   pqh_process_log
			     WHERE  module_cd = 'BUDGET_REALLOCATION'
		             AND    master_process_log_id IS NULL
		             AND    txn_id = p_folder_id)
CONNECT BY master_process_log_id = PRIOR process_log_id
ORDER BY level DESC;

Line: 261

Select wf_transaction_category_id
From pqh_budget_pools
Where pool_id = p_folder_id;

Line: 270

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

Line: 287

   delete_bgt_transaction
    (p_transaction_id    => l_transaction_id);

Line: 299

  pqh_budget_pools_api.delete_reallocation_folder
    (p_validate   		=> false
    ,p_folder_id                  => l_folder_id
    ,p_object_version_number      => l_ovn
    ,p_effective_date             => sysdate
     );

Line: 314

    pqh_process_log_api.delete_process_log(p_process_log_id => plg.process_log_id
                                          ,p_object_version_number=> plg.object_version_number
                                          ,p_effective_date => sysdate);

Line: 320

hr_utility.set_location(' call to delete folder from inbox:' || l_proc,40);

Line: 330

END delete_bgt_folder;

Line: 557

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

Line: 571

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

Line: 577

  savepoint delete_reallocation_folder_swi;

Line: 597

  pqh_budget_pools_api.delete_reallocation_folder
    (p_validate                     => l_validate
    ,p_folder_id                    => p_folder_id
    ,p_object_version_number        => p_object_version_number
    ,p_effective_date               => p_effective_date
    );

Line: 625

    rollback to delete_reallocation_folder_swi;

Line: 639

    rollback to delete_reallocation_folder_swi;

Line: 649

end delete_reallocation_folder;

Line: 653

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

Line: 667

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

Line: 673

  savepoint delete_reallocation_txn_swi;

Line: 693

  pqh_budget_pools_api.delete_reallocation_txn
    (p_validate                     => l_validate
    ,p_transaction_id               => p_transaction_id
    ,p_object_version_number        => p_object_version_number
    ,p_effective_date               => p_effective_date
    );

Line: 721

    rollback to delete_reallocation_txn_swi;

Line: 735

    rollback to delete_reallocation_txn_swi;

Line: 745

end delete_reallocation_txn;

Line: 749

PROCEDURE update_reallocation_folder
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date
  ,p_folder_id                    in     number
  ,p_name                         in     varchar2  default hr_api.g_varchar2
  ,p_budget_version_id            in     number    default hr_api.g_number
  ,p_budget_unit_id               in     number    default hr_api.g_number
  ,p_entity_type                  in     varchar2  default hr_api.g_varchar2
  ,p_approval_status              in     varchar2  default hr_api.g_varchar2
  ,p_object_version_number        in out nocopy number
  ,p_business_group_id            in     number
  ,p_wf_transaction_category_id   in number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 771

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

Line: 777

  savepoint update_reallocation_folder_swi;

Line: 798

  pqh_budget_pools_api.update_reallocation_folder
    (p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    ,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_business_group_id            => p_business_group_id
    ,p_wf_transaction_category_id   => p_wf_transaction_category_id
    );

Line: 833

    rollback to update_reallocation_folder_swi;

Line: 848

    rollback to update_reallocation_folder_swi;

Line: 859

end update_reallocation_folder;

Line: 863

PROCEDURE update_reallocation_txn
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date
  ,p_transaction_id               in     number
  ,p_name                         in     varchar2  default hr_api.g_varchar2
  ,p_parent_folder_id               in     number    default hr_api.g_number
  ,p_object_version_number        in out nocopy number
  ,p_business_group_id            in     number    default hr_api.g_number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 881

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

Line: 887

  savepoint update_reallocation_txn_swi;

Line: 908

  pqh_budget_pools_api.update_reallocation_txn
    (p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    ,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_business_group_id            => p_business_group_id
    );

Line: 939

    rollback to update_reallocation_txn_swi;

Line: 954

    rollback to update_reallocation_txn_swi;

Line: 965

end update_reallocation_txn;

Line: 967

PROCEDURE bgt_realloc_delete(p_node_type  in varchar2, p_node_id in number)
is

/*
Node Type :
==========
F-  Folder
T - Transaction
D - Donor
DD - Donor Details
R - Receiver
RD - Receiver Details
*/
l_proc    varchar2(72) := g_package ||'bgt_realloc_delete';

Line: 992

  delete_trxn_amts
   ( p_transaction_type    => p_node_type
    ,p_bdgt_trnx_amount_id => p_node_id);

Line: 997

  delete_trxn_dtls
      (p_transaction_type    => p_node_type
      ,p_bdgt_trnx_detail_id => p_node_id);

Line: 1002

 delete_bgt_transaction
   (p_transaction_id => p_node_id);

Line: 1006

   delete_bgt_folder
   (p_folder_id => p_node_id);

Line: 1012

END bgt_realloc_delete;