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 1161: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id

1157: LOOP
1158: --
1159: l_count := 1;
1160: gXMLTable(l_count).Name := c_rec_run_results.description;
1161: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1162: ,abs(fnd_number.canonical_to_number(c_rec_run_results.amount)));
1163: --
1164: IF c_rec_run_results.classification = 'Earnings'
1165: or c_rec_run_results.classification = 'Allowances' THEN

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

1218: --
1219: -- If there is no data for any Element Classification then 'No Data Exists.' is printed
1220: --
1221: IF l_total_earnings <> 0 THEN
1222: l_tag := getTag('c_total_earnings', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1223: ,l_total_earnings));
1224: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1225: ELSE
1226: gXMLTable(1).Name := 'No Data Exists.';

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

1230: ,1);
1231: END IF;
1232:
1233: IF l_total_deductions <> 0 THEN
1234: l_tag := getTag('c_total_deductions', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1235: ,l_total_deductions));
1236: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1237: ELSE
1238: gXMLTable(1).Name := 'No Data Exists.';

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

1242: ,1);
1243: END IF;
1244:
1245: IF l_total_employer_charges <> 0 THEN
1246: l_tag := getTag('c_total_employer_charges', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1247: ,l_total_employer_charges));
1248: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1249: ELSE
1250: gXMLTable(1).Name := 'No Data Exists.';

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

1254: ,1);
1255: END IF;
1256:
1257: IF l_total_perquisites <> 0 THEN
1258: l_tag := getTag('c_total_perquisites', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1259: ,l_total_perquisites));
1260: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1261: ELSE
1262: gXMLTable(1).Name := 'No Data Exists.';

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

1266: ,1);
1267: END IF;
1268:
1269: IF l_total_other_deductions <> 0 THEN
1270: l_tag := getTag('c_total_other_deductions', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1271: ,abs(fnd_number.canonical_to_number(l_total_other_deductions))));
1272: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1273: ELSE
1274: gXMLTable(1).Name := 'No Data Exists.';

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

1279: END IF;
1280: -- /*Added code for bug fix 6660147*/
1281: --Bugfix 66660147 start
1282: IF l_total_advance <> 0 THEN
1283: l_tag := getTag('c_total_advance', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1284: ,abs(fnd_number.canonical_to_number(l_total_advance))));
1285: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1286: ELSE
1287: gXMLTable(1).Name := 'No Data Exists.';

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

1291: ,1);
1292: END IF;
1293:
1294: IF l_total_fringe_benefit <> 0 THEN
1295: l_tag := getTag('c_total_fringe_benefit', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1296: ,abs(fnd_number.canonical_to_number(l_total_fringe_benefit))));
1297: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1298: ELSE
1299: gXMLTable(1).Name := 'No Data Exists.';

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

1331: gXMLTable(l_count).Name := c_rec_loan.loan_type;
1332: --
1333: ELSIF c_rec_loan.description = 'Pay Value' AND fnd_number.canonical_to_number(c_rec_loan.amount) < 0 THEN
1334: --
1335: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1336: ,abs(fnd_number.canonical_to_number(c_rec_loan.amount)));
1337: l_total_loan_recovery := l_total_loan_recovery + abs(fnd_number.canonical_to_number(c_rec_loan.amount));
1338: l_count := l_count + 1;
1339: --

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

1350: --
1351: -- If there is no data then 'No Data Exists.' is printed
1352: --
1353: IF l_total_loan_recovery <> 0 THEN
1354: l_tag := getTag('c_total_perquisites_loan_recovery', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1355: ,fnd_number.canonical_to_number(l_total_loan_recovery)));
1356: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1357: ELSE
1358: gXMLTable(1).Name := 'No Data Exists.';

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

1394: gXMLTable(l_count).Value := nvl((c_rec_leave_encashment.amount),'0');
1395: --
1396: ELSIF c_rec_leave_encashment.description = 'Encashment Amount' THEN
1397: gXMLTable(l_count).Name := 'c_amount';
1398: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1399: ,nvl(fnd_number.canonical_to_number(c_rec_leave_encashment.amount),0));
1400: END IF;
1401: l_count := l_count + 1;
1402: --

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

1450: END LOOP;
1451: ELSE
1452: l_grat_elig_sal := fnd_number.canonical_to_number(c_rec_gratuity_payment.amount);
1453: END IF;
1454: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1455: ,(l_grat_elig_sal));
1456: --
1457: ELSIF c_rec_gratuity_payment.description = 'Completed Service Years' THEN
1458: gXMLTable(l_count).Name := 'c_completed_service_years';

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

1459: gXMLTable(l_count).Value := (c_rec_gratuity_payment.amount);
1460: --
1461: ELSIF c_rec_gratuity_payment.description = 'Forfeiture Amount' THEN
1462: gXMLTable(l_count).Name := 'c_forfeiture_amount';
1463: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1464: ,nvl(fnd_number.canonical_to_number(c_rec_gratuity_payment.amount),0));
1465: --
1466: ELSIF c_rec_gratuity_payment.description = 'Forfeiture Reason' THEN
1467: gXMLTable(l_count).Name := 'c_forfeiture_reason';

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

1468: gXMLTable(l_count).Value := hr_general.decode_lookup('IN_GRATUITY_FORFEITURE_REASON',c_rec_gratuity_payment.amount);
1469: --
1470: ELSIF c_rec_gratuity_payment.description = 'Pay Value' THEN
1471: gXMLTable(l_count).Name := 'c_gratuity_amount';
1472: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1473: ,nvl(fnd_number.canonical_to_number(c_rec_gratuity_payment.amount),0));
1474: --
1475: ELSIF c_rec_gratuity_payment.description = 'Calculated Amount' THEN
1476: gXMLTable(l_count).Name := 'c_calculated_amount';

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

1473: ,nvl(fnd_number.canonical_to_number(c_rec_gratuity_payment.amount),0));
1474: --
1475: ELSIF c_rec_gratuity_payment.description = 'Calculated Amount' THEN
1476: gXMLTable(l_count).Name := 'c_calculated_amount';
1477: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1478: ,nvl(fnd_number.canonical_to_number(c_rec_gratuity_payment.amount),0));
1479: --
1480: END IF;
1481: --

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

1526: gXMLTable(1).Value := (c_rec_employee_dues.element);
1527: --
1528: IF c_rec_employee_dues.description = 'Non Taxable Amount' THEN
1529: gXMLTable(l_count).Name := 'c_amount_exempted';
1530: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1531: ,nvl(fnd_number.canonical_to_number(c_rec_employee_dues.amount),0));
1532: l_exempted := fnd_number.canonical_to_number(nvl(c_rec_employee_dues.amount,0));
1533: --
1534: ELSIF c_rec_employee_dues.description = 'Pay Value' AND fnd_number.canonical_to_number(NVL(c_rec_employee_dues.amount,0)) > 0 THEN

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

1533: --
1534: ELSIF c_rec_employee_dues.description = 'Pay Value' AND fnd_number.canonical_to_number(NVL(c_rec_employee_dues.amount,0)) > 0 THEN
1535:
1536: gXMLTable(l_count).Name := 'c_amount_paid';
1537: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1538: ,nvl(fnd_number.canonical_to_number(c_rec_employee_dues.amount),0));
1539: l_paid := fnd_number.canonical_to_number(nvl(c_rec_employee_dues.amount,0));
1540: --
1541: ELSIF c_rec_employee_dues.description = 'Taxable Amount' THEN

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

1541: ELSIF c_rec_employee_dues.description = 'Taxable Amount' THEN
1542: --
1543: IF l_count = 3 THEN
1544: gXMLTable(l_count).Name := 'c_amount_paid';
1545: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id,0);
1546: l_paid := 0;
1547: l_count := l_count + 1;
1548: END IF;
1549: --

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

1547: l_count := l_count + 1;
1548: END IF;
1549: --
1550: gXMLTable(l_count).Name := 'c_taxable_amount';
1551: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1552: ,nvl(fnd_number.canonical_to_number(c_rec_employee_dues.amount),0));
1553: l_taxable := fnd_number.canonical_to_number(nvl(c_rec_employee_dues.amount,0));
1554: END IF;
1555: --

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

1603: END IF;
1604: --
1605: IF c_rec_employee_term_dues.description = 'Non Taxable Amount' THEN
1606: gXMLTable(l_count).Name := 'c_amount_exempted';
1607: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1608: ,nvl(fnd_number.canonical_to_number(c_rec_employee_term_dues.amount),0));
1609: l_exempted := fnd_number.canonical_to_number(nvl(c_rec_employee_term_dues.amount,0));
1610:
1611: ELSIF c_rec_employee_term_dues.description = 'Taxable Amount' THEN

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

1609: l_exempted := fnd_number.canonical_to_number(nvl(c_rec_employee_term_dues.amount,0));
1610:
1611: ELSIF c_rec_employee_term_dues.description = 'Taxable Amount' THEN
1612: gXMLTable(l_count).Name := 'c_taxable_amount';
1613: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1614: ,nvl(fnd_number.canonical_to_number(c_rec_employee_term_dues.amount),0));
1615: l_taxable := fnd_number.canonical_to_number(nvl(c_rec_employee_term_dues.amount,0));
1616:
1617: END IF;

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

1618:
1619: IF l_count = 3 THEN
1620: gXMLTable(4).Name := 'c_amount_paid';
1621: l_paid := l_exempted + l_taxable;
1622: gXMLTable(4).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1623: ,nvl(l_paid,0));
1624: multiColumnar('t_due_to_ee'
1625: ,gXMLTable
1626: ,4);

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

1650: gXMLTable(1).Name := 'c_description';
1651: gXMLTable(1).Value := (c_rec_employee_dues_user.description);
1652: --
1653: gXMLTable(2).Name := 'c_amount_exempted';
1654: gXMLTable(2).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id,0);
1655: --
1656: gXMLTable(3).Name := 'c_amount_paid';
1657: gXMLTable(3).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1658: ,nvl(fnd_number.canonical_to_number(c_rec_employee_dues_user.amount),0));

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

1653: gXMLTable(2).Name := 'c_amount_exempted';
1654: gXMLTable(2).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id,0);
1655: --
1656: gXMLTable(3).Name := 'c_amount_paid';
1657: gXMLTable(3).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1658: ,nvl(fnd_number.canonical_to_number(c_rec_employee_dues_user.amount),0));
1659: l_total_paid := l_total_paid + fnd_number.canonical_to_number(nvl(c_rec_employee_dues_user.amount,0));
1660: --
1661: gXMLTable(4).Name := 'c_taxable_amount';

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

1658: ,nvl(fnd_number.canonical_to_number(c_rec_employee_dues_user.amount),0));
1659: l_total_paid := l_total_paid + fnd_number.canonical_to_number(nvl(c_rec_employee_dues_user.amount,0));
1660: --
1661: gXMLTable(4).Name := 'c_taxable_amount';
1662: gXMLTable(4).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1663: ,nvl(fnd_number.canonical_to_number(c_rec_employee_dues_user.amount),0));
1664: l_total_taxable := l_total_taxable + fnd_number.canonical_to_number(nvl(c_rec_employee_dues_user.amount,0));
1665: --
1666: multiColumnar('t_due_to_ee'

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

1675: multiColumnar('t_due_to_ee'
1676: ,gXMLTable
1677: ,1);
1678: ELSE
1679: l_tag := getTag('c_total_amount_paid', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1680: ,l_total_paid));
1681: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1682:
1683: l_tag := getTag('c_total_taxable_amount', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id

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

1679: l_tag := getTag('c_total_amount_paid', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1680: ,l_total_paid));
1681: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1682:
1683: l_tag := getTag('c_total_taxable_amount', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1684: ,l_total_taxable));
1685: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1686:
1687: l_tag := getTag('c_total_amount_exempted', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id

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

1683: l_tag := getTag('c_total_taxable_amount', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1684: ,l_total_taxable));
1685: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1686:
1687: l_tag := getTag('c_total_amount_exempted', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1688: ,l_total_exempted));
1689: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1690: END IF;
1691: --

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

1708: l_gross_earnings := l_gross_earnings + nvl(abs(fnd_number.canonical_to_number(c_rec_gross_deductions.amount)),0);
1709: --
1710: END LOOP;
1711:
1712: l_tag := getTag('c_gross_deductions', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1713: ,l_gross_earnings));
1714: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1715:
1716: --

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

1730: --
1731: --
1732: END LOOP;
1733:
1734: l_tag := getTag('c_net_amount', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1735: ,l_net_pay));
1736: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1737:
1738: IF l_net_pay >= 0 THEN

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

1740: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1741: END IF;
1742:
1743: --
1744: l_tag := getTag('c_gross_earnings', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1745: ,l_gross_earnings));
1746: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1747: --
1748: fnd_file.put_line(fnd_file.log,'Created Net Amount Payables.');

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

1789: gXMLTable(l_count).Value := (c_rec_payment_details.account_number);
1790: l_count := l_count + 1;
1791: --Amount
1792: gXMLTable(l_count).Name := 'c_amount';
1793: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1794: ,nvl(c_rec_payment_details.amount,0));
1795: multiColumnar('t_payment_details'
1796: ,gXMLTable
1797: ,l_count);