Results for “update_bank_account”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

XTR_REPLICATE_BANK_BALANCES is an APPS-owned PL/SQL package classified under the OTHER API category within Oracle EBS Treasury (ETRM). Its stated purpose is to replicate bank balance data from the Oracle Cash Management (CE) base tables into the ETRM staging table XTR_BANK_BALANCES. The package performs insert, update, and delete operations against XTR_BANK_BALANCES so that treasury-side processes operate on a synchronized copy of cash management balance records. The header comment identifies the replication of data from CE tables to XTR_BANK_BALANCES as the central design goal, with REPLICATE_BANK_BALANCE serving as the main entry point through which the individual DML procedures are dispatched according to an action flag. The package was created by Eakta Aggarwal on 19-May-2005 and carries a version header dated 25-Jul-2005.

Key Procedures and Functions

The package exposes 22 documented procedures. The replication core consists of overloaded REPLICATE_BANK_BALANCE entry points: one accepting a full XTR_BANK_BALANCES%ROWTYPE record and one accepting discrete balance attributes such as CE bank account balance identifier, company code, account number, balance date, ledger balance, available balance, interest-calculated balance, one-day float, and two-day float. Both overloads accept an action flag and return standard status and message outputs.

• INSERT_BANK_BALANCE, UPDATE_BANK_BALANCE, and DELETE_BANK_BALANCE perform the underlying DML against XTR_BANK_BALANCES.
• VALIDATE_BANK_BALANCE validates balance data prior to persistence, and VALIDATE_OD_LIMIT_BALANCE validates overdraft limit balance conditions.
• UPDATE_BANK_ACCOUNT refreshes associated bank account attributes; this is the procedure most closely related to the search term "update_bank_account."
• LOG_ERR_MSG provides error logging and message capture for the replication cycle.
• CHK_REVAL, CHK_ACCRUAL, CHK_ACCRUAL_ON_RENDER, CHK_REVAL_ON_RENDER, CHK_ACCRUAL_INT, CHK_INTEREST_SETTLED, and CHK_ACCRUAL_REVAL_WARNINGS are conditional checks governing revaluation, accrual, interest settlement, and warning scenarios.
• CHK_ROUNDING_CHANGE and UPDATE_ROUNDING_DAYCOUNT handle rounding and day-count configuration adjustments.
• CHK_INT_OVERRIDE evaluates interest override conditions.

Tables Accessed

The package reads from and writes to several ETRM and Cash Management tables through APPS synonyms. XTR_BANK_BALANCES is the primary target of insert, update, and delete activity. CE_BANK_ACCT_BALANCES, CE_BANK_ACCOUNTS, CE_BANK_ACCT_USES_ALL, CE_CASHPOOLS, and CE_CASHPOOL_SUB_ACCTS supply source balance, account, account-use, and cashpool data. XTR_BANK_ACCOUNTS holds treasury bank account definitions. Interest and accrual processing references XTR_ACCRLS_AMORT, XTR_BATCHES, XTR_BATCH_EVENTS, XTR_DEAL_DATE_AMOUNTS, XTR_PARTY_INFO, XTR_PRO_PARAM, and XTR_REVALUATION_DETAILS.

Usage Notes

XTR_REPLICATE_BANK_BALANCES is referenced by two other packages, indicating it is invoked programmatically rather than through direct end-user forms. In typical ETRM deployments, balance replication is driven by concurrent programs, batch processes, or treasury-facing forms that synchronize cash management balances into the treasury schema. The action flag parameter on REPLICATE_BANK_BALANCE determines whether the record is inserted, updated, or deleted, allowing a single caller to dispatch all three maintenance operations. Custom integrations should call the public entry points rather than the lower-level DML procedures directly, honor the returned status and message outputs, and respect the validation routines before commit.