Search Results cp_ship_method_p




Overview
Explore in AI Chat

Overview

WSH_WSHRDASP_XMLP_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Shipper’s Report / Release Delivery Audit report, an Oracle Shipping Execution (WSH) concurrent program typically associated with the Release Delivery Audit Report and related shipping diagnostics. The package is declared AUTHID CURRENT_USER and carries a header marker of WSHRDASPS.pls (version 120.4, dated 2010/08/30), indicating it is a packaged XML Publisher report driver rather than a business API. Its primary role is to receive concurrent program parameters supplied on the report submission form, resolve lookup descriptions and derived values through the CP_* helper functions, and manage the report lifecycle through the standard XML Publisher trigger functions BEFOREREPORT, BEFOREPFORM, AFTERPFORM, and AFTERREPORT. A prominent parameter in the package, P_EXCEPTIONS_ONLY, corresponds to the user search term “cp_exceptions_only_p”; it controls whether the report returns all delivery lines or restricts output to shipments that produced exceptions in WSH_EXCEPTIONS.

Key Procedures and Functions

  • BEFOREREPORT / BEFOREPFORM / AFTERPFORM / AFTERREPORT — Standard concurrent program and XML report triggers that initialize the package state, populate the CP_* display variables before the report query executes, and perform any post-processing.
  • CF_1FORMULA — A formula column returning a VARCHAR2 value derived from a supplied delivery ID; typically used to render a delivery identifier or descriptive text on the report body.
  • CF_MESSAGE — A formula column that resolves exception-related message text for a given exception ID, sourcing descriptive text for display.
  • CP_BATCH_NAME_P, CP_CUSTOMER_P, CP_SHIP_FROM_P, CP_SHIP_TO_P, CP_ORG_P, CP_PR_BATCH_P, CP_SHIP_METHOD_P — Value-resolution helpers that populate the corresponding CP_* display variables (batch, customer, ship-from, ship-to, organization, picking batch, ship method) from submitted parameter values or lookups.
  • CP_DELIVERY_FROM_P, CP_DELIVERY_TO_P — Helpers that format delivery date range parameters for the report header.
  • CP_TRIP_NAME_P, CP_TRIP_ID_P — Resolve trip name and trip identifier display values.
  • CP_MESSAGE_P, CP_BATCH_ID_P, CP_EXCEPTIONS_ONLY_P — Helpers that finalize the exception message, batch identifier, and the critical CP_EXCEPTIONS_ONLY flag. CP_EXCEPTIONS_ONLY_P maps the P_EXCEPTIONS_ONLY selection into the display variable read by the data model.
  • CP_AUTO_CONFIRM_RULE — Supports the automatic ship-confirm rule parameter used to drive confirmation behavior.

Tables Accessed

The package reads from shipping and reference tables via APPS synonyms. WSH_NEW_DELIVERIES, WSH_DELIVERY_LEGS, and WSH_TRIPS with WSH_TRIP_STOPS provide the delivery, leg, trip, and stop data underlying the report. WSH_EXCEPTIONS supplies exception records when the P_EXCEPTIONS_ONLY filter is applied. WSH_PICKING_BATCHES and WSH_SHIP_CONFIRM_RULES support batch identification and ship-confirm rule lookups. HZ_CUST_ACCOUNTS and HZ_PARTIES resolve customer and party names, while HR_ALL_ORGANIZATION_UNITS provides the organization/inventory name. FND_NEW_MESSAGES is queried to translate message names into readable text for display.

Usage Notes

The package is invoked exclusively through its associated concurrent program and XML Publisher template; it is not called by any other package (referenced by 0 packages). Administrators and technical consultants interact with it indirectly when running the Shipper’s Report, where form parameters such as ship-to, customer, ship method, batch, trip, and the Exceptions Only indicator are bound to the P_* variables. The CP_EXCEPTIONS_ONLY_P logic is the mechanism by which the “cp_exceptions_only_p” search term becomes relevant: selecting this option restricts report output to deliveries containing exceptions, which is the standard diagnostic view for shipment failures. Customizations should avoid altering the package directly and instead modify the underlying XML template or concurrent program definition.