1 package pay_fr_rebates AUTHID CURRENT_USER as
2 /* $Header: pyfrebat.pkh 115.7 2003/11/11 07:58:06 autiwari noship $ */
3 --
4 Procedure init_formula (p_formula_name in varchar2);
5 --
6 g_inputs ff_exec.inputs_t;
7 g_outputs ff_exec.outputs_t;
8 --
9 Function get_aubry_II_rebate (p_date_earned in date
10 ,p_assignment_id in number
11 ,p_process_type in varchar2
12 ,p_tax_unit_id in number
13 ,p_asg_action_id in number
14 ,p_business_group_id in number
15 ,p_aubry_I_used in varchar2
16 ,p_robien_used in varchar2
17 ,p_subject_to_ss_cont in number
18 ,p_hours_worked in number
19 ,p_sick_pay in number
20 ,p_absence_days in number
21 ,p_aubry_II_rebate out nocopy number
22 ,p_aubry_II_rebate_code out nocopy varchar2
23 ,p_aubry_II_contribution_id out nocopy number
24 ,p_aubry_II_zrr_rebate out nocopy number
25 ,p_aubry_II_zrr_rebate_code out nocopy varchar2
26 ,p_aubry_II_zrr_contribution_id out nocopy number
27 ,p_message out nocopy varchar2) return number;
28 --
29 Function get_aubry_I_rebate (p_date_earned in date
30 ,p_assignment_id in number
31 ,p_process_type in varchar2
32 ,p_tax_unit_id in number
33 ,p_mesg out nocopy varchar2
34 ,p_aubry_I_rebate out nocopy number
35 ,p_aubry_I_rebate_code out nocopy varchar2
36 ,p_aubry_I_contribution_id out nocopy number) return number;
37 --
38 Function get_robien_rebate (p_date_earned in date
39 ,p_assignment_id in number
40 ,p_process_type in varchar2
41 ,p_tax_unit_id in number
42 ,p_contributions_base in number
43 ,p_mesg out nocopy varchar2
44 ,p_robien_rebate out nocopy number
45 ,p_robien_rebate_code out nocopy varchar2
46 ,p_robien_rebate_rate out nocopy number
47 ,p_robien_contribution_id out nocopy number) return number;
48 --
49 Function get_part_time_rebate (p_date_earned in date
50 ,p_assignment_id in number
51 ,p_process_type in varchar2
52 ,p_tax_unit_id in number
53 ,p_contributions_base in number
54 ,p_mesg out nocopy varchar2
55 ,p_part_time_rebate out nocopy number
56 ,p_part_time_rebate_code out nocopy varchar2
57 ,p_part_time_contribution_id out nocopy number) return number;
58 --
59 Function get_ss_lower_rebate (p_date_earned in date
60 ,p_assignment_id in number
61 ,p_process_type in varchar2
62 ,p_tax_unit_id in number
63 ,p_business_group_id in number
64 ,p_salary in number
65 ,p_salary_excluding_absence in number
66 ,p_hours_worked in number
67 ,p_absence_days in number
68 ,p_mesg out nocopy varchar2
69 ,p_ss_lower_rebate out nocopy number
70 ,p_ss_lower_rebate_code out nocopy varchar2
71 ,p_ss_lower_contribution_id out nocopy number) return number;
72 --
73 Function valid_aubry_robien_dates (p_org_id in number,
74 p_information_type in varchar2,
75 p_date_from in date,
76 p_date_to in date default null) return varchar2;
77 --
78 Function contribution_info (p_date_earned in date
79 ,p_process_type in varchar2
80 ,p_element_name in varchar2
81 ,p_usage_type in varchar2
82 ,p_contribution_id out nocopy number
83 ,p_contribution_code out nocopy varchar2
84 ,mesg out nocopy varchar2) return number;
85 --
86 Function get_eligibility (p_date_earned in date
87 ,p_assignment_id in number
88 ,p_process_type in varchar2
89 ,p_tax_unit_id in number
90 ,p_asg_action_id in number
91 ,p_pay_action_id in number
92 ,p_aubry_II_used out nocopy varchar2
93 ,p_aubry_I_used out nocopy varchar2
94 ,p_robien_used out nocopy varchar2
95 ,p_part_time_used out nocopy varchar2
96 ,p_ss_lower_used out nocopy varchar2
97 ,p_mesg out nocopy varchar2
98 ,p_fillon_used out nocopy varchar2
99 ,p_fillon_mesg out nocopy varchar2
100 ,p_director_mesg out nocopy varchar2
101 ,p_fillon_part_time_mesg
102 out nocopy varchar2) return number;
103 --
104 Function get_prev_asg_hours (p_assignment_id in number
105 ,p_payroll_action_id in number
106 ,p_process_type in varchar2
107 ,p_tax_unit_id in number) return number;
108 --
109 end pay_fr_rebates;