Search Results ce_intra_stmt_headers_s

Overview

CE_AUTO_BANK_IMPORT is an Oracle Applications (APPS) PL/SQL package body within the Cash Management (CE) module of Oracle E-Business Suite 12.1.1 and 12.2.2. Its principal business function is to automate the import of bank statement data into the Cash Management statement interface and reconciliation tables. The package supports the automated ingestion of external bank files — including intra-day and archival statement formats — by loading header and line records, validating account and currency information, and populating the interface and error tables that downstream reconciliation and Bank Statement Reconciliation processes rely upon. Because the package is classified as OTHER in the documented API metadata and is not referenced by any other database object, it is intended primarily for internal invocation by Cash Management concurrent programs and forms rather than as a public integration API.

Key Procedures and Functions

The package body exposes six documented procedures and functions:

• SPEC_REVISION — Returns the revision identifier of the package specification, allowing callers and diagnostics to confirm the installed version.
• BODY_REVISION — Returns the revision identifier of the package body, used to verify the loaded implementation matches expectations.
• IMPORT_PROCESS — The core driver of the automatic bank import. It orchestrates the reading of source statement data and the loading of headers and lines into the interface and statement tables.
• UPDATE_HEADER_STATUS — Updates the processing status of statement header records as the import progresses, tracking which headers have been processed or rejected.
• HEADER_ERROR — Records header-level validation failures, typically by writing to the interface error tables through the CE_HEADER_INTERFACE_ERRORS_PKG dependency.
• GET_SEQUENCE_INFO — Retrieves sequence information used to generate or validate identifiers for imported statement records.

Tables Accessed

The package reads and writes the core Cash Management statement and account structures, accessed via APPS synonyms. Key tables include:

• CE_STATEMENT_HEADERS and CE_STATEMENT_HEADERS_INT — the production and interface header tables populated during import.
• CE_STATEMENT_LINES, CE_STATEMENT_LINES_INTERFACE, and CE_STATEMENT_LINES_S — statement line records and their interface/sequence counterparts.
• CE_INTRA_STMT_HEADERS, CE_INTRA_STMT_HEADERS_S, CE_INTRA_STMT_LINES, and CE_INTRA_STMT_LINES_S — intra-day statement headers and lines, including sequence definitions. The user search term ce_intra_stmt_headers_s refers directly to this referenced sequence table.
• CE_ARCH_INTERFACE_HEADERS and CE_ARCH_INTERFACE_LINES — archival interface structures for historical statement data.
• CE_BANK_ACCOUNTS, CE_BANK_ACCOUNTS_V, CE_BANK_ACCTS_GT_V, CE_BANK_ACCT_BALANCES, and CE_BANK_ACCT_BALANCES_S — bank account validation, balances, and sequence data.
• CE_TRANSACTION_CODES — used to validate or map transaction codes on imported lines.

Supporting currency validation relies on FND_CURRENCIES, GL_CURRENCY_API, and GL_DAILY_CONVERSION_TYPES; error handling uses APP_EXCEPTIONS, CE_HEADER_INTERFACE_ERRORS_PKG, and CE_LINE_INTERFACE_ERRORS_PKG.

Usage Notes

CE_AUTO_BANK_IMPORT is typically invoked indirectly through Cash Management concurrent programs and forms that perform automatic bank statement import, rather than through direct calls from custom code. It is not referenced by any other database object, and its output flows into the reconciliation interface tables consumed by Bank Statement Reconciliation. Developers diagnosing import failures commonly inspect the CE_INTRA_STMT_HEADERS_S and related sequence tables referenced here. Direct invocation should be approached cautiously, since the package manipulates interface and error state that standard concurrent processing expects to control.