eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_DI_FILEUPLOAD_PVT SQL Statements

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

Line: 8


/* description: Procedure to insert/update content item for  */
/*              an associated document                       */
/*-----------------------------------------------------------*/




G_DEBUG 		 VARCHAR2(1):=AHL_DEBUG_PUB.is_log_enabled;

Line: 51


          SELECT AHL_DOC_FILE_ASSOC_B_S.nextval
          FROM dual;

Line: 56


     select  FUPV.FILE_ID , FUPV.FILE_NAME   from AHL_DOC_FILE_ASSOC_V FUPV, FND_LOBS FLOB
     where FUPV.REVISION_ID = l_revid
     and FUPV.FILE_ID  = FLOB.FILE_ID;

Line: 105


       SELECT 1
       INTO l_dummy
       FROM AHL_DOC_REVISIONS_B
       WHERE DOC_REVISION_ID = p_x_ahl_fileupload_rec.p_revision_id;

Line: 140


       SELECT distinct 1
       INTO l_dummy
       FROM FND_LOBS
       WHERE FILE_ID = p_x_ahl_fileupload_rec.p_file_id;

Line: 183


   DELETE_ITEM
           (
             p_api_version => 1.0,
   	     p_init_msg_list => FND_API.G_FALSE,
   	     p_commit => FND_API.G_FALSE,
   	     p_validation_level => FND_API.G_VALID_LEVEL_FULL,
   	     x_return_status => l_return_status,
   	     x_msg_count => l_msg_count,
   	     x_msg_data => l_msg_data,
             p_x_ahl_fileupload_rec => p_x_ahl_fileupload_rec
      );

Line: 197


    AHL_DEBUG_PUB.debug('completed delete if there are any  ');

Line: 211


   AHL_DOC_FILE_ASSOC_PKG.INSERT_ROW(
   X_ROWID => l_rowid ,
   X_ASSOCIATION_ID => l_association_id,
   X_OBJECT_VERSION_NUMBER => 1,
   X_FILE_ID => p_x_ahl_fileupload_rec.p_file_id,
   X_FILE_NAME => p_x_ahl_fileupload_rec.p_file_name,
   X_REVISION_ID => p_x_ahl_fileupload_rec.p_revision_id,
   X_DATATYPE_CODE => p_x_ahl_fileupload_rec.p_datatype_code,
   X_SECURITY_GROUP_ID => l_security_group_id,
   X_ATTRIBUTE_CATEGORY => p_x_ahl_fileupload_rec.p_attribute_category,
     X_ATTRIBUTE1 =>  p_x_ahl_fileupload_rec.p_attribute1,
     X_ATTRIBUTE2  => p_x_ahl_fileupload_rec.p_attribute2,
     X_ATTRIBUTE3  => p_x_ahl_fileupload_rec.p_attribute3,
     X_ATTRIBUTE4  => p_x_ahl_fileupload_rec.p_attribute4,
     X_ATTRIBUTE5 => p_x_ahl_fileupload_rec.p_attribute5,
     X_ATTRIBUTE6  => p_x_ahl_fileupload_rec.p_attribute6,
     X_ATTRIBUTE7  => p_x_ahl_fileupload_rec.p_attribute7,
     X_ATTRIBUTE8 => p_x_ahl_fileupload_rec.p_attribute8,
     X_ATTRIBUTE9  => p_x_ahl_fileupload_rec.p_attribute9,
     X_ATTRIBUTE10 => p_x_ahl_fileupload_rec.p_attribute10,
     X_ATTRIBUTE11  => p_x_ahl_fileupload_rec.p_attribute11,
     X_ATTRIBUTE12 => p_x_ahl_fileupload_rec.p_attribute12,
     X_ATTRIBUTE13 => p_x_ahl_fileupload_rec.p_attribute13,
     X_ATTRIBUTE14  => p_x_ahl_fileupload_rec.p_attribute14,
     X_ATTRIBUTE15 => p_x_ahl_fileupload_rec.p_attribute15,
   X_FILE_DESC =>  p_x_ahl_fileupload_rec.p_file_description,
   X_CREATION_DATE => sysdate,
   X_CREATED_BY => fnd_global.user_id,
   X_LAST_UPDATE_DATE => sysdate,
   X_LAST_UPDATED_BY => fnd_global.user_id,
   X_LAST_UPDATE_LOGIN => fnd_global.login_id
   );

Line: 321


 PROCEDURE DELETE_ITEM
  (
   p_api_version                  IN  NUMBER    := 1.0               ,
   p_init_msg_list                IN  VARCHAR2  := FND_API.G_TRUE      ,
   p_commit                       IN  VARCHAR2  := FND_API.G_FALSE     ,
   p_validation_level             IN  NUMBER    := FND_API.G_VALID_LEVEL_FULL,
   x_return_status                OUT NOCOPY VARCHAR2,
   x_msg_count                    OUT NOCOPY NUMBER,
   x_msg_data                     OUT NOCOPY VARCHAR2,
   p_x_ahl_fileupload_rec           IN ahl_fileupload_rec
 )

  IS

   l_api_name      CONSTANT VARCHAR2(30) := 'DELETE_ITEM';

Line: 347


       select  FUPV.ASSOCIATION_ID  from AHL_DOC_FILE_ASSOC_V FUPV , FND_LOBS FLOB
       where FUPV.REVISION_ID = l_revid
     and FUPV.FILE_ID  = FLOB.FILE_ID;

Line: 353


        SAVEPOINT Delete_Item;

Line: 362


            AHL_DEBUG_PUB.debug( 'enter private AHL_DI_FILEUPLOAD_PVT.DELETE_ITEM');

Line: 389


           AHL_DEBUG_PUB.debug( 'enter private AHL_DI_FILEUPLOAD_PVT.DELETE_ITEM');

Line: 394


                SELECT 1
  	      INTO l_dummy
  	      FROM AHL_DOC_REVISIONS_B
                WHERE DOC_REVISION_ID = p_x_ahl_fileupload_rec.p_revision_id;

Line: 428


           SELECT distinct 1
           INTO l_dummy
           FROM FND_LOBS
           WHERE FILE_ID = p_x_ahl_fileupload_rec.p_file_id;

Line: 467


           AHL_DEBUG_PUB.debug( 'l_assoc_id  value to be deleted'||  l_assoc_id);

Line: 479


    	   AHL_DEBUG_PUB.debug( 'ERROR: the file association to be deleted is not found ');

Line: 489


   AHL_DOC_FILE_ASSOC_PKG.DELETE_ROW(

      X_ASSOCIATION_ID => l_assoc_id

      );

Line: 508


            AHL_DEBUG_PUB.debug( 'exit private AHL_DI_FILEUPLOAD_PVT.DELETE_ITEM');

Line: 513


                ROLLBACK TO Delete_Item;

Line: 520


                  AHL_DEBUG_PUB.debug( 'AHL_DI_FILEUPLOAD_PVT.DELETE_ITEMS');

Line: 529


                ROLLBACK TO Delete_Item;

Line: 537


                   AHL_DEBUG_PUB.debug( 'AHL_DI_FILEUPLOAD_PVT.DELETE_ITEMS:');

Line: 546


                ROLLBACK TO Delete_Item;

Line: 560


                   AHL_DEBUG_PUB.debug( 'AHL_DI_FILEUPLOAD_PVT.DELETE_ITEM');

Line: 569


  END DELETE_ITEM;

Line: 581


      p_delete_flag                  IN VARCHAR2
     )

     IS

      l_ahl_fileupload_rec ahl_fileupload_rec;

Line: 624


	IF ( p_delete_flag ='Y') THEN

		DELETE_ITEM
		(
		  p_api_version => 1.0,
		  p_init_msg_list => FND_API.G_FALSE,
		  p_commit => FND_API.G_FALSE,
		  p_validation_level => FND_API.G_VALID_LEVEL_FULL,
		  x_return_status => x_return_status,
		  x_msg_count => x_msg_count,
		  x_msg_data => x_msg_data,
		  p_x_ahl_fileupload_rec => p_x_ahl_fileupload_rec
	        );

Line: 638


	ELSIF ( p_delete_flag = 'N') THEN
	         UPLOAD_ITEM
	   	 (
	   	  p_api_version => 1.0,
	   	  p_init_msg_list => FND_API.G_TRUE,
	   	  p_commit => FND_API.G_FALSE,
	   	  p_validation_level => FND_API.G_VALID_LEVEL_FULL,
	   	  x_return_status => x_return_status,
	   	  x_msg_count => x_msg_count,
	    	  x_msg_data => x_msg_data,
	   	  p_x_ahl_fileupload_rec => p_x_ahl_fileupload_rec
                 );