[Home] [Help]
PACKAGE: APPS.PY_ZA_TX_01032002
Source
1 PACKAGE py_za_tx_01032002 AUTHID CURRENT_USER AS
2 /* $Header: pyzat004.pkh 115.7 2003/07/03 15:15:38 jlouw noship $ */
3 /* Copyright (c) Oracle Corporation 2000. All rights reserved. */
4 /*
5 PRODUCT
6 Oracle Payroll - ZA Localisation Tax Module
7 NAME
8 py_za_tx_01032002.pkh
9
10 DESCRIPTION
11 This is the main tax package as used in the ZA Localisation Tax Module.
12 The public functions in this package are not for client use and is
13 only referenced by the tax formulae in the Application.
14
15 PUBLIC FUNCTIONS
16 ZaTxGlb_01082000
17 This function is called from Oracle Applications Fast Formula.
18 It passes all necessary global values to the main tax package.
19 ZaTxDbi_01032002
20 This function is called from Oracle Applications Fast Formula.
21 It passes all necessary Application Database Items to the
22 main tax package.
23 ZaTxBal1_01032002
24 This function is called from Oracle Applications Fast Formula.
25 It passes the first group of balances to the main tax package.
26 ZaTxBal2_01032002
27 This function is called from Oracle Applications Fast Formula.
28 It passes the second group of balances to the main tax package.
29 ZaTxBal3_01032002
30 This function is called from Oracle Applications Fast Formula.
31 It passes the third group of balances to the main tax package.
32 ZaTx_01032002
33 This function is called from Oracle Applications Fast Formula.
34 This is the main tax function from where all necessary
35 validation and calculations are done. The function will
36 calculate the tax liabilities of the employee assignment
37 and pass it back to the calling formula.
38
39 PRIVATE FUNCTIONS
40 <none>
41 NOTES
42 .
43
44 MODIFICATION HISTORY
45 Person Date(DD/MM/YYYY) Version Comments
46 --------- ---------------- ------- --------------------------------
47 J.N. Louw 02/07/2003 115.6 Bug 3011568
48 J.N. Louw 15/04/2002 115.5 Removed SPOOL commands
49 J.N. Louw 15/04/2002 115.4 Bug 2224332
50 Directors Remuneration
51 J.N. Louw 22/03/2002 115.3 Bug 2274662
52 Personal Service Trusts
53 J.N. Louw 31/08/2001 115.2 Added bal_ANN_PF_CYTD
54 Added trc_NegPtd global
55 J.N. Louw 31/08/2001 115.1 Corrected Spool File
56 J.N. Louw 29/08/2001 115.0 Next Version of Main ZA Tax
57 Package.
58 For detail history see
59 py_za_tx_01082000
60 */
61 -------------------------------------------------------------------------------
62 -- PACKAGE GLOBAL AREA --
63 -------------------------------------------------------------------------------
64 -- Types
65 -------------------------------------------------------------------------------
66 SUBTYPE BALANCE IS py_za_tx_utl_01032002.t_balance;
67 -------------------------------------------------------------------------------
68 -- Application Contexts
69 -------------------------------------------------------------------------------
70 con_ASG_ACT_ID NUMBER;
71 con_ASG_ID NUMBER;
72 con_PRL_ACT_ID NUMBER;
73 con_PRL_ID NUMBER;
74 -------------------------------------------------------------------------------
75 -- Application Global Values
76 -------------------------------------------------------------------------------
77 glb_ZA_ADL_TX_RBT NUMBER;
78 glb_ZA_ARR_PF_AN_MX_ABT NUMBER;
79 glb_ZA_ARR_RA_AN_MX_ABT NUMBER;
80 glb_ZA_TRV_ALL_TX_PRC NUMBER;
81 glb_ZA_CC_TX_PRC NUMBER;
82 glb_ZA_LABOUR_BROK_PERC NUMBER;
83 glb_ZA_PF_AN_MX_ABT NUMBER;
84 glb_ZA_PF_MX_PRC NUMBER;
85 glb_ZA_PER_SERV_COMP_PERC NUMBER;
86 glb_ZA_PER_SERV_TRST_PERC NUMBER;
87 glb_ZA_PRI_TX_RBT NUMBER;
88 glb_ZA_PRI_TX_THRSHLD NUMBER;
89 glb_ZA_PBL_TX_PRC NUMBER;
90 glb_ZA_PBL_TX_RTE NUMBER;
91 glb_ZA_RA_AN_MX_ABT NUMBER;
92 glb_ZA_RA_MX_PRC NUMBER;
93 glb_ZA_SC_TX_THRSHLD NUMBER;
94 glb_ZA_SIT_LIM NUMBER;
95 glb_ZA_TMP_TX_RTE NUMBER;
96 glb_ZA_WRK_DYS_PR_YR NUMBER;
97 -------------------------------------------------------------------------------
98 -- Application Database Items
99 -------------------------------------------------------------------------------
100 dbi_BP_TX_RCV VARCHAR2(1);
101 dbi_PAY_PROC_PRD_DTE_PD DATE;
102 dbi_PER_AGE NUMBER;
103 dbi_PER_DTE_OF_BRTH DATE;
104 dbi_SEA_WRK_DYS_WRK NUMBER;
105 dbi_SES_DTE DATE;
106 dbi_TX_DIR_NUM VARCHAR2(60);
107 dbi_TX_DIR_VAL NUMBER DEFAULT 25;
108 dbi_TX_STA VARCHAR2(1);
109 dbi_ZA_ACT_END_DTE DATE;
110 dbi_ZA_ACT_STRT_DTE DATE;
111 dbi_ZA_ASG_TX_RTR_PRD VARCHAR2(1);
112 dbi_ZA_ASG_TX_YR NUMBER(4);
113 dbi_ZA_ASG_TX_YR_END DATE;
114 dbi_ZA_ASG_TX_YR_STRT DATE;
115 dbi_ZA_CUR_PRD_END_DTE DATE;
116 dbi_ZA_CUR_PRD_STRT_DTE DATE;
117 dbi_ZA_DYS_IN_YR NUMBER;
118 dbi_ZA_PAY_PRDS_LFT NUMBER;
119 dbi_ZA_PAY_PRDS_PER_YR NUMBER;
120 dbi_ZA_TX_YR_END DATE;
121 dbi_ZA_TX_YR_STRT DATE;
122 -------------------------------------------------------------------------------
123 -- Balances
124 -------------------------------------------------------------------------------
125 bal_ANN_ARR_PF_CMTD BALANCE;
126 bal_ANN_ARR_PF_CYTD BALANCE;
127 bal_ANN_ARR_PF_RUN BALANCE;
128 bal_ANN_ARR_PF_PTD BALANCE;
129 bal_ANN_ARR_PF_YTD BALANCE;
130 bal_ANN_ARR_RA_CMTD BALANCE;
131 bal_ANN_ARR_RA_CYTD BALANCE;
132 bal_ANN_ARR_RA_RUN BALANCE;
133 bal_ANN_ARR_RA_PTD BALANCE;
134 bal_ANN_ARR_RA_YTD BALANCE;
135 bal_AA_PRCHD_RVAL_NRFI_CMTD BALANCE;
136 bal_AA_PRCHD_RVAL_NRFI_RUN BALANCE;
137 bal_AA_PRCHD_RVAL_NRFI_PTD BALANCE;
138 bal_AA_PRCHD_RVAL_NRFI_YTD BALANCE;
139 bal_AA_PRCHD_RVAL_RFI_CMTD BALANCE;
140 bal_AA_PRCHD_RVAL_RFI_RUN BALANCE;
141 bal_AA_PRCHD_RVAL_RFI_PTD BALANCE;
142 bal_AA_PRCHD_RVAL_RFI_YTD BALANCE;
143 bal_AB_NRFI_CMTD BALANCE;
144 bal_AB_NRFI_RUN BALANCE;
145 bal_AB_NRFI_PTD BALANCE;
146 bal_AB_NRFI_YTD BALANCE;
147 bal_AB_RFI_CMTD BALANCE;
148 bal_AB_RFI_RUN BALANCE;
149 bal_AB_RFI_PTD BALANCE;
150 bal_AB_RFI_YTD BALANCE;
151 bal_ANN_BUR_AND_SCH_NRFI_CMTD BALANCE;
152 bal_ANN_BUR_AND_SCH_NRFI_RUN BALANCE;
153 bal_ANN_BUR_AND_SCH_NRFI_PTD BALANCE;
154 bal_ANN_BUR_AND_SCH_NRFI_YTD BALANCE;
155 bal_ANN_BUR_AND_SCH_RFI_CMTD BALANCE;
156 bal_ANN_BUR_AND_SCH_RFI_RUN BALANCE;
157 bal_ANN_BUR_AND_SCH_RFI_PTD BALANCE;
158 bal_ANN_BUR_AND_SCH_RFI_YTD BALANCE;
159 bal_AC_NRFI_CMTD BALANCE;
160 bal_AC_NRFI_RUN BALANCE;
161 bal_AC_NRFI_PTD BALANCE;
162 bal_AC_NRFI_YTD BALANCE;
163 bal_AC_RFI_CMTD BALANCE;
164 bal_AC_RFI_RUN BALANCE;
165 bal_AC_RFI_PTD BALANCE;
166 bal_AC_RFI_YTD BALANCE;
167 bal_ANN_PF_CMTD BALANCE;
168 bal_ANN_PF_CYTD BALANCE;
169 bal_ANN_PF_RUN BALANCE;
170 bal_ANN_PF_PTD BALANCE;
171 bal_ANN_PF_YTD BALANCE;
172 bal_ARES_TRD_NRFI_CMTD BALANCE;
173 bal_ARES_TRD_NRFI_RUN BALANCE;
174 bal_ARES_TRD_NRFI_PTD BALANCE;
175 bal_ARES_TRD_NRFI_YTD BALANCE;
176 bal_ARES_TRD_RFI_CMTD BALANCE;
177 bal_ARES_TRD_RFI_RUN BALANCE;
178 bal_ARES_TRD_RFI_PTD BALANCE;
179 bal_ARES_TRD_RFI_YTD BALANCE;
180 bal_ANN_RA_CMTD BALANCE;
181 bal_ANN_RA_CYTD BALANCE;
182 bal_ANN_RA_RUN BALANCE;
183 bal_ANN_RA_PTD BALANCE;
184 bal_ANN_RA_YTD BALANCE;
185 bal_ANU_FRM_RET_FND_NRFI_CMTD BALANCE;
186 bal_ANU_FRM_RET_FND_NRFI_RUN BALANCE;
187 bal_ANU_FRM_RET_FND_NRFI_PTD BALANCE;
188 bal_ANU_FRM_RET_FND_NRFI_YTD BALANCE;
189 bal_ANU_FRM_RET_FND_RFI_CMTD BALANCE;
190 bal_ANU_FRM_RET_FND_RFI_RUN BALANCE;
191 bal_ANU_FRM_RET_FND_RFI_PTD BALANCE;
192 bal_ANU_FRM_RET_FND_RFI_YTD BALANCE;
193 bal_ARR_PF_CMTD BALANCE;
194 bal_ARR_PF_CYTD BALANCE;
195 bal_ARR_PF_PTD BALANCE;
196 bal_ARR_PF_YTD BALANCE;
197 bal_ARR_RA_CMTD BALANCE;
198 bal_ARR_RA_CYTD BALANCE;
199 bal_ARR_RA_PTD BALANCE;
200 bal_ARR_RA_YTD BALANCE;
201 bal_AST_PRCHD_RVAL_NRFI_CMTD BALANCE;
202 bal_AST_PRCHD_RVAL_NRFI_CYTD BALANCE;
203 bal_AST_PRCHD_RVAL_NRFI_RUN BALANCE;
204 bal_AST_PRCHD_RVAL_NRFI_PTD BALANCE;
205 bal_AST_PRCHD_RVAL_NRFI_YTD BALANCE;
206 bal_AST_PRCHD_RVAL_RFI_CMTD BALANCE;
207 bal_AST_PRCHD_RVAL_RFI_CYTD BALANCE;
208 bal_AST_PRCHD_RVAL_RFI_RUN BALANCE;
209 bal_AST_PRCHD_RVAL_RFI_PTD BALANCE;
210 bal_AST_PRCHD_RVAL_RFI_YTD BALANCE;
211 bal_BP_CMTD BALANCE;
212 bal_BP_PTD BALANCE;
213 bal_BP_YTD BALANCE;
214 bal_BUR_AND_SCH_NRFI_CMTD BALANCE;
215 bal_BUR_AND_SCH_NRFI_CYTD BALANCE;
216 bal_BUR_AND_SCH_NRFI_RUN BALANCE;
217 bal_BUR_AND_SCH_NRFI_PTD BALANCE;
218 bal_BUR_AND_SCH_NRFI_YTD BALANCE;
219 bal_BUR_AND_SCH_RFI_CMTD BALANCE;
220 bal_BUR_AND_SCH_RFI_CYTD BALANCE;
221 bal_BUR_AND_SCH_RFI_RUN BALANCE;
222 bal_BUR_AND_SCH_RFI_PTD BALANCE;
223 bal_BUR_AND_SCH_RFI_YTD BALANCE;
224 bal_COMM_NRFI_CMTD BALANCE;
225 bal_COMM_NRFI_CYTD BALANCE;
226 bal_COMM_NRFI_RUN BALANCE;
227 bal_COMM_NRFI_PTD BALANCE;
228 bal_COMM_NRFI_YTD BALANCE;
229 bal_COMM_RFI_CMTD BALANCE;
230 bal_COMM_RFI_CYTD BALANCE;
231 bal_COMM_RFI_RUN BALANCE;
232 bal_COMM_RFI_PTD BALANCE;
233 bal_COMM_RFI_YTD BALANCE;
234 bal_COMP_ALL_NRFI_CMTD BALANCE;
235 bal_COMP_ALL_NRFI_CYTD BALANCE;
236 bal_COMP_ALL_NRFI_RUN BALANCE;
237 bal_COMP_ALL_NRFI_PTD BALANCE;
238 bal_COMP_ALL_NRFI_YTD BALANCE;
239 bal_COMP_ALL_RFI_CMTD BALANCE;
240 bal_COMP_ALL_RFI_CYTD BALANCE;
241 bal_COMP_ALL_RFI_RUN BALANCE;
242 bal_COMP_ALL_RFI_PTD BALANCE;
243 bal_COMP_ALL_RFI_YTD BALANCE;
244 bal_PF_CMTD BALANCE;
245 bal_PF_CYTD BALANCE;
246 bal_PF_RUN BALANCE;
247 bal_PF_PTD BALANCE;
248 bal_PF_YTD BALANCE;
249 bal_RA_CMTD BALANCE;
250 bal_RA_CYTD BALANCE;
251 bal_RA_RUN BALANCE;
252 bal_RA_PTD BALANCE;
253 bal_RA_YTD BALANCE;
254 bal_DIR_DMD_RMN_ITD BALANCE;
255 bal_ENT_ALL_NRFI_CMTD BALANCE;
256 bal_ENT_ALL_NRFI_CYTD BALANCE;
257 bal_ENT_ALL_NRFI_RUN BALANCE;
258 bal_ENT_ALL_NRFI_PTD BALANCE;
259 bal_ENT_ALL_NRFI_YTD BALANCE;
260 bal_ENT_ALL_RFI_CMTD BALANCE;
261 bal_ENT_ALL_RFI_CYTD BALANCE;
262 bal_ENT_ALL_RFI_RUN BALANCE;
263 bal_ENT_ALL_RFI_PTD BALANCE;
264 bal_ENT_ALL_RFI_YTD BALANCE;
265 bal_EXC_ARR_PEN_ITD BALANCE;
266 bal_EXC_ARR_PEN_PTD BALANCE;
267 bal_EXC_ARR_PEN_YTD BALANCE;
268 bal_EXC_ARR_RA_ITD BALANCE;
269 bal_EXC_ARR_RA_PTD BALANCE;
270 bal_EXC_ARR_RA_YTD BALANCE;
271 bal_FREE_ACCOM_NRFI_CMTD BALANCE;
272 bal_FREE_ACCOM_NRFI_CYTD BALANCE;
273 bal_FREE_ACCOM_NRFI_RUN BALANCE;
274 bal_FREE_ACCOM_NRFI_PTD BALANCE;
275 bal_FREE_ACCOM_NRFI_YTD BALANCE;
276 bal_FREE_ACCOM_RFI_CMTD BALANCE;
277 bal_FREE_ACCOM_RFI_CYTD BALANCE;
278 bal_FREE_ACCOM_RFI_RUN BALANCE;
279 bal_FREE_ACCOM_RFI_PTD BALANCE;
280 bal_FREE_ACCOM_RFI_YTD BALANCE;
281 bal_FREE_SERV_NRFI_CMTD BALANCE;
282 bal_FREE_SERV_NRFI_CYTD BALANCE;
283 bal_FREE_SERV_NRFI_RUN BALANCE;
284 bal_FREE_SERV_NRFI_PTD BALANCE;
285 bal_FREE_SERV_NRFI_YTD BALANCE;
286 bal_FREE_SERV_RFI_CMTD BALANCE;
287 bal_FREE_SERV_RFI_CYTD BALANCE;
288 bal_FREE_SERV_RFI_RUN BALANCE;
289 bal_FREE_SERV_RFI_PTD BALANCE;
290 bal_FREE_SERV_RFI_YTD BALANCE;
291 bal_LOW_LOANS_NRFI_CMTD BALANCE;
292 bal_LOW_LOANS_NRFI_CYTD BALANCE;
293 bal_LOW_LOANS_NRFI_RUN BALANCE;
294 bal_LOW_LOANS_NRFI_PTD BALANCE;
295 bal_LOW_LOANS_NRFI_YTD BALANCE;
296 bal_LOW_LOANS_RFI_CMTD BALANCE;
297 bal_LOW_LOANS_RFI_CYTD BALANCE;
298 bal_LOW_LOANS_RFI_RUN BALANCE;
299 bal_LOW_LOANS_RFI_PTD BALANCE;
300 bal_LOW_LOANS_RFI_YTD BALANCE;
301 bal_MLS_AND_VOUCH_NRFI_CMTD BALANCE;
302 bal_MLS_AND_VOUCH_NRFI_CYTD BALANCE;
303 bal_MLS_AND_VOUCH_NRFI_RUN BALANCE;
304 bal_MLS_AND_VOUCH_NRFI_PTD BALANCE;
305 bal_MLS_AND_VOUCH_NRFI_YTD BALANCE;
306 bal_MLS_AND_VOUCH_RFI_CMTD BALANCE;
307 bal_MLS_AND_VOUCH_RFI_CYTD BALANCE;
308 bal_MLS_AND_VOUCH_RFI_RUN BALANCE;
309 bal_MLS_AND_VOUCH_RFI_PTD BALANCE;
310 bal_MLS_AND_VOUCH_RFI_YTD BALANCE;
311 bal_MED_CONTR_CMTD BALANCE;
312 bal_MED_CONTR_CYTD BALANCE;
313 bal_MED_CONTR_RUN BALANCE;
314 bal_MED_CONTR_PTD BALANCE;
315 bal_MED_CONTR_YTD BALANCE;
316 bal_MED_PAID_NRFI_CMTD BALANCE;
317 bal_MED_PAID_NRFI_CYTD BALANCE;
318 bal_MED_PAID_NRFI_RUN BALANCE;
319 bal_MED_PAID_NRFI_PTD BALANCE;
320 bal_MED_PAID_NRFI_YTD BALANCE;
321 bal_MED_PAID_RFI_CMTD BALANCE;
322 bal_MED_PAID_RFI_CYTD BALANCE;
323 bal_MED_PAID_RFI_RUN BALANCE;
324 bal_MED_PAID_RFI_PTD BALANCE;
325 bal_MED_PAID_RFI_YTD BALANCE;
326 bal_NET_PAY_RUN BALANCE;
327 bal_NET_TXB_INC_CMTD BALANCE;
328 bal_OTHER_TXB_ALL_NRFI_CMTD BALANCE;
329 bal_OTHER_TXB_ALL_NRFI_CYTD BALANCE;
330 bal_OTHER_TXB_ALL_NRFI_RUN BALANCE;
331 bal_OTHER_TXB_ALL_NRFI_PTD BALANCE;
332 bal_OTHER_TXB_ALL_NRFI_YTD BALANCE;
333 bal_OTHER_TXB_ALL_RFI_CMTD BALANCE;
334 bal_OTHER_TXB_ALL_RFI_CYTD BALANCE;
335 bal_OTHER_TXB_ALL_RFI_RUN BALANCE;
336 bal_OTHER_TXB_ALL_RFI_PTD BALANCE;
337 bal_OTHER_TXB_ALL_RFI_YTD BALANCE;
338 bal_OVTM_NRFI_CMTD BALANCE;
339 bal_OVTM_NRFI_CYTD BALANCE;
340 bal_OVTM_NRFI_RUN BALANCE;
341 bal_OVTM_NRFI_PTD BALANCE;
345 bal_OVTM_RFI_RUN BALANCE;
342 bal_OVTM_NRFI_YTD BALANCE;
343 bal_OVTM_RFI_CMTD BALANCE;
344 bal_OVTM_RFI_CYTD BALANCE;
346 bal_OVTM_RFI_PTD BALANCE;
347 bal_OVTM_RFI_YTD BALANCE;
348 bal_PAYE_YTD BALANCE;
349 bal_PYM_DBT_NRFI_CMTD BALANCE;
350 bal_PYM_DBT_NRFI_CYTD BALANCE;
351 bal_PYM_DBT_NRFI_RUN BALANCE;
352 bal_PYM_DBT_NRFI_PTD BALANCE;
353 bal_PYM_DBT_NRFI_YTD BALANCE;
354 bal_PYM_DBT_RFI_CMTD BALANCE;
355 bal_PYM_DBT_RFI_CYTD BALANCE;
356 bal_PYM_DBT_RFI_RUN BALANCE;
357 bal_PYM_DBT_RFI_PTD BALANCE;
358 bal_PYM_DBT_RFI_YTD BALANCE;
359 bal_PO_NRFI_CMTD BALANCE;
360 bal_PO_NRFI_RUN BALANCE;
361 bal_PO_NRFI_PTD BALANCE;
362 bal_PO_NRFI_YTD BALANCE;
363 bal_PO_RFI_CMTD BALANCE;
364 bal_PO_RFI_RUN BALANCE;
365 bal_PO_RFI_PTD BALANCE;
366 bal_PO_RFI_YTD BALANCE;
367 bal_PRCH_ANU_TXB_NRFI_CMTD BALANCE;
368 bal_PRCH_ANU_TXB_NRFI_RUN BALANCE;
369 bal_PRCH_ANU_TXB_NRFI_PTD BALANCE;
370 bal_PRCH_ANU_TXB_NRFI_YTD BALANCE;
371 bal_PRCH_ANU_TXB_RFI_CMTD BALANCE;
372 bal_PRCH_ANU_TXB_RFI_RUN BALANCE;
373 bal_PRCH_ANU_TXB_RFI_PTD BALANCE;
374 bal_PRCH_ANU_TXB_RFI_YTD BALANCE;
375 bal_RES_TRD_NRFI_CMTD BALANCE;
376 bal_RES_TRD_NRFI_CYTD BALANCE;
377 bal_RES_TRD_NRFI_RUN BALANCE;
378 bal_RES_TRD_NRFI_PTD BALANCE;
379 bal_RES_TRD_NRFI_YTD BALANCE;
380 bal_RES_TRD_RFI_CMTD BALANCE;
381 bal_RES_TRD_RFI_CYTD BALANCE;
382 bal_RES_TRD_RFI_RUN BALANCE;
383 bal_RES_TRD_RFI_PTD BALANCE;
384 bal_RES_TRD_RFI_YTD BALANCE;
385 bal_RGT_AST_NRFI_CMTD BALANCE;
386 bal_RGT_AST_NRFI_CYTD BALANCE;
387 bal_RGT_AST_NRFI_RUN BALANCE;
388 bal_RGT_AST_NRFI_PTD BALANCE;
389 bal_RGT_AST_NRFI_YTD BALANCE;
390 bal_RGT_AST_RFI_CMTD BALANCE;
391 bal_RGT_AST_RFI_CYTD BALANCE;
392 bal_RGT_AST_RFI_RUN BALANCE;
393 bal_RGT_AST_RFI_PTD BALANCE;
394 bal_RGT_AST_RFI_YTD BALANCE;
395 bal_SITE_YTD BALANCE;
396 bal_TAX_YTD BALANCE;
397 bal_TX_ON_AB_PTD BALANCE;
398 bal_TX_ON_AB_YTD BALANCE;
399 bal_TX_ON_AP_RUN BALANCE;
400 bal_TX_ON_AP_PTD BALANCE;
401 bal_TX_ON_AP_YTD BALANCE;
402 bal_TX_ON_BP_PTD BALANCE;
403 bal_TX_ON_BP_YTD BALANCE;
404 bal_TX_ON_TA_PTD BALANCE;
405 bal_TX_ON_TA_YTD BALANCE;
406 bal_TX_ON_DR_PTD BALANCE;
407 bal_TX_ON_DR_YTD BALANCE;
408 bal_TX_ON_FB_PTD BALANCE;
409 bal_TX_ON_FB_YTD BALANCE;
410 bal_TX_ON_NI_PTD BALANCE;
411 bal_TX_ON_NI_YTD BALANCE;
412 bal_TX_ON_PO_PTD BALANCE;
413 bal_TX_ON_PO_YTD BALANCE;
414 bal_TXB_AP_NRFI_CMTD BALANCE;
415 bal_TXB_AP_NRFI_RUN BALANCE;
416 bal_TXB_AP_NRFI_PTD BALANCE;
417 bal_TXB_AP_NRFI_YTD BALANCE;
418 bal_TXB_AP_RFI_CMTD BALANCE;
419 bal_TXB_AP_RFI_RUN BALANCE;
420 bal_TXB_AP_RFI_PTD BALANCE;
421 bal_TXB_AP_RFI_YTD BALANCE;
422 bal_TXB_INC_NRFI_CMTD BALANCE;
423 bal_TXB_INC_NRFI_CYTD BALANCE;
424 bal_TXB_INC_NRFI_RUN BALANCE;
425 bal_TXB_INC_NRFI_PTD BALANCE;
426 bal_TXB_INC_NRFI_YTD BALANCE;
427 bal_TXB_INC_RFI_CMTD BALANCE;
428 bal_TXB_INC_RFI_CYTD BALANCE;
429 bal_TXB_INC_RFI_RUN BALANCE;
430 bal_TXB_INC_RFI_PTD BALANCE;
431 bal_TXB_INC_RFI_YTD BALANCE;
432 bal_TXB_PEN_NRFI_CMTD BALANCE;
433 bal_TXB_PEN_NRFI_CYTD BALANCE;
434 bal_TXB_PEN_NRFI_RUN BALANCE;
435 bal_TXB_PEN_NRFI_PTD BALANCE;
436 bal_TXB_PEN_NRFI_YTD BALANCE;
437 bal_TXB_PEN_RFI_CMTD BALANCE;
438 bal_TXB_PEN_RFI_CYTD BALANCE;
439 bal_TXB_PEN_RFI_RUN BALANCE;
440 bal_TXB_PEN_RFI_PTD BALANCE;
441 bal_TXB_PEN_RFI_YTD BALANCE;
442 bal_TEL_ALL_NRFI_CMTD BALANCE;
443 bal_TEL_ALL_NRFI_CYTD BALANCE;
444 bal_TEL_ALL_NRFI_RUN BALANCE;
445 bal_TEL_ALL_NRFI_PTD BALANCE;
446 bal_TEL_ALL_NRFI_YTD BALANCE;
447 bal_TEL_ALL_RFI_CMTD BALANCE;
448 bal_TEL_ALL_RFI_CYTD BALANCE;
449 bal_TEL_ALL_RFI_RUN BALANCE;
450 bal_TEL_ALL_RFI_PTD BALANCE;
451 bal_TEL_ALL_RFI_YTD BALANCE;
452 bal_TOOL_ALL_NRFI_CMTD BALANCE;
453 bal_TOOL_ALL_NRFI_CYTD BALANCE;
454 bal_TOOL_ALL_NRFI_RUN BALANCE;
455 bal_TOOL_ALL_NRFI_PTD BALANCE;
456 bal_TOOL_ALL_NRFI_YTD BALANCE;
457 bal_TOOL_ALL_RFI_CMTD BALANCE;
458 bal_TOOL_ALL_RFI_CYTD BALANCE;
459 bal_TOOL_ALL_RFI_RUN BALANCE;
460 bal_TOOL_ALL_RFI_PTD BALANCE;
464 bal_TOT_NRFI_AN_INC_CMTD BALANCE;
461 bal_TOOL_ALL_RFI_YTD BALANCE;
462 bal_TOT_INC_PTD BALANCE;
463 bal_TOT_INC_YTD BALANCE;
465 bal_TOT_NRFI_AN_INC_CYTD BALANCE;
466 bal_TOT_NRFI_AN_INC_RUN BALANCE;
467 bal_TOT_NRFI_AN_INC_PTD BALANCE;
468 bal_TOT_NRFI_AN_INC_YTD BALANCE;
469 bal_TOT_NRFI_INC_CMTD BALANCE;
470 bal_TOT_NRFI_INC_CYTD BALANCE;
471 bal_TOT_NRFI_INC_RUN BALANCE;
472 bal_TOT_NRFI_INC_PTD BALANCE;
473 bal_TOT_NRFI_INC_YTD BALANCE;
474 bal_TOT_RFI_AN_INC_CMTD BALANCE;
475 bal_TOT_RFI_AN_INC_CYTD BALANCE;
476 bal_TOT_RFI_AN_INC_RUN BALANCE;
477 bal_TOT_RFI_AN_INC_PTD BALANCE;
478 bal_TOT_RFI_AN_INC_YTD BALANCE;
479 bal_TOT_RFI_INC_CMTD BALANCE;
480 bal_TOT_RFI_INC_CYTD BALANCE;
481 bal_TOT_RFI_INC_RUN BALANCE;
482 bal_TOT_RFI_INC_PTD BALANCE;
483 bal_TOT_RFI_INC_YTD BALANCE;
484 bal_TOT_SEA_WRK_DYS_WRK_YTD BALANCE;
485 bal_TOT_TXB_INC_ITD BALANCE;
486 bal_TA_NRFI_CMTD BALANCE;
487 bal_TA_NRFI_CYTD BALANCE;
488 bal_TA_NRFI_PTD BALANCE;
489 bal_TA_NRFI_YTD BALANCE;
490 bal_TA_RFI_CMTD BALANCE;
491 bal_TA_RFI_CYTD BALANCE;
492 bal_TA_RFI_PTD BALANCE;
493 bal_TA_RFI_YTD BALANCE;
494 bal_USE_VEH_NRFI_CMTD BALANCE;
495 bal_USE_VEH_NRFI_CYTD BALANCE;
496 bal_USE_VEH_NRFI_RUN BALANCE;
497 bal_USE_VEH_NRFI_PTD BALANCE;
498 bal_USE_VEH_NRFI_YTD BALANCE;
499 bal_USE_VEH_RFI_CMTD BALANCE;
500 bal_USE_VEH_RFI_CYTD BALANCE;
501 bal_USE_VEH_RFI_RUN BALANCE;
502 bal_USE_VEH_RFI_PTD BALANCE;
503 bal_USE_VEH_RFI_YTD BALANCE;
504
505 -------------------------------------------------------------------------------
506 -- Trace Globals
507 -------------------------------------------------------------------------------
508
509 -- These are set within the procedures and function calls!!
510 -- Values can be output by the main function call from formula
511 --
512 -- Calculation Type
513 trc_CalTyp VARCHAR2(7) DEFAULT 'Unknown';
514 -- Factors
515 trc_TxbIncPtd BALANCE DEFAULT 0;
516 trc_PrdFactor NUMBER DEFAULT 0;
517 trc_PosFactor NUMBER DEFAULT 0;
518 trc_SitFactor NUMBER DEFAULT 1;
519 -- Deemed Remuneration
520 trc_DmdRmnRun BALANCE DEFAULT 0;
521 trc_TxbDmdRmn BALANCE DEFAULT 0;
522 trc_TotLibDR BALANCE DEFAULT 0;
523 trc_LibFyDR BALANCE DEFAULT 0;
524 trc_LibFpDR BALANCE DEFAULT 0;
525 -- Base Income
526 trc_BseErn BALANCE DEFAULT 0;
527 trc_TxbBseInc BALANCE DEFAULT 0;
528 trc_TotLibBse BALANCE DEFAULT 0;
529 -- Period Pension Fund
530 trc_TxbIncYtd BALANCE DEFAULT 0;
531 trc_PerTxbInc BALANCE DEFAULT 0;
532 trc_PerPenFnd BALANCE DEFAULT 0;
533 trc_PerRfiCon BALANCE DEFAULT 0;
534 trc_PerRfiTxb BALANCE DEFAULT 0;
535 trc_PerPenFndMax BALANCE DEFAULT 0;
536 trc_PerPenFndAbm BALANCE DEFAULT 0;
537 -- Annual Pension Fund
538 trc_AnnTxbInc BALANCE DEFAULT 0;
539 trc_AnnPenFnd BALANCE DEFAULT 0;
540 trc_AnnRfiCon BALANCE DEFAULT 0;
541 trc_AnnRfiTxb BALANCE DEFAULT 0;
542 trc_AnnPenFndMax BALANCE DEFAULT 0;
543 trc_AnnPenFndAbm BALANCE DEFAULT 0;
544 -- Period Arrear Pension
545 trc_PerArrPenFnd BALANCE DEFAULT 0;
546 trc_PerArrPenFndAbm BALANCE DEFAULT 0;
547 -- Annual Arrear Pension
548 trc_AnnArrPenFnd BALANCE DEFAULT 0;
549 trc_AnnArrPenFndAbm BALANCE DEFAULT 0;
550 -- Arrear Excess Update Value
551 trc_PfUpdFig BALANCE DEFAULT 0;
552 -- Period Retirement Annuity
553 trc_PerRetAnu BALANCE DEFAULT 0;
554 trc_PerNrfiCon BALANCE DEFAULT 0;
555 trc_PerRetAnuMax BALANCE DEFAULT 0;
556 trc_PerRetAnuAbm BALANCE DEFAULT 0;
557 -- Annual Retirement Annuity
558 trc_AnnRetAnu BALANCE DEFAULT 0;
559 trc_AnnNrfiCon BALANCE DEFAULT 0;
560 trc_AnnRetAnuMax BALANCE DEFAULT 0;
561 trc_AnnRetAnuAbm BALANCE DEFAULT 0;
562 -- Period Arrear Retirement Annuity
563 trc_PerArrRetAnu BALANCE DEFAULT 0;
564 trc_PerArrRetAnuAbm BALANCE DEFAULT 0;
565 -- Annual Arrear Retirement Annuity
566 trc_AnnArrRetAnu BALANCE DEFAULT 0;
567 trc_AnnArrRetAnuAbm BALANCE DEFAULT 0;
568 -- Arrear Excess Update Value
569 trc_RaUpdFig BALANCE DEFAULT 0;
570 -- Rebates Thresholds and Med Aid
571 trc_Rebate BALANCE DEFAULT 0;
572 trc_Threshold BALANCE DEFAULT 0;
573 trc_MedAidAbm BALANCE DEFAULT 0;
574 -- Abatement Totals
575 trc_PerTotAbm BALANCE DEFAULT 0;
576 trc_AnnTotAbm BALANCE DEFAULT 0;
577 -- Normal Income
578 trc_NorIncYtd BALANCE DEFAULT 0;
579 trc_NorIncPtd BALANCE DEFAULT 0;
580 trc_NorErn BALANCE DEFAULT 0;
581 trc_TxbNorInc BALANCE DEFAULT 0;
582 trc_TotLibNI BALANCE DEFAULT 0;
583 trc_LibFyNI BALANCE DEFAULT 0;
584 trc_LibFpNI BALANCE DEFAULT 0;
585 -- Fringe Benefits
586 trc_FrnBenYtd BALANCE DEFAULT 0;
590 trc_TotLibFB BALANCE DEFAULT 0;
587 trc_FrnBenPtd BALANCE DEFAULT 0;
588 trc_FrnBenErn BALANCE DEFAULT 0;
589 trc_TxbFrnInc BALANCE DEFAULT 0;
591 trc_LibFyFB BALANCE DEFAULT 0;
592 trc_LibFpFB BALANCE DEFAULT 0;
593 -- Travel Allowance
594 trc_TrvAllYtd BALANCE DEFAULT 0;
595 trc_TrvAllPtd BALANCE DEFAULT 0;
596 trc_TrvAllErn BALANCE DEFAULT 0;
597 trc_TxbTrvInc BALANCE DEFAULT 0;
598 trc_TotLibTA BALANCE DEFAULT 0;
599 trc_LibFyTA BALANCE DEFAULT 0;
600 trc_LibFpTA BALANCE DEFAULT 0;
601 -- Bonus Provision
602 trc_BonProYtd BALANCE DEFAULT 0;
603 trc_BonProPtd BALANCE DEFAULT 0;
604 trc_BonProErn BALANCE DEFAULT 0;
605 trc_TxbBonProInc BALANCE DEFAULT 0;
606 trc_TotLibBP BALANCE DEFAULT 0;
607 trc_LibFyBP BALANCE DEFAULT 0;
608 trc_LibFpBP BALANCE DEFAULT 0;
609 -- Annual Bonus
610 trc_AnnBonYtd BALANCE DEFAULT 0;
611 trc_AnnBonPtd BALANCE DEFAULT 0;
612 trc_AnnBonErn BALANCE DEFAULT 0;
613 trc_TxbAnnBonInc BALANCE DEFAULT 0;
614 trc_TotLibAB BALANCE DEFAULT 0;
615 trc_LibFyAB BALANCE DEFAULT 0;
616 trc_LibFpAB BALANCE DEFAULT 0;
617 -- Annual Payments
618 trc_AnnPymYtd BALANCE DEFAULT 0;
619 trc_AnnPymPtd BALANCE DEFAULT 0;
620 trc_AnnPymErn BALANCE DEFAULT 0;
621 trc_TxbAnnPymInc BALANCE DEFAULT 0;
622 trc_TotLibAP BALANCE DEFAULT 0;
623 trc_LibFyAP BALANCE DEFAULT 0;
624 trc_LibFpAP BALANCE DEFAULT 0;
625 -- Pubilc Office Allowance
626 trc_PblOffYtd BALANCE DEFAULT 0;
627 trc_PblOffPtd BALANCE DEFAULT 0;
628 trc_PblOffErn BALANCE DEFAULT 0;
629 trc_LibFyPO BALANCE DEFAULT 0;
630 trc_LibFpPO BALANCE DEFAULT 0;
631 -- Messages
632 trc_LibWrn VARCHAR2(100) DEFAULT ' ';
633
634 -- Statutory Deduction Value
635 trc_PayValSD BALANCE DEFAULT 0;
636 -- Employer Contribution Value
637 trc_PayValEC BALANCE DEFAULT 0;
638 -- PAYE and SITE Values
639 trc_PayeVal BALANCE DEFAULT 0;
640 trc_SiteVal BALANCE DEFAULT 0;
641 -- IT3A Threshold Indicator
642 trc_It3Ind NUMBER DEFAULT 0;
643 -- Tax Percentage Value On trace
644 trc_TxPercVal NUMBER DEFAULT 0;
645 -- Total Taxable Income Update Figure
646 trc_OUpdFig BALANCE DEFAULT 0;
647 -- Net Taxable Income Update Figure
648 trc_NtiUpdFig BALANCE DEFAULT 0;
649
650 -- ValidateTaxOns Override Globals
651 trc_LibFpDROvr BOOLEAN DEFAULT FALSE;
652 trc_LibFpNIOvr BOOLEAN DEFAULT FALSE;
653 trc_LibFpFBOvr BOOLEAN DEFAULT FALSE;
654 trc_LibFpTAOvr BOOLEAN DEFAULT FALSE;
655 trc_LibFpBPOvr BOOLEAN DEFAULT FALSE;
656 trc_LibFpABOvr BOOLEAN DEFAULT FALSE;
657 trc_LibFpAPOvr BOOLEAN DEFAULT FALSE;
658 trc_LibFpPOOvr BOOLEAN DEFAULT FALSE;
659
660 -- Global Exception Message
661 xpt_Msg VARCHAR2(100) DEFAULT 'No Error';
662 -- Global Exception
663 xpt_E EXCEPTION;
664
665 -- Override Globals
666 trc_OvrTxCalc BOOLEAN DEFAULT FALSE;
667 trc_OvrTyp VARCHAR2(1) DEFAULT 'V';
668 trc_OvrPrc NUMBER(3) DEFAULT 0;
669 trc_OvrWrn VARCHAR2(150) DEFAULT ' ';
670
671 -- Negative Ptd Global
672 trc_NegPtd BOOLEAN DEFAULT FALSE;
673
674 -- Function to Override Tax Calculation
675 --
676 FUNCTION ZaTxOvr_01032002(
677 p_OvrTyp IN VARCHAR2
678 ,p_TxOnNI IN NUMBER DEFAULT 0
679 ,p_TxOnAP IN NUMBER DEFAULT 0
680 ,p_TxPrc IN NUMBER DEFAULT 0
681 )RETURN NUMBER;
682
683
684 -- Function to Initialise Globals
685 --
686 FUNCTION ZaTxGlb_01032002(
687 -- Global Values
688 p_ZA_ADL_TX_RBT IN NUMBER DEFAULT 0
689 ,p_ZA_ARR_PF_AN_MX_ABT IN NUMBER DEFAULT 0
690 ,p_ZA_ARR_RA_AN_MX_ABT IN NUMBER DEFAULT 0
691 ,p_ZA_TRV_ALL_TX_PRC IN NUMBER DEFAULT 0
692 ,p_ZA_CC_TX_PRC IN NUMBER DEFAULT 0
693 ,p_ZA_LABOUR_BROK_PERC IN NUMBER DEFAULT 0
694 ,p_ZA_PF_AN_MX_ABT IN NUMBER DEFAULT 0
695 ,p_ZA_PF_MX_PRC IN NUMBER DEFAULT 0
696 ,p_ZA_PER_SERV_COMP_PERC IN NUMBER DEFAULT 0
697 ,p_ZA_PER_SERV_TRST_PERC IN NUMBER DEFAULT 0
698 ,p_ZA_PRI_TX_RBT IN NUMBER DEFAULT 0
699 ,p_ZA_PRI_TX_THRSHLD IN NUMBER DEFAULT 0
700 ,p_ZA_PBL_TX_PRC IN NUMBER DEFAULT 0
701 ,p_ZA_PBL_TX_RTE IN NUMBER DEFAULT 0
702 ,p_ZA_RA_AN_MX_ABT IN NUMBER DEFAULT 0
703 ,p_ZA_RA_MX_PRC IN NUMBER DEFAULT 0
704 ,p_ZA_SC_TX_THRSHLD IN NUMBER DEFAULT 0
705 ,p_ZA_SIT_LIM IN NUMBER DEFAULT 0
706 ,p_ZA_TMP_TX_RTE IN NUMBER DEFAULT 0
707 ,p_ZA_WRK_DYS_PR_YR IN NUMBER DEFAULT 0
708 ) RETURN NUMBER;
709
710 -- Function to Initialise Globals - Database Item Values
711 --
712 FUNCTION ZaTxDbi_01032002(
713 -- Database Items
714 p_BP_TX_RCV IN VARCHAR2 DEFAULT 'B'
715 ,p_PAY_PROC_PRD_DTE_PD IN DATE DEFAULT to_date('31-12-4712','DD-MM-YYYY')
716 ,p_PER_AGE IN NUMBER DEFAULT 0
720 ,p_TX_DIR_NUM IN VARCHAR2 DEFAULT 'NULL'
717 ,p_PER_DTE_OF_BRTH IN DATE DEFAULT to_date('31-12-4712','DD-MM-YYYY')
718 ,p_SEA_WRK_DYS_WRK IN NUMBER DEFAULT 0
719 ,p_SES_DTE IN DATE DEFAULT to_date('31-12-4712','DD-MM-YYYY')
721 ,p_TX_DIR_VAL IN NUMBER DEFAULT 0
722 ,p_TX_STA IN VARCHAR2 DEFAULT 'X'
723 ,p_ZA_ACT_END_DTE IN DATE DEFAULT to_date('31-12-4712','DD-MM-YYYY')
724 ,p_ZA_ACT_STRT_DTE IN DATE DEFAULT to_date('31-12-4712','DD-MM-YYYY')
725 ,p_ZA_ASG_TX_RTR_PRD IN VARCHAR2 DEFAULT 'N'
726 ,p_ZA_ASG_TX_YR IN NUMBER DEFAULT 4712
727 ,p_ZA_ASG_TX_YR_END IN DATE DEFAULT to_date('31-12-4712','DD-MM-YYYY')
728 ,p_ZA_ASG_TX_YR_STRT IN DATE DEFAULT to_date('31-12-4712','DD-MM-YYYY')
729 ,p_ZA_CUR_PRD_END_DTE IN DATE DEFAULT to_date('31-12-4712','DD-MM-YYYY')
730 ,p_ZA_CUR_PRD_STRT_DTE IN DATE DEFAULT to_date('31-12-4712','DD-MM-YYYY')
731 ,p_ZA_DYS_IN_YR IN NUMBER DEFAULT 0
732 ,p_ZA_PAY_PRDS_LFT IN NUMBER DEFAULT 0
733 ,p_ZA_PAY_PRDS_PER_YR IN NUMBER DEFAULT 0
734 ,p_ZA_TX_YR_END IN DATE DEFAULT to_date('31-12-4712','DD-MM-YYYY')
735 ,p_ZA_TX_YR_STRT IN DATE DEFAULT to_date('31-12-4712','DD-MM-YYYY')
736 ) RETURN NUMBER;
737
738
739 -- Function to Initialise Globals - Balance Values
740 -- First Section
741 FUNCTION ZaTxBal1_01032002(
742 -- Balances
743 p_ANN_ARR_PF_CMTD IN NUMBER DEFAULT 0
744 , p_ANN_ARR_PF_CYTD IN NUMBER DEFAULT 0
745 , p_ANN_ARR_PF_RUN IN NUMBER DEFAULT 0
746 , p_ANN_ARR_PF_PTD IN NUMBER DEFAULT 0
747 , p_ANN_ARR_PF_YTD IN NUMBER DEFAULT 0
748 , p_ANN_ARR_RA_CMTD IN NUMBER DEFAULT 0
749 , p_ANN_ARR_RA_CYTD IN NUMBER DEFAULT 0
750 , p_ANN_ARR_RA_RUN IN NUMBER DEFAULT 0
751 , p_ANN_ARR_RA_PTD IN NUMBER DEFAULT 0
752 , p_ANN_ARR_RA_YTD IN NUMBER DEFAULT 0
753 , p_AA_PRCHD_RVAL_NRFI_CMTD IN NUMBER DEFAULT 0
754 , p_AA_PRCHD_RVAL_NRFI_RUN IN NUMBER DEFAULT 0
755 , p_AA_PRCHD_RVAL_NRFI_PTD IN NUMBER DEFAULT 0
756 , p_AA_PRCHD_RVAL_NRFI_YTD IN NUMBER DEFAULT 0
757 , p_AA_PRCHD_RVAL_RFI_CMTD IN NUMBER DEFAULT 0
758 , p_AA_PRCHD_RVAL_RFI_RUN IN NUMBER DEFAULT 0
759 , p_AA_PRCHD_RVAL_RFI_PTD IN NUMBER DEFAULT 0
760 , p_AA_PRCHD_RVAL_RFI_YTD IN NUMBER DEFAULT 0
761 , p_AB_NRFI_CMTD IN NUMBER DEFAULT 0
762 , p_AB_NRFI_RUN IN NUMBER DEFAULT 0
763 , p_AB_NRFI_PTD IN NUMBER DEFAULT 0
764 , p_AB_NRFI_YTD IN NUMBER DEFAULT 0
765 , p_AB_RFI_CMTD IN NUMBER DEFAULT 0
766 , p_AB_RFI_RUN IN NUMBER DEFAULT 0
767 , p_AB_RFI_PTD IN NUMBER DEFAULT 0
768 , p_AB_RFI_YTD IN NUMBER DEFAULT 0
769 , p_ANN_BUR_AND_SCH_NRFI_CMTD IN NUMBER DEFAULT 0
770 , p_ANN_BUR_AND_SCH_NRFI_RUN IN NUMBER DEFAULT 0
771 , p_ANN_BUR_AND_SCH_NRFI_PTD IN NUMBER DEFAULT 0
772 , p_ANN_BUR_AND_SCH_NRFI_YTD IN NUMBER DEFAULT 0
773 , p_ANN_BUR_AND_SCH_RFI_CMTD IN NUMBER DEFAULT 0
774 , p_ANN_BUR_AND_SCH_RFI_RUN IN NUMBER DEFAULT 0
775 , p_ANN_BUR_AND_SCH_RFI_PTD IN NUMBER DEFAULT 0
776 , p_ANN_BUR_AND_SCH_RFI_YTD IN NUMBER DEFAULT 0
777 , p_AC_NRFI_CMTD IN NUMBER DEFAULT 0
778 , p_AC_NRFI_RUN IN NUMBER DEFAULT 0
779 , p_AC_NRFI_PTD IN NUMBER DEFAULT 0
780 , p_AC_NRFI_YTD IN NUMBER DEFAULT 0
781 , p_AC_RFI_CMTD IN NUMBER DEFAULT 0
782 , p_AC_RFI_RUN IN NUMBER DEFAULT 0
783 , p_AC_RFI_PTD IN NUMBER DEFAULT 0
784 , p_AC_RFI_YTD IN NUMBER DEFAULT 0
785 , p_ANN_PF_CMTD IN NUMBER DEFAULT 0
786 , p_ANN_PF_CYTD IN NUMBER DEFAULT 0
787 , p_ANN_PF_RUN IN NUMBER DEFAULT 0
788 , p_ANN_PF_PTD IN NUMBER DEFAULT 0
789 , p_ANN_PF_YTD IN NUMBER DEFAULT 0
790 , p_ARES_TRD_NRFI_CMTD IN NUMBER DEFAULT 0
791 , p_ARES_TRD_NRFI_RUN IN NUMBER DEFAULT 0
792 , p_ARES_TRD_NRFI_PTD IN NUMBER DEFAULT 0
793 , p_ARES_TRD_NRFI_YTD IN NUMBER DEFAULT 0
794 , p_ARES_TRD_RFI_CMTD IN NUMBER DEFAULT 0
795 , p_ARES_TRD_RFI_RUN IN NUMBER DEFAULT 0
796 , p_ARES_TRD_RFI_PTD IN NUMBER DEFAULT 0
797 , p_ARES_TRD_RFI_YTD IN NUMBER DEFAULT 0
798 , p_ANN_RA_CMTD IN NUMBER DEFAULT 0
799 , p_ANN_RA_CYTD IN NUMBER DEFAULT 0
800 , p_ANN_RA_RUN IN NUMBER DEFAULT 0
801 , p_ANN_RA_PTD IN NUMBER DEFAULT 0
802 , p_ANN_RA_YTD IN NUMBER DEFAULT 0
803 , p_ANU_FRM_RET_FND_NRFI_CMTD IN NUMBER DEFAULT 0
804 , p_ANU_FRM_RET_FND_NRFI_RUN IN NUMBER DEFAULT 0
805 , p_ANU_FRM_RET_FND_NRFI_PTD IN NUMBER DEFAULT 0
806 , p_ANU_FRM_RET_FND_NRFI_YTD IN NUMBER DEFAULT 0
810 , p_ANU_FRM_RET_FND_RFI_YTD IN NUMBER DEFAULT 0
807 , p_ANU_FRM_RET_FND_RFI_CMTD IN NUMBER DEFAULT 0
808 , p_ANU_FRM_RET_FND_RFI_RUN IN NUMBER DEFAULT 0
809 , p_ANU_FRM_RET_FND_RFI_PTD IN NUMBER DEFAULT 0
811 , p_ARR_PF_CMTD IN NUMBER DEFAULT 0
812 , p_ARR_PF_CYTD IN NUMBER DEFAULT 0
813 , p_ARR_PF_PTD IN NUMBER DEFAULT 0
814 , p_ARR_PF_YTD IN NUMBER DEFAULT 0
815 , p_ARR_RA_CMTD IN NUMBER DEFAULT 0
816 , p_ARR_RA_CYTD IN NUMBER DEFAULT 0
817 , p_ARR_RA_PTD IN NUMBER DEFAULT 0
818 , p_ARR_RA_YTD IN NUMBER DEFAULT 0
819 , p_AST_PRCHD_RVAL_NRFI_CMTD IN NUMBER DEFAULT 0
820 , p_AST_PRCHD_RVAL_NRFI_CYTD IN NUMBER DEFAULT 0
821 , p_AST_PRCHD_RVAL_NRFI_RUN IN NUMBER DEFAULT 0
822 , p_AST_PRCHD_RVAL_NRFI_PTD IN NUMBER DEFAULT 0
823 , p_AST_PRCHD_RVAL_NRFI_YTD IN NUMBER DEFAULT 0
824 , p_AST_PRCHD_RVAL_RFI_CMTD IN NUMBER DEFAULT 0
825 , p_AST_PRCHD_RVAL_RFI_CYTD IN NUMBER DEFAULT 0
826 , p_AST_PRCHD_RVAL_RFI_RUN IN NUMBER DEFAULT 0
827 , p_AST_PRCHD_RVAL_RFI_PTD IN NUMBER DEFAULT 0
828 , p_AST_PRCHD_RVAL_RFI_YTD IN NUMBER DEFAULT 0
829 ) RETURN NUMBER;
830
831 -- Function to Initialise Globals - Balance Values
832 -- Second Section
833 FUNCTION ZaTxBal2_01032002(
834 -- Balances
835 p_BP_CMTD IN NUMBER DEFAULT 0
836 , p_BP_PTD IN NUMBER DEFAULT 0
837 , p_BP_YTD IN NUMBER DEFAULT 0
838 , p_BUR_AND_SCH_NRFI_CMTD IN NUMBER DEFAULT 0
839 , p_BUR_AND_SCH_NRFI_CYTD IN NUMBER DEFAULT 0
840 , p_BUR_AND_SCH_NRFI_RUN IN NUMBER DEFAULT 0
841 , p_BUR_AND_SCH_NRFI_PTD IN NUMBER DEFAULT 0
842 , p_BUR_AND_SCH_NRFI_YTD IN NUMBER DEFAULT 0
843 , p_BUR_AND_SCH_RFI_CMTD IN NUMBER DEFAULT 0
844 , p_BUR_AND_SCH_RFI_CYTD IN NUMBER DEFAULT 0
845 , p_BUR_AND_SCH_RFI_RUN IN NUMBER DEFAULT 0
846 , p_BUR_AND_SCH_RFI_PTD IN NUMBER DEFAULT 0
847 , p_BUR_AND_SCH_RFI_YTD IN NUMBER DEFAULT 0
848 , p_COMM_NRFI_CMTD IN NUMBER DEFAULT 0
849 , p_COMM_NRFI_CYTD IN NUMBER DEFAULT 0
850 , p_COMM_NRFI_RUN IN NUMBER DEFAULT 0
851 , p_COMM_NRFI_PTD IN NUMBER DEFAULT 0
852 , p_COMM_NRFI_YTD IN NUMBER DEFAULT 0
853 , p_COMM_RFI_CMTD IN NUMBER DEFAULT 0
854 , p_COMM_RFI_CYTD IN NUMBER DEFAULT 0
855 , p_COMM_RFI_RUN IN NUMBER DEFAULT 0
856 , p_COMM_RFI_PTD IN NUMBER DEFAULT 0
857 , p_COMM_RFI_YTD IN NUMBER DEFAULT 0
858 , p_COMP_ALL_NRFI_CMTD IN NUMBER DEFAULT 0
859 , p_COMP_ALL_NRFI_CYTD IN NUMBER DEFAULT 0
860 , p_COMP_ALL_NRFI_RUN IN NUMBER DEFAULT 0
861 , p_COMP_ALL_NRFI_PTD IN NUMBER DEFAULT 0
862 , p_COMP_ALL_NRFI_YTD IN NUMBER DEFAULT 0
863 , p_COMP_ALL_RFI_CMTD IN NUMBER DEFAULT 0
864 , p_COMP_ALL_RFI_CYTD IN NUMBER DEFAULT 0
865 , p_COMP_ALL_RFI_RUN IN NUMBER DEFAULT 0
866 , p_COMP_ALL_RFI_PTD IN NUMBER DEFAULT 0
867 , p_COMP_ALL_RFI_YTD IN NUMBER DEFAULT 0
868 , p_CUR_PF_CMTD IN NUMBER DEFAULT 0
869 , p_CUR_PF_CYTD IN NUMBER DEFAULT 0
870 , p_CUR_PF_RUN IN NUMBER DEFAULT 0
871 , p_CUR_PF_PTD IN NUMBER DEFAULT 0
872 , p_CUR_PF_YTD IN NUMBER DEFAULT 0
873 , p_CUR_RA_CMTD IN NUMBER DEFAULT 0
874 , p_CUR_RA_CYTD IN NUMBER DEFAULT 0
875 , p_CUR_RA_RUN IN NUMBER DEFAULT 0
876 , p_CUR_RA_PTD IN NUMBER DEFAULT 0
877 , p_CUR_RA_YTD IN NUMBER DEFAULT 0
878 , p_DIR_DMD_RMN_ITD IN NUMBER DEFAULT 0
879 , p_ENT_ALL_NRFI_CMTD IN NUMBER DEFAULT 0
880 , p_ENT_ALL_NRFI_CYTD IN NUMBER DEFAULT 0
881 , p_ENT_ALL_NRFI_RUN IN NUMBER DEFAULT 0
882 , p_ENT_ALL_NRFI_PTD IN NUMBER DEFAULT 0
883 , p_ENT_ALL_NRFI_YTD IN NUMBER DEFAULT 0
884 , p_ENT_ALL_RFI_CMTD IN NUMBER DEFAULT 0
885 , p_ENT_ALL_RFI_CYTD IN NUMBER DEFAULT 0
886 , p_ENT_ALL_RFI_RUN IN NUMBER DEFAULT 0
887 , p_ENT_ALL_RFI_PTD IN NUMBER DEFAULT 0
888 , p_ENT_ALL_RFI_YTD IN NUMBER DEFAULT 0
889 , p_EXC_ARR_PEN_ITD IN NUMBER DEFAULT 0
890 , p_EXC_ARR_PEN_PTD IN NUMBER DEFAULT 0
891 , p_EXC_ARR_PEN_YTD IN NUMBER DEFAULT 0
892 , p_EXC_ARR_RA_ITD IN NUMBER DEFAULT 0
893 , p_EXC_ARR_RA_PTD IN NUMBER DEFAULT 0
894 , p_EXC_ARR_RA_YTD IN NUMBER DEFAULT 0
895 , p_FREE_ACCOM_NRFI_CMTD IN NUMBER DEFAULT 0
896 , p_FREE_ACCOM_NRFI_CYTD IN NUMBER DEFAULT 0
900 , p_FREE_ACCOM_RFI_CMTD IN NUMBER DEFAULT 0
897 , p_FREE_ACCOM_NRFI_RUN IN NUMBER DEFAULT 0
898 , p_FREE_ACCOM_NRFI_PTD IN NUMBER DEFAULT 0
899 , p_FREE_ACCOM_NRFI_YTD IN NUMBER DEFAULT 0
901 , p_FREE_ACCOM_RFI_CYTD IN NUMBER DEFAULT 0
902 , p_FREE_ACCOM_RFI_RUN IN NUMBER DEFAULT 0
903 , p_FREE_ACCOM_RFI_PTD IN NUMBER DEFAULT 0
904 , p_FREE_ACCOM_RFI_YTD IN NUMBER DEFAULT 0
905 , p_FREE_SERV_NRFI_CMTD IN NUMBER DEFAULT 0
906 , p_FREE_SERV_NRFI_CYTD IN NUMBER DEFAULT 0
907 , p_FREE_SERV_NRFI_RUN IN NUMBER DEFAULT 0
908 , p_FREE_SERV_NRFI_PTD IN NUMBER DEFAULT 0
909 , p_FREE_SERV_NRFI_YTD IN NUMBER DEFAULT 0
910 , p_FREE_SERV_RFI_CMTD IN NUMBER DEFAULT 0
911 , p_FREE_SERV_RFI_CYTD IN NUMBER DEFAULT 0
912 , p_FREE_SERV_RFI_RUN IN NUMBER DEFAULT 0
913 , p_FREE_SERV_RFI_PTD IN NUMBER DEFAULT 0
914 , p_FREE_SERV_RFI_YTD IN NUMBER DEFAULT 0
915 ) RETURN NUMBER;
916
917 -- Function to Initialise Globals - Balance Values
918 -- Third Section
919 FUNCTION ZaTxBal3_01032002(
920 -- Balances
921 p_LOW_LOANS_NRFI_CMTD IN NUMBER DEFAULT 0
922 , p_LOW_LOANS_NRFI_CYTD IN NUMBER DEFAULT 0
923 , p_LOW_LOANS_NRFI_RUN IN NUMBER DEFAULT 0
924 , p_LOW_LOANS_NRFI_PTD IN NUMBER DEFAULT 0
925 , p_LOW_LOANS_NRFI_YTD IN NUMBER DEFAULT 0
926 , p_LOW_LOANS_RFI_CMTD IN NUMBER DEFAULT 0
927 , p_LOW_LOANS_RFI_CYTD IN NUMBER DEFAULT 0
928 , p_LOW_LOANS_RFI_RUN IN NUMBER DEFAULT 0
929 , p_LOW_LOANS_RFI_PTD IN NUMBER DEFAULT 0
930 , p_LOW_LOANS_RFI_YTD IN NUMBER DEFAULT 0
931 , p_MLS_AND_VOUCH_NRFI_CMTD IN NUMBER DEFAULT 0
932 , p_MLS_AND_VOUCH_NRFI_CYTD IN NUMBER DEFAULT 0
933 , p_MLS_AND_VOUCH_NRFI_RUN IN NUMBER DEFAULT 0
934 , p_MLS_AND_VOUCH_NRFI_PTD IN NUMBER DEFAULT 0
935 , p_MLS_AND_VOUCH_NRFI_YTD IN NUMBER DEFAULT 0
936 , p_MLS_AND_VOUCH_RFI_CMTD IN NUMBER DEFAULT 0
937 , p_MLS_AND_VOUCH_RFI_CYTD IN NUMBER DEFAULT 0
938 , p_MLS_AND_VOUCH_RFI_RUN IN NUMBER DEFAULT 0
939 , p_MLS_AND_VOUCH_RFI_PTD IN NUMBER DEFAULT 0
940 , p_MLS_AND_VOUCH_RFI_YTD IN NUMBER DEFAULT 0
941 , p_MED_CONTR_CMTD IN NUMBER DEFAULT 0
942 , p_MED_CONTR_CYTD IN NUMBER DEFAULT 0
943 , p_MED_CONTR_RUN IN NUMBER DEFAULT 0
944 , p_MED_CONTR_PTD IN NUMBER DEFAULT 0
945 , p_MED_CONTR_YTD IN NUMBER DEFAULT 0
946 , p_MED_PAID_NRFI_CMTD IN NUMBER DEFAULT 0
947 , p_MED_PAID_NRFI_CYTD IN NUMBER DEFAULT 0
948 , p_MED_PAID_NRFI_RUN IN NUMBER DEFAULT 0
949 , p_MED_PAID_NRFI_PTD IN NUMBER DEFAULT 0
950 , p_MED_PAID_NRFI_YTD IN NUMBER DEFAULT 0
951 , p_MED_PAID_RFI_CMTD IN NUMBER DEFAULT 0
952 , p_MED_PAID_RFI_CYTD IN NUMBER DEFAULT 0
953 , p_MED_PAID_RFI_RUN IN NUMBER DEFAULT 0
954 , p_MED_PAID_RFI_PTD IN NUMBER DEFAULT 0
955 , p_MED_PAID_RFI_YTD IN NUMBER DEFAULT 0
956 , p_NET_PAY_RUN IN NUMBER DEFAULT 0
957 , p_NET_TXB_INC_CMTD IN NUMBER DEFAULT 0
958 , p_OTHER_TXB_ALL_NRFI_CMTD IN NUMBER DEFAULT 0
959 , p_OTHER_TXB_ALL_NRFI_CYTD IN NUMBER DEFAULT 0
960 , p_OTHER_TXB_ALL_NRFI_RUN IN NUMBER DEFAULT 0
961 , p_OTHER_TXB_ALL_NRFI_PTD IN NUMBER DEFAULT 0
962 , p_OTHER_TXB_ALL_NRFI_YTD IN NUMBER DEFAULT 0
963 , p_OTHER_TXB_ALL_RFI_CMTD IN NUMBER DEFAULT 0
964 , p_OTHER_TXB_ALL_RFI_CYTD IN NUMBER DEFAULT 0
965 , p_OTHER_TXB_ALL_RFI_RUN IN NUMBER DEFAULT 0
966 , p_OTHER_TXB_ALL_RFI_PTD IN NUMBER DEFAULT 0
967 , p_OTHER_TXB_ALL_RFI_YTD IN NUMBER DEFAULT 0
968 , p_OVTM_NRFI_CMTD IN NUMBER DEFAULT 0
969 , p_OVTM_NRFI_CYTD IN NUMBER DEFAULT 0
970 , p_OVTM_NRFI_RUN IN NUMBER DEFAULT 0
971 , p_OVTM_NRFI_PTD IN NUMBER DEFAULT 0
972 , p_OVTM_NRFI_YTD IN NUMBER DEFAULT 0
973 , p_OVTM_RFI_CMTD IN NUMBER DEFAULT 0
974 , p_OVTM_RFI_CYTD IN NUMBER DEFAULT 0
975 , p_OVTM_RFI_RUN IN NUMBER DEFAULT 0
976 , p_OVTM_RFI_PTD IN NUMBER DEFAULT 0
977 , p_OVTM_RFI_YTD IN NUMBER DEFAULT 0
978 , p_PAYE_YTD IN NUMBER DEFAULT 0
979 , p_PYM_DBT_NRFI_CMTD IN NUMBER DEFAULT 0
980 , p_PYM_DBT_NRFI_CYTD IN NUMBER DEFAULT 0
981 , p_PYM_DBT_NRFI_RUN IN NUMBER DEFAULT 0
982 , p_PYM_DBT_NRFI_PTD IN NUMBER DEFAULT 0
983 , p_PYM_DBT_NRFI_YTD IN NUMBER DEFAULT 0
984 , p_PYM_DBT_RFI_CMTD IN NUMBER DEFAULT 0
985 , p_PYM_DBT_RFI_CYTD IN NUMBER DEFAULT 0
986 , p_PYM_DBT_RFI_RUN IN NUMBER DEFAULT 0
990
987 , p_PYM_DBT_RFI_PTD IN NUMBER DEFAULT 0
988 , p_PYM_DBT_RFI_YTD IN NUMBER DEFAULT 0
989 ) RETURN NUMBER;
991 -- Function to Initialise Globals - Balance Values
992 -- Fourth Section
993 FUNCTION ZaTxBal4_01032002(
994 -- Balances
995 p_PO_NRFI_CMTD IN NUMBER DEFAULT 0
996 , p_PO_NRFI_RUN IN NUMBER DEFAULT 0
997 , p_PO_NRFI_PTD IN NUMBER DEFAULT 0
998 , p_PO_NRFI_YTD IN NUMBER DEFAULT 0
999 , p_PO_RFI_CMTD IN NUMBER DEFAULT 0
1000 , p_PO_RFI_RUN IN NUMBER DEFAULT 0
1001 , p_PO_RFI_PTD IN NUMBER DEFAULT 0
1002 , p_PO_RFI_YTD IN NUMBER DEFAULT 0
1003 , p_PRCH_ANU_TXB_NRFI_CMTD IN NUMBER DEFAULT 0
1004 , p_PRCH_ANU_TXB_NRFI_RUN IN NUMBER DEFAULT 0
1005 , p_PRCH_ANU_TXB_NRFI_PTD IN NUMBER DEFAULT 0
1006 , p_PRCH_ANU_TXB_NRFI_YTD IN NUMBER DEFAULT 0
1007 , p_PRCH_ANU_TXB_RFI_CMTD IN NUMBER DEFAULT 0
1008 , p_PRCH_ANU_TXB_RFI_RUN IN NUMBER DEFAULT 0
1009 , p_PRCH_ANU_TXB_RFI_PTD IN NUMBER DEFAULT 0
1010 , p_PRCH_ANU_TXB_RFI_YTD IN NUMBER DEFAULT 0
1011 , p_RES_TRD_NRFI_CMTD IN NUMBER DEFAULT 0
1012 , p_RES_TRD_NRFI_CYTD IN NUMBER DEFAULT 0
1013 , p_RES_TRD_NRFI_RUN IN NUMBER DEFAULT 0
1014 , p_RES_TRD_NRFI_PTD IN NUMBER DEFAULT 0
1015 , p_RES_TRD_NRFI_YTD IN NUMBER DEFAULT 0
1016 , p_RES_TRD_RFI_CMTD IN NUMBER DEFAULT 0
1017 , p_RES_TRD_RFI_CYTD IN NUMBER DEFAULT 0
1018 , p_RES_TRD_RFI_RUN IN NUMBER DEFAULT 0
1019 , p_RES_TRD_RFI_PTD IN NUMBER DEFAULT 0
1020 , p_RES_TRD_RFI_YTD IN NUMBER DEFAULT 0
1021 , p_RGT_AST_NRFI_CMTD IN NUMBER DEFAULT 0
1022 , p_RGT_AST_NRFI_CYTD IN NUMBER DEFAULT 0
1023 , p_RGT_AST_NRFI_RUN IN NUMBER DEFAULT 0
1024 , p_RGT_AST_NRFI_PTD IN NUMBER DEFAULT 0
1025 , p_RGT_AST_NRFI_YTD IN NUMBER DEFAULT 0
1026 , p_RGT_AST_RFI_CMTD IN NUMBER DEFAULT 0
1027 , p_RGT_AST_RFI_CYTD IN NUMBER DEFAULT 0
1028 , p_RGT_AST_RFI_RUN IN NUMBER DEFAULT 0
1029 , p_RGT_AST_RFI_PTD IN NUMBER DEFAULT 0
1030 , p_RGT_AST_RFI_YTD IN NUMBER DEFAULT 0
1031 , p_SITE_YTD IN NUMBER DEFAULT 0
1032 , p_TAX_YTD IN NUMBER DEFAULT 0
1033 , p_TX_ON_AB_PTD IN NUMBER DEFAULT 0
1034 , p_TX_ON_AB_YTD IN NUMBER DEFAULT 0
1035 , p_TX_ON_AP_RUN IN NUMBER DEFAULT 0
1036 , p_TX_ON_AP_PTD IN NUMBER DEFAULT 0
1037 , p_TX_ON_AP_YTD IN NUMBER DEFAULT 0
1038 , p_TX_ON_BP_PTD IN NUMBER DEFAULT 0
1039 , p_TX_ON_BP_YTD IN NUMBER DEFAULT 0
1040 , p_TX_ON_TA_PTD IN NUMBER DEFAULT 0
1041 , p_TX_ON_TA_YTD IN NUMBER DEFAULT 0
1042 , p_TX_ON_DR_PTD IN NUMBER DEFAULT 0
1043 , p_TX_ON_DR_YTD IN NUMBER DEFAULT 0
1044 , p_TX_ON_FB_PTD IN NUMBER DEFAULT 0
1045 , p_TX_ON_FB_YTD IN NUMBER DEFAULT 0
1046 , p_TX_ON_NI_PTD IN NUMBER DEFAULT 0
1047 , p_TX_ON_NI_YTD IN NUMBER DEFAULT 0
1048 , p_TX_ON_PO_PTD IN NUMBER DEFAULT 0
1049 , p_TX_ON_PO_YTD IN NUMBER DEFAULT 0
1050 , p_TXB_AP_NRFI_CMTD IN NUMBER DEFAULT 0
1051 , p_TXB_AP_NRFI_RUN IN NUMBER DEFAULT 0
1052 , p_TXB_AP_NRFI_PTD IN NUMBER DEFAULT 0
1053 , p_TXB_AP_NRFI_YTD IN NUMBER DEFAULT 0
1054 , p_TXB_AP_RFI_CMTD IN NUMBER DEFAULT 0
1055 , p_TXB_AP_RFI_RUN IN NUMBER DEFAULT 0
1056 , p_TXB_AP_RFI_PTD IN NUMBER DEFAULT 0
1057 , p_TXB_AP_RFI_YTD IN NUMBER DEFAULT 0
1058 , p_TXB_INC_NRFI_CMTD IN NUMBER DEFAULT 0
1059 , p_TXB_INC_NRFI_CYTD IN NUMBER DEFAULT 0
1060 , p_TXB_INC_NRFI_RUN IN NUMBER DEFAULT 0
1061 , p_TXB_INC_NRFI_PTD IN NUMBER DEFAULT 0
1062 , p_TXB_INC_NRFI_YTD IN NUMBER DEFAULT 0
1063 , p_TXB_INC_RFI_CMTD IN NUMBER DEFAULT 0
1064 , p_TXB_INC_RFI_CYTD IN NUMBER DEFAULT 0
1065 , p_TXB_INC_RFI_RUN IN NUMBER DEFAULT 0
1066 , p_TXB_INC_RFI_PTD IN NUMBER DEFAULT 0
1067 , p_TXB_INC_RFI_YTD IN NUMBER DEFAULT 0
1068 ) RETURN NUMBER;
1069
1070 FUNCTION ZaTxBal5_01032002(
1071 -- Balances
1072 p_TXB_PEN_NRFI_CMTD IN NUMBER DEFAULT 0
1073 , p_TXB_PEN_NRFI_CYTD IN NUMBER DEFAULT 0
1074 , p_TXB_PEN_NRFI_RUN IN NUMBER DEFAULT 0
1075 , p_TXB_PEN_NRFI_PTD IN NUMBER DEFAULT 0
1076 , p_TXB_PEN_NRFI_YTD IN NUMBER DEFAULT 0
1077 , p_TXB_PEN_RFI_CMTD IN NUMBER DEFAULT 0
1078 , p_TXB_PEN_RFI_CYTD IN NUMBER DEFAULT 0
1079 , p_TXB_PEN_RFI_RUN IN NUMBER DEFAULT 0
1083 , p_TEL_ALL_NRFI_CYTD IN NUMBER DEFAULT 0
1080 , p_TXB_PEN_RFI_PTD IN NUMBER DEFAULT 0
1081 , p_TXB_PEN_RFI_YTD IN NUMBER DEFAULT 0
1082 , p_TEL_ALL_NRFI_CMTD IN NUMBER DEFAULT 0
1084 , p_TEL_ALL_NRFI_RUN IN NUMBER DEFAULT 0
1085 , p_TEL_ALL_NRFI_PTD IN NUMBER DEFAULT 0
1086 , p_TEL_ALL_NRFI_YTD IN NUMBER DEFAULT 0
1087 , p_TEL_ALL_RFI_CMTD IN NUMBER DEFAULT 0
1088 , p_TEL_ALL_RFI_CYTD IN NUMBER DEFAULT 0
1089 , p_TEL_ALL_RFI_RUN IN NUMBER DEFAULT 0
1090 , p_TEL_ALL_RFI_PTD IN NUMBER DEFAULT 0
1091 , p_TEL_ALL_RFI_YTD IN NUMBER DEFAULT 0
1092 , p_TOOL_ALL_NRFI_CMTD IN NUMBER DEFAULT 0
1093 , p_TOOL_ALL_NRFI_CYTD IN NUMBER DEFAULT 0
1094 , p_TOOL_ALL_NRFI_RUN IN NUMBER DEFAULT 0
1095 , p_TOOL_ALL_NRFI_PTD IN NUMBER DEFAULT 0
1096 , p_TOOL_ALL_NRFI_YTD IN NUMBER DEFAULT 0
1097 , p_TOOL_ALL_RFI_CMTD IN NUMBER DEFAULT 0
1098 , p_TOOL_ALL_RFI_CYTD IN NUMBER DEFAULT 0
1099 , p_TOOL_ALL_RFI_RUN IN NUMBER DEFAULT 0
1100 , p_TOOL_ALL_RFI_PTD IN NUMBER DEFAULT 0
1101 , p_TOOL_ALL_RFI_YTD IN NUMBER DEFAULT 0
1102 , p_TOT_INC_PTD IN NUMBER DEFAULT 0
1103 , p_TOT_INC_YTD IN NUMBER DEFAULT 0
1104 , p_TOT_NRFI_AN_INC_CMTD IN NUMBER DEFAULT 0
1105 , p_TOT_NRFI_AN_INC_CYTD IN NUMBER DEFAULT 0
1106 , p_TOT_NRFI_AN_INC_RUN IN NUMBER DEFAULT 0
1107 , p_TOT_NRFI_AN_INC_PTD IN NUMBER DEFAULT 0
1108 , p_TOT_NRFI_AN_INC_YTD IN NUMBER DEFAULT 0
1109 , p_TOT_NRFI_INC_CMTD IN NUMBER DEFAULT 0
1110 , p_TOT_NRFI_INC_CYTD IN NUMBER DEFAULT 0
1111 , p_TOT_NRFI_INC_RUN IN NUMBER DEFAULT 0
1112 , p_TOT_NRFI_INC_PTD IN NUMBER DEFAULT 0
1113 , p_TOT_NRFI_INC_YTD IN NUMBER DEFAULT 0
1114 , p_TOT_RFI_AN_INC_CMTD IN NUMBER DEFAULT 0
1115 , p_TOT_RFI_AN_INC_CYTD IN NUMBER DEFAULT 0
1116 , p_TOT_RFI_AN_INC_RUN IN NUMBER DEFAULT 0
1117 , p_TOT_RFI_AN_INC_PTD IN NUMBER DEFAULT 0
1118 , p_TOT_RFI_AN_INC_YTD IN NUMBER DEFAULT 0
1119 , p_TOT_RFI_INC_CMTD IN NUMBER DEFAULT 0
1120 , p_TOT_RFI_INC_CYTD IN NUMBER DEFAULT 0
1121 , p_TOT_RFI_INC_RUN IN NUMBER DEFAULT 0
1122 , p_TOT_RFI_INC_PTD IN NUMBER DEFAULT 0
1123 , p_TOT_RFI_INC_YTD IN NUMBER DEFAULT 0
1124 , p_TOT_SEA_WRK_DYS_WRK_YTD IN NUMBER DEFAULT 0
1125 , p_TOT_TXB_INC_ITD IN NUMBER DEFAULT 0
1126 , p_TA_NRFI_CMTD IN NUMBER DEFAULT 0
1127 , p_TA_NRFI_CYTD IN NUMBER DEFAULT 0
1128 , p_TA_NRFI_PTD IN NUMBER DEFAULT 0
1129 , p_TA_NRFI_YTD IN NUMBER DEFAULT 0
1130 , p_TA_RFI_CMTD IN NUMBER DEFAULT 0
1131 , p_TA_RFI_CYTD IN NUMBER DEFAULT 0
1132 , p_TA_RFI_PTD IN NUMBER DEFAULT 0
1133 , p_TA_RFI_YTD IN NUMBER DEFAULT 0
1134 , p_USE_VEH_NRFI_CMTD IN NUMBER DEFAULT 0
1135 , p_USE_VEH_NRFI_CYTD IN NUMBER DEFAULT 0
1136 , p_USE_VEH_NRFI_RUN IN NUMBER DEFAULT 0
1137 , p_USE_VEH_NRFI_PTD IN NUMBER DEFAULT 0
1138 , p_USE_VEH_NRFI_YTD IN NUMBER DEFAULT 0
1139 , p_USE_VEH_RFI_CMTD IN NUMBER DEFAULT 0
1140 , p_USE_VEH_RFI_CYTD IN NUMBER DEFAULT 0
1141 , p_USE_VEH_RFI_RUN IN NUMBER DEFAULT 0
1142 , p_USE_VEH_RFI_PTD IN NUMBER DEFAULT 0
1143 , p_USE_VEH_RFI_YTD IN NUMBER DEFAULT 0
1144 ) RETURN NUMBER;
1145
1146
1147 -- Main Tax Function
1148 -- Called from Fast Formula
1149 FUNCTION ZaTx_01032002(
1150 /* PARAMETERS */
1151 -- Contexts
1152 ASSIGNMENT_ACTION_ID IN NUMBER
1153 ,ASSIGNMENT_ID IN NUMBER
1154 ,PAYROLL_ACTION_ID IN NUMBER
1155 ,PAYROLL_ID IN NUMBER
1156 -- Out Parameters
1157 , p_LibWrn OUT NOCOPY VARCHAR2
1158 , p_LibFpDR OUT NOCOPY NUMBER
1159 , p_LibFpNI OUT NOCOPY NUMBER
1160 , p_LibFpFB OUT NOCOPY NUMBER
1161 , p_LibFpTA OUT NOCOPY NUMBER
1162 , p_LibFpBP OUT NOCOPY NUMBER
1163 , p_LibFpAB OUT NOCOPY NUMBER
1164 , p_LibFpAP OUT NOCOPY NUMBER
1165 , p_LibFpPO OUT NOCOPY NUMBER
1166 , p_PayValSD OUT NOCOPY NUMBER
1167 , p_PayValEC OUT NOCOPY NUMBER
1168 , p_PayeVal OUT NOCOPY NUMBER
1169 , p_SiteVal OUT NOCOPY NUMBER
1170 , p_It3Ind OUT NOCOPY NUMBER
1171 , p_PfUpdFig OUT NOCOPY NUMBER
1172 , p_RaUpdFig OUT NOCOPY NUMBER
1173 , p_OUpdFig OUT NOCOPY NUMBER
1174 , p_NtiUpdFig OUT NOCOPY NUMBER
1175 , p_OvrWrn OUT NOCOPY VARCHAR2
1176 )RETURN NUMBER;
1177
1178
1179
1180
1181
1182 END py_za_tx_01032002;
1183