pears.NotificationAttachments [iqx]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== pears.NotificationAttachments ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

===== Original SQL =====
<code sql>
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NotificationAttachments" IS 
{create function pears."NotificationAttachments"(in pTemplateID char(50), in pRecipientType char(20),   in pPersonID char(20),in pVacancyID char(20), in pCompanyID char(20),    in pDivisionID char(20)  ,in pSubjectType char(20) default null, in pSubjectIDs char(100) default null) 
returns char(255)
begin
  -- Return comma separated list of file pathnames or documents of the form RecordType: Document name with optional wild cards
  -- e.g. Company: Contract*
end
}
</code>