Search Results update_this_record

Overview

APPS.PAY_ZA_UPDATE_PKG is a South African localizations package within Oracle EBS Payroll (PAY). It supports the maintenance of tax year start (TYS) data for South African payrolls, providing the validation, update, and rollback logic that governs the records stored in the ZA tax year start processing structures. The package operates under AUTHID CURRENT_USER and is compiled against the APPS schema, consistent with standard EBS PL/SQL practice for localization packages that must resolve object names through APPS-owned synonyms at runtime.

The package header originates from the source file pyzaupdt.pkh (version 120.1.12010000.1, shipped 2008/07/28), which corresponds to the R12 12.1.1 code line and remains applicable in 12.2.2. Its principal business role is to determine whether a given payroll and tax year combination is eligible for update or rollback, to validate individual tax year start entries, and to apply or reverse changes against the underlying payroll element data.

Key Procedures and Functions

The documented interface comprises ten procedures and functions. Several are boolean predicates used by the calling form or process to gate user actions:

• PAYROLL_UPDATEBLE — Returns a BOOLEAN indicating whether the specified payroll and tax year may be updated. (The misspelling "updateble" is the shipped identifier.)
• PAYROLL_ROLLBACKABLE — Returns a BOOLEAN indicating whether the specified payroll and tax year may be rolled back.
• GET_TAX_YEAR — Returns a VARCHAR2 tax year value for a payroll. It is documented in the header as a commented-out declaration, so its status depends on the compiled specification.
• GET_TAX_YEAR_END — Returns the DATE on which the tax year ends for a payroll and tax year.
• ENTRY_VALID — Validates a single tax year start entry record, taking a validation mode to distinguish validation contexts.
• UPDATE_THIS_RECORD — Applies a new value to an individual entry record, subject to an update mode.
• UPDATE_TYSP_TABLE — Updates the ZA tax year start process table for a payroll and tax year.
• DELETE_TYSP_TABLE — Removes tax year start process rows for a payroll and tax year.
• GET_ORIGINAL_VALUE — Retrieves the original (pre-update) value of an entry record to support rollback.
• ROLLBACK_THIS_RECORD — Reverses changes on an individual entry record, restoring its original value.

The header carries PRAGMA RESTRICT_REFERENCES declarations (WNDS, and WNPS where noted) on the query functions, reflecting the pre-12c purity-level conventions used in this code line.

Tables Accessed

The package reads and writes core payroll and ZA localization tables through APPS synonyms:

• PAY_ZA_TYS_PROCESSES and PAY_ZA_TYS_PROCESSES_S — the ZA tax year start process header and its translation table, the primary target of UPDATE_TYSP_TABLE and DELETE_TYSP_TABLE.
• PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_ENTRY_VALUES_F, PAY_ELEMENT_LINKS_F, PAY_ELEMENT_TYPES_F, PAY_ELEMENT_CLASSIFICATIONS, and PAY_INPUT_VALUES_F — the element definition and entry-value date-tracked tables whose values are modified or restored during update and rollback.
• PER_TIME_PERIODS — used to resolve period and tax year boundaries.

Usage Notes

PAY_ZA_UPDATE_PKG is an internal localization utility rather than a public API. It is invoked from the South African Tax Year Start maintenance flow — typically the ZA payroll update form or a related concurrent process — and it is referenced by one other package in the EBS codebase. Because the package is AUTHID CURRENT_USER and unlisted as a published API, customizations should call it only where the shipped ZA localization flow already invokes it. Purity pragmas restrict the query functions to reads, and all update and rollback operations are scoped strictly by payroll and tax year to limit impact to the targeted localization data.