Search Results get_current_event_spec_disp_id

Overview

GMD_DISP_PUB is the public PL/SQL package responsible for managing the disposition of samples and sample groups within the Oracle E-Business Suite Process Manufacturing (OPM) Quality module. Its documented business function is to provide a public layer API for "Changing the disposition of a Sample/Group." Disposition in this context refers to the quality decision applied to a sample or sample group — for example, whether material associated with a sampling event is released, rejected, or placed on hold — and the package encapsulates the validation logic and specification-related lookups required to record that decision consistently.

The package follows Oracle's standard public API conventions: it is owned by APPS, classified as PUB, and its header carries a forward-declaration block for internal routines that support the exposed API. It was created by Ravi Lingappa Nagaraja (16-Jun-2008), with a later revision tag (120.1, 2009/06/08). The body includes a logging helper (set_debug_flag) that inspects FND_LOG.LEVEL_PROCEDURE against the current runtime level, enabling diagnostic tracing without altering business logic.

Key Procedures and Functions

• CHANGE_DISPOSITION — The single documented public entry point. It changes the disposition of a sample or sample group, driving the underlying specification-disposition and results records that OPM Quality uses to determine material status.
• get_current_event_spec_disp_id — An internal function (exposed via forward declaration) that resolves the current event specification disposition identifier for a given entity. Its signature accepts a numeric identifier and a flag indicating whether that identifier refers to a sample. This is the routine users searching the term "get_current_event_spec_disp_id" are typically attempting to locate.
• validate_parentlot_lot and validate_lpn — Internal validation routines declared in the forward section. They accept inventory item, organization, lot, and (for LPN) license plate number information, returning a standard return status, message count, and message data triple. These validations ensure that parent lot/lot relationships and LPN references are legitimate before a disposition change is committed.

Parameter lists are not reproduced here; only the documented purpose of each unit is described.

Tables Accessed

The package reads and writes the core OPM Quality tables via APPS synonyms. GMD_SAMPLES and GMD_SAMPLING_EVENTS anchor the sample and event context. GMD_EVENT_SPEC_DISP and GMD_SAMPLE_SPEC_DISP hold the specification-level disposition values resolved through get_current_event_spec_disp_id and updated by CHANGE_DISPOSITION. GMD_COMPOSITE_SPEC_DISP and GMD_COMPOSITE_RESULTS support composite sample results, while GMD_RESULTS and GMD_SPEC_RESULTS store quality results used in disposition determination. Specification definitions come from GMD_SPECIFICATIONS_B and GMD_SPEC_TESTS_B, with versioned views GMD_INVENTORY_SPEC_VRS, GMD_SUPPLIER_SPEC_VRS, and GMD_WIP_SPEC_VRS. GMD_QUALITY_CONFIG supplies module configuration, and MTL_GRADES participates where grade-based disposition applies.

Usage Notes

GMD_DISP_PUB is invoked whenever disposition is set or changed on a sample or group — most commonly from OPM Quality forms that manage sampling events and result entry, and from concurrent or batch programs performing bulk disposition updates. In Oracle EBS 12.1.1 and 12.2.2 it is a stable, shiphome public API. Custom integrations should call CHANGE_DISPOSITION rather than manipulating GMD disposition tables directly, so that validation logic and standard return-status handling are preserved. The package is referenced by zero other packages, so it is a true leaf-level public API intended for external callers; the internal routines such as get_current_event_spec_disp_id are not part of the supported external contract.