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