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