Search Results fetch_business_group_name

Overview

The PL/SQL package body APPS.SSP_SSPRPWKS_XMLP_PKG is the database-side companion to an Oracle BI Publisher (XML Publisher) report definition used within Oracle E-Business Suite. Its identifier indicates a payroll worksheet report belonging to the SSP (Self-Service Payroll / HRMS) product family, with the suffix _XMLP_PKG denoting that the package is generated to supply report-level data, parameters, and derived values to an associated XML Publisher report template. The package is owned by the APPS schema and is classified as "OTHER" in the ETRM registry, meaning it is not a public or formally versioned API but an internal report component.

Its primary business function is to resolve descriptive reference data — specifically the payroll name and business group name — that the payroll worksheet report must display as header or subtitle information. Because report templates cannot directly join reference tables, this package performs that lookup in PL/SQL and exposes the results through return functions that the report layout references as placeholders. The package also assembles dynamic report parameters, such as the payroll identifier clause and session date, before the report is rendered.

Key Procedures and Functions

• BEFOREREPORT — A function returning a boolean that executes prior to report rendering. It serves as the main initialization hook, invoking the payroll and business group retrieval routines, building the payroll ID filter clause (L_PAYROLL_ID), initializing the date format handler, and capturing the session date. It returns TRUE to allow the report to proceed.
• AFTERREPORT — A function returning a boolean that executes after report completion, reserved for cleanup or termination logic. In this package it performs no substantive operation and returns TRUE.
• FETCH_PAYROLL_NAME — A procedure that opens an explicit cursor over PAY_PAYROLLS_X, fetches the payroll name for the payroll identifier supplied by the report parameter, and stores it in the package global C_PAYROLL_NAME. This is the routine associated with the user's search term and represents the common customization point for resolving a payroll description.
• FETCH_BUSINESS_GROUP_NAME — A procedure that populates the global C_BUSINESS_GROUP_NAME by calling hr_reports.get_business_group with the business group parameter.
• C_BUSINESS_GROUP_NAME_P, C_REPORT_SUBTITLE_P, C_PAYROLL_NAME_P — Accessor functions that return the value of their corresponding package-level variables to the report template. They allow the XML Publisher layout to bind directly to these placeholders.

Tables Accessed

The package reads from PAY_PAYROLLS_X via its APPS synonym, selecting the PAYROLL_NAME column filtered by PAYROLL_ID. This table is the payroll definition entity in the Oracle Payroll data model; the lookup is required so the report can print the human-readable payroll name rather than the numeric identifier. No insert, update, or delete operations are documented, consistent with the package's read-only reporting role.

Usage Notes

This package is invoked automatically by the Oracle Reports/BI Publisher runtime when the associated payroll worksheet report is executed, either as a concurrent program submission or through a self-service payroll page. It is not intended for direct invocation from custom forms or external code, and the ETRM metadata records no other packages referencing it. Because the header comment references a "DT Fix" and the body contains commented-out legacy calls replaced by local routines, the package reflects a patched revision rather than the original generated form. Implementers extending the report should confine changes to the placeholder functions or the fetch procedures to preserve the expected report contract.