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.ETRM_FNDNAV dependencies on DBMS_LOB

Line 1580: , dbms_lob.getlength(FILE_CONTENT) file_length

1576: select APPLICATION_ID
1577: , FILE_NAME
1578: , FILE_TYPE
1579: , DESCRIPTION
1580: , dbms_lob.getlength(FILE_CONTENT) file_length
1581: from fnd_etrm_files
1582: where file_id = n_fileid;
1583:
1584:

Line 1661: lob_bytes_remaining := dbms_lob.getlength(lob_rec.file_content);

1657: v_disposition varchar2(32) := 'attachment';
1658:
1659: begin
1660: for lob_rec in cur_get_lob(n_file_id) loop
1661: lob_bytes_remaining := dbms_lob.getlength(lob_rec.file_content);
1662:
1663: if upper(c_mode) = 'INLINE'
1664: then v_disposition := 'inline';
1665: else

Line 1678: chunksize := dbms_lob.getchunksize(lob_rec.file_content);

1674: htp.p('Content-Transfer-Encoding: base64');
1675: htp.p('');
1676: end if;
1677:
1678: chunksize := dbms_lob.getchunksize(lob_rec.file_content);
1679: if (chunksize < 32767) then
1680: amount := (32767 / chunksize) * chunksize;
1681: end if;
1682: dbms_lob.open(lob_rec.file_content, DBMS_LOB.LOB_READONLY);

Line 1682: dbms_lob.open(lob_rec.file_content, DBMS_LOB.LOB_READONLY);

1678: chunksize := dbms_lob.getchunksize(lob_rec.file_content);
1679: if (chunksize < 32767) then
1680: amount := (32767 / chunksize) * chunksize;
1681: end if;
1682: dbms_lob.open(lob_rec.file_content, DBMS_LOB.LOB_READONLY);
1683:
1684: while (lob_bytes_remaining > 0) loop
1685: if (lob_bytes_remaining < amount) then
1686: amount := lob_bytes_remaining;

Line 1688: dbms_lob.read(lob_rec.file_content, amount, position, buffer);

1684: while (lob_bytes_remaining > 0) loop
1685: if (lob_bytes_remaining < amount) then
1686: amount := lob_bytes_remaining;
1687: end if;
1688: dbms_lob.read(lob_rec.file_content, amount, position, buffer);
1689: htp.prn(utl_raw.cast_to_varchar2(buffer));
1690: position := position + amount;
1691: lob_bytes_remaining := lob_bytes_remaining - amount;
1692: end loop;

Line 1693: dbms_lob.close(lob_rec.file_content);

1689: htp.prn(utl_raw.cast_to_varchar2(buffer));
1690: position := position + amount;
1691: lob_bytes_remaining := lob_bytes_remaining - amount;
1692: end loop;
1693: dbms_lob.close(lob_rec.file_content);
1694: end loop;
1695: end show_file;
1696:
1697: