Search Results derive_default_parameters

Overview

The APPS.PJI_REP_WP_DFLT_PARAMS package is a PL/SQL component belonging to the Oracle E-Business Suite Projects Intelligence (PJI) application module. Its name reflects its role within the "Rep WP" (Reporting Workbench or Reporting Work Process) area of the Projects Intelligence reporting framework, where it supplies default parameter values that drive report execution and workbench rendering. In the ETRM metadata for Release 12.2.2, the package is classified with an API classification of OTHER, indicating that it is a supporting utility package rather than a published public API. It is a VALID object owned by the APPS schema and carries a dependency on the SYS.STANDARD package, which is the standard PL/SQL package present in every Oracle database. The package does not expose a formal public interface consumed by other application packages; the ETRM records show it is referenced by no other packages, confirming that it is used internally within the Projects Intelligence layer.

Key Procedures and Functions

• DERIVE_DEFAULT_PARAMETERS — This procedure derives and returns the default parameter values used when a Projects Intelligence report or workbench is initialized. It is the primary entry point of the package, responsible for populating the parameter set that the reporting framework applies when a user opens a report without explicitly supplying values.
• GET_CURRENCY_TIP — This function returns a currency-related tip or hint string, typically used to display contextual guidance to the user regarding currency selection or currency conversion within the reporting workbench interface. The term "TIP" in Oracle EBS convention usually refers to a tooltip or informational message surfaced in a form or OAF page.

No parameter lists are documented in the ETRM metadata for either routine, so callers should obtain the exact signatures from the package specification stored in the APPS schema rather than relying on assumptions.

Tables Accessed

• FND_NEW_MESSAGES — The Oracle Application Object Library messages table. Accessed to retrieve translatable message text, most likely the currency tip returned by GET_CURRENCY_TIP, ensuring the tip respects the session language.
• PA_PROJECTS — The core Oracle Projects table of project definitions. Accessed to derive project-related default parameters, such as the default project or project context used by the reporting workbench.
• PJI_TIME_CAL_PERIOD — The Projects Intelligence time calendar period table. Accessed to derive default period parameters, such as the current or default reporting period used to seed the workbench.

Usage Notes

This package is invoked internally by the Projects Intelligence reporting framework whenever default parameters must be established for a reporting workbench session. It is not intended as a general-purpose customer API, and the ETRM metadata records no referencing packages, meaning it is called directly by the form or OAF layer, or by other PJI-internal code paths. Because it reads from PA_PROJECTS and PJI_TIME_CAL_PERIOD, any customization should account for the possibility that these queries are subject to the standard Oracle Projects security model and operating unit context. The dependency on FND_NEW_MESSAGES means that message text is resolved at runtime and cached according to AOL message caching rules. The metadata notes that the package references SYS.STANDARD only, so it has no dependency on other APPS packages, making it relatively self-contained and low-risk from a patch impact perspective. Developers should not call this package as a substitute for standard Oracle Projects parameter APIs; it is a presentation-layer default provider for the Projects Intelligence workbench rather than an integration point. For Releases 12.1.1 and 12.2.2, the package is expected to be present and VALID, and any invalidation should be resolved by recompiling it from the APPS schema.