Search Results c_the_end1

Overview

The APPS.CE_CECLEXER_XMLP_PKG package body is an Oracle Reports PL/SQL library package generated to support the CE_CECLEXER report, a Cash Management (CE) leveling and reconciliation report in Oracle E-Business Suite Release 12.1.1 and 12.2.2. The package follows the standard XML Publisher report packaging convention, where an Oracle Reports executable retains its procedural logic inside a server-side PL/SQL package that shares the report's name. Its role is to supply report-level lifecycle hooks, formatted field callbacks, and group filter logic that the Reports runtime invokes during execution of the concurrent request.

The package is owned by APPS, is classified as OTHER (a non-public, non-API implementation artifact), and is referenced by zero other packages, confirming that it exists solely to service its parent report. The header comment reference CECLEXERB.pls 120.0 2007/12/28 indicates the source was created under the standard concurrent manager header convention.

Key Procedures and Functions

• C_DATEFORMATFORMULA — Returns a character date format string; the implementation returns the canonical DD-MON-YYYY mask used by the report.
• BEFOREREPORT — Report-level initialization hook. It captures FND_GLOBAL.CONC_REQUEST_ID into P_CONC_REQUEST_ID, invokes CEP_STANDARD.INIT_SECURITY to enforce Cash Management security, and populates CP_PROFILE from the CE_BANK_ACCOUNT_TRANSFERS profile option.
• AFTERREPORT — Post-report cleanup hook that deletes leveling message rows from CE_LEVELING_MESSAGES for the current request ID, preventing message accumulation across runs.
• G_SUB_ACCOUNTGROUPFILTER — Group filter that evaluates the SUB_ACCOUNT value and sets C_THE_END to 'N' when the value is empty and 'Y' otherwise.
• G_SUB_ACCOUNT1GROUPFILTER and G_SUB_ACCOUNT2GROUPFILTER — Parallel group filters for SUB_ACCOUNT1 and SUB_ACCOUNT2, setting C_THE_END1 and C_THE_END2 respectively.
• C_PRT_MESSAGEFORMULA — Format formula declared against FND_NEW_MESSAGES.MESSAGE_TEXT; it currently returns NULL.
• C_THE_END_P, C_THE_END1_P, and C_THE_END2_P — Accessor functions returning the values of the C_THE_END, C_THE_END1, and C_THE_END2 package globals.
• CP_PROFILE_P — Accessor returning the CP_PROFILE package global captured during BEFOREREPORT.

Tables Accessed

• CE_LEVELING_MESSAGES — Written (DELETE) by AFTERREPORT to remove leveling message records associated with the completed concurrent request ID.
• FND_NEW_MESSAGES — Referenced as a datatype anchor for C_PRT_MESSAGEFORMULA through FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE; no runtime DML is performed against this table in the shown logic.

Usage Notes

The package is not intended for direct invocation by external code. It is executed implicitly by the Oracle Reports runtime when the CE_CECLEXER concurrent program is submitted. BEFOREREPORT runs before the report query, AFTERREPORT runs after output generation, and the group filter functions are invoked as each report group is processed. The *_P accessors expose package globals to report fields so formatted columns can reference computed values such as C_THE_END_P — the object the user searched for. Because the package is regenerated whenever the report is recompiled, customizations should never be applied directly to the package body; changes must be made in the Reports source (CECLEXER.rdf). The presence of CEP_STANDARD.INIT_SECURITY confirms that Cash Management security rules govern which bank accounts and transfers appear in the output.