Search Results wsh_itm_util




Overview
Explore in AI Chat

Overview

WSH_ITM_UTIL is a utility package in the Oracle E-Business Suite Order Management and Shipping Execution (WSH) modules. Its purpose is to centralize the resolution of service-provider configuration used during shipment and delivery processing, in particular the identification of which service types and vendors are valid for a given operating unit, master organization, and application context. The package abstracts the configuration stored in the WSH_ITM setup tables (service preferences, vendor services, and vendor definitions) so that calling products — notably the compliance and international trade management flows — can obtain a normalized, validated view of the enabled services without duplicating the underlying query logic. Because it is registered as a UTIL classified API under the APPS schema, it is treated as an internal supporting routine rather than a public transactional API. The header comment indicates that the source has been stable since release 11.5 and is shipped unchanged into 12.1.1 and 12.2.2.

Key Procedures and Functions

The documented package exposes four procedures and functions:

  • GET_SERVICE_DETAILS — Returns the list of services defined for a given user context, along with the additional country-code information associated with each service. The header comment notes that the caller supplies an application identifier and both the master and operating organization identifiers, and receives back a PL/SQL table of the WSH_ITM_SERVICE_PREFERENCES record type, a flag indicating whether a combined (single) request covering all returned services is permitted, and a return status. The routine is the primary entry point for service enumeration.
  • UPDATE_PROCESS_FLAG — Updates a process-control indicator in the service-request processing cycle, allowing callers to mark a request or batch as processed and to prevent reprocessing.
  • GET_SERVICE_PROVIDER — Resolves the vendor (service provider) responsible for a requested service type within the supplied organization, returning the applicable WSH_ITM_VENDORS identifier so that downstream validation and document generation can attribute the service correctly.
  • GET_COMPLIANCE_STATUS — Evaluates and returns the compliance status for a service or shipment, exposing the outcome of the international-trade screening logic that the ITM tables support.

Tables Accessed

The package reads and writes the following tables through APPS synonyms:

  • WSH_ITM_SERVICE_PREFERENCES — holds the user- or organization-level service enablement preferences; the primary driver of GET_SERVICE_DETAILS.
  • WSH_ITM_VENDOR_SERVICES — maps service types to the vendors qualified to perform them, including the additional-country-code check requirement and the supports-combination flag.
  • WSH_ITM_VENDORS — the vendor master for service providers, supplying vendor identifiers and combination-support flags.
  • WSH_ITM_REQUEST_CONTROL — governs processing state for service requests; used by UPDATE_PROCESS_FLAG.
  • WSH_SHIPPING_PARAMETERS — provides the shipping and international-trade parameter values that qualify service and compliance results.
  • PLITBLM — the PL/SQL table buffer mechanism used to pass the returned service table between caller and package.

Usage Notes

WSH_ITM_UTIL is an internal utility rather than a form-bound API; it is referenced by two other packages and is typically invoked from server-side PL/SQL during service-request validation, vendor determination, and compliance screening. Direct calls from custom code are possible but should be limited to the procedures documented here, and callers must honor the OUT NOCOPY parameter conventions shown in the source. Because the package is classified as a UTIL API and has remained largely unchanged since 11.5, integrators should treat it as stable but unsupported for modification, and should confirm behavior against the target release (12.1.1 or 12.2.2) before embedding calls in custom extensions.