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 3490: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS

3486: l_year NUMBER;
3487: l_contract_number VARCHAR2(2000);
3488:
3489: -- cursor to get the contract number
3490: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
3491: SELECT contract_number
3492: FROM OKC_K_HEADERS_B
3493: WHERE id = p_ctr_id;
3494:

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

3605: l_total_rate NUMBER;
3606: l_contract_number VARCHAR2(2000);
3607:
3608: -- cursor to get the contract number
3609: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
3610: SELECT contract_number
3611: FROM OKC_K_HEADERS_B
3612: WHERE id = p_ctr_id;
3613:

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

3995:
3996: -- cursor to get the contract number
3997: -- 02-Oct-2003. SGIYER. Added condition ste.stream_element_date >= p_date
3998: -- on product management's instructions.
3999: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
4000: SELECT contract_number
4001: FROM OKL_K_HEADERS_FULL_V
4002: WHERE id = p_ctr_id;
4003:

Line 4001: FROM OKL_K_HEADERS_FULL_V

3997: -- 02-Oct-2003. SGIYER. Added condition ste.stream_element_date >= p_date
3998: -- on product management's instructions.
3999: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
4000: SELECT contract_number
4001: FROM OKL_K_HEADERS_FULL_V
4002: WHERE id = p_ctr_id;
4003:
4004: -- SGIYER
4005: -- modifying cursor for user defind streams project

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

4115: l_lease_inc_sty_id NUMBER;
4116: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4117:
4118: -- cursor to get the contract number
4119: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
4120: SELECT contract_number
4121: FROM OKL_K_HEADERS_FULL_V
4122: WHERE id = p_ctr_id;
4123:

Line 4121: FROM OKL_K_HEADERS_FULL_V

4117:
4118: -- cursor to get the contract number
4119: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
4120: SELECT contract_number
4121: FROM OKL_K_HEADERS_FULL_V
4122: WHERE id = p_ctr_id;
4123:
4124: -- changing stream type name from INCOME to PRE TAX INCOME as suggested by PM. BUG# 2671223
4125: -- correcting name. Its hould be PRE-TAX INCOME (with hyphen)

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

4366: l_unguaranteed_residual NUMBER := 0;
4367: l_contract_number VARCHAR2(2000);
4368:
4369: -- cursor to get the contract number
4370: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
4371: SELECT contract_number
4372: FROM OKL_K_HEADERS_FULL_V
4373: WHERE id = p_ctr_id;
4374:

Line 4372: FROM OKL_K_HEADERS_FULL_V

4368:
4369: -- cursor to get the contract number
4370: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
4371: SELECT contract_number
4372: FROM OKL_K_HEADERS_FULL_V
4373: WHERE id = p_ctr_id;
4374:
4375: CURSOR get_ung_res_csr(p_ctr_id NUMBER) IS
4376: SELECT SUM(NVL(RESIDUAL_VALUE,0)) - SUM(NVL(RESIDUAL_GRNTY_AMOUNT, 0))

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

4443: l_subsidy_inc_id NUMBER;
4444: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4445:
4446: -- cursor to get the contract number
4447: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
4448: SELECT contract_number
4449: FROM OKL_K_HEADERS_FULL_V
4450: WHERE id = p_ctr_id;
4451:

Line 4449: FROM OKL_K_HEADERS_FULL_V

4445:
4446: -- cursor to get the contract number
4447: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
4448: SELECT contract_number
4449: FROM OKL_K_HEADERS_FULL_V
4450: WHERE id = p_ctr_id;
4451:
4452: -- cursor to get unaccrued subsidy for a contract
4453: CURSOR unaccrued_subsidy_csr(p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE, p_date DATE, p_subsidy_inc_id NUMBER) IS

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

4449: FROM OKL_K_HEADERS_FULL_V
4450: WHERE id = p_ctr_id;
4451:
4452: -- cursor to get unaccrued subsidy for a contract
4453: CURSOR unaccrued_subsidy_csr(p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE, p_date DATE, p_subsidy_inc_id NUMBER) IS
4454: SELECT SUM(ste.amount)
4455: FROM OKL_STRM_ELEMENTS ste,
4456: OKL_STRM_TYPE_B sty,
4457: OKL_STREAMS stm

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

4638: l_sty_id NUMBER;
4639: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4640:
4641: -- cursor to get the contract number
4642: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
4643: SELECT contract_number
4644: FROM OKL_K_HEADERS_FULL_V
4645: WHERE id = p_ctr_id;
4646:

Line 4644: FROM OKL_K_HEADERS_FULL_V

4640:
4641: -- cursor to get the contract number
4642: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
4643: SELECT contract_number
4644: FROM OKL_K_HEADERS_FULL_V
4645: WHERE id = p_ctr_id;
4646:
4647:
4648: -- cursor to get unaccrued subsidy for a contract

Line 6368: p_contract_currency okl_k_headers_full_v.currency_code%TYPE;

6364: l_depn_contract NUMBER := 0;
6365: l_converted_amount NUMBER := 0;
6366: p_return_status VARCHAR2(1);
6367: p_contract_start_date DATE;
6368: p_contract_currency okl_k_headers_full_v.currency_code%TYPE;
6369: p_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
6370: p_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
6371: p_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
6372:

Line 6369: p_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;

6365: l_converted_amount NUMBER := 0;
6366: p_return_status VARCHAR2(1);
6367: p_contract_start_date DATE;
6368: p_contract_currency okl_k_headers_full_v.currency_code%TYPE;
6369: p_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
6370: p_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
6371: p_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
6372:
6373: --Cursor to get the parent line id for a contract

Line 6370: p_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

6366: p_return_status VARCHAR2(1);
6367: p_contract_start_date DATE;
6368: p_contract_currency okl_k_headers_full_v.currency_code%TYPE;
6369: p_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
6370: p_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
6371: p_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
6372:
6373: --Cursor to get the parent line id for a contract
6374: CURSOR parent_line_id_csr (p_contract_id NUMBER)

Line 6371: p_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

6367: p_contract_start_date DATE;
6368: p_contract_currency okl_k_headers_full_v.currency_code%TYPE;
6369: p_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
6370: p_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
6371: p_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
6372:
6373: --Cursor to get the parent line id for a contract
6374: CURSOR parent_line_id_csr (p_contract_id NUMBER)
6375: IS

Line 6998: p_contract_currency okl_k_headers_full_v.currency_code%TYPE;

6994: l_depn_contract NUMBER := 0;
6995: l_converted_amount NUMBER := 0;
6996: p_return_status VARCHAR2(1);
6997: p_contract_start_date DATE;
6998: p_contract_currency okl_k_headers_full_v.currency_code%TYPE;
6999: p_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
7000: p_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
7001: p_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
7002:

Line 6999: p_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;

6995: l_converted_amount NUMBER := 0;
6996: p_return_status VARCHAR2(1);
6997: p_contract_start_date DATE;
6998: p_contract_currency okl_k_headers_full_v.currency_code%TYPE;
6999: p_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
7000: p_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
7001: p_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
7002:
7003: --Cursor to get the parent line id for a contract

Line 7000: p_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

6996: p_return_status VARCHAR2(1);
6997: p_contract_start_date DATE;
6998: p_contract_currency okl_k_headers_full_v.currency_code%TYPE;
6999: p_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
7000: p_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
7001: p_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
7002:
7003: --Cursor to get the parent line id for a contract
7004: CURSOR parent_line_id_csr (p_contract_id NUMBER)

Line 7001: p_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

6997: p_contract_start_date DATE;
6998: p_contract_currency okl_k_headers_full_v.currency_code%TYPE;
6999: p_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
7000: p_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
7001: p_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
7002:
7003: --Cursor to get the parent line id for a contract
7004: CURSOR parent_line_id_csr (p_contract_id NUMBER)
7005: IS

Line 11746: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;

11742: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
11743:
11744: l_converted_amount NUMBER;
11745: l_contract_start_date DATE;
11746: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
11747: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
11748: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
11749: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
11750:

Line 11747: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;

11743:
11744: l_converted_amount NUMBER;
11745: l_contract_start_date DATE;
11746: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
11747: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
11748: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
11749: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
11750:
11751: -- Bug# 4061058:

Line 11748: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;

11744: l_converted_amount NUMBER;
11745: l_contract_start_date DATE;
11746: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
11747: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
11748: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
11749: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
11750:
11751: -- Bug# 4061058:
11752: -- Changes to ensure that the query works for Release Asset

Line 11749: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;

11745: l_contract_start_date DATE;
11746: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
11747: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
11748: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
11749: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
11750:
11751: -- Bug# 4061058:
11752: -- Changes to ensure that the query works for Release Asset
11753: -- and Release Contract

Line 12106: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;

12102: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
12103:
12104: l_converted_amount NUMBER;
12105: l_contract_start_date DATE;
12106: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
12107: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
12108: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
12109: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
12110:

Line 12107: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;

12103:
12104: l_converted_amount NUMBER;
12105: l_contract_start_date DATE;
12106: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
12107: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
12108: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
12109: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
12110:
12111: -- Bug# 4061058:

Line 12108: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;

12104: l_converted_amount NUMBER;
12105: l_contract_start_date DATE;
12106: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
12107: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
12108: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
12109: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
12110:
12111: -- Bug# 4061058:
12112: -- Changes to ensure that the query works for Release Asset

Line 12109: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;

12105: l_contract_start_date DATE;
12106: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
12107: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
12108: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
12109: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
12110:
12111: -- Bug# 4061058:
12112: -- Changes to ensure that the query works for Release Asset
12113: -- and Release Contract

Line 15249: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;

15245: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
15246:
15247: l_converted_amount NUMBER;
15248: l_contract_start_date DATE;
15249: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
15250: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
15251: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
15252: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
15253:

Line 15250: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;

15246:
15247: l_converted_amount NUMBER;
15248: l_contract_start_date DATE;
15249: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
15250: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
15251: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
15252: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
15253:
15254: CURSOR l_asset_csr(p_chr_id IN NUMBER

Line 15251: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;

15247: l_converted_amount NUMBER;
15248: l_contract_start_date DATE;
15249: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
15250: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
15251: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
15252: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
15253:
15254: CURSOR l_asset_csr(p_chr_id IN NUMBER
15255: ,p_cle_id IN NUMBER

Line 15252: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;

15248: l_contract_start_date DATE;
15249: l_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
15250: l_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
15251: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
15252: l_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
15253:
15254: CURSOR l_asset_csr(p_chr_id IN NUMBER
15255: ,p_cle_id IN NUMBER
15256: ,p_book_class IN VARCHAR2 -- 7626121