Search Results per_peruscpe_xmlp_pkg

Overview

APPS.PER_PERUSCPE_XMLP_PKG is the generated PL/SQL package body that backs the Oracle HRMS report commonly known as the US Compliance report (PERUSCPE), an XML Publisher-based concurrent program. The package follows the standard Oracle Reports/XML Publisher server-side pattern in which the report's user-entered parameters are exposed as package variables and the report event triggers are implemented as PL/SQL functions. Its primary business purpose is to resolve and format the descriptive values that appear on the printed compliance output: the business group name, the employee name, the session date, and the qualifying date. Together these values personalize and contextualize the report for the legislative and regulatory requirements applicable to a US business group.

Key Procedures and Functions

• BeforeReport — The principal event function. It executes once, prior to the report's data query, and is responsible for populating the package-level placeholder variables used throughout the report layout. It derives the business group name from the entered business group identifier, assigns that value to both the business group and organization name variables, resolves the employee name from the session date and person identifier, and formats the qualifying date when one is supplied, otherwise substituting an empty string.
• AfterReport — The closing event function. It performs no substantive processing other than returning success, and is present to complete the standard report lifecycle contract.
• C_LETTER_DATE_P — An accessor function returning the letter date placeholder value to the report runtime.
• C_BUSINESS_GROUP_NAME_P — An accessor function returning the resolved business group name. This is the function most directly associated with the user's search term c_business_group_name; it exposes the package variable of the same name to the report definition.
• C_EMPLOYEE_NAME_P — An accessor function returning the resolved employee name.
• C_QUALIFYING_DATE_P — An accessor function returning the formatted qualifying date string.

No parameter lists are documented for these entry points. The accessor functions follow the fixed no-argument convention required by Oracle report placeholder resolution.

Tables Accessed

No direct table references are documented for this package. All data retrieval is delegated to the HRMS reporting utility package HR_REPORTS, specifically the get_business_group and get_person_name utility calls used in BeforeReport. Those utilities internally resolve the business group and person records from the HRMS base tables against the session context, so the package itself contains no embedded SQL and no direct read or write of application tables. This design keeps the report definition independent of the underlying HRMS schema.

Usage Notes

The package is not intended for direct invocation. It is generated and maintained by Oracle and is called by the report server during execution of the PERUSCPE concurrent program. The header comment indicates a source revision dated December 2007, consistent with the R12-era HRMS reporting layer.

Custom code should not call these procedures or access the package variables directly; the supported integration point is the concurrent program and its parameter set, including the business group and person identifiers. Because the business group name is resolved through HR_REPORTS at report runtime, any customization affecting business group naming should be applied at the HR organization level rather than by modifying this package. The ETRM metadata records no dependent packages referencing PER_PERUSCPE_XMLP_PKG, confirming its role as a terminal, report-specific artifact.