USP_PEOCLIENTUSERSLINK_DELETE
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | |
| @CHANGEAGENTID | uniqueidentifier | IN | |
| @CLIENTUSERSID | int | IN | |
| @PEOUSERCODE | nvarchar(512) | IN |
Definition
Copy
create procedure dbo.USP_PEOCLIENTUSERSLINK_DELETE
(
@ID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier,
@CLIENTUSERSID integer = null,
@PEOUSERCODE nvarchar(512) = null
)
as begin
if (@ID is null) or @ID = '00000000-0000-0000-0000-000000000000' begin
select @ID = cue.ID from clientusersextension cue
where (isnull(@CLIENTUSERSID,0) = 0 or cue.CLIENTUSERID = @CLIENTUSERSID)
and (isnull(@PEOUSERCODE,'') = '' or cue.IDENTIFIER = rtrim(ltrim(@PEOUSERCODE)) )
end
-- use the system generated delete routine to allow proper recording of the deleting agent
exec USP_CLIENTUSERSEXTENSION_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID
return 0;
end