Search Results per_peruscne_xmlp_pkg

Overview

APPS.PER_PERUSCNE_XMLP_PKG is a server-side PL/SQL package that supports the Oracle E-Business Suite concurrent program PERUSCNE, the "Person US Citizen" report. The package forms part of the Oracle HRMS (Human Resources) reporting layer and provides the formatting and parameter-handling logic consumed by the report's XML Publisher (BI Publisher) template. Its declaration section defines the bind parameters and global variables that the underlying report query and its layout template share at runtime.

The package is registered under the APPS schema with an API classification of OTHER, meaning it is not an exposed business API but rather a generated report-support package. In EBS 12.1.1 and 12.2.2 it is shipped in the same form; the source header indicates an original build revision (120.0, dated 2007) that predates both releases and has remained stable.

Key Procedures and Functions

The documented package exposes a small, tightly scoped set of entry points, all of which are either report lifecycle hooks or accessor functions for report-level global variables resolved at runtime.

• BEFOREREPORT — A report trigger function invoked before the report query executes. It is used to initialize package state and to populate the derived globals listed below.
• AFTERREPORT — The complementary trigger invoked after report execution completes. It performs end-of-run cleanup and resets package globals so that subsequent invocations from the same database session do not inherit stale values.
• C_BUSINESS_GROUP_NAME_P — Accessor function returning the business group name global (C_BUSINESS_GROUP_NAME), used by the report layout to print the operating business group on the output.
• C_REPORT_SUBTITLE_P — Accessor function returning the report subtitle global (C_REPORT_SUBTITLE). This is the object most frequently located through searches for c_report_subtitle.
• C_PERSON_NAME_P — Accessor function returning the person name global (C_PERSON_NAME), used to display the individual whose citizenship record is being reported.

The accessors exist because Oracle Reports and XML Publisher templates cannot reference package variables directly; they must call a function that returns the value. All three follow the same naming convention, appending the suffix _P to the corresponding global.

Tables Accessed

The ETRM metadata records no directly referenced tables for this package. This is expected: the package is a report-support shell whose business logic is largely contained in the report definition and in the SQL executed by the concurrent program. Data such as the business group name and person name is derived from HRMS base entities (notably PER_BUSINESS_GROUPS and PER_PEOPLE_F) by the report query, with the resulting scalar values stored into the package globals rather than queried directly inside the package body.

Usage Notes

PER_PERUSCNE_XMLP_PKG is not intended for direct invocation from forms or custom code. It is bound to the PERUSCNE concurrent program and is called implicitly by the Oracle Reports runtime when that program is submitted from the Submit Requests window or from the concurrent manager. Custom PL/SQL should treat the package as read-only and should never assign to its globals, since doing so would corrupt the state expected by the XML Publisher template.

The c_report_subtitle global is populated during BEFOREREPORT and remains valid only for the duration of a single report run. Any dependency on that value outside the report lifecycle is unsupported. Because no other documented packages reference this package, its footprint is confined to the PERUSCNE report itself.