Oracle ERP Alert Nasıl Silinir?

DECLARE
   CURSOR ALR
   IS
      SELECT ALERT_ID, APPLICATION_ID
        FROM ALR_ALERTS
       WHERE ALERT_ID = 107046;
BEGIN
   FOR REC IN ALR
   LOOP
      DELETE FROM ALR_ACTION_SETS
            WHERE     APPLICATION_ID = REC.APPLICATION_ID
                  AND ALERT_ID = REC.ALERT_ID;
 
      DELETE FROM ALR_ACTIONS
            WHERE     APPLICATION_ID = REC.APPLICATION_ID
                  AND ALERT_ID = REC.ALERT_ID;
 
      DELETE FROM ALR_ALERT_INPUTS
            WHERE     APPLICATION_ID = REC.APPLICATION_ID
                  AND ALERT_ID = REC.ALERT_ID;
 
      DELETE FROM ALR_ACTION_SET_INPUTS
            WHERE     APPLICATION_ID = REC.APPLICATION_ID
                  AND ALERT_ID = REC.ALERT_ID;
 
      DELETE FROM ALR_ALERT_OUTPUTS
            WHERE     APPLICATION_ID = REC.APPLICATION_ID
                  AND ALERT_ID = REC.ALERT_ID;
 
      DELETE FROM ALR_ACTION_SET_OUTPUTS
            WHERE     APPLICATION_ID = REC.APPLICATION_ID
                  AND ALERT_ID = REC.ALERT_ID;
 
      DELETE FROM ALR_PERIODIC_SET_MEMBERS
            WHERE     CHILD_APPLICATION_ID = REC.APPLICATION_ID
                  AND CHILD_ALERT_ID = REC.ALERT_ID;
 
      DELETE FROM ALR_RESPONSE_SETS
            WHERE     APPLICATION_ID = REC.APPLICATION_ID
                  AND ALERT_ID = REC.ALERT_ID;
 
      DELETE FROM ALR_RESPONSE_VARIABLES
            WHERE     APPLICATION_ID = REC.APPLICATION_ID
                  AND ALERT_ID = REC.ALERT_ID;
 
      DELETE FROM ALR_VALID_RESPONSES
            WHERE     APPLICATION_ID = REC.APPLICATION_ID
                  AND ALERT_ID = REC.ALERT_ID;
 
      DELETE FROM ALR_RESPONSE_ACTIONS
            WHERE     APPLICATION_ID = REC.APPLICATION_ID
                  AND ALERT_ID = REC.ALERT_ID;
 
      DELETE FROM ALR_RESPONSE_VARIABLE_VALUES
            WHERE     APPLICATION_ID = REC.APPLICATION_ID
                  AND ALERT_ID = REC.ALERT_ID;
 
      DELETE FROM ALR_ACTUAL_RESPONSES
            WHERE     APPLICATION_ID = REC.APPLICATION_ID
                  AND ALERT_ID = REC.ALERT_ID;
 
      DELETE FROM ALR_ALERT_INSTALLATIONS
            WHERE     APPLICATION_ID = REC.APPLICATION_ID
                  AND ALERT_ID = REC.ALERT_ID;
 
      DELETE FROM ALR_ALERTS WHERE ALERT_ID = REC.ALERT_ID;                  
 
      COMMIT;
   END LOOP;
END;