====== pears.NotificationEmailSubject ====== Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. ===== Original SQL ===== create function "pears"."NotificationEmailSubject"( in "pTemplateID" char(50),in "pRecipientType" char(20),in "pPersonID" char(20),in "pVacancyID" char(20),in "pCompanyID" char(20),in "pDivisionID" char(20) ) returns char(100) begin -- If no value returned will use template description end