APPS.PAY_KW_PAYROLL_REGISTER dependencies on DBMS_LOB

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

1709: l_str7 := '
1710:
1711:
1712: ';
1713: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
1714: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
1715: if p_report = 'MAIN' then
1716: if vXMLTable.count > 0 then
1717: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );

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

1710:
1711:
1712: ';
1713: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
1714: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
1715: if p_report = 'MAIN' then
1716: if vXMLTable.count > 0 then
1717: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
1718: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP

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

1713: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
1714: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
1715: if p_report = 'MAIN' then
1716: if vXMLTable.count > 0 then
1717: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
1718: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP
1719: l_str8 := vXMLTable(ctr_table).TagName;
1720: l_str9 := vXMLTable(ctr_table).TagValue;
1721: if (l_str9 is not null) then

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

1720: l_str9 := vXMLTable(ctr_table).TagValue;
1721: if (l_str9 is not null) then
1722: /* Added CDATA to handle special characters Bug No:6685975 */
1723: l_str9 := '';
1724: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
1725: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
1726: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
1727: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
1728: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);

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

1721: if (l_str9 is not null) then
1722: /* Added CDATA to handle special characters Bug No:6685975 */
1723: l_str9 := '';
1724: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
1725: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
1726: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
1727: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
1728: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1729: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );

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

1722: /* Added CDATA to handle special characters Bug No:6685975 */
1723: l_str9 := '';
1724: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
1725: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
1726: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
1727: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
1728: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1729: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
1730: elsif (l_str9 is null and l_str8 is not null) then

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

1723: l_str9 := '';
1724: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
1725: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
1726: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
1727: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
1728: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1729: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
1730: elsif (l_str9 is null and l_str8 is not null) then
1731: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);

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

1724: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
1725: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
1726: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
1727: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
1728: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1729: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
1730: elsif (l_str9 is null and l_str8 is not null) then
1731: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
1732: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);

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

1725: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
1726: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
1727: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
1728: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1729: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
1730: elsif (l_str9 is null and l_str8 is not null) then
1731: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
1732: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
1733: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);

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

1727: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
1728: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1729: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
1730: elsif (l_str9 is null and l_str8 is not null) then
1731: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
1732: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
1733: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
1734: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
1735: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);

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

1728: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1729: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
1730: elsif (l_str9 is null and l_str8 is not null) then
1731: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
1732: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
1733: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
1734: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
1735: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
1736: else

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

1729: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
1730: elsif (l_str9 is null and l_str8 is not null) then
1731: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
1732: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
1733: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
1734: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
1735: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
1736: else
1737: null;

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

1730: elsif (l_str9 is null and l_str8 is not null) then
1731: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
1732: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
1733: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
1734: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
1735: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
1736: else
1737: null;
1738: end if;

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

1731: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
1732: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
1733: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
1734: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
1735: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
1736: else
1737: null;
1738: end if;
1739: END LOOP;

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

1736: else
1737: null;
1738: end if;
1739: END LOOP;
1740: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6 );
1741: else
1742: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );
1743: end if;
1744: else

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

1738: end if;
1739: END LOOP;
1740: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6 );
1741: else
1742: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );
1743: end if;
1744: else
1745: if vXMLTable_summary.count > 0 then
1746: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );

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

1742: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );
1743: end if;
1744: else
1745: if vXMLTable_summary.count > 0 then
1746: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
1747: FOR ctr_table IN vXMLTable_summary.FIRST .. vXMLTable_summary.LAST LOOP
1748: l_str8 := vXMLTable_summary(ctr_table).TagName;
1749: l_str9 := vXMLTable_summary(ctr_table).TagValue;
1750: if (l_str9 is not null) then

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

1749: l_str9 := vXMLTable_summary(ctr_table).TagValue;
1750: if (l_str9 is not null) then
1751: /* Added CDATA to handle special characters Bug No:6685975 */
1752: l_str9 := '';
1753: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
1754: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
1755: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
1756: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
1757: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);

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

1750: if (l_str9 is not null) then
1751: /* Added CDATA to handle special characters Bug No:6685975 */
1752: l_str9 := '';
1753: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
1754: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
1755: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
1756: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
1757: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1758: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );

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

1751: /* Added CDATA to handle special characters Bug No:6685975 */
1752: l_str9 := '';
1753: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
1754: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
1755: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
1756: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
1757: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1758: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
1759: elsif (l_str9 is null and l_str8 is not null) then

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

1752: l_str9 := '';
1753: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
1754: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
1755: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
1756: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
1757: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1758: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
1759: elsif (l_str9 is null and l_str8 is not null) then
1760: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);

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

1753: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
1754: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
1755: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
1756: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
1757: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1758: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
1759: elsif (l_str9 is null and l_str8 is not null) then
1760: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
1761: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);

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

1754: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
1755: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
1756: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
1757: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1758: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
1759: elsif (l_str9 is null and l_str8 is not null) then
1760: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
1761: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
1762: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);

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

1756: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
1757: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1758: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
1759: elsif (l_str9 is null and l_str8 is not null) then
1760: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
1761: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
1762: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
1763: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
1764: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);

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

1757: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1758: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
1759: elsif (l_str9 is null and l_str8 is not null) then
1760: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
1761: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
1762: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
1763: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
1764: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
1765: else

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

1758: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
1759: elsif (l_str9 is null and l_str8 is not null) then
1760: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
1761: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
1762: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
1763: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
1764: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
1765: else
1766: null;

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

1759: elsif (l_str9 is null and l_str8 is not null) then
1760: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
1761: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
1762: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
1763: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
1764: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
1765: else
1766: null;
1767: end if;

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

1760: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
1761: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
1762: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
1763: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
1764: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
1765: else
1766: null;
1767: end if;
1768: END LOOP;

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

1765: else
1766: null;
1767: end if;
1768: END LOOP;
1769: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6 );
1770: else
1771: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );
1772: end if;
1773: end if;

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

1767: end if;
1768: END LOOP;
1769: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6 );
1770: else
1771: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );
1772: end if;
1773: end if;
1774: DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);
1775: clob_to_blob(l_xfdf_string,p_xfdf_blob);

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

1770: else
1771: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );
1772: end if;
1773: end if;
1774: DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);
1775: clob_to_blob(l_xfdf_string,p_xfdf_blob);
1776: hr_utility.set_location('Finished Procedure Write to CLOB ,Before clob to blob ',110);
1777: --return p_xfdf_blob;
1778: EXCEPTION

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

1798:
1799: begin
1800: hr_utility.set_location('Entered Procedure clob to blob',120);
1801: select userenv('LANGUAGE') into g_nls_db_char from dual;
1802: l_length_clob := dbms_lob.getlength(p_clob);
1803: l_offset := 1;
1804: while l_length_clob > 0 loop
1805: hr_utility.trace('l_length_clob '|| l_length_clob);
1806: if l_length_clob < l_buffer_len then

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

1807: l_chunk_len := l_length_clob;
1808: else
1809: l_chunk_len := l_buffer_len;
1810: end if;
1811: DBMS_LOB.READ(p_clob,l_chunk_len,l_offset,l_varchar_buffer);
1812: --l_raw_buffer := utl_raw.cast_to_raw(l_varchar_buffer);
1813: l_raw_buffer := utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char);
1814: 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));
1815:

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

1813: l_raw_buffer := utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char);
1814: 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));
1815:
1816: hr_utility.trace('l_varchar_buffer '|| l_varchar_buffer);
1817: --dbms_lob.write(p_blob,l_chunk_len, l_offset, l_raw_buffer);
1818: dbms_lob.write(p_blob,l_raw_buffer_len, l_blob_offset, l_raw_buffer);
1819: l_blob_offset := l_blob_offset + l_raw_buffer_len;
1820:
1821: l_offset := l_offset + l_chunk_len;

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

1814: 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));
1815:
1816: hr_utility.trace('l_varchar_buffer '|| l_varchar_buffer);
1817: --dbms_lob.write(p_blob,l_chunk_len, l_offset, l_raw_buffer);
1818: dbms_lob.write(p_blob,l_raw_buffer_len, l_blob_offset, l_raw_buffer);
1819: l_blob_offset := l_blob_offset + l_raw_buffer_len;
1820:
1821: l_offset := l_offset + l_chunk_len;
1822: l_length_clob := l_length_clob - l_chunk_len;

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

1819: l_blob_offset := l_blob_offset + l_raw_buffer_len;
1820:
1821: l_offset := l_offset + l_chunk_len;
1822: l_length_clob := l_length_clob - l_chunk_len;
1823: hr_utility.trace('l_length_blob '|| dbms_lob.getlength(p_blob));
1824: end loop;
1825: hr_utility.set_location('Finished Procedure clob to blob ',130);
1826: end;
1827: