APPS.BIS_SAVE_REPORT dependencies on DBMS_LOB

Line 57: length := dbms_lob.getLength(loc);

53: from fnd_lobs
54: where file_id = initWrite.file_id
55: for update of file_data;
56:
57: length := dbms_lob.getLength(loc);
58: if length > 0 then
59: dbms_lob.trim(loc, offset);
60: end if;
61: --dbms_lob.write(loc, amount, offset, convert(buffer,ocs));

Line 59: dbms_lob.trim(loc, offset);

55: for update of file_data;
56:
57: length := dbms_lob.getLength(loc);
58: if length > 0 then
59: dbms_lob.trim(loc, offset);
60: end if;
61: --dbms_lob.write(loc, amount, offset, convert(buffer,ocs));
62: dbms_lob.write(loc, amount, offset, buffer);
63: commit;

Line 61: --dbms_lob.write(loc, amount, offset, convert(buffer,ocs));

57: length := dbms_lob.getLength(loc);
58: if length > 0 then
59: dbms_lob.trim(loc, offset);
60: end if;
61: --dbms_lob.write(loc, amount, offset, convert(buffer,ocs));
62: dbms_lob.write(loc, amount, offset, buffer);
63: commit;
64: end initWrite;
65:

Line 62: dbms_lob.write(loc, amount, offset, buffer);

58: if length > 0 then
59: dbms_lob.trim(loc, offset);
60: end if;
61: --dbms_lob.write(loc, amount, offset, convert(buffer,ocs));
62: dbms_lob.write(loc, amount, offset, buffer);
63: commit;
64: end initWrite;
65:
66: procedure appendWrite (file_id number, buffer varchar2) is

Line 85: --dbms_lob.writeappend(loc, amount, convert(buffer,ocs));

81: from fnd_lobs
82: where file_id = appendWrite.file_id
83: for update of file_data;
84:
85: --dbms_lob.writeappend(loc, amount, convert(buffer,ocs));
86: -- Fix for bug 3336412
87: if lengthb(buffer) > 0 then
88: dbms_lob.writeappend(loc, amount, buffer);
89: commit;

Line 88: dbms_lob.writeappend(loc, amount, buffer);

84:
85: --dbms_lob.writeappend(loc, amount, convert(buffer,ocs));
86: -- Fix for bug 3336412
87: if lengthb(buffer) > 0 then
88: dbms_lob.writeappend(loc, amount, buffer);
89: commit;
90: end if ;
91: end appendWrite;
92: