Search Results contract_tradein

Overview

OKL_SEEDED_FUNCTIONS_PVT is a private PL/SQL package in the APPS schema that belongs to the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite. It is classified as a PVT (private) API, meaning it is intended for internal consumption by other ETRM packages rather than direct invocation by external customers or forms. The package encapsulates the seeded financial calculation functions that the leasing application uses to derive monetary and accounting values across contracts and contract lines. Its central role is to compute contract-level and line-level financial measures — residual values, rents, capitalized amounts, discounts, and depreciation-related figures — consistently so that downstream processes (funding, loss provisioning, cure calculations, financial extraction, and workflow) all draw from a single authoritative source of calculation logic.

Key Procedures and Functions

The package exposes 129 documented functions and procedures, organized as parallel contract-level and line-level calculators. Representative members include:

• CONTRACT_SUM_OF_RENTS — aggregates the total of rents payable across a contract.
• CONTRACT_INCOME — derives income recognized on the contract.
• LINE_RESIDUAL_VALUE / CONTRACT_RESIDUAL_VALUE — compute residual values at line and contract granularity.
• LINE_OEC / CONTRACT_OEC — calculate original equipment cost.
• LINE_TRADEIN / CONTRACT_TRADEIN — determine trade-in values.
• LINE_CAPITAL_REDUCTION / CONTRACT_CAPITAL_REDUCTION — compute capital reduction amounts.
• LINE_FEES_CAPITALIZED / CONTRACT_FEES_CAPITALIZED — identify fees eligible for capitalization.
• LINE_SERVICE_CAPITALIZED — captures capitalized service amounts.
• INVESTOR_ACCOUNT_AMOUNT — returns amounts attributable to the investor.
• LINE_CAPITALIZED_INTEREST / CONTRACT_CAPITALIZED_INTEREST — calculate interest eligible for capitalization.
• LINE_DISCOUNT / CONTRACT_DISCOUNT — derive discount values.
• CONTRACT_AMORTIZED_EXPENSES — returns amortized expense figures.
• CONTRACT_AMOUNT_PREFUNDED — determines amounts received prior to funding.

The dual structure (LINE_* versus CONTRACT_*) lets callers request a value scoped either to an individual contract line or rolled up to the full contract.

Tables Accessed

The package reads from a broad set of ETRM and Oracle Financials tables through APPS synonyms:

• OKC_K_HEADERS_B, OKC_K_HEADERS_ALL_B, OKC_K_LINES_B, OKC_K_LINES_V, OKC_K_ITEMS — contract header and line definition data that anchors every calculation.
• OKC_GOVERNANCES, OKC_RULES_B, OKC_RULE_GROUPS_B, OKC_LINE_STYLES_B, OKC_K_PARTY_ROLES_B — governance, rules, line styles, and party roles that influence which calculation applies.
• AR_PAYMENT_SCHEDULES, AR_PAYMENT_SCHEDULES_ALL — payment schedule rows used to derive rents, income, and prefunded amounts.
• FA_ADDITIONS, FA_BOOKS, FA_BOOK_CONTROLS, FA_RETIREMENTS — fixed asset data used for depreciation, residual, and OEC calculations.

It also references OKL_API and SYS.STANDARD for error handling and standard utilities.

Usage Notes

Because OKL_SEEDED_FUNCTIONS_PVT is a private package, it is not called directly from Oracle Forms or concurrent programs by end users. Instead it is referenced by eleven other APPS packages, including OKL_FUNDING_PVT, OKL_FUNDING_WF, OKL_CURE_CALC_PVT, OKL_LOSS_PROV_PVT, OKL_MAINTAIN_FEE_PVT, OKL_OPI_PVT, OKL_CNTRCT_FIN_EXTRACT_PVT, OKL_K_LINE_FIN_EXT_PVT, OKL_CO_WF, the OKL_CREDITLINES_UV view, and IEX_CASE_INFO_PUB. These callers invoke the appropriate seeded function during funding, provisioning, cure evaluation, or financial extraction. Customizations should invoke the calling public APIs rather than OKL_SEEDED_FUNCTIONS_PVT directly, since the private package signature is not guaranteed across patches. When troubleshooting lease financial figures in 12.1.1 or 12.2.2, this package is a key starting point for tracing how a displayed amount was derived.