USP_MARRIAGERELATIONSHIP_DELETE

Executes the "Marriage Relationship Delete Record Operation" 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_MARRIAGERELATIONSHIP_DELETE
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier
)
as begin
    declare @contextCache varbinary(128);
    set @contextCache = CONTEXT_INFO();

    if not @CHANGEAGENTID is null
        set CONTEXT_INFO @CHANGEAGENTID

    delete dbo.MARRIAGERELATIONSHIPASSOCIATION where MARRIAGERELATIONSHIPID=@ID;

    if not @contextCache is null
        set CONTEXT_INFO @contextCache

  exec USP_MARRIAGERELATIONSHIP_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID
  return 0;

end