Search Results update_asset

Overview

The APPS.OKL_ASSET_DETAILS_PVT package is a private PL/SQL API belonging to the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite. It is declared with AUTHID CURRENT_USER, meaning its statements execute with the privileges of the invoking user rather than the package owner, which is consistent with the ETRM (Enterprise Territory and Revenue Management / Lease Management) internal API conventions. The package encapsulates low-level business logic used to manipulate asset-related and rule-related detail attributes that are entered during lease or contract origination.

The PVT classification indicates that this is a private utility package intended for internal use by other OKL APIs and forms, rather than a fully supported public integration interface. Its primary role is to centralize the update logic for the year, tax rule information, and asset descriptive attributes associated with lease contract lines, ensuring consistent validation and message handling through the standard OKC_API error stack (return status, message count, and message data parameters).

Key Procedures and Functions

Three procedures are documented within the package specification:

• UPDATE_YEAR — Updates the year attribute associated with a lease contract identifier and parent line. It accepts API-version and initialization parameters, the character identifier (p_dnz_chr_id) and parent line identifier, together with the incoming year value, and returns the resulting year through an OUT parameter.
• UPDATE_TAX — Updates tax rule information for a given rule and rule group tied to a contract. In addition to the standard API parameters, it receives rule identifiers and up to four rule information attributes, returning the corresponding updated rule information values via OUT parameters.
• UPDATE_ASSET — The procedure most relevant to the search term "update_asset." It updates asset-level descriptive details, taking an asset identifier and asset number along with in-out parameters for asset description, model number, and manufacturer. The in-out (IN OUT NOCOPY) parameter style reflects a bug-fix refinement (referenced as 2689257 in the source) allowing the procedure to both receive and return the modified asset attribute values.

Tables Accessed

The ETRM metadata does not enumerate explicit table references for this package; access is performed through APPS synonyms against the underlying OKL asset and rule detail tables. Based on the procedure signatures, the package reads and writes asset detail records keyed by asset identifier and asset number, and updates rule information keyed by rule identifier and rule group identifier. These operations support the maintenance of asset descriptive data and tax rule attributes attached to lease contract lines.

Usage Notes

Because OKL_ASSET_DETAILS_PVT is a private package, it is not intended for direct external invocation. It is typically called from within the OKL application layer — for example, from Oracle Forms used for lease/asset entry, or from other OKL packages that wrap or expose these procedures through public APIs. The metadata notes the package is referenced by one other package, confirming its role as a subordinate utility.

Customizations should generally avoid calling this private API directly, since it may change between patch levels and is not part of the supported public interface. Any development requiring its functionality should prefer the supported public OKL APIs or the corresponding Oracle Forms and concurrent programs that invoke it internally, thereby preserving upgrade safety across EBS 12.1.1 and 12.2.2 environments.