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_UTIL

Line 1010: lx_return_status := Okl_Streams_Util.round_streams_amount(

1006: RAISE OKL_API.G_EXCEPTION_ERROR;
1007: END IF;
1008:
1009:
1010: lx_return_status := Okl_Streams_Util.round_streams_amount(
1011: p_api_version => g_api_version,
1012: p_init_msg_list => p_init_msg_list,
1013: x_msg_count => x_msg_count,
1014: x_msg_data => x_msg_data,

Line 1169: lx_return_status := Okl_Streams_Util.round_streams_amount(

1165: l_stmv_rec.say_code := 'CURR';
1166: l_stmv_rec.active_yn := 'Y';
1167: l_stmv_rec.date_current := SYSDATE;
1168:
1169: lx_return_status := Okl_Streams_Util.round_streams_amount(
1170: p_api_version => g_api_version,
1171: p_init_msg_list => p_init_msg_list,
1172: x_msg_count => x_msg_count,
1173: x_msg_data => x_msg_data,

Line 1225: lx_return_status := Okl_Streams_Util.round_streams_amount(

1221: l_stmv_rec.say_code := 'CURR';
1222: l_stmv_rec.active_yn := 'Y';
1223: l_stmv_rec.date_current := SYSDATE;
1224:
1225: lx_return_status := Okl_Streams_Util.round_streams_amount(
1226: p_api_version => g_api_version,
1227: p_init_msg_list => p_init_msg_list,
1228: x_msg_count => x_msg_count,
1229: x_msg_data => x_msg_data,

Line 1281: lx_return_status := Okl_Streams_Util.round_streams_amount(

1277: l_stmv_rec.say_code := 'CURR';
1278: l_stmv_rec.active_yn := 'Y';
1279: l_stmv_rec.date_current := SYSDATE;
1280:
1281: lx_return_status := Okl_Streams_Util.round_streams_amount(
1282: p_api_version => g_api_version,
1283: p_init_msg_list => p_init_msg_list,
1284: x_msg_count => x_msg_count,
1285: x_msg_data => x_msg_data,

Line 1337: lx_return_status := Okl_Streams_Util.round_streams_amount(

1333: l_stmv_rec.say_code := 'CURR';
1334: l_stmv_rec.active_yn := 'Y';
1335: l_stmv_rec.date_current := SYSDATE;
1336:
1337: lx_return_status := Okl_Streams_Util.round_streams_amount(
1338: p_api_version => g_api_version,
1339: p_init_msg_list => p_init_msg_list,
1340: x_msg_count => x_msg_count,
1341: x_msg_data => x_msg_data,

Line 1393: lx_return_status := Okl_Streams_Util.round_streams_amount(

1389: l_stmv_rec.active_yn := 'Y';
1390: l_stmv_rec.date_current := SYSDATE;
1391:
1392:
1393: lx_return_status := Okl_Streams_Util.round_streams_amount(
1394: p_api_version => g_api_version,
1395: p_init_msg_list => p_init_msg_list,
1396: x_msg_count => x_msg_count,
1397: x_msg_data => x_msg_data,

Line 3824: eleid_tbl Okl_Streams_Util.NumberTabTyp;

3820: l_line_num NUMBER;
3821: n NUMBER := 0;
3822:
3823: -- Added by RGOOTY
3824: eleid_tbl Okl_Streams_Util.NumberTabTyp;
3825: streamid_tbl Okl_Streams_Util.NumberTabTyp;
3826: sel_date Okl_Streams_Util.DateTabTyp;
3827:
3828: lom_date DATE;

Line 3825: streamid_tbl Okl_Streams_Util.NumberTabTyp;

3821: n NUMBER := 0;
3822:
3823: -- Added by RGOOTY
3824: eleid_tbl Okl_Streams_Util.NumberTabTyp;
3825: streamid_tbl Okl_Streams_Util.NumberTabTyp;
3826: sel_date Okl_Streams_Util.DateTabTyp;
3827:
3828: lom_date DATE;
3829: i NUMBER;

Line 3826: sel_date Okl_Streams_Util.DateTabTyp;

3822:
3823: -- Added by RGOOTY
3824: eleid_tbl Okl_Streams_Util.NumberTabTyp;
3825: streamid_tbl Okl_Streams_Util.NumberTabTyp;
3826: sel_date Okl_Streams_Util.DateTabTyp;
3827:
3828: lom_date DATE;
3829: i NUMBER;
3830: -- Added by RGOOTY: 4403311

Line 3837: l_ele_id_all_tbl Okl_Streams_Util.NumberTabTyp;

3833: j NUMBER;
3834: r NUMBER;
3835:
3836:
3837: l_ele_id_all_tbl Okl_Streams_Util.NumberTabTyp;
3838: l_streamid_all_tbl Okl_Streams_Util.NumberTabTyp;
3839: l_sel_date_all_tbl Okl_Streams_Util.DateTabTyp;
3840: l_kle_id_all_tbl Okl_Streams_Util.NumberTabTyp;
3841: l_amt_all_tbl Okl_Streams_Util.NumberTabTyp;

Line 3838: l_streamid_all_tbl Okl_Streams_Util.NumberTabTyp;

3834: r NUMBER;
3835:
3836:
3837: l_ele_id_all_tbl Okl_Streams_Util.NumberTabTyp;
3838: l_streamid_all_tbl Okl_Streams_Util.NumberTabTyp;
3839: l_sel_date_all_tbl Okl_Streams_Util.DateTabTyp;
3840: l_kle_id_all_tbl Okl_Streams_Util.NumberTabTyp;
3841: l_amt_all_tbl Okl_Streams_Util.NumberTabTyp;
3842: l_stm_purpose_all_tbl Okl_Streams_Util.Var150TabTyp;

Line 3839: l_sel_date_all_tbl Okl_Streams_Util.DateTabTyp;

3835:
3836:
3837: l_ele_id_all_tbl Okl_Streams_Util.NumberTabTyp;
3838: l_streamid_all_tbl Okl_Streams_Util.NumberTabTyp;
3839: l_sel_date_all_tbl Okl_Streams_Util.DateTabTyp;
3840: l_kle_id_all_tbl Okl_Streams_Util.NumberTabTyp;
3841: l_amt_all_tbl Okl_Streams_Util.NumberTabTyp;
3842: l_stm_purpose_all_tbl Okl_Streams_Util.Var150TabTyp;
3843:

Line 3840: l_kle_id_all_tbl Okl_Streams_Util.NumberTabTyp;

3836:
3837: l_ele_id_all_tbl Okl_Streams_Util.NumberTabTyp;
3838: l_streamid_all_tbl Okl_Streams_Util.NumberTabTyp;
3839: l_sel_date_all_tbl Okl_Streams_Util.DateTabTyp;
3840: l_kle_id_all_tbl Okl_Streams_Util.NumberTabTyp;
3841: l_amt_all_tbl Okl_Streams_Util.NumberTabTyp;
3842: l_stm_purpose_all_tbl Okl_Streams_Util.Var150TabTyp;
3843:
3844: --Added by dpsingh for bug 5503678

Line 3841: l_amt_all_tbl Okl_Streams_Util.NumberTabTyp;

3837: l_ele_id_all_tbl Okl_Streams_Util.NumberTabTyp;
3838: l_streamid_all_tbl Okl_Streams_Util.NumberTabTyp;
3839: l_sel_date_all_tbl Okl_Streams_Util.DateTabTyp;
3840: l_kle_id_all_tbl Okl_Streams_Util.NumberTabTyp;
3841: l_amt_all_tbl Okl_Streams_Util.NumberTabTyp;
3842: l_stm_purpose_all_tbl Okl_Streams_Util.Var150TabTyp;
3843:
3844: --Added by dpsingh for bug 5503678
3845: l_sty_id_all_tbl Okl_Streams_Util.NumberTabTyp;

Line 3842: l_stm_purpose_all_tbl Okl_Streams_Util.Var150TabTyp;

3838: l_streamid_all_tbl Okl_Streams_Util.NumberTabTyp;
3839: l_sel_date_all_tbl Okl_Streams_Util.DateTabTyp;
3840: l_kle_id_all_tbl Okl_Streams_Util.NumberTabTyp;
3841: l_amt_all_tbl Okl_Streams_Util.NumberTabTyp;
3842: l_stm_purpose_all_tbl Okl_Streams_Util.Var150TabTyp;
3843:
3844: --Added by dpsingh for bug 5503678
3845: l_sty_id_all_tbl Okl_Streams_Util.NumberTabTyp;
3846:

Line 3845: l_sty_id_all_tbl Okl_Streams_Util.NumberTabTyp;

3841: l_amt_all_tbl Okl_Streams_Util.NumberTabTyp;
3842: l_stm_purpose_all_tbl Okl_Streams_Util.Var150TabTyp;
3843:
3844: --Added by dpsingh for bug 5503678
3845: l_sty_id_all_tbl Okl_Streams_Util.NumberTabTyp;
3846:
3847: l_ele_id_mod_tbl Okl_Streams_Util.NumberTabTyp;
3848: l_streamid_mod_tbl Okl_Streams_Util.NumberTabTyp;
3849: l_sel_date_mod_tbl Okl_Streams_Util.DateTabTyp;

Line 3847: l_ele_id_mod_tbl Okl_Streams_Util.NumberTabTyp;

3843:
3844: --Added by dpsingh for bug 5503678
3845: l_sty_id_all_tbl Okl_Streams_Util.NumberTabTyp;
3846:
3847: l_ele_id_mod_tbl Okl_Streams_Util.NumberTabTyp;
3848: l_streamid_mod_tbl Okl_Streams_Util.NumberTabTyp;
3849: l_sel_date_mod_tbl Okl_Streams_Util.DateTabTyp;
3850: l_kle_id_mod_tbl Okl_Streams_Util.NumberTabTyp;
3851: l_amt_mod_tbl Okl_Streams_Util.NumberTabTyp;

Line 3848: l_streamid_mod_tbl Okl_Streams_Util.NumberTabTyp;

3844: --Added by dpsingh for bug 5503678
3845: l_sty_id_all_tbl Okl_Streams_Util.NumberTabTyp;
3846:
3847: l_ele_id_mod_tbl Okl_Streams_Util.NumberTabTyp;
3848: l_streamid_mod_tbl Okl_Streams_Util.NumberTabTyp;
3849: l_sel_date_mod_tbl Okl_Streams_Util.DateTabTyp;
3850: l_kle_id_mod_tbl Okl_Streams_Util.NumberTabTyp;
3851: l_amt_mod_tbl Okl_Streams_Util.NumberTabTyp;
3852: l_stm_purpose_mod_tbl Okl_Streams_Util.Var150TabTyp;

Line 3849: l_sel_date_mod_tbl Okl_Streams_Util.DateTabTyp;

3845: l_sty_id_all_tbl Okl_Streams_Util.NumberTabTyp;
3846:
3847: l_ele_id_mod_tbl Okl_Streams_Util.NumberTabTyp;
3848: l_streamid_mod_tbl Okl_Streams_Util.NumberTabTyp;
3849: l_sel_date_mod_tbl Okl_Streams_Util.DateTabTyp;
3850: l_kle_id_mod_tbl Okl_Streams_Util.NumberTabTyp;
3851: l_amt_mod_tbl Okl_Streams_Util.NumberTabTyp;
3852: l_stm_purpose_mod_tbl Okl_Streams_Util.Var150TabTyp;
3853:

Line 3850: l_kle_id_mod_tbl Okl_Streams_Util.NumberTabTyp;

3846:
3847: l_ele_id_mod_tbl Okl_Streams_Util.NumberTabTyp;
3848: l_streamid_mod_tbl Okl_Streams_Util.NumberTabTyp;
3849: l_sel_date_mod_tbl Okl_Streams_Util.DateTabTyp;
3850: l_kle_id_mod_tbl Okl_Streams_Util.NumberTabTyp;
3851: l_amt_mod_tbl Okl_Streams_Util.NumberTabTyp;
3852: l_stm_purpose_mod_tbl Okl_Streams_Util.Var150TabTyp;
3853:
3854: l_ele_id_del_tbl Okl_Streams_Util.NumberTabTyp;

Line 3851: l_amt_mod_tbl Okl_Streams_Util.NumberTabTyp;

3847: l_ele_id_mod_tbl Okl_Streams_Util.NumberTabTyp;
3848: l_streamid_mod_tbl Okl_Streams_Util.NumberTabTyp;
3849: l_sel_date_mod_tbl Okl_Streams_Util.DateTabTyp;
3850: l_kle_id_mod_tbl Okl_Streams_Util.NumberTabTyp;
3851: l_amt_mod_tbl Okl_Streams_Util.NumberTabTyp;
3852: l_stm_purpose_mod_tbl Okl_Streams_Util.Var150TabTyp;
3853:
3854: l_ele_id_del_tbl Okl_Streams_Util.NumberTabTyp;
3855: l_streamid_del_tbl Okl_Streams_Util.NumberTabTyp;

Line 3852: l_stm_purpose_mod_tbl Okl_Streams_Util.Var150TabTyp;

3848: l_streamid_mod_tbl Okl_Streams_Util.NumberTabTyp;
3849: l_sel_date_mod_tbl Okl_Streams_Util.DateTabTyp;
3850: l_kle_id_mod_tbl Okl_Streams_Util.NumberTabTyp;
3851: l_amt_mod_tbl Okl_Streams_Util.NumberTabTyp;
3852: l_stm_purpose_mod_tbl Okl_Streams_Util.Var150TabTyp;
3853:
3854: l_ele_id_del_tbl Okl_Streams_Util.NumberTabTyp;
3855: l_streamid_del_tbl Okl_Streams_Util.NumberTabTyp;
3856: l_sel_date_del_tbl Okl_Streams_Util.DateTabTyp;

Line 3854: l_ele_id_del_tbl Okl_Streams_Util.NumberTabTyp;

3850: l_kle_id_mod_tbl Okl_Streams_Util.NumberTabTyp;
3851: l_amt_mod_tbl Okl_Streams_Util.NumberTabTyp;
3852: l_stm_purpose_mod_tbl Okl_Streams_Util.Var150TabTyp;
3853:
3854: l_ele_id_del_tbl Okl_Streams_Util.NumberTabTyp;
3855: l_streamid_del_tbl Okl_Streams_Util.NumberTabTyp;
3856: l_sel_date_del_tbl Okl_Streams_Util.DateTabTyp;
3857: l_kle_id_del_tbl Okl_Streams_Util.NumberTabTyp;
3858: l_amt_del_tbl Okl_Streams_Util.NumberTabTyp;

Line 3855: l_streamid_del_tbl Okl_Streams_Util.NumberTabTyp;

3851: l_amt_mod_tbl Okl_Streams_Util.NumberTabTyp;
3852: l_stm_purpose_mod_tbl Okl_Streams_Util.Var150TabTyp;
3853:
3854: l_ele_id_del_tbl Okl_Streams_Util.NumberTabTyp;
3855: l_streamid_del_tbl Okl_Streams_Util.NumberTabTyp;
3856: l_sel_date_del_tbl Okl_Streams_Util.DateTabTyp;
3857: l_kle_id_del_tbl Okl_Streams_Util.NumberTabTyp;
3858: l_amt_del_tbl Okl_Streams_Util.NumberTabTyp;
3859: l_stm_purpose_del_tbl Okl_Streams_Util.Var150TabTyp;

Line 3856: l_sel_date_del_tbl Okl_Streams_Util.DateTabTyp;

3852: l_stm_purpose_mod_tbl Okl_Streams_Util.Var150TabTyp;
3853:
3854: l_ele_id_del_tbl Okl_Streams_Util.NumberTabTyp;
3855: l_streamid_del_tbl Okl_Streams_Util.NumberTabTyp;
3856: l_sel_date_del_tbl Okl_Streams_Util.DateTabTyp;
3857: l_kle_id_del_tbl Okl_Streams_Util.NumberTabTyp;
3858: l_amt_del_tbl Okl_Streams_Util.NumberTabTyp;
3859: l_stm_purpose_del_tbl Okl_Streams_Util.Var150TabTyp;
3860:

Line 3857: l_kle_id_del_tbl Okl_Streams_Util.NumberTabTyp;

3853:
3854: l_ele_id_del_tbl Okl_Streams_Util.NumberTabTyp;
3855: l_streamid_del_tbl Okl_Streams_Util.NumberTabTyp;
3856: l_sel_date_del_tbl Okl_Streams_Util.DateTabTyp;
3857: l_kle_id_del_tbl Okl_Streams_Util.NumberTabTyp;
3858: l_amt_del_tbl Okl_Streams_Util.NumberTabTyp;
3859: l_stm_purpose_del_tbl Okl_Streams_Util.Var150TabTyp;
3860:
3861: l_sum_amount NUMBER;

Line 3858: l_amt_del_tbl Okl_Streams_Util.NumberTabTyp;

3854: l_ele_id_del_tbl Okl_Streams_Util.NumberTabTyp;
3855: l_streamid_del_tbl Okl_Streams_Util.NumberTabTyp;
3856: l_sel_date_del_tbl Okl_Streams_Util.DateTabTyp;
3857: l_kle_id_del_tbl Okl_Streams_Util.NumberTabTyp;
3858: l_amt_del_tbl Okl_Streams_Util.NumberTabTyp;
3859: l_stm_purpose_del_tbl Okl_Streams_Util.Var150TabTyp;
3860:
3861: l_sum_amount NUMBER;
3862: BEGIN

Line 3859: l_stm_purpose_del_tbl Okl_Streams_Util.Var150TabTyp;

3855: l_streamid_del_tbl Okl_Streams_Util.NumberTabTyp;
3856: l_sel_date_del_tbl Okl_Streams_Util.DateTabTyp;
3857: l_kle_id_del_tbl Okl_Streams_Util.NumberTabTyp;
3858: l_amt_del_tbl Okl_Streams_Util.NumberTabTyp;
3859: l_stm_purpose_del_tbl Okl_Streams_Util.Var150TabTyp;
3860:
3861: l_sum_amount NUMBER;
3862: BEGIN
3863:

Line 4334: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(

4330: l_selv_tbl(1).stream_element_date := l_hdr.end_date;
4331: l_selv_tbl(1).se_line_number := 1;
4332: l_selv_tbl(1).accrued_yn := NULL;
4333:
4334: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(
4335: p_api_version => g_api_version,
4336: p_init_msg_list => p_init_msg_list,
4337: x_msg_count => x_msg_count,
4338: x_msg_data => x_msg_data,

Line 4356: OKL_STREAMS_UTIL.accumulate_strm_headers(

4352: END IF;
4353: l_selv_tbl.DELETE;
4354: l_selv_tbl := lx_selv_tbl;
4355: --Accumulate Stream Header: 4346646
4356: OKL_STREAMS_UTIL.accumulate_strm_headers(
4357: p_stmv_rec => l_stmv_rec,
4358: x_full_stmv_tbl => l_stmv_tbl,
4359: x_return_status => lx_return_status );
4360: IF (lx_return_status = G_RET_STS_UNEXP_ERROR) THEN

Line 4366: OKL_STREAMS_UTIL.accumulate_strm_elements(

4362: ELSIF (lx_return_status = G_RET_STS_ERROR) THEN
4363: RAISE OKL_API.G_EXCEPTION_ERROR;
4364: END IF;
4365: --Accumulate Stream Elements
4366: OKL_STREAMS_UTIL.accumulate_strm_elements(
4367: p_stm_index_no => l_stmv_tbl.LAST,
4368: p_selv_tbl => l_selv_tbl,
4369: x_full_selv_tbl => l_full_selv_tbl,
4370: x_return_status => lx_return_status );

Line 4427: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(

4423: l_selv_tbl(1).stream_element_date := l_hdr.start_date;
4424: l_selv_tbl(1).se_line_number := 1;
4425: l_selv_tbl(1).accrued_yn := NULL;
4426:
4427: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(
4428: p_api_version => g_api_version,
4429: p_init_msg_list => p_init_msg_list,
4430: x_msg_count => x_msg_count,
4431: x_msg_data => x_msg_data,

Line 4451: OKL_STREAMS_UTIL.accumulate_strm_headers(

4447: l_selv_tbl.DELETE;
4448: l_selv_tbl := lx_selv_tbl;
4449:
4450: --Accumulate Stream Header: 4346646
4451: OKL_STREAMS_UTIL.accumulate_strm_headers(
4452: p_stmv_rec => l_stmv_rec,
4453: x_full_stmv_tbl => l_stmv_tbl,
4454: x_return_status => lx_return_status );
4455: IF (lx_return_status = G_RET_STS_UNEXP_ERROR) THEN

Line 4462: OKL_STREAMS_UTIL.accumulate_strm_elements(

4458: RAISE OKL_API.G_EXCEPTION_ERROR;
4459: END IF;
4460:
4461: --Accumulate Stream Elements
4462: OKL_STREAMS_UTIL.accumulate_strm_elements(
4463: p_stm_index_no => l_stmv_tbl.LAST,
4464: p_selv_tbl => l_selv_tbl,
4465: x_full_selv_tbl => l_full_selv_tbl,
4466: x_return_status => lx_return_status );

Line 4640: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(

4636: RAISE OKL_API.G_EXCEPTION_ERROR;
4637: END IF;
4638:
4639:
4640: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(
4641: p_api_version => g_api_version,
4642: p_init_msg_list => p_init_msg_list,
4643: x_msg_count => x_msg_count,
4644: x_msg_data => x_msg_data,

Line 4785: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(

4781: l_selv_tbl(i).comments := r_inflow_line_tbl(i).cf_arrear;
4782: END LOOP;
4783:
4784:
4785: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(
4786: p_api_version => p_api_version,
4787: p_init_msg_list => p_init_msg_list,
4788: x_msg_count => x_msg_count,
4789: x_msg_data => x_msg_data,

Line 5196: lx_return_status := Okl_Streams_Util.round_streams_amount(

5192: RAISE OKL_API.G_EXCEPTION_ERROR;
5193: END IF;
5194:
5195: l_pt_rec.purpose_code := 'PLOW';
5196: lx_return_status := Okl_Streams_Util.round_streams_amount(
5197: p_api_version => g_api_version,
5198: p_init_msg_list => p_init_msg_list,
5199: x_msg_count => x_msg_count,
5200: x_msg_data => x_msg_data,

Line 5611: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(

5607: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
5608: RAISE OKL_API.G_EXCEPTION_ERROR;
5609: END IF;
5610:
5611: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(
5612: p_api_version => g_api_version,
5613: p_init_msg_list => p_init_msg_list,
5614: x_msg_count => x_msg_count,
5615: x_msg_data => x_msg_data,

Line 5635: OKL_STREAMS_UTIL.accumulate_strm_headers(

5631: l_selv_tbl.DELETE;
5632: l_selv_tbl := lx_selv_tbl;
5633:
5634: --Accumulate Stream Header
5635: OKL_STREAMS_UTIL.accumulate_strm_headers(
5636: p_stmv_rec => l_stmv_rec,
5637: x_full_stmv_tbl => l_stmv_tbl,
5638: x_return_status => lx_return_status );
5639: IF (lx_return_status = G_RET_STS_UNEXP_ERROR) THEN

Line 5646: OKL_STREAMS_UTIL.accumulate_strm_elements(

5642: RAISE OKL_API.G_EXCEPTION_ERROR;
5643: END IF;
5644:
5645: --Accumulate Stream Elements
5646: OKL_STREAMS_UTIL.accumulate_strm_elements(
5647: p_stm_index_no => l_stmv_tbl.LAST,
5648: p_selv_tbl => l_selv_tbl,
5649: x_full_selv_tbl => l_full_selv_tbl,
5650: x_return_status => lx_return_status );

Line 5724: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(

5720: RAISE OKL_API.G_EXCEPTION_ERROR;
5721: END IF;
5722:
5723:
5724: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(
5725: p_api_version => g_api_version,
5726: p_init_msg_list => p_init_msg_list,
5727: x_msg_count => x_msg_count,
5728: x_msg_data => x_msg_data,

Line 5747: OKL_STREAMS_UTIL.accumulate_strm_headers(

5743:
5744: l_pt_tbl.DELETE;
5745: l_pt_tbl := lx_selv_tbl;
5746: --Accumulate Stream Header: 4346646
5747: OKL_STREAMS_UTIL.accumulate_strm_headers(
5748: p_stmv_rec => l_pt_rec,
5749: x_full_stmv_tbl => l_stmv_tbl,
5750: x_return_status => lx_return_status );
5751: IF (lx_return_status = G_RET_STS_UNEXP_ERROR) THEN

Line 5758: OKL_STREAMS_UTIL.accumulate_strm_elements(

5754: RAISE OKL_API.G_EXCEPTION_ERROR;
5755: END IF;
5756:
5757: --Accumulate Stream Elements
5758: OKL_STREAMS_UTIL.accumulate_strm_elements(
5759: p_stm_index_no => l_stmv_tbl.LAST,
5760: p_selv_tbl => l_pt_tbl,
5761: x_full_selv_tbl => l_full_selv_tbl,
5762: x_return_status => lx_return_status );

Line 5843: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(

5839: RAISE OKL_API.G_EXCEPTION_ERROR;
5840: END IF;
5841:
5842:
5843: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(
5844: p_api_version => g_api_version,
5845: p_init_msg_list => p_init_msg_list,
5846: x_msg_count => x_msg_count,
5847: x_msg_data => x_msg_data,

Line 5866: OKL_STREAMS_UTIL.accumulate_strm_headers(

5862:
5863: l_pt_pro_fee_tbl.DELETE;
5864: l_pt_pro_fee_tbl := lx_selv_tbl;
5865:
5866: OKL_STREAMS_UTIL.accumulate_strm_headers(
5867: p_stmv_rec => l_pt_pro_fee_rec,
5868: x_full_stmv_tbl => l_stmv_tbl,
5869: x_return_status => lx_return_status );
5870:

Line 5878: OKL_STREAMS_UTIL.accumulate_strm_elements(

5874: RAISE OKL_API.G_EXCEPTION_ERROR;
5875: END IF;
5876:
5877: --Accumulate Stream Elements
5878: OKL_STREAMS_UTIL.accumulate_strm_elements(
5879: p_stm_index_no => l_stmv_tbl.LAST,
5880: p_selv_tbl => l_pt_pro_fee_tbl,
5881: x_full_selv_tbl => l_full_selv_tbl,
5882: x_return_status => lx_return_status );

Line 6321: OKL_STREAMS_UTIL.get_acc_options(

6317: BEGIN
6318:
6319: -- print( l_prog_name, 'begin' );
6320: -- Added by RGOOTY: Start
6321: OKL_STREAMS_UTIL.get_acc_options(
6322: p_khr_id => p_khr_id,
6323: x_org_id => G_ORG_ID,
6324: x_precision => G_PRECISION,
6325: x_currency_code => G_CURRENCY_CODE,

Line 6795: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(

6791: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
6792: RAISE OKL_API.G_EXCEPTION_ERROR;
6793: END IF;
6794:
6795: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(
6796: p_api_version => g_api_version,
6797: p_init_msg_list => p_init_msg_list,
6798: x_msg_count => x_msg_count,
6799: x_msg_data => x_msg_data,

Line 6856: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(

6852: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
6853: RAISE OKL_API.G_EXCEPTION_ERROR;
6854: END IF;
6855:
6856: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(
6857: p_api_version => g_api_version,
6858: p_init_msg_list => p_init_msg_list,
6859: x_msg_count => x_msg_count,
6860: x_msg_data => x_msg_data,

Line 6917: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(

6913: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
6914: RAISE OKL_API.G_EXCEPTION_ERROR;
6915: END IF;
6916:
6917: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(
6918: p_api_version => g_api_version,
6919: p_init_msg_list => p_init_msg_list,
6920: x_msg_count => x_msg_count,
6921: x_msg_data => x_msg_data,

Line 6972: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(

6968: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
6969: RAISE OKL_API.G_EXCEPTION_ERROR;
6970: END IF;
6971:
6972: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(
6973: p_api_version => g_api_version,
6974: p_init_msg_list => p_init_msg_list,
6975: x_msg_count => x_msg_count,
6976: x_msg_data => x_msg_data,

Line 7025: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(

7021: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
7022: RAISE OKL_API.G_EXCEPTION_ERROR;
7023: END IF;
7024:
7025: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(
7026: p_api_version => g_api_version,
7027: p_init_msg_list => p_init_msg_list,
7028: x_msg_count => x_msg_count,
7029: x_msg_data => x_msg_data,

Line 7540: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(

7536: --
7537: -- call process API to create parent Stream Header and its child Stream Elements
7538: --
7539:
7540: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(
7541: p_api_version => g_api_version,
7542: p_init_msg_list => p_init_msg_list,
7543: x_msg_count => x_msg_count,
7544: x_msg_data => x_msg_data,

Line 7563: OKL_STREAMS_UTIL.accumulate_strm_headers(

7559:
7560: l_selv_tbl.DELETE;
7561: l_selv_tbl := lx_selv_tbl;
7562: --Accumulate Stream Header
7563: OKL_STREAMS_UTIL.accumulate_strm_headers(
7564: p_stmv_rec => l_stmv_rec,
7565: x_full_stmv_tbl => l_stmv_tbl,
7566: x_return_status => lx_return_status );
7567: IF (lx_return_status = G_RET_STS_UNEXP_ERROR) THEN

Line 7573: OKL_STREAMS_UTIL.accumulate_strm_elements(

7569: ELSIF (lx_return_status = G_RET_STS_ERROR) THEN
7570: RAISE OKL_API.G_EXCEPTION_ERROR;
7571: END IF;
7572: --Accumulate Stream Elements
7573: OKL_STREAMS_UTIL.accumulate_strm_elements(
7574: p_stm_index_no => l_stmv_tbl.LAST,
7575: p_selv_tbl => l_selv_tbl,
7576: x_full_selv_tbl => l_full_selv_tbl,
7577: x_return_status => lx_return_status );

Line 8095: x_return_status := Okl_Streams_Util.round_streams_amount(

8091: RAISE OKL_API.G_EXCEPTION_ERROR;
8092: END IF;
8093:
8094:
8095: x_return_status := Okl_Streams_Util.round_streams_amount(
8096: p_api_version => p_api_version,
8097: p_init_msg_list => p_init_msg_list,
8098: x_msg_count => x_msg_count,
8099: x_msg_data => x_msg_data,

Line 9750: x_return_status := Okl_Streams_Util.round_streams_amount(

9746: If( l_selv_tbl.COUNT > 0 AND (l_stmv_rec.sty_id IS NOT NULL) ) Then
9747:
9748: print( l_api_name, ' creating pv disb streams ' );
9749:
9750: x_return_status := Okl_Streams_Util.round_streams_amount(
9751: p_api_version => g_api_version,
9752: p_init_msg_list => p_init_msg_list,
9753: x_msg_count => x_msg_count,
9754: x_msg_data => x_msg_data,

Line 9939: x_return_status := Okl_Streams_Util.round_streams_amount(

9935: If( l_selv_tbl.COUNT > 0 AND (l_stmv_rec.sty_id IS NOT NULL) ) Then
9936:
9937: print( l_api_name, ' creating pv disb streams ' );
9938:
9939: x_return_status := Okl_Streams_Util.round_streams_amount(
9940: p_api_version => g_api_version,
9941: p_init_msg_list => p_init_msg_list,
9942: x_msg_count => x_msg_count,
9943: x_msg_data => x_msg_data,

Line 10353: x_return_status := Okl_Streams_Util.round_streams_amount(

10349: If( l_selv_tbl.COUNT > 0 AND l_stmv_rec.sty_id IS NOT NULL) Then
10350:
10351: print( l_api_name, ' creating disb streams ' );
10352:
10353: x_return_status := Okl_Streams_Util.round_streams_amount(
10354: p_api_version => g_api_version,
10355: p_init_msg_list => p_init_msg_list,
10356: x_msg_count => x_msg_count,
10357: x_msg_data => x_msg_data,

Line 10546: x_return_status := Okl_Streams_Util.round_streams_amount(

10542: If( l_selv_tbl.COUNT > 0 AND l_stmv_rec.sty_id IS NOT NULL) Then
10543:
10544: print( l_api_name, ' creating disb streams ' );
10545:
10546: x_return_status := Okl_Streams_Util.round_streams_amount(
10547: p_api_version => g_api_version,
10548: p_init_msg_list => p_init_msg_list,
10549: x_msg_count => x_msg_count,
10550: x_msg_data => x_msg_data,

Line 11721: x_return_status := Okl_Streams_Util.round_streams_amount_esg(

11717: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
11718: RAISE OKL_API.G_EXCEPTION_ERROR;
11719: END IF;
11720:
11721: x_return_status := Okl_Streams_Util.round_streams_amount_esg(
11722: p_api_version => g_api_version,
11723: p_init_msg_list => p_init_msg_list,
11724: x_msg_count => x_msg_count,
11725: x_msg_data => x_msg_data,

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

11741: l_selv_tbl.DELETE;
11742: l_selv_tbl := lx_selv_tbl;
11743:
11744: --Accumulate Stream Header
11745: OKL_STREAMS_UTIL.accumulate_strm_headers( p_stmv_rec => l_stmv_rec,
11746: x_full_stmv_tbl => l_stmv_tbl,
11747: x_return_status => x_return_status );
11748: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
11749: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

11751: RAISE OKL_API.G_EXCEPTION_ERROR;
11752: END IF;
11753:
11754: --Accumulate Stream Elements
11755: OKL_STREAMS_UTIL.accumulate_strm_elements( p_stm_index_no => l_stmv_tbl.LAST,
11756: p_selv_tbl => l_selv_tbl,
11757: x_full_selv_tbl => l_full_selv_tbl,
11758: x_return_status => x_return_status );
11759: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

Line 11968: x_return_status := Okl_Streams_Util.round_streams_amount_esg(

11964: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
11965: RAISE OKL_API.G_EXCEPTION_ERROR;
11966: END IF;
11967:
11968: x_return_status := Okl_Streams_Util.round_streams_amount_esg(
11969: p_api_version => g_api_version,
11970: p_init_msg_list => p_init_msg_list,
11971: x_msg_count => x_msg_count,
11972: x_msg_data => x_msg_data,

Line 11992: OKL_STREAMS_UTIL.accumulate_strm_headers(

11988: l_selv_tbl.DELETE;
11989: l_selv_tbl := lx_selv_tbl;
11990:
11991: --Accumulate Stream Header
11992: OKL_STREAMS_UTIL.accumulate_strm_headers(
11993: p_stmv_rec => l_stmv_rec,
11994: x_full_stmv_tbl => l_stmv_tbl,
11995: x_return_status => x_return_status );
11996: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

Line 12003: OKL_STREAMS_UTIL.accumulate_strm_elements(

11999: RAISE OKL_API.G_EXCEPTION_ERROR;
12000: END IF;
12001:
12002: --Accumulate Stream Elements
12003: OKL_STREAMS_UTIL.accumulate_strm_elements(
12004: p_stm_index_no => l_stmv_tbl.LAST,
12005: p_selv_tbl => l_selv_tbl,
12006: x_full_selv_tbl => l_full_selv_tbl,
12007: x_return_status => x_return_status );

Line 12085: l_strm_id_tbl okl_streams_util.NumberTabTyp;

12081: , x_msg_data OUT NOCOPY VARCHAR2
12082: )
12083: IS
12084:
12085: l_strm_id_tbl okl_streams_util.NumberTabTyp;
12086: l_say_code_tbl okl_streams_util.Var10TabTyp;
12087: l_active_yn_tbl okl_streams_util.Var10TabTyp;
12088: l_date_history_tbl okl_streams_util.DateTabTyp;
12089: l_date_curr_tbl okl_streams_util.DateTabTyp;

Line 12086: l_say_code_tbl okl_streams_util.Var10TabTyp;

12082: )
12083: IS
12084:
12085: l_strm_id_tbl okl_streams_util.NumberTabTyp;
12086: l_say_code_tbl okl_streams_util.Var10TabTyp;
12087: l_active_yn_tbl okl_streams_util.Var10TabTyp;
12088: l_date_history_tbl okl_streams_util.DateTabTyp;
12089: l_date_curr_tbl okl_streams_util.DateTabTyp;
12090:

Line 12087: l_active_yn_tbl okl_streams_util.Var10TabTyp;

12083: IS
12084:
12085: l_strm_id_tbl okl_streams_util.NumberTabTyp;
12086: l_say_code_tbl okl_streams_util.Var10TabTyp;
12087: l_active_yn_tbl okl_streams_util.Var10TabTyp;
12088: l_date_history_tbl okl_streams_util.DateTabTyp;
12089: l_date_curr_tbl okl_streams_util.DateTabTyp;
12090:
12091: CURSOR strms_csr IS

Line 12088: l_date_history_tbl okl_streams_util.DateTabTyp;

12084:
12085: l_strm_id_tbl okl_streams_util.NumberTabTyp;
12086: l_say_code_tbl okl_streams_util.Var10TabTyp;
12087: l_active_yn_tbl okl_streams_util.Var10TabTyp;
12088: l_date_history_tbl okl_streams_util.DateTabTyp;
12089: l_date_curr_tbl okl_streams_util.DateTabTyp;
12090:
12091: CURSOR strms_csr IS
12092: SELECT strm.id

Line 12089: l_date_curr_tbl okl_streams_util.DateTabTyp;

12085: l_strm_id_tbl okl_streams_util.NumberTabTyp;
12086: l_say_code_tbl okl_streams_util.Var10TabTyp;
12087: l_active_yn_tbl okl_streams_util.Var10TabTyp;
12088: l_date_history_tbl okl_streams_util.DateTabTyp;
12089: l_date_curr_tbl okl_streams_util.DateTabTyp;
12090:
12091: CURSOR strms_csr IS
12092: SELECT strm.id
12093: , strm.say_code