USP_PEOPLEFINDER_DELETE

Executes the "PeopleFinder: 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.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



CREATE procedure dbo.USP_PEOPLEFINDER_DELETE
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier,
    @CURRENTAPPUSERID uniqueidentifier
)
as
    set nocount on;

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

    declare @SUBMITID uniqueidentifier;
    declare @RESUBMITID uniqueidentifier;
    declare @GETID uniqueidentifier;

    select 
        @SUBMITID = SUBMIT.ID,
        @RESUBMITID = RESUBMIT.ID,
        @GETID = GET.ID
    from 
        dbo.PEOPLEFINDER
    inner join 
        dbo.PEOPLEFINDERSUBMITPROCESS SUBMIT on PEOPLEFINDER.ID = SUBMIT.PEOPLEFINDERID
    inner join
        dbo.PEOPLEFINDERRESUBMITPROCESS RESUBMIT on PEOPLEFINDER.ID = RESUBMIT.PEOPLEFINDERID
    inner join
        dbo.PEOPLEFINDERGETPROCESS GET on GET.PEOPLEFINDERID = PEOPLEFINDER.ID
    where 
        PEOPLEFINDER.ID = @ID;

    exec dbo.USP_BUSINESSPROCESS_PARAMETERSETCANBEDELETED 'PEOPLEFINDERSUBMITPROCESSSTATUS', @SUBMITID;
    exec dbo.USP_BUSINESSPROCESS_PARAMETERSETCANBEDELETED 'PEOPLEFINDERRESUBMITPROCESSSTATUS', @RESUBMITID;
    exec dbo.USP_BUSINESSPROCESS_PARAMETERSETCANBEDELETED 'PEOPLEFINDERGETPROCESSSTATUS', @GETID;

    exec dbo.USP_BUSINESSPROCESSINSTANCE_DELETE 'ECBAA00E-AE64-489A-9545-377C024F7E7C', @SUBMITID, @CHANGEAGENTID;
    exec dbo.USP_BUSINESSPROCESSINSTANCE_DELETE '7EDF6B16-6522-489E-B80F-85B533FD3FFE', @RESUBMITID, @CHANGEAGENTID;
    exec dbo.USP_BUSINESSPROCESSINSTANCE_DELETE '9C1BACEC-AB82-43EF-A851-5B2EA92F1FAE', @GETID, @CHANGEAGENTID;

    exec dbo.USP_PEOPLEFINDER_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID;

    return 0;