Search Results per_perrprbd_xmlp_pkg




Overview
Explore in AI Chat

Overview

APPS.PER_PERRPRBD_XMLP_PKG is a PL/SQL package that serves as the report logic container for the Oracle EBS "Budget and Position Report" (or Period-to-Date Budget Report) executed through the Oracle XML Publisher (BI Publisher) reporting engine. In the Oracle E-Business Suite 12.1.1 and 12.2.2 architectures, concurrent programs based on Oracle Reports are frequently converted to XML Publisher templates. When such a report is registered, Oracle generates a wrapper package whose name follows the pattern <REPORT_NAME>_XMLP_PKG. This package encapsulates the report's procedural logic—parameter defaulting, data retrieval, formula columns, and formatting—while the presentation layer is handled separately by an RTF or similar template.

This package holds a status of VALID and is owned by the APPS schema. Its API classification is OTHER, indicating it is not an exposed public API but rather an internal implementation support object. The package body contains the executable logic, while the specification exposes the callable entry points used by the XML Publisher runtime during concurrent program execution.

Key Procedures and Functions

The package documents eighteen procedures and functions. The lifecycle procedures BEFOREREPORT and AFTERREPORT bracket report execution: BEFOREREPORT initializes session context and parameter values prior to data extraction, while AFTERREPORT performs cleanup and post-processing.

The C_* members are report formula (column) functions that compute derived display values. C_START_VALUEFORMULA, C_END_VALUE_P, C_AMOUNT_P, and C_PERCENTAGE_P produce the start value, end value, monetary amount, and percentage columns of the report output. Descriptive formula functions include C_BUSINESS_GROUP_NAME_P, C_REPORT_SUBTITLE_P, C_BUDGET_NAME_P, C_BUDGET_VERSION_P, C_START_PERIOD_NAME_P, C_END_PERIOD_NAME_P, and C_UNIT_P, which supply the business group name, report subtitle, budget identifiers, period names, and unit of measure for display.

The remaining members are lookup functions that resolve surrogate identifiers from user-entered parameters: GET_BUDGET, GET_BUDGET_VERSION, GET_TIME_PERIOD, GET_BUSINESS_GROUP, and GET_ACTUALS. These translate parameter values into the key values required to query the underlying data.

Tables Accessed

The package references PER_BUDGETS, the base table that stores budget definitions within the Oracle Human Resources (PER) schema. The budget lookup functions and the budget-name formula functions query this table to resolve and display budget context. All access is performed through APPS synonyms, consistent with standard EBS naming and security conventions. The dependency listing also shows a reference to SYS.STANDARD, reflecting the use of standard PL/SQL built-in types.

Usage Notes

This package is invoked automatically by the XML Publisher concurrent program framework when the associated Budget/Position Report is submitted from the Submit Requests form or through the concurrent manager. It is not intended for direct invocation by custom code. Because the package is regenerated whenever the report definition is modified through the XML Publisher administrator interface, customizations should not be applied directly to the package body; they will be overwritten. The package is referenced by zero other packages, confirming its role as a leaf-level report implementation object. Administrators troubleshooting the report should verify that the package compiles cleanly and that the corresponding data template and concurrent program definition remain synchronized.