1 PACKAGE pay_hk_mpf AUTHID CURRENT_USER AS
2 /* $Header: pyhkudfs.pkh 120.3 2010/04/27 04:10:59 jalin ship $ */
3 FUNCTION get_retro_mpf(p_bus_grp_id in NUMBER,
4 p_assignment_id in NUMBER,
5 p_date_from in DATE,
6 p_date_to in DATE,
7 p_pay_basis in VARCHAR2,
8 p_percentage in NUMBER,
9 p_calc_method in VARCHAR2,
10 p_hire_date in DATE,
11 p_min_birthday in DATE,
12 p_ER_Liability_Start_Date in DATE,
13 p_EE_Deductions_Start_Date in DATE,
14 p_Contributions_End_Date in DATE,
15 p_value1 out nocopy number,
16 p_value2 out nocopy number,
17 p_start_date1 out nocopy date,
18 p_start_date2 out nocopy date,
19 p_end_date1 out nocopy date,
20 p_end_date2 out nocopy date) RETURN NUMBER;
21 --
22
23 FUNCTION hk_scheme_val(p_bus_grp_id in NUMBER,
24 p_assignment_id in NUMBER,
25 p_entry_value in VARCHAR2)
26 RETURN VARCHAR2;
27 --
28 FUNCTION hk_quarters_val(p_bus_grp_id in NUMBER,
29 p_assignment_id in NUMBER,
30 p_entry_value in VARCHAR2)
31 RETURN VARCHAR2;
32 --
33 /* Bug:3333006. Added the following function */
34 FUNCTION get_act_termination_date
35 (p_assignment_id in per_all_assignments_f.assignment_id%type,
36 p_date in date)
37 RETURN DATE;
38 --
39 END pay_hk_mpf;