Search Results update_bond_details




Overview
Explore in AI Chat

Overview

The APPS.XTR_RESET_BOND_RATE package is a component of the Oracle Treasury (ETRM) module in Oracle E-Business Suite, delivered under the 12.1.1 and 12.2.2 releases. Its principal business function is to recalculate and reset the benchmark and coupon interest rates applicable to bond issues managed within the Treasury application. When a benchmark reference rate changes, treasury operations staff must roll the new rate into affected bond instruments, re-derive coupon amounts, and record the resulting transaction and accounting detail. This package encapsulates that logic so it can be executed consistently and audited. It is classified as an OTHER API, meaning it is a supporting package rather than a formally published public interface, and it is referenced by no other packages in the ETRM schema, indicating it is invoked directly by user-facing components rather than through inter-package dependency chains.

Key Procedures and Functions

  • RESET_BOND_BENCHMARK_RATE — The primary driver procedure. It accepts a source rate set, target rate set, adjustment value, bond issue code, currency, benchmark, and an overwrite type (defaulting to 'N'). It returns a standard concurrent program error buffer and return code, and is responsible for propagating the selected benchmark rate into the bond records.
  • VALIDATE_TRANSACTION — Performs eligibility checks before any rate change is applied. It receives the bond issue code, coupon date, ratefix date, and overwrite type, and returns validation status and a return code, allowing callers to gate the update on business rules.
  • UPDATE_COUPON_DETAILS — Writes the new interest rate to the coupon records for a given bond issue and coupon date, associating the change with the originating deal and transaction numbers and the update type.
  • UPDATE_COUPON_AMOUNT — Recomputes the monetary coupon amount for the specified bond issue, deal, and transaction, ensuring the currency value aligns with the new rate.
  • UPDATE_BOND_DETAILS — The procedure most relevant to the update_bond_details search. It reconciles the bond record using the bond issue code, coupon date, ratefix date, and new rate, and returns an out parameter counting the affected records, effectively serving as the write-back routine that ties together the rate reset workflow.

Tables Accessed

The package works against the core Treasury bond and deal tables through APPS synonyms. XTR_BOND_ISSUES holds the master bond definitions being reset. XTR_BOND_COUPON_DATES and XTR_BOND_ALLOC_DETAILS store the coupon schedule and allocation splits that determine who receives interest. XTR_DEALS, XTR_DEAL_DATE_AMOUNTS, and XTR_ROLLOVER_TRANSACTIONS capture the deal-level transaction and amount history generated when a rate reset is booked, while XTR_TAX_BROKERAGE_SETUP supplies tax and brokerage treatment used in amount derivation.

Usage Notes

This package is typically invoked from Treasury bond management forms and their supporting concurrent programs, where a user selects an instrument and triggers a benchmark or coupon rate reset. Because RESET_BOND_BENCHMARK_RATE exposes concurrent-program standard out parameters, it is commonly registered as a concurrent executable. Custom code should call the individual procedures only after VALIDATE_TRANSACTION confirms eligibility, and should respect the overwrite type to avoid unintentionally replacing existing ratefix data. As the package is not referenced by other ETRM packages and its source header dates from 2005, it functions as a stable, low-level utility that should be extended through supported public APIs wherever possible.