Search Results oke_deliverable_utils




Overview
Explore in AI Chat

Overview

The PL/SQL package body APPS.OKE_DELIVERABLE_UTILS is a utility package within the Oracle E-Business Suite (EBS) Enterprise Contracts (OKE) module, also classified under the ETRM (Enterprise Trade and Risk Management) family. Its principal business function is to support the deliverable management and contract terms functionality of Oracle Contracts by providing reusable helper logic that resolves term values, party information, and contract reference identifiers. In Oracle EBS 12.1.1 and 12.2.2, deliverables represent the contractual obligations tracked against a contract or contract line, and this package centralises the low-level retrieval routines that other deliverable-related programs depend on. The package is documented with a VALID status in the APPS schema and is classified as an OTHER API type, indicating that it is an internal supporting package rather than an exposed public interface.

Key Procedures and Functions

The ETRM metadata documents three procedures or functions within the package body. Their scope is described as follows:

  • GET_TERM_VALUE — Retrieves the value associated with a contract term, resolving the term definition against the contract terms data. It supplies term values required for evaluating deliverable rules and conditions.
  • GET_PARTY — Resolves party information associated with a contract, typically by traversing the contract party role structures. This enables deliverables to reference the correct contractual party in context.
  • GET_K_REFERENCE — Returns a contract reference identifier (the K reference used throughout the OKC/OKE contract model), allowing callers to resolve or confirm the owning contract of a deliverable or term.

These are supporting accessors rather than transactional entry points; they encapsulate repeated lookups so that deliverable processing logic remains consistent across the module.

Tables Accessed

The package references the following documented tables (via APPS synonyms):

  • OKC_ANCESTRYS — Provides the contract hierarchy and ancestry relationships needed to resolve parent/child contract context.
  • OKC_K_HEADERS_ALL_B — The base contract header table, the primary source of contract-level attributes.
  • OKC_K_LINES_B — The contract lines base table, used when deliverables or terms are associated at line level.
  • OKC_K_PARTY_ROLES_B — The party role base table, consulted by GET_PARTY to establish the acting party on a contract.
  • OKE_DELIVERABLES_B — The base deliverables table, the core entity this package supports.
  • OKE_DELIVERABLE_ACTIONS — Tracks actions performed against deliverables, used in evaluating deliverable state.
  • OKE_K_DELIVERABLES_B — The contract-linked deliverables base table.
  • OKE_K_TERMS — The contract terms table, read by GET_TERM_VALUE to obtain term values.

Usage Notes

OKE_DELIVERABLE_UTILS is an internal utility invoked by other packages rather than called directly from Oracle Forms. The metadata confirms it references and is related to OKE_UTILS, and it is referenced by one other database object, indicating use within the deliverable processing stack. Typical invocation pathways include concurrent programs and API-based contract authoring flows that create, evaluate, update, or report on deliverables, and custom extensions that need consistent resolution of term values, parties, or contract references. It is not referenced by any other database object in the dependency report beyond that single consumer, so customisations should treat it as a private helper and avoid direct dependency where a supported public API exists.