USP_DATAFORMTEMPLATE_EDIT_JOBSKILL

USP_DATAFORMTEMPLATE_EDIT_JOBSKILL

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.
@SKILLCODEID uniqueidentifier IN Skill
@SKILLLEVELID uniqueidentifier IN Skill level

Definition

Copy


CREATE procedure USP_DATAFORMTEMPLATE_EDIT_JOBSKILL
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier,
    @SKILLCODEID uniqueidentifier,
    @SKILLLEVELID uniqueidentifier
)

as
    set nocount on;

    declare @ISREQUIRED bit;

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_JOBSKILL
        @ID = @ID,
        @ISREQUIRED = @ISREQUIRED output

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_JOBSKILL_2
        @ID,
        @CHANGEAGENTID,
        @SKILLCODEID,
        @SKILLLEVELID,
        @ISREQUIRED

    return 0;