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