APPS.OKL_ACCRUAL_SEC_PVT dependencies on OKL_STREAMS_UTIL

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 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 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 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,