Search Results p_req_number_from

Overview

PO_POXRQSDD_XMLP_PKG is the generated Oracle Reports PL/SQL library package associated with the Purchasing requisition and shipment detail report (commonly known by its report short name POXRQSDD). In Oracle EBS 12.1.1 and 12.2.2, report-specific packages such as this one encapsulate the server-side logic that a concurrent program invokes when an Oracle Reports executable is submitted. The package resides in the APPS schema and contains functions and procedures that the report calls at defined report-level triggers: BeforeReport, AfterReport, AfterPForm, and the various formula columns that shape the result set returned to the report layout.

The primary business purpose of this package is to enforce security and parameter validation before the report extracts data, to derive formatted values for the output, and to construct the dynamic WHERE and ORDER BY clauses used by the report query. The user search term p_req_number_to identifies a report parameter of this package, representing the upper bound of a requisition number range entered on the concurrent program request form. It is generally paired with a corresponding from-value parameter, and both are consumed by the C_WHERE formula to restrict the requisition numbers the report selects.

Key Procedures and Functions

• BEFOREREPORT — Executes at report startup. Retrieves the display value for the ORDER BY parameter from the lookup codes table, resolves the OE status installation information, and returns FALSE to halt execution when the program is not licensed to run.
• GET_PRECISION — Reads the quantity precision system parameter and returns the appropriate numeric format mask so quantity figures display correctly for the operating unit.
• ORDERBY_CLAUSEFORMULA — Supplies the ORDER BY fragment appended to the report query based on the user's sort selection.
• C_WHEREFORMULA — Builds the runtime WHERE clause used to filter requisition, shipment, and related records, incorporating the requisition number range supplied through parameters such as p_req_number_to.
• C_FROMFORMULA — Builds the FROM clause required by the dynamic query.
• C_SHIPPED_QTYFORMULA, C_SELLING_PRICEFORMULA — Format the shipped quantity and selling price columns for display.
• C_GET_SHIPPED_QUANTITY, GET_SHIPPED_QUANTITY — Retrieve the quantity shipped for a requisition line for use in the report output.
• AFTERPFORM — Runs after the parameter form is evaluated, allowing parameter-dependent setup to occur before data extraction.
• AFTERREPORT — Runs at report completion, typically releasing resources and finalizing output.
• C_QUANTITY_SHIPPED_P, C_QUANTITY_VARIANCE_P, C_COST_VARIANCE_P — Report formula columns computing shipped quantity, quantity variance, and cost variance metrics for each displayed row.

Tables Accessed

• OE_ORDER_HEADERS_ALL — Supplies sales order header information joined to shipment data so ordered quantities and header attributes are available to the report.
• OE_ORDER_LINES_ALL — Provides line-level order details used in quantity shipped, quantity variance, and cost variance calculations.
• PO_SYSTEM_PARAMETERS — Provides Purchasing setup values, including quantity precision, that control formatting and calculation behavior.

Lookup values are additionally read from the PO_LOOKUP_CODES view for sort and message resolution.

Usage Notes

This package is invoked by the Oracle Reports executable submitted through the Purchasing concurrent program that runs the requisition and shipment detail report. It is not intended to be called directly from forms or custom PL/SQL. Parameters such as p_req_number_to are passed to the report from the concurrent request parameter form; the package consumes them at BeforeReport and AfterPForm to constrain and format the output. Customizations should be performed only in the report-specific package version and recompiled through adadmin or adcrtrep to remain upgrade-safe.