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_SEEDED_FUNCTIONS_PVT dependencies on OKL_K_HEADERS_FULL_V

Line 3026: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS

3022: l_year NUMBER;
3023: l_contract_number VARCHAR2(2000);
3024:
3025: -- cursor to get the contract number
3026: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
3027: SELECT contract_number
3028: FROM OKC_K_HEADERS_B
3029: WHERE id = p_ctr_id;
3030:

Line 3145: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS

3141: l_total_rate NUMBER;
3142: l_contract_number VARCHAR2(2000);
3143:
3144: -- cursor to get the contract number
3145: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
3146: SELECT contract_number
3147: FROM OKC_K_HEADERS_B
3148: WHERE id = p_ctr_id;
3149:

Line 3528: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS

3524:
3525: -- cursor to get the contract number
3526: -- 02-Oct-2003. SGIYER. Added condition ste.stream_element_date >= p_date
3527: -- on product management's instructions.
3528: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
3529: SELECT contract_number
3530: FROM OKL_K_HEADERS_FULL_V
3531: WHERE id = p_ctr_id;
3532:

Line 3530: FROM OKL_K_HEADERS_FULL_V

3526: -- 02-Oct-2003. SGIYER. Added condition ste.stream_element_date >= p_date
3527: -- on product management's instructions.
3528: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
3529: SELECT contract_number
3530: FROM OKL_K_HEADERS_FULL_V
3531: WHERE id = p_ctr_id;
3532:
3533: -- SGIYER
3534: -- modifying cursor for user defind streams project

Line 3648: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS

3644: l_lease_inc_sty_id NUMBER;
3645: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3646:
3647: -- cursor to get the contract number
3648: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
3649: SELECT contract_number
3650: FROM OKL_K_HEADERS_FULL_V
3651: WHERE id = p_ctr_id;
3652:

Line 3650: FROM OKL_K_HEADERS_FULL_V

3646:
3647: -- cursor to get the contract number
3648: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
3649: SELECT contract_number
3650: FROM OKL_K_HEADERS_FULL_V
3651: WHERE id = p_ctr_id;
3652:
3653: -- changing stream type name from INCOME to PRE TAX INCOME as suggested by PM. BUG# 2671223
3654: -- correcting name. Its hould be PRE-TAX INCOME (with hyphen)

Line 3807: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS

3803: l_unguaranteed_residual NUMBER := 0;
3804: l_contract_number VARCHAR2(2000);
3805:
3806: -- cursor to get the contract number
3807: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
3808: SELECT contract_number
3809: FROM OKL_K_HEADERS_FULL_V
3810: WHERE id = p_ctr_id;
3811:

Line 3809: FROM OKL_K_HEADERS_FULL_V

3805:
3806: -- cursor to get the contract number
3807: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
3808: SELECT contract_number
3809: FROM OKL_K_HEADERS_FULL_V
3810: WHERE id = p_ctr_id;
3811:
3812: CURSOR get_ung_res_csr(p_ctr_id NUMBER) IS
3813: SELECT SUM(NVL(RESIDUAL_VALUE,0)) - SUM(NVL(RESIDUAL_GRNTY_AMOUNT, 0))

Line 3884: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS

3880: l_subsidy_inc_id NUMBER;
3881: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3882:
3883: -- cursor to get the contract number
3884: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
3885: SELECT contract_number
3886: FROM OKL_K_HEADERS_FULL_V
3887: WHERE id = p_ctr_id;
3888:

Line 3886: FROM OKL_K_HEADERS_FULL_V

3882:
3883: -- cursor to get the contract number
3884: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
3885: SELECT contract_number
3886: FROM OKL_K_HEADERS_FULL_V
3887: WHERE id = p_ctr_id;
3888:
3889: -- cursor to get unaccrued subsidy for a contract
3890: CURSOR unaccrued_subsidy_csr(p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE, p_date DATE, p_subsidy_inc_id NUMBER) IS

Line 3890: CURSOR unaccrued_subsidy_csr(p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE, p_date DATE, p_subsidy_inc_id NUMBER) IS

3886: FROM OKL_K_HEADERS_FULL_V
3887: WHERE id = p_ctr_id;
3888:
3889: -- cursor to get unaccrued subsidy for a contract
3890: CURSOR unaccrued_subsidy_csr(p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE, p_date DATE, p_subsidy_inc_id NUMBER) IS
3891: SELECT SUM(ste.amount)
3892: FROM OKL_STRM_ELEMENTS ste,
3893: OKL_STRM_TYPE_B sty,
3894: OKL_STREAMS stm

Line 4079: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS

4075: l_sty_id NUMBER;
4076: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4077:
4078: -- cursor to get the contract number
4079: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
4080: SELECT contract_number
4081: FROM OKL_K_HEADERS_FULL_V
4082: WHERE id = p_ctr_id;
4083:

Line 4081: FROM OKL_K_HEADERS_FULL_V

4077:
4078: -- cursor to get the contract number
4079: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
4080: SELECT contract_number
4081: FROM OKL_K_HEADERS_FULL_V
4082: WHERE id = p_ctr_id;
4083:
4084: -- cursor to get unaccrued subsidy for a contract
4085: CURSOR total_accrued_csr(p_ctr_id NUMBER, p_date DATE, p_sty_id NUMBER) IS

Line 5770: p_contract_currency okl_k_headers_full_v.currency_code%TYPE;

5766: l_depn_contract NUMBER := 0;
5767: l_converted_amount NUMBER := 0;
5768: p_return_status VARCHAR2(1);
5769: p_contract_start_date DATE;
5770: p_contract_currency okl_k_headers_full_v.currency_code%TYPE;
5771: p_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
5772: p_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
5773: p_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
5774:

Line 5771: p_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;

5767: l_converted_amount NUMBER := 0;
5768: p_return_status VARCHAR2(1);
5769: p_contract_start_date DATE;
5770: p_contract_currency okl_k_headers_full_v.currency_code%TYPE;
5771: p_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
5772: p_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
5773: p_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
5774:
5775: --Cursor to get the parent line id for a contract

Line 5772: p_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

5768: p_return_status VARCHAR2(1);
5769: p_contract_start_date DATE;
5770: p_contract_currency okl_k_headers_full_v.currency_code%TYPE;
5771: p_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
5772: p_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
5773: p_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
5774:
5775: --Cursor to get the parent line id for a contract
5776: CURSOR parent_line_id_csr (p_contract_id NUMBER)

Line 5773: p_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

5769: p_contract_start_date DATE;
5770: p_contract_currency okl_k_headers_full_v.currency_code%TYPE;
5771: p_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
5772: p_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
5773: p_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
5774:
5775: --Cursor to get the parent line id for a contract
5776: CURSOR parent_line_id_csr (p_contract_id NUMBER)
5777: IS

Line 6400: p_contract_currency okl_k_headers_full_v.currency_code%TYPE;

6396: l_depn_contract NUMBER := 0;
6397: l_converted_amount NUMBER := 0;
6398: p_return_status VARCHAR2(1);
6399: p_contract_start_date DATE;
6400: p_contract_currency okl_k_headers_full_v.currency_code%TYPE;
6401: p_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
6402: p_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
6403: p_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
6404:

Line 6401: p_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;

6397: l_converted_amount NUMBER := 0;
6398: p_return_status VARCHAR2(1);
6399: p_contract_start_date DATE;
6400: p_contract_currency okl_k_headers_full_v.currency_code%TYPE;
6401: p_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
6402: p_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
6403: p_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
6404:
6405: --Cursor to get the parent line id for a contract

Line 6402: p_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

6398: p_return_status VARCHAR2(1);
6399: p_contract_start_date DATE;
6400: p_contract_currency okl_k_headers_full_v.currency_code%TYPE;
6401: p_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
6402: p_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
6403: p_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
6404:
6405: --Cursor to get the parent line id for a contract
6406: CURSOR parent_line_id_csr (p_contract_id NUMBER)

Line 6403: p_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

6399: p_contract_start_date DATE;
6400: p_contract_currency okl_k_headers_full_v.currency_code%TYPE;
6401: p_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
6402: p_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
6403: p_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
6404:
6405: --Cursor to get the parent line id for a contract
6406: CURSOR parent_line_id_csr (p_contract_id NUMBER)
6407: IS

Line 10795: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;

10791: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
10792:
10793: l_converted_amount NUMBER;
10794: l_contract_start_date DATE;
10795: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
10796: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
10797: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
10798: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
10799:

Line 10796: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;

10792:
10793: l_converted_amount NUMBER;
10794: l_contract_start_date DATE;
10795: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
10796: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
10797: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
10798: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
10799:
10800: -- Bug# 4061058:

Line 10797: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;

10793: l_converted_amount NUMBER;
10794: l_contract_start_date DATE;
10795: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
10796: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
10797: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
10798: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
10799:
10800: -- Bug# 4061058:
10801: -- Changes to ensure that the query works for Release Asset

Line 10798: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;

10794: l_contract_start_date DATE;
10795: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
10796: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
10797: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
10798: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
10799:
10800: -- Bug# 4061058:
10801: -- Changes to ensure that the query works for Release Asset
10802: -- and Release Contract

Line 11018: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;

11014: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
11015:
11016: l_converted_amount NUMBER;
11017: l_contract_start_date DATE;
11018: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
11019: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
11020: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
11021: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
11022:

Line 11019: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;

11015:
11016: l_converted_amount NUMBER;
11017: l_contract_start_date DATE;
11018: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
11019: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
11020: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
11021: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
11022:
11023: -- Bug# 4061058:

Line 11020: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;

11016: l_converted_amount NUMBER;
11017: l_contract_start_date DATE;
11018: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
11019: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
11020: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
11021: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
11022:
11023: -- Bug# 4061058:
11024: -- Changes to ensure that the query works for Release Asset

Line 11021: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;

11017: l_contract_start_date DATE;
11018: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
11019: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
11020: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
11021: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
11022:
11023: -- Bug# 4061058:
11024: -- Changes to ensure that the query works for Release Asset
11025: -- and Release Contract

Line 14017: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;

14013: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
14014:
14015: l_converted_amount NUMBER;
14016: l_contract_start_date DATE;
14017: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
14018: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
14019: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
14020: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
14021:

Line 14018: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;

14014:
14015: l_converted_amount NUMBER;
14016: l_contract_start_date DATE;
14017: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
14018: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
14019: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
14020: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
14021:
14022: CURSOR l_asset_csr(p_chr_id IN NUMBER

Line 14019: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;

14015: l_converted_amount NUMBER;
14016: l_contract_start_date DATE;
14017: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
14018: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
14019: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
14020: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
14021:
14022: CURSOR l_asset_csr(p_chr_id IN NUMBER
14023: ,p_cle_id IN NUMBER

Line 14020: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;

14016: l_contract_start_date DATE;
14017: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
14018: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
14019: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
14020: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
14021:
14022: CURSOR l_asset_csr(p_chr_id IN NUMBER
14023: ,p_cle_id IN NUMBER
14024: ,p_book_class IN VARCHAR2 -- 7626121