Search Results clean_up_after_rtp

Overview

APPS.RCV_WSH_INTERFACE_PKG is a PL/SQL package in Oracle E-Business Suite Receiving (RCV) and Shipping Execution (WSH) that coordinates the movement of shipping and receiving data between the Warehouse Management / Shipping tables and the Receiving open interface. Its principal responsibility is to convert confirmed shipping transaction data—delivery details, shipped quantities, lot and serial information—into receiving interface records so that receipt transactions can be processed by the standard Receiving Open Interface (ROI) while preserving shipment-receipt traceability.

The package is declared AUTHID CURRENT_USER, which means it executes under the privileges of the calling user rather than the package owner. This design supports direct invocation from concurrent programs, forms, and back-end processes running as APPS. It is referenced by one other package, indicating it is part of a controlled call hierarchy rather than a standalone user-facing API.

Key Procedures and Functions

The package exposes eleven documented procedures. Each is summarized below.

• CREATE_DELIVERY_DETAILS — Populates delivery detail records in preparation for creating receiving interface rows. Inputs include the return organization, interface transaction identifier, lot and serial usage flags, ship-to identifier, and site-use identifier.
• INTERFACE_TO_RCV — Transfers shipment data for a given delivery into the receiving interface, returning a status through the p_return_status output parameter.
• INVOKE_RTP — Invokes the Receiving Transaction Processor (RTP) for a specific interface group, returning a processing status.
• PROCESS_TXN — The procedure most commonly searched for. It drives processing for a given header identifier and returns a status. It functions as the orchestrating entry point that ties together the interface population and RTP invocation steps for a shipment header.
• LOAD_MTL_INTERFACES — Loads inventory open interface rows derived from delivery detail and header information.
• LOAD_RCV_INTERFACES — Loads receiving interface rows for a delivery against a given interface group.
• LOAD_LOT_SERIAL_INTERFACES — Loads lot and serial number interface records, keyed by source, delivery detail, and parent identifier.
• PERFORM_POST_TM_UPDATES — Executes post-transaction updates for a given Transportation Management source and delivery.
• ADJUST_RCV_QUANTITIES — Reconciles receiving quantities against shipped quantities, unit of measure codes, and backup return-to-vendor identifiers used by the RTV project phase 2 logic.
• CLEAN_UP_AFTER_RTP — Removes residual staging data for a delivery and interface group once the Receiving Transaction Processor has completed.
• CANCEL_RTV_LINES — Cancels return-to-vendor interface lines using a collection of interface transaction identifiers declared with the RTI_id_tbl index-by table type.

Tables Accessed

The package reads from and writes to a broad set of Receiving, Shipping, Inventory, and Purchasing tables, all through APPS synonyms:

• WSH_DELIVERY_DETAILS — Source of shipped delivery detail rows driving interface creation.
• RCV_TRANSACTIONS_INTERFACE and MTL_TRANSACTIONS_INTERFACE — Target open-interface staging tables populated for processing.
• MTL_MATERIAL_TRANSACTIONS and MTL_MATERIAL_TRANSACTIONS_S — Inventory transaction results and their sequence source.
• MTL_TRANSACTION_LOTS_INTERFACE, MTL_TRANSACTION_LOTS_TEMP, MTL_SERIAL_NUMBERS, MTL_SERIAL_NUMBERS_INTERFACE, and MTL_SERIAL_NUMBERS_TEMP — Lot and serial control staging and validation.
• MTL_SYSTEM_ITEMS, MTL_PARAMETERS, and MTL_UNITS_OF_MEASURE — Master data for item validation, organization defaults, and UOM conversion.
• AP_SUPPLIER_SITES_ALL and PO_LINES_ALL — Supplier site and purchase order line context for receipt and RTV processing.

Usage Notes

RCV_WSH_INTERFACE_PKG is typically invoked indirectly. In standard shipping flows, shipment confirmation triggers the creation of receiving records for in-transit shipments; the RTP concurrent program then processes the staged rows. Custom code and extensions should call PROCESS_TXN when synchronizing a shipment header into receiving, and INVOKE_RTP when an interface group must be submitted programmatically.

Because the package uses AUTHID CURRENT_USER, the calling session must have the appropriate APPS-privileged grants on the referenced synonyms. The g_asn_debug package-level variable, initialized from asn_debug.is_debug_on, indicates that debug logging is governed by the ASN debugging utility, which should be enabled during troubleshooting. Callers should always inspect the returned p_return_status before committing, since these procedures stage data rather than commit it, leaving transaction control to the caller or the concurrent manager.