USP_DATAFORMTEMPLATE_EDIT_RELATIONSHIPJOBINFO_3

The save procedure used by the edit dataform template "Relationship Job Info Edit Data Form".

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.
@JOBTITLE	nvarchar(100)	IN	Job title
@CAREERLEVELCODEID	uniqueidentifier	IN	Career level
@JOBCATEGORYCODEID	uniqueidentifier	IN	Category
@STARTDATE	date	IN	Start date
@ENDDATE	date	IN	End date
@JOBDIVISION	nvarchar(100)	IN	Division
@JOBDEPARTMENT	nvarchar(100)	IN	Department
@JOBSCHEDULECODEID	uniqueidentifier	IN	Schedule
@JOBRESPONSIBILITY	nvarchar(250)	IN	Responsibilities
@ISPRIVATERECORD	bit	IN	Is private

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_RELATIONSHIPJOBINFO_3 (
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @JOBTITLE nvarchar(100),
    @CAREERLEVELCODEID uniqueidentifier,
    @JOBCATEGORYCODEID uniqueidentifier,
    @STARTDATE date,
    @ENDDATE date,
    @JOBDIVISION nvarchar(100),
    @JOBDEPARTMENT nvarchar(100),
    @JOBSCHEDULECODEID uniqueidentifier,
    @JOBRESPONSIBILITY nvarchar(250),
    @ISPRIVATERECORD bit
)
as

        set nocount on;

        declare @SYNCENDDATETORELATIONSHIP bit;

        exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_RELATIONSHIPJOBINFO
                @ID = @ID,
                @SYNCENDDATETORELATIONSHIP = @SYNCENDDATETORELATIONSHIP output;

        exec dbo.USP_DATAFORMTEMPLATE_EDIT_RELATIONSHIPJOBINFO_4
                @ID,
                @CHANGEAGENTID,
                @JOBTITLE,
                @CAREERLEVELCODEID,
                @JOBCATEGORYCODEID,
                @STARTDATE,
                @ENDDATE,
                @JOBDIVISION,
                @JOBDEPARTMENT,
                @JOBSCHEDULECODEID,
                @JOBRESPONSIBILITY,
                @ISPRIVATERECORD,
                @SYNCENDDATETORELATIONSHIP;

        return 0;