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_STREAM_GENERATOR_PVT dependencies on DUAL

Line 14: from dual where exists

10: -- Added by RGOOTY : Start
11:
12: CURSOR G_SRV_ASSETS_EXISTS_CSR( chrId NUMBER ) IS
13: select 'T' flag
14: from dual where exists
15: (
16: select 1
17: from okc_k_lines_b kle,
18: okc_line_styles_b lse,

Line 540: ElsIf ( p_sty_purpose = 'RESIDUAL' ) Then

536: p_primary_sty_purpose => 'INVESTOR_RENT_DISB_BASIS',
537: x_return_status => x_return_status,
538: x_primary_sty_id => l_sty_id,
539: x_primary_sty_name => x_mapped_stream);
540: ElsIf ( p_sty_purpose = 'RESIDUAL' ) Then
541: --x_mapped_stream := 'INVESTOR RESIDUAL DISBURSEMENT BASIS';
542: OKL_ISG_UTILS_PVT.get_primary_stream_type(
543: p_khr_id => p_khr_id,
544: p_pdt_id => r_hdr.pid,

Line 541: --x_mapped_stream := 'INVESTOR RESIDUAL DISBURSEMENT BASIS';

537: x_return_status => x_return_status,
538: x_primary_sty_id => l_sty_id,
539: x_primary_sty_name => x_mapped_stream);
540: ElsIf ( p_sty_purpose = 'RESIDUAL' ) Then
541: --x_mapped_stream := 'INVESTOR RESIDUAL DISBURSEMENT BASIS';
542: OKL_ISG_UTILS_PVT.get_primary_stream_type(
543: p_khr_id => p_khr_id,
544: p_pdt_id => r_hdr.pid,
545: p_primary_sty_purpose => 'INVESTOR_RESIDUAL_DISB_BASIS',

Line 545: p_primary_sty_purpose => 'INVESTOR_RESIDUAL_DISB_BASIS',

541: --x_mapped_stream := 'INVESTOR RESIDUAL DISBURSEMENT BASIS';
542: OKL_ISG_UTILS_PVT.get_primary_stream_type(
543: p_khr_id => p_khr_id,
544: p_pdt_id => r_hdr.pid,
545: p_primary_sty_purpose => 'INVESTOR_RESIDUAL_DISB_BASIS',
546: x_return_status => x_return_status,
547: x_primary_sty_id => l_sty_id,
548: x_primary_sty_name => x_mapped_stream);
549: End If;

Line 570: ElsIf ( p_sty_purpose = 'RESIDUAL' ) Then

566: p_primary_sty_purpose => 'PV_RENT_SECURITIZED',
567: x_return_status => x_return_status,
568: x_primary_sty_id => l_sty_id,
569: x_primary_sty_name => x_mapped_stream);
570: ElsIf ( p_sty_purpose = 'RESIDUAL' ) Then
571: --x_mapped_stream := 'PRESENT VALUE SECURITIZED RESIDUAL';
572: OKL_ISG_UTILS_PVT.get_primary_stream_type(
573: p_khr_id => p_khr_id,
574: p_pdt_id => r_hdr.pid,

Line 571: --x_mapped_stream := 'PRESENT VALUE SECURITIZED RESIDUAL';

567: x_return_status => x_return_status,
568: x_primary_sty_id => l_sty_id,
569: x_primary_sty_name => x_mapped_stream);
570: ElsIf ( p_sty_purpose = 'RESIDUAL' ) Then
571: --x_mapped_stream := 'PRESENT VALUE SECURITIZED RESIDUAL';
572: OKL_ISG_UTILS_PVT.get_primary_stream_type(
573: p_khr_id => p_khr_id,
574: p_pdt_id => r_hdr.pid,
575: p_primary_sty_purpose => 'PV_RV_SECURITIZED',

Line 1069: p_residual_value => 0,

1065: OKL_PRICING_PVT.get_quote_amortization(
1066: p_khr_id => p_khr_id,
1067: p_kle_id => l_cle_id,
1068: p_investment => l_capital_cost,
1069: p_residual_value => 0,
1070: p_start_date => l_hdr.start_date,
1071: p_asset_start_date => l_fee_start_date,
1072: p_term_duration => l_hdr.term_duration,
1073: x_principal_tbl => l_principal_tbl,

Line 2237: ElsIf ( p_sty_purpose = 'RESIDUAL' ) Then

2233: x_return_status => x_return_status,
2234: x_primary_sty_id => l_sty_id,
2235: x_primary_sty_name => x_mapped_stream);
2236:
2237: ElsIf ( p_sty_purpose = 'RESIDUAL' ) Then
2238: --x_mapped_stream := 'INVESTOR RESIDUAL DISBURSEMENT BASIS';
2239: OKL_ISG_UTILS_PVT.get_primary_stream_type(
2240: p_khr_id => p_khr_id,
2241: p_pdt_id => r_hdr.pid,

Line 2238: --x_mapped_stream := 'INVESTOR RESIDUAL DISBURSEMENT BASIS';

2234: x_primary_sty_id => l_sty_id,
2235: x_primary_sty_name => x_mapped_stream);
2236:
2237: ElsIf ( p_sty_purpose = 'RESIDUAL' ) Then
2238: --x_mapped_stream := 'INVESTOR RESIDUAL DISBURSEMENT BASIS';
2239: OKL_ISG_UTILS_PVT.get_primary_stream_type(
2240: p_khr_id => p_khr_id,
2241: p_pdt_id => r_hdr.pid,
2242: p_primary_sty_purpose => 'INVESTOR_RESIDUAL_DISB_BASIS',

Line 2242: p_primary_sty_purpose => 'INVESTOR_RESIDUAL_DISB_BASIS',

2238: --x_mapped_stream := 'INVESTOR RESIDUAL DISBURSEMENT BASIS';
2239: OKL_ISG_UTILS_PVT.get_primary_stream_type(
2240: p_khr_id => p_khr_id,
2241: p_pdt_id => r_hdr.pid,
2242: p_primary_sty_purpose => 'INVESTOR_RESIDUAL_DISB_BASIS',
2243: x_return_status => x_return_status,
2244: x_primary_sty_id => l_sty_id,
2245: x_primary_sty_name => x_mapped_stream);
2246: End If;

Line 2292: ElsIf ( p_sty_purpose = 'RESIDUAL' ) Then

2288: x_return_status => x_return_status,
2289: x_primary_sty_id => l_sty_id,
2290: x_primary_sty_name => x_mapped_stream);
2291:
2292: ElsIf ( p_sty_purpose = 'RESIDUAL' ) Then
2293: OKL_ISG_UTILS_PVT.get_primary_stream_type(
2294: p_khr_id => p_khr_id,
2295: p_pdt_id => r_hdr.pid,
2296: p_primary_sty_purpose => 'PV_RV_SECURITIZED',

Line 2613: SELECT okl_sif_seq.nextval INTO l_transaction_number FROM DUAL;

2609:
2610: BEGIN
2611:
2612: --print( l_prog_name, 'begin' );
2613: SELECT okl_sif_seq.nextval INTO l_transaction_number FROM DUAL;
2614:
2615: -- NOTE: UV for Streams inquiry (OKL_ASSET_STREAMS_UV) assumes a denormalized use of KHR_ID
2616:
2617: l_stmv_rec.khr_id := p_khr_id;

Line 3968: kle.residual_code,

3964:
3965: cursor l_line_csr( chrid NUMBER, lnetype VARCHAR2 ) is
3966: select kle.id,
3967: kle.oec,
3968: kle.residual_code,
3969: kle.capital_amount,
3970: kle.delivered_date,
3971: kle.date_funding_required,
3972: kle.residual_grnty_amount,

Line 3972: kle.residual_grnty_amount,

3968: kle.residual_code,
3969: kle.capital_amount,
3970: kle.delivered_date,
3971: kle.date_funding_required,
3972: kle.residual_grnty_amount,
3973: kle.date_funding,
3974: kle.residual_value,
3975: kle.amount,
3976: kle.price_negotiated,

Line 3974: kle.residual_value,

3970: kle.delivered_date,
3971: kle.date_funding_required,
3972: kle.residual_grnty_amount,
3973: kle.date_funding,
3974: kle.residual_value,
3975: kle.amount,
3976: kle.price_negotiated,
3977: kle.start_date,
3978: kle.end_date,

Line 4191: p_primary_sty_purpose => 'RESIDUAL_VALUE',

4187:
4188: OKL_ISG_UTILS_PVT.get_primary_stream_type(
4189: p_khr_id => p_khr_id,
4190: p_deal_type => l_deal_type,
4191: p_primary_sty_purpose => 'RESIDUAL_VALUE',
4192: x_return_status => lx_return_status,
4193: x_primary_sty_id => l_rv_sty_id,
4194: x_primary_sty_name => l_rv_sty_name);
4195:

Line 4223: -- Residual Value Streams are getting generated here ....

4219: IF ( p_generation_type <> 'SERVICE_LINES' )
4220: THEN
4221: FOR l_line_rec in l_line_csr( p_khr_id, 'FREE_FORM1' )
4222: LOOP
4223: -- Residual Value Streams are getting generated here ....
4224: IF ( (p_generation_type = 'FULL' OR p_generation_type = 'RESIDUAL VALUE') ) AND
4225: ( nvl(l_line_rec.residual_value, 0) > 0 )
4226: THEN
4227:

Line 4224: IF ( (p_generation_type = 'FULL' OR p_generation_type = 'RESIDUAL VALUE') ) AND

4220: THEN
4221: FOR l_line_rec in l_line_csr( p_khr_id, 'FREE_FORM1' )
4222: LOOP
4223: -- Residual Value Streams are getting generated here ....
4224: IF ( (p_generation_type = 'FULL' OR p_generation_type = 'RESIDUAL VALUE') ) AND
4225: ( nvl(l_line_rec.residual_value, 0) > 0 )
4226: THEN
4227:
4228: l_selv_tbl.delete;

Line 4225: ( nvl(l_line_rec.residual_value, 0) > 0 )

4221: FOR l_line_rec in l_line_csr( p_khr_id, 'FREE_FORM1' )
4222: LOOP
4223: -- Residual Value Streams are getting generated here ....
4224: IF ( (p_generation_type = 'FULL' OR p_generation_type = 'RESIDUAL VALUE') ) AND
4225: ( nvl(l_line_rec.residual_value, 0) > 0 )
4226: THEN
4227:
4228: l_selv_tbl.delete;
4229: -- Moving the execution of the RV Stream out of loop

Line 4245: l_selv_tbl(1).amount := l_line_rec.residual_value;

4241: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
4242: RAISE OKL_API.G_EXCEPTION_ERROR;
4243: END IF;
4244:
4245: l_selv_tbl(1).amount := l_line_rec.residual_value;
4246: l_selv_tbl(1).stream_element_date := l_hdr.end_date;
4247:
4248: --Bug# 9725362
4249: if l_line_rec.ste_code ='TERMINATED' then

Line 5247: kle.residual_value residual_value,

5243: TO_NUMBER(rul2.rule_information7) stub_days,
5244: TO_NUMBER(rul2.rule_information8) stub_amount,
5245: lse.lty_code lty_code,
5246: kle.capital_amount capital_amount,
5247: kle.residual_value residual_value,
5248: kle.fee_type fee_type
5249: FROM okc_rule_groups_b rgp,
5250: okc_rules_b rul1,
5251: okc_rules_b rul2,

Line 5279: TO_NUMBER(NULL) residual_value,

5275: TO_NUMBER(rul2.rule_information7) stub_days,
5276: TO_NUMBER(rul2.rule_information8) stub_amount,
5277: NULL lty_code,
5278: TO_NUMBER(NULL) capital_amount,
5279: TO_NUMBER(NULL) residual_value,
5280: NULL fee_type
5281: FROM okc_rule_groups_b rgp,
5282: okc_rules_b rul1,
5283: okc_rules_b rul2

Line 5298: NVL(kle.residual_value, 0) residual_value,

5294: l_inflow c_inflows%rowtype;
5295:
5296: CURSOR c_fin_assets IS
5297: SELECT kle.id,
5298: NVL(kle.residual_value, 0) residual_value,
5299: cle.start_date
5300: FROM okc_k_lines_b cle,
5301: okl_k_lines kle,
5302: okc_line_styles_b lse

Line 6650: FROM DUAL;

6646: IF l_wrk_strm_trx_number IS NULL
6647: THEN
6648: SELECT okl_sif_seq.nextval
6649: INTO l_wrk_strm_trx_number
6650: FROM DUAL;
6651: END IF;
6652: print(l_prog_name, 'l_wrk_strm_trx_number = ' || l_wrk_strm_trx_number );
6653:
6654: -- Store this Index

Line 6904: ( SELECT 'RENT_ACCRUAL' FROM DUAL WHERE p_context IN ( 'FULL' ) )

6900: AND NVL(stm.purpose_code, '-99') = p_purpose
6901: AND sty.id = stm.sty_id
6902: AND sty.stream_type_purpose IN (
6903: -- Accrual Streams generated using Straight Line Algorithm
6904: ( SELECT 'RENT_ACCRUAL' FROM DUAL WHERE p_context IN ( 'FULL' ) )
6905: ,( SELECT 'ACCRUED_FEE_INCOME' FROM DUAL WHERE p_context IN ( 'FULL' ) )
6906: ,( SELECT 'ACCRUED_FEE_EXPENSE' FROM DUAL WHERE p_context IN ( 'FULL' ) )
6907:
6908: --sechawla 10-aug-09 Added 'SERVICE_LINES' context for Service Income and Service Expense

Line 6905: ,( SELECT 'ACCRUED_FEE_INCOME' FROM DUAL WHERE p_context IN ( 'FULL' ) )

6901: AND sty.id = stm.sty_id
6902: AND sty.stream_type_purpose IN (
6903: -- Accrual Streams generated using Straight Line Algorithm
6904: ( SELECT 'RENT_ACCRUAL' FROM DUAL WHERE p_context IN ( 'FULL' ) )
6905: ,( SELECT 'ACCRUED_FEE_INCOME' FROM DUAL WHERE p_context IN ( 'FULL' ) )
6906: ,( SELECT 'ACCRUED_FEE_EXPENSE' FROM DUAL WHERE p_context IN ( 'FULL' ) )
6907:
6908: --sechawla 10-aug-09 Added 'SERVICE_LINES' context for Service Income and Service Expense
6909: --streams to support Prospective Rebooking for these streams

Line 6906: ,( SELECT 'ACCRUED_FEE_EXPENSE' FROM DUAL WHERE p_context IN ( 'FULL' ) )

6902: AND sty.stream_type_purpose IN (
6903: -- Accrual Streams generated using Straight Line Algorithm
6904: ( SELECT 'RENT_ACCRUAL' FROM DUAL WHERE p_context IN ( 'FULL' ) )
6905: ,( SELECT 'ACCRUED_FEE_INCOME' FROM DUAL WHERE p_context IN ( 'FULL' ) )
6906: ,( SELECT 'ACCRUED_FEE_EXPENSE' FROM DUAL WHERE p_context IN ( 'FULL' ) )
6907:
6908: --sechawla 10-aug-09 Added 'SERVICE_LINES' context for Service Income and Service Expense
6909: --streams to support Prospective Rebooking for these streams
6910: ,( SELECT 'SERVICE_INCOME' FROM DUAL WHERE p_context IN ( 'FULL','SERVICE_LINES' ) )

Line 6910: ,( SELECT 'SERVICE_INCOME' FROM DUAL WHERE p_context IN ( 'FULL','SERVICE_LINES' ) )

6906: ,( SELECT 'ACCRUED_FEE_EXPENSE' FROM DUAL WHERE p_context IN ( 'FULL' ) )
6907:
6908: --sechawla 10-aug-09 Added 'SERVICE_LINES' context for Service Income and Service Expense
6909: --streams to support Prospective Rebooking for these streams
6910: ,( SELECT 'SERVICE_INCOME' FROM DUAL WHERE p_context IN ( 'FULL','SERVICE_LINES' ) )
6911: ,( SELECT 'SERVICE_EXPENSE' FROM DUAL WHERE p_context IN ( 'FULL', 'SERVICE_LINES') )
6912:
6913: ,( SELECT 'PASS_THRU_REV_ACCRUAL' FROM DUAL WHERE p_context IN ('FULL', 'PASSTHRU_ONLY' ) )
6914: ,( SELECT 'PASS_THRU_EXP_ACCRUAL' FROM DUAL WHERE p_context IN ('FULL', 'PASSTHRU_ONLY' ) )

Line 6911: ,( SELECT 'SERVICE_EXPENSE' FROM DUAL WHERE p_context IN ( 'FULL', 'SERVICE_LINES') )

6907:
6908: --sechawla 10-aug-09 Added 'SERVICE_LINES' context for Service Income and Service Expense
6909: --streams to support Prospective Rebooking for these streams
6910: ,( SELECT 'SERVICE_INCOME' FROM DUAL WHERE p_context IN ( 'FULL','SERVICE_LINES' ) )
6911: ,( SELECT 'SERVICE_EXPENSE' FROM DUAL WHERE p_context IN ( 'FULL', 'SERVICE_LINES') )
6912:
6913: ,( SELECT 'PASS_THRU_REV_ACCRUAL' FROM DUAL WHERE p_context IN ('FULL', 'PASSTHRU_ONLY' ) )
6914: ,( SELECT 'PASS_THRU_EXP_ACCRUAL' FROM DUAL WHERE p_context IN ('FULL', 'PASSTHRU_ONLY' ) )
6915: -- 15-Sep-10 SECHAWLA 10045043 : begin

Line 6913: ,( SELECT 'PASS_THRU_REV_ACCRUAL' FROM DUAL WHERE p_context IN ('FULL', 'PASSTHRU_ONLY' ) )

6909: --streams to support Prospective Rebooking for these streams
6910: ,( SELECT 'SERVICE_INCOME' FROM DUAL WHERE p_context IN ( 'FULL','SERVICE_LINES' ) )
6911: ,( SELECT 'SERVICE_EXPENSE' FROM DUAL WHERE p_context IN ( 'FULL', 'SERVICE_LINES') )
6912:
6913: ,( SELECT 'PASS_THRU_REV_ACCRUAL' FROM DUAL WHERE p_context IN ('FULL', 'PASSTHRU_ONLY' ) )
6914: ,( SELECT 'PASS_THRU_EXP_ACCRUAL' FROM DUAL WHERE p_context IN ('FULL', 'PASSTHRU_ONLY' ) )
6915: -- 15-Sep-10 SECHAWLA 10045043 : begin
6916: ,( SELECT 'PASS_THRU_SVC_EXP_ACCRUAL' FROM DUAL WHERE p_context IN ('FULL', 'PASSTHRU_ONLY' ) )
6917: -- 15-Sep-10 SECHAWLA 10045043 : end

Line 6914: ,( SELECT 'PASS_THRU_EXP_ACCRUAL' FROM DUAL WHERE p_context IN ('FULL', 'PASSTHRU_ONLY' ) )

6910: ,( SELECT 'SERVICE_INCOME' FROM DUAL WHERE p_context IN ( 'FULL','SERVICE_LINES' ) )
6911: ,( SELECT 'SERVICE_EXPENSE' FROM DUAL WHERE p_context IN ( 'FULL', 'SERVICE_LINES') )
6912:
6913: ,( SELECT 'PASS_THRU_REV_ACCRUAL' FROM DUAL WHERE p_context IN ('FULL', 'PASSTHRU_ONLY' ) )
6914: ,( SELECT 'PASS_THRU_EXP_ACCRUAL' FROM DUAL WHERE p_context IN ('FULL', 'PASSTHRU_ONLY' ) )
6915: -- 15-Sep-10 SECHAWLA 10045043 : begin
6916: ,( SELECT 'PASS_THRU_SVC_EXP_ACCRUAL' FROM DUAL WHERE p_context IN ('FULL', 'PASSTHRU_ONLY' ) )
6917: -- 15-Sep-10 SECHAWLA 10045043 : end
6918:

Line 6916: ,( SELECT 'PASS_THRU_SVC_EXP_ACCRUAL' FROM DUAL WHERE p_context IN ('FULL', 'PASSTHRU_ONLY' ) )

6912:
6913: ,( SELECT 'PASS_THRU_REV_ACCRUAL' FROM DUAL WHERE p_context IN ('FULL', 'PASSTHRU_ONLY' ) )
6914: ,( SELECT 'PASS_THRU_EXP_ACCRUAL' FROM DUAL WHERE p_context IN ('FULL', 'PASSTHRU_ONLY' ) )
6915: -- 15-Sep-10 SECHAWLA 10045043 : begin
6916: ,( SELECT 'PASS_THRU_SVC_EXP_ACCRUAL' FROM DUAL WHERE p_context IN ('FULL', 'PASSTHRU_ONLY' ) )
6917: -- 15-Sep-10 SECHAWLA 10045043 : end
6918:
6919: -- Accrual Streams generated using Spread By Income Logic
6920: ,( SELECT 'AMORTIZE_FEE_INCOME' FROM DUAL WHERE p_context IN ('FULL' ) )

Line 6920: ,( SELECT 'AMORTIZE_FEE_INCOME' FROM DUAL WHERE p_context IN ('FULL' ) )

6916: ,( SELECT 'PASS_THRU_SVC_EXP_ACCRUAL' FROM DUAL WHERE p_context IN ('FULL', 'PASSTHRU_ONLY' ) )
6917: -- 15-Sep-10 SECHAWLA 10045043 : end
6918:
6919: -- Accrual Streams generated using Spread By Income Logic
6920: ,( SELECT 'AMORTIZE_FEE_INCOME' FROM DUAL WHERE p_context IN ('FULL' ) )
6921: ,( SELECT 'AMORTIZED_FEE_EXPENSE' FROM DUAL WHERE p_context IN ('FULL') )
6922: ,( SELECT 'SUBSIDY_INCOME' FROM DUAL WHERE p_context IN ('FULL') )
6923: )
6924: AND stm.sgn_code NOT IN ( 'STMP' , 'STMP-REBK')

Line 6921: ,( SELECT 'AMORTIZED_FEE_EXPENSE' FROM DUAL WHERE p_context IN ('FULL') )

6917: -- 15-Sep-10 SECHAWLA 10045043 : end
6918:
6919: -- Accrual Streams generated using Spread By Income Logic
6920: ,( SELECT 'AMORTIZE_FEE_INCOME' FROM DUAL WHERE p_context IN ('FULL' ) )
6921: ,( SELECT 'AMORTIZED_FEE_EXPENSE' FROM DUAL WHERE p_context IN ('FULL') )
6922: ,( SELECT 'SUBSIDY_INCOME' FROM DUAL WHERE p_context IN ('FULL') )
6923: )
6924: AND stm.sgn_code NOT IN ( 'STMP' , 'STMP-REBK')
6925: ORDER BY DECODE( sty.stream_type_purpose, 'RENT_ACCRUAL', 1, 99 ) ASC;

Line 6922: ,( SELECT 'SUBSIDY_INCOME' FROM DUAL WHERE p_context IN ('FULL') )

6918:
6919: -- Accrual Streams generated using Spread By Income Logic
6920: ,( SELECT 'AMORTIZE_FEE_INCOME' FROM DUAL WHERE p_context IN ('FULL' ) )
6921: ,( SELECT 'AMORTIZED_FEE_EXPENSE' FROM DUAL WHERE p_context IN ('FULL') )
6922: ,( SELECT 'SUBSIDY_INCOME' FROM DUAL WHERE p_context IN ('FULL') )
6923: )
6924: AND stm.sgn_code NOT IN ( 'STMP' , 'STMP-REBK')
6925: ORDER BY DECODE( sty.stream_type_purpose, 'RENT_ACCRUAL', 1, 99 ) ASC;
6926: TYPE l_accrual_streams_tbl_type IS TABLE OF lcu_get_accrual_streams%ROWTYPE

Line 8076: NULL residual_value,

8072: NULL stub_days,
8073: NULL stub_amount,
8074: lse.lty_code lty_code,
8075: NULL capital_amount,
8076: NULL residual_value,
8077: kle.fee_type fee_type,
8078: kle.origination_income origination_income,
8079: kle.amount fee_amount,
8080: 'INCOME_AMORT' fee_line_level_type

Line 8114: kle.residual_value residual_value,

8110: TO_NUMBER(rul2.rule_information7) stub_days,
8111: TO_NUMBER(rul2.rule_information8) stub_amount,
8112: lse.lty_code lty_code,
8113: kle.capital_amount capital_amount,
8114: kle.residual_value residual_value,
8115: kle.fee_type fee_type,
8116: kle.origination_income origination_income,
8117: kle.amount fee_amount,
8118: DECODE(kle.fee_type, 'INCOME', 'INCOME_ACCRUED', 'FEE_PAYMENT') fee_line_level_type

Line 8150: TO_NUMBER(NULL) residual_value,

8146: TO_NUMBER(rul2.rule_information7) stub_days,
8147: TO_NUMBER(rul2.rule_information8) stub_amount,
8148: NULL lty_code,
8149: TO_NUMBER(NULL) capital_amount,
8150: TO_NUMBER(NULL) residual_value,
8151: NULL fee_type,
8152: NULL origination_income,
8153: NULL fee_amount,
8154: 'ASSET_ACCRUALS' fee_line_level_type

Line 8179: NVL(kle.residual_value, 0) residual_value,

8175: -- Added by RGOOTY. Bug 4403311: End
8176:
8177: CURSOR c_fin_assets IS
8178: SELECT kle.id,
8179: NVL(kle.residual_value, 0) residual_value,
8180: cle.start_date,
8181: cle.sts_code,
8182: kle.fee_type,
8183: lse.lty_code,

Line 8244: from dual

8240: r_link_pmnts c_link_pmnts%ROWTYPE;
8241:
8242: CURSOR c_pt_yn (p_cle_id NUMBER) IS
8243: Select 'Y'
8244: from dual
8245: where Exists (
8246: select vDtls.DISBURSEMENT_BASIS,
8247: vDtls.DISBURSEMENT_FIXED_AMOUNT,
8248: vDtls.DISBURSEMENT_PERCENT,

Line 8337: From dual

8333: l_SUB_PRE_TAX_IRR NUMBER;
8334:
8335: Cursor c_subs Is
8336: Select 'Y'
8337: From dual
8338: where Exists(
8339: select kle.id
8340: from okl_k_lines_full_v kle,
8341: okc_line_styles_b lse,

Line 8352: l_residual_value NUMBER;

8348:
8349: r_subs c_subs%ROWTYPE;
8350: l_subsidies_yn VARCHAR2(1);
8351: l_subsidy_amount NUMBER;
8352: l_residual_value NUMBER;
8353:
8354: l_fee_type VARCHAR2(256);
8355:
8356: l_additional_parameters OKL_EXECUTE_FORMULA_PUB.ctxt_val_tbl_type;

Line 8469: FROM DUAL

8465: -- Bug 12944979: RGOOTY
8466: CURSOR c_chk_tmnt_asset_exists_csr(cp_khr_id IN NUMBER)
8467: IS
8468: SELECT 'EXISTS'
8469: FROM DUAL
8470: WHERE EXISTS
8471: (
8472: SELECT 1
8473: FROM okc_k_lines_b cle

Line 8715: l_residual_value := OKL_AM_UTIL_PVT.get_actual_asset_residual(

8711: END IF;
8712:
8713: IF ( l_capital_cost > 0 ) THEN
8714: IF l_fin_asset.sts_code = 'TERMINATED' THEN
8715: l_residual_value := OKL_AM_UTIL_PVT.get_actual_asset_residual(
8716: p_khr_id => p_khr_id,
8717: p_kle_id => l_fin_asset.id);
8718: ELSE
8719: l_residual_value := l_fin_asset.residual_value;

Line 8719: l_residual_value := l_fin_asset.residual_value;

8715: l_residual_value := OKL_AM_UTIL_PVT.get_actual_asset_residual(
8716: p_khr_id => p_khr_id,
8717: p_kle_id => l_fin_asset.id);
8718: ELSE
8719: l_residual_value := l_fin_asset.residual_value;
8720: END IF;
8721: --print( l_prog_name, ' subsidies_yn ' || l_subsidies_yn );
8722:
8723:

Line 8842: p_residual_value => l_residual_value,

8838: OKL_PRICING_PVT.get_loan_amortization(p_khr_id => p_khr_id,
8839: p_kle_id => l_fin_asset.id,
8840: p_purpose_code => l_purpose_code,
8841: p_investment => l_capital_cost,
8842: p_residual_value => l_residual_value,
8843: p_start_date => l_hdr.start_date,
8844: p_asset_start_date => l_fin_asset.start_date,
8845: p_term_duration => l_hdr.term_duration,
8846: p_currency_code => l_hdr.currency_code,

Line 8917: p_residual_value => l_residual_value,

8913: p_khr_id => p_khr_id,
8914: p_kle_id => l_fin_asset.id,
8915: p_purpose_code => l_purpose_code,
8916: p_investment => l_capital_cost,
8917: p_residual_value => l_residual_value,
8918: p_start_date => l_hdr.start_date,
8919: p_asset_start_date => l_fin_asset.start_date,
8920: p_term_duration => l_hdr.term_duration,
8921: p_currency_code => l_hdr.currency_code,

Line 9941: -- streams like RESIDUAL VALUE, etc.

9937: END IF;
9938: END IF;
9939: -- Added by RGOOTY: End
9940:
9941: -- streams like RESIDUAL VALUE, etc.
9942: gen_non_cash_flows ( p_api_version => p_api_version,
9943: p_init_msg_list => p_init_msg_list,
9944: p_khr_id => p_khr_id,
9945: p_pre_tax_irr => (l_pre_tax_irr*100.00),

Line 10095: IF (p_generation_type <> 'RESIDUAL VALUE' AND p_generation_type <> 'CAPITAL REDUCTION')

10091: /*
10092: * delete the duplicates from the okl_streams header table.
10093: */
10094: -- Modified by RGOOTY: Start
10095: IF (p_generation_type <> 'RESIDUAL VALUE' AND p_generation_type <> 'CAPITAL REDUCTION')
10096: THEN
10097:
10098: consolidate_line_streams(p_khr_id => p_khr_id,
10099: p_purpose_code => l_purpose_code,

Line 10111: p_generation_type <> 'RESIDUAL VALUE' AND

10107: END IF;
10108: END IF;
10109:
10110: IF (p_generation_type <> 'SERVICE_LINES' AND
10111: p_generation_type <> 'RESIDUAL VALUE' AND
10112: p_generation_type <> 'CAPITAL REDUCTION')
10113: THEN
10114:
10115: consolidate_header_streams(p_khr_id => p_khr_id,

Line 10129: IF (p_generation_type <> 'RESIDUAL VALUE' AND p_generation_type <> 'CAPITAL REDUCTION')

10125: END IF;
10126: --bakuchib changes
10127: END IF;
10128:
10129: IF (p_generation_type <> 'RESIDUAL VALUE' AND p_generation_type <> 'CAPITAL REDUCTION')
10130: THEN
10131: consolidate_acc_streams(p_khr_id => p_khr_id,
10132: p_purpose_code => l_purpose_code,
10133: x_return_status => lx_return_status);

Line 10358: TO_NUMBER(NULL) residual_value

10354: TO_NUMBER(rul2.rule_information7) stub_days,
10355: TO_NUMBER(rul2.rule_information8) stub_amount,
10356: NULL lty_code,
10357: TO_NUMBER(NULL) capital_amount,
10358: TO_NUMBER(NULL) residual_value
10359: FROM okc_rule_groups_b rgp,
10360: okc_rules_b rul1,
10361: okc_rules_b rul2,
10362: okl_strm_type_tl sty

Line 13489: from dual where Exists(

13485:
13486:
13487: Cursor fee_type_csr IS
13488: Select 'Y' What
13489: from dual where Exists(
13490: SELECT nvl(kle.fee_type, 'XYZ'),
13491: nvl(lse.lty_code, 'XYZ')
13492: FROM okc_k_lines_b cle,
13493: okl_k_lines kle,

Line 13789: TO_NUMBER(NULL) residual_value

13785: TO_NUMBER(rul2.rule_information7) stub_days,
13786: TO_NUMBER(rul2.rule_information8) stub_amount,
13787: NULL lty_code,
13788: TO_NUMBER(NULL) capital_amount,
13789: TO_NUMBER(NULL) residual_value
13790: FROM okc_rule_groups_b rgp,
13791: okc_rules_b rul1,
13792: okc_rules_b rul2,
13793: okl_strm_type_b sty

Line 14074: kle.residual_value residual_value,

14070: TO_NUMBER(rul2.rule_information7) stub_days,
14071: TO_NUMBER(rul2.rule_information8) stub_amount,
14072: lse.lty_code lty_code,
14073: kle.capital_amount capital_amount,
14074: kle.residual_value residual_value,
14075: kle.fee_type fee_type
14076: FROM okc_rule_groups_b rgp,
14077: okc_rules_b rul1,
14078: okc_rules_b rul2,

Line 14304: kle.residual_value residual_value,

14300: TO_NUMBER(rul2.rule_information7) stub_days,
14301: TO_NUMBER(rul2.rule_information8) stub_amount,
14302: lse.lty_code lty_code,
14303: kle.capital_amount capital_amount,
14304: kle.residual_value residual_value,
14305: kle.fee_type fee_type
14306: FROM okc_rule_groups_b rgp,
14307: okc_rules_b rul1,
14308: okc_rules_b rul2,