Search Results gmd_customer_tests_grp




Overview
Explore in AI Chat

Overview

GMD_CUSTOMER_TESTS_GRP is an Oracle EBS PL/SQL package body owned by the APPS schema that supports the Quality Management module's customer test functionality. The "GRP" classification designates it as a group or validation package, meaning it centralizes reusable business logic that other Quality Management components (forms, APIs, and related packages) call to enforce data integrity rules against customer-linked specification tests. In process manufacturing and discrete environments, customer tests allow quality specifications to be tied to specific customers or customer sites, so that the appropriate tests are applied when material or product is received or released against a customer's order. This package provides the validation layer that governs the insertion and deletion of such customer test records, ensuring referential integrity with Oracle's Trading Community Architecture (HZ) customer model and the Quality Management test definition tables.

Key Procedures and Functions

The package body exposes three documented procedures:

  • VALIDATE_BEFORE_INSERT — Performs pre-insert validation logic, enforcing business rules and cross-table consistency checks before a new customer test record is committed.
  • VALIDATE_BEFORE_DELETE — Performs pre-delete validation, verifying that a customer test record may be removed without violating dependent data or business constraints.
  • CHECK_EXISTS — A utility routine that determines whether a given customer test record already exists, typically used to prevent duplicates and to drive conditional processing.

Tables Accessed

The package reads and writes the following tables (through APPS synonyms):

  • GMD_CUSTOMER_TESTS — The primary customer test definition table; the package validates and manipulates records here.
  • GMD_QC_TESTS — Quality Management test definitions, referenced to confirm that the specified test is valid.
  • GL_PLCY_MST — The policy master table, used for policy-driven validation logic.
  • HZ_CUST_ACCOUNTS_ALL, HZ_CUST_ACCT_SITES_ALL, HZ_PARTIES — TCA customer account, site, and party tables, used to validate that the customer or site referenced by the customer test is a valid, existing entity.

Usage Notes

Because GMD_CUSTOMER_TESTS_GRP is not referenced by any other database object, it operates as a top-level validation helper rather than as part of a deeper dependency chain. It is typically invoked from Oracle Forms or from custom code that creates and deletes customer test records, or indirectly through the public API layer (GMD_API_PUB, FND_API, and FND_MSG_PUB are among its dependencies, indicating API-style error handling and message publication). The package does not make use of the FND message stack only for fatal errors; it integrates with FND_MSG_PUB to raise and retrieve user-facing messages. When customizing or debugging customer test behavior in EBS 12.1.1 or 12.2.2, this package is the correct starting point for understanding insert and delete validation semantics. Care should be taken not to modify this APPS-owned object directly; extensions should be layered through supported APIs or Oracle Forms personalization.