DBA Data[Home] [Help]

APPS.CSFW_SIGNATURE_PVT dependencies on DBMS_LOB

Line 119: l_signature_size := dbms_lob.getLength(p_file_data);

115: INSERT INTO fnd_lobs(file_id, file_name, file_content_type, file_data, upload_date, language, file_format)
116: VALUES (l_fnd_lobs_id, 'INTERNAL', 'image/bmp', empty_blob(), SYSDATE, l_language, 'binary')
117: RETURN file_data into l_signature_loc;
118:
119: l_signature_size := dbms_lob.getLength(p_file_data);
120: dbms_lob.read(p_file_data, l_signature_size, 1, l_signature_raw);
121:
122: dbms_lob.write(l_signature_loc, l_signature_size, 1, l_signature_raw);
123:

Line 120: dbms_lob.read(p_file_data, l_signature_size, 1, l_signature_raw);

116: VALUES (l_fnd_lobs_id, 'INTERNAL', 'image/bmp', empty_blob(), SYSDATE, l_language, 'binary')
117: RETURN file_data into l_signature_loc;
118:
119: l_signature_size := dbms_lob.getLength(p_file_data);
120: dbms_lob.read(p_file_data, l_signature_size, 1, l_signature_raw);
121:
122: dbms_lob.write(l_signature_loc, l_signature_size, 1, l_signature_raw);
123:
124: EXCEPTION

Line 122: dbms_lob.write(l_signature_loc, l_signature_size, 1, l_signature_raw);

118:
119: l_signature_size := dbms_lob.getLength(p_file_data);
120: dbms_lob.read(p_file_data, l_signature_size, 1, l_signature_raw);
121:
122: dbms_lob.write(l_signature_loc, l_signature_size, 1, l_signature_raw);
123:
124: EXCEPTION
125: WHEN OTHERS THEN
126: -- check if the record exists