Search Results xtr_reference_internal




Overview
Explore in AI Chat

Overview

XTR_BISF_P is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, delivered as part of the Treasury (ETRM) module. Its revision history, reflected in the header comment (xtrbisfs.pls 120.2.12010000.2, dated 2008/08/06), confirms it is a long-standing component of the Treasury code line and remains present in both 12.1.1 and 12.2.2. The package is classified as OTHER rather than as a formal public API, indicating that it is primarily an internal utility used by Treasury business logic rather than an interface intended for direct customer invocation.

Functionally, the package addresses two related areas of Treasury processing: the resolution of deal reference information (both spot and internal references) and the calculation of internal adjustment summaries associated with income-generating or rollover-related activity. In practical terms, XTR_BISF_P supports downstream Treasury reporting and journal generation by supplying the reference identifiers and numeric adjustment values that other processes consume.

Key Procedures and Functions

The package exposes three documented functions:

  • XTR_REFERENCE_SPOT — Returns a numeric reference value for a given deal. It resolves the spot-side reference associated with a deal identified by its deal type and deal number. The numeric return type indicates it yields an internal reference key rather than a display reference string.
  • XTR_REFERENCE_INTERNAL — Returns a varchar2 reference for a deal, additionally qualified by a transaction number. This is the function associated with the search term "xtr_reference_internal". Because a transaction number is required, it targets a specific transaction line within a deal rather than the deal as a whole, and it returns a textual reference suitable for display, matching, or storage.
  • XTR_IG_ONC_SUM_INTADJ — Returns a numeric summary of internal adjustments. It is qualified by deal type, deal number, transaction number, and journal date, making it a date-sensitive aggregation of adjustment amounts tied to a specific journal accounting date.

No parameter lists beyond those shown are documented, and no additional overloads or procedures are declared in the specification.

Tables Accessed

The package operates against three Treasury base tables through APPS synonyms:

  • XTR_DEALS — The primary deal header table. Reference resolution functions read from this table to associate a deal type and deal number with its reference identifiers.
  • XTR_JOURNALS — The Treasury journal table. The adjustment summary function relies on this table, and the presence of a journal date parameter confirms the function aggregates journal entries filtered by accounting date.
  • XTR_ROLLOVER_TRANSACTIONS — The rollover transaction table, which supplies the transaction-level context required by XTR_REFERENCE_INTERNAL and XTR_IG_ONC_SUM_INTADJ.

Because these are read for reference resolution and summarization, the package is predominantly a query-oriented utility with no documented insert, update, or delete behavior.

Usage Notes

XTR_BISF_P is referenced by zero other packages in the documented metadata, which indicates that callers are not other PL/SQL APIs but rather direct consumers such as Treasury forms, concurrent programs, or custom extensions. Typical invocation scenarios include Treasury deal maintenance forms that need to display an internal reference for a transaction, and journal or income-generation reporting programs that require an adjustment total for a specific journal date. The journal date parameter on XTR_IG_ONC_SUM_INTADJ indicates the function must be called within the context of a defined accounting period, so callers should supply a valid, open, or historical journal date consistent with the data being reported. Since the package is not a formal API, custom code invoking it directly should treat the specification as subject to change between patch levels and should not rely on undocumented behavior beyond the three functions listed above.