Search Results cf_faculty_totformula




Overview
Explore in AI Chat

Overview

APPS.PQH_PQIPED2_XMLP_PKG is a report-support PL/SQL package in the Oracle E-Business Suite HRMS/Payroll family (PQH application). It belongs to the class of auto-generated "XMLP" packages that Oracle BI/XML Publisher (formerly Oracle Reports) creates to back concurrent report definitions. The suffix _XMLP_PKG indicates the package supplies the PL/SQL package body logic invoked by a report template at run time. The source header records $Header: PQIPED2S.pls 120.1 2007/12/21, confirming that this is a Report-era object that was retained and re-registered for the XML Publisher engine in Release 12.1.1 and 12.2.2.

Functionally the package supports the PQIPED2 report — a "PQIPED" (People/Position Information Detail) style faculty and instructional-staff disclosure report. The presence of faculty aggregates (tenured, on-tenure-track, not-on-tenure-track) and a NonFacInstr counter indicates the report produces a public accountability or institutional-research extract counting faculty and non-faculty instructional staff by organization. The owner is APPS and the ETRM API classification is OTHER, i.e., it is not a callable business API but an internal report artifact.

Key Procedures and Functions

  • BEFOREREPORT — report-level pre-processing hook; performs initialisation and defaulting of the report parameters before the query executes.
  • AFTERREPORT — report-level post-processing hook; final formatting and cleanup after all rows have been produced.
  • LINEFORMULA — computes and returns the report line number used for sequencing output rows.
  • CF_TOTTITLEFORMULA(orgCode) — conditional format returning the title text for a given organization code.
  • CF_DISPNAMEFORMULA(orgCode) — conditional format returning the display name for an organization code.
  • CF_FACULTY_TOTFORMULA(...) — conditional format that sums the tenured, on-tenure-track and not-on-tenure-track faculty counts into a single faculty total.
  • LINE_NUM_P, CP_FR_P, CP_FT_P, CP_PR_P, CP_PT_P, TMP_VAR_P, TMP_VAR1_P, CP_NONFACINSTR_P — accessor functions returning the current values of the package-level globals line_num, CP_FR, CP_FT, CP_PR, CP_PT, tmp_var, tmp_var1 and CP_NonFacInstr. The CP_* globals hold faculty/instructional-staff counts by category, while tmp_var and tmp_var1 are working counters initialised to 28 and 41.

The package consequently documents fourteen callable units: six report/formula functions and eight state accessors.

Tables Accessed

ETRM records no directly referenced base tables for this package. This is consistent with the XMLP report-support pattern: the driving SQL resides in the report data model or in a companion query package, and PQH_PQIPED2_XMLP_PKG only manipulates the resulting values through its group-level formula columns and its package globals. Any table access occurs in the report query itself rather than inside this package.

Usage Notes

The package is invoked indirectly. A concurrent program registered in the HRMS/Payroll responsibility executes the PQIPED2 report template; the BI/XML Publisher or Reports runtime then calls BEFOREREPORT, evaluates the CF_* formula columns and the CP_*_P accessors once per report group, and finally calls AFTERREPORT. It is not intended for direct invocation from forms or custom code, and no other package in the ETRM inventory references it. Because it is a report artifact, customisations should be applied through a copied, differently named package or via the report template rather than by modifying APPS.PQH_PQIPED2_XMLP_PKG, which may be regenerated by patching.