Search Results pay_paykrspl_xmlp_pkg




Overview
Explore in AI Chat

Overview

APPS.PAY_PAYKRSPL_XMLP_PKG is the generated PL/SQL package body that supports the Oracle Payroll "Salary and Progression" report, an XML Publisher (BI Publisher) concurrent program used by payroll and human resources administrators to analyze salary progression, average salary, and separation pay across a payroll or establishment. The package is declared with AUTHID CURRENT_USER, meaning that when it executes, all unqualified references to database objects are resolved in the schema of the invoking user rather than the package owner, a standard convention for Oracle EBS XML Publisher report packages that rely on APPS synonyms.

The package holds global report state variables such as P_BUSINESS_GROUP_ID, P_CONC_REQUEST_ID, P_SELECTION_DATE, P_SORT_BY, P_SELECTION_VALUE (defaulting to 'COST_CENTER'), P_PAYROLL_ID, and P_ESTABLISHMENT_ID, together with running counters (frame_counter, total, assignment_id) and a currency unit holder (CP_Unit). These variables are populated from the concurrent program's parameter form and consumed by the XML Publisher data template and layout.

Key Procedures and Functions

The package exposes fifteen documented program units that fall into three groups.

  • Report lifecycle: BeforeReport performs initialization prior to data retrieval, and AfterReport handles cleanup after the report completes.
  • Formatting and calculation formulas: CF_business_groupFormula and CF_legislation_codeFormula resolve the business group and legislation context. CF_PERIOD_NAMEFormula derives the reporting period name, while CF_DATE_FORMAT_MASKFormula supplies the date format mask. cf_currency_format_maskformula returns the currency format mask, supported by set_currency_format_mask, and CP_Unit_p returns the currency unit string.
  • Aggregation and payroll-specific logic: cf_average_salaryformula combines average salary, year-beginning, and other components into a single figure. cf_page_totalformula accumulates page-level totals, cf_separation_payformula computes separation pay against a liability rate, and cf_format_working_periodformul formats the working period using the proportion and assignment identifier supplied to it. BetweenPage handles page-break logic between report frames, and P_BUSINESS_GROUP_IDValidTrigge validates the business group parameter.

Tables Accessed

All tables are referenced through APPS synonyms. FND_CURRENCIES supplies currency definitions used by the currency format mask and unit formulas. HR_ALL_ORGANIZATION_UNITS and HR_ORGANIZATION_INFORMATION provide organization and establishment detail, notably for the cost center selection value. PER_TIME_PERIODS provides payroll period definitions that underpin the working period and period name formulas.

Usage Notes

This package is not a public API and is not referenced by any other package. It is invoked indirectly when the associated XML Publisher concurrent program runs in Oracle EBS 12.1.1 or 12.2.2. The report server calls BeforeReport, executes the report query, evaluates the CF_* formulas during layout generation, and finally calls AfterReport. Customizations should be confined to the underlying report definition (data template, RTF layout, or the source PLS file PAYKRSPLS.pls) rather than direct calls to this generated package.