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.OKL_SUBSIDY_POOL_AUTH_TRX_PVT dependencies on OKL_TRX_SUBSIDY_POOLS

Line 6: G_ADDITION_TYPE_CODE CONSTANT okl_trx_subsidy_pools.trx_type_code%TYPE DEFAULT 'ADDITION';

2: /* $Header: OKLRSIUB.pls 120.2.12010000.2 2008/10/01 22:34:17 rkuttiya ship $ */
3:
4: G_NO_SUB_POOL_TRX_FOUND CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_NO_SUB_POOL_TRX_FOUND';
5: G_TRX_SOURCE_TYPE_CODE CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'LEASE_CONTRACT';
6: G_ADDITION_TYPE_CODE CONSTANT okl_trx_subsidy_pools.trx_type_code%TYPE DEFAULT 'ADDITION';
7: G_REDUCTION_TYPE_CODE CONSTANT okl_trx_subsidy_pools.trx_type_code%TYPE DEFAULT 'REDUCTION';
8: G_CONTRACT_REVERSAL_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'REVERSE_CONTRACT';
9: G_CONTRACT_BOOK_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'ACTIVATE_CONTRACT';
10: G_CONTRACT_REBOOK_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'REBOOK_CONTRACT';

Line 7: G_REDUCTION_TYPE_CODE CONSTANT okl_trx_subsidy_pools.trx_type_code%TYPE DEFAULT 'REDUCTION';

3:
4: G_NO_SUB_POOL_TRX_FOUND CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_NO_SUB_POOL_TRX_FOUND';
5: G_TRX_SOURCE_TYPE_CODE CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'LEASE_CONTRACT';
6: G_ADDITION_TYPE_CODE CONSTANT okl_trx_subsidy_pools.trx_type_code%TYPE DEFAULT 'ADDITION';
7: G_REDUCTION_TYPE_CODE CONSTANT okl_trx_subsidy_pools.trx_type_code%TYPE DEFAULT 'REDUCTION';
8: G_CONTRACT_REVERSAL_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'REVERSE_CONTRACT';
9: G_CONTRACT_BOOK_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'ACTIVATE_CONTRACT';
10: G_CONTRACT_REBOOK_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'REBOOK_CONTRACT';
11: G_CONTRACT_SPLIT_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'SPLIT_CONTRACT';

Line 21: PROCEDURE pool_trx_khr_rbk(p_source_trx_date IN okl_trx_subsidy_pools.source_trx_date%TYPE

17: G_ORIG_CODE_QUOTE CONSTANT varchar2(30) := 'OKL_QUOTE';
18: -- end: cklee 07/12/2005
19:
20: -- local procedure 1. START
21: PROCEDURE pool_trx_khr_rbk(p_source_trx_date IN okl_trx_subsidy_pools.source_trx_date%TYPE
22: ,p_six_tbl IN okl_six_pvt.sixv_tbl_type
23: ,x_return_status OUT NOCOPY VARCHAR2)IS
24:
25: CURSOR c_get_pool_dates_csr(cp_subsidy_pool_id okl_subsidy_pools_b.id%TYPE) IS

Line 33: CURSOR c_get_pool_trx_details(cp_source_object_id okl_trx_subsidy_pools.source_object_id%TYPE

29: FROM okl_subsidy_pools_b
30: WHERE id = cp_subsidy_pool_id;
31: cv_get_pool_dates_csr c_get_pool_dates_csr%ROWTYPE;
32:
33: CURSOR c_get_pool_trx_details(cp_source_object_id okl_trx_subsidy_pools.source_object_id%TYPE
34: ,cp_subsidy_pool_id okl_trx_subsidy_pools.subsidy_pool_id%TYPE
35: ,cp_pool_currency_code okl_trx_subsidy_pools.subsidy_pool_currency_code%TYPE
36: ,cp_vendor_id okl_trx_subsidy_pools.vendor_id%TYPE
37: ,cp_asset_number okl_trx_subsidy_pools.dnz_asset_number%TYPE

Line 34: ,cp_subsidy_pool_id okl_trx_subsidy_pools.subsidy_pool_id%TYPE

30: WHERE id = cp_subsidy_pool_id;
31: cv_get_pool_dates_csr c_get_pool_dates_csr%ROWTYPE;
32:
33: CURSOR c_get_pool_trx_details(cp_source_object_id okl_trx_subsidy_pools.source_object_id%TYPE
34: ,cp_subsidy_pool_id okl_trx_subsidy_pools.subsidy_pool_id%TYPE
35: ,cp_pool_currency_code okl_trx_subsidy_pools.subsidy_pool_currency_code%TYPE
36: ,cp_vendor_id okl_trx_subsidy_pools.vendor_id%TYPE
37: ,cp_asset_number okl_trx_subsidy_pools.dnz_asset_number%TYPE
38: ,cp_subsidy_id okl_trx_subsidy_pools.subsidy_id%TYPE

Line 35: ,cp_pool_currency_code okl_trx_subsidy_pools.subsidy_pool_currency_code%TYPE

31: cv_get_pool_dates_csr c_get_pool_dates_csr%ROWTYPE;
32:
33: CURSOR c_get_pool_trx_details(cp_source_object_id okl_trx_subsidy_pools.source_object_id%TYPE
34: ,cp_subsidy_pool_id okl_trx_subsidy_pools.subsidy_pool_id%TYPE
35: ,cp_pool_currency_code okl_trx_subsidy_pools.subsidy_pool_currency_code%TYPE
36: ,cp_vendor_id okl_trx_subsidy_pools.vendor_id%TYPE
37: ,cp_asset_number okl_trx_subsidy_pools.dnz_asset_number%TYPE
38: ,cp_subsidy_id okl_trx_subsidy_pools.subsidy_id%TYPE
39: ,cp_trx_amount okl_trx_subsidy_pools.trx_amount%TYPE

Line 36: ,cp_vendor_id okl_trx_subsidy_pools.vendor_id%TYPE

32:
33: CURSOR c_get_pool_trx_details(cp_source_object_id okl_trx_subsidy_pools.source_object_id%TYPE
34: ,cp_subsidy_pool_id okl_trx_subsidy_pools.subsidy_pool_id%TYPE
35: ,cp_pool_currency_code okl_trx_subsidy_pools.subsidy_pool_currency_code%TYPE
36: ,cp_vendor_id okl_trx_subsidy_pools.vendor_id%TYPE
37: ,cp_asset_number okl_trx_subsidy_pools.dnz_asset_number%TYPE
38: ,cp_subsidy_id okl_trx_subsidy_pools.subsidy_id%TYPE
39: ,cp_trx_amount okl_trx_subsidy_pools.trx_amount%TYPE
40: ,cp_trx_currency_code okl_trx_subsidy_pools.trx_currency_code%TYPE

Line 37: ,cp_asset_number okl_trx_subsidy_pools.dnz_asset_number%TYPE

33: CURSOR c_get_pool_trx_details(cp_source_object_id okl_trx_subsidy_pools.source_object_id%TYPE
34: ,cp_subsidy_pool_id okl_trx_subsidy_pools.subsidy_pool_id%TYPE
35: ,cp_pool_currency_code okl_trx_subsidy_pools.subsidy_pool_currency_code%TYPE
36: ,cp_vendor_id okl_trx_subsidy_pools.vendor_id%TYPE
37: ,cp_asset_number okl_trx_subsidy_pools.dnz_asset_number%TYPE
38: ,cp_subsidy_id okl_trx_subsidy_pools.subsidy_id%TYPE
39: ,cp_trx_amount okl_trx_subsidy_pools.trx_amount%TYPE
40: ,cp_trx_currency_code okl_trx_subsidy_pools.trx_currency_code%TYPE
41: ) IS

Line 38: ,cp_subsidy_id okl_trx_subsidy_pools.subsidy_id%TYPE

34: ,cp_subsidy_pool_id okl_trx_subsidy_pools.subsidy_pool_id%TYPE
35: ,cp_pool_currency_code okl_trx_subsidy_pools.subsidy_pool_currency_code%TYPE
36: ,cp_vendor_id okl_trx_subsidy_pools.vendor_id%TYPE
37: ,cp_asset_number okl_trx_subsidy_pools.dnz_asset_number%TYPE
38: ,cp_subsidy_id okl_trx_subsidy_pools.subsidy_id%TYPE
39: ,cp_trx_amount okl_trx_subsidy_pools.trx_amount%TYPE
40: ,cp_trx_currency_code okl_trx_subsidy_pools.trx_currency_code%TYPE
41: ) IS
42: SELECT trx_reason_code

Line 39: ,cp_trx_amount okl_trx_subsidy_pools.trx_amount%TYPE

35: ,cp_pool_currency_code okl_trx_subsidy_pools.subsidy_pool_currency_code%TYPE
36: ,cp_vendor_id okl_trx_subsidy_pools.vendor_id%TYPE
37: ,cp_asset_number okl_trx_subsidy_pools.dnz_asset_number%TYPE
38: ,cp_subsidy_id okl_trx_subsidy_pools.subsidy_id%TYPE
39: ,cp_trx_amount okl_trx_subsidy_pools.trx_amount%TYPE
40: ,cp_trx_currency_code okl_trx_subsidy_pools.trx_currency_code%TYPE
41: ) IS
42: SELECT trx_reason_code
43: ,subsidy_pool_amount

Line 40: ,cp_trx_currency_code okl_trx_subsidy_pools.trx_currency_code%TYPE

36: ,cp_vendor_id okl_trx_subsidy_pools.vendor_id%TYPE
37: ,cp_asset_number okl_trx_subsidy_pools.dnz_asset_number%TYPE
38: ,cp_subsidy_id okl_trx_subsidy_pools.subsidy_id%TYPE
39: ,cp_trx_amount okl_trx_subsidy_pools.trx_amount%TYPE
40: ,cp_trx_currency_code okl_trx_subsidy_pools.trx_currency_code%TYPE
41: ) IS
42: SELECT trx_reason_code
43: ,subsidy_pool_amount
44: ,conversion_rate

Line 45: FROM okl_trx_subsidy_pools

41: ) IS
42: SELECT trx_reason_code
43: ,subsidy_pool_amount
44: ,conversion_rate
45: FROM okl_trx_subsidy_pools
46: WHERE trx_type_code = 'REDUCTION'
47: AND source_type_code = G_TRX_SOURCE_TYPE_CODE
48: AND source_object_id = cp_source_object_id
49: AND subsidy_pool_id = cp_subsidy_pool_id

Line 177: ,p_source_trx_date IN okl_trx_subsidy_pools.source_trx_date%TYPE

173: -- local procedure 1. END
174:
175: -- local procedure 2. START
176: PROCEDURE reduce_pool_balance(p_khr_id IN okc_k_headers_b.id%TYPE
177: ,p_source_trx_date IN okl_trx_subsidy_pools.source_trx_date%TYPE
178: ,x_return_status OUT NOCOPY VARCHAR2) IS
179:
180: -- cursor to fetch all subsidies attached to assets on the contract
181: CURSOR c_subsidy_csr(cp_chr_id IN okc_k_headers_b.id%TYPE) IS

Line 552: ,p_override_trx_reason IN okl_trx_subsidy_pools.trx_reason_code%TYPE

548: ,x_msg_count OUT NOCOPY NUMBER
549: ,x_msg_data OUT NOCOPY VARCHAR2
550: ,p_chr_id IN okc_k_headers_b.id%TYPE
551: ,p_reversal_date IN DATE
552: ,p_override_trx_reason IN okl_trx_subsidy_pools.trx_reason_code%TYPE
553: ) IS
554:
555: -- cursor to fetch all subsidies attached in the contract
556: CURSOR c_subsidy_csr(cp_chr_id IN okc_k_headers_b.id%TYPE) IS

Line 605: FROM okl_trx_subsidy_pools

601: ,trx_amount
602: ,subsidy_pool_currency_code
603: ,subsidy_pool_amount
604: ,conversion_rate
605: FROM okl_trx_subsidy_pools
606: WHERE source_object_id = cp_chr_id
607: AND dnz_asset_number = cp_asset_number
608: AND subsidy_id = cp_subsidy_id
609: AND subsidy_pool_id = cp_subsidy_pool_id

Line 669: -- for that subsidy in the okl_trx_subsidy_pools table

665: -- now that the pool is applicable, verify if there exists a pool transaction for the contract, asset, subsidy, subsidy_pool,
666: -- and trx_type_code of REDUCTION. this record should be present for reversal. if the record is not found then we need to
667: -- raise an error. this is because the transaction reversal cannot be done until the transaction was not created in the first instance
668: -- there can never be the case that a subsidy pool is applicable to a subsidy and there are no REDUCTION type transactions
669: -- for that subsidy in the okl_trx_subsidy_pools table
670: OPEN c_sub_pool_trx_csr(cp_chr_id => p_chr_id
671: ,cp_asset_number => c_subsidy_csr_rec.asset_number
672: ,cp_subsidy_id => c_subsidy_csr_rec.subsidy_id
673: ,cp_subsidy_pool_id => lx_sub_pool_id

Line 985: lv_source_trx_date okl_trx_subsidy_pools.source_trx_date%TYPE;

981: --
982: AND CHR.id = p_rbk_chr_id
983: AND CHR.ORIG_SYSTEM_SOURCE_CODE = 'OKL_REBOOK';
984:
985: lv_source_trx_date okl_trx_subsidy_pools.source_trx_date%TYPE;
986: -- counter to manage all pool transaction rows.
987: idx PLS_INTEGER;
988:
989: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'POOL_TRX_KHR_RBK';