pears.NotificationTemplateSelector
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
Original SQL
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NotificationTemplateSelector" IS {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 }