Search Results get_sec_curr_name




Overview
Explore in AI Chat

Overview

FII_CURRENCY_API is a public PL/SQL API in the APPS schema that provides currency-related naming and display services to other Oracle E-Business Suite components. Its primary business function is to produce consistent, human-readable representation strings for currencies and rate types used throughout the financial intelligence and reporting layers of EBS. Rather than forcing each calling program to construct its own currency label, the package centralizes this logic so that display strings remain uniform across forms, reports, and concurrent programs.

The package carries a header revision of 120.3 (dated 2005/10/30) and is classified as an API in the ETRM registry, meaning it is intended for invocation by other code rather than for direct end-user execution. Its functions are read-only; no data manipulation occurs. Display names are cached after first access, reducing repetitive queries against reference data and improving performance in loops or multi-row report contexts.

Key Procedures and Functions

The package exposes four documented functions:

  • GET_DISPLAY_NAME — Returns the display name of a currency code formatted together with a specified rate type. For example, given the currency code USD and the rate type Corporate Rate, it returns a string such as "USD at Corporate Rate". SQL errors encountered during processing raise an exception to the caller. This is the function most commonly referenced in searches and is the package's principal entry point.
  • GET_PRIM_CURR_NAME — Returns the display name associated with the primary currency configuration, allowing callers to obtain a formatted label for the primary currency without supplying parameters.
  • GET_SEC_CURR_NAME — Returns the display name for the secondary currency configuration, supporting dual-currency reporting scenarios where a secondary currency is tracked alongside the primary.
  • GET_ANNUALIZED_CURR_NAME — Returns the display name for the annualized currency, introduced under enhancement reference enh#3659270, typically used where annualized financial figures must be labeled distinctly.

The package specification declares PRAGMA RESTRICT_REFERENCES (get_display_name, WNDS), asserting that GET_DISPLAY_NAME writes no database state. This purity guarantee allows the function to be called safely from SQL statements and from other PL/SQL constructs that enforce read-only constraints.

Tables Accessed

The documented table reference for this package is GL_DAILY_CONVERSION_TYPES, accessed via an APPS synonym. This General Ledger table stores the rate types (such as Corporate Rate or Spot) used in currency conversion definitions. FII_CURRENCY_API reads this table to validate the supplied rate type and to obtain the descriptive text incorporated into the display name returned by GET_DISPLAY_NAME. Because the package only reads and caches this reference data, no insert, update, or delete operations are performed, and no locking behavior is introduced.

Usage Notes

FII_CURRENCY_API is referenced by four other packages within the EBS codebase, indicating that it functions as a shared utility layer rather than a standalone feature. Typical invocation occurs from custom PL/SQL code, report programs, and form-level logic that must present currency identifiers to users in a standard format. Callers should note that the cache populated after initial access persists for the session, so changes to currency or rate type definitions made within the same session may not be immediately reflected.

Because GET_DISPLAY_NAME raises an exception on SQL error, calling code should include appropriate exception handling. In Oracle EBS 12.1.1 and 12.2.2 environments, the package resides in the APPS schema, and callers must therefore reference it as APPS.FII_CURRENCY_API unless an APPS synonym is available to the calling schema. Its read-only nature and WNDS pragma make it suitable for use in SQL expressions, views, and other contexts where side-effecting PL/SQL is prohibited.