Search Results update_serial_temp

Overview

INV_TRANSFER_ORDER_PVT is a private PL/SQL package in the APPS schema that encapsulates the core business logic for internal material transfer orders (also known as move orders) within Oracle Inventory. The _PVT suffix indicates an internal application programming interface: the package is not published for direct third-party calls but rather supports the public INV_MOVE_ORDER_PUB layer, Oracle Forms, and other Inventory modules that create, validate, and process transfer orders. Its responsibilities span header and line identifier generation, uniqueness validation, transfer order processing and locking, subinventory and lot/serial validation, and cleanup of the temporary and reservation data created during the transfer flow. In short, it is the workhorse routine set beneath the transfer order (move order) user interface and the public move order API.

Key Procedures and Functions

• INCREMENT_MAX_LINE_NUMBER / RESET_MAX_LINE_NUMBER — manage the cached maximum line number used to assign sequential transfer order line numbers.
• GET_NEXT_HEADER_ID — obtains the next header identifier from the MTL_TXN_REQUEST_HEADERS_S sequence for a new transfer order.
• UNIQUE_ORDER / UNIQUE_LINE — validation functions that confirm a proposed header or line identifier does not already exist.
• PROCESS_TRANSFER_ORDER — the central routine that processes a transfer order (creating/updating the header, lines, and related transaction request data).
• LOCK_TRANSFER_ORDER — acquires a lock on the transfer order record to serialize concurrent processing.
• GET_TRANSFER_ORDER — retrieves transfer order header/line attributes for downstream processing.
• VALIDATE_FROM_SUBINVENTORY / VALIDATE_TO_SUBINVENTORY — validate that the source and destination subinventories exist and are permissible for the transaction.
• UPDATE_TXN_SOURCE_LINE — updates the originating source line linkage on the transaction request line.
• FINALIZE_PICK_CONFIRM — completes the pick confirmation step of the transfer order flow.
• KILL_MOVE_ORDER — terminates a move order, reversing associated processing state.
• CLEAR_PICKED_QUANTITY / CLEAN_RESERVATIONS — reset picked quantities and release reservations associated with the order.
• UPDATE_LOTS_TEMP / UPDATE_SERIAL_TEMP / ADJUST_SERIAL_NUMBERS_IN_MSNT — synchronize lot and serial number data between the temporary transaction tables and the permanent serial number tables.

Tables Accessed

The package reads and writes transfer order data through APPS synonyms, principally MTL_TXN_REQUEST_HEADERS, its sequence-based shipper MTL_TXN_REQUEST_HEADERS_S, and MTL_TXN_REQUEST_LINES. Supporting lookups and validations reference MTL_SECONDARY_INVENTORIES (subinventory validation), MTL_SYSTEM_ITEMS and MTL_SYSTEM_ITEMS_B (item attributes), MTL_PARAMETERS (organization-level Inventory setup), and WIP_ENTITIES. Reservation management uses MTL_RESERVATIONS. Lot and serial handling touches MTL_LOT_NUMBERS, MTL_TRANSACTION_LOTS_TEMP, MTL_SERIAL_NUMBERS, MTL_SERIAL_NUMBERS_TEMP, and MTL_MATERIAL_TRANSACTIONS_TEMP. FND_TABLES is referenced, most likely for descriptive flexfield or attribute-column resolution.

Usage Notes

INV_TRANSFER_ORDER_PVT is invoked indirectly by the Transfer Order (move order) forms such as INV_TO_FORM_TROHDR and INV_TO_FORM_TROLIN, by the public INV_MOVE_ORDER_PUB API, and by the validation packages INV_VALIDATE_TROHDR and INV_VALIDATE_TROLIN. It is referenced by twenty other packages, including INV_KANBAN_PVT, INV_MINMAX_PVT, INV_MO_BACKORDER_PVT, WMS task and wave planning packages, and WSH_USA_INV_PVT, confirming its role as a shared internal service across Inventory, Warehouse Management, and shipping flows. Because the package is classified as PVT, custom code should not call it directly; integrations should use the supported public API layer, since procedure signatures and behavior are not guaranteed across releases. On both EBS 12.1.1 and 12.2.2 the object status is VALID, and no parameter-level contract is published in the data dictionary metadata.