Search Results okc_class_pub




Overview
Explore in AI Chat

Overview

The APPS.OKC_CLASS_PUB package body is a public application programming interface (API) within the Oracle E-Business Suite Contract Core (OKC) module. Its principal business function is to provide a controlled, multitenant-aware mechanism for the creation, maintenance, and lifecycle management of contract classification records. Contract classifications allow an enterprise to group and categorize contracts using configurable class codes, categories, and associated attributes, enabling reporting, security, and business-rule segmentation across the contracting lifecycle.

As a public API package, it exposes a stable, supported interface to external callers, shielding them from the internal complexity of the underlying private implementation. Its status in the enterprise technical reference model is listed as VALID, confirming that it is compiled and available for use in both Oracle EBS 12.1.1 and 12.2.2 environments.

Key Procedures and Functions

The ETRM metadata documents eleven program units within the package, with the following named procedures identified:

  • INSERT_CLASS — Creates a new contract classification record in the underlying data store, applying standard validation and defaulting rules before persisting the row.
  • UPDATE_CLASS — Modifies attributes of an existing contract classification, enforcing concurrency handling and permitted-field restrictions.
  • DELETE_CLASS — Logically or physically removes an existing classification record, subject to referential and business validation.
  • LOCK_CLASS — Acquires a lock on a classification record, typically to support concurrent edit scenarios and protect against lost updates during an update or delete transaction.
  • VALIDATE_CLASS — Performs business-rule validation against a classification record without performing any data manipulation, allowing callers to pre-check before commit.
  • ADD_LANGUAGE — Inserts translated (multi-language) descriptions or name records for a classification, supporting Oracle Applications' Multi-Language Support (MLS) architecture.

The remaining documented program units constitute supporting logic and overloads that underpin these six primary operations. The API follows the standard Oracle EBS convention of returning a boolean or status indicator together with an outbound message table.

Tables Accessed

While the ETRM excerpt does not enumerate the specific base tables accessed in this object’s metadata segment, the package operates against the OKC classification schema — principally OKC_CLASSES_B (base definitions) and OKC_CLASSES_TL (translated descriptions), together with any related association or usage tables — via APPS synonyms. All reads and writes are performed using the standard DML patterns expected of Oracle EBS public APIs, with the necessary WHO-column and language-session population driven by profile options and FND_PROFILE.

Usage Notes

OKC_CLASS_PUB is typically invoked programmatically rather than directly by end users. It is called from Contract Core forms, concurrent programs, and custom extensions that need to manage classification data consistently. The dependency metadata confirms that it references FND_API, FND_PROFILE, and the internal OKC_API and OKC_CLASS_PVT packages, and notably that it is referenced by no other database object — meaning it is a top-level entry point intended for external callers. Developers should call VALIDATE_CLASS before INSERT_CLASS or UPDATE_CLASS, and should honor the API’s commit and rollback conventions, using LOCK_CLASS where strict concurrency control is required.