1446: vXMLTable(vCtr).TagValue := l_emp_rec.Payment_Key;
1447: vCtr := vCtr + 1;
1448:
1449: vXMLTable(vCtr).TagName := 'TWR_LENGTH_OF_CONTRACT';
1450: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_emp_rec.Length_Of_Contract);
1451: vCtr := vCtr + 1;
1452:
1453: vXMLTable(vCtr).TagName := 'TWR_EMP_MOVED';
1454: vXMLTable(vCtr).TagValue := l_emp_rec.Change_in_Residency;
1500: ELSE
1501: l_total_earnings := l_emp_rec.Calc_Cont_Earnings;
1502: END IF;
1503: vXMLTable(vCtr).TagName := 'TWR_TOTAL_EARNINGS';
1504: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_total_earnings);
1505: vCtr := vCtr + 1;
1506:
1507: vXMLTable(vCtr).TagName := 'TWR_CALC_CONT_EARNINGS';
1508: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_emp_rec.Calc_Cont_Earnings);
1504: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_total_earnings);
1505: vCtr := vCtr + 1;
1506:
1507: vXMLTable(vCtr).TagName := 'TWR_CALC_CONT_EARNINGS';
1508: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_emp_rec.Calc_Cont_Earnings);
1509: vCtr := vCtr + 1;
1510:
1511: vXMLTable(vCtr).TagName := 'TWR_NO_OF_DESC';
1512: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_desc_rec.No_of_Desc);
1508: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_emp_rec.Calc_Cont_Earnings);
1509: vCtr := vCtr + 1;
1510:
1511: vXMLTable(vCtr).TagName := 'TWR_NO_OF_DESC';
1512: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_desc_rec.No_of_Desc);
1513: vCtr := vCtr + 1;
1514:
1515: vXMLTable(vCtr).TagName := 'TWR_NO_OF_DESC_LESS_3';
1516: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_desc_rec.No_of_Desc_less_3);
1512: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_desc_rec.No_of_Desc);
1513: vCtr := vCtr + 1;
1514:
1515: vXMLTable(vCtr).TagName := 'TWR_NO_OF_DESC_LESS_3';
1516: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_desc_rec.No_of_Desc_less_3);
1517: vCtr := vCtr + 1;
1518:
1519: vXMLTable(vCtr).TagName := 'TWR_NO_OF_DESC_BET_3_25';
1520: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_desc_rec.No_Desc_bet_3_25);
1516: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_desc_rec.No_of_Desc_less_3);
1517: vCtr := vCtr + 1;
1518:
1519: vXMLTable(vCtr).TagName := 'TWR_NO_OF_DESC_BET_3_25';
1520: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_desc_rec.No_Desc_bet_3_25);
1521: vCtr := vCtr + 1;
1522:
1523: vXMLTable(vCtr).TagName := 'TWR_NO_OF_DESC_ADOPT_LESS_3';
1524: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_desc_rec.No_Desc_Adopted_less_3);
1520: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_desc_rec.No_Desc_bet_3_25);
1521: vCtr := vCtr + 1;
1522:
1523: vXMLTable(vCtr).TagName := 'TWR_NO_OF_DESC_ADOPT_LESS_3';
1524: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_desc_rec.No_Desc_Adopted_less_3);
1525: vCtr := vCtr + 1;
1526:
1527: vXMLTable(vCtr).TagName := 'TWR_DESC_DISABILITY_BET_33_65';
1528: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_desc_rec.No_Desc_disablity_bet_33_65);
1524: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_desc_rec.No_Desc_Adopted_less_3);
1525: vCtr := vCtr + 1;
1526:
1527: vXMLTable(vCtr).TagName := 'TWR_DESC_DISABILITY_BET_33_65';
1528: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_desc_rec.No_Desc_disablity_bet_33_65);
1529: vCtr := vCtr + 1;
1530:
1531: vXMLTable(vCtr).TagName := 'TWR_DESC_DISABILITY_GR_65';
1532: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_desc_rec.No_Desc_disablity_gr_65);
1528: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_desc_rec.No_Desc_disablity_bet_33_65);
1529: vCtr := vCtr + 1;
1530:
1531: vXMLTable(vCtr).TagName := 'TWR_DESC_DISABILITY_GR_65';
1532: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_desc_rec.No_Desc_disablity_gr_65);
1533: vCtr := vCtr + 1;
1534:
1535: vXMLTable(vCtr).TagName := 'TWR_DESC_REDUCED_MOBILITY';
1536: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_desc_rec.No_Desc_Reduced_Mobility);
1532: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_desc_rec.No_Desc_disablity_gr_65);
1533: vCtr := vCtr + 1;
1534:
1535: vXMLTable(vCtr).TagName := 'TWR_DESC_REDUCED_MOBILITY';
1536: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_desc_rec.No_Desc_Reduced_Mobility);
1537: vCtr := vCtr + 1;
1538:
1539: vXMLTable(vCtr).TagName := 'TWR_DESC_SINGLE_PARENT';
1540: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_desc_rec.No_Desc_Single_Parent);
1536: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_desc_rec.No_Desc_Reduced_Mobility);
1537: vCtr := vCtr + 1;
1538:
1539: vXMLTable(vCtr).TagName := 'TWR_DESC_SINGLE_PARENT';
1540: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_desc_rec.No_Desc_Single_Parent);
1541: vCtr := vCtr + 1;
1542:
1543: vXMLTable(vCtr).TagName := 'TWR_DESC_DISABILITY_AMT';
1544: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_desc_rec.Desc_Disability_Amt);
1540: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_desc_rec.No_Desc_Single_Parent);
1541: vCtr := vCtr + 1;
1542:
1543: vXMLTable(vCtr).TagName := 'TWR_DESC_DISABILITY_AMT';
1544: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_desc_rec.Desc_Disability_Amt);
1545: vCtr := vCtr + 1;
1546:
1547: vXMLTable(vCtr).TagName := 'TWR_DESC_SPL_ASSISTANCE_AMT';
1548: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_desc_rec.DESC_SPECIAL_ASSISTANCE);
1544: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_desc_rec.Desc_Disability_Amt);
1545: vCtr := vCtr + 1;
1546:
1547: vXMLTable(vCtr).TagName := 'TWR_DESC_SPL_ASSISTANCE_AMT';
1548: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_desc_rec.DESC_SPECIAL_ASSISTANCE);
1549: vCtr := vCtr + 1;
1550:
1551: vXMLTable(vCtr).TagName := 'TWR_NO_OF_ASC';
1552: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_asc_rec.NO_OF_ASC);
1548: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_desc_rec.DESC_SPECIAL_ASSISTANCE);
1549: vCtr := vCtr + 1;
1550:
1551: vXMLTable(vCtr).TagName := 'TWR_NO_OF_ASC';
1552: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_asc_rec.NO_OF_ASC);
1553: vCtr := vCtr + 1;
1554:
1555: vXMLTable(vCtr).TagName := 'TWR_NO_OF_ASC_GR_75';
1556: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_asc_rec.No_of_Asc_Gr_75);
1552: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_asc_rec.NO_OF_ASC);
1553: vCtr := vCtr + 1;
1554:
1555: vXMLTable(vCtr).TagName := 'TWR_NO_OF_ASC_GR_75';
1556: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_asc_rec.No_of_Asc_Gr_75);
1557: vCtr := vCtr + 1;
1558:
1559: vXMLTable(vCtr).TagName := 'TWR_ASC_DISABILITY_BET_33_65';
1560: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_asc_rec.No_Asc_disablity_bet_33_65);
1556: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_asc_rec.No_of_Asc_Gr_75);
1557: vCtr := vCtr + 1;
1558:
1559: vXMLTable(vCtr).TagName := 'TWR_ASC_DISABILITY_BET_33_65';
1560: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_asc_rec.No_Asc_disablity_bet_33_65);
1561: vCtr := vCtr + 1;
1562:
1563: vXMLTable(vCtr).TagName := 'TWR_ASC_DISABILITY_GR_65';
1564: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_asc_rec.No_Asc_disablity_gr_65);
1560: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_asc_rec.No_Asc_disablity_bet_33_65);
1561: vCtr := vCtr + 1;
1562:
1563: vXMLTable(vCtr).TagName := 'TWR_ASC_DISABILITY_GR_65';
1564: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_asc_rec.No_Asc_disablity_gr_65);
1565: vCtr := vCtr + 1;
1566:
1567: vXMLTable(vCtr).TagName := 'TWR_ASC_REDUCED_MOBILITY';
1568: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_asc_rec.No_Asc_Reduced_Mobility);
1564: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_asc_rec.No_Asc_disablity_gr_65);
1565: vCtr := vCtr + 1;
1566:
1567: vXMLTable(vCtr).TagName := 'TWR_ASC_REDUCED_MOBILITY';
1568: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_asc_rec.No_Asc_Reduced_Mobility);
1569: vCtr := vCtr + 1;
1570:
1571: vXMLTable(vCtr).TagName := 'TWR_ASC_SNGLE_DESC';
1572: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_asc_rec.No_Asc_Single_Descendent);
1568: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_asc_rec.No_Asc_Reduced_Mobility);
1569: vCtr := vCtr + 1;
1570:
1571: vXMLTable(vCtr).TagName := 'TWR_ASC_SNGLE_DESC';
1572: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_asc_rec.No_Asc_Single_Descendent);
1573: vCtr := vCtr + 1;
1574:
1575: vXMLTable(vCtr).TagName := 'TWR_ASC_DISABILITY_AMT';
1576: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_asc_rec.Asc_Disability_Amt);
1572: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_asc_rec.No_Asc_Single_Descendent);
1573: vCtr := vCtr + 1;
1574:
1575: vXMLTable(vCtr).TagName := 'TWR_ASC_DISABILITY_AMT';
1576: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_asc_rec.Asc_Disability_Amt);
1577: vCtr := vCtr + 1;
1578:
1579: vXMLTable(vCtr).TagName := 'TWR_ASC_SPECIAL_ALLOWANCE';
1580: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_asc_rec.Asc_Special_Allowance);
1576: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_asc_rec.Asc_Disability_Amt);
1577: vCtr := vCtr + 1;
1578:
1579: vXMLTable(vCtr).TagName := 'TWR_ASC_SPECIAL_ALLOWANCE';
1580: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_asc_rec.Asc_Special_Allowance);
1581: vCtr := vCtr + 1;
1582:
1583: vXMLTable(vCtr).TagName := 'TWR_ASC_AGE_DEDUCTION';
1584: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_asc_rec.Asc_Age_Deduction);
1580: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_asc_rec.Asc_Special_Allowance);
1581: vCtr := vCtr + 1;
1582:
1583: vXMLTable(vCtr).TagName := 'TWR_ASC_AGE_DEDUCTION';
1584: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_asc_rec.Asc_Age_Deduction);
1585: vCtr := vCtr + 1;
1586:
1587: vXMLTable(vCtr).TagName := 'TWR_ASC_SPL_ASSISTANCE_AMT';
1588: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_asc_rec.Asc_Special_Assistance);
1584: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_asc_rec.Asc_Age_Deduction);
1585: vCtr := vCtr + 1;
1586:
1587: vXMLTable(vCtr).TagName := 'TWR_ASC_SPL_ASSISTANCE_AMT';
1588: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_asc_rec.Asc_Special_Assistance);
1589: vCtr := vCtr + 1;
1590:
1591: vXMLTable(vCtr).TagName := 'TWR_EMP_SPECIAL_ASSISTANCE';
1592: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_amt_rec.Emp_Special_Assistance);
1588: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_asc_rec.Asc_Special_Assistance);
1589: vCtr := vCtr + 1;
1590:
1591: vXMLTable(vCtr).TagName := 'TWR_EMP_SPECIAL_ASSISTANCE';
1592: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_amt_rec.Emp_Special_Assistance);
1593: vCtr := vCtr + 1;
1594:
1595: vXMLTable(vCtr).TagName := 'TWR_EMP_DISABILITY_ASSISTANCE';
1596: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_amt_rec.Emp_Disability_Assistance);
1592: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_amt_rec.Emp_Special_Assistance);
1593: vCtr := vCtr + 1;
1594:
1595: vXMLTable(vCtr).TagName := 'TWR_EMP_DISABILITY_ASSISTANCE';
1596: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_amt_rec.Emp_Disability_Assistance);
1597: vCtr := vCtr + 1;
1598:
1599: vXMLTable(vCtr).TagName := 'TWR_EMPLOYEE_SPECIAL_ALLOWANCE';
1600: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_amt_rec.Employee_Special_Allowance);
1596: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_amt_rec.Emp_Disability_Assistance);
1597: vCtr := vCtr + 1;
1598:
1599: vXMLTable(vCtr).TagName := 'TWR_EMPLOYEE_SPECIAL_ALLOWANCE';
1600: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_amt_rec.Employee_Special_Allowance);
1601: vCtr := vCtr + 1;
1602:
1603: vXMLTable(vCtr).TagName := 'TWR_EMP_AGE_DEDUCTION';
1604: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_amt_rec.Emp_Age_Deduction);
1600: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_amt_rec.Employee_Special_Allowance);
1601: vCtr := vCtr + 1;
1602:
1603: vXMLTable(vCtr).TagName := 'TWR_EMP_AGE_DEDUCTION';
1604: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_amt_rec.Emp_Age_Deduction);
1605: vCtr := vCtr + 1;
1606:
1607: vXMLTable(vCtr).TagName := 'TWR_SPOUSE_ALIMONY';
1608: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_amt_rec.Spouse_Alimony);
1604: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_amt_rec.Emp_Age_Deduction);
1605: vCtr := vCtr + 1;
1606:
1607: vXMLTable(vCtr).TagName := 'TWR_SPOUSE_ALIMONY';
1608: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_amt_rec.Spouse_Alimony);
1609: vCtr := vCtr + 1;
1610:
1611: vXMLTable(vCtr).TagName := 'TWR_CHILD_SUPPORT';
1612: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_amt_rec.Child_Support);
1608: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_amt_rec.Spouse_Alimony);
1609: vCtr := vCtr + 1;
1610:
1611: vXMLTable(vCtr).TagName := 'TWR_CHILD_SUPPORT';
1612: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_amt_rec.Child_Support);
1613: vCtr := vCtr + 1;
1614:
1615: vXMLTable(vCtr).TagName := 'TWR_DEDUCTIBLE_EXPENSES';
1616: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_amt_rec.Deductible_Expences);
1612: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_amt_rec.Child_Support);
1613: vCtr := vCtr + 1;
1614:
1615: vXMLTable(vCtr).TagName := 'TWR_DEDUCTIBLE_EXPENSES';
1616: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_amt_rec.Deductible_Expences);
1617: vCtr := vCtr + 1;
1618:
1619: vXMLTable(vCtr).TagName := 'TWR_IRREGULAR_EARNINGS';
1620: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_amt_rec.Irregular_Earnings);
1616: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_amt_rec.Deductible_Expences);
1617: vCtr := vCtr + 1;
1618:
1619: vXMLTable(vCtr).TagName := 'TWR_IRREGULAR_EARNINGS';
1620: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_amt_rec.Irregular_Earnings);
1621: vCtr := vCtr + 1;
1622:
1623: vXMLTable(vCtr).TagName := 'TWR_TAX_BASE';
1624: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_amt_rec.Tax_Base);
1620: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_amt_rec.Irregular_Earnings);
1621: vCtr := vCtr + 1;
1622:
1623: vXMLTable(vCtr).TagName := 'TWR_TAX_BASE';
1624: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_amt_rec.Tax_Base);
1625: vCtr := vCtr + 1;
1626:
1627: vXMLTable(vCtr).TagName := 'TWR_OVERRIDE_RATE';
1628: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_amt_rec.Override_TWR);
1624: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_amt_rec.Tax_Base);
1625: vCtr := vCtr + 1;
1626:
1627: vXMLTable(vCtr).TagName := 'TWR_OVERRIDE_RATE';
1628: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_amt_rec.Override_TWR);
1629: vCtr := vCtr + 1;
1630:
1631: vXMLTable(vCtr).TagName := 'TWR_OVERRIDE_CONT_EARNINGS';
1632: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_amt_rec.Override_Cont_Earnings);
1628: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_amt_rec.Override_TWR);
1629: vCtr := vCtr + 1;
1630:
1631: vXMLTable(vCtr).TagName := 'TWR_OVERRIDE_CONT_EARNINGS';
1632: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_amt_rec.Override_Cont_Earnings);
1633: vCtr := vCtr + 1;
1634:
1635: IF l_amt_rec.Override_TWR IS NOT NULL THEN
1636: l_twr_rate := NULL;
1638: l_twr_rate := l_twr_rec.Rate;
1639: END IF;
1640:
1641: vXMLTable(vCtr).TagName := 'TWR_RATE';
1642: vXMLTable(vCtr).TagValue := fnd_number.canonical_to_number(l_twr_rate);
1643: vCtr := vCtr + 1;
1644: END IF;
1645: --
1646: END LOOP;