Search Results py_cost

Overview

APPS.PJI_PMV_PROFITABILITY_TREND is an Oracle E-Business Suite package body belonging to the Projects Intelligence (PJI) application module. Its purpose is to supply the SQL generation logic consumed by the Profitability Trend page-based metric view (PMV) region PJI_REP_PP5, which drives the Profitability Trend reporting interface. Instead of embedding SQL directly, the package delegates statement construction to the shared engine API PJI_PMV_ENGINE.Generate_SQL, passing the page parameters received from the calling page and returning the generated SQL text and query attribute descriptors to the caller.

The package therefore acts as a thin adapter between a specific PMV region and the generic PJI reporting engine. The trend analysis exposed through this region compares current period revenue and margin values against prior-year (PY) equivalents, which explains the presence of the PY_REVENUE, PY_MARGIN, PY_MARGIN_PERCENT, and associated change-percent columns in the select list. In the context of the user search term "py_cost", it is worth noting that the documented select list exposes prior-year revenue and margin measures but not a prior-year cost column directly; cost is effectively implied through the margin calculations derived by the underlying engine.

Key Procedures and Functions

The documented package exposes a single procedure, Get_SQL_PJI_REP_PP5, which returns the SQL statement generated by the base engine API for the report region PJI_REP_PP5. The procedure accepts the PMV page parameter table as input and returns the SQL text and the query output attribute collection as output parameters. The metadata lists no additional documented procedures or functions for this package body; other members referenced by the source (such as the PL/SQL driver callback PLSQLDriver_PJI_REP_PP5) are invoked indirectly through the engine rather than exposed as independently documented APIs.

The select list assembled by the procedure maps engine fact columns to PMV measure tokens including PJI_REP_MSR_1 through PJI_REP_MSR_13, covering revenue, prior-year revenue, revenue change percent, margin, prior-year margin, margin percent, and the corresponding change percentages. Both current and prior-year variants of the margin measures are aliased to the same measure tokens in the source excerpt, a characteristic that reflects how the PMV layout handles comparative positioning.

Tables Accessed

The referenced-table metadata for this package is limited, and no APPS synonym dependencies are documented in the ETRM extract. The package does not issue direct SQL against base tables within its own body; it constructs a statement text that is subsequently executed by the PMV engine framework. Consequently, the physical tables read at runtime are those resolved by PJI_PMV_ENGINE and the underlying Projects fact and dimension views, not tables named explicitly inside PJI_PMV_PROFITABILITY_TREND.

Usage Notes

This package is invoked by the Oracle EBS page-based metric view framework when a user opens the Profitability Trend region associated with PJI_REP_PP5. The engine calls Get_SQL_PJI_REP_PP5 with the runtime page parameter table supplied by the UI, and the returned SQL and attribute definitions populate the region's result set. Parameters passed through to the engine include organization and operating unit selections, currency, as-of date, period type, view-by option, project classification category and code, and project revenue category values.

Because the package provides no independently callable business API, customizations should not invoke it directly. Extensions to the Profitability Trend output are more appropriately implemented by modifying or extending the PJI PMV engine configuration, or by creating a new region and driver combination rather than altering this package body. The header comment records a version of 120.4 dated 2005, indicating the object has been stable across the 12.1.1 and 12.2.2 releases and is maintained as shipped code.