Search Results cf_sumnh_opmenformula
Overview
PQH_PQIPED7_XMLP_PKG is an Oracle EBS PL/SQL package owned by the APPS schema that serves as the database-side program unit for the concurrent program report PQIPED7. Reports in Oracle E-Business Suite are commonly built with Oracle Reports and registered against a stub PL/SQL package whose name carries the _XMLP_PKG suffix. This package exists to hold the report's global variables, user-entered parameters, and the formula functions that the report layout calls at runtime.
Functionally, the package supports a U.S. federal/state workforce composition reporting requirement. Judging from the parameter and function names, the report produces headcount and part-time/full-time statistics. The package defines the literal totTitle as "Total Part-Time Employees (sum of lines 68-76)", and the layout constants line_num and LastLineNo indicate the report is a structured, line-numbered statistical return rather than a free-form listing.
The default search term cf_sumtmrmenformula corresponds directly to the package function CF_SUMTMRMENFORMULA, which is one of the formula functions the report invokes to compute a subtotal. It is a companion to CF_SUMTMRWMENFORMULA.
Key Procedures and Functions
The package declares 30 documented procedures and functions, nearly all of which are cf_* "column formula" functions. These take paired numeric inputs, one for a non-institutional category and one for an institutional category, and return a computed number used in a report column.
CF_1FORMULA,CF_2FORMULA,CF_3FORMULA,CF_4FORMULA,CF_4FORMULA0004,CF_11FORMULA— General formula functions covering numbered report cells.CF_SUMAM_ALWMENFORMULA,CF_SUMAPMENFORMULA,CF_SUMAPWMENFORMULA,CF_SUMHMENFORMULA,CF_SUMHWMENFORMULA— Subtotal formulas for specific employee categories, split between male and female (W) variants.CF_SUMWNHMENFORMULA,CF_SUMWNHWMENFORMULA,CF_SUMURMENFORMULA,CF_SUMURWMENFORMULA— Additional category subtotals.CF_SUMNH_OPMENFORMULA,CF_SUMNH_OPWMENFORMULA— Subtotals for an operational sub-category.CF_SUMTMRMENFORMULA,CF_SUMTMRWMENFORMULA— The subtotal formulas matching the user's search term, computing category totals for male and female employees respectively.CF_TOTMENFORMULA— Aggregate total formula.
The package also declares global parameters (P_BUSINESS_GROUP_ID, P_CONC_REQUEST_ID, P_REPORT_DATE, LP_REPORT_DATE) and formatting strings (CP_FR, CP_FT, CP_PR, CP_PT). The package is defined with AUTHID CURRENT_USER, so privileges are evaluated as the invoking user.
Tables Accessed
The package references eight APPS synonyms:
PER_ALL_PEOPLE_F,PER_ALL_ASSIGNMENTS_F— Effective-dated person and assignment records, the primary source of employee population.PER_ASSIGNMENT_STATUS_TYPES— Determines which assignments are active at the report date.PER_JOBS,PER_PAY_BASES,PER_PAY_PROPOSALS— Classification and compensation attributes used to categorize employees.HR_ALL_ORGANIZATION_UNITS— Organization/establishment hierarchy used to scope the report.PAY_US_RPT_TOTALS— U.S. payroll reporting totals, indicating the report consolidates payroll-derived statistics.
Usage Notes
This package is invoked indirectly. It is not called by other PL/SQL packages (referenced by 0 packages), nor is it intended for direct customer invocation. It is bound to the PQIPED7 concurrent program through Oracle Reports, which calls the cf_*formula functions to populate computed columns and cell totals at print time. The P_CONC_REQUEST_ID and P_BUSINESS_GROUP_ID parameters are filled by the concurrent manager at submission.
Because the package is AUTHID CURRENT_USER and resides in APPS, customization should be avoided; modifications are overwritten during patching. The header comment (120.3, dated 2010) reflects version history maintained by Oracle development.