Results for “serial_number_status”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

INV_LABEL_PVT2 is a private PL/SQL package body in the Oracle E-Business Suite Inventory (INV) module, invoked through the APPS schema. It participates in the label printing infrastructure that generates barcode- and text-based label output for material transactions, receiving, and serialized or lot-controlled inventory movements. The package name follows the INV_LABEL private-series naming convention, where LABEL_SERIAL, LABEL_LOT, and related label programs delegate to private packages such as this one to resolve variable content that is subsequently merged into label templates. Its role is to gather, evaluate, and format the runtime values that appear on a printed label — receipt numbers, project and task references, lot and serial numbers, subinventory, revision, and cost group identifiers — based on label type configuration and the transaction currently being processed.

The package header cites a File Header revision of 120.26, dated 2011/04/19, indicating the version that shipped with early Release 12.1.x and carried forward into 12.2.x. It references INV_LABEL global constants, FND_GLOBAL for user context and local character handling, and maintains package-level state such as a date format mask, a header-print flag, and the current user name.

Key Procedures and Functions

ETRM documents a single public procedure, GET_VARIABLE_DATA, though the package body also contains a private TRACE procedure used for diagnostic output to the label debug log. GET_VARIABLE_DATA returns a variable collection (of type inv_label.label_tbl_type) representing the name/value pairs consumed by the label template engine. It accepts a label type definition, a transaction identifier, a material transaction temporary row, and a transaction identifier, and returns standard API message and return-status outputs.

Internally the procedure declares local variables for receipt number, delivery detail, project and task identifiers, cost group, inventory item, organization, lot number, serial number, revision, and subinventory. The serial_number_status search term relevant to this object relates to the serial control validation logic executed within this procedure, which resolves serial numbers from the transaction interfaces and confirms their status before inclusion on the label.

Tables Accessed

The procedure reads from MTL_MATERIAL_TRANSACTIONS_TEMP and MTL_MATERIAL_TRANSACTIONS as the primary transaction sources, and from MTL_SERIAL_NUMBERS, MTL_SERIAL_NUMBERS_INTERFACE, and MTL_SERIAL_NUMBERS_TEMP for serialized item detail. Lot-controlled content is sourced from MTL_LOT_NUMBERS, MTL_TRANSACTION_LOTS_INTERFACE, MTL_TRANSACTION_LOTS_TEMP, and MTL_TRANSACTION_LOT_NUMBERS. Organization and cost context derive from MTL_PARAMETERS and CST_COST_GROUPS. MTL_TXN_REQUEST_LINES and MTL_UNIT_TRANSACTIONS supply move-order and unit-level movement data. FND_USER provides the session user name for trace output.

Usage Notes

INV_LABEL_PVT2 is invoked indirectly by the Inventory label printing framework, which is triggered during receiving, subinventory transfer, move-order, and serialized transaction flows when a label format has been assigned to the transaction type. It is not exposed as a standalone concurrent program; instead, it is called from the parent INV_LABEL package logic and from one additional package, as indicated by ETRM. Customizations typically extend GET_VARIABLE_DATA to inject site-specific label variables, and developers should be aware that the procedure's NOCOPY output parameters reflect the package's tolerance for large variable collections without significant memory-pinning overhead.