pears.NotificationComplete

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

Original SQL

CREATE FUNCTION "pears"."NotificationComplete"( 
  IN "pTemplateID" CHAR(50) DEFAULT NULL,IN "pRecipientType" CHAR(20) DEFAULT NULL,IN "pPersonID" CHAR(20) DEFAULT NULL,IN "pVacancyID" CHAR(20) DEFAULT NULL,IN "pCompanyID" CHAR(20) DEFAULT NULL,IN "pProgressid" CHAR(20) DEFAULT NULL,IN "pPlacementid" CHAR(20) DEFAULT NULL,IN "pDivisionID" CHAR(20) DEFAULT NULL,IN "pSubjectType" VARCHAR(40) DEFAULT NULL,IN "pSubjectIDs" long VARCHAR DEFAULT NULL ) 
RETURNS CHAR(20)
BEGIN
  -- executed after the notification is sent
END