Search Results pa_currency

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.

PACKAGE BODY: APPS.PA_CURRENCY 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_CURRENCY, status:VALID,
PACKAGE BODY: APPS.PA_CURRENCY 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PA_CURRENCY, status:VALID,
PACKAGE BODY: APPS.PA_MISC 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PA_MISC, status:VALID,
PACKAGE BODY: APPS.PA_BUDGET_MATRIX_LINES_V_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_BUDGET_MATRIX_LINES_V_PKG, status:VALID,
PACKAGE BODY: APPS.PA_BILL_SCHEDULE 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PA_BILL_SCHEDULE, status:VALID,
PACKAGE BODY: APPS.PA_PAXCPCAL_XMLP_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_PAXCPCAL_XMLP_PKG, status:VALID,
PACKAGE BODY: APPS.PA_PAXPCPRS_XMLP_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PA_PAXPCPRS_XMLP_PKG, status:VALID,
PACKAGE BODY: APPS.PA_PAXEXONE_XMLP_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_PAXEXONE_XMLP_PKG, status:VALID,
PACKAGE BODY: APPS.PA_PAXAUGLT_XMLP_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PA_PAXAUGLT_XMLP_PKG, status:VALID,
PACKAGE BODY: APPS.PA_PAXAUGLT_XMLP_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_PAXAUGLT_XMLP_PKG, status:VALID,
PACKAGE BODY: APPS.PA_COST_PLUS1 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_COST_PLUS1, status:VALID,
PACKAGE BODY: APPS.PA_ONLINE_COPY_EXP 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PA_ONLINE_COPY_EXP, status:VALID,
PACKAGE BODY: APPS.PA_MULTI_CURRENCY 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PA_MULTI_CURRENCY, status:VALID,
PACKAGE BODY: APPS.PA_FORECAST_COST 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PA_FORECAST_COST, status:VALID,
PACKAGE BODY: APPS.PA_MC_BILLING_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_MC_BILLING_PVT, status:VALID,
PACKAGE BODY: APPS.PA_BUDGET_VERSIONS_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PA_BUDGET_VERSIONS_PKG, status:VALID,
PACKAGE BODY: APPS.PA_CI_SUPPLIER_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PA_CI_SUPPLIER_PKG, status:VALID,
PACKAGE BODY: APPS.PA_COST_PLUS1 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PA_COST_PLUS1, status:VALID,
PACKAGE BODY: APPS.PA_PAUBRUER_XMLP_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PA_PAUBRUER_XMLP_PKG, status:VALID,
PACKAGE BODY: APPS.PA_CMT_UTILS 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PA_CMT_UTILS, status:VALID,
PACKAGE BODY: APPS.PA_BUDGET_LINES_V_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PA_BUDGET_LINES_V_PKG, status:VALID,
PACKAGE BODY: APPS.PA_MISC 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_MISC, status:VALID,
PACKAGE BODY: APPS.PA_BUDGET_VERSIONS_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_BUDGET_VERSIONS_PKG, status:VALID,
PACKAGE BODY: APPS.PA_PAXEXONE_XMLP_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PA_PAXEXONE_XMLP_PKG, status:VALID,
PACKAGE BODY: APPS.PA_PAUBRUER_XMLP_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_PAUBRUER_XMLP_PKG, status:VALID,
PACKAGE BODY: APPS.PA_BUDGET_MATRIX_LINES_V_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PA_BUDGET_MATRIX_LINES_V_PKG, status:VALID,
PACKAGE BODY: APPS.PA_PAXACRTA_XMLP_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PA_PAXACRTA_XMLP_PKG, status:VALID,
PACKAGE BODY: APPS.PA_PAXCPGAL_XMLP_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PA_PAXCPGAL_XMLP_PKG, status:VALID,
PACKAGE BODY: APPS.PA_FORECAST_COST 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_FORECAST_COST, status:VALID,
PACKAGE BODY: APPS.PA_PAXACMPT_XMLP_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_PAXACMPT_XMLP_PKG, status:VALID,
PACKAGE BODY: APPS.PA_EVENT_PUB 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_EVENT_PUB, status:VALID,
PACKAGE BODY: APPS.PA_PLAN_REVENUE 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_PLAN_REVENUE, status:VALID,
PACKAGE BODY: APPS.PA_BILLING_AMOUNT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PA_BILLING_AMOUNT, status:VALID,
PACKAGE BODY: APPS.GMS_BILLING_ADJUSTMENTS 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:GMS_BILLING_ADJUSTMENTS, status:VALID,
PACKAGE BODY: APPS.PA_REVENUE_AMT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_REVENUE_AMT, status:VALID,
PACKAGE BODY: APPS.PA_MC_BILLING_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PA_MC_BILLING_PVT, status:VALID,
PACKAGE BODY: APPS.PA_PAXACRPT_XMLP_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PA_PAXACRPT_XMLP_PKG, status:VALID,
PACKAGE BODY: APPS.PA_ONLINE_COPY_EXP 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_ONLINE_COPY_EXP, status:VALID,
PACKAGE BODY: APPS.PA_PAXACRPT_XMLP_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_PAXACRPT_XMLP_PKG, status:VALID,
PACKAGE BODY: APPS.PA_PAXCPGAL_XMLP_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_PAXCPGAL_XMLP_PKG, status:VALID,
PACKAGE BODY: APPS.PA_CMT_UTILS 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_CMT_UTILS, status:VALID,
PACKAGE BODY: APPS.PA_BILL_SCHEDULE 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_BILL_SCHEDULE, status:VALID,
PACKAGE BODY: APPS.PA_MULTI_CURRENCY_TXN 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PA_MULTI_CURRENCY_TXN, status:VALID,
PACKAGE BODY: APPS.PA_AGREEMENT_CORE 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PA_AGREEMENT_CORE, status:VALID,
PACKAGE BODY: APPS.PA_FP_SPREAD_AMTS_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_FP_SPREAD_AMTS_PKG, status:VALID,
PACKAGE BODY: APPS.PA_FP_MULTI_CURRENCY_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_FP_MULTI_CURRENCY_PKG, status:VALID,
PACKAGE BODY: APPS.PA_CAPITAL_EVENTS_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_CAPITAL_EVENTS_PVT, status:VALID,
PACKAGE BODY: APPS.PA_PAXCPCAL_XMLP_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PA_PAXCPCAL_XMLP_PKG, status:VALID,
PACKAGE BODY: APPS.PA_PAXPCPRS_XMLP_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_PAXPCPRS_XMLP_PKG, status:VALID,
PACKAGE BODY: APPS.PA_REVENUE_AMT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PA_REVENUE_AMT, status:VALID,