Search Results okc_sae_pvt




Overview
Explore in AI Chat

Overview

OKC_SAE_PVT is a private PL/SQL package body in the APPS schema that implements the underlying logic for the Standard Article Entries (SAE) feature within Oracle E-Business Suite's Contracts (OKC) module. Standard Articles are reusable clause and article templates maintained in a central repository, and a Standard Article Entry represents an instance of such a template attached to a contract or contract line. The package's "PVT" classification indicates that it is an internal implementation layer, not a public API intended for direct customer invocation. The public wrapper for these operations is exposed through OKC_SAE_PUB, which delegates to this private package after performing public-level validation and exception handling. The package body depends on shared ETRM infrastructure including FND_API, FND_GLOBAL, FND_PROFILE, FND_LANGUAGES, OKC_API, OKC_P_UTIL, OKC_UTIL, and OKC_DEBUG, reflecting a consistent, layered design. It is marked VALID and is referenced by two other packages, confirming its role as a foundational component in the Standard Articles code path.

Key Procedures and Functions

The package exposes sixteen documented procedures and functions that together provide a complete create, read, update, and delete lifecycle for Standard Article Entries:

  • INSERT_ROW — Inserts a new Standard Article Entry record into the underlying base table.
  • UPDATE_ROW — Applies modifications to an existing Standard Article Entry.
  • DELETE_ROW — Removes a Standard Article Entry.
  • LOCK_ROW — Obtains a row-level lock to serialize concurrent modification.
  • VALIDATE_ROW — Performs integrity checks prior to persistence.
  • VALIDATE_NAME — Confirms that the article name supplied meets uniqueness and format rules.
  • VALIDATE_NO_K_ATTACHED — Enforces the business rule that an article not attached to a contract (K) cannot be modified or deleted.
  • QC — A quality-control routine that verifies post-condition consistency of an entry.
  • CHANGE_VERSION — Manages version tracking when a Standard Article Entry is revised.
  • API_COPY — Copies a Standard Article Entry, supporting template reuse.
  • ADD_LANGUAGE — Inserts translated rows into the TL table for the requested language.

Tables Accessed

The package operates against the core Standard Articles schema and supporting EBS reference tables:

  • OKC_STD_ARTICLES_B — Primary base table storing Standard Article Entry records; the target of insert, update, and delete operations.
  • OKC_STD_ARTICLES_TL — Translation table holding language-specific name and description columns; written by ADD_LANGUAGE and read by validation logic.
  • OKC_STD_ARTICLES_V — The view joining B and TL, used for read-back and validation of the effective entry.
  • OKC_K_ARTICLES_B — Links articles to contracts; consulted by VALIDATE_NO_K_ATTACHED to determine usage.
  • FND_LANGUAGES — Provides the set of installed languages used to resolve ADD_LANGUAGE requests.
  • PLITBLM — A standard EBS utility table used in bulk SQL and array processing.

Usage Notes

OKC_SAE_PVT is invoked indirectly. Users interact with Standard Article Entries through the Contracts Authoring forms, which call OKC_SAE_PUB, which in turn routes to this private package. Custom code developed against the Contracts module should call OKC_SAE_PUB rather than this body, since the PVT package does not guarantee interface stability across releases and assumes callers have already satisfied public-level validations. The package is compliant across Oracle EBS 12.1.1 and 12.2.2; the schema and dependencies cited in the ETRM metadata are unchanged between these releases. Debug tracing can be enabled through OKC_DEBUG when diagnosing unexpected validation or persistence errors in the Standard Articles authoring flow.