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 351: p_get_k_info_csr OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR%ROWTYPE;

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

Line 364: OPEN OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR (p_khr_id);

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

Line 365: FETCH OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR INTO p_get_k_info_csr;

361: r_rollover_pmnts := p_rollover_pmnts;
362: END IF;
363:
364: OPEN OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR (p_khr_id);
365: FETCH OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR INTO p_get_k_info_csr;
366: CLOSE OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR;
367:
368: l_primary_sty_id := nvl(p_primary_sty_id, r_rollover_pmnts.styId);
369:

Line 366: CLOSE OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR;

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

Line 377: OKL_ISG_UTILS_PVT.get_dep_stream_type(

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

Line 396: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

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

Line 405: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

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

Line 418: OKL_ISG_UTILS_PVT.get_dep_stream_type(

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

Line 433: OKL_ISG_UTILS_PVT.get_dep_stream_type(

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

Line 447: OKL_ISG_UTILS_PVT.get_dep_stream_type(

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

Line 467: OKL_ISG_UTILS_PVT.get_dep_stream_type(

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

Line 479: OKL_ISG_UTILS_PVT.get_dep_stream_type(

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

Line 533: OKL_ISG_UTILS_PVT.get_primary_stream_type(

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

Line 542: OKL_ISG_UTILS_PVT.get_primary_stream_type(

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

Line 563: OKL_ISG_UTILS_PVT.get_primary_stream_type(

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

Line 572: OKL_ISG_UTILS_PVT.get_primary_stream_type(

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

Line 669: OKL_ISG_UTILS_PVT.get_primary_stream_type(

665:
666: Begin
667: --print( l_prog_name, ' deal type ' || p_deal_type );
668: -- Utility API to get the Stream Type Id of the RENT Stream Type.
669: OKL_ISG_UTILS_PVT.get_primary_stream_type(
670: p_khr_id => p_khr_id,
671: p_deal_type => p_deal_type,
672: p_primary_sty_purpose => 'RENT',
673: x_return_status => x_return_status,

Line 1094: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

1090: RAISE OKL_API.G_EXCEPTION_ERROR;
1091: END IF;
1092:
1093:
1094: OKL_ISG_UTILS_PVT.get_dependent_stream_type(
1095: p_khr_id => p_khr_id,
1096: p_deal_type => l_deal_type,
1097: p_dependent_sty_purpose => 'INTEREST_INCOME',
1098: x_return_status => x_return_status,

Line 1108: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

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

Line 1122: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

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

Line 1136: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

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

Line 1150: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

1146: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
1147: RAISE OKL_API.G_EXCEPTION_ERROR;
1148: END IF;
1149:
1150: OKL_ISG_UTILS_PVT.get_dependent_stream_type(
1151: p_khr_id => p_khr_id,
1152: p_deal_type => l_deal_type,
1153: p_dependent_sty_purpose => 'TERMINATION_VALUE',
1154: x_return_status => lx_return_status,

Line 1706: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

1702: l_primary_sty_id := r_rollover_pmnts.styId;
1703:
1704: IF p_deal_type = 'LEASEOP' THEN
1705: --l_sty_name := 'RENTAL ACCRUAL';
1706: OKL_ISG_UTILS_PVT.get_dependent_stream_type(
1707: p_khr_id => p_khr_id,
1708: p_deal_type => p_deal_type,
1709: p_primary_sty_id => l_primary_sty_id,
1710: p_dependent_sty_purpose => 'RENT_ACCRUAL',

Line 1722: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

1718: RAISE OKL_API.G_EXCEPTION_ERROR;
1719: END IF;
1720: ELSIF p_deal_type IN ('LEASEDF', 'LEASEST') THEN
1721: --l_sty_name := 'PRE-TAX INCOME';
1722: OKL_ISG_UTILS_PVT.get_dependent_stream_type(
1723: p_khr_id => p_khr_id,
1724: p_deal_type => p_deal_type,
1725: p_primary_sty_id => l_primary_sty_id,
1726: p_dependent_sty_purpose => 'LEASE_INCOME',

Line 1739: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

1735: END IF;
1736:
1737: ELSIF p_deal_type IN ('LOAN', 'LOAN-REVOLVING') THEN
1738: --l_sty_name := 'PRE-TAX INCOME';
1739: OKL_ISG_UTILS_PVT.get_dependent_stream_type(
1740: p_khr_id => p_khr_id,
1741: p_deal_type => p_deal_type,
1742: p_primary_sty_id => l_primary_sty_id,
1743: p_dependent_sty_purpose => 'INTEREST_INCOME',

Line 2076: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

2072: IF p_sty_purpose = 'RENT' AND p_deal_type = 'LEASEOP' AND
2073: (p_line_style = 'FREE_FORM1' OR p_line_style IS NULL) THEN
2074: --x_mapped_stream := 'RENTAL ACCRUAL';
2075: print( l_prog_name, '##1##' );
2076: OKL_ISG_UTILS_PVT.get_dependent_stream_type(
2077: p_khr_id => p_khr_id,
2078: p_deal_type => p_deal_type,
2079: p_primary_sty_id => l_primary_sty_id,
2080: p_dependent_sty_purpose => 'RENT_ACCRUAL',

Line 2096: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

2092: --If condition added by mansrini on 10-Jun-2005 for generating accrual streams for Service Lines
2093: --Bug 4434343 -Start of Changes
2094:
2095: IF (p_line_style = 'FEE') THEN
2096: OKL_ISG_UTILS_PVT.get_dependent_stream_type(
2097: p_khr_id => p_khr_id,
2098: p_deal_type => p_deal_type,
2099: p_primary_sty_id => l_primary_sty_id,
2100: p_dependent_sty_purpose => 'PASS_THRU_REV_ACCRUAL',

Line 2106: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

2102: x_dependent_sty_id => l_sty_id,
2103: x_dependent_sty_name => x_mapped_stream);
2104:
2105: ELSIF ((p_line_style = 'SOLD_SERVICE') OR (p_line_style = 'LINK_SERV_ASSET')) THEN
2106: OKL_ISG_UTILS_PVT.get_dependent_stream_type(
2107: p_khr_id => p_khr_id,
2108: p_deal_type => p_deal_type,
2109: p_primary_sty_id => l_primary_sty_id,
2110: p_dependent_sty_purpose => 'PASS_THRU_SVC_REV_ACCRUAL',

Line 2120: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

2116:
2117: ELSIF ((p_line_style = 'SOLD_SERVICE') OR (p_line_style = 'LINK_SERV_ASSET')) THEN
2118: print( l_prog_name, '##4##' );
2119: --x_mapped_stream := 'SERVICE INCOME';
2120: OKL_ISG_UTILS_PVT.get_dependent_stream_type(
2121: p_khr_id => p_khr_id,
2122: p_deal_type => p_deal_type,
2123: p_primary_sty_id => l_primary_sty_id,
2124: p_dependent_sty_purpose => 'SERVICE_INCOME',

Line 2134: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

2130: (p_sty_purpose <> 'SECURITY_DEPOSIT') THEN
2131:
2132: If ( p_fee_type = 'INCOME' AND p_recurr_yn = OKL_API.G_FALSE ) Then
2133: --x_mapped_stream := 'AMORTIZED FEE INCOME';
2134: OKL_ISG_UTILS_PVT.get_dependent_stream_type(
2135: p_khr_id => p_khr_id,
2136: p_deal_type => p_deal_type,
2137: p_primary_sty_id => l_primary_sty_id,
2138: p_dependent_sty_purpose => 'AMORTIZE_FEE_INCOME',

Line 2147: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

2143: elsif ( p_fee_type = 'FINANCED' OR p_fee_type = 'ROLLOVER') Then
2144: x_mapped_stream := NULL;
2145: else
2146: --x_mapped_stream := 'FEE INCOME';
2147: OKL_ISG_UTILS_PVT.get_dependent_stream_type(
2148: p_khr_id => p_khr_id,
2149: p_deal_type => p_deal_type,
2150: p_primary_sty_id => l_primary_sty_id,
2151: p_dependent_sty_purpose => 'ACCRUED_FEE_INCOME',

Line 2166: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

2162: ELSIF p_mapping_type = 'PRE-TAX INCOME' THEN
2163:
2164: IF (p_deal_type IN ('LEASEDF', 'LEASEST')) THEN
2165: --x_mapped_stream := 'PRE-TAX INCOME';
2166: OKL_ISG_UTILS_PVT.get_dependent_stream_type(
2167: p_khr_id => p_khr_id,
2168: p_deal_type => p_deal_type,
2169: p_primary_sty_id => l_primary_sty_id,
2170: p_dependent_sty_purpose => 'LEASE_INCOME',

Line 2177: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

2173: x_dependent_sty_name => x_mapped_stream);
2174:
2175: ElsIF (p_deal_type IN ('LOAN', 'LOAN-REVOLVING')) OR ( p_fee_type in ('FINANCED', 'ROLLOVER','LINK_FEE_ASSET') ) THEN
2176: --x_mapped_stream := 'PRE-TAX INCOME';
2177: OKL_ISG_UTILS_PVT.get_dependent_stream_type(
2178: p_khr_id => p_khr_id,
2179: p_deal_type => p_deal_type,
2180: p_primary_sty_id => l_primary_sty_id,
2181: p_dependent_sty_purpose => 'INTEREST_INCOME',

Line 2229: OKL_ISG_UTILS_PVT.get_primary_stream_type(

2225: CLOSE c_hdr;
2226: IF p_deal_type = 'LEASE' THEN
2227: If ( p_sty_purpose = 'RENT' ) THen
2228: --x_mapped_stream := 'INVESTOR RENT DISBURSEMENT BASIS';
2229: OKL_ISG_UTILS_PVT.get_primary_stream_type(
2230: p_khr_id => p_khr_id,
2231: p_pdt_id => r_hdr.pid,
2232: p_primary_sty_purpose => 'INVESTOR_RENT_DISB_BASIS',
2233: x_return_status => x_return_status,

Line 2239: OKL_ISG_UTILS_PVT.get_primary_stream_type(

2235: x_primary_sty_name => x_mapped_stream);
2236:
2237: ElsIf ( p_sty_purpose = 'RESIDUAL' ) Then
2238: --x_mapped_stream := 'INVESTOR RESIDUAL DISBURSEMENT BASIS';
2239: OKL_ISG_UTILS_PVT.get_primary_stream_type(
2240: p_khr_id => p_khr_id,
2241: p_pdt_id => r_hdr.pid,
2242: p_primary_sty_purpose => 'INVESTOR_RESIDUAL_DISB_BASIS',
2243: x_return_status => x_return_status,

Line 2250: OKL_ISG_UTILS_PVT.get_primary_stream_type(

2246: End If;
2247: ELSIF p_deal_type = 'LOAN' THEN
2248: If ( p_sty_purpose = 'LOAN_PAYMENT' ) Then
2249: IF p_stream_type_purpose = 'PRINCIPAL_PAYMENT' THEN
2250: OKL_ISG_UTILS_PVT.get_primary_stream_type(
2251: p_khr_id => p_khr_id,
2252: p_pdt_id => r_hdr.pid,
2253: p_primary_sty_purpose => 'INVESTOR_PRINCIPAL_DISB_BASIS',
2254: x_return_status => x_return_status,

Line 2258: OKL_ISG_UTILS_PVT.get_primary_stream_type(

2254: x_return_status => x_return_status,
2255: x_primary_sty_id => l_sty_id,
2256: x_primary_sty_name => x_mapped_stream);
2257: ELSIF p_stream_type_purpose = 'INTEREST_PAYMENT' THEN
2258: OKL_ISG_UTILS_PVT.get_primary_stream_type(
2259: p_khr_id => p_khr_id,
2260: p_pdt_id => r_hdr.pid,
2261: p_primary_sty_purpose => 'INVESTOR_INTEREST_DISB_BASIS',
2262: x_return_status => x_return_status,

Line 2266: OKL_ISG_UTILS_PVT.get_primary_stream_type(

2262: x_return_status => x_return_status,
2263: x_primary_sty_id => l_sty_id,
2264: x_primary_sty_name => x_mapped_stream);
2265: ELSIF p_stream_type_purpose = 'UNSCHEDULED_PRINCIPAL_PAYMENT' THEN
2266: OKL_ISG_UTILS_PVT.get_primary_stream_type(
2267: p_khr_id => p_khr_id,
2268: p_pdt_id => r_hdr.pid,
2269: p_primary_sty_purpose => 'INVESTOR_PPD_DISB_BASIS',
2270: x_return_status => x_return_status,

Line 2284: OKL_ISG_UTILS_PVT.get_primary_stream_type(

2280: FETCH c_hdr INTO r_hdr;
2281: CLOSE c_hdr;
2282: IF p_deal_type = 'LEASE' THEN
2283: If ( p_sty_purpose = 'RENT' ) THen
2284: OKL_ISG_UTILS_PVT.get_primary_stream_type(
2285: p_khr_id => p_khr_id,
2286: p_pdt_id => r_hdr.pid,
2287: p_primary_sty_purpose => 'PV_RENT_SECURITIZED',
2288: x_return_status => x_return_status,

Line 2293: OKL_ISG_UTILS_PVT.get_primary_stream_type(

2289: x_primary_sty_id => l_sty_id,
2290: x_primary_sty_name => x_mapped_stream);
2291:
2292: ElsIf ( p_sty_purpose = 'RESIDUAL' ) Then
2293: OKL_ISG_UTILS_PVT.get_primary_stream_type(
2294: p_khr_id => p_khr_id,
2295: p_pdt_id => r_hdr.pid,
2296: p_primary_sty_purpose => 'PV_RV_SECURITIZED',
2297: x_return_status => x_return_status,

Line 2304: OKL_ISG_UTILS_PVT.get_primary_stream_type(

2300: End If;
2301: ELSIF p_deal_type = 'LOAN' THEN
2302: If ( p_sty_purpose = 'LOAN_PAYMENT' ) Then
2303: IF p_stream_type_purpose = 'PRINCIPAL_PAYMENT' THEN
2304: OKL_ISG_UTILS_PVT.get_primary_stream_type(
2305: p_khr_id => p_khr_id,
2306: p_pdt_id => r_hdr.pid,
2307: p_primary_sty_purpose => 'PV_PRINCIPAL_SECURITIZED',
2308: x_return_status => x_return_status,

Line 2312: OKL_ISG_UTILS_PVT.get_primary_stream_type(

2308: x_return_status => x_return_status,
2309: x_primary_sty_id => l_sty_id,
2310: x_primary_sty_name => x_mapped_stream);
2311: ELSIF p_stream_type_purpose = 'INTEREST_PAYMENT' THEN
2312: OKL_ISG_UTILS_PVT.get_primary_stream_type(
2313: p_khr_id => p_khr_id,
2314: p_pdt_id => r_hdr.pid,
2315: p_primary_sty_purpose => 'PV_INTEREST_SECURITIZED',
2316: x_return_status => x_return_status,

Line 2320: OKL_ISG_UTILS_PVT.get_primary_stream_type(

2316: x_return_status => x_return_status,
2317: x_primary_sty_id => l_sty_id,
2318: x_primary_sty_name => x_mapped_stream);
2319: ELSIF p_stream_type_purpose = 'UNSCHEDULED_PRINCIPAL_PAYMENT' THEN
2320: OKL_ISG_UTILS_PVT.get_primary_stream_type(
2321: p_khr_id => p_khr_id,
2322: p_pdt_id => r_hdr.pid,
2323: p_primary_sty_purpose => 'PV_UNSCHEDULED_PMT_SECURITIZED',
2324: x_return_status => x_return_status,

Line 2725: OKL_ISG_UTILS_PVT.get_arrears_pay_dates_option(

2721:
2722:
2723: -- djanaswa ER6274342 start
2724: IF p_advance_or_arrears = 'ARREARS' THEN
2725: OKL_ISG_UTILS_PVT.get_arrears_pay_dates_option(
2726: p_khr_id => p_khr_id,
2727: x_arrears_pay_dates_option => l_arrears_pay_dates_option,
2728: x_return_status => lx_return_status);
2729:

Line 2910: OKL_ISG_UTILS_PVT.get_arrears_pay_dates_option(

2906: END IF;
2907:
2908: -- djanaswa ER6274342 start
2909: IF p_advance_or_arrears = 'ARREARS' THEN
2910: OKL_ISG_UTILS_PVT.get_arrears_pay_dates_option(
2911: p_khr_id => p_khr_id,
2912: x_arrears_pay_dates_option => l_arrears_pay_dates_option,
2913: x_return_status => lx_return_status);
2914:

Line 4188: OKL_ISG_UTILS_PVT.get_primary_stream_type(

4184: l_deal_type := l_hdr.deal_type;
4185: l_purpose_code := '-99';
4186: END IF;
4187:
4188: OKL_ISG_UTILS_PVT.get_primary_stream_type(
4189: p_khr_id => p_khr_id,
4190: p_deal_type => l_deal_type,
4191: p_primary_sty_purpose => 'RESIDUAL_VALUE',
4192: x_return_status => lx_return_status,

Line 4204: OKL_ISG_UTILS_PVT.get_arrears_pay_dates_option(

4200: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
4201: RAISE OKL_API.G_EXCEPTION_ERROR;
4202: END IF;
4203:
4204: OKL_ISG_UTILS_PVT.get_arrears_pay_dates_option(
4205: p_khr_id => p_khr_id,
4206: x_arrears_pay_dates_option => l_arrears_pay_dates_option,
4207: x_return_status => lx_return_status);
4208:

Line 4310: OKL_ISG_UTILS_PVT.get_primary_stream_type(

4306: IF ( l_line_rec.capitalize_down_payment_yn = 'Y' AND
4307: ( nvl(l_line_rec.capital_reduction, l_line_rec.capital_reduction_percent) > 0 ) ) AND
4308: (p_generation_type = 'FULL' OR p_generation_type = 'CAPITAL REDUCTION')
4309: THEN
4310: OKL_ISG_UTILS_PVT.get_primary_stream_type(
4311: p_khr_id => p_khr_id,
4312: p_deal_type => l_deal_type,
4313: p_primary_sty_purpose => 'CAPITAL_REDUCTION',
4314: x_return_status => lx_return_status,

Line 4537: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

4533:
4534: */
4535:
4536: -- bug# 4041666
4537: OKL_ISG_UTILS_PVT.get_dependent_stream_type(
4538: p_khr_id => p_khr_id,
4539: p_deal_type => l_deal_type,
4540: p_primary_sty_id => l_asbv_tbl(i).stream_type_id,
4541: p_dependent_sty_purpose => 'SUBSIDY_INCOME',

Line 4621: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

4617:
4618:
4619: l_primary_sty_id := r_rollover_pmnts.styId;
4620:
4621: OKL_ISG_UTILS_PVT.get_dependent_stream_type(
4622: p_khr_id => p_khr_id,
4623: p_deal_type => l_deal_type,
4624: p_primary_sty_id => l_primary_sty_id,
4625: p_dependent_sty_purpose => 'PV_RENT',

Line 5089: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

5085: IF l_pt_tbl.COUNT > 0
5086: THEN
5087: IF l_passthrough_id IS NULL
5088: THEN
5089: OKL_ISG_UTILS_PVT.get_dependent_stream_type(
5090: p_khr_id => p_khr_id,
5091: p_deal_type => l_deal_type,
5092: p_dependent_sty_purpose => 'PASS_THRU_EXP_ACCRUAL',
5093: x_return_status => lx_return_status,

Line 5599: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

5595: IF l_pt_tbl.COUNT > 0 THEN
5596: --Added by mansrini on 30-Jun-2005 for generating pass through accrual streams for service lines
5597: --Bug 4434343 - Start of Changes
5598: IF (l_inflow.lty_code = 'FEE') OR (l_inflow.lty_code = 'LINK_FEE_ASSET') THEN
5599: OKL_ISG_UTILS_PVT.get_dependent_stream_type(
5600: p_khr_id => p_khr_id,
5601: p_deal_type => l_deal_type,
5602: p_primary_sty_id => l_inflow.sty_id,
5603: p_dependent_sty_purpose => 'PASS_THRU_EXP_ACCRUAL',

Line 5613: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

5609: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
5610: RAISE OKL_API.G_EXCEPTION_ERROR;
5611: END IF;
5612: ELSIF (l_inflow.lty_code = 'SOLD_SERVICE') OR (l_inflow.lty_code = 'LINK_SERV_ASSET') THEN
5613: OKL_ISG_UTILS_PVT.get_dependent_stream_type(
5614: p_khr_id => p_khr_id,
5615: p_deal_type => l_deal_type,
5616: p_primary_sty_id => l_inflow.sty_id,
5617: p_dependent_sty_purpose => 'PASS_THRU_SVC_EXP_ACCRUAL',

Line 5732: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

5728: CLOSE fee_strm_type_csr;
5729:
5730: End If;
5731:
5732: OKL_ISG_UTILS_PVT.get_dependent_stream_type(
5733: p_khr_id => p_khr_id,
5734: p_deal_type => l_deal_type,
5735: p_primary_sty_id => fee_strm_type_rec.styp_id,
5736: p_dependent_sty_purpose => 'PASS_THRU_PRO_FEE_ACCRUAL',

Line 5948: p_get_k_info_csr OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR%ROWTYPE;

5944: lx_selv_tbl Okl_Streams_Pub.selv_tbl_type;
5945: lx_stmv_tbl Okl_Streams_Pub.stmv_tbl_type;
5946: lx_full_selv_tbl Okl_Streams_Pub.selv_tbl_type;
5947: l_dep_sty_id NUMBER;
5948: p_get_k_info_csr OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR%ROWTYPE;
5949: l_mapped_sty_name VARCHAR2(150);
5950: l_days NUMBER;
5951: i BINARY_INTEGER := 0;
5952: l_start_day NUMBER;

Line 5970: OPEN OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR (p_khr_id);

5966: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
5967: RAISE OKL_API.G_EXCEPTION_ERROR;
5968: END IF;
5969:
5970: OPEN OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR (p_khr_id);
5971: FETCH OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR INTO p_get_k_info_csr;
5972: CLOSE OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR;
5973:
5974: FOR l_asset_rec IN c_assets LOOP

Line 5971: FETCH OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR INTO p_get_k_info_csr;

5967: RAISE OKL_API.G_EXCEPTION_ERROR;
5968: END IF;
5969:
5970: OPEN OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR (p_khr_id);
5971: FETCH OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR INTO p_get_k_info_csr;
5972: CLOSE OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR;
5973:
5974: FOR l_asset_rec IN c_assets LOOP
5975: l_sum_of_rents := 0;

Line 5972: CLOSE OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR;

5968: END IF;
5969:
5970: OPEN OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR (p_khr_id);
5971: FETCH OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR INTO p_get_k_info_csr;
5972: CLOSE OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR;
5973:
5974: FOR l_asset_rec IN c_assets LOOP
5975: l_sum_of_rents := 0;
5976: FOR l_inflow IN c_inflows(l_asset_rec.cle_id) LOOP

Line 5979: OKL_ISG_UTILS_PVT.get_dep_stream_type(

5975: l_sum_of_rents := 0;
5976: FOR l_inflow IN c_inflows(l_asset_rec.cle_id) LOOP
5977:
5978: IF(l_mapped_sty_name IS NULL) THEN
5979: OKL_ISG_UTILS_PVT.get_dep_stream_type(
5980: p_khr_id => p_khr_id,
5981: p_deal_type => 'LEASEOP',
5982: p_primary_sty_id => l_inflow.sty_id,
5983: p_dependent_sty_purpose => 'RENT_ACCRUAL',

Line 7280: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

7276: -- based on the Lease Contract Book Classification
7277: print(l_prog_name, 'Identifying the Dependent Income Stream Type Name' );
7278: IF p_deal_type = 'LEASEOP'
7279: THEN
7280: OKL_ISG_UTILS_PVT.get_dependent_stream_type(
7281: p_khr_id => p_khr_id,
7282: p_deal_type => p_deal_type,
7283: p_primary_sty_id => l_pri_rent_sty_id,
7284: p_dependent_sty_purpose => 'RENT_ACCRUAL',

Line 7296: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

7292: RAISE OKL_API.G_EXCEPTION_ERROR;
7293: END IF;
7294: ELSIF p_deal_type IN ('LEASEDF', 'LEASEST')
7295: THEN
7296: OKL_ISG_UTILS_PVT.get_dependent_stream_type(
7297: p_khr_id => p_khr_id,
7298: p_deal_type => p_deal_type,
7299: p_primary_sty_id => l_pri_rent_sty_id,
7300: p_dependent_sty_purpose => 'LEASE_INCOME',

Line 7312: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

7308: RAISE OKL_API.G_EXCEPTION_ERROR;
7309: END IF;
7310: ELSIF p_deal_type IN ('LOAN', 'LOAN-REVOLVING')
7311: THEN
7312: OKL_ISG_UTILS_PVT.get_dependent_stream_type(
7313: p_khr_id => p_khr_id,
7314: p_deal_type => p_deal_type,
7315: p_primary_sty_id => l_pri_rent_sty_id,
7316: p_dependent_sty_purpose => 'INTEREST_INCOME',

Line 8391: p_get_k_info_csr OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR%ROWTYPE;

8387:
8388: -- Assuming that there are no Services initially.
8389: exec_svc_csr VARCHAR2(1) := 'F';
8390: l_tmp_cle_id NUMBER;
8391: p_get_k_info_csr OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR%ROWTYPE;
8392:
8393: l_initial_irr NUMBER := 0;
8394: l_asset_count NUMBER := 0;
8395:

Line 8506: OPEN OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR (p_khr_id);

8502: OPEN G_ROLLOVER_PMNTS(p_khr_id);
8503: FETCH G_ROLLOVER_PMNTS INTO r_rollover_pmnts;
8504: CLOSE G_ROLLOVER_PMNTS;
8505:
8506: OPEN OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR (p_khr_id);
8507: FETCH OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR INTO p_get_k_info_csr;
8508: CLOSE OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR;
8509:
8510: -- Added by RGOOTY : End

Line 8507: FETCH OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR INTO p_get_k_info_csr;

8503: FETCH G_ROLLOVER_PMNTS INTO r_rollover_pmnts;
8504: CLOSE G_ROLLOVER_PMNTS;
8505:
8506: OPEN OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR (p_khr_id);
8507: FETCH OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR INTO p_get_k_info_csr;
8508: CLOSE OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR;
8509:
8510: -- Added by RGOOTY : End
8511: OPEN c_hdr;

Line 8508: CLOSE OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR;

8504: CLOSE G_ROLLOVER_PMNTS;
8505:
8506: OPEN OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR (p_khr_id);
8507: FETCH OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR INTO p_get_k_info_csr;
8508: CLOSE OKL_ISG_UTILS_PVT.G_GET_K_INFO_CSR;
8509:
8510: -- Added by RGOOTY : End
8511: OPEN c_hdr;
8512: FETCH c_hdr INTO l_hdr;

Line 8525: OKL_ISG_UTILS_PVT.validate_strm_gen_template(

8521: END IF;
8522:
8523: l_asset_guess_iir := l_hdr.base_rate / 100.0;
8524:
8525: OKL_ISG_UTILS_PVT.validate_strm_gen_template(
8526: p_api_version => p_api_version,
8527: p_init_msg_list => p_init_msg_list,
8528: x_return_status => x_return_status,
8529: x_msg_count => x_msg_count,

Line 8764: OKL_ISG_UTILS_PVT.get_dep_stream_type(

8760: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
8761: RAISE OKL_API.G_EXCEPTION_ERROR;
8762: END IF;
8763:
8764: OKL_ISG_UTILS_PVT.get_dep_stream_type(
8765: p_khr_id => p_khr_id,
8766: p_deal_type => l_deal_type,
8767: p_primary_sty_id => l_primary_sty_id,
8768: p_dependent_sty_purpose => 'INTEREST_PAYMENT',

Line 8782: OKL_ISG_UTILS_PVT.get_dep_stream_type(

8778: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
8779: RAISE OKL_API.G_EXCEPTION_ERROR;
8780: END IF;
8781:
8782: OKL_ISG_UTILS_PVT.get_dep_stream_type(
8783: p_khr_id => p_khr_id,
8784: p_deal_type => l_deal_type,
8785: p_primary_sty_id => l_primary_sty_id,
8786: p_dependent_sty_purpose => 'PRINCIPAL_PAYMENT',

Line 8801: OKL_ISG_UTILS_PVT.get_dep_stream_type(

8797: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
8798: RAISE OKL_API.G_EXCEPTION_ERROR;
8799: END IF;
8800:
8801: OKL_ISG_UTILS_PVT.get_dep_stream_type(
8802: p_khr_id => p_khr_id,
8803: p_deal_type => l_deal_type,
8804: p_primary_sty_id => l_primary_sty_id,
8805: p_dependent_sty_purpose => 'PRINCIPAL_BALANCE',

Line 8819: OKL_ISG_UTILS_PVT.get_dep_stream_type(

8815: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
8816: RAISE OKL_API.G_EXCEPTION_ERROR;
8817: END IF;
8818:
8819: OKL_ISG_UTILS_PVT.get_dep_stream_type(
8820: p_khr_id => p_khr_id,
8821: p_deal_type => l_deal_type,
8822: p_primary_sty_id => l_primary_sty_id,
8823: p_dependent_sty_purpose => 'TERMINATION_VALUE',

Line 9996: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

9992: fetch get_rent_sty_id into l_rent_sty_id;
9993: close get_rent_sty_id;
9994: -- bug 13013062: fetch the rent stream type id .. end
9995:
9996: OKL_ISG_UTILS_PVT.get_dependent_stream_type(
9997: p_khr_id => p_khr_id,
9998: p_deal_type => l_deal_type,
9999: p_primary_sty_id => l_rent_sty_id,
10000: p_dependent_sty_purpose => 'LOAN_PAYMENT',

Line 10042: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

10038:
10039:
10040: If ( l_rent_sty_id is NOT NULL ) Then
10041:
10042: OKL_ISG_UTILS_PVT.get_dependent_stream_type(
10043: p_khr_id => p_khr_id,
10044: p_deal_type => l_deal_type,
10045: p_primary_sty_id => l_rent_sty_id,
10046: p_dependent_sty_purpose => 'LOAN_PAYMENT',

Line 13560: OKL_ISG_UTILS_PVT.get_primary_stream_type(

13556: FETCH fee_strm_type_csr INTO l_sty_id;
13557: CLOSE fee_strm_type_csr;
13558:
13559: Else
13560: OKL_ISG_UTILS_PVT.get_primary_stream_type(
13561: p_khr_id => p_khr_id,
13562: p_deal_type => l_deal_type,
13563: p_primary_sty_purpose => 'RENT',
13564: x_return_status => x_return_status,

Line 14412: OKL_ISG_UTILS_PVT.get_dependent_stream_type(

14408: FETCH c_hdr INTO l_pdt_id, l_currency_code;
14409: CLOSE c_hdr;
14410: */
14411:
14412: OKL_ISG_UTILS_PVT.get_dependent_stream_type(
14413: p_khr_id => p_khr_id,
14414: p_pdt_id => l_pdt_tbl(i), -- R12.1.2
14415: p_dependent_sty_purpose => 'ACCRUED_FEE_INCOME',
14416: x_return_status => x_return_status,