pears.NetIncomingApplications

CREATE PROCEDURE "pears"."NetIncomingApplications"( IN "pWebUserId" CHAR(20),IN "Jobid" CHAR(20) DEFAULT NULL ) 
RESULT( "pResult" CHAR(250) ) 
BEGIN
  DECLARE "Person" CHAR(20);
  DECLARE "Applied" CHAR(20);
  DECLARE "VacancyOwner" CHAR(20);
  IF "pWebUserId" IS NULL THEN
    SELECT '99:~You are not logged in';
    RETURN
  END IF;
  SET "VacancyOwner" = (SELECT "staffid" FROM "vacancy" WHERE "vacancyid" = "JobId");
  SET "Person" = (SELECT "IQXNetUserLink"."PersonID" FROM "IQXNetUserLink" WHERE "iqxnetuserlink"."iqxnetuserid" = "pwebuserid");
  SET "Applied" = (SELECT "status" FROM "progress" WHERE "vacancyid" = "JobId" AND "personid" = "person");
  IF "Applied" > '' THEN
    SELECT '99:~You have already Applied for this post';
    RETURN
  END IF;
  INSERT INTO "progress"( "progressid","vacancyid","actiondate","status","personid","staffId" ) VALUES( "uniquekey"('X'),"JobId","getdate"(),'A',"Person","VacancyOwner" ) ;
  SELECT '0:~Success'
END /* Unsafe - do not use without re-write */
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetIncomingApplications" IS 
{CREATE PROCEDURE pears."NetIncomingApplications"( IN "pWebUserId" CHAR(20),IN "Jobid" CHAR(20) DEFAULT NULL ) 
RESULT( "pResult" CHAR(250) ) 
BEGIN
  DECLARE "Person" CHAR(20);
  DECLARE "Applied" CHAR(20);
  DECLARE "VacancyOwner" CHAR(20);
  IF "pWebUserId" IS NULL THEN
    SELECT '99:~You are not logged in';
    RETURN
  END IF;
  SET "VacancyOwner" = (SELECT "staffid" FROM "vacancy" WHERE "vacancyid" = "JobId");
  SET "Person" = (SELECT "IQXNetUserLink"."PersonID" FROM "IQXNetUserLink" WHERE "iqxnetuserlink"."iqxnetuserid" = "pwebuserid");
  SET "Applied" = (SELECT "status" FROM "progress" WHERE "vacancyid" = "JobId" AND "personid" = "person");
  IF "Applied" > '' THEN
    SELECT '99:~You have already Applied for this post';
    RETURN
  END IF;
  INSERT INTO "progress"( "progressid","vacancyid","actiondate","status","personid","staffId" ) VALUES( "uniquekey"('X'),"JobId","getdate"(),'A',"Person","VacancyOwner" ) ;
  SELECT '0:~Success'
END
 
/* Unsafe - do not use without re-write */
}