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.

[Home] [Help]

APPS.BSC_PORTLET_GRAPH dependencies on UTL_RAW

Line 287: len := utl_raw.length(buf);

283: LOOP
284: -- fill bytes from the source till buf is full
285: BEGIN
286: LOOP
287: len := utl_raw.length(buf);
288: EXIT WHEN (len = 2000);
289: cut_len := 2000 - len;
290: IF (cut_len > (lengthb(src(src_row)) - src_pos + 1)) THEN
291: cut_len := lengthb(src(src_row)) - src_pos + 1;

Line 293: buf := utl_raw.concat(buf, utl_raw.substr(

289: cut_len := 2000 - len;
290: IF (cut_len > (lengthb(src(src_row)) - src_pos + 1)) THEN
291: cut_len := lengthb(src(src_row)) - src_pos + 1;
292: END IF;
293: buf := utl_raw.concat(buf, utl_raw.substr(
294: utl_raw.cast_to_raw(src(src_row)), src_pos, cut_len));
295: src_pos := src_pos + cut_len;
296: IF (src_pos > lengthb(src(src_row))) THEN
297: src_row := src_row + 1;

Line 294: utl_raw.cast_to_raw(src(src_row)), src_pos, cut_len));

290: IF (cut_len > (lengthb(src(src_row)) - src_pos + 1)) THEN
291: cut_len := lengthb(src(src_row)) - src_pos + 1;
292: END IF;
293: buf := utl_raw.concat(buf, utl_raw.substr(
294: utl_raw.cast_to_raw(src(src_row)), src_pos, cut_len));
295: src_pos := src_pos + cut_len;
296: IF (src_pos > lengthb(src(src_row))) THEN
297: src_row := src_row + 1;
298: src_pos := 1;

Line 303: EXIT WHEN utl_raw.length(buf) = 0;

299: END IF;
300: END LOOP;
301: EXCEPTION
302: WHEN no_data_found THEN
303: EXIT WHEN utl_raw.length(buf) = 0;
304: END;
305:
306: -- extract from buf at character boundary
307: len := lengthb(substr(utl_raw.cast_to_varchar2(buf), 1,

Line 307: len := lengthb(substr(utl_raw.cast_to_varchar2(buf), 1,

303: EXIT WHEN utl_raw.length(buf) = 0;
304: END;
305:
306: -- extract from buf at character boundary
307: len := lengthb(substr(utl_raw.cast_to_varchar2(buf), 1,
308: length(utl_raw.cast_to_varchar2(buf))));
309: dst(dst_row) := utl_raw.cast_to_varchar2(utl_raw.substr(buf, 1, len));
310: IF (len < utl_raw.length(buf)) THEN
311: buf := utl_raw.substr(buf, len + 1);

Line 308: length(utl_raw.cast_to_varchar2(buf))));

304: END;
305:
306: -- extract from buf at character boundary
307: len := lengthb(substr(utl_raw.cast_to_varchar2(buf), 1,
308: length(utl_raw.cast_to_varchar2(buf))));
309: dst(dst_row) := utl_raw.cast_to_varchar2(utl_raw.substr(buf, 1, len));
310: IF (len < utl_raw.length(buf)) THEN
311: buf := utl_raw.substr(buf, len + 1);
312: ELSE

Line 309: dst(dst_row) := utl_raw.cast_to_varchar2(utl_raw.substr(buf, 1, len));

305:
306: -- extract from buf at character boundary
307: len := lengthb(substr(utl_raw.cast_to_varchar2(buf), 1,
308: length(utl_raw.cast_to_varchar2(buf))));
309: dst(dst_row) := utl_raw.cast_to_varchar2(utl_raw.substr(buf, 1, len));
310: IF (len < utl_raw.length(buf)) THEN
311: buf := utl_raw.substr(buf, len + 1);
312: ELSE
313: buf := NULL;

Line 310: IF (len < utl_raw.length(buf)) THEN

306: -- extract from buf at character boundary
307: len := lengthb(substr(utl_raw.cast_to_varchar2(buf), 1,
308: length(utl_raw.cast_to_varchar2(buf))));
309: dst(dst_row) := utl_raw.cast_to_varchar2(utl_raw.substr(buf, 1, len));
310: IF (len < utl_raw.length(buf)) THEN
311: buf := utl_raw.substr(buf, len + 1);
312: ELSE
313: buf := NULL;
314: END IF;

Line 311: buf := utl_raw.substr(buf, len + 1);

307: len := lengthb(substr(utl_raw.cast_to_varchar2(buf), 1,
308: length(utl_raw.cast_to_varchar2(buf))));
309: dst(dst_row) := utl_raw.cast_to_varchar2(utl_raw.substr(buf, 1, len));
310: IF (len < utl_raw.length(buf)) THEN
311: buf := utl_raw.substr(buf, len + 1);
312: ELSE
313: buf := NULL;
314: END IF;
315: dst_row := dst_row + 1;