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_SE_FORA dependencies on DBMS_LOB

Line 1792: DBMS_LOB.createtemporary (l_xfdf_string, FALSE, DBMS_LOB.CALL);

1788: || l_iana_charset
1789: || '"?> ';
1790: l_str10 := '';
1791: l_str11 := '';
1792: DBMS_LOB.createtemporary (l_xfdf_string, FALSE, DBMS_LOB.CALL);
1793: DBMS_LOB.OPEN (l_xfdf_string, DBMS_LOB.lob_readwrite);
1794: current_index := 0;
1795:
1796: IF xml_tab.COUNT > 0

Line 1793: DBMS_LOB.OPEN (l_xfdf_string, DBMS_LOB.lob_readwrite);

1789: || '"?> ';
1790: l_str10 := '';
1791: l_str11 := '';
1792: DBMS_LOB.createtemporary (l_xfdf_string, FALSE, DBMS_LOB.CALL);
1793: DBMS_LOB.OPEN (l_xfdf_string, DBMS_LOB.lob_readwrite);
1794: current_index := 0;
1795:
1796: IF xml_tab.COUNT > 0
1797: THEN

Line 1798: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str1), l_str1);

1794: current_index := 0;
1795:
1796: IF xml_tab.COUNT > 0
1797: THEN
1798: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str1), l_str1);
1799:
1800: FOR table_counter IN xml_tab.FIRST .. xml_tab.LAST
1801: LOOP
1802: l_str8 := xml_tab (table_counter).tagname;

Line 1820: DBMS_LOB.writeappend (l_xfdf_string

1816: THEN
1817: IF l_str9 IN
1818: ('LU_DETAILS','PER_DETAILS','EMP_CAT_DETAILS')
1819: THEN
1820: DBMS_LOB.writeappend (l_xfdf_string
1821: , LENGTH (l_str2)
1822: , l_str2
1823: );
1824: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

Line 1824: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

1820: DBMS_LOB.writeappend (l_xfdf_string
1821: , LENGTH (l_str2)
1822: , l_str2
1823: );
1824: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1825: , l_str8);
1826: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1827: , l_str3);
1828: ELSE

Line 1826: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)

1822: , l_str2
1823: );
1824: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1825: , l_str8);
1826: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1827: , l_str3);
1828: ELSE
1829: DBMS_LOB.writeappend (l_xfdf_string
1830: , LENGTH (l_str4)

Line 1829: DBMS_LOB.writeappend (l_xfdf_string

1825: , l_str8);
1826: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1827: , l_str3);
1828: ELSE
1829: DBMS_LOB.writeappend (l_xfdf_string
1830: , LENGTH (l_str4)
1831: , l_str4
1832: );
1833: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

Line 1833: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

1829: DBMS_LOB.writeappend (l_xfdf_string
1830: , LENGTH (l_str4)
1831: , l_str4
1832: );
1833: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1834: , l_str8);
1835: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
1836: , l_str5);
1837: END IF;

Line 1835: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)

1831: , l_str4
1832: );
1833: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1834: , l_str8);
1835: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
1836: , l_str5);
1837: END IF;
1838: ELSE
1839: IF l_str9 IS NOT NULL

Line 1841: DBMS_LOB.writeappend (l_xfdf_string

1837: END IF;
1838: ELSE
1839: IF l_str9 IS NOT NULL
1840: THEN
1841: DBMS_LOB.writeappend (l_xfdf_string
1842: , LENGTH (l_str2)
1843: , l_str2
1844: );
1845: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

Line 1845: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

1841: DBMS_LOB.writeappend (l_xfdf_string
1842: , LENGTH (l_str2)
1843: , l_str2
1844: );
1845: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1846: , l_str8);
1847: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1848: , l_str3);
1849: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)

Line 1847: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)

1843: , l_str2
1844: );
1845: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1846: , l_str8);
1847: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1848: , l_str3);
1849: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)
1850: , l_str9);
1851: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)

Line 1849: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)

1845: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1846: , l_str8);
1847: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1848: , l_str3);
1849: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)
1850: , l_str9);
1851: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
1852: , l_str4);
1853: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

Line 1851: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)

1847: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1848: , l_str3);
1849: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)
1850: , l_str9);
1851: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
1852: , l_str4);
1853: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1854: , l_str8);
1855: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)

Line 1853: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

1849: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)
1850: , l_str9);
1851: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
1852: , l_str4);
1853: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1854: , l_str8);
1855: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
1856: , l_str5);
1857: ELSE

Line 1855: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)

1851: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
1852: , l_str4);
1853: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1854: , l_str8);
1855: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
1856: , l_str5);
1857: ELSE
1858: DBMS_LOB.writeappend (l_xfdf_string
1859: , LENGTH (l_str2)

Line 1858: DBMS_LOB.writeappend (l_xfdf_string

1854: , l_str8);
1855: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
1856: , l_str5);
1857: ELSE
1858: DBMS_LOB.writeappend (l_xfdf_string
1859: , LENGTH (l_str2)
1860: , l_str2
1861: );
1862: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

Line 1862: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

1858: DBMS_LOB.writeappend (l_xfdf_string
1859: , LENGTH (l_str2)
1860: , l_str2
1861: );
1862: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1863: , l_str8);
1864: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1865: , l_str3);
1866: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)

Line 1864: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)

1860: , l_str2
1861: );
1862: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1863: , l_str8);
1864: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1865: , l_str3);
1866: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
1867: , l_str4);
1868: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

Line 1866: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)

1862: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1863: , l_str8);
1864: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1865: , l_str3);
1866: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
1867: , l_str4);
1868: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1869: , l_str8);
1870: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)

Line 1868: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

1864: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1865: , l_str3);
1866: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
1867: , l_str4);
1868: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1869: , l_str8);
1870: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
1871: , l_str5);
1872: END IF;

Line 1870: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)

1866: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
1867: , l_str4);
1868: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1869: , l_str8);
1870: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
1871: , l_str5);
1872: END IF;
1873: END IF;
1874: END LOOP;

Line 1876: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str6), l_str6);

1872: END IF;
1873: END IF;
1874: END LOOP;
1875:
1876: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str6), l_str6);
1877: ELSE
1878: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);
1879: END IF;
1880: p_xfdf_clob := l_xfdf_string;

Line 1878: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);

1874: END LOOP;
1875:
1876: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str6), l_str6);
1877: ELSE
1878: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);
1879: END IF;
1880: p_xfdf_clob := l_xfdf_string;
1881: -- hr_utility.set_location ('Leaving WritetoCLOB ', 40);
1882: EXCEPTION