APPS.CSFW_SIGNATURE_PVT SQL Statements

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

Line: 10

UPDATE NOTES
| Date          Developer           Change
|------         ---------------     --------------------------------------
08-06-2003	MMERCHAN	 Created


--End of Comments
*/


/*
Procedure to insert signature, name and date to Server
p_description is composed of --l_signed_date||' '||l_signed_by,
*/

PROCEDURE UPLOAD_SIGNATURE
		(p_debrief_header_id	NUMBER,
		 p_task_assignment_id NUMBER,
		 p_description VARCHAR2,
		 p_file_data BLOB,
		 p_error_msg     OUT NOCOPY    VARCHAR2,
           	 x_return_status IN OUT NOCOPY VARCHAR2
		) IS

 l_seq_num number;

Line: 50

  SELECT  nvl(max(fad.seq_num),0)+10
    FROM  fnd_attached_documents fad,
          fnd_documents fd
   WHERE  fad.pk1_value = to_char(x_debrief_header_id)
   AND    fd.document_id = fad.document_id
   AND EXISTS
         (SELECT 1
          FROM fnd_document_categories_tl cat_tl
          WHERE cat_tl.category_id = fd.category_id
          AND cat_tl.user_name = 'Signature'
          );

Line: 65

  SELECT category_id
  FROM  fnd_document_categories_tl
  WHERE user_name = 'Signature';

Line: 72

  select fnd_lobs_s.nextval
  from dual;

Line: 78

  select userenv('LANG')
  from dual;

Line: 83

 select 1
 from fnd_lobs
 where file_id = p_file_id;

Line: 87

RECORD_NOT_INSERTED EXCEPTION;

Line: 115

      INSERT INTO fnd_lobs(file_id, file_name, file_content_type,  file_data, upload_date, language, file_format)
      VALUES (l_fnd_lobs_id, 'INTERNAL', 'image/bmp', empty_blob(), SYSDATE, l_language, 'binary')
      RETURN file_data into l_signature_loc;

Line: 134

	          raise RECORD_NOT_INSERTED;

Line: 167

WHEN RECORD_NOT_INSERTED THEN
          x_return_status := FND_API.G_RET_STS_ERROR;

Line: 169

	  p_error_msg := 'Record not inserted';