pears.NetSetVacancyCascade

CREATE PROCEDURE "pears"."NetSetVacancyCascade"( IN "svacid" CHAR(20) ) 
BEGIN
  DECLARE "dtCascade" "datetime";
  SELECT "getvacancycascadetime"("employment"."companyid","vacancy"."vacancyid",CURRENT TIMESTAMP,"vacancy"."startdate",CURRENT TIMESTAMP,1)
    INTO "dtCascade"
    FROM "vacancy" KEY JOIN "employment" WHERE "vacancy"."vacancyid" = "svacid";
  IF "dtCascade" IS NOT NULL THEN
    UPDATE "vacancy" SET "cascadedatetime" = "dtCascade" WHERE "vacancyid" = "svacid"
  END IF
END
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetSetVacancyCascade" IS 
{CREATE PROCEDURE pears."NetSetVacancyCascade"( IN "svacid" CHAR(20) )
BEGIN
  DECLARE "dtCascade" "datetime";
  SELECT "getvacancycascadetime"("employment"."companyid","vacancy"."vacancyid",CURRENT TIMESTAMP,"vacancy"."startdate",CURRENT TIMESTAMP,1)
    INTO "dtCascade"
    FROM "vacancy" KEY JOIN "employment" WHERE "vacancy"."vacancyid" = "svacid";
  IF "dtCascade" IS NOT NULL THEN
    UPDATE "vacancy" SET "cascadedatetime" = "dtCascade" WHERE "vacancyid" = "svacid"
  END IF
END
}