USP_MARRIAGEADDITIONALRELATIONSHIP_DELETE

Executes the "Marriage Additional 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_MARRIAGEADDITIONALRELATIONSHIP_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.MARRIAGEADDITIONALRELATIONSHIPASSOCIATION where MARRIAGEADDITIONALRELATIONSHIPID=@ID;

    if not @contextCache is null
        set CONTEXT_INFO @contextCache

  exec USP_MARRIAGEADDITIONALRELATIONSHIP_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID
  return 0;

end