Search Results okc_aae_pvt




Overview
Explore in AI Chat

Overview

OKC_AAE_PVT is a private PL/SQL package in the APPS schema that supports the Oracle E-Business Suite Contracts (OKC) module, specifically the Action Attributes functionality. In Oracle EBS 12.1.1 and 12.2.2, the OKC schema family manages contract authoring, lifecycle, and terms, and the OKC_ACTION_ATTRIBUTES tables store attribute-level metadata associated with contract actions and action types. The "_PVT" suffix designates this as a private API package, meaning it is intended for internal consumption by the OKC module's public APIs and concurrent processes rather than for direct invocation by external customizations.

The package provides the low-level data manipulation, validation, and concurrency control routines that back the Action Attributes entity. It follows the standard Oracle Applications private API pattern established by FND_API, exposing granular row-level operations (insert, update, delete, lock, validate) that public packages such as OKC_ACTIONS_PUB and OKC_ACTIONS_PVT compose into higher-level business transactions.

Key Procedures and Functions

The ETRM documentation lists 14 documented procedures and functions in this package. The principal ones include:

  • INSERT_ROW — Creates a new Action Attributes record, populating the base (_B), translation (_TL), and view (_V) layers as appropriate.
  • UPDATE_ROW — Modifies an existing Action Attributes record, applying changes to the base table and, where relevant, associated translated columns.
  • DELETE_ROW — Removes an Action Attributes record from the underlying base table.
  • LOCK_ROW — Acquires a row-level lock on an Action Attributes record to serialize concurrent modifications and prevent lost updates.
  • VALIDATE_ROW — Performs business-rule and referential validation before a DML operation proceeds.
  • ADD_LANGUAGE — Inserts translation rows for a newly installed or enabled language, supporting the Multi-Language Support (MLS) model used by the _TL table.
  • API_COPY — Copies Action Attributes from a source entity (for example, an action type or template) to a target, enabling inheritance and defaulting behavior.
  • CHANGE_VERSION — Updates the version/MLS columns (such as LAST_UPDATE_DATE and related audit fields) on affected records.
  • QC — A generic quality-control or consistency checking routine invoked to ensure data integrity across the entity.

Because parameter signatures are not disclosed in the supplied metadata, only the functional intent of each routine is described here.

Tables Accessed

The package operates through APPS synonyms on the following documented tables:

  • OKC_ACTION_ATTRIBUTES_B — The base table storing Action Attributes rows; INSERT_ROW, UPDATE_ROW, and DELETE_ROW act directly on it.
  • OKC_ACTION_ATTRIBUTES_TL — The translation table holding language-specific attribute text; ADD_LANGUAGE and the MLS-aware DML routines write here.
  • OKC_ACTION_ATTRIBUTES_S1 — A sequence used to generate primary keys for new rows.
  • OKC_ACTION_ATTRIBUTES_V — The MLS view exposing joined base and translation data for read access.
  • FND_APPLICATION, FND_LANGUAGES, and DUAL — Standard Oracle Application Object Library reference tables and the DUAL pseudo-table, used for application context and language resolution.
  • PLITBLM — The PL/SQL internal table used by FND_API for message and error handling.

Usage Notes

OKC_AAE_PVT is referenced by four other OKC packages: OKC_ACTIONS_PUB, OKC_ACTIONS_PVT, OKC_CONDITION_EVAL_PUB, and OKC_CONDITION_EVAL_PVT, and by OKC_API. This confirms that the package is a backend utility layer, not a user-facing API. It is typically invoked indirectly: a Forms-based contract authoring screen, a concurrent program such as contract generation or condition evaluation, or a public API call ultimately routes its Action Attributes DML through this package. Custom code should not call OKC_AAE_PVT directly; instead, use the public OKC_ACTIONS_PUB APIs, which encapsulate validation, versioning, and multi-language handling provided by this private package.