 --------------------------------------------------------
 -- BIOENTITY PROPERTYVALUE
 --------------------------------------------------------
- CREATE SEQUENCE  "A2_BEPROPERTYVALUE_SEQ"
+ CREATE SEQUENCE  "A2_BIOENTITYPROPERTYVALUE_SEQ"
     MINVALUE 1 MAXVALUE 1.00000000000000E+27
     INCREMENT BY 1 START WITH 1 CACHE 20
     NOORDER  NOCYCLE;

    ,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_BIOENTITYPROPERTYVALUE_SEQ.nextval into :new.BEPropertyValueID from dual;
end if;
end;
/
