Search Results f_sort_order

Overview

WSH_WSHRDOPN_XMLP_PKG is a report-support package body owned by APPS that underpins the Oracle Shipping open orders extract. Its purpose is to assemble the data bind variables and derived values required by the XML Publisher (BI Publisher) report definition that prints the open (unshipped) order or delivery information for a given warehouse. The package performs the classic Oracle Reports-to-XML-Publisher wrapper role: the report definition invokes it at defined trigger points, and the package resolves organization codes, organization names, customer details, item display meanings and picking batch references, then hands those values back as bind parameters used by the report's data model and format triggers.

In EBS 12.1.1 and 12.2.2 this pattern is typical of converted report templates where the original PL/SQL library logic was consolidated into a package body. The package operates on the operational warehouse dataset — MTL_PARAMETERS, HR_ALL_ORGANIZATION_UNITS, HZ_CUST_ACCOUNTS, MTL_SYSTEM_ITEMS_KFV and WSH_PICKING_BATCHES — making it read-only with respect to transactional data.

Key Procedures and Functions

• BEFOREREPORT — Main entry point. Defines the local cursors that resolve the organization code (GET_ORG_CODE), organization name (GET_ORG_NAME), customer account number (GET_CUSTOMER), item display meaning (GET_ITEM_DISP_MEANING), item concatenated segments (GET_ITEM_NAME), batch name (GET_BATCH_NAME) and sort display meaning (GET_SORT_DISP_MEANING). It also initialises the concurrent request id via FND_GLOBAL.CONC_REQUEST_ID.
• BEFOREPFORM — Performs setup prior to the report's parameter form; establishes defaults for the parameter form.
• AFTERPFORM — Executes after the parameter form values are captured, ensuring parameter values are available before the main report query runs.
• AFTERREPORT — Cleanup / post-processing hook executed after the report data model completes.
• CF_SHIPMENT_PRIORITYFORMULA and CF_LPNFORMULA — Formula columns executed per report row to derive display text, typically formatting shipment priority and LPN (licence plate number) values.
• CP_* group — Parameter/formula functions invoked for specific attributes: CP_WAREHOUSE_NAME_P, CP_WHSE_LONGNAME_P, CP_P_SHIPTO_LOCATION_P, CP_P_CUSTOMER_P, CP_TEMP_P, CP_P_SHIP_METHOD_P, CP_P_ITEM_NO_P, CP_P_BATCH_NO_P, CP_P_FROM_CREATION_DATE_P, CP_P_TO_CREATION_DATE_P, CP_P_ITEM_DISPLAY_P and CP_P_SORT_ORDER_P. Each computes or returns a single display value bound to the corresponding report parameter.

Tables Accessed

• MTL_PARAMETERS — resolves ORGANIZATION_CODE for the entered organization id.
• HR_ALL_ORGANIZATION_UNITS — resolves the organization NAME for header display.
• HZ_CUST_ACCOUNTS — resolves ACCOUNT_NUMBER for the customer identifier.
• MTL_SYSTEM_ITEMS_KFV — resolves CONCATENATED_SEGMENTS for the item within the organization.
• WSH_PICKING_BATCHES — resolves the picking batch NAME for the batch id.

Lookups are additionally read from FND_LOOKUP_VALUES_VL and WSH_LOOKUPS for item display and sort-by meanings; the metadata lists these as lookup sources rather than base tables.

Usage Notes

The package is invoked exclusively as a supporting unit of the WSH open orders XML Publisher report. It is registered as the report's PL/SQL package on the concurrent program definition, and the report template calls BEFOREREPORT before execution and AFTERREPORT afterwards. It is not designed as a public API — no other packages reference it — so customisations should call the report or read the same tables directly rather than invoking these procedures. Because it is read-only and driven by concurrent request parameters, it is safe under standard multi-org access, provided the responsible organisation is set for the session.