Search Results okc_terms_util_pvt




Overview
Explore in AI Chat

Overview

OKC_TERMS_UTIL_PVT is a private (PVT) PL/SQL utility package in the Oracle E-Business Suite Contracts (OKC) module, owned by the APPS schema and declared with AUTHID CURRENT_USER. It provides the internal service layer that supports the Terms and Conditions (T&C) infrastructure used across Oracle Contracts, Order Management, and Quoting. Rather than exposing a public API surface, this package centralizes low-level operations such as deleting terms records when a source document is removed, marking clause variables as amended, merging template working copies upon approval, and resolving the many system variables embedded in contract text. The package also contains the versioning helpers used to determine which article version is current, which is the area of interest for callers searching on get_latest_art_version_id. With 61 documented procedures and functions and 34 dependent packages, OKC_TERMS_UTIL_PVT is a foundational internal component of the ETRM (Enterprise Contracts / Terms) data model in both 12.1.1 and 12.2.2.

Key Procedures and Functions

Tables Accessed

The package reads and writes contract template structures (OKC_TEMPLATE_USAGES and related draft clause tables), Quoting tables (ASO_QUOTE_HEADERS_ALL, ASO_QUOTE_ACCESSES), and Order Management tables (OE_ORDER_HEADERS_ALL, OE_BLANKET_HEADERS_ALL, OE_TRANSACTION_TYPES_ALL) to resolve source document context. It references Oracle resource and role tables (JTF_RS_RESOURCE_EXTNS, JTF_RS_ROLES_B, JTF_RS_GROUP_MEMBERS, JTF_RS_ROLE_RELATIONS, JTF_RS_GRP_RELATIONS) for party and permission resolution, and standard FND tables (FND_USER, FND_ORACLE_USERID, FND_FLEX_VALUE_SETS, FND_FLEX_VALIDATION_TABLES) for user identity and value-set validation.

Usage Notes

Because OKC_TERMS_UTIL_PVT is classified as a private API, Oracle does not publish it as an extension point; it is invoked internally by public Contracts APIs, by the Contracts and Quoting forms, and by concurrent programs performing template merge, version resolution, or document deletion. Customers searching for get_latest_art_version_id will find related logic in the article-version helpers documented here, but this routine is called through supported public APIs rather than directly. Custom code should never call this package directly, as its signatures and behavior may change across releases and are not covered by Oracle's public API compatibility commitment.