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 OKL_STREAMS

Line 640: p_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;

636: x_return_status OUT NOCOPY VARCHAR2,
637: x_se_id OUT NOCOPY NUMBER) Is
638:
639: l_prog_name CONSTANT VARCHAR2(100) := G_PKG_NAME||'.'||'generate_stub_element';
640: p_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
641: x_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
642: p_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
643: x_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
644: l_sty_id NUMBER;

Line 641: x_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;

637: x_se_id OUT NOCOPY NUMBER) Is
638:
639: l_prog_name CONSTANT VARCHAR2(100) := G_PKG_NAME||'.'||'generate_stub_element';
640: p_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
641: x_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
642: p_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
643: x_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
644: l_sty_id NUMBER;
645:

Line 642: p_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;

638:
639: l_prog_name CONSTANT VARCHAR2(100) := G_PKG_NAME||'.'||'generate_stub_element';
640: p_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
641: x_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
642: p_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
643: x_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
644: l_sty_id NUMBER;
645:
646: --prasjain:start for bug 5474827

Line 643: x_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;

639: l_prog_name CONSTANT VARCHAR2(100) := G_PKG_NAME||'.'||'generate_stub_element';
640: p_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
641: x_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
642: p_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
643: x_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
644: l_sty_id NUMBER;
645:
646: --prasjain:start for bug 5474827
647: /*

Line 650: FROM okl_streams stm,

646: --prasjain:start for bug 5474827
647: /*
648: Cursor c_sty IS
649: SELECT sel.id
650: FROM okl_streams stm,
651: okl_strm_elements sel
652: where stm.khr_id = p_khr_id
653: and stm.say_code = 'HIST'
654: and stm.SGN_CODE = 'MANL'

Line 714: okl_streams_pub.create_streams(

710: p_selv_tbl(0).parent_index := 1 ;
711:
712: -- Create the Stream Header along with one stream element.
713: --print( l_prog_name, ' b4 create_stub ' || to_char(l_sty_id) );
714: okl_streams_pub.create_streams(
715: p_api_version,
716: p_init_msg_list,
717: x_return_status,
718: x_msg_count,

Line 828: l_selv_tbl okl_streams_pub.selv_tbl_type;

824: AND kle.fee_type <> 'CAPITALIZED';
825:
826: r_rollover_fee c_rollover_fee%ROWTYPE;
827:
828: l_selv_tbl okl_streams_pub.selv_tbl_type;
829: l_tmp_selv_tbl okl_streams_pub.selv_tbl_type;
830: l_pt_tbl okl_streams_pub.selv_tbl_type;
831: lx_selv_tbl okl_streams_pub.selv_tbl_type;
832:

Line 829: l_tmp_selv_tbl okl_streams_pub.selv_tbl_type;

825:
826: r_rollover_fee c_rollover_fee%ROWTYPE;
827:
828: l_selv_tbl okl_streams_pub.selv_tbl_type;
829: l_tmp_selv_tbl okl_streams_pub.selv_tbl_type;
830: l_pt_tbl okl_streams_pub.selv_tbl_type;
831: lx_selv_tbl okl_streams_pub.selv_tbl_type;
832:
833: l_stmv_rec okl_streams_pub.stmv_rec_type;

Line 830: l_pt_tbl okl_streams_pub.selv_tbl_type;

826: r_rollover_fee c_rollover_fee%ROWTYPE;
827:
828: l_selv_tbl okl_streams_pub.selv_tbl_type;
829: l_tmp_selv_tbl okl_streams_pub.selv_tbl_type;
830: l_pt_tbl okl_streams_pub.selv_tbl_type;
831: lx_selv_tbl okl_streams_pub.selv_tbl_type;
832:
833: l_stmv_rec okl_streams_pub.stmv_rec_type;
834: l_pt_rec okl_streams_pub.stmv_rec_type;

Line 831: lx_selv_tbl okl_streams_pub.selv_tbl_type;

827:
828: l_selv_tbl okl_streams_pub.selv_tbl_type;
829: l_tmp_selv_tbl okl_streams_pub.selv_tbl_type;
830: l_pt_tbl okl_streams_pub.selv_tbl_type;
831: lx_selv_tbl okl_streams_pub.selv_tbl_type;
832:
833: l_stmv_rec okl_streams_pub.stmv_rec_type;
834: l_pt_rec okl_streams_pub.stmv_rec_type;
835: lx_stmv_rec okl_streams_pub.stmv_rec_type;

Line 833: l_stmv_rec okl_streams_pub.stmv_rec_type;

829: l_tmp_selv_tbl okl_streams_pub.selv_tbl_type;
830: l_pt_tbl okl_streams_pub.selv_tbl_type;
831: lx_selv_tbl okl_streams_pub.selv_tbl_type;
832:
833: l_stmv_rec okl_streams_pub.stmv_rec_type;
834: l_pt_rec okl_streams_pub.stmv_rec_type;
835: lx_stmv_rec okl_streams_pub.stmv_rec_type;
836:
837: l_capital_cost NUMBER;

Line 834: l_pt_rec okl_streams_pub.stmv_rec_type;

830: l_pt_tbl okl_streams_pub.selv_tbl_type;
831: lx_selv_tbl okl_streams_pub.selv_tbl_type;
832:
833: l_stmv_rec okl_streams_pub.stmv_rec_type;
834: l_pt_rec okl_streams_pub.stmv_rec_type;
835: lx_stmv_rec okl_streams_pub.stmv_rec_type;
836:
837: l_capital_cost NUMBER;
838:

Line 835: lx_stmv_rec okl_streams_pub.stmv_rec_type;

831: lx_selv_tbl okl_streams_pub.selv_tbl_type;
832:
833: l_stmv_rec okl_streams_pub.stmv_rec_type;
834: l_pt_rec okl_streams_pub.stmv_rec_type;
835: lx_stmv_rec okl_streams_pub.stmv_rec_type;
836:
837: l_capital_cost NUMBER;
838:
839: i BINARY_INTEGER := 0;

Line 864: l_principal_tbl okl_streams_pub.selv_tbl_type;

860:
861: l_se_id NUMBER;
862: l_fee_start_date DATE;
863:
864: l_principal_tbl okl_streams_pub.selv_tbl_type;
865: l_interest_tbl okl_streams_pub.selv_tbl_type;
866: l_prin_bal_tbl okl_streams_pub.selv_tbl_type;
867: l_termination_tbl okl_streams_pub.selv_tbl_type;
868: l_pre_tax_inc_tbl okl_streams_pub.selv_tbl_type;

Line 865: l_interest_tbl okl_streams_pub.selv_tbl_type;

861: l_se_id NUMBER;
862: l_fee_start_date DATE;
863:
864: l_principal_tbl okl_streams_pub.selv_tbl_type;
865: l_interest_tbl okl_streams_pub.selv_tbl_type;
866: l_prin_bal_tbl okl_streams_pub.selv_tbl_type;
867: l_termination_tbl okl_streams_pub.selv_tbl_type;
868: l_pre_tax_inc_tbl okl_streams_pub.selv_tbl_type;
869:

Line 866: l_prin_bal_tbl okl_streams_pub.selv_tbl_type;

862: l_fee_start_date DATE;
863:
864: l_principal_tbl okl_streams_pub.selv_tbl_type;
865: l_interest_tbl okl_streams_pub.selv_tbl_type;
866: l_prin_bal_tbl okl_streams_pub.selv_tbl_type;
867: l_termination_tbl okl_streams_pub.selv_tbl_type;
868: l_pre_tax_inc_tbl okl_streams_pub.selv_tbl_type;
869:
870: l_interim_interest NUMBER;

Line 867: l_termination_tbl okl_streams_pub.selv_tbl_type;

863:
864: l_principal_tbl okl_streams_pub.selv_tbl_type;
865: l_interest_tbl okl_streams_pub.selv_tbl_type;
866: l_prin_bal_tbl okl_streams_pub.selv_tbl_type;
867: l_termination_tbl okl_streams_pub.selv_tbl_type;
868: l_pre_tax_inc_tbl okl_streams_pub.selv_tbl_type;
869:
870: l_interim_interest NUMBER;
871: l_interim_days NUMBER;

Line 868: l_pre_tax_inc_tbl okl_streams_pub.selv_tbl_type;

864: l_principal_tbl okl_streams_pub.selv_tbl_type;
865: l_interest_tbl okl_streams_pub.selv_tbl_type;
866: l_prin_bal_tbl okl_streams_pub.selv_tbl_type;
867: l_termination_tbl okl_streams_pub.selv_tbl_type;
868: l_pre_tax_inc_tbl okl_streams_pub.selv_tbl_type;
869:
870: l_interim_interest NUMBER;
871: l_interim_days NUMBER;
872: l_interim_dpp NUMBER;

Line 926: update okl_streams

922: LOOP
923:
924: print( l_prog_name, ' found a roll fee ', to_char(r_rollover_fee.kleId) );
925:
926: update okl_streams
927: set say_code = 'HIST',
928: date_history = SYSDATE,
929: last_updated_by = FND_GLOBAL.USER_ID, -- BUG:14749215 changes start here
930: last_update_date = sysdate,

Line 935: update okl_streams

931: last_update_login = FND_GLOBAL.LOGIN_ID -- BUG:14749215 changes end here
932: where khr_id = p_khr_id
933: and kle_id = r_rollover_fee.kleId;
934:
935: update okl_streams
936: set active_yn = 'N',
937: last_updated_by = FND_GLOBAL.USER_ID, -- BUG:14749215 changes start here
938: last_update_date = sysdate,
939: last_update_login = FND_GLOBAL.LOGIN_ID -- BUG:14749215 changes end here

Line 1025: lx_return_status := Okl_Streams_Util.round_streams_amount(

1021: RAISE OKL_API.G_EXCEPTION_ERROR;
1022: END IF;
1023:
1024:
1025: lx_return_status := Okl_Streams_Util.round_streams_amount(
1026: p_api_version => g_api_version,
1027: p_init_msg_list => p_init_msg_list,
1028: x_msg_count => x_msg_count,
1029: x_msg_data => x_msg_data,

Line 1047: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,

1043: l_stmv_rec.say_code := 'CURR';
1044: l_stmv_rec.active_yn := 'Y';
1045: l_stmv_rec.date_current := SYSDATE;
1046:
1047: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,
1048: p_init_msg_list => G_FALSE,
1049: x_return_status => lx_return_status,
1050: x_msg_count => x_msg_count,
1051: x_msg_data => x_msg_data,

Line 1184: lx_return_status := Okl_Streams_Util.round_streams_amount(

1180: l_stmv_rec.say_code := 'CURR';
1181: l_stmv_rec.active_yn := 'Y';
1182: l_stmv_rec.date_current := SYSDATE;
1183:
1184: lx_return_status := Okl_Streams_Util.round_streams_amount(
1185: p_api_version => g_api_version,
1186: p_init_msg_list => p_init_msg_list,
1187: x_msg_count => x_msg_count,
1188: x_msg_data => x_msg_data,

Line 1202: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,

1198:
1199: l_principal_tbl.DELETE;
1200: l_principal_tbl := lx_selv_tbl;
1201:
1202: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,
1203: p_init_msg_list => G_FALSE,
1204: x_return_status => lx_return_status,
1205: x_msg_count => x_msg_count,
1206: x_msg_data => x_msg_data,

Line 1240: lx_return_status := Okl_Streams_Util.round_streams_amount(

1236: l_stmv_rec.say_code := 'CURR';
1237: l_stmv_rec.active_yn := 'Y';
1238: l_stmv_rec.date_current := SYSDATE;
1239:
1240: lx_return_status := Okl_Streams_Util.round_streams_amount(
1241: p_api_version => g_api_version,
1242: p_init_msg_list => p_init_msg_list,
1243: x_msg_count => x_msg_count,
1244: x_msg_data => x_msg_data,

Line 1258: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,

1254:
1255: l_interest_tbl.DELETE;
1256: l_interest_tbl := lx_selv_tbl;
1257:
1258: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,
1259: p_init_msg_list => G_FALSE,
1260: x_return_status => lx_return_status,
1261: x_msg_count => x_msg_count,
1262: x_msg_data => x_msg_data,

Line 1296: lx_return_status := Okl_Streams_Util.round_streams_amount(

1292: l_stmv_rec.say_code := 'CURR';
1293: l_stmv_rec.active_yn := 'Y';
1294: l_stmv_rec.date_current := SYSDATE;
1295:
1296: lx_return_status := Okl_Streams_Util.round_streams_amount(
1297: p_api_version => g_api_version,
1298: p_init_msg_list => p_init_msg_list,
1299: x_msg_count => x_msg_count,
1300: x_msg_data => x_msg_data,

Line 1314: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,

1310:
1311: l_prin_bal_tbl.DELETE;
1312: l_prin_bal_tbl := lx_selv_tbl;
1313:
1314: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,
1315: p_init_msg_list => G_FALSE,
1316: x_return_status => lx_return_status,
1317: x_msg_count => x_msg_count,
1318: x_msg_data => x_msg_data,

Line 1352: lx_return_status := Okl_Streams_Util.round_streams_amount(

1348: l_stmv_rec.say_code := 'CURR';
1349: l_stmv_rec.active_yn := 'Y';
1350: l_stmv_rec.date_current := SYSDATE;
1351:
1352: lx_return_status := Okl_Streams_Util.round_streams_amount(
1353: p_api_version => g_api_version,
1354: p_init_msg_list => p_init_msg_list,
1355: x_msg_count => x_msg_count,
1356: x_msg_data => x_msg_data,

Line 1370: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,

1366:
1367: l_termination_tbl.DELETE;
1368: l_termination_tbl := lx_selv_tbl;
1369:
1370: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,
1371: p_init_msg_list => G_FALSE,
1372: x_return_status => lx_return_status,
1373: x_msg_count => x_msg_count,
1374: x_msg_data => x_msg_data,

Line 1408: lx_return_status := Okl_Streams_Util.round_streams_amount(

1404: l_stmv_rec.active_yn := 'Y';
1405: l_stmv_rec.date_current := SYSDATE;
1406:
1407:
1408: lx_return_status := Okl_Streams_Util.round_streams_amount(
1409: p_api_version => g_api_version,
1410: p_init_msg_list => p_init_msg_list,
1411: x_msg_count => x_msg_count,
1412: x_msg_data => x_msg_data,

Line 1426: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,

1422:
1423: l_pre_tax_inc_tbl.DELETE;
1424: l_pre_tax_inc_tbl := lx_selv_tbl;
1425:
1426: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,
1427: p_init_msg_list => G_FALSE,
1428: x_return_status => lx_return_status,
1429: x_msg_count => x_msg_count,
1430: x_msg_data => x_msg_data,

Line 1637: okl_streams stm,

1633: CURSOR c_k_income (p_sty_name VARCHAR2) IS
1634: SELECT sel.amount income_amount,
1635: sel.stream_element_date income_date
1636: FROM okl_strm_elements sel,
1637: okl_streams stm,
1638: okl_strm_type_b sty,
1639: okl_strm_type_tl styt
1640: WHERE stm.khr_id = p_khr_id
1641: AND stm.say_code = 'WORK'

Line 1652: l_selv_tbl okl_streams_pub.selv_tbl_type;

1648: AND sel.stream_element_date >= p_start_date
1649: AND sel.stream_element_date <= LAST_DAY(p_end_date) --bug# 3379436
1650: ORDER BY sel.stream_element_date;
1651:
1652: l_selv_tbl okl_streams_pub.selv_tbl_type;
1653: lx_selv_tbl okl_streams_pub.selv_tbl_type;
1654:
1655: l_stmv_rec okl_streams_pub.stmv_rec_type;
1656: lx_stmv_rec okl_streams_pub.stmv_rec_type;

Line 1653: lx_selv_tbl okl_streams_pub.selv_tbl_type;

1649: AND sel.stream_element_date <= LAST_DAY(p_end_date) --bug# 3379436
1650: ORDER BY sel.stream_element_date;
1651:
1652: l_selv_tbl okl_streams_pub.selv_tbl_type;
1653: lx_selv_tbl okl_streams_pub.selv_tbl_type;
1654:
1655: l_stmv_rec okl_streams_pub.stmv_rec_type;
1656: lx_stmv_rec okl_streams_pub.stmv_rec_type;
1657:

Line 1655: l_stmv_rec okl_streams_pub.stmv_rec_type;

1651:
1652: l_selv_tbl okl_streams_pub.selv_tbl_type;
1653: lx_selv_tbl okl_streams_pub.selv_tbl_type;
1654:
1655: l_stmv_rec okl_streams_pub.stmv_rec_type;
1656: lx_stmv_rec okl_streams_pub.stmv_rec_type;
1657:
1658: l_amortized_exp_id NUMBER;
1659: l_sty_name VARCHAR2(150);

Line 1656: lx_stmv_rec okl_streams_pub.stmv_rec_type;

1652: l_selv_tbl okl_streams_pub.selv_tbl_type;
1653: lx_selv_tbl okl_streams_pub.selv_tbl_type;
1654:
1655: l_stmv_rec okl_streams_pub.stmv_rec_type;
1656: lx_stmv_rec okl_streams_pub.stmv_rec_type;
1657:
1658: l_amortized_exp_id NUMBER;
1659: l_sty_name VARCHAR2(150);
1660: l_sty_id NUMBER;

Line 3084: x_selv_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,

3080: p_stub_amount IN NUMBER,
3081: p_currency_code IN VARCHAR2,
3082: p_day_convention_month IN VARCHAR2 DEFAULT '30',
3083: p_day_convention_year IN VARCHAR2 DEFAULT '360',
3084: x_selv_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
3085: x_return_status OUT NOCOPY VARCHAR2) IS
3086:
3087: lx_return_status VARCHAR2(1);
3088:

Line 3445: FROM okl_streams stm

3441:
3442: CURSOR c_stm_count IS
3443: SELECT COUNT(stm.id),
3444: stm.sty_id
3445: FROM okl_streams stm
3446: WHERE stm.khr_id = p_khr_id
3447: AND stm.say_code = 'WORK'
3448: AND NVL(stm.purpose_code, '-99') = p_purpose_code
3449: AND stm.kle_id IS NULL

Line 3455: FROM okl_streams

3451: GROUP BY stm.kle_id, stm.sty_id;
3452:
3453: CURSOR c_stm_first (p_sty_id NUMBER) IS
3454: SELECT id
3455: FROM okl_streams
3456: WHERE khr_id = p_khr_id
3457: AND kle_id IS NULL
3458: AND say_code = 'WORK'
3459: AND sty_id = p_sty_id

Line 3464: FROM okl_streams

3460: AND NVL(purpose_code, '-99') = p_purpose_code;
3461:
3462: CURSOR c_stm (p_sty_id NUMBER, p_stm_id NUMBER) IS
3463: SELECT id
3464: FROM okl_streams
3465: WHERE khr_id = p_khr_id
3466: AND kle_id IS NULL
3467: AND sty_id = p_sty_id
3468: AND say_code = 'WORK'

Line 3503: DELETE FROM okl_streams WHERE id = l_stm.id

3499: CLOSE c_last_sel;
3500:
3501: FOR l_stm IN c_stm (l_stm_count.sty_id, l_stm_first) LOOP
3502:
3503: DELETE FROM okl_streams WHERE id = l_stm.id
3504: and khr_id = p_khr_id;
3505:
3506: FOR l_sel IN c_sel (l_stm.id) LOOP
3507:

Line 3524: DELETE FROM OKL_STREAMS WHERE purpose_code = 'STUBS'

3520:
3521: END LOOP;
3522:
3523:
3524: DELETE FROM OKL_STREAMS WHERE purpose_code = 'STUBS'
3525: and khr_id = p_khr_id;
3526: x_return_status := G_RET_STS_SUCCESS;
3527: print( l_prog_name, 'end' );
3528:

Line 3568: FROM okl_streams stm,

3564: CURSOR c_stm_count IS
3565: SELECT COUNT(stm.id),
3566: stm.kle_id,
3567: stm.sty_id
3568: FROM okl_streams stm,
3569: okc_k_lines_b cle,
3570: okc_line_styles_b lse
3571: WHERE stm.khr_id = p_khr_id
3572: AND stm.say_code = 'WORK'

Line 3583: FROM okl_streams

3579: GROUP BY stm.kle_id, stm.sty_id;
3580:
3581: CURSOR c_stm_first (p_kle_id NUMBER, p_sty_id NUMBER) IS
3582: SELECT id
3583: FROM okl_streams
3584: WHERE khr_id = p_khr_id
3585: AND kle_id = p_kle_id
3586: AND sty_id = p_sty_id
3587: AND say_code = 'WORK'

Line 3592: FROM okl_streams

3588: AND NVL(purpose_code, '-99') = p_purpose_code;
3589:
3590: CURSOR c_stm (p_kle_id NUMBER, p_sty_id NUMBER, p_stm_id NUMBER) IS
3591: SELECT id
3592: FROM okl_streams
3593: WHERE khr_id = p_khr_id
3594: AND kle_id = p_kle_id
3595: AND sty_id = p_sty_id
3596: AND say_code = 'WORK'

Line 3632: DELETE FROM okl_streams WHERE id = l_stm.id

3628: CLOSE c_last_sel;
3629:
3630: FOR l_stm IN c_stm (l_stm_count.kle_id, l_stm_count.sty_id, l_stm_first) LOOP
3631:
3632: DELETE FROM okl_streams WHERE id = l_stm.id
3633: and khr_id = p_khr_id;
3634:
3635: FOR l_sel IN c_sel (l_stm.id) LOOP
3636:

Line 3651: DELETE FROM OKL_STREAMS WHERE purpose_code = 'STUBS'

3647:
3648: END LOOP;
3649:
3650:
3651: DELETE FROM OKL_STREAMS WHERE purpose_code = 'STUBS'
3652: and khr_id = p_khr_id;
3653:
3654: x_return_status := G_RET_STS_SUCCESS;
3655: print( l_prog_name, 'end' );

Line 3709: FROM okl_streams stm,

3705: stm.kle_id kle_id,
3706: stm.sty_id,
3707: sty.stream_type_purpose stm_purpose,
3708: ele.amount amount
3709: FROM okl_streams stm,
3710: okl_strm_elements ele,
3711: okl_strm_type_b sty
3712: WHERE stm.khr_id = p_khr_id
3713: AND ele.stm_id = stm.id

Line 3737: eleid_tbl Okl_Streams_Util.NumberTabTyp;

3733: l_line_num NUMBER;
3734: n NUMBER := 0;
3735:
3736: -- Added by RGOOTY
3737: eleid_tbl Okl_Streams_Util.NumberTabTyp;
3738: streamid_tbl Okl_Streams_Util.NumberTabTyp;
3739: sel_date Okl_Streams_Util.DateTabTyp;
3740:
3741: lom_date DATE;

Line 3738: streamid_tbl Okl_Streams_Util.NumberTabTyp;

3734: n NUMBER := 0;
3735:
3736: -- Added by RGOOTY
3737: eleid_tbl Okl_Streams_Util.NumberTabTyp;
3738: streamid_tbl Okl_Streams_Util.NumberTabTyp;
3739: sel_date Okl_Streams_Util.DateTabTyp;
3740:
3741: lom_date DATE;
3742: i NUMBER;

Line 3739: sel_date Okl_Streams_Util.DateTabTyp;

3735:
3736: -- Added by RGOOTY
3737: eleid_tbl Okl_Streams_Util.NumberTabTyp;
3738: streamid_tbl Okl_Streams_Util.NumberTabTyp;
3739: sel_date Okl_Streams_Util.DateTabTyp;
3740:
3741: lom_date DATE;
3742: i NUMBER;
3743: -- Added by RGOOTY: 4403311

Line 3750: l_ele_id_all_tbl Okl_Streams_Util.NumberTabTyp;

3746: j NUMBER;
3747: r NUMBER;
3748:
3749:
3750: l_ele_id_all_tbl Okl_Streams_Util.NumberTabTyp;
3751: l_streamid_all_tbl Okl_Streams_Util.NumberTabTyp;
3752: l_sel_date_all_tbl Okl_Streams_Util.DateTabTyp;
3753: l_kle_id_all_tbl Okl_Streams_Util.NumberTabTyp;
3754: l_amt_all_tbl Okl_Streams_Util.NumberTabTyp;

Line 3751: l_streamid_all_tbl Okl_Streams_Util.NumberTabTyp;

3747: r NUMBER;
3748:
3749:
3750: l_ele_id_all_tbl Okl_Streams_Util.NumberTabTyp;
3751: l_streamid_all_tbl Okl_Streams_Util.NumberTabTyp;
3752: l_sel_date_all_tbl Okl_Streams_Util.DateTabTyp;
3753: l_kle_id_all_tbl Okl_Streams_Util.NumberTabTyp;
3754: l_amt_all_tbl Okl_Streams_Util.NumberTabTyp;
3755: l_stm_purpose_all_tbl Okl_Streams_Util.Var150TabTyp;

Line 3752: l_sel_date_all_tbl Okl_Streams_Util.DateTabTyp;

3748:
3749:
3750: l_ele_id_all_tbl Okl_Streams_Util.NumberTabTyp;
3751: l_streamid_all_tbl Okl_Streams_Util.NumberTabTyp;
3752: l_sel_date_all_tbl Okl_Streams_Util.DateTabTyp;
3753: l_kle_id_all_tbl Okl_Streams_Util.NumberTabTyp;
3754: l_amt_all_tbl Okl_Streams_Util.NumberTabTyp;
3755: l_stm_purpose_all_tbl Okl_Streams_Util.Var150TabTyp;
3756:

Line 3753: l_kle_id_all_tbl Okl_Streams_Util.NumberTabTyp;

3749:
3750: l_ele_id_all_tbl Okl_Streams_Util.NumberTabTyp;
3751: l_streamid_all_tbl Okl_Streams_Util.NumberTabTyp;
3752: l_sel_date_all_tbl Okl_Streams_Util.DateTabTyp;
3753: l_kle_id_all_tbl Okl_Streams_Util.NumberTabTyp;
3754: l_amt_all_tbl Okl_Streams_Util.NumberTabTyp;
3755: l_stm_purpose_all_tbl Okl_Streams_Util.Var150TabTyp;
3756:
3757: --Added by dpsingh for bug 5503678

Line 3754: l_amt_all_tbl Okl_Streams_Util.NumberTabTyp;

3750: l_ele_id_all_tbl Okl_Streams_Util.NumberTabTyp;
3751: l_streamid_all_tbl Okl_Streams_Util.NumberTabTyp;
3752: l_sel_date_all_tbl Okl_Streams_Util.DateTabTyp;
3753: l_kle_id_all_tbl Okl_Streams_Util.NumberTabTyp;
3754: l_amt_all_tbl Okl_Streams_Util.NumberTabTyp;
3755: l_stm_purpose_all_tbl Okl_Streams_Util.Var150TabTyp;
3756:
3757: --Added by dpsingh for bug 5503678
3758: l_sty_id_all_tbl Okl_Streams_Util.NumberTabTyp;

Line 3755: l_stm_purpose_all_tbl Okl_Streams_Util.Var150TabTyp;

3751: l_streamid_all_tbl Okl_Streams_Util.NumberTabTyp;
3752: l_sel_date_all_tbl Okl_Streams_Util.DateTabTyp;
3753: l_kle_id_all_tbl Okl_Streams_Util.NumberTabTyp;
3754: l_amt_all_tbl Okl_Streams_Util.NumberTabTyp;
3755: l_stm_purpose_all_tbl Okl_Streams_Util.Var150TabTyp;
3756:
3757: --Added by dpsingh for bug 5503678
3758: l_sty_id_all_tbl Okl_Streams_Util.NumberTabTyp;
3759:

Line 3758: l_sty_id_all_tbl Okl_Streams_Util.NumberTabTyp;

3754: l_amt_all_tbl Okl_Streams_Util.NumberTabTyp;
3755: l_stm_purpose_all_tbl Okl_Streams_Util.Var150TabTyp;
3756:
3757: --Added by dpsingh for bug 5503678
3758: l_sty_id_all_tbl Okl_Streams_Util.NumberTabTyp;
3759:
3760: l_ele_id_mod_tbl Okl_Streams_Util.NumberTabTyp;
3761: l_streamid_mod_tbl Okl_Streams_Util.NumberTabTyp;
3762: l_sel_date_mod_tbl Okl_Streams_Util.DateTabTyp;

Line 3760: l_ele_id_mod_tbl Okl_Streams_Util.NumberTabTyp;

3756:
3757: --Added by dpsingh for bug 5503678
3758: l_sty_id_all_tbl Okl_Streams_Util.NumberTabTyp;
3759:
3760: l_ele_id_mod_tbl Okl_Streams_Util.NumberTabTyp;
3761: l_streamid_mod_tbl Okl_Streams_Util.NumberTabTyp;
3762: l_sel_date_mod_tbl Okl_Streams_Util.DateTabTyp;
3763: l_kle_id_mod_tbl Okl_Streams_Util.NumberTabTyp;
3764: l_amt_mod_tbl Okl_Streams_Util.NumberTabTyp;

Line 3761: l_streamid_mod_tbl Okl_Streams_Util.NumberTabTyp;

3757: --Added by dpsingh for bug 5503678
3758: l_sty_id_all_tbl Okl_Streams_Util.NumberTabTyp;
3759:
3760: l_ele_id_mod_tbl Okl_Streams_Util.NumberTabTyp;
3761: l_streamid_mod_tbl Okl_Streams_Util.NumberTabTyp;
3762: l_sel_date_mod_tbl Okl_Streams_Util.DateTabTyp;
3763: l_kle_id_mod_tbl Okl_Streams_Util.NumberTabTyp;
3764: l_amt_mod_tbl Okl_Streams_Util.NumberTabTyp;
3765: l_stm_purpose_mod_tbl Okl_Streams_Util.Var150TabTyp;

Line 3762: l_sel_date_mod_tbl Okl_Streams_Util.DateTabTyp;

3758: l_sty_id_all_tbl Okl_Streams_Util.NumberTabTyp;
3759:
3760: l_ele_id_mod_tbl Okl_Streams_Util.NumberTabTyp;
3761: l_streamid_mod_tbl Okl_Streams_Util.NumberTabTyp;
3762: l_sel_date_mod_tbl Okl_Streams_Util.DateTabTyp;
3763: l_kle_id_mod_tbl Okl_Streams_Util.NumberTabTyp;
3764: l_amt_mod_tbl Okl_Streams_Util.NumberTabTyp;
3765: l_stm_purpose_mod_tbl Okl_Streams_Util.Var150TabTyp;
3766:

Line 3763: l_kle_id_mod_tbl Okl_Streams_Util.NumberTabTyp;

3759:
3760: l_ele_id_mod_tbl Okl_Streams_Util.NumberTabTyp;
3761: l_streamid_mod_tbl Okl_Streams_Util.NumberTabTyp;
3762: l_sel_date_mod_tbl Okl_Streams_Util.DateTabTyp;
3763: l_kle_id_mod_tbl Okl_Streams_Util.NumberTabTyp;
3764: l_amt_mod_tbl Okl_Streams_Util.NumberTabTyp;
3765: l_stm_purpose_mod_tbl Okl_Streams_Util.Var150TabTyp;
3766:
3767: l_ele_id_del_tbl Okl_Streams_Util.NumberTabTyp;

Line 3764: l_amt_mod_tbl Okl_Streams_Util.NumberTabTyp;

3760: l_ele_id_mod_tbl Okl_Streams_Util.NumberTabTyp;
3761: l_streamid_mod_tbl Okl_Streams_Util.NumberTabTyp;
3762: l_sel_date_mod_tbl Okl_Streams_Util.DateTabTyp;
3763: l_kle_id_mod_tbl Okl_Streams_Util.NumberTabTyp;
3764: l_amt_mod_tbl Okl_Streams_Util.NumberTabTyp;
3765: l_stm_purpose_mod_tbl Okl_Streams_Util.Var150TabTyp;
3766:
3767: l_ele_id_del_tbl Okl_Streams_Util.NumberTabTyp;
3768: l_streamid_del_tbl Okl_Streams_Util.NumberTabTyp;

Line 3765: l_stm_purpose_mod_tbl Okl_Streams_Util.Var150TabTyp;

3761: l_streamid_mod_tbl Okl_Streams_Util.NumberTabTyp;
3762: l_sel_date_mod_tbl Okl_Streams_Util.DateTabTyp;
3763: l_kle_id_mod_tbl Okl_Streams_Util.NumberTabTyp;
3764: l_amt_mod_tbl Okl_Streams_Util.NumberTabTyp;
3765: l_stm_purpose_mod_tbl Okl_Streams_Util.Var150TabTyp;
3766:
3767: l_ele_id_del_tbl Okl_Streams_Util.NumberTabTyp;
3768: l_streamid_del_tbl Okl_Streams_Util.NumberTabTyp;
3769: l_sel_date_del_tbl Okl_Streams_Util.DateTabTyp;

Line 3767: l_ele_id_del_tbl Okl_Streams_Util.NumberTabTyp;

3763: l_kle_id_mod_tbl Okl_Streams_Util.NumberTabTyp;
3764: l_amt_mod_tbl Okl_Streams_Util.NumberTabTyp;
3765: l_stm_purpose_mod_tbl Okl_Streams_Util.Var150TabTyp;
3766:
3767: l_ele_id_del_tbl Okl_Streams_Util.NumberTabTyp;
3768: l_streamid_del_tbl Okl_Streams_Util.NumberTabTyp;
3769: l_sel_date_del_tbl Okl_Streams_Util.DateTabTyp;
3770: l_kle_id_del_tbl Okl_Streams_Util.NumberTabTyp;
3771: l_amt_del_tbl Okl_Streams_Util.NumberTabTyp;

Line 3768: l_streamid_del_tbl Okl_Streams_Util.NumberTabTyp;

3764: l_amt_mod_tbl Okl_Streams_Util.NumberTabTyp;
3765: l_stm_purpose_mod_tbl Okl_Streams_Util.Var150TabTyp;
3766:
3767: l_ele_id_del_tbl Okl_Streams_Util.NumberTabTyp;
3768: l_streamid_del_tbl Okl_Streams_Util.NumberTabTyp;
3769: l_sel_date_del_tbl Okl_Streams_Util.DateTabTyp;
3770: l_kle_id_del_tbl Okl_Streams_Util.NumberTabTyp;
3771: l_amt_del_tbl Okl_Streams_Util.NumberTabTyp;
3772: l_stm_purpose_del_tbl Okl_Streams_Util.Var150TabTyp;

Line 3769: l_sel_date_del_tbl Okl_Streams_Util.DateTabTyp;

3765: l_stm_purpose_mod_tbl Okl_Streams_Util.Var150TabTyp;
3766:
3767: l_ele_id_del_tbl Okl_Streams_Util.NumberTabTyp;
3768: l_streamid_del_tbl Okl_Streams_Util.NumberTabTyp;
3769: l_sel_date_del_tbl Okl_Streams_Util.DateTabTyp;
3770: l_kle_id_del_tbl Okl_Streams_Util.NumberTabTyp;
3771: l_amt_del_tbl Okl_Streams_Util.NumberTabTyp;
3772: l_stm_purpose_del_tbl Okl_Streams_Util.Var150TabTyp;
3773:

Line 3770: l_kle_id_del_tbl Okl_Streams_Util.NumberTabTyp;

3766:
3767: l_ele_id_del_tbl Okl_Streams_Util.NumberTabTyp;
3768: l_streamid_del_tbl Okl_Streams_Util.NumberTabTyp;
3769: l_sel_date_del_tbl Okl_Streams_Util.DateTabTyp;
3770: l_kle_id_del_tbl Okl_Streams_Util.NumberTabTyp;
3771: l_amt_del_tbl Okl_Streams_Util.NumberTabTyp;
3772: l_stm_purpose_del_tbl Okl_Streams_Util.Var150TabTyp;
3773:
3774: l_sum_amount NUMBER;

Line 3771: l_amt_del_tbl Okl_Streams_Util.NumberTabTyp;

3767: l_ele_id_del_tbl Okl_Streams_Util.NumberTabTyp;
3768: l_streamid_del_tbl Okl_Streams_Util.NumberTabTyp;
3769: l_sel_date_del_tbl Okl_Streams_Util.DateTabTyp;
3770: l_kle_id_del_tbl Okl_Streams_Util.NumberTabTyp;
3771: l_amt_del_tbl Okl_Streams_Util.NumberTabTyp;
3772: l_stm_purpose_del_tbl Okl_Streams_Util.Var150TabTyp;
3773:
3774: l_sum_amount NUMBER;
3775: BEGIN

Line 3772: l_stm_purpose_del_tbl Okl_Streams_Util.Var150TabTyp;

3768: l_streamid_del_tbl Okl_Streams_Util.NumberTabTyp;
3769: l_sel_date_del_tbl Okl_Streams_Util.DateTabTyp;
3770: l_kle_id_del_tbl Okl_Streams_Util.NumberTabTyp;
3771: l_amt_del_tbl Okl_Streams_Util.NumberTabTyp;
3772: l_stm_purpose_del_tbl Okl_Streams_Util.Var150TabTyp;
3773:
3774: l_sum_amount NUMBER;
3775: BEGIN
3776:

Line 4011: l_selv_tbl okl_streams_pub.selv_tbl_type;

4007: l_sty_id NUMBER;
4008: l_sty_name VARCHAR2(150);
4009: l_mapped_sty_name VARCHAR2(150);
4010:
4011: l_selv_tbl okl_streams_pub.selv_tbl_type;
4012: l_tmp_selv_tbl okl_streams_pub.selv_tbl_type;
4013: l_pt_tbl okl_streams_pub.selv_tbl_type;
4014: lx_selv_tbl okl_streams_pub.selv_tbl_type;
4015:

Line 4012: l_tmp_selv_tbl okl_streams_pub.selv_tbl_type;

4008: l_sty_name VARCHAR2(150);
4009: l_mapped_sty_name VARCHAR2(150);
4010:
4011: l_selv_tbl okl_streams_pub.selv_tbl_type;
4012: l_tmp_selv_tbl okl_streams_pub.selv_tbl_type;
4013: l_pt_tbl okl_streams_pub.selv_tbl_type;
4014: lx_selv_tbl okl_streams_pub.selv_tbl_type;
4015:
4016: l_stmv_rec okl_streams_pub.stmv_rec_type;

Line 4013: l_pt_tbl okl_streams_pub.selv_tbl_type;

4009: l_mapped_sty_name VARCHAR2(150);
4010:
4011: l_selv_tbl okl_streams_pub.selv_tbl_type;
4012: l_tmp_selv_tbl okl_streams_pub.selv_tbl_type;
4013: l_pt_tbl okl_streams_pub.selv_tbl_type;
4014: lx_selv_tbl okl_streams_pub.selv_tbl_type;
4015:
4016: l_stmv_rec okl_streams_pub.stmv_rec_type;
4017: l_pt_rec okl_streams_pub.stmv_rec_type;

Line 4014: lx_selv_tbl okl_streams_pub.selv_tbl_type;

4010:
4011: l_selv_tbl okl_streams_pub.selv_tbl_type;
4012: l_tmp_selv_tbl okl_streams_pub.selv_tbl_type;
4013: l_pt_tbl okl_streams_pub.selv_tbl_type;
4014: lx_selv_tbl okl_streams_pub.selv_tbl_type;
4015:
4016: l_stmv_rec okl_streams_pub.stmv_rec_type;
4017: l_pt_rec okl_streams_pub.stmv_rec_type;
4018: lx_stmv_rec okl_streams_pub.stmv_rec_type;

Line 4016: l_stmv_rec okl_streams_pub.stmv_rec_type;

4012: l_tmp_selv_tbl okl_streams_pub.selv_tbl_type;
4013: l_pt_tbl okl_streams_pub.selv_tbl_type;
4014: lx_selv_tbl okl_streams_pub.selv_tbl_type;
4015:
4016: l_stmv_rec okl_streams_pub.stmv_rec_type;
4017: l_pt_rec okl_streams_pub.stmv_rec_type;
4018: lx_stmv_rec okl_streams_pub.stmv_rec_type;
4019:
4020: l_capital_cost NUMBER;

Line 4017: l_pt_rec okl_streams_pub.stmv_rec_type;

4013: l_pt_tbl okl_streams_pub.selv_tbl_type;
4014: lx_selv_tbl okl_streams_pub.selv_tbl_type;
4015:
4016: l_stmv_rec okl_streams_pub.stmv_rec_type;
4017: l_pt_rec okl_streams_pub.stmv_rec_type;
4018: lx_stmv_rec okl_streams_pub.stmv_rec_type;
4019:
4020: l_capital_cost NUMBER;
4021:

Line 4018: lx_stmv_rec okl_streams_pub.stmv_rec_type;

4014: lx_selv_tbl okl_streams_pub.selv_tbl_type;
4015:
4016: l_stmv_rec okl_streams_pub.stmv_rec_type;
4017: l_pt_rec okl_streams_pub.stmv_rec_type;
4018: lx_stmv_rec okl_streams_pub.stmv_rec_type;
4019:
4020: l_capital_cost NUMBER;
4021:
4022: i BINARY_INTEGER := 0;

Line 4108: FROM okl_streams stm,

4104: sty.stream_type_purpose cf_purpose,
4105: sll.object1_id1 cf_frequency,
4106: DECODE(sll.object1_id1, 'M', 30, 'Q', 90, 'S', 180, 'A', 360) days_per_period,
4107: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year
4108: FROM okl_streams stm,
4109: okl_strm_type_b sty,
4110: okl_strm_elements sel,
4111: okc_k_lines_b cle,
4112: okc_line_styles_b lse,

Line 4162: l_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;

4158: l_capred_sty_name VARCHAR2(150);
4159:
4160: -- Added by RGOOTY : End
4161: -- Added by RGOOTY for perf.: Bug Number 4346646 Start
4162: l_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
4163: l_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
4164:
4165: lx_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
4166: lx_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;

Line 4163: l_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;

4159:
4160: -- Added by RGOOTY : End
4161: -- Added by RGOOTY for perf.: Bug Number 4346646 Start
4162: l_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
4163: l_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
4164:
4165: lx_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
4166: lx_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
4167: -- Added by RGOOTY for perf.: End

Line 4165: lx_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;

4161: -- Added by RGOOTY for perf.: Bug Number 4346646 Start
4162: l_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
4163: l_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
4164:
4165: lx_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
4166: lx_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
4167: -- Added by RGOOTY for perf.: End
4168:
4169: -- djanaswa ER6274342 start

Line 4166: lx_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;

4162: l_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
4163: l_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
4164:
4165: lx_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
4166: lx_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
4167: -- Added by RGOOTY for perf.: End
4168:
4169: -- djanaswa ER6274342 start
4170: l_arrears_pay_dates_option okl_st_gen_tmpt_sets_all.isg_arrears_pay_dates_option%type;

Line 4256: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(

4252:
4253: l_selv_tbl(1).se_line_number := 1;
4254: l_selv_tbl(1).accrued_yn := NULL;
4255:
4256: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(
4257: p_api_version => g_api_version,
4258: p_init_msg_list => p_init_msg_list,
4259: x_msg_count => x_msg_count,
4260: x_msg_data => x_msg_data,

Line 4278: OKL_STREAMS_UTIL.accumulate_strm_headers(

4274: END IF;
4275: l_selv_tbl.DELETE;
4276: l_selv_tbl := lx_selv_tbl;
4277: --Accumulate Stream Header: 4346646
4278: OKL_STREAMS_UTIL.accumulate_strm_headers(
4279: p_stmv_rec => l_stmv_rec,
4280: x_full_stmv_tbl => l_stmv_tbl,
4281: x_return_status => lx_return_status );
4282: IF (lx_return_status = G_RET_STS_UNEXP_ERROR) THEN

Line 4288: OKL_STREAMS_UTIL.accumulate_strm_elements(

4284: ELSIF (lx_return_status = G_RET_STS_ERROR) THEN
4285: RAISE OKL_API.G_EXCEPTION_ERROR;
4286: END IF;
4287: --Accumulate Stream Elements
4288: OKL_STREAMS_UTIL.accumulate_strm_elements(
4289: p_stm_index_no => l_stmv_tbl.LAST,
4290: p_selv_tbl => l_selv_tbl,
4291: x_full_selv_tbl => l_full_selv_tbl,
4292: x_return_status => lx_return_status );

Line 4349: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(

4345: l_selv_tbl(1).stream_element_date := l_hdr.start_date;
4346: l_selv_tbl(1).se_line_number := 1;
4347: l_selv_tbl(1).accrued_yn := NULL;
4348:
4349: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(
4350: p_api_version => g_api_version,
4351: p_init_msg_list => p_init_msg_list,
4352: x_msg_count => x_msg_count,
4353: x_msg_data => x_msg_data,

Line 4373: OKL_STREAMS_UTIL.accumulate_strm_headers(

4369: l_selv_tbl.DELETE;
4370: l_selv_tbl := lx_selv_tbl;
4371:
4372: --Accumulate Stream Header: 4346646
4373: OKL_STREAMS_UTIL.accumulate_strm_headers(
4374: p_stmv_rec => l_stmv_rec,
4375: x_full_stmv_tbl => l_stmv_tbl,
4376: x_return_status => lx_return_status );
4377: IF (lx_return_status = G_RET_STS_UNEXP_ERROR) THEN

Line 4384: OKL_STREAMS_UTIL.accumulate_strm_elements(

4380: RAISE OKL_API.G_EXCEPTION_ERROR;
4381: END IF;
4382:
4383: --Accumulate Stream Elements
4384: OKL_STREAMS_UTIL.accumulate_strm_elements(
4385: p_stm_index_no => l_stmv_tbl.LAST,
4386: p_selv_tbl => l_selv_tbl,
4387: x_full_selv_tbl => l_full_selv_tbl,
4388: x_return_status => lx_return_status );

Line 4562: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(

4558: RAISE OKL_API.G_EXCEPTION_ERROR;
4559: END IF;
4560:
4561:
4562: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(
4563: p_api_version => g_api_version,
4564: p_init_msg_list => p_init_msg_list,
4565: x_msg_count => x_msg_count,
4566: x_msg_data => x_msg_data,

Line 4585: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,

4581:
4582: l_selv_tbl.DELETE;
4583: l_selv_tbl := lx_selv_tbl;
4584:
4585: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,
4586: p_init_msg_list => G_FALSE,
4587: x_return_status => lx_return_status,
4588: x_msg_count => x_msg_count,
4589: x_msg_data => x_msg_data,

Line 4707: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(

4703: l_selv_tbl(i).comments := r_inflow_line_tbl(i).cf_arrear;
4704: END LOOP;
4705:
4706:
4707: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(
4708: p_api_version => p_api_version,
4709: p_init_msg_list => p_init_msg_list,
4710: x_msg_count => x_msg_count,
4711: x_msg_data => x_msg_data,

Line 4730: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,

4726:
4727: l_selv_tbl.DELETE;
4728: l_selv_tbl := lx_selv_tbl;
4729:
4730: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,
4731: p_init_msg_list => G_FALSE,
4732: x_return_status => lx_return_status,
4733: x_msg_count => x_msg_count,
4734: x_msg_data => x_msg_data,

Line 4753: Okl_Streams_Pub.create_streams_perf(

4749: --Create all the accumulated Streams at one shot ..
4750: IF l_stmv_tbl.COUNT > 0 AND
4751: l_full_selv_tbl.COUNT > 0
4752: THEN
4753: Okl_Streams_Pub.create_streams_perf(
4754: p_api_version,
4755: p_init_msg_list,
4756: lx_return_status,
4757: x_msg_count,

Line 4855: l_selv_tbl okl_streams_pub.selv_tbl_type;

4851: l_interest_id NUMBER;
4852: l_prin_bal_id NUMBER;
4853: l_termination_id NUMBER;
4854:
4855: l_selv_tbl okl_streams_pub.selv_tbl_type;
4856: l_pt_tbl okl_streams_pub.selv_tbl_type;
4857: lx_selv_tbl okl_streams_pub.selv_tbl_type;
4858:
4859: l_stmv_rec okl_streams_pub.stmv_rec_type;

Line 4856: l_pt_tbl okl_streams_pub.selv_tbl_type;

4852: l_prin_bal_id NUMBER;
4853: l_termination_id NUMBER;
4854:
4855: l_selv_tbl okl_streams_pub.selv_tbl_type;
4856: l_pt_tbl okl_streams_pub.selv_tbl_type;
4857: lx_selv_tbl okl_streams_pub.selv_tbl_type;
4858:
4859: l_stmv_rec okl_streams_pub.stmv_rec_type;
4860: l_pt_rec okl_streams_pub.stmv_rec_type;

Line 4857: lx_selv_tbl okl_streams_pub.selv_tbl_type;

4853: l_termination_id NUMBER;
4854:
4855: l_selv_tbl okl_streams_pub.selv_tbl_type;
4856: l_pt_tbl okl_streams_pub.selv_tbl_type;
4857: lx_selv_tbl okl_streams_pub.selv_tbl_type;
4858:
4859: l_stmv_rec okl_streams_pub.stmv_rec_type;
4860: l_pt_rec okl_streams_pub.stmv_rec_type;
4861: lx_stmv_rec okl_streams_pub.stmv_rec_type;

Line 4859: l_stmv_rec okl_streams_pub.stmv_rec_type;

4855: l_selv_tbl okl_streams_pub.selv_tbl_type;
4856: l_pt_tbl okl_streams_pub.selv_tbl_type;
4857: lx_selv_tbl okl_streams_pub.selv_tbl_type;
4858:
4859: l_stmv_rec okl_streams_pub.stmv_rec_type;
4860: l_pt_rec okl_streams_pub.stmv_rec_type;
4861: lx_stmv_rec okl_streams_pub.stmv_rec_type;
4862:
4863: i BINARY_INTEGER := 0;

Line 4860: l_pt_rec okl_streams_pub.stmv_rec_type;

4856: l_pt_tbl okl_streams_pub.selv_tbl_type;
4857: lx_selv_tbl okl_streams_pub.selv_tbl_type;
4858:
4859: l_stmv_rec okl_streams_pub.stmv_rec_type;
4860: l_pt_rec okl_streams_pub.stmv_rec_type;
4861: lx_stmv_rec okl_streams_pub.stmv_rec_type;
4862:
4863: i BINARY_INTEGER := 0;
4864: j BINARY_INTEGER := 0;

Line 4861: lx_stmv_rec okl_streams_pub.stmv_rec_type;

4857: lx_selv_tbl okl_streams_pub.selv_tbl_type;
4858:
4859: l_stmv_rec okl_streams_pub.stmv_rec_type;
4860: l_pt_rec okl_streams_pub.stmv_rec_type;
4861: lx_stmv_rec okl_streams_pub.stmv_rec_type;
4862:
4863: i BINARY_INTEGER := 0;
4864: j BINARY_INTEGER := 0;
4865: l_ele_count BINARY_INTEGER := 0;

Line 4923: okl_streams_pub.create_streams(

4919: END IF;
4920:
4921: l_stmv_rec.purpose_code := 'FLOW';
4922: -- Proceed with Creating the RENT Stream Header
4923: okl_streams_pub.create_streams(
4924: p_api_version => G_API_VERSION,
4925: p_init_msg_list => G_FALSE,
4926: x_return_status => lx_return_status,
4927: x_msg_count => x_msg_count,

Line 5029: okl_streams_pub.create_stream_elements(

5025: --print( l_prog_name, 'start date ' || l_selv_tbl(1).stream_element_date );
5026: -- Create the Stream Elements in the OKL_STRM_ELEMENTS table
5027: -- feels like the join between stream header and stream elements here is
5028: -- sel_id, we are populating it in the above for loop.
5029: okl_streams_pub.create_stream_elements(
5030: p_api_version => G_API_VERSION,
5031: p_init_msg_list => G_FALSE,
5032: x_return_status => lx_return_status,
5033: x_msg_count => x_msg_count,

Line 5068: okl_streams_pub.create_stream_elements(

5064: END IF;
5065: END LOOP;
5066: lx_selv_tbl.DELETE;
5067: -- Create/Update Stream Elements with the above modification.
5068: okl_streams_pub.create_stream_elements(
5069: p_api_version => G_API_VERSION,
5070: p_init_msg_list => G_FALSE,
5071: x_return_status => lx_return_status,
5072: x_msg_count => x_msg_count,

Line 5118: lx_return_status := Okl_Streams_Util.round_streams_amount(

5114: RAISE OKL_API.G_EXCEPTION_ERROR;
5115: END IF;
5116:
5117: l_pt_rec.purpose_code := 'PLOW';
5118: lx_return_status := Okl_Streams_Util.round_streams_amount(
5119: p_api_version => g_api_version,
5120: p_init_msg_list => p_init_msg_list,
5121: x_msg_count => x_msg_count,
5122: x_msg_data => x_msg_data,

Line 5135: okl_streams_pub.create_streams(

5131: END IF;
5132: l_pt_tbl.DELETE;
5133: l_pt_tbl := lx_selv_tbl;
5134: -- Create additional Pass Through Streams
5135: okl_streams_pub.create_streams(
5136: p_api_version => G_API_VERSION,
5137: p_init_msg_list => G_FALSE,
5138: x_return_status => lx_return_status,
5139: x_msg_count => x_msg_count,

Line 5329: l_selv_tbl okl_streams_pub.selv_tbl_type;

5325: l_interest_id NUMBER;
5326: l_prin_bal_id NUMBER;
5327: l_termination_id NUMBER;
5328:
5329: l_selv_tbl okl_streams_pub.selv_tbl_type;
5330: l_pt_tbl okl_streams_pub.selv_tbl_type;
5331: l_pt_pro_fee_tbl okl_streams_pub.selv_tbl_type;
5332: lx_selv_tbl okl_streams_pub.selv_tbl_type;
5333:

Line 5330: l_pt_tbl okl_streams_pub.selv_tbl_type;

5326: l_prin_bal_id NUMBER;
5327: l_termination_id NUMBER;
5328:
5329: l_selv_tbl okl_streams_pub.selv_tbl_type;
5330: l_pt_tbl okl_streams_pub.selv_tbl_type;
5331: l_pt_pro_fee_tbl okl_streams_pub.selv_tbl_type;
5332: lx_selv_tbl okl_streams_pub.selv_tbl_type;
5333:
5334: l_stmv_rec okl_streams_pub.stmv_rec_type;

Line 5331: l_pt_pro_fee_tbl okl_streams_pub.selv_tbl_type;

5327: l_termination_id NUMBER;
5328:
5329: l_selv_tbl okl_streams_pub.selv_tbl_type;
5330: l_pt_tbl okl_streams_pub.selv_tbl_type;
5331: l_pt_pro_fee_tbl okl_streams_pub.selv_tbl_type;
5332: lx_selv_tbl okl_streams_pub.selv_tbl_type;
5333:
5334: l_stmv_rec okl_streams_pub.stmv_rec_type;
5335: l_pt_rec okl_streams_pub.stmv_rec_type;

Line 5332: lx_selv_tbl okl_streams_pub.selv_tbl_type;

5328:
5329: l_selv_tbl okl_streams_pub.selv_tbl_type;
5330: l_pt_tbl okl_streams_pub.selv_tbl_type;
5331: l_pt_pro_fee_tbl okl_streams_pub.selv_tbl_type;
5332: lx_selv_tbl okl_streams_pub.selv_tbl_type;
5333:
5334: l_stmv_rec okl_streams_pub.stmv_rec_type;
5335: l_pt_rec okl_streams_pub.stmv_rec_type;
5336: l_pt_pro_fee_rec okl_streams_pub.stmv_rec_type;

Line 5334: l_stmv_rec okl_streams_pub.stmv_rec_type;

5330: l_pt_tbl okl_streams_pub.selv_tbl_type;
5331: l_pt_pro_fee_tbl okl_streams_pub.selv_tbl_type;
5332: lx_selv_tbl okl_streams_pub.selv_tbl_type;
5333:
5334: l_stmv_rec okl_streams_pub.stmv_rec_type;
5335: l_pt_rec okl_streams_pub.stmv_rec_type;
5336: l_pt_pro_fee_rec okl_streams_pub.stmv_rec_type;
5337: lx_stmv_rec okl_streams_pub.stmv_rec_type;
5338:

Line 5335: l_pt_rec okl_streams_pub.stmv_rec_type;

5331: l_pt_pro_fee_tbl okl_streams_pub.selv_tbl_type;
5332: lx_selv_tbl okl_streams_pub.selv_tbl_type;
5333:
5334: l_stmv_rec okl_streams_pub.stmv_rec_type;
5335: l_pt_rec okl_streams_pub.stmv_rec_type;
5336: l_pt_pro_fee_rec okl_streams_pub.stmv_rec_type;
5337: lx_stmv_rec okl_streams_pub.stmv_rec_type;
5338:
5339: -- Loan Amortization

Line 5336: l_pt_pro_fee_rec okl_streams_pub.stmv_rec_type;

5332: lx_selv_tbl okl_streams_pub.selv_tbl_type;
5333:
5334: l_stmv_rec okl_streams_pub.stmv_rec_type;
5335: l_pt_rec okl_streams_pub.stmv_rec_type;
5336: l_pt_pro_fee_rec okl_streams_pub.stmv_rec_type;
5337: lx_stmv_rec okl_streams_pub.stmv_rec_type;
5338:
5339: -- Loan Amortization
5340: l_principal_tbl okl_streams_pub.selv_tbl_type;

Line 5337: lx_stmv_rec okl_streams_pub.stmv_rec_type;

5333:
5334: l_stmv_rec okl_streams_pub.stmv_rec_type;
5335: l_pt_rec okl_streams_pub.stmv_rec_type;
5336: l_pt_pro_fee_rec okl_streams_pub.stmv_rec_type;
5337: lx_stmv_rec okl_streams_pub.stmv_rec_type;
5338:
5339: -- Loan Amortization
5340: l_principal_tbl okl_streams_pub.selv_tbl_type;
5341: l_interest_tbl okl_streams_pub.selv_tbl_type;

Line 5340: l_principal_tbl okl_streams_pub.selv_tbl_type;

5336: l_pt_pro_fee_rec okl_streams_pub.stmv_rec_type;
5337: lx_stmv_rec okl_streams_pub.stmv_rec_type;
5338:
5339: -- Loan Amortization
5340: l_principal_tbl okl_streams_pub.selv_tbl_type;
5341: l_interest_tbl okl_streams_pub.selv_tbl_type;
5342: l_prin_bal_tbl okl_streams_pub.selv_tbl_type;
5343: l_termination_tbl okl_streams_pub.selv_tbl_type;
5344: l_pre_tax_inc_tbl okl_streams_pub.selv_tbl_type;

Line 5341: l_interest_tbl okl_streams_pub.selv_tbl_type;

5337: lx_stmv_rec okl_streams_pub.stmv_rec_type;
5338:
5339: -- Loan Amortization
5340: l_principal_tbl okl_streams_pub.selv_tbl_type;
5341: l_interest_tbl okl_streams_pub.selv_tbl_type;
5342: l_prin_bal_tbl okl_streams_pub.selv_tbl_type;
5343: l_termination_tbl okl_streams_pub.selv_tbl_type;
5344: l_pre_tax_inc_tbl okl_streams_pub.selv_tbl_type;
5345:

Line 5342: l_prin_bal_tbl okl_streams_pub.selv_tbl_type;

5338:
5339: -- Loan Amortization
5340: l_principal_tbl okl_streams_pub.selv_tbl_type;
5341: l_interest_tbl okl_streams_pub.selv_tbl_type;
5342: l_prin_bal_tbl okl_streams_pub.selv_tbl_type;
5343: l_termination_tbl okl_streams_pub.selv_tbl_type;
5344: l_pre_tax_inc_tbl okl_streams_pub.selv_tbl_type;
5345:
5346: l_capital_cost NUMBER;

Line 5343: l_termination_tbl okl_streams_pub.selv_tbl_type;

5339: -- Loan Amortization
5340: l_principal_tbl okl_streams_pub.selv_tbl_type;
5341: l_interest_tbl okl_streams_pub.selv_tbl_type;
5342: l_prin_bal_tbl okl_streams_pub.selv_tbl_type;
5343: l_termination_tbl okl_streams_pub.selv_tbl_type;
5344: l_pre_tax_inc_tbl okl_streams_pub.selv_tbl_type;
5345:
5346: l_capital_cost NUMBER;
5347: l_interim_interest NUMBER;

Line 5344: l_pre_tax_inc_tbl okl_streams_pub.selv_tbl_type;

5340: l_principal_tbl okl_streams_pub.selv_tbl_type;
5341: l_interest_tbl okl_streams_pub.selv_tbl_type;
5342: l_prin_bal_tbl okl_streams_pub.selv_tbl_type;
5343: l_termination_tbl okl_streams_pub.selv_tbl_type;
5344: l_pre_tax_inc_tbl okl_streams_pub.selv_tbl_type;
5345:
5346: l_capital_cost NUMBER;
5347: l_interim_interest NUMBER;
5348: l_interim_days NUMBER;

Line 5364: l_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;

5360:
5361: l_passthrough_pro_fee_id NUMBER;
5362:
5363: -- Added by RGOOTY for perf.: Bug Number 4346646 Start
5364: l_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
5365: l_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
5366:
5367: lx_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
5368: lx_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;

Line 5365: l_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;

5361: l_passthrough_pro_fee_id NUMBER;
5362:
5363: -- Added by RGOOTY for perf.: Bug Number 4346646 Start
5364: l_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
5365: l_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
5366:
5367: lx_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
5368: lx_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
5369: -- Added by RGOOTY for perf.: End

Line 5367: lx_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;

5363: -- Added by RGOOTY for perf.: Bug Number 4346646 Start
5364: l_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
5365: l_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
5366:
5367: lx_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
5368: lx_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
5369: -- Added by RGOOTY for perf.: End
5370:
5371: cursor fee_strm_type_csr ( kleid NUMBER,

Line 5368: lx_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;

5364: l_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
5365: l_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
5366:
5367: lx_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
5368: lx_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
5369: -- Added by RGOOTY for perf.: End
5370:
5371: cursor fee_strm_type_csr ( kleid NUMBER,
5372: linestyle VARCHAR2 ) is

Line 5533: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(

5529: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
5530: RAISE OKL_API.G_EXCEPTION_ERROR;
5531: END IF;
5532:
5533: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(
5534: p_api_version => g_api_version,
5535: p_init_msg_list => p_init_msg_list,
5536: x_msg_count => x_msg_count,
5537: x_msg_data => x_msg_data,

Line 5557: OKL_STREAMS_UTIL.accumulate_strm_headers(

5553: l_selv_tbl.DELETE;
5554: l_selv_tbl := lx_selv_tbl;
5555:
5556: --Accumulate Stream Header
5557: OKL_STREAMS_UTIL.accumulate_strm_headers(
5558: p_stmv_rec => l_stmv_rec,
5559: x_full_stmv_tbl => l_stmv_tbl,
5560: x_return_status => lx_return_status );
5561: IF (lx_return_status = G_RET_STS_UNEXP_ERROR) THEN

Line 5568: OKL_STREAMS_UTIL.accumulate_strm_elements(

5564: RAISE OKL_API.G_EXCEPTION_ERROR;
5565: END IF;
5566:
5567: --Accumulate Stream Elements
5568: OKL_STREAMS_UTIL.accumulate_strm_elements(
5569: p_stm_index_no => l_stmv_tbl.LAST,
5570: p_selv_tbl => l_selv_tbl,
5571: x_full_selv_tbl => l_full_selv_tbl,
5572: x_return_status => lx_return_status );

Line 5579: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,

5575: ELSIF (lx_return_status = G_RET_STS_ERROR) THEN
5576: RAISE OKL_API.G_EXCEPTION_ERROR;
5577: END IF;
5578: /*
5579: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,
5580: p_init_msg_list => G_FALSE,
5581: x_return_status => lx_return_status,
5582: x_msg_count => x_msg_count,
5583: x_msg_data => x_msg_data,

Line 5646: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(

5642: RAISE OKL_API.G_EXCEPTION_ERROR;
5643: END IF;
5644:
5645:
5646: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(
5647: p_api_version => g_api_version,
5648: p_init_msg_list => p_init_msg_list,
5649: x_msg_count => x_msg_count,
5650: x_msg_data => x_msg_data,

Line 5669: OKL_STREAMS_UTIL.accumulate_strm_headers(

5665:
5666: l_pt_tbl.DELETE;
5667: l_pt_tbl := lx_selv_tbl;
5668: --Accumulate Stream Header: 4346646
5669: OKL_STREAMS_UTIL.accumulate_strm_headers(
5670: p_stmv_rec => l_pt_rec,
5671: x_full_stmv_tbl => l_stmv_tbl,
5672: x_return_status => lx_return_status );
5673: IF (lx_return_status = G_RET_STS_UNEXP_ERROR) THEN

Line 5680: OKL_STREAMS_UTIL.accumulate_strm_elements(

5676: RAISE OKL_API.G_EXCEPTION_ERROR;
5677: END IF;
5678:
5679: --Accumulate Stream Elements
5680: OKL_STREAMS_UTIL.accumulate_strm_elements(
5681: p_stm_index_no => l_stmv_tbl.LAST,
5682: p_selv_tbl => l_pt_tbl,
5683: x_full_selv_tbl => l_full_selv_tbl,
5684: x_return_status => lx_return_status );

Line 5691: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,

5687: ELSIF (lx_return_status = G_RET_STS_ERROR) THEN
5688: RAISE OKL_API.G_EXCEPTION_ERROR;
5689: END IF;
5690: /*
5691: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,
5692: p_init_msg_list => G_FALSE,
5693: x_return_status => lx_return_status,
5694: x_msg_count => x_msg_count,
5695: x_msg_data => x_msg_data,

Line 5765: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(

5761: RAISE OKL_API.G_EXCEPTION_ERROR;
5762: END IF;
5763:
5764:
5765: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(
5766: p_api_version => g_api_version,
5767: p_init_msg_list => p_init_msg_list,
5768: x_msg_count => x_msg_count,
5769: x_msg_data => x_msg_data,

Line 5788: OKL_STREAMS_UTIL.accumulate_strm_headers(

5784:
5785: l_pt_pro_fee_tbl.DELETE;
5786: l_pt_pro_fee_tbl := lx_selv_tbl;
5787:
5788: OKL_STREAMS_UTIL.accumulate_strm_headers(
5789: p_stmv_rec => l_pt_pro_fee_rec,
5790: x_full_stmv_tbl => l_stmv_tbl,
5791: x_return_status => lx_return_status );
5792:

Line 5800: OKL_STREAMS_UTIL.accumulate_strm_elements(

5796: RAISE OKL_API.G_EXCEPTION_ERROR;
5797: END IF;
5798:
5799: --Accumulate Stream Elements
5800: OKL_STREAMS_UTIL.accumulate_strm_elements(
5801: p_stm_index_no => l_stmv_tbl.LAST,
5802: p_selv_tbl => l_pt_pro_fee_tbl,
5803: x_full_selv_tbl => l_full_selv_tbl,
5804: x_return_status => lx_return_status );

Line 5838: Okl_Streams_Pub.create_streams_perf(

5834: x_payment_count := x_payment_count + 1;
5835: END IF;
5836: END LOOP;
5837: --Create all the accumulated Streams at one shot ..
5838: Okl_Streams_Pub.create_streams_perf(
5839: p_api_version,
5840: p_init_msg_list,
5841: lx_return_status,
5842: x_msg_count,

Line 5940: l_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;

5936: l_total_days NUMBER;
5937: l_daily_amt NUMBER;
5938: l_start_date DATE;
5939: l_month_end DATE;
5940: l_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
5941: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;
5942: l_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
5943: l_selv_tbl Okl_Streams_Pub.selv_tbl_type;
5944: lx_selv_tbl Okl_Streams_Pub.selv_tbl_type;

Line 5941: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;

5937: l_daily_amt NUMBER;
5938: l_start_date DATE;
5939: l_month_end DATE;
5940: l_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
5941: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;
5942: l_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
5943: l_selv_tbl Okl_Streams_Pub.selv_tbl_type;
5944: lx_selv_tbl Okl_Streams_Pub.selv_tbl_type;
5945: lx_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;

Line 5942: l_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;

5938: l_start_date DATE;
5939: l_month_end DATE;
5940: l_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
5941: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;
5942: l_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
5943: l_selv_tbl Okl_Streams_Pub.selv_tbl_type;
5944: lx_selv_tbl Okl_Streams_Pub.selv_tbl_type;
5945: lx_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
5946: lx_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;

Line 5943: l_selv_tbl Okl_Streams_Pub.selv_tbl_type;

5939: l_month_end DATE;
5940: l_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
5941: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;
5942: l_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
5943: l_selv_tbl Okl_Streams_Pub.selv_tbl_type;
5944: lx_selv_tbl Okl_Streams_Pub.selv_tbl_type;
5945: lx_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
5946: lx_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
5947: l_dep_sty_id NUMBER;

Line 5944: lx_selv_tbl Okl_Streams_Pub.selv_tbl_type;

5940: l_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
5941: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;
5942: l_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
5943: l_selv_tbl Okl_Streams_Pub.selv_tbl_type;
5944: lx_selv_tbl Okl_Streams_Pub.selv_tbl_type;
5945: lx_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
5946: lx_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
5947: l_dep_sty_id NUMBER;
5948: p_get_k_info_csr OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR%ROWTYPE;

Line 5945: lx_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;

5941: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;
5942: l_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
5943: l_selv_tbl Okl_Streams_Pub.selv_tbl_type;
5944: lx_selv_tbl Okl_Streams_Pub.selv_tbl_type;
5945: lx_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
5946: lx_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
5947: l_dep_sty_id NUMBER;
5948: p_get_k_info_csr OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR%ROWTYPE;
5949: l_mapped_sty_name VARCHAR2(150);

Line 5946: lx_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;

5942: l_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
5943: l_selv_tbl Okl_Streams_Pub.selv_tbl_type;
5944: lx_selv_tbl Okl_Streams_Pub.selv_tbl_type;
5945: lx_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
5946: lx_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
5947: l_dep_sty_id NUMBER;
5948: p_get_k_info_csr OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR%ROWTYPE;
5949: l_mapped_sty_name VARCHAR2(150);
5950: l_days NUMBER;

Line 6076: x_return_status := Okl_Streams_Util.round_streams_amount_esg(

6072: l_month_end := ADD_MONTHS(l_month_end, 1);
6073: END LOOP;
6074:
6075: IF (l_selv_tbl.COUNT > 0 ) THEN
6076: x_return_status := Okl_Streams_Util.round_streams_amount_esg(
6077: p_api_version => g_api_version,
6078: p_init_msg_list => p_init_msg_list,
6079: x_msg_count => x_msg_count,
6080: x_msg_data => x_msg_data,

Line 6112: OKL_STREAMS_UTIL.accumulate_strm_headers(

6108: RAISE OKL_API.G_EXCEPTION_ERROR;
6109: END IF;
6110:
6111: --Accumulate Stream Header
6112: OKL_STREAMS_UTIL.accumulate_strm_headers(
6113: p_stmv_rec => l_stmv_rec,
6114: x_full_stmv_tbl => l_stmv_tbl,
6115: x_return_status => x_return_status );
6116: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

Line 6123: OKL_STREAMS_UTIL.accumulate_strm_elements(

6119: RAISE OKL_API.G_EXCEPTION_ERROR;
6120: END IF;
6121:
6122: --Accumulate Stream Elements
6123: OKL_STREAMS_UTIL.accumulate_strm_elements(
6124: p_stm_index_no => l_stmv_tbl.LAST,
6125: p_selv_tbl => l_selv_tbl,
6126: x_full_selv_tbl => l_full_selv_tbl,
6127: x_return_status => x_return_status );

Line 6141: Okl_Streams_Pub.create_streams_perf(

6137: --Create all the accumulated Streams
6138: IF l_stmv_tbl.COUNT > 0 AND
6139: l_full_selv_tbl.COUNT > 0
6140: THEN
6141: Okl_Streams_Pub.create_streams_perf(
6142: p_api_version,
6143: p_init_msg_list,
6144: x_return_status,
6145: x_msg_count,

Line 6205: l_prev_stm_id OKL_STREAMS.ID%TYPE;

6201: -- Declare Variables
6202: l_api_name CONSTANT VARCHAR2(30) := 'COPY_ACCRUAL_STREAMS_ISG';
6203: l_strm_index NUMBER;
6204: l_sel_index NUMBER;
6205: l_prev_stm_id OKL_STREAMS.ID%TYPE;
6206: l_orig_chr_id OKC_K_HEADERS_B.ID%TYPE;
6207: l_new_stm_cle_id OKC_K_LINES_B.ID%TYPE;
6208:
6209: -- Declare records/table types

Line 6210: l_stmv_tbl okl_streams_pub.stmv_tbl_type;

6206: l_orig_chr_id OKC_K_HEADERS_B.ID%TYPE;
6207: l_new_stm_cle_id OKC_K_LINES_B.ID%TYPE;
6208:
6209: -- Declare records/table types
6210: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
6211: lx_stmv_tbl okl_streams_pub.stmv_tbl_type;
6212: l_selv_tbl okl_streams_pub.selv_tbl_type;
6213: lx_selv_tbl okl_streams_pub.selv_tbl_type;
6214:

Line 6211: lx_stmv_tbl okl_streams_pub.stmv_tbl_type;

6207: l_new_stm_cle_id OKC_K_LINES_B.ID%TYPE;
6208:
6209: -- Declare records/table types
6210: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
6211: lx_stmv_tbl okl_streams_pub.stmv_tbl_type;
6212: l_selv_tbl okl_streams_pub.selv_tbl_type;
6213: lx_selv_tbl okl_streams_pub.selv_tbl_type;
6214:
6215: -- Cursor to fetch the terminated lines

Line 6212: l_selv_tbl okl_streams_pub.selv_tbl_type;

6208:
6209: -- Declare records/table types
6210: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
6211: lx_stmv_tbl okl_streams_pub.stmv_tbl_type;
6212: l_selv_tbl okl_streams_pub.selv_tbl_type;
6213: lx_selv_tbl okl_streams_pub.selv_tbl_type;
6214:
6215: -- Cursor to fetch the terminated lines
6216: CURSOR l_get_curr_streams_lines(cp_chr_id IN NUMBER )

Line 6213: lx_selv_tbl okl_streams_pub.selv_tbl_type;

6209: -- Declare records/table types
6210: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
6211: lx_stmv_tbl okl_streams_pub.stmv_tbl_type;
6212: l_selv_tbl okl_streams_pub.selv_tbl_type;
6213: lx_selv_tbl okl_streams_pub.selv_tbl_type;
6214:
6215: -- Cursor to fetch the terminated lines
6216: CURSOR l_get_curr_streams_lines(cp_chr_id IN NUMBER )
6217: IS

Line 6259: FROM okl_streams stm

6255: , lse1.lty_code line_type
6256: , cle1.id kle_id
6257: , NULL fee_id
6258: , cle1.date_terminated date_terminated
6259: FROM okl_streams stm
6260: , okc_k_lines_b cle1
6261: , okc_line_styles_b lse1
6262: , okc_statuses_b sts1
6263: WHERE stm.khr_id = cp_chr_id

Line 6279: , cp_purpose_code okl_streams.purpose_code%TYPE) IS

6275: -- copied over during mass/online rebook. Streams will be regenerated by ISG
6276: CURSOR c_streams (cp_chr_id OKC_K_HEADERS_B.ID%TYPE
6277: , cp_cle_id OKC_K_LINES_B.ID%TYPE
6278: , cp_date_terminated DATE
6279: , cp_purpose_code okl_streams.purpose_code%TYPE) IS
6280: SELECT STM.ID STREAM_ID
6281: , STM.STY_ID
6282: , STM.SGN_CODE
6283: , STM.PURPOSE_CODE

Line 6292: FROM OKL_STREAMS STM

6288: , SEL.COMMENTS
6289: , SEL.ACCRUED_YN
6290: , STM.TRANSACTION_NUMBER
6291: , STY.STREAM_TYPE_PURPOSE
6292: FROM OKL_STREAMS STM
6293: , OKL_STRM_ELEMENTS SEL
6294: , OKL_STRM_TYPE_B STY
6295: WHERE SEL.STM_ID = STM.ID
6296: AND STM.KHR_ID = cp_chr_id

Line 6408: FROM okl_streams stm

6404: )
6405: IS
6406: SELECT stm.id stm_id
6407: ,stm.transaction_number transaction_number
6408: FROM okl_streams stm
6409: WHERE stm.khr_id = cp_chr_id
6410: AND stm.kle_id = cp_kle_id
6411: AND stm.sty_id = cp_sty_id
6412: AND stm.sgn_code = cp_sgn_code

Line 6782: -- Delete teh records from the OKL_STREAMS table now

6778: DELETE okl_strm_elements sel
6779: WHERE sel.stm_id = l_del_stm_id_tbl(i);
6780: print(l_prog_name, 'After calling Delete okl_strm_elements statement : ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS') );
6781:
6782: -- Delete teh records from the OKL_STREAMS table now
6783: print(l_prog_name, 'Before calling Delete okl_streams statement : ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS') );
6784: FORALL i IN l_del_stm_id_tbl.FIRST .. l_del_stm_id_tbl.LAST
6785: DELETE okl_streams stm
6786: WHERE stm.id = l_del_stm_id_tbl(i);

Line 6783: print(l_prog_name, 'Before calling Delete okl_streams statement : ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS') );

6779: WHERE sel.stm_id = l_del_stm_id_tbl(i);
6780: print(l_prog_name, 'After calling Delete okl_strm_elements statement : ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS') );
6781:
6782: -- Delete teh records from the OKL_STREAMS table now
6783: print(l_prog_name, 'Before calling Delete okl_streams statement : ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS') );
6784: FORALL i IN l_del_stm_id_tbl.FIRST .. l_del_stm_id_tbl.LAST
6785: DELETE okl_streams stm
6786: WHERE stm.id = l_del_stm_id_tbl(i);
6787: print(l_prog_name, 'After calling Delete okl_streams statement : ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS') );

Line 6785: DELETE okl_streams stm

6781:
6782: -- Delete teh records from the OKL_STREAMS table now
6783: print(l_prog_name, 'Before calling Delete okl_streams statement : ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS') );
6784: FORALL i IN l_del_stm_id_tbl.FIRST .. l_del_stm_id_tbl.LAST
6785: DELETE okl_streams stm
6786: WHERE stm.id = l_del_stm_id_tbl(i);
6787: print(l_prog_name, 'After calling Delete okl_streams statement : ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS') );
6788: END IF;
6789:

Line 6787: print(l_prog_name, 'After calling Delete okl_streams statement : ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS') );

6783: print(l_prog_name, 'Before calling Delete okl_streams statement : ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS') );
6784: FORALL i IN l_del_stm_id_tbl.FIRST .. l_del_stm_id_tbl.LAST
6785: DELETE okl_streams stm
6786: WHERE stm.id = l_del_stm_id_tbl(i);
6787: print(l_prog_name, 'After calling Delete okl_streams statement : ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS') );
6788: END IF;
6789:
6790: -- Finally at the very end of this API, create all the streams back in the DB using the Performant utiltiy API
6791: print(l_prog_name, 'Before calling APIs to insert the copied over streams. l_stmv_tbl.COUNT =' || l_stmv_tbl.COUNT );

Line 6795: print(l_prog_name, 'Before calling OKL_STREAMS_PUB.CREATE_STREAMS_PERF : ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS') );

6791: print(l_prog_name, 'Before calling APIs to insert the copied over streams. l_stmv_tbl.COUNT =' || l_stmv_tbl.COUNT );
6792: IF l_stmv_tbl.COUNT > 0
6793: THEN
6794: -- Call the API to bulk insert data into streams and stream elements
6795: print(l_prog_name, 'Before calling OKL_STREAMS_PUB.CREATE_STREAMS_PERF : ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS') );
6796: OKL_STREAMS_PUB.CREATE_STREAMS_PERF(p_api_version
6797: , p_init_msg_list
6798: , x_return_status
6799: , x_msg_count

Line 6796: OKL_STREAMS_PUB.CREATE_STREAMS_PERF(p_api_version

6792: IF l_stmv_tbl.COUNT > 0
6793: THEN
6794: -- Call the API to bulk insert data into streams and stream elements
6795: print(l_prog_name, 'Before calling OKL_STREAMS_PUB.CREATE_STREAMS_PERF : ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS') );
6796: OKL_STREAMS_PUB.CREATE_STREAMS_PERF(p_api_version
6797: , p_init_msg_list
6798: , x_return_status
6799: , x_msg_count
6800: , x_msg_data

Line 6805: print(l_prog_name, 'After calling OKL_STREAMS_PUB.CREATE_STREAMS_PERF : ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS') || 'x_return_status= ' || x_return_status);

6801: , l_stmv_tbl
6802: , l_selv_tbl
6803: , lx_stmv_tbl
6804: , lx_selv_tbl);
6805: print(l_prog_name, 'After calling OKL_STREAMS_PUB.CREATE_STREAMS_PERF : ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS') || 'x_return_status= ' || x_return_status);
6806: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
6807: RAISE OKL_API.G_EXCEPTION_ERROR;
6808: ELSIF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
6809: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 6896: FROM okl_streams stm,

6892: ,DECODE(
6893: sty.stream_type_purpose,
6894: 'RENT_ACCRUAL', 1,
6895: 99 ) sty_priority
6896: FROM okl_streams stm,
6897: okl_strm_type_b sty
6898: WHERE stm.khr_id = p_khr_id
6899: AND stm.say_code = p_say_code
6900: AND NVL(stm.purpose_code, '-99') = p_purpose

Line 6950: okl_streams stm

6946: stm.sty_id sty_id,
6947: stm.say_code say_code,
6948: stm.purpose_code purpose_code
6949: FROM okl_strm_elements sel,
6950: okl_streams stm
6951: WHERE stm.kle_id = p_kle_id
6952: AND stm.khr_id = p_khr_id
6953: AND stm.sty_id = p_sty_id
6954: AND DECODE(stm.purpose_code,

Line 7073: ,okl_streams stm

7069: IS
7070: SELECT TRUNC(sel.stream_element_date) income_date
7071: ,SUM(sel.amount) income_amount
7072: FROM okl_strm_elements sel
7073: ,okl_streams stm
7074: ,okl_strm_type_b sty
7075: ,okl_strm_type_tl styt
7076: WHERE stm.khr_id = p_khr_id
7077: AND stm.say_code = 'WORK'

Line 7172: l_selv_tbl okl_streams_pub.selv_tbl_type;

7168: l_sel_amt_tbl l_num_tbl_type;
7169: i NUMBER;
7170:
7171: --Bug# 12596925
7172: l_selv_tbl okl_streams_pub.selv_tbl_type;
7173: lx_selv_tbl okl_streams_pub.selv_tbl_type;
7174: j NUMBER;
7175:
7176: BEGIN

Line 7173: lx_selv_tbl okl_streams_pub.selv_tbl_type;

7169: i NUMBER;
7170:
7171: --Bug# 12596925
7172: l_selv_tbl okl_streams_pub.selv_tbl_type;
7173: lx_selv_tbl okl_streams_pub.selv_tbl_type;
7174: j NUMBER;
7175:
7176: BEGIN
7177: -- Added by RGOOTY: For Debugging purposes

Line 7898: x_return_status := Okl_Streams_Util.round_streams_amount(

7894: print(l_prog_name, l_selv_tbl(k).stream_element_date
7895: || '|' || l_selv_tbl(k).amount
7896: || '|' || l_selv_tbl(k).stm_id);
7897: end loop;
7898: x_return_status := Okl_Streams_Util.round_streams_amount(
7899: p_api_version => p_api_version,
7900: p_init_msg_list => OKL_API.G_FALSE,
7901: x_msg_count => x_msg_count,
7902: x_msg_data => x_msg_data,

Line 7907: print(l_prog_name, 'After calling Okl_Streams_Util.round_streams_amount' || x_return_status);

7903: p_chr_id => p_khr_id,
7904: p_selv_tbl => l_selv_tbl,
7905: x_selv_tbl => lx_selv_tbl);
7906:
7907: print(l_prog_name, 'After calling Okl_Streams_Util.round_streams_amount' || x_return_status);
7908:
7909: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
7910: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7911: ELSIF (x_return_status = G_RET_STS_ERROR) THEN

Line 8287: l_selv_tbl okl_streams_pub.selv_tbl_type;

8283: l_interest_id NUMBER;
8284: l_prin_bal_id NUMBER;
8285: l_termination_id NUMBER;
8286:
8287: l_selv_tbl okl_streams_pub.selv_tbl_type;
8288: l_pt_tbl okl_streams_pub.selv_tbl_type;
8289: lx_selv_tbl okl_streams_pub.selv_tbl_type;
8290:
8291: l_stmv_rec okl_streams_pub.stmv_rec_type;

Line 8288: l_pt_tbl okl_streams_pub.selv_tbl_type;

8284: l_prin_bal_id NUMBER;
8285: l_termination_id NUMBER;
8286:
8287: l_selv_tbl okl_streams_pub.selv_tbl_type;
8288: l_pt_tbl okl_streams_pub.selv_tbl_type;
8289: lx_selv_tbl okl_streams_pub.selv_tbl_type;
8290:
8291: l_stmv_rec okl_streams_pub.stmv_rec_type;
8292: l_pt_rec okl_streams_pub.stmv_rec_type;

Line 8289: lx_selv_tbl okl_streams_pub.selv_tbl_type;

8285: l_termination_id NUMBER;
8286:
8287: l_selv_tbl okl_streams_pub.selv_tbl_type;
8288: l_pt_tbl okl_streams_pub.selv_tbl_type;
8289: lx_selv_tbl okl_streams_pub.selv_tbl_type;
8290:
8291: l_stmv_rec okl_streams_pub.stmv_rec_type;
8292: l_pt_rec okl_streams_pub.stmv_rec_type;
8293: lx_stmv_rec okl_streams_pub.stmv_rec_type;

Line 8291: l_stmv_rec okl_streams_pub.stmv_rec_type;

8287: l_selv_tbl okl_streams_pub.selv_tbl_type;
8288: l_pt_tbl okl_streams_pub.selv_tbl_type;
8289: lx_selv_tbl okl_streams_pub.selv_tbl_type;
8290:
8291: l_stmv_rec okl_streams_pub.stmv_rec_type;
8292: l_pt_rec okl_streams_pub.stmv_rec_type;
8293: lx_stmv_rec okl_streams_pub.stmv_rec_type;
8294:
8295: -- Loan Amortization

Line 8292: l_pt_rec okl_streams_pub.stmv_rec_type;

8288: l_pt_tbl okl_streams_pub.selv_tbl_type;
8289: lx_selv_tbl okl_streams_pub.selv_tbl_type;
8290:
8291: l_stmv_rec okl_streams_pub.stmv_rec_type;
8292: l_pt_rec okl_streams_pub.stmv_rec_type;
8293: lx_stmv_rec okl_streams_pub.stmv_rec_type;
8294:
8295: -- Loan Amortization
8296: l_principal_tbl okl_streams_pub.selv_tbl_type;

Line 8293: lx_stmv_rec okl_streams_pub.stmv_rec_type;

8289: lx_selv_tbl okl_streams_pub.selv_tbl_type;
8290:
8291: l_stmv_rec okl_streams_pub.stmv_rec_type;
8292: l_pt_rec okl_streams_pub.stmv_rec_type;
8293: lx_stmv_rec okl_streams_pub.stmv_rec_type;
8294:
8295: -- Loan Amortization
8296: l_principal_tbl okl_streams_pub.selv_tbl_type;
8297: l_interest_tbl okl_streams_pub.selv_tbl_type;

Line 8296: l_principal_tbl okl_streams_pub.selv_tbl_type;

8292: l_pt_rec okl_streams_pub.stmv_rec_type;
8293: lx_stmv_rec okl_streams_pub.stmv_rec_type;
8294:
8295: -- Loan Amortization
8296: l_principal_tbl okl_streams_pub.selv_tbl_type;
8297: l_interest_tbl okl_streams_pub.selv_tbl_type;
8298: l_prin_bal_tbl okl_streams_pub.selv_tbl_type;
8299: l_termination_tbl okl_streams_pub.selv_tbl_type;
8300: l_pre_tax_inc_tbl okl_streams_pub.selv_tbl_type;

Line 8297: l_interest_tbl okl_streams_pub.selv_tbl_type;

8293: lx_stmv_rec okl_streams_pub.stmv_rec_type;
8294:
8295: -- Loan Amortization
8296: l_principal_tbl okl_streams_pub.selv_tbl_type;
8297: l_interest_tbl okl_streams_pub.selv_tbl_type;
8298: l_prin_bal_tbl okl_streams_pub.selv_tbl_type;
8299: l_termination_tbl okl_streams_pub.selv_tbl_type;
8300: l_pre_tax_inc_tbl okl_streams_pub.selv_tbl_type;
8301:

Line 8298: l_prin_bal_tbl okl_streams_pub.selv_tbl_type;

8294:
8295: -- Loan Amortization
8296: l_principal_tbl okl_streams_pub.selv_tbl_type;
8297: l_interest_tbl okl_streams_pub.selv_tbl_type;
8298: l_prin_bal_tbl okl_streams_pub.selv_tbl_type;
8299: l_termination_tbl okl_streams_pub.selv_tbl_type;
8300: l_pre_tax_inc_tbl okl_streams_pub.selv_tbl_type;
8301:
8302: l_capital_cost NUMBER;

Line 8299: l_termination_tbl okl_streams_pub.selv_tbl_type;

8295: -- Loan Amortization
8296: l_principal_tbl okl_streams_pub.selv_tbl_type;
8297: l_interest_tbl okl_streams_pub.selv_tbl_type;
8298: l_prin_bal_tbl okl_streams_pub.selv_tbl_type;
8299: l_termination_tbl okl_streams_pub.selv_tbl_type;
8300: l_pre_tax_inc_tbl okl_streams_pub.selv_tbl_type;
8301:
8302: l_capital_cost NUMBER;
8303: l_interim_interest NUMBER;

Line 8300: l_pre_tax_inc_tbl okl_streams_pub.selv_tbl_type;

8296: l_principal_tbl okl_streams_pub.selv_tbl_type;
8297: l_interest_tbl okl_streams_pub.selv_tbl_type;
8298: l_prin_bal_tbl okl_streams_pub.selv_tbl_type;
8299: l_termination_tbl okl_streams_pub.selv_tbl_type;
8300: l_pre_tax_inc_tbl okl_streams_pub.selv_tbl_type;
8301:
8302: l_capital_cost NUMBER;
8303: l_interim_interest NUMBER;
8304: l_interim_days NUMBER;

Line 8397: l_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;

8393: l_initial_irr NUMBER := 0;
8394: l_asset_count NUMBER := 0;
8395:
8396: -- Added by RGOOTY for perf.: Bug Number 4346646 Start
8397: l_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
8398: l_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
8399:
8400: lx_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
8401: lx_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;

Line 8398: l_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;

8394: l_asset_count NUMBER := 0;
8395:
8396: -- Added by RGOOTY for perf.: Bug Number 4346646 Start
8397: l_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
8398: l_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
8399:
8400: lx_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
8401: lx_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
8402: -- Added by RGOOTY for perf.: End

Line 8400: lx_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;

8396: -- Added by RGOOTY for perf.: Bug Number 4346646 Start
8397: l_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
8398: l_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
8399:
8400: lx_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
8401: lx_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
8402: -- Added by RGOOTY for perf.: End
8403:
8404: --Added by prasjain for bug 5474827

Line 8401: lx_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;

8397: l_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
8398: l_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
8399:
8400: lx_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
8401: lx_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
8402: -- Added by RGOOTY for perf.: End
8403:
8404: --Added by prasjain for bug 5474827
8405: l_se_id NUMBER;

Line 8484: OKL_STREAMS_UTIL.get_acc_options(

8480: -- Added by RGOOTY: For Debugging purposes
8481: L_DEBUG_ENABLED := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;
8482: -- print( l_prog_name, 'begin' );
8483: -- Added by RGOOTY: Start
8484: OKL_STREAMS_UTIL.get_acc_options(
8485: p_khr_id => p_khr_id,
8486: x_org_id => G_ORG_ID,
8487: x_precision => G_PRECISION,
8488: x_currency_code => G_CURRENCY_CODE,

Line 9022: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(

9018: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
9019: RAISE OKL_API.G_EXCEPTION_ERROR;
9020: END IF;
9021:
9022: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(
9023: p_api_version => g_api_version,
9024: p_init_msg_list => p_init_msg_list,
9025: x_msg_count => x_msg_count,
9026: x_msg_data => x_msg_data,

Line 9045: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,

9041:
9042: l_principal_tbl.DELETE;
9043: l_principal_tbl := lx_selv_tbl;
9044:
9045: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,
9046: p_init_msg_list => G_FALSE,
9047: x_return_status => lx_return_status,
9048: x_msg_count => x_msg_count,
9049: x_msg_data => x_msg_data,

Line 9083: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(

9079: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
9080: RAISE OKL_API.G_EXCEPTION_ERROR;
9081: END IF;
9082:
9083: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(
9084: p_api_version => g_api_version,
9085: p_init_msg_list => p_init_msg_list,
9086: x_msg_count => x_msg_count,
9087: x_msg_data => x_msg_data,

Line 9106: okl_streams_pub.create_streams(

9102:
9103: l_interest_tbl.DELETE;
9104: l_interest_tbl := lx_selv_tbl;
9105:
9106: okl_streams_pub.create_streams(
9107: p_api_version => G_API_VERSION,
9108: p_init_msg_list => G_FALSE,
9109: x_return_status => lx_return_status,
9110: x_msg_count => x_msg_count,

Line 9144: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(

9140: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
9141: RAISE OKL_API.G_EXCEPTION_ERROR;
9142: END IF;
9143:
9144: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(
9145: p_api_version => g_api_version,
9146: p_init_msg_list => p_init_msg_list,
9147: x_msg_count => x_msg_count,
9148: x_msg_data => x_msg_data,

Line 9167: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,

9163:
9164: l_prin_bal_tbl.DELETE;
9165: l_prin_bal_tbl := lx_selv_tbl;
9166:
9167: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,
9168: p_init_msg_list => G_FALSE,
9169: x_return_status => lx_return_status,
9170: x_msg_count => x_msg_count,
9171: x_msg_data => x_msg_data,

Line 9199: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(

9195: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
9196: RAISE OKL_API.G_EXCEPTION_ERROR;
9197: END IF;
9198:
9199: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(
9200: p_api_version => g_api_version,
9201: p_init_msg_list => p_init_msg_list,
9202: x_msg_count => x_msg_count,
9203: x_msg_data => x_msg_data,

Line 9222: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,

9218:
9219: l_termination_tbl.DELETE;
9220: l_termination_tbl := lx_selv_tbl;
9221:
9222: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,
9223: p_init_msg_list => G_FALSE,
9224: x_return_status => lx_return_status,
9225: x_msg_count => x_msg_count,
9226: x_msg_data => x_msg_data,

Line 9252: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(

9248: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
9249: RAISE OKL_API.G_EXCEPTION_ERROR;
9250: END IF;
9251:
9252: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(
9253: p_api_version => g_api_version,
9254: p_init_msg_list => p_init_msg_list,
9255: x_msg_count => x_msg_count,
9256: x_msg_data => x_msg_data,

Line 9275: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,

9271:
9272: l_pre_tax_inc_tbl.DELETE;
9273: l_pre_tax_inc_tbl := lx_selv_tbl;
9274:
9275: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,
9276: p_init_msg_list => G_FALSE,
9277: x_return_status => lx_return_status,
9278: x_msg_count => x_msg_count,
9279: x_msg_data => x_msg_data,

Line 9853: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(

9849: --
9850: -- call process API to create parent Stream Header and its child Stream Elements
9851: --
9852:
9853: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(
9854: p_api_version => g_api_version,
9855: p_init_msg_list => p_init_msg_list,
9856: x_msg_count => x_msg_count,
9857: x_msg_data => x_msg_data,

Line 9876: OKL_STREAMS_UTIL.accumulate_strm_headers(

9872:
9873: l_selv_tbl.DELETE;
9874: l_selv_tbl := lx_selv_tbl;
9875: --Accumulate Stream Header
9876: OKL_STREAMS_UTIL.accumulate_strm_headers(
9877: p_stmv_rec => l_stmv_rec,
9878: x_full_stmv_tbl => l_stmv_tbl,
9879: x_return_status => lx_return_status );
9880: IF (lx_return_status = G_RET_STS_UNEXP_ERROR) THEN

Line 9886: OKL_STREAMS_UTIL.accumulate_strm_elements(

9882: ELSIF (lx_return_status = G_RET_STS_ERROR) THEN
9883: RAISE OKL_API.G_EXCEPTION_ERROR;
9884: END IF;
9885: --Accumulate Stream Elements
9886: OKL_STREAMS_UTIL.accumulate_strm_elements(
9887: p_stm_index_no => l_stmv_tbl.LAST,
9888: p_selv_tbl => l_selv_tbl,
9889: x_full_selv_tbl => l_full_selv_tbl,
9890: x_return_status => lx_return_status );

Line 9922: Okl_Streams_Pub.create_streams_perf(

9918: --Create all the accumulated Streams at one shot ..
9919: IF l_stmv_tbl.COUNT > 0 AND
9920: l_full_selv_tbl.COUNT > 0
9921: THEN
9922: Okl_Streams_Pub.create_streams_perf(
9923: p_api_version,
9924: p_init_msg_list,
9925: lx_return_status,
9926: x_msg_count,

Line 10013: UPDATE okl_streams

10009: END IF;
10010:
10011: If ( l_sty_id IS NOT NULL ) Then
10012:
10013: UPDATE okl_streams
10014: SET sty_id = l_sty_id,
10015: last_updated_by = FND_GLOBAL.USER_ID, -- BUG:14749215 changes start here
10016: last_update_date = sysdate,
10017: last_update_login = FND_GLOBAL.LOGIN_ID -- BUG:14749215 changes end here

Line 10061: UPDATE okl_streams

10057: If ( l_sty_id IS NOT NULL ) Then
10058:
10059: -- print( l_prog_name, ' updating financed fees ' || to_char( r_financed_fees.id ));
10060:
10061: UPDATE okl_streams
10062: SET sty_id = l_sty_id,
10063: last_updated_by = FND_GLOBAL.USER_ID, -- BUG:14749215 changes start here
10064: last_update_date = sysdate,
10065: last_update_login = FND_GLOBAL.LOGIN_ID -- BUG:14749215 changes end here

Line 10088: (SELECT id from okl_streams WHERE khr_id = p_khr_id and say_code = 'WORK');

10084:
10085: UPDATE okl_strm_elements
10086: SET comments=NULL
10087: WHERE stm_id IN
10088: (SELECT id from okl_streams WHERE khr_id = p_khr_id and say_code = 'WORK');
10089: -- print( l_prog_name, ' done ' );
10090:
10091: /*
10092: * delete the duplicates from the okl_streams header table.

Line 10092: * delete the duplicates from the okl_streams header table.

10088: (SELECT id from okl_streams WHERE khr_id = p_khr_id and say_code = 'WORK');
10089: -- print( l_prog_name, ' done ' );
10090:
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

Line 10379: From okl_streams str

10375: l_advance_or_arrears VARCHAR2(10) := 'ARREARS';
10376:
10377: Cursor l_strms_csr ( chrId NUMBER, styId NUMBER ) IS
10378: Select str.id strm_id
10379: From okl_streams str
10380: Where str.sty_id = styId
10381: and str.khr_id = chrId
10382: and str.say_code = 'WORK';
10383:

Line 10406: l_selv_tbl okl_streams_pub.selv_tbl_type;

10402: l_sty_id NUMBER;
10403: l_sty_name VARCHAR2(150);
10404: l_mapped_sty_name VARCHAR2(150);
10405:
10406: l_selv_tbl okl_streams_pub.selv_tbl_type;
10407: l_pt_tbl okl_streams_pub.selv_tbl_type;
10408: lx_selv_tbl okl_streams_pub.selv_tbl_type;
10409:
10410: l_stmv_rec okl_streams_pub.stmv_rec_type;

Line 10407: l_pt_tbl okl_streams_pub.selv_tbl_type;

10403: l_sty_name VARCHAR2(150);
10404: l_mapped_sty_name VARCHAR2(150);
10405:
10406: l_selv_tbl okl_streams_pub.selv_tbl_type;
10407: l_pt_tbl okl_streams_pub.selv_tbl_type;
10408: lx_selv_tbl okl_streams_pub.selv_tbl_type;
10409:
10410: l_stmv_rec okl_streams_pub.stmv_rec_type;
10411: l_stmv_tbl okl_streams_pub.stmv_tbl_type;

Line 10408: lx_selv_tbl okl_streams_pub.selv_tbl_type;

10404: l_mapped_sty_name VARCHAR2(150);
10405:
10406: l_selv_tbl okl_streams_pub.selv_tbl_type;
10407: l_pt_tbl okl_streams_pub.selv_tbl_type;
10408: lx_selv_tbl okl_streams_pub.selv_tbl_type;
10409:
10410: l_stmv_rec okl_streams_pub.stmv_rec_type;
10411: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
10412: lx_stmv_tbl okl_streams_pub.stmv_tbl_type;

Line 10410: l_stmv_rec okl_streams_pub.stmv_rec_type;

10406: l_selv_tbl okl_streams_pub.selv_tbl_type;
10407: l_pt_tbl okl_streams_pub.selv_tbl_type;
10408: lx_selv_tbl okl_streams_pub.selv_tbl_type;
10409:
10410: l_stmv_rec okl_streams_pub.stmv_rec_type;
10411: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
10412: lx_stmv_tbl okl_streams_pub.stmv_tbl_type;
10413: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
10414: l_pt_rec okl_streams_pub.stmv_rec_type;

Line 10411: l_stmv_tbl okl_streams_pub.stmv_tbl_type;

10407: l_pt_tbl okl_streams_pub.selv_tbl_type;
10408: lx_selv_tbl okl_streams_pub.selv_tbl_type;
10409:
10410: l_stmv_rec okl_streams_pub.stmv_rec_type;
10411: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
10412: lx_stmv_tbl okl_streams_pub.stmv_tbl_type;
10413: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
10414: l_pt_rec okl_streams_pub.stmv_rec_type;
10415: lx_stmv_rec okl_streams_pub.stmv_rec_type;

Line 10412: lx_stmv_tbl okl_streams_pub.stmv_tbl_type;

10408: lx_selv_tbl okl_streams_pub.selv_tbl_type;
10409:
10410: l_stmv_rec okl_streams_pub.stmv_rec_type;
10411: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
10412: lx_stmv_tbl okl_streams_pub.stmv_tbl_type;
10413: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
10414: l_pt_rec okl_streams_pub.stmv_rec_type;
10415: lx_stmv_rec okl_streams_pub.stmv_rec_type;
10416:

Line 10413: x_stmv_tbl okl_streams_pub.stmv_tbl_type;

10409:
10410: l_stmv_rec okl_streams_pub.stmv_rec_type;
10411: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
10412: lx_stmv_tbl okl_streams_pub.stmv_tbl_type;
10413: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
10414: l_pt_rec okl_streams_pub.stmv_rec_type;
10415: lx_stmv_rec okl_streams_pub.stmv_rec_type;
10416:
10417: i BINARY_INTEGER := 0;

Line 10414: l_pt_rec okl_streams_pub.stmv_rec_type;

10410: l_stmv_rec okl_streams_pub.stmv_rec_type;
10411: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
10412: lx_stmv_tbl okl_streams_pub.stmv_tbl_type;
10413: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
10414: l_pt_rec okl_streams_pub.stmv_rec_type;
10415: lx_stmv_rec okl_streams_pub.stmv_rec_type;
10416:
10417: i BINARY_INTEGER := 0;
10418:

Line 10415: lx_stmv_rec okl_streams_pub.stmv_rec_type;

10411: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
10412: lx_stmv_tbl okl_streams_pub.stmv_tbl_type;
10413: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
10414: l_pt_rec okl_streams_pub.stmv_rec_type;
10415: lx_stmv_rec okl_streams_pub.stmv_rec_type;
10416:
10417: i BINARY_INTEGER := 0;
10418:
10419: l_api_name CONSTANT VARCHAR2(61) := 'GEN_VAR_INT_SCHEDULE';

Line 10475: Okl_Streams_pub.update_streams(

10471: END LOOP;
10472:
10473: If ( l_stmv_tbl.COUNT > 0 ) Then
10474:
10475: Okl_Streams_pub.update_streams(
10476: p_api_version => p_api_version,
10477: p_init_msg_list => p_init_msg_list,
10478: x_return_status => x_return_status,
10479: x_msg_count => x_msg_count,

Line 10550: x_return_status := Okl_Streams_Util.round_streams_amount(

10546: RAISE OKL_API.G_EXCEPTION_ERROR;
10547: END IF;
10548:
10549:
10550: x_return_status := Okl_Streams_Util.round_streams_amount(
10551: p_api_version => p_api_version,
10552: p_init_msg_list => p_init_msg_list,
10553: x_msg_count => x_msg_count,
10554: x_msg_data => x_msg_data,

Line 10568: okl_streams_pub.create_streams(p_api_version => p_api_version,

10564:
10565: l_selv_tbl.DELETE;
10566: l_selv_tbl := lx_selv_tbl;
10567:
10568: okl_streams_pub.create_streams(p_api_version => p_api_version,
10569: p_init_msg_list => p_init_msg_list,
10570: x_return_status => x_return_status,
10571: x_msg_count => x_msg_count,
10572: x_msg_data => x_msg_data,

Line 10626: x_stmv_rec OUT NOCOPY okl_streams_pub.stmv_rec_type,

10622: p_contract_id IN NUMBER,
10623: p_kle_id IN NUMBER,
10624: p_sty_id IN NUMBER,
10625: p_mode IN VARCHAR2,
10626: x_stmv_rec OUT NOCOPY okl_streams_pub.stmv_rec_type,
10627: x_selv_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
10628: x_return_status OUT NOCOPY VARCHAR2,
10629: x_msg_count OUT NOCOPY NUMBER,
10630: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 10627: x_selv_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,

10623: p_kle_id IN NUMBER,
10624: p_sty_id IN NUMBER,
10625: p_mode IN VARCHAR2,
10626: x_stmv_rec OUT NOCOPY okl_streams_pub.stmv_rec_type,
10627: x_selv_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
10628: x_return_status OUT NOCOPY VARCHAR2,
10629: x_msg_count OUT NOCOPY NUMBER,
10630: x_msg_data OUT NOCOPY VARCHAR2) IS
10631:

Line 10651: okl_streams stm,

10647: stm.id stm_id
10648: from okl_pools pol,
10649: okl_pool_contents pcn,
10650: okl_strm_type_v sty,
10651: okl_streams stm,
10652: okl_strm_elements ele
10653: where pcn.sty_id = sty.id
10654: and pcn.pol_id = pol.id
10655: and stm.kle_id = pcn.kle_id

Line 10710: okl_streams stm,

10706: stm.id stm_id
10707: from okl_pools pol,
10708: okl_pool_contents pcn,
10709: okl_strm_type_v sty,
10710: okl_streams stm,
10711: okl_strm_elements ele
10712: where pcn.sty_id = sty.id
10713: and pcn.pol_id = pol.id
10714: and stm.kle_id = pcn.kle_id

Line 10763: l_selv_tbl okl_streams_pub.selv_tbl_type;

10759: l_sty_id NUMBER;
10760: l_sty_name VARCHAR2(150);
10761: l_mapped_sty_name VARCHAR2(150);
10762:
10763: l_selv_tbl okl_streams_pub.selv_tbl_type;
10764: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
10765: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
10766: lx_selv_tbl okl_streams_pub.selv_tbl_type;
10767:

Line 10764: l_stmv_tbl okl_streams_pub.stmv_tbl_type;

10760: l_sty_name VARCHAR2(150);
10761: l_mapped_sty_name VARCHAR2(150);
10762:
10763: l_selv_tbl okl_streams_pub.selv_tbl_type;
10764: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
10765: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
10766: lx_selv_tbl okl_streams_pub.selv_tbl_type;
10767:
10768: l_stmv_rec okl_streams_pub.stmv_rec_type;

Line 10765: x_stmv_tbl okl_streams_pub.stmv_tbl_type;

10761: l_mapped_sty_name VARCHAR2(150);
10762:
10763: l_selv_tbl okl_streams_pub.selv_tbl_type;
10764: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
10765: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
10766: lx_selv_tbl okl_streams_pub.selv_tbl_type;
10767:
10768: l_stmv_rec okl_streams_pub.stmv_rec_type;
10769: lx_stmv_rec okl_streams_pub.stmv_rec_type;

Line 10766: lx_selv_tbl okl_streams_pub.selv_tbl_type;

10762:
10763: l_selv_tbl okl_streams_pub.selv_tbl_type;
10764: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
10765: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
10766: lx_selv_tbl okl_streams_pub.selv_tbl_type;
10767:
10768: l_stmv_rec okl_streams_pub.stmv_rec_type;
10769: lx_stmv_rec okl_streams_pub.stmv_rec_type;
10770:

Line 10768: l_stmv_rec okl_streams_pub.stmv_rec_type;

10764: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
10765: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
10766: lx_selv_tbl okl_streams_pub.selv_tbl_type;
10767:
10768: l_stmv_rec okl_streams_pub.stmv_rec_type;
10769: lx_stmv_rec okl_streams_pub.stmv_rec_type;
10770:
10771: cursor l_hdrrl_csr IS
10772: select crl.RULE_INFORMATION1 method

Line 10769: lx_stmv_rec okl_streams_pub.stmv_rec_type;

10765: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
10766: lx_selv_tbl okl_streams_pub.selv_tbl_type;
10767:
10768: l_stmv_rec okl_streams_pub.stmv_rec_type;
10769: lx_stmv_rec okl_streams_pub.stmv_rec_type;
10770:
10771: cursor l_hdrrl_csr IS
10772: select crl.RULE_INFORMATION1 method
10773: from OKC_RULE_GROUPS_B crg,

Line 11296: x_stmv_rec OUT NOCOPY okl_streams_pub.stmv_rec_type,

11292: p_kle_id IN NUMBER,
11293: p_sty_id IN NUMBER,
11294: --sosharma added, bug 6691554
11295: p_mode IN VARCHAR2,
11296: x_stmv_rec OUT NOCOPY okl_streams_pub.stmv_rec_type,
11297: x_selv_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
11298: x_return_status OUT NOCOPY VARCHAR2,
11299: x_msg_count OUT NOCOPY NUMBER,
11300: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 11297: x_selv_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,

11293: p_sty_id IN NUMBER,
11294: --sosharma added, bug 6691554
11295: p_mode IN VARCHAR2,
11296: x_stmv_rec OUT NOCOPY okl_streams_pub.stmv_rec_type,
11297: x_selv_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
11298: x_return_status OUT NOCOPY VARCHAR2,
11299: x_msg_count OUT NOCOPY NUMBER,
11300: x_msg_data OUT NOCOPY VARCHAR2) IS
11301:

Line 11321: okl_streams stm,

11317: stm.id stm_id
11318: from okl_pools pol,
11319: okl_pool_contents pcn,
11320: okl_strm_type_v sty,
11321: okl_streams stm,
11322: okl_strm_elements ele
11323: where pcn.sty_id = sty.id
11324: and pcn.pol_id = pol.id
11325: and stm.kle_id = pcn.kle_id

Line 11383: okl_streams stm,

11379: stm.id stm_id
11380: from okl_pools pol,
11381: okl_pool_contents pcn,
11382: okl_strm_type_v sty,
11383: okl_streams stm,
11384: okl_strm_elements ele
11385: where pcn.sty_id = sty.id
11386: and pcn.pol_id = pol.id
11387: and stm.kle_id = pcn.kle_id

Line 11430: l_selv_tbl okl_streams_pub.selv_tbl_type;

11426: l_sty_id NUMBER;
11427: l_sty_name VARCHAR2(150);
11428: l_mapped_sty_name VARCHAR2(150);
11429:
11430: l_selv_tbl okl_streams_pub.selv_tbl_type;
11431: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
11432: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
11433: lx_selv_tbl okl_streams_pub.selv_tbl_type;
11434:

Line 11431: l_stmv_tbl okl_streams_pub.stmv_tbl_type;

11427: l_sty_name VARCHAR2(150);
11428: l_mapped_sty_name VARCHAR2(150);
11429:
11430: l_selv_tbl okl_streams_pub.selv_tbl_type;
11431: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
11432: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
11433: lx_selv_tbl okl_streams_pub.selv_tbl_type;
11434:
11435: l_stmv_rec okl_streams_pub.stmv_rec_type;

Line 11432: x_stmv_tbl okl_streams_pub.stmv_tbl_type;

11428: l_mapped_sty_name VARCHAR2(150);
11429:
11430: l_selv_tbl okl_streams_pub.selv_tbl_type;
11431: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
11432: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
11433: lx_selv_tbl okl_streams_pub.selv_tbl_type;
11434:
11435: l_stmv_rec okl_streams_pub.stmv_rec_type;
11436: lx_stmv_rec okl_streams_pub.stmv_rec_type;

Line 11433: lx_selv_tbl okl_streams_pub.selv_tbl_type;

11429:
11430: l_selv_tbl okl_streams_pub.selv_tbl_type;
11431: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
11432: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
11433: lx_selv_tbl okl_streams_pub.selv_tbl_type;
11434:
11435: l_stmv_rec okl_streams_pub.stmv_rec_type;
11436: lx_stmv_rec okl_streams_pub.stmv_rec_type;
11437:

Line 11435: l_stmv_rec okl_streams_pub.stmv_rec_type;

11431: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
11432: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
11433: lx_selv_tbl okl_streams_pub.selv_tbl_type;
11434:
11435: l_stmv_rec okl_streams_pub.stmv_rec_type;
11436: lx_stmv_rec okl_streams_pub.stmv_rec_type;
11437:
11438: cursor l_hdrrl_csr IS
11439: select crl.RULE_INFORMATION1 method

Line 11436: lx_stmv_rec okl_streams_pub.stmv_rec_type;

11432: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
11433: lx_selv_tbl okl_streams_pub.selv_tbl_type;
11434:
11435: l_stmv_rec okl_streams_pub.stmv_rec_type;
11436: lx_stmv_rec okl_streams_pub.stmv_rec_type;
11437:
11438: cursor l_hdrrl_csr IS
11439: select crl.RULE_INFORMATION1 method
11440: from OKC_RULE_GROUPS_B crg,

Line 11896: okl_streams stm

11892: Cursor l_strms_csr ( khrId NUMBER, kleId NUMBER, strmname VARCHAR2) IS
11893: select stm.id strm_id
11894: from okl_strm_type_v sty,
11895: okl_strm_type_tl stl,
11896: okl_streams stm
11897: where stl.language = 'US'
11898: and stl.name = strmname
11899: and sty.id = stl.id
11900: and stm.sty_id = sty.id

Line 11917: okl_streams stm

11913: sty.stream_type_purpose stream_type_purpose
11914: from okl_pools pol,
11915: okl_pool_contents pcn,
11916: okl_strm_type_v sty,
11917: okl_streams stm
11918: where pcn.sty_id = sty.id
11919: and pcn.pol_id = pol.id
11920: and stm.kle_id = pcn.kle_id
11921: and stm.khr_id = pcn.khr_id

Line 11938: okl_streams stm

11934: sty.stream_type_purpose stream_type_purpose
11935: from okl_pools pol,
11936: okl_pool_contents pcn,
11937: okl_strm_type_v sty,
11938: okl_streams stm
11939: where pcn.sty_id = sty.id
11940: and pcn.pol_id = pol.id
11941: and stm.kle_id = pcn.kle_id
11942: and stm.khr_id = pcn.khr_id

Line 11965: okl_streams stm

11961: sty.stream_type_purpose stream_type_purpose
11962: from okl_pools pol,
11963: okl_pool_contents pcn,
11964: okl_strm_type_v sty,
11965: okl_streams stm
11966: where pcn.sty_id = sty.id
11967: and pcn.pol_id = pol.id
11968: and stm.kle_id = pcn.kle_id
11969: and stm.khr_id = pcn.khr_id

Line 11986: okl_streams stm

11982: sty.stream_type_purpose stream_type_purpose
11983: from okl_pools pol,
11984: okl_pool_contents pcn,
11985: okl_strm_type_v sty,
11986: okl_streams stm
11987: where pcn.sty_id = sty.id
11988: and pcn.pol_id = pol.id
11989: and stm.kle_id = pcn.kle_id
11990: and stm.khr_id = pcn.khr_id

Line 12004: l_selv_tbl okl_streams_pub.selv_tbl_type;

12000: sec_strms_rec sec_strms_csr%ROWTYPE;
12001:
12002: l_sty_id NUMBER;
12003:
12004: l_selv_tbl okl_streams_pub.selv_tbl_type;
12005: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
12006: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
12007: lx_selv_tbl okl_streams_pub.selv_tbl_type;
12008:

Line 12005: l_stmv_tbl okl_streams_pub.stmv_tbl_type;

12001:
12002: l_sty_id NUMBER;
12003:
12004: l_selv_tbl okl_streams_pub.selv_tbl_type;
12005: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
12006: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
12007: lx_selv_tbl okl_streams_pub.selv_tbl_type;
12008:
12009: l_stmv_rec okl_streams_pub.stmv_rec_type;

Line 12006: x_stmv_tbl okl_streams_pub.stmv_tbl_type;

12002: l_sty_id NUMBER;
12003:
12004: l_selv_tbl okl_streams_pub.selv_tbl_type;
12005: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
12006: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
12007: lx_selv_tbl okl_streams_pub.selv_tbl_type;
12008:
12009: l_stmv_rec okl_streams_pub.stmv_rec_type;
12010: lx_stmv_rec okl_streams_pub.stmv_rec_type;

Line 12007: lx_selv_tbl okl_streams_pub.selv_tbl_type;

12003:
12004: l_selv_tbl okl_streams_pub.selv_tbl_type;
12005: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
12006: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
12007: lx_selv_tbl okl_streams_pub.selv_tbl_type;
12008:
12009: l_stmv_rec okl_streams_pub.stmv_rec_type;
12010: lx_stmv_rec okl_streams_pub.stmv_rec_type;
12011:

Line 12009: l_stmv_rec okl_streams_pub.stmv_rec_type;

12005: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
12006: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
12007: lx_selv_tbl okl_streams_pub.selv_tbl_type;
12008:
12009: l_stmv_rec okl_streams_pub.stmv_rec_type;
12010: lx_stmv_rec okl_streams_pub.stmv_rec_type;
12011:
12012: i NUMBER;
12013: n NUMBER;

Line 12010: lx_stmv_rec okl_streams_pub.stmv_rec_type;

12006: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
12007: lx_selv_tbl okl_streams_pub.selv_tbl_type;
12008:
12009: l_stmv_rec okl_streams_pub.stmv_rec_type;
12010: lx_stmv_rec okl_streams_pub.stmv_rec_type;
12011:
12012: i NUMBER;
12013: n NUMBER;
12014:

Line 12093: Okl_Streams_pub.update_streams(

12089: END LOOP;
12090:
12091: If ( l_stmv_tbl.COUNT > 0 ) Then
12092:
12093: Okl_Streams_pub.update_streams(
12094: p_api_version => p_api_version,
12095: p_init_msg_list => p_init_msg_list,
12096: x_return_status => x_return_status,
12097: x_msg_count => x_msg_count,

Line 12147: Okl_Streams_pub.update_streams(

12143: END LOOP;
12144:
12145: If ( l_stmv_tbl.COUNT > 0 ) Then
12146:
12147: Okl_Streams_pub.update_streams(
12148: p_api_version => p_api_version,
12149: p_init_msg_list => p_init_msg_list,
12150: x_return_status => x_return_status,
12151: x_msg_count => x_msg_count,

Line 12205: x_return_status := Okl_Streams_Util.round_streams_amount(

12201: If( l_selv_tbl.COUNT > 0 AND (l_stmv_rec.sty_id IS NOT NULL) ) Then
12202:
12203: print( l_api_name, ' creating pv disb streams ' );
12204:
12205: x_return_status := Okl_Streams_Util.round_streams_amount(
12206: p_api_version => g_api_version,
12207: p_init_msg_list => p_init_msg_list,
12208: x_msg_count => x_msg_count,
12209: x_msg_data => x_msg_data,

Line 12223: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,

12219:
12220: l_selv_tbl.DELETE;
12221: l_selv_tbl := lx_selv_tbl;
12222:
12223: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,
12224: p_init_msg_list => G_FALSE,
12225: x_return_status => x_return_status,
12226: x_msg_count => x_msg_count,
12227: x_msg_data => x_msg_data,

Line 12283: Okl_Streams_pub.update_streams(

12279: END LOOP;
12280:
12281: If ( l_stmv_tbl.COUNT > 0 ) Then
12282:
12283: Okl_Streams_pub.update_streams(
12284: p_api_version => p_api_version,
12285: p_init_msg_list => p_init_msg_list,
12286: x_return_status => x_return_status,
12287: x_msg_count => x_msg_count,

Line 12336: Okl_Streams_pub.update_streams(

12332: END LOOP;
12333:
12334: If ( l_stmv_tbl.COUNT > 0 ) Then
12335:
12336: Okl_Streams_pub.update_streams(
12337: p_api_version => p_api_version,
12338: p_init_msg_list => p_init_msg_list,
12339: x_return_status => x_return_status,
12340: x_msg_count => x_msg_count,

Line 12394: x_return_status := Okl_Streams_Util.round_streams_amount(

12390: If( l_selv_tbl.COUNT > 0 AND (l_stmv_rec.sty_id IS NOT NULL) ) Then
12391:
12392: print( l_api_name, ' creating pv disb streams ' );
12393:
12394: x_return_status := Okl_Streams_Util.round_streams_amount(
12395: p_api_version => g_api_version,
12396: p_init_msg_list => p_init_msg_list,
12397: x_msg_count => x_msg_count,
12398: x_msg_data => x_msg_data,

Line 12412: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,

12408:
12409: l_selv_tbl.DELETE;
12410: l_selv_tbl := lx_selv_tbl;
12411:
12412: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,
12413: p_init_msg_list => G_FALSE,
12414: x_return_status => x_return_status,
12415: x_msg_count => x_msg_count,
12416: x_msg_data => x_msg_data,

Line 12490: okl_streams stm

12486: Cursor l_strms_csr ( khrId NUMBER, kleId NUMBER, strmname VARCHAR2) IS
12487: select stm.id strm_id
12488: from okl_strm_type_v sty,
12489: okl_strm_type_tl stl,
12490: okl_streams stm
12491: where stl.language = 'US'
12492: and stl.name = strmname
12493: and sty.id = stl.id
12494: and stm.sty_id = sty.id

Line 12511: okl_streams stm

12507: sty.stream_type_purpose stream_type_purpose
12508: from okl_pools pol,
12509: okl_pool_contents pcn,
12510: okl_strm_type_v sty,
12511: okl_streams stm
12512: where pcn.sty_id = sty.id
12513: and pcn.pol_id = pol.id
12514: and stm.kle_id = pcn.kle_id
12515: and stm.khr_id = pcn.khr_id

Line 12532: okl_streams stm

12528: sty.stream_type_purpose stream_type_purpose
12529: from okl_pools pol,
12530: okl_pool_contents pcn,
12531: okl_strm_type_v sty,
12532: okl_streams stm
12533: where pcn.sty_id = sty.id
12534: and pcn.pol_id = pol.id
12535: and stm.kle_id = pcn.kle_id
12536: and stm.khr_id = pcn.khr_id

Line 12560: okl_streams stm

12556: sty.stream_type_purpose stream_type_purpose
12557: from okl_pools pol,
12558: okl_pool_contents pcn,
12559: okl_strm_type_v sty,
12560: okl_streams stm
12561: where pcn.sty_id = sty.id
12562: and pcn.pol_id = pol.id
12563: and stm.kle_id = pcn.kle_id
12564: and stm.khr_id = pcn.khr_id

Line 12581: okl_streams stm

12577: sty.stream_type_purpose stream_type_purpose
12578: from okl_pools pol,
12579: okl_pool_contents pcn,
12580: okl_strm_type_v sty,
12581: okl_streams stm
12582: where pcn.sty_id = sty.id
12583: and pcn.pol_id = pol.id
12584: and stm.kle_id = pcn.kle_id
12585: and stm.khr_id = pcn.khr_id

Line 12601: l_selv_tbl okl_streams_pub.selv_tbl_type;

12597: sec_strms_rec sec_strms_csr%ROWTYPE;
12598:
12599: l_sty_id NUMBER;
12600:
12601: l_selv_tbl okl_streams_pub.selv_tbl_type;
12602: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
12603: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
12604: lx_selv_tbl okl_streams_pub.selv_tbl_type;
12605:

Line 12602: l_stmv_tbl okl_streams_pub.stmv_tbl_type;

12598:
12599: l_sty_id NUMBER;
12600:
12601: l_selv_tbl okl_streams_pub.selv_tbl_type;
12602: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
12603: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
12604: lx_selv_tbl okl_streams_pub.selv_tbl_type;
12605:
12606: l_stmv_rec okl_streams_pub.stmv_rec_type;

Line 12603: x_stmv_tbl okl_streams_pub.stmv_tbl_type;

12599: l_sty_id NUMBER;
12600:
12601: l_selv_tbl okl_streams_pub.selv_tbl_type;
12602: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
12603: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
12604: lx_selv_tbl okl_streams_pub.selv_tbl_type;
12605:
12606: l_stmv_rec okl_streams_pub.stmv_rec_type;
12607: lx_stmv_rec okl_streams_pub.stmv_rec_type;

Line 12604: lx_selv_tbl okl_streams_pub.selv_tbl_type;

12600:
12601: l_selv_tbl okl_streams_pub.selv_tbl_type;
12602: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
12603: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
12604: lx_selv_tbl okl_streams_pub.selv_tbl_type;
12605:
12606: l_stmv_rec okl_streams_pub.stmv_rec_type;
12607: lx_stmv_rec okl_streams_pub.stmv_rec_type;
12608:

Line 12606: l_stmv_rec okl_streams_pub.stmv_rec_type;

12602: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
12603: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
12604: lx_selv_tbl okl_streams_pub.selv_tbl_type;
12605:
12606: l_stmv_rec okl_streams_pub.stmv_rec_type;
12607: lx_stmv_rec okl_streams_pub.stmv_rec_type;
12608:
12609: i NUMBER;
12610: n NUMBER;

Line 12607: lx_stmv_rec okl_streams_pub.stmv_rec_type;

12603: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
12604: lx_selv_tbl okl_streams_pub.selv_tbl_type;
12605:
12606: l_stmv_rec okl_streams_pub.stmv_rec_type;
12607: lx_stmv_rec okl_streams_pub.stmv_rec_type;
12608:
12609: i NUMBER;
12610: n NUMBER;
12611:

Line 12695: Okl_Streams_pub.update_streams(

12691: END LOOP;
12692:
12693: If ( l_stmv_tbl.COUNT > 0 ) Then
12694:
12695: Okl_Streams_pub.update_streams(
12696: p_api_version => p_api_version,
12697: p_init_msg_list => p_init_msg_list,
12698: x_return_status => x_return_status,
12699: x_msg_count => x_msg_count,

Line 12749: Okl_Streams_pub.update_streams(

12745: END LOOP;
12746:
12747: If ( l_stmv_tbl.COUNT > 0 ) Then
12748:
12749: Okl_Streams_pub.update_streams(
12750: p_api_version => p_api_version,
12751: p_init_msg_list => p_init_msg_list,
12752: x_return_status => x_return_status,
12753: x_msg_count => x_msg_count,

Line 12808: x_return_status := Okl_Streams_Util.round_streams_amount(

12804: If( l_selv_tbl.COUNT > 0 AND l_stmv_rec.sty_id IS NOT NULL) Then
12805:
12806: print( l_api_name, ' creating disb streams ' );
12807:
12808: x_return_status := Okl_Streams_Util.round_streams_amount(
12809: p_api_version => g_api_version,
12810: p_init_msg_list => p_init_msg_list,
12811: x_msg_count => x_msg_count,
12812: x_msg_data => x_msg_data,

Line 12826: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,

12822:
12823: l_selv_tbl.DELETE;
12824: l_selv_tbl := lx_selv_tbl;
12825:
12826: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,
12827: p_init_msg_list => G_FALSE,
12828: x_return_status => x_return_status,
12829: x_msg_count => x_msg_count,
12830: x_msg_data => x_msg_data,

Line 12886: Okl_Streams_pub.update_streams(

12882: END LOOP;
12883:
12884: If ( l_stmv_tbl.COUNT > 0 ) Then
12885:
12886: Okl_Streams_pub.update_streams(
12887: p_api_version => p_api_version,
12888: p_init_msg_list => p_init_msg_list,
12889: x_return_status => x_return_status,
12890: x_msg_count => x_msg_count,

Line 12940: Okl_Streams_pub.update_streams(

12936: END LOOP;
12937:
12938: If ( l_stmv_tbl.COUNT > 0 ) Then
12939:
12940: Okl_Streams_pub.update_streams(
12941: p_api_version => p_api_version,
12942: p_init_msg_list => p_init_msg_list,
12943: x_return_status => x_return_status,
12944: x_msg_count => x_msg_count,

Line 13001: x_return_status := Okl_Streams_Util.round_streams_amount(

12997: If( l_selv_tbl.COUNT > 0 AND l_stmv_rec.sty_id IS NOT NULL) Then
12998:
12999: print( l_api_name, ' creating disb streams ' );
13000:
13001: x_return_status := Okl_Streams_Util.round_streams_amount(
13002: p_api_version => g_api_version,
13003: p_init_msg_list => p_init_msg_list,
13004: x_msg_count => x_msg_count,
13005: x_msg_data => x_msg_data,

Line 13019: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,

13015:
13016: l_selv_tbl.DELETE;
13017: l_selv_tbl := lx_selv_tbl;
13018:
13019: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,
13020: p_init_msg_list => G_FALSE,
13021: x_return_status => x_return_status,
13022: x_msg_count => x_msg_count,
13023: x_msg_data => x_msg_data,

Line 13436: FROM okl_streams stm,

13432:
13433: CURSOR c_pbal IS
13434: SELECT ele.amount,
13435: ele.stream_element_date
13436: FROM okl_streams stm,
13437: okl_strm_elements ele,
13438: okl_strm_type_b sty
13439: WHERE sty.stream_type_purpose = 'PRINCIPAL_BALANCE'
13440: AND stm.sty_id = sty.id

Line 13448: FROM okl_streams stm,

13444: AND stm.active_yn = 'Y'
13445: AND ele.stm_id = stm.id
13446: AND ele.stream_element_date =
13447: ( SELECT max( ele.stream_element_date)
13448: FROM okl_streams stm,
13449: okl_strm_elements ele,
13450: okl_strm_type_b sty
13451: WHERE sty.stream_type_purpose = 'PRINCIPAL_BALANCE'
13452: AND stm.sty_id = sty.id

Line 13809: From okl_streams str

13805: l_advance_or_arrears VARCHAR2(10) := 'ARREARS';
13806:
13807: Cursor l_strms_csr ( chrId NUMBER, styId NUMBER ) IS
13808: Select str.id strm_id
13809: From okl_streams str
13810: Where str.sty_id = styId
13811: and str.khr_id = chrId
13812: and str.say_code = 'WORK';
13813:

Line 13837: l_selv_tbl okl_streams_pub.selv_tbl_type;

13833: l_sty_id NUMBER;
13834: l_sty_name VARCHAR2(150);
13835: l_mapped_sty_name VARCHAR2(150);
13836:
13837: l_selv_tbl okl_streams_pub.selv_tbl_type;
13838: l_pt_tbl okl_streams_pub.selv_tbl_type;
13839: lx_selv_tbl okl_streams_pub.selv_tbl_type;
13840:
13841: l_stmv_rec okl_streams_pub.stmv_rec_type;

Line 13838: l_pt_tbl okl_streams_pub.selv_tbl_type;

13834: l_sty_name VARCHAR2(150);
13835: l_mapped_sty_name VARCHAR2(150);
13836:
13837: l_selv_tbl okl_streams_pub.selv_tbl_type;
13838: l_pt_tbl okl_streams_pub.selv_tbl_type;
13839: lx_selv_tbl okl_streams_pub.selv_tbl_type;
13840:
13841: l_stmv_rec okl_streams_pub.stmv_rec_type;
13842: l_stmv_tbl okl_streams_pub.stmv_tbl_type;

Line 13839: lx_selv_tbl okl_streams_pub.selv_tbl_type;

13835: l_mapped_sty_name VARCHAR2(150);
13836:
13837: l_selv_tbl okl_streams_pub.selv_tbl_type;
13838: l_pt_tbl okl_streams_pub.selv_tbl_type;
13839: lx_selv_tbl okl_streams_pub.selv_tbl_type;
13840:
13841: l_stmv_rec okl_streams_pub.stmv_rec_type;
13842: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
13843: lx_stmv_tbl okl_streams_pub.stmv_tbl_type;

Line 13841: l_stmv_rec okl_streams_pub.stmv_rec_type;

13837: l_selv_tbl okl_streams_pub.selv_tbl_type;
13838: l_pt_tbl okl_streams_pub.selv_tbl_type;
13839: lx_selv_tbl okl_streams_pub.selv_tbl_type;
13840:
13841: l_stmv_rec okl_streams_pub.stmv_rec_type;
13842: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
13843: lx_stmv_tbl okl_streams_pub.stmv_tbl_type;
13844: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
13845: l_pt_rec okl_streams_pub.stmv_rec_type;

Line 13842: l_stmv_tbl okl_streams_pub.stmv_tbl_type;

13838: l_pt_tbl okl_streams_pub.selv_tbl_type;
13839: lx_selv_tbl okl_streams_pub.selv_tbl_type;
13840:
13841: l_stmv_rec okl_streams_pub.stmv_rec_type;
13842: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
13843: lx_stmv_tbl okl_streams_pub.stmv_tbl_type;
13844: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
13845: l_pt_rec okl_streams_pub.stmv_rec_type;
13846: lx_stmv_rec okl_streams_pub.stmv_rec_type;

Line 13843: lx_stmv_tbl okl_streams_pub.stmv_tbl_type;

13839: lx_selv_tbl okl_streams_pub.selv_tbl_type;
13840:
13841: l_stmv_rec okl_streams_pub.stmv_rec_type;
13842: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
13843: lx_stmv_tbl okl_streams_pub.stmv_tbl_type;
13844: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
13845: l_pt_rec okl_streams_pub.stmv_rec_type;
13846: lx_stmv_rec okl_streams_pub.stmv_rec_type;
13847:

Line 13844: x_stmv_tbl okl_streams_pub.stmv_tbl_type;

13840:
13841: l_stmv_rec okl_streams_pub.stmv_rec_type;
13842: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
13843: lx_stmv_tbl okl_streams_pub.stmv_tbl_type;
13844: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
13845: l_pt_rec okl_streams_pub.stmv_rec_type;
13846: lx_stmv_rec okl_streams_pub.stmv_rec_type;
13847:
13848: i BINARY_INTEGER := 0;

Line 13845: l_pt_rec okl_streams_pub.stmv_rec_type;

13841: l_stmv_rec okl_streams_pub.stmv_rec_type;
13842: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
13843: lx_stmv_tbl okl_streams_pub.stmv_tbl_type;
13844: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
13845: l_pt_rec okl_streams_pub.stmv_rec_type;
13846: lx_stmv_rec okl_streams_pub.stmv_rec_type;
13847:
13848: i BINARY_INTEGER := 0;
13849:

Line 13846: lx_stmv_rec okl_streams_pub.stmv_rec_type;

13842: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
13843: lx_stmv_tbl okl_streams_pub.stmv_tbl_type;
13844: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
13845: l_pt_rec okl_streams_pub.stmv_rec_type;
13846: lx_stmv_rec okl_streams_pub.stmv_rec_type;
13847:
13848: i BINARY_INTEGER := 0;
13849:
13850: l_api_name CONSTANT VARCHAR2(61) := 'GET_NEXT_BILL_DATE';

Line 14108: l_pt_tbl okl_streams_pub.selv_tbl_type;

14104: l_old_cle_id NUMBER;
14105: l_old_sty_id NUMBER;
14106: l_purpose_code VARCHAR2(30);
14107:
14108: l_pt_tbl okl_streams_pub.selv_tbl_type;
14109: l_pt_pro_fee_tbl okl_streams_pub.selv_tbl_type;
14110:
14111: l_selv_tbl okl_streams_pub.selv_tbl_type;
14112: lx_selv_tbl okl_streams_pub.selv_tbl_type;

Line 14109: l_pt_pro_fee_tbl okl_streams_pub.selv_tbl_type;

14105: l_old_sty_id NUMBER;
14106: l_purpose_code VARCHAR2(30);
14107:
14108: l_pt_tbl okl_streams_pub.selv_tbl_type;
14109: l_pt_pro_fee_tbl okl_streams_pub.selv_tbl_type;
14110:
14111: l_selv_tbl okl_streams_pub.selv_tbl_type;
14112: lx_selv_tbl okl_streams_pub.selv_tbl_type;
14113:

Line 14111: l_selv_tbl okl_streams_pub.selv_tbl_type;

14107:
14108: l_pt_tbl okl_streams_pub.selv_tbl_type;
14109: l_pt_pro_fee_tbl okl_streams_pub.selv_tbl_type;
14110:
14111: l_selv_tbl okl_streams_pub.selv_tbl_type;
14112: lx_selv_tbl okl_streams_pub.selv_tbl_type;
14113:
14114: l_stmv_rec okl_streams_pub.stmv_rec_type;
14115: l_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;

Line 14112: lx_selv_tbl okl_streams_pub.selv_tbl_type;

14108: l_pt_tbl okl_streams_pub.selv_tbl_type;
14109: l_pt_pro_fee_tbl okl_streams_pub.selv_tbl_type;
14110:
14111: l_selv_tbl okl_streams_pub.selv_tbl_type;
14112: lx_selv_tbl okl_streams_pub.selv_tbl_type;
14113:
14114: l_stmv_rec okl_streams_pub.stmv_rec_type;
14115: l_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
14116: lx_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;

Line 14114: l_stmv_rec okl_streams_pub.stmv_rec_type;

14110:
14111: l_selv_tbl okl_streams_pub.selv_tbl_type;
14112: lx_selv_tbl okl_streams_pub.selv_tbl_type;
14113:
14114: l_stmv_rec okl_streams_pub.stmv_rec_type;
14115: l_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
14116: lx_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
14117:
14118: l_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;

Line 14115: l_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;

14111: l_selv_tbl okl_streams_pub.selv_tbl_type;
14112: lx_selv_tbl okl_streams_pub.selv_tbl_type;
14113:
14114: l_stmv_rec okl_streams_pub.stmv_rec_type;
14115: l_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
14116: lx_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
14117:
14118: l_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
14119: lx_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;

Line 14116: lx_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;

14112: lx_selv_tbl okl_streams_pub.selv_tbl_type;
14113:
14114: l_stmv_rec okl_streams_pub.stmv_rec_type;
14115: l_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
14116: lx_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
14117:
14118: l_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
14119: lx_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
14120:

Line 14118: l_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;

14114: l_stmv_rec okl_streams_pub.stmv_rec_type;
14115: l_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
14116: lx_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
14117:
14118: l_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
14119: lx_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
14120:
14121: l_prog_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'gen_cash_flows_for_IA';
14122:

Line 14119: lx_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;

14115: l_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
14116: lx_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
14117:
14118: l_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
14119: lx_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
14120:
14121: l_prog_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'gen_cash_flows_for_IA';
14122:
14123: BEGIN

Line 14188: x_return_status := Okl_Streams_Util.round_streams_amount_esg(

14184: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
14185: RAISE OKL_API.G_EXCEPTION_ERROR;
14186: END IF;
14187:
14188: x_return_status := Okl_Streams_Util.round_streams_amount_esg(
14189: p_api_version => g_api_version,
14190: p_init_msg_list => p_init_msg_list,
14191: x_msg_count => x_msg_count,
14192: x_msg_data => x_msg_data,

Line 14212: OKL_STREAMS_UTIL.accumulate_strm_headers( p_stmv_rec => l_stmv_rec,

14208: l_selv_tbl.DELETE;
14209: l_selv_tbl := lx_selv_tbl;
14210:
14211: --Accumulate Stream Header
14212: OKL_STREAMS_UTIL.accumulate_strm_headers( p_stmv_rec => l_stmv_rec,
14213: x_full_stmv_tbl => l_stmv_tbl,
14214: x_return_status => x_return_status );
14215: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
14216: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 14222: OKL_STREAMS_UTIL.accumulate_strm_elements( p_stm_index_no => l_stmv_tbl.LAST,

14218: RAISE OKL_API.G_EXCEPTION_ERROR;
14219: END IF;
14220:
14221: --Accumulate Stream Elements
14222: OKL_STREAMS_UTIL.accumulate_strm_elements( p_stm_index_no => l_stmv_tbl.LAST,
14223: p_selv_tbl => l_selv_tbl,
14224: x_full_selv_tbl => l_full_selv_tbl,
14225: x_return_status => x_return_status );
14226: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

Line 14239: Okl_Streams_Pub.create_streams_perf( p_api_version,

14235:
14236: END LOOP;
14237:
14238: --Create all the accumulated Streams at one shot ..
14239: Okl_Streams_Pub.create_streams_perf( p_api_version,
14240: p_init_msg_list,
14241: x_return_status,
14242: x_msg_count,
14243: x_msg_data,

Line 14358: l_selv_tbl okl_streams_pub.selv_tbl_type;

14354: l_pdt_id okl_products.id%type;
14355: l_currency_code okc_k_headers_all_b.currency_code%type;
14356: l_purpose_code VARCHAR2(30) := '-99';
14357:
14358: l_selv_tbl okl_streams_pub.selv_tbl_type;
14359: lx_selv_tbl okl_streams_pub.selv_tbl_type;
14360: l_full_selv_tbl okl_streams_pub.selv_tbl_type;
14361: lx_full_selv_tbl okl_streams_pub.selv_tbl_type;
14362:

Line 14359: lx_selv_tbl okl_streams_pub.selv_tbl_type;

14355: l_currency_code okc_k_headers_all_b.currency_code%type;
14356: l_purpose_code VARCHAR2(30) := '-99';
14357:
14358: l_selv_tbl okl_streams_pub.selv_tbl_type;
14359: lx_selv_tbl okl_streams_pub.selv_tbl_type;
14360: l_full_selv_tbl okl_streams_pub.selv_tbl_type;
14361: lx_full_selv_tbl okl_streams_pub.selv_tbl_type;
14362:
14363: l_stmv_rec okl_streams_pub.stmv_rec_type;

Line 14360: l_full_selv_tbl okl_streams_pub.selv_tbl_type;

14356: l_purpose_code VARCHAR2(30) := '-99';
14357:
14358: l_selv_tbl okl_streams_pub.selv_tbl_type;
14359: lx_selv_tbl okl_streams_pub.selv_tbl_type;
14360: l_full_selv_tbl okl_streams_pub.selv_tbl_type;
14361: lx_full_selv_tbl okl_streams_pub.selv_tbl_type;
14362:
14363: l_stmv_rec okl_streams_pub.stmv_rec_type;
14364: l_stmv_tbl okl_Streams_Pub.stmv_tbl_type;

Line 14361: lx_full_selv_tbl okl_streams_pub.selv_tbl_type;

14357:
14358: l_selv_tbl okl_streams_pub.selv_tbl_type;
14359: lx_selv_tbl okl_streams_pub.selv_tbl_type;
14360: l_full_selv_tbl okl_streams_pub.selv_tbl_type;
14361: lx_full_selv_tbl okl_streams_pub.selv_tbl_type;
14362:
14363: l_stmv_rec okl_streams_pub.stmv_rec_type;
14364: l_stmv_tbl okl_Streams_Pub.stmv_tbl_type;
14365: lx_stmv_tbl okl_Streams_Pub.stmv_tbl_type;

Line 14363: l_stmv_rec okl_streams_pub.stmv_rec_type;

14359: lx_selv_tbl okl_streams_pub.selv_tbl_type;
14360: l_full_selv_tbl okl_streams_pub.selv_tbl_type;
14361: lx_full_selv_tbl okl_streams_pub.selv_tbl_type;
14362:
14363: l_stmv_rec okl_streams_pub.stmv_rec_type;
14364: l_stmv_tbl okl_Streams_Pub.stmv_tbl_type;
14365: lx_stmv_tbl okl_Streams_Pub.stmv_tbl_type;
14366:
14367: l_prog_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'gen_income_accruals_for_IA';

Line 14364: l_stmv_tbl okl_Streams_Pub.stmv_tbl_type;

14360: l_full_selv_tbl okl_streams_pub.selv_tbl_type;
14361: lx_full_selv_tbl okl_streams_pub.selv_tbl_type;
14362:
14363: l_stmv_rec okl_streams_pub.stmv_rec_type;
14364: l_stmv_tbl okl_Streams_Pub.stmv_tbl_type;
14365: lx_stmv_tbl okl_Streams_Pub.stmv_tbl_type;
14366:
14367: l_prog_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'gen_income_accruals_for_IA';
14368:

Line 14365: lx_stmv_tbl okl_Streams_Pub.stmv_tbl_type;

14361: lx_full_selv_tbl okl_streams_pub.selv_tbl_type;
14362:
14363: l_stmv_rec okl_streams_pub.stmv_rec_type;
14364: l_stmv_tbl okl_Streams_Pub.stmv_tbl_type;
14365: lx_stmv_tbl okl_Streams_Pub.stmv_tbl_type;
14366:
14367: l_prog_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'gen_income_accruals_for_IA';
14368:
14369: BEGIN

Line 14479: x_return_status := Okl_Streams_Util.round_streams_amount_esg(

14475: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
14476: RAISE OKL_API.G_EXCEPTION_ERROR;
14477: END IF;
14478:
14479: x_return_status := Okl_Streams_Util.round_streams_amount_esg(
14480: p_api_version => g_api_version,
14481: p_init_msg_list => p_init_msg_list,
14482: x_msg_count => x_msg_count,
14483: x_msg_data => x_msg_data,

Line 14503: OKL_STREAMS_UTIL.accumulate_strm_headers(

14499: l_selv_tbl.DELETE;
14500: l_selv_tbl := lx_selv_tbl;
14501:
14502: --Accumulate Stream Header
14503: OKL_STREAMS_UTIL.accumulate_strm_headers(
14504: p_stmv_rec => l_stmv_rec,
14505: x_full_stmv_tbl => l_stmv_tbl,
14506: x_return_status => x_return_status );
14507: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

Line 14514: OKL_STREAMS_UTIL.accumulate_strm_elements(

14510: RAISE OKL_API.G_EXCEPTION_ERROR;
14511: END IF;
14512:
14513: --Accumulate Stream Elements
14514: OKL_STREAMS_UTIL.accumulate_strm_elements(
14515: p_stm_index_no => l_stmv_tbl.LAST,
14516: p_selv_tbl => l_selv_tbl,
14517: x_full_selv_tbl => l_full_selv_tbl,
14518: x_return_status => x_return_status );

Line 14542: Okl_Streams_Pub.create_streams_perf(

14538: --Create all the accumulated Streams at one shot ..
14539: IF l_stmv_tbl.COUNT > 0 AND
14540: l_full_selv_tbl.COUNT > 0
14541: THEN
14542: Okl_Streams_Pub.create_streams_perf(
14543: p_api_version,
14544: p_init_msg_list,
14545: x_return_status,
14546: x_msg_count,

Line 14601: l_strm_id_tbl okl_streams_util.NumberTabTyp;

14597: , x_msg_data OUT NOCOPY VARCHAR2
14598: )
14599: IS
14600:
14601: l_strm_id_tbl okl_streams_util.NumberTabTyp;
14602: l_say_code_tbl okl_streams_util.Var10TabTyp;
14603: l_active_yn_tbl okl_streams_util.Var10TabTyp;
14604: l_date_history_tbl okl_streams_util.DateTabTyp;
14605: l_date_curr_tbl okl_streams_util.DateTabTyp;

Line 14602: l_say_code_tbl okl_streams_util.Var10TabTyp;

14598: )
14599: IS
14600:
14601: l_strm_id_tbl okl_streams_util.NumberTabTyp;
14602: l_say_code_tbl okl_streams_util.Var10TabTyp;
14603: l_active_yn_tbl okl_streams_util.Var10TabTyp;
14604: l_date_history_tbl okl_streams_util.DateTabTyp;
14605: l_date_curr_tbl okl_streams_util.DateTabTyp;
14606:

Line 14603: l_active_yn_tbl okl_streams_util.Var10TabTyp;

14599: IS
14600:
14601: l_strm_id_tbl okl_streams_util.NumberTabTyp;
14602: l_say_code_tbl okl_streams_util.Var10TabTyp;
14603: l_active_yn_tbl okl_streams_util.Var10TabTyp;
14604: l_date_history_tbl okl_streams_util.DateTabTyp;
14605: l_date_curr_tbl okl_streams_util.DateTabTyp;
14606:
14607: CURSOR strms_csr IS

Line 14604: l_date_history_tbl okl_streams_util.DateTabTyp;

14600:
14601: l_strm_id_tbl okl_streams_util.NumberTabTyp;
14602: l_say_code_tbl okl_streams_util.Var10TabTyp;
14603: l_active_yn_tbl okl_streams_util.Var10TabTyp;
14604: l_date_history_tbl okl_streams_util.DateTabTyp;
14605: l_date_curr_tbl okl_streams_util.DateTabTyp;
14606:
14607: CURSOR strms_csr IS
14608: SELECT strm.id

Line 14605: l_date_curr_tbl okl_streams_util.DateTabTyp;

14601: l_strm_id_tbl okl_streams_util.NumberTabTyp;
14602: l_say_code_tbl okl_streams_util.Var10TabTyp;
14603: l_active_yn_tbl okl_streams_util.Var10TabTyp;
14604: l_date_history_tbl okl_streams_util.DateTabTyp;
14605: l_date_curr_tbl okl_streams_util.DateTabTyp;
14606:
14607: CURSOR strms_csr IS
14608: SELECT strm.id
14609: , strm.say_code

Line 14611: FROM okl_streams strm

14607: CURSOR strms_csr IS
14608: SELECT strm.id
14609: , strm.say_code
14610: , purpose_code -- R12.1.2
14611: FROM okl_streams strm
14612: WHERE khr_id = p_khr_id;
14613: l_strms_rec strms_csr%rowtype;
14614:
14615: i NUMBER;

Line 14647: UPDATE OKL_STREAMS

14643: END LOOP;
14644:
14645: -- Update all streams at once...
14646: FORALL i IN l_strm_id_tbl.FIRST..l_strm_id_tbl.LAST
14647: UPDATE OKL_STREAMS
14648: SET say_code = l_say_code_tbl(i),
14649: active_yn = l_active_yn_tbl(i),
14650: date_history = l_date_history_tbl(i),
14651: date_current = l_date_curr_tbl(i),