Search Results gmo_dispensing_planning_s

Overview

GMO_SWORKBENCH_PVT is a private PL/SQL package body in the APPS schema that supports the Oracle E-Business Suite Process Manufacturing (OPM) Shop Floor Workbench. The package encapsulates business logic for shop floor task execution, material reservation, and dispensing planning activities performed by production operators and supervisors. It belongs to the GMO (Process Manufacturing Shop Floor) module family and is classified as a PVT (private) API, meaning it is intended for internal consumption by the Shop Floor Workbench forms and related components rather than for direct external invocation.

The package depends on a broad set of OPM and Oracle Inventory constructs, including GME_BATCH_HEADER and GME_MATERIAL_DETAILS (batch and material detail processing), GMO_DISPENSING_PLANNING and its synonym GMO_DISPENSING_PLANNING_S (dispensing plan maintenance), GMO_DISPENSE_AREA_B (dispense area definitions), and the reservation APIs INV_RESERVATION_GLOBAL and INV_RESERVATION_PUB. It also leverages shared utilities GME_COMMON_PVT, GMO_UTILITIES, and GMO_CONSTANTS_GRP, along with FND_API and FND_MESSAGE for the standard EBS API error and messaging framework.

Key Procedures and Functions

The package body exposes thirteen documented procedures and functions, organized around reservation management and task progress calculation.

• UPDATE_PLANNING_STATUS — Updates the status of dispensing planning records, reflecting progress through the shop floor planning lifecycle.
• GET_TASK_PERCENTAGE — Returns the completion percentage for a given task, used to display progress in the workbench.
• GET_WEEKLY_TASK_PERCENTAGE — Returns task completion percentage on a weekly basis, supporting time-phased progress reporting.
• GET_HOURS — Calculates or converts a duration value into hours.
• GET_MINUTES — Calculates or converts a duration value into minutes.
• GET_DAYS — Calculates or converts a duration value into days.
• CREATE_MATERIAL_RESERVATION — Creates a reservation against on-hand inventory for batch materials, invoking Oracle Inventory reservation APIs.
• VALIDATE_MTL_FOR_RESERVATION — Validates that material and inventory conditions satisfy the requirements for reservation before the reservation is attempted.
• UPDATE_RESERVATION — Modifies an existing material reservation, typically to adjust quantities or status.
• QUERY_RESERVATION — Retrieves reservation details for display or downstream processing.

The GET_HOURS, GET_MINUTES, and GET_DAYS utilities provide consistent time-unit conversion reused by the percentage calculations.

Tables Accessed

The package reads and writes several core OPM and Inventory tables through APPS synonyms:

• GME_MATERIAL_DETAILS — Material requirements and consumption details for batches; the basis for reservation and dispensing logic.
• GME_BATCH_HEADER — Batch master records that anchor task and material activity.
• GMO_DISPENSING_PLANNING / GMO_DISPENSING_PLANNING_S — Dispensing plan headers and lines whose status is maintained by UPDATE_PLANNING_STATUS.
• GMO_DISPENSE_AREA_B — Dispense area base table definitions used to organize dispensing operations.
• MTL_RESERVATIONS — Inventory reservations created, validated, updated, and queried by the reservation procedures.
• MTL_ONHAND_QUANTITIES — On-hand balances referenced during reservation validation.

Usage Notes

Because GMO_SWORKBENCH_PVT is a private package, it is invoked indirectly by the Shop Floor Workbench forms and related OPM concurrent or UI components rather than being called directly by customers. It is referenced by one other package, and the dependency metadata indicates it is not itself referenced by any database object outside the APPS schema. Standard EBS API conventions apply: callers should expect FND_API-style error handling and FND_MESSAGE-based error text, and any custom code that must interact with this package should do so with awareness that private APIs are not guaranteed to remain stable across patches or upgrades.