Search Results gmd_test_methods




Overview
Explore in AI Chat

Overview

GMD_TEST_METHODS_PVT is an Oracle Application Object Library (APPS) private PL/SQL package in Oracle E-Business Suite. It belongs to the Oracle Process Manufacturing (OPM) Quality Management module and serves as the private API layer for the GMD_TEST_METHODS entity, which stores the definitions of laboratory test methods used to qualify and analyze materials, products, and batches. The package operates against the base table GMD_TEST_METHODS and its associated translation and language tables, encapsulating the row-level DML, concurrency locking, and multi-language maintenance logic that higher-level public APIs and forms depend upon. Because it is classified as a PVT (private) package, it is not intended as a published integration interface; instead it provides controlled, reusable data manipulation routines for internal OPM Quality components. Within the 12.1.1 and 12.2.2 releases, the package remains schema-owned by APPS and carries a VALID status, confirming it is compiled and available at runtime.

Key Procedures and Functions

The package exposes eight documented entry points covering the full lifecycle of a test method record and its translations:

  • INSERT_ROW — Creates a new test method definition record in the underlying entity tables.
  • UPDATE_ROW — Modifies attributes of an existing test method record.
  • LOCK_ROW — Acquires a row-level lock to enforce concurrency control before an update, preventing simultaneous modification conflicts.
  • DELETE_ROW — Removes an existing test method record, subject to referential and integrity checks.
  • FETCH_ROW — Retrieves a single test method record, returning its column values to the calling program for display or processing.
  • LOAD_ROW — Loads a test method record during data migration, conversion, or bulk seeding operations.
  • TRANSLATE_ROW — Populates or updates the translatable (multi-language) attributes of a test method definition.
  • ADD_LANGUAGE — Inserts translation rows for additional languages supported by the installation.

These procedures mirror the standard Oracle EBS private API pattern, in which TRANSLATE_ROW and ADD_LANGUAGE handle the TL table, while the remaining routines manage the base table and its translations.

Tables Accessed

The package reads and writes the following tables, reached through APPS synonyms:

  • GMD_TEST_METHODS — The primary base table holding test method definitions.
  • GMD_TEST_METHODS_B — The base (non-translatable) table within the standard _B/_TL translatable entity design.
  • GMD_TEST_METHODS_TL — The translation table storing language-specific text for each test method.
  • FND_LANGUAGES — The Application Object Library table of installed and available languages, consulted by the language-related routines.
  • DUAL — The standard Oracle dummy table, typically used for sequence lookups or single-value selects.

The _B and _TL pairing confirms that test method definitions support multi-language installations, consistent with the presence of TRANSLATE_ROW and ADD_LANGUAGE.

Usage Notes

GMD_TEST_METHODS_PVT is referenced by the public package GMD_RESULTS_GRP and by itself, reflecting its role as a shared internal component of the OPM Quality data model. It is typically invoked indirectly: OPM Quality forms and concurrent programs call public APIs or loaders, which in turn call these private routines to insert, lock, update, delete, fetch, translate, and load test method records. Direct invocation from custom code is generally discouraged because the package is private and its signatures are not part of Oracle's supported integration surface. When organizations perform data conversion or migration of test method master data, the documented procedures are exercised through Oracle's supported loaders rather than called directly. Because the package is fully compiled and VALID, administrators can rely on it as the current implementation for the GMD_TEST_METHODS entity in both EBS 12.1.1 and 12.2.2.