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 1025: lx_return_status := Okl_Streams_Util.round_streams_amount(

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

Line 1184: lx_return_status := Okl_Streams_Util.round_streams_amount(

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

Line 1240: lx_return_status := Okl_Streams_Util.round_streams_amount(

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

Line 1296: lx_return_status := Okl_Streams_Util.round_streams_amount(

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

Line 1352: lx_return_status := Okl_Streams_Util.round_streams_amount(

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

Line 1408: lx_return_status := Okl_Streams_Util.round_streams_amount(

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

Line 3737: eleid_tbl Okl_Streams_Util.NumberTabTyp;

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

Line 3738: streamid_tbl Okl_Streams_Util.NumberTabTyp;

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

Line 3739: sel_date Okl_Streams_Util.DateTabTyp;

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

Line 3750: l_ele_id_all_tbl Okl_Streams_Util.NumberTabTyp;

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

Line 3751: l_streamid_all_tbl Okl_Streams_Util.NumberTabTyp;

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

Line 3752: l_sel_date_all_tbl Okl_Streams_Util.DateTabTyp;

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

Line 3753: l_kle_id_all_tbl Okl_Streams_Util.NumberTabTyp;

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

Line 3754: l_amt_all_tbl Okl_Streams_Util.NumberTabTyp;

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

Line 3755: l_stm_purpose_all_tbl Okl_Streams_Util.Var150TabTyp;

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

Line 3758: l_sty_id_all_tbl Okl_Streams_Util.NumberTabTyp;

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

Line 3760: l_ele_id_mod_tbl Okl_Streams_Util.NumberTabTyp;

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

Line 3761: l_streamid_mod_tbl Okl_Streams_Util.NumberTabTyp;

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

Line 3762: l_sel_date_mod_tbl Okl_Streams_Util.DateTabTyp;

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

Line 3763: l_kle_id_mod_tbl Okl_Streams_Util.NumberTabTyp;

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

Line 3764: l_amt_mod_tbl Okl_Streams_Util.NumberTabTyp;

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

Line 3765: l_stm_purpose_mod_tbl Okl_Streams_Util.Var150TabTyp;

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

Line 3767: l_ele_id_del_tbl Okl_Streams_Util.NumberTabTyp;

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

Line 3768: l_streamid_del_tbl Okl_Streams_Util.NumberTabTyp;

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

Line 3769: l_sel_date_del_tbl Okl_Streams_Util.DateTabTyp;

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

Line 3770: l_kle_id_del_tbl Okl_Streams_Util.NumberTabTyp;

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

Line 3771: l_amt_del_tbl Okl_Streams_Util.NumberTabTyp;

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

Line 3772: l_stm_purpose_del_tbl Okl_Streams_Util.Var150TabTyp;

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

Line 4256: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(

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

Line 4278: OKL_STREAMS_UTIL.accumulate_strm_headers(

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

Line 4288: OKL_STREAMS_UTIL.accumulate_strm_elements(

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

Line 4349: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(

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

Line 4373: OKL_STREAMS_UTIL.accumulate_strm_headers(

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

Line 4384: OKL_STREAMS_UTIL.accumulate_strm_elements(

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

Line 4562: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(

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

Line 4707: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(

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

Line 5118: lx_return_status := Okl_Streams_Util.round_streams_amount(

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

Line 5533: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(

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

Line 5557: OKL_STREAMS_UTIL.accumulate_strm_headers(

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

Line 5568: OKL_STREAMS_UTIL.accumulate_strm_elements(

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

Line 5646: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(

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

Line 5669: OKL_STREAMS_UTIL.accumulate_strm_headers(

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

Line 5680: OKL_STREAMS_UTIL.accumulate_strm_elements(

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

Line 5765: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(

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

Line 5788: OKL_STREAMS_UTIL.accumulate_strm_headers(

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

Line 5800: OKL_STREAMS_UTIL.accumulate_strm_elements(

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

Line 6076: x_return_status := Okl_Streams_Util.round_streams_amount_esg(

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

Line 6112: OKL_STREAMS_UTIL.accumulate_strm_headers(

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

Line 6123: OKL_STREAMS_UTIL.accumulate_strm_elements(

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

Line 7898: x_return_status := Okl_Streams_Util.round_streams_amount(

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

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

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

Line 8484: OKL_STREAMS_UTIL.get_acc_options(

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

Line 9022: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(

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

Line 9083: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(

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

Line 9144: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(

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

Line 9199: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(

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

Line 9252: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(

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

Line 9853: lx_return_status := Okl_Streams_Util.round_streams_amount_esg(

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

Line 9876: OKL_STREAMS_UTIL.accumulate_strm_headers(

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

Line 9886: OKL_STREAMS_UTIL.accumulate_strm_elements(

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

Line 10550: x_return_status := Okl_Streams_Util.round_streams_amount(

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

Line 12205: x_return_status := Okl_Streams_Util.round_streams_amount(

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

Line 12394: x_return_status := Okl_Streams_Util.round_streams_amount(

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

Line 12808: x_return_status := Okl_Streams_Util.round_streams_amount(

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

Line 13001: x_return_status := Okl_Streams_Util.round_streams_amount(

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

Line 14188: x_return_status := Okl_Streams_Util.round_streams_amount_esg(

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

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

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

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

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

Line 14479: x_return_status := Okl_Streams_Util.round_streams_amount_esg(

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

Line 14503: OKL_STREAMS_UTIL.accumulate_strm_headers(

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

Line 14514: OKL_STREAMS_UTIL.accumulate_strm_elements(

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

Line 14601: l_strm_id_tbl okl_streams_util.NumberTabTyp;

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

Line 14602: l_say_code_tbl okl_streams_util.Var10TabTyp;

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

Line 14603: l_active_yn_tbl okl_streams_util.Var10TabTyp;

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

Line 14604: l_date_history_tbl okl_streams_util.DateTabTyp;

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

Line 14605: l_date_curr_tbl okl_streams_util.DateTabTyp;

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