Search Results p_deal_type

Overview

XTR_BISF_P is a PL/SQL package body owned by APPS within the Oracle E-Business Suite Treasury (ETRM) module. Its name reflects its role as a business intelligence and settlement/summary foundation utility that supplies derived reference values and interest adjustment aggregations for treasury deals. The package provides small, focused functions that are consumed by other ETRM components — forms, reports, and downstream calculations — rather than exposing a public API surface intended for external integration. In the 12.1.1 and 12.2.2 code lines the package carries the 120.2.12010000.2 header, indicating a mature, stable object that has seen limited change since the R12 family was introduced. All functions accept a p_deal_type argument among their parameters, and the internal logic branches on that deal type to select the correct source table and cursor, which is the central design pattern of the package.

Key Procedures and Functions

• XTR_REFERENCE_SPOT — Returns a numeric reference rate for spot-oriented instruments. The function takes p_deal_type and p_deal_number and is documented as branching on p_deal_type, fetching the base rate only when the deal type is FX or FXO. Values for other deal types fall through without a fetch, which means callers must only invoke this function for the supported types.
• XTR_REFERENCE_INTERNAL — Returns the internal ticket reference for a deal as a string. It accepts p_deal_type, p_deal_number, and a transaction number. The function distinguishes between standard deals (FX, FXO, BOND, BDO, STOCK, FRA, NI, IRO, IRS, SWPTN, TMM, RTMM), for which the reference is read from XTR_DEALS, and ONC deals, for which the reference is read from XTR_ROLLOVER_TRANSACTIONS using the supplied transaction number. This dual-path design is the primary reason a p_deal_type search surfaces this package.
• XTR_IG_ONC_SUM_INTADJ — Returns a numeric sum of interest adjustment amounts for a deal and journal date. It accepts p_deal_type, p_deal_number, p_transaction_number, and p_journal_date. Internally it locates the prior journal date for the deal by scanning XTR_JOURNALS for interest set and compound amount types, then aggregates the interest adjustment for that prior period. This supports the ONC (rollover) interest accrual logic where adjustments must be carried across journal periods.

Tables Accessed

• XTR_DEALS — The central treasury deal repository. Read by XTR_REFERENCE_SPOT for the base rate and by XTR_REFERENCE_INTERNAL for the internal ticket number on standard deal types.
• XTR_JOURNALS — The accounting journal line store. Read by XTR_IG_ONC_SUM_INTADJ to identify prior journal dates and to sum interest adjustment amounts, filtered by deal type, deal number, amount type, and accounted amount.
• XTR_ROLLOVER_TRANSACTIONS — Holds rollover transaction records for ONC deals. Read by XTR_REFERENCE_INTERNAL to resolve the internal ticket number for ONC deal types.

Usage Notes

XTR_BISF_P is documented as an OTHER-classification API and is referenced by zero other packages, indicating that it is invoked directly rather than through a package dependency chain. Typical invocation occurs from ETRM forms and report logic where a deal's spot rate, internal reference, or ONC interest adjustment must be displayed or fed into a calculation. Because the functions branch on p_deal_type, custom code calling them must pass a deal type that the relevant branch supports; passing an unsupported type to XTR_REFERENCE_SPOT or XTR_REFERENCE_INTERNAL returns an uninitialized value rather than raising a handled error. When extending or debugging code that searches on p_deal_type, this package is a likely match point for reference lookups and journal-based interest adjustment summaries in the Treasury module.