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.

APPS.BSC_PORTLET_UTIL dependencies on UTL_RAW

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

485: LOOP
486: -- fill bytes from the source till buf is full
487: BEGIN
488: LOOP
489: len := utl_raw.length(buf);
490: EXIT WHEN (len = 2000);
491: cut_len := 2000 - nvl(len,0); -- when buff is NULL len becomes NULL which causes the infinite loop
492: IF (cut_len > (lengthb(src(src_row)) - src_pos + 1)) THEN
493: cut_len := lengthb(src(src_row)) - src_pos + 1;

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

491: cut_len := 2000 - nvl(len,0); -- when buff is NULL len becomes NULL which causes the infinite loop
492: IF (cut_len > (lengthb(src(src_row)) - src_pos + 1)) THEN
493: cut_len := lengthb(src(src_row)) - src_pos + 1;
494: END IF;
495: buf := utl_raw.concat(buf, utl_raw.substr(
496: utl_raw.cast_to_raw(src(src_row)), src_pos, cut_len));
497: src_pos := src_pos + cut_len;
498: IF (src_pos > lengthb(src(src_row))) THEN
499: src_row := src_row + 1;

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

492: IF (cut_len > (lengthb(src(src_row)) - src_pos + 1)) THEN
493: cut_len := lengthb(src(src_row)) - src_pos + 1;
494: END IF;
495: buf := utl_raw.concat(buf, utl_raw.substr(
496: utl_raw.cast_to_raw(src(src_row)), src_pos, cut_len));
497: src_pos := src_pos + cut_len;
498: IF (src_pos > lengthb(src(src_row))) THEN
499: src_row := src_row + 1;
500: src_pos := 1;

Line 505: EXIT WHEN utl_raw.length(buf) IS NULL;

501: END IF;
502: END LOOP;
503: EXCEPTION
504: WHEN no_data_found THEN
505: EXIT WHEN utl_raw.length(buf) IS NULL;
506: END;
507:
508: -- extract from buf at character boundary
509: len := lengthb(substr(utl_raw.cast_to_varchar2(buf), 1,

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

505: EXIT WHEN utl_raw.length(buf) IS NULL;
506: END;
507:
508: -- extract from buf at character boundary
509: len := lengthb(substr(utl_raw.cast_to_varchar2(buf), 1,
510: length(utl_raw.cast_to_varchar2(buf))));
511:
512: EXIT WHEN nvl(len,0) = 0; -- bug#2765446
513:

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

506: END;
507:
508: -- extract from buf at character boundary
509: len := lengthb(substr(utl_raw.cast_to_varchar2(buf), 1,
510: length(utl_raw.cast_to_varchar2(buf))));
511:
512: EXIT WHEN nvl(len,0) = 0; -- bug#2765446
513:
514: dst(dst_row) := utl_raw.cast_to_varchar2(utl_raw.substr(buf, 1, len));

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

510: length(utl_raw.cast_to_varchar2(buf))));
511:
512: EXIT WHEN nvl(len,0) = 0; -- bug#2765446
513:
514: dst(dst_row) := utl_raw.cast_to_varchar2(utl_raw.substr(buf, 1, len));
515: IF (len < utl_raw.length(buf)) THEN
516: buf := utl_raw.substr(buf, len + 1);
517: ELSE
518: buf := NULL;

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

511:
512: EXIT WHEN nvl(len,0) = 0; -- bug#2765446
513:
514: dst(dst_row) := utl_raw.cast_to_varchar2(utl_raw.substr(buf, 1, len));
515: IF (len < utl_raw.length(buf)) THEN
516: buf := utl_raw.substr(buf, len + 1);
517: ELSE
518: buf := NULL;
519: END IF;

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

512: EXIT WHEN nvl(len,0) = 0; -- bug#2765446
513:
514: dst(dst_row) := utl_raw.cast_to_varchar2(utl_raw.substr(buf, 1, len));
515: IF (len < utl_raw.length(buf)) THEN
516: buf := utl_raw.substr(buf, len + 1);
517: ELSE
518: buf := NULL;
519: END IF;
520: dst_row := dst_row + 1;