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_LA_STREAM_PVT dependencies on OKL_STREAMS_PUB

Line 1703: l_stmv_rec okl_streams_pub.stmv_rec_type;

1699: lx_fee_types_rec okl_maintain_fee_pvt.fee_types_rec_type;
1700: l_fee_types_rec okl_maintain_fee_pvt.fee_types_rec_type;
1701: l_rvi_amount NUMBER;
1702: l_strm_id NUMBER;
1703: l_stmv_rec okl_streams_pub.stmv_rec_type;
1704: l_api_name VARCHAR2(255) := 'update_rvi_amount';
1705: BEGIN
1706: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1707: -- Call start_activity to create savepoint, check compatibility

Line 1776: okl_streams_pub.delete_streams(p_api_version => p_api_version,

1772: END IF;
1773: END IF; -- end of stream element check
1774: END IF; -- end of main product check
1775: -- delete the primary stream for all products
1776: okl_streams_pub.delete_streams(p_api_version => p_api_version,
1777: p_init_msg_list => OKL_API.G_FALSE,
1778: x_return_status => x_return_status,
1779: x_msg_count => x_msg_count,
1780: x_msg_data => x_msg_data,

Line 2462: l_stmv_tbl okl_streams_pub.stmv_tbl_type;

2458: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_WKG_STRMS';
2459: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2460: l_api_version NUMBER := 1.0;
2461:
2462: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
2463: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
2464: l_strms_orig_rec strms_csr%ROWTYPE;
2465: l_strms_rep_rec strms_csr%ROWTYPE;
2466:

Line 2463: x_stmv_tbl okl_streams_pub.stmv_tbl_type;

2459: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2460: l_api_version NUMBER := 1.0;
2461:
2462: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
2463: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
2464: l_strms_orig_rec strms_csr%ROWTYPE;
2465: l_strms_rep_rec strms_csr%ROWTYPE;
2466:
2467: i NUMBER;

Line 2516: Okl_Streams_pub.delete_streams(

2512: END LOOP;
2513:
2514: If ( i > 0 ) Then
2515:
2516: Okl_Streams_pub.delete_streams(
2517: p_api_version => p_api_version,
2518: p_init_msg_list => p_init_msg_list,
2519: x_return_status => x_return_status,
2520: x_msg_count => x_msg_count,

Line 2725: p_selv_tbl IN okl_streams_pub.selv_tbl_type,

2721: -- Description : This procedure sorts and consolidates the Passthrough
2722: -- Expense Accrual Stream elements
2723: -- End of comments
2724: PROCEDURE consolidate_pth_acc_streams(p_chr_id IN NUMBER,
2725: p_selv_tbl IN okl_streams_pub.selv_tbl_type,
2726: x_selv_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
2727: x_return_status OUT NOCOPY VARCHAR2) AS
2728:
2729: l_api_name CONSTANT VARCHAR2(30) := 'consolidate_pth_acc_streams';

Line 2726: x_selv_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,

2722: -- Expense Accrual Stream elements
2723: -- End of comments
2724: PROCEDURE consolidate_pth_acc_streams(p_chr_id IN NUMBER,
2725: p_selv_tbl IN okl_streams_pub.selv_tbl_type,
2726: x_selv_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
2727: x_return_status OUT NOCOPY VARCHAR2) AS
2728:
2729: l_api_name CONSTANT VARCHAR2(30) := 'consolidate_pth_acc_streams';
2730: l_tmp_selv_tbl okl_streams_pub.selv_tbl_type;

Line 2730: l_tmp_selv_tbl okl_streams_pub.selv_tbl_type;

2726: x_selv_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
2727: x_return_status OUT NOCOPY VARCHAR2) AS
2728:
2729: l_api_name CONSTANT VARCHAR2(30) := 'consolidate_pth_acc_streams';
2730: l_tmp_selv_tbl okl_streams_pub.selv_tbl_type;
2731: i NUMBER;
2732: j NUMBER;
2733: x_msg_data VARCHAR2(4000);
2734: x_msg_count NUMBER;

Line 2823: x_selv_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,

2819: PROCEDURE get_passthru_exp_accruals(p_chr_id IN NUMBER,
2820: p_disb_amount IN NUMBER,
2821: p_start_date IN DATE,
2822: p_end_date IN DATE,
2823: x_selv_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
2824: x_return_status OUT NOCOPY VARCHAR2) AS
2825:
2826: l_api_name CONSTANT VARCHAR2(30) := 'get_passthru_exp_accruals';
2827: l_end_date DATE;

Line 3031: l_stmv_tbl okl_streams_pub.stmv_tbl_type;

3027: lx_failStatus VARCHAR2(30);
3028: c_kle_id NUMBER;
3029: c_sty_id NUMBER;
3030: v_adj_amt NUMBER;
3031: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
3032: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
3033: l_selv_tbl okl_streams_pvt.selv_tbl_type;
3034: l_pt_tbl okl_streams_pub.selv_tbl_type;
3035: --srsreeni Bug 5917582 start

Line 3032: x_stmv_tbl okl_streams_pub.stmv_tbl_type;

3028: c_kle_id NUMBER;
3029: c_sty_id NUMBER;
3030: v_adj_amt NUMBER;
3031: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
3032: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
3033: l_selv_tbl okl_streams_pvt.selv_tbl_type;
3034: l_pt_tbl okl_streams_pub.selv_tbl_type;
3035: --srsreeni Bug 5917582 start
3036: l_pt_tbl_tmp okl_streams_pub.selv_tbl_type;

Line 3034: l_pt_tbl okl_streams_pub.selv_tbl_type;

3030: v_adj_amt NUMBER;
3031: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
3032: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
3033: l_selv_tbl okl_streams_pvt.selv_tbl_type;
3034: l_pt_tbl okl_streams_pub.selv_tbl_type;
3035: --srsreeni Bug 5917582 start
3036: l_pt_tbl_tmp okl_streams_pub.selv_tbl_type;
3037: --srsreeni Bug 5917582 end
3038: lx_selv_tbl okl_streams_pvt.selv_tbl_type;

Line 3036: l_pt_tbl_tmp okl_streams_pub.selv_tbl_type;

3032: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
3033: l_selv_tbl okl_streams_pvt.selv_tbl_type;
3034: l_pt_tbl okl_streams_pub.selv_tbl_type;
3035: --srsreeni Bug 5917582 start
3036: l_pt_tbl_tmp okl_streams_pub.selv_tbl_type;
3037: --srsreeni Bug 5917582 end
3038: lx_selv_tbl okl_streams_pvt.selv_tbl_type;
3039: l_stmv_rec okl_streams_pub.stmv_rec_type;
3040: lx_stmv_rec okl_streams_pub.stmv_rec_type;

Line 3039: l_stmv_rec okl_streams_pub.stmv_rec_type;

3035: --srsreeni Bug 5917582 start
3036: l_pt_tbl_tmp okl_streams_pub.selv_tbl_type;
3037: --srsreeni Bug 5917582 end
3038: lx_selv_tbl okl_streams_pvt.selv_tbl_type;
3039: l_stmv_rec okl_streams_pub.stmv_rec_type;
3040: lx_stmv_rec okl_streams_pub.stmv_rec_type;
3041: --srsreeni bug 5869271 start add
3042: l_old_cle_id okc_k_lines_b.ID%TYPE;
3043: l_old_sty_id okl_strm_type_b.ID%TYPE;

Line 3040: lx_stmv_rec okl_streams_pub.stmv_rec_type;

3036: l_pt_tbl_tmp okl_streams_pub.selv_tbl_type;
3037: --srsreeni Bug 5917582 end
3038: lx_selv_tbl okl_streams_pvt.selv_tbl_type;
3039: l_stmv_rec okl_streams_pub.stmv_rec_type;
3040: lx_stmv_rec okl_streams_pub.stmv_rec_type;
3041: --srsreeni bug 5869271 start add
3042: l_old_cle_id okc_k_lines_b.ID%TYPE;
3043: l_old_sty_id okl_strm_type_b.ID%TYPE;
3044: l_old_str_stmv_rec okl_streams_pub.stmv_rec_type;

Line 3044: l_old_str_stmv_rec okl_streams_pub.stmv_rec_type;

3040: lx_stmv_rec okl_streams_pub.stmv_rec_type;
3041: --srsreeni bug 5869271 start add
3042: l_old_cle_id okc_k_lines_b.ID%TYPE;
3043: l_old_sty_id okl_strm_type_b.ID%TYPE;
3044: l_old_str_stmv_rec okl_streams_pub.stmv_rec_type;
3045: l_old_acr_stmv_rec okl_streams_pub.stmv_rec_type;
3046: l_last_se_line_number OKL_STRM_ELEMENTS_V.SE_LINE_NUMBER%TYPE;
3047: l_last_acr_se_line_number OKL_STRM_ELEMENTS_V.SE_LINE_NUMBER%TYPE;
3048: --srsreeni bug 5869271 end add

Line 3045: l_old_acr_stmv_rec okl_streams_pub.stmv_rec_type;

3041: --srsreeni bug 5869271 start add
3042: l_old_cle_id okc_k_lines_b.ID%TYPE;
3043: l_old_sty_id okl_strm_type_b.ID%TYPE;
3044: l_old_str_stmv_rec okl_streams_pub.stmv_rec_type;
3045: l_old_acr_stmv_rec okl_streams_pub.stmv_rec_type;
3046: l_last_se_line_number OKL_STRM_ELEMENTS_V.SE_LINE_NUMBER%TYPE;
3047: l_last_acr_se_line_number OKL_STRM_ELEMENTS_V.SE_LINE_NUMBER%TYPE;
3048: --srsreeni bug 5869271 end add
3049: l_purpose_code VARCHAR2(30) := p_purpose;

Line 3148: l_pt_pro_fee_tbl okl_streams_pub.selv_tbl_type;

3144: l_pdt_id NUMBER;
3145: l_primary_sty_id NUMBER;
3146:
3147: -- gboomina Bug 4746368 - Added - Start
3148: l_pt_pro_fee_tbl okl_streams_pub.selv_tbl_type;
3149: l_fee_strm_type_rec fee_strm_type_csr%ROWTYPE;
3150: -- gboomina Bug 4746368 - Added - End
3151: --srsreeni Bug 5917582 start
3152: l_pt_pro_fee_tbl_tmp okl_streams_pub.selv_tbl_type;

Line 3152: l_pt_pro_fee_tbl_tmp okl_streams_pub.selv_tbl_type;

3148: l_pt_pro_fee_tbl okl_streams_pub.selv_tbl_type;
3149: l_fee_strm_type_rec fee_strm_type_csr%ROWTYPE;
3150: -- gboomina Bug 4746368 - Added - End
3151: --srsreeni Bug 5917582 start
3152: l_pt_pro_fee_tbl_tmp okl_streams_pub.selv_tbl_type;
3153: --srsreeni Bug 5917582 end
3154:
3155: --Added by djanaswa for bug 6007644
3156: l_recurrence_date DATE := NULL;

Line 3251: l_pth_selv_tbl okl_streams_pub.selv_tbl_type;

3247: l_frequency VARCHAR2(1);
3248: l_pay_start_date DATE;
3249: l_pay_end_date DATE;
3250: l_months_factor NUMBER;
3251: l_pth_selv_tbl okl_streams_pub.selv_tbl_type;
3252: l_pth_exp_selv_tbl okl_streams_pub.selv_tbl_type;
3253: l_bill_amount NUMBER;
3254: l_prev_pay_start_date DATE;
3255: --end rgooty

Line 3252: l_pth_exp_selv_tbl okl_streams_pub.selv_tbl_type;

3248: l_pay_start_date DATE;
3249: l_pay_end_date DATE;
3250: l_months_factor NUMBER;
3251: l_pth_selv_tbl okl_streams_pub.selv_tbl_type;
3252: l_pth_exp_selv_tbl okl_streams_pub.selv_tbl_type;
3253: l_bill_amount NUMBER;
3254: l_prev_pay_start_date DATE;
3255: --end rgooty
3256:

Line 3294: okl_streams_pub.delete_streams(p_api_version => p_api_version,

3290: i := i + 1;
3291: l_stmv_tbl(i).id := l_stm_rec.stmid;
3292: END LOOP;
3293: IF ( i > 0 ) THEN
3294: okl_streams_pub.delete_streams(p_api_version => p_api_version,
3295: x_return_status => x_return_status,
3296: p_init_msg_list => p_init_msg_list,
3297: x_msg_count => x_msg_count,
3298: x_msg_data => x_msg_data,

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

3380: l_stmv_rec.date_working := SYSDATE;
3381: --Added by kthiruva on 09-Feb-2006
3382: --Bug 5029161 - Start of Changes
3383: IF l_selv_tbl.COUNT > 0 THEN
3384: okl_streams_pub.create_streams(p_api_version => p_api_version,
3385: p_init_msg_list => p_init_msg_list,
3386: x_return_status => x_return_status,
3387: x_msg_count => x_msg_count,
3388: x_msg_data => x_msg_data,

Line 3415: okl_streams_pub.create_stream_elements(

3411: EXIT WHEN(i = l_selv_tbl.LAST);
3412: i := l_selv_tbl.NEXT(i);
3413: END LOOP;
3414: -- populate the detail
3415: okl_streams_pub.create_stream_elements(
3416: p_api_version => p_api_version
3417: ,p_init_msg_list => p_init_msg_list
3418: ,x_return_status => x_return_status
3419: ,x_msg_count => x_msg_count

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

3521: l_stmv_rec.date_working := SYSDATE;
3522: --Added by kthiruva on 09-Feb-2006
3523: --Bug 5029161 - Start of Changes
3524: IF l_selv_tbl.COUNT > 0 THEN
3525: okl_streams_pub.create_streams(p_api_version => p_api_version,
3526: p_init_msg_list => p_init_msg_list,
3527: x_return_status => x_return_status,
3528: x_msg_count => x_msg_count,
3529: x_msg_data => x_msg_data,

Line 3557: okl_streams_pub.create_stream_elements(

3553: EXIT WHEN(i = l_selv_tbl.LAST);
3554: i := l_selv_tbl.NEXT(i);
3555: END LOOP;
3556: -- populate the detail
3557: okl_streams_pub.create_stream_elements(
3558: p_api_version => p_api_version
3559: ,p_init_msg_list => p_init_msg_list
3560: ,x_return_status => x_return_status
3561: ,x_msg_count => x_msg_count

Line 3867: l_pt_tbl_tmp okl_streams_pub.selv_tbl_type;

3863: l_payment_period_end_date DATE;
3864: l_total_disb_amount NUMBER;
3865: --Bug 13448352: RGOOTY: End
3866:
3867: l_pt_tbl_tmp okl_streams_pub.selv_tbl_type;
3868: l_pth_selv_tbl okl_streams_pub.selv_tbl_type;
3869: l_pth_exp_selv_tbl okl_streams_pub.selv_tbl_type;
3870: l_fee_strm_type_rec fee_strm_type_csr%ROWTYPE;
3871: l_pdt_id_rec l_hdr_pdt_csr%ROWTYPE;

Line 3868: l_pth_selv_tbl okl_streams_pub.selv_tbl_type;

3864: l_total_disb_amount NUMBER;
3865: --Bug 13448352: RGOOTY: End
3866:
3867: l_pt_tbl_tmp okl_streams_pub.selv_tbl_type;
3868: l_pth_selv_tbl okl_streams_pub.selv_tbl_type;
3869: l_pth_exp_selv_tbl okl_streams_pub.selv_tbl_type;
3870: l_fee_strm_type_rec fee_strm_type_csr%ROWTYPE;
3871: l_pdt_id_rec l_hdr_pdt_csr%ROWTYPE;
3872: l_sty_id strm_rec_type;

Line 3869: l_pth_exp_selv_tbl okl_streams_pub.selv_tbl_type;

3865: --Bug 13448352: RGOOTY: End
3866:
3867: l_pt_tbl_tmp okl_streams_pub.selv_tbl_type;
3868: l_pth_selv_tbl okl_streams_pub.selv_tbl_type;
3869: l_pth_exp_selv_tbl okl_streams_pub.selv_tbl_type;
3870: l_fee_strm_type_rec fee_strm_type_csr%ROWTYPE;
3871: l_pdt_id_rec l_hdr_pdt_csr%ROWTYPE;
3872: l_sty_id strm_rec_type;
3873: l_stmv_rec okl_streams_pub.stmv_rec_type;

Line 3873: l_stmv_rec okl_streams_pub.stmv_rec_type;

3869: l_pth_exp_selv_tbl okl_streams_pub.selv_tbl_type;
3870: l_fee_strm_type_rec fee_strm_type_csr%ROWTYPE;
3871: l_pdt_id_rec l_hdr_pdt_csr%ROWTYPE;
3872: l_sty_id strm_rec_type;
3873: l_stmv_rec okl_streams_pub.stmv_rec_type;
3874: lx_stmv_rec okl_streams_pub.stmv_rec_type;
3875: lx_selv_tbl okl_streams_pvt.selv_tbl_type;
3876:
3877: BEGIN

Line 3874: lx_stmv_rec okl_streams_pub.stmv_rec_type;

3870: l_fee_strm_type_rec fee_strm_type_csr%ROWTYPE;
3871: l_pdt_id_rec l_hdr_pdt_csr%ROWTYPE;
3872: l_sty_id strm_rec_type;
3873: l_stmv_rec okl_streams_pub.stmv_rec_type;
3874: lx_stmv_rec okl_streams_pub.stmv_rec_type;
3875: lx_selv_tbl okl_streams_pvt.selv_tbl_type;
3876:
3877: BEGIN
3878:

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

4050: --Added by kthiruva on 09-Feb-2006
4051: --Bug 5029161 - Start of Changes
4052: --Made change by bkatraga for bug 8226735
4053: IF l_pth_exp_selv_tbl.COUNT > 0 THEN
4054: okl_streams_pub.create_streams(p_api_version => p_api_version,
4055: p_init_msg_list => p_init_msg_list,
4056: x_return_status => x_return_status,
4057: x_msg_count => x_msg_count,
4058: x_msg_data => x_msg_data,

Line 4195: l_pt_tbl_tmp okl_streams_pub.selv_tbl_type;

4191: l_payment_period_end_date DATE;
4192: l_total_disb_amount NUMBER;
4193: --Bug 13448352: RGOOTY: End
4194:
4195: l_pt_tbl_tmp okl_streams_pub.selv_tbl_type;
4196: l_pth_selv_tbl okl_streams_pub.selv_tbl_type;
4197: l_pth_exp_selv_tbl okl_streams_pub.selv_tbl_type;
4198: l_serv_strm_type_rec serv_strm_type_csr%ROWTYPE; --added this cursor in the spec
4199: l_pdt_id_rec l_hdr_pdt_csr%ROWTYPE;

Line 4196: l_pth_selv_tbl okl_streams_pub.selv_tbl_type;

4192: l_total_disb_amount NUMBER;
4193: --Bug 13448352: RGOOTY: End
4194:
4195: l_pt_tbl_tmp okl_streams_pub.selv_tbl_type;
4196: l_pth_selv_tbl okl_streams_pub.selv_tbl_type;
4197: l_pth_exp_selv_tbl okl_streams_pub.selv_tbl_type;
4198: l_serv_strm_type_rec serv_strm_type_csr%ROWTYPE; --added this cursor in the spec
4199: l_pdt_id_rec l_hdr_pdt_csr%ROWTYPE;
4200: l_sty_id strm_rec_type;

Line 4197: l_pth_exp_selv_tbl okl_streams_pub.selv_tbl_type;

4193: --Bug 13448352: RGOOTY: End
4194:
4195: l_pt_tbl_tmp okl_streams_pub.selv_tbl_type;
4196: l_pth_selv_tbl okl_streams_pub.selv_tbl_type;
4197: l_pth_exp_selv_tbl okl_streams_pub.selv_tbl_type;
4198: l_serv_strm_type_rec serv_strm_type_csr%ROWTYPE; --added this cursor in the spec
4199: l_pdt_id_rec l_hdr_pdt_csr%ROWTYPE;
4200: l_sty_id strm_rec_type;
4201: l_stmv_rec okl_streams_pub.stmv_rec_type;

Line 4201: l_stmv_rec okl_streams_pub.stmv_rec_type;

4197: l_pth_exp_selv_tbl okl_streams_pub.selv_tbl_type;
4198: l_serv_strm_type_rec serv_strm_type_csr%ROWTYPE; --added this cursor in the spec
4199: l_pdt_id_rec l_hdr_pdt_csr%ROWTYPE;
4200: l_sty_id strm_rec_type;
4201: l_stmv_rec okl_streams_pub.stmv_rec_type;
4202: lx_stmv_rec okl_streams_pub.stmv_rec_type;
4203: lx_selv_tbl okl_streams_pvt.selv_tbl_type;
4204:
4205: BEGIN

Line 4202: lx_stmv_rec okl_streams_pub.stmv_rec_type;

4198: l_serv_strm_type_rec serv_strm_type_csr%ROWTYPE; --added this cursor in the spec
4199: l_pdt_id_rec l_hdr_pdt_csr%ROWTYPE;
4200: l_sty_id strm_rec_type;
4201: l_stmv_rec okl_streams_pub.stmv_rec_type;
4202: lx_stmv_rec okl_streams_pub.stmv_rec_type;
4203: lx_selv_tbl okl_streams_pvt.selv_tbl_type;
4204:
4205: BEGIN
4206:

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

4381: --Added by kthiruva on 09-Feb-2006
4382: --Bug 5029161 - Start of Changes
4383: --Made change by bkatraga for bug 8226735
4384: IF l_pth_exp_selv_tbl.COUNT > 0 THEN
4385: okl_streams_pub.create_streams(p_api_version => p_api_version,
4386: p_init_msg_list => p_init_msg_list,
4387: x_return_status => x_return_status,
4388: x_msg_count => x_msg_count,
4389: x_msg_data => x_msg_data,

Line 4462: l_stmv_rec Okl_Streams_pub.stmv_rec_type;

4458:
4459:
4460: l_ctrt_cap_amnt NUMBER := p_ctrt_cap_amnt;
4461:
4462: l_stmv_rec Okl_Streams_pub.stmv_rec_type;
4463: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
4464: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
4465: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
4466:

Line 4463: l_selv_tbl Okl_Streams_pub.selv_tbl_type;

4459:
4460: l_ctrt_cap_amnt NUMBER := p_ctrt_cap_amnt;
4461:
4462: l_stmv_rec Okl_Streams_pub.stmv_rec_type;
4463: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
4464: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
4465: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
4466:
4467: i NUMBER;

Line 4464: x_stmv_rec Okl_Streams_pub.stmv_rec_type;

4460: l_ctrt_cap_amnt NUMBER := p_ctrt_cap_amnt;
4461:
4462: l_stmv_rec Okl_Streams_pub.stmv_rec_type;
4463: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
4464: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
4465: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
4466:
4467: i NUMBER;
4468: j NUMBER;

Line 4465: x_selv_tbl Okl_Streams_pub.selv_tbl_type;

4461:
4462: l_stmv_rec Okl_Streams_pub.stmv_rec_type;
4463: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
4464: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
4465: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
4466:
4467: i NUMBER;
4468: j NUMBER;
4469: k NUMBER;

Line 4536: Okl_Streams_Pub.create_streams(

4532: END LOOP;
4533:
4534:
4535:
4536: Okl_Streams_Pub.create_streams(
4537: p_api_version => l_api_version
4538: ,p_init_msg_list => p_init_msg_list
4539: ,x_return_status => l_return_status
4540: ,x_msg_count => x_msg_count

Line 4632: l_stmv_rec Okl_Streams_pub.stmv_rec_type;

4628: l_superTval NUMBER;
4629: l_alloc_value NUMBER;
4630: l_ctrt_cap_amnt NUMBER := p_ctrt_cap_amnt;
4631:
4632: l_stmv_rec Okl_Streams_pub.stmv_rec_type;
4633: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
4634: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
4635: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
4636:

Line 4633: l_selv_tbl Okl_Streams_pub.selv_tbl_type;

4629: l_alloc_value NUMBER;
4630: l_ctrt_cap_amnt NUMBER := p_ctrt_cap_amnt;
4631:
4632: l_stmv_rec Okl_Streams_pub.stmv_rec_type;
4633: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
4634: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
4635: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
4636:
4637: BEGIN

Line 4634: x_stmv_rec Okl_Streams_pub.stmv_rec_type;

4630: l_ctrt_cap_amnt NUMBER := p_ctrt_cap_amnt;
4631:
4632: l_stmv_rec Okl_Streams_pub.stmv_rec_type;
4633: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
4634: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
4635: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
4636:
4637: BEGIN
4638:

Line 4635: x_selv_tbl Okl_Streams_pub.selv_tbl_type;

4631:
4632: l_stmv_rec Okl_Streams_pub.stmv_rec_type;
4633: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
4634: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
4635: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
4636:
4637: BEGIN
4638:
4639: l_return_status := OKL_API.START_ACTIVITY(

Line 4700: Okl_Streams_Pub.update_streams(

4696:
4697: END LOOP;
4698:
4699:
4700: Okl_Streams_Pub.update_streams(
4701: p_api_version => l_api_version
4702: ,p_init_msg_list => p_init_msg_list
4703: ,x_return_status => l_return_status
4704: ,x_msg_count => x_msg_count

Line 4724: Okl_Streams_Pub.create_stream_elements(

4720: LOOP
4721: l_selv_tbl(i).stm_id := x_stmv_rec.id;
4722: END LOOP;
4723:
4724: Okl_Streams_Pub.create_stream_elements(
4725: p_api_version => l_api_version
4726: ,p_init_msg_list => p_init_msg_list
4727: ,x_return_status => l_return_status
4728: ,x_msg_count => x_msg_count

Line 5073: l_stmv_rec Okl_Streams_pub.stmv_rec_type;

5069: l_rl_rec1 l_rl_csr1%ROWTYPE;
5070: l_line_rec l_line_csr%ROWTYPE;
5071: l_strm_rec l_strm_csr%ROWTYPE;
5072: l_styid_rec get_styid_csr%ROWTYPE;
5073: l_stmv_rec Okl_Streams_pub.stmv_rec_type;
5074: l_stmv_rec_intm_rentals Okl_Streams_pub.stmv_rec_type;
5075: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
5076: l_selv_tbl_intm_rentals Okl_Streams_pub.selv_tbl_type;
5077: x_stmv_rec Okl_Streams_pub.stmv_rec_type;

Line 5074: l_stmv_rec_intm_rentals Okl_Streams_pub.stmv_rec_type;

5070: l_line_rec l_line_csr%ROWTYPE;
5071: l_strm_rec l_strm_csr%ROWTYPE;
5072: l_styid_rec get_styid_csr%ROWTYPE;
5073: l_stmv_rec Okl_Streams_pub.stmv_rec_type;
5074: l_stmv_rec_intm_rentals Okl_Streams_pub.stmv_rec_type;
5075: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
5076: l_selv_tbl_intm_rentals Okl_Streams_pub.selv_tbl_type;
5077: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
5078: x_selv_tbl Okl_Streams_pub.selv_tbl_type;

Line 5075: l_selv_tbl Okl_Streams_pub.selv_tbl_type;

5071: l_strm_rec l_strm_csr%ROWTYPE;
5072: l_styid_rec get_styid_csr%ROWTYPE;
5073: l_stmv_rec Okl_Streams_pub.stmv_rec_type;
5074: l_stmv_rec_intm_rentals Okl_Streams_pub.stmv_rec_type;
5075: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
5076: l_selv_tbl_intm_rentals Okl_Streams_pub.selv_tbl_type;
5077: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
5078: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
5079: l_stmv_rec_secure Okl_Streams_pub.stmv_rec_type;

Line 5076: l_selv_tbl_intm_rentals Okl_Streams_pub.selv_tbl_type;

5072: l_styid_rec get_styid_csr%ROWTYPE;
5073: l_stmv_rec Okl_Streams_pub.stmv_rec_type;
5074: l_stmv_rec_intm_rentals Okl_Streams_pub.stmv_rec_type;
5075: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
5076: l_selv_tbl_intm_rentals Okl_Streams_pub.selv_tbl_type;
5077: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
5078: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
5079: l_stmv_rec_secure Okl_Streams_pub.stmv_rec_type;
5080: l_selv_tbl_secure Okl_Streams_pub.selv_tbl_type;

Line 5077: x_stmv_rec Okl_Streams_pub.stmv_rec_type;

5073: l_stmv_rec Okl_Streams_pub.stmv_rec_type;
5074: l_stmv_rec_intm_rentals Okl_Streams_pub.stmv_rec_type;
5075: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
5076: l_selv_tbl_intm_rentals Okl_Streams_pub.selv_tbl_type;
5077: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
5078: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
5079: l_stmv_rec_secure Okl_Streams_pub.stmv_rec_type;
5080: l_selv_tbl_secure Okl_Streams_pub.selv_tbl_type;
5081: lx_stmv_rec_secure Okl_Streams_pub.stmv_rec_type;

Line 5078: x_selv_tbl Okl_Streams_pub.selv_tbl_type;

5074: l_stmv_rec_intm_rentals Okl_Streams_pub.stmv_rec_type;
5075: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
5076: l_selv_tbl_intm_rentals Okl_Streams_pub.selv_tbl_type;
5077: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
5078: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
5079: l_stmv_rec_secure Okl_Streams_pub.stmv_rec_type;
5080: l_selv_tbl_secure Okl_Streams_pub.selv_tbl_type;
5081: lx_stmv_rec_secure Okl_Streams_pub.stmv_rec_type;
5082: lx_selv_tbl_secure Okl_Streams_pub.selv_tbl_type;

Line 5079: l_stmv_rec_secure Okl_Streams_pub.stmv_rec_type;

5075: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
5076: l_selv_tbl_intm_rentals Okl_Streams_pub.selv_tbl_type;
5077: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
5078: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
5079: l_stmv_rec_secure Okl_Streams_pub.stmv_rec_type;
5080: l_selv_tbl_secure Okl_Streams_pub.selv_tbl_type;
5081: lx_stmv_rec_secure Okl_Streams_pub.stmv_rec_type;
5082: lx_selv_tbl_secure Okl_Streams_pub.selv_tbl_type;
5083: lx_inv_agmt_chr_id_tbl okl_securitization_pvt.inv_agmt_chr_id_tbl_type;

Line 5080: l_selv_tbl_secure Okl_Streams_pub.selv_tbl_type;

5076: l_selv_tbl_intm_rentals Okl_Streams_pub.selv_tbl_type;
5077: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
5078: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
5079: l_stmv_rec_secure Okl_Streams_pub.stmv_rec_type;
5080: l_selv_tbl_secure Okl_Streams_pub.selv_tbl_type;
5081: lx_stmv_rec_secure Okl_Streams_pub.stmv_rec_type;
5082: lx_selv_tbl_secure Okl_Streams_pub.selv_tbl_type;
5083: lx_inv_agmt_chr_id_tbl okl_securitization_pvt.inv_agmt_chr_id_tbl_type;
5084: BEGIN

Line 5081: lx_stmv_rec_secure Okl_Streams_pub.stmv_rec_type;

5077: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
5078: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
5079: l_stmv_rec_secure Okl_Streams_pub.stmv_rec_type;
5080: l_selv_tbl_secure Okl_Streams_pub.selv_tbl_type;
5081: lx_stmv_rec_secure Okl_Streams_pub.stmv_rec_type;
5082: lx_selv_tbl_secure Okl_Streams_pub.selv_tbl_type;
5083: lx_inv_agmt_chr_id_tbl okl_securitization_pvt.inv_agmt_chr_id_tbl_type;
5084: BEGIN
5085: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 5082: lx_selv_tbl_secure Okl_Streams_pub.selv_tbl_type;

5078: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
5079: l_stmv_rec_secure Okl_Streams_pub.stmv_rec_type;
5080: l_selv_tbl_secure Okl_Streams_pub.selv_tbl_type;
5081: lx_stmv_rec_secure Okl_Streams_pub.stmv_rec_type;
5082: lx_selv_tbl_secure Okl_Streams_pub.selv_tbl_type;
5083: lx_inv_agmt_chr_id_tbl okl_securitization_pvt.inv_agmt_chr_id_tbl_type;
5084: BEGIN
5085: x_return_status := OKL_API.G_RET_STS_SUCCESS;
5086: -- Call start_activity to create savepoint, check compatibility

Line 5248: Okl_Streams_Pub.create_streams(

5244: --l_selv_tbl_intm_rentals(1).date_billed := sysdate;
5245: --l_stmv_rec_intm_rentals.sty_id := l_styid_rec.id;
5246: l_stmv_rec_intm_rentals.sty_id := styid.id;
5247: IF l_selv_tbl_intm_rentals(1).amount <> 0 THEN
5248: Okl_Streams_Pub.create_streams(
5249: p_api_version => p_api_version,
5250: p_init_msg_list => p_init_msg_list,
5251: x_return_status => x_return_status,
5252: x_msg_count => x_msg_count,

Line 5376: okl_streams_pub.create_streams(

5372: l_selv_tbl_secure(1).amount := ln_secure_amt * -1;
5373:
5374: IF l_selv_tbl_secure(1).amount <> 0 THEN
5375:
5376: okl_streams_pub.create_streams(
5377: p_api_version => p_api_version,
5378: p_init_msg_list => p_init_msg_list,
5379: x_return_status => x_return_status,
5380: x_msg_count => x_msg_count,

Line 5457: Okl_Streams_Pub.create_streams(

5453: --l_selv_tbl_intm_rentals(1).date_billed := sysdate;
5454: --l_stmv_rec_intm_rentals.sty_id := l_styid_rec.id;
5455: l_stmv_rec_intm_rentals.sty_id := styid.id;
5456: IF l_selv_tbl_intm_rentals(1).amount <> 0 THEN
5457: Okl_Streams_Pub.create_streams(
5458: p_api_version => p_api_version,
5459: p_init_msg_list => p_init_msg_list,
5460: x_return_status => x_return_status,
5461: x_msg_count => x_msg_count,

Line 5670: l_stmv_rec Okl_Streams_pub.stmv_rec_type;

5666: l_pdt_id_rec l_hdr_pdt_csr%ROWTYPE;
5667: r_line_rec l_line_csr%ROWTYPE;
5668: l_strm_rec l_trx_num_csr%ROWTYPE;
5669: l_styid_rec get_styid_csr%ROWTYPE;
5670: l_stmv_rec Okl_Streams_pub.stmv_rec_type;
5671: l_stmv_rec_intm_rentals Okl_Streams_pub.stmv_rec_type;
5672: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
5673: l_selv_tbl_intm_rentals Okl_Streams_pub.selv_tbl_type;
5674: x_stmv_rec Okl_Streams_pub.stmv_rec_type;

Line 5671: l_stmv_rec_intm_rentals Okl_Streams_pub.stmv_rec_type;

5667: r_line_rec l_line_csr%ROWTYPE;
5668: l_strm_rec l_trx_num_csr%ROWTYPE;
5669: l_styid_rec get_styid_csr%ROWTYPE;
5670: l_stmv_rec Okl_Streams_pub.stmv_rec_type;
5671: l_stmv_rec_intm_rentals Okl_Streams_pub.stmv_rec_type;
5672: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
5673: l_selv_tbl_intm_rentals Okl_Streams_pub.selv_tbl_type;
5674: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
5675: x_selv_tbl Okl_Streams_pub.selv_tbl_type;

Line 5672: l_selv_tbl Okl_Streams_pub.selv_tbl_type;

5668: l_strm_rec l_trx_num_csr%ROWTYPE;
5669: l_styid_rec get_styid_csr%ROWTYPE;
5670: l_stmv_rec Okl_Streams_pub.stmv_rec_type;
5671: l_stmv_rec_intm_rentals Okl_Streams_pub.stmv_rec_type;
5672: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
5673: l_selv_tbl_intm_rentals Okl_Streams_pub.selv_tbl_type;
5674: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
5675: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
5676: l_stmv_rec_secure Okl_Streams_pub.stmv_rec_type;

Line 5673: l_selv_tbl_intm_rentals Okl_Streams_pub.selv_tbl_type;

5669: l_styid_rec get_styid_csr%ROWTYPE;
5670: l_stmv_rec Okl_Streams_pub.stmv_rec_type;
5671: l_stmv_rec_intm_rentals Okl_Streams_pub.stmv_rec_type;
5672: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
5673: l_selv_tbl_intm_rentals Okl_Streams_pub.selv_tbl_type;
5674: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
5675: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
5676: l_stmv_rec_secure Okl_Streams_pub.stmv_rec_type;
5677: l_selv_tbl_secure Okl_Streams_pub.selv_tbl_type;

Line 5674: x_stmv_rec Okl_Streams_pub.stmv_rec_type;

5670: l_stmv_rec Okl_Streams_pub.stmv_rec_type;
5671: l_stmv_rec_intm_rentals Okl_Streams_pub.stmv_rec_type;
5672: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
5673: l_selv_tbl_intm_rentals Okl_Streams_pub.selv_tbl_type;
5674: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
5675: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
5676: l_stmv_rec_secure Okl_Streams_pub.stmv_rec_type;
5677: l_selv_tbl_secure Okl_Streams_pub.selv_tbl_type;
5678: lx_stmv_rec_secure Okl_Streams_pub.stmv_rec_type;

Line 5675: x_selv_tbl Okl_Streams_pub.selv_tbl_type;

5671: l_stmv_rec_intm_rentals Okl_Streams_pub.stmv_rec_type;
5672: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
5673: l_selv_tbl_intm_rentals Okl_Streams_pub.selv_tbl_type;
5674: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
5675: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
5676: l_stmv_rec_secure Okl_Streams_pub.stmv_rec_type;
5677: l_selv_tbl_secure Okl_Streams_pub.selv_tbl_type;
5678: lx_stmv_rec_secure Okl_Streams_pub.stmv_rec_type;
5679: lx_selv_tbl_secure Okl_Streams_pub.selv_tbl_type;

Line 5676: l_stmv_rec_secure Okl_Streams_pub.stmv_rec_type;

5672: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
5673: l_selv_tbl_intm_rentals Okl_Streams_pub.selv_tbl_type;
5674: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
5675: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
5676: l_stmv_rec_secure Okl_Streams_pub.stmv_rec_type;
5677: l_selv_tbl_secure Okl_Streams_pub.selv_tbl_type;
5678: lx_stmv_rec_secure Okl_Streams_pub.stmv_rec_type;
5679: lx_selv_tbl_secure Okl_Streams_pub.selv_tbl_type;
5680: lx_inv_agmt_chr_id_tbl okl_securitization_pvt.inv_agmt_chr_id_tbl_type;

Line 5677: l_selv_tbl_secure Okl_Streams_pub.selv_tbl_type;

5673: l_selv_tbl_intm_rentals Okl_Streams_pub.selv_tbl_type;
5674: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
5675: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
5676: l_stmv_rec_secure Okl_Streams_pub.stmv_rec_type;
5677: l_selv_tbl_secure Okl_Streams_pub.selv_tbl_type;
5678: lx_stmv_rec_secure Okl_Streams_pub.stmv_rec_type;
5679: lx_selv_tbl_secure Okl_Streams_pub.selv_tbl_type;
5680: lx_inv_agmt_chr_id_tbl okl_securitization_pvt.inv_agmt_chr_id_tbl_type;
5681: Begin

Line 5678: lx_stmv_rec_secure Okl_Streams_pub.stmv_rec_type;

5674: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
5675: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
5676: l_stmv_rec_secure Okl_Streams_pub.stmv_rec_type;
5677: l_selv_tbl_secure Okl_Streams_pub.selv_tbl_type;
5678: lx_stmv_rec_secure Okl_Streams_pub.stmv_rec_type;
5679: lx_selv_tbl_secure Okl_Streams_pub.selv_tbl_type;
5680: lx_inv_agmt_chr_id_tbl okl_securitization_pvt.inv_agmt_chr_id_tbl_type;
5681: Begin
5682: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 5679: lx_selv_tbl_secure Okl_Streams_pub.selv_tbl_type;

5675: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
5676: l_stmv_rec_secure Okl_Streams_pub.stmv_rec_type;
5677: l_selv_tbl_secure Okl_Streams_pub.selv_tbl_type;
5678: lx_stmv_rec_secure Okl_Streams_pub.stmv_rec_type;
5679: lx_selv_tbl_secure Okl_Streams_pub.selv_tbl_type;
5680: lx_inv_agmt_chr_id_tbl okl_securitization_pvt.inv_agmt_chr_id_tbl_type;
5681: Begin
5682: x_return_status := OKL_API.G_RET_STS_SUCCESS;
5683: -- Call start_activity to create savepoint, check compatibility

Line 5815: Okl_Streams_Pub.create_streams(

5811: l_selv_tbl_intm_rentals(1).stream_element_date := sysdate;
5812: l_selv_tbl_intm_rentals(1).se_line_number := 1;
5813: l_selv_tbl_intm_rentals(1).comments := 'Interim Rentals for a Mass Rebooked Rentals';
5814: IF l_selv_tbl_intm_rentals(1).amount <> 0 THEN
5815: Okl_Streams_Pub.create_streams(
5816: p_api_version => p_api_version,
5817: p_init_msg_list => p_init_msg_list,
5818: x_return_status => x_return_status,
5819: x_msg_count => x_msg_count,

Line 5932: okl_streams_pub.create_streams(

5928: l_stmv_rec_secure.source_id := lx_inv_agmt_chr_id_tbl(i).khr_id;
5929: l_stmv_rec_secure.source_table := 'OKL_K_HEADERS';
5930: l_selv_tbl_secure(1).amount := ln_secure_amt * -1;
5931: IF l_selv_tbl_secure(1).amount <> 0 THEN
5932: okl_streams_pub.create_streams(
5933: p_api_version => p_api_version,
5934: p_init_msg_list => p_init_msg_list,
5935: x_return_status => x_return_status,
5936: x_msg_count => x_msg_count,

Line 6013: Okl_Streams_Pub.create_streams(

6009: l_selv_tbl_intm_rentals(1).stream_element_date := sysdate;
6010: l_selv_tbl_intm_rentals(1).se_line_number := 1;
6011: l_selv_tbl_intm_rentals(1).comments := 'Interim Rentals for a Mass Rebooked Rentals';
6012: IF l_selv_tbl_intm_rentals(1).amount <> 0 THEN
6013: Okl_Streams_Pub.create_streams(
6014: p_api_version => p_api_version,
6015: p_init_msg_list => p_init_msg_list,
6016: x_return_status => x_return_status,
6017: x_msg_count => x_msg_count,

Line 6142: l_stmv_rec okl_streams_pub.stmv_rec_type;

6138: error VARCHAR2(256);
6139: --styid NUMBER;
6140: styid strm_rec_type;
6141: stream_name VARCHAR2(256);
6142: l_stmv_rec okl_streams_pub.stmv_rec_type;
6143: l_stmv_rec_adv_rentals okl_streams_pub.stmv_rec_type;
6144: l_selv_tbl okl_streams_pub.selv_tbl_type;
6145: l_selv_tbl_adv_rentals okl_streams_pub.selv_tbl_type;
6146: x_stmv_rec okl_streams_pub.stmv_rec_type;

Line 6143: l_stmv_rec_adv_rentals okl_streams_pub.stmv_rec_type;

6139: --styid NUMBER;
6140: styid strm_rec_type;
6141: stream_name VARCHAR2(256);
6142: l_stmv_rec okl_streams_pub.stmv_rec_type;
6143: l_stmv_rec_adv_rentals okl_streams_pub.stmv_rec_type;
6144: l_selv_tbl okl_streams_pub.selv_tbl_type;
6145: l_selv_tbl_adv_rentals okl_streams_pub.selv_tbl_type;
6146: x_stmv_rec okl_streams_pub.stmv_rec_type;
6147: x_selv_tbl okl_streams_pub.selv_tbl_type;

Line 6144: l_selv_tbl okl_streams_pub.selv_tbl_type;

6140: styid strm_rec_type;
6141: stream_name VARCHAR2(256);
6142: l_stmv_rec okl_streams_pub.stmv_rec_type;
6143: l_stmv_rec_adv_rentals okl_streams_pub.stmv_rec_type;
6144: l_selv_tbl okl_streams_pub.selv_tbl_type;
6145: l_selv_tbl_adv_rentals okl_streams_pub.selv_tbl_type;
6146: x_stmv_rec okl_streams_pub.stmv_rec_type;
6147: x_selv_tbl okl_streams_pub.selv_tbl_type;
6148:

Line 6145: l_selv_tbl_adv_rentals okl_streams_pub.selv_tbl_type;

6141: stream_name VARCHAR2(256);
6142: l_stmv_rec okl_streams_pub.stmv_rec_type;
6143: l_stmv_rec_adv_rentals okl_streams_pub.stmv_rec_type;
6144: l_selv_tbl okl_streams_pub.selv_tbl_type;
6145: l_selv_tbl_adv_rentals okl_streams_pub.selv_tbl_type;
6146: x_stmv_rec okl_streams_pub.stmv_rec_type;
6147: x_selv_tbl okl_streams_pub.selv_tbl_type;
6148:
6149: --Modified for streams performance

Line 6146: x_stmv_rec okl_streams_pub.stmv_rec_type;

6142: l_stmv_rec okl_streams_pub.stmv_rec_type;
6143: l_stmv_rec_adv_rentals okl_streams_pub.stmv_rec_type;
6144: l_selv_tbl okl_streams_pub.selv_tbl_type;
6145: l_selv_tbl_adv_rentals okl_streams_pub.selv_tbl_type;
6146: x_stmv_rec okl_streams_pub.stmv_rec_type;
6147: x_selv_tbl okl_streams_pub.selv_tbl_type;
6148:
6149: --Modified for streams performance
6150: -- This cursors fetches all the line id's for the contract whose Rent streams

Line 6147: x_selv_tbl okl_streams_pub.selv_tbl_type;

6143: l_stmv_rec_adv_rentals okl_streams_pub.stmv_rec_type;
6144: l_selv_tbl okl_streams_pub.selv_tbl_type;
6145: l_selv_tbl_adv_rentals okl_streams_pub.selv_tbl_type;
6146: x_stmv_rec okl_streams_pub.stmv_rec_type;
6147: x_selv_tbl okl_streams_pub.selv_tbl_type;
6148:
6149: --Modified for streams performance
6150: -- This cursors fetches all the line id's for the contract whose Rent streams
6151: -- have a structure that is not -1 or 0

Line 6519: okl_streams_pub.update_streams(

6515: --Assigning the value of the sum of the last n element amounts to the first advance rent stream
6516: l_selv_tbl_adv_rentals(1).amount := l_pay_amount;
6517: --Bug 4414441 - End of Changes
6518: -- update the rent streams for ESG to reflect uniform rental payment
6519: okl_streams_pub.update_streams(
6520: p_api_version => l_api_version
6521: ,p_init_msg_list => p_init_msg_list
6522: ,x_return_status => x_return_status
6523: ,x_msg_count => x_msg_count

Line 6542: okl_streams_pub.create_streams(

6538: l_selv_tbl_adv_rentals(1).amount := l_pay_amount;
6539: END IF;
6540:
6541: l_stmv_rec_adv_rentals.sty_id := styid.id;
6542: okl_streams_pub.create_streams(
6543: p_api_version => l_api_version
6544: ,p_init_msg_list => p_init_msg_list
6545: ,x_return_status => x_return_status
6546: ,x_msg_count => x_msg_count

Line 6897: l_stmv_tbl okl_streams_pub.stmv_tbl_type;

6893: l_strm_index NUMBER;
6894: l_sel_index NUMBER;
6895: l_prev_stm_id OKL_STREAMS.ID%TYPE;
6896: l_terminated_date DATE;
6897: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
6898: lx_stmv_tbl okl_streams_pub.stmv_tbl_type;
6899: l_selv_tbl okl_streams_pub.selv_tbl_type;
6900: lx_selv_tbl okl_streams_pub.selv_tbl_type;
6901: l_kle_id OKC_K_LINES_B.ID%TYPE;

Line 6898: lx_stmv_tbl okl_streams_pub.stmv_tbl_type;

6894: l_sel_index NUMBER;
6895: l_prev_stm_id OKL_STREAMS.ID%TYPE;
6896: l_terminated_date DATE;
6897: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
6898: lx_stmv_tbl okl_streams_pub.stmv_tbl_type;
6899: l_selv_tbl okl_streams_pub.selv_tbl_type;
6900: lx_selv_tbl okl_streams_pub.selv_tbl_type;
6901: l_kle_id OKC_K_LINES_B.ID%TYPE;
6902:

Line 6899: l_selv_tbl okl_streams_pub.selv_tbl_type;

6895: l_prev_stm_id OKL_STREAMS.ID%TYPE;
6896: l_terminated_date DATE;
6897: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
6898: lx_stmv_tbl okl_streams_pub.stmv_tbl_type;
6899: l_selv_tbl okl_streams_pub.selv_tbl_type;
6900: lx_selv_tbl okl_streams_pub.selv_tbl_type;
6901: l_kle_id OKC_K_LINES_B.ID%TYPE;
6902:
6903: BEGIN

Line 6900: lx_selv_tbl okl_streams_pub.selv_tbl_type;

6896: l_terminated_date DATE;
6897: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
6898: lx_stmv_tbl okl_streams_pub.stmv_tbl_type;
6899: l_selv_tbl okl_streams_pub.selv_tbl_type;
6900: lx_selv_tbl okl_streams_pub.selv_tbl_type;
6901: l_kle_id OKC_K_LINES_B.ID%TYPE;
6902:
6903: BEGIN
6904:

Line 6959: OKL_STREAMS_PUB.CREATE_STREAMS_PERF(p_api_version

6955: END LOOP;
6956:
6957: IF l_stmv_tbl.COUNT > 0 THEN
6958: -- Call the API to bulk insert data into streams and stream elements
6959: OKL_STREAMS_PUB.CREATE_STREAMS_PERF(p_api_version
6960: , p_init_msg_list
6961: , x_return_status
6962: , x_msg_count
6963: , x_msg_data

Line 7167: l_stmv_tbl okl_streams_pub.stmv_tbl_type;

7163: l_pdt_id_rec l_hdr_pdt_csr%ROWTYPE;
7164: l_strm_rec strm_csr%ROWTYPE;
7165: l_strms_rec strms_csr%ROWTYPE;
7166:
7167: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
7168: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
7169: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
7170: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
7171:

Line 7168: x_stmv_tbl okl_streams_pub.stmv_tbl_type;

7164: l_strm_rec strm_csr%ROWTYPE;
7165: l_strms_rec strms_csr%ROWTYPE;
7166:
7167: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
7168: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
7169: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
7170: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
7171:
7172: -- Code for bulk update -02/28/2004 - HKPATEL

Line 7169: l_selv_tbl Okl_Streams_pub.selv_tbl_type;

7165: l_strms_rec strms_csr%ROWTYPE;
7166:
7167: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
7168: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
7169: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
7170: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
7171:
7172: -- Code for bulk update -02/28/2004 - HKPATEL
7173: l_id_tbl okl_streams_util.NumberTabTyp;

Line 7170: x_selv_tbl Okl_Streams_pub.selv_tbl_type;

7166:
7167: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
7168: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
7169: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
7170: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
7171:
7172: -- Code for bulk update -02/28/2004 - HKPATEL
7173: l_id_tbl okl_streams_util.NumberTabTyp;
7174: l_say_code_tbl okl_streams_util.Var10TabTyp;

Line 7574: Okl_Streams_pub.update_streams(

7570: END LOOP;
7571: If ( l_id_tbl.COUNT > 0 ) Then
7572: /* Commented for Bulk update by HKPATEL -02/18/2005
7573: If ( l_stmv_tbl.COUNT > 0 ) Then
7574: Okl_Streams_pub.update_streams(
7575: p_api_version => p_api_version,
7576: p_init_msg_list => p_init_msg_list,
7577: x_return_status => x_return_status,
7578: x_msg_count => x_msg_count,

Line 7701: Okl_Streams_pub.delete_stream_elements(

7697:
7698:
7699: If ( i > 0 ) Then
7700:
7701: Okl_Streams_pub.delete_stream_elements(
7702: p_api_version => p_api_version,
7703: p_init_msg_list => p_init_msg_list,
7704: x_return_status => x_return_status,
7705: x_msg_count => x_msg_count,

Line 7849: l_stmv_tbl okl_streams_pub.stmv_tbl_type;

7845:
7846: -- vdamerla Forward Ported Bug6149951 ends
7847:
7848: -- Declare records/table types
7849: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
7850: lx_stmv_tbl okl_streams_pub.stmv_tbl_type;
7851: l_selv_tbl okl_streams_pub.selv_tbl_type;
7852: lx_selv_tbl okl_streams_pub.selv_tbl_type;
7853: -- vdamerla Forward Port

Line 7850: lx_stmv_tbl okl_streams_pub.stmv_tbl_type;

7846: -- vdamerla Forward Ported Bug6149951 ends
7847:
7848: -- Declare records/table types
7849: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
7850: lx_stmv_tbl okl_streams_pub.stmv_tbl_type;
7851: l_selv_tbl okl_streams_pub.selv_tbl_type;
7852: lx_selv_tbl okl_streams_pub.selv_tbl_type;
7853: -- vdamerla Forward Port
7854: -- Cursor to get fees linked to a terminated Asset

Line 7851: l_selv_tbl okl_streams_pub.selv_tbl_type;

7847:
7848: -- Declare records/table types
7849: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
7850: lx_stmv_tbl okl_streams_pub.stmv_tbl_type;
7851: l_selv_tbl okl_streams_pub.selv_tbl_type;
7852: lx_selv_tbl okl_streams_pub.selv_tbl_type;
7853: -- vdamerla Forward Port
7854: -- Cursor to get fees linked to a terminated Asset
7855: CURSOR c_lnk_fin_rol_trm_fee (cp_chr_id OKC_K_HEADERS_B.ID%TYPE) IS

Line 7852: lx_selv_tbl okl_streams_pub.selv_tbl_type;

7848: -- Declare records/table types
7849: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
7850: lx_stmv_tbl okl_streams_pub.stmv_tbl_type;
7851: l_selv_tbl okl_streams_pub.selv_tbl_type;
7852: lx_selv_tbl okl_streams_pub.selv_tbl_type;
7853: -- vdamerla Forward Port
7854: -- Cursor to get fees linked to a terminated Asset
7855: CURSOR c_lnk_fin_rol_trm_fee (cp_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
7856: SELECT LNK_CLE.ID LNK_ID

Line 8523: OKL_STREAMS_PUB.CREATE_STREAMS_PERF(p_api_version

8519:
8520: -- STEP 3
8521: IF l_stmv_tbl.COUNT > 0 THEN
8522: -- Call the API to bulk insert data into streams and stream elements
8523: OKL_STREAMS_PUB.CREATE_STREAMS_PERF(p_api_version
8524: , p_init_msg_list
8525: , x_return_status
8526: , x_msg_count
8527: , x_msg_data

Line 8704: m_stmv_tbl okl_streams_pub.stmv_tbl_type;

8700: -- Bug 4737555 - End of Changes
8701:
8702: lv_pdt_no_rep VARCHAR2(3) := 'N';
8703: j NUMBER := 0;
8704: m_stmv_tbl okl_streams_pub.stmv_tbl_type;
8705: mx_stmv_tbl okl_streams_pub.stmv_tbl_type;
8706: ylds_rec ylds_csr%ROWTYPE;
8707:
8708: l_strm_rec strm_csr%ROWTYPE;

Line 8705: mx_stmv_tbl okl_streams_pub.stmv_tbl_type;

8701:
8702: lv_pdt_no_rep VARCHAR2(3) := 'N';
8703: j NUMBER := 0;
8704: m_stmv_tbl okl_streams_pub.stmv_tbl_type;
8705: mx_stmv_tbl okl_streams_pub.stmv_tbl_type;
8706: ylds_rec ylds_csr%ROWTYPE;
8707:
8708: l_strm_rec strm_csr%ROWTYPE;
8709: l_stmv_tbl okl_streams_pub.stmv_tbl_type;

Line 8709: l_stmv_tbl okl_streams_pub.stmv_tbl_type;

8705: mx_stmv_tbl okl_streams_pub.stmv_tbl_type;
8706: ylds_rec ylds_csr%ROWTYPE;
8707:
8708: l_strm_rec strm_csr%ROWTYPE;
8709: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
8710: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
8711:
8712: i NUMBER;
8713: l_tcnCode VARCHAR2(256);

Line 8710: x_stmv_tbl okl_streams_pub.stmv_tbl_type;

8706: ylds_rec ylds_csr%ROWTYPE;
8707:
8708: l_strm_rec strm_csr%ROWTYPE;
8709: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
8710: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
8711:
8712: i NUMBER;
8713: l_tcnCode VARCHAR2(256);
8714: l_transaction_type VARCHAR2(256) := 'Miscellaneous';--'Generate Yields';

Line 8937: Okl_Streams_pub.delete_streams(

8933: l_stmv_tbl(i).sgn_code := l_strms_rep_rec.SGN_CODE;
8934: l_stmv_tbl(i).transaction_number := l_strms_rep_rec.TRN_NUM;
8935: END LOOP;
8936: IF i > 0 THEN
8937: Okl_Streams_pub.delete_streams(
8938: p_api_version => p_api_version,
8939: p_init_msg_list => p_init_msg_list,
8940: x_return_status => x_return_status,
8941: x_msg_count => x_msg_count,

Line 9028: Okl_Streams_pub.delete_streams(

9024: l_stmv_tbl(i).sgn_code := l_strms_rep_rec.SGN_CODE;
9025: l_stmv_tbl(i).transaction_number := l_strms_rep_rec.TRN_NUM;
9026: END LOOP;
9027: IF i > 0 THEN
9028: Okl_Streams_pub.delete_streams(
9029: p_api_version => p_api_version,
9030: p_init_msg_list => p_init_msg_list,
9031: x_return_status => x_return_status,
9032: x_msg_count => x_msg_count,

Line 9151: okl_streams_pub.update_streams(

9147: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9148: END;
9149: /* Commented for Bulk Update - HKPATEL - 02/18/2004
9150: IF (m_stmv_tbl.COUNT > 0) THEN
9151: okl_streams_pub.update_streams(
9152: p_api_version => p_api_version,
9153: p_init_msg_list => p_init_msg_list,
9154: x_return_status => x_return_status,
9155: x_msg_count => x_msg_count,

Line 22412: l_stmv_tbl okl_streams_pub.stmv_tbl_type;

22408:
22409: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
22410: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
22411:
22412: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
22413: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
22414:
22415: i NUMBER;
22416: l_lines_rec l_line_rec_csr%ROWTYPE;

Line 22413: x_stmv_tbl okl_streams_pub.stmv_tbl_type;

22409: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
22410: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
22411:
22412: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
22413: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
22414:
22415: i NUMBER;
22416: l_lines_rec l_line_rec_csr%ROWTYPE;
22417: l_transaction_type VARCHAR2(256):= 'Miscellaneous';--'Generate Yields';

Line 22837: l_stmv_rec Okl_Streams_pub.stmv_rec_type;

22833: l_api_name CONSTANT VARCHAR2(30) := 'GEN_STREAMS';
22834: l_api_version CONSTANT NUMBER := 1.0;
22835: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
22836:
22837: l_stmv_rec Okl_Streams_pub.stmv_rec_type;
22838: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
22839: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
22840: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
22841:

Line 22838: l_selv_tbl Okl_Streams_pub.selv_tbl_type;

22834: l_api_version CONSTANT NUMBER := 1.0;
22835: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
22836:
22837: l_stmv_rec Okl_Streams_pub.stmv_rec_type;
22838: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
22839: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
22840: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
22841:
22842: cursor l_rl_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,

Line 22839: x_stmv_rec Okl_Streams_pub.stmv_rec_type;

22835: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
22836:
22837: l_stmv_rec Okl_Streams_pub.stmv_rec_type;
22838: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
22839: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
22840: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
22841:
22842: cursor l_rl_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
22843: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,

Line 22840: x_selv_tbl Okl_Streams_pub.selv_tbl_type;

22836:
22837: l_stmv_rec Okl_Streams_pub.stmv_rec_type;
22838: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
22839: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
22840: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
22841:
22842: cursor l_rl_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
22843: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
22844: chrId NUMBER,

Line 23001: Okl_Streams_Pub.create_streams(

22997: j := j + k;
22998:
22999: END LOOP;
23000:
23001: Okl_Streams_Pub.create_streams(
23002: p_api_version => l_api_version
23003: ,p_init_msg_list => p_init_msg_list
23004: ,x_return_status => l_return_status
23005: ,x_msg_count => x_msg_count

Line 23183: l_stmv_tbl okl_streams_pub.stmv_tbl_type;

23179: p_pdtv_rec pdtv_rec_type;
23180: x_pdt_parameter_rec pdt_param_rec_type;
23181: x_no_data_found BOOLEAN;
23182:
23183: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
23184: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
23185: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
23186: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
23187: l_strms_orig_rec strms_csr%ROWTYPE;

Line 23184: x_stmv_tbl okl_streams_pub.stmv_tbl_type;

23180: x_pdt_parameter_rec pdt_param_rec_type;
23181: x_no_data_found BOOLEAN;
23182:
23183: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
23184: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
23185: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
23186: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
23187: l_strms_orig_rec strms_csr%ROWTYPE;
23188: l_strms_rep_rec strms_csr%ROWTYPE;

Line 23185: l_selv_tbl Okl_Streams_pub.selv_tbl_type;

23181: x_no_data_found BOOLEAN;
23182:
23183: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
23184: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
23185: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
23186: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
23187: l_strms_orig_rec strms_csr%ROWTYPE;
23188: l_strms_rep_rec strms_csr%ROWTYPE;
23189: -- Code for bulk update -02/28/2004 - HKPATEL

Line 23186: x_selv_tbl Okl_Streams_pub.selv_tbl_type;

23182:
23183: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
23184: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
23185: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
23186: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
23187: l_strms_orig_rec strms_csr%ROWTYPE;
23188: l_strms_rep_rec strms_csr%ROWTYPE;
23189: -- Code for bulk update -02/28/2004 - HKPATEL
23190: l_id_tbl okl_streams_util.NumberTabTyp;

Line 23329: Okl_Streams_pub.update_streams(

23325: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
23326: END;
23327: /* Commented for Bulk update by HKPATEL -02/28/2004
23328: If ( l_stmv_tbl.COUNT > 0 ) Then
23329: Okl_Streams_pub.update_streams(
23330: p_api_version => p_api_version,
23331: p_init_msg_list => p_init_msg_list,
23332: x_return_status => x_return_status,
23333: x_msg_count => x_msg_count,