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

APPS.PAY_IN_TERM_RPRT_GEN_PKG dependencies on PAY_US_EMPLOYEE_PAYSLIP_WEB

Line 1274: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id

1270: l_count := l_count + 1 ;
1271:
1272: --Amount
1273: gXMLTable(l_count).Name := 'c_amount';
1274: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1275: ,fnd_number.canonical_to_number(c_rec_run_results.amount)); /* bug no: 14753072 */
1276: l_count := l_count + 1 ;
1277:
1278: --Classification

Line 1346: l_tag := getTag('c_total_earnings', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id

1342: --
1343: -- If there is no data for any Element Classification then 'No Data Exists.' is printed
1344: --
1345: IF l_total_earnings <> 0 THEN
1346: l_tag := getTag('c_total_earnings', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1347: ,l_total_earnings));
1348: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1349: ELSE
1350: gXMLTable(1).Name := 'No Data Exists.';

Line 1358: l_tag := getTag('c_total_deductions', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id

1354: ,1);
1355: END IF;
1356:
1357: IF l_total_deductions <> 0 THEN
1358: l_tag := getTag('c_total_deductions', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1359: ,l_total_deductions));
1360: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1361: ELSE
1362: gXMLTable(1).Name := 'No Data Exists.';

Line 1370: l_tag := getTag('c_total_employer_charges', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id

1366: ,1);
1367: END IF;
1368:
1369: IF l_total_employer_charges <> 0 THEN
1370: l_tag := getTag('c_total_employer_charges', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1371: ,l_total_employer_charges));
1372: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1373: ELSE
1374: gXMLTable(1).Name := 'No Data Exists.';

Line 1382: l_tag := getTag('c_total_perquisites', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id

1378: ,1);
1379: END IF;
1380:
1381: IF l_total_perquisites <> 0 THEN
1382: l_tag := getTag('c_total_perquisites', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1383: ,l_total_perquisites));
1384: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1385: ELSE
1386: gXMLTable(1).Name := 'No Data Exists.';

Line 1394: l_tag := getTag('c_total_other_deductions', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id

1390: ,1);
1391: END IF;
1392:
1393: IF l_total_other_deductions <> 0 THEN
1394: l_tag := getTag('c_total_other_deductions', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1395: ,(fnd_number.canonical_to_number(l_total_other_deductions))));
1396: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1397: ELSE
1398: gXMLTable(1).Name := 'No Data Exists.';

Line 1407: l_tag := getTag('c_total_advance', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id

1403: END IF;
1404: -- /*Added code for bug fix 6660147*/
1405: --Bugfix 66660147 start
1406: IF l_total_advance <> 0 THEN
1407: l_tag := getTag('c_total_advance', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1408: ,abs(fnd_number.canonical_to_number(l_total_advance))));
1409: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1410: ELSE
1411: gXMLTable(1).Name := 'No Data Exists.';

Line 1419: l_tag := getTag('c_total_fringe_benefit', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id

1415: ,1);
1416: END IF;
1417:
1418: IF l_total_fringe_benefit <> 0 THEN
1419: l_tag := getTag('c_total_fringe_benefit', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1420: ,abs(fnd_number.canonical_to_number(l_total_fringe_benefit))));
1421: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1422: ELSE
1423: gXMLTable(1).Name := 'No Data Exists.';

Line 1459: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id

1455: gXMLTable(l_count).Name := c_rec_loan.loan_type;
1456: --
1457: ELSIF c_rec_loan.description = 'Pay Value' AND fnd_number.canonical_to_number(c_rec_loan.amount) < 0 THEN
1458: --
1459: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1460: ,(fnd_number.canonical_to_number(c_rec_loan.amount)));
1461: l_total_loan_recovery := l_total_loan_recovery + (fnd_number.canonical_to_number(c_rec_loan.amount));
1462: l_count := l_count + 1;
1463: --

Line 1478: l_tag := getTag('c_total_perquisites_loan_recovery', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id

1474: --
1475: -- If there is no data then 'No Data Exists.' is printed
1476: --
1477: IF l_total_loan_recovery <> 0 THEN
1478: l_tag := getTag('c_total_perquisites_loan_recovery', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1479: ,fnd_number.canonical_to_number(l_total_loan_recovery)));
1480: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1481: ELSE
1482: gXMLTable(1).Name := 'No Data Exists.';

Line 1522: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id

1518: gXMLTable(l_count).Value := nvl((c_rec_leave_encashment.amount),'0');
1519: --
1520: ELSIF c_rec_leave_encashment.description = 'Encashment Amount' THEN
1521: gXMLTable(l_count).Name := 'c_amount';
1522: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1523: ,nvl(fnd_number.canonical_to_number(c_rec_leave_encashment.amount),0));
1524: END IF;
1525: l_count := l_count + 1;
1526: --

Line 1578: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id

1574: END LOOP;
1575: ELSE
1576: l_grat_elig_sal := fnd_number.canonical_to_number(c_rec_gratuity_payment.amount);
1577: END IF;
1578: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1579: ,(l_grat_elig_sal));
1580: --
1581: ELSIF c_rec_gratuity_payment.description = 'Completed Service Years' THEN
1582: gXMLTable(l_count).Name := 'c_completed_service_years';

Line 1587: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id

1583: gXMLTable(l_count).Value := (c_rec_gratuity_payment.amount);
1584: --
1585: ELSIF c_rec_gratuity_payment.description = 'Forfeiture Amount' THEN
1586: gXMLTable(l_count).Name := 'c_forfeiture_amount';
1587: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1588: ,nvl(fnd_number.canonical_to_number(c_rec_gratuity_payment.amount),0));
1589: --
1590: ELSIF c_rec_gratuity_payment.description = 'Forfeiture Reason' THEN
1591: gXMLTable(l_count).Name := 'c_forfeiture_reason';

Line 1596: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id

1592: gXMLTable(l_count).Value := hr_general.decode_lookup('IN_GRATUITY_FORFEITURE_REASON',c_rec_gratuity_payment.amount);
1593: --
1594: ELSIF c_rec_gratuity_payment.description = 'Pay Value' THEN
1595: gXMLTable(l_count).Name := 'c_gratuity_amount';
1596: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1597: ,nvl(fnd_number.canonical_to_number(c_rec_gratuity_payment.amount),0));
1598: --
1599: ELSIF c_rec_gratuity_payment.description = 'Calculated Amount' THEN
1600: gXMLTable(l_count).Name := 'c_calculated_amount';

Line 1601: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id

1597: ,nvl(fnd_number.canonical_to_number(c_rec_gratuity_payment.amount),0));
1598: --
1599: ELSIF c_rec_gratuity_payment.description = 'Calculated Amount' THEN
1600: gXMLTable(l_count).Name := 'c_calculated_amount';
1601: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1602: ,nvl(fnd_number.canonical_to_number(c_rec_gratuity_payment.amount),0));
1603: --
1604: END IF;
1605: --

Line 1654: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id

1650: gXMLTable(1).Value := (c_rec_employee_dues.element);
1651: --
1652: IF c_rec_employee_dues.description = 'Non Taxable Amount' THEN
1653: gXMLTable(l_count).Name := 'c_amount_exempted';
1654: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1655: ,nvl(fnd_number.canonical_to_number(c_rec_employee_dues.amount),0));
1656: l_exempted := fnd_number.canonical_to_number(nvl(c_rec_employee_dues.amount,0));
1657: --
1658: ELSIF c_rec_employee_dues.description = 'Pay Value' AND fnd_number.canonical_to_number(NVL(c_rec_employee_dues.amount,0)) > 0 THEN

Line 1661: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id

1657: --
1658: ELSIF c_rec_employee_dues.description = 'Pay Value' AND fnd_number.canonical_to_number(NVL(c_rec_employee_dues.amount,0)) > 0 THEN
1659:
1660: gXMLTable(l_count).Name := 'c_amount_paid';
1661: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1662: ,nvl(fnd_number.canonical_to_number(c_rec_employee_dues.amount),0));
1663: l_paid := fnd_number.canonical_to_number(nvl(c_rec_employee_dues.amount,0));
1664: --
1665: ELSIF c_rec_employee_dues.description = 'Taxable Amount' THEN

Line 1669: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id,0);

1665: ELSIF c_rec_employee_dues.description = 'Taxable Amount' THEN
1666: --
1667: IF l_count = 3 THEN
1668: gXMLTable(l_count).Name := 'c_amount_paid';
1669: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id,0);
1670: l_paid := 0;
1671: l_count := l_count + 1;
1672: END IF;
1673: --

Line 1675: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id

1671: l_count := l_count + 1;
1672: END IF;
1673: --
1674: gXMLTable(l_count).Name := 'c_taxable_amount';
1675: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1676: ,nvl(fnd_number.canonical_to_number(c_rec_employee_dues.amount),0));
1677: l_taxable := fnd_number.canonical_to_number(nvl(c_rec_employee_dues.amount,0));
1678: END IF;
1679: --

Line 1733: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id

1729: END IF;
1730: --
1731: IF c_rec_employee_term_dues.description = 'Non Taxable Amount' THEN
1732: gXMLTable(l_count).Name := 'c_amount_exempted';
1733: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1734: ,nvl(fnd_number.canonical_to_number(c_rec_employee_term_dues.amount),0));
1735: l_exempted := fnd_number.canonical_to_number(nvl(c_rec_employee_term_dues.amount,0));
1736:
1737: ELSIF c_rec_employee_term_dues.description = 'Taxable Amount' THEN

Line 1739: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id

1735: l_exempted := fnd_number.canonical_to_number(nvl(c_rec_employee_term_dues.amount,0));
1736:
1737: ELSIF c_rec_employee_term_dues.description = 'Taxable Amount' THEN
1738: gXMLTable(l_count).Name := 'c_taxable_amount';
1739: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1740: ,nvl(fnd_number.canonical_to_number(c_rec_employee_term_dues.amount),0));
1741: l_taxable := fnd_number.canonical_to_number(nvl(c_rec_employee_term_dues.amount,0));
1742:
1743: END IF;

Line 1748: gXMLTable(4).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id

1744:
1745: IF l_count = 3 THEN
1746: gXMLTable(4).Name := 'c_amount_paid';
1747: l_paid := l_exempted + l_taxable;
1748: gXMLTable(4).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1749: ,nvl(l_paid,0));
1750: multiColumnar('t_due_to_ee'
1751: ,gXMLTable
1752: ,4);

Line 1780: gXMLTable(2).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id,0);

1776: gXMLTable(1).Name := 'c_description';
1777: gXMLTable(1).Value := (c_rec_employee_dues_user.description);
1778: --
1779: gXMLTable(2).Name := 'c_amount_exempted';
1780: gXMLTable(2).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id,0);
1781: --
1782: gXMLTable(3).Name := 'c_amount_paid';
1783: gXMLTable(3).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1784: ,nvl(fnd_number.canonical_to_number(c_rec_employee_dues_user.amount),0));

Line 1783: gXMLTable(3).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id

1779: gXMLTable(2).Name := 'c_amount_exempted';
1780: gXMLTable(2).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id,0);
1781: --
1782: gXMLTable(3).Name := 'c_amount_paid';
1783: gXMLTable(3).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1784: ,nvl(fnd_number.canonical_to_number(c_rec_employee_dues_user.amount),0));
1785: l_total_paid := l_total_paid + fnd_number.canonical_to_number(nvl(c_rec_employee_dues_user.amount,0));
1786: --
1787: gXMLTable(4).Name := 'c_taxable_amount';

Line 1788: gXMLTable(4).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id

1784: ,nvl(fnd_number.canonical_to_number(c_rec_employee_dues_user.amount),0));
1785: l_total_paid := l_total_paid + fnd_number.canonical_to_number(nvl(c_rec_employee_dues_user.amount,0));
1786: --
1787: gXMLTable(4).Name := 'c_taxable_amount';
1788: gXMLTable(4).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1789: ,nvl(fnd_number.canonical_to_number(c_rec_employee_dues_user.amount),0));
1790: l_total_taxable := l_total_taxable + fnd_number.canonical_to_number(nvl(c_rec_employee_dues_user.amount,0));
1791: --
1792: gXMLTable(5).Name := 'c_elementname';

Line 1808: l_tag := getTag('c_total_amount_paid', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id

1804: multiColumnar('t_due_to_ee'
1805: ,gXMLTable
1806: ,1);
1807: ELSE
1808: l_tag := getTag('c_total_amount_paid', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1809: ,l_total_paid));
1810: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1811:
1812: l_tag := getTag('c_total_taxable_amount', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id

Line 1812: l_tag := getTag('c_total_taxable_amount', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id

1808: l_tag := getTag('c_total_amount_paid', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1809: ,l_total_paid));
1810: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1811:
1812: l_tag := getTag('c_total_taxable_amount', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1813: ,l_total_taxable));
1814: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1815:
1816: l_tag := getTag('c_total_amount_exempted', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id

Line 1816: l_tag := getTag('c_total_amount_exempted', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id

1812: l_tag := getTag('c_total_taxable_amount', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1813: ,l_total_taxable));
1814: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1815:
1816: l_tag := getTag('c_total_amount_exempted', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1817: ,l_total_exempted));
1818: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1819: END IF;
1820: --

Line 1841: l_tag := getTag('c_gross_deductions', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id

1837: l_gross_earnings := l_gross_earnings + nvl(abs(fnd_number.canonical_to_number(c_rec_gross_deductions.amount)),0);
1838: --
1839: END LOOP;
1840:
1841: l_tag := getTag('c_gross_deductions', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1842: ,l_gross_earnings));
1843: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1844:
1845: --

Line 1863: l_tag := getTag('c_net_amount', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id

1859: --
1860: --
1861: END LOOP;
1862: l_net_pay := round(l_net_pay,2); /* rounded to two digits after decimal point to write amount in words */
1863: l_tag := getTag('c_net_amount', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1864: ,l_net_pay));
1865: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1866:
1867: IF l_net_pay >= 0 THEN

Line 1873: l_tag := getTag('c_gross_earnings', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id

1869: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1870: END IF;
1871:
1872: --
1873: l_tag := getTag('c_gross_earnings', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1874: ,l_gross_earnings));
1875: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1876: --
1877: fnd_file.put_line(fnd_file.log,'Created Net Amount Payables.');

Line 1922: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id

1918: gXMLTable(l_count).Value := (c_rec_payment_details.account_number);
1919: l_count := l_count + 1;
1920: --Amount
1921: gXMLTable(l_count).Name := 'c_amount';
1922: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1923: ,nvl(c_rec_payment_details.amount,0));
1924: multiColumnar('t_payment_details'
1925: ,gXMLTable
1926: ,l_count);