====== pears.ShiftBackColourOverride ======
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
===== Original SQL =====
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
}