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 347: x_return_status := OKL_API.G_RET_STS_SUCCESS;

343: l_desc_flex_name VARCHAR2(30) := 'OKL_K_LINES_DF';
344: l_segment_partial_name VARCHAR2(30) := 'ATTRIBUTE';
345: Begin
346: -- initialize return status
347: x_return_status := OKL_API.G_RET_STS_SUCCESS;
348:
349: l_segment_values_rec.attribute_category := p_klev_rec.attribute_category;
350: l_segment_values_rec.attribute1 := p_klev_rec.attribute1;
351: l_segment_values_rec.attribute2 := p_klev_rec.attribute2;

Line 368: ,p_init_msg_list => OKL_API.G_FALSE

364: l_segment_values_rec.attribute15 := p_klev_rec.attribute15;
365:
366: okl_dflex_util_pvt.validate_desc_flex
367: (p_api_version => 1.0
368: ,p_init_msg_list => OKL_API.G_FALSE
369: ,x_return_status => x_return_status
370: ,x_msg_count => l_msg_count
371: ,x_msg_data => l_msg_data
372: ,p_appl_short_name => l_appl_short_name

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

374: ,p_segment_partial_name => l_segment_partial_name
375: ,p_segment_values_rec => l_segment_values_rec);
376:
377: -- check return status
378: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
379: RAISE G_EXCEPTION_HALT_VALIDATION;
380: END IF;
381:
382: exception

Line 384: x_return_status := OKL_API.G_RET_STS_ERROR;

380: END IF;
381:
382: exception
383: when G_EXCEPTION_HALT_VALIDATION THEN
384: x_return_status := OKL_API.G_RET_STS_ERROR;
385:
386: when OTHERS then
387: -- store SQL error message on message stack
388: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

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

384: x_return_status := OKL_API.G_RET_STS_ERROR;
385:
386: when OTHERS then
387: -- store SQL error message on message stack
388: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
389: p_msg_name => g_unexpected_error,
390: p_token1 => g_sqlcode_token,
391: p_token1_value => sqlcode,
392: p_token2 => g_sqlerrm_token,

Line 395: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

391: p_token1_value => sqlcode,
392: p_token2 => g_sqlerrm_token,
393: p_token2_value => sqlerrm);
394: -- notify caller of an error as UNEXPETED error
395: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
396: End validate_DFF_attributes;
397: --Bug# 4558486: end
398:
399: -- ************************ END OF HAND CODED VALIDATION *********************************

Line 541: x_return_status := OKL_API.G_RET_STS_SUCCESS;

537: where subb.id = p_subsidy_id;
538:
539: l_exists varchar2(1) default 'N';
540: BEGIN
541: x_return_status := OKL_API.G_RET_STS_SUCCESS;
542: IF (p_klev_rec.subsidy_id = OKL_API.G_MISS_NUM OR
543: p_klev_rec.subsidy_id IS NULL)
544: THEN
545: null; --null values are allowed

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

538:
539: l_exists varchar2(1) default 'N';
540: BEGIN
541: x_return_status := OKL_API.G_RET_STS_SUCCESS;
542: IF (p_klev_rec.subsidy_id = OKL_API.G_MISS_NUM OR
543: p_klev_rec.subsidy_id IS NULL)
544: THEN
545: null; --null values are allowed
546: ELSE

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

552: null;
553: End If;
554: Close l_sub_csr;
555: If l_exists = 'N' then
556: OKL_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'Subsidy Name');
557: x_return_status := OKL_API.G_RET_STS_ERROR;
558: RAISE G_EXCEPTION_HALT_VALIDATION;
559: End If;
560: END IF;

Line 557: x_return_status := OKL_API.G_RET_STS_ERROR;

553: End If;
554: Close l_sub_csr;
555: If l_exists = 'N' then
556: OKL_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'Subsidy Name');
557: x_return_status := OKL_API.G_RET_STS_ERROR;
558: RAISE G_EXCEPTION_HALT_VALIDATION;
559: End If;
560: END IF;
561: EXCEPTION

Line 565: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

561: EXCEPTION
562: WHEN G_EXCEPTION_HALT_VALIDATION THEN
563: null;
564: WHEN OTHERS THEN
565: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
566: ,p_msg_name => G_UNEXPECTED_ERROR
567: ,p_token1 => G_SQLCODE_TOKEN
568: ,p_token1_value => SQLCODE
569: ,p_token2 => G_SQLERRM_TOKEN

Line 571: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

567: ,p_token1 => G_SQLCODE_TOKEN
568: ,p_token1_value => SQLCODE
569: ,p_token2 => G_SQLERRM_TOKEN
570: ,p_token2_value => SQLERRM);
571: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
572: end validate_subsidy_id;
573: ---------------------------------------------
574: -- Validate_Attributes for: OKL_K_LINES_V --
575: ---------------------------------------------

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

702: --Bug# 4558486
703: -- ***
704: -- DFF Attributes
705: -- ***
706: if ( NVL(p_klev_rec.validate_dff_yn,OKL_API.G_MISS_CHAR) = 'Y') then
707: validate_DFF_attributes
708: (x_return_status => l_return_status,
709: p_klev_rec => p_klev_rec);
710:

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

2170: l_klev_rec.FEE_TYPE := NULL;
2171: END IF;
2172: --Bug# 3143522: 11.5.10
2173: --subsidy
2174: IF (l_klev_rec.SUBSIDY_ID = OKL_API.G_MISS_NUM) THEN
2175: l_klev_rec.SUBSIDY_ID := NULL;
2176: END IF;
2177: --IF (l_klev_rec.SUBSIDIZED_OEC = OKL_API.G_MISS_NUM) THEN
2178: --l_klev_rec.SUBSIDIZED_OEC := NULL;

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

2173: --subsidy
2174: IF (l_klev_rec.SUBSIDY_ID = OKL_API.G_MISS_NUM) THEN
2175: l_klev_rec.SUBSIDY_ID := NULL;
2176: END IF;
2177: --IF (l_klev_rec.SUBSIDIZED_OEC = OKL_API.G_MISS_NUM) THEN
2178: --l_klev_rec.SUBSIDIZED_OEC := NULL;
2179: --END IF;
2180: --IF (l_klev_rec.SUBSIDIZED_CAP_AMOUNT = OKL_API.G_MISS_NUM) THEN
2181: --l_klev_rec.SUBSIDIZED_CAP_AMOUNT := NULL;

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

2176: END IF;
2177: --IF (l_klev_rec.SUBSIDIZED_OEC = OKL_API.G_MISS_NUM) THEN
2178: --l_klev_rec.SUBSIDIZED_OEC := NULL;
2179: --END IF;
2180: --IF (l_klev_rec.SUBSIDIZED_CAP_AMOUNT = OKL_API.G_MISS_NUM) THEN
2181: --l_klev_rec.SUBSIDIZED_CAP_AMOUNT := NULL;
2182: --END IF;
2183: IF (l_klev_rec.SUBSIDY_OVERRIDE_AMOUNT = OKL_API.G_MISS_NUM) THEN
2184: l_klev_rec.SUBSIDY_OVERRIDE_AMOUNT := NULL;

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

2179: --END IF;
2180: --IF (l_klev_rec.SUBSIDIZED_CAP_AMOUNT = OKL_API.G_MISS_NUM) THEN
2181: --l_klev_rec.SUBSIDIZED_CAP_AMOUNT := NULL;
2182: --END IF;
2183: IF (l_klev_rec.SUBSIDY_OVERRIDE_AMOUNT = OKL_API.G_MISS_NUM) THEN
2184: l_klev_rec.SUBSIDY_OVERRIDE_AMOUNT := NULL;
2185: END IF;
2186: --financed fee
2187: IF (l_klev_rec.PRE_TAX_YIELD = OKL_API.G_MISS_NUM) THEN

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

2183: IF (l_klev_rec.SUBSIDY_OVERRIDE_AMOUNT = OKL_API.G_MISS_NUM) THEN
2184: l_klev_rec.SUBSIDY_OVERRIDE_AMOUNT := NULL;
2185: END IF;
2186: --financed fee
2187: IF (l_klev_rec.PRE_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
2188: l_klev_rec.PRE_TAX_YIELD := NULL;
2189: END IF;
2190: IF (l_klev_rec.AFTER_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
2191: l_klev_rec.AFTER_TAX_YIELD := NULL;

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

2186: --financed fee
2187: IF (l_klev_rec.PRE_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
2188: l_klev_rec.PRE_TAX_YIELD := NULL;
2189: END IF;
2190: IF (l_klev_rec.AFTER_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
2191: l_klev_rec.AFTER_TAX_YIELD := NULL;
2192: END IF;
2193: IF (l_klev_rec.IMPLICIT_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
2194: l_klev_rec.IMPLICIT_INTEREST_RATE := NULL;

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

2189: END IF;
2190: IF (l_klev_rec.AFTER_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
2191: l_klev_rec.AFTER_TAX_YIELD := NULL;
2192: END IF;
2193: IF (l_klev_rec.IMPLICIT_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
2194: l_klev_rec.IMPLICIT_INTEREST_RATE := NULL;
2195: END IF;
2196: IF (l_klev_rec.IMPLICIT_NON_IDC_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
2197: l_klev_rec.IMPLICIT_NON_IDC_INTEREST_RATE := NULL;

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

2192: END IF;
2193: IF (l_klev_rec.IMPLICIT_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
2194: l_klev_rec.IMPLICIT_INTEREST_RATE := NULL;
2195: END IF;
2196: IF (l_klev_rec.IMPLICIT_NON_IDC_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
2197: l_klev_rec.IMPLICIT_NON_IDC_INTEREST_RATE := NULL;
2198: END IF;
2199: IF (l_klev_rec.PRE_TAX_IRR = OKL_API.G_MISS_NUM) THEN
2200: l_klev_rec.PRE_TAX_IRR := NULL;

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

2195: END IF;
2196: IF (l_klev_rec.IMPLICIT_NON_IDC_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
2197: l_klev_rec.IMPLICIT_NON_IDC_INTEREST_RATE := NULL;
2198: END IF;
2199: IF (l_klev_rec.PRE_TAX_IRR = OKL_API.G_MISS_NUM) THEN
2200: l_klev_rec.PRE_TAX_IRR := NULL;
2201: END IF;
2202: IF (l_klev_rec.AFTER_TAX_IRR = OKL_API.G_MISS_NUM) THEN
2203: l_klev_rec.AFTER_TAX_IRR := NULL;

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

2198: END IF;
2199: IF (l_klev_rec.PRE_TAX_IRR = OKL_API.G_MISS_NUM) THEN
2200: l_klev_rec.PRE_TAX_IRR := NULL;
2201: END IF;
2202: IF (l_klev_rec.AFTER_TAX_IRR = OKL_API.G_MISS_NUM) THEN
2203: l_klev_rec.AFTER_TAX_IRR := NULL;
2204: END IF;
2205: --quote
2206: IF (l_klev_rec.SUB_PRE_TAX_YIELD = OKL_API.G_MISS_NUM) THEN

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

2202: IF (l_klev_rec.AFTER_TAX_IRR = OKL_API.G_MISS_NUM) THEN
2203: l_klev_rec.AFTER_TAX_IRR := NULL;
2204: END IF;
2205: --quote
2206: IF (l_klev_rec.SUB_PRE_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
2207: l_klev_rec.SUB_PRE_TAX_YIELD := NULL;
2208: END IF;
2209: IF (l_klev_rec.SUB_AFTER_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
2210: l_klev_rec.SUB_AFTER_TAX_YIELD := NULL;

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

2205: --quote
2206: IF (l_klev_rec.SUB_PRE_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
2207: l_klev_rec.SUB_PRE_TAX_YIELD := NULL;
2208: END IF;
2209: IF (l_klev_rec.SUB_AFTER_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
2210: l_klev_rec.SUB_AFTER_TAX_YIELD := NULL;
2211: END IF;
2212: IF (l_klev_rec.SUB_IMPL_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
2213: l_klev_rec.SUB_IMPL_INTEREST_RATE := NULL;

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

2208: END IF;
2209: IF (l_klev_rec.SUB_AFTER_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
2210: l_klev_rec.SUB_AFTER_TAX_YIELD := NULL;
2211: END IF;
2212: IF (l_klev_rec.SUB_IMPL_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
2213: l_klev_rec.SUB_IMPL_INTEREST_RATE := NULL;
2214: END IF;
2215: IF (l_klev_rec.SUB_IMPL_NON_IDC_INT_RATE = OKL_API.G_MISS_NUM) THEN
2216: l_klev_rec.SUB_IMPL_NON_IDC_INT_RATE := NULL;

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

2211: END IF;
2212: IF (l_klev_rec.SUB_IMPL_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
2213: l_klev_rec.SUB_IMPL_INTEREST_RATE := NULL;
2214: END IF;
2215: IF (l_klev_rec.SUB_IMPL_NON_IDC_INT_RATE = OKL_API.G_MISS_NUM) THEN
2216: l_klev_rec.SUB_IMPL_NON_IDC_INT_RATE := NULL;
2217: END IF;
2218: IF (l_klev_rec.SUB_PRE_TAX_IRR = OKL_API.G_MISS_NUM) THEN
2219: l_klev_rec.SUB_PRE_TAX_IRR := NULL;

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

2214: END IF;
2215: IF (l_klev_rec.SUB_IMPL_NON_IDC_INT_RATE = OKL_API.G_MISS_NUM) THEN
2216: l_klev_rec.SUB_IMPL_NON_IDC_INT_RATE := NULL;
2217: END IF;
2218: IF (l_klev_rec.SUB_PRE_TAX_IRR = OKL_API.G_MISS_NUM) THEN
2219: l_klev_rec.SUB_PRE_TAX_IRR := NULL;
2220: END IF;
2221: IF (l_klev_rec.SUB_AFTER_TAX_IRR = OKL_API.G_MISS_NUM) THEN
2222: l_klev_rec.SUB_AFTER_TAX_IRR := NULL;

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

2217: END IF;
2218: IF (l_klev_rec.SUB_PRE_TAX_IRR = OKL_API.G_MISS_NUM) THEN
2219: l_klev_rec.SUB_PRE_TAX_IRR := NULL;
2220: END IF;
2221: IF (l_klev_rec.SUB_AFTER_TAX_IRR = OKL_API.G_MISS_NUM) THEN
2222: l_klev_rec.SUB_AFTER_TAX_IRR := NULL;
2223: END IF;
2224: --Bug# 2994971 :
2225: IF (l_klev_rec.ITEM_INSURANCE_CATEGORY = OKL_API.G_MISS_NUM) THEN

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

2221: IF (l_klev_rec.SUB_AFTER_TAX_IRR = OKL_API.G_MISS_NUM) THEN
2222: l_klev_rec.SUB_AFTER_TAX_IRR := NULL;
2223: END IF;
2224: --Bug# 2994971 :
2225: IF (l_klev_rec.ITEM_INSURANCE_CATEGORY = OKL_API.G_MISS_NUM) THEN
2226: l_klev_rec.ITEM_INSURANCE_CATEGORY := NULL;
2227: END IF;
2228: --Bug# 3973640 11.5.10+
2229: IF (l_klev_rec.QTE_ID = OKL_API.G_MISS_NUM) THEN

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

2225: IF (l_klev_rec.ITEM_INSURANCE_CATEGORY = OKL_API.G_MISS_NUM) THEN
2226: l_klev_rec.ITEM_INSURANCE_CATEGORY := NULL;
2227: END IF;
2228: --Bug# 3973640 11.5.10+
2229: IF (l_klev_rec.QTE_ID = OKL_API.G_MISS_NUM) THEN
2230: l_klev_rec.QTE_ID := NULL;
2231: END IF;
2232: IF (l_klev_rec.FUNDING_DATE = OKL_API.G_MISS_DATE) THEN
2233: l_klev_rec.FUNDING_DATE := NULL;

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

2228: --Bug# 3973640 11.5.10+
2229: IF (l_klev_rec.QTE_ID = OKL_API.G_MISS_NUM) THEN
2230: l_klev_rec.QTE_ID := NULL;
2231: END IF;
2232: IF (l_klev_rec.FUNDING_DATE = OKL_API.G_MISS_DATE) THEN
2233: l_klev_rec.FUNDING_DATE := NULL;
2234: END IF;
2235: IF (l_klev_rec.STREAM_TYPE_SUBCLASS = OKL_API.G_MISS_CHAR) THEN
2236: l_klev_rec.STREAM_TYPE_SUBCLASS := NULL;

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

2231: END IF;
2232: IF (l_klev_rec.FUNDING_DATE = OKL_API.G_MISS_DATE) THEN
2233: l_klev_rec.FUNDING_DATE := NULL;
2234: END IF;
2235: IF (l_klev_rec.STREAM_TYPE_SUBCLASS = OKL_API.G_MISS_CHAR) THEN
2236: l_klev_rec.STREAM_TYPE_SUBCLASS := NULL;
2237: END IF;
2238:
2239: --Bug# 4419339 OKLH

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

2236: l_klev_rec.STREAM_TYPE_SUBCLASS := NULL;
2237: END IF;
2238:
2239: --Bug# 4419339 OKLH
2240: IF (l_klev_rec.DATE_FUNDING_EXPECTED = OKL_API.G_MISS_DATE) THEN
2241: l_klev_rec.DATE_FUNDING_EXPECTED := NULL;
2242: END IF;
2243:
2244: IF (l_klev_rec.MANUFACTURER_NAME = OKL_API.G_MISS_CHAR) THEN

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

2240: IF (l_klev_rec.DATE_FUNDING_EXPECTED = OKL_API.G_MISS_DATE) THEN
2241: l_klev_rec.DATE_FUNDING_EXPECTED := NULL;
2242: END IF;
2243:
2244: IF (l_klev_rec.MANUFACTURER_NAME = OKL_API.G_MISS_CHAR) THEN
2245: l_klev_rec.MANUFACTURER_NAME := NULL;
2246: END IF;
2247:
2248: IF (l_klev_rec.MODEL_NUMBER = OKL_API.G_MISS_CHAR) THEN

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

2244: IF (l_klev_rec.MANUFACTURER_NAME = OKL_API.G_MISS_CHAR) THEN
2245: l_klev_rec.MANUFACTURER_NAME := NULL;
2246: END IF;
2247:
2248: IF (l_klev_rec.MODEL_NUMBER = OKL_API.G_MISS_CHAR) THEN
2249: l_klev_rec.MODEL_NUMBER := NULL;
2250: END IF;
2251:
2252: IF (l_klev_rec.DOWN_PAYMENT_RECEIVER_CODE = OKL_API.G_MISS_CHAR) THEN

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

2248: IF (l_klev_rec.MODEL_NUMBER = OKL_API.G_MISS_CHAR) THEN
2249: l_klev_rec.MODEL_NUMBER := NULL;
2250: END IF;
2251:
2252: IF (l_klev_rec.DOWN_PAYMENT_RECEIVER_CODE = OKL_API.G_MISS_CHAR) THEN
2253: l_klev_rec.DOWN_PAYMENT_RECEIVER_CODE := NULL;
2254: END IF;
2255:
2256: IF (l_klev_rec.CAPITALIZE_DOWN_PAYMENT_YN = OKL_API.G_MISS_CHAR) THEN

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

2252: IF (l_klev_rec.DOWN_PAYMENT_RECEIVER_CODE = OKL_API.G_MISS_CHAR) THEN
2253: l_klev_rec.DOWN_PAYMENT_RECEIVER_CODE := NULL;
2254: END IF;
2255:
2256: IF (l_klev_rec.CAPITALIZE_DOWN_PAYMENT_YN = OKL_API.G_MISS_CHAR) THEN
2257: l_klev_rec.CAPITALIZE_DOWN_PAYMENT_YN := NULL;
2258: END IF;
2259: --Bug#4373029
2260: IF (l_klev_rec.FEE_PURPOSE_CODE = OKL_API.G_MISS_CHAR) THEN

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

2256: IF (l_klev_rec.CAPITALIZE_DOWN_PAYMENT_YN = OKL_API.G_MISS_CHAR) THEN
2257: l_klev_rec.CAPITALIZE_DOWN_PAYMENT_YN := NULL;
2258: END IF;
2259: --Bug#4373029
2260: IF (l_klev_rec.FEE_PURPOSE_CODE = OKL_API.G_MISS_CHAR) THEN
2261: l_klev_rec.FEE_PURPOSE_CODE := NULL;
2262: END IF;
2263:
2264: IF (l_klev_rec.TERMINATION_VALUE = OKL_API.G_MISS_NUM) THEN

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

2260: IF (l_klev_rec.FEE_PURPOSE_CODE = OKL_API.G_MISS_CHAR) THEN
2261: l_klev_rec.FEE_PURPOSE_CODE := NULL;
2262: END IF;
2263:
2264: IF (l_klev_rec.TERMINATION_VALUE = OKL_API.G_MISS_NUM) THEN
2265: l_klev_rec.TERMINATION_VALUE := NULL;
2266: END IF;
2267:
2268: --Bug# 4631549

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

2265: l_klev_rec.TERMINATION_VALUE := NULL;
2266: END IF;
2267:
2268: --Bug# 4631549
2269: IF (l_klev_rec.EXPECTED_ASSET_COST = OKL_API.G_MISS_NUM) THEN
2270: l_klev_rec.EXPECTED_ASSET_COST := NULL;
2271: END IF;
2272:
2273: IF (l_klev_rec.ORIG_CONTRACT_LINE_ID = OKL_API.G_MISS_NUM) THEN

Line 2273: IF (l_klev_rec.ORIG_CONTRACT_LINE_ID = OKL_API.G_MISS_NUM) THEN

2269: IF (l_klev_rec.EXPECTED_ASSET_COST = OKL_API.G_MISS_NUM) THEN
2270: l_klev_rec.EXPECTED_ASSET_COST := NULL;
2271: END IF;
2272:
2273: IF (l_klev_rec.ORIG_CONTRACT_LINE_ID = OKL_API.G_MISS_NUM) THEN
2274: l_klev_rec.ORIG_CONTRACT_LINE_ID := NULL;
2275: END IF;
2276:
2277: --Added by jjuneja

Line 2278: IF (l_klev_rec.ORIGINATION_INCOME = OKL_API.G_MISS_NUM) THEN

2274: l_klev_rec.ORIG_CONTRACT_LINE_ID := NULL;
2275: END IF;
2276:
2277: --Added by jjuneja
2278: IF (l_klev_rec.ORIGINATION_INCOME = OKL_API.G_MISS_NUM) THEN
2279: l_klev_rec.ORIGINATION_INCOME := NULL;
2280: END IF;
2281: --end of addition by jjuneja
2282:

Line 2284: IF (l_klev_rec.AMOUNT_BALANCE_LEGACY = OKL_API.G_MISS_NUM) THEN

2280: END IF;
2281: --end of addition by jjuneja
2282:
2283: --Bug# 16344245
2284: IF (l_klev_rec.AMOUNT_BALANCE_LEGACY = OKL_API.G_MISS_NUM) THEN
2285: l_klev_rec.AMOUNT_BALANCE_LEGACY := NULL;
2286: END IF;
2287:
2288: IF (l_klev_rec.DT_EFFECTIVE_BALANCE_LEGACY = OKL_API.G_MISS_DATE) THEN

Line 2288: IF (l_klev_rec.DT_EFFECTIVE_BALANCE_LEGACY = OKL_API.G_MISS_DATE) THEN

2284: IF (l_klev_rec.AMOUNT_BALANCE_LEGACY = OKL_API.G_MISS_NUM) THEN
2285: l_klev_rec.AMOUNT_BALANCE_LEGACY := NULL;
2286: END IF;
2287:
2288: IF (l_klev_rec.DT_EFFECTIVE_BALANCE_LEGACY = OKL_API.G_MISS_DATE) THEN
2289: l_klev_rec.DT_EFFECTIVE_BALANCE_LEGACY := NULL;
2290: END IF;
2291:
2292: RETURN(l_klev_rec);

Line 3080: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

3076:
3077: PROCEDURE validate_row(
3078:
3079: p_api_version IN NUMBER,
3080: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
3081: x_return_status OUT NOCOPY VARCHAR2,
3082: x_msg_count OUT NOCOPY NUMBER,
3083: x_msg_data OUT NOCOPY VARCHAR2,
3084: p_klev_rec IN klev_rec_type) IS

Line 3168: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

3164:
3165: PROCEDURE validate_row(
3166:
3167: p_api_version IN NUMBER,
3168: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
3169: x_return_status OUT NOCOPY VARCHAR2,
3170: x_msg_count OUT NOCOPY NUMBER,
3171: x_msg_data OUT NOCOPY VARCHAR2,
3172: p_klev_tbl IN klev_tbl_type) IS

Line 3243: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

3239:
3240: PROCEDURE insert_row(
3241:
3242: p_api_version IN NUMBER,
3243: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
3244: x_return_status OUT NOCOPY VARCHAR2,
3245: x_msg_count OUT NOCOPY NUMBER,
3246: x_msg_data OUT NOCOPY VARCHAR2,
3247: p_okl_k_lines_h_rec IN okl_k_lines_h_rec_type,

Line 3633: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

3629:
3630: PROCEDURE insert_row(
3631:
3632: p_api_version IN NUMBER,
3633: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
3634: x_return_status OUT NOCOPY VARCHAR2,
3635: x_msg_count OUT NOCOPY NUMBER,
3636: x_msg_data OUT NOCOPY VARCHAR2,
3637: p_kle_rec IN kle_rec_type,

Line 4030: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

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

Line 4195: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

4191:
4192: PROCEDURE insert_row(
4193:
4194: p_api_version IN NUMBER,
4195: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
4196: x_return_status OUT NOCOPY VARCHAR2,
4197: x_msg_count OUT NOCOPY NUMBER,
4198: x_msg_data OUT NOCOPY VARCHAR2,
4199: p_klev_tbl IN klev_tbl_type,

Line 4271: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

4267:
4268: PROCEDURE lock_row(
4269:
4270: p_api_version IN NUMBER,
4271: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
4272: x_return_status OUT NOCOPY VARCHAR2,
4273: x_msg_count OUT NOCOPY NUMBER,
4274: x_msg_data OUT NOCOPY VARCHAR2,
4275: p_kle_rec IN kle_rec_type) IS

Line 4385: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

4381:
4382: PROCEDURE lock_row(
4383:
4384: p_api_version IN NUMBER,
4385: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
4386: x_return_status OUT NOCOPY VARCHAR2,
4387: x_msg_count OUT NOCOPY NUMBER,
4388: x_msg_data OUT NOCOPY VARCHAR2,
4389: p_klev_rec IN klev_rec_type) IS

Line 4474: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

4470:
4471: PROCEDURE lock_row(
4472:
4473: p_api_version IN NUMBER,
4474: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
4475: x_return_status OUT NOCOPY VARCHAR2,
4476: x_msg_count OUT NOCOPY NUMBER,
4477: x_msg_data OUT NOCOPY VARCHAR2,
4478: p_klev_tbl IN klev_tbl_type) IS

Line 4548: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

4544:
4545: PROCEDURE update_row(
4546:
4547: p_api_version IN NUMBER,
4548: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
4549: x_return_status OUT NOCOPY VARCHAR2,
4550: x_msg_count OUT NOCOPY NUMBER,
4551: x_msg_data OUT NOCOPY VARCHAR2,
4552: p_kle_rec IN kle_rec_type,

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

4983: END IF;
4984:
4985: --Bug# 3143522: 11.5.10
4986: --subsidy
4987: IF (x_kle_rec.SUBSIDY_ID = OKL_API.G_MISS_NUM) THEN
4988: x_kle_rec.SUBSIDY_ID := l_kle_rec.SUBSIDY_ID;
4989: END IF;
4990: --IF (x_kle_rec.SUBSIDIZED_OEC = OKL_API.G_MISS_NUM) THEN
4991: --x_kle_rec.SUBSIDIZED_OEC := l_kle_rec.SUBSIDIZED_OEC;

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

4986: --subsidy
4987: IF (x_kle_rec.SUBSIDY_ID = OKL_API.G_MISS_NUM) THEN
4988: x_kle_rec.SUBSIDY_ID := l_kle_rec.SUBSIDY_ID;
4989: END IF;
4990: --IF (x_kle_rec.SUBSIDIZED_OEC = OKL_API.G_MISS_NUM) THEN
4991: --x_kle_rec.SUBSIDIZED_OEC := l_kle_rec.SUBSIDIZED_OEC;
4992: --END IF;
4993: --IF (x_kle_rec.SUBSIDIZED_CAP_AMOUNT = OKL_API.G_MISS_NUM) THEN
4994: --x_kle_rec.SUBSIDIZED_CAP_AMOUNT := l_kle_rec.SUBSIDIZED_CAP_AMOUNT;

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

4989: END IF;
4990: --IF (x_kle_rec.SUBSIDIZED_OEC = OKL_API.G_MISS_NUM) THEN
4991: --x_kle_rec.SUBSIDIZED_OEC := l_kle_rec.SUBSIDIZED_OEC;
4992: --END IF;
4993: --IF (x_kle_rec.SUBSIDIZED_CAP_AMOUNT = OKL_API.G_MISS_NUM) THEN
4994: --x_kle_rec.SUBSIDIZED_CAP_AMOUNT := l_kle_rec.SUBSIDIZED_CAP_AMOUNT;
4995: --END IF;
4996: IF (x_kle_rec.SUBSIDY_OVERRIDE_AMOUNT = OKL_API.G_MISS_NUM) THEN
4997: x_kle_rec.SUBSIDY_OVERRIDE_AMOUNT := l_kle_rec.SUBSIDY_OVERRIDE_AMOUNT;

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

4992: --END IF;
4993: --IF (x_kle_rec.SUBSIDIZED_CAP_AMOUNT = OKL_API.G_MISS_NUM) THEN
4994: --x_kle_rec.SUBSIDIZED_CAP_AMOUNT := l_kle_rec.SUBSIDIZED_CAP_AMOUNT;
4995: --END IF;
4996: IF (x_kle_rec.SUBSIDY_OVERRIDE_AMOUNT = OKL_API.G_MISS_NUM) THEN
4997: x_kle_rec.SUBSIDY_OVERRIDE_AMOUNT := l_kle_rec.SUBSIDY_OVERRIDE_AMOUNT;
4998: END IF;
4999: --financed fee
5000: IF (x_kle_rec.PRE_TAX_YIELD = OKL_API.G_MISS_NUM) THEN

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

4996: IF (x_kle_rec.SUBSIDY_OVERRIDE_AMOUNT = OKL_API.G_MISS_NUM) THEN
4997: x_kle_rec.SUBSIDY_OVERRIDE_AMOUNT := l_kle_rec.SUBSIDY_OVERRIDE_AMOUNT;
4998: END IF;
4999: --financed fee
5000: IF (x_kle_rec.PRE_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
5001: x_kle_rec.PRE_TAX_YIELD := l_kle_rec.PRE_TAX_YIELD;
5002: END IF;
5003: IF (x_kle_rec.AFTER_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
5004: x_kle_rec.AFTER_TAX_YIELD := l_kle_rec.AFTER_TAX_YIELD;

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

4999: --financed fee
5000: IF (x_kle_rec.PRE_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
5001: x_kle_rec.PRE_TAX_YIELD := l_kle_rec.PRE_TAX_YIELD;
5002: END IF;
5003: IF (x_kle_rec.AFTER_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
5004: x_kle_rec.AFTER_TAX_YIELD := l_kle_rec.AFTER_TAX_YIELD;
5005: END IF;
5006: IF (x_kle_rec.IMPLICIT_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
5007: x_kle_rec.IMPLICIT_INTEREST_RATE := l_kle_rec.IMPLICIT_INTEREST_RATE;

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

5002: END IF;
5003: IF (x_kle_rec.AFTER_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
5004: x_kle_rec.AFTER_TAX_YIELD := l_kle_rec.AFTER_TAX_YIELD;
5005: END IF;
5006: IF (x_kle_rec.IMPLICIT_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
5007: x_kle_rec.IMPLICIT_INTEREST_RATE := l_kle_rec.IMPLICIT_INTEREST_RATE;
5008: END IF;
5009: IF (x_kle_rec.IMPLICIT_NON_IDC_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
5010: x_kle_rec.IMPLICIT_NON_IDC_INTEREST_RATE := l_kle_rec.IMPLICIT_NON_IDC_INTEREST_RATE;

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

5005: END IF;
5006: IF (x_kle_rec.IMPLICIT_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
5007: x_kle_rec.IMPLICIT_INTEREST_RATE := l_kle_rec.IMPLICIT_INTEREST_RATE;
5008: END IF;
5009: IF (x_kle_rec.IMPLICIT_NON_IDC_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
5010: x_kle_rec.IMPLICIT_NON_IDC_INTEREST_RATE := l_kle_rec.IMPLICIT_NON_IDC_INTEREST_RATE;
5011: END IF;
5012: IF (x_kle_rec.PRE_TAX_IRR = OKL_API.G_MISS_NUM) THEN
5013: x_kle_rec.PRE_TAX_IRR := l_kle_rec.PRE_TAX_IRR;

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

5008: END IF;
5009: IF (x_kle_rec.IMPLICIT_NON_IDC_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
5010: x_kle_rec.IMPLICIT_NON_IDC_INTEREST_RATE := l_kle_rec.IMPLICIT_NON_IDC_INTEREST_RATE;
5011: END IF;
5012: IF (x_kle_rec.PRE_TAX_IRR = OKL_API.G_MISS_NUM) THEN
5013: x_kle_rec.PRE_TAX_IRR := l_kle_rec.PRE_TAX_IRR;
5014: END IF;
5015: IF (x_kle_rec.AFTER_TAX_IRR = OKL_API.G_MISS_NUM) THEN
5016: x_kle_rec.AFTER_TAX_IRR := l_kle_rec.AFTER_TAX_IRR;

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

5011: END IF;
5012: IF (x_kle_rec.PRE_TAX_IRR = OKL_API.G_MISS_NUM) THEN
5013: x_kle_rec.PRE_TAX_IRR := l_kle_rec.PRE_TAX_IRR;
5014: END IF;
5015: IF (x_kle_rec.AFTER_TAX_IRR = OKL_API.G_MISS_NUM) THEN
5016: x_kle_rec.AFTER_TAX_IRR := l_kle_rec.AFTER_TAX_IRR;
5017: END IF;
5018: --quote
5019: IF (x_kle_rec.SUB_PRE_TAX_YIELD = OKL_API.G_MISS_NUM) THEN

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

5015: IF (x_kle_rec.AFTER_TAX_IRR = OKL_API.G_MISS_NUM) THEN
5016: x_kle_rec.AFTER_TAX_IRR := l_kle_rec.AFTER_TAX_IRR;
5017: END IF;
5018: --quote
5019: IF (x_kle_rec.SUB_PRE_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
5020: x_kle_rec.SUB_PRE_TAX_YIELD := l_kle_rec.SUB_PRE_TAX_YIELD;
5021: END IF;
5022: IF (x_kle_rec.SUB_AFTER_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
5023: x_kle_rec.SUB_AFTER_TAX_YIELD := l_kle_rec.SUB_AFTER_TAX_YIELD;

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

5018: --quote
5019: IF (x_kle_rec.SUB_PRE_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
5020: x_kle_rec.SUB_PRE_TAX_YIELD := l_kle_rec.SUB_PRE_TAX_YIELD;
5021: END IF;
5022: IF (x_kle_rec.SUB_AFTER_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
5023: x_kle_rec.SUB_AFTER_TAX_YIELD := l_kle_rec.SUB_AFTER_TAX_YIELD;
5024: END IF;
5025: IF (x_kle_rec.SUB_IMPL_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
5026: x_kle_rec.SUB_IMPL_INTEREST_RATE := l_kle_rec.SUB_IMPL_INTEREST_RATE;

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

5021: END IF;
5022: IF (x_kle_rec.SUB_AFTER_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
5023: x_kle_rec.SUB_AFTER_TAX_YIELD := l_kle_rec.SUB_AFTER_TAX_YIELD;
5024: END IF;
5025: IF (x_kle_rec.SUB_IMPL_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
5026: x_kle_rec.SUB_IMPL_INTEREST_RATE := l_kle_rec.SUB_IMPL_INTEREST_RATE;
5027: END IF;
5028: IF (x_kle_rec.SUB_IMPL_NON_IDC_INT_RATE = OKL_API.G_MISS_NUM) THEN
5029: x_kle_rec.SUB_IMPL_NON_IDC_INT_RATE := l_kle_rec.SUB_IMPL_NON_IDC_INT_RATE;

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

5024: END IF;
5025: IF (x_kle_rec.SUB_IMPL_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
5026: x_kle_rec.SUB_IMPL_INTEREST_RATE := l_kle_rec.SUB_IMPL_INTEREST_RATE;
5027: END IF;
5028: IF (x_kle_rec.SUB_IMPL_NON_IDC_INT_RATE = OKL_API.G_MISS_NUM) THEN
5029: x_kle_rec.SUB_IMPL_NON_IDC_INT_RATE := l_kle_rec.SUB_IMPL_NON_IDC_INT_RATE;
5030: END IF;
5031: IF (x_kle_rec.SUB_PRE_TAX_IRR = OKL_API.G_MISS_NUM) THEN
5032: x_kle_rec.SUB_PRE_TAX_IRR := l_kle_rec.SUB_PRE_TAX_IRR;

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

5027: END IF;
5028: IF (x_kle_rec.SUB_IMPL_NON_IDC_INT_RATE = OKL_API.G_MISS_NUM) THEN
5029: x_kle_rec.SUB_IMPL_NON_IDC_INT_RATE := l_kle_rec.SUB_IMPL_NON_IDC_INT_RATE;
5030: END IF;
5031: IF (x_kle_rec.SUB_PRE_TAX_IRR = OKL_API.G_MISS_NUM) THEN
5032: x_kle_rec.SUB_PRE_TAX_IRR := l_kle_rec.SUB_PRE_TAX_IRR;
5033: END IF;
5034: IF (x_kle_rec.SUB_AFTER_TAX_IRR = OKL_API.G_MISS_NUM) THEN
5035: x_kle_rec.SUB_AFTER_TAX_IRR := l_kle_rec.SUB_AFTER_TAX_IRR;

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

5030: END IF;
5031: IF (x_kle_rec.SUB_PRE_TAX_IRR = OKL_API.G_MISS_NUM) THEN
5032: x_kle_rec.SUB_PRE_TAX_IRR := l_kle_rec.SUB_PRE_TAX_IRR;
5033: END IF;
5034: IF (x_kle_rec.SUB_AFTER_TAX_IRR = OKL_API.G_MISS_NUM) THEN
5035: x_kle_rec.SUB_AFTER_TAX_IRR := l_kle_rec.SUB_AFTER_TAX_IRR;
5036: END IF;
5037: --Bug# 2994971
5038: IF (x_kle_rec.ITEM_INSURANCE_CATEGORY = OKL_API.G_MISS_NUM) THEN

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

5034: IF (x_kle_rec.SUB_AFTER_TAX_IRR = OKL_API.G_MISS_NUM) THEN
5035: x_kle_rec.SUB_AFTER_TAX_IRR := l_kle_rec.SUB_AFTER_TAX_IRR;
5036: END IF;
5037: --Bug# 2994971
5038: IF (x_kle_rec.ITEM_INSURANCE_CATEGORY = OKL_API.G_MISS_NUM) THEN
5039: x_kle_rec.ITEM_INSURANCE_CATEGORY := l_kle_rec.ITEM_INSURANCE_CATEGORY;
5040: END IF;
5041: --Bug# 3973640 :11.5.10+
5042: IF (x_kle_rec.QTE_ID = OKL_API.G_MISS_NUM) THEN

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

5038: IF (x_kle_rec.ITEM_INSURANCE_CATEGORY = OKL_API.G_MISS_NUM) THEN
5039: x_kle_rec.ITEM_INSURANCE_CATEGORY := l_kle_rec.ITEM_INSURANCE_CATEGORY;
5040: END IF;
5041: --Bug# 3973640 :11.5.10+
5042: IF (x_kle_rec.QTE_ID = OKL_API.G_MISS_NUM) THEN
5043: x_kle_rec.QTE_ID := l_kle_rec.QTE_ID;
5044: END IF;
5045: IF (x_kle_rec.FUNDING_DATE = OKL_API.G_MISS_DATE) THEN
5046: x_kle_rec.FUNDING_DATE := l_kle_rec.FUNDING_DATE;

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

5041: --Bug# 3973640 :11.5.10+
5042: IF (x_kle_rec.QTE_ID = OKL_API.G_MISS_NUM) THEN
5043: x_kle_rec.QTE_ID := l_kle_rec.QTE_ID;
5044: END IF;
5045: IF (x_kle_rec.FUNDING_DATE = OKL_API.G_MISS_DATE) THEN
5046: x_kle_rec.FUNDING_DATE := l_kle_rec.FUNDING_DATE;
5047: END IF;
5048: IF (x_kle_rec.STREAM_TYPE_SUBCLASS = OKL_API.G_MISS_CHAR) THEN
5049: x_kle_rec.STREAM_TYPE_SUBCLASS := l_kle_rec.STREAM_TYPE_SUBCLASS;

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

5044: END IF;
5045: IF (x_kle_rec.FUNDING_DATE = OKL_API.G_MISS_DATE) THEN
5046: x_kle_rec.FUNDING_DATE := l_kle_rec.FUNDING_DATE;
5047: END IF;
5048: IF (x_kle_rec.STREAM_TYPE_SUBCLASS = OKL_API.G_MISS_CHAR) THEN
5049: x_kle_rec.STREAM_TYPE_SUBCLASS := l_kle_rec.STREAM_TYPE_SUBCLASS;
5050: END IF;
5051:
5052: --Bug# 4419339 OKLH

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

5049: x_kle_rec.STREAM_TYPE_SUBCLASS := l_kle_rec.STREAM_TYPE_SUBCLASS;
5050: END IF;
5051:
5052: --Bug# 4419339 OKLH
5053: IF (x_kle_rec.DATE_FUNDING_EXPECTED = OKL_API.G_MISS_DATE) THEN
5054: x_kle_rec.DATE_FUNDING_EXPECTED := l_kle_rec.DATE_FUNDING_EXPECTED;
5055: END IF;
5056:
5057: IF (x_kle_rec.MANUFACTURER_NAME = OKL_API.G_MISS_CHAR) THEN

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

5053: IF (x_kle_rec.DATE_FUNDING_EXPECTED = OKL_API.G_MISS_DATE) THEN
5054: x_kle_rec.DATE_FUNDING_EXPECTED := l_kle_rec.DATE_FUNDING_EXPECTED;
5055: END IF;
5056:
5057: IF (x_kle_rec.MANUFACTURER_NAME = OKL_API.G_MISS_CHAR) THEN
5058: x_kle_rec.MANUFACTURER_NAME := l_kle_rec.MANUFACTURER_NAME;
5059: END IF;
5060:
5061: IF (x_kle_rec.MODEL_NUMBER = OKL_API.G_MISS_CHAR) THEN

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

5057: IF (x_kle_rec.MANUFACTURER_NAME = OKL_API.G_MISS_CHAR) THEN
5058: x_kle_rec.MANUFACTURER_NAME := l_kle_rec.MANUFACTURER_NAME;
5059: END IF;
5060:
5061: IF (x_kle_rec.MODEL_NUMBER = OKL_API.G_MISS_CHAR) THEN
5062: x_kle_rec.MODEL_NUMBER := l_kle_rec.MODEL_NUMBER;
5063: END IF;
5064:
5065: IF (x_kle_rec.DOWN_PAYMENT_RECEIVER_CODE = OKL_API.G_MISS_CHAR) THEN

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

5061: IF (x_kle_rec.MODEL_NUMBER = OKL_API.G_MISS_CHAR) THEN
5062: x_kle_rec.MODEL_NUMBER := l_kle_rec.MODEL_NUMBER;
5063: END IF;
5064:
5065: IF (x_kle_rec.DOWN_PAYMENT_RECEIVER_CODE = OKL_API.G_MISS_CHAR) THEN
5066: x_kle_rec.DOWN_PAYMENT_RECEIVER_CODE := l_kle_rec.DOWN_PAYMENT_RECEIVER_CODE;
5067: END IF;
5068:
5069: IF (x_kle_rec.CAPITALIZE_DOWN_PAYMENT_YN = OKL_API.G_MISS_CHAR) THEN

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

5065: IF (x_kle_rec.DOWN_PAYMENT_RECEIVER_CODE = OKL_API.G_MISS_CHAR) THEN
5066: x_kle_rec.DOWN_PAYMENT_RECEIVER_CODE := l_kle_rec.DOWN_PAYMENT_RECEIVER_CODE;
5067: END IF;
5068:
5069: IF (x_kle_rec.CAPITALIZE_DOWN_PAYMENT_YN = OKL_API.G_MISS_CHAR) THEN
5070: x_kle_rec.CAPITALIZE_DOWN_PAYMENT_YN := l_kle_rec.CAPITALIZE_DOWN_PAYMENT_YN;
5071: END IF;
5072:
5073: IF (x_kle_rec.FEE_PURPOSE_CODE = OKL_API.G_MISS_CHAR) THEN

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

5069: IF (x_kle_rec.CAPITALIZE_DOWN_PAYMENT_YN = OKL_API.G_MISS_CHAR) THEN
5070: x_kle_rec.CAPITALIZE_DOWN_PAYMENT_YN := l_kle_rec.CAPITALIZE_DOWN_PAYMENT_YN;
5071: END IF;
5072:
5073: IF (x_kle_rec.FEE_PURPOSE_CODE = OKL_API.G_MISS_CHAR) THEN
5074: x_kle_rec.FEE_PURPOSE_CODE := l_kle_rec.FEE_PURPOSE_CODE;
5075: END IF;
5076:
5077: IF (x_kle_rec.TERMINATION_VALUE = OKL_API.G_MISS_NUM) THEN

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

5073: IF (x_kle_rec.FEE_PURPOSE_CODE = OKL_API.G_MISS_CHAR) THEN
5074: x_kle_rec.FEE_PURPOSE_CODE := l_kle_rec.FEE_PURPOSE_CODE;
5075: END IF;
5076:
5077: IF (x_kle_rec.TERMINATION_VALUE = OKL_API.G_MISS_NUM) THEN
5078: x_kle_rec.TERMINATION_VALUE := l_kle_rec.TERMINATION_VALUE;
5079: END IF;
5080:
5081: --Bug# 4631549

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

5078: x_kle_rec.TERMINATION_VALUE := l_kle_rec.TERMINATION_VALUE;
5079: END IF;
5080:
5081: --Bug# 4631549
5082: IF (x_kle_rec.EXPECTED_ASSET_COST = OKL_API.G_MISS_NUM) THEN
5083: x_kle_rec.EXPECTED_ASSET_COST := l_kle_rec.EXPECTED_ASSET_COST;
5084: END IF;
5085:
5086: IF (x_kle_rec.ORIG_CONTRACT_LINE_ID = OKL_API.G_MISS_NUM) THEN

Line 5086: IF (x_kle_rec.ORIG_CONTRACT_LINE_ID = OKL_API.G_MISS_NUM) THEN

5082: IF (x_kle_rec.EXPECTED_ASSET_COST = OKL_API.G_MISS_NUM) THEN
5083: x_kle_rec.EXPECTED_ASSET_COST := l_kle_rec.EXPECTED_ASSET_COST;
5084: END IF;
5085:
5086: IF (x_kle_rec.ORIG_CONTRACT_LINE_ID = OKL_API.G_MISS_NUM) THEN
5087: x_kle_rec.ORIG_CONTRACT_LINE_ID := l_kle_rec.ORIG_CONTRACT_LINE_ID;
5088: END IF;
5089:
5090: --Added by JJUNEJA

Line 5091: IF (x_kle_rec.ORIGINATION_INCOME = OKL_API.G_MISS_NUM) THEN

5087: x_kle_rec.ORIG_CONTRACT_LINE_ID := l_kle_rec.ORIG_CONTRACT_LINE_ID;
5088: END IF;
5089:
5090: --Added by JJUNEJA
5091: IF (x_kle_rec.ORIGINATION_INCOME = OKL_API.G_MISS_NUM) THEN
5092: x_kle_rec.ORIGINATION_INCOME := l_kle_rec.ORIGINATION_INCOME;
5093: END IF;
5094: --End of addition by JJUNEJA
5095:

Line 5097: IF (x_kle_rec.AMOUNT_BALANCE_LEGACY = OKL_API.G_MISS_NUM) THEN

5093: END IF;
5094: --End of addition by JJUNEJA
5095:
5096: --Bug# 16344245
5097: IF (x_kle_rec.AMOUNT_BALANCE_LEGACY = OKL_API.G_MISS_NUM) THEN
5098: x_kle_rec.AMOUNT_BALANCE_LEGACY := l_kle_rec.AMOUNT_BALANCE_LEGACY;
5099: END IF;
5100:
5101: IF (x_kle_rec.DT_EFFECTIVE_BALANCE_LEGACY = OKL_API.G_MISS_DATE) THEN

Line 5101: IF (x_kle_rec.DT_EFFECTIVE_BALANCE_LEGACY = OKL_API.G_MISS_DATE) THEN

5097: IF (x_kle_rec.AMOUNT_BALANCE_LEGACY = OKL_API.G_MISS_NUM) THEN
5098: x_kle_rec.AMOUNT_BALANCE_LEGACY := l_kle_rec.AMOUNT_BALANCE_LEGACY;
5099: END IF;
5100:
5101: IF (x_kle_rec.DT_EFFECTIVE_BALANCE_LEGACY = OKL_API.G_MISS_DATE) THEN
5102: x_kle_rec.DT_EFFECTIVE_BALANCE_LEGACY := l_kle_rec.DT_EFFECTIVE_BALANCE_LEGACY;
5103: END IF;
5104:
5105: RETURN(l_return_status);

Line 5371: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

5367:
5368: PROCEDURE update_row(
5369:
5370: p_api_version IN NUMBER,
5371: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
5372: x_return_status OUT NOCOPY VARCHAR2,
5373: x_msg_count OUT NOCOPY NUMBER,
5374: x_msg_data OUT NOCOPY VARCHAR2,
5375: p_klev_rec IN klev_rec_type,

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

5813: x_klev_rec.FEE_TYPE := l_klev_rec.FEE_TYPE;
5814: END IF;
5815: --Bug# 3143522: 11.5.10
5816: --subsidy
5817: IF (x_klev_rec.SUBSIDY_ID = OKL_API.G_MISS_NUM) THEN
5818: x_klev_rec.SUBSIDY_ID := l_klev_rec.SUBSIDY_ID;
5819: END IF;
5820: --IF (x_klev_rec.SUBSIDIZED_OEC = OKL_API.G_MISS_NUM) THEN
5821: --x_klev_rec.SUBSIDIZED_OEC := l_klev_rec.SUBSIDIZED_OEC;

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

5816: --subsidy
5817: IF (x_klev_rec.SUBSIDY_ID = OKL_API.G_MISS_NUM) THEN
5818: x_klev_rec.SUBSIDY_ID := l_klev_rec.SUBSIDY_ID;
5819: END IF;
5820: --IF (x_klev_rec.SUBSIDIZED_OEC = OKL_API.G_MISS_NUM) THEN
5821: --x_klev_rec.SUBSIDIZED_OEC := l_klev_rec.SUBSIDIZED_OEC;
5822: --END IF;
5823: --IF (x_klev_rec.SUBSIDIZED_CAP_AMOUNT = OKL_API.G_MISS_NUM) THEN
5824: --x_klev_rec.SUBSIDIZED_CAP_AMOUNT := l_klev_rec.SUBSIDIZED_CAP_AMOUNT;

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

5819: END IF;
5820: --IF (x_klev_rec.SUBSIDIZED_OEC = OKL_API.G_MISS_NUM) THEN
5821: --x_klev_rec.SUBSIDIZED_OEC := l_klev_rec.SUBSIDIZED_OEC;
5822: --END IF;
5823: --IF (x_klev_rec.SUBSIDIZED_CAP_AMOUNT = OKL_API.G_MISS_NUM) THEN
5824: --x_klev_rec.SUBSIDIZED_CAP_AMOUNT := l_klev_rec.SUBSIDIZED_CAP_AMOUNT;
5825: --END IF;
5826: IF (x_klev_rec.SUBSIDY_OVERRIDE_AMOUNT = OKL_API.G_MISS_NUM) THEN
5827: x_klev_rec.SUBSIDY_OVERRIDE_AMOUNT := l_klev_rec.SUBSIDY_OVERRIDE_AMOUNT;

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

5822: --END IF;
5823: --IF (x_klev_rec.SUBSIDIZED_CAP_AMOUNT = OKL_API.G_MISS_NUM) THEN
5824: --x_klev_rec.SUBSIDIZED_CAP_AMOUNT := l_klev_rec.SUBSIDIZED_CAP_AMOUNT;
5825: --END IF;
5826: IF (x_klev_rec.SUBSIDY_OVERRIDE_AMOUNT = OKL_API.G_MISS_NUM) THEN
5827: x_klev_rec.SUBSIDY_OVERRIDE_AMOUNT := l_klev_rec.SUBSIDY_OVERRIDE_AMOUNT;
5828: END IF;
5829: --financed fee
5830: IF (x_klev_rec.PRE_TAX_YIELD = OKL_API.G_MISS_NUM) THEN

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

5826: IF (x_klev_rec.SUBSIDY_OVERRIDE_AMOUNT = OKL_API.G_MISS_NUM) THEN
5827: x_klev_rec.SUBSIDY_OVERRIDE_AMOUNT := l_klev_rec.SUBSIDY_OVERRIDE_AMOUNT;
5828: END IF;
5829: --financed fee
5830: IF (x_klev_rec.PRE_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
5831: x_klev_rec.PRE_TAX_YIELD := l_klev_rec.PRE_TAX_YIELD;
5832: END IF;
5833: IF (x_klev_rec.AFTER_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
5834: x_klev_rec.AFTER_TAX_YIELD := l_klev_rec.AFTER_TAX_YIELD;

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

5829: --financed fee
5830: IF (x_klev_rec.PRE_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
5831: x_klev_rec.PRE_TAX_YIELD := l_klev_rec.PRE_TAX_YIELD;
5832: END IF;
5833: IF (x_klev_rec.AFTER_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
5834: x_klev_rec.AFTER_TAX_YIELD := l_klev_rec.AFTER_TAX_YIELD;
5835: END IF;
5836: IF (x_klev_rec.IMPLICIT_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
5837: x_klev_rec.IMPLICIT_INTEREST_RATE := l_klev_rec.IMPLICIT_INTEREST_RATE;

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

5832: END IF;
5833: IF (x_klev_rec.AFTER_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
5834: x_klev_rec.AFTER_TAX_YIELD := l_klev_rec.AFTER_TAX_YIELD;
5835: END IF;
5836: IF (x_klev_rec.IMPLICIT_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
5837: x_klev_rec.IMPLICIT_INTEREST_RATE := l_klev_rec.IMPLICIT_INTEREST_RATE;
5838: END IF;
5839: IF (x_klev_rec.IMPLICIT_NON_IDC_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
5840: x_klev_rec.IMPLICIT_NON_IDC_INTEREST_RATE := l_klev_rec.IMPLICIT_NON_IDC_INTEREST_RATE;

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

5835: END IF;
5836: IF (x_klev_rec.IMPLICIT_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
5837: x_klev_rec.IMPLICIT_INTEREST_RATE := l_klev_rec.IMPLICIT_INTEREST_RATE;
5838: END IF;
5839: IF (x_klev_rec.IMPLICIT_NON_IDC_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
5840: x_klev_rec.IMPLICIT_NON_IDC_INTEREST_RATE := l_klev_rec.IMPLICIT_NON_IDC_INTEREST_RATE;
5841: END IF;
5842: IF (x_klev_rec.PRE_TAX_IRR = OKL_API.G_MISS_NUM) THEN
5843: x_klev_rec.PRE_TAX_IRR := l_klev_rec.PRE_TAX_IRR;

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

5838: END IF;
5839: IF (x_klev_rec.IMPLICIT_NON_IDC_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
5840: x_klev_rec.IMPLICIT_NON_IDC_INTEREST_RATE := l_klev_rec.IMPLICIT_NON_IDC_INTEREST_RATE;
5841: END IF;
5842: IF (x_klev_rec.PRE_TAX_IRR = OKL_API.G_MISS_NUM) THEN
5843: x_klev_rec.PRE_TAX_IRR := l_klev_rec.PRE_TAX_IRR;
5844: END IF;
5845: IF (x_klev_rec.AFTER_TAX_IRR = OKL_API.G_MISS_NUM) THEN
5846: x_klev_rec.AFTER_TAX_IRR := l_klev_rec.AFTER_TAX_IRR;

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

5841: END IF;
5842: IF (x_klev_rec.PRE_TAX_IRR = OKL_API.G_MISS_NUM) THEN
5843: x_klev_rec.PRE_TAX_IRR := l_klev_rec.PRE_TAX_IRR;
5844: END IF;
5845: IF (x_klev_rec.AFTER_TAX_IRR = OKL_API.G_MISS_NUM) THEN
5846: x_klev_rec.AFTER_TAX_IRR := l_klev_rec.AFTER_TAX_IRR;
5847: END IF;
5848: --quote
5849: IF (x_klev_rec.SUB_PRE_TAX_YIELD = OKL_API.G_MISS_NUM) THEN

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

5845: IF (x_klev_rec.AFTER_TAX_IRR = OKL_API.G_MISS_NUM) THEN
5846: x_klev_rec.AFTER_TAX_IRR := l_klev_rec.AFTER_TAX_IRR;
5847: END IF;
5848: --quote
5849: IF (x_klev_rec.SUB_PRE_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
5850: x_klev_rec.SUB_PRE_TAX_YIELD := l_klev_rec.SUB_PRE_TAX_YIELD;
5851: END IF;
5852: IF (x_klev_rec.SUB_AFTER_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
5853: x_klev_rec.SUB_AFTER_TAX_YIELD := l_klev_rec.SUB_AFTER_TAX_YIELD;

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

5848: --quote
5849: IF (x_klev_rec.SUB_PRE_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
5850: x_klev_rec.SUB_PRE_TAX_YIELD := l_klev_rec.SUB_PRE_TAX_YIELD;
5851: END IF;
5852: IF (x_klev_rec.SUB_AFTER_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
5853: x_klev_rec.SUB_AFTER_TAX_YIELD := l_klev_rec.SUB_AFTER_TAX_YIELD;
5854: END IF;
5855: IF (x_klev_rec.SUB_IMPL_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
5856: x_klev_rec.SUB_IMPL_INTEREST_RATE := l_klev_rec.SUB_IMPL_INTEREST_RATE;

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

5851: END IF;
5852: IF (x_klev_rec.SUB_AFTER_TAX_YIELD = OKL_API.G_MISS_NUM) THEN
5853: x_klev_rec.SUB_AFTER_TAX_YIELD := l_klev_rec.SUB_AFTER_TAX_YIELD;
5854: END IF;
5855: IF (x_klev_rec.SUB_IMPL_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
5856: x_klev_rec.SUB_IMPL_INTEREST_RATE := l_klev_rec.SUB_IMPL_INTEREST_RATE;
5857: END IF;
5858: IF (x_klev_rec.SUB_IMPL_NON_IDC_INT_RATE = OKL_API.G_MISS_NUM) THEN
5859: x_klev_rec.SUB_IMPL_NON_IDC_INT_RATE := l_klev_rec.SUB_IMPL_NON_IDC_INT_RATE;

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

5854: END IF;
5855: IF (x_klev_rec.SUB_IMPL_INTEREST_RATE = OKL_API.G_MISS_NUM) THEN
5856: x_klev_rec.SUB_IMPL_INTEREST_RATE := l_klev_rec.SUB_IMPL_INTEREST_RATE;
5857: END IF;
5858: IF (x_klev_rec.SUB_IMPL_NON_IDC_INT_RATE = OKL_API.G_MISS_NUM) THEN
5859: x_klev_rec.SUB_IMPL_NON_IDC_INT_RATE := l_klev_rec.SUB_IMPL_NON_IDC_INT_RATE;
5860: END IF;
5861: IF (x_klev_rec.SUB_PRE_TAX_IRR = OKL_API.G_MISS_NUM) THEN
5862: x_klev_rec.SUB_PRE_TAX_IRR := l_klev_rec.SUB_PRE_TAX_IRR;

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

5857: END IF;
5858: IF (x_klev_rec.SUB_IMPL_NON_IDC_INT_RATE = OKL_API.G_MISS_NUM) THEN
5859: x_klev_rec.SUB_IMPL_NON_IDC_INT_RATE := l_klev_rec.SUB_IMPL_NON_IDC_INT_RATE;
5860: END IF;
5861: IF (x_klev_rec.SUB_PRE_TAX_IRR = OKL_API.G_MISS_NUM) THEN
5862: x_klev_rec.SUB_PRE_TAX_IRR := l_klev_rec.SUB_PRE_TAX_IRR;
5863: END IF;
5864: IF (x_klev_rec.SUB_AFTER_TAX_IRR = OKL_API.G_MISS_NUM) THEN
5865: x_klev_rec.SUB_AFTER_TAX_IRR := l_klev_rec.SUB_AFTER_TAX_IRR;

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

5860: END IF;
5861: IF (x_klev_rec.SUB_PRE_TAX_IRR = OKL_API.G_MISS_NUM) THEN
5862: x_klev_rec.SUB_PRE_TAX_IRR := l_klev_rec.SUB_PRE_TAX_IRR;
5863: END IF;
5864: IF (x_klev_rec.SUB_AFTER_TAX_IRR = OKL_API.G_MISS_NUM) THEN
5865: x_klev_rec.SUB_AFTER_TAX_IRR := l_klev_rec.SUB_AFTER_TAX_IRR;
5866: END IF;
5867: --Bug# 2994971
5868: IF (x_klev_rec.ITEM_INSURANCE_CATEGORY = OKL_API.G_MISS_NUM) THEN

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

5864: IF (x_klev_rec.SUB_AFTER_TAX_IRR = OKL_API.G_MISS_NUM) THEN
5865: x_klev_rec.SUB_AFTER_TAX_IRR := l_klev_rec.SUB_AFTER_TAX_IRR;
5866: END IF;
5867: --Bug# 2994971
5868: IF (x_klev_rec.ITEM_INSURANCE_CATEGORY = OKL_API.G_MISS_NUM) THEN
5869: x_klev_rec.ITEM_INSURANCE_CATEGORY := l_klev_rec.ITEM_INSURANCE_CATEGORY;
5870: END IF;
5871: --Bug# 3973640 :11.5.10+
5872: IF (x_klev_rec.QTE_ID = OKL_API.G_MISS_NUM) THEN

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

5868: IF (x_klev_rec.ITEM_INSURANCE_CATEGORY = OKL_API.G_MISS_NUM) THEN
5869: x_klev_rec.ITEM_INSURANCE_CATEGORY := l_klev_rec.ITEM_INSURANCE_CATEGORY;
5870: END IF;
5871: --Bug# 3973640 :11.5.10+
5872: IF (x_klev_rec.QTE_ID = OKL_API.G_MISS_NUM) THEN
5873: x_klev_rec.QTE_ID := l_klev_rec.QTE_ID;
5874: END IF;
5875: IF (x_klev_rec.FUNDING_DATE = OKL_API.G_MISS_DATE) THEN
5876: x_klev_rec.FUNDING_DATE := l_klev_rec.FUNDING_DATE;

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

5871: --Bug# 3973640 :11.5.10+
5872: IF (x_klev_rec.QTE_ID = OKL_API.G_MISS_NUM) THEN
5873: x_klev_rec.QTE_ID := l_klev_rec.QTE_ID;
5874: END IF;
5875: IF (x_klev_rec.FUNDING_DATE = OKL_API.G_MISS_DATE) THEN
5876: x_klev_rec.FUNDING_DATE := l_klev_rec.FUNDING_DATE;
5877: END IF;
5878: IF (x_klev_rec.STREAM_TYPE_SUBCLASS = OKL_API.G_MISS_CHAR) THEN
5879: x_klev_rec.STREAM_TYPE_SUBCLASS := l_klev_rec.STREAM_TYPE_SUBCLASS;

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

5874: END IF;
5875: IF (x_klev_rec.FUNDING_DATE = OKL_API.G_MISS_DATE) THEN
5876: x_klev_rec.FUNDING_DATE := l_klev_rec.FUNDING_DATE;
5877: END IF;
5878: IF (x_klev_rec.STREAM_TYPE_SUBCLASS = OKL_API.G_MISS_CHAR) THEN
5879: x_klev_rec.STREAM_TYPE_SUBCLASS := l_klev_rec.STREAM_TYPE_SUBCLASS;
5880: END IF;
5881:
5882: --Bug# 4419339 OKLH

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

5879: x_klev_rec.STREAM_TYPE_SUBCLASS := l_klev_rec.STREAM_TYPE_SUBCLASS;
5880: END IF;
5881:
5882: --Bug# 4419339 OKLH
5883: IF (x_klev_rec.DATE_FUNDING_EXPECTED = OKL_API.G_MISS_DATE) THEN
5884: x_klev_rec.DATE_FUNDING_EXPECTED := l_klev_rec.DATE_FUNDING_EXPECTED;
5885: END IF;
5886:
5887: IF (x_klev_rec.MANUFACTURER_NAME = OKL_API.G_MISS_CHAR) THEN

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

5883: IF (x_klev_rec.DATE_FUNDING_EXPECTED = OKL_API.G_MISS_DATE) THEN
5884: x_klev_rec.DATE_FUNDING_EXPECTED := l_klev_rec.DATE_FUNDING_EXPECTED;
5885: END IF;
5886:
5887: IF (x_klev_rec.MANUFACTURER_NAME = OKL_API.G_MISS_CHAR) THEN
5888: x_klev_rec.MANUFACTURER_NAME := l_klev_rec.MANUFACTURER_NAME;
5889: END IF;
5890:
5891: IF (x_klev_rec.MODEL_NUMBER = OKL_API.G_MISS_CHAR) THEN

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

5887: IF (x_klev_rec.MANUFACTURER_NAME = OKL_API.G_MISS_CHAR) THEN
5888: x_klev_rec.MANUFACTURER_NAME := l_klev_rec.MANUFACTURER_NAME;
5889: END IF;
5890:
5891: IF (x_klev_rec.MODEL_NUMBER = OKL_API.G_MISS_CHAR) THEN
5892: x_klev_rec.MODEL_NUMBER := l_klev_rec.MODEL_NUMBER;
5893: END IF;
5894:
5895: IF (x_klev_rec.DOWN_PAYMENT_RECEIVER_CODE = OKL_API.G_MISS_CHAR) THEN

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

5891: IF (x_klev_rec.MODEL_NUMBER = OKL_API.G_MISS_CHAR) THEN
5892: x_klev_rec.MODEL_NUMBER := l_klev_rec.MODEL_NUMBER;
5893: END IF;
5894:
5895: IF (x_klev_rec.DOWN_PAYMENT_RECEIVER_CODE = OKL_API.G_MISS_CHAR) THEN
5896: x_klev_rec.DOWN_PAYMENT_RECEIVER_CODE := l_klev_rec.DOWN_PAYMENT_RECEIVER_CODE;
5897: END IF;
5898:
5899: IF (x_klev_rec.CAPITALIZE_DOWN_PAYMENT_YN = OKL_API.G_MISS_CHAR) THEN

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

5895: IF (x_klev_rec.DOWN_PAYMENT_RECEIVER_CODE = OKL_API.G_MISS_CHAR) THEN
5896: x_klev_rec.DOWN_PAYMENT_RECEIVER_CODE := l_klev_rec.DOWN_PAYMENT_RECEIVER_CODE;
5897: END IF;
5898:
5899: IF (x_klev_rec.CAPITALIZE_DOWN_PAYMENT_YN = OKL_API.G_MISS_CHAR) THEN
5900: x_klev_rec.CAPITALIZE_DOWN_PAYMENT_YN := l_klev_rec.CAPITALIZE_DOWN_PAYMENT_YN;
5901: END IF;
5902:
5903: IF (x_klev_rec.FEE_PURPOSE_CODE = OKL_API.G_MISS_CHAR) THEN

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

5899: IF (x_klev_rec.CAPITALIZE_DOWN_PAYMENT_YN = OKL_API.G_MISS_CHAR) THEN
5900: x_klev_rec.CAPITALIZE_DOWN_PAYMENT_YN := l_klev_rec.CAPITALIZE_DOWN_PAYMENT_YN;
5901: END IF;
5902:
5903: IF (x_klev_rec.FEE_PURPOSE_CODE = OKL_API.G_MISS_CHAR) THEN
5904: x_klev_rec.FEE_PURPOSE_CODE := l_klev_rec.FEE_PURPOSE_CODE;
5905: END IF;
5906:
5907: IF (x_klev_rec.TERMINATION_VALUE = OKL_API.G_MISS_NUM) THEN

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

5903: IF (x_klev_rec.FEE_PURPOSE_CODE = OKL_API.G_MISS_CHAR) THEN
5904: x_klev_rec.FEE_PURPOSE_CODE := l_klev_rec.FEE_PURPOSE_CODE;
5905: END IF;
5906:
5907: IF (x_klev_rec.TERMINATION_VALUE = OKL_API.G_MISS_NUM) THEN
5908: x_klev_rec.TERMINATION_VALUE := l_klev_rec.TERMINATION_VALUE;
5909: END IF;
5910:
5911: --Bug# 4631549

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

5908: x_klev_rec.TERMINATION_VALUE := l_klev_rec.TERMINATION_VALUE;
5909: END IF;
5910:
5911: --Bug# 4631549
5912: IF (x_klev_rec.EXPECTED_ASSET_COST = OKL_API.G_MISS_NUM) THEN
5913: x_klev_rec.EXPECTED_ASSET_COST := l_klev_rec.EXPECTED_ASSET_COST;
5914: END IF;
5915:
5916: IF (x_klev_rec.ORIG_CONTRACT_LINE_ID = OKL_API.G_MISS_NUM) THEN

Line 5916: IF (x_klev_rec.ORIG_CONTRACT_LINE_ID = OKL_API.G_MISS_NUM) THEN

5912: IF (x_klev_rec.EXPECTED_ASSET_COST = OKL_API.G_MISS_NUM) THEN
5913: x_klev_rec.EXPECTED_ASSET_COST := l_klev_rec.EXPECTED_ASSET_COST;
5914: END IF;
5915:
5916: IF (x_klev_rec.ORIG_CONTRACT_LINE_ID = OKL_API.G_MISS_NUM) THEN
5917: x_klev_rec.ORIG_CONTRACT_LINE_ID := l_klev_rec.ORIG_CONTRACT_LINE_ID;
5918: END IF;
5919:
5920: --Added by JJUNEJA

Line 5921: IF (x_klev_rec.ORIGINATION_INCOME = OKL_API.G_MISS_NUM) THEN

5917: x_klev_rec.ORIG_CONTRACT_LINE_ID := l_klev_rec.ORIG_CONTRACT_LINE_ID;
5918: END IF;
5919:
5920: --Added by JJUNEJA
5921: IF (x_klev_rec.ORIGINATION_INCOME = OKL_API.G_MISS_NUM) THEN
5922: x_klev_rec.ORIGINATION_INCOME := l_klev_rec.ORIGINATION_INCOME;
5923: END IF;
5924: --End of addition by JJUNEJA
5925:

Line 5927: IF (x_klev_rec.AMOUNT_BALANCE_LEGACY = OKL_API.G_MISS_NUM) THEN

5923: END IF;
5924: --End of addition by JJUNEJA
5925:
5926: --Bug# 16344245
5927: IF (x_klev_rec.AMOUNT_BALANCE_LEGACY = OKL_API.G_MISS_NUM) THEN
5928: x_klev_rec.AMOUNT_BALANCE_LEGACY := l_klev_rec.AMOUNT_BALANCE_LEGACY;
5929: END IF;
5930:
5931: IF (x_klev_rec.DT_EFFECTIVE_BALANCE_LEGACY = OKL_API.G_MISS_DATE) THEN

Line 5931: IF (x_klev_rec.DT_EFFECTIVE_BALANCE_LEGACY = OKL_API.G_MISS_DATE) THEN

5927: IF (x_klev_rec.AMOUNT_BALANCE_LEGACY = OKL_API.G_MISS_NUM) THEN
5928: x_klev_rec.AMOUNT_BALANCE_LEGACY := l_klev_rec.AMOUNT_BALANCE_LEGACY;
5929: END IF;
5930:
5931: IF (x_klev_rec.DT_EFFECTIVE_BALANCE_LEGACY = OKL_API.G_MISS_DATE) THEN
5932: x_klev_rec.DT_EFFECTIVE_BALANCE_LEGACY := l_klev_rec.DT_EFFECTIVE_BALANCE_LEGACY;
5933: END IF;
5934:
5935: RETURN(l_return_status);

Line 6072: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

6068:
6069: PROCEDURE update_row(
6070:
6071: p_api_version IN NUMBER,
6072: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
6073: x_return_status OUT NOCOPY VARCHAR2,
6074: x_msg_count OUT NOCOPY NUMBER,
6075: x_msg_data OUT NOCOPY VARCHAR2,
6076: p_klev_tbl IN klev_tbl_type,

Line 6149: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

6145:
6146: PROCEDURE delete_row(
6147:
6148: p_api_version IN NUMBER,
6149: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
6150: x_return_status OUT NOCOPY VARCHAR2,
6151: x_msg_count OUT NOCOPY NUMBER,
6152: x_msg_data OUT NOCOPY VARCHAR2,
6153: p_kle_rec IN kle_rec_type) IS

Line 6239: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

6235:
6236: PROCEDURE delete_row(
6237:
6238: p_api_version IN NUMBER,
6239: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
6240: x_return_status OUT NOCOPY VARCHAR2,
6241: x_msg_count OUT NOCOPY NUMBER,
6242: x_msg_data OUT NOCOPY VARCHAR2,
6243: p_klev_rec IN klev_rec_type) IS

Line 6329: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

6325:
6326: PROCEDURE delete_row(
6327:
6328: p_api_version IN NUMBER,
6329: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
6330: x_return_status OUT NOCOPY VARCHAR2,
6331: x_msg_count OUT NOCOPY NUMBER,
6332: x_msg_data OUT NOCOPY VARCHAR2,
6333: p_klev_tbl IN klev_tbl_type) IS