Search Results debit_dsp




Overview
Explore in AI Chat

Overview

APPS.GL_GLRFGNJ_XMLP_PKG is the generated PL/SQL package body that backs the Oracle General Ledger XML Publisher concurrent program GLRFGNJ, a journal-line detail and posting-status report. In Oracle EBS 12.1.1 and 12.2.2, XML Publisher (BI Publisher) reports are implemented as a package containing a BeforeReport function (and supporting formula, group-filter, and data-source functions) that the XML Publisher engine calls at runtime. This package is responsible for initialising report-level globals, resolving the selected Data Access Set, translating lookup codes into display strings, and assembling the dynamic WHERE and SELECT fragments that filter ledger, journal, and period data before the XML output is produced.

The package performs no permanent DML; its role is purely to shape the query that the report's data template executes. Output values such as POSTING_STATUS_SELECT, POSTING_STATUS_WHERE, PERIOD_WHERE, DAS_WHERE, STAT, DEBIT_DSP, and CREDIT_DSP are stored in package-level variables referenced by the accompanying .rtf or .xml template.

Key Procedures and Functions

  • BeforeReport — The main entry point, invoked once before data retrieval. It initialises the invalid-flexfield message, obtains the STAT currency format mask, validates the Data Access Set, resolves the DR/CR lookup display values, and builds the posting-status SELECT and WHERE clauses.
  • AfterReport — Cleanup routine called after the report completes; returns control to the XML Publisher engine.
  • ENT_X_DRCRFORMULA / ACCT_X_DRCRFORMULA — Column formulas that format the entered and accounted debit/credit amounts for display.
  • DR_CR_DSPFORMULA — Formats the debit/credit indicator column.
  • G_LINESGROUPFILTER — Group filter applied to the journal-lines data group to suppress or include rows.
  • GL_FORMAT_CURRENCY — Applies the currency format mask (STAT) to monetary columns.
  • FLEXDATA_P — Supplies the concatenated accounting flexfield (CCID) description for each journal line.
  • POSTING_STATUS_SELECT_P — Returns the SELECT-list expression for the posting status, switching between J.reference_4 and J.reference_1 based on parameter P_KIND.
  • POSTING_STATUS_WHERE_P — Builds the WHERE predicate on B.status, either excluding non-posted statuses or matching the requested status.
  • PERIOD_WHERE_P — Generates the period predicate for the report query; this is the accessor most commonly searched under the term "period_where".
  • STRUCT_NUM_P — Exposes the chart of accounts ID resolved from the access set.
  • PARAM_LEDGER_NAME_P / PARAM_LEDGER_TYPE_P — Return the ledger name and ledger type parameters for the report header.
  • INV_FLEX_MSG_P, DEBIT_DSP_P, CREDIT_DSP_P, WIDTH_P, DAS_WHERE_P, ACCESS_SET_NAME_P — Accessor functions that expose package globals (message text, DR/CR display strings, column width, Data Access Set WHERE clause, and access set name) to the template.

Tables Accessed

Usage Notes

The package is invoked exclusively by the XML Publisher concurrent program GLRFGNJ (for example, "Journal Line - XML" or similar GL diagnostic report). It is not a public API and is not referenced by any other package in EBS. Developers customising the report should modify the underlying data template or the report definition rather than this generated body, since it is regenerated whenever the XML Publisher data source is edited. The PERIOD_WHERE_P function in particular should be inspected when period-selection errors occur, as it is the source of the date predicate passed into the journal query.