CREATE OR REPLACE TRIGGER FARM.HARVEST_DATA_TRG
AFTER DELETE OR INSERT OR UPDATE
ON FARM.BALES_HARVESTED
REFERENCING NEW AS New OLD AS Old
FOR EACH ROW
BEGIN

  IF INSERTING THEN
             insert into BALES_STORAGE (BALES_RECEIVED_GAINED, CROP, CUTTING, STACKYARD, DATE_MOVED, HARVEST_ID, BALE_YEAR) values(:new.BALES_RECEIVED, :new.CROP, :new.CUTTING, :new.STACKYARD, :new.DATE_RECEIVED, :new.HARVEST_ID, :new.BALE_YEAR);
             
      ELSIF UPDATING THEN
              UPDATE BALES_STORAGE 
              SET  BALES_RECEIVED_GAINED= :new.BALES_RECEIVED, 
                   CROP= :new.CROP, 
                   CUTTING= :new.CUTTING, 
                   STACKYARD= :new.STACKYARD,
                   DATE_MOVED= :new.DATE_RECEIVED, 
                   HARVEST_ID= :new.HARVEST_ID,
                   BALE_YEAR= :new.BALE_YEAR 
               WHERE  BALES_STORAGE.harvest_id = :old.harvest_id;
                 
       ELSIF DELETING THEN
                   DELETE FROM BALES_STORAGE
                   WHERE  harvest_id = :old.harvest_id;    
       END IF;
END;
/

CREATE OR REPLACE TRIGGER FARM.TRIG_BALES_STORAGE_PK BEFORE INSERT ON FARM.BALES_STORAGE REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW
begin  
   if inserting then 
      if :NEW."STORAGE_ID" is null then 
         select SEQ_STORAGE_ID.nextval into :NEW."STORAGE_ID" from dual; 
        end if; 
   end if; 
end;
/