Search Results create_assets_with_adjustments

Overview

OKL_LEASE_QUOTE_ASSET_PVT is a private (PVT) PL/SQL API package in the Oracle E-Business Suite Lease and Finance Management module (OKL), part of the Enterprise Trade and Risk Management (ETRM) family. The package encapsulates the business logic that manages the assets and cost adjustments associated with lease quotations. During lease origination, a lessor or lessee must define the equipment or property being leased, capture its cost components, apply adjustments, and evaluate subsidy and tax applicability before the quote can be priced. OKL_LEASE_QUOTE_ASSET_PVT provides the programmatic entry points that create, duplicate, update, and delete these asset and adjustment records while enforcing the validation and calculation rules required by the leasing engine.

The package is declared with AUTHID CURRENT_USER, executes under the invoking user's schema privileges, and follows the standard EBS API conventions: a package version constant (G_API_VERSION), FND_API return status constants (G_RET_STS_SUCCESS, G_RET_STS_ERROR, G_RET_STS_UNEXP_ERROR), and error tokens such as G_SQLCODE_TOKEN and G_SQLERRM_TOKEN. It is classified as a Private API, meaning it is intended for internal use by the leasing application rather than as a public integration surface.

Key Procedures and Functions

The package exposes fifteen documented procedures and functions organized around three concerns: asset lifecycle maintenance, cost adjustment maintenance, and subsidy processing.

• CREATE_ASSET — Creates a new lease quote asset record.
• DUPLICATE_ASSET — Copies an existing asset, including its associated components, for reuse within a quote.
• DELETE_ASSET — Removes an asset from the lease quote.
• UPDATE_ASSET — Modifies attributes of an existing asset.
• CREATE_ADJUSTMENT, UPDATE_ADJUSTMENT, DELETE_ADJUSTMENT — Maintain cost adjustment records that affect the asset's capitalized cost basis.
• CREATE_ASSETS_WITH_ADJUSTMENTS — A composite operation that creates an asset together with its adjustments in a single call.
• DUPLICATE_ADJUSTMENTS — Copies adjustment records, typically following asset duplication.
• VALIDATE_SUBSIDY_APPLICABILITY — Determines whether a subsidy rule applies to the asset's context.
• VALIDATE_SUBSIDY — Performs the subsidy validation logic prior to calculation.
• CALCULATE_SUBSIDY_AMOUNT — Computes the subsidy amount for the asset, deriving the value passed into the quote's pricing and cash flow streams. This is the procedure most frequently referenced in custom code, since it produces the subsidy figure consumed downstream.
• PROCESS_LINK_ASSETS — Manages relationships between linked assets.

The package also defines composite record and table types based on OKL_ASS_PVT, OKL_ASO_PVT, and the lease quote cash flow structures (OKL_LEASE_QUOTE_CASHFLOW_PVT), reflecting its role in feeding asset data into the cash flow engine.

Tables Accessed

The package reads and writes several core OKL tables through APPS synonyms:

• OKL_ASSETS_B and OKL_ASSET_COMPONENTS_B / _TL — Store the asset header, its component breakdown, and translated descriptions.
• OKL_COST_ADJUSTMENTS_B / _TL — Hold cost adjustment lines and their translated text.
• OKL_LEASE_QUOTES_B, OKL_LEASE_APPLICATIONS_B, and OKL_LEASE_OPPORTUNITIES_B — Provide the quote, application, and opportunity context that links assets to the leasing pipeline.
• OKL_CASH_FLOWS, OKL_CASH_FLOW_LEVELS, and OKL_CASH_FLOW_OBJECTS — Receive the cash flow entries generated from asset and subsidy amounts.
• OKL_FE_EO_TERMS_ALL_B and OKL_FE_EO_TERM_VERS — Supply fair value and economic ownership terms used during validation.
• OKL_LINE_RELATIONSHIPS_B and OKL_QUA_REF_SEQ — Support line-level relationships and quote reference sequence numbering.

Usage Notes

Because OKL_LEASE_QUOTE_ASSET_PVT is a Private API, it is normally invoked indirectly through the Lease Quotes form or the pricing and cash flow generation concurrent programs rather than by external integrations. Customizations that need to drive subsidy calculations programmatically — for example, when bulk-loading quote assets or reproducing subsidy logic in an extension — call CALCULATE_SUBSIDY_AMOUNT after establishing the asset and adjustment context. Standard API discipline applies: check the returned status against G_RET_STS_SUCCESS, and on failure read the SQLCODE and SQLERRM tokens from the error message stack. The package is referenced by three other OKL packages, so modifications to its behavior can cascade into the quote pricing and cash flow processes.