Results for “get_total”

50+ results




Overview
Explore in AI Chat

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

Overview

APPS.PER_ZA_EE_DIFFERENTIAL_PKG is a South African localisation package within the Oracle E-Business Suite Human Resources (PER) module. Its purpose is to support the reporting and calculation of Employment Equity (EE) differential data as required by South African statutory reporting obligations, notably the Employment Equity Act and related Sector Education and Training Authority (SETA) classification requirements. The package body, delivered under version 120.0.12010000.1 with the source file perzaeid.pkb, was first introduced in November 2009 under bug 9112237 and carries a noship designation in its header.

The package is classified as OTHER within the ETRM metadata, indicating it is not a public supported API but rather an internal helper package used to prepare data for an EE differential report. It is not referenced by any other packages in the documented schema, which confirms its role as a report-specific utility.

Key Procedures and Functions

The package exposes five documented entry points:

  • BEFOREREPORT — Returns a boolean. This is the standard Oracle Reports before-report trigger function. It writes diagnostic location information for the key report parameters (report date, business group, legal entity, and salary method) and delegates the preparation of the category-level comparison tables to per_za_employment_equity_pkg.init_g_cat_lev_new_table, passing the same four parameters. This initialisation step is essential before the report body executes.
  • AFTERREPORT — Returns a boolean. The standard Oracle Reports after-report trigger. In the documented source it performs no substantive work, simply returning TRUE; the commented-out reset_tables call suggests table cleanup was considered but not enabled.
  • GET_SETA_CLASSIFICATION — Returns a varchar2 value representing the SETA classification. It accepts a business group identifier and an optional legal entity identifier. It reads the ZA_NQF_SETA_INFO organisation information context from HR_ORGANIZATION_INFORMATION, first attempting to resolve classification from the legal entity and falling back to the business group. If neither yields a value, null is returned.
  • GET_TOTAL — Returns a total value used in the EE differential calculations, typically aggregating the relevant workforce counts or amounts for a given category.
  • GET_ROW_TOTAL — Returns a row-level total, supporting the report's tabular aggregation logic by summing values across a category or assignment row.

Tables Accessed

The package references four tables via APPS synonyms:

  • PER_ALL_ASSIGNMENTS_F — The core assignment table, used to scope employees and assignments by business group and legal entity for the report population.
  • PER_ASSIGNMENT_EXTRA_INFO — Holds assignment-level flexfield information, referenced here for the aei_information7 attribute that carries legal entity context.
  • HR_ORGANIZATION_INFORMATION — Supplies the SETA classification via the ZA_NQF_SETA_INFO organisation information context, keyed by organisation identifier.
  • PER_ZA_EMPLOYMENT_EQUITY — The South African employment equity data table, providing the underlying EE metrics aggregated by GET_TOTAL and GET_ROW_TOTAL.

Usage Notes

PER_ZA_EE_DIFFERENTIAL_PKG is designed to be invoked from an Oracle Reports report, specifically through the before-report and after-report triggers of the EE differential report. BEFOREREPORT must be called first, as it initialises the category-level tables that subsequent report queries depend upon. GET_SETA_CLASSIFICATION may be invoked at any point where SETA classification must be displayed or grouped; its fallback from legal entity to business group ensures a value is returned whenever either level carries the NQF/SETA information.

Because the package is not referenced by other packages and is not a registered public API, it should not be called from custom concurrent programs or external code without reviewing the supporting Employment Equity package. The noship header flag indicates the file is delivered as part of the regional localisation patch stream rather than as shippable standalone functionality. Any modification should account for the fact that table initialisation happens in BEFOREREPORT while no cleanup occurs in AFTERREPORT, so temporary or derived data may persist within the session scope of the report run.