Results for “okl_avl_pvt”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The APPS.OKL_AVL_PVT package body is a private (PVT-classified) API within the Oracle E-Business Suite Lease Management (ETRM) module. It provides the foundational data-access and validation logic for lease accounting and accrual entries, specifically supporting the generation, creation, and maintenance of accounting entry templates used by the Lease Management accounting engine. In Oracle EBS 12.1.1 and 12.2.2, this package sits beneath the public OKL accounting interfaces and is not itself referenced by any other database object, confirming its role as an internal implementation unit. It supplies the row-level insert, update, delete, lock, and validation primitives that the higher-level accounting entry generation processes rely upon, while also providing an API_COPY routine and a version-management utility (CHANGE_VERSION) that governs how accounting entry template records are stamped and versioned over time.

Key Procedures and Functions

The package exposes thirteen documented procedures and functions. Their documented purposes are as follows:

• QC — A query-and-cache or query-control routine, typically used to obtain and hold lookup or template data within a session.
• CHANGE_VERSION — Manages versioning of accounting entry template records, supporting the tracking of successive revisions.
• API_COPY — Copies accounting entry template definitions, enabling duplication of existing template structures into new records.
• INSERT_ROW — Creates a new accounting entry template row in the underlying table.
• LOCK_ROW — Obtains a row-level lock to preserve concurrency integrity before an update or delete.
• UPDATE_ROW — Modifies an existing accounting entry template row.
• DELETE_ROW — Removes an accounting entry template row.
• VALIDATE_ROW — Performs business-rule validation against a row prior to persistence.

Parameter lists are not disclosed in the metadata and are therefore not reproduced here. The package depends on several public utilities including FND_API, FND_GLOBAL, MO_GLOBAL, OKC_API, OKC_P_UTIL, OKC_UTIL, OKL_ACCOUNTING_UTIL, and OKL_AE_TEMPLATES, along with views OKL_AE_TMPT_SETS_V, OKL_FORMULAE_V, OKL_STRM_TYPE_V, and OKL_TRX_TYPES_V. It also references APP_EXCEPTIONS and the STANDARD package.

Tables Accessed

The documented base tables accessed through APPS synonyms are OKL_AE_TEMPLATES and PLITBLM. OKL_AE_TEMPLATES is the primary store for accounting entry template definitions, and it is here that INSERT_ROW, UPDATE_ROW, DELETE_ROW, LOCK_ROW, and VALIDATE_ROW operate. PLITBLM is the standard Oracle EBS PL/SQL integer table type (a PL/SQL-supplied type used for passing collections between APIs), reflecting the package's use of bulk collection parameters in its internal calls. The view OKL_AE_TMPT_SETS_V provides formatted access to the template set definitions consumed during validation and copies, while OKL_FORMULAE_V, OKL_STRM_TYPE_V, and OKL_TRX_TYPES_V supply the stream type, formula, and transaction type reference data used in accounting entry composition.

Usage Notes

Because OKL_AVL_PVT is a private package and is not referenced by any other database object, it is not intended for direct invocation by external custom code. It is invoked internally by the public Lease Management accounting APIs and by the accounting entry generation engine when processing lease transactions, accruals, and revenue recognition. The 36 other packages reported as referencing it confirm its position as a shared internal service layer. Clients on 12.1.1 and 12.2.2 will encounter it only indirectly, through the standard Lease Management accounting flows and concurrent programs that post accounting entries. Implementers extending template behavior should interact with the supported public APIs rather than calling OKL_AVL_PVT directly, to preserve upgrade safety.