Search Results p_report_year

Overview

The APPS.HR_NL_LAW_SAMEN_REPORT package body supports Dutch statutory headcount reporting for Oracle Human Resources in Oracle E-Business Suite 12.1.1 and 12.2.2. The package name derives from the Dutch terms Samen (aggregate/combined) and Report, and the underlying source file pernllsr.pkb belongs to the PER (Human Resources) product family. Its principal purpose is to compute and expose aggregated workforce metrics that satisfy Dutch legal reporting obligations, including the Wet SAMEN (Act on Stimulation of Labor Participation of Disabled Persons) requirements concerning the employment of individuals with a labor disability.

The package body is implemented as a thin functional wrapper layer. Each function delegates to the HQOrgData constructor and retrieves a specific attribute from the resulting object. This design reflects Oracle's convention of using a data-holding construct to cache organization-level headcount values, then exposing those values through discrete, single-purpose functions. All functions share a uniform exception-handling pattern: any error raised during attribute retrieval results in a return value of 0, ensuring that reporting queries do not fail should organizational data be incomplete or unavailable.

Key Procedures and Functions

ETRM documentation records 23 functions in this package. The primary set provides absolute headcount values for a given organization, keyed by p_organization_id:

• GET_TOTAL — returns the aggregate total headcount for the organization.
• GET_LS_TOTAL — returns the total within the reporting scope defined for the statutory report.
• GET_ACHT_TOTAL — returns the total as derived from the ACHT (actueel/current figure) perspective used in Dutch reporting.
• GET_FULL_TIME / GET_ACHT_FULL_TIME — return full-time headcount and its ACHT counterpart.
• GET_PART_TIME / GET_ACHT_PART_TIME — return part-time headcount and its ACHT counterpart.
• GET_TOTAL_HIRED / GET_ACHT_HIRED — return total hires and the corresponding ACHT figure.
• GET_TERMINATED / GET_ACHT_TERMINATED — return terminations and the corresponding ACHT figure.

The remaining documented functions supply comparison and percentage measures:

• GET_CURRENT_TOTAL and GET_LAST_ACHT_TOTAL — return the current total and the prior-period ACHT total respectively, supporting year-over-year comparison.
• GET_LAST_PERC_ACHT / GET_PERC_ACHT — return the prior and current ACHT percentage values.
• GET_PERC_FULL_TIME / GET_PERC_ACHT_FTIME — return the percentage of full-time employees and the ACHT full-time percentage.
• GET_PERC_PART_TIME / GET_PERC_ACHT_PTIME — return the percentage of part-time employees and the ACHT part-time percentage.
• GET_PERC_ACHT_HIRED — returns the ACHT percentage relating to hires.

The recurring reference to ACHT indicates that the package distinguishes statutory or prior-period target values from actual current values, allowing the report to compare realization against norm.

Tables Accessed

The package resolves its data through the following APPS synonyms:

• PER_ALL_ASSIGNMENTS_F — the date-tracked assignment table that provides the basis for headcount, full-time/part-time classification, and hire and termination activity.
• PER_PERIODS_OF_SERVICE — supplies engagement and service dates used to determine hire and termination counts and period membership.
• PER_ORG_STRUCTURE_ELEMENTS and PER_ORG_STRUCTURE_VERSIONS — provide organizational hierarchy context, ensuring that headcounts are correctly scoped to the passing organization and its subordinate units.
• DUAL — used for single-row evaluation within the underlying enquiry logic.

Consumption is read-only; no inserts, updates, or deletes are performed by this package.

Usage Notes

This package is an internal reporting utility rather than a public API, and ETRM records that it is referenced by zero other packages. It is not designed for direct invocation by external integrations. In practice it is invoked from Oracle HRMS reporting constructs — typically concurrent program report definitions, Oracle Reports or BI Publisher report templates, or form-level triggers — that generate the Dutch statutory headcount report. Callers pass an organization identifier to each function and receive a numeric value suitable for direct display or further aggregation.

Because every function absorbs exceptions and returns 0, consumers cannot distinguish a genuine zero from a failed lookup. Custom code should therefore validate organization identifiers and data completeness upstream if strict accuracy is required. As the source header indicates a version date of 2002, the package reflects long-standing statutory logic that has been retained across 12.1.1 and 12.2.2 without structural change; implementations should verify the organizational hierarchy and ACHT configuration in HRMS before relying on the derived percentage values.