Search Results where_template




Overview
Explore in AI Chat

Overview

APPS.GL_GLXRLACH_XMLP_PKG is the generated PL/SQL package body that backs the Oracle E-Business Suite General Ledger XML Publisher (BI Publisher) concurrent report GLXRLACH, commonly associated with the GL Account Analysis and ledger activity reporting family. The package follows the standard XML Publisher report package pattern: Oracle Reports or the XML Publisher engine invokes a package-level BeforeReport trigger and a set of placeholder functions that expose PL/SQL variables to the report data model and layout templates.

The business purpose of the package is to establish ledger context (ledger identifier, ledger name, chart of accounts identifier, and functional currency) before the report query executes, and to assemble dynamically generated SQL fragments—most notably the Data Access Set security predicate and template filters—that are appended to the report's SELECT statement. The package header carries the source control marker GLXRLACHB.pls 120.0 2007/12/27, and it is classified as an OTHER API in ETRM, meaning it is not a formally supported public interface but a report-internal component. The user search term "where_das" corresponds directly to the WHERE_DAS package variable, which holds the Data Access Set security clause injected into the report SQL.

Key Procedures and Functions

  • BEFOREREPORT — The initialization entry point. It calls gl_info.gl_get_ledger_info to populate the chart of accounts identifier, ledger name, and functional currency, raising a fatal application error if the ledger cannot be resolved. It also builds WHERE_TEMPLATE from P_TEMPLATE_ID and constructs WHERE_DAS by calling GL_ACCESS_SET_SECURITY_PKG.GET_SECURITY_CLAUSE, prefixing the result with "AND" when non-null.
  • AFTERREPORT — Executes after report completion; retained for the standard SRW exit hook.
  • NEW_DESCFORMULA — Implements a change-detection formula comparing the current account description (C_DESC_ACCT_DET) against the stored OLD_DESC, returning 'Y' on change and 'N' otherwise, used for controlled suppression of repeated descriptions.
  • OLD_DESC_P — Placeholder accessor returning the cached prior account description.
  • LEDGER_NAME_P — Placeholder accessor returning the ledger name resolved in BeforeReport.
  • P_FLEXDATA_SUM_P / P_FLEXDATA_DET_P — Placeholders exposing the summary and detail flexfield (accounting flexfield) display strings to the report layout.
  • P_ORDER_BY_SUM_P / P_ORDER_BY_DET_P — Placeholders exposing the user-selected ORDER BY clauses for the summary and detail queries.
  • STRUCT_NUM_P — Placeholder returning the chart of accounts identifier assigned in BeforeReport.
  • WHERE_DAS_P — Placeholder returning the Data Access Set security clause (WHERE_DAS) for injection into the report SQL.
  • WHERE_TEMPLATE_P — Placeholder returning the template filter clause (WHERE_TEMPLATE).

Tables Accessed

The package body itself does not contain embedded SQL against application tables; all data retrieval is performed by the XML Publisher data model against APPS synonyms. Ledger attributes are obtained indirectly through GL_INFO.GL_GET_LEDGER_INFO and access set predicates through GL_ACCESS_SET_SECURITY_PKG. The underlying report query reads General Ledger account analysis and ledger activity sources, with security enforced by the WHERE_DAS clause.

Usage Notes

This package is invoked only by the GLXRLACH XML Publisher concurrent program; it is not referenced by any other package in ETRM. The WHERE_DAS value is central to row-level security: it is generated from the Access Set specified at submission and restricts returned ledger data to the ledgers and balancing segment values the access set permits. Customizations should avoid direct calls to this package, since regeneration of the XML Publisher report definition overwrites the body.