1 PACKAGE py_za_tx_01032012 AUTHID CURRENT_USER AS
2 /* $Header: pyzat013.pkh 120.14.12020000.2 2013/01/31 10:55:36 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_01032012.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_01032012
17 This function is called from Oracle Applications Fast Formula.
18 It passes all necessary global values to the main tax package.
19 ZaTxDbi_01032012
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_01032012
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_01032012
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_01032012
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_01032012
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_01032012
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 ABDASH 11/10/2012 115.15 14376752 SDL ENH
69 ABDASH 11/10/2012 115.16 14376752 SDL ENH
70 ABDASH 11/10/2012 115.17 14376752 SDL ENH
71 */
72 -------------------------------------------------------------------------------
73 -- PACKAGE GLOBAL AREA --
74 -------------------------------------------------------------------------------
75 -- Types
76 -------------------------------------------------------------------------------
77 SUBTYPE BALANCE IS py_za_tx_utl_01032012.t_balance;
78 -------------------------------------------------------------------------------
79 -- Application Contexts
80 -------------------------------------------------------------------------------
81 con_ASG_ACT_ID NUMBER;
82 con_ASG_ID NUMBER;
83 con_PRL_ACT_ID NUMBER;
84 con_PRL_ID NUMBER;
85 -------------------------------------------------------------------------------
86 -- Application Global Values
87 -------------------------------------------------------------------------------
88 glb_ZA_ADL_TX_RBT NUMBER;
89 glb_ZA_ARR_PF_AN_MX_ABT NUMBER;
90 glb_ZA_ARR_RA_AN_MX_ABT NUMBER;
91 glb_ZA_TRV_ALL_TX_PRC NUMBER;
92 glb_ZA_CC_TX_PRC 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_PER_SERV_TRST_PERC NUMBER;
97 glb_ZA_PRI_TX_RBT NUMBER;
98 glb_ZA_PRI_TX_THRSHLD NUMBER;
99 glb_ZA_PBL_TX_PRC NUMBER;
100 glb_ZA_PBL_TX_RTE NUMBER;
101 glb_ZA_RA_AN_MX_ABT NUMBER;
102 glb_ZA_RA_MX_PRC NUMBER;
103 glb_ZA_SC_TX_THRSHLD NUMBER;
104 glb_ZA_SIT_LIM NUMBER;
105 glb_ZA_TMP_TX_RTE NUMBER;
106 glb_ZA_WRK_DYS_PR_YR NUMBER;
107 glb_ZA_ALLOW_DONATION_PERC NUMBER; /*TYS2010*/
108 --Bug 8844712
109 glb_ZA_LATE_PAYMENT_PERC NUMBER;
110 glb_ZA_TRI_TX_RBT NUMBER;
111 glb_ZA_TRI_TX_THRSHLD NUMBER;
112 -------------------------------------------------------------------------------
113 -- Application Database Items
114 -------------------------------------------------------------------------------
115 dbi_BP_TX_RCV VARCHAR2(1);
116 dbi_PAY_PROC_PRD_DTE_PD DATE;
117 dbi_PER_AGE NUMBER;
118 dbi_PER_DTE_OF_BRTH DATE;
119 dbi_SEA_WRK_DYS_WRK NUMBER;
120 dbi_SES_DTE DATE;
121 dbi_TX_DIR_NUM VARCHAR2(60);
122 dbi_TX_DIR_VAL NUMBER DEFAULT 25;
123 dbi_TX_STA VARCHAR2(1);
124 dbi_TX_MTD VARCHAR2(1);
125 dbi_ZA_ACT_END_DTE DATE;
126 dbi_ZA_ACT_STRT_DTE DATE;
127 dbi_ZA_ASG_TX_RTR_PRD VARCHAR2(1);
128 dbi_ZA_ASG_TAX_RTR_RSLTS VARCHAR2(1);
129 dbi_ZA_ASG_TX_YR NUMBER(4);
130 dbi_ZA_ASG_TX_YR_END DATE;
131 dbi_ZA_ASG_TX_YR_STRT DATE;
132 dbi_ZA_CUR_PRD_END_DTE DATE;
133 dbi_ZA_CUR_PRD_STRT_DTE DATE;
134 dbi_ZA_DYS_IN_YR NUMBER;
135 dbi_ZA_PAY_PRDS_LFT NUMBER;
136 dbi_ZA_PAY_PRDS_PER_YR NUMBER;
137 dbi_ZA_TX_YR_END DATE;
138 dbi_ZA_TX_YR_STRT DATE;
139 dbi_ZA_LS_DIR_NUM VARCHAR2(13);
140 dbi_ZA_LS_DIR_VAL NUMBER;
141 dbi_ZA_RET_LS_DIR_NUM VARCHAR2(13);
142 dbi_ZA_RET_LS_DIR_VAL NUMBER;
143 -------------------------------------------------------------------------------
144 -- Balances
145 -------------------------------------------------------------------------------
146 bal_ANN_ARR_PF_CMTD BALANCE;
147 bal_ANN_ARR_PF_CYTD BALANCE;
148 bal_ANN_ARR_PF_RUN BALANCE;
149 bal_ANN_ARR_PF_PTD BALANCE;
150 bal_ANN_ARR_PF_YTD BALANCE;
151 bal_ANN_ARR_RA_CMTD BALANCE;
152 bal_ANN_ARR_RA_CYTD BALANCE;
153 bal_ANN_ARR_RA_RUN BALANCE;
154 bal_ANN_ARR_RA_PTD BALANCE;
155 bal_ANN_ARR_RA_YTD BALANCE;
156 bal_ANN_EE_INC_PRO_POL_CMTD BALANCE;
157 bal_ANN_EE_INC_PRO_POL_CYTD BALANCE;
158 bal_ANN_EE_INC_PRO_POL_RUN BALANCE;
159 bal_ANN_EE_INC_PRO_POL_PTD BALANCE;
160 bal_ANN_EE_INC_PRO_POL_YTD BALANCE;
161 bal_ANN_MED_CNTRB_ABM_CMTD BALANCE;
162 bal_ANN_MED_CNTRB_ABM_CYTD BALANCE;
163 bal_ANN_MED_CNTRB_ABM_RUN BALANCE;
164 bal_ANN_MED_CNTRB_ABM_PTD BALANCE;
165 bal_ANN_MED_CNTRB_ABM_YTD BALANCE;
166 bal_ANN_PF_CMTD BALANCE;
167 bal_ANN_PF_CYTD BALANCE;
168 bal_ANN_PF_RUN BALANCE;
169 bal_ANN_PF_PTD BALANCE;
170 bal_ANN_PF_YTD BALANCE;
171 bal_ANN_RA_CMTD BALANCE;
172 bal_ANN_RA_CYTD BALANCE;
173 bal_ANN_RA_RUN BALANCE;
174 bal_ANN_RA_PTD BALANCE;
175 bal_ANN_RA_YTD BALANCE;
176 /* TYS2010 */
177 bal_ANN_DONAT_MD_EE_CMTD BALANCE;
178 bal_ANN_DONAT_MD_EE_CYTD BALANCE;
179 bal_ANN_DONAT_MD_EE_RUN BALANCE;
180 bal_ANN_DONAT_MD_EE_PTD BALANCE;
181 bal_ANN_DONAT_MD_EE_YTD BALANCE;
182 /* End TYS2010 */
183 bal_ARR_PF_CMTD BALANCE;
184 bal_ARR_PF_CYTD BALANCE;
185 bal_ARR_PF_PTD BALANCE;
186 bal_ARR_PF_YTD BALANCE;
187 bal_ARR_RA_CMTD BALANCE;
188 bal_ARR_RA_CYTD BALANCE;
189 bal_ARR_RA_PTD BALANCE;
190 bal_ARR_RA_YTD BALANCE;
191 bal_BP_CMTD BALANCE;
192 bal_BP_RUN BALANCE; -- Bug 13777759
193 bal_BP_PTD BALANCE;
194 bal_BP_YTD BALANCE;
195 bal_CUR_PF_CMTD BALANCE;
196 bal_CUR_PF_CYTD BALANCE;
197 bal_CUR_PF_RUN BALANCE;
198 bal_CUR_PF_PTD BALANCE;
199 bal_CUR_PF_YTD BALANCE;
200 bal_CUR_RA_CMTD BALANCE;
201 bal_CUR_RA_CYTD BALANCE;
202 bal_CUR_RA_RUN BALANCE;
203 bal_CUR_RA_PTD BALANCE;
204 bal_CUR_RA_YTD BALANCE;
205 bal_DIR_DMD_RMN_ITD BALANCE;
206 /* TYS2010 */
207 bal_DONAT_MD_EE_CMTD BALANCE;
208 bal_DONAT_MD_EE_CYTD BALANCE;
209 bal_DONAT_MD_EE_RUN BALANCE;
210 bal_DONAT_MD_EE_PTD BALANCE;
211 bal_DONAT_MD_EE_YTD BALANCE;
212 /* End TYS2010 */
213 bal_EE_INC_PRO_POL_CMTD BALANCE;
214 bal_EE_INC_PRO_POL_CYTD BALANCE;
215 bal_EE_INC_PRO_POL_RUN BALANCE;
216 bal_EE_INC_PRO_POL_PTD BALANCE;
217 bal_EE_INC_PRO_POL_YTD BALANCE;
218 bal_EXC_ARR_PEN_ITD BALANCE;
219 bal_EXC_ARR_PEN_PTD BALANCE;
220 bal_EXC_ARR_PEN_YTD BALANCE;
221 bal_EXC_ARR_RA_ITD BALANCE;
222 bal_EXC_ARR_RA_PTD BALANCE;
223 bal_EXC_ARR_RA_YTD BALANCE;
224 bal_MED_CONTR_CMTD BALANCE;
225 bal_MED_CONTR_CYTD BALANCE;
226 bal_MED_CONTR_RUN BALANCE;
227 bal_MED_CONTR_PTD BALANCE;
228 bal_MED_CONTR_YTD BALANCE;
229 bal_MED_CNTRB_ABM_CMTD BALANCE;
230 bal_MED_CNTRB_ABM_CYTD BALANCE;
231 bal_MED_CNTRB_ABM_RUN BALANCE;
232 bal_MED_CNTRB_ABM_PTD BALANCE;
233 bal_MED_CNTRB_ABM_YTD BALANCE;
234 bal_NET_PAY_RUN BALANCE;
235 bal_NET_TXB_INC_CMTD BALANCE;
236 bal_PAYE_YTD BALANCE;
237 bal_SITE_YTD BALANCE;
238 bal_TAX_YTD BALANCE;
239 bal_TX_ON_AB_PTD BALANCE;
240 bal_TX_ON_AB_YTD BALANCE;
241 bal_TX_ON_AP_PTD BALANCE;
242 bal_TX_ON_AP_YTD BALANCE;
243 bal_TX_ON_BP_PTD BALANCE;
244 bal_TX_ON_BP_YTD BALANCE;
245 bal_TX_ON_TA_PTD BALANCE;
246 bal_TX_ON_TA_YTD BALANCE;
247 bal_TX_ON_DR_PTD BALANCE;
248 bal_TX_ON_DR_YTD BALANCE;
249 bal_TX_ON_FB_PTD BALANCE;
250 bal_TX_ON_FB_YTD BALANCE;
251 bal_TX_ON_NI_PTD BALANCE;
252 bal_TX_ON_NI_YTD BALANCE;
253 bal_TX_ON_PO_PTD BALANCE;
254 bal_TX_ON_PO_YTD BALANCE;
255 bal_TX_ON_LS_PTD BALANCE;
256 bal_TX_ON_RET_LS_PTD BALANCE;
257
258 bal_TX_ON_LS_RUN BALANCE;
259 bal_TX_ON_LS_YTD BALANCE;
260
261 bal_TOT_INC_PTD BALANCE;
262 bal_TOT_INC_YTD BALANCE;
263 bal_TOT_NRFI_AN_INC_CMTD BALANCE;
264 bal_TOT_NRFI_AN_INC_CYTD BALANCE;
265 bal_TOT_NRFI_AN_INC_RUN BALANCE;
266 bal_TOT_NRFI_AN_INC_PTD BALANCE;
267 bal_TOT_NRFI_AN_INC_YTD BALANCE;
268 bal_TOT_NRFI_INC_CMTD BALANCE;
269 bal_TOT_NRFI_INC_CYTD BALANCE;
270 bal_TOT_NRFI_INC_RUN BALANCE;
271 bal_TOT_NRFI_INC_PTD BALANCE;
272 bal_TOT_NRFI_INC_YTD BALANCE;
273 bal_TOT_RFI_AN_INC_CMTD BALANCE;
274 bal_TOT_RFI_AN_INC_CYTD BALANCE;
275 bal_TOT_RFI_AN_INC_RUN BALANCE;
276 bal_TOT_RFI_AN_INC_PTD BALANCE;
277 bal_TOT_RFI_AN_INC_YTD BALANCE;
278 bal_TOT_RFI_INC_CMTD BALANCE;
279 bal_TOT_RFI_INC_CYTD BALANCE;
280 bal_TOT_RFI_INC_RUN BALANCE;
281 bal_TOT_RFI_INC_PTD BALANCE;
282 bal_TOT_RFI_INC_YTD BALANCE;
283 bal_TOT_SEA_WRK_DYS_WRK_YTD BALANCE;
284 bal_TOT_SKL_ANN_INC_CMTD BALANCE;
285 bal_TOT_SKL_INC_CMTD BALANCE;
286 bal_TOT_TXB_INC_ITD BALANCE;
287 bal_TOT_TXB_AB_CMTD BALANCE;
288 bal_TOT_TXB_AB_RUN BALANCE;
289 bal_TOT_TXB_AB_PTD BALANCE;
290 bal_TOT_TXB_AB_YTD BALANCE;
291 bal_TOT_TXB_AP_CMTD BALANCE;
292 bal_TOT_TXB_AP_RUN BALANCE;
293 bal_TOT_TXB_AP_PTD BALANCE;
294 bal_TOT_TXB_AP_YTD BALANCE;
295 bal_TOT_TXB_FB_CMTD BALANCE;
296 bal_TOT_TXB_FB_CYTD BALANCE;
297 bal_TOT_TXB_FB_RUN BALANCE;
298 bal_TOT_TXB_FB_PTD BALANCE;
299 bal_TOT_TXB_FB_YTD BALANCE;
300 bal_TOT_TXB_NI_CMTD BALANCE;
301 bal_TOT_TXB_NI_CYTD BALANCE;
302 bal_TOT_TXB_NI_RUN BALANCE;
303 bal_TOT_TXB_NI_PTD BALANCE;
304 bal_TOT_TXB_NI_YTD BALANCE;
305 bal_TOT_TXB_PO_CMTD BALANCE;
306 bal_TOT_TXB_PO_RUN BALANCE; -- Bug 13777759
307 bal_TOT_TXB_PO_PTD BALANCE;
308 bal_TOT_TXB_PO_YTD BALANCE;
309 bal_TOT_TXB_TA_CMTD BALANCE;
310 bal_TOT_TXB_TA_CYTD BALANCE;
311 bal_TOT_TXB_TA_RUN BALANCE; -- Bug 13777759
312 bal_TOT_TXB_TA_PTD BALANCE;
313 bal_TOT_TXB_TA_YTD BALANCE;
314 -- EMP201
315 bal_GROSS_REMUNERATION_CMTD BALANCE;
316 bal_ANN_PAYMENTS_CMTD BALANCE;
317 bal_NET_PAYE_TXB_INC_CMTD BALANCE;
318
319 bal_MED_AID_TAX_CR_CMTD BALANCE;
323 bal_MED_AID_TAX_CR_YTD BALANCE;
320 bal_MED_AID_TAX_CR_CYTD BALANCE;
321 bal_MED_AID_TAX_CR_RUN BALANCE;
322 bal_MED_AID_TAX_CR_PTD BALANCE;
324 bal_ANN_MED_AID_TAX_CR_CMTD BALANCE;
325 bal_ANN_MED_AID_TAX_CR_CYTD BALANCE;
326 bal_ANN_MED_AID_TAX_CR_RUN BALANCE;
327 bal_ANN_MED_AID_TAX_CR_PTD BALANCE;
328 bal_ANN_MED_AID_TAX_CR_YTD BALANCE;
329 bal_MED_AID_TAX_CR_USED_CMTD BALANCE;
330 bal_MED_AID_TAX_CR_USED_CYTD BALANCE;
331 bal_MED_AID_TAX_CR_USED_RUN BALANCE;
332 bal_MED_AID_TAX_CR_USED_PTD BALANCE;
333 bal_MED_AID_TAX_CR_USED_YTD BALANCE;
334 bal_MED_TAX_CR_USED_NI_CMTD BALANCE;
335 bal_MED_TAX_CR_USED_NI_CYTD BALANCE;
336 bal_MED_TAX_CR_USED_NI_RUN BALANCE;
337 bal_MED_TAX_CR_USED_NI_PTD BALANCE;
338 bal_MED_TAX_CR_USED_NI_YTD BALANCE;
339 bal_MED_TAX_CR_USED_FB_CMTD BALANCE;
340 bal_MED_TAX_CR_USED_FB_CYTD BALANCE;
341 bal_MED_TAX_CR_USED_FB_RUN BALANCE;
342 bal_MED_TAX_CR_USED_FB_PTD BALANCE;
343 bal_MED_TAX_CR_USED_FB_YTD BALANCE;
344 bal_MED_TAX_CR_USED_TA_CMTD BALANCE;
345 bal_MED_TAX_CR_USED_TA_CYTD BALANCE;
346 bal_MED_TAX_CR_USED_TA_RUN BALANCE;
347 bal_MED_TAX_CR_USED_TA_PTD BALANCE;
348 bal_MED_TAX_CR_USED_TA_YTD BALANCE;
349 bal_MED_TAX_CR_USED_BP_CMTD BALANCE;
350 bal_MED_TAX_CR_USED_BP_CYTD BALANCE;
351 bal_MED_TAX_CR_USED_BP_RUN BALANCE;
352 bal_MED_TAX_CR_USED_BP_PTD BALANCE;
353 bal_MED_TAX_CR_USED_BP_YTD BALANCE;
354 bal_MED_TAX_CR_USED_AB_CMTD BALANCE;
355 bal_MED_TAX_CR_USED_AB_CYTD BALANCE;
356 bal_MED_TAX_CR_USED_AB_RUN BALANCE;
357 bal_MED_TAX_CR_USED_AB_PTD BALANCE;
358 bal_MED_TAX_CR_USED_AB_YTD BALANCE;
359 bal_MED_TAX_CR_USED_AP_CMTD BALANCE;
360 bal_MED_TAX_CR_USED_AP_CYTD BALANCE;
361 bal_MED_TAX_CR_USED_AP_RUN BALANCE;
362 bal_MED_TAX_CR_USED_AP_PTD BALANCE;
363 bal_MED_TAX_CR_USED_AP_YTD BALANCE;
364 bal_MED_TAX_CR_USED_PO_CMTD BALANCE;
365 bal_MED_TAX_CR_USED_PO_CYTD BALANCE;
366 bal_MED_TAX_CR_USED_PO_RUN BALANCE;
367 bal_MED_TAX_CR_USED_PO_PTD BALANCE;
368 bal_MED_TAX_CR_USED_PO_YTD BALANCE;
369 -- Bug 13777759
370 bal_MED_TAX_CR_USED_NG_CMTD BALANCE;
371 bal_MED_TAX_CR_USED_NG_CYTD BALANCE;
372 bal_MED_TAX_CR_USED_NG_RUN BALANCE;
373 bal_MED_TAX_CR_USED_NG_PTD BALANCE;
374 bal_MED_TAX_CR_USED_NG_YTD BALANCE;
375 bal_MED_TAX_CR_USED_EE_CMTD BALANCE;
376 bal_MED_TAX_CR_USED_EE_CYTD BALANCE;
377 bal_MED_TAX_CR_USED_EE_RUN BALANCE;
378 bal_MED_TAX_CR_USED_EE_PTD BALANCE;
379 bal_MED_TAX_CR_USED_EE_YTD BALANCE;
380 -- Bug 13777759
381
382 -- Bug 14024624
383 bal_MED_TAX_CR_USED_DR_CMTD BALANCE;
384 bal_MED_TAX_CR_USED_DR_CYTD BALANCE;
385 bal_MED_TAX_CR_USED_DR_RUN BALANCE;
386 bal_MED_TAX_CR_USED_DR_PTD BALANCE;
387 bal_MED_TAX_CR_USED_DR_YTD BALANCE;
388 -- Bug 14024624
389
390 bal_MED_AID_TAX_CR_USED_LS_PTD BALANCE;
391 bal_MED_AID_TAX_CR_USED_LS_YTD BALANCE;
392
393 /*NTG */
394 bal_TX_ON_AP_NTG_YTD BALANCE;
395 bal_TX_ON_AP_NTG_PTD BALANCE;
396 bal_TX_ON_EE_DBT_NTG_YTD BALANCE;
397 bal_TX_ON_EE_DBT_NTG_PTD BALANCE;
398 bal_TOT_TXB_AP_NTG_CMTD BALANCE;
399 bal_TOT_TXB_AP_NTG_RUN BALANCE;
400 bal_TOT_TXB_AP_NTG_PTD BALANCE;
401 bal_TOT_TXB_AP_NTG_YTD BALANCE;
402 bal_TOT_TXB_EE_DBT_NTG_CMTD BALANCE;
403 bal_TOT_TXB_EE_DBT_NTG_RUN BALANCE;
404 bal_TOT_TXB_EE_DBT_NTG_PTD BALANCE;
405 bal_TOT_TXB_EE_DBT_NTG_YTD BALANCE;
406 bal_TOT_RFI_EE_DBT_NTG_CMTD BALANCE;
407 bal_TOT_RFI_EE_DBT_NTG_CYTD BALANCE;
408 bal_TOT_RFI_EE_DBT_NTG_RUN BALANCE;
409 bal_TOT_RFI_EE_DBT_NTG_PTD BALANCE;
410 bal_TOT_RFI_EE_DBT_NTG_YTD BALANCE;
411 bal_TOT_NRFI_EE_DBT_NTG_CMTD BALANCE;
412 bal_TOT_NRFI_EE_DBT_NTG_CYTD BALANCE;
413 bal_TOT_NRFI_EE_DBT_NTG_RUN BALANCE;
414 bal_TOT_NRFI_EE_DBT_NTG_PTD BALANCE;
415 bal_TOT_NRFI_EE_DBT_NTG_YTD BALANCE;
416 bal_TOT_SKL_ANN_INC_NTG_CMTD BALANCE;
417
418 -- Medical Aid Employer Contribution Changes
419 bal_ER_MED_CONTR_CMTD BALANCE;
420 bal_ER_MED_CONTR_CYTD BALANCE;
421 bal_ER_MED_CONTR_RUN BALANCE;
422 bal_ER_MED_CONTR_PTD BALANCE;
423 bal_ER_MED_CONTR_YTD BALANCE;
424
425 -- Bug 14168167
426 bal_MED_EMP_NRFI_ASG_RUN BALANCE;
427 bal_MED_EMP_NRFI_ASG_TAX_PTD BALANCE;
428 bal_MED_EMP_NRFI_ASG_TAX_YTD BALANCE;
429 bal_MED_EMP_PKG_ASG_RUN BALANCE;
430 bal_MED_EMP_PKG_ASG_TAX_PTD BALANCE;
431 bal_MED_EMP_PKG_ASG_TAX_YTD BALANCE;
432 bal_MED_EMP_RFI_ASG_RUN BALANCE;
433 bal_MED_EMP_RFI_ASG_TAX_PTD BALANCE;
434 bal_MED_EMP_RFI_ASG_TAX_YTD BALANCE;
435 -- Bug 14168167
436
437 -------------------------------------------------------------------------------
438 -- Trace Globals
439 -------------------------------------------------------------------------------
440
441 -- These are set within the procedures and function calls!!
442 -- Values can be output by the main function call from formula
443 --
444 -- Calculation Type
445 trc_CalTyp VARCHAR2(7) DEFAULT 'Unknown';
446 -- Added for Bug 9369895
447 trc_PenBasis NUMBER DEFAULT 0;
448
449 -- trc_TxbInc BALANCE DEFAULT 0;
450 -- Factors
451 trc_TxbIncPtd BALANCE DEFAULT 0;
455 -- Deemed Remuneration
452 trc_PrdFactor NUMBER DEFAULT 0;
453 trc_PosFactor NUMBER DEFAULT 0;
454 trc_SitFactor NUMBER DEFAULT 1;
456 trc_DmdRmnRun BALANCE DEFAULT 0;
457 trc_TxbDmdRmn BALANCE DEFAULT 0;
458 trc_TotLibDR BALANCE DEFAULT 0;
459 trc_LibFyDR BALANCE DEFAULT 0;
460 trc_LibFpDR BALANCE DEFAULT 0;
461 -- Base Income
462 trc_BseErn BALANCE DEFAULT 0;
463 trc_TxbBseInc BALANCE DEFAULT 0;
464 --TYS2010
465 trc_TxbBseIncWoDon BALANCE DEFAULT 0;
466 trc_TotLibBse BALANCE DEFAULT 0;
467 -- Period Pension Fund
468 trc_TxbIncYtd BALANCE DEFAULT 0;
469 trc_PerTxbInc BALANCE DEFAULT 0;
470 trc_PerPenFnd BALANCE DEFAULT 0;
471 trc_PerRfiCon BALANCE DEFAULT 0;
472 trc_PerRfiTxb BALANCE DEFAULT 0;
473 trc_PerPenFndMax BALANCE DEFAULT 0;
474 trc_PerPenFndAbm BALANCE DEFAULT 0;
475 -- Annual Pension Fund
476 trc_AnnTxbInc BALANCE DEFAULT 0;
477 trc_AnnPenFnd BALANCE DEFAULT 0;
478 trc_AnnRfiCon BALANCE DEFAULT 0;
479 trc_AnnRfiTxb BALANCE DEFAULT 0;
480 trc_AnnPenFndMax BALANCE DEFAULT 0;
481 trc_AnnPenFndAbm BALANCE DEFAULT 0;
482 -- Period Arrear Pension
483 trc_PerArrPenFnd BALANCE DEFAULT 0;
484 trc_PerArrPenFndAbm BALANCE DEFAULT 0;
485 -- Annual Arrear Pension
486 trc_AnnArrPenFnd BALANCE DEFAULT 0;
487 trc_AnnArrPenFndAbm BALANCE DEFAULT 0;
488 -- Arrear Excess Update Value
489 trc_PfUpdFig BALANCE DEFAULT 0;
490 -- Period Retirement Annuity
491 trc_PerRetAnu BALANCE DEFAULT 0;
492 trc_PerNrfiCon BALANCE DEFAULT 0;
493 trc_PerRetAnuMax BALANCE DEFAULT 0;
494 trc_PerRetAnuAbm BALANCE DEFAULT 0;
495 -- Annual Retirement Annuity
496 trc_AnnRetAnu BALANCE DEFAULT 0;
497 trc_AnnNrfiCon BALANCE DEFAULT 0;
498 trc_AnnRetAnuMax BALANCE DEFAULT 0;
499 trc_AnnRetAnuAbm BALANCE DEFAULT 0;
500 -- Period Arrear Retirement Annuity
501 trc_PerArrRetAnu BALANCE DEFAULT 0;
502 trc_PerArrRetAnuAbm BALANCE DEFAULT 0;
503 -- Annual Arrear Retirement Annuity
504 trc_AnnArrRetAnu BALANCE DEFAULT 0;
505 trc_AnnArrRetAnuAbm BALANCE DEFAULT 0;
506 -- Arrear Excess Update Value
507 trc_RaUpdFig BALANCE DEFAULT 0;
508 -- Medical Aid Abatement
509 trc_PerMedAidAbm BALANCE DEFAULT 0;
510 trc_AnnMedAidAbm BALANCE DEFAULT 0;
511 -- Rebates Thresholds
512 trc_Rebate BALANCE DEFAULT 0;
513 trc_Threshold BALANCE DEFAULT 0;
514 -- TYS2010
515 -- Donation
516 trc_AllowDonPerc BALANCE DEFAULT 0;
517 -- Income Protection Policy
518 trc_PerIncProPolAbm BALANCE DEFAULT 0;
519 trc_AnnIncProPolAbm BALANCE DEFAULT 0;
520 -- Abatement Totals
521 trc_PerTotAbm BALANCE DEFAULT 0;
522 trc_AnnTotAbm BALANCE DEFAULT 0;
523 -- Employee Donation --TYS2010
524 trc_PerDonAmt BALANCE DEFAULT 0;
525 trc_AnnDonAmt BALANCE DEFAULT 0;
526 -- Normal Income
527 trc_NorIncYtd BALANCE DEFAULT 0;
528 trc_NorIncPtd BALANCE DEFAULT 0;
529 trc_NorErn BALANCE DEFAULT 0;
530 trc_TxbNorInc BALANCE DEFAULT 0;
531 --TYS2010
532 trc_TxbNorIncWoDon BALANCE DEFAULT 0;
533 trc_TotLibNI BALANCE DEFAULT 0;
534 trc_LibFyNI BALANCE DEFAULT 0;
535 trc_LibFpNI BALANCE DEFAULT 0;
536 -- Fringe Benefits
537 trc_FrnBenYtd BALANCE DEFAULT 0;
538 trc_FrnBenPtd BALANCE DEFAULT 0;
539 trc_FrnBenErn BALANCE DEFAULT 0;
540 trc_TxbFrnInc BALANCE DEFAULT 0;
541 --TYS2010
542 trc_TxbFrnIncWoDon BALANCE DEFAULT 0;
543 trc_TotLibFB BALANCE DEFAULT 0;
544 trc_LibFyFB BALANCE DEFAULT 0;
545 trc_LibFpFB BALANCE DEFAULT 0;
546 -- Travel Allowance
547 trc_TrvAllYtd BALANCE DEFAULT 0;
548 trc_TrvAllPtd BALANCE DEFAULT 0;
549 trc_TrvAllErn BALANCE DEFAULT 0;
550 trc_TxbTrvInc BALANCE DEFAULT 0;
551 --TYS2010
552 trc_TxbTrvIncWoDon BALANCE DEFAULT 0;
553 trc_TotLibTA BALANCE DEFAULT 0;
554 trc_LibFyTA BALANCE DEFAULT 0;
555 trc_LibFpTA BALANCE DEFAULT 0;
556 -- Bonus Provision
557 trc_BonProYtd BALANCE DEFAULT 0;
558 trc_BonProPtd BALANCE DEFAULT 0;
559 trc_BonProErn BALANCE DEFAULT 0;
560 trc_TxbBonProInc BALANCE DEFAULT 0;
561 --TYS2010
562 trc_TxbBonProIncWoDon BALANCE DEFAULT 0;
563 trc_TotLibBP BALANCE DEFAULT 0;
564 trc_LibFyBP BALANCE DEFAULT 0;
565 trc_LibFpBP BALANCE DEFAULT 0;
566 -- Annual Bonus
567 trc_AnnBonYtd BALANCE DEFAULT 0;
568 trc_AnnBonPtd BALANCE DEFAULT 0;
569 trc_AnnBonErn BALANCE DEFAULT 0;
570 trc_TxbAnnBonInc BALANCE DEFAULT 0;
571 --TYS2010
572 trc_TxbAnnBonIncWoDon BALANCE DEFAULT 0;
573 trc_TotLibAB BALANCE DEFAULT 0;
574 trc_LibFyAB BALANCE DEFAULT 0;
575 trc_LibFpAB BALANCE DEFAULT 0;
576 -- Annual Payments
577 trc_AnnPymYtd BALANCE DEFAULT 0;
578 trc_AnnPymPtd BALANCE DEFAULT 0;
579 trc_AnnPymErn BALANCE DEFAULT 0;
580 trc_TxbAnnPymInc BALANCE DEFAULT 0;
581 --TYS2010
585 trc_LibFpAP BALANCE DEFAULT 0;
582 trc_TxbAnnPymIncWoDon BALANCE DEFAULT 0;
583 trc_TotLibAP BALANCE DEFAULT 0;
584 trc_LibFyAP BALANCE DEFAULT 0;
586 -- NTG Annual Payments
587 trc_AnnPymNtgYtd BALANCE DEFAULT 0;
588 trc_AnnPymNtgPtd BALANCE DEFAULT 0;
589 trc_AnnPymNtgErn BALANCE DEFAULT 0;
590 trc_TxbAnnPymNtgInc BALANCE DEFAULT 0;
591 trc_TxbAnnPymNtgIncWoDon BALANCE DEFAULT 0;
592 trc_TotLibNtgAP BALANCE DEFAULT 0;
593 trc_LibFyNtgAP BALANCE DEFAULT 0;
594 trc_LibFpNtgAP BALANCE DEFAULT 0;
595 -- NTG Fringe Benifits
596 trc_AnnEEDbtNtgYtd BALANCE DEFAULT 0;
597 trc_AnnEEDbtNtgPtd BALANCE DEFAULT 0;
598 trc_AnnEEDbtNtgErn BALANCE DEFAULT 0;
599 trc_TxbAnnEEDbtNtgInc BALANCE DEFAULT 0;
600 trc_TxbAnnEEDbtNtgIncWoDon BALANCE DEFAULT 0;
601 trc_TotLibNtgEEDbt BALANCE DEFAULT 0;
602 trc_LibFyNtgEEDbt BALANCE DEFAULT 0;
603 trc_LibFpNtgEEDbt BALANCE DEFAULT 0;
604 trc_AnnRfiEEDbtNTGCon BALANCE DEFAULT 0;
605 trc_AnnNrfiEEDbtNTGCon BALANCE DEFAULT 0;
606 trc_AnnPenFndNTGMax BALANCE DEFAULT 0;
607 trc_AnnPenFndNTGAbm BALANCE DEFAULT 0;
608 trc_AnnRetAnuNTGMax BALANCE DEFAULT 0;
609 trc_AnnRetAnuNTGAbm BALANCE DEFAULT 0;
610 trc_AnnTotNTGAbm BALANCE DEFAULT 0;
611 --End NTG Annual Payments
612 -- Pubilc Office Allowance
613 trc_PblOffYtd BALANCE DEFAULT 0;
614 trc_PblOffPtd BALANCE DEFAULT 0;
615 trc_PblOffErn BALANCE DEFAULT 0;
616 trc_TxbPblOffInc BALANCE DEFAULT 0;
617 --TYS2010
618 trc_TxbPblOffIncWoDon BALANCE DEFAULT 0;
619 trc_TotLibPO BALANCE DEFAULT 0;
620 trc_LibFyPO BALANCE DEFAULT 0;
621 trc_LibFpPO BALANCE DEFAULT 0;
622
623 --EMP201
624 trc_NPtiUpdFig BALANCE default 0 ;
625
626
627 -- Messages
628 trc_LibWrn VARCHAR2(100) DEFAULT ' ';
629
630 -- Statutory Deduction Value
631 trc_PayValSD BALANCE DEFAULT 0;
632 -- Employer Contribution Value
633 trc_PayValEC BALANCE DEFAULT 0;
634 -- PAYE and SITE Values
635 trc_PayeVal BALANCE DEFAULT 0;
636 trc_SiteVal BALANCE DEFAULT 0;
637 -- IT3A Threshold Indicator
638 trc_It3Ind NUMBER DEFAULT 0;
639 -- Tax Percentage Value On trace
640 trc_TxPercVal NUMBER DEFAULT 0;
641 -- Total Taxable Income Update Figure
642 trc_OUpdFig BALANCE DEFAULT 0;
643 -- Net Taxable Income Update Figure
644 trc_NtiUpdFig BALANCE DEFAULT 0;
645
646 -- ValidateTaxOns Override Globals
647 trc_LibFpDROvr BOOLEAN DEFAULT FALSE;
648 trc_LibFpNIOvr BOOLEAN DEFAULT FALSE;
649 trc_LibFpFBOvr BOOLEAN DEFAULT FALSE;
650 trc_LibFpTAOvr BOOLEAN DEFAULT FALSE;
651 trc_LibFpBPOvr BOOLEAN DEFAULT FALSE;
652 trc_LibFpABOvr BOOLEAN DEFAULT FALSE;
653 trc_LibFpAPOvr BOOLEAN DEFAULT FALSE;
654 trc_LibFpPOOvr BOOLEAN DEFAULT FALSE;
655 -- NTG
656 trc_LibFpNtgAPOvr BOOLEAN DEFAULT FALSE;
657 trc_LibFpNtgEEDbtOvr BOOLEAN DEFAULT FALSE;
658 -- End NTG
659
660 -- Global Exception Message
661 xpt_Msg VARCHAR2(100) DEFAULT 'No Error';
662 -- Global Exception
663 xpt_E EXCEPTION;
664
665 -- Override Globals
666 trc_OvrTxCalc BOOLEAN DEFAULT FALSE;
667 trc_OvrTyp VARCHAR2(1) DEFAULT 'V';
668 trc_OvrPrc NUMBER(3) DEFAULT 0;
669 trc_OvrWrn VARCHAR2(150) DEFAULT ' ';
670 -- Bug 8844712 This indicates whether its LteCalc and is calculating SitePaye split
671 trc_LateSitePaye NUMBER(3) DEFAULT 0;
672
673 -- Negative Ptd Global
674 trc_NegPtd BOOLEAN DEFAULT FALSE;
675
676 trc_MedTxCr BALANCE DEFAULT 0;
677 trc_MedTxCrUsed BALANCE DEFAULT 0;
678 trc_MedTxCrUsedDR BALANCE DEFAULT 0; -- Bug 14024624
679 trc_MedTxCrUsedNI BALANCE DEFAULT 0;
680 trc_MedTxCrUsedFB BALANCE DEFAULT 0;
681 trc_MedTxCrUsedTA BALANCE DEFAULT 0;
682 trc_MedTxCrUsedBP BALANCE DEFAULT 0;
683 trc_MedTxCrUsedAB BALANCE DEFAULT 0;
684 trc_MedTxCrUsedAP BALANCE DEFAULT 0;
685 trc_MedTxCrUsedPO BALANCE DEFAULT 0;
686 trc_MedTxCrUsedNtgAP BALANCE DEFAULT 0; -- Bug 13777759
687 trc_MedTxCrUsedNtgEEDbt BALANCE DEFAULT 0; -- Bug 13777759
688 trc_LibFpDR_Upd BALANCE DEFAULT 0; -- Bug 13777759
689 trc_LibFyNI_Upd BALANCE DEFAULT 0;
690 trc_LibFpNI_Upd BALANCE DEFAULT 0;
691 trc_LibFyFB_Upd BALANCE DEFAULT 0;
692 trc_LibFpFB_Upd BALANCE DEFAULT 0;
693 trc_LibFyTA_Upd BALANCE DEFAULT 0;
694 trc_LibFpTA_Upd BALANCE DEFAULT 0;
695 trc_LibFyBP_Upd BALANCE DEFAULT 0;
696 trc_LibFpBP_Upd BALANCE DEFAULT 0;
697 trc_LibFyAB_Upd BALANCE DEFAULT 0;
698 trc_LibFpAB_Upd BALANCE DEFAULT 0;
699 trc_LibFyAP_Upd BALANCE DEFAULT 0;
700 trc_LibFpAP_Upd BALANCE DEFAULT 0;
701 trc_LibFyPO_Upd BALANCE DEFAULT 0;
702 trc_LibFpPO_Upd BALANCE DEFAULT 0;
703 trc_LibFpNtgAP_Upd BALANCE DEFAULT 0; -- Bug 13777759
704 trc_LibFpNtgEEDbt_Upd BALANCE DEFAULT 0; -- Bug 13777759
705
706 trc_TotLibBse_Upd BALANCE DEFAULT 0;
707 trc_TotLibNI_Upd BALANCE DEFAULT 0;
708 trc_TotLibFB_Upd BALANCE DEFAULT 0;
712 trc_TotLibAP_Upd BALANCE DEFAULT 0;
709 trc_TotLibTA_Upd BALANCE DEFAULT 0;
710 trc_TotLibBP_Upd BALANCE DEFAULT 0;
711 trc_TotLibAB_Upd BALANCE DEFAULT 0;
713 trc_TotLibPO_Upd BALANCE DEFAULT 0;
714
715 -- Bug 13777759
716 trc_MedTxCrUsed_Upd BALANCE DEFAULT 0;
717 trc_MedTxCrUsedDR_Upd BALANCE DEFAULT 0; -- Bug 14024624
718 trc_MedTxCrUsedNI_Upd BALANCE DEFAULT 0;
719 trc_MedTxCrUsedFB_Upd BALANCE DEFAULT 0;
720 trc_MedTxCrUsedTA_Upd BALANCE DEFAULT 0;
721 trc_MedTxCrUsedBP_Upd BALANCE DEFAULT 0;
722 trc_MedTxCrUsedAB_Upd BALANCE DEFAULT 0;
723 trc_MedTxCrUsedAP_Upd BALANCE DEFAULT 0;
724 trc_MedTxCrUsedPO_Upd BALANCE DEFAULT 0;
725 trc_MedTxCrUsedNtgAP_Upd BALANCE DEFAULT 0;
726 trc_MedTxCrUsedNtgEEDbt_Upd BALANCE DEFAULT 0;
727 -- Bug 13777759
728
729 trc_curMedTxCrEle BALANCE DEFAULT 0;
730
731 -- Bug14376752
732 trc_LScount NUMBER DEFAULT 0;
733 -- Bug14376752
734
735 -- Medical Tax Credit Lump Sum Changes
736 type LSDirRec is record
737 (
738 TxOnLSDirRUN NUMBER
739 ,TxOnLSDirPTD NUMBER
740 ,TxOnLSDirYTD NUMBER
741 ,MedTxCrUsedOnLSDirRUN NUMBER
742 ,MedTxCrUsedOnLSDirPTD NUMBER
743 ,MedTxCrUsedOnLSDirYTD NUMBER
744 );
745
746 type LSDirTab is table of LSDirRec index by VARCHAR2(100);
747
748 trc_LSDirTab LSDirTab;
749
750 -- Bug 14376752
751 -- tables created for SDL Enh
752
753 type LSDirMTDRec is record
754 (
755 inc_typ VARCHAR2(10)
756 ,dir_value NUMBER
757 );
758
759
760 type LSDirMTDTab IS TABLE OF LSDirMTDRec INDEX BY VARCHAR2(100);
761
762 trc_LSDirMTDTab LSDirMTDTab;
763
764 type LS_Net_Txb_INC_Rec is record (
765 LSTxbIncMTD number,
766 LSNtiUpdFig number,
767 LSSkl number
768 );
769
770
771 type LSNetTxbIncTab IS TABLE OF LS_Net_Txb_INC_Rec INDEX BY VARCHAR2(100);
772
773 trc_LSNetTxbIncTab LSNetTxbIncTab;
774
775 type LSSklDirNum IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER ;
776
777 trc_LSSklDirNumTab LSSklDirNum;
778
779 -- Function to fetch the Directive Numbers
780
781 FUNCTION NetTxbSklDirNum(
782 p_chunk_num IN NUMBER
783 ,p_DirNum1 OUT NOCOPY VARCHAR2
784 ,p_DirNum2 OUT NOCOPY VARCHAR2
785 ,p_DirNum3 OUT NOCOPY VARCHAR2
786 ,p_DirNum4 OUT NOCOPY VARCHAR2
787 ,p_DirNum5 OUT NOCOPY VARCHAR2
788 ,p_DirNum6 OUT NOCOPY VARCHAR2
789 ,p_DirNum7 OUT NOCOPY VARCHAR2
790 ,p_DirNum8 OUT NOCOPY VARCHAR2
791 ,p_DirNum9 OUT NOCOPY VARCHAR2
792 ,p_DirNum10 OUT NOCOPY VARCHAR2
793 ,p_DirNum11 OUT NOCOPY VARCHAR2
794 ,p_DirNum12 OUT NOCOPY VARCHAR2
795 ,p_DirNum13 OUT NOCOPY VARCHAR2
796 ,p_DirNum14 OUT NOCOPY VARCHAR2
797 ,p_DirNum15 OUT NOCOPY VARCHAR2
798 )RETURN NUMBER ;
799
800
801 FUNCTION LSNetTxbInc(
802 p_Dir_Num IN VARCHAR2
803 ,p_Dir_LSNetTxbInc OUT NOCOPY NUMBER
804 )RETURN NUMBER ;
805
806 FUNCTION LSNetTxbIncUpd(
807 p_Dir_Num IN VARCHAR2
808 ,p_Dir_LSNetTxbInc OUT NOCOPY NUMBER
809 )RETURN NUMBER ;
810
811 FUNCTION LSSkillsLevy(
812 p_Dir_Num IN VARCHAR2
813 ,p_Dir_LSSkillsLevy OUT NOCOPY NUMBER
814 )RETURN NUMBER ;
815
816 FUNCTION LSDirCount RETURN NUMBER;
817
818 FUNCTION LSDirNetTxbInc(
819 p_Dir_Num IN VARCHAR2
820 ,p_LSNetTxbInc OUT NOCOPY NUMBER
821 ) RETURN NUMBER ;
822
823 -- Bug 14376752
824
825 -- Function to Override Tax Calculation
826 --
827 FUNCTION ZaTxOvr_01032012(
828 p_OvrTyp IN VARCHAR2
829 ,p_TxOnNI IN NUMBER
830 ,p_TxOnAP IN NUMBER
831 ,p_TxPrc IN NUMBER
832 )RETURN NUMBER;
833
834
835 -- Function to Initialise Globals
836 --
837 FUNCTION ZaTxGlb_01032012(
838 -- Global Values
839 p_ZA_ADL_TX_RBT IN NUMBER
840 ,p_ZA_ARR_PF_AN_MX_ABT IN NUMBER
841 ,p_ZA_ARR_RA_AN_MX_ABT IN NUMBER
842 ,p_ZA_TRV_ALL_TX_PRC IN NUMBER
843 ,p_ZA_CC_TX_PRC IN NUMBER
844 ,p_ZA_PF_AN_MX_ABT IN NUMBER
845 ,p_ZA_PF_MX_PRC IN NUMBER
846 ,p_ZA_PER_SERV_COMP_PERC IN NUMBER
847 ,p_ZA_PER_SERV_TRST_PERC IN NUMBER
848 ,p_ZA_PRI_TX_RBT IN NUMBER
849 ,p_ZA_PRI_TX_THRSHLD IN NUMBER
850 ,p_ZA_PBL_TX_PRC IN NUMBER
851 ,p_ZA_PBL_TX_RTE IN NUMBER
852 ,p_ZA_RA_AN_MX_ABT IN NUMBER
853 ,p_ZA_RA_MX_PRC IN NUMBER
854 ,p_ZA_SC_TX_THRSHLD IN NUMBER
855 ,p_ZA_SIT_LIM IN NUMBER
856 ,p_ZA_TMP_TX_RTE IN NUMBER
857 ,p_ZA_WRK_DYS_PR_YR IN NUMBER
858 ,p_ZA_ALLOW_DONATION_PERC IN NUMBER /*TYS2010*/
859 --Bug 8844712
860 ,p_ZA_LATE_PAYMENT_PERC IN NUMBER
861 ,p_ZA_TRI_TX_RBT IN NUMBER
862 ,p_ZA_TRI_TX_THRSHLD IN NUMBER
863 ) RETURN NUMBER;
864
865 -- Function to Initialise Globals - Database Item Values
866 --
867 FUNCTION ZaTxDbi_01032012(
868 -- Database Items
869 p_PAY_PROC_PRD_DTE_PD IN DATE
870 ,p_PER_AGE IN NUMBER
871 ,p_PER_DTE_OF_BRTH IN DATE
872 ,p_SES_DTE IN DATE
873 ,p_ZA_ACT_END_DTE IN DATE
874 ,p_ZA_ACT_STRT_DTE IN DATE
875 ,p_ZA_ASG_TX_RTR_PRD IN VARCHAR2
879 ,p_ZA_ASG_TX_YR_STRT IN DATE */
876 ,p_ZA_ASG_TAX_RTR_RSLTS IN VARCHAR2
877 /* ,p_ZA_ASG_TX_YR IN NUMBER
878 ,p_ZA_ASG_TX_YR_END IN DATE
880 ,p_ZA_CUR_PRD_END_DTE IN DATE
881 ,p_ZA_CUR_PRD_STRT_DTE IN DATE
882 ,p_ZA_DYS_IN_YR IN NUMBER
883 ,p_ZA_PAY_PRDS_LFT IN NUMBER
884 ,p_ZA_PAY_PRDS_PER_YR IN NUMBER
885 ,p_ZA_TX_YR_END IN DATE
886 ,p_ZA_TX_YR_STRT IN DATE
887 ,p_BP_TX_RCV IN VARCHAR2
888 ,p_SEA_WRK_DYS_WRK IN NUMBER
889 ,p_TX_DIR_NUM IN VARCHAR2
890 ,p_TX_DIR_VAL IN NUMBER
891 ,p_TX_STA IN VARCHAR2
892 ,p_ZA_LS_DIR_NUM IN VARCHAR2
893 ,p_ZA_LS_DIR_VAL IN NUMBER
894 ,p_ZA_RET_LS_DIR_NUM IN VARCHAR2
895 ,p_ZA_RET_LS_DIR_VAL IN NUMBER
896 ,p_TAX_METHOD IN VARCHAR2
897 ) RETURN NUMBER;
898
899
900 -- Function to Initialise Globals - Balance Values
901 -- First Section
902 FUNCTION ZaTxBal1_01032012(
903 -- Balances
904 p_ANN_ARR_PF_CMTD IN NUMBER
905 ,p_ANN_ARR_PF_CYTD IN NUMBER
906 ,p_ANN_ARR_PF_RUN IN NUMBER
907 ,p_ANN_ARR_PF_PTD IN NUMBER
908 ,p_ANN_ARR_PF_YTD IN NUMBER
909 ,p_ANN_ARR_RA_CMTD IN NUMBER
910 ,p_ANN_ARR_RA_CYTD IN NUMBER
911 ,p_ANN_ARR_RA_RUN IN NUMBER
912 ,p_ANN_ARR_RA_PTD IN NUMBER
913 ,p_ANN_ARR_RA_YTD IN NUMBER
914 ,p_ANN_EE_INC_PRO_POL_CMTD IN NUMBER
915 ,p_ANN_EE_INC_PRO_POL_CYTD IN NUMBER
916 ,p_ANN_EE_INC_PRO_POL_RUN IN NUMBER
917 ,p_ANN_EE_INC_PRO_POL_PTD IN NUMBER
918 ,p_ANN_EE_INC_PRO_POL_YTD IN NUMBER
919 ,p_ANN_MED_CNTRB_ABM_CMTD IN NUMBER
920 ,p_ANN_MED_CNTRB_ABM_CYTD IN NUMBER
921 ,p_ANN_MED_CNTRB_ABM_RUN IN NUMBER
922 ,p_ANN_MED_CNTRB_ABM_PTD IN NUMBER
923 ,p_ANN_MED_CNTRB_ABM_YTD IN NUMBER
924 ,p_ANN_PF_CMTD IN NUMBER
925 ,p_ANN_PF_CYTD IN NUMBER
926 ,p_ANN_PF_RUN IN NUMBER
927 ,p_ANN_PF_PTD IN NUMBER
928 ,p_ANN_PF_YTD IN NUMBER
929 ,p_ANN_RA_CMTD IN NUMBER
930 ,p_ANN_RA_CYTD IN NUMBER
931 ,p_ANN_RA_RUN IN NUMBER
932 ,p_ANN_RA_PTD IN NUMBER
933 ,p_ANN_RA_YTD IN NUMBER
934 /*TYS2010*/
935 ,p_ANN_DONAT_MD_EE_CMTD IN NUMBER
936 ,p_ANN_DONAT_MD_EE_CYTD IN NUMBER
937 ,p_ANN_DONAT_MD_EE_RUN IN NUMBER
938 ,p_ANN_DONAT_MD_EE_PTD IN NUMBER
939 ,p_ANN_DONAT_MD_EE_YTD IN NUMBER
940 ) RETURN NUMBER;
941
942 -- Function to Initialise Globals - Balance Values
943 -- Second Section
944 FUNCTION ZaTxBal2_01032012(
945 -- Balances
946 p_ARR_PF_CMTD IN NUMBER
947 ,p_ARR_PF_CYTD IN NUMBER
948 ,p_ARR_PF_PTD IN NUMBER
949 ,p_ARR_PF_YTD IN NUMBER
950 ,p_ARR_RA_CMTD IN NUMBER
951 ,p_ARR_RA_CYTD IN NUMBER
952 ,p_ARR_RA_PTD IN NUMBER
953 ,p_ARR_RA_YTD IN NUMBER
954 ,p_BP_CMTD IN NUMBER
955 ,p_BP_RUN IN NUMBER -- Bug 13777759
956 ,p_BP_PTD IN NUMBER
957 ,p_BP_YTD IN NUMBER
958 ,p_CUR_PF_CMTD IN NUMBER
959 ,p_CUR_PF_CYTD IN NUMBER
960 ,p_CUR_PF_RUN IN NUMBER
961 ,p_CUR_PF_PTD IN NUMBER
962 ,p_CUR_PF_YTD IN NUMBER
963 ,p_CUR_RA_CMTD IN NUMBER
964 ,p_CUR_RA_CYTD IN NUMBER
965 ,p_CUR_RA_RUN IN NUMBER
966 ,p_CUR_RA_PTD IN NUMBER
967 ,p_CUR_RA_YTD IN NUMBER
968 ,p_DIR_DMD_RMN_ITD IN NUMBER
969 /*TYS2010*/
970 ,p_DONAT_MD_EE_CMTD IN NUMBER
971 ,p_DONAT_MD_EE_CYTD IN NUMBER
972 ,p_DONAT_MD_EE_RUN IN NUMBER
973 ,p_DONAT_MD_EE_PTD IN NUMBER
974 ,p_DONAT_MD_EE_YTD IN NUMBER
975 -- Bug 14168167
976 ,p_MED_AID_EMP_NRFI_ASG_RUN IN NUMBER
977 ,p_MED_AID_EMP_NRFI_ASG_TAX_PTD IN NUMBER
978 ,p_MED_AID_EMP_NRFI_ASG_TAX_YTD IN NUMBER
979 ,p_MED_AID_EMP_PKG_ASG_RUN IN NUMBER
980 ,p_MED_AID_EMP_PKG_ASG_TAX_PTD IN NUMBER
981 ,p_MED_AID_EMP_PKG_ASG_TAX_YTD IN NUMBER
982 ,p_MED_AID_EMP_RFI_ASG_RUN IN NUMBER
983 ,p_MED_AID_EMP_RFI_ASG_TAX_PTD IN NUMBER
984 ,p_MED_AID_EMP_RFI_ASG_TAX_YTD IN NUMBER
985 -- Bug 14168167
986 ) RETURN NUMBER;
987
988 -- Function to Initialise Globals - Balance Values
989 -- Third Section
990 FUNCTION ZaTxBal3_01032012(
991 -- Balances
992 p_EE_INC_PRO_POL_CMTD IN NUMBER
993 ,p_EE_INC_PRO_POL_CYTD IN NUMBER
994 ,p_EE_INC_PRO_POL_RUN IN NUMBER
995 ,p_EE_INC_PRO_POL_PTD IN NUMBER
996 ,p_EE_INC_PRO_POL_YTD IN NUMBER
997 ,p_EXC_ARR_PEN_ITD IN NUMBER
998 ,p_EXC_ARR_PEN_PTD IN NUMBER
999 ,p_EXC_ARR_PEN_YTD IN NUMBER
1000 ,p_EXC_ARR_RA_ITD IN NUMBER
1001 ,p_EXC_ARR_RA_PTD IN NUMBER
1002 ,p_EXC_ARR_RA_YTD IN NUMBER
1003 ,p_MED_CONTR_CMTD IN NUMBER
1004 ,p_MED_CONTR_CYTD IN NUMBER
1005 ,p_MED_CONTR_RUN IN NUMBER
1006 ,p_MED_CONTR_PTD IN NUMBER
1007 ,p_MED_CONTR_YTD IN NUMBER
1008 ,p_MED_CNTRB_ABM_CMTD IN NUMBER
1009 ,p_MED_CNTRB_ABM_CYTD IN NUMBER
1010 ,p_MED_CNTRB_ABM_RUN IN NUMBER
1011 ,p_MED_CNTRB_ABM_PTD IN NUMBER
1015 --EMP201
1012 ,p_MED_CNTRB_ABM_YTD IN NUMBER
1013 ,p_NET_PAY_RUN IN NUMBER
1014 ,p_NET_TXB_INC_CMTD IN NUMBER
1016 ,p_NET_PAYE_TXB_INC_CMTD IN NUMBER
1017 ,p_MED_AID_TAX_CR_CMTD IN NUMBER
1018 ,p_MED_AID_TAX_CR_CYTD IN NUMBER
1019 ,p_MED_AID_TAX_CR_RUN IN NUMBER
1020 ,p_MED_AID_TAX_CR_PTD IN NUMBER
1021 ,p_MED_AID_TAX_CR_YTD IN NUMBER
1022 ,p_ANN_MED_AID_TAX_CR_CMTD IN NUMBER
1023 ,p_ANN_MED_AID_TAX_CR_CYTD IN NUMBER
1024 ,p_ANN_MED_AID_TAX_CR_RUN IN NUMBER
1025 ,p_ANN_MED_AID_TAX_CR_PTD IN NUMBER
1026 ,p_ANN_MED_AID_TAX_CR_YTD IN NUMBER
1027 ,p_MED_AID_TAX_CR_USED_CMTD IN NUMBER
1028 ,p_MED_AID_TAX_CR_USED_CYTD IN NUMBER
1029 ,p_MED_AID_TAX_CR_USED_RUN IN NUMBER
1030 ,p_MED_AID_TAX_CR_USED_PTD IN NUMBER
1031 ,p_MED_AID_TAX_CR_USED_YTD IN NUMBER
1032 ,p_MED_AID_TAX_CR_USED_NI_CMTD IN NUMBER
1033 ,p_MED_AID_TAX_CR_USED_NI_CYTD IN NUMBER
1034 ,p_MED_AID_TAX_CR_USED_NI_RUN IN NUMBER
1035 ,p_MED_AID_TAX_CR_USED_NI_PTD IN NUMBER
1036 ,p_MED_AID_TAX_CR_USED_NI_YTD IN NUMBER
1037 ,p_MED_AID_TAX_CR_USED_FB_CMTD IN NUMBER
1038 ,p_MED_AID_TAX_CR_USED_FB_CYTD IN NUMBER
1039 ,p_MED_AID_TAX_CR_USED_FB_RUN IN NUMBER
1040 ,p_MED_AID_TAX_CR_USED_FB_PTD IN NUMBER
1041 ,p_MED_AID_TAX_CR_USED_FB_YTD IN NUMBER
1042 ,p_MED_AID_TAX_CR_USED_TA_CMTD IN NUMBER
1043 ,p_MED_AID_TAX_CR_USED_TA_CYTD IN NUMBER
1044 ,p_MED_AID_TAX_CR_USED_TA_RUN IN NUMBER
1045 ,p_MED_AID_TAX_CR_USED_TA_PTD IN NUMBER
1046 ,p_MED_AID_TAX_CR_USED_TA_YTD IN NUMBER
1047 ,p_MED_AID_TAX_CR_USED_BP_CMTD IN NUMBER
1048 ,p_MED_AID_TAX_CR_USED_BP_CYTD IN NUMBER
1049 ,p_MED_AID_TAX_CR_USED_BP_RUN IN NUMBER
1050 ,p_MED_AID_TAX_CR_USED_BP_PTD IN NUMBER
1051 ,p_MED_AID_TAX_CR_USED_BP_YTD IN NUMBER
1052 ,p_MED_AID_TAX_CR_USED_AB_CMTD IN NUMBER
1053 ,p_MED_AID_TAX_CR_USED_AB_CYTD IN NUMBER
1054 ,p_MED_AID_TAX_CR_USED_AB_RUN IN NUMBER
1055 ,p_MED_AID_TAX_CR_USED_AB_PTD IN NUMBER
1056 ,p_MED_AID_TAX_CR_USED_AB_YTD IN NUMBER
1057 ,p_MED_AID_TAX_CR_USED_AP_CMTD IN NUMBER
1058 ,p_MED_AID_TAX_CR_USED_AP_CYTD IN NUMBER
1059 ,p_MED_AID_TAX_CR_USED_AP_RUN IN NUMBER
1060 ,p_MED_AID_TAX_CR_USED_AP_PTD IN NUMBER
1061 ,p_MED_AID_TAX_CR_USED_AP_YTD IN NUMBER
1062 ,p_MED_AID_TAX_CR_USED_PO_CMTD IN NUMBER
1063 ,p_MED_AID_TAX_CR_USED_PO_CYTD IN NUMBER
1064 ,p_MED_AID_TAX_CR_USED_PO_RUN IN NUMBER
1065 ,p_MED_AID_TAX_CR_USED_PO_PTD IN NUMBER
1066 ,p_MED_AID_TAX_CR_USED_PO_YTD IN NUMBER
1067 -- Bug 13777759
1068 ,p_MED_AID_TAX_CR_USED_NG_CMTD IN NUMBER
1069 ,p_MED_AID_TAX_CR_USED_NG_CYTD IN NUMBER
1070 ,p_MED_AID_TAX_CR_USED_NG_RUN IN NUMBER
1071 ,p_MED_AID_TAX_CR_USED_NG_PTD IN NUMBER
1072 ,p_MED_AID_TAX_CR_USED_NG_YTD IN NUMBER
1073 ,p_MED_AID_TAX_CR_USED_EE_CMTD IN NUMBER
1074 ,p_MED_AID_TAX_CR_USED_EE_CYTD IN NUMBER
1075 ,p_MED_AID_TAX_CR_USED_EE_RUN IN NUMBER
1076 ,p_MED_AID_TAX_CR_USED_EE_PTD IN NUMBER
1077 ,p_MED_AID_TAX_CR_USED_EE_YTD IN NUMBER
1078 -- Bug 13777759
1079 ,p_ER_MED_CONTR_CMTD IN NUMBER
1080 ,p_ER_MED_CONTR_CYTD IN NUMBER
1081 ,p_ER_MED_CONTR_RUN IN NUMBER
1082 ,p_ER_MED_CONTR_PTD IN NUMBER
1083 ,p_ER_MED_CONTR_YTD IN NUMBER
1084 -- Bug 14024624
1085 ,p_MED_AID_TAX_CR_USED_DR_CMTD IN NUMBER
1086 ,p_MED_AID_TAX_CR_USED_DR_CYTD IN NUMBER
1087 ,p_MED_AID_TAX_CR_USED_DR_RUN IN NUMBER
1088 ,p_MED_AID_TAX_CR_USED_DR_PTD IN NUMBER
1089 ,p_MED_AID_TAX_CR_USED_DR_YTD IN NUMBER
1090 -- Bug 14024624
1091 ,p_MED_AID_TAX_CR_USED_LS_PTD IN NUMBER
1092 ,p_MED_AID_TAX_CR_USED_LS_YTD IN NUMBER
1093 ) RETURN NUMBER;
1094
1095 -- Function to Initialise Globals - Balance Values
1096 -- Fourth Section
1097 FUNCTION ZaTxBal4_01032012(
1098 -- Balances
1099 p_PAYE_YTD IN NUMBER
1100 ,p_SITE_YTD IN NUMBER
1101 ,p_TAX_YTD IN NUMBER
1102 ,p_TX_ON_AB_PTD IN NUMBER
1103 ,p_TX_ON_AB_YTD IN NUMBER
1104 ,p_TX_ON_AP_PTD IN NUMBER
1105 ,p_TX_ON_AP_YTD IN NUMBER
1106 ,p_TX_ON_BP_PTD IN NUMBER
1107 ,p_TX_ON_BP_YTD IN NUMBER
1108 ,p_TX_ON_TA_PTD IN NUMBER
1109 ,p_TX_ON_TA_YTD IN NUMBER
1110 ,p_TX_ON_DR_PTD IN NUMBER
1111 ,p_TX_ON_DR_YTD IN NUMBER
1112 ,p_TX_ON_FB_PTD IN NUMBER
1113 ,p_TX_ON_FB_YTD IN NUMBER
1114 ,p_TX_ON_NI_PTD IN NUMBER
1115 ,p_TX_ON_NI_YTD IN NUMBER
1116 ,p_TX_ON_PO_PTD IN NUMBER
1117 ,p_TX_ON_PO_YTD IN NUMBER
1118 ,p_TX_ON_LS_PTD IN NUMBER
1119 ,p_TX_ON_RET_LS_PTD IN NUMBER
1120 /* NTG */
1121 ,p_TX_ON_AP_NTG_PTD IN NUMBER
1122 ,p_TX_ON_AP_NTG_YTD IN NUMBER
1123 ,p_TX_ON_EE_DBT_NTG_PTD IN NUMBER
1124 ,p_TX_ON_EE_DBT_NTG_YTD IN NUMBER
1125 ,p_TX_ON_LS_RUN IN NUMBER
1126 ,p_TX_ON_LS_YTD IN NUMBER
1127 /* End NTG */
1128 ) RETURN NUMBER;
1129
1130 FUNCTION ZaTxBal5_01032012(
1131 -- Balances
1132 p_TOT_INC_PTD IN NUMBER
1133 ,p_TOT_INC_YTD IN NUMBER
1134 ,p_TOT_NRFI_AN_INC_CMTD IN NUMBER
1135 ,p_TOT_NRFI_AN_INC_CYTD IN NUMBER
1136 ,p_TOT_NRFI_AN_INC_RUN IN NUMBER
1137 ,p_TOT_NRFI_AN_INC_PTD IN NUMBER
1138 ,p_TOT_NRFI_AN_INC_YTD IN NUMBER
1139 ,p_TOT_NRFI_INC_CMTD IN NUMBER
1140 ,p_TOT_NRFI_INC_CYTD IN NUMBER
1141 ,p_TOT_NRFI_INC_RUN IN NUMBER
1142 ,p_TOT_NRFI_INC_PTD IN NUMBER
1146 ,p_TOT_RFI_AN_INC_RUN IN NUMBER
1143 ,p_TOT_NRFI_INC_YTD IN NUMBER
1144 ,p_TOT_RFI_AN_INC_CMTD IN NUMBER
1145 ,p_TOT_RFI_AN_INC_CYTD IN NUMBER
1147 ,p_TOT_RFI_AN_INC_PTD IN NUMBER
1148 ,p_TOT_RFI_AN_INC_YTD IN NUMBER
1149 ,p_TOT_RFI_INC_CMTD IN NUMBER
1150 ,p_TOT_RFI_INC_CYTD IN NUMBER
1151 ,p_TOT_RFI_INC_RUN IN NUMBER
1152 ,p_TOT_RFI_INC_PTD IN NUMBER
1153 ,p_TOT_RFI_INC_YTD IN NUMBER
1154 ,p_TOT_SEA_WRK_DYS_WRK_YTD IN NUMBER
1155 ,p_TOT_SKL_ANN_INC_CMTD IN NUMBER
1156 ,p_TOT_SKL_INC_CMTD IN NUMBER
1157 ,p_TOT_TXB_INC_ITD IN NUMBER
1158 --EMP201
1159 ,p_GROSS_REMUNERATION_CMTD IN NUMBER
1160 ,p_ANN_PAYMENTS_CMTD IN NUMBER
1161 --NTG
1162 ,p_TOT_RFI_EE_DBT_NTG_CMTD IN NUMBER
1163 ,p_TOT_RFI_EE_DBT_NTG_CYTD IN NUMBER
1164 ,p_TOT_RFI_EE_DBT_NTG_RUN IN NUMBER
1165 ,p_TOT_RFI_EE_DBT_NTG_PTD IN NUMBER
1166 ,p_TOT_RFI_EE_DBT_NTG_YTD IN NUMBER
1167 ,p_TOT_NRFI_EE_DBT_NTG_CMTD IN NUMBER
1168 ,p_TOT_NRFI_EE_DBT_NTG_CYTD IN NUMBER
1169 ,p_TOT_NRFI_EE_DBT_NTG_RUN IN NUMBER
1170 ,p_TOT_NRFI_EE_DBT_NTG_PTD IN NUMBER
1171 ,p_TOT_NRFI_EE_DBT_NTG_YTD IN NUMBER
1172 ,p_TOT_SKL_ANN_INC_NTG_CMTD IN NUMBER
1173 ) RETURN NUMBER;
1174
1175 FUNCTION ZaTxBal6_01032012(
1176 -- Balances
1177 p_TOT_TXB_AB_CMTD IN NUMBER
1178 ,p_TOT_TXB_AB_RUN IN NUMBER
1179 ,p_TOT_TXB_AB_PTD IN NUMBER
1180 ,p_TOT_TXB_AB_YTD IN NUMBER
1181 ,p_TOT_TXB_AP_CMTD IN NUMBER
1182 ,p_TOT_TXB_AP_RUN IN NUMBER
1183 ,p_TOT_TXB_AP_PTD IN NUMBER
1184 ,p_TOT_TXB_AP_YTD IN NUMBER
1185 ,p_TOT_TXB_FB_CMTD IN NUMBER
1186 ,p_TOT_TXB_FB_CYTD IN NUMBER
1187 ,p_TOT_TXB_FB_RUN IN NUMBER
1188 ,p_TOT_TXB_FB_PTD IN NUMBER
1189 ,p_TOT_TXB_FB_YTD IN NUMBER
1190 ,p_TOT_TXB_NI_CMTD IN NUMBER
1191 ,p_TOT_TXB_NI_CYTD IN NUMBER
1192 ,p_TOT_TXB_NI_RUN IN NUMBER
1193 ,p_TOT_TXB_NI_PTD IN NUMBER
1194 ,p_TOT_TXB_NI_YTD IN NUMBER
1195 ,p_TOT_TXB_PO_CMTD IN NUMBER
1196 ,p_TOT_TXB_PO_RUN IN NUMBER -- Bug 13777759
1197 ,p_TOT_TXB_PO_PTD IN NUMBER
1198 ,p_TOT_TXB_PO_YTD IN NUMBER
1199 ,p_TOT_TXB_TA_CMTD IN NUMBER
1200 ,p_TOT_TXB_TA_CYTD IN NUMBER
1201 ,p_TOT_TXB_TA_RUN IN NUMBER -- Bug 13777759
1202 ,p_TOT_TXB_TA_PTD IN NUMBER
1203 ,p_TOT_TXB_TA_YTD IN NUMBER
1204 /* NTG */
1205 ,p_TOT_TXB_AP_NTG_CMTD IN NUMBER
1206 ,p_TOT_TXB_AP_NTG_RUN IN NUMBER
1207 ,p_TOT_TXB_AP_NTG_PTD IN NUMBER
1208 ,p_TOT_TXB_AP_NTG_YTD IN NUMBER
1209 ,p_TOT_TXB_EE_DBT_NTG_CMTD IN NUMBER
1210 ,p_TOT_TXB_EE_DBT_NTG_RUN IN NUMBER
1211 ,p_TOT_TXB_EE_DBT_NTG_PTD IN NUMBER
1212 ,p_TOT_TXB_EE_DBT_NTG_YTD IN NUMBER
1213 /* End NTG */
1214 ) RETURN NUMBER;
1215
1216 -- Main Tax Function
1217 -- Called from Fast Formula
1218 FUNCTION ZaTx_01032012(
1219 /* PARAMETERS */
1220 -- Contexts
1221 ASSIGNMENT_ACTION_ID IN NUMBER
1222 ,ASSIGNMENT_ID IN NUMBER
1223 ,PAYROLL_ACTION_ID IN NUMBER
1224 ,PAYROLL_ID IN NUMBER
1225 -- Out Parameters
1226 , p_LibWrn OUT NOCOPY VARCHAR2
1227 , p_LibFpDR OUT NOCOPY NUMBER
1228 , p_LibFpNI OUT NOCOPY NUMBER
1229 , p_LibFpFB OUT NOCOPY NUMBER
1230 , p_LibFpTA OUT NOCOPY NUMBER
1231 , p_LibFpBP OUT NOCOPY NUMBER
1232 , p_LibFpAB OUT NOCOPY NUMBER
1233 , p_LibFpAP OUT NOCOPY NUMBER
1234 , p_LibFpPO OUT NOCOPY NUMBER
1235 , p_PayValSD OUT NOCOPY NUMBER
1236 , p_PayValEC OUT NOCOPY NUMBER
1237 , p_PayeVal OUT NOCOPY NUMBER
1238 , p_SiteVal OUT NOCOPY NUMBER
1239 , p_It3Ind OUT NOCOPY NUMBER
1240 , p_PfUpdFig OUT NOCOPY NUMBER
1241 , p_RaUpdFig OUT NOCOPY NUMBER
1242 , p_OUpdFig OUT NOCOPY NUMBER
1243 , p_NtiUpdFig OUT NOCOPY NUMBER
1244 , p_OvrWrn OUT NOCOPY VARCHAR2
1245 , p_LSDirNum OUT NOCOPY VARCHAR2
1246 , p_LSDirVal OUT NOCOPY NUMBER
1247 , p_RETLSDirNum OUT NOCOPY VARCHAR2
1248 , p_RETLSDirVal OUT NOCOPY NUMBER
1249 --EMP201
1250 , p_NPtiUpdFig OUT NOCOPY NUMBER
1251 -- NTG
1252 , p_LibFpNtgAP OUT NOCOPY NUMBER
1253 , p_LibFpNtgEEDbt OUT NOCOPY NUMBER
1254 , p_LibFpNtg OUT NOCOPY NUMBER
1255 -- End NTG
1256 , p_MedCrUsed OUT NOCOPY NUMBER
1257 , p_MedCrUsedNI OUT NOCOPY NUMBER
1258 , p_MedCrUsedFB OUT NOCOPY NUMBER
1259 , p_MedCrUsedTA OUT NOCOPY NUMBER
1260 , p_MedCrUsedBP OUT NOCOPY NUMBER
1261 , p_MedCrUsedAB OUT NOCOPY NUMBER
1262 , p_MedCrUsedAP OUT NOCOPY NUMBER
1263 , p_MedCrUsedPO OUT NOCOPY NUMBER
1264 , p_MedCrUsedNtgAP OUT NOCOPY NUMBER -- Bug 13777759
1265 , p_MedCrUsedNtgEEDbt OUT NOCOPY NUMBER -- Bug 13777759
1266 , p_MedCrUsedDR OUT NOCOPY NUMBER -- Bug 14024624
1267 , p_MedCrUsedLS OUT NOCOPY NUMBER
1268 )RETURN NUMBER;
1269
1270 FUNCTION ZaTxMedTxCrLmpSm1_01032012(
1271 p_MedCrUsedLS OUT NOCOPY NUMBER
1272 , p_DirNum1 OUT NOCOPY VARCHAR2
1273 , p_MedTxCrUsed1 OUT NOCOPY NUMBER
1274 , p_DirNum2 OUT NOCOPY VARCHAR2
1275 , p_MedTxCrUsed2 OUT NOCOPY NUMBER
1279 , p_MedTxCrUsed4 OUT NOCOPY NUMBER
1276 , p_DirNum3 OUT NOCOPY VARCHAR2
1277 , p_MedTxCrUsed3 OUT NOCOPY NUMBER
1278 , p_DirNum4 OUT NOCOPY VARCHAR2
1280 , p_DirNum5 OUT NOCOPY VARCHAR2
1281 , p_MedTxCrUsed5 OUT NOCOPY NUMBER
1282 , p_DirNum6 OUT NOCOPY VARCHAR2
1283 , p_MedTxCrUsed6 OUT NOCOPY NUMBER
1284 , p_DirNum7 OUT NOCOPY VARCHAR2
1285 , p_MedTxCrUsed7 OUT NOCOPY NUMBER
1286 , p_DirNum8 OUT NOCOPY VARCHAR2
1287 , p_MedTxCrUsed8 OUT NOCOPY NUMBER
1288 , p_DirNum9 OUT NOCOPY VARCHAR2
1289 , p_MedTxCrUsed9 OUT NOCOPY NUMBER
1290 , p_DirNum10 OUT NOCOPY VARCHAR2
1291 , p_MedTxCrUsed10 OUT NOCOPY NUMBER
1292 )RETURN NUMBER;
1293
1294 FUNCTION ZaTxMedTxCrLmpSm2_01032012(
1295 p_MedCrUsedLS OUT NOCOPY NUMBER
1296 , p_DirNum1 OUT NOCOPY VARCHAR2
1297 , p_MedTxCrUsed1 OUT NOCOPY NUMBER
1298 , p_DirNum2 OUT NOCOPY VARCHAR2
1299 , p_MedTxCrUsed2 OUT NOCOPY NUMBER
1300 , p_DirNum3 OUT NOCOPY VARCHAR2
1301 , p_MedTxCrUsed3 OUT NOCOPY NUMBER
1302 , p_DirNum4 OUT NOCOPY VARCHAR2
1303 , p_MedTxCrUsed4 OUT NOCOPY NUMBER
1304 , p_DirNum5 OUT NOCOPY VARCHAR2
1305 , p_MedTxCrUsed5 OUT NOCOPY NUMBER
1306 , p_DirNum6 OUT NOCOPY VARCHAR2
1307 , p_MedTxCrUsed6 OUT NOCOPY NUMBER
1308 , p_DirNum7 OUT NOCOPY VARCHAR2
1309 , p_MedTxCrUsed7 OUT NOCOPY NUMBER
1310 , p_DirNum8 OUT NOCOPY VARCHAR2
1311 , p_MedTxCrUsed8 OUT NOCOPY NUMBER
1312 , p_DirNum9 OUT NOCOPY VARCHAR2
1313 , p_MedTxCrUsed9 OUT NOCOPY NUMBER
1314 , p_DirNum10 OUT NOCOPY VARCHAR2
1315 , p_MedTxCrUsed10 OUT NOCOPY NUMBER
1316 )RETURN NUMBER;
1317
1318 FUNCTION ZaTxMedTxCrLmpSm3_01032012(
1319 p_MedCrUsedLS OUT NOCOPY NUMBER
1320 , p_DirNum1 OUT NOCOPY VARCHAR2
1321 , p_MedTxCrUsed1 OUT NOCOPY NUMBER
1322 , p_DirNum2 OUT NOCOPY VARCHAR2
1323 , p_MedTxCrUsed2 OUT NOCOPY NUMBER
1324 , p_DirNum3 OUT NOCOPY VARCHAR2
1325 , p_MedTxCrUsed3 OUT NOCOPY NUMBER
1326 , p_DirNum4 OUT NOCOPY VARCHAR2
1327 , p_MedTxCrUsed4 OUT NOCOPY NUMBER
1328 , p_DirNum5 OUT NOCOPY VARCHAR2
1329 , p_MedTxCrUsed5 OUT NOCOPY NUMBER
1330 , p_DirNum6 OUT NOCOPY VARCHAR2
1331 , p_MedTxCrUsed6 OUT NOCOPY NUMBER
1332 , p_DirNum7 OUT NOCOPY VARCHAR2
1333 , p_MedTxCrUsed7 OUT NOCOPY NUMBER
1334 , p_DirNum8 OUT NOCOPY VARCHAR2
1335 , p_MedTxCrUsed8 OUT NOCOPY NUMBER
1336 , p_DirNum9 OUT NOCOPY VARCHAR2
1337 , p_MedTxCrUsed9 OUT NOCOPY NUMBER
1338 , p_DirNum10 OUT NOCOPY VARCHAR2
1339 , p_MedTxCrUsed10 OUT NOCOPY NUMBER
1340 )RETURN NUMBER;
1341
1342 FUNCTION ZaTxMedTxCrLmpSm4_01032012(
1343 p_MedCrUsedLS OUT NOCOPY NUMBER
1344 , p_DirNum1 OUT NOCOPY VARCHAR2
1345 , p_MedTxCrUsed1 OUT NOCOPY NUMBER
1346 , p_DirNum2 OUT NOCOPY VARCHAR2
1347 , p_MedTxCrUsed2 OUT NOCOPY NUMBER
1348 , p_DirNum3 OUT NOCOPY VARCHAR2
1349 , p_MedTxCrUsed3 OUT NOCOPY NUMBER
1350 , p_DirNum4 OUT NOCOPY VARCHAR2
1351 , p_MedTxCrUsed4 OUT NOCOPY NUMBER
1352 , p_DirNum5 OUT NOCOPY VARCHAR2
1353 , p_MedTxCrUsed5 OUT NOCOPY NUMBER
1354 , p_DirNum6 OUT NOCOPY VARCHAR2
1355 , p_MedTxCrUsed6 OUT NOCOPY NUMBER
1356 , p_DirNum7 OUT NOCOPY VARCHAR2
1357 , p_MedTxCrUsed7 OUT NOCOPY NUMBER
1358 , p_DirNum8 OUT NOCOPY VARCHAR2
1359 , p_MedTxCrUsed8 OUT NOCOPY NUMBER
1360 , p_DirNum9 OUT NOCOPY VARCHAR2
1361 , p_MedTxCrUsed9 OUT NOCOPY NUMBER
1362 , p_DirNum10 OUT NOCOPY VARCHAR2
1363 , p_MedTxCrUsed10 OUT NOCOPY NUMBER
1364 )RETURN NUMBER;
1365
1366 FUNCTION ZaTxMedTxCrLmpSm5_01032012(
1367 p_MedCrUsedLS OUT NOCOPY NUMBER
1368 , p_DirNum1 OUT NOCOPY VARCHAR2
1369 , p_MedTxCrUsed1 OUT NOCOPY NUMBER
1370 , p_DirNum2 OUT NOCOPY VARCHAR2
1371 , p_MedTxCrUsed2 OUT NOCOPY NUMBER
1372 , p_DirNum3 OUT NOCOPY VARCHAR2
1373 , p_MedTxCrUsed3 OUT NOCOPY NUMBER
1374 , p_DirNum4 OUT NOCOPY VARCHAR2
1375 , p_MedTxCrUsed4 OUT NOCOPY NUMBER
1376 , p_DirNum5 OUT NOCOPY VARCHAR2
1377 , p_MedTxCrUsed5 OUT NOCOPY NUMBER
1378 , p_DirNum6 OUT NOCOPY VARCHAR2
1379 , p_MedTxCrUsed6 OUT NOCOPY NUMBER
1380 , p_DirNum7 OUT NOCOPY VARCHAR2
1381 , p_MedTxCrUsed7 OUT NOCOPY NUMBER
1382 , p_DirNum8 OUT NOCOPY VARCHAR2
1383 , p_MedTxCrUsed8 OUT NOCOPY NUMBER
1384 , p_DirNum9 OUT NOCOPY VARCHAR2
1385 , p_MedTxCrUsed9 OUT NOCOPY NUMBER
1386 , p_DirNum10 OUT NOCOPY VARCHAR2
1387 , p_MedTxCrUsed10 OUT NOCOPY NUMBER
1388 )RETURN NUMBER;
1389
1390 FUNCTION ZaTxMedTxCrLmpSm6_01032012(
1391 p_MedCrUsedLS OUT NOCOPY NUMBER
1392 , p_DirNum1 OUT NOCOPY VARCHAR2
1393 , p_MedTxCrUsed1 OUT NOCOPY NUMBER
1394 , p_DirNum2 OUT NOCOPY VARCHAR2
1395 , p_MedTxCrUsed2 OUT NOCOPY NUMBER
1396 , p_DirNum3 OUT NOCOPY VARCHAR2
1397 , p_MedTxCrUsed3 OUT NOCOPY NUMBER
1398 , p_DirNum4 OUT NOCOPY VARCHAR2
1399 , p_MedTxCrUsed4 OUT NOCOPY NUMBER
1400 , p_DirNum5 OUT NOCOPY VARCHAR2
1401 , p_MedTxCrUsed5 OUT NOCOPY NUMBER
1402 , p_DirNum6 OUT NOCOPY VARCHAR2
1403 , p_MedTxCrUsed6 OUT NOCOPY NUMBER
1404 , p_DirNum7 OUT NOCOPY VARCHAR2
1405 , p_MedTxCrUsed7 OUT NOCOPY NUMBER
1406 , p_DirNum8 OUT NOCOPY VARCHAR2
1407 , p_MedTxCrUsed8 OUT NOCOPY NUMBER
1408 , p_DirNum9 OUT NOCOPY VARCHAR2
1409 , p_MedTxCrUsed9 OUT NOCOPY NUMBER
1410 , p_DirNum10 OUT NOCOPY VARCHAR2
1411 , p_MedTxCrUsed10 OUT NOCOPY NUMBER
1412 )RETURN NUMBER;
1413
1414 FUNCTION ZaTxMedTxCrLmpSm7_01032012(
1415 p_MedCrUsedLS OUT NOCOPY NUMBER
1416 , p_DirNum1 OUT NOCOPY VARCHAR2
1417 , p_MedTxCrUsed1 OUT NOCOPY NUMBER
1418 , p_DirNum2 OUT NOCOPY VARCHAR2
1419 , p_MedTxCrUsed2 OUT NOCOPY NUMBER
1420 , p_DirNum3 OUT NOCOPY VARCHAR2
1421 , p_MedTxCrUsed3 OUT NOCOPY NUMBER
1422 , p_DirNum4 OUT NOCOPY VARCHAR2
1423 , p_MedTxCrUsed4 OUT NOCOPY NUMBER
1424 , p_DirNum5 OUT NOCOPY VARCHAR2
1425 , p_MedTxCrUsed5 OUT NOCOPY NUMBER
1426 , p_DirNum6 OUT NOCOPY VARCHAR2
1427 , p_MedTxCrUsed6 OUT NOCOPY NUMBER
1428 , p_DirNum7 OUT NOCOPY VARCHAR2
1429 , p_MedTxCrUsed7 OUT NOCOPY NUMBER
1430 , p_DirNum8 OUT NOCOPY VARCHAR2
1431 , p_MedTxCrUsed8 OUT NOCOPY NUMBER
1432 , p_DirNum9 OUT NOCOPY VARCHAR2
1433 , p_MedTxCrUsed9 OUT NOCOPY NUMBER
1434 , p_DirNum10 OUT NOCOPY VARCHAR2
1435 , p_MedTxCrUsed10 OUT NOCOPY NUMBER
1436 )RETURN NUMBER;
1437
1438 FUNCTION ZaTxMedTxCrLmpSm8_01032012(
1439 p_MedCrUsedLS OUT NOCOPY NUMBER
1440 , p_DirNum1 OUT NOCOPY VARCHAR2
1441 , p_MedTxCrUsed1 OUT NOCOPY NUMBER
1442 , p_DirNum2 OUT NOCOPY VARCHAR2
1443 , p_MedTxCrUsed2 OUT NOCOPY NUMBER
1444 , p_DirNum3 OUT NOCOPY VARCHAR2
1445 , p_MedTxCrUsed3 OUT NOCOPY NUMBER
1446 , p_DirNum4 OUT NOCOPY VARCHAR2
1447 , p_MedTxCrUsed4 OUT NOCOPY NUMBER
1448 , p_DirNum5 OUT NOCOPY VARCHAR2
1449 , p_MedTxCrUsed5 OUT NOCOPY NUMBER
1450 , p_DirNum6 OUT NOCOPY VARCHAR2
1451 , p_MedTxCrUsed6 OUT NOCOPY NUMBER
1452 , p_DirNum7 OUT NOCOPY VARCHAR2
1453 , p_MedTxCrUsed7 OUT NOCOPY NUMBER
1454 , p_DirNum8 OUT NOCOPY VARCHAR2
1455 , p_MedTxCrUsed8 OUT NOCOPY NUMBER
1456 , p_DirNum9 OUT NOCOPY VARCHAR2
1457 , p_MedTxCrUsed9 OUT NOCOPY NUMBER
1458 , p_DirNum10 OUT NOCOPY VARCHAR2
1459 , p_MedTxCrUsed10 OUT NOCOPY NUMBER
1460 )RETURN NUMBER;
1461
1462 FUNCTION ZaTxMedTxCrLmpSm9_01032012(
1463 p_MedCrUsedLS OUT NOCOPY NUMBER
1464 , p_DirNum1 OUT NOCOPY VARCHAR2
1465 , p_MedTxCrUsed1 OUT NOCOPY NUMBER
1466 , p_DirNum2 OUT NOCOPY VARCHAR2
1467 , p_MedTxCrUsed2 OUT NOCOPY NUMBER
1468 , p_DirNum3 OUT NOCOPY VARCHAR2
1469 , p_MedTxCrUsed3 OUT NOCOPY NUMBER
1470 , p_DirNum4 OUT NOCOPY VARCHAR2
1471 , p_MedTxCrUsed4 OUT NOCOPY NUMBER
1472 , p_DirNum5 OUT NOCOPY VARCHAR2
1473 , p_MedTxCrUsed5 OUT NOCOPY NUMBER
1474 , p_DirNum6 OUT NOCOPY VARCHAR2
1475 , p_MedTxCrUsed6 OUT NOCOPY NUMBER
1476 , p_DirNum7 OUT NOCOPY VARCHAR2
1477 , p_MedTxCrUsed7 OUT NOCOPY NUMBER
1478 , p_DirNum8 OUT NOCOPY VARCHAR2
1479 , p_MedTxCrUsed8 OUT NOCOPY NUMBER
1480 , p_DirNum9 OUT NOCOPY VARCHAR2
1481 , p_MedTxCrUsed9 OUT NOCOPY NUMBER
1482 , p_DirNum10 OUT NOCOPY VARCHAR2
1483 , p_MedTxCrUsed10 OUT NOCOPY NUMBER
1484 )RETURN NUMBER;
1485
1486 FUNCTION ZaTxMedTxCrLmpSm10_01032012(
1487 p_MedCrUsedLS OUT NOCOPY NUMBER
1488 , p_DirNum1 OUT NOCOPY VARCHAR2
1489 , p_MedTxCrUsed1 OUT NOCOPY NUMBER
1490 , p_DirNum2 OUT NOCOPY VARCHAR2
1491 , p_MedTxCrUsed2 OUT NOCOPY NUMBER
1492 , p_DirNum3 OUT NOCOPY VARCHAR2
1493 , p_MedTxCrUsed3 OUT NOCOPY NUMBER
1494 , p_DirNum4 OUT NOCOPY VARCHAR2
1495 , p_MedTxCrUsed4 OUT NOCOPY NUMBER
1496 , p_DirNum5 OUT NOCOPY VARCHAR2
1497 , p_MedTxCrUsed5 OUT NOCOPY NUMBER
1498 , p_DirNum6 OUT NOCOPY VARCHAR2
1499 , p_MedTxCrUsed6 OUT NOCOPY NUMBER
1500 , p_DirNum7 OUT NOCOPY VARCHAR2
1501 , p_MedTxCrUsed7 OUT NOCOPY NUMBER
1502 , p_DirNum8 OUT NOCOPY VARCHAR2
1503 , p_MedTxCrUsed8 OUT NOCOPY NUMBER
1504 , p_DirNum9 OUT NOCOPY VARCHAR2
1505 , p_MedTxCrUsed9 OUT NOCOPY NUMBER
1506 , p_DirNum10 OUT NOCOPY VARCHAR2
1507 , p_MedTxCrUsed10 OUT NOCOPY NUMBER
1508 )RETURN NUMBER;
1509
1510
1511
1512
1513 END py_za_tx_01032012;
[Home] [Help]