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_STREAM_GENERATOR_PVT dependencies on OKL_ISG_UTILS_PVT

Line 347: p_get_k_info_csr OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR%ROWTYPE;

343:
344: l_prog_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'get_mapped_stream';
345: l_sty_id NUMBER;
346: l_primary_sty_id NUMBER;
347: p_get_k_info_csr OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR%ROWTYPE;
348: BEGIN
349: -- Enhancement pending to remove hard coding dependency (TBD by MCHAKRAB, SRAWLING)
350: -- Accrual Stream Type will be specified during setup of Payment Stream Type
351: IF p_rollover_pmnts.styId IS NULL

Line 360: OPEN OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR (p_khr_id);

356: ELSE
357: r_rollover_pmnts := p_rollover_pmnts;
358: END IF;
359:
360: OPEN OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR (p_khr_id);
361: FETCH OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR INTO p_get_k_info_csr;
362: CLOSE OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR;
363:
364: l_primary_sty_id := nvl(p_primary_sty_id, r_rollover_pmnts.styId);

Line 361: FETCH OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR INTO p_get_k_info_csr;

357: r_rollover_pmnts := p_rollover_pmnts;
358: END IF;
359:
360: OPEN OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR (p_khr_id);
361: FETCH OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR INTO p_get_k_info_csr;
362: CLOSE OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR;
363:
364: l_primary_sty_id := nvl(p_primary_sty_id, r_rollover_pmnts.styId);
365:

Line 362: CLOSE OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR;

358: END IF;
359:
360: OPEN OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR (p_khr_id);
361: FETCH OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR INTO p_get_k_info_csr;
362: CLOSE OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR;
363:
364: l_primary_sty_id := nvl(p_primary_sty_id, r_rollover_pmnts.styId);
365:
366: -- print( l_prog_name, 'begin' );

Line 373: OKL_ISG_UTILS_PVT.get_dep_stream_type(

369: IF p_sty_purpose = 'RENT' AND p_deal_type = 'LEASEOP' AND
370: (p_line_style = 'FREE_FORM1' OR p_line_style IS NULL) THEN
371: --x_mapped_stream := 'RENTAL ACCRUAL';
372: -- print( l_prog_name, '##1##' );
373: OKL_ISG_UTILS_PVT.get_dep_stream_type(
374: p_khr_id => p_khr_id,
375: p_deal_type => p_deal_type,
376: p_primary_sty_id => l_primary_sty_id,
377: p_dependent_sty_purpose => 'RENT_ACCRUAL',

Line 392: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

388: -- print( l_prog_name, '##3##' );
389: --x_mapped_stream := 'PASS THROUGH REVENUE ACCRUAL';
390: --Bug 4434343 - Start of Changes
391: IF (p_line_style = 'FEE') THEN
392: OKL_ISG_UTILS_PVT.get_dependent_stream_type(
393: p_khr_id => p_khr_id,
394: p_deal_type => p_deal_type,
395: p_primary_sty_id => l_primary_sty_id,
396: p_dependent_sty_purpose => 'PASS_THRU_REV_ACCRUAL',

Line 401: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

397: x_return_status => x_return_status,
398: x_dependent_sty_id => l_sty_id,
399: x_dependent_sty_name => x_mapped_stream);
400: ELSIF (p_line_style = 'SOLD_SERVICE') OR (p_line_style = 'LINK_SERV_ASSET') THEN
401: OKL_ISG_UTILS_PVT.get_dependent_stream_type(
402: p_khr_id => p_khr_id,
403: p_deal_type => p_deal_type,
404: p_primary_sty_id => l_primary_sty_id,
405: p_dependent_sty_purpose => 'PASS_THRU_SVC_REV_ACCRUAL',

Line 414: OKL_ISG_UTILS_PVT.get_dep_stream_type(

410: --Bug 4434343 - End of Changes
411: ELSIF ((p_line_style = 'SOLD_SERVICE') OR (p_line_style = 'LINK_SERV_ASSET')) THEN
412: -- print( l_prog_name, '##4##' );
413: --x_mapped_stream := 'SERVICE INCOME';
414: OKL_ISG_UTILS_PVT.get_dep_stream_type(
415: p_khr_id => p_khr_id,
416: p_deal_type => p_deal_type,
417: p_primary_sty_id => l_primary_sty_id,
418: p_dependent_sty_purpose => 'SERVICE_INCOME',

Line 429: OKL_ISG_UTILS_PVT.get_dep_stream_type(

425: (p_sty_purpose <> 'SECURITY_DEPOSIT') THEN
426:
427: If ( p_fee_type = 'INCOME' AND p_recurr_yn = OKL_API.G_FALSE ) Then
428: --x_mapped_stream := 'AMORTIZED FEE INCOME';
429: OKL_ISG_UTILS_PVT.get_dep_stream_type(
430: p_khr_id => p_khr_id,
431: p_deal_type => p_deal_type,
432: p_primary_sty_id => l_primary_sty_id,
433: p_dependent_sty_purpose => 'AMORTIZE_FEE_INCOME',

Line 443: OKL_ISG_UTILS_PVT.get_dep_stream_type(

439: elsif ( p_fee_type = 'FINANCED' OR p_fee_type = 'ROLLOVER') Then
440: x_mapped_stream := NULL;
441: else
442: --x_mapped_stream := 'FEE INCOME';
443: OKL_ISG_UTILS_PVT.get_dep_stream_type(
444: p_khr_id => p_khr_id,
445: p_deal_type => p_deal_type,
446: p_primary_sty_id => l_primary_sty_id,
447: p_dependent_sty_purpose => 'ACCRUED_FEE_INCOME',

Line 463: OKL_ISG_UTILS_PVT.get_dep_stream_type(

459:
460: IF (p_deal_type IN ('LOAN', 'LOAN-REVOLVING')) OR
461: ( p_fee_type in ('FINANCED', 'ROLLOVER','LINK_FEE_ASSET') ) THEN
462: --x_mapped_stream := 'PRE-TAX INCOME';
463: OKL_ISG_UTILS_PVT.get_dep_stream_type(
464: p_khr_id => p_khr_id,
465: p_deal_type => p_deal_type,
466: p_primary_sty_id => l_primary_sty_id,
467: p_dependent_sty_purpose => 'INTEREST_INCOME',

Line 475: OKL_ISG_UTILS_PVT.get_dep_stream_type(

471: p_get_k_info_rec => p_get_k_info_csr);
472:
473: ELSIF (p_deal_type IN ('LEASEDF', 'LEASEST')) THEN
474: --x_mapped_stream := 'PRE-TAX INCOME';
475: OKL_ISG_UTILS_PVT.get_dep_stream_type(
476: p_khr_id => p_khr_id,
477: p_deal_type => p_deal_type,
478: p_primary_sty_id => l_primary_sty_id,
479: p_dependent_sty_purpose => 'LEASE_INCOME',

Line 529: OKL_ISG_UTILS_PVT.get_primary_stream_type(

525: END IF;
526:
527: If ( p_sty_purpose = 'RENT' ) THen
528: --x_mapped_stream := 'INVESTOR RENT DISBURSEMENT BASIS';
529: OKL_ISG_UTILS_PVT.get_primary_stream_type(
530: p_khr_id => p_khr_id,
531: p_pdt_id => r_hdr.pid,
532: p_primary_sty_purpose => 'INVESTOR_RENT_DISB_BASIS',
533: x_return_status => x_return_status,

Line 538: OKL_ISG_UTILS_PVT.get_primary_stream_type(

534: x_primary_sty_id => l_sty_id,
535: x_primary_sty_name => x_mapped_stream);
536: ElsIf ( p_sty_purpose = 'RESIDUAL' ) Then
537: --x_mapped_stream := 'INVESTOR RESIDUAL DISBURSEMENT BASIS';
538: OKL_ISG_UTILS_PVT.get_primary_stream_type(
539: p_khr_id => p_khr_id,
540: p_pdt_id => r_hdr.pid,
541: p_primary_sty_purpose => 'INVESTOR_RESIDUAL_DISB_BASIS',
542: x_return_status => x_return_status,

Line 559: OKL_ISG_UTILS_PVT.get_primary_stream_type(

555: END IF;
556:
557: If ( p_sty_purpose = 'RENT' ) THen
558: --x_mapped_stream := 'PRESENT VALUE SECURITIZED RENT';
559: OKL_ISG_UTILS_PVT.get_primary_stream_type(
560: p_khr_id => p_khr_id,
561: p_pdt_id => r_hdr.pid,
562: p_primary_sty_purpose => 'PV_RENT_SECURITIZED',
563: x_return_status => x_return_status,

Line 568: OKL_ISG_UTILS_PVT.get_primary_stream_type(

564: x_primary_sty_id => l_sty_id,
565: x_primary_sty_name => x_mapped_stream);
566: ElsIf ( p_sty_purpose = 'RESIDUAL' ) Then
567: --x_mapped_stream := 'PRESENT VALUE SECURITIZED RESIDUAL';
568: OKL_ISG_UTILS_PVT.get_primary_stream_type(
569: p_khr_id => p_khr_id,
570: p_pdt_id => r_hdr.pid,
571: p_primary_sty_purpose => 'PV_RV_SECURITIZED',
572: x_return_status => x_return_status,

Line 660: OKL_ISG_UTILS_PVT.get_primary_stream_type(

656:
657: Begin
658: --print( l_prog_name, ' deal type ' || p_deal_type );
659: -- Utility API to get the Stream Type Id of the RENT Stream Type.
660: OKL_ISG_UTILS_PVT.get_primary_stream_type(
661: p_khr_id => p_khr_id,
662: p_deal_type => p_deal_type,
663: p_primary_sty_purpose => 'RENT',
664: x_return_status => x_return_status,

Line 1079: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

1075: RAISE OKL_API.G_EXCEPTION_ERROR;
1076: END IF;
1077:
1078:
1079: OKL_ISG_UTILS_PVT.get_dependent_stream_type(
1080: p_khr_id => p_khr_id,
1081: p_deal_type => l_deal_type,
1082: p_dependent_sty_purpose => 'INTEREST_INCOME',
1083: x_return_status => x_return_status,

Line 1093: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

1089: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
1090: RAISE OKL_API.G_EXCEPTION_ERROR;
1091: END IF;
1092:
1093: OKL_ISG_UTILS_PVT.get_dependent_stream_type(
1094: p_khr_id => p_khr_id,
1095: p_deal_type => l_deal_type,
1096: p_dependent_sty_purpose => 'INTEREST_PAYMENT',
1097: x_return_status => lx_return_status,

Line 1107: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

1103: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
1104: RAISE OKL_API.G_EXCEPTION_ERROR;
1105: END IF;
1106:
1107: OKL_ISG_UTILS_PVT.get_dependent_stream_type(
1108: p_khr_id => p_khr_id,
1109: p_deal_type => l_deal_type,
1110: p_dependent_sty_purpose => 'PRINCIPAL_PAYMENT',
1111: x_return_status => lx_return_status,

Line 1121: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

1117: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
1118: RAISE OKL_API.G_EXCEPTION_ERROR;
1119: END IF;
1120:
1121: OKL_ISG_UTILS_PVT.get_dependent_stream_type(
1122: p_khr_id => p_khr_id,
1123: p_deal_type => l_deal_type,
1124: p_dependent_sty_purpose => 'PRINCIPAL_BALANCE',
1125: x_return_status => lx_return_status,

Line 1135: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

1131: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
1132: RAISE OKL_API.G_EXCEPTION_ERROR;
1133: END IF;
1134:
1135: OKL_ISG_UTILS_PVT.get_dependent_stream_type(
1136: p_khr_id => p_khr_id,
1137: p_deal_type => l_deal_type,
1138: p_dependent_sty_purpose => 'TERMINATION_VALUE',
1139: x_return_status => lx_return_status,

Line 1691: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

1687: l_primary_sty_id := r_rollover_pmnts.styId;
1688:
1689: IF p_deal_type = 'LEASEOP' THEN
1690: --l_sty_name := 'RENTAL ACCRUAL';
1691: OKL_ISG_UTILS_PVT.get_dependent_stream_type(
1692: p_khr_id => p_khr_id,
1693: p_deal_type => p_deal_type,
1694: p_primary_sty_id => l_primary_sty_id,
1695: p_dependent_sty_purpose => 'RENT_ACCRUAL',

Line 1707: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

1703: RAISE OKL_API.G_EXCEPTION_ERROR;
1704: END IF;
1705: ELSIF p_deal_type IN ('LEASEDF', 'LEASEST') THEN
1706: --l_sty_name := 'PRE-TAX INCOME';
1707: OKL_ISG_UTILS_PVT.get_dependent_stream_type(
1708: p_khr_id => p_khr_id,
1709: p_deal_type => p_deal_type,
1710: p_primary_sty_id => l_primary_sty_id,
1711: p_dependent_sty_purpose => 'LEASE_INCOME',

Line 1724: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

1720: END IF;
1721:
1722: ELSIF p_deal_type IN ('LOAN', 'LOAN-REVOLVING') THEN
1723: --l_sty_name := 'PRE-TAX INCOME';
1724: OKL_ISG_UTILS_PVT.get_dependent_stream_type(
1725: p_khr_id => p_khr_id,
1726: p_deal_type => p_deal_type,
1727: p_primary_sty_id => l_primary_sty_id,
1728: p_dependent_sty_purpose => 'INTEREST_INCOME',

Line 2061: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

2057: IF p_sty_purpose = 'RENT' AND p_deal_type = 'LEASEOP' AND
2058: (p_line_style = 'FREE_FORM1' OR p_line_style IS NULL) THEN
2059: --x_mapped_stream := 'RENTAL ACCRUAL';
2060: print( l_prog_name, '##1##' );
2061: OKL_ISG_UTILS_PVT.get_dependent_stream_type(
2062: p_khr_id => p_khr_id,
2063: p_deal_type => p_deal_type,
2064: p_primary_sty_id => l_primary_sty_id,
2065: p_dependent_sty_purpose => 'RENT_ACCRUAL',

Line 2081: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

2077: --If condition added by mansrini on 10-Jun-2005 for generating accrual streams for Service Lines
2078: --Bug 4434343 -Start of Changes
2079:
2080: IF (p_line_style = 'FEE') THEN
2081: OKL_ISG_UTILS_PVT.get_dependent_stream_type(
2082: p_khr_id => p_khr_id,
2083: p_deal_type => p_deal_type,
2084: p_primary_sty_id => l_primary_sty_id,
2085: p_dependent_sty_purpose => 'PASS_THRU_REV_ACCRUAL',

Line 2091: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

2087: x_dependent_sty_id => l_sty_id,
2088: x_dependent_sty_name => x_mapped_stream);
2089:
2090: ELSIF ((p_line_style = 'SOLD_SERVICE') OR (p_line_style = 'LINK_SERV_ASSET')) THEN
2091: OKL_ISG_UTILS_PVT.get_dependent_stream_type(
2092: p_khr_id => p_khr_id,
2093: p_deal_type => p_deal_type,
2094: p_primary_sty_id => l_primary_sty_id,
2095: p_dependent_sty_purpose => 'PASS_THRU_SVC_REV_ACCRUAL',

Line 2105: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

2101:
2102: ELSIF ((p_line_style = 'SOLD_SERVICE') OR (p_line_style = 'LINK_SERV_ASSET')) THEN
2103: print( l_prog_name, '##4##' );
2104: --x_mapped_stream := 'SERVICE INCOME';
2105: OKL_ISG_UTILS_PVT.get_dependent_stream_type(
2106: p_khr_id => p_khr_id,
2107: p_deal_type => p_deal_type,
2108: p_primary_sty_id => l_primary_sty_id,
2109: p_dependent_sty_purpose => 'SERVICE_INCOME',

Line 2119: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

2115: (p_sty_purpose <> 'SECURITY_DEPOSIT') THEN
2116:
2117: If ( p_fee_type = 'INCOME' AND p_recurr_yn = OKL_API.G_FALSE ) Then
2118: --x_mapped_stream := 'AMORTIZED FEE INCOME';
2119: OKL_ISG_UTILS_PVT.get_dependent_stream_type(
2120: p_khr_id => p_khr_id,
2121: p_deal_type => p_deal_type,
2122: p_primary_sty_id => l_primary_sty_id,
2123: p_dependent_sty_purpose => 'AMORTIZE_FEE_INCOME',

Line 2132: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

2128: elsif ( p_fee_type = 'FINANCED' OR p_fee_type = 'ROLLOVER') Then
2129: x_mapped_stream := NULL;
2130: else
2131: --x_mapped_stream := 'FEE INCOME';
2132: OKL_ISG_UTILS_PVT.get_dependent_stream_type(
2133: p_khr_id => p_khr_id,
2134: p_deal_type => p_deal_type,
2135: p_primary_sty_id => l_primary_sty_id,
2136: p_dependent_sty_purpose => 'ACCRUED_FEE_INCOME',

Line 2151: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

2147: ELSIF p_mapping_type = 'PRE-TAX INCOME' THEN
2148:
2149: IF (p_deal_type IN ('LEASEDF', 'LEASEST')) THEN
2150: --x_mapped_stream := 'PRE-TAX INCOME';
2151: OKL_ISG_UTILS_PVT.get_dependent_stream_type(
2152: p_khr_id => p_khr_id,
2153: p_deal_type => p_deal_type,
2154: p_primary_sty_id => l_primary_sty_id,
2155: p_dependent_sty_purpose => 'LEASE_INCOME',

Line 2162: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

2158: x_dependent_sty_name => x_mapped_stream);
2159:
2160: ElsIF (p_deal_type IN ('LOAN', 'LOAN-REVOLVING')) OR ( p_fee_type in ('FINANCED', 'ROLLOVER','LINK_FEE_ASSET') ) THEN
2161: --x_mapped_stream := 'PRE-TAX INCOME';
2162: OKL_ISG_UTILS_PVT.get_dependent_stream_type(
2163: p_khr_id => p_khr_id,
2164: p_deal_type => p_deal_type,
2165: p_primary_sty_id => l_primary_sty_id,
2166: p_dependent_sty_purpose => 'INTEREST_INCOME',

Line 2214: OKL_ISG_UTILS_PVT.get_primary_stream_type(

2210: CLOSE c_hdr;
2211: IF p_deal_type = 'LEASE' THEN
2212: If ( p_sty_purpose = 'RENT' ) THen
2213: --x_mapped_stream := 'INVESTOR RENT DISBURSEMENT BASIS';
2214: OKL_ISG_UTILS_PVT.get_primary_stream_type(
2215: p_khr_id => p_khr_id,
2216: p_pdt_id => r_hdr.pid,
2217: p_primary_sty_purpose => 'INVESTOR_RENT_DISB_BASIS',
2218: x_return_status => x_return_status,

Line 2224: OKL_ISG_UTILS_PVT.get_primary_stream_type(

2220: x_primary_sty_name => x_mapped_stream);
2221:
2222: ElsIf ( p_sty_purpose = 'RESIDUAL' ) Then
2223: --x_mapped_stream := 'INVESTOR RESIDUAL DISBURSEMENT BASIS';
2224: OKL_ISG_UTILS_PVT.get_primary_stream_type(
2225: p_khr_id => p_khr_id,
2226: p_pdt_id => r_hdr.pid,
2227: p_primary_sty_purpose => 'INVESTOR_RESIDUAL_DISB_BASIS',
2228: x_return_status => x_return_status,

Line 2235: OKL_ISG_UTILS_PVT.get_primary_stream_type(

2231: End If;
2232: ELSIF p_deal_type = 'LOAN' THEN
2233: If ( p_sty_purpose = 'LOAN_PAYMENT' ) Then
2234: IF p_stream_type_purpose = 'PRINCIPAL_PAYMENT' THEN
2235: OKL_ISG_UTILS_PVT.get_primary_stream_type(
2236: p_khr_id => p_khr_id,
2237: p_pdt_id => r_hdr.pid,
2238: p_primary_sty_purpose => 'INVESTOR_PRINCIPAL_DISB_BASIS',
2239: x_return_status => x_return_status,

Line 2243: OKL_ISG_UTILS_PVT.get_primary_stream_type(

2239: x_return_status => x_return_status,
2240: x_primary_sty_id => l_sty_id,
2241: x_primary_sty_name => x_mapped_stream);
2242: ELSIF p_stream_type_purpose = 'INTEREST_PAYMENT' THEN
2243: OKL_ISG_UTILS_PVT.get_primary_stream_type(
2244: p_khr_id => p_khr_id,
2245: p_pdt_id => r_hdr.pid,
2246: p_primary_sty_purpose => 'INVESTOR_INTEREST_DISB_BASIS',
2247: x_return_status => x_return_status,

Line 2251: OKL_ISG_UTILS_PVT.get_primary_stream_type(

2247: x_return_status => x_return_status,
2248: x_primary_sty_id => l_sty_id,
2249: x_primary_sty_name => x_mapped_stream);
2250: ELSIF p_stream_type_purpose = 'UNSCHEDULED_PRINCIPAL_PAYMENT' THEN
2251: OKL_ISG_UTILS_PVT.get_primary_stream_type(
2252: p_khr_id => p_khr_id,
2253: p_pdt_id => r_hdr.pid,
2254: p_primary_sty_purpose => 'INVESTOR_PPD_DISB_BASIS',
2255: x_return_status => x_return_status,

Line 2269: OKL_ISG_UTILS_PVT.get_primary_stream_type(

2265: FETCH c_hdr INTO r_hdr;
2266: CLOSE c_hdr;
2267: IF p_deal_type = 'LEASE' THEN
2268: If ( p_sty_purpose = 'RENT' ) THen
2269: OKL_ISG_UTILS_PVT.get_primary_stream_type(
2270: p_khr_id => p_khr_id,
2271: p_pdt_id => r_hdr.pid,
2272: p_primary_sty_purpose => 'PV_RENT_SECURITIZED',
2273: x_return_status => x_return_status,

Line 2278: OKL_ISG_UTILS_PVT.get_primary_stream_type(

2274: x_primary_sty_id => l_sty_id,
2275: x_primary_sty_name => x_mapped_stream);
2276:
2277: ElsIf ( p_sty_purpose = 'RESIDUAL' ) Then
2278: OKL_ISG_UTILS_PVT.get_primary_stream_type(
2279: p_khr_id => p_khr_id,
2280: p_pdt_id => r_hdr.pid,
2281: p_primary_sty_purpose => 'PV_RV_SECURITIZED',
2282: x_return_status => x_return_status,

Line 2289: OKL_ISG_UTILS_PVT.get_primary_stream_type(

2285: End If;
2286: ELSIF p_deal_type = 'LOAN' THEN
2287: If ( p_sty_purpose = 'LOAN_PAYMENT' ) Then
2288: IF p_stream_type_purpose = 'PRINCIPAL_PAYMENT' THEN
2289: OKL_ISG_UTILS_PVT.get_primary_stream_type(
2290: p_khr_id => p_khr_id,
2291: p_pdt_id => r_hdr.pid,
2292: p_primary_sty_purpose => 'PV_PRINCIPAL_SECURITIZED',
2293: x_return_status => x_return_status,

Line 2297: OKL_ISG_UTILS_PVT.get_primary_stream_type(

2293: x_return_status => x_return_status,
2294: x_primary_sty_id => l_sty_id,
2295: x_primary_sty_name => x_mapped_stream);
2296: ELSIF p_stream_type_purpose = 'INTEREST_PAYMENT' THEN
2297: OKL_ISG_UTILS_PVT.get_primary_stream_type(
2298: p_khr_id => p_khr_id,
2299: p_pdt_id => r_hdr.pid,
2300: p_primary_sty_purpose => 'PV_INTEREST_SECURITIZED',
2301: x_return_status => x_return_status,

Line 2305: OKL_ISG_UTILS_PVT.get_primary_stream_type(

2301: x_return_status => x_return_status,
2302: x_primary_sty_id => l_sty_id,
2303: x_primary_sty_name => x_mapped_stream);
2304: ELSIF p_stream_type_purpose = 'UNSCHEDULED_PRINCIPAL_PAYMENT' THEN
2305: OKL_ISG_UTILS_PVT.get_primary_stream_type(
2306: p_khr_id => p_khr_id,
2307: p_pdt_id => r_hdr.pid,
2308: p_primary_sty_purpose => 'PV_UNSCHEDULED_PMT_SECURITIZED',
2309: x_return_status => x_return_status,

Line 2735: OKL_ISG_UTILS_PVT.get_arrears_pay_dates_option(

2731:
2732:
2733: -- djanaswa ER6274342 start
2734: IF p_advance_or_arrears = 'ARREARS' THEN
2735: OKL_ISG_UTILS_PVT.get_arrears_pay_dates_option(
2736: p_khr_id => p_khr_id,
2737: x_arrears_pay_dates_option => l_arrears_pay_dates_option,
2738: x_return_status => lx_return_status);
2739:

Line 3034: OKL_ISG_UTILS_PVT.get_arrears_pay_dates_option(

3030: END IF;
3031:
3032: -- djanaswa ER6274342 start
3033: IF p_advance_or_arrears = 'ARREARS' THEN
3034: OKL_ISG_UTILS_PVT.get_arrears_pay_dates_option(
3035: p_khr_id => p_khr_id,
3036: x_arrears_pay_dates_option => l_arrears_pay_dates_option,
3037: x_return_status => lx_return_status);
3038:

Line 4272: OKL_ISG_UTILS_PVT.get_primary_stream_type(

4268: l_deal_type := l_hdr.deal_type;
4269: l_purpose_code := '-99';
4270: END IF;
4271:
4272: OKL_ISG_UTILS_PVT.get_primary_stream_type(
4273: p_khr_id => p_khr_id,
4274: p_deal_type => l_deal_type,
4275: p_primary_sty_purpose => 'RESIDUAL_VALUE',
4276: x_return_status => lx_return_status,

Line 4288: OKL_ISG_UTILS_PVT.get_arrears_pay_dates_option(

4284: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
4285: RAISE OKL_API.G_EXCEPTION_ERROR;
4286: END IF;
4287:
4288: OKL_ISG_UTILS_PVT.get_arrears_pay_dates_option(
4289: p_khr_id => p_khr_id,
4290: x_arrears_pay_dates_option => l_arrears_pay_dates_option,
4291: x_return_status => lx_return_status);
4292:

Line 4388: OKL_ISG_UTILS_PVT.get_primary_stream_type(

4384: IF ( l_line_rec.capitalize_down_payment_yn = 'Y' AND
4385: ( nvl(l_line_rec.capital_reduction, l_line_rec.capital_reduction_percent) > 0 ) ) AND
4386: (p_generation_type = 'FULL' OR p_generation_type = 'CAPITAL REDUCTION')
4387: THEN
4388: OKL_ISG_UTILS_PVT.get_primary_stream_type(
4389: p_khr_id => p_khr_id,
4390: p_deal_type => l_deal_type,
4391: p_primary_sty_purpose => 'CAPITAL_REDUCTION',
4392: x_return_status => lx_return_status,

Line 4615: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

4611:
4612: */
4613:
4614: -- bug# 4041666
4615: OKL_ISG_UTILS_PVT.get_dependent_stream_type(
4616: p_khr_id => p_khr_id,
4617: p_deal_type => l_deal_type,
4618: p_primary_sty_id => l_asbv_tbl(i).stream_type_id,
4619: p_dependent_sty_purpose => 'SUBSIDY_INCOME',

Line 4699: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

4695:
4696:
4697: l_primary_sty_id := r_rollover_pmnts.styId;
4698:
4699: OKL_ISG_UTILS_PVT.get_dependent_stream_type(
4700: p_khr_id => p_khr_id,
4701: p_deal_type => l_deal_type,
4702: p_primary_sty_id => l_primary_sty_id,
4703: p_dependent_sty_purpose => 'PV_RENT',

Line 5167: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

5163: IF l_pt_tbl.COUNT > 0
5164: THEN
5165: IF l_passthrough_id IS NULL
5166: THEN
5167: OKL_ISG_UTILS_PVT.get_dependent_stream_type(
5168: p_khr_id => p_khr_id,
5169: p_deal_type => l_deal_type,
5170: p_dependent_sty_purpose => 'PASS_THRU_EXP_ACCRUAL',
5171: x_return_status => lx_return_status,

Line 5677: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

5673: IF l_pt_tbl.COUNT > 0 THEN
5674: --Added by mansrini on 30-Jun-2005 for generating pass through accrual streams for service lines
5675: --Bug 4434343 - Start of Changes
5676: IF (l_inflow.lty_code = 'FEE') OR (l_inflow.lty_code = 'LINK_FEE_ASSET') THEN
5677: OKL_ISG_UTILS_PVT.get_dependent_stream_type(
5678: p_khr_id => p_khr_id,
5679: p_deal_type => l_deal_type,
5680: p_primary_sty_id => l_inflow.sty_id,
5681: p_dependent_sty_purpose => 'PASS_THRU_EXP_ACCRUAL',

Line 5691: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

5687: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
5688: RAISE OKL_API.G_EXCEPTION_ERROR;
5689: END IF;
5690: ELSIF (l_inflow.lty_code = 'SOLD_SERVICE') OR (l_inflow.lty_code = 'LINK_SERV_ASSET') THEN
5691: OKL_ISG_UTILS_PVT.get_dependent_stream_type(
5692: p_khr_id => p_khr_id,
5693: p_deal_type => l_deal_type,
5694: p_primary_sty_id => l_inflow.sty_id,
5695: p_dependent_sty_purpose => 'PASS_THRU_SVC_EXP_ACCRUAL',

Line 5810: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

5806: CLOSE fee_strm_type_csr;
5807:
5808: End If;
5809:
5810: OKL_ISG_UTILS_PVT.get_dependent_stream_type(
5811: p_khr_id => p_khr_id,
5812: p_deal_type => l_deal_type,
5813: p_primary_sty_id => fee_strm_type_rec.styp_id,
5814: p_dependent_sty_purpose => 'PASS_THRU_PRO_FEE_ACCRUAL',

Line 6300: p_get_k_info_csr OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR%ROWTYPE;

6296: -- Added by RGOOTY
6297: -- Assuming that there are no Services initially.
6298: exec_svc_csr VARCHAR2(1) := 'F';
6299: l_tmp_cle_id NUMBER;
6300: p_get_k_info_csr OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR%ROWTYPE;
6301:
6302: l_initial_irr NUMBER := 0;
6303: l_asset_count NUMBER := 0;
6304:

Line 6343: OPEN OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR (p_khr_id);

6339: OPEN G_ROLLOVER_PMNTS(p_khr_id);
6340: FETCH G_ROLLOVER_PMNTS INTO r_rollover_pmnts;
6341: CLOSE G_ROLLOVER_PMNTS;
6342:
6343: OPEN OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR (p_khr_id);
6344: FETCH OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR INTO p_get_k_info_csr;
6345: CLOSE OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR;
6346:
6347: -- Added by RGOOTY : End

Line 6344: FETCH OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR INTO p_get_k_info_csr;

6340: FETCH G_ROLLOVER_PMNTS INTO r_rollover_pmnts;
6341: CLOSE G_ROLLOVER_PMNTS;
6342:
6343: OPEN OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR (p_khr_id);
6344: FETCH OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR INTO p_get_k_info_csr;
6345: CLOSE OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR;
6346:
6347: -- Added by RGOOTY : End
6348: OPEN c_hdr;

Line 6345: CLOSE OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR;

6341: CLOSE G_ROLLOVER_PMNTS;
6342:
6343: OPEN OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR (p_khr_id);
6344: FETCH OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR INTO p_get_k_info_csr;
6345: CLOSE OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR;
6346:
6347: -- Added by RGOOTY : End
6348: OPEN c_hdr;
6349: FETCH c_hdr INTO l_hdr;

Line 6362: OKL_ISG_UTILS_PVT.validate_strm_gen_template(

6358: END IF;
6359:
6360: l_asset_guess_iir := l_hdr.base_rate / 100.0;
6361:
6362: OKL_ISG_UTILS_PVT.validate_strm_gen_template(
6363: p_api_version => p_api_version,
6364: p_init_msg_list => p_init_msg_list,
6365: x_return_status => x_return_status,
6366: x_msg_count => x_msg_count,

Line 6703: OKL_ISG_UTILS_PVT.get_dep_stream_type(

6699: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
6700: RAISE OKL_API.G_EXCEPTION_ERROR;
6701: END IF;
6702:
6703: OKL_ISG_UTILS_PVT.get_dep_stream_type(
6704: p_khr_id => p_khr_id,
6705: p_deal_type => l_deal_type,
6706: p_primary_sty_id => l_primary_sty_id,
6707: p_dependent_sty_purpose => 'INTEREST_PAYMENT',

Line 6721: OKL_ISG_UTILS_PVT.get_dep_stream_type(

6717: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
6718: RAISE OKL_API.G_EXCEPTION_ERROR;
6719: END IF;
6720:
6721: OKL_ISG_UTILS_PVT.get_dep_stream_type(
6722: p_khr_id => p_khr_id,
6723: p_deal_type => l_deal_type,
6724: p_primary_sty_id => l_primary_sty_id,
6725: p_dependent_sty_purpose => 'PRINCIPAL_PAYMENT',

Line 6740: OKL_ISG_UTILS_PVT.get_dep_stream_type(

6736: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
6737: RAISE OKL_API.G_EXCEPTION_ERROR;
6738: END IF;
6739:
6740: OKL_ISG_UTILS_PVT.get_dep_stream_type(
6741: p_khr_id => p_khr_id,
6742: p_deal_type => l_deal_type,
6743: p_primary_sty_id => l_primary_sty_id,
6744: p_dependent_sty_purpose => 'PRINCIPAL_BALANCE',

Line 6758: OKL_ISG_UTILS_PVT.get_dep_stream_type(

6754: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
6755: RAISE OKL_API.G_EXCEPTION_ERROR;
6756: END IF;
6757:
6758: OKL_ISG_UTILS_PVT.get_dep_stream_type(
6759: p_khr_id => p_khr_id,
6760: p_deal_type => l_deal_type,
6761: p_primary_sty_id => l_primary_sty_id,
6762: p_dependent_sty_purpose => 'TERMINATION_VALUE',

Line 7677: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

7673:
7674:
7675: IF l_deal_type IN ('LOAN', 'LOAN-REVOLVING') THEN
7676:
7677: OKL_ISG_UTILS_PVT.get_dependent_stream_type(
7678: p_khr_id => p_khr_id,
7679: p_deal_type => l_deal_type,
7680: p_primary_sty_id => l_rent_sty_id,
7681: p_dependent_sty_purpose => 'LOAN_PAYMENT',

Line 7720: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

7716:
7717:
7718: If ( l_rent_sty_id is NOT NULL ) Then
7719:
7720: OKL_ISG_UTILS_PVT.get_dependent_stream_type(
7721: p_khr_id => p_khr_id,
7722: p_deal_type => l_deal_type,
7723: p_primary_sty_id => l_rent_sty_id,
7724: p_dependent_sty_purpose => 'LOAN_PAYMENT',

Line 11105: OKL_ISG_UTILS_PVT.get_primary_stream_type(

11101: FETCH fee_strm_type_csr INTO l_sty_id;
11102: CLOSE fee_strm_type_csr;
11103:
11104: Else
11105: OKL_ISG_UTILS_PVT.get_primary_stream_type(
11106: p_khr_id => p_khr_id,
11107: p_deal_type => l_deal_type,
11108: p_primary_sty_purpose => 'RENT',
11109: x_return_status => x_return_status,

Line 11908: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

11904: OPEN c_hdr;
11905: FETCH c_hdr INTO l_pdt_id, l_currency_code;
11906: CLOSE c_hdr;
11907:
11908: OKL_ISG_UTILS_PVT.get_dependent_stream_type(
11909: p_khr_id => p_khr_id,
11910: p_pdt_id => l_pdt_id,
11911: p_dependent_sty_purpose => 'ACCRUED_FEE_INCOME',
11912: x_return_status => x_return_status,