Search Results cs_count_aut




Overview
Explore in AI Chat

Overview

APPS.JE_JENOGEIA_XMLP_PKG is the generated PL/SQL package body that backs the Oracle EBS General Ledger concurrent program report JENOGEIA (submitted as a BI/XML Publisher style report in Oracle E-Business Suite 12.1.1 and 12.2.2). The package implements the standard report lifecycle hooks and the data-access logic required by the Oracle Reports runtime bridge — initialization, retrieval of ledger and chart-of-accounts context, and the parameter/formula functions that the report layout engine calls to render header information and query predicates. Its responsibilities are narrowly scoped: identify the ledger selected by the user, resolve the associated chart of accounts and functional currency, validate that a report run has returned data, and supply display values such as the report title. The source header ($Header: JENOGEIAB.pls 120.2 2008/01/11 ...) confirms this is a legacy Oracle Reports–generated package (the _XMLP_PKG suffix indicates XML Publisher integration), and its classification in the ETRM repository is OTHER, i.e., an internal, non-public API.

Key Procedures and Functions

  • AFTERREPORT — Terminal lifecycle hook invoked after the report completes. It performs cleanup of the report runtime environment and always returns a success Boolean.
  • BEFOREREPORT — Primary initialization hook. It captures the concurrent request ID, resolves the ledger/book/currency context through JG_INFO, derives the chart-of-accounts identifier, precision, set of books name, and functional currency, and exposes these as package-level values used by the other functions.
  • B_EORFORMATTRIGGER — Formatting trigger that inspects an incoming count (CS_COUNT_AUT) and returns TRUE or FALSE to control whether the end-of-report formatting block is executed.
  • CF_REPORT_TITLEFORMULA — Column/formula function that looks up the user-facing concurrent program name for JENOGEIA and returns it as the printed report title, falling back to a default label when no row is found.
  • CF_DATEFORMULA — Formula function (the object of the search term "cf_dateformula") supplying the date value rendered on the report, typically the report run/date parameter output for the header or column.
  • STRUCT_NUM_P, SET_OF_BOOKS_NAME_P, PRECISION_P, FUNC_CURRENCY_P — Parameter/accessor functions that expose the structure number, set of books name, currency precision, and functional currency resolved during BEFOREREPORT to the report layout.
  • SELECT_ALL_P, WHERE_FLEX_P, ORDERBY_ACCT_P — Parameter functions that supply the "select all" indicator and the dynamic SQL fragments used to build the flexfield WHERE clause and account ordering clause in the report's main query.

Tables Accessed

The package reads FND_CURRENCIES to obtain the precision of the functional currency resolved from the ledger, and DUAL for trivial single-row expressions. Concurrent program metadata (FND_CONCURRENT_PROGRAMS_VL, FND_APPLICATION_VL) is referenced inside the title formula to resolve the program name, and JG_INFO.JG_GET_SET_OF_BOOKS_INFO supplies the ledger/chart-of-accounts values. No tables are written by the package.

Usage Notes

JE_JENOGEIA_XMLP_PKG is not intended for direct invocation by custom code. It is executed exclusively by the Oracle Reports/XML Publisher runtime when the JENOGEIA concurrent program is submitted from the General Ledger responsibility or via the Concurrent Requests form. The ETRM metadata records no other packages referencing it. Customizations should be confined to the underlying report definition, ledger parameters, or the JG_INFO lookup logic rather than this generated body, since it is regenerated from the report source and any edits would be overwritten. Because the package depends on a valid ledger and functional currency being passed in, submission without a properly resolved ledger context will raise an application error during BEFOREREPORT.