API to Delete Oracle Alert

Query to Get Alert Details:

Select * from ALR_ALERTS where alert_name like 'TEST_ALERT_NEW';


API to Delete Alert:

Declare
l_Alert_appl_id Number := 20003;                    -- Application Id from ALR_ALERTS
l_Alert_id Number := 11111;                         -- Alert Id from ALR_ALERTS

BEGIN
ALR_ALERTS_PKG.DELETE_ROW(l_Alert_appl_id,l_Alert_id);
COMMIT;
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE('Alert Deleted Successfully..'||SQLERRM);
ROLLBACK;
END;