pears.TempCustomShiftFetcher

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