USP_DATAFORMTEMPLATE_EDIT_RELATIONSHIPJOBINFO_2

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

Definition

Copy



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

    set nocount on;

    declare @JOBRESPONSIBILITY nvarchar(250);
    declare @ISPRIVATERECORD bit;

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_RELATIONSHIPJOBINFO
        @ID = @ID,
        @JOBRESPONSIBILITY = @JOBRESPONSIBILITY output,
        @ISPRIVATERECORD = @ISPRIVATERECORD output

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

    return 0;