Search Results gmi_global_grp




Overview
Explore in AI Chat

Overview

GMI_GLOBAL_GRP is a PL/SQL group package owned by the APPS schema in Oracle E-Business Suite, classified as a Group (GRP) API. It belongs to the Process Manufacturing (GMI) inventory family and, as its header comment states, "contains global inventory functions and procedures." In practical terms, the package provides a single, centralized access layer for retrieving core process-manufacturing inventory master and detail records — items, lots, warehouses, and location inventory balances — without requiring every caller to re-implement the same lookup logic against the underlying GMI tables.

Because it is declared AUTHID CURRENT_USER, the package executes with the privileges of the invoking user rather than the definer, which is the conventional pattern for shared utility code in EBS that must respect the caller's security context. The package was created in October 1998 by M. Godfrey, upgraded to Release 11 in February 1999, and last modified in October 2002 under Bug#2643330, which added the NOCOPY hint to its output parameters. It is documented as API version 2.0.

The metadata reflects the Oracle EBS 12.2.2 release; the object is equally relevant in 12.1.1, where the same GMI inventory constructs apply. The "International Business Support Division" association in the user's search reflects the package's origin within Oracle's TVP (Reading, England) development organization, which produced much of the GMI process-manufacturing codebase.

Key Procedures and Functions

The documented interface exposes six procedures, all oriented toward record retrieval rather than maintenance:

  • GET_ITEM — Retrieves a single inventory item master record by item number, returning the corresponding rows of the item master and its companion CPG (costing/product group) table.
  • GET_LOT — Retrieves a lot master record identified by item, lot number, and sublot number, together with the associated lot CPG row.
  • GET_WAREHOUSE — Retrieves a warehouse master record by warehouse code.
  • GET_LOCT_INV — Retrieves a location inventory record for a given item, warehouse, lot, and location combination. The procedure supports a delete-mark parameter, allowing callers to filter records flagged for deletion.
  • GET_UM — Retrieves unit-of-measure information, drawing on the system UOM master and UOM type tables.
  • GET_LOT_INV — Retrieves lot-level inventory information, complementing GET_LOCT_INV at the lot aggregation level.

Consistent with version 2.0 of the package, output parameters are declared NOCOPY, reducing overhead when returning whole %ROWTYPE structures to the caller.

Tables Accessed

The package reads and writes the following tables through APPS synonyms:

These are the canonical GMI inventory and UOM tables; the package therefore acts as a controlled read access point across the core inventory schema.

Usage Notes

GMI_GLOBAL_GRP is a low-level utility package, invoked programmatically rather than directly by end users. It is referenced by four other packages within the EBS codebase, which use it to obtain item, lot, warehouse, location inventory, and UOM records without duplicating SQL. Typical invocation scenarios include Oracle Forms-based GMI inventory windows, concurrent programs that process inventory transactions or generate reports, and custom extensions or interfaces that must resolve GMI inventory entities consistently. Developers should treat the documented procedures as the supported access path and avoid querying the underlying tables directly when this package already provides the required lookup.