     ,GeneID NUMBER(22,0) 
     ,GeneIdentifier varchar2(255)) ON COMMIT DELETE ROWS;
 
---------------------------------------------------------
---  DDL for Bioetity annotations TEMP TABLE
---------------------------------------------------------
-
-CREATE TABLE "TMP_BIOENTITY" (
-    accession varchar2(255)
-    ,name varchar2(255)
-    ,value varchar2(255));
     
 --------------------------------------------------------
 --  TASK MANAGER DATA STRUCTURES

for each row
begin
if(:new.BEPropertyValueID is null) then
select A2_BEPropertyValue_seq.nextval into :new.BEPropertyValueID from dual;
end if;
end;
/


ALTER TRIGGER A2_BIOENTITY2BIOENTITY_INSERT ENABLE;


--------------------------------------------------------
-- BIOENTITY BIOENTITYPROPERTYVALUE
