Search Results c_person_name_p

Overview

APPS.PAY_PAYRPACT_XMLP_PKG is the generated PL/SQL package body that supports the Oracle Payroll "Payroll Activity" XML Publisher (XMLP) concurrent report. In Oracle EBS 12.1.1 and 12.2.2, XML Publisher reports are built on a BI Publisher data model whose PL/SQL data source is encapsulated in a package generated by the XML Publisher report definition. This package follows the standard XMLP generated-package pattern: it exposes report-level trigger functions (BEFOREREPORT, BETWEENPAGE, AFTERREPORT) plus a set of getter functions that surface global (package-level) variables to the report template. Its business purpose is to resolve payroll activity reporting parameters — specifically the business group and person context — into display-ready values used in the report header and layout.

The header comment ($Header: PAYRPACTB.pls 120.0 2008/01/11) indicates the file is a generated artifact whose version history is maintained by the XML Publisher design-time generator, not hand-coded business logic. The package owner is APPS, and its API classification in ETRM is OTHER, consistent with a report-support package rather than a public application programming interface.

Key Procedures and Functions

• BEFOREREPORT — The before-report trigger fired once when the report begins execution. It initializes report globals: it calls HR_REPORTS.GET_BUSINESS_GROUP to populate C_BUSINESS_GROUP_NAME from the P_BUSINESS_GROUP_ID parameter, and, when P_PERSON_ID is not null, calls HR_REPORTS.GET_PERSON_NAME using P_SESSION_DATE and P_PERSON_ID to populate C_PERSON_NAME. Returns TRUE on success.
• BETWEENPAGE — The between-page trigger. In this package it is a pass-through stub returning TRUE, provided for XML Publisher template compliance.
• AFTERREPORT — The after-report trigger, likewise a stub returning TRUE.
• C_BUSINESS_GROUP_NAME_P — Getter returning the C_BUSINESS_GROUP_NAME global for use by the report layout.
• C_REPORT_SUBTITLE_P — Getter returning the C_REPORT_SUBTITLE global. This is the function associated with the user's search term c_report_subtitle_p; it exposes the report subtitle text to the XML template.
• C_PERSON_NAME_P — Getter returning the C_PERSON_NAME global resolved during BEFOREREPORT.
• GET_BUSINESS_GROUP — Wrapper that delegates to HR_REPORTS.GET_BUSINESS_GROUP and returns the business group name as VARCHAR2.
• GET_PERSON_NAME — Wrapper that delegates to HR_REPORTS.GET_PERSON_NAME (session date, person ID) and returns the formatted person name as VARCHAR2.

Tables Accessed

The documented metadata lists no direct table references via APPS synonyms. All data retrieval is delegated to the HR_REPORTS utility package, which internally reads HR business group and person master data (for example PER_BUSINESS_GROUPS and PER_ALL_PEOPLE_F) to resolve the names surfaced by this package. Because the package performs no direct SQL, it carries no direct table privileges of its own beyond those inherited through HR_REPORTS.

Usage Notes

This package is invoked exclusively by the XML Publisher runtime engine when the Payroll Activity concurrent program executes: the engine calls BEFOREREPORT at report start, BETWEENPAGE between pages, and AFTERREPORT at completion, and the report layout calls the C_*_P getter functions to render header and subtitle values. The package is not referenced by any other package (ETRM records zero referencing packages) and is not intended for direct invocation from forms or custom code. Customizations should be applied to the XML Publisher report definition and its template rather than to this generated body, since regeneration overwrites it. In 12.2.2 the same behavior applies, with the concurrently generated package deployed under the APPS schema alongside other PAY_*_XMLP_PKG report support packages.