Search Results za_term_cat_update

Overview

PER_ZA_UTILITY_PKG is a South African localization utility package within Oracle Human Resources (Oracle EBS 12.1.1 / 12.2.2). It provides helper routines that support payroll and element configuration specific to the ZA (South Africa) legislation, with particular emphasis on maintaining input value links and element entry values during legislative install and migration processes. The package is owned by APPS and is classified as OTHER in the ETRM metadata, indicating it is not a public API in the traditional sense but is a supporting utility invoked by other legislative installation and migration scripts. The package source header (pezautly.pkh, version 120.1, dated 2005) shows it is part of the Oracle HR ZA Utility Package family and has evolved from the earlier pezatbme package.

Key Procedures and Functions

• GET_TABLE_VALUE — Returns a value from a specified user table. An overloaded version of this function was added in version 115.1 (bug 2266156) to support flexible lookup requirements.
• PER_ZA_TABLE_MEANING — Returns the meaning/value associated with a specific user table; its documented reference is PER_ZA_LEARNERSHIP_AGREEMENT_V.
• CHK_ENTRY_IN_LOOKUP — Validates whether a given entry exists in the lookup table, supporting data integrity checks for ZA legislative values.
• MAINTAIN_IPV_LINKS — Checks for any seeded input value that has been linked at element level but for which no input value link exists; it then creates the link based on the element link's values and creates a dummy element entry value when an element entry is found. Added in version 115.3 (bug 2224332).
• INSERT_EE_VALUE — Inserts element entry values. Modified to public in version 115.4 (bug 4346970) to support migration scripts.
• INSERT_RR_VALUE — Inserts run result values; introduced alongside the change to INSERT_EE_VALUE in version 115.4.
• ZA_TERM_CAT_UPDATE — Updates termination category values, accepting an existing leaving reason and a seeded leaving reason. Added in version 115.2.

Tables Accessed

The package operates on core Oracle Payroll tables via APPS synonyms. It reads and writes PAY_ELEMENT_ENTRY_VALUES_F and PAY_ELEMENT_ENTRY_VALUES_S, PAY_INPUT_VALUES_F, PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_LINKS_F, PAY_ELEMENT_TYPES_F, PAY_LINK_INPUT_VALUES_F and PAY_LINK_INPUT_VALUES_S. Run result data is handled through PAY_RUN_RESULTS, PAY_RUN_RESULT_VALUES, PAY_ACTION_CONTEXTS, PAY_USER_COLUMNS and PAY_USER_COLUMN_INSTANCES_F. Context and session information is drawn from FF_CONTEXTS and FND_SESSIONS. These accesses underpin the creation and validation of element links, input values and element entries required by South African legislative configuration.

Usage Notes

PER_ZA_UTILITY_PKG is typically invoked during legislative installation and migration, not by end users directly. The documented call from perlegza.sql during the legislative install process demonstrates its role in bootstrapping ZA payroll configuration. Because INSERT_EE_VALUE and INSERT_RR_VALUE are public, custom migration scripts may call them to populate element entry and run result values consistently. The package is referenced by three other packages, indicating it is a foundational dependency in the ZA HR localization layer. Developers customizing South African payroll elements should treat these routines as internal utilities and avoid direct modification, since they are maintained by Oracle and tied to legislative patch delivery.