Results for “pay_za_tax_year_start_pkg”

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

Overview

PAY_ZA_TAX_YEAR_START_PKG is an Oracle E-Business Suite payroll utility package owned by the APPS schema that supports the South African (ZA) payroll legislated tax year rollover process. Its business purpose is to re-initialise payroll element entries at the commencement of a new statutory tax year so that year-to-date balances, indicator values, and start-of-year flags are correctly reset before the first payroll run of the new tax year is processed. The package operates over the assignments belonging to a specified payroll and evaluates records as of a supplied effective date, ensuring that only the assignment and element entry versions valid on that date are touched.

Because South African payroll reporting (including PAYE, UIF, SDL, and the associated statutory returns) is anchored to the tax year, incorrect carry-over of prior-year data produces materially wrong cumulative figures. This package provides the controlled reset and rollback mechanism that protects that boundary. The header reflects a legacy origin (pyzatysp.pkh, version 115.2, 2002) and is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than as a definer-rights package.

Key Procedures and Functions

The package exposes two documented procedures. Both accept an OUT error message, an OUT error code, and optional selection parameters for payroll and tax year, allowing the caller to scope the operation to a single payroll and tax year or to run it more broadly.

• RESET_ALL_IND — Performs the tax year start reset. It iterates the assignments associated with the specified payroll, locates the relevant element entries and their input values, and resets the year-start indicator values so that the new tax year begins from a clean state. It returns diagnostic information through the two OUT parameters.
• ROLLBACK_ALL_IND — Provides the compensating action for the reset. It reverses a previously applied reset, restoring the indicator values to their pre-reset condition. This is the recovery path when a tax year start is executed in error or must be undone before payroll processing resumes.

The two cursors defined in the package specification are internal helpers. c_assignments selects assignment identifiers from PER_ASSIGNMENTS_F for a given payroll and effective date. c_entry_details joins element entries, entry values, element links, and input values to retrieve screen entry values for a given element type, input value, assignment, payroll, and effective date. These cursors define the population over which the reset and rollback procedures operate.

Tables Accessed

The package reads and updates the following tables through their APPS synonyms:

• PAY_ELEMENT_ENTRIES_F — the dated element entry records for each assignment; the driver of which entries are in scope.
• PAY_ELEMENT_ENTRY_VALUES_F — the effective-dated entry values that hold the indicator screens the package resets.
• PAY_ELEMENT_LINKS_F — links element types to payrolls; used to confirm an entry is legitimately linked for the payroll in question.
• PAY_INPUT_VALUES_F — defines the input values, including the year-start indicator inputs being cleared.
• PAY_ELEMENT_TYPES_F — the element type definitions referenced during selection.

All queries are effective-date aware, using BETWEEN effective_start_date AND effective_end_date predicates so that the correct dated row is chosen for the supplied processing date.

Usage Notes

This package is typically invoked from the South African payroll tax year start process — usually a concurrent program or a supporting form action executed by the payroll administrator shortly before the first payroll run of the new tax year. It may also be called from custom PL/SQL where a site performs a controlled pre-year-end or post-year-end correction. The optional payroll and tax year parameters allow incremental execution per payroll, which is the recommended approach in multi-payroll environments.

The presence of both reset and rollback procedures indicates that the operation is intended to be reversible and should be run during a window in which no conflicting element entry maintenance is in progress. Callers must inspect the returned error message and error code; a non-success code signals that the reset or rollback was not fully applied and that subsequent payroll processing should be deferred until the condition is resolved. The package is referenced by one other package, indicating it forms part of a small dependency chain within the ZA payroll localisation.

With respect to the search term "quarterly tax payment 2026", this package does not calculate or remit quarterly tax payments. Its scope is the tax year start reset of element entry indicators, which precedes and enables correct cumulative tax calculation for the year; quarterly payment processing is handled by separate payroll and statutory reporting components.