Results for “wsh_trips_actions”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
WSH_TRIPS_ACTIONS is a public PL/SQL package in the Oracle E-Business Suite Applications (APPS) schema that centralizes the core business operations performed against trip records in Oracle Transportation Execution / Shipping Execution. A trip in Oracle EBS represents a planned movement of one or more deliveries by a single carrier, mode of transport, and service level. This package encapsulates the logic required to create, plan, confirm, and change the status of trips, as well as to manage the sequence and assignment of trip stops and to compute weight and volume aggregations across a trip. It also supports carrier selection and load tendering interactions with freight carriers.
The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than the definer, which is consistent with standard EBS API conventions. Its source includes declared record and table types (cs_trip_rec_type, cs_trip_tab_type, cs_stop_rec_type) that model trip headers and trip stops, and it carries legacy support for dummy locations (#DUM_LOC).
Key Procedures and Functions
- AUTOCREATE_TRIP, AUTOCREATE_TRIP_MULTI, AUTOCREATE_DEL_TRIP — Create trips automatically from deliveries, either singly or in a batch, including the automatic generation of trip records from delivery data.
- PLAN — Executes the planning logic that establishes or revises the routing and scheduling of a trip.
- CONFIRM_TRIP — Finalizes a trip, transitioning it to a confirmed state needed for downstream execution.
- CHANGE_STATUS and CHANGESTATUS — Update the status code of a trip or its components.
- ASSIGN_TRIP and UNASSIGN_TRIP — Assign deliveries to, or remove them from, a trip; CHECK_UNASSIGN_TRIP validates whether unassignment is permitted.
- GET_TRIP_DEFAULTS and GET_STOP_SEQ_MODE — Retrieve default attribute values for trip creation and determine the stop sequencing mode.
- VALIDATE_STOP_SEQUENCE and RESET_STOP_PLANNED_DATES — Validate the ordering of trip stops and recalculate planned arrival/departure dates.
- CALC_STOP_FILL_PERCENT and TRIP_WEIGHT_VOLUME — Compute stop fill percentages and aggregate trip weight and volume.
- HANDLE_INTERNAL_STOPS — Manage internal (non-customer) stops within a trip.
- PROCESS_CARRIER_SELECTION and FTE_LOAD_TENDER — Support carrier selection and load tendering to the selected carrier.
- GENERATEROUTINGRESPONSE — Generate the routing response returned to the calling process or external system.
Tables Accessed
The package reads and writes the central trip tables WSH_TRIPS and WSH_TRIP_STOPS, which store trip headers and individual stop records. Delivery linkage is handled through WSH_NEW_DELIVERIES and WSH_DELIVERY_LEGS. Party and location information is resolved via HZ_CUST_ACCT_SITES_ALL, HZ_CUST_SITE_USES_ALL, HZ_LOCATIONS, HZ_PARTY_SITES, and HZ_PARTY_SITES. Item master data is referenced through MTL_SYSTEM_ITEMS, while WSH_SHIPPING_PARAMETERS supplies configuration defaults and WSH_REPORT_SETS supports reporting. WSH_TMP, DUAL, and PLITBLM provide temporary storage and utility functions.
Usage Notes
WSH_TRIPS_ACTIONS is invoked primarily from the Oracle Shipping Execution and Transportation Execution forms, from concurrent programs that automate trip creation and planning, and from custom PL/SQL code that needs to manipulate trips programmatically. Because it is referenced by twenty other packages, it acts as a shared service layer; changes to its behavior can cascade widely. Users searching under the term "WTO dumpping" are typically investigating trip stop or routing output, and the stop-related procedures (VALIDATE_STOP_SEQUENCE, RESET_STOP_PLANNED_DATES, HANDLE_INTERNAL_STOPS) are the relevant entry points for diagnosing stop sequencing and dummy-location handling in 12.1.1 and 12.2.2.