====== pears.TempShiftEditingAllowed ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

===== Original SQL =====
<code sql>
create function "pears"."TempShiftEditingAllowed"( in "planid" char(20),in "shiftid" char(20),in "EditOrCancel" char(1),in "Source" char(3) ) 
returns long varchar
begin
  --  return nothing if allowed
  -- EditOrCancel E - Edit C - Cancel
  -- Source 
  -- TS - Tempdesk Shifts 
  -- VDD - Vacancy Diary Drag return value not shown
  -- VDM - Vacancy Diary menu
  -- VS - Vacancy Shifts
  -- PDD - Person Diary Drag return value not shown
  -- PDM - Person Diary Menu
  declare "rv" long varchar;
  set "rv" = '';
  return "rv"
end
</code>