Search Results get_lot_attributes

Overview

GMI_SUMM_INV_DB_PVT is a private PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It is part of the Oracle Process Manufacturing (OPM) product family and, more specifically, of the Process Inventory / Oracle Inventory (GMI) module. The package encapsulates the Data Manipulation Language (DML) operations performed against the IC_SUMM_INV table, which stores summarized inventory transaction records. The header comment in the source file identifies the package as containing "private definitions For DML Actions For IC_SUMM_INV" and states that its procedures are "used to create IC_SUMM_INV transactions." The package is declared with AUTHID CURRENT_USER, meaning its procedures execute with the privileges of the invoking user rather than the definer. It is classified as a private (PVT) API, so it is intended for internal use by other OPM packages rather than as a public, supported interface for customer extensions. The referenced-by metadata indicates that one other package depends on it, consistent with its role as a low-level DML helper invoked from higher-level business logic.

Key Procedures and Functions

The documented package exposes three program units, all declared as functions returning BOOLEAN:

• UPDATE_IC_SUMM_INV — Updates an existing summarized inventory transaction record. The function accepts a row of IC_SUMM_INV (passed as a %ROWTYPE parameter) containing the new values to apply, and returns a Boolean indicating success or failure. This is the routine associated with the user search term "update_ic_summ_inv."
• INSERT_IC_SUMM_INV — Inserts a new summarized inventory transaction record into IC_SUMM_INV. As with the update routine, it receives an IC_SUMM_INV row and returns a Boolean status.
• GET_LOT_ATTRIBUTES — Retrieves lot status attributes for a given lot status value, returning the corresponding IC_LOTS_STS row through an OUT parameter. This supports the DML routines by supplying lot-related context needed when creating or updating summarized inventory records.

Because the package is private and the metadata is limited, no parameter lists beyond those shown in the source excerpt should be assumed for any routine.

Tables Accessed

• IC_SUMM_INV — The primary target of the package. It holds summarized inventory transaction data, and the update and insert routines write to it. The table's %ROWTYPE is used as the input structure for both DML functions.
• IC_LOTS_STS — Accessed via GET_LOT_ATTRIBUTES to resolve lot status information. This table defines valid lot statuses and their attributes, which are relevant when a summarized inventory record involves lot-controlled material.
• GEM5_SUMM_INV_ID_S — A sequence object referenced by the package, most likely used to generate primary key values for new IC_SUMM_INV rows during inserts.
• DUAL — The standard Oracle single-row table, typically referenced in sequence value retrieval or simple validation logic.

All tables are accessed through APPS synonyms, consistent with the package's ownership in the APPS schema.

Usage Notes

GMI_SUMM_INV_DB_PVT is an internal implementation package. It is not intended to be called directly from Oracle Forms, concurrent programs, or customer-written code. Instead, it is invoked by higher-level OPM packages that manage inventory transaction processing and require summarized inventory rows to be created or maintained. The documented "Referenced by 1 other packages" metadata confirms this dependency pattern. Because it is a private (PVT) API, Oracle does not guarantee its interface across releases, and it may change without notice. Developers investigating behavior related to summarized inventory transactions should trace calls from the public package layer downward to this helper rather than invoking it directly. The AUTHID CURRENT_USER declaration further implies that callers must hold appropriate privileges on the underlying tables at runtime. In EBS 12.1.1 and 12.2.2 environments, this package resides in the APPS schema and is shipped as part of the OPM Process Inventory code set.