| index

Package mip_quotation_document

Program units

generate_quote_pdf |

Types

caveat_text |
img_props |
cost_line |
address |
works |
costs |
caveats |
dimensions |
quote_data |

caveat_text

    type caveat_text is varray(20) of varchar2(4000);

img_props

    type img_props is record(width number,
                             height number);

cost_line

    type cost_line is record(
                          cost_description varchar2(80),
                          cost_price number);

address

    type address is varray(7) of varchar2(160);

works

    type works is varray(20) of varchar2(160);

costs

    type costs is varray(20) of cost_line;

caveats

    type caveats is varray(20) of varchar2(2000);

dimensions

    type dimensions is varray(10) of number;

quote_data

    type quote_data is record
    (quote_ref NUMBER,
     transaction_ref VARCHAR2(80),
     mprn number(30),
     supplier_address address := address(null,null,null,null,null,null,null),
     current_date DATE,
     agent_first_name varchar2(80),
     site_address address := address(null,null,null,null,null,null,null),
     mam varchar2(80),
     quote_works works := works(null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null),
     caveat_desc_works caveat_text:= caveat_text(null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null),
     lead_time number,
     total_cost number,
     caveat_cont_sum caveat_text:= caveat_text(null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null),
     quote_costs costs := costs(null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null),
     house_length number,
     house_depth number,
     house_height number,
     house_ventilation number,
     base_length number,
     base_depth number,
     base_height number,
     outlet_termninal_size number,
     caveat_term_cond caveat_text:= caveat_text(null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null),
     liquid_damage_day number,
     liquid_damage_cap number,
     base_dimensions dimensions := dimensions(null,null,null,null,null,null,null,null,null,null),
     base_diagram varchar2(80),
     house_dimensions dimensions := dimensions(null,null,null,null,null,null,null,null,null,null),
     house_diagram varchar2(80),
     module_dimensions dimensions := dimensions(null,null,null,null,null,null,null,null,null,null),
     module_reference varchar2(80),
     module_diagram varchar2(80),
     requested_qmax number,
     module_qmax number,
     module_qmin number,
     module_inlet_height number,
     module_outlet_height number,
     module_inlet_size number,
     module_outlet_size number,
     module_inlet_type varchar2(80),
     module_outlet_type varchar2(80),
     module_inlet_orientation varchar2(80),
     module_outlet_orientation varchar2(80),
     meter_reference varchar(80),
     caveat_cont_sum_qa caveat_text:= caveat_text(null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null),
     mety_code varchar(80),
     svcpt_code varchar(10)
    );

generate_quote_pdf

    FUNCTION generate_quote_pdf(p_quote_id IN NUMBER) RETURN VARCHAR2