Search Results oke_deliverable_pvt




Overview
Explore in AI Chat

Overview

OKE_DELIVERABLE_PVT is a private PL/SQL package in the APPS schema that encapsulates the core data-management logic for contract deliverables within Oracle E-Business Suite Procurement Contracts (OKE/OKC module). Deliverables represent the specific goods, services, or performance obligations that a contract line commits a party to provide, and they form a critical bridge between the contractual instrument and downstream execution, billing, and project tracking. The package carries an API classification of PVT (private), which signals that it is intended for internal consumption by other ETRM packages rather than as a supported public integration interface. In practice, OKE_DELIVERABLE_PVT provides the insert, update, delete, validation, locking, and multi-language maintenance routines that manipulate the OKE_K_DELIVERABLES family of tables, ensuring that row-level integrity, dependency checks, and translation handling are performed consistently regardless of the calling surface (form, concurrent program, or public API). Its presence in both 12.1.1 and 12.2.2 reflects a stable, long-lived component of the Contracts foundation layer. The package status is VALID, and it is documented in the ETRM repository as depending on OKE_API (the public contracts API) and the SYS.STANDARD library.

Key Procedures and Functions

Twelve documented routines make up the procedural surface of the package. Their purposes are summarized below; parameter lists are intentionally omitted.

  • INSERT_ROW — Creates a new deliverable record in the base and translation tables, applying defaults and surrogate-key derivation.
  • UPDATE_ROW — Modifies an existing deliverable's attributes while preserving audit and versioning columns.
  • DELETE_ROW — Removes a deliverable and its dependent translation rows.
  • VALIDATE_ROW — Performs business-rule validation on a deliverable before it is committed, checking required attributes and referential consistency.
  • LOCK_ROW — Acquires a row-level lock to serialize concurrent modification of a deliverable.
  • ADD_LANGUAGE — Inserts translated (TL) rows for a deliverable in a target language, supporting the multi-language contract model.
  • CHECK_DEPENDENCY — Verifies that prerequisite or parent records (for example, headers or lines) exist and that dependency relationships are satisfied before allowing a change.

These routines collectively implement the CRUD-plus-validation pattern characteristic of Oracle's private table-handler packages, with LOCK_ROW and CHECK_DEPENDENCY enforcing concurrency and integrity constraints that callers cannot be trusted to enforce themselves.

Tables Accessed

The package operates primarily across the deliverable schema objects OKE_K_DELIVERABLES_B (base), _TL (translations), _BH and _TLH (history/audit), and _S (security or sequence), together with the header and line context tables OKE_K_HEADERS and OKE_K_LINES and the OKC_K_HEADERS_B and OKC_K_LINES_B core contract structures. Reference and validation lookups include FND_LANGUAGES (for ADD_LANGUAGE), MTL_UNITS_OF_MEASURE (unit-of-measure validation), GL_DAILY_CONVERSION_TYPES (currency/rate type validation), OKC_ANCESTRYS (contract hierarchy consistency), OKE_DEPENDENCIES (deliverable interdependency rules), and MRP_SCHEDULE_DATES (planning/schedule-date validation). Reads and writes against these tables are performed through APPS synonyms, which is standard for ETRM packages and supports the multi-org access model.

Usage Notes

OKE_DELIVERABLE_PVT is not invoked directly by end users or by custom integrations; it is called internally by the ETRM stack. The ETRM metadata shows it is referenced by seven packages, including OKE_CONTRACT_PUB, OKE_CONTRACT_PVT, OKE_DEFAULTING_PKG, OKE_IMPORT_CONTRACT_PUB, OKE_POOLS_PARTIES_PUB, OKE_STANDARD_NOTES_PUB, and OKE_TERMS_PUB. This reference pattern confirms that deliverable maintenance is exercised whenever a contract is created, defaulted, imported, or amended through the supported public APIs and their supporting Forms. Custom developers who need to manipulate deliverables should route changes through the public OKE_API or OKE_CONTRACT_PUB interfaces, which in turn delegate to this private package, rather than calling OKE_DELIVERABLE_PVT routines directly. Because the package depends on OKE_API, any deployment or patch activity touching the public contracts API should be sequenced with awareness of this private dependency. In 12.2.2 the package retains its VALID status, indicating no signature-level breakage relative to 12.1.1.