Search Results okc_aal_pvt




Overview
Explore in AI Chat

Overview

OKC_AAL_PVT is a private API package body in the APPS schema that supports the Oracle E-Business Suite Contract Lifecycle Management (OKC) module. Its name follows the OKC convention for internal "private" APIs, indicated by the PVT suffix, distinguishing it from public APIs such as OKC_API. The package provides the low-level implementation logic for managing action attribute lookups, the reference data that governs which attributes are available on contract actions. In the ETRM 12.2.2 metadata, OKC_AAL_PVT is documented with an API classification of PVT, contains 13 documented procedures and functions, references the OKC_ACTION_ATT_LOOKUPS table and PLITBLM through APPS synonyms, and is referenced by six other database objects. It is marked VALID in the provided ETRM dependency extract, confirming that it compiles cleanly against its declared dependencies at the time the metadata was captured.

Key Procedures and Functions

The documented procedure and function list includes the following members. Where the metadata does not supply a parameter list, only the documented purpose is described.

  • QC — A quality-control routine that validates internal consistency within the package's operational data.
  • CHANGE_VERSION — Increments or otherwise advances the version identifier associated with a lookup row, supporting concurrency and audit requirements.
  • API_COPY — Copies an existing action attribute lookup record, typically for duplication or versioning purposes.
  • INSERT_ROW — Inserts a new action attribute lookup row into the underlying table.
  • LOCK_ROW — Acquires a row-level lock on a lookup record, preventing conflicting concurrent modifications.
  • UPDATE_ROW — Modifies an existing action attribute lookup row.
  • DELETE_ROW — Removes an action attribute lookup row.
  • VALIDATE_ROW — Performs business-rule validation on a lookup row before insert or update operations proceed.

These eight documented entries follow the standard Oracle EBS private-API pattern of insert, update, delete, lock, validate, copy, and version-management operations on a single primary entity.

Tables Accessed

The ETRM dependency information identifies OKC_ACTION_ATT_LOOKUPS as the principal table referenced by this package, with the companion view OKC_ACTION_ATT_LOOKUPS_V also listed among dependencies. This table stores the action attribute lookup definitions that the OKC module uses to determine which attributes are valid for a given contract action. PLITBLM, a PL/SQL internal table type used for bulk processing, appears in the dependency list and indicates that the package implements array-based DML for performance. All table references are made through APPS synonyms rather than fully qualified schema names, which is consistent with standard Oracle EBS coding standards. The package body is documented as not being referenced by any database object in the dependency extract, though the ETRM 12.2.2 metadata records six other packages as referencing it.

Usage Notes

Because OKC_AAL_PVT is a PVT (private) API, it is not intended to be called directly from user-facing forms, concurrent programs, or customer-developed code. Instead, it is invoked internally by the public OKC APIs and by the six packages documented as referencing it. The dependency list confirms that OKC_AAL_PVT itself calls FND_API, FND_GLOBAL, FND_PROFILE, OKC_API, OKC_P_UTIL, and APP_EXCEPTIONS, meaning it participates in the standard Oracle EBS error-handling and message-stack model through FND_API and APP_EXCEPTIONS, derives session context through FND_GLOBAL, and reads profile option values through FND_PROFILE. Customizations should never call this package directly; instead, they should use the corresponding public APIs, which will in turn delegate to OKC_AAL_PVT. Administrators troubleshooting attribute lookup behaviour should examine OKC_ACTION_ATT_LOOKUPS and its view for the data this package maintains.