Search Results p_trace_flag

Overview

APPS.INV_INVSRUOM_XMLP_PKG is a generated PL/SQL package that supports the Oracle E-Business Suite concurrent program for the Inventory Unit of Measure report (internal short name INVSRUOM). The report produces a listing of units of measure and their associated conversion information for inventory organizations. Like most XML Publisher (BI Publisher) report packages in EBS 12.1.1 and 12.2.2, this package acts as the PL/SQL wrapper embedded in the report definition: it declares the bind parameters used by the report, defines the pre-report and post-formula triggers that XML Publisher invokes during report execution, and exposes the parameter variables so that the report SQL and template logic can reference them.

The package source header indicates a last revision of 120.1 dated 2007/12/25 and is flagged noship, consistent with the typical state of generated report packages that are distributed as part of the standard application seed data. The owner is APPS, and the API classification is OTHER, reflecting that this is a report-support package rather than a public business API.

Key Procedures and Functions

Two functions are documented, both conforming to the standard XML Publisher report-trigger interface:

• BEFOREREPORT – Executed before the report data is fetched. It is used to perform report-level initialization, such as setting up session context or defaulting parameter values, so that the subsequent report query runs against the correct operating context.
• AFTERPFORM – Executed after the parameter form (the concurrent program parameter entry step) is completed. It is used to validate, derive, or transform parameter values after user entry and before the main report query executes.

No parameter lists are documented for these functions; only their names and the standard trigger roles are defined. Customization of behavior should be limited to the bodies of these triggers rather than to the package specification, which declares the bind variables.

Tables Accessed

The ETRM metadata records no directly referenced tables via APPS synonyms. In practice, the data retrieval for this report is performed by the report's SQL query definition rather than by the package body, which is the standard XML Publisher design. The package itself primarily manipulates parameter values and session state. Any tables that appear in the report output (for example, unit-of-measure and conversion entities) are accessed through the associated XML Publisher data definition, not through this package.

Usage Notes

The package declares three key bind parameters relevant to report execution and diagnostics:

• P_CONC_REQUEST_ID – VARCHAR2(15) initialized to '0'; holds the concurrent request identifier for the report run and is used to associate log and output with the correct request.
• P_TRACE_FLAG – NUMBER; a debug/tracing switch commonly used to enable diagnostic output during report execution. This is the parameter referenced in the search term "p_trace_flag."
• P_OPTIMIZER_CODE and P_ORGANIZATION_ID – NUMBER parameters controlling query optimization and restricting the report to a specific inventory organization, respectively.

INV_INVSRUOM_XMLP_PKG is invoked by the XML Publisher engine when the INVSRUOM concurrent program is submitted. It is not called directly by forms or other PL/SQL packages; the metadata shows zero referencing packages. Developers troubleshooting the report, or enabling trace output, typically focus on P_TRACE_FLAG. Standard practice is to avoid modifying seeded report packages where possible, since they may be overwritten by patching; use a copy or an extension package for custom logic. This package behaves identically under EBS 12.1.1 and 12.2.2, as the XML Publisher trigger framework is unchanged between those releases.