pears.NotificationICS

CREATE FUNCTION "pears"."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