Search Results p_organization_id

Overview

HR_NL_LAW_SAMEN_REPORT is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the OTHER API category. It supports Dutch (NL) statutory headcount and workforce-composition reporting — the term "SAMEN" refers to aggregated or consolidated reporting, and the package is associated with the legal reporting requirements that Dutch organizations must satisfy for works council (Ondernemingsraad) and social reporting purposes. The package exposes a set of scalar functions that each accept an organization identifier and return a numeric aggregate describing a dimension of the workforce for that organization, including total headcount, full-time and part-time splits, hires, terminations, and derived percentages. A record type, HQOrgTableType, defines the full set of reporting measures, and a collection type, HQOrgTable, indexes those records by binary integer so that results for a hierarchy of organizations can be assembled in memory.

Key Procedures and Functions

The package declares 23 documented functions, each returning a NUMBER and carrying PRAGMA RESTRICT_REFERENCES(...,WNDS,WNPS), confirming they are free of writes to database state and package state.

• GET_TOTAL, GET_LS_TOTAL, GET_ACHT_TOTAL — return overall headcount measures, including the "ACHT" (eight, i.e., full-time-equivalent) variant and an LS variant used in the Dutch reporting model.
• GET_FULL_TIME, GET_ACHT_FULL_TIME — return the count of full-time employees and its FTE-weighted equivalent.
• GET_PART_TIME, GET_ACHT_PART_TIME — return the count of part-time employees and its FTE-weighted equivalent.
• GET_TOTAL_HIRED, GET_ACHT_HIRED — return the number of employees hired in the reporting period, in headcount and FTE terms respectively. GET_TOTAL_HIRED is the function most frequently located through the search term that prompted this article.
• GET_TERMINATED, GET_ACHT_TERMINATED — return the number of employees who left during the period, in headcount and FTE terms.
• GET_CURRENT_TOTAL, GET_LAST_ACHT_TOTAL — return the current-period total and the prior-period FTE total, providing the basis for period-over-period comparison.
• GET_LAST_PERC_ACHT, GET_PERC_ACHT, GET_PERC_FULL_TIME, GET_PERC_ACHT_FTIME, GET_PERC_PART_TIME, GET_PERC_ACHT_PTIME, GET_PERC_ACHT_HIRED — return the percentage measures that populate the ratio columns of HQOrgTableType, expressing each category as a proportion of the applicable total.

Tables Accessed

The package reads from five objects through APPS synonyms:

• PER_ALL_ASSIGNMENTS_F — the primary source of assignment-level workforce data, providing the effective-dated basis for headcount and FTE calculations.
• PER_PERIODS_OF_SERVICE — supplies hire and termination dates used by GET_TOTAL_HIRED, GET_ACHT_HIRED, GET_TERMINATED, and GET_ACHT_TERMINATED.
• PER_ORG_STRUCTURE_ELEMENTS and PER_ORG_STRUCTURE_VERSIONS — resolve the organization hierarchy so that aggregates can be scoped to a specific organization and its reporting structure.
• DUAL — used for single-row arithmetic and validation within the function bodies.

Usage Notes

HR_NL_LAW_SAMEN_REPORT is referenced by zero other packages, so it is not part of a larger server-side dependency chain; it functions as a terminal reporting utility rather than a shared API. It is typically invoked from Oracle Forms-based Dutch statutory reporting screens, from concurrent programs that generate the SAMEN/headcount report output, or from custom PL/SQL that needs a single workforce metric for a given organization. Because every function is a RESTRICT_REFERENCES pure function taking p_organization_id, callers can embed the functions directly in SQL SELECT lists or PL/SQL expressions, for example to retrieve GET_TOTAL_HIRED for an organization without instantiating the HQOrgTable collection. When a full multi-measure report is required, the caller populates the HQOrgTable collection with HQOrgTableType records and computes or reads the percentage columns alongside the base counts. The AUTHID CURRENT_USER declaration means the package executes with the privileges of the invoking schema, so callers must themselves have access to the underlying PER tables.