Search Results where_flex

Overview

The APPS.JE_JENOGEIA_XMLP_PKG package is a report-support PL/SQL package generated by Oracle Reports for an XML Publisher (XMLP) concurrent program in Oracle E-Business Suite. Its naming convention (JE_JENOGEIA) ties it to the Journal Entry (JE) module, and the accompanying CF_REPORT_TITLEFORMULA and CF_DATEFORMULA functions confirm a report layout context. The package exists to supply report-level bind and lexical parameters to the underlying XML Publisher data model, and to run the before/after report triggers that Oracle Reports requires for a concurrent program submission. Its $Header indicates source file JENOGEIAS.pls at version 120.1, last updated 2008, which identifies it as a legacy General Ledger/Journal Entry report companion rather than a public API. In EBS 12.1.1 and 12.2.2 the package is compiled into the APPS schema and invoked only through the concurrent manager. The user search term WHERE_FLEX maps directly to a package-level variable in this source (line 21), whose default value is CC.SEGMENT11 BETWEEN '00' and '11' — a key flexfield segment predicate applied to the accounting flexfield, demonstrating the package's role in filtering GL code combinations.

Key Procedures and Functions

The package exposes twelve documented procedures and functions:

• BEFOREREPORT — Executed at report start; initialises package state prior to the data query.
• AFTERREPORT — Executed at report completion; performs any finalisation, cleanup, or pass-back or report-output processing.
• B_EORFORMATTRIGGER — Format trigger bound to the report's End-of-Report section; accepts a count and controls conditional formatting or suppression of that section.
• CF_REPORT_TITLEFORMULA — Computes the report's displayed title.
• CF_DATEFORMULA — Computes the date string displayed on the report, typically from SYSDATE or the concurrent request date.
• STRUCT_NUM_P — Accessor returning the accounting flexfield structure number, defaulted to '101'.
• SET_OF_BOOKS_NAME_P — Accessor returning the ledger/set-of-books name.
• SELECT_ALL_P — Accessor returning the concatenated SELECT_ALL expression, which builds a multi-segment accounting flexfield display string by joining SEGMENT1 through SEGMENT30 with newline characters.
• WHERE_FLEX_P — Accessor returning the WHERE_FLEX value, the GL flexfield filtering clause embedded in the report query; this is the parameter that the user search term references.
• ORDERBY_ACCT_P — Accessor returning the account ordering clause, defaulting to CC.SEGMENT10.
• PRECISION_P — Accessor returning numeric precision, defaulted to 0.
• FUNC_CURRENCY_P — Accessor returning the functional currency code.

The package-level declarations also include P_CONC_REQUEST_ID, P_LEDGER_ID, P_FILENAME, and P_ERRORS, which carry the concurrent request context, target ledger, output file name, and error buffer respectively.

Tables Accessed

Per ETRM metadata, the package references two objects through APPS synonyms:

• FND_CURRENCIES — Queried to resolve and derive the functional currency returned by FUNC_CURRENCY_P, and to supply currency information to the report's ledger context.
• DUAL — Used for single-row evaluations of expressions and for SYSDATE-based lookups associated with date and prerequisite validation logic.

No other tables are documented as directly read or written by this package. All substantive GL data retrieval for the report is performed by the report's own query definition, not by the package; the package supplies the bind and lexical parameter values (such as WHERE_FLEX, SELECT_ALL, and the ordering and precision values) that query consumes.

Usage Notes

The package is never called by other PL/SQL packages — ETRM records zero referencing packages — and is not a supported public API. It is invoked exclusively by the Oracle Reports/XML Publisher runtime when the associated concurrent program is submitted from the General Ledger responsibility. The typical invocation path is: the user submits the concurrent request, the concurrent manager launches the report executable, Oracle Reports calls BEFOREREPORT to initialise P_CONC_REQUEST_ID, P_LEDGER_ID, and related parameters, runs the data query using the lexical values returned through the various _P accessor functions, evaluates the CF_* formulas and the End-of-Report format trigger, and finally calls AFTERREPORT to finalise output and return any error text in P_ERRORS. Because the report-specific behaviour is driven by compile-time defaults — flexfield structure 101, the SEGMENT11 BETWEEN '00' and '11' restriction, and ordering by SEGMENT10 — customisations should be implemented by copying the report and its package rather than modifying the APPS-owned version, since Oracle patching may overwrite it. Diagnosing issues typically involves reviewing P_ERRORS, the concurrent request log, and confirming that the intended ledger and accounting flexfield structure align with the seeded defaults.