Search Results gmd_qc_tests_grp




Overview
Explore in AI Chat

Overview

GMD_QC_TESTS_GRP is a PL/SQL group-layer API within the Oracle E-Business Suite Process Manufacturing (OPM) Quality module. It is owned by the APPS schema and declared with AUTHID CURRENT_USER, meaning that execution privileges are evaluated against the calling schema. The header identifies the package owner as Mahesh Chandak, with an original creation date in July 2002 and a header revision dated May 2004 (115.8).

The package encapsulates the business logic required to define, validate, and maintain Quality Control test definitions. A "test" in OPM Quality represents a measurable quality characteristic (for example, a chemical assay, a physical property, or a microbiological count) used to evaluate samples, specifications, and sampling events. The group layer sits above the base table API layer, providing set-based and cross-entity operations such as validating expressions that reference multiple tests, populating global temporary structures for concurrent or bulk processing, and returning collections of test identifiers. The package is referenced by four other packages in the EBS codebase, which confirms its role as a shared utility rather than an end-user-facing component.

Key Procedures and Functions

The ETRM metadata documents fifteen procedures and functions. The following are explicitly described in the source excerpt:

  • CHECK_TEST_EXIST — Determines whether a given test_code or test_id already exists in the system. It accepts an initialization message list flag and either a test code or a test identifier, and returns a Boolean indicating existence. This supports uniqueness validation during test definition and cross-referencing.
  • GET_TEST_ID_TAB — Returns a PL/SQL associative array of type exp_test_id_tab_type, indexed by BINARY_INTEGER and holding numeric test identifiers. This allows callers to work with test IDs as a set rather than issuing row-by-row queries.
  • VALIDATE_EXPRESSION — Validates whether a supplied expression is mathematically well-formed and, in addition, verifies that every test referenced within that expression corresponds to an existing test definition. It returns a table of all distinct tests used in the expression, enabling callers to resolve dependencies.
  • VALIDATE_ALL_EXP_ERROR — Performs validation across expressions and surfaces error conditions, supporting the expression validation workflow.
  • POPULATE_TEST_GRP_GT — Populates the GMD_TEST_GROUP_GT global temporary table, which is the standard OPM mechanism for staging data during concurrent processing and bulk validation.

Additional documented entry points include NAME (typically a version or identifier helper) and the type declaration exp_test_id_tab_type. Parameter lists are intentionally not reproduced here.

Tables Accessed

The package reads and writes the principal OPM Quality base and translation tables through APPS synonyms:

Usage Notes

As a GRP-class API, GMD_QC_TESTS_GRP is not intended to be called directly from the user interface. It is invoked by the OPM Quality forms (such as the Quality Tests and Specifications setup forms), by concurrent programs that validate and load test definitions, and by other PL/SQL packages — four packages are documented as referencing it. Customizations and extensions should call the package rather than modifying base tables directly, because the validation and staging logic maintains referential and expression integrity. Callers should supply an appropriate p_init_msg_list value ('T' to initialize the message stack, 'F' otherwise) and inspect the message stack for errors after execution, consistent with standard EBS API conventions.