Search Results gmd_qc_test_values




Overview
Explore in AI Chat

Overview

GMD_QC_TEST_VALUES_PVT is a private PL/SQL package in the APPS schema belonging to the Oracle Quality Management (GMD) product family within Oracle E-Business Suite. It serves as the low-level data access layer for Quality Control test value records, providing the primitive row operations that other, more public packages use to manipulate test results captured against QC specifications. In Oracle EBS terminology, the PVT suffix denotes a private API: the package is not intended for direct invocation by external consumers, but instead acts as the implementation backbone for higher-level public packages such as GMD_QC_TESTS_PUB and group APIs such as GMD_QC_TESTS_GRP. Its status is recorded as VALID in the ETRM 12.2.2 metadata, and the package is present in both 12.1.1 and 12.2.2 environments.

Key Procedures and Functions

The package exposes seven documented procedures and functions, all centered on maintaining rows in the GMD_QC_TEST_VALUES entity and its related translation and base tables:

  • INSERT_ROW — Creates a new QC test value record, populating the descriptive and translated columns of the test value entity.
  • LOCK_ROW — Obtains a row-level lock on an existing QC test value, used to serialize concurrent updates and guarantee read-consistency before modification.
  • UPDATE_ROW — Modifies an existing QC test value record, typically following a successful LOCK_ROW call within the same transaction.
  • DELETE_ROW — Removes a QC test value record, handling the corresponding base and translation rows.
  • ADD_LANGUAGE — Inserts translation rows for a QC test value into the _TL table for a specified language, supporting the Oracle multi-language architecture (MLS).

The remaining documented entries are the standard package and package body internal routines that implement the above. Parameter lists are not published in the metadata; callers should reference the package specification in the target instance for exact signatures.

Tables Accessed

Documented table references, accessed through APPS synonyms, are:

  • GMD_QC_TEST_VALUES — the primary entity table storing QC test results; this is the principal read/write target.
  • GMD_QC_TEST_VALUES_B — the base (language-independent) table backing the MLS entity.
  • GMD_QC_TEST_VALUES_TL — the translation table holding language-specific descriptive columns, populated by ADD_LANGUAGE and the row operations.
  • GMD_QC_TEST_VALUE_ID_S — the sequence used to generate primary keys for new test value rows.
  • FND_LANGUAGES — read to validate or resolve the language code supplied to ADD_LANGUAGE.
  • DUAL — used for single-row expression evaluation typical of PL/SQL utilities.

Usage Notes

Because GMD_QC_TEST_VALUES_PVT is a private package, it is not exposed as a user-facing API and should not be called directly from custom code. The metadata confirms it is referenced by GMD_QC_TESTS_GRP and GMD_QC_TESTS_PUB, and it also references itself (a standard internal call pattern). In practice, it is invoked transitively when users create, update, or delete QC test values through the Oracle Quality Management forms, or when concurrent programs and integration code call the public QC test APIs. In Oracle EBS 12.1.1 and 12.2.2 the package resides in the APPS schema and is normally executed under the application's standard file and database privilege model. Developers extending QC functionality should target the public packages rather than this PVT layer, since Oracle reserves the right to change private package signatures without notice.