Search Results p_org_displayed

Overview

PO_POXRVRUR_XMLP_PKG is an Oracle Applications (APPS) package body that supports the Oracle Purchasing XML Publisher report POXRVRUR, commonly associated with the Receiving Transaction Register / Receiving Value Report family in Oracle E-Business Suite 12.1.1 and 12.2.2. The package implements the standard Oracle Reports-to-XML-Publisher conversion structure, exposing a set of report-level trigger functions that the BI Publisher engine calls at defined points in the concurrent request lifecycle. Its primary responsibilities are to initialize the report context, resolve the organization display name from the supplied organization identifier, set the numeric formatting mask based on the user-supplied quantity precision parameter, capture the concurrent request identifier, and return control to the reporting framework.

Key Procedures and Functions

• BEFOREREPORT — The principal initialization function. It resolves P_ORG_ID against ORG_ORGANIZATION_DEFINITIONS and populates P_ORG_DISPLAYED, then derives FORMAT_MASK by invoking PO_COMMON_XMLP_PKG.GET_PRECISION with P_QTY_PRECISION and assigns P_CONC_REQUEST_ID from FND_GLOBAL.CONC_REQUEST_ID. This is the point at which the searched parameter P_QTY_PRECISION is consumed.
• AFTERREPORT — Post-processing hook executed after the report data model completes; returns TRUE unconditionally in the shipped version.
• GET_PRECISION — A local helper procedure that inspects P_QTY_PRECISION and branches across the recognized precision values (0, 1, 3, 4, 5, 6). In the delivered source each branch executes NULL, confirming the procedure exists as a placeholder for formatting logic that is effectively delegated to PO_COMMON_XMLP_PKG.GET_PRECISION.
• AFTERPFORM — Trigger fired after the report parameter form is processed; returns TRUE.
• BETWEENPAGE — Trigger fired between report pages; returns TRUE.
• BEFOREPFORM — Trigger fired before the parameter form is displayed; returns TRUE.

P_QTY_PRECISION is therefore the user-facing parameter that governs quantity display precision, and FORMAT_MASK is the derived mask applied to numeric columns in the XML output.

Tables Accessed

• ORG_ORGANIZATION_DEFINITIONS — Read by BEFOREREPORT. The query selects ORGANIZATION_NAME for the ORGANIZATION_ID matching P_ORG_ID, providing the human-readable inventory organization name displayed on the report header. When P_ORG_ID is null, P_ORG_DISPLAYED is set to an empty string.

No other base tables are referenced directly within this package body; report data is supplied by the underlying XML Publisher data definition and its SQL query, not by PL/SQL within this package.

Usage Notes

This package is invoked automatically by the Oracle Reports / XML Publisher concurrent program runtime for the POXRVRUR report; it is not intended for direct invocation from forms or custom code. The ETRM metadata records zero packages referencing it and no API classification beyond OTHER, confirming its role as a report-local implementation unit. Customizations should avoid modifying the shipped body, since the $Header$ signature (120.1, dated 2007/12/25) indicates a long-stable file and any change risks conflict during patching or upgrade between 12.1.1 and 12.2.2. When troubleshooting quantity formatting, P_QTY_PRECISION and the FORMAT_MASK derived from it are the expected diagnostic entry points.