Search Results gl_glxrlbol_xmlp_pkg




Overview
Explore in AI Chat

Overview

APPS.GL_GLXRLBOL_XMLP_PKG is a server-side PL/SQL package body that supports the Oracle General Ledger budgetary control reporting infrastructure in Oracle E-Business Suite releases 12.1.1 and 12.2.2. The package is registered in the APPS schema with VALID status and is classified under the ETRM "OTHER" API classification, indicating that it is not a public or open interface but rather a private implementation package bound to a specific concurrent program or XML Publisher report definition. The suffix "XMLP" confirms that the package belongs to the Oracle XML Publisher (BI Publisher) report generation framework, and its procedures supply the runtime parameters and lexical values that an XML Publisher data template or report layout requires before the SQL query executes. The "GLXRLBOL" naming element reflects the General Ledger reporting context, with the report oriented toward ledger, organization, and budgetary control attributes used in the Budgetary Control and Reserve Ledger Balances reporting family. The package therefore serves the business function of retrieving and staging General Ledger context information — ledger identity, access set security, organization identifiers, and budgetary control flags — so that the associated concurrent program produces a correctly filtered and secured financial report.

Key Procedures and Functions

The package exposes twelve documented procedures and functions. Their purposes are as follows:

  • BEFOREREPORT — The standard XML Publisher before-report trigger that initializes package-level state and resolves report parameters prior to data extraction.
  • AFTERREPORT — The standard after-report trigger, typically used to release resources and finalize package state once the report completes.
  • GL_GET_ALL_ORG_ID — Returns the full organization identifier context, supporting multi-organization filtering in General Ledger reporting.
  • LEDGER_NAME_P — Resolves the display name of the selected ledger.
  • ORGNAME_P — Resolves the name of the organization associated with the report run.
  • ORGDESC_P — Returns the descriptive text for the organization.
  • ORGPASS_P — Supplies the organization parameter passed through to the report query.
  • STARTDATE_P — Provides the report's start date parameter.
  • ENDDATE_P — Provides the report's end date parameter.
  • STRUCT_NUM_P — Returns the accounting structure number, identifying the chart of accounts context.
  • BUDGETARY_CONTROL_FLAG_P — Indicates whether budgetary control is enabled for the reporting context.
  • DAS_NAME_P — Returns the Data Access Set name, which governs ledger and balancing segment security for the querying user.

Tables Accessed

The package reads from three documented General Ledger tables via APPS synonyms: GL_ACCESS_SETS, GL_BUDGET_ENTITIES, and GL_LEDGERS. GL_ACCESS_SETS supplies Data Access Set definitions that drive the DAS_NAME_P and ledger security logic. GL_BUDGET_ENTITIES provides budgetary control configuration used by BUDGETARY_CONTROL_FLAG_P. GL_LEDGERS provides the ledger definition, name, and chart of accounts context required by LEDGER_NAME_P and STRUCT_NUM_P. The dependency list also references GL_LOOKUPS, GL_INFO, GL_MESSAGE, and DBMS_STANDARD, which supply lookup values, message handling, and standard PL/SQL utilities.

Usage Notes

This package is invoked indirectly by its parent XML Publisher concurrent program rather than called directly from forms or custom code. The BEFORE- and AFTER-REPORT hooks follow the standard XML Publisher PL/SQL trigger convention, and the *_P functions act as parameter getters consumed by the report's data template. Because the package is classified as OTHER and is not referenced by any other database object, it should be treated as private implementation rather than a supported extension point. Customizations should target the underlying concurrent program or report definition instead of the package body.