Results for “get_rpt_budget_type”

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

Overview

PA_RPT_UTILS is a reporting utility package in the Oracle Projects (PA) module of Oracle E-Business Suite. Its name reflects its role as a shared support library for Oracle Projects reporting and analytics. The package was originally authored to support Oracle Discoverer-based reporting, as evidenced by the inclusion of the DISCOVERER_INIT procedure and the package header comment dated 1999. In EBS 12.1.1 and 12.2.2, the package remains classified as an OTHER API under the APPS schema and continues to provide reusable helper routines consumed by Oracle Projects reports, listing facilities, and reporting integrations.

The package exposes three published global variables used to cache class category and role type context: Class_Category1/2/3, Role_Type1/2/3, along with cost and revenue budget type codes, an Unassigned_txt placeholder, and PA_Start_Date / PA_End_Date date range holders. These seed the reporting context before the functional routines are invoked. The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the calling user rather than its owner, which is typical for APPS-schema utility code that must respect the security context of the invoking responsibility.

Key Procedures and Functions

• DISCOVERER_INIT — A procedure that populates the PA_PROJ_RPT_ATTRIBS_TEMP table. It reads profile options for the current responsibility and derives the reporting attributes used by Discoverer-based or listing-style reports. It is the initialization entry point for reporting sessions.
• PROJECT_RPT_CLASS — A function returning the class code assigned to a project for a supplied class category. It abstracts the lookup against project classification data so that reports do not need to embed join logic.
• PROJECT_RPT_KEYMEMBER — A function returning the key member assigned to a project for a given project role type. This supports key member listings and staffed-role reporting.
• GET_RPT_CLASS_CATEGORY — A function that returns class category reporting information. Used to drive class-category based report groupings and filters.
• GET_RPT_ROLE_TYPE — A function returning report role type metadata, allowing report-driven role filtering without hardcoding role types.
• GET_RPT_BUDGET_TYPE — A function returning report budget type metadata, supporting budget-type based reporting criteria.

Tables Accessed

The package reads from several core Oracle Projects tables via APPS synonyms. PA_CLASS_CATEGORIES supplies the defined class category values used in reporting; PA_PROJECT_CLASSES and PA_CLASS_CODES resolve the classification assigned to each project. PA_BUDGET_TYPES provides the budget type codes cached in the global variables. PA_PERIODS supports reporting date ranges. The package writes to PA_PROJ_RPT_ATTRIBS_TEMP, a temporary staging table populated by DISCOVERER_INIT.

Usage Notes

PA_RPT_UTILS is not a transactional API and should not be invoked as part of project or budget maintenance transactions. It is designed for read-side reporting scenarios. Typical invocation occurs from Oracle Projects reporting flows, custom Discoverer worksheets, and concurrent programs that need consistent, pre-resolved project classification, role, and budget type values. The package is referenced by at least six other packages, so changes should be treated as having a potentially wide blast radius. Custom code calling these routines should set responsibility context first, since DISCOVERER_INIT depends on profile options evaluated at the responsibility level, and the AUTHID CURRENT_USER clause ensures execution under the caller's privilege set.