APPS.IGS_CO_GEN_004 dependencies on UTL_RAW

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 442: l_query := l_query || utl_raw.cast_to_varchar2(l_rawBuffer);

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;
446:

Line 449: l_query := l_query || utl_raw.cast_to_varchar2(l_rawBuffer);

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;
453: END IF;

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: