[Home] [Help]
354: FUNCTION VALIDATE_SERIAL_NUMBER(p_serial_number VARCHAR2,
355: p_item_id NUMBER) RETURN BOOLEAN IS
356: CURSOR c1 IS
357: SELECT 1 col1
358: FROM mtl_serial_numbers
359: WHERE serial_number = p_serial_number
360: AND inventory_item_id = p_item_id;
361:
362: l_tmp_count NUMBER;