Search Results gmd_qc_test_value_id_s

Overview

GMD_QC_TEST_VALUES_PVT is a private PL/SQL package body in the APPS schema that implements the low-level data access layer for Quality Control test values in Oracle Process Manufacturing (OPM). Test values represent the discrete results captured against a QC test definition for a given sample, specification, or lot, and they form the raw analytical data underpinning quality results, specification comparisons, and disposition decisions. The package is classified as PVT (private), indicating it is not a public API and is intended for internal consumption by other EBS objects rather than direct customer invocation. It has no independent UI surface; instead it exposes row-level operations—insertion, update, deletion, locking, and translation maintenance—that are called by higher-level public APIs and quality transaction logic.

Key Procedures and Functions

The documented ETRM metadata identifies seven procedures and functions, of which five are enumerated by name. All logic centers on the GMD_QC_TEST_VALUES entity and its associated base and translation tables.

• INSERT_ROW — Creates a new QC test value record, deriving the primary key from the GMD_QC_TEST_VALUE_ID_S sequence and populating the base table columns from the values passed across the call interface.
• LOCK_ROW — Acquires a row-level lock on the specified test value (typically via SELECT FOR UPDATE) to serialize concurrent modifications and guarantee consistency during update and delete operations.
• UPDATE_ROW — Modifies the mutable attributes of an existing QC test value row after the caller has secured a lock, writing changes back to the base table.
• DELETE_ROW — Removes an existing test value row, and by implication the corresponding translation rows, thereby retiring the analytical result from the entity.
• ADD_LANGUAGE — Inserts translated description or display text into GMD_QC_TEST_VALUES_TL for a target language seeded in FND_LANGUAGES, supporting the multi-lingual attributes of the test value entity.

Tables Accessed

The package resolves all objects through APPS synonyms and references the following:

• GMD_QC_TEST_VALUES — the main base table holding QC test value records.
• GMD_QC_TEST_VALUES_B — the base table (B) variant used in the EBS multi-lingual (_B/_TL) pattern, storing language-independent columns.
• GMD_QC_TEST_VALUES_TL — the translation table storing language-specific columns, written by ADD_LANGUAGE and maintained for each installed language.
• GMD_QC_TEST_VALUE_ID_S — the sequence supplying unique primary keys on insert; this is the object most commonly searched for when tracing QC test value key generation.
• FND_LANGUAGES — the language registry consulted to validate installed languages for translation maintenance.
• DUAL — used for sequence value retrieval and lightweight SQL expressions.

Additional dependencies include FND_GLOBAL (session and user context), FND_MESSAGE and APP_EXCEPTION (error message construction and exception raising), and GMD_API_PUB, the public API package that mediates access to this private layer.

Usage Notes

Because GMD_QC_TEST_VALUES_PVT is a private package, it is not intended as a direct integration point. It is invoked indirectly whenever QC test values are created, modified, or deleted through the OPM Quality module—typically via the public GMD_API_PUB procedures, Oracle Forms on quality test and result screens, or batch loading of analytical results. The documented metadata records it as referenced by two other packages, consistent with its role as a shared internal dependency. Custom code should prefer the public API over this private body; direct calls bypass validation and are not supported across upgrades. In EBS 12.1.1 and 12.2.2, the object is deployed as VALID in the APPS schema, and its sequence, GMD_QC_TEST_VALUE_ID_S, is the authoritative source of test value identifiers.