Results for “pay_au_term_rep”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The APPS.PAY_AU_TERM_REP package is a PL/SQL reporting utility that belongs to the Australian localisation of Oracle Payroll within Oracle E-Business Suite. Its primary business function is to supply the calculation and data-retrieval logic required by the Australian Termination Report, which employers must produce when an employee's employment ceases. The package encapsulates the logic needed to determine Employment Termination Payment (ETP) amounts, pre-payment (accrued) balances, invalidity pay components, and the pre-tax and post-tax split of ETP components, including superannuation rollover treatment.

The package is declared as AUTHID CURRENT_USER, meaning that its SQL statements execute with the privileges of the invoking user rather than the definer. It has been maintained continuously since its creation in November 2000, with change history reflecting a series of statutory updates — notably multiple-ETP impact (Bug#6470561), ETP superannuation rollover changes (Bug#8769345), pre-tax salary-in-lieu treatment (Bug#12583457), and the introduction of an ETP type parameter (Bug#14358180). These updates demonstrate that the package tracks changes to Australian Taxation Office (ATO) termination payment rules.

Key Procedures and Functions

• ETP_PAYMENT_INFORMATION — Returns the Employment Termination Payment information required to populate the termination report. It assembles the taxable and tax-free components of the ETP and has been extended over time to accept ETP pre-tax salary-in-lieu and ETP type parameters.
• ETP_PREPAYMENT_INFORMATION — Returns ETP information relating to prepayment (amounts paid or accrued prior to the termination event). An invalidity component parameter was added, and additional output parameters were introduced to support the pre/post ETP structure.
• GET_INVALIDITY_PAY_BAL — Retrieves invalidity-related pay balances. This function supports the treatment of termination payments made on the grounds of invalidity, which attract different tax treatment from ordinary ETPs.
• GET_ETP_PRE_POST_COMPONENTS — Derived from statutory ETP superannuation rollover changes, this function separates ETP amounts into pre- and post-components, enabling correct classification and rollover treatment.

Tables Accessed

The package reads payroll and assignment data through APPS synonyms, including:

• PAY_ASSIGNMENT_ACTIONS and PAY_PAYROLL_ACTIONS — to identify the termination event and its associated payroll action.
• PAY_RUN_RESULTS and PAY_RUN_RESULT_VALUES — to obtain calculated payroll values for the affected assignment.
• PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_TYPES_F, PAY_INPUT_VALUES_F, and PAY_BALANCE_TYPES — to resolve element definitions, input values, and balance classifications such as invalidity balances.

Usage Notes

PAY_AU_TERM_REP is typically invoked indirectly rather than directly by end users. It is called from the Australian Termination Report concurrent program and from payroll termination formulas that require report-level detail. No other packages reference it, so its callers are Oracle Applications components and, in customisations, bespoke report or formula code built for Australian payroll. It is most relevant during employee termination processing in EBS 12.1.1 and 12.2.2, particularly where ETP classification and statutory rollover reporting are required.