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