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_BDGT_POOL_REALLOCTIONS_API dependencies on PQH_BDGT_POOL_REALLOCTIONS

Line 1: Package Body pqh_bdgt_pool_realloctions_api as

1: Package Body pqh_bdgt_pool_realloctions_api as
2: /* $Header: pqbreapi.pkb 115.7 2003/04/02 13:22:47 ggnanagu noship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: pqbreapi.pkb 115.7 2003/04/02 13:22:47 ggnanagu noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' pqh_bdgt_pool_realloctions_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_realloc_txn_dtl >----------------------|
10: -- ----------------------------------------------------------------------------

Line 26: l_txn_detail_id pqh_bdgt_pool_realloctions.reallocation_id%TYPE;

22: ) is
23: --
24: -- Declare cursors and local variables
25: --
26: l_txn_detail_id pqh_bdgt_pool_realloctions.reallocation_id%TYPE;
27: l_proc varchar2(72) := g_package||'create_realloc_txn_dtl';
28: l_object_version_number pqh_bdgt_pool_realloctions.object_version_number%TYPE;
29: --
30: begin

Line 28: l_object_version_number pqh_bdgt_pool_realloctions.object_version_number%TYPE;

24: -- Declare cursors and local variables
25: --
26: l_txn_detail_id pqh_bdgt_pool_realloctions.reallocation_id%TYPE;
27: l_proc varchar2(72) := g_package||'create_realloc_txn_dtl';
28: l_object_version_number pqh_bdgt_pool_realloctions.object_version_number%TYPE;
29: --
30: begin
31: --
32: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 46: pqh_bdgt_pool_realloctions_bk1.create_realloc_txn_dtl_b

42: begin
43: --
44: -- Start of API User Hook for the before hook of create_realloc_txn_dtl
45: --
46: pqh_bdgt_pool_realloctions_bk1.create_realloc_txn_dtl_b
47: (
48: p_transaction_id => p_transaction_id
49: ,p_transaction_type => p_transaction_type
50: ,p_entity_id => p_entity_id

Line 80: pqh_bdgt_pool_realloctions_bk1.create_realloc_txn_dtl_a

76: begin
77: --
78: -- Start of API User Hook for the after hook of create_realloc_txn_dtl
79: --
80: pqh_bdgt_pool_realloctions_bk1.create_realloc_txn_dtl_a
81: (
82: p_txn_detail_id => l_txn_detail_id
83: ,p_transaction_id => p_transaction_id
84: ,p_transaction_type => p_transaction_type

Line 159: l_object_version_number pqh_bdgt_pool_realloctions.object_version_number%TYPE;

155: --
156: -- Declare cursors and local variables
157: --
158: l_proc varchar2(72) := g_package||'update_realloc_txn_dtl';
159: l_object_version_number pqh_bdgt_pool_realloctions.object_version_number%TYPE;
160: --
161: begin
162: --
163: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 179: pqh_bdgt_pool_realloctions_bk2.update_realloc_txn_dtl_b

175: begin
176: --
177: -- Start of API User Hook for the before hook of update_realloc_txn_dtl
178: --
179: pqh_bdgt_pool_realloctions_bk2.update_realloc_txn_dtl_b
180: (
181: p_transaction_id => p_transaction_id
182: ,p_transaction_type => p_transaction_type
183: ,p_entity_id => p_entity_id

Line 214: pqh_bdgt_pool_realloctions_bk2.update_realloc_txn_dtl_a

210: begin
211: --
212: -- Start of API User Hook for the after hook of update_realloc_txn_dtl
213: --
214: pqh_bdgt_pool_realloctions_bk2.update_realloc_txn_dtl_a
215: (
216: p_transaction_id => p_transaction_id
217: ,p_transaction_type => p_transaction_type
218: ,p_entity_id => p_entity_id

Line 284: l_object_version_number pqh_bdgt_pool_realloctions.object_version_number%TYPE;

280: --
281: -- Declare cursors and local variables
282: --
283: l_proc varchar2(72) := g_package||'delete_realloc_txn_dtl';
284: l_object_version_number pqh_bdgt_pool_realloctions.object_version_number%TYPE;
285: --
286: begin
287: --
288: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 305: pqh_bdgt_pool_realloctions_bk3.delete_realloc_txn_dtl_b

301: begin
302: --
303: -- Start of API User Hook for the before hook of delete_realloc_txn_dtl
304: --
305: pqh_bdgt_pool_realloctions_bk3.delete_realloc_txn_dtl_b
306: (
307: p_txn_detail_id => p_txn_detail_id
308: ,p_object_version_number => p_object_version_number
309: );

Line 331: pqh_bdgt_pool_realloctions_bk3.delete_realloc_txn_dtl_a

327: begin
328: --
329: -- Start of API User Hook for the after hook of delete_realloc_txn_dtl
330: --
331: pqh_bdgt_pool_realloctions_bk3.delete_realloc_txn_dtl_a
332: (
333: p_txn_detail_id => p_txn_detail_id
334: ,p_object_version_number => l_object_version_number
335: );

Line 403: l_reallocation_period_id pqh_bdgt_pool_realloctions.reallocation_id%TYPE;

399: ) is
400: --
401: -- Declare cursors and local variables
402: --
403: l_reallocation_period_id pqh_bdgt_pool_realloctions.reallocation_id%TYPE;
404: l_proc varchar2(72) := g_package||'create_realloc_txn_period';
405: l_object_version_number pqh_bdgt_pool_realloctions.object_version_number%TYPE;
406: --
407: Cursor csr_prd_txn_id IS

Line 405: l_object_version_number pqh_bdgt_pool_realloctions.object_version_number%TYPE;

401: -- Declare cursors and local variables
402: --
403: l_reallocation_period_id pqh_bdgt_pool_realloctions.reallocation_id%TYPE;
404: l_proc varchar2(72) := g_package||'create_realloc_txn_period';
405: l_object_version_number pqh_bdgt_pool_realloctions.object_version_number%TYPE;
406: --
407: Cursor csr_prd_txn_id IS
408: SELECT pool_id
409: FROM pqh_bdgt_pool_realloctions txndtl

Line 409: FROM pqh_bdgt_pool_realloctions txndtl

405: l_object_version_number pqh_bdgt_pool_realloctions.object_version_number%TYPE;
406: --
407: Cursor csr_prd_txn_id IS
408: SELECT pool_id
409: FROM pqh_bdgt_pool_realloctions txndtl
410: WHERE txndtl.reallocation_id = p_txn_detail_id;
411: l_transaction_id NUMBER(15);
412: Cursor csr_dup_rcvr_period(p_transaction_id NUMBER) IS
413: SELECT 1

Line 415: pqh_bdgt_pool_realloctions txndtl,

411: l_transaction_id NUMBER(15);
412: Cursor csr_dup_rcvr_period(p_transaction_id NUMBER) IS
413: SELECT 1
414: FROM pqh_budget_pools txn,
415: pqh_bdgt_pool_realloctions txndtl,
416: pqh_bdgt_pool_realloctions txnprd
417: WHERE txn.pool_id = p_transaction_id
418: AND txndtl.pool_id = txn.pool_id
419: AND txndtl.reallocation_id = txnprd.txn_detail_id

Line 416: pqh_bdgt_pool_realloctions txnprd

412: Cursor csr_dup_rcvr_period(p_transaction_id NUMBER) IS
413: SELECT 1
414: FROM pqh_budget_pools txn,
415: pqh_bdgt_pool_realloctions txndtl,
416: pqh_bdgt_pool_realloctions txnprd
417: WHERE txn.pool_id = p_transaction_id
418: AND txndtl.pool_id = txn.pool_id
419: AND txndtl.reallocation_id = txnprd.txn_detail_id
420: AND NVL(txnprd.entity_id,-1) = NVL(p_entity_id,-1)

Line 458: pqh_bdgt_pool_realloctions_bk4.create_realloc_txn_period_b

454: begin
455: --
456: -- Start of API User Hook for the before hook of create_realloc_txn_period
457: --
458: pqh_bdgt_pool_realloctions_bk4.create_realloc_txn_period_b
459: (
460: p_txn_detail_id => p_txn_detail_id
461: ,p_transaction_type => p_transaction_type
462: ,p_entity_id => p_entity_id

Line 500: pqh_bdgt_pool_realloctions_bk4.create_realloc_txn_period_a

496: begin
497: --
498: -- Start of API User Hook for the after hook of create_realloc_txn_period
499: --
500: pqh_bdgt_pool_realloctions_bk4.create_realloc_txn_period_a
501: (
502: p_txn_detail_id => p_txn_detail_id
503: ,p_transaction_type => p_transaction_type
504: ,p_entity_id => p_entity_id

Line 587: l_object_version_number pqh_bdgt_pool_realloctions.object_version_number%TYPE;

583: --
584: -- Declare cursors and local variables
585: --
586: l_proc varchar2(72) := g_package||'update_realloc_txn_period';
587: l_object_version_number pqh_bdgt_pool_realloctions.object_version_number%TYPE;
588: --
589: Cursor csr_prd_txn_id IS
590: SELECT pool_id
591: FROM pqh_bdgt_pool_realloctions txndtl

Line 591: FROM pqh_bdgt_pool_realloctions txndtl

587: l_object_version_number pqh_bdgt_pool_realloctions.object_version_number%TYPE;
588: --
589: Cursor csr_prd_txn_id IS
590: SELECT pool_id
591: FROM pqh_bdgt_pool_realloctions txndtl
592: WHERE txndtl.reallocation_id = p_txn_detail_id;
593: l_transaction_id NUMBER(15);
594: Cursor csr_dup_rcvr_period(p_transaction_id NUMBER) IS
595: SELECT 1

Line 597: pqh_bdgt_pool_realloctions txndtl,

593: l_transaction_id NUMBER(15);
594: Cursor csr_dup_rcvr_period(p_transaction_id NUMBER) IS
595: SELECT 1
596: FROM pqh_budget_pools txn,
597: pqh_bdgt_pool_realloctions txndtl,
598: pqh_bdgt_pool_realloctions txnprd
599: WHERE txn.pool_id = p_transaction_id
600: AND txndtl.pool_id = txn.pool_id
601: AND txndtl.reallocation_id = txnprd.txn_detail_id

Line 598: pqh_bdgt_pool_realloctions txnprd

594: Cursor csr_dup_rcvr_period(p_transaction_id NUMBER) IS
595: SELECT 1
596: FROM pqh_budget_pools txn,
597: pqh_bdgt_pool_realloctions txndtl,
598: pqh_bdgt_pool_realloctions txnprd
599: WHERE txn.pool_id = p_transaction_id
600: AND txndtl.pool_id = txn.pool_id
601: AND txndtl.reallocation_id = txnprd.txn_detail_id
602: AND NVL(txnprd.entity_id,-1) = NVL(p_entity_id,-1)

Line 641: pqh_bdgt_pool_realloctions_bk5.update_realloc_txn_period_b

637: begin
638: --
639: -- Start of API User Hook for the before hook of update_realloc_txn_period
640: --
641: pqh_bdgt_pool_realloctions_bk5.update_realloc_txn_period_b
642: (
643: p_txn_detail_id => p_txn_detail_id
644: ,p_transaction_type => p_transaction_type
645: ,p_entity_id => p_entity_id

Line 684: pqh_bdgt_pool_realloctions_bk5.update_realloc_txn_period_a

680: begin
681: --
682: -- Start of API User Hook for the after hook of update_realloc_txn_period
683: --
684: pqh_bdgt_pool_realloctions_bk5.update_realloc_txn_period_a
685: (
686: p_txn_detail_id => p_txn_detail_id
687: ,p_transaction_type => p_transaction_type
688: ,p_entity_id => p_entity_id

Line 758: l_object_version_number pqh_bdgt_pool_realloctions.object_version_number%TYPE;

754: --
755: -- Declare cursors and local variables
756: --
757: l_proc varchar2(72) := g_package||'delete_realloc_txn_period';
758: l_object_version_number pqh_bdgt_pool_realloctions.object_version_number%TYPE;
759: --
760: begin
761: --
762: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 779: pqh_bdgt_pool_realloctions_bk6.delete_realloc_txn_period_b

775: begin
776: --
777: -- Start of API User Hook for the before hook of delete_realloc_txn_period
778: --
779: pqh_bdgt_pool_realloctions_bk6.delete_realloc_txn_period_b
780: (
781: p_reallocation_period_id => p_reallocation_period_id
782: ,p_object_version_number => p_object_version_number
783: );

Line 805: pqh_bdgt_pool_realloctions_bk6.delete_realloc_txn_period_a

801: begin
802: --
803: -- Start of API User Hook for the after hook of delete_realloc_txn_period
804: --
805: pqh_bdgt_pool_realloctions_bk6.delete_realloc_txn_period_a
806: (
807: p_reallocation_period_id => p_reallocation_period_id
808: ,p_object_version_number => l_object_version_number
809: );

Line 855: end pqh_bdgt_pool_realloctions_api;

851: --
852: end delete_realloc_txn_period;
853: --
854: --
855: end pqh_bdgt_pool_realloctions_api;