Results for “report_sort_by_2_p”

8 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

WSH_WSHRDSDL_XMLP_PKG is the generated PL/SQL package body behind the Oracle E-Business Suite concurrent program "Shipped Delivery Lines Report" (internal report short name WSHRDSDL, XML Publisher edition). It belongs to the shipping execution module (WSH) and exists to supply the bind parameters, derived display values, and formula columns required by an XML Publisher report definition driven from a concurrent request. The package body opens with the standard report preamble: header $Header: WSHRDSDLB.pls 120.3 2010/08/17 ... ship $, a BEFOREREPORT initialization routine that captures FND_GLOBAL.CONC_REQUEST_ID, and a set of generated subprograms that resolve lookup meanings and organization names for report parameters.

The package is relevant to the user search term p_customer_name_low because this is the type of report package that carries customer-related range parameters. In the documented excerpt the visible range parameters are ship date, order number, and delivery, while the package metadata lists REPORT_CUSTOMER_FROM_P and REPORT_CUSTOMER_TO_P style global procedures, indicating that customer name or number ranges are passed to the report and resolved before the query executes.

Key Procedures and Functions

No parameter lists are documented in the ETRM metadata, so the exact signatures should be read from the delivered source in the instance before extension.

Tables Accessed

  • FND_CONCURRENT_REQUESTS / FND_CONCURRENT_PROGRAMS_VL — identify the running concurrent request and its program name.
  • FND_ID_FLEX_STRUCTURES — key flexfield structures used when resolving item or organization segments.
  • HZ_CUST_ACCOUNTS / HZ_PARTIES — Trading Community Architecture tables supplying customer name and account data for customer range parameters.
  • WSH_DELIVERY_DETAILS — the core shipping table listing delivery detail lines that constitute the report output.
  • WSH_TRIP_STOPS — trip and stop information joined for delivery and shipment-from context.

Usage Notes

The package is invoked indirectly through the concurrent program "Shipped Delivery Lines Report" submitted from the Shipping Transactions form or the Submit Requests window; it is not called by other packages (referenced by 0 objects per the metadata). It is a generated XML Publisher report package, so customization is normally performed in the associated XML template or by copying the package rather than editing the seeded body. When diagnosing a parameter such as p_customer_name_low, review the global parameter procedures and BEFOREREPORT logic, since those translate the user-entered value into the display variable consumed by the report query. In 12.2.2 this object remains under the APPS schema and is classified as OTHER in the ETRM API inventory, confirming it is an internal report support package rather than a public integration API.