Search Results okl_pool_pub




Overview
Explore in AI Chat

Overview

OKL_POOL_PUB is the public application programming interface of the Oracle Lease and Finance Management (OKL) module, delivered in the APPS schema and classified in the ETRM dictionary as a PUB (public) API package. Its business purpose is to manage the lifecycle of lease pools. In Oracle Lease Management, a pool is an aggregation of lease contracts or assets that is treated as a unit for origination, syndication, securitization, or investor funding purposes. Pools serve as the grouping mechanism by which a lessor bundles contracts and their associated cash flows so that they can be valued, sold, or otherwise transferred to a third party.

The package exposes a small, well-defined public surface and delegates the substantive business logic to the private implementation packages OKL_POOL_PVT and OKL_POL_PVT, while relying on OKL_API and OKC_API for standard error handling, message retrieval, and common utility behavior. This layering — public wrapper over private worker — is the standard ETRM implementation pattern, ensuring that validation and internal rules cannot be bypassed by external callers.

Key Procedures and Functions

  • CREATE_POOL — Creates a new pool record, establishing the pool header and its identifying attributes so that lease contracts may subsequently be associated with it.
  • UPDATE_POOL — Modifies the attributes of an existing pool, allowing maintenance of pool descriptive and control information after the pool has been created.
  • ADD_POOL_CONTENTS — Adds the constituent items (typically lease contracts or associated assets) to an existing pool, thereby building the population that the pool represents.
  • CLEANUP_POOL_CONTENTS — Removes or clears members from a pool, supporting correction, reversal, or reconfiguration of the pool population prior to final processing.

No parameter lists are documented in the ETRM metadata, and none should be assumed; callers must consult the package specification in the E-Business Suite database for exact signatures.

Tables Accessed

The ETRM metadata for OKL_POOL_PUB does not enumerate the base tables directly. The package operates through APPS synonyms and, per the documented dependency information, performs its data manipulation principally through OKL_POOL_PVT and OKL_POL_PVT, which own the physical access to the OKL pool and contract-line tables. In practice, this means the pool header and pool line/contract association tables are read and written indirectly. Custom code should not assume direct table access through OKL_POOL_PUB; all persistence is mediated by the private layer.

Usage Notes

OKL_POOL_PUB is the supported entry point for programmatic pool maintenance. It is typically invoked from the Oracle Lease Management concurrent programs and forms that manage pool definitions, and from custom extensions or integrations that need to create or maintain pools without direct table manipulation. Because the package is classified as PUB and is not referenced by any other documented package, it is effectively a leaf API intended for external callers rather than an internal dependency.

Callers should invoke CREATE_POOL before ADD_POOL_CONTENTS, respect the commit/rollback conventions of the surrounding transaction, and rely on OKL_API and OKC_API messaging for error interpretation. Direct DML against the underlying OKL tables is not recommended, as it bypasses the validation and audit logic enforced within the private implementation packages.