USP_MKTSEGMENTATIONEXPORTPROCESSSTATUS_DELETE

Executes the "Marketing Effort Export Status: 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_MKTSEGMENTATIONEXPORTPROCESSSTATUS_DELETE
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier
)
as begin

    if @CHANGEAGENTID is null  
      exec dbo.[USP_CHANGEAGENT_GETORCREATECHANGEAGENT] @CHANGEAGENTID output;

    declare @CURRENTDATE datetime;
    set @CURRENTDATE = GetDate();

    /***************************************************************************/
    /* Clean up MKTMEMBERSHIPRENEWALEFFORTMAILINGPROCESS table before delete   */
    /* the record in MKTSEGMENTATION table to prevent FK constraint error.     */
    /***************************************************************************/
    update MKTMEMBERSHIPRENEWALEFFORTMAILINGPROCESS 
        set SEGMENTATIONEXPORTPROCESSSTATUSID = null,
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = @CURRENTDATE
    from MKTMEMBERSHIPRENEWALEFFORTMAILINGPROCESS RENEWALPROCESS
        inner join dbo.MKTSEGMENTATIONEXPORTPROCESSSTATUS EXPORTSTATUS 
            on RENEWALPROCESS.SEGMENTATIONEXPORTPROCESSSTATUSID = EXPORTSTATUS.ID 
    where EXPORTSTATUS.ID = @ID 

    /**************************************************************************************/
    /* Call USP_BUSINESSPROCESSSTATUS_DELETE to delete the business process status record */
    /**************************************************************************************/
    exec USP_BUSINESSPROCESSSTATUS_DELETE @ID, @CHANGEAGENTID

    return 0;

end