FUNCTION insGenVDRow(p_creation_date IN DATE, p_latitude IN VARCHAR, p_longitude IN VARCHAR, p_gps_date IN VARCHAR, p_gps_full_date IN DATE, p_wgs84_latitude IN NUMBER, p_wgs84_longitude IN NUMBER, p_vehicle_id IN NUMBER, p_event_type_id IN NUMBER, p_date_day IN DATE) RETURN NUMBER;
  FUNCTION insGenVDRow(p_creation_date IN DATE, p_latitude IN VARCHAR, p_longitude IN VARCHAR, p_gps_date IN VARCHAR, p_gps_full_date IN DATE, p_wgs84_latitude IN NUMBER, p_wgs84_longitude IN NUMBER, p_vehicle_id IN NUMBER, p_event_type_id IN NUMBER, p_date_day IN DATE) RETURN NUMBER AS
    v_vehicle_data_id NUMBER(10);
    BEGIN
    SELECT seq_vehicle_data_id.NEXTVAL INTO v_vehicle_data_id FROM dual;

    INSERT INTO vehicle_data (vehicle_data_id, creation_date, latitude, longitude, gps_date, gps_full_date, wgs84_latitude, wgs84_longitude, vehicle_id, event_type_id, date_day)
    VALUES (v_vehicle_data_id, p_creation_date, p_latitude, p_longitude, p_gps_date, p_gps_full_date, p_wgs84_latitude, p_wgs84_longitude, p_vehicle_id, p_event_type_id. p_date_day);

    p_msg_util.updateVehicleOnLastEvent(v_vehicle_data_id);

    INSERT INTO vd_poi
    VALUES (seq_vd_poi_id.NEXTVAL, v_vehicle_data_id, p_poi_id, 1, NULL, SYSDATE, NULL);

    RETURN v_vehicle_data_id;
  END;