Search Results ce_ceclexer_xmlp_pkg




Overview
Explore in AI Chat

Overview

CE_CECLEXER_XMLP_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM as an "OTHER" API type. It is a report-logic package associated with an Oracle Reports (.rdf) executable, identified by the "XMLP" naming pattern, and belongs to the Cash Management (CE) module. Specifically, the package name embeds "CECLEXER," indicating it supports the Cash Management foreign exchange (FX) exposure or revaluation exception reporting family rather than a public application programming interface.

Its business function is to encapsulate the PL/SQL constructs generated and invoked by Oracle Reports during execution of the associated concurrent report. These constructs include format triggers, report-level Before/After Report triggers, group filters, and parameter-related logic. As with all generated report packages, the object is a supporting implementation detail of a standard concurrent program and is not intended as an integration point for third-party development.

Key Procedures and Functions

The package exposes eleven documented program units. Their roles align with Oracle Reports trigger and formula-column conventions:

  • C_DATEFORMATFORMULA — a formula column or format-trigger routine that supplies a date formatting mask used when rendering report output.
  • BEFOREREPORT — the report-level Before Report trigger, executed once prior to the main query to initialize session state, profiles, and report parameters.
  • AFTERREPORT — the report-level After Report trigger, executed once after all data is fetched and formatted, used for final cleanup and summary processing.
  • G_SUB_ACCOUNTGROUPFILTER — a group filter applied to a report query group, constraining rows based on sub-account criteria.
  • G_SUB_ACCOUNT1GROUPFILTER and G_SUB_ACCOUNT2GROUPFILTER — additional group filters providing finer granularity over the first and second sub-account segments.
  • C_PRT_MESSAGEFORMULA — a formula column that produces or formats the informational message text displayed on the report.
  • C_THE_END_P, C_THE_END1_P, C_THE_END2_P — formula or summary columns evaluated at the terminal stage of report processing, typically for closing balances, totals, or footer lines.
  • CP_PROFILE_P — a profile-related program unit that resolves an Oracle EBS profile option value for use within the report.

Tables Accessed

The ETRM metadata records two referenced tables, both accessed through APPS synonyms:

  • CE_LEVELING_MESSAGES — stores the leveling or exposure-related message text associated with Cash Management processing. The package reads this table to populate report messages via the message formula routines.
  • FND_NEW_MESSAGES — the Oracle Application Object Library message repository. It is accessed to resolve translatable message text and language-specific strings used when the report output is generated.

Usage Notes

CE_CECLEXER_XMLP_PKG is invoked exclusively through the Oracle Reports runtime when the associated Cash Management concurrent program is submitted from the Standard Request Submission (SRS) window. Program units are triggered implicitly by the report engine in response to report events such as Before Report, After Report, format triggers, and formula columns; no application form calls the package directly, and no other documented package references it (referenced by 0 packages). Customization of report output should be performed by modifying the underlying report definition and regenerating the package, not by editing the package body. The package is dependent on the SYS STANDARD package, is marked VALID, and behaves identically in EBS 12.1.1 and 12.2.2, although the file system location of the concurrent executable differs between the two releases.