function get_bfile (p_path IN VARCHAR2) return BFILE is
    v_file_name VARCHAR(1000);
    v_file_dir VARCHAR(1000);
    BEGIN
        v_file_name := get_filename(p_path);

        -- no need to do this, only one directory for attached docs now
        --select directory_name into v_file_dir from all_directories
        --where directory_path = replace(p_path, v_file_name, '');

        RETURN BFILENAME('ATTACHED_DOC_DIR', v_file_name);

    END;