Search Results calc_days_run_c

Overview

APPS.XTR_MM_COVERS is a Treasury Management (ETRM) PL/SQL package body that centralizes the core quantitative and date-manipulation routines used to price money-market instruments, bonds, forward rate agreements (FRAs) and simple options within Oracle E-Business Suite 12.1.1 and 12.2.2. Its principal design role is to act as a dispatching and calculation "cover" layer: it abstracts the underlying day-count conventions and valuation mathematics so that calling programs do not need to know which internal routine is appropriate for a given basis or instrument type. The package supports interest accrual, coupon schedule handling, present- and future-value computation, yield and price derivation, and the determination of coupon rate reset dates. It is classified as an OTHER API under the APPS schema and is referenced by nine other packages, indicating its position as a shared utility used across the ETRM calculation stack rather than an entry point invoked directly by end users.

Key Procedures and Functions

The package exposes seventeen documented procedures and functions. Among the most significant:

• CALC_DAYS_RUN_C — the recommended cover routine for day-count calculation. It inspects the supplied method and either delegates to CALC_DAYS_RUN_B when the basis is ACT/ACT-BOND, or to CALC_DAYS_RUN otherwise. Callers should use this rather than CALC_DAYS_RUN directly when ACT/ACT-BOND may apply.
• CALC_DAYS_RUN_B — computes day counts and year basis specifically for the ACT/ACT-BOND convention. The year basis is only correct when the start and end dates together constitute a full coupon period; day counts are always correct.
• CALC_DAYS_RUN — the general day-count and year-basis routine for all non-bond bases, including support for the interest override feature.
• FUTURE_VALUE / PRESENT_VALUE — time-value-of-money computations used in valuation and cash-flow projection.
• FRA_SETTLEMENT_AMOUNT / INTEREST_FORWARD_RATE — forward rate agreement settlement and forward-rate derivation.
• BLACK_OPTION_PRICE_CV — Black-model option pricing for simple option valuation.
• ODD_COUPON_DATE, FULL_COUPONS, PREVIOUS_FULL_COUPONS — coupon schedule and accrual-period construction, handling odd first/last coupons.
• CALC_COMPOUND_COUPON_AMT, CALC_TOTAL_PREVIOUS_COUPON, CALC_BOND_COUPON_AMT — coupon amount computation, including compounding and the aggregation of prior coupons.
• CALCULATE_BOND_PRICE_YIELD — derives bond price from yield or yield from price.
• BOND_RATE_FIXING_DATE_CALC — determines the rate fixing date for floating-rate bond instruments.
• CHECK_COUPON_RATE_RESET — the routine most closely associated with the search term check_coupon_rate_reset. It evaluates whether a coupon rate reset event applies to a bond given its schedule and reset configuration, and is central to processing floating-rate coupon resets.

Tables Accessed

The package reads and writes ETRM base tables through APPS synonyms: XTR_BOND_ISSUES (bond master definitions), XTR_DEAL_TYPES (instrument and deal type configuration), XTR_BOND_ALLOC_DETAILS (bond allocation records), XTR_BOND_COUPON_DATES (generated coupon schedule dates), XTR_DEALS (deal header data), XTR_ROLLOVER_TRANSACTIONS (rollover and reset transactions) and XTR_TAX_BROKERAGE_SETUP (tax and brokerage parameters affecting net amounts). Coupon schedule and reset logic relies principally on XTR_BOND_COUPON_DATES and XTR_ROLLOVER_TRANSACTIONS, while valuation routines depend on the instrument definition held in XTR_BOND_ISSUES and XTR_DEALS.

Usage Notes

XTR_MM_COVERS is not intended for direct end-user invocation. It is called from ETRM forms and concurrent programs that perform bond and money-market processing, and from the nine packages that depend on it. The header version (120.29.12010000.2, dated 2008) confirms the file was last shipped as part of the standard ETRM code line and remained stable across the 12.1.1 and 12.2.2 releases. Custom code should call the documented cover routines — notably CALC_DAYS_RUN_C rather than the lower-level day-count procedures — to preserve correct handling of the ACT/ACT-BOND convention and the interest override feature. No direct modification of this package body is supported; extensions should be implemented through wrapper logic in custom packages.