Search Results okl_qua_ref_seq

Overview

OKL_LEASE_QUOTE_ASSET_PVT is a private PL/SQL package body in the APPS schema that implements the asset-side business logic for Oracle Lease and Finance Management (OKL), the EBS module supporting lease quotation, origination, and contract management. The package is classified as a PVT (private) API, meaning its procedures are not published for direct external invocation and are instead consumed by the public OKL APIs and the lease quotation user interface. Its principal responsibility is to create, duplicate, update, and delete lease quote assets and their associated cost adjustments within the OKL_LEASE_QUOTES_B quote header structure, and to drive subsidy validation and subsidy amount calculation against those assets. In Oracle EBS 12.1.1 and 12.2.2 the package remains VALID and is a core element of the lease quotation asset layer, orchestrating calls to OKL_ASS_PVT, OKL_ASO_PVT, OKL_CFL_PVT, OKL_CFO_PVT, OKL_CDJ_PVT, OKL_SUBSIDIES_B and OKL_EXECUTE_FORMULA_PUB to align quote assets with cash flow, subsidy and formula evaluation engines.

Key Procedures and Functions

The documented 15 procedures and functions divide into asset lifecycle, adjustment lifecycle, and subsidy evaluation groups.

• CREATE_ASSET, DUPLICATE_ASSET, UPDATE_ASSET, DELETE_ASSET — maintain lease quote asset records, persisting asset attributes to OKL_ASSETS_B, OKL_ASSET_COMPONENTS_B, and the associated _V views, and invoking OKL_ASS_PVT for lower-level asset processing.
• CREATE_ADJUSTMENT, UPDATE_ADJUSTMENT, DELETE_ADJUSTMENT — maintain cost adjustment lines held in OKL_COST_ADJUSTMENTS_B/_TL and their _V view, typically for capitalized cost, residual or price adjustments linked to a quote asset.
• CREATE_ASSETS_WITH_ADJUSTMENTS — a compound entry point that creates an asset together with its adjustments in a single transactional unit, used by the quote UI when an asset is entered with attached costs.
• DUPLICATE_ADJUSTMENTS — copies adjustment records when an asset is duplicated, preserving the quote structure.
• VALIDATE_SUBSIDY_APPLICABILITY, VALIDATE_SUBSIDY, CALCULATE_SUBSIDY_AMOUNT — evaluate whether a subsidy (OKL_SUBSIDIES_B) applies to the asset and compute the resulting subsidy amount, using OKL_ASSET_SUBSIDY_PVT, OKL_EXECUTE_FORMULA_PVT/PUB, and OKL_ACCOUNTING_UTIL.
• PROCESS_LINK_ASSETS — establishes and maintains relationships between assets through OKL_LINE_RELATIONSHIPS_B.

Tables Accessed

The package reads and writes the quote and asset base tables OKL_LEASE_QUOTES_B, OKL_LEASE_APPLICATIONS_B and OKL_LEASE_OPPORTUNITIES_B to anchor an asset to its owning quote, application or opportunity. Asset detail resides in OKL_ASSETS_B, OKL_ASSET_COMPONENTS_B/_TL and their _V views. Cost adjustments are stored in OKL_COST_ADJUSTMENTS_B/_TL and OKL_COST_ADJUSTMENTS_V. Cash flow generation relies on OKL_CASH_FLOWS, OKL_CASH_FLOW_LEVELS and OKL_CASH_FLOW_OBJECTS, while OKL_FE_EO_TERMS_ALL_B and OKL_FE_EO_TERM_VERS supply end-of-term (residual) values. OKL_LINE_RELATIONSHIPS_B holds asset-to-asset links. OKL_QUA_REF_SEQ, the reference sequence documented as a dependency, supplies the internal sequence numbering used to uniquely identify quote asset and adjustment records created by this package. The package also depends on OKL_STRMTYP_SOURCE_V for stream type sourcing.

Usage Notes

Because this is a PVT package, it should not be called directly by customer extensions. It is invoked indirectly from the Oracle Lease and Finance Management lease quotation forms and from the public OKL APIs that wrap the private layer, and is referenced by three other packages. The OKL_QUA_REF_SEQ dependency confirms that sequence values for quote asset records are generated inside this package, so any custom code needing the same numbering must reuse this package rather than querying the sequence table. Customizations should call the public OKL API entry points, which internally dispatch to OKL_LEASE_QUOTE_ASSET_PVT, to preserve subsidy, cash flow and formula integrity across EBS 12.1.1 and 12.2.2.