pears.NetOwnerGetContactEventOutcome

CREATE PROCEDURE "pears"."NetOwnerGetContactEventOutcome"( IN "pWebUserID" CHAR(20) ) 
/* RESULT( column_name column_type, ... ) */
BEGIN
  SELECT "contactoutcomeid" AS "Value",
    "description" AS "Descrip",
    "callbackdays" AS "callback"
    FROM "pears"."contactoutcome"
    ORDER BY "sortorder" ASC
END /* DOC
2016-08-31 PC test and doc
 
inputs:
pWebUserID
 
outputs:
Value - Primary Key
Descrip - text description
 
tests:
ensure a list is returned. There is no filtering
 
*/
/* TEST
 
select (if (select count(*) from "pears"."NetOwnerGetContactEventOutcome"("pWebUserID" = null)) != 0 then 'y' else 'n' endif);
expect y;
select (if (select count(*) from "pears"."NetOwnerGetContactEventOutcome"("pWebUserID" = null)) = (select count(*) from contactoutcome) then 'y' else 'n' endif);
expect y;
 
*/
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetOwnerGetContactEventOutcome" IS 
{CREATE PROCEDURE pears."NetOwnerGetContactEventOutcome"( IN pWebUserID CHAR(20) )
/* RESULT( column_name column_type, ... ) */
BEGIN
    SELECT 
        contactoutcomeid AS VALUE, 
        description AS Descrip, 
        callbackdays AS callback 
    FROM 
        "pears"."contactoutcome"
    ORDER BY 
        sortorder
END
 
/* DOC
2016-08-31 PC test and doc
 
inputs:
    pWebUserID
 
outputs:
    Value - Primary Key
    Descrip - text description
 
tests:
    ensure a list is returned. There is no filtering
 
*/
 
/* TEST
 
select (if (select count(*) from "pears"."NetOwnerGetContactEventOutcome"("pWebUserID" = null)) != 0 then 'y' else 'n' endif);
expect y;
select (if (select count(*) from "pears"."NetOwnerGetContactEventOutcome"("pWebUserID" = null)) = (select count(*) from contactoutcome) then 'y' else 'n' endif);
expect y;
 
*/
}