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