USP_DATAFORMTEMPLATE_ADD_STUDENTCOURSEREQUEST
The save procedure used by the add dataform template "Student Course Request Add Data Form".
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | INOUT | The output parameter indicating the ID of the record added. |
| @CURRENTAPPUSERID | uniqueidentifier | IN | Input parameter indicating the ID of the current user. |
| @CHANGEAGENTID | uniqueidentifier | IN | Input parameter indicating the ID of the change agent invoking the procedure. |
| @SESSIONID | uniqueidentifier | IN | |
| @STUDENTID | uniqueidentifier | IN | |
| @COURSEREQUESTS | xml | IN | |
| @OVERRIDEEXCEPTIONS | bit | IN |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_STUDENTCOURSEREQUEST
(
@ID uniqueidentifier = null output, --STUDENTID
@CURRENTAPPUSERID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier = null,
@SESSIONID uniqueidentifier = null,
@STUDENTID uniqueidentifier = null,
@COURSEREQUESTS xml = null,
@OVERRIDEEXCEPTIONS bit = 0
)
as
set nocount on
if @OVERRIDEEXCEPTIONS = 0 and (select count(COURSEID) from dbo.UFN_STUDENTCOURSEREQUESTS_GETEXCEPTIONS(@STUDENTID,@SESSIONID,@COURSEREQUESTS)) > 0
raiserror('BBERR_STUDENTCOURSEREQUEST_EXCEPTIONS', 13, 1)
exec dbo.USP_STUDENTCOURSEREQUEST_UPDATEFROMXML @CURRENTAPPUSERID, @STUDENTID, @COURSEREQUESTS, @CHANGEAGENTID, null
return 0