Search Results coa_name_p

Overview

APPS.GL_GLXRLRUR_XMLP_PKG is the PL/SQL wrapper package that supports the Oracle General Ledger XML Publisher report associated with the "GLXRLRUR" concurrent program short name. The package specification carries the header identifier $Header: GLXRLRURS.pls 120.0 2007/12/27 15:18:18 vijranga noship $, indicating that it was authored as a "noship" (not shipped as a standalone database object outside the EBS file system delivery) module tied to a specific reporting artifact. Its purpose is to declare the bind/parameter variables and the report trigger functions that the XML Publisher (Oracle BI Publisher) engine calls at runtime to produce a General Ledger report output.

The package exposes public package-level variables, including P_CONC_REQUEST_ID, P_STRUCT_NUM, P_SEGMENT_NAME, STRUCT_NUM, and COA_NAME. These correspond to the concurrent request identifier and the Chart of Accounts (COA) / accounting structure selection parameters submitted when the report is run. The presence of COA_NAME and its accessor function COA_NAME_p confirms that the report is parameterized by chart of accounts, which is consistent with General Ledger reporting objects that must resolve the correct accounting flexfield structure before data extraction.

Key Procedures and Functions

The package documents four callable units:

• BeforeReport — A function returning BOOLEAN, invoked by the Oracle Reports/XML Publisher runtime before the report query executes. It performs initialization and parameter validation logic, typically resolving the accounting structure and chart of accounts values needed by the report.
• AfterReport — A function returning BOOLEAN, invoked after report execution completes. It performs any cleanup or post-processing required once the report data set has been rendered.
• STRUCT_NUM_p — A function returning VARCHAR2 that supplies the accounting structure number (STRUCT_NUM) to the report definition, exposing the resolved structure value as a report-level bind.
• COA_NAME_p — A function returning VARCHAR2 that supplies the chart of accounts name (COA_NAME) to the report definition. This is the accessor most directly relevant to the user's search term "coa_name_p": it returns the COA name resolved from the report parameters so that the XML Publisher template and query can filter and display the correct chart of accounts.

No parameter lists are documented for these functions; the metadata exposes only their names and return types.

Tables Accessed

The ETRM metadata does not record any direct table references through APPS synonyms for this package. As a typical XML Publisher report wrapper, data access is generally delegated to the concurrent program's SQL query and to the underlying GL reporting views rather than being performed directly inside the PL/SQL package body. Consequently, no documented base or interface tables can be listed with certainty from the supplied excerpt.

Usage Notes

GL_GLXRLRUR_XMLP_PKG is not an application programming interface intended for customer invocation. It is classified as OTHER and is referenced by zero other packages, meaning it functions as a self-contained report-support module. It is executed indirectly by the concurrent manager whenever the GLXRLRUR concurrent program is submitted: the report runtime calls BeforeReport, retrieves parameter values via the STRUCT_NUM_p and COA_NAME_p accessors, runs the report query, and finally calls AfterReport. Customizations should not modify this package; instead, extensions are normally applied to the underlying XML Publisher data template or by copying the report. The package is compatible with Oracle EBS 12.1.1 and 12.2.2, where the same concurrent program and package structure are retained.