Search Results okl_pol_pvt




Overview
Explore in AI Chat

Overview

OKL_POL_PVT is the private PL/SQL package body owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2, delivered as part of the Oracle Lease and Finance Management (OKL) module within the ETRM (Enterprise Telecommunications Resource Management) application family. The package implements the internal logic supporting the OKL_POOLS base table — the repository of lease pools used by Oracle Lease Management to group contracts, assets, and funding sources for accounting, securitization, investor reporting, and pool-level processing. As a "PVT" (private) API classification, OKL_POL_PVT is not intended to be called directly by external consumers. Instead it encapsulates the row-level DML, validation, versioning, and copy operations that the public OKL pool APIs delegate to. This separation of public and private layers is the standard Oracle EBS API architecture: the private package holds the implementation, while a corresponding public package (typically OKL_POL_PUB) exposes the sanctioned entry points. The package status is VALID, and the ETRM metadata records 18 documented procedures and functions.

Key Procedures and Functions

The documented program units in OKL_POL_PVT cover the full lifecycle of a pool record:

  • INSERT_ROW — Inserts a new row into the pool table, applying defaults and standard WHO columns.
  • UPDATE_ROW — Updates an existing pool row with the supplied attribute values.
  • DELETE_ROW — Removes a pool row, subject to any referential or business-rule checks.
  • LOCK_ROW — Acquires a row-level lock on a pool record to serialize concurrent modification, typically called before an update in a multi-user flow.
  • VALIDATE_ROW — Performs attribute-level and cross-field validation on a pool record, raising errors via FND_MSG_PUB.
  • CHANGE_VERSION — Advances the object version number of a pool row, supporting the standard EBS optimistic-locking model.
  • API_COPY — Copies an existing pool definition (and associated attributes) to create a new pool, used for template-driven or clone-based pool creation.
  • QC — A quality-check/consistency routine used to verify pool data integrity, consistent with the OKL_API and OKC_P_UTIL conventions.

Although the ETRM metadata states 18 total program units, the eight above are the documented procedures and functions; the remainder are private helper routines internal to the body.

Tables Accessed

OKL_POL_PVT reads and writes OKL_POOLS, the primary pool table it owns. It also depends on DUAL for scalar evaluations and PLITBLM, the standard EBS PL/SQL index-by table type used for buffering and set-based processing. The dependency list further shows the package referencing OKL_POOL_TYPES_V (pool type validation), OKL_K_HEADERS_V (contract header lookups), FND_CURRENCIES_VL (currency validation), and the utility packages FND_API, FND_GLOBAL, FND_MSG_PUB, MO_GLOBAL, OKC_P_UTIL, OKL_ACCOUNTING_UTIL, OKL_API, OKL_LEGAL_ENTITY_UTIL, and APP_EXCEPTIONS. OKL_POL_PVT is referenced by six other packages but does not itself depend on any external database object for its row logic.

Usage Notes

Because OKL_POL_PVT is a private package, it should not be called directly from custom code or concurrent programs. Invocation typically occurs through the public OKL pool API layer (OKL_POL_PUB), which in turn is driven by the Oracle Lease Management Forms, the pool setup and maintenance UI, and lease-pool concurrent programs such as pool generation and accounting. Customizations needing to create, copy, validate, or version a pool should call the public API to preserve validation and versioning behavior. Direct calls to OKL_POL_PVT bypass these safeguards and are unsupported. All database objects resolve through APPS synonyms, so the package executes in the APPS schema context and is governed by standard EBS security and MOAC (Multi-Org Access Control) handling via MO_GLOBAL.