Search Results wsh_wf_std




Overview
Explore in AI Chat

Overview

WSH_WF_STD is an Oracle Workflow integration package body owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Its central purpose is to bridge shipping execution business events with the Oracle Workflow engine, allowing delivery, trip, and carrier-related activities to drive workflow processes and business events. The package supplies the PL/SQL entry points invoked when Shipping Execution needs to launch, confirm, or manage a workflow process, resolve process selection rules, and publish event messages to subscribers. It is classified as an OTHER API in the ETRM repository, indicating that it is an internal supporting package rather than a freely callable public interface, and it is referenced by nineteen other database objects, confirming its role as a shared integration utility within the WSH module.

Key Procedures and Functions

The package exposes seventeen documented procedures and functions. START_WF_PROCESS and START_SCPOD_C_PROCESS initiate workflow processes, the latter targeting the supply chain order/delivery context. CONFIRM_START_WF_PROCESS follows up on a previously launched process, while CHECK_WF_EXISTS and WF_EXISTS test whether a suitable workflow definition or instance already exists. GET_CUSTOM_WF_PROCESS resolves a customer-defined workflow process, and PROCESS_SELECTOR applies selection logic to choose the appropriate process. INSTANCE_DEFAULT_RULE supports defaulting of workflow instance rules. RAISE_EVENT publishes an Oracle Workflow business event. PURGE_ENTITY and LOG_WF_EXCEPTION provide housekeeping and error diagnostics. RESET_APPS_CONTEXT_ON and RESET_APPS_CONTEXT_OFF manage the session's applications context where workflow execution requires it. The carrier-related procedures GET_CARRIER, HANDLE_TRIP_CARRIERS, and ASSIGN_UNASSIGN_CARRIER support trip and carrier assignment logic, and GET_DELIVERIES retrieves delivery rows for processing.

Tables Accessed

The package operates against several documented tables through APPS synonyms. WF_EVENT_T and WF_PARAMETER_LIST_T supply the Oracle Workflow event and parameter structures used by RAISE_EVENT and the START_* procedures. WSH_DELIVERY_DETAILS and WSH_NEW_DELIVERIES hold the delivery and delivery-line information consumed by GET_DELIVERIES and the delivery workflow processes. WSH_TRIPS provides trip headers used by the carrier and trip handling routines. HZ_CUST_ACCOUNTS and HZ_PARTIES supply customer and party identity data required to resolve process selection and carrier assignments. MTL_PARAMETERS provides inventory organization parameters that influence shipping defaults. PLITBLM is referenced for PL/SQL table buffering utilities. The package also depends on packages including FND_API, FND_GLOBAL, FND_MESSAGE, FND_PROFILE, WF_CORE, WF_ENGINE, WF_EVENT, WF_PURGE, WSH_DEBUG_SV, WSH_EXTERNAL_INTERFACE_SV, WSH_SHIPPING_PARAMS_PVT, WSH_UTIL_CORE, and WSH_XC_UTIL.

Usage Notes

WSH_WF_STD is invoked internally by Shipping Execution when a delivery, trip, or carrier event must trigger or query a workflow. Typical invocation paths include shipping transaction forms and concurrent programs that manage delivery confirmation, trip closure, and carrier assignment, as well as workflow-enabled business event subscriptions. The RESET_APPS_CONTEXT_ON and RESET_APPS_CONTEXT_OFF procedures indicate that some calls temporarily reset the FND_GLOBAL application context, a pattern commonly followed before launching background workflow activity. Because the package is classified as OTHER and is not referenced as a public API, customizations should avoid direct calls where possible; integrators should prefer the documented WSH public APIs or workflow event subscriptions. When troubleshooting workflow behavior in shipping, the LOG_WF_EXCEPTION and CHECK_WF_EXISTS routines assist in determining whether a process was started and whether errors occurred during event publication.