USP_MKTFINDERFILEIMPORTPROCESS_DELETE
Executes the "Finder File 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. |
Definition
Copy
CREATE procedure dbo.[USP_MKTFINDERFILEIMPORTPROCESS_DELETE]
(
@ID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier
)
as
set nocount on;
if @CHANGEAGENTID is not null
set CONTEXT_INFO @CHANGEAGENTID;
--Remove all the data rows for this finder file
exec dbo.[USP_MKTFINDERFILEIMPORTPROCESS_ROLLBACKIMPORT] @ID;
--Delete finder file record
exec dbo.USP_MKTFINDERFILEIMPORTPROCESS_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID;
return 0;