Search Results ce_bank_stmt_sql_ldr




Overview
Explore in AI Chat

Overview

CE_BANK_STMT_SQL_LDR is an Oracle EBS PL/SQL package owned by the APPS schema that supports the bank statement import process within the Cash Management (CE) module. Its role is to load, parse, and stage bank statement data using SQL*Loader-driven mechanisms, acting as a bridge between externally formatted bank statement files and the standard CE_BANK_STMT_INTERFACE staging area. The package carries the "OTHER" API classification, indicating it is not a public, supported API but an internal utility invoked by the bank statement loader framework. It is stored in a VALID state and is documented in ETRM for both 12.1.1 and 12.2.2 releases.

The package sits beneath CE_BANK_STATEMENT_LOADER, which references it, and itself references CE_BANK_STMT_SQL_LDR recursively, reflecting internal calls and package body dependencies. It depends on the SYS.STANDARD package only, confirming that it relies on standard PL/SQL constructs and does not directly reference Oracle EBS foundation APIs beyond the objects resolved through APPS synonyms.

Key Procedures and Functions

The documented package exposes four procedures or functions:

  • SPEC_REVISION — Returns the revision identifier for the package specification, used to track the version of the interface definition.
  • BODY_REVISION — Returns the revision identifier for the package body, enabling version verification of the implementation separately from the specification.
  • PRINT_REPORT — Produces report output associated with the SQL*Loader bank statement process, typically for diagnostic or audit purposes during statement import.
  • CALL_SQL_LOADER — Orchestrates the invocation of SQL*Loader, driving the loading of bank statement data into the interface table. This is the central runtime procedure of the package.

No parameter lists are documented; the above describes purpose only based on the ETRM metadata.

Tables Accessed

The package references two tables through APPS synonyms:

  • CE_BANK_STMT_INT_MAP — The bank statement interface mapping table. It defines how incoming flat-file or loader columns map to the CE_BANK_STMT_INTERFACE structures, guiding the transformation performed during loading.
  • FND_CONCURRENT_PROGRAMS — The concurrent program definition table, consulted to resolve the SQL*Loader-based concurrent program metadata governing execution context and parameters.

These references confirm that the package operates as part of the concurrent processing and bank statement interface framework rather than as a standalone data owner.

Usage Notes

CE_BANK_STMT_SQL_LDR is invoked indirectly. It is called by CE_BANK_STATEMENT_LOADER, and its CALL_SQL_LOADER procedure is typically triggered through the bank statement import concurrent program configured in Cash Management. Users do not call this package from forms or custom code; instead, the standard Bank Statement Import flow (using SQL*Loader templates defined for the bank) reaches this package. Because it is classified as OTHER and not a supported public API, customizations should avoid direct invocation. The revision procedures are useful for support diagnostics to confirm which version of the loader logic is active in an environment.