Search Results set_int_rate

Overview

CE_INTEREST_CALC is a PL/SQL package in the Oracle E-Business Suite Cash Management (CE) module, owned by the APPS schema and classified as an "OTHER" API in the ETRM repository. Its principal business function is the calculation of interest on bank account balances and cash pool balances, together with the maintenance of the underlying interest schedules, rate ranges, and balance details that drive those calculations.

The package is not a full public API in the traditional sense; it combines utility routines, schedule maintenance procedures, and interest calculation engines that operate against Cash Management interest tables. It supports both single bank account interest computation and cash pool interest computation, which is reflected in the parallel "balance" and "pool" procedure pairs. The object is referenced by three other packages, indicating that it serves as a shared calculation component within the Cash Management interest processing flow.

Key Procedures and Functions

The package exposes thirteen documented procedures and functions (excluding declarations). Their documented purposes are:

• ROUNDUP — A function that rounds an amount using a supplied round factor, used to normalize calculated interest values.
• GET_INTEREST_RATE — A function that determines the applicable interest rate for a given bank account, balance date, and balance amount. It accepts the interest rate as an IN OUT NOCOPY parameter, meaning the caller may pass a candidate rate and the routine returns the resolved rate. This is the routine most commonly referenced in searches for get_interest_rate.
• DELETE_SCHEDULE_ACCOUNT — Removes schedule account associations for a given interest schedule, bank account, interest account type, and cash pool.
• GET_BALANCE_INFO — Gathers balance information for a date range and schedule context, returning a row count.
• GET_BALANCE_POOL_INFO — A cash pool variant of balance gathering, returning a row count.
• GET_INTEREST_INFO — Retrieves interest information for the given date range and schedule context.
• GET_INTEREST_POOL_INFO — The cash pool equivalent of interest information retrieval.
• SET_END_DATE — Establishes the end date on an interest schedule record for the given scope.
• SET_INT_RATE — Assigns an interest rate to a schedule record for the given scope.
• SET_RANGE_AND_RATE — Sets the balance range boundaries together with the corresponding rate.
• CALCULATE_INTEREST — The primary interest calculation driver.
• INT_CAL_DETAIL_MAIN — Main detail processing routine for interest calculation.
• INT_CAL_XTR — Extraction routine supporting the interest calculation detail flow.

Tables Accessed

The package reads and writes a small, focused set of Cash Management tables through APPS synonyms. CE_BANK_ACCOUNTS and CE_BANK_ACCT_BALANCES provide the account and balance source data for computation. CE_CASHPOOL_SUB_ACCTS supplies cash pool membership, supporting the pool-specific procedures. CE_INTEREST_RATES and CE_INTEREST_BAL_RANGES drive rate determination, including the tiered balance range logic used by GET_INTEREST_RATE and SET_RANGE_AND_RATE. CE_INTEREST_SCHEDULES stores the schedule definitions that SET_END_DATE, SET_INT_RATE, and DELETE_SCHEDULE_ACCOUNT maintain. CE_INT_CALC_DETAILS_GT and CE_INT_CALC_DETAILS_GT_S are global temporary tables used to stage calculated interest details during processing. DUAL is used for scalar evaluations and defaults.

Usage Notes

CE_INTEREST_CALC is invoked from within Cash Management interest processing, primarily through concurrent programs and internal package calls that generate and maintain interest schedules and computed interest records. GET_INTEREST_RATE is typically called when the system must resolve the effective rate for a balance tier, making it the entry point for rate lookup logic exposed to custom extensions. Because the package relies on global temporary tables, callers must ensure the calculation routines are invoked within a session context where the staging tables are populated. Direct modification of interest schedule rows should be performed through SET_END_DATE, SET_INT_RATE, SET_RANGE_AND_RATE, and DELETE_SCHEDULE_ACCOUNT rather than by direct DML, to preserve consistency with the package's internal logic. The header references a 2005 source version, consistent with the long-standing Cash Management interest architecture carried forward into EBS 12.1.1 and 12.2.2.