Search Results pay_au_terminations




Overview
Explore in AI Chat

Overview

PAY_AU_TERMINATIONS is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that encapsulates the Australian payroll termination and Employment Termination Payment (ETP) calculations delivered with Oracle Payroll. Its primary business function is to compute the entitlements, accruals, leave payouts, and statutory tax treatment that apply when an Australian employee's assignment is terminated. The package centralizes logic for long service leave, ETP components, marginal tax rates, and ETP tax-free thresholds, providing a single reusable programmatic entry point for termination processing rather than relying on duplicated rule logic inside payroll formulas.

The package is classified as OTHER in the Oracle ETRM registry, is marked VALID, and exposes 22 documented procedures and functions. It is referenced by nine other packages, including PAY_AU_PAYMENT_SUMMARY, PAY_AU_RECON_SUMMARY, PAY_AU_REC_DET_PAYSUM_MODE, PAY_AU_TERM_REP, and the termination views PAY_AU_TERM_ANNUAL_V, PAY_AU_TERM_ETP_V, PAY_AU_TERM_LONG_V, and PAY_AU_TERM_SUPER_V.

Key Procedures and Functions

Tables Accessed

Usage Notes

PAY_AU_TERMINATIONS is invoked indirectly through Australian payroll termination processing, typically triggered by payroll run elements, the termination concurrent processes, and termination reports such as PAY_AU_TERM_REP. It also supports the termination views and downstream reconciliation and payment summary packages. Custom code should treat it as a library of calculation utilities and call it only from within APPS-owned PL/SQL, respecting the documented input and return semantics. Because tax legislation changes are versioned inside the package (for example the 2010 ETP functions), implementations on 12.1.1 and 12.2.2 should verify that patch levels include the required legislative variants before relying on a given function.