Search Results c_name_p

Overview

APPS.CE_CEBSLERR_XMLP_PKG is a generated PL/SQL package that supports the Oracle Cash Management bank statement loader error report. The name follows the standard Oracle Reports XML Publisher package convention: the CE_CEBSLERR_XMLP prefix identifies the associated report (CEBSLERR, the bank statement interface error listing), while the _PKG suffix identifies the server-side package that supplies report parameters, performs pre- and post-report logic, and exposes formatted values to the XML Publisher data model.

The package operates within the bank statement integration flow. When bank statement data is loaded through SQL*Loader into the interface tables, control-file mappings and loader errors are captured and evaluated. This package provides the concurrent program with the metadata required to present that information: the map identity, the statement source name and description, the format type, the control file name, and error counts. In Oracle EBS 12.1.1 and 12.2.2 the object resides in the APPS schema and is classified as a non-public, report-support API (API classification: OTHER). It is not part of the general-purpose Cash Management PL/SQL API surface and should not be called from customer extensions.

Key Procedures and Functions

The documented package interface consists of eight callable units and a set of package-level variables.

• BEFOREREPORT — Returns a Boolean. Executed by the report before data retrieval, it initializes package state and populates the report parameters and package globals from the concurrent request context.
• AFTERREPORT — Returns a Boolean. Executed after report data has been fetched, it performs cleanup and any finalization required by the report.
• C_NAME_P — Returns VARCHAR2. Supplies the statement source (bank statement map) name to the report layout.
• C_DESCRIPTION_P — Returns VARCHAR2. Supplies the descriptive text for the statement source.
• C_FORMAT_TYPE_P — Returns VARCHAR2. Supplies the bank statement format type associated with the map.
• C_CONTROL_FILE_NAME_P — Returns VARCHAR2. Supplies the name of the SQL*Loader control file used for the format.
• CP_FATAL_ERR_COUNT_P — Returns NUMBER. Supplies the count of fatal loader errors for the run.
• CP_TOTAL_ERR_COUNT_P — Returns NUMBER. Supplies the total count of loader errors for the run.

The package also declares public globals including P_CONC_REQUEST_ID, P_FILE_NAME, P_FILE_NAME_1, P_DEBUG_MODE, P_MAP_ID, P_MAP_ID_1, P_SQL_TRACE, C_NAME, C_DESCRIPTION, C_FORMAT_TYPE, and C_CONTROL_FILE_NAME. These hold the concurrent request identifier and the values bound to the report parameters; the _P functions expose them to the XML Publisher template.

Tables Accessed

The package reads the following tables through APPS synonyms:

• CE_BANK_STMT_INT_MAP — the definition of the bank statement interface mapping, which supplies the statement source name, description, format type, and control file name returned by the C_*_P functions.
• CE_SQLLDR_ERRORS — the staging table of SQL*Loader errors produced during bank statement upload; the fatal and total error counts are derived from this table.
• FND_CONCURRENT_REQUESTS — the concurrent request definition, used to resolve the running request, its parameters, and its status.
• FND_NEW_MESSAGES — the message repository, used to resolve translatable text for the report output.

Usage Notes

CE_CEBSLERR_XMLP_PKG is invoked exclusively by the Cash Management bank statement loader error concurrent program and its associated XML Publisher report. The report engine calls BEFOREREPORT to seed the globals, retrieves the report data set, resolves the parameter values through the *_P functions, and calls AFTERREPORT on completion. Because the package is not referenced by any other package, it has no downstream PL/SQL dependencies. Customizations should be limited to the report template and to the concurrent program definition; direct calls into the package from customer code are not supported, and the package body may be regenerated by Oracle during patching or upgrades.