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