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

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

1821: l_str7 := '
1822:
1823:
1824: ';
1825: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
1826: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
1827: if p_report = 'MAIN' then
1828: if vXMLTable.count > 0 then
1829: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );

Line 1826: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);

1822:
1823:
1824: ';
1825: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
1826: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
1827: if p_report = 'MAIN' then
1828: if vXMLTable.count > 0 then
1829: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
1830: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP

Line 1829: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );

1825: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
1826: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
1827: if p_report = 'MAIN' then
1828: if vXMLTable.count > 0 then
1829: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
1830: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP
1831: l_str8 := vXMLTable(ctr_table).TagName;
1832: l_str9 := vXMLTable(ctr_table).TagValue;
1833: if (l_str9 is not null) then

Line 1836: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );

1832: l_str9 := vXMLTable(ctr_table).TagValue;
1833: if (l_str9 is not null) then
1834: /* Added CDATA to handle special characters Bug No: 6676325*/
1835: l_str9 := '';
1836: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
1837: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
1838: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
1839: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
1840: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);

Line 1837: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);

1833: if (l_str9 is not null) then
1834: /* Added CDATA to handle special characters Bug No: 6676325*/
1835: l_str9 := '';
1836: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
1837: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
1838: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
1839: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
1840: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1841: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );

Line 1838: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );

1834: /* Added CDATA to handle special characters Bug No: 6676325*/
1835: l_str9 := '';
1836: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
1837: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
1838: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
1839: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
1840: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1841: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
1842: elsif (l_str9 is null and l_str8 is not null) then

Line 1839: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );

1835: l_str9 := '';
1836: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
1837: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
1838: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
1839: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
1840: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1841: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
1842: elsif (l_str9 is null and l_str8 is not null) then
1843: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);

Line 1840: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);

1836: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
1837: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
1838: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
1839: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
1840: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1841: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
1842: elsif (l_str9 is null and l_str8 is not null) then
1843: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
1844: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);

Line 1841: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );

1837: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
1838: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
1839: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
1840: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1841: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
1842: elsif (l_str9 is null and l_str8 is not null) then
1843: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
1844: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
1845: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);

Line 1843: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);

1839: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
1840: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1841: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
1842: elsif (l_str9 is null and l_str8 is not null) then
1843: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
1844: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
1845: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
1846: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
1847: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);

Line 1844: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);

1840: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1841: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
1842: elsif (l_str9 is null and l_str8 is not null) then
1843: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
1844: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
1845: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
1846: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
1847: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
1848: else

Line 1845: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);

1841: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
1842: elsif (l_str9 is null and l_str8 is not null) then
1843: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
1844: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
1845: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
1846: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
1847: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
1848: else
1849: null;

Line 1846: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);

1842: elsif (l_str9 is null and l_str8 is not null) then
1843: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
1844: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
1845: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
1846: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
1847: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
1848: else
1849: null;
1850: end if;

Line 1847: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);

1843: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
1844: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
1845: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
1846: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
1847: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
1848: else
1849: null;
1850: end if;
1851: END LOOP;

Line 1852: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6 );

1848: else
1849: null;
1850: end if;
1851: END LOOP;
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: else

Line 1854: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );

1850: end if;
1851: END LOOP;
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: else
1857: if vXMLTable_summary.count > 0 then
1858: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );

Line 1858: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );

1854: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );
1855: end if;
1856: else
1857: if vXMLTable_summary.count > 0 then
1858: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
1859: FOR ctr_table IN vXMLTable_summary.FIRST .. vXMLTable_summary.LAST LOOP
1860: l_str8 := vXMLTable_summary(ctr_table).TagName;
1861: l_str9 := vXMLTable_summary(ctr_table).TagValue;
1862: if (l_str9 is not null) then

Line 1865: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );

1861: l_str9 := vXMLTable_summary(ctr_table).TagValue;
1862: if (l_str9 is not null) then
1863: /* Added CDATA to handle special characters Bug No: 6676325*/
1864: l_str9 := '';
1865: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
1866: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
1867: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
1868: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
1869: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);

Line 1866: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);

1862: if (l_str9 is not null) then
1863: /* Added CDATA to handle special characters Bug No: 6676325*/
1864: l_str9 := '';
1865: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
1866: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
1867: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
1868: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
1869: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1870: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );

Line 1867: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );

1863: /* Added CDATA to handle special characters Bug No: 6676325*/
1864: l_str9 := '';
1865: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
1866: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
1867: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
1868: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
1869: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1870: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
1871: elsif (l_str9 is null and l_str8 is not null) then

Line 1868: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );

1864: l_str9 := '';
1865: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
1866: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
1867: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
1868: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
1869: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1870: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
1871: elsif (l_str9 is null and l_str8 is not null) then
1872: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);

Line 1869: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);

1865: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
1866: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
1867: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
1868: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
1869: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1870: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
1871: elsif (l_str9 is null and l_str8 is not null) then
1872: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
1873: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);

Line 1870: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );

1866: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
1867: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
1868: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
1869: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1870: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
1871: elsif (l_str9 is null and l_str8 is not null) then
1872: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
1873: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
1874: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);

Line 1872: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);

1868: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
1869: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1870: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
1871: elsif (l_str9 is null and l_str8 is not null) then
1872: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
1873: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
1874: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
1875: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
1876: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);

Line 1873: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);

1869: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1870: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
1871: elsif (l_str9 is null and l_str8 is not null) then
1872: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
1873: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
1874: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
1875: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
1876: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
1877: else

Line 1874: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);

1870: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
1871: elsif (l_str9 is null and l_str8 is not null) then
1872: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
1873: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
1874: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
1875: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
1876: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
1877: else
1878: null;

Line 1875: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);

1871: elsif (l_str9 is null and l_str8 is not null) then
1872: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
1873: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
1874: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
1875: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
1876: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
1877: else
1878: null;
1879: end if;

Line 1876: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);

1872: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
1873: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
1874: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
1875: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
1876: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
1877: else
1878: null;
1879: end if;
1880: END LOOP;

Line 1881: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6 );

1877: else
1878: null;
1879: end if;
1880: END LOOP;
1881: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6 );
1882: else
1883: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );
1884: end if;
1885: end if;

Line 1883: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );

1879: end if;
1880: END LOOP;
1881: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6 );
1882: else
1883: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );
1884: end if;
1885: end if;
1886: DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);
1887: clob_to_blob(l_xfdf_string,p_xfdf_blob);

Line 1886: DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);

1882: else
1883: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );
1884: end if;
1885: end if;
1886: DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);
1887: clob_to_blob(l_xfdf_string,p_xfdf_blob);
1888: hr_utility.set_location('Finished Procedure Write to CLOB ,Before clob to blob ',110);
1889: --return p_xfdf_blob;
1890: EXCEPTION

Line 1912: l_length_clob := dbms_lob.getlength(p_clob);

1908: l_blob_offset pls_integer := 1;
1909: begin
1910: hr_utility.set_location('Entered Procedure clob to blob',120);
1911: select userenv('LANGUAGE') into g_nls_db_char from dual;
1912: l_length_clob := dbms_lob.getlength(p_clob);
1913: l_offset := 1;
1914: while l_length_clob > 0 loop
1915: hr_utility.trace('l_length_clob '|| l_length_clob);
1916: if l_length_clob < l_buffer_len then

Line 1921: DBMS_LOB.READ(p_clob,l_chunk_len,l_offset,l_varchar_buffer);

1917: l_chunk_len := l_length_clob;
1918: else
1919: l_chunk_len := l_buffer_len;
1920: end if;
1921: DBMS_LOB.READ(p_clob,l_chunk_len,l_offset,l_varchar_buffer);
1922: --l_raw_buffer := utl_raw.cast_to_raw(l_varchar_buffer);
1923: l_raw_buffer := utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char);
1924: l_raw_buffer_len := utl_raw.length(utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char));
1925: hr_utility.trace('l_varchar_buffer '|| l_varchar_buffer);

Line 1926: --dbms_lob.write(p_blob,l_chunk_len, l_offset, l_raw_buffer);

1922: --l_raw_buffer := utl_raw.cast_to_raw(l_varchar_buffer);
1923: l_raw_buffer := utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char);
1924: l_raw_buffer_len := utl_raw.length(utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char));
1925: hr_utility.trace('l_varchar_buffer '|| l_varchar_buffer);
1926: --dbms_lob.write(p_blob,l_chunk_len, l_offset, l_raw_buffer);
1927: dbms_lob.write(p_blob,l_raw_buffer_len, l_blob_offset, l_raw_buffer);
1928: l_blob_offset := l_blob_offset + l_raw_buffer_len;
1929: l_offset := l_offset + l_chunk_len;
1930: l_length_clob := l_length_clob - l_chunk_len;

Line 1927: dbms_lob.write(p_blob,l_raw_buffer_len, l_blob_offset, l_raw_buffer);

1923: l_raw_buffer := utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char);
1924: l_raw_buffer_len := utl_raw.length(utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char));
1925: hr_utility.trace('l_varchar_buffer '|| l_varchar_buffer);
1926: --dbms_lob.write(p_blob,l_chunk_len, l_offset, l_raw_buffer);
1927: dbms_lob.write(p_blob,l_raw_buffer_len, l_blob_offset, l_raw_buffer);
1928: l_blob_offset := l_blob_offset + l_raw_buffer_len;
1929: l_offset := l_offset + l_chunk_len;
1930: l_length_clob := l_length_clob - l_chunk_len;
1931: hr_utility.trace('l_length_blob '|| dbms_lob.getlength(p_blob));

Line 1931: hr_utility.trace('l_length_blob '|| dbms_lob.getlength(p_blob));

1927: dbms_lob.write(p_blob,l_raw_buffer_len, l_blob_offset, l_raw_buffer);
1928: l_blob_offset := l_blob_offset + l_raw_buffer_len;
1929: l_offset := l_offset + l_chunk_len;
1930: l_length_clob := l_length_clob - l_chunk_len;
1931: hr_utility.trace('l_length_blob '|| dbms_lob.getlength(p_blob));
1932: end loop;
1933: hr_utility.set_location('Finished Procedure clob to blob ',130);
1934: end;
1935: ----------------------------------------------------------------