[dbo].[RevenueRatingImportInvoiceDetailUpdateAgent]

Property	Value
ANSI Nulls On
Quoted Identifier On

Name	Data Type	Max Length (Bytes)
@inRevenueRatingImportInvoiceDetailID	int	4
@inAgentID	int	4
@inImported	bit	1

Type	Action	Owning Principal
Grant	Execute	MssExec

SQL Script

/*
*    Module: Revenue Entry
*
*    Description: Updates the agent for a revenue import invoice detail item.
*    Error Codes:
*/
CREATE PROCEDURE [dbo].[RevenueRatingImportInvoiceDetailUpdateAgent]
    @inRevenueRatingImportInvoiceDetailID int,
    @inAgentID int,
    @inImported bit
AS
set nocount on

if( @inImported = 0 )
begin
    update RevenueRatingImportInvoiceDetail set AgentFID = @inAgentID where RevenueRatingImportInvoiceDetailID = @inRevenueRatingImportInvoiceDetailID
end
else
begin
    update RevenueRatingImportedInvoiceDetail set AgentFID = @inAgentID where RevenueRatingImportedInvoiceDetailID = @inRevenueRatingImportInvoiceDetailID
end
GO
GRANT EXECUTE ON  [dbo].[RevenueRatingImportInvoiceDetailUpdateAgent] TO [MssExec]
GO