pears.GenerateContactEventWithEmailLog

CREATE PROCEDURE "pears"."GenerateContactEventWithEmailLog"( 
  /* Application Maintained Function / Procedure - DO NOT EDIT*/
  IN "pcontacteventid" CHAR(20),
  IN "pstaffid" CHAR(20),IN "pcontactdate" DATE,IN "pclasscode" CHAR(2),IN "ppersonid" CHAR(20) DEFAULT NULL,
  IN "pvacancyid" CHAR(20) DEFAULT NULL,IN "pemploymentid" CHAR(20) DEFAULT NULL,IN "pprogressid" CHAR(20) DEFAULT NULL,
  IN "pplacementid" CHAR(20) DEFAULT NULL,IN "pcontacttime" TIME DEFAULT NULL,
  IN "pdescription" CHAR(100) DEFAULT NULL,IN "poutcome" CHAR(50) DEFAULT NULL,IN "pwho" CHAR(1) DEFAULT NULL,
  IN "pnotes" long VARCHAR DEFAULT NULL,IN "plettertext" long VARCHAR DEFAULT NULL,IN "pfollowup" SMALLINT DEFAULT 0,
  IN "pwpdoc" CHAR(10) DEFAULT NULL,IN "pcallbackdate" DATE DEFAULT NULL,IN "pWhenEntered" TIMESTAMP DEFAULT CURRENT TIMESTAMP,
  IN "pWhoEntered" CHAR(20) DEFAULT NULL,IN "pcallbacktime" TIME DEFAULT NULL,
  IN "ppriority" SMALLINT DEFAULT 5,IN "pSynetyGUID" CHAR(100) DEFAULT NULL,
  IN "pspeciality" CHAR(50) DEFAULT NULL,IN "pforenames" CHAR(30) DEFAULT NULL,IN "psurname" CHAR(30) DEFAULT NULL,
  IN "pDirection" CHAR(3) DEFAULT 'OUT',IN "pMethod" CHAR(10) DEFAULT 'EMAIL',IN "pWhenSent" TIMESTAMP DEFAULT CURRENT TIMESTAMP,
  IN "pRecipients" long VARCHAR DEFAULT NULL,IN "pAttachments" long VARCHAR DEFAULT NULL,IN "pdivisionid" CHAR(20) DEFAULT NULL ) 
BEGIN
  INSERT INTO "contactevent"( "contacteventid","personid","staffid","vacancyid","employmentid","progressid","placementid","contactdate","contacttime",
    "description","outcome","classcode","who","notes","lettertext","followup","wpdoc","callbackdate","divisionid","WhenEntered","WhoEntered",
    "callbacktime","priority","SynetyGUID","speciality","forenames","surname" ) VALUES
    ( "pcontacteventid","ppersonid","pstaffid","pvacancyid","pemploymentid","pprogressid","pplacementid","pcontactdate","pcontacttime",
    "pdescription","poutcome","pclasscode","pwho","pnotes","plettertext","pfollowup","pwpdoc","pcallbackdate","pdivisionid","pWhenEntered","pWhoEntered",
    "pcallbacktime","ppriority","pSynetyGUID","pspeciality","pforenames","psurname" ) ;
  CALL "GenerateContactEventEmailLog"("pContactEventid","pWhenSent","pRecipients","pAttachments","pDirection","pMethod")
END
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."GenerateContactEventWithEmailLog" IS 
{CREATE PROCEDURE GenerateContactEventWithEmailLog 
 
/* Application Maintained Function / Procedure - DO NOT EDIT*/
 
 (IN "pcontacteventid" CHAR(20) ,
   IN"pstaffid" CHAR(20) ,IN"pcontactdate" DATE , IN"pclasscode" CHAR(2), IN"ppersonid" CHAR(20) DEFAULT NULL, 
   IN"pvacancyid" CHAR(20) DEFAULT NULL, IN"pemploymentid" CHAR(20)  DEFAULT NULL, IN"pprogressid" CHAR(20) DEFAULT NULL, 
   IN"pplacementid" CHAR(20) DEFAULT NULL,   IN"pcontacttime" TIME DEFAULT NULL, 
   IN"pdescription" CHAR(100) DEFAULT NULL, IN"poutcome" CHAR(50)DEFAULT  NULL, IN"pwho" CHAR(1) DEFAULT NULL, 
   IN"pnotes" LONG VARCHAR DEFAULT NULL,IN"plettertext" LONG VARCHAR DEFAULT NULL, IN"pfollowup" SMALLINT DEFAULT 0, 
   IN"pwpdoc" CHAR(10) DEFAULT NULL,  IN"pcallbackdate" DATE DEFAULT NULL, IN"pWhenEntered" TIMESTAMP DEFAULT CURRENT TIMESTAMP, 
   IN"pWhoEntered" CHAR(20) DEFAULT NULL,  IN"pcallbacktime" TIME DEFAULT NULL, 
   IN"ppriority" SMALLINT DEFAULT 5,  IN"pSynetyGUID" CHAR(100) DEFAULT NULL, 
   IN"pspeciality" CHAR(50) DEFAULT NULL, IN"pforenames" CHAR(30) DEFAULT NULL,IN"psurname" CHAR(30) DEFAULT NULL, 
   IN"pDirection" CHAR(3) DEFAULT 'OUT',IN"pMethod" CHAR(10) DEFAULT 'EMAIL',IN"pWhenSent" TIMESTAMP DEFAULT CURRENT TIMESTAMP, 
   IN"pRecipients" long VARCHAR DEFAULT NULL,IN"pAttachments" long VARCHAR DEFAULT NULL, IN"pdivisionid" CHAR(20) DEFAULT NULL) 
BEGIN 
  INSERT INTO contactevent ( contacteventid,personid,staffid,vacancyid,employmentid,progressid,placementid,contactdate,contacttime, 
  description,outcome,classcode,who,notes,lettertext,followup,wpdoc,callbackdate,divisionid,WhenEntered,WhoEntered, 
  callbacktime,priority,SynetyGUID,speciality,forenames,surname )  
  VALUES(pcontacteventid,ppersonid,pstaffid,pvacancyid,pemploymentid,pprogressid,pplacementid,pcontactdate,pcontacttime, 
  pdescription,poutcome,pclasscode,pwho,pnotes,plettertext,pfollowup,pwpdoc,pcallbackdate,pdivisionid,pWhenEntered,pWhoEntered, 
  pcallbacktime,ppriority,pSynetyGUID,pspeciality,pforenames,psurname); 
  CALL GenerateContactEventEmailLog(pContactEventid, pWhenSent, pRecipients, pAttachments, pDirection, pMethod); 
END
}