USP_PDACCOUNTSTRUCTURE_UPDATEENTRY2

Adds/updates a system-defined entry in the PDACCOUNTSTRUCTURE table with system

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DESCRIPTION	nvarchar(100)	IN
@SEQUENCE	tinyint	IN
@LENGTH	tinyint	IN
@PDACCOUNTTABLESAVAILABLEFORSEGMENTID	uniqueidentifier	IN
@SEPARATORCODE	tinyint	IN
@SEGMENTTYPE	tinyint	IN
@PDACCOUNTSYSTEMID	uniqueidentifier	IN
@TSLONG	int	IN
@CHANGEAGENTID	uniqueidentifier	IN
@ISPROJECTSEGMENT	bit	IN

Definition

Copy



CREATE procedure dbo.USP_PDACCOUNTSTRUCTURE_UPDATEENTRY2(
    @ID uniqueidentifier,
    @DESCRIPTION nvarchar(100),
    @SEQUENCE tinyint,
    @LENGTH tinyint,
    @PDACCOUNTTABLESAVAILABLEFORSEGMENTID uniqueidentifier,
    @SEPARATORCODE tinyint,
    @SEGMENTTYPE tinyint,
    @PDACCOUNTSYSTEMID uniqueidentifier,
    @TSLONG int=0,            
    @CHANGEAGENTID uniqueidentifier = NULL,
  @ISPROJECTSEGMENT bit = 0

)
as
begin

declare @CHANGEDATE datetime;

exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;
set @CHANGEDATE = getdate();        

if (select count(ID) from dbo.PDACCOUNTSTRUCTURE where ID = @ID) = 0
    insert into dbo.PDACCOUNTSTRUCTURE(ID,DESCRIPTION,SEQUENCE,LENGTH,PDACCOUNTTABLESAVAILABLEFORSEGMENTID,SEPARATORCODE,SEGMENTTYPE,PDACCOUNTSYSTEMID, ISPROJECTSEGMENT, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
        values(@ID,@DESCRIPTION,@SEQUENCE,@LENGTH,@PDACCOUNTTABLESAVAILABLEFORSEGMENTID,@SEPARATORCODE,@SEGMENTTYPE,@PDACCOUNTSYSTEMID, @ISPROJECTSEGMENT, @CHANGEAGENTID, @CHANGEAGENTID, @CHANGEDATE, @CHANGEDATE)
else
    update dbo.PDACCOUNTSTRUCTURE
        set DESCRIPTION = @DESCRIPTION, 
            SEQUENCE = @SEQUENCE,
            LENGTH = @LENGTH,
            PDACCOUNTTABLESAVAILABLEFORSEGMENTID = @PDACCOUNTTABLESAVAILABLEFORSEGMENTID,    
            SEPARATORCODE = @SEPARATORCODE,    
            SEGMENTTYPE = @SEGMENTTYPE,
            PDACCOUNTSYSTEMID = @PDACCOUNTSYSTEMID,
      ISPROJECTSEGMENT = @ISPROJECTSEGMENT,
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = @CHANGEDATE
        where ID = @ID;

return 0
end