[Home] [Help]
PACKAGE: APPS.PAY_US_TAXBAL_VIEW_PKG
Source
1 package pay_us_taxbal_view_pkg AUTHID CURRENT_USER as
2 /* $Header: pyustxbv.pkh 120.3 2010/06/15 09:12:23 vvijayku 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 p_classification_name varchar2 DEFAULT NULL,
71 p_accrued_dimension varchar2 DEFAULT NULL,
72 p_source_id number DEFAULT NULL,
73 p_ele_typ_id number DEFAULT NULL)
74 RETURN number;
75 --
76 --PRAGMA RESTRICT_REFERENCES(us_named_balance_vm, WNDS);
77 --
78 --
79 FUNCTION payments_balance_required(p_assignment_action_id NUMBER)
80 RETURN boolean;
81 --
82 PRAGMA RESTRICT_REFERENCES(payments_balance_required, WNDS);
83 --
84 procedure us_gp_multiple_gre_ytd (p_tax_unit_id IN NUMBER,
85 p_effective_date IN DATE,
86 p_balance_name1 IN VARCHAR2 DEFAULT NULL,
87 p_balance_name2 IN VARCHAR2 DEFAULT NULL,
88 p_balance_name3 IN VARCHAR2 DEFAULT NULL,
89 p_balance_name4 IN VARCHAR2 DEFAULT NULL,
90 p_balance_name5 IN VARCHAR2 DEFAULT NULL,
91 p_balance_name6 IN VARCHAR2 DEFAULT NULL,
92 p_balance_name7 IN VARCHAR2 DEFAULT NULL,
93 p_balance_name8 IN VARCHAR2 DEFAULT NULL,
94 p_balance_name9 IN VARCHAR2 DEFAULT NULL,
95 p_balance_name10 IN VARCHAR2 DEFAULT NULL,
96 p_value1 OUT NOCOPY NUMBER,
97 p_value2 OUT NOCOPY NUMBER,
98 p_value3 OUT NOCOPY NUMBER,
99 p_value4 OUT NOCOPY NUMBER,
100 p_value5 OUT NOCOPY NUMBER,
101 p_value6 OUT NOCOPY NUMBER,
102 p_value7 OUT NOCOPY NUMBER,
103 p_value8 OUT NOCOPY NUMBER,
104 p_value9 OUT NOCOPY NUMBER,
105 p_value10 OUT NOCOPY NUMBER);
106 --
107 PRAGMA RESTRICT_REFERENCES(us_gp_multiple_gre_ytd, WNDS);
108 --
109 procedure us_gp_multiple_gre_qtd (p_tax_unit_id IN NUMBER,
110 p_effective_date IN DATE,
111 p_balance_name1 IN VARCHAR2 DEFAULT NULL,
112 p_balance_name2 IN VARCHAR2 DEFAULT NULL,
113 p_balance_name3 IN VARCHAR2 DEFAULT NULL,
114 p_balance_name4 IN VARCHAR2 DEFAULT NULL,
115 p_balance_name5 IN VARCHAR2 DEFAULT NULL,
116 p_balance_name6 IN VARCHAR2 DEFAULT NULL,
117 p_balance_name7 IN VARCHAR2 DEFAULT NULL,
118 p_balance_name8 IN VARCHAR2 DEFAULT NULL,
119 p_balance_name9 IN VARCHAR2 DEFAULT NULL,
120 p_balance_name10 IN VARCHAR2 DEFAULT NULL,
121 p_value1 OUT NOCOPY NUMBER,
122 p_value2 OUT NOCOPY NUMBER,
123 p_value3 OUT NOCOPY NUMBER,
124 p_value4 OUT NOCOPY NUMBER,
125 p_value5 OUT NOCOPY NUMBER,
126 p_value6 OUT NOCOPY NUMBER,
127 p_value7 OUT NOCOPY NUMBER,
128 p_value8 OUT NOCOPY NUMBER,
129 p_value9 OUT NOCOPY NUMBER,
130 p_value10 OUT NOCOPY NUMBER);
131 --
132 procedure us_gp_multiple_gre_qtd (p_tax_unit_id IN NUMBER,
133 p_effective_date IN DATE,
134 p_balance_name1 IN VARCHAR2 DEFAULT NULL,
135 p_balance_name2 IN VARCHAR2 DEFAULT NULL,
136 p_balance_name3 IN VARCHAR2 DEFAULT NULL,
137 p_balance_name4 IN VARCHAR2 DEFAULT NULL,
138 p_balance_name5 IN VARCHAR2 DEFAULT NULL,
139 p_balance_name6 IN VARCHAR2 DEFAULT NULL,
140 p_balance_name7 IN VARCHAR2 DEFAULT NULL,
141 p_balance_name8 IN VARCHAR2 DEFAULT NULL,
142 p_balance_name9 IN VARCHAR2 DEFAULT NULL,
143 p_balance_name10 IN VARCHAR2 DEFAULT NULL,
144 p_balance_name11 IN VARCHAR2 DEFAULT NULL,
145 p_balance_name12 IN VARCHAR2 DEFAULT NULL,
146 p_value1 OUT NOCOPY NUMBER,
147 p_value2 OUT NOCOPY NUMBER,
148 p_value3 OUT NOCOPY NUMBER,
149 p_value4 OUT NOCOPY NUMBER,
150 p_value5 OUT NOCOPY NUMBER,
151 p_value6 OUT NOCOPY NUMBER,
152 p_value7 OUT NOCOPY NUMBER,
153 p_value8 OUT NOCOPY NUMBER,
154 p_value9 OUT NOCOPY NUMBER,
155 p_value10 OUT NOCOPY NUMBER,
156 p_value11 OUT NOCOPY NUMBER,
157 p_value12 OUT NOCOPY NUMBER);
158 --
159 PRAGMA RESTRICT_REFERENCES(us_gp_multiple_gre_qtd, WNDS);
160 --
161
162 PROCEDURE us_gp_multiple_gre_qtd_ss_w11
163 (p_tax_unit_id IN NUMBER,
164 p_effective_date IN DATE,
165 p_balance_name1 IN VARCHAR2 ,
166 p_value1 OUT NOCOPY NUMBER);
167 --
168 PRAGMA RESTRICT_REFERENCES(us_gp_multiple_gre_qtd_ss_w11, WNDS);
169 --
170
171 PROCEDURE us_gp_subject_to_tax_gre_ytd (p_balance_name1 IN VARCHAR2 DEFAULT NULL,
172 p_balance_name2 IN VARCHAR2 DEFAULT NULL,
173 p_balance_name3 IN VARCHAR2 DEFAULT NULL,
174 p_balance_name4 IN VARCHAR2 DEFAULT NULL,
175 p_balance_name5 IN VARCHAR2 DEFAULT NULL,
176 p_effective_date IN DATE,
177 p_tax_unit_id IN NUMBER,
178 p_value1 OUT NOCOPY NUMBER,
179 p_value2 OUT NOCOPY NUMBER,
180 p_value3 OUT NOCOPY NUMBER,
181 p_value4 OUT NOCOPY NUMBER,
182 p_value5 OUT NOCOPY NUMBER);
183 --
184 PRAGMA RESTRICT_REFERENCES(us_gp_subject_to_tax_gre_ytd, WNDS);
185 --
186 PROCEDURE us_gp_subject_to_tax_gre_qtd (p_balance_name1 IN VARCHAR2 DEFAULT NULL,
187 p_balance_name2 IN VARCHAR2 DEFAULT NULL,
188 p_balance_name3 IN VARCHAR2 DEFAULT NULL,
189 p_balance_name4 IN VARCHAR2 DEFAULT NULL,
190 p_balance_name5 IN VARCHAR2 DEFAULT NULL,
191 p_effective_date IN DATE,
192 p_tax_unit_id IN NUMBER,
193 p_value1 OUT NOCOPY NUMBER,
194 p_value2 OUT NOCOPY NUMBER,
195 p_value3 OUT NOCOPY NUMBER,
196 p_value4 OUT NOCOPY NUMBER,
197 p_value5 OUT NOCOPY NUMBER);
198 --
199 PRAGMA RESTRICT_REFERENCES(us_gp_subject_to_tax_gre_qtd, WNDS);
200 --
201 PROCEDURE us_gp_gre_jd_ytd (p_balance_name1 IN VARCHAR2 DEFAULT NULL,
202 p_balance_name2 IN VARCHAR2 DEFAULT NULL,
203 p_balance_name3 IN VARCHAR2 DEFAULT NULL,
204 p_balance_name4 IN VARCHAR2 DEFAULT NULL,
205 p_balance_name5 IN VARCHAR2 DEFAULT NULL,
206 p_balance_name6 IN VARCHAR2 DEFAULT NULL,
207 p_balance_name7 IN VARCHAR2 DEFAULT NULL,
208 p_effective_date IN DATE,
209 p_tax_unit_id IN NUMBER,
210 p_state_code IN VARCHAR2,
211 p_value1 OUT NOCOPY NUMBER,
212 p_value2 OUT NOCOPY NUMBER,
213 p_value3 OUT NOCOPY NUMBER,
214 p_value4 OUT NOCOPY NUMBER,
215 p_value5 OUT NOCOPY NUMBER,
216 p_value6 OUT NOCOPY NUMBER,
217 p_value7 OUT NOCOPY NUMBER);
218 --
219 PRAGMA RESTRICT_REFERENCES(us_gp_gre_jd_ytd,WNDS);
220 --
221 PROCEDURE us_gp_gre_jd_qtd (p_balance_name1 IN VARCHAR2 DEFAULT NULL,
222 p_balance_name2 IN VARCHAR2 DEFAULT NULL,
223 p_balance_name3 IN VARCHAR2 DEFAULT NULL,
224 p_balance_name4 IN VARCHAR2 DEFAULT NULL,
225 p_balance_name5 IN VARCHAR2 DEFAULT NULL,
226 p_balance_name6 IN VARCHAR2 DEFAULT NULL,
227 p_balance_name7 IN VARCHAR2 DEFAULT NULL,
228 p_effective_date IN DATE,
229 p_tax_unit_id IN NUMBER,
230 p_state_code IN VARCHAR2,
231 p_value1 OUT NOCOPY NUMBER,
232 p_value2 OUT NOCOPY NUMBER,
233 p_value3 OUT NOCOPY NUMBER,
234 p_value4 OUT NOCOPY NUMBER,
235 p_value5 OUT NOCOPY NUMBER,
236 p_value6 OUT NOCOPY NUMBER,
237 p_value7 OUT NOCOPY NUMBER);
238 --
239 PRAGMA RESTRICT_REFERENCES(us_gp_gre_jd_qtd,WNDS);
240 --
241 procedure us_gp_multiple_gre_mtd (p_tax_unit_id IN NUMBER,
242 p_effective_date IN DATE,
243 p_balance_name1 IN VARCHAR2 DEFAULT NULL,
244 p_balance_name2 IN VARCHAR2 DEFAULT NULL,
245 p_balance_name3 IN VARCHAR2 DEFAULT NULL,
246 p_balance_name4 IN VARCHAR2 DEFAULT NULL,
247 p_balance_name5 IN VARCHAR2 DEFAULT NULL,
248 p_balance_name6 IN VARCHAR2 DEFAULT NULL,
249 p_balance_name7 IN VARCHAR2 DEFAULT NULL,
250 p_balance_name8 IN VARCHAR2 DEFAULT NULL,
251 p_balance_name9 IN VARCHAR2 DEFAULT NULL,
252 p_balance_name10 IN VARCHAR2 DEFAULT NULL,
253 p_value1 OUT NOCOPY NUMBER,
254 p_value2 OUT NOCOPY NUMBER,
255 p_value3 OUT NOCOPY NUMBER,
256 p_value4 OUT NOCOPY NUMBER,
257 p_value5 OUT NOCOPY NUMBER,
258 p_value6 OUT NOCOPY NUMBER,
259 p_value7 OUT NOCOPY NUMBER,
260 p_value8 OUT NOCOPY NUMBER,
261 p_value9 OUT NOCOPY NUMBER,
262 p_value10 OUT NOCOPY NUMBER);
263 --
264 PRAGMA RESTRICT_REFERENCES(us_gp_multiple_gre_mtd, WNDS);
265 --
266 procedure us_gp_multiple_gre_ctd (p_tax_unit_id IN NUMBER,
267 p_start_date IN DATE,
268 p_effective_date IN DATE,
269 p_balance_name1 IN VARCHAR2 DEFAULT NULL,
270 p_balance_name2 IN VARCHAR2 DEFAULT NULL,
271 p_balance_name3 IN VARCHAR2 DEFAULT NULL,
272 p_balance_name4 IN VARCHAR2 DEFAULT NULL,
273 p_balance_name5 IN VARCHAR2 DEFAULT NULL,
274 p_balance_name6 IN VARCHAR2 DEFAULT NULL,
275 p_balance_name7 IN VARCHAR2 DEFAULT NULL,
276 p_balance_name8 IN VARCHAR2 DEFAULT NULL,
277 p_balance_name9 IN VARCHAR2 DEFAULT NULL,
278 p_balance_name10 IN VARCHAR2 DEFAULT NULL,
279 p_value1 OUT NOCOPY NUMBER,
280 p_value2 OUT NOCOPY NUMBER,
281 p_value3 OUT NOCOPY NUMBER,
282 p_value4 OUT NOCOPY NUMBER,
283 p_value5 OUT NOCOPY NUMBER,
284 p_value6 OUT NOCOPY NUMBER,
285 p_value7 OUT NOCOPY NUMBER,
286 p_value8 OUT NOCOPY NUMBER,
287 p_value9 OUT NOCOPY NUMBER,
288 p_value10 OUT NOCOPY NUMBER);
289 --
290 PRAGMA RESTRICT_REFERENCES(us_gp_multiple_gre_ctd, WNDS);
291 --
292 --
293 PROCEDURE us_gp_subject_to_tax_gre_mtd (p_balance_name1 IN VARCHAR2 DEFAULT NULL,
294 p_balance_name2 IN VARCHAR2 DEFAULT NULL,
295 p_balance_name3 IN VARCHAR2 DEFAULT NULL,
296 p_balance_name4 IN VARCHAR2 DEFAULT NULL,
297 p_balance_name5 IN VARCHAR2 DEFAULT NULL,
298 p_effective_date IN DATE,
299 p_tax_unit_id IN NUMBER,
300 p_value1 OUT NOCOPY NUMBER,
301 p_value2 OUT NOCOPY NUMBER,
302 p_value3 OUT NOCOPY NUMBER,
303 p_value4 OUT NOCOPY NUMBER,
304 p_value5 OUT NOCOPY NUMBER);
305 --
306 PRAGMA RESTRICT_REFERENCES(us_gp_subject_to_tax_gre_mtd, WNDS);
307 --
308 PROCEDURE us_gp_subject_to_tax_gre_ctd (p_balance_name1 IN VARCHAR2 DEFAULT NULL,
309 p_balance_name2 IN VARCHAR2 DEFAULT NULL,
310 p_balance_name3 IN VARCHAR2 DEFAULT NULL,
311 p_balance_name4 IN VARCHAR2 DEFAULT NULL,
312 p_balance_name5 IN VARCHAR2 DEFAULT NULL,
313 p_start_date IN DATE,
314 p_effective_date IN DATE,
315 p_tax_unit_id IN NUMBER,
316 p_value1 OUT NOCOPY NUMBER,
317 p_value2 OUT NOCOPY NUMBER,
318 p_value3 OUT NOCOPY NUMBER,
319 p_value4 OUT NOCOPY NUMBER,
320 p_value5 OUT NOCOPY NUMBER);
321 --
322 PRAGMA RESTRICT_REFERENCES(us_gp_subject_to_tax_gre_ctd, WNDS);
323 --
324 PROCEDURE us_gp_gre_jd_mtd (p_balance_name1 IN VARCHAR2 DEFAULT NULL,
325 p_balance_name2 IN VARCHAR2 DEFAULT NULL,
326 p_balance_name3 IN VARCHAR2 DEFAULT NULL,
327 p_balance_name4 IN VARCHAR2 DEFAULT NULL,
328 p_balance_name5 IN VARCHAR2 DEFAULT NULL,
329 p_balance_name6 IN VARCHAR2 DEFAULT NULL,
330 p_balance_name7 IN VARCHAR2 DEFAULT NULL,
331 p_effective_date IN DATE,
332 p_tax_unit_id IN NUMBER,
333 p_state_code IN VARCHAR2,
334 p_value1 OUT NOCOPY NUMBER,
335 p_value2 OUT NOCOPY NUMBER,
336 p_value3 OUT NOCOPY NUMBER,
337 p_value4 OUT NOCOPY NUMBER,
338 p_value5 OUT NOCOPY NUMBER,
339 p_value6 OUT NOCOPY NUMBER,
340 p_value7 OUT NOCOPY NUMBER);
341 --
342 PRAGMA RESTRICT_REFERENCES(us_gp_gre_jd_mtd,WNDS);
343 --
344 PROCEDURE us_gp_gre_jd_ctd (p_balance_name1 IN VARCHAR2 DEFAULT NULL,
345 p_balance_name2 IN VARCHAR2 DEFAULT NULL,
346 p_balance_name3 IN VARCHAR2 DEFAULT NULL,
347 p_balance_name4 IN VARCHAR2 DEFAULT NULL,
348 p_balance_name5 IN VARCHAR2 DEFAULT NULL,
349 p_balance_name6 IN VARCHAR2 DEFAULT NULL,
350 p_balance_name7 IN VARCHAR2 DEFAULT NULL,
351 p_start_date IN DATE,
352 p_effective_date IN DATE,
353 p_tax_unit_id IN NUMBER,
354 p_state_code IN VARCHAR2,
355 p_value1 OUT NOCOPY NUMBER,
356 p_value2 OUT NOCOPY NUMBER,
357 p_value3 OUT NOCOPY NUMBER,
358 p_value4 OUT NOCOPY NUMBER,
359 p_value5 OUT NOCOPY NUMBER,
360 p_value6 OUT NOCOPY NUMBER,
361 p_value7 OUT NOCOPY NUMBER);
362 --
363 PRAGMA RESTRICT_REFERENCES(us_gp_gre_jd_ctd,WNDS);
364 --
365 end pay_us_taxbal_view_pkg;