Search Results pji_vp_rep_dflt_params




Overview
Explore in AI Chat

Overview

APPS.PJI_VP_REP_DFLT_PARAMS is a PL/SQL package body in the Oracle E-Business Suite Applications schema. Its name reflects its role within the PJI (Project Intelligence) module, specifically the "VP Reporting Default Parameters" area. The package supplies the runtime logic that derives and returns the default parameter values used when a Project Intelligence reporting or visual reporting process is launched without an explicit parameter set. In effect, it acts as a parameter-resolution helper: given project context, it computes sensible defaults so that the reporting engine can proceed without requiring the user to supply every value manually.

The object is recorded as VALID in the ETRM repository for both Oracle EBS 12.1.1 and 12.2.2, and its API classification is OTHER, meaning it is an internal utility package rather than a formal public API. It depends on the standard EBS API framework (FND_API), the project financial planning utilities (PA_FIN_PLAN_UTILS), the PJI reporting utilities (PJI_REP_UTIL), and the SQL collection type PA_NUM_TBL_TYPE from the SYSTEM schema. The package body does not appear in the dependency list of any other database object, which indicates it is consumed at the application layer rather than being called directly by other PL/SQL packages.

Key Procedures and Functions

The ETRM documentation lists a single documented program unit within this package body:

  • DERIVE_DEFAULT_PARAMETERS — The core routine that calculates and returns the default parameter values applicable to a Project Intelligence report invocation. It encapsulates the derivation rules that translate project and planning context into report parameters. Consistent with the ETRM metadata, no parameter list is documented; consumers should treat its signature as internal and subject to change across releases.

Because only one procedure is exposed, the package is narrowly scoped: it centralises default-value logic rather than offering a broad set of utilities.

Tables Accessed

The documented table reference for this package is through the APPS synonym PA_PROJECTS_ALL, the master view of projects in Oracle Projects. The package reads project attributes from this table to establish the project context from which defaults are derived. Additional data may be obtained indirectly through the referenced utilities (PA_FIN_PLAN_UTILS and PJI_REP_UTIL), but PA_PROJECTS_ALL is the only table explicitly documented as accessed by this object.

Usage Notes

In typical Oracle EBS deployments, PJI_VP_REP_DFLT_PARAMS is invoked internally by the Project Intelligence reporting framework when a report is submitted without a complete parameter list. It is not intended to be called directly from custom code, and the ETRM dependency data confirms that no other database object references it. Because the package relies on FND_API, it participates in the standard EBS error-handling and message conventions, returning errors through the FND message stack rather than raw exceptions.

Customers and integrators should not modify this package, as it is an APPS-owned object and would be overwritten during patching. Where customisation of default report parameters is required, the supported approach is to extend or override behaviour through the standard Project Intelligence configuration and parameter defaults, not by editing this package body. Because the documented metadata exposes only one procedure and one table, any deeper behavioural analysis should be based on the actual source in the target environment, since the package body text itself is not reproduced in the ETRM excerpt.