1 PACKAGE pay_no_holiday_pay AS
2 /* $Header: pynoholp.pkh 120.0.12000000.1 2007/05/22 07:56:31 rajesrin noship $ */
3
4 -- Function to get the G value.
5 FUNCTION get_grate(p_business_group_id IN NUMBER, p_effective_date IN DATE) RETURN NUMBER;
6
7 --Funtion to get the age of a person as on 31-AUG of the holiday year.
8 FUNCTION get_age(p_payroll_proc_start_date IN DATE, p_date_of_birth IN DATE) RETURN NUMBER;
9
10 /* Function to whether the payroll run is the last payroll run of the year in order
11 recalulate the holiday pay over 60*/ FUNCTION get_last_payroll(p_payroll_id IN NUMBER, p_pay_proc_period_end_date IN DATE) RETURN VARCHAR2;
12
13 -- Function to get the assignments status.
14 FUNCTION get_assg_status(p_business_group_id IN NUMBER, p_asg_id IN NUMBER, p_pay_proc_period_start_date IN DATE, p_pay_proc_period_end_date IN DATE) RETURN VARCHAR2;
15
16 -- Function to get the entitlement days as years last payroll run end date.
17 FUNCTION get_entitlement_days(p_business_group_id IN NUMBER, p_asg_id IN NUMBER, p_tax_unit_id IN NUMBER, p_effective_date IN DATE, p_above_60 IN VARCHAR2, p_entit_days OUT nocopy NUMBER,
18 p_entit_days_over_60 OUT nocopy NUMBER) RETURN NUMBER;
19
20 -- Function to get the previous employer details.
21 /* Bug 5344736 fix - Adding assignment start date parameter*/
22 FUNCTION get_prev_employer_days(p_business_group_id IN NUMBER, p_assg_id IN NUMBER, p_emp_hire_date IN DATE, p_asg_start_date IN DATE) RETURN NUMBER;
23
24 -- Function to get the fixed period for a payroll.
25 FUNCTION get_fixed_period(p_payroll_id IN NUMBER, p_start_date IN DATE) RETURN NUMBER;
26
27 -- Function to get the holiday details required for hoiliday pay calculation.
28 FUNCTION get_hol_parameters(p_bus_group_id IN NUMBER, p_assignment_id IN NUMBER, p_date_earned IN DATE, p_tax_unit_id IN NUMBER, p_hourly_salaried_code IN OUT nocopy VARCHAR2, p_holiday_entitlement IN OUT nocopy VARCHAR2,
29 p_holiday_pay_calc_basis IN OUT nocopy VARCHAR2, p_holiday_pay_in_fixed_period IN OUT nocopy VARCHAR2, p_hol_pay_over60_in_fix_period IN OUT nocopy VARCHAR2, p_holiday_pay_to_be_adjusted IN OUT nocopy VARCHAR2,
30 p_res_hol_pay_to_6g_for_over60 IN OUT nocopy VARCHAR2) RETURN NUMBER;
31
32 -- Function to get the assignment start date.
33
34 /*Bug 5334894 fix- Added a new function to get the assignment start date*/
35 FUNCTION get_asg_start_date(p_business_group_id IN NUMBER, p_assignment_id IN NUMBER, p_asg_start_date OUT nocopy DATE) RETURN NUMBER;
36
37 --Function to get the accrual act information from absence details
38 FUNCTION get_abs_hol_accr_entitl (p_bus_group_id IN NUMBER, p_assignment_id IN NUMBER, p_date_earned IN DATE, p_tax_unit_id IN NUMBER
39 , p_hol_accrual_entit OUT nocopy VARCHAR2) RETURN NUMBER;
40
41 END;