Search Results c_rpt_act_cost_sumformula




Overview
Explore in AI Chat

Overview

PA_PAXMGTSD_XMLP_PKG is the generated PL/SQL package that underpins the Oracle EBS concurrent program and XML Publisher (BI Publisher) report associated with the Project Management Task Summary / project actual-versus-budget cost review. The suffix "XMLP_PKG" indicates that the package was produced by the Oracle Reports-to-XML Publisher migration utility, which wraps the data model and formula columns of a legacy Oracle Reports (RDF) file inside a PL/SQL package so it can be executed as a concurrent program against the XML Publisher engine. The package is owned by APPLS and is declared AUTHID CURRENT_USER, meaning that name resolution for the referenced PA tables and synonyms occurs under the privileges of the invoking schema (typically APPS).

Functionally, the package gathers period-based actual costs and budgeted amounts for a selected project, task, or resource, applies the requested budget type and rule optimizer options, and produces the formatted report data set. Its business purpose is to let project managers and cost analysts compare actual expenditure to budgeted cost or revenue at the task or resource level for a given GL/PA period.

Key Procedures and Functions

The package exposes several report life-cycle entry points. BEFOREREPORT, AFTERREPORT, and GET_COVER_PAGE_VALUES initialize report parameters and build the cover page header, while GET_COMPANY_NAME and NO_DATA_FOUND_FUNC populate descriptive header values. GET_PERIOD and PERIOD_NAMEFORMULA derive the period display name from a supplied date.

The calculation layer consists of formula functions that map to report columns: C_TASK_ACTUAL_COSTFORMULA returns the task-level actual cost, C_ACT_PER_REVFORMULA and C_ACT_PER_COSTFORMULA return period-to-date actual revenue and cost for a resource/task, and GET_PERIOD_AMT is the shared amount-retrieval routine these formulas call. GET_RSRC_NAME_DISP resolves a resource name for display from an alias and level.

The summation and totals functions support the report’s summary mode: C_ACT_PER_REV_SUMFORMULA, C_ACT_PER_COST_SUMFORMULA, GET_PERIOD_AMT_SUM, C_SUM_RPT_TOTALSFORMULA, CHECK_SUM_RPT_TOTALS, C_RPT_BGT_COST_SUMFORMULA, GET_REPORT_LINE_TOTAL, and C_RPT_ACT_COST_SUMFORMULA. The latter, C_RPT_ACT_COST_SUMFORMULA, is the object most closely matching the user’s search term "c_rpt_act_cost_sumformula" and computes the report-level aggregate of actual cost when the summary totals option is enabled.

Tables Accessed

  • PA_PROJECTS – project number, name, and manager details for the report header.
  • PA_TASKS – task number and name for task-level cost and revenue calculations.
  • PA_PERIODS – period name and date ranges used to derive the reporting period.
  • PA_BUDGET_TYPES – budget type codes and names for cost and revenue budgets (COST_BGT_CODE, REV_BGT_CODE).
  • PA_IMPLEMENTATIONS – installation-level configuration and the operating unit/org context.

Usage Notes

The package is invoked indirectly through the concurrent program that runs the XML Publisher report definition; users submit the program from the Project Management or Projects responsibility rather than calling the package directly. The report parameters map to the package globals PROJ, TASK, TASK_MGR, TASK_ORG, PA_PERIOD, COST_BGT_CODE, REV_BGT_CODE, and the debug and rule optimizer flags. The package is referenced by no other PL/SQL packages, so it should be treated as an end-point report driver. In custom diagnostics or debugging, C_SUM_RPT_TOTALSFORMULA and CHECK_SUM_RPT_TOTALS are useful for verifying whether summary totals were selected and whether the aggregate column logic executed correctly.