Search Results get_compliance_status

Overview

WSH_ITM_UTIL is a utility PL/SQL package owned by the APPS schema and classified as a UTIL API within Oracle E-Business Suite Release 12.1.1 and 12.2.2. Its principal business function is to resolve the set of shipping services that a Master Organization is permitted to use, together with any additional country codes and the combination-support flag associated with those services. The package therefore sits at the intersection of shipping execution and geography-based service eligibility: it determines which of the services recorded in WSH_ITM_VENDOR_SERVICES apply to a given Master Organization, whether an additional country code governs that service, and whether a combined request spanning all returned services can be processed as one unit.

The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the calling user rather than the definer, and is typically reached through APPS synonyms. Because it exposes reusable lookup logic rather than transactional business events, it is invoked by other packages and by service-provider registration flows to obtain consistent service definitions across the shipping and trade management modules.

Key Procedures and Functions

• GET_SERVICE_DETAILS — The central routine. Given an application identifier, a Master Organization identifier, and an organization identifier, it returns the services defined for the user along with the additional country codes applicable to each service. The returned payload is a PL/SQL table of a record type containing the service type code and additional country code, accompanied by a flag indicating whether a combined request for all returned service types is supported, plus a standard return status. This is the procedure most frequently associated with searches for "get_service_details."
• UPDATE_PROCESS_FLAG — Maintains the process flag associated with service request control, recording processing state for services returned by the service-details lookup.
• GET_SERVICE_PROVIDER — Resolves the service provider information associated with a service, drawing on vendor and shipping parameter configuration.
• GET_COMPLIANCE_STATUS — Returns the compliance status applicable to a service or organization context, supporting regulatory checks performed during service selection.

The package additionally declares supporting record and collection types, including a control identifier list and a service record type used to carry service type codes and additional country codes.

Tables Accessed

• WSH_ITM_VENDOR_SERVICES — The authoritative source of service type definitions and the base for the returned service list.
• WSH_ITM_REQUEST_CONTROL — Consulted and updated for request processing flags and control-state information.
• WSH_ITM_SERVICE_PREFERENCES — Supplies preference configuration influencing service eligibility and combination support.
• WSH_ITM_VENDORS — Provides service provider and vendor details used when resolving the provider for a service.
• WSH_SHIPPING_PARAMETERS — Supplies shipping parameter defaults and organization-level settings.
• PLITBLM — The standard EBS PL/SQL table maintenance package, used for the collection manipulations that back the returned table structures.

Usage Notes

WSH_ITM_UTIL is invoked from other PL/SQL packages, from shipping and trade management forms, and from customizations that need organization-specific service definitions. Custom code should call GET_SERVICE_DETAILS rather than querying the underlying tables directly, so that additional country code logic and the combination-support determination remain consistent. The two packages known to reference WSH_ITM_UTIL should be reviewed for call ordering, since flags maintained by UPDATE_PROCESS_FLAG can influence downstream processing. As an AUTHID CURRENT_USER utility, callers must hold the necessary privileges on the referenced APPS synonyms, and the return status should always be checked before consuming the returned service table.