Search Results okl_ass_pvt




Overview
Explore in AI Chat

Overview

OKL_ASS_PVT is a private PL/SQL package in the APPS schema that serves as the core asset-maintenance engine for the Oracle Lease and Finance Management (OKL) module in Oracle E-Business Suite 12.1.1 and 12.2.2. It encapsulates the low-level insert, update, and delete logic for leased assets, exposing them to the public API layer OKL_ASS_PVT_W and to other OKL private packages. The _PVT suffix indicates that the package is classified as private: it is not intended for direct invocation by external or customer-written code, but rather provides the internal persistence logic behind the published asset interfaces. In practice, this package is what actually writes the multi-lingual asset records when a lease, lease quote, or asset transaction is created or maintained through the application.

Key Procedures and Functions

The ETRM metadata documents a compact API surface of four named procedures:

  • INSERT_ROW — Creates a new asset record in the base and translation tables, populating the descriptive and attribute columns required by lease processing.
  • UPDATE_ROW — Modifies an existing asset record, applying changes to the attributes held in the asset base and translation tables.
  • DELETE_ROW — Removes an asset record when it is no longer required, maintaining referential consistency with the rest of the asset data model.
  • ADD_LANGUAGE — Inserts the translated (TL) row for a new language, supporting Oracle's multi-language installation model so that an asset description can exist in more than one installed language.

All four procedures follow the standard Oracle Application Object Library private-API pattern, taking a row-type or ID-based parameter set and raising errors through FND_API rather than returning ad-hoc codes. Parameter lists are not enumerated here, but their behaviour mirrors the standard OKL private table-handler convention.

Tables Accessed

The package operates on the following documented tables and objects, referenced through APPS synonyms:

  • OKL_ASSETS_B — the base table holding non-translatable asset attributes; this is the primary target of INSERT_ROW, UPDATE_ROW, and DELETE_ROW.
  • OKL_ASSETS_TL — the translation table storing language-specific asset descriptions; written by INSERT_ROW, UPDATE_ROW, and ADD_LANGUAGE.
  • FND_LANGUAGES — read to validate the language code supplied to ADD_LANGUAGE.
  • OKL_ASS_SEQ — the sequence supplying primary keys for new asset rows.
  • DUAL — used for sequence and scalar lookups.
  • PLITBLM — an internal AOL table used for string and message handling utilities.

Usage Notes

Because OKL_ASS_PVT is a private package, it is never called directly from a form or concurrent program. Instead it is invoked by the public wrapper OKL_ASS_PVT_W, and in turn by higher-level providers such as OKL_LEASE_QUOTE_ASSET_PVT, OKL_LEASE_QUOTE_PRICING_PVT, OKL_LEASE_QUOTE_PVT, and OKL_PRICING_UTILS_PVT during lease quoting, pricing, and asset creation. The metadata confirms OKL_ASS_PVT is referenced by seven other packages, all part of the OKL call chain. Custom developers must not invoke it directly; the supported entry points remain OKL_API and the public _PVT_W or _PUB wrappers. When troubleshooting asset records, it is useful to know that OKL_ASS_PVT is the final writer, and that its dependencies include FND_API, FND_GLOBAL, OKL_API, and the STANDARD package.