Search Results okc_terms_deviations_s1




Overview
Explore in AI Chat

Overview

OKC_TERMS_DEVIATIONS_PVT is an internal (private) PL/SQL package body in the APPS schema that supports Oracle E-Business Suite's Enterprise Contracts (OKC) module, part of the ETRM (Enterprise Transaction and Repository Management) family of applications. Its core business purpose is to identify, generate, and report on deviations between contract terms as authored and the corresponding standard or template terms defined for a business document type. These deviation records give legal, sales, and contract administration staff visibility into clauses that diverge from approved boilerplate language, supporting compliance review and approval workflows. Because the object is classified as a PVT (private) API, it is not intended as a public integration point; it functions as the engine behind deviation-related user interfaces and concurrent processing rather than as a documented extension API.

Key Procedures and Functions

The package exposes six documented procedures and functions that together implement the full deviation lifecycle:

  • POPULATE_TEMPLATE_ARTICLES — Loads the standard (template) article set for the contract so that a baseline of expected terms is available for comparison.
  • POPULATE_EXPERT_ARTICLES — Loads expert or system-derived article content, complementing the template population logic.
  • GENERATE_TERMS_DEVIATIONS — The principal driver routine; it compares authored contract articles against the populated baseline and produces deviation results.
  • INSERT_DEVIATIONS — Persists the identified deviations into the deviation table for subsequent querying and reporting.
  • PURGE_DEVIATIONS_DATA — Removes stale or prior deviation data, typically ahead of a regeneration cycle to prevent duplicates.
  • HAS_DEVIATION_REPORT — Returns whether a deviation report exists or is required for the contract in question, allowing callers to conditionally invoke reporting logic.

No parameter lists are documented, and none are asserted here.

Tables Accessed

The package reads and writes the following documented objects through APPS synonyms:

Usage Notes

Because OKC_TERMS_DEVIATIONS_PVT is a private package, it is not referenced by any database object outside its own dependency chain, but it is invoked by at least two other packages within the ETRM stack. In typical deployments it is driven from the Contracts authoring forms when a user requests deviation analysis, and from concurrent programs or batch processes that regenerate deviation reports across contract portfolios. It depends on shared infrastructure including FND_API, FND_MSG_PUB, FND_LOG, FND_FILE, APP_EXCEPTIONS, OKC_API, OKC_TERMS_UTIL_PVT, OKC_TERMS_QA_GRP, and OKC_XPRT_UTIL_PVT for error handling, messaging, logging, and terms utilities. The behavior is consistent across EBS 12.1.1 and 12.2.2. Custom code should not call this package directly; the supported public contract APIs should be used instead.