[Home] [Help]
28:
29:
30: PRIVATE PROCEDURES
31: WrtHrTrc
32: Wrapper procedure for py_za_tx_utl_01032012.WriteHrTrace
33: NetTxbIncCalc
34: Procedure to calculate a Net Taxable Income figure used
35: to properly calculate the Skills Development Levy
36: LteCalc
144: END get_def_bal_id;
145:
146: -------------------------------------------------------------------------------
147: -- WrtHrTrc
148: -- Wrapper for py_za_tx_utl_01032012.WriteHrTrace
149: -------------------------------------------------------------------------------
150: PROCEDURE WrtHrTrc(
151: p_Buf IN VARCHAR2
152: )
153: AS
154:
155: BEGIN
156:
157: py_za_tx_utl_01032012.WriteHrTrace(p_Buf);
158: END WrtHrTrc;
159:
160:
161: -------------------------------------------------------------------------------
1164: EXCEPTION
1165: WHEN OTHERS THEN
1166: WrtHrTrc('Sql error code: '||TO_CHAR(SQLCODE));
1167: WrtHrTrc('Sql error msg: '||SUBSTR(SQLERRM(SQLCODE), 1, 100));
1168: py_za_tx_utl_01032012.StopHrTrace;
1169: hr_utility.raise_error;
1170: END NetTxbSklDirNum;
1171:
1172: FUNCTION LSNetTxbInc(
1185: EXCEPTION
1186: WHEN OTHERS THEN
1187: WrtHrTrc('Sql error code: '||TO_CHAR(SQLCODE));
1188: WrtHrTrc('Sql error msg: '||SUBSTR(SQLERRM(SQLCODE), 1, 100));
1189: py_za_tx_utl_01032012.StopHrTrace;
1190: hr_utility.raise_error;
1191: END LSNetTxbInc;
1192:
1193: FUNCTION LSNetTxbIncUpd(
1205: EXCEPTION
1206: WHEN OTHERS THEN
1207: WrtHrTrc('Sql error code: '||TO_CHAR(SQLCODE));
1208: WrtHrTrc('Sql error msg: '||SUBSTR(SQLERRM(SQLCODE), 1, 100));
1209: py_za_tx_utl_01032012.StopHrTrace;
1210: hr_utility.raise_error;
1211: END LSNetTxbIncUpd;
1212:
1213:
1227: EXCEPTION
1228: WHEN OTHERS THEN
1229: WrtHrTrc('Sql error code: '||TO_CHAR(SQLCODE));
1230: WrtHrTrc('Sql error msg: '||SUBSTR(SQLERRM(SQLCODE), 1, 100));
1231: py_za_tx_utl_01032012.StopHrTrace;
1232: hr_utility.raise_error;
1233: END LSSkillsLevy;
1234:
1235: FUNCTION LSDirCount RETURN NUMBER
1245: EXCEPTION
1246: WHEN OTHERS THEN
1247: WrtHrTrc('Sql error code: '||TO_CHAR(SQLCODE));
1248: WrtHrTrc('Sql error msg: '||SUBSTR(SQLERRM(SQLCODE), 1, 100));
1249: py_za_tx_utl_01032012.StopHrTrace;
1250: hr_utility.raise_error;
1251: END LSDirCount;
1252:
1253: FUNCTION LSDirNetTxbInc(
1270: EXCEPTION
1271: WHEN OTHERS THEN
1272: WrtHrTrc('Sql error code: '||TO_CHAR(SQLCODE));
1273: WrtHrTrc('Sql error msg: '||SUBSTR(SQLERRM(SQLCODE), 1, 100));
1274: py_za_tx_utl_01032012.StopHrTrace;
1275: hr_utility.raise_error;
1276: END LSDirNetTxbInc;
1277:
1278: -- Bug 14376752
1411: l_StrtDte := dbi_ZA_ASG_TX_YR_STRT;
1412: l_EndDate := dbi_ZA_ASG_TX_YR_END;
1413: hr_utility.set_location('py_za_tx_01032012.LteCalc',8);
1414:
1415: trc_SitFactor := (l_EndDate - l_StrtDte + 1) / py_za_tx_utl_01032012.DaysWorked;
1416: hr_utility.set_location('py_za_tx_01032012.LteCalc',9);
1417:
1418: -- Populate Local Balance Variables
1419: -- The PTD Globals are used as dummy to store the previous tax year's
1457: hr_utility.set_location('py_za_tx_01032012.LteCalc',10);
1458:
1459: -- Update Globals with Correct Taxable Values
1460: Fix for bug#10372926
1461: --py_za_tx_utl_01032012.TrvAll;
1462:
1463: -- Bug 8691928
1464: -- removed newlines between various operands of the expression
1465: bal_TOT_TXB_PO_PTD := bal_TOT_TXB_PO_PTD * py_za_tx_utl_01032012.GlbVal('ZA_PUBL_TAX_PERC',l_EndDate) / 100;
1461: --py_za_tx_utl_01032012.TrvAll;
1462:
1463: -- Bug 8691928
1464: -- removed newlines between various operands of the expression
1465: bal_TOT_TXB_PO_PTD := bal_TOT_TXB_PO_PTD * py_za_tx_utl_01032012.GlbVal('ZA_PUBL_TAX_PERC',l_EndDate) / 100;
1466: hr_utility.set_location('py_za_tx_01032012.LteCalc',11);
1467:
1468: -- Rebates
1469: py_za_tx_utl_01032012.SetRebates;
1465: bal_TOT_TXB_PO_PTD := bal_TOT_TXB_PO_PTD * py_za_tx_utl_01032012.GlbVal('ZA_PUBL_TAX_PERC',l_EndDate) / 100;
1466: hr_utility.set_location('py_za_tx_01032012.LteCalc',11);
1467:
1468: -- Rebates
1469: py_za_tx_utl_01032012.SetRebates;
1470: -- Abatements
1471: py_za_tx_utl_01032012.Abatements;
1472:
1473: hr_utility.set_location('py_za_tx_01032012.LteCalc',12);
1467:
1468: -- Rebates
1469: py_za_tx_utl_01032012.SetRebates;
1470: -- Abatements
1471: py_za_tx_utl_01032012.Abatements;
1472:
1473: hr_utility.set_location('py_za_tx_01032012.LteCalc',12);
1474:
1475: -- Base Earnings
1491: --TYS2010
1492: --Suffixed the variable with WoDon to denote that donation amount is not deducted.
1493: /*
1494: trc_TxbBseIncWoDon := trc_BseErn - trc_AnnTotNTGAbm;
1495: trc_TxbBseInc :=trc_TxbBseIncWoDon - py_za_tx_utl_01032012.AllowableDeduction(trc_TxbBseIncWoDon,trc_AnnDonAmt);
1496:
1497: -- Threshold Check
1498: IF trc_TxbBseInc >= trc_Threshold THEN
1499: hr_utility.set_location('py_za_tx_01032012.LteCalc',13);
1497: -- Threshold Check
1498: IF trc_TxbBseInc >= trc_Threshold THEN
1499: hr_utility.set_location('py_za_tx_01032012.LteCalc',13);
1500: -- Tax Liability
1501: trc_TotLibBse := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbBseInc);
1502: ELSE
1503: hr_utility.set_location('py_za_tx_01032012.LteCalc',14);
1504: trc_TotLibBse := 0;
1505: END IF;
1526: hr_utility.set_location('py_za_tx_01032012.LteCalc',16);
1527:
1528: -- Global Values
1529: l_ZA_TX_YR_END := l_EndDate;
1530: l_ZA_ADL_TX_RBT := py_za_tx_utl_01032012.GlbVal('ZA_ADDITIONAL_TAX_REBATE',l_EndDate);
1531: l_ZA_PRI_TX_RBT := py_za_tx_utl_01032012.GlbVal('ZA_PRIMARY_TAX_REBATE',l_EndDate);
1532: l_ZA_PRI_TX_THRSHLD := py_za_tx_utl_01032012.GlbVal('ZA_PRIM_TAX_THRESHOLD',l_EndDate);
1533: l_ZA_SC_TX_THRSHLD := py_za_tx_utl_01032012.GlbVal('ZA_SEC_TAX_THRESHOLD',l_EndDate);
1534:
1527:
1528: -- Global Values
1529: l_ZA_TX_YR_END := l_EndDate;
1530: l_ZA_ADL_TX_RBT := py_za_tx_utl_01032012.GlbVal('ZA_ADDITIONAL_TAX_REBATE',l_EndDate);
1531: l_ZA_PRI_TX_RBT := py_za_tx_utl_01032012.GlbVal('ZA_PRIMARY_TAX_REBATE',l_EndDate);
1532: l_ZA_PRI_TX_THRSHLD := py_za_tx_utl_01032012.GlbVal('ZA_PRIM_TAX_THRESHOLD',l_EndDate);
1533: l_ZA_SC_TX_THRSHLD := py_za_tx_utl_01032012.GlbVal('ZA_SEC_TAX_THRESHOLD',l_EndDate);
1534:
1535: -- Calculate the assignments 65 Year Date
1528: -- Global Values
1529: l_ZA_TX_YR_END := l_EndDate;
1530: l_ZA_ADL_TX_RBT := py_za_tx_utl_01032012.GlbVal('ZA_ADDITIONAL_TAX_REBATE',l_EndDate);
1531: l_ZA_PRI_TX_RBT := py_za_tx_utl_01032012.GlbVal('ZA_PRIMARY_TAX_REBATE',l_EndDate);
1532: l_ZA_PRI_TX_THRSHLD := py_za_tx_utl_01032012.GlbVal('ZA_PRIM_TAX_THRESHOLD',l_EndDate);
1533: l_ZA_SC_TX_THRSHLD := py_za_tx_utl_01032012.GlbVal('ZA_SEC_TAX_THRESHOLD',l_EndDate);
1534:
1535: -- Calculate the assignments 65 Year Date
1536: l_65Year := add_months(dbi_PER_DTE_OF_BRTH,780);
1529: l_ZA_TX_YR_END := l_EndDate;
1530: l_ZA_ADL_TX_RBT := py_za_tx_utl_01032012.GlbVal('ZA_ADDITIONAL_TAX_REBATE',l_EndDate);
1531: l_ZA_PRI_TX_RBT := py_za_tx_utl_01032012.GlbVal('ZA_PRIMARY_TAX_REBATE',l_EndDate);
1532: l_ZA_PRI_TX_THRSHLD := py_za_tx_utl_01032012.GlbVal('ZA_PRIM_TAX_THRESHOLD',l_EndDate);
1533: l_ZA_SC_TX_THRSHLD := py_za_tx_utl_01032012.GlbVal('ZA_SEC_TAX_THRESHOLD',l_EndDate);
1534:
1535: -- Calculate the assignments 65 Year Date
1536: l_65Year := add_months(dbi_PER_DTE_OF_BRTH,780);
1537:
1555: -- Threshold Check
1556: IF trc_TxbBseInc >= trc_Threshold THEN
1557: hr_utility.set_location('py_za_tx_01032012.LteCalc',19);
1558: -- Tax Liability
1559: trc_TotLibBse := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbBseInc);
1560: ELSE
1561: hr_utility.set_location('py_za_tx_01032012.LteCalc',20);
1562: trc_TotLibBse := 0;
1563: END IF;
1575:
1576: hr_utility.set_location('py_za_tx_01032012.LteCalc',21);
1577:
1578: -- Rebates
1579: py_za_tx_utl_01032012.SetRebates;
1580: -- Abatements
1581: py_za_tx_utl_01032012.Abatements;
1582:
1583: hr_utility.set_location('py_za_tx_01032012.LteCalc',22);
1577:
1578: -- Rebates
1579: py_za_tx_utl_01032012.SetRebates;
1580: -- Abatements
1581: py_za_tx_utl_01032012.Abatements;
1582:
1583: hr_utility.set_location('py_za_tx_01032012.LteCalc',22);
1584:
1585: -- Update Global Balance Values with correct TAXABLE values
1583: hr_utility.set_location('py_za_tx_01032012.LteCalc',22);
1584:
1585: -- Update Global Balance Values with correct TAXABLE values
1586: Fix for bug#10372926
1587: --py_za_tx_utl_01032012.TrvAll;
1588:
1589: bal_TOT_TXB_PO_YTD := bal_TOT_TXB_PO_YTD * glb_ZA_PBL_TX_PRC / 100;
1590:
1591: -- Normal Income
1600: -- Taxable Normal Income
1601: --TYS2010
1602: --Suffixed the variable with WoDon to denote that donation amount is not deducted.
1603: trc_TxbNorIncWoDon := trc_NorErn - trc_PerTotAbm;
1604: trc_TxbNorInc :=trc_TxbNorIncWoDon - py_za_tx_utl_01032012.AllowableDeduction(trc_TxbNorIncWoDon,trc_PerDonAmt);
1605:
1606: -- Threshold Check
1607: IF trc_TxbNorInc >= trc_Threshold THEN
1608: hr_utility.set_location('py_za_tx_01032012.LteCalc',24);
1606: -- Threshold Check
1607: IF trc_TxbNorInc >= trc_Threshold THEN
1608: hr_utility.set_location('py_za_tx_01032012.LteCalc',24);
1609: -- Tax Liability
1610: trc_TotLibNI := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbNorInc);
1611: trc_LibFyNI := trc_TotLibNI - least(trc_TotLibNI,trc_TotLibBse);
1612: trc_TotLibNI := greatest(trc_TotLibNI,trc_TotLibBse);
1613: trc_LibFpNI := trc_LibFyNI - bal_TX_ON_NI_YTD;
1614: ELSE
1639: -- Taxable Fringe Income
1640: --TYS2010
1641: --Suffixed the variable with WoDon to denote that donation amount is not deducted.
1642: trc_TxbFrnIncWoDon := trc_FrnBenErn - trc_PerTotAbm;
1643: trc_TxbFrnInc :=trc_TxbFrnIncWoDon - py_za_tx_utl_01032012.AllowableDeduction(trc_TxbFrnIncWoDon,trc_PerDonAmt);
1644:
1645: -- Threshold Check
1646: IF trc_TxbFrnInc >= trc_Threshold THEN
1647: hr_utility.set_location('py_za_tx_01032012.LteCalc',28);
1645: -- Threshold Check
1646: IF trc_TxbFrnInc >= trc_Threshold THEN
1647: hr_utility.set_location('py_za_tx_01032012.LteCalc',28);
1648: -- Tax Liability
1649: trc_TotLibFB := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbFrnInc);
1650: trc_LibFyFB := trc_TotLibFB - least(trc_TotLibFB,trc_TotLibNI);
1651: trc_TotLibFB := greatest(trc_TotLibFB,trc_TotLibNI);
1652: trc_LibFpFB := trc_LibFyFB - bal_TX_ON_FB_YTD;
1653: ElSE
1679: -- Taxable Travel Income
1680: --TYS2010
1681: --Suffixed the variable with WoDon to denote that donation amount is not deducted.
1682: trc_TxbTrvIncWoDon := trc_TrvAllErn - trc_PerTotAbm;
1683: trc_TxbTrvInc :=trc_TxbTrvIncWoDon - py_za_tx_utl_01032012.AllowableDeduction(trc_TxbTrvIncWoDon,trc_PerDonAmt);
1684:
1685: -- Threshold Check
1686: IF trc_TxbTrvInc >= trc_Threshold THEN
1687: hr_utility.set_location('py_za_tx_01032012.LteCalc',32);
1685: -- Threshold Check
1686: IF trc_TxbTrvInc >= trc_Threshold THEN
1687: hr_utility.set_location('py_za_tx_01032012.LteCalc',32);
1688: -- Tax Liability
1689: trc_TotLibTA := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbTrvInc);
1690: trc_LibFyTA := trc_TotLibTA - least(trc_TotLibTA,trc_TotLibFB);
1691: trc_TotLibTA := greatest(trc_TotLibTA,trc_TotLibFB);
1692: trc_LibFpTA := trc_LibFyTA - bal_TX_ON_TA_YTD;
1693: ELSE
1719: -- Taxable Annual Bonus Income
1720: --TYS2010
1721: --Suffixed the variable with WoDon to denote that donation amount is not deducted.
1722: trc_TxbAnnBonIncWoDon := trc_AnnBonErn - trc_AnnTotAbm;
1723: trc_TxbAnnBonInc :=trc_TxbAnnBonIncWoDon - py_za_tx_utl_01032012.AllowableDeduction(trc_TxbAnnBonIncWoDon,trc_AnnDonAmt);
1724:
1725: -- Threshold Check
1726: IF trc_TxbAnnBonInc >= trc_Threshold THEN
1727: hr_utility.set_location('py_za_tx_01032012.LteCalc',36);
1725: -- Threshold Check
1726: IF trc_TxbAnnBonInc >= trc_Threshold THEN
1727: hr_utility.set_location('py_za_tx_01032012.LteCalc',36);
1728: -- Tax Liability
1729: trc_TotLibAB := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbAnnBonInc);
1730: trc_LibFyAB := trc_TotLibAB - least(trc_TotLibAB,trc_TotLibTA);
1731: trc_TotLibAB := greatest(trc_TotLibAB,trc_TotLibTA);
1732: trc_LibFpAB := trc_LibFyAB - bal_TX_ON_AB_YTD;
1733: ELSE
1759: -- Taxable Annual Payments Income
1760: --TYS2010
1761: --Suffixed the variable with WoDon to denote that donation amount is not deducted.
1762: trc_TxbAnnPymIncWoDon := trc_AnnPymErn - trc_AnnTotAbm;
1763: trc_TxbAnnPymInc :=trc_TxbAnnPymIncWoDon - py_za_tx_utl_01032012.AllowableDeduction(trc_TxbAnnPymIncWoDon,trc_AnnDonAmt);
1764:
1765: -- Threshold Check
1766: IF trc_TxbAnnPymInc >= trc_Threshold THEN
1767: hr_utility.set_location('py_za_tx_01032012.LteCalc',42);
1765: -- Threshold Check
1766: IF trc_TxbAnnPymInc >= trc_Threshold THEN
1767: hr_utility.set_location('py_za_tx_01032012.LteCalc',42);
1768: -- Tax Liability
1769: trc_TotLibAP := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbAnnPymInc);
1770: trc_LibFyAP := trc_TotLibAP - least(trc_TotLibAP,trc_TotLibAB);
1771: trc_TotLibAP := greatest(trc_TotLibAP,trc_TotLibAB);
1772: trc_LibFpAP := trc_LibFyAP - bal_TX_ON_AP_YTD;
1773: ELSE
1799: -- Taxable Public Office Allowance
1800: --TYS2010
1801: --Suffixed the variable with WoDon to denote that donation amount is not deducted.
1802: trc_TxbPblOffIncWoDon := trc_PblOffErn - trc_AnnTotAbm;
1803: trc_TxbPblOffInc :=trc_TxbPblOffIncWoDon - py_za_tx_utl_01032012.AllowableDeduction(trc_TxbPblOffIncWoDon,trc_AnnDonAmt);
1804:
1805: -- Threshold Check
1806: IF trc_TxbPblOffInc >= trc_Threshold THEN
1807: hr_utility.set_location('py_za_tx_01032012.LteCalc',48);
1805: -- Threshold Check
1806: IF trc_TxbPblOffInc >= trc_Threshold THEN
1807: hr_utility.set_location('py_za_tx_01032012.LteCalc',48);
1808: -- Tax Liability
1809: trc_TotLibPO := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbPblOffInc);
1810: trc_LibFyPO := trc_TotLibPO - least(trc_TotLibPO,trc_TotLibAP);
1811: trc_TotLibPO := greatest(trc_TotLibPO,trc_TotLibAP);
1812: trc_LibFpPO := trc_LibFyPO - bal_TX_ON_PO_YTD;
1813: ElSE
1839: hr_utility.set_location('py_za_tx_01032012.LteCalc',52);
1840: l_Sl := FALSE;
1841: END IF;
1842:
1843: py_za_tx_utl_01032012.ValidateTaxOns(p_Rf => l_Sl);
1844:
1845: -- Set IT3A Indicator
1846: --
1847: IF trc_TxbAnnPymInc + trc_PblOffErn >= trc_Threshold THEN
1929: trc_SitFactor := 1;
1930: trc_LateSitePaye := 0;
1931:
1932: --Fix for bug#10372926
1933: --py_za_tx_utl_01032012.TrvAll;
1934: py_za_tx_utl_01032012.SetRebates;
1935:
1936: hr_utility.set_location('py_za_tx_01032012.LteCalc',2);
1937:
1930: trc_LateSitePaye := 0;
1931:
1932: --Fix for bug#10372926
1933: --py_za_tx_utl_01032012.TrvAll;
1934: py_za_tx_utl_01032012.SetRebates;
1935:
1936: hr_utility.set_location('py_za_tx_01032012.LteCalc',2);
1937:
1938: bal_TOT_TXB_PO_YTD := bal_TOT_TXB_PO_YTD * glb_ZA_PBL_TX_PRC / 100;
1946: hr_utility.set_location('py_za_tx_01032012.LteCalc',3);
1947: -- Normal Earnings
1948: trc_NorErn := trc_NorIncYtd;
1949: -- Tax Liability
1950: trc_TotLibNI := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_NorErn);
1951: trc_LibFyNI := trc_TotLibNI - 0;
1952: trc_TotLibNI := greatest(trc_TotLibNI,0);
1953: trc_LibFpNI := trc_LibFyNI - bal_TX_ON_NI_YTD;
1954: ELSE
1969: hr_utility.set_location('py_za_tx_01032012.LteCalc',5);
1970: -- Fringe Benefit Earnings
1971: trc_FrnBenErn := trc_FrnBenYtd + trc_NorErn;
1972: -- Tax Liability
1973: trc_TotLibFB := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_FrnBenErn);
1974: trc_LibFyFB := trc_TotLibFB - least(trc_TotLibFB,trc_TotLibNI);
1975: trc_TotLibFB := greatest(trc_TotLibFB,trc_TotLibNI);
1976: trc_LibFpFB := trc_LibFyFB - bal_TX_ON_FB_YTD;
1977: ELSE
1992: hr_utility.set_location('py_za_tx_01032012.LteCalc',7);
1993: -- Travel Allowance Earnings
1994: trc_TrvAllErn := trc_TrvAllYtd + trc_FrnBenErn;
1995: -- Tax Liability
1996: trc_TotLibTA := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TrvAllErn);
1997: trc_LibFyTA := trc_TotLibTA - least(trc_TotLibTA,trc_TotLibFB);
1998: trc_TotLibTA := greatest(trc_TotLibTA,trc_TotLibFB);
1999: trc_LibFpTA := trc_LibFyTA - bal_TX_ON_TA_YTD;
2000: ELSE
2015: hr_utility.set_location('py_za_tx_01032012.LteCalc',9);
2016: -- Annual Bonus Earnings
2017: trc_AnnBonErn := trc_AnnBonYtd + trc_TrvAllErn;
2018: -- Tax Liability
2019: trc_TotLibAB := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_AnnBonErn);
2020: trc_LibFyAB := trc_TotLibAB - least(trc_TotLibAB,trc_TotLibTA);
2021: trc_TotLibAB := greatest(trc_TotLibAB,trc_TotLibTA);
2022: -- Check Bonus Provision
2023: trc_LibFpAB := trc_LibFyAB - bal_TX_ON_AB_YTD;
2038: hr_utility.set_location('py_za_tx_01032012.LteCalc',11);
2039: -- Annual Payments Earnings
2040: trc_AnnPymErn := trc_AnnPymYtd + trc_AnnBonErn;
2041: -- Tax Liability
2042: trc_TotLibAP := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_AnnPymErn);
2043: trc_LibFyAP := trc_TotLibAP - least(trc_TotLibAP,trc_TotLibAB);
2044: trc_TotLibAP := greatest(trc_TotLibAP,trc_TotLibAB);
2045: trc_LibFpAP := trc_LibFyAP - bal_TX_ON_AP_YTD;
2046: ElSE
2063: hr_utility.set_location('py_za_tx_01032012.LteCalc',13);
2064: -- Public Office Allowance Earnings
2065: trc_PblOffErn := trc_PblOffYtd + trc_AnnPymErn;
2066: -- Tax Liability
2067: trc_TotLibPO := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_PblOffErn);
2068: trc_LibFyPO := trc_TotLibPO - least(trc_TotLibPO,trc_TotLibAP);
2069: trc_TotLibPO := greatest(trc_TotLibPO,trc_TotLibAP);
2070: trc_LibFpPO := trc_LibFyPO - bal_TX_ON_PO_YTD;
2071: ELSE
2086: hr_utility.set_location('py_za_tx_01032012.LteCalc',52);
2087: l_Sl := FALSE;
2088: END IF;
2089:
2090: py_za_tx_utl_01032012.ValidateTaxOns(p_Rf => l_Sl);
2091:
2092: -- Set IT3A Indicator
2093: --
2094: IF trc_PblOffErn >= trc_Threshold THEN
2208: -- Threshold Check
2209: IF trc_TxbBseInc >= trc_Threshold THEN
2210: hr_utility.set_location('py_za_tx_01032012.SeaCalc',6);
2211: -- Tax Liability
2212: trc_TotLibBse := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbBseInc);
2213: ELSE
2214: hr_utility.set_location('py_za_tx_01032012.SeaCalc',7);
2215: trc_TotLibBse := 0;
2216: END IF;
2222: -- Threshold Check
2223: IF trc_TxbAnnPymInc >= trc_Threshold THEN
2224: hr_utility.set_location('py_za_tx_01032012.SeaCalc',8);
2225: -- Tax Liability
2226: trc_TotLibAP := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbAnnPymInc);
2227: trc_LibFpAP := trc_TotLibAP - least(trc_TotLibAP,trc_TotLibBse);
2228: ElSE
2229: hr_utility.set_location('py_za_tx_01032012.SeaCalc',9);
2230: trc_LibFpAP := 0;
2250: --
2251: trc_SitFactor := glb_ZA_WRK_DYS_PR_YR / dbi_SEA_WRK_DYS_WRK;
2252:
2253: -- Rebates
2254: py_za_tx_utl_01032012.SetRebates;
2255:
2256: -- Abatements
2257: py_za_tx_utl_01032012.Abatements;
2258:
2253: -- Rebates
2254: py_za_tx_utl_01032012.SetRebates;
2255:
2256: -- Abatements
2257: py_za_tx_utl_01032012.Abatements;
2258:
2259:
2260: trc_curMedTxCrEle := greatest(bal_MED_AID_TAX_CR_RUN + bal_ANN_MED_AID_TAX_CR_RUN,0);
2261:
2273: --TYS2010
2274: --Suffixed the variable with WoDon to denote that donation amount is not deducted.
2275: -- Taxable Normal Income
2276: trc_TxbNorIncWoDon := trc_NorErn - trc_PerTotAbm;
2277: trc_TxbNorInc :=trc_TxbNorIncWoDon - py_za_tx_utl_01032012.AllowableDeduction(trc_TxbNorIncWoDon,trc_PerDonAmt);
2278:
2279: -- Threshold Check
2280: IF trc_TxbNorInc >= trc_Threshold THEN
2281: hr_utility.set_location('py_za_tx_01032012.SeaCalc',13);
2279: -- Threshold Check
2280: IF trc_TxbNorInc >= trc_Threshold THEN
2281: hr_utility.set_location('py_za_tx_01032012.SeaCalc',13);
2282: -- Tax Liability
2283: trc_TotLibNI := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbNorInc);
2284: trc_LibFyNI := trc_TotLibNI - 0;
2285: trc_TotLibNI := greatest(trc_TotLibNI,0);
2286: trc_LibFpNI := (trc_LibFyNI / trc_SitFactor) + bal_MED_TAX_CR_USED_NI_RUN;
2287:
2285: trc_TotLibNI := greatest(trc_TotLibNI,0);
2286: trc_LibFpNI := (trc_LibFyNI / trc_SitFactor) + bal_MED_TAX_CR_USED_NI_RUN;
2287:
2288: -- Start Medical Tax Credit Changes
2289: py_za_tx_utl_01032012.CalMedTxCrUSEDOns
2290: (p_Avlbl_Md_Tx_Crdt => trc_curMedTxCrEle
2291: ,p_Md_tx_Crdt_Used_YTD => bal_MED_TAX_CR_USED_NI_RUN
2292: ,p_Tx_RUN => trc_LibFpNI
2293: ,p_Tx_YTD => 0
2325: --TYS2010
2326: --Suffixed the variable with WoDon to denote that donation amount is not deducted.
2327: -- Taxable Fringe Income
2328: trc_TxbFrnIncWoDon := trc_FrnBenErn - trc_PerTotAbm;
2329: trc_TxbFrnInc :=trc_TxbFrnIncWoDon - py_za_tx_utl_01032012.AllowableDeduction(trc_TxbFrnIncWoDon,trc_PerDonAmt);
2330: -- Threshold Check
2331: IF trc_TxbFrnInc >= trc_Threshold THEN
2332: hr_utility.set_location('py_za_tx_01032012.SeaCalc',17);
2333: -- Tax Liability
2330: -- Threshold Check
2331: IF trc_TxbFrnInc >= trc_Threshold THEN
2332: hr_utility.set_location('py_za_tx_01032012.SeaCalc',17);
2333: -- Tax Liability
2334: trc_TotLibFB := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbFrnInc);
2335: trc_LibFyFB := trc_TotLibFB - least(trc_TotLibFB,trc_TotLibNI);
2336: trc_TotLibFB := greatest(trc_TotLibFB,trc_TotLibNI);
2337: trc_LibFpFB := (trc_LibFyFB / trc_SitFactor) + bal_MED_TAX_CR_USED_FB_RUN;
2338:
2336: trc_TotLibFB := greatest(trc_TotLibFB,trc_TotLibNI);
2337: trc_LibFpFB := (trc_LibFyFB / trc_SitFactor) + bal_MED_TAX_CR_USED_FB_RUN;
2338:
2339: -- Start Medical Tax Credit Changes
2340: py_za_tx_utl_01032012.CalMedTxCrUSEDOns
2341: (p_Avlbl_Md_Tx_Crdt => trc_curMedTxCrEle
2342: ,p_Md_tx_Crdt_Used_YTD => bal_MED_TAX_CR_USED_FB_RUN
2343: ,p_Tx_RUN => trc_LibFpFB
2344: ,p_Tx_YTD => 0
2377: --TYS2010
2378: --Suffixed the variable with WoDon to denote that donation amount is not deducted.
2379: -- Taxable Annual Payments Income
2380: trc_TxbAnnPymIncWoDon := trc_AnnPymErn - trc_AnnTotAbm;
2381: trc_TxbAnnPymInc :=trc_TxbAnnPymIncWoDon - py_za_tx_utl_01032012.AllowableDeduction(trc_TxbAnnPymIncWoDon,trc_AnnDonAmt);
2382:
2383: -- Threshold Check
2384: IF trc_TxbAnnPymInc >= trc_Threshold THEN
2385: hr_utility.set_location('py_za_tx_01032012.SeaCalc',21);
2383: -- Threshold Check
2384: IF trc_TxbAnnPymInc >= trc_Threshold THEN
2385: hr_utility.set_location('py_za_tx_01032012.SeaCalc',21);
2386: -- Tax Liability
2387: trc_TotLibAP := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbAnnPymInc);
2388: trc_LibFyAP := trc_TotLibAP - least(trc_TotLibAP,trc_TotLibFB);
2389: trc_TotLibAP := greatest(trc_TotLibAP,trc_TotLibFB);
2390: trc_LibFpAP := trc_LibFyAP + bal_MED_TAX_CR_USED_AP_RUN;
2391:
2389: trc_TotLibAP := greatest(trc_TotLibAP,trc_TotLibFB);
2390: trc_LibFpAP := trc_LibFyAP + bal_MED_TAX_CR_USED_AP_RUN;
2391:
2392: -- Start Medical Tax Credit Changes
2393: py_za_tx_utl_01032012.CalMedTxCrUSEDOns
2394: (p_Avlbl_Md_Tx_Crdt => trc_curMedTxCrEle
2395: ,p_Md_tx_Crdt_Used_YTD => bal_MED_TAX_CR_USED_AP_RUN
2396: ,p_Tx_RUN => trc_LibFpAP
2397: ,p_Tx_YTD => 0
2422: trc_LibFpAP := trc_LibFpAP_Upd;
2423:
2424: -- Net Pay Validation
2425: --
2426: py_za_tx_utl_01032012.ValidateTaxOns;
2427:
2428: hr_utility.set_location('py_za_tx_01032012.SeaCalc',24);
2429:
2430: -- Set IT3A Indicator
2493:
2494: -- Update Global Balance Values with correct TAXABLE values
2495: --
2496: --Fix for bug#10372926
2497: --py_za_tx_utl_01032012.TrvAll;
2498:
2499: hr_utility.set_location('py_za_tx_01032012.SitCalc',2);
2500:
2501: bal_TOT_TXB_PO_YTD := bal_TOT_TXB_PO_YTD * glb_ZA_PBL_TX_PRC / 100;
2511: hr_utility.set_location('py_za_tx_01032012.SitCalc',3);
2512:
2513: -- Site Factor
2514: --
2515: trc_SitFactor := dbi_ZA_DYS_IN_YR / py_za_tx_utl_01032012.DaysWorked;
2516:
2517: hr_utility.set_location('py_za_tx_01032012.SitCalc',4);
2518:
2519: -- Rebates
2516:
2517: hr_utility.set_location('py_za_tx_01032012.SitCalc',4);
2518:
2519: -- Rebates
2520: py_za_tx_utl_01032012.SetRebates;
2521:
2522: -- Abatements
2523: py_za_tx_utl_01032012.Abatements;
2524:
2519: -- Rebates
2520: py_za_tx_utl_01032012.SetRebates;
2521:
2522: -- Abatements
2523: py_za_tx_utl_01032012.Abatements;
2524:
2525:
2526: trc_curMedTxCrEle := greatest(bal_MED_AID_TAX_CR_YTD + bal_ANN_MED_AID_TAX_CR_YTD,0,bal_MED_AID_TAX_CR_USED_YTD + bal_MED_AID_TAX_CR_USED_LS_YTD);
2527:
2540: -- Threshold Check
2541: IF trc_TxbDmdRmn >= trc_Threshold THEN
2542: hr_utility.set_location('py_za_tx_01032012.SitCalc',7);
2543: -- Tax Liability
2544: trc_TotLibDR := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbDmdRmn);
2545: trc_LibFyDR := (trc_TotLibDR - 0) / trc_SitFactor;
2546: trc_TotLibDR := greatest(trc_TotLibDR,0);
2547: trc_LibFpDR := trc_LibFyDR - (bal_TX_ON_DR_YTD + bal_MED_TAX_CR_USED_DR_YTD);
2548:
2546: trc_TotLibDR := greatest(trc_TotLibDR,0);
2547: trc_LibFpDR := trc_LibFyDR - (bal_TX_ON_DR_YTD + bal_MED_TAX_CR_USED_DR_YTD);
2548:
2549: -- Start Medical Tax Credit Changes
2550: py_za_tx_utl_01032012.CalMedTxCrUSEDOns
2551: (p_Avlbl_Md_Tx_Crdt => trc_curMedTxCrEle
2552: ,p_Md_tx_Crdt_Used_YTD => bal_MED_TAX_CR_USED_DR_YTD
2553: ,p_Tx_RUN => trc_LibFpDR
2554: ,p_Tx_YTD => bal_TX_ON_DR_YTD
2597: -- Taxable Normal Income
2598: --TYS2010
2599: --Suffixed the variable with WoDon to denote that donation amount is not deducted.
2600: trc_TxbNorIncWoDon := trc_NorErn - trc_PerTotAbm;
2601: trc_TxbNorInc :=trc_TxbNorIncWoDon - py_za_tx_utl_01032012.AllowableDeduction(trc_TxbNorIncWoDon,trc_PerDonAmt);
2602:
2603: -- Threshold Check
2604: IF trc_TxbNorInc >= trc_Threshold THEN
2605: hr_utility.set_location('py_za_tx_01032012.SitCalc',12);
2603: -- Threshold Check
2604: IF trc_TxbNorInc >= trc_Threshold THEN
2605: hr_utility.set_location('py_za_tx_01032012.SitCalc',12);
2606: -- Tax Liability
2607: trc_TotLibNI := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbNorInc);
2608: trc_LibFyNI := (trc_TotLibNI - least(trc_TotLibNI,trc_TotLibDR)) / trc_SitFactor;
2609: trc_TotLibNI := greatest(trc_TotLibNI,trc_TotLibDR);
2610: trc_LibFpNI := trc_LibFyNI - (bal_TX_ON_NI_YTD + bal_MED_TAX_CR_USED_NI_YTD);
2611:
2609: trc_TotLibNI := greatest(trc_TotLibNI,trc_TotLibDR);
2610: trc_LibFpNI := trc_LibFyNI - (bal_TX_ON_NI_YTD + bal_MED_TAX_CR_USED_NI_YTD);
2611:
2612: -- Start Medical Tax Credit Changes
2613: py_za_tx_utl_01032012.CalMedTxCrUSEDOns
2614: (p_Avlbl_Md_Tx_Crdt => trc_curMedTxCrEle
2615: ,p_Md_tx_Crdt_Used_YTD => bal_MED_TAX_CR_USED_NI_YTD
2616: ,p_Tx_RUN => trc_LibFpNI
2617: ,p_Tx_YTD => bal_TX_ON_NI_YTD
2660: -- Taxable Fringe Income
2661: --TYS2010
2662: --Suffixed the variable with WoDon to denote that donation amount is not deducted.
2663: trc_TxbFrnIncWoDon := trc_FrnBenErn - trc_PerTotAbm;
2664: trc_TxbFrnInc :=trc_TxbFrnIncWoDon - py_za_tx_utl_01032012.AllowableDeduction(trc_TxbFrnIncWoDon,trc_PerDonAmt);
2665:
2666: -- Threshold Check
2667: IF trc_TxbFrnInc >= trc_Threshold THEN
2668: hr_utility.set_location('py_za_tx_01032012.SitCalc',16);
2666: -- Threshold Check
2667: IF trc_TxbFrnInc >= trc_Threshold THEN
2668: hr_utility.set_location('py_za_tx_01032012.SitCalc',16);
2669: -- Tax Liability
2670: trc_TotLibFB := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbFrnInc);
2671: trc_LibFyFB := (trc_TotLibFB - least(trc_TotLibFB,trc_TotLibNI)) / trc_SitFactor;
2672: trc_TotLibFB := greatest(trc_TotLibFB,trc_TotLibNI);
2673: trc_LibFpFB := trc_LibFyFB - (bal_TX_ON_FB_YTD + bal_MED_TAX_CR_USED_FB_YTD);
2674:
2672: trc_TotLibFB := greatest(trc_TotLibFB,trc_TotLibNI);
2673: trc_LibFpFB := trc_LibFyFB - (bal_TX_ON_FB_YTD + bal_MED_TAX_CR_USED_FB_YTD);
2674:
2675: -- Start Medical Tax Credit Changes
2676: py_za_tx_utl_01032012.CalMedTxCrUSEDOns
2677: (p_Avlbl_Md_Tx_Crdt => trc_curMedTxCrEle
2678: ,p_Md_tx_Crdt_Used_YTD => bal_MED_TAX_CR_USED_FB_YTD
2679: ,p_Tx_RUN => trc_LibFpFB
2680: ,p_Tx_YTD => bal_TX_ON_FB_YTD
2723: -- Taxable Travel Income
2724: --TYS2010
2725: --Suffixed the variable with WoDon to denote that donation amount is not deducted.
2726: trc_TxbTrvIncWoDon := trc_TrvAllErn - trc_PerTotAbm;
2727: trc_TxbTrvInc :=trc_TxbTrvIncWoDon - py_za_tx_utl_01032012.AllowableDeduction(trc_TxbTrvIncWoDon,trc_PerDonAmt);
2728:
2729: -- Threshold Check
2730: IF trc_TxbTrvInc >= trc_Threshold THEN
2731: hr_utility.set_location('py_za_tx_01032012.SitCalc',20);
2729: -- Threshold Check
2730: IF trc_TxbTrvInc >= trc_Threshold THEN
2731: hr_utility.set_location('py_za_tx_01032012.SitCalc',20);
2732: -- Tax Liability
2733: trc_TotLibTA := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbTrvInc);
2734: trc_LibFyTA := (trc_TotLibTA - least(trc_TotLibTA,trc_TotLibFB)) / trc_SitFactor;
2735: trc_TotLibTA := greatest(trc_TotLibTA,trc_TotLibFB);
2736: trc_LibFpTA := trc_LibFyTA - (bal_TX_ON_TA_YTD + bal_MED_TAX_CR_USED_TA_YTD);
2737:
2735: trc_TotLibTA := greatest(trc_TotLibTA,trc_TotLibFB);
2736: trc_LibFpTA := trc_LibFyTA - (bal_TX_ON_TA_YTD + bal_MED_TAX_CR_USED_TA_YTD);
2737:
2738: -- Start Medical Tax Credit Changes
2739: py_za_tx_utl_01032012.CalMedTxCrUSEDOns
2740: (p_Avlbl_Md_Tx_Crdt => trc_curMedTxCrEle
2741: ,p_Md_tx_Crdt_Used_YTD => bal_MED_TAX_CR_USED_TA_YTD
2742: ,p_Tx_RUN => trc_LibFpTA
2743: ,p_Tx_YTD => bal_TX_ON_TA_YTD
2785: -- Taxable Bonus Provision Income
2786: --TYS2010
2787: --Suffixed the variable with WoDon to denote that donation amount is not deducted.
2788: trc_TxbBonProIncWoDon := trc_BonProErn - trc_PerTotAbm;
2789: trc_TxbBonProInc :=trc_TxbBonProIncWoDon - py_za_tx_utl_01032012.AllowableDeduction(trc_TxbBonProIncWoDon,trc_PerDonAmt);
2790:
2791: -- Threshold Check
2792: IF trc_TxbBonProInc >= trc_Threshold THEN
2793: hr_utility.set_location('py_za_tx_01032012.SitCalc',24);
2791: -- Threshold Check
2792: IF trc_TxbBonProInc >= trc_Threshold THEN
2793: hr_utility.set_location('py_za_tx_01032012.SitCalc',24);
2794: -- Tax Liability
2795: trc_TotLibBP := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbBonProInc);
2796: trc_LibFyBP := (trc_TotLibBP - least(trc_TotLibBP,trc_TotLibTA)) / trc_SitFactor;
2797: trc_TotLibBP := greatest(trc_TotLibBP,trc_TotLibTA);
2798: trc_LibFpBP := trc_LibFyBP - (bal_TX_ON_BP_YTD + bal_MED_TAX_CR_USED_BP_YTD);
2799:
2797: trc_TotLibBP := greatest(trc_TotLibBP,trc_TotLibTA);
2798: trc_LibFpBP := trc_LibFyBP - (bal_TX_ON_BP_YTD + bal_MED_TAX_CR_USED_BP_YTD);
2799:
2800: -- Start Medical Tax Credit Changes
2801: py_za_tx_utl_01032012.CalMedTxCrUSEDOns
2802: (p_Avlbl_Md_Tx_Crdt => trc_curMedTxCrEle
2803: ,p_Md_tx_Crdt_Used_YTD => bal_MED_TAX_CR_USED_BP_YTD
2804: ,p_Tx_RUN => trc_LibFpBP
2805: ,p_Tx_YTD => bal_TX_ON_BP_YTD
2847: -- Taxable Annual Bonus Income
2848: --TYS2010
2849: --Suffixed the variable with WoDon to denote that donation amount is not deducted.
2850: trc_TxbAnnBonIncWoDon := trc_AnnBonErn - trc_AnnTotAbm;
2851: trc_TxbAnnBonInc :=trc_TxbAnnBonIncWoDon - py_za_tx_utl_01032012.AllowableDeduction(trc_TxbAnnBonIncWoDon,trc_AnnDonAmt);
2852:
2853: -- Threshold Check
2854: IF trc_TxbAnnBonInc >= trc_Threshold THEN
2855: hr_utility.set_location('py_za_tx_01032012.SitCalc',28);
2853: -- Threshold Check
2854: IF trc_TxbAnnBonInc >= trc_Threshold THEN
2855: hr_utility.set_location('py_za_tx_01032012.SitCalc',28);
2856: -- Tax Liability
2857: trc_TotLibAB := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbAnnBonInc);
2858: trc_LibFyAB := trc_TotLibAB - least(trc_TotLibAB,trc_TotLibTA);
2859: trc_TotLibAB := greatest(trc_TotLibAB,trc_TotLibTA);
2860: hr_utility.set_location('py_za_tx_01032012.SitCalc',29);
2861: -- Check Bonus Provision
2861: -- Check Bonus Provision
2862: IF trc_BonProYtd <> 0 THEN
2863: hr_utility.set_location('py_za_tx_01032012.SitCalc',30);
2864: -- Check Bonus Provision Frequency
2865: IF dbi_BP_TX_RCV = 'B' OR py_za_tx_utl_01032012.SitePeriod THEN
2866: hr_utility.set_location('py_za_tx_01032012.SitCalc',31);
2867: trc_LibFpAB :=
2868: trc_LibFyAB - (bal_TX_ON_BP_YTD
2869: + bal_MED_TAX_CR_USED_BP_YTD
2871: + bal_TX_ON_AB_YTD
2872: + bal_MED_TAX_CR_USED_AB_YTD);
2873:
2874: -- Start Medical Tax Credit Changes
2875: py_za_tx_utl_01032012.CalMedTxCrUSEDOns
2876: (p_Avlbl_Md_Tx_Crdt => trc_curMedTxCrEle
2877: ,p_Md_tx_Crdt_Used_YTD => bal_MED_TAX_CR_USED_AB_YTD
2878: ,p_Tx_RUN => trc_LibFpAB
2879: ,p_Tx_YTD => bal_TX_ON_AB_YTD
2896: hr_utility.set_location('py_za_tx_01032012.SitCalc',33);
2897: trc_LibFpAB := trc_LibFyAB - (bal_TX_ON_AB_YTD + bal_MED_TAX_CR_USED_AB_YTD);
2898:
2899: -- Start Medical Tax Credit Changes
2900: py_za_tx_utl_01032012.CalMedTxCrUSEDOns
2901: (p_Avlbl_Md_Tx_Crdt => trc_curMedTxCrEle
2902: ,p_Md_tx_Crdt_Used_YTD => bal_MED_TAX_CR_USED_AB_YTD
2903: ,p_Tx_RUN => trc_LibFpAB
2904: ,p_Tx_YTD => bal_TX_ON_AB_YTD
2930: trc_MedTxCrUsedAB_Upd := -1 * bal_MED_TAX_CR_USED_AB_YTD;
2931: trc_LibFpAB_Upd := trc_LibFpAB ;
2932: trc_LibFpABOvr := TRUE;
2933:
2934: IF dbi_BP_TX_RCV = 'A' AND py_za_tx_utl_01032012.SitePeriod THEN
2935: hr_utility.set_location('py_za_tx_01032012.SitCalc',36);
2936: trc_LibFpBP := -1 * bal_TX_ON_BP_YTD;
2937: trc_MedTxCrUsedBP_Upd := -1 * bal_MED_TAX_CR_USED_BP_PTD;
2938: trc_LibFpBP_Upd := trc_LibFpBP;
2963: --Suffixed the variable with WoDon to denote that donation amount is not deducted.
2964: -- Taxable Annual Payments Income
2965: trc_TxbAnnPymIncWoDon := trc_AnnPymErn - trc_AnnTotAbm;
2966:
2967: trc_TxbAnnPymInc :=trc_TxbAnnPymIncWoDon - py_za_tx_utl_01032012.AllowableDeduction(trc_TxbAnnPymIncWoDon,trc_AnnDonAmt);
2968:
2969: -- Threshold Check
2970: IF trc_TxbAnnPymInc >= trc_Threshold THEN
2971: hr_utility.set_location('py_za_tx_01032012.SitCalc',39);
2969: -- Threshold Check
2970: IF trc_TxbAnnPymInc >= trc_Threshold THEN
2971: hr_utility.set_location('py_za_tx_01032012.SitCalc',39);
2972: -- Tax Liability
2973: trc_TotLibAP := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbAnnPymInc);
2974: trc_LibFyAP := trc_TotLibAP - least(trc_TotLibAP,trc_TotLibAB);
2975: trc_TotLibAP := greatest(trc_TotLibAP,trc_TotLibAB);
2976: trc_LibFpAP := trc_LibFyAP - (bal_TX_ON_AP_YTD + bal_MED_TAX_CR_USED_AP_YTD);
2977:
2975: trc_TotLibAP := greatest(trc_TotLibAP,trc_TotLibAB);
2976: trc_LibFpAP := trc_LibFyAP - (bal_TX_ON_AP_YTD + bal_MED_TAX_CR_USED_AP_YTD);
2977:
2978: -- Start Medical Tax Credit Changes
2979: py_za_tx_utl_01032012.CalMedTxCrUSEDOns
2980: (p_Avlbl_Md_Tx_Crdt => trc_curMedTxCrEle
2981: ,p_Md_tx_Crdt_Used_YTD => bal_MED_TAX_CR_USED_AP_YTD
2982: ,p_Tx_RUN => trc_LibFpAP
2983: ,p_Tx_YTD => bal_TX_ON_AP_YTD
3026: --TYS2010
3027: --Suffixed the variable with WoDon to denote that donation amount is not deducted.
3028: trc_TxbPblOffIncWoDon := trc_PblOffErn - trc_AnnTotAbm;
3029:
3030: trc_TxbPblOffInc :=trc_TxbPblOffIncWoDon - py_za_tx_utl_01032012.AllowableDeduction(trc_TxbPblOffIncWoDon,trc_AnnDonAmt);
3031:
3032: -- Threshold Check
3033: IF trc_TxbPblOffInc >= trc_Threshold THEN
3034: hr_utility.set_location('py_za_tx_01032012.SitCalc',43);
3032: -- Threshold Check
3033: IF trc_TxbPblOffInc >= trc_Threshold THEN
3034: hr_utility.set_location('py_za_tx_01032012.SitCalc',43);
3035: -- Tax Liability
3036: trc_TotLibPO := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbPblOffInc);
3037: trc_LibFyPO := (trc_TotLibPO - least(trc_TotLibPO,trc_TotLibAP)) / trc_SitFactor;
3038: trc_TotLibPO := greatest(trc_TotLibPO,trc_TotLibAP);
3039: trc_LibFpPO := trc_LibFyPO - (bal_TX_ON_PO_YTD + bal_MED_TAX_CR_USED_PO_YTD);
3040:
3038: trc_TotLibPO := greatest(trc_TotLibPO,trc_TotLibAP);
3039: trc_LibFpPO := trc_LibFyPO - (bal_TX_ON_PO_YTD + bal_MED_TAX_CR_USED_PO_YTD);
3040:
3041: -- Start Medical Tax Credit Changes
3042: py_za_tx_utl_01032012.CalMedTxCrUSEDOns
3043: (p_Avlbl_Md_Tx_Crdt => trc_curMedTxCrEle
3044: ,p_Md_tx_Crdt_Used_YTD => bal_MED_TAX_CR_USED_PO_YTD
3045: ,p_Tx_RUN => trc_LibFpPO
3046: ,p_Tx_YTD => bal_TX_ON_PO_YTD
3087:
3088: --Suffixed the variable with WoDon to denote that donation amount is not deducted.
3089: -- Taxable Annual Payments Income
3090: trc_TxbAnnPymNtgIncWoDon := trc_AnnPymNtgErn - trc_AnnTotAbm;
3091: trc_TxbAnnPymNtgInc :=trc_TxbAnnPymNtgIncWoDon - py_za_tx_utl_01032012.AllowableDeduction(trc_TxbAnnPymNtgIncWoDon,trc_AnnDonAmt);
3092:
3093: -- Threshold Check
3094: IF trc_TxbAnnPymNtgInc >= trc_Threshold THEN
3095: hr_utility.set_location('py_za_tx_01032012.SitCalc',47);
3093: -- Threshold Check
3094: IF trc_TxbAnnPymNtgInc >= trc_Threshold THEN
3095: hr_utility.set_location('py_za_tx_01032012.SitCalc',47);
3096: -- Tax Liability
3097: trc_TotLibNtgAP := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbAnnPymNtgInc);
3098: trc_LibFyNtgAP := trc_TotLibNtgAP - least(trc_TotLibNtgAP,trc_TotLibPO);
3099: trc_TotLibNtgAP := greatest(trc_TotLibNtgAP,trc_TotLibPO);
3100:
3101: trc_LibFpNtgAP := trc_LibFyNtgAP - (bal_TX_ON_AP_NTG_YTD+ bal_MED_TAX_CR_USED_NG_YTD);
3100:
3101: trc_LibFpNtgAP := trc_LibFyNtgAP - (bal_TX_ON_AP_NTG_YTD+ bal_MED_TAX_CR_USED_NG_YTD);
3102:
3103: -- Start Medical Tax Credit Changes
3104: py_za_tx_utl_01032012.CalMedTxCrUSEDOns
3105: (p_Avlbl_Md_Tx_Crdt => trc_curMedTxCrEle
3106: ,p_Md_tx_Crdt_Used_YTD => bal_MED_TAX_CR_USED_NG_YTD
3107: ,p_Tx_RUN => trc_LibFpNtgAP
3108: ,p_Tx_YTD => bal_TX_ON_AP_NTG_YTD
3147: trc_AnnEEDbtNtgErn := trc_AnnEEDbtNtgYtd + trc_AnnPymNtgErn;
3148:
3149: --Suffixed the variable with WoDon to denote that donation amount is not deducted.
3150: trc_TxbAnnEEDbtNtgIncWoDon := trc_AnnEEDbtNtgErn - trc_AnnTotNTGAbm;
3151: trc_TxbAnnEEDbtNtgInc :=trc_TxbAnnEEDbtNtgIncWoDon - py_za_tx_utl_01032012.AllowableDeduction(trc_TxbAnnEEDbtNtgIncWoDon,trc_AnnDonAmt);
3152:
3153: -- Threshold Check
3154: IF trc_TxbAnnEEDbtNtgInc >= trc_Threshold THEN
3155: hr_utility.set_location('py_za_tx_01032012.SitCalc',51);
3153: -- Threshold Check
3154: IF trc_TxbAnnEEDbtNtgInc >= trc_Threshold THEN
3155: hr_utility.set_location('py_za_tx_01032012.SitCalc',51);
3156: -- Tax Liability
3157: trc_TotLibNtgEEDbt := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbAnnEEDbtNtgInc);
3158: trc_LibFyNtgEEDbt := trc_TotLibNtgEEDbt - least(trc_TotLibNtgEEDbt,trc_TotLibNtgAP);
3159: trc_TotLibNtgEEDbt := greatest(trc_TotLibNtgEEDbt,trc_TotLibNtgAP);
3160: trc_LibFpNtgEEDbt := trc_LibFyNtgEEDbt - (bal_TX_ON_EE_DBT_NTG_YTD + bal_MED_TAX_CR_USED_EE_YTD);
3161:
3159: trc_TotLibNtgEEDbt := greatest(trc_TotLibNtgEEDbt,trc_TotLibNtgAP);
3160: trc_LibFpNtgEEDbt := trc_LibFyNtgEEDbt - (bal_TX_ON_EE_DBT_NTG_YTD + bal_MED_TAX_CR_USED_EE_YTD);
3161:
3162: -- Start Medical Tax Credit Changes
3163: py_za_tx_utl_01032012.CalMedTxCrUSEDOns
3164: (p_Avlbl_Md_Tx_Crdt => trc_curMedTxCrEle
3165: ,p_Md_tx_Crdt_Used_YTD => bal_MED_TAX_CR_USED_EE_YTD
3166: ,p_Tx_RUN => trc_LibFpNtgEEDbt
3167: ,p_Tx_YTD => bal_TX_ON_EE_DBT_NTG_YTD
3239: l_Sl := TRUE;
3240: END IF;
3241: */
3242:
3243: py_za_tx_utl_01032012.ValidateTaxOns(p_Rf => l_Sl);
3244:
3245: hr_utility.set_location('py_za_tx_01032012.SitCalc',56);
3246:
3247: -- Set IT3A Indicator
3384:
3385: -- Update Global Balance Values with correct TAXABLE values
3386: --
3387: --Fix for bug#10372926
3388: --py_za_tx_utl_01032012.TrvAll;
3389:
3390: hr_utility.set_location('py_za_tx_01032012.DirCalc',2);
3391:
3392: bal_TOT_TXB_PO_YTD := bal_TOT_TXB_PO_YTD * glb_ZA_PBL_TX_PRC / 100;
3401: hr_utility.set_location('py_za_tx_01032012.DirCalc',3);
3402: -- Normal Earnings
3403: trc_NorErn := trc_NorIncYtd;
3404: -- Tax Liability
3405: trc_TotLibNI := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_NorErn);
3406: trc_LibFyNI := trc_TotLibNI - 0;
3407: trc_TotLibNI := greatest(trc_TotLibNI,0);
3408: trc_LibFpNI := trc_LibFyNI - (bal_TX_ON_NI_YTD + bal_MED_TAX_CR_USED_NI_YTD);
3409:
3407: trc_TotLibNI := greatest(trc_TotLibNI,0);
3408: trc_LibFpNI := trc_LibFyNI - (bal_TX_ON_NI_YTD + bal_MED_TAX_CR_USED_NI_YTD);
3409:
3410: -- Start Medical Tax Credit Changes
3411: py_za_tx_utl_01032012.CalMedTxCrUSEDOns
3412: (p_Avlbl_Md_Tx_Crdt => trc_curMedTxCrEle
3413: ,p_Md_tx_Crdt_Used_YTD => bal_MED_TAX_CR_USED_NI_YTD
3414: ,p_Tx_RUN => trc_LibFpNI
3415: ,p_Tx_YTD => bal_TX_ON_NI_YTD
3445: hr_utility.set_location('py_za_tx_01032012.DirCalc',5);
3446: -- Fringe Benefit Earnings
3447: trc_FrnBenErn := trc_FrnBenYtd + trc_NorErn;
3448: -- Tax Liability
3449: trc_TotLibFB := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_FrnBenErn);
3450: trc_LibFyFB := trc_TotLibFB - least(trc_TotLibFB,trc_TotLibNI);
3451: trc_TotLibFB := greatest(trc_TotLibFB,trc_TotLibNI);
3452: trc_LibFpFB := trc_LibFyFB - (bal_TX_ON_FB_YTD + bal_MED_TAX_CR_USED_FB_YTD);
3453:
3451: trc_TotLibFB := greatest(trc_TotLibFB,trc_TotLibNI);
3452: trc_LibFpFB := trc_LibFyFB - (bal_TX_ON_FB_YTD + bal_MED_TAX_CR_USED_FB_YTD);
3453:
3454: -- Start Medical Tax Credit Changes
3455: py_za_tx_utl_01032012.CalMedTxCrUSEDOns
3456: (p_Avlbl_Md_Tx_Crdt => trc_curMedTxCrEle
3457: ,p_Md_tx_Crdt_Used_YTD => bal_MED_TAX_CR_USED_FB_YTD
3458: ,p_Tx_RUN => trc_LibFpFB
3459: ,p_Tx_YTD => bal_TX_ON_FB_YTD
3489: hr_utility.set_location('py_za_tx_01032012.DirCalc',7);
3490: -- Travel Allowance Earnings
3491: trc_TrvAllErn := trc_TrvAllYtd + trc_FrnBenErn;
3492: -- Tax Liability
3493: trc_TotLibTA := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TrvAllErn);
3494: trc_LibFyTA := trc_TotLibTA - least(trc_TotLibTA,trc_TotLibFB);
3495: trc_TotLibTA := greatest(trc_TotLibTA,trc_TotLibFB);
3496: trc_LibFpTA := trc_LibFyTA - (bal_TX_ON_TA_YTD + bal_MED_TAX_CR_USED_TA_YTD) ;
3497:
3495: trc_TotLibTA := greatest(trc_TotLibTA,trc_TotLibFB);
3496: trc_LibFpTA := trc_LibFyTA - (bal_TX_ON_TA_YTD + bal_MED_TAX_CR_USED_TA_YTD) ;
3497:
3498: -- Start Medical Tax Credit Changes
3499: py_za_tx_utl_01032012.CalMedTxCrUSEDOns
3500: (p_Avlbl_Md_Tx_Crdt => trc_curMedTxCrEle
3501: ,p_Md_tx_Crdt_Used_YTD => bal_MED_TAX_CR_USED_TA_YTD
3502: ,p_Tx_RUN => trc_LibFpTA
3503: ,p_Tx_YTD => bal_TX_ON_TA_YTD
3532: hr_utility.set_location('py_za_tx_01032012.DirCalc',9);
3533: -- Bonus Provision Earnings
3534: trc_BonProErn := trc_BonProYtd + trc_TrvAllErn;
3535: -- Tax Liability
3536: trc_TotLibBP := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_BonProErn);
3537: trc_LibFyBP := trc_TotLibBP - least(trc_TotLibBP,trc_TotLibTA);
3538: trc_TotLibBP := greatest(trc_TotLibBP,trc_TotLibTA);
3539: trc_LibFpBP := trc_LibFyBP - (bal_TX_ON_BP_YTD + bal_MED_TAX_CR_USED_BP_YTD);
3540:
3538: trc_TotLibBP := greatest(trc_TotLibBP,trc_TotLibTA);
3539: trc_LibFpBP := trc_LibFyBP - (bal_TX_ON_BP_YTD + bal_MED_TAX_CR_USED_BP_YTD);
3540:
3541: -- Start Medical Tax Credit Changes
3542: py_za_tx_utl_01032012.CalMedTxCrUSEDOns
3543: (p_Avlbl_Md_Tx_Crdt => trc_curMedTxCrEle
3544: ,p_Md_tx_Crdt_Used_YTD => bal_MED_TAX_CR_USED_BP_YTD
3545: ,p_Tx_RUN => trc_LibFpBP
3546: ,p_Tx_YTD => bal_TX_ON_BP_YTD
3575: hr_utility.set_location('py_za_tx_01032012.DirCalc',11);
3576: -- Annual Bonus Earnings
3577: trc_AnnBonErn := trc_AnnBonYtd + trc_TrvAllErn;
3578: -- Tax Liability
3579: trc_TotLibAB := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_AnnBonErn);
3580: trc_LibFyAB := trc_TotLibAB - least(trc_TotLibAB,trc_TotLibTA);
3581: trc_TotLibAB := greatest(trc_TotLibAB,trc_TotLibTA);
3582: -- Check Bonus Provision
3583: IF trc_BonProYtd <> 0 THEN
3582: -- Check Bonus Provision
3583: IF trc_BonProYtd <> 0 THEN
3584: hr_utility.set_location('py_za_tx_01032012.DirCalc',12);
3585: -- Check Bonus Provision Frequency
3586: IF dbi_BP_TX_RCV = 'B' OR py_za_tx_utl_01032012.SitePeriod THEN
3587: hr_utility.set_location('py_za_tx_01032012.DirCalc',13);
3588: trc_LibFpAB :=
3589: trc_LibFyAB - (bal_TX_ON_BP_YTD
3590: + bal_MED_TAX_CR_USED_BP_YTD
3593: + bal_MED_TAX_CR_USED_AB_YTD
3594: );
3595:
3596: -- Start Medical Tax Credit Changes
3597: py_za_tx_utl_01032012.CalMedTxCrUSEDOns
3598: (p_Avlbl_Md_Tx_Crdt => trc_curMedTxCrEle
3599: ,p_Md_tx_Crdt_Used_YTD => bal_MED_TAX_CR_USED_AB_YTD
3600: ,p_Tx_RUN => trc_LibFpAB
3601: ,p_Tx_YTD => bal_TX_ON_AB_YTD
3618: hr_utility.set_location('py_za_tx_01032012.DirCalc',15);
3619: trc_LibFpAB := trc_LibFyAB - (bal_TX_ON_AB_YTD + bal_MED_TAX_CR_USED_AB_YTD);
3620:
3621: -- Start Medical Tax Credit Changes
3622: py_za_tx_utl_01032012.CalMedTxCrUSEDOns
3623: (p_Avlbl_Md_Tx_Crdt => trc_curMedTxCrEle
3624: ,p_Md_tx_Crdt_Used_YTD => bal_MED_TAX_CR_USED_AB_YTD
3625: ,p_Tx_RUN => trc_LibFpAB
3626: ,p_Tx_YTD => bal_TX_ON_AB_YTD
3642: trc_LibFpAB := -1 * bal_TX_ON_AB_YTD;
3643: trc_LibFpABOvr := TRUE;
3644: trc_MedTxCrUsedAB_Upd := -1 * bal_MED_TAX_CR_USED_AB_YTD;
3645: trc_LibFpAB_Upd := trc_LibFpAB ;
3646: IF dbi_BP_TX_RCV = 'A' AND py_za_tx_utl_01032012.SitePeriod THEN
3647: hr_utility.set_location('py_za_tx_01032012.DirCalc',17);
3648: trc_LibFpBP := -1 * bal_TX_ON_BP_YTD;
3649: trc_MedTxCrUsedBP_Upd := -1 * bal_MED_TAX_CR_USED_BP_YTD;
3650: trc_LibFpBPOvr := TRUE;
3669: hr_utility.set_location('py_za_tx_01032012.DirCalc',19);
3670: -- Annual Payments Earnings
3671: trc_AnnPymErn := trc_AnnPymYtd + trc_AnnBonErn;
3672: -- Tax Liability
3673: trc_TotLibAP := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_AnnPymErn);
3674: trc_LibFyAP := trc_TotLibAP - least(trc_TotLibAP,trc_TotLibAB);
3675: trc_TotLibAP := greatest(trc_TotLibAP,trc_TotLibAB);
3676: trc_LibFpAP := trc_LibFyAP - (bal_TX_ON_AP_YTD + bal_MED_TAX_CR_USED_AP_YTD);
3677:
3675: trc_TotLibAP := greatest(trc_TotLibAP,trc_TotLibAB);
3676: trc_LibFpAP := trc_LibFyAP - (bal_TX_ON_AP_YTD + bal_MED_TAX_CR_USED_AP_YTD);
3677:
3678: -- Start Medical Tax Credit Changes
3679: py_za_tx_utl_01032012.CalMedTxCrUSEDOns
3680: (p_Avlbl_Md_Tx_Crdt => trc_curMedTxCrEle
3681: ,p_Md_tx_Crdt_Used_YTD => bal_MED_TAX_CR_USED_AP_YTD
3682: ,p_Tx_RUN => trc_LibFpAP
3683: ,p_Tx_YTD => bal_TX_ON_AP_YTD
3712: hr_utility.set_location('py_za_tx_01032012.DirCalc',21);
3713: -- Public Office Allowance Earnings
3714: trc_PblOffErn := trc_PblOffYtd + trc_AnnPymErn;
3715: -- Tax Liability
3716: trc_TotLibPO := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_PblOffErn);
3717: trc_LibFyPO := trc_TotLibPO - least(trc_TotLibPO,trc_TotLibAP);
3718: trc_TotLibPO := greatest(trc_TotLibPO,trc_TotLibAP);
3719: trc_LibFpPO := trc_LibFyPO - (bal_TX_ON_PO_YTD + bal_MED_TAX_CR_USED_PO_YTD);
3720:
3718: trc_TotLibPO := greatest(trc_TotLibPO,trc_TotLibAP);
3719: trc_LibFpPO := trc_LibFyPO - (bal_TX_ON_PO_YTD + bal_MED_TAX_CR_USED_PO_YTD);
3720:
3721: -- Start Medical Tax Credit Changes
3722: py_za_tx_utl_01032012.CalMedTxCrUSEDOns
3723: (p_Avlbl_Md_Tx_Crdt => trc_curMedTxCrEle
3724: ,p_Md_tx_Crdt_Used_YTD => bal_MED_TAX_CR_USED_PO_YTD
3725: ,p_Tx_RUN => trc_LibFpPO
3726: ,p_Tx_YTD => bal_TX_ON_PO_YTD
3754: hr_utility.set_location('py_za_tx_01032012.DirCalc',23);
3755: -- Annual Payments Net to Gross Earnings
3756: trc_AnnPymNtgErn := trc_AnnPymNtgYtd + trc_PblOffErn;
3757: -- Tax Liability
3758: trc_TotLibNtgAP := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_AnnPymNtgErn);
3759: trc_LibFyNtgAP := trc_TotLibNtgAP - least(trc_TotLibNtgAP,trc_TotLibPO);
3760: trc_TotLibNtgAP := greatest(trc_TotLibNtgAP,trc_TotLibPO);
3761: trc_LibFpNtgAP := trc_LibFyNtgAP - (bal_TX_ON_AP_NTG_YTD + bal_MED_TAX_CR_USED_NG_YTD);
3762:
3760: trc_TotLibNtgAP := greatest(trc_TotLibNtgAP,trc_TotLibPO);
3761: trc_LibFpNtgAP := trc_LibFyNtgAP - (bal_TX_ON_AP_NTG_YTD + bal_MED_TAX_CR_USED_NG_YTD);
3762:
3763: -- Start Medical Tax Credit Changes
3764: py_za_tx_utl_01032012.CalMedTxCrUSEDOns
3765: (p_Avlbl_Md_Tx_Crdt => trc_curMedTxCrEle
3766: ,p_Md_tx_Crdt_Used_YTD => bal_MED_TAX_CR_USED_NG_YTD
3767: ,p_Tx_RUN => trc_LibFpNtgAP
3768: ,p_Tx_YTD => bal_TX_ON_AP_NTG_YTD
3796: -- Annual EE Debt Net to Gross Earnings
3797: trc_AnnEEDbtNtgErn := trc_AnnEEDbtNtgYtd + trc_AnnPymNtgErn;
3798:
3799: -- Tax Liability
3800: trc_TotLibNtgEEDbt := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_AnnEEDbtNtgErn);
3801: trc_LibFyNtgEEDbt := trc_TotLibNtgEEDbt - least(trc_TotLibNtgEEDbt,trc_TotLibNtgAP);
3802: trc_TotLibNtgEEDbt := greatest(trc_TotLibNtgEEDbt,trc_TotLibNtgAP);
3803: trc_LibFpNtgEEDbt := trc_LibFyNtgEEDbt - (bal_TX_ON_EE_DBT_NTG_YTD + bal_MED_TAX_CR_USED_EE_YTD);
3804:
3802: trc_TotLibNtgEEDbt := greatest(trc_TotLibNtgEEDbt,trc_TotLibNtgAP);
3803: trc_LibFpNtgEEDbt := trc_LibFyNtgEEDbt - (bal_TX_ON_EE_DBT_NTG_YTD + bal_MED_TAX_CR_USED_EE_YTD);
3804:
3805: -- Start Medical Tax Credit Changes
3806: py_za_tx_utl_01032012.CalMedTxCrUSEDOns
3807: (p_Avlbl_Md_Tx_Crdt => trc_curMedTxCrEle
3808: ,p_Md_tx_Crdt_Used_YTD => bal_MED_TAX_CR_USED_EE_YTD
3809: ,p_Tx_RUN => trc_LibFpNtgEEDbt
3810: ,p_Tx_YTD => bal_TX_ON_EE_DBT_NTG_YTD
3849: l_Sl := TRUE;
3850: ELSE
3851: l_Sl := FALSE;
3852: END IF;
3853: py_za_tx_utl_01032012.ValidateTaxOns(p_Rf => l_Sl);
3854:
3855: hr_utility.set_location('py_za_tx_01032012.DirCalc',27);
3856:
3857: -- Tax Percentage Indicator
3984: --
3985: trc_CalTyp := 'BasCalc';
3986:
3987: -- Rebates
3988: py_za_tx_utl_01032012.SetRebates;
3989:
3990: -- Abatements
3991: py_za_tx_utl_01032012.Abatements;
3992:
3987: -- Rebates
3988: py_za_tx_utl_01032012.SetRebates;
3989:
3990: -- Abatements
3991: py_za_tx_utl_01032012.Abatements;
3992:
3993: trc_curMedTxCrEle := greatest(bal_MED_AID_TAX_CR_YTD + bal_ANN_MED_AID_TAX_CR_YTD,0,bal_MED_AID_TAX_CR_USED_YTD + bal_MED_AID_TAX_CR_USED_LS_YTD);
3994:
3995: -- Deemed Remuneration
4005: -- Threshold Check
4006: IF trc_TxbDmdRmn >= trc_Threshold THEN
4007: hr_utility.set_location('py_za_tx_01032012.BasCalc',3);
4008: -- Tax Liability
4009: trc_TotLibDR := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbDmdRmn);
4010: ELSE
4011: hr_utility.set_location('py_za_tx_01032012.BasCalc',4);
4012: trc_TotLibDR := 0;
4013: END IF;
4027: -- Threshold Check
4028: IF trc_TxbBseInc >= trc_Threshold THEN
4029: hr_utility.set_location('py_za_tx_01032012.BasCalc',7);
4030: -- Tax Liability
4031: trc_TotLibBse := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbBseInc);
4032: trc_TotLibBse := greatest(trc_TotLibBse,trc_TotLibDR);
4033: ELSE
4034: hr_utility.set_location('py_za_tx_01032012.BasCalc',8);
4035: trc_TotLibBse := trc_TotLibDR;
4049: -- Taxable Annual Bonus Income
4050: --TYS2010
4051: --Suffixed the variable with WoDon to denote that donation amount is not deducted.
4052: trc_TxbAnnBonIncWoDon := trc_AnnBonErn - trc_AnnTotAbm;
4053: trc_TxbAnnBonInc :=trc_TxbAnnBonIncWoDon - py_za_tx_utl_01032012.AllowableDeduction(trc_TxbAnnBonIncWoDon,trc_AnnDonAmt);
4054:
4055: -- Threshold Check
4056: IF trc_TxbAnnBonInc >= trc_Threshold THEN
4057: hr_utility.set_location('py_za_tx_01032012.BasCalc',11);
4055: -- Threshold Check
4056: IF trc_TxbAnnBonInc >= trc_Threshold THEN
4057: hr_utility.set_location('py_za_tx_01032012.BasCalc',11);
4058: -- Tax Liability
4059: trc_TotLibAB := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbAnnBonInc);
4060: trc_LibFyAB := trc_TotLibAB - least(trc_TotLibAB,trc_TotLibBse);
4061: trc_TotLibAB := greatest(trc_TotLibAB,trc_TotLibBse);
4062: -- Check Bonus Provision
4063: IF bal_BP_YTD <> 0 THEN
4071: trc_LibFpAB := trc_LibFyAB - ( bal_TX_ON_BP_YTD + bal_MED_TAX_CR_USED_BP_YTD
4072: + bal_TX_ON_AB_YTD + bal_MED_TAX_CR_USED_AB_YTD);
4073:
4074: -- Start Medical Tax Credit Changes
4075: py_za_tx_utl_01032012.CalMedTxCrUSEDOns
4076: (p_Avlbl_Md_Tx_Crdt => trc_curMedTxCrEle
4077: ,p_Md_tx_Crdt_Used_YTD => bal_MED_TAX_CR_USED_AB_YTD
4078: ,p_Tx_RUN => trc_LibFpAB
4079: ,p_Tx_YTD => bal_TX_ON_AB_YTD
4093: hr_utility.set_location('py_za_tx_01032012.BasCalc',15);
4094: trc_LibFpAB := trc_LibFyAB - (bal_TX_ON_AB_YTD + bal_MED_TAX_CR_USED_AB_YTD);
4095:
4096: -- Start Medical Tax Credit Changes
4097: py_za_tx_utl_01032012.CalMedTxCrUSEDOns
4098: (p_Avlbl_Md_Tx_Crdt => trc_curMedTxCrEle
4099: ,p_Md_tx_Crdt_Used_YTD => bal_MED_TAX_CR_USED_AB_YTD
4100: ,p_Tx_RUN => trc_LibFpAB
4101: ,p_Tx_YTD => bal_TX_ON_AB_YTD
4136: trc_TxbAnnPymInc := trc_AnnPymYtd + trc_TxbAnnBonInc; */
4137: --Added for TYS2010
4138: trc_AnnPymErn := trc_AnnPymYtd + trc_AnnBonErn;
4139: trc_TxbAnnPymIncWoDon := trc_AnnPymErn - trc_AnnTotAbm;
4140: trc_TxbAnnPymInc :=trc_TxbAnnPymIncWoDon - py_za_tx_utl_01032012.AllowableDeduction(trc_TxbAnnPymIncWoDon,trc_AnnDonAmt);
4141:
4142: -- Threshold Check
4143: IF trc_TxbAnnPymInc >= trc_Threshold THEN
4144: hr_utility.set_location('py_za_tx_01032012.BasCalc',20);
4142: -- Threshold Check
4143: IF trc_TxbAnnPymInc >= trc_Threshold THEN
4144: hr_utility.set_location('py_za_tx_01032012.BasCalc',20);
4145: -- Tax Liability
4146: trc_TotLibAP := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbAnnPymInc);
4147: trc_LibFyAP := trc_TotLibAP - least(trc_TotLibAP,trc_TotLibAB);
4148: trc_TotLibAP := greatest(trc_TotLibAP,trc_TotLibAB);
4149: trc_LibFpAP := trc_LibFyAP - (bal_TX_ON_AP_YTD + bal_MED_TAX_CR_USED_AP_YTD);
4150:
4148: trc_TotLibAP := greatest(trc_TotLibAP,trc_TotLibAB);
4149: trc_LibFpAP := trc_LibFyAP - (bal_TX_ON_AP_YTD + bal_MED_TAX_CR_USED_AP_YTD);
4150:
4151: -- Start Medical Tax Credit Changes
4152: py_za_tx_utl_01032012.CalMedTxCrUSEDOns
4153: (p_Avlbl_Md_Tx_Crdt => trc_curMedTxCrEle
4154: ,p_Md_tx_Crdt_Used_YTD => bal_MED_TAX_CR_USED_AP_YTD
4155: ,p_Tx_RUN => trc_LibFpAP
4156: ,p_Tx_YTD => bal_TX_ON_AP_YTD
4192:
4193: --Suffixed the variable with WoDon to denote that donation amount is not deducted.
4194: -- Taxable Annual Payments Income
4195: trc_TxbAnnPymNtgIncWoDon := trc_AnnPymNtgErn - trc_AnnTotAbm;
4196: trc_TxbAnnPymNtgInc :=trc_TxbAnnPymNtgIncWoDon - py_za_tx_utl_01032012.AllowableDeduction(trc_TxbAnnPymNtgIncWoDon,trc_AnnDonAmt);
4197:
4198: -- Threshold Check
4199: IF trc_TxbAnnPymNtgInc >= trc_Threshold THEN
4200: hr_utility.set_location('py_za_tx_01032012.BasCalc',24);
4198: -- Threshold Check
4199: IF trc_TxbAnnPymNtgInc >= trc_Threshold THEN
4200: hr_utility.set_location('py_za_tx_01032012.BasCalc',24);
4201: -- Tax Liability
4202: trc_TotLibNtgAP := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbAnnPymNtgInc);
4203: trc_LibFyNtgAP := trc_TotLibNtgAP - least(trc_TotLibNtgAP,trc_TotLibAP);
4204: trc_TotLibNtgAP := greatest(trc_TotLibNtgAP,trc_TotLibAP);
4205: trc_LibFpNtgAP := trc_LibFyNtgAP - (bal_TX_ON_AP_NTG_YTD + bal_MED_TAX_CR_USED_NG_YTD);
4206:
4204: trc_TotLibNtgAP := greatest(trc_TotLibNtgAP,trc_TotLibAP);
4205: trc_LibFpNtgAP := trc_LibFyNtgAP - (bal_TX_ON_AP_NTG_YTD + bal_MED_TAX_CR_USED_NG_YTD);
4206:
4207: -- Start Medical Tax Credit Changes
4208: py_za_tx_utl_01032012.CalMedTxCrUSEDOns
4209: (p_Avlbl_Md_Tx_Crdt => trc_curMedTxCrEle
4210: ,p_Md_tx_Crdt_Used_YTD => bal_MED_TAX_CR_USED_NG_YTD
4211: ,p_Tx_RUN => trc_LibFpNtgAP
4212: ,p_Tx_YTD => bal_TX_ON_AP_NTG_YTD
4241: trc_AnnEEDbtNtgErn := trc_AnnEEDbtNtgYtd + trc_AnnPymNtgErn;
4242:
4243: --Suffixed the variable with WoDon to denote that donation amount is not deducted.
4244: trc_TxbAnnEEDbtNtgIncWoDon := trc_AnnEEDbtNtgErn - trc_AnnTotNTGAbm;
4245: trc_TxbAnnEEDbtNtgInc :=trc_TxbAnnEEDbtNtgIncWoDon - py_za_tx_utl_01032012.AllowableDeduction(trc_TxbAnnEEDbtNtgIncWoDon,trc_AnnDonAmt);
4246:
4247: -- Threshold Check
4248: IF trc_TxbAnnEEDbtNtgInc >= trc_Threshold THEN
4249: hr_utility.set_location('py_za_tx_01032012.BasCalc',28);
4247: -- Threshold Check
4248: IF trc_TxbAnnEEDbtNtgInc >= trc_Threshold THEN
4249: hr_utility.set_location('py_za_tx_01032012.BasCalc',28);
4250: -- Tax Liability
4251: trc_TotLibNtgEEDbt := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbAnnEEDbtNtgInc);
4252: trc_LibFyNtgEEDbt := trc_TotLibNtgEEDbt - least(trc_TotLibNtgEEDbt,trc_TotLibNtgAP);
4253: trc_TotLibNtgEEDbt := greatest(trc_TotLibNtgEEDbt,trc_TotLibNtgAP);
4254:
4255: hr_utility.set_location('py_za_tx_01032012.BasCalc',29);
4255: hr_utility.set_location('py_za_tx_01032012.BasCalc',29);
4256: trc_LibFpNtgEEDbt := trc_LibFyNtgEEDbt - (bal_TX_ON_EE_DBT_NTG_YTD + bal_MED_TAX_CR_USED_EE_YTD);
4257:
4258: -- Start Medical Tax Credit Changes
4259: py_za_tx_utl_01032012.CalMedTxCrUSEDOns
4260: (p_Avlbl_Md_Tx_Crdt => trc_curMedTxCrEle
4261: ,p_Md_tx_Crdt_Used_YTD => bal_MED_TAX_CR_USED_EE_YTD
4262: ,p_Tx_RUN => trc_LibFpNtgEEDbt
4263: ,p_Tx_YTD => bal_TX_ON_EE_DBT_NTG_YTD
4289: trc_LibFpNtgEEDbt := trc_LibFpNtgEEDbt_Upd;
4290:
4291: -- Net Pay Validation
4292: --
4293: py_za_tx_utl_01032012.ValidateTaxOns;
4294:
4295: -- Deemed Remuneration
4296: WrtHrTrc('trc_TxbDmdRmn: '||to_char(trc_TxbDmdRmn));
4297: WrtHrTrc('trc_TotLibDR: '||to_char(trc_TotLibDR));
4410:
4411: -- Update Global Balance Values with correct TAXABLE values
4412: --
4413: --Fix for bug#10372926
4414: --py_za_tx_utl_01032012.TrvAll;
4415:
4416: hr_utility.set_location('py_za_tx_01032012.CalCalc',2);
4417:
4418: -- Calendar Ytd Taxable Income
4428: ELSE -- continue CalCalc
4429: hr_utility.set_location('py_za_tx_01032012.CalCalc',4);
4430: -- Site Factor
4431: --
4432: trc_SitFactor := dbi_ZA_DYS_IN_YR / py_za_tx_utl_01032012.DaysWorked;
4433:
4434: -- Rebates
4435: py_za_tx_utl_01032012.SetRebates;
4436:
4431: --
4432: trc_SitFactor := dbi_ZA_DYS_IN_YR / py_za_tx_utl_01032012.DaysWorked;
4433:
4434: -- Rebates
4435: py_za_tx_utl_01032012.SetRebates;
4436:
4437: -- Abatements
4438: py_za_tx_utl_01032012.Abatements;
4439:
4434: -- Rebates
4435: py_za_tx_utl_01032012.SetRebates;
4436:
4437: -- Abatements
4438: py_za_tx_utl_01032012.Abatements;
4439:
4440: hr_utility.set_location('py_za_tx_01032012.CalCalc',5);
4441:
4442: trc_curMedTxCrEle := greatest(bal_MED_AID_TAX_CR_YTD + bal_ANN_MED_AID_TAX_CR_YTD,0,bal_MED_AID_TAX_CR_USED_YTD + bal_MED_AID_TAX_CR_USED_LS_YTD);
4454: -- Threshold Check
4455: IF trc_TxbDmdRmn >= trc_Threshold THEN
4456: hr_utility.set_location('py_za_tx_01032012.CalCalc',7);
4457: -- Tax Liability
4458: trc_TotLibDR := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbDmdRmn);
4459: ELSE
4460: hr_utility.set_location('py_za_tx_01032012.CalCalc',8);
4461: trc_TotLibDR := 0;
4462: END IF;
4474: --TYS2010
4475: --Suffixed the variable with WoDon to denote that donation amount is not deducted.
4476: -- Taxable Base Income
4477: trc_TxbBseIncWoDon := trc_BseErn - trc_PerTotAbm;
4478: trc_TxbBseInc :=trc_TxbBseIncWoDon - py_za_tx_utl_01032012.AllowableDeduction(trc_TxbBseIncWoDon,trc_PerDonAmt);
4479:
4480: -- Threshold Check
4481: IF trc_TxbBseInc >= trc_Threshold THEN
4482: hr_utility.set_location('py_za_tx_01032012.CalCalc',11);
4480: -- Threshold Check
4481: IF trc_TxbBseInc >= trc_Threshold THEN
4482: hr_utility.set_location('py_za_tx_01032012.CalCalc',11);
4483: -- Tax Liability
4484: trc_TotLibBse := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbBseInc);
4485: trc_TotLibBse := greatest(trc_TotLibBse,trc_TotLibDR);
4486: ELSE
4487: hr_utility.set_location('py_za_tx_01032012.CalCalc',12);
4488: trc_TotLibBse := trc_TotLibDR;
4501: -- Taxable Annual Bonus Income
4502: --TYS2010
4503: --Suffixed the variable with WoDon to denote that donation amount is not deducted.
4504: trc_TxbAnnBonIncWoDon := trc_AnnBonErn - trc_AnnTotAbm;
4505: trc_TxbAnnBonInc :=trc_TxbAnnBonIncWoDon - py_za_tx_utl_01032012.AllowableDeduction(trc_TxbAnnBonIncWoDon,trc_AnnDonAmt);
4506:
4507: -- Threshold Check
4508: IF trc_TxbAnnBonInc >= trc_Threshold THEN
4509: hr_utility.set_location('py_za_tx_01032012.CalCalc',15);
4507: -- Threshold Check
4508: IF trc_TxbAnnBonInc >= trc_Threshold THEN
4509: hr_utility.set_location('py_za_tx_01032012.CalCalc',15);
4510: -- Tax Liability
4511: trc_TotLibAB := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbAnnBonInc);
4512: trc_LibFyAB := trc_TotLibAB - least(trc_TotLibAB,trc_TotLibBse);
4513: trc_TotLibAB := greatest(trc_TotLibAB,trc_TotLibBse);
4514: -- Check Bonus Provision
4515: IF bal_BP_YTD <> 0 THEN
4522: hr_utility.set_location('py_za_tx_01032012.CalCalc',18);
4523: trc_LibFpAB := trc_LibFyAB - ( bal_TX_ON_BP_YTD + bal_MED_TAX_CR_USED_BP_YTD
4524: + bal_TX_ON_AB_YTD + bal_MED_TAX_CR_USED_AB_YTD);
4525: -- Start Medical Tax Credit Changes
4526: py_za_tx_utl_01032012.CalMedTxCrUSEDOns
4527: (p_Avlbl_Md_Tx_Crdt => trc_curMedTxCrEle
4528: ,p_Md_tx_Crdt_Used_YTD => bal_MED_TAX_CR_USED_AB_YTD
4529: ,p_Tx_RUN => trc_LibFpAB
4530: ,p_Tx_YTD => bal_TX_ON_AB_YTD
4544: hr_utility.set_location('py_za_tx_01032012.CalCalc',19);
4545: trc_LibFpAB := trc_LibFyAB - (bal_TX_ON_AB_YTD + bal_MED_TAX_CR_USED_AB_YTD);
4546:
4547: -- Start Medical Tax Credit Changes
4548: py_za_tx_utl_01032012.CalMedTxCrUSEDOns
4549: (p_Avlbl_Md_Tx_Crdt => trc_curMedTxCrEle
4550: ,p_Md_tx_Crdt_Used_YTD => bal_MED_TAX_CR_USED_AB_YTD
4551: ,p_Tx_RUN => trc_LibFpAB
4552: ,p_Tx_YTD => bal_TX_ON_AB_YTD
4587: -- Taxable Annual Payments Income
4588: --TYS2010
4589: --Suffixed the variable with WoDon to denote that donation amount is not deducted.
4590: trc_TxbAnnPymIncWoDon := trc_AnnPymErn - trc_AnnTotAbm;
4591: trc_TxbAnnPymInc :=trc_TxbAnnPymIncWoDon - py_za_tx_utl_01032012.AllowableDeduction(trc_TxbAnnPymIncWoDon,trc_AnnDonAmt);
4592:
4593: -- Threshold Check
4594: IF trc_TxbAnnPymInc >= trc_Threshold THEN
4595: hr_utility.set_location('py_za_tx_01032012.CalCalc',24);
4593: -- Threshold Check
4594: IF trc_TxbAnnPymInc >= trc_Threshold THEN
4595: hr_utility.set_location('py_za_tx_01032012.CalCalc',24);
4596: -- Tax Liability
4597: trc_TotLibAP := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbAnnPymInc);
4598: trc_LibFyAP := trc_TotLibAP - least(trc_TotLibAP,trc_TotLibAB);
4599: trc_TotLibAP := greatest(trc_TotLibAP,trc_TotLibAB);
4600: trc_LibFpAP := trc_LibFyAP - (bal_TX_ON_AP_YTD + bal_MED_TAX_CR_USED_AP_YTD);
4601:
4599: trc_TotLibAP := greatest(trc_TotLibAP,trc_TotLibAB);
4600: trc_LibFpAP := trc_LibFyAP - (bal_TX_ON_AP_YTD + bal_MED_TAX_CR_USED_AP_YTD);
4601:
4602: -- Start Medical Tax Credit Changes
4603: py_za_tx_utl_01032012.CalMedTxCrUSEDOns
4604: (p_Avlbl_Md_Tx_Crdt => trc_curMedTxCrEle
4605: ,p_Md_tx_Crdt_Used_YTD => bal_MED_TAX_CR_USED_AP_YTD
4606: ,p_Tx_RUN => trc_LibFpAP
4607: ,p_Tx_YTD => bal_TX_ON_AP_YTD
4638:
4639: --Suffixed the variable with WoDon to denote that donation amount is not deducted.
4640: -- Taxable Annual Payments Income
4641: trc_TxbAnnPymNtgIncWoDon := trc_AnnPymNtgErn - trc_AnnTotAbm;
4642: trc_TxbAnnPymNtgInc :=trc_TxbAnnPymNtgIncWoDon - py_za_tx_utl_01032012.AllowableDeduction(trc_TxbAnnPymNtgIncWoDon,trc_AnnDonAmt);
4643:
4644: -- Threshold Check
4645: IF trc_TxbAnnPymNtgInc >= trc_Threshold THEN
4646: hr_utility.set_location('py_za_tx_01032012.CalCalc',28);
4644: -- Threshold Check
4645: IF trc_TxbAnnPymNtgInc >= trc_Threshold THEN
4646: hr_utility.set_location('py_za_tx_01032012.CalCalc',28);
4647: -- Tax Liability
4648: trc_TotLibNtgAP := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbAnnPymNtgInc);
4649: trc_LibFyNtgAP := trc_TotLibNtgAP - least(trc_TotLibNtgAP,trc_TotLibAP);
4650: trc_TotLibNtgAP := greatest(trc_TotLibNtgAP,trc_TotLibAP);
4651:
4652: hr_utility.set_location('py_za_tx_01032012.CalCalc',29);
4652: hr_utility.set_location('py_za_tx_01032012.CalCalc',29);
4653: trc_LibFpNtgAP := trc_LibFyNtgAP - (bal_TX_ON_AP_NTG_YTD + bal_MED_TAX_CR_USED_NG_YTD);
4654:
4655: -- Start Medical Tax Credit Changes
4656: py_za_tx_utl_01032012.CalMedTxCrUSEDOns
4657: (p_Avlbl_Md_Tx_Crdt => trc_curMedTxCrEle
4658: ,p_Md_tx_Crdt_Used_YTD => bal_MED_TAX_CR_USED_NG_YTD
4659: ,p_Tx_RUN => trc_LibFpNtgAP
4660: ,p_Tx_YTD => bal_TX_ON_AP_NTG_YTD
4689: trc_AnnEEDbtNtgErn := trc_AnnEEDbtNtgYtd + trc_AnnPymNtgErn;
4690:
4691: --Suffixed the variable with WoDon to denote that donation amount is not deducted.
4692: trc_TxbAnnEEDbtNtgIncWoDon := trc_AnnEEDbtNtgErn - trc_AnnTotNTGAbm;
4693: trc_TxbAnnEEDbtNtgInc :=trc_TxbAnnEEDbtNtgIncWoDon - py_za_tx_utl_01032012.AllowableDeduction(trc_TxbAnnEEDbtNtgIncWoDon,trc_AnnDonAmt);
4694:
4695: -- Threshold Check
4696: IF trc_TxbAnnEEDbtNtgInc >= trc_Threshold THEN
4697: hr_utility.set_location('py_za_tx_01032012.CalCalc',33);
4695: -- Threshold Check
4696: IF trc_TxbAnnEEDbtNtgInc >= trc_Threshold THEN
4697: hr_utility.set_location('py_za_tx_01032012.CalCalc',33);
4698: -- Tax Liability
4699: trc_TotLibNtgEEDbt := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbAnnEEDbtNtgInc);
4700: trc_LibFyNtgEEDbt := trc_TotLibNtgEEDbt - least(trc_TotLibNtgEEDbt,trc_TotLibNtgAP);
4701: trc_TotLibNtgEEDbt := greatest(trc_TotLibNtgEEDbt,trc_TotLibNtgAP);
4702:
4703: hr_utility.set_location('py_za_tx_01032012.CalCalc',34);
4703: hr_utility.set_location('py_za_tx_01032012.CalCalc',34);
4704: trc_LibFpNtgEEDbt := trc_LibFyNtgEEDbt - (bal_TX_ON_EE_DBT_NTG_YTD + bal_MED_TAX_CR_USED_EE_YTD);
4705:
4706: -- Start Medical Tax Credit Changes
4707: py_za_tx_utl_01032012.CalMedTxCrUSEDOns
4708: (p_Avlbl_Md_Tx_Crdt => trc_curMedTxCrEle
4709: ,p_Md_tx_Crdt_Used_YTD => bal_MED_TAX_CR_USED_EE_YTD
4710: ,p_Tx_RUN => trc_LibFpNtgEEDbt
4711: ,p_Tx_YTD => bal_TX_ON_EE_DBT_NTG_YTD
4737: trc_LibFpNtgEEDbt := trc_LibFpNtgEEDbt_Upd;
4738:
4739: -- Net pay Validation
4740: --
4741: py_za_tx_utl_01032012.ValidateTaxOns;
4742:
4743: -- Deemed Remuneration
4744: WrtHrTrc('trc_TxbDmdRmn: '||to_char(trc_TxbDmdRmn));
4745: WrtHrTrc('trc_TotLibDR: '||to_char(trc_TotLibDR));
4860: trc_CalTyp := 'YtdCalc';
4861:
4862: -- Update Global Balance Values with correct TAXABLE values
4863: --Fix for bug#10372926
4864: --py_za_tx_utl_01032012.TrvAll;
4865:
4866: hr_utility.set_location('py_za_tx_01032012.YtdCalc',2);
4867:
4868: -- Ytd Taxable Income
4884: END IF;
4885: ELSE --Continue YtdCalc
4886: hr_utility.set_location('py_za_tx_01032012.YtdCalc',4);
4887: -- Site Factor
4888: trc_SitFactor := dbi_ZA_DYS_IN_YR / py_za_tx_utl_01032012.DaysWorked;
4889:
4890: -- Rebates
4891: py_za_tx_utl_01032012.SetRebates;
4892:
4887: -- Site Factor
4888: trc_SitFactor := dbi_ZA_DYS_IN_YR / py_za_tx_utl_01032012.DaysWorked;
4889:
4890: -- Rebates
4891: py_za_tx_utl_01032012.SetRebates;
4892:
4893: -- Abatements
4894: py_za_tx_utl_01032012.Abatements;
4895:
4890: -- Rebates
4891: py_za_tx_utl_01032012.SetRebates;
4892:
4893: -- Abatements
4894: py_za_tx_utl_01032012.Abatements;
4895:
4896: -- Arrive at Medical tax credit Available for Annual Bonus and Annual paymet
4897: trc_curMedTxCrEle := greatest(bal_MED_AID_TAX_CR_YTD + bal_ANN_MED_AID_TAX_CR_YTD
4898: - (bal_MED_TAX_CR_USED_DR_YTD + bal_MED_TAX_CR_USED_NI_YTD + bal_MED_TAX_CR_USED_FB_YTD + bal_MED_TAX_CR_USED_TA_YTD + bal_MED_TAX_CR_USED_BP_YTD),0,
4918: -- Threshold Check
4919: IF trc_TxbDmdRmn >= trc_Threshold THEN
4920: hr_utility.set_location('py_za_tx_01032012.YtdCalc',7);
4921: -- Tax Liability
4922: trc_TotLibDR := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbDmdRmn);
4923: ELSE
4924: hr_utility.set_location('py_za_tx_01032012.YtdCalc',8);
4925: trc_TotLibDR := 0;
4926: END IF;
4938: -- Taxable Base Income
4939: --TYS2010
4940: --Suffixed the variable with WoDon to denote that donation amount is not deducted.
4941: trc_TxbBseIncWoDon := trc_BseErn - trc_PerTotAbm;
4942: trc_TxbBseInc :=trc_TxbBseIncWoDon - py_za_tx_utl_01032012.AllowableDeduction(trc_TxbBseIncWoDon,trc_PerDonAmt);
4943:
4944: -- Threshold Check
4945: IF trc_TxbBseInc >= trc_Threshold THEN
4946: hr_utility.set_location('py_za_tx_01032012.YtdCalc',11);
4944: -- Threshold Check
4945: IF trc_TxbBseInc >= trc_Threshold THEN
4946: hr_utility.set_location('py_za_tx_01032012.YtdCalc',11);
4947: -- Tax Liability
4948: trc_TotLibBse := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbBseInc);
4949: trc_TotLibBse := greatest(trc_TotLibBse,trc_TotLibDR);
4950: ELSE
4951: hr_utility.set_location('py_za_tx_01032012.YtdCalc',12);
4952: trc_TotLibBse := trc_TotLibDR;
4967: -- Taxable Annual Bonus Income
4968: --TYS2010
4969: --Suffixed the variable with WoDon to denote that donation amount is not deducted.
4970: trc_TxbAnnBonIncWoDon := trc_AnnBonErn - trc_AnnTotAbm;
4971: trc_TxbAnnBonInc :=trc_TxbAnnBonIncWoDon - py_za_tx_utl_01032012.AllowableDeduction(trc_TxbAnnBonIncWoDon,trc_AnnDonAmt);
4972:
4973: -- Threshold Check
4974: IF trc_TxbAnnBonInc >= trc_Threshold THEN
4975: hr_utility.set_location('py_za_tx_01032012.YtdCalc',15);
4973: -- Threshold Check
4974: IF trc_TxbAnnBonInc >= trc_Threshold THEN
4975: hr_utility.set_location('py_za_tx_01032012.YtdCalc',15);
4976: -- Tax Liability
4977: trc_TotLibAB := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbAnnBonInc);
4978: trc_LibFyAB := trc_TotLibAB - least(trc_TotLibAB,trc_TotLibBse);
4979: trc_TotLibAB := greatest(trc_TotLibAB,trc_TotLibBse);
4980: -- Check Bonus Provision
4981: IF bal_BP_YTD <> 0 THEN
4989: trc_LibFpAB := trc_LibFyAB - ( bal_TX_ON_BP_YTD + bal_MED_TAX_CR_USED_BP_YTD
4990: + bal_TX_ON_AB_YTD + bal_MED_TAX_CR_USED_AB_YTD);
4991:
4992: -- Start Medical Tax Credit Changes
4993: py_za_tx_utl_01032012.CalMedTxCrUSEDOns
4994: (p_Avlbl_Md_Tx_Crdt => trc_curMedTxCrEle
4995: ,p_Md_tx_Crdt_Used_YTD => bal_MED_TAX_CR_USED_AB_YTD
4996: ,p_Tx_RUN => trc_LibFpAB
4997: ,p_Tx_YTD => bal_TX_ON_AB_YTD
5011: hr_utility.set_location('py_za_tx_01032012.YtdCalc',19);
5012: trc_LibFpAB := trc_LibFyAB - (bal_TX_ON_AB_YTD + bal_MED_TAX_CR_USED_AB_YTD);
5013:
5014: -- Start Medical Tax Credit Changes
5015: py_za_tx_utl_01032012.CalMedTxCrUSEDOns
5016: (p_Avlbl_Md_Tx_Crdt => trc_curMedTxCrEle
5017: ,p_Md_tx_Crdt_Used_YTD => bal_MED_TAX_CR_USED_AB_YTD
5018: ,p_Tx_RUN => trc_LibFpAB
5019: ,p_Tx_YTD => bal_TX_ON_AB_YTD
5056: -- Taxable Annual Payments Income
5057: --TYS2010
5058: --Suffixed the variable with WoDon to denote that donation amount is not deducted.
5059: trc_TxbAnnPymIncWoDon := trc_AnnPymErn - trc_AnnTotAbm;
5060: trc_TxbAnnPymInc :=trc_TxbAnnPymIncWoDon - py_za_tx_utl_01032012.AllowableDeduction(trc_TxbAnnPymIncWoDon,trc_AnnDonAmt);
5061:
5062: -- Threshold Check
5063: IF trc_TxbAnnPymInc >= trc_Threshold THEN
5064: hr_utility.set_location('py_za_tx_01032012.YtdCalc',24);
5062: -- Threshold Check
5063: IF trc_TxbAnnPymInc >= trc_Threshold THEN
5064: hr_utility.set_location('py_za_tx_01032012.YtdCalc',24);
5065: -- Tax Liability
5066: trc_TotLibAP := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbAnnPymInc);
5067: trc_LibFyAP := trc_TotLibAP - least(trc_TotLibAP,trc_TotLibAB);
5068: trc_TotLibAP := greatest(trc_TotLibAP,trc_TotLibAB);
5069: trc_LibFpAP := trc_LibFyAP - (bal_TX_ON_AP_YTD + bal_MED_TAX_CR_USED_AP_YTD);
5070:
5068: trc_TotLibAP := greatest(trc_TotLibAP,trc_TotLibAB);
5069: trc_LibFpAP := trc_LibFyAP - (bal_TX_ON_AP_YTD + bal_MED_TAX_CR_USED_AP_YTD);
5070:
5071: -- Start Medical Tax Credit Changes
5072: py_za_tx_utl_01032012.CalMedTxCrUSEDOns
5073: (p_Avlbl_Md_Tx_Crdt => trc_curMedTxCrEle
5074: ,p_Md_tx_Crdt_Used_YTD => bal_MED_TAX_CR_USED_AP_YTD
5075: ,p_Tx_RUN => trc_LibFpAP
5076: ,p_Tx_YTD => bal_TX_ON_AP_YTD
5108:
5109: --Suffixed the variable with WoDon to denote that donation amount is not deducted.
5110: -- Taxable Annual Payments Income
5111: trc_TxbAnnPymNtgIncWoDon := trc_AnnPymNtgErn - trc_AnnTotAbm;
5112: trc_TxbAnnPymNtgInc :=trc_TxbAnnPymNtgIncWoDon - py_za_tx_utl_01032012.AllowableDeduction(trc_TxbAnnPymNtgIncWoDon,trc_AnnDonAmt);
5113:
5114: -- Threshold Check
5115: IF trc_TxbAnnPymNtgInc >= trc_Threshold THEN
5116: hr_utility.set_location('py_za_tx_01032012.YtdCalc',28);
5114: -- Threshold Check
5115: IF trc_TxbAnnPymNtgInc >= trc_Threshold THEN
5116: hr_utility.set_location('py_za_tx_01032012.YtdCalc',28);
5117: -- Tax Liability
5118: trc_TotLibNtgAP := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbAnnPymNtgInc);
5119: trc_LibFyNtgAP := trc_TotLibNtgAP - least(trc_TotLibNtgAP,trc_TotLibAP);
5120: trc_TotLibNtgAP := greatest(trc_TotLibNtgAP,trc_TotLibAP);
5121:
5122: hr_utility.set_location('py_za_tx_01032012.YtdCalc',29);
5122: hr_utility.set_location('py_za_tx_01032012.YtdCalc',29);
5123: trc_LibFpNtgAP := trc_LibFyNtgAP - (bal_TX_ON_AP_NTG_YTD + bal_MED_TAX_CR_USED_NG_YTD);
5124:
5125: -- Start Medical Tax Credit Changes
5126: py_za_tx_utl_01032012.CalMedTxCrUSEDOns
5127: (p_Avlbl_Md_Tx_Crdt => trc_curMedTxCrEle
5128: ,p_Md_tx_Crdt_Used_YTD => bal_MED_TAX_CR_USED_NG_YTD
5129: ,p_Tx_RUN => trc_LibFpNtgAP
5130: ,p_Tx_YTD => bal_TX_ON_AP_NTG_YTD
5162: trc_AnnEEDbtNtgErn := trc_AnnEEDbtNtgYtd + trc_AnnPymNtgErn;
5163:
5164: --Suffixed the variable with WoDon to denote that donation amount is not deducted.
5165: trc_TxbAnnEEDbtNtgIncWoDon := trc_AnnEEDbtNtgErn - trc_AnnTotNTGAbm;
5166: trc_TxbAnnEEDbtNtgInc :=trc_TxbAnnEEDbtNtgIncWoDon - py_za_tx_utl_01032012.AllowableDeduction(trc_TxbAnnEEDbtNtgIncWoDon,trc_AnnDonAmt);
5167:
5168: -- Threshold Check
5169: IF trc_TxbAnnEEDbtNtgInc >= trc_Threshold THEN
5170: hr_utility.set_location('py_za_tx_01032012.YtdCalc',33);
5168: -- Threshold Check
5169: IF trc_TxbAnnEEDbtNtgInc >= trc_Threshold THEN
5170: hr_utility.set_location('py_za_tx_01032012.YtdCalc',33);
5171: -- Tax Liability
5172: trc_TotLibNtgEEDbt := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbAnnEEDbtNtgInc);
5173: trc_LibFyNtgEEDbt := trc_TotLibNtgEEDbt - least(trc_TotLibNtgEEDbt,trc_TotLibNtgAP);
5174: trc_TotLibNtgEEDbt := greatest(trc_TotLibNtgEEDbt,trc_TotLibNtgAP);
5175:
5176: hr_utility.set_location('py_za_tx_01032012.YtdCalc',34);
5176: hr_utility.set_location('py_za_tx_01032012.YtdCalc',34);
5177: trc_LibFpNtgEEDbt := trc_LibFyNtgEEDbt - (bal_TX_ON_EE_DBT_NTG_YTD + bal_MED_TAX_CR_USED_EE_YTD);
5178:
5179: -- Start Medical Tax Credit Changes
5180: py_za_tx_utl_01032012.CalMedTxCrUSEDOns
5181: (p_Avlbl_Md_Tx_Crdt => trc_curMedTxCrEle
5182: ,p_Md_tx_Crdt_Used_YTD => bal_MED_TAX_CR_USED_EE_YTD
5183: ,p_Tx_RUN => trc_LibFpNtgEEDbt
5184: ,p_Tx_YTD => bal_TX_ON_EE_DBT_NTG_YTD
5212: trc_LibFpNtgEEDbt := trc_LibFpNtgEEDbt_Upd;
5213:
5214: -- Net Pay validation
5215: --
5216: py_za_tx_utl_01032012.ValidateTaxOns;
5217:
5218: hr_utility.set_location('py_za_tx_01032012.YtdCalc',37);
5219:
5220: -- Deemed Remuneration
5338: --
5339: --Fix for bug#10372926
5340: --bal_TOT_TXB_TA_PTD := bal_TOT_TXB_TA_PTD * glb_ZA_TRV_ALL_TX_PRC / 100;
5341:
5342: --py_za_tx_utl_01032012.TrvAll;
5343:
5344: hr_utility.set_location('py_za_tx_01032012.NorCalc',2);
5345:
5346: bal_TOT_TXB_PO_PTD := bal_TOT_TXB_PO_PTD * glb_ZA_PBL_TX_PRC / 100;
5354: + bal_TOT_TXB_TA_PTD
5355: + bal_BP_PTD
5356: );
5357: -- Period Factor
5358: py_za_tx_utl_01032012.PeriodFactor;
5359:
5360: -- Possible Periods Factor
5361: py_za_tx_utl_01032012.PossiblePeriodsFactor;
5362:
5357: -- Period Factor
5358: py_za_tx_utl_01032012.PeriodFactor;
5359:
5360: -- Possible Periods Factor
5361: py_za_tx_utl_01032012.PossiblePeriodsFactor;
5362:
5363: -- Rebates
5364: py_za_tx_utl_01032012.SetRebates;
5365:
5360: -- Possible Periods Factor
5361: py_za_tx_utl_01032012.PossiblePeriodsFactor;
5362:
5363: -- Rebates
5364: py_za_tx_utl_01032012.SetRebates;
5365:
5366: -- Abatements
5367: py_za_tx_utl_01032012.Abatements;
5368:
5363: -- Rebates
5364: py_za_tx_utl_01032012.SetRebates;
5365:
5366: -- Abatements
5367: py_za_tx_utl_01032012.Abatements;
5368:
5369: hr_utility.set_location('py_za_tx_01032012.NorCalc',3);
5370:
5371: trc_curMedTxCrEle := greatest(bal_MED_AID_TAX_CR_YTD + bal_ANN_MED_AID_TAX_CR_YTD,0,bal_MED_AID_TAX_CR_USED_YTD + bal_MED_AID_TAX_CR_USED_LS_YTD);
5383: -- Threshold Check
5384: IF trc_TxbDmdRmn >= trc_Threshold THEN
5385: hr_utility.set_location('py_za_tx_01032012.NorCalc',5);
5386: -- Tax Liability
5387: trc_TotLibDR := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbDmdRmn);
5388: trc_LibFyDR := trc_TotLibDR - 0;
5389: trc_TotLibDR := greatest(trc_TotLibDR,0);
5390: -- DeAnnualise
5391: trc_LibFpDR := py_za_tx_utl_01032012.DeAnnualise
5387: trc_TotLibDR := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbDmdRmn);
5388: trc_LibFyDR := trc_TotLibDR - 0;
5389: trc_TotLibDR := greatest(trc_TotLibDR,0);
5390: -- DeAnnualise
5391: trc_LibFpDR := py_za_tx_utl_01032012.DeAnnualise
5392: ( p_Liab => trc_LibFyDR
5393: , p_TxOnYtd => bal_TX_ON_DR_YTD + bal_MED_TAX_CR_USED_DR_YTD
5394: , p_TxOnPtd => bal_TX_ON_DR_PTD + bal_MED_TAX_CR_USED_DR_PTD
5395: );
5394: , p_TxOnPtd => bal_TX_ON_DR_PTD + bal_MED_TAX_CR_USED_DR_PTD
5395: );
5396:
5397: -- Start Medical Tax Credit Changes
5398: py_za_tx_utl_01032012.CalMedTxCrUSEDOns
5399: (p_Avlbl_Md_Tx_Crdt => trc_curMedTxCrEle
5400: ,p_Md_tx_Crdt_Used_YTD => bal_MED_TAX_CR_USED_DR_YTD
5401: ,p_Tx_RUN => trc_LibFpDR
5402: ,p_Tx_YTD => bal_TX_ON_DR_YTD
5443: IF (dbi_TX_MTD = 'C' AND trc_NorIncYtd <> 0) OR (dbi_TX_MTD = 'N' AND trc_NorIncPtd > 0) THEN
5444: hr_utility.set_location('py_za_tx_01032012.NorCalc',8);
5445:
5446: -- Annualise Normal Income
5447: trc_NorErn := py_za_tx_utl_01032012.Annualise
5448: (p_YtdInc => trc_NorIncYtd
5449: ,p_PtdInc => trc_NorIncPtd
5450: );
5451: --TYS2010
5451: --TYS2010
5452: -- Taxable Normal Income
5453: --Suffixed the variable with WoDon to denote that donation amount is not deducted.
5454: trc_TxbNorIncWoDon := trc_NorErn - trc_PerTotAbm;
5455: trc_TxbNorInc :=trc_TxbNorIncWoDon - py_za_tx_utl_01032012.AllowableDeduction(trc_TxbNorIncWoDon,trc_PerDonAmt);
5456: -- Threshold Check
5457: IF trc_TxbNorInc >= trc_Threshold THEN
5458: hr_utility.set_location('py_za_tx_01032012.NorCalc',9);
5459: -- Tax Liability
5456: -- Threshold Check
5457: IF trc_TxbNorInc >= trc_Threshold THEN
5458: hr_utility.set_location('py_za_tx_01032012.NorCalc',9);
5459: -- Tax Liability
5460: trc_TotLibNI := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbNorInc);
5461: trc_LibFyNI := trc_TotLibNI - least(trc_TotLibNI,trc_TotLibDR);
5462: trc_TotLibNI := greatest(trc_TotLibNI,trc_TotLibDR);
5463: -- DeAnnualise
5464: trc_LibFpNI := py_za_tx_utl_01032012.DeAnnualise
5460: trc_TotLibNI := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbNorInc);
5461: trc_LibFyNI := trc_TotLibNI - least(trc_TotLibNI,trc_TotLibDR);
5462: trc_TotLibNI := greatest(trc_TotLibNI,trc_TotLibDR);
5463: -- DeAnnualise
5464: trc_LibFpNI := py_za_tx_utl_01032012.DeAnnualise
5465: ( p_Liab => trc_LibFyNI
5466: , p_TxOnYtd => bal_TX_ON_NI_YTD + bal_MED_TAX_CR_USED_NI_YTD
5467: , p_TxOnPtd => bal_TX_ON_NI_PTD + bal_MED_TAX_CR_USED_NI_PTD
5468: );
5467: , p_TxOnPtd => bal_TX_ON_NI_PTD + bal_MED_TAX_CR_USED_NI_PTD
5468: );
5469:
5470: -- Start Medical Tax Credit Changes
5471: py_za_tx_utl_01032012.CalMedTxCrUSEDOns
5472: (p_Avlbl_Md_Tx_Crdt => trc_curMedTxCrEle
5473: ,p_Md_tx_Crdt_Used_YTD => bal_MED_TAX_CR_USED_NI_YTD
5474: ,p_Tx_RUN => trc_LibFpNI
5475: ,p_Tx_YTD => bal_TX_ON_NI_YTD
5529: IF (dbi_TX_MTD = 'C' AND trc_FrnBenYtd <> 0) OR (dbi_TX_MTD = 'N' AND trc_FrnBenPtd > 0) THEN
5530: hr_utility.set_location('py_za_tx_01032012.NorCalc',12);
5531:
5532: -- Annualise Fringe Benefits
5533: trc_FrnBenErn := py_za_tx_utl_01032012.Annualise
5534: ( p_YtdInc => trc_FrnBenYtd
5535: , p_PtdInc => trc_FrnBenPtd
5536: ) + trc_NorErn;
5537: --TYS2010
5537: --TYS2010
5538: --Suffixed the variable with WoDon to denote that donation amount is not deducted.
5539: -- Taxable Fringe Income
5540: trc_TxbFrnIncWoDon := trc_FrnBenErn - trc_PerTotAbm;
5541: trc_TxbFrnInc :=trc_TxbFrnIncWoDon - py_za_tx_utl_01032012.AllowableDeduction(trc_TxbFrnIncWoDon,trc_PerDonAmt);
5542:
5543: -- Threshold Check
5544: IF trc_TxbFrnInc >= trc_Threshold THEN
5545: hr_utility.set_location('py_za_tx_01032012.NorCalc',13);
5543: -- Threshold Check
5544: IF trc_TxbFrnInc >= trc_Threshold THEN
5545: hr_utility.set_location('py_za_tx_01032012.NorCalc',13);
5546: -- Tax Liability
5547: trc_TotLibFB := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbFrnInc);
5548: trc_LibFyFB := trc_TotLibFB - least(trc_TotLibFB,trc_TotLibNI);
5549: trc_TotLibFB := greatest(trc_TotLibFB,trc_TotLibNI);
5550: -- DeAnnualise
5551: trc_LibFpFB := py_za_tx_utl_01032012.DeAnnualise
5547: trc_TotLibFB := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbFrnInc);
5548: trc_LibFyFB := trc_TotLibFB - least(trc_TotLibFB,trc_TotLibNI);
5549: trc_TotLibFB := greatest(trc_TotLibFB,trc_TotLibNI);
5550: -- DeAnnualise
5551: trc_LibFpFB := py_za_tx_utl_01032012.DeAnnualise
5552: ( trc_LibFyFB
5553: , bal_TX_ON_FB_YTD + bal_MED_TAX_CR_USED_FB_YTD
5554: , bal_TX_ON_FB_PTD + bal_MED_TAX_CR_USED_FB_PTD
5555: );
5554: , bal_TX_ON_FB_PTD + bal_MED_TAX_CR_USED_FB_PTD
5555: );
5556:
5557: -- Start Medical Tax Credit Changes
5558: py_za_tx_utl_01032012.CalMedTxCrUSEDOns
5559: (p_Avlbl_Md_Tx_Crdt => trc_curMedTxCrEle
5560: ,p_Md_tx_Crdt_Used_YTD => bal_MED_TAX_CR_USED_FB_YTD
5561: ,p_Tx_RUN => trc_LibFpFB
5562: ,p_Tx_YTD => bal_TX_ON_FB_YTD
5617: hr_utility.set_location('py_za_tx_01032012.NorCalc',16);
5618: -- Ptd Travel Allowance
5619: trc_TrvAllPtd := bal_TOT_TXB_TA_PTD;
5620: -- Annualise Travel Allowance
5621: trc_TrvAllErn := py_za_tx_utl_01032012.Annualise
5622: ( p_YtdInc => trc_TrvAllYtd
5623: , p_PtdInc => trc_TrvAllPtd
5624: ) + trc_FrnBenErn;
5625: --TYS2010
5625: --TYS2010
5626: --Suffixed the variable with WoDon to denote that donation amount is not deducted.
5627: -- Taxable Travel Income
5628: trc_TxbTrvIncWoDon := trc_TrvAllErn - trc_PerTotAbm;
5629: trc_TxbTrvInc :=trc_TxbTrvIncWoDon - py_za_tx_utl_01032012.AllowableDeduction(trc_TxbTrvIncWoDon,trc_PerDonAmt);
5630:
5631: -- Threshold Check
5632: IF trc_TxbTrvInc >= trc_Threshold THEN
5633: hr_utility.set_location('py_za_tx_01032012.NorCalc',17);
5631: -- Threshold Check
5632: IF trc_TxbTrvInc >= trc_Threshold THEN
5633: hr_utility.set_location('py_za_tx_01032012.NorCalc',17);
5634: -- Tax Liability
5635: trc_TotLibTA := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbTrvInc);
5636: trc_LibFyTA := trc_TotLibTA - least(trc_TotLibTA,trc_TotLibFB);
5637: trc_TotLibTA := greatest(trc_TotLibTA,trc_TotLibFB);
5638: -- DeAnnualise
5639: trc_LibFpTA := py_za_tx_utl_01032012.DeAnnualise
5635: trc_TotLibTA := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbTrvInc);
5636: trc_LibFyTA := trc_TotLibTA - least(trc_TotLibTA,trc_TotLibFB);
5637: trc_TotLibTA := greatest(trc_TotLibTA,trc_TotLibFB);
5638: -- DeAnnualise
5639: trc_LibFpTA := py_za_tx_utl_01032012.DeAnnualise
5640: ( trc_LibFyTA
5641: , bal_TX_ON_TA_YTD + bal_MED_TAX_CR_USED_TA_YTD
5642: , bal_TX_ON_TA_PTD + bal_MED_TAX_CR_USED_TA_PTD
5643: );
5642: , bal_TX_ON_TA_PTD + bal_MED_TAX_CR_USED_TA_PTD
5643: );
5644:
5645: -- Start Medical Tax Credit Changes
5646: py_za_tx_utl_01032012.CalMedTxCrUSEDOns
5647: (p_Avlbl_Md_Tx_Crdt => trc_curMedTxCrEle
5648: ,p_Md_tx_Crdt_Used_YTD => bal_MED_TAX_CR_USED_TA_YTD
5649: ,p_Tx_RUN => trc_LibFpTA
5650: ,p_Tx_YTD => bal_TX_ON_TA_YTD
5703: -- If Tax Method is Non Cumulative check for PTD Income
5704: IF (dbi_TX_MTD = 'C' AND trc_BonProYtd <> 0) OR (dbi_TX_MTD = 'N' AND trc_BonProPtd > 0) THEN
5705: hr_utility.set_location('py_za_tx_01032012.NorCalc',20);
5706: -- Annualise Bonus Provision
5707: trc_BonProErn := py_za_tx_utl_01032012.Annualise
5708: ( p_YtdInc => trc_BonProYtd
5709: , p_PtdInc => trc_BonProPtd
5710: ) + trc_TrvAllErn;
5711: --TYS2010
5711: --TYS2010
5712: --Suffixed the variable with WoDon to denote that donation amount is not deducted.
5713: -- Taxable Bonus Provision Income
5714: trc_TxbBonProIncWoDon := trc_BonProErn - trc_PerTotAbm;
5715: trc_TxbBonProInc :=trc_TxbBonProIncWoDon - py_za_tx_utl_01032012.AllowableDeduction(trc_TxbBonProIncWoDon,trc_PerDonAmt);
5716:
5717: -- Threshold Check
5718: IF trc_TxbBonProInc >= trc_Threshold THEN
5719: hr_utility.set_location('py_za_tx_01032012.NorCalc',21);
5717: -- Threshold Check
5718: IF trc_TxbBonProInc >= trc_Threshold THEN
5719: hr_utility.set_location('py_za_tx_01032012.NorCalc',21);
5720: -- Tax Liability
5721: trc_TotLibBP := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbBonProInc);
5722: trc_LibFyBP := trc_TotLibBP - least(trc_TotLibBP,trc_TotLibTA);
5723: trc_TotLibBP := greatest(trc_TotLibBP,trc_TotLibTA);
5724: -- DeAnnualise
5725: trc_LibFpBP := py_za_tx_utl_01032012.DeAnnualise
5721: trc_TotLibBP := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbBonProInc);
5722: trc_LibFyBP := trc_TotLibBP - least(trc_TotLibBP,trc_TotLibTA);
5723: trc_TotLibBP := greatest(trc_TotLibBP,trc_TotLibTA);
5724: -- DeAnnualise
5725: trc_LibFpBP := py_za_tx_utl_01032012.DeAnnualise
5726: ( trc_LibFyBP
5727: , bal_TX_ON_BP_YTD + bal_MED_TAX_CR_USED_BP_YTD
5728: , bal_TX_ON_BP_PTD + bal_MED_TAX_CR_USED_BP_PTD
5729: );
5728: , bal_TX_ON_BP_PTD + bal_MED_TAX_CR_USED_BP_PTD
5729: );
5730:
5731: -- Start Medical Tax Credit Changes
5732: py_za_tx_utl_01032012.CalMedTxCrUSEDOns
5733: (p_Avlbl_Md_Tx_Crdt => trc_curMedTxCrEle
5734: ,p_Md_tx_Crdt_Used_YTD => bal_MED_TAX_CR_USED_BP_YTD
5735: ,p_Tx_RUN => trc_LibFpBP
5736: ,p_Tx_YTD => bal_TX_ON_BP_YTD
5790: --TYS2010
5791: --Suffixed the variable with WoDon to denote that donation amount is not deducted.
5792: -- Taxable Annual Bonus Income
5793: trc_TxbAnnBonIncWoDon := trc_AnnBonErn - trc_AnnTotAbm;
5794: trc_TxbAnnBonInc :=trc_TxbAnnBonIncWoDon - py_za_tx_utl_01032012.AllowableDeduction(trc_TxbAnnBonIncWoDon,trc_AnnDonAmt);
5795:
5796: -- Threshold Check
5797: IF trc_TxbAnnBonInc >= trc_Threshold THEN
5798: hr_utility.set_location('py_za_tx_01032012.NorCalc',25);
5796: -- Threshold Check
5797: IF trc_TxbAnnBonInc >= trc_Threshold THEN
5798: hr_utility.set_location('py_za_tx_01032012.NorCalc',25);
5799: -- Tax Liability
5800: trc_TotLibAB := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbAnnBonInc);
5801: trc_LibFyAB := trc_TotLibAB - least(trc_TotLibAB,trc_TotLibTA);
5802: trc_TotLibAB := greatest(trc_TotLibAB,trc_TotLibTA);
5803: -- Check Bonus Provision
5804: IF trc_BonProYtd <> 0 THEN
5815: + bal_TX_ON_AB_YTD
5816: + bal_MED_TAX_CR_USED_AB_YTD);
5817:
5818: -- Start Medical Tax Credit Changes
5819: py_za_tx_utl_01032012.CalMedTxCrUSEDOns
5820: (p_Avlbl_Md_Tx_Crdt => trc_curMedTxCrEle
5821: ,p_Md_tx_Crdt_Used_YTD => bal_MED_TAX_CR_USED_AB_YTD
5822: ,p_Tx_RUN => trc_LibFpAB
5823: ,p_Tx_YTD => bal_TX_ON_AB_YTD
5837: hr_utility.set_location('py_za_tx_01032012.NorCalc',29);
5838: trc_LibFpAB := trc_LibFyAB - (bal_TX_ON_AB_YTD + bal_MED_TAX_CR_USED_AB_YTD);
5839:
5840: -- Start Medical Tax Credit Changes
5841: py_za_tx_utl_01032012.CalMedTxCrUSEDOns
5842: (p_Avlbl_Md_Tx_Crdt => trc_curMedTxCrEle
5843: ,p_Md_tx_Crdt_Used_YTD => bal_MED_TAX_CR_USED_AB_YTD
5844: ,p_Tx_RUN => trc_LibFpAB
5845: ,p_Tx_YTD => bal_TX_ON_AB_YTD
5900: --TYS2010
5901: --Suffixed the variable with WoDon to denote that donation amount is not deducted.
5902: -- Taxable Annual Payments Income
5903: trc_TxbAnnPymIncWoDon := trc_AnnPymErn - trc_AnnTotAbm;
5904: trc_TxbAnnPymInc :=trc_TxbAnnPymIncWoDon - py_za_tx_utl_01032012.AllowableDeduction(trc_TxbAnnPymIncWoDon,trc_AnnDonAmt);
5905:
5906: -- Threshold Check
5907: IF trc_TxbAnnPymInc >= trc_Threshold THEN
5908: hr_utility.set_location('py_za_tx_01032012.NorCalc',33);
5906: -- Threshold Check
5907: IF trc_TxbAnnPymInc >= trc_Threshold THEN
5908: hr_utility.set_location('py_za_tx_01032012.NorCalc',33);
5909: -- Tax Liability
5910: trc_TotLibAP := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbAnnPymInc);
5911: trc_LibFyAP := trc_TotLibAP - least(trc_TotLibAP,trc_TotLibAB);
5912: trc_TotLibAP := greatest(trc_TotLibAP,trc_TotLibAB);
5913: hr_utility.set_location('py_za_tx_01032012.NorCalc',34);
5914: trc_LibFpAP := trc_LibFyAP - (bal_TX_ON_AP_YTD + bal_MED_TAX_CR_USED_AP_YTD) ;
5913: hr_utility.set_location('py_za_tx_01032012.NorCalc',34);
5914: trc_LibFpAP := trc_LibFyAP - (bal_TX_ON_AP_YTD + bal_MED_TAX_CR_USED_AP_YTD) ;
5915:
5916: -- Start Medical Tax Credit Changes
5917: py_za_tx_utl_01032012.CalMedTxCrUSEDOns
5918: (p_Avlbl_Md_Tx_Crdt => trc_curMedTxCrEle
5919: ,p_Md_tx_Crdt_Used_YTD => bal_MED_TAX_CR_USED_AP_YTD
5920: ,p_Tx_RUN => trc_LibFpAP
5921: ,p_Tx_YTD => bal_TX_ON_AP_YTD
5976: hr_utility.set_location('py_za_tx_01032012.NorCalc',37);
5977: -- Ptd Public Office Allowance
5978: trc_PblOffPtd := bal_TOT_TXB_PO_PTD;
5979: -- Annualise Public Office Allowance
5980: trc_PblOffErn := py_za_tx_utl_01032012.Annualise
5981: ( p_YtdInc => trc_PblOffYtd
5982: , p_PtdInc => trc_PblOffPtd
5983: ) + trc_AnnPymErn;
5984: --TYS2010
5984: --TYS2010
5985: --Suffixed the variable with WoDon to denote that donation amount is not deducted.
5986: -- Taxable Public Office Allowance
5987: trc_TxbPblOffIncWoDon := trc_PblOffErn - trc_AnnTotAbm;
5988: trc_TxbPblOffInc :=trc_TxbPblOffIncWoDon - py_za_tx_utl_01032012.AllowableDeduction(trc_TxbPblOffIncWoDon,trc_AnnDonAmt);
5989:
5990: -- Threshold Check
5991: IF trc_TxbPblOffInc >= trc_Threshold THEN
5992: hr_utility.set_location('py_za_tx_01032012.NorCalc',38);
5990: -- Threshold Check
5991: IF trc_TxbPblOffInc >= trc_Threshold THEN
5992: hr_utility.set_location('py_za_tx_01032012.NorCalc',38);
5993: -- Tax Liability
5994: trc_TotLibPO := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbPblOffInc);
5995: trc_LibFyPO := trc_TotLibPO - least(trc_TotLibPO,trc_TotLibAP);
5996: trc_TotLibPO := greatest(trc_TotLibPO,trc_TotLibAP);
5997: -- DeAnnualise
5998: trc_LibFpPO := py_za_tx_utl_01032012.DeAnnualise
5994: trc_TotLibPO := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbPblOffInc);
5995: trc_LibFyPO := trc_TotLibPO - least(trc_TotLibPO,trc_TotLibAP);
5996: trc_TotLibPO := greatest(trc_TotLibPO,trc_TotLibAP);
5997: -- DeAnnualise
5998: trc_LibFpPO := py_za_tx_utl_01032012.DeAnnualise
5999: ( trc_LibFyPO
6000: , bal_TX_ON_PO_YTD + bal_MED_TAX_CR_USED_PO_YTD
6001: , bal_TX_ON_PO_PTD + bal_MED_TAX_CR_USED_PO_PTD
6002: );
6001: , bal_TX_ON_PO_PTD + bal_MED_TAX_CR_USED_PO_PTD
6002: );
6003:
6004: -- Start Medical Tax Credit Changes
6005: py_za_tx_utl_01032012.CalMedTxCrUSEDOns
6006: (p_Avlbl_Md_Tx_Crdt => trc_curMedTxCrEle
6007: ,p_Md_tx_Crdt_Used_YTD => bal_MED_TAX_CR_USED_PO_YTD
6008: ,p_Tx_RUN => trc_LibFpPO
6009: ,p_Tx_YTD => bal_TX_ON_PO_YTD
6064:
6065: --Suffixed the variable with WoDon to denote that donation amount is not deducted.
6066: -- Taxable Annual Payments Income
6067: trc_TxbAnnPymNtgIncWoDon := trc_AnnPymNtgErn - trc_AnnTotAbm;
6068: trc_TxbAnnPymNtgInc :=trc_TxbAnnPymNtgIncWoDon - py_za_tx_utl_01032012.AllowableDeduction(trc_TxbAnnPymNtgIncWoDon,trc_AnnDonAmt);
6069:
6070: -- Threshold Check
6071: IF trc_TxbAnnPymNtgInc >= trc_Threshold THEN
6072: hr_utility.set_location('py_za_tx_01032012.NorCalc',42);
6070: -- Threshold Check
6071: IF trc_TxbAnnPymNtgInc >= trc_Threshold THEN
6072: hr_utility.set_location('py_za_tx_01032012.NorCalc',42);
6073: -- Tax Liability
6074: trc_TotLibNtgAP := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbAnnPymNtgInc);
6075: trc_LibFyNtgAP := trc_TotLibNtgAP - least(trc_TotLibNtgAP,trc_TotLibPO);
6076: trc_TotLibNtgAP := greatest(trc_TotLibNtgAP,trc_TotLibPO);
6077:
6078: hr_utility.set_location('py_za_tx_01032012.NorCalc',43);
6078: hr_utility.set_location('py_za_tx_01032012.NorCalc',43);
6079: trc_LibFpNtgAP := trc_LibFyNtgAP - (bal_TX_ON_AP_NTG_YTD + bal_MED_TAX_CR_USED_NG_YTD);
6080:
6081: -- Start Medical Tax Credit Changes
6082: py_za_tx_utl_01032012.CalMedTxCrUSEDOns
6083: (p_Avlbl_Md_Tx_Crdt => trc_curMedTxCrEle
6084: ,p_Md_tx_Crdt_Used_YTD => bal_MED_TAX_CR_USED_NG_YTD
6085: ,p_Tx_RUN => trc_LibFpNtgAP
6086: ,p_Tx_YTD => bal_TX_ON_AP_NTG_YTD
6126: trc_AnnEEDbtNtgErn := trc_AnnEEDbtNtgYtd + trc_AnnPymNtgErn;
6127:
6128: --Suffixed the variable with WoDon to denote that donation amount is not deducted.
6129: trc_TxbAnnEEDbtNtgIncWoDon := trc_AnnEEDbtNtgErn - trc_AnnTotNTGAbm;
6130: trc_TxbAnnEEDbtNtgInc :=trc_TxbAnnEEDbtNtgIncWoDon - py_za_tx_utl_01032012.AllowableDeduction(trc_TxbAnnEEDbtNtgIncWoDon,trc_AnnDonAmt);
6131:
6132: -- Threshold Check
6133: IF trc_TxbAnnEEDbtNtgInc >= trc_Threshold THEN
6134: hr_utility.set_location('py_za_tx_01032012.NorCalc',47);
6132: -- Threshold Check
6133: IF trc_TxbAnnEEDbtNtgInc >= trc_Threshold THEN
6134: hr_utility.set_location('py_za_tx_01032012.NorCalc',47);
6135: -- Tax Liability
6136: trc_TotLibNtgEEDbt := py_za_tx_utl_01032012.TaxLiability(p_Amt => trc_TxbAnnEEDbtNtgInc);
6137: trc_LibFyNtgEEDbt := trc_TotLibNtgEEDbt - least(trc_TotLibNtgEEDbt,trc_TotLibNtgAP);
6138: trc_TotLibNtgEEDbt := greatest(trc_TotLibNtgEEDbt,trc_TotLibNtgAP);
6139:
6140: hr_utility.set_location('py_za_tx_01032012.NorCalc',48);
6140: hr_utility.set_location('py_za_tx_01032012.NorCalc',48);
6141: trc_LibFpNtgEEDbt := trc_LibFyNtgEEDbt - (bal_TX_ON_EE_DBT_NTG_YTD + bal_MED_TAX_CR_USED_EE_YTD) ;
6142:
6143: -- Start Medical Tax Credit Changes
6144: py_za_tx_utl_01032012.CalMedTxCrUSEDOns
6145: (p_Avlbl_Md_Tx_Crdt => trc_curMedTxCrEle
6146: ,p_Md_tx_Crdt_Used_YTD => bal_MED_TAX_CR_USED_EE_YTD
6147: ,p_Tx_RUN => trc_LibFpNtgEEDbt
6148: ,p_Tx_YTD => bal_TX_ON_EE_DBT_NTG_YTD
6190: trc_LibFpNtgEEDbt := trc_LibFpNtgEEDbt_Upd;
6191:
6192: -- Net Pay Validation
6193: --
6194: py_za_tx_utl_01032012.ValidateTaxOns;
6195:
6196: hr_utility.set_location('py_za_tx_01032012.NorCalc',51);
6197:
6198: -- Deemed Remuneration
7277:
7278:
7279: -- Set hr_utility globals if debugging
7280: --
7281: -- py_za_tx_utl_01032012.g_HrTraceEnabled := TRUE;
7282: -- py_za_tx_utl_01032012.g_HrTracePipeName := 'ZATAX';
7283:
7284: -- Call hr_utility start procedure
7285: py_za_tx_utl_01032012.StartHrTrace;
7278:
7279: -- Set hr_utility globals if debugging
7280: --
7281: -- py_za_tx_utl_01032012.g_HrTraceEnabled := TRUE;
7282: -- py_za_tx_utl_01032012.g_HrTracePipeName := 'ZATAX';
7283:
7284: -- Call hr_utility start procedure
7285: py_za_tx_utl_01032012.StartHrTrace;
7286:
7281: -- py_za_tx_utl_01032012.g_HrTraceEnabled := TRUE;
7282: -- py_za_tx_utl_01032012.g_HrTracePipeName := 'ZATAX';
7283:
7284: -- Call hr_utility start procedure
7285: py_za_tx_utl_01032012.StartHrTrace;
7286:
7287: l_65Year := add_months(py_za_tx_01032012.dbi_PER_DTE_OF_BRTH,780);
7288: -- Setup Trace Header Info
7289: WrtHrTrc(' ');
7742: trc_LSDirTab.delete;
7743:
7744: -- Only If the employee is below 65 year the Medical Tax credit Should be calculated
7745: -- So making the Available Medical Tax Credit as Zero for others.
7746: IF l_65Year <= dbi_ZA_TX_YR_END or py_za_tx_utl_01032012.AllowRefund(p_65Year => l_65Year) THEN
7747: bal_MED_AID_TAX_CR_CMTD := 0;
7748: bal_MED_AID_TAX_CR_CYTD := 0;
7749: bal_MED_AID_TAX_CR_RUN := 0;
7750: bal_MED_AID_TAX_CR_PTD := 0;
7851: hr_utility.set_location('l_MdTxCrdtUEE_Adj:'||l_MdTxCrdtUEE_Adj,99);
7852: END IF;
7853:
7854: -- Bug 14168167
7855: IF py_za_tx_utl_01032012.AllowRefund(p_65Year => l_65Year) THEN
7856:
7857: bal_MED_AID_TAX_CR_USED_CMTD := 0;
7858: bal_MED_AID_TAX_CR_USED_CYTD := 0;
7859: bal_MED_AID_TAX_CR_USED_RUN := 0;
7966:
7967: trc_LibFpNI := trc_LibFpNI_Upd;
7968:
7969: -- Standard NetPay Validation
7970: py_za_tx_utl_01032012.ValidateTaxOns;
7971: END IF;
7972: -- D = Directive Percentage
7973: -- P = Private Director wth Directive Percentage
7974: --
7987: ELSE
7988: IF trc_OvrTxCalc AND trc_OvrTyp = 'P' THEN
7989: hr_utility.set_location('py_za_tx_01032012.ZaTx_01032012',16);
7990: trc_OvrWrn := 'WARNING: Tax Override - '||to_char(trc_OvrPrc)||' Percent';
7991: -- Percentage taken into account in py_za_tx_utl_01032012.TaxLiability
7992: END IF;
7993: -- Check Directive Number First
7994: IF dbi_TX_DIR_NUM = 'NULL' THEN
7995: hr_utility.set_location('py_za_tx_01032012.ZaTx_01032012',17);
8032: ELSE
8033: IF trc_OvrTxCalc AND trc_OvrTyp = 'P' THEN
8034: hr_utility.set_location('py_za_tx_01032012.ZaTx_01032012',25);
8035: trc_OvrWrn := 'WARNING: Tax Override - '||to_char(trc_OvrPrc)||' Percent';
8036: -- Percentage taken into account in py_za_tx_utl_01032012.TaxLiability
8037: END IF;
8038: hr_utility.set_location('py_za_tx_01032012.ZaTx_01032012',26);
8039: -- Simply Execute the Directive Calculation
8040: DirCalc;
8062: IF trc_OvrTxCalc AND trc_OvrTyp = 'V' THEN
8063: hr_utility.set_location('py_za_tx_01032012.ZaTx_01032012',32);
8064: trc_CalTyp := 'OvrCalc';
8065: trc_OvrWrn := 'WARNING: Tax Override - Total Tax Value: '||to_char(trc_LibFpNI + trc_LibFpAP);
8066: py_za_tx_utl_01032012.SetRebates;
8067: ELSE
8068: hr_utility.set_location('py_za_tx_01032012.ZaTx_01032012',33);
8069: SeaCalc;
8070: END IF;
8083: IF trc_OvrTxCalc AND trc_OvrTyp = 'V' THEN
8084: hr_utility.set_location('py_za_tx_01032012.ZaTx_01032012',35);
8085: trc_CalTyp := 'OvrCalc';
8086: trc_OvrWrn := 'WARNING: Tax Override - Total Tax Value: '||to_char(trc_LibFpNI + trc_LibFpAP);
8087: py_za_tx_utl_01032012.SetRebates;
8088: trc_SitFactor := dbi_ZA_DYS_IN_YR / py_za_tx_utl_01032012.DaysWorked;
8089: ELSIF trc_OvrTxCalc AND trc_OvrTyp = 'S' THEN
8090: hr_utility.set_location('py_za_tx_01032012.ZaTx_01032012',36);
8091: trc_CalTyp := 'OvrCalc';
8084: hr_utility.set_location('py_za_tx_01032012.ZaTx_01032012',35);
8085: trc_CalTyp := 'OvrCalc';
8086: trc_OvrWrn := 'WARNING: Tax Override - Total Tax Value: '||to_char(trc_LibFpNI + trc_LibFpAP);
8087: py_za_tx_utl_01032012.SetRebates;
8088: trc_SitFactor := dbi_ZA_DYS_IN_YR / py_za_tx_utl_01032012.DaysWorked;
8089: ELSIF trc_OvrTxCalc AND trc_OvrTyp = 'S' THEN
8090: hr_utility.set_location('py_za_tx_01032012.ZaTx_01032012',36);
8091: trc_CalTyp := 'OvrCalc';
8092: trc_OvrWrn := 'WARNING: Tax Override - Forced Site Calculation';
8096: ELSE
8097: IF trc_OvrTxCalc AND trc_OvrTyp = 'P' THEN
8098: hr_utility.set_location('py_za_tx_01032012.ZaTx_01032012',38);
8099: trc_OvrWrn := 'WARNING: Tax Override - '||to_char(trc_OvrPrc)||' Percent';
8100: -- Percentage taken into account in py_za_tx_utl_01032012.TaxLiability
8101: END IF;
8102:
8103: hr_utility.set_location('py_za_tx_01032012.ZaTx_01032012',39);
8104: IF py_za_tx_utl_01032012.LatePayPeriod THEN
8100: -- Percentage taken into account in py_za_tx_utl_01032012.TaxLiability
8101: END IF;
8102:
8103: hr_utility.set_location('py_za_tx_01032012.ZaTx_01032012',39);
8104: IF py_za_tx_utl_01032012.LatePayPeriod THEN
8105: hr_utility.set_location('py_za_tx_01032012.ZaTx_01032012',40);
8106: LteCalc;
8107: -- Is this a SITE Period?
8108: ELSIF py_za_tx_utl_01032012.EmpTermPrePeriod THEN
8104: IF py_za_tx_utl_01032012.LatePayPeriod THEN
8105: hr_utility.set_location('py_za_tx_01032012.ZaTx_01032012',40);
8106: LteCalc;
8107: -- Is this a SITE Period?
8108: ELSIF py_za_tx_utl_01032012.EmpTermPrePeriod THEN
8109: hr_utility.set_location('py_za_tx_01032012.ZaTx_01032012',41);
8110: SitCalc;
8111: ELSIF py_za_tx_utl_01032012.LstPeriod OR py_za_tx_utl_01032012.EmpTermInPeriod THEN
8112: hr_utility.set_location('py_za_tx_01032012.ZaTx_01032012',42);
8107: -- Is this a SITE Period?
8108: ELSIF py_za_tx_utl_01032012.EmpTermPrePeriod THEN
8109: hr_utility.set_location('py_za_tx_01032012.ZaTx_01032012',41);
8110: SitCalc;
8111: ELSIF py_za_tx_utl_01032012.LstPeriod OR py_za_tx_utl_01032012.EmpTermInPeriod THEN
8112: hr_utility.set_location('py_za_tx_01032012.ZaTx_01032012',42);
8113: IF py_za_tx_utl_01032012.PreErnPeriod THEN
8114: hr_utility.set_location('py_za_tx_01032012.ZaTx_01032012',43);
8115: --When a YtdCalc or CalCalc would be performed,
8109: hr_utility.set_location('py_za_tx_01032012.ZaTx_01032012',41);
8110: SitCalc;
8111: ELSIF py_za_tx_utl_01032012.LstPeriod OR py_za_tx_utl_01032012.EmpTermInPeriod THEN
8112: hr_utility.set_location('py_za_tx_01032012.ZaTx_01032012',42);
8113: IF py_za_tx_utl_01032012.PreErnPeriod THEN
8114: hr_utility.set_location('py_za_tx_01032012.ZaTx_01032012',43);
8115: --When a YtdCalc or CalCalc would be performed,
8116: --the system must do a Bascalc if the method is non-cumulative
8117: IF (dbi_TX_MTD = 'N') then
8125: END IF;
8126: ElSE
8127: hr_utility.set_location('py_za_tx_01032012.ZaTx_01032012',45);
8128: -- The employee has NOT been terminated!
8129: IF py_za_tx_utl_01032012.PreErnPeriod THEN
8130: hr_utility.set_location('py_za_tx_01032012.ZaTx_01032012',46);
8131: --When a YtdCalc or CalCalc would be performed,
8132: --the system must do a Bascalc if the method is non-cumulative
8133: IF (dbi_TX_MTD = 'N') then
8140: hr_utility.set_location('py_za_tx_01032012.ZaTx_01032012',47);
8141: IF dbi_ZA_ASG_TAX_RTR_RSLTS = 'Y' THEN
8142: hr_utility.set_location('py_za_tx_01032012.ZaTx_01032012',48);
8143: SitCalc;
8144: ELSIF py_za_tx_utl_01032012.NegPtd THEN
8145: hr_utility.set_location('py_za_tx_01032012.ZaTx_01032012',49);
8146: SitCalc;
8147: ELSE
8148: hr_utility.set_location('py_za_tx_01032012.ZaTx_01032012',50);
8147: ELSE
8148: hr_utility.set_location('py_za_tx_01032012.ZaTx_01032012',50);
8149: NorCalc;
8150: END IF; */
8151: ELSIF py_za_tx_utl_01032012.NegPtd THEN
8152: hr_utility.set_location('py_za_tx_01032012.ZaTx_01032012',51);
8153: SitCalc;
8154: ELSE
8155: hr_utility.set_location('py_za_tx_01032012.ZaTx_01032012',52);
8227: if l_paye < 0 and l_TotMedTxCr_Upd > 0 then
8228:
8229: hr_utility.set_location('py_za_tx_01032012.ZaTx_01032012',59);
8230: hr_utility.set_location('py_za_tx_01032012.ZaTx_01032012 trc_curMedTxCrEle '|| trc_curMedTxCrEle,59);
8231: trc_curMedTxCrEle := py_za_tx_utl_01032012.AdjMACTxOns
8232: ( p_MedTxCrUsedDR_Upd => trc_MedTxCrUsedDR_Upd
8233: , p_MedTxCrUsedNI_Upd => trc_MedTxCrUsedNI_Upd
8234: , p_MedTxCrUsedFB_Upd => trc_MedTxCrUsedFB_Upd
8235: , p_MedTxCrUsedTA_Upd => trc_MedTxCrUsedTA_Upd
8245: end if;
8246: l_paye :=0;
8247: l_TotMedTxCr_Upd :=0;
8248: --
8249: py_za_tx_utl_01032012.SitPaySplit;
8250:
8251: hr_utility.set_location('py_za_tx_01032012.ZaTx_01032012',58);
8252:
8253: -- Execute the Arrear Processing
8251: hr_utility.set_location('py_za_tx_01032012.ZaTx_01032012',58);
8252:
8253: -- Execute the Arrear Processing
8254: --
8255: IF py_za_tx_utl_01032012.SitePeriod THEN
8256: hr_utility.set_location('py_za_tx_01032012.ZaTx_01032012',59);
8257: py_za_tx_utl_01032012.ArrearExcess;
8258: END IF;
8259:
8253: -- Execute the Arrear Processing
8254: --
8255: IF py_za_tx_utl_01032012.SitePeriod THEN
8256: hr_utility.set_location('py_za_tx_01032012.ZaTx_01032012',59);
8257: py_za_tx_utl_01032012.ArrearExcess;
8258: END IF;
8259:
8260: hr_utility.set_location('py_za_tx_01032012.ZaTx_01032012',60);
8261:
8468:
8469: FOR LSDir in csr_all_LSDir(ASSIGNMENT_ACTION_ID)
8470: LOOP
8471: l_LSDirRec := null;
8472: py_za_tx_utl_01032012.StopHrTrace;
8473: pay_balance_pkg.set_context('SOURCE_TEXT',LSDir.dirnum);
8474: l_LSDirRec.TxOnLSDirRUN := pay_balance_pkg.get_value(get_def_bal_id('Tax on Lump Sums',
8475: '_ASG_LMPSM_RUN')
8476: ,ASSIGNMENT_ACTION_ID);
8488: ,ASSIGNMENT_ACTION_ID);
8489: l_LSDirRec.MedTxCrUsedOnLSDirYTD := pay_balance_pkg.get_value(get_def_bal_id('Medical Tax Credit Used on Lump Sums',
8490: '_ASG_LMPSM_TAX_YTD')
8491: ,ASSIGNMENT_ACTION_ID);
8492: py_za_tx_utl_01032012.StartHrTrace;
8493: hr_utility.set_location('trc_curMedTxCrEle:'||trc_curMedTxCrEle,67);
8494: hr_utility.set_location('LSDir.dirnum:'||LSDir.dirnum,67);
8495: hr_utility.set_location('l_LSDirRec.TxOnLSDirRUN:'||l_LSDirRec.TxOnLSDirRUN,67);
8496: hr_utility.set_location('l_LSDirRec.TxOnLSDirPTD:'||l_LSDirRec.TxOnLSDirPTD,67);
8577:
8578: -- To allow refund incase of employee above 65
8579: -- or when balances in code 3810, 4005, 4474 is zero
8580: IF (l_TotMedTxCr_Upd < 0 and
8581: not py_za_tx_utl_01032012.AllowRefund(p_65Year => l_65Year)
8582: ) THEN
8583: LOOP
8584: -- Normal Earnings
8585: IF trc_MedTxCrUsedDR_Upd < 0 THEN
8697: -- End Medical Tax credit Changes
8698:
8699: -- Execute The Tax Trace
8700: --
8701: py_za_tx_utl_01032012.Trace;
8702:
8703: hr_utility.set_location('py_za_tx_01032012.ZaTx_01032012',65);
8704:
8705: -- Clear Globals
8703: hr_utility.set_location('py_za_tx_01032012.ZaTx_01032012',65);
8704:
8705: -- Clear Globals
8706: --
8707: py_za_tx_utl_01032012.ClearGlobals;
8708:
8709: hr_utility.set_location('py_za_tx_01032012.ZaTx_01032012',66);
8710:
8711: -- End off Trace File
8714: WrtHrTrc('------------------------------------------------------------');
8715: WrtHrTrc(' -- ');
8716:
8717: -- Call hr_utility stop procedure
8718: py_za_tx_utl_01032012.StopHrTrace;
8719:
8720: --dbms_debug.debug_off;
8721:
8722: RETURN l_Dum;
8724: EXCEPTION
8725: WHEN xpt_FxdPrc THEN
8726: hr_utility.set_location('py_za_tx_01032012.ZaTx_01032012',67);
8727: WrtHrTrc('Sql error msg: Fixed Percentage was not entered');
8728: py_za_tx_utl_01032012.StopHrTrace;
8729: hr_utility.set_message(801, 'Fixed Percentage not entered');
8730: py_za_tx_utl_01032012.ClearGlobals;
8731: hr_utility.raise_error;
8732: WHEN xpt_E THEN
8726: hr_utility.set_location('py_za_tx_01032012.ZaTx_01032012',67);
8727: WrtHrTrc('Sql error msg: Fixed Percentage was not entered');
8728: py_za_tx_utl_01032012.StopHrTrace;
8729: hr_utility.set_message(801, 'Fixed Percentage not entered');
8730: py_za_tx_utl_01032012.ClearGlobals;
8731: hr_utility.raise_error;
8732: WHEN xpt_E THEN
8733: hr_utility.set_location('py_za_tx_01032012.ZaTx_01032012',68);
8734: WrtHrTrc('xpt_Msg: '||xpt_Msg);
8731: hr_utility.raise_error;
8732: WHEN xpt_E THEN
8733: hr_utility.set_location('py_za_tx_01032012.ZaTx_01032012',68);
8734: WrtHrTrc('xpt_Msg: '||xpt_Msg);
8735: py_za_tx_utl_01032012.StopHrTrace;
8736: hr_utility.set_message(801, xpt_Msg);
8737: py_za_tx_utl_01032012.ClearGlobals;
8738: hr_utility.raise_error;
8739: WHEN OTHERS THEN
8733: hr_utility.set_location('py_za_tx_01032012.ZaTx_01032012',68);
8734: WrtHrTrc('xpt_Msg: '||xpt_Msg);
8735: py_za_tx_utl_01032012.StopHrTrace;
8736: hr_utility.set_message(801, xpt_Msg);
8737: py_za_tx_utl_01032012.ClearGlobals;
8738: hr_utility.raise_error;
8739: WHEN OTHERS THEN
8740: hr_utility.set_location('py_za_tx_01032012.ZaTx_01032012',69);
8741: WrtHrTrc('Sql error code: '||TO_CHAR(SQLCODE));
8739: WHEN OTHERS THEN
8740: hr_utility.set_location('py_za_tx_01032012.ZaTx_01032012',69);
8741: WrtHrTrc('Sql error code: '||TO_CHAR(SQLCODE));
8742: WrtHrTrc('Sql error msg: '||SUBSTR(SQLERRM(SQLCODE), 1, 100));
8743: py_za_tx_utl_01032012.StopHrTrace;
8744: hr_utility.set_message(801, 'ZaTx_01032012: '||TO_CHAR(SQLCODE));
8745: py_za_tx_utl_01032012.ClearGlobals;
8746: hr_utility.raise_error;
8747: END ZaTx_01032012;
8741: WrtHrTrc('Sql error code: '||TO_CHAR(SQLCODE));
8742: WrtHrTrc('Sql error msg: '||SUBSTR(SQLERRM(SQLCODE), 1, 100));
8743: py_za_tx_utl_01032012.StopHrTrace;
8744: hr_utility.set_message(801, 'ZaTx_01032012: '||TO_CHAR(SQLCODE));
8745: py_za_tx_utl_01032012.ClearGlobals;
8746: hr_utility.raise_error;
8747: END ZaTx_01032012;
8748:
8749:
8780: l_count number :=0;
8781:
8782:
8783: BEGIN
8784: py_za_tx_utl_01032012.StartHrTrace;
8785: hr_utility.set_location('PY_ZA_TX_01032012.ZaTxMedTxCrLmpSm1_01032012',1);
8786:
8787: p_DirNum1 :=' ';
8788: p_MedTxCrUsed1 :=0;
8855: p_MedCrUsedLS := l_cur_max_dir;
8856: hr_utility.set_location('trc_LSDirTab.count:'||trc_LSDirTab.count,4);
8857: hr_utility.set_location('p_MedCrUsedLS:'||p_MedCrUsedLS,4);
8858:
8859: py_za_tx_utl_01032012.StopHrTrace;
8860:
8861: RETURN 1;
8862:
8863: EXCEPTION
8864: WHEN OTHERS THEN
8865: hr_utility.set_location('PY_ZA_TX_01032012.ZaTxMedTxCrLmpSm1_01032012',50);
8866: WrtHrTrc('Sql error code: '||TO_CHAR(SQLCODE));
8867: WrtHrTrc('Sql error msg: '||SUBSTR(SQLERRM(SQLCODE), 1, 100));
8868: py_za_tx_utl_01032012.StopHrTrace;
8869: hr_utility.set_message(801, 'PY_ZA_TX_01032012.ZaTxMedTxCrLmpSm1_01032012: '||TO_CHAR(SQLCODE));
8870: hr_utility.raise_error;
8871: END ZaTxMedTxCrLmpSm1_01032012;
8872:
8903: l_count number :=0;
8904:
8905:
8906: BEGIN
8907: py_za_tx_utl_01032012.StartHrTrace;
8908: hr_utility.set_location('PY_ZA_TX_01032012.ZaTxMedTxCrLmpSm2_01032012',1);
8909:
8910: p_DirNum1 :=' ';
8911: p_MedTxCrUsed1 :=0;
8978: p_MedCrUsedLS := l_cur_max_dir;
8979: hr_utility.set_location('trc_LSDirTab.count:'||trc_LSDirTab.count,4);
8980: hr_utility.set_location('p_MedCrUsedLS:'||p_MedCrUsedLS,4);
8981:
8982: py_za_tx_utl_01032012.StopHrTrace;
8983:
8984: RETURN 1;
8985:
8986: EXCEPTION
8987: WHEN OTHERS THEN
8988: hr_utility.set_location('PY_ZA_TX_01032012.ZaTxMedTxCrLmpSm2_01032012',50);
8989: WrtHrTrc('Sql error code: '||TO_CHAR(SQLCODE));
8990: WrtHrTrc('Sql error msg: '||SUBSTR(SQLERRM(SQLCODE), 1, 100));
8991: py_za_tx_utl_01032012.StopHrTrace;
8992: hr_utility.set_message(801, 'PY_ZA_TX_01032012.ZaTxMedTxCrLmpSm2_01032012: '||TO_CHAR(SQLCODE));
8993: hr_utility.raise_error;
8994: END ZaTxMedTxCrLmpSm2_01032012;
8995:
9026: l_count number :=0;
9027:
9028:
9029: BEGIN
9030: py_za_tx_utl_01032012.StartHrTrace;
9031: hr_utility.set_location('PY_ZA_TX_01032012.ZaTxMedTxCrLmpSm3_01032012',1);
9032:
9033: p_DirNum1 :=' ';
9034: p_MedTxCrUsed1 :=0;
9101: p_MedCrUsedLS := l_cur_max_dir;
9102: hr_utility.set_location('trc_LSDirTab.count:'||trc_LSDirTab.count,4);
9103: hr_utility.set_location('p_MedCrUsedLS:'||p_MedCrUsedLS,4);
9104:
9105: py_za_tx_utl_01032012.StopHrTrace;
9106:
9107: RETURN 1;
9108:
9109: EXCEPTION
9110: WHEN OTHERS THEN
9111: hr_utility.set_location('PY_ZA_TX_01032012.ZaTxMedTxCrLmpSm3_01032012',50);
9112: WrtHrTrc('Sql error code: '||TO_CHAR(SQLCODE));
9113: WrtHrTrc('Sql error msg: '||SUBSTR(SQLERRM(SQLCODE), 1, 100));
9114: py_za_tx_utl_01032012.StopHrTrace;
9115: hr_utility.set_message(801, 'PY_ZA_TX_01032012.ZaTxMedTxCrLmpSm3_01032012: '||TO_CHAR(SQLCODE));
9116: hr_utility.raise_error;
9117: END ZaTxMedTxCrLmpSm3_01032012;
9118:
9150: l_count number :=0;
9151:
9152:
9153: BEGIN
9154: py_za_tx_utl_01032012.StartHrTrace;
9155: hr_utility.set_location('PY_ZA_TX_01032012.ZaTxMedTxCrLmpSm4_01032012',1);
9156:
9157: p_DirNum1 :=' ';
9158: p_MedTxCrUsed1 :=0;
9225: p_MedCrUsedLS := l_cur_max_dir;
9226: hr_utility.set_location('trc_LSDirTab.count:'||trc_LSDirTab.count,4);
9227: hr_utility.set_location('p_MedCrUsedLS:'||p_MedCrUsedLS,4);
9228:
9229: py_za_tx_utl_01032012.StopHrTrace;
9230:
9231: RETURN 1;
9232:
9233: EXCEPTION
9234: WHEN OTHERS THEN
9235: hr_utility.set_location('PY_ZA_TX_01032012.ZaTxMedTxCrLmpSm4_01032012',50);
9236: WrtHrTrc('Sql error code: '||TO_CHAR(SQLCODE));
9237: WrtHrTrc('Sql error msg: '||SUBSTR(SQLERRM(SQLCODE), 1, 100));
9238: py_za_tx_utl_01032012.StopHrTrace;
9239: hr_utility.set_message(801, 'PY_ZA_TX_01032012.ZaTxMedTxCrLmpSm4_01032012: '||TO_CHAR(SQLCODE));
9240: hr_utility.raise_error;
9241: END ZaTxMedTxCrLmpSm4_01032012;
9242:
9273: l_count number :=0;
9274:
9275:
9276: BEGIN
9277: py_za_tx_utl_01032012.StartHrTrace;
9278: hr_utility.set_location('PY_ZA_TX_01032012.ZaTxMedTxCrLmpSm5_01032012',1);
9279:
9280: p_DirNum1 :=' ';
9281: p_MedTxCrUsed1 :=0;
9348: p_MedCrUsedLS := l_cur_max_dir;
9349: hr_utility.set_location('trc_LSDirTab.count:'||trc_LSDirTab.count,4);
9350: hr_utility.set_location('p_MedCrUsedLS:'||p_MedCrUsedLS,4);
9351:
9352: py_za_tx_utl_01032012.StopHrTrace;
9353:
9354: RETURN 1;
9355:
9356: EXCEPTION
9357: WHEN OTHERS THEN
9358: hr_utility.set_location('PY_ZA_TX_01032012.ZaTxMedTxCrLmpSm5_01032012',50);
9359: WrtHrTrc('Sql error code: '||TO_CHAR(SQLCODE));
9360: WrtHrTrc('Sql error msg: '||SUBSTR(SQLERRM(SQLCODE), 1, 100));
9361: py_za_tx_utl_01032012.StopHrTrace;
9362: hr_utility.set_message(801, 'PY_ZA_TX_01032012.ZaTxMedTxCrLmpSm5_01032012: '||TO_CHAR(SQLCODE));
9363: hr_utility.raise_error;
9364: END ZaTxMedTxCrLmpSm5_01032012;
9365:
9396: l_count number :=0;
9397:
9398:
9399: BEGIN
9400: py_za_tx_utl_01032012.StartHrTrace;
9401: hr_utility.set_location('PY_ZA_TX_01032012.ZaTxMedTxCrLmpSm6_01032012',1);
9402:
9403: p_DirNum1 :=' ';
9404: p_MedTxCrUsed1 :=0;
9471: p_MedCrUsedLS := l_cur_max_dir;
9472: hr_utility.set_location('trc_LSDirTab.count:'||trc_LSDirTab.count,4);
9473: hr_utility.set_location('p_MedCrUsedLS:'||p_MedCrUsedLS,4);
9474:
9475: py_za_tx_utl_01032012.StopHrTrace;
9476:
9477: RETURN 1;
9478:
9479: EXCEPTION
9480: WHEN OTHERS THEN
9481: hr_utility.set_location('PY_ZA_TX_01032012.ZaTxMedTxCrLmpSm6_01032012',50);
9482: WrtHrTrc('Sql error code: '||TO_CHAR(SQLCODE));
9483: WrtHrTrc('Sql error msg: '||SUBSTR(SQLERRM(SQLCODE), 1, 100));
9484: py_za_tx_utl_01032012.StopHrTrace;
9485: hr_utility.set_message(801, 'PY_ZA_TX_01032012.ZaTxMedTxCrLmpSm6_01032012: '||TO_CHAR(SQLCODE));
9486: hr_utility.raise_error;
9487: END ZaTxMedTxCrLmpSm6_01032012;
9488:
9520: l_count number :=0;
9521:
9522:
9523: BEGIN
9524: py_za_tx_utl_01032012.StartHrTrace;
9525: hr_utility.set_location('PY_ZA_TX_01032012.ZaTxMedTxCrLmpSm7_01032012',1);
9526:
9527: p_DirNum1 :=' ';
9528: p_MedTxCrUsed1 :=0;
9595: p_MedCrUsedLS := l_cur_max_dir;
9596: hr_utility.set_location('trc_LSDirTab.count:'||trc_LSDirTab.count,4);
9597: hr_utility.set_location('p_MedCrUsedLS:'||p_MedCrUsedLS,4);
9598:
9599: py_za_tx_utl_01032012.StopHrTrace;
9600:
9601: RETURN 1;
9602:
9603: EXCEPTION
9604: WHEN OTHERS THEN
9605: hr_utility.set_location('PY_ZA_TX_01032012.ZaTxMedTxCrLmpSm7_01032012',50);
9606: WrtHrTrc('Sql error code: '||TO_CHAR(SQLCODE));
9607: WrtHrTrc('Sql error msg: '||SUBSTR(SQLERRM(SQLCODE), 1, 100));
9608: py_za_tx_utl_01032012.StopHrTrace;
9609: hr_utility.set_message(801, 'PY_ZA_TX_01032012.ZaTxMedTxCrLmpSm7_01032012: '||TO_CHAR(SQLCODE));
9610: hr_utility.raise_error;
9611: END ZaTxMedTxCrLmpSm7_01032012;
9612:
9644: l_count number :=0;
9645:
9646:
9647: BEGIN
9648: py_za_tx_utl_01032012.StartHrTrace;
9649: hr_utility.set_location('PY_ZA_TX_01032012.ZaTxMedTxCrLmpSm8_01032012',1);
9650:
9651: p_DirNum1 :=' ';
9652: p_MedTxCrUsed1 :=0;
9719: p_MedCrUsedLS := l_cur_max_dir;
9720: hr_utility.set_location('trc_LSDirTab.count:'||trc_LSDirTab.count,4);
9721: hr_utility.set_location('p_MedCrUsedLS:'||p_MedCrUsedLS,4);
9722:
9723: py_za_tx_utl_01032012.StopHrTrace;
9724:
9725: RETURN 1;
9726:
9727: EXCEPTION
9728: WHEN OTHERS THEN
9729: hr_utility.set_location('PY_ZA_TX_01032012.ZaTxMedTxCrLmpSm8_01032012',50);
9730: WrtHrTrc('Sql error code: '||TO_CHAR(SQLCODE));
9731: WrtHrTrc('Sql error msg: '||SUBSTR(SQLERRM(SQLCODE), 1, 100));
9732: py_za_tx_utl_01032012.StopHrTrace;
9733: hr_utility.set_message(801, 'PY_ZA_TX_01032012.ZaTxMedTxCrLmpSm8_01032012: '||TO_CHAR(SQLCODE));
9734: hr_utility.raise_error;
9735: END ZaTxMedTxCrLmpSm8_01032012;
9736:
9768: l_count number :=0;
9769:
9770:
9771: BEGIN
9772: py_za_tx_utl_01032012.StartHrTrace;
9773: hr_utility.set_location('PY_ZA_TX_01032012.ZaTxMedTxCrLmpSm9_01032012',1);
9774:
9775: p_DirNum1 :=' ';
9776: p_MedTxCrUsed1 :=0;
9843: p_MedCrUsedLS := l_cur_max_dir;
9844: hr_utility.set_location('trc_LSDirTab.count:'||trc_LSDirTab.count,4);
9845: hr_utility.set_location('p_MedCrUsedLS:'||p_MedCrUsedLS,4);
9846:
9847: py_za_tx_utl_01032012.StopHrTrace;
9848:
9849: RETURN 1;
9850:
9851: EXCEPTION
9852: WHEN OTHERS THEN
9853: hr_utility.set_location('PY_ZA_TX_01032012.ZaTxMedTxCrLmpSm9_01032012',50);
9854: WrtHrTrc('Sql error code: '||TO_CHAR(SQLCODE));
9855: WrtHrTrc('Sql error msg: '||SUBSTR(SQLERRM(SQLCODE), 1, 100));
9856: py_za_tx_utl_01032012.StopHrTrace;
9857: hr_utility.set_message(801, 'PY_ZA_TX_01032012.ZaTxMedTxCrLmpSm9_01032012: '||TO_CHAR(SQLCODE));
9858: hr_utility.raise_error;
9859: END ZaTxMedTxCrLmpSm9_01032012;
9860:
9892: l_count number :=0;
9893:
9894:
9895: BEGIN
9896: py_za_tx_utl_01032012.StartHrTrace;
9897: hr_utility.set_location('PY_ZA_TX_01032012.ZaTxMedTxCrLmpSm10_01032012',1);
9898:
9899: p_DirNum1 :=' ';
9900: p_MedTxCrUsed1 :=0;
9967: p_MedCrUsedLS := l_cur_max_dir;
9968: hr_utility.set_location('trc_LSDirTab.count:'||trc_LSDirTab.count,4);
9969: hr_utility.set_location('p_MedCrUsedLS:'||p_MedCrUsedLS,4);
9970:
9971: py_za_tx_utl_01032012.StopHrTrace;
9972:
9973: RETURN 1;
9974:
9975: EXCEPTION
9976: WHEN OTHERS THEN
9977: hr_utility.set_location('PY_ZA_TX_01032012.ZaTxMedTxCrLmpSm10_01032012',50);
9978: WrtHrTrc('Sql error code: '||TO_CHAR(SQLCODE));
9979: WrtHrTrc('Sql error msg: '||SUBSTR(SQLERRM(SQLCODE), 1, 100));
9980: py_za_tx_utl_01032012.StopHrTrace;
9981: hr_utility.set_message(801, 'PY_ZA_TX_01032012.ZaTxMedTxCrLmpSm10_01032012: '||TO_CHAR(SQLCODE));
9982: hr_utility.raise_error;
9983: END ZaTxMedTxCrLmpSm10_01032012;
9984: