Search Results wsh_wshrdvls_xmlp_pkg




Overview
Explore in AI Chat

Overview

WSH_WSHRDVLS_XMLP_PKG is an Oracle E-Business Suite package body owned by the APPS schema and classified under the OTHER API category. It supports the WSHRDVLS Oracle Reports report, a shipping execution deliverable that produces consolidated delivery documentation in XML Publisher format. The package follows the standard XML Publisher report integration pattern, in which a PL/SQL library is bound to an .rdf report definition to supply format triggers, parameter-level computation, and report lifecycle callbacks. The naming convention (WSHRDVLS plus the _XMLP_PKG suffix) indicates that the report renders delivery-level data drawn from Oracle Shipping Execution and publishes the output through the XML Publisher engine.

The package header line references version 120.3 dated January 2008 and carries the "noship" build tag, meaning it was shipped with the EBS code baseline but is not independently installable. No other packages are documented as referencing it, so it is self-contained and invoked solely as the server-side library for its companion report.

Key Procedures and Functions

  • BEFOREREPORT — The report initialization callback. It populates P_CONC_REQUEST_ID from FND_GLOBAL.CONC_REQUEST_ID, establishing the concurrent request context. The legacy SRW.USER_EXIT('FND SRWINIT') call has been commented out and replaced with a NULL, with the exception handler similarly neutralized. This migration pattern is common in reports converted from the older SRW-based runtime to the XML Publisher and Oracle Reports 10g runtime.
  • C_COMPANY_NAME — Resolves the ledger name for the report. It queries GL_LEDGERS_PUBLIC_V using the P_SOB_ID parameter and returns the ledger NAME, or NULL when no matching row exists. This value typically appears in the report header as the reporting organization or legal entity.
  • AFTERREPORT — The report termination callback. The historical SRW.USER_EXIT('FND SRWEXIT') call is commented out, consistent with BEFOREREPORT, and the routine returns TRUE unconditionally after the exception block.
  • AFTERPFORM — The after-parameter-form routine. When P_TRIP_ID is supplied, it builds the bind-variable clause appended to the report query, assigning the lexical variable LP_TRIP the string ' and trp.trip_id = :P_trip_id '. This dynamically filters the deliverable data by trip.
  • CF_CONSOL_DELIVERY_NAMEFORMULA — A format trigger that accepts a parent delivery leg identifier and returns the name of the associated consolidated delivery. It opens an explicit cursor joining WSH_NEW_DELIVERIES to WSH_DELIVERY_LEGS on DELIVERY_ID, fetches the delivery NAME, and returns it. A NULL check guards the cursor open, and the routine silently handles exceptions.
  • RP_SUB_TITLE_P — The report subtitle parameter function. In the WSHRDVLS report this supplies the descriptive subtitle text rendered beneath the main report heading, typically assembled from parameter values such as trip or delivery context so that the printed document identifies the shipment being reviewed.

Tables Accessed

  • WSH_NEW_DELIVERIES — The core delivery entity. The package reads the delivery NAME to resolve consolidated delivery identification for parent delivery legs.
  • WSH_DELIVERY_LEGS — Provides the DELIVERY_LEG_ID and DELIVERY_ID linkage used to map a parent delivery leg to its owning delivery record.

Access is read-only. The only other data source is GL_LEDGERS_PUBLIC_V, accessed through the C_COMPANY_NAME ledger lookup.

Usage Notes

WSH_WSHRDVLS_XMLP_PKG is invoked exclusively through its companion Oracle Reports report definition executed from the concurrent manager. The user-facing report accepts parameters including P_TRIP_ID and P_SOB_ID; P_TRIP_ID is consumed by AFTERPFORM to construct the runtime filter, while P_SOB_ID drives the ledger name lookup. Because no packages reference this object, it should not be called directly from custom forms or concurrent programs. Customizations should be limited to the underlying report definition or by cloning the report, since the package body is a shipped, non-modifiable artifact subject to patching in Release 12.1.1 and 12.2.2.