Search Results p_gl_num

Overview

INV_INVSRAAL_XMLP_PKG is the generated PL/SQL package specification that supports the Oracle E-Business Suite concurrent program associated with the report source file INVSRAALS.pls (header revision 120.1, dated 2007/12/25). In Oracle EBS, report-based concurrent programs built on Oracle Reports use a paired PL/SQL package, conventionally suffixed with _XMLP_PKG, to hold the report's global (bind) parameters and its report-level trigger logic. This package is declared AUTHID CURRENT_USER, meaning its SQL statements execute under the privileges of the invoking user rather than the package owner, which is the standard convention for these report-support packages so that report execution respects the caller's responsibility and organization context.

The business function of the package is to expose the report's parameter interface and pre-execution processing hooks for the Inventory subledger summarization/accounting report identified by the INV_INVSRAAL program short name. The user search term "p_gl_num" maps directly to the declared global parameter P_GL_NUM, one of the report's selection parameters.

Key Procedures and Functions

The package specification documents two functions:

• BEFOREREPORT — the BeforeReport trigger function. It is invoked by Oracle Reports immediately before the report's main data query executes, and is conventionally used to derive or default parameter values, set up session context, and prepare any data the report body depends on. It returns BOOLEAN, as required by the Reports trigger signature.
• AFTERPFORM — the AfterPForm trigger function. It is invoked after the parameter form has been processed, and is used to validate or transform the user-supplied parameter values before the report query runs. It also returns BOOLEAN.

Note that no parameter lists are declared for these functions in the documented metadata; only their names and return type are specified, and they should be referenced as documented.

Tables Accessed

The ETRM metadata for this package documents no tables referenced via APPS synonyms. This is consistent with the nature of report-support package specifications: data access for the report is performed predominantly by the underlying Oracle Reports query (in INVSRAALS.rdf), not by the package body. Any table access performed by the package would occur inside the package body, which is not represented in the documented specification.

Usage Notes

INV_INVSRAAL_XMLP_PKG is not intended to be called directly from forms or custom code. It is invoked automatically by the Oracle Reports runtime when the associated Inventory concurrent program is submitted from the Standard Concurrent Programs (or Standard Request Submission) interface in EBS 12.1.1 or 12.2.2. The declared globals — P_GL_NUM, P_MDSP_NUM, P_CONC_REQUEST_ID, P_GL_FLEXDATA, P_MDSP_FLEXDATA, P_MDSP_ORDER_BY, P_TRACE_FLAG, P_OPTIMIZER_CODE, and P_ORGANIZATION_ID — are populated either from the concurrent program's parameter form (P_GL_NUM, P_MDSP_NUM) or at runtime, for example P_CONC_REQUEST_ID, which is initialized to '0' and set to the actual concurrent request ID by the Reports runtime. Because the package specification is regenerated whenever INVSRAALS.pls is rebuilt, any custom extension should avoid modifying this package directly and instead rely on standard report customization mechanisms.