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 371: l_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;

367: DECLARE
368: TYPE ref_cursor IS REF CURSOR;
369: TYPE element_type IS RECORD (stream_element_date DATE,
370: amount NUMBER);
371: l_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
372: l_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
373: x_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
374: x_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
375: l_difference NUMBER := 0;

Line 372: l_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;

368: TYPE ref_cursor IS REF CURSOR;
369: TYPE element_type IS RECORD (stream_element_date DATE,
370: amount NUMBER);
371: l_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
372: l_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
373: x_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
374: x_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
375: l_difference NUMBER := 0;
376: l_counter NUMBER := 1;

Line 373: x_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;

369: TYPE element_type IS RECORD (stream_element_date DATE,
370: amount NUMBER);
371: l_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
372: l_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
373: x_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
374: x_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
375: l_difference NUMBER := 0;
376: l_counter NUMBER := 1;
377: l_line_number NUMBER := 1;

Line 374: x_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;

370: amount NUMBER);
371: l_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
372: l_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
373: x_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
374: x_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
375: l_difference NUMBER := 0;
376: l_counter NUMBER := 1;
377: l_line_number NUMBER := 1;
378: --l_stmt VARCHAR2(5000);

Line 649: okl_streams_pub.create_streams(

645: END LOOP;
646: CLOSE strm_csr;
647: IF l_selv_tbl.COUNT > 0 THEN
648: -- call streams api
649: okl_streams_pub.create_streams(
650: p_api_version => p_api_version,
651: p_init_msg_list => p_init_msg_list,
652: x_return_status => x_return_status,
653: x_msg_count => x_msg_count,

Line 1197: l_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;

1193: EXIT WHEN securitized_contracts_csr%NOTFOUND;
1194: DECLARE
1195: TYPE ref_cursor IS REF CURSOR;
1196: TYPE element_type IS RECORD (stream_element_date DATE, amount NUMBER);
1197: l_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
1198: l_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
1199: x_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
1200: x_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
1201: l_difference NUMBER := 0;

Line 1198: l_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;

1194: DECLARE
1195: TYPE ref_cursor IS REF CURSOR;
1196: TYPE element_type IS RECORD (stream_element_date DATE, amount NUMBER);
1197: l_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
1198: l_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
1199: x_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
1200: x_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
1201: l_difference NUMBER := 0;
1202: l_counter NUMBER := 1;

Line 1199: x_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;

1195: TYPE ref_cursor IS REF CURSOR;
1196: TYPE element_type IS RECORD (stream_element_date DATE, amount NUMBER);
1197: l_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
1198: l_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
1199: x_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
1200: x_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
1201: l_difference NUMBER := 0;
1202: l_counter NUMBER := 1;
1203: l_line_number NUMBER := 1;

Line 1200: x_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;

1196: TYPE element_type IS RECORD (stream_element_date DATE, amount NUMBER);
1197: l_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
1198: l_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
1199: x_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
1200: x_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
1201: l_difference NUMBER := 0;
1202: l_counter NUMBER := 1;
1203: l_line_number NUMBER := 1;
1204: --l_stmt VARCHAR2(5000);

Line 1455: OKL_STREAMS_PUB.create_streams(

1451: END LOOP;
1452: CLOSE strm_csr;
1453: IF l_selv_tbl.COUNT > 0 THEN
1454: -- call streams api
1455: OKL_STREAMS_PUB.create_streams(
1456: p_api_version => l_api_version
1457: ,p_init_msg_list => l_init_msg_list
1458: ,x_return_status => l_return_status
1459: ,x_msg_count => l_msg_count

Line 1519: l_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;

1515: EXIT WHEN securitized_contracts_pend_csr%NOTFOUND;
1516: DECLARE
1517: TYPE ref_cursor IS REF CURSOR;
1518: TYPE element_type IS RECORD (stream_element_date DATE, amount NUMBER);
1519: l_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
1520: l_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
1521: x_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
1522: x_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
1523: l_difference NUMBER := 0;

Line 1520: l_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;

1516: DECLARE
1517: TYPE ref_cursor IS REF CURSOR;
1518: TYPE element_type IS RECORD (stream_element_date DATE, amount NUMBER);
1519: l_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
1520: l_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
1521: x_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
1522: x_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
1523: l_difference NUMBER := 0;
1524: l_counter NUMBER := 1;

Line 1521: x_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;

1517: TYPE ref_cursor IS REF CURSOR;
1518: TYPE element_type IS RECORD (stream_element_date DATE, amount NUMBER);
1519: l_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
1520: l_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
1521: x_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
1522: x_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
1523: l_difference NUMBER := 0;
1524: l_counter NUMBER := 1;
1525: l_line_number NUMBER := 1;

Line 1522: x_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;

1518: TYPE element_type IS RECORD (stream_element_date DATE, amount NUMBER);
1519: l_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
1520: l_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
1521: x_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
1522: x_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
1523: l_difference NUMBER := 0;
1524: l_counter NUMBER := 1;
1525: l_line_number NUMBER := 1;
1526: --l_stmt VARCHAR2(5000);

Line 1765: OKL_STREAMS_PUB.create_streams(

1761: END LOOP;
1762: CLOSE strm_csr;
1763: IF l_selv_tbl.COUNT > 0 THEN
1764: -- call streams api
1765: OKL_STREAMS_PUB.create_streams(
1766: p_api_version => l_api_version
1767: ,p_init_msg_list => l_init_msg_list
1768: ,x_return_status => l_return_status
1769: ,x_msg_count => l_msg_count

Line 1889: l_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;

1885: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1886: l_msg_count NUMBER;
1887: l_msg_data VARCHAR2(2000);
1888: l_deal_type VARCHAR2(2000);
1889: l_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
1890: x_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
1891:
1892: -- cursor to get deal type of lease contract.
1893: CURSOR get_deal_type_csr(p_khr_id NUMBER) IS

Line 1890: x_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;

1886: l_msg_count NUMBER;
1887: l_msg_data VARCHAR2(2000);
1888: l_deal_type VARCHAR2(2000);
1889: l_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
1890: x_selv_tbl OKL_STREAMS_PUB.selv_tbl_type;
1891:
1892: -- cursor to get deal type of lease contract.
1893: CURSOR get_deal_type_csr(p_khr_id NUMBER) IS
1894: SELECT deal_type

Line 2000: OKL_STREAMS_PUB.update_stream_elements(

1996:
1997: -- call delete stream elements API.
1998: IF l_selv_tbl.COUNT > 0 THEN
1999:
2000: OKL_STREAMS_PUB.update_stream_elements(
2001: p_api_version => l_api_version
2002: ,p_init_msg_list => l_init_msg_list
2003: ,x_return_status => l_return_status
2004: ,x_msg_count => l_msg_count