USP_ACTION_ITEM_DELETE

Executes the "Action Item Delete" 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_ACTION_ITEM_DELETE
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier
)
as begin
    --check deletion rules, if any

    declare @AIFID uniqueidentifier
    declare @AIMTID uniqueidentifier
  declare @EMAILTEMPLATEID int

    select @AIFID = ID FROM dbo.ACTIONITEMFOLDER where ACTIONITEMID = @ID

    select @AIMTID = ID, @EMAILTEMPLATEID = EMAILTEMPLATEID  
    FROM dbo.ACTIONITEMMESSAGETEXT where ACTIONITEMID = @ID

    IF @AIFID IS NOT NULL
    EXEC USP_ACTION_ITEM_FOLDER_DELETE @ID = @AIFID, @CHANGEAGENTID = @CHANGEAGENTID

    IF @AIMTID IS NOT NULL
    EXEC USP_ACTIONITEMMESSAGETEXT_DELETEBYID_WITHCHANGEAGENTID @ID = @AIMTID, @CHANGEAGENTID = @CHANGEAGENTID

  IF ISNULL(@EMAILTEMPLATEID,0) > 0
  DELETE FROM dbo.EMAILTEMPLATE WHERE ID = @EMAILTEMPLATEID

    IF EXISTS (SELECT 1 FROM ACTIONITEMMEDIATARGET WHERE ACTIONITEMID = @ID)
    DELETE FROM ACTIONITEMMEDIATARGET WHERE ACTIONITEMID = @ID

    EXEC dbo.USP_ACTIONITEMTARGET_DELETE_BY_ACTIONITEM @ACTIONITEMID = @ID, @CHANGEAGENTID = @CHANGEAGENTID, @ADVOCACYGROUPID = null

    -- use the system generated delete routine to allow proper recording of the deleting agent

    exec USP_ACTION_ITEM_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID
    return 0;

end