Results for “get_seta_classification”

8 results




Overview
Explore in AI Chat

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

Overview

PER_ZA_EE_DIFFERENTIAL_PKG is a South Africa–specific Oracle HRMS (Oracle Human Resources / Payroll) PL/SQL package owned by the APPS schema. It supports the statutory reporting of Employment Equity (EE) differential data required by South African labour legislation, where employers must report on the composition of their workforce across occupational levels and designated groups. The package supplies the underlying data-handling and calculation logic for the corresponding EE differential report — typically an Oracle Reports or BI Publisher output — enabling totals and classification values to be derived at runtime rather than being pre-stored.

The package is declared AUTHID CURRENT_USER, meaning its SQL executes under the privileges of the invoking user, relying on APPS synonyms and grants rather than definer's rights. It carries no seeded API classification beyond OTHER, confirming that it is a report-support package rather than a public integration API, and it is not referenced by any other package.

Key Procedures and Functions

  • BEFOREREPORT — Returns a boolean. Invoked by the report framework to initialise state before the report body executes, typically resetting the package-level globals (business group, report date, legal entity, submission date, salary method).
  • AFTERREPORT — Returns a boolean. Cleanup entry point invoked once the report completes, clearing package state and releasing report context.
  • GET_SETA_CLASSIFICATION — Returns a varchar2 SETA (Sector Education and Training Authority) classification value, derived from the business group and legal entity context. Used to determine the correct SETA grouping for EE submission purposes.
  • GET_TOTAL — Returns a number. Computes an aggregate total for a given employment type, employee type, report identifier and legal entity, providing the summary counts or amounts that appear on the differential report.
  • GET_ROW_TOTAL — Returns a number. Computes a row-level total for a specific employment type, inclusion number and legal entity, supporting per-line subtotalling within the report layout.

Five package-level globals — P_BUSINESS_GROUP_ID, P_REPORT_DATE, P_LEGAL_ENTITY_ID, P_SUBMISSION_DATE and P_SALARY_METHOD — carry report parameters between these entry points.

Tables Accessed

  • PER_ALL_ASSIGNMENTS_F — Primary source of assignment and employment records, filtered by business group and effective date.
  • PER_ASSIGNMENT_EXTRA_INFO — Supplies assignment-level flexfield extra information, including the legal entity reference used in classification lookups.
  • HR_ORGANIZATION_INFORMATION — Provides organisation-level attributes for the legal entity and reporting hierarchy.
  • PER_ZA_EMPLOYMENT_EQUITY — The South Africa EE-specific table holding employment equity attributes used to populate the differential report.

Usage Notes

The package is invoked exclusively as a report-support library. Its BEFOREREPORT and AFTERREPORT functions are called by the report trigger framework, while GET_SETA_CLASSIFICATION, GET_TOTAL and GET_ROW_TOTAL are called from report query groups or formula columns to supply derived values. It is not a concurrent program in its own right and exposes no public API for external integration. Customisations should avoid modifying the package body directly; extensions are best implemented by wrapping the documented functions.

Note: documentation is confirmed against ETRM 12.2.2; behaviour in 12.1.1 is consistent, as indicated by the 120.0.12010000 source header.