pears.AutoMatchRemoveShiftFromQueue

CREATE PROCEDURE "pears"."AutoMatchRemoveShiftFromQueue"( 
  IN @TempShiftPlanID CHAR(20),@State CHAR(1),@Refill SMALLINT ) 
BEGIN
  IF @State IN( 'P','B' ) THEN
    UPDATE "AutoMatchShiftQueue" SET "NotRequired" = 1 WHERE "TempshiftPlanID" = @TempShiftPlanID AND "completed" IS NULL;
    UPDATE "AutoMatchNotificationQueue" SET "NotRequired" = 1 WHERE "TempshiftPlanID" = @TempShiftPlanID AND "emailcompleted" IS NULL AND "SMScompleted" IS NULL AND "Pushcompleted" IS NULL
  END IF;
  IF(@State = 'C') AND("isnull"(@Refill,0) = 0) THEN
    UPDATE "AutoMatchShiftQueue" SET "NotRequired" = 1 WHERE "TempshiftPlanID" = @TempShiftPlanID AND "completed" IS NULL;
    UPDATE "AutoMatchNotificationQueue" SET "NotRequired" = 1 WHERE "TempshiftPlanID" = @TempShiftPlanID AND "emailcompleted" IS NULL AND "SMScompleted" IS NULL AND "Pushcompleted" IS NULL
  END IF
END
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."AutoMatchRemoveShiftFromQueue" IS 
{CREATE PROCEDURE AutoMatchRemoveShiftFromQueue 
( IN @TempShiftPlanID CHAR(20), @State CHAR(1), @Refill SMALLINT ) 
BEGIN
  IF @State IN ('P','B') THEN
    UPDATE AutoMatchShiftQueue SET NotRequired = 1 WHERE TempshiftPlanID = @TempShiftPlanID AND completed IS NULL;
    UPDATE AutoMatchNotificationQueue SET NotRequired = 1 WHERE TempshiftPlanID = @TempShiftPlanID AND emailcompleted IS NULL AND SMScompleted IS NULL AND Pushcompleted IS NULL;
  END IF;
  IF (@State = 'C') AND (isnull(@Refill,0) = 0) THEN
    UPDATE AutoMatchShiftQueue SET NotRequired = 1 WHERE TempshiftPlanID = @TempShiftPlanID AND completed IS NULL;
    UPDATE AutoMatchNotificationQueue SET NotRequired = 1 WHERE TempshiftPlanID = @TempShiftPlanID AND emailcompleted IS NULL AND SMScompleted IS NULL AND Pushcompleted IS NULL;
  END IF;
END
}