====== pears.DocumentPackAttachName ======
<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>
create function "pears"."DocumentPackAttachName"( in "docpackid" char(20),in "doctypeid" char(20),in "persid" char(20),in "vacid" char(20),in "planid" char(20),in "shiftid" char(20),in "placid" char(20) ) 
returns long varchar
begin
  -- persid, docpackid, doctypeid and vacid always populated
  declare "rv" long varchar;
  select "description" into "rv" from "documenttype" where "documenttypeid" = "doctypeid";
  return("rv")
end
</code>