Search Results ic_lots_cpg_select

Overview

GMIVDBL is a private PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the Process Manufacturing (OPM) inventory application family. Its name reflects its role as the Inventory API Database Layer, a low-level component positioned beneath the public Inventory API processing layers. The package specification header (GMIVDBLS.pls, version 115.11) confirms that it was created for Inventory API Release 3.0 and that its contents are intended to be accessible only from the inventory API processing stack; no public or third-party use is supported.

The package therefore encapsulates the row-level database access logic — simple insert and select operations against the core OPM inventory tables — that the higher API layers call upon. It carries an AUTHID CURRENT_USER declaration, meaning that privileges are evaluated against the invoking user rather than the definer, consistent with its role as an internal helper rather than an application entry point.

Key Procedures and Functions

The documented interface exposes 27 procedures and functions. The majority follow a naming convention of <entity>_insert or <entity>_select, and return BOOLEAN to signal success or failure to the calling API layer. Each operates on a single table row passed in as a %ROWTYPE parameter.

• IC_ITEM_MST_INSERT / IC_ITEM_MST_SELECT — insert and retrieve item master records in IC_ITEM_MST.
• IC_LOTS_MST_INSERT / IC_LOTS_MST_SELECT — insert and retrieve lot master records in IC_LOTS_MST.
• IC_ITEM_CPG_INSERT / IC_ITEM_CPG_SELECT — manage item category/class code group assignments in IC_ITEM_CPG.
• IC_LOTS_CPG_INSERT / IC_LOTS_CPG_SELECT — manage lot-level category/class code group assignments in IC_LOTS_CPG.
• IC_LOTS_STS_SELECT — retrieve lot status information from IC_LOTS_STS.
• IC_JRNL_MST_INSERT / IC_JRNL_MST_SELECT — insert and retrieve inventory journal master rows in IC_JRNL_MST.
• IC_WHSE_MST_SELECT — retrieve warehouse master records from IC_WHSE_MST.
• IC_LOCT_INV_SELECT — retrieve location inventory balances from IC_LOCT_INV; this is the function associated with the user's search term.
• IC_ADJS_JNL_INSERT — insert adjustment journal lines into IC_ADJS_JNL.
• IC_ITEM_CNV_INSERT — insert item conversion records into IC_ITEM_CNV.
• SY_REAS_CDS_SELECT — retrieve reason codes from SY_REAS_CDS.
• SY_UOMS_MST_SELECT / SY_UOMS_TYP_SELECT — retrieve unit-of-measure definitions and UOM types.
• QC_ACTN_MST_SELECT / QC_GRAD_MST_SELECT — retrieve quality action and grade master data used during inventory transactions.

The header history notes that a p_item_rec parameter was added to gmi_item_categories in 2003 so that categories could be inserted for both existing and new class definitions.

Tables Accessed

All tables are referenced through APPS synonyms. The package reads and writes IC_ITEM_MST (item definitions), IC_LOTS_MST and IC_LOTS_STS (lot definitions and status), IC_ITEM_CPG and IC_LOTS_CPG (category assignments at item and lot level), IC_LOCT_INV (on-hand quantities by inventory location), IC_JRNL_MST and IC_ADJS_JNL (journal headers and adjustment lines), IC_ITEM_CNV (item conversions), and IC_WHSE_MST (warehouses). It reads reference data from SY_REAS_CDS, SY_UOMS_MST, and PO_VEND_MST, and quality reference data from QC_ACTN_MST and QC_GRAD_MST.

Usage Notes

GMIVDBL is invoked indirectly. It is referenced by six other packages, which are the public inventory API layers that forms, concurrent programs, and custom code are expected to call. Direct invocation of GMIVDBL is unsupported, and its signatures may change between patch levels without notice. Developers integrating with OPM inventory should use the supported public APIs rather than this database layer.