Search Results cf_dispnameformula

Overview

APPS.PQH_PQIPED1_XMLP_PKG is a generated PL/SQL package that supports the Oracle EBS Report eXchange (XML Publisher) report PQIPED1, a Public Sector / Human Resources report used within the Oracle iRecruitment and Human Resources (PQH) product family. In the EBS 12.1.1 and 12.2.2 architectures, XML Publisher concurrent programs are typically driven by an auto-generated package whose name follows the pattern <Report_Short_Name>_XMLP_PKG. This package owns the data model logic that feeds the report template, defines the report parameters, and provides the formatting helper functions invoked from the RTF or XML template layout. Its header comment (PQIPED1S.pls 120.1) indicates it is a seeded, non-customized object maintained under the APPS schema with AUTHID CURRENT_USER, meaning it executes with the privileges of the calling session rather than the definer.

The package is classified in ETRM as API classification OTHER, reflecting that it is not a public, supported business API but rather internal report infrastructure. It exposes report-level variables, parameter accessor functions, and formula functions consumed by the XML Publisher engine.

Key Procedures and Functions

• LINEFORMULA — Returns a line-numbering value used to sequence rows in the report output.
• CF_TOTTITLEFORMULA — A column formula that produces a formatted title string based on an organization code input.
• CF_DISPNAMEFormula — A column formula that derives a display name for a given organization code.
• BEFOREPFORM — Pre-parameter form trigger logic executed prior to the report parameter form being displayed.
• BEFOREREPORT — Initialization logic executed before the main report query runs, typically setting up globals and derived parameters.
• CF_SUMFACULTYFORMULA — Aggregates faculty counts across tenure categories (tenured, on tenure track, not on tenure track) into a single summary figure.
• AFTERREPORT — Cleanup logic executed after report completion.
• LINE_NUM_P — Accessor function returning the current value of the LINE_NUM package variable. This is the function matching the user's search term "line_num_p".
• CP_FT_P — Accessor returning the CP_FT character parameter value.
• CP_FR_P — Accessor returning the CP_FR parameter value.
• CP_PT_P — Accessor returning the CP_PT parameter value.
• CP_PR_P — Accessor returning the CP_PR parameter value.

Tables Accessed

The ETRM metadata for this object documents no directly referenced tables via APPS synonyms. This is consistent with report data-model packages that delegate all SQL to the XML Publisher data source or to an underlying view rather than executing DML directly. The faculty-related calculations in CF_SUMFACULTYFORMULA imply that source data derives from human resources and faculty assignment structures (for example, PER_ and HR_ organizational and assignment entities), but the metadata does not confirm specific table dependencies, and no direct references should be assumed.

Usage Notes

This package is invoked exclusively through the Oracle XML Publisher concurrent program execution path. When the PQIPED1 concurrent program is submitted, the XML Publisher engine calls BEFOREPFORM and BEFOREREPORT to initialize report state, executes the report query, evaluates the CF_* formula functions and LINE_NUM_P accessor during output formatting, and finally calls AFTERREPORT. It is not referenced by any other database package (documented as referenced by zero other packages), confirming it sits at the top of its own dependency chain.

Developers troubleshooting report output—such as numbering anomalies involving LINE_NUM_P or the CP_* column parameters—should inspect these accessors rather than modifying the package, since it is a seeded, auto-generated object. Any customization should be applied to the XML Publisher template or data definition layer, not the APPS package, to preserve upgrade safety in 12.1.1 and 12.2.2 environments.