DBA Data[Home] [Help]

APPS.AMS_ATCH_UPGRADE SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 39

      select fnd_lobs_s.nextval
      from dual;
Line: 56

	 --insert an empty lob into fnd_lobs
	 insert
	 into
	 fnd_lobs
	 (file_id,
	 file_name,
	 file_content_type,
	 file_data,
	 upload_date,
	 file_format,
	 program_name
	 )
	 values
	 (
	 l_LOB_ID,
	 p_file_name,
	 'image/html',
	 empty_blob(),
	 sysdate,
	 'image',
	 'AMS_CONTENT'
	 )
	 returning file_data into Dest_Loc;