CREATE OR REPLACE TRIGGER td_inbound_uld
BEFORE DELETE ON inbound_uld
FOR EACH ROW
BEGIN
   
   /*  delete children in "inbound_uld_dests"  */
   DELETE 
     FROM inbound_uld_dests
    WHERE inbound_uld_id = :old.inbound_uld_id;

END;
/