Search Results per_peruscpr_xmlp_pkg

Overview

APPS.PER_PERUSCPR_XMLP_PKG is the generated PL/SQL package body that supports the Oracle E-Business Suite (EBS) HRMS report commonly known as the US COBRA coverage/participation report (internally referenced as PERUSCPR). It is an XML Publisher (XMLP)-style report package typically produced by Oracle Reports/BI Publisher conversion utilities, in which the report's data model is consolidated into a callable PL/SQL package owned by APPS. The package is classified as "OTHER" in the ETRM metadata, indicating it is not a public or supported API but rather a report-support artifact. Its primary role is to compute and hold report-level derived values — organization names, hierarchy structure names, and code-translated values such as the COBRA qualifying event — and expose them through wrapper functions so the report template (RTF/XML) can render them. In EBS 12.1.1 and 12.2.2 the package is distributed with the HRMS/payroll report components and is regenerated during patching.

The user's search term "c_end_of_time_p" corresponds to one of the package's documented functions, C_END_OF_TIME_P. It is a pl/sql wrapper that returns the value of the package variable C_END_OF_TIME, which is initialized in BEFOREREPORT from HR_GENERAL.END_OF_TIME. That constant represents a high date (typically 31-DEC-4712) used as an open-ended effective date when the report assembles date-ranged HR data.

Key Procedures and Functions

• BEFOREREPORT — The main initialization routine, invoked before the report data is fetched. It performs the core derivation logic: sets C_END_OF_TIME from HR_GENERAL.END_OF_TIME; resolves the business group name via HR_REPORTS.GET_BUSINESS_GROUP; if a parent organization ID parameter is supplied, calls HR_REPORTS.GET_ORGANIZATION to populate the parent organization name; if an organization structure version ID is supplied, calls HR_REPORTS.GET_ORGANIZATION_HIERARCHY to populate the hierarchy name and version dates; and translates the qualifying event code through HR_US_REPORTS.GET_COBRA_QUALIFYING_EVENT. It always returns TRUE.
• AFTERREPORT — A no-op post-processing hook that returns TRUE; retained for symmetry with the report lifecycle.
• C_BUSINESS_GROUP_NAME_P — Returns the business group name captured during BEFOREREPORT.
• C_REPORT_SUBTITLE_P — Returns the report subtitle string used in the report header.
• C_PARENT_ORGANIZATION_NAME_P — Returns the resolved parent organization name (empty string when no parent organization ID is passed).
• C_ORG_STRUCTURE_NAME_P — Returns the organization hierarchy (structure) name resolved from the structure version ID.
• C_QUALIFYING_EVENT_P — Returns the translated COBRA qualifying event description.
• C_END_OF_TIME_P — Returns the "end of time" high date value used as an open upper bound in effective-dated queries.

Tables Accessed

The ETRM metadata does not list any directly referenced tables for this package. All data retrieval is delegated to the HRMS reporting helper APIs — HR_GENERAL, HR_REPORTS, and HR_US_REPORTS — which internally read HR foundation tables such as PER_BUSINESS_GROUPS, PER_ORGANIZATION_STRUCTURES, PER_ORG_STRUCTURE_VERSIONS, and the COBRA-related lookup tables. The package itself functions as a value cache for the report rather than as a direct table reader or writer.

Usage Notes

This package is not a public API and is not referenced by any other documented package. It is invoked indirectly by the XML Publisher engine through the report definition: the report's data model calls BEFOREREPORT, the template calls the wrapper functions (..._P) to retrieve derived values, and the engine calls AFTERREPORT on completion. Customizations should be limited to the underlying HRMS helper APIs or the report definition rather than editing the package body, since it is regenerated during EBS patching in 12.1.1 and 12.2.2. For troubleshooting, DBMS_OUTPUT tracing of BEFOREREPORT is commonly used to verify that organization and qualifying event parameters are populated before report execution.