Search Results set_load_tender

Overview

The APPS.WSH_DELIVERY_LEGS_ACTIONS package is a PL/SQL API belonging to the Oracle E-Business Suite Transportation and Logistics module. It provides the core programmatic interface for manipulating delivery legs — the discrete movement segments that connect a delivery to a trip or to pickup and dropoff stops within the Oracle Transportation Management (OTM)/Shipping Execution (WSH) data model. The package is declared with AUTHID CURRENT_USER, meaning its SQL statements execute with the privileges of the invoking user rather than the package owner, which is consistent with Oracle's standard approach to public APIs in the WSH schema.

Functionally, the package governs the lifecycle events that occur when deliveries are associated with or disassociated from trips and trip stops. It supports assignment of deliveries to trips, removal of deliveries (unassignment), tendering of load information to carriers or rating engines, and marking records as requiring repricing when freight costs change. These operations are central to dock scheduling, trip planning, carrier tendering, and freight cost recalculation workflows.

Key Procedures and Functions

The ETRM metadata documents five procedures and functions in this package:

• ASSIGN_DELIVERIES — Assigns one or more deliveries to either a trip or a pickup/dropoff stop, creating delivery legs and, where necessary, trip stops. It accepts a table of delivery identifiers, trip and stop identifiers, pickup and dropoff location overrides, and a create flag that controls whether new trip stops are generated. It returns a table of the resulting delivery leg identifiers and a standard return status value consistent with FND_API.G_RET_STS_SUCCESS, G_RET_STS_ERROR, or G_RET_STS_UNEXP_ERROR. Later revisions added caller identification and planned arrival/departure date parameters.
• UNASSIGN_DELIVERIES — Performs the inverse operation, detaching deliveries from trips or stops and thereby removing the associated delivery legs.
• SET_LOAD_TENDER — Sets the load tender status on delivery legs, reflecting that a shipment has been offered to a carrier for execution. This is the specific procedure sought by users searching on set_load_tender.
• MARK_REPRICE_REQUIRED — Flags deliveries or delivery legs so that freight costs are recalculated, typically after a change to stops, legs, or shipment characteristics invalidates existing rate information.
• CHECK_RATE_DELIVERY — Validates whether a delivery can be rated, supporting the costing and freight payment processes.

Tables Accessed

The package reads and writes several core WSH tables through APPS synonyms:

• WSH_DELIVERY_LEGS and WSH_DELIVERY_ASSIGNMENTS — store the leg segments and the delivery-to-trip/stop assignments that this package creates and removes.
• WSH_TRIPS and WSH_TRIP_STOPS — hold trip headers and stop sequences to which deliveries are attached.
• WSH_DELIVERY_DETAILS and WSH_NEW_DELIVERIES — provide delivery-level attributes such as initial pickup and ultimate dropoff locations that the API may override.
• WSH_FREIGHT_COSTS — supports repricing and rate-check operations.
• WSH_TMP, DUAL, and PLITBLM — utility and PL/SQL table objects used internally.

Usage Notes

This package is documented as referenced by 22 other packages, indicating broad internal reuse across Shipping Execution, trip planning, and freight costing logic. It is typically invoked from Oracle Shipping Execution forms, trip and carrier tendering concurrent programs, and custom extensions that need to programmatically assign or release deliveries against trips. Because parameters default to NULL and return status follows the FND_API convention, callers should always check x_return_status and handle error conditions before proceeding. All calls should be made within the standard WSH transaction context to preserve data integrity.