Search Results gmd_disp_pub




Overview
Explore in AI Chat

Overview

GMD_DISP_PUB is a public PL/SQL package owned by the APPS schema in Oracle E-Business Suite, belonging to the Process Manufacturing (OPM) Quality module family. Its name derives from "Disposition," and it exists to manage the disposition status of quality samples, specifications, and results generated within the OPM Quality Management (GMD) schema. Disposition in this context refers to the business decision applied to sampled material — acceptance, rejection, or other configured statuses — that determines whether inventory, WIP, supplier, or specification-versioned material may proceed through the manufacturing lifecycle.

The package is classified as a PUB (public) API, indicating it is intended for external invocation by other application modules, forms, workflows, or custom extensions rather than being restricted to internal use. Its dependency on FND_API confirms that it participates in the Oracle Application Object Library's standard API framework, including the error-handling and messaging conventions (FND_MSG_PUB) that accompany that framework. This makes GMD_DISP_PUB a supported integration point for developers extending quality and disposition workflows.

Key Procedures and Functions

The documented interface exposes a single public procedure:

  • CHANGE_DISPOSITION — Alters the disposition associated with a quality sample, specification, or result record. It is the primary entry point for programmatically transitioning material from one disposition state to another, for example moving a sample from a pending or quarantine state to an approved or rejected disposition. It encapsulates the validation and update logic required to keep disposition data consistent across the underlying result, sample, and specification tables. Because it is exposed as a public API, it is the recommended mechanism for custom code that must change disposition without directly manipulating base tables.

The ETRM metadata documents no additional public procedures or functions in this package; any other programs reside in the package body as private helpers supporting CHANGE_DISPOSITION.

Tables Accessed

GMD_DISP_PUB reads and writes a broad set of OPM Quality and Inventory tables, referenced through APPS synonyms:

Usage Notes

GMD_DISP_PUB.CHANGE_DISPOSITION is typically invoked from OPM Quality forms when a user manually changes a disposition, from concurrent programs that batch-process disposition updates, or from custom PL/SQL extensions and workflow notification handlers that must automate disposition decisions. Because the package follows FND_API conventions, callers should expect it to signal errors through the standard API return status and message stack rather than raising unhandled exceptions.

No other application packages are documented as referencing GMD_DISP_PUB within this release, so it should be treated as a leaf-level public API. Direct DML against the disposition tables is not recommended; the documented procedure is the appropriate integration surface for both Oracle EBS 12.1.1 and 12.2.2 environments.