APPS.OKL_STREAM_GENERATOR_PVT dependencies on OKL_STREAMS_PUB

Line 631: p_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;

627: x_return_status OUT NOCOPY VARCHAR2,
628: x_se_id OUT NOCOPY NUMBER) Is
629:
630: l_prog_name CONSTANT VARCHAR2(100) := G_PKG_NAME||'.'||'generate_stub_element';
631: p_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
632: x_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
633: p_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
634: x_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
635: l_sty_id NUMBER;

Line 632: x_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;

628: x_se_id OUT NOCOPY NUMBER) Is
629:
630: l_prog_name CONSTANT VARCHAR2(100) := G_PKG_NAME||'.'||'generate_stub_element';
631: p_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
632: x_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
633: p_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
634: x_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
635: l_sty_id NUMBER;
636:

Line 633: p_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;

629:
630: l_prog_name CONSTANT VARCHAR2(100) := G_PKG_NAME||'.'||'generate_stub_element';
631: p_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
632: x_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
633: p_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
634: x_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
635: l_sty_id NUMBER;
636:
637: --prasjain:start for bug 5474827

Line 634: x_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;

630: l_prog_name CONSTANT VARCHAR2(100) := G_PKG_NAME||'.'||'generate_stub_element';
631: p_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
632: x_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
633: p_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
634: x_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
635: l_sty_id NUMBER;
636:
637: --prasjain:start for bug 5474827
638: /*

Line 705: okl_streams_pub.create_streams(

701: p_selv_tbl(0).parent_index := 1 ;
702:
703: -- Create the Stream Header along with one stream element.
704: --print( l_prog_name, ' b4 create_stub ' || to_char(l_sty_id) );
705: okl_streams_pub.create_streams(
706: p_api_version,
707: p_init_msg_list,
708: x_return_status,
709: x_msg_count,

Line 819: l_selv_tbl okl_streams_pub.selv_tbl_type;

815: AND kle.fee_type <> 'CAPITALIZED';
816:
817: r_rollover_fee c_rollover_fee%ROWTYPE;
818:
819: l_selv_tbl okl_streams_pub.selv_tbl_type;
820: l_tmp_selv_tbl okl_streams_pub.selv_tbl_type;
821: l_pt_tbl okl_streams_pub.selv_tbl_type;
822: lx_selv_tbl okl_streams_pub.selv_tbl_type;
823:

Line 820: l_tmp_selv_tbl okl_streams_pub.selv_tbl_type;

816:
817: r_rollover_fee c_rollover_fee%ROWTYPE;
818:
819: l_selv_tbl okl_streams_pub.selv_tbl_type;
820: l_tmp_selv_tbl okl_streams_pub.selv_tbl_type;
821: l_pt_tbl okl_streams_pub.selv_tbl_type;
822: lx_selv_tbl okl_streams_pub.selv_tbl_type;
823:
824: l_stmv_rec okl_streams_pub.stmv_rec_type;

Line 821: l_pt_tbl okl_streams_pub.selv_tbl_type;

817: r_rollover_fee c_rollover_fee%ROWTYPE;
818:
819: l_selv_tbl okl_streams_pub.selv_tbl_type;
820: l_tmp_selv_tbl okl_streams_pub.selv_tbl_type;
821: l_pt_tbl okl_streams_pub.selv_tbl_type;
822: lx_selv_tbl okl_streams_pub.selv_tbl_type;
823:
824: l_stmv_rec okl_streams_pub.stmv_rec_type;
825: l_pt_rec okl_streams_pub.stmv_rec_type;

Line 822: lx_selv_tbl okl_streams_pub.selv_tbl_type;

818:
819: l_selv_tbl okl_streams_pub.selv_tbl_type;
820: l_tmp_selv_tbl okl_streams_pub.selv_tbl_type;
821: l_pt_tbl okl_streams_pub.selv_tbl_type;
822: lx_selv_tbl okl_streams_pub.selv_tbl_type;
823:
824: l_stmv_rec okl_streams_pub.stmv_rec_type;
825: l_pt_rec okl_streams_pub.stmv_rec_type;
826: lx_stmv_rec okl_streams_pub.stmv_rec_type;

Line 824: l_stmv_rec okl_streams_pub.stmv_rec_type;

820: l_tmp_selv_tbl okl_streams_pub.selv_tbl_type;
821: l_pt_tbl okl_streams_pub.selv_tbl_type;
822: lx_selv_tbl okl_streams_pub.selv_tbl_type;
823:
824: l_stmv_rec okl_streams_pub.stmv_rec_type;
825: l_pt_rec okl_streams_pub.stmv_rec_type;
826: lx_stmv_rec okl_streams_pub.stmv_rec_type;
827:
828: l_capital_cost NUMBER;

Line 825: l_pt_rec okl_streams_pub.stmv_rec_type;

821: l_pt_tbl okl_streams_pub.selv_tbl_type;
822: lx_selv_tbl okl_streams_pub.selv_tbl_type;
823:
824: l_stmv_rec okl_streams_pub.stmv_rec_type;
825: l_pt_rec okl_streams_pub.stmv_rec_type;
826: lx_stmv_rec okl_streams_pub.stmv_rec_type;
827:
828: l_capital_cost NUMBER;
829:

Line 826: lx_stmv_rec okl_streams_pub.stmv_rec_type;

822: lx_selv_tbl okl_streams_pub.selv_tbl_type;
823:
824: l_stmv_rec okl_streams_pub.stmv_rec_type;
825: l_pt_rec okl_streams_pub.stmv_rec_type;
826: lx_stmv_rec okl_streams_pub.stmv_rec_type;
827:
828: l_capital_cost NUMBER;
829:
830: i BINARY_INTEGER := 0;

Line 855: l_principal_tbl okl_streams_pub.selv_tbl_type;

851:
852: l_se_id NUMBER;
853: l_fee_start_date DATE;
854:
855: l_principal_tbl okl_streams_pub.selv_tbl_type;
856: l_interest_tbl okl_streams_pub.selv_tbl_type;
857: l_prin_bal_tbl okl_streams_pub.selv_tbl_type;
858: l_termination_tbl okl_streams_pub.selv_tbl_type;
859: l_pre_tax_inc_tbl okl_streams_pub.selv_tbl_type;

Line 856: l_interest_tbl okl_streams_pub.selv_tbl_type;

852: l_se_id NUMBER;
853: l_fee_start_date DATE;
854:
855: l_principal_tbl okl_streams_pub.selv_tbl_type;
856: l_interest_tbl okl_streams_pub.selv_tbl_type;
857: l_prin_bal_tbl okl_streams_pub.selv_tbl_type;
858: l_termination_tbl okl_streams_pub.selv_tbl_type;
859: l_pre_tax_inc_tbl okl_streams_pub.selv_tbl_type;
860:

Line 857: l_prin_bal_tbl okl_streams_pub.selv_tbl_type;

853: l_fee_start_date DATE;
854:
855: l_principal_tbl okl_streams_pub.selv_tbl_type;
856: l_interest_tbl okl_streams_pub.selv_tbl_type;
857: l_prin_bal_tbl okl_streams_pub.selv_tbl_type;
858: l_termination_tbl okl_streams_pub.selv_tbl_type;
859: l_pre_tax_inc_tbl okl_streams_pub.selv_tbl_type;
860:
861: l_interim_interest NUMBER;

Line 858: l_termination_tbl okl_streams_pub.selv_tbl_type;

854:
855: l_principal_tbl okl_streams_pub.selv_tbl_type;
856: l_interest_tbl okl_streams_pub.selv_tbl_type;
857: l_prin_bal_tbl okl_streams_pub.selv_tbl_type;
858: l_termination_tbl okl_streams_pub.selv_tbl_type;
859: l_pre_tax_inc_tbl okl_streams_pub.selv_tbl_type;
860:
861: l_interim_interest NUMBER;
862: l_interim_days NUMBER;

Line 859: l_pre_tax_inc_tbl okl_streams_pub.selv_tbl_type;

855: l_principal_tbl okl_streams_pub.selv_tbl_type;
856: l_interest_tbl okl_streams_pub.selv_tbl_type;
857: l_prin_bal_tbl okl_streams_pub.selv_tbl_type;
858: l_termination_tbl okl_streams_pub.selv_tbl_type;
859: l_pre_tax_inc_tbl okl_streams_pub.selv_tbl_type;
860:
861: l_interim_interest NUMBER;
862: l_interim_days NUMBER;
863: l_interim_dpp NUMBER;

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

1028: l_stmv_rec.say_code := 'CURR';
1029: l_stmv_rec.active_yn := 'Y';
1030: l_stmv_rec.date_current := SYSDATE;
1031:
1032: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,
1033: p_init_msg_list => G_FALSE,
1034: x_return_status => lx_return_status,
1035: x_msg_count => x_msg_count,
1036: x_msg_data => x_msg_data,

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

1183:
1184: l_principal_tbl.DELETE;
1185: l_principal_tbl := lx_selv_tbl;
1186:
1187: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,
1188: p_init_msg_list => G_FALSE,
1189: x_return_status => lx_return_status,
1190: x_msg_count => x_msg_count,
1191: x_msg_data => x_msg_data,

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

1239:
1240: l_interest_tbl.DELETE;
1241: l_interest_tbl := lx_selv_tbl;
1242:
1243: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,
1244: p_init_msg_list => G_FALSE,
1245: x_return_status => lx_return_status,
1246: x_msg_count => x_msg_count,
1247: x_msg_data => x_msg_data,

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

1295:
1296: l_prin_bal_tbl.DELETE;
1297: l_prin_bal_tbl := lx_selv_tbl;
1298:
1299: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,
1300: p_init_msg_list => G_FALSE,
1301: x_return_status => lx_return_status,
1302: x_msg_count => x_msg_count,
1303: x_msg_data => x_msg_data,

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

1351:
1352: l_termination_tbl.DELETE;
1353: l_termination_tbl := lx_selv_tbl;
1354:
1355: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,
1356: p_init_msg_list => G_FALSE,
1357: x_return_status => lx_return_status,
1358: x_msg_count => x_msg_count,
1359: x_msg_data => x_msg_data,

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

1407:
1408: l_pre_tax_inc_tbl.DELETE;
1409: l_pre_tax_inc_tbl := lx_selv_tbl;
1410:
1411: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,
1412: p_init_msg_list => G_FALSE,
1413: x_return_status => lx_return_status,
1414: x_msg_count => x_msg_count,
1415: x_msg_data => x_msg_data,

Line 1637: l_selv_tbl okl_streams_pub.selv_tbl_type;

1633: AND sel.stream_element_date >= p_start_date
1634: AND sel.stream_element_date <= LAST_DAY(p_end_date) --bug# 3379436
1635: ORDER BY sel.stream_element_date;
1636:
1637: l_selv_tbl okl_streams_pub.selv_tbl_type;
1638: lx_selv_tbl okl_streams_pub.selv_tbl_type;
1639:
1640: l_stmv_rec okl_streams_pub.stmv_rec_type;
1641: lx_stmv_rec okl_streams_pub.stmv_rec_type;

Line 1638: lx_selv_tbl okl_streams_pub.selv_tbl_type;

1634: AND sel.stream_element_date <= LAST_DAY(p_end_date) --bug# 3379436
1635: ORDER BY sel.stream_element_date;
1636:
1637: l_selv_tbl okl_streams_pub.selv_tbl_type;
1638: lx_selv_tbl okl_streams_pub.selv_tbl_type;
1639:
1640: l_stmv_rec okl_streams_pub.stmv_rec_type;
1641: lx_stmv_rec okl_streams_pub.stmv_rec_type;
1642:

Line 1640: l_stmv_rec okl_streams_pub.stmv_rec_type;

1636:
1637: l_selv_tbl okl_streams_pub.selv_tbl_type;
1638: lx_selv_tbl okl_streams_pub.selv_tbl_type;
1639:
1640: l_stmv_rec okl_streams_pub.stmv_rec_type;
1641: lx_stmv_rec okl_streams_pub.stmv_rec_type;
1642:
1643: l_amortized_exp_id NUMBER;
1644: l_sty_name VARCHAR2(150);

Line 1641: lx_stmv_rec okl_streams_pub.stmv_rec_type;

1637: l_selv_tbl okl_streams_pub.selv_tbl_type;
1638: lx_selv_tbl okl_streams_pub.selv_tbl_type;
1639:
1640: l_stmv_rec okl_streams_pub.stmv_rec_type;
1641: lx_stmv_rec okl_streams_pub.stmv_rec_type;
1642:
1643: l_amortized_exp_id NUMBER;
1644: l_sty_name VARCHAR2(150);
1645: l_sty_id NUMBER;

Line 3208: x_selv_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,

3204: p_stub_amount IN NUMBER,
3205: p_currency_code IN VARCHAR2,
3206: p_day_convention_month IN VARCHAR2 DEFAULT '30',
3207: p_day_convention_year IN VARCHAR2 DEFAULT '360',
3208: x_selv_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
3209: x_return_status OUT NOCOPY VARCHAR2) IS
3210:
3211: lx_return_status VARCHAR2(1);
3212:

Line 4096: l_selv_tbl okl_streams_pub.selv_tbl_type;

4092: l_sty_id NUMBER;
4093: l_sty_name VARCHAR2(150);
4094: l_mapped_sty_name VARCHAR2(150);
4095:
4096: l_selv_tbl okl_streams_pub.selv_tbl_type;
4097: l_tmp_selv_tbl okl_streams_pub.selv_tbl_type;
4098: l_pt_tbl okl_streams_pub.selv_tbl_type;
4099: lx_selv_tbl okl_streams_pub.selv_tbl_type;
4100:

Line 4097: l_tmp_selv_tbl okl_streams_pub.selv_tbl_type;

4093: l_sty_name VARCHAR2(150);
4094: l_mapped_sty_name VARCHAR2(150);
4095:
4096: l_selv_tbl okl_streams_pub.selv_tbl_type;
4097: l_tmp_selv_tbl okl_streams_pub.selv_tbl_type;
4098: l_pt_tbl okl_streams_pub.selv_tbl_type;
4099: lx_selv_tbl okl_streams_pub.selv_tbl_type;
4100:
4101: l_stmv_rec okl_streams_pub.stmv_rec_type;

Line 4098: l_pt_tbl okl_streams_pub.selv_tbl_type;

4094: l_mapped_sty_name VARCHAR2(150);
4095:
4096: l_selv_tbl okl_streams_pub.selv_tbl_type;
4097: l_tmp_selv_tbl okl_streams_pub.selv_tbl_type;
4098: l_pt_tbl okl_streams_pub.selv_tbl_type;
4099: lx_selv_tbl okl_streams_pub.selv_tbl_type;
4100:
4101: l_stmv_rec okl_streams_pub.stmv_rec_type;
4102: l_pt_rec okl_streams_pub.stmv_rec_type;

Line 4099: lx_selv_tbl okl_streams_pub.selv_tbl_type;

4095:
4096: l_selv_tbl okl_streams_pub.selv_tbl_type;
4097: l_tmp_selv_tbl okl_streams_pub.selv_tbl_type;
4098: l_pt_tbl okl_streams_pub.selv_tbl_type;
4099: lx_selv_tbl okl_streams_pub.selv_tbl_type;
4100:
4101: l_stmv_rec okl_streams_pub.stmv_rec_type;
4102: l_pt_rec okl_streams_pub.stmv_rec_type;
4103: lx_stmv_rec okl_streams_pub.stmv_rec_type;

Line 4101: l_stmv_rec okl_streams_pub.stmv_rec_type;

4097: l_tmp_selv_tbl okl_streams_pub.selv_tbl_type;
4098: l_pt_tbl okl_streams_pub.selv_tbl_type;
4099: lx_selv_tbl okl_streams_pub.selv_tbl_type;
4100:
4101: l_stmv_rec okl_streams_pub.stmv_rec_type;
4102: l_pt_rec okl_streams_pub.stmv_rec_type;
4103: lx_stmv_rec okl_streams_pub.stmv_rec_type;
4104:
4105: l_capital_cost NUMBER;

Line 4102: l_pt_rec okl_streams_pub.stmv_rec_type;

4098: l_pt_tbl okl_streams_pub.selv_tbl_type;
4099: lx_selv_tbl okl_streams_pub.selv_tbl_type;
4100:
4101: l_stmv_rec okl_streams_pub.stmv_rec_type;
4102: l_pt_rec okl_streams_pub.stmv_rec_type;
4103: lx_stmv_rec okl_streams_pub.stmv_rec_type;
4104:
4105: l_capital_cost NUMBER;
4106:

Line 4103: lx_stmv_rec okl_streams_pub.stmv_rec_type;

4099: lx_selv_tbl okl_streams_pub.selv_tbl_type;
4100:
4101: l_stmv_rec okl_streams_pub.stmv_rec_type;
4102: l_pt_rec okl_streams_pub.stmv_rec_type;
4103: lx_stmv_rec okl_streams_pub.stmv_rec_type;
4104:
4105: l_capital_cost NUMBER;
4106:
4107: i BINARY_INTEGER := 0;

Line 4246: l_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;

4242: l_capred_sty_name VARCHAR2(150);
4243:
4244: -- Added by RGOOTY : End
4245: -- Added by RGOOTY for perf.: Bug Number 4346646 Start
4246: l_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
4247: l_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
4248:
4249: lx_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
4250: lx_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;

Line 4247: l_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;

4243:
4244: -- Added by RGOOTY : End
4245: -- Added by RGOOTY for perf.: Bug Number 4346646 Start
4246: l_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
4247: l_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
4248:
4249: lx_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
4250: lx_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
4251: -- Added by RGOOTY for perf.: End

Line 4249: lx_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;

4245: -- Added by RGOOTY for perf.: Bug Number 4346646 Start
4246: l_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
4247: l_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
4248:
4249: lx_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
4250: lx_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
4251: -- Added by RGOOTY for perf.: End
4252:
4253: -- djanaswa ER6274342 start

Line 4250: lx_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;

4246: l_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
4247: l_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
4248:
4249: lx_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
4250: lx_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
4251: -- Added by RGOOTY for perf.: End
4252:
4253: -- djanaswa ER6274342 start
4254: l_arrears_pay_dates_option okl_st_gen_tmpt_sets_all.isg_arrears_pay_dates_option%type;

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

4659:
4660: l_selv_tbl.DELETE;
4661: l_selv_tbl := lx_selv_tbl;
4662:
4663: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,
4664: p_init_msg_list => G_FALSE,
4665: x_return_status => lx_return_status,
4666: x_msg_count => x_msg_count,
4667: x_msg_data => x_msg_data,

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

4804:
4805: l_selv_tbl.DELETE;
4806: l_selv_tbl := lx_selv_tbl;
4807:
4808: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,
4809: p_init_msg_list => G_FALSE,
4810: x_return_status => lx_return_status,
4811: x_msg_count => x_msg_count,
4812: x_msg_data => x_msg_data,

Line 4831: Okl_Streams_Pub.create_streams_perf(

4827: --Create all the accumulated Streams at one shot ..
4828: IF l_stmv_tbl.COUNT > 0 AND
4829: l_full_selv_tbl.COUNT > 0
4830: THEN
4831: Okl_Streams_Pub.create_streams_perf(
4832: p_api_version,
4833: p_init_msg_list,
4834: lx_return_status,
4835: x_msg_count,

Line 4933: l_selv_tbl okl_streams_pub.selv_tbl_type;

4929: l_interest_id NUMBER;
4930: l_prin_bal_id NUMBER;
4931: l_termination_id NUMBER;
4932:
4933: l_selv_tbl okl_streams_pub.selv_tbl_type;
4934: l_pt_tbl okl_streams_pub.selv_tbl_type;
4935: lx_selv_tbl okl_streams_pub.selv_tbl_type;
4936:
4937: l_stmv_rec okl_streams_pub.stmv_rec_type;

Line 4934: l_pt_tbl okl_streams_pub.selv_tbl_type;

4930: l_prin_bal_id NUMBER;
4931: l_termination_id NUMBER;
4932:
4933: l_selv_tbl okl_streams_pub.selv_tbl_type;
4934: l_pt_tbl okl_streams_pub.selv_tbl_type;
4935: lx_selv_tbl okl_streams_pub.selv_tbl_type;
4936:
4937: l_stmv_rec okl_streams_pub.stmv_rec_type;
4938: l_pt_rec okl_streams_pub.stmv_rec_type;

Line 4935: lx_selv_tbl okl_streams_pub.selv_tbl_type;

4931: l_termination_id NUMBER;
4932:
4933: l_selv_tbl okl_streams_pub.selv_tbl_type;
4934: l_pt_tbl okl_streams_pub.selv_tbl_type;
4935: lx_selv_tbl okl_streams_pub.selv_tbl_type;
4936:
4937: l_stmv_rec okl_streams_pub.stmv_rec_type;
4938: l_pt_rec okl_streams_pub.stmv_rec_type;
4939: lx_stmv_rec okl_streams_pub.stmv_rec_type;

Line 4937: l_stmv_rec okl_streams_pub.stmv_rec_type;

4933: l_selv_tbl okl_streams_pub.selv_tbl_type;
4934: l_pt_tbl okl_streams_pub.selv_tbl_type;
4935: lx_selv_tbl okl_streams_pub.selv_tbl_type;
4936:
4937: l_stmv_rec okl_streams_pub.stmv_rec_type;
4938: l_pt_rec okl_streams_pub.stmv_rec_type;
4939: lx_stmv_rec okl_streams_pub.stmv_rec_type;
4940:
4941: i BINARY_INTEGER := 0;

Line 4938: l_pt_rec okl_streams_pub.stmv_rec_type;

4934: l_pt_tbl okl_streams_pub.selv_tbl_type;
4935: lx_selv_tbl okl_streams_pub.selv_tbl_type;
4936:
4937: l_stmv_rec okl_streams_pub.stmv_rec_type;
4938: l_pt_rec okl_streams_pub.stmv_rec_type;
4939: lx_stmv_rec okl_streams_pub.stmv_rec_type;
4940:
4941: i BINARY_INTEGER := 0;
4942: j BINARY_INTEGER := 0;

Line 4939: lx_stmv_rec okl_streams_pub.stmv_rec_type;

4935: lx_selv_tbl okl_streams_pub.selv_tbl_type;
4936:
4937: l_stmv_rec okl_streams_pub.stmv_rec_type;
4938: l_pt_rec okl_streams_pub.stmv_rec_type;
4939: lx_stmv_rec okl_streams_pub.stmv_rec_type;
4940:
4941: i BINARY_INTEGER := 0;
4942: j BINARY_INTEGER := 0;
4943: l_ele_count BINARY_INTEGER := 0;

Line 5001: okl_streams_pub.create_streams(

4997: END IF;
4998:
4999: l_stmv_rec.purpose_code := 'FLOW';
5000: -- Proceed with Creating the RENT Stream Header
5001: okl_streams_pub.create_streams(
5002: p_api_version => G_API_VERSION,
5003: p_init_msg_list => G_FALSE,
5004: x_return_status => lx_return_status,
5005: x_msg_count => x_msg_count,

Line 5107: okl_streams_pub.create_stream_elements(

5103: --print( l_prog_name, 'start date ' || l_selv_tbl(1).stream_element_date );
5104: -- Create the Stream Elements in the OKL_STRM_ELEMENTS table
5105: -- feels like the join between stream header and stream elements here is
5106: -- sel_id, we are populating it in the above for loop.
5107: okl_streams_pub.create_stream_elements(
5108: p_api_version => G_API_VERSION,
5109: p_init_msg_list => G_FALSE,
5110: x_return_status => lx_return_status,
5111: x_msg_count => x_msg_count,

Line 5146: okl_streams_pub.create_stream_elements(

5142: END IF;
5143: END LOOP;
5144: lx_selv_tbl.DELETE;
5145: -- Create/Update Stream Elements with the above modification.
5146: okl_streams_pub.create_stream_elements(
5147: p_api_version => G_API_VERSION,
5148: p_init_msg_list => G_FALSE,
5149: x_return_status => lx_return_status,
5150: x_msg_count => x_msg_count,

Line 5213: okl_streams_pub.create_streams(

5209: END IF;
5210: l_pt_tbl.DELETE;
5211: l_pt_tbl := lx_selv_tbl;
5212: -- Create additional Pass Through Streams
5213: okl_streams_pub.create_streams(
5214: p_api_version => G_API_VERSION,
5215: p_init_msg_list => G_FALSE,
5216: x_return_status => lx_return_status,
5217: x_msg_count => x_msg_count,

Line 5407: l_selv_tbl okl_streams_pub.selv_tbl_type;

5403: l_interest_id NUMBER;
5404: l_prin_bal_id NUMBER;
5405: l_termination_id NUMBER;
5406:
5407: l_selv_tbl okl_streams_pub.selv_tbl_type;
5408: l_pt_tbl okl_streams_pub.selv_tbl_type;
5409: l_pt_pro_fee_tbl okl_streams_pub.selv_tbl_type;
5410: lx_selv_tbl okl_streams_pub.selv_tbl_type;
5411:

Line 5408: l_pt_tbl okl_streams_pub.selv_tbl_type;

5404: l_prin_bal_id NUMBER;
5405: l_termination_id NUMBER;
5406:
5407: l_selv_tbl okl_streams_pub.selv_tbl_type;
5408: l_pt_tbl okl_streams_pub.selv_tbl_type;
5409: l_pt_pro_fee_tbl okl_streams_pub.selv_tbl_type;
5410: lx_selv_tbl okl_streams_pub.selv_tbl_type;
5411:
5412: l_stmv_rec okl_streams_pub.stmv_rec_type;

Line 5409: l_pt_pro_fee_tbl okl_streams_pub.selv_tbl_type;

5405: l_termination_id NUMBER;
5406:
5407: l_selv_tbl okl_streams_pub.selv_tbl_type;
5408: l_pt_tbl okl_streams_pub.selv_tbl_type;
5409: l_pt_pro_fee_tbl okl_streams_pub.selv_tbl_type;
5410: lx_selv_tbl okl_streams_pub.selv_tbl_type;
5411:
5412: l_stmv_rec okl_streams_pub.stmv_rec_type;
5413: l_pt_rec okl_streams_pub.stmv_rec_type;

Line 5410: lx_selv_tbl okl_streams_pub.selv_tbl_type;

5406:
5407: l_selv_tbl okl_streams_pub.selv_tbl_type;
5408: l_pt_tbl okl_streams_pub.selv_tbl_type;
5409: l_pt_pro_fee_tbl okl_streams_pub.selv_tbl_type;
5410: lx_selv_tbl okl_streams_pub.selv_tbl_type;
5411:
5412: l_stmv_rec okl_streams_pub.stmv_rec_type;
5413: l_pt_rec okl_streams_pub.stmv_rec_type;
5414: l_pt_pro_fee_rec okl_streams_pub.stmv_rec_type;

Line 5412: l_stmv_rec okl_streams_pub.stmv_rec_type;

5408: l_pt_tbl okl_streams_pub.selv_tbl_type;
5409: l_pt_pro_fee_tbl okl_streams_pub.selv_tbl_type;
5410: lx_selv_tbl okl_streams_pub.selv_tbl_type;
5411:
5412: l_stmv_rec okl_streams_pub.stmv_rec_type;
5413: l_pt_rec okl_streams_pub.stmv_rec_type;
5414: l_pt_pro_fee_rec okl_streams_pub.stmv_rec_type;
5415: lx_stmv_rec okl_streams_pub.stmv_rec_type;
5416:

Line 5413: l_pt_rec okl_streams_pub.stmv_rec_type;

5409: l_pt_pro_fee_tbl okl_streams_pub.selv_tbl_type;
5410: lx_selv_tbl okl_streams_pub.selv_tbl_type;
5411:
5412: l_stmv_rec okl_streams_pub.stmv_rec_type;
5413: l_pt_rec okl_streams_pub.stmv_rec_type;
5414: l_pt_pro_fee_rec okl_streams_pub.stmv_rec_type;
5415: lx_stmv_rec okl_streams_pub.stmv_rec_type;
5416:
5417: -- Loan Amortization

Line 5414: l_pt_pro_fee_rec okl_streams_pub.stmv_rec_type;

5410: lx_selv_tbl okl_streams_pub.selv_tbl_type;
5411:
5412: l_stmv_rec okl_streams_pub.stmv_rec_type;
5413: l_pt_rec okl_streams_pub.stmv_rec_type;
5414: l_pt_pro_fee_rec okl_streams_pub.stmv_rec_type;
5415: lx_stmv_rec okl_streams_pub.stmv_rec_type;
5416:
5417: -- Loan Amortization
5418: l_principal_tbl okl_streams_pub.selv_tbl_type;

Line 5415: lx_stmv_rec okl_streams_pub.stmv_rec_type;

5411:
5412: l_stmv_rec okl_streams_pub.stmv_rec_type;
5413: l_pt_rec okl_streams_pub.stmv_rec_type;
5414: l_pt_pro_fee_rec okl_streams_pub.stmv_rec_type;
5415: lx_stmv_rec okl_streams_pub.stmv_rec_type;
5416:
5417: -- Loan Amortization
5418: l_principal_tbl okl_streams_pub.selv_tbl_type;
5419: l_interest_tbl okl_streams_pub.selv_tbl_type;

Line 5418: l_principal_tbl okl_streams_pub.selv_tbl_type;

5414: l_pt_pro_fee_rec okl_streams_pub.stmv_rec_type;
5415: lx_stmv_rec okl_streams_pub.stmv_rec_type;
5416:
5417: -- Loan Amortization
5418: l_principal_tbl okl_streams_pub.selv_tbl_type;
5419: l_interest_tbl okl_streams_pub.selv_tbl_type;
5420: l_prin_bal_tbl okl_streams_pub.selv_tbl_type;
5421: l_termination_tbl okl_streams_pub.selv_tbl_type;
5422: l_pre_tax_inc_tbl okl_streams_pub.selv_tbl_type;

Line 5419: l_interest_tbl okl_streams_pub.selv_tbl_type;

5415: lx_stmv_rec okl_streams_pub.stmv_rec_type;
5416:
5417: -- Loan Amortization
5418: l_principal_tbl okl_streams_pub.selv_tbl_type;
5419: l_interest_tbl okl_streams_pub.selv_tbl_type;
5420: l_prin_bal_tbl okl_streams_pub.selv_tbl_type;
5421: l_termination_tbl okl_streams_pub.selv_tbl_type;
5422: l_pre_tax_inc_tbl okl_streams_pub.selv_tbl_type;
5423:

Line 5420: l_prin_bal_tbl okl_streams_pub.selv_tbl_type;

5416:
5417: -- Loan Amortization
5418: l_principal_tbl okl_streams_pub.selv_tbl_type;
5419: l_interest_tbl okl_streams_pub.selv_tbl_type;
5420: l_prin_bal_tbl okl_streams_pub.selv_tbl_type;
5421: l_termination_tbl okl_streams_pub.selv_tbl_type;
5422: l_pre_tax_inc_tbl okl_streams_pub.selv_tbl_type;
5423:
5424: l_capital_cost NUMBER;

Line 5421: l_termination_tbl okl_streams_pub.selv_tbl_type;

5417: -- Loan Amortization
5418: l_principal_tbl okl_streams_pub.selv_tbl_type;
5419: l_interest_tbl okl_streams_pub.selv_tbl_type;
5420: l_prin_bal_tbl okl_streams_pub.selv_tbl_type;
5421: l_termination_tbl okl_streams_pub.selv_tbl_type;
5422: l_pre_tax_inc_tbl okl_streams_pub.selv_tbl_type;
5423:
5424: l_capital_cost NUMBER;
5425: l_interim_interest NUMBER;

Line 5422: l_pre_tax_inc_tbl okl_streams_pub.selv_tbl_type;

5418: l_principal_tbl okl_streams_pub.selv_tbl_type;
5419: l_interest_tbl okl_streams_pub.selv_tbl_type;
5420: l_prin_bal_tbl okl_streams_pub.selv_tbl_type;
5421: l_termination_tbl okl_streams_pub.selv_tbl_type;
5422: l_pre_tax_inc_tbl okl_streams_pub.selv_tbl_type;
5423:
5424: l_capital_cost NUMBER;
5425: l_interim_interest NUMBER;
5426: l_interim_days NUMBER;

Line 5442: l_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;

5438:
5439: l_passthrough_pro_fee_id NUMBER;
5440:
5441: -- Added by RGOOTY for perf.: Bug Number 4346646 Start
5442: l_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
5443: l_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
5444:
5445: lx_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
5446: lx_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;

Line 5443: l_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;

5439: l_passthrough_pro_fee_id NUMBER;
5440:
5441: -- Added by RGOOTY for perf.: Bug Number 4346646 Start
5442: l_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
5443: l_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
5444:
5445: lx_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
5446: lx_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
5447: -- Added by RGOOTY for perf.: End

Line 5445: lx_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;

5441: -- Added by RGOOTY for perf.: Bug Number 4346646 Start
5442: l_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
5443: l_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
5444:
5445: lx_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
5446: lx_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
5447: -- Added by RGOOTY for perf.: End
5448:
5449: cursor fee_strm_type_csr ( kleid NUMBER,

Line 5446: lx_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;

5442: l_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
5443: l_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
5444:
5445: lx_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
5446: lx_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
5447: -- Added by RGOOTY for perf.: End
5448:
5449: cursor fee_strm_type_csr ( kleid NUMBER,
5450: linestyle VARCHAR2 ) is

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

5653: ELSIF (lx_return_status = G_RET_STS_ERROR) THEN
5654: RAISE OKL_API.G_EXCEPTION_ERROR;
5655: END IF;
5656: /*
5657: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,
5658: p_init_msg_list => G_FALSE,
5659: x_return_status => lx_return_status,
5660: x_msg_count => x_msg_count,
5661: x_msg_data => x_msg_data,

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

5765: ELSIF (lx_return_status = G_RET_STS_ERROR) THEN
5766: RAISE OKL_API.G_EXCEPTION_ERROR;
5767: END IF;
5768: /*
5769: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,
5770: p_init_msg_list => G_FALSE,
5771: x_return_status => lx_return_status,
5772: x_msg_count => x_msg_count,
5773: x_msg_data => x_msg_data,

Line 5916: Okl_Streams_Pub.create_streams_perf(

5912: x_payment_count := x_payment_count + 1;
5913: END IF;
5914: END LOOP;
5915: --Create all the accumulated Streams at one shot ..
5916: Okl_Streams_Pub.create_streams_perf(
5917: p_api_version,
5918: p_init_msg_list,
5919: lx_return_status,
5920: x_msg_count,

Line 6211: l_selv_tbl okl_streams_pub.selv_tbl_type;

6207: l_interest_id NUMBER;
6208: l_prin_bal_id NUMBER;
6209: l_termination_id NUMBER;
6210:
6211: l_selv_tbl okl_streams_pub.selv_tbl_type;
6212: l_pt_tbl okl_streams_pub.selv_tbl_type;
6213: lx_selv_tbl okl_streams_pub.selv_tbl_type;
6214:
6215: l_stmv_rec okl_streams_pub.stmv_rec_type;

Line 6212: l_pt_tbl okl_streams_pub.selv_tbl_type;

6208: l_prin_bal_id NUMBER;
6209: l_termination_id NUMBER;
6210:
6211: l_selv_tbl okl_streams_pub.selv_tbl_type;
6212: l_pt_tbl okl_streams_pub.selv_tbl_type;
6213: lx_selv_tbl okl_streams_pub.selv_tbl_type;
6214:
6215: l_stmv_rec okl_streams_pub.stmv_rec_type;
6216: l_pt_rec okl_streams_pub.stmv_rec_type;

Line 6213: lx_selv_tbl okl_streams_pub.selv_tbl_type;

6209: l_termination_id NUMBER;
6210:
6211: l_selv_tbl okl_streams_pub.selv_tbl_type;
6212: l_pt_tbl okl_streams_pub.selv_tbl_type;
6213: lx_selv_tbl okl_streams_pub.selv_tbl_type;
6214:
6215: l_stmv_rec okl_streams_pub.stmv_rec_type;
6216: l_pt_rec okl_streams_pub.stmv_rec_type;
6217: lx_stmv_rec okl_streams_pub.stmv_rec_type;

Line 6215: l_stmv_rec okl_streams_pub.stmv_rec_type;

6211: l_selv_tbl okl_streams_pub.selv_tbl_type;
6212: l_pt_tbl okl_streams_pub.selv_tbl_type;
6213: lx_selv_tbl okl_streams_pub.selv_tbl_type;
6214:
6215: l_stmv_rec okl_streams_pub.stmv_rec_type;
6216: l_pt_rec okl_streams_pub.stmv_rec_type;
6217: lx_stmv_rec okl_streams_pub.stmv_rec_type;
6218:
6219: -- Loan Amortization

Line 6216: l_pt_rec okl_streams_pub.stmv_rec_type;

6212: l_pt_tbl okl_streams_pub.selv_tbl_type;
6213: lx_selv_tbl okl_streams_pub.selv_tbl_type;
6214:
6215: l_stmv_rec okl_streams_pub.stmv_rec_type;
6216: l_pt_rec okl_streams_pub.stmv_rec_type;
6217: lx_stmv_rec okl_streams_pub.stmv_rec_type;
6218:
6219: -- Loan Amortization
6220: l_principal_tbl okl_streams_pub.selv_tbl_type;

Line 6217: lx_stmv_rec okl_streams_pub.stmv_rec_type;

6213: lx_selv_tbl okl_streams_pub.selv_tbl_type;
6214:
6215: l_stmv_rec okl_streams_pub.stmv_rec_type;
6216: l_pt_rec okl_streams_pub.stmv_rec_type;
6217: lx_stmv_rec okl_streams_pub.stmv_rec_type;
6218:
6219: -- Loan Amortization
6220: l_principal_tbl okl_streams_pub.selv_tbl_type;
6221: l_interest_tbl okl_streams_pub.selv_tbl_type;

Line 6220: l_principal_tbl okl_streams_pub.selv_tbl_type;

6216: l_pt_rec okl_streams_pub.stmv_rec_type;
6217: lx_stmv_rec okl_streams_pub.stmv_rec_type;
6218:
6219: -- Loan Amortization
6220: l_principal_tbl okl_streams_pub.selv_tbl_type;
6221: l_interest_tbl okl_streams_pub.selv_tbl_type;
6222: l_prin_bal_tbl okl_streams_pub.selv_tbl_type;
6223: l_termination_tbl okl_streams_pub.selv_tbl_type;
6224: l_pre_tax_inc_tbl okl_streams_pub.selv_tbl_type;

Line 6221: l_interest_tbl okl_streams_pub.selv_tbl_type;

6217: lx_stmv_rec okl_streams_pub.stmv_rec_type;
6218:
6219: -- Loan Amortization
6220: l_principal_tbl okl_streams_pub.selv_tbl_type;
6221: l_interest_tbl okl_streams_pub.selv_tbl_type;
6222: l_prin_bal_tbl okl_streams_pub.selv_tbl_type;
6223: l_termination_tbl okl_streams_pub.selv_tbl_type;
6224: l_pre_tax_inc_tbl okl_streams_pub.selv_tbl_type;
6225:

Line 6222: l_prin_bal_tbl okl_streams_pub.selv_tbl_type;

6218:
6219: -- Loan Amortization
6220: l_principal_tbl okl_streams_pub.selv_tbl_type;
6221: l_interest_tbl okl_streams_pub.selv_tbl_type;
6222: l_prin_bal_tbl okl_streams_pub.selv_tbl_type;
6223: l_termination_tbl okl_streams_pub.selv_tbl_type;
6224: l_pre_tax_inc_tbl okl_streams_pub.selv_tbl_type;
6225:
6226: l_capital_cost NUMBER;

Line 6223: l_termination_tbl okl_streams_pub.selv_tbl_type;

6219: -- Loan Amortization
6220: l_principal_tbl okl_streams_pub.selv_tbl_type;
6221: l_interest_tbl okl_streams_pub.selv_tbl_type;
6222: l_prin_bal_tbl okl_streams_pub.selv_tbl_type;
6223: l_termination_tbl okl_streams_pub.selv_tbl_type;
6224: l_pre_tax_inc_tbl okl_streams_pub.selv_tbl_type;
6225:
6226: l_capital_cost NUMBER;
6227: l_interim_interest NUMBER;

Line 6224: l_pre_tax_inc_tbl okl_streams_pub.selv_tbl_type;

6220: l_principal_tbl okl_streams_pub.selv_tbl_type;
6221: l_interest_tbl okl_streams_pub.selv_tbl_type;
6222: l_prin_bal_tbl okl_streams_pub.selv_tbl_type;
6223: l_termination_tbl okl_streams_pub.selv_tbl_type;
6224: l_pre_tax_inc_tbl okl_streams_pub.selv_tbl_type;
6225:
6226: l_capital_cost NUMBER;
6227: l_interim_interest NUMBER;
6228: l_interim_days NUMBER;

Line 6306: l_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;

6302: l_initial_irr NUMBER := 0;
6303: l_asset_count NUMBER := 0;
6304:
6305: -- Added by RGOOTY for perf.: Bug Number 4346646 Start
6306: l_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
6307: l_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
6308:
6309: lx_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
6310: lx_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;

Line 6307: l_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;

6303: l_asset_count NUMBER := 0;
6304:
6305: -- Added by RGOOTY for perf.: Bug Number 4346646 Start
6306: l_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
6307: l_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
6308:
6309: lx_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
6310: lx_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
6311: -- Added by RGOOTY for perf.: End

Line 6309: lx_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;

6305: -- Added by RGOOTY for perf.: Bug Number 4346646 Start
6306: l_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
6307: l_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
6308:
6309: lx_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
6310: lx_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
6311: -- Added by RGOOTY for perf.: End
6312:
6313: --Added by prasjain for bug 5474827

Line 6310: lx_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;

6306: l_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
6307: l_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
6308:
6309: lx_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
6310: lx_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
6311: -- Added by RGOOTY for perf.: End
6312:
6313: --Added by prasjain for bug 5474827
6314: l_se_id NUMBER;

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

6814:
6815: l_principal_tbl.DELETE;
6816: l_principal_tbl := lx_selv_tbl;
6817:
6818: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,
6819: p_init_msg_list => G_FALSE,
6820: x_return_status => lx_return_status,
6821: x_msg_count => x_msg_count,
6822: x_msg_data => x_msg_data,

Line 6879: okl_streams_pub.create_streams(

6875:
6876: l_interest_tbl.DELETE;
6877: l_interest_tbl := lx_selv_tbl;
6878:
6879: okl_streams_pub.create_streams(
6880: p_api_version => G_API_VERSION,
6881: p_init_msg_list => G_FALSE,
6882: x_return_status => lx_return_status,
6883: x_msg_count => x_msg_count,

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

6936:
6937: l_prin_bal_tbl.DELETE;
6938: l_prin_bal_tbl := lx_selv_tbl;
6939:
6940: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,
6941: p_init_msg_list => G_FALSE,
6942: x_return_status => lx_return_status,
6943: x_msg_count => x_msg_count,
6944: x_msg_data => x_msg_data,

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

6991:
6992: l_termination_tbl.DELETE;
6993: l_termination_tbl := lx_selv_tbl;
6994:
6995: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,
6996: p_init_msg_list => G_FALSE,
6997: x_return_status => lx_return_status,
6998: x_msg_count => x_msg_count,
6999: x_msg_data => x_msg_data,

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

7044:
7045: l_pre_tax_inc_tbl.DELETE;
7046: l_pre_tax_inc_tbl := lx_selv_tbl;
7047:
7048: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,
7049: p_init_msg_list => G_FALSE,
7050: x_return_status => lx_return_status,
7051: x_msg_count => x_msg_count,
7052: x_msg_data => x_msg_data,

Line 7609: Okl_Streams_Pub.create_streams_perf(

7605: --Create all the accumulated Streams at one shot ..
7606: IF l_stmv_tbl.COUNT > 0 AND
7607: l_full_selv_tbl.COUNT > 0
7608: THEN
7609: Okl_Streams_Pub.create_streams_perf(
7610: p_api_version,
7611: p_init_msg_list,
7612: lx_return_status,
7613: x_msg_count,

Line 7951: l_selv_tbl okl_streams_pub.selv_tbl_type;

7947: l_sty_id NUMBER;
7948: l_sty_name VARCHAR2(150);
7949: l_mapped_sty_name VARCHAR2(150);
7950:
7951: l_selv_tbl okl_streams_pub.selv_tbl_type;
7952: l_pt_tbl okl_streams_pub.selv_tbl_type;
7953: lx_selv_tbl okl_streams_pub.selv_tbl_type;
7954:
7955: l_stmv_rec okl_streams_pub.stmv_rec_type;

Line 7952: l_pt_tbl okl_streams_pub.selv_tbl_type;

7948: l_sty_name VARCHAR2(150);
7949: l_mapped_sty_name VARCHAR2(150);
7950:
7951: l_selv_tbl okl_streams_pub.selv_tbl_type;
7952: l_pt_tbl okl_streams_pub.selv_tbl_type;
7953: lx_selv_tbl okl_streams_pub.selv_tbl_type;
7954:
7955: l_stmv_rec okl_streams_pub.stmv_rec_type;
7956: l_stmv_tbl okl_streams_pub.stmv_tbl_type;

Line 7953: lx_selv_tbl okl_streams_pub.selv_tbl_type;

7949: l_mapped_sty_name VARCHAR2(150);
7950:
7951: l_selv_tbl okl_streams_pub.selv_tbl_type;
7952: l_pt_tbl okl_streams_pub.selv_tbl_type;
7953: lx_selv_tbl okl_streams_pub.selv_tbl_type;
7954:
7955: l_stmv_rec okl_streams_pub.stmv_rec_type;
7956: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
7957: lx_stmv_tbl okl_streams_pub.stmv_tbl_type;

Line 7955: l_stmv_rec okl_streams_pub.stmv_rec_type;

7951: l_selv_tbl okl_streams_pub.selv_tbl_type;
7952: l_pt_tbl okl_streams_pub.selv_tbl_type;
7953: lx_selv_tbl okl_streams_pub.selv_tbl_type;
7954:
7955: l_stmv_rec okl_streams_pub.stmv_rec_type;
7956: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
7957: lx_stmv_tbl okl_streams_pub.stmv_tbl_type;
7958: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
7959: l_pt_rec okl_streams_pub.stmv_rec_type;

Line 7956: l_stmv_tbl okl_streams_pub.stmv_tbl_type;

7952: l_pt_tbl okl_streams_pub.selv_tbl_type;
7953: lx_selv_tbl okl_streams_pub.selv_tbl_type;
7954:
7955: l_stmv_rec okl_streams_pub.stmv_rec_type;
7956: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
7957: lx_stmv_tbl okl_streams_pub.stmv_tbl_type;
7958: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
7959: l_pt_rec okl_streams_pub.stmv_rec_type;
7960: lx_stmv_rec okl_streams_pub.stmv_rec_type;

Line 7957: lx_stmv_tbl okl_streams_pub.stmv_tbl_type;

7953: lx_selv_tbl okl_streams_pub.selv_tbl_type;
7954:
7955: l_stmv_rec okl_streams_pub.stmv_rec_type;
7956: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
7957: lx_stmv_tbl okl_streams_pub.stmv_tbl_type;
7958: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
7959: l_pt_rec okl_streams_pub.stmv_rec_type;
7960: lx_stmv_rec okl_streams_pub.stmv_rec_type;
7961:

Line 7958: x_stmv_tbl okl_streams_pub.stmv_tbl_type;

7954:
7955: l_stmv_rec okl_streams_pub.stmv_rec_type;
7956: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
7957: lx_stmv_tbl okl_streams_pub.stmv_tbl_type;
7958: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
7959: l_pt_rec okl_streams_pub.stmv_rec_type;
7960: lx_stmv_rec okl_streams_pub.stmv_rec_type;
7961:
7962: i BINARY_INTEGER := 0;

Line 7959: l_pt_rec okl_streams_pub.stmv_rec_type;

7955: l_stmv_rec okl_streams_pub.stmv_rec_type;
7956: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
7957: lx_stmv_tbl okl_streams_pub.stmv_tbl_type;
7958: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
7959: l_pt_rec okl_streams_pub.stmv_rec_type;
7960: lx_stmv_rec okl_streams_pub.stmv_rec_type;
7961:
7962: i BINARY_INTEGER := 0;
7963:

Line 7960: lx_stmv_rec okl_streams_pub.stmv_rec_type;

7956: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
7957: lx_stmv_tbl okl_streams_pub.stmv_tbl_type;
7958: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
7959: l_pt_rec okl_streams_pub.stmv_rec_type;
7960: lx_stmv_rec okl_streams_pub.stmv_rec_type;
7961:
7962: i BINARY_INTEGER := 0;
7963:
7964: l_api_name CONSTANT VARCHAR2(61) := 'GEN_VAR_INT_SCHEDULE';

Line 8020: Okl_Streams_pub.update_streams(

8016: END LOOP;
8017:
8018: If ( l_stmv_tbl.COUNT > 0 ) Then
8019:
8020: Okl_Streams_pub.update_streams(
8021: p_api_version => p_api_version,
8022: p_init_msg_list => p_init_msg_list,
8023: x_return_status => x_return_status,
8024: x_msg_count => x_msg_count,

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

8109:
8110: l_selv_tbl.DELETE;
8111: l_selv_tbl := lx_selv_tbl;
8112:
8113: okl_streams_pub.create_streams(p_api_version => p_api_version,
8114: p_init_msg_list => p_init_msg_list,
8115: x_return_status => x_return_status,
8116: x_msg_count => x_msg_count,
8117: x_msg_data => x_msg_data,

Line 8171: x_stmv_rec OUT NOCOPY okl_streams_pub.stmv_rec_type,

8167: p_contract_id IN NUMBER,
8168: p_kle_id IN NUMBER,
8169: p_sty_id IN NUMBER,
8170: p_mode IN VARCHAR2,
8171: x_stmv_rec OUT NOCOPY okl_streams_pub.stmv_rec_type,
8172: x_selv_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
8173: x_return_status OUT NOCOPY VARCHAR2,
8174: x_msg_count OUT NOCOPY NUMBER,
8175: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 8172: x_selv_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,

8168: p_kle_id IN NUMBER,
8169: p_sty_id IN NUMBER,
8170: p_mode IN VARCHAR2,
8171: x_stmv_rec OUT NOCOPY okl_streams_pub.stmv_rec_type,
8172: x_selv_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
8173: x_return_status OUT NOCOPY VARCHAR2,
8174: x_msg_count OUT NOCOPY NUMBER,
8175: x_msg_data OUT NOCOPY VARCHAR2) IS
8176:

Line 8308: l_selv_tbl okl_streams_pub.selv_tbl_type;

8304: l_sty_id NUMBER;
8305: l_sty_name VARCHAR2(150);
8306: l_mapped_sty_name VARCHAR2(150);
8307:
8308: l_selv_tbl okl_streams_pub.selv_tbl_type;
8309: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
8310: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
8311: lx_selv_tbl okl_streams_pub.selv_tbl_type;
8312:

Line 8309: l_stmv_tbl okl_streams_pub.stmv_tbl_type;

8305: l_sty_name VARCHAR2(150);
8306: l_mapped_sty_name VARCHAR2(150);
8307:
8308: l_selv_tbl okl_streams_pub.selv_tbl_type;
8309: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
8310: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
8311: lx_selv_tbl okl_streams_pub.selv_tbl_type;
8312:
8313: l_stmv_rec okl_streams_pub.stmv_rec_type;

Line 8310: x_stmv_tbl okl_streams_pub.stmv_tbl_type;

8306: l_mapped_sty_name VARCHAR2(150);
8307:
8308: l_selv_tbl okl_streams_pub.selv_tbl_type;
8309: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
8310: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
8311: lx_selv_tbl okl_streams_pub.selv_tbl_type;
8312:
8313: l_stmv_rec okl_streams_pub.stmv_rec_type;
8314: lx_stmv_rec okl_streams_pub.stmv_rec_type;

Line 8311: lx_selv_tbl okl_streams_pub.selv_tbl_type;

8307:
8308: l_selv_tbl okl_streams_pub.selv_tbl_type;
8309: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
8310: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
8311: lx_selv_tbl okl_streams_pub.selv_tbl_type;
8312:
8313: l_stmv_rec okl_streams_pub.stmv_rec_type;
8314: lx_stmv_rec okl_streams_pub.stmv_rec_type;
8315:

Line 8313: l_stmv_rec okl_streams_pub.stmv_rec_type;

8309: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
8310: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
8311: lx_selv_tbl okl_streams_pub.selv_tbl_type;
8312:
8313: l_stmv_rec okl_streams_pub.stmv_rec_type;
8314: lx_stmv_rec okl_streams_pub.stmv_rec_type;
8315:
8316: cursor l_hdrrl_csr IS
8317: select crl.RULE_INFORMATION1 method

Line 8314: lx_stmv_rec okl_streams_pub.stmv_rec_type;

8310: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
8311: lx_selv_tbl okl_streams_pub.selv_tbl_type;
8312:
8313: l_stmv_rec okl_streams_pub.stmv_rec_type;
8314: lx_stmv_rec okl_streams_pub.stmv_rec_type;
8315:
8316: cursor l_hdrrl_csr IS
8317: select crl.RULE_INFORMATION1 method
8318: from OKC_RULE_GROUPS_B crg,

Line 8841: x_stmv_rec OUT NOCOPY okl_streams_pub.stmv_rec_type,

8837: p_kle_id IN NUMBER,
8838: p_sty_id IN NUMBER,
8839: --sosharma added, bug 6691554
8840: p_mode IN VARCHAR2,
8841: x_stmv_rec OUT NOCOPY okl_streams_pub.stmv_rec_type,
8842: x_selv_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
8843: x_return_status OUT NOCOPY VARCHAR2,
8844: x_msg_count OUT NOCOPY NUMBER,
8845: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 8842: x_selv_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,

8838: p_sty_id IN NUMBER,
8839: --sosharma added, bug 6691554
8840: p_mode IN VARCHAR2,
8841: x_stmv_rec OUT NOCOPY okl_streams_pub.stmv_rec_type,
8842: x_selv_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
8843: x_return_status OUT NOCOPY VARCHAR2,
8844: x_msg_count OUT NOCOPY NUMBER,
8845: x_msg_data OUT NOCOPY VARCHAR2) IS
8846:

Line 8975: l_selv_tbl okl_streams_pub.selv_tbl_type;

8971: l_sty_id NUMBER;
8972: l_sty_name VARCHAR2(150);
8973: l_mapped_sty_name VARCHAR2(150);
8974:
8975: l_selv_tbl okl_streams_pub.selv_tbl_type;
8976: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
8977: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
8978: lx_selv_tbl okl_streams_pub.selv_tbl_type;
8979:

Line 8976: l_stmv_tbl okl_streams_pub.stmv_tbl_type;

8972: l_sty_name VARCHAR2(150);
8973: l_mapped_sty_name VARCHAR2(150);
8974:
8975: l_selv_tbl okl_streams_pub.selv_tbl_type;
8976: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
8977: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
8978: lx_selv_tbl okl_streams_pub.selv_tbl_type;
8979:
8980: l_stmv_rec okl_streams_pub.stmv_rec_type;

Line 8977: x_stmv_tbl okl_streams_pub.stmv_tbl_type;

8973: l_mapped_sty_name VARCHAR2(150);
8974:
8975: l_selv_tbl okl_streams_pub.selv_tbl_type;
8976: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
8977: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
8978: lx_selv_tbl okl_streams_pub.selv_tbl_type;
8979:
8980: l_stmv_rec okl_streams_pub.stmv_rec_type;
8981: lx_stmv_rec okl_streams_pub.stmv_rec_type;

Line 8978: lx_selv_tbl okl_streams_pub.selv_tbl_type;

8974:
8975: l_selv_tbl okl_streams_pub.selv_tbl_type;
8976: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
8977: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
8978: lx_selv_tbl okl_streams_pub.selv_tbl_type;
8979:
8980: l_stmv_rec okl_streams_pub.stmv_rec_type;
8981: lx_stmv_rec okl_streams_pub.stmv_rec_type;
8982:

Line 8980: l_stmv_rec okl_streams_pub.stmv_rec_type;

8976: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
8977: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
8978: lx_selv_tbl okl_streams_pub.selv_tbl_type;
8979:
8980: l_stmv_rec okl_streams_pub.stmv_rec_type;
8981: lx_stmv_rec okl_streams_pub.stmv_rec_type;
8982:
8983: cursor l_hdrrl_csr IS
8984: select crl.RULE_INFORMATION1 method

Line 8981: lx_stmv_rec okl_streams_pub.stmv_rec_type;

8977: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
8978: lx_selv_tbl okl_streams_pub.selv_tbl_type;
8979:
8980: l_stmv_rec okl_streams_pub.stmv_rec_type;
8981: lx_stmv_rec okl_streams_pub.stmv_rec_type;
8982:
8983: cursor l_hdrrl_csr IS
8984: select crl.RULE_INFORMATION1 method
8985: from OKC_RULE_GROUPS_B crg,

Line 9549: l_selv_tbl okl_streams_pub.selv_tbl_type;

9545: sec_strms_rec sec_strms_csr%ROWTYPE;
9546:
9547: l_sty_id NUMBER;
9548:
9549: l_selv_tbl okl_streams_pub.selv_tbl_type;
9550: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
9551: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
9552: lx_selv_tbl okl_streams_pub.selv_tbl_type;
9553:

Line 9550: l_stmv_tbl okl_streams_pub.stmv_tbl_type;

9546:
9547: l_sty_id NUMBER;
9548:
9549: l_selv_tbl okl_streams_pub.selv_tbl_type;
9550: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
9551: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
9552: lx_selv_tbl okl_streams_pub.selv_tbl_type;
9553:
9554: l_stmv_rec okl_streams_pub.stmv_rec_type;

Line 9551: x_stmv_tbl okl_streams_pub.stmv_tbl_type;

9547: l_sty_id NUMBER;
9548:
9549: l_selv_tbl okl_streams_pub.selv_tbl_type;
9550: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
9551: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
9552: lx_selv_tbl okl_streams_pub.selv_tbl_type;
9553:
9554: l_stmv_rec okl_streams_pub.stmv_rec_type;
9555: lx_stmv_rec okl_streams_pub.stmv_rec_type;

Line 9552: lx_selv_tbl okl_streams_pub.selv_tbl_type;

9548:
9549: l_selv_tbl okl_streams_pub.selv_tbl_type;
9550: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
9551: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
9552: lx_selv_tbl okl_streams_pub.selv_tbl_type;
9553:
9554: l_stmv_rec okl_streams_pub.stmv_rec_type;
9555: lx_stmv_rec okl_streams_pub.stmv_rec_type;
9556:

Line 9554: l_stmv_rec okl_streams_pub.stmv_rec_type;

9550: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
9551: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
9552: lx_selv_tbl okl_streams_pub.selv_tbl_type;
9553:
9554: l_stmv_rec okl_streams_pub.stmv_rec_type;
9555: lx_stmv_rec okl_streams_pub.stmv_rec_type;
9556:
9557: i NUMBER;
9558: n NUMBER;

Line 9555: lx_stmv_rec okl_streams_pub.stmv_rec_type;

9551: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
9552: lx_selv_tbl okl_streams_pub.selv_tbl_type;
9553:
9554: l_stmv_rec okl_streams_pub.stmv_rec_type;
9555: lx_stmv_rec okl_streams_pub.stmv_rec_type;
9556:
9557: i NUMBER;
9558: n NUMBER;
9559:

Line 9638: Okl_Streams_pub.update_streams(

9634: END LOOP;
9635:
9636: If ( l_stmv_tbl.COUNT > 0 ) Then
9637:
9638: Okl_Streams_pub.update_streams(
9639: p_api_version => p_api_version,
9640: p_init_msg_list => p_init_msg_list,
9641: x_return_status => x_return_status,
9642: x_msg_count => x_msg_count,

Line 9692: Okl_Streams_pub.update_streams(

9688: END LOOP;
9689:
9690: If ( l_stmv_tbl.COUNT > 0 ) Then
9691:
9692: Okl_Streams_pub.update_streams(
9693: p_api_version => p_api_version,
9694: p_init_msg_list => p_init_msg_list,
9695: x_return_status => x_return_status,
9696: x_msg_count => x_msg_count,

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

9764:
9765: l_selv_tbl.DELETE;
9766: l_selv_tbl := lx_selv_tbl;
9767:
9768: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,
9769: p_init_msg_list => G_FALSE,
9770: x_return_status => x_return_status,
9771: x_msg_count => x_msg_count,
9772: x_msg_data => x_msg_data,

Line 9828: Okl_Streams_pub.update_streams(

9824: END LOOP;
9825:
9826: If ( l_stmv_tbl.COUNT > 0 ) Then
9827:
9828: Okl_Streams_pub.update_streams(
9829: p_api_version => p_api_version,
9830: p_init_msg_list => p_init_msg_list,
9831: x_return_status => x_return_status,
9832: x_msg_count => x_msg_count,

Line 9881: Okl_Streams_pub.update_streams(

9877: END LOOP;
9878:
9879: If ( l_stmv_tbl.COUNT > 0 ) Then
9880:
9881: Okl_Streams_pub.update_streams(
9882: p_api_version => p_api_version,
9883: p_init_msg_list => p_init_msg_list,
9884: x_return_status => x_return_status,
9885: x_msg_count => x_msg_count,

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

9953:
9954: l_selv_tbl.DELETE;
9955: l_selv_tbl := lx_selv_tbl;
9956:
9957: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,
9958: p_init_msg_list => G_FALSE,
9959: x_return_status => x_return_status,
9960: x_msg_count => x_msg_count,
9961: x_msg_data => x_msg_data,

Line 10146: l_selv_tbl okl_streams_pub.selv_tbl_type;

10142: sec_strms_rec sec_strms_csr%ROWTYPE;
10143:
10144: l_sty_id NUMBER;
10145:
10146: l_selv_tbl okl_streams_pub.selv_tbl_type;
10147: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
10148: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
10149: lx_selv_tbl okl_streams_pub.selv_tbl_type;
10150:

Line 10147: l_stmv_tbl okl_streams_pub.stmv_tbl_type;

10143:
10144: l_sty_id NUMBER;
10145:
10146: l_selv_tbl okl_streams_pub.selv_tbl_type;
10147: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
10148: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
10149: lx_selv_tbl okl_streams_pub.selv_tbl_type;
10150:
10151: l_stmv_rec okl_streams_pub.stmv_rec_type;

Line 10148: x_stmv_tbl okl_streams_pub.stmv_tbl_type;

10144: l_sty_id NUMBER;
10145:
10146: l_selv_tbl okl_streams_pub.selv_tbl_type;
10147: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
10148: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
10149: lx_selv_tbl okl_streams_pub.selv_tbl_type;
10150:
10151: l_stmv_rec okl_streams_pub.stmv_rec_type;
10152: lx_stmv_rec okl_streams_pub.stmv_rec_type;

Line 10149: lx_selv_tbl okl_streams_pub.selv_tbl_type;

10145:
10146: l_selv_tbl okl_streams_pub.selv_tbl_type;
10147: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
10148: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
10149: lx_selv_tbl okl_streams_pub.selv_tbl_type;
10150:
10151: l_stmv_rec okl_streams_pub.stmv_rec_type;
10152: lx_stmv_rec okl_streams_pub.stmv_rec_type;
10153:

Line 10151: l_stmv_rec okl_streams_pub.stmv_rec_type;

10147: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
10148: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
10149: lx_selv_tbl okl_streams_pub.selv_tbl_type;
10150:
10151: l_stmv_rec okl_streams_pub.stmv_rec_type;
10152: lx_stmv_rec okl_streams_pub.stmv_rec_type;
10153:
10154: i NUMBER;
10155: n NUMBER;

Line 10152: lx_stmv_rec okl_streams_pub.stmv_rec_type;

10148: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
10149: lx_selv_tbl okl_streams_pub.selv_tbl_type;
10150:
10151: l_stmv_rec okl_streams_pub.stmv_rec_type;
10152: lx_stmv_rec okl_streams_pub.stmv_rec_type;
10153:
10154: i NUMBER;
10155: n NUMBER;
10156:

Line 10240: Okl_Streams_pub.update_streams(

10236: END LOOP;
10237:
10238: If ( l_stmv_tbl.COUNT > 0 ) Then
10239:
10240: Okl_Streams_pub.update_streams(
10241: p_api_version => p_api_version,
10242: p_init_msg_list => p_init_msg_list,
10243: x_return_status => x_return_status,
10244: x_msg_count => x_msg_count,

Line 10294: Okl_Streams_pub.update_streams(

10290: END LOOP;
10291:
10292: If ( l_stmv_tbl.COUNT > 0 ) Then
10293:
10294: Okl_Streams_pub.update_streams(
10295: p_api_version => p_api_version,
10296: p_init_msg_list => p_init_msg_list,
10297: x_return_status => x_return_status,
10298: x_msg_count => x_msg_count,

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

10367:
10368: l_selv_tbl.DELETE;
10369: l_selv_tbl := lx_selv_tbl;
10370:
10371: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,
10372: p_init_msg_list => G_FALSE,
10373: x_return_status => x_return_status,
10374: x_msg_count => x_msg_count,
10375: x_msg_data => x_msg_data,

Line 10431: Okl_Streams_pub.update_streams(

10427: END LOOP;
10428:
10429: If ( l_stmv_tbl.COUNT > 0 ) Then
10430:
10431: Okl_Streams_pub.update_streams(
10432: p_api_version => p_api_version,
10433: p_init_msg_list => p_init_msg_list,
10434: x_return_status => x_return_status,
10435: x_msg_count => x_msg_count,

Line 10485: Okl_Streams_pub.update_streams(

10481: END LOOP;
10482:
10483: If ( l_stmv_tbl.COUNT > 0 ) Then
10484:
10485: Okl_Streams_pub.update_streams(
10486: p_api_version => p_api_version,
10487: p_init_msg_list => p_init_msg_list,
10488: x_return_status => x_return_status,
10489: x_msg_count => x_msg_count,

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

10560:
10561: l_selv_tbl.DELETE;
10562: l_selv_tbl := lx_selv_tbl;
10563:
10564: okl_streams_pub.create_streams(p_api_version => G_API_VERSION,
10565: p_init_msg_list => G_FALSE,
10566: x_return_status => x_return_status,
10567: x_msg_count => x_msg_count,
10568: x_msg_data => x_msg_data,

Line 11382: l_selv_tbl okl_streams_pub.selv_tbl_type;

11378: l_sty_id NUMBER;
11379: l_sty_name VARCHAR2(150);
11380: l_mapped_sty_name VARCHAR2(150);
11381:
11382: l_selv_tbl okl_streams_pub.selv_tbl_type;
11383: l_pt_tbl okl_streams_pub.selv_tbl_type;
11384: lx_selv_tbl okl_streams_pub.selv_tbl_type;
11385:
11386: l_stmv_rec okl_streams_pub.stmv_rec_type;

Line 11383: l_pt_tbl okl_streams_pub.selv_tbl_type;

11379: l_sty_name VARCHAR2(150);
11380: l_mapped_sty_name VARCHAR2(150);
11381:
11382: l_selv_tbl okl_streams_pub.selv_tbl_type;
11383: l_pt_tbl okl_streams_pub.selv_tbl_type;
11384: lx_selv_tbl okl_streams_pub.selv_tbl_type;
11385:
11386: l_stmv_rec okl_streams_pub.stmv_rec_type;
11387: l_stmv_tbl okl_streams_pub.stmv_tbl_type;

Line 11384: lx_selv_tbl okl_streams_pub.selv_tbl_type;

11380: l_mapped_sty_name VARCHAR2(150);
11381:
11382: l_selv_tbl okl_streams_pub.selv_tbl_type;
11383: l_pt_tbl okl_streams_pub.selv_tbl_type;
11384: lx_selv_tbl okl_streams_pub.selv_tbl_type;
11385:
11386: l_stmv_rec okl_streams_pub.stmv_rec_type;
11387: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
11388: lx_stmv_tbl okl_streams_pub.stmv_tbl_type;

Line 11386: l_stmv_rec okl_streams_pub.stmv_rec_type;

11382: l_selv_tbl okl_streams_pub.selv_tbl_type;
11383: l_pt_tbl okl_streams_pub.selv_tbl_type;
11384: lx_selv_tbl okl_streams_pub.selv_tbl_type;
11385:
11386: l_stmv_rec okl_streams_pub.stmv_rec_type;
11387: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
11388: lx_stmv_tbl okl_streams_pub.stmv_tbl_type;
11389: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
11390: l_pt_rec okl_streams_pub.stmv_rec_type;

Line 11387: l_stmv_tbl okl_streams_pub.stmv_tbl_type;

11383: l_pt_tbl okl_streams_pub.selv_tbl_type;
11384: lx_selv_tbl okl_streams_pub.selv_tbl_type;
11385:
11386: l_stmv_rec okl_streams_pub.stmv_rec_type;
11387: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
11388: lx_stmv_tbl okl_streams_pub.stmv_tbl_type;
11389: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
11390: l_pt_rec okl_streams_pub.stmv_rec_type;
11391: lx_stmv_rec okl_streams_pub.stmv_rec_type;

Line 11388: lx_stmv_tbl okl_streams_pub.stmv_tbl_type;

11384: lx_selv_tbl okl_streams_pub.selv_tbl_type;
11385:
11386: l_stmv_rec okl_streams_pub.stmv_rec_type;
11387: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
11388: lx_stmv_tbl okl_streams_pub.stmv_tbl_type;
11389: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
11390: l_pt_rec okl_streams_pub.stmv_rec_type;
11391: lx_stmv_rec okl_streams_pub.stmv_rec_type;
11392:

Line 11389: x_stmv_tbl okl_streams_pub.stmv_tbl_type;

11385:
11386: l_stmv_rec okl_streams_pub.stmv_rec_type;
11387: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
11388: lx_stmv_tbl okl_streams_pub.stmv_tbl_type;
11389: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
11390: l_pt_rec okl_streams_pub.stmv_rec_type;
11391: lx_stmv_rec okl_streams_pub.stmv_rec_type;
11392:
11393: i BINARY_INTEGER := 0;

Line 11390: l_pt_rec okl_streams_pub.stmv_rec_type;

11386: l_stmv_rec okl_streams_pub.stmv_rec_type;
11387: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
11388: lx_stmv_tbl okl_streams_pub.stmv_tbl_type;
11389: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
11390: l_pt_rec okl_streams_pub.stmv_rec_type;
11391: lx_stmv_rec okl_streams_pub.stmv_rec_type;
11392:
11393: i BINARY_INTEGER := 0;
11394:

Line 11391: lx_stmv_rec okl_streams_pub.stmv_rec_type;

11387: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
11388: lx_stmv_tbl okl_streams_pub.stmv_tbl_type;
11389: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
11390: l_pt_rec okl_streams_pub.stmv_rec_type;
11391: lx_stmv_rec okl_streams_pub.stmv_rec_type;
11392:
11393: i BINARY_INTEGER := 0;
11394:
11395: l_api_name CONSTANT VARCHAR2(61) := 'GET_NEXT_BILL_DATE';

Line 11641: l_pt_tbl okl_streams_pub.selv_tbl_type;

11637: l_old_cle_id NUMBER;
11638: l_old_sty_id NUMBER;
11639: l_purpose_code VARCHAR2(30);
11640:
11641: l_pt_tbl okl_streams_pub.selv_tbl_type;
11642: l_pt_pro_fee_tbl okl_streams_pub.selv_tbl_type;
11643:
11644: l_selv_tbl okl_streams_pub.selv_tbl_type;
11645: lx_selv_tbl okl_streams_pub.selv_tbl_type;

Line 11642: l_pt_pro_fee_tbl okl_streams_pub.selv_tbl_type;

11638: l_old_sty_id NUMBER;
11639: l_purpose_code VARCHAR2(30);
11640:
11641: l_pt_tbl okl_streams_pub.selv_tbl_type;
11642: l_pt_pro_fee_tbl okl_streams_pub.selv_tbl_type;
11643:
11644: l_selv_tbl okl_streams_pub.selv_tbl_type;
11645: lx_selv_tbl okl_streams_pub.selv_tbl_type;
11646:

Line 11644: l_selv_tbl okl_streams_pub.selv_tbl_type;

11640:
11641: l_pt_tbl okl_streams_pub.selv_tbl_type;
11642: l_pt_pro_fee_tbl okl_streams_pub.selv_tbl_type;
11643:
11644: l_selv_tbl okl_streams_pub.selv_tbl_type;
11645: lx_selv_tbl okl_streams_pub.selv_tbl_type;
11646:
11647: l_stmv_rec okl_streams_pub.stmv_rec_type;
11648: l_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;

Line 11645: lx_selv_tbl okl_streams_pub.selv_tbl_type;

11641: l_pt_tbl okl_streams_pub.selv_tbl_type;
11642: l_pt_pro_fee_tbl okl_streams_pub.selv_tbl_type;
11643:
11644: l_selv_tbl okl_streams_pub.selv_tbl_type;
11645: lx_selv_tbl okl_streams_pub.selv_tbl_type;
11646:
11647: l_stmv_rec okl_streams_pub.stmv_rec_type;
11648: l_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
11649: lx_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;

Line 11647: l_stmv_rec okl_streams_pub.stmv_rec_type;

11643:
11644: l_selv_tbl okl_streams_pub.selv_tbl_type;
11645: lx_selv_tbl okl_streams_pub.selv_tbl_type;
11646:
11647: l_stmv_rec okl_streams_pub.stmv_rec_type;
11648: l_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
11649: lx_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
11650:
11651: l_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;

Line 11648: l_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;

11644: l_selv_tbl okl_streams_pub.selv_tbl_type;
11645: lx_selv_tbl okl_streams_pub.selv_tbl_type;
11646:
11647: l_stmv_rec okl_streams_pub.stmv_rec_type;
11648: l_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
11649: lx_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
11650:
11651: l_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
11652: lx_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;

Line 11649: lx_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;

11645: lx_selv_tbl okl_streams_pub.selv_tbl_type;
11646:
11647: l_stmv_rec okl_streams_pub.stmv_rec_type;
11648: l_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
11649: lx_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
11650:
11651: l_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
11652: lx_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
11653:

Line 11651: l_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;

11647: l_stmv_rec okl_streams_pub.stmv_rec_type;
11648: l_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
11649: lx_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
11650:
11651: l_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
11652: lx_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
11653:
11654: l_prog_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'gen_cash_flows_for_IA';
11655:

Line 11652: lx_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;

11648: l_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
11649: lx_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
11650:
11651: l_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
11652: lx_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
11653:
11654: l_prog_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'gen_cash_flows_for_IA';
11655:
11656: BEGIN

Line 11772: Okl_Streams_Pub.create_streams_perf( p_api_version,

11768:
11769: END LOOP;
11770:
11771: --Create all the accumulated Streams at one shot ..
11772: Okl_Streams_Pub.create_streams_perf( p_api_version,
11773: p_init_msg_list,
11774: x_return_status,
11775: x_msg_count,
11776: x_msg_data,

Line 11876: l_selv_tbl okl_streams_pub.selv_tbl_type;

11872: l_pdt_id okl_products.id%type;
11873: l_currency_code okc_k_headers_all_b.currency_code%type;
11874: l_purpose_code VARCHAR2(30) := '-99';
11875:
11876: l_selv_tbl okl_streams_pub.selv_tbl_type;
11877: lx_selv_tbl okl_streams_pub.selv_tbl_type;
11878: l_full_selv_tbl okl_streams_pub.selv_tbl_type;
11879: lx_full_selv_tbl okl_streams_pub.selv_tbl_type;
11880:

Line 11877: lx_selv_tbl okl_streams_pub.selv_tbl_type;

11873: l_currency_code okc_k_headers_all_b.currency_code%type;
11874: l_purpose_code VARCHAR2(30) := '-99';
11875:
11876: l_selv_tbl okl_streams_pub.selv_tbl_type;
11877: lx_selv_tbl okl_streams_pub.selv_tbl_type;
11878: l_full_selv_tbl okl_streams_pub.selv_tbl_type;
11879: lx_full_selv_tbl okl_streams_pub.selv_tbl_type;
11880:
11881: l_stmv_rec okl_streams_pub.stmv_rec_type;

Line 11878: l_full_selv_tbl okl_streams_pub.selv_tbl_type;

11874: l_purpose_code VARCHAR2(30) := '-99';
11875:
11876: l_selv_tbl okl_streams_pub.selv_tbl_type;
11877: lx_selv_tbl okl_streams_pub.selv_tbl_type;
11878: l_full_selv_tbl okl_streams_pub.selv_tbl_type;
11879: lx_full_selv_tbl okl_streams_pub.selv_tbl_type;
11880:
11881: l_stmv_rec okl_streams_pub.stmv_rec_type;
11882: l_stmv_tbl okl_Streams_Pub.stmv_tbl_type;

Line 11879: lx_full_selv_tbl okl_streams_pub.selv_tbl_type;

11875:
11876: l_selv_tbl okl_streams_pub.selv_tbl_type;
11877: lx_selv_tbl okl_streams_pub.selv_tbl_type;
11878: l_full_selv_tbl okl_streams_pub.selv_tbl_type;
11879: lx_full_selv_tbl okl_streams_pub.selv_tbl_type;
11880:
11881: l_stmv_rec okl_streams_pub.stmv_rec_type;
11882: l_stmv_tbl okl_Streams_Pub.stmv_tbl_type;
11883: lx_stmv_tbl okl_Streams_Pub.stmv_tbl_type;

Line 11881: l_stmv_rec okl_streams_pub.stmv_rec_type;

11877: lx_selv_tbl okl_streams_pub.selv_tbl_type;
11878: l_full_selv_tbl okl_streams_pub.selv_tbl_type;
11879: lx_full_selv_tbl okl_streams_pub.selv_tbl_type;
11880:
11881: l_stmv_rec okl_streams_pub.stmv_rec_type;
11882: l_stmv_tbl okl_Streams_Pub.stmv_tbl_type;
11883: lx_stmv_tbl okl_Streams_Pub.stmv_tbl_type;
11884:
11885: l_prog_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'gen_income_accruals_for_IA';

Line 11882: l_stmv_tbl okl_Streams_Pub.stmv_tbl_type;

11878: l_full_selv_tbl okl_streams_pub.selv_tbl_type;
11879: lx_full_selv_tbl okl_streams_pub.selv_tbl_type;
11880:
11881: l_stmv_rec okl_streams_pub.stmv_rec_type;
11882: l_stmv_tbl okl_Streams_Pub.stmv_tbl_type;
11883: lx_stmv_tbl okl_Streams_Pub.stmv_tbl_type;
11884:
11885: l_prog_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'gen_income_accruals_for_IA';
11886:

Line 11883: lx_stmv_tbl okl_Streams_Pub.stmv_tbl_type;

11879: lx_full_selv_tbl okl_streams_pub.selv_tbl_type;
11880:
11881: l_stmv_rec okl_streams_pub.stmv_rec_type;
11882: l_stmv_tbl okl_Streams_Pub.stmv_tbl_type;
11883: lx_stmv_tbl okl_Streams_Pub.stmv_tbl_type;
11884:
11885: l_prog_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'gen_income_accruals_for_IA';
11886:
11887: BEGIN

Line 12031: Okl_Streams_Pub.create_streams_perf(

12027: --Create all the accumulated Streams at one shot ..
12028: IF l_stmv_tbl.COUNT > 0 AND
12029: l_full_selv_tbl.COUNT > 0
12030: THEN
12031: Okl_Streams_Pub.create_streams_perf(
12032: p_api_version,
12033: p_init_msg_list,
12034: x_return_status,
12035: x_msg_count,