Search Results cf_no_of_annexesformula

Overview

APPS.PQH_PQHEEO5_XMLP_PKG is a PL/SQL package associated with the Oracle E-Business Suite HRMS (Human Resources Management System) reporting infrastructure. Based on its naming convention, the PQH_ prefix identifies it as a component of the Public Sector/HRMS reporting family, while the _XMLP_PKG suffix indicates that it functions as a supporting package for an XML Publisher (BI Publisher) report definition generated through the Oracle Reports-to-XML Publisher migration path. The package is compiled with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user, consistent with standard seeded report packages in the EBS 12.1.1 and 12.2.2 code lines.

The business function of this package is to supply the data retrieval, parameter preparation, and formula-evaluation logic required by a statutory or regulatory HRMS report — most plausibly an annual enrollment or education-related return, given the presence of report-year, enrollment-count, and agency-type parameters. Its source header carries the identifier PQHEEO5S.pls 120.3, dated 2007, indicating it is a long-standing seeded object carried forward unchanged into the 12.2.2 release.

Key Procedures and Functions

The package exposes 94 documented procedures and functions. The principal groups are:

• Report event handlers — BEFOREREPORT, BEFOREPFORM, AFTERPFORM, and AFTERREPORT control report initialization and post-processing logic, consistently returning BOOLEAN and invoked automatically by the XML Publisher engine at defined lifecycle points.
• Formula functions — CF_TOTAL_TITLEFORMULA0005 and CF_NO_OF_ANNEXESFORMULA compute derived report values, accepting an employment-category input and returning a character or numeric result respectively.
• Parameter accessors — CP_REPORT_DATE_P, CP_NO_OF_SCHOOLS_P, CP_FR_P, CP_FT_P, CP_PR_P, and CP_PT_P return the current values of the seeded user parameters (report date, school count, and the part-time/full-time/regular/foreign groupings) to the report layout.
• Lookup and utility helpers — GET_BUSINESS_GROUP_ID, CHK_APPLICATION_ID, CORE_HR_APP_ID, VERTICAL_APP_ID, HRMS_OBJECT, GET_APPLICATION_SHORT_NAME, EFFECTIVE_DATE, START_OF_TIME, and END_OF_TIME resolve security context, date boundaries, and application identifiers.
• Currency functions — PAY_VALUE, MONEY_UNIT, and the overloaded DEFAULT_CURRENCY_CODE return the legislative or business-group currency context — the MONEY_UNIT function is precisely the object referenced by the search term "money_unit" and supplies the monetary unit string used on the report output.
• Validation and assertion — ASSERT_CONDITION and LOCATION_VALID provide defensive checks on report execution prerequisites.

Tables Accessed

The package references three core HRMS tables through APPS synonyms: HR_ALL_ORGANIZATION_UNITS (business group and organization context, including agency identification), PER_ALL_ASSIGNMENTS_F (assignment-level data used to count enrollments and classify full-time/part-time status), and PER_ALL_PEOPLE_F (person-level details for the report population). All three are date-tracked (the _F suffix), and access is governed by the effective-date boundaries returned by EFFECTIVE_DATE, START_OF_TIME, and END_OF_TIME.

Usage Notes

PQH_PQHEEO5_XMLP_PKG is not intended to be called directly from custom code. It is invoked automatically by the XML Publisher runtime when the associated concurrent program or report definition executes, and the metadata confirms it is not referenced by any other package. Its public variables (for example P_REPORT_YEAR, P_BUSINESS_GROUP_ID, P_CONC_REQUEST_ID) are populated by the concurrent manager at submission time and should be treated as read-only by downstream components. Because the package uses AUTHID CURRENT_USER, custom callers — if any — must be granted the necessary object privileges explicitly. The MONEY_UNIT function is the documented entry point for retrieving the currency or monetary unit string applied to the report, and it should be used rather than hard-coding a currency designation in report templates.