Delimiter //
/**
 * Checks if the contact's last name is not null
 *
 * @param int batchnum
 * @return void
 * @author Jean-François
 * @ticket #3787
 */
Drop Procedure if exists LOADER_CONTACTS_NORMALIZE_CONTACTS_CHECK_LAST_NAME_NOT_NULL//

Create Procedure LOADER_CONTACTS_NORMALIZE_CONTACTS_CHECK_LAST_NAME_NOT_NULL (
    In batchnum int
)
Begin
    CALL LOADER_CONTACTS_CHECK_NULL (
        'CONTACTS_INDIVIDUAL_LAST_NAME'
        , batchnum, 0, null
    );
End //

Delimiter ;
