Search Results per_perushrm_xmlp_pkg




Overview
Explore in AI Chat

Overview

APPS.PER_PERUSHRM_XMLP_PKG is a PL/SQL package associated with the Oracle EBS HRMS (Human Resources Management System) reporting infrastructure. Its name follows the standard EBS XML Publisher concurrent program naming convention, in which the _XMLP_PKG suffix identifies a package generated to support a specific XML Publisher report template. In this case the underlying report is the US HRMS multi-state / new-hire reporting concurrent program, internally referenced as PERUSHRM. The package header carries the source control tag PERUSHRMS.pls 120.0 2007/12/28, confirming it has been shipped since the 11i/R12 baseline and is still deployed in both Oracle EBS 12.1.1 and 12.2.2. The package encapsulates the report's public and private state variables — such as P_BUSINESS_GROUP_ID, P_TAX_UNIT_ID, P_REPORT_DATE, P_STATE_CODE, and numerous calculated (C_…) and processing (CP_…) columns — together with the procedural logic that drives report execution, data selection, and formatting.

Key Procedures and Functions

The package exposes 35 documented procedures and functions. Notable entries include:

  • CHAR_SET_INIT — Accepts a character set argument and initializes the session/report environment for the specified NLS character set, ensuring correct rendering of multi-state and new-hire data (for example, national identifiers and names containing non-ASCII characters). This is the object surface referenced by the user's search on "char_set_init".
  • BeforeReport / AfterReport — The standard XML Publisher report entry and exit hooks; BeforeReport prepares global state and AfterReport finalizes output and accepts new-hire totals.
  • BetweenPage — Controls page-break behavior in the XML Publisher output.
  • G_new_hiresGroupFilter — A group filter function that determines which rows of the new-hires data model qualify for output.
  • new_hire_record — Loads a single new-hire row (name, dates, identifiers, GRE location) for output.
  • CF_new_hireFormula — Computes the new-hire result set across federal, state, and SUI/SIT identifiers and location data.
  • Formula functions — c_employee_addressformula, c_salaryformula, CF_GREformula, c_contact_nameformula, c_contact_phoneformula, c_contact_titleformula, and c_tax_unit_addressformula drive calculated columns in the report output.
  • Record procedures — total_record, a01_header_record, a01_total_record, a03_header_record, and gre_record assemble specific report sections.
  • P_MAG_UPDATE_STATUS — Updates the concurrent request processing status for the report run.

Tables Accessed

The package reads through APPS synonyms from the core HRMS tables:

Usage Notes

PER_PERUSHRM_XMLP_PKG is invoked exclusively by the associated Oracle HRMS multi-state/new-hire XML Publisher concurrent program; it is not referenced by any other package (referenced by 0). The CHAR_SET_INIT procedure is typically called early in the report lifecycle — before the data model executes — to align the session character set with the template output, which is essential when national identifiers or names contain non-ASCII characters. Because the package is generated and regenerated by the XML Publisher data definition process, customizations should be confined to the underlying data template and SQL, not to direct edits of the package body. No public API contract is published for this object; it should not be called from custom forms or concurrent programs.