database:procedures:pears_vacancyadjustrequirements



pears.VacancyAdjustRequirements

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

Original SQL

CREATE PROCEDURE "pears"."VacancyAdjustRequirements"( IN "vacID" CHAR(20) ) 
BEGIN
  IF EXISTS(SELECT "Vacancyid" FROM "vacancy" WHERE "vacancyid" = "vacid" AND "QuestionnaireUpdated" IS NOT NULL) THEN
    -- update requirements
    UPDATE "vacancy" SET "QuestionnaireUpdated" = NULL WHERE "vacancyid" = "vacid"
  END IF
END
  • database/procedures/pears_vacancyadjustrequirements.txt
  • Last modified: 2026/08/07 19:24
  • by 127.0.0.1