CREATE OR REPLACE PROCEDURE CleanupShiftLogs
AS
SHIFTNOTE_COUNT_1 CONSTANT NUMBER := 200,
SHIFTNOTE_COUNT_2 CONSTANT NUMBER:= 350,
OLDER_THAN_MONTHS NUMBER := 2;
BEGIN
-- SQL STATEMENTS --
END CleanupShiftLogs;
-- SHIFTNOTE_COUNT_3 CONSTANT NUMBER; --> If it is a constant, you need to initialize it at declaration.