Search Results get_assg_status

Overview

APPS.PAY_NO_HOLIDAY_PAY is a PL/SQL package within the Oracle E-Business Suite 12.1.1 and 12.2.2 payroll schema that supports holiday pay calculation logic, principally for legislative contexts (such as the United Kingdom) where statutory holiday pay entitlement is derived from earnings history, age thresholds, and assignment status. The package encapsulates a set of calculation and lookup functions rather than performing database DML as a public API; it is classified as OTHER in ETRM, indicating it is a supporting package rather than a formal public business API. The header comment (pynoholp.pkh 120.0.12000000.1, dated 2007) confirms it is part of the core payroll library shipped under the APPS schema. Its functions resolve the inputs required by holiday pay formulas — the "G" rate, employee age at a reference date, whether a payroll run is the final run of the holiday year, entitlement days, previous employer service, and assignment status — which are then consumed by Oracle Payroll fast formulas and payroll processes.

Key Procedures and Functions

• get_grate — Returns the G value used in holiday pay rate derivation, resolved by business group and effective date.
• get_age — Computes a person's age as at 31 August of the holiday year, based on the payroll process start date and date of birth.
• get_last_payroll — Determines whether the current payroll run is the last payroll run of the year, the condition under which holiday pay is recalculated over the age‑60 threshold. Returns a VARCHAR2 flag.
• get_assg_status — Returns the assignment status for a given assignment, evaluated over the payroll process period start and end dates within a business group. This is the function referenced by the search term "get_assg_status".
• get_entitlement_days — Returns entitlement days as at the last payroll run end date, returning both standard entitlement and entitlement over 60 through NOCOPY OUT parameters.
• get_prev_employer_days — Retrieves previous employer service days; the header notes Bug 5344736 added the assignment start date parameter.
• get_fixed_period — Determines the fixed period associated with a payroll and start date.
• get_hol_parameters — Fetches the holiday parameters required for holiday pay calculation (hourly/salaried code, holiday entitlement, holiday pay calculation basis) as IN OUT NOCOPY parameters.
• get_asg_start_date — Resolves the assignment start date used by other calculations.
• get_abs_hol_accr_entitl and get_holiday_pay_base_asg_run — Support absence/holiday accrual entitlement and holiday pay base calculation for an assignment run.

Tables Accessed

• PER_ALL_ASSIGNMENTS_F and PER_ALL_PEOPLE_F — Assignment and person records supplying status, dates of birth, and hire data.
• PER_PREVIOUS_EMPLOYERS — Prior employment service used by get_prev_employer_days.
• PER_TIME_PERIODS — Payroll period definitions supporting period start/end date logic.
• HR_ORGANIZATION_INFORMATION and HR_SOFT_CODING_KEYFLEX — Organisation and key flexfield attribute lookups.
• FF_GLOBALS_F and FF_USER_ENTITIES — Fast formula globals and user entity definitions used to resolve calculation constants.

Usage Notes

The package is not referenced by any other documented package, indicating it is invoked directly by Oracle Payroll fast formulas, payroll calculation routines, or the holiday pay concurrent/legislative processes rather than through a public API chain. Custom code should call the functions with validated business group, assignment, and date parameters, and should treat the package as read‑only. Because signatures are version‑specific (12.1.1 versus 12.2.2), integrations should confirm parameter definitions against the target instance before reuse.