Search Results validate_lot

Overview

APPS.GMIVLOT is a private PL/SQL package in Oracle E-Business Suite that supports the inventory lot creation functionality. Its stated purpose, per the package header, is to contain "private code for the 'Create Lot' Inventory API." The package is owned by the APPS schema and, in the ETRM metadata for 12.2.2, is classified as an "OTHER" API object rather than a public or standard open interface.

Within the Oracle Process Manufacturing (OPM) / Inventory integration boundary, GMIVLOT serves as a validation utility called during lot creation. It isolates the validation logic from the publicly exposed Create Lot API, allowing the underlying validation rules for lot master and lot copy (CPG) records to be centralized and tuned independently. The package uses AUTHID CURRENT_USER, so it executes with the privileges of the calling user context rather than the definer, consistent with standard EBS API security design. The 2002 header history notes a major restructuring performed for performance reasons (Bug 1294915) and the introduction of NOCOPY hints in 11.5.1J (Bug 2643440), confirming the package has been a performance-sensitive internal component for many releases.

Key Procedures and Functions

The ETRM metadata documents a single procedure for this package:

• VALIDATE_LOT — Validates a lot record prior to creation or update. It accepts a standard EBS API version parameter, a validation-level parameter defaulting to FND_API.G_VALID_LEVEL_FULL, the inbound lot record, and the parent item master and item CPG rows. It returns the validated lot master and lot CPG rows plus the standard API return status, message count, and message data outputs. The NOCOPY hints on the output parameters reduce copying overhead for large PL/SQL records.

No other public procedures or functions are exposed by the package; additional helper logic, if present, is private to the package body and not documented in the ETRM metadata.

Tables Accessed

The package references the following tables through APPS synonyms:

• IC_ITEM_MST — Item master definition; supplies item attributes used to validate that the lot belongs to a valid, lot-controlled item.
• IC_ITEM_CPG — Item-level CPG (cost, planning, grading) attributes; used to validate lot CPG values against item defaults.
• IC_LOTS_MST — Lot master; the destination table for the validated lot record (returned via ic_lots_mst%ROWTYPE).
• IC_LOTS_CPG — Lot CPG attributes; the corresponding validated detail record (returned via ic_lots_cpg%ROWTYPE).
• FND_USER — Application user; likely used for created-by / last-updated-by stamping and audit validation.
• PO_VEND_MST — Supplier master; used where lot records reference a supplier (for example, supplier lot or vendor lot validation).
• QC_ACTN_MST — Quality action codes; used to validate quality-related lot attributes.
• QC_GRAD_MST — Quality grades; used to validate grade assignments on the lot.

Usage Notes

GMIVLOT is not intended to be called directly by end users or external integrations. It is a private helper package invoked internally by the Create Lot Inventory API flow. Because the ETRM metadata records that GMIVLOT is referenced by one other package (and it references no other packages itself), it should be treated as a subordinate component of a larger lot-processing routine rather than a standalone API entry point.

Typical invocation scenarios include inventory forms, concurrent programs, or custom code that ultimately calls the public Create Lot API; GMIVLOT’s VALIDATE_LOT then executes within that call chain. Because the package is defined with AUTHID CURRENT_USER and relies on APPS synonyms to its base tables, callers must run with appropriate APPS-level privileges. Customizations should avoid calling VALIDATE_LOT directly, since its signature and behavior are private implementation details that Oracle may change between 12.1.1 and 12.2.2 without notice.