Search Results oke_pool_pvt




Overview
Explore in AI Chat

Overview

OKE_POOL_PVT is a private PL/SQL package in the APPS schema that supports the Oracle E-Business Suite (EBS) Funding Pool functionality, part of the Procurement Contracts (OKE) module. This package encapsulates the low-level DML operations required to maintain funding pool records stored in the OKE_FUNDING_POOLS and OKE_FUNDING_POOLS_S tables. Its classification as a "PVT" (private) API indicates that it is intended for internal use within the OKE module and is not exposed for direct external invocation. Instead, public packages and concurrent processes invoke it to insert, update, delete, and lock rows in the funding pools underlying tables. The package encapsulates row-level logic and consistency checks required to preserve the integrity of funding pool data used later for authorization, funding allocation, and expenditure tracking in contract and procurement activity.

Key Procedures and Functions

The ETRM metadata documents four procedures, which correspond to the standard CRUD-plus-lock pattern seen in EBS private APIs:

  • INSERT_ROW — Creates a new funding pool row, populating the base and translated (_S) tables with the supplied attributes.
  • UPDATE_ROW — Modifies an existing funding pool record, updating both the base table and the associated _S (translated) row.
  • DELETE_ROW — Removes a funding pool record from the base and _S tables.
  • LOCK_ROW — Acquires a row-level lock on the selected funding pool record to prevent concurrent modification during a transaction.

Although the package lists seven documented subprograms, only these four are explicitly named in the metadata. Parameter lists are not published here and must be obtained from the PL/SQL source itself; they should not be inferred.

Tables Accessed

The package operates against the following tables, referenced via APPS synonyms:

  • OKE_FUNDING_POOLS — Base table holding the primary funding pool records.
  • OKE_FUNDING_POOLS_S — The translated/secure table paired with the base table; insert, update, and delete operations are applied here as well.
  • FND_CURRENCIES — Provides currency validation and defaulting information for pool amounts.
  • OKE_PROGRAMS — Supplies program context (e.g., contract programs) to which the pool may be associated.
  • DUAL — Standard Oracle utility table used for single-row queries and function evaluation.
  • PLITBLM — Standard EBS PL/SQL table used for handling multi-row attribute values.

Usage Notes

OKE_POOL_PVT is not intended for direct customer invocation. It is called by public APIs and forms within the OKE module, notably OKE_POOLS_PARTIES_PUB, which manages the relationship between funding pools and their associated parties. The package also references OKE_API, indicating reuse of common OKE utilities, and it appears in dependency chains involving OKE_FUNDING_POOLS. Because it handles critical DML and row locking for funding pool data, any customization that interacts with OKE_POOL_PVT should be performed cautiously, ideally by calling the public wrappers rather than this private package. When troubleshooting funding pool insert, update, or lock-related errors in EBS 12.1.1 or 12.2.2, the package source and its dependency tree should be examined to confirm the call path and table state.