APPS.IGS_CO_GEN_004 dependencies on DBMS_LOB

Line 431: l_totalLen := DBMS_LOB.GETLENGTH(l_xmlBlob_loc);

427: SELECT file_data INTO l_xmlBlob_loc
428: FROM fnd_lobs
429: WHERE file_id = p_file_id;
430:
431: l_totalLen := DBMS_LOB.GETLENGTH(l_xmlBlob_loc);
432: l_chunksize := DBMS_LOB.GETCHUNKSIZE(l_xmlBlob_loc);
433:
434: IF (l_chunksize < 32767) THEN
435: l_amount := (32767 / l_chunksize) * l_chunksize;

Line 432: l_chunksize := DBMS_LOB.GETCHUNKSIZE(l_xmlBlob_loc);

428: FROM fnd_lobs
429: WHERE file_id = p_file_id;
430:
431: l_totalLen := DBMS_LOB.GETLENGTH(l_xmlBlob_loc);
432: l_chunksize := DBMS_LOB.GETCHUNKSIZE(l_xmlBlob_loc);
433:
434: IF (l_chunksize < 32767) THEN
435: l_amount := (32767 / l_chunksize) * l_chunksize;
436: END IF;

Line 440: DBMS_LOB.READ(l_xmlBlob_loc, l_amount, l_offset, l_rawBuffer);

436: END IF;
437:
438: l_query := '';
439: WHILE l_totalLen >= l_amount LOOP
440: DBMS_LOB.READ(l_xmlBlob_loc, l_amount, l_offset, l_rawBuffer);
441: --DBMS_LOB.WRITEAPPEND(p_xml_clob_loc, utl_raw.LENGTH(l_rawBuffer), utl_raw.cast_to_varchar2(l_rawBuffer));
442: l_query := l_query || utl_raw.cast_to_varchar2(l_rawBuffer);
443: l_totalLen := l_totalLen - l_amount;
444: l_offset := l_offset + l_amount;

Line 441: --DBMS_LOB.WRITEAPPEND(p_xml_clob_loc, utl_raw.LENGTH(l_rawBuffer), utl_raw.cast_to_varchar2(l_rawBuffer));

437:
438: l_query := '';
439: WHILE l_totalLen >= l_amount LOOP
440: DBMS_LOB.READ(l_xmlBlob_loc, l_amount, l_offset, l_rawBuffer);
441: --DBMS_LOB.WRITEAPPEND(p_xml_clob_loc, utl_raw.LENGTH(l_rawBuffer), utl_raw.cast_to_varchar2(l_rawBuffer));
442: l_query := l_query || utl_raw.cast_to_varchar2(l_rawBuffer);
443: l_totalLen := l_totalLen - l_amount;
444: l_offset := l_offset + l_amount;
445: END LOOP;

Line 448: DBMS_LOB.READ(l_xmlBlob_loc, l_totalLen, l_offset, l_rawBuffer);

444: l_offset := l_offset + l_amount;
445: END LOOP;
446:
447: IF l_totalLen > 0 THEN
448: DBMS_LOB.READ(l_xmlBlob_loc, l_totalLen, l_offset, l_rawBuffer);
449: l_query := l_query || utl_raw.cast_to_varchar2(l_rawBuffer);
450: --DBMS_LOB.WRITEAPPEND(p_xml_clob_loc, utl_raw.LENGTH(l_rawBuffer), utl_raw.cast_to_varchar2(l_rawBuffer));
451: END IF;
452: p_query_text := l_query;

Line 450: --DBMS_LOB.WRITEAPPEND(p_xml_clob_loc, utl_raw.LENGTH(l_rawBuffer), utl_raw.cast_to_varchar2(l_rawBuffer));

446:
447: IF l_totalLen > 0 THEN
448: DBMS_LOB.READ(l_xmlBlob_loc, l_totalLen, l_offset, l_rawBuffer);
449: l_query := l_query || utl_raw.cast_to_varchar2(l_rawBuffer);
450: --DBMS_LOB.WRITEAPPEND(p_xml_clob_loc, utl_raw.LENGTH(l_rawBuffer), utl_raw.cast_to_varchar2(l_rawBuffer));
451: END IF;
452: p_query_text := l_query;
453: END IF;
454: