APPS.FND_ATTACHED_DOCUMENTS3_PKG SQL Statements

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

Line: 17

       SELECT COUNT(1) INTO DUMMY
	 FROM fnd_attached_documents
	  WHERE seq_num = X_seq_num
   	    AND entity_name = X_entity_name
	    AND pk1_value = X_pkey1
	    AND pk2_value = X_pkey2
	    AND pk3_value = X_pkey3
	    AND (X_pkey4 IS NULL
		 OR pk4_value = X_pkey4)
	    AND (X_pkey5 IS NULL
		 OR pk5_value = X_pkey5)
	    AND ( (X_rowid IS NULL) OR (rowid <> X_rowid) );

Line: 32

       SELECT COUNT(1) INTO DUMMY
	 FROM fnd_attached_documents
	  WHERE seq_num = X_seq_num
   	    AND entity_name = X_entity_name
	    AND pk1_value = X_pkey1
	    AND pk2_value = X_pkey2
	    AND pk3_value IS NULL
	    AND (X_pkey4 IS NULL
		 OR pk4_value = X_pkey4)
	    AND (X_pkey5 IS NULL
		 OR pk5_value = X_pkey5)
	    AND ( (X_rowid IS NULL) OR (rowid <> X_rowid) );

Line: 46

	SELECT COUNT(1) INTO DUMMY
	 FROM fnd_attached_documents
	  WHERE seq_num = X_seq_num
   	    AND entity_name = X_entity_name
	    AND pk1_value = X_pkey1
	    AND (X_pkey2 IS NULL)
	    AND (X_pkey3 IS NULL)
	    AND (X_pkey4 IS NULL
		 OR pk4_value = X_pkey4)
	    AND (X_pkey5 IS NULL
		 OR pk5_value = X_pkey5)
	    AND ( (X_rowid IS NULL) OR (rowid <> X_rowid) );

Line: 74

  SELECT count(*)
    INTO reference_count
    FROM fnd_attached_documents
   WHERE document_id = X_document_id;

Line: 87

PROCEDURE delete_row (X_attached_document_id NUMBER,
		      X_datatype_id NUMBER,
		      delete_document_flag VARCHAR2 DEFAULT 'N' ) IS

 X_document_id NUMBER;

Line: 96

  IF (delete_document_flag = 'Y') THEN
	-- Get the document_id from fnd_attached_documents.

	SELECT document_id
	INTO   X_document_id
	FROM fnd_attached_documents
	WHERE attached_document_id = X_attached_document_id;

Line: 108

  DELETE FROM fnd_attached_documents
   WHERE attached_document_id = X_attached_document_id;

Line: 112

  IF (delete_document_flag = 'Y') THEN

	-- Delete the document
        IF (X_document_id > 0) THEN
		fnd_documents_pkg.delete_row (X_document_id,
					      X_datatype_id,
					      'N');

Line: 121

  END IF; /* Delete Document */

Line: 123

END delete_row ;