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_AM_SECURITIZATION_PVT dependencies on OKL_STREAMS

Line 110: OKL_STREAMS_UTIL.get_primary_stream_type(p_ia_id,

106: g_add_params(l_loop_counter).value := p_ia_id;
107: END IF;
108:
109: -- smoduga +++++++++ User Defined Streams -- start ++++++++++++++++
110: OKL_STREAMS_UTIL.get_primary_stream_type(p_ia_id,
111: l_rent_sty,
112: l_return_status,
113: l_sty_id);
114:

Line 120: ,'OKL_STREAMS_UTIL.get_primary_stream_type returned no values');

116: --message logging
117: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
118: FND_LOG.STRING(FND_LOG.LEVEL_ERROR
119: ,'OKL_AM_SECURITIZATION_PVT.create_inv_khr_obligation'
120: ,'OKL_STREAMS_UTIL.get_primary_stream_type returned no values');
121: END IF;
122:
123: -- smoduga +++++++++ User Defined Streams -- end ++++++++++++++++
124: OKL_API.set_message(p_app_name => G_APP_NAME,

Line 196: ,'calling OKL_STREAMS_PUB.create_streams ');

192: --message logging
193: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
194: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
195: ,'OKL_AM_SECURITIZATION_PVT.create_inv_khr_obligation'
196: ,'calling OKL_STREAMS_PUB.create_streams ');
197: END IF;
198:
199: OKL_STREAMS_PUB.create_streams(
200: p_api_version => p_api_version

Line 199: OKL_STREAMS_PUB.create_streams(

195: ,'OKL_AM_SECURITIZATION_PVT.create_inv_khr_obligation'
196: ,'calling OKL_STREAMS_PUB.create_streams ');
197: END IF;
198:
199: OKL_STREAMS_PUB.create_streams(
200: p_api_version => p_api_version
201: ,p_init_msg_list => p_init_msg_list
202: ,x_return_status => l_return_status
203: ,x_msg_count => x_msg_count

Line 219: ,'returning from OKL_STREAMS_PUB.create_streams,'

215: --message logging
216: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
217: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
218: ,'OKL_AM_SECURITIZATION_PVT.create_inv_khr_obligation'
219: ,'returning from OKL_STREAMS_PUB.create_streams,'
220: ||' status is '||l_return_status);
221: END IF;
222: END IF;
223:

Line 341: OKL_STREAMS STM,

337: SELECT
338: sum(ste.amount)
339: FROM
340: OKL_STRM_ELEMENTS STE,
341: OKL_STREAMS STM,
342: OKL_STRM_TYPE_V STY
343: WHERE ste.amount <> 0
344: AND stm.id = ste.stm_id
345: AND sty.id IN (p_invdisbas_sty_id) -- pick INVESTOR RENT DISB BASIS streams only

Line 366: OKL_STREAMS STM,

362: SELECT
363: sum(ste.amount)
364: FROM
365: OKL_STRM_ELEMENTS STE,
366: OKL_STREAMS STM,
367: OKL_STRM_TYPE_V STY,
368: OKL_STRM_ELEMENTS BILLED_STE
369: WHERE ste.amount <> 0
370: AND stm.id = ste.stm_id

Line 427: OKL_STREAMS_UTIL.get_primary_stream_type(

423: -- get disbursement amounts only when FULL TERMINATION
424: IF p_partial_yn = 'N' THEN
425:
426: -- get rebook disbursement stream purpose
427: OKL_STREAMS_UTIL.get_primary_stream_type(
428: p_khr_id => p_ia_id,
429: p_primary_sty_purpose => 'INVESTOR_DISB_ADJUSTMENT',
430: x_return_status => l_return_status,
431: x_primary_sty_id => l_rbkadj_sty_id);

Line 446: OKL_STREAMS_UTIL.get_primary_stream_type(

442: RAISE OKL_API.G_EXCEPTION_ERROR;
443: END IF;
444:
445: -- get investor rent disb basis stream purpose
446: OKL_STREAMS_UTIL.get_primary_stream_type(
447: p_khr_id => p_ia_id,
448: p_primary_sty_purpose => 'INVESTOR_RENT_DISB_BASIS',
449: x_return_status => l_return_status,
450: x_primary_sty_id => l_invdisbas_sty_id);

Line 510: OKL_STREAMS_PUB.create_streams(

506: l_selv_tbl(1).amount := l_term_adj_amount * -1; -- rmunjulu always negate the amount
507: l_selv_tbl(1).accrued_yn := 'N';
508: l_selv_tbl(1).se_line_number := 1;
509:
510: OKL_STREAMS_PUB.create_streams(
511: p_api_version => p_api_version
512: ,p_init_msg_list => OKL_API.G_FALSE
513: ,x_return_status => l_return_status
514: ,x_msg_count => x_msg_count

Line 666: OKL_STREAMS STM,

662: SELECT
663: sum(ste.amount)
664: FROM
665: OKL_STRM_ELEMENTS STE,
666: OKL_STREAMS STM,
667: OKL_STRM_TYPE_V STY
668: WHERE ste.amount <> 0
669: AND stm.id = ste.stm_id
670: AND sty.id IN (p_invdisbas_sty_id,p_intdisbas_sty_id) -- pick INVESTOR Principal,interest DISB BASIS streams only

Line 692: OKL_STREAMS STM,

688: SELECT
689: sum(ste.amount)
690: FROM
691: OKL_STRM_ELEMENTS STE,
692: OKL_STREAMS STM,
693: OKL_STRM_TYPE_V STY,
694: OKL_STRM_ELEMENTS BILLED_STE
695: WHERE ste.amount <> 0
696: AND stm.id = ste.stm_id

Line 754: OKL_STREAMS_UTIL.get_primary_stream_type(

750: -- get disbursement amounts only when FULL TERMINATION
751: IF p_partial_yn = 'N' THEN
752:
753: -- get rebook disbursement stream purpose
754: OKL_STREAMS_UTIL.get_primary_stream_type(
755: p_khr_id => p_ia_id,
756: p_primary_sty_purpose => 'INVESTOR_DISB_ADJUSTMENT',
757: x_return_status => l_return_status,
758: x_primary_sty_id => l_rbkadj_sty_id);

Line 773: OKL_STREAMS_UTIL.get_primary_stream_type(

769: RAISE OKL_API.G_EXCEPTION_ERROR;
770: END IF;
771:
772: -- get investor investor disb basis stream purpose
773: OKL_STREAMS_UTIL.get_primary_stream_type(
774: p_khr_id => p_ia_id,
775: p_primary_sty_purpose => 'INVESTOR_PRINCIPAL_DISB_BASIS',
776: x_return_status => l_return_status,
777: x_primary_sty_id => l_invdisbas_sty_id);

Line 779: OKL_STREAMS_UTIL.get_primary_stream_type(

775: p_primary_sty_purpose => 'INVESTOR_PRINCIPAL_DISB_BASIS',
776: x_return_status => l_return_status,
777: x_primary_sty_id => l_invdisbas_sty_id);
778:
779: OKL_STREAMS_UTIL.get_primary_stream_type(
780: p_khr_id => p_ia_id,
781: p_primary_sty_purpose => 'INVESTOR_INTEREST_DISB_BASIS',
782: x_return_status => l_return_status,
783: x_primary_sty_id => l_intdisbas_sty_id);

Line 845: OKL_STREAMS_PUB.create_streams(

841: l_selv_tbl(1).amount := l_term_adj_amount * -1; -- rmunjulu always negate the amount
842: l_selv_tbl(1).accrued_yn := 'N';
843: l_selv_tbl(1).se_line_number := 1;
844:
845: OKL_STREAMS_PUB.create_streams(
846: p_api_version => p_api_version
847: ,p_init_msg_list => OKL_API.G_FALSE
848: ,x_return_status => l_return_status
849: ,x_msg_count => x_msg_count

Line 1084: FROM OKL_STREAMS_V STM,

1080:
1081: CURSOR get_rv_streams_csr(c_khr_id IN NUMBER,
1082: c_kle_id IN NUMBER) IS
1083: SELECT STM.id
1084: FROM OKL_STREAMS_V STM,
1085: OKL_STRM_TYPE_B STY
1086: WHERE STM.khr_id = c_khr_id
1087: AND STM.kle_id = c_kle_id
1088: AND STM.say_code = 'CURR'

Line 1127: FROM OKL_STREAMS STMB,

1123: AND POC.KHR_ID = p_khr_id
1124: AND POC.KLE_ID = p_kle_id
1125: AND POC.STATUS_CODE = 'ACTIVE'
1126: AND EXISTS (SELECT '1'
1127: FROM OKL_STREAMS STMB,
1128: OKL_STRM_TYPE_B STYB
1129: WHERE stmb.sty_id = styb.id
1130: AND stmb.khr_id = POC.khr_id
1131: AND stmb.kle_id = POC.kle_id

Line 1164: lp_stmv_tbl OKL_STREAMS_PUB.stmv_tbl_type;

1160: l_khr_id NUMBER;
1161: l_loop_counter NUMBER := 0;
1162: l_is_securitized VARCHAR2(1) := OKC_API.G_FALSE;
1163:
1164: lp_stmv_tbl OKL_STREAMS_PUB.stmv_tbl_type;
1165: lx_stmv_tbl OKL_STREAMS_PUB.stmv_tbl_type;
1166:
1167: l_stm_id NUMBER;
1168: l_stm_id_not_found BOOLEAN := FALSE;

Line 1165: lx_stmv_tbl OKL_STREAMS_PUB.stmv_tbl_type;

1161: l_loop_counter NUMBER := 0;
1162: l_is_securitized VARCHAR2(1) := OKC_API.G_FALSE;
1163:
1164: lp_stmv_tbl OKL_STREAMS_PUB.stmv_tbl_type;
1165: lx_stmv_tbl OKL_STREAMS_PUB.stmv_tbl_type;
1166:
1167: l_stm_id NUMBER;
1168: l_stm_id_not_found BOOLEAN := FALSE;
1169: l_asset_tbl asset_tbl_type;

Line 1647: ,'calling OKL_STREAMS_PUB.update_streams');

1643: --message logging
1644: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1645: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
1646: ,'OKL_AM_SECURITIZATION_PVT.process_securitized_streams'
1647: ,'calling OKL_STREAMS_PUB.update_streams');
1648: END IF;
1649:
1650: -- historize rv streams
1651: OKL_STREAMS_PUB.update_streams(

Line 1651: OKL_STREAMS_PUB.update_streams(

1647: ,'calling OKL_STREAMS_PUB.update_streams');
1648: END IF;
1649:
1650: -- historize rv streams
1651: OKL_STREAMS_PUB.update_streams(
1652: p_api_version => p_api_version,
1653: p_init_msg_list => OKC_API.G_FALSE,
1654: x_return_status => l_return_status,
1655: x_msg_count => x_msg_count,

Line 1668: ,'returning from OKL_STREAMS_PUB.update_streams'

1664: --message logging
1665: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1666: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
1667: ,'OKL_AM_SECURITIZATION_PVT.process_securitized_streams'
1668: ,'returning from OKL_STREAMS_PUB.update_streams'
1669: ||', status is '||l_return_status);
1670: END IF;
1671:
1672: /* sosharma 17-01-2008

Line 2012: OKL_STREAMS_UTIL.get_primary_stream_type(p_ia_id,

2008:
2009: IF p_asset_tbl.COUNT > 0 THEN
2010:
2011: -- smoduga +++++++++ User Defined Streams -- start ++++++++++++++++
2012: OKL_STREAMS_UTIL.get_primary_stream_type(p_ia_id,
2013: l_rent_sty,
2014: l_return_status,
2015: l_sty_id);
2016:

Line 2022: ,'OKL_STREAMS_UTIL.get_primary_stream_type returned no values');

2018: --message logging
2019: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2020: FND_LOG.STRING(FND_LOG.LEVEL_ERROR
2021: ,'OKL_AM_SECURITIZATION_PVT.disburse_investor_rent'
2022: ,'OKL_STREAMS_UTIL.get_primary_stream_type returned no values');
2023: END IF;
2024:
2025: -- smoduga +++++++++ User Defined Streams -- end ++++++++++++++++
2026: OKL_API.set_message(p_app_name => G_APP_NAME,

Line 2104: ,'calling OKL_STREAMS_PUB.create_streams ');

2100: --message logging
2101: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2102: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
2103: ,'OKL_AM_SECURITIZATION_PVT.disburse_investor_rent'
2104: ,'calling OKL_STREAMS_PUB.create_streams ');
2105: END IF;
2106:
2107: OKL_STREAMS_PUB.create_streams(
2108: p_api_version => p_api_version

Line 2107: OKL_STREAMS_PUB.create_streams(

2103: ,'OKL_AM_SECURITIZATION_PVT.disburse_investor_rent'
2104: ,'calling OKL_STREAMS_PUB.create_streams ');
2105: END IF;
2106:
2107: OKL_STREAMS_PUB.create_streams(
2108: p_api_version => p_api_version
2109: ,p_init_msg_list => p_init_msg_list
2110: ,x_return_status => l_return_status
2111: ,x_msg_count => x_msg_count

Line 2127: ,'returning from OKL_STREAMS_PUB.create_streams,'

2123: --message logging
2124: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2125: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
2126: ,'OKL_AM_SECURITIZATION_PVT.disburse_investor_rent'
2127: ,'returning from OKL_STREAMS_PUB.create_streams,'
2128: ||' status is '||l_return_status);
2129: END IF;
2130: -- gboomina Bug 4775555 - Start
2131: -- INVESTOR_DISB_ADJUSTMENTS

Line 2347: OKL_STREAMS_UTIL.get_primary_stream_type(p_ia_id,

2343:
2344: IF p_asset_tbl.COUNT > 0 THEN
2345:
2346: -- smoduga +++++++++ User Defined Streams -- start ++++++++++++++++
2347: OKL_STREAMS_UTIL.get_primary_stream_type(p_ia_id,
2348: l_rent_sty,
2349: l_return_status,
2350: l_sty_id);
2351:

Line 2357: ,'OKL_STREAMS_UTIL.get_primary_stream_type returned no values');

2353: --message logging
2354: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2355: FND_LOG.STRING(FND_LOG.LEVEL_ERROR
2356: ,'OKL_AM_SECURITIZATION_PVT.disburse_investor_loan_payment'
2357: ,'OKL_STREAMS_UTIL.get_primary_stream_type returned no values');
2358: END IF;
2359:
2360: -- smoduga +++++++++ User Defined Streams -- end ++++++++++++++++
2361: OKL_API.set_message(p_app_name => G_APP_NAME,

Line 2439: ,'calling OKL_STREAMS_PUB.create_streams ');

2435: --message logging
2436: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2437: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
2438: ,'OKL_AM_SECURITIZATION_PVT.disburse_investor_loan_payment'
2439: ,'calling OKL_STREAMS_PUB.create_streams ');
2440: END IF;
2441:
2442: OKL_STREAMS_PUB.create_streams(
2443: p_api_version => p_api_version

Line 2442: OKL_STREAMS_PUB.create_streams(

2438: ,'OKL_AM_SECURITIZATION_PVT.disburse_investor_loan_payment'
2439: ,'calling OKL_STREAMS_PUB.create_streams ');
2440: END IF;
2441:
2442: OKL_STREAMS_PUB.create_streams(
2443: p_api_version => p_api_version
2444: ,p_init_msg_list => p_init_msg_list
2445: ,x_return_status => l_return_status
2446: ,x_msg_count => x_msg_count

Line 2462: ,'returning from OKL_STREAMS_PUB.create_streams,'

2458: --message logging
2459: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2460: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
2461: ,'OKL_AM_SECURITIZATION_PVT.disburse_investor_loan_payment'
2462: ,'returning from OKL_STREAMS_PUB.create_streams,'
2463: ||' status is '||l_return_status);
2464: END IF;
2465: -- gboomina Bug 4775555 - Start
2466: -- INVESTOR_DISB_ADJUSTMENTS

Line 2702: OKL_STREAMS_UTIL.get_primary_stream_type(p_ia_id,

2698: l_disbursement_amount := (p_sale_price * l_formula_amount);
2699:
2700:
2701: -- smoduga +++++++++ User Defined Streams -- start ++++++++++++++++
2702: OKL_STREAMS_UTIL.get_primary_stream_type(p_ia_id,
2703: l_rent_sty,
2704: l_return_status,
2705: l_stmv_rec.sty_id);
2706: IF l_stmv_rec.sty_id IS NULL OR l_stmv_rec.sty_id = OKL_API.G_MISS_NUM THEN

Line 2712: ,' OKL_STREAMS_UTIL.get_primary_stream_type returned no values');

2708: --message logging
2709: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2710: FND_LOG.STRING(FND_LOG.LEVEL_ERROR
2711: ,'OKL_AM_SECURITIZATION_PVT.disburse_investor_rv'
2712: ,' OKL_STREAMS_UTIL.get_primary_stream_type returned no values');
2713: END IF;
2714: -- smoduga +++++++++ User Defined Streams -- end ++++++++++++++++
2715:
2716: OKL_API.set_message(p_app_name => G_APP_NAME,

Line 2749: ,'calling OKL_STREAMS_PUB.create_streams ');

2745: --message logging
2746: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2747: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
2748: ,'OKL_AM_SECURITIZATION_PVT.disburse_investor_rv'
2749: ,'calling OKL_STREAMS_PUB.create_streams ');
2750: END IF;
2751:
2752: -- create disbursement record
2753: OKL_STREAMS_PUB.create_streams(

Line 2753: OKL_STREAMS_PUB.create_streams(

2749: ,'calling OKL_STREAMS_PUB.create_streams ');
2750: END IF;
2751:
2752: -- create disbursement record
2753: OKL_STREAMS_PUB.create_streams(
2754: p_api_version => p_api_version
2755: ,p_init_msg_list => p_init_msg_list
2756: ,x_return_status => l_return_status
2757: ,x_msg_count => x_msg_count

Line 2773: ,'returning from OKL_STREAMS_PUB.create_streams, status is '

2769: --message logging
2770: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2771: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
2772: ,'OKL_AM_SECURITIZATION_PVT.disburse_investor_rv'
2773: ,'returning from OKL_STREAMS_PUB.create_streams, status is '
2774: ||l_return_status);
2775: END IF;
2776: END IF;
2777: --message logging