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

Line 253: select id from okl_streams

249: CURSOR stream_id_csr (p_khr_id NUMBER,
250: p_sty_id NUMBER,
251: p_say_code VARCHAR2)
252: IS
253: select id from okl_streams
254: where khr_id=p_khr_id
255: and sty_id=p_sty_id
256: and say_code=p_say_code ;
257:

Line 258: l_id_tbl okl_streams_util.NumberTabTyp;

254: where khr_id=p_khr_id
255: and sty_id=p_sty_id
256: and say_code=p_say_code ;
257:
258: l_id_tbl okl_streams_util.NumberTabTyp;
259: j NUMBER := 0;
260:
261: -- declaration of a parameterized cursor by zrehman on 12-Sep-2006
262: CURSOR strm_csr (khr_id NUMBER,

Line 268: FROM okl_strm_type_b sty, okl_streams stm, okl_strm_elements ste

264: end_date DATE,
265: l_stream_type_purpose VARCHAR2)
266: IS
267: select ste.stream_element_date stream_element_date,ste.amount amount
268: FROM okl_strm_type_b sty, okl_streams stm, okl_strm_elements ste
269: WHERE
270: stm.sty_id = sty.id
271: AND ste.stm_id = stm.id
272: AND stm.active_yn = 'Y'

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 484: okl_streams stm,

480: -- Commented for SQL Literals on 12-09-2006
481: /* l_stmt := 'SELECT ste.stream_element_date stream_element_date,
482: ste.amount amount
483: FROM okl_strm_type_b sty,
484: okl_streams stm,
485: okl_strm_elements ste
486: WHERE 1 = 1
487: AND stm.sty_id = sty.id
488: AND ste.stm_id = stm.id

Line 501: OKL_STREAMS_UTIL.get_primary_stream_type

497: Added code to generate new Stream Types for a Loan product on an Investor Agreement
498: Start Changes
499: */
500: IF l_contracts_csr.deal_type = 'LEASEOP' THEN
501: OKL_STREAMS_UTIL.get_primary_stream_type
502: (
503: p_khr_id => l_contracts_csr.khr_id,
504: p_primary_sty_purpose => l_investor_rental_accrual,
505: x_return_status => l_return_status,

Line 528: OKL_STREAMS_UTIL.get_primary_stream_type

524: RAISE okl_api.G_EXCEPTION_ERROR;
525: END IF;
526: stream_type_purpose := l_rental_accrual;
527: ELSIF l_contracts_csr.deal_type IN ('LEASEDF', 'LEASEST') THEN
528: OKL_STREAMS_UTIL.get_primary_stream_type
529: (
530: p_khr_id => l_contracts_csr.khr_id,
531: p_primary_sty_purpose => l_investor_pre_tax_income,
532: x_return_status => l_return_status,

Line 563: OKL_STREAMS_UTIL.get_primary_stream_type

559: Added condition for fetching stream type for a Loan product
560: Start Changes
561: */
562: ELSIF l_contracts_csr.deal_type IN ('LOAN', 'LOAN-REVOLVING') THEN
563: OKL_STREAMS_UTIL.get_primary_stream_type
564: (
565: p_khr_id => l_contracts_csr.khr_id,
566: p_primary_sty_purpose => l_inv_interest_income_accrual,
567: x_return_status => l_return_status,

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

693:
694: BEGIN
695:
696: FORALL i IN l_id_tbl.FIRST..l_id_tbl.LAST
697: UPDATE OKL_STREAMS
698: SET say_code = 'HIST',
699: active_yn = 'N',
700: date_history = sysdate
701: WHERE ID = l_id_tbl(i);

Line 736: UPDATE OKL_STREAMS

732:
733: BEGIN
734:
735: FORALL i IN l_id_tbl.FIRST..l_id_tbl.LAST
736: UPDATE OKL_STREAMS
737: SET say_code = 'CURR',
738: active_yn = 'Y',
739: date_current = sysdate
740: WHERE ID = l_id_tbl(i);

Line 1123: FROM okl_strm_type_b sty, okl_streams stm, okl_strm_elements ste

1119: p_end_date DATE,
1120: p_stream_type_purpose VARCHAR2)
1121: IS
1122: select ste.stream_element_date stream_element_date,ste.amount amount
1123: FROM okl_strm_type_b sty, okl_streams stm, okl_strm_elements ste
1124: WHERE
1125: stm.sty_id = sty.id
1126: AND ste.stm_id = stm.id
1127: AND stm.active_yn = 'Y'

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 1277: ,OKL_STREAMS stm

1273: -- SQL Literals Change on 12/09/2006
1274: /*l_stmt := 'SELECT ste.stream_element_date stream_element_date
1275: ,ste.amount amount
1276: FROM OKL_STRM_TYPE_B sty
1277: ,OKL_STREAMS stm
1278: ,OKL_STRM_ELEMENTS ste
1279: WHERE 1 = 1
1280: AND stm.sty_id = sty.id
1281: AND ste.stm_id = stm.id

Line 1292: OKL_STREAMS_UTIL.get_primary_stream_type

1288: Start Changes
1289: */
1290: --get sty_id for the contract based on deal type
1291: IF l_contracts_csr.deal_type = 'LEASEOP' THEN
1292: OKL_STREAMS_UTIL.get_primary_stream_type
1293: (
1294: p_khr_id => l_contracts_csr.khr_id,
1295: p_primary_sty_purpose => l_investor_rental_accrual,
1296: x_return_status => l_return_status,

Line 1327: OKL_STREAMS_UTIL.get_primary_stream_type

1323: -- l_where := l_where ||' AND sty.stream_type_purpose = '|| '''' ||l_rental_accrual|| '''' ||' ORDER BY ste.stream_element_date';
1324: stream_type_purpose := l_rental_accrual;
1325: --Bug 4228708 - End of Changes
1326: ELSIF l_contracts_csr.deal_type IN ('LEASEDF', 'LEASEST') THEN
1327: OKL_STREAMS_UTIL.get_primary_stream_type
1328: (
1329: p_khr_id => l_contracts_csr.khr_id,
1330: p_primary_sty_purpose => l_investor_pre_tax_income,
1331: x_return_status => l_return_status,

Line 1365: OKL_STREAMS_UTIL.get_primary_stream_type

1361: Added condition for fetching stream type for a Loan product
1362: Start Changes
1363: */
1364: ELSIF l_contracts_csr.deal_type IN ('LOAN', 'LOAN-REVOLVING') THEN
1365: OKL_STREAMS_UTIL.get_primary_stream_type
1366: (
1367: p_khr_id => l_contracts_csr.khr_id,
1368: p_primary_sty_purpose => l_inv_interest_income_accrual,
1369: x_return_status => l_return_status,

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 1603: OKL_STREAMS_UTIL.get_primary_stream_type

1599: Start Changes
1600: */
1601: --get sty_id for the contract based on deal type
1602: IF l_contracts_csr.deal_type = 'LEASEOP' THEN
1603: OKL_STREAMS_UTIL.get_primary_stream_type
1604: (
1605: p_khr_id => l_contracts_csr.khr_id,
1606: p_primary_sty_purpose => l_investor_rental_accrual,
1607: x_return_status => l_return_status,

Line 1638: OKL_STREAMS_UTIL.get_primary_stream_type

1634: -- l_where := l_where ||' AND sty.stream_type_purpose = '|| '''' ||l_rental_accrual|| '''' ||' ORDER BY ste.stream_element_date';
1635: stream_type_purpose := l_rental_accrual;
1636: --Bug 4228708 - End of Changes
1637: ELSIF l_contracts_csr.deal_type IN ('LEASEDF', 'LEASEST') THEN
1638: OKL_STREAMS_UTIL.get_primary_stream_type
1639: (
1640: p_khr_id => l_contracts_csr.khr_id,
1641: p_primary_sty_purpose => l_investor_pre_tax_income,
1642: x_return_status => l_return_status,

Line 1676: OKL_STREAMS_UTIL.get_primary_stream_type

1672: Added condition for fetching stream type for a Loan product
1673: Start Changes
1674: */
1675: ELSIF l_contracts_csr.deal_type IN ('LOAN', 'LOAN-REVOLVING') THEN
1676: OKL_STREAMS_UTIL.get_primary_stream_type
1677: (
1678: p_khr_id => l_contracts_csr.khr_id,
1679: p_primary_sty_purpose => l_inv_interest_income_accrual,
1680: x_return_status => l_return_status,

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 1901: OKL_STREAMS stm,

1897:
1898: CURSOR non_accrued_streams_csr(p_khr_id NUMBER, p_sty_code VARCHAR2, p_date DATE) IS
1899: SELECT ste.id
1900: FROM OKL_STRM_TYPE_B sty,
1901: OKL_STREAMS stm,
1902: OKL_STRM_ELEMENTS ste
1903: WHERE stm.khr_id = p_khr_id
1904: AND stm.sty_id = sty.id
1905: --AND sty.code = p_sty_code

Line 1916: OKL_STREAMS stm,

1912:
1913: CURSOR accrued_streams_csr(p_khr_id NUMBER, p_sty_code VARCHAR2, p_date DATE) IS
1914: SELECT ste.id
1915: FROM OKL_STRM_TYPE_B sty,
1916: OKL_STREAMS stm,
1917: OKL_STRM_ELEMENTS ste
1918: WHERE stm.khr_id = p_khr_id
1919: AND stm.sty_id = sty.id
1920: --AND sty.code = p_sty_code

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

Line 2140: FROM okl_streams str,

2136: CURSOR l_strm_for_line_csr(chrid NUMBER, kleid NUMBER)
2137: IS
2138: SELECT
2139: str.sty_id sty_id
2140: FROM okl_streams str,
2141: okl_strm_type_b sty
2142: WHERE str.sty_id = sty.id
2143: AND str.say_code = 'CURR'
2144: AND str.khr_id = chrid

Line 2153: --FROM okl_streams str,

2149: IS
2150: SELECT
2151: sum(ste.amount) amount,
2152: str.sty_id sty_id
2153: --FROM okl_streams str,
2154: FROM okl_streams_rep_v str, -- MGAAP 7263041
2155: okl_strm_elements ste,
2156: okl_strm_type_b sty
2157: WHERE ste.stm_id = str.id

Line 2154: FROM okl_streams_rep_v str, -- MGAAP 7263041

2150: SELECT
2151: sum(ste.amount) amount,
2152: str.sty_id sty_id
2153: --FROM okl_streams str,
2154: FROM okl_streams_rep_v str, -- MGAAP 7263041
2155: okl_strm_elements ste,
2156: okl_strm_type_b sty
2157: WHERE ste.stm_id = str.id
2158: AND str.sty_id = sty.id

Line 2171: --FROM okl_streams str,

2167: IS
2168: SELECT
2169: sum(ste.amount) amount,
2170: str.sty_id sty_id
2171: --FROM okl_streams str,
2172: FROM okl_streams_rep_v str, -- MGAAP 7263041
2173: okl_strm_elements ste,
2174: okl_strm_type_b sty
2175: WHERE ste.stm_id = str.id

Line 2172: FROM okl_streams_rep_v str, -- MGAAP 7263041

2168: SELECT
2169: sum(ste.amount) amount,
2170: str.sty_id sty_id
2171: --FROM okl_streams str,
2172: FROM okl_streams_rep_v str, -- MGAAP 7263041
2173: okl_strm_elements ste,
2174: okl_strm_type_b sty
2175: WHERE ste.stm_id = str.id
2176: AND str.sty_id = sty.id

Line 2189: --FROM okl_streams str,

2185: CURSOR l_bill_amt_csr(chrid NUMBER, kleid NUMBER,tadate DATE, strmPurpose VARCHAR2)
2186: IS
2187: SELECT
2188: sum(ste.amount)
2189: --FROM okl_streams str,
2190: FROM okl_streams_rep_v str, -- MGAAP 7263041
2191: okl_strm_elements ste,
2192: okl_strm_type_b sty
2193: WHERE ste.stm_id = str.id

Line 2190: FROM okl_streams_rep_v str, -- MGAAP 7263041

2186: IS
2187: SELECT
2188: sum(ste.amount)
2189: --FROM okl_streams str,
2190: FROM okl_streams_rep_v str, -- MGAAP 7263041
2191: okl_strm_elements ste,
2192: okl_strm_type_b sty
2193: WHERE ste.stm_id = str.id
2194: AND str.sty_id = sty.id

Line 2205: --FROM okl_streams str,

2201: CURSOR l_bill_pmt_sty_csr(chrid NUMBER, kleid NUMBER, styid NUMBER, tadate DATE)
2202: IS
2203: SELECT
2204: sum(ste.amount)
2205: --FROM okl_streams str,
2206: FROM okl_streams_rep_v str, -- MGAAP 7263041
2207: okl_strm_elements ste,
2208: okl_strm_type_b sty
2209: WHERE ste.stm_id = str.id

Line 2206: FROM okl_streams_rep_v str, -- MGAAP 7263041

2202: IS
2203: SELECT
2204: sum(ste.amount)
2205: --FROM okl_streams str,
2206: FROM okl_streams_rep_v str, -- MGAAP 7263041
2207: okl_strm_elements ste,
2208: okl_strm_type_b sty
2209: WHERE ste.stm_id = str.id
2210: AND str.sty_id = sty.id