pears.NotificationICS

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

Original SQL

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NotificationICS" IS 
{CREATE FUNCTION NotificationICS 
(IN "pTemplateID" CHAR(50),IN "pRecipientType" CHAR(20),IN "pPersonID" CHAR(20), IN "pVacancyID" CHAR(20),IN "pCompanyID" CHAR(20),IN "pDivisionID" CHAR(20),IN "pProgressID" CHAR(20), IN "pDiaryID" CHAR(20) ) 
RETURNS long VARCHAR
BEGIN
  DECLARE "rv" long VARCHAR;
  DECLARE @clientcode CHAR(12);
  DECLARE @TransportType CHAR(20);
  DECLARE @starttime TIMESTAMP;
  DECLARE @InterviewTime TIME;
  DECLARE @Notes long VARCHAR;
  DECLARE @description VARCHAR(200);
  DECLARE @Location VARCHAR(200);
  DECLARE @uid CHAR(20);
  SET "rv" = '';
 IF (@starttime  IS NOT NULL) AND (isnull(@description,'')<>'') THEN   
/*  set "rv" = (select "createicsfile"(@uid,@Location,@notes,@starttime,@starttime,@description,5,0,0,''))*/
  END IF;
  RETURN "RV";
END
}