Search Results p_das_id

Overview

APPS.GL_GLXRBJRN_XMLP_PKG is the generated PL/SQL package body associated with the Oracle EBS General Ledger report "GLXRBJRN" (Journal report). In Oracle E-Business Suite 12.1.1 and 12.2.2, reports built with Oracle Reports/BI Publisher are wrapped by the Reports Server, which invokes a corresponding server-side package to supply the SQL and PL/SQL data model logic. This package, identified by the header comment $Header: GLXRBJRNB.pls 120.0 2007/12/27, belongs to the APPS schema and is classified as OTHER in the ETRM metadata.

Its primary responsibility is the BeforeReport trigger, which resolves the runtime parameters of the report into meaningful values before the data query executes. Specifically, it translates a ledger identifier into a chart of accounts identifier and ledger name, resolves a budget version identifier into a budget name, and resolves a data access set identifier into a DAS name. It then constructs the security WHERE clause used to filter journal data by data access set.

Key Procedures and Functions

The package exposes eight documented program units. These are the standard Reports integration points plus the user-named local overrides used to expose report parameters:

• BEFOREREPORT — The main initialization function. It calls gl_info.gl_get_ledger_info to derive the chart of accounts ID, ledger name, and functional currency from the ledger ID, populates the global STRUCT_NUM and LEDGER_NAME, queries the budget name and the data access set name, sets the WHERE_DAS security clause, and raises -20101 on error to abort the report.
• AFTERREPORT — The post-execution hook, used to perform cleanup or finalization after report output is produced.
• STRUCT_NUM_P — Returns the chart of accounts structure number (STRUCT_NUM) resolved during BeforeReport.
• LEDGER_NAME_P — Returns the ledger name resolved from the ledger ID.
• FLEXDATA_P — Returns summary/flexfield data used in the report layout.
• BUDGET_NAME_P — Returns the budget name resolved from the budget version ID.
• DAS_NAME_P — Returns the data access set name. This is the program unit referred to by the user's search term das_name, sourced from GL_ACCESS_SETS.NAME.
• WHERE_DAS_P — Returns the security WHERE clause generated by GL_ACCESS_SET_SECURITY_PKG.GET_SECURITY_CLAUSE for the given DAS ID.

Tables Accessed

The package reads two documented tables through APPS synonyms:

• GL_BUDGET_VERSIONS — queried for BUDGET_NAME using the budget version ID passed as a parameter.
• GL_ACCESS_SETS — queried for NAME to populate DAS_NAME, keyed on the access set ID. A NO_DATA_FOUND condition raises a localized message via gl_message.get_message ('GL_PLL_INVALID_DATA_ACCESS_SET') before aborting.

Additional data is retrieved indirectly through the gl_info and GL_ACCESS_SET_SECURITY_PKG APIs rather than direct table access.

Usage Notes

This package is not intended for direct invocation by end users or custom code — it is generated and invoked by the Oracle Reports runtime when the GLXRBJRN concurrent program executes. The XMLP naming convention confirms it is wired into the XML Publisher/Reports integration layer. Because ETRM records zero downstream dependencies, no other package references it. Customizations should be applied through the underlying report definition and the public GL APIs (gl_info, GL_ACCESS_SET_SECURITY_PKG) rather than by editing this generated body, since regeneration by the Reports Server would overwrite direct modifications.