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 ',')