Search Results delete_pending_transaction

Overview

GMI_OM_UTILITIES_PKG is a Process Manufacturing (OPM) utility package owned by APPS that provides supporting logic between Oracle Order Management/Shipping Execution and the Process Manufacturing inventory and transaction engine. Its documented business purpose is to manage the disposition of Move Order Lines when allocations for those lines must either be removed or backordered. The package body (source file GMIUTOMB.pls, header revision 120.0, dated 2005/05/25) was created on 17-NOV-04 and extended in the same period to add the backorder and delete-allocation functionality for a Move Order Line. The primary entry point, DELETE_ALLOC_BACKORDER_MO_LINE, encapsulates the OPM-specific cleanup and backorder logic that would otherwise have to be duplicated across numerous callers, ensuring consistency in how move order allocations are reconciled with delivery detail records and pending inventory transactions.

Key Procedures and Functions

The package documents a single public program unit: DELETE_ALLOC_BACKORDER_MO_LINE. This function deletes allocations for a Move Order Line when invoked in delete-allocation mode, and backorders the Move Order Line when invoked in backorder mode (identified internally by the p_mode values 'DA' for delete allocations and 'BO' for backorder). It accepts parameters identifying the transaction source line (p_txn_source_line_id) and the line itself (p_line_id), and returns a BOOLEAN to indicate success or failure. Behavior documented in the source: if any allocations exist for the move order line, they are deleted; all affected delivery detail lines are backordered and the screen is refreshed; the move order line is then closed; and the order line status is left unchanged. The routine was introduced to resolve Bug 3874270 and supersedes the earlier functionality created in November 2004.

Tables Accessed

The package operates against three documented tables, each accessed through APPS synonyms. IC_TRAN_PND is the Process Manufacturing pending transaction interface table, holding inventory transactions that have not yet been processed by the transaction engine; the package reads and removes rows associated with the move order line being deleted or backordered. IC_TXN_REQUEST_LINES is the OPM move order (transaction request) line table; the package reads the line and updates or closes its status as part of the operation. WSH_DELIVERY_DETAILS is the Shipping Execution delivery detail table; the package queries delivery detail lines linked to the move order line so they can be backordered and the affected records refreshed. These three tables together represent the full chain from move order request, through shipment staging, to pending inventory transaction.

Usage Notes

DELETE_ALLOC_BACKORDER_MO_Line is typically invoked from OPM Order Management and shipping-related forms, or from custom code, whenever an operator or program must either delete existing allocations against a Move Order Line or backorder that line without altering the containing order line status. Because the function is declared in the package body with the package name as a constant (G_PKG_NAME) and returns BOOLEAN, callers should invoke it as APPS.GMI_OM_UTILITIES_PKG.DELETE_ALLOC_BACKORDER_MO_Line and handle the Boolean result appropriately in PL/SQL. The routine closes the move order line after processing and refreshes the delivery detail screen, so it should be used in place of direct DML against IC_TRAN_PND, IC_TXN_REQUEST_LINES, or WSH_DELIVERY_DETAILS to avoid orphaned allocations and inconsistent transaction engine state. In Oracle EBS 12.1.1 and 12.2.2 this package remains part of the OPM/OM integration layer and is referenced by no other documented packages, so it is essentially a public convenience API for callers that manage move order allocation lifecycle events.