IQX Quick Menu

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

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

pears.NotificationComplete

Original SQL

iqx