APPS.EDR_ATTACHMENTS_GRP SQL Statements

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

Line: 27

			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 doclist 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, fdtl.file_name,
		fdtl.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
	  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 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);

Line: 79

	SELECT short_text
	  FROM fnd_documents_short_text
	 WHERE media_id = mid;

Line: 84

	SELECT long_text
	  FROM fnd_documents_long_text
	 WHERE media_id = mid;

Line: 89

        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: 140

      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),
       --Bug 4381237: Start
       --security is always enforced as 4 and security id as null
       --docrec.security_type,
       4,
       --docrec.security_id,
       NULL,
       --Bug 4381237: End
       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);

Line: 193

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

Line: 208

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

Line: 232

       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: 262

   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
   (fnd_attached_documents_s.nextval,
    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,
    NVL(X_to_pk2_value, docrec.pk2_value),
    NVL(X_to_pk3_value, docrec.pk3_value),
    NVL(X_to_pk4_value, docrec.pk4_value),
    NVL(X_to_pk5_value, docrec.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: 317

     UPDATE fnd_documents
     SET usage_type = 'S'
     WHERE document_id = docrec.document_id;

Line: 346

			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
BEGIN

		fnd_attached_documents2_pkg.copy_attachments(
			      X_from_entity_name,
			      X_from_pk1_value,
				X_from_pk2_value,
			      X_from_pk3_value,
			      X_from_pk4_value,
			      X_from_pk5_value,
			      X_to_entity_name,
			      X_to_pk1_value,
			      X_to_pk2_value,
			      X_to_pk3_value,
			      X_to_pk4_value,
			      X_to_pk5_value,
			      X_created_by,
			      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);

Line: 396

			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 doclist 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, fdtl.file_name,
		fdtl.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
	  FROM 	fnd_attached_documents fad,
		fnd_documents fd,
		fnd_documents_tl fdtl
	  --WHERE fad.document_id = fd.document_id
	  WHERE	fad.document_id = X_document_id
	    AND fad.document_id = fd.document_id
	    AND fd.document_id = fdtl.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);

Line: 450

	SELECT short_text
	  FROM fnd_documents_short_text
	 WHERE media_id = mid;

Line: 455

	SELECT long_text
	  FROM fnd_documents_long_text
	 WHERE media_id = mid;

Line: 460

        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: 511

      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),
       --Bug 4381237: Start
       --security is always enforced as 4 and security id as null
       --docrec.security_type,
       4,
       --docrec.security_id,
       NULL,
       --Bug 4381237: End
       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);

Line: 564

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

Line: 579

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

Line: 603

       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: 633

   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
   (fnd_attached_documents_s.nextval,
    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,
    NVL(X_to_pk2_value, docrec.pk2_value),
    NVL(X_to_pk3_value, docrec.pk3_value),
    NVL(X_to_pk4_value, docrec.pk4_value),
    NVL(X_to_pk5_value, docrec.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: 688

     UPDATE fnd_documents
     SET usage_type = 'S'
     WHERE document_id = docrec.document_id;

Line: 719

			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
BEGIN
		fnd_attached_documents2_pkg.copy_attachments(
			      X_from_entity_name,
			      X_from_pk1_value,
				X_from_pk2_value,
			      X_from_pk3_value,
			      X_from_pk4_value,
			      X_from_pk5_value,
			      X_to_entity_name,
			      X_to_pk1_value,
			      X_to_pk2_value,
			      X_to_pk3_value,
			      X_to_pk4_value,
			      X_to_pk5_value,
			      X_created_by,
			      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);

Line: 828

				select category_id into l_category_id
				from fnd_document_categories_vl
				where name = l_category_name;

Line: 855

      X_last_update_login 		=> l_login_id,
      X_program_application_id 	=> null,
      X_program_id 			=> null,
      X_request_id 			=> null,
      X_automatically_added_flag 	=> 'N',
      X_from_category_id            => l_category_id,
      X_to_category_id              => l_category_id);

Line: 889

    select document_id
    from edr_erecord_id_temp;

Line: 931

  select status into l_file_status
  from edr_files_vl
  where file_id = p_file_id;

Line: 959

    UPDATE EDR_FILES_B
    SET STATUS = l_status
    where file_id = p_file_id;

Line: 966

      select fnd_document_id
      into l_document_id
      from edr_files_b
      where file_id = p_file_id;

Line: 973

      update fnd_documents set
      security_type = G_SECURITY_OFF,
      publish_flag = G_PUBLISH_FLAG_Y
      where document_id = l_document_id;

Line: 1002

	SELECT USER_NAME INTO P_DISPLAY_NAME
	FROM FND_DOCUMENT_CATEGORIES_VL
	WHERE NAME = P_CATEGORY_NAME;

Line: 1263

    select document_id
    from edr_erecord_id_temp;

Line: 1306

	select fnd_attached_documents_s.nextval into l_atc_doc_id
	from dual;

Line: 1312

	select userenv('lang') into l_language from dual;

Line: 1314

	FND_ATTACHED_DOCUMENTS_PKG.Insert_Row
	(X_Rowid    			=> l_rowid,
	 X_attached_document_id         => l_atc_doc_id,
	 X_document_id                  => l_document_id,
       X_creation_date                => SYSDATE,
	 X_created_by                   => l_user_id,
       X_last_update_date             => SYSDATE,
	 X_last_updated_by              => l_user_id,
	 X_last_update_login            => l_login_id,
	 X_seq_num                      => 1,
	 X_entity_name                  => G_TEMP_ENTITY_NAME,
	 X_column1                      => null,
	 X_pk1_value                    => p_target_value,
	 X_pk2_value                    => null,
	 X_pk3_value                    => null,
	 X_pk4_value                    => null,
	 X_pk5_value                    => null,
       X_automatically_added_flag     => 'N',
       X_datatype_id                  => 6,
	 X_category_id                  => NULL,
	 X_security_type                => NULL,
	 X_publish_flag                 => NULL,
       X_language                     => l_language,
	 X_media_id                     => l_media_id);