USP_DOCUMENTPRINTINGHISTORYBYPRINTJOB_DELETE

Executes the "Delete Sales Document Printing History By Print Job" record operation.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Input parameter indicating the ID of the record being deleted.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the delete.

Definition

Copy



CREATE procedure dbo.USP_DOCUMENTPRINTINGHISTORYBYPRINTJOB_DELETE
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier
)
as begin
            if @CHANGEAGENTID is null  
                exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

            declare @e int;
            declare @contextCache varbinary(128);

            set @contextCache = CONTEXT_INFO();

            if not @CHANGEAGENTID is null
                set CONTEXT_INFO @CHANGEAGENTID

            delete from dbo.DOCUMENTPRINTINGHISTORY
            from dbo.DOCUMENTPRINTINGHISTORY
            inner join dbo.UFN_DOCUMENTPRINTINGHISTORY_GETUNPRINTABLE_BYREPRINTID(@ID) [FAILEDDOCUMENT]
                on DOCUMENTPRINTINGHISTORY.ID = [FAILEDDOCUMENT].ID

            if not @contextCache is null
                set CONTEXT_INFO @contextCache

            select @e=@@error;

            if @e<>0 return -456; --always return non-zero sp result if an error occurs


end