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

Line 484: l_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;

480: DECLARE
481: TYPE ref_cursor IS REF CURSOR;
482: TYPE element_type IS RECORD (stream_element_date DATE,
483: amount NUMBER);
484: l_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
485: l_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
486: x_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
487: x_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
488: l_difference NUMBER := 0;

Line 485: l_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;

481: TYPE ref_cursor IS REF CURSOR;
482: TYPE element_type IS RECORD (stream_element_date DATE,
483: amount NUMBER);
484: l_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
485: l_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
486: x_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
487: x_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
488: l_difference NUMBER := 0;
489: l_counter NUMBER := 1;

Line 486: x_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;

482: TYPE element_type IS RECORD (stream_element_date DATE,
483: amount NUMBER);
484: l_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
485: l_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
486: x_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
487: x_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
488: l_difference NUMBER := 0;
489: l_counter NUMBER := 1;
490: l_line_number NUMBER := 1;

Line 487: x_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;

483: amount NUMBER);
484: l_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
485: l_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
486: x_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
487: x_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
488: l_difference NUMBER := 0;
489: l_counter NUMBER := 1;
490: l_line_number NUMBER := 1;
491: --l_stmt VARCHAR2(5000);

Line 504: l_rep_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;

500: --strm_csr ref_cursor;
501: l_elements element_type;
502:
503: --sechawla 09-mar-09 : MG Impact on Investor Agreement
504: l_rep_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
505: l_rep_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
506: x_rep_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
507: x_rep_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
508: l_rep_elements element_type;

Line 505: l_rep_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;

501: l_elements element_type;
502:
503: --sechawla 09-mar-09 : MG Impact on Investor Agreement
504: l_rep_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
505: l_rep_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
506: x_rep_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
507: x_rep_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
508: l_rep_elements element_type;
509: l_rep_counter NUMBER := 1;

Line 506: x_rep_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;

502:
503: --sechawla 09-mar-09 : MG Impact on Investor Agreement
504: l_rep_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
505: l_rep_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
506: x_rep_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
507: x_rep_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
508: l_rep_elements element_type;
509: l_rep_counter NUMBER := 1;
510: l_rep_line_number NUMBER := 1;

Line 507: x_rep_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;

503: --sechawla 09-mar-09 : MG Impact on Investor Agreement
504: l_rep_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
505: l_rep_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
506: x_rep_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
507: x_rep_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
508: l_rep_elements element_type;
509: l_rep_counter NUMBER := 1;
510: l_rep_line_number NUMBER := 1;
511: BEGIN

Line 945: okl_streams_pub.create_streams(

941: END LOOP;
942: CLOSE strm_csr;
943: IF l_selv_tbl.COUNT > 0 THEN
944: -- call streams api
945: okl_streams_pub.create_streams(
946: p_api_version => p_api_version,
947: p_init_msg_list => p_init_msg_list,
948: x_return_status => x_return_status,
949: x_msg_count => x_msg_count,

Line 1008: OKL_STREAMS_PUB.create_streams(

1004: END LOOP;
1005: CLOSE rep_strm_csr;
1006: IF l_rep_selv_tbl.COUNT > 0 THEN
1007: -- call streams api
1008: OKL_STREAMS_PUB.create_streams(
1009: p_api_version => l_api_version
1010: ,p_init_msg_list => p_init_msg_list
1011: ,x_return_status => l_return_status
1012: ,x_msg_count => x_msg_count

Line 1703: l_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;

1699: EXIT WHEN securitized_contracts_csr%NOTFOUND;
1700: DECLARE
1701: TYPE ref_cursor IS REF CURSOR;
1702: TYPE element_type IS RECORD (stream_element_date DATE, amount NUMBER);
1703: l_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
1704: l_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
1705: x_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
1706: x_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
1707: l_difference NUMBER := 0;

Line 1704: l_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;

1700: DECLARE
1701: TYPE ref_cursor IS REF CURSOR;
1702: TYPE element_type IS RECORD (stream_element_date DATE, amount NUMBER);
1703: l_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
1704: l_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
1705: x_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
1706: x_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
1707: l_difference NUMBER := 0;
1708: l_counter NUMBER := 1;

Line 1705: x_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;

1701: TYPE ref_cursor IS REF CURSOR;
1702: TYPE element_type IS RECORD (stream_element_date DATE, amount NUMBER);
1703: l_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
1704: l_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
1705: x_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
1706: x_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
1707: l_difference NUMBER := 0;
1708: l_counter NUMBER := 1;
1709: l_line_number NUMBER := 1;

Line 1706: x_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;

1702: TYPE element_type IS RECORD (stream_element_date DATE, amount NUMBER);
1703: l_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
1704: l_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
1705: x_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
1706: x_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
1707: l_difference NUMBER := 0;
1708: l_counter NUMBER := 1;
1709: l_line_number NUMBER := 1;
1710: --l_stmt VARCHAR2(5000);

Line 1723: l_rep_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;

1719: --strm_csr ref_cursor;
1720: l_elements element_type;
1721:
1722: --sechawla : 9-mar-2009 MG Impact on IA
1723: l_rep_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
1724: l_rep_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
1725: x_rep_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
1726: x_rep_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
1727: l_rep_elements element_type;

Line 1724: l_rep_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;

1720: l_elements element_type;
1721:
1722: --sechawla : 9-mar-2009 MG Impact on IA
1723: l_rep_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
1724: l_rep_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
1725: x_rep_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
1726: x_rep_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
1727: l_rep_elements element_type;
1728: l_rep_line_number NUMBER := 1;

Line 1725: x_rep_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;

1721:
1722: --sechawla : 9-mar-2009 MG Impact on IA
1723: l_rep_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
1724: l_rep_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
1725: x_rep_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
1726: x_rep_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
1727: l_rep_elements element_type;
1728: l_rep_line_number NUMBER := 1;
1729: l_rep_counter NUMBER := 1;

Line 1726: x_rep_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;

1722: --sechawla : 9-mar-2009 MG Impact on IA
1723: l_rep_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
1724: l_rep_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
1725: x_rep_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
1726: x_rep_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
1727: l_rep_elements element_type;
1728: l_rep_line_number NUMBER := 1;
1729: l_rep_counter NUMBER := 1;
1730: BEGIN

Line 2146: OKL_STREAMS_PUB.create_streams(

2142: END LOOP;
2143: CLOSE strm_csr;
2144: IF l_selv_tbl.COUNT > 0 THEN
2145: -- call streams api
2146: OKL_STREAMS_PUB.create_streams(
2147: p_api_version => l_api_version
2148: ,p_init_msg_list => l_init_msg_list
2149: ,x_return_status => l_return_status
2150: ,x_msg_count => l_msg_count

Line 2205: OKL_STREAMS_PUB.create_streams(

2201: END LOOP;
2202: CLOSE rep_strm_csr;
2203: IF l_rep_selv_tbl.COUNT > 0 THEN
2204: -- call streams api
2205: OKL_STREAMS_PUB.create_streams(
2206: p_api_version => l_api_version
2207: ,p_init_msg_list => l_init_msg_list
2208: ,x_return_status => l_return_status
2209: ,x_msg_count => l_msg_count

Line 2272: l_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;

2268: EXIT WHEN securitized_contracts_pend_csr%NOTFOUND;
2269: DECLARE
2270: TYPE ref_cursor IS REF CURSOR;
2271: TYPE element_type IS RECORD (stream_element_date DATE, amount NUMBER);
2272: l_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
2273: l_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
2274: x_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
2275: x_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
2276: l_difference NUMBER := 0;

Line 2273: l_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;

2269: DECLARE
2270: TYPE ref_cursor IS REF CURSOR;
2271: TYPE element_type IS RECORD (stream_element_date DATE, amount NUMBER);
2272: l_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
2273: l_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
2274: x_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
2275: x_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
2276: l_difference NUMBER := 0;
2277: l_counter NUMBER := 1;

Line 2274: x_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;

2270: TYPE ref_cursor IS REF CURSOR;
2271: TYPE element_type IS RECORD (stream_element_date DATE, amount NUMBER);
2272: l_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
2273: l_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
2274: x_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
2275: x_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
2276: l_difference NUMBER := 0;
2277: l_counter NUMBER := 1;
2278: l_line_number NUMBER := 1;

Line 2275: x_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;

2271: TYPE element_type IS RECORD (stream_element_date DATE, amount NUMBER);
2272: l_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
2273: l_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
2274: x_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
2275: x_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
2276: l_difference NUMBER := 0;
2277: l_counter NUMBER := 1;
2278: l_line_number NUMBER := 1;
2279: --l_stmt VARCHAR2(5000);

Line 2292: l_rep_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;

2288: --strm_csr ref_cursor;
2289: l_elements element_type;
2290:
2291: --sechawla : 9-mar-2009 MG Impact on IA
2292: l_rep_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
2293: l_rep_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
2294: x_rep_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
2295: x_rep_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
2296: l_rep_elements element_type;

Line 2293: l_rep_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;

2289: l_elements element_type;
2290:
2291: --sechawla : 9-mar-2009 MG Impact on IA
2292: l_rep_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
2293: l_rep_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
2294: x_rep_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
2295: x_rep_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
2296: l_rep_elements element_type;
2297: l_rep_line_number NUMBER := 1;

Line 2294: x_rep_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;

2290:
2291: --sechawla : 9-mar-2009 MG Impact on IA
2292: l_rep_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
2293: l_rep_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
2294: x_rep_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
2295: x_rep_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
2296: l_rep_elements element_type;
2297: l_rep_line_number NUMBER := 1;
2298: l_rep_counter NUMBER := 1;

Line 2295: x_rep_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;

2291: --sechawla : 9-mar-2009 MG Impact on IA
2292: l_rep_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
2293: l_rep_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
2294: x_rep_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
2295: x_rep_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
2296: l_rep_elements element_type;
2297: l_rep_line_number NUMBER := 1;
2298: l_rep_counter NUMBER := 1;
2299:

Line 2699: OKL_STREAMS_PUB.create_streams(

2695: END LOOP;
2696: CLOSE strm_csr;
2697: IF l_selv_tbl.COUNT > 0 THEN
2698: -- call streams api
2699: OKL_STREAMS_PUB.create_streams(
2700: p_api_version => l_api_version
2701: ,p_init_msg_list => l_init_msg_list
2702: ,x_return_status => l_return_status
2703: ,x_msg_count => l_msg_count

Line 2758: OKL_STREAMS_PUB.create_streams(

2754: END LOOP;
2755: CLOSE rep_strm_csr;
2756: IF l_rep_selv_tbl.COUNT > 0 THEN
2757: -- call streams api
2758: OKL_STREAMS_PUB.create_streams(
2759: p_api_version => l_api_version
2760: ,p_init_msg_list => l_init_msg_list
2761: ,x_return_status => l_return_status
2762: ,x_msg_count => l_msg_count

Line 2913: l_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;

2909: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2910: l_msg_count NUMBER;
2911: l_msg_data VARCHAR2(2000);
2912: l_deal_type VARCHAR2(2000);
2913: l_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
2914: x_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
2915:
2916: --sechawla 10-mar-09 MG impacts
2917: l_sec_rep_method VARCHAR2(30);

Line 2914: x_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;

2910: l_msg_count NUMBER;
2911: l_msg_data VARCHAR2(2000);
2912: l_deal_type VARCHAR2(2000);
2913: l_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
2914: x_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
2915:
2916: --sechawla 10-mar-09 MG impacts
2917: l_sec_rep_method VARCHAR2(30);
2918: lx_rep_product OKL_PRODUCTS_V.NAME%TYPE;

Line 2921: l_rep_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;

2917: l_sec_rep_method VARCHAR2(30);
2918: lx_rep_product OKL_PRODUCTS_V.NAME%TYPE;
2919: lx_rep_product_id NUMBER;
2920: lx_rep_deal_type okl_product_parameters_v.deal_type%TYPE;
2921: l_rep_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
2922: x_rep_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
2923:
2924: -- cursor to get deal type of lease contract.
2925: CURSOR get_deal_type_csr(p_khr_id NUMBER) IS

Line 2922: x_rep_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;

2918: lx_rep_product OKL_PRODUCTS_V.NAME%TYPE;
2919: lx_rep_product_id NUMBER;
2920: lx_rep_deal_type okl_product_parameters_v.deal_type%TYPE;
2921: l_rep_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
2922: x_rep_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
2923:
2924: -- cursor to get deal type of lease contract.
2925: CURSOR get_deal_type_csr(p_khr_id NUMBER) IS
2926: SELECT deal_type

Line 3055: OKL_STREAMS_PUB.update_stream_elements(

3051:
3052: -- call delete stream elements API.
3053: IF l_selv_tbl.COUNT > 0 THEN
3054:
3055: OKL_STREAMS_PUB.update_stream_elements(
3056: p_api_version => l_api_version
3057: ,p_init_msg_list => l_init_msg_list
3058: ,x_return_status => l_return_status
3059: ,x_msg_count => l_msg_count

Line 3128: OKL_STREAMS_PUB.update_stream_elements(

3124:
3125: -- call delete stream elements API.
3126: IF l_rep_selv_tbl.COUNT > 0 THEN
3127:
3128: OKL_STREAMS_PUB.update_stream_elements(
3129: p_api_version => l_api_version
3130: ,p_init_msg_list => l_init_msg_list
3131: ,x_return_status => l_return_status
3132: ,x_msg_count => l_msg_count

Line 4085: l_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;

4081: l_arrears VARCHAR2(1);
4082: l_start_date DATE;
4083: l_kle_id NUMBER;
4084:
4085: l_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
4086: x_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
4087: lx_rep_product OKL_PRODUCTS_V.NAME%TYPE;
4088: lx_rep_deal_type okl_product_parameters_v.deal_type%TYPE;
4089: l_rep_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;

Line 4086: x_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;

4082: l_start_date DATE;
4083: l_kle_id NUMBER;
4084:
4085: l_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
4086: x_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
4087: lx_rep_product OKL_PRODUCTS_V.NAME%TYPE;
4088: lx_rep_deal_type okl_product_parameters_v.deal_type%TYPE;
4089: l_rep_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
4090: x_rep_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;

Line 4089: l_rep_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;

4085: l_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
4086: x_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
4087: lx_rep_product OKL_PRODUCTS_V.NAME%TYPE;
4088: lx_rep_deal_type okl_product_parameters_v.deal_type%TYPE;
4089: l_rep_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
4090: x_rep_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
4091:
4092: -- cursor to get deal type of lease contract.
4093: CURSOR get_deal_type_csr(p_khr_id NUMBER)

Line 4090: x_rep_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;

4086: x_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
4087: lx_rep_product OKL_PRODUCTS_V.NAME%TYPE;
4088: lx_rep_deal_type okl_product_parameters_v.deal_type%TYPE;
4089: l_rep_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
4090: x_rep_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
4091:
4092: -- cursor to get deal type of lease contract.
4093: CURSOR get_deal_type_csr(p_khr_id NUMBER)
4094: IS

Line 4297: OKL_STREAMS_PUB.delete_stream_elements(

4293: END LOOP;
4294: END IF;
4295:
4296: IF l_selv_tbl.COUNT > 0 THEN
4297: OKL_STREAMS_PUB.delete_stream_elements(
4298: p_api_version => l_api_version ,
4299: p_init_msg_list => l_init_msg_list ,
4300: x_return_status => l_return_status ,
4301: x_msg_count => l_msg_count ,

Line 4360: OKL_STREAMS_PUB.delete_stream_elements(

4356: END IF;
4357:
4358: -- call delete stream elements API.
4359: IF l_rep_selv_tbl.COUNT > 0 THEN
4360: OKL_STREAMS_PUB.delete_stream_elements(
4361: p_api_version => l_api_version ,
4362: p_init_msg_list => l_init_msg_list ,
4363: x_return_status => l_return_status ,
4364: x_msg_count => l_msg_count ,