Search Results okc_pon_int_grp




Overview
Explore in AI Chat

Overview

OKC_PON_INT_GRP is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified in the ETRM repository as an API group (GRP). It operates within the Oracle Contracts (OKC) module and, more specifically, within the Oracle Procurement Contracts / Contract Terms family of components. The package name reflects the "PON" (Procurement Online / Purchasing) integration context, and it works in close association with OKC_TERMS_UTIL_GRP and OKC_TERMS_UTIL_PVT, which handle contract terms and variable substitution logic.

Its principal business role is to support the exposure and evaluation of contract clause article variables and their values during contract authoring and integration processing. The package acts as a grouping layer that front-ends lower-level terms utilities, providing controlled access to article variable values and change detection information required by the Expert (authoring) UI and by integration flows such as Oracle Purchasing document generation from procurement contracts. It also supplies a commit-safety check used to validate whether a transaction can be committed. Because the package is marked VALID with both a package specification and body, it forms an active, executable component of the contract terms architecture rather than a stub.

Key Procedures and Functions

  • GET_ARTICLE_VARIABLE_VALUES — Retrieves the values of variables defined within contract article templates. This is used to resolve the substituted text or data associated with a clause or article when a contract or purchasing document is rendered or processed.
  • GET_CHANGED_VARIABLES — Identifies which article variables have changed, supporting change-detection and refresh logic so that dependent documents or integration payloads can be updated incrementally rather than fully regenerated.
  • GET_ITEM_DTL_FOR_EXPERT — Returns item detail information for consumption by the Contracts Expert authoring interface, supplying the data needed to display or validate item-related contract content.
  • OK_TO_COMMIT — Performs a validation check indicating whether the current transaction or processing context is in a state that permits a commit, protecting integrity when the package is called within a larger transaction.

All four are documented as program units of this package; no parameter signatures are asserted here.

Tables Accessed

The ETRM dependency extract for OKC_PON_INT_GRP does not enumerate direct base-table references via APPS synonyms. Instead, the package relies on the OKC_TERMS_UTIL_GRP package and the FND_API framework, delegating most data access to the terms utility layer, which in turn reads and writes the contract terms, article, and variable tables (such as OKC_ARTICLE_VARIABLES and related clause definition structures). The absence of a direct table list is consistent with its role as an API grouping layer that encapsulates data access behind utility calls.

Usage Notes

The package is referenced by three other packages — OKC_PON_INT_GRP itself, OKC_TERMS_UTIL_GRP, and OKC_TERMS_UTIL_PVT — indicating it is invoked from contract terms maintenance logic and internal recursion. It is not a standalone concurrent program; rather, it is called from contract authoring forms, the Contract Terms Expert UI, and integration processing that synchronizes procurement contracts with purchasing documents. Customizations should invoke the utility package OKC_TERMS_UTIL_PVT rather than calling OKC_PON_INT_GRP directly, because the group layer is an internal implementation dependency. It depends on FND_API and STANDARD, so it must be executed within an initialized EBS session with standard API error handling and savepoint management available.