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 256: select id from okl_streams

252: p_sty_id NUMBER,
253: p_say_code VARCHAR2,
254: p_purpose_code VARCHAR2)--sechawla 9-mar-09 MG Impact on IA : added
255: IS
256: select id from okl_streams
257: where khr_id=p_khr_id
258: and sty_id=p_sty_id
259: and say_code=p_say_code
260: and nvl(purpose_code,'XXX') = nvl(p_purpose_code,'XXX') ; --sechawla 9-mar-09 MG Impact on IA : added

Line 263: l_id_tbl okl_streams_util.NumberTabTyp;

259: and say_code=p_say_code
260: and nvl(purpose_code,'XXX') = nvl(p_purpose_code,'XXX') ; --sechawla 9-mar-09 MG Impact on IA : added
261:
262:
263: l_id_tbl okl_streams_util.NumberTabTyp;
264: j NUMBER := 0;
265:
266: -- declaration of a parameterized cursor by zrehman on 12-Sep-2006
267: --sechawla 9-mar-09 MG Impact on IA prefixed curosr parameters with cp, to avoid conflict with column names

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

272: cp_end_date DATE,
273: cp_stream_type_purpose VARCHAR2)
274: IS
275: select ste.stream_element_date stream_element_date,ste.amount amount
276: FROM okl_strm_type_b sty, okl_streams stm, okl_strm_elements ste
277: WHERE
278: stm.sty_id = sty.id
279: AND ste.stm_id = stm.id
280: AND stm.active_yn = 'Y'

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

292: p_sty_id NUMBER,
293: cp_stream_type_purpose VARCHAR2 )
294: IS
295: select ste.stream_element_date stream_element_date,ste.amount amount
296: FROM okl_strm_type_b sty, okl_streams stm, okl_strm_elements ste
297:
298: WHERE
299: stm.sty_id = sty.id
300: AND ste.stm_id = stm.id

Line 307: FROM okl_strm_type_b sty1, okl_streams stm1, okl_strm_elements ste1

303: AND stm.khr_id = cp_khr_id
304: AND sty.stream_type_purpose = cp_stream_type_purpose
305: and exists (
306: select '1'
307: FROM okl_strm_type_b sty1, okl_streams stm1, okl_strm_elements ste1
308: where stm1.sty_id = sty1.id
309: AND ste1.stm_id = stm1.id
310: AND stm1.active_yn = 'Y'
311: AND stm1.say_code = 'CURR'

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

324: cp_end_date DATE,
325: cp_stream_type_purpose VARCHAR2)
326: IS
327: select ste.stream_element_date stream_element_date,ste.amount amount
328: FROM okl_strm_type_b sty, okl_streams stm, okl_strm_elements ste
329: WHERE
330: stm.sty_id = sty.id
331: AND ste.stm_id = stm.id
332: AND stm.active_yn = 'N'

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

344: p_rep_sty_id NUMBER,
345: cp_stream_type_purpose VARCHAR2)
346: IS
347: select ste.stream_element_date stream_element_date,ste.amount amount
348: FROM okl_strm_type_b sty, okl_streams stm, okl_strm_elements ste
349: WHERE
350: stm.sty_id = sty.id
351: AND ste.stm_id = stm.id
352: AND stm.active_yn = 'N'

Line 359: FROM okl_strm_type_b sty1, okl_streams stm1, okl_strm_elements ste1

355: AND stm.khr_id = cp_khr_id
356: AND sty.stream_type_purpose = cp_stream_type_purpose
357: and exists (
358: select '1'
359: FROM okl_strm_type_b sty1, okl_streams stm1, okl_strm_elements ste1
360: where stm1.sty_id = sty1.id
361: AND ste1.stm_id = stm1.id
362: AND stm1.active_yn = 'N'
363: AND stm1.say_code = 'CURR'

Line 382: l_rep_id_tbl okl_streams_util.NumberTabTyp;

378: lx_rep_deal_type okl_product_parameters_v.deal_type%TYPE;
379: l_rep_sty_id NUMBER;
380: rep_stream_type_purpose VARCHAR2(30);
381: l_api_version CONSTANT NUMBER := 1.0;
382: l_rep_id_tbl okl_streams_util.NumberTabTyp;
383:
384: BEGIN
385: x_return_status := OKL_API.G_RET_STS_SUCCESS;
386: -- Call start_activity to create savepoint, check compatibility

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

602: -- Commented for SQL Literals on 12-09-2006
603: /* l_stmt := 'SELECT ste.stream_element_date stream_element_date,
604: ste.amount amount
605: FROM okl_strm_type_b sty,
606: okl_streams stm,
607: okl_strm_elements ste
608: WHERE 1 = 1
609: AND stm.sty_id = sty.id
610: AND ste.stm_id = stm.id

Line 656: OKL_STREAMS_UTIL.get_primary_stream_type

652: --------------sechawla 09-mar-09 : MG Impact on Investor Agreement end --------------
653:
654:
655: IF l_contracts_csr.deal_type = 'LEASEOP' THEN -- deal type of primary product of the contract
656: OKL_STREAMS_UTIL.get_primary_stream_type
657: (
658: p_khr_id => l_contracts_csr.khr_id,
659: p_primary_sty_purpose => l_investor_rental_accrual,
660: x_return_status => l_return_status,

Line 690: OKL_STREAMS_UTIL.get_primary_stream_type_rep

686: ---generate Investor Rental Accrual / Pre Tax Income streams for reporting product
687: --IF lx_rep_product IS NOT NULL AND l_sec_rep_method = 'AUTOMATED' THEN
688: IF lx_rep_product IS NOT NULL THEN
689: IF lx_rep_deal_type = 'LEASEOP' THEN
690: OKL_STREAMS_UTIL.get_primary_stream_type_rep
691: (
692: p_khr_id => l_contracts_csr.khr_id,
693: p_primary_sty_purpose => l_investor_rental_accrual,
694: --sechawla : INVESTOR_RENTAL_ACCRUAL is the primary stream type purpose on the SGT of reporing product(OP lease)

Line 712: OKL_STREAMS_UTIL.get_primary_stream_type_rep

708: rep_stream_type_purpose := l_rental_accrual; -- Rental Accrual for reporting product
709: --Rental Accrual stream is also generated for the reporting product (if OP Lease), when contract
710: --is Booked. This stream is used to generate Investor Rental Accrual Stream for reporting product, upon rebook
711: ELSIF lx_rep_deal_type IN ('LEASEDF', 'LEASEST') THEN
712: OKL_STREAMS_UTIL.get_primary_stream_type_rep
713: (
714: p_khr_id => l_contracts_csr.khr_id,
715: p_primary_sty_purpose => l_investor_pre_tax_income,
716: --INVESTOR_PRE_TAX_INCOME is the primary stream type purpose on the SGT of reporting product (DF/ST)

Line 739: OKL_STREAMS_UTIL.get_primary_stream_type

735: --------------sechawla 09-mar-09 : MG Impact on Investor Agreement end -----
736:
737:
738: ELSIF l_contracts_csr.deal_type IN ('LEASEDF', 'LEASEST') THEN -- deal type of primary product of the contract
739: OKL_STREAMS_UTIL.get_primary_stream_type
740: (
741: p_khr_id => l_contracts_csr.khr_id,
742: p_primary_sty_purpose => l_investor_pre_tax_income,
743: --INVESTOR_PRE_TAX_INCOME is the primary stream type purpose on the SGT of DF/ST lease contract

Line 775: OKL_STREAMS_UTIL.get_primary_stream_type_rep

771: ---generate Investor Rental Accrual / Pre Tax Income streams for reporting product
772: -- IF lx_rep_product IS NOT NULL AND l_sec_rep_method = 'AUTOMATED' THEN
773: IF lx_rep_product IS NOT NULL THEN
774: IF lx_rep_deal_type = 'LEASEOP' THEN
775: OKL_STREAMS_UTIL.get_primary_stream_type_rep
776: (
777: p_khr_id => l_contracts_csr.khr_id,
778: p_primary_sty_purpose => l_investor_rental_accrual,
779: --sechawla : INVESTOR_RENTAL_ACCRUAL is the primary stream type purpose on the SGT of reporing product(OP lease)

Line 797: OKL_STREAMS_UTIL.get_primary_stream_type_rep

793: rep_stream_type_purpose := l_rental_accrual; -- Rental Accrual for reporting product
794: --Rental Accrual stream is generated for the reporting product (if OP Lease), when contract
795: --is Booked. This stream is used to generate Investor Rental Accrual Stream for reporting product, upon IA activation
796: ELSIF lx_rep_deal_type IN ('LEASEDF', 'LEASEST') THEN
797: OKL_STREAMS_UTIL.get_primary_stream_type_rep
798: (
799: p_khr_id => l_contracts_csr.khr_id,
800: p_primary_sty_purpose => l_investor_pre_tax_income,
801: --INVESTOR_PRE_TAX_INCOME is the primary stream type purpose on the SGT of reporting product (DF/ST)

Line 832: OKL_STREAMS_UTIL.get_primary_stream_type

828: Start Changes
829: */
830: ---sechawla 09-mar-09 : MG Impact on Investor Agreement : No impacts on Loans
831: ELSIF l_contracts_csr.deal_type IN ('LOAN', 'LOAN-REVOLVING') THEN
832: OKL_STREAMS_UTIL.get_primary_stream_type
833: (
834: p_khr_id => l_contracts_csr.khr_id,
835: p_primary_sty_purpose => l_inv_interest_income_accrual,
836: x_return_status => l_return_status,

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

1060:
1061: BEGIN
1062:
1063: FORALL i IN l_id_tbl.FIRST..l_id_tbl.LAST
1064: UPDATE OKL_STREAMS
1065: SET say_code = 'HIST',
1066: active_yn = 'N',
1067: date_history = sysdate,
1068: last_updated_by = FND_GLOBAL.USER_ID, -- BUG:14749215 changes start here

Line 1108: UPDATE OKL_STREAMS

1104:
1105: BEGIN
1106:
1107: FORALL i IN l_rep_id_tbl.FIRST..l_rep_id_tbl.LAST
1108: UPDATE OKL_STREAMS
1109: SET say_code = 'HIST',
1110: active_yn = 'N',
1111: date_history = sysdate,
1112: last_updated_by = FND_GLOBAL.USER_ID, -- BUG:14749215 changes start here

Line 1152: UPDATE OKL_STREAMS

1148:
1149: BEGIN
1150:
1151: FORALL i IN l_id_tbl.FIRST..l_id_tbl.LAST
1152: UPDATE OKL_STREAMS
1153: SET say_code = 'CURR',
1154: active_yn = 'Y',
1155: date_current = sysdate,
1156: last_updated_by = FND_GLOBAL.USER_ID, -- BUG:14749215 changes start here

Line 1198: UPDATE OKL_STREAMS

1194:
1195: BEGIN
1196:
1197: FORALL i IN l_rep_id_tbl.FIRST..l_rep_id_tbl.LAST
1198: UPDATE OKL_STREAMS
1199: SET say_code = 'CURR',
1200: active_yn = 'N',
1201: date_current = sysdate,
1202: last_updated_by = FND_GLOBAL.USER_ID, -- BUG:14749215 changes start here

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

1597: p_end_date DATE,
1598: p_stream_type_purpose VARCHAR2)
1599: IS
1600: select ste.stream_element_date stream_element_date,ste.amount amount
1601: FROM okl_strm_type_b sty, okl_streams stm, okl_strm_elements ste
1602: WHERE
1603: stm.sty_id = sty.id
1604: AND ste.stm_id = stm.id
1605: AND stm.active_yn = 'Y'

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

1615: p_end_date DATE,
1616: p_rep_stream_type_purpose VARCHAR2)
1617: IS
1618: select ste.stream_element_date stream_element_date,ste.amount amount
1619: FROM okl_strm_type_b sty, okl_streams stm, okl_strm_elements ste
1620: WHERE
1621: stm.sty_id = sty.id
1622: AND ste.stm_id = stm.id
1623: AND stm.active_yn = 'N'

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

1821: -- SQL Literals Change on 12/09/2006
1822: /*l_stmt := 'SELECT ste.stream_element_date stream_element_date
1823: ,ste.amount amount
1824: FROM OKL_STRM_TYPE_B sty
1825: ,OKL_STREAMS stm
1826: ,OKL_STRM_ELEMENTS ste
1827: WHERE 1 = 1
1828: AND stm.sty_id = sty.id
1829: AND ste.stm_id = stm.id

Line 1841: OKL_STREAMS_UTIL.get_primary_stream_type

1837: Start Changes
1838: */
1839: --get sty_id for the contract based on deal type
1840: IF l_contracts_csr.deal_type = 'LEASEOP' THEN -- deal type of primary product of the contract
1841: OKL_STREAMS_UTIL.get_primary_stream_type
1842: (
1843: p_khr_id => l_contracts_csr.khr_id,
1844: p_primary_sty_purpose => l_investor_rental_accrual,
1845: --sechawla : INVESTOR_RENTAL_ACCRUAL is the primary stream type purpose on the SGT of OP lease contract

Line 1887: OKL_STREAMS_UTIL.get_primary_stream_type_rep

1883: ---generate Investor Rental Accrual / Pre Tax Income streams for reporting product
1884: -- IF lx_rep_product IS NOT NULL AND l_sec_rep_method = 'AUTOMATED' THEN
1885: IF lx_rep_product IS NOT NULL THEN
1886: IF lx_rep_deal_type = 'LEASEOP' THEN
1887: OKL_STREAMS_UTIL.get_primary_stream_type_rep
1888: (
1889: p_khr_id => l_contracts_csr.khr_id,
1890: p_primary_sty_purpose => l_investor_rental_accrual,
1891: --sechawla : INVESTOR_RENTAL_ACCRUAL is the primary stream type purpose on the SGT of reporing product(OP lease)

Line 1909: OKL_STREAMS_UTIL.get_primary_stream_type_rep

1905: rep_stream_type_purpose := l_rental_accrual; -- Rental Accrual for reporting product
1906: --Rental Accrual stream is also generated for the reporting product (if OP Lease), when contract
1907: --is Booked. This stream is used to generate Investor Rental Accrual Stream for reporting product, upon IA activation
1908: ELSIF lx_rep_deal_type IN ('LEASEDF', 'LEASEST') THEN
1909: OKL_STREAMS_UTIL.get_primary_stream_type_rep
1910: (
1911: p_khr_id => l_contracts_csr.khr_id,
1912: p_primary_sty_purpose => l_investor_pre_tax_income,
1913: --INVESTOR_PRE_TAX_INCOME is the primary stream type purpose on the SGT of reporting product (DF/ST)

Line 1937: OKL_STREAMS_UTIL.get_primary_stream_type

1933:
1934:
1935: --Bug 4228708 - End of ChangesB
1936: ELSIF l_contracts_csr.deal_type IN ('LEASEDF', 'LEASEST') THEN -- deal type of primary product of the contract
1937: OKL_STREAMS_UTIL.get_primary_stream_type
1938: (
1939: p_khr_id => l_contracts_csr.khr_id,
1940: p_primary_sty_purpose => l_investor_pre_tax_income,
1941: --INVESTOR_PRE_TAX_INCOME is the primary stream type purpose on the SGT of DF/ST lease contract

Line 1977: OKL_STREAMS_UTIL.get_primary_stream_type_rep

1973: ---generate Investor Rental Accrual / Pre Tax Income streams for reporting product
1974: -- IF lx_rep_product IS NOT NULL AND l_sec_rep_method = 'AUTOMATED' THEN
1975: IF lx_rep_product IS NOT NULL THEN
1976: IF lx_rep_deal_type = 'LEASEOP' THEN
1977: OKL_STREAMS_UTIL.get_primary_stream_type_rep
1978: (
1979: p_khr_id => l_contracts_csr.khr_id,
1980: p_primary_sty_purpose => l_investor_rental_accrual,
1981: --sechawla : INVESTOR_RENTAL_ACCRUAL is the primary stream type purpose on the SGT of reporing product(OP lease)

Line 1999: OKL_STREAMS_UTIL.get_primary_stream_type_rep

1995: rep_stream_type_purpose := l_rental_accrual; -- Rental Accrual for reporting product
1996: --Rental Accrual stream is generated for the reporting product (if OP Lease), when contract
1997: --is Booked. This stream is used to generate Investor Rental Accrual Stream for reporting product, upon IA activation
1998: ELSIF lx_rep_deal_type IN ('LEASEDF', 'LEASEST') THEN
1999: OKL_STREAMS_UTIL.get_primary_stream_type_rep
2000: (
2001: p_khr_id => l_contracts_csr.khr_id,
2002: p_primary_sty_purpose => l_investor_pre_tax_income,
2003: --INVESTOR_PRE_TAX_INCOME is the primary stream type purpose on the SGT of reporting product (DF/ST)

Line 2033: OKL_STREAMS_UTIL.get_primary_stream_type

2029: Start Changes
2030: */
2031: ---sechawla 09-mar-09 : MG Impact on Investor Agreement : No impacts on Loans
2032: ELSIF l_contracts_csr.deal_type IN ('LOAN', 'LOAN-REVOLVING') THEN
2033: OKL_STREAMS_UTIL.get_primary_stream_type
2034: (
2035: p_khr_id => l_contracts_csr.khr_id,
2036: p_primary_sty_purpose => l_inv_interest_income_accrual,
2037: x_return_status => l_return_status,

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

2393: Start Changes
2394: */
2395: --get sty_id for the contract based on deal type
2396: IF l_contracts_csr.deal_type = 'LEASEOP' THEN -- deal type of primary product of the contract
2397: OKL_STREAMS_UTIL.get_primary_stream_type
2398: (
2399: p_khr_id => l_contracts_csr.khr_id,
2400: p_primary_sty_purpose => l_investor_rental_accrual,
2401: --sechawla : INVESTOR_RENTAL_ACCRUAL is the primary stream type purpose on the SGT of OP lease contract

Line 2443: OKL_STREAMS_UTIL.get_primary_stream_type_rep

2439: ---generate Investor Rental Accrual / Pre Tax Income streams for reporting product
2440: --IF lx_rep_product IS NOT NULL AND l_sec_rep_method = 'AUTOMATED' THEN
2441: IF lx_rep_product IS NOT NULL THEN
2442: IF lx_rep_deal_type = 'LEASEOP' THEN
2443: OKL_STREAMS_UTIL.get_primary_stream_type_rep
2444: (
2445: p_khr_id => l_contracts_csr.khr_id,
2446: p_primary_sty_purpose => l_investor_rental_accrual,
2447: --sechawla : INVESTOR_RENTAL_ACCRUAL is the primary stream type purpose on the SGT of reporing product(OP lease)

Line 2465: OKL_STREAMS_UTIL.get_primary_stream_type_rep

2461: rep_stream_type_purpose := l_rental_accrual; -- Rental Accrual for reporting product
2462: --Rental Accrual stream is also generated for the reporting product (if OP Lease), when contract
2463: --is Booked. This stream is used to generate Investor Rental Accrual Stream for reporting product, upon IA activation
2464: ELSIF lx_rep_deal_type IN ('LEASEDF', 'LEASEST') THEN
2465: OKL_STREAMS_UTIL.get_primary_stream_type_rep
2466: (
2467: p_khr_id => l_contracts_csr.khr_id,
2468: p_primary_sty_purpose => l_investor_pre_tax_income,
2469: --INVESTOR_PRE_TAX_INCOME is the primary stream type purpose on the SGT of reporting product (DF/ST)

Line 2491: OKL_STREAMS_UTIL.get_primary_stream_type

2487: END IF;
2488: --------------sechawla 09-mar-09 : MG Impact on Investor Agreement end -----
2489:
2490: ELSIF l_contracts_csr.deal_type IN ('LEASEDF', 'LEASEST') THEN -- deal type of primary product of the contract
2491: OKL_STREAMS_UTIL.get_primary_stream_type
2492: (
2493: p_khr_id => l_contracts_csr.khr_id,
2494: p_primary_sty_purpose => l_investor_pre_tax_income,
2495: --INVESTOR_PRE_TAX_INCOME is the primary stream type purpose on the SGT of DF/ST lease contract

Line 2532: OKL_STREAMS_UTIL.get_primary_stream_type_rep

2528: ---generate Investor Rental Accrual / Pre Tax Income streams for reporting product
2529: --IF lx_rep_product IS NOT NULL AND l_sec_rep_method = 'AUTOMATED' THEN
2530: IF lx_rep_product IS NOT NULL THEN
2531: IF lx_rep_deal_type = 'LEASEOP' THEN
2532: OKL_STREAMS_UTIL.get_primary_stream_type_rep
2533: (
2534: p_khr_id => l_contracts_csr.khr_id,
2535: p_primary_sty_purpose => l_investor_rental_accrual,
2536: --sechawla : INVESTOR_RENTAL_ACCRUAL is the primary stream type purpose on the SGT of reporing product(OP lease)

Line 2554: OKL_STREAMS_UTIL.get_primary_stream_type_rep

2550: rep_stream_type_purpose := l_rental_accrual; -- Rental Accrual for reporting product
2551: --Rental Accrual stream is generated for the reporting product (if OP Lease), when contract
2552: --is Booked. This stream is used to generate Investor Rental Accrual Stream for reporting product, upon IA activation
2553: ELSIF lx_rep_deal_type IN ('LEASEDF', 'LEASEST') THEN
2554: OKL_STREAMS_UTIL.get_primary_stream_type_rep
2555: (
2556: p_khr_id => l_contracts_csr.khr_id,
2557: p_primary_sty_purpose => l_investor_pre_tax_income,
2558: --INVESTOR_PRE_TAX_INCOME is the primary stream type purpose on the SGT of reporting product (DF/ST)

Line 2589: OKL_STREAMS_UTIL.get_primary_stream_type

2585: Start Changes
2586: */
2587: ---sechawla 09-mar-09 : MG Impact on Investor Agreement : No impacts on Loans
2588: ELSIF l_contracts_csr.deal_type IN ('LOAN', 'LOAN-REVOLVING') THEN
2589: OKL_STREAMS_UTIL.get_primary_stream_type
2590: (
2591: p_khr_id => l_contracts_csr.khr_id,
2592: p_primary_sty_purpose => l_inv_interest_income_accrual,
2593: x_return_status => l_return_status,

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

2929:
2930: CURSOR non_accrued_streams_csr(p_khr_id NUMBER, p_sty_code VARCHAR2, p_date DATE) IS
2931: SELECT ste.id
2932: FROM OKL_STRM_TYPE_B sty,
2933: OKL_STREAMS stm,
2934: OKL_STRM_ELEMENTS ste
2935: WHERE stm.khr_id = p_khr_id
2936: AND stm.sty_id = sty.id
2937: --AND sty.code = p_sty_code

Line 2949: OKL_STREAMS stm,

2945: --sechawla 10-mar-09 MG Impact
2946: CURSOR rep_non_accrued_streams_csr(p_khr_id NUMBER, p_sty_code VARCHAR2, p_date DATE) IS
2947: SELECT ste.id
2948: FROM OKL_STRM_TYPE_B sty,
2949: OKL_STREAMS stm,
2950: OKL_STRM_ELEMENTS ste
2951: WHERE stm.khr_id = p_khr_id
2952: AND stm.sty_id = sty.id
2953: --AND sty.code = p_sty_code

Line 2971: OKL_STREAMS stm,

2967:
2968: CURSOR accrued_streams_csr(p_khr_id NUMBER, p_sty_code VARCHAR2, p_date DATE) IS
2969: SELECT ste.id
2970: FROM OKL_STRM_TYPE_B sty,
2971: OKL_STREAMS stm,
2972: OKL_STRM_ELEMENTS ste
2973: WHERE stm.khr_id = p_khr_id
2974: AND stm.sty_id = sty.id
2975: --AND sty.code = p_sty_code

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

3300: CURSOR l_strm_for_line_csr(chrid NUMBER, kleid NUMBER)
3301: IS
3302: SELECT
3303: str.sty_id sty_id
3304: --FROM okl_streams str,
3305: FROM okl_streams_rep_v str, -- Bug# 10091594
3306: okl_strm_type_b sty
3307: WHERE str.sty_id = sty.id
3308: AND str.say_code = 'CURR'

Line 3305: FROM okl_streams_rep_v str, -- Bug# 10091594

3301: IS
3302: SELECT
3303: str.sty_id sty_id
3304: --FROM okl_streams str,
3305: FROM okl_streams_rep_v str, -- Bug# 10091594
3306: okl_strm_type_b sty
3307: WHERE str.sty_id = sty.id
3308: AND str.say_code = 'CURR'
3309: AND str.khr_id = chrid

Line 3318: --FROM okl_streams str,

3314: IS
3315: SELECT
3316: sum(ste.amount) amount,
3317: str.sty_id sty_id
3318: --FROM okl_streams str,
3319: FROM okl_streams_rep_v str, -- MGAAP 7263041
3320: okl_strm_elements ste,
3321: okl_strm_type_b sty
3322: WHERE ste.stm_id = str.id

Line 3319: FROM okl_streams_rep_v str, -- MGAAP 7263041

3315: SELECT
3316: sum(ste.amount) amount,
3317: str.sty_id sty_id
3318: --FROM okl_streams str,
3319: FROM okl_streams_rep_v str, -- MGAAP 7263041
3320: okl_strm_elements ste,
3321: okl_strm_type_b sty
3322: WHERE ste.stm_id = str.id
3323: AND str.sty_id = sty.id

Line 3336: --FROM okl_streams str,

3332: IS
3333: SELECT
3334: sum(ste.amount) amount,
3335: str.sty_id sty_id
3336: --FROM okl_streams str,
3337: FROM okl_streams_rep_v str, -- MGAAP 7263041
3338: okl_strm_elements ste,
3339: okl_strm_type_b sty
3340: WHERE ste.stm_id = str.id

Line 3337: FROM okl_streams_rep_v str, -- MGAAP 7263041

3333: SELECT
3334: sum(ste.amount) amount,
3335: str.sty_id sty_id
3336: --FROM okl_streams str,
3337: FROM okl_streams_rep_v str, -- MGAAP 7263041
3338: okl_strm_elements ste,
3339: okl_strm_type_b sty
3340: WHERE ste.stm_id = str.id
3341: AND str.sty_id = sty.id

Line 3354: --FROM okl_streams str,

3350: CURSOR l_bill_amt_csr(chrid NUMBER, kleid NUMBER,tadate DATE, strmPurpose VARCHAR2)
3351: IS
3352: SELECT
3353: sum(ste.amount)
3354: --FROM okl_streams str,
3355: FROM okl_streams_rep_v str, -- MGAAP 7263041
3356: okl_strm_elements ste,
3357: okl_strm_type_b sty
3358: WHERE ste.stm_id = str.id

Line 3355: FROM okl_streams_rep_v str, -- MGAAP 7263041

3351: IS
3352: SELECT
3353: sum(ste.amount)
3354: --FROM okl_streams str,
3355: FROM okl_streams_rep_v str, -- MGAAP 7263041
3356: okl_strm_elements ste,
3357: okl_strm_type_b sty
3358: WHERE ste.stm_id = str.id
3359: AND str.sty_id = sty.id

Line 3370: --FROM okl_streams str,

3366: CURSOR l_bill_pmt_sty_csr(chrid NUMBER, kleid NUMBER, styid NUMBER, tadate DATE)
3367: IS
3368: SELECT
3369: sum(ste.amount)
3370: --FROM okl_streams str,
3371: FROM okl_streams_rep_v str, -- MGAAP 7263041
3372: okl_strm_elements ste,
3373: okl_strm_type_b sty
3374: WHERE ste.stm_id = str.id

Line 3371: FROM okl_streams_rep_v str, -- MGAAP 7263041

3367: IS
3368: SELECT
3369: sum(ste.amount)
3370: --FROM okl_streams str,
3371: FROM okl_streams_rep_v str, -- MGAAP 7263041
3372: okl_strm_elements ste,
3373: okl_strm_type_b sty
3374: WHERE ste.stm_id = str.id
3375: AND str.sty_id = sty.id

Line 3442: --FROM okl_streams str,

3438: IS
3439: SELECT
3440: sum(ste.amount) amount,
3441: str.sty_id sty_id
3442: --FROM okl_streams str,
3443: FROM okl_streams_rep_v str, -- MGAAP 7263041
3444: okl_strm_elements ste,
3445: okl_strm_type_b sty
3446: WHERE ste.stm_id = str.id

Line 3443: FROM okl_streams_rep_v str, -- MGAAP 7263041

3439: SELECT
3440: sum(ste.amount) amount,
3441: str.sty_id sty_id
3442: --FROM okl_streams str,
3443: FROM okl_streams_rep_v str, -- MGAAP 7263041
3444: okl_strm_elements ste,
3445: okl_strm_type_b sty
3446: WHERE ste.stm_id = str.id
3447: AND str.sty_id = sty.id

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

4098: CURSOR non_accrued_streams_csr(p_khr_id NUMBER, p_sty_code VARCHAR2, p_date DATE)
4099: IS
4100: SELECT ste.id
4101: FROM OKL_STRM_TYPE_B sty,
4102: OKL_STREAMS stm,
4103: OKL_STRM_ELEMENTS ste
4104: WHERE stm.khr_id = p_khr_id
4105: AND stm.sty_id = sty.id
4106: --AND sty.code = p_sty_code

Line 4120: OKL_STREAMS stm,

4116: CURSOR rep_non_accrued_streams_csr(p_khr_id NUMBER, p_sty_code VARCHAR2, p_date DATE)
4117: IS
4118: SELECT ste.id
4119: FROM OKL_STRM_TYPE_B sty,
4120: OKL_STREAMS stm,
4121: OKL_STRM_ELEMENTS ste
4122: WHERE stm.khr_id = p_khr_id
4123: AND stm.sty_id = sty.id
4124: --AND sty.code = p_sty_code

Line 4142: OKL_STREAMS stm,

4138: CURSOR accrued_streams_csr(p_khr_id NUMBER, p_sty_code VARCHAR2, p_date DATE)
4139: IS
4140: SELECT ste.id
4141: FROM OKL_STRM_TYPE_B sty,
4142: OKL_STREAMS stm,
4143: OKL_STRM_ELEMENTS ste
4144: WHERE stm.khr_id = p_khr_id
4145: AND stm.sty_id = sty.id
4146: --AND sty.code = p_sty_code

Line 4199: OKL_STREAMS stm,

4195: CURSOR get_ear_billable_stream_csr (p_khr_id NUMBER)
4196: IS
4197: SELECT MIN(ste.stream_element_date)
4198: FROM OKL_STRM_TYPE_B sty,
4199: OKL_STREAMS stm,
4200: OKL_STRM_ELEMENTS ste
4201: WHERE stm.khr_id = p_khr_id
4202: AND stm.sty_id = sty.id
4203: AND sty.stream_type_purpose IN ( 'RENT', 'PRINCIPAL_PAYMENT')

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 ,