1 PACKAGE pay_fi_general AS
2 /* $Header: pyfigenr.pkh 120.11.12010000.1 2008/07/27 22:36:52 appldev ship $ */
3
4 --
5 TYPE fi_cache_rec IS RECORD
6 ( cache_code VARCHAR2(30),
7 cache_value VARCHAR2(240) );
8
9 TYPE fi_cache_table IS TABLE OF
10 fi_cache_rec
11 INDEX BY BINARY_INTEGER;
12 g_fi_cache_table fi_cache_table;
13
14 FUNCTION get_accrual_status
15 (p_time_definition_id IN NUMBER
16 ,p_balance_date IN DATE
17 ,p_payroll_start_date IN DATE
18 ,p_payroll_end_date IN DATE
19 ) RETURN NUMBER;
20
21 FUNCTION get_holiday_pay_accr_override
22 (p_assignment_id NUMBER
23 , p_effective_date DATE
24 , p_holiday_days OUT NOCOPY NUMBER
25 , p_holiday_compensation OUT NOCOPY NUMBER
26 , p_holiday_pay_reserve OUT NOCOPY NUMBER
27 , p_working_days OUT NOCOPY NUMBER
28 , p_working_hours OUT NOCOPY NUMBER
29 ) RETURN NUMBER ;
30
31 FUNCTION get_holiday_pay_entitle_over
32 (p_assignment_id NUMBER
33 , p_effective_date DATE
34 , p_summer_holiday_days OUT NOCOPY NUMBER
35 , p_winter_holiday_days OUT NOCOPY NUMBER
36 , p_holiday_pay OUT NOCOPY NUMBER
37 , p_holiday_compensation OUT NOCOPY NUMBER
38 , p_carryover_holiday_days OUT NOCOPY NUMBER
39 , p_carryover_holiday_pay OUT NOCOPY NUMBER
40 , p_carryover_holiday_compen OUT NOCOPY NUMBER
41 , p_average_hourly_pay OUT NOCOPY NUMBER
42 , p_average_daily_pay OUT NOCOPY NUMBER
43 ) RETURN NUMBER ;
44
45 function run_holiday_pay_entitlement
46 (p_assignment_id IN NUMBER
47 ,p_date_earned IN DATE
48 ,p_business_group_id IN NUMBER
49 ,p_payroll_id IN NUMBER
50 ,p_payroll_action_id IN NUMBER
51 ,p_assignment_action_id IN NUMBER
52 ,p_tax_unit_id IN NUMBER
53 ,p_element_entry_id IN NUMBER
54 ,p_element_type_id IN NUMBER
55 ,p_original_entry_id IN NUMBER
56 ,p_balance_date IN DATE
57 , p_summer_holiday_days OUT NOCOPY NUMBER
58 , p_winter_holiday_days OUT NOCOPY NUMBER
59 , p_holiday_pay OUT NOCOPY NUMBER
60 , p_holiday_compensation OUT NOCOPY NUMBER
61 , p_carryover_holiday_days OUT NOCOPY NUMBER
62 , p_carryover_holiday_pay OUT NOCOPY NUMBER
63 , p_carryover_holiday_compen OUT NOCOPY NUMBER
64
65 )
66 return NUMBER;
67
68 function run_holiday_pay_formula
69 (p_assignment_id IN NUMBER
70 ,p_date_earned IN DATE
71 ,p_business_group_id IN NUMBER
72 ,p_payroll_id IN NUMBER
73 ,p_payroll_action_id IN NUMBER
74 ,p_assignment_action_id IN NUMBER
75 ,p_tax_unit_id IN NUMBER
76 ,p_element_entry_id IN NUMBER
77 ,p_element_type_id IN NUMBER
78 ,p_original_entry_id IN NUMBER
79 ,p_balance_date IN DATE
80 ,p_holiday_days OUT NOCOPY NUMBER
81 ,p_holiday_compensation OUT NOCOPY NUMBER
82 ,p_holiday_pay_reserve OUT NOCOPY NUMBER
83 ,p_working_days OUT NOCOPY NUMBER
84 ,p_working_hours OUT NOCOPY NUMBER
85 )
86 return NUMBER ;
87
88 function element_exist(p_assignment_id in number ,p_date_earned in date,p_element_name in varchar2 ) return number ;
89 FUNCTION calc_sch_based_dur ( p_assignment_id IN NUMBER,
90 p_days_or_hours IN VARCHAR2,
91 -- p_include_event IN VARCHAR2 DEFAULT 'Y',
92 p_date_start IN DATE,
93 p_date_end IN DATE,
94 p_time_start IN VARCHAR2,
95 p_time_end IN VARCHAR2,
96 p_duration IN OUT NOCOPY NUMBER
97 ) RETURN NUMBER ;
98
99
100 /*FUNCTION get_working_time
101 (p_time_definition_id IN NUMBER
102 , p_assignment_id in number
103 ,p_payroll_start_date IN DATE
104 ,p_payroll_end_date IN DATE
105 ,p_working_days out number
106 ,p_working_hours out number
107 ) RETURN NUMBER;
108
109 */
110 FUNCTION get_input_value_in_varchar
111 (p_assignment_id in NUMBER
112 ,p_effective_date in DATE
113 ,p_element_name in varchar2
114 ,p_input_value_name in varchar2
115 ,p_input_value out nocopy varchar2
116 ) RETURN NUMBER;
117 FUNCTION GET_BALANCE_DATE(p_BALANCE_DATE IN DATE)RETURN DATE ;
118
119 FUNCTION set_value_cache(p_cache_code in varchar2, p_cache_value in varchar2) RETURN NUMBER;
120 FUNCTION get_value_cache(p_cache_code in varchar2, p_cache_value out nocopy varchar2)RETURN NUMBER;
121 FUNCTION delete_cache_table_row(p_cache_code in varchar2)RETURN NUMBER;
122 FUNCTION clear_cache RETURN NUMBER;
123
124 FUNCTION PRINT1(P_LEVEL IN NUMBER,P_TEXT IN VARCHAR2,P_VALUE IN VARCHAR2) RETURN NUMBER;
125
126 function get_hourly_salaried_type(p_assignment_id in number,
127 p_date_earned in date
128 ) return varchar2 ;
129
130
131 FUNCTION good_time_format ( p_time IN VARCHAR2 ) RETURN BOOLEAN;
132
133 FUNCTION get_tax_card_details
134 (p_assignment_id IN NUMBER
135 ,p_effective_date in date
136 ,p_julian_effective_date OUT NOCOPY NUMBER
137 ,p_tax_card_type OUT NOCOPY VARCHAR2
138 ,p_base_rate OUT NOCOPY NUMBER
139 ,p_additional_rate OUT NOCOPY NUMBER
140 ,p_yearly_income_limit OUT NOCOPY NUMBER
141 ,p_previous_income OUT NOCOPY NUMBER
142 ,p_lower_income_Percentage OUT NOCOPY NUMBER ) RETURN NUMBER;
143 --
144 FUNCTION get_tax_days_override
145 (p_assignment_id IN NUMBER
146 ,p_effective_date IN DATE
147 ,p_tax_days OUT NOCOPY NUMBER
148 ,p_ref_tax_days OUT NOCOPY NUMBER
149 ) RETURN NUMBER;
150 --
151 function run_tax_days_formula
152 (p_assignment_id IN NUMBER
153 ,p_date_earned IN DATE
154 ,p_business_group_id IN NUMBER
155 ,p_payroll_id IN NUMBER
156 ,p_payroll_action_id IN NUMBER
157 ,p_assignment_action_id IN NUMBER
158 ,p_tax_unit_id IN NUMBER
159 ,p_element_entry_id IN NUMBER
160 ,p_element_type_id IN NUMBER
161 ,p_original_entry_id IN NUMBER
162 )
163 return NUMBER;
164 --
165
166 FUNCTION get_tax_details
167 (p_assignment_id IN NUMBER
168 ,p_effective_date IN DATE
169 ) RETURN NUMBER;
170
171 --
172 FUNCTION get_tax_calendar_days
173 ( p_business_group_id IN NUMBER
174 , p_tax_unit_id IN NUMBER
175 ) RETURN NUMBER ;
176
177 FUNCTION get_social_security_info
178 ( p_business_group_id IN NUMBER
179 ,p_tax_unit_id IN NUMBER
180 ,p_social_security_category OUT NOCOPY NUMBER
181 ,p_social_security_exempt OUT NOCOPY VARCHAR2
182 ) RETURN NUMBER;
183
184 FUNCTION get_accident_insurance_info
185 ( p_business_group_id IN NUMBER
186 ,p_tax_unit_id IN NUMBER
187 ,p_effective_date IN DATE
188 ) RETURN NUMBER;
189
190 FUNCTION get_accident_insurance_rate
191 ( p_business_group_id IN NUMBER
192 ,p_tax_unit_id IN NUMBER
193 ,p_effective_date IN DATE
194 ,p_assignment_id IN NUMBER
195 ,p_rate_type IN VARCHAR2
196 ,p_accident_insurance_id OUT NOCOPY NUMBER
197 ,p_rate OUT NOCOPY NUMBER
198 ) RETURN NUMBER ;
199
200 FUNCTION get_person_pension_info
201 ( p_business_group_id IN NUMBER
202 ,p_tax_unit_id IN NUMBER
203 ,p_assignment_id IN NUMBER
204 ,p_effective_date IN DATE
205 ,p_pension_type OUT NOCOPY VARCHAR2
206 ,p_pension_group OUT NOCOPY NUMBER
207 ,p_pension_provider OUT NOCOPY NUMBER
208 ,p_pension_rate OUT NOCOPY NUMBER
209 ) RETURN NUMBER;
210
211 FUNCTION get_retirement_date
212 (p_assignment_id IN NUMBER
213 , p_effective_date IN DATE
214 ) RETURN DATE;
215
216 FUNCTION xml_parser
217 (p_data IN VARCHAR2
218 ) RETURN VARCHAR2;
219
220 PROCEDURE INSERT_OR_UPDATE_PERSON_EIT
221 (p_person_id IN NUMBER,
222 p_new_PENSION_JOINING_DATE IN VARCHAR2,
223 p_old_PENSION_JOINING_DATE in VARCHAR2,
224 p_new_PENSION_TYPES IN VARCHAR2,
225 p_old_PENSION_TYPES in VARCHAR2,
226 p_new_PENSION_INS_NUM IN VARCHAR2,
227 p_old_PENSION_INS_NUM in VARCHAR2,
228 p_new_PENSION_GROUP IN VARCHAR2,
229 p_old_PENSION_GROUP in VARCHAR2,
230 p_new_LOCAL_UNIT IN VARCHAR2,
231 p_old_LOCAL_UNIT in VARCHAR2,
232 p_Session_Date in VARCHAR2,
233 p_dt_update_mode in varchar2,
234 p_where IN VARCHAR2 default NULL
235
236 );
237 PROCEDURE INS_OR_UPD_PERSON_EIT_COLUMN
238 ( p_person_id IN NUMBER
239 ,p_new_value in VARCHAR2
240 ,p_Session_Date in VARCHAR2
241 ,p_COLUMN_NAME in per_people_extra_info.PEI_INFORMATION3%TYPE
242 ,p_dt_update_mode in varchar2
243 );
244
245 FUNCTION get_payroll_period_info
246 (p_payroll_id IN NUMBER
247 ,p_payroll_start_date IN DATE
248 ,p_payroll_end_date IN DATE
249 ,p_S_hp_pcent OUT NOCOPY NUMBER
250 ,p_W_hp_pcent OUT NOCOPY NUMBER
251 ,p_S_hb_pcent OUT NOCOPY NUMBER
252 ,p_W_hb_pcent OUT NOCOPY NUMBER
253 ,p_hc_pcent OUT NOCOPY NUMBER
254 ) RETURN NUMBER;
255
256 END pay_fi_general;