Search Results pji_rep_dflt_drilldown_txn




Overview
Explore in AI Chat

Overview

The APPS.PJI_REP_DFLT_DRILLDOWN_TXN package is a PL/SQL database object owned by the APPS schema and classified under the OTHER API classification within Oracle E-Business Suite. Its name, combining the PJI product prefix (Oracle Projects Intelligence / Projects reporting) with the terms "REP", "DFLT", "DRILLDOWN", and "TXN", indicates that it supports the default drill-down transaction reporting behavior for Oracle Projects. In practical terms, this package provides the server-side logic that determines what "default" parameters a Projects-related report or dashboard should use, and how drill-down from summarized report rows resolves to the underlying transactions, events, and costs.

Unlike a public, customer-facing API, this package is an internal helper object. The ETRM metadata confirms that it exposes no documented public interface parameters and is referenced by no other packages, which is characteristic of a report-support utility invoked indirectly by a specific Oracle Projects reporting component.

Key Procedures and Functions

The documented package exposes two procedures:

  • DERIVE_PARAMETERS — Derives the default parameter values used by the drill-down report. This routine encapsulates the logic that computes or infers reporting parameters (such as organizational, resource, or time-related defaults) so the report can execute without requiring the user to specify every value manually.
  • DETERMINE_EVENTS_COSTS_DISPLAY — Determines how events and costs are displayed within the drill-down output. This routine governs the presentation logic that decides which underlying event and expenditure records are surfaced when a user drills from a summarized figure into its constituent detail.

Both procedures are server-side and are not documented as callable public APIs, consistent with their role as internal reporting helpers.

Tables Accessed

The package references a broad set of Oracle Projects and associated tables through APPS synonyms. These reflect its dual responsibilities of parameter derivation and drill-down resolution:

Usage Notes

Because the package is referenced by no other packages and is not catalogued as a public API, it is best understood as an internal component of the Oracle Projects Intelligence reporting framework. It is typically invoked indirectly when a user runs the associated drill-down report and requests default parameter population or expands a summary line into event and cost detail. The presence of the report-structure tables (PJI_TIME_RPT_STRUCT, PJI_TIME_CAL_RPT_STRUCT) strongly suggests the object belongs to a time-oriented Projects report rather than a general-purpose utility.

For customization, the recommended approach is to call the package only through the standard report that consumes it and to avoid direct dependency in custom code, since the procedures are undocumented and unsupported as a public interface. Any modification should be regression-tested against both 12.1.1 and 12.2.2, as drill-down and reporting logic can vary by release.