APPS.PAY_KW_PAYROLL_REGISTER dependencies on DBMS_LOB

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

1870: l_str7 := '
1871:
1872:
1873: ';
1874: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
1875: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
1876: if p_report = 'MAIN' then
1877: if vXMLTable.count > 0 then
1878: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );

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

1871:
1872:
1873: ';
1874: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
1875: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
1876: if p_report = 'MAIN' then
1877: if vXMLTable.count > 0 then
1878: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
1879: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP

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

1874: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
1875: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
1876: if p_report = 'MAIN' then
1877: if vXMLTable.count > 0 then
1878: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
1879: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP
1880: l_str8 := vXMLTable(ctr_table).TagName;
1881: l_str9 := vXMLTable(ctr_table).TagValue;
1882: if (l_str9 is not null) then

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

1881: l_str9 := vXMLTable(ctr_table).TagValue;
1882: if (l_str9 is not null) then
1883: /* Added CDATA to handle special characters Bug No:6685975 */
1884: l_str9 := '';
1885: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
1886: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
1887: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
1888: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
1889: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);

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

1882: if (l_str9 is not null) then
1883: /* Added CDATA to handle special characters Bug No:6685975 */
1884: l_str9 := '';
1885: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
1886: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
1887: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
1888: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
1889: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1890: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );

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

1883: /* Added CDATA to handle special characters Bug No:6685975 */
1884: l_str9 := '';
1885: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
1886: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
1887: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
1888: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
1889: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1890: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
1891: elsif (l_str9 is null and l_str8 is not null) then

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

1884: l_str9 := '';
1885: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
1886: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
1887: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
1888: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
1889: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1890: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
1891: elsif (l_str9 is null and l_str8 is not null) then
1892: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);

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

1885: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
1886: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
1887: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
1888: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
1889: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1890: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
1891: elsif (l_str9 is null and l_str8 is not null) then
1892: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
1893: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);

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

1886: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
1887: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
1888: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
1889: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1890: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
1891: elsif (l_str9 is null and l_str8 is not null) then
1892: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
1893: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
1894: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);

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

1888: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
1889: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1890: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
1891: elsif (l_str9 is null and l_str8 is not null) then
1892: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
1893: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
1894: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
1895: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
1896: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);

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

1889: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1890: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
1891: elsif (l_str9 is null and l_str8 is not null) then
1892: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
1893: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
1894: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
1895: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
1896: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
1897: else

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

1890: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
1891: elsif (l_str9 is null and l_str8 is not null) then
1892: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
1893: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
1894: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
1895: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
1896: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
1897: else
1898: null;

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

1891: elsif (l_str9 is null and l_str8 is not null) then
1892: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
1893: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
1894: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
1895: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
1896: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
1897: else
1898: null;
1899: end if;

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

1892: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
1893: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
1894: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
1895: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
1896: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
1897: else
1898: null;
1899: end if;
1900: END LOOP;

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

1897: else
1898: null;
1899: end if;
1900: END LOOP;
1901: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6 );
1902: else
1903: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );
1904: end if;
1905: else

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

1899: end if;
1900: END LOOP;
1901: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6 );
1902: else
1903: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );
1904: end if;
1905: else
1906: if vXMLTable_summary.count > 0 then
1907: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );

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

1903: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );
1904: end if;
1905: else
1906: if vXMLTable_summary.count > 0 then
1907: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
1908: FOR ctr_table IN vXMLTable_summary.FIRST .. vXMLTable_summary.LAST LOOP
1909: l_str8 := vXMLTable_summary(ctr_table).TagName;
1910: l_str9 := vXMLTable_summary(ctr_table).TagValue;
1911: if (l_str9 is not null) then

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

1910: l_str9 := vXMLTable_summary(ctr_table).TagValue;
1911: if (l_str9 is not null) then
1912: /* Added CDATA to handle special characters Bug No:6685975 */
1913: l_str9 := '';
1914: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
1915: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
1916: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
1917: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
1918: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);

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

1911: if (l_str9 is not null) then
1912: /* Added CDATA to handle special characters Bug No:6685975 */
1913: l_str9 := '';
1914: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
1915: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
1916: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
1917: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
1918: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1919: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );

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

1912: /* Added CDATA to handle special characters Bug No:6685975 */
1913: l_str9 := '';
1914: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
1915: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
1916: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
1917: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
1918: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1919: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
1920: elsif (l_str9 is null and l_str8 is not null) then

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

1913: l_str9 := '';
1914: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
1915: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
1916: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
1917: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
1918: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1919: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
1920: elsif (l_str9 is null and l_str8 is not null) then
1921: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);

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

1914: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
1915: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
1916: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
1917: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
1918: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1919: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
1920: elsif (l_str9 is null and l_str8 is not null) then
1921: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
1922: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);

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

1915: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
1916: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
1917: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
1918: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1919: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
1920: elsif (l_str9 is null and l_str8 is not null) then
1921: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
1922: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
1923: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);

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

1917: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
1918: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1919: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
1920: elsif (l_str9 is null and l_str8 is not null) then
1921: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
1922: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
1923: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
1924: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
1925: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);

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

1918: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1919: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
1920: elsif (l_str9 is null and l_str8 is not null) then
1921: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
1922: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
1923: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
1924: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
1925: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
1926: else

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

1919: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
1920: elsif (l_str9 is null and l_str8 is not null) then
1921: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
1922: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
1923: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
1924: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
1925: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
1926: else
1927: null;

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

1920: elsif (l_str9 is null and l_str8 is not null) then
1921: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
1922: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
1923: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
1924: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
1925: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
1926: else
1927: null;
1928: end if;

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

1921: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
1922: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
1923: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
1924: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
1925: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
1926: else
1927: null;
1928: end if;
1929: END LOOP;

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

1926: else
1927: null;
1928: end if;
1929: END LOOP;
1930: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6 );
1931: else
1932: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );
1933: end if;
1934: end if;

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

1928: end if;
1929: END LOOP;
1930: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6 );
1931: else
1932: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );
1933: end if;
1934: end if;
1935: DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);
1936: clob_to_blob(l_xfdf_string,p_xfdf_blob);

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

1931: else
1932: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );
1933: end if;
1934: end if;
1935: DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);
1936: clob_to_blob(l_xfdf_string,p_xfdf_blob);
1937: hr_utility.set_location('Finished Procedure Write to CLOB ,Before clob to blob ',110);
1938: --return p_xfdf_blob;
1939: EXCEPTION

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

1959:
1960: begin
1961: hr_utility.set_location('Entered Procedure clob to blob',120);
1962: select userenv('LANGUAGE') into g_nls_db_char from dual;
1963: l_length_clob := dbms_lob.getlength(p_clob);
1964: l_offset := 1;
1965: while l_length_clob > 0 loop
1966: hr_utility.trace('l_length_clob '|| l_length_clob);
1967: if l_length_clob < l_buffer_len then

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

1968: l_chunk_len := l_length_clob;
1969: else
1970: l_chunk_len := l_buffer_len;
1971: end if;
1972: DBMS_LOB.READ(p_clob,l_chunk_len,l_offset,l_varchar_buffer);
1973: --l_raw_buffer := utl_raw.cast_to_raw(l_varchar_buffer);
1974: l_raw_buffer := utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char);
1975: 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));
1976:

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

1974: l_raw_buffer := utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char);
1975: 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));
1976:
1977: hr_utility.trace('l_varchar_buffer '|| l_varchar_buffer);
1978: --dbms_lob.write(p_blob,l_chunk_len, l_offset, l_raw_buffer);
1979: dbms_lob.write(p_blob,l_raw_buffer_len, l_blob_offset, l_raw_buffer);
1980: l_blob_offset := l_blob_offset + l_raw_buffer_len;
1981:
1982: l_offset := l_offset + l_chunk_len;

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

1975: 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));
1976:
1977: hr_utility.trace('l_varchar_buffer '|| l_varchar_buffer);
1978: --dbms_lob.write(p_blob,l_chunk_len, l_offset, l_raw_buffer);
1979: dbms_lob.write(p_blob,l_raw_buffer_len, l_blob_offset, l_raw_buffer);
1980: l_blob_offset := l_blob_offset + l_raw_buffer_len;
1981:
1982: l_offset := l_offset + l_chunk_len;
1983: l_length_clob := l_length_clob - l_chunk_len;

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

1980: l_blob_offset := l_blob_offset + l_raw_buffer_len;
1981:
1982: l_offset := l_offset + l_chunk_len;
1983: l_length_clob := l_length_clob - l_chunk_len;
1984: hr_utility.trace('l_length_blob '|| dbms_lob.getlength(p_blob));
1985: end loop;
1986: hr_utility.set_location('Finished Procedure clob to blob ',130);
1987: end;
1988: