pears.NetClientShiftCancelReasonsOuter

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

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
}
  • database/procedures/pears_netclientshiftcancelreasonsouter.txt
  • Last modified: 2026/08/07 19:24
  • by 127.0.0.1