Search Results del_name




Overview
Explore in AI Chat

Overview

WSH_EXTERNAL_CUSTOM is a stub/customization hook package body owned by APPS within the Oracle E-Business Suite shipping execution module (WSH). Its documented API classification is OTHER, and in the Oracle EBS 12.1.1 / 12.2.2 code line it is delivered as an empty-shell implementation whose function bodies return placeholder values. The package exists so that implementations can override default shipping naming and reference-number derivation logic without modifying Oracle's seeded shipping code. The document excerpt preserves the file header identifier WSHUOPNB.pls (version 115.3), which associates the object with the open/ship/transport release path of the WSH module. No DML is performed in the delivered version; every function either returns zero, NULL, or a truncated conversion of its input identifier.

Key Procedures and Functions

  • ORDER_VALUE — Returns a numeric value associated with a header identifier. In the shipped body it is hard-coded to return zero, acting as a placeholder for a customer-specific order value calculation.
  • PICKRELEASE_SLQs — Accepts a batch identifier and a release mode and returns a VARCHAR2. The delivered implementation returns NULL and is intended as an extension point for pick-release selection logic.
  • DEPARTURE_NAME — Derives a display name for a departure identifier. The shipped logic converts the numeric departure ID to character form and truncates it to 30 characters.
  • DELIVERY_NAME — Derives a display name for a delivery identifier. This is the function referenced by the search term "del_name": the local variable del_name is declared as VARCHAR2(30), assigned the character conversion of the delivery ID truncated to 15 characters, and returned. It is the only function in the package where truncation length differs from the departure counterpart.
  • BILL_OF_LADING — Returns a bill-of-lading reference for a departure identifier. The shipped body returns NULL.
  • WAYBILL — Returns a waybill reference from a departure identifier and a delivery identifier. The shipped body returns NULL.

Tables Accessed

The documented metadata records no tables accessed through APPS synonyms in the delivered body. All six functions operate solely on their incoming parameters; none issues SELECT, INSERT, UPDATE, or DELETE statements. Any table access would be introduced only by a customer extension that replaces the placeholder bodies, typically reading delivery, departure, and shipment header data from WSH_DELIVERY_DETAILS, WSH_DELIVERIES, or WSH_TRIP_STOPS depending on the chosen naming convention.

Usage Notes

Because the package is a customization hook, invocation is indirect. Oracle's seeded shipping execution logic, and up to four other documented packages per the ETRM metadata, call these functions during delivery and departure processing to obtain display names and reference numbers. In practice the DEFINE-name functions (departure_name, delivery_name) are exercised when shipping documents, delivery labels, or transportation screens need a human-readable identifier in place of a numeric ID, while the SLQ, bill-of-lading, and waybill functions are called where a customer-specific external reference must be produced. Implementations that require meaningful values (for example, a formatted BOL number) create a custom copy of this package body and populate each function; the truncation behavior visible in delivery_name illustrates the intended pattern of returning a bounded VARCHAR2. When troubleshooting unexpected delivery or departure labels in 12.1.1 or 12.2.2, verifying whether WSH_EXTERNAL_CUSTOM has been customized is the first diagnostic step, since the delivered version will silently return the raw identifier or NULL.