APPS.DOM_ATTACHMENT_UTIL_PKG SQL Statements

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

Line: 20

 update dom_file_ext
 set status =p_status
 where repository_id=p_repository_id
 and version_id=p_version_id;

Line: 25

   insert into dom_file_ext
   (
     repository_id
     ,version_id
     ,status
   )
   values
   (
     p_repository_id
     ,p_version_id
     ,p_status
   );

Line: 53

  , p_last_update_login        IN Number DEFAULT NULL
  , x_Attached_document_id     OUT NOCOPY Number
)
IS


l_document_id         number;

Line: 69

l_last_update_login   NUMBER;

Line: 80

  select fnd_attached_documents_s.nextval
    into l_attached_document_id from dual;

Line: 83

  fnd_attached_documents_pkg.Insert_Row(
           X_Rowid                      => l_row_id,
           X_attached_document_id       => l_Attached_document_id,
           X_document_id                => l_document_id,
           X_creation_date              => sysdate,
           X_created_by                 => p_created_by,
           X_last_update_date           => sysdate,
           X_last_updated_by            => p_created_by,
           X_last_update_login          => p_last_update_login,
           X_seq_num                    => 1,
           X_entity_name                => p_entity_name,
           X_column1                    => null,
           X_pk1_value                  => p_pk1_value,
           X_pk2_value                  => p_pk2_value,
           X_pk3_value                  => p_pk3_value,
           X_pk4_value                  => p_pk4_value,
           X_pk5_value                  => p_pk5_value,
           X_automatically_added_flag   => 'N',
           X_datatype_id                => null,
           X_category_id                => p_category_id,
           X_security_type              => null,
           X_publish_flag               => null,
           X_usage_type                 => null,
           X_language                   => null,
           X_media_id                   => l_media_id,
           X_doc_attribute_Category     => null,
           X_doc_attribute1             => null,
           X_doc_attribute2             => null,
           X_doc_attribute3             => null,
           X_doc_attribute4             => null,
           X_doc_attribute5             => null,
           X_doc_attribute6             => null,
           X_doc_attribute7             => null,
           X_doc_attribute8             => null,
           X_doc_attribute9             => null,
           X_doc_attribute10            => null,
           X_doc_attribute11            => null,
           X_doc_attribute12            => null,
           X_doc_attribute13            => null,
           X_doc_attribute14            => null,
           X_doc_attribute15            => null,
           X_create_doc                 => 'N' -- Fix for 3762710
         );

Line: 145

  , p_last_update_login        IN NUMBER DEFAULT NULL
  , x_Attached_document_id     OUT NOCOPY NUMBER
)
IS


l_document_id         number;

Line: 161

l_last_update_login   NUMBER;

Line: 174

  select fnd_attached_documents_s.nextval
    into l_attached_document_id from dual;

Line: 179

	SELECT fnd_documents_s.nextval
	INTO l_document_id
	FROM dual;

Line: 186

	INSERT INTO fnd_documents(
	 document_id,
	 creation_date,
	 created_by,
	 last_update_date,
	 last_updated_by,
	 last_update_login,
	 datatype_id,
	 category_id,
	 security_type,
	 publish_flag,
	 usage_type,
         media_id,
	 dm_document_id,
         file_name,
	 dm_node,
	 dm_type)
	VALUES (
	 l_document_id,
	 sysdate,
	 p_created_by,
	 sysdate,
	 p_created_by,
	 p_last_update_login,
	 8,
	 l_category_id,
	 4,
	 'Y',
	 0,
         p_family_id,
	 p_version_id,
	 p_file_name,
	 p_repository_id,
	 'FILE');

Line: 221

	 SELECT userenv('LANG') INTO l_language FROM dual;

Line: 223

	 fnd_documents_pkg.insert_tl_row(
		 X_document_id => l_document_id,
		 X_creation_date     => sysdate,
		 X_created_by        => p_created_by,
		 X_last_update_date  => sysdate,
		 X_last_updated_by   => p_created_by,
		 X_last_update_login => p_last_update_login,
		 X_language          => l_language
	 );

Line: 235

	 INSERT INTO fnd_documents
		(document_id,
		creation_date,
		created_by,
		last_update_date,
		last_updated_by,
		last_update_login,
		datatype_id,
		category_id,
		security_type,
		publish_flag,
		usage_type,
		media_id,
		dm_document_id,
		file_name,
		dm_node,
		dm_type)
        SELECT
		fnd_documents_s.NEXTVAL,
		creation_date,
		created_by,
		last_update_date,
		last_updated_by,
		last_update_login,
		datatype_id,
		category_id,
		security_type,
		publish_flag,
		usage_type,
		media_id,
		decode(dm_document_id,0,p_version_id,dm_document_id),
		file_name,
		dm_node,
		dm_type
        FROM fnd_documents x
        WHERE x.document_id = l_document_id;

Line: 272

	select media_id, category_id, userenv('LANG') into l_media_id, l_category_id, l_language from fnd_documents where document_id = l_document_id;

Line: 274

	select fnd_documents_s.CURRVAL into l_document_id from dual;

Line: 276

	fnd_documents_pkg.insert_tl_row(
		 X_document_id => l_document_id,
		 X_creation_date     => sysdate,
		 X_created_by        => p_created_by,
		 X_last_update_date  => sysdate,
		 X_last_updated_by   => p_created_by,
		 X_last_update_login => p_last_update_login,
		 X_language          => l_language
	 );

Line: 291

  fnd_attached_documents_pkg.Insert_Row(
     X_Rowid                      => l_row_id,
     X_attached_document_id       => l_Attached_document_id,
     X_document_id                => l_document_id,
     X_creation_date              => sysdate,
     X_created_by                 => p_created_by,
     X_last_update_date           => sysdate,
     X_last_updated_by            => p_created_by,
     X_last_update_login          => p_last_update_login,
     X_seq_num                    => 1,
     X_entity_name                => p_entity_name,
     X_column1                    => null,
     X_pk1_value                  => p_pk1_value,
     X_pk2_value                  => p_pk2_value,
     X_pk3_value                  => p_pk3_value,
     X_pk4_value                  => p_pk4_value,
     X_pk5_value                  => p_pk5_value,
     X_automatically_added_flag   => 'N',
     X_datatype_id                => null,
     X_category_id                => l_category_id,
     X_security_type              => null,
     X_publish_flag               => null,
     X_usage_type                 => null,
     X_language                   => null,
     X_media_id                   => l_media_id,
     X_doc_attribute_Category     => null,
     X_doc_attribute1             => null,
     X_doc_attribute2             => null,
     X_doc_attribute3             => null,
     X_doc_attribute4             => null,
     X_doc_attribute5             => null,
     X_doc_attribute6             => null,
     X_doc_attribute7             => null,
     X_doc_attribute8             => null,
     X_doc_attribute9             => null,
     X_doc_attribute10            => null,
     X_doc_attribute11            => null,
     X_doc_attribute12            => null,
     X_doc_attribute13            => null,
     X_doc_attribute14            => null,
     X_doc_attribute15            => null,
     X_create_doc                 => 'N' -- Fix for 3762710
   );

Line: 335

   UPDATE fnd_attached_documents set category_id = l_category_id where attached_document_id = l_Attached_document_id;

Line: 348

  select att.document_id,docs.datatype_id
    from fnd_attached_documents att,
    fnd_documents docs
    where Attached_document_id=p_Attached_document_id
    and docs.document_id=att.document_id;

Line: 357

SELECT attached_document_id
    FROM fnd_attached_documents
    where document_id=cp_document_id;

Line: 372

   delete fnd_attached_documents
   where attached_document_id = p_Attached_document_id;

Line: 379

     fnd_documents_pkg.Delete_Row(
        X_document_id   =>l_document_id,
        X_datatype_id   =>l_datatype_id,
        delete_ref_Flag => 'Y');

Line: 392

Procedure Update_Document(
     p_Attached_document_id     IN Number
    , p_FileName                IN Varchar2
    , p_Description             IN Varchar2 DEFAULT NULL
    , p_Category                IN Number
    , p_last_updated_by         IN Number
    , p_last_update_login       IN Number DEFAULT NULL
)
IS

  cursor get_document_id(cp_Attached_document_id number)
  is
  select document_id
    from fnd_attached_documents
    where Attached_document_id=p_Attached_document_id;

Line: 418

  update fnd_documents_tl
  set  Description = p_Description
      ,last_updated_by = p_last_updated_by
      ,last_update_login =p_last_update_login
  where document_id= l_document_id
  and language=userenv('LANG');

Line: 425

  update fnd_documents
  set File_Name = p_FileName
     ,Category_id= p_Category
      ,last_updated_by = p_last_updated_by
      ,last_update_login =p_last_update_login
  where document_id= l_document_id;

Line: 432

  update fnd_attached_documents
  set Category_id= p_Category
    ,last_updated_by = p_last_updated_by
    ,last_update_login =p_last_update_login
  where Attached_document_id=p_Attached_document_id;

Line: 438

END Update_Document;

Line: 446

   , p_last_updated_by           IN Number
   , p_last_update_login         IN Number DEFAULT NULL
)

IS

BEGIN
  UPDATE fnd_attached_documents
	   SET document_id = p_Document_id,
	   last_update_date = sysdate,
	   last_updated_by = p_last_updated_by,
	   last_update_login = p_last_update_login
	   WHERE attached_document_id = p_Attached_document_id;

Line: 470

   , p_last_updated_by           IN Number
   , p_last_update_login         IN Number DEFAULT NULL
)
IS

l_service_url   		VARCHAR2(255);

Line: 485

select service_url
from dom_repositories
where id=cp_Repository_id;

Line: 491

select user_name
from fnd_user
where user_id=cp_user_id;

Line: 497

select att.attached_document_id
from fnd_attached_documents att,
fnd_documents docs
where docs.document_id=att.document_id
and docs.dm_document_id=cp_dm_document_id;

Line: 505

SELECT n.protocol
from dom_repositories n
where n.id=cp_Repository_id;

Line: 533

	  DOM_WS_INTERFACE_PUB.Update_Files_Document_Status
	  (
	    p_api_version	      => 1.0,
      p_service_url       => l_service_url,
      p_document_id      	=> p_Document_id,
      p_status           	=> p_Status,
      p_login_user_name   => l_user_name,
      x_return_status	    => l_return_status,
      x_msg_count		      => l_msg_count,
      x_msg_data		      => l_msg_data
	  );

Line: 546

	  --Update status for all the attached documents for the WS document.
	  FOR rec in get_affected_attachments(p_Document_id) LOOP
	    --dbms_output.put_line('Updating attachment id= '||rec.attached_document_id);

Line: 549

	    UPDATE fnd_attached_documents
	    SET status = p_Status,
	    last_update_date = sysdate,
	    last_updated_by = p_submitted_by,
	    last_update_login = p_last_update_login
	    WHERE attached_document_id = rec.attached_document_id;

Line: 560

    UPDATE fnd_attached_documents
    SET status = p_Status,
    last_update_date = sysdate,
    last_updated_by = p_submitted_by,
    last_update_login = p_last_update_login
    WHERE attached_document_id = p_Attached_document_id;

Line: 586

   select media_id,datatype_id
   from fnd_documents_vl
   where document_id=cp_document_id;

Line: 605

	    SELECT  repos.dav_url,
	    docs.dm_folder_path||'/'||docs.file_name
	    INTO l_host_url,l_document_path
	    FROM fnd_documents_vl docs,
	    dom_repositories repos
	    where repos.id=docs.dm_node
	    and docs.document_id=p_document_id;

Line: 626

PROCEDURE delete_attachments(X_entity_name IN VARCHAR2,
		X_pk1_value IN VARCHAR2,
		X_pk2_value IN VARCHAR2 DEFAULT NULL,
		X_pk3_value IN VARCHAR2 DEFAULT NULL,
		X_pk4_value IN VARCHAR2 DEFAULT NULL,
		X_pk5_value IN VARCHAR2 DEFAULT NULL,
		X_delete_document_flag IN VARCHAR2,
		X_automatically_added_flag IN VARCHAR2 DEFAULT NULL) IS
l_delete_document_flag varchar2(1);

Line: 636

fnd_attached_documents2_pkg.delete_attachments(X_entity_name,
		X_pk1_value,
		X_pk2_value,
		X_pk3_value,
		X_pk4_value,
		X_pk5_value,
		X_delete_document_flag,
		X_automatically_added_flag);

Line: 645

END delete_attachments;

Line: 652

			X_last_update_login IN NUMBER DEFAULT NULL,
			X_program_application_id IN NUMBER DEFAULT NULL,
			X_program_id IN NUMBER DEFAULT NULL,
			X_request_id IN NUMBER DEFAULT NULL,
			X_automatically_added_flag IN VARCHAR2 DEFAULT NULL,
			X_from_category_id IN NUMBER DEFAULT NULL,
			X_to_category_id IN NUMBER DEFAULT NULL) IS
  l_delete_document_flag varchar2(1);

Line: 661

	SELECT fad.seq_num, fad.document_id,
		fad.attribute_category, fad.attribute1, fad.attribute2,
		fad.attribute3, fad.attribute4, fad.attribute5,
		fad.attribute6, fad.attribute7, fad.attribute8,
		fad.attribute9, fad.attribute10, fad.attribute11,
		fad.attribute12, fad.attribute13, fad.attribute14,
		fad.attribute15, fad.column1, fad.automatically_added_flag,
		fad.category_id att_cat, fad.pk2_value, fad.pk3_value,
                fad.pk4_value, fad.pk5_value,
		fd.datatype_id, fd.category_id, fd.security_type, fd.security_id,
		fd.publish_flag, fd.image_type, fd.storage_type,
		fd.usage_type, fd.start_date_active, fd.end_date_active,
		fdtl.language, fdtl.description, fd.file_name,
		fd.media_id, fdtl.doc_attribute_category dattr_cat,
		fdtl.doc_attribute1 dattr1, fdtl.doc_attribute2 dattr2,
		fdtl.doc_attribute3 dattr3, fdtl.doc_attribute4 dattr4,
		fdtl.doc_attribute5 dattr5, fdtl.doc_attribute6 dattr6,
		fdtl.doc_attribute7 dattr7, fdtl.doc_attribute8 dattr8,
		fdtl.doc_attribute9 dattr9, fdtl.doc_attribute10 dattr10,
		fdtl.doc_attribute11 dattr11, fdtl.doc_attribute12 dattr12,
		fdtl.doc_attribute13 dattr13, fdtl.doc_attribute14 dattr14,
		fdtl.doc_attribute15 dattr15, fd.url, fdtl.title  ,
    FD.DM_NODE fd_dm_node,
        fd.DM_FOLDER_PATH fd_DM_FOLDER_PATH,
        fd.DM_TYPE fd_DM_TYPE,
        fd.DM_DOCUMENT_ID fd_DM_DOCUMENT_ID,
        fd.DM_VERSION_NUMBER fd_DM_VERSION_NUMBER,
        fd.URL fd_URL,
        fd.MEDIA_ID fd_MEDIA_ID
	  FROM 	fnd_attached_documents fad,
		fnd_documents fd,
		fnd_documents_tl fdtl
	  WHERE	fad.document_id = fd.document_id
	    AND fd.document_id = fdtl.document_id
	    AND fdtl.language  = userenv('LANG')
	    AND fd.document_id = X_from_document_id  ;

Line: 699

	SELECT short_text
	  FROM fnd_documents_short_text
	 WHERE media_id = mid;

Line: 704

	SELECT long_text
	  FROM fnd_documents_long_text
	 WHERE media_id = mid;

Line: 709

        SELECT file_id,
               file_name,
               file_content_type,
               upload_date,
               expiration_date,
               program_name,
               program_tag,
               file_data,
               language,
               oracle_charset,
               file_format
        FROM fnd_lobs
        WHERE file_id = mid;

Line: 745

			FND_DOCUMENTS_PKG.Insert_Row(row_id_tmp,
		                document_id_tmp,
				SYSDATE,
				NVL(X_created_by,0),
				SYSDATE,
				NVL(X_created_by,0),
				X_last_update_login,
				docrec.datatype_id,
				NVL(X_to_category_id, docrec.category_id),
				docrec.security_type,
				docrec.security_id,
				docrec.publish_flag,
				docrec.image_type,
				docrec.storage_type,
				docrec.usage_type,
				docrec.start_date_active,
				docrec.end_date_active,
				X_request_id,
				X_program_application_id,
				X_program_id,
				SYSDATE,
				docrec.language,
				docrec.description,
				docrec.file_name,
				media_id_tmp,
				docrec.dattr_cat, docrec.dattr1,
				docrec.dattr2, docrec.dattr3,
				docrec.dattr4, docrec.dattr5,
				docrec.dattr6, docrec.dattr7,
				docrec.dattr8, docrec.dattr9,
				docrec.dattr10, docrec.dattr11,
				docrec.dattr12, docrec.dattr13,
				docrec.dattr14, docrec.dattr15,
                                'N',docrec.url, docrec.title);

Line: 781

			--  cursor for later insert into
			--  fnd_attached_documents

			docrec.document_id := document_id_tmp;

Line: 788

      UPDATE fnd_documents
      SET
        DM_NODE = docrec.fd_dm_node,
         DM_FOLDER_PATH =docrec.fd_dm_folder_path,
         DM_TYPE = docrec.fd_dm_type,
         DM_DOCUMENT_ID = docrec.fd_dm_document_id,
         DM_VERSION_NUMBER = docrec.fd_dm_version_number,
         URL = docrec.fd_url,
         MEDIA_ID = docrec.fd_media_id
      WHERE
      document_id = document_id_tmp;

Line: 799

      END IF;     --end of update the document row for ws/webdav attachments

Line: 810

				INSERT INTO fnd_documents_short_text (
					media_id,
					short_text)
				 VALUES (
					media_id_tmp,
					short_text_tmp);

Line: 825

				INSERT INTO fnd_documents_long_text (
					media_id,
					long_text)
				 VALUES (
					media_id_tmp,
					long_text_tmp);

Line: 850

             INSERT INTO fnd_lobs (
                                 file_id,
                                 file_name,
                                 file_content_type,
                                 upload_date,
                                 expiration_date,
                                 program_name,
                                 program_tag,
                                 file_data,
                                 language,
                                 oracle_charset,
                                 file_format)
               VALUES  (
                       media_id_tmp,
                       fnd_lobs_rec.file_name,
                       fnd_lobs_rec.file_content_type,
                       fnd_lobs_rec.upload_date,
                       fnd_lobs_rec.expiration_date,
                       fnd_lobs_rec.program_name,
                       fnd_lobs_rec.program_tag,
                       fnd_lobs_rec.file_data,
                       fnd_lobs_rec.language,
                       fnd_lobs_rec.oracle_charset,
                       fnd_lobs_rec.file_format);

Line: 882

	--  Update the document to be a std document if it
	--  was an ole or image that wasn't already a std doc
	--  (images should be created as Std, but just in case)
		IF (docrec.datatype_id IN (3,4)
		    AND docrec.usage_type <> 'S') THEN
			UPDATE fnd_documents
			   SET usage_type = 'S'
			WHERE document_id = docrec.document_id;

Line: 924

			X_last_update_login IN NUMBER DEFAULT NULL,
			X_program_application_id IN NUMBER DEFAULT NULL,
			X_program_id IN NUMBER DEFAULT NULL,
			X_request_id IN NUMBER DEFAULT NULL,
			X_automatically_added_flag IN VARCHAR2 DEFAULT NULL,
			X_from_category_id IN NUMBER DEFAULT NULL,
			X_to_category_id IN NUMBER DEFAULT NULL) IS

  CURSOR docpk1 IS
	SELECT fad.seq_num, fad.document_id,
		fad.attribute_category, fad.attribute1, fad.attribute2,
		fad.attribute3, fad.attribute4, fad.attribute5,
		fad.attribute6, fad.attribute7, fad.attribute8,
		fad.attribute9, fad.attribute10, fad.attribute11,
		fad.attribute12, fad.attribute13, fad.attribute14,
		fad.attribute15, fad.column1, fad.automatically_added_flag,
		fad.category_id att_cat, fad.pk2_value, fad.pk3_value,
                fad.pk4_value, fad.pk5_value,
		fd.datatype_id, fd.category_id, fd.security_type, fd.security_id,
		fd.publish_flag, fd.image_type, fd.storage_type,
		fd.usage_type, fd.start_date_active, fd.end_date_active,
		fdtl.language, fdtl.description, fd.file_name,
		fd.media_id, fdtl.doc_attribute_category dattr_cat,
		fdtl.doc_attribute1 dattr1, fdtl.doc_attribute2 dattr2,
		fdtl.doc_attribute3 dattr3, fdtl.doc_attribute4 dattr4,
		fdtl.doc_attribute5 dattr5, fdtl.doc_attribute6 dattr6,
		fdtl.doc_attribute7 dattr7, fdtl.doc_attribute8 dattr8,
		fdtl.doc_attribute9 dattr9, fdtl.doc_attribute10 dattr10,
		fdtl.doc_attribute11 dattr11, fdtl.doc_attribute12 dattr12,
		fdtl.doc_attribute13 dattr13, fdtl.doc_attribute14 dattr14,
		fdtl.doc_attribute15 dattr15, fd.url, fdtl.title,
 FD.DM_NODE fd_dm_node,
        fd.DM_FOLDER_PATH fd_DM_FOLDER_PATH,
        fd.DM_TYPE fd_DM_TYPE,
        fd.DM_DOCUMENT_ID fd_DM_DOCUMENT_ID,
        fd.DM_VERSION_NUMBER fd_DM_VERSION_NUMBER,
        fd.URL fd_URL,
        fd.MEDIA_ID fd_MEDIA_ID

	  FROM 	fnd_attached_documents fad,
		fnd_documents fd,
		fnd_documents_tl fdtl
	  WHERE	fd.document_id = fad.document_id
	    AND fdtl.document_id = fd.document_id
      AND fdtl.language  = userenv('LANG')
	    AND fad.entity_name = X_from_entity_name
	    AND fad.pk1_value = X_from_pk1_value
	    AND (X_from_category_id IS NULL
		 OR (fad.category_id = X_from_category_id
		 OR (fad.category_id is NULL AND fd.category_id = X_from_category_id)))
	    AND fad.automatically_added_flag like decode(X_automatically_added_flag,NULL,'%',X_automatically_added_flag)
     AND (X_from_attachment_id IS NULL OR fad.attached_document_id = X_from_attachment_id);

Line: 979

	SELECT fad.seq_num, fad.document_id,
		fad.attribute_category, fad.attribute1, fad.attribute2,
		fad.attribute3, fad.attribute4, fad.attribute5,
		fad.attribute6, fad.attribute7, fad.attribute8,
		fad.attribute9, fad.attribute10, fad.attribute11,
		fad.attribute12, fad.attribute13, fad.attribute14,
		fad.attribute15, fad.column1, fad.automatically_added_flag,
		fad.category_id att_cat, fad.pk2_value, fad.pk3_value,
                fad.pk4_value, fad.pk5_value,
		fd.datatype_id, fd.category_id, fd.security_type, fd.security_id,
		fd.publish_flag, fd.image_type, fd.storage_type,
		fd.usage_type, fd.start_date_active, fd.end_date_active,
		fdtl.language, fdtl.description, fd.file_name,
		fd.media_id, fdtl.doc_attribute_category dattr_cat,
		fdtl.doc_attribute1 dattr1, fdtl.doc_attribute2 dattr2,
		fdtl.doc_attribute3 dattr3, fdtl.doc_attribute4 dattr4,
		fdtl.doc_attribute5 dattr5, fdtl.doc_attribute6 dattr6,
		fdtl.doc_attribute7 dattr7, fdtl.doc_attribute8 dattr8,
		fdtl.doc_attribute9 dattr9, fdtl.doc_attribute10 dattr10,
		fdtl.doc_attribute11 dattr11, fdtl.doc_attribute12 dattr12,
		fdtl.doc_attribute13 dattr13, fdtl.doc_attribute14 dattr14,
		fdtl.doc_attribute15 dattr15, fd.url, fdtl.title,
    FD.DM_NODE fd_dm_node,
        fd.DM_FOLDER_PATH fd_DM_FOLDER_PATH,
        fd.DM_TYPE fd_DM_TYPE,
        fd.DM_DOCUMENT_ID fd_DM_DOCUMENT_ID,
        fd.DM_VERSION_NUMBER fd_DM_VERSION_NUMBER,
        fd.URL fd_URL,
        fd.MEDIA_ID fd_MEDIA_ID
	  FROM 	fnd_attached_documents fad,
		fnd_documents fd,
		fnd_documents_tl fdtl
	  WHERE	fd.document_id = fad.document_id
	    AND fdtl.document_id = fd.document_id
      AND fdtl.language  = userenv('LANG')
	    AND fad.entity_name = X_from_entity_name
	    AND fad.pk1_value = X_from_pk1_value
	    AND fad.pk2_value = X_from_pk2_value
	    AND (X_from_category_id IS NULL
		 OR (fad.category_id = X_from_category_id
		 OR (fad.category_id is NULL AND fd.category_id = X_from_category_id)))
	    AND fad.automatically_added_flag like decode(X_automatically_added_flag,NULL,'%',X_automatically_added_flag)
     AND (X_from_attachment_id IS NULL OR fad.attached_document_id = X_from_attachment_id);

Line: 1028

	SELECT fad.seq_num, fad.document_id,
		fad.attribute_category, fad.attribute1, fad.attribute2,
		fad.attribute3, fad.attribute4, fad.attribute5,
		fad.attribute6, fad.attribute7, fad.attribute8,
		fad.attribute9, fad.attribute10, fad.attribute11,
		fad.attribute12, fad.attribute13, fad.attribute14,
		fad.attribute15, fad.column1, fad.automatically_added_flag,
		fad.category_id att_cat, fad.pk2_value, fad.pk3_value,
                fad.pk4_value, fad.pk5_value,
		fd.datatype_id, fd.category_id, fd.security_type, fd.security_id,
		fd.publish_flag, fd.image_type, fd.storage_type,
		fd.usage_type, fd.start_date_active, fd.end_date_active,
		fdtl.language, fdtl.description, fd.file_name,
		fd.media_id, fdtl.doc_attribute_category dattr_cat,
		fdtl.doc_attribute1 dattr1, fdtl.doc_attribute2 dattr2,
		fdtl.doc_attribute3 dattr3, fdtl.doc_attribute4 dattr4,
		fdtl.doc_attribute5 dattr5, fdtl.doc_attribute6 dattr6,
		fdtl.doc_attribute7 dattr7, fdtl.doc_attribute8 dattr8,
		fdtl.doc_attribute9 dattr9, fdtl.doc_attribute10 dattr10,
		fdtl.doc_attribute11 dattr11, fdtl.doc_attribute12 dattr12,
		fdtl.doc_attribute13 dattr13, fdtl.doc_attribute14 dattr14,
		fdtl.doc_attribute15 dattr15, fd.url, fdtl.title ,
    FD.DM_NODE fd_dm_node,
        fd.DM_FOLDER_PATH fd_DM_FOLDER_PATH,
        fd.DM_TYPE fd_DM_TYPE,
        fd.DM_DOCUMENT_ID fd_DM_DOCUMENT_ID,
        fd.DM_VERSION_NUMBER fd_DM_VERSION_NUMBER,
        fd.URL fd_URL,
        fd.MEDIA_ID fd_MEDIA_ID
	  FROM 	fnd_attached_documents fad,
		fnd_documents fd,
		fnd_documents_tl fdtl
	  WHERE	fd.document_id = fad.document_id
	    AND fdtl.document_id = fd.document_id
	    AND fdtl.language  = userenv('LANG')
	    AND fad.entity_name = X_from_entity_name
	    AND fad.pk1_value = X_from_pk1_value
	    AND fad.pk2_value = X_from_pk2_value
            AND fad.pk3_value = X_from_pk3_value
--	    AND (X_from_category_id IS NULL
--		 OR (fad.category_id = X_from_category_id
--		 OR (fad.category_id is NULL AND fd.category_id = X_from_category_id)))
	    AND fad.automatically_added_flag like decode(X_automatically_added_flag,NULL,'%',X_automatically_added_flag)
     AND (X_from_attachment_id IS NULL OR fad.attached_document_id = X_from_attachment_id);

Line: 1078

	SELECT fad.seq_num, fad.document_id,
		fad.attribute_category, fad.attribute1, fad.attribute2,
		fad.attribute3, fad.attribute4, fad.attribute5,
		fad.attribute6, fad.attribute7, fad.attribute8,
		fad.attribute9, fad.attribute10, fad.attribute11,
		fad.attribute12, fad.attribute13, fad.attribute14,
		fad.attribute15, fad.column1, fad.automatically_added_flag,
		fad.category_id att_cat, fad.pk2_value, fad.pk3_value,
                fad.pk4_value, fad.pk5_value,
		fd.datatype_id, fd.category_id, fd.security_type, fd.security_id,
		fd.publish_flag, fd.image_type, fd.storage_type,
		fd.usage_type, fd.start_date_active, fd.end_date_active,
		fdtl.language, fdtl.description, fd.file_name,
		fd.media_id, fdtl.doc_attribute_category dattr_cat,
		fdtl.doc_attribute1 dattr1, fdtl.doc_attribute2 dattr2,
		fdtl.doc_attribute3 dattr3, fdtl.doc_attribute4 dattr4,
		fdtl.doc_attribute5 dattr5, fdtl.doc_attribute6 dattr6,
		fdtl.doc_attribute7 dattr7, fdtl.doc_attribute8 dattr8,
		fdtl.doc_attribute9 dattr9, fdtl.doc_attribute10 dattr10,
		fdtl.doc_attribute11 dattr11, fdtl.doc_attribute12 dattr12,
		fdtl.doc_attribute13 dattr13, fdtl.doc_attribute14 dattr14,
		fdtl.doc_attribute15 dattr15, fd.url, fdtl.title,
    FD.DM_NODE fd_dm_node,
        fd.DM_FOLDER_PATH fd_DM_FOLDER_PATH,
        fd.DM_TYPE fd_DM_TYPE,
        fd.DM_DOCUMENT_ID fd_DM_DOCUMENT_ID,
        fd.DM_VERSION_NUMBER fd_DM_VERSION_NUMBER,
        fd.URL fd_URL,
        fd.MEDIA_ID fd_MEDIA_ID
	  FROM 	fnd_attached_documents fad,
		fnd_documents fd,
		fnd_documents_tl fdtl
	  WHERE		fd.document_id = fad.document_id
	    AND fdtl.document_id = fd.document_id
	    AND fdtl.language  = userenv('LANG')
	    AND fad.entity_name = X_from_entity_name
	    AND fad.pk1_value = X_from_pk1_value
	    AND (X_from_pk2_value IS NULL
		 OR fad.pk2_value = X_from_pk2_value)
	    AND (X_from_pk3_value IS NULL
		 OR fad.pk3_value = X_from_pk3_value)
	    AND (X_from_pk4_value IS NULL
		 OR fad.pk4_value = X_from_pk4_value)
	    AND (X_from_pk5_value IS NULL
		 OR fad.pk5_value = X_from_pk5_value)
	    AND (X_from_category_id IS NULL
		 OR (fad.category_id = X_from_category_id
		 OR (fad.category_id is NULL AND fd.category_id = X_from_category_id)))
	    AND fad.automatically_added_flag like decode(X_automatically_added_flag,NULL,'%',X_automatically_added_flag)
     AND (X_from_attachment_id IS NULL OR fad.attached_document_id = X_from_attachment_id);

Line: 1134

	SELECT short_text
	  FROM fnd_documents_short_text
	 WHERE media_id = mid;

Line: 1139

	SELECT long_text
	  FROM fnd_documents_long_text
	 WHERE media_id = mid;

Line: 1144

        SELECT file_id,
               file_name,
               file_content_type,
               upload_date,
               expiration_date,
               program_name,
               program_tag,
               file_data,
               language,
               oracle_charset,
               file_format
        FROM fnd_lobs
        WHERE file_id = mid;

Line: 1222

			FND_DOCUMENTS_PKG.Insert_Row(row_id_tmp,
		                document_id_tmp,
				SYSDATE,
				NVL(X_created_by,0),
				SYSDATE,
				NVL(X_created_by,0),
				X_last_update_login,
				docrec.datatype_id,
				NVL(X_to_category_id, docrec.category_id),
				docrec.security_type,
				docrec.security_id,
				docrec.publish_flag,
				docrec.image_type,
				docrec.storage_type,
				docrec.usage_type,
				docrec.start_date_active,
				docrec.end_date_active,
				X_request_id,
				X_program_application_id,
				X_program_id,
				SYSDATE,
				docrec.language,
				docrec.description,
				docrec.file_name,
				media_id_tmp,
				docrec.dattr_cat, docrec.dattr1,
				docrec.dattr2, docrec.dattr3,
				docrec.dattr4, docrec.dattr5,
				docrec.dattr6, docrec.dattr7,
				docrec.dattr8, docrec.dattr9,
				docrec.dattr10, docrec.dattr11,
				docrec.dattr12, docrec.dattr13,
				docrec.dattr14, docrec.dattr15,
                                'N',docrec.url, docrec.title);

Line: 1258

			--  cursor for later insert into
			--  fnd_attached_documents

      --update the document row for ws/webdav attachments
      IF(docrec.datatype_id =7 OR docrec.datatype_id =8 OR docrec.datatype_id =9)
      then
      UPDATE fnd_documents
      SET
        DM_NODE = docrec.fd_dm_node,
         DM_FOLDER_PATH =docrec.fd_dm_folder_path,
         DM_TYPE = docrec.fd_dm_type,
         DM_DOCUMENT_ID = docrec.fd_dm_document_id,
         DM_VERSION_NUMBER = docrec.fd_dm_version_number,
         URL = docrec.fd_url,
         MEDIA_ID = docrec.fd_media_id
      WHERE
      document_id = document_id_tmp;

Line: 1275

      END IF;     --end of update the document row for ws/webdav attachments

Line: 1286

				INSERT INTO fnd_documents_short_text (
					media_id,
					short_text)
				 VALUES (
					media_id_tmp,
					short_text_tmp);

Line: 1300

				INSERT INTO fnd_documents_long_text (
					media_id,
					long_text)
				 VALUES (
					media_id_tmp,
					long_text_tmp);

Line: 1323

             INSERT INTO fnd_lobs (
                                 file_id,
                                 file_name,
                                 file_content_type,
                                 upload_date,
                                 expiration_date,
                                 program_name,
                                 program_tag,
                                 file_data,
                                 language,
                                 oracle_charset,
                                 file_format)
               VALUES  (
                       media_id_tmp,
                       fnd_lobs_rec.file_name,
                       fnd_lobs_rec.file_content_type,
                       fnd_lobs_rec.upload_date,
                       fnd_lobs_rec.expiration_date,
                       fnd_lobs_rec.program_name,
                       fnd_lobs_rec.program_tag,
                       fnd_lobs_rec.file_data,
                       fnd_lobs_rec.language,
                       fnd_lobs_rec.oracle_charset,
                       fnd_lobs_rec.file_format);

Line: 1353

    SELECT fnd_attached_documents_s.NEXTVAL
    INTO l_to_attachment_id
    FROM dual;

Line: 1356

		INSERT INTO fnd_attached_documents
		(attached_document_id,
		document_id,
		creation_date,
		created_by,
		last_update_date,
		last_updated_by,
		last_update_login,
		seq_num,
		entity_name,
		pk1_value, pk2_value, pk3_value,
		pk4_value, pk5_value,
		automatically_added_flag,
		program_application_id, program_id,
		program_update_date, request_id,
		attribute_category, attribute1,
		attribute2, attribute3, attribute4,
		attribute5, attribute6, attribute7,
		attribute8, attribute9, attribute10,
		attribute11, attribute12, attribute13,
		attribute14, attribute15, column1, category_id) VALUES
		(l_to_attachment_id,
		docrec.document_id,
		sysdate,
		NVL(X_created_by,0),
		sysdate,
		NVL(X_created_by,0),
		X_last_update_login,
		docrec.seq_num,
		X_to_entity_name,
		X_to_pk1_value,
                X_to_pk2_value,
                X_to_pk3_value,
		X_to_pk4_value,
                X_to_pk5_value,
		docrec.automatically_added_flag,
		X_program_application_id, X_program_id,
		sysdate, X_request_id,
		docrec.attribute_category, docrec.attribute1,
		docrec.attribute2, docrec.attribute3,
		docrec.attribute4, docrec.attribute5,
		docrec.attribute6, docrec.attribute7,
		docrec.attribute8, docrec.attribute9,
		docrec.attribute10, docrec.attribute11,
		docrec.attribute12, docrec.attribute13,
		docrec.attribute14, docrec.attribute15,
		docrec.column1,
		NVL(X_to_category_id, NVL(docrec.att_cat, docrec.category_id)));

Line: 1407

		--  Update the document to be a std document if it
		--  was an ole or image that wasn't already a std doc
		--  (images should be created as Std, but just in case)
		IF (docrec.datatype_id IN (3,4)
		    AND docrec.usage_type <> 'S') THEN
			UPDATE fnd_documents
			   SET usage_type = 'S'
			WHERE document_id = docrec.document_id;

Line: 1458

			X_last_update_login IN NUMBER DEFAULT NULL,
			X_program_application_id IN NUMBER DEFAULT NULL,
			X_program_id IN NUMBER DEFAULT NULL,
			X_request_id IN NUMBER DEFAULT NULL,
			X_automatically_added_flag IN VARCHAR2 DEFAULT NULL,
			X_from_category_id IN NUMBER DEFAULT NULL,
			X_to_category_id IN NUMBER DEFAULT NULL) IS
  l_delete_document_flag varchar2(1);

Line: 1483

			X_last_update_login,
			X_program_application_id,
			X_program_id,
			X_request_id,
			X_automatically_added_flag,
			X_from_category_id,
			X_to_category_id);