Search Results p_top_organization_id

Overview

APPS.HR_HEAD_COUNT is a PL/SQL package body that supplies the Oracle EBS Human Resources (HR) head count engine used across HRMS reporting and position management. It belongs to the "OTHER" API classification in ETRM, meaning it is an internal utility package rather than a formally supported public API. Its principal business purpose is to compute head count metrics for an organization structure element across a specific organization structure version, separating active (regular) workforce from non-regular workforce populations. These metrics are the computational foundation behind head count reports surfaced through Oracle HRMS forms and concurrent programs.

The package body carries the version banner perhdcnt.pkb 120.0.12010000.2 (2008/08/06), indicating it derives from the 12.0 code line and is still shipped in 12.1.1 and 12.2.2. The functions are thin accessors that delegate to an object type instance, HQOrgData, instantiated from an organization structure element identifier. That design places the substantive computation logic in the HQOrgData type body while HR_HEAD_COUNT exposes individual scalar attributes of the computed head count result.

Key Procedures and Functions

The package exposes 35 documented functions, organized into a set of paired getters. All of them accept an organization structure element identifier and return a NUMBER, allowing them to be selected directly from SQL or referenced in a report query.

• Start-value getters — GET_REV_START_VAL and GET_NONREV_START_VAL return the starting head count for the regular and non-regular populations respectively.
• Permanent head count — GET_REV_PERM and GET_NONREV_PERM return permanent employee counts for each population.
• Contract head count — GET_REV_CONT and GET_NONREV_CONT return contractor counts.
• Temporary head count — GET_REV_TEMP and GET_NONREV_TEMP return temporary worker counts.
• Current head count — GET_REV_CUR_NH and GET_NONREV_CUR_NH return the current head count position for each population.
• New hires — GET_REV_NH and GET_NONREV_NH return new hire counts.
• Transfers — GET_REV_TRANSFER_IN, GET_NONREV_TRANSFER_IN, GET_REV_TRANSFER_OUT and GET_NONREV_TRANSFER_OUT return inbound and outbound transfer counts.
• Offers — GET_REV_OPEN_OFFERS, GET_NONREV_OPEN_OFFERS, GET_REV_ACCEPTED_OFFERS and GET_NONREV_ACCEPTED_OFFERS return open and accepted offer counts.

Every function wraps its delegation to HQOrgData in a WHEN OTHERS exception handler that returns 0, so callers never receive an unhandled error from these accessors. This defensive pattern means a missing or invalid organization structure element yields zero counts rather than a runtime failure.

Tables Accessed

The package and its underlying computations read from the following APPS synonym tables:

• PER_ORG_STRUCTURE_ELEMENTS and PER_ORG_STRUCTURE_VERSIONS — define the organization hierarchy nodes and the version effective-dating that scopes the head count calculation.
• PER_ALL_ASSIGNMENTS_F — the primary source of employee assignment records used to classify and count workers.
• PER_ASSIGNMENT_STATUS_TYPES — supplies status classifications required to distinguish active, transferred, and terminated assignments.
• PER_PERIODS_OF_SERVICE and PER_PERIODS_OF_PLACEMENT — provide service and placement context for new hires, transfers, and contractor counts.
• PER_REQUISITIONS — supports the open and accepted offer metrics.
• FF_FORMULAS_F — resolves formula logic used in head count derivation.
• DUAL — used by the simple accessor functions, consistent with the pattern shown at line 7 of the package body.

Usage Notes

Because HR_HEAD_COUNT is classified as OTHER, Oracle does not warrant the function signatures as a supported public interface, and customizations should avoid direct dependency where possible. In practice the package is invoked by HRMS head count reports, organization structure elements and Oracle HRMS forms that display establishment or head count figures, and by concurrent programs performing workforce analysis.

Regarding the user search term p_top_organization_id: this parameter name does not appear among the documented function signatures for HR_HEAD_COUNT, which consistently use p_org_structure_element_id. Callers searching for p_top_organization_id are likely working with a higher-level wrapper, a report parameter, or a different HR head count routine. When integrating, treat the organization structure element identifier as the authoritative key, and note that the package is referenced by one other package, which may supply the organization-level parameter translation.