Search Results okc_qa_check_pub




Overview
Explore in AI Chat

Overview

OKC_QA_CHECK_PUB is a public PL/SQL package in the Oracle E-Business Suite Contracts (OKC) module, delivered under the APPS schema. It forms part of the Quality Assurance (QA) validation framework used by Oracle Contracts to verify that contract data satisfies user-defined business rules before the record is committed to the database. The QA check framework allows implementers to attach configurable validation checks to contract headers, lines, and related entities, and OKC_QA_CHECK_PUB provides the public entry point through which those checks are executed.

The package follows the standard Oracle EBS public/private (PUB/PVT) design pattern. Business logic for evaluating QA check lists resides in the companion private package OKC_QA_CHECK_PVT, while OKC_QA_CHECK_PUB exposes the supported, callable interface for external consumers. The source header indicates a build date of 2005 (OKCPQACS.pls, version 120.0), confirming the package is a long-standing component of the Contracts foundation rather than a late-generation addition.

The package inherits its message-oriented constants from OKC_API, including tokens for required values, invalid values, record locking conflicts, optimistic locking failures, and unexpected errors. This confirms its role as a validation and error-reporting layer rather than a data-maintenance API.

Key Procedures and Functions

The documented public interface for OKC_QA_CHECK_PUB exposes a single procedure:

  • EXECUTE_QA_CHECK_LIST — Executes the QA check list associated with a Contracts entity. This is the mechanism by which the QA validation rules registered against a contract record are evaluated at the point of entry or update. Because the procedure operates on a "check list," it processes a collection of QA checks rather than a single rule. It is not documented here with an explicit parameter list, and parameter signatures should be confirmed directly in the package specification for the target release.

The package also declares the public subtype msg_tbl_type, aliased from OKC_QA_CHECK_PVT.MSG_TBL_TYPE, which is the message-table structure used to collect validation results. The declared global exception G_EXCEPTION_HALT_VALIDATION allows callers or internal logic to abort the remaining checks in the list. Constants such as G_UPPERCASE_REQUIRED and G_UNEXPECTED_ERROR indicate that the procedure emits structured, message-name-based errors suitable for display in the Contracts forms.

Tables Accessed

The ETRM metadata for this package does not enumerate tables accessed through APPS synonyms. Functionally, the QA check framework reads QA check definitions and QA check list assignments and, in the context of the entity being validated, references the contract header or line records under validation. Because the documented public procedure delegates to OKC_QA_CHECK_PVT, the physical table reads occur primarily in the private package; OKC_QA_CHECK_PUB acts as a thin public facade.

Usage Notes

OKC_QA_CHECK_PUB is referenced by nine other packages, which reflects its position as a shared validation utility within the Contracts module. It is typically invoked from the Contracts forms at the point where a user saves or validates a contract, and from internal Contracts APIs that must enforce QA rules programmatically. Customizations that need to enforce the same QA validation behavior as the standard application should call EXECUTE_QA_CHECK_LIST rather than reimplementing the logic.

Because this is a PUB package, it is the supported integration surface; the underlying OKC_QA_CHECK_PVT should not be called directly. Customers upgrading from 12.1.1 to 12.2.2 should note that the PUB/PVT separation and message-constant inheritance from OKC_API remain consistent across both releases, and the package header confirms no signature change was introduced with the online-patching (adop) file system used from 12.2 onward.