Search Results pay_payrpvpr_xmlp_pkg




Overview
Explore in AI Chat

Overview

PAY_PAYRPVPR_XMLP_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema. It supports the Oracle Payroll concurrent program and its associated XML Publisher (BI Publisher) report definition known internally as PAYRPVPR. In EBS 12.1.1 and 12.2.2, packages ending with the suffix _XMLP_PKG are generated to wrap the report logic, bind parameters, and output substitutions consumed by the XML Publisher template engine. This package therefore acts as the runtime container for the report's global variables, its lexical or bind parameters, and the report triggers that execute before and after the report is rendered.

The report itself addresses payroll payment reporting, drawing on payroll, consolidation set, tax unit, and business group context. It is designed to run within the context of a specific business group and reporting period, allowing payroll administrators to produce payment-related output tied to the consolidation set and payroll identifiers they submit at runtime.

Key Procedures and Functions

The package is declared AUTHID CURRENT_USER and exposes the following documented program units:

  • BEFOREREPORT — Report-level trigger executed prior to data retrieval; typically used to initialize session and contextual values.
  • AFTERPFORM — Trigger invoked after the report parameter form is processed, used to adjust or validate parameter state before the main query runs.
  • AFTERREPORT — Trigger executed after report output is generated, generally used for cleanup or final formatting.
  • C_PAYMENT_TYPEFORMULA — Formula function that derives or formats the payment type value for the report output.
  • P_UK_USFormula — Formula function used to determine the UK/US legislative context flag (P_UK_US), influencing localization-specific behavior.
  • C_BUSINESS_GROUP_NAME_P — Accessor returning the cached business group name.
  • C_PAYROLL_NAME_P — Accessor returning the cached payroll name.
  • C_CONSOLIDATION_SET_NAME_P — Accessor returning the cached consolidation set name.
  • C_GRE_NAME_P — Accessor returning the cached GRE (Group Reporting Entity / Government Reporting Entity) name. This is the object the user searched for as "c_gre_name_p".
  • C_SESSION_DATE_P — Accessor returning the cached session date used in the report.

Tables Accessed

The documented table reference is PAY_CONSOLIDATION_SETS, accessed through its APPS synonym. This table supplies consolidation set definition data, which the report uses to resolve and display the consolidation set name (C_CONSOLIDATION_SET_NAME) associated with the submitted consolidation set identifier. The package inputs P_CONSOLIDATION_SET_ID, P_PAYROLL_ID, P_TAX_UNIT_ID, and P_BUSINESS_GROUP_ID are used to scope that retrieval.

Usage Notes

PAY_PAYRPVPR_XMLP_PKG is not intended for direct invocation by application code. It is referenced by zero other packages per ETRM metadata, confirming it is a leaf-level report container rather than a shared API. It is invoked by the Oracle Payroll concurrent manager when the associated XML Publisher report is submitted, and by Oracle Forms-based report submission flows that pass the lexical parameters (business group, start and end dates, payroll, consolidation set, tax unit, and payment type) defined as package globals.

Because the package is marked AUTHID CURRENT_USER, execution honors the privileges of the invoking user, and callers must possess the necessary grants on the underlying PAY synonym objects. Modifications to this package are not supported; it is regenerated whenever the report definition is modified. Customization should be confined to the XML Publisher template or to a cloned report, not to the package body itself.