Package pdf_builder_pkg

Functions, procedures

procedure init

procedure init

function get_pdf

function get_pdf return blob

procedure save_pdf

procedure save_pdf(
    p_dir in varchar2:=MY_DIR,
    p_filename in varchar2:=my.pdf
)

procedure show_pdf

procedure show_pdf

function conv2user_units

function conv2user_units(
    p_value in number,
    p_unit in varchar2
) return number

procedure set_format

procedure set_format(
    p_format in varchar2:=A4,
    p_orientation in varchar2:=PORTRAIT
)

procedure set_pagesize

procedure set_pagesize(
    p_width in number,
    p_height in number,
    p_unit in varchar2:=cm
)

procedure set_margins

procedure set_margins(
    p_top in number:=3,
    p_left in number:=1,
    p_bottom in number:=4,
    p_right in number:=1,
    p_unit in varchar2:=cm
)

function get_settings

function get_settings return tp_settings

procedure new_page

procedure new_page

procedure set_font

procedure set_font(
    p_family in varchar2,
    p_style in varchar2:=N,
    p_fontsizept in pls_integer:=null,
    p_encoding in varchar2:=WINDOWS-1252
)

procedure add2page

procedure add2page(
    p_txt in nclob
)

procedure put_txt

procedure put_txt(
    p_x in number,
    p_y in number,
    p_txt in nclob
)

function string_width

function string_width(
    p_txt in nclob
) return number

procedure write

procedure write(
    p_txt in nclob,
    p_x in number:=null,
    p_y in number:=null,
    p_line_height in number:=null,
    p_start in number:=null,
    p_width in number:=null,
    p_alignment in varchar2:=null
)

procedure set_color

procedure set_color(
    p_rgb in varchar2:=000000
)

procedure set_color

procedure set_color(
    p_red in number:=0,
    p_green in number:=0,
    p_blue in number:=0
)

procedure set_bk_color

procedure set_bk_color(
    p_rgb in varchar2:=ffffff
)

procedure set_bk_color

procedure set_bk_color(
    p_red in number:=255,
    p_green in number:=255,
    p_blue in number:=255
)

procedure horizontal_line

procedure horizontal_line(
    p_x in number,
    p_y in number,
    p_width in number,
    p_line_width in number:=0.5,
    p_line_color in varchar2:=000000
)

procedure vertical_line

procedure vertical_line(
    p_x in number,
    p_y in number,
    p_height in number,
    p_line_width in number:=0.5,
    p_line_color in varchar2:=000000
)

procedure rect

procedure rect(
    p_x in number,
    p_y in number,
    p_width in number,
    p_height in number,
    p_line_color in varchar2:=null,
    p_fill_color in varchar2:=null,
    p_line_width in number:=0.5
)

procedure put_image

procedure put_image(
    p_dir in varchar2,
    p_file_name in varchar2,
    p_x in number,
    p_y in number,
    p_width in number:=null,
    p_height in number:=null
)

procedure put_image

procedure put_image(
    p_url in varchar2,
    p_x in number,
    p_y in number,
    p_width in number:=null,
    p_height in number:=null
)

procedure put_image

procedure put_image(
    p_img in blob,
    p_x in number,
    p_y in number,
    p_width in number:=null,
    p_height in number:=null
)

Types

record tp_settings

type tp_settings is record(
    page_width number,
    page_height number,
    margin_left number,
    margin_right number,
    margin_top number,
    margin_bottom number,
    encoding varchar2(100),
    current_font pls_integer,
    current_fontsizept pls_integer,
    x number,
    y number,
    page_nr pls_integer
)