Results for “emp_count”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.PAY_NZ_QES_PKG is a New Zealand localization package within the Oracle E-Business Suite Payroll module. Its name derives from the Quarterly Employment Survey (QES), a statistical return that New Zealand employers are required to file with Statistics New Zealand. The package provides the PL/SQL logic needed to gather, aggregate, and reconcile payroll data required for that survey, drawing together headcount, hours, and earnings information across payroll, assignment, and balance structures. The 12.2.2 ETRM record classifies this object as an "OTHER" API — that is, it is not an officially supported public interface intended for third-party extension, but rather an internal component invoked by Oracle-delivered localization logic. It is associated with the seeded New Zealand legislative and statutory reporting content. The package body carries an old header date (2005) reflecting its long-standing presence since the early 11i/12.0 lineage, but it remains present in both 12.1.1 and 12.2.2 environments where the NZ payroll localization has been installed. All eight documented program units are internal helper routines; none is exposed as a supported API.

Key Procedures and Functions

The package contains eight documented program units. COUNT_EMPLOYEES returns a headcount based on organizational, payroll, time-period, location, employee-category, work-time, and gender selection criteria evaluated as of a survey date. COUNT_EMPLOYEES_USING_BALANCE provides a comparable headcount, but derives it from payroll balance data rather than direct assignment querying, which is useful where a balance already embodies the required filtering. SUM_BALANCES aggregates a balance value across the selected population for the survey period. ID_FOR_DEFINED_BALANCE resolves a defined-balance identifier, allowing the package to locate the correct balance definition at runtime rather than hard-coding it. ORDINARY_TIME_PAYOUT and HOURS_WORKED extract the ordinary-time earnings and hours-worked figures respectively, which form core QES measurements. CONVERT_HOURS is the routine a user searching on "convert_hours" is typically looking for; it normalizes hours into the reporting unit expected by the survey, reconciling time recorded across differing assignment and payroll period conventions. NO_PERIODS_PER_YEAR returns the count of pay periods in the year for a given payroll frequency, supporting annualization and pro-rating calculations.

Tables Accessed

The package reads from nine documented tables via APPS synonyms. PER_ALL_PEOPLE_F and PER_ALL_ASSIGNMENTS_F supply the employee and assignment attributes — organization, location, employee category, work-time code, gender — that drive population selection. PAY_ALL_PAYROLLS_F scopes the query to a specific payroll. PER_TIME_PERIODS and PER_TIME_PERIOD_TYPES establish the survey period boundaries and pay-frequency context required by NO_PERIODS_PER_YEAR. HR_SOFT_CODING_KEYFLEX links assignments to organization via the keyflex segment, which is the mechanism the COUNT_EMPLOYEES cursor uses to restrict results to a designated organization. PAY_DEFINED_BALANCES, PAY_BALANCE_TYPES, and PAY_BALANCE_DIMENSIONS provide the balance metadata needed to resolve balance identifiers and aggregate balance values for HOURS_WORKED, ORDINARY_TIME_PAYOUT, and SUM_BALANCES.

Usage Notes

The package is invoked by Oracle's New Zealand QES reporting flow rather than from a standard user form. It is most commonly reached through the concurrent program that generates the quarterly survey output, or through the NZ localization report that Statistics New Zealand requires. Because ETRM lists zero referencing packages and classifies the API as OTHER, it should be treated as internal: customizations should not call it directly, since its signatures and behavior are not guaranteed across patches or upgrades. Where the metadata is limited, the practical guidance is to run the seeded QES concurrent process and let the package drive selection, aggregation, and hour conversion internally; any bespoke reporting should instead query the underlying payroll balance and assignment tables directly to avoid dependency on an unsupported internal body.