Search Results cpg_install

Overview

GMIGUTL is a global inventory utility package body owned by APPS in the Oracle E-Business Suite. It belongs to the Process Manufacturing (OPM) inventory family and supplies shared utility routines and global variables used by other OPM inventory packages. The package header comment describes its purpose as containing "global inventory utility procedures and variables." Its contents list includes Get_Item, Get_Lot, Get_Warehouse, Get_Loct_inv, Get_Um, Setup, and Get_Transfer.

The header revision history indicates active maintenance across multiple 11.5.x releases, addressing bug fixes such as removal of Intrastat profile retrieval, correction of default user ID validation (since 0 is a valid user for sysadmin), addition of a default lot description profile option, and a NOCOPY optimization.

ETRM classifies the API as OTHER, and notes it is referenced by 18 other packages, confirming its role as a low-level shared utility rather than an end-user-facing API.

Key Procedures and Functions

• SETUP — Initializes global constants and variables for the session. It accepts a user name parameter and returns a boolean. It resolves the default user, sets the API version, retrieves LOGIN_ID from FND_PROFILE, and calls GMA_GLOBAL_GRP.Get_who to populate the default user ID.
• GET_ITEM — Retrieves item-related data from the OPM item master and CPG tables.
• GET_LOT — Retrieves lot information, including lot master, CPG, and status details.
• GET_WAREHOUSE — Resolves warehouse information from the warehouse master.
• GET_LOCT_INV — The routine the user searched for. It retrieves location/inventory (loct_inv) information from IC_LOCT_INV, the OPM inventory location table.
• GET_UM — Retrieves unit of measure information from the UOM master and type tables.
• GET_TRANSFER — Returns transfer-related data used in inventory movement processing.
• V_EXPACTION_CODE, V_QC_GRADE, V_REASON_CODE, V_SHIP_VENDOR, V_LOT_STATUS — Documented as package-level objects, typically global variables holding action codes, QC grades, reason codes, ship vendor identifiers, and lot statuses.

Tables Accessed

The package reads and writes documented OPM and shared tables through APPS synonyms:

• FND_USER — user identity resolution during Setup.
• IC_ITEM_MST, IC_ITEM_CPG — item master and item CPG attributes.
• IC_LOCT_INV — inventory location balances used by GET_LOCT_INV.
• IC_LOTS_MST, IC_LOTS_CPG, IC_LOTS_STS — lot master, CPG attributes, and lot status.
• IC_WHSE_MST — warehouse definitions.
• SY_UOMS_MST, SY_UOMS_TYP — unit of measure master and types.
• QC_ACTN_MST, QC_GRAD_MST — quality action and grade codes.
• SY_REAS_CDS — reason codes.
• PO_VEND_MST — ship vendor reference data.

Usage Notes

GMIGUTL is a support package invoked internally by other OPM inventory packages rather than called directly from forms or concurrent programs. Custom code should treat it as a stable internal utility: call Setup once to initialize the session globals before invoking the getter routines, and reference the global variables (such as lot status or action code) after the appropriate retrieval call. Because the package is referenced by 18 other packages, changes to its behavior can have broad downstream impact across OPM inventory processing.