Search Results pay_gb_rules

Overview

PAY_GB_RULES is a United Kingdom localization package within the Oracle Payroll (PAY) application module. Its declared purpose, as reflected in the package header source, is to support Great Britain statutory and legislative processing rules that fall outside the generic payroll engine. The package is owned by APPS in the E-Business Suite schema and is declared with AUTHID CURRENT_USER, meaning its SQL statements execute under the privileges of the invoking user rather than the defining user. This is consistent with a utility package intended to be called from PL/SQL contexts where the caller already holds the necessary data privileges.

The specific capability documented in the header relates to Court Order Reference source text contexts. Court Orders (including Deduction from Earnings Orders and similar statutory deductions) require reference text that identifies the source and nature of the order. PAY_GB_RULES centralises the derivation of that context so that multiple payroll processes generate consistent reference information.

Key Procedures and Functions

The ETRM metadata for this object documents a single public procedure:

• GET_SOURCE_TEXT_CONTEXT — Populates or resolves the default context for Court Order Reference source text. The procedure signature includes an assignment action identifier, an employee identifier, and an input/output source text parameter. Because the source text argument is declared IN OUT NOCOPY, the procedure may both read the caller-supplied value and return a modified value to the calling program. This pattern is typically used when a default must be established conditionally — the caller passes an existing candidate value, and the procedure adjusts or replaces it based on the assignment action and employee context. No additional public functions or procedures are documented in the package specification.

The package specification exposes no other documented entry points. Any internal helper routines are private to the body and are not part of the published interface.

Tables Accessed

The ETRM metadata records no tables referenced through APPS synonyms for this package. This is expected for a specification-level extract, since table references are resolved at runtime and are generally recorded in the package body rather than the header. Practically, GET_SOURCE_TEXT_CONTEXT relies on payroll assignment action and employee context data — logically drawn from the assignment action and person/assignment entities — together with any Court Order source text configuration maintained by the GB localization. Because the package executes with current-user privileges, callers must ensure they have select access to the underlying payroll tables.

Usage Notes

PAY_GB_RULES is invoked from within UK payroll processing logic rather than being exposed directly to end users. Typical call sites include:

• UK payroll legislative or statutory deduction routines that must generate Court Order reference text during payroll run processing.
• Payroll forms or concurrent processes that seed default reference text before an order is recorded or recalculated.
• Custom PL/SQL extensions that need to reproduce the standard GB Court Order reference context for reporting or data migration.

Because the package is not referenced by any other documented package in the ETRM 12.2.2 extract, it should be treated as a leaf-level utility. Callers should supply a valid assignment action identifier and employee identifier, and should expect the source text parameter to be modified in place. No direct menu function or concurrent program is documented for this object.