Search Results gmd_customer_tests




Overview
Explore in AI Chat

Overview

The APPS.GMD_QC_TESTS_PUB package is a public PL/SQL API within the Oracle E-Business Suite Process Manufacturing (OPM) module, responsible for managing quality control test definitions and customer-specific test assignments. In the Oracle EBS 12.1.1 and 12.2.2 environments, this package serves as the programmatic entry point for creating, maintaining, and removing quality control test headers and their associated value records, as well as defining which tests are applicable to specific customers. The package is classified as PUB (public), indicating that it is intended for external invocation by forms, concurrent programs, workflows, and custom extensions rather than being restricted to internal package use. It is owned by the APPS schema and holds a VALID status in the ETRM 12.2.2 metadata repository. A notable characteristic of this package is that it is referenced by zero other packages, meaning it is a leaf-level API intended to be called directly from client code. The dependency list confirms it relies on the standard Oracle Application Object Library API framework (FND_API) and the STANDARD package for standard error handling and message conventions.

Key Procedures and Functions

The package exposes four documented procedures, each targeting a distinct aspect of quality control test management:

  • CREATE_TESTS — Creates new quality control test definitions, populating the test header and associated parameter or specification records required for quality inspection activities.
  • DELETE_TEST_HEADERS — Removes quality control test header records, typically the master definition of a test, along with the governing record that anchors its child values.
  • DELETE_TEST_VALUES — Deletes individual test value records associated with a given test, allowing granular removal of specification values without deleting the parent test definition.
  • DELETE_CUSTOMER_TESTS — Removes the association between quality control tests and specific customers, effectively revoking a test assignment that had been configured for a particular customer.

The presence of DELETE_CUSTOMER_TESTS is directly relevant to the user's search term "gmd_customer_tests," as this procedure operates on the GMD_CUSTOMER_TESTS table and represents the documented interface for managing customer-specific test linkages.

Tables Accessed

The package interacts with the following tables through APPS synonyms:

  • GMD_QC_TESTS — The core quality control test definition table; read and written by CREATE_TESTS and DELETE_TEST_HEADERS.
  • GMD_QC_TEST_VALUES — Stores individual test values or specification parameters belonging to a test; manipulated by DELETE_TEST_VALUES and populated during test creation.
  • GMD_CUSTOMER_TESTS — Maps quality control tests to specific customers; the target of DELETE_CUSTOMER_TESTS and maintained when customer-specific test assignments are created.
  • PLITBLM — The PL/SQL integer table type used internally for passing collections (such as lists of IDs) into the API procedures.

These tables form the OPM quality control test configuration data model, ensuring that test definitions, their values, and customer assignments remain consistent.

Usage Notes

GMD_QC_TESTS_PUB is typically invoked from Oracle Forms within the Process Manufacturing Quality module, from concurrent programs performing bulk test maintenance, or from custom PL/SQL code that needs to programmatically create or delete quality control tests and customer test assignments. Because it is a public API dependent on FND_API, callers should follow standard Oracle API conventions: initialize the FND_GLOBAL environment, supply the mandatory p_api_version argument, and inspect the returned x_return_status and message stack for errors. The package should not be modified directly; extensions should wrap the API rather than alter it. Given that no other packages reference it, GMD_QC_TESTS_PUB represents the highest-level maintenance interface for these quality control entities within the EBS 12.1.1 and 12.2.2 code lines.