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 DBMS_LOB

Line 47: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);

43: END IF;
44:
45: --
46: l_tag := '<'||p_type||'>';
47: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
48:
49: FOR i in 1..p_count
50: LOOP
51: --

Line 55: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);

51: --
52: IF p_data.exists(i) THEN
53: --
54: l_tag := getTag(p_data(i).Name, p_data(i).Value);
55: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
56: --
57: END IF;
58: --
59: END LOOP;

Line 62: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);

58: --
59: END LOOP;
60: --
61: l_tag := '';
62: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
63: pay_in_utils.trace('**************************************************','********************');
64: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
65: --
66: END multiColumnar;

Line 112: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);

108: IF p_data.exists(i) THEN
109: --
110: -- Start Main tag
111: l_tag := '<'||p_type||'>';
112: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
113: --
114: -- Put Description tag
115: l_tag := getTag('c_description', p_data(i).Name);
116: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);

Line 116: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);

112: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
113: --
114: -- Put Description tag
115: l_tag := getTag('c_description', p_data(i).Name);
116: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
117: --
118: -- Put amount tag
119: l_tag := getTag('c_amount', p_data(i).Value);
120: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);

Line 120: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);

116: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
117: --
118: -- Put amount tag
119: l_tag := getTag('c_amount', p_data(i).Value);
120: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
121: --
122: -- End Main tag
123: l_tag := '';
124: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);

Line 124: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);

120: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
121: --
122: -- End Main tag
123: l_tag := '';
124: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
125: --
126: END IF;
127: --
128: END LOOP;

Line 1123: dbms_lob.createtemporary(p_xml_data,FALSE,DBMS_LOB.CALL);

1119: gXMLTable.DELETE;
1120: l_count := 1;
1121: --
1122: fnd_file.put_line(fnd_file.log,'Creating the XML...');
1123: dbms_lob.createtemporary(p_xml_data,FALSE,DBMS_LOB.CALL);
1124: dbms_lob.open(p_xml_data,dbms_lob.lob_readwrite);
1125: --
1126: l_tag := '';
1127: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);

Line 1124: dbms_lob.open(p_xml_data,dbms_lob.lob_readwrite);

1120: l_count := 1;
1121: --
1122: fnd_file.put_line(fnd_file.log,'Creating the XML...');
1123: dbms_lob.createtemporary(p_xml_data,FALSE,DBMS_LOB.CALL);
1124: dbms_lob.open(p_xml_data,dbms_lob.lob_readwrite);
1125: --
1126: l_tag := '';
1127: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1128: l_tag := '';

Line 1127: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);

1123: dbms_lob.createtemporary(p_xml_data,FALSE,DBMS_LOB.CALL);
1124: dbms_lob.open(p_xml_data,dbms_lob.lob_readwrite);
1125: --
1126: l_tag := '';
1127: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1128: l_tag := '';
1129: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1130: fnd_file.put_line(fnd_file.log,'Started...');
1131: --

Line 1129: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);

1125: --
1126: l_tag := '';
1127: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1128: l_tag := '';
1129: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1130: fnd_file.put_line(fnd_file.log,'Started...');
1131: --
1132: --
1133: fnd_file.put_line(fnd_file.log,'Creating XML for Employee Personal Details.');

Line 1238: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);

1234: ,l_term_date)
1235: LOOP
1236: -- For getting the Designation
1237: l_tag := getTag('c_designation', c_rec_designation.designation);
1238: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1239: END LOOP;
1240: fnd_file.put_line(fnd_file.log,'Created Employee Personal Details.');
1241: --
1242: l_total_earnings := 0;

Line 1348: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);

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.';
1351: gXMLTable(1).Value := ' ';
1352: twoColumnar('t_earnings'

Line 1360: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);

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.';
1363: gXMLTable(1).Value := ' ';
1364: twoColumnar('t_deductions'

Line 1372: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);

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.';
1375: gXMLTable(1).Value := ' ';
1376: twoColumnar('t_er_charges'

Line 1384: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);

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.';
1387: gXMLTable(1).Value := ' ';
1388: twoColumnar('t_perquisites'

Line 1396: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);

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.';
1399: gXMLTable(1).Value := ' ';
1400: twoColumnar('t_other_deductions'

Line 1409: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);

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.';
1412: gXMLTable(1).Value := ' ';
1413: twoColumnar('t_advances'

Line 1421: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);

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.';
1424: gXMLTable(1).Value := ' ';
1425: twoColumnar('t_fringe_benefits'

Line 1480: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);

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.';
1483: gXMLTable(1).Value := ' ';
1484: twoColumnar('t_loan_recovery'

Line 1810: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);

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
1813: ,l_total_taxable));
1814: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);

Line 1814: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);

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
1817: ,l_total_exempted));
1818: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);

Line 1818: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);

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: --
1821: fnd_file.put_line(fnd_file.log,'Created Dues to Employee.');
1822: --

Line 1843: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);

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: --
1846: l_net_pay := 0;
1847: --

Line 1865: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);

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
1868: l_tag := getTag('c_net_amount_in_words', initcap(pay_in_utils.number_to_words(l_net_pay)));
1869: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);

Line 1869: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);

1865: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1866:
1867: IF l_net_pay >= 0 THEN
1868: l_tag := getTag('c_net_amount_in_words', initcap(pay_in_utils.number_to_words(l_net_pay)));
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

Line 1875: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);

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.');
1878: --
1879: fnd_file.put_line(fnd_file.log,'Creating XML for Payment Details.');

Line 1898: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);

1894: l_payment_flag := 1;
1895:
1896: IF l_count = 1 THEN
1897: l_tag := getTag('c_payment_date', to_char(c_rec_payment_details.payment_date,'dd-Mon-yyyy'));
1898: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1899: END IF;
1900:
1901: l_count := 1;
1902: --

Line 1941: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);

1937: fnd_file.put_line(fnd_file.log,'Created Payment Details.');
1938: --
1939: l_tag := '';
1940: --
1941: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1942: --
1943: l_xml_data := p_xml_data;
1944: --
1945: pay_in_utils.trace('**************************************************','********************');