Search Results get_long_service_leave

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

• GET_LONG_SERVICE_LEAVE — Retrieves long service leave entitlement values for an assignment.
• OVERRIDE_ELIG — Applies an eligibility override during termination processing.
• PROCESSED — Signals or checks whether a termination-related process or record has already been processed.
• GET_ACCRUAL_PLAN_BY_CATEGORY — Returns the applicable accrual plan based on accrual category.
• CALCULATE_MARGINAL_TAX — Computes marginal tax on termination amounts.
• MAX_ETP_TAX_FREE — Determines the maximum ETP tax-free component.
• CHECK_ROLLOVER — Validates rollover eligibility for ETP amounts.
• ETP_PREPOST_RATIOS — Derives pre/post termination ETP ratio splits.
• TERM_LSL_ELIGIBILITY_YEARS — Returns long service leave eligibility years.
• DECLARATION — Supports termination declaration processing.
• GET_TOTAL_ACCRUAL_HOURS — Returns total accrual hours for an assignment.
• CALCULATE_ETP_TAX and CALCULATE_ETP_TAX_2010 — Compute ETP tax under current and 2010-legislative rules.
• GET_FIN_YEAR_END — Returns the financial year end date relevant to termination tax.
• GET_PREV_AGE — Returns the employee's age at a prior reference point.
• AU_CHECK_TRANS — Performs Australian-specific validation checks on transactions.
• CALCULATE_ETP_LUMPSUM_D_2010 — Computes lump-sum D ETP amounts under 2010 rules.
• GET_FOREIGN_ACCRUAL — Retrieves foreign service accrual amounts.
• GET_DAYS_PPL_SUSPENDED — Returns days of paid parental leave suspended.
• AU_COUNT_ETPS_SIL — Counts ETPs associated with salary-in-lieu processing.

Tables Accessed

• PER_ALL_ASSIGNMENTS_F — Assignment details driving termination eligibility and dates.
• HR_ALL_ORGANIZATION_UNITS — Organizational context for the terminating assignment.
• PAY_BALANCE_TYPES, PAY_DEFINED_BALANCES, PAY_BALANCE_DIMENSIONS, PAY_BALANCE_PKG — Balance definitions and values used in accrual and leave calculations.
• PAY_ACCRUAL_PLANS — Accrual plan configuration for leave entitlement.
• PAY_ELEMENT_TYPES_F, PAY_ELEMENT_LINKS_F, PAY_ELEMENT_CLASSIFICATIONS, PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_ENTRY_VALUES_F, PAY_INPUT_VALUES_F, PAY_ASSIGNMENT_ACTIONS — Element structure, inputs, and entries used to derive and post termination payments.
• FF_GLOBALS_F and HR_SOFT_CODING_KEYFLEX — Fast Formula globals and soft coding used for costing and rule evaluation.

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.