pears.NotificationTemplateSelector
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
Original SQL
CREATE FUNCTION "pears"."NotificationTemplateSelector"( IN "pTemplateID" CHAR(50),IN "pSubjectType" CHAR(20),IN "pSubjectIDs" CHAR(100),IN "pNotificationType" CHAR(20),IN "pRecipientType" CHAR(20),IN "pGroupCode" CHAR(20) ) RETURNS SMALLINT BEGIN -- Used for filtering the dropdown list of templates -- Return 1 to indicate that this template is applicable to the context RETURN 1 END