USP_DATAFORMTEMPLATE_EDIT_RELATIONSHIPJOBINFO

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

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_RELATIONSHIPJOBINFO
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @JOBTITLE nvarchar(100),
    @CAREERLEVELCODEID uniqueidentifier,
    @JOBCATEGORYCODEID uniqueidentifier,
    @STARTDATE date,
    @ENDDATE date
)

as
    set nocount on;

    declare @JOBDIVISION nvarchar(100);
    declare @JOBDEPARTMENT nvarchar(100);
    declare @JOBSCHEDULECODEID uniqueidentifier;

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_RELATIONSHIPJOBINFO
        @ID = @ID,
        @JOBDIVISION = @JOBDIVISION output,
        @JOBDEPARTMENT = @JOBDEPARTMENT output,
        @JOBSCHEDULECODEID = @JOBSCHEDULECODEID output

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_RELATIONSHIPJOBINFO_2
        @ID,
        @CHANGEAGENTID,
        @JOBTITLE,
        @CAREERLEVELCODEID,
        @JOBCATEGORYCODEID,
        @STARTDATE,
        @ENDDATE,
        @JOBDIVISION,
        @JOBDEPARTMENT,
        @JOBSCHEDULECODEID

    return 0;