====== pears.NetClientShiftCancelReasonsOuter ======
<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 procedure "pears"."NetClientShiftCancelReasonsOuter"( in "pWebUserID" char(20),in "NeedsRefill" integer default 0 ) 
result( "CancelReasonsList" long varchar ) 
-- 20111012 outer wrapper for NetGenevaClientShiftCancelReasons
-- 20111128 modify to allow filter on reject or cancel reasons where refill=true
-- 20130213 created from GenevaNetClientShiftCancelReasonsOuter
begin
  select "NetClientShiftCancelReasons"("pWebUserID","NeedsRefill") as "CancelReasonsList" from "dummy"
end
go

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetClientShiftCancelReasonsOuter" IS 
{create procedure pears."NetClientShiftCancelReasonsOuter"( in "pWebUserID" char(20),in "NeedsRefill" integer default 0 ) 
result( "CancelReasonsList" long varchar ) 
-- 20111012 outer wrapper for NetGenevaClientShiftCancelReasons
-- 20111128 modify to allow filter on reject or cancel reasons where refill=true
-- 20130213 created from GenevaNetClientShiftCancelReasonsOuter
begin
  select "NetClientShiftCancelReasons"("pWebUserID","NeedsRefill") as "CancelReasonsList" from "dummy"
end
}
</code>