Search Results budgetary_control_flag_p

Overview

GL_GLXRLBOL_XMLP_PKG is a PL/SQL package in the APPS schema that backs the Oracle EBS General Ledger XML Publisher concurrent program associated with the GLXRLBOL report. The name follows the standard XML Publisher packaging convention, in which a concurrent executable defined as an XML Publisher report is bound to a generated PL/SQL package whose procedures supply the data group query and control report execution. The package is declared with AUTHID CURRENT_USER, so all database references resolve through the privileges of the invoking user, and the header identifier GLXRLBOLS.pls confirms its role as a report-support package shipped with the General Ledger module.

Functionally, the package retrieves and exposes budgetary control and organizational hierarchy information for a specified ledger and budget entity. It is responsible for populating the runtime lexicals and select parameters required by the report layout, and for resolving organization IDs through a dedicated helper function.

Key Procedures and Functions

The package exposes twelve documented program units. The two lifecycle functions, BeforeReport and AfterReport, are invoked by the XML Publisher/BIP engine before and after the report data model executes; BeforeReport performs any required setup and validation, while AfterReport handles post-processing and cleanup.

The function gl_get_all_org_id returns the organization identifier used by the report, providing a single point of resolution for the organization context.

The remaining ten functions are generated accessor functions that return the value of package-level variables for use as report parameters. LEDGER_NAME_p returns the ledger name. ORGNAME_p and ORGDESC_p return the organization name and description. ORGPASS_p returns the organization password value. STARTDATE_p and ENDDATE_p return the effective start and end dates for the report range. STRUCT_NUM_p returns the accounting structure number. BUDGETARY_CONTROL_FLAG_p returns the budgetary control indicator. DAS_NAME_p returns the value of the DAS_NAME variable, the element the user searched for.

Tables Accessed

The package reads from three documented tables through APPS synonyms. GL_LEDGERS supplies ledger definition attributes, including the ledger name exposed by LEDGER_NAME_p. GL_BUDGET_ENTITIES provides budget entity details that drive the budgetary control flag and entity identifiers used by the report. GL_ACCESS_SETS supports the resolution of access set and organization security context, which underpins gl_get_all_org_id and the organization-related accessors. The metadata indicates read-only usage; no insert, update, or delete operations are documented.

Usage Notes

This package is not an application programming interface and is not referenced by any other package (referenced by 0 packages). It is invoked exclusively by the Oracle EBS concurrent manager when the associated GL XML Publisher report program is submitted, typically from the General Ledger responsibility for budgetary control and organization reporting. The public accessors are called by the report definition to map package variables into the XML data template. Custom code should not call these functions directly; any extension should instead query GL_LEDGERS, GL_BUDGET_ENTITIES, and GL_ACCESS_SETS independently to avoid dependency on generated report artifacts that may change between 12.1.1 and 12.2.2.