Search Results c_format_type




Overview
Explore in AI Chat

Overview

APPS.CE_CEBSLERR_XMLP_PKG is a report-support package body associated with the Oracle Cash Management bank statement SQL*Loader error report. Its primary responsibility is to prepare and supply runtime values that the XML Publisher (BI Publisher) report template consumes during execution. The package is classified as OTHER in ETRM, indicating it is not a public API but rather an internal, report-specific PL/SQL construct generated in the standard Oracle EBS report packaging style.

The package serves the concurrent program that reports errors encountered when bank statement data is loaded through SQL*Loader. When the report is submitted, the concurrent request arguments identify the bank statement integration mapping and the source file. The package resolves these arguments, validates that the mapping is usable, counts the error rows, and exposes the resulting values to the report layout. The c_format_type value that users search for is one of these output values, derived from the integration map definition and surfaced through the corresponding getter function C_FORMAT_TYPE_P.

Key Procedures and Functions

The package exposes eight documented program units. Two are lifecycle hooks invoked automatically by the Oracle Reports/XML Publisher runtime, and the remaining six are accessor functions returning package-level variables to the report template.

  • BEFOREREPORT — Executes before the report output is generated. It captures the concurrent request identifier, parses the concurrent program arguments to derive the map identifier and file name, counts fatal and total error rows in the SQL*Loader error table, and queries the bank statement integration map to populate the name, description, format type, and control file name package variables.
  • AFTERREPORT — Executes after report generation completes. In the supplied source it performs cleanup of the Oracle Reports user exit environment and returns control to the runtime.
  • C_NAME_P — Returns the integration map name (format name) retrieved from the bank statement integration map.
  • C_DESCRIPTION_P — Returns the description associated with the integration map.
  • C_FORMAT_TYPE_P — Returns the format type of the integration map, corresponding to the c_format_type value searched by users. This value is read from CE_BANK_STMT_INT_MAP.FORMAT_TYPE.
  • C_CONTROL_FILE_NAME_P — Returns the control file name associated with the mapping, normalized so that it ends with the .ctl extension.
  • CP_FATAL_ERR_COUNT_P — Returns the count of fatal errors, defined as rows in CE_SQLLDR_ERRORS where the record number, statement number, or bank account number is null.
  • CP_TOTAL_ERR_COUNT_P — Returns the total number of rows in CE_SQLLDR_ERRORS, providing the denominator for error-rate reporting.

Tables Accessed

Usage Notes

CE_CEBSLERR_XMLP_PKG is not invoked directly by application forms or custom code. It is bound to the bank statement SQL*Loader error report concurrent program and is executed automatically by the XML Publisher engine when that program is run. ETRM records zero packages referencing this package, confirming it has no external dependents and should be treated as report-internal.

Because the package reads FORMAT_TYPE and related attributes at report runtime, any diagnostic of the c_format_type value should begin with the CE_BANK_STMT_INT_MAP row identified by the submission's map identifier argument. If the mapping is missing or ambiguous, the package raises application error -20101 with the CE_INVALID_SQLLDR message, and the report aborts without output. Debug behavior is additionally governed by a P_DEBUG_MODE flag checked during BEFOREREPORT.