Search Results wsh_trips_pvt

Overview

WSH_CUSTOM_PUB is the public customization package within the Oracle Shipping Execution (WSH) module of Oracle E-Business Suite. It serves as the designated extension point through which customers, integrators, and Oracle's own shipping components inject site-specific business logic into standard shipping flows without modifying Oracle-owned code. The package is classified as a public API (PUB) in the ETRM documentation for release 12.2.2, carries APPS as its owner, and is marked VALID in the data dictionary, confirming that the package spec and body compile cleanly against the current schema.

Functionally, WSH_CUSTOM_PUB acts as a broker between the core shipping engine and a wide set of downstream consumers. It exposes naming rules for deliveries and trips, credit-check behavior, shipped and backordered line queries, workflow initiation, transportation planning date calculations, rate shopping overrides, and integrations with third-party shipping service providers. Because it is referenced by fifteen other packages and is itself dependent on WSH_TRIPS_PVT, WSH_NEW_DELIVERIES_PVT, WSH_LOCATIONS_PKG, and WSH_UTIL_CORE, it occupies a central position in the shipping call graph. The mutual reference with WSH_TRIPS_PVT is particularly relevant to users searching on that object, since trip-related logic in WSH_TRIPS_PVT can flow through the customization hooks defined here.

Key Procedures and Functions

The ETRM metadata documents nineteen procedures and functions. Their documented purposes are summarized below.

DELIVERY_NAME — Returns a customized delivery name, allowing organizations to enforce their own numbering or naming conventions on deliveries.
TRIP_NAME — Returns a customized trip name, supporting site-specific trip numbering schemes.
RUN_PR_SMC_SS_PARALLEL — Controls whether the shipment management parallel processing program runs in parallel mode.
CREDIT_CHECK_DETAILS_OPTION — Determines the credit-check option applied to delivery details during pick release and shipping.
UI_LOCATION_CODE — Supplies the location code used by shipping user interface components.
SHIPPED_LINES — Identifies shipped lines for downstream shipment confirmation and billing.
BACKORDERED_LINES — Identifies backordered lines so that they can be carried forward or reprocessed.
START_WORKFLOW — Determines whether the shipping workflow is launched for a given transaction.
CALCULATE_TP_DATES — Governs transportation planning date calculations for trips and deliveries.
OVERRIDE_RIQ_XML_ATTRIBUTES — Allows site-specific override of attributes in the Rate Inquiry (RIQ) XML payload.
CANCEL_UNPICKED_DETAILS_AT_ITS — Controls cancellation of unpicked delivery details at the ITS (Integration to Shipping) stage.
GET_STANDALONE_WMS_DEFAULTS — Returns default values for standalone Warehouse Management System integration scenarios.
POST_PROCESS_SHIPMENT_REQUEST — Executes customer-defined post-processing after a shipment request is submitted.
DSNO_OUTPUT_FILE_PREFIX — Provides the output file prefix for DSNO (Delivery Ship Notice Outbound) transmissions.
SHIPMENT_BATCH_GROUP_CRITERIA — Defines grouping criteria used when batching shipments.
CSP_SHIPMENT_SERVICES, RATE_SHIPMENT_SERVICES, TRK_SHIPMENT_SERVICES, TNT_SHIPMENT_SERVICES — Return shipment service values for the CSP, RATE, TRK, and TNT carrier interfaces respectively.

Tables Accessed

The package reaches base shipping data through APPS synonyms, notably MTL_SYSTEM_ITEMS, WSH_DELIVERY_ASSIGNMENTS, WSH_DELIVERY_DETAILS, WSH_LOCATIONS, and WSH_NEW_DELIVERIES. These tables supply the item, delivery-assignment, delivery-detail, location, and delivery header information needed to evaluate the customization logic. XML processing relies on XMLTYPE, DBMS_XMLDOM, and UTL_HTTP, which support the RIQ XML override and outbound carrier messaging functionality.

Usage Notes

WSH_CUSTOM_PUB is not a standalone API for direct ad-hoc invocation; it is called by Oracle's shipping forms, concurrent programs, workflows, and integration packages. Customers extend it by bodying out the stub routines with site-specific logic, after which WSH_TRIPS_PVT, WSH_NEW_DELIVERIES_PVT, WSH_LOCATIONS_PKG, WSH_PICK_LIST, WSH_SHIP_CONFIRM_ACTIONS, WSH_TP_RELEASE, WSH_WF, and WSH_OTM_RIQ_XML automatically pick up the customized behavior at runtime. The package is identical in structure across EBS 12.1.1 and 12.2.2.

PACKAGE: APPS.WSH_CUSTOM_PUB 12.1.1
owner:APPS, object_type:PACKAGE, object_name:WSH_CUSTOM_PUB, status:VALID,
PACKAGE: APPS.WSH_TRIP_VALIDATIONS 12.2.2
owner:APPS, object_type:PACKAGE, object_name:WSH_TRIP_VALIDATIONS, status:VALID,
PACKAGE BODY: APPS.WSH_TRIPS_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_TRIPS_PVT, status:VALID,
PACKAGE BODY: APPS.WSH_TRIPS_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_TRIPS_PVT, status:VALID,
PACKAGE: APPS.WSH_TRIP_VALIDATIONS 12.1.1
owner:APPS, object_type:PACKAGE, object_name:WSH_TRIP_VALIDATIONS, status:VALID,
PACKAGE: APPS.WSH_CUSTOM_PUB 12.2.2
owner:APPS, object_type:PACKAGE, object_name:WSH_CUSTOM_PUB, status:VALID,
SYNONYM: APPS.WSH_TRIPS_S 12.2.2
owner:APPS, object_type:SYNONYM, object_name:WSH_TRIPS_S, status:VALID,
SYNONYM: APPS.WSH_TRIPS_S 12.1.1
owner:APPS, object_type:SYNONYM, object_name:WSH_TRIPS_S, status:VALID,
PACKAGE: APPS.WSH_TRIPS_PVT 12.2.2
owner:APPS, object_type:PACKAGE, object_name:WSH_TRIPS_PVT, status:VALID,
PACKAGE BODY: APPS.WSH_PACKING_SLIPS_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_PACKING_SLIPS_PVT, status:VALID,
PACKAGE: APPS.FTE_WSH_INTERFACE_PKG 12.2.2
owner:APPS, object_type:PACKAGE, object_name:FTE_WSH_INTERFACE_PKG, status:VALID,
PACKAGE: APPS.WSH_TRIPS_PVT 12.1.1
owner:APPS, object_type:PACKAGE, object_name:WSH_TRIPS_PVT, status:VALID,
PACKAGE BODY: APPS.WSH_FTE_TP_INTEGRATION 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_FTE_TP_INTEGRATION, status:VALID,
PACKAGE: APPS.FTE_WSH_INTERFACE_PKG 12.1.1
owner:APPS, object_type:PACKAGE, object_name:FTE_WSH_INTERFACE_PKG, status:VALID,
PACKAGE: APPS.FTE_MLS_UTIL 12.2.2
owner:APPS, object_type:PACKAGE, object_name:FTE_MLS_UTIL, status:VALID,
PACKAGE BODY: APPS.WSH_DELIVERY_DETAILS_PUB 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_DELIVERY_DETAILS_PUB, status:VALID,
PACKAGE BODY: APPS.FTE_SS_INTERFACE 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:FTE_SS_INTERFACE, status:VALID,
PACKAGE BODY: APPS.WSH_BOLS_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_BOLS_PVT, status:VALID,
PACKAGE: APPS.FTE_TENDER_PVT 12.2.2
owner:APPS, object_type:PACKAGE, object_name:FTE_TENDER_PVT, status:VALID,
PACKAGE: APPS.FTE_TP_GRP 12.1.1
owner:APPS, object_type:PACKAGE, object_name:FTE_TP_GRP, status:VALID,
PACKAGE BODY: APPS.WSH_DELIVERIES_PUB 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_DELIVERIES_PUB, status:VALID,
PACKAGE: APPS.FTE_TENDER_PVT 12.1.1
owner:APPS, object_type:PACKAGE, object_name:FTE_TENDER_PVT, status:VALID,
PACKAGE: APPS.FTE_TP_GRP 12.2.2
owner:APPS, object_type:PACKAGE, object_name:FTE_TP_GRP, status:VALID,
PACKAGE BODY: APPS.WSH_CUSTOM_PUB 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_CUSTOM_PUB, status:VALID,
PACKAGE BODY: APPS.WSH_PACKING_SLIPS_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_PACKING_SLIPS_PVT, status:VALID,
PACKAGE BODY: APPS.FTE_ACS_TRIP_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:FTE_ACS_TRIP_PKG, status:VALID,
PACKAGE: APPS.WSH_FTE_TP_INTEGRATION 12.1.1
owner:APPS, object_type:PACKAGE, object_name:WSH_FTE_TP_INTEGRATION, status:VALID,
PACKAGE BODY: APPS.WSH_DELIVERY_DETAILS_PUB 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_DELIVERY_DETAILS_PUB, status:VALID,
PACKAGE BODY: APPS.WSH_TRIPS_PUB 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_TRIPS_PUB, status:VALID,
PACKAGE BODY: APPS.WSH_TRIPS_PUB 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_TRIPS_PUB, status:VALID,
PACKAGE: APPS.WSH_WF_STD 12.1.1
owner:APPS, object_type:PACKAGE, object_name:WSH_WF_STD, status:VALID,
PACKAGE: APPS.WSH_FTE_TP_INTEGRATION 12.2.2
owner:APPS, object_type:PACKAGE, object_name:WSH_FTE_TP_INTEGRATION, status:VALID,
PACKAGE BODY: APPS.WSH_FTE_TP_INTEGRATION 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_FTE_TP_INTEGRATION, status:VALID,
PACKAGE: APPS.FTE_MLS_UTIL 12.1.1
owner:APPS, object_type:PACKAGE, object_name:FTE_MLS_UTIL, status:VALID,
PACKAGE BODY: APPS.FTE_SS_INTERFACE 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:FTE_SS_INTERFACE, status:VALID,
PACKAGE BODY: APPS.WSH_BOLS_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_BOLS_PVT, status:VALID,
PACKAGE BODY: APPS.FTE_CARRIER_RANK_LIST_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:FTE_CARRIER_RANK_LIST_PVT, status:VALID,
PACKAGE BODY: APPS.WSH_FTE_COMP_CONSTRAINT_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_FTE_COMP_CONSTRAINT_PKG, status:VALID,
PACKAGE BODY: APPS.WSH_FTE_COMP_CONSTRAINT_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_FTE_COMP_CONSTRAINT_PKG, status:VALID,
PACKAGE: APPS.FTE_MLS_WRAPPER 12.2.2
owner:APPS, object_type:PACKAGE, object_name:FTE_MLS_WRAPPER, status:VALID,
PACKAGE BODY: APPS.FTE_MLS_UTIL 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:FTE_MLS_UTIL, status:VALID,
PACKAGE BODY: APPS.WSH_CUSTOM_PUB 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_CUSTOM_PUB, status:VALID,
PACKAGE BODY: APPS.WSH_DELIVERY_LEGS_GRP 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_DELIVERY_LEGS_GRP, status:VALID,
PACKAGE: APPS.FTE_MLS_WRAPPER 12.1.1
owner:APPS, object_type:PACKAGE, object_name:FTE_MLS_WRAPPER, status:VALID,
PACKAGE BODY: APPS.WSH_DELIVERIES_PUB 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_DELIVERIES_PUB, status:VALID,
PACKAGE BODY: APPS.FTE_CARRIER_RANK_LIST_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:FTE_CARRIER_RANK_LIST_PVT, status:VALID,
PACKAGE BODY: APPS.WSH_DELIVERY_LEGS_GRP 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_DELIVERY_LEGS_GRP, status:VALID,
PACKAGE BODY: APPS.WSH_INTERFACE_GRP 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_INTERFACE_GRP, status:VALID,
PACKAGE BODY: APPS.WSH_INTERFACE_GRP 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_INTERFACE_GRP, status:VALID,
PACKAGE BODY: APPS.WSH_DELIVERY_DETAILS_UTILITIES 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_DELIVERY_DETAILS_UTILITIES, status:VALID,