[Home] [Help]
PACKAGE: APPS.PAY_US_TAXBAL_VIEW_PKG
Source
1 package pay_us_taxbal_view_pkg as
2 /* $Header: pyustxbv.pkh 120.0.12010000.1 2008/07/27 23:57:49 appldev ship $ */
3 --
4 -- Functions/Procedures
5 --
6 FUNCTION us_tax_balance (p_tax_balance_category in varchar2,
7 p_tax_type in varchar2,
8 p_ee_or_er in varchar2,
9 p_time_type in varchar2,
10 p_asg_type in varchar2,
11 p_gre_id_context in number,
12 p_jd_context in varchar2 DEFAULT NULL,
13 p_assignment_action_id in number DEFAULT NULL,
14 p_assignment_id in number DEFAULT NULL,
15 p_virtual_date in date DEFAULT NULL)
16 RETURN number;
17 --PRAGMA RESTRICT_REFERENCES(us_tax_balance, WNDS);
18 --
19 FUNCTION us_tax_balance (p_tax_balance_category in varchar2,
20 p_tax_type in varchar2,
21 p_ee_or_er in varchar2,
22 p_time_type in varchar2,
23 p_asg_type in varchar2,
24 p_gre_id_context in number,
25 p_jd_context in varchar2 DEFAULT NULL,
26 p_assignment_action_id in number DEFAULT NULL,
27 p_assignment_id in number DEFAULT NULL,
28 p_virtual_date in date DEFAULT NULL,
29 p_payroll_action_id in number)
30 RETURN number;
31 --PRAGMA RESTRICT_REFERENCES(us_tax_balance, WNDS);
32 --
33 -- "_vm" wrapper function that calls us_tax_balance with asg_type param
34 -- derived from view_mode context stored in pkg global by set_view_mode
35 FUNCTION us_tax_balance_vm (p_tax_balance_category in varchar2,
36 p_tax_type in varchar2,
37 p_ee_or_er in varchar2,
38 p_time_type in varchar2,
39 p_gre_id_context in number,
40 p_jd_context in varchar2 DEFAULT NULL,
41 p_assignment_action_id in number DEFAULT NULL,
42 p_assignment_id in number DEFAULT NULL,
43 p_virtual_date in date DEFAULT NULL,
44 p_payroll_action_id in number)
45 RETURN number;
46 --PRAGMA RESTRICT_REFERENCES(us_tax_balance_vm, WNDS);
47 --
48 FUNCTION us_named_balance
49 (p_balance_name varchar2,
50 p_dimension_suffix varchar2,
51 p_assignment_action_id number DEFAULT NULL,
52 p_assignment_id number DEFAULT NULL,
53 p_virtual_date date DEFAULT NULL,
54 p_asg_type varchar2 DEFAULT NULL,
55 p_gre_id number DEFAULT NULL,
56 p_business_group_id number DEFAULT NULL,
57 p_jurisdiction_code varchar2 DEFAULT NULL)
58 RETURN number;
59 --PRAGMA RESTRICT_REFERENCES(us_named_balance, WNDS);
60 --
61 FUNCTION us_named_balance_vm
62 (p_balance_name varchar2,
63 p_dimension_suffix varchar2,
64 p_assignment_action_id number DEFAULT NULL,
65 p_assignment_id number DEFAULT NULL,
66 p_virtual_date date DEFAULT NULL,
67 p_gre_id number DEFAULT NULL,
68 p_business_group_id number DEFAULT NULL,
69 p_jurisdiction_code varchar2 DEFAULT NULL)
70 RETURN number;
71 --
72 --PRAGMA RESTRICT_REFERENCES(us_named_balance_vm, WNDS);
73 --
74 --
75 FUNCTION payments_balance_required(p_assignment_action_id NUMBER)
76 RETURN boolean;
77 --
78 PRAGMA RESTRICT_REFERENCES(payments_balance_required, WNDS);
79 --
80 procedure us_gp_multiple_gre_ytd (p_tax_unit_id IN NUMBER,
81 p_effective_date IN DATE,
82 p_balance_name1 IN VARCHAR2 DEFAULT NULL,
83 p_balance_name2 IN VARCHAR2 DEFAULT NULL,
84 p_balance_name3 IN VARCHAR2 DEFAULT NULL,
85 p_balance_name4 IN VARCHAR2 DEFAULT NULL,
86 p_balance_name5 IN VARCHAR2 DEFAULT NULL,
87 p_balance_name6 IN VARCHAR2 DEFAULT NULL,
88 p_balance_name7 IN VARCHAR2 DEFAULT NULL,
89 p_balance_name8 IN VARCHAR2 DEFAULT NULL,
90 p_balance_name9 IN VARCHAR2 DEFAULT NULL,
91 p_balance_name10 IN VARCHAR2 DEFAULT NULL,
92 p_value1 OUT NOCOPY NUMBER,
93 p_value2 OUT NOCOPY NUMBER,
94 p_value3 OUT NOCOPY NUMBER,
95 p_value4 OUT NOCOPY NUMBER,
96 p_value5 OUT NOCOPY NUMBER,
97 p_value6 OUT NOCOPY NUMBER,
98 p_value7 OUT NOCOPY NUMBER,
99 p_value8 OUT NOCOPY NUMBER,
100 p_value9 OUT NOCOPY NUMBER,
101 p_value10 OUT NOCOPY NUMBER);
102 --
103 PRAGMA RESTRICT_REFERENCES(us_gp_multiple_gre_ytd, WNDS);
104 --
105 procedure us_gp_multiple_gre_qtd (p_tax_unit_id IN NUMBER,
106 p_effective_date IN DATE,
107 p_balance_name1 IN VARCHAR2 DEFAULT NULL,
108 p_balance_name2 IN VARCHAR2 DEFAULT NULL,
109 p_balance_name3 IN VARCHAR2 DEFAULT NULL,
110 p_balance_name4 IN VARCHAR2 DEFAULT NULL,
111 p_balance_name5 IN VARCHAR2 DEFAULT NULL,
112 p_balance_name6 IN VARCHAR2 DEFAULT NULL,
113 p_balance_name7 IN VARCHAR2 DEFAULT NULL,
114 p_balance_name8 IN VARCHAR2 DEFAULT NULL,
115 p_balance_name9 IN VARCHAR2 DEFAULT NULL,
116 p_balance_name10 IN VARCHAR2 DEFAULT NULL,
117 p_value1 OUT NOCOPY NUMBER,
118 p_value2 OUT NOCOPY NUMBER,
119 p_value3 OUT NOCOPY NUMBER,
120 p_value4 OUT NOCOPY NUMBER,
121 p_value5 OUT NOCOPY NUMBER,
122 p_value6 OUT NOCOPY NUMBER,
123 p_value7 OUT NOCOPY NUMBER,
124 p_value8 OUT NOCOPY NUMBER,
125 p_value9 OUT NOCOPY NUMBER,
126 p_value10 OUT NOCOPY NUMBER);
127 --
128 procedure us_gp_multiple_gre_qtd (p_tax_unit_id IN NUMBER,
129 p_effective_date IN DATE,
130 p_balance_name1 IN VARCHAR2 DEFAULT NULL,
131 p_balance_name2 IN VARCHAR2 DEFAULT NULL,
132 p_balance_name3 IN VARCHAR2 DEFAULT NULL,
133 p_balance_name4 IN VARCHAR2 DEFAULT NULL,
134 p_balance_name5 IN VARCHAR2 DEFAULT NULL,
135 p_balance_name6 IN VARCHAR2 DEFAULT NULL,
136 p_balance_name7 IN VARCHAR2 DEFAULT NULL,
137 p_balance_name8 IN VARCHAR2 DEFAULT NULL,
138 p_balance_name9 IN VARCHAR2 DEFAULT NULL,
139 p_balance_name10 IN VARCHAR2 DEFAULT NULL,
140 p_balance_name11 IN VARCHAR2 DEFAULT NULL,
141 p_balance_name12 IN VARCHAR2 DEFAULT NULL,
142 p_value1 OUT NOCOPY NUMBER,
143 p_value2 OUT NOCOPY NUMBER,
144 p_value3 OUT NOCOPY NUMBER,
145 p_value4 OUT NOCOPY NUMBER,
146 p_value5 OUT NOCOPY NUMBER,
147 p_value6 OUT NOCOPY NUMBER,
148 p_value7 OUT NOCOPY NUMBER,
149 p_value8 OUT NOCOPY NUMBER,
150 p_value9 OUT NOCOPY NUMBER,
151 p_value10 OUT NOCOPY NUMBER,
152 p_value11 OUT NOCOPY NUMBER,
153 p_value12 OUT NOCOPY NUMBER);
154 --
155 PRAGMA RESTRICT_REFERENCES(us_gp_multiple_gre_qtd, WNDS);
156 --
157 PROCEDURE us_gp_subject_to_tax_gre_ytd (p_balance_name1 IN VARCHAR2 DEFAULT NULL,
158 p_balance_name2 IN VARCHAR2 DEFAULT NULL,
159 p_balance_name3 IN VARCHAR2 DEFAULT NULL,
160 p_balance_name4 IN VARCHAR2 DEFAULT NULL,
161 p_balance_name5 IN VARCHAR2 DEFAULT NULL,
162 p_effective_date IN DATE,
163 p_tax_unit_id IN NUMBER,
164 p_value1 OUT NOCOPY NUMBER,
165 p_value2 OUT NOCOPY NUMBER,
166 p_value3 OUT NOCOPY NUMBER,
167 p_value4 OUT NOCOPY NUMBER,
168 p_value5 OUT NOCOPY NUMBER);
169 --
170 PRAGMA RESTRICT_REFERENCES(us_gp_subject_to_tax_gre_ytd, WNDS);
171 --
172 PROCEDURE us_gp_subject_to_tax_gre_qtd (p_balance_name1 IN VARCHAR2 DEFAULT NULL,
173 p_balance_name2 IN VARCHAR2 DEFAULT NULL,
174 p_balance_name3 IN VARCHAR2 DEFAULT NULL,
175 p_balance_name4 IN VARCHAR2 DEFAULT NULL,
176 p_balance_name5 IN VARCHAR2 DEFAULT NULL,
177 p_effective_date IN DATE,
178 p_tax_unit_id IN NUMBER,
179 p_value1 OUT NOCOPY NUMBER,
180 p_value2 OUT NOCOPY NUMBER,
181 p_value3 OUT NOCOPY NUMBER,
182 p_value4 OUT NOCOPY NUMBER,
183 p_value5 OUT NOCOPY NUMBER);
184 --
185 PRAGMA RESTRICT_REFERENCES(us_gp_subject_to_tax_gre_qtd, WNDS);
186 --
187 PROCEDURE us_gp_gre_jd_ytd (p_balance_name1 IN VARCHAR2 DEFAULT NULL,
188 p_balance_name2 IN VARCHAR2 DEFAULT NULL,
189 p_balance_name3 IN VARCHAR2 DEFAULT NULL,
190 p_balance_name4 IN VARCHAR2 DEFAULT NULL,
191 p_balance_name5 IN VARCHAR2 DEFAULT NULL,
192 p_balance_name6 IN VARCHAR2 DEFAULT NULL,
193 p_balance_name7 IN VARCHAR2 DEFAULT NULL,
194 p_effective_date IN DATE,
195 p_tax_unit_id IN NUMBER,
196 p_state_code IN VARCHAR2,
197 p_value1 OUT NOCOPY NUMBER,
198 p_value2 OUT NOCOPY NUMBER,
199 p_value3 OUT NOCOPY NUMBER,
200 p_value4 OUT NOCOPY NUMBER,
201 p_value5 OUT NOCOPY NUMBER,
202 p_value6 OUT NOCOPY NUMBER,
203 p_value7 OUT NOCOPY NUMBER);
204 --
205 PRAGMA RESTRICT_REFERENCES(us_gp_gre_jd_ytd,WNDS);
206 --
207 PROCEDURE us_gp_gre_jd_qtd (p_balance_name1 IN VARCHAR2 DEFAULT NULL,
208 p_balance_name2 IN VARCHAR2 DEFAULT NULL,
209 p_balance_name3 IN VARCHAR2 DEFAULT NULL,
210 p_balance_name4 IN VARCHAR2 DEFAULT NULL,
211 p_balance_name5 IN VARCHAR2 DEFAULT NULL,
212 p_balance_name6 IN VARCHAR2 DEFAULT NULL,
213 p_balance_name7 IN VARCHAR2 DEFAULT NULL,
214 p_effective_date IN DATE,
215 p_tax_unit_id IN NUMBER,
216 p_state_code IN VARCHAR2,
217 p_value1 OUT NOCOPY NUMBER,
218 p_value2 OUT NOCOPY NUMBER,
219 p_value3 OUT NOCOPY NUMBER,
220 p_value4 OUT NOCOPY NUMBER,
221 p_value5 OUT NOCOPY NUMBER,
222 p_value6 OUT NOCOPY NUMBER,
223 p_value7 OUT NOCOPY NUMBER);
224 --
225 PRAGMA RESTRICT_REFERENCES(us_gp_gre_jd_qtd,WNDS);
226 --
227 procedure us_gp_multiple_gre_mtd (p_tax_unit_id IN NUMBER,
231 p_balance_name3 IN VARCHAR2 DEFAULT NULL,
228 p_effective_date IN DATE,
229 p_balance_name1 IN VARCHAR2 DEFAULT NULL,
230 p_balance_name2 IN VARCHAR2 DEFAULT NULL,
232 p_balance_name4 IN VARCHAR2 DEFAULT NULL,
233 p_balance_name5 IN VARCHAR2 DEFAULT NULL,
234 p_balance_name6 IN VARCHAR2 DEFAULT NULL,
235 p_balance_name7 IN VARCHAR2 DEFAULT NULL,
236 p_balance_name8 IN VARCHAR2 DEFAULT NULL,
237 p_balance_name9 IN VARCHAR2 DEFAULT NULL,
238 p_balance_name10 IN VARCHAR2 DEFAULT NULL,
239 p_value1 OUT NOCOPY NUMBER,
240 p_value2 OUT NOCOPY NUMBER,
241 p_value3 OUT NOCOPY NUMBER,
242 p_value4 OUT NOCOPY NUMBER,
243 p_value5 OUT NOCOPY NUMBER,
244 p_value6 OUT NOCOPY NUMBER,
245 p_value7 OUT NOCOPY NUMBER,
246 p_value8 OUT NOCOPY NUMBER,
247 p_value9 OUT NOCOPY NUMBER,
248 p_value10 OUT NOCOPY NUMBER);
249 --
250 PRAGMA RESTRICT_REFERENCES(us_gp_multiple_gre_mtd, WNDS);
251 --
252 procedure us_gp_multiple_gre_ctd (p_tax_unit_id IN NUMBER,
253 p_start_date IN DATE,
254 p_effective_date IN DATE,
255 p_balance_name1 IN VARCHAR2 DEFAULT NULL,
256 p_balance_name2 IN VARCHAR2 DEFAULT NULL,
257 p_balance_name3 IN VARCHAR2 DEFAULT NULL,
258 p_balance_name4 IN VARCHAR2 DEFAULT NULL,
259 p_balance_name5 IN VARCHAR2 DEFAULT NULL,
260 p_balance_name6 IN VARCHAR2 DEFAULT NULL,
261 p_balance_name7 IN VARCHAR2 DEFAULT NULL,
262 p_balance_name8 IN VARCHAR2 DEFAULT NULL,
263 p_balance_name9 IN VARCHAR2 DEFAULT NULL,
264 p_balance_name10 IN VARCHAR2 DEFAULT NULL,
265 p_value1 OUT NOCOPY NUMBER,
266 p_value2 OUT NOCOPY NUMBER,
267 p_value3 OUT NOCOPY NUMBER,
268 p_value4 OUT NOCOPY NUMBER,
269 p_value5 OUT NOCOPY NUMBER,
270 p_value6 OUT NOCOPY NUMBER,
271 p_value7 OUT NOCOPY NUMBER,
272 p_value8 OUT NOCOPY NUMBER,
273 p_value9 OUT NOCOPY NUMBER,
274 p_value10 OUT NOCOPY NUMBER);
275 --
276 PRAGMA RESTRICT_REFERENCES(us_gp_multiple_gre_ctd, WNDS);
277 --
278 --
279 PROCEDURE us_gp_subject_to_tax_gre_mtd (p_balance_name1 IN VARCHAR2 DEFAULT NULL,
280 p_balance_name2 IN VARCHAR2 DEFAULT NULL,
281 p_balance_name3 IN VARCHAR2 DEFAULT NULL,
282 p_balance_name4 IN VARCHAR2 DEFAULT NULL,
283 p_balance_name5 IN VARCHAR2 DEFAULT NULL,
284 p_effective_date IN DATE,
285 p_tax_unit_id IN NUMBER,
286 p_value1 OUT NOCOPY NUMBER,
287 p_value2 OUT NOCOPY NUMBER,
288 p_value3 OUT NOCOPY NUMBER,
289 p_value4 OUT NOCOPY NUMBER,
290 p_value5 OUT NOCOPY NUMBER);
291 --
292 PRAGMA RESTRICT_REFERENCES(us_gp_subject_to_tax_gre_mtd, WNDS);
293 --
294 PROCEDURE us_gp_subject_to_tax_gre_ctd (p_balance_name1 IN VARCHAR2 DEFAULT NULL,
295 p_balance_name2 IN VARCHAR2 DEFAULT NULL,
296 p_balance_name3 IN VARCHAR2 DEFAULT NULL,
297 p_balance_name4 IN VARCHAR2 DEFAULT NULL,
298 p_balance_name5 IN VARCHAR2 DEFAULT NULL,
299 p_start_date IN DATE,
300 p_effective_date IN DATE,
301 p_tax_unit_id IN NUMBER,
302 p_value1 OUT NOCOPY NUMBER,
303 p_value2 OUT NOCOPY NUMBER,
304 p_value3 OUT NOCOPY NUMBER,
305 p_value4 OUT NOCOPY NUMBER,
306 p_value5 OUT NOCOPY NUMBER);
307 --
308 PRAGMA RESTRICT_REFERENCES(us_gp_subject_to_tax_gre_ctd, WNDS);
309 --
310 PROCEDURE us_gp_gre_jd_mtd (p_balance_name1 IN VARCHAR2 DEFAULT NULL,
311 p_balance_name2 IN VARCHAR2 DEFAULT NULL,
312 p_balance_name3 IN VARCHAR2 DEFAULT NULL,
313 p_balance_name4 IN VARCHAR2 DEFAULT NULL,
317 p_effective_date IN DATE,
314 p_balance_name5 IN VARCHAR2 DEFAULT NULL,
315 p_balance_name6 IN VARCHAR2 DEFAULT NULL,
316 p_balance_name7 IN VARCHAR2 DEFAULT NULL,
318 p_tax_unit_id IN NUMBER,
319 p_state_code IN VARCHAR2,
320 p_value1 OUT NOCOPY NUMBER,
321 p_value2 OUT NOCOPY NUMBER,
322 p_value3 OUT NOCOPY NUMBER,
323 p_value4 OUT NOCOPY NUMBER,
324 p_value5 OUT NOCOPY NUMBER,
325 p_value6 OUT NOCOPY NUMBER,
326 p_value7 OUT NOCOPY NUMBER);
327 --
328 PRAGMA RESTRICT_REFERENCES(us_gp_gre_jd_mtd,WNDS);
329 --
330 PROCEDURE us_gp_gre_jd_ctd (p_balance_name1 IN VARCHAR2 DEFAULT NULL,
331 p_balance_name2 IN VARCHAR2 DEFAULT NULL,
332 p_balance_name3 IN VARCHAR2 DEFAULT NULL,
333 p_balance_name4 IN VARCHAR2 DEFAULT NULL,
334 p_balance_name5 IN VARCHAR2 DEFAULT NULL,
335 p_balance_name6 IN VARCHAR2 DEFAULT NULL,
336 p_balance_name7 IN VARCHAR2 DEFAULT NULL,
337 p_start_date IN DATE,
338 p_effective_date IN DATE,
339 p_tax_unit_id IN NUMBER,
340 p_state_code IN VARCHAR2,
341 p_value1 OUT NOCOPY NUMBER,
342 p_value2 OUT NOCOPY NUMBER,
343 p_value3 OUT NOCOPY NUMBER,
344 p_value4 OUT NOCOPY NUMBER,
345 p_value5 OUT NOCOPY NUMBER,
346 p_value6 OUT NOCOPY NUMBER,
347 p_value7 OUT NOCOPY NUMBER);
348 --
349 PRAGMA RESTRICT_REFERENCES(us_gp_gre_jd_ctd,WNDS);
350 --
351 end pay_us_taxbal_view_pkg;