471: END IF;
472: END;
473: END IF;
474:
475: l_field_name := 'GMI Migration parameters';
476: l_field_value := NULL;
477: IF (g_auto_lot_alpha_prefix is NULL) THEN
478: BEGIN
479: SELECT
481: child_lot_prefix, child_lot_starting_number
482: INTO
483: g_auto_lot_alpha_prefix, g_start_auto_lot_number,
484: g_child_lot_prefix, g_child_lot_starting_number
485: FROM gmi_migration_parameters
486: WHERE rownum = 1;
487: EXCEPTION
488: WHEN NO_DATA_FOUND THEN
489: g_auto_lot_alpha_prefix := 'L';