Search Results gem5_summ_inv_id_s

Overview

GMI_SUMM_INV_DB_PVT is a private PL/SQL package body owned by the APPS schema in Oracle E-Business Suite. Its documented purpose is to hold the private DML procedures used to create and maintain IC_SUMM_INV transactions within the Oracle Process Manufacturing (OPM) inventory summarization architecture. The package is classified as PVT (private), meaning it is not intended to be called directly from external code; it is invoked by the public wrapper package that owns the business validation layer.

The header comment (GMIVSUMB.pls, version 115.8, last modified 2002) describes the package as containing "private definitions For DML Actions For IC_SUMM_INV." The body implements incremental quantity accumulation logic against the summary inventory table rather than replacing row values, which is essential for maintaining accurate on-hand balances as transactions are posted.

Key Procedures and Functions

• UPDATE_IC_SUMM_INV — Performs an incremental update of an IC_SUMM_INV row. The documented source shows that quantities are accumulated (for example, onhand_qty = onhand_qty + p_summ_inv.onhand_qty) rather than overwritten. A significant documented behavior is the use of NVL on all qty2 (secondary unit of measure) fields, introduced under Bug 1662876 and refined under Bug 2043337, because pending transactions may carry NULL qty2 values. The procedure branches on p_summ_inv.qc_grade being NULL. It returns BOOLEAN and contains an error-handling block using err_num and err_msg.
• INSERT_IC_SUMM_INV — Creates a new IC_SUMM_INV summary row when no existing record is available to update. It supplies the primary key from the sequence and initializes the quantity columns.
• GET_LOT_ATTRIBUTES — Retrieves lot-level attributes, including lot status, by reading the IC_LOTS_STS table. This function is the documented source for the v_lot_status value referenced by callers, providing the quality/inventory status of a lot so that summary quantities can be segregated correctly.

Tables Accessed

• IC_SUMM_INV — The primary target table. It stores summarized on-hand quantities by inventory item, lot, subinventory, and related dimensions. The package inserts new rows and incrementally updates existing rows in this table.
• IC_LOTS_STS — The lot status table, read by GET_LOT_ATTRIBUTES to resolve lot status and related lot attributes. This is the table behind the v_lot_status search term.
• GEM5_SUMM_INV_ID_S — The sequence used to generate the IC_SUMM_INV primary key on insert.
• DUAL — Used for single-row PL/SQL evaluation and sequence access.

All tables are referenced through APPS synonyms, in keeping with EBS naming standards.

Usage Notes

Because this package is private, it is not called directly from forms, concurrent programs, or customer extensions. It is invoked by one other package (the public API), which validates inputs and then delegates the physical DML to GMI_SUMM_INV_DB_PVT. Typical invocation paths are OPM inventory transaction processing, lot status maintenance, and inventory summarization concurrent programs.

Developers investigating v_lot_status should understand that lot status is resolved through GET_LOT_ATTRIBUTES against IC_LOTS_STS and drives whether a summary row is treated as quality-controlled (qc_grade is NULL versus populated). Custom code should call the public wrapper, never this body directly, to preserve the qty2 NULL-handling and incremental accumulation semantics documented above.