USP_R68_CLEARR68DETAIL

Clears the R68DETAIL table of records for a given parameter set instance of the R68 business process.

Parameters

Parameter	Parameter Type	Mode	Description
@PROCESSID	uniqueidentifier	IN

Definition

Copy



            CREATE procedure dbo.USP_R68_CLEARR68DETAIL
            (
                @PROCESSID uniqueidentifier
            )
            as 
            set nocount on;

            delete from dbo.R68DETAIL where R68ID = @PROCESSID;

            delete from dbo.R68REFUNDDETAIL where R68ID = @PROCESSID;