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 1818: DBMS_LOB.createtemporary (l_xfdf_string, FALSE, DBMS_LOB.CALL);

1814: || l_iana_charset
1815: || '"?> ';
1816: l_str10 := '';
1817: l_str11 := '';
1818: DBMS_LOB.createtemporary (l_xfdf_string, FALSE, DBMS_LOB.CALL);
1819: DBMS_LOB.OPEN (l_xfdf_string, DBMS_LOB.lob_readwrite);
1820: current_index := 0;
1821:
1822: IF xml_tab.COUNT > 0

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

1815: || '"?> ';
1816: l_str10 := '';
1817: l_str11 := '';
1818: DBMS_LOB.createtemporary (l_xfdf_string, FALSE, DBMS_LOB.CALL);
1819: DBMS_LOB.OPEN (l_xfdf_string, DBMS_LOB.lob_readwrite);
1820: current_index := 0;
1821:
1822: IF xml_tab.COUNT > 0
1823: THEN

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

1820: current_index := 0;
1821:
1822: IF xml_tab.COUNT > 0
1823: THEN
1824: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str1), l_str1);
1825:
1826: FOR table_counter IN xml_tab.FIRST .. xml_tab.LAST
1827: LOOP
1828: l_str8 := xml_tab (table_counter).tagname;

Line 1846: DBMS_LOB.writeappend (l_xfdf_string

1842: THEN
1843: IF l_str9 IN
1844: ('LU_DETAILS','PER_DETAILS','EMP_CAT_DETAILS')
1845: THEN
1846: DBMS_LOB.writeappend (l_xfdf_string
1847: , LENGTH (l_str2)
1848: , l_str2
1849: );
1850: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

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

1846: DBMS_LOB.writeappend (l_xfdf_string
1847: , LENGTH (l_str2)
1848: , l_str2
1849: );
1850: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1851: , l_str8);
1852: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1853: , l_str3);
1854: ELSE

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

1848: , l_str2
1849: );
1850: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1851: , l_str8);
1852: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1853: , l_str3);
1854: ELSE
1855: DBMS_LOB.writeappend (l_xfdf_string
1856: , LENGTH (l_str4)

Line 1855: DBMS_LOB.writeappend (l_xfdf_string

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

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

1855: DBMS_LOB.writeappend (l_xfdf_string
1856: , LENGTH (l_str4)
1857: , l_str4
1858: );
1859: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1860: , l_str8);
1861: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
1862: , l_str5);
1863: END IF;

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

1857: , l_str4
1858: );
1859: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1860: , l_str8);
1861: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
1862: , l_str5);
1863: END IF;
1864: ELSE
1865: IF l_str9 IS NOT NULL

Line 1867: DBMS_LOB.writeappend (l_xfdf_string

1863: END IF;
1864: ELSE
1865: IF l_str9 IS NOT NULL
1866: THEN
1867: DBMS_LOB.writeappend (l_xfdf_string
1868: , LENGTH (l_str2)
1869: , l_str2
1870: );
1871: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

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

1867: DBMS_LOB.writeappend (l_xfdf_string
1868: , LENGTH (l_str2)
1869: , l_str2
1870: );
1871: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1872: , l_str8);
1873: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1874: , l_str3);
1875: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)

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

1869: , l_str2
1870: );
1871: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1872: , l_str8);
1873: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1874: , l_str3);
1875: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)
1876: , l_str9);
1877: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)

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

1871: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1872: , l_str8);
1873: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1874: , l_str3);
1875: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)
1876: , l_str9);
1877: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
1878: , l_str4);
1879: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

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

1873: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1874: , l_str3);
1875: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)
1876: , l_str9);
1877: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
1878: , l_str4);
1879: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1880: , l_str8);
1881: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)

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

1875: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)
1876: , l_str9);
1877: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
1878: , l_str4);
1879: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1880: , l_str8);
1881: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
1882: , l_str5);
1883: ELSE

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

1877: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
1878: , l_str4);
1879: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1880: , l_str8);
1881: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
1882: , l_str5);
1883: ELSE
1884: DBMS_LOB.writeappend (l_xfdf_string
1885: , LENGTH (l_str2)

Line 1884: DBMS_LOB.writeappend (l_xfdf_string

1880: , l_str8);
1881: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
1882: , l_str5);
1883: ELSE
1884: DBMS_LOB.writeappend (l_xfdf_string
1885: , LENGTH (l_str2)
1886: , l_str2
1887: );
1888: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

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

1884: DBMS_LOB.writeappend (l_xfdf_string
1885: , LENGTH (l_str2)
1886: , l_str2
1887: );
1888: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1889: , l_str8);
1890: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1891: , l_str3);
1892: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)

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

1886: , l_str2
1887: );
1888: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1889: , l_str8);
1890: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1891: , l_str3);
1892: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
1893: , l_str4);
1894: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

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

1888: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1889: , l_str8);
1890: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1891: , l_str3);
1892: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
1893: , l_str4);
1894: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1895: , l_str8);
1896: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)

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

1890: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1891: , l_str3);
1892: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
1893: , l_str4);
1894: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1895: , l_str8);
1896: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
1897: , l_str5);
1898: END IF;

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

1892: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
1893: , l_str4);
1894: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1895: , l_str8);
1896: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
1897: , l_str5);
1898: END IF;
1899: END IF;
1900: END LOOP;

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

1898: END IF;
1899: END IF;
1900: END LOOP;
1901:
1902: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str6), l_str6);
1903: ELSE
1904: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);
1905: END IF;
1906: p_xfdf_clob := l_xfdf_string;

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

1900: END LOOP;
1901:
1902: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str6), l_str6);
1903: ELSE
1904: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);
1905: END IF;
1906: p_xfdf_clob := l_xfdf_string;
1907: -- hr_utility.set_location ('Leaving WritetoCLOB ', 40);
1908: EXCEPTION