DBA Data[Home] [Help]

APPS.PQH_BUDGET_POOLS_API dependencies on PQH_BUDGET_POOLS

Line 1: Package Body pqh_budget_pools_api as

1: Package Body pqh_budget_pools_api as
2: /* $Header: pqbplapi.pkb 115.7 2003/03/03 12:16:00 ggnanagu noship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: pqbplapi.pkb 115.7 2003/03/03 12:16:00 ggnanagu noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' pqh_budget_pools_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_reallocation_folder >----------------------|
10: -- ----------------------------------------------------------------------------

Line 30: l_folder_id pqh_budget_pools.pool_id%TYPE;

26: ) is
27: --
28: -- Declare cursors and local variables
29: --
30: l_folder_id pqh_budget_pools.pool_id%TYPE;
31: l_proc varchar2(72) := g_package||'create_reallocation_folder';
32: l_object_version_number pqh_budget_pools.object_version_number%TYPE;
33: --
34: begin

Line 32: l_object_version_number pqh_budget_pools.object_version_number%TYPE;

28: -- Declare cursors and local variables
29: --
30: l_folder_id pqh_budget_pools.pool_id%TYPE;
31: l_proc varchar2(72) := g_package||'create_reallocation_folder';
32: l_object_version_number pqh_budget_pools.object_version_number%TYPE;
33: --
34: begin
35: --
36: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 73: pqh_budget_pools_bk1.create_reallocation_folder_b

69: begin
70: --
71: -- Start of API User Hook for the before hook of create_reallocation_folder
72: --
73: pqh_budget_pools_bk1.create_reallocation_folder_b
74: (
75: p_name => p_name
76: ,p_budget_version_id => p_budget_version_id
77: ,p_budget_unit_id => p_budget_unit_id

Line 114: pqh_budget_pools_bk1.create_reallocation_folder_a

110: begin
111: --
112: -- Start of API User Hook for the after hook of create_reallocation_folder
113: --
114: pqh_budget_pools_bk1.create_reallocation_folder_a
115: (
116: p_folder_id => l_folder_id
117: ,p_name => p_name
118: ,p_budget_version_id => p_budget_version_id

Line 200: l_object_version_number pqh_budget_pools.object_version_number%TYPE;

196: --
197: -- Declare cursors and local variables
198: --
199: l_proc varchar2(72) := g_package||'update_reallocation_folder';
200: l_object_version_number pqh_budget_pools.object_version_number%TYPE;
201: --
202: begin
203: --
204: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 220: pqh_budget_pools_bk2.update_reallocation_folder_b

216: begin
217: --
218: -- Start of API User Hook for the before hook of update_reallocation_folder
219: --
220: pqh_budget_pools_bk2.update_reallocation_folder_b
221: (
222: p_folder_id => p_folder_id
223: ,p_name => p_name
224: ,p_budget_version_id => p_budget_version_id

Line 262: pqh_budget_pools_bk2.update_reallocation_folder_a

258: begin
259: --
260: -- Start of API User Hook for the after hook of update_reallocation_folder
261: --
262: pqh_budget_pools_bk2.update_reallocation_folder_a
263: (
264: p_folder_id => p_folder_id
265: ,p_name => p_name
266: ,p_budget_version_id => p_budget_version_id

Line 337: l_object_version_number pqh_budget_pools.object_version_number%TYPE;

333: --
334: -- Declare cursors and local variables
335: --
336: l_proc varchar2(72) := g_package||'delete_reallocation_folder';
337: l_object_version_number pqh_budget_pools.object_version_number%TYPE;
338: --
339: begin
340: --
341: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 358: pqh_budget_pools_bk3.delete_reallocation_folder_b

354: begin
355: --
356: -- Start of API User Hook for the before hook of delete_reallocation_folder
357: --
358: pqh_budget_pools_bk3.delete_reallocation_folder_b
359: (
360: p_folder_id => p_folder_id
361: ,p_object_version_number => p_object_version_number
362: ,p_effective_date => trunc(p_effective_date)

Line 385: pqh_budget_pools_bk3.delete_reallocation_folder_a

381: begin
382: --
383: -- Start of API User Hook for the after hook of delete_reallocation_folder
384: --
385: pqh_budget_pools_bk3.delete_reallocation_folder_a
386: (
387: p_folder_id => p_folder_id
388: ,p_object_version_number => l_object_version_number
389: ,p_effective_date => trunc(p_effective_date)

Line 454: l_transaction_id pqh_budget_pools.pool_id%TYPE;

450: ) is
451: --
452: -- Declare cursors and local variables
453: --
454: l_transaction_id pqh_budget_pools.pool_id%TYPE;
455: l_proc varchar2(72) := g_package||'create_reallocation_txn';
456: l_object_version_number pqh_budget_pools.object_version_number%TYPE;
457: --
458: begin

Line 456: l_object_version_number pqh_budget_pools.object_version_number%TYPE;

452: -- Declare cursors and local variables
453: --
454: l_transaction_id pqh_budget_pools.pool_id%TYPE;
455: l_proc varchar2(72) := g_package||'create_reallocation_txn';
456: l_object_version_number pqh_budget_pools.object_version_number%TYPE;
457: --
458: begin
459: --
460: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 481: pqh_budget_pools_bk4.create_reallocation_txn_b

477: begin
478: --
479: -- Start of API User Hook for the before hook of create_reallocation_txn
480: --
481: pqh_budget_pools_bk4.create_reallocation_txn_b
482: (
483: p_name => p_name
484: ,p_parent_folder_id => p_parent_folder_id
485: ,p_effective_date => trunc(p_effective_date)

Line 514: pqh_budget_pools_bk4.create_reallocation_txn_a

510: begin
511: --
512: -- Start of API User Hook for the after hook of create_reallocation_txn
513: --
514: pqh_budget_pools_bk4.create_reallocation_txn_a
515: (
516: p_transaction_id => l_transaction_id
517: ,p_name => p_name
518: ,p_parent_folder_id => p_parent_folder_id

Line 594: l_object_version_number pqh_budget_pools.object_version_number%TYPE;

590: --
591: -- Declare cursors and local variables
592: --
593: l_proc varchar2(72) := g_package||'update_reallocation_txn';
594: l_object_version_number pqh_budget_pools.object_version_number%TYPE;
595: --
596: begin
597: --
598: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 614: pqh_budget_pools_bk5.update_reallocation_txn_b

610: begin
611: --
612: -- Start of API User Hook for the before hook of update_reallocation_txn
613: --
614: pqh_budget_pools_bk5.update_reallocation_txn_b
615: (
616: p_transaction_id => p_transaction_id
617: ,p_name => p_name
618: ,p_parent_folder_id => p_parent_folder_id

Line 648: pqh_budget_pools_bk5.update_reallocation_txn_a

644: begin
645: --
646: -- Start of API User Hook for the after hook of update_reallocation_txn
647: --
648: pqh_budget_pools_bk5.update_reallocation_txn_a
649: (
650: p_transaction_id => p_transaction_id
651: ,p_name => p_name
652: ,p_parent_folder_id => p_parent_folder_id

Line 719: l_object_version_number pqh_budget_pools.object_version_number%TYPE;

715: --
716: -- Declare cursors and local variables
717: --
718: l_proc varchar2(72) := g_package||'delete_reallocation_txn';
719: l_object_version_number pqh_budget_pools.object_version_number%TYPE;
720: --
721: begin
722: --
723: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 740: pqh_budget_pools_bk6.delete_reallocation_txn_b

736: begin
737: --
738: -- Start of API User Hook for the before hook of delete_reallocation_txn
739: --
740: pqh_budget_pools_bk6.delete_reallocation_txn_b
741: (
742: p_transaction_id => p_transaction_id
743: ,p_object_version_number => p_object_version_number
744: ,p_effective_date => trunc(p_effective_date)

Line 767: pqh_budget_pools_bk6.delete_reallocation_txn_a

763: begin
764: --
765: -- Start of API User Hook for the after hook of delete_reallocation_txn
766: --
767: pqh_budget_pools_bk6.delete_reallocation_txn_a
768: (
769: p_transaction_id => p_transaction_id
770: ,p_object_version_number => l_object_version_number
771: ,p_effective_date => trunc(p_effective_date)

Line 819: end pqh_budget_pools_api;

815: end delete_reallocation_txn;
816: --
817: --
818:
819: end pqh_budget_pools_api;