Search Results mark_amendment

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

• DELETE_DOC — Removes Terms and Conditions records associated with a document that is being deleted, identified by document type and document ID.
• DELETE_DOC_VERSION — Performs the same cleanup for a specific document version rather than the entire document.
• MARK_AMENDMENT — Flags an article as amended when one or more of its variables has changed, using the API message-handling convention.
• MERGE_TEMPLATE_WORKING_COPY — Merges an approved working copy of a template back into the parent template, storing the parent template identifier as a package global and updating the draft clause records accordingly.
• GET_SYSTEM_VARIABLES — Retrieves the values of all system variables referenced in the Terms and Conditions of a given document, dispatching to the appropriate integrating API based on document type.
• SUBSTITUTE_VAR_VALUE_GLOBALLY — Replaces variable values throughout the contract text.
• Versioning helpers — GET_LATEST_ART_VERSION, GET_LATEST_ART_VERSION_NO, and GET_ARTICLE_VERSION_NUMBER resolve the current article version identifier and its version number for a contract line.
• Amendment and alternate checks — HAS_AMENDMENTS, HAS_ALTERNATES, GET_ALTERNATE_YN, GET_SUMMARY_AMEND_CODE, and GET_ACTUAL_SUMMARY_AMEND_CODE report amendment and alternate status.
• Metadata and label helpers — CREATE_UNASSIGNED_SECTION, IS_DOC_TYPE_VALID, GET_MESSAGE, TMPL_INTENT_EDITABLE, GET_SECTION_LABEL, and GET_SECTION_NAME provide structural, validation, and display utilities.

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.