pears.NotificationDeeplinkComplete
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
Original SQL
CREATE FUNCTION "pears"."NotificationDeeplinkComplete"( IN "pTemplateID" CHAR(50) 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 Deeplink submitted END