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

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

Line: 31


  		select 'x'
  		from OKC_K_HEADERS_B
  		where ID = p_khrv_rec.khr_id;

Line: 88


  		select 'x'
  		from OKL_PRODUCTS
  		where ID = p_khrv_rec.pdt_id;

Line: 601


  select '!'
  from   gl_daily_conversion_types
  where  conversion_type = p_curr_cotyp;

Line: 733


  		select 'x'
  		from OKL_VP_CHANGE_REQUESTS
  		where ID = p_khrv_rec.crs_id;

Line: 1228


      SELECT
	ID,
        ISG_ID,
        KHR_ID,
        PDT_ID,
        OBJECT_VERSION_NUMBER,
        DATE_FIRST_ACTIVITY,
        SYNDICATABLE_YN,
        SALESTYPE_YN,
        DATE_REFINANCED,
        DATE_CONVERSION_EFFECTIVE,
        DATE_DEAL_TRANSFERRED,
        TERM_DURATION,
        DATETIME_PROPOSAL_EFFECTIVE,
        DATETIME_PROPOSAL_INEFFECTIVE,
        DATE_PROPOSAL_ACCEPTED,
        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,
        AMD_CODE,
        GENERATE_ACCRUAL_YN,
        GENERATE_ACCRUAL_OVERRIDE_YN,
        CREDIT_ACT_YN,
        CONVERTED_ACCOUNT_YN,
        PRE_TAX_YIELD,
        AFTER_TAX_YIELD,
        IMPLICIT_INTEREST_RATE,
        IMPLICIT_NON_IDC_INTEREST_RATE,
        TARGET_PRE_TAX_YIELD,
        TARGET_AFTER_TAX_YIELD,
        TARGET_IMPLICIT_INTEREST_RATE,
        TARGET_IMPLICIT_NONIDC_INTRATE,
        DATE_LAST_INTERIM_INTEREST_CAL,
        DEAL_TYPE,
        PRE_TAX_IRR,
        AFTER_TAX_IRR,
        EXPECTED_DELIVERY_DATE,
        ACCEPTED_DATE,
        PREFUNDING_ELIGIBLE_YN,
        REVOLVING_CREDIT_YN,
--Bug# 2697681 schema changes  11.5.9
        CURRENCY_CONVERSION_TYPE,
        CURRENCY_CONVERSION_RATE,
        CURRENCY_CONVERSION_DATE,
        MULTI_GAAP_YN,
        RECOURSE_CODE,
        LESSOR_SERV_ORG_CODE,
        ASSIGNABLE_YN,
        SECURITIZED_CODE,
        SECURITIZATION_TYPE,
--Bug#3143522 : 11.5.10
   --subsidy
   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# 3973640 : 11.5.10+
   TOT_CL_TRANSFER_AMT,
   TOT_CL_NET_TRANSFER_AMT,
   TOT_CL_LIMIT,
   TOT_CL_FUNDING_AMT,
   CRS_ID,
   TEMPLATE_TYPE_CODE,
--Bug# 4419339 OKLH Schema Sales Quote
   DATE_FUNDING_EXPECTED ,
   DATE_TRADEIN,
   TRADEIN_AMOUNT,
   TRADEIN_DESCRIPTION,
   --Added by dpsingh for LE uptake
   LEGAL_ENTITY_ID
 FROM OKL_K_HEADERS
      WHERE OKL_K_HEADERS.id     = p_id;

Line: 1361


        l_khr_rec.LAST_UPDATED_BY,
        l_khr_rec.LAST_UPDATE_DATE,
        l_khr_rec.LAST_UPDATE_LOGIN,
        l_khr_rec.AMD_CODE,
        l_khr_rec.GENERATE_ACCRUAL_YN,
        l_khr_rec.GENERATE_ACCRUAL_OVERRIDE_YN,
        l_khr_rec.CREDIT_ACT_YN,
        l_khr_rec.CONVERTED_ACCOUNT_YN,
        l_khr_rec.PRE_TAX_YIELD,
        l_khr_rec.AFTER_TAX_YIELD,
        l_khr_rec.IMPLICIT_INTEREST_RATE,
        l_khr_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
        l_khr_rec.TARGET_PRE_TAX_YIELD,
        l_khr_rec.TARGET_AFTER_TAX_YIELD,
        l_khr_rec.TARGET_IMPLICIT_INTEREST_RATE,
        l_khr_rec.TARGET_IMPLICIT_NONIDC_INTRATE,
        l_khr_rec.DATE_LAST_INTERIM_INTEREST_CAL,
        l_khr_rec.DEAL_TYPE,
        l_khr_rec.PRE_TAX_IRR,
        l_khr_rec.AFTER_TAX_IRR,
        l_khr_rec.EXPECTED_DELIVERY_DATE,
        l_khr_rec.ACCEPTED_DATE,
        l_khr_rec.PREFUNDING_ELIGIBLE_YN,
        l_khr_rec.REVOLVING_CREDIT_YN,
--Bug# 2697681 schema changes  11.5.9
        l_khr_rec.CURRENCY_CONVERSION_TYPE,
        l_khr_rec.CURRENCY_CONVERSION_RATE,
        l_khr_rec.CURRENCY_CONVERSION_DATE,
        l_khr_rec.MULTI_GAAP_YN,
        l_khr_rec.RECOURSE_CODE,
        l_khr_rec.LESSOR_SERV_ORG_CODE,
        l_khr_rec.ASSIGNABLE_YN,
        l_khr_rec.SECURITIZED_CODE,
        l_khr_rec.SECURITIZATION_TYPE,
--Bug#3143522 : 11.5.10
   --subsidy
   l_khr_rec.SUB_PRE_TAX_YIELD,
   l_khr_rec.SUB_AFTER_TAX_YIELD,
   l_khr_rec.SUB_IMPL_INTEREST_RATE,
   l_khr_rec.SUB_IMPL_NON_IDC_INT_RATE,
   l_khr_rec.SUB_PRE_TAX_IRR,
   l_khr_rec.SUB_AFTER_TAX_IRR,
   --Bug# 3973640 : 11.5.10+
   l_khr_rec.TOT_CL_TRANSFER_AMT,
   l_khr_rec.TOT_CL_NET_TRANSFER_AMT,
   l_khr_rec.TOT_CL_LIMIT,
   l_khr_rec.TOT_CL_FUNDING_AMT,
   l_khr_rec.CRS_ID,
   l_khr_rec.TEMPLATE_TYPE_CODE,
--Bug# 4419339 OKLH Schema Sales Quote
   l_khr_rec.DATE_FUNDING_EXPECTED ,
   l_khr_rec.DATE_TRADEIN,
   l_khr_rec.TRADEIN_AMOUNT,
   l_khr_rec.TRADEIN_DESCRIPTION,
   --Added by dpsingh for LE uptake
    l_khr_rec.LEGAL_ENTITY_ID     ;

Line: 1439


      SELECT
	ID,
        MAJOR_VERSION,
        ISG_ID,
        KHR_ID,
        PDT_ID,
        OBJECT_VERSION_NUMBER,
        DATE_FIRST_ACTIVITY,
        SYNDICATABLE_YN,
        SALESTYPE_YN,
        DATE_REFINANCED,
        DATE_CONVERSION_EFFECTIVE,
        DATE_DEAL_TRANSFERRED,
        TERM_DURATION,
        DATETIME_PROPOSAL_EFFECTIVE,
        DATETIME_PROPOSAL_INEFFECTIVE,
        DATE_PROPOSAL_ACCEPTED,
        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,
        AMD_CODE,
        GENERATE_ACCRUAL_YN,
        GENERATE_ACCRUAL_OVERRIDE_YN,
        CREDIT_ACT_YN,
        CONVERTED_ACCOUNT_YN,
        PRE_TAX_YIELD,
        AFTER_TAX_YIELD,
        IMPLICIT_INTEREST_RATE,
        IMPLICIT_NON_IDC_INTEREST_RATE,
        TARGET_PRE_TAX_YIELD,
        TARGET_AFTER_TAX_YIELD,
        TARGET_IMPLICIT_INTEREST_RATE,
        TARGET_IMPLICIT_NONIDC_INTRATE,
        DATE_LAST_INTERIM_INTEREST_CAL,
        DEAL_TYPE,
        PRE_TAX_IRR,
        AFTER_TAX_IRR,
        EXPECTED_DELIVERY_DATE,
        ACCEPTED_DATE,
        PREFUNDING_ELIGIBLE_YN,
        REVOLVING_CREDIT_YN,
--Bug# 2697681 schema changes  11.5.9
        CURRENCY_CONVERSION_TYPE,
        CURRENCY_CONVERSION_RATE,
        CURRENCY_CONVERSION_DATE,
        MULTI_GAAP_YN,
        RECOURSE_CODE,
        LESSOR_SERV_ORG_CODE,
        ASSIGNABLE_YN,
        SECURITIZED_CODE,
        SECURITIZATION_TYPE,
--Bug#3143522 : 11.5.10
   --subsidy
   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# 3973640 : 11.5.10+
   TOT_CL_TRANSFER_AMT,
   TOT_CL_NET_TRANSFER_AMT,
   TOT_CL_LIMIT,
   TOT_CL_FUNDING_AMT,
   CRS_ID,
   TEMPLATE_TYPE_CODE,
--Bug# 4419339 OKLH Schema Sales Quote
   DATE_FUNDING_EXPECTED ,
   DATE_TRADEIN,
   TRADEIN_AMOUNT,
   TRADEIN_DESCRIPTION,
--Added by dpsingh for LE uptake
   LEGAL_ENTITY_ID
      FROM OKL_K_HEADERS_H
      WHERE OKL_K_HEADERS_H.id     = p_id;

Line: 1573


        l_okl_k_headers_h_rec.LAST_UPDATED_BY,
        l_okl_k_headers_h_rec.LAST_UPDATE_DATE,
        l_okl_k_headers_h_rec.LAST_UPDATE_LOGIN,
        l_okl_k_headers_h_rec.AMD_CODE,
        l_okl_k_headers_h_rec.GENERATE_ACCRUAL_YN,
        l_okl_k_headers_h_rec.GENERATE_ACCRUAL_OVERRIDE_YN,
        l_okl_k_headers_h_rec.CREDIT_ACT_YN,
        l_okl_k_headers_h_rec.CONVERTED_ACCOUNT_YN,
        l_okl_k_headers_h_rec.PRE_TAX_YIELD,
        l_okl_k_headers_h_rec.AFTER_TAX_YIELD,
        l_okl_k_headers_h_rec.IMPLICIT_INTEREST_RATE,
        l_okl_k_headers_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
        l_okl_k_headers_h_rec.TARGET_PRE_TAX_YIELD,
        l_okl_k_headers_h_rec.TARGET_AFTER_TAX_YIELD,
        l_okl_k_headers_h_rec.TARGET_IMPLICIT_INTEREST_RATE,
        l_okl_k_headers_h_rec.TARGET_IMPLICIT_NONIDC_INTRATE,
        l_okl_k_headers_h_rec.DATE_LAST_INTERIM_INTEREST_CAL,
        l_okl_k_headers_h_rec.DEAL_TYPE,
        l_okl_k_headers_h_rec.PRE_TAX_IRR,
        l_okl_k_headers_h_rec.AFTER_TAX_IRR,
        l_okl_k_headers_h_rec.EXPECTED_DELIVERY_DATE,
        l_okl_k_headers_h_rec.ACCEPTED_DATE,
        l_okl_k_headers_h_rec.PREFUNDING_ELIGIBLE_YN,
        l_okl_k_headers_h_rec.REVOLVING_CREDIT_YN,
--Bug# 2697681 schema changes  11.5.9
        l_okl_k_headers_h_rec.CURRENCY_CONVERSION_TYPE,
        l_okl_k_headers_h_rec.CURRENCY_CONVERSION_RATE,
        l_okl_k_headers_h_rec.CURRENCY_CONVERSION_DATE,
        l_okl_k_headers_h_rec.MULTI_GAAP_YN,
        l_okl_k_headers_h_rec.RECOURSE_CODE,
        l_okl_k_headers_h_rec.LESSOR_SERV_ORG_CODE,
        l_okl_k_headers_h_rec.ASSIGNABLE_YN,
        l_okl_k_headers_h_rec.SECURITIZED_CODE,
        l_okl_k_headers_h_rec.SECURITIZATION_TYPE,
--Bug#3143522 : 11.5.10
   --subsidy
   l_okl_k_headers_h_rec.SUB_PRE_TAX_YIELD,
   l_okl_k_headers_h_rec.SUB_AFTER_TAX_YIELD,
   l_okl_k_headers_h_rec.SUB_IMPL_INTEREST_RATE,
   l_okl_k_headers_h_rec.SUB_IMPL_NON_IDC_INT_RATE,
   l_okl_k_headers_h_rec.SUB_PRE_TAX_IRR,
   l_okl_k_headers_h_rec.SUB_AFTER_TAX_IRR,
   --Bug# 3973640 : 11.5.10+
   l_okl_k_headers_h_rec.TOT_CL_TRANSFER_AMT,
   l_okl_k_headers_h_rec.TOT_CL_NET_TRANSFER_AMT,
   l_okl_k_headers_h_rec.TOT_CL_LIMIT,
   l_okl_k_headers_h_rec.TOT_CL_FUNDING_AMT,
   l_okl_k_headers_h_rec.CRS_ID,
   l_okl_k_headers_h_rec.TEMPLATE_TYPE_CODE,
--Bug# 4419339 OKLH Schema Sales Quote
   l_okl_k_headers_h_rec.DATE_FUNDING_EXPECTED ,
   l_okl_k_headers_h_rec.DATE_TRADEIN,
   l_okl_k_headers_h_rec.TRADEIN_AMOUNT,
   l_okl_k_headers_h_rec.TRADEIN_DESCRIPTION,
   --Added by dpsingh for LE uptake
   l_okl_k_headers_h_rec.LEGAL_ENTITY_ID
        ;

Line: 1652


      SELECT
	ID,
        OBJECT_VERSION_NUMBER,
        ISG_ID,
        KHR_ID,
        PDT_ID,
        AMD_CODE,
        DATE_FIRST_ACTIVITY,
        GENERATE_ACCRUAL_YN,
        GENERATE_ACCRUAL_OVERRIDE_YN,
        DATE_REFINANCED,
        CREDIT_ACT_YN,
        TERM_DURATION,
        CONVERTED_ACCOUNT_YN,
        DATE_CONVERSION_EFFECTIVE,
        SYNDICATABLE_YN,
        SALESTYPE_YN,
        DATE_DEAL_TRANSFERRED,
        DATETIME_PROPOSAL_EFFECTIVE,
        DATETIME_PROPOSAL_INEFFECTIVE,
        DATE_PROPOSAL_ACCEPTED,
        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,
        PRE_TAX_YIELD,
        AFTER_TAX_YIELD,
        IMPLICIT_INTEREST_RATE,
        IMPLICIT_NON_IDC_INTEREST_RATE,
        TARGET_PRE_TAX_YIELD,
        TARGET_AFTER_TAX_YIELD,
        TARGET_IMPLICIT_INTEREST_RATE,
        TARGET_IMPLICIT_NONIDC_INTRATE,
        DATE_LAST_INTERIM_INTEREST_CAL,
        DEAL_TYPE,
        PRE_TAX_IRR,
        AFTER_TAX_IRR,
        EXPECTED_DELIVERY_DATE,
        ACCEPTED_DATE,
        PREFUNDING_ELIGIBLE_YN,
        REVOLVING_CREDIT_YN,
--Bug# 2697681 schema changes  11.5.9
        CURRENCY_CONVERSION_TYPE,
        CURRENCY_CONVERSION_RATE,
        CURRENCY_CONVERSION_DATE,
        MULTI_GAAP_YN,
        RECOURSE_CODE,
        LESSOR_SERV_ORG_CODE,
        ASSIGNABLE_YN,
        SECURITIZED_CODE,
        SECURITIZATION_TYPE,
--Bug#3143522 : 11.5.10
   --subsidy
   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# 3973640 11.5.10+ schema
   TOT_CL_TRANSFER_AMT,
   TOT_CL_NET_TRANSFER_AMT,
   TOT_CL_LIMIT,
   TOT_CL_FUNDING_AMT,
   CRS_ID,
   TEMPLATE_TYPE_CODE,
--Bug# 4419339 OKLH Schema Sales Quote
   DATE_FUNDING_EXPECTED ,
   DATE_TRADEIN,
   TRADEIN_AMOUNT,
   TRADEIN_DESCRIPTION,
   --Added by dpsingh for LE uptake
   LEGAL_ENTITY_ID
      FROM OKL_K_HEADERS_V
      WHERE OKL_K_HEADERS_V.id     = p_id;

Line: 1790


        l_khrv_rec.LAST_UPDATED_BY,
        l_khrv_rec.LAST_UPDATE_DATE,
        l_khrv_rec.LAST_UPDATE_LOGIN,
        l_khrv_rec.PRE_TAX_YIELD,
        l_khrv_rec.AFTER_TAX_YIELD,
        l_khrv_rec.IMPLICIT_INTEREST_RATE,
        l_khrv_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
        l_khrv_rec.TARGET_PRE_TAX_YIELD,
        l_khrv_rec.TARGET_AFTER_TAX_YIELD,
        l_khrv_rec.TARGET_IMPLICIT_INTEREST_RATE,
        l_khrv_rec.TARGET_IMPLICIT_NONIDC_INTRATE,
        l_khrv_rec.DATE_LAST_INTERIM_INTEREST_CAL,
        l_khrv_rec.DEAL_TYPE,
        l_khrv_rec.PRE_TAX_IRR,
        l_khrv_rec.AFTER_TAX_IRR,
        l_khrv_rec.EXPECTED_DELIVERY_DATE,
        l_khrv_rec.ACCEPTED_DATE,
        l_khrv_rec.PREFUNDING_ELIGIBLE_YN,
        l_khrv_rec.REVOLVING_CREDIT_YN,
--Bug# 2697681 schema changes  11.5.9
        l_khrv_rec.CURRENCY_CONVERSION_TYPE,
        l_khrv_rec.CURRENCY_CONVERSION_RATE,
        l_khrv_rec.CURRENCY_CONVERSION_DATE,
        l_khrv_rec.MULTI_GAAP_YN,
        l_khrv_rec.RECOURSE_CODE,
        l_khrv_rec.LESSOR_SERV_ORG_CODE,
        l_khrv_rec.ASSIGNABLE_YN,
        l_khrv_rec.SECURITIZED_CODE,
        l_khrv_rec.SECURITIZATION_TYPE,
--Bug#3143522 : 11.5.10
   --subsidy
   l_khrv_rec.SUB_PRE_TAX_YIELD,
   l_khrv_rec.SUB_AFTER_TAX_YIELD,
   l_khrv_rec.SUB_IMPL_INTEREST_RATE,
   l_khrv_rec.SUB_IMPL_NON_IDC_INT_RATE,
   l_khrv_rec.SUB_PRE_TAX_IRR,
   l_khrv_rec.SUB_AFTER_TAX_IRR,
   --Bug# 3973640 11.5.10+ schema
   l_khrv_rec.TOT_CL_TRANSFER_AMT,
   l_khrv_rec.TOT_CL_NET_TRANSFER_AMT,
   l_khrv_rec.TOT_CL_LIMIT,
   l_khrv_rec.TOT_CL_FUNDING_AMT,
   l_khrv_rec.CRS_ID,
   l_khrv_rec.TEMPLATE_TYPE_CODE,
--Bug# 4419339 OKLH Schema Sales Quote
   l_khrv_rec.DATE_FUNDING_EXPECTED ,
   l_khrv_rec.DATE_TRADEIN,
   l_khrv_rec.TRADEIN_AMOUNT,
   l_khrv_rec.TRADEIN_DESCRIPTION,
   --Added by dpsingh for LE uptake
   l_khrv_rec.LEGAL_ENTITY_ID ;

Line: 2016


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

Line: 2020


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

Line: 2024


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

Line: 2285


      p_to.LAST_UPDATED_BY := p_from.LAST_UPDATED_BY;

Line: 2287


      p_to.LAST_UPDATE_DATE := p_from.LAST_UPDATE_DATE;

Line: 2289


      p_to.LAST_UPDATE_LOGIN := p_from.LAST_UPDATE_LOGIN;

Line: 2441


      p_to.LAST_UPDATED_BY := p_from.LAST_UPDATED_BY;

Line: 2443


      p_to.LAST_UPDATE_DATE := p_from.LAST_UPDATE_DATE;

Line: 2445


      p_to.LAST_UPDATE_LOGIN := p_from.LAST_UPDATE_LOGIN;

Line: 2595


      p_to.LAST_UPDATED_BY := p_from.LAST_UPDATED_BY;

Line: 2597


      p_to.LAST_UPDATE_DATE := p_from.LAST_UPDATE_DATE;

Line: 2599


      p_to.LAST_UPDATE_LOGIN := p_from.LAST_UPDATE_LOGIN;

Line: 2850


  PROCEDURE insert_row(

    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_okl_k_headers_h_rec                     IN okl_k_headers_h_rec_type,
    x_okl_k_headers_h_rec                     OUT NOCOPY okl_k_headers_h_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2861


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

Line: 2902


    INSERT INTO OKL_K_HEADERS_H(
	ID,
        MAJOR_VERSION,
        ISG_ID,
        KHR_ID,
        PDT_ID,
        OBJECT_VERSION_NUMBER,
        DATE_FIRST_ACTIVITY,
        SYNDICATABLE_YN,
        SALESTYPE_YN,
        DATE_REFINANCED,
        DATE_CONVERSION_EFFECTIVE,
        DATE_DEAL_TRANSFERRED,
        TERM_DURATION,
        DATETIME_PROPOSAL_EFFECTIVE,
        DATETIME_PROPOSAL_INEFFECTIVE,
        DATE_PROPOSAL_ACCEPTED,
        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,
        AMD_CODE,
        GENERATE_ACCRUAL_YN,
        GENERATE_ACCRUAL_OVERRIDE_YN,
        CREDIT_ACT_YN,
        CONVERTED_ACCOUNT_YN,
        PRE_TAX_YIELD,
        AFTER_TAX_YIELD,
        IMPLICIT_INTEREST_RATE,
        IMPLICIT_NON_IDC_INTEREST_RATE,
        TARGET_PRE_TAX_YIELD,
        TARGET_AFTER_TAX_YIELD,
        TARGET_IMPLICIT_INTEREST_RATE,
        TARGET_IMPLICIT_NONIDC_INTRATE,
        DATE_LAST_INTERIM_INTEREST_CAL,
        DEAL_TYPE,
        PRE_TAX_IRR,
        AFTER_TAX_IRR,
        EXPECTED_DELIVERY_DATE,
        ACCEPTED_DATE,
        PREFUNDING_ELIGIBLE_YN,
        REVOLVING_CREDIT_YN,
--Bug# 2697681 schema changes  11.5.9
        CURRENCY_CONVERSION_TYPE,
        CURRENCY_CONVERSION_RATE,
        CURRENCY_CONVERSION_DATE,
        MULTI_GAAP_YN,
        RECOURSE_CODE,
        LESSOR_SERV_ORG_CODE,
        ASSIGNABLE_YN,
        SECURITIZED_CODE,
        SECURITIZATION_TYPE,
--Bug#3143522 : 11.5.10
   --subsidy
   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# 3973640 : 11.5.10+ schema
   TOT_CL_TRANSFER_AMT,
   TOT_CL_NET_TRANSFER_AMT,
   TOT_CL_LIMIT,
   TOT_CL_FUNDING_AMT,
   CRS_ID,
   TEMPLATE_TYPE_CODE,
--Bug# 4419339 OKLH Schema Sales Quote
   DATE_FUNDING_EXPECTED,
   DATE_TRADEIN,
   TRADEIN_AMOUNT,
   TRADEIN_DESCRIPTION,
    --Added by dpsingh for LE uptake
    LEGAL_ENTITY_ID
        )
      VALUES (
       l_okl_k_headers_h_rec.ID,
        l_okl_k_headers_h_rec.MAJOR_VERSION,
        l_okl_k_headers_h_rec.ISG_ID,
        l_okl_k_headers_h_rec.KHR_ID,
        l_okl_k_headers_h_rec.PDT_ID,
        l_okl_k_headers_h_rec.OBJECT_VERSION_NUMBER,
        l_okl_k_headers_h_rec.DATE_FIRST_ACTIVITY,
        l_okl_k_headers_h_rec.SYNDICATABLE_YN,
        l_okl_k_headers_h_rec.SALESTYPE_YN,
        l_okl_k_headers_h_rec.DATE_REFINANCED,
        l_okl_k_headers_h_rec.DATE_CONVERSION_EFFECTIVE,
        l_okl_k_headers_h_rec.DATE_DEAL_TRANSFERRED,
        l_okl_k_headers_h_rec.TERM_DURATION,
        l_okl_k_headers_h_rec.DATETIME_PROPOSAL_EFFECTIVE,
        l_okl_k_headers_h_rec.DATETIME_PROPOSAL_INEFFECTIVE,
        l_okl_k_headers_h_rec.DATE_PROPOSAL_ACCEPTED,
        l_okl_k_headers_h_rec.ATTRIBUTE_CATEGORY,
        l_okl_k_headers_h_rec.ATTRIBUTE1,
        l_okl_k_headers_h_rec.ATTRIBUTE2,
        l_okl_k_headers_h_rec.ATTRIBUTE3,
        l_okl_k_headers_h_rec.ATTRIBUTE4,
        l_okl_k_headers_h_rec.ATTRIBUTE5,
        l_okl_k_headers_h_rec.ATTRIBUTE6,
        l_okl_k_headers_h_rec.ATTRIBUTE7,
        l_okl_k_headers_h_rec.ATTRIBUTE8,
        l_okl_k_headers_h_rec.ATTRIBUTE9,
        l_okl_k_headers_h_rec.ATTRIBUTE10,
        l_okl_k_headers_h_rec.ATTRIBUTE11,
        l_okl_k_headers_h_rec.ATTRIBUTE12,
        l_okl_k_headers_h_rec.ATTRIBUTE13,
        l_okl_k_headers_h_rec.ATTRIBUTE14,
        l_okl_k_headers_h_rec.ATTRIBUTE15,
        l_okl_k_headers_h_rec.CREATED_BY,
        l_okl_k_headers_h_rec.CREATION_DATE,
        l_okl_k_headers_h_rec.LAST_UPDATED_BY,
        l_okl_k_headers_h_rec.LAST_UPDATE_DATE,
        l_okl_k_headers_h_rec.LAST_UPDATE_LOGIN,
        l_okl_k_headers_h_rec.AMD_CODE,
        l_okl_k_headers_h_rec.GENERATE_ACCRUAL_YN,
        l_okl_k_headers_h_rec.GENERATE_ACCRUAL_OVERRIDE_YN,
        l_okl_k_headers_h_rec.CREDIT_ACT_YN,
        l_okl_k_headers_h_rec.CONVERTED_ACCOUNT_YN,
        l_okl_k_headers_h_rec.PRE_TAX_YIELD,
        l_okl_k_headers_h_rec.AFTER_TAX_YIELD,
        l_okl_k_headers_h_rec.IMPLICIT_INTEREST_RATE,
        l_okl_k_headers_h_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
        l_okl_k_headers_h_rec.TARGET_PRE_TAX_YIELD,
        l_okl_k_headers_h_rec.TARGET_AFTER_TAX_YIELD,
        l_okl_k_headers_h_rec.TARGET_IMPLICIT_INTEREST_RATE,
        l_okl_k_headers_h_rec.TARGET_IMPLICIT_NONIDC_INTRATE,
        l_okl_k_headers_h_rec.DATE_LAST_INTERIM_INTEREST_CAL,
        l_okl_k_headers_h_rec.DEAL_TYPE,
        l_okl_k_headers_h_rec.PRE_TAX_IRR,
        l_okl_k_headers_h_rec.AFTER_TAX_IRR,
        l_okl_k_headers_h_rec.EXPECTED_DELIVERY_DATE,
        l_okl_k_headers_h_rec.ACCEPTED_DATE,
        l_okl_k_headers_h_rec.PREFUNDING_ELIGIBLE_YN,
        l_okl_k_headers_h_rec.REVOLVING_CREDIT_YN,
        --Bug# 2697681 schema changes  11.5.9
        l_okl_k_headers_h_rec.CURRENCY_CONVERSION_TYPE,
        l_okl_k_headers_h_rec.CURRENCY_CONVERSION_RATE,
        l_okl_k_headers_h_rec.CURRENCY_CONVERSION_DATE,
        l_okl_k_headers_h_rec.MULTI_GAAP_YN,
        l_okl_k_headers_h_rec.RECOURSE_CODE,
        l_okl_k_headers_h_rec.LESSOR_SERV_ORG_CODE,
        l_okl_k_headers_h_rec.ASSIGNABLE_YN,
        l_okl_k_headers_h_rec.SECURITIZED_CODE,
        l_okl_k_headers_h_rec.SECURITIZATION_TYPE,
--Bug#3143522 : 11.5.10
   --subsidy
   l_okl_k_headers_h_rec.SUB_PRE_TAX_YIELD,
   l_okl_k_headers_h_rec.SUB_AFTER_TAX_YIELD,
   l_okl_k_headers_h_rec.SUB_IMPL_INTEREST_RATE,
   l_okl_k_headers_h_rec.SUB_IMPL_NON_IDC_INT_RATE,
   l_okl_k_headers_h_rec.SUB_PRE_TAX_IRR,
   l_okl_k_headers_h_rec.SUB_AFTER_TAX_IRR,
   --Bug# 3973640 : 11.5.10+ schema
   l_okl_k_headers_h_rec.TOT_CL_TRANSFER_AMT,
   l_okl_k_headers_h_rec.TOT_CL_NET_TRANSFER_AMT,
   l_okl_k_headers_h_rec.TOT_CL_LIMIT,
   l_okl_k_headers_h_rec.TOT_CL_FUNDING_AMT,
   l_okl_k_headers_h_rec.CRS_ID,
   l_okl_k_headers_h_rec.TEMPLATE_TYPE_CODE,
--Bug# 4419339 OKLH Schema Sales Quote
   l_okl_k_headers_h_rec.DATE_FUNDING_EXPECTED,
   l_okl_k_headers_h_rec.DATE_TRADEIN,
   l_okl_k_headers_h_rec.TRADEIN_AMOUNT,
   l_okl_k_headers_h_rec.TRADEIN_DESCRIPTION,
   --Added by dpsingh for LE uptake
   l_okl_k_headers_h_rec.LEGAL_ENTITY_ID);

Line: 3121


  END insert_row;

Line: 3127


  PROCEDURE insert_row(

    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_khr_rec                     IN khr_rec_type,
    x_khr_rec                     OUT NOCOPY khr_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3138


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

Line: 3179


    INSERT INTO OKL_K_HEADERS(
	ID,
        ISG_ID,
        KHR_ID,
        PDT_ID,
        OBJECT_VERSION_NUMBER,
        DATE_FIRST_ACTIVITY,
        SYNDICATABLE_YN,
        SALESTYPE_YN,
        DATE_REFINANCED,
        DATE_CONVERSION_EFFECTIVE,
        DATE_DEAL_TRANSFERRED,
        TERM_DURATION,
        DATETIME_PROPOSAL_EFFECTIVE,
        DATETIME_PROPOSAL_INEFFECTIVE,
        DATE_PROPOSAL_ACCEPTED,
        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,
        AMD_CODE,
        GENERATE_ACCRUAL_YN,
        GENERATE_ACCRUAL_OVERRIDE_YN,
        CREDIT_ACT_YN,
        CONVERTED_ACCOUNT_YN,
        PRE_TAX_YIELD,
        AFTER_TAX_YIELD,
        IMPLICIT_INTEREST_RATE,
        IMPLICIT_NON_IDC_INTEREST_RATE,
        TARGET_PRE_TAX_YIELD,
        TARGET_AFTER_TAX_YIELD,
        TARGET_IMPLICIT_INTEREST_RATE,
        TARGET_IMPLICIT_NONIDC_INTRATE,
        DATE_LAST_INTERIM_INTEREST_CAL,
        DEAL_TYPE,
        PRE_TAX_IRR,
        AFTER_TAX_IRR,
        EXPECTED_DELIVERY_DATE,
        ACCEPTED_DATE,
        PREFUNDING_ELIGIBLE_YN,
        REVOLVING_CREDIT_YN,
--Bug# 2697681 schema changes  11.5.9
        CURRENCY_CONVERSION_TYPE,
        CURRENCY_CONVERSION_RATE,
        CURRENCY_CONVERSION_DATE,
        MULTI_GAAP_YN,
        RECOURSE_CODE,
        LESSOR_SERV_ORG_CODE,
        ASSIGNABLE_YN,
        SECURITIZED_CODE,
        SECURITIZATION_TYPE,
--Bug#3143522 : 11.5.10
   --subsidy
   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# 3973640 : 11.5.10+ schema
   TOT_CL_TRANSFER_AMT,
   TOT_CL_NET_TRANSFER_AMT,
   TOT_CL_LIMIT,
   TOT_CL_FUNDING_AMT,
  -- Schema Change for Vendor Enhancements
   CRS_ID,
   TEMPLATE_TYPE_CODE,
--Bug# 4419339 OKLH Schema Sales Quote
   DATE_FUNDING_EXPECTED,
   DATE_TRADEIN,
   TRADEIN_AMOUNT,
   TRADEIN_DESCRIPTION,
   --Added by dpsingh for LE uptake
   LEGAL_ENTITY_ID
        )
      VALUES (
       l_khr_rec.ID,
        l_khr_rec.ISG_ID,
        l_khr_rec.KHR_ID,
        l_khr_rec.PDT_ID,
        l_khr_rec.OBJECT_VERSION_NUMBER,
        l_khr_rec.DATE_FIRST_ACTIVITY,
        l_khr_rec.SYNDICATABLE_YN,
        l_khr_rec.SALESTYPE_YN,
        l_khr_rec.DATE_REFINANCED,
        l_khr_rec.DATE_CONVERSION_EFFECTIVE,
        l_khr_rec.DATE_DEAL_TRANSFERRED,
        l_khr_rec.TERM_DURATION,
        l_khr_rec.DATETIME_PROPOSAL_EFFECTIVE,
        l_khr_rec.DATETIME_PROPOSAL_INEFFECTIVE,
        l_khr_rec.DATE_PROPOSAL_ACCEPTED,
        l_khr_rec.ATTRIBUTE_CATEGORY,
        l_khr_rec.ATTRIBUTE1,
        l_khr_rec.ATTRIBUTE2,
        l_khr_rec.ATTRIBUTE3,
        l_khr_rec.ATTRIBUTE4,
        l_khr_rec.ATTRIBUTE5,
        l_khr_rec.ATTRIBUTE6,
        l_khr_rec.ATTRIBUTE7,
        l_khr_rec.ATTRIBUTE8,
        l_khr_rec.ATTRIBUTE9,
        l_khr_rec.ATTRIBUTE10,
        l_khr_rec.ATTRIBUTE11,
        l_khr_rec.ATTRIBUTE12,
        l_khr_rec.ATTRIBUTE13,
        l_khr_rec.ATTRIBUTE14,
        l_khr_rec.ATTRIBUTE15,
        l_khr_rec.CREATED_BY,
        l_khr_rec.CREATION_DATE,
        l_khr_rec.LAST_UPDATED_BY,
        l_khr_rec.LAST_UPDATE_DATE,
        l_khr_rec.LAST_UPDATE_LOGIN,
        l_khr_rec.AMD_CODE,
        l_khr_rec.GENERATE_ACCRUAL_YN,
        l_khr_rec.GENERATE_ACCRUAL_OVERRIDE_YN,
        l_khr_rec.CREDIT_ACT_YN,
        l_khr_rec.CONVERTED_ACCOUNT_YN,
        l_khr_rec.PRE_TAX_YIELD,
        l_khr_rec.AFTER_TAX_YIELD,
        l_khr_rec.IMPLICIT_INTEREST_RATE,
        l_khr_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
        l_khr_rec.TARGET_PRE_TAX_YIELD,
        l_khr_rec.TARGET_AFTER_TAX_YIELD,
        l_khr_rec.TARGET_IMPLICIT_INTEREST_RATE,
        l_khr_rec.TARGET_IMPLICIT_NONIDC_INTRATE,
        l_khr_rec.DATE_LAST_INTERIM_INTEREST_CAL,
        l_khr_rec.DEAL_TYPE,
        l_khr_rec.PRE_TAX_IRR,
        l_khr_rec.AFTER_TAX_IRR,
        l_khr_rec.EXPECTED_DELIVERY_DATE,
        l_khr_rec.ACCEPTED_DATE,
        l_khr_rec.PREFUNDING_ELIGIBLE_YN,
        l_khr_rec.REVOLVING_CREDIT_YN,
--Bug# 2697681 schema changes  11.5.9
        l_khr_rec.CURRENCY_CONVERSION_TYPE,
        l_khr_rec.CURRENCY_CONVERSION_RATE,
        l_khr_rec.CURRENCY_CONVERSION_DATE,
        l_khr_rec.MULTI_GAAP_YN,
        l_khr_rec.RECOURSE_CODE,
        l_khr_rec.LESSOR_SERV_ORG_CODE,
        l_khr_rec.ASSIGNABLE_YN,
        l_khr_rec.SECURITIZED_CODE,
        l_khr_rec.SECURITIZATION_TYPE,
--Bug#3143522 : 11.5.10
   --subsidy
   l_khr_rec.SUB_PRE_TAX_YIELD,
   l_khr_rec.SUB_AFTER_TAX_YIELD,
   l_khr_rec.SUB_IMPL_INTEREST_RATE,
   l_khr_rec.SUB_IMPL_NON_IDC_INT_RATE,
   l_khr_rec.SUB_PRE_TAX_IRR,
   l_khr_rec.SUB_AFTER_TAX_IRR,
  --Bug# 3973640 : 11.5.10+ schema
   l_khr_rec.TOT_CL_TRANSFER_AMT,
   l_khr_rec.TOT_CL_NET_TRANSFER_AMT,
   l_khr_rec.TOT_CL_LIMIT,
   l_khr_rec.TOT_CL_FUNDING_AMT,
  -- Schema Change for Vendor Enhancements
   l_khr_rec.CRS_ID,
   l_khr_rec.TEMPLATE_TYPE_CODE,
--Bug# 4419339 OKLH Schema Sales Quote
   l_khr_rec.DATE_FUNDING_EXPECTED,
   l_khr_rec.DATE_TRADEIN,
   l_khr_rec.TRADEIN_AMOUNT,
   l_khr_rec.TRADEIN_DESCRIPTION,
   --Added by dpsingh for LE uptake
   l_khr_rec.LEGAL_ENTITY_ID);

Line: 3398


  END insert_row;

Line: 3404


  PROCEDURE insert_row(

    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_khrv_rec                     IN khrv_rec_type,
    x_khrv_rec                     OUT NOCOPY khrv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3415


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

Line: 3431


      l_khrv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 3432


      l_khrv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 3433


      l_khrv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 3510


    insert_row(
      l_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_khr_rec,
      lx_khr_rec
    );

Line: 3563


  END insert_row;

Line: 3569


  PROCEDURE insert_row(

    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_khrv_tbl                     IN khrv_tbl_type,
    x_khrv_tbl                     OUT NOCOPY khrv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3580


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

Line: 3589


        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_khrv_rec                     => p_khrv_tbl(i),
          x_khrv_rec                     => x_khrv_tbl(i));

Line: 3634


  END insert_row;

Line: 3657


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_K_HEADERS
     WHERE ID = p_khr_rec.id
       AND OBJECT_VERSION_NUMBER = p_khr_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 3664


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_K_HEADERS
    WHERE ID = p_khr_rec.id;

Line: 3707


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 3716


      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 3922


  PROCEDURE update_row(

    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_khr_rec                     IN khr_rec_type,
    x_khr_rec                     OUT NOCOPY khr_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3933


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

Line: 4094


      IF (x_khr_rec.LAST_UPDATED_BY = OKC_API.G_MISS_NUM) THEN
      x_khr_rec.LAST_UPDATED_BY := l_khr_rec.LAST_UPDATED_BY;

Line: 4098


      IF (x_khr_rec.LAST_UPDATE_DATE = OKC_API.G_MISS_DATE) THEN
      x_khr_rec.LAST_UPDATE_DATE := l_khr_rec.LAST_UPDATE_DATE;

Line: 4102


      IF (x_khr_rec.LAST_UPDATE_LOGIN = OKC_API.G_MISS_NUM) THEN
      x_khr_rec.LAST_UPDATE_LOGIN := l_khr_rec.LAST_UPDATE_LOGIN;

Line: 4327


    UPDATE  OKL_K_HEADERS
    SET
    ID = l_def_khr_rec.ID,
        ISG_ID = l_def_khr_rec.ISG_ID,
        KHR_ID = l_def_khr_rec.KHR_ID,
        PDT_ID = l_def_khr_rec.PDT_ID,
        OBJECT_VERSION_NUMBER = l_def_khr_rec.OBJECT_VERSION_NUMBER,
        DATE_FIRST_ACTIVITY = l_def_khr_rec.DATE_FIRST_ACTIVITY,
        SYNDICATABLE_YN = l_def_khr_rec.SYNDICATABLE_YN,
        SALESTYPE_YN = l_def_khr_rec.SALESTYPE_YN,
        DATE_REFINANCED = l_def_khr_rec.DATE_REFINANCED,
        DATE_CONVERSION_EFFECTIVE = l_def_khr_rec.DATE_CONVERSION_EFFECTIVE,
        DATE_DEAL_TRANSFERRED = l_def_khr_rec.DATE_DEAL_TRANSFERRED,
        TERM_DURATION = l_def_khr_rec.TERM_DURATION,
        DATETIME_PROPOSAL_EFFECTIVE = l_def_khr_rec.DATETIME_PROPOSAL_EFFECTIVE,
        DATETIME_PROPOSAL_INEFFECTIVE = l_def_khr_rec.DATETIME_PROPOSAL_INEFFECTIVE,
        DATE_PROPOSAL_ACCEPTED = l_def_khr_rec.DATE_PROPOSAL_ACCEPTED,
        ATTRIBUTE_CATEGORY = l_def_khr_rec.ATTRIBUTE_CATEGORY,
        ATTRIBUTE1 = l_def_khr_rec.ATTRIBUTE1,
        ATTRIBUTE2 = l_def_khr_rec.ATTRIBUTE2,
        ATTRIBUTE3 = l_def_khr_rec.ATTRIBUTE3,
        ATTRIBUTE4 = l_def_khr_rec.ATTRIBUTE4,
        ATTRIBUTE5 = l_def_khr_rec.ATTRIBUTE5,
        ATTRIBUTE6 = l_def_khr_rec.ATTRIBUTE6,
        ATTRIBUTE7 = l_def_khr_rec.ATTRIBUTE7,
        ATTRIBUTE8 = l_def_khr_rec.ATTRIBUTE8,
        ATTRIBUTE9 = l_def_khr_rec.ATTRIBUTE9,
        ATTRIBUTE10 = l_def_khr_rec.ATTRIBUTE10,
        ATTRIBUTE11 = l_def_khr_rec.ATTRIBUTE11,
        ATTRIBUTE12 = l_def_khr_rec.ATTRIBUTE12,
        ATTRIBUTE13 = l_def_khr_rec.ATTRIBUTE13,
        ATTRIBUTE14 = l_def_khr_rec.ATTRIBUTE14,
        ATTRIBUTE15 = l_def_khr_rec.ATTRIBUTE15,
        CREATED_BY = l_def_khr_rec.CREATED_BY,
        CREATION_DATE = l_def_khr_rec.CREATION_DATE,
        LAST_UPDATED_BY = l_def_khr_rec.LAST_UPDATED_BY,
        LAST_UPDATE_DATE = l_def_khr_rec.LAST_UPDATE_DATE,
        LAST_UPDATE_LOGIN = l_def_khr_rec.LAST_UPDATE_LOGIN,
        AMD_CODE = l_def_khr_rec.AMD_CODE,
        GENERATE_ACCRUAL_YN = l_def_khr_rec.GENERATE_ACCRUAL_YN,
        GENERATE_ACCRUAL_OVERRIDE_YN = l_def_khr_rec.GENERATE_ACCRUAL_OVERRIDE_YN,
        CREDIT_ACT_YN = l_def_khr_rec.CREDIT_ACT_YN,
        CONVERTED_ACCOUNT_YN = l_def_khr_rec.CONVERTED_ACCOUNT_YN,
        PRE_TAX_YIELD = l_def_khr_rec.PRE_TAX_YIELD,
        AFTER_TAX_YIELD = l_def_khr_rec.AFTER_TAX_YIELD,
        IMPLICIT_INTEREST_RATE = l_def_khr_rec.IMPLICIT_INTEREST_RATE,
        IMPLICIT_NON_IDC_INTEREST_RATE = l_def_khr_rec.IMPLICIT_NON_IDC_INTEREST_RATE,
        TARGET_PRE_TAX_YIELD = l_def_khr_rec.TARGET_PRE_TAX_YIELD,
        TARGET_AFTER_TAX_YIELD = l_def_khr_rec.TARGET_AFTER_TAX_YIELD,
        TARGET_IMPLICIT_INTEREST_RATE = l_def_khr_rec.TARGET_IMPLICIT_INTEREST_RATE,
        TARGET_IMPLICIT_NONIDC_INTRATE = l_def_khr_rec.TARGET_IMPLICIT_NONIDC_INTRATE,
        DATE_LAST_INTERIM_INTEREST_CAL = l_def_khr_rec.DATE_LAST_INTERIM_INTEREST_CAL,
        DEAL_TYPE = l_def_khr_rec.DEAL_TYPE,
        PRE_TAX_IRR = l_def_khr_rec.PRE_TAX_IRR,
        AFTER_TAX_IRR = l_def_khr_rec.AFTER_TAX_IRR,
        EXPECTED_DELIVERY_DATE = l_def_khr_rec.EXPECTED_DELIVERY_DATE,
        ACCEPTED_DATE = l_def_khr_rec.ACCEPTED_DATE,
        PREFUNDING_ELIGIBLE_YN = l_def_khr_rec.PREFUNDING_ELIGIBLE_YN,
        REVOLVING_CREDIT_YN = l_def_khr_rec.REVOLVING_CREDIT_YN,
--Bug# 2697681 schema changes  11.5.9
        CURRENCY_CONVERSION_TYPE   = l_def_khr_rec.CURRENCY_CONVERSION_TYPE,
        CURRENCY_CONVERSION_RATE   = l_def_khr_rec.CURRENCY_CONVERSION_RATE,
        CURRENCY_CONVERSION_DATE   = l_def_khr_rec.CURRENCY_CONVERSION_DATE,
        MULTI_GAAP_YN              = l_def_khr_rec.MULTI_GAAP_YN,
        RECOURSE_CODE              = l_def_khr_rec.RECOURSE_CODE,
        LESSOR_SERV_ORG_CODE       = l_def_khr_rec.LESSOR_SERV_ORG_CODE,
        ASSIGNABLE_YN              = l_def_khr_rec.ASSIGNABLE_YN,
        SECURITIZED_CODE           = l_def_khr_rec.SECURITIZED_CODE,
        SECURITIZATION_TYPE        = l_def_khr_rec.SECURITIZATION_TYPE,
--Bug# 3143522 : 11.5.10
   --subsidy
   SUB_PRE_TAX_YIELD                          = l_def_khr_rec.SUB_PRE_TAX_YIELD,
   SUB_AFTER_TAX_YIELD                        = l_def_khr_rec.SUB_AFTER_TAX_YIELD,
   SUB_IMPL_INTEREST_RATE                     = l_def_khr_rec.SUB_IMPL_INTEREST_RATE,
   SUB_IMPL_NON_IDC_INT_RATE                  = l_def_khr_rec.SUB_IMPL_NON_IDC_INT_RATE,
   SUB_PRE_TAX_IRR                            = l_def_khr_rec.SUB_PRE_TAX_IRR,
   SUB_AFTER_TAX_IRR                          = l_def_khr_rec.SUB_AFTER_TAX_IRR,
   --Bug# 3973640 : 11.5.10+ schema
   TOT_CL_TRANSFER_AMT                        = l_def_khr_rec.TOT_CL_TRANSFER_AMT,
   TOT_CL_NET_TRANSFER_AMT                    = l_def_khr_rec.TOT_CL_NET_TRANSFER_AMT,
   TOT_CL_LIMIT                               = l_def_khr_rec.TOT_CL_LIMIT,
   TOT_CL_FUNDING_AMT                         = l_def_khr_rec.TOT_CL_FUNDING_AMT,
   CRS_ID                                     = l_def_khr_rec.CRS_ID,
   TEMPLATE_TYPE_CODE                         = l_def_khr_rec.TEMPLATE_TYPE_CODE,
--Bug# 4419339 OKLH Schema Sales Quote
   DATE_FUNDING_EXPECTED                      = l_def_khr_rec.DATE_FUNDING_EXPECTED,
   DATE_TRADEIN                               = l_def_khr_rec.DATE_TRADEIN,
   TRADEIN_AMOUNT                             = l_def_khr_rec.TRADEIN_AMOUNT,
   TRADEIN_DESCRIPTION                        = l_def_khr_rec.TRADEIN_DESCRIPTION,
   --Added by dpsingh for LE uptake
   LEGAL_ENTITY_ID                        = l_def_khr_rec.LEGAL_ENTITY_ID
    WHERE ID = l_def_khr_rec.id;

Line: 4422


    insert_row(
      l_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_okl_k_headers_h_rec,
      lx_okl_k_headers_h_rec
    );

Line: 4474


  END update_row;

Line: 4480


  PROCEDURE update_row(

    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_khrv_rec                     IN khrv_rec_type,
    x_khrv_rec                     OUT NOCOPY khrv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 4491


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

Line: 4505


      l_khrv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 4506


      l_khrv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 4507


      l_khrv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 4681


      IF (x_khrv_rec.LAST_UPDATED_BY = OKC_API.G_MISS_NUM) THEN
      x_khrv_rec.LAST_UPDATED_BY := l_khrv_rec.LAST_UPDATED_BY;

Line: 4685


      IF (x_khrv_rec.LAST_UPDATE_DATE = OKC_API.G_MISS_DATE) THEN
      x_khrv_rec.LAST_UPDATE_DATE := l_khrv_rec.LAST_UPDATE_DATE;

Line: 4689


      IF (x_khrv_rec.LAST_UPDATE_LOGIN = OKC_API.G_MISS_NUM) THEN
      x_khrv_rec.LAST_UPDATE_LOGIN := l_khrv_rec.LAST_UPDATE_LOGIN;

Line: 4928


    update_row(
      l_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_khr_rec,
      lx_khr_rec
    );

Line: 4980


  END update_row;

Line: 4985


  PROCEDURE update_row(

    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_khrv_tbl                     IN khrv_tbl_type,
    x_khrv_tbl                     OUT NOCOPY khrv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 4996


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

Line: 5005


        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_khrv_rec                     => p_khrv_tbl(i),
          x_khrv_rec                     => x_khrv_tbl(i));

Line: 5050


  END update_row;

Line: 5062


  PROCEDURE delete_row(

    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_khr_rec                     IN khr_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 5072


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

Line: 5090


/*-------removed as we do not do implicit versioning on delete------------------
    -- Insert into History table
    l_khr_rec := get_rec(l_khr_rec, l_row_notfound);

Line: 5097


    insert_row(
      l_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_okl_k_headers_h_rec,
      lx_okl_k_headers_h_rec
    );

Line: 5114


    DELETE FROM OKL_K_HEADERS
     WHERE ID = l_khr_rec.id;

Line: 5151


  END delete_row;

Line: 5153


  PROCEDURE delete_row(

    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_khrv_rec                     IN khrv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 5163


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

Line: 5189


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

Line: 5238


  END delete_row;

Line: 5243


  PROCEDURE delete_row(

    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_khrv_tbl                     IN khrv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 5253


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

Line: 5262


        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_khrv_rec                     => p_khrv_tbl(i));

Line: 5306


  END delete_row;

Line: 5320


INSERT INTO OKL_K_HEADERS_H
  (
      major_version,
	ID,
        ISG_ID,
        KHR_ID,
        PDT_ID,
        OBJECT_VERSION_NUMBER,
        DATE_FIRST_ACTIVITY,
        SYNDICATABLE_YN,
        SALESTYPE_YN,
        DATE_REFINANCED,
        DATE_CONVERSION_EFFECTIVE,
        DATE_DEAL_TRANSFERRED,
        TERM_DURATION,
        DATETIME_PROPOSAL_EFFECTIVE,
        DATETIME_PROPOSAL_INEFFECTIVE,
        DATE_PROPOSAL_ACCEPTED,
        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,
        AMD_CODE,
        GENERATE_ACCRUAL_YN,
        GENERATE_ACCRUAL_OVERRIDE_YN,
        CREDIT_ACT_YN,
        CONVERTED_ACCOUNT_YN,
        PRE_TAX_YIELD,
        AFTER_TAX_YIELD,
        IMPLICIT_INTEREST_RATE,
        IMPLICIT_NON_IDC_INTEREST_RATE,
        TARGET_PRE_TAX_YIELD,
        TARGET_AFTER_TAX_YIELD,
        TARGET_IMPLICIT_INTEREST_RATE,
        TARGET_IMPLICIT_NONIDC_INTRATE,
        DATE_LAST_INTERIM_INTEREST_CAL,
        DEAL_TYPE,
        PRE_TAX_IRR,
        AFTER_TAX_IRR,
        EXPECTED_DELIVERY_DATE,
        ACCEPTED_DATE,
        PREFUNDING_ELIGIBLE_YN,
        REVOLVING_CREDIT_YN,
--Bug# 2697681 schema changes  11.5.9
        CURRENCY_CONVERSION_TYPE,
        CURRENCY_CONVERSION_RATE,
        CURRENCY_CONVERSION_DATE,
        MULTI_GAAP_YN,
        RECOURSE_CODE,
        LESSOR_SERV_ORG_CODE,
        ASSIGNABLE_YN,
        SECURITIZED_CODE,
        SECURITIZATION_TYPE,
--Bug# 3143522 :11.5.10
   --subsidy
   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# 3973640 : 11.5.10+ schema
   TOT_CL_TRANSFER_AMT,
   TOT_CL_NET_TRANSFER_AMT,
   TOT_CL_LIMIT,
   TOT_CL_FUNDING_AMT   ,
   CRS_ID,
   TEMPLATE_TYPE_CODE ,
--Bug# 4419339 OKLH Schema Sales Quote
   DATE_FUNDING_EXPECTED,
   DATE_TRADEIN,
   TRADEIN_AMOUNT,
   TRADEIN_DESCRIPTION,
   --Added by dpsingh for LE uptake
   LEGAL_ENTITY_ID
   )
  SELECT
      p_major_version,
	ID,
        ISG_ID,
        KHR_ID,
        PDT_ID,
        OBJECT_VERSION_NUMBER,
        DATE_FIRST_ACTIVITY,
        SYNDICATABLE_YN,
        SALESTYPE_YN,
        DATE_REFINANCED,
        DATE_CONVERSION_EFFECTIVE,
        DATE_DEAL_TRANSFERRED,
        TERM_DURATION,
        DATETIME_PROPOSAL_EFFECTIVE,
        DATETIME_PROPOSAL_INEFFECTIVE,
        DATE_PROPOSAL_ACCEPTED,
        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,
        AMD_CODE,
        GENERATE_ACCRUAL_YN,
        GENERATE_ACCRUAL_OVERRIDE_YN,
        CREDIT_ACT_YN,
        CONVERTED_ACCOUNT_YN,
        PRE_TAX_YIELD,
        AFTER_TAX_YIELD,
        IMPLICIT_INTEREST_RATE,
        IMPLICIT_NON_IDC_INTEREST_RATE,
        TARGET_PRE_TAX_YIELD,
        TARGET_AFTER_TAX_YIELD,
        TARGET_IMPLICIT_INTEREST_RATE,
        TARGET_IMPLICIT_NONIDC_INTRATE,
        DATE_LAST_INTERIM_INTEREST_CAL,
        DEAL_TYPE,
        PRE_TAX_IRR,
        AFTER_TAX_IRR,
        EXPECTED_DELIVERY_DATE,
        ACCEPTED_DATE,
        PREFUNDING_ELIGIBLE_YN,
        REVOLVING_CREDIT_YN,
--Bug# 2697681 schema changes  11.5.9
        CURRENCY_CONVERSION_TYPE,
        CURRENCY_CONVERSION_RATE,
        CURRENCY_CONVERSION_DATE,
        MULTI_GAAP_YN,
        RECOURSE_CODE,
        LESSOR_SERV_ORG_CODE,
        ASSIGNABLE_YN,
        SECURITIZED_CODE,
        SECURITIZATION_TYPE,
--Bug#3143522 : 11.5.10
   --subsidy
   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# 3973640 : 11.5.10+ schema
   TOT_CL_TRANSFER_AMT,
   TOT_CL_NET_TRANSFER_AMT,
   TOT_CL_LIMIT,
   TOT_CL_FUNDING_AMT,
   CRS_ID,
   TEMPLATE_TYPE_CODE,
--Bug# 4419339 OKLH Schema Sales Quote
   DATE_FUNDING_EXPECTED,
   DATE_TRADEIN,
   TRADEIN_AMOUNT,
   TRADEIN_DESCRIPTION,
   --Added by dpsingh for LE uptake
   LEGAL_ENTITY_ID
  FROM OKL_K_HEADERS
  WHERE id = p_khr_id;

Line: 5531


INSERT INTO OKL_K_HEADERS
  (
	ID,
        ISG_ID,
        KHR_ID,
        PDT_ID,
        OBJECT_VERSION_NUMBER,
        DATE_FIRST_ACTIVITY,
        SYNDICATABLE_YN,
        SALESTYPE_YN,
        DATE_REFINANCED,
        DATE_CONVERSION_EFFECTIVE,
        DATE_DEAL_TRANSFERRED,
        TERM_DURATION,
        DATETIME_PROPOSAL_EFFECTIVE,
        DATETIME_PROPOSAL_INEFFECTIVE,
        DATE_PROPOSAL_ACCEPTED,
        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,
        AMD_CODE,
        GENERATE_ACCRUAL_YN,
        GENERATE_ACCRUAL_OVERRIDE_YN,
        CREDIT_ACT_YN,
        CONVERTED_ACCOUNT_YN,
        PRE_TAX_YIELD,
        AFTER_TAX_YIELD,
        IMPLICIT_INTEREST_RATE,
        IMPLICIT_NON_IDC_INTEREST_RATE,
        TARGET_PRE_TAX_YIELD,
        TARGET_AFTER_TAX_YIELD,
        TARGET_IMPLICIT_INTEREST_RATE,
        TARGET_IMPLICIT_NONIDC_INTRATE,
        DATE_LAST_INTERIM_INTEREST_CAL,
        DEAL_TYPE,
        PRE_TAX_IRR,
        AFTER_TAX_IRR,
        EXPECTED_DELIVERY_DATE,
        ACCEPTED_DATE,
        PREFUNDING_ELIGIBLE_YN,
        REVOLVING_CREDIT_YN,
--Bug# 2697681 schema changes  11.5.9
        CURRENCY_CONVERSION_TYPE,
        CURRENCY_CONVERSION_RATE,
        CURRENCY_CONVERSION_DATE,
        MULTI_GAAP_YN,
        RECOURSE_CODE,
        LESSOR_SERV_ORG_CODE,
        ASSIGNABLE_YN,
        SECURITIZED_CODE,
        SECURITIZATION_TYPE,
--Bug# 3143522 :11.5.10
   --subsidy
   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# 3973640 : 11.5.10+ schema
   TOT_CL_TRANSFER_AMT,
   TOT_CL_NET_TRANSFER_AMT,
   TOT_CL_LIMIT,
   TOT_CL_FUNDING_AMT,
   CRS_ID,
   TEMPLATE_TYPE_CODE,
--Bug# 4419339 OKLH Schema Sales Quote
   DATE_FUNDING_EXPECTED,
   DATE_TRADEIN,
   TRADEIN_AMOUNT,
   TRADEIN_DESCRIPTION,
    --Added by dpsingh for LE uptake
   LEGAL_ENTITY_ID)
  SELECT
	ID,
        ISG_ID,
        KHR_ID,
        PDT_ID,
        OBJECT_VERSION_NUMBER,
        DATE_FIRST_ACTIVITY,
        SYNDICATABLE_YN,
        SALESTYPE_YN,
        DATE_REFINANCED,
        DATE_CONVERSION_EFFECTIVE,
        DATE_DEAL_TRANSFERRED,
        TERM_DURATION,
        DATETIME_PROPOSAL_EFFECTIVE,
        DATETIME_PROPOSAL_INEFFECTIVE,
        DATE_PROPOSAL_ACCEPTED,
        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,
        AMD_CODE,
        GENERATE_ACCRUAL_YN,
        GENERATE_ACCRUAL_OVERRIDE_YN,
        CREDIT_ACT_YN,
        CONVERTED_ACCOUNT_YN,
        PRE_TAX_YIELD,
        AFTER_TAX_YIELD,
        IMPLICIT_INTEREST_RATE,
        IMPLICIT_NON_IDC_INTEREST_RATE,
        TARGET_PRE_TAX_YIELD,
        TARGET_AFTER_TAX_YIELD,
        TARGET_IMPLICIT_INTEREST_RATE,
        TARGET_IMPLICIT_NONIDC_INTRATE,
        DATE_LAST_INTERIM_INTEREST_CAL,
        DEAL_TYPE,
        PRE_TAX_IRR,
        AFTER_TAX_IRR,
        EXPECTED_DELIVERY_DATE,
        ACCEPTED_DATE,
        PREFUNDING_ELIGIBLE_YN,
        REVOLVING_CREDIT_YN,
--Bug# 2697681 schema changes  11.5.9
        CURRENCY_CONVERSION_TYPE,
        CURRENCY_CONVERSION_RATE,
        CURRENCY_CONVERSION_DATE,
        MULTI_GAAP_YN,
        RECOURSE_CODE,
        LESSOR_SERV_ORG_CODE,
        ASSIGNABLE_YN,
        SECURITIZED_CODE,
        SECURITIZATION_TYPE,
--Bug# 3143522  : 11.5.10
   --subsidy
   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# 3973640 : 11.5.10+ schema
   TOT_CL_TRANSFER_AMT,
   TOT_CL_NET_TRANSFER_AMT,
   TOT_CL_LIMIT,
   TOT_CL_FUNDING_AMT,
   CRS_ID,
   TEMPLATE_TYPE_CODE,
--Bug# 4419339 OKLH Schema Sales Quote
   DATE_FUNDING_EXPECTED,
   DATE_TRADEIN,
   TRADEIN_AMOUNT,
   TRADEIN_DESCRIPTION,
 --Added by dpsingh for LE uptake
   LEGAL_ENTITY_ID
  FROM OKL_K_HEADERS_H
  WHERE id = p_khr_id and major_version = p_major_version;