Search Results where_flex_p

Overview

APPS.JE_JENOGEIM_XMLP_PKG is the PL/SQL package body that implements the report logic for the Oracle E-Business Suite concurrent program "JENOGEIM," registered under the JE (General Ledger) application short name. The program generates the "GEI Print Messages" report, extracting and presenting General Ledger interface messages associated with a specified ledger. The package follows the standard Oracle Reports XML Publisher (XMLP) integration pattern: the report template invokes package-level PL/SQL functions during the Before Report, After Report, and group-level formatting events, and the package in turn resolves runtime context (concurrent request ID, ledger set-of-books information, functional currency, and chart of accounts structure) before the query executes.

Source header information shows the body at version 120.2, last modified 2008/01/11, indicating the object predates the 12.1.1 and 12.2.2 releases and has remained stable across them. Because it is a report-support package, it is not designed to be called by other application code; the ETRM metadata confirms it is referenced by zero other packages.

Key Procedures and Functions

• AFTERREPORT — Returns a BOOLEAN and is invoked at the After Report trigger. It performs no substantive work (the original SRW user exit is commented out) and simply returns TRUE.
• BEFOREREPORT — The core initialization routine. It captures the concurrent request ID via FND_GLOBAL.CONC_REQUEST_ID, then calls JG_INFO.JG_GET_SET_OF_BOOKS_INFO to resolve the chart of accounts ID, set of books name, and functional currency for the supplied ledger. It queries FND_CURRENCIES to obtain the currency precision and populates the package globals STRUCT_NUM, SET_OF_BOOKS_NAME, FUNC_CURRENCY, and PRECISION. Error buffers from the set-of-books call cause the program to abort with RAISE_APPLICATION_ERROR(-20101).
• B_PERIOD_ENDFORMATTRIGGER — A group-level format trigger that returns FALSE when PERIOD_END is null, suppressing output for rows lacking a period end date.
• CF_REPORT_TITLEFORMULA — Returns the report title as a CHAR. It queries FND_CONCURRENT_PROGRAMS_VL joined to FND_APPLICATION_VL for the program named 'JENOGEIM' under application short name 'JE'. When no row is found it defaults to 'GEI Print Messages'. This is the function matched by the user search term "cf_report_titleformula".
• CF_DATEFORMULA — A report-level formula column function that derives a formatted date value for display.
• STRUCT_NUM_P, SET_OF_BOOKS_NAME_P, SELECT_ALL_P, WHERE_FLEX_P, ORDERBY_ACCT_P, PRECISION_P, FUNC_CURRENCY_P — A set of parameter-return functions that expose the corresponding package globals (structure number, set of books name, selection flag, flexfield WHERE clause, account ordering, currency precision, and functional currency) to the report query and layout. The "P" suffix denotes them as report parameters sourced from package state.

Tables Accessed

• FND_CURRENCIES — Read to retrieve the PRECISION (decimal places) attribute for the functional currency returned by JG_GET_SET_OF_BOOKS_INFO.
• DUAL — Referenced for singleton computations within the report formulas.
• FND_CONCURRENT_PROGRAMS_VL and FND_APPLICATION_VL — Read by CF_REPORT_TITLEFORMULA to resolve the concurrent program's display name for the report title.

Usage Notes

The package is invoked exclusively through the JENOGEIM concurrent program: Oracle Reports executes BEFOREREPORT before the main query, calls the CF_* formula functions and the *_P parameter functions during layout, and runs AFTERREPORT on completion. Parameters such as P_LEDGER_ID are supplied by the concurrent program definition and passed into the set-of-books lookup. Customization is generally not advised, since the package is owned by APPS infrastructure; instead, organizations needing modified report titles or filtering should copy the concurrent program definition or adjust the output via XML Publisher templates. Because the object has no downstream callers, changes are isolated to this single report, and standard patching of the JE product family may overwrite any direct edits to the package body.