1 PACKAGE py_za_tx_01032013 AUTHID CURRENT_USER AS
2 /* $Header: pyzat014.pkh 120.0.12020000.4 2012/11/27 10:59:21 nchinnam noship $ */
3 /* Copyright (c) Oracle Corporation 2005. All rights reserved. */
4 /*
5 PRODUCT
6 Oracle Payroll - ZA Localisation Tax Module
7 NAME
8 py_za_tx_01032013.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_01032013
17 This function is called from Oracle Applications Fast Formula.
18 It passes all necessary global values to the main tax package.
19 ZaTxDbi_01032013
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_01032013
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_01032013
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_01032013
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_01032013
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 Version Bug Comments
46 ---------- ---------- -------------- ------- --------------------------------
47 R Babla 22/04/2009 115.0 Copied from pyzat008.pkh ver115.0
48 Added package variables for TYS2010
49 R Babla 10/06/2009 115.1 8512751 Passed few additional parameters
50 in ZATxBal% functions and added a
51 new globals for balances and trace
52 for EMP201
53 R Babla 29/07/2009 115.2 8526698 Added few globals for Net to Gross.
54 New parameters passed to few functions
55 for net to gross
56 R Babla 20/09/2009 115.3 8824018 Added few globals for Abatements for Net to Gross
57 New parameters passed to function ZaTxBal5_01032013
58 R Babla 01/09/2009 115.4 8844712 Added a global for tax percentage of Late Payments
59 R Babla 24/02/2010 115.5 9369895 Added a global for Pension Basis
60 R Babla 26/02/2010 115.6 9397464 Removed reference of dbi_ZA_ASG_TX_YR%
61 NCHINNAM 03/11/2010 115.7 10245740 Non Cumilative tax method enhancement changes.
62 NCHINNAM 24/02/2011 115.1 11806660 2011/12 Tax Year End Legislative Changes.
63 ABDASH 07/03/2012 115.7 13777759 CHANGES FOR MEDICAL AID TAX CREDIT FUNCTIONALIY
64 ABDASH 08/03/2012 115.8 13777759 CHANGES FOR MEDICAL AID TAX CREDIT FUNCTIONALIY
65 ABDASH 08/03/2012 115.12 14024624 APPLICATION OF MEDICAL TAX CREDIT ON DIRECTOR'S DEEMED REMUNERATION.
66 NCHINNAM 08/03/2012 115.13 14045928 MEDICAL TAX CREDIT For Lump sum Changes.
67 ABDASH 12/06/2012 115.14 14168167 MAC ALLOWED TO BE REFUNDED INCASE OF EMPLOYEE ABOVE AGE 65 OR WHEN BALANCES FOR CODE 3810, 4005 AND 4474 ARE ZERO.
68 */
69 -------------------------------------------------------------------------------
70 -- PACKAGE GLOBAL AREA --
71 -------------------------------------------------------------------------------
72 -- Types
73 -------------------------------------------------------------------------------
74 SUBTYPE BALANCE IS py_za_tx_utl_01032013.t_balance;
75 -------------------------------------------------------------------------------
76 -- Application Contexts
77 -------------------------------------------------------------------------------
78 con_ASG_ACT_ID NUMBER;
79 con_ASG_ID NUMBER;
80 con_PRL_ACT_ID NUMBER;
81 con_PRL_ID NUMBER;
82 -------------------------------------------------------------------------------
83 -- Application Global Values
84 -------------------------------------------------------------------------------
85 glb_ZA_ADL_TX_RBT NUMBER;
86 glb_ZA_ARR_PF_AN_MX_ABT NUMBER;
87 glb_ZA_ARR_RA_AN_MX_ABT NUMBER;
88 glb_ZA_TRV_ALL_TX_PRC NUMBER;
89 glb_ZA_CC_TX_PRC NUMBER;
90 glb_ZA_PF_AN_MX_ABT NUMBER;
91 glb_ZA_PF_MX_PRC NUMBER;
92 glb_ZA_PER_SERV_COMP_PERC NUMBER;
93 glb_ZA_PER_SERV_TRST_PERC NUMBER;
94 glb_ZA_PRI_TX_RBT NUMBER;
95 glb_ZA_PRI_TX_THRSHLD NUMBER;
96 glb_ZA_PBL_TX_PRC NUMBER;
97 glb_ZA_PBL_TX_RTE NUMBER;
98 glb_ZA_RA_AN_MX_ABT NUMBER;
99 glb_ZA_RA_MX_PRC NUMBER;
100 glb_ZA_SC_TX_THRSHLD NUMBER;
101 glb_ZA_SIT_LIM NUMBER;
102 glb_ZA_TMP_TX_RTE NUMBER;
103 glb_ZA_WRK_DYS_PR_YR NUMBER;
104 glb_ZA_ALLOW_DONATION_PERC NUMBER; /*TYS2010*/
105 --Bug 8844712
106 glb_ZA_LATE_PAYMENT_PERC NUMBER;
107 glb_ZA_TRI_TX_RBT NUMBER;
108 glb_ZA_TRI_TX_THRSHLD NUMBER;
109 -------------------------------------------------------------------------------
110 -- Application Database Items
111 -------------------------------------------------------------------------------
112 dbi_BP_TX_RCV VARCHAR2(1);
113 dbi_PAY_PROC_PRD_DTE_PD DATE;
114 dbi_PER_AGE NUMBER;
115 dbi_PER_DTE_OF_BRTH DATE;
116 dbi_SEA_WRK_DYS_WRK NUMBER;
117 dbi_SES_DTE DATE;
118 dbi_TX_DIR_NUM VARCHAR2(60);
119 dbi_TX_DIR_VAL NUMBER DEFAULT 25;
120 dbi_TX_STA VARCHAR2(1);
121 dbi_TX_MTD VARCHAR2(1);
122 dbi_ZA_ACT_END_DTE DATE;
123 dbi_ZA_ACT_STRT_DTE DATE;
124 dbi_ZA_ASG_TX_RTR_PRD VARCHAR2(1);
125 dbi_ZA_ASG_TAX_RTR_RSLTS VARCHAR2(1);
126 dbi_ZA_ASG_TX_YR NUMBER(4);
127 dbi_ZA_ASG_TX_YR_END DATE;
128 dbi_ZA_ASG_TX_YR_STRT DATE;
129 dbi_ZA_CUR_PRD_END_DTE DATE;
130 dbi_ZA_CUR_PRD_STRT_DTE DATE;
131 dbi_ZA_DYS_IN_YR NUMBER;
132 dbi_ZA_PAY_PRDS_LFT NUMBER;
133 dbi_ZA_PAY_PRDS_PER_YR NUMBER;
134 dbi_ZA_TX_YR_END DATE;
135 dbi_ZA_TX_YR_STRT DATE;
136 dbi_ZA_LS_DIR_NUM VARCHAR2(13);
137 dbi_ZA_LS_DIR_VAL NUMBER;
138 dbi_ZA_RET_LS_DIR_NUM VARCHAR2(13);
139 dbi_ZA_RET_LS_DIR_VAL NUMBER;
140 -------------------------------------------------------------------------------
141 -- Balances
142 -------------------------------------------------------------------------------
143 bal_ANN_ARR_PF_CMTD BALANCE;
144 bal_ANN_ARR_PF_CYTD BALANCE;
145 bal_ANN_ARR_PF_RUN BALANCE;
146 bal_ANN_ARR_PF_PTD BALANCE;
147 bal_ANN_ARR_PF_YTD BALANCE;
148 bal_ANN_ARR_RA_CMTD BALANCE;
149 bal_ANN_ARR_RA_CYTD BALANCE;
150 bal_ANN_ARR_RA_RUN BALANCE;
151 bal_ANN_ARR_RA_PTD BALANCE;
152 bal_ANN_ARR_RA_YTD BALANCE;
153 bal_ANN_EE_INC_PRO_POL_CMTD BALANCE;
154 bal_ANN_EE_INC_PRO_POL_CYTD BALANCE;
155 bal_ANN_EE_INC_PRO_POL_RUN BALANCE;
156 bal_ANN_EE_INC_PRO_POL_PTD BALANCE;
157 bal_ANN_EE_INC_PRO_POL_YTD BALANCE;
158 bal_ANN_MED_CNTRB_ABM_CMTD BALANCE;
159 bal_ANN_MED_CNTRB_ABM_CYTD BALANCE;
160 bal_ANN_MED_CNTRB_ABM_RUN BALANCE;
161 bal_ANN_MED_CNTRB_ABM_PTD BALANCE;
162 bal_ANN_MED_CNTRB_ABM_YTD BALANCE;
163 bal_ANN_PF_CMTD BALANCE;
164 bal_ANN_PF_CYTD BALANCE;
165 bal_ANN_PF_RUN BALANCE;
166 bal_ANN_PF_PTD BALANCE;
167 bal_ANN_PF_YTD BALANCE;
168 bal_ANN_RA_CMTD BALANCE;
169 bal_ANN_RA_CYTD BALANCE;
170 bal_ANN_RA_RUN BALANCE;
171 bal_ANN_RA_PTD BALANCE;
172 bal_ANN_RA_YTD BALANCE;
173 /* TYS2010 */
174 bal_ANN_DONAT_MD_EE_CMTD BALANCE;
175 bal_ANN_DONAT_MD_EE_CYTD BALANCE;
176 bal_ANN_DONAT_MD_EE_RUN BALANCE;
177 bal_ANN_DONAT_MD_EE_PTD BALANCE;
178 bal_ANN_DONAT_MD_EE_YTD BALANCE;
179 /* End TYS2010 */
180 bal_ARR_PF_CMTD BALANCE;
181 bal_ARR_PF_CYTD BALANCE;
182 bal_ARR_PF_PTD BALANCE;
183 bal_ARR_PF_YTD BALANCE;
184 bal_ARR_RA_CMTD BALANCE;
185 bal_ARR_RA_CYTD BALANCE;
186 bal_ARR_RA_PTD BALANCE;
187 bal_ARR_RA_YTD BALANCE;
188 bal_BP_CMTD BALANCE;
189 bal_BP_RUN BALANCE; -- Bug 13777759
190 bal_BP_PTD BALANCE;
191 bal_BP_YTD BALANCE;
192 bal_CUR_PF_CMTD BALANCE;
193 bal_CUR_PF_CYTD BALANCE;
194 bal_CUR_PF_RUN BALANCE;
195 bal_CUR_PF_PTD BALANCE;
196 bal_CUR_PF_YTD BALANCE;
197 bal_CUR_RA_CMTD BALANCE;
198 bal_CUR_RA_CYTD BALANCE;
199 bal_CUR_RA_RUN BALANCE;
200 bal_CUR_RA_PTD BALANCE;
201 bal_CUR_RA_YTD BALANCE;
202 bal_DIR_DMD_RMN_ITD BALANCE;
206 bal_DONAT_MD_EE_RUN BALANCE;
203 /* TYS2010 */
204 bal_DONAT_MD_EE_CMTD BALANCE;
205 bal_DONAT_MD_EE_CYTD BALANCE;
207 bal_DONAT_MD_EE_PTD BALANCE;
208 bal_DONAT_MD_EE_YTD BALANCE;
209 /* End TYS2010 */
210 bal_EE_INC_PRO_POL_CMTD BALANCE;
211 bal_EE_INC_PRO_POL_CYTD BALANCE;
212 bal_EE_INC_PRO_POL_RUN BALANCE;
213 bal_EE_INC_PRO_POL_PTD BALANCE;
214 bal_EE_INC_PRO_POL_YTD BALANCE;
215 bal_EXC_ARR_PEN_ITD BALANCE;
216 bal_EXC_ARR_PEN_PTD BALANCE;
217 bal_EXC_ARR_PEN_YTD BALANCE;
218 bal_EXC_ARR_RA_ITD BALANCE;
219 bal_EXC_ARR_RA_PTD BALANCE;
220 bal_EXC_ARR_RA_YTD BALANCE;
221 bal_MED_CONTR_CMTD BALANCE;
222 bal_MED_CONTR_CYTD BALANCE;
223 bal_MED_CONTR_RUN BALANCE;
224 bal_MED_CONTR_PTD BALANCE;
225 bal_MED_CONTR_YTD BALANCE;
226 bal_MED_CNTRB_ABM_CMTD BALANCE;
227 bal_MED_CNTRB_ABM_CYTD BALANCE;
228 bal_MED_CNTRB_ABM_RUN BALANCE;
229 bal_MED_CNTRB_ABM_PTD BALANCE;
230 bal_MED_CNTRB_ABM_YTD BALANCE;
231 bal_NET_PAY_RUN BALANCE;
232 bal_NET_TXB_INC_CMTD BALANCE;
233 bal_PAYE_YTD BALANCE;
234 bal_SITE_YTD BALANCE;
235 bal_TAX_YTD BALANCE;
236 bal_TX_ON_AB_PTD BALANCE;
237 bal_TX_ON_AB_YTD BALANCE;
238 bal_TX_ON_AP_PTD BALANCE;
239 bal_TX_ON_AP_YTD BALANCE;
240 bal_TX_ON_BP_PTD BALANCE;
241 bal_TX_ON_BP_YTD BALANCE;
242 bal_TX_ON_TA_PTD BALANCE;
243 bal_TX_ON_TA_YTD BALANCE;
244 bal_TX_ON_DR_PTD BALANCE;
245 bal_TX_ON_DR_YTD BALANCE;
246 bal_TX_ON_FB_PTD BALANCE;
247 bal_TX_ON_FB_YTD BALANCE;
248 bal_TX_ON_NI_PTD BALANCE;
249 bal_TX_ON_NI_YTD BALANCE;
250 bal_TX_ON_PO_PTD BALANCE;
251 bal_TX_ON_PO_YTD BALANCE;
252 bal_TX_ON_LS_PTD BALANCE;
253 bal_TX_ON_RET_LS_PTD BALANCE;
254
255 bal_TX_ON_LS_RUN BALANCE;
256 bal_TX_ON_LS_YTD BALANCE;
257
258 bal_TOT_INC_PTD BALANCE;
259 bal_TOT_INC_YTD BALANCE;
260 bal_TOT_NRFI_AN_INC_CMTD BALANCE;
261 bal_TOT_NRFI_AN_INC_CYTD BALANCE;
262 bal_TOT_NRFI_AN_INC_RUN BALANCE;
263 bal_TOT_NRFI_AN_INC_PTD BALANCE;
264 bal_TOT_NRFI_AN_INC_YTD BALANCE;
265 bal_TOT_NRFI_INC_CMTD BALANCE;
266 bal_TOT_NRFI_INC_CYTD BALANCE;
267 bal_TOT_NRFI_INC_RUN BALANCE;
268 bal_TOT_NRFI_INC_PTD BALANCE;
269 bal_TOT_NRFI_INC_YTD BALANCE;
270 bal_TOT_RFI_AN_INC_CMTD BALANCE;
271 bal_TOT_RFI_AN_INC_CYTD BALANCE;
272 bal_TOT_RFI_AN_INC_RUN BALANCE;
273 bal_TOT_RFI_AN_INC_PTD BALANCE;
274 bal_TOT_RFI_AN_INC_YTD BALANCE;
275 bal_TOT_RFI_INC_CMTD BALANCE;
276 bal_TOT_RFI_INC_CYTD BALANCE;
277 bal_TOT_RFI_INC_RUN BALANCE;
278 bal_TOT_RFI_INC_PTD BALANCE;
279 bal_TOT_RFI_INC_YTD BALANCE;
280 bal_TOT_SEA_WRK_DYS_WRK_YTD BALANCE;
281 bal_TOT_SKL_ANN_INC_CMTD BALANCE;
282 bal_TOT_SKL_INC_CMTD BALANCE;
283 bal_TOT_TXB_INC_ITD BALANCE;
284 bal_TOT_TXB_AB_CMTD BALANCE;
285 bal_TOT_TXB_AB_RUN BALANCE;
286 bal_TOT_TXB_AB_PTD BALANCE;
287 bal_TOT_TXB_AB_YTD BALANCE;
288 bal_TOT_TXB_AP_CMTD BALANCE;
289 bal_TOT_TXB_AP_RUN BALANCE;
290 bal_TOT_TXB_AP_PTD BALANCE;
291 bal_TOT_TXB_AP_YTD BALANCE;
292 bal_TOT_TXB_FB_CMTD BALANCE;
293 bal_TOT_TXB_FB_CYTD BALANCE;
294 bal_TOT_TXB_FB_RUN BALANCE;
295 bal_TOT_TXB_FB_PTD BALANCE;
296 bal_TOT_TXB_FB_YTD BALANCE;
297 bal_TOT_TXB_NI_CMTD BALANCE;
298 bal_TOT_TXB_NI_CYTD BALANCE;
299 bal_TOT_TXB_NI_RUN BALANCE;
300 bal_TOT_TXB_NI_PTD BALANCE;
301 bal_TOT_TXB_NI_YTD BALANCE;
302 bal_TOT_TXB_PO_CMTD BALANCE;
303 bal_TOT_TXB_PO_RUN BALANCE; -- Bug 13777759
304 bal_TOT_TXB_PO_PTD BALANCE;
305 bal_TOT_TXB_PO_YTD BALANCE;
306 bal_TOT_TXB_TA_CMTD BALANCE;
307 bal_TOT_TXB_TA_CYTD BALANCE;
308 bal_TOT_TXB_TA_RUN BALANCE; -- Bug 13777759
309 bal_TOT_TXB_TA_PTD BALANCE;
310 bal_TOT_TXB_TA_YTD BALANCE;
311 -- EMP201
312 bal_GROSS_REMUNERATION_CMTD BALANCE;
313 bal_ANN_PAYMENTS_CMTD BALANCE;
314 bal_NET_PAYE_TXB_INC_CMTD BALANCE;
315
316 bal_MED_AID_TAX_CR_CMTD BALANCE;
317 bal_MED_AID_TAX_CR_CYTD BALANCE;
318 bal_MED_AID_TAX_CR_RUN BALANCE;
319 bal_MED_AID_TAX_CR_PTD BALANCE;
320 bal_MED_AID_TAX_CR_YTD BALANCE;
321 bal_ANN_MED_AID_TAX_CR_CMTD BALANCE;
322 bal_ANN_MED_AID_TAX_CR_CYTD BALANCE;
323 bal_ANN_MED_AID_TAX_CR_RUN BALANCE;
324 bal_ANN_MED_AID_TAX_CR_PTD BALANCE;
325 bal_ANN_MED_AID_TAX_CR_YTD BALANCE;
326 bal_MED_AID_TAX_CR_USED_CMTD BALANCE;
327 bal_MED_AID_TAX_CR_USED_CYTD BALANCE;
328 bal_MED_AID_TAX_CR_USED_RUN BALANCE;
329 bal_MED_AID_TAX_CR_USED_PTD BALANCE;
330 bal_MED_AID_TAX_CR_USED_YTD BALANCE;
334 /*NTG */
331 bal_MED_AID_TAX_CR_USED_LS_PTD BALANCE;
332 bal_MED_AID_TAX_CR_USED_LS_YTD BALANCE;
333
335 bal_TX_ON_AP_NTG_YTD BALANCE;
336 bal_TX_ON_AP_NTG_PTD BALANCE;
337 bal_TX_ON_EE_DBT_NTG_YTD BALANCE;
338 bal_TX_ON_EE_DBT_NTG_PTD BALANCE;
339 bal_TOT_TXB_AP_NTG_CMTD BALANCE;
340 bal_TOT_TXB_AP_NTG_RUN BALANCE;
341 bal_TOT_TXB_AP_NTG_PTD BALANCE;
342 bal_TOT_TXB_AP_NTG_YTD BALANCE;
343 bal_TOT_TXB_EE_DBT_NTG_CMTD BALANCE;
344 bal_TOT_TXB_EE_DBT_NTG_RUN BALANCE;
345 bal_TOT_TXB_EE_DBT_NTG_PTD BALANCE;
346 bal_TOT_TXB_EE_DBT_NTG_YTD BALANCE;
347 bal_TOT_RFI_EE_DBT_NTG_CMTD BALANCE;
348 bal_TOT_RFI_EE_DBT_NTG_CYTD BALANCE;
349 bal_TOT_RFI_EE_DBT_NTG_RUN BALANCE;
350 bal_TOT_RFI_EE_DBT_NTG_PTD BALANCE;
351 bal_TOT_RFI_EE_DBT_NTG_YTD BALANCE;
352 bal_TOT_NRFI_EE_DBT_NTG_CMTD BALANCE;
353 bal_TOT_NRFI_EE_DBT_NTG_CYTD BALANCE;
354 bal_TOT_NRFI_EE_DBT_NTG_RUN BALANCE;
355 bal_TOT_NRFI_EE_DBT_NTG_PTD BALANCE;
356 bal_TOT_NRFI_EE_DBT_NTG_YTD BALANCE;
357 bal_TOT_SKL_ANN_INC_NTG_CMTD BALANCE;
358
359 -- Medical Aid Employer Contribution Changes
360 bal_ER_MED_CONTR_CMTD BALANCE;
361 bal_ER_MED_CONTR_CYTD BALANCE;
362 bal_ER_MED_CONTR_RUN BALANCE;
363 bal_ER_MED_CONTR_PTD BALANCE;
364 bal_ER_MED_CONTR_YTD BALANCE;
365
366 -- Bug 14168167
367 bal_MED_EMP_NRFI_ASG_RUN BALANCE;
368 bal_MED_EMP_NRFI_ASG_TAX_PTD BALANCE;
369 bal_MED_EMP_NRFI_ASG_TAX_YTD BALANCE;
370 bal_MED_EMP_PKG_ASG_RUN BALANCE;
371 bal_MED_EMP_PKG_ASG_TAX_PTD BALANCE;
372 bal_MED_EMP_PKG_ASG_TAX_YTD BALANCE;
373 bal_MED_EMP_RFI_ASG_RUN BALANCE;
374 bal_MED_EMP_RFI_ASG_TAX_PTD BALANCE;
375 bal_MED_EMP_RFI_ASG_TAX_YTD BALANCE;
376 -- Bug 14168167
377
378
379 -------------------------------------------------------------------------------
380 -- Trace Globals
381 -------------------------------------------------------------------------------
382
383 -- These are set within the procedures and function calls!!
384 -- Values can be output by the main function call from formula
385 --
386 -- Calculation Type
387 trc_CalTyp VARCHAR2(7) DEFAULT 'Unknown';
388 -- Added for Bug 9369895
389 trc_PenBasis NUMBER DEFAULT 0;
390
391 -- trc_TxbInc BALANCE DEFAULT 0;
392 -- Factors
393 trc_TxbIncPtd BALANCE DEFAULT 0;
394 trc_PrdFactor NUMBER DEFAULT 0;
395 trc_PosFactor NUMBER DEFAULT 0;
396 trc_SitFactor NUMBER DEFAULT 1;
397 -- Deemed Remuneration
398 trc_DmdRmnRun BALANCE DEFAULT 0;
399 trc_TxbDmdRmn BALANCE DEFAULT 0;
400 trc_TotLibDR BALANCE DEFAULT 0;
401 trc_LibFyDR BALANCE DEFAULT 0;
402 trc_LibFpDR BALANCE DEFAULT 0;
403 -- Base Income
404 trc_BseErn BALANCE DEFAULT 0;
405 trc_TxbBseInc BALANCE DEFAULT 0;
406 --TYS2010
407 trc_TxbBseIncWoDon BALANCE DEFAULT 0;
408 trc_TotLibBse BALANCE DEFAULT 0;
409 -- Period Pension Fund
410 trc_TxbIncYtd BALANCE DEFAULT 0;
411 trc_PerTxbInc BALANCE DEFAULT 0;
412 trc_PerPenFnd BALANCE DEFAULT 0;
413 trc_PerRfiCon BALANCE DEFAULT 0;
414 trc_PerRfiTxb BALANCE DEFAULT 0;
415 trc_PerPenFndMax BALANCE DEFAULT 0;
416 trc_PerPenFndAbm BALANCE DEFAULT 0;
417 -- Annual Pension Fund
418 trc_AnnTxbInc BALANCE DEFAULT 0;
419 trc_AnnPenFnd BALANCE DEFAULT 0;
420 trc_AnnRfiCon BALANCE DEFAULT 0;
421 trc_AnnRfiTxb BALANCE DEFAULT 0;
422 trc_AnnPenFndMax BALANCE DEFAULT 0;
423 trc_AnnPenFndAbm BALANCE DEFAULT 0;
424 -- Period Arrear Pension
425 trc_PerArrPenFnd BALANCE DEFAULT 0;
426 trc_PerArrPenFndAbm BALANCE DEFAULT 0;
427 -- Annual Arrear Pension
428 trc_AnnArrPenFnd BALANCE DEFAULT 0;
429 trc_AnnArrPenFndAbm BALANCE DEFAULT 0;
430 -- Arrear Excess Update Value
431 trc_PfUpdFig BALANCE DEFAULT 0;
432 -- Period Retirement Annuity
433 trc_PerRetAnu BALANCE DEFAULT 0;
434 trc_PerNrfiCon BALANCE DEFAULT 0;
435 trc_PerRetAnuMax BALANCE DEFAULT 0;
436 trc_PerRetAnuAbm BALANCE DEFAULT 0;
437 -- Annual Retirement Annuity
438 trc_AnnRetAnu BALANCE DEFAULT 0;
439 trc_AnnNrfiCon BALANCE DEFAULT 0;
440 trc_AnnRetAnuMax BALANCE DEFAULT 0;
441 trc_AnnRetAnuAbm BALANCE DEFAULT 0;
442 -- Period Arrear Retirement Annuity
443 trc_PerArrRetAnu BALANCE DEFAULT 0;
444 trc_PerArrRetAnuAbm BALANCE DEFAULT 0;
445 -- Annual Arrear Retirement Annuity
446 trc_AnnArrRetAnu BALANCE DEFAULT 0;
447 trc_AnnArrRetAnuAbm BALANCE DEFAULT 0;
448 -- Arrear Excess Update Value
449 trc_RaUpdFig BALANCE DEFAULT 0;
450 -- Medical Aid Abatement
451 trc_PerMedAidAbm BALANCE DEFAULT 0;
452 trc_AnnMedAidAbm BALANCE DEFAULT 0;
453 -- Rebates Thresholds
454 trc_Rebate BALANCE DEFAULT 0;
455 trc_Threshold BALANCE DEFAULT 0;
456 -- TYS2010
457 -- Donation
458 trc_AllowDonPerc BALANCE DEFAULT 0;
459 -- Income Protection Policy
460 trc_PerIncProPolAbm BALANCE DEFAULT 0;
461 trc_AnnIncProPolAbm BALANCE DEFAULT 0;
462 -- Abatement Totals
463 trc_PerTotAbm BALANCE DEFAULT 0;
464 trc_AnnTotAbm BALANCE DEFAULT 0;
468
465 -- Employee Donation --TYS2010
466 trc_PerDonAmt BALANCE DEFAULT 0;
467 trc_AnnDonAmt BALANCE DEFAULT 0;
469 -- Normal Income
470 trc_NorIncYtd BALANCE DEFAULT 0;
471 trc_NorIncPtd BALANCE DEFAULT 0;
472 trc_NorErn BALANCE DEFAULT 0;
473 trc_TxbNorInc BALANCE DEFAULT 0;
474 --TYS2010
475 trc_TxbNorIncWoDon BALANCE DEFAULT 0;
476 trc_TotLibNI BALANCE DEFAULT 0;
477 trc_LibFyNI BALANCE DEFAULT 0;
478 trc_LibFpNI BALANCE DEFAULT 0;
479 -- Fringe Benefits
480 trc_FrnBenYtd BALANCE DEFAULT 0;
481 trc_FrnBenPtd BALANCE DEFAULT 0;
482 trc_FrnBenErn BALANCE DEFAULT 0;
483 trc_TxbFrnInc BALANCE DEFAULT 0;
484 --TYS2010
485 trc_TxbFrnIncWoDon BALANCE DEFAULT 0;
486 trc_TotLibFB BALANCE DEFAULT 0;
487 trc_LibFyFB BALANCE DEFAULT 0;
488 trc_LibFpFB BALANCE DEFAULT 0;
489 -- Travel Allowance
490 trc_TrvAllYtd BALANCE DEFAULT 0;
491 trc_TrvAllPtd BALANCE DEFAULT 0;
492 trc_TrvAllErn BALANCE DEFAULT 0;
493 trc_TxbTrvInc BALANCE DEFAULT 0;
494 --TYS2010
495 trc_TxbTrvIncWoDon BALANCE DEFAULT 0;
496 trc_TotLibTA BALANCE DEFAULT 0;
497 trc_LibFyTA BALANCE DEFAULT 0;
498 trc_LibFpTA BALANCE DEFAULT 0;
499 -- Bonus Provision
500 trc_BonProYtd BALANCE DEFAULT 0;
501 trc_BonProPtd BALANCE DEFAULT 0;
502 trc_BonProErn BALANCE DEFAULT 0;
503 trc_TxbBonProInc BALANCE DEFAULT 0;
504 --TYS2010
505 trc_TxbBonProIncWoDon BALANCE DEFAULT 0;
506 trc_TotLibBP BALANCE DEFAULT 0;
507 trc_LibFyBP BALANCE DEFAULT 0;
508 trc_LibFpBP BALANCE DEFAULT 0;
509 -- Annual Bonus
510 trc_AnnBonYtd BALANCE DEFAULT 0;
511 trc_AnnBonPtd BALANCE DEFAULT 0;
512 trc_AnnBonErn BALANCE DEFAULT 0;
513 trc_TxbAnnBonInc BALANCE DEFAULT 0;
514 --TYS2010
515 trc_TxbAnnBonIncWoDon BALANCE DEFAULT 0;
516 trc_TotLibAB BALANCE DEFAULT 0;
517 trc_LibFyAB BALANCE DEFAULT 0;
518 trc_LibFpAB BALANCE DEFAULT 0;
519 -- Annual Payments
520 trc_AnnPymYtd BALANCE DEFAULT 0;
521 trc_AnnPymPtd BALANCE DEFAULT 0;
522 trc_AnnPymErn BALANCE DEFAULT 0;
523 trc_TxbAnnPymInc BALANCE DEFAULT 0;
524 --TYS2010
525 trc_TxbAnnPymIncWoDon BALANCE DEFAULT 0;
526 trc_TotLibAP BALANCE DEFAULT 0;
527 trc_LibFyAP BALANCE DEFAULT 0;
528 trc_LibFpAP BALANCE DEFAULT 0;
529 -- NTG Annual Payments
530 trc_AnnPymNtgYtd BALANCE DEFAULT 0;
531 trc_AnnPymNtgPtd BALANCE DEFAULT 0;
532 trc_AnnPymNtgErn BALANCE DEFAULT 0;
533 trc_TxbAnnPymNtgInc BALANCE DEFAULT 0;
534 trc_TxbAnnPymNtgIncWoDon BALANCE DEFAULT 0;
535 trc_TotLibNtgAP BALANCE DEFAULT 0;
536 trc_LibFyNtgAP BALANCE DEFAULT 0;
537 trc_LibFpNtgAP BALANCE DEFAULT 0;
538 -- NTG Fringe Benifits
539 trc_AnnEEDbtNtgYtd BALANCE DEFAULT 0;
540 trc_AnnEEDbtNtgPtd BALANCE DEFAULT 0;
541 trc_AnnEEDbtNtgErn BALANCE DEFAULT 0;
542 trc_TxbAnnEEDbtNtgInc BALANCE DEFAULT 0;
543 trc_TxbAnnEEDbtNtgIncWoDon BALANCE DEFAULT 0;
544 trc_TotLibNtgEEDbt BALANCE DEFAULT 0;
545 trc_LibFyNtgEEDbt BALANCE DEFAULT 0;
546 trc_LibFpNtgEEDbt BALANCE DEFAULT 0;
547 trc_AnnRfiEEDbtNTGCon BALANCE DEFAULT 0;
548 trc_AnnNrfiEEDbtNTGCon BALANCE DEFAULT 0;
549 trc_AnnPenFndNTGMax BALANCE DEFAULT 0;
550 trc_AnnPenFndNTGAbm BALANCE DEFAULT 0;
551 trc_AnnRetAnuNTGMax BALANCE DEFAULT 0;
552 trc_AnnRetAnuNTGAbm BALANCE DEFAULT 0;
553 trc_AnnTotNTGAbm BALANCE DEFAULT 0;
554 --End NTG Annual Payments
555
556 -- Pubilc Office Allowance
557 trc_PblOffYtd BALANCE DEFAULT 0;
558 trc_PblOffPtd BALANCE DEFAULT 0;
559 trc_PblOffErn BALANCE DEFAULT 0;
560 trc_TxbPblOffInc BALANCE DEFAULT 0;
561 --TYS2010
562 trc_TxbPblOffIncWoDon BALANCE DEFAULT 0;
563 trc_TotLibPO BALANCE DEFAULT 0;
564 trc_LibFyPO BALANCE DEFAULT 0;
565 trc_LibFpPO BALANCE DEFAULT 0;
566
567 --EMP201
568 trc_NPtiUpdFig BALANCE default 0 ;
569
570 -- Messages
571 trc_LibWrn VARCHAR2(100) DEFAULT ' ';
572
573 -- Statutory Deduction Value
574 trc_PayValSD BALANCE DEFAULT 0;
575 -- Employer Contribution Value
576 trc_PayValEC BALANCE DEFAULT 0;
577 -- PAYE and SITE Values
578 trc_PayeVal BALANCE DEFAULT 0;
579 trc_SiteVal BALANCE DEFAULT 0;
580 -- IT3A Threshold Indicator
581 trc_It3Ind NUMBER DEFAULT 0;
582 -- Tax Percentage Value On trace
583 trc_TxPercVal NUMBER DEFAULT 0;
584 -- Total Taxable Income Update Figure
585 trc_OUpdFig BALANCE DEFAULT 0;
586 -- Net Taxable Income Update Figure
587 trc_NtiUpdFig BALANCE DEFAULT 0;
588
589 -- ValidateTaxOns Override Globals
590 trc_LibFpDROvr BOOLEAN DEFAULT FALSE;
591 trc_LibFpNIOvr BOOLEAN DEFAULT FALSE;
592 trc_LibFpFBOvr BOOLEAN DEFAULT FALSE;
593 trc_LibFpTAOvr BOOLEAN DEFAULT FALSE;
594 trc_LibFpBPOvr BOOLEAN DEFAULT FALSE;
595 trc_LibFpABOvr BOOLEAN DEFAULT FALSE;
599 trc_LibFpNtgAPOvr BOOLEAN DEFAULT FALSE;
596 trc_LibFpAPOvr BOOLEAN DEFAULT FALSE;
597 trc_LibFpPOOvr BOOLEAN DEFAULT FALSE;
598 -- NTG
600 trc_LibFpNtgEEDbtOvr BOOLEAN DEFAULT FALSE;
601 -- End NTG
602
603 -- Global Exception Message
604 xpt_Msg VARCHAR2(100) DEFAULT 'No Error';
605 -- Global Exception
606 xpt_E EXCEPTION;
607
608 -- Override Globals
609 trc_OvrTxCalc BOOLEAN DEFAULT FALSE;
610 trc_OvrTyp VARCHAR2(1) DEFAULT 'V';
611 trc_OvrPrc NUMBER(3) DEFAULT 0;
612 trc_OvrWrn VARCHAR2(150) DEFAULT ' ';
613 -- Bug 8844712 This indicates whether its LteCalc and is calculating SitePaye split
614 trc_LateSitePaye NUMBER(3) DEFAULT 0;
615
616 -- Negative Ptd Global
617 trc_NegPtd BOOLEAN DEFAULT FALSE;
618
619 -- Medical Tax Credit Globals
620 trc_curMedTxCrEle BALANCE DEFAULT 0;
621 trc_MedCrUsed BALANCE DEFAULT 0;
622
623 -- Bug 14376752
624 -- tables created for SDL Enh
625
626 type LSDirMTDRec is record
627 (
628 inc_typ VARCHAR2(10)
629 ,dir_value NUMBER
630 );
631
632
633 type LSDirMTDTab IS TABLE OF LSDirMTDRec INDEX BY VARCHAR2(100);
634
635 trc_LSDirMTDTab LSDirMTDTab;
636
637 -- Bug 14376752
638
639 -- Function to Override Tax Calculation
640 --
641 FUNCTION ZaTxOvr_01032013(
642 p_OvrTyp IN VARCHAR2
643 ,p_TxOnNI IN NUMBER
644 ,p_TxOnAP IN NUMBER
645 ,p_TxPrc IN NUMBER
646 )RETURN NUMBER;
647
648
649 -- Function to Initialise Globals
650 --
651 FUNCTION ZaTxGlb_01032013(
652 -- Global Values
653 p_ZA_ADL_TX_RBT IN NUMBER
654 ,p_ZA_ARR_PF_AN_MX_ABT IN NUMBER
655 ,p_ZA_ARR_RA_AN_MX_ABT IN NUMBER
656 ,p_ZA_TRV_ALL_TX_PRC IN NUMBER
657 ,p_ZA_CC_TX_PRC IN NUMBER
658 ,p_ZA_PF_AN_MX_ABT IN NUMBER
659 ,p_ZA_PF_MX_PRC IN NUMBER
660 ,p_ZA_PER_SERV_COMP_PERC IN NUMBER
661 ,p_ZA_PER_SERV_TRST_PERC IN NUMBER
662 ,p_ZA_PRI_TX_RBT IN NUMBER
663 ,p_ZA_PRI_TX_THRSHLD IN NUMBER
664 ,p_ZA_PBL_TX_PRC IN NUMBER
665 ,p_ZA_PBL_TX_RTE IN NUMBER
666 ,p_ZA_RA_AN_MX_ABT IN NUMBER
667 ,p_ZA_RA_MX_PRC IN NUMBER
668 ,p_ZA_SC_TX_THRSHLD IN NUMBER
669 ,p_ZA_SIT_LIM IN NUMBER
670 ,p_ZA_TMP_TX_RTE IN NUMBER
671 ,p_ZA_WRK_DYS_PR_YR IN NUMBER
672 ,p_ZA_ALLOW_DONATION_PERC IN NUMBER /*TYS2010*/
673 --Bug 8844712
674 ,p_ZA_LATE_PAYMENT_PERC IN NUMBER
675 ,p_ZA_TRI_TX_RBT IN NUMBER
676 ,p_ZA_TRI_TX_THRSHLD IN NUMBER
677 ) RETURN NUMBER;
678
679 -- Function to Initialise Globals - Database Item Values
680 --
681 FUNCTION ZaTxDbi_01032013(
682 -- Database Items
683 p_PAY_PROC_PRD_DTE_PD IN DATE
684 ,p_PER_AGE IN NUMBER
685 ,p_PER_DTE_OF_BRTH IN DATE
686 ,p_SES_DTE IN DATE
687 ,p_ZA_ACT_END_DTE IN DATE
688 ,p_ZA_ACT_STRT_DTE IN DATE
689 ,p_ZA_ASG_TX_RTR_PRD IN VARCHAR2
690 ,p_ZA_ASG_TAX_RTR_RSLTS IN VARCHAR2
691 /* ,p_ZA_ASG_TX_YR IN NUMBER
692 ,p_ZA_ASG_TX_YR_END IN DATE
693 ,p_ZA_ASG_TX_YR_STRT IN DATE */
694 ,p_ZA_CUR_PRD_END_DTE IN DATE
695 ,p_ZA_CUR_PRD_STRT_DTE IN DATE
696 ,p_ZA_DYS_IN_YR IN NUMBER
697 ,p_ZA_PAY_PRDS_LFT IN NUMBER
698 ,p_ZA_PAY_PRDS_PER_YR IN NUMBER
699 ,p_ZA_TX_YR_END IN DATE
700 ,p_ZA_TX_YR_STRT IN DATE
701 ,p_BP_TX_RCV IN VARCHAR2
702 ,p_SEA_WRK_DYS_WRK IN NUMBER
703 ,p_TX_DIR_NUM IN VARCHAR2
704 ,p_TX_DIR_VAL IN NUMBER
705 ,p_TX_STA IN VARCHAR2
706 ,p_ZA_LS_DIR_NUM IN VARCHAR2
707 ,p_ZA_LS_DIR_VAL IN NUMBER
708 ,p_ZA_RET_LS_DIR_NUM IN VARCHAR2
709 ,p_ZA_RET_LS_DIR_VAL IN NUMBER
710 ,p_TAX_METHOD IN VARCHAR2
711 ) RETURN NUMBER;
712
713
714 -- Function to Initialise Globals - Balance Values
715 -- First Section
716 FUNCTION ZaTxBal1_01032013(
717 -- Balances
718 p_ANN_ARR_PF_CMTD IN NUMBER
719 ,p_ANN_ARR_PF_CYTD IN NUMBER
720 ,p_ANN_ARR_PF_RUN IN NUMBER
721 ,p_ANN_ARR_PF_PTD IN NUMBER
722 ,p_ANN_ARR_PF_YTD IN NUMBER
723 ,p_ANN_ARR_RA_CMTD IN NUMBER
724 ,p_ANN_ARR_RA_CYTD IN NUMBER
725 ,p_ANN_ARR_RA_RUN IN NUMBER
726 ,p_ANN_ARR_RA_PTD IN NUMBER
727 ,p_ANN_ARR_RA_YTD IN NUMBER
728 ,p_ANN_EE_INC_PRO_POL_CMTD IN NUMBER
729 ,p_ANN_EE_INC_PRO_POL_CYTD IN NUMBER
730 ,p_ANN_EE_INC_PRO_POL_RUN IN NUMBER
731 ,p_ANN_EE_INC_PRO_POL_PTD IN NUMBER
732 ,p_ANN_EE_INC_PRO_POL_YTD IN NUMBER
733 ,p_ANN_MED_CNTRB_ABM_CMTD IN NUMBER
734 ,p_ANN_MED_CNTRB_ABM_CYTD IN NUMBER
735 ,p_ANN_MED_CNTRB_ABM_RUN IN NUMBER
736 ,p_ANN_MED_CNTRB_ABM_PTD IN NUMBER
737 ,p_ANN_MED_CNTRB_ABM_YTD IN NUMBER
738 ,p_ANN_PF_CMTD IN NUMBER
739 ,p_ANN_PF_CYTD IN NUMBER
740 ,p_ANN_PF_RUN IN NUMBER
741 ,p_ANN_PF_PTD IN NUMBER
742 ,p_ANN_PF_YTD IN NUMBER
743 ,p_ANN_RA_CMTD IN NUMBER
744 ,p_ANN_RA_CYTD IN NUMBER
745 ,p_ANN_RA_RUN IN NUMBER
746 ,p_ANN_RA_PTD IN NUMBER
747 ,p_ANN_RA_YTD IN NUMBER
748 /*TYS2010*/
752 ,p_ANN_DONAT_MD_EE_PTD IN NUMBER
749 ,p_ANN_DONAT_MD_EE_CMTD IN NUMBER
750 ,p_ANN_DONAT_MD_EE_CYTD IN NUMBER
751 ,p_ANN_DONAT_MD_EE_RUN IN NUMBER
753 ,p_ANN_DONAT_MD_EE_YTD IN NUMBER
754 ) RETURN NUMBER;
755
756 -- Function to Initialise Globals - Balance Values
757 -- Second Section
758 FUNCTION ZaTxBal2_01032013(
759 -- Balances
760 p_ARR_PF_CMTD IN NUMBER
761 ,p_ARR_PF_CYTD IN NUMBER
762 ,p_ARR_PF_PTD IN NUMBER
763 ,p_ARR_PF_YTD IN NUMBER
764 ,p_ARR_RA_CMTD IN NUMBER
765 ,p_ARR_RA_CYTD IN NUMBER
766 ,p_ARR_RA_PTD IN NUMBER
767 ,p_ARR_RA_YTD IN NUMBER
768 ,p_BP_CMTD IN NUMBER
769 ,p_BP_RUN IN NUMBER -- Bug 13777759
770 ,p_BP_PTD IN NUMBER
771 ,p_BP_YTD IN NUMBER
772 ,p_CUR_PF_CMTD IN NUMBER
773 ,p_CUR_PF_CYTD IN NUMBER
774 ,p_CUR_PF_RUN IN NUMBER
775 ,p_CUR_PF_PTD IN NUMBER
776 ,p_CUR_PF_YTD IN NUMBER
777 ,p_CUR_RA_CMTD IN NUMBER
778 ,p_CUR_RA_CYTD IN NUMBER
779 ,p_CUR_RA_RUN IN NUMBER
780 ,p_CUR_RA_PTD IN NUMBER
781 ,p_CUR_RA_YTD IN NUMBER
782 ,p_DIR_DMD_RMN_ITD IN NUMBER
783 /*TYS2010*/
784 ,p_DONAT_MD_EE_CMTD IN NUMBER
785 ,p_DONAT_MD_EE_CYTD IN NUMBER
786 ,p_DONAT_MD_EE_RUN IN NUMBER
787 ,p_DONAT_MD_EE_PTD IN NUMBER
788 ,p_DONAT_MD_EE_YTD IN NUMBER
789 -- Bug 14168167
790 ,p_MED_AID_EMP_NRFI_ASG_RUN IN NUMBER
791 ,p_MED_AID_EMP_NRFI_ASG_TAX_PTD IN NUMBER
792 ,p_MED_AID_EMP_NRFI_ASG_TAX_YTD IN NUMBER
793 ,p_MED_AID_EMP_PKG_ASG_RUN IN NUMBER
794 ,p_MED_AID_EMP_PKG_ASG_TAX_PTD IN NUMBER
795 ,p_MED_AID_EMP_PKG_ASG_TAX_YTD IN NUMBER
796 ,p_MED_AID_EMP_RFI_ASG_RUN IN NUMBER
797 ,p_MED_AID_EMP_RFI_ASG_TAX_PTD IN NUMBER
798 ,p_MED_AID_EMP_RFI_ASG_TAX_YTD IN NUMBER
799 -- Bug 14168167
800 ) RETURN NUMBER;
801
802 -- Function to Initialise Globals - Balance Values
803 -- Third Section
804 FUNCTION ZaTxBal3_01032013(
805 -- Balances
806 p_EE_INC_PRO_POL_CMTD IN NUMBER
807 ,p_EE_INC_PRO_POL_CYTD IN NUMBER
808 ,p_EE_INC_PRO_POL_RUN IN NUMBER
809 ,p_EE_INC_PRO_POL_PTD IN NUMBER
810 ,p_EE_INC_PRO_POL_YTD IN NUMBER
811 ,p_EXC_ARR_PEN_ITD IN NUMBER
812 ,p_EXC_ARR_PEN_PTD IN NUMBER
813 ,p_EXC_ARR_PEN_YTD IN NUMBER
814 ,p_EXC_ARR_RA_ITD IN NUMBER
815 ,p_EXC_ARR_RA_PTD IN NUMBER
816 ,p_EXC_ARR_RA_YTD IN NUMBER
817 ,p_MED_CONTR_CMTD IN NUMBER
818 ,p_MED_CONTR_CYTD IN NUMBER
819 ,p_MED_CONTR_RUN IN NUMBER
820 ,p_MED_CONTR_PTD IN NUMBER
821 ,p_MED_CONTR_YTD IN NUMBER
822 ,p_MED_CNTRB_ABM_CMTD IN NUMBER
823 ,p_MED_CNTRB_ABM_CYTD IN NUMBER
824 ,p_MED_CNTRB_ABM_RUN IN NUMBER
825 ,p_MED_CNTRB_ABM_PTD IN NUMBER
826 ,p_MED_CNTRB_ABM_YTD IN NUMBER
827 ,p_NET_PAY_RUN IN NUMBER
828 ,p_NET_TXB_INC_CMTD IN NUMBER
829 --EMP201
830 ,p_NET_PAYE_TXB_INC_CMTD IN NUMBER
831 ,p_MED_AID_TAX_CR_CMTD IN NUMBER
832 ,p_MED_AID_TAX_CR_CYTD IN NUMBER
833 ,p_MED_AID_TAX_CR_RUN IN NUMBER
834 ,p_MED_AID_TAX_CR_PTD IN NUMBER
835 ,p_MED_AID_TAX_CR_YTD IN NUMBER
836 ,p_ANN_MED_AID_TAX_CR_CMTD IN NUMBER
837 ,p_ANN_MED_AID_TAX_CR_CYTD IN NUMBER
838 ,p_ANN_MED_AID_TAX_CR_RUN IN NUMBER
839 ,p_ANN_MED_AID_TAX_CR_PTD IN NUMBER
840 ,p_ANN_MED_AID_TAX_CR_YTD IN NUMBER
841 ,p_MED_AID_TAX_CR_USED_CMTD IN NUMBER
842 ,p_MED_AID_TAX_CR_USED_CYTD IN NUMBER
843 ,p_MED_AID_TAX_CR_USED_RUN IN NUMBER
844 ,p_MED_AID_TAX_CR_USED_PTD IN NUMBER
845 ,p_MED_AID_TAX_CR_USED_YTD IN NUMBER
846 -- Bug 13777759
847 ,p_ER_MED_CONTR_CMTD IN NUMBER
848 ,p_ER_MED_CONTR_CYTD IN NUMBER
849 ,p_ER_MED_CONTR_RUN IN NUMBER
850 ,p_ER_MED_CONTR_PTD IN NUMBER
851 ,p_ER_MED_CONTR_YTD IN NUMBER
852 ,p_MED_AID_TAX_CR_USED_LS_PTD IN NUMBER
853 ,p_MED_AID_TAX_CR_USED_LS_YTD IN NUMBER
854 ) RETURN NUMBER;
855
856 -- Function to Initialise Globals - Balance Values
857 -- Fourth Section
858 FUNCTION ZaTxBal4_01032013(
859 -- Balances
860 p_PAYE_YTD IN NUMBER
861 ,p_SITE_YTD IN NUMBER
862 ,p_TAX_YTD IN NUMBER
863 ,p_TX_ON_AB_PTD IN NUMBER
864 ,p_TX_ON_AB_YTD IN NUMBER
865 ,p_TX_ON_AP_PTD IN NUMBER
866 ,p_TX_ON_AP_YTD IN NUMBER
867 ,p_TX_ON_BP_PTD IN NUMBER
868 ,p_TX_ON_BP_YTD IN NUMBER
869 ,p_TX_ON_TA_PTD IN NUMBER
870 ,p_TX_ON_TA_YTD IN NUMBER
871 ,p_TX_ON_DR_PTD IN NUMBER
872 ,p_TX_ON_DR_YTD IN NUMBER
873 ,p_TX_ON_FB_PTD IN NUMBER
874 ,p_TX_ON_FB_YTD IN NUMBER
875 ,p_TX_ON_NI_PTD IN NUMBER
876 ,p_TX_ON_NI_YTD IN NUMBER
877 ,p_TX_ON_PO_PTD IN NUMBER
878 ,p_TX_ON_PO_YTD IN NUMBER
879 ,p_TX_ON_LS_PTD IN NUMBER
880 ,p_TX_ON_RET_LS_PTD IN NUMBER
881 /* NTG */
882 ,p_TX_ON_AP_NTG_PTD IN NUMBER
883 ,p_TX_ON_AP_NTG_YTD IN NUMBER
887 ,p_TX_ON_LS_YTD IN NUMBER
884 ,p_TX_ON_EE_DBT_NTG_PTD IN NUMBER
885 ,p_TX_ON_EE_DBT_NTG_YTD IN NUMBER
886 ,p_TX_ON_LS_RUN IN NUMBER
888 /* End NTG */
889 ) RETURN NUMBER;
890
891 FUNCTION ZaTxBal5_01032013(
892 -- Balances
893 p_TOT_INC_PTD IN NUMBER
894 ,p_TOT_INC_YTD IN NUMBER
895 ,p_TOT_NRFI_AN_INC_CMTD IN NUMBER
896 ,p_TOT_NRFI_AN_INC_CYTD IN NUMBER
897 ,p_TOT_NRFI_AN_INC_RUN IN NUMBER
898 ,p_TOT_NRFI_AN_INC_PTD IN NUMBER
899 ,p_TOT_NRFI_AN_INC_YTD IN NUMBER
900 ,p_TOT_NRFI_INC_CMTD IN NUMBER
901 ,p_TOT_NRFI_INC_CYTD IN NUMBER
902 ,p_TOT_NRFI_INC_RUN IN NUMBER
903 ,p_TOT_NRFI_INC_PTD IN NUMBER
904 ,p_TOT_NRFI_INC_YTD IN NUMBER
905 ,p_TOT_RFI_AN_INC_CMTD IN NUMBER
906 ,p_TOT_RFI_AN_INC_CYTD IN NUMBER
907 ,p_TOT_RFI_AN_INC_RUN IN NUMBER
908 ,p_TOT_RFI_AN_INC_PTD IN NUMBER
909 ,p_TOT_RFI_AN_INC_YTD IN NUMBER
910 ,p_TOT_RFI_INC_CMTD IN NUMBER
911 ,p_TOT_RFI_INC_CYTD IN NUMBER
912 ,p_TOT_RFI_INC_RUN IN NUMBER
913 ,p_TOT_RFI_INC_PTD IN NUMBER
914 ,p_TOT_RFI_INC_YTD IN NUMBER
915 ,p_TOT_SEA_WRK_DYS_WRK_YTD IN NUMBER
916 ,p_TOT_SKL_ANN_INC_CMTD IN NUMBER
917 ,p_TOT_SKL_INC_CMTD IN NUMBER
918 ,p_TOT_TXB_INC_ITD IN NUMBER
919 --EMP201
920 ,p_GROSS_REMUNERATION_CMTD IN NUMBER
921 ,p_ANN_PAYMENTS_CMTD IN NUMBER
922 --NTG
923 ,p_TOT_RFI_EE_DBT_NTG_CMTD IN NUMBER
924 ,p_TOT_RFI_EE_DBT_NTG_CYTD IN NUMBER
925 ,p_TOT_RFI_EE_DBT_NTG_RUN IN NUMBER
926 ,p_TOT_RFI_EE_DBT_NTG_PTD IN NUMBER
927 ,p_TOT_RFI_EE_DBT_NTG_YTD IN NUMBER
928 ,p_TOT_NRFI_EE_DBT_NTG_CMTD IN NUMBER
929 ,p_TOT_NRFI_EE_DBT_NTG_CYTD IN NUMBER
930 ,p_TOT_NRFI_EE_DBT_NTG_RUN IN NUMBER
931 ,p_TOT_NRFI_EE_DBT_NTG_PTD IN NUMBER
932 ,p_TOT_NRFI_EE_DBT_NTG_YTD IN NUMBER
933 ,p_TOT_SKL_ANN_INC_NTG_CMTD IN NUMBER
934 ) RETURN NUMBER;
935
936 FUNCTION ZaTxBal6_01032013(
937 -- Balances
938 p_TOT_TXB_AB_CMTD IN NUMBER
939 ,p_TOT_TXB_AB_RUN IN NUMBER
940 ,p_TOT_TXB_AB_PTD IN NUMBER
941 ,p_TOT_TXB_AB_YTD IN NUMBER
942 ,p_TOT_TXB_AP_CMTD IN NUMBER
943 ,p_TOT_TXB_AP_RUN IN NUMBER
944 ,p_TOT_TXB_AP_PTD IN NUMBER
945 ,p_TOT_TXB_AP_YTD IN NUMBER
946 ,p_TOT_TXB_FB_CMTD IN NUMBER
947 ,p_TOT_TXB_FB_CYTD IN NUMBER
948 ,p_TOT_TXB_FB_RUN IN NUMBER
949 ,p_TOT_TXB_FB_PTD IN NUMBER
950 ,p_TOT_TXB_FB_YTD IN NUMBER
951 ,p_TOT_TXB_NI_CMTD IN NUMBER
952 ,p_TOT_TXB_NI_CYTD IN NUMBER
953 ,p_TOT_TXB_NI_RUN IN NUMBER
954 ,p_TOT_TXB_NI_PTD IN NUMBER
955 ,p_TOT_TXB_NI_YTD IN NUMBER
956 ,p_TOT_TXB_PO_CMTD IN NUMBER
957 ,p_TOT_TXB_PO_RUN IN NUMBER -- Bug 13777759
958 ,p_TOT_TXB_PO_PTD IN NUMBER
959 ,p_TOT_TXB_PO_YTD IN NUMBER
960 ,p_TOT_TXB_TA_CMTD IN NUMBER
961 ,p_TOT_TXB_TA_CYTD IN NUMBER
962 ,p_TOT_TXB_TA_RUN IN NUMBER -- Bug 13777759
963 ,p_TOT_TXB_TA_PTD IN NUMBER
964 ,p_TOT_TXB_TA_YTD IN NUMBER
965 /* NTG */
966 ,p_TOT_TXB_AP_NTG_CMTD IN NUMBER
967 ,p_TOT_TXB_AP_NTG_RUN IN NUMBER
968 ,p_TOT_TXB_AP_NTG_PTD IN NUMBER
969 ,p_TOT_TXB_AP_NTG_YTD IN NUMBER
970 ,p_TOT_TXB_EE_DBT_NTG_CMTD IN NUMBER
971 ,p_TOT_TXB_EE_DBT_NTG_RUN IN NUMBER
972 ,p_TOT_TXB_EE_DBT_NTG_PTD IN NUMBER
973 ,p_TOT_TXB_EE_DBT_NTG_YTD IN NUMBER
974 /* End NTG */
975 ) RETURN NUMBER;
976
977 -- Main Tax Function
978 -- Called from Fast Formula
979 FUNCTION ZaTx_01032013(
980 /* PARAMETERS */
981 -- Contexts
982 ASSIGNMENT_ACTION_ID IN NUMBER
983 ,ASSIGNMENT_ID IN NUMBER
984 ,PAYROLL_ACTION_ID IN NUMBER
985 ,PAYROLL_ID IN NUMBER
986 -- Out Parameters
987 , p_LibWrn OUT NOCOPY VARCHAR2
988 , p_LibFpDR OUT NOCOPY NUMBER
989 , p_LibFpNI OUT NOCOPY NUMBER
990 , p_LibFpFB OUT NOCOPY NUMBER
991 , p_LibFpTA OUT NOCOPY NUMBER
992 , p_LibFpBP OUT NOCOPY NUMBER
993 , p_LibFpAB OUT NOCOPY NUMBER
994 , p_LibFpAP OUT NOCOPY NUMBER
995 , p_LibFpPO OUT NOCOPY NUMBER
996 , p_PayValSD OUT NOCOPY NUMBER
997 , p_PayValEC OUT NOCOPY NUMBER
998 , p_PayeVal OUT NOCOPY NUMBER
999 , p_SiteVal OUT NOCOPY NUMBER
1000 , p_It3Ind OUT NOCOPY NUMBER
1001 , p_PfUpdFig OUT NOCOPY NUMBER
1002 , p_RaUpdFig OUT NOCOPY NUMBER
1003 , p_OUpdFig OUT NOCOPY NUMBER
1004 , p_NtiUpdFig OUT NOCOPY NUMBER
1005 , p_OvrWrn OUT NOCOPY VARCHAR2
1006 , p_LSDirNum OUT NOCOPY VARCHAR2
1007 , p_LSDirVal OUT NOCOPY NUMBER
1008 , p_RETLSDirNum OUT NOCOPY VARCHAR2
1009 , p_RETLSDirVal OUT NOCOPY NUMBER
1010 --EMP201
1011 , p_NPtiUpdFig OUT NOCOPY NUMBER
1012 -- NTG
1013 , p_LibFpNtgAP OUT NOCOPY NUMBER
1014 , p_LibFpNtgEEDbt OUT NOCOPY NUMBER
1015 , p_LibFpNtg OUT NOCOPY NUMBER
1016 -- End NTG
1017 , p_MedCrUsed OUT NOCOPY NUMBER
1018 , p_MedCrUsedLS OUT NOCOPY NUMBER
1019 )RETURN NUMBER;
1020
1021
1022 END py_za_tx_01032013;
[Home] [Help]