Search Results cf_grouptottitleformula

Overview

APPS.PQH_PQIPED3_XMLP_PKG is a PL/SQL package associated with an Oracle HRMS (Public Sector / Position and Employee reporting) XML Publisher concurrent program report in Oracle E-Business Suite 12.1.1 and 12.2.2. The _XMLP_PKG suffix indicates that the package is an XML Publisher (BI Publisher) report packaging unit — the source .pls file, with a header revision of 120.2 dated 2007/12/21, generates the report definition and supports the data model defined in the accompanying .xml concurrent program definition.

The business purpose of the package is to produce a statutory government reporting extract — specifically an "Instruction Combined with Research and/or Public Service Employees" report, referenced by the constant CP_TotTitlePerReport. Such reports are typically used by public sector and educational institutions to report headcount or FTE (Full-Time Equivalent) statistics to regulatory bodies. The user search term "p_report_day_month" maps directly to the package's global variable P_REPORT_DAY_MONTH, which is a report parameter captured as a varchar2 value.

Key Procedures and Functions

The package declares eleven documented procedures and functions. These are:

• lineFormula — a function returning a Number, used to calculate the running line number within the report layout.
• CF_GroupTotTitleFormula — a formula function that returns a character value, producing the group total title based on a supplied group code (genCode).
• BeforeReport — a function returning boolean; the standard report trigger that executes before the report body is generated, typically used to initialize parameters, resolve the concurrent request context, and prepare globals such as CP_REPORT_DATE.
• AfterReport — a function returning boolean; executes after the report is generated, used for cleanup and final formatting.
• line_num_p — accessor function returning the current line_num value.
• CP_TotTitlePerReport_p — accessor returning the report title string.
• CP_PT_p, CP_PR_p, CP_FT_p, CP_FR_p — accessor functions returning varchar2 values; these correspond to the classification buckets (probably Part-Time, Research, Full-Time, and Full-Time Research) used in the "Instruction Combined with Research and/or Public Service" categories.
• ReportTotLineNo_p — accessor returning the report total line number, initialized to 15.

Tables Accessed

No tables are documented as accessed via APPS synonyms in the ETRM metadata for this package, and no referenced-by relationships are recorded. This is consistent with the package's design as a report-side wrapper: the underlying data extraction is performed by the driving SQL query in the concurrent program definition, not by the package itself. The package only manages report-level globals, computed columns, and the BeforeReport/AfterReport flow.

Usage Notes

This package is not intended for ad-hoc or customer invocation. It is bound to the XML Publisher concurrent program PQIPED3 and is executed implicitly when that report is submitted. The parameter P_REPORT_DAY_MONTH should be passed through the concurrent program parameters (or populated from the SRS request via the data model), and P_CONC_REQUEST_ID is populated automatically by the Oracle Reports/XML Publisher runtime. No other packages reference this package, so customizations should avoid modifying it directly and instead use a copied custom package or the standard XML Publisher template/data-model editors to extend behavior.