pears.NetClientShiftCancelReasonsOuter
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
Original 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 }