Search Results p_sort_tag




Overview
Explore in AI Chat

Overview

APPS.PER_PERCACEI_XMLP_PKG is the packaged body that supports the Oracle EBS concurrent program "Report on Hirings" (internal short name PERCACEI). It belongs to the Oracle Human Resources / Payroll family of reports, and its primary business role is to produce a listing of employee hirings that can be filtered, limited and sorted by a set of user-supplied parameters. In Oracle EBS 12.1.1 and 12.2.2 this report is normally registered as an XML Publisher (BI Publisher) concurrent program, in which case the PL/SQL package is responsible only for the data selection and for passing the query, sort ordering and parameter values to the XML template through the standard report triggers. The package header file reference (PERCACEIB.pls, version 120.0) confirms that it is an Oracle-supplied, non-customized component maintained under the APPS schema.

Key Procedures and Functions

The ETRM metadata documents eight procedures and functions within the package body, several of which are the standard Oracle Reports and XML Publisher entry points:

  • AFTERPFORM — Executed after the parameter form is accepted. Among other tasks it initializes the sort handling variables (P_SORT_COUNT, COL1, COL2 and P_SORT_TAG) and also writes an FND_SESSIONS row keyed to the current session and the ending hire date parameter.
  • BEFOREREPORT — Fires before the report is generated. It sets the report title (CP_REPORT_TITLE), resolves the consolidation set name from PAY_CONSOLIDATION_SETS, and resolves the payroll name from PAY_PAYROLLS_F when the corresponding parameters are supplied.
  • BEFOREPFORM — Executed before the parameter form is displayed, typically used to initialize or validate parameter defaults.
  • AFTERREPORT — Runs once report generation is complete, used for any post-processing or cleanup activity.
  • CP_REPORT_TITLE_P — Accessor function returning the CP_REPORT_TITLE value used as the report heading.
  • CP_CONSOLIDATION_P — Accessor function returning the resolved consolidation set name (CP_CONSOLIDATION) for the report.
  • CP_PAYROLL_NAME_P — Accessor function returning the resolved payroll name (CP_PAYROLL_NAME).
  • CP_GRE_P — Accessor function exposing a package-level report variable to the XML template.

Tables Accessed

Two tables are documented as referenced through APPS synonyms. FND_SESSIONS is written to (and checked for an existing row) inside AFTERPFORM, so that the report session is associated with the effective date range of the request — this is a common technique for ensuring the correct date-effective payroll/HR data is returned. PAY_CONSOLIDATION_SETS is queried in BEFOREREPORT to translate the consolidation set identifier parameter into the consolidation set name displayed on the report; the same trigger also queries PAY_PAYROLLS_F for the payroll name.

Usage Notes

PER_PERCACEI_XMLP_PKG is not an application programming interface in the ordinary sense; ETRM classifies it as OTHER, and it is referenced by zero other packages. It is invoked indirectly whenever the "Report on Hirings" concurrent program is submitted from the Oracle HRMS/Payroll responsibility. The parameter form collects the payroll, consolidation set, tax unit and sorting options; the sort parameters (P_SORT1 and P_SORT2) accept values such as Social Insurance Number, Employee ID and Hire Date, and the package translates these into numeric column positions held in P_SORT_TAG, which the query builder then uses in its ORDER BY clause. From a user or developer perspective the relevant search term "p_sort_tag" therefore refers to the internal package variable that carries the final SQL ORDER BY fragment. Because the package is Oracle-supplied, it should not be modified; custom sort requirements are better met by copying the concurrent program definition and extending it in a custom schema.