====== pears.TempCustomShiftFetcher ======
<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 procedure "pears"."TempCustomShiftFetcher"( in "YearNo" integer,in "PeriodNo" integer,in "PeriodLength" char(20),in "PeriodStartDate" date,in "PeriodEndDate" date,in "PersID" char(20),in "DeskID" char(20) ) 
begin
  -- Called before generation of e-timesheets on a shift desk (DeskID will have a non null value)
  -- And before fetching shifts for an individual timesheet (PersID will have a non null value)
  -- May insert tempshift and tempshiftplan rows
end
</code>