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

Line 1691: okl_streams str

1687: -- cursor to fetch the stream element amount
1688: CURSOR get_strmele_csr(p_khr_id NUMBER, p_strm_id NUMBER, p_sty_id NUMBER) IS
1689: SELECT ele.amount
1690: FROM okl_strm_elements ele,
1691: okl_streams str
1692: WHERE ele.stm_id = p_strm_id
1693: AND str.khr_id = p_khr_id
1694: AND str.sty_id = p_sty_id
1695: AND upper(str.say_code) = 'CURR'

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 3033: l_selv_tbl okl_streams_pvt.selv_tbl_type;

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;
3037: --srsreeni Bug 5917582 end

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 3038: lx_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;
3041: --srsreeni bug 5869271 start add
3042: l_old_cle_id okc_k_lines_b.ID%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 3109: FROM okl_streams stm

3105: CURSOR l_stmp_yn_csr(khrid NUMBER, p VARCHAR2) IS
3106: SELECT 'Y' What
3107: FROM dual
3108: WHERE EXISTS(SELECT stm.id stmid
3109: FROM okl_streams stm
3110: WHERE stm.khr_id = khrid
3111: --AND stm.say_code = 'CURR'
3112: AND stm.say_code = 'WORK'
3113: AND stm.sgn_code = 'STMP'

Line 3119: FROM okl_streams stm

3115: AND stm.active_yn = 'N');
3116: -- To get the stream information
3117: CURSOR l_stm_csr(khrid NUMBER, kleid NUMBER, styid NUMBER, p VARCHAR2) IS
3118: SELECT stm.id stmid
3119: FROM okl_streams stm
3120: WHERE stm.khr_id = khrid
3121: AND stm.kle_id = kleid
3122: AND stm.sty_id = styid
3123: AND stm.say_code = 'CURR'

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 3875: lx_selv_tbl okl_streams_pvt.selv_tbl_type;

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:
3879: FOR l_lne_rec in l_line_rec_csr ( p_chr_id, 'FEE' )

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 4203: lx_selv_tbl okl_streams_pvt.selv_tbl_type;

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:
4207: FOR l_lne_rec in l_line_rec_csr ( p_chr_id, 'SOLD_SERVICE' )

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 4806: From okl_streams str,

4802:
4803: Cursor l_strms_csr ( chrId NUMBER, st VARCHAR2 ) IS
4804: Select sty.id sty_id,
4805: sty.name
4806: From okl_streams str,
4807: okl_strm_type_tl sty
4808: Where sty.id = str.sty_id
4809: and str.khr_id = chrId
4810: and sty.name = st

Line 4974: FROM okl_streams str

4970: -- get the transaction number
4971: CURSOR l_strm_csr (chrId NUMBER, pp VARCHAR2 )
4972: IS
4973: SELECT DISTINCT str.transaction_number transaction_number
4974: FROM okl_streams str
4975: WHERE str.khr_id = chrId
4976: AND str.say_code = 'CURR'
4977: AND nvl(str.purpose_code, 'ORIGIN') = pp;
4978: -- Billable rents

Line 4986: okl_streams str,

4982: CURSOR l_billedrents_csr(chrId NUMBER, kleid NUMBER, p VARCHAR2)
4983: IS
4984: SELECT nvl(sum(ele.AMOUNT),0)
4985: FROM okl_strm_elements ele,
4986: okl_streams str,
4987: okl_strm_type_b sty
4988: WHERE str.khr_id = chrId
4989: AND nvl(str.kle_id, -1) = kleid
4990: AND str.sty_id = sty.id

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 5586: okl_streams str,

5582: p_purpose VARCHAR2)
5583: IS
5584: SELECT NVL(SUM(ele.AMOUNT),0) amount
5585: FROM okl_strm_elements ele,
5586: okl_streams str,
5587: okl_strm_type_b sty
5588: WHERE str.khr_id = p_chr_id
5589: AND NVL(str.kle_id, -1) = p_kle_id
5590: AND str.sty_id = sty.id

Line 5604: okl_streams str,

5600: p_purpose VARCHAR2)
5601: IS
5602: SELECT NVL(SUM(ele.AMOUNT),0) amount
5603: FROM okl_strm_elements ele,
5604: okl_streams str,
5605: okl_strm_type_b sty
5606: WHERE str.khr_id = p_chr_id
5607: AND NVL(str.kle_id, -1) = p_kle_id
5608: AND str.sty_id = sty.id

Line 5650: -- FROM okl_streams str

5646: -- get the transaction number
5647: CURSOR l_trx_num_csr
5648: IS
5649: -- SELECT DISTINCT str.transaction_number transaction_number
5650: -- FROM okl_streams str
5651: -- WHERE str.khr_id = p_chr_id
5652: -- AND str.say_code = 'CURR'
5653: -- AND nvl(str.purpose_code, 'ORIGIN') = p_purpose;
5654: SELECT OKL_SIF_SEQ.NEXTVAL

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 6221: FROM okl_streams str

6217: str.sty_id,
6218: str.say_code,
6219: str.active_yn,
6220: str.kle_id
6221: FROM okl_streams str
6222: WHERE str.khr_id = chrId
6223: AND str.kle_id = kleId
6224: AND str.say_code = 'WORK'
6225: --Added by kthiruva for Streams Performance Patch

Line 6247: FROM okl_streams stm

6243: ORDER BY ele.stream_element_date;
6244:
6245: CURSOR l_stmp_yn_csr(khrid NUMBER, p VARCHAR2) IS
6246: SELECT count(stm.id) cnt
6247: FROM okl_streams stm
6248: WHERE stm.khr_id = khrid
6249: AND stm.say_code = 'WORK'
6250: AND stm.sgn_code = 'STMP'
6251: AND nvl(stm.purpose_code, 'ORIGIN') = p;

Line 6271: l_rent_amt_tbl Okl_Streams_Util.NumberTabTyp;

6267: --Bug 4414441 - Start of Changes
6268: l_payment_rec l_payment_csr%ROWTYPE;
6269: TYPE l_payment_tbl_type IS TABLE OF l_payment_csr%ROWTYPE INDEX BY BINARY_INTEGER;
6270: l_payment_tbl l_payment_tbl_type;
6271: l_rent_amt_tbl Okl_Streams_Util.NumberTabTyp;
6272: k NUMBER;
6273: l_next_position NUMBER;
6274: --Bug 4414441 - End of Changes
6275: BEGIN

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 6645: FROM okl_streams

6641: IS
6642: SELECT 1
6643: FROM dual
6644: WHERE EXISTS (SELECT 1
6645: FROM okl_streams
6646: WHERE khr_id= p_dnz_chr_id
6647: AND say_code = 'WORK'
6648: AND sgn_code = 'STMP');
6649: -- Validate the contract has Subsidy line

Line 6866: , cp_trx_number okl_streams.transaction_number%TYPE) IS

6862: --Cursor to get the streams for terminated asset upto termination date
6863: CURSOR c_streams (cp_chr_id OKC_K_HEADERS_B.ID%TYPE
6864: , cp_cle_id OKC_K_LINES_B.ID%TYPE
6865: , cp_date_terminated DATE
6866: , cp_trx_number okl_streams.transaction_number%TYPE) IS
6867: SELECT STM.ID STREAM_ID
6868: , STM.STY_ID
6869: , STM.SGN_CODE
6870: , STM.PURPOSE_CODE

Line 6876: FROM OKL_STREAMS STM

6872: , SEL.STREAM_ELEMENT_DATE
6873: , SEL.AMOUNT
6874: , SEL.SE_LINE_NUMBER
6875: , SEL.COMMENTS
6876: FROM OKL_STREAMS STM
6877: , OKL_STRM_ELEMENTS SEL
6878: , OKL_STRM_TYPE_B STY
6879: WHERE SEL.STM_ID = STM.ID
6880: AND STM.KHR_ID = cp_chr_id

Line 6895: l_prev_stm_id OKL_STREAMS.ID%TYPE;

6891:
6892: l_api_name CONSTANT VARCHAR2(30) := 'COPY_VARIABLE_RATE_STREAMS';
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;

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 7034: FROM OKL_STREAMS STM

7030: CURSOR c_streams (cp_chr_id OKC_K_HEADERS_B.ID%TYPE
7031: , cp_cle_id OKC_K_LINES_B.ID%TYPE
7032: , cp_purpose VARCHAR2) IS
7033: SELECT STM.ID STREAM_ID
7034: FROM OKL_STREAMS STM
7035: , OKL_STRM_TYPE_B STY
7036: WHERE STM.KHR_ID = cp_chr_id
7037: AND STM.KLE_ID = cp_cle_id
7038: AND (nvl(STM.purpose_code,'ORIGIN') = cp_purpose)

Line 7097: UPDATE OKL_STREAMS

7093: FOR tmt_asset_rec IN c_tmt_assets (p_chr_id)
7094: LOOP
7095: FOR streams_rec IN c_streams (p_chr_id, tmt_asset_rec.LINE_ID, p_purpose)
7096: LOOP
7097: UPDATE OKL_STREAMS
7098: SET say_code = 'HIST',
7099: active_yn = 'N',
7100: date_history = sysdate,
7101: last_updated_by = FND_GLOBAL.USER_ID, -- BUG:14749215 changes start here

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 7173: l_id_tbl okl_streams_util.NumberTabTyp;

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;
7175: l_active_yn_tbl okl_streams_util.Var10TabTyp;
7176: l_date_history_tbl okl_streams_util.DateTabTyp;
7177: l_date_curr_tbl okl_streams_util.DateTabTyp;

Line 7174: l_say_code_tbl okl_streams_util.Var10TabTyp;

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;
7175: l_active_yn_tbl okl_streams_util.Var10TabTyp;
7176: l_date_history_tbl okl_streams_util.DateTabTyp;
7177: l_date_curr_tbl okl_streams_util.DateTabTyp;
7178:

Line 7175: l_active_yn_tbl okl_streams_util.Var10TabTyp;

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;
7175: l_active_yn_tbl okl_streams_util.Var10TabTyp;
7176: l_date_history_tbl okl_streams_util.DateTabTyp;
7177: l_date_curr_tbl okl_streams_util.DateTabTyp;
7178:
7179: -- Code for bulk update ends here -02/28/2004 - HKPATEL

Line 7176: l_date_history_tbl okl_streams_util.DateTabTyp;

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;
7175: l_active_yn_tbl okl_streams_util.Var10TabTyp;
7176: l_date_history_tbl okl_streams_util.DateTabTyp;
7177: l_date_curr_tbl okl_streams_util.DateTabTyp;
7178:
7179: -- Code for bulk update ends here -02/28/2004 - HKPATEL
7180:

Line 7177: l_date_curr_tbl okl_streams_util.DateTabTyp;

7173: l_id_tbl okl_streams_util.NumberTabTyp;
7174: l_say_code_tbl okl_streams_util.Var10TabTyp;
7175: l_active_yn_tbl okl_streams_util.Var10TabTyp;
7176: l_date_history_tbl okl_streams_util.DateTabTyp;
7177: l_date_curr_tbl okl_streams_util.DateTabTyp;
7178:
7179: -- Code for bulk update ends here -02/28/2004 - HKPATEL
7180:
7181:

Line 7200: okl_streams str,

7196: -- Changed this cursor for user defined streams
7197: Cursor l_secdep_csr( chrId NUMBER,pdtId NUMBER, pp VARCHAR2 ) is
7198: Select ele.id
7199: From okl_strm_elements ele,
7200: okl_streams str,
7201: --okl_strm_type_v sty,
7202: OKL_STRM_TMPT_LINES_UV sty,
7203: okl_k_lines_full_v kle,
7204: okc_line_styles_b lse,

Line 7231: FROM okl_streams stm

7227: l_secdep_rec l_secdep_csr%ROWTYPE;
7228:
7229: CURSOR l_stmp_yn_csr(khrid NUMBER, p VARCHAR2) IS
7230: SELECT count(stm.id) cnt
7231: FROM okl_streams stm
7232: WHERE stm.khr_id = khrid
7233: AND stm.say_code = 'WORK'
7234: AND stm.sgn_code = 'STMP'
7235: AND nvl(stm.purpose_code, 'ORIGIN') = p;

Line 7256: FROM OKL_STREAMS str

7252: pp VARCHAR2 )
7253: IS
7254:
7255: SELECT 'N'
7256: FROM OKL_STREAMS str
7257: WHERE EXISTS (SELECT ID FROM OKL_STRM_ELEMENTS ele WHERE ele.STM_ID = str.ID AND ele.DATE_BILLED IS NULL )
7258: AND str.KHR_ID = chrId
7259: AND str.STY_ID = styId
7260: AND str.SAY_CODE = status

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 7595: UPDATE OKL_STREAMS

7591: --Added by kthiruva for Debugging
7592: write_to_log('Prior to the Historing of Current streams and updation of Work streams to current');
7593:
7594: FORALL i IN l_id_tbl.FIRST..l_id_tbl.LAST
7595: UPDATE OKL_STREAMS
7596: SET say_code = l_say_code_tbl(i),
7597: active_yn = l_active_yn_tbl(i),
7598: date_history = l_date_history_tbl(i),
7599: date_current = l_date_curr_tbl(i),

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 7839: l_prev_stm_id OKL_STREAMS.ID%TYPE;

7835: -- Declare Variables
7836: l_api_name CONSTANT VARCHAR2(30) := 'RECREATE_TMT_LN_STRMS';
7837: l_strm_index NUMBER;
7838: l_sel_index NUMBER;
7839: l_prev_stm_id OKL_STREAMS.ID%TYPE;
7840:
7841: -- vdamerla Forward Ported Bug6149951 starts
7842:
7843: l_orig_chr_id OKC_K_HEADERS_B.ID%TYPE; -- smadhava - Bug# 6149951

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 7907: , cp_trx_number okl_streams.transaction_number%TYPE) IS

7903:
7904: CURSOR c_streams (cp_chr_id OKC_K_HEADERS_B.ID%TYPE
7905: , cp_cle_id OKC_K_LINES_B.ID%TYPE
7906: , cp_date_terminated DATE
7907: , cp_trx_number okl_streams.transaction_number%TYPE) IS
7908: SELECT STM.ID STREAM_ID
7909: , STM.STY_ID
7910: , STM.SGN_CODE
7911: , STM.PURPOSE_CODE

Line 7917: FROM OKL_STREAMS STM

7913: , SEL.STREAM_ELEMENT_DATE
7914: , SEL.AMOUNT
7915: , SEL.SE_LINE_NUMBER
7916: , SEL.COMMENTS -- vdamerla Forward Ported Bug 6344223
7917: FROM OKL_STREAMS STM
7918: , OKL_STRM_ELEMENTS SEL
7919: , OKL_STRM_TYPE_B STY -- vdamerla Forward Ported Bug 6082209
7920: WHERE SEL.STM_ID = STM.ID
7921: AND STM.KHR_ID = cp_chr_id

Line 7983: FROM okl_streams stm,

7979: --This cursor will get the terminated lines of current streams
7980: CURSOR l_get_curr_streams_lines
7981: IS
7982: SELECT distinct stm.kle_id
7983: FROM okl_streams stm,
7984: okc_k_lines_b ln
7985: WHERE stm.khr_id = p_chr_id
7986: AND stm.say_code = 'CURR'
7987: AND stm.kle_id = ln.id

Line 8007: ,cp_trx_number okl_streams.transaction_number%TYPE) IS

8003: --Modified the cursor by vdamerla for bug 6344223
8004: --Added ISG generated stream type purposes so that these streams will not be
8005: --copied over during mass/online rebook. Streams will be regenerated by ISG
8006: CURSOR c_streams1 (cp_chr_id OKC_K_HEADERS_B.ID%TYPE
8007: ,cp_trx_number okl_streams.transaction_number%TYPE) IS
8008: SELECT STM.ID STREAM_ID
8009: , STM.STY_ID
8010: , STM.SGN_CODE
8011: , STM.PURPOSE_CODE

Line 8017: FROM OKL_STREAMS STM

8013: , SEL.STREAM_ELEMENT_DATE
8014: , SEL.AMOUNT
8015: , SEL.SE_LINE_NUMBER
8016: , SEL.COMMENTS
8017: FROM OKL_STREAMS STM
8018: , OKL_STRM_ELEMENTS SEL
8019: , OKL_STRM_TYPE_B STY
8020: WHERE SEL.STM_ID = STM.ID
8021: AND STM.KHR_ID = cp_chr_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 8597: l_id_tbl okl_streams_util.NumberTabTyp;

8593:
8594: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
8595: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
8596: -- Code for bulk update -02/18/2004 - HKPATEL
8597: l_id_tbl okl_streams_util.NumberTabTyp;
8598: -- Code for bulk update ends here -02/18/2004 - HKPATEL
8599:
8600:
8601: Cursor ylds_csr( chrId NUMBER ) IS

Line 8686: FROM okl_streams str

8682: str.transaction_number trn_num,
8683: str.purpose_code,
8684: str.say_code,
8685: str.active_yn
8686: FROM okl_streams str
8687: WHERE str.khr_id = p_chr_id
8688: AND str.purpose_code = 'REPORT'
8689: AND str.say_code = 'CURR'
8690: AND str.sgn_code NOT IN ('INTC','LATE_CALC') -- bug 6472228

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 9126: UPDATE OKL_STREAMS

9122: BEGIN
9123: --Added by kthiruva for Debugging
9124: write_to_log('Prior to the call to historing current streams');
9125: FORALL i IN l_id_tbl.FIRST..l_id_tbl.LAST
9126: UPDATE OKL_STREAMS
9127: SET say_code = 'HIST',
9128: active_yn = 'N',
9129: date_history = sysdate,
9130: last_updated_by = FND_GLOBAL.USER_ID, -- BUG:14749215 changes start here

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 9248: l_timeout := FND_PROFILE.value('OKL_STREAMS_TIME_OUT');

9244: IF(l_report_req_status NOT IN('PROCESS_COMPLETE', 'PROCESS_COMPLETE_ERRORS','PROCESSING_FAILED'
9245: ,'PROCESS_ABORTED','SERVER_NA','TIME_OUT')) THEN
9246:
9247: --Fetching the value of the time out variable
9248: l_timeout := FND_PROFILE.value('OKL_STREAMS_TIME_OUT');
9249: l_timeout := l_timeout * 60;
9250:
9251: OPEN get_rep_trans_num(p_chr_id);
9252: FETCH get_rep_trans_num INTO l_alert_name;

Line 10692: OKL_STREAMS_UTIL.get_dependent_stream_type

10688: END IF;
10689: CLOSE get_sub_income_strm_csr;
10690:
10691: -- New code for bug 4044089 by HKPATEL 12/02/2004
10692: OKL_STREAMS_UTIL.get_dependent_stream_type
10693: (
10694: p_khr_id =>p_chr_id,
10695: p_primary_sty_id =>l_sty_id,
10696: p_dependent_sty_purpose=>'SUBSIDY_INCOME',

Line 10847: OKL_STREAMS_UTIL.get_dependent_stream_type

10843: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
10844: END IF;
10845: CLOSE get_sub_income_strm_csr;
10846: -- New code for bug 4044089 by HKPATEL 12/02/2004
10847: OKL_STREAMS_UTIL.get_dependent_stream_type
10848: (
10849: p_khr_id =>p_chr_id,
10850: p_primary_sty_id =>l_sty_id,
10851: p_dependent_sty_purpose=>'SUBSIDY_INCOME',

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 22973: From okl_streams;

22969: l_stmv_rec.active_yn := 'Y';
22970: l_stmv_rec.date_current := sysdate;
22971:
22972: Select max(transaction_number)+1 into temp
22973: From okl_streams;
22974:
22975: l_stmv_rec.transaction_number := temp;
22976: l_stmv_rec.sgn_code := 'MANL';
22977:

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 23190: l_id_tbl okl_streams_util.NumberTabTyp;

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;
23191: -- Code for bulk update ends here -02/28/2004 - HKPATEL
23192:
23193:
23194: i NUMBER;

Line 23296: UPDATE OKL_STREAMS

23292: --Added by kthiruva for Debugging
23293: write_to_log('Updating the Work streams to CURR');
23294:
23295: FORALL i IN l_id_tbl.FIRST..l_id_tbl.LAST
23296: UPDATE OKL_STREAMS
23297: SET say_code = 'CURR',
23298: active_yn = 'Y',
23299: date_current = sysdate,
23300: last_updated_by = FND_GLOBAL.USER_ID, -- BUG:14749215 changes start here

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,

Line 23401: OKL_STREAMS_UTIL.get_pricing_engine(

23397: return;
23398:
23399: End If;
23400:
23401: OKL_STREAMS_UTIL.get_pricing_engine(
23402: p_khr_id => p_khr_id,
23403: x_pricing_engine => l_pricing_engine,
23404: x_return_status => x_return_status);
23405: --Added by kthiruva for Debugging

Line 23414: --IF ( fnd_profile.value('OKL_STREAMS_GEN_PATH') = 'EXTERNAL') THEN

23410: raise OKL_API.G_EXCEPTION_ERROR;
23411: END IF;
23412:
23413:
23414: --IF ( fnd_profile.value('OKL_STREAMS_GEN_PATH') = 'EXTERNAL') THEN
23415: IF ( l_pricing_engine = 'EXTERNAL') THEN
23416:
23417: -- populate orig_contract_line_id for the lines.
23418: -- orig_contract_line_id would be null for existing contracts and needing upgrade