Search Results get_currency_tip

Overview

APPS.PJI_REP_VP_UTILS is a PL/SQL package body in the Oracle E-Business Suite Projects Intelligence (PJI) application, catalogued under the APPS schema with a VALID status in both release 12.1.1 and 12.2.2. Its name and dependency footprint identify it as a utility layer for the "VP" (version planning) reporting component of PJI, which supplies the reporting and analytics objects that surface project financial plan versions to end users. Rather than performing a single business transaction, the package encapsulates reusable validation and presentation-support logic that other PJI reporting routines call to keep plan-version processing consistent. The ETRM classification for this object is OTHER, indicating it is a supporting utility rather than a public, externally documented API. It carries no "referenced by" entries in the dependency catalogue, confirming that it is invoked internally by its own package family and by PJI reporting code rather than being a published integration point. Its principal dependencies — PA_FIN_PLAN_UTILS, PA_PROJECTS, PJI_REP_UTIL, PJI_REP_VP_UTILS itself, plus the FND_API, FND_MESSAGE, and FND_NEW_MESSAGES foundation packages — show that it bridges Oracle Projects financial-plan data and the EBS message/API framework.

Key Procedures and Functions

The documented package metadata exposes two callable units:

• CHECK_PLAN_VERSION_LOCK — a validation routine that determines whether a given project financial plan version is locked and therefore unavailable for modification or certain reporting operations. This guards downstream logic against acting on a version that is in a locked state, and typically returns or raises an outcome consistent with the FND_API error-handling convention the package depends on.
• GET_CURRENCY_TIP — a presentation-support function that retrieves the tooltip (hint) text associated with a currency value, most likely sourced through the FND_MESSAGE / FND_NEW_MESSAGES message dictionary so that currency labels and explanatory text are translatable and centrally maintained.

The metadata does not publish parameter lists or return signatures for either unit; consumers should treat them as internal utilities and inspect the package specification in the target instance before direct invocation.

Tables Accessed

Two tables are documented as accessed through APPS synonyms:

• PA_PROJECTS — the Oracle Projects master project table, read to resolve the project context against which a plan version and its currency are evaluated.
• FND_NEW_MESSAGES — the Oracle Application Object Library message repository, read to obtain message and tooltip text used by GET_CURRENCY_TIP and, potentially, error text returned by CHECK_PLAN_VERSION_LOCK.

The dependency list additionally names PA_FIN_PLAN_UTILS, whose logic underpins plan-version state determination. No write operations are documented.

Usage Notes

Because APPS.PJI_REP_VP_UTILS is referenced by no other database object in the documented dependency graph, it is not a shared entry point across the application. It is invoked from within the PJI reporting stack — most plausibly from PJI report or OAF/Forms pages that display project plan versions — to validate version lock status before rendering or acting, and to resolve currency tooltip text for display. Custom code should not depend on this package unless the specification is examined and the internal usage context is understood; the supported route for plan-version inquiries remains the Oracle Projects public APIs. Any direct use should be wrapped in standard FND_API error handling consistent with the package's own dependencies.