USP_DATAFORMTEMPLATE_ADD_PROGRAMDISCOUNT

The save procedure used by the add dataform template "Program Discount Add Data Form".

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier INOUT The output parameter indicating the ID of the record added.
@PROGRAMID uniqueidentifier IN Input parameter indicating the context ID for the record being added.
@CHANGEAGENTID uniqueidentifier IN Input parameter indicating the ID of the change agent invoking the procedure.
@DISCOUNTID uniqueidentifier IN Discount

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_PROGRAMDISCOUNT
(
    @ID uniqueidentifier = null output,
    @PROGRAMID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @DISCOUNTID uniqueidentifier = null
)
as

set nocount on;

if @ID is null
    set @ID = newid()

exec dbo.USP_PROGRAMDISCOUNT_ADD @ID, @PROGRAMID, @CHANGEAGENTID, @DISCOUNTID;

return 0