Search Results pay_element_entry_values_s




Overview
Explore in AI Chat

Overview

The APPS.PER_ZA_UTILITY_PKG package body is a South African (ZA) localization utility that supports Oracle Payroll's element entry and payroll run processing for the Republic of South Africa legislative context. Its principal business role is to manage the persistence of element entry values and payroll run result values that arise when a payroll element is processed for an assignment, with particular emphasis on the interaction between input values, link input values, and user-defined columns.

The package is classified as OTHER in the ETRM metadata and holds VALID status in the APPS schema. It is referenced by three other database objects, confirming its role as a shared localization library rather than a standalone entry point. The presence of the PAY_ELEMENT_ENTRY_VALUES_S dependency — the object name that produced the user's original search — indicates that the package participates directly in the insert and maintenance of element entry value rows on the PAY_ELEMENT_ENTRY_VALUES_F entity.

Key Procedures and Functions

  • GET_TABLE_VALUE — Retrieves a value from a referenced table, generally used to look up meanings or session-scoped data required during payroll processing.
  • PER_ZA_TABLE_MEANING — Resolves a human-readable meaning for a South African legislative lookup, supporting validation and display logic for ZA-specific values.
  • CHK_ENTRY_IN_LOOKUP — Validates that a supplied entry exists within the relevant HR or legislative lookup, preventing invalid values from being written to element entry or run result records.
  • MAINTAIN_IPV_LINKS — Coordinates the maintenance of input value and link input value relationships, ensuring that PAY_INPUT_VALUES_F, PAY_LINK_INPUT_VALUES_F, and PAY_LINK_INPUT_VALUES_S remain synchronized with element link configurations.
  • INSERT_EE_VALUE — Inserts element entry values into the PAY_ELEMENT_ENTRY_VALUES_F and PAY_ELEMENT_ENTRY_VALUES_S tables, persisting the input values captured for an assignment's element entry.
  • INSERT_RR_VALUE — Inserts payroll run result values into PAY_RUN_RESULT_VALUES, linking run results to their corresponding input value definitions.

The metadata lists eight documented procedures and functions; the remaining entries support the six described above, typically as helper routines for session, context, or date/number conversion handling.

Tables Accessed

Usage Notes

PER_ZA_UTILITY_PKG is not referenced by any database object that consumes it directly, but it is referenced by three other packages within the ZA payroll localization. It is typically invoked from South African payroll element processing, from the element entry forms when values are saved, and from concurrent programs that generate or recalculate payroll run results. Custom localization code that must persist element entry or run result values for South African business groups should call INSERT_EE_VALUE and INSERT_RR_VALUE rather than inserting directly into the underlying _F and _S tables, since the package encapsulates the required date-tracked and session-context logic. Because it depends on FND_SESSIONS and PAY_ACTION_CONTEXTS, the package must be executed within an initialised EBS session with an active payroll action context; direct SQL invocation outside that context will not resolve context-dependent values correctly.