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