Search Results generate_terms_deviations

Overview

The APPS.OKC_TERMS_DEVIATIONS_PVT package is a private (PVT-classification) PL/SQL API within the Oracle E-Business Suite Oracle Contracts (OKC) module, specifically the Enterprise Contracts Terms and Conditions functionality delivered under the ETRM (Enterprise Contract Terms Management) framework. Its principal business purpose is to detect, record, and manage deviations between standard contract terms (template articles) and the actual negotiated terms captured on a contract or business document. Contract administrators and legal reviewers rely on deviation reporting to identify clauses that depart from approved boilerplate, so the package effectively underpins the compliance and risk-review aspects of contract authoring.

The package is classified as private, meaning it is not intended as a public integration API. It is consumed internally by other OKC components and by ETRM processing logic rather than being called directly from customer extensions. The metadata confirms a status of VALID and identifies the owning schema as APPS.

Key Procedures and Functions

The 12.2.2 metadata documents six procedures/functions within the package:

• POPULATE_TEMPLATE_ARTICLES — Loads the standard (template) articles associated with the applicable contract template into the working structure used for deviation comparison.
• POPULATE_EXPERT_ARTICLES — Loads expert or alternate article content, providing the comparison baseline where expert-authored clauses apply.
• GENERATE_TERMS_DEVIATIONS — The core engine that compares captured contract articles against the template/expert baseline and determines which terms constitute deviations.
• INSERT_DEVIATIONS — Persists the identified deviations into the deviations table for subsequent reporting and review.
• PURGE_DEVIATIONS_DATA — Removes deviation records, supporting cleanup and housekeeping (invoked via OKC_PURGE_PVT).
• HAS_DEVIATION_REPORT — A boolean-style check indicating whether a deviation report exists for the document in question, allowing callers to branch on the presence of deviations.

Parameter lists are not exposed in the documented metadata and are therefore not reproduced here.

Tables Accessed

The package reads and writes the following objects via APPS synonyms:

• OKC_TERMS_DEVIATIONS_T and OKC_TERMS_DEVIATIONS_TEMP — the persistent and temporary stores for deviation results.
• OKC_TERMS_DEVIATIONS_S1 — the sequence used to generate deviation identifiers.
• OKC_ARTICLES_ALL, OKC_ARTICLE_RELATNS_ALL, OKC_ARTICLE_VERSIONS, OKC_K_ARTICLES_B, OKC_SECTIONS_B — the article, relationship, version, and section definitions that form the comparison source.
• OKC_BUS_DOC_TYPES_B — business document type definitions that scope which deviation rules apply.
• FND_LOOKUP_VALUES — reference lookup values used during processing.
• DUAL and PLITBLM — standard single-row and PL/SQL index-by table utilities.

Usage Notes

Because the package is private, it is referenced by only two other packages — documented as OKC_PURGE_PVT and OKC_TERMS_UTIL_GRP — and by itself. Deviation generation is normally triggered as part of the contract authoring lifecycle rather than by direct user invocation; the OKC Terms and Conditions user interface and its supporting utilities call into this package to refresh deviation data. Purge operations are driven through the standard OKC purge concurrent program. Custom code should interact with deviation data through the tables or supported public APIs rather than calling this private package directly, since its signatures are not guaranteed across patches or releases.