Results for “get_leave_initialise”

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

Overview

APPS.HR_AU_HOLIDAYS is an Oracle E-Business Suite PL/SQL package that encapsulates Australian (AU) Human Resources and Payroll leave accrual logic for the Oracle HRMS localization. Although its name suggests holiday processing, the package actually provides the server-side calculation engine for Australian statutory leave entitlements—annual leave, personal/carer's leave, and Long Service Leave (LSL)—together with the accrual plan lookups and period validation utilities that those entitlements depend upon. It is a long-standing component: the source header identifies the file as hrauhol.pkh, originally shipped in 2000 and based on the equivalent New Zealand package hrnzhol.pkh, with a change list running from version 115.1 (January 2000) through 120.0.12000000.1 (January 2007).

The package is classified as an "OTHER" API in ETRM rather than as a public, supported interface, meaning it is primarily an internal implementation layer consumed by Oracle's own localization code. It exposes fourteen documented procedures and functions and is referenced by six other packages within the AU HRMS/Payroll codebase, confirming its role as a shared accrual service rather than an end-user-facing API.

Key Procedures and Functions

The documented entry points fall into five logical groups:

• Accrual plan resolution: GET_ACCRUAL_PLAN_BY_CATEGORY returns the accrual plan applicable to an assignment for a given plan category and effective date. GET_ANNUAL_LEAVE_PLAN is the specialised lookup used by annual leave processing. VALIDATE_ACCRUAL_PLAN_NAME checks that a supplied plan name is valid before it is used. SET_ACCRUAL_IDS establishes the internal plan, band, and element identifiers required by subsequent accrual calculations within a session.
• Accrual calculation: GET_NET_ACCRUAL is a wrapper around the PER_ACCRUAL_CALC_FUNCTIONS.GET_NET_ACCRUAL procedure, and the change list explicitly notes that the wrapper exists so that a FastFormula function can be registered for use in payroll formulas. GET_ACCRUAL_ENTITLEMENT simplifies the determination of entitlement for calls originating from the accrual and absence forms. ACCRUAL_DAILY_BASIS converts accrual rates to a daily basis.
• Continuous service and Long Service Leave: GET_CONTINUOUS_SERVICE_DATE and GET_LSL_ENTITLEMENT_DATE support LSL eligibility, which under Australian state legislation depends on years of continuous service. The change list records that terminal LSL eligibility years logic was later moved out to PAY_AU_TERMINATIONS.
• Absence and suspension handling: DAYS_SUSPENDED and ADJUST_FOR_SUSPEND_ASSIGN support the treatment of periods during which an assignment is suspended, adjusting accrual accordingly.
• Validation and initialisation: CHECK_PERIODS validates time periods used in accrual processing, GET_LEAVE_INITIALISE initialises leave processing (added under Bug 1942971), and AU_GET_ENROLLMENT_STARTDATE returns the enrolment start date used when an employee is brought into an accrual plan.

Tables Accessed

The package reads and in some cases writes through APPS synonyms. Accrual plan configuration is drawn from PAY_ACCRUAL_PLANS and PAY_ACCRUAL_BANDS. Payroll element configuration is read from PAY_ELEMENT_TYPES_F, PAY_ELEMENT_LINKS_F, and PAY_INPUT_VALUES_F, while accrual results and inputs are read from and written to the date-effective tables PAY_ELEMENT_ENTRIES_F and PAY_ELEMENT_ENTRY_VALUES_F. Assignment and service data come from PER_ALL_ASSIGNMENTS_F, PER_ASSIGNMENT_STATUS_TYPES, and PER_PERIODS_OF_SERVICE. Period validation relies on PER_TIME_PERIODS and PER_TIME_PERIOD_TYPES. PLITBLM is used as the PL/SQL index-by table type for bulk operations, consistent with Oracle HRMS coding standards of the period.

Usage Notes

HR_AU_HOLIDAYS is not normally called directly by customers. It is invoked by the Australian accrual and absence forms, by payroll FastFormulas that require net accrual or entitlement values, and by the other AU localization packages that reference it. Because it is classified as "OTHER" and not part of a supported public API, extensions or customisations should avoid direct calls; implementers requiring similar behaviour should call the supported PER_ACCRUAL_CALC_FUNCTIONS interfaces or configure accrual plans in the standard setup screens instead.

Regarding the search phrase "IBM holiday list 2025": this package contains no holiday calendar data, and no IBM-specific or year-specific holiday list exists within it. Australian public holiday calendars in EBS are maintained as HRMS holiday records associated with a location or business group, not inside HR_AU_HOLIDAYS. A 2025 holiday list for a specific employer such as IBM would be maintained as customer setup data, not as seeded Oracle code.