Search Results per_gb_reverse_term_rules

Overview

APPS.PER_GB_REVERSE_TERM_RULES is a PL/SQL package in the Oracle E-Business Suite Applications (APPS) schema that supports United Kingdom (GB) localization requirements for the Oracle Human Resources (HR) module. Its name indicates its role in governing the rules applied when a termination is reversed. Terminations recorded against employee assignments in Oracle HRMS may be reversed to correct data-entry errors or reinstatement decisions, and the reversal must comply with statutory and business rules specific to the GB legislation. This package encapsulates those rules so that terminating and reinstating an assignment produces a consistent, validated result. The package is documented in the E-Business Suite Technical Reference Manual (ETRM) as being owned by APPS with a status of VALID, and it is classified under the generic API classification OTHER, indicating it is an internal utility rather than a public, fully documented application programming interface.

Key Procedures and Functions

The ETRM metadata documents a single procedure for this package:

• VALIDATE_REVERSE_TERMINATION — This procedure validates the conditions under which a reverse termination action may be performed for a GB employee assignment. It is the central entry point of the package and is invoked to confirm that the reversal request satisfies the GB-specific business rules before the termination record is reversed. Consistent with the package's internal classification, no parameter list is published in the ETRM documentation, so the procedure should be treated as an internal validation routine rather than a freely callable API. Custom code requiring this validation should generally rely on the standard HR termination-reversal flows that invoke it, rather than calling the procedure directly.

Tables Accessed

The package reads and evaluates data from the following documented tables, accessed through APPS synonyms:

• PER_ALL_ASSIGNMENTS_F — The core HR assignment table. It stores the assignment records, effective dates, and termination-related fields against which reverse termination is validated. The package examines the assignment to confirm that a termination exists and that the reversal is valid for the assignment's effective-dated history.
• PER_ASSIGNMENT_STATUS_TYPES — The assignment status lookup table. It defines valid assignment statuses (for example, active, terminated, suspended). The package uses this table to determine the assignment's status and to ensure that the resulting status after reversal is legitimate under GB rules.

No other base tables are documented as referenced by this package.

Usage Notes

PER_GB_REVERSE_TERM_RULES is invoked indirectly through Oracle HRMS termination and reinstatement processing for GB legislation rather than being exposed as a standalone concurrent program. The ETRM dependency information shows that it is referenced by the package APPS.HR_EX_EMPLOYEE_BK4, indicating that it is called from Oracle's delivered HR business logic during employee and assignment processing. Because it is classified as an internal (OTHER) API, direct invocation from forms, concurrent programs, or custom code is not recommended. Developers who need to reverse a termination should use the supported Oracle HR APIs and forms, which apply this validation automatically. Direct calls risk bypassing GB-specific statutory checks and may leave assignment records in an inconsistent state.