USP_DATAFORMTEMPLATE_EDIT_PROGRAMSALESMETHOD

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@SALESMETHODID	uniqueidentifier	IN	Sales method
@ONSALETYPECODE	tinyint	IN	On-sale period begins
@ONSALEDATE	datetime	IN	Date
@ONSALETIME	char(4)	IN	Time
@ONSALETIMEBEFORE	int	IN	Time before

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_PROGRAMSALESMETHOD
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @SALESMETHODID uniqueidentifier,
    @ONSALETYPECODE tinyint,
    @ONSALEDATE datetime,
    @ONSALETIME char(4),
    @ONSALETIMEBEFORE int
)

as
    set nocount on;

    declare @ONSALEENDTYPECODE tinyint;
    declare @ONSALEENDINTERVAL int;

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_PROGRAMSALESMETHOD
        @ID = @ID,
        @ONSALEENDTYPECODE = @ONSALEENDTYPECODE output,
        @ONSALEENDINTERVAL = @ONSALEENDINTERVAL output

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_PROGRAMSALESMETHOD_2
        @ID,
        @CHANGEAGENTID,
        @SALESMETHODID,
        @ONSALETYPECODE,
        @ONSALEDATE,
        @ONSALETIME,
        @ONSALETIMEBEFORE,
        @ONSALEENDTYPECODE,
        @ONSALEENDINTERVAL

    return 0;