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_KLE_PVT dependencies on OKL_API

Line 299: x_return_status := OKL_API.G_RET_STS_SUCCESS;

295: l_desc_flex_name VARCHAR2(30) := 'OKL_K_LINES_DF';
296: l_segment_partial_name VARCHAR2(30) := 'ATTRIBUTE';
297: Begin
298: -- initialize return status
299: x_return_status := OKL_API.G_RET_STS_SUCCESS;
300:
301: l_segment_values_rec.attribute_category := p_klev_rec.attribute_category;
302: l_segment_values_rec.attribute1 := p_klev_rec.attribute1;
303: l_segment_values_rec.attribute2 := p_klev_rec.attribute2;

Line 320: ,p_init_msg_list => OKL_API.G_FALSE

316: l_segment_values_rec.attribute15 := p_klev_rec.attribute15;
317:
318: okl_dflex_util_pvt.validate_desc_flex
319: (p_api_version => 1.0
320: ,p_init_msg_list => OKL_API.G_FALSE
321: ,x_return_status => x_return_status
322: ,x_msg_count => l_msg_count
323: ,x_msg_data => l_msg_data
324: ,p_appl_short_name => l_appl_short_name

Line 330: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

326: ,p_segment_partial_name => l_segment_partial_name
327: ,p_segment_values_rec => l_segment_values_rec);
328:
329: -- check return status
330: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
331: RAISE G_EXCEPTION_HALT_VALIDATION;
332: END IF;
333:
334: exception

Line 336: x_return_status := OKL_API.G_RET_STS_ERROR;

332: END IF;
333:
334: exception
335: when G_EXCEPTION_HALT_VALIDATION THEN
336: x_return_status := OKL_API.G_RET_STS_ERROR;
337:
338: when OTHERS then
339: -- store SQL error message on message stack
340: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

Line 340: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

336: x_return_status := OKL_API.G_RET_STS_ERROR;
337:
338: when OTHERS then
339: -- store SQL error message on message stack
340: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
341: p_msg_name => g_unexpected_error,
342: p_token1 => g_sqlcode_token,
343: p_token1_value => sqlcode,
344: p_token2 => g_sqlerrm_token,

Line 347: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

343: p_token1_value => sqlcode,
344: p_token2 => g_sqlerrm_token,
345: p_token2_value => sqlerrm);
346: -- notify caller of an error as UNEXPETED error
347: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
348: End validate_DFF_attributes;
349: --Bug# 4558486: end
350:
351: -- ************************ END OF HAND CODED VALIDATION *********************************

Line 493: x_return_status := OKL_API.G_RET_STS_SUCCESS;

489: where subb.id = p_subsidy_id;
490:
491: l_exists varchar2(1) default 'N';
492: BEGIN
493: x_return_status := OKL_API.G_RET_STS_SUCCESS;
494: IF (p_klev_rec.subsidy_id = OKL_API.G_MISS_NUM OR
495: p_klev_rec.subsidy_id IS NULL)
496: THEN
497: null; --null values are allowed

Line 494: IF (p_klev_rec.subsidy_id = OKL_API.G_MISS_NUM OR

490:
491: l_exists varchar2(1) default 'N';
492: BEGIN
493: x_return_status := OKL_API.G_RET_STS_SUCCESS;
494: IF (p_klev_rec.subsidy_id = OKL_API.G_MISS_NUM OR
495: p_klev_rec.subsidy_id IS NULL)
496: THEN
497: null; --null values are allowed
498: ELSE

Line 508: OKL_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'Subsidy Name');

504: null;
505: End If;
506: Close l_sub_csr;
507: If l_exists = 'N' then
508: OKL_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'Subsidy Name');
509: x_return_status := OKL_API.G_RET_STS_ERROR;
510: RAISE G_EXCEPTION_HALT_VALIDATION;
511: End If;
512: END IF;

Line 509: x_return_status := OKL_API.G_RET_STS_ERROR;

505: End If;
506: Close l_sub_csr;
507: If l_exists = 'N' then
508: OKL_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'Subsidy Name');
509: x_return_status := OKL_API.G_RET_STS_ERROR;
510: RAISE G_EXCEPTION_HALT_VALIDATION;
511: End If;
512: END IF;
513: EXCEPTION

Line 517: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

513: EXCEPTION
514: WHEN G_EXCEPTION_HALT_VALIDATION THEN
515: null;
516: WHEN OTHERS THEN
517: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
518: ,p_msg_name => G_UNEXPECTED_ERROR
519: ,p_token1 => G_SQLCODE_TOKEN
520: ,p_token1_value => SQLCODE
521: ,p_token2 => G_SQLERRM_TOKEN

Line 523: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

519: ,p_token1 => G_SQLCODE_TOKEN
520: ,p_token1_value => SQLCODE
521: ,p_token2 => G_SQLERRM_TOKEN
522: ,p_token2_value => SQLERRM);
523: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
524: end validate_subsidy_id;
525: ---------------------------------------------
526: -- Validate_Attributes for: OKL_K_LINES_V --
527: ---------------------------------------------

Line 658: if ( NVL(p_klev_rec.validate_dff_yn,OKL_API.G_MISS_CHAR) = 'Y') then

654: --Bug# 4558486
655: -- ***
656: -- DFF Attributes
657: -- ***
658: if ( NVL(p_klev_rec.validate_dff_yn,OKL_API.G_MISS_CHAR) = 'Y') then
659: validate_DFF_attributes
660: (x_return_status => l_return_status,
661: p_klev_rec => p_klev_rec);
662:

Line 2078: IF (l_klev_rec.SUBSIDY_ID = OKL_API.G_MISS_NUM) THEN

2074: l_klev_rec.FEE_TYPE := NULL;
2075: END IF;
2076: --Bug# 3143522: 11.5.10
2077: --subsidy
2078: IF (l_klev_rec.SUBSIDY_ID = OKL_API.G_MISS_NUM) THEN
2079: l_klev_rec.SUBSIDY_ID := NULL;
2080: END IF;
2081: --IF (l_klev_rec.SUBSIDIZED_OEC = OKL_API.G_MISS_NUM) THEN
2082: --l_klev_rec.SUBSIDIZED_OEC := NULL;

Line 2081: --IF (l_klev_rec.SUBSIDIZED_OEC = OKL_API.G_MISS_NUM) THEN

2077: --subsidy
2078: IF (l_klev_rec.SUBSIDY_ID = OKL_API.G_MISS_NUM) THEN
2079: l_klev_rec.SUBSIDY_ID := NULL;
2080: END IF;
2081: --IF (l_klev_rec.SUBSIDIZED_OEC = OKL_API.G_MISS_NUM) THEN
2082: --l_klev_rec.SUBSIDIZED_OEC := NULL;
2083: --END IF;
2084: --IF (l_klev_rec.SUBSIDIZED_CAP_AMOUNT = OKL_API.G_MISS_NUM) THEN
2085: --l_klev_rec.SUBSIDIZED_CAP_AMOUNT := NULL;

Line 2084: --IF (l_klev_rec.SUBSIDIZED_CAP_AMOUNT = OKL_API.G_MISS_NUM) THEN

2080: END IF;
2081: --IF (l_klev_rec.SUBSIDIZED_OEC = OKL_API.G_MISS_NUM) THEN
2082: --l_klev_rec.SUBSIDIZED_OEC := NULL;
2083: --END IF;
2084: --IF (l_klev_rec.SUBSIDIZED_CAP_AMOUNT = OKL_API.G_MISS_NUM) THEN
2085: --l_klev_rec.SUBSIDIZED_CAP_AMOUNT := NULL;
2086: --END IF;
2087: IF (l_klev_rec.SUBSIDY_OVERRIDE_AMOUNT = OKL_API.G_MISS_NUM) THEN
2088: l_klev_rec.SUBSIDY_OVERRIDE_AMOUNT := NULL;

Line 2087: IF (l_klev_rec.SUBSIDY_OVERRIDE_AMOUNT = OKL_API.G_MISS_NUM) THEN

2083: --END IF;
2084: --IF (l_klev_rec.SUBSIDIZED_CAP_AMOUNT = OKL_API.G_MISS_NUM) THEN
2085: --l_klev_rec.SUBSIDIZED_CAP_AMOUNT := NULL;
2086: --END IF;
2087: IF (l_klev_rec.SUBSIDY_OVERRIDE_AMOUNT = OKL_API.G_MISS_NUM) THEN
2088: l_klev_rec.SUBSIDY_OVERRIDE_AMOUNT := NULL;
2089: END IF;
2090: --financed fee
2091: IF (l_klev_rec.PRE_TAX_YIELD = OKL_API.G_MISS_NUM) THEN

Line 2091: IF (l_klev_rec.PRE_TAX_YIELD = OKL_API.G_MISS_NUM) THEN

2087: IF (l_klev_rec.SUBSIDY_OVERRIDE_AMOUNT = OKL_API.G_MISS_NUM) THEN
2088: l_klev_rec.SUBSIDY_OVERRIDE_AMOUNT := NULL;
2089: END IF;
2090: --financed fee
2091: IF (l_klev_rec.PRE_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
2092: l_klev_rec.PRE_TAX_YIELD := NULL;
2093: END IF;
2094: IF (l_klev_rec.AFTER_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
2095: l_klev_rec.AFTER_TAX_YIELD := NULL;

Line 2094: IF (l_klev_rec.AFTER_TAX_YIELD = OKL_API.G_MISS_NUM) THEN

2090: --financed fee
2091: IF (l_klev_rec.PRE_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
2092: l_klev_rec.PRE_TAX_YIELD := NULL;
2093: END IF;
2094: IF (l_klev_rec.AFTER_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
2095: l_klev_rec.AFTER_TAX_YIELD := NULL;
2096: END IF;
2097: IF (l_klev_rec.IMPLICIT_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
2098: l_klev_rec.IMPLICIT_INTEREST_RATE := NULL;

Line 2097: IF (l_klev_rec.IMPLICIT_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN

2093: END IF;
2094: IF (l_klev_rec.AFTER_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
2095: l_klev_rec.AFTER_TAX_YIELD := NULL;
2096: END IF;
2097: IF (l_klev_rec.IMPLICIT_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
2098: l_klev_rec.IMPLICIT_INTEREST_RATE := NULL;
2099: END IF;
2100: IF (l_klev_rec.IMPLICIT_NON_IDC_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
2101: l_klev_rec.IMPLICIT_NON_IDC_INTEREST_RATE := NULL;

Line 2100: IF (l_klev_rec.IMPLICIT_NON_IDC_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN

2096: END IF;
2097: IF (l_klev_rec.IMPLICIT_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
2098: l_klev_rec.IMPLICIT_INTEREST_RATE := NULL;
2099: END IF;
2100: IF (l_klev_rec.IMPLICIT_NON_IDC_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
2101: l_klev_rec.IMPLICIT_NON_IDC_INTEREST_RATE := NULL;
2102: END IF;
2103: IF (l_klev_rec.PRE_TAX_IRR = OKL_API.G_MISS_NUM) THEN
2104: l_klev_rec.PRE_TAX_IRR := NULL;

Line 2103: IF (l_klev_rec.PRE_TAX_IRR = OKL_API.G_MISS_NUM) THEN

2099: END IF;
2100: IF (l_klev_rec.IMPLICIT_NON_IDC_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
2101: l_klev_rec.IMPLICIT_NON_IDC_INTEREST_RATE := NULL;
2102: END IF;
2103: IF (l_klev_rec.PRE_TAX_IRR = OKL_API.G_MISS_NUM) THEN
2104: l_klev_rec.PRE_TAX_IRR := NULL;
2105: END IF;
2106: IF (l_klev_rec.AFTER_TAX_IRR = OKL_API.G_MISS_NUM) THEN
2107: l_klev_rec.AFTER_TAX_IRR := NULL;

Line 2106: IF (l_klev_rec.AFTER_TAX_IRR = OKL_API.G_MISS_NUM) THEN

2102: END IF;
2103: IF (l_klev_rec.PRE_TAX_IRR = OKL_API.G_MISS_NUM) THEN
2104: l_klev_rec.PRE_TAX_IRR := NULL;
2105: END IF;
2106: IF (l_klev_rec.AFTER_TAX_IRR = OKL_API.G_MISS_NUM) THEN
2107: l_klev_rec.AFTER_TAX_IRR := NULL;
2108: END IF;
2109: --quote
2110: IF (l_klev_rec.SUB_PRE_TAX_YIELD = OKL_API.G_MISS_NUM) THEN

Line 2110: IF (l_klev_rec.SUB_PRE_TAX_YIELD = OKL_API.G_MISS_NUM) THEN

2106: IF (l_klev_rec.AFTER_TAX_IRR = OKL_API.G_MISS_NUM) THEN
2107: l_klev_rec.AFTER_TAX_IRR := NULL;
2108: END IF;
2109: --quote
2110: IF (l_klev_rec.SUB_PRE_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
2111: l_klev_rec.SUB_PRE_TAX_YIELD := NULL;
2112: END IF;
2113: IF (l_klev_rec.SUB_AFTER_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
2114: l_klev_rec.SUB_AFTER_TAX_YIELD := NULL;

Line 2113: IF (l_klev_rec.SUB_AFTER_TAX_YIELD = OKL_API.G_MISS_NUM) THEN

2109: --quote
2110: IF (l_klev_rec.SUB_PRE_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
2111: l_klev_rec.SUB_PRE_TAX_YIELD := NULL;
2112: END IF;
2113: IF (l_klev_rec.SUB_AFTER_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
2114: l_klev_rec.SUB_AFTER_TAX_YIELD := NULL;
2115: END IF;
2116: IF (l_klev_rec.SUB_IMPL_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
2117: l_klev_rec.SUB_IMPL_INTEREST_RATE := NULL;

Line 2116: IF (l_klev_rec.SUB_IMPL_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN

2112: END IF;
2113: IF (l_klev_rec.SUB_AFTER_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
2114: l_klev_rec.SUB_AFTER_TAX_YIELD := NULL;
2115: END IF;
2116: IF (l_klev_rec.SUB_IMPL_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
2117: l_klev_rec.SUB_IMPL_INTEREST_RATE := NULL;
2118: END IF;
2119: IF (l_klev_rec.SUB_IMPL_NON_IDC_INT_RATE = OKL_API.G_MISS_NUM) THEN
2120: l_klev_rec.SUB_IMPL_NON_IDC_INT_RATE := NULL;

Line 2119: IF (l_klev_rec.SUB_IMPL_NON_IDC_INT_RATE = OKL_API.G_MISS_NUM) THEN

2115: END IF;
2116: IF (l_klev_rec.SUB_IMPL_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
2117: l_klev_rec.SUB_IMPL_INTEREST_RATE := NULL;
2118: END IF;
2119: IF (l_klev_rec.SUB_IMPL_NON_IDC_INT_RATE = OKL_API.G_MISS_NUM) THEN
2120: l_klev_rec.SUB_IMPL_NON_IDC_INT_RATE := NULL;
2121: END IF;
2122: IF (l_klev_rec.SUB_PRE_TAX_IRR = OKL_API.G_MISS_NUM) THEN
2123: l_klev_rec.SUB_PRE_TAX_IRR := NULL;

Line 2122: IF (l_klev_rec.SUB_PRE_TAX_IRR = OKL_API.G_MISS_NUM) THEN

2118: END IF;
2119: IF (l_klev_rec.SUB_IMPL_NON_IDC_INT_RATE = OKL_API.G_MISS_NUM) THEN
2120: l_klev_rec.SUB_IMPL_NON_IDC_INT_RATE := NULL;
2121: END IF;
2122: IF (l_klev_rec.SUB_PRE_TAX_IRR = OKL_API.G_MISS_NUM) THEN
2123: l_klev_rec.SUB_PRE_TAX_IRR := NULL;
2124: END IF;
2125: IF (l_klev_rec.SUB_AFTER_TAX_IRR = OKL_API.G_MISS_NUM) THEN
2126: l_klev_rec.SUB_AFTER_TAX_IRR := NULL;

Line 2125: IF (l_klev_rec.SUB_AFTER_TAX_IRR = OKL_API.G_MISS_NUM) THEN

2121: END IF;
2122: IF (l_klev_rec.SUB_PRE_TAX_IRR = OKL_API.G_MISS_NUM) THEN
2123: l_klev_rec.SUB_PRE_TAX_IRR := NULL;
2124: END IF;
2125: IF (l_klev_rec.SUB_AFTER_TAX_IRR = OKL_API.G_MISS_NUM) THEN
2126: l_klev_rec.SUB_AFTER_TAX_IRR := NULL;
2127: END IF;
2128: --Bug# 2994971 :
2129: IF (l_klev_rec.ITEM_INSURANCE_CATEGORY = OKL_API.G_MISS_NUM) THEN

Line 2129: IF (l_klev_rec.ITEM_INSURANCE_CATEGORY = OKL_API.G_MISS_NUM) THEN

2125: IF (l_klev_rec.SUB_AFTER_TAX_IRR = OKL_API.G_MISS_NUM) THEN
2126: l_klev_rec.SUB_AFTER_TAX_IRR := NULL;
2127: END IF;
2128: --Bug# 2994971 :
2129: IF (l_klev_rec.ITEM_INSURANCE_CATEGORY = OKL_API.G_MISS_NUM) THEN
2130: l_klev_rec.ITEM_INSURANCE_CATEGORY := NULL;
2131: END IF;
2132: --Bug# 3973640 11.5.10+
2133: IF (l_klev_rec.QTE_ID = OKL_API.G_MISS_NUM) THEN

Line 2133: IF (l_klev_rec.QTE_ID = OKL_API.G_MISS_NUM) THEN

2129: IF (l_klev_rec.ITEM_INSURANCE_CATEGORY = OKL_API.G_MISS_NUM) THEN
2130: l_klev_rec.ITEM_INSURANCE_CATEGORY := NULL;
2131: END IF;
2132: --Bug# 3973640 11.5.10+
2133: IF (l_klev_rec.QTE_ID = OKL_API.G_MISS_NUM) THEN
2134: l_klev_rec.QTE_ID := NULL;
2135: END IF;
2136: IF (l_klev_rec.FUNDING_DATE = OKL_API.G_MISS_DATE) THEN
2137: l_klev_rec.FUNDING_DATE := NULL;

Line 2136: IF (l_klev_rec.FUNDING_DATE = OKL_API.G_MISS_DATE) THEN

2132: --Bug# 3973640 11.5.10+
2133: IF (l_klev_rec.QTE_ID = OKL_API.G_MISS_NUM) THEN
2134: l_klev_rec.QTE_ID := NULL;
2135: END IF;
2136: IF (l_klev_rec.FUNDING_DATE = OKL_API.G_MISS_DATE) THEN
2137: l_klev_rec.FUNDING_DATE := NULL;
2138: END IF;
2139: IF (l_klev_rec.STREAM_TYPE_SUBCLASS = OKL_API.G_MISS_CHAR) THEN
2140: l_klev_rec.STREAM_TYPE_SUBCLASS := NULL;

Line 2139: IF (l_klev_rec.STREAM_TYPE_SUBCLASS = OKL_API.G_MISS_CHAR) THEN

2135: END IF;
2136: IF (l_klev_rec.FUNDING_DATE = OKL_API.G_MISS_DATE) THEN
2137: l_klev_rec.FUNDING_DATE := NULL;
2138: END IF;
2139: IF (l_klev_rec.STREAM_TYPE_SUBCLASS = OKL_API.G_MISS_CHAR) THEN
2140: l_klev_rec.STREAM_TYPE_SUBCLASS := NULL;
2141: END IF;
2142:
2143: --Bug# 4419339 OKLH

Line 2144: IF (l_klev_rec.DATE_FUNDING_EXPECTED = OKL_API.G_MISS_DATE) THEN

2140: l_klev_rec.STREAM_TYPE_SUBCLASS := NULL;
2141: END IF;
2142:
2143: --Bug# 4419339 OKLH
2144: IF (l_klev_rec.DATE_FUNDING_EXPECTED = OKL_API.G_MISS_DATE) THEN
2145: l_klev_rec.DATE_FUNDING_EXPECTED := NULL;
2146: END IF;
2147:
2148: IF (l_klev_rec.MANUFACTURER_NAME = OKL_API.G_MISS_CHAR) THEN

Line 2148: IF (l_klev_rec.MANUFACTURER_NAME = OKL_API.G_MISS_CHAR) THEN

2144: IF (l_klev_rec.DATE_FUNDING_EXPECTED = OKL_API.G_MISS_DATE) THEN
2145: l_klev_rec.DATE_FUNDING_EXPECTED := NULL;
2146: END IF;
2147:
2148: IF (l_klev_rec.MANUFACTURER_NAME = OKL_API.G_MISS_CHAR) THEN
2149: l_klev_rec.MANUFACTURER_NAME := NULL;
2150: END IF;
2151:
2152: IF (l_klev_rec.MODEL_NUMBER = OKL_API.G_MISS_CHAR) THEN

Line 2152: IF (l_klev_rec.MODEL_NUMBER = OKL_API.G_MISS_CHAR) THEN

2148: IF (l_klev_rec.MANUFACTURER_NAME = OKL_API.G_MISS_CHAR) THEN
2149: l_klev_rec.MANUFACTURER_NAME := NULL;
2150: END IF;
2151:
2152: IF (l_klev_rec.MODEL_NUMBER = OKL_API.G_MISS_CHAR) THEN
2153: l_klev_rec.MODEL_NUMBER := NULL;
2154: END IF;
2155:
2156: IF (l_klev_rec.DOWN_PAYMENT_RECEIVER_CODE = OKL_API.G_MISS_CHAR) THEN

Line 2156: IF (l_klev_rec.DOWN_PAYMENT_RECEIVER_CODE = OKL_API.G_MISS_CHAR) THEN

2152: IF (l_klev_rec.MODEL_NUMBER = OKL_API.G_MISS_CHAR) THEN
2153: l_klev_rec.MODEL_NUMBER := NULL;
2154: END IF;
2155:
2156: IF (l_klev_rec.DOWN_PAYMENT_RECEIVER_CODE = OKL_API.G_MISS_CHAR) THEN
2157: l_klev_rec.DOWN_PAYMENT_RECEIVER_CODE := NULL;
2158: END IF;
2159:
2160: IF (l_klev_rec.CAPITALIZE_DOWN_PAYMENT_YN = OKL_API.G_MISS_CHAR) THEN

Line 2160: IF (l_klev_rec.CAPITALIZE_DOWN_PAYMENT_YN = OKL_API.G_MISS_CHAR) THEN

2156: IF (l_klev_rec.DOWN_PAYMENT_RECEIVER_CODE = OKL_API.G_MISS_CHAR) THEN
2157: l_klev_rec.DOWN_PAYMENT_RECEIVER_CODE := NULL;
2158: END IF;
2159:
2160: IF (l_klev_rec.CAPITALIZE_DOWN_PAYMENT_YN = OKL_API.G_MISS_CHAR) THEN
2161: l_klev_rec.CAPITALIZE_DOWN_PAYMENT_YN := NULL;
2162: END IF;
2163: --Bug#4373029
2164: IF (l_klev_rec.FEE_PURPOSE_CODE = OKL_API.G_MISS_CHAR) THEN

Line 2164: IF (l_klev_rec.FEE_PURPOSE_CODE = OKL_API.G_MISS_CHAR) THEN

2160: IF (l_klev_rec.CAPITALIZE_DOWN_PAYMENT_YN = OKL_API.G_MISS_CHAR) THEN
2161: l_klev_rec.CAPITALIZE_DOWN_PAYMENT_YN := NULL;
2162: END IF;
2163: --Bug#4373029
2164: IF (l_klev_rec.FEE_PURPOSE_CODE = OKL_API.G_MISS_CHAR) THEN
2165: l_klev_rec.FEE_PURPOSE_CODE := NULL;
2166: END IF;
2167:
2168: IF (l_klev_rec.TERMINATION_VALUE = OKL_API.G_MISS_NUM) THEN

Line 2168: IF (l_klev_rec.TERMINATION_VALUE = OKL_API.G_MISS_NUM) THEN

2164: IF (l_klev_rec.FEE_PURPOSE_CODE = OKL_API.G_MISS_CHAR) THEN
2165: l_klev_rec.FEE_PURPOSE_CODE := NULL;
2166: END IF;
2167:
2168: IF (l_klev_rec.TERMINATION_VALUE = OKL_API.G_MISS_NUM) THEN
2169: l_klev_rec.TERMINATION_VALUE := NULL;
2170: END IF;
2171:
2172: --Bug# 4631549

Line 2173: IF (l_klev_rec.EXPECTED_ASSET_COST = OKL_API.G_MISS_NUM) THEN

2169: l_klev_rec.TERMINATION_VALUE := NULL;
2170: END IF;
2171:
2172: --Bug# 4631549
2173: IF (l_klev_rec.EXPECTED_ASSET_COST = OKL_API.G_MISS_NUM) THEN
2174: l_klev_rec.EXPECTED_ASSET_COST := NULL;
2175: END IF;
2176:
2177: RETURN(l_klev_rec);

Line 2947: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

2943:
2944: PROCEDURE validate_row(
2945:
2946: p_api_version IN NUMBER,
2947: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2948: x_return_status OUT NOCOPY VARCHAR2,
2949: x_msg_count OUT NOCOPY NUMBER,
2950: x_msg_data OUT NOCOPY VARCHAR2,
2951: p_klev_rec IN klev_rec_type) IS

Line 3035: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

3031:
3032: PROCEDURE validate_row(
3033:
3034: p_api_version IN NUMBER,
3035: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
3036: x_return_status OUT NOCOPY VARCHAR2,
3037: x_msg_count OUT NOCOPY NUMBER,
3038: x_msg_data OUT NOCOPY VARCHAR2,
3039: p_klev_tbl IN klev_tbl_type) IS

Line 3110: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

3106:
3107: PROCEDURE insert_row(
3108:
3109: p_api_version IN NUMBER,
3110: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
3111: x_return_status OUT NOCOPY VARCHAR2,
3112: x_msg_count OUT NOCOPY NUMBER,
3113: x_msg_data OUT NOCOPY VARCHAR2,
3114: p_okl_k_lines_h_rec IN okl_k_lines_h_rec_type,

Line 3490: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

3486:
3487: PROCEDURE insert_row(
3488:
3489: p_api_version IN NUMBER,
3490: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
3491: x_return_status OUT NOCOPY VARCHAR2,
3492: x_msg_count OUT NOCOPY NUMBER,
3493: x_msg_data OUT NOCOPY VARCHAR2,
3494: p_kle_rec IN kle_rec_type,

Line 3866: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

3862:
3863: PROCEDURE insert_row(
3864:
3865: p_api_version IN NUMBER,
3866: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
3867: x_return_status OUT NOCOPY VARCHAR2,
3868: x_msg_count OUT NOCOPY NUMBER,
3869: x_msg_data OUT NOCOPY VARCHAR2,
3870: p_klev_rec IN klev_rec_type,

Line 4031: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

4027:
4028: PROCEDURE insert_row(
4029:
4030: p_api_version IN NUMBER,
4031: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
4032: x_return_status OUT NOCOPY VARCHAR2,
4033: x_msg_count OUT NOCOPY NUMBER,
4034: x_msg_data OUT NOCOPY VARCHAR2,
4035: p_klev_tbl IN klev_tbl_type,

Line 4107: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

4103:
4104: PROCEDURE lock_row(
4105:
4106: p_api_version IN NUMBER,
4107: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
4108: x_return_status OUT NOCOPY VARCHAR2,
4109: x_msg_count OUT NOCOPY NUMBER,
4110: x_msg_data OUT NOCOPY VARCHAR2,
4111: p_kle_rec IN kle_rec_type) IS

Line 4221: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

4217:
4218: PROCEDURE lock_row(
4219:
4220: p_api_version IN NUMBER,
4221: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
4222: x_return_status OUT NOCOPY VARCHAR2,
4223: x_msg_count OUT NOCOPY NUMBER,
4224: x_msg_data OUT NOCOPY VARCHAR2,
4225: p_klev_rec IN klev_rec_type) IS

Line 4310: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

4306:
4307: PROCEDURE lock_row(
4308:
4309: p_api_version IN NUMBER,
4310: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
4311: x_return_status OUT NOCOPY VARCHAR2,
4312: x_msg_count OUT NOCOPY NUMBER,
4313: x_msg_data OUT NOCOPY VARCHAR2,
4314: p_klev_tbl IN klev_tbl_type) IS

Line 4384: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

4380:
4381: PROCEDURE update_row(
4382:
4383: p_api_version IN NUMBER,
4384: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
4385: x_return_status OUT NOCOPY VARCHAR2,
4386: x_msg_count OUT NOCOPY NUMBER,
4387: x_msg_data OUT NOCOPY VARCHAR2,
4388: p_kle_rec IN kle_rec_type,

Line 4823: IF (x_kle_rec.SUBSIDY_ID = OKL_API.G_MISS_NUM) THEN

4819: END IF;
4820:
4821: --Bug# 3143522: 11.5.10
4822: --subsidy
4823: IF (x_kle_rec.SUBSIDY_ID = OKL_API.G_MISS_NUM) THEN
4824: x_kle_rec.SUBSIDY_ID := l_kle_rec.SUBSIDY_ID;
4825: END IF;
4826: --IF (x_kle_rec.SUBSIDIZED_OEC = OKL_API.G_MISS_NUM) THEN
4827: --x_kle_rec.SUBSIDIZED_OEC := l_kle_rec.SUBSIDIZED_OEC;

Line 4826: --IF (x_kle_rec.SUBSIDIZED_OEC = OKL_API.G_MISS_NUM) THEN

4822: --subsidy
4823: IF (x_kle_rec.SUBSIDY_ID = OKL_API.G_MISS_NUM) THEN
4824: x_kle_rec.SUBSIDY_ID := l_kle_rec.SUBSIDY_ID;
4825: END IF;
4826: --IF (x_kle_rec.SUBSIDIZED_OEC = OKL_API.G_MISS_NUM) THEN
4827: --x_kle_rec.SUBSIDIZED_OEC := l_kle_rec.SUBSIDIZED_OEC;
4828: --END IF;
4829: --IF (x_kle_rec.SUBSIDIZED_CAP_AMOUNT = OKL_API.G_MISS_NUM) THEN
4830: --x_kle_rec.SUBSIDIZED_CAP_AMOUNT := l_kle_rec.SUBSIDIZED_CAP_AMOUNT;

Line 4829: --IF (x_kle_rec.SUBSIDIZED_CAP_AMOUNT = OKL_API.G_MISS_NUM) THEN

4825: END IF;
4826: --IF (x_kle_rec.SUBSIDIZED_OEC = OKL_API.G_MISS_NUM) THEN
4827: --x_kle_rec.SUBSIDIZED_OEC := l_kle_rec.SUBSIDIZED_OEC;
4828: --END IF;
4829: --IF (x_kle_rec.SUBSIDIZED_CAP_AMOUNT = OKL_API.G_MISS_NUM) THEN
4830: --x_kle_rec.SUBSIDIZED_CAP_AMOUNT := l_kle_rec.SUBSIDIZED_CAP_AMOUNT;
4831: --END IF;
4832: IF (x_kle_rec.SUBSIDY_OVERRIDE_AMOUNT = OKL_API.G_MISS_NUM) THEN
4833: x_kle_rec.SUBSIDY_OVERRIDE_AMOUNT := l_kle_rec.SUBSIDY_OVERRIDE_AMOUNT;

Line 4832: IF (x_kle_rec.SUBSIDY_OVERRIDE_AMOUNT = OKL_API.G_MISS_NUM) THEN

4828: --END IF;
4829: --IF (x_kle_rec.SUBSIDIZED_CAP_AMOUNT = OKL_API.G_MISS_NUM) THEN
4830: --x_kle_rec.SUBSIDIZED_CAP_AMOUNT := l_kle_rec.SUBSIDIZED_CAP_AMOUNT;
4831: --END IF;
4832: IF (x_kle_rec.SUBSIDY_OVERRIDE_AMOUNT = OKL_API.G_MISS_NUM) THEN
4833: x_kle_rec.SUBSIDY_OVERRIDE_AMOUNT := l_kle_rec.SUBSIDY_OVERRIDE_AMOUNT;
4834: END IF;
4835: --financed fee
4836: IF (x_kle_rec.PRE_TAX_YIELD = OKL_API.G_MISS_NUM) THEN

Line 4836: IF (x_kle_rec.PRE_TAX_YIELD = OKL_API.G_MISS_NUM) THEN

4832: IF (x_kle_rec.SUBSIDY_OVERRIDE_AMOUNT = OKL_API.G_MISS_NUM) THEN
4833: x_kle_rec.SUBSIDY_OVERRIDE_AMOUNT := l_kle_rec.SUBSIDY_OVERRIDE_AMOUNT;
4834: END IF;
4835: --financed fee
4836: IF (x_kle_rec.PRE_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
4837: x_kle_rec.PRE_TAX_YIELD := l_kle_rec.PRE_TAX_YIELD;
4838: END IF;
4839: IF (x_kle_rec.AFTER_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
4840: x_kle_rec.AFTER_TAX_YIELD := l_kle_rec.AFTER_TAX_YIELD;

Line 4839: IF (x_kle_rec.AFTER_TAX_YIELD = OKL_API.G_MISS_NUM) THEN

4835: --financed fee
4836: IF (x_kle_rec.PRE_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
4837: x_kle_rec.PRE_TAX_YIELD := l_kle_rec.PRE_TAX_YIELD;
4838: END IF;
4839: IF (x_kle_rec.AFTER_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
4840: x_kle_rec.AFTER_TAX_YIELD := l_kle_rec.AFTER_TAX_YIELD;
4841: END IF;
4842: IF (x_kle_rec.IMPLICIT_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
4843: x_kle_rec.IMPLICIT_INTEREST_RATE := l_kle_rec.IMPLICIT_INTEREST_RATE;

Line 4842: IF (x_kle_rec.IMPLICIT_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN

4838: END IF;
4839: IF (x_kle_rec.AFTER_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
4840: x_kle_rec.AFTER_TAX_YIELD := l_kle_rec.AFTER_TAX_YIELD;
4841: END IF;
4842: IF (x_kle_rec.IMPLICIT_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
4843: x_kle_rec.IMPLICIT_INTEREST_RATE := l_kle_rec.IMPLICIT_INTEREST_RATE;
4844: END IF;
4845: IF (x_kle_rec.IMPLICIT_NON_IDC_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
4846: x_kle_rec.IMPLICIT_NON_IDC_INTEREST_RATE := l_kle_rec.IMPLICIT_NON_IDC_INTEREST_RATE;

Line 4845: IF (x_kle_rec.IMPLICIT_NON_IDC_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN

4841: END IF;
4842: IF (x_kle_rec.IMPLICIT_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
4843: x_kle_rec.IMPLICIT_INTEREST_RATE := l_kle_rec.IMPLICIT_INTEREST_RATE;
4844: END IF;
4845: IF (x_kle_rec.IMPLICIT_NON_IDC_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
4846: x_kle_rec.IMPLICIT_NON_IDC_INTEREST_RATE := l_kle_rec.IMPLICIT_NON_IDC_INTEREST_RATE;
4847: END IF;
4848: IF (x_kle_rec.PRE_TAX_IRR = OKL_API.G_MISS_NUM) THEN
4849: x_kle_rec.PRE_TAX_IRR := l_kle_rec.PRE_TAX_IRR;

Line 4848: IF (x_kle_rec.PRE_TAX_IRR = OKL_API.G_MISS_NUM) THEN

4844: END IF;
4845: IF (x_kle_rec.IMPLICIT_NON_IDC_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
4846: x_kle_rec.IMPLICIT_NON_IDC_INTEREST_RATE := l_kle_rec.IMPLICIT_NON_IDC_INTEREST_RATE;
4847: END IF;
4848: IF (x_kle_rec.PRE_TAX_IRR = OKL_API.G_MISS_NUM) THEN
4849: x_kle_rec.PRE_TAX_IRR := l_kle_rec.PRE_TAX_IRR;
4850: END IF;
4851: IF (x_kle_rec.AFTER_TAX_IRR = OKL_API.G_MISS_NUM) THEN
4852: x_kle_rec.AFTER_TAX_IRR := l_kle_rec.AFTER_TAX_IRR;

Line 4851: IF (x_kle_rec.AFTER_TAX_IRR = OKL_API.G_MISS_NUM) THEN

4847: END IF;
4848: IF (x_kle_rec.PRE_TAX_IRR = OKL_API.G_MISS_NUM) THEN
4849: x_kle_rec.PRE_TAX_IRR := l_kle_rec.PRE_TAX_IRR;
4850: END IF;
4851: IF (x_kle_rec.AFTER_TAX_IRR = OKL_API.G_MISS_NUM) THEN
4852: x_kle_rec.AFTER_TAX_IRR := l_kle_rec.AFTER_TAX_IRR;
4853: END IF;
4854: --quote
4855: IF (x_kle_rec.SUB_PRE_TAX_YIELD = OKL_API.G_MISS_NUM) THEN

Line 4855: IF (x_kle_rec.SUB_PRE_TAX_YIELD = OKL_API.G_MISS_NUM) THEN

4851: IF (x_kle_rec.AFTER_TAX_IRR = OKL_API.G_MISS_NUM) THEN
4852: x_kle_rec.AFTER_TAX_IRR := l_kle_rec.AFTER_TAX_IRR;
4853: END IF;
4854: --quote
4855: IF (x_kle_rec.SUB_PRE_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
4856: x_kle_rec.SUB_PRE_TAX_YIELD := l_kle_rec.SUB_PRE_TAX_YIELD;
4857: END IF;
4858: IF (x_kle_rec.SUB_AFTER_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
4859: x_kle_rec.SUB_AFTER_TAX_YIELD := l_kle_rec.SUB_AFTER_TAX_YIELD;

Line 4858: IF (x_kle_rec.SUB_AFTER_TAX_YIELD = OKL_API.G_MISS_NUM) THEN

4854: --quote
4855: IF (x_kle_rec.SUB_PRE_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
4856: x_kle_rec.SUB_PRE_TAX_YIELD := l_kle_rec.SUB_PRE_TAX_YIELD;
4857: END IF;
4858: IF (x_kle_rec.SUB_AFTER_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
4859: x_kle_rec.SUB_AFTER_TAX_YIELD := l_kle_rec.SUB_AFTER_TAX_YIELD;
4860: END IF;
4861: IF (x_kle_rec.SUB_IMPL_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
4862: x_kle_rec.SUB_IMPL_INTEREST_RATE := l_kle_rec.SUB_IMPL_INTEREST_RATE;

Line 4861: IF (x_kle_rec.SUB_IMPL_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN

4857: END IF;
4858: IF (x_kle_rec.SUB_AFTER_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
4859: x_kle_rec.SUB_AFTER_TAX_YIELD := l_kle_rec.SUB_AFTER_TAX_YIELD;
4860: END IF;
4861: IF (x_kle_rec.SUB_IMPL_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
4862: x_kle_rec.SUB_IMPL_INTEREST_RATE := l_kle_rec.SUB_IMPL_INTEREST_RATE;
4863: END IF;
4864: IF (x_kle_rec.SUB_IMPL_NON_IDC_INT_RATE = OKL_API.G_MISS_NUM) THEN
4865: x_kle_rec.SUB_IMPL_NON_IDC_INT_RATE := l_kle_rec.SUB_IMPL_NON_IDC_INT_RATE;

Line 4864: IF (x_kle_rec.SUB_IMPL_NON_IDC_INT_RATE = OKL_API.G_MISS_NUM) THEN

4860: END IF;
4861: IF (x_kle_rec.SUB_IMPL_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
4862: x_kle_rec.SUB_IMPL_INTEREST_RATE := l_kle_rec.SUB_IMPL_INTEREST_RATE;
4863: END IF;
4864: IF (x_kle_rec.SUB_IMPL_NON_IDC_INT_RATE = OKL_API.G_MISS_NUM) THEN
4865: x_kle_rec.SUB_IMPL_NON_IDC_INT_RATE := l_kle_rec.SUB_IMPL_NON_IDC_INT_RATE;
4866: END IF;
4867: IF (x_kle_rec.SUB_PRE_TAX_IRR = OKL_API.G_MISS_NUM) THEN
4868: x_kle_rec.SUB_PRE_TAX_IRR := l_kle_rec.SUB_PRE_TAX_IRR;

Line 4867: IF (x_kle_rec.SUB_PRE_TAX_IRR = OKL_API.G_MISS_NUM) THEN

4863: END IF;
4864: IF (x_kle_rec.SUB_IMPL_NON_IDC_INT_RATE = OKL_API.G_MISS_NUM) THEN
4865: x_kle_rec.SUB_IMPL_NON_IDC_INT_RATE := l_kle_rec.SUB_IMPL_NON_IDC_INT_RATE;
4866: END IF;
4867: IF (x_kle_rec.SUB_PRE_TAX_IRR = OKL_API.G_MISS_NUM) THEN
4868: x_kle_rec.SUB_PRE_TAX_IRR := l_kle_rec.SUB_PRE_TAX_IRR;
4869: END IF;
4870: IF (x_kle_rec.SUB_AFTER_TAX_IRR = OKL_API.G_MISS_NUM) THEN
4871: x_kle_rec.SUB_AFTER_TAX_IRR := l_kle_rec.SUB_AFTER_TAX_IRR;

Line 4870: IF (x_kle_rec.SUB_AFTER_TAX_IRR = OKL_API.G_MISS_NUM) THEN

4866: END IF;
4867: IF (x_kle_rec.SUB_PRE_TAX_IRR = OKL_API.G_MISS_NUM) THEN
4868: x_kle_rec.SUB_PRE_TAX_IRR := l_kle_rec.SUB_PRE_TAX_IRR;
4869: END IF;
4870: IF (x_kle_rec.SUB_AFTER_TAX_IRR = OKL_API.G_MISS_NUM) THEN
4871: x_kle_rec.SUB_AFTER_TAX_IRR := l_kle_rec.SUB_AFTER_TAX_IRR;
4872: END IF;
4873: --Bug# 2994971
4874: IF (x_kle_rec.ITEM_INSURANCE_CATEGORY = OKL_API.G_MISS_NUM) THEN

Line 4874: IF (x_kle_rec.ITEM_INSURANCE_CATEGORY = OKL_API.G_MISS_NUM) THEN

4870: IF (x_kle_rec.SUB_AFTER_TAX_IRR = OKL_API.G_MISS_NUM) THEN
4871: x_kle_rec.SUB_AFTER_TAX_IRR := l_kle_rec.SUB_AFTER_TAX_IRR;
4872: END IF;
4873: --Bug# 2994971
4874: IF (x_kle_rec.ITEM_INSURANCE_CATEGORY = OKL_API.G_MISS_NUM) THEN
4875: x_kle_rec.ITEM_INSURANCE_CATEGORY := l_kle_rec.ITEM_INSURANCE_CATEGORY;
4876: END IF;
4877: --Bug# 3973640 :11.5.10+
4878: IF (x_kle_rec.QTE_ID = OKL_API.G_MISS_NUM) THEN

Line 4878: IF (x_kle_rec.QTE_ID = OKL_API.G_MISS_NUM) THEN

4874: IF (x_kle_rec.ITEM_INSURANCE_CATEGORY = OKL_API.G_MISS_NUM) THEN
4875: x_kle_rec.ITEM_INSURANCE_CATEGORY := l_kle_rec.ITEM_INSURANCE_CATEGORY;
4876: END IF;
4877: --Bug# 3973640 :11.5.10+
4878: IF (x_kle_rec.QTE_ID = OKL_API.G_MISS_NUM) THEN
4879: x_kle_rec.QTE_ID := l_kle_rec.QTE_ID;
4880: END IF;
4881: IF (x_kle_rec.FUNDING_DATE = OKL_API.G_MISS_DATE) THEN
4882: x_kle_rec.FUNDING_DATE := l_kle_rec.FUNDING_DATE;

Line 4881: IF (x_kle_rec.FUNDING_DATE = OKL_API.G_MISS_DATE) THEN

4877: --Bug# 3973640 :11.5.10+
4878: IF (x_kle_rec.QTE_ID = OKL_API.G_MISS_NUM) THEN
4879: x_kle_rec.QTE_ID := l_kle_rec.QTE_ID;
4880: END IF;
4881: IF (x_kle_rec.FUNDING_DATE = OKL_API.G_MISS_DATE) THEN
4882: x_kle_rec.FUNDING_DATE := l_kle_rec.FUNDING_DATE;
4883: END IF;
4884: IF (x_kle_rec.STREAM_TYPE_SUBCLASS = OKL_API.G_MISS_CHAR) THEN
4885: x_kle_rec.STREAM_TYPE_SUBCLASS := l_kle_rec.STREAM_TYPE_SUBCLASS;

Line 4884: IF (x_kle_rec.STREAM_TYPE_SUBCLASS = OKL_API.G_MISS_CHAR) THEN

4880: END IF;
4881: IF (x_kle_rec.FUNDING_DATE = OKL_API.G_MISS_DATE) THEN
4882: x_kle_rec.FUNDING_DATE := l_kle_rec.FUNDING_DATE;
4883: END IF;
4884: IF (x_kle_rec.STREAM_TYPE_SUBCLASS = OKL_API.G_MISS_CHAR) THEN
4885: x_kle_rec.STREAM_TYPE_SUBCLASS := l_kle_rec.STREAM_TYPE_SUBCLASS;
4886: END IF;
4887:
4888: --Bug# 4419339 OKLH

Line 4889: IF (x_kle_rec.DATE_FUNDING_EXPECTED = OKL_API.G_MISS_DATE) THEN

4885: x_kle_rec.STREAM_TYPE_SUBCLASS := l_kle_rec.STREAM_TYPE_SUBCLASS;
4886: END IF;
4887:
4888: --Bug# 4419339 OKLH
4889: IF (x_kle_rec.DATE_FUNDING_EXPECTED = OKL_API.G_MISS_DATE) THEN
4890: x_kle_rec.DATE_FUNDING_EXPECTED := l_kle_rec.DATE_FUNDING_EXPECTED;
4891: END IF;
4892:
4893: IF (x_kle_rec.MANUFACTURER_NAME = OKL_API.G_MISS_CHAR) THEN

Line 4893: IF (x_kle_rec.MANUFACTURER_NAME = OKL_API.G_MISS_CHAR) THEN

4889: IF (x_kle_rec.DATE_FUNDING_EXPECTED = OKL_API.G_MISS_DATE) THEN
4890: x_kle_rec.DATE_FUNDING_EXPECTED := l_kle_rec.DATE_FUNDING_EXPECTED;
4891: END IF;
4892:
4893: IF (x_kle_rec.MANUFACTURER_NAME = OKL_API.G_MISS_CHAR) THEN
4894: x_kle_rec.MANUFACTURER_NAME := l_kle_rec.MANUFACTURER_NAME;
4895: END IF;
4896:
4897: IF (x_kle_rec.MODEL_NUMBER = OKL_API.G_MISS_CHAR) THEN

Line 4897: IF (x_kle_rec.MODEL_NUMBER = OKL_API.G_MISS_CHAR) THEN

4893: IF (x_kle_rec.MANUFACTURER_NAME = OKL_API.G_MISS_CHAR) THEN
4894: x_kle_rec.MANUFACTURER_NAME := l_kle_rec.MANUFACTURER_NAME;
4895: END IF;
4896:
4897: IF (x_kle_rec.MODEL_NUMBER = OKL_API.G_MISS_CHAR) THEN
4898: x_kle_rec.MODEL_NUMBER := l_kle_rec.MODEL_NUMBER;
4899: END IF;
4900:
4901: IF (x_kle_rec.DOWN_PAYMENT_RECEIVER_CODE = OKL_API.G_MISS_CHAR) THEN

Line 4901: IF (x_kle_rec.DOWN_PAYMENT_RECEIVER_CODE = OKL_API.G_MISS_CHAR) THEN

4897: IF (x_kle_rec.MODEL_NUMBER = OKL_API.G_MISS_CHAR) THEN
4898: x_kle_rec.MODEL_NUMBER := l_kle_rec.MODEL_NUMBER;
4899: END IF;
4900:
4901: IF (x_kle_rec.DOWN_PAYMENT_RECEIVER_CODE = OKL_API.G_MISS_CHAR) THEN
4902: x_kle_rec.DOWN_PAYMENT_RECEIVER_CODE := l_kle_rec.DOWN_PAYMENT_RECEIVER_CODE;
4903: END IF;
4904:
4905: IF (x_kle_rec.CAPITALIZE_DOWN_PAYMENT_YN = OKL_API.G_MISS_CHAR) THEN

Line 4905: IF (x_kle_rec.CAPITALIZE_DOWN_PAYMENT_YN = OKL_API.G_MISS_CHAR) THEN

4901: IF (x_kle_rec.DOWN_PAYMENT_RECEIVER_CODE = OKL_API.G_MISS_CHAR) THEN
4902: x_kle_rec.DOWN_PAYMENT_RECEIVER_CODE := l_kle_rec.DOWN_PAYMENT_RECEIVER_CODE;
4903: END IF;
4904:
4905: IF (x_kle_rec.CAPITALIZE_DOWN_PAYMENT_YN = OKL_API.G_MISS_CHAR) THEN
4906: x_kle_rec.CAPITALIZE_DOWN_PAYMENT_YN := l_kle_rec.CAPITALIZE_DOWN_PAYMENT_YN;
4907: END IF;
4908:
4909: IF (x_kle_rec.FEE_PURPOSE_CODE = OKL_API.G_MISS_CHAR) THEN

Line 4909: IF (x_kle_rec.FEE_PURPOSE_CODE = OKL_API.G_MISS_CHAR) THEN

4905: IF (x_kle_rec.CAPITALIZE_DOWN_PAYMENT_YN = OKL_API.G_MISS_CHAR) THEN
4906: x_kle_rec.CAPITALIZE_DOWN_PAYMENT_YN := l_kle_rec.CAPITALIZE_DOWN_PAYMENT_YN;
4907: END IF;
4908:
4909: IF (x_kle_rec.FEE_PURPOSE_CODE = OKL_API.G_MISS_CHAR) THEN
4910: x_kle_rec.FEE_PURPOSE_CODE := l_kle_rec.FEE_PURPOSE_CODE;
4911: END IF;
4912:
4913: IF (x_kle_rec.TERMINATION_VALUE = OKL_API.G_MISS_NUM) THEN

Line 4913: IF (x_kle_rec.TERMINATION_VALUE = OKL_API.G_MISS_NUM) THEN

4909: IF (x_kle_rec.FEE_PURPOSE_CODE = OKL_API.G_MISS_CHAR) THEN
4910: x_kle_rec.FEE_PURPOSE_CODE := l_kle_rec.FEE_PURPOSE_CODE;
4911: END IF;
4912:
4913: IF (x_kle_rec.TERMINATION_VALUE = OKL_API.G_MISS_NUM) THEN
4914: x_kle_rec.TERMINATION_VALUE := l_kle_rec.TERMINATION_VALUE;
4915: END IF;
4916:
4917: --Bug# 4631549

Line 4918: IF (x_kle_rec.EXPECTED_ASSET_COST = OKL_API.G_MISS_NUM) THEN

4914: x_kle_rec.TERMINATION_VALUE := l_kle_rec.TERMINATION_VALUE;
4915: END IF;
4916:
4917: --Bug# 4631549
4918: IF (x_kle_rec.EXPECTED_ASSET_COST = OKL_API.G_MISS_NUM) THEN
4919: x_kle_rec.EXPECTED_ASSET_COST := l_kle_rec.EXPECTED_ASSET_COST;
4920: END IF;
4921:
4922: RETURN(l_return_status);

Line 5174: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

5170:
5171: PROCEDURE update_row(
5172:
5173: p_api_version IN NUMBER,
5174: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
5175: x_return_status OUT NOCOPY VARCHAR2,
5176: x_msg_count OUT NOCOPY NUMBER,
5177: x_msg_data OUT NOCOPY VARCHAR2,
5178: p_klev_rec IN klev_rec_type,

Line 5620: IF (x_klev_rec.SUBSIDY_ID = OKL_API.G_MISS_NUM) THEN

5616: x_klev_rec.FEE_TYPE := l_klev_rec.FEE_TYPE;
5617: END IF;
5618: --Bug# 3143522: 11.5.10
5619: --subsidy
5620: IF (x_klev_rec.SUBSIDY_ID = OKL_API.G_MISS_NUM) THEN
5621: x_klev_rec.SUBSIDY_ID := l_klev_rec.SUBSIDY_ID;
5622: END IF;
5623: --IF (x_klev_rec.SUBSIDIZED_OEC = OKL_API.G_MISS_NUM) THEN
5624: --x_klev_rec.SUBSIDIZED_OEC := l_klev_rec.SUBSIDIZED_OEC;

Line 5623: --IF (x_klev_rec.SUBSIDIZED_OEC = OKL_API.G_MISS_NUM) THEN

5619: --subsidy
5620: IF (x_klev_rec.SUBSIDY_ID = OKL_API.G_MISS_NUM) THEN
5621: x_klev_rec.SUBSIDY_ID := l_klev_rec.SUBSIDY_ID;
5622: END IF;
5623: --IF (x_klev_rec.SUBSIDIZED_OEC = OKL_API.G_MISS_NUM) THEN
5624: --x_klev_rec.SUBSIDIZED_OEC := l_klev_rec.SUBSIDIZED_OEC;
5625: --END IF;
5626: --IF (x_klev_rec.SUBSIDIZED_CAP_AMOUNT = OKL_API.G_MISS_NUM) THEN
5627: --x_klev_rec.SUBSIDIZED_CAP_AMOUNT := l_klev_rec.SUBSIDIZED_CAP_AMOUNT;

Line 5626: --IF (x_klev_rec.SUBSIDIZED_CAP_AMOUNT = OKL_API.G_MISS_NUM) THEN

5622: END IF;
5623: --IF (x_klev_rec.SUBSIDIZED_OEC = OKL_API.G_MISS_NUM) THEN
5624: --x_klev_rec.SUBSIDIZED_OEC := l_klev_rec.SUBSIDIZED_OEC;
5625: --END IF;
5626: --IF (x_klev_rec.SUBSIDIZED_CAP_AMOUNT = OKL_API.G_MISS_NUM) THEN
5627: --x_klev_rec.SUBSIDIZED_CAP_AMOUNT := l_klev_rec.SUBSIDIZED_CAP_AMOUNT;
5628: --END IF;
5629: IF (x_klev_rec.SUBSIDY_OVERRIDE_AMOUNT = OKL_API.G_MISS_NUM) THEN
5630: x_klev_rec.SUBSIDY_OVERRIDE_AMOUNT := l_klev_rec.SUBSIDY_OVERRIDE_AMOUNT;

Line 5629: IF (x_klev_rec.SUBSIDY_OVERRIDE_AMOUNT = OKL_API.G_MISS_NUM) THEN

5625: --END IF;
5626: --IF (x_klev_rec.SUBSIDIZED_CAP_AMOUNT = OKL_API.G_MISS_NUM) THEN
5627: --x_klev_rec.SUBSIDIZED_CAP_AMOUNT := l_klev_rec.SUBSIDIZED_CAP_AMOUNT;
5628: --END IF;
5629: IF (x_klev_rec.SUBSIDY_OVERRIDE_AMOUNT = OKL_API.G_MISS_NUM) THEN
5630: x_klev_rec.SUBSIDY_OVERRIDE_AMOUNT := l_klev_rec.SUBSIDY_OVERRIDE_AMOUNT;
5631: END IF;
5632: --financed fee
5633: IF (x_klev_rec.PRE_TAX_YIELD = OKL_API.G_MISS_NUM) THEN

Line 5633: IF (x_klev_rec.PRE_TAX_YIELD = OKL_API.G_MISS_NUM) THEN

5629: IF (x_klev_rec.SUBSIDY_OVERRIDE_AMOUNT = OKL_API.G_MISS_NUM) THEN
5630: x_klev_rec.SUBSIDY_OVERRIDE_AMOUNT := l_klev_rec.SUBSIDY_OVERRIDE_AMOUNT;
5631: END IF;
5632: --financed fee
5633: IF (x_klev_rec.PRE_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
5634: x_klev_rec.PRE_TAX_YIELD := l_klev_rec.PRE_TAX_YIELD;
5635: END IF;
5636: IF (x_klev_rec.AFTER_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
5637: x_klev_rec.AFTER_TAX_YIELD := l_klev_rec.AFTER_TAX_YIELD;

Line 5636: IF (x_klev_rec.AFTER_TAX_YIELD = OKL_API.G_MISS_NUM) THEN

5632: --financed fee
5633: IF (x_klev_rec.PRE_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
5634: x_klev_rec.PRE_TAX_YIELD := l_klev_rec.PRE_TAX_YIELD;
5635: END IF;
5636: IF (x_klev_rec.AFTER_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
5637: x_klev_rec.AFTER_TAX_YIELD := l_klev_rec.AFTER_TAX_YIELD;
5638: END IF;
5639: IF (x_klev_rec.IMPLICIT_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
5640: x_klev_rec.IMPLICIT_INTEREST_RATE := l_klev_rec.IMPLICIT_INTEREST_RATE;

Line 5639: IF (x_klev_rec.IMPLICIT_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN

5635: END IF;
5636: IF (x_klev_rec.AFTER_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
5637: x_klev_rec.AFTER_TAX_YIELD := l_klev_rec.AFTER_TAX_YIELD;
5638: END IF;
5639: IF (x_klev_rec.IMPLICIT_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
5640: x_klev_rec.IMPLICIT_INTEREST_RATE := l_klev_rec.IMPLICIT_INTEREST_RATE;
5641: END IF;
5642: IF (x_klev_rec.IMPLICIT_NON_IDC_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
5643: x_klev_rec.IMPLICIT_NON_IDC_INTEREST_RATE := l_klev_rec.IMPLICIT_NON_IDC_INTEREST_RATE;

Line 5642: IF (x_klev_rec.IMPLICIT_NON_IDC_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN

5638: END IF;
5639: IF (x_klev_rec.IMPLICIT_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
5640: x_klev_rec.IMPLICIT_INTEREST_RATE := l_klev_rec.IMPLICIT_INTEREST_RATE;
5641: END IF;
5642: IF (x_klev_rec.IMPLICIT_NON_IDC_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
5643: x_klev_rec.IMPLICIT_NON_IDC_INTEREST_RATE := l_klev_rec.IMPLICIT_NON_IDC_INTEREST_RATE;
5644: END IF;
5645: IF (x_klev_rec.PRE_TAX_IRR = OKL_API.G_MISS_NUM) THEN
5646: x_klev_rec.PRE_TAX_IRR := l_klev_rec.PRE_TAX_IRR;

Line 5645: IF (x_klev_rec.PRE_TAX_IRR = OKL_API.G_MISS_NUM) THEN

5641: END IF;
5642: IF (x_klev_rec.IMPLICIT_NON_IDC_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
5643: x_klev_rec.IMPLICIT_NON_IDC_INTEREST_RATE := l_klev_rec.IMPLICIT_NON_IDC_INTEREST_RATE;
5644: END IF;
5645: IF (x_klev_rec.PRE_TAX_IRR = OKL_API.G_MISS_NUM) THEN
5646: x_klev_rec.PRE_TAX_IRR := l_klev_rec.PRE_TAX_IRR;
5647: END IF;
5648: IF (x_klev_rec.AFTER_TAX_IRR = OKL_API.G_MISS_NUM) THEN
5649: x_klev_rec.AFTER_TAX_IRR := l_klev_rec.AFTER_TAX_IRR;

Line 5648: IF (x_klev_rec.AFTER_TAX_IRR = OKL_API.G_MISS_NUM) THEN

5644: END IF;
5645: IF (x_klev_rec.PRE_TAX_IRR = OKL_API.G_MISS_NUM) THEN
5646: x_klev_rec.PRE_TAX_IRR := l_klev_rec.PRE_TAX_IRR;
5647: END IF;
5648: IF (x_klev_rec.AFTER_TAX_IRR = OKL_API.G_MISS_NUM) THEN
5649: x_klev_rec.AFTER_TAX_IRR := l_klev_rec.AFTER_TAX_IRR;
5650: END IF;
5651: --quote
5652: IF (x_klev_rec.SUB_PRE_TAX_YIELD = OKL_API.G_MISS_NUM) THEN

Line 5652: IF (x_klev_rec.SUB_PRE_TAX_YIELD = OKL_API.G_MISS_NUM) THEN

5648: IF (x_klev_rec.AFTER_TAX_IRR = OKL_API.G_MISS_NUM) THEN
5649: x_klev_rec.AFTER_TAX_IRR := l_klev_rec.AFTER_TAX_IRR;
5650: END IF;
5651: --quote
5652: IF (x_klev_rec.SUB_PRE_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
5653: x_klev_rec.SUB_PRE_TAX_YIELD := l_klev_rec.SUB_PRE_TAX_YIELD;
5654: END IF;
5655: IF (x_klev_rec.SUB_AFTER_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
5656: x_klev_rec.SUB_AFTER_TAX_YIELD := l_klev_rec.SUB_AFTER_TAX_YIELD;

Line 5655: IF (x_klev_rec.SUB_AFTER_TAX_YIELD = OKL_API.G_MISS_NUM) THEN

5651: --quote
5652: IF (x_klev_rec.SUB_PRE_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
5653: x_klev_rec.SUB_PRE_TAX_YIELD := l_klev_rec.SUB_PRE_TAX_YIELD;
5654: END IF;
5655: IF (x_klev_rec.SUB_AFTER_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
5656: x_klev_rec.SUB_AFTER_TAX_YIELD := l_klev_rec.SUB_AFTER_TAX_YIELD;
5657: END IF;
5658: IF (x_klev_rec.SUB_IMPL_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
5659: x_klev_rec.SUB_IMPL_INTEREST_RATE := l_klev_rec.SUB_IMPL_INTEREST_RATE;

Line 5658: IF (x_klev_rec.SUB_IMPL_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN

5654: END IF;
5655: IF (x_klev_rec.SUB_AFTER_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
5656: x_klev_rec.SUB_AFTER_TAX_YIELD := l_klev_rec.SUB_AFTER_TAX_YIELD;
5657: END IF;
5658: IF (x_klev_rec.SUB_IMPL_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
5659: x_klev_rec.SUB_IMPL_INTEREST_RATE := l_klev_rec.SUB_IMPL_INTEREST_RATE;
5660: END IF;
5661: IF (x_klev_rec.SUB_IMPL_NON_IDC_INT_RATE = OKL_API.G_MISS_NUM) THEN
5662: x_klev_rec.SUB_IMPL_NON_IDC_INT_RATE := l_klev_rec.SUB_IMPL_NON_IDC_INT_RATE;

Line 5661: IF (x_klev_rec.SUB_IMPL_NON_IDC_INT_RATE = OKL_API.G_MISS_NUM) THEN

5657: END IF;
5658: IF (x_klev_rec.SUB_IMPL_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
5659: x_klev_rec.SUB_IMPL_INTEREST_RATE := l_klev_rec.SUB_IMPL_INTEREST_RATE;
5660: END IF;
5661: IF (x_klev_rec.SUB_IMPL_NON_IDC_INT_RATE = OKL_API.G_MISS_NUM) THEN
5662: x_klev_rec.SUB_IMPL_NON_IDC_INT_RATE := l_klev_rec.SUB_IMPL_NON_IDC_INT_RATE;
5663: END IF;
5664: IF (x_klev_rec.SUB_PRE_TAX_IRR = OKL_API.G_MISS_NUM) THEN
5665: x_klev_rec.SUB_PRE_TAX_IRR := l_klev_rec.SUB_PRE_TAX_IRR;

Line 5664: IF (x_klev_rec.SUB_PRE_TAX_IRR = OKL_API.G_MISS_NUM) THEN

5660: END IF;
5661: IF (x_klev_rec.SUB_IMPL_NON_IDC_INT_RATE = OKL_API.G_MISS_NUM) THEN
5662: x_klev_rec.SUB_IMPL_NON_IDC_INT_RATE := l_klev_rec.SUB_IMPL_NON_IDC_INT_RATE;
5663: END IF;
5664: IF (x_klev_rec.SUB_PRE_TAX_IRR = OKL_API.G_MISS_NUM) THEN
5665: x_klev_rec.SUB_PRE_TAX_IRR := l_klev_rec.SUB_PRE_TAX_IRR;
5666: END IF;
5667: IF (x_klev_rec.SUB_AFTER_TAX_IRR = OKL_API.G_MISS_NUM) THEN
5668: x_klev_rec.SUB_AFTER_TAX_IRR := l_klev_rec.SUB_AFTER_TAX_IRR;

Line 5667: IF (x_klev_rec.SUB_AFTER_TAX_IRR = OKL_API.G_MISS_NUM) THEN

5663: END IF;
5664: IF (x_klev_rec.SUB_PRE_TAX_IRR = OKL_API.G_MISS_NUM) THEN
5665: x_klev_rec.SUB_PRE_TAX_IRR := l_klev_rec.SUB_PRE_TAX_IRR;
5666: END IF;
5667: IF (x_klev_rec.SUB_AFTER_TAX_IRR = OKL_API.G_MISS_NUM) THEN
5668: x_klev_rec.SUB_AFTER_TAX_IRR := l_klev_rec.SUB_AFTER_TAX_IRR;
5669: END IF;
5670: --Bug# 2994971
5671: IF (x_klev_rec.ITEM_INSURANCE_CATEGORY = OKL_API.G_MISS_NUM) THEN

Line 5671: IF (x_klev_rec.ITEM_INSURANCE_CATEGORY = OKL_API.G_MISS_NUM) THEN

5667: IF (x_klev_rec.SUB_AFTER_TAX_IRR = OKL_API.G_MISS_NUM) THEN
5668: x_klev_rec.SUB_AFTER_TAX_IRR := l_klev_rec.SUB_AFTER_TAX_IRR;
5669: END IF;
5670: --Bug# 2994971
5671: IF (x_klev_rec.ITEM_INSURANCE_CATEGORY = OKL_API.G_MISS_NUM) THEN
5672: x_klev_rec.ITEM_INSURANCE_CATEGORY := l_klev_rec.ITEM_INSURANCE_CATEGORY;
5673: END IF;
5674: --Bug# 3973640 :11.5.10+
5675: IF (x_klev_rec.QTE_ID = OKL_API.G_MISS_NUM) THEN

Line 5675: IF (x_klev_rec.QTE_ID = OKL_API.G_MISS_NUM) THEN

5671: IF (x_klev_rec.ITEM_INSURANCE_CATEGORY = OKL_API.G_MISS_NUM) THEN
5672: x_klev_rec.ITEM_INSURANCE_CATEGORY := l_klev_rec.ITEM_INSURANCE_CATEGORY;
5673: END IF;
5674: --Bug# 3973640 :11.5.10+
5675: IF (x_klev_rec.QTE_ID = OKL_API.G_MISS_NUM) THEN
5676: x_klev_rec.QTE_ID := l_klev_rec.QTE_ID;
5677: END IF;
5678: IF (x_klev_rec.FUNDING_DATE = OKL_API.G_MISS_DATE) THEN
5679: x_klev_rec.FUNDING_DATE := l_klev_rec.FUNDING_DATE;

Line 5678: IF (x_klev_rec.FUNDING_DATE = OKL_API.G_MISS_DATE) THEN

5674: --Bug# 3973640 :11.5.10+
5675: IF (x_klev_rec.QTE_ID = OKL_API.G_MISS_NUM) THEN
5676: x_klev_rec.QTE_ID := l_klev_rec.QTE_ID;
5677: END IF;
5678: IF (x_klev_rec.FUNDING_DATE = OKL_API.G_MISS_DATE) THEN
5679: x_klev_rec.FUNDING_DATE := l_klev_rec.FUNDING_DATE;
5680: END IF;
5681: IF (x_klev_rec.STREAM_TYPE_SUBCLASS = OKL_API.G_MISS_CHAR) THEN
5682: x_klev_rec.STREAM_TYPE_SUBCLASS := l_klev_rec.STREAM_TYPE_SUBCLASS;

Line 5681: IF (x_klev_rec.STREAM_TYPE_SUBCLASS = OKL_API.G_MISS_CHAR) THEN

5677: END IF;
5678: IF (x_klev_rec.FUNDING_DATE = OKL_API.G_MISS_DATE) THEN
5679: x_klev_rec.FUNDING_DATE := l_klev_rec.FUNDING_DATE;
5680: END IF;
5681: IF (x_klev_rec.STREAM_TYPE_SUBCLASS = OKL_API.G_MISS_CHAR) THEN
5682: x_klev_rec.STREAM_TYPE_SUBCLASS := l_klev_rec.STREAM_TYPE_SUBCLASS;
5683: END IF;
5684:
5685: --Bug# 4419339 OKLH

Line 5686: IF (x_klev_rec.DATE_FUNDING_EXPECTED = OKL_API.G_MISS_DATE) THEN

5682: x_klev_rec.STREAM_TYPE_SUBCLASS := l_klev_rec.STREAM_TYPE_SUBCLASS;
5683: END IF;
5684:
5685: --Bug# 4419339 OKLH
5686: IF (x_klev_rec.DATE_FUNDING_EXPECTED = OKL_API.G_MISS_DATE) THEN
5687: x_klev_rec.DATE_FUNDING_EXPECTED := l_klev_rec.DATE_FUNDING_EXPECTED;
5688: END IF;
5689:
5690: IF (x_klev_rec.MANUFACTURER_NAME = OKL_API.G_MISS_CHAR) THEN

Line 5690: IF (x_klev_rec.MANUFACTURER_NAME = OKL_API.G_MISS_CHAR) THEN

5686: IF (x_klev_rec.DATE_FUNDING_EXPECTED = OKL_API.G_MISS_DATE) THEN
5687: x_klev_rec.DATE_FUNDING_EXPECTED := l_klev_rec.DATE_FUNDING_EXPECTED;
5688: END IF;
5689:
5690: IF (x_klev_rec.MANUFACTURER_NAME = OKL_API.G_MISS_CHAR) THEN
5691: x_klev_rec.MANUFACTURER_NAME := l_klev_rec.MANUFACTURER_NAME;
5692: END IF;
5693:
5694: IF (x_klev_rec.MODEL_NUMBER = OKL_API.G_MISS_CHAR) THEN

Line 5694: IF (x_klev_rec.MODEL_NUMBER = OKL_API.G_MISS_CHAR) THEN

5690: IF (x_klev_rec.MANUFACTURER_NAME = OKL_API.G_MISS_CHAR) THEN
5691: x_klev_rec.MANUFACTURER_NAME := l_klev_rec.MANUFACTURER_NAME;
5692: END IF;
5693:
5694: IF (x_klev_rec.MODEL_NUMBER = OKL_API.G_MISS_CHAR) THEN
5695: x_klev_rec.MODEL_NUMBER := l_klev_rec.MODEL_NUMBER;
5696: END IF;
5697:
5698: IF (x_klev_rec.DOWN_PAYMENT_RECEIVER_CODE = OKL_API.G_MISS_CHAR) THEN

Line 5698: IF (x_klev_rec.DOWN_PAYMENT_RECEIVER_CODE = OKL_API.G_MISS_CHAR) THEN

5694: IF (x_klev_rec.MODEL_NUMBER = OKL_API.G_MISS_CHAR) THEN
5695: x_klev_rec.MODEL_NUMBER := l_klev_rec.MODEL_NUMBER;
5696: END IF;
5697:
5698: IF (x_klev_rec.DOWN_PAYMENT_RECEIVER_CODE = OKL_API.G_MISS_CHAR) THEN
5699: x_klev_rec.DOWN_PAYMENT_RECEIVER_CODE := l_klev_rec.DOWN_PAYMENT_RECEIVER_CODE;
5700: END IF;
5701:
5702: IF (x_klev_rec.CAPITALIZE_DOWN_PAYMENT_YN = OKL_API.G_MISS_CHAR) THEN

Line 5702: IF (x_klev_rec.CAPITALIZE_DOWN_PAYMENT_YN = OKL_API.G_MISS_CHAR) THEN

5698: IF (x_klev_rec.DOWN_PAYMENT_RECEIVER_CODE = OKL_API.G_MISS_CHAR) THEN
5699: x_klev_rec.DOWN_PAYMENT_RECEIVER_CODE := l_klev_rec.DOWN_PAYMENT_RECEIVER_CODE;
5700: END IF;
5701:
5702: IF (x_klev_rec.CAPITALIZE_DOWN_PAYMENT_YN = OKL_API.G_MISS_CHAR) THEN
5703: x_klev_rec.CAPITALIZE_DOWN_PAYMENT_YN := l_klev_rec.CAPITALIZE_DOWN_PAYMENT_YN;
5704: END IF;
5705:
5706: IF (x_klev_rec.FEE_PURPOSE_CODE = OKL_API.G_MISS_CHAR) THEN

Line 5706: IF (x_klev_rec.FEE_PURPOSE_CODE = OKL_API.G_MISS_CHAR) THEN

5702: IF (x_klev_rec.CAPITALIZE_DOWN_PAYMENT_YN = OKL_API.G_MISS_CHAR) THEN
5703: x_klev_rec.CAPITALIZE_DOWN_PAYMENT_YN := l_klev_rec.CAPITALIZE_DOWN_PAYMENT_YN;
5704: END IF;
5705:
5706: IF (x_klev_rec.FEE_PURPOSE_CODE = OKL_API.G_MISS_CHAR) THEN
5707: x_klev_rec.FEE_PURPOSE_CODE := l_klev_rec.FEE_PURPOSE_CODE;
5708: END IF;
5709:
5710: IF (x_klev_rec.TERMINATION_VALUE = OKL_API.G_MISS_NUM) THEN

Line 5710: IF (x_klev_rec.TERMINATION_VALUE = OKL_API.G_MISS_NUM) THEN

5706: IF (x_klev_rec.FEE_PURPOSE_CODE = OKL_API.G_MISS_CHAR) THEN
5707: x_klev_rec.FEE_PURPOSE_CODE := l_klev_rec.FEE_PURPOSE_CODE;
5708: END IF;
5709:
5710: IF (x_klev_rec.TERMINATION_VALUE = OKL_API.G_MISS_NUM) THEN
5711: x_klev_rec.TERMINATION_VALUE := l_klev_rec.TERMINATION_VALUE;
5712: END IF;
5713:
5714: --Bug# 4631549

Line 5715: IF (x_klev_rec.EXPECTED_ASSET_COST = OKL_API.G_MISS_NUM) THEN

5711: x_klev_rec.TERMINATION_VALUE := l_klev_rec.TERMINATION_VALUE;
5712: END IF;
5713:
5714: --Bug# 4631549
5715: IF (x_klev_rec.EXPECTED_ASSET_COST = OKL_API.G_MISS_NUM) THEN
5716: x_klev_rec.EXPECTED_ASSET_COST := l_klev_rec.EXPECTED_ASSET_COST;
5717: END IF;
5718:
5719: RETURN(l_return_status);

Line 5856: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

5852:
5853: PROCEDURE update_row(
5854:
5855: p_api_version IN NUMBER,
5856: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
5857: x_return_status OUT NOCOPY VARCHAR2,
5858: x_msg_count OUT NOCOPY NUMBER,
5859: x_msg_data OUT NOCOPY VARCHAR2,
5860: p_klev_tbl IN klev_tbl_type,

Line 5933: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

5929:
5930: PROCEDURE delete_row(
5931:
5932: p_api_version IN NUMBER,
5933: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
5934: x_return_status OUT NOCOPY VARCHAR2,
5935: x_msg_count OUT NOCOPY NUMBER,
5936: x_msg_data OUT NOCOPY VARCHAR2,
5937: p_kle_rec IN kle_rec_type) IS

Line 6023: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

6019:
6020: PROCEDURE delete_row(
6021:
6022: p_api_version IN NUMBER,
6023: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
6024: x_return_status OUT NOCOPY VARCHAR2,
6025: x_msg_count OUT NOCOPY NUMBER,
6026: x_msg_data OUT NOCOPY VARCHAR2,
6027: p_klev_rec IN klev_rec_type) IS

Line 6113: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

6109:
6110: PROCEDURE delete_row(
6111:
6112: p_api_version IN NUMBER,
6113: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
6114: x_return_status OUT NOCOPY VARCHAR2,
6115: x_msg_count OUT NOCOPY NUMBER,
6116: x_msg_data OUT NOCOPY VARCHAR2,
6117: p_klev_tbl IN klev_tbl_type) IS