Delimiter //
/**
vérifie que le code catégorie de l'historique est fournis
**/
Drop Procedure if exists LOADER_SUMMARIES_NORMALIZE_DF_SUMM_CODE_NOT_NULL//
Create Procedure LOADER_SUMMARIES_NORMALIZE_DF_SUMM_CODE_NOT_NULL (
    In batchnum int
)
Begin

	Set @flagCountField='LOADER_SUMMARIES_ERRCOUNT';
    Set @flagMsgField='LOADER_SUMMARIES_ERRMSGS';
    Set @lastStatusField=null;
    Set @lastStatus=null;
    Set @checkedFieldName = 'DF_SUMMARIES_CODE';

    CALL LOADER_CHECK_NULL (
        'LOADER_SUMMARIES'
        , @checkedFieldName
        , 'LOADER_SUMMARIES_BATCH_NUM'
        , batchnum
        , @flagCountField
        , @flagMsgField
        , @lastStatusField
        , @lastStatus
    );



End //
Delimiter ;