Search Results funct_curr_code

Overview

GL_GLXBCSD_XMLP_PKG is the generated PL/SQL package body that supports the Oracle E-Business Suite XML Publisher (BI Publisher) report commonly associated with the GLXBCSD concurrent program — a General Ledger budgetary control / account security data extract report. Like all XMLP_PKG packages, it is automatically produced by Oracle Reports when a report definition is migrated to the XML Publisher publishing model. Rather than containing report layout logic, the package acts as the PL/SQL data model driver: it resolves runtime parameters into query fragments, caches frequently referenced values, and exposes them to the report's data definition through user-defined placeholder functions. In the context of a user search for "funct_curr_code," this package is significant because its BeforeReport function populates the FUNCT_CURR_CODE variable (the functional currency code) from the GL_LEDGERS table, and exposes it to the report through the FUNCT_CURR_CODE_P placeholder function. This value is typically used in the report output for currency conversion display, column headers, or amount formatting.

Key Procedures and Functions

The package documents eleven procedures and functions:

• BEFOREREPORT — The primary initialization routine. It queries GL_ACCESS_SETS to obtain the access set name and chart of accounts structure number, queries GL_LEDGERS to populate LEDGER_NAME and FUNCT_CURR_CODE, and queries GL_BUDGET_VERSIONS for BUDGET_NAME. It also invokes GL_ACCESS_SET_SECURITY_PKG.GET_SECURITY_CLAUSE to build the DAS_WHERE data access security restriction. Its header indicates a 2008 revision date.
• AFTERREPORT — A cleanup/termination stub that returns TRUE. In the original Oracle Reports form it would have issued SRW.USER_EXIT('FND SRWEXIT'); that call is commented out in the XML Publisher version.
• STRUCT_NUM_P — Placeholder function returning the chart of accounts structure number (STRUCT_NUM).
• LEDGER_NAME_P — Placeholder function returning the ledger name resolved in BeforeReport.
• BUDGET_NAME_P — Placeholder function returning the budget name resolved in BeforeReport.
• FUNCT_CURR_CODE_P — Placeholder function returning the functional currency code, the value implied by the user's "funct_curr_code" search term.
• ACCESS_SET_NAME_P — Placeholder function returning the data access set name.
• DAS_WHERE_P — Placeholder function returning the data access security WHERE clause fragment used to filter ledger rows.
• FLEXDATA_P, FLEX_ORDERBY_P, FLEX_WHERE_P — Placeholder functions supporting the Key Flexfield (Accounting Flexfield) segment display: the concatenated segment value, its ORDER BY clause, and its WHERE clause.

Tables Accessed

Three GL tables are referenced through APPS synonyms: GL_ACCESS_SETS (read to resolve the access set name and chart of accounts ID from P_ACCESS_SET_ID), GL_LEDGERS (read to resolve the ledger name and functional currency code, FUNCT_CURR_CODE, from P_LEDGER_ID), and GL_BUDGET_VERSIONS (read to resolve the budget name from P_BUDGET_VERSION_ID). All accesses are read-only lookups performed during report initialization; the package itself performs no DML.

Usage Notes

This package is never invoked directly by end users. In Release 12.1.1 and 12.2.2 it is called by the XML Publisher engine when the associated GLXBCSD concurrent program is submitted, or when the report is run from a GL responsibility. BeforeReport executes once per report run to validate parameters — raising ORA-20101 via RAISE_APPLICATION_ERROR and GL_MESSAGE if the access set is invalid or any lookup fails. The placeholder functions are then called by the report template as data-model triggers to supply ledger, budget, currency, and flexfield values. Because the original SRW calls are commented out, the package is tightly bound to the XML Publisher execution model and inherits its concurrency manager and data security context; custom code should not call it directly, as parameter binding and package-level state (STRUCT_NUM, LEDGER_NAME, FUNCT_CURR_CODE, BUDGET_NAME, DAS_WHERE) depend on prior BeforeReport execution.