Results for “conv_mc_bulk”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PA_FP_MULTI_CURRENCY_PKG is an Oracle Projects financial planning utility package (APPS schema, AUTHID CURRENT_USER) that performs currency conversion and monetary rounding for project forecast and budget lines in Oracle E-Business Suite 12.1.1 and 12.2.2. Its core purpose is to translate transaction currency amounts into project, project functional, and other currencies used by the financial plan, and then to round the resulting line amounts before they are stored against the plan. The package maintains cached state—project identifiers, financial plan type, rate types, exchange rates, and rate dates—through a set of global variables declared at the top of the specification. It also exposes several PL/SQL collection types (cached_row, cached_row_tab, number_type_tab, date_type_tab, char30_type_tab, char240_type_tab, and rowid_type_tab) that support bulk operations over arrays of resource assignments, dates, and amounts. Because the package is referenced by 19 other packages, it acts as a shared conversion engine across the Projects financial planning code path rather than a self-contained API.

Key Procedures and Functions

• CONV_MC_BULK — A bulk currency conversion routine that processes sets of resource assignment IDs, start and end dates, and transaction currency codes in array form, rather than one row at a time. It is used when many plan lines must be converted in a single pass for performance reasons.
• CONVERT_TXN_CURRENCY — Converts an individual transaction currency amount into the target currency, applying the appropriate cost or revenue exchange rate type and rate date from the package globals or the cached row data.
• ROUND_BUDGET_LINE_AMOUNTS — Rounds monetary amounts on budget lines after conversion, aligning them with the currency precision rules applied to the financial plan before the lines are persisted.
• GET_FP_CUR_DETAILS — Retrieves the effective currency and rate details for a financial plan, populating the package variables (project functional currency, project currency, cost and revenue rate types, exchange rates, and rate dates) that later calls depend on.
• ROUND_AMOUNTS — The general-purpose rounding routine. This is the procedure most closely associated with the search term "round_amounts"; it applies currency-specific rounding to converted amounts so plan totals remain consistent.

Tables Accessed

The package reads and writes through APPS synonyms across the Projects planning data model:

• PA_PROJECTS_ALL and PA_PROJ_FP_OPTIONS — supply project identifiers, project number, and financial plan type options that drive which currencies and rate types apply.
• PA_BUDGET_LINES and PA_BUDGET_VERSIONS — hold the budget and plan lines whose amounts are converted and rounded.
• PA_RESOURCE_ASSIGNMENTS and PA_RESOURCE_LIST_MEMBERS — identify the resources whose assignments carry conversion requirements.
• PA_FP_TXN_CURRENCIES — defines the transaction currencies accepted for the financial plan.
• PA_FP_ROLLUP_TMP — a temporary working table used when rolling up or staging converted amounts.
• PA_PROJ_ELEMENTS and PLITBLM — support element-level processing and the standard PL/SQL index-by table type used internally.

Usage Notes

PA_FP_MULTI_CURRENCY_PKG is an internal, non-API-classified (OTHER) package. It is not intended for direct customer invocation; instead it is called by the Projects budgeting and forecasting forms, concurrent programs that generate or refresh financial plans, and 19 dependent packages in the same product. Custom extensions should not call ROUND_AMOUNTS or CONV_MC_BULK directly, as parameter signatures and cached globals are not part of a supported public interface. Where rounding behaviour must be altered, the supported approach is to configure currency precision and financial plan options rather than to modify this package.