database:functions:pears_netcanuploadvacancy



pears.NetCanUploadVacancy

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

Original SQL

CREATE FUNCTION "pears"."NetCanUploadVacancy"( IN "vacID" CHAR(20) ) 
RETURNS INTEGER
BEGIN
  IF EXISTS
    (SELECT "Vacancyid",
      "isnull"((IF "v"."temp" = 1 THEN "v"."finishdate" ELSE "v"."expiry" endif),CURRENT DATE) AS "LD"
      FROM "vacancy" AS "v"
      WHERE "vacancyid" = "vacid"
      AND "status" = 'C'
      AND "ld" >= CURRENT DATE) THEN
    RETURN 1
  ELSE RETURN 0
  END IF
END
  • database/functions/pears_netcanuploadvacancy.txt
  • Last modified: 2026/08/07 19:24
  • by 127.0.0.1