Search Results update_sample_comp_disp

Overview

GMD_DISP_GRP is a Group-layer PL/SQL package owned by APPS in the Oracle E-Business Suite Process Manufacturing (OPM) product family. The package name follows the OPM naming convention in which the "GRP" suffix denotes a Group API layer: a thin, business-oriented wrapper that sits above the individual entity APIs and coordinates disposition changes across the related Process Quality and sample-management entities. Its declared purpose, as stated in the package header, is to provide Group-layer APIs for changing the disposition of a Sample or Sample Group. In OPM, disposition governs the quality state of a sample or a composite, including its QC status, grade assignment, and lot status. The package was created in June 2008 by Ravi Lingappa Nagaraja and its PL/SQL specification carries the revision marker 120.0.12010000.1, consistent with its use in EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

The package exposes two documented public procedures. Both follow the standard OPM API calling convention, returning status and message information through output parameters (conventionally X_RETURN_STATUS and X_MESSAGE_DATA) rather than raising business errors to the caller.

• UPDATE_SAMPLE_COMP_DISP — Updates the disposition assigned to a sample component. It accepts an update record of type Gmd_Samples_Grp.update_disp_rec together with the target disposition value, and reports the outcome through the standard return status and message data output parameters. This is the procedure associated with the search term "update_sample_comp_disp."
• UPDATE_LOT_GRADE_BATCH — Performs a coordinated update of lot status, grade code, and QC status for a sample or composite specification disposition. Its parameters carry default NULL values for the sample identifier, composite specification disposition identifier, and grade codes, and it accepts a reason identifier and a hold date defaulting to SYSDATE. The procedure exists to apply quality decisions consistently across the batch, lot, and grade attributes of the affected item.

Tables Accessed

The ETRM metadata for this package does not enumerate the base tables it touches through APPS synonyms. Functionally, the disposition of a sample component referenced by UPDATE_SAMPLE_COMP_DISP is held in the OPM sample and quality disposition tables (the same structures surfaced through Gmd_Samples_Grp), while UPDATE_LOT_GRADE_BATCH necessarily writes to the OPM lot, grade, and QC status tables that record lot status, grade codes, and quality control results. Because the package is declared AUTHID CURRENT_USER and is invoked from the APPS schema, all underlying object references resolve through APPS synonyms.

Usage Notes

GMD_DISP_GRP is an internal Group-layer API, not a user-facing form entry point. It is intended to be called from custom PL/SQL or from other OPM packages rather than invoked directly from a form or concurrent program. The ETRM metadata records that the package is referenced by one other package, indicating it functions as a shared service consumed elsewhere in the OPM quality stack. When calling either procedure, custom code must supply the standard output parameters and inspect X_RETURN_STATUS before acting on X_MESSAGE_DATA; the Group API does not commit on behalf of the caller, so transaction control remains the caller's responsibility. Because the API is AUTHID CURRENT_USER, privilege checking is performed against the invoking schema, and integrations should therefore be run under APPS or an appropriately privileged account.