Search Results gl_glxbcsd_xmlp_pkg

Overview

GL_GLXBCSD_XMLP_PKG is the generated PL/SQL package body associated with the Oracle E-Business Suite concurrent program that produces the General Ledger Budget Status (Comparative) report — internally identified by the executable short name GLXBCSD and delivered through the XML Publisher (BI Publisher) reporting framework. As with all XMLP wrapper packages in Release 12.1.1 and 12.2.2, this package exists to bind a report definition to the Oracle Reports/XML Publisher runtime, supplying substitution values, lexical parameters, and the before/after report logic that the report engine invokes during execution. Its functional purpose is to present budget-versus-actual balances for a selected ledger, budget version, accounting period, and account segment range, in both the ledger currency and the functional currency, while respecting the data access set assigned to the requesting user. The package header shown in the ETRM extract carries package-level global variables for the concurrent request ID, ledger, budget version, currency code, period name, access set, and a large WHERE clause fragment named DAS_WHERE, together with the standard after-report and before-report entry points and a series of _p accessor functions.

Key Procedures and Functions

• AfterReport — Returns a boolean and executes once the report has completed output generation; it is the standard XML Publisher post-processing hook, used to release resources or reset package state following a run.
• BeforeReport — Returns a boolean and executes prior to report data retrieval; it is the customary location for deriving runtime parameters, populating package globals such as LEDGER_NAME, BUDGET_NAME, ACCESS_SET_NAME, and FUNCT_CURR_CODE, and for validating the user's selection before the query executes.
• STRUCT_NUM_p — Accessor returning the numeric structure (chart of accounts) identifier, initialized in the package specification to 50105, which governs the key flexfield segments used in the report's account display.
• LEDGER_NAME_p — Accessor returning the descriptive name of the ledger selected at runtime, resolved from the ledger identifier parameter for display in the report heading.
• BUDGET_NAME_p — Accessor returning the name of the budget version being reported against, resolved from the budget version identifier.
• FLEXDATA_p — Accessor returning the concatenated key flexfield segment expression. The package specification defines FLEXDATA as a concatenation of segment1 through segment30 separated by newline characters, producing the multi-line account description rendered in the report output.
• FLEX_ORDERBY_p — Accessor returning the ordering directive for the account flexfield, defaulted to the value '1'.
• FLEX_WHERE_p — Accessor returning the lexical WHERE fragment applied to the flexfield account segments, defaulting to segment1 = segment1, which is subsequently narrowed by the runtime segment values entered by the user.
• ACCESS_SET_NAME_p — Accessor returning the name of the data access set associated with the report run, used to communicate the security scope applied to ledger and balancing segment data.
• FUNCT_CURR_CODE_p — Accessor returning the functional currency code of the ledger, enabling the report to show amounts in both entered and functional currency.
• DAS_WHERE_p — Accessor returning the DAS_WHERE package variable, an 800-character string that holds the data access set WHERE clause fragment injected into the report query. This is the object of the user's search term "das_where_p": it exposes the dynamically constructed access-set predicate so the report SQL can enforce ledger-level security without hard-coding the restriction.

Tables Accessed

The package operates against three documented tables accessed through APPS synonyms. GL_LEDGERS supplies ledger definitions, including ledger name, functional currency, and chart of accounts structure, supporting LEDGER_NAME and FUNCT_CURR_CODE. GL_BUDGET_VERSIONS supplies budget version names and their association with ledgers, supporting BUDGET_NAME. GL_ACCESS_SETS supplies data access set definitions, supporting ACCESS_SET_NAME and the DAS_WHERE security predicate. The report's actual balance retrieval is performed by the underlying report query rather than by package-level DML; no insert, update, or delete operations are attributed to this package.

Usage Notes

GL_GLXBCSD_XMLP_PKG is not intended for direct invocation by custom code. It is called by the XML Publisher concurrent program runtime when the Budget Status (Comparative) report is submitted, typically from the Standard Report Submission form or from General Ledger responsibility menus. The concurrent request ID parameter identifies the submission, and the report engine calls BeforeReport, evaluates the _p accessor functions to substitute values into the report template, then calls AfterReport. The ETRM metadata records no packages referencing this object, confirming it sits at the top of the call stack as a report entry point rather than as a reusable library. Customizations should be made through the report definition and template rather than by modifying this generated package. In 12.2.2 the object remains functionally identical to its 12.1.1 counterpart, with the header revision dated 2008 and marked noship, indicating no shipped code changes between releases.