pears.TempShiftConfirmationChange

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

Original SQL

CREATE PROCEDURE "pears"."TempShiftConfirmationChange"( IN "shiftid" CHAR(20),IN "vacid" CHAR(20),IN "persid" CHAR(20),IN "sdate" DATE,IN "cconfirm" INTEGER,IN "tconfirm" INTEGER ) 
BEGIN
  -- Actual content of procedure will vary depending on desired placement behaviour
  -- Can call EnsurePlacementForShift(shiftid,vacid,persid,sdate)
  -- Called by insert and confirm triggers
END