Search Results v_ship_vendor

Overview

GMIGUTL is a global inventory utility package in the Oracle E-Business Suite (EBS) Process Manufacturing / Oracle Inventory domain, deployed under the APPS schema with AUTHID CURRENT_USER privileges. As stated in its package header, its purpose is to "contain global inventory utility procedures and variables." The package centralizes shared PL/SQL logic used across Oracle Process Manufacturing (OPM) and Oracle Inventory components, providing a single point of maintenance for common lookup and validation routines. The package declares several public global variables, including DEFAULT_USER, DEFAULT_USER_ID, DEFAULT_LOGIN, API_VERSION, DB_ERRNUM, DB_ERRMSG, and a set of configuration flags such as IC$DEFAULT_LOT, IC$DEFAULT_LOT_DESC, IC$DEFAULT_LOCT, IC$ALLOWNEGINV, IC$API_ALLOW_INACTIVE, IC$MOVEDIFFSTAT, and SY$CPG_INSTALL. These globals allow calling modules to reference consistent session-level defaults. Because it is classified as API classification OTHER in the ETRM documentation, GMIGUTL is not a formal public API, but it functions as an internal shared utility layer. The package is referenced by 18 other packages in the EBS codebase, confirming its role as a foundational dependency.

Key Procedures and Functions

The documented functions in GMIGUTL fall into two categories: initialization and lookup/validation.

• SETUP — Initializes the package globals for a given user by supplying a user name. It effectively establishes the session context (default user, default user ID, login) used by subsequent calls.
• V_EXPACTION_CODE — The function the user searched for. It accepts an action code and returns a Boolean indicating whether the corresponding QC action master row was successfully retrieved, with the row returned via an output parameter. It queries QC_ACTN_MST.
• V_QC_GRADE — Validates/retrieves a QC grade record. It accepts a QC grade value and returns the corresponding row from QC_GRAD_MST with a Boolean result.
• V_REASON_CODE — Validates/retrieves a reason code. It accepts a reason code and returns the matching SY_REAS_CDS row with a Boolean result.
• V_SHIP_VENDOR — Retrieves a vendor record. It accepts a vendor number and returns the PO_VEND_MST row with a Boolean result.
• GET_ITEM — Retrieves item information, primarily from IC_ITEM_MST and related item tables.
• GET_LOT — Retrieves lot information from IC_LOTS_MST and related lot tables.
• GET_WAREHOUSE — Retrieves warehouse information from IC_WHSE_MST.
• GET_LOCT_INV — Retrieves location inventory information from IC_LOCT_INV.
• GET_UM — Retrieves unit of measure information from SY_UOMS_MST and SY_UOMS_TYP.
• GET_TRANSFER — Handles transfer-related retrieval logic across inventory structures.
• V_LOT_STATUS — Validates/retrieves lot status information from IC_LOTS_STS.

All functions return BOOLEAN, and output row parameters use NOCOPY semantics (added under Bug#2643440) for performance. The historical note records removal of SY$INTRASTAT and addition of IC$DEFAULT_LOT_DESC under Bug#2343411.

Tables Accessed

GMIGUTL references the following tables through APPS synonyms, reflecting a broad cross-module footprint:

• FND_USER — source of default user name and ID during SETUP.
• IC_ITEM_MST, IC_ITEM_CPG — item master and CPG item extension.
• IC_LOTS_MST, IC_LOTS_CPG, IC_LOTS_STS — lot master, CPG lot extension, and lot status.
• IC_LOCT_INV — location inventory quantities.
• IC_WHSE_MST — warehouse master.
• PO_VEND_MST — vendor master for V_SHIP_VENDOR.
• QC_ACTN_MST, QC_GRAD_MST — quality action and grade masters.
• SY_REAS_CDS — reason code master.
• SY_UOMS_MST, SY_UOMS_TYP — unit of measure definitions and types.

These tables span Inventory, Process Manufacturing, Purchasing, Quality, and System Administration, consistent with a "global inventory utility" scope.

Usage Notes

GMIGUTL is typically invoked indirectly. OPM and Inventory forms and concurrent programs call the wrapper packages that depend on GMIGUTL for lookup resolution and validation. SETUP must be called before other functions to populate DEFAULT_USER, DEFAULT_USER_ID, and DEFAULT_LOGIN. Because it is declared AUTHID CURRENT_USER, it executes with the privileges of the calling user, requiring appropriate grants on the underlying tables. Developers extending OPM/inventory functionality may call these functions from custom code to reuse the same validation logic, but should treat GMIGUTL as an internal utility rather than a supported public API, given its OTHER classification. Any changes should be validated against its 18 referencing packages.