375: IS
376: BEGIN
377: -- special cases
378: IF p_stream_type_name = 'AMORTIZED FEE INCOME' AND
379: p_sfe_type = OKL_SFE_PVT.G_SFE_TYPE_ONE_OFF THEN
380: x_stream_type_name := 'Single Fee Accrual';
381: ELSIF p_stream_type_name = 'FEE INCOME' AND
382: p_sfe_type = 'SFI' THEN
383: x_stream_type_name := 'Single Periodic Income Accrual';
381: ELSIF p_stream_type_name = 'FEE INCOME' AND
382: p_sfe_type = 'SFI' THEN
383: x_stream_type_name := 'Single Periodic Income Accrual';
384: -- end special cases
385: ELSIF p_sfe_type = OKL_SFE_PVT.G_SFE_TYPE_ONE_OFF
386: OR p_stream_type_name = 'RATE PARTICIPATION'
387: OR p_stream_type_name = 'RESIDUAL VALUE INSURANCE PREMIUM' THEN
388: x_stream_type_name := 'Fee';
389:
387: OR p_stream_type_name = 'RESIDUAL VALUE INSURANCE PREMIUM' THEN
388: x_stream_type_name := 'Fee';
389:
390: -- removed since no periodic expense stream is generated
391: --ELSIF p_sfe_type = OKL_SFE_PVT.G_SFE_TYPE_PERIODIC_EXPENSE THEN
392: --x_stream_type_name := 'Periodic Expenses';
393: ELSIF p_sfe_type = OKL_SFE_PVT.G_SFE_TYPE_PERIODIC_INCOME THEN
394: x_stream_type_name := 'Periodic Income';
395: ELSIF p_sfe_type = OKL_SFE_PVT.G_SFE_TYPE_SUBSIDY THEN
389:
390: -- removed since no periodic expense stream is generated
391: --ELSIF p_sfe_type = OKL_SFE_PVT.G_SFE_TYPE_PERIODIC_EXPENSE THEN
392: --x_stream_type_name := 'Periodic Expenses';
393: ELSIF p_sfe_type = OKL_SFE_PVT.G_SFE_TYPE_PERIODIC_INCOME THEN
394: x_stream_type_name := 'Periodic Income';
395: ELSIF p_sfe_type = OKL_SFE_PVT.G_SFE_TYPE_SUBSIDY THEN
396: x_stream_type_name := 'Single Subsidy Accrual';
397: ELSIF p_sfe_type = OKL_SFE_PVT.G_SFE_TYPE_RENT THEN
391: --ELSIF p_sfe_type = OKL_SFE_PVT.G_SFE_TYPE_PERIODIC_EXPENSE THEN
392: --x_stream_type_name := 'Periodic Expenses';
393: ELSIF p_sfe_type = OKL_SFE_PVT.G_SFE_TYPE_PERIODIC_INCOME THEN
394: x_stream_type_name := 'Periodic Income';
395: ELSIF p_sfe_type = OKL_SFE_PVT.G_SFE_TYPE_SUBSIDY THEN
396: x_stream_type_name := 'Single Subsidy Accrual';
397: ELSIF p_sfe_type = OKL_SFE_PVT.G_SFE_TYPE_RENT THEN
398: x_stream_type_name := 'Rent';
399: ELSIF p_stream_type_name = 'RENT' THEN
393: ELSIF p_sfe_type = OKL_SFE_PVT.G_SFE_TYPE_PERIODIC_INCOME THEN
394: x_stream_type_name := 'Periodic Income';
395: ELSIF p_sfe_type = OKL_SFE_PVT.G_SFE_TYPE_SUBSIDY THEN
396: x_stream_type_name := 'Single Subsidy Accrual';
397: ELSIF p_sfe_type = OKL_SFE_PVT.G_SFE_TYPE_RENT THEN
398: x_stream_type_name := 'Rent';
399: ELSIF p_stream_type_name = 'RENT' THEN
400: x_stream_type_name := 'Rent';
401:
470: IS
471: BEGIN
472: -- special cases
473: IF p_stream_type_name = 'AMORTIZED FEE INCOME' AND
474: p_sfe_type = OKL_SFE_PVT.G_SFE_TYPE_ONE_OFF THEN
475: x_stream_type_name := 'Single Fee Accrual';
476: ELSIF p_stream_type_name = 'FEE INCOME' AND
477: p_sfe_type = OKL_SFE_PVT.G_SFE_TYPE_PERIODIC_INCOME THEN
478: x_stream_type_name := 'Single Periodic Income Accrual';
473: IF p_stream_type_name = 'AMORTIZED FEE INCOME' AND
474: p_sfe_type = OKL_SFE_PVT.G_SFE_TYPE_ONE_OFF THEN
475: x_stream_type_name := 'Single Fee Accrual';
476: ELSIF p_stream_type_name = 'FEE INCOME' AND
477: p_sfe_type = OKL_SFE_PVT.G_SFE_TYPE_PERIODIC_INCOME THEN
478: x_stream_type_name := 'Single Periodic Income Accrual';
479: ELSIF p_stream_type_name = 'PRE-TAX INCOME' AND
480: p_sil_type = OKL_SIL_PVT.G_SIL_TYPE_LEASE THEN
481: x_stream_type_name := 'Single Rent Accrual';
481: x_stream_type_name := 'Single Rent Accrual';
482: ELSIF p_stream_type_name = 'PRE-TAX INCOME' THEN
483: x_stream_type_name := 'Single Lending Loan Accrual';
484: -- end special cases
485: ELSIF p_sfe_type = OKL_SFE_PVT.G_SFE_TYPE_ONE_OFF
486: OR p_stream_type_name = 'RATE PARTICIPATION'
487: OR p_stream_type_name = 'RESIDUAL VALUE INSURANCE PREMIUM' THEN
488: x_stream_type_name := 'Fee';
489:
487: OR p_stream_type_name = 'RESIDUAL VALUE INSURANCE PREMIUM' THEN
488: x_stream_type_name := 'Fee';
489:
490: -- removed since no periodic expense stream is generated
491: --ELSIF p_sfe_type = OKL_SFE_PVT.G_SFE_TYPE_PERIODIC_EXPENSE THEN
492: --x_stream_type_name := 'Periodic Expenses';
493: ELSIF p_sfe_type = OKL_SFE_PVT.G_SFE_TYPE_PERIODIC_INCOME THEN
494: x_stream_type_name := 'Periodic Income';
495: ELSIF p_sfe_type = OKL_SFE_PVT.G_SFE_TYPE_SUBSIDY THEN
489:
490: -- removed since no periodic expense stream is generated
491: --ELSIF p_sfe_type = OKL_SFE_PVT.G_SFE_TYPE_PERIODIC_EXPENSE THEN
492: --x_stream_type_name := 'Periodic Expenses';
493: ELSIF p_sfe_type = OKL_SFE_PVT.G_SFE_TYPE_PERIODIC_INCOME THEN
494: x_stream_type_name := 'Periodic Income';
495: ELSIF p_sfe_type = OKL_SFE_PVT.G_SFE_TYPE_SUBSIDY THEN
496: x_stream_type_name := 'Single Subsidy Accrual';
497: ELSIF p_sfe_type = OKL_SFE_PVT.G_SFE_TYPE_RENT THEN
491: --ELSIF p_sfe_type = OKL_SFE_PVT.G_SFE_TYPE_PERIODIC_EXPENSE THEN
492: --x_stream_type_name := 'Periodic Expenses';
493: ELSIF p_sfe_type = OKL_SFE_PVT.G_SFE_TYPE_PERIODIC_INCOME THEN
494: x_stream_type_name := 'Periodic Income';
495: ELSIF p_sfe_type = OKL_SFE_PVT.G_SFE_TYPE_SUBSIDY THEN
496: x_stream_type_name := 'Single Subsidy Accrual';
497: ELSIF p_sfe_type = OKL_SFE_PVT.G_SFE_TYPE_RENT THEN
498: x_stream_type_name := 'Rent';
499: ELSIF p_stream_type_name = 'RENT' THEN
493: ELSIF p_sfe_type = OKL_SFE_PVT.G_SFE_TYPE_PERIODIC_INCOME THEN
494: x_stream_type_name := 'Periodic Income';
495: ELSIF p_sfe_type = OKL_SFE_PVT.G_SFE_TYPE_SUBSIDY THEN
496: x_stream_type_name := 'Single Subsidy Accrual';
497: ELSIF p_sfe_type = OKL_SFE_PVT.G_SFE_TYPE_RENT THEN
498: x_stream_type_name := 'Rent';
499: ELSIF p_stream_type_name = 'RENT' THEN
500: x_stream_type_name := 'Rent';
501: