PACKAGE: APPS.PAY_PAYGBTPL_XMLP_PKG

Source

1 PACKAGE PAY_PAYGBTPL_XMLP_PKG AS
2 /* $Header: PAYGBTPLS.pls 120.0 2008/01/07 15:34:19 srikrish noship $ */
3   P_BUSINESS_GROUP_ID NUMBER;
4 
5   P_PAYROLL_ID NUMBER;
6 
7   P_PAYROLL_PERIOD_ID NUMBER;
8 
9   P_CONSOLIDATION_SET_ID NUMBER;
10 
11   P_SORT_ORDER VARCHAR2(100);
12 
13   P_SORT VARCHAR2(32767);
14 
15   P_SUMMARY_ONLY VARCHAR2(1);
16 
17   P_CONC_REQUEST_ID NUMBER;
18 
19   P_CONSOLIDATION_SET_WHERE VARCHAR2(100) := ' ';
20 
21   P_REVERSAL_CONSOLIDATION_SET VARCHAR2(100);
22 
23   C_TAX_CODE VARCHAR2(60);
24 
25   C_BASIS VARCHAR2(1);
26 
27   C_PREV_TAXABLE NUMBER := 0;
28 
29   C_PAID NUMBER := 0;
30 
31   C_CURRENT_CAT VARCHAR2(30);
32 
33   C_OUTPUT NUMBER;
34 
35   C_GROSS_PAY_PTD_VALUE NUMBER := 0;
36 
37   C_GROSS_PAY_YTD_VALUE NUMBER := 0;
38 
39   C_TAXABLE_PAY_PTD_VALUE NUMBER := 0;
40 
41   C_TAXABLE_PAY_YTD_VALUE NUMBER := 0;
42 
43   C_SPPA_YTD_VALUE NUMBER := 0;
44 
45   C_PENSION_PTD_VALUE NUMBER := 0;
46 
47   C_PENSION_YTD_VALUE NUMBER := 0;
48 
49   C_PAYE_PTD_VALUE NUMBER := 0;
50 
51   C_PAYE_YTD_VALUE NUMBER := 0;
52 
53   C_SPPA_PTD_VALUE NUMBER := 0;
54 
55   C_SSP_PTD_VALUE NUMBER := 0;
56 
57   C_SSP_YTD_VALUE NUMBER;
58 
59   C_SMP_PTD_VALUE NUMBER := 0;
60 
61   C_SPPB_YTD_VALUE NUMBER := 0;
62 
63   C_SMP_YTD_VALUE NUMBER := 0;
64 
65   C_STULN_PTD_VALUE NUMBER := 0;
66 
67   C_WORKING_TAXCR_YTD_VALUE NUMBER := 0;
68 
69   C_SPPB_PTD_VALUE NUMBER := 0;
70 
71   C_STULN_YTD_VALUE NUMBER := 0;
72 
73   C_WORKING_TAXCR_PTD_VALUE NUMBER := 0;
74 
75   C_SAP_PTD_VALUE NUMBER := 0;
76 
77   C_TAXCR_PTD_VALUE NUMBER := 0;
78 
79   C_SAP_YTD_VALUE NUMBER := 0;
80 
81   C_TAXCR_YTD_VALUE NUMBER := 0;
82 
83   C_NI_TOTAL NUMBER;
84 
85   C_YTD_BAL_DIM_ID NUMBER := 0;
86 
87   C_PTD_BAL_DIM_ID NUMBER := 0;
88 
89   C_SCON_INPUT_VALUE_ID NUMBER := 0;
90 
91   C_NI_ELEMENT_TYPE_ID NUMBER := 0;
92 
93   C_GROSS_PAY_PTD_DBID NUMBER := 0;
94 
95   C_GROSS_PAY_YTD_DBID NUMBER := 0;
96 
97   C_GROSS_PAY_PTD_TOT NUMBER := 0;
98 
99   C_GROSS_PAY_YTD_TOT NUMBER := 0;
100 
101   C_NI_EARNINGS_PTD_TOT NUMBER := 0;
102 
103   C_NI_EARNINGS_YTD_TOT NUMBER := 0;
104 
105   C_TAXABLE_PAY_PTD_DBID NUMBER := 0;
106 
107   C_TAXABLE_PAY_YTD_DBID NUMBER := 0;
108 
109   C_TAXABLE_PAY_PTD_TOT NUMBER := 0;
110 
111   C_TAXABLE_PAY_YTD_TOT NUMBER := 0;
112 
113   C_PENSION_PTD_DBID NUMBER := 0;
114 
115   C_PENSION_YTD_DBID NUMBER := 0;
116 
117   C_PENSION_PTD_TOT NUMBER := 0;
118 
119   C_PENSION_YTD_TOT NUMBER := 0;
120 
121   C_PAYE_PTD_DBID NUMBER := 0;
122 
123   C_PAYE_YTD_DBID NUMBER := 0;
124 
125   C_PAYE_PTD_TOT NUMBER := 0;
126 
127   C_PAYE_YTD_TOT NUMBER := 0;
128 
129   C_SSP_YTD_DBID NUMBER := 0;
130 
131   C_SSP_PTD_DBID NUMBER := 0;
132 
133   C_SSP_PTD_TOT NUMBER := 0;
134 
135   C_SSP_YTD_TOT NUMBER := 0;
136 
137   C_SMP_PTD_DBID NUMBER := 0;
138 
139   C_SMP_YTD_DBID NUMBER := 0;
140 
141   C_SMP_PTD_TOT NUMBER := 0;
142 
143   C_SMP_YTD_TOT NUMBER := 0;
144 
145   C_NI_EES_PTD_TOT NUMBER := 0;
146 
147   C_NI_EES_YTD_TOT NUMBER := 0;
148 
149   C_NI_ERS_PTD_TOT NUMBER := 0;
150 
151   C_NI_ERS_YTD_TOT NUMBER := 0;
152 
153   C_PREVIOUS_GROSS_TOT NUMBER := 0;
154 
155   C_PREVIOUS_TAX_TOT NUMBER := 0;
156 
157   C_BUSINESS_GROUP_NAME VARCHAR2(240);
158 
159   C_PAYROLL_NAME VARCHAR2(60);
160 
161   C_PAYROLL_PERIOD VARCHAR2(60);
162 
163   C_CONSOLIDATION_SET VARCHAR2(60);
164 
165   C_SORT_ORDER VARCHAR2(60);
166 
167   C_PERIOD_DATE DATE;
168 
169   C_SUMMARY_ONLY VARCHAR2(3) := 'No';
170 
171   C_STULN_PTD_DBID NUMBER := 0;
172 
173   C_STULN_YTD_DBID NUMBER := 0;
174 
175   C_STULN_PTD_TOT NUMBER := 0;
176 
177   C_STULN_YTD_TOT NUMBER := 0;
178 
179   C_EES_REB_PTD_TOT NUMBER := 0;
180 
181   C_EES_REB_YTD_TOT NUMBER := 0;
182 
183   C_TAXCR_PTD_DBID NUMBER := 0;
184 
185   C_TAXCR_YTD_DBID NUMBER := 0;
186 
187   C_TAXCR_PTD_TOT NUMBER := 0;
188 
189   C_TAXCR_YTD_TOT NUMBER := 0;
190 
191   C_ERS_REB_PTD_TOT NUMBER := 0;
192 
193   C_ERS_REB_YTD_TOT NUMBER := 0;
194 
195   C_NET_INCOME_TAX NUMBER := 0;
196 
197   C_GROSS_NIC NUMBER := 0;
198 
199   C_NIC_REBATE NUMBER := 0;
200 
201   C_NET_NI NUMBER := 0;
202 
203   C_TOTAL_AMOUNT_DUE NUMBER := 0;
204 
205   C_SAP_PTD_DBID NUMBER := 0;
206 
207   C_SAP_PTD_TOT NUMBER := 0;
208 
209   C_SAP_YTD_DBID NUMBER := 0;
210 
211   C_SAP_YTD_TOT NUMBER := 0;
212 
213   C_SPPB_PTD_DBID NUMBER := 0;
214 
215   C_SPPB_PTD_TOT NUMBER := 0;
216 
217   C_SPPB_YTD_DBID NUMBER := 0;
218 
219   C_SPPB_YTD_TOT NUMBER := 0;
220 
221   C_SPPA_PTD_DBID NUMBER := 0;
222 
223   C_SPPA_PTD_TOT NUMBER := 0;
224 
225   C_SPPA_YTD_DBID NUMBER := 0;
226 
227   C_SPPA_YTD_TOT NUMBER := 0;
228 
229   C_WORKING_TAXCR_PTD_DBID NUMBER := 0;
230 
231   C_WORKING_TAXCR_YTD_DBID NUMBER := 0;
232 
233   C_CAT_INPUT_VALUE_ID NUMBER;
234 
235   C_TY_START DATE;
236 
237   FUNCTION BEFOREREPORT RETURN BOOLEAN;
238 
239   FUNCTION C_GET_TPL_DATAFORMULA0030(ASSIGNMENT_ID IN NUMBER
240                                     ,REG_PAYMENT_DATE IN DATE
241                                     ,END_DATE_P IN DATE) RETURN NUMBER;
242 
243   FUNCTION C_GET_BALANCESFORMULA(ASG_ACTION_ID IN NUMBER) RETURN NUMBER;
244 
245   FUNCTION C_GET_DEF_BAL_ID(P_BALANCE_NAME IN VARCHAR2
246                            ,P_DIMENSION_ID IN NUMBER) RETURN NUMBER;
247 
248   FUNCTION C_CALCULATE_TOTALSFORMULA(CAT_CODE IN VARCHAR2
249                                     ,DIM IN VARCHAR2
250                                     ,EMPLOYER IN NUMBER
251                                     ,ABLE IN NUMBER
252                                     ,EMPLOYEE IN NUMBER) RETURN NUMBER;
253 
254   FUNCTION C_ESTABLISH_PERIODFORMULA RETURN NUMBER;
255 
256   FUNCTION AFTERREPORT RETURN BOOLEAN;
257 
258   FUNCTION AFTERPFORM RETURN BOOLEAN;
259 
260   FUNCTION C_TAX_CODE_P RETURN VARCHAR2;
261 
262   FUNCTION C_BASIS_P RETURN VARCHAR2;
263 
264   FUNCTION C_PREV_TAXABLE_P RETURN NUMBER;
265 
266   FUNCTION C_PAID_P RETURN NUMBER;
267 
268   FUNCTION C_CURRENT_CAT_P RETURN VARCHAR2;
269 
270   FUNCTION C_OUTPUT_P RETURN NUMBER;
271 
272   FUNCTION C_GROSS_PAY_PTD_VALUE_P RETURN NUMBER;
273 
274   FUNCTION C_GROSS_PAY_YTD_VALUE_P RETURN NUMBER;
275 
276   FUNCTION C_TAXABLE_PAY_PTD_VALUE_P RETURN NUMBER;
277 
278   FUNCTION C_TAXABLE_PAY_YTD_VALUE_P RETURN NUMBER;
279 
280   FUNCTION C_SPPA_YTD_VALUE_P RETURN NUMBER;
281 
282   FUNCTION C_PENSION_PTD_VALUE_P RETURN NUMBER;
283 
284   FUNCTION C_PENSION_YTD_VALUE_P RETURN NUMBER;
285 
286   FUNCTION C_PAYE_PTD_VALUE_P RETURN NUMBER;
287 
288   FUNCTION C_PAYE_YTD_VALUE_P RETURN NUMBER;
289 
290   FUNCTION C_SPPA_PTD_VALUE_P RETURN NUMBER;
291 
292   FUNCTION C_SSP_PTD_VALUE_P RETURN NUMBER;
293 
294   FUNCTION C_SSP_YTD_VALUE_P RETURN NUMBER;
295 
296   FUNCTION C_SMP_PTD_VALUE_P RETURN NUMBER;
297 
298   FUNCTION C_SPPB_YTD_VALUE_P RETURN NUMBER;
299 
300   FUNCTION C_SMP_YTD_VALUE_P RETURN NUMBER;
301 
302   FUNCTION C_STULN_PTD_VALUE_P RETURN NUMBER;
303 
304   FUNCTION C_WORKING_TAXCR_YTD_VALUE_P RETURN NUMBER;
305 
306   FUNCTION C_SPPB_PTD_VALUE_P RETURN NUMBER;
307 
308   FUNCTION C_STULN_YTD_VALUE_P RETURN NUMBER;
309 
310   FUNCTION C_WORKING_TAXCR_PTD_VALUE_P RETURN NUMBER;
311 
312   FUNCTION C_SAP_PTD_VALUE_P RETURN NUMBER;
313 
314   FUNCTION C_TAXCR_PTD_VALUE_P RETURN NUMBER;
315 
316   FUNCTION C_SAP_YTD_VALUE_P RETURN NUMBER;
317 
318   FUNCTION C_TAXCR_YTD_VALUE_P RETURN NUMBER;
319 
320   FUNCTION C_NI_TOTAL_P RETURN NUMBER;
321 
322   FUNCTION C_YTD_BAL_DIM_ID_P RETURN NUMBER;
323 
324   FUNCTION C_PTD_BAL_DIM_ID_P RETURN NUMBER;
325 
326   FUNCTION C_SCON_INPUT_VALUE_ID_P RETURN NUMBER;
327 
328   FUNCTION C_NI_ELEMENT_TYPE_ID_P RETURN NUMBER;
329 
330   FUNCTION C_GROSS_PAY_PTD_DBID_P RETURN NUMBER;
331 
332   FUNCTION C_GROSS_PAY_YTD_DBID_P RETURN NUMBER;
333 
334   FUNCTION C_GROSS_PAY_PTD_TOT_P RETURN NUMBER;
335 
336   FUNCTION C_GROSS_PAY_YTD_TOT_P RETURN NUMBER;
337 
338   FUNCTION C_NI_EARNINGS_PTD_TOT_P RETURN NUMBER;
339 
340   FUNCTION C_NI_EARNINGS_YTD_TOT_P RETURN NUMBER;
341 
342   FUNCTION C_TAXABLE_PAY_PTD_DBID_P RETURN NUMBER;
343 
344   FUNCTION C_TAXABLE_PAY_YTD_DBID_P RETURN NUMBER;
345 
346   FUNCTION C_TAXABLE_PAY_PTD_TOT_P RETURN NUMBER;
347 
348   FUNCTION C_TAXABLE_PAY_YTD_TOT_P RETURN NUMBER;
349 
350   FUNCTION C_PENSION_PTD_DBID_P RETURN NUMBER;
351 
352   FUNCTION C_PENSION_YTD_DBID_P RETURN NUMBER;
353 
354   FUNCTION C_PENSION_PTD_TOT_P RETURN NUMBER;
355 
356   FUNCTION C_PENSION_YTD_TOT_P RETURN NUMBER;
357 
358   FUNCTION C_PAYE_PTD_DBID_P RETURN NUMBER;
359 
360   FUNCTION C_PAYE_YTD_DBID_P RETURN NUMBER;
361 
362   FUNCTION C_PAYE_PTD_TOT_P RETURN NUMBER;
363 
364   FUNCTION C_PAYE_YTD_TOT_P RETURN NUMBER;
365 
366   FUNCTION C_SSP_YTD_DBID_P RETURN NUMBER;
367 
368   FUNCTION C_SSP_PTD_DBID_P RETURN NUMBER;
369 
370   FUNCTION C_SSP_PTD_TOT_P RETURN NUMBER;
371 
372   FUNCTION C_SSP_YTD_TOT_P RETURN NUMBER;
373 
374   FUNCTION C_SMP_PTD_DBID_P RETURN NUMBER;
375 
376   FUNCTION C_SMP_YTD_DBID_P RETURN NUMBER;
377 
378   FUNCTION C_SMP_PTD_TOT_P RETURN NUMBER;
379 
380   FUNCTION C_SMP_YTD_TOT_P RETURN NUMBER;
381 
382   FUNCTION C_NI_EES_PTD_TOT_P RETURN NUMBER;
383 
384   FUNCTION C_NI_EES_YTD_TOT_P RETURN NUMBER;
385 
386   FUNCTION C_NI_ERS_PTD_TOT_P RETURN NUMBER;
387 
388   FUNCTION C_NI_ERS_YTD_TOT_P RETURN NUMBER;
389 
390   FUNCTION C_PREVIOUS_GROSS_TOT_P RETURN NUMBER;
391 
392   FUNCTION C_PREVIOUS_TAX_TOT_P RETURN NUMBER;
393 
394   FUNCTION C_BUSINESS_GROUP_NAME_P RETURN VARCHAR2;
395 
396   FUNCTION C_PAYROLL_NAME_P RETURN VARCHAR2;
397 
398   FUNCTION C_PAYROLL_PERIOD_P RETURN VARCHAR2;
399 
400   FUNCTION C_CONSOLIDATION_SET_P RETURN VARCHAR2;
401 
402   FUNCTION C_SORT_ORDER_P RETURN VARCHAR2;
403 
404   FUNCTION C_PERIOD_DATE_P RETURN DATE;
405 
406   FUNCTION C_SUMMARY_ONLY_P RETURN VARCHAR2;
407 
408   FUNCTION C_STULN_PTD_DBID_P RETURN NUMBER;
409 
410   FUNCTION C_STULN_YTD_DBID_P RETURN NUMBER;
411 
412   FUNCTION C_STULN_PTD_TOT_P RETURN NUMBER;
413 
414   FUNCTION C_STULN_YTD_TOT_P RETURN NUMBER;
415 
416   FUNCTION C_EES_REB_PTD_TOT_P RETURN NUMBER;
417 
418   FUNCTION C_EES_REB_YTD_TOT_P RETURN NUMBER;
419 
420   FUNCTION C_TAXCR_PTD_DBID_P RETURN NUMBER;
421 
422   FUNCTION C_TAXCR_YTD_DBID_P RETURN NUMBER;
423 
424   FUNCTION C_TAXCR_PTD_TOT_P RETURN NUMBER;
425 
426   FUNCTION C_TAXCR_YTD_TOT_P RETURN NUMBER;
427 
428   FUNCTION C_ERS_REB_PTD_TOT_P RETURN NUMBER;
429 
430   FUNCTION C_ERS_REB_YTD_TOT_P RETURN NUMBER;
431 
432   FUNCTION C_NET_INCOME_TAX_P RETURN NUMBER;
433 
434   FUNCTION C_GROSS_NIC_P RETURN NUMBER;
435 
436   FUNCTION C_NIC_REBATE_P RETURN NUMBER;
437 
438   FUNCTION C_NET_NI_P RETURN NUMBER;
439 
440   FUNCTION C_TOTAL_AMOUNT_DUE_P RETURN NUMBER;
441 
442   FUNCTION C_SAP_PTD_DBID_P RETURN NUMBER;
443 
444   FUNCTION C_SAP_PTD_TOT_P RETURN NUMBER;
445 
446   FUNCTION C_SAP_YTD_DBID_P RETURN NUMBER;
447 
448   FUNCTION C_SAP_YTD_TOT_P RETURN NUMBER;
449 
450   FUNCTION C_SPPB_PTD_DBID_P RETURN NUMBER;
451 
452   FUNCTION C_SPPB_PTD_TOT_P RETURN NUMBER;
453 
454   FUNCTION C_SPPB_YTD_DBID_P RETURN NUMBER;
455 
456   FUNCTION C_SPPB_YTD_TOT_P RETURN NUMBER;
457 
458   FUNCTION C_SPPA_PTD_DBID_P RETURN NUMBER;
459 
460   FUNCTION C_SPPA_PTD_TOT_P RETURN NUMBER;
461 
462   FUNCTION C_SPPA_YTD_DBID_P RETURN NUMBER;
463 
464   FUNCTION C_SPPA_YTD_TOT_P RETURN NUMBER;
465 
466   FUNCTION C_WORKING_TAXCR_PTD_DBID_P RETURN NUMBER;
467 
468   FUNCTION C_WORKING_TAXCR_YTD_DBID_P RETURN NUMBER;
469 
470   FUNCTION C_CAT_INPUT_VALUE_ID_P RETURN NUMBER;
471 
472   FUNCTION C_TY_START_P RETURN DATE;
473 
474 END PAY_PAYGBTPL_XMLP_PKG;