Search Results c_all_translation_p

Overview

APPS.CE_CEJEEXER_XMLP_PKG is the PL/SQL package specification that backs an Oracle Cash Management XML Publisher (XMLP) concurrent report. The package name follows the standard Oracle EBS XMLP generated-package convention: the "CE" prefix identifies the Cash Management application, "CEJEEXER" identifies the report (a Cash Management bank statement or related statement report), and the "_XMLP_PKG" suffix marks it as the report's data-model / formula package. It is owned by APPS and classified as OTHER (not a public API).

The package declares the bind and lexical parameters for the concurrent request, exposes report-level entry points (BEFOREREPORT and AFTERREPORT), and provides a set of "formula" functions that the XML Publisher template calls to derive display values. Its declaration uses AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user. The header comment dates the source to 2007 and marks it noship, indicating it is a report artifact rather than a shipped API. The package declares global variables such as P_CONC_REQUEST_ID, the date-range and statement-number parameters, and a series of C_... display columns used to render the report output.

Key Procedures and Functions

• BEFOREREPORT — initialization routine that runs before report data is fetched. It typically resolves the concurrent request context and populates the package-level global variables.
• AFTERREPORT — cleanup / post-processing routine executed after the report completes.
• C_DATEFORMATFORMULA — returns a formatted date string, applying the appropriate date format to a supplied value for display.
• C_MESSAGE_DSPFORMULA — the function the user searched for. It accepts an error/message value and returns the display text for that message, resolving it through the Cash Management message tables. This is the formula used to surface report error or status messages on the output.
• C_ALL_TRANSLATION_P, C_BANK_BRANCH_NAME_DSP_P, C_BANK_CURRENCY_CODE_DSP_P, C_COMPANY_NAME_HEADER_P, C_BASE_CURRENCY_CODE_DSP_P, C_BANK_ACCOUNT_NUM_DSP_P — a family of "_P" getter functions that return the value of the corresponding C_... global variable for use by the report template. Each supplies a specific display element: translation indicator, bank branch name, bank currency code, company name header, base currency code, and bank account number.

Tables Accessed

• FND_CONCURRENT_REQUESTS — read to resolve the concurrent request context (request id, parameters, and logged-in user) during BEFOREREPORT.
• CE_JE_MESSAGES — the Cash Management journal-entry / statement message table, read by C_MESSAGE_DSPFORMULA and related logic to resolve message text.
• FND_NEW_MESSAGES — the Oracle Application Object Library message repository, consulted to retrieve translatable message text for display.

The metadata lists no writes; the package is effectively read-only against these tables, consistent with its role as a report data model.

Usage Notes

This package is not a callable business API. It is invoked indirectly by the XML Publisher concurrent program that owns the CEJEEXER report — the report engine calls BEFOREREPORT, the SQL data model, the C_..._P getters and C_MESSAGE_DSPFORMULA, then AFTERREPORT. The ETRM metadata records zero packages referencing it, confirming it is a leaf artifact.

Because C_MESSAGE_DSPFORMULA is the function matched by the user's search, note that it is a report-specific formula, not a general API. Customizations should not call it directly; instead, customize the underlying report or template. Any modification to message resolution should be made through the Cash Management message setup (CE_JE_MESSAGES / FND_NEW_MESSAGES) rather than by editing this generated package.