eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PY_ZA_TX_01032007 dependencies on PY_ZA_TX_UTL_01032007

Line 32: Wrapper procedure for py_za_tx_utl_01032007.WriteHrTrace

28:
29:
30: PRIVATE PROCEDURES
31: WrtHrTrc
32: Wrapper procedure for py_za_tx_utl_01032007.WriteHrTrace
33: NetTxbIncCalc
34: Procedure to calculate a Net Taxable Income figure used
35: to properly calculate the Skills Development Levy
36: LteCalc

Line 81: -- Wrapper for py_za_tx_utl_01032007.WriteHrTrace

77: -------------------------------------------------------------------------------
78:
79: -------------------------------------------------------------------------------
80: -- WrtHrTrc
81: -- Wrapper for py_za_tx_utl_01032007.WriteHrTrace
82: -------------------------------------------------------------------------------
83: PROCEDURE WrtHrTrc(
84: p_Buf IN VARCHAR2
85: )

Line 89: py_za_tx_utl_01032007.WriteHrTrace(p_Buf);

85: )
86: AS
87:
88: BEGIN
89: py_za_tx_utl_01032007.WriteHrTrace(p_Buf);
90: END WrtHrTrc;
91:
92: -------------------------------------------------------------------------------
93: -- NetTxbIncCalc

Line 628: trc_SitFactor := (l_EndDate - l_StrtDte + 1) / py_za_tx_utl_01032007.DaysWorked;

624: l_StrtDte := dbi_ZA_ASG_TX_YR_STRT;
625: l_EndDate := dbi_ZA_ASG_TX_YR_END;
626: hr_utility.set_location('py_za_tx_01032007.LteCalc',8);
627:
628: trc_SitFactor := (l_EndDate - l_StrtDte + 1) / py_za_tx_utl_01032007.DaysWorked;
629: hr_utility.set_location('py_za_tx_01032007.LteCalc',9);
630:
631: -- Populate Local Balance Variables
632: -- The PTD Globals are used as dummy to store the previous tax year's

Line 664: py_za_tx_utl_01032007.TrvAll;

660:
661: hr_utility.set_location('py_za_tx_01032007.LteCalc',10);
662:
663: -- Update Globals with Correct Taxable Values
664: py_za_tx_utl_01032007.TrvAll;
665:
666: bal_TOT_TXB_PO_PTD := bal_TOT_TXB_PO_PTD
667: * py_za_tx_utl_01032007.GlbVal('ZA_PUBL_TAX_PERC',l_EndDate)
668: / 100;

Line 667: * py_za_tx_utl_01032007.GlbVal('ZA_PUBL_TAX_PERC',l_EndDate)

663: -- Update Globals with Correct Taxable Values
664: py_za_tx_utl_01032007.TrvAll;
665:
666: bal_TOT_TXB_PO_PTD := bal_TOT_TXB_PO_PTD
667: * py_za_tx_utl_01032007.GlbVal('ZA_PUBL_TAX_PERC',l_EndDate)
668: / 100;
669: hr_utility.set_location('py_za_tx_01032007.LteCalc',11);
670:
671: -- Rebates

Line 672: py_za_tx_utl_01032007.SetRebates;

668: / 100;
669: hr_utility.set_location('py_za_tx_01032007.LteCalc',11);
670:
671: -- Rebates
672: py_za_tx_utl_01032007.SetRebates;
673: -- Abatements
674: py_za_tx_utl_01032007.Abatements;
675:
676: hr_utility.set_location('py_za_tx_01032007.LteCalc',12);

Line 674: py_za_tx_utl_01032007.Abatements;

670:
671: -- Rebates
672: py_za_tx_utl_01032007.SetRebates;
673: -- Abatements
674: py_za_tx_utl_01032007.Abatements;
675:
676: hr_utility.set_location('py_za_tx_01032007.LteCalc',12);
677:
678: -- Base Earnings

Line 696: trc_TotLibBse := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbBseInc);

692: -- Threshold Check
693: IF trc_TxbBseInc >= trc_Threshold THEN
694: hr_utility.set_location('py_za_tx_01032007.LteCalc',13);
695: -- Tax Liability
696: trc_TotLibBse := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbBseInc);
697: ELSE
698: hr_utility.set_location('py_za_tx_01032007.LteCalc',14);
699: trc_TotLibBse := 0;
700: END IF;

Line 725: l_ZA_ADL_TX_RBT := py_za_tx_utl_01032007.GlbVal('ZA_ADDITIONAL_TAX_REBATE',l_EndDate);

721: hr_utility.set_location('py_za_tx_01032007.LteCalc',16);
722:
723: -- Global Values
724: l_ZA_TX_YR_END := l_EndDate;
725: l_ZA_ADL_TX_RBT := py_za_tx_utl_01032007.GlbVal('ZA_ADDITIONAL_TAX_REBATE',l_EndDate);
726: l_ZA_PRI_TX_RBT := py_za_tx_utl_01032007.GlbVal('ZA_PRIMARY_TAX_REBATE',l_EndDate);
727: l_ZA_PRI_TX_THRSHLD := py_za_tx_utl_01032007.GlbVal('ZA_PRIM_TAX_THRESHOLD',l_EndDate);
728: l_ZA_SC_TX_THRSHLD := py_za_tx_utl_01032007.GlbVal('ZA_SEC_TAX_THRESHOLD',l_EndDate);
729:

Line 726: l_ZA_PRI_TX_RBT := py_za_tx_utl_01032007.GlbVal('ZA_PRIMARY_TAX_REBATE',l_EndDate);

722:
723: -- Global Values
724: l_ZA_TX_YR_END := l_EndDate;
725: l_ZA_ADL_TX_RBT := py_za_tx_utl_01032007.GlbVal('ZA_ADDITIONAL_TAX_REBATE',l_EndDate);
726: l_ZA_PRI_TX_RBT := py_za_tx_utl_01032007.GlbVal('ZA_PRIMARY_TAX_REBATE',l_EndDate);
727: l_ZA_PRI_TX_THRSHLD := py_za_tx_utl_01032007.GlbVal('ZA_PRIM_TAX_THRESHOLD',l_EndDate);
728: l_ZA_SC_TX_THRSHLD := py_za_tx_utl_01032007.GlbVal('ZA_SEC_TAX_THRESHOLD',l_EndDate);
729:
730: -- Calculate the assignments 65 Year Date

Line 727: l_ZA_PRI_TX_THRSHLD := py_za_tx_utl_01032007.GlbVal('ZA_PRIM_TAX_THRESHOLD',l_EndDate);

723: -- Global Values
724: l_ZA_TX_YR_END := l_EndDate;
725: l_ZA_ADL_TX_RBT := py_za_tx_utl_01032007.GlbVal('ZA_ADDITIONAL_TAX_REBATE',l_EndDate);
726: l_ZA_PRI_TX_RBT := py_za_tx_utl_01032007.GlbVal('ZA_PRIMARY_TAX_REBATE',l_EndDate);
727: l_ZA_PRI_TX_THRSHLD := py_za_tx_utl_01032007.GlbVal('ZA_PRIM_TAX_THRESHOLD',l_EndDate);
728: l_ZA_SC_TX_THRSHLD := py_za_tx_utl_01032007.GlbVal('ZA_SEC_TAX_THRESHOLD',l_EndDate);
729:
730: -- Calculate the assignments 65 Year Date
731: l_65Year := add_months(dbi_PER_DTE_OF_BRTH,780);

Line 728: l_ZA_SC_TX_THRSHLD := py_za_tx_utl_01032007.GlbVal('ZA_SEC_TAX_THRESHOLD',l_EndDate);

724: l_ZA_TX_YR_END := l_EndDate;
725: l_ZA_ADL_TX_RBT := py_za_tx_utl_01032007.GlbVal('ZA_ADDITIONAL_TAX_REBATE',l_EndDate);
726: l_ZA_PRI_TX_RBT := py_za_tx_utl_01032007.GlbVal('ZA_PRIMARY_TAX_REBATE',l_EndDate);
727: l_ZA_PRI_TX_THRSHLD := py_za_tx_utl_01032007.GlbVal('ZA_PRIM_TAX_THRESHOLD',l_EndDate);
728: l_ZA_SC_TX_THRSHLD := py_za_tx_utl_01032007.GlbVal('ZA_SEC_TAX_THRESHOLD',l_EndDate);
729:
730: -- Calculate the assignments 65 Year Date
731: l_65Year := add_months(dbi_PER_DTE_OF_BRTH,780);
732:

Line 754: trc_TotLibBse := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbBseInc);

750: -- Threshold Check
751: IF trc_TxbBseInc >= trc_Threshold THEN
752: hr_utility.set_location('py_za_tx_01032007.LteCalc',19);
753: -- Tax Liability
754: trc_TotLibBse := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbBseInc);
755: ELSE
756: hr_utility.set_location('py_za_tx_01032007.LteCalc',20);
757: trc_TotLibBse := 0;
758: END IF;

Line 774: py_za_tx_utl_01032007.SetRebates;

770:
771: hr_utility.set_location('py_za_tx_01032007.LteCalc',21);
772:
773: -- Rebates
774: py_za_tx_utl_01032007.SetRebates;
775: -- Abatements
776: py_za_tx_utl_01032007.Abatements;
777:
778: hr_utility.set_location('py_za_tx_01032007.LteCalc',22);

Line 776: py_za_tx_utl_01032007.Abatements;

772:
773: -- Rebates
774: py_za_tx_utl_01032007.SetRebates;
775: -- Abatements
776: py_za_tx_utl_01032007.Abatements;
777:
778: hr_utility.set_location('py_za_tx_01032007.LteCalc',22);
779:
780: -- Update Global Balance Values with correct TAXABLE values

Line 781: py_za_tx_utl_01032007.TrvAll;

777:
778: hr_utility.set_location('py_za_tx_01032007.LteCalc',22);
779:
780: -- Update Global Balance Values with correct TAXABLE values
781: py_za_tx_utl_01032007.TrvAll;
782:
783: bal_TOT_TXB_PO_YTD := bal_TOT_TXB_PO_YTD * glb_ZA_PBL_TX_PRC / 100;
784:
785: -- Normal Income

Line 800: trc_TotLibNI := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbNorInc);

796: -- Threshold Check
797: IF trc_TxbNorInc >= trc_Threshold THEN
798: hr_utility.set_location('py_za_tx_01032007.LteCalc',24);
799: -- Tax Liability
800: trc_TotLibNI := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbNorInc);
801: trc_LibFyNI := trc_TotLibNI - least(trc_TotLibNI,trc_TotLibBse);
802: trc_TotLibNI := greatest(trc_TotLibNI,trc_TotLibBse);
803: trc_LibFpNI := trc_LibFyNI - bal_TX_ON_NI_YTD;
804: ELSE

Line 835: trc_TotLibFB := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbFrnInc);

831: -- Threshold Check
832: IF trc_TxbFrnInc >= trc_Threshold THEN
833: hr_utility.set_location('py_za_tx_01032007.LteCalc',28);
834: -- Tax Liability
835: trc_TotLibFB := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbFrnInc);
836: trc_LibFyFB := trc_TotLibFB - least(trc_TotLibFB,trc_TotLibNI);
837: trc_TotLibFB := greatest(trc_TotLibFB,trc_TotLibNI);
838: trc_LibFpFB := trc_LibFyFB - bal_TX_ON_FB_YTD;
839: ElSE

Line 871: trc_TotLibTA := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbTrvInc);

867: -- Threshold Check
868: IF trc_TxbTrvInc >= trc_Threshold THEN
869: hr_utility.set_location('py_za_tx_01032007.LteCalc',32);
870: -- Tax Liability
871: trc_TotLibTA := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbTrvInc);
872: trc_LibFyTA := trc_TotLibTA - least(trc_TotLibTA,trc_TotLibFB);
873: trc_TotLibTA := greatest(trc_TotLibTA,trc_TotLibFB);
874: trc_LibFpTA := trc_LibFyTA - bal_TX_ON_TA_YTD;
875: ELSE

Line 907: trc_TotLibAB := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbAnnBonInc);

903: -- Threshold Check
904: IF trc_TxbAnnBonInc >= trc_Threshold THEN
905: hr_utility.set_location('py_za_tx_01032007.LteCalc',36);
906: -- Tax Liability
907: trc_TotLibAB := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbAnnBonInc);
908: trc_LibFyAB := trc_TotLibAB - least(trc_TotLibAB,trc_TotLibTA);
909: trc_TotLibAB := greatest(trc_TotLibAB,trc_TotLibTA);
910: trc_LibFpAB := trc_LibFyAB - bal_TX_ON_AB_YTD;
911: ELSE

Line 943: trc_TotLibAP := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbAnnPymInc);

939: -- Threshold Check
940: IF trc_TxbAnnPymInc >= trc_Threshold THEN
941: hr_utility.set_location('py_za_tx_01032007.LteCalc',42);
942: -- Tax Liability
943: trc_TotLibAP := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbAnnPymInc);
944: trc_LibFyAP := trc_TotLibAP - least(trc_TotLibAP,trc_TotLibAB);
945: trc_TotLibAP := greatest(trc_TotLibAP,trc_TotLibAB);
946: trc_LibFpAP := trc_LibFyAP - bal_TX_ON_AP_YTD;
947: ELSE

Line 979: trc_TotLibPO := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbPblOffInc);

975: -- Threshold Check
976: IF trc_TxbPblOffInc >= trc_Threshold THEN
977: hr_utility.set_location('py_za_tx_01032007.LteCalc',48);
978: -- Tax Liability
979: trc_TotLibPO := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbPblOffInc);
980: trc_LibFyPO := trc_TotLibPO - least(trc_TotLibPO,trc_TotLibAP);
981: trc_TotLibPO := greatest(trc_TotLibPO,trc_TotLibAP);
982: trc_LibFpPO := trc_LibFyPO - bal_TX_ON_PO_YTD;
983: ElSE

Line 1013: py_za_tx_utl_01032007.ValidateTaxOns(p_Rf => l_Sl);

1009: hr_utility.set_location('py_za_tx_01032007.LteCalc',52);
1010: l_Sl := FALSE;
1011: END IF;
1012:
1013: py_za_tx_utl_01032007.ValidateTaxOns(p_Rf => l_Sl);
1014:
1015: -- Set IT3A Indicator
1016: --
1017: IF trc_TxbAnnPymInc + trc_PblOffErn >= trc_Threshold THEN

Line 1141: trc_TotLibBse := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbBseInc);

1137: -- Threshold Check
1138: IF trc_TxbBseInc >= trc_Threshold THEN
1139: hr_utility.set_location('py_za_tx_01032007.SeaCalc',6);
1140: -- Tax Liability
1141: trc_TotLibBse := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbBseInc);
1142: ELSE
1143: hr_utility.set_location('py_za_tx_01032007.SeaCalc',7);
1144: trc_TotLibBse := 0;
1145: END IF;

Line 1155: trc_TotLibAP := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbAnnPymInc);

1151: -- Threshold Check
1152: IF trc_TxbAnnPymInc >= trc_Threshold THEN
1153: hr_utility.set_location('py_za_tx_01032007.SeaCalc',8);
1154: -- Tax Liability
1155: trc_TotLibAP := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbAnnPymInc);
1156: trc_LibFpAP := trc_TotLibAP - least(trc_TotLibAP,trc_TotLibBse);
1157: ElSE
1158: hr_utility.set_location('py_za_tx_01032007.SeaCalc',9);
1159: trc_LibFpAP := 0;

Line 1183: py_za_tx_utl_01032007.SetRebates;

1179: --
1180: trc_SitFactor := glb_ZA_WRK_DYS_PR_YR / dbi_SEA_WRK_DYS_WRK;
1181:
1182: -- Rebates
1183: py_za_tx_utl_01032007.SetRebates;
1184:
1185: -- Abatements
1186: py_za_tx_utl_01032007.Abatements;
1187:

Line 1186: py_za_tx_utl_01032007.Abatements;

1182: -- Rebates
1183: py_za_tx_utl_01032007.SetRebates;
1184:
1185: -- Abatements
1186: py_za_tx_utl_01032007.Abatements;
1187:
1188: hr_utility.set_location('py_za_tx_01032007.SeaCalc',11);
1189:
1190: -- Normal Income

Line 1205: trc_TotLibNI := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbNorInc);

1201: -- Threshold Check
1202: IF trc_TxbNorInc >= trc_Threshold THEN
1203: hr_utility.set_location('py_za_tx_01032007.SeaCalc',13);
1204: -- Tax Liability
1205: trc_TotLibNI := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbNorInc);
1206: trc_LibFyNI := trc_TotLibNI - 0;
1207: trc_TotLibNI := greatest(trc_TotLibNI,0);
1208: trc_LibFpNI := trc_LibFyNI / trc_SitFactor;
1209: ELSE

Line 1235: trc_TotLibFB := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbFrnInc);

1231: -- Threshold Check
1232: IF trc_TxbFrnInc >= trc_Threshold THEN
1233: hr_utility.set_location('py_za_tx_01032007.SeaCalc',17);
1234: -- Tax Liability
1235: trc_TotLibFB := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbFrnInc);
1236: trc_LibFyFB := trc_TotLibFB - least(trc_TotLibFB,trc_TotLibNI);
1237: trc_TotLibFB := greatest(trc_TotLibFB,trc_TotLibNI);
1238: trc_LibFpFB := trc_LibFyFB / trc_SitFactor;
1239: ELSE

Line 1265: trc_TotLibAP := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbAnnPymInc);

1261: -- Threshold Check
1262: IF trc_TxbAnnPymInc >= trc_Threshold THEN
1263: hr_utility.set_location('py_za_tx_01032007.SeaCalc',21);
1264: -- Tax Liability
1265: trc_TotLibAP := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbAnnPymInc);
1266: trc_LibFyAP := trc_TotLibAP - least(trc_TotLibAP,trc_TotLibFB);
1267: trc_TotLibAP := greatest(trc_TotLibAP,trc_TotLibFB);
1268: trc_LibFpAP := trc_LibFyAP;
1269: ELSE

Line 1283: py_za_tx_utl_01032007.ValidateTaxOns;

1279:
1280:
1281: -- Net Pay Validation
1282: --
1283: py_za_tx_utl_01032007.ValidateTaxOns;
1284:
1285: hr_utility.set_location('py_za_tx_01032007.SeaCalc',24);
1286:
1287: -- Set IT3A Indicator

Line 1350: py_za_tx_utl_01032007.TrvAll;

1346: trc_CalTyp := 'SitCalc';
1347:
1348: -- Update Global Balance Values with correct TAXABLE values
1349: --
1350: py_za_tx_utl_01032007.TrvAll;
1351:
1352: hr_utility.set_location('py_za_tx_01032007.SitCalc',2);
1353:
1354: bal_TOT_TXB_PO_YTD := bal_TOT_TXB_PO_YTD * glb_ZA_PBL_TX_PRC / 100;

Line 1368: trc_SitFactor := dbi_ZA_DYS_IN_YR / py_za_tx_utl_01032007.DaysWorked;

1364: hr_utility.set_location('py_za_tx_01032007.SitCalc',3);
1365:
1366: -- Site Factor
1367: --
1368: trc_SitFactor := dbi_ZA_DYS_IN_YR / py_za_tx_utl_01032007.DaysWorked;
1369:
1370: hr_utility.set_location('py_za_tx_01032007.SitCalc',4);
1371:
1372: -- Rebates

Line 1373: py_za_tx_utl_01032007.SetRebates;

1369:
1370: hr_utility.set_location('py_za_tx_01032007.SitCalc',4);
1371:
1372: -- Rebates
1373: py_za_tx_utl_01032007.SetRebates;
1374:
1375: -- Abatements
1376: py_za_tx_utl_01032007.Abatements;
1377:

Line 1376: py_za_tx_utl_01032007.Abatements;

1372: -- Rebates
1373: py_za_tx_utl_01032007.SetRebates;
1374:
1375: -- Abatements
1376: py_za_tx_utl_01032007.Abatements;
1377:
1378: hr_utility.set_location('py_za_tx_01032007.SitCalc',5);
1379:
1380: -- Deemed Remuneration

Line 1394: trc_TotLibDR := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbDmdRmn);

1390: -- Threshold Check
1391: IF trc_TxbDmdRmn >= trc_Threshold THEN
1392: hr_utility.set_location('py_za_tx_01032007.SitCalc',7);
1393: -- Tax Liability
1394: trc_TotLibDR := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbDmdRmn);
1395: trc_LibFyDR := (trc_TotLibDR - 0) / trc_SitFactor;
1396: trc_TotLibDR := greatest(trc_TotLibDR,0);
1397: trc_LibFpDR := trc_LibFyDR - bal_TX_ON_DR_YTD;
1398: ELSE

Line 1431: trc_TotLibNI := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbNorInc);

1427: -- Threshold Check
1428: IF trc_TxbNorInc >= trc_Threshold THEN
1429: hr_utility.set_location('py_za_tx_01032007.SitCalc',12);
1430: -- Tax Liability
1431: trc_TotLibNI := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbNorInc);
1432: trc_LibFyNI := (trc_TotLibNI - least(trc_TotLibNI,trc_TotLibDR)) / trc_SitFactor;
1433: trc_TotLibNI := greatest(trc_TotLibNI,trc_TotLibDR);
1434: trc_LibFpNI := trc_LibFyNI - bal_TX_ON_NI_YTD;
1435: ELSE

Line 1467: trc_TotLibFB := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbFrnInc);

1463: -- Threshold Check
1464: IF trc_TxbFrnInc >= trc_Threshold THEN
1465: hr_utility.set_location('py_za_tx_01032007.SitCalc',16);
1466: -- Tax Liability
1467: trc_TotLibFB := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbFrnInc);
1468: trc_LibFyFB := (trc_TotLibFB - least(trc_TotLibFB,trc_TotLibNI)) / trc_SitFactor;
1469: trc_TotLibFB := greatest(trc_TotLibFB,trc_TotLibNI);
1470: trc_LibFpFB := trc_LibFyFB - bal_TX_ON_FB_YTD;
1471: ElSE

Line 1503: trc_TotLibTA := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbTrvInc);

1499: -- Threshold Check
1500: IF trc_TxbTrvInc >= trc_Threshold THEN
1501: hr_utility.set_location('py_za_tx_01032007.SitCalc',20);
1502: -- Tax Liability
1503: trc_TotLibTA := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbTrvInc);
1504: trc_LibFyTA := (trc_TotLibTA - least(trc_TotLibTA,trc_TotLibFB)) / trc_SitFactor;
1505: trc_TotLibTA := greatest(trc_TotLibTA,trc_TotLibFB);
1506: trc_LibFpTA := trc_LibFyTA - bal_TX_ON_TA_YTD;
1507: ELSE

Line 1539: trc_TotLibBP := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbBonProInc);

1535: -- Threshold Check
1536: IF trc_TxbBonProInc >= trc_Threshold THEN
1537: hr_utility.set_location('py_za_tx_01032007.SitCalc',24);
1538: -- Tax Liability
1539: trc_TotLibBP := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbBonProInc);
1540: trc_LibFyBP := (trc_TotLibBP - least(trc_TotLibBP,trc_TotLibTA)) / trc_SitFactor;
1541: trc_TotLibBP := greatest(trc_TotLibBP,trc_TotLibTA);
1542: trc_LibFpBP := trc_LibFyBP - bal_TX_ON_BP_YTD;
1543: ELSE

Line 1575: trc_TotLibAB := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbAnnBonInc);

1571: -- Threshold Check
1572: IF trc_TxbAnnBonInc >= trc_Threshold THEN
1573: hr_utility.set_location('py_za_tx_01032007.SitCalc',28);
1574: -- Tax Liability
1575: trc_TotLibAB := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbAnnBonInc);
1576: trc_LibFyAB := trc_TotLibAB - least(trc_TotLibAB,trc_TotLibTA);
1577: trc_TotLibAB := greatest(trc_TotLibAB,trc_TotLibTA);
1578: hr_utility.set_location('py_za_tx_01032007.SitCalc',29);
1579: -- Check Bonus Provision

Line 1583: IF dbi_BP_TX_RCV = 'B' OR py_za_tx_utl_01032007.SitePeriod THEN

1579: -- Check Bonus Provision
1580: IF trc_BonProYtd <> 0 THEN
1581: hr_utility.set_location('py_za_tx_01032007.SitCalc',30);
1582: -- Check Bonus Provision Frequency
1583: IF dbi_BP_TX_RCV = 'B' OR py_za_tx_utl_01032007.SitePeriod THEN
1584: hr_utility.set_location('py_za_tx_01032007.SitCalc',31);
1585: trc_LibFpAB :=
1586: trc_LibFyAB - (bal_TX_ON_BP_YTD
1587: + trc_LibFpBP

Line 1610: IF dbi_BP_TX_RCV = 'A' AND py_za_tx_utl_01032007.SitePeriod THEN

1606: -- Set Cascade Figures and Refund
1607: trc_LibFpAB := -1 * bal_TX_ON_AB_YTD;
1608: trc_LibFpABOvr := TRUE;
1609:
1610: IF dbi_BP_TX_RCV = 'A' AND py_za_tx_utl_01032007.SitePeriod THEN
1611: hr_utility.set_location('py_za_tx_01032007.SitCalc',36);
1612: trc_LibFpBP := -1 * bal_TX_ON_BP_YTD;
1613: trc_LibFpBPOvr := TRUE;
1614: trc_LibFpAPOvr := TRUE;

Line 1642: trc_TotLibAP := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbAnnPymInc);

1638: -- Threshold Check
1639: IF trc_TxbAnnPymInc >= trc_Threshold THEN
1640: hr_utility.set_location('py_za_tx_01032007.SitCalc',39);
1641: -- Tax Liability
1642: trc_TotLibAP := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbAnnPymInc);
1643: trc_LibFyAP := trc_TotLibAP - least(trc_TotLibAP,trc_TotLibAB);
1644: trc_TotLibAP := greatest(trc_TotLibAP,trc_TotLibAB);
1645: trc_LibFpAP := trc_LibFyAP - bal_TX_ON_AP_YTD;
1646: ELSE

Line 1678: trc_TotLibPO := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbPblOffInc);

1674: -- Threshold Check
1675: IF trc_TxbPblOffInc >= trc_Threshold THEN
1676: hr_utility.set_location('py_za_tx_01032007.SitCalc',43);
1677: -- Tax Liability
1678: trc_TotLibPO := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbPblOffInc);
1679: trc_LibFyPO := (trc_TotLibPO - least(trc_TotLibPO,trc_TotLibAP)) / trc_SitFactor;
1680: trc_TotLibPO := greatest(trc_TotLibPO,trc_TotLibAP);
1681: trc_LibFpPO := trc_LibFyPO - bal_TX_ON_PO_YTD;
1682: ElSE

Line 1712: py_za_tx_utl_01032007.ValidateTaxOns(p_Rf => l_Sl);

1708: hr_utility.set_location('py_za_tx_01032007.SitCalc',47);
1709: l_Sl := FALSE;
1710: END IF;
1711:
1712: py_za_tx_utl_01032007.ValidateTaxOns(p_Rf => l_Sl);
1713:
1714: hr_utility.set_location('py_za_tx_01032007.SitCalc',48);
1715:
1716: -- Set IT3A Indicator

Line 1824: py_za_tx_utl_01032007.TrvAll;

1820: trc_CalTyp := 'DirCalc';
1821:
1822: -- Update Global Balance Values with correct TAXABLE values
1823: --
1824: py_za_tx_utl_01032007.TrvAll;
1825:
1826: hr_utility.set_location('py_za_tx_01032007.DirCalc',2);
1827:
1828: bal_TOT_TXB_PO_YTD := bal_TOT_TXB_PO_YTD * glb_ZA_PBL_TX_PRC / 100;

Line 1840: trc_TotLibNI := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_NorErn);

1836: hr_utility.set_location('py_za_tx_01032007.DirCalc',3);
1837: -- Normal Earnings
1838: trc_NorErn := trc_NorIncYtd;
1839: -- Tax Liability
1840: trc_TotLibNI := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_NorErn);
1841: trc_LibFyNI := trc_TotLibNI - 0;
1842: trc_TotLibNI := greatest(trc_TotLibNI,0);
1843: trc_LibFpNI := trc_LibFyNI - bal_TX_ON_NI_YTD;
1844: ELSE

Line 1863: trc_TotLibFB := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_FrnBenErn);

1859: hr_utility.set_location('py_za_tx_01032007.DirCalc',5);
1860: -- Fringe Benefit Earnings
1861: trc_FrnBenErn := trc_FrnBenYtd + trc_NorErn;
1862: -- Tax Liability
1863: trc_TotLibFB := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_FrnBenErn);
1864: trc_LibFyFB := trc_TotLibFB - least(trc_TotLibFB,trc_TotLibNI);
1865: trc_TotLibFB := greatest(trc_TotLibFB,trc_TotLibNI);
1866: trc_LibFpFB := trc_LibFyFB - bal_TX_ON_FB_YTD;
1867: ELSE

Line 1886: trc_TotLibTA := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TrvAllErn);

1882: hr_utility.set_location('py_za_tx_01032007.DirCalc',7);
1883: -- Travel Allowance Earnings
1884: trc_TrvAllErn := trc_TrvAllYtd + trc_FrnBenErn;
1885: -- Tax Liability
1886: trc_TotLibTA := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TrvAllErn);
1887: trc_LibFyTA := trc_TotLibTA - least(trc_TotLibTA,trc_TotLibFB);
1888: trc_TotLibTA := greatest(trc_TotLibTA,trc_TotLibFB);
1889: trc_LibFpTA := trc_LibFyTA - bal_TX_ON_TA_YTD;
1890: ELSE

Line 1909: trc_TotLibBP := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_BonProErn);

1905: hr_utility.set_location('py_za_tx_01032007.DirCalc',9);
1906: -- Bonus Provision Earnings
1907: trc_BonProErn := trc_BonProYtd + trc_TrvAllErn;
1908: -- Tax Liability
1909: trc_TotLibBP := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_BonProErn);
1910: trc_LibFyBP := trc_TotLibBP - least(trc_TotLibBP,trc_TotLibTA);
1911: trc_TotLibBP := greatest(trc_TotLibBP,trc_TotLibTA);
1912: trc_LibFpBP := trc_LibFyBP - bal_TX_ON_BP_YTD;
1913: ELSE

Line 1932: trc_TotLibAB := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_AnnBonErn);

1928: hr_utility.set_location('py_za_tx_01032007.DirCalc',11);
1929: -- Annual Bonus Earnings
1930: trc_AnnBonErn := trc_AnnBonYtd + trc_TrvAllErn;
1931: -- Tax Liability
1932: trc_TotLibAB := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_AnnBonErn);
1933: trc_LibFyAB := trc_TotLibAB - least(trc_TotLibAB,trc_TotLibTA);
1934: trc_TotLibAB := greatest(trc_TotLibAB,trc_TotLibTA);
1935: -- Check Bonus Provision
1936: IF trc_BonProYtd <> 0 THEN

Line 1939: IF dbi_BP_TX_RCV = 'B' OR py_za_tx_utl_01032007.SitePeriod THEN

1935: -- Check Bonus Provision
1936: IF trc_BonProYtd <> 0 THEN
1937: hr_utility.set_location('py_za_tx_01032007.DirCalc',12);
1938: -- Check Bonus Provision Frequency
1939: IF dbi_BP_TX_RCV = 'B' OR py_za_tx_utl_01032007.SitePeriod THEN
1940: hr_utility.set_location('py_za_tx_01032007.DirCalc',13);
1941: trc_LibFpAB :=
1942: trc_LibFyAB - (bal_TX_ON_BP_YTD
1943: + trc_LibFpBP

Line 1959: IF dbi_BP_TX_RCV = 'A' AND py_za_tx_utl_01032007.SitePeriod THEN

1955: -- Set Cascade Figures and Refund
1956: trc_LibFpAB := -1 * bal_TX_ON_AB_YTD;
1957: trc_LibFpABOvr := TRUE;
1958:
1959: IF dbi_BP_TX_RCV = 'A' AND py_za_tx_utl_01032007.SitePeriod THEN
1960: hr_utility.set_location('py_za_tx_01032007.DirCalc',17);
1961: trc_LibFpBP := -1 * bal_TX_ON_BP_YTD;
1962: trc_LibFpBPOvr := TRUE;
1963: trc_LibFpAPOvr := TRUE;

Line 1984: trc_TotLibAP := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_AnnPymErn);

1980: hr_utility.set_location('py_za_tx_01032007.DirCalc',19);
1981: -- Annual Payments Earnings
1982: trc_AnnPymErn := trc_AnnPymYtd + trc_AnnBonErn;
1983: -- Tax Liability
1984: trc_TotLibAP := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_AnnPymErn);
1985: trc_LibFyAP := trc_TotLibAP - least(trc_TotLibAP,trc_TotLibAB);
1986: trc_TotLibAP := greatest(trc_TotLibAP,trc_TotLibAB);
1987: trc_LibFpAP := trc_LibFyAP - bal_TX_ON_AP_YTD;
1988: ElSE

Line 2007: trc_TotLibPO := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_PblOffErn);

2003: hr_utility.set_location('py_za_tx_01032007.DirCalc',21);
2004: -- Public Office Allowance Earnings
2005: trc_PblOffErn := trc_PblOffYtd + trc_AnnPymErn;
2006: -- Tax Liability
2007: trc_TotLibPO := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_PblOffErn);
2008: trc_LibFyPO := trc_TotLibPO - least(trc_TotLibPO,trc_TotLibAP);
2009: trc_TotLibPO := greatest(trc_TotLibPO,trc_TotLibAP);
2010: trc_LibFpPO := trc_LibFyPO - bal_TX_ON_PO_YTD;
2011: ELSE

Line 2022: py_za_tx_utl_01032007.ValidateTaxOns(p_Rf => TRUE);

2018: END IF;
2019:
2020: -- Net Pay Validation
2021: --
2022: py_za_tx_utl_01032007.ValidateTaxOns(p_Rf => TRUE);
2023:
2024: hr_utility.set_location('py_za_tx_01032007.DirCalc',23);
2025:
2026: -- Tax Percentage Indicator

Line 2140: py_za_tx_utl_01032007.SetRebates;

2136: --
2137: trc_CalTyp := 'BasCalc';
2138:
2139: -- Rebates
2140: py_za_tx_utl_01032007.SetRebates;
2141:
2142: -- Abatements
2143: py_za_tx_utl_01032007.Abatements;
2144:

Line 2143: py_za_tx_utl_01032007.Abatements;

2139: -- Rebates
2140: py_za_tx_utl_01032007.SetRebates;
2141:
2142: -- Abatements
2143: py_za_tx_utl_01032007.Abatements;
2144:
2145: -- Deemed Remuneration
2146: --
2147: -- Run Deemed Remuneration

Line 2159: trc_TotLibDR := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbDmdRmn);

2155: -- Threshold Check
2156: IF trc_TxbDmdRmn >= trc_Threshold THEN
2157: hr_utility.set_location('py_za_tx_01032007.BasCalc',3);
2158: -- Tax Liability
2159: trc_TotLibDR := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbDmdRmn);
2160: ELSE
2161: hr_utility.set_location('py_za_tx_01032007.BasCalc',4);
2162: trc_TotLibDR := 0;
2163: END IF;

Line 2181: trc_TotLibBse := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbBseInc);

2177: -- Threshold Check
2178: IF trc_TxbBseInc >= trc_Threshold THEN
2179: hr_utility.set_location('py_za_tx_01032007.BasCalc',7);
2180: -- Tax Liability
2181: trc_TotLibBse := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbBseInc);
2182: trc_TotLibBse := greatest(trc_TotLibBse,trc_TotLibDR);
2183: ELSE
2184: hr_utility.set_location('py_za_tx_01032007.BasCalc',8);
2185: trc_TotLibBse := trc_TotLibDR;

Line 2205: trc_TotLibAB := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbAnnBonInc);

2201: -- Threshold Check
2202: IF trc_TxbAnnBonInc >= trc_Threshold THEN
2203: hr_utility.set_location('py_za_tx_01032007.BasCalc',11);
2204: -- Tax Liability
2205: trc_TotLibAB := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbAnnBonInc);
2206: trc_LibFyAB := trc_TotLibAB - least(trc_TotLibAB,trc_TotLibBse);
2207: trc_TotLibAB := greatest(trc_TotLibAB,trc_TotLibBse);
2208: -- Check Bonus Provision
2209: IF bal_BP_YTD <> 0 THEN

Line 2249: trc_TotLibAP := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbAnnPymInc);

2245: -- Threshold Check
2246: IF trc_TxbAnnPymInc >= trc_Threshold THEN
2247: hr_utility.set_location('py_za_tx_01032007.BasCalc',20);
2248: -- Tax Liability
2249: trc_TotLibAP := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbAnnPymInc);
2250: trc_LibFyAP := trc_TotLibAP - least(trc_TotLibAP,trc_TotLibAB);
2251: trc_TotLibAP := greatest(trc_TotLibAP,trc_TotLibAB);
2252: trc_LibFpAP := trc_LibFyAP - bal_TX_ON_AP_YTD;
2253: ELSE

Line 2264: py_za_tx_utl_01032007.ValidateTaxOns;

2260: END IF;
2261:
2262: -- Net Pay Validation
2263: --
2264: py_za_tx_utl_01032007.ValidateTaxOns;
2265:
2266: -- Deemed Remuneration
2267: WrtHrTrc('trc_TxbDmdRmn: '||to_char(trc_TxbDmdRmn));
2268: WrtHrTrc('trc_TotLibDR: '||to_char(trc_TotLibDR));

Line 2356: py_za_tx_utl_01032007.TrvAll;

2352: trc_CalTyp := 'CalCalc';
2353:
2354: -- Update Global Balance Values with correct TAXABLE values
2355: --
2356: py_za_tx_utl_01032007.TrvAll;
2357:
2358: hr_utility.set_location('py_za_tx_01032007.CalCalc',2);
2359:
2360: -- Calendar Ytd Taxable Income

Line 2374: trc_SitFactor := dbi_ZA_DYS_IN_YR / py_za_tx_utl_01032007.DaysWorked;

2370: ELSE -- continue CalCalc
2371: hr_utility.set_location('py_za_tx_01032007.CalCalc',4);
2372: -- Site Factor
2373: --
2374: trc_SitFactor := dbi_ZA_DYS_IN_YR / py_za_tx_utl_01032007.DaysWorked;
2375:
2376: -- Rebates
2377: py_za_tx_utl_01032007.SetRebates;
2378:

Line 2377: py_za_tx_utl_01032007.SetRebates;

2373: --
2374: trc_SitFactor := dbi_ZA_DYS_IN_YR / py_za_tx_utl_01032007.DaysWorked;
2375:
2376: -- Rebates
2377: py_za_tx_utl_01032007.SetRebates;
2378:
2379: -- Abatements
2380: py_za_tx_utl_01032007.Abatements;
2381:

Line 2380: py_za_tx_utl_01032007.Abatements;

2376: -- Rebates
2377: py_za_tx_utl_01032007.SetRebates;
2378:
2379: -- Abatements
2380: py_za_tx_utl_01032007.Abatements;
2381:
2382: hr_utility.set_location('py_za_tx_01032007.CalCalc',5);
2383:
2384: -- Deemed Remuneration

Line 2398: trc_TotLibDR := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbDmdRmn);

2394: -- Threshold Check
2395: IF trc_TxbDmdRmn >= trc_Threshold THEN
2396: hr_utility.set_location('py_za_tx_01032007.CalCalc',7);
2397: -- Tax Liability
2398: trc_TotLibDR := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbDmdRmn);
2399: ELSE
2400: hr_utility.set_location('py_za_tx_01032007.CalCalc',8);
2401: trc_TotLibDR := 0;
2402: END IF;

Line 2420: trc_TotLibBse := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbBseInc);

2416: -- Threshold Check
2417: IF trc_TxbBseInc >= trc_Threshold THEN
2418: hr_utility.set_location('py_za_tx_01032007.CalCalc',11);
2419: -- Tax Liability
2420: trc_TotLibBse := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbBseInc);
2421: trc_TotLibBse := greatest(trc_TotLibBse,trc_TotLibDR);
2422: ELSE
2423: hr_utility.set_location('py_za_tx_01032007.CalCalc',12);
2424: trc_TotLibBse := trc_TotLibDR;

Line 2444: trc_TotLibAB := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbAnnBonInc);

2440: -- Threshold Check
2441: IF trc_TxbAnnBonInc >= trc_Threshold THEN
2442: hr_utility.set_location('py_za_tx_01032007.CalCalc',15);
2443: -- Tax Liability
2444: trc_TotLibAB := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbAnnBonInc);
2445: trc_LibFyAB := trc_TotLibAB - least(trc_TotLibAB,trc_TotLibBse);
2446: trc_TotLibAB := greatest(trc_TotLibAB,trc_TotLibBse);
2447: -- Check Bonus Provision
2448: IF bal_BP_YTD <> 0 THEN

Line 2491: trc_TotLibAP := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbAnnPymInc);

2487: -- Threshold Check
2488: IF trc_TxbAnnPymInc >= trc_Threshold THEN
2489: hr_utility.set_location('py_za_tx_01032007.CalCalc',24);
2490: -- Tax Liability
2491: trc_TotLibAP := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbAnnPymInc);
2492: trc_LibFyAP := trc_TotLibAP - least(trc_TotLibAP,trc_TotLibAB);
2493: trc_TotLibAP := greatest(trc_TotLibAP,trc_TotLibAB);
2494: trc_LibFpAP := trc_LibFyAP - bal_TX_ON_AP_YTD;
2495: ELSE

Line 2508: py_za_tx_utl_01032007.ValidateTaxOns;

2504: END IF;
2505:
2506: -- Net pay Validation
2507: --
2508: py_za_tx_utl_01032007.ValidateTaxOns;
2509:
2510: -- Deemed Remuneration
2511: WrtHrTrc('trc_TxbDmdRmn: '||to_char(trc_TxbDmdRmn));
2512: WrtHrTrc('trc_TotLibDR: '||to_char(trc_TotLibDR));

Line 2602: py_za_tx_utl_01032007.TrvAll;

2598: --
2599: trc_CalTyp := 'YtdCalc';
2600:
2601: -- Update Global Balance Values with correct TAXABLE values
2602: py_za_tx_utl_01032007.TrvAll;
2603:
2604: hr_utility.set_location('py_za_tx_01032007.YtdCalc',2);
2605:
2606: -- Ytd Taxable Income

Line 2620: trc_SitFactor := dbi_ZA_DYS_IN_YR / py_za_tx_utl_01032007.DaysWorked;

2616: CalCalc;
2617: ELSE --Continue YtdCalc
2618: hr_utility.set_location('py_za_tx_01032007.YtdCalc',4);
2619: -- Site Factor
2620: trc_SitFactor := dbi_ZA_DYS_IN_YR / py_za_tx_utl_01032007.DaysWorked;
2621:
2622: -- Rebates
2623: py_za_tx_utl_01032007.SetRebates;
2624:

Line 2623: py_za_tx_utl_01032007.SetRebates;

2619: -- Site Factor
2620: trc_SitFactor := dbi_ZA_DYS_IN_YR / py_za_tx_utl_01032007.DaysWorked;
2621:
2622: -- Rebates
2623: py_za_tx_utl_01032007.SetRebates;
2624:
2625: -- Abatements
2626: py_za_tx_utl_01032007.Abatements;
2627:

Line 2626: py_za_tx_utl_01032007.Abatements;

2622: -- Rebates
2623: py_za_tx_utl_01032007.SetRebates;
2624:
2625: -- Abatements
2626: py_za_tx_utl_01032007.Abatements;
2627:
2628: hr_utility.set_location('py_za_tx_01032007.YtdCalc',5);
2629:
2630: -- Deemed Remuneration

Line 2644: trc_TotLibDR := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbDmdRmn);

2640: -- Threshold Check
2641: IF trc_TxbDmdRmn >= trc_Threshold THEN
2642: hr_utility.set_location('py_za_tx_01032007.YtdCalc',7);
2643: -- Tax Liability
2644: trc_TotLibDR := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbDmdRmn);
2645: ELSE
2646: hr_utility.set_location('py_za_tx_01032007.YtdCalc',8);
2647: trc_TotLibDR := 0;
2648: END IF;

Line 2666: trc_TotLibBse := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbBseInc);

2662: -- Threshold Check
2663: IF trc_TxbBseInc >= trc_Threshold THEN
2664: hr_utility.set_location('py_za_tx_01032007.YtdCalc',11);
2665: -- Tax Liability
2666: trc_TotLibBse := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbBseInc);
2667: trc_TotLibBse := greatest(trc_TotLibBse,trc_TotLibDR);
2668: ELSE
2669: hr_utility.set_location('py_za_tx_01032007.YtdCalc',12);
2670: trc_TotLibBse := trc_TotLibDR;

Line 2690: trc_TotLibAB := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbAnnBonInc);

2686: -- Threshold Check
2687: IF trc_TxbAnnBonInc >= trc_Threshold THEN
2688: hr_utility.set_location('py_za_tx_01032007.YtdCalc',15);
2689: -- Tax Liability
2690: trc_TotLibAB := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbAnnBonInc);
2691: trc_LibFyAB := trc_TotLibAB - least(trc_TotLibAB,trc_TotLibBse);
2692: trc_TotLibAB := greatest(trc_TotLibAB,trc_TotLibBse);
2693: -- Check Bonus Provision
2694: IF bal_BP_YTD <> 0 THEN

Line 2737: trc_TotLibAP := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbAnnPymInc);

2733: -- Threshold Check
2734: IF trc_TxbAnnPymInc >= trc_Threshold THEN
2735: hr_utility.set_location('py_za_tx_01032007.YtdCalc',24);
2736: -- Tax Liability
2737: trc_TotLibAP := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbAnnPymInc);
2738: trc_LibFyAP := trc_TotLibAP - least(trc_TotLibAP,trc_TotLibAB);
2739: trc_TotLibAP := greatest(trc_TotLibAP,trc_TotLibAB);
2740: trc_LibFpAP := trc_LibFyAP - bal_TX_ON_AP_YTD;
2741: ELSE

Line 2754: py_za_tx_utl_01032007.ValidateTaxOns;

2750: END IF;
2751:
2752: -- Net Pay validation
2753: --
2754: py_za_tx_utl_01032007.ValidateTaxOns;
2755:
2756: hr_utility.set_location('py_za_tx_01032007.YtdCalc',27);
2757:
2758: -- Deemed Remuneration

Line 2851: py_za_tx_utl_01032007.TrvAll;

2847: -- Update Global Balance Values with correct TAXABLE values
2848: --
2849: bal_TOT_TXB_TA_PTD := bal_TOT_TXB_TA_PTD * glb_ZA_TRV_ALL_TX_PRC / 100;
2850:
2851: py_za_tx_utl_01032007.TrvAll;
2852:
2853: hr_utility.set_location('py_za_tx_01032007.NorCalc',2);
2854:
2855: bal_TOT_TXB_PO_PTD := bal_TOT_TXB_PO_PTD * glb_ZA_PBL_TX_PRC / 100;

Line 2867: py_za_tx_utl_01032007.PeriodFactor;

2863: + bal_TOT_TXB_TA_PTD
2864: + bal_BP_PTD
2865: );
2866: -- Period Factor
2867: py_za_tx_utl_01032007.PeriodFactor;
2868:
2869: -- Possible Periods Factor
2870: py_za_tx_utl_01032007.PossiblePeriodsFactor;
2871:

Line 2870: py_za_tx_utl_01032007.PossiblePeriodsFactor;

2866: -- Period Factor
2867: py_za_tx_utl_01032007.PeriodFactor;
2868:
2869: -- Possible Periods Factor
2870: py_za_tx_utl_01032007.PossiblePeriodsFactor;
2871:
2872: -- Rebates
2873: py_za_tx_utl_01032007.SetRebates;
2874:

Line 2873: py_za_tx_utl_01032007.SetRebates;

2869: -- Possible Periods Factor
2870: py_za_tx_utl_01032007.PossiblePeriodsFactor;
2871:
2872: -- Rebates
2873: py_za_tx_utl_01032007.SetRebates;
2874:
2875: -- Abatements
2876: py_za_tx_utl_01032007.Abatements;
2877:

Line 2876: py_za_tx_utl_01032007.Abatements;

2872: -- Rebates
2873: py_za_tx_utl_01032007.SetRebates;
2874:
2875: -- Abatements
2876: py_za_tx_utl_01032007.Abatements;
2877:
2878: hr_utility.set_location('py_za_tx_01032007.NorCalc',3);
2879:
2880: -- Deemed Remuneration

Line 2893: trc_TotLibDR := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbDmdRmn);

2889: -- Threshold Check
2890: IF trc_TxbDmdRmn >= trc_Threshold THEN
2891: hr_utility.set_location('py_za_tx_01032007.NorCalc',5);
2892: -- Tax Liability
2893: trc_TotLibDR := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbDmdRmn);
2894: trc_LibFyDR := trc_TotLibDR - 0;
2895: trc_TotLibDR := greatest(trc_TotLibDR,0);
2896: -- DeAnnualise
2897: trc_LibFpDR := py_za_tx_utl_01032007.DeAnnualise

Line 2897: trc_LibFpDR := py_za_tx_utl_01032007.DeAnnualise

2893: trc_TotLibDR := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbDmdRmn);
2894: trc_LibFyDR := trc_TotLibDR - 0;
2895: trc_TotLibDR := greatest(trc_TotLibDR,0);
2896: -- DeAnnualise
2897: trc_LibFpDR := py_za_tx_utl_01032007.DeAnnualise
2898: ( p_Liab => trc_LibFyDR
2899: , p_TxOnYtd => bal_TX_ON_DR_YTD
2900: , p_TxOnPtd => bal_TX_ON_DR_PTD
2901: );

Line 2927: trc_NorErn := py_za_tx_utl_01032007.Annualise

2923: IF trc_NorIncYtd <> 0 THEN
2924: hr_utility.set_location('py_za_tx_01032007.NorCalc',8);
2925:
2926: -- Annualise Normal Income
2927: trc_NorErn := py_za_tx_utl_01032007.Annualise
2928: (p_YtdInc => trc_NorIncYtd
2929: ,p_PtdInc => trc_NorIncPtd
2930: );
2931: -- Taxable Normal Income

Line 2937: trc_TotLibNI := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbNorInc);

2933: -- Threshold Check
2934: IF trc_TxbNorInc >= trc_Threshold THEN
2935: hr_utility.set_location('py_za_tx_01032007.NorCalc',9);
2936: -- Tax Liability
2937: trc_TotLibNI := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbNorInc);
2938: trc_LibFyNI := trc_TotLibNI - least(trc_TotLibNI,trc_TotLibDR);
2939: trc_TotLibNI := greatest(trc_TotLibNI,trc_TotLibDR);
2940: -- DeAnnualise
2941: trc_LibFpNI := py_za_tx_utl_01032007.DeAnnualise

Line 2941: trc_LibFpNI := py_za_tx_utl_01032007.DeAnnualise

2937: trc_TotLibNI := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbNorInc);
2938: trc_LibFyNI := trc_TotLibNI - least(trc_TotLibNI,trc_TotLibDR);
2939: trc_TotLibNI := greatest(trc_TotLibNI,trc_TotLibDR);
2940: -- DeAnnualise
2941: trc_LibFpNI := py_za_tx_utl_01032007.DeAnnualise
2942: ( p_Liab => trc_LibFyNI
2943: , p_TxOnYtd => bal_TX_ON_NI_YTD
2944: , p_TxOnPtd => bal_TX_ON_NI_PTD
2945: );

Line 2972: trc_FrnBenErn := py_za_tx_utl_01032007.Annualise

2968: IF trc_FrnBenYtd <> 0 THEN
2969: hr_utility.set_location('py_za_tx_01032007.NorCalc',12);
2970:
2971: -- Annualise Fringe Benefits
2972: trc_FrnBenErn := py_za_tx_utl_01032007.Annualise
2973: ( p_YtdInc => trc_FrnBenYtd
2974: , p_PtdInc => trc_FrnBenPtd
2975: ) + trc_NorErn;
2976: -- Taxable Fringe Income

Line 2982: trc_TotLibFB := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbFrnInc);

2978: -- Threshold Check
2979: IF trc_TxbFrnInc >= trc_Threshold THEN
2980: hr_utility.set_location('py_za_tx_01032007.NorCalc',13);
2981: -- Tax Liability
2982: trc_TotLibFB := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbFrnInc);
2983: trc_LibFyFB := trc_TotLibFB - least(trc_TotLibFB,trc_TotLibNI);
2984: trc_TotLibFB := greatest(trc_TotLibFB,trc_TotLibNI);
2985: -- DeAnnualise
2986: trc_LibFpFB := py_za_tx_utl_01032007.DeAnnualise

Line 2986: trc_LibFpFB := py_za_tx_utl_01032007.DeAnnualise

2982: trc_TotLibFB := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbFrnInc);
2983: trc_LibFyFB := trc_TotLibFB - least(trc_TotLibFB,trc_TotLibNI);
2984: trc_TotLibFB := greatest(trc_TotLibFB,trc_TotLibNI);
2985: -- DeAnnualise
2986: trc_LibFpFB := py_za_tx_utl_01032007.DeAnnualise
2987: ( trc_LibFyFB
2988: , bal_TX_ON_FB_YTD
2989: , bal_TX_ON_FB_PTD
2990: );

Line 3018: trc_TrvAllErn := py_za_tx_utl_01032007.Annualise

3014: hr_utility.set_location('py_za_tx_01032007.NorCalc',16);
3015: -- Ptd Travel Allowance
3016: trc_TrvAllPtd := bal_TOT_TXB_TA_PTD;
3017: -- Annualise Travel Allowance
3018: trc_TrvAllErn := py_za_tx_utl_01032007.Annualise
3019: ( p_YtdInc => trc_TrvAllYtd
3020: , p_PtdInc => trc_TrvAllPtd
3021: ) + trc_FrnBenErn;
3022: -- Taxable Travel Income

Line 3028: trc_TotLibTA := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbTrvInc);

3024: -- Threshold Check
3025: IF trc_TxbTrvInc >= trc_Threshold THEN
3026: hr_utility.set_location('py_za_tx_01032007.NorCalc',17);
3027: -- Tax Liability
3028: trc_TotLibTA := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbTrvInc);
3029: trc_LibFyTA := trc_TotLibTA - least(trc_TotLibTA,trc_TotLibFB);
3030: trc_TotLibTA := greatest(trc_TotLibTA,trc_TotLibFB);
3031: -- DeAnnualise
3032: trc_LibFpTA := py_za_tx_utl_01032007.DeAnnualise

Line 3032: trc_LibFpTA := py_za_tx_utl_01032007.DeAnnualise

3028: trc_TotLibTA := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbTrvInc);
3029: trc_LibFyTA := trc_TotLibTA - least(trc_TotLibTA,trc_TotLibFB);
3030: trc_TotLibTA := greatest(trc_TotLibTA,trc_TotLibFB);
3031: -- DeAnnualise
3032: trc_LibFpTA := py_za_tx_utl_01032007.DeAnnualise
3033: ( trc_LibFyTA
3034: , bal_TX_ON_TA_YTD
3035: , bal_TX_ON_TA_PTD
3036: );

Line 3062: trc_BonProErn := py_za_tx_utl_01032007.Annualise

3058: -- Skip the calculation if there is No Income
3059: IF trc_BonProYtd <> 0 THEN
3060: hr_utility.set_location('py_za_tx_01032007.NorCalc',20);
3061: -- Annualise Bonus Provision
3062: trc_BonProErn := py_za_tx_utl_01032007.Annualise
3063: ( p_YtdInc => trc_BonProYtd
3064: , p_PtdInc => trc_BonProPtd
3065: ) + trc_TrvAllErn;
3066: -- Taxable Bonus Provision Income

Line 3072: trc_TotLibBP := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbBonProInc);

3068: -- Threshold Check
3069: IF trc_TxbBonProInc >= trc_Threshold THEN
3070: hr_utility.set_location('py_za_tx_01032007.NorCalc',21);
3071: -- Tax Liability
3072: trc_TotLibBP := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbBonProInc);
3073: trc_LibFyBP := trc_TotLibBP - least(trc_TotLibBP,trc_TotLibTA);
3074: trc_TotLibBP := greatest(trc_TotLibBP,trc_TotLibTA);
3075: -- DeAnnualise
3076: trc_LibFpBP := py_za_tx_utl_01032007.DeAnnualise

Line 3076: trc_LibFpBP := py_za_tx_utl_01032007.DeAnnualise

3072: trc_TotLibBP := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbBonProInc);
3073: trc_LibFyBP := trc_TotLibBP - least(trc_TotLibBP,trc_TotLibTA);
3074: trc_TotLibBP := greatest(trc_TotLibBP,trc_TotLibTA);
3075: -- DeAnnualise
3076: trc_LibFpBP := py_za_tx_utl_01032007.DeAnnualise
3077: ( trc_LibFyBP
3078: , bal_TX_ON_BP_YTD
3079: , bal_TX_ON_BP_PTD
3080: );

Line 3113: trc_TotLibAB := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbAnnBonInc);

3109: -- Threshold Check
3110: IF trc_TxbAnnBonInc >= trc_Threshold THEN
3111: hr_utility.set_location('py_za_tx_01032007.NorCalc',25);
3112: -- Tax Liability
3113: trc_TotLibAB := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbAnnBonInc);
3114: trc_LibFyAB := trc_TotLibAB - least(trc_TotLibAB,trc_TotLibTA);
3115: trc_TotLibAB := greatest(trc_TotLibAB,trc_TotLibTA);
3116: -- Check Bonus Provision
3117: IF trc_BonProYtd <> 0 THEN

Line 3165: trc_TotLibAP := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbAnnPymInc);

3161: -- Threshold Check
3162: IF trc_TxbAnnPymInc >= trc_Threshold THEN
3163: hr_utility.set_location('py_za_tx_01032007.NorCalc',33);
3164: -- Tax Liability
3165: trc_TotLibAP := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbAnnPymInc);
3166: trc_LibFyAP := trc_TotLibAP - least(trc_TotLibAP,trc_TotLibAB);
3167: trc_TotLibAP := greatest(trc_TotLibAP,trc_TotLibAB);
3168: hr_utility.set_location('py_za_tx_01032007.NorCalc',34);
3169: trc_LibFpAP := trc_LibFyAP - bal_TX_ON_AP_YTD;

Line 3197: trc_PblOffErn := py_za_tx_utl_01032007.Annualise

3193: hr_utility.set_location('py_za_tx_01032007.NorCalc',37);
3194: -- Ptd Public Office Allowance
3195: trc_PblOffPtd := bal_TOT_TXB_PO_PTD;
3196: -- Annualise Public Office Allowance
3197: trc_PblOffErn := py_za_tx_utl_01032007.Annualise
3198: ( p_YtdInc => trc_PblOffYtd
3199: , p_PtdInc => trc_PblOffPtd
3200: ) + trc_AnnPymErn;
3201: -- Taxable Public Office Allowance

Line 3207: trc_TotLibPO := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbPblOffInc);

3203: -- Threshold Check
3204: IF trc_TxbPblOffInc >= trc_Threshold THEN
3205: hr_utility.set_location('py_za_tx_01032007.NorCalc',38);
3206: -- Tax Liability
3207: trc_TotLibPO := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbPblOffInc);
3208: trc_LibFyPO := trc_TotLibPO - least(trc_TotLibPO,trc_TotLibAP);
3209: trc_TotLibPO := greatest(trc_TotLibPO,trc_TotLibAP);
3210: -- DeAnnualise
3211: trc_LibFpPO := py_za_tx_utl_01032007.DeAnnualise

Line 3211: trc_LibFpPO := py_za_tx_utl_01032007.DeAnnualise

3207: trc_TotLibPO := py_za_tx_utl_01032007.TaxLiability(p_Amt => trc_TxbPblOffInc);
3208: trc_LibFyPO := trc_TotLibPO - least(trc_TotLibPO,trc_TotLibAP);
3209: trc_TotLibPO := greatest(trc_TotLibPO,trc_TotLibAP);
3210: -- DeAnnualise
3211: trc_LibFpPO := py_za_tx_utl_01032007.DeAnnualise
3212: ( trc_LibFyPO
3213: , bal_TX_ON_PO_YTD
3214: , bal_TX_ON_PO_PTD
3215: );

Line 3235: py_za_tx_utl_01032007.ValidateTaxOns;

3231: END IF;
3232:
3233: -- Net Pay Validation
3234: --
3235: py_za_tx_utl_01032007.ValidateTaxOns;
3236:
3237: hr_utility.set_location('py_za_tx_01032007.NorCalc',41);
3238:
3239: -- Deemed Remuneration

Line 3907: -- py_za_tx_utl_01032007.g_HrTraceEnabled := TRUE;

3903: BEGIN-- MAIN --
3904: -------------------------------------------------------------------------------
3905: -- Set hr_utility globals if debugging
3906: --
3907: -- py_za_tx_utl_01032007.g_HrTraceEnabled := TRUE;
3908: -- py_za_tx_utl_01032007.g_HrTracePipeName := 'ZATAX';
3909:
3910: -- Call hr_utility start procedure
3911: py_za_tx_utl_01032007.StartHrTrace;

Line 3908: -- py_za_tx_utl_01032007.g_HrTracePipeName := 'ZATAX';

3904: -------------------------------------------------------------------------------
3905: -- Set hr_utility globals if debugging
3906: --
3907: -- py_za_tx_utl_01032007.g_HrTraceEnabled := TRUE;
3908: -- py_za_tx_utl_01032007.g_HrTracePipeName := 'ZATAX';
3909:
3910: -- Call hr_utility start procedure
3911: py_za_tx_utl_01032007.StartHrTrace;
3912:

Line 3911: py_za_tx_utl_01032007.StartHrTrace;

3907: -- py_za_tx_utl_01032007.g_HrTraceEnabled := TRUE;
3908: -- py_za_tx_utl_01032007.g_HrTracePipeName := 'ZATAX';
3909:
3910: -- Call hr_utility start procedure
3911: py_za_tx_utl_01032007.StartHrTrace;
3912:
3913: -- Setup Trace Header Info
3914: WrtHrTrc(' ');
3915: WrtHrTrc(' ');

Line 4210: py_za_tx_utl_01032007.ValidateTaxOns;

4206: trc_CalTyp := 'NoCalc';
4207: -- Liability = entered value
4208: trc_LibFpNI := dbi_TX_DIR_VAL;
4209: -- Standard NetPay Validation
4210: py_za_tx_utl_01032007.ValidateTaxOns;
4211: END IF;
4212: -- D = Directive Percentage
4213: -- P = Private Director wth Directive Percentage
4214: --

Line 4231: -- Percentage taken into account in py_za_tx_utl_01032007.TaxLiability

4227: ELSE
4228: IF trc_OvrTxCalc AND trc_OvrTyp = 'P' THEN
4229: hr_utility.set_location('py_za_tx_01032007.ZaTx_01032007',16);
4230: trc_OvrWrn := 'WARNING: Tax Override - '||to_char(trc_OvrPrc)||' Percent';
4231: -- Percentage taken into account in py_za_tx_utl_01032007.TaxLiability
4232: END IF;
4233: -- Check Directive Number First
4234: IF dbi_TX_DIR_NUM = 'NULL' THEN
4235: hr_utility.set_location('py_za_tx_01032007.ZaTx_01032007',17);

Line 4276: -- Percentage taken into account in py_za_tx_utl_01032007.TaxLiability

4272: ELSE
4273: IF trc_OvrTxCalc AND trc_OvrTyp = 'P' THEN
4274: hr_utility.set_location('py_za_tx_01032007.ZaTx_01032007',25);
4275: trc_OvrWrn := 'WARNING: Tax Override - '||to_char(trc_OvrPrc)||' Percent';
4276: -- Percentage taken into account in py_za_tx_utl_01032007.TaxLiability
4277: END IF;
4278: hr_utility.set_location('py_za_tx_01032007.ZaTx_01032007',26);
4279: -- Simply Execute the Directive Calculation
4280: DirCalc;

Line 4306: py_za_tx_utl_01032007.SetRebates;

4302: IF trc_OvrTxCalc AND trc_OvrTyp = 'V' THEN
4303: hr_utility.set_location('py_za_tx_01032007.ZaTx_01032007',32);
4304: trc_CalTyp := 'OvrCalc';
4305: trc_OvrWrn := 'WARNING: Tax Override - Total Tax Value: '||to_char(trc_LibFpNI + trc_LibFpAP);
4306: py_za_tx_utl_01032007.SetRebates;
4307: ELSE
4308: hr_utility.set_location('py_za_tx_01032007.ZaTx_01032007',33);
4309: SeaCalc;
4310: END IF;

Line 4327: py_za_tx_utl_01032007.SetRebates;

4323: IF trc_OvrTxCalc AND trc_OvrTyp = 'V' THEN
4324: hr_utility.set_location('py_za_tx_01032007.ZaTx_01032007',35);
4325: trc_CalTyp := 'OvrCalc';
4326: trc_OvrWrn := 'WARNING: Tax Override - Total Tax Value: '||to_char(trc_LibFpNI + trc_LibFpAP);
4327: py_za_tx_utl_01032007.SetRebates;
4328: trc_SitFactor := dbi_ZA_DYS_IN_YR / py_za_tx_utl_01032007.DaysWorked;
4329: ELSIF trc_OvrTxCalc AND trc_OvrTyp = 'S' THEN
4330: hr_utility.set_location('py_za_tx_01032007.ZaTx_01032007',36);
4331: trc_CalTyp := 'OvrCalc';

Line 4328: trc_SitFactor := dbi_ZA_DYS_IN_YR / py_za_tx_utl_01032007.DaysWorked;

4324: hr_utility.set_location('py_za_tx_01032007.ZaTx_01032007',35);
4325: trc_CalTyp := 'OvrCalc';
4326: trc_OvrWrn := 'WARNING: Tax Override - Total Tax Value: '||to_char(trc_LibFpNI + trc_LibFpAP);
4327: py_za_tx_utl_01032007.SetRebates;
4328: trc_SitFactor := dbi_ZA_DYS_IN_YR / py_za_tx_utl_01032007.DaysWorked;
4329: ELSIF trc_OvrTxCalc AND trc_OvrTyp = 'S' THEN
4330: hr_utility.set_location('py_za_tx_01032007.ZaTx_01032007',36);
4331: trc_CalTyp := 'OvrCalc';
4332: trc_OvrWrn := 'WARNING: Tax Override - Forced Site Calculation';

Line 4340: -- Percentage taken into account in py_za_tx_utl_01032007.TaxLiability

4336: ELSE
4337: IF trc_OvrTxCalc AND trc_OvrTyp = 'P' THEN
4338: hr_utility.set_location('py_za_tx_01032007.ZaTx_01032007',38);
4339: trc_OvrWrn := 'WARNING: Tax Override - '||to_char(trc_OvrPrc)||' Percent';
4340: -- Percentage taken into account in py_za_tx_utl_01032007.TaxLiability
4341: END IF;
4342:
4343: hr_utility.set_location('py_za_tx_01032007.ZaTx_01032007',39);
4344: IF py_za_tx_utl_01032007.LatePayPeriod THEN

Line 4344: IF py_za_tx_utl_01032007.LatePayPeriod THEN

4340: -- Percentage taken into account in py_za_tx_utl_01032007.TaxLiability
4341: END IF;
4342:
4343: hr_utility.set_location('py_za_tx_01032007.ZaTx_01032007',39);
4344: IF py_za_tx_utl_01032007.LatePayPeriod THEN
4345: hr_utility.set_location('py_za_tx_01032007.ZaTx_01032007',40);
4346: LteCalc;
4347: -- Is this a SITE Period?
4348: ELSIF py_za_tx_utl_01032007.EmpTermPrePeriod THEN

Line 4348: ELSIF py_za_tx_utl_01032007.EmpTermPrePeriod THEN

4344: IF py_za_tx_utl_01032007.LatePayPeriod THEN
4345: hr_utility.set_location('py_za_tx_01032007.ZaTx_01032007',40);
4346: LteCalc;
4347: -- Is this a SITE Period?
4348: ELSIF py_za_tx_utl_01032007.EmpTermPrePeriod THEN
4349: hr_utility.set_location('py_za_tx_01032007.ZaTx_01032007',41);
4350: SitCalc;
4351: ELSIF py_za_tx_utl_01032007.LstPeriod OR py_za_tx_utl_01032007.EmpTermInPeriod THEN
4352: hr_utility.set_location('py_za_tx_01032007.ZaTx_01032007',42);

Line 4351: ELSIF py_za_tx_utl_01032007.LstPeriod OR py_za_tx_utl_01032007.EmpTermInPeriod THEN

4347: -- Is this a SITE Period?
4348: ELSIF py_za_tx_utl_01032007.EmpTermPrePeriod THEN
4349: hr_utility.set_location('py_za_tx_01032007.ZaTx_01032007',41);
4350: SitCalc;
4351: ELSIF py_za_tx_utl_01032007.LstPeriod OR py_za_tx_utl_01032007.EmpTermInPeriod THEN
4352: hr_utility.set_location('py_za_tx_01032007.ZaTx_01032007',42);
4353: IF py_za_tx_utl_01032007.PreErnPeriod THEN
4354: hr_utility.set_location('py_za_tx_01032007.ZaTx_01032007',43);
4355: YtdCalc;

Line 4353: IF py_za_tx_utl_01032007.PreErnPeriod THEN

4349: hr_utility.set_location('py_za_tx_01032007.ZaTx_01032007',41);
4350: SitCalc;
4351: ELSIF py_za_tx_utl_01032007.LstPeriod OR py_za_tx_utl_01032007.EmpTermInPeriod THEN
4352: hr_utility.set_location('py_za_tx_01032007.ZaTx_01032007',42);
4353: IF py_za_tx_utl_01032007.PreErnPeriod THEN
4354: hr_utility.set_location('py_za_tx_01032007.ZaTx_01032007',43);
4355: YtdCalc;
4356: ELSE
4357: hr_utility.set_location('py_za_tx_01032007.ZaTx_01032007',44);

Line 4363: IF py_za_tx_utl_01032007.PreErnPeriod THEN

4359: END IF;
4360: ElSE
4361: hr_utility.set_location('py_za_tx_01032007.ZaTx_01032007',45);
4362: -- The employee has NOT been terminated!
4363: IF py_za_tx_utl_01032007.PreErnPeriod THEN
4364: hr_utility.set_location('py_za_tx_01032007.ZaTx_01032007',46);
4365: YtdCalc;
4366: -- Bug 4346955 Bug 5148830
4367: /* ELSIF dbi_ZA_ASG_TX_RTR_PRD = 'Y' THEN

Line 4372: ELSIF py_za_tx_utl_01032007.NegPtd THEN

4368: hr_utility.set_location('py_za_tx_01032007.ZaTx_01032007',47);
4369: IF dbi_ZA_ASG_TAX_RTR_RSLTS = 'Y' THEN
4370: hr_utility.set_location('py_za_tx_01032007.ZaTx_01032007',48);
4371: SitCalc;
4372: ELSIF py_za_tx_utl_01032007.NegPtd THEN
4373: hr_utility.set_location('py_za_tx_01032007.ZaTx_01032007',49);
4374: SitCalc;
4375: ELSE
4376: hr_utility.set_location('py_za_tx_01032007.ZaTx_01032007',50);

Line 4379: ELSIF py_za_tx_utl_01032007.NegPtd THEN

4375: ELSE
4376: hr_utility.set_location('py_za_tx_01032007.ZaTx_01032007',50);
4377: NorCalc;
4378: END IF; */
4379: ELSIF py_za_tx_utl_01032007.NegPtd THEN
4380: hr_utility.set_location('py_za_tx_01032007.ZaTx_01032007',51);
4381: SitCalc;
4382: ELSE
4383: hr_utility.set_location('py_za_tx_01032007.ZaTx_01032007',52);

Line 4419: py_za_tx_utl_01032007.SitPaySplit;

4415: hr_utility.set_location('py_za_tx_01032007.ZaTx_01032007',57);
4416:
4417: -- Post Calculation Steps
4418: --
4419: py_za_tx_utl_01032007.SitPaySplit;
4420:
4421: hr_utility.set_location('py_za_tx_01032007.ZaTx_01032007',58);
4422:
4423: -- Execute the Arrear Processing

Line 4425: IF py_za_tx_utl_01032007.SitePeriod THEN

4421: hr_utility.set_location('py_za_tx_01032007.ZaTx_01032007',58);
4422:
4423: -- Execute the Arrear Processing
4424: --
4425: IF py_za_tx_utl_01032007.SitePeriod THEN
4426: hr_utility.set_location('py_za_tx_01032007.ZaTx_01032007',59);
4427: py_za_tx_utl_01032007.ArrearExcess;
4428: END IF;
4429:

Line 4427: py_za_tx_utl_01032007.ArrearExcess;

4423: -- Execute the Arrear Processing
4424: --
4425: IF py_za_tx_utl_01032007.SitePeriod THEN
4426: hr_utility.set_location('py_za_tx_01032007.ZaTx_01032007',59);
4427: py_za_tx_utl_01032007.ArrearExcess;
4428: END IF;
4429:
4430: hr_utility.set_location('py_za_tx_01032007.ZaTx_01032007',60);
4431:

Line 4513: py_za_tx_utl_01032007.Trace;

4509:
4510:
4511: -- Execute The Tax Trace
4512: --
4513: py_za_tx_utl_01032007.Trace;
4514:
4515: hr_utility.set_location('py_za_tx_01032007.ZaTx_01032007',65);
4516:
4517: -- Clear Globals

Line 4519: py_za_tx_utl_01032007.ClearGlobals;

4515: hr_utility.set_location('py_za_tx_01032007.ZaTx_01032007',65);
4516:
4517: -- Clear Globals
4518: --
4519: py_za_tx_utl_01032007.ClearGlobals;
4520:
4521: hr_utility.set_location('py_za_tx_01032007.ZaTx_01032007',66);
4522:
4523: -- End off Trace File

Line 4530: py_za_tx_utl_01032007.StopHrTrace;

4526: WrtHrTrc('------------------------------------------------------------');
4527: WrtHrTrc(' -- ');
4528:
4529: -- Call hr_utility stop procedure
4530: py_za_tx_utl_01032007.StopHrTrace;
4531:
4532: --dbms_debug.debug_off;
4533:
4534: RETURN l_Dum;

Line 4540: py_za_tx_utl_01032007.StopHrTrace;

4536: EXCEPTION
4537: WHEN xpt_FxdPrc THEN
4538: hr_utility.set_location('py_za_tx_01032007.ZaTx_01032007',67);
4539: WrtHrTrc('Sql error msg: Fixed Percentage was not entered');
4540: py_za_tx_utl_01032007.StopHrTrace;
4541: hr_utility.set_message(801, 'Fixed Percentage not entered');
4542: py_za_tx_utl_01032007.ClearGlobals;
4543: hr_utility.raise_error;
4544: WHEN xpt_E THEN

Line 4542: py_za_tx_utl_01032007.ClearGlobals;

4538: hr_utility.set_location('py_za_tx_01032007.ZaTx_01032007',67);
4539: WrtHrTrc('Sql error msg: Fixed Percentage was not entered');
4540: py_za_tx_utl_01032007.StopHrTrace;
4541: hr_utility.set_message(801, 'Fixed Percentage not entered');
4542: py_za_tx_utl_01032007.ClearGlobals;
4543: hr_utility.raise_error;
4544: WHEN xpt_E THEN
4545: hr_utility.set_location('py_za_tx_01032007.ZaTx_01032007',68);
4546: WrtHrTrc('xpt_Msg: '||xpt_Msg);

Line 4547: py_za_tx_utl_01032007.StopHrTrace;

4543: hr_utility.raise_error;
4544: WHEN xpt_E THEN
4545: hr_utility.set_location('py_za_tx_01032007.ZaTx_01032007',68);
4546: WrtHrTrc('xpt_Msg: '||xpt_Msg);
4547: py_za_tx_utl_01032007.StopHrTrace;
4548: hr_utility.set_message(801, xpt_Msg);
4549: py_za_tx_utl_01032007.ClearGlobals;
4550: hr_utility.raise_error;
4551: WHEN OTHERS THEN

Line 4549: py_za_tx_utl_01032007.ClearGlobals;

4545: hr_utility.set_location('py_za_tx_01032007.ZaTx_01032007',68);
4546: WrtHrTrc('xpt_Msg: '||xpt_Msg);
4547: py_za_tx_utl_01032007.StopHrTrace;
4548: hr_utility.set_message(801, xpt_Msg);
4549: py_za_tx_utl_01032007.ClearGlobals;
4550: hr_utility.raise_error;
4551: WHEN OTHERS THEN
4552: hr_utility.set_location('py_za_tx_01032007.ZaTx_01032007',69);
4553: WrtHrTrc('Sql error code: '||TO_CHAR(SQLCODE));

Line 4555: py_za_tx_utl_01032007.StopHrTrace;

4551: WHEN OTHERS THEN
4552: hr_utility.set_location('py_za_tx_01032007.ZaTx_01032007',69);
4553: WrtHrTrc('Sql error code: '||TO_CHAR(SQLCODE));
4554: WrtHrTrc('Sql error msg: '||SUBSTR(SQLERRM(SQLCODE), 1, 100));
4555: py_za_tx_utl_01032007.StopHrTrace;
4556: hr_utility.set_message(801, 'ZaTx_01032007: '||TO_CHAR(SQLCODE));
4557: py_za_tx_utl_01032007.ClearGlobals;
4558: hr_utility.raise_error;
4559: END ZaTx_01032007;

Line 4557: py_za_tx_utl_01032007.ClearGlobals;

4553: WrtHrTrc('Sql error code: '||TO_CHAR(SQLCODE));
4554: WrtHrTrc('Sql error msg: '||SUBSTR(SQLERRM(SQLCODE), 1, 100));
4555: py_za_tx_utl_01032007.StopHrTrace;
4556: hr_utility.set_message(801, 'ZaTx_01032007: '||TO_CHAR(SQLCODE));
4557: py_za_tx_utl_01032007.ClearGlobals;
4558: hr_utility.raise_error;
4559: END ZaTx_01032007;
4560:
4561: END PY_ZA_TX_01032007;