Search Results calculate_capacity

Overview

PA_REP_UTIL_SCREEN is a PL/SQL package in the Oracle EBS Projects (PA) module that supports the Utilization reporting screens and concurrent processes. It is defined with AUTHID CURRENT_USER, meaning that its unqualified references to database objects are resolved in the schema of the calling user rather than the package owner. Its primary business purpose is to populate temporary reporting tables with summarized utilization data for a selected organization, manager, and reporting period, and to compute capacity figures used to derive utilization percentages. The package therefore functions as the data-preparation and calculation layer behind the Utilization inquiry and reporting screens in Oracle Projects, converting raw summarized balances and resource information into the display-oriented rows held in the temporary tables. The parameter p_period_year appears in two of the three documented program units and identifies the calendar or accounting year for which utilization data is being assembled; it is accepted as a NUMBER in poplt_screen_tmp_table and as a VARCHAR2 in poplt_u1_screen_tmp_table.

Key Procedures and Functions

• POPLT_SCREEN_TMP_TABLE — Populates the primary utilization reporting temporary table. It accepts organization, manager, period type, period year, period quarter, period name, global week end date, assignment status, show percentage by, utilization method, utilization category, and calling mode as inputs, allowing the caller to narrow the result set to a specific reporting context and controlling how percentages are presented.
• POPLT_U1_SCREEN_TMP_TABLE — Populates a secondary utilization temporary table associated with a screen variant (the U1 screen). Its parameter set is narrower and does not include manager, utilization method, category, or calling mode, and it receives the period year, quarter, name, and week end date as character values. This variant is oriented toward a more restricted set of screen criteria.
• CALCULATE_CAPACITY — Returns a NUMBER representing calculated capacity for a given organization, balance type, entity, version, period type/set/name, global expenditure period end date, and the amount identifiers for resource hours, capacity, and reduced capacity, together with the show-percentage-by option. Optional parameters for organization, period year, and quarter-or-month number refine the calculation. This function supplies the denominator and related measures used when computing utilization percentages for the selected period year.

Tables Accessed

• PA_REP_UTIL_SCREEN_TMP — The primary temporary working table written by POPLT_SCREEN_TMP_TABLE for utilization screen display.
• PA_REP_UTIL_SCR_U1_TMP — The secondary temporary table written by POPLT_U1_SCREEN_TMP_TABLE.
• PA_SUMM_BALANCES — Summarized project balances that provide the base amounts from which utilization and capacity figures are derived.
• PA_RESOURCES_DENORM — Denormalized resource information used to identify resources and their attributes for the report.
• GL_PERIODS — General Ledger period definitions used to resolve period names, years, and end dates.
• PA_OBJECTS — Project objects referenced for entity and organizational context.

Usage Notes

In Oracle EBS 12.1.1 and 12.2.2, PA_REP_UTIL_SCREEN is normally invoked indirectly by the Utilization reporting forms and their associated concurrent programs rather than being called directly by end users. The screen population procedures are called when a user submits utilization query criteria, at which point the temporary tables are refreshed and the screen reads from them. CALCULATE_CAPACITY is called during the same processing to obtain capacity amounts needed for percentage computation. Because the package is documented as referenced by seven other packages, it should be treated as a shared utility layer within Oracle Projects; customizations that invoke it should match the documented parameter signatures and respect the AUTHID CURRENT_USER resolution behavior. Direct modification is not supported, and the temporary tables should be regarded as transient working structures whose contents are valid only for the duration of the reporting session.