Results for “pa_org_util_def_calc_method”

33 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.PJI_PMV_UTLZ is a PL/SQL package body belonging to the Oracle Project Intelligence (PJI) product family within Oracle E-Business Suite. Its role is to provide the SQL generation layer that feeds Oracle Daily Business Intelligence and Project Management View (PMV) reporting pages. Specifically, the package contains procedures that build dynamic SQL statements used by the PMV engine to render Key Performance Indicator and utilization report pages.

The package body is dated by its header comment ($Header: PJIRR02B.pls 120.2 2005/12/07) and is shipped in the APPS schema. It is classified under ETRM as an "OTHER" API type, meaning it is not a formally published public API but an internal component called by the PMV engine infrastructure. Its naming convention—PJI_PMV_UTLZ—aligns it with the Project Intelligence PMV utilities layer, complementing packages such as PJI_PMV_ENGINE.

Key Procedures and Functions

The documented excerpt exposes the procedure Get_SQL_PJI_REP_UAP1. This procedure accepts a page parameter table (BIS_PMV_PAGE_PARAMETER_TBL) as input and returns a generated SQL string (x_PMV_Sql) along with query attributes (x_PMV_Output, of type BIS_QUERY_ATTRIBUTES_TBL).

Its core responsibility is to define the SELECT list passed into PJI_PMV_ENGINE.Generate_SQL. The column mappings reveal the measures produced by this page: actual utilization percentage, resource hours percentage, billable hours percentage, change percentages, actual and prior-period utilization hours, denominators, resource hours, total resource hours, and billable hours. Collectively these represent a utilization and billable-hours analysis report, referencing the FACT table aliased in the generated statement.

The ETRM metadata records zero documented procedures or functions for this package, which is consistent with the object being a helper routine whose signature is captured in the source excerpt rather than in the formal API registry. No additional procedures should be inferred beyond those shown.

Tables Accessed

The ETRM metadata lists no tables referenced through APPS synonyms for this package. This is expected because the package does not execute SQL directly; it constructs a SQL statement whose FROM clause and fact table are resolved at runtime by PJI_PMV_ENGINE. The generated SELECT list targets a table aliased as FACT, which corresponds to the Project Intelligence fact table underlying the utilization report. All measure columns—BILL_HOURS_PERCENT, ACT_UTIL_PERCENT, RES_HOURS_PERCENT, and the PRIOR_ variants—are read-only projected values. Because table resolution is deferred to the engine, the referenced object does not appear in this package's dependency metadata.

Usage Notes

PJI_PMV_UTLZ is invoked as part of the PMV page-definition framework. When a user opens a Project Intelligence utilization or billable-hours dashboard page, the PMV engine looks up the page's registered SQL-generation routine—in this case Get_SQL_PJI_REP_UAP1—passes the page parameter table, and receives a ready-to-execute SQL statement. The procedure is therefore not called directly from Oracle Forms, concurrent programs, or typical custom code; it is registered to a DBI/PMV page through the standard page definition setup.

Developers extending or debugging a PMV utilization page should consult this package to understand how the page's SELECT list is composed. Because it is an unreleased internal object, direct invocation from custom code is unsupported and any modification should be treated as a patch to seeded EBS functionality. The package is not referenced by any other documented package, confirming its position as a leaf-level generator called only by the PMV engine.