pears.ShiftBackColourOverride

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."ShiftBackColourOverride" IS 
{CREATE FUNCTION ShiftBackColourOverride(IN shiftid CHAR(20), IN planid CHAR(20)) 
RETURNS INTEGER
BEGIN
  -- return 1 to apply colour
  IF isnull(shiftid,'') > '' THEN
  -- shift logic
  END IF;
  IF isnull(planid,'') > '' THEN
  -- shiftplan logic
  END IF;
  RETURN 0
END
}