Search Results get_omso_lot_status

Overview

GML_INTORD_LOT_STS is an Oracle EBS PL/SQL package owned by the APPS schema that supports lot status handling for Process Manufacturing (OPM/GML) inventory and internal sales order flows. Its central business purpose is to determine, derive, and apply lot status values as material moves between warehouses, locations, and shipping transactions. The package is declared with AUTHID CURRENT_USER, meaning its unqualified object references resolve against the invoking user's schema, a common convention for EBS APIs that rely on APPS synonyms for underlying OPM and Oracle Inventory tables.

The package is especially relevant to the search term "change_inv_lot_status," because it exposes a dedicated procedure of that name that is intended to transition an inventory lot from one status to another. The header source also reveals two cached profile option values: IC$MOVEDIFFSTAT, used to interpret the default move-difference status, and GMI_INT_ORD_LOT_STS, which governs whether shipping lot status should be retained. These profiles make the package's behavior configurable by installation and by operating context.

Key Procedures and Functions

The package documents three public subprograms:

• DERIVE_PORC_LOT_STATUS — Derives a receipt lot status and determines whether the associated transaction is permitted, based on item, warehouse, lot, location, and the incoming shipping lot status.
• CHANGE_INV_LOT_STATUS — Changes the status of an inventory lot, taking item, warehouse, lot, location, and the target status as inputs and returning status and message data to the caller. This is the procedure most closely associated with the user's search term.
• GET_OMSO_LOT_STATUS — Retrieves lot status information for an Order Management sales order line, returning results into the package's lot status PL/SQL table type.

The package also defines the record type LOT_STS_REC (lot identifier and status), the table type LOT_STS_TABLE, and the global variable G_lot_sts_tab used to cache lot status values across calls.

Tables Accessed

The package references the following APPS-synonym objects, reflecting its dual OPM and Oracle Inventory scope:

• IC_ITEM_MST, IC_LOTS_MST, IC_LOCT_INV, IC_WHSE_MST — OPM item, lot, location inventory, and warehouse masters used to validate the item, lot, warehouse, and location inputs and to read current inventory quantities and statuses.
• IC_TRAN_PND, IC_JRNL_MST, IC_ADJS_JNL — OPM pending transaction, journal, and adjustment journal tables, used when a status change requires a corresponding inventory transaction record.
• GMA_REASON_CODE_SECURITY, SY_REAS_CDS — Reason code and reason code security tables, ensuring that status changes are tied to authorized reason codes.
• OE_ORDER_LINES_ALL — Order Management sales order lines, supporting the GET_OMSO_LOT_STATUS procedure.
• SY_ORGN_MST — Organization master data.
• PLITBLM — The standard EBS message table used to return user-facing error and information messages.

Usage Notes

GML_INTORD_LOT_STS is an internal API rather than a user-facing interface. It is typically invoked from OPM inventory forms, internal sales order shipment logic, and custom PL/SQL code that must programmatically adjust lot status or determine the appropriate status during receipt and order processing. The referenced-by metadata indicates at least one other package depends on it, confirming its role as a shared utility within the OPM integration layer.

Developers calling these procedures should respect the documented profile options and always inspect the returned x_return_status and x_msg_data values before committing any surrounding transaction, since the procedures signal failures through these output parameters rather than by raising exceptions.