Search Results p_trip_id

Overview

WSH_MBOLS_PVT is a private PL/SQL package in the Oracle E-Business Suite Logistics Execution (WSH) module that supports the generation, printing, and cancellation of Master Bills of Lading (MBOLs) and their associated Bills of Lading (BOLs). The package operates in the shipping and transportation execution flow, where a trip groups together multiple deliveries under one carrier movement. The MBOL serves as the primary legal transport document consolidating the shipments on that trip, while individual BOLs cover each delivery or shipment line. Because it is classified as a PVT (private) package, it is intended for internal use by the WSH application and is not published as a supported public API. Its declared AUTHID CURRENT_USER setting means it executes with the privileges of the calling user, so callers must possess the appropriate WSH and printing privileges.

Key Procedures and Functions

The package exposes six documented procedures. All shared trip-level operations accept a trip identifier, historically the p_trip_id parameter that users search on, which points to a record in WSH_TRIPS.

• Generate_MBOL — Creates the Master Bill of Lading for a trip and returns the generated MBOL sequence number along with a return status.
• Generate_BOLs — Generates the individual Bills of Lading associated with the deliveries on a given trip, returning a status.
• Print_MBOL — Prepares and submits the MBOL for printing, with an optional flag controlling whether related BOLs are generated at the same time.
• Print_BOLs — Submits the BOLs for a trip to the printing process, optionally tied to a concurrent request identifier for tracking output.
• Cancel_MBOL — Reverses or voids an existing MBOL for the trip, returning a status.
• Get_Organization_Of_MBOL — Retrieves the organization associated with a Master Bill of Lading, typically resolving carrier or operating unit context.

Tables Accessed

The package reads and writes through APPS synonyms. Core trip data comes from WSH_TRIPS and WSH_TRIP_STOPS, which define the trip and its stop sequence. Delivery and shipment content is drawn from WSH_NEW_DELIVERIES and WSH_DELIVERY_LEGS. Carrier and service details are resolved from WSH_CARRIERS and WSH_CARRIER_SERVICES. Document instance records used to track generated MBOL and BOL documents are maintained in WSH_DOCUMENT_INSTANCES. Organization context for the Get_Organization_Of_MBOL call is obtained from HR_ALL_ORGANIZATION_UNITS. PLITBLM is referenced for print/output handling of the resulting documents.

Usage Notes

Because WSH_MBOLS_PVT is a private package, it is normally invoked from Oracle-shipping forms and concurrent programs rather than directly by customers. Trip and shipping workbench actions such as generating, printing, or cancelling a Master Bill of Lading ultimately call these procedures, with p_trip_id identifying the trip selected in the user interface. The package is referenced by six other packages, confirming its role as an internal service layer. In 12.1.1 and 12.2.2 the behavior is consistent, though 12.2.x Online Patching means the package is wrapped by the editioning view infrastructure. Custom code should avoid calling this private package directly and instead use the supported public WSH APIs, since signatures and internal logic are subject to change without notice.