USP_BATCHTEMPLATE_ADDBATCHNUMBERINGSCHEME
This procedure adds a default numbering scheme to newly added templates during load spec process
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | INOUT | |
| @CHANGEAGENTID | uniqueidentifier | IN |
Definition
Copy
create procedure dbo.USP_BATCHTEMPLATE_ADDBATCHNUMBERINGSCHEME(
@ID uniqueidentifier output
, @CHANGEAGENTID uniqueidentifier
)
as
begin
if @CHANGEAGENTID is null
exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output
declare @BATCHNUMBERINGSCHEMEID uniqueidentifier;
select
@BATCHNUMBERINGSCHEMEID = BATCHNUMBERINGSCHEMEID
from dbo.BATCHTEMPLATE
where ID = @ID;
if @BATCHNUMBERINGSCHEMEID is not null
return;
select
@BATCHNUMBERINGSCHEMEID = ID
from dbo.BATCHNUMBERINGSCHEME
where NAME = 'Default';
if @BATCHNUMBERINGSCHEMEID is not null
update BATCHTEMPLATE set
BATCHNUMBERINGSCHEMEID = @BATCHNUMBERINGSCHEMEID
, CHANGEDBYID = @CHANGEAGENTID
where ID = @ID;
end;