The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_last_updated_by NUMBER := fnd_global.user_id;
l_last_update_login NUMBER := fnd_global.login_id;
SELECT
ID
,OBJECT_VERSION_NUMBER
,SFWT_FLAG
,CHR_ID_RESPONSE
,CHR_ID_AWARD
,CHR_ID_RENEWED
,INV_ORGANIZATION_ID
,STS_CODE
,QCL_ID
,SCS_CODE
,CONTRACT_NUMBER
,CURRENCY_CODE
,CONTRACT_NUMBER_MODIFIER
,ARCHIVED_YN
,DELETED_YN
,CUST_PO_NUMBER_REQ_YN
,PRE_PAY_REQ_YN
,CUST_PO_NUMBER
,SHORT_DESCRIPTION
,COMMENTS
,DESCRIPTION
,DPAS_RATING
,COGNOMEN
,TEMPLATE_YN
--,GOVERNING_CONTRACT_YN
,TEMPLATE_USED
,DATE_APPROVED
,DATETIME_CANCELLED
,AUTO_RENEW_DAYS
,DATE_ISSUED
,DATETIME_RESPONDED
,NON_RESPONSE_REASON
,NON_RESPONSE_EXPLAIN
,RFP_TYPE
,CHR_TYPE
,KEEP_ON_MAIL_LIST
,SET_ASIDE_REASON
,SET_ASIDE_PERCENT
,RESPONSE_COPIES_REQ
,DATE_CLOSE_PROJECTED
,DATETIME_PROPOSED
,DATE_SIGNED
,DATE_TERMINATED
,DATE_RENEWED
,TRN_CODE
,START_DATE
,END_DATE
,AUTHORING_ORG_ID
,BUY_OR_SELL
,ISSUE_OR_RECEIVE
,ESTIMATED_AMOUNT
,CHR_ID_RENEWED_TO
,ESTIMATED_AMOUNT_RENEWED
,CURRENCY_CODE_RENEWED
--,USER_ACCESS_LEVEL
,UPG_ORIG_SYSTEM_REF
,UPG_ORIG_SYSTEM_REF_ID
,APPLICATION_ID
--,RESOLVED_UNTIL
,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
,ORIG_SYSTEM_SOURCE_CODE
,ORIG_SYSTEM_ID1
,ORIG_SYSTEM_REFERENCE1
,PROGRAM_APPLICATION_ID
,PROGRAM_ID
,PROGRAM_UPDATE_DATE
,REQUEST_ID
,PRICE_LIST_ID
,PRICING_DATE
,TOTAL_LINE_LIST_PRICE
,SIGN_BY_DATE
,USER_ESTIMATED_AMOUNT
,CONVERSION_TYPE
,CONVERSION_RATE
,CONVERSION_RATE_DATE
,CONVERSION_EURO_RATE
,CUST_ACCT_ID
,BILL_TO_SITE_USE_ID
,INV_RULE_ID
,RENEWAL_TYPE_CODE
,RENEWAL_NOTIFY_TO
,RENEWAL_END_DATE
,SHIP_TO_SITE_USE_ID
,PAYMENT_TERM_ID
FROM Okc_K_Headers_V
WHERE okc_k_headers_v.id = p_id;
,l_chrv_rec.DELETED_YN
,l_chrv_rec.CUST_PO_NUMBER_REQ_YN
,l_chrv_rec.PRE_PAY_REQ_YN
,l_chrv_rec.CUST_PO_NUMBER
,l_chrv_rec.SHORT_DESCRIPTION
,l_chrv_rec.COMMENTS
,l_chrv_rec.DESCRIPTION
,l_chrv_rec.DPAS_RATING
,l_chrv_rec.COGNOMEN
,l_chrv_rec.TEMPLATE_YN
--,l_chrv_rec.GOVERNING_CONTRACT_YN
,l_chrv_rec.TEMPLATE_USED
,l_chrv_rec.DATE_APPROVED
,l_chrv_rec.DATETIME_CANCELLED
,l_chrv_rec.AUTO_RENEW_DAYS
,l_chrv_rec.DATE_ISSUED
,l_chrv_rec.DATETIME_RESPONDED
,l_chrv_rec.NON_RESPONSE_REASON
,l_chrv_rec.NON_RESPONSE_EXPLAIN
,l_chrv_rec.RFP_TYPE
,l_chrv_rec.CHR_TYPE
,l_chrv_rec.KEEP_ON_MAIL_LIST
,l_chrv_rec.SET_ASIDE_REASON
,l_chrv_rec.SET_ASIDE_PERCENT
,l_chrv_rec.RESPONSE_COPIES_REQ
,l_chrv_rec.DATE_CLOSE_PROJECTED
,l_chrv_rec.DATETIME_PROPOSED
,l_chrv_rec.DATE_SIGNED
,l_chrv_rec.DATE_TERMINATED
,l_chrv_rec.DATE_RENEWED
,l_chrv_rec.TRN_CODE
,l_chrv_rec.START_DATE
,l_chrv_rec.END_DATE
,l_chrv_rec.AUTHORING_ORG_ID
,l_chrv_rec.BUY_OR_SELL
,l_chrv_rec.ISSUE_OR_RECEIVE
,l_chrv_rec.ESTIMATED_AMOUNT
,l_chrv_rec.CHR_ID_RENEWED_TO
,l_chrv_rec.ESTIMATED_AMOUNT_RENEWED
,l_chrv_rec.CURRENCY_CODE_RENEWED
--,l_chrv_rec.USER_ACCESS_LEVEL
,l_chrv_rec.UPG_ORIG_SYSTEM_REF
,l_chrv_rec.UPG_ORIG_SYSTEM_REF_ID
,l_chrv_rec.APPLICATION_ID
--,l_chrv_rec.RESOLVED_UNTIL
,l_chrv_rec.ATTRIBUTE_CATEGORY
,l_chrv_rec.ATTRIBUTE1
,l_chrv_rec.ATTRIBUTE2
,l_chrv_rec.ATTRIBUTE3
,l_chrv_rec.ATTRIBUTE4
,l_chrv_rec.ATTRIBUTE5
,l_chrv_rec.ATTRIBUTE6
,l_chrv_rec.ATTRIBUTE7
,l_chrv_rec.ATTRIBUTE8
,l_chrv_rec.ATTRIBUTE9
,l_chrv_rec.ATTRIBUTE10
,l_chrv_rec.ATTRIBUTE11
,l_chrv_rec.ATTRIBUTE12
,l_chrv_rec.ATTRIBUTE13
,l_chrv_rec.ATTRIBUTE14
,l_chrv_rec.ATTRIBUTE15
,l_chrv_rec.CREATED_BY
,l_chrv_rec.CREATION_DATE
,l_chrv_rec.LAST_UPDATED_BY
,l_chrv_rec.LAST_UPDATE_DATE
,l_chrv_rec.LAST_UPDATE_LOGIN
,l_chrv_rec.ORIG_SYSTEM_SOURCE_CODE
,l_chrv_rec.ORIG_SYSTEM_ID1
,l_chrv_rec.ORIG_SYSTEM_REFERENCE1
,l_chrv_rec.PROGRAM_APPLICATION_ID
,l_chrv_rec.PROGRAM_ID
,l_chrv_rec.PROGRAM_UPDATE_DATE
,l_chrv_rec.REQUEST_ID
,l_chrv_rec.PRICE_LIST_ID
,l_chrv_rec.PRICING_DATE
,l_chrv_rec.TOTAL_LINE_LIST_PRICE
,l_chrv_rec.SIGN_BY_DATE
,l_chrv_rec.USER_ESTIMATED_AMOUNT
,l_chrv_rec.CONVERSION_TYPE
,l_chrv_rec.CONVERSION_RATE
,l_chrv_rec.CONVERSION_RATE_DATE
,l_chrv_rec.CONVERSION_EURO_RATE
,l_chrv_rec.CUST_ACCT_ID
,l_chrv_rec.BILL_TO_SITE_USE_ID
,l_chrv_rec.INV_RULE_ID
,l_chrv_rec.RENEWAL_TYPE_CODE
,l_chrv_rec.RENEWAL_NOTIFY_TO
,l_chrv_rec.RENEWAL_END_DATE
,l_chrv_rec.SHIP_TO_SITE_USE_ID
,l_chrv_rec.PAYMENT_TERM_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
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# 2697681
--Bug# 3143522 : Subsidies
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#3923883 Rollover/Creditline performance
TOT_CL_TRANSFER_AMT,
TOT_CL_NET_TRANSFER_AMT,
TOT_CL_LIMIT,
TOT_CL_FUNDING_AMT,
--Bug 4466440 OKL.H columns
CRS_ID,
TEMPLATE_TYPE_CODE,
TRADEIN_DESCRIPTION,
TRADEIN_AMOUNT,
DATE_TRADEIN,
DATE_FUNDING_EXPECTED,
--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,
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 : Subsidies
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#3923883 Rollover/Creditline performance
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,
--Bug 4466440 OKL.H new columns
l_khrv_rec.CRS_ID,
l_khrv_rec.TEMPLATE_TYPE_CODE,
l_khrv_rec.TRADEIN_DESCRIPTION,
l_khrv_rec.TRADEIN_AMOUNT,
l_khrv_rec.DATE_TRADEIN,
l_khrv_rec.DATE_FUNDING_EXPECTED,
--Added by dpsingh for LE Uptake
l_khrv_rec.LEGAL_ENTITY_ID;
SELECT
ID
,OBJECT_VERSION_NUMBER
,SFWT_FLAG
,CHR_ID
,CLE_ID
,CLE_ID_RENEWED
,CLE_ID_RENEWED_TO
,LSE_ID
,LINE_NUMBER
,STS_CODE
,DISPLAY_SEQUENCE
,TRN_CODE
,DNZ_CHR_ID
,COMMENTS
,ITEM_DESCRIPTION
,OKE_BOE_DESCRIPTION
,HIDDEN_IND
,PRICE_UNIT
,PRICE_UNIT_PERCENT
,PRICE_NEGOTIATED
,PRICE_NEGOTIATED_RENEWED
,PRICE_LEVEL_IND
,INVOICE_LINE_LEVEL_IND
,DPAS_RATING
,BLOCK23TEXT
,EXCEPTION_YN
,TEMPLATE_USED
,DATE_TERMINATED
,NAME
,START_DATE
,END_DATE
,UPG_ORIG_SYSTEM_REF
,UPG_ORIG_SYSTEM_REF_ID
,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
,PRICE_TYPE
,CURRENCY_CODE
,CURRENCY_CODE_RENEWED
,DATE_RENEWED
,ORIG_SYSTEM_SOURCE_CODE
,ORIG_SYSTEM_ID1
,ORIG_SYSTEM_REFERENCE1
,COGNOMEN
,PROGRAM_APPLICATION_ID
,PROGRAM_ID
,PROGRAM_UPDATE_DATE
,REQUEST_ID
,PRICE_LIST_LINE_ID
,PRICE_LIST_ID
,LINE_LIST_PRICE
,ITEM_TO_PRICE_YN
,PRICING_DATE
,PRICE_BASIS_YN
,CONFIG_HEADER_ID
,CONFIG_REVISION_NUMBER
,CONFIG_COMPLETE_YN
,CONFIG_VALID_YN
,CONFIG_TOP_MODEL_LINE_ID
,CONFIG_ITEM_TYPE
,CONFIG_ITEM_ID
--,SERVICE_ITEM_YN
--,PH_PRICING_TYPE
--,PH_ADJUSTMENT
--,PH_PRICE_BREAK_BASIS
--,PH_MIN_QTY
--,PH_MIN_AMT
--,PH_QP_REFERENCE_ID
--,PH_VALUE
--,PH_ENFORCE_PRICE_LIST_YN
--,PH_INTEGRATED_WITH_QP
,CUST_ACCT_ID
,BILL_TO_SITE_USE_ID
,INV_RULE_ID
,LINE_RENEWAL_TYPE_CODE
,SHIP_TO_SITE_USE_ID
,PAYMENT_TERM_ID
FROM Okc_K_Lines_V
WHERE okc_k_lines_v.id = p_id;
,l_clev_rec.LAST_UPDATED_BY
,l_clev_rec.LAST_UPDATE_DATE
,l_clev_rec.LAST_UPDATE_LOGIN
,l_clev_rec.PRICE_TYPE
,l_clev_rec.CURRENCY_CODE
,l_clev_rec.CURRENCY_CODE_RENEWED
,l_clev_rec.DATE_RENEWED
,l_clev_rec.ORIG_SYSTEM_SOURCE_CODE
,l_clev_rec.ORIG_SYSTEM_ID1
,l_clev_rec.ORIG_SYSTEM_REFERENCE1
,l_clev_rec.COGNOMEN
,l_clev_rec.PROGRAM_APPLICATION_ID
,l_clev_rec.PROGRAM_ID
,l_clev_rec.PROGRAM_UPDATE_DATE
,l_clev_rec.REQUEST_ID
,l_clev_rec.PRICE_LIST_LINE_ID
,l_clev_rec.PRICE_LIST_ID
,l_clev_rec.LINE_LIST_PRICE
,l_clev_rec.ITEM_TO_PRICE_YN
,l_clev_rec.PRICING_DATE
,l_clev_rec.PRICE_BASIS_YN
,l_clev_rec.CONFIG_HEADER_ID
,l_clev_rec.CONFIG_REVISION_NUMBER
,l_clev_rec.CONFIG_COMPLETE_YN
,l_clev_rec.CONFIG_VALID_YN
,l_clev_rec.CONFIG_TOP_MODEL_LINE_ID
,l_clev_rec.CONFIG_ITEM_TYPE
,l_clev_rec.CONFIG_ITEM_ID
--,l_clev_rec.SERVICE_ITEM_YN
--,l_clev_rec.PH_PRICING_TYPE
--,l_clev_rec.PH_ADJUSTMENT
--,l_clev_rec.PH_PRICE_BREAK_BASIS
--,l_clev_rec.PH_MIN_QTY
--,l_clev_rec.PH_MIN_AMT
--,l_clev_rec.PH_QP_REFERENCE_ID
--,l_clev_rec.PH_VALUE
--,l_clev_rec.PH_ENFORCE_PRICE_LIST_YN
--,l_clev_rec.PH_INTEGRATED_WITH_QP
,l_clev_rec.CUST_ACCT_ID
,l_clev_rec.BILL_TO_SITE_USE_ID
,l_clev_rec.INV_RULE_ID
,l_clev_rec.LINE_RENEWAL_TYPE_CODE
,l_clev_rec.SHIP_TO_SITE_USE_ID
,l_clev_rec.PAYMENT_TERM_ID;
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
DATE_PAY_INVESTOR_START,
PAY_INVESTOR_FREQUENCY,
PAY_INVESTOR_EVENT,
PAY_INVESTOR_REMITTANCE_DAYS,
-- Bug# 2697681
FEE_TYPE,
-- Bug# 3143522 : Subsidies
SUBSIDY_ID,
--SUBSIDIZED_OEC,
--SUBSIDIZED_CAP_AMOUNT,
PRE_TAX_YIELD,
AFTER_TAX_YIELD,
IMPLICIT_INTEREST_RATE,
IMPLICIT_NON_IDC_INTEREST_RATE,
PRE_TAX_IRR,
AFTER_TAX_IRR,
SUBSIDY_OVERRIDE_AMOUNT,
--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+ schema
QTE_ID,
FUNDING_DATE,
STREAM_TYPE_SUBCLASS,
--Bug 4466440 OKL.H new columns
DATE_FUNDING_EXPECTED,
MANUFACTURER_NAME,
MODEL_NUMBER,
DOWN_PAYMENT_RECEIVER_CODE,
CAPITALIZE_DOWN_PAYMENT_YN,
FEE_PURPOSE_CODE
FROM Okl_K_Lines_V
WHERE okl_k_lines_v.id = p_id;
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,
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,
l_klev_rec.FEE_TYPE,
-- Bug# 3143522 : Subsidies
l_klev_rec.SUBSIDY_ID,
--l_klev_rec.SUBSIDIZED_OEC,
--l_klev_rec.SUBSIDIZED_CAP_AMOUNT,
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,
l_klev_rec.SUBSIDY_OVERRIDE_AMOUNT,
--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+ schema
l_klev_rec.QTE_ID,
l_klev_rec.FUNDING_DATE,
l_klev_rec.STREAM_TYPE_SUBCLASS,
--Bug 4466440 OKL.H new columns
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,
l_klev_rec.FEE_PURPOSE_CODE;
SELECT
ID,
OBJECT_VERSION_NUMBER,
DNZ_CHR_ID,
CLE_ID,
PPL_ID,
PASSTHRU_START_DATE,
PAYOUT_BASIS,
PAYOUT_BASIS_FORMULA,
EFFECTIVE_FROM,
EFFECTIVE_TO,
PASSTHRU_TERM,
PASSTHRU_STREAM_TYPE_ID,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN
FROM Okl_Party_Payment_Hdr_V
WHERE okl_party_payment_hdr_v.id = p_id;
l_pphv_rec.last_updated_by,
l_pphv_rec.last_update_date,
l_pphv_rec.last_update_login;
SELECT
ID,
OBJECT_VERSION_NUMBER,
CPL_ID,
VENDOR_ID,
PAY_SITE_ID,
PAYMENT_TERM_ID,
PAYMENT_METHOD_CODE,
PAY_GROUP_CODE,
PAYMENT_HDR_ID,
PAYMENT_START_DATE,
PAYMENT_FREQUENCY,
REMIT_DAYS,
DISBURSEMENT_BASIS,
DISBURSEMENT_FIXED_AMOUNT,
DISBURSEMENT_PERCENT,
PROCESSING_FEE_BASIS,
PROCESSING_FEE_FIXED_AMOUNT,
PROCESSING_FEE_PERCENT,
PAYMENT_BASIS,
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
FROM Okl_Party_Payment_Dtls_V
WHERE okl_party_payment_dtls_v.id = p_id;
l_ppydv_rec.last_updated_by,
l_ppydv_rec.last_update_date,
l_ppydv_rec.last_update_login;
SELECT
ID,
OBJECT_VERSION_NUMBER,
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
FROM Okl_K_Party_Roles_V
WHERE okl_k_party_roles_v.id = p_id;
l_kplv_rec.last_updated_by,
l_kplv_rec.last_update_date,
l_kplv_rec.last_update_login;
SELECT
ID,
OBJECT_VERSION_NUMBER,
POV_ID,
KHR_ID,
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
FROM OKL_SLCTD_OPTNS_V
WHERE OKL_SLCTD_OPTNS_V.id = p_id;
l_cspv_rec.last_updated_by,
l_cspv_rec.last_update_date,
l_cspv_rec.last_update_login;
OKL_LDB_PVT.insert_row
(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_pphv_rec => l_pphv_rec,
x_pphv_rec => lx_pphv_rec);
OKL_PYD_PVT.insert_row
(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_ppydv_rec => l_ppydv_rec,
x_ppydv_rec => lx_ppydv_rec);
OKL_KPL_PVT.insert_row
(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_kplv_rec => l_kplv_rec,
x_kplv_rec => lx_kplv_rec);
OKL_CONTRACT_PUB.update_contract_line(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_clev_rec => l_clev_rec,
p_klev_rec => l_klev_rec,
x_clev_rec => l_clev_rec_out,
x_klev_rec => x_klev_rec);
FUNCTION update_target_contract(p_chr_id IN NUMBER) RETURN BOOLEAN IS
BEGIN
RETURN(OKC_COPY_CONTRACT_PUB.update_target_contract(p_chr_id));
END update_target_contract;
SELECT
ID,
OBJECT_VERSION_NUMBER,
SFWT_FLAG,
OBJECT1_ID1,
OBJECT2_ID1,
OBJECT3_ID1,
OBJECT1_ID2,
OBJECT2_ID2,
OBJECT3_ID2,
JTOT_OBJECT1_CODE,
JTOT_OBJECT2_CODE,
JTOT_OBJECT3_CODE,
DNZ_CHR_ID,
RGP_ID,
PRIORITY,
STD_TEMPLATE_YN,
COMMENTS,
WARN_YN,
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,
--TEXT,
RULE_INFORMATION_CATEGORY,
RULE_INFORMATION1,
RULE_INFORMATION2,
RULE_INFORMATION3,
RULE_INFORMATION4,
RULE_INFORMATION5,
RULE_INFORMATION6,
RULE_INFORMATION7,
RULE_INFORMATION8,
RULE_INFORMATION9,
RULE_INFORMATION10,
RULE_INFORMATION11,
RULE_INFORMATION12,
RULE_INFORMATION13,
RULE_INFORMATION14,
RULE_INFORMATION15,
TEMPLATE_YN,
ans_set_jtot_object_code,
ans_set_jtot_object_id1,
ans_set_jtot_object_id2,
DISPLAY_SEQUENCE
FROM Okc_Rules_V
WHERE okc_rules_v.rgp_id = p_rgp_id
AND okc_rules_v.object2_id1 = p_slh_id
AND RULE_INFORMATION_CATEGORY = DECODE(p_rdf_code,NULL,RULE_INFORMATION_CATEGORY,p_rdf_code);
l_rulv_rec.LAST_UPDATED_BY,
l_rulv_rec.LAST_UPDATE_DATE,
l_rulv_rec.LAST_UPDATE_LOGIN,
--l_rulv_rec.TEXT,
l_rulv_rec.RULE_INFORMATION_CATEGORY,
l_rulv_rec.RULE_INFORMATION1,
l_rulv_rec.RULE_INFORMATION2,
l_rulv_rec.RULE_INFORMATION3,
l_rulv_rec.RULE_INFORMATION4,
l_rulv_rec.RULE_INFORMATION5,
l_rulv_rec.RULE_INFORMATION6,
l_rulv_rec.RULE_INFORMATION7,
l_rulv_rec.RULE_INFORMATION8,
l_rulv_rec.RULE_INFORMATION9,
l_rulv_rec.RULE_INFORMATION10,
l_rulv_rec.RULE_INFORMATION11,
l_rulv_rec.RULE_INFORMATION12,
l_rulv_rec.RULE_INFORMATION13,
l_rulv_rec.RULE_INFORMATION14,
l_rulv_rec.RULE_INFORMATION15,
l_rulv_rec.TEMPLATE_YN,
l_rulv_rec.ans_set_jtot_object_code,
l_rulv_rec.ans_set_jtot_object_id1,
l_rulv_rec.ans_set_jtot_object_id2,
l_rulv_rec.DISPLAY_SEQUENCE ;
SELECT orig_system_id1
FROM okc_k_lines_v
WHERE id = p_cle_id;
SELECT id
FROM okc_rule_groups_v
WHERE dnz_chr_id = p_chr_id
AND id = p_rgp_id
AND rgd_code = 'LALEVL';
SELECT id
FROM okc_rules_v
WHERE rgp_id = p_rgp_id
--Bug# : 3124577 :11.5.10 Rule migration
AND rule_information_category IN ('LASLH','LASLL');
Okl_Rule_Pub.delete_rule(
p_api_version => 1.0,
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_rulv_tbl => l_rulv_tbl
);
SELECT id,
cle_id
FROM okc_rule_groups_v
WHERE dnz_chr_id = p_chr_id
AND cle_id = p_cle_id
AND rgd_code = 'LALEVL';
SELECT id
FROM okc_rule_groups_v
WHERE dnz_chr_id = p_chr_id
AND rgd_code = 'LALEVL'
AND (cle_id = p_cle_id
OR ( cle_id IS NULL
AND
p_cle_id IS NULL));
SELECT orig_system_id1
FROM OKC_K_LINES_V
WHERE id = p_cle_id;
SELECT id,
cle_id
FROM okc_rule_groups_v
WHERE dnz_chr_id = p_chr_id
AND cle_id IS NULL -- Bug 2376998
AND rgd_code = 'LALEVL';
SELECT id
FROM okc_rule_groups_v
WHERE dnz_chr_id = p_chr_id
AND rgd_code = 'LALEVL'
AND (cle_id = p_cle_id
OR ( cle_id IS NULL
AND
p_cle_id IS NULL));
SELECT orig_system_id1
FROM OKC_K_LINES_V
WHERE id = p_cle_id;
Select cle.id,
cle.orig_system_id1
from OKC_K_LINES_B cle_parent,
OKC_LINE_STYLES_B cle_parent_lse,
OKC_K_LINES_B cle
WHERE cle_parent.id = cle.orig_system_id1
AND cle_parent.lse_id = cle_parent_lse.id
AND cle_parent.sts_code = 'ABANDONED'
AND cle_parent_lse.lse_type = 'TLS'
AND cle.dnz_chr_id = p_copied_chr_id;
Select cle.id,
cle.orig_system_id1
from OKC_K_LINES_B cle_parent,
OKC_LINE_STYLES_B cle_parent_lse,
OKC_K_LINES_B cle
WHERE cle_parent.id = cle.orig_system_id1
AND cle_parent.lse_id = cle_parent_lse.id
AND cle_parent.sts_code = 'ABANDONED'
AND cle_parent_lse.lse_type = 'SLS'
AND cle.dnz_chr_id = p_copied_chr_id;
OKL_CONTRACT_PUB.delete_contract_line(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_line_id => l_cle_id);
OKL_CONTRACT_PUB.delete_contract_line(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_line_id => l_cle_id);
Select cle.id, cle.orig_system_id1
from OKC_K_LINES_B cle_parent,
OKC_LINE_STYLES_B cle_parent_lse,
OKC_K_LINES_B cle,
okl_k_lines kle_parent
WHERE cle_parent.id = kle_parent.id
AND cle_parent.id = cle.orig_system_id1
AND cle_parent.lse_id = cle_parent_lse.id
AND kle_parent.fee_type = 'ROLLOVER'
AND cle_parent_lse.lse_type = 'TLS'
AND cle.dnz_chr_id = p_copied_chr_id;
OKL_CONTRACT_PUB.delete_contract_line(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_line_id => l_cle_id);
OKL_CSP_PVT.insert_row
(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_cspv_rec => l_cspv_rec,
x_cspv_rec => lx_cspv_rec);
Select Orig_System_Id1,id
From OKC_K_LINES_V
Where dnz_chr_id = l_chr_id;
select pyd_old.id pyd_id,
cpl_new.id cpl_id
from okl_party_payment_dtls pyd_old,
okc_k_party_roles_b cpl_old,
okc_k_party_roles_b cpl_new
where pyd_old.cpl_id = cpl_old.id
and cpl_old.chr_id = p_old_chr_id
and cpl_old.dnz_chr_id = p_old_chr_id
and cpl_new.chr_id = p_new_chr_id
and cpl_new.dnz_chr_id = p_new_chr_id
and cpl_old.rle_code = cpl_new.rle_code
and cpl_old.jtot_object1_code = cpl_new.jtot_object1_code
and cpl_old.object1_id1 = cpl_new.object1_id1
and cpl_old.object1_id2 = cpl_new.object1_id2;
select pyd_old.id pyd_id,
cpl_new.id cpl_id
from okl_party_payment_dtls pyd_old,
okc_k_party_roles_b cpl_old,
okc_k_party_roles_b cpl_new
where pyd_old.cpl_id = cpl_old.id
and cpl_old.cle_id = p_old_cle_id
and cpl_old.dnz_chr_id = p_old_chr_id
and cpl_new.cle_id = p_new_cle_id
and cpl_new.dnz_chr_id = p_new_chr_id
and cpl_old.rle_code = cpl_new.rle_code
and cpl_old.jtot_object1_code = cpl_new.jtot_object1_code
and cpl_old.object1_id1 = cpl_new.object1_id1
and cpl_old.object1_id2 = cpl_new.object1_id2;
select cspv.id
from OKL_SLCTD_OPTNS_V cspv
where cspv.khr_id = p_old_chr_id;
OKL_CONTRACT_PUB.update_contract_header(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_restricted_update => OKL_API.G_FALSE,
p_chrv_rec => l_chrv_rec,
p_khrv_rec => l_khrv_rec,
x_chrv_rec => l_chrv_rec_out,
x_khrv_rec => l_khrv_rec_out);
SELECT level,
id,
chr_id,
cle_id,
dnz_chr_id,
orig_system_id1
FROM okc_k_lines_b
CONNECT BY PRIOR id = cle_id
START WITH id = p_from_cle_id;
SELECT dnz_chr_id
FROM okc_k_lines_v
WHERE id = p_cle_id;
select pyd_old.id pyd_id,
cpl_new.id cpl_id
from okl_party_payment_dtls pyd_old,
okc_k_party_roles_b cpl_old,
okc_k_party_roles_b cpl_new
where pyd_old.cpl_id = cpl_old.id
and cpl_old.cle_id = p_old_cle_id
and cpl_old.dnz_chr_id = p_old_chr_id
and cpl_new.cle_id = p_new_cle_id
and cpl_new.dnz_chr_id = p_new_chr_id
and cpl_old.rle_code = cpl_new.rle_code
and cpl_old.jtot_object1_code = cpl_new.jtot_object1_code
and cpl_old.object1_id1 = cpl_new.object1_id1
and cpl_old.object1_id2 = cpl_new.object1_id2;
SELECT id
FROM okl_party_payment_hdr
WHERE dnz_chr_id = p_chr_id
AND cle_id = p_cle_id;
SELECT id
FROM okl_party_payment_dtls
WHERE payment_hdr_id IN
(SELECT id
FROM okl_party_payment_hdr
WHERE dnz_chr_id = p_chr_id
AND cle_id = p_cle_id);
select pyd_old.id pyd_id,
pyd_old.payment_hdr_id,
cpl_new.id cpl_id
from okl_party_payment_dtls pyd_old,
okc_k_party_roles_b cpl_old,
okc_k_party_roles_b cpl_new,
okl_party_payment_hdr hdr
where pyd_old.cpl_id = cpl_old.id
and cpl_old.cle_id = p_old_cle_id
and cpl_old.dnz_chr_id = p_old_chr_id
and cpl_new.cle_id = p_new_cle_id
and cpl_new.dnz_chr_id = p_new_chr_id
and cpl_old.rle_code = cpl_new.rle_code
and cpl_old.jtot_object1_code = cpl_new.jtot_object1_code
and cpl_old.object1_id1 = cpl_new.object1_id1
and cpl_old.object1_id2 = cpl_new.object1_id2
and hdr.id = pyd_old.payment_hdr_id
and hdr.id = p_hdr_id;
Select pyd.id
from okl_party_payment_dtls pyd
where pyd.cpl_id = p_cpl_id;
Select kpl.id
from okl_k_party_roles kpl
where kpl.id = p_cpl_id;
SELECT id
FROM okc_governances_v
WHERE dnz_chr_id = p_from_chr_id
AND cle_id is null;
SELECT
DNZ_CHR_ID,
ISA_AGREEMENT_ID,
CHR_ID,
CLE_ID,
CHR_ID_REFERRED,
CLE_ID_REFERRED,
COPIED_ONLY_YN
FROM OKC_GOVERNANCES
WHERE ID = p_gve_id;
SELECT new_cle.id
FROM OKC_K_LINES_B new_cle,
OKC_K_ITEMS orig_lnk_cim
WHERE new_cle.ORIG_SYSTEM_ID1 = to_number(orig_lnk_cim.object1_id1)
AND new_cle.chr_id = p_new_chr_id
AND orig_lnk_cim.cle_id = p_orig_lnk_cle_id
AND not exists (select null
from OKC_K_LINES_B another_cle
where another_cle.orig_system_id1 = new_cle.orig_system_id1
and another_cle.lse_id = new_cle.lse_id
and another_cle.chr_id = new_cle.chr_id
and another_cle.id <> new_cle.id);
okl_okc_migration_pvt.update_contract_item(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_cimv_rec => l_cimv_rec,
x_cimv_rec => lx_cimv_rec);
okl_contract_status_pub.update_contract_status
(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_khr_status => p_status,
p_chr_id => p_chr_id);
PROCEDURE delete_yields(
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_chr_id IN NUMBER,
--Bug# 3973640
p_trans_type IN VARCHAR2
) IS
l_api_name CONSTANT VARCHAR2(30) := 'OKL_DELETE_YIELDS';
select kle.id
,kle.pre_tax_yield
,kle.after_tax_yield
,kle.implicit_interest_rate
,kle.implicit_non_idc_interest_rate
,kle.pre_tax_irr
,kle.after_tax_irr
,kle.sub_pre_tax_yield
,kle.sub_after_tax_yield
,kle.sub_impl_interest_rate
,kle.sub_impl_non_idc_int_rate
,kle.sub_pre_tax_irr
,kle.sub_after_tax_irr
,kle.capitalized_interest
--Bug# 3973640
,kle.qte_id
,kle.funding_date
from okc_k_lines_b cle
,okl_k_lines kle
where cle.dnz_chr_id = p_chr_id
and cle.id = kle.id;
okl_contract_pub.update_contract_header(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_chrv_rec => l_chrv_rec,
p_khrv_rec => l_khrv_rec,
x_chrv_rec => lx_chrv_rec,
x_khrv_rec => lx_khrv_rec);
okl_contract_pub.update_contract_line(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_clev_rec => l_clev_rec,
p_klev_rec => l_klev_rec,
x_clev_rec => lx_clev_rec,
x_klev_rec => lx_klev_rec);
END delete_yields;
SELECT DATE_TRANSACTION_OCCURRED
FROM OKL_TRX_CONTRACTS
WHERE KHR_ID = p_id
AND TCN_TYPE = 'TRBK'
and TSU_CODE = 'ENTERED';
SELECT
a.khr_id, a.parameter_type_code, a.effective_from_date,
a.effective_to_date, a.interest_index_id, a.base_rate,
a.interest_start_date, a.adder_rate, a.maximum_rate,
a.minimum_rate, a.principal_basis_code, a.days_in_a_month_code,
a.days_in_a_year_code, a.interest_basis_code, a.rate_delay_code,
a.rate_delay_frequency, a.compounding_frequency_code, a.calculation_formula_id,
a.catchup_basis_code, a.catchup_start_date, a.catchup_settlement_code,
a.rate_change_start_date, a.rate_change_frequency_code, a.rate_change_value,
a.conversion_option_code, a.next_conversion_date, a.conversion_type_code,
a.attribute_category, a.attribute1, a.attribute2,
a.attribute3, a.attribute4, a.attribute5,
a.attribute6, a.attribute7, a.attribute8,
a.attribute9, a.attribute10, a.attribute11,
a.attribute12, a.attribute13, a.attribute14,
a.attribute15, a.catchup_frequency_code
FROM OKL_K_RATE_PARAMS a
WHERE a.khr_id = p_id;
INSERT INTO okl_k_rate_params (
khr_id, parameter_type_code, effective_from_date,
effective_to_date, interest_index_id, base_rate,
interest_start_date, adder_rate, maximum_rate,
minimum_rate, principal_basis_code, days_in_a_month_code,
days_in_a_year_code, interest_basis_code, rate_delay_code,
rate_delay_frequency,compounding_frequency_code, calculation_formula_id,
catchup_basis_code, catchup_start_date, catchup_settlement_code,
rate_change_start_date, rate_change_frequency_code, rate_change_value,
conversion_option_code, next_conversion_date, conversion_type_code,
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,
catchup_frequency_code
) VALUES (
l_kkhr_id_tab(i), l_kparameter_type_code_tab(i), l_keffective_from_date_tab(i),
l_keffective_to_date_tab(i), l_kinterest_index_id_tab(i), l_kbase_rate_tab(i),
l_kinterest_start_date_tab(i), l_kadder_rate_tab(i), l_kmaximum_rate_tab(i),
l_kminimum_rate_tab(i), l_kprincipal_basis_code_tab(i), l_kdays_in_a_month_code_tab(i),
l_kdays_in_a_year_code_tab(i), l_kinterest_basis_code_tab(i), l_krate_delay_code_tab(i),
l_krate_delay_frequency_tab(i), l_kcompounding_frequ_code_tab(i), l_kcalculation_formula_id_tab(i),
l_kcatchup_basis_code_tab(i), l_kcatchup_start_date_tab(i), l_kcatchup_settlemen_code_tab(i),
l_krate_change_start_date_tab(i), l_krate_change_frequ_code_tab(i), l_krate_change_value_tab(i),
l_kconversion_option_code_tab(i), l_knext_conversion_date_tab(i), l_kconversion_type_code_tab(i),
l_kattribute_category_tab(i),l_kattribute1_tab(i), l_kattribute2_tab(i),
l_kattribute3_tab(i), l_kattribute4_tab(i), l_kattribute5_tab(i),
l_kattribute6_tab(i), l_kattribute7_tab(i), l_kattribute8_tab(i),
l_kattribute9_tab(i), l_kattribute10_tab(i), l_kattribute11_tab(i),
l_kattribute12_tab(i), l_kattribute13_tab(i), l_kattribute14_tab(i),
l_kattribute15_tab(i), l_created_by, SYSDATE,
l_last_updated_by, SYSDATE, l_last_update_login,
l_kcatchup_frequency_code_tab(i)
);
G_WF_EVT_SERV_FEXP_UPDATED CONSTANT VARCHAR2(70):= 'oracle.apps.okl.la.lease_contract.service_fee_expense_updated';
G_WF_EVT_FEE_EXP_UPDATED CONSTANT VARCHAR2(70):= 'oracle.apps.okl.la.lease_contract.fee_expense_updated';
G_WF_EVT_FEE_PASS_UPDATED CONSTANT VARCHAR2(70):= 'oracle.apps.okl.la.lease_contract.fee_passthrough_updated';
G_WF_EVT_SERV_PASS_UPDATED CONSTANT VARCHAR2(70):= 'oracle.apps.okl.la.lease_contract.service_fee_passthrough_updated';
G_WF_EVT_ASSET_PROPTAX_UPDATED CONSTANT VARCHAR2(70):= 'oracle.apps.okl.la.lease_contract.asset_property_tax_updated';
G_WF_EVT_ASSET_FILING_UPDATED CONSTANT VARCHAR2(70):= 'oracle.apps.okl.la.lease_contract.asset_filing_updated';
G_WF_EVT_CONTRACT_TERM_UPDATED CONSTANT VARCHAR2(70):= 'oracle.apps.okl.la.lease_contract.asset_filing_terms_updated';
SELECT * FROM okc_k_headers_b
WHERE id=p_chr_id;
SELECT * FROM okc_governances
WHERE dnz_chr_id = p_chr_id;
select * from okc_governances_h
where dnz_chr_id = p_chr_id; */
SELECT
a.id, a.line_number, a.chr_id,
a.cle_id, a.cle_id_renewed, a.dnz_chr_id,
a.display_sequence, a.sts_code, a.trn_code,
a.lse_id, a.exception_yn, a.object_version_number,
a.created_by, a.creation_date, a.last_updated_by,
a.last_update_date, a.hidden_ind, a.price_negotiated,
a.price_level_ind, a.price_unit, a.price_unit_percent,
a.invoice_line_level_ind, a.dpas_rating, a.template_used,
a.price_type, a.currency_code, a.last_update_login,
a.date_terminated, a.start_date, a.end_date,
a.attribute_category, a.attribute1, a.attribute2,
a.attribute3, a.attribute4, a.attribute5,
a.attribute6, a.attribute7, a.attribute8,
a.attribute9, a.attribute10, a.attribute11,
a.attribute12, a.attribute13, a.attribute14,
a.attribute15, a.security_group_id, a.cle_id_renewed_to,
a.price_negotiated_renewed, a.currency_code_renewed, a.upg_orig_system_ref,
a.upg_orig_system_ref_id, a.date_renewed, a.orig_system_source_code,
a.orig_system_id1, a.orig_system_reference1, a.program_application_id,
a.program_id, a.program_update_date, a.request_id,
a.price_list_id, a.price_list_line_id, a.line_list_price,
a.item_to_price_yn, a.pricing_date, a.price_basis_yn,
a.config_header_id, a.config_revision_number, a.config_complete_yn,
a.config_valid_yn, a.config_top_model_line_id, a.config_item_type,
a.config_item_id, a.service_item_yn, a.ph_pricing_type,
a.ph_price_break_basis, a.ph_min_qty, a.ph_min_amt,
a.ph_qp_reference_id, a.ph_value, a.ph_enforce_price_list_yn,
a.ph_adjustment, a.ph_integrated_with_qp, a.cust_acct_id,
a.bill_to_site_use_id, a.inv_rule_id, a.line_renewal_type_code,
a.ship_to_site_use_id, a.payment_term_id, b.fee_type,
c.name
FROM okc_k_lines_b a,
okl_k_lines b,
okc_k_lines_tl c
WHERE a.dnz_chr_id = p_chr_id
AND a.id = b.id
AND a.id = c.id
AND c.LANGUAGE = USERENV('LANG');
SELECT rlobj.cle_id, rlobj.object1_id1
FROM okc_k_rel_objs_v rlobj
WHERE rlobj.chr_id = p_id
--AND rlobj.cle_id = p_line_id
AND rlobj.rty_code = 'OKLSRV'
AND rlobj.jtot_object1_code = 'OKL_SERVICE_LINE';
SELECT ID
FROM OKC_K_HEADERS_B
WHERE CONTRACT_NUMBER = p_contract_number;
TYPE l_last_updated_by_type IS TABLE OF okc_k_lines_b.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
TYPE l_last_update_date_type IS TABLE OF okc_k_lines_b.last_update_date%TYPE INDEX BY BINARY_INTEGER;
TYPE l_last_update_login_type IS TABLE OF okc_k_lines_b.last_update_login%TYPE INDEX BY BINARY_INTEGER;
TYPE l_program_update_date_type IS TABLE OF okc_k_lines_b.program_update_date%TYPE INDEX BY BINARY_INTEGER;
TYPE l_plast_updated_by_type IS TABLE OF okc_k_party_roles_tl.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
TYPE l_plast_update_date_type IS TABLE OF okc_k_party_roles_tl.last_update_date%TYPE INDEX BY BINARY_INTEGER;
TYPE l_plast_update_login_type IS TABLE OF okc_k_party_roles_tl.last_update_login%TYPE INDEX BY BINARY_INTEGER;
TYPE l_oslast_updated_by_type IS TABLE OF okl_supp_invoice_dtls.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
TYPE l_oslast_update_date_type IS TABLE OF okl_supp_invoice_dtls.last_update_date%TYPE INDEX BY BINARY_INTEGER;
TYPE l_oslast_update_login_type IS TABLE OF okl_supp_invoice_dtls.last_update_login%TYPE INDEX BY BINARY_INTEGER;
TYPE l_clast_updated_by_type IS TABLE OF okc_contacts.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
TYPE l_clast_update_date_type IS TABLE OF okc_contacts.last_update_date%TYPE INDEX BY BINARY_INTEGER;
TYPE l_clast_update_login_type IS TABLE OF okc_contacts.last_update_login%TYPE INDEX BY BINARY_INTEGER;
TYPE l_rlast_updated_by_type IS TABLE OF okc_rule_groups_b.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
TYPE l_rlast_update_date_type IS TABLE OF okc_rule_groups_b.last_update_date%TYPE INDEX BY BINARY_INTEGER;
TYPE l_rlast_update_login_type IS TABLE OF okc_rule_groups_b.last_update_login%TYPE INDEX BY BINARY_INTEGER;
TYPE l_rtlast_updated_by_type IS TABLE OF okc_rule_groups_tl.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
TYPE l_rtlast_update_date_type IS TABLE OF okc_rule_groups_tl.last_update_date%TYPE INDEX BY BINARY_INTEGER;
TYPE l_rtlast_update_login_type IS TABLE OF okc_rule_groups_tl.last_update_login%TYPE INDEX BY BINARY_INTEGER;
TYPE l_rrlast_updated_by_type IS TABLE OF okc_rules_b.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
TYPE l_rrlast_update_date_type IS TABLE OF okc_rules_b.last_update_date%TYPE INDEX BY BINARY_INTEGER;
TYPE l_rrlast_update_login_type IS TABLE OF okc_rules_b.last_update_login%TYPE INDEX BY BINARY_INTEGER;
TYPE l_trlast_updated_by_type IS TABLE OF okc_rules_tl.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
TYPE l_trlast_update_date_type IS TABLE OF okc_rules_tl.last_update_date%TYPE INDEX BY BINARY_INTEGER;
TYPE l_trlast_update_login_type IS TABLE OF okc_rules_tl.last_update_login%TYPE INDEX BY BINARY_INTEGER;
TYPE l_ilast_updated_by_type IS TABLE OF okc_k_items.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
TYPE l_ilast_update_date_type IS TABLE OF okc_k_items.last_update_date%TYPE INDEX BY BINARY_INTEGER;
TYPE l_ilast_update_login_type IS TABLE OF okc_k_items.last_update_login%TYPE INDEX BY BINARY_INTEGER;
TYPE l_iprogram_update_date_type IS TABLE OF okc_k_items.program_update_date%TYPE INDEX BY BINARY_INTEGER;
TYPE l_tlast_updated_by_type IS TABLE OF okl_trx_assets.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
TYPE l_tlast_update_date_type IS TABLE OF okl_trx_assets.last_update_date%TYPE INDEX BY BINARY_INTEGER;
TYPE l_tlast_update_login_type IS TABLE OF okl_trx_assets.last_update_login%TYPE INDEX BY BINARY_INTEGER;
TYPE l_t2last_updated_by_type IS TABLE OF okl_trx_assets.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
TYPE l_t2last_update_date_type IS TABLE OF okl_trx_assets.last_update_date%TYPE INDEX BY BINARY_INTEGER;
TYPE l_t2last_update_login_type IS TABLE OF okl_trx_assets.last_update_login%TYPE INDEX BY BINARY_INTEGER;
TYPE l_tblast_updated_by_type IS TABLE OF okl_txl_assets_b.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
TYPE l_tblast_update_date_type IS TABLE OF okl_txl_assets_b.last_update_date%TYPE INDEX BY BINARY_INTEGER;
TYPE l_tblast_update_login_type IS TABLE OF okl_txl_assets_b.last_update_login%TYPE INDEX BY BINARY_INTEGER;
TYPE l_tllast_updated_by_type IS TABLE OF okl_txl_assets_tl.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
TYPE l_tllast_update_date_type IS TABLE OF okl_txl_assets_tl.last_update_date%TYPE INDEX BY BINARY_INTEGER;
TYPE l_tllast_update_login_type IS TABLE OF okl_txl_assets_tl.last_update_login%TYPE INDEX BY BINARY_INTEGER;
TYPE l_dblast_updated_by_type IS TABLE OF okl_txd_assets_b.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
TYPE l_dblast_update_date_type IS TABLE OF okl_txd_assets_b.last_update_date%TYPE INDEX BY BINARY_INTEGER;
TYPE l_dblast_update_login_type IS TABLE OF okl_txd_assets_b.last_update_login%TYPE INDEX BY BINARY_INTEGER;
TYPE l_dllast_updated_by_type IS TABLE OF okl_txd_assets_tl.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
TYPE l_dllast_update_date_type IS TABLE OF okl_txd_assets_tl.last_update_date%TYPE INDEX BY BINARY_INTEGER;
TYPE l_dllast_update_login_type IS TABLE OF okl_txd_assets_tl.last_update_login%TYPE INDEX BY BINARY_INTEGER;
TYPE l_tilast_updated_by_type IS TABLE OF okl_txl_itm_insts.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
TYPE l_tilast_update_date_type IS TABLE OF okl_txl_itm_insts.last_update_date%TYPE INDEX BY BINARY_INTEGER;
TYPE l_tilast_update_login_type IS TABLE OF okl_txl_itm_insts.last_update_login%TYPE INDEX BY BINARY_INTEGER;
TYPE l_tiselected_for_split_fl_type IS TABLE OF okl_txl_itm_insts.selected_for_split_flag%TYPE INDEX BY BINARY_INTEGER;
TYPE l_pplast_updated_by_type IS TABLE OF okl_party_payment_dtls.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
TYPE l_pplast_update_date_type IS TABLE OF okl_party_payment_dtls.last_update_date%TYPE INDEX BY BINARY_INTEGER;
TYPE l_pplast_update_login_type IS TABLE OF okl_party_payment_dtls.last_update_login%TYPE INDEX BY BINARY_INTEGER;
TYPE l_slast_updated_by_type IS TABLE OF okl_slctd_optns.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
TYPE l_slast_update_date_type IS TABLE OF okl_slctd_optns.last_update_date%TYPE INDEX BY BINARY_INTEGER;
TYPE l_slast_update_login_type IS TABLE OF okl_slctd_optns.last_update_login%TYPE INDEX BY BINARY_INTEGER;
TYPE l_glast_updated_by_type IS TABLE OF okc_rg_party_roles.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
TYPE l_glast_update_date_type IS TABLE OF okc_rg_party_roles.last_update_date%TYPE INDEX BY BINARY_INTEGER;
TYPE l_glast_update_login_type IS TABLE OF okc_rg_party_roles.last_update_login%TYPE INDEX BY BINARY_INTEGER;
TYPE l_ollast_updated_by_type IS TABLE OF okc_k_lines_tl.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
TYPE l_ollast_update_date_type IS TABLE OF okc_k_lines_tl.last_update_date%TYPE INDEX BY BINARY_INTEGER;
TYPE l_ollast_update_login_type IS TABLE OF okc_k_lines_tl.last_update_login%TYPE INDEX BY BINARY_INTEGER;
l_oslast_updated_by_tab l_oslast_updated_by_type;
l_oslast_update_date_tab l_oslast_update_date_type;
l_oslast_update_login_tab l_oslast_update_login_type;
l_plast_updated_by_tab l_plast_updated_by_type;
l_plast_update_date_tab l_plast_update_date_type;
l_plast_update_login_tab l_plast_update_login_type;
l_clast_updated_by_tab l_clast_updated_by_type;
l_clast_update_date_tab l_clast_update_date_type;
l_clast_update_login_tab l_clast_update_login_type;
l_rlast_updated_by_tab l_rlast_updated_by_type;
l_rlast_update_date_tab l_rlast_update_date_type;
l_rlast_update_login_tab l_rlast_update_login_type;
l_rtlast_updated_by_tab l_rtlast_updated_by_type;
l_rtlast_update_date_tab l_rtlast_update_date_type;
l_rtlast_update_login_tab l_rtlast_update_login_type;
l_rrlast_updated_by_tab l_rrlast_updated_by_type;
l_rrlast_update_date_tab l_rrlast_update_date_type;
l_rrlast_update_login_tab l_rrlast_update_login_type;
l_trlast_updated_by_tab l_trlast_updated_by_type;
l_trlast_update_date_tab l_trlast_update_date_type;
l_trlast_update_login_tab l_trlast_update_login_type;
l_ilast_updated_by_tab l_ilast_updated_by_type;
l_ilast_update_date_tab l_ilast_update_date_type;
l_ilast_update_login_tab l_ilast_update_login_type;
l_iprogram_update_date_tab l_iprogram_update_date_type;
l_tlast_updated_by_tab l_tlast_updated_by_type;
l_tlast_update_date_tab l_tlast_update_date_type;
l_tlast_update_login_tab l_tlast_update_login_type;
l_t2last_updated_by_tab l_t2last_updated_by_type;
l_t2last_update_date_tab l_t2last_update_date_type;
l_t2last_update_login_tab l_t2last_update_login_type;
l_tblast_updated_by_tab l_tblast_updated_by_type;
l_tblast_update_date_tab l_tblast_update_date_type;
l_tblast_update_login_tab l_tblast_update_login_type;
l_tb2last_updated_by_tab l_tblast_updated_by_type;
l_tb2last_update_date_tab l_tblast_update_date_type;
l_tb2last_update_login_tab l_tblast_update_login_type;
l_tllast_updated_by_tab l_tllast_updated_by_type;
l_tllast_update_date_tab l_tllast_update_date_type;
l_tllast_update_login_tab l_tllast_update_login_type;
l_dblast_updated_by_tab l_dblast_updated_by_type;
l_dblast_update_date_tab l_dblast_update_date_type;
l_dblast_update_login_tab l_dblast_update_login_type;
l_dllast_updated_by_tab l_dllast_updated_by_type;
l_dllast_update_date_tab l_dllast_update_date_type;
l_dllast_update_login_tab l_dllast_update_login_type;
l_tilast_updated_by_tab l_tilast_updated_by_type;
l_tilast_update_date_tab l_tilast_update_date_type;
l_tilast_update_login_tab l_tilast_update_login_type;
l_tiselected_for_split_fl_tab l_tiselected_for_split_fl_type;
l_ollast_updated_by_tab l_ollast_updated_by_type;
l_ollast_update_date_tab l_ollast_update_date_type;
l_ollast_update_login_tab l_ollast_update_login_type;
l_pplast_updated_by_tab l_pplast_updated_by_type;
l_pplast_update_date_tab l_pplast_update_date_type;
l_pplast_update_login_tab l_pplast_update_login_type;
l_slast_updated_by_tab l_slast_updated_by_type;
l_slast_update_date_tab l_slast_update_date_type;
l_slast_update_login_tab l_slast_update_login_type;
l_glast_updated_by_tab l_glast_updated_by_type;
l_glast_update_date_tab l_glast_update_date_type;
l_glast_update_login_tab l_glast_update_login_type;
l_delete_id_tab l_id_type;
l_delete_counter NUMBER := 1;
l_last_updated_by_tab l_last_updated_by_type;
l_last_update_date_tab l_last_update_date_type;
l_last_update_login_tab l_last_update_login_type;
l_program_update_date_tab l_program_update_date_type;
l_last_updated_by_tab2 l_last_updated_by_type;
l_last_update_date_tab2 l_last_update_date_type;
l_last_update_login_tab2 l_last_update_login_type;
l_program_update_date_tab2 l_program_update_date_type;
SELECT 'x'
FROM FND_CURRENCIES_VL
WHERE currency_code = p_ccy_code
AND SYSDATE BETWEEN NVL(start_date_active,SYSDATE)
AND NVL(end_date_active,SYSDATE);
SELECT '!'
FROM gl_daily_conversion_types
WHERE conversion_type = p_curr_cotyp;
/* AKP To do: Delete this procedure from here.
After the spec in okl_copy_asset_pvt spec has been changed to
expose this function */
FUNCTION generate_asset_number(x_asset_number OUT NOCOPY OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE)
RETURN VARCHAR2 IS
x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
SELECT 'OKL'||OKL_FAN_SEQ.NEXTVAL
FROM dual;
SELECT 1
FROM DUAL
WHERE EXISTS (SELECT '1'
FROM OKL_TXL_ASSETS_B
WHERE asset_number = p_asset_number);
SELECT 1
FROM DUAL
WHERE EXISTS (SELECT '1'
FROM OKX_ASSET_LINES_V
WHERE asset_number = p_asset_number);
SELECT 1
FROM DUAL
WHERE EXISTS (SELECT '1'
FROM OKX_ASSETS_V
WHERE asset_number = p_asset_number);
PROCEDURE insert_okc_k_lines_tl(p_old_id IN okc_k_lines_b.id%TYPE) IS
CURSOR c5(p_id NUMBER) IS
SELECT
a.id, a.LANGUAGE, a.source_lang,
a.sfwt_flag, a.name, a.comments,
a.item_description, a.block23text, a.created_by,
a.creation_date, a.last_updated_by, a.last_update_date,
a.last_update_login, a.security_group_id, a.oke_boe_description,
a.cognomen, b.lse_id, b.sts_code, c.fee_type
--avsingh: Bug 5710213: start
, lsb.lty_code
--avsingh: Bug 5710213: end
FROM okc_k_lines_tl a,
okc_k_lines_b b,
okl_k_lines c,
fnd_languages d
--avsingh: Bug 5710213: start
, okc_line_styles_b lsb
--avsingh: Bug 5710213: end
WHERE a.id = b.id
AND b.id = c.id
AND a.id = c.id
AND b.dnz_chr_id = p_id
AND a.LANGUAGE = d.language_code
AND d.installed_flag = 'B'
--avsingh: Bug 5710213: start
AND b.lse_id = lsb.id
--avsingh: Bug 5710213: end
;
SELECT language_code
FROM fnd_languages
WHERE installed_flag IN ('B', 'I');
SELECT DISTINCT a.name
FROM okc_k_lines_tl a,
okc_k_lines_b b
WHERE a.id = b.id
AND b.dnz_chr_id = p_id
-- gboomina Bug 6353660 - Start
-- excluding NULL values to get valid asset numbers
-- which is used down the line to replace asset numbers.
AND a.name IS NOT NULL
-- gboomina Bug 6353660 - End
AND a.LANGUAGE = USERENV('LANG');
l_ollast_updated_by_tab2 l_ollast_updated_by_type;
l_ollast_update_date_tab2 l_ollast_update_date_type;
l_ollast_update_login_tab2 l_ollast_update_login_type;
l_olcreation_date_tab2, l_ollast_updated_by_tab2, l_ollast_update_date_tab2,
l_ollast_update_login_tab2, l_olsecurity_group_id_tab2, l_oloke_boe_description_tab2,
l_olcognomen_tab2, l_ollse_id_tab2, l_olsts_code_tab2, l_olfee_type_tab2
--avsingh: Bug 5710213: start
, l_ollty_code_tab2
--avsingh: Bug 5710213: end
limit G_BULK_SIZE;
l_ollast_updated_by_tab(l_okc_k_lines_tl_counter) := l_ollast_updated_by_tab2(i);
l_ollast_update_date_tab(l_okc_k_lines_tl_counter) := l_ollast_update_date_tab2(i);
l_ollast_update_login_tab(l_okc_k_lines_tl_counter) := l_ollast_update_login_tab2(i);
print('Printing insert_okc_k_lines_tl:l_olid_tab ...');
INSERT INTO okc_k_lines_tl (
id, LANGUAGE, source_lang,
sfwt_flag, name, comments,
item_description, block23text, created_by,
creation_date, last_updated_by, last_update_date,
last_update_login, security_group_id, oke_boe_description,
cognomen
) VALUES (
l_olid_tab(i), r.language_code, l_olsource_lang_tab(i),
'N', l_olname_tab(i), l_olcomments_tab(i),
l_olitem_description_tab(i), l_olblock23text_tab(i), l_created_by,
SYSDATE,l_last_updated_by,SYSDATE,
l_last_update_login,l_olsecurity_group_id_tab(i),l_oloke_boe_description_tab(i),
l_olcognomen_tab(i)
);
p_token1_value => 'insert_okc_k_lines_tl');*/
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Printing insert_okc_k_lines_tl:l_olid_tab.count=' || l_olid_tab.COUNT || ' ...');
END; /* insert okc_k_lines_tl */
PROCEDURE insert_okc_k_lines_tl_old(p_old_id IN okc_k_lines_b.id%TYPE,
p_new_id IN okc_k_lines_b.id%TYPE,
p_flush IN VARCHAR2 ) IS
CURSOR c5(p_id okc_k_lines_b.id%TYPE) IS
SELECT
a.id, a.LANGUAGE, a.source_lang,
a.sfwt_flag, a.name, a.comments,
a.item_description, a.block23text, a.created_by,
a.creation_date, a.last_updated_by, a.last_update_date,
a.last_update_login, a.security_group_id, a.oke_boe_description,
a.cognomen, b.lse_id
FROM okc_k_lines_tl a,
okc_k_lines_b b
WHERE a.id = p_id
AND a.id = b.id;
l_ollast_updated_by_tab2 l_ollast_updated_by_type;
l_ollast_update_date_tab2 l_ollast_update_date_type;
l_ollast_update_login_tab2 l_ollast_update_login_type;
l_olcreation_date_tab2, l_ollast_updated_by_tab2, l_ollast_update_date_tab2,
l_ollast_update_login_tab2,l_olsecurity_group_id_tab2, l_oloke_boe_description_tab2,
l_olcognomen_tab2, l_ollse_id_tab2
limit G_BULK_SIZE;
l_ollast_updated_by_tab(l_okc_k_lines_tl_counter) := l_ollast_updated_by_tab2(i);
l_ollast_update_date_tab(l_okc_k_lines_tl_counter) := l_ollast_update_date_tab2(i);
l_ollast_update_login_tab(l_okc_k_lines_tl_counter) := l_ollast_update_login_tab2(i);
INSERT INTO okc_k_lines_tl (
id, LANGUAGE, source_lang,
sfwt_flag, name, comments,
item_description, block23text, created_by,
creation_date, last_updated_by, last_update_date,
last_update_login, security_group_id, oke_boe_description,
cognomen
) VALUES (
l_olid_tab(i), l_ollanguage_tab(i), l_olsource_lang_tab(i),
'N', l_olname_tab(i), l_olcomments_tab(i),
l_olitem_description_tab(i), l_olblock23text_tab(i), l_created_by,
SYSDATE,l_last_updated_by,SYSDATE,
l_last_update_login,l_olsecurity_group_id_tab(i),l_oloke_boe_description_tab(i),
l_olcognomen_tab(i)
);
END; /* insert_okc_k_lines_tl_old */
PROCEDURE insert_okc_k_headers_tl(p_old_id IN okc_k_headers_tl.id%TYPE,
p_new_id IN okc_k_headers_tl.id%TYPE) IS
CURSOR c6(p_id okc_k_headers_tl.id%TYPE) IS
SELECT
id, LANGUAGE, source_lang,
sfwt_flag, short_description, comments,
description, cognomen, non_response_reason,
non_response_explain, set_aside_reason, created_by,
creation_date, last_updated_by, last_update_date,
last_update_login, security_group_id
FROM okc_k_headers_tl
WHERE id = p_id;
TYPE l_last_updated_by_type IS TABLE OF okc_k_headers_tl.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
TYPE l_last_update_date_type IS TABLE OF okc_k_headers_tl.last_update_date%TYPE INDEX BY BINARY_INTEGER;
TYPE l_last_update_login_type IS TABLE OF okc_k_headers_tl.last_update_login%TYPE INDEX BY BINARY_INTEGER;
l_last_updated_by_tab l_last_updated_by_type;
l_last_update_date_tab l_last_update_date_type;
l_last_update_login_tab l_last_update_login_type;
l_creation_date_tab, l_last_updated_by_tab, l_last_update_date_tab,
l_last_update_login_tab, l_security_group_id_tab
limit G_BULK_SIZE;
INSERT INTO okc_k_headers_tl (
id, LANGUAGE, source_lang,
sfwt_flag, short_description, comments,
description, cognomen, non_response_reason,
non_response_explain, set_aside_reason, created_by,
creation_date, last_updated_by, last_update_date,
last_update_login, security_group_id
) VALUES (
l_id_tab(i), l_language_tab(i), l_source_lang_tab(i),
'N', l_short_description_tab(i), l_comments_tab(i),
l_description_tab(i), l_cognomen_tab(i), NULL,
NULL, NULL, l_created_by,
SYSDATE, l_last_updated_by, SYSDATE,
l_last_update_login, l_security_group_id_tab(i)
);
p_token1_value => 'insert_okc_k_headers_tl');*/
END; /* insert_okc_k_headers_tl */
PROCEDURE insert_okl_k_headers(p_old_id IN okc_k_headers_tl.id%TYPE,
p_new_id IN okc_k_headers_tl.id%TYPE) IS
CURSOR c7(p_id okl_k_headers.id%TYPE) IS
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,
currency_conversion_type, currency_conversion_rate, currency_conversion_date,
multi_gaap_yn, recourse_code, lessor_serv_org_code,
assignable_yn, securitized_code, securitization_type,
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,
tot_cl_transfer_amt, tot_cl_net_transfer_amt, tot_cl_limit,
tot_cl_funding_amt, crs_id, template_type_code,
tradein_description, date_funding_expected, tradein_amount,
date_tradein,
legal_entity_id
FROM okl_k_headers
WHERE id = p_id;
TYPE l_last_updated_by_type IS TABLE OF okl_k_headers.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
TYPE l_last_update_date_type IS TABLE OF okl_k_headers.last_update_date%TYPE INDEX BY BINARY_INTEGER;
TYPE l_last_update_login_type IS TABLE OF okl_k_headers.last_update_login%TYPE INDEX BY BINARY_INTEGER;
l_last_updated_by_tab l_last_updated_by_type;
l_last_update_date_tab l_last_update_date_type;
l_last_update_login_tab l_last_update_login_type;
l_last_updated_by_tab, l_last_update_date_tab, l_last_update_login_tab,
l_amd_code_tab, l_generate_accrual_yn_tab, l_generate_ac_override_yn_tab,
l_credit_act_yn_tab, l_converted_account_yn_tab, l_pre_tax_yield_tab,
l_after_tax_yield_tab, l_implicit_interest_rate_tab, l_implicit_non_idc_i_rate_tab,
l_target_pre_tax_yield_tab, l_target_after_tax_yield_tab, l_target_implicit_in_rate_tab,
l_target_i_nonidc_intrate_tab, l_date_last_interim_i_cal_tab, l_deal_type_tab,
l_pre_tax_irr_tab, l_after_tax_irr_tab, l_expected_delivery_date_tab,
l_accepted_date_tab, l_prefunding_eligible_yn_tab, l_revolving_credit_yn_tab,
l_currency_conversion_type_tab, l_currency_conversion_rate_tab, l_currency_conversion_date_tab,
l_multi_gaap_yn_tab, l_recourse_code_tab, l_lessor_serv_org_code_tab,
l_assignable_yn_tab, l_securitized_code_tab, l_securitization_type_tab,
l_sub_pre_tax_yield_tab, l_sub_after_tax_yield_tab, l_sub_impl_interest_rate_tab,
l_sub_impl_non_idc_int_ra_tab, l_sub_pre_tax_irr_tab, l_sub_after_tax_irr_tab,
l_tot_cl_transfer_amt_tab, l_tot_cl_net_transfer_amt_tab, l_tot_cl_limit_tab,
l_tot_cl_funding_amt_tab, l_crs_id_tab, l_template_type_code_tab,
l_tradein_description_tab, l_date_funding_expected_tab, l_tradein_amount_tab,
l_date_tradein_tab,l_legal_entity_id_tab
limit G_BULK_SIZE;
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,
currency_conversion_type, currency_conversion_rate, currency_conversion_date,
multi_gaap_yn, recourse_code, lessor_serv_org_code,
assignable_yn, securitized_code, securitization_type,
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,
tot_cl_transfer_amt, tot_cl_net_transfer_amt, tot_cl_limit,
tot_cl_funding_amt, crs_id, template_type_code,
tradein_description, date_funding_expected, tradein_amount,
date_tradein,legal_entity_id
) VALUES (
l_id_tab(i), l_isg_id_tab(i), l_khr_id_tab(i),
l_pdt_id_tab(i), 1, l_date_first_activity_tab(i),
l_syndicatable_yn_tab(i), l_salestype_yn_tab(i), l_date_refinanced_tab(i),
l_date_conversion_effectiv_tab(i), l_date_deal_transferred_tab(i), l_term_duration_tab(i),
l_datetime_proposal_effec_tab(i), l_datetime_proposal_ineff_tab(i), l_date_proposal_accepted_tab(i),
l_attribute_category_tab(i), l_attribute1_tab(i), l_attribute2_tab(i),
l_attribute3_tab(i), l_attribute4_tab(i), l_attribute5_tab(i),
l_attribute6_tab(i), l_attribute7_tab(i), l_attribute8_tab(i),
l_attribute9_tab(i), l_attribute10_tab(i), l_attribute11_tab(i),
l_attribute12_tab(i), l_attribute13_tab(i), l_attribute14_tab(i),
l_attribute15_tab(i), l_created_by, SYSDATE,
l_last_updated_by, SYSDATE, l_last_update_login,
l_amd_code_tab(i), l_generate_accrual_yn_tab(i), l_generate_ac_override_yn_tab(i),
l_credit_act_yn_tab(i), l_converted_account_yn_tab(i), DECODE(p_trans_type, 'CFA', NULL, 'CRL', NULL, l_pre_tax_yield_tab(i)),
DECODE(p_trans_type, 'CFA',NULL, 'CRL',NULL, l_after_tax_yield_tab(i)), DECODE(p_trans_type, 'CFA',NULL, 'CRL',NULL, l_implicit_interest_rate_tab(i)), DECODE(p_trans_type, 'CFA',NULL, 'CRL',NULL, l_implicit_non_idc_i_rate_tab(i)),
l_target_pre_tax_yield_tab(i), l_target_after_tax_yield_tab(i), l_target_implicit_in_rate_tab(i),
l_target_i_nonidc_intrate_tab(i), DECODE(p_trans_type, 'CFA',NULL, 'CRL',NULL, l_date_last_interim_i_cal_tab(i)), l_deal_type_tab(i),
DECODE(p_trans_type, 'CFA',NULL, 'CRL',NULL, l_pre_tax_irr_tab(i)), DECODE(p_trans_type, 'CFA',NULL, 'CRL',NULL, l_after_tax_irr_tab(i)), l_expected_delivery_date_tab(i),
l_accepted_date_tab(i), l_prefunding_eligible_yn_tab(i), l_revolving_credit_yn_tab(i),
l_currency_conversion_type_tab(i), l_currency_conversion_rate_tab(i), l_currency_conversion_date_tab(i),
l_multi_gaap_yn_tab(i), l_recourse_code_tab(i), l_lessor_serv_org_code_tab(i),
--l_assignable_yn_tab(i), l_securitized_code_tab(i), l_securitization_type_tab(i),
--Fix bug 4381642 to nullify securitized_code
l_assignable_yn_tab(i), NULL, l_securitization_type_tab(i),
DECODE(p_trans_type, 'CFA',NULL, 'CRL',NULL, l_sub_pre_tax_yield_tab(i)), DECODE(p_trans_type, 'CFA',NULL, 'CRL',NULL, l_sub_after_tax_yield_tab(i)), DECODE(p_trans_type, 'CFA',NULL, 'CRL',NULL,l_sub_impl_interest_rate_tab(i)),
DECODE(p_trans_type, 'CFA',NULL, 'CRL',NULL, l_sub_impl_non_idc_int_ra_tab(i)), DECODE(p_trans_type, 'CFA',NULL, 'CRL',NULL,l_sub_pre_tax_irr_tab(i)), DECODE(p_trans_type, 'CFA',NULL, 'CRL',NULL, l_sub_after_tax_irr_tab(i)),
DECODE(p_trans_type, 'CFA',NULL, 'CRL',NULL, l_tot_cl_transfer_amt_tab(i)), DECODE(p_trans_type, 'CFA',NULL, 'CRL',NULL, l_tot_cl_net_transfer_amt_tab(i)), DECODE(p_trans_type, 'CFA',NULL, 'CRL',NULL, l_tot_cl_limit_tab(i)),
DECODE(p_trans_type, 'CFA',NULL, 'CRL',NULL, l_tot_cl_funding_amt_tab(i)),
l_crs_id_tab(i), l_template_type_code_tab(i),l_tradein_description_tab(i),
l_date_funding_expected_tab(i), l_tradein_amount_tab(i), l_date_tradein_tab(i),l_legal_entity_id_tab(i)
);
p_token1_value => 'insert_okl_k_headers');*/
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Printing insert_okl_k_headers:l_id_tab=' || l_id_tab.COUNT || ' ...');
END; /* insert_okl_k_headers */
PROCEDURE insert_okl_slctd_optns(p_old_id IN okc_k_headers_tl.id%TYPE,
p_new_id IN okc_k_headers_tl.id%TYPE) IS
CURSOR c24(p_id NUMBER) IS
SELECT
id, pov_id, khr_id,
object_version_number, 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
FROM okl_slctd_optns
WHERE khr_id = p_id;
l_slast_updated_by_tab2 l_slast_updated_by_type;
l_slast_update_date_tab2 l_slast_update_date_type;
l_slast_update_login_tab2 l_slast_update_login_type;
l_screation_date_tab2, l_slast_updated_by_tab2, l_slast_update_date_tab2,
l_slast_update_login_tab2
limit G_BULK_SIZE;
l_slast_updated_by_tab(l_slctd_optns_counter) := l_slast_updated_by_tab2(i);
l_slast_update_date_tab(l_slctd_optns_counter) := l_slast_update_date_tab2(i);
l_slast_update_login_tab(l_slctd_optns_counter) := l_slast_update_login_tab2(i);
INSERT INTO okl_slctd_optns (
id, pov_id, khr_id,
object_version_number, 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
) VALUES (
l_sid_tab(i), l_spov_id_tab(i), l_skhr_id_tab(i),
l_sobject_version_number_tab(i), l_sattribute_category_tab(i), l_sattribute1_tab(i),
l_sattribute2_tab(i), l_sattribute3_tab(i), l_sattribute4_tab(i),
l_sattribute5_tab(i), l_sattribute6_tab(i), l_sattribute7_tab(i),
l_sattribute8_tab(i), l_sattribute9_tab(i), l_sattribute10_tab(i),
l_sattribute11_tab(i), l_sattribute12_tab(i), l_sattribute13_tab(i),
l_sattribute14_tab(i), l_sattribute15_tab(i), l_created_by,
SYSDATE, l_last_updated_by, SYSDATE,
l_last_update_login
);
p_token1_value => 'insert_okl_slctd_optns');*/
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Printing insert_okl_slctd_optns:l_sid_tab=' || l_sid_tab.COUNT || ' ...');
END; /* insert_okl_slctd_optns */
PROCEDURE insert_okl_k_lines IS
CURSOR c8(p_id NUMBER) IS
SELECT
a.id, a.kle_id, a.sty_id,
a.object_version_number, a.lao_amount, a.fee_charge,
a.title_date, a.date_residual_last_review, a.date_last_reamortisation,
a.termination_purchase_amount, a.date_last_cleanup, a.remarketed_amount,
a.date_remarketed, a.remarket_margin, a.repurchased_amount,
a.date_repurchased, a.gain_loss, a.floor_amount,
a.previous_contract, a.tracked_residual, a.date_title_received,
a.estimated_oec, a.residual_percentage, a.capital_reduction,
a.vendor_advance_paid, a.tradein_amount, a.delivered_date,
a.year_of_manufacture, a.initial_direct_cost, a.occupancy,
a.date_last_inspection, a.date_next_inspection_due, a.weighted_average_life,
a.bond_equivalent_yield, a.refinance_amount, a.year_built,
a.coverage_ratio, a.gross_square_footage, a.net_rentable,
a.date_letter_acceptance, a.date_commitment_expiration, a.date_appraisal,
a.appraisal_value, a.residual_value, a.percent,
a.coverage, a.lrv_amount, a.amount,
a.lrs_percent, a.evergreen_percent, a.percent_stake,
a.amount_stake, a.date_sold, a.sty_id_for,
a.attribute_category, a.attribute1, a.attribute2,
a.attribute3, a.attribute4, a.attribute5,
a.attribute6, a.attribute7, a.attribute8,
a.attribute9, a.attribute10, a.attribute11,
a.attribute12, a.attribute13, a.attribute14,
a.attribute15, a.created_by, a.creation_date,
a.last_updated_by, a.last_update_date, a.last_update_login,
a.nty_code, a.fcg_code, a.prc_code,
a.re_lease_yn, a.prescribed_asset_yn, a.credit_tenant_yn,
a.secured_deal_yn, a.clg_id, a.date_funding,
a.date_funding_required, a.date_accepted, a.date_delivery_expected,
a.oec, a.capital_amount, a.residual_grnty_amount,
a.residual_code, a.rvi_premium, a.credit_nature,
a.capitalized_interest, a.capital_reduction_percent, a.date_pay_investor_start,
a.pay_investor_frequency, a.pay_investor_event, a.pay_investor_remittance_days,
a.fee_type, a.subsidy_id, a.subsidy_override_amount,
a.pre_tax_yield, a.after_tax_yield, a.implicit_interest_rate,
a.implicit_non_idc_interest_rate, a.pre_tax_irr, a.after_tax_irr,
a.sub_pre_tax_yield, a.sub_after_tax_yield, a.sub_impl_interest_rate,
a.sub_impl_non_idc_int_rate, a.sub_pre_tax_irr, a.sub_after_tax_irr,
a.item_insurance_category, a.qte_id, a.funding_date,
a.stream_type_subclass, b.lse_id, c.item_description,
a.fee_purpose_code, a.date_funding_expected, a.manufacturer_name,
a.model_number, a.down_payment_receiver_code, a.capitalize_down_payment_yn
FROM okl_k_lines a,
okc_k_lines_b b,
okc_k_lines_tl c
WHERE b.id = a.id
AND b.dnz_chr_id = p_id
AND b.id = c.id
AND c.LANGUAGE = USERENV('LANG');
TYPE l_last_updated_by_type IS TABLE OF okl_k_lines.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
TYPE l_last_update_date_type IS TABLE OF okl_k_lines.last_update_date%TYPE INDEX BY BINARY_INTEGER;
TYPE l_last_update_login_type IS TABLE OF okl_k_lines.last_update_login%TYPE INDEX BY BINARY_INTEGER;
l_last_updated_by_tab l_last_updated_by_type;
l_last_update_date_tab l_last_update_date_type;
l_last_update_login_tab l_last_update_login_type;
l_last_updated_by_tab2 l_last_updated_by_type;
l_last_update_date_tab2 l_last_update_date_type;
l_last_update_login_tab2 l_last_update_login_type;
l_last_updated_by_tab2, l_last_update_date_tab2, l_last_update_login_tab2,
l_nty_code_tab2, l_fcg_code_tab2, l_prc_code_tab2,
l_re_lease_yn_tab2, l_prescribed_asset_yn_tab2, l_credit_tenant_yn_tab2,
l_secured_deal_yn_tab2, l_clg_id_tab2, l_date_funding_tab2,
l_date_funding_required_tab2, l_date_accepted_tab2, l_date_delivery_expected_tab2,
l_oec_tab2, l_capital_amount_tab2, l_residual_grnty_amount_tab2,
l_residual_code_tab2, l_rvi_premium_tab2, l_credit_nature_tab2,
l_capitalized_interest_tab2, l_capital_reduction_perce_tab2, l_date_pay_investor_start_tab2,
l_pay_investor_frequency_tab2, l_pay_investor_event_tab2, l_pay_investor_remit_days_tab2,
l_fee_type_tab2, l_subsidy_id_tab2, l_subsidy_override_amount_tab2,
l_pre_tax_yield_tab2, l_after_tax_yield_tab2, l_implicit_interest_rate_tab2,
l_implicit_non_idc_i_rate_tab2, l_pre_tax_irr_tab2, l_after_tax_irr_tab2,
l_sub_pre_tax_yield_tab2, l_sub_after_tax_yield_tab2, l_sub_impl_interest_rate_tab2,
l_sub_impl_non_idc_int_ra_tab2, l_sub_pre_tax_irr_tab2, l_sub_after_tax_irr_tab2,
l_item_insurance_category_tab2, l_qte_id_tab2, l_funding_date_tab2,
l_stream_type_subclass_tab2, l_lse_id_tab2, l_item_description_tab2,
l_fee_purpose_code_tab2, l_date_funding_expected_tab2, l_manufacturer_name_tab2,
l_model_number_tab2, l_down_payment_recei_code_tab2, l_capitalize_down_paym_yn_tab2
limit G_BULK_SIZE;
l_last_updated_by_tab(l_okl_k_lines_counter) := l_last_updated_by_tab2(i);
l_last_update_date_tab(l_okl_k_lines_counter) := l_last_update_date_tab2(i);
l_last_update_login_tab(l_okl_k_lines_counter) := l_last_update_login_tab2(i);
SELECT id INTO l_34_id
FROM okc_k_lines_b
WHERE cle_id = l_curr_id
AND lse_id = 34;
SELECT a.asset_category_id
INTO l_asset_category_id
FROM mtl_system_items a,
okc_k_items b
WHERE a.inventory_item_id = TO_NUMBER(b.object1_id1)
AND a.organization_id = TO_NUMBER(b.object1_id2)
AND b.cle_id = l_34_id;
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,date_pay_investor_start,
pay_investor_frequency, pay_investor_event,pay_investor_remittance_days,
fee_type, subsidy_id, subsidy_override_amount,
pre_tax_yield, after_tax_yield, implicit_interest_rate,
implicit_non_idc_interest_rate, pre_tax_irr, after_tax_irr,
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,
item_insurance_category, qte_id, funding_date,
stream_type_subclass, fee_purpose_code, date_funding_expected,
manufacturer_name, model_number, down_payment_receiver_code,
capitalize_down_payment_yn
) VALUES (
l_id_tab(i), l_kle_id_tab(i), l_sty_id_tab(i),
l_object_version_number_tab(i), l_lao_amount_tab(i), l_fee_charge_tab(i),
l_title_date_tab(i), l_date_residual_last_revi_tab(i), l_date_last_reamortisatio_tab(i),
l_termination_purchase_am_tab(i), l_date_last_cleanup_tab(i), l_remarketed_amount_tab(i),
l_date_remarketed_tab(i), l_remarket_margin_tab(i), l_repurchased_amount_tab(i),
l_date_repurchased_tab(i), l_gain_loss_tab(i), l_floor_amount_tab(i),
l_previous_contract_tab(i), l_tracked_residual_tab(i), l_date_title_received_tab(i),
l_estimated_oec_tab(i), l_residual_percentage_tab(i), l_capital_reduction_tab(i),
l_vendor_advance_paid_tab(i), l_tradein_amount_tab(i), l_delivered_date_tab(i),
l_year_of_manufacture_tab(i), l_initial_direct_cost_tab(i), l_occupancy_tab(i),
l_date_last_inspection_tab(i), l_date_next_inspection_du_tab(i), l_weighted_average_life_tab(i),
l_bond_equivalent_yield_tab(i), l_refinance_amount_tab(i), l_year_built_tab(i),
l_coverage_ratio_tab(i), l_gross_square_footage_tab(i), l_net_rentable_tab(i),
l_date_letter_acceptance_tab(i), l_date_commitment_expirat_tab(i), l_date_appraisal_tab(i),
l_appraisal_value_tab(i), l_residual_value_tab(i), l_percent_tab(i),
l_coverage_tab(i), l_lrv_amount_tab(i), l_amount_tab(i),
l_lrs_percent_tab(i), l_evergreen_percent_tab(i), l_percent_stake_tab(i),
l_amount_stake_tab(i), l_date_sold_tab(i), l_sty_id_for_tab(i),
l_attribute_category_tab(i), l_attribute1_tab(i), l_attribute2_tab(i),
l_attribute3_tab(i), l_attribute4_tab(i), l_attribute5_tab(i),
l_attribute6_tab(i), l_attribute7_tab(i), l_attribute8_tab(i),
l_attribute9_tab(i), l_attribute10_tab(i), l_attribute11_tab(i),
l_attribute12_tab(i), l_attribute13_tab(i), l_attribute14_tab(i),
l_attribute15_tab(i), l_created_by_tab(i), l_creation_date_tab(i),
l_last_updated_by_tab(i), l_last_update_date_tab(i), l_last_update_login_tab(i),
l_nty_code_tab(i), l_fcg_code_tab(i), l_prc_code_tab(i),
l_re_lease_yn_tab(i), l_prescribed_asset_yn_tab(i), l_credit_tenant_yn_tab(i),
l_secured_deal_yn_tab(i), l_clg_id_tab(i), l_date_funding_tab(i),
l_date_funding_required_tab(i), l_date_accepted_tab(i), l_date_delivery_expected_tab(i),
l_oec_tab(i), l_capital_amount_tab(i), l_residual_grnty_amount_tab(i),
l_residual_code_tab(i), l_rvi_premium_tab(i), l_credit_nature_tab(i),
l_capitalized_interest_tab(i), l_capital_reduction_perce_tab(i), l_date_pay_investor_start_tab(i),
l_pay_investor_frequency_tab(i), l_pay_investor_event_tab(i), l_pay_investor_remit_days_tab(i),
l_fee_type_tab(i), l_subsidy_id_tab(i), l_subsidy_override_amount_tab(i),
l_pre_tax_yield_tab(i), l_after_tax_yield_tab(i), l_implicit_interest_rate_tab(i),
l_implicit_non_idc_i_rate_tab(i), l_pre_tax_irr_tab(i), l_after_tax_irr_tab(i),
l_sub_pre_tax_yield_tab(i), l_sub_after_tax_yield_tab(i), l_sub_impl_interest_rate_tab(i),
l_sub_impl_non_idc_int_ra_tab(i), l_sub_pre_tax_irr_tab(i), l_sub_after_tax_irr_tab(i),
l_item_insurance_category_tab(i), l_qte_id_tab(i), l_funding_date_tab(i),
l_stream_type_subclass_tab(i), l_fee_purpose_code_tab(i), l_date_funding_expected_tab(i),
l_manufacturer_name_tab(i), l_model_number_tab(i), l_down_payment_recei_code_tab(i),
l_capitalize_down_paym_yn_tab(i)
);
p_token1_value => 'insert_okl_k_lines');*/
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Printing insert_okl_k_lines:l_id_tab.count=' || l_id_tab.COUNT || ' ...');
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_last_updated_by_tab('||i||')=' || l_last_updated_by_tab(i));
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_last_update_date_tab('||i||')=' || l_last_update_date_tab(i));
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_last_update_login_tab('||i||')=' || l_last_update_login_tab(i));
END; /* insert_okl_k_lines */
SELECT
a.id, a.object_version_number, a.attribute_category,
a.attribute1, a.attribute2, a.attribute3,
a.attribute4, a.attribute5, a.attribute6,
a.attribute7, a.attribute8, a.attribute9,
a.attribute10, a.attribute11, a.attribute12,
a.attribute13, a.attribute14, a.attribute15
FROM okl_k_party_roles a
WHERE id = p_id;
INSERT INTO okl_k_party_roles (
id, object_version_number, 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
) VALUES (
l_plid_tab(i), l_plobject_version_number_tab(i), l_plattribute_category_tab(i),
l_plattribute1_tab(i), l_plattribute2_tab(i), l_plattribute3_tab(i),
l_plattribute4_tab(i), l_plattribute5_tab(i), l_plattribute6_tab(i),
l_plattribute7_tab(i), l_plattribute8_tab(i), l_plattribute9_tab(i),
l_plattribute10_tab(i), l_plattribute11_tab(i), l_plattribute12_tab(i),
l_plattribute13_tab(i), l_plattribute14_tab(i), l_plattribute15_tab(i),
l_created_by, SYSDATE, l_last_updated_by,
SYSDATE, l_last_update_login
);
SELECT
id, LANGUAGE, source_lang,
sfwt_flag, created_by, creation_date,
last_updated_by, last_update_date, cognomen,
alias, last_update_login, security_group_id
FROM okc_k_party_roles_tl
WHERE id = p_id;
l_plast_updated_by_tab2 l_plast_updated_by_type;
l_plast_update_date_tab2 l_plast_update_date_type;
l_plast_update_login_tab2 l_plast_update_login_type;
l_plast_updated_by_tab2, l_plast_update_date_tab2, l_pcognomen_tab2,
l_palias_tab2, l_plast_update_login_tab2, l_psecurity_group_id_tab2
limit G_BULK_SIZE;
l_plast_updated_by_tab(l_party_roles_tl_counter) := l_plast_updated_by_tab2(i);
l_plast_update_date_tab(l_party_roles_tl_counter) := l_plast_update_date_tab2(i);
l_plast_update_login_tab(l_party_roles_tl_counter) := l_plast_update_login_tab2(i);
INSERT INTO okc_k_party_roles_tl (
id, LANGUAGE, source_lang,
sfwt_flag, created_by, creation_date,
last_updated_by, last_update_date, cognomen,
alias, last_update_login, security_group_id
) VALUES (
l_pid_tab(i), l_planguage_tab(i), l_psource_lang_tab(i),
'N', l_created_by, SYSDATE,
l_last_updated_by, SYSDATE,l_pcognomen_tab(i),
l_palias_tab(i),l_last_update_login, l_psecurity_group_id_tab(i)
);
SELECT
id, cpl_id, cro_code,
dnz_chr_id, object1_id1, object1_id2,
jtot_object1_code, object_version_number, created_by,
creation_date, last_updated_by, last_update_date,
contact_sequence, last_update_login, attribute_category,
attribute1, attribute2, attribute3,
attribute4, attribute5, attribute6,
attribute7, attribute8, attribute9,
attribute10, attribute11, attribute12,
attribute13, attribute14, attribute15,
security_group_id, start_date, end_date,
primary_yn, resource_class
FROM okc_contacts
WHERE cpl_id = p_id;
l_clast_updated_by_tab2 l_clast_updated_by_type;
l_clast_update_date_tab2 l_clast_update_date_type;
l_clast_update_login_tab2 l_clast_update_login_type;
l_ccreation_date_tab2, l_clast_updated_by_tab2, l_clast_update_date_tab2,
l_ccontact_sequence_tab2, l_clast_update_login_tab2, l_cattribute_category_tab2,
l_cattribute1_tab2, l_cattribute2_tab2, l_cattribute3_tab2,
l_cattribute4_tab2, l_cattribute5_tab2, l_cattribute6_tab2,
l_cattribute7_tab2, l_cattribute8_tab2, l_cattribute9_tab2,
l_cattribute10_tab2, l_cattribute11_tab2, l_cattribute12_tab2,
l_cattribute13_tab2, l_cattribute14_tab2, l_cattribute15_tab2,
l_csecurity_group_id_tab2, l_cstart_date_tab2, l_cend_date_tab2,
l_cprimary_yn_tab2, l_cresource_class_tab2
limit G_BULK_SIZE;
l_clast_updated_by_tab(l_contacts_counter) := l_clast_updated_by_tab2(i);
l_clast_update_date_tab(l_contacts_counter) := l_clast_update_date_tab2(i);
l_clast_update_login_tab(l_contacts_counter) := l_clast_update_login_tab2(i);
INSERT INTO okc_contacts (
id, cpl_id, cro_code,
dnz_chr_id, object1_id1, object1_id2,
jtot_object1_code, object_version_number, created_by,
creation_date, last_updated_by, last_update_date,
contact_sequence, last_update_login, attribute_category,
attribute1, attribute2, attribute3,
attribute4, attribute5, attribute6,
attribute7, attribute8, attribute9,
attribute10, attribute11, attribute12,
attribute13, attribute14, attribute15,
security_group_id, start_date, end_date,
primary_yn, resource_class
) VALUES (
l_cid_tab(i), l_ccpl_id_tab(i), l_ccro_code_tab(i),
l_cdnz_chr_id_tab(i), l_cobject1_id1_tab(i), l_cobject1_id2_tab(i),
l_cjtot_object1_code_tab(i), 1, l_created_by,
SYSDATE, l_last_updated_by, SYSDATE,
l_ccontact_sequence_tab(i), l_last_update_login, l_cattribute_category_tab(i),
l_cattribute1_tab(i), l_cattribute2_tab(i), l_cattribute3_tab(i),
l_cattribute4_tab(i), l_cattribute5_tab(i), l_cattribute6_tab(i),
l_cattribute7_tab(i), l_cattribute8_tab(i), l_cattribute9_tab(i),
l_cattribute10_tab(i), l_cattribute11_tab(i), l_cattribute12_tab(i),
l_cattribute13_tab(i), l_cattribute14_tab(i), l_cattribute15_tab(i),
l_csecurity_group_id_tab(i), l_cstart_date_tab(i), l_cend_date_tab(i),
l_cprimary_yn_tab(i),l_cresource_class_tab(i)
);
SELECT
a.id, a.dnz_chr_id, a.cle_id,
a.ppl_id, a.passthru_start_date, a.payout_basis,
a.effective_from, a.effective_to, a.object_version_number,
a.passthru_term, a.payout_basis_formula, a.passthru_stream_type_id
FROM okl_party_payment_hdr a
WHERE a.dnz_chr_id = p_id;
INSERT INTO okl_party_payment_hdr (
id, dnz_chr_id, cle_id,
ppl_id, passthru_start_date, payout_basis,
effective_from, effective_to, created_by,
creation_date, last_updated_by, last_update_date,
last_update_login, object_version_number, passthru_term,
payout_basis_formula, passthru_stream_type_id
) VALUES (
l_phid_tab(i), l_phdnz_chr_id_tab(i), l_phcle_id_tab(i),
l_phppl_id_tab(i), l_phpassthru_start_date_tab(i), l_phpayout_basis_tab(i),
l_pheffective_from_tab(i), l_pheffective_to_tab(i), l_created_by,
SYSDATE, l_last_updated_by, SYSDATE,
l_last_update_login, l_phobject_version_number_tab(i), l_phpassthru_term_tab(i),
l_phpayout_basis_formula_tab(i), l_phpassthru_stre_type_id_tab(i)
);
SELECT
id, object_version_number, cpl_id,
vendor_id, pay_site_id, payment_term_id,
payment_method_code, pay_group_code, 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, payment_hdr_id,
payment_start_date, payment_frequency, remit_days,
disbursement_basis, disbursement_fixed_amount, disbursement_percent,
processing_fee_basis, processing_fee_fixed_amount, processing_fee_percent,
payment_basis
FROM okl_party_payment_dtls
WHERE cpl_id = p_id;
l_pplast_updated_by_tab2 l_pplast_updated_by_type;
l_pplast_update_date_tab2 l_pplast_update_date_type;
l_pplast_update_login_tab2 l_pplast_update_login_type;
l_ppcreated_by_tab2, l_ppcreation_date_tab2, l_pplast_updated_by_tab2,
l_pplast_update_date_tab2, l_pplast_update_login_tab2, l_pppayment_hdr_id_tab2,
l_pppayment_start_date_tab2, l_pppayment_frequency_tab2, l_ppremit_days_tab2,
l_ppdisbursement_basis_tab2, l_ppdisbursement_fixed_am_tab2, l_ppdisbursement_percent_tab2,
l_ppprocessing_fee_basis_tab2, l_ppprocessing_fee_fixedt_tab2, l_ppprocessing_fee_percen_tab2,
l_pppayment_basis_tab2
limit G_BULK_SIZE;
l_pplast_updated_by_tab(l_party_payment_dtls_counter) := l_pplast_updated_by_tab2(i);
l_pplast_update_date_tab(l_party_payment_dtls_counter) := l_pplast_update_date_tab2(i);
l_pplast_update_login_tab(l_party_payment_dtls_counter) := l_pplast_update_login_tab2(i);
INSERT INTO okl_party_payment_dtls (
id, object_version_number, cpl_id,
vendor_id, pay_site_id, payment_term_id,
payment_method_code, pay_group_code, 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, payment_hdr_id,
payment_start_date, payment_frequency, remit_days,
disbursement_basis, disbursement_fixed_amount, disbursement_percent,
processing_fee_basis, processing_fee_fixed_amount, processing_fee_percent,
payment_basis
) VALUES (
l_ppid_tab(i), l_ppobject_version_number_tab(i), l_ppcpl_id_tab(i),
l_ppvendor_id_tab(i), l_pppay_site_id_tab(i), l_pppayment_term_id_tab(i),
l_pppayment_method_code_tab(i), l_pppay_group_code_tab(i), l_ppattribute_category_tab(i),
l_ppattribute1_tab(i), l_ppattribute2_tab(i), l_ppattribute3_tab(i),
l_ppattribute4_tab(i), l_ppattribute5_tab(i), l_ppattribute6_tab(i),
l_ppattribute7_tab(i), l_ppattribute8_tab(i), l_ppattribute9_tab(i),
l_ppattribute10_tab(i), l_ppattribute11_tab(i), l_ppattribute12_tab(i),
l_ppattribute13_tab(i), l_ppattribute14_tab(i), l_ppattribute15_tab(i),
l_created_by, SYSDATE, l_last_updated_by,
SYSDATE, l_last_update_login, l_pppayment_hdr_id_tab(i),
l_pppayment_start_date_tab(i), l_pppayment_frequency_tab(i), l_ppremit_days_tab(i),
l_ppdisbursement_basis_tab(i), l_ppdisbursement_fixed_am_tab(i), l_ppdisbursement_percent_tab(i),
l_ppprocessing_fee_basis_tab(i), l_ppprocessing_fee_fixedt_tab(i), l_ppprocessing_fee_percen_tab(i),
l_pppayment_basis_tab(i)
);
PROCEDURE insert_okc_k_party_roles(p_old_id IN okc_k_headers_b.id%TYPE,
p_new_id IN okc_k_headers_b.id%TYPE) IS
CURSOR c9(p_id okc_k_party_roles_b.dnz_chr_id%TYPE) IS
SELECT
id, chr_id, cle_id,
dnz_chr_id, rle_code, object1_id1,
object1_id2, jtot_object1_code, object_version_number,
created_by, creation_date, last_updated_by,
last_update_date, code, facility,
minority_group_lookup_code, small_business_flag, women_owned_flag,
last_update_login, attribute_category, attribute1,
attribute2, attribute3, attribute4,
attribute5, attribute6, attribute7,
attribute8, attribute9, attribute10,
attribute11, attribute12, attribute13,
attribute14, attribute15, security_group_id,
cpl_id, primary_yn, bill_to_site_use_id,
cust_acct_id, id orig_system_id1
FROM okc_k_party_roles_b
WHERE dnz_chr_id = p_id
AND (
chr_id = chr_id
OR (
NVL(p_copy_lines_yn, 'N') = 'Y'
AND cle_id IS NOT NULL
)
);
TYPE l_last_updated_by_type IS TABLE OF okc_k_party_roles_b.last_updated_by%TYPE INDEX BY BINARY_INTEGER;
TYPE l_last_update_date_type IS TABLE OF okc_k_party_roles_b.last_update_date%TYPE INDEX BY BINARY_INTEGER;
TYPE l_last_update_login_type IS TABLE OF okc_k_party_roles_b.last_update_login%TYPE INDEX BY BINARY_INTEGER;
l_last_updated_by_tab l_last_updated_by_type;
l_last_update_date_tab l_last_update_date_type;
l_last_update_login_tab l_last_update_login_type;
l_last_updated_by_tab2 l_last_updated_by_type;
l_last_update_date_tab2 l_last_update_date_type;
l_last_update_login_tab2 l_last_update_login_type;
l_created_by_tab2, l_creation_date_tab2, l_last_updated_by_tab2,
l_last_update_date_tab2, l_code_tab2, l_facility_tab2,
l_minority_group_lookup_c_tab2, l_small_business_flag_tab2, l_women_owned_flag_tab2,
l_last_update_login_tab2, l_attribute_category_tab2, l_attribute1_tab2,
l_attribute2_tab2, l_attribute3_tab2, l_attribute4_tab2,
l_attribute5_tab2, l_attribute6_tab2, l_attribute7_tab2,
l_attribute8_tab2, l_attribute9_tab2, l_attribute10_tab2,
l_attribute11_tab2, l_attribute12_tab2, l_attribute13_tab2,
l_attribute14_tab2, l_attribute15_tab2, l_security_group_id_tab2,
l_cpl_id_tab2, l_primary_yn_tab2, l_bill_to_site_use_id_tab2,
l_cust_acct_id_tab2, l_orig_system_id1_tab2
limit G_BULK_SIZE;
l_last_updated_by_tab(l_loop_counter) := l_last_updated_by_tab2(i);
l_last_update_date_tab(l_loop_counter) := l_last_update_date_tab2(i);
l_last_update_login_tab(l_loop_counter) := l_last_update_login_tab2(i);
INSERT INTO okc_k_party_roles_b (
id, chr_id, cle_id,
dnz_chr_id, rle_code, object1_id1,
object1_id2, jtot_object1_code, object_version_number,
created_by, creation_date, last_updated_by,
last_update_date, code, facility,
minority_group_lookup_code, small_business_flag, women_owned_flag,
last_update_login, attribute_category, attribute1,
attribute2, attribute3, attribute4,
attribute5, attribute6, attribute7,
attribute8, attribute9, attribute10,
attribute11, attribute12, attribute13,
attribute14, attribute15, security_group_id,
cpl_id, primary_yn, bill_to_site_use_id,
cust_acct_id, orig_system_id1
) VALUES (
l_id_tab(i), l_chr_id_tab(i), l_cle_id_tab(i),
l_dnz_chr_id_tab(i), l_rle_code_tab(i), l_object1_id1_tab(i),
l_object1_id2_tab(i), l_jtot_object1_code_tab(i), 1,
l_created_by, SYSDATE, l_last_updated_by,
SYSDATE, l_code_tab(i), l_facility_tab(i),
l_minority_group_lookup_c_tab(i), l_small_business_flag_tab(i), l_women_owned_flag_tab(i),
l_last_update_login, l_attribute_category_tab(i), l_attribute1_tab(i),
l_attribute2_tab(i), l_attribute3_tab(i), l_attribute4_tab(i),
l_attribute5_tab(i), l_attribute6_tab(i), l_attribute7_tab(i),
l_attribute8_tab(i), l_attribute9_tab(i), l_attribute10_tab(i),
l_attribute11_tab(i), l_attribute12_tab(i), l_attribute13_tab(i),
l_attribute14_tab(i), l_attribute15_tab(i), l_security_group_id_tab(i),
l_cpl_id_tab(i), l_primary_yn_tab(i), l_bill_to_site_use_id_tab(i),
l_cust_acct_id_tab(i), l_orig_system_id1_tab(i)
);
p_token1_value => 'insert_okc_k_party_roles');*/
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Printing insert_okc_k_party_roles:l_id_tab.count=' || l_id_tab.COUNT || ' ...');
END; /* insert_okc_k_party_roles */
SELECT
id, LANGUAGE, source_lang,
sfwt_flag, comments, created_by,
creation_date, last_updated_by, last_update_date,
last_update_login, security_group_id
FROM okc_rule_groups_tl
WHERE id = p_id;
l_rtlast_updated_by_tab2 l_rtlast_updated_by_type;
l_rtlast_update_date_tab2 l_rtlast_update_date_type;
l_rtlast_update_login_tab2 l_rtlast_update_login_type;
l_rtcreation_date_tab2,l_rtlast_updated_by_tab2,l_rtlast_update_date_tab2,
l_rtlast_update_login_tab2, l_rtsecurity_group_id_tab2
limit G_BULK_SIZE;
l_rtlast_updated_by_tab(l_rule_groups_tl_counter) := l_rtlast_updated_by_tab2(i);
l_rtlast_update_date_tab(l_rule_groups_tl_counter) := l_rtlast_update_date_tab2(i);
l_rtlast_update_login_tab(l_rule_groups_tl_counter) := l_rtlast_update_login_tab2(i);
INSERT INTO okc_rule_groups_tl (
id, LANGUAGE, source_lang,
sfwt_flag, comments, created_by,
creation_date, last_updated_by, last_update_date,
last_update_login, security_group_id
) VALUES (
l_rtid_tab(i), l_rtlanguage_tab(i), l_rtsource_lang_tab(i),
'N', l_rtcomments_tab(i), l_created_by,
SYSDATE, l_last_updated_by, SYSDATE,
l_last_update_login, l_rtsecurity_group_id_tab(i)
);
PROCEDURE insert_okc_rules_tl(p_old_id IN okc_rules_b.id%TYPE,
p_new_id okc_rules_b.id%TYPE,
p_flush IN VARCHAR2 ) IS
CURSOR c15(p_id okc_rules_b.id%TYPE) IS
SELECT
id, LANGUAGE, source_lang,
sfwt_flag, comments, text,
created_by, creation_date, last_updated_by,
last_update_date, last_update_login, security_group_id
FROM okc_rules_tl
WHERE id = p_id;
l_trlast_updated_by_tab2 l_trlast_updated_by_type;
l_trlast_update_date_tab2 l_trlast_update_date_type;
l_trlast_update_login_tab2 l_trlast_update_login_type;
l_trcreated_by_tab2, l_trcreation_date_tab2, l_trlast_updated_by_tab2,
l_trlast_update_date_tab2, l_trlast_update_login_tab2, l_trsecurity_group_id_tab2
limit G_BULK_SIZE;
l_trlast_updated_by_tab(l_rules_tl_counter) := l_trlast_updated_by_tab2(i);
l_trlast_update_date_tab(l_rules_tl_counter) := l_trlast_update_date_tab2(i);
l_trlast_update_login_tab(l_rules_tl_counter) := l_trlast_update_login_tab2(i);
INSERT INTO okc_rules_tl (
id, LANGUAGE, source_lang,
sfwt_flag, comments, text,
created_by, creation_date, last_updated_by,
last_update_date, last_update_login, security_group_id
) VALUES (
l_trid_tab(i), l_trlanguage_tab(i), l_trsource_lang_tab(i),
l_trsfwt_flag_tab(i), l_trcomments_tab(i), l_trtext_tab(i),
l_trcreated_by_tab(i), l_trcreation_date_tab(i), l_trlast_updated_by_tab(i),
l_trlast_update_date_tab(i), l_trlast_update_login_tab(i), l_trsecurity_group_id_tab(i)
);
p_token1_value => 'insert_okc_rules_tl');*/
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Printing insert_okc_rules_tl:l_trid_tab.count=' || l_trid_tab.COUNT || ' ...');
END; /* insert_okc_rules_tl */
PROCEDURE insert_okc_rules_b( p_old_id IN okc_rule_groups_b.id%TYPE,
p_new_id IN okc_rule_groups_b.id%TYPE) IS
CURSOR c14(p_id okc_rule_groups_b.id%TYPE) IS
SELECT
a.id, a.rgp_id, a.object1_id1,
a.object2_id1, a.object3_id1, a.object1_id2,
a.object2_id2, a.object3_id2, a.jtot_object1_code,
a.jtot_object2_code, a.jtot_object3_code, a.dnz_chr_id,
a.std_template_yn, a.warn_yn, a.priority,
a.object_version_number, a.created_by, a.creation_date,
a.last_updated_by, a.last_update_date, a.last_update_login,
a.attribute_category, a.attribute1, a.attribute2,
a.attribute3, a.attribute4, a.attribute5,
a.attribute6, a.attribute7, a.attribute8,
a.attribute9, a.attribute10, a.attribute11,
a.attribute12, a.attribute13, a.attribute14,
a.attribute15, a.rule_information_category, a.rule_information1,
a.rule_information2, a.rule_information3, a.rule_information4,
a.rule_information5, a.rule_information6, a.rule_information7,
a.rule_information8, a.rule_information9, a.rule_information10,
a.rule_information11, a.rule_information12, a.rule_information13,
a.rule_information14, a.rule_information15, a.security_group_id,
a.template_yn, a.ans_set_jtot_object_code, a.ans_set_jtot_object_id1,
a.ans_set_jtot_object_id2, a.display_sequence, a.comments
FROM okc_rules_b a,
okc_rule_groups_b rgp,
okc_rg_def_rules rgdef
WHERE a.dnz_chr_id=p_id
AND a.rgp_id=rgp.id
AND rgp.rgd_code=rgdef.rgd_code
AND a.rule_information_category = rgdef.rdf_code
AND (
rgp.chr_id = rgp.chr_id
OR (
NVL(p_copy_lines_yn, 'N') = 'Y'
AND rgp.cle_id IS NOT NULL
)
);
l_rrlast_updated_by_tab2 l_rrlast_updated_by_type;
l_rrlast_update_date_tab2 l_rrlast_update_date_type;
l_rrlast_update_login_tab2 l_rrlast_update_login_type;
l_rrlast_updated_by_tab2, l_rrlast_update_date_tab2, l_rrlast_update_login_tab2,
l_rrattribute_category_tab2, l_rrattribute1_tab2, l_rrattribute2_tab2,
l_rrattribute3_tab2, l_rrattribute4_tab2, l_rrattribute5_tab2,
l_rrattribute6_tab2, l_rrattribute7_tab2, l_rrattribute8_tab2,
l_rrattribute9_tab2, l_rrattribute10_tab2, l_rrattribute11_tab2,
l_rrattribute12_tab2, l_rrattribute13_tab2, l_rrattribute14_tab2,
l_rrattribute15_tab2, l_rrrule_information_cate_tab2, l_rrrule_information1_tab2,
l_rrrule_information2_tab2, l_rrrule_information3_tab2, l_rrrule_information4_tab2,
l_rrrule_information5_tab2, l_rrrule_information6_tab2, l_rrrule_information7_tab2,
l_rrrule_information8_tab2, l_rrrule_information9_tab2, l_rrrule_information10_tab2,
l_rrrule_information11_tab2, l_rrrule_information12_tab2, l_rrrule_information13_tab2,
l_rrrule_information14_tab2, l_rrrule_information15_tab2, l_rrsecurity_group_id_tab2,
l_rrtemplate_yn_tab2, l_rrans_set_jtot_object_c_tab2, l_rrans_set_jtot_object_1_tab2,
l_rrans_set_jtot_object_2_tab2, l_rrdisplay_sequence_tab2, l_rrcomments_tab2
limit G_BULK_SIZE;
l_rrlast_updated_by_tab(l_rules_b_counter) := l_rrlast_updated_by_tab2(i);
l_rrlast_update_date_tab(l_rules_b_counter) := l_rrlast_update_date_tab2(i);
l_rrlast_update_login_tab(l_rules_b_counter) := l_rrlast_update_login_tab2(i);
INSERT INTO okc_rules_b (
id, rgp_id, object1_id1,
object2_id1, object3_id1, object1_id2,
object2_id2, object3_id2, jtot_object1_code,
jtot_object2_code, jtot_object3_code, dnz_chr_id,
std_template_yn, warn_yn, priority,
object_version_number, created_by, creation_date,
last_updated_by, last_update_date, last_update_login,
attribute_category, attribute1, attribute2,
attribute3, attribute4, attribute5,
attribute6, attribute7, attribute8,
attribute9, attribute10, attribute11,
attribute12, attribute13, attribute14,
attribute15, rule_information_category, rule_information1,
rule_information2, rule_information3, rule_information4,
rule_information5, rule_information6, rule_information7,
rule_information8, rule_information9, rule_information10,
rule_information11, rule_information12, rule_information13,
rule_information14, rule_information15, security_group_id,
template_yn, ans_set_jtot_object_code, ans_set_jtot_object_id1,
ans_set_jtot_object_id2, display_sequence, comments
) VALUES (
l_rrid_tab(i), l_rrrgp_id_tab(i), l_rrobject1_id1_tab(i),
l_rrobject2_id1_tab(i), l_rrobject3_id1_tab(i), l_rrobject1_id2_tab(i),
l_rrobject2_id2_tab(i), l_rrobject3_id2_tab(i), l_rrjtot_object1_code_tab(i),
l_rrjtot_object2_code_tab(i), l_rrjtot_object3_code_tab(i), l_rrdnz_chr_id_tab(i),
l_rrstd_template_yn_tab(i), l_rrwarn_yn_tab(i), l_rrpriority_tab(i),
1, l_created_by, SYSDATE,
l_last_updated_by, SYSDATE, l_last_update_login,
l_rrattribute_category_tab(i), l_rrattribute1_tab(i), l_rrattribute2_tab(i),
l_rrattribute3_tab(i), l_rrattribute4_tab(i), l_rrattribute5_tab(i),
l_rrattribute6_tab(i), l_rrattribute7_tab(i), l_rrattribute8_tab(i),
l_rrattribute9_tab(i), l_rrattribute10_tab(i), l_rrattribute11_tab(i),
l_rrattribute12_tab(i), l_rrattribute13_tab(i), l_rrattribute14_tab(i),
l_rrattribute15_tab(i), l_rrrule_information_cate_tab(i), l_rrrule_information1_tab(i),
l_rrrule_information2_tab(i), l_rrrule_information3_tab(i), l_rrrule_information4_tab(i),
l_rrrule_information5_tab(i), l_rrrule_information6_tab(i), l_rrrule_information7_tab(i),
l_rrrule_information8_tab(i), l_rrrule_information9_tab(i), l_rrrule_information10_tab(i),
l_rrrule_information11_tab(i), l_rrrule_information12_tab(i), l_rrrule_information13_tab(i),
l_rrrule_information14_tab(i), l_rrrule_information15_tab(i), l_rrsecurity_group_id_tab(i),
l_rrtemplate_yn_tab(i), l_rrans_set_jtot_object_c_tab(i), l_rrans_set_jtot_object_1_tab(i),
l_rrans_set_jtot_object_2_tab(i), l_rrdisplay_sequence_tab(i), l_rrcomments_tab(i)
);
insert_okc_rules_tl(l_rrid_tab3(i),l_rrid_tab(i), 'Y');
insert_okc_rules_tl(l_rrid_tab3(i),l_rrid_tab(i), 'N');
p_token1_value => 'insert_okc_rules_b');*/
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Printing insert_okc_rules_b:l_rrid_tab.count=' || l_rrid_tab.COUNT || ' ...');
END; /* insert_okc_rules_b */
PROCEDURE insert_okc_rule_groups (p_old_id IN okc_k_headers_b.id%TYPE,
p_new_id IN okc_k_headers_b.id%TYPE) IS
CURSOR c12(p_id NUMBER) IS
SELECT
id, rgd_code, chr_id,
cle_id, dnz_chr_id, parent_rgp_id,
sat_code, object_version_number, rgp_type,
created_by, creation_date, last_updated_by,
last_update_date, last_update_login, attribute_category,
attribute1, attribute2, attribute3,
attribute4, attribute5, attribute6,
attribute7, attribute8, attribute9,
attribute10, attribute11, attribute12,
attribute13, attribute14, attribute15,
security_group_id
FROM okc_rule_groups_b
WHERE dnz_chr_id = p_id
AND (
chr_id = chr_id
OR (
NVL(p_copy_lines_yn, 'N') = 'Y'
AND cle_id IS NOT NULL
)
);
l_rlast_updated_by_tab2 l_rlast_updated_by_type;
l_rlast_update_date_tab2 l_rlast_update_date_type;
l_rlast_update_login_tab2 l_rlast_update_login_type;
l_rcreated_by_tab2, l_rcreation_date_tab2, l_rlast_updated_by_tab2,
l_rlast_update_date_tab2, l_rlast_update_login_tab2, l_rattribute_category_tab2,
l_rattribute1_tab2, l_rattribute2_tab2, l_rattribute3_tab2,
l_rattribute4_tab2, l_rattribute5_tab2, l_rattribute6_tab2,
l_rattribute7_tab2, l_rattribute8_tab2, l_rattribute9_tab2,
l_rattribute10_tab2, l_rattribute11_tab2, l_rattribute12_tab2,
l_rattribute13_tab2, l_rattribute14_tab2, l_rattribute15_tab2,
l_rsecurity_group_id_tab2
limit G_BULK_SIZE;
l_rlast_updated_by_tab(l_rule_groups_b_counter) := l_rlast_updated_by_tab2(i);
l_rlast_update_date_tab(l_rule_groups_b_counter) := l_rlast_update_date_tab2(i);
l_rlast_update_login_tab(l_rule_groups_b_counter) := l_rlast_update_login_tab2(i);
INSERT INTO okc_rule_groups_b (
id, rgd_code, chr_id,
cle_id, dnz_chr_id, parent_rgp_id,
sat_code, object_version_number, rgp_type,
created_by, creation_date, last_updated_by,
last_update_date, last_update_login, attribute_category,
attribute1, attribute2, attribute3,
attribute4, attribute5, attribute6,
attribute7, attribute8, attribute9,
attribute10, attribute11, attribute12,
attribute13, attribute14, attribute15,
security_group_id
) VALUES (
l_rid_tab(i), l_rrgd_code_tab(i), l_rchr_id_tab(i),
l_rcle_id_tab(i), l_rdnz_chr_id_tab(i), l_rparent_rgp_id_tab(i),
l_rsat_code_tab(i), 1, l_rrgp_type_tab(i),
l_created_by, SYSDATE, l_last_updated_by,
SYSDATE, l_last_update_login, l_rattribute_category_tab(i),
l_rattribute1_tab(i), l_rattribute2_tab(i), l_rattribute3_tab(i),
l_rattribute4_tab(i), l_rattribute5_tab(i), l_rattribute6_tab(i),
l_rattribute7_tab(i), l_rattribute8_tab(i), l_rattribute9_tab(i),
l_rattribute10_tab(i), l_rattribute11_tab(i), l_rattribute12_tab(i),
l_rattribute13_tab(i), l_rattribute14_tab(i), l_rattribute15_tab(i),
l_rsecurity_group_id_tab(i)
);
insert_okc_rules_b(p_chr_id, l_copied_id);
p_token1_value => 'insert_okc_rule_groups');*/
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Printing insert_okc_rule_groups:l_rid_tab.count=' || l_rid_tab.COUNT || ' ...');
END; /* insert_okc_rule_groups */
PROCEDURE insert_okc_k_items (p_old_id IN okc_k_headers_b.id%TYPE,
p_new_id IN okc_k_headers_b.id%TYPE) IS
CURSOR c16(p_id NUMBER) IS
SELECT
a.id, a.cle_id, a.chr_id,
a.cle_id_for, a.dnz_chr_id, a.object1_id1,
a.object1_id2, a.jtot_object1_code, a.uom_code,
a.exception_yn, a.number_of_items, a.priced_item_yn,
a.object_version_number, a.created_by, a.creation_date,
a.last_updated_by, a.last_update_date, a.last_update_login,
a.security_group_id, a.upg_orig_system_ref, a.upg_orig_system_ref_id,
a.program_application_id, a.program_id, a.program_update_date,
a.request_id, b.lse_id
FROM okc_k_items a,
okc_k_lines_b b
WHERE a.dnz_chr_id = p_id
AND a.cle_id = b.id;
l_ilast_updated_by_tab2 l_ilast_updated_by_type;
l_ilast_update_date_tab2 l_ilast_update_date_type;
l_ilast_update_login_tab2 l_ilast_update_login_type;
l_iprogram_update_date_tab2 l_iprogram_update_date_type;
l_ilast_updated_by_tab2, l_ilast_update_date_tab2, l_ilast_update_login_tab2,
l_isecurity_group_id_tab2, l_iupg_orig_system_ref_tab2, l_iupg_orig_system_ref_id_tab2,
l_iprogram_application_id_tab2, l_iprogram_id_tab2, l_iprogram_update_date_tab2,
l_irequest_id_tab2, l_ilse_id_tab2
limit G_BULK_SIZE;
l_ilast_updated_by_tab(l_items_counter) := l_ilast_updated_by_tab2(i);
l_ilast_update_date_tab(l_items_counter) := l_ilast_update_date_tab2(i);
l_ilast_update_login_tab(l_items_counter) := l_ilast_update_login_tab2(i);
l_iprogram_update_date_tab(l_items_counter) := l_iprogram_update_date_tab2(i);
INSERT INTO okc_k_items (
id, cle_id, chr_id,
cle_id_for, dnz_chr_id, object1_id1,
object1_id2, jtot_object1_code, uom_code,
exception_yn, number_of_items, priced_item_yn,
object_version_number, created_by, creation_date,
last_updated_by, last_update_date, last_update_login,
security_group_id, upg_orig_system_ref, upg_orig_system_ref_id,
program_application_id, program_id, program_update_date,
request_id
) VALUES (
l_iid_tab(i), l_icle_id_tab(i), l_ichr_id_tab(i),
l_icle_id_for_tab(i), l_idnz_chr_id_tab(i), l_iobject1_id1_tab(i),
l_iobject1_id2_tab(i), l_ijtot_object1_code_tab(i), l_iuom_code_tab(i),
l_iexception_yn_tab(i), l_inumber_of_items_tab(i), l_ipriced_item_yn_tab(i),
1, l_icreated_by_tab(i), l_icreation_date_tab(i),
l_ilast_updated_by_tab(i), l_ilast_update_date_tab(i), l_ilast_update_login_tab(i),
l_isecurity_group_id_tab(i), l_iupg_orig_system_ref_tab(i), l_iupg_orig_system_ref_id_tab(i),
l_iprogram_application_id_tab(i), l_iprogram_id_tab(i), l_iprogram_update_date_tab(i),
l_irequest_id_tab(i)
);
p_token1_value => 'insert_okc_k_items');*/
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Printing insert_okc_k_items:l_iid_tab.count=' || l_iid_tab.COUNT || ' ...');
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_iprogram_update_date_tab('||i||')=' || l_iprogram_update_date_tab(i));
END; /* insert okc_k_items */
PROCEDURE insert_okl_txl_assets_tl(p_old_id IN okl_txl_assets_b.id%TYPE,
p_new_id IN okl_txl_assets_b.id%TYPE,
p_flush IN VARCHAR2 ) IS
CURSOR c19(p_id NUMBER) IS
SELECT
id, LANGUAGE, source_lang,
sfwt_flag, description, created_by,
creation_date, last_updated_by, last_update_date,
last_update_login
FROM okl_txl_assets_tl
WHERE id = p_id;
l_tllast_updated_by_tab2 l_tllast_updated_by_type;
l_tllast_update_date_tab2 l_tllast_update_date_type;
l_tllast_update_login_tab2 l_tllast_update_login_type;
l_tlcreation_date_tab2, l_tllast_updated_by_tab2, l_tllast_update_date_tab2,
l_tllast_update_login_tab2
limit G_BULK_SIZE;
l_tllast_updated_by_tab(l_txl_assets_tl_counter) := l_tllast_updated_by_tab2(i);
l_tllast_update_date_tab(l_txl_assets_tl_counter) := l_tllast_update_date_tab2(i);
l_tllast_update_login_tab(l_txl_assets_tl_counter) := l_tllast_update_login_tab2(i);
INSERT INTO okl_txl_assets_tl (
id, LANGUAGE, source_lang,
sfwt_flag, description, created_by,
creation_date, last_updated_by, last_update_date,
last_update_login
) VALUES (
l_tlid_tab(i), l_tllanguage_tab(i), l_tlsource_lang_tab(i),
l_tlsfwt_flag_tab(i), l_tldescription_tab(i), l_created_by,
SYSDATE, l_last_updated_by, SYSDATE,
l_last_update_login
);
p_token1_value => 'insert_okl_txl_assets_tl');*/
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Printing insert_okl-txl_assets_tl:l_tlid_tab.count=' || l_tlid_tab.COUNT || ' ...');
END; /* insert_okl_txl_assets_tl */
PROCEDURE insert_okl_txd_assets_tl(p_old_id IN okc_k_headers_b.id%TYPE,
p_new_id IN okc_k_headers_b.id%TYPE,
p_flush IN VARCHAR2) IS
CURSOR c21(p_id NUMBER) IS
SELECT
id, LANGUAGE, source_lang,
sfwt_flag, description, created_by,
creation_date, last_updated_by, last_update_date,
last_update_login
FROM okl_txd_assets_tl
WHERE id = p_id
AND id IN (
SELECT b.id FROM okl_txd_assets_b b, okl_txl_assets_b c
WHERE b.id = p_id
AND b.tal_id = c.id
AND c.dnz_khr_id = p_chr_id
);
l_dllast_updated_by_tab2 l_dllast_updated_by_type;
l_dllast_update_date_tab2 l_dllast_update_date_type;
l_dllast_update_login_tab2 l_dllast_update_login_type;
l_dlcreation_date_tab2, l_dllast_updated_by_tab2, l_dllast_update_date_tab2,
l_dllast_update_login_tab2
limit G_BULK_SIZE;
l_dllast_updated_by_tab(l_txd_assets_tl_counter) := l_dllast_updated_by_tab2(i);
l_dllast_update_date_tab(l_txd_assets_tl_counter) := l_dllast_update_date_tab2(i);
l_dllast_update_login_tab(l_txd_assets_tl_counter) := l_dllast_update_login_tab2(i);
INSERT INTO okl_txd_assets_tl (
id, LANGUAGE, source_lang,
sfwt_flag, description, created_by,
creation_date, last_updated_by, last_update_date,
last_update_login
) VALUES (
l_dlid_tab(i), l_dllanguage_tab(i), l_dlsource_lang_tab(i),
l_dlsfwt_flag_tab(i), l_dldescription_tab(i), l_created_by,
SYSDATE, l_last_updated_by, SYSDATE,
l_last_update_login
);
p_token1_value => 'insert_okl_txd_assets_tl');*/
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Printing insert_okl_txd_assets_tl:l_dlid_tab.count=' || l_dlid_tab.COUNT || ' ...');
END; /* insert_okl_txd_assets_tl */
PROCEDURE insert_okl_txd_assets_b(p_old_id IN okc_k_headers_b.id%TYPE,
p_new_id IN okc_k_headers_b.id%TYPE) IS
CURSOR c20(p_id NUMBER) IS
SELECT
id, object_version_number, tal_id,
target_kle_id, line_detail_number, asset_number,
quantity, cost, tax_book,
life_in_months_tax, deprn_method_tax, deprn_rate_tax,
salvage_value, split_percent, inventory_item_id,
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,
currency_code, currency_conversion_type, currency_conversion_rate,
currency_conversion_date
FROM okl_txd_assets_b
WHERE tal_id IN (
SELECT a.id
FROM okl_txl_assets_b a,
okc_k_lines_b b,
okc_k_items c
WHERE a.dnz_khr_id = p_id
AND b.dnz_chr_id = p_id
AND c.dnz_chr_id = p_id
AND b.lse_id = 42
AND a.kle_id = b.id
AND a.kle_id = c.cle_id
AND c.object1_id1 IS NULL
AND c.object1_id2 IS NULL
);
l_dblast_updated_by_tab2 l_dblast_updated_by_type;
l_dblast_update_date_tab2 l_dblast_update_date_type;
l_dblast_update_login_tab2 l_dblast_update_login_type;
l_dblast_updated_by_tab2, l_dblast_update_date_tab2, l_dblast_update_login_tab2,
l_dbcurrency_code_tab2, l_dbcurrency_convers_type_tab2, l_dbcurrency_convers_rate_tab2,
l_dbcurrency_convers_date_tab2
limit G_BULK_SIZE;
l_dblast_updated_by_tab(l_txd_assets_b_counter) := l_dblast_updated_by_tab2(i);
l_dblast_update_date_tab(l_txd_assets_b_counter) := l_dblast_update_date_tab2(i);
l_dblast_update_login_tab(l_txd_assets_b_counter) := l_dblast_update_login_tab2(i);
INSERT INTO okl_txd_assets_b (
id, object_version_number, tal_id,
target_kle_id, line_detail_number, asset_number,
quantity, cost, tax_book,
life_in_months_tax, deprn_method_tax, deprn_rate_tax,
salvage_value, split_percent, inventory_item_id,
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,
currency_code, currency_conversion_type, currency_conversion_rate,
currency_conversion_date
) VALUES (
l_dbid_tab(i), 1, l_dbtal_id_tab(i),
l_dbtarget_kle_id_tab(i), l_dbline_detail_number_tab(i), l_dbasset_number_tab(i),
l_dbquantity_tab(i), l_dbcost_tab(i), l_dbtax_book_tab(i),
l_dblife_in_months_tax_tab(i), l_dbdeprn_method_tax_tab(i), l_dbdeprn_rate_tax_tab(i),
l_dbsalvage_value_tab(i), l_dbsplit_percent_tab(i), l_dbinventory_item_id_tab(i),
l_dbattribute_category_tab(i), l_dbattribute1_tab(i), l_dbattribute2_tab(i),
l_dbattribute3_tab(i), l_dbattribute4_tab(i), l_dbattribute5_tab(i),
l_dbattribute6_tab(i), l_dbattribute7_tab(i), l_dbattribute8_tab(i),
l_dbattribute9_tab(i), l_dbattribute10_tab(i), l_dbattribute11_tab(i),
l_dbattribute12_tab(i), l_dbattribute13_tab(i), l_dbattribute14_tab(i),
l_dbattribute15_tab(i), l_created_by, SYSDATE,
l_last_updated_by, SYSDATE, l_last_update_login,
l_dbcurrency_code_tab(i), l_dbcurrency_convers_type_tab(i), l_dbcurrency_convers_rate_tab(i),
l_dbcurrency_convers_date_tab(i)
);
insert_okl_txd_assets_tl(l_dbid_tab3(i),l_dbid_tab(i), 'Y');
insert_okl_txd_assets_tl(l_dbid_tab3(i),l_dbid_tab(i), 'N');
p_token1_value => 'insert_okl_txd_assets_b');*/
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Printing insert_okl_txd_assets_b:l_dbid_tab.count=' || l_dbid_tab.COUNT || ' ...');
END; /* insert_okl_txd_assets_b */
PROCEDURE insert_okl_txl_assets_b(p_old_id IN okc_k_headers_b.id%TYPE,
p_new_id IN okc_k_headers_b.id%TYPE) IS
CURSOR c18(p_id NUMBER) IS
SELECT
a.id, a.object_version_number, a.tas_id,
a.ilo_id, a.ilo_id_old, a.iay_id,
a.iay_id_new, a.kle_id, a.dnz_khr_id,
a.line_number, a.org_id, a.tal_type,
a.asset_number, a.fa_location_id, a.original_cost,
a.current_units, a.manufacturer_name, a.year_manufactured,
a.supplier_id, a.used_asset_yn, a.tag_number,
a.model_number, a.corporate_book, a.date_purchased,
a.date_delivery, a.in_service_date, a.life_in_months,
a.depreciation_id, a.depreciation_cost, a.deprn_method,
a.deprn_rate, a.salvage_value, a.percent_salvage_value,
a.attribute_category, a.attribute1, a.attribute2,
a.attribute3, a.attribute4, a.attribute5,
a.attribute6, a.attribute7, a.attribute8,
a.attribute9, a.attribute10, a.attribute11,
a.attribute12, a.attribute13, a.attribute14,
a.attribute15, a.created_by, a.creation_date,
a.last_updated_by, a.last_update_date, a.last_update_login,
a.depreciate_yn, a.hold_period_days, a.old_salvage_value,
a.new_residual_value, a.old_residual_value, a.units_retired,
a.cost_retired, a.sale_proceeds, a.removal_cost,
a.dnz_asset_id, a.date_due, a.rep_asset_id,
a.lke_asset_id, a.match_amount, a.split_into_singles_flag,
a.split_into_units, a.currency_code, a.currency_conversion_type,
a.currency_conversion_rate, a.currency_conversion_date, a.asset_key_id,
a.fa_trx_date
FROM okl_txl_assets_b a,
okc_k_lines_b b,
okc_k_items c
WHERE a.dnz_khr_id = p_id
AND b.dnz_chr_id = p_id
AND c.dnz_chr_id = p_id
AND b.lse_id = 42
AND a.kle_id = b.id
AND a.kle_id = c.cle_id
AND c.object1_id1 IS NULL
AND c.object1_id2 IS NULL;
l_tblast_updated_by_tab2 l_tblast_updated_by_type;
l_tblast_update_date_tab2 l_tblast_update_date_type;
l_tblast_update_login_tab2 l_tblast_update_login_type;
l_tblast_updated_by_tab2, l_tblast_update_date_tab2, l_tblast_update_login_tab2,
l_tbdepreciate_yn_tab2, l_tbhold_period_days_tab2, l_tbold_salvage_value_tab2,
l_tbnew_residual_value_tab2, l_tbold_residual_value_tab2, l_tbunits_retired_tab2,
l_tbcost_retired_tab2, l_tbsale_proceeds_tab2, l_tbremoval_cost_tab2,
l_tbdnz_asset_id_tab2, l_tbdate_due_tab2, l_tbrep_asset_id_tab2,
l_tblke_asset_id_tab2, l_tbmatch_amount_tab2, l_tbsplit_into_singles_fl_tab2,
l_tbsplit_into_units_tab2, l_tbcurrency_code_tab2, l_tbcurrency_convers_type_tab2,
l_tbcurrency_convers_rate_tab2, l_tbcurrency_convers_date_tab2, l_tbasset_key_id_tab2,
l_tbfa_trx_date_tab2
limit G_BULK_SIZE;
l_tblast_updated_by_tab(l_txl_assets_b_counter) := l_tblast_updated_by_tab2(i);
l_tblast_update_date_tab(l_txl_assets_b_counter) := l_tblast_update_date_tab2(i);
l_tblast_update_login_tab(l_txl_assets_b_counter) := l_tblast_update_login_tab2(i);
INSERT INTO okl_txl_assets_b (
id, object_version_number, tas_id,
ilo_id, ilo_id_old, iay_id,
iay_id_new, kle_id, dnz_khr_id,
line_number, org_id, tal_type,
asset_number, fa_location_id, original_cost,
current_units, manufacturer_name, year_manufactured,
supplier_id, used_asset_yn, tag_number,
model_number, corporate_book, date_purchased,
date_delivery, in_service_date, life_in_months,
depreciation_id, depreciation_cost, deprn_method,
deprn_rate, salvage_value, percent_salvage_value,
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,
depreciate_yn, hold_period_days, old_salvage_value,
new_residual_value, old_residual_value, units_retired,
cost_retired, sale_proceeds, removal_cost,
dnz_asset_id, date_due, rep_asset_id,
lke_asset_id, match_amount, split_into_singles_flag,
split_into_units, currency_code, currency_conversion_type,
currency_conversion_rate, currency_conversion_date, asset_key_id,
fa_trx_date
) VALUES (
l_tbid_tab(i), 1, l_tbtas_id_tab(i),
l_tbilo_id_tab(i), l_tbilo_id_old_tab(i), l_tbiay_id_tab(i),
l_tbiay_id_new_tab(i), l_tbkle_id_tab(i), l_tbdnz_khr_id_tab(i),
l_tbline_number_tab(i), l_tborg_id_tab(i), p_trans_type,
l_tbasset_number_tab(i), l_tbfa_location_id_tab(i), l_tboriginal_cost_tab(i),
l_tbcurrent_units_tab(i), l_tbmanufacturer_name_tab(i), l_tbyear_manufactured_tab(i),
l_tbsupplier_id_tab(i), l_tbused_asset_yn_tab(i), l_tbtag_number_tab(i),
l_tbmodel_number_tab(i), l_tbcorporate_book_tab(i), l_tbdate_purchased_tab(i),
l_tbdate_delivery_tab(i), l_tbin_service_date_tab(i), l_tblife_in_months_tab(i),
l_tbdepreciation_id_tab(i), l_tbdepreciation_cost_tab(i), l_tbdeprn_method_tab(i),
l_tbdeprn_rate_tab(i), l_tbsalvage_value_tab(i), l_tbpercent_salvage_value_tab(i),
l_tbattribute_category_tab(i), l_tbattribute1_tab(i), l_tbattribute2_tab(i),
l_tbattribute3_tab(i), l_tbattribute4_tab(i), l_tbattribute5_tab(i),
l_tbattribute6_tab(i), l_tbattribute7_tab(i), l_tbattribute8_tab(i),
l_tbattribute9_tab(i), l_tbattribute10_tab(i), l_tbattribute11_tab(i),
l_tbattribute12_tab(i), l_tbattribute13_tab(i), l_tbattribute14_tab(i),
l_tbattribute15_tab(i), l_created_by, SYSDATE,
l_last_updated_by, SYSDATE, l_last_update_login,
l_tbdepreciate_yn_tab(i), l_tbhold_period_days_tab(i), l_tbold_salvage_value_tab(i),
l_tbnew_residual_value_tab(i), l_tbold_residual_value_tab(i), l_tbunits_retired_tab(i),
l_tbcost_retired_tab(i), l_tbsale_proceeds_tab(i), l_tbremoval_cost_tab(i),
l_tbdnz_asset_id_tab(i), l_tbdate_due_tab(i), l_tbrep_asset_id_tab(i),
l_tblke_asset_id_tab(i), l_tbmatch_amount_tab(i), l_tbsplit_into_singles_fl_tab(i),
l_tbsplit_into_units_tab(i), l_tbcurrency_code_tab(i), l_tbcurrency_convers_type_tab(i),
l_tbcurrency_convers_rate_tab(i), l_tbcurrency_convers_date_tab(i), l_tbasset_key_id_tab(i),
NULL
);
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting okl_txl_assets_b done...' || TO_CHAR(SYSDATE,'HH24:MI:SS'));
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting okl_txl_assets_tl...' || TO_CHAR(SYSDATE,'HH24:MI:SS'));
insert_okl_txl_assets_tl(l_tbid_tab3(i), l_tbid_tab(i), 'Y');
insert_okl_txl_assets_tl(l_tbid_tab3(i), l_tbid_tab(i), 'N');
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting okl_txd_assets_b ' || TO_CHAR(SYSDATE,'HH24:MI:SS'));
insert_okl_txd_assets_b(p_chr_id, l_copied_id);
p_token1_value => 'insert_okl_txl_assets_b');*/
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Printing insert_okl_txl_assets_b:l_tbid_tab.count=' || l_tbid_tab.COUNT || ' ...');
END; /* insert_okl_txl_assets_b */
PROCEDURE insert_okl_trx_assets(p_old_id IN okc_k_headers_b.id%TYPE,
p_new_id IN okc_k_headers_b.id%TYPE) IS
CURSOR c17(p_id NUMBER) IS
SELECT
id, ica_id, tas_type,
object_version_number, 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, tsu_code, try_id,
date_trans_occurred, trans_number, comments,
req_asset_id, total_match_amount, org_id,legal_entity_id
FROM okl_trx_assets
WHERE id IN
(SELECT a.tas_id FROM okl_txl_assets_b a,
okc_k_lines_b b,
okc_k_items c
WHERE a.dnz_khr_id = p_id
AND b.dnz_chr_id = p_id
AND c.dnz_chr_id = p_id
AND b.lse_id = 42
AND a.kle_id = b.id
AND a.kle_id = c.cle_id
AND c.object1_id1 IS NULL
AND c.object1_id2 IS NULL);
l_tlast_updated_by_tab2 l_tlast_updated_by_type;
l_tlast_update_date_tab2 l_tlast_update_date_type;
l_tlast_update_login_tab2 l_tlast_update_login_type;
l_tcreation_date_tab2, l_tlast_updated_by_tab2, l_tlast_update_date_tab2,
l_tlast_update_login_tab2, l_ttsu_code_tab2, l_ttry_id_tab2,
l_tdate_trans_occurred_tab2, l_ttrans_number_tab2, l_tcomments_tab2,
l_treq_asset_id_tab2, l_ttotal_match_amount_tab2, l_torg_id_tab2,l_tlegal_entity_id_tab2
limit G_BULK_SIZE;
l_tlast_updated_by_tab(l_trx_assets_counter) := l_tlast_updated_by_tab2(i);
l_tlast_update_date_tab(l_trx_assets_counter) := l_tlast_update_date_tab2(i);
l_tlast_update_login_tab(l_trx_assets_counter) := l_tlast_update_login_tab2(i);
INSERT INTO okl_trx_assets (
id, ica_id, tas_type,
object_version_number, 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, tsu_code, try_id,
date_trans_occurred, trans_number, comments,
req_asset_id, total_match_amount, org_id,legal_entity_id
,transaction_date
) VALUES (
l_tid_tab(i), l_tica_id_tab(i), p_trans_type,
1, l_tattribute_category_tab(i), l_tattribute1_tab(i),
l_tattribute2_tab(i), l_tattribute3_tab(i), l_tattribute4_tab(i),
l_tattribute5_tab(i), l_tattribute6_tab(i), l_tattribute7_tab(i),
l_tattribute8_tab(i), l_tattribute9_tab(i), l_tattribute10_tab(i),
l_tattribute11_tab(i), l_tattribute12_tab(i), l_tattribute13_tab(i),
l_tattribute14_tab(i), l_tattribute15_tab(i), l_created_by,
SYSDATE, l_last_updated_by, SYSDATE,
l_last_update_login, 'ENTERED', l_ttry_id_tab(i),
SYSDATE, okl_trn_seq.NEXTVAL, l_tcomments_tab(i),
l_treq_asset_id_tab(i), l_ttotal_match_amount_tab(i), l_torg_id_tab(i),l_tlegal_entity_id_tab(i)
,SYSDATE
);
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting okl_txl_assets_b...' || TO_CHAR(SYSDATE,'HH24:MI:SS'));
insert_okl_txl_assets_b(p_chr_id, l_copied_id);
p_token1_value => 'insert_okl_trx_assets');*/
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Printing insert_okl_trx_assets:l_tid_tab.count=' || l_tid_tab.COUNT || ' ...');
END; /* insert_okl_trx_assets */
PROCEDURE insert_okl_trx_assets_2(p_old_id IN okc_k_headers_b.id%TYPE,
p_new_id IN okc_k_headers_b.id%TYPE) IS
CURSOR c17_2(p_id NUMBER) IS
SELECT
id, ica_id, tas_type,
object_version_number, 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, tsu_code, try_id,
date_trans_occurred, trans_number, comments,
req_asset_id, total_match_amount, org_id,legal_entity_id
FROM okl_trx_assets
WHERE id IN
(
SELECT tas_id
FROM okl_txl_itm_insts b
WHERE kle_id IN
(SELECT a.id
FROM okc_k_lines_b a,
okc_k_items c
WHERE a.dnz_chr_id = p_id
AND c.dnz_chr_id = p_id
AND c.cle_id = a.id
AND a.lse_id = 45
AND c.object1_id1 IS NULL
AND c.object1_id2 IS NULL)
);
l_t2last_updated_by_tab2 l_t2last_updated_by_type;
l_t2last_update_date_tab2 l_t2last_update_date_type;
l_t2last_update_login_tab2 l_t2last_update_login_type;
l_t2creation_date_tab2, l_t2last_updated_by_tab2, l_t2last_update_date_tab2,
l_t2last_update_login_tab2, l_t2tsu_code_tab2, l_t2try_id_tab2,
l_t2date_trans_occurred_tab2, l_t2trans_number_tab2, l_t2comments_tab2,
l_t2req_asset_id_tab2, l_t2total_match_amount_tab2, l_t2org_id_tab2,l_t2legal_entity_id_tab2
limit G_BULK_SIZE;
l_t2last_updated_by_tab(l_trx_assets_counter2) := l_t2last_updated_by_tab2(i);
l_t2last_update_date_tab(l_trx_assets_counter2) := l_t2last_update_date_tab2(i);
l_t2last_update_login_tab(l_trx_assets_counter2) := l_t2last_update_login_tab2(i);
INSERT INTO okl_trx_assets (
id, ica_id, tas_type,
object_version_number, 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, tsu_code, try_id,
date_trans_occurred, trans_number, comments,
req_asset_id, total_match_amount, org_id,legal_entity_id
,transaction_date
) VALUES (
l_t2id_tab(i), l_t2ica_id_tab(i), p_trans_type,
1, l_t2attribute_category_tab(i), l_t2attribute1_tab(i),
l_t2attribute2_tab(i), l_t2attribute3_tab(i), l_t2attribute4_tab(i),
l_t2attribute5_tab(i), l_t2attribute6_tab(i), l_t2attribute7_tab(i),
l_t2attribute8_tab(i), l_t2attribute9_tab(i), l_t2attribute10_tab(i),
l_t2attribute11_tab(i), l_t2attribute12_tab(i), l_t2attribute13_tab(i),
l_t2attribute14_tab(i), l_t2attribute15_tab(i), l_created_by,
SYSDATE, l_last_updated_by, SYSDATE,
l_last_update_login, 'ENTERED', l_t2try_id_tab(i),
SYSDATE, okl_trn_seq.NEXTVAL, l_t2comments_tab(i),
l_t2req_asset_id_tab(i), l_t2total_match_amount_tab(i), l_t2org_id_tab(i),l_t2legal_entity_id_tab(i)
,SYSDATE
);
p_token1_value => 'insert_okl_trx_assets_2');*/
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Printing insert_okl_trx_assets_2:l_t2id_tab.count=' || l_t2id_tab.COUNT || ' ...');
END; /* insert_okl_trx_assets_2 */
SELECT TO_CHAR(OKL_IBN_SEQ.NEXTVAL)
FROM dual;
PROCEDURE insert_okl_txl_itm_insts(p_old_id IN okc_k_headers_b.id%TYPE,
p_new_id IN okc_k_headers_b.id%TYPE) IS
CURSOR c22(p_id NUMBER) IS
SELECT
p.id, p.object_version_number, p.tas_id,
p.tal_id, p.kle_id, p.tal_type,
p.line_number, p.instance_number_ib, p.object_id1_new,
p.object_id2_new, p.jtot_object_code_new, p.object_id1_old,
p.object_id2_old, p.jtot_object_code_old, p.inventory_org_id,
p.serial_number, p.mfg_serial_number_yn, p.inventory_item_id,
p.inv_master_org_id, p.attribute_category, p.attribute1,
p.attribute2, p.attribute3, p.attribute4,
p.attribute5, p.attribute6, p.attribute7,
p.attribute8, p.attribute9, p.attribute10,
p.attribute11, p.attribute12, p.attribute13,
p.attribute14, p.attribute15, p.created_by,
p.creation_date, p.last_updated_by, p.last_update_date,
p.last_update_login, p.dnz_cle_id, p.instance_id,
p.selected_for_split_flag, p.asd_id
FROM okl_txl_itm_insts p
WHERE p.kle_id IN
(
SELECT a.id
FROM okc_k_lines_b a,
okc_k_items c
WHERE a.dnz_chr_id = p_id
AND c.dnz_chr_id = p_id
AND c.cle_id = a.id
AND a.lse_id = 45
AND c.object1_id1 IS NULL
AND c.object1_id2 IS NULL
);
l_tilast_updated_by_tab2 l_tilast_updated_by_type;
l_tilast_update_date_tab2 l_tilast_update_date_type;
l_tilast_update_login_tab2 l_tilast_update_login_type;
l_tiselected_for_split_fl_tab2 l_tiselected_for_split_fl_type;
l_ticreation_date_tab2, l_tilast_updated_by_tab2, l_tilast_update_date_tab2,
l_tilast_update_login_tab2, l_tidnz_cle_id_tab2, l_tiinstance_id_tab2,
l_tiselected_for_split_fl_tab2, l_tiasd_id_tab2
limit G_BULK_SIZE;
l_tilast_updated_by_tab(l_txl_itm_insts_counter) := l_tilast_updated_by_tab2(i);
l_tilast_update_date_tab(l_txl_itm_insts_counter) := l_tilast_update_date_tab2(i);
l_tilast_update_login_tab(l_txl_itm_insts_counter) := l_tilast_update_login_tab2(i);
l_tiselected_for_split_fl_tab(l_txl_itm_insts_counter) := l_tiselected_for_split_fl_tab2(i);
INSERT INTO okl_txl_itm_insts (
id, object_version_number, tas_id,
tal_id, kle_id, tal_type,
line_number, instance_number_ib, object_id1_new,
object_id2_new, jtot_object_code_new, object_id1_old,
object_id2_old, jtot_object_code_old, inventory_org_id,
serial_number, mfg_serial_number_yn, inventory_item_id,
inv_master_org_id, 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, dnz_cle_id, instance_id,
selected_for_split_flag, asd_id
) VALUES (
l_tiid_tab(i), 1, l_titas_id_tab(i),
l_tital_id_tab(i), l_tikle_id_tab(i), p_trans_type,
l_tiline_number_tab(i), l_tiinstance_number_ib_tab(i), l_tiobject_id1_new_tab(i),
l_tiobject_id2_new_tab(i), l_tijtot_object_code_new_tab(i), l_tiobject_id1_old_tab(i),
l_tiobject_id2_old_tab(i), l_tijtot_object_code_old_tab(i), l_tiinventory_org_id_tab(i),
l_tiserial_number_tab(i), l_timfg_serial_number_yn_tab(i), l_tiinventory_item_id_tab(i),
l_tiinv_master_org_id_tab(i), l_tiattribute_category_tab(i), l_tiattribute1_tab(i),
l_tiattribute2_tab(i), l_tiattribute3_tab(i), l_tiattribute4_tab(i),
l_tiattribute5_tab(i), l_tiattribute6_tab(i), l_tiattribute7_tab(i),
l_tiattribute8_tab(i), l_tiattribute9_tab(i), l_tiattribute10_tab(i),
l_tiattribute11_tab(i), l_tiattribute12_tab(i), l_tiattribute13_tab(i),
l_tiattribute14_tab(i), l_tiattribute15_tab(i), l_created_by,
SYSDATE, l_last_updated_by, SYSDATE,
l_last_update_login, l_tidnz_cle_id_tab(i), l_tiinstance_id_tab(i),
l_tiselected_for_split_fl_tab(i), l_tiasd_id_tab(i)
);
p_token1_value => 'insert_okl_txl_itm_insts');*/
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Printing insert_okl_txl_itm_insts:l_tiid_tab.count=' || l_tiid_tab.COUNT || ' ...');
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tiselected_for_split_fl_tab('||i||')=' || l_tiselected_for_split_fl_tab(i));
END; /* insert_okl_txl_itm_insts */
SELECT 'Y'
FROM fa_methods
WHERE method_code = p_deprn_method
AND life_in_months = p_life_in_months
AND life_in_months IS NOT NULL;
SELECT 'Y'
FROM fa_flat_rates ffr,
fa_methods fm
WHERE fm.method_code = p_deprn_method
AND ffr.method_id = fm.method_id
AND ffr.adjusted_rate = p_rate
AND ffr.adjusting_rate = 0;
PROCEDURE insert_okl_trx_assets_3(p_old_id IN okc_k_headers_b.id%TYPE,
p_new_id IN okc_k_headers_b.id%TYPE) IS
CURSOR c27(p_id NUMBER) IS
SELECT
fa.asset_id ID1,
'#' ID2,
fa.asset_number NAME,
fat.description DESCRIPTION,
fa.Asset_Id ASSET_ID,
fa.Asset_Number ASSET_NUMBER,
fb.book_type_code BOOK_TYPE_CODE,
fb.life_in_months LIFE_IN_MONTHS,
fb.original_cost ORIGINAL_COST,
fb.cost COST,
fb.adjusted_cost ADJUSTED_COST,
fa.tag_number TAG_NUMBER,
fa.current_units CURRENT_UNITS,
fa.serial_number SERIAL_NUMBER,
fb.reval_ceiling REVAL_CEILING,
fa.new_used NEW_USED,
fb.date_placed_in_service IN_SERVICE_DATE,
fa.manufacturer_name MANUFACTURER_NAME,
fa.model_number MODEL_NUMBER,
fa.asset_type ASSET_TYPE,
fb.salvage_value SALVAGE_VALUE,
fb.percent_salvage_value PERCENT_SALVAGE_VALUE,
fa.asset_category_id DEPRECIATION_CATEGORY,
fb.deprn_start_date DEPR_START_DATE,
fb.deprn_method_code DEPRN_METHOD_CODE,
fb.rate_adjustment_factor RATE_ADJUSTMENT_FACTOR,
fb.basic_rate BASIC_RATE,
fb.adjusted_rate ADJUSTED_RATE,
fb.Date_effective START_DATE_ACTIVE,
fb.Date_ineffective END_DATE_ACTIVE,
DECODE(SIGN(TRUNC(SYSDATE)-NVL(fb.date_effective,TRUNC(SYSDATE))),-1,'I', DECODE(SIGN(TRUNC(SYSDATE) - NVL(fb.date_ineffective,TRUNC(SYSDATE))), 1,'I','A ')) STATUS,
NULL PRIMARY_UOM_CODE,
fb.recoverable_cost RECOVERABLE_COST,
fbc.org_id ORG_ID,
fbc.set_of_books_id SET_OF_BOOKS_ID,
fa.property_type_code PROPERTY_TYPE_CODE,
fa.property_1245_1250_code PROPERTY_1245_1250_CODE,
fa.in_use_flag IN_USE_FLAG,
fa.owned_leased OWNED_LEASED,
fa.inventorial INVENTORIAL,
fa.ASSET_KEY_CCID ASSET_KEY_CCID,
fbc.book_class book_class ,
b.id,
b.cle_id
FROM FA_BOOK_CONTROLS FBC,
FA_BOOKS FB,
FA_ADDITIONS_TL FAT,
FA_ADDITIONS_B FA ,
okc_k_items c,
okc_k_lines_b b
WHERE
fbc.book_type_code = fb.book_type_code
AND NVL(fbc.date_ineffective,SYSDATE+1) > SYSDATE
AND fb.asset_id = fa.asset_id
AND fb.transaction_header_id_out IS NULL
AND fat.asset_id = fa.asset_id
AND fat.LANGUAGE = USERENV('LANG')
AND fa.asset_id = TO_CHAR(c.object1_id1) --for LSE_ID = 42
AND c.cle_id = b.id
AND c.object1_id1 IS NOT NULL
AND c.object1_id2 IS NOT NULL
AND b.lse_id = 42
AND b.dnz_chr_id=p_id
AND c.dnz_chr_id=p_id
AND fbc.book_class IN ('CORPORATE', 'TAX')
ORDER BY b.cle_id;
SELECT language_code
FROM fnd_languages
WHERE installed_flag = 'B';
SELECT language_code
FROM fnd_languages
WHERE installed_flag IN ('B','I');
SELECT id
FROM okl_trx_types_tl
WHERE name = 'Internal Asset Creation'
AND LANGUAGE = 'US';
SELECT location_id
FROM fa_distribution_history
WHERE asset_id = p_asset_id
AND book_type_code = p_book_type_code
AND transaction_header_id_out IS NULL
AND ROWNUM < 2;
SELECT contract_number
FROM OKC_K_HEADERS_B
WHERE id = p_ctr_id1;
INSERT INTO okl_trx_assets (
id, tas_type, object_version_number,
tsu_code, try_id, date_trans_occurred,
created_by, creation_date, last_updated_by,
last_update_date, last_update_login, trans_number,legal_entity_id
,transaction_date
) VALUES (
l_t3id_tab(i), p_trans_type, 1,
'ENTERED', l_try_id, SYSDATE, -- AKP: populate try_id properly
l_created_by, SYSDATE, l_last_updated_by,
SYSDATE, l_last_update_login, okl_trn_seq.NEXTVAL,l_legal_entity_id
,SYSDATE
);
INSERT INTO okl_txl_assets_b (
id, object_version_number, tas_id,
kle_id, dnz_khr_id, line_number,
asset_number, tal_type, original_cost,
depreciation_cost, current_units, manufacturer_name,
used_asset_yn, tag_number, model_number,
corporate_book, in_service_date, depreciation_id,
deprn_method, deprn_rate, life_in_months,
salvage_value, percent_salvage_value, asset_key_id,
fa_trx_date, created_by, creation_date,
last_updated_by, last_update_date, last_update_login,
fa_location_id, currency_code, currency_conversion_type,
currency_conversion_rate, currency_conversion_date, year_manufactured,
fa_cost
) VALUES (
l_tb2id_tab(i), 1, l_tb2tas_id_tab(i),
l_tb2kle_id_tab(i), l_tb2dnz_khr_id_tab(i), l_tb2line_number_tab(i),
l_tb2asset_number_tab(i), l_tb2tal_type_tab(i), l_tb2original_cost_tab(i),
l_tb2depreciation_cost_tab(i), l_tb2current_units_tab(i), l_tb2manufacturer_name_tab(i),
l_tb2used_asset_yn_tab(i), l_tb2tag_number_tab(i), l_tb2model_number_tab(i),
l_tb2corporate_book_tab(i), l_tb2in_service_date_tab(i), l_tb2depreciation_id_tab(i),
l_tb2deprn_method_tab(i), l_tb2deprn_rate_tab(i), l_tb2life_in_months_tab(i),
l_tb2salvage_value_tab(i), l_tb2percent_salvage_value_tab(i), l_tb2asset_key_id_tab(i),
l_tb2fa_trx_date_tab(i), l_created_by, SYSDATE,
l_last_updated_by, SYSDATE, l_last_update_login,
l_tb2fa_location_id_tab(i), l_contract_currency, l_conversion_type,
l_conversion_rate, l_conversion_rate_date, l_tb2year_manufactured_tab(i),
l_tb2fa_cost_tab(i)
);
INSERT INTO okl_txl_assets_tl (
id, LANGUAGE, source_lang,
sfwt_flag, description, created_by,
creation_date, last_updated_by, last_update_date,
last_update_login
) VALUES (
l_tl2id_tab(i), l_tl2language_tab(i), l_base_language,
'N', l_tl2description_tab(i), l_created_by,
SYSDATE, l_last_updated_by, SYSDATE,
l_last_update_login
);
INSERT INTO okl_txd_assets_b (
id, object_version_number, tal_id,
asset_number, line_detail_number, quantity,
cost, tax_book, salvage_value,
deprn_method_tax, life_in_months_tax, deprn_rate_tax,
created_by, creation_date, last_updated_by,
last_update_date, last_update_login, currency_code,
currency_conversion_type, currency_conversion_rate, currency_conversion_date
) VALUES (
l_db2id_tab(i), 1, l_db2tal_id_tab(i),
l_db2asset_number_tab(i), l_db2line_detail_number_tab(i), l_db2quantity_tab(i),
l_db2cost_tab(i), l_db2tax_book_tab(i), l_db2salvage_value_tab(i),
l_db2deprn_method_tax_tab(i), l_db2life_in_months_tax_tab(i), l_db2deprn_rate_tax_tab(i),
l_created_by, SYSDATE, l_last_updated_by,
SYSDATE, l_last_update_login, l_contract_currency,
l_conversion_type, l_conversion_rate, l_conversion_rate_date
);
INSERT INTO okl_txd_assets_tl (
id, LANGUAGE, source_lang,
sfwt_flag, description, created_by,
creation_date, last_updated_by, last_update_date,
last_update_login
) VALUES (
l_dl2id_tab(i), l_dl2language_tab(i), l_base_language,
'N', l_dl2description_tab(i), l_created_by,
SYSDATE, l_last_updated_by, SYSDATE,
l_last_update_login
);
END; /* insert okl_trx_assets_3 */
PROCEDURE insert_okc_rg_party_roles(p_old_id IN okc_k_headers_b.id%TYPE,
p_new_id IN okc_k_headers_b.id%TYPE) IS
CURSOR c25(p_id NUMBER) IS
SELECT
a.id, a.rgp_id, a.rrd_id,
a.cpl_id, a.dnz_chr_id, a.object_version_number,
a.created_by, a.creation_date, a.last_updated_by,
a.last_update_date, a.last_update_login, a.security_group_id
FROM okc_rg_party_roles a,
okc_rule_groups_b b
WHERE a.rgp_id = b.id
AND b.dnz_chr_id = p_id
AND (
b.chr_id = b.chr_id
OR (
NVL(p_trans_type, 'N') = 'Y'
AND b.cle_id IS NOT NULL
)
);
l_glast_updated_by_tab2 l_glast_updated_by_type;
l_glast_update_date_tab2 l_glast_update_date_type;
l_glast_update_login_tab2 l_glast_update_login_type;
l_gcreated_by_tab2, l_gcreation_date_tab2, l_glast_updated_by_tab2,
l_glast_update_date_tab2, l_glast_update_login_tab2, l_gsecurity_group_id_tab2
limit G_BULK_SIZE;
l_glast_updated_by_tab(l_rg_party_roles_counter) := l_glast_updated_by_tab2(i);
l_glast_update_date_tab(l_rg_party_roles_counter) := l_glast_update_date_tab2(i);
l_glast_update_login_tab(l_rg_party_roles_counter) := l_glast_update_login_tab2(i);
INSERT INTO okc_rg_party_roles (
id, rgp_id, rrd_id,
cpl_id, dnz_chr_id, object_version_number,
created_by, creation_date, last_updated_by,
last_update_date, last_update_login, security_group_id
) VALUES (
l_gid_tab(i), l_grgp_id_tab(i), l_grrd_id_tab(i),
l_gcpl_id_tab(i), l_gdnz_chr_id_tab(i), l_gobject_version_number_tab(i),
l_created_by, SYSDATE, l_last_updated_by,
SYSDATE, l_last_update_login, l_gsecurity_group_id_tab(i)
);
END; /* insert_okc_rg_party_roles */
PROCEDURE insert_okl_supp_invoice_dtls(p_old_id IN okc_k_headers_b.id%TYPE)
IS
CURSOR c26(p_id NUMBER) IS
SELECT
a.id, a.object_version_number, a.cle_id,
a.fa_cle_id, a.invoice_number, a.date_invoiced,
a.date_due, a.shipping_address_id1, a.shipping_address_id2,
a.shipping_address_code, a.attribute_category, a.attribute1,
a.attribute2, a.attribute3, a.attribute4,
a.attribute5, a.attribute6, a.attribute7,
a.attribute8, a.attribute9, a.attribute10,
a.attribute11, a.attribute12, a.attribute13,
a.attribute14, a.attribute15, a.created_by,
a.creation_date, a.last_updated_by, a.last_update_date,
a.last_update_login
FROM okl_supp_invoice_dtls a,
okc_k_lines_b b
WHERE b.dnz_chr_id = p_id
AND (
( a.cle_id = b.id AND b.lse_id IN (34,44) )
-- Bug (duplicate supp invoice dtls lines because of the OR condition)
--OR
--( a.fa_cle_id = b.id AND b.lse_id = 42 )
);
TYPE l_oslast_updated_by_type is table of okl_supp_invoice_dtls.last_updated_by%TYPE index by binary_integer;
TYPE l_oslast_update_date_type is table of okl_supp_invoice_dtls.last_update_date%TYPE index by binary_integer;
TYPE l_oslast_update_login_type is table of okl_supp_invoice_dtls.last_update_login%TYPE index by binary_integer;
l_oslast_updated_by_tab l_oslast_updated_by_type;
l_oslast_update_date_tab l_oslast_update_date_type;
l_oslast_update_login_tab l_oslast_update_login_type;
l_oslast_updated_by_tab2 l_oslast_updated_by_type;
l_oslast_update_date_tab2 l_oslast_update_date_type;
l_oslast_update_login_tab2 l_oslast_update_login_type;
l_oscreation_date_tab2, l_oslast_updated_by_tab2, l_oslast_update_date_tab2,
l_oslast_update_login_tab2
limit G_BULK_SIZE;
l_oslast_updated_by_tab(l_supp_invoice_dtls_counter) := l_oslast_updated_by_tab2(i);
l_oslast_update_date_tab(l_supp_invoice_dtls_counter) := l_oslast_update_date_tab2(i);
l_oslast_update_login_tab(l_supp_invoice_dtls_counter) := l_oslast_update_login_tab2(i);
INSERT INTO okl_supp_invoice_dtls (
id, object_version_number, cle_id,
fa_cle_id, invoice_number, date_invoiced,
date_due, shipping_address_id1, shipping_address_id2,
shipping_address_code, 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
) VALUES (
l_osid_tab(i), 1, l_oscle_id_tab(i),
l_osfa_cle_id_tab(i), l_osinvoice_number_tab(i), l_osdate_invoiced_tab(i),
l_osdate_due_tab(i), l_osshipping_address_id1_tab(i), l_osshipping_address_id2_tab(i),
l_osshipping_address_code_tab(i), l_osattribute_category_tab(i), l_osattribute1_tab(i),
l_osattribute2_tab(i), l_osattribute3_tab(i), l_osattribute4_tab(i),
l_osattribute5_tab(i), l_osattribute6_tab(i), l_osattribute7_tab(i),
l_osattribute8_tab(i), l_osattribute9_tab(i), l_osattribute10_tab(i),
l_osattribute11_tab(i), l_osattribute12_tab(i), l_osattribute13_tab(i),
l_osattribute14_tab(i), l_osattribute15_tab(i), l_created_by,
SYSDATE, l_last_updated_by, SYSDATE,
l_last_update_login
);
SELECT psu.party_site_use_id
FROM HZ_PARTY_SITE_USES psu,
HZ_PARTY_SITES ps
WHERE ps.party_site_id = psu.party_site_id
AND psu.site_use_type = 'INSTALL_AT'
AND psu.party_site_id = p_party_site_id;
SELECT psu.party_site_use_id
FROM hz_party_site_uses psu,
hz_party_sites ps
WHERE psu.party_site_id = ps.party_site_id
AND psu.site_use_type = 'INSTALL_AT'
AND ps.location_id = p_location_id;
SELECT SUBSTR(arp_addr_label_pkg.format_address(NULL,hl.address1,hl.address2,hl.address3, hl.address4,hl.city,hl.county,hl.state,hl.province,hl.postal_code,NULL,hl.country,NULL, NULL,NULL,NULL,NULL,NULL,NULL,'n','n',80,1,1),1,80)
FROM hz_locations hl,
hz_party_sites ps
WHERE hl.location_id = ps.location_id
AND ps.party_site_id = pty_site_id;
SELECT SUBSTR(arp_addr_label_pkg.format_address(NULL,hl.address1,hl.address2,hl.address3, hl.address4,hl.city,hl.county,hl.state,hl.province,hl.postal_code,NULL,hl.country,NULL, NULL,NULL,NULL,NULL,NULL,NULL,'n','n',80,1,1),1,80)
FROM hz_locations hl
WHERE hl.location_id = loc_id;
PROCEDURE insert_okl_txl_itm_insts2(p_old_id IN okc_k_headers_b.id%TYPE,
p_new_id IN okc_k_headers_b.id%TYPE) IS
CURSOR c28(p_id NUMBER) IS
SELECT csi.inventory_item_id,
csi.inv_master_organization_id,
csi.instance_number,
b.id,
b.cle_id,
c.object1_id1,
csi.location_type_code,
csi.location_id,
csi.serial_number
FROM okx_install_items_v csi,
okc_k_lines_b b,
okc_k_items c
WHERE b.dnz_chr_id = p_id
AND b.lse_id = 45
AND c.dnz_chr_id = p_id
AND b.id = c.cle_id
AND csi.id1 = TO_NUMBER(c.object1_id1);
SELECT id
FROM okc_k_lines_b
WHERE cle_id = p_id
AND lse_id = p_lse_id;
select c.object1_id2
from okc_k_items c,
okc_k_lines_b b
where c.cle_id = b.id
and b.id = p_id
and b.lse_id = p_lse_id;*/
INSERT INTO okl_trx_assets (
id, tas_type, object_version_number,
tsu_code, try_id, date_trans_occurred,
created_by, creation_date, last_updated_by,
last_update_date, last_update_login, trans_number
,transaction_date
) VALUES (
l_t4id_tab(i), p_trans_type, 1,
'ENTERED', l_try_id, SYSDATE, -- AKP: populate try_id properly
l_created_by, SYSDATE, l_last_updated_by,
SYSDATE, l_last_update_login, okl_trn_seq.NEXTVAL
,SYSDATE
);
INSERT INTO okl_txl_itm_insts (
id, object_version_number, tas_id,
tal_type, kle_id, line_number,
instance_number_ib, object_id1_new, object_id2_new,
jtot_object_code_new, dnz_cle_id, inventory_item_id,
inv_master_org_id, inventory_org_id, created_by,
creation_date, last_updated_by, last_update_date,
last_update_login, serial_number, mfg_serial_number_yn
) VALUES (
l_ti2id_tab(i), 1, l_ti2tas_id_tab(i),
p_trans_type, l_ti2kle_id_tab(i), l_ti2line_number_tab(i),
l_ti2instance_number_ib_tab(i), l_ti2object_id1_new_tab(i), l_ti2object_id2_new_tab(i),
l_ti2jtot_object_code_new_tab(i), l_ti2dnz_cle_id_tab(i), l_ti2inventory_item_id_tab(i),
l_ti2inv_master_org_id_tab(i), l_ti2inventory_org_id_tab(i), l_created_by,
SYSDATE, l_last_updated_by, SYSDATE,
l_last_update_login, l_ti2serial_number_tab(i), l_ti2mfg_serial_number_yn_tab(i)
);
p_token1_value => 'insert_okl_txl_itm_instst2');*/
END; /* insert_okl_txl_itm_insts2 */
SELECT okc_k_headers_b_s.NEXTVAL INTO l_copied_id FROM dual;
INSERT INTO okc_k_headers_b (
ID, CONTRACT_NUMBER, AUTHORING_ORG_ID,
CONTRACT_NUMBER_MODIFIER, CHR_ID_RESPONSE, CHR_ID_AWARD,
CHR_ID_RENEWED, INV_ORGANIZATION_ID, STS_CODE,
QCL_ID, SCS_CODE, TRN_CODE,
CURRENCY_CODE, ARCHIVED_YN, DELETED_YN,
TEMPLATE_YN, CHR_TYPE, OBJECT_VERSION_NUMBER,
CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
CUST_PO_NUMBER_REQ_YN, PRE_PAY_REQ_YN, CUST_PO_NUMBER,
DPAS_RATING, TEMPLATE_USED, DATE_APPROVED,
DATETIME_CANCELLED, AUTO_RENEW_DAYS, DATE_ISSUED,
DATETIME_RESPONDED, RFP_TYPE, KEEP_ON_MAIL_LIST,
SET_ASIDE_PERCENT, RESPONSE_COPIES_REQ, DATE_CLOSE_PROJECTED,
DATETIME_PROPOSED, DATE_SIGNED, DATE_TERMINATED,
DATE_RENEWED, START_DATE, END_DATE,
BUY_OR_SELL, ISSUE_OR_RECEIVE, LAST_UPDATE_LOGIN,
ESTIMATED_AMOUNT, ATTRIBUTE_CATEGORY, LAST_UPDATE_DATE,
ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3,
ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6,
ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9,
ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12,
ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15,
SECURITY_GROUP_ID, CHR_ID_RENEWED_TO, ESTIMATED_AMOUNT_RENEWED,
CURRENCY_CODE_RENEWED, UPG_ORIG_SYSTEM_REF, UPG_ORIG_SYSTEM_REF_ID,
APPLICATION_ID, RESOLVED_UNTIL, ORIG_SYSTEM_SOURCE_CODE,
ORIG_SYSTEM_ID1, ORIG_SYSTEM_REFERENCE1, PROGRAM_APPLICATION_ID,
PROGRAM_ID, PROGRAM_UPDATE_DATE, REQUEST_ID,
PRICE_LIST_ID, PRICING_DATE, TOTAL_LINE_LIST_PRICE,
SIGN_BY_DATE, USER_ESTIMATED_AMOUNT, GOVERNING_CONTRACT_YN,
CONVERSION_TYPE, CONVERSION_RATE,
CONVERSION_RATE_DATE, CONVERSION_EURO_RATE, CUST_ACCT_ID,
BILL_TO_SITE_USE_ID, INV_RULE_ID, RENEWAL_TYPE_CODE,
RENEWAL_NOTIFY_TO, RENEWAL_END_DATE, SHIP_TO_SITE_USE_ID,
PAYMENT_TERM_ID,
ORG_ID --MOAC
) VALUES (
l_copied_id, l_contract_number, c1rec.AUTHORING_ORG_ID,
NULL, NULL, NULL,
c1rec.CHR_ID_RENEWED, c1rec.INV_ORGANIZATION_ID, l_sts_code,
c1rec.QCL_ID, c1rec.SCS_CODE, NULL,
c1rec.CURRENCY_CODE, 'N', 'N',
'N', c1rec.CHR_TYPE, 1,
l_created_by, SYSDATE, l_last_updated_by,
c1rec.CUST_PO_NUMBER_REQ_YN, c1rec.PRE_PAY_REQ_YN, c1rec.CUST_PO_NUMBER,
c1rec.DPAS_RATING, DECODE(c1rec.template_yn,'Y',c1rec.CONTRACT_NUMBER,NULL), NULL,
NULL, c1rec.AUTO_RENEW_DAYS, NULL,
NULL, NULL, c1rec.KEEP_ON_MAIL_LIST,
NULL, NULL, NULL,
NULL, c1rec.DATE_SIGNED, NULL,
NULL, c1rec.START_DATE, c1rec.END_DATE,
c1rec.BUY_OR_SELL, c1rec.ISSUE_OR_RECEIVE, l_last_update_login,
c1rec.ESTIMATED_AMOUNT, c1rec.ATTRIBUTE_CATEGORY, SYSDATE,
c1rec.ATTRIBUTE1, c1rec.ATTRIBUTE2, c1rec.ATTRIBUTE3,
c1rec.ATTRIBUTE4, c1rec.ATTRIBUTE5, c1rec.ATTRIBUTE6,
c1rec.ATTRIBUTE7, c1rec.ATTRIBUTE8, c1rec.ATTRIBUTE9,
c1rec.ATTRIBUTE10, c1rec.ATTRIBUTE11, c1rec.ATTRIBUTE12,
c1rec.ATTRIBUTE13, c1rec.ATTRIBUTE14, c1rec.ATTRIBUTE15,
c1rec.SECURITY_GROUP_ID, c1rec.CHR_ID_RENEWED_TO, c1rec.ESTIMATED_AMOUNT_RENEWED,
c1rec.CURRENCY_CODE_RENEWED, c1rec.UPG_ORIG_SYSTEM_REF, c1rec.UPG_ORIG_SYSTEM_REF_ID,
c1rec.APPLICATION_ID, c1rec.RESOLVED_UNTIL, l_orig_system_source_code,
--decode(p_trans_type, 'RBK', c1rec.orig_system_id1, c1rec.ID), null, c1rec.PROGRAM_APPLICATION_ID,
c1rec.ID, NULL, c1rec.PROGRAM_APPLICATION_ID,
c1rec.PROGRAM_ID, c1rec.PROGRAM_UPDATE_DATE, c1rec.REQUEST_ID,
c1rec.PRICE_LIST_ID, c1rec.PRICING_DATE, c1rec.TOTAL_LINE_LIST_PRICE,
c1rec.SIGN_BY_DATE, NULL, c1rec.GOVERNING_CONTRACT_YN,
c1rec.CONVERSION_TYPE, c1rec.CONVERSION_RATE,
c1rec.CONVERSION_RATE_DATE, c1rec.CONVERSION_EURO_RATE, c1rec.CUST_ACCT_ID,
c1rec.BILL_TO_SITE_USE_ID, c1rec.INV_RULE_ID, c1rec.RENEWAL_TYPE_CODE,
c1rec.RENEWAL_NOTIFY_TO, c1rec.RENEWAL_END_DATE, c1rec.SHIP_TO_SITE_USE_ID,
c1rec.PAYMENT_TERM_ID,
c1rec.AUTHORING_ORG_ID --MOAC
);
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'ERROR during insert into okc_k_headers_b...');
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'ERROR during insert into create_k_history...');
INSERT INTO okc_k_vers_numbers (
chr_id, major_version, minor_version,
object_version_number, created_by, creation_date,
last_updated_by, last_update_date, last_update_login
--security_group_id
) VALUES (
l_copied_id, 0, 1,
1, l_created_by, SYSDATE,
l_last_updated_by, SYSDATE, l_last_update_login
--FND_GLOBAL.SECURITY_GROUP_ID
);
insert_okc_k_headers_tl(p_chr_id, l_copied_id);
insert_okl_k_headers(p_chr_id, l_copied_id);
insert_okl_slctd_optns(p_chr_id, l_copied_id);
INSERT INTO okc_governances (
ID, DNZ_CHR_ID, CHR_ID,
CLE_ID, CHR_ID_REFERRED, CLE_ID_REFERRED,
ISA_AGREEMENT_ID, COPIED_ONLY_YN, OBJECT_VERSION_NUMBER,
CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, SECURITY_GROUP_ID
) VALUES (
okc_p_util.raw_to_number(sys_guid()), l_copied_id, l_copied_id,
c2rec.CLE_ID, c2rec.CHR_ID_REFERRED, c2rec.CLE_ID_REFERRED,
c2rec.ISA_AGREEMENT_ID, c2rec.COPIED_ONLY_YN, c2rec.OBJECT_VERSION_NUMBER,
l_created_by, SYSDATE, l_last_updated_by,
SYSDATE, l_last_update_login, c2rec.SECURITY_GROUP_ID
) RETURNING ID INTO l_gov_id;
insert into okc_governances_h (
ID, DNZ_CHR_ID, CHR_ID,
CLE_ID, CHR_ID_REFERRED, CLE_ID_REFERRED,
ISA_AGREEMENT_ID, MAJOR_VERSION, OBJECT_VERSION_NUMBER,
COPIED_ONLY_YN, CREATED_BY, CREATION_DATE,
LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN,
SECURITY_GROUP_ID
) VALUES (
l_gov_id, l_copied_id, l_copied_id,
c3rec.CLE_ID, c3rec.CHR_ID_REFERRED, c3rec.CLE_ID_REFERRED,
c3rec.ISA_AGREEMENT_ID, c3rec.MAJOR_VERSION, c3rec.OBJECT_VERSION_NUMBER,
c3rec.COPIED_ONLY_YN, c3rec.CREATED_BY, SYSDATE,
c3rec.LAST_UPDATED_BY, SYSDATE, c3rec.LAST_UPDATE_LOGIN,
c3rec.SECURITY_GROUP_ID
);
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting okc_k_party_roles...' || TO_CHAR(SYSDATE,'HH24:MI:SS'));
insert_okc_k_party_roles(p_chr_id, l_copied_id); -- _b _tl contacts okl_party_payment_dtls
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting okc_rule_groups...' || TO_CHAR(SYSDATE,'HH24:MI:SS'));
insert_okc_rule_groups(p_chr_id, l_copied_id); -- _b,_tl and rules(_b,_tl)
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting okc_rg_party_roles...' || TO_CHAR(SYSDATE,'HH24:MI:SS'));
insert_okc_rg_party_roles(p_chr_id, l_copied_id);
l_created_by_tab2,l_creation_date_tab2,l_last_updated_by_tab2,
l_last_update_date_tab2,l_hidden_ind_tab2,l_price_negotiated_tab2,
l_price_level_ind_tab2,l_price_unit_tab2,l_price_unit_percent_tab2,
l_invoice_line_level_ind_tab2,l_dpas_rating_tab2,l_template_used_tab2,
l_price_type_tab2,l_currency_code_tab2,l_last_update_login_tab2,
l_date_terminated_tab2,l_start_date_tab2,l_end_date_tab2,
l_attribute_category_tab2,l_attribute1_tab2,l_attribute2_tab2,
l_attribute3_tab2,l_attribute4_tab2,l_attribute5_tab2,
l_attribute6_tab2,l_attribute7_tab2,l_attribute8_tab2,
l_attribute9_tab2,l_attribute10_tab2,l_attribute11_tab2,
l_attribute12_tab2,l_attribute13_tab2,l_attribute14_tab2,
l_attribute15_tab2,l_security_group_id_tab2,l_cle_id_renewed_to_tab2,
l_price_negotiated_renewed_tb2,l_currency_code_renewed_tab2,l_upg_orig_system_ref_tab2,
l_upg_orig_system_ref_id_tab2,l_date_renewed_tab2,l_orig_system_source_code_tab2,
l_orig_system_id1_tab2,l_orig_system_reference1_tab2,l_program_application_id_tab2,
l_program_id_tab2,l_program_update_date_tab2,l_request_id_tab2,
l_price_list_id_tab2,l_price_list_line_id_tab2,l_line_list_price_tab2,
l_item_to_price_yn_tab2,l_pricing_date_tab2,l_price_basis_yn_tab2,
l_config_header_id_tab2,l_config_revision_number_tab2,l_config_complete_yn_tab2,
l_config_valid_yn_tab2,l_config_top_model_line_id_tb2,l_config_item_type_tab2,
l_config_item_id_tab2,l_service_item_yn_tab2,l_ph_pricing_type_tab2,
l_ph_price_break_basis_tab2,l_ph_min_qty_tab2,l_ph_min_amt_tab2,
l_ph_qp_reference_id_tab2,l_ph_value_tab2,l_ph_enforce_price_list_yn_tb2,
l_ph_adjustment_tab2,l_ph_integrated_with_qp_tab2,l_cust_acct_id_tab2,
l_bill_to_site_use_id_tab2,l_inv_rule_id_tab2,l_line_renewal_type_code_tab2,
l_ship_to_site_use_id_tab2,l_payment_term_id_tab2 , l_fee_type_tab2,
l_name_tab2
limit G_BULK_SIZE;
l_last_updated_by_tab(l_counter) := l_last_updated_by_tab2(i);
l_last_update_date_tab(l_counter) := l_last_update_date_tab2(i);
l_last_update_login_tab(l_counter) := l_last_update_login_tab2(i);
l_program_update_date_tab(l_counter) := l_program_update_date_tab2(i);
l_delete_id_tab(l_delete_counter) := l_id_tab(l_counter);
l_delete_counter := l_delete_counter + 1;
l_delete_id_tab(l_delete_counter) := l_id_tab(l_counter);
l_delete_counter := l_delete_counter + 1;
/*print('Before update values...');
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Update Started ...' || TO_CHAR(SYSDATE,'HH24:MI:SS'));
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Update Finished ...' || TO_CHAR(SYSDATE,'HH24:MI:SS'));
print('After update values...');
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Before Inserting okc_k_lines_b...' || TO_CHAR(SYSDATE,'HH24:MI:SS'));
INSERT INTO okc_k_lines_b (
id, line_number, chr_id,
cle_id, cle_id_renewed, dnz_chr_id,
display_sequence, sts_code, trn_code,
lse_id, exception_yn, object_version_number,
created_by, creation_date, last_updated_by,
last_update_date, hidden_ind, price_negotiated,
price_level_ind, price_unit, price_unit_percent,
invoice_line_level_ind, dpas_rating, template_used,
price_type, currency_code, last_update_login,
date_terminated, start_date, end_date,
attribute_category, attribute1, attribute2,
attribute3, attribute4, attribute5,
attribute6, attribute7, attribute8,
attribute9, attribute10, attribute11,
attribute12, attribute13, attribute14,
attribute15, security_group_id, cle_id_renewed_to,
price_negotiated_renewed, currency_code_renewed, upg_orig_system_ref,
upg_orig_system_ref_id, date_renewed, orig_system_source_code,
orig_system_id1, orig_system_reference1, program_application_id,
program_id, program_update_date, request_id,
price_list_id, price_list_line_id, line_list_price,
item_to_price_yn, pricing_date, price_basis_yn,
config_header_id, config_revision_number, config_complete_yn,
config_valid_yn, config_top_model_line_id, config_item_type,
config_item_id, service_item_yn, ph_pricing_type,
ph_price_break_basis, ph_min_qty, ph_min_amt,
ph_qp_reference_id, ph_value, ph_enforce_price_list_yn,
ph_adjustment, ph_integrated_with_qp, cust_acct_id,
bill_to_site_use_id, inv_rule_id, line_renewal_type_code,
ship_to_site_use_id, payment_term_id)
VALUES (
l_id_tab(i), l_line_number_tab(i), l_chr_id_tab(i),
l_cle_id_tab(i), l_cle_id_renewed_tab(i), l_dnz_chr_id_tab(i),
l_display_sequence_tab(i), 'ENTERED', l_trn_code_tab(i), -- Bug 4959361 NULL,
l_lse_id_tab(i), l_exception_yn_tab(i), 1,
l_created_by, SYSDATE, l_last_updated_by,
SYSDATE, l_hidden_ind_tab(i), l_price_negotiated_tab(i),
l_price_level_ind_tab(i), l_price_unit_tab(i), l_price_unit_percent_tab(i),
l_invoice_line_level_ind_tab(i), l_dpas_rating_tab(i), l_template_used_tab(i),
l_price_type_tab(i), l_currency_code_tab(i), l_last_update_login,
-- Bug 4959361 NULL, l_start_date_tab(i), l_end_date_tab(i),
l_date_terminated_tab(i), l_start_date_tab(i), l_end_date_tab(i),
l_attribute_category_tab(i), l_attribute1_tab(i), l_attribute2_tab(i),
l_attribute3_tab(i), l_attribute4_tab(i), l_attribute5_tab(i),
l_attribute6_tab(i), l_attribute7_tab(i), l_attribute8_tab(i),
l_attribute9_tab(i), l_attribute10_tab(i), l_attribute11_tab(i),
l_attribute12_tab(i), l_attribute13_tab(i), l_attribute14_tab(i),
l_attribute15_tab(i), l_security_group_id_tab(i), l_cle_id_renewed_to_tab(i),
l_price_negotiated_renewed_tab(i), l_currency_code_renewed_tab(i), l_upg_orig_system_ref_tab(i),
l_upg_orig_system_ref_id_tab(i), NULL, 'OKC_LINE',
l_id_tab3(i), l_orig_system_reference1_tab(i), l_program_application_id_tab(i),
l_program_id_tab(i), l_program_update_date_tab(i), l_request_id_tab(i),
l_price_list_id_tab(i), l_price_list_line_id_tab(i), l_line_list_price_tab(i),
l_item_to_price_yn_tab(i), l_pricing_date_tab(i), l_price_basis_yn_tab(i),
l_config_header_id_tab(i), l_config_revision_number_tab(i), l_config_complete_yn_tab(i),
l_config_valid_yn_tab(i), l_config_top_model_line_id_tab(i), l_config_item_type_tab(i),
l_config_item_id_tab(i), l_service_item_yn_tab(i), l_ph_pricing_type_tab(i),
l_ph_price_break_basis_tab(i), l_ph_min_qty_tab(i), l_ph_min_amt_tab(i),
NULL, l_ph_value_tab(i), l_ph_enforce_price_list_yn_tab(i),
l_ph_adjustment_tab(i), NULL, l_cust_acct_id_tab(i),
l_bill_to_site_use_id_tab(i), l_inv_rule_id_tab(i), l_line_renewal_type_code_tab(i),
l_ship_to_site_use_id_tab(i), l_payment_term_id_tab(i)
);
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'ERROR during insert into okc_k_lines_b...');
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting okc_k_lines_tl...' || TO_CHAR(SYSDATE,'HH24:MI:SS'));
insert_okc_k_lines_tl_old(l_id_tab3(i), l_id_tab(i), 'Y');
insert_okc_k_lines_tl_old(l_id_tab3(i), l_id_tab(i), 'N');
insert_okc_k_lines_tl(p_chr_id);
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting okl_k_lines...' || TO_CHAR(SYSDATE,'HH24:MI:SS'));
insert_okl_k_lines;
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting okc_k_party_roles...' || TO_CHAR(SYSDATE,'HH24:MI:SS'));
insert_okc_k_party_roles(p_chr_id, l_copied_id); -- _b _tl contacts okl_party_payment_dtls
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting okc_rule_groups...' || TO_CHAR(SYSDATE,'HH24:MI:SS'));
insert_okc_rule_groups(p_chr_id, l_copied_id); -- _b,_tl and rules(_b,_tl)
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting okc_rg_party_roles...' || TO_CHAR(SYSDATE,'HH24:MI:SS'));
insert_okc_rg_party_roles(p_chr_id, l_copied_id);
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting okc_k_items...' || TO_CHAR(SYSDATE,'HH24:MI:SS'));
insert_okc_k_items(p_chr_id, l_copied_id);
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting okl_trx_assets...' || TO_CHAR(SYSDATE,'HH24:MI:SS'));
insert_okl_trx_assets(p_chr_id, l_copied_id);
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting okl_txl_itm_insts...' || TO_CHAR(SYSDATE,'HH24:MI:SS'));
insert_okl_trx_assets_2(p_chr_id, l_copied_id);
insert_okl_txl_itm_insts(p_chr_id, l_copied_id);
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting okl_trx_assets BOOKED...' || TO_CHAR(SYSDATE,'HH24:MI:SS'));
insert_okl_trx_assets_3(p_chr_id, l_copied_id);
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting okl_txl_itm_insts BOOKED...' || TO_CHAR(SYSDATE,'HH24:MI:SS'));
insert_okl_txl_itm_insts2(p_chr_id, l_copied_id);
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Delete started ' || TO_CHAR(SYSDATE,'HH24:MI:SS'));
IF (l_delete_counter > 1) THEN
IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_delete_counter=' || l_delete_counter);
FOR i IN l_delete_id_tab.first..l_delete_id_tab.last
LOOP
IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_delete_id_tab(' || i || ')=' || l_delete_id_tab(i));
select count(1) into l_line_count -- 5207066
FROM okc_k_lines_b
where id = l_delete_id_tab(i);
Okl_Contract_Pub.delete_contract_line(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_line_id => l_delete_id_tab(i));
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Update sts_code started ' || TO_CHAR(SYSDATE,'HH24:MI:SS'));
UPDATE okc_k_lines_b
SET sts_code = l_entered_sts_code_tab(i) -- Bug 4872258
--SET sts_code = 'ENTERED'
WHERE id = l_entered_id_tab(i);
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting okl_supp_invoice_dtls...' || TO_CHAR(SYSDATE,'HH24:MI:SS'));
insert_okl_supp_invoice_dtls(p_chr_id);
l_business_event_name := G_WF_EVT_CONTRACT_TERM_UPDATED;
l_business_event_name := G_WF_EVT_ASSET_FILING_UPDATED;
l_business_event_name := G_WF_EVT_ASSET_PROPTAX_UPDATED;
l_business_event_name := G_WF_EVT_SERV_PASS_UPDATED;
l_business_event_name := G_WF_EVT_FEE_PASS_UPDATED;
l_business_event_name := G_WF_EVT_SERV_FEXP_UPDATED;
l_business_event_name := G_WF_EVT_FEE_EXP_UPDATED;
SELECT cle.id top_line
FROM okc_subclasses_b scs,
okc_subclass_top_line stl,
okc_line_styles_b lse,
okc_k_lines_b cle
WHERE cle.dnz_chr_id = p_dnz_chr_id
AND cle.cle_id is null
and cle.chr_id = cle.dnz_chr_id
AND cle.lse_id = lse.id
AND lse.lse_parent_id is null
AND lse.lse_type = 'TLS'
AND lse.id = stl.lse_Id
AND stl.scs_code = scs.code
AND scs.cls_code = 'OKL';
SELECT cle.id top_line
FROM okc_line_styles_b lse,
okc_k_lines_b cle
WHERE cle.dnz_chr_id = p_dnz_chr_id
AND cle.cle_id is null
and cle.chr_id = cle.dnz_chr_id
AND cle.lse_id = lse.id
AND lse.lse_type = 'TLS';
Select chr.date_signed
From okc_k_headers_b chr
where
( (chr.id = p_chr_id and p_chr_id is not null)
or (p_chr_id is null and p_chr_modifier is null and p_chr_number is not null and chr.contract_number = p_chr_number )
or (p_chr_id is null and p_chr_modifier is not null and p_chr_number is not null and chr.contract_number_modifier = p_chr_modifier and chr.contract_number = p_chr_number)
);
select cle.id
from OKC_LINE_STYLES_B lse,
OKC_K_LINES_B cle
where lse.lty_code = 'INSURANCE'
and lse.id = cle.lse_id
and lse.lse_type = 'TLS'
and lse.application_id = 540
and cle.chr_id = p_chr_id;
Select scs_code,
orig_system_id1
From okc_k_headers_b
where id = p_chr_id;
Select sts_code
From OKC_K_HEADERS_B
Where id = pchrid;
select txdb.id
from okl_txd_assets_b txdb,
okl_txl_assets_b txlb,
okc_k_lines_b cleb,
okc_line_styles_b lseb
where txdb.tax_book = p_book_type_code
and txdb.tal_id = txlb.id
and txlb.kle_id = cleb.id
and cleb.lse_id = lseb.id
and lseb.lty_code = 'FIXED_ASSET'
and cleb.dnz_chr_id = p_chr_id;
select stsb.ste_code,
parent_chrb.scs_code
from okc_statuses_b stsb,
okc_k_headers_b parent_chrb
where stsb.code = parent_chrb.sts_code
and parent_chrb.id = p_chr_id;
OKL_OKC_MIGRATION_PVT.update_contract_header(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_restricted_update => OKC_API.G_FALSE,
p_chrv_rec => l_chrv_rec,
x_chrv_rec => lx_chrv_rec);
--Bug# 3923883 : Physically delete all the rollover lines
IF(p_trans_type is not null AND p_trans_type = 'CFA') THEN
cleanup_rollover_lines(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_Status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_chr_id => x_chr_id);
OKL_CONTRACT_PUB.delete_contract_line(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_line_id => l_ins_top_line_id);
delete_yields(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_chr_id => x_chr_id,
--Bug# 3973640
p_trans_type => p_trans_type);
OKL_TXD_ASSETS_PUB.delete_txd_asset_Def(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_adpv_tbl => l_adpv_tbl);
Okl_Contract_Pub.update_contract_header(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_chrv_rec => l_chrv_rec,
p_khrv_rec => lp_khrv_rec,
x_chrv_rec => lx_chrv_rec,
x_khrv_rec => lx_khrv_rec);