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

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

1687: || l_iana_charset
1688: || '"?> ';
1689: l_str10 := NULL;
1690: l_str11 := '';
1691: DBMS_LOB.createtemporary (l_xfdf_string, FALSE, DBMS_LOB.CALL);
1692: DBMS_LOB.OPEN (l_xfdf_string, DBMS_LOB.lob_readwrite);
1693: current_index := 0;
1694:
1695: --logger('CLOB CLOB +== > ','In CLOB');

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

1688: || '"?> ';
1689: l_str10 := NULL;
1690: l_str11 := '';
1691: DBMS_LOB.createtemporary (l_xfdf_string, FALSE, DBMS_LOB.CALL);
1692: DBMS_LOB.OPEN (l_xfdf_string, DBMS_LOB.lob_readwrite);
1693: current_index := 0;
1694:
1695: --logger('CLOB CLOB +== > ','In CLOB');
1696: --logger('str1111 +== > ',l_str1);

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

1696: --logger('str1111 +== > ',l_str1);
1697: --logger('str1111 +== > ',l_str_1);
1698: IF ghpd_data.COUNT > 0
1699: THEN
1700: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str1), l_str1);
1701: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str_1), l_str_1);
1702: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str_2), l_str_2);
1703: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str_3), l_str_3);
1704: FOR table_counter IN ghpd_data.FIRST .. ghpd_data.LAST

Line 1701: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str_1), l_str_1);

1697: --logger('str1111 +== > ',l_str_1);
1698: IF ghpd_data.COUNT > 0
1699: THEN
1700: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str1), l_str1);
1701: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str_1), l_str_1);
1702: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str_2), l_str_2);
1703: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str_3), l_str_3);
1704: FOR table_counter IN ghpd_data.FIRST .. ghpd_data.LAST
1705: LOOP

Line 1702: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str_2), l_str_2);

1698: IF ghpd_data.COUNT > 0
1699: THEN
1700: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str1), l_str1);
1701: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str_1), l_str_1);
1702: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str_2), l_str_2);
1703: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str_3), l_str_3);
1704: FOR table_counter IN ghpd_data.FIRST .. ghpd_data.LAST
1705: LOOP
1706: l_str8 := ghpd_data (table_counter).tagname;

Line 1703: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str_3), l_str_3);

1699: THEN
1700: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str1), l_str1);
1701: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str_1), l_str_1);
1702: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str_2), l_str_2);
1703: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str_3), l_str_3);
1704: FOR table_counter IN ghpd_data.FIRST .. ghpd_data.LAST
1705: LOOP
1706: l_str8 := ghpd_data (table_counter).tagname;
1707: l_str9 := ghpd_data (table_counter).tagvalue;

Line 1765: DBMS_LOB.writeappend (l_xfdf_string

1761: ,'granssnitt:LoneandringHandelse'
1762: ,'granssnitt:NyanmalanHandelse'
1763: )
1764: THEN
1765: DBMS_LOB.writeappend (l_xfdf_string
1766: ,LENGTH (l_str2)
1767: ,l_str2
1768: );
1769: DBMS_LOB.writeappend (l_xfdf_string

Line 1769: DBMS_LOB.writeappend (l_xfdf_string

1765: DBMS_LOB.writeappend (l_xfdf_string
1766: ,LENGTH (l_str2)
1767: ,l_str2
1768: );
1769: DBMS_LOB.writeappend (l_xfdf_string
1770: ,LENGTH (l_str8)
1771: ,l_str8
1772: );
1773: --logger('Adding +== > ','Attribute');

Line 1776: DBMS_LOB.writeappend (l_xfdf_string

1772: );
1773: --logger('Adding +== > ','Attribute');
1774: --logger('Adding l_str10 +== > ', l_str10);
1775: -- Add attribute column
1776: DBMS_LOB.writeappend (l_xfdf_string
1777: ,LENGTH (' Handelsenummer="')
1778: ,' Handelsenummer="'
1779: );
1780: DBMS_LOB.writeappend (l_xfdf_string

Line 1780: DBMS_LOB.writeappend (l_xfdf_string

1776: DBMS_LOB.writeappend (l_xfdf_string
1777: ,LENGTH (' Handelsenummer="')
1778: ,' Handelsenummer="'
1779: );
1780: DBMS_LOB.writeappend (l_xfdf_string
1781: ,LENGTH (l_str10)
1782: ,l_str10
1783: );
1784: DBMS_LOB.writeappend (l_xfdf_string, LENGTH ('"'), '"');

Line 1784: DBMS_LOB.writeappend (l_xfdf_string, LENGTH ('"'), '"');

1780: DBMS_LOB.writeappend (l_xfdf_string
1781: ,LENGTH (l_str10)
1782: ,l_str10
1783: );
1784: DBMS_LOB.writeappend (l_xfdf_string, LENGTH ('"'), '"');
1785: -- END of attribute addition
1786: DBMS_LOB.writeappend (l_xfdf_string
1787: ,LENGTH (l_str3)
1788: ,l_str3

Line 1786: DBMS_LOB.writeappend (l_xfdf_string

1782: ,l_str10
1783: );
1784: DBMS_LOB.writeappend (l_xfdf_string, LENGTH ('"'), '"');
1785: -- END of attribute addition
1786: DBMS_LOB.writeappend (l_xfdf_string
1787: ,LENGTH (l_str3)
1788: ,l_str3
1789: );
1790: ELSE

Line 1791: DBMS_LOB.writeappend (l_xfdf_string

1787: ,LENGTH (l_str3)
1788: ,l_str3
1789: );
1790: ELSE
1791: DBMS_LOB.writeappend (l_xfdf_string
1792: ,LENGTH (l_str2)
1793: ,l_str2
1794: );
1795: DBMS_LOB.writeappend (l_xfdf_string

Line 1795: DBMS_LOB.writeappend (l_xfdf_string

1791: DBMS_LOB.writeappend (l_xfdf_string
1792: ,LENGTH (l_str2)
1793: ,l_str2
1794: );
1795: DBMS_LOB.writeappend (l_xfdf_string
1796: ,LENGTH (l_str8)
1797: ,l_str8
1798: );
1799: DBMS_LOB.writeappend (l_xfdf_string

Line 1799: DBMS_LOB.writeappend (l_xfdf_string

1795: DBMS_LOB.writeappend (l_xfdf_string
1796: ,LENGTH (l_str8)
1797: ,l_str8
1798: );
1799: DBMS_LOB.writeappend (l_xfdf_string
1800: ,LENGTH (l_str3)
1801: ,l_str3
1802: );
1803: END IF;

Line 1805: DBMS_LOB.writeappend (l_xfdf_string

1801: ,l_str3
1802: );
1803: END IF;
1804: ELSE
1805: DBMS_LOB.writeappend (l_xfdf_string
1806: ,LENGTH (l_str4)
1807: ,l_str4
1808: );
1809: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

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

1805: DBMS_LOB.writeappend (l_xfdf_string
1806: ,LENGTH (l_str4)
1807: ,l_str4
1808: );
1809: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1810: ,l_str8);
1811: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
1812: ,l_str5);
1813: END IF;

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

1807: ,l_str4
1808: );
1809: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1810: ,l_str8);
1811: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
1812: ,l_str5);
1813: END IF;
1814: ELSE
1815: IF l_str9 IS NOT NULL

Line 1817: DBMS_LOB.writeappend (l_xfdf_string

1813: END IF;
1814: ELSE
1815: IF l_str9 IS NOT NULL
1816: THEN
1817: DBMS_LOB.writeappend (l_xfdf_string
1818: ,LENGTH (l_str2)
1819: ,l_str2
1820: );
1821: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

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

1817: DBMS_LOB.writeappend (l_xfdf_string
1818: ,LENGTH (l_str2)
1819: ,l_str2
1820: );
1821: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1822: ,l_str8);
1823: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1824: ,l_str3);
1825: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)

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

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

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

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

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

1823: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1824: ,l_str3);
1825: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9)
1826: ,l_str9);
1827: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
1828: ,l_str4);
1829: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1830: ,l_str8);
1831: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)

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

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

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

1827: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
1828: ,l_str4);
1829: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1830: ,l_str8);
1831: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
1832: ,l_str5);
1833: ELSE
1834: DBMS_LOB.writeappend (l_xfdf_string
1835: ,LENGTH (l_str2)

Line 1834: DBMS_LOB.writeappend (l_xfdf_string

1830: ,l_str8);
1831: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
1832: ,l_str5);
1833: ELSE
1834: DBMS_LOB.writeappend (l_xfdf_string
1835: ,LENGTH (l_str2)
1836: ,l_str2
1837: );
1838: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

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

1834: DBMS_LOB.writeappend (l_xfdf_string
1835: ,LENGTH (l_str2)
1836: ,l_str2
1837: );
1838: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1839: ,l_str8);
1840: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1841: ,l_str3);
1842: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)

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

1836: ,l_str2
1837: );
1838: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1839: ,l_str8);
1840: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1841: ,l_str3);
1842: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
1843: ,l_str4);
1844: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)

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

1838: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1839: ,l_str8);
1840: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1841: ,l_str3);
1842: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
1843: ,l_str4);
1844: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1845: ,l_str8);
1846: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)

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

1840: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3)
1841: ,l_str3);
1842: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
1843: ,l_str4);
1844: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1845: ,l_str8);
1846: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
1847: ,l_str5);
1848: END IF;

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

1842: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4)
1843: ,l_str4);
1844: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8)
1845: ,l_str8);
1846: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5)
1847: ,l_str5);
1848: END IF;
1849: END IF;
1850: END LOOP;

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

1848: END IF;
1849: END IF;
1850: END LOOP;
1851:
1852: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str6), l_str6);
1853: ELSE
1854: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);
1855: END IF;
1856:

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

1850: END LOOP;
1851:
1852: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str6), l_str6);
1853: ELSE
1854: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);
1855: END IF;
1856:
1857: p_xfdf_clob := l_xfdf_string;
1858: hr_utility.set_location ('Leaving WritetoCLOB ', 40);