USP_RESERVATIONRATESCALEAPPLICATION_DELETE

Executes the "Reservation Rate Scale Application: Delete" record operation.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Input parameter indicating the ID of the record being deleted.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the delete.

Definition

Copy



                CREATE procedure dbo.USP_RESERVATIONRATESCALEAPPLICATION_DELETE
                (
                    @ID uniqueidentifier,
                    @CHANGEAGENTID uniqueidentifier
                )
                as begin
                    declare @STATUSCODE tinyint;

                    select @STATUSCODE = SALESORDER.STATUSCODE
                    from dbo.SALESORDER
                    inner join dbo.RESERVATIONRATESCALE on RESERVATIONRATESCALE.ID = SALESORDER.ID
                    inner join dbo.RESERVATIONRATESCALEAPPLICATION on RESERVATIONRATESCALEAPPLICATION.RESERVATIONRATESCALEID = RESERVATIONRATESCALE.ID
                    where RESERVATIONRATESCALEAPPLICATION.ID = @ID

                    if @STATUSCODE in (1, 5)
                        raiserror('BBERR_INVALIDSTATUS', 13, 1);                

                    declare @RESERVATIONRATESCALEID uniqueidentifier
                    select 
                        @RESERVATIONRATESCALEID = RESERVATIONRATESCALEID 
                    from dbo.RESERVATIONRATESCALEAPPLICATION 
                    where ID = @ID
                    -- use the system generated delete routine to allow proper recording of the deleting agent

                    exec USP_RESERVATIONRATESCALEAPPLICATION_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID;

                    exec dbo.USP_RESERVATION_UPDATEFLATRATE @RESERVATIONRATESCALEID, @CHANGEAGENTID;
                    return 0;

                end