eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_BUDGET_POOLS_SWI dependencies on PQH_BUDGET_POOLS

Line 1: Package Body pqh_budget_pools_swi As

1: Package Body pqh_budget_pools_swi As
2: /* $Header: pqbplswi.pkb 115.7 2003/04/28 11:41:20 kgowripe noship $ */
3: --
4: -- Package variables
5: --

Line 6: g_package varchar2(33) := 'pqh_budget_pools_swi.';

2: /* $Header: pqbplswi.pkb 115.7 2003/04/28 11:41:20 kgowripe noship $ */
3: --
4: -- Package variables
5: --
6: g_package varchar2(33) := 'pqh_budget_pools_swi.';
7: --
8: --
9: PROCEDURE delete_trxn_amts(p_transaction_type in varchar2 , p_bdgt_trnx_amount_id in number) is
10:

Line 186: from pqh_budget_pools

182: where pool_id = p_transaction_id;
183:
184: cursor csr_bdgt_transaction is
185: select pool_id,object_version_number
186: from pqh_budget_pools
187: where pool_id = p_transaction_id;
188:
189: l_ovn number;
190: l_transaction_id number;

Line 215: pqh_budget_pools_api.delete_reallocation_txn

211: fetch csr_bdgt_transaction into l_transaction_id, l_ovn;
212: close csr_bdgt_transaction;
213: hr_utility.set_location(' l_transaction_id :' || l_transaction_id ,25);
214: if l_transaction_id is not null then
215: pqh_budget_pools_api.delete_reallocation_txn
216: (p_validate => false
217: ,p_transaction_id => l_transaction_id
218: ,p_object_version_number => l_ovn
219: ,p_effective_date => sysdate

Line 235: from pqh_budget_pools

231: */
232:
233: cursor csr_bdgt_transaction is
234: select pool_id
235: from pqh_budget_pools
236: where parent_pool_id = p_folder_id;
237:
238:
239: cursor csr_bdgt_folder is

Line 241: from pqh_budget_pools

237:
238:
239: cursor csr_bdgt_folder is
240: select pool_id,object_version_number
241: from pqh_budget_pools
242: where pool_id = p_folder_id;
243:
244: --added by kgowripe for bug#2875736
245: -- Modifed start with caluse for bug 2880128

Line 262: From pqh_budget_pools

258: -- Added by mvankada
259: -- Bug : 2880151
260: Cursor csr_txn_cat_id IS
261: Select wf_transaction_category_id
262: From pqh_budget_pools
263: Where pool_id = p_folder_id;
264:
265: l_ovn number;
266: l_folder_id number;

Line 299: pqh_budget_pools_api.delete_reallocation_folder

295: hr_utility.set_location(' Folder Id :' || l_folder_id ,15);
296:
297: if l_folder_id is not null then
298:
299: pqh_budget_pools_api.delete_reallocation_folder
300: (p_validate => false
301: ,p_folder_id => l_folder_id
302: ,p_object_version_number => l_ovn
303: ,p_effective_date => sysdate

Line 384: pqh_budget_pools_api.create_reallocation_folder

380: --
381: --
382: -- Call API
383: --
384: pqh_budget_pools_api.create_reallocation_folder
385: (p_validate => l_validate
386: ,p_effective_date => p_effective_date
387: ,p_folder_id => p_folder_id
388: ,p_name => p_name

Line 494: pqh_budget_pools_api.create_reallocation_txn

490: --
491: --
492: -- Call API
493: --
494: pqh_budget_pools_api.create_reallocation_txn
495: (p_validate => l_validate
496: ,p_effective_date => p_effective_date
497: ,p_transaction_id => p_transaction_id
498: ,p_name => p_name

Line 597: pqh_budget_pools_api.delete_reallocation_folder

593: --
594: --
595: -- Call API
596: --
597: pqh_budget_pools_api.delete_reallocation_folder
598: (p_validate => l_validate
599: ,p_folder_id => p_folder_id
600: ,p_object_version_number => p_object_version_number
601: ,p_effective_date => p_effective_date

Line 693: pqh_budget_pools_api.delete_reallocation_txn

689: --
690: --
691: -- Call API
692: --
693: pqh_budget_pools_api.delete_reallocation_txn
694: (p_validate => l_validate
695: ,p_transaction_id => p_transaction_id
696: ,p_object_version_number => p_object_version_number
697: ,p_effective_date => p_effective_date

Line 798: pqh_budget_pools_api.update_reallocation_folder

794: --
795: --
796: -- Call API
797: --
798: pqh_budget_pools_api.update_reallocation_folder
799: (p_validate => l_validate
800: ,p_effective_date => p_effective_date
801: ,p_folder_id => p_folder_id
802: ,p_name => p_name

Line 908: pqh_budget_pools_api.update_reallocation_txn

904: --
905: --
906: -- Call API
907: --
908: pqh_budget_pools_api.update_reallocation_txn
909: (p_validate => l_validate
910: ,p_effective_date => p_effective_date
911: ,p_transaction_id => p_transaction_id
912: ,p_name => p_name

Line 1013: end pqh_budget_pools_swi;

1009: End if;
1010: hr_utility.set_location(' Leaving:' || l_proc,30);
1011:
1012: END bgt_realloc_delete;
1013: end pqh_budget_pools_swi;