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_PUB

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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,