Search Results c_payroll_name_p

Overview

SSP_SSPRPWKS_XMLP_PKG is an Oracle Application Object Library package owned by APPS that supports the Payroll Workbench XML Publisher report (SSPRPWKS) in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It functions as the report-level PL/SQL package generated through the XML Publisher (BI Publisher) concurrent program architecture, where the data model and report logic are anchored to a wrapper package that supplies run-time parameters and derived column values to the report template.

The package address the reporting needs of the Payroll Workbench, exposing the payroll context and business group context required by the report layout. It belongs to the SSP (Payroll) product family and is classified as OTHER in the ETRM metadata, indicating it is not part of the public PL/SQL API surface but rather an internal report helper package. The package name and stored header indicate it was last revised in 2007 under version 120.1, and it predates the extensive DT (data transformation) fixes noted within its body.

Key Procedures and Functions

• BEFOREREPORT — The standard XML Publisher before-report trigger. Invoked once prior to report execution to initialize session and parameter state, typically derived from the concurrent request context such as business group and session date.
• AFTERREPORT — The standard XML Publisher after-report trigger. Invoked once after report generation completes, used for cleanup or post-processing activities.
• C_BUSINESS_GROUP_NAME_P — Returns the cached business group name used by the report output. It exposes the package variable C_BUSINESS_GROUP_NAME as a function for the report template.
• C_REPORT_SUBTITLE_P — Returns the report subtitle string, exposed via the C_REPORT_SUBTITLE variable for use on the report header.
• C_PAYROLL_NAME_P — Returns the payroll name associated with the report run. This corresponds directly to the search term c_payroll_name_p, which is the function that surfaces the C_PAYROLL_NAME variable to the report data model.
• FETCH_PAYROLL_NAME — Added during the DT Fix, this procedure performs the lookup that populates the payroll name variable used by C_PAYROLL_NAME_P.
• FETCH_BUSINESS_GROUP_NAME — Also added during the DT Fix, this procedure resolves the business group name and stores it in the C_BUSINESS_GROUP_NAME variable.

Tables Accessed

The ETRM metadata documents no direct table references for this package. As a report-level wrapper, it relies on APPS synonyms and calling conventions rather than declaring direct DML against base tables. The FETCH_PAYROLL_NAME and FETCH_BUSINESS_GROUP_NAME procedures imply lookups against payroll and business group definition entities (for example, PAY_PAYROLLS_F and HR_OPERATING_UNITS) to translate numeric identifiers such as P_PAYROLL and P_BUSINESS_GROUP_ID into displayable names, but the metadata does not enumerate these explicitly.

Usage Notes

This package is invoked automatically by the XML Publisher concurrent program framework when the SSPRPWKS report executes. It is not intended for direct invocation by custom code, and the ETRM metadata confirms it is referenced by zero other packages. Developers customizing or debugging the Payroll Workbench report output should treat the C_*_P functions as the supported read points for report template columns, particularly C_PAYROLL_NAME_P, while the FETCH_* procedures represent the internal resolution logic added to correct the payroll and business group name values. Because the package is a private report helper, changes should be confined to cloning or extending the report data model rather than altering the package definition directly.