Search Results c_chart_of_accts_id

Overview

APPS.GL_GLYRLJGE_XMLP_PKG is the package body that backs the Oracle EBS General Ledger "Journal Entries Report" (report short name GLYRLJGE), a concurrent report that lists detailed journal entry lines for a selected ledger, period range, and data access set. The package is generated in the standard Oracle Reports XML Publisher (XMLP) pattern, where the report's PL/SQL library is built as a package body containing the report's BeforeReport and AfterReport triggers, group filters, and formula columns. Its principal business purpose in both 12.1.1 and 12.2.2 is to resolve the runtime reporting context — ledger, period range, chart of accounts, and data access security — and to hand that context to the report query at execution time.

The user's search term "c_access_where" refers directly to the package-level variable C_ACCESS_WHERE, which is central to this package's function. It is not a procedure or function; it is a package variable that holds the SQL predicate fragment generated by GL_ACCESS_SET_SECURITY_PKG.GET_SECURITY_CLAUSE and then prefixed with " AND " before being concatenated into the report's WHERE clause.

Key Procedures and Functions

The documented interface includes 36 procedures and functions. The most significant are:

• BEFOREREPORT — the primary entry point. It queries GL_ACCESS_SETS to populate C_ACCESS_SET_NAME and C_CHART_OF_ACCTS_ID, derives C_START_DATE/C_END_DATE and their display forms from P_START_PERIOD/P_END_PERIOD, and sets P_STRUCT_NUM. It then calls GET_SECURITY_CLAUSE to populate C_ACCESS_WHERE and prepends " AND " if the clause is non-null. It also conditionally loads ledger attributes (name, currency, object type, consolidation flag, period set, accounted period type) when P_LEDGER_ID is passed.
• AFTERREPORT — the complementary teardown trigger.
• C_ACCESS_SET_NAME, C_CHART_OF_ACCTS_ID_P, C_START_DATE_P, C_WHERE_P — accessor functions exposing package state to the report layout.
• Formula columns — C_CURR_NAMEFORMULA, C_BAL_LPROMPTFORMULA, COMPANY_LPROMPT_NDFORMULA, ZERO_INDICATORFORMULA, C_MESSAGEFORMULA, C_ENTRYFORMULA.
• Group filters — G_JOURNALGROUPFILTER, G_JOURNAL_ENTRIESGROUPFILTER, G_BATCHESGROUPFILTER, G_COMPANY_MASTERGROUPFILTER.
• Environment helpers — SET_DISPLAY_FOR_CORE, SET_DISPLAY_FOR_GOV, GET_INDUSTRY_CODE, GL_FORMAT_CURRENCY, BETWEENPAGE.

Tables Accessed

The package reads from the following APPS synonyms:

• GL_ACCESS_SETS — to validate P_ACCESS_SET_ID and obtain the access set name and chart of accounts ID.
• GL_LEDGERS — to resolve ledger name, currency code, object type, consolidation flag, period set name, and accounted period type.
• GL_PERIODS — to derive period start/end dates for the fiscal year and period-type resolution.
• GL_SYSTEM_USAGES — to confirm the General Ledger application is enabled for the target ledger.
• DUAL — for scalar evaluations in formula columns.

No writes are performed; the package is strictly read-only against reference data.

Usage Notes

GL_GLYRLJGE_XMLP_PKG is invoked exclusively through the Journal Entries Report concurrent program and the Oracle Reports runtime. Parameters typically include P_ACCESS_SET_ID, P_LEDGER_ID, P_START_PERIOD, P_END_PERIOD, and P_STRUCT_NUM. In 12.1.1 the report relies on the same access-set security package as in 12.2.2, so C_ACCESS_WHERE behaves consistently across releases. The package is referenced by zero other PL/SQL packages, meaning it is not exposed as a shared API and should not be called directly from custom code. Customizations must be applied through the underlying report definition (GLYRLJGE.rdf/.xml) rather than by modifying this generated package body, as it is regenerated whenever the report is recompiled or patched. The " AND " concatenation pattern on C_ACCESS_WHERE requires that the host query already contain at least one WHERE predicate; report query changes must preserve that assumption.