Results for “get_acp_start_date”

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

Overview

APPS.HR_NZ_HOLIDAYS is a New Zealand–specific Oracle HRMS payroll package body that encapsulates the statutory and payroll logic required to calculate annual leave accrual, entitlement, and end-of-year (EOY) adjustments for NZ-based employees. It forms part of the localization layer that extends Oracle Payroll for New Zealand legislative requirements, including the Holidays Act obligations around continuous service, anniversary-based entitlement, parental leave treatment, and average weekly earnings. The package is owned by APPS and is classified as OTHER in the ETRM API catalogue for Oracle EBS 12.1.1 and 12.2.2. Its header dates to the late 1990s, with documented change activity between 2002 and 2005 addressing retro-dated adjustments, parental leave handling, and the migration of net entitlement logic to the successor package PAY_NZ_HOLIDAYS. It exposes approximately 30 documented procedures and functions and is referenced by six other packages, indicating that it sits at the centre of the NZ absence and accrual calculation model rather than acting as a standalone utility.

Key Procedures and Functions

The documented units divide into three functional groups. Accrual and entitlement calculation is handled by GET_ACCRUAL_ENTITLEMENT, GET_NET_ACCRUAL, ANNUAL_LEAVE_NET_ENTITLEMENT, GET_NET_ENTITLEMENT, GET_ANNUAL_ENTITLEMENT, GET_ANNUAL_LEAVE_TAKEN, ANNUAL_LEAVE_ENTITLED_TO_PAY, and ANNUAL_LEAVE_EOY_ADJUSTMENT. Of these, GET_NET_ENTITLEMENT was subsequently redirected to the newer PAY_NZ_HOLIDAYS package, and several redundant procedures in the original body were nulled out. ANNUAL_LEAVE_EOY_ADJUSTMENT returns a negative end-of-year adjustment value.

• Plan and period derivation: GET_ACCRUAL_PLAN_BY_CATEGORY, GET_ANNUAL_LEAVE_PLAN, GET_ACP_START_DATE, CHECK_PERIODS, and GET_WEEKDAYS_IN_PERIOD establish the accrual plan applicable to an assignment and the working-day count within a pay period.
• Service and eligibility dating: GET_CONTINUOUS_SERVICE_DATE, GET_ANNIVERSARY_DATE, GET_LAST_ANNIVERSARY, and GET_LEAP_YEAR_MON determine the employee's qualifying service dates from which entitlement is measured.
• Supporting calculations: CALL_ACCRUAL_FORMULA, NUM_WEEKS_FOR_AVG_EARNINGS, GET_AR_ELEMENT_DETAILS, and CHECK_RETRO_EOY (added 2003) support formula invocation, average earnings determination, element detail retrieval, and detection of leaves retroactively applied across an EOY boundary.

The GET_ADJUSTMENT_VALUES logic remains notable for returning adjustment element entries whose effective start date falls outside the accrual period, a change introduced to correct accrual reporting accuracy.

Tables Accessed

All access is through APPS synonyms. Assignment and person context is drawn from PER_ALL_ASSIGNMENTS_F. Accrual configuration is read from PAY_ACCRUAL_PLANS and PAY_ACCRUAL_BANDS, while payroll and run context come from PAY_ALL_PAYROLLS_F, PAY_PAYROLL_ACTIONS, PAY_ASSIGNMENT_ACTIONS, PAY_RUN_RESULTS, and PAY_RUN_RESULT_VALUES. Element definition, linkage, and entry data are read from PAY_ELEMENT_TYPES_F, PAY_ELEMENT_LINKS_F, PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_ENTRY_VALUES_F, PAY_INPUT_VALUES_F, and PAY_BALANCE_TYPES. HR_SOFT_CODING_KEYFLEX supplies costing information used in adjustment and accrual postings. These objects are predominantly read; element entry and run result tables represent the primary points at which the package influences payroll outcomes.

Usage Notes

HR_NZ_HOLIDAYS is invoked indirectly rather than as a user-facing API. Typical call paths include NZ HRMS forms that display leave balances and entitlement, payroll accrual and EOY concurrent processes, and payroll formulas that call package functions such as CALL_ACCRUAL_FORMULA during a payroll run. The package is also referenced by six other packages, so customizations should avoid direct modification and instead consume the documented entry points, respecting the NOCOPY conventions applied to OUT and IN OUT parameters. Because entitlement logic has been partly migrated to PAY_NZ_HOLIDAYS, developers extending NZ leave functionality should confirm which package is authoritative for a given calculation before building customisations in 12.1.1 or 12.2.2.