Search Results get_source_number_context

Overview

APPS.PAY_ZA_RULES is a PL/SQL package body within the Oracle E-Business Suite Payroll (PAY) module, owned by the APPS schema. Its naming convention indicates a country-specific localization for South Africa (the "ZA" suffix denoting the ZA legislation/country code). The package encapsulates payroll legislative rules and validation logic used by the South African payroll environment to evaluate element entry data, assignment actions, and payroll processing attributes against statutory or business rules.

The object is documented with a VALID status in the ETRM repository, with an API classification of OTHER, meaning it is not a formally published public API but rather an internal implementation package invoked by Oracle's seeded ZA payroll configuration. The package body is not referenced by any other database object, confirming its role as a leaf-level implementation unit consumed indirectly by higher-level payroll processes (fast formulas, element processing, and payroll run logic) rather than being called by other PL/SQL packages.

Key Procedures and Functions

The ETRM metadata documents two procedures/functions within the package body:

• GET_SOURCE_TEXT_CONTEXT — A context-retrieval routine that returns the textual (character) context associated with a payroll rule evaluation. In the Oracle payroll rules framework, this type of function supplies the descriptive source value used to resolve or message a rule condition.
• GET_SOURCE_NUMBER_CONTEXT — The numeric counterpart, returning the numeric context value required for rule evaluation. This is typically used where a rule must compare or derive a number (for example, a rate, threshold, or amount) from source payroll data.

Both names follow the standard "GET_" accessor convention, indicating they retrieve context values rather than performing data manipulation. Only the names and purposes are documented; specific parameter lists are not published in the ETRM entry and are therefore not enumerated here.

Tables Accessed

The package body references the following base payroll tables via APPS synonyms, all of which are standard Oracle Payroll (PAY) entities:

• PAY_ASSIGNMENT_ACTIONS — Assignment-level actions and their effective dates, used to determine the state of an assignment during rule evaluation.
• PAY_ELEMENT_ENTRIES_F — The element entry header records, providing the entry context for an assignment.
• PAY_ELEMENT_ENTRY_VALUES_F — The input values attached to element entries, which supply the actual numbers and text that the context functions resolve.
• PAY_ELEMENT_LINKS_F — Links that determine which elements are available to which assignments or payrolls.
• PAY_ELEMENT_TYPES_F — Element type definitions, supplying classification and processing rules for elements.
• PAY_INPUT_VALUES_F — Definitions of element input values, defining the units and data types of entry values.
• PAY_PAYROLL_ACTIONS — Payroll action records that establish the payroll run context in which rules are evaluated.

The package also references APPS.HR_UTILITY, a shared utility package providing common date, validation, and error-handling routines, and SYS.STANDARD, the default PL/SQL package supplying built-in types and operators.

Usage Notes

PAY_ZA_RULES is invoked in the context of South African payroll processing—most commonly during payroll runs, element entry validation, and fast formula execution, where legislative or company rules must be evaluated against assignment and entry data. Because it is classified as OTHER and is not referenced by other database objects, it is not intended for direct invocation by custom code. The context functions are called internally by Oracle's seeded rule engine, using the referenced payroll tables to derive text and numeric context values.

Developers tracing South African payroll behavior should treat PAY_ZA_RULES as an internal dependency of seeded ZA payroll configuration rather than a supported extension point. The absence of reverse dependencies indicates that the package is a terminal node in the payoll localization call graph, reinforcing that modifications should be avoided in favor of Oracle-provided configuration and formula mechanisms.