Search Results cf_sumurwmenformula

Overview

APPS.PQH_PQIPED11_XMLP_PKG is a PL/SQL package that implements the server-side logic for the Oracle E-Business Suite concurrent program report PQIPED11, an Oracle Public Sector / Human Resources part-time employment reporting report. The package follows the standard Oracle Reports XML Publisher (XMLP) packaging convention: the report layout is generated by Oracle Reports, while the calculation and formula logic is encapsulated in PL/SQL so that report triggers and formula columns can call into it. The report focuses on part-time employee headcount broken down by race, ethnicity, gender, and instructional versus non-instructional status, which is characteristic of an IPEDS (Integrated Postsecondary Education Data System) regulatory submission used by higher education and public sector institutions.

The package version reflected in the source header is 120.1, dated 2007/12/21, which places it within the 12.1.1 code line and carried forward essentially unchanged into 12.2.2. It is an "OTHER" classified API, meaning Oracle does not document it as a supported public interface; customers should treat it as an internal report implementation object.

Key Procedures and Functions

The package exposes 26 documented program units. The bulk of these are formula functions that return a numeric year-to-date or period total by adding a non-instructional count to an instructional count. Each function corresponds to a specific reporting row:

• CF_1FORMULA, CF_2FORMULA, CF_3FORMULA, CF_4FORMULA, CF_4FORMULA0004 — general row-formula calculations for the first through fourth report lines and a variant of line four.
• CF_SUMAM_ALWMENFORMULA, CF_SUMAPMENFORMULA, CF_SUMAPWMENFORMULA — summation formulas for American Indian/Alaskan Native men and women, and Asian/Pacific Islander men and women.
• CF_SUMHMENFORMULA, CF_SUMHWMENFORMULA — Hispanic men and Hispanic women totals.
• CF_SUMWNHMENFORMULA, CF_SUMWNHWMENFORMULA — men and women whose race/ethnicity is not reported (non-Hispanic, unknown/other).
• CF_SUMURMENFORMULA, CF_SUMURWMENFORMULA — non-resident alien men and women totals. CF_SUMURWMENFORMULA is the function that matches the user's search term "cf_sumurwmenformula", confirming it computes the non-resident alien female count.
• CF_TOTMENFORMULA, CF_11FORMULA — grand total and line-eleven calculations.
• BEFOREREPORT, AFTERREPORT — report-level triggers that initialize and clean up the report context.
• LINE_NOFORMULA — controls the sequential line numbering printed on the report; note the package-level variables line_num (initialized to 2) and LastLineNo (10), and the constant totTitle holding the literal "Total Part-Time Employees (sum of lines 1-9)".

Parameter variables declared include P_BUSINESS_GROUP_ID, P_CONC_REQUEST_ID, P_REPORT_DATE, and the character parameters CP_FR, CP_FT, CP_PR, CP_PT, which correspond to the four report parameter prompts.

Tables Accessed

The package reads from several HRMS and Public Sector tables through APPS synonyms:

• PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_F — the core person and assignment records providing gender, date-tracked effective dates, and current assignment status.
• PER_ASSIGNMENT_STATUS_TYPES — filters to active assignments only.
• PER_JOBS — identifies instructional versus non-instructional job classifications.
• PER_PAY_BASES, PER_PAY_PROPOSALS — used to determine full-time/part-time status and pay basis.
• PER_PEOPLE_EXTRA_INFO — supplies race, ethnicity, and other reported demographic attributes.
• HR_ALL_ORGANIZATION_UNITS — resolves the business group and organizational reporting hierarchy.
• PAY_US_RPT_TOTALS — the aggregate US reporting totals table that supplies or validates reported counts.

Usage Notes

This package is invoked exclusively from the concurrent program and its accompanying Oracle Reports XMLP definition, not from forms. A user runs the report by selecting the concurrent request parameters (business group, report date, and the four categorical filters). At runtime the Oracle Reports engine fires BEFOREREPORT, executes the data query, and calls the CF_* formula functions for each row of the report output; AFTERREPORT performs final cleanup. Because the package is classified as OTHER and is not a supported public API, it must not be called directly from custom code. It is referenced by zero other packages, confirming it is a leaf report implementation object. The "cf_sumurwmenformula" identifier the user searched for is simply the internal formula function that calculates the non-resident alien female column within this IPEDS part-time employee report.