Search Results set_fromsub_rec

Overview

APPS.INV_CACHE is a global PL/SQL caching package within the Oracle Inventory module. Its purpose is to provide session-level, in-memory storage of frequently accessed master and transactional data, avoiding repeated queries against base tables during high-volume transactions such as pick release, move order processing, material transactions, and onhand maintenance. The package exposes public global variables — most notably fromsub_rec and tosub_rec, both declared as MTL_SECONDARY_INVENTORIES%ROWTYPE — that hold a complete row of secondary inventory metadata for the source and destination subinventories respectively. Companion set_* functions populate these globals so that downstream logic can reference attributes such as locator control, asset subinventory flags, and picking defaults without issuing redundant lookups. The package is documented under ETRM 12.2.2 as a non-API utility classification (OTHER) and is referenced by 88 other packages, confirming its role as a foundational internal cache used broadly across Inventory, Shipping, and Order Management flows.

Key Procedures and Functions

The package implements a family of SET_* functions, each returning BOOLEAN to indicate successful population of a corresponding global record:

• SET_ORG_REC — Loads MTL_PARAMETERS organization attributes into org_rec, keyed by organization ID or code.
• SET_ITEM_REC — Populates item_rec from MTL_SYSTEM_ITEMS for a given organization and item.
• SET_TOSUB_REC and SET_FROMSUB_REC — Populate the destination (tosub_rec) and source (fromsub_rec) secondary inventory globals from MTL_SECONDARY_INVENTORIES. These are central to transfer and pick-release logic that distinguishes source from destination subinventory attributes.
• SET_MMTT_REC — Loads a pending transaction row from MTL_MATERIAL_TRANSACTIONS_TEMP.
• SET_MOL_REC and SET_MTRH_REC — Cache move order line and header rows from MTL_TXN_REQUEST_LINES and MTL_TXN_REQUEST_HEADERS.
• SET_WDD_REC — Caches a WSH_DELIVERY_DETAILS row, supporting shipping and delivery processing.
• SET_MSO_REC — Populates mso_rec from MTL_SALES_ORDERS.
• SET_MTT_REC, SET_OEH_ID, SET_WMS_INSTALLED, SET_PICK_RELEASE — Support transaction type caching, order header reference, warehouse management system detection, and pick-release mode flagging.
• SET_TO_LOCATOR and SET_TO_SUBINVENTORY — Establish destination locator and subinventory context.
• SET_OOLA_REC (Bug 4171297), SET_WPB_REC (R12 crossdock pegging), SET_LOC_REC and SET_MOQD_STATUS_REC (onhand material status support), and SET_PJM_ORG_PARMS_REC — Extend caching to order lines, picking batches, item locations, onhand quantities detail, and project organization parameters.

Tables Accessed

The package reads referenced APPS synonyms including MTL_PARAMETERS, MTL_SECONDARY_INVENTORIES, MTL_SYSTEM_ITEMS, MTL_MATERIAL_TRANSACTIONS_TEMP, MTL_TXN_REQUEST_HEADERS, MTL_TXN_REQUEST_LINES, MTL_TRANSACTION_TYPES, MTL_SALES_ORDERS, MTL_ITEM_LOCATIONS, MTL_ONHAND_QUANTITIES_DETAIL, OE_ORDER_LINES_ALL, WSH_DELIVERY_DETAILS, WSH_PICKING_BATCHES, PJM_ORG_PARAMETERS, and MTL_CLIENT_PARAMETERS. These supply the organizational, item, subinventory, transaction, and shipping attributes held in the global records.

Usage Notes

Because the globals persist for the duration of a database session, the package is intended for reuse within a single transaction flow — typically invoked from forms, concurrent programs, and internal Inventory, Shipping, and Order Management packages that require repeated, consistent access to master data. Callers must invoke the appropriate SET_* function before reading a corresponding global, and should be aware that stale cached values can persist across logical operations within the same session. In Oracle EBS 12.1.1 and 12.2.2, the package is an internal, non-public-API utility; it is not documented for direct customer extension, and customizations should avoid depending on its global state.