Search Results full_coupons

Overview

XTR_MM_COVERS is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified as an Oracle Financials / Treasury (ETRM) component. Its documented status is VALID, and it is designated with an API classification of OTHER rather than a public or private API. The package provides the core treasury and money-market instrument calculation engine used throughout Oracle Treasury to derive dates, interest amounts, present and future values, and bond pricing for financial instruments recorded in the ETRM data model.

The package draws on deal type and instrument configuration stored in XTR_DEAL_TYPES and XTR_BOND_ISSUES, and exposes a suite of reusable financial functions consumed by other treasury packages. It is referenced by nine distinct dependent packages, including QRM_CALCULATORS_P, QRM_FX_FORMULAS, QRM_MM_FORMULAS, QRM_PA_CALCULATION_P, XTR_ACCRUAL_PROCESS_P, XTR_CALC_P, XTR_JOURNAL_PROCESS_P, XTR_RESET_BOND_RATE, and XTR_REVAL_PROCESS_P, confirming its role as a shared calculation utility underpinning accrual, journal, revaluation, reset, and risk-processing logic.

Key Procedures and Functions

The package exposes 17 documented procedures and functions covering date rolling, valuation, and rate calculations:

CALC_DAYS_RUN / CALC_DAYS_RUN_B / CALC_DAYS_RUN_C — generate and iterate business day run dates, used to build coupon or calculation schedules.
FUTURE_VALUE and PRESENT_VALUE — compute the time-value equivalent of a cash flow for reporting and valuation purposes.
FRA_SETTLEMENT_AMOUNT — determine the settlement amount for a Forward Rate Agreement.
INTEREST_FORWARD_RATE — derive the forward interest rate implied by two spot periods.
BLACK_OPTION_PRICE_CV — evaluate option pricing using the Black model.
ODD_COUPON_DATE, FULL_COUPONS, and PREVIOUS_FULL_COUPONS — resolve irregular and regular coupon period boundaries for bond instruments.
CALC_COMPOUND_COUPON_AMT and CALC_TOTAL_PREVIOUS_COUPON — compute compound coupon amounts and aggregate prior coupon accumulations.
CALCULATE_BOND_PRICE_YIELD — derive bond price or yield from the instrument's remaining cash flows.
BOND_RATE_FIXING_DATE_CALC — determine the rate fixing date applicable to a floating-rate bond.
CALC_BOND_COUPON_AMT — calculate the coupon amount payable for a bond period.
CHECK_COUPON_RATE_RESET — validate whether a coupon rate reset event is due, supporting the XTR_RESET_BOND_RATE flow.

Tables Accessed

The package resolves treasury tables through APPS synonyms. XTR_BOND_ISSUES and XTR_DEAL_TYPES supply instrument and deal configuration. XTR_BOND_COUPON_DATES and XTR_BOND_ALLOC_DETAILS provide coupon schedules and allocation reference data during coupon and reset processing. XTR_DEALS supplies the underlying treasury deal record, XTR_ROLLOVER_TRANSACTIONS supports rollover interest calculations, and XTR_TAX_BROKERAGE_SETUP provides tax and brokerage parameters used in amount derivation.

Usage Notes

XTR_MM_COVERS is an internal calculation library rather than a self-service API. It is invoked indirectly by treasury processing packages — accrual, journal, revaluation, and rate reset routines — and by QRM risk calculation packages in Oracle Risk Manager. It is not typically called from Oracle Forms directly; instead, concurrent programs and scheduled treasury processes execute the dependent packages that in turn call these functions. Custom extensions should treat XTR_MM_COVERS as a read-only utility and invoke the documented dependent APIs wherever possible, since its behavior is shared broadly across treasury and risk-processing logic.