Search Results gme_update_step_qty_pvt




Overview
Explore in AI Chat

Overview

GME_UPDATE_STEP_QTY_PVT is a private PL/SQL package in the APPS schema belonging to the Oracle Process Manufacturing (OPM/GME) module of Oracle E-Business Suite. It provides the core quantity recalculation and step-update engine for batch manufacturing. In OPM terminology, a "step" is a discrete operation within a batch routing, and each step carries planned, actual, pending, and charge-related quantities for activities and resources. This package is responsible for recalculating step quantities from mass/volume data, propagating quantity changes to activities and resources, regenerating resource transactions, and adjusting pending versus actual material usage and resource charges when a batch step is created, modified, released, completed, or reverted.

The "PVT" classification confirms it is a private (internal) API, intended to be called by other OPM public packages rather than directly by customers or external integrations. Its status is VALID in the ETRM documentation, and it is maintained as a compiled package plus package body.

Key Procedures and Functions

The documented package exposes eleven procedures/functions, all centered on batch step quantity maintenance:

Tables Accessed

The package reads and writes the primary OPM batch structures: GME_BATCH_HEADER (batch-level context), GME_BATCH_STEPS (the step being updated), GME_BATCH_STEP_ACTIVITIES (activity quantities), GME_BATCH_STEP_RESOURCES (resource quantities), GME_BATCH_STEP_CHARGES (charge amounts), GME_BATCH_STEP_DEPENDENCIES (step sequencing/dependencies), and GME_RESOURCE_TXNS with its global temporary counterpart GME_RESOURCE_TXNS_GTMP (resource transaction generation). GEM5_POC_TRANS_ID_S supplies transaction identifiers via sequence. MTL_UNITS_OF_MEASURE and MTL_UOM_CONVERSIONS are used for unit-of-measure conversion when deriving mass and volume quantities. DUAL supports scalar calculations, and PLITBLM is an OPM internal PL/SQL table type used for passing collections.

Usage Notes

GME_UPDATE_STEP_QTY_PVT is never invoked directly from forms or concurrent programs. It is called programmatically by higher-level OPM packages, as reflected in its dependency list of 13 referencing packages, including GME_CREATE_BATCH_PVT, GME_CREATE_STEP_PVT, GME_COMPLETE_BATCH_STEP_PVT, GME_RELEASE_BATCH_STEP_PVT, GME_UNRELEASE_STEP_PVT, GME_REVERT_BATCH_PVT, GME_SCALE_BATCH_PVT, GME_INCREMENTAL_BACKFLUSH_PVT, GME_MATERIAL_DETAIL_PVT, GME_RESOURCE_ENGINE_PVT, GME_BATCHSTEP_ACT_PVT, and GME_API_GRP. Customizations that must alter step quantity behavior should be routed through these public calling APIs rather than modifying this private package, since it is subject to change between releases (12.1.1 and 12.2.2) and forms part of the seeded OPM codebase.