Delimiter //
/**
 * Main contact isn't provided
 * 
 * @author Jean-François
 * @ticket #2113
 * @ticket #3907
 */
Drop Procedure If Exists LOADER_CONTACTS_NORMALIZE_MAP_MAIN_NOTPROVIDED//
Create Procedure LOADER_CONTACTS_NORMALIZE_MAP_MAIN_NOTPROVIDED(
    In batchnum Int
)
Begin

    Set @loader_type = GET_LOADER_INFO('LOADER_TYPE', batchnum);
    If  @loader_type = 'CONTACTS' Then
        Call LOADER_CONTACTS_NORMALIZE_MAP_MAIN_FROMCONTACT_NOTPROVIDED();
    ElseIf @loader_type = 'ACCOUNTS' Then
        Call LOADER_CONTACTS_NORMALIZE_MAP_MAIN_FROMACCOUNT_NOTPROVIDED();
    End If;
End//
Delimiter ;