1 PACKAGE pay_no_holiday_pay AUTHID CURRENT_USER AS
2 /* $Header: pynoholp.pkh 120.0.12020000.2 2012/09/21 11:21:41 mkuppuch ship $ */
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 --Function to get holiday_pay_base_asg_run value
42 FUNCTION get_holiday_pay_base_asg_run
43 (p_assignment_action_id IN number
44 , p_payroll_action_id IN number
45 , p_business_group_id IN number
46 , p_effective_date DATE
47 , p_entity_name IN varchar2) RETURN number;
48
49 END;
[Home] [Help]