Search Results raise_itm_event

Overview

The APPS.WSH_ITM_EXPORT_SCREENING package is a PL/SQL component within the Oracle E-Business Suite Warehouse Management (WSH) module that supports International Trade Management (ITM) export screening. Its principal business function is to evaluate outbound delivery transactions against export compliance and restricted-party screening requirements before goods are shipped. In EBS 12.1.1 and 12.2.2, the package acts as the integration point between the shipping execution data model (deliveries, delivery details, and delivery assignments) and the ITM screening engine. Screening is a regulatory necessity for organizations that must comply with export control regimes, and this package provides the programmatic mechanism by which deliveries are selected for screening and the corresponding ITM events are raised.

Key Procedures and Functions

The ETRM documentation for 12.2.2 records three procedures or functions in this package:

• SCREEN_DELIVERIES — The primary driver that identifies and submits eligible deliveries for export screening. It forms the entry point used when a batch of shipments must be evaluated against ITM screening rules.
• SCREEN_EVENT_DELIVERIES — Handles screening for deliveries in the context of an ITM event, providing the event-driven path by which delivery lines are routed into the screening process.
• RAISE_ITM_EVENT — Publishes or raises an ITM event to the Oracle Workflow / event infrastructure once screening activity has been determined. It serves as the notification mechanism connecting WSH shipping data to the ITM event queue.

Documented parameter lists are not published in the available metadata; parameter details must be obtained from the package specification source. The package status is VALID, confirming it is compiled and active in the APPS schema.

Tables Accessed

The package reads and writes a set of WSH and ITM tables, all accessed through APPS synonyms:

• WSH_NEW_DELIVERIES, WSH_DELIVERY_DETAILS, and WSH_DELIVERY_ASSIGNMENTS — supply the delivery header, line, and assignment information that constitutes the screening scope.
• WSH_ITM_REQUEST_CONTROL and WSH_ITM_REQUEST_CONTROL_S — store the ITM screening request records and control sequence data generated by the package.
• WSH_ITM_SERIAL_NUMBERS and MTL_SERIAL_NUMBERS_TEMP — capture serial-controlled item details relevant to export screening.
• WSH_TRANSACTIONS_HISTORY and WSH_DOCUMENT_NUMBER_S — provide shipping transaction history and document numbering.
• WF_PARAMETER_LIST_T, FND_LANGUAGES, DBMS_SQL, DUAL, and PLITBLM — support Workflow parameter passing, language handling, dynamic SQL, and PL/SQL table utilities.

Usage Notes

WSH_ITM_EXPORT_SCREENING is referenced by WSH_ITM_PKG and WSH_WF_INTERFACE, indicating it is invoked both by the ITM processing package and by the Workflow interface layer. It is typically called during delivery confirmation or shipment processing, either through a concurrent program that screens batches of deliveries or through an event-triggered path initiated by Oracle Workflow. Custom code should invoke the package only through its documented procedures and should not bypass the ITM request control tables, as these maintain screening audit records required for compliance reporting.