USP_RECORDOPERATION_EVENTREGISTRATIONOPPORTUNITYUNLINK

CREATE procedure dbo.USP_RECORDOPERATION_EVENTREGISTRATIONOPPORTUNITYUNLINK
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier
)
as begin

  -- Remove event registration link

  exec USP_EVENTREGISTRATIONOPPORTUNITY_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID;

  -- cache current context information

  declare @contextCache varbinary(128);
  set @contextCache = CONTEXT_INFO();

  -- set CONTEXT_INFO to @CHANGEAGENTID

  set CONTEXT_INFO @CHANGEAGENTID;

  -- Remove payment links

  delete from dbo.REVENUEOPPORTUNITY
  where REVENUEOPPORTUNITY.ID in
  (
    select
      EVENTREGISTRANTPAYMENT.PAYMENTID
    from dbo.EVENTREGISTRANTPAYMENT
    where EVENTREGISTRANTPAYMENT.REGISTRANTID = @ID
  );

  -- reset CONTEXT_INFO to previous value

  if not @contextCache is null
    set CONTEXT_INFO @contextCache;

  return 0;
end