739: -- Invalid status change.
740: BEGIN
741: SELECT a.meaning,b.meaning
742: INTO l_supply_status_code_from, l_supply_status_code_to
743: FROM mfg_lookups a, mfg_lookups b
744: WHERE a.lookup_type = 'MTL_KANBAN_SUPPLY_STATUS' AND a.lookup_code = p_supply_status
745: AND b.lookup_type = 'MTL_KANBAN_SUPPLY_STATUS' AND b.lookup_code = p_supply_status_to;
746:
747: EXCEPTION