pears.NetSetShiftplanCascade

CREATE PROCEDURE "pears"."NetSetShiftplanCascade"( IN "splanid" CHAR(20) ) 
BEGIN
  DECLARE "dtCascade" "datetime";
  SELECT "GetCascadeTime"("employment"."companyid","vacancy"."vacancyid",CURRENT TIMESTAMP,"p"."shiftdate"+"p"."timefrom",CURRENT TIMESTAMP,1)
    INTO "dtCascade"
    FROM "tempshiftplan" AS "p" KEY JOIN "vacancy" KEY JOIN "employment" WHERE "p"."tempshiftplanid" = "splanid";
  IF "dtCascade" IS NOT NULL THEN
    UPDATE "tempshiftplan" SET "cascadedatetime" = "dtCascade" WHERE "tempshiftplanid" = "splanid"
  END IF
END
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetSetShiftplanCascade" IS 
{CREATE PROCEDURE pears."NetSetShiftplanCascade"( IN "splanid" CHAR(20) ) 
BEGIN
  DECLARE "dtCascade" "datetime";
  SELECT "GetCascadeTime"("employment"."companyid","vacancy"."vacancyid",CURRENT TIMESTAMP,"p"."shiftdate"+"p"."timefrom",CURRENT TIMESTAMP,1)
    INTO "dtCascade"
    FROM "tempshiftplan" AS "p" KEY JOIN "vacancy" KEY JOIN "employment" WHERE "p"."tempshiftplanid" = "splanid";
  IF "dtCascade" IS NOT NULL THEN
    UPDATE "tempshiftplan" SET "cascadedatetime" = "dtCascade" WHERE "tempshiftplanid" = "splanid"
  END IF
END
}