1 PACKAGE per_qh_tax_update AUTHID CURRENT_USER as
2 /* $Header: peqhtaxi.pkh 115.3 2004/02/10 00:38:57 jpthomas noship $ */
3
4 procedure insert_tax_data
5 (tax_effective_start_date in out nocopy date
6 ,tax_effective_end_date in out nocopy date
7 ,tax_field1 in out nocopy VARCHAR2
8 ,tax_field2 in out nocopy VARCHAR2
9 ,tax_field3 in out nocopy VARCHAR2
10 ,tax_field4 in out nocopy VARCHAR2
11 ,tax_field5 in out nocopy VARCHAR2
12 ,tax_field6 in out nocopy VARCHAR2
13 ,tax_field7 in out nocopy VARCHAR2
14 ,tax_field8 in out nocopy VARCHAR2
15 ,tax_field9 in out nocopy VARCHAR2
16 ,tax_field10 in out nocopy VARCHAR2
17 ,tax_field11 in out nocopy VARCHAR2
18 ,tax_field12 in out nocopy VARCHAR2
19 ,tax_field13 in out nocopy VARCHAR2
20 ,tax_field14 in out nocopy VARCHAR2
21 ,tax_field15 in out nocopy VARCHAR2
22 ,tax_field16 in out nocopy VARCHAR2
23 ,tax_field17 in out nocopy VARCHAR2
24 ,tax_field18 in out nocopy VARCHAR2
25 ,tax_field19 in out nocopy VARCHAR2
26 ,tax_field20 in out nocopy VARCHAR2
27 ,tax_field21 in out nocopy VARCHAR2
28 ,tax_field22 in out nocopy VARCHAR2
29 ,tax_field23 in out nocopy VARCHAR2
30 ,tax_field24 in out nocopy VARCHAR2
31 ,tax_field25 in out nocopy VARCHAR2
32 ,tax_field26 in out nocopy VARCHAR2
33 ,tax_field27 in out nocopy VARCHAR2
34 ,tax_field28 in out nocopy VARCHAR2
35 ,tax_field29 in out nocopy VARCHAR2
36 ,tax_field30 in out nocopy VARCHAR2
37 ,tax_field31 in out nocopy VARCHAR2
38 ,tax_field32 in out nocopy VARCHAR2
39 ,tax_field33 in out nocopy VARCHAR2
40 ,tax_field34 in out nocopy VARCHAR2
41 ,tax_field35 in out nocopy VARCHAR2
42 ,tax_field36 in out nocopy VARCHAR2
43 ,tax_field37 in out nocopy VARCHAR2
44 ,tax_field38 in out nocopy VARCHAR2
45 ,tax_field39 in out nocopy VARCHAR2
46 ,tax_field40 in out nocopy VARCHAR2
47 ,tax_field41 in out nocopy VARCHAR2
48 ,tax_field42 in out nocopy VARCHAR2
49 ,tax_field43 in out nocopy VARCHAR2
50 ,tax_field44 in out nocopy VARCHAR2
51 ,tax_field45 in out nocopy VARCHAR2
52 ,tax_field46 in out nocopy VARCHAR2
53 ,tax_field47 in out nocopy VARCHAR2
54 ,tax_field48 in out nocopy VARCHAR2
55 ,tax_field49 in out nocopy VARCHAR2
56 ,tax_field50 in out nocopy VARCHAR2
57 ,tax_field51 in out nocopy VARCHAR2
58 ,tax_field52 in out nocopy VARCHAR2
59 ,tax_field53 in out nocopy VARCHAR2
60 ,tax_field54 in out nocopy VARCHAR2
61 ,tax_field55 in out nocopy VARCHAR2
62 ,tax_field56 in out nocopy VARCHAR2
63 ,tax_field57 in out nocopy VARCHAR2
64 ,tax_field58 in out nocopy VARCHAR2
65 ,tax_field59 in out nocopy VARCHAR2
66 ,tax_field60 in out nocopy VARCHAR2
67 ,tax_field61 in out nocopy VARCHAR2
68 ,tax_field62 in out nocopy VARCHAR2
69 ,tax_field63 in out nocopy VARCHAR2
70 ,tax_field64 in out nocopy VARCHAR2
71 ,tax_field65 in out nocopy VARCHAR2
72 ,tax_field66 in out nocopy VARCHAR2
73 ,tax_field67 in out nocopy VARCHAR2
74 ,tax_field68 in out nocopy VARCHAR2
75 ,tax_field69 in out nocopy VARCHAR2
76 ,tax_field70 in out nocopy VARCHAR2
77 ,tax_field71 in out nocopy VARCHAR2
78 ,tax_field72 in out nocopy VARCHAR2
79 ,tax_field73 in out nocopy VARCHAR2
80 ,tax_field74 in out nocopy VARCHAR2
81 ,tax_field75 in out nocopy VARCHAR2
82 ,tax_field76 in out nocopy VARCHAR2
83 ,tax_field77 in out nocopy VARCHAR2
84 ,tax_field78 in out nocopy VARCHAR2
85 ,tax_field79 in out nocopy VARCHAR2
86 ,tax_field80 in out nocopy VARCHAR2
87 ,tax_field81 in out nocopy VARCHAR2
88 ,tax_field82 in out nocopy VARCHAR2
89 ,tax_field83 in out nocopy VARCHAR2
90 ,tax_field84 in out nocopy VARCHAR2
91 ,tax_field85 in out nocopy VARCHAR2
92 ,tax_field86 in out nocopy VARCHAR2
93 ,tax_field87 in out nocopy VARCHAR2
94 ,tax_field88 in out nocopy VARCHAR2
95 ,tax_field89 in out nocopy VARCHAR2
96 ,tax_field90 in out nocopy VARCHAR2
97 ,tax_field91 in out nocopy VARCHAR2
98 ,tax_field92 in out nocopy VARCHAR2
99 ,tax_field93 in out nocopy VARCHAR2
100 ,tax_field94 in out nocopy VARCHAR2
101 ,tax_field95 in out nocopy VARCHAR2
102 ,tax_field96 in out nocopy VARCHAR2
103 ,tax_field97 in out nocopy VARCHAR2
104 ,tax_field98 in out nocopy VARCHAR2
105 ,tax_field99 in out nocopy VARCHAR2
106 ,tax_field100 in out nocopy VARCHAR2
107 ,tax_field101 in out nocopy VARCHAR2
108 ,tax_field102 in out nocopy VARCHAR2
109 ,tax_field103 in out nocopy VARCHAR2
110 ,tax_field104 in out nocopy VARCHAR2
111 ,tax_field105 in out nocopy VARCHAR2
112 ,tax_field106 in out nocopy VARCHAR2
113 ,tax_field107 in out nocopy VARCHAR2
114 ,tax_field108 in out nocopy VARCHAR2
115 ,tax_field109 in out nocopy VARCHAR2
116 ,tax_field110 in out nocopy VARCHAR2
117 ,tax_field111 in out nocopy VARCHAR2
118 ,tax_field112 in out nocopy VARCHAR2
119 ,tax_field113 in out nocopy VARCHAR2
120 ,tax_field114 in out nocopy VARCHAR2
121 ,tax_field115 in out nocopy VARCHAR2
122 ,tax_field116 in out nocopy VARCHAR2
123 ,tax_field117 in out nocopy VARCHAR2
124 ,tax_field118 in out nocopy VARCHAR2
125 ,tax_field119 in out nocopy VARCHAR2
126 ,tax_field120 in out nocopy VARCHAR2
127 ,tax_field121 in out nocopy VARCHAR2
128 ,tax_field122 in out nocopy VARCHAR2
129 ,tax_field123 in out nocopy VARCHAR2
130 ,tax_field124 in out nocopy VARCHAR2
131 ,tax_field125 in out nocopy VARCHAR2
132 ,tax_field126 in out nocopy VARCHAR2
133 ,tax_field127 in out nocopy VARCHAR2
134 ,tax_field128 in out nocopy VARCHAR2
135 ,tax_field129 in out nocopy VARCHAR2
136 ,tax_field130 in out nocopy VARCHAR2
137 ,tax_field131 in out nocopy VARCHAR2
138 ,tax_field132 in out nocopy VARCHAR2
139 ,tax_field133 in out nocopy VARCHAR2
140 ,tax_field134 in out nocopy VARCHAR2
141 ,tax_field135 in out nocopy VARCHAR2
142 ,tax_field136 in out nocopy VARCHAR2
143 ,tax_field137 in out nocopy VARCHAR2
144 ,tax_field138 in out nocopy VARCHAR2
145 ,tax_field139 in out nocopy VARCHAR2
146 ,tax_field140 in out nocopy VARCHAR2
147 -- Bug 3357807 Start Here
148 ,tax_field141 IN OUT NOCOPY DATE
149 ,tax_field142 IN OUT NOCOPY DATE
150 ,tax_field143 IN OUT NOCOPY DATE
151 ,tax_field144 IN OUT NOCOPY DATE
152 ,tax_field145 IN OUT NOCOPY DATE
153 ,tax_field146 IN OUT NOCOPY DATE
154 ,tax_field147 IN OUT NOCOPY DATE
155 ,tax_field148 IN OUT NOCOPY DATE
156 ,tax_field149 IN OUT NOCOPY DATE
157 ,tax_field150 IN OUT NOCOPY DATE
158 -- Bug 3357807 End Here
159 ,p_person_id in per_all_people_f.person_id%type
160 ,p_assignment_id in per_all_assignments_f.assignment_id%type
161 ,p_legislation_code in varchar2
162 ,p_effective_date in date
163 );
164
165 procedure insert_tax_data
166 (p_rec in out nocopy per_qh_tax_query.taxrec
167 ,p_person_id in per_all_people_f.person_id%type
168 ,p_assignment_id in per_all_assignments_f.assignment_id%type
169 ,p_legislation_code in varchar2
170 ,p_effective_date in date
171 );
172
173 procedure update_tax_data
174 (tax_effective_start_date in out nocopy date
175 ,tax_effective_end_date in out nocopy date
176 ,tax_field1 in out nocopy VARCHAR2
177 ,tax_field2 in out nocopy VARCHAR2
178 ,tax_field3 in out nocopy VARCHAR2
179 ,tax_field4 in out nocopy VARCHAR2
180 ,tax_field5 in out nocopy VARCHAR2
181 ,tax_field6 in out nocopy VARCHAR2
182 ,tax_field7 in out nocopy VARCHAR2
183 ,tax_field8 in out nocopy VARCHAR2
184 ,tax_field9 in out nocopy VARCHAR2
185 ,tax_field10 in out nocopy VARCHAR2
186 ,tax_field11 in out nocopy VARCHAR2
187 ,tax_field12 in out nocopy VARCHAR2
188 ,tax_field13 in out nocopy VARCHAR2
189 ,tax_field14 in out nocopy VARCHAR2
190 ,tax_field15 in out nocopy VARCHAR2
191 ,tax_field16 in out nocopy VARCHAR2
192 ,tax_field17 in out nocopy VARCHAR2
193 ,tax_field18 in out nocopy VARCHAR2
194 ,tax_field19 in out nocopy VARCHAR2
195 ,tax_field20 in out nocopy VARCHAR2
196 ,tax_field21 in out nocopy VARCHAR2
197 ,tax_field22 in out nocopy VARCHAR2
198 ,tax_field23 in out nocopy VARCHAR2
199 ,tax_field24 in out nocopy VARCHAR2
200 ,tax_field25 in out nocopy VARCHAR2
201 ,tax_field26 in out nocopy VARCHAR2
202 ,tax_field27 in out nocopy VARCHAR2
203 ,tax_field28 in out nocopy VARCHAR2
204 ,tax_field29 in out nocopy VARCHAR2
205 ,tax_field30 in out nocopy VARCHAR2
206 ,tax_field31 in out nocopy VARCHAR2
207 ,tax_field32 in out nocopy VARCHAR2
208 ,tax_field33 in out nocopy VARCHAR2
209 ,tax_field34 in out nocopy VARCHAR2
210 ,tax_field35 in out nocopy VARCHAR2
211 ,tax_field36 in out nocopy VARCHAR2
212 ,tax_field37 in out nocopy VARCHAR2
213 ,tax_field38 in out nocopy VARCHAR2
214 ,tax_field39 in out nocopy VARCHAR2
215 ,tax_field40 in out nocopy VARCHAR2
216 ,tax_field41 in out nocopy VARCHAR2
217 ,tax_field42 in out nocopy VARCHAR2
218 ,tax_field43 in out nocopy VARCHAR2
219 ,tax_field44 in out nocopy VARCHAR2
220 ,tax_field45 in out nocopy VARCHAR2
221 ,tax_field46 in out nocopy VARCHAR2
222 ,tax_field47 in out nocopy VARCHAR2
223 ,tax_field48 in out nocopy VARCHAR2
224 ,tax_field49 in out nocopy VARCHAR2
225 ,tax_field50 in out nocopy VARCHAR2
226 ,tax_field51 in out nocopy VARCHAR2
227 ,tax_field52 in out nocopy VARCHAR2
228 ,tax_field53 in out nocopy VARCHAR2
229 ,tax_field54 in out nocopy VARCHAR2
230 ,tax_field55 in out nocopy VARCHAR2
231 ,tax_field56 in out nocopy VARCHAR2
232 ,tax_field57 in out nocopy VARCHAR2
233 ,tax_field58 in out nocopy VARCHAR2
234 ,tax_field59 in out nocopy VARCHAR2
235 ,tax_field60 in out nocopy VARCHAR2
236 ,tax_field61 in out nocopy VARCHAR2
237 ,tax_field62 in out nocopy VARCHAR2
238 ,tax_field63 in out nocopy VARCHAR2
239 ,tax_field64 in out nocopy VARCHAR2
240 ,tax_field65 in out nocopy VARCHAR2
241 ,tax_field66 in out nocopy VARCHAR2
242 ,tax_field67 in out nocopy VARCHAR2
243 ,tax_field68 in out nocopy VARCHAR2
244 ,tax_field69 in out nocopy VARCHAR2
245 ,tax_field70 in out nocopy VARCHAR2
246 ,tax_field71 in out nocopy VARCHAR2
247 ,tax_field72 in out nocopy VARCHAR2
248 ,tax_field73 in out nocopy VARCHAR2
249 ,tax_field74 in out nocopy VARCHAR2
250 ,tax_field75 in out nocopy VARCHAR2
251 ,tax_field76 in out nocopy VARCHAR2
252 ,tax_field77 in out nocopy VARCHAR2
253 ,tax_field78 in out nocopy VARCHAR2
254 ,tax_field79 in out nocopy VARCHAR2
255 ,tax_field80 in out nocopy VARCHAR2
256 ,tax_field81 in out nocopy VARCHAR2
257 ,tax_field82 in out nocopy VARCHAR2
258 ,tax_field83 in out nocopy VARCHAR2
259 ,tax_field84 in out nocopy VARCHAR2
260 ,tax_field85 in out nocopy VARCHAR2
261 ,tax_field86 in out nocopy VARCHAR2
262 ,tax_field87 in out nocopy VARCHAR2
263 ,tax_field88 in out nocopy VARCHAR2
264 ,tax_field89 in out nocopy VARCHAR2
265 ,tax_field90 in out nocopy VARCHAR2
266 ,tax_field91 in out nocopy VARCHAR2
267 ,tax_field92 in out nocopy VARCHAR2
268 ,tax_field93 in out nocopy VARCHAR2
269 ,tax_field94 in out nocopy VARCHAR2
270 ,tax_field95 in out nocopy VARCHAR2
271 ,tax_field96 in out nocopy VARCHAR2
272 ,tax_field97 in out nocopy VARCHAR2
273 ,tax_field98 in out nocopy VARCHAR2
274 ,tax_field99 in out nocopy VARCHAR2
275 ,tax_field100 in out nocopy VARCHAR2
276 ,tax_field101 in out nocopy VARCHAR2
277 ,tax_field102 in out nocopy VARCHAR2
278 ,tax_field103 in out nocopy VARCHAR2
279 ,tax_field104 in out nocopy VARCHAR2
280 ,tax_field105 in out nocopy VARCHAR2
281 ,tax_field106 in out nocopy VARCHAR2
282 ,tax_field107 in out nocopy VARCHAR2
283 ,tax_field108 in out nocopy VARCHAR2
284 ,tax_field109 in out nocopy VARCHAR2
285 ,tax_field110 in out nocopy VARCHAR2
286 ,tax_field111 in out nocopy VARCHAR2
287 ,tax_field112 in out nocopy VARCHAR2
288 ,tax_field113 in out nocopy VARCHAR2
289 ,tax_field114 in out nocopy VARCHAR2
290 ,tax_field115 in out nocopy VARCHAR2
291 ,tax_field116 in out nocopy VARCHAR2
292 ,tax_field117 in out nocopy VARCHAR2
293 ,tax_field118 in out nocopy VARCHAR2
294 ,tax_field119 in out nocopy VARCHAR2
295 ,tax_field120 in out nocopy VARCHAR2
296 ,tax_field121 in out nocopy VARCHAR2
297 ,tax_field122 in out nocopy VARCHAR2
298 ,tax_field123 in out nocopy VARCHAR2
299 ,tax_field124 in out nocopy VARCHAR2
300 ,tax_field125 in out nocopy VARCHAR2
301 ,tax_field126 in out nocopy VARCHAR2
302 ,tax_field127 in out nocopy VARCHAR2
303 ,tax_field128 in out nocopy VARCHAR2
304 ,tax_field129 in out nocopy VARCHAR2
305 ,tax_field130 in out nocopy VARCHAR2
306 ,tax_field131 in out nocopy VARCHAR2
307 ,tax_field132 in out nocopy VARCHAR2
308 ,tax_field133 in out nocopy VARCHAR2
309 ,tax_field134 in out nocopy VARCHAR2
310 ,tax_field135 in out nocopy VARCHAR2
311 ,tax_field136 in out nocopy VARCHAR2
312 ,tax_field137 in out nocopy VARCHAR2
313 ,tax_field138 in out nocopy VARCHAR2
314 ,tax_field139 in out nocopy VARCHAR2
315 ,tax_field140 in out nocopy VARCHAR2
316 -- Bug 3357807 Start Here
317 ,tax_field141 IN OUT NOCOPY DATE
318 ,tax_field142 IN OUT NOCOPY DATE
319 ,tax_field143 IN OUT NOCOPY DATE
320 ,tax_field144 IN OUT NOCOPY DATE
321 ,tax_field145 IN OUT NOCOPY DATE
322 ,tax_field146 IN OUT NOCOPY DATE
323 ,tax_field147 IN OUT NOCOPY DATE
324 ,tax_field148 IN OUT NOCOPY DATE
325 ,tax_field149 IN OUT NOCOPY DATE
326 ,tax_field150 IN OUT NOCOPY DATE
327 -- Bug 3357807 End Here
328 ,tax_update_allowed in out nocopy varchar2
329 ,p_person_id in per_all_people_f.person_id%type
330 ,p_assignment_id in per_all_assignments_f.assignment_id%type
331 ,p_legislation_code in varchar2
332 ,p_effective_date in date
333 );
334
335 procedure update_tax_data
336 (p_rec in out nocopy per_qh_tax_query.taxrec
337 ,p_person_id in per_all_people_f.person_id%type
338 ,p_assignment_id in per_all_assignments_f.assignment_id%type
339 ,p_legislation_code in varchar2
340 ,p_effective_date in date
341 );
342
343 end per_qh_tax_update;