1 PACKAGE pay_es_ss_calculation AUTHID CURRENT_USER as
2 /* $Header: pyesssdc.pkh 120.4 2005/08/08 07:16:25 grchandr noship $ */
3 --
4 FUNCTION get_assignment_info(p_assignment_id IN NUMBER
5 ,p_effective_date IN DATE
6 ,p_Contribution_grp OUT NOCOPY VARCHAR2
7 ,p_work_center OUT NOCOPY NUMBER
8 ,p_35_yrs_ss OUT NOCOPY VARCHAR2
9 ,p_seniority_yrs OUT NOCOPY NUMBER
10 ,p_date IN DATE) RETURN NUMBER;
11 --
12 FUNCTION get_absence_days(p_assignment_id IN NUMBER
13 ,p_business_group_id IN NUMBER
14 ,p_effective_date IN DATE
15 ,p_period_start_date IN DATE
16 ,p_period_end_date IN DATE
17 ,p_leave_type IN VARCHAR2
18 ,p_work_pattern IN VARCHAR2) RETURN NUMBER;
19 --
20 FUNCTION get_absence_Hours(p_assignment_id IN NUMBER
21 ,p_business_group_id IN NUMBER
22 ,p_effective_date IN DATE
23 ,p_period_start_date IN DATE
24 ,p_period_end_date IN DATE
25 ,p_leave_type IN VARCHAR2) RETURN NUMBER;
26 --
27 FUNCTION get_working_time(p_assignment_id IN NUMBER
28 ,p_business_group_id IN NUMBER
29 ,p_period_start_date IN DATE
30 ,p_period_end_date IN DATE
31 ,p_working_days OUT NOCOPY NUMBER
32 ,p_working_hours OUT NOCOPY NUMBER) RETURN NUMBER;
33 --
34 FUNCTION get_work_center_info(p_business_gr_id IN NUMBER
35 ,p_work_center IN NUMBER
36 ,p_info1 OUT NOCOPY VARCHAR2
37 ,p_info2 OUT NOCOPY VARCHAR2
38 ,p_info3 OUT NOCOPY VARCHAR2
39 ,p_info4 OUT NOCOPY VARCHAR2
40 ,p_info5 OUT NOCOPY VARCHAR2
41 ,p_info6 OUT NOCOPY VARCHAR2
42 ,p_info7 OUT NOCOPY VARCHAR2
43 ,p_info8 OUT NOCOPY VARCHAR2
44 ,p_info9 OUT NOCOPY VARCHAR2
45 ,p_info10 OUT NOCOPY VARCHAR2) RETURN NUMBER;
46 --
47 FUNCTION get_legal_employer_info(p_business_gr_id IN NUMBER
48 ,p_effective_date IN DATE
49 ,p_assignment_id IN NUMBER
50 ,p_work_center IN NUMBER
51 ,p_period_start_date IN DATE
52 ,p_period_end_date IN DATE
53 ,p_ss_type IN VARCHAR2
54 ,p_td_flag OUT NOCOPY VARCHAR2
55 ,p_td_rebate_days OUT NOCOPY NUMBER
56 ,p_le_td_perc OUT NOCOPY NUMBER
57 ,p_ss_td_perc OUT NOCOPY NUMBER
58 ,p_exempt_flag OUT NOCOPY VARCHAR2
59 ,p_exempt_days OUT NOCOPY NUMBER
60 ,p_le_exempt_perc OUT NOCOPY NUMBER
61 ,p_emp_exempt_perc OUT NOCOPY NUMBER
62 ,p_tot_days IN NUMBER
63 ,p_contract_type IN VARCHAR2) RETURN NUMBER;
64 --
65 FUNCTION get_trng_hours(p_business_gr_id IN NUMBER
66 ,p_assignment_id IN NUMBER
67 ,p_effective_date IN DATE
68 ,p_in_class_trng_hours OUT NOCOPY NUMBER
69 ,p_remote_trng_hours OUT NOCOPY NUMBER) RETURN NUMBER;
70 --
71 FUNCTION get_defined_bal_id(p_bal_name IN VARCHAR2
72 ,p_db_item_suffix IN VARCHAR2) RETURN NUMBER;
73 --
74 FUNCTION get_prev_salary(p_assignment_action_id IN NUMBER
75 ,p_balance_name IN VARCHAR2
76 ,p_database_item_suffix IN VARCHAR2
77 ,p_period_start_date IN DATE
78 ,p_no_month IN NUMBER
79 ,p_flag IN VARCHAR2
80 ,p_context IN VARCHAR2
81 ,p_context_val IN VARCHAR2
82 ,p_days IN OUT NOCOPY NUMBER) RETURN NUMBER;
83 --
84 FUNCTION get_row_value(p_effective_date IN DATE
85 ,p_reduction_id IN VARCHAR2
86 ,p_duration IN NUMBER) RETURN VARCHAR2;
87 --
88 FUNCTION get_input_value(p_assignment_id IN NUMBER
89 ,p_effective_date IN DATE
90 ,p_no_ptm_days OUT NOCOPY NUMBER
91 ,p_no_ptm_hours OUT NOCOPY NUMBER
92 ,p_no_partial_strike_days OUT NOCOPY NUMBER
93 ,p_no_partial_strike_hours OUT NOCOPY NUMBER
94 ,p_active_without_pay_days OUT NOCOPY NUMBER
95 ,p_active_without_pay_hours OUT NOCOPY NUMBER
96 ,p_rec_start_date IN DATE
97 ,p_rec_end_date IN DATE
98 ,p_cac IN VARCHAR2
99 ,p_epigraph_code IN VARCHAR2
100 ,p_period_end_date IN DATE) RETURN NUMBER;
101 --
102 FUNCTION get_table_value(bus_group_id IN NUMBER
103 ,ptab_name IN VARCHAR2
104 ,pcol_name IN VARCHAR2
105 ,prow_value IN VARCHAR2
106 ,peffective_date IN DATE )RETURN NUMBER;
107 --
108 FUNCTION get_org_context_info(p_assignment_id IN NUMBER
109 ,p_business_group_id IN NUMBER
110 ,p_work_center IN NUMBER
111 ,p_context IN VARCHAR2
112 ,p_period_start_date IN DATE
113 ,p_period_end_date IN DATE
114 ,p_tot_days IN NUMBER
115 ,p_contract_type IN VARCHAR2) RETURN NUMBER;
116 --
117 FUNCTION write_cac_epigraph_chg_table(p_assignment_id NUMBER
118 ,p_effective_date DATE
119 ,p_business_group_id NUMBER
120 ,p_period_start_date DATE
121 ,p_period_end_date DATE
122 ,p_contract_type VARCHAR2
123 ,p_hire_date DATE
124 ,p_end_date DATE) RETURN NUMBER;
125 --
126 FUNCTION read_cac_epigraph_chg_table(p_assignment_id IN NUMBER
127 ,p_cac IN OUT NOCOPY VARCHAR2
128 ,p_epigraph IN OUT NOCOPY VARCHAR2
129 ,p_epigraph_114 IN OUT NOCOPY VARCHAR2
130 ,p_epigraph_126 IN OUT NOCOPY VARCHAR2
131 ,p_days IN OUT NOCOPY NUMBER
132 ,p_start_date IN OUT NOCOPY DATE
133 ,p_end_date IN OUT NOCOPY DATE
134 ,p_no_ptm_days IN OUT NOCOPY NUMBER
135 ,p_no_ptm_hours IN OUT NOCOPY NUMBER
136 ,p_no_partial_strike_days IN OUT NOCOPY NUMBER
137 ,p_no_partial_strike_hours IN OUT NOCOPY NUMBER
138 ,p_active_without_pay_days IN OUT NOCOPY NUMBER
139 ,p_active_without_pay_hours IN OUT NOCOPY NUMBER
140 ,p_curr_index IN OUT NOCOPY NUMBER
141 ,p_next_epigraph IN OUT NOCOPY VARCHAR2
142 ,p_next_cac IN OUT NOCOPY VARCHAR2
143 ,p_days_worked IN OUT NOCOPY NUMBER
144 ,p_td_days IN OUT NOCOPY NUMBER
145 ,p_tot_days IN OUT NOCOPY NUMBER
146 ,p_pu_days IN OUT NOCOPY NUMBER) RETURN NUMBER;
147 --
148 FUNCTION read_table_index_values(p_assignment_id IN NUMBER
149 ,p_index IN NUMBER
150 ,p_cac IN OUT NOCOPY VARCHAR2
151 ,p_epigraph IN OUT NOCOPY VARCHAR2
152 ,p_epigraph_114 IN OUT NOCOPY VARCHAR2
153 ,p_epigraph_126 IN OUT NOCOPY VARCHAR2
154 ,p_days IN OUT NOCOPY NUMBER
155 ,p_start_date IN OUT NOCOPY DATE
156 ,p_end_date IN OUT NOCOPY DATE
157 ,p_no_ptm_days IN OUT NOCOPY NUMBER
158 ,p_no_ptm_hours IN OUT NOCOPY NUMBER
159 ,p_no_partial_strike_days IN OUT NOCOPY NUMBER
160 ,p_no_partial_strike_hours IN OUT NOCOPY NUMBER
161 ,p_active_without_pay_days IN OUT NOCOPY NUMBER
162 ,p_active_without_pay_hours IN OUT NOCOPY NUMBER
163 ,p_days_worked IN OUT NOCOPY NUMBER
164 ,p_td_days IN OUT NOCOPY NUMBER
165 ,p_tot_days IN OUT NOCOPY NUMBER
166 ,p_pu_days IN OUT NOCOPY NUMBER) RETURN NUMBER;
167 --
168 FUNCTION read_table_index(p_next_epigraph IN OUT NOCOPY VARCHAR2
169 ,p_next_cac IN OUT NOCOPY VARCHAR2) RETURN NUMBER;
170 --
171 FUNCTION get_prev_base(p_assignment_action_id IN NUMBER
172 ,p_balance_name IN VARCHAR2
173 ,p_database_item_suffix IN VARCHAR2
174 ,p_period_start_date IN DATE
175 ,p_no_month IN NUMBER
176 ,p_flag IN VARCHAR2
177 ,p_context IN VARCHAR2
178 ,p_context_val IN VARCHAR2
179 ,p_ss_days IN OUT NOCOPY NUMBER
180 ,p_days IN OUT NOCOPY NUMBER) RETURN NUMBER;
181 --
182 END pay_es_ss_calculation;