pears.NotificationTemplateSelector

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

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
}
  • database/procedures/pears_notificationtemplateselector.txt
  • Last modified: 2026/08/07 19:24
  • by 127.0.0.1