Search Results get_trans_currency_info

Overview

The APPS.PA_CURRENCY package body is a foundational currency-handling utility within the Oracle Projects (PA) application family in Oracle E-Business Suite 12.1.1 and 12.2.2. Its principal business function is to centralize the retrieval, storage, and rounding of monetary values across the multiple currency contexts that Oracle Projects processes — functional (ledger) currency, project currency, and transaction currency. Because Oracle Projects supports multi-currency project accounting, amounts originating in one currency frequently must be interpreted, formatted, or rounded according to a different currency context before they can be reported, invoiced, or posted to General Ledger. PA_CURRENCY provides the shared session-level currency context and the reusable rounding and formatting primitives that other Oracle Projects packages depend upon, ensuring consistent monetary precision throughout the application. It is classified as an OTHER API rather than a public web-service-enabled PL/SQL API, meaning it is intended primarily for internal application use.

Key Procedures and Functions

The documented package exposes twelve procedures and functions:

• SET_CURRENCY_INFO — establishes and caches currency context information for the current session based on implementation and ledger settings.
• GET_CURRENCY_CODE — returns the applicable currency code for the requested currency context.
• ROUND_CURRENCY_AMT and ROUND_CURRENCY_AMT1 — round a supplied amount to the precision defined for a given currency.
• ROUND_TRANS_CURRENCY_AMT and ROUND_TRANS_CURRENCY_AMT1 — round amounts specifically in the transaction currency context.
• CURRENCY_FMT_MASK — supplies the format mask used to display a currency amount.
• RPT_CURRENCY_FMT_MASK — supplies the format mask appropriate for reporting output.
• TRANS_CURRENCY_FMT_MASK — supplies the format mask for transaction currency display.
• GET_MAU — retrieves the minimum accountable unit (the smallest rounding increment) for a currency.
• ROUND_CURRENCY_AMT_BLK — a block-level rounding routine applied to amounts in a set-oriented processing context.
• ROUND_CURRENCY_AMT_NESTED_BLK — a nested-block variant of the rounding routine used where rounding must occur within an inner PL/SQL block.

Tables Accessed

The package reads from a small, well-defined set of reference and configuration tables through APPS synonyms:

• FND_CURRENCIES — the Oracle Application Object Library currency repository, supplying currency codes, precision, and minimum accountable unit definitions.
• PA_IMPLEMENTATIONS and PA_IMPLEMENTATIONS_ALL — Oracle Projects implementation parameters, which determine the operating currency contexts and defaulting behavior for the installation.
• PLITBLM — the PL/SQL integer-table buffer used for bulk currency processing operations.

The dependency on GL_SETS_OF_BOOKS reflects the package's need to align functional currency with the associated ledger.

Usage Notes

PA_CURRENCY is referenced by 141 other database objects, confirming its role as a shared low-level service rather than a standalone entry point. It is typically invoked indirectly: Oracle Projects forms, concurrent programs (such as cost distribution, revenue generation, and invoicing), and other PL/SQL packages call SET_CURRENCY_INFO to establish session context, then use the rounding and formatting routines when displaying or persisting monetary values. Custom extensions that must reproduce Oracle Projects rounding behavior should call the same functions rather than implementing independent rounding logic, so that amounts remain consistent with the standard application.