Search Results okc_rep_qa_check_pvt




Overview
Explore in AI Chat

Overview

OKC_REP_QA_CHECK_PVT is a private PL/SQL package in the Oracle Contracts (OKC) module of Oracle E-Business Suite, used within the repository (OKC_REP) subsystem. Its business function is to execute quality assurance (QA) checks against contract terms and deliverables that were authored or generated from the contract repository templates. In the Oracle Contracts architecture, contract terms are assembled into structured term groups, and each term group may be subject to configured QA rules defined in the QA list lookups and QA group definitions. The package provides the runtime engine that evaluates those rules, reports success, error, or warning statuses, and persists findings such as deliverables QA checks.

The $Header line (OKCVREPQACHKS.pls 120.0.12000000.1) indicates a 12.0-series source file, which is consistent with the file also running under 12.1.1 and 12.2.2 since the Contracts QA framework was carried forward largely unchanged. The package is classified as PVT, meaning it is not intended for direct customer invocation; it is called by other OKC APIs and forms.

Key Procedures and Functions

The package exposes two documented entry points:

A business-event table type, EVENT_TBL_TYPE, is declared as OKC_TERMS_QA_GRP.BUSDOCDATES_TBL_TYPE, allowing multiple contract business document dates to be passed into a check in a single call. Module-level globals G_PKG_NAME, G_APP_NAME, and G_MODULE provide consistent logging and error context.

Tables Accessed

The package reads and writes several application tables through APPS synonyms, notably:

Usage Notes

Because the package is PVT, it is invoked internally by Oracle Contracts forms and by higher-level OKC APIs rather than by custom code. Typical call sites include the contract authoring/repository forms when a user saves or validates a contract, and concurrent programs that perform bulk QA over repository contracts. The g_contract_id_token referenced in the source represents the bind token used to pass the current contract's ID into the QA check, ensuring checks are scoped to the contract in context. Customizations should prefer public OKC APIs; direct calls to OKC_REP_QA_CHECK_PVT are unsupported and may break across patches from 12.1.1 to 12.2.2.