APPS.MSD_SSWA dependencies on DBMS_LOB

Line 169: dbms_lob.createtemporary(v_clob,TRUE);

165: v_filename varchar2(4000);
166: v_clob clob;
167:
168: begin
169: dbms_lob.createtemporary(v_clob,TRUE);
170: v_filename := 'MSD' || p_id || '_dpbatch.html';
171: input_file := utl_file.fopen(fnd_profile.value('MSD_DIR_ALIAS'),v_filename, 'R');
172:
173: loop

Line 176: dbms_lob.writeappend(v_clob,length(input_buffer),input_buffer);

172:
173: loop
174: utl_file.get_line(input_file, input_buffer);
175: if (length(input_buffer) > 0) then
176: dbms_lob.writeappend(v_clob,length(input_buffer),input_buffer);
177: --dbms_output.put_line(substr(input_buffer,1,100));
178: end if;
179: end loop;
180: return v_clob;