pears.DocumentPackAllowed

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

Original SQL

CREATE FUNCTION "pears"."DocumentPackAllowed"( IN "docpackid" 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
  -- function called BEFORE selecting who to send to
  -- persid, docpackid and vacid always populated)
  DECLARE "rv" long VARCHAR;
  SET "rv" = '';
  RETURN("rv")
END