1 PACKAGE py_za_tx_01032005 AUTHID CURRENT_USER AS
2 /* $Header: pyzat006.pkh 120.3 2005/08/26 01:59:09 jlouw noship $ */
3 /* Copyright (c) Oracle Corporation 2000. All rights reserved. */
4 /*
5 PRODUCT
6 Oracle Payroll - ZA Localisation Tax Module
7 NAME
8 py_za_tx_01032005.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_01032005
17 This function is called from Oracle Applications Fast Formula.
18 It passes all necessary global values to the main tax package.
19 ZaTxDbi_01032005
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_01032005
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_01032005
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_01032005
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_01032005
33 This function is called from Oracle Applications Fast Formula.
34 This is the main tax function from where all necessary
35 validation and calculations are done. The function will
36 calculate the tax liabilities of the employee assignment
37 and pass it back to the calling formula.
38
39 PRIVATE FUNCTIONS
40 <none>
41 NOTES
42 .
43
44 MODIFICATION HISTORY
45 Person Date(DD/MM/YYYY) Version Bug Comments
46 ------------ ---------------- ------- ------- -----------------------------
47 J.N. Louw 24/08/2005 115.7 4566053 Updated
48 J.N. Louw 17/08/2005 115.6 4346920 Updated
49 R.V.Pahune 04/07/2005 115.5 4346920 Package Structure
50 J.N. Louw 05/04/2005 115.4 4032647
51 R.V. Pahune 31/03/2005 115.3 4276047
52 J.N. Louw 02/02/2005 115.2 4159844
53 J.N. Louw 06/01/2005 115.1 4106326
54 J.N. Louw 22/12/2004 115.0 Next Version of Main ZA Tax
55 Package.
56 For detail history see
57 py_za_tx_01032004
58 */
59 -------------------------------------------------------------------------------
60 -- PACKAGE GLOBAL AREA --
61 -------------------------------------------------------------------------------
62 -- Types
63 -------------------------------------------------------------------------------
64 SUBTYPE BALANCE IS py_za_tx_utl_01032005.t_balance;
65 -------------------------------------------------------------------------------
66 -- Application Contexts
67 -------------------------------------------------------------------------------
68 con_ASG_ACT_ID NUMBER;
69 con_ASG_ID NUMBER;
70 con_PRL_ACT_ID NUMBER;
71 con_PRL_ID NUMBER;
72 -------------------------------------------------------------------------------
73 -- Application Global Values
74 -------------------------------------------------------------------------------
75 glb_ZA_ADL_TX_RBT NUMBER;
76 glb_ZA_ARR_PF_AN_MX_ABT NUMBER;
77 glb_ZA_ARR_RA_AN_MX_ABT NUMBER;
78 glb_ZA_TRV_ALL_TX_PRC NUMBER;
79 glb_ZA_CC_TX_PRC NUMBER;
80 glb_ZA_PF_AN_MX_ABT NUMBER;
81 glb_ZA_PF_MX_PRC NUMBER;
82 glb_ZA_PER_SERV_COMP_PERC NUMBER;
83 glb_ZA_PER_SERV_TRST_PERC NUMBER;
84 glb_ZA_PRI_TX_RBT NUMBER;
85 glb_ZA_PRI_TX_THRSHLD NUMBER;
86 glb_ZA_PBL_TX_PRC NUMBER;
87 glb_ZA_PBL_TX_RTE NUMBER;
88 glb_ZA_RA_AN_MX_ABT NUMBER;
89 glb_ZA_RA_MX_PRC NUMBER;
90 glb_ZA_SC_TX_THRSHLD NUMBER;
91 glb_ZA_SIT_LIM NUMBER;
92 glb_ZA_TMP_TX_RTE NUMBER;
93 glb_ZA_WRK_DYS_PR_YR NUMBER;
94 -------------------------------------------------------------------------------
95 -- Application Database Items
96 -------------------------------------------------------------------------------
97 dbi_BP_TX_RCV VARCHAR2(1);
98 dbi_PAY_PROC_PRD_DTE_PD DATE;
99 dbi_PER_AGE NUMBER;
100 dbi_PER_DTE_OF_BRTH DATE;
101 dbi_SEA_WRK_DYS_WRK NUMBER;
102 dbi_SES_DTE DATE;
103 dbi_TX_DIR_NUM VARCHAR2(60);
104 dbi_TX_DIR_VAL NUMBER DEFAULT 25;
105 dbi_TX_STA VARCHAR2(1);
106 dbi_ZA_ACT_END_DTE DATE;
107 dbi_ZA_ACT_STRT_DTE DATE;
108 dbi_ZA_ASG_TX_RTR_PRD VARCHAR2(1);
109 dbi_ZA_ASG_TAX_RTR_RSLTS VARCHAR2(1);
110 dbi_ZA_ASG_TX_YR NUMBER(4);
111 dbi_ZA_ASG_TX_YR_END DATE;
112 dbi_ZA_ASG_TX_YR_STRT DATE;
113 dbi_ZA_CUR_PRD_END_DTE DATE;
114 dbi_ZA_CUR_PRD_STRT_DTE DATE;
115 dbi_ZA_DYS_IN_YR NUMBER;
116 dbi_ZA_PAY_PRDS_LFT NUMBER;
117 dbi_ZA_PAY_PRDS_PER_YR NUMBER;
118 dbi_ZA_TX_YR_END DATE;
119 dbi_ZA_TX_YR_STRT DATE;
120 dbi_ZA_LS_DIR_NUM VARCHAR2(13);
121 dbi_ZA_LS_DIR_VAL NUMBER;
122 -------------------------------------------------------------------------------
123 -- Balances
124 -------------------------------------------------------------------------------
125 bal_ANN_ARR_PF_CMTD BALANCE;
126 bal_ANN_ARR_PF_CYTD BALANCE;
127 bal_ANN_ARR_PF_RUN BALANCE;
128 bal_ANN_ARR_PF_PTD BALANCE;
129 bal_ANN_ARR_PF_YTD BALANCE;
130 bal_ANN_ARR_RA_CMTD BALANCE;
131 bal_ANN_ARR_RA_CYTD BALANCE;
132 bal_ANN_ARR_RA_RUN BALANCE;
133 bal_ANN_ARR_RA_PTD BALANCE;
134 bal_ANN_ARR_RA_YTD BALANCE;
135 bal_ANN_EE_INC_PRO_POL_CMTD BALANCE;
136 bal_ANN_EE_INC_PRO_POL_CYTD BALANCE;
137 bal_ANN_EE_INC_PRO_POL_RUN BALANCE;
138 bal_ANN_EE_INC_PRO_POL_PTD BALANCE;
139 bal_ANN_EE_INC_PRO_POL_YTD BALANCE;
140 bal_ANN_PF_CMTD BALANCE;
141 bal_ANN_PF_CYTD BALANCE;
142 bal_ANN_PF_RUN BALANCE;
143 bal_ANN_PF_PTD BALANCE;
144 bal_ANN_PF_YTD BALANCE;
145 bal_ANN_RA_CMTD BALANCE;
146 bal_ANN_RA_CYTD BALANCE;
147 bal_ANN_RA_RUN BALANCE;
148 bal_ANN_RA_PTD BALANCE;
149 bal_ANN_RA_YTD BALANCE;
150 bal_ARR_PF_CMTD BALANCE;
151 bal_ARR_PF_CYTD BALANCE;
152 bal_ARR_PF_PTD BALANCE;
153 bal_ARR_PF_YTD BALANCE;
154 bal_ARR_RA_CMTD BALANCE;
155 bal_ARR_RA_CYTD BALANCE;
156 bal_ARR_RA_PTD BALANCE;
157 bal_ARR_RA_YTD BALANCE;
158 bal_BP_CMTD BALANCE;
159 bal_BP_PTD BALANCE;
160 bal_BP_YTD BALANCE;
161 bal_CUR_PF_CMTD BALANCE;
162 bal_CUR_PF_CYTD BALANCE;
163 bal_CUR_PF_RUN BALANCE;
164 bal_CUR_PF_PTD BALANCE;
165 bal_CUR_PF_YTD BALANCE;
166 bal_CUR_RA_CMTD BALANCE;
167 bal_CUR_RA_CYTD BALANCE;
168 bal_CUR_RA_RUN BALANCE;
169 bal_CUR_RA_PTD BALANCE;
170 bal_CUR_RA_YTD BALANCE;
171 bal_DIR_DMD_RMN_ITD BALANCE;
172 bal_EE_INC_PRO_POL_CMTD BALANCE;
173 bal_EE_INC_PRO_POL_CYTD BALANCE;
174 bal_EE_INC_PRO_POL_RUN BALANCE;
175 bal_EE_INC_PRO_POL_PTD BALANCE;
176 bal_EE_INC_PRO_POL_YTD BALANCE;
177 bal_EXC_ARR_PEN_ITD BALANCE;
178 bal_EXC_ARR_PEN_PTD BALANCE;
179 bal_EXC_ARR_PEN_YTD BALANCE;
180 bal_EXC_ARR_RA_ITD BALANCE;
181 bal_EXC_ARR_RA_PTD BALANCE;
182 bal_EXC_ARR_RA_YTD BALANCE;
183 bal_MED_CONTR_CMTD BALANCE;
184 bal_MED_CONTR_CYTD BALANCE;
185 bal_MED_CONTR_RUN BALANCE;
186 bal_MED_CONTR_PTD BALANCE;
187 bal_MED_CONTR_YTD BALANCE;
188 bal_NET_PAY_RUN BALANCE;
189 bal_NET_TXB_INC_CMTD BALANCE;
190 bal_PAYE_YTD BALANCE;
191 bal_SITE_YTD BALANCE;
192 bal_TAX_YTD BALANCE;
193 bal_TX_ON_AB_PTD BALANCE;
194 bal_TX_ON_AB_YTD BALANCE;
195 bal_TX_ON_AP_PTD BALANCE;
196 bal_TX_ON_AP_YTD BALANCE;
197 bal_TX_ON_BP_PTD BALANCE;
198 bal_TX_ON_BP_YTD BALANCE;
199 bal_TX_ON_TA_PTD BALANCE;
200 bal_TX_ON_TA_YTD BALANCE;
201 bal_TX_ON_DR_PTD BALANCE;
202 bal_TX_ON_DR_YTD BALANCE;
203 bal_TX_ON_FB_PTD BALANCE;
204 bal_TX_ON_FB_YTD BALANCE;
205 bal_TX_ON_NI_PTD BALANCE;
206 bal_TX_ON_NI_YTD BALANCE;
207 bal_TX_ON_PO_PTD BALANCE;
208 bal_TX_ON_PO_YTD BALANCE;
209 bal_TOT_INC_PTD BALANCE;
210 bal_TOT_INC_YTD BALANCE;
211 bal_TOT_NRFI_AN_INC_CMTD BALANCE;
212 bal_TOT_NRFI_AN_INC_CYTD BALANCE;
213 bal_TOT_NRFI_AN_INC_RUN BALANCE;
214 bal_TOT_NRFI_AN_INC_PTD BALANCE;
215 bal_TOT_NRFI_AN_INC_YTD BALANCE;
216 bal_TOT_NRFI_INC_CMTD BALANCE;
217 bal_TOT_NRFI_INC_CYTD BALANCE;
218 bal_TOT_NRFI_INC_RUN BALANCE;
219 bal_TOT_NRFI_INC_PTD BALANCE;
220 bal_TOT_NRFI_INC_YTD BALANCE;
221 bal_TOT_RFI_AN_INC_CMTD BALANCE;
222 bal_TOT_RFI_AN_INC_CYTD BALANCE;
223 bal_TOT_RFI_AN_INC_RUN BALANCE;
224 bal_TOT_RFI_AN_INC_PTD BALANCE;
225 bal_TOT_RFI_AN_INC_YTD BALANCE;
226 bal_TOT_RFI_INC_CMTD BALANCE;
227 bal_TOT_RFI_INC_CYTD BALANCE;
228 bal_TOT_RFI_INC_RUN BALANCE;
229 bal_TOT_RFI_INC_PTD BALANCE;
230 bal_TOT_RFI_INC_YTD BALANCE;
231 bal_TOT_SEA_WRK_DYS_WRK_YTD BALANCE;
232 bal_TOT_SKL_ANN_INC_CMTD BALANCE;
233 bal_TOT_SKL_INC_CMTD BALANCE;
234 bal_TOT_TXB_INC_ITD BALANCE;
235 bal_TOT_TXB_AB_CMTD BALANCE;
236 bal_TOT_TXB_AB_RUN BALANCE;
237 bal_TOT_TXB_AB_PTD BALANCE;
238 bal_TOT_TXB_AB_YTD BALANCE;
239 bal_TOT_TXB_AP_CMTD BALANCE;
240 bal_TOT_TXB_AP_RUN BALANCE;
241 bal_TOT_TXB_AP_PTD BALANCE;
242 bal_TOT_TXB_AP_YTD BALANCE;
243 bal_TOT_TXB_FB_CMTD BALANCE;
244 bal_TOT_TXB_FB_CYTD BALANCE;
245 bal_TOT_TXB_FB_RUN BALANCE;
246 bal_TOT_TXB_FB_PTD BALANCE;
247 bal_TOT_TXB_FB_YTD BALANCE;
248 bal_TOT_TXB_NI_CMTD BALANCE;
249 bal_TOT_TXB_NI_CYTD BALANCE;
250 bal_TOT_TXB_NI_RUN BALANCE;
251 bal_TOT_TXB_NI_PTD BALANCE;
252 bal_TOT_TXB_NI_YTD BALANCE;
253 bal_TOT_TXB_PO_CMTD BALANCE;
254 bal_TOT_TXB_PO_PTD BALANCE;
255 bal_TOT_TXB_PO_YTD BALANCE;
256 bal_TOT_TXB_TA_CMTD BALANCE;
257 bal_TOT_TXB_TA_CYTD BALANCE;
258 bal_TOT_TXB_TA_PTD BALANCE;
259 bal_TOT_TXB_TA_YTD BALANCE;
260
261 -------------------------------------------------------------------------------
262 -- Trace Globals
263 -------------------------------------------------------------------------------
264
265 -- These are set within the procedures and function calls!!
266 -- Values can be output by the main function call from formula
267 --
268 -- Calculation Type
269 trc_CalTyp VARCHAR2(7) DEFAULT 'Unknown';
270 -- Factors
271 trc_TxbIncPtd BALANCE DEFAULT 0;
272 trc_PrdFactor NUMBER DEFAULT 0;
273 trc_PosFactor NUMBER DEFAULT 0;
274 trc_SitFactor NUMBER DEFAULT 1;
275 -- Deemed Remuneration
276 trc_DmdRmnRun BALANCE DEFAULT 0;
277 trc_TxbDmdRmn BALANCE DEFAULT 0;
278 trc_TotLibDR BALANCE DEFAULT 0;
279 trc_LibFyDR BALANCE DEFAULT 0;
280 trc_LibFpDR BALANCE DEFAULT 0;
281 -- Base Income
282 trc_BseErn BALANCE DEFAULT 0;
283 trc_TxbBseInc BALANCE DEFAULT 0;
284 trc_TotLibBse BALANCE DEFAULT 0;
285 -- Period Pension Fund
286 trc_TxbIncYtd BALANCE DEFAULT 0;
287 trc_PerTxbInc BALANCE DEFAULT 0;
288 trc_PerPenFnd BALANCE DEFAULT 0;
289 trc_PerRfiCon BALANCE DEFAULT 0;
290 trc_PerRfiTxb BALANCE DEFAULT 0;
291 trc_PerPenFndMax BALANCE DEFAULT 0;
292 trc_PerPenFndAbm BALANCE DEFAULT 0;
293 -- Annual Pension Fund
294 trc_AnnTxbInc BALANCE DEFAULT 0;
295 trc_AnnPenFnd BALANCE DEFAULT 0;
296 trc_AnnRfiCon BALANCE DEFAULT 0;
297 trc_AnnRfiTxb BALANCE DEFAULT 0;
298 trc_AnnPenFndMax BALANCE DEFAULT 0;
299 trc_AnnPenFndAbm BALANCE DEFAULT 0;
300 -- Period Arrear Pension
301 trc_PerArrPenFnd BALANCE DEFAULT 0;
302 trc_PerArrPenFndAbm BALANCE DEFAULT 0;
303 -- Annual Arrear Pension
304 trc_AnnArrPenFnd BALANCE DEFAULT 0;
305 trc_AnnArrPenFndAbm BALANCE DEFAULT 0;
306 -- Arrear Excess Update Value
307 trc_PfUpdFig BALANCE DEFAULT 0;
308 -- Period Retirement Annuity
309 trc_PerRetAnu BALANCE DEFAULT 0;
310 trc_PerNrfiCon BALANCE DEFAULT 0;
311 trc_PerRetAnuMax BALANCE DEFAULT 0;
312 trc_PerRetAnuAbm BALANCE DEFAULT 0;
313 -- Annual Retirement Annuity
314 trc_AnnRetAnu BALANCE DEFAULT 0;
315 trc_AnnNrfiCon BALANCE DEFAULT 0;
316 trc_AnnRetAnuMax BALANCE DEFAULT 0;
317 trc_AnnRetAnuAbm BALANCE DEFAULT 0;
318 -- Period Arrear Retirement Annuity
319 trc_PerArrRetAnu BALANCE DEFAULT 0;
320 trc_PerArrRetAnuAbm BALANCE DEFAULT 0;
321 -- Annual Arrear Retirement Annuity
322 trc_AnnArrRetAnu BALANCE DEFAULT 0;
323 trc_AnnArrRetAnuAbm BALANCE DEFAULT 0;
324 -- Arrear Excess Update Value
325 trc_RaUpdFig BALANCE DEFAULT 0;
326 -- Rebates Thresholds and Med Aid
327 trc_Rebate BALANCE DEFAULT 0;
328 trc_Threshold BALANCE DEFAULT 0;
329 trc_MedAidAbm BALANCE DEFAULT 0;
330 -- Income Protection Policy
331 trc_PerIncProPolAbm BALANCE DEFAULT 0;
332 trc_AnnIncProPolAbm BALANCE DEFAULT 0;
333 -- Abatement Totals
334 trc_PerTotAbm BALANCE DEFAULT 0;
338 trc_NorIncPtd BALANCE DEFAULT 0;
335 trc_AnnTotAbm BALANCE DEFAULT 0;
336 -- Normal Income
337 trc_NorIncYtd BALANCE DEFAULT 0;
339 trc_NorErn BALANCE DEFAULT 0;
340 trc_TxbNorInc BALANCE DEFAULT 0;
341 trc_TotLibNI BALANCE DEFAULT 0;
342 trc_LibFyNI BALANCE DEFAULT 0;
343 trc_LibFpNI BALANCE DEFAULT 0;
344 -- Fringe Benefits
345 trc_FrnBenYtd BALANCE DEFAULT 0;
346 trc_FrnBenPtd BALANCE DEFAULT 0;
347 trc_FrnBenErn BALANCE DEFAULT 0;
348 trc_TxbFrnInc BALANCE DEFAULT 0;
349 trc_TotLibFB BALANCE DEFAULT 0;
350 trc_LibFyFB BALANCE DEFAULT 0;
351 trc_LibFpFB BALANCE DEFAULT 0;
352 -- Travel Allowance
353 trc_TrvAllYtd BALANCE DEFAULT 0;
354 trc_TrvAllPtd BALANCE DEFAULT 0;
355 trc_TrvAllErn BALANCE DEFAULT 0;
356 trc_TxbTrvInc BALANCE DEFAULT 0;
357 trc_TotLibTA BALANCE DEFAULT 0;
358 trc_LibFyTA BALANCE DEFAULT 0;
359 trc_LibFpTA BALANCE DEFAULT 0;
360 -- Bonus Provision
361 trc_BonProYtd BALANCE DEFAULT 0;
362 trc_BonProPtd BALANCE DEFAULT 0;
363 trc_BonProErn BALANCE DEFAULT 0;
364 trc_TxbBonProInc BALANCE DEFAULT 0;
365 trc_TotLibBP BALANCE DEFAULT 0;
366 trc_LibFyBP BALANCE DEFAULT 0;
367 trc_LibFpBP BALANCE DEFAULT 0;
368 -- Annual Bonus
369 trc_AnnBonYtd BALANCE DEFAULT 0;
370 trc_AnnBonPtd BALANCE DEFAULT 0;
371 trc_AnnBonErn BALANCE DEFAULT 0;
372 trc_TxbAnnBonInc BALANCE DEFAULT 0;
373 trc_TotLibAB BALANCE DEFAULT 0;
374 trc_LibFyAB BALANCE DEFAULT 0;
375 trc_LibFpAB BALANCE DEFAULT 0;
376 -- Annual Payments
377 trc_AnnPymYtd BALANCE DEFAULT 0;
378 trc_AnnPymPtd BALANCE DEFAULT 0;
379 trc_AnnPymErn BALANCE DEFAULT 0;
380 trc_TxbAnnPymInc BALANCE DEFAULT 0;
381 trc_TotLibAP BALANCE DEFAULT 0;
382 trc_LibFyAP BALANCE DEFAULT 0;
383 trc_LibFpAP BALANCE DEFAULT 0;
384 -- Pubilc Office Allowance
385 trc_PblOffYtd BALANCE DEFAULT 0;
386 trc_PblOffPtd BALANCE DEFAULT 0;
387 trc_PblOffErn BALANCE DEFAULT 0;
388 trc_LibFyPO BALANCE DEFAULT 0;
389 trc_LibFpPO BALANCE DEFAULT 0;
390 -- Messages
391 trc_LibWrn VARCHAR2(100) DEFAULT ' ';
392
393 -- Statutory Deduction Value
394 trc_PayValSD BALANCE DEFAULT 0;
395 -- Employer Contribution Value
396 trc_PayValEC BALANCE DEFAULT 0;
397 -- PAYE and SITE Values
398 trc_PayeVal BALANCE DEFAULT 0;
399 trc_SiteVal BALANCE DEFAULT 0;
400 -- IT3A Threshold Indicator
401 trc_It3Ind NUMBER DEFAULT 0;
402 -- Tax Percentage Value On trace
403 trc_TxPercVal NUMBER DEFAULT 0;
404 -- Total Taxable Income Update Figure
405 trc_OUpdFig BALANCE DEFAULT 0;
406 -- Net Taxable Income Update Figure
407 trc_NtiUpdFig BALANCE DEFAULT 0;
408
409 -- ValidateTaxOns Override Globals
410 trc_LibFpDROvr BOOLEAN DEFAULT FALSE;
411 trc_LibFpNIOvr BOOLEAN DEFAULT FALSE;
412 trc_LibFpFBOvr BOOLEAN DEFAULT FALSE;
413 trc_LibFpTAOvr BOOLEAN DEFAULT FALSE;
414 trc_LibFpBPOvr BOOLEAN DEFAULT FALSE;
415 trc_LibFpABOvr BOOLEAN DEFAULT FALSE;
416 trc_LibFpAPOvr BOOLEAN DEFAULT FALSE;
417 trc_LibFpPOOvr BOOLEAN DEFAULT FALSE;
418
419 -- Global Exception Message
420 xpt_Msg VARCHAR2(100) DEFAULT 'No Error';
421 -- Global Exception
422 xpt_E EXCEPTION;
423
424 -- Override Globals
425 trc_OvrTxCalc BOOLEAN DEFAULT FALSE;
426 trc_OvrTyp VARCHAR2(1) DEFAULT 'V';
427 trc_OvrPrc NUMBER(3) DEFAULT 0;
428 trc_OvrWrn VARCHAR2(150) DEFAULT ' ';
429
430 -- Negative Ptd Global
431 trc_NegPtd BOOLEAN DEFAULT FALSE;
432
433 -- Function to Override Tax Calculation
434 --
435 FUNCTION ZaTxOvr_01032005(
436 p_OvrTyp IN VARCHAR2
437 ,p_TxOnNI IN NUMBER
438 ,p_TxOnAP IN NUMBER
439 ,p_TxPrc IN NUMBER
440 )RETURN NUMBER;
441
442
443 -- Function to Initialise Globals
444 --
445 FUNCTION ZaTxGlb_01032005(
446 -- Global Values
447 p_ZA_ADL_TX_RBT IN NUMBER
448 ,p_ZA_ARR_PF_AN_MX_ABT IN NUMBER
449 ,p_ZA_ARR_RA_AN_MX_ABT IN NUMBER
450 ,p_ZA_TRV_ALL_TX_PRC IN NUMBER
451 ,p_ZA_CC_TX_PRC IN NUMBER
452 ,p_ZA_PF_AN_MX_ABT IN NUMBER
453 ,p_ZA_PF_MX_PRC IN NUMBER
454 ,p_ZA_PER_SERV_COMP_PERC IN NUMBER
455 ,p_ZA_PER_SERV_TRST_PERC IN NUMBER
456 ,p_ZA_PRI_TX_RBT IN NUMBER
457 ,p_ZA_PRI_TX_THRSHLD IN NUMBER
458 ,p_ZA_PBL_TX_PRC IN NUMBER
459 ,p_ZA_PBL_TX_RTE IN NUMBER
460 ,p_ZA_RA_AN_MX_ABT IN NUMBER
461 ,p_ZA_RA_MX_PRC IN NUMBER
462 ,p_ZA_SC_TX_THRSHLD IN NUMBER
463 ,p_ZA_SIT_LIM IN NUMBER
464 ,p_ZA_TMP_TX_RTE IN NUMBER
465 ,p_ZA_WRK_DYS_PR_YR IN NUMBER
466 ) RETURN NUMBER;
470 FUNCTION ZaTxDbi_01032005(
467
468 -- Function to Initialise Globals - Database Item Values
469 --
471 -- Database Items
472 p_PAY_PROC_PRD_DTE_PD IN DATE
473 ,p_PER_AGE IN NUMBER
474 ,p_PER_DTE_OF_BRTH IN DATE
475 ,p_SES_DTE IN DATE
476 ,p_ZA_ACT_END_DTE IN DATE
477 ,p_ZA_ACT_STRT_DTE IN DATE
478 ,p_ZA_ASG_TX_RTR_PRD IN VARCHAR2
479 ,p_ZA_ASG_TAX_RTR_RSLTS IN VARCHAR2
480 ,p_ZA_ASG_TX_YR IN NUMBER
481 ,p_ZA_ASG_TX_YR_END IN DATE
482 ,p_ZA_ASG_TX_YR_STRT IN DATE
483 ,p_ZA_CUR_PRD_END_DTE IN DATE
484 ,p_ZA_CUR_PRD_STRT_DTE IN DATE
485 ,p_ZA_DYS_IN_YR IN NUMBER
486 ,p_ZA_PAY_PRDS_LFT IN NUMBER
487 ,p_ZA_PAY_PRDS_PER_YR IN NUMBER
488 ,p_ZA_TX_YR_END IN DATE
489 ,p_ZA_TX_YR_STRT IN DATE
490 ,p_BP_TX_RCV IN VARCHAR2
491 ,p_SEA_WRK_DYS_WRK IN NUMBER
492 ,p_TX_DIR_NUM IN VARCHAR2
493 ,p_TX_DIR_VAL IN NUMBER
494 ,p_TX_STA IN VARCHAR2
495 ,p_ZA_LS_DIR_NUM IN VARCHAR2
496 ,p_ZA_LS_DIR_VAL IN NUMBER
497 ) RETURN NUMBER;
498
499
500 -- Function to Initialise Globals - Balance Values
501 -- First Section
502 FUNCTION ZaTxBal1_01032005(
503 -- Balances
504 p_ANN_ARR_PF_CMTD IN NUMBER
505 ,p_ANN_ARR_PF_CYTD IN NUMBER
506 ,p_ANN_ARR_PF_RUN IN NUMBER
507 ,p_ANN_ARR_PF_PTD IN NUMBER
508 ,p_ANN_ARR_PF_YTD IN NUMBER
509 ,p_ANN_ARR_RA_CMTD IN NUMBER
510 ,p_ANN_ARR_RA_CYTD IN NUMBER
511 ,p_ANN_ARR_RA_RUN IN NUMBER
512 ,p_ANN_ARR_RA_PTD IN NUMBER
513 ,p_ANN_ARR_RA_YTD IN NUMBER
514 ,p_ANN_EE_INC_PRO_POL_CMTD IN NUMBER
515 ,p_ANN_EE_INC_PRO_POL_CYTD IN NUMBER
516 ,p_ANN_EE_INC_PRO_POL_RUN IN NUMBER
517 ,p_ANN_EE_INC_PRO_POL_PTD IN NUMBER
518 ,p_ANN_EE_INC_PRO_POL_YTD IN NUMBER
519 ,p_ANN_PF_CMTD IN NUMBER
520 ,p_ANN_PF_CYTD IN NUMBER
521 ,p_ANN_PF_RUN IN NUMBER
522 ,p_ANN_PF_PTD IN NUMBER
523 ,p_ANN_PF_YTD IN NUMBER
524 ,p_ANN_RA_CMTD IN NUMBER
525 ,p_ANN_RA_CYTD IN NUMBER
526 ,p_ANN_RA_RUN IN NUMBER
527 ,p_ANN_RA_PTD IN NUMBER
528 ,p_ANN_RA_YTD IN NUMBER
529 ) RETURN NUMBER;
530
531 -- Function to Initialise Globals - Balance Values
532 -- Second Section
533 FUNCTION ZaTxBal2_01032005(
534 -- Balances
535 p_ARR_PF_CMTD IN NUMBER
536 ,p_ARR_PF_CYTD IN NUMBER
537 ,p_ARR_PF_PTD IN NUMBER
538 ,p_ARR_PF_YTD IN NUMBER
539 ,p_ARR_RA_CMTD IN NUMBER
540 ,p_ARR_RA_CYTD IN NUMBER
541 ,p_ARR_RA_PTD IN NUMBER
542 ,p_ARR_RA_YTD IN NUMBER
543 ,p_BP_CMTD IN NUMBER
544 ,p_BP_PTD IN NUMBER
545 ,p_BP_YTD IN NUMBER
546 ,p_CUR_PF_CMTD IN NUMBER
547 ,p_CUR_PF_CYTD IN NUMBER
548 ,p_CUR_PF_RUN IN NUMBER
549 ,p_CUR_PF_PTD IN NUMBER
550 ,p_CUR_PF_YTD IN NUMBER
551 ,p_CUR_RA_CMTD IN NUMBER
552 ,p_CUR_RA_CYTD IN NUMBER
553 ,p_CUR_RA_RUN IN NUMBER
554 ,p_CUR_RA_PTD IN NUMBER
555 ,p_CUR_RA_YTD IN NUMBER
556 ,p_DIR_DMD_RMN_ITD IN NUMBER
557 ) RETURN NUMBER;
558
559 -- Function to Initialise Globals - Balance Values
560 -- Third Section
561 FUNCTION ZaTxBal3_01032005(
562 -- Balances
563 p_EE_INC_PRO_POL_CMTD IN NUMBER
564 ,p_EE_INC_PRO_POL_CYTD IN NUMBER
565 ,p_EE_INC_PRO_POL_RUN IN NUMBER
566 ,p_EE_INC_PRO_POL_PTD IN NUMBER
567 ,p_EE_INC_PRO_POL_YTD IN NUMBER
568 ,p_EXC_ARR_PEN_ITD IN NUMBER
569 ,p_EXC_ARR_PEN_PTD IN NUMBER
570 ,p_EXC_ARR_PEN_YTD IN NUMBER
571 ,p_EXC_ARR_RA_ITD IN NUMBER
572 ,p_EXC_ARR_RA_PTD IN NUMBER
573 ,p_EXC_ARR_RA_YTD IN NUMBER
574 ,p_MED_CONTR_CMTD IN NUMBER
575 ,p_MED_CONTR_CYTD IN NUMBER
576 ,p_MED_CONTR_RUN IN NUMBER
577 ,p_MED_CONTR_PTD IN NUMBER
578 ,p_MED_CONTR_YTD IN NUMBER
579 ,p_NET_PAY_RUN IN NUMBER
580 ,p_NET_TXB_INC_CMTD IN NUMBER
581 ) RETURN NUMBER;
582
583 -- Function to Initialise Globals - Balance Values
584 -- Fourth Section
585 FUNCTION ZaTxBal4_01032005(
586 -- Balances
587 p_PAYE_YTD IN NUMBER
588 ,p_SITE_YTD IN NUMBER
589 ,p_TAX_YTD IN NUMBER
590 ,p_TX_ON_AB_PTD IN NUMBER
591 ,p_TX_ON_AB_YTD IN NUMBER
592 ,p_TX_ON_AP_PTD IN NUMBER
593 ,p_TX_ON_AP_YTD IN NUMBER
594 ,p_TX_ON_BP_PTD IN NUMBER
595 ,p_TX_ON_BP_YTD IN NUMBER
596 ,p_TX_ON_TA_PTD IN NUMBER
597 ,p_TX_ON_TA_YTD IN NUMBER
601 ,p_TX_ON_FB_YTD IN NUMBER
598 ,p_TX_ON_DR_PTD IN NUMBER
599 ,p_TX_ON_DR_YTD IN NUMBER
600 ,p_TX_ON_FB_PTD IN NUMBER
602 ,p_TX_ON_NI_PTD IN NUMBER
603 ,p_TX_ON_NI_YTD IN NUMBER
604 ,p_TX_ON_PO_PTD IN NUMBER
605 ,p_TX_ON_PO_YTD IN NUMBER
606 ) RETURN NUMBER;
607
608 FUNCTION ZaTxBal5_01032005(
609 -- Balances
610 p_TOT_INC_PTD IN NUMBER
611 ,p_TOT_INC_YTD IN NUMBER
612 ,p_TOT_NRFI_AN_INC_CMTD IN NUMBER
613 ,p_TOT_NRFI_AN_INC_CYTD IN NUMBER
614 ,p_TOT_NRFI_AN_INC_RUN IN NUMBER
615 ,p_TOT_NRFI_AN_INC_PTD IN NUMBER
616 ,p_TOT_NRFI_AN_INC_YTD IN NUMBER
617 ,p_TOT_NRFI_INC_CMTD IN NUMBER
618 ,p_TOT_NRFI_INC_CYTD IN NUMBER
619 ,p_TOT_NRFI_INC_RUN IN NUMBER
620 ,p_TOT_NRFI_INC_PTD IN NUMBER
621 ,p_TOT_NRFI_INC_YTD IN NUMBER
622 ,p_TOT_RFI_AN_INC_CMTD IN NUMBER
623 ,p_TOT_RFI_AN_INC_CYTD IN NUMBER
624 ,p_TOT_RFI_AN_INC_RUN IN NUMBER
625 ,p_TOT_RFI_AN_INC_PTD IN NUMBER
626 ,p_TOT_RFI_AN_INC_YTD IN NUMBER
627 ,p_TOT_RFI_INC_CMTD IN NUMBER
628 ,p_TOT_RFI_INC_CYTD IN NUMBER
629 ,p_TOT_RFI_INC_RUN IN NUMBER
630 ,p_TOT_RFI_INC_PTD IN NUMBER
631 ,p_TOT_RFI_INC_YTD IN NUMBER
632 ,p_TOT_SEA_WRK_DYS_WRK_YTD IN NUMBER
633 ,p_TOT_SKL_ANN_INC_CMTD IN NUMBER
634 ,p_TOT_SKL_INC_CMTD IN NUMBER
635 ,p_TOT_TXB_INC_ITD IN NUMBER
636 ) RETURN NUMBER;
637
638 FUNCTION ZaTxBal6_01032005(
639 -- Balances
640 p_TOT_TXB_AB_CMTD IN NUMBER
641 ,p_TOT_TXB_AB_RUN IN NUMBER
642 ,p_TOT_TXB_AB_PTD IN NUMBER
643 ,p_TOT_TXB_AB_YTD IN NUMBER
644 ,p_TOT_TXB_AP_CMTD IN NUMBER
645 ,p_TOT_TXB_AP_RUN IN NUMBER
646 ,p_TOT_TXB_AP_PTD IN NUMBER
647 ,p_TOT_TXB_AP_YTD IN NUMBER
648 ,p_TOT_TXB_FB_CMTD IN NUMBER
649 ,p_TOT_TXB_FB_CYTD IN NUMBER
650 ,p_TOT_TXB_FB_RUN IN NUMBER
651 ,p_TOT_TXB_FB_PTD IN NUMBER
652 ,p_TOT_TXB_FB_YTD IN NUMBER
653 ,p_TOT_TXB_NI_CMTD IN NUMBER
654 ,p_TOT_TXB_NI_CYTD IN NUMBER
655 ,p_TOT_TXB_NI_RUN IN NUMBER
656 ,p_TOT_TXB_NI_PTD IN NUMBER
657 ,p_TOT_TXB_NI_YTD IN NUMBER
658 ,p_TOT_TXB_PO_CMTD IN NUMBER
659 ,p_TOT_TXB_PO_PTD IN NUMBER
660 ,p_TOT_TXB_PO_YTD IN NUMBER
661 ,p_TOT_TXB_TA_CMTD IN NUMBER
662 ,p_TOT_TXB_TA_CYTD IN NUMBER
663 ,p_TOT_TXB_TA_PTD IN NUMBER
664 ,p_TOT_TXB_TA_YTD IN NUMBER
665 ) RETURN NUMBER;
666
667 -- Main Tax Function
668 -- Called from Fast Formula
669 FUNCTION ZaTx_01032005(
670 /* PARAMETERS */
671 -- Contexts
672 ASSIGNMENT_ACTION_ID IN NUMBER
673 ,ASSIGNMENT_ID IN NUMBER
674 ,PAYROLL_ACTION_ID IN NUMBER
675 ,PAYROLL_ID IN NUMBER
676 -- Out Parameters
677 , p_LibWrn OUT NOCOPY VARCHAR2
678 , p_LibFpDR OUT NOCOPY NUMBER
679 , p_LibFpNI OUT NOCOPY NUMBER
680 , p_LibFpFB OUT NOCOPY NUMBER
681 , p_LibFpTA OUT NOCOPY NUMBER
682 , p_LibFpBP OUT NOCOPY NUMBER
683 , p_LibFpAB OUT NOCOPY NUMBER
684 , p_LibFpAP OUT NOCOPY NUMBER
685 , p_LibFpPO OUT NOCOPY NUMBER
686 , p_PayValSD OUT NOCOPY NUMBER
687 , p_PayValEC OUT NOCOPY NUMBER
688 , p_PayeVal OUT NOCOPY NUMBER
689 , p_SiteVal OUT NOCOPY NUMBER
690 , p_It3Ind OUT NOCOPY NUMBER
691 , p_PfUpdFig OUT NOCOPY NUMBER
692 , p_RaUpdFig OUT NOCOPY NUMBER
693 , p_OUpdFig OUT NOCOPY NUMBER
694 , p_NtiUpdFig OUT NOCOPY NUMBER
695 , p_OvrWrn OUT NOCOPY VARCHAR2
696 , p_LSDirNum OUT NOCOPY VARCHAR2
697 , p_LSDirVal OUT NOCOPY NUMBER
698 )RETURN NUMBER;
699
700
701 END py_za_tx_01032005;
702
[Home] [Help]