Search Results validate_update_type

Overview

MTL_LOT_UOM_CONV_PVT is an Oracle EBS private (PVT) PL/SQL package belonging to the APPS schema that supports Oracle Inventory lot-level unit of measure conversion functionality. Its principal business purpose is to validate, process, and copy lot-specific UOM conversion rules that define how quantities are converted between units of measure for a given inventory item and lot. These conversions are critical in process manufacturing and regulated industries, where conversion factors can vary by lot rather than being fixed at the item level. The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the calling user, and it is intended for internal consumption by other Inventory packages rather than direct customer invocation.

The most distinctive element surfaced by the "edr_eres_enabled" search term is the package global G_ERES_ENABLED, initialized from the profile option EDR_ERES_ENABLED with a default of 'N'. This flag reflects the Electronic Records and Electronic Signatures (ERES) capability, used to enforce 21 CFR Part 11 compliance for validated environments. When ERES is enabled, the conversion-processing logic must capture electronic signature and audit information. The package also defines two constants, G_TRUE (1) and G_FALSE (0), used as standardized boolean return values. The header indicates the source file INVVLUCS.pls.

Key Procedures and Functions

• VALIDATE_UPDATE_TYPE — Accepts an update type value and returns a numeric result indicating whether the supplied update type is valid for the requested conversion operation.
• VALIDATE_LOT_CONVERSION_RULES — Validates lot conversion rules for a specific organization, item, lot number, and from/to UOM combination, taking quantity update and update type parameters plus an optional header identifier, and returns a numeric validity result.
• PROCESS_CONVERSION_DATA — The core processing routine. It performs the requested action against a lot UOM class conversion record and quantity update record set, returning standard status, message count, message data, and sequence outputs. It is the primary driver for applying, creating, or modifying lot-level conversions.
• COPY_LOT_UOM_CONVERSIONS — Copies lot UOM conversion definitions from a source organization and lot number to a target organization and lot number, including user and creation date attributes, with an optional commit flag and standard return-status outputs.
• VALIDATE_ONHAND_EQUALS_AVAIL — Checks that on-hand and available quantities reconcile for the specified organization, item, lot, and header before permitting a conversion change.

Tables Accessed

The package reads and writes MTL_LOT_UOM_CLASS_CONVERSIONS, the base table holding lot UOM conversion definitions, and MTL_LOT_CONV_AUDIT_DETAILS together with the MTL_CONV_AUDIT_ID_S and MTL_CONV_AUDIT_DETAIL_ID_S sequences, which record audit history for conversion changes. It validates against MTL_SYSTEM_ITEMS, MTL_PARAMETERS, and MTL_LOT_NUMBERS. On-hand and transaction validation draws on MTL_MATERIAL_TRANSACTIONS, its _S and _TEMP variants, MTL_TRANSACTION_LOT_NUMBERS, MTL_TRANSACTION_LOTS_TEMP, MTL_TRANSACTIONS_INTERFACE, and GME_TRANSACTION_PAIRS. FND_DUAL is referenced for lightweight DML-based validation. Together these tables support rule validation, audit capture, and inventory quantity verification.

Usage Notes

As a PVT package, MTL_LOT_UOM_CONV_PVT is not called directly by end users; it is invoked by public Inventory APIs, concurrent programs, and Oracle Forms that manage lot UOM conversions. The ETRM metadata records that it is referenced by four other packages, confirming its role as a shared internal service layer. Customizations requiring lot conversion processing should call the public wrapper MTL_LOT_UOM_CONV_PUB where available rather than this private package. When EDR_ERES_ENABLED is set to 'Y', callers should expect the package to participate in electronic signature and audit-trail behavior consistent with Oracle's ERES framework.