pears.TempShiftConfirmationAllowed

CREATE FUNCTION "pears"."TempShiftConfirmationAllowed"( IN "shiftid" CHAR(20),IN "TempOrClient" CHAR(1),IN "NewVal" SMALLINT ) 
RETURNS long VARCHAR
BEGIN
  DECLARE "rv" long VARCHAR;
  IF "NewVal" = 1 THEN
    SET "rv" = '';
    -- Return nothing if allowed
    -- TempOrClient T - Temp C - Client
    -- NewVal 1 - Confirm 0 - Unconfirm 
    -- Return is prevalidation style not state change
    RETURN "rv"
  END IF
END