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 SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 487


    select 'Y'
    from   okl_subsidies_b subb
    where  subb.id = p_subsidy_id;

Line: 734


      SELECT
	ID,
        KLE_ID,
        STY_ID,
        OBJECT_VERSION_NUMBER,
        LAO_AMOUNT,
        FEE_CHARGE,
        TITLE_DATE,
        DATE_RESIDUAL_LAST_REVIEW,
        DATE_LAST_REAMORTISATION,
        TERMINATION_PURCHASE_AMOUNT,
        DATE_LAST_CLEANUP,
        REMARKETED_AMOUNT,
        DATE_REMARKETED,
        REMARKET_MARGIN,
        REPURCHASED_AMOUNT,
        DATE_REPURCHASED,
        GAIN_LOSS,
        FLOOR_AMOUNT,
        PREVIOUS_CONTRACT,
        TRACKED_RESIDUAL,
        DATE_TITLE_RECEIVED,
        ESTIMATED_OEC,
        RESIDUAL_PERCENTAGE,
        CAPITAL_REDUCTION,
        VENDOR_ADVANCE_PAID,
        TRADEIN_AMOUNT,
        DELIVERED_DATE,
        YEAR_OF_MANUFACTURE,
        INITIAL_DIRECT_COST,
        OCCUPANCY,
        DATE_LAST_INSPECTION,
        DATE_NEXT_INSPECTION_DUE,
        WEIGHTED_AVERAGE_LIFE,
        BOND_EQUIVALENT_YIELD,
        REFINANCE_AMOUNT,
        YEAR_BUILT,
        COVERAGE_RATIO,
        GROSS_SQUARE_FOOTAGE,
        NET_RENTABLE,
        DATE_LETTER_ACCEPTANCE,
        DATE_COMMITMENT_EXPIRATION,
        DATE_APPRAISAL,
        APPRAISAL_VALUE,
        RESIDUAL_VALUE,
        PERCENT,
        COVERAGE,
        LRV_AMOUNT,
        AMOUNT,
        LRS_PERCENT,
        EVERGREEN_PERCENT,
        PERCENT_STAKE,
        AMOUNT_STAKE,
        DATE_SOLD,
        STY_ID_FOR,
        ATTRIBUTE_CATEGORY,
        ATTRIBUTE1,
        ATTRIBUTE2,
        ATTRIBUTE3,
        ATTRIBUTE4,
        ATTRIBUTE5,
        ATTRIBUTE6,
        ATTRIBUTE7,
        ATTRIBUTE8,
        ATTRIBUTE9,
        ATTRIBUTE10,
        ATTRIBUTE11,
        ATTRIBUTE12,
        ATTRIBUTE13,
        ATTRIBUTE14,
        ATTRIBUTE15,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATE_LOGIN,
        NTY_CODE,
        FCG_CODE,
        PRC_CODE,
        RE_LEASE_YN,
        PRESCRIBED_ASSET_YN,
        CREDIT_TENANT_YN,
        SECURED_DEAL_YN,
        CLG_ID,
        DATE_FUNDING,
        DATE_FUNDING_REQUIRED,
        DATE_ACCEPTED,
        DATE_DELIVERY_EXPECTED,
        OEC,
        CAPITAL_AMOUNT,
        RESIDUAL_GRNTY_AMOUNT,
        RESIDUAL_CODE,
        RVI_PREMIUM,
        CREDIT_NATURE,
        CAPITALIZED_INTEREST,
        CAPITAL_REDUCTION_PERCENT,
--Bug# 2697681 :11.5.9
        DATE_PAY_INVESTOR_START,
        PAY_INVESTOR_FREQUENCY,
        PAY_INVESTOR_EVENT,
        PAY_INVESTOR_REMITTANCE_DAYS,
--financed fees
        FEE_TYPE,
--Bug# 3143522: 11.5.10
--subsidy
        SUBSIDY_ID,
        --SUBSIDIZED_OEC,
        --SUBSIDIZED_CAP_AMOUNT,
        SUBSIDY_OVERRIDE_AMOUNT,
--financed fee
        PRE_TAX_YIELD,
        AFTER_TAX_YIELD,
        IMPLICIT_INTEREST_RATE,
        IMPLICIT_NON_IDC_INTEREST_RATE,
        PRE_TAX_IRR,
        AFTER_TAX_IRR,
--quote
        SUB_PRE_TAX_YIELD,
        SUB_AFTER_TAX_YIELD,
        SUB_IMPL_INTEREST_RATE,
        SUB_IMPL_NON_IDC_INT_RATE,
        SUB_PRE_TAX_IRR,
        SUB_AFTER_TAX_IRR,
--Bug# 2994971
        ITEM_INSURANCE_CATEGORY,
--Bug# 3973640: 11.5.10+
        QTE_ID,
        FUNDING_DATE,
        STREAM_TYPE_SUBCLASS,
--Bug# 4419339  OKLH
        DATE_FUNDING_EXPECTED,
        MANUFACTURER_NAME,
        MODEL_NUMBER,
        DOWN_PAYMENT_RECEIVER_CODE,
        CAPITALIZE_DOWN_PAYMENT_YN,
--Bug#4373029
        FEE_PURPOSE_CODE,
        TERMINATION_VALUE,
--Bug# 4631549
        EXPECTED_ASSET_COST

      FROM OKL_K_LINES
      WHERE OKL_K_LINES.id     = p_id;

Line: 957


        l_kle_rec.LAST_UPDATED_BY,
        l_kle_rec.LAST_UPDATE_DATE,
        l_kle_rec.LAST_UPDATE_LOGIN,
        l_kle_rec.NTY_CODE,
        l_kle_rec.FCG_CODE,
        l_kle_rec.PRC_CODE,
        l_kle_rec.RE_LEASE_YN,
        l_kle_rec.PRESCRIBED_ASSET_YN,
        l_kle_rec.CREDIT_TENANT_YN,
        l_kle_rec.SECURED_DEAL_YN,
        l_kle_rec.CLG_ID,
        l_kle_rec.DATE_FUNDING,
        l_kle_rec.DATE_FUNDING_REQUIRED,
        l_kle_rec.DATE_ACCEPTED,
        l_kle_rec.DATE_DELIVERY_EXPECTED,
        l_kle_rec.OEC,
        l_kle_rec.CAPITAL_AMOUNT,
        l_kle_rec.RESIDUAL_GRNTY_AMOUNT,
        l_kle_rec.RESIDUAL_CODE,
        l_kle_rec.RVI_PREMIUM,
        l_kle_rec.CREDIT_NATURE,
        l_kle_rec.CAPITALIZED_INTEREST,
        l_kle_rec.CAPITAL_REDUCTION_PERCENT,
--Bug# 2697681 11.5.9
        l_kle_rec.DATE_PAY_INVESTOR_START,
        l_kle_rec.PAY_INVESTOR_FREQUENCY,
        l_kle_rec.PAY_INVESTOR_EVENT,
        l_kle_rec.PAY_INVESTOR_REMITTANCE_DAYS,
--financed fees
        l_kle_rec.FEE_TYPE,
--Bug#3143522 : 11.5.10
--subsidy
   l_kle_rec.SUBSIDY_ID,
   --l_kle_rec.SUBSIDIZED_OEC,
   --l_kle_rec.SUBSIDIZED_CAP_AMOUNT,
   l_kle_rec.SUBSIDY_OVERRIDE_AMOUNT,
--financed fee
   l_kle_rec.PRE_TAX_YIELD,
   l_kle_rec.AFTER_TAX_YIELD,
   l_kle_rec.IMPLICIT_INTEREST_RATE,
   l_kle_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
   l_kle_rec.PRE_TAX_IRR,
   l_kle_rec.AFTER_TAX_IRR,
--quote
   l_kle_rec.SUB_PRE_TAX_YIELD,
   l_kle_rec.SUB_AFTER_TAX_YIELD,
   l_kle_rec.SUB_IMPL_INTEREST_RATE,
   l_kle_rec.SUB_IMPL_NON_IDC_INT_RATE,
   l_kle_rec.SUB_PRE_TAX_IRR,
   l_kle_rec.SUB_AFTER_TAX_IRR,
--Bug# 2994971 :
   l_kle_rec.ITEM_INSURANCE_CATEGORY,
--Bug# 3973640: 11.5.10+
   l_kle_rec.QTE_ID,
   l_kle_rec.FUNDING_DATE,
   l_kle_rec.STREAM_TYPE_SUBCLASS,
--Bug# 4419339 OKLH
   l_kle_rec.DATE_FUNDING_EXPECTED,
   l_kle_rec.MANUFACTURER_NAME,
   l_kle_rec.MODEL_NUMBER,
   l_kle_rec.DOWN_PAYMENT_RECEIVER_CODE,
   l_kle_rec.CAPITALIZE_DOWN_PAYMENT_YN,
--Bug#4373029
   l_kle_rec.FEE_PURPOSE_CODE,
   l_kle_rec.TERMINATION_VALUE,
--Bug# 457760
   l_kle_rec.EXPECTED_ASSET_COST
        ;

Line: 1047


      SELECT
	ID,
        MAJOR_VERSION,
        KLE_ID,
        STY_ID,
        OBJECT_VERSION_NUMBER,
        LAO_AMOUNT,
        FEE_CHARGE,
        TITLE_DATE,
        DATE_RESIDUAL_LAST_REVIEW,
        DATE_LAST_REAMORTISATION,
        TERMINATION_PURCHASE_AMOUNT,
        DATE_LAST_CLEANUP,
        REMARKETED_AMOUNT,
        DATE_REMARKETED,
        REMARKET_MARGIN,
        REPURCHASED_AMOUNT,
        DATE_REPURCHASED,
        GAIN_LOSS,
        FLOOR_AMOUNT,
        PREVIOUS_CONTRACT,
        TRACKED_RESIDUAL,
        DATE_TITLE_RECEIVED,
        ESTIMATED_OEC,
        RESIDUAL_PERCENTAGE,
        CAPITAL_REDUCTION,
        VENDOR_ADVANCE_PAID,
        TRADEIN_AMOUNT,
        DELIVERED_DATE,
        YEAR_OF_MANUFACTURE,
        INITIAL_DIRECT_COST,
        OCCUPANCY,
        DATE_LAST_INSPECTION,
        DATE_NEXT_INSPECTION_DUE,
        WEIGHTED_AVERAGE_LIFE,
        BOND_EQUIVALENT_YIELD,
        REFINANCE_AMOUNT,
        YEAR_BUILT,
        COVERAGE_RATIO,
        GROSS_SQUARE_FOOTAGE,
        NET_RENTABLE,
        DATE_LETTER_ACCEPTANCE,
        DATE_COMMITMENT_EXPIRATION,
        DATE_APPRAISAL,
        APPRAISAL_VALUE,
        RESIDUAL_VALUE,
        PERCENT,
        COVERAGE,
        LRV_AMOUNT,
        AMOUNT,
        LRS_PERCENT,
        EVERGREEN_PERCENT,
        PERCENT_STAKE,
        AMOUNT_STAKE,
        DATE_SOLD,
        STY_ID_FOR,
        ATTRIBUTE_CATEGORY,
        ATTRIBUTE1,
        ATTRIBUTE2,
        ATTRIBUTE3,
        ATTRIBUTE4,
        ATTRIBUTE5,
        ATTRIBUTE6,
        ATTRIBUTE7,
        ATTRIBUTE8,
        ATTRIBUTE9,
        ATTRIBUTE10,
        ATTRIBUTE11,
        ATTRIBUTE12,
        ATTRIBUTE13,
        ATTRIBUTE14,
        ATTRIBUTE15,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATE_LOGIN,
        NTY_CODE,
        FCG_CODE,
        PRC_CODE,
        RE_LEASE_YN,
        PRESCRIBED_ASSET_YN,
        CREDIT_TENANT_YN,
        SECURED_DEAL_YN,
        CLG_ID,
        DATE_FUNDING,
        DATE_FUNDING_REQUIRED,
        DATE_ACCEPTED,
        DATE_DELIVERY_EXPECTED,
        OEC,
        CAPITAL_AMOUNT,
        RESIDUAL_GRNTY_AMOUNT,
        RESIDUAL_CODE,
        RVI_PREMIUM,
        CREDIT_NATURE,
        CAPITALIZED_INTEREST,
        CAPITAL_REDUCTION_PERCENT,
--Bug# 2697681 11.5.9
        DATE_PAY_INVESTOR_START,
        PAY_INVESTOR_FREQUENCY,
        PAY_INVESTOR_EVENT,
        PAY_INVESTOR_REMITTANCE_DAYS,
--financed fees
        FEE_TYPE,
--Bug# 3143522 : 11.5.10
--subsidy
   SUBSIDY_ID,
   --SUBSIDIZED_OEC,
   --SUBSIDIZED_CAP_AMOUNT,
   SUBSIDY_OVERRIDE_AMOUNT,
--financed fee
   PRE_TAX_YIELD,
   AFTER_TAX_YIELD,
   IMPLICIT_INTEREST_RATE,
   IMPLICIT_NON_IDC_INTEREST_RATE,
   PRE_TAX_IRR,
   AFTER_TAX_IRR,
--quote
   SUB_PRE_TAX_YIELD,
   SUB_AFTER_TAX_YIELD,
   SUB_IMPL_INTEREST_RATE,
   SUB_IMPL_NON_IDC_INT_RATE,
   SUB_PRE_TAX_IRR,
   SUB_AFTER_TAX_IRR,
--bug# 2994971
   ITEM_INSURANCE_CATEGORY,
--Bug# 3973640 :11.5.10+
   QTE_ID,
   FUNDING_DATE,
   STREAM_TYPE_SUBCLASS,
--Bug# 4419339 OKLH
   DATE_FUNDING_EXPECTED,
   MANUFACTURER_NAME,
   MODEL_NUMBER,
   DOWN_PAYMENT_RECEIVER_CODE,
   CAPITALIZE_DOWN_PAYMENT_YN,
--Bug#4373029
   FEE_PURPOSE_CODE,
   TERMINATION_VALUE,
--Bug# 4631549
   EXPECTED_ASSET_COST

      FROM OKL_K_LINES_H
      WHERE OKL_K_LINES_H.id     = p_id;

Line: 1272


        l_okl_k_lines_h_rec.LAST_UPDATED_BY,
        l_okl_k_lines_h_rec.LAST_UPDATE_DATE,
        l_okl_k_lines_h_rec.LAST_UPDATE_LOGIN,
        l_okl_k_lines_h_rec.NTY_CODE,
        l_okl_k_lines_h_rec.FCG_CODE,
        l_okl_k_lines_h_rec.PRC_CODE,
        l_okl_k_lines_h_rec.RE_LEASE_YN,
        l_okl_k_lines_h_rec.PRESCRIBED_ASSET_YN,
        l_okl_k_lines_h_rec.CREDIT_TENANT_YN,
        l_okl_k_lines_h_rec.SECURED_DEAL_YN,
        l_okl_k_lines_h_rec.CLG_ID,
        l_okl_k_lines_h_rec.DATE_FUNDING,
        l_okl_k_lines_h_rec.DATE_FUNDING_REQUIRED,
        l_okl_k_lines_h_rec.DATE_ACCEPTED,
        l_okl_k_lines_h_rec.DATE_DELIVERY_EXPECTED,
        l_okl_k_lines_h_rec.OEC,
        l_okl_k_lines_h_rec.CAPITAL_AMOUNT,
        l_okl_k_lines_h_rec.RESIDUAL_GRNTY_AMOUNT,
        l_okl_k_lines_h_rec.RESIDUAL_CODE,
        l_okl_k_lines_h_rec.RVI_PREMIUM,
        l_okl_k_lines_h_rec.CREDIT_NATURE,
        l_okl_k_lines_h_rec.CAPITALIZED_INTEREST,
        l_okl_k_lines_h_rec.CAPITAL_REDUCTION_PERCENT,
--Bug# 2697681 11.5.9
        l_okl_k_lines_h_rec.DATE_PAY_INVESTOR_START,
        l_okl_k_lines_h_rec.PAY_INVESTOR_FREQUENCY,
        l_okl_k_lines_h_rec.PAY_INVESTOR_EVENT,
        l_okl_k_lines_h_rec.PAY_INVESTOR_REMITTANCE_DAYS,
--financed fees
        l_okl_k_lines_h_rec.FEE_TYPE,
--Bug# 3143522 : 11.5.10
--subsidy
   l_okl_k_lines_h_rec.SUBSIDY_ID,
   --l_okl_k_lines_h_rec.SUBSIDIZED_OEC,
   --l_okl_k_lines_h_rec.SUBSIDIZED_CAP_AMOUNT,
   l_okl_k_lines_h_rec.SUBSIDY_OVERRIDE_AMOUNT,
   --financed fee
   l_okl_k_lines_h_rec.PRE_TAX_YIELD,
   l_okl_k_lines_h_rec.AFTER_TAX_YIELD,
   l_okl_k_lines_h_rec.IMPLICIT_INTEREST_RATE,
   l_okl_k_lines_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
   l_okl_k_lines_h_rec.PRE_TAX_IRR,
   l_okl_k_lines_h_rec.AFTER_TAX_IRR,
--quote
   l_okl_k_lines_h_rec.SUB_PRE_TAX_YIELD,
   l_okl_k_lines_h_rec.SUB_AFTER_TAX_YIELD,
   l_okl_k_lines_h_rec.SUB_IMPL_INTEREST_RATE,
   l_okl_k_lines_h_rec.SUB_IMPL_NON_IDC_INT_RATE,
   l_okl_k_lines_h_rec.SUB_PRE_TAX_IRR,
   l_okl_k_lines_h_rec.SUB_AFTER_TAX_IRR,
--Bug# 2994971
   l_okl_k_lines_h_rec.ITEM_INSURANCE_CATEGORY,
--Bug# 3973640 11.5.10+
   l_okl_k_lines_h_rec.QTE_ID,
   l_okl_k_lines_h_rec.FUNDING_DATE,
   l_okl_k_lines_h_rec.STREAM_TYPE_SUBCLASS,
   --Bug# 4419339 OKLH
   l_okl_k_lines_h_rec.DATE_FUNDING_EXPECTED,
   l_okl_k_lines_h_rec.MANUFACTURER_NAME,
   l_okl_k_lines_h_rec.MODEL_NUMBER,
   l_okl_k_lines_h_rec.DOWN_PAYMENT_RECEIVER_CODE,
   l_okl_k_lines_h_rec.CAPITALIZE_DOWN_PAYMENT_YN,
--Bug#4373029
   l_okl_k_lines_h_rec.FEE_PURPOSE_CODE,
   l_okl_k_lines_h_rec.TERMINATION_VALUE,
--Bug# 4631549
   l_okl_k_lines_h_rec.EXPECTED_ASSET_COST
         ;

Line: 1362


      SELECT
	ID,
        OBJECT_VERSION_NUMBER,
        KLE_ID,
        STY_ID,
        PRC_CODE,
        FCG_CODE,
        NTY_CODE,
        ESTIMATED_OEC,
        LAO_AMOUNT,
        TITLE_DATE,
        FEE_CHARGE,
        LRS_PERCENT,
        INITIAL_DIRECT_COST,
        PERCENT_STAKE,
        PERCENT,
        EVERGREEN_PERCENT,
        AMOUNT_STAKE,
        OCCUPANCY,
        COVERAGE,
        RESIDUAL_PERCENTAGE,
        DATE_LAST_INSPECTION,
        DATE_SOLD,
        LRV_AMOUNT,
        CAPITAL_REDUCTION,
        DATE_NEXT_INSPECTION_DUE,
        DATE_RESIDUAL_LAST_REVIEW,
        DATE_LAST_REAMORTISATION,
        VENDOR_ADVANCE_PAID,
        WEIGHTED_AVERAGE_LIFE,
        TRADEIN_AMOUNT,
        BOND_EQUIVALENT_YIELD,
        TERMINATION_PURCHASE_AMOUNT,
        REFINANCE_AMOUNT,
        YEAR_BUILT,
        DELIVERED_DATE,
        CREDIT_TENANT_YN,
        DATE_LAST_CLEANUP,
        YEAR_OF_MANUFACTURE,
        COVERAGE_RATIO,
        REMARKETED_AMOUNT,
        GROSS_SQUARE_FOOTAGE,
        PRESCRIBED_ASSET_YN,
        DATE_REMARKETED,
        NET_RENTABLE,
        REMARKET_MARGIN,
        DATE_LETTER_ACCEPTANCE,
        REPURCHASED_AMOUNT,
        DATE_COMMITMENT_EXPIRATION,
        DATE_REPURCHASED,
        DATE_APPRAISAL,
        RESIDUAL_VALUE,
        APPRAISAL_VALUE,
        SECURED_DEAL_YN,
        GAIN_LOSS,
        FLOOR_AMOUNT,
        RE_LEASE_YN,
        PREVIOUS_CONTRACT,
        TRACKED_RESIDUAL,
        DATE_TITLE_RECEIVED,
        AMOUNT,
        ATTRIBUTE_CATEGORY,
        ATTRIBUTE1,
        ATTRIBUTE2,
        ATTRIBUTE3,
        ATTRIBUTE4,
        ATTRIBUTE5,
        ATTRIBUTE6,
        ATTRIBUTE7,
        ATTRIBUTE8,
        ATTRIBUTE9,
        ATTRIBUTE10,
        ATTRIBUTE11,
        ATTRIBUTE12,
        ATTRIBUTE13,
        ATTRIBUTE14,
        ATTRIBUTE15,
        STY_ID_FOR,
        CLG_ID,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATE_LOGIN,
        DATE_FUNDING,
        DATE_FUNDING_REQUIRED,
        DATE_ACCEPTED,
        DATE_DELIVERY_EXPECTED,
        OEC,
        CAPITAL_AMOUNT,
        RESIDUAL_GRNTY_AMOUNT,
        RESIDUAL_CODE,
        RVI_PREMIUM,
        CREDIT_NATURE,
        CAPITALIZED_INTEREST,
        CAPITAL_REDUCTION_PERCENT,
--Bug# 2697681 11.5.9
        DATE_PAY_INVESTOR_START,
        PAY_INVESTOR_FREQUENCY,
        PAY_INVESTOR_EVENT,
        PAY_INVESTOR_REMITTANCE_DAYS,
--financed fees
        FEE_TYPE,
--Bug#3143522 : 11.5.10
--subsidy
   SUBSIDY_ID,
   --SUBSIDIZED_OEC,
   --SUBSIDIZED_CAP_AMOUNT,
   SUBSIDY_OVERRIDE_AMOUNT,
--financed fee
   PRE_TAX_YIELD,
   AFTER_TAX_YIELD,
   IMPLICIT_INTEREST_RATE,
   IMPLICIT_NON_IDC_INTEREST_RATE,
   PRE_TAX_IRR,
   AFTER_TAX_IRR,
--quote
   SUB_PRE_TAX_YIELD,
   SUB_AFTER_TAX_YIELD,
   SUB_IMPL_INTEREST_RATE,
   SUB_IMPL_NON_IDC_INT_RATE,
   SUB_PRE_TAX_IRR,
   SUB_AFTER_TAX_IRR,
--Bug# 2994971
   ITEM_INSURANCE_CATEGORY,
--Bug# 3973640 11.5.10+
   QTE_ID,
   FUNDING_DATE,
   STREAM_TYPE_SUBCLASS,
--Bug# 4419339 OKLH
   DATE_FUNDING_EXPECTED,
   MANUFACTURER_NAME,
   MODEL_NUMBER,
   DOWN_PAYMENT_RECEIVER_CODE,
   CAPITALIZE_DOWN_PAYMENT_YN,
--Bug#4373029
   FEE_PURPOSE_CODE,
   TERMINATION_VALUE,
--Bug# 4631549
   EXPECTED_ASSET_COST


      FROM OKL_K_LINES_V
      WHERE OKL_K_LINES_V.id     = p_id;

Line: 1594


        l_klev_rec.LAST_UPDATED_BY,
        l_klev_rec.LAST_UPDATE_DATE,
        l_klev_rec.LAST_UPDATE_LOGIN,
        l_klev_rec.DATE_FUNDING,
        l_klev_rec.DATE_FUNDING_REQUIRED,
        l_klev_rec.DATE_ACCEPTED,
        l_klev_rec.DATE_DELIVERY_EXPECTED,
        l_klev_rec.OEC,
        l_klev_rec.CAPITAL_AMOUNT,
        l_klev_rec.RESIDUAL_GRNTY_AMOUNT,
        l_klev_rec.RESIDUAL_CODE,
        l_klev_rec.RVI_PREMIUM,
        l_klev_rec.CREDIT_NATURE,
        l_klev_rec.CAPITALIZED_INTEREST,
        l_klev_rec.CAPITAL_REDUCTION_PERCENT,
--Bug# 2697681 11.5.9
        l_klev_rec.DATE_PAY_INVESTOR_START,
        l_klev_rec.PAY_INVESTOR_FREQUENCY,
        l_klev_rec.PAY_INVESTOR_EVENT,
        l_klev_rec.PAY_INVESTOR_REMITTANCE_DAYS,
--financed fees
        l_klev_rec.FEE_TYPE,
--Bug# 3143522 : 11.5.10
--subsidy
   l_klev_rec.SUBSIDY_ID,
   --l_klev_rec.SUBSIDIZED_OEC,
   --l_klev_rec.SUBSIDIZED_CAP_AMOUNT,
   l_klev_rec.SUBSIDY_OVERRIDE_AMOUNT,
--financed fee
   l_klev_rec.PRE_TAX_YIELD,
   l_klev_rec.AFTER_TAX_YIELD,
   l_klev_rec.IMPLICIT_INTEREST_RATE,
   l_klev_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
   l_klev_rec.PRE_TAX_IRR,
   l_klev_rec.AFTER_TAX_IRR,
--quote
   l_klev_rec.SUB_PRE_TAX_YIELD,
   l_klev_rec.SUB_AFTER_TAX_YIELD,
   l_klev_rec.SUB_IMPL_INTEREST_RATE,
   l_klev_rec.SUB_IMPL_NON_IDC_INT_RATE,
   l_klev_rec.SUB_PRE_TAX_IRR,
   l_klev_rec.SUB_AFTER_TAX_IRR,
--Bug# 2994971
   l_klev_rec.ITEM_INSURANCE_CATEGORY,
--Bug# 3973640 - 11.5.10+
   l_klev_rec.QTE_ID,
   l_klev_rec.FUNDING_DATE,
   l_klev_rec.STREAM_TYPE_SUBCLASS,
--Bug# 4419339 OKLH
   l_klev_rec.DATE_FUNDING_EXPECTED,
   l_klev_rec.MANUFACTURER_NAME,
   l_klev_rec.MODEL_NUMBER,
   l_klev_rec.DOWN_PAYMENT_RECEIVER_CODE,
   l_klev_rec.CAPITALIZE_DOWN_PAYMENT_YN,
--Bug#4373029
   l_klev_rec.FEE_PURPOSE_CODE,
   l_klev_rec.TERMINATION_VALUE,
--Bug# 4631549
   l_klev_rec.EXPECTED_ASSET_COST
;

Line: 1997


    IF (l_klev_rec.LAST_UPDATED_BY = OKC_API.G_MISS_NUM) THEN
      l_klev_rec.LAST_UPDATED_BY := NULL;

Line: 2001


    IF (l_klev_rec.LAST_UPDATE_DATE = OKC_API.G_MISS_DATE) THEN
      l_klev_rec.LAST_UPDATE_DATE := NULL;

Line: 2005


    IF (l_klev_rec.LAST_UPDATE_LOGIN = OKC_API.G_MISS_NUM) THEN
      l_klev_rec.LAST_UPDATE_LOGIN := NULL;

Line: 2352


      p_to.LAST_UPDATED_BY := p_from.LAST_UPDATED_BY;

Line: 2354


      p_to.LAST_UPDATE_DATE := p_from.LAST_UPDATE_DATE;

Line: 2356


      p_to.LAST_UPDATE_LOGIN := p_from.LAST_UPDATE_LOGIN;

Line: 2597


      p_to.LAST_UPDATED_BY := p_from.LAST_UPDATED_BY;

Line: 2599


      p_to.LAST_UPDATE_DATE := p_from.LAST_UPDATE_DATE;

Line: 2601


      p_to.LAST_UPDATE_LOGIN := p_from.LAST_UPDATE_LOGIN;

Line: 2841


      p_to.LAST_UPDATED_BY := p_from.LAST_UPDATED_BY;

Line: 2843


      p_to.LAST_UPDATE_DATE := p_from.LAST_UPDATE_DATE;

Line: 2845


      p_to.LAST_UPDATE_LOGIN := p_from.LAST_UPDATE_LOGIN;

Line: 3107


  PROCEDURE insert_row(

    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_okl_k_lines_h_rec                     IN okl_k_lines_h_rec_type,
    x_okl_k_lines_h_rec                     OUT NOCOPY okl_k_lines_h_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3118


    l_api_name                     CONSTANT VARCHAR2(30) := 'rec_insert_row';

Line: 3159


    INSERT INTO OKL_K_LINES_H(
	ID,
        MAJOR_VERSION,
        KLE_ID,
        STY_ID,
        OBJECT_VERSION_NUMBER,
        LAO_AMOUNT,
        FEE_CHARGE,
        TITLE_DATE,
        DATE_RESIDUAL_LAST_REVIEW,
        DATE_LAST_REAMORTISATION,
        TERMINATION_PURCHASE_AMOUNT,
        DATE_LAST_CLEANUP,
        REMARKETED_AMOUNT,
        DATE_REMARKETED,
        REMARKET_MARGIN,
        REPURCHASED_AMOUNT,
        DATE_REPURCHASED,
        GAIN_LOSS,
        FLOOR_AMOUNT,
        PREVIOUS_CONTRACT,
        TRACKED_RESIDUAL,
        DATE_TITLE_RECEIVED,
        ESTIMATED_OEC,
        RESIDUAL_PERCENTAGE,
        CAPITAL_REDUCTION,
        VENDOR_ADVANCE_PAID,
        TRADEIN_AMOUNT,
        DELIVERED_DATE,
        YEAR_OF_MANUFACTURE,
        INITIAL_DIRECT_COST,
        OCCUPANCY,
        DATE_LAST_INSPECTION,
        DATE_NEXT_INSPECTION_DUE,
        WEIGHTED_AVERAGE_LIFE,
        BOND_EQUIVALENT_YIELD,
        REFINANCE_AMOUNT,
        YEAR_BUILT,
        COVERAGE_RATIO,
        GROSS_SQUARE_FOOTAGE,
        NET_RENTABLE,
        DATE_LETTER_ACCEPTANCE,
        DATE_COMMITMENT_EXPIRATION,
        DATE_APPRAISAL,
        APPRAISAL_VALUE,
        RESIDUAL_VALUE,
        PERCENT,
        COVERAGE,
        LRV_AMOUNT,
        AMOUNT,
        LRS_PERCENT,
        EVERGREEN_PERCENT,
        PERCENT_STAKE,
        AMOUNT_STAKE,
        DATE_SOLD,
        STY_ID_FOR,
        ATTRIBUTE_CATEGORY,
        ATTRIBUTE1,
        ATTRIBUTE2,
        ATTRIBUTE3,
        ATTRIBUTE4,
        ATTRIBUTE5,
        ATTRIBUTE6,
        ATTRIBUTE7,
        ATTRIBUTE8,
        ATTRIBUTE9,
        ATTRIBUTE10,
        ATTRIBUTE11,
        ATTRIBUTE12,
        ATTRIBUTE13,
        ATTRIBUTE14,
        ATTRIBUTE15,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATE_LOGIN,
        NTY_CODE,
        FCG_CODE,
        PRC_CODE,
        RE_LEASE_YN,
        PRESCRIBED_ASSET_YN,
        CREDIT_TENANT_YN,
        SECURED_DEAL_YN,
        CLG_ID,
        DATE_FUNDING,
        DATE_FUNDING_REQUIRED,
        DATE_ACCEPTED,
        DATE_DELIVERY_EXPECTED,
        OEC,
        CAPITAL_AMOUNT,
        RESIDUAL_GRNTY_AMOUNT,
        RESIDUAL_CODE,
        RVI_PREMIUM,
        CREDIT_NATURE,
        CAPITALIZED_INTEREST,
        CAPITAL_REDUCTION_PERCENT,
--Bug# 2697681 11.5.9
        DATE_PAY_INVESTOR_START,
        PAY_INVESTOR_FREQUENCY,
        PAY_INVESTOR_EVENT,
        PAY_INVESTOR_REMITTANCE_DAYS,
--financed fees
        FEE_TYPE,
--Bug# 3143522 : 11.5.10
   --subsidy
   SUBSIDY_ID,
   --SUBSIDIZED_OEC,
   --SUBSIDIZED_CAP_AMOUNT,
   SUBSIDY_OVERRIDE_AMOUNT,
   --financed fee
   PRE_TAX_YIELD,
   AFTER_TAX_YIELD,
   IMPLICIT_INTEREST_RATE,
   IMPLICIT_NON_IDC_INTEREST_RATE,
   PRE_TAX_IRR,
   AFTER_TAX_IRR,
--quote
   SUB_PRE_TAX_YIELD,
   SUB_AFTER_TAX_YIELD,
   SUB_IMPL_INTEREST_RATE,
   SUB_IMPL_NON_IDC_INT_RATE,
   SUB_PRE_TAX_IRR,
   SUB_AFTER_TAX_IRR,
--Bug# 2994971
   ITEM_INSURANCE_CATEGORY,
--Bug# 3973640 :11.5.10+
   QTE_ID,
   FUNDING_DATE,
   STREAM_TYPE_SUBCLASS,
--Bug# 4419339  OKLH
   DATE_FUNDING_EXPECTED,
   MANUFACTURER_NAME,
   MODEL_NUMBER,
   DOWN_PAYMENT_RECEIVER_CODE,
   CAPITALIZE_DOWN_PAYMENT_YN,
--Bug#4373029
   FEE_PURPOSE_CODE,
   TERMINATION_VALUE,
--Bug# 4631549
   EXPECTED_ASSET_COST

        )
      VALUES (
       l_okl_k_lines_h_rec.ID,
        l_okl_k_lines_h_rec.MAJOR_VERSION,
        l_okl_k_lines_h_rec.KLE_ID,
        l_okl_k_lines_h_rec.STY_ID,
        l_okl_k_lines_h_rec.OBJECT_VERSION_NUMBER,
        l_okl_k_lines_h_rec.LAO_AMOUNT,
        l_okl_k_lines_h_rec.FEE_CHARGE,
        l_okl_k_lines_h_rec.TITLE_DATE,
        l_okl_k_lines_h_rec.DATE_RESIDUAL_LAST_REVIEW,
        l_okl_k_lines_h_rec.DATE_LAST_REAMORTISATION,
        l_okl_k_lines_h_rec.TERMINATION_PURCHASE_AMOUNT,
        l_okl_k_lines_h_rec.DATE_LAST_CLEANUP,
        l_okl_k_lines_h_rec.REMARKETED_AMOUNT,
        l_okl_k_lines_h_rec.DATE_REMARKETED,
        l_okl_k_lines_h_rec.REMARKET_MARGIN,
        l_okl_k_lines_h_rec.REPURCHASED_AMOUNT,
        l_okl_k_lines_h_rec.DATE_REPURCHASED,
        l_okl_k_lines_h_rec.GAIN_LOSS,
        l_okl_k_lines_h_rec.FLOOR_AMOUNT,
        l_okl_k_lines_h_rec.PREVIOUS_CONTRACT,
        l_okl_k_lines_h_rec.TRACKED_RESIDUAL,
        l_okl_k_lines_h_rec.DATE_TITLE_RECEIVED,
        l_okl_k_lines_h_rec.ESTIMATED_OEC,
        l_okl_k_lines_h_rec.RESIDUAL_PERCENTAGE,
        l_okl_k_lines_h_rec.CAPITAL_REDUCTION,
        l_okl_k_lines_h_rec.VENDOR_ADVANCE_PAID,
        l_okl_k_lines_h_rec.TRADEIN_AMOUNT,
        l_okl_k_lines_h_rec.DELIVERED_DATE,
        l_okl_k_lines_h_rec.YEAR_OF_MANUFACTURE,
        l_okl_k_lines_h_rec.INITIAL_DIRECT_COST,
        l_okl_k_lines_h_rec.OCCUPANCY,
        l_okl_k_lines_h_rec.DATE_LAST_INSPECTION,
        l_okl_k_lines_h_rec.DATE_NEXT_INSPECTION_DUE,
        l_okl_k_lines_h_rec.WEIGHTED_AVERAGE_LIFE,
        l_okl_k_lines_h_rec.BOND_EQUIVALENT_YIELD,
        l_okl_k_lines_h_rec.REFINANCE_AMOUNT,
        l_okl_k_lines_h_rec.YEAR_BUILT,
        l_okl_k_lines_h_rec.COVERAGE_RATIO,
        l_okl_k_lines_h_rec.GROSS_SQUARE_FOOTAGE,
        l_okl_k_lines_h_rec.NET_RENTABLE,
        l_okl_k_lines_h_rec.DATE_LETTER_ACCEPTANCE,
        l_okl_k_lines_h_rec.DATE_COMMITMENT_EXPIRATION,
        l_okl_k_lines_h_rec.DATE_APPRAISAL,
        l_okl_k_lines_h_rec.APPRAISAL_VALUE,
        l_okl_k_lines_h_rec.RESIDUAL_VALUE,
        l_okl_k_lines_h_rec.PERCENT,
        l_okl_k_lines_h_rec.COVERAGE,
        l_okl_k_lines_h_rec.LRV_AMOUNT,
        l_okl_k_lines_h_rec.AMOUNT,
        l_okl_k_lines_h_rec.LRS_PERCENT,
        l_okl_k_lines_h_rec.EVERGREEN_PERCENT,
        l_okl_k_lines_h_rec.PERCENT_STAKE,
        l_okl_k_lines_h_rec.AMOUNT_STAKE,
        l_okl_k_lines_h_rec.DATE_SOLD,
        l_okl_k_lines_h_rec.STY_ID_FOR,
        l_okl_k_lines_h_rec.ATTRIBUTE_CATEGORY,
        l_okl_k_lines_h_rec.ATTRIBUTE1,
        l_okl_k_lines_h_rec.ATTRIBUTE2,
        l_okl_k_lines_h_rec.ATTRIBUTE3,
        l_okl_k_lines_h_rec.ATTRIBUTE4,
        l_okl_k_lines_h_rec.ATTRIBUTE5,
        l_okl_k_lines_h_rec.ATTRIBUTE6,
        l_okl_k_lines_h_rec.ATTRIBUTE7,
        l_okl_k_lines_h_rec.ATTRIBUTE8,
        l_okl_k_lines_h_rec.ATTRIBUTE9,
        l_okl_k_lines_h_rec.ATTRIBUTE10,
        l_okl_k_lines_h_rec.ATTRIBUTE11,
        l_okl_k_lines_h_rec.ATTRIBUTE12,
        l_okl_k_lines_h_rec.ATTRIBUTE13,
        l_okl_k_lines_h_rec.ATTRIBUTE14,
        l_okl_k_lines_h_rec.ATTRIBUTE15,
        l_okl_k_lines_h_rec.CREATED_BY,
        l_okl_k_lines_h_rec.CREATION_DATE,
        l_okl_k_lines_h_rec.LAST_UPDATED_BY,
        l_okl_k_lines_h_rec.LAST_UPDATE_DATE,
        l_okl_k_lines_h_rec.LAST_UPDATE_LOGIN,
        l_okl_k_lines_h_rec.NTY_CODE,
        l_okl_k_lines_h_rec.FCG_CODE,
        l_okl_k_lines_h_rec.PRC_CODE,
        l_okl_k_lines_h_rec.RE_LEASE_YN,
        l_okl_k_lines_h_rec.PRESCRIBED_ASSET_YN,
        l_okl_k_lines_h_rec.CREDIT_TENANT_YN,
        l_okl_k_lines_h_rec.SECURED_DEAL_YN,
        l_okl_k_lines_h_rec.CLG_ID,
        l_okl_k_lines_h_rec.DATE_FUNDING,
        l_okl_k_lines_h_rec.DATE_FUNDING_REQUIRED,
        l_okl_k_lines_h_rec.DATE_ACCEPTED,
        l_okl_k_lines_h_rec.DATE_DELIVERY_EXPECTED,
        l_okl_k_lines_h_rec.OEC,
        l_okl_k_lines_h_rec.CAPITAL_AMOUNT,
        l_okl_k_lines_h_rec.RESIDUAL_GRNTY_AMOUNT,
        l_okl_k_lines_h_rec.RESIDUAL_CODE,
        l_okl_k_lines_h_rec.RVI_PREMIUM,
        l_okl_k_lines_h_rec.CREDIT_NATURE,
        l_okl_k_lines_h_rec.CAPITALIZED_INTEREST,
        l_okl_k_lines_h_rec.CAPITAL_REDUCTION_PERCENT,
--Bug# 2697681 11.5.9
        l_okl_k_lines_h_rec.DATE_PAY_INVESTOR_START,
        l_okl_k_lines_h_rec.PAY_INVESTOR_FREQUENCY,
        l_okl_k_lines_h_rec.PAY_INVESTOR_EVENT,
        l_okl_k_lines_h_rec.PAY_INVESTOR_REMITTANCE_DAYS,
--financed fees
        l_okl_k_lines_h_rec.FEE_TYPE,
--Bug# 3143522: 11.5.10
   --subsidy
   l_okl_k_lines_h_rec.SUBSIDY_ID,
   --l_okl_k_lines_h_rec.SUBSIDIZED_OEC,
   --l_okl_k_lines_h_rec.SUBSIDIZED_CAP_AMOUNT,
   l_okl_k_lines_h_rec.SUBSIDY_OVERRIDE_AMOUNT,
   --financed fee
   l_okl_k_lines_h_rec.PRE_TAX_YIELD,
   l_okl_k_lines_h_rec.AFTER_TAX_YIELD,
   l_okl_k_lines_h_rec.IMPLICIT_INTEREST_RATE,
   l_okl_k_lines_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
   l_okl_k_lines_h_rec.PRE_TAX_IRR,
   l_okl_k_lines_h_rec.AFTER_TAX_IRR,
--quote
   l_okl_k_lines_h_rec.SUB_PRE_TAX_YIELD,
   l_okl_k_lines_h_rec.SUB_AFTER_TAX_YIELD,
   l_okl_k_lines_h_rec.SUB_IMPL_INTEREST_RATE,
   l_okl_k_lines_h_rec.SUB_IMPL_NON_IDC_INT_RATE,
   l_okl_k_lines_h_rec.SUB_PRE_TAX_IRR,
   l_okl_k_lines_h_rec.SUB_AFTER_TAX_IRR,
--Bug#2994971
   l_okl_k_lines_h_rec.ITEM_INSURANCE_CATEGORY,
--Bug# 3973640: 11.5.10+
   l_okl_k_lines_h_rec.QTE_ID,
   l_okl_k_lines_h_rec.FUNDING_DATE,
   l_okl_k_lines_h_rec.STREAM_TYPE_SUBCLASS,
--Bug# 4419339  OKLH
   l_okl_k_lines_h_rec.DATE_FUNDING_EXPECTED,
   l_okl_k_lines_h_rec.MANUFACTURER_NAME,
   l_okl_k_lines_h_rec.MODEL_NUMBER,
   l_okl_k_lines_h_rec.DOWN_PAYMENT_RECEIVER_CODE,
   l_okl_k_lines_h_rec.CAPITALIZE_DOWN_PAYMENT_YN,
--Bug#4373029
   l_okl_k_lines_h_rec.FEE_PURPOSE_CODE,
   l_okl_k_lines_h_rec.TERMINATION_VALUE,
--Bug# 4631549
   l_okl_k_lines_h_rec.EXPECTED_ASSET_COST

        );

Line: 3481


  END insert_row;

Line: 3487


  PROCEDURE insert_row(

    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_kle_rec                     IN kle_rec_type,
    x_kle_rec                     OUT NOCOPY kle_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3498


    l_api_name                     CONSTANT VARCHAR2(30) := 'rec_insert_row';

Line: 3539


    INSERT INTO OKL_K_LINES(
	ID,
        KLE_ID,
        STY_ID,
        OBJECT_VERSION_NUMBER,
        LAO_AMOUNT,
        FEE_CHARGE,
        TITLE_DATE,
        DATE_RESIDUAL_LAST_REVIEW,
        DATE_LAST_REAMORTISATION,
        TERMINATION_PURCHASE_AMOUNT,
        DATE_LAST_CLEANUP,
        REMARKETED_AMOUNT,
        DATE_REMARKETED,
        REMARKET_MARGIN,
        REPURCHASED_AMOUNT,
        DATE_REPURCHASED,
        GAIN_LOSS,
        FLOOR_AMOUNT,
        PREVIOUS_CONTRACT,
        TRACKED_RESIDUAL,
        DATE_TITLE_RECEIVED,
        ESTIMATED_OEC,
        RESIDUAL_PERCENTAGE,
        CAPITAL_REDUCTION,
        VENDOR_ADVANCE_PAID,
        TRADEIN_AMOUNT,
        DELIVERED_DATE,
        YEAR_OF_MANUFACTURE,
        INITIAL_DIRECT_COST,
        OCCUPANCY,
        DATE_LAST_INSPECTION,
        DATE_NEXT_INSPECTION_DUE,
        WEIGHTED_AVERAGE_LIFE,
        BOND_EQUIVALENT_YIELD,
        REFINANCE_AMOUNT,
        YEAR_BUILT,
        COVERAGE_RATIO,
        GROSS_SQUARE_FOOTAGE,
        NET_RENTABLE,
        DATE_LETTER_ACCEPTANCE,
        DATE_COMMITMENT_EXPIRATION,
        DATE_APPRAISAL,
        APPRAISAL_VALUE,
        RESIDUAL_VALUE,
        PERCENT,
        COVERAGE,
        LRV_AMOUNT,
        AMOUNT,
        LRS_PERCENT,
        EVERGREEN_PERCENT,
        PERCENT_STAKE,
        AMOUNT_STAKE,
        DATE_SOLD,
        STY_ID_FOR,
        ATTRIBUTE_CATEGORY,
        ATTRIBUTE1,
        ATTRIBUTE2,
        ATTRIBUTE3,
        ATTRIBUTE4,
        ATTRIBUTE5,
        ATTRIBUTE6,
        ATTRIBUTE7,
        ATTRIBUTE8,
        ATTRIBUTE9,
        ATTRIBUTE10,
        ATTRIBUTE11,
        ATTRIBUTE12,
        ATTRIBUTE13,
        ATTRIBUTE14,
        ATTRIBUTE15,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATE_LOGIN,
        NTY_CODE,
        FCG_CODE,
        PRC_CODE,
        RE_LEASE_YN,
        PRESCRIBED_ASSET_YN,
        CREDIT_TENANT_YN,
        SECURED_DEAL_YN,
        CLG_ID,
        DATE_FUNDING,
        DATE_FUNDING_REQUIRED,
        DATE_ACCEPTED,
        DATE_DELIVERY_EXPECTED,
        OEC,
        CAPITAL_AMOUNT,
        RESIDUAL_GRNTY_AMOUNT,
        RESIDUAL_CODE,
        RVI_PREMIUM,
        CREDIT_NATURE,
        CAPITALIZED_INTEREST,
        CAPITAL_REDUCTION_PERCENT,
--Bug# 2697681 11.5.9
        DATE_PAY_INVESTOR_START,
        PAY_INVESTOR_FREQUENCY,
        PAY_INVESTOR_EVENT,
        PAY_INVESTOR_REMITTANCE_DAYS,
--financed fees
        FEE_TYPE,
-- Bug# 3143522 : 11.5.10
   --subsidy
   SUBSIDY_ID,
   --SUBSIDIZED_OEC,
   --SUBSIDIZED_CAP_AMOUNT,
   SUBSIDY_OVERRIDE_AMOUNT,
   --financed fee
   PRE_TAX_YIELD,
   AFTER_TAX_YIELD,
   IMPLICIT_INTEREST_RATE,
   IMPLICIT_NON_IDC_INTEREST_RATE,
   PRE_TAX_IRR,
   AFTER_TAX_IRR,
--quote
   SUB_PRE_TAX_YIELD,
   SUB_AFTER_TAX_YIELD,
   SUB_IMPL_INTEREST_RATE,
   SUB_IMPL_NON_IDC_INT_RATE,
   SUB_PRE_TAX_IRR,
   SUB_AFTER_TAX_IRR,
--Bug# 2994971
   ITEM_INSURANCE_CATEGORY,
-- Bug# 3973640 :11.5.10+
   QTE_ID,
   FUNDING_DATE,
   STREAM_TYPE_SUBCLASS,
--Bug# 4419339  OKLH
   DATE_FUNDING_EXPECTED,
   MANUFACTURER_NAME,
   MODEL_NUMBER,
   DOWN_PAYMENT_RECEIVER_CODE,
   CAPITALIZE_DOWN_PAYMENT_YN,
--Bug#4373029
   FEE_PURPOSE_CODE,
   TERMINATION_VALUE,
--Bug# 4631549
   EXPECTED_ASSET_COST
        )
      VALUES (
       l_kle_rec.ID,
        l_kle_rec.KLE_ID,
        l_kle_rec.STY_ID,
        l_kle_rec.OBJECT_VERSION_NUMBER,
        l_kle_rec.LAO_AMOUNT,
        l_kle_rec.FEE_CHARGE,
        l_kle_rec.TITLE_DATE,
        l_kle_rec.DATE_RESIDUAL_LAST_REVIEW,
        l_kle_rec.DATE_LAST_REAMORTISATION,
        l_kle_rec.TERMINATION_PURCHASE_AMOUNT,
        l_kle_rec.DATE_LAST_CLEANUP,
        l_kle_rec.REMARKETED_AMOUNT,
        l_kle_rec.DATE_REMARKETED,
        l_kle_rec.REMARKET_MARGIN,
        l_kle_rec.REPURCHASED_AMOUNT,
        l_kle_rec.DATE_REPURCHASED,
        l_kle_rec.GAIN_LOSS,
        l_kle_rec.FLOOR_AMOUNT,
        l_kle_rec.PREVIOUS_CONTRACT,
        l_kle_rec.TRACKED_RESIDUAL,
        l_kle_rec.DATE_TITLE_RECEIVED,
        l_kle_rec.ESTIMATED_OEC,
        l_kle_rec.RESIDUAL_PERCENTAGE,
        l_kle_rec.CAPITAL_REDUCTION,
        l_kle_rec.VENDOR_ADVANCE_PAID,
        l_kle_rec.TRADEIN_AMOUNT,
        l_kle_rec.DELIVERED_DATE,
        l_kle_rec.YEAR_OF_MANUFACTURE,
        l_kle_rec.INITIAL_DIRECT_COST,
        l_kle_rec.OCCUPANCY,
        l_kle_rec.DATE_LAST_INSPECTION,
        l_kle_rec.DATE_NEXT_INSPECTION_DUE,
        l_kle_rec.WEIGHTED_AVERAGE_LIFE,
        l_kle_rec.BOND_EQUIVALENT_YIELD,
        l_kle_rec.REFINANCE_AMOUNT,
        l_kle_rec.YEAR_BUILT,
        l_kle_rec.COVERAGE_RATIO,
        l_kle_rec.GROSS_SQUARE_FOOTAGE,
        l_kle_rec.NET_RENTABLE,
        l_kle_rec.DATE_LETTER_ACCEPTANCE,
        l_kle_rec.DATE_COMMITMENT_EXPIRATION,
        l_kle_rec.DATE_APPRAISAL,
        l_kle_rec.APPRAISAL_VALUE,
        l_kle_rec.RESIDUAL_VALUE,
        l_kle_rec.PERCENT,
        l_kle_rec.COVERAGE,
        l_kle_rec.LRV_AMOUNT,
        l_kle_rec.AMOUNT,
        l_kle_rec.LRS_PERCENT,
        l_kle_rec.EVERGREEN_PERCENT,
        l_kle_rec.PERCENT_STAKE,
        l_kle_rec.AMOUNT_STAKE,
        l_kle_rec.DATE_SOLD,
        l_kle_rec.STY_ID_FOR,
        l_kle_rec.ATTRIBUTE_CATEGORY,
        l_kle_rec.ATTRIBUTE1,
        l_kle_rec.ATTRIBUTE2,
        l_kle_rec.ATTRIBUTE3,
        l_kle_rec.ATTRIBUTE4,
        l_kle_rec.ATTRIBUTE5,
        l_kle_rec.ATTRIBUTE6,
        l_kle_rec.ATTRIBUTE7,
        l_kle_rec.ATTRIBUTE8,
        l_kle_rec.ATTRIBUTE9,
        l_kle_rec.ATTRIBUTE10,
        l_kle_rec.ATTRIBUTE11,
        l_kle_rec.ATTRIBUTE12,
        l_kle_rec.ATTRIBUTE13,
        l_kle_rec.ATTRIBUTE14,
        l_kle_rec.ATTRIBUTE15,
        l_kle_rec.CREATED_BY,
        l_kle_rec.CREATION_DATE,
        l_kle_rec.LAST_UPDATED_BY,
        l_kle_rec.LAST_UPDATE_DATE,
        l_kle_rec.LAST_UPDATE_LOGIN,
        l_kle_rec.NTY_CODE,
        l_kle_rec.FCG_CODE,
        l_kle_rec.PRC_CODE,
        l_kle_rec.RE_LEASE_YN,
        l_kle_rec.PRESCRIBED_ASSET_YN,
        l_kle_rec.CREDIT_TENANT_YN,
        l_kle_rec.SECURED_DEAL_YN,
        l_kle_rec.CLG_ID,
        l_kle_rec.DATE_FUNDING,
        l_kle_rec.DATE_FUNDING_REQUIRED,
        l_kle_rec.DATE_ACCEPTED,
        l_kle_rec.DATE_DELIVERY_EXPECTED,
        l_kle_rec.OEC,
        l_kle_rec.CAPITAL_AMOUNT,
        l_kle_rec.RESIDUAL_GRNTY_AMOUNT,
        l_kle_rec.RESIDUAL_CODE,
        l_kle_rec.RVI_PREMIUM,
        l_kle_rec.CREDIT_NATURE,
        l_kle_rec.CAPITALIZED_INTEREST,
        l_kle_rec.CAPITAL_REDUCTION_PERCENT,
--Bug# 2697681 11.5.9
        l_kle_rec.DATE_PAY_INVESTOR_START,
        l_kle_rec.PAY_INVESTOR_FREQUENCY,
        l_kle_rec.PAY_INVESTOR_EVENT,
        l_kle_rec.PAY_INVESTOR_REMITTANCE_DAYS,
--financed fees
        l_kle_rec.FEE_TYPE,
--Bug# 3143522: 11.5.10
   --subsidy
   l_kle_rec.SUBSIDY_ID,
   --l_kle_rec.SUBSIDIZED_OEC,
   --l_kle_rec.SUBSIDIZED_CAP_AMOUNT,
   l_kle_rec.SUBSIDY_OVERRIDE_AMOUNT,
   --financed fee
   l_kle_rec.PRE_TAX_YIELD,
   l_kle_rec.AFTER_TAX_YIELD,
   l_kle_rec.IMPLICIT_INTEREST_RATE,
   l_kle_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
   l_kle_rec.PRE_TAX_IRR,
   l_kle_rec.AFTER_TAX_IRR,
--quotes
   l_kle_rec.SUB_PRE_TAX_YIELD,
   l_kle_rec.SUB_AFTER_TAX_YIELD,
   l_kle_rec.SUB_IMPL_INTEREST_RATE,
   l_kle_rec.SUB_IMPL_NON_IDC_INT_RATE,
   l_kle_rec.SUB_PRE_TAX_IRR,
   l_kle_rec.SUB_AFTER_TAX_IRR,
--Bug# 2994971
   l_kle_rec.ITEM_INSURANCE_CATEGORY,
--Bug# 3973640 :11.5.10+
   l_kle_rec.QTE_ID,
   l_kle_rec.FUNDING_DATE,
   l_kle_rec.STREAM_TYPE_SUBCLASS,
--Bug# 4419339  OKLH
   l_kle_rec.DATE_FUNDING_EXPECTED,
   l_kle_rec.MANUFACTURER_NAME,
   l_kle_rec.MODEL_NUMBER,
   l_kle_rec.DOWN_PAYMENT_RECEIVER_CODE,
   l_kle_rec.CAPITALIZE_DOWN_PAYMENT_YN,
--Bug# 4373029
   l_kle_rec.FEE_PURPOSE_CODE,
   l_kle_rec.TERMINATION_VALUE,
--Bug# 4631549
   l_kle_rec.EXPECTED_ASSET_COST
        );

Line: 3857


  END insert_row;

Line: 3863


  PROCEDURE insert_row(

    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_klev_rec                     IN klev_rec_type,
    x_klev_rec                     OUT NOCOPY klev_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3874


    l_api_name                     CONSTANT VARCHAR2(30) := 'rec_insert_row';

Line: 3890


      l_klev_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 3891


      l_klev_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 3892


      l_klev_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 3969


    insert_row(
      l_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_kle_rec,
      lx_kle_rec
    );

Line: 4022


  END insert_row;

Line: 4028


  PROCEDURE insert_row(

    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_klev_tbl                     IN klev_tbl_type,
    x_klev_tbl                     OUT NOCOPY klev_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 4039


    l_api_name                     CONSTANT VARCHAR2(30) := 'tbl_insert_row';

Line: 4048


        insert_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKC_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_klev_rec                     => p_klev_tbl(i),
          x_klev_rec                     => x_klev_tbl(i));

Line: 4093


  END insert_row;

Line: 4116


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_K_LINES
     WHERE ID = p_kle_rec.id
       AND OBJECT_VERSION_NUMBER = p_kle_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 4123


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_K_LINES
    WHERE ID = p_kle_rec.id;

Line: 4166


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 4175


      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 4381


  PROCEDURE update_row(

    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_kle_rec                     IN kle_rec_type,
    x_kle_rec                     OUT NOCOPY kle_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 4392


    l_api_name                     CONSTANT VARCHAR2(30) := 'rec_update_row';

Line: 4709


      IF (x_kle_rec.LAST_UPDATED_BY = OKC_API.G_MISS_NUM) THEN
      x_kle_rec.LAST_UPDATED_BY := l_kle_rec.LAST_UPDATED_BY;

Line: 4713


      IF (x_kle_rec.LAST_UPDATE_DATE = OKC_API.G_MISS_DATE) THEN
      x_kle_rec.LAST_UPDATE_DATE := l_kle_rec.LAST_UPDATE_DATE;

Line: 4717


      IF (x_kle_rec.LAST_UPDATE_LOGIN = OKC_API.G_MISS_NUM) THEN
      x_kle_rec.LAST_UPDATE_LOGIN := l_kle_rec.LAST_UPDATE_LOGIN;

Line: 4968


    UPDATE  OKL_K_LINES
    SET
    ID = l_def_kle_rec.ID,
        KLE_ID = l_def_kle_rec.KLE_ID,
        STY_ID = l_def_kle_rec.STY_ID,
        OBJECT_VERSION_NUMBER = l_def_kle_rec.OBJECT_VERSION_NUMBER,
        LAO_AMOUNT = l_def_kle_rec.LAO_AMOUNT,
        FEE_CHARGE = l_def_kle_rec.FEE_CHARGE,
        TITLE_DATE = l_def_kle_rec.TITLE_DATE,
        DATE_RESIDUAL_LAST_REVIEW = l_def_kle_rec.DATE_RESIDUAL_LAST_REVIEW,
        DATE_LAST_REAMORTISATION = l_def_kle_rec.DATE_LAST_REAMORTISATION,
        TERMINATION_PURCHASE_AMOUNT = l_def_kle_rec.TERMINATION_PURCHASE_AMOUNT,
        DATE_LAST_CLEANUP = l_def_kle_rec.DATE_LAST_CLEANUP,
        REMARKETED_AMOUNT = l_def_kle_rec.REMARKETED_AMOUNT,
        DATE_REMARKETED = l_def_kle_rec.DATE_REMARKETED,
        REMARKET_MARGIN = l_def_kle_rec.REMARKET_MARGIN,
        REPURCHASED_AMOUNT = l_def_kle_rec.REPURCHASED_AMOUNT,
        DATE_REPURCHASED = l_def_kle_rec.DATE_REPURCHASED,
        GAIN_LOSS = l_def_kle_rec.GAIN_LOSS,
        FLOOR_AMOUNT = l_def_kle_rec.FLOOR_AMOUNT,
        PREVIOUS_CONTRACT = l_def_kle_rec.PREVIOUS_CONTRACT,
        TRACKED_RESIDUAL = l_def_kle_rec.TRACKED_RESIDUAL,
        DATE_TITLE_RECEIVED = l_def_kle_rec.DATE_TITLE_RECEIVED,
        ESTIMATED_OEC = l_def_kle_rec.ESTIMATED_OEC,
        RESIDUAL_PERCENTAGE = l_def_kle_rec.RESIDUAL_PERCENTAGE,
        CAPITAL_REDUCTION = l_def_kle_rec.CAPITAL_REDUCTION,
        VENDOR_ADVANCE_PAID = l_def_kle_rec.VENDOR_ADVANCE_PAID,
        TRADEIN_AMOUNT = l_def_kle_rec.TRADEIN_AMOUNT,
        DELIVERED_DATE = l_def_kle_rec.DELIVERED_DATE,
        YEAR_OF_MANUFACTURE = l_def_kle_rec.YEAR_OF_MANUFACTURE,
        INITIAL_DIRECT_COST = l_def_kle_rec.INITIAL_DIRECT_COST,
        OCCUPANCY = l_def_kle_rec.OCCUPANCY,
        DATE_LAST_INSPECTION = l_def_kle_rec.DATE_LAST_INSPECTION,
        DATE_NEXT_INSPECTION_DUE = l_def_kle_rec.DATE_NEXT_INSPECTION_DUE,
        WEIGHTED_AVERAGE_LIFE = l_def_kle_rec.WEIGHTED_AVERAGE_LIFE,
        BOND_EQUIVALENT_YIELD = l_def_kle_rec.BOND_EQUIVALENT_YIELD,
        REFINANCE_AMOUNT = l_def_kle_rec.REFINANCE_AMOUNT,
        YEAR_BUILT = l_def_kle_rec.YEAR_BUILT,
        COVERAGE_RATIO = l_def_kle_rec.COVERAGE_RATIO,
        GROSS_SQUARE_FOOTAGE = l_def_kle_rec.GROSS_SQUARE_FOOTAGE,
        NET_RENTABLE = l_def_kle_rec.NET_RENTABLE,
        DATE_LETTER_ACCEPTANCE = l_def_kle_rec.DATE_LETTER_ACCEPTANCE,
        DATE_COMMITMENT_EXPIRATION = l_def_kle_rec.DATE_COMMITMENT_EXPIRATION,
        DATE_APPRAISAL = l_def_kle_rec.DATE_APPRAISAL,
        APPRAISAL_VALUE = l_def_kle_rec.APPRAISAL_VALUE,
        RESIDUAL_VALUE = l_def_kle_rec.RESIDUAL_VALUE,
        PERCENT = l_def_kle_rec.PERCENT,
        COVERAGE = l_def_kle_rec.COVERAGE,
        LRV_AMOUNT = l_def_kle_rec.LRV_AMOUNT,
        AMOUNT = l_def_kle_rec.AMOUNT,
        LRS_PERCENT = l_def_kle_rec.LRS_PERCENT,
        EVERGREEN_PERCENT = l_def_kle_rec.EVERGREEN_PERCENT,
        PERCENT_STAKE = l_def_kle_rec.PERCENT_STAKE,
        AMOUNT_STAKE = l_def_kle_rec.AMOUNT_STAKE,
        DATE_SOLD = l_def_kle_rec.DATE_SOLD,
        STY_ID_FOR = l_def_kle_rec.STY_ID_FOR,
        ATTRIBUTE_CATEGORY = l_def_kle_rec.ATTRIBUTE_CATEGORY,
        ATTRIBUTE1 = l_def_kle_rec.ATTRIBUTE1,
        ATTRIBUTE2 = l_def_kle_rec.ATTRIBUTE2,
        ATTRIBUTE3 = l_def_kle_rec.ATTRIBUTE3,
        ATTRIBUTE4 = l_def_kle_rec.ATTRIBUTE4,
        ATTRIBUTE5 = l_def_kle_rec.ATTRIBUTE5,
        ATTRIBUTE6 = l_def_kle_rec.ATTRIBUTE6,
        ATTRIBUTE7 = l_def_kle_rec.ATTRIBUTE7,
        ATTRIBUTE8 = l_def_kle_rec.ATTRIBUTE8,
        ATTRIBUTE9 = l_def_kle_rec.ATTRIBUTE9,
        ATTRIBUTE10 = l_def_kle_rec.ATTRIBUTE10,
        ATTRIBUTE11 = l_def_kle_rec.ATTRIBUTE11,
        ATTRIBUTE12 = l_def_kle_rec.ATTRIBUTE12,
        ATTRIBUTE13 = l_def_kle_rec.ATTRIBUTE13,
        ATTRIBUTE14 = l_def_kle_rec.ATTRIBUTE14,
        ATTRIBUTE15 = l_def_kle_rec.ATTRIBUTE15,
        CREATED_BY = l_def_kle_rec.CREATED_BY,
        CREATION_DATE = l_def_kle_rec.CREATION_DATE,
        LAST_UPDATED_BY = l_def_kle_rec.LAST_UPDATED_BY,
        LAST_UPDATE_DATE = l_def_kle_rec.LAST_UPDATE_DATE,
        LAST_UPDATE_LOGIN = l_def_kle_rec.LAST_UPDATE_LOGIN,
        NTY_CODE = l_def_kle_rec.NTY_CODE,
        FCG_CODE = l_def_kle_rec.FCG_CODE,
        PRC_CODE = l_def_kle_rec.PRC_CODE,
        RE_LEASE_YN = l_def_kle_rec.RE_LEASE_YN,
        PRESCRIBED_ASSET_YN = l_def_kle_rec.PRESCRIBED_ASSET_YN,
        CREDIT_TENANT_YN = l_def_kle_rec.CREDIT_TENANT_YN,
        SECURED_DEAL_YN = l_def_kle_rec.SECURED_DEAL_YN,
        CLG_ID = l_def_kle_rec.CLG_ID,
        DATE_FUNDING = l_def_kle_rec.DATE_FUNDING,
        DATE_FUNDING_REQUIRED = l_def_kle_rec.DATE_FUNDING_REQUIRED,
        DATE_ACCEPTED = l_def_kle_rec.DATE_ACCEPTED,
        DATE_DELIVERY_EXPECTED = l_def_kle_rec.DATE_DELIVERY_EXPECTED,
        OEC = l_def_kle_rec.OEC,
        CAPITAL_AMOUNT = l_def_kle_rec.CAPITAL_AMOUNT,
        RESIDUAL_GRNTY_AMOUNT = l_def_kle_rec.RESIDUAL_GRNTY_AMOUNT,
        RESIDUAL_CODE = l_def_kle_rec.RESIDUAL_CODE,
        RVI_PREMIUM = l_def_kle_rec.RVI_PREMIUM,
        CREDIT_NATURE = l_def_kle_rec.CREDIT_NATURE,
        CAPITALIZED_INTEREST = l_def_kle_rec.CAPITALIZED_INTEREST,
        CAPITAL_REDUCTION_PERCENT = l_def_kle_rec.CAPITAL_REDUCTION_PERCENT,
--Bug# 2697681 11.5.9
        DATE_PAY_INVESTOR_START      = l_def_kle_rec.DATE_PAY_INVESTOR_START,
        PAY_INVESTOR_FREQUENCY       = l_def_kle_rec.PAY_INVESTOR_FREQUENCY,
        PAY_INVESTOR_EVENT           = l_def_kle_rec.PAY_INVESTOR_EVENT,
        PAY_INVESTOR_REMITTANCE_DAYS = l_def_kle_rec.PAY_INVESTOR_REMITTANCE_DAYS,
--financed fees
        FEE_TYPE                     = l_def_kle_rec.FEE_TYPE,
--Bug# 3143522 : 11.5.10
   --subsidy
   SUBSIDY_ID = l_def_kle_rec.SUBSIDY_ID,
   --SUBSIDIZED_OEC = l_def_kle_rec.SUBSIDIZED_OEC,
   --SUBSIDIZED_CAP_AMOUNT = l_def_kle_rec.SUBSIDIZED_CAP_AMOUNT,
   SUBSIDY_OVERRIDE_AMOUNT = l_def_kle_rec.SUBSIDY_OVERRIDE_AMOUNT,
   --financed fee
   PRE_TAX_YIELD = l_def_kle_rec.PRE_TAX_YIELD,
   AFTER_TAX_YIELD = l_def_kle_rec.AFTER_TAX_YIELD,
   IMPLICIT_INTEREST_RATE = l_def_kle_rec.IMPLICIT_INTEREST_RATE,
   IMPLICIT_NON_IDC_INTEREST_RATE = l_def_kle_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
   PRE_TAX_IRR = l_def_kle_rec.PRE_TAX_IRR,
   AFTER_TAX_IRR = l_def_kle_rec.AFTER_TAX_IRR,
--quote
   SUB_PRE_TAX_YIELD = l_def_kle_rec.SUB_PRE_TAX_YIELD,
   SUB_AFTER_TAX_YIELD = l_def_kle_rec.SUB_AFTER_TAX_YIELD,
   SUB_IMPL_INTEREST_RATE = l_def_kle_rec.SUB_IMPL_INTEREST_RATE,
   SUB_IMPL_NON_IDC_INT_RATE = l_def_kle_rec.SUB_IMPL_NON_IDC_INT_RATE,
   SUB_PRE_TAX_IRR = l_def_kle_rec.SUB_PRE_TAX_IRR,
   SUB_AFTER_TAX_IRR = l_def_kle_rec.SUB_AFTER_TAX_IRR,
--Bug# 2994971
   ITEM_INSURANCE_CATEGORY = l_def_kle_rec.ITEM_INSURANCE_CATEGORY,
--Bug# 3973640 :11.5.10+
   QTE_ID = l_def_kle_rec.QTE_ID,
   FUNDING_DATE = l_def_kle_rec.FUNDING_DATE,
   STREAM_TYPE_SUBCLASS = l_def_kle_rec.STREAM_TYPE_SUBCLASS,
--Bug# 4419339  OKLH
   DATE_FUNDING_EXPECTED = l_def_kle_rec.DATE_FUNDING_EXPECTED,
   MANUFACTURER_NAME = l_def_kle_rec.MANUFACTURER_NAME,
   MODEL_NUMBER = l_def_kle_rec.MODEL_NUMBER,
   DOWN_PAYMENT_RECEIVER_CODE = l_def_kle_rec.DOWN_PAYMENT_RECEIVER_CODE,
   CAPITALIZE_DOWN_PAYMENT_YN = l_def_kle_rec.CAPITALIZE_DOWN_PAYMENT_YN,
   FEE_PURPOSE_CODE = l_def_kle_rec.FEE_PURPOSE_CODE,
   TERMINATION_VALUE = l_def_kle_rec.TERMINATION_VALUE,
--Bug# 4631549
   EXPECTED_ASSET_COST = l_def_kle_rec.EXPECTED_ASSET_COST

    WHERE ID = l_def_kle_rec.id;

Line: 5113


    insert_row(
      l_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_okl_k_lines_h_rec,
      lx_okl_k_lines_h_rec
    );

Line: 5165


  END update_row;

Line: 5171


  PROCEDURE update_row(

    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_klev_rec                     IN klev_rec_type,
    x_klev_rec                     OUT NOCOPY klev_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 5182


    l_api_name                     CONSTANT VARCHAR2(30) := 'rec_update_row';

Line: 5196


      l_klev_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 5197


      l_klev_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 5198


      l_klev_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 5540


      IF (x_klev_rec.LAST_UPDATED_BY = OKC_API.G_MISS_NUM) THEN
      x_klev_rec.LAST_UPDATED_BY := l_klev_rec.LAST_UPDATED_BY;

Line: 5544


      IF (x_klev_rec.LAST_UPDATE_DATE = OKC_API.G_MISS_DATE) THEN
      x_klev_rec.LAST_UPDATE_DATE := l_klev_rec.LAST_UPDATE_DATE;

Line: 5548


      IF (x_klev_rec.LAST_UPDATE_LOGIN = OKC_API.G_MISS_NUM) THEN
      x_klev_rec.LAST_UPDATE_LOGIN := l_klev_rec.LAST_UPDATE_LOGIN;

Line: 5796


    update_row(
      l_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_kle_rec,
      lx_kle_rec
    );

Line: 5848


  END update_row;

Line: 5853


  PROCEDURE update_row(

    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_klev_tbl                     IN klev_tbl_type,
    x_klev_tbl                     OUT NOCOPY klev_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 5864


    l_api_name                     CONSTANT VARCHAR2(30) := 'tbl_update_row';

Line: 5873


        update_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKC_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_klev_rec                     => p_klev_tbl(i),
          x_klev_rec                     => x_klev_tbl(i));

Line: 5918


  END update_row;

Line: 5930


  PROCEDURE delete_row(

    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_kle_rec                     IN kle_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 5940


    l_api_name                     CONSTANT VARCHAR2(30) := 'rec_delete_row';

Line: 5965


    insert_row(
      l_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_okl_k_lines_h_rec,
      lx_okl_k_lines_h_rec
    );

Line: 5981


    DELETE FROM OKL_K_LINES
     WHERE ID = l_kle_rec.id;

Line: 6018


  END delete_row;

Line: 6020


  PROCEDURE delete_row(

    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_klev_rec                     IN klev_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 6030


    l_api_name                     CONSTANT VARCHAR2(30) := 'rec_delete_row';

Line: 6056


    delete_row(
      l_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_kle_rec
    );

Line: 6105


  END delete_row;

Line: 6110


  PROCEDURE delete_row(

    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_klev_tbl                     IN klev_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 6120


    l_api_name                     CONSTANT VARCHAR2(30) := 'tbl_delete_row';

Line: 6129


        delete_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKC_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_klev_rec                     => p_klev_tbl(i));

Line: 6173


  END delete_row;

Line: 6187


INSERT INTO OKL_K_LINES_H
  (
      major_version,
	ID,
        KLE_ID,
        STY_ID,
        OBJECT_VERSION_NUMBER,
        LAO_AMOUNT,
        FEE_CHARGE,
        TITLE_DATE,
        DATE_RESIDUAL_LAST_REVIEW,
        DATE_LAST_REAMORTISATION,
        TERMINATION_PURCHASE_AMOUNT,
        DATE_LAST_CLEANUP,
        REMARKETED_AMOUNT,
        DATE_REMARKETED,
        REMARKET_MARGIN,
        REPURCHASED_AMOUNT,
        DATE_REPURCHASED,
        GAIN_LOSS,
        FLOOR_AMOUNT,
        PREVIOUS_CONTRACT,
        TRACKED_RESIDUAL,
        DATE_TITLE_RECEIVED,
        ESTIMATED_OEC,
        RESIDUAL_PERCENTAGE,
        CAPITAL_REDUCTION,
        VENDOR_ADVANCE_PAID,
        TRADEIN_AMOUNT,
        DELIVERED_DATE,
        YEAR_OF_MANUFACTURE,
        INITIAL_DIRECT_COST,
        OCCUPANCY,
        DATE_LAST_INSPECTION,
        DATE_NEXT_INSPECTION_DUE,
        WEIGHTED_AVERAGE_LIFE,
        BOND_EQUIVALENT_YIELD,
        REFINANCE_AMOUNT,
        YEAR_BUILT,
        COVERAGE_RATIO,
        GROSS_SQUARE_FOOTAGE,
        NET_RENTABLE,
        DATE_LETTER_ACCEPTANCE,
        DATE_COMMITMENT_EXPIRATION,
        DATE_APPRAISAL,
        APPRAISAL_VALUE,
        RESIDUAL_VALUE,
        PERCENT,
        COVERAGE,
        LRV_AMOUNT,
        AMOUNT,
        LRS_PERCENT,
        EVERGREEN_PERCENT,
        PERCENT_STAKE,
        AMOUNT_STAKE,
        DATE_SOLD,
        STY_ID_FOR,
        ATTRIBUTE_CATEGORY,
        ATTRIBUTE1,
        ATTRIBUTE2,
        ATTRIBUTE3,
        ATTRIBUTE4,
        ATTRIBUTE5,
        ATTRIBUTE6,
        ATTRIBUTE7,
        ATTRIBUTE8,
        ATTRIBUTE9,
        ATTRIBUTE10,
        ATTRIBUTE11,
        ATTRIBUTE12,
        ATTRIBUTE13,
        ATTRIBUTE14,
        ATTRIBUTE15,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATE_LOGIN,
        NTY_CODE,
        FCG_CODE,
        PRC_CODE,
        RE_LEASE_YN,
        PRESCRIBED_ASSET_YN,
        CREDIT_TENANT_YN,
        SECURED_DEAL_YN,
        CLG_ID,
        DATE_FUNDING,
        DATE_FUNDING_REQUIRED,
        DATE_ACCEPTED,
        DATE_DELIVERY_EXPECTED,
        OEC,
        CAPITAL_AMOUNT,
        RESIDUAL_GRNTY_AMOUNT,
        RESIDUAL_CODE,
        RVI_PREMIUM,
        CREDIT_NATURE,
        CAPITALIZED_INTEREST,
        CAPITAL_REDUCTION_PERCENT,
--Bug# 2697681 11.5.9
        DATE_PAY_INVESTOR_START,
        PAY_INVESTOR_FREQUENCY,
        PAY_INVESTOR_EVENT,
        PAY_INVESTOR_REMITTANCE_DAYS,
--financed fees
        FEE_TYPE,
--Bug#3143522 : 11.5.10
   --subsidy
   SUBSIDY_ID,
   --SUBSIDIZED_OEC,
   --SUBSIDIZED_CAP_AMOUNT,
   SUBSIDY_OVERRIDE_AMOUNT,
   --financed fee
   PRE_TAX_YIELD,
   AFTER_TAX_YIELD,
   IMPLICIT_INTEREST_RATE,
   IMPLICIT_NON_IDC_INTEREST_RATE,
   PRE_TAX_IRR,
   AFTER_TAX_IRR,
--quote
   SUB_PRE_TAX_YIELD,
   SUB_AFTER_TAX_YIELD,
   SUB_IMPL_INTEREST_RATE,
   SUB_IMPL_NON_IDC_INT_RATE,
   SUB_PRE_TAX_IRR,
   SUB_AFTER_TAX_IRR,
--Bug# 2994971
   ITEM_INSURANCE_CATEGORY,
--Bug# 3973640 :11.5.10+
   QTE_ID,
   FUNDING_DATE,
   STREAM_TYPE_SUBCLASS,
--Bug# 4419339  OKLH
   DATE_FUNDING_EXPECTED,
   MANUFACTURER_NAME,
   MODEL_NUMBER,
   DOWN_PAYMENT_RECEIVER_CODE,
   CAPITALIZE_DOWN_PAYMENT_YN,
--Bug#4373029
   FEE_PURPOSE_CODE,
   TERMINATION_VALUE,
--Bug# 4631549
   EXPECTED_ASSET_COST

)
  SELECT
      p_major_version,
	ID,
        KLE_ID,
        STY_ID,
        OBJECT_VERSION_NUMBER,
        LAO_AMOUNT,
        FEE_CHARGE,
        TITLE_DATE,
        DATE_RESIDUAL_LAST_REVIEW,
        DATE_LAST_REAMORTISATION,
        TERMINATION_PURCHASE_AMOUNT,
        DATE_LAST_CLEANUP,
        REMARKETED_AMOUNT,
        DATE_REMARKETED,
        REMARKET_MARGIN,
        REPURCHASED_AMOUNT,
        DATE_REPURCHASED,
        GAIN_LOSS,
        FLOOR_AMOUNT,
        PREVIOUS_CONTRACT,
        TRACKED_RESIDUAL,
        DATE_TITLE_RECEIVED,
        ESTIMATED_OEC,
        RESIDUAL_PERCENTAGE,
        CAPITAL_REDUCTION,
        VENDOR_ADVANCE_PAID,
        TRADEIN_AMOUNT,
        DELIVERED_DATE,
        YEAR_OF_MANUFACTURE,
        INITIAL_DIRECT_COST,
        OCCUPANCY,
        DATE_LAST_INSPECTION,
        DATE_NEXT_INSPECTION_DUE,
        WEIGHTED_AVERAGE_LIFE,
        BOND_EQUIVALENT_YIELD,
        REFINANCE_AMOUNT,
        YEAR_BUILT,
        COVERAGE_RATIO,
        GROSS_SQUARE_FOOTAGE,
        NET_RENTABLE,
        DATE_LETTER_ACCEPTANCE,
        DATE_COMMITMENT_EXPIRATION,
        DATE_APPRAISAL,
        APPRAISAL_VALUE,
        RESIDUAL_VALUE,
        PERCENT,
        COVERAGE,
        LRV_AMOUNT,
        AMOUNT,
        LRS_PERCENT,
        EVERGREEN_PERCENT,
        PERCENT_STAKE,
        AMOUNT_STAKE,
        DATE_SOLD,
        STY_ID_FOR,
        ATTRIBUTE_CATEGORY,
        ATTRIBUTE1,
        ATTRIBUTE2,
        ATTRIBUTE3,
        ATTRIBUTE4,
        ATTRIBUTE5,
        ATTRIBUTE6,
        ATTRIBUTE7,
        ATTRIBUTE8,
        ATTRIBUTE9,
        ATTRIBUTE10,
        ATTRIBUTE11,
        ATTRIBUTE12,
        ATTRIBUTE13,
        ATTRIBUTE14,
        ATTRIBUTE15,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATE_LOGIN,
        NTY_CODE,
        FCG_CODE,
        PRC_CODE,
        RE_LEASE_YN,
        PRESCRIBED_ASSET_YN,
        CREDIT_TENANT_YN,
        SECURED_DEAL_YN,
        CLG_ID,
        DATE_FUNDING,
        DATE_FUNDING_REQUIRED,
        DATE_ACCEPTED,
        DATE_DELIVERY_EXPECTED,
        OEC,
        CAPITAL_AMOUNT,
        RESIDUAL_GRNTY_AMOUNT,
        RESIDUAL_CODE,
        RVI_PREMIUM,
        CREDIT_NATURE,
        CAPITALIZED_INTEREST,
        CAPITAL_REDUCTION_PERCENT,
--Bug# 2697681 11.5.9
        DATE_PAY_INVESTOR_START,
        PAY_INVESTOR_FREQUENCY,
        PAY_INVESTOR_EVENT,
        PAY_INVESTOR_REMITTANCE_DAYS,
--financed fees
        FEE_TYPE,
--Bug#3143522 : 11.5.10
   --subsidy
   SUBSIDY_ID,
   --SUBSIDIZED_OEC,
   --SUBSIDIZED_CAP_AMOUNT,
   SUBSIDY_OVERRIDE_AMOUNT,
   --financed fee
   PRE_TAX_YIELD,
   AFTER_TAX_YIELD,
   IMPLICIT_INTEREST_RATE,
   IMPLICIT_NON_IDC_INTEREST_RATE,
   PRE_TAX_IRR,
   AFTER_TAX_IRR,
--quote
   SUB_PRE_TAX_YIELD,
   SUB_AFTER_TAX_YIELD,
   SUB_IMPL_INTEREST_RATE,
   SUB_IMPL_NON_IDC_INT_RATE,
   SUB_PRE_TAX_IRR,
   SUB_AFTER_TAX_IRR,
--Bug# 2994971
   ITEM_INSURANCE_CATEGORY,
--Bug# 3973640 : 11.5.10+
   QTE_ID,
   FUNDING_DATE,
   STREAM_TYPE_SUBCLASS,
--Bug# 4419339  OKLH
   DATE_FUNDING_EXPECTED,
   MANUFACTURER_NAME,
   MODEL_NUMBER,
   DOWN_PAYMENT_RECEIVER_CODE,
   CAPITALIZE_DOWN_PAYMENT_YN,
   FEE_PURPOSE_CODE,
   TERMINATION_VALUE,
--Bug# 4631549
   EXPECTED_ASSET_COST

  FROM OKL_K_LINES
  WHERE id in (select id from okc_k_lines_b where dnz_chr_id = p_chr_id);

Line: 6499


INSERT INTO OKL_K_LINES
  (
	ID,
        KLE_ID,
        STY_ID,
        OBJECT_VERSION_NUMBER,
        LAO_AMOUNT,
        FEE_CHARGE,
        TITLE_DATE,
        DATE_RESIDUAL_LAST_REVIEW,
        DATE_LAST_REAMORTISATION,
        TERMINATION_PURCHASE_AMOUNT,
        DATE_LAST_CLEANUP,
        REMARKETED_AMOUNT,
        DATE_REMARKETED,
        REMARKET_MARGIN,
        REPURCHASED_AMOUNT,
        DATE_REPURCHASED,
        GAIN_LOSS,
        FLOOR_AMOUNT,
        PREVIOUS_CONTRACT,
        TRACKED_RESIDUAL,
        DATE_TITLE_RECEIVED,
        ESTIMATED_OEC,
        RESIDUAL_PERCENTAGE,
        CAPITAL_REDUCTION,
        VENDOR_ADVANCE_PAID,
        TRADEIN_AMOUNT,
        DELIVERED_DATE,
        YEAR_OF_MANUFACTURE,
        INITIAL_DIRECT_COST,
        OCCUPANCY,
        DATE_LAST_INSPECTION,
        DATE_NEXT_INSPECTION_DUE,
        WEIGHTED_AVERAGE_LIFE,
        BOND_EQUIVALENT_YIELD,
        REFINANCE_AMOUNT,
        YEAR_BUILT,
        COVERAGE_RATIO,
        GROSS_SQUARE_FOOTAGE,
        NET_RENTABLE,
        DATE_LETTER_ACCEPTANCE,
        DATE_COMMITMENT_EXPIRATION,
        DATE_APPRAISAL,
        APPRAISAL_VALUE,
        RESIDUAL_VALUE,
        PERCENT,
        COVERAGE,
        LRV_AMOUNT,
        AMOUNT,
        LRS_PERCENT,
        EVERGREEN_PERCENT,
        PERCENT_STAKE,
        AMOUNT_STAKE,
        DATE_SOLD,
        STY_ID_FOR,
        ATTRIBUTE_CATEGORY,
        ATTRIBUTE1,
        ATTRIBUTE2,
        ATTRIBUTE3,
        ATTRIBUTE4,
        ATTRIBUTE5,
        ATTRIBUTE6,
        ATTRIBUTE7,
        ATTRIBUTE8,
        ATTRIBUTE9,
        ATTRIBUTE10,
        ATTRIBUTE11,
        ATTRIBUTE12,
        ATTRIBUTE13,
        ATTRIBUTE14,
        ATTRIBUTE15,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATE_LOGIN,
        NTY_CODE,
        FCG_CODE,
        PRC_CODE,
        RE_LEASE_YN,
        PRESCRIBED_ASSET_YN,
        CREDIT_TENANT_YN,
        SECURED_DEAL_YN,
        CLG_ID,
        DATE_FUNDING,
        DATE_FUNDING_REQUIRED,
        DATE_ACCEPTED,
        DATE_DELIVERY_EXPECTED,
        OEC,
        CAPITAL_AMOUNT,
        RESIDUAL_GRNTY_AMOUNT,
        RESIDUAL_CODE,
        RVI_PREMIUM,
        CREDIT_NATURE,
        CAPITALIZED_INTEREST,
        CAPITAL_REDUCTION_PERCENT,
--Bug# 2697681 11.5.9
        DATE_PAY_INVESTOR_START,
        PAY_INVESTOR_FREQUENCY,
        PAY_INVESTOR_EVENT,
        PAY_INVESTOR_REMITTANCE_DAYS,
--financed fees
        FEE_TYPE,
--Bug#3143522 : 11.5.10
   --subsidy
   SUBSIDY_ID,
   --SUBSIDIZED_OEC,
   --SUBSIDIZED_CAP_AMOUNT,
   SUBSIDY_OVERRIDE_AMOUNT,
   --financed fee
   PRE_TAX_YIELD,
   AFTER_TAX_YIELD,
   IMPLICIT_INTEREST_RATE,
   IMPLICIT_NON_IDC_INTEREST_RATE,
   PRE_TAX_IRR,
   AFTER_TAX_IRR,
--quote
   SUB_PRE_TAX_YIELD,
   SUB_AFTER_TAX_YIELD,
   SUB_IMPL_INTEREST_RATE,
   SUB_IMPL_NON_IDC_INT_RATE,
   SUB_PRE_TAX_IRR,
   SUB_AFTER_TAX_IRR,
--Bug# 2994971
   ITEM_INSURANCE_CATEGORY,
--Bug# 3973640:11.5.10+
   QTE_ID,
   FUNDING_DATE,
   STREAM_TYPE_SUBCLASS,
--Bug# 4419339  OKLH
   DATE_FUNDING_EXPECTED,
   MANUFACTURER_NAME,
   MODEL_NUMBER,
   DOWN_PAYMENT_RECEIVER_CODE,
   CAPITALIZE_DOWN_PAYMENT_YN,
--Bug#4373029
   FEE_PURPOSE_CODE,
   TERMINATION_VALUE,
--Bug# 4631549
   EXPECTED_ASSET_COST

)
  SELECT
	ID,
        KLE_ID,
        STY_ID,
        OBJECT_VERSION_NUMBER,
        LAO_AMOUNT,
        FEE_CHARGE,
        TITLE_DATE,
        DATE_RESIDUAL_LAST_REVIEW,
        DATE_LAST_REAMORTISATION,
        TERMINATION_PURCHASE_AMOUNT,
        DATE_LAST_CLEANUP,
        REMARKETED_AMOUNT,
        DATE_REMARKETED,
        REMARKET_MARGIN,
        REPURCHASED_AMOUNT,
        DATE_REPURCHASED,
        GAIN_LOSS,
        FLOOR_AMOUNT,
        PREVIOUS_CONTRACT,
        TRACKED_RESIDUAL,
        DATE_TITLE_RECEIVED,
        ESTIMATED_OEC,
        RESIDUAL_PERCENTAGE,
        CAPITAL_REDUCTION,
        VENDOR_ADVANCE_PAID,
        TRADEIN_AMOUNT,
        DELIVERED_DATE,
        YEAR_OF_MANUFACTURE,
        INITIAL_DIRECT_COST,
        OCCUPANCY,
        DATE_LAST_INSPECTION,
        DATE_NEXT_INSPECTION_DUE,
        WEIGHTED_AVERAGE_LIFE,
        BOND_EQUIVALENT_YIELD,
        REFINANCE_AMOUNT,
        YEAR_BUILT,
        COVERAGE_RATIO,
        GROSS_SQUARE_FOOTAGE,
        NET_RENTABLE,
        DATE_LETTER_ACCEPTANCE,
        DATE_COMMITMENT_EXPIRATION,
        DATE_APPRAISAL,
        APPRAISAL_VALUE,
        RESIDUAL_VALUE,
        PERCENT,
        COVERAGE,
        LRV_AMOUNT,
        AMOUNT,
        LRS_PERCENT,
        EVERGREEN_PERCENT,
        PERCENT_STAKE,
        AMOUNT_STAKE,
        DATE_SOLD,
        STY_ID_FOR,
        ATTRIBUTE_CATEGORY,
        ATTRIBUTE1,
        ATTRIBUTE2,
        ATTRIBUTE3,
        ATTRIBUTE4,
        ATTRIBUTE5,
        ATTRIBUTE6,
        ATTRIBUTE7,
        ATTRIBUTE8,
        ATTRIBUTE9,
        ATTRIBUTE10,
        ATTRIBUTE11,
        ATTRIBUTE12,
        ATTRIBUTE13,
        ATTRIBUTE14,
        ATTRIBUTE15,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATE_LOGIN,
        NTY_CODE,
        FCG_CODE,
        PRC_CODE,
        RE_LEASE_YN,
        PRESCRIBED_ASSET_YN,
        CREDIT_TENANT_YN,
        SECURED_DEAL_YN,
        CLG_ID,
        DATE_FUNDING,
        DATE_FUNDING_REQUIRED,
        DATE_ACCEPTED,
        DATE_DELIVERY_EXPECTED,
        OEC,
        CAPITAL_AMOUNT,
        RESIDUAL_GRNTY_AMOUNT,
        RESIDUAL_CODE,
        RVI_PREMIUM,
        CREDIT_NATURE,
        CAPITALIZED_INTEREST,
        CAPITAL_REDUCTION_PERCENT,
--Bug# 2697681 11.5.9
        DATE_PAY_INVESTOR_START,
        PAY_INVESTOR_FREQUENCY,
        PAY_INVESTOR_EVENT,
        PAY_INVESTOR_REMITTANCE_DAYS,
--financed fees
        FEE_TYPE,
--Bug#3143522 11.5.10
   --subsidy
   SUBSIDY_ID,
   --SUBSIDIZED_OEC,
   --SUBSIDIZED_CAP_AMOUNT,
   SUBSIDY_OVERRIDE_AMOUNT,
   --financed fee
   PRE_TAX_YIELD,
   AFTER_TAX_YIELD,
   IMPLICIT_INTEREST_RATE,
   IMPLICIT_NON_IDC_INTEREST_RATE,
   PRE_TAX_IRR,
   AFTER_TAX_IRR,
--quote
   SUB_PRE_TAX_YIELD,
   SUB_AFTER_TAX_YIELD,
   SUB_IMPL_INTEREST_RATE,
   SUB_IMPL_NON_IDC_INT_RATE,
   SUB_PRE_TAX_IRR,
   SUB_AFTER_TAX_IRR,
--Bug#2994971
   ITEM_INSURANCE_CATEGORY,
--Bug# 3973640 :11.5.10+
   QTE_ID,
   FUNDING_DATE,
   STREAM_TYPE_SUBCLASS,
--Bug# 4419339 :OKLH
   DATE_FUNDING_EXPECTED,
   MANUFACTURER_NAME,
   MODEL_NUMBER,
   DOWN_PAYMENT_RECEIVER_CODE,
   CAPITALIZE_DOWN_PAYMENT_YN,
--Bug# 4373029 : OKLH Sales Tax
   FEE_PURPOSE_CODE,
   TERMINATION_VALUE,
--Bug# 4631549
   EXPECTED_ASSET_COST

  FROM OKL_K_LINES_H
  WHERE id in (select id from okc_k_lines_b where dnz_chr_id = p_chr_id) and major_version = p_major_version;