database:procedures:pears_tempshiftconfirmationchange



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
  • database/procedures/pears_tempshiftconfirmationchange.txt
  • Last modified: 2026/08/07 19:24
  • by 127.0.0.1