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 10: from dual where exists

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

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

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

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

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

Line 541: p_primary_sty_purpose => 'INVESTOR_RESIDUAL_DISB_BASIS',

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

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

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

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

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

Line 1054: p_residual_value => 0,

1050: OKL_PRICING_PVT.get_quote_amortization(
1051: p_khr_id => p_khr_id,
1052: p_kle_id => l_cle_id,
1053: p_investment => l_capital_cost,
1054: p_residual_value => 0,
1055: p_start_date => l_hdr.start_date,
1056: p_asset_start_date => l_fee_start_date,
1057: p_term_duration => l_hdr.term_duration,
1058: x_principal_tbl => l_principal_tbl,

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

2218: x_return_status => x_return_status,
2219: x_primary_sty_id => l_sty_id,
2220: x_primary_sty_name => x_mapped_stream);
2221:
2222: ElsIf ( p_sty_purpose = 'RESIDUAL' ) Then
2223: --x_mapped_stream := 'INVESTOR RESIDUAL DISBURSEMENT BASIS';
2224: OKL_ISG_UTILS_PVT.get_primary_stream_type(
2225: p_khr_id => p_khr_id,
2226: p_pdt_id => r_hdr.pid,

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

2219: x_primary_sty_id => l_sty_id,
2220: x_primary_sty_name => x_mapped_stream);
2221:
2222: ElsIf ( p_sty_purpose = 'RESIDUAL' ) Then
2223: --x_mapped_stream := 'INVESTOR RESIDUAL DISBURSEMENT BASIS';
2224: OKL_ISG_UTILS_PVT.get_primary_stream_type(
2225: p_khr_id => p_khr_id,
2226: p_pdt_id => r_hdr.pid,
2227: p_primary_sty_purpose => 'INVESTOR_RESIDUAL_DISB_BASIS',

Line 2227: p_primary_sty_purpose => 'INVESTOR_RESIDUAL_DISB_BASIS',

2223: --x_mapped_stream := 'INVESTOR RESIDUAL DISBURSEMENT BASIS';
2224: OKL_ISG_UTILS_PVT.get_primary_stream_type(
2225: p_khr_id => p_khr_id,
2226: p_pdt_id => r_hdr.pid,
2227: p_primary_sty_purpose => 'INVESTOR_RESIDUAL_DISB_BASIS',
2228: x_return_status => x_return_status,
2229: x_primary_sty_id => l_sty_id,
2230: x_primary_sty_name => x_mapped_stream);
2231: End If;

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

2273: x_return_status => x_return_status,
2274: x_primary_sty_id => l_sty_id,
2275: x_primary_sty_name => x_mapped_stream);
2276:
2277: ElsIf ( p_sty_purpose = 'RESIDUAL' ) Then
2278: OKL_ISG_UTILS_PVT.get_primary_stream_type(
2279: p_khr_id => p_khr_id,
2280: p_pdt_id => r_hdr.pid,
2281: p_primary_sty_purpose => 'PV_RV_SECURITIZED',

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

2594:
2595: BEGIN
2596:
2597: --print( l_prog_name, 'begin' );
2598: SELECT okl_sif_seq.nextval INTO l_transaction_number FROM DUAL;
2599:
2600: -- NOTE: UV for Streams inquiry (OKL_ASSET_STREAMS_UV) assumes a denormalized use of KHR_ID
2601:
2602: l_stmv_rec.khr_id := p_khr_id;

Line 4055: kle.residual_code,

4051:
4052: cursor l_line_csr( chrid NUMBER, lnetype VARCHAR2 ) is
4053: select kle.id,
4054: kle.oec,
4055: kle.residual_code,
4056: kle.capital_amount,
4057: kle.delivered_date,
4058: kle.date_funding_required,
4059: kle.residual_grnty_amount,

Line 4059: kle.residual_grnty_amount,

4055: kle.residual_code,
4056: kle.capital_amount,
4057: kle.delivered_date,
4058: kle.date_funding_required,
4059: kle.residual_grnty_amount,
4060: kle.date_funding,
4061: kle.residual_value,
4062: kle.amount,
4063: kle.price_negotiated,

Line 4061: kle.residual_value,

4057: kle.delivered_date,
4058: kle.date_funding_required,
4059: kle.residual_grnty_amount,
4060: kle.date_funding,
4061: kle.residual_value,
4062: kle.amount,
4063: kle.price_negotiated,
4064: kle.start_date,
4065: kle.end_date,

Line 4275: p_primary_sty_purpose => 'RESIDUAL_VALUE',

4271:
4272: OKL_ISG_UTILS_PVT.get_primary_stream_type(
4273: p_khr_id => p_khr_id,
4274: p_deal_type => l_deal_type,
4275: p_primary_sty_purpose => 'RESIDUAL_VALUE',
4276: x_return_status => lx_return_status,
4277: x_primary_sty_id => l_rv_sty_id,
4278: x_primary_sty_name => l_rv_sty_name);
4279:

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

4303: IF ( p_generation_type <> 'SERVICE_LINES' )
4304: THEN
4305: FOR l_line_rec in l_line_csr( p_khr_id, 'FREE_FORM1' )
4306: LOOP
4307: -- Residual Value Streams are getting generated here ....
4308: IF ( (p_generation_type = 'FULL' OR p_generation_type = 'RESIDUAL VALUE') ) AND
4309: ( nvl(l_line_rec.residual_value, 0) > 0 )
4310: THEN
4311:

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

4304: THEN
4305: FOR l_line_rec in l_line_csr( p_khr_id, 'FREE_FORM1' )
4306: LOOP
4307: -- Residual Value Streams are getting generated here ....
4308: IF ( (p_generation_type = 'FULL' OR p_generation_type = 'RESIDUAL VALUE') ) AND
4309: ( nvl(l_line_rec.residual_value, 0) > 0 )
4310: THEN
4311:
4312: l_selv_tbl.delete;

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

4305: FOR l_line_rec in l_line_csr( p_khr_id, 'FREE_FORM1' )
4306: LOOP
4307: -- Residual Value Streams are getting generated here ....
4308: IF ( (p_generation_type = 'FULL' OR p_generation_type = 'RESIDUAL VALUE') ) AND
4309: ( nvl(l_line_rec.residual_value, 0) > 0 )
4310: THEN
4311:
4312: l_selv_tbl.delete;
4313: -- Moving the execution of the RV Stream out of loop

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

4325: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
4326: RAISE OKL_API.G_EXCEPTION_ERROR;
4327: END IF;
4328:
4329: l_selv_tbl(1).amount := l_line_rec.residual_value;
4330: l_selv_tbl(1).stream_element_date := l_hdr.end_date;
4331: l_selv_tbl(1).se_line_number := 1;
4332: l_selv_tbl(1).accrued_yn := NULL;
4333:

Line 5325: kle.residual_value residual_value,

5321: TO_NUMBER(rul2.rule_information7) stub_days,
5322: TO_NUMBER(rul2.rule_information8) stub_amount,
5323: lse.lty_code lty_code,
5324: kle.capital_amount capital_amount,
5325: kle.residual_value residual_value,
5326: kle.fee_type fee_type
5327: FROM okc_rule_groups_b rgp,
5328: okc_rules_b rul1,
5329: okc_rules_b rul2,

Line 5357: TO_NUMBER(NULL) residual_value,

5353: TO_NUMBER(rul2.rule_information7) stub_days,
5354: TO_NUMBER(rul2.rule_information8) stub_amount,
5355: NULL lty_code,
5356: TO_NUMBER(NULL) capital_amount,
5357: TO_NUMBER(NULL) residual_value,
5358: NULL fee_type
5359: FROM okc_rule_groups_b rgp,
5360: okc_rules_b rul1,
5361: okc_rules_b rul2

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

5372: l_inflow c_inflows%rowtype;
5373:
5374: CURSOR c_fin_assets IS
5375: SELECT kle.id,
5376: NVL(kle.residual_value, 0) residual_value,
5377: cle.start_date
5378: FROM okc_k_lines_b cle,
5379: okl_k_lines kle,
5380: okc_line_styles_b lse

Line 6046: kle.residual_value residual_value,

6042: TO_NUMBER(rul2.rule_information7) stub_days,
6043: TO_NUMBER(rul2.rule_information8) stub_amount,
6044: lse.lty_code lty_code,
6045: kle.capital_amount capital_amount,
6046: kle.residual_value residual_value,
6047: kle.fee_type fee_type
6048: FROM okc_rule_groups_b rgp,
6049: okc_rules_b rul1,
6050: okc_rules_b rul2,

Line 6079: TO_NUMBER(NULL) residual_value,

6075: TO_NUMBER(rul2.rule_information7) stub_days,
6076: TO_NUMBER(rul2.rule_information8) stub_amount,
6077: NULL lty_code,
6078: TO_NUMBER(NULL) capital_amount,
6079: TO_NUMBER(NULL) residual_value,
6080: NULL fee_type
6081: FROM okc_rule_groups_b rgp,
6082: okc_rules_b rul1,
6083: okc_rules_b rul2,

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

6101: -- Added by RGOOTY. Bug 4403311: End
6102:
6103: CURSOR c_fin_assets IS
6104: SELECT kle.id,
6105: NVL(kle.residual_value, 0) residual_value,
6106: cle.start_date,
6107: cle.sts_code,
6108: kle.fee_type,
6109: lse.lty_code,

Line 6168: from dual

6164: r_link_pmnts c_link_pmnts%ROWTYPE;
6165:
6166: CURSOR c_pt_yn (p_cle_id NUMBER) IS
6167: Select 'Y'
6168: from dual
6169: where Exists (
6170: select vDtls.DISBURSEMENT_BASIS,
6171: vDtls.DISBURSEMENT_FIXED_AMOUNT,
6172: vDtls.DISBURSEMENT_PERCENT,

Line 6261: From dual

6257: l_SUB_PRE_TAX_IRR NUMBER;
6258:
6259: Cursor c_subs Is
6260: Select 'Y'
6261: From dual
6262: where Exists(
6263: select kle.id
6264: from okl_k_lines_full_v kle,
6265: okc_line_styles_b lse,

Line 6276: l_residual_value NUMBER;

6272:
6273: r_subs c_subs%ROWTYPE;
6274: l_subsidies_yn VARCHAR2(1);
6275: l_subsidy_amount NUMBER;
6276: l_residual_value NUMBER;
6277:
6278: l_fee_type VARCHAR2(256);
6279:
6280: l_additional_parameters OKL_EXECUTE_FORMULA_PUB.ctxt_val_tbl_type;

Line 6516: l_residual_value := OKL_AM_UTIL_PVT.get_actual_asset_residual(

6512: END IF;
6513:
6514: IF ( l_capital_cost > 0 ) THEN
6515: IF l_fin_asset.sts_code = 'TERMINATED' THEN
6516: l_residual_value := OKL_AM_UTIL_PVT.get_actual_asset_residual(
6517: p_khr_id => p_khr_id,
6518: p_kle_id => l_fin_asset.id);
6519: ELSE
6520: l_residual_value := l_fin_asset.residual_value;

Line 6520: l_residual_value := l_fin_asset.residual_value;

6516: l_residual_value := OKL_AM_UTIL_PVT.get_actual_asset_residual(
6517: p_khr_id => p_khr_id,
6518: p_kle_id => l_fin_asset.id);
6519: ELSE
6520: l_residual_value := l_fin_asset.residual_value;
6521: END IF;
6522: --print( l_prog_name, ' subsidies_yn ' || l_subsidies_yn );
6523:
6524:

Line 6549: p_residual_value => l_residual_value,

6545: OKL_PRICING_PVT.get_loan_amortization(p_khr_id => p_khr_id,
6546: p_kle_id => l_fin_asset.id,
6547: p_purpose_code => l_purpose_code,
6548: p_investment => l_capital_cost,
6549: p_residual_value => l_residual_value,
6550: p_start_date => l_hdr.start_date,
6551: p_asset_start_date => l_fin_asset.start_date,
6552: p_term_duration => l_hdr.term_duration,
6553: p_currency_code => l_hdr.currency_code,

Line 6615: p_residual_value => l_residual_value,

6611: p_khr_id => p_khr_id,
6612: p_kle_id => l_fin_asset.id,
6613: p_purpose_code => l_purpose_code,
6614: p_investment => l_capital_cost,
6615: p_residual_value => l_residual_value,
6616: p_start_date => l_hdr.start_date,
6617: p_asset_start_date => l_fin_asset.start_date,
6618: p_term_duration => l_hdr.term_duration,
6619: p_currency_code => l_hdr.currency_code,

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

7624: END IF;
7625: END IF;
7626: -- Added by RGOOTY: End
7627:
7628: -- streams like RESIDUAL VALUE, etc.
7629: gen_non_cash_flows ( p_api_version => p_api_version,
7630: p_init_msg_list => p_init_msg_list,
7631: p_khr_id => p_khr_id,
7632: p_pre_tax_irr => (l_pre_tax_irr*100.00),

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

7766: /*
7767: * delete the duplicates from the okl_streams header table.
7768: */
7769: -- Modified by RGOOTY: Start
7770: IF (p_generation_type <> 'RESIDUAL VALUE' AND p_generation_type <> 'CAPITAL REDUCTION')
7771: THEN
7772:
7773: consolidate_line_streams(p_khr_id => p_khr_id,
7774: p_purpose_code => l_purpose_code,

Line 7786: p_generation_type <> 'RESIDUAL VALUE' AND

7782: END IF;
7783: END IF;
7784:
7785: IF (p_generation_type <> 'SERVICE_LINES' AND
7786: p_generation_type <> 'RESIDUAL VALUE' AND
7787: p_generation_type <> 'CAPITAL REDUCTION')
7788: THEN
7789:
7790: consolidate_header_streams(p_khr_id => p_khr_id,

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

7800: END IF;
7801: --bakuchib changes
7802: END IF;
7803:
7804: IF (p_generation_type <> 'RESIDUAL VALUE' AND p_generation_type <> 'CAPITAL REDUCTION')
7805: THEN
7806: consolidate_acc_streams(p_khr_id => p_khr_id,
7807: p_purpose_code => l_purpose_code,
7808: x_return_status => lx_return_status);

Line 7903: TO_NUMBER(NULL) residual_value

7899: TO_NUMBER(rul2.rule_information7) stub_days,
7900: TO_NUMBER(rul2.rule_information8) stub_amount,
7901: NULL lty_code,
7902: TO_NUMBER(NULL) capital_amount,
7903: TO_NUMBER(NULL) residual_value
7904: FROM okc_rule_groups_b rgp,
7905: okc_rules_b rul1,
7906: okc_rules_b rul2,
7907: okl_strm_type_tl sty

Line 11034: from dual where Exists(

11030:
11031:
11032: Cursor fee_type_csr IS
11033: Select 'Y' What
11034: from dual where Exists(
11035: SELECT nvl(kle.fee_type, 'XYZ'),
11036: nvl(lse.lty_code, 'XYZ')
11037: FROM okc_k_lines_b cle,
11038: okl_k_lines kle,

Line 11334: TO_NUMBER(NULL) residual_value

11330: TO_NUMBER(rul2.rule_information7) stub_days,
11331: TO_NUMBER(rul2.rule_information8) stub_amount,
11332: NULL lty_code,
11333: TO_NUMBER(NULL) capital_amount,
11334: TO_NUMBER(NULL) residual_value
11335: FROM okc_rule_groups_b rgp,
11336: okc_rules_b rul1,
11337: okc_rules_b rul2,
11338: okl_strm_type_b sty

Line 11607: kle.residual_value residual_value,

11603: TO_NUMBER(rul2.rule_information7) stub_days,
11604: TO_NUMBER(rul2.rule_information8) stub_amount,
11605: lse.lty_code lty_code,
11606: kle.capital_amount capital_amount,
11607: kle.residual_value residual_value,
11608: kle.fee_type fee_type
11609: FROM okc_rule_groups_b rgp,
11610: okc_rules_b rul1,
11611: okc_rules_b rul2,

Line 11837: kle.residual_value residual_value,

11833: TO_NUMBER(rul2.rule_information7) stub_days,
11834: TO_NUMBER(rul2.rule_information8) stub_amount,
11835: lse.lty_code lty_code,
11836: kle.capital_amount capital_amount,
11837: kle.residual_value residual_value,
11838: kle.fee_type fee_type
11839: FROM okc_rule_groups_b rgp,
11840: okc_rules_b rul1,
11841: okc_rules_b rul2,