Search Results get_sequence_info

Overview

CE_AUTO_BANK_IMPORT is an Oracle E-Business Suite Cash Management (CE) package owned by APPS and defined with AUTHID CURRENT_USER. It provides the core programmatic infrastructure for automatically importing bank statement data into EBS from external sources. In the context of Oracle EBS 12.1.1 and 12.2.2, this package is the engine behind automated bank statement processing: it accepts statement headers and lines delivered through the Cash Management open interface, validates and reconciles them against control totals, and stages the records for creation of bank statement entities.

The package does not present an end-user interface; it is an internal API invoked by concurrent programs and integrated systems. A significant portion of its global declarations mirror columns on CE_STATEMENT_HEADERS and its interface table, including control totals (control_total_dr, control_total_cr), debit and credit line counts, begin and end balances, cashflow and interest-calculated balances, one-day and two-day float amounts, intra-day and subsidiary flags, and the descriptive attribute flexfield columns (attribute_category through attribute8). These globals are used to hold header-level context while the import is in progress and to drive validation of the incoming statement before the data is committed.

Key Procedures and Functions

ETRM documents six procedures and functions within this package, though no parameter lists are published:

• SPEC_REVISION — Returns the revision identifier of the package specification, used for version tracking and support diagnostics.
• BODY_REVISION — Returns the revision identifier of the package body, allowing confirmation that the deployed body matches the expected code level.
• IMPORT_PROCESS — The principal driver of bank statement import. It orchestrates reading staged interface records, applying header and line validation, computing balances and control totals, and populating the target statement structures.
• UPDATE_HEADER_STATUS — Updates the processing status of a statement header record to reflect the outcome of an import attempt (for example, successful load or error).
• HEADER_ERROR — Records or raises header-level validation errors encountered during import processing, supporting error reporting and downstream reprocessing.
• GET_SEQUENCE_INFO — Retrieves sequence information required to generate identifiers for imported statement headers and lines.

Tables Accessed

The package reads and writes a defined set of Cash Management tables through APPS synonyms:

• CE_STATEMENT_HEADERS and CE_STATEMENT_HEADERS_INT — target and interface header tables; source of the control total, balance, float, and attribute columns declared as globals.
• CE_STATEMENT_LINES, CE_STATEMENT_LINES_INTERFACE, and CE_STATEMENT_LINES_S — statement line detail storage during import and validation.
• CE_BANK_ACCOUNTS, CE_BANK_ACCT_BALANCES, and CE_BANK_ACCT_BALANCES_S — bank account and balance information used for validation and for the average close ledger/available MTD and YTD figures referenced in the globals.
• CE_TRANSACTION_CODES — transaction code validation and mapping for statement lines.
• CE_ARCH_INTERFACE_HEADERS and CE_ARCH_INTERFACE_LINES — archival interface structures used during statement import processing.
• CE_INTRA_STMT_HEADERS, CE_INTRA_STMT_HEADERS_S, CE_INTRA_STMT_LINES, and CE_INTRA_STMT_LINES_S — intra-day statement header and line tables, consistent with the intra-day flag declared in the package globals.

Usage Notes

CE_AUTO_BANK_IMPORT is invoked indirectly rather than directly by end users. Typical invocation paths include the Cash Management bank statement import concurrent program, which loads data from the interface tables into the statement tables, and bank-specific or third-party integration routines that populate the CE statement interface tables before calling the import API. In customizations, the package may be referenced by PL/SQL code performing programmatic statement loads or status corrections. Because ETRM lists two dependent packages that reference it, care should be taken when applying patches that alter its specification. Organizations such as Sangitarai Exports Pvt Ltd, Ichalkaranji, operating EBS 12.1.1 or 12.2.2 with automated bank feed integration would encounter this package as part of standard Cash Management statement import configuration, though the reference is incidental to the object's function.