Search Results set_200_group

Overview

CE_AUTO_BANK_MATCH is an Oracle Cash Management (CE) PL/SQL package that encapsulates the automatic bank reconciliation logic used by Oracle E-Business Suite. Its principal business function is to support the matching of bank statement lines against candidate transactions originating in Payables, Receivables, and Payroll, applying the tolerance and matching rules defined on the bank account. The package is declared with AUTHID CURRENT_USER, meaning that all unqualified object references resolve under the privileges of the invoking session rather than the package owner. This characteristic is significant in multi-organization and multi-ledger deployments because the same package can operate against the calling user's accessible data set.

The header comment identifies the source file as ceabrmas.pls at version 120.16, last modified in January 2008, which confirms the package lineage predates the 12.1.1 and 12.2.2 releases and has remained stable across both. The package is classified as OTHER in the ETRM metadata and is referenced by at least twelve other packages within the application, indicating that it functions as a shared reconciliation service rather than an end-user entry point.

Key Procedures and Functions

The package exposes a deliberately narrow public surface. The documented routines fall into three families: revision identifiers, setter/unsetter routines for match-type flags, and getter routines that report current state.

• SPEC_REVISION and BODY_REVISION — Return the version identifiers of the package specification and body respectively, used to verify that the deployed code matches the expected release level.
• SET_101, SET_200, SET_222, SET_260, SET_801, SET_999, and SET_ALL — Activate the global match-type flags. The numeric suffixes correspond to reconciliation categories such as payment, receipt, and journal-related matches. Each SET_ routine sets the corresponding av_*_inserted_flag global to 'Y'; SET_ALL activates the complete set in a single call.
• SET_200_GROUP — Applies the 200-series flag as a group, supporting batch or grouped matching scenarios where several statement lines are processed together.
• UNSET_101, UNSET_200, UNSET_200_GROUP, UNSET_222, UNSET_260, UNSET_801, UNSET_999, and UNSET_ALL — Reverse the corresponding flags, typically invoked during session cleanup, error handling, or when reinitializing the package state between statement batches.
• GET_101 and GET_200 — Query the current value of the associated flags so that calling code can conditionally branch on whether a given match type has already been processed.

All procedures and functions manipulate package-level state. No parameter lists are published in the documented metadata, and callers should treat the procedures as no-argument state mutators.

Tables Accessed

The package touches a defined set of tables through APPS synonyms. Statement data is read from CE_STATEMENT_HEADERS and CE_STATEMENT_LINES, while bank account configuration, tolerances, and currency settings are drawn from CE_BANK_ACCOUNTS and CE_BANK_ACCT_USES_ALL. Matching category lookup is resolved through CE_TRANSACTION_CODES and FND_LOOKUP_VALUES. Currency conversion relies on FND_CURRENCIES and GL_DAILY_RATES.

Payables-side candidates are retrieved from AP_INV_SELECTION_CRITERIA_ALL, AP_CHECKS_ALL, IBY_PAYMENTS_ALL, and PAY_PAYMENT_TYPES. Receivables-side data comes from AR_CASH_RECEIPT_HISTORY_ALL, AR_RECEIPT_METHODS, and AR_SYSTEM_PARAMETERS_ALL, the last of which supplies the accounting method used to drive the ar_accounting_method global. The package also reads Payables and Receivables amount and percentage tolerances — ap_amount_tolerance, ap_percent_tolerance, ar_amount_tolerance, ar_percent_tolerance, and ce_amount_tolerance — from the bank account definitions to determine whether a candidate falls within acceptable variance.

Usage Notes

CE_AUTO_BANK_MATCH is invoked internally by the Cash Management automatic reconciliation engine, which is driven from the Bank Statements and Reconciliation workbench and from the Automatic Reconciliation concurrent program. Custom extensions that need to reproduce or extend automatic matching behavior call the package directly, first invoking the relevant SET_ routine to declare the match types in scope, then performing the match, and finally calling the matching UNSET_ routine to restore a clean state. Because the package depends on global flags and AUTHID CURRENT_USER semantics, it is not reentrant within a single session and should not be called concurrently from nested program units that manage overlapping flag sets.