Search Results c_person_name

Overview

APPS.PER_PERUSCNE_XMLP_PKG is the generated PL/SQL package body that supports the Oracle E-Business Suite concurrent program "US Citizen/Non-Citizen Report" (PERUSCNE), a HRMS report that produces a listing of employees classified by citizenship status. In EBS 12.1.1 and 12.2.2 the report is registered against an Oracle Reports (XML Publisher-enabled) definition, and the ETRM metadata classifies this object as API classification OTHER. The package body is created automatically by Oracle Reports at report definition generation time and mirrors the data model and formula columns of the underlying .rdf file.

Rather than implementing business logic of its own, the package exposes the report's PL/SQL placeholders — user-entered parameters and derived formula columns — as callable PL/SQL functions, and provides the BeforeReport and AfterReport triggers used by the Reports runtime to initialize and clean up report state. The package is a thin orchestration layer that delegates all meaningful HRMS logic to shared libraries such as HR_REPORTS and HR_STANDARD.

Key Procedures and Functions

• BeforeReport — Executes when the Reports runtime fires the Before Report trigger, prior to any query execution. Its documented behavior is to populate the report-level global LP_SESSION_DATE from the P_SESSION_DATE parameter and, critically, to derive C_PERSON_NAME by calling HR_REPORTS.GET_PERSON_NAME with the session date and person ID. This is the resolution point for the search term "c_person_name": the placeholder is not a user parameter but a computed value, resolved once per report run.
• AfterReport — Fires after all report output has been produced. In the documented source it contains no functional statements other than an optional HR_STANDARD event call that is commented out, and returns TRUE. It exists to satisfy the Reports trigger interface.
• C_BUSINESS_GROUP_NAME_P — Placeholder accessor that returns the C_BUSINESS_GROUP_NAME value, allowing the business group name to be referenced from report layout or formulas.
• C_REPORT_SUBTITLE_P — Placeholder accessor that returns the C_REPORT_SUBTITLE value used for the report heading or subtitle line.
• C_PERSON_NAME_P — Placeholder accessor that returns the C_PERSON_NAME formula column/document parameter, i.e. the person name resolved in BeforeReport.

No parameter lists are documented for these functions; callers should treat them as Reports runtime hooks and zero-argument accessors.

Tables Accessed

The ETRM metadata lists no directly referenced tables for this package; all database access for the report is performed by the Oracle Reports queries and by the HRMS APIs it calls. When BeforeReport invokes HR_REPORTS.GET_PERSON_NAME, the read of the person record is performed inside that HRMS library — typically resolving the person's display name via the standard person/assignment business group view with effective-dating restricted to the supplied session date. Similarly, the C_BUSINESS_GROUP_NAME and C_REPORT_SUBTITLE values originate from parameters or from HRMS business group data resolved by the report query rather than by this package body.

Usage Notes

This package is invoked exclusively by the Oracle Reports runtime when the PERUSCNE concurrent program is executed from the Submit Requests form or via the standard concurrent manager. It is not a supported public API and is not referenced by any other documented package. Developers should not call it directly from forms, workflows, or custom PL/SQL; the supported integration point is the concurrent program definition itself.

Because the header comment indicates a 2008 file revision (PERUSCNEB.pls 120.1), the package body is stable across 12.1.1 and 12.2.2 and should be regenerated only by recompiling the corresponding report definition. Customizations should be applied to a copy of the report rather than to APPS.PER_PERUSCNE_XMLP_PKG, since any patch or online patching cycle in 12.2.2 may regenerate the shipped object.