Search Results get_mau_secondary

Overview

PJI_PJP_FP_CURR_WRAP is a PL/SQL wrapper package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM API classification OTHER. It resides within the Oracle Projects product family, as indicated by the PJI prefix, and belongs to the Project Portfolio and Project Billing integration layer. The package provides a thin abstraction layer over currency conversion, monetary amount unit (MAU), and enterprise period utilities supplied by underlying Oracle Projects APIs. Its header comment, "$Header: PJIPUT2S.pls 120.2 2006/03/08," identifies it as a long-standing component first shipped in the 11i era and carried forward unchanged into EBS 12.1.1 and 12.2.2.

The central business purpose of this package is to centralize the retrieval of global currency settings and exchange rates used during time-and-expense processing, project costing, and cross-charge calculations. Because it declares AUTHID CURRENT_USER, the package executes with the privileges of the invoking user rather than the defining APPS schema, allowing it to participate in Oracle Projects' security model. The package is referenced by thirteen other packages, confirming its role as a shared, foundational utility rather than a user-facing API.

Key Procedures and Functions

The 15 documented members fall into several functional groups.

• Currency code accessors — GET_GLOBAL1_CURR_CODE and GET_GLOBAL2_CURR_CODE return the first and second global currency codes configured for the project enterprise.
• Primary and secondary rate lookups — GET_GLOBAL_RATE_PRIMARY, the function the user searched for, returns the exchange rate applicable to a supplied foreign currency code and exchange date, expressed against the primary (global1) currency. GET_GLOBAL_RATE_SECONDARY performs the equivalent lookup for the secondary (global2) currency. In this context "primary" denotes the conversion from a transaction currency into the enterprise's first global currency.
• MAU lookups — GET_MAU_PRIMARY, GET_MAU_SECONDARY, and GET_MAU return the monetary amount unit associated with the primary currency, the secondary currency, and an explicitly supplied currency code respectively.
• Direct rate conversion — GET_RATE accepts explicit from-currency, to-currency, and exchange date parameters, returning the rate for an arbitrary currency pair independent of the global currency configuration.
• Period and date utilities — GET_ENT_DATES_INFO returns enterprise start period, start and end dates, and their Julian equivalents. GET_GLOBAL_CURRENCY_INFO returns the conversion rule, prorating format, both global currency codes, and their MAUs as output parameters.
• Diagnostic and infrastructure routines — GET_WORKER_ID returns the current worker identifier. PRINT_TIME is a timing/diagnostic helper. EXCP_HANDLER and INIT_ERR_STACK provide standard error-stack handling consistent with Oracle's API error conventions. SET_TABLE_STATS is an optimizer statistics utility.

Tables Accessed

The package references three objects through APPS synonyms. PJI_SYSTEM_SETTINGS supplies the enterprise-level configuration governing global currencies, conversion rules, prorating formats, and MAUs, making it the principal source for the accessor and currency-info routines. PJI_TIME_ENT_PERIOD provides enterprise period definitions used by GET_ENT_DATES_INFO. DUAL is used for single-row arithmetic and simple scalar returns. All documented access is read-oriented; no insert, update, or delete operations are implied by the metadata.

Usage Notes

PJI_PJP_FP_CURR_WRAP is typically invoked indirectly. Concurrent programs and Oracle Forms within Oracle Projects, particularly those supporting time entry, expenditure processing, and project performance reporting, call it to resolve currency rates without duplicating conversion logic. The same applies to the thirteen dependent packages, which consume its functions as a stable interface should the underlying Shane-authored APIs change. Custom extensions built on Oracle Projects should call GET_GLOBAL_RATE_PRIMARY or GET_RATE rather than querying currency tables directly, ensuring consistency with the global currency configuration. Because the package operates under AUTHID CURRENT_USER, callers must hold appropriate execute privileges and the underlying APPS synonym grants. The code is unchanged between 12.1.1 and 12.2.2, so behavior is consistent across both releases.