Search Results create_update_trip

Overview

WSH_TRIPS_GRP is a public PL/SQL group package (API classification GRP) owned by APPS in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It provides the canonical application programming interface for creating, updating, and acting upon trips within the Oracle Warehouse Management and Shipping Execution (WSH) module. A trip represents a logical grouping of deliveries, stops, and delivery legs assigned to a specific vehicle, carrier, and ship method, allowing transportation planners to consolidate shipments into a single movement. The package declares AUTHID CURRENT_USER and exposes a public record type, Trip_Pub_Rec_Type, that carries the full attribute set of a trip: identifiers, sequencing data (arrive-after trip), vehicle item and organization details, carrier and ship-method codes, routing instructions, and the standard 15 descriptive flexfield attribute columns. Each field is initialized with FND_API.G_MISS_NUM or FND_API.G_MISS_CHAR, consistent with the Oracle Application Object Library API conventions that allow callers to distinguish between "not supplied" and "explicitly set to null" values.

Key Procedures and Functions

The ETRM metadata documents seven procedures and functions, of which five are named:

• CREATE_UPDATE_TRIP — The publicly documented entry point (corresponding to the "create_update_trip" search term) for creating a new trip or updating an existing one. Callers populate a Trip_Pub_Rec_Type record and pass it to this procedure, which handles insert and update logic, validation, and defaulting.
• CREATE_UPDATE_TRIP_NEW — A newer variant of the create/update procedure, providing the current-generation interface recommended for new integrations.
• TRIP_ACTION — Performs a state or lifecycle action on an existing trip, such as confirming, closing, or otherwise transitioning trip status.
• TRIP_ACTION_NEW — The newer variant of the trip action procedure, offering the current-generation entry point for trip state transitions.
• GET_TRIP_DETAILS_PVT — A private helper that retrieves trip detail information, typically used internally to support the public create, update, and action procedures.

The remaining two documented procedures are internal support routines that complete the package’s public surface. The _NEW suffixed procedures represent the forward-looking API generation, while the unsuffixed procedures are retained for backward compatibility with existing integrations.

Tables Accessed

The package operates against the following tables through APPS synonyms:

• WSH_TRIPS — The primary trip entity table; the create, update, and action procedures insert into and update rows here.
• WSH_TRIP_STOPS — Stores the ordered stops associated with each trip, read and maintained as trip routing is defined or changed.
• WSH_DELIVERY_LEGS — Holds the legs that connect stops and carry deliveries; queried and updated when trips are modified.
• WSH_NEW_DELIVERIES — The delivery header table; read to determine which deliveries are assigned to or eligible for the trip.
• WSH_REPORT_SETS and WSH_REPORT_SET_LINES — Reference data used when trip documentation or report groupings are generated.
• PLITBLM — The PL/SQL integer table type used internally for bulk processing and array handling.

Usage Notes

WSH_TRIPS_GRP is invoked from multiple layers of the EBS stack. It is referenced by 21 other packages, indicating that it underpins much of the outbound logistics and trip-management functionality, including shipping execution concurrent programs and the Transportation/Shipping Execution forms. Custom code should call the public procedures through the APPS schema synonym and populate Trip_Pub_Rec_Type rather than writing directly to the underlying tables, so that validation, defaulting, and flexfield handling are preserved. When integrating in Release 12.2.2, preference should be given to the _NEW procedure variants where available, as these represent the maintained interface generation.