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