Search Results working_period




Overview
Explore in AI Chat

Overview

APPS.PAY_PAYKRSPL_XMLP_PKG is the generated PL/SQL package body that supports the Oracle Payroll report PAYKRSPL, an XML Publisher (BI Publisher) concurrent program. As an XMLP_PKG package, it is produced automatically by Oracle Reports when a report is converted to the XML Publisher publishing model, and it encapsulates the report's data model logic, formula columns, parameter validation, and formatting routines. The package belongs to the APPS schema and is classified as OTHER, meaning it is not a public or supported application programming interface; it is invoked internally by the report execution framework rather than by external code.

The package is tied to the payroll reporting domain, reading business group, legislation, currency, and payroll period information to format report output. It underpins reports concerned with payroll results and working period information, which is the element most directly associated with the supplied search term.

Key Procedures and Functions

Fifteen documented units are exposed. BEFOREREPORT and AFTERREPORT are the standard report lifecycle entry points; BEFOREREPORT performs initialisation, resetting internal counters and defaults and mapping the p_sort_by parameter to a selection value, while AFTERREPORT performs any closing logic. BETWEENPAGE is the standard inter-page trigger.

Tables Accessed

The package reads from four APPS synonyms. FND_CURRENCIES (and its view FND_CURRENCIES_VL) supplies currency codes, names, and issuing territory codes used to build format masks. HR_ALL_ORGANIZATION_UNITS provides the business group organisation name. HR_ORGANIZATION_INFORMATION supplies the legislation code through the Business Group Information context. PER_TIME_PERIODS provides the payroll time period rows from which working period and period name values are derived. All access is read-only reference data retrieval.

Usage Notes

The package is executed implicitly when the associated XML Publisher concurrent program is run. It is not intended for direct invocation by forms, custom concurrent programs, or client code; no other packages reference it. The p_sort_by parameter drives the BeforeReport mapping, allowing the report to be sorted by cost centre, establishment, or grade. Because the package is regenerated whenever the underlying report definition changes, customisations should not be applied to this body; supported extension points should be used instead.