| index

Package MIP_FILES

Program units

drawing_file_exists |
update_file_association |
set_file_association |
export_table_to_csv |

drawing_file_exists

    FUNCTION drawing_file_exists(p_drwg_code VARCHAR2) RETURN BOOLEAN

update_file_association

    FUNCTION update_file_association(p_uri         IN VARCHAR2
                                    ,p_description IN VARCHAR2
                                    ,p_docu_type   IN VARCHAR2
                                    ,p_qute_id     IN NUMBER
                                    ,p_enqu_id     IN NUMBER
                                    ,p_drwg_code   IN VARCHAR2) RETURN BOOLEAN

set_file_association

    FUNCTION set_file_association(p_uri         IN VARCHAR2
                                 ,p_description IN VARCHAR2
                                 ,p_docu_type   IN VARCHAR2
                                 ,p_rt_code     IN VARCHAR2
                                 ,p_qute_id     IN NUMBER
                                 ,p_enqu_id     IN NUMBER
                                 ,p_drwg_code   IN VARCHAR2
                                 ,p_doro_type   IN VARCHAR2) RETURN BOOLEAN

export_table_to_csv

    PROCEDURE export_table_to_csv(p_table          IN VARCHAR2
                                 ,p_column_headers IN VARCHAR2
                                 ,p_delimiter      IN VARCHAR2 DEFAULT ',')