The following lines contain the word 'select', 'insert', 'update' or 'delete':
select 'x'
from OKC_K_HEADERS_B
where ID = p_khrv_rec.khr_id;
select 'x'
from OKL_PRODUCTS
where ID = p_khrv_rec.pdt_id;
select '!'
from gl_daily_conversion_types
where conversion_type = p_curr_cotyp;
select 'x'
from OKL_VP_CHANGE_REQUESTS
where ID = p_khrv_rec.crs_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+
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;
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 ;
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;
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
;
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;
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 ;
IF (l_khrv_rec.LAST_UPDATED_BY = OKC_API.G_MISS_NUM) THEN
l_khrv_rec.LAST_UPDATED_BY := NULL;
IF (l_khrv_rec.LAST_UPDATE_DATE = OKC_API.G_MISS_DATE) THEN
l_khrv_rec.LAST_UPDATE_DATE := NULL;
IF (l_khrv_rec.LAST_UPDATE_LOGIN = OKC_API.G_MISS_NUM) THEN
l_khrv_rec.LAST_UPDATE_LOGIN := NULL;
p_to.LAST_UPDATED_BY := p_from.LAST_UPDATED_BY;
p_to.LAST_UPDATE_DATE := p_from.LAST_UPDATE_DATE;
p_to.LAST_UPDATE_LOGIN := p_from.LAST_UPDATE_LOGIN;
p_to.LAST_UPDATED_BY := p_from.LAST_UPDATED_BY;
p_to.LAST_UPDATE_DATE := p_from.LAST_UPDATE_DATE;
p_to.LAST_UPDATE_LOGIN := p_from.LAST_UPDATE_LOGIN;
p_to.LAST_UPDATED_BY := p_from.LAST_UPDATED_BY;
p_to.LAST_UPDATE_DATE := p_from.LAST_UPDATE_DATE;
p_to.LAST_UPDATE_LOGIN := p_from.LAST_UPDATE_LOGIN;
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;
l_api_name CONSTANT VARCHAR2(30) := 'rec_insert_row';
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);
END insert_row;
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;
l_api_name CONSTANT VARCHAR2(30) := 'rec_insert_row';
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);
END insert_row;
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;
l_api_name CONSTANT VARCHAR2(30) := 'rec_insert_row';
l_khrv_rec.LAST_UPDATE_DATE := SYSDATE;
l_khrv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
l_khrv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
insert_row(
l_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_khr_rec,
lx_khr_rec
);
END insert_row;
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;
l_api_name CONSTANT VARCHAR2(30) := 'tbl_insert_row';
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));
END insert_row;
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;
SELECT OBJECT_VERSION_NUMBER
FROM OKL_K_HEADERS
WHERE ID = p_khr_rec.id;
OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
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;
l_api_name CONSTANT VARCHAR2(30) := 'rec_update_row';
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;
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;
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;
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;
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
);
END update_row;
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;
l_api_name CONSTANT VARCHAR2(30) := 'rec_update_row';
l_khrv_rec.LAST_UPDATE_DATE := SYSDATE;
l_khrv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
l_khrv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
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;
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;
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;
update_row(
l_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_khr_rec,
lx_khr_rec
);
END update_row;
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;
l_api_name CONSTANT VARCHAR2(30) := 'tbl_update_row';
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));
END update_row;
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;
l_api_name CONSTANT VARCHAR2(30) := 'rec_delete_row';
/*-------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);
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
);
DELETE FROM OKL_K_HEADERS
WHERE ID = l_khr_rec.id;
END delete_row;
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;
l_api_name CONSTANT VARCHAR2(30) := 'rec_delete_row';
delete_row(
l_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_khr_rec
);
END delete_row;
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;
l_api_name CONSTANT VARCHAR2(30) := 'tbl_delete_row';
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));
END delete_row;
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;
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;