Search Results per_persaipe_xmlp_pkg




Overview
Explore in AI Chat

Overview

The APPS.PER_PERSAIPE_XMLP_PKG package body is the generated PL/SQL implementation behind the Oracle EBS concurrent program whose short name is PER_PERSAIPE. In Oracle E-Business Suite 12.1.1 and 12.2.2, XML Publisher (BI Publisher) concurrent programs follow a consistent pattern: a report definition is registered via FND_CONCURRENT_PROGRAMS, and a wrapper package of the form <PROGRAM>_XMLP_PKG supplies the PL/SQL logic that gathers data, formats template values, and returns XML to the XML Publisher engine. This package is the "Human Resources Legislative/Organization Structure" style report associated with the PER (Human Resources) product and is compiled and stored in the APPS schema in VALID status.

The object is classified in the ETRM metadata as having an API classification of OTHER, meaning it is not a public, supported extension API. It exists primarily to service its associated report and is not intended for direct invocation by customer code.

Key Procedures and Functions

The documented package exposes fourteen procedures and functions, which conform to the standard XML Publisher report package idiom:

  • BEFOREREPORT — The standard "before report" trigger that initializes session and report-level context (for example, global variables and currency format settings) prior to report execution.
  • AFTERREPORT — The standard "after report" trigger that performs cleanup once report processing completes.
  • AFTERPFORM — The "after parameter form" trigger, executed after the concurrent program parameter form is submitted; typically used to derive or default parameter values.
  • P_BUSINESS_GROUP_IDVALIDTRIGGE — The parameter validation trigger for the Business Group ID parameter, enforcing that the supplied operating unit / business group is valid.
  • CF_BUSINESS_GROUPFORMULA — A column/format formula that resolves the Business Group value for the report output.
  • CF_LEGISLATION_CODEFORMULA — A formula returning the applicable legislation code.
  • CF_CURRENCY_FORMAT_MASKFORMULA — A formula returning the currency format mask used to render monetary values.
  • SET_CURRENCY_FORMAT_MASK — A helper procedure that determines and sets the currency format mask for the report session.
  • CF_1FORMULA — A generic column formula used to compute a derived report field.
  • CF_ORGFORMULA — A formula resolving organization name/details for display.
  • CF_DURATION_UNITSFORMULA — A formula that returns the duration units value (for example, days, months) used in the report.
  • CP_1_P — The main data-fetching procedure that drives the query and populates the XML output for the report.
  • CF_VERSIONFORMULA — A formula resolving the organization structure version.
  • CF_HIERARCHYFORMULA — A formula resolving the hierarchy name associated with the organization structure.

Tables Accessed

The package reads from the standard HR organization model and supporting lookups, via APPS synonyms:

It additionally depends on the standard utility packages FND_CURRENCY, FND_DATE, FND_GLOBAL, and HR_REPORTS, and on HR_LOOKUPS for lookup validation.

Usage Notes

This package is invoked indirectly by the XML Publisher / BI Publisher concurrent program registration, not by application forms or by customer-authored PL/SQL. The report runtime executes BEFOREREPORT, the parameter validation trigger, the CP_1_P data fetch, and AFTERREPORT in the standard sequence, while the CF_*FORMULA functions supply token values to the RTF template. Because the ETRM metadata records that this package is referenced by zero other database objects, it is a leaf dependency: modifications to the underlying HR organization tables can affect the report, but no other code depends on this package. It should be treated as report infrastructure, not as a supported API, and any customization should be performed through the concurrent program's template or a copy of the report rather than by editing the generated package body.