create or replace package body PLPDF_INVOICE_EXAMPLE_1 is
  /* 2016-NOV.  -29 20:34 */
  /* PL/PDF REPORTER 4.3.0 */
  /* THIS IS GENERATED CODE. DO NOT MODIFY DIRECTLY! PLEASE CHANGE THE TEMPLATE. */
  v_format1      plpdf_type.t_pageformat;
  l_color1       plpdf_type.t_color;
  l_box1         plpdf3.t_box;
  v_paragraph1   plpdf3.t_paragraph;
  l_tblGrid1     plpdf3.t_TableGrid := plpdf3.v_TableGrid_empty;
  l_table1       plpdf3.t_Table;
  l_parsedTable2 plpdf3.t_parsed_table;
  l_row1         plpdf3.t_TableRow;
  l_cell1        plpdf3.t_TableCell;
  l_box2         plpdf3.t_box;
  v_paragraph2   plpdf3.t_paragraph;
  l_font1        plpdf3.t_font;
  l_color2       plpdf_type.t_color;
  l_text_idx1    pls_integer;
  l_paragraph3   pls_integer;
  l_box3         plpdf3.t_box;
  v_paragraph4   plpdf3.t_paragraph;
  l_font2        plpdf3.t_font;
  l_color3       plpdf_type.t_color;
  l_text_idx2    pls_integer;
  l_text_idx3    pls_integer;
  l_paragraph5   pls_integer;
  l_cell2        pls_integer;
  l_cell3        plpdf3.t_TableCell;
  l_box4         plpdf3.t_box;
  v_paragraph6   plpdf3.t_paragraph;
  l_font3        plpdf3.t_font;
  l_color4       plpdf_type.t_color;
  l_text_idx4    pls_integer;
  l_paragraph7   pls_integer;
  l_box5         plpdf3.t_box;
  v_paragraph8   plpdf3.t_paragraph;
  l_text_idx5    pls_integer;
  l_paragraph9   pls_integer;
  l_box6         plpdf3.t_box;
  v_paragraph10  plpdf3.t_paragraph;
  l_text_idx6    pls_integer;
  l_paragraph11  pls_integer;
  l_cell4        pls_integer;
  l_box7         plpdf3.t_box;
  v_paragraph12  plpdf3.t_paragraph;
  l_tblGrid2     plpdf3.t_TableGrid := plpdf3.v_TableGrid_empty;
  l_table3       plpdf3.t_Table;
  l_parsedTable4 plpdf3.t_parsed_table;
  l_row2         plpdf3.t_TableRow;
  l_padding1     plpdf3.t_Padding;
  l_color5       plpdf_type.t_color;
  l_box8         plpdf3.t_box;
  l_cell5        plpdf3.t_TableCell;
  l_box9         plpdf3.t_box;
  v_paragraph13  plpdf3.t_paragraph;
  l_font4        plpdf3.t_font;
  l_color6       plpdf_type.t_color;
  l_text_idx7    pls_integer;
  l_paragraph14  pls_integer;
  l_box10        plpdf3.t_box;
  v_paragraph15  plpdf3.t_paragraph;
  l_text_idx8    pls_integer;
  l_paragraph16  pls_integer;
  l_box11        plpdf3.t_box;
  v_paragraph17  plpdf3.t_paragraph;
  l_text_idx9    pls_integer;
  l_text_idx10   pls_integer;
  l_text_idx11   pls_integer;
  l_text_idx12   pls_integer;
  l_text_idx13   pls_integer;
  l_paragraph18  pls_integer;
  l_cell6        pls_integer;
  l_cell7        plpdf3.t_TableCell;
  l_box12        plpdf3.t_box;
  v_paragraph19  plpdf3.t_paragraph;
  l_text_idx14   pls_integer;
  l_paragraph20  pls_integer;
  l_box13        plpdf3.t_box;
  v_paragraph21  plpdf3.t_paragraph;
  l_text_idx15   pls_integer;
  l_paragraph22  pls_integer;
  l_box14        plpdf3.t_box;
  v_paragraph23  plpdf3.t_paragraph;
  l_color7       plpdf_type.t_color;
  l_text_idx16   pls_integer;
  l_text_idx17   pls_integer;
  l_paragraph24  pls_integer;
  l_cell8        pls_integer;
  l_box15        plpdf3.t_box;
  v_paragraph25  plpdf3.t_paragraph;
  l_box16        plpdf3.t_box;
  v_paragraph26  plpdf3.t_paragraph;
  l_color8       plpdf_type.t_color;
  l_border_side1 plpdf3.t_border1;
  l_border2      plpdf3.t_Border;
  l_box17        plpdf3.t_box;
  l_tblGrid3     plpdf3.t_TableGrid := plpdf3.v_TableGrid_empty;
  l_table5       plpdf3.t_Table;
  l_row3         plpdf3.t_TableRow;
  l_padding2     plpdf3.t_Padding;
  l_color9       plpdf_type.t_color;
  l_box18        plpdf3.t_box;
  l_cell9        plpdf3.t_TableCell;
  l_box19        plpdf3.t_box;
  v_paragraph27  plpdf3.t_paragraph;
  l_text_idx18   pls_integer;
  l_paragraph28  pls_integer;
  l_cell10       pls_integer;
  l_cell11       plpdf3.t_TableCell;
  l_box20        plpdf3.t_box;
  v_paragraph29  plpdf3.t_paragraph;
  l_text_idx19   pls_integer;
  l_paragraph30  pls_integer;
  l_cell12       pls_integer;
  l_cell13       plpdf3.t_TableCell;
  l_box21        plpdf3.t_box;
  v_paragraph31  plpdf3.t_paragraph;
  l_text_idx20   pls_integer;
  l_paragraph32  pls_integer;
  l_cell14       pls_integer;
  l_cell15       plpdf3.t_TableCell;
  l_box22        plpdf3.t_box;
  v_paragraph33  plpdf3.t_paragraph;
  l_text_idx21   pls_integer;
  l_paragraph34  pls_integer;
  l_cell16       pls_integer;
  l_cell17       plpdf3.t_TableCell;
  l_box23        plpdf3.t_box;
  v_paragraph35  plpdf3.t_paragraph;
  l_text_idx22   pls_integer;
  l_paragraph36  pls_integer;
  l_cell18       pls_integer;
  l_row_idx4     pls_integer;
  l_parsedTable6 plpdf3.t_parsed_table;
  l_row5         plpdf3.t_TableRow;
  l_box24        plpdf3.t_box;
  l_cell19       plpdf3.t_TableCell;
  l_box25        plpdf3.t_box;
  v_paragraph37  plpdf3.t_paragraph;
  l_text_idx23   pls_integer;
  l_paragraph38  pls_integer;
  l_cell20       pls_integer;
  l_cell21       plpdf3.t_TableCell;
  l_box26        plpdf3.t_box;
  v_paragraph39  plpdf3.t_paragraph;
  l_box27        plpdf3.t_box;
  l_image1       pls_integer;
  l_paragraph40  pls_integer;
  l_cell22       pls_integer;
  l_cell23       plpdf3.t_TableCell;
  l_box28        plpdf3.t_box;
  v_paragraph41  plpdf3.t_paragraph;
  l_text_idx24   pls_integer;
  l_paragraph42  pls_integer;
  l_cell24       pls_integer;
  l_cell25       plpdf3.t_TableCell;
  l_box29        plpdf3.t_box;
  v_paragraph43  plpdf3.t_paragraph;
  l_text_idx25   pls_integer;
  l_paragraph44  pls_integer;
  l_cell26       pls_integer;
  l_cell27       plpdf3.t_TableCell;
  l_box30        plpdf3.t_box;
  v_paragraph45  plpdf3.t_paragraph;
  l_text_idx26   pls_integer;
  l_paragraph46  pls_integer;
  l_cell28       pls_integer;
  l_row6         plpdf3.t_TableRow;
  l_color10      plpdf_type.t_color;
  l_box31        plpdf3.t_box;
  l_cell29       plpdf3.t_TableCell;
  l_box32        plpdf3.t_box;
  v_paragraph47  plpdf3.t_paragraph;
  l_text_idx27   pls_integer;
  l_paragraph48  pls_integer;
  l_cell30       pls_integer;
  l_cell31       plpdf3.t_TableCell;
  l_box33        plpdf3.t_box;
  v_paragraph49  plpdf3.t_paragraph;
  l_text_idx28   pls_integer;
  l_paragraph50  pls_integer;
  l_cell32       pls_integer;
  l_cell33       plpdf3.t_TableCell;
  l_box34        plpdf3.t_box;
  v_paragraph51  plpdf3.t_paragraph;
  l_text_idx29   pls_integer;
  l_paragraph52  pls_integer;
  l_cell34       pls_integer;
  l_cell35       plpdf3.t_TableCell;
  l_box35        plpdf3.t_box;
  v_paragraph53  plpdf3.t_paragraph;
  l_text_idx30   pls_integer;
  l_paragraph54  pls_integer;
  l_cell36       pls_integer;
  l_cell37       plpdf3.t_TableCell;
  l_box36        plpdf3.t_box;
  v_paragraph55  plpdf3.t_paragraph;
  l_text_idx31   pls_integer;
  l_text_idx32   pls_integer;
  l_paragraph56  pls_integer;
  l_cell38       pls_integer;
  l_row7         plpdf3.t_TableRow;
  l_cell39       plpdf3.t_TableCell;
  l_box37        plpdf3.t_box;
  v_paragraph57  plpdf3.t_paragraph;
  l_text_idx33   pls_integer;
  l_paragraph58  pls_integer;
  l_cell40       pls_integer;
  l_cell41       plpdf3.t_TableCell;
  l_box38        plpdf3.t_box;
  v_paragraph59  plpdf3.t_paragraph;
  l_text_idx34   pls_integer;
  l_paragraph60  pls_integer;
  l_cell42       pls_integer;
  l_cell43       plpdf3.t_TableCell;
  l_box39        plpdf3.t_box;
  v_paragraph61  plpdf3.t_paragraph;
  l_text_idx35   pls_integer;
  l_paragraph62  pls_integer;
  l_cell44       pls_integer;
  l_cell45       plpdf3.t_TableCell;
  l_box40        plpdf3.t_box;
  v_paragraph63  plpdf3.t_paragraph;
  l_text_idx36   pls_integer;
  l_paragraph64  pls_integer;
  l_cell46       pls_integer;
  l_cell47       plpdf3.t_TableCell;
  l_box41        plpdf3.t_box;
  v_paragraph65  plpdf3.t_paragraph;
  l_text_idx37   pls_integer;
  l_text_idx38   pls_integer;
  l_paragraph66  pls_integer;
  l_cell48       pls_integer;
  l_row8         plpdf3.t_TableRow;
  l_cell49       plpdf3.t_TableCell;
  l_box42        plpdf3.t_box;
  v_paragraph67  plpdf3.t_paragraph;
  l_text_idx39   pls_integer;
  l_paragraph68  pls_integer;
  l_cell50       pls_integer;
  l_cell51       plpdf3.t_TableCell;
  l_box43        plpdf3.t_box;
  v_paragraph69  plpdf3.t_paragraph;
  l_text_idx40   pls_integer;
  l_paragraph70  pls_integer;
  l_cell52       pls_integer;
  l_cell53       plpdf3.t_TableCell;
  l_box44        plpdf3.t_box;
  v_paragraph71  plpdf3.t_paragraph;
  l_text_idx41   pls_integer;
  l_paragraph72  pls_integer;
  l_cell54       pls_integer;
  l_cell55       plpdf3.t_TableCell;
  l_box45        plpdf3.t_box;
  v_paragraph73  plpdf3.t_paragraph;
  l_text_idx42   pls_integer;
  l_paragraph74  pls_integer;
  l_cell56       pls_integer;
  l_cell57       plpdf3.t_TableCell;
  l_box46        plpdf3.t_box;
  v_paragraph75  plpdf3.t_paragraph;
  l_text_idx43   pls_integer;
  l_text_idx44   pls_integer;
  l_paragraph76  pls_integer;
  l_cell58       pls_integer;
  l_box47        plpdf3.t_box;
  v_paragraph77  plpdf3.t_paragraph;
  /* BODYSECTION */
  function image_util(p_name varchar2) return blob is
    l_ret blob;
  begin
    SELECT IMAGE_FILE INTO l_ret FROM image_blob WHERE FILENAME = p_name;
    return l_ret;
  end;
  procedure genPDF is
  begin
    v_format1 := plpdf_util.crFormat(p_w => 612, p_h => 792);
    plpdf.init1(p_orientation => 'P',
                p_unit        => 'pt',
                p_format      => v_format1);
    l_color1 := plpdf_util.crColor(p_r => 255, p_g => 255, p_b => 255);
    plpdf.setBackgroundColor(p_color => l_color1);
    plpdf.setTopMargin(p_margin => 21.550);
    plpdf.setLeftMargin(p_margin => 36);
    plpdf.setRightMargin(p_margin => 36);
    plpdf.setBottomMargin(p_margin => 36);
    plpdf3.setDefaultRunProps(p_fontname => 'Helvetica', p_sz => 11);
    plpdf3.setDefaultParagraphProps();
    plpdf.NewPage();
    /* PARAGRAPH */
    l_box1       := plpdf3.crBox();
    v_paragraph1 := plpdf3.crParagraph(p_box          => l_box1,
                                       p_spacing      => 1,
                                       p_widowControl => true);
    plpdf3.printParagraph(p_paragraph => v_paragraph1);
    /* TABLE */
    l_tblGrid1 := plpdf3.v_TableGrid_empty;
    plpdf3.AddGridCol(p_tableGrid => l_tblGrid1, p_width => 330);
    plpdf3.AddGridCol(p_tableGrid => l_tblGrid1, p_width => 210);
    l_table1       := plpdf3.crTable(p_width => 540, p_grid => l_tblGrid1);
    l_parsedTable2 := plpdf3.InitParseTable(p_table => l_table1);
    plpdf3.startTable(p_parsed_table => l_parsedTable2);
    /* SDT CONTROL: GROUP -> F_ORDER IN C_ORDER(P_ORDER_ID) */
    for F_ORDER in C_ORDER(p_order_id) loop
    
      /* TABLE ROW */
      l_row1 := plpdf3.crRow();
      /* TABLE CELL */
      l_cell1 := plpdf3.crCell(p_width => 330);
      /* PARAGRAPH */
      l_box2       := plpdf3.crBox();
      v_paragraph2 := plpdf3.crParagraph(p_box          => l_box2,
                                         p_widowControl => true);
      /* ADD TEXT */
      l_font1      := plpdf3.crFont(p_fontname => 'Helvetica', p_sz => 30);
      l_color2     := plpdf_util.crColor(p_r => 133, p_g => 133, p_b => 214);
      l_text_idx1  := plpdf3.addText(p_paragraph  => v_paragraph2,
                                     p_text       => 'ORANEXT BT',
                                     p_font       => l_font1,
                                     p_text_color => l_color2);
      l_paragraph3 := plpdf3.addParagraph(p_TableCell => l_cell1,
                                          p_Paragraph => v_paragraph2);
      /* PARAGRAPH */
      l_box3       := plpdf3.crBox();
      v_paragraph4 := plpdf3.crParagraph(p_box          => l_box3,
                                         p_widowControl => true);
      /* ADD TEXT */
      l_font2     := plpdf3.crFont(p_fontname => 'Helvetica', p_sz => 18);
      l_color3    := plpdf_util.crColor(p_r => 204, p_g => 204, p_b => 204);
      l_text_idx2 := plpdf3.addText(p_paragraph  => v_paragraph4,
                                    p_text       => 'INVOICE ',
                                    p_font       => l_font2,
                                    p_text_color => l_color3);
      /* SDT CONTROL: COLUMN -> F_ORDER.ORDER_DATE */
      /* ADD TEXT */
      l_text_idx3  := plpdf3.addText(p_paragraph  => v_paragraph4,
                                     p_text       => F_ORDER.order_date,
                                     p_font       => l_font2,
                                     p_text_color => l_color3);
      l_paragraph5 := plpdf3.addParagraph(p_TableCell => l_cell1,
                                          p_Paragraph => v_paragraph4);
      l_cell2      := plpdf3.addCell(p_TableRow  => l_row1,
                                     p_TableCell => l_cell1);
      /* TABLE CELL */
      l_cell3 := plpdf3.crCell(p_width => 210);
      /* PARAGRAPH */
      l_box4       := plpdf3.crBox();
      v_paragraph6 := plpdf3.crParagraph(p_box          => l_box4,
                                         p_alignment    => 'right',
                                         p_spacing      => 1.500,
                                         p_widowControl => true);
      /* ADD TEXT */
      l_font3      := plpdf3.crFont(p_fontname => 'Helvetica');
      l_color4     := plpdf_util.crColor(p_r => 68, p_g => 68, p_b => 68);
      l_text_idx4  := plpdf3.addText(p_paragraph  => v_paragraph6,
                                     p_text       => 'Your Address',
                                     p_font       => l_font3,
                                     p_text_color => l_color4);
      l_paragraph7 := plpdf3.addParagraph(p_TableCell => l_cell3,
                                          p_Paragraph => v_paragraph6);
      /* PARAGRAPH */
      l_box5       := plpdf3.crBox();
      v_paragraph8 := plpdf3.crParagraph(p_box          => l_box5,
                                         p_alignment    => 'right',
                                         p_spacing      => 1.500,
                                         p_widowControl => true);
      /* ADD TEXT */
      l_text_idx5  := plpdf3.addText(p_paragraph  => v_paragraph8,
                                     p_text       => 'City, State Zip',
                                     p_font       => l_font3,
                                     p_text_color => l_color4);
      l_paragraph9 := plpdf3.addParagraph(p_TableCell => l_cell3,
                                          p_Paragraph => v_paragraph8);
      /* PARAGRAPH */
      l_box6        := plpdf3.crBox();
      v_paragraph10 := plpdf3.crParagraph(p_box          => l_box6,
                                          p_alignment    => 'right',
                                          p_spacing      => 1.500,
                                          p_widowControl => true);
      /* ADD TEXT */
      l_text_idx6   := plpdf3.addText(p_paragraph => v_paragraph10,
                                      p_text      => 'info@plpdf.com',
                                      p_font      => l_font3,
                                      p_link      => 'info@plpdf.com');
      l_paragraph11 := plpdf3.addParagraph(p_TableCell => l_cell3,
                                           p_Paragraph => v_paragraph10);
      l_cell4       := plpdf3.addCell(p_TableRow  => l_row1,
                                      p_TableCell => l_cell3);
      /* TABLE BODY ROW */
      plpdf3.printBodyRow(p_parsed_table => l_parsedTable2,
                          p_TableRow     => l_row1);
    end loop;
    plpdf3.endTable(p_parsed_table => l_parsedTable2);
    /* PARAGRAPH */
    l_box7        := plpdf3.crBox();
    v_paragraph12 := plpdf3.crParagraph(p_box          => l_box7,
                                        p_spacing      => 1,
                                        p_widowControl => true);
    plpdf3.printParagraph(p_paragraph => v_paragraph12);
    /* TABLE */
    l_tblGrid2 := plpdf3.v_TableGrid_empty;
    plpdf3.AddGridCol(p_tableGrid => l_tblGrid2, p_width => 298.500);
    plpdf3.AddGridCol(p_tableGrid => l_tblGrid2, p_width => 241.500);
    l_table3       := plpdf3.crTable(p_width => 540, p_grid => l_tblGrid2);
    l_parsedTable4 := plpdf3.InitParseTable(p_table => l_table3);
    plpdf3.startTable(p_parsed_table => l_parsedTable4);
    /* SDT CONTROL: GROUP -> F_ORDER IN C_ORDER(P_ORDER_ID) */
    for F_ORDER in C_ORDER(p_order_id) loop
    
      /* TABLE ROW */
      l_row2 := plpdf3.crRow(p_min_height => 99);
      /* TABLE CELL */
      l_padding1 := plpdf3.crPadding(p_top    => 14.200,
                                     p_bottom => 14.200,
                                     p_left   => 14.200,
                                     p_right  => 14.200);
      l_color5   := plpdf_util.crColor(p_r => 212, p_g => 211, p_b => 255);
      l_box8     := plpdf3.crBox(p_padding          => l_padding1,
                                 p_background_color => l_color5);
      l_cell5    := plpdf3.crCell(p_box => l_box8, p_width => 298.500);
      /* SDT CONTROL: COLUMN -> F_ORDER.CUST_NAME */
      /* PARAGRAPH */
      l_box9        := plpdf3.crBox();
      v_paragraph13 := plpdf3.crParagraph(p_box          => l_box9,
                                          p_spacing      => 1.500,
                                          p_widowControl => true);
      /* ADD TEXT */
      l_font4       := plpdf3.crFont(p_fontname => 'Helvetica', p_b => true);
      l_color6      := plpdf_util.crColor(p_r => 47, p_g => 46, p_b => 107);
      l_text_idx7   := plpdf3.addText(p_paragraph  => v_paragraph13,
                                      p_text       => F_ORDER.cust_name,
                                      p_font       => l_font4,
                                      p_text_color => l_color6);
      l_paragraph14 := plpdf3.addParagraph(p_TableCell => l_cell5,
                                           p_Paragraph => v_paragraph13);
      /* SDT CONTROL: COLUMN -> F_ORDER.CUST_STREET_ADDRESS1 */
      /* PARAGRAPH */
      l_box10       := plpdf3.crBox();
      v_paragraph15 := plpdf3.crParagraph(p_box          => l_box10,
                                          p_spacing      => 1.500,
                                          p_widowControl => true);
      /* ADD TEXT */
      l_text_idx8   := plpdf3.addText(p_paragraph  => v_paragraph15,
                                      p_text       => F_ORDER.cust_street_address1,
                                      p_font       => l_font3,
                                      p_text_color => l_color6);
      l_paragraph16 := plpdf3.addParagraph(p_TableCell => l_cell5,
                                           p_Paragraph => v_paragraph15);
      /* PARAGRAPH */
      l_box11       := plpdf3.crBox();
      v_paragraph17 := plpdf3.crParagraph(p_box          => l_box11,
                                          p_spacing      => 1.500,
                                          p_widowControl => true);
      /* SDT CONTROL: COLUMN -> F_ORDER.CUST_CITY */
      /* ADD TEXT */
      l_text_idx9 := plpdf3.addText(p_paragraph  => v_paragraph17,
                                    p_text       => F_ORDER.cust_city,
                                    p_font       => l_font3,
                                    p_text_color => l_color6);
      /* ADD TEXT */
      l_text_idx10 := plpdf3.addText(p_paragraph  => v_paragraph17,
                                     p_text       => ', ',
                                     p_font       => l_font3,
                                     p_text_color => l_color6);
      /* SDT CONTROL: COLUMN -> F_ORDER.CUST_STATE */
      /* ADD TEXT */
      l_text_idx11 := plpdf3.addText(p_paragraph  => v_paragraph17,
                                     p_text       => F_ORDER.cust_state,
                                     p_font       => l_font3,
                                     p_text_color => l_color6);
      /* ADD TEXT */
      l_text_idx12 := plpdf3.addText(p_paragraph  => v_paragraph17,
                                     p_text       => ' ',
                                     p_font       => l_font3,
                                     p_text_color => l_color6);
      /* SDT CONTROL: COLUMN -> F_ORDER.CUST_POSTAL_CODE */
      /* ADD TEXT */
      l_text_idx13  := plpdf3.addText(p_paragraph  => v_paragraph17,
                                      p_text       => F_ORDER.cust_postal_code,
                                      p_font       => l_font3,
                                      p_text_color => l_color6);
      l_paragraph18 := plpdf3.addParagraph(p_TableCell => l_cell5,
                                           p_Paragraph => v_paragraph17);
      l_cell6       := plpdf3.addCell(p_TableRow  => l_row2,
                                      p_TableCell => l_cell5);
      /* TABLE CELL */
      l_cell7 := plpdf3.crCell(p_box => l_box8, p_width => 241.500);
      /* PARAGRAPH */
      l_box12       := plpdf3.crBox();
      v_paragraph19 := plpdf3.crParagraph(p_box          => l_box12,
                                          p_alignment    => 'right',
                                          p_spacing      => 1.500,
                                          p_widowControl => true);
      /* ADD TEXT */
      l_text_idx14  := plpdf3.addText(p_paragraph  => v_paragraph19,
                                      p_text       => 'BALANCE DUE',
                                      p_font       => l_font4,
                                      p_text_color => l_color6);
      l_paragraph20 := plpdf3.addParagraph(p_TableCell => l_cell7,
                                           p_Paragraph => v_paragraph19);
      /* PARAGRAPH */
      l_box13       := plpdf3.crBox();
      v_paragraph21 := plpdf3.crParagraph(p_box          => l_box13,
                                          p_alignment    => 'right',
                                          p_spacing      => 1.500,
                                          p_widowControl => true);
      /* ADD TEXT */
      l_text_idx15  := plpdf3.addText(p_paragraph  => v_paragraph21,
                                      p_text       => 'Upon Receipt',
                                      p_font       => l_font3,
                                      p_text_color => l_color6);
      l_paragraph22 := plpdf3.addParagraph(p_TableCell => l_cell7,
                                           p_Paragraph => v_paragraph21);
      /* PARAGRAPH */
      l_box14       := plpdf3.crBox();
      v_paragraph23 := plpdf3.crParagraph(p_box          => l_box14,
                                          p_alignment    => 'right',
                                          p_spacing      => 1,
                                          p_widowControl => true);
      /* ADD TEXT */
      l_color7     := plpdf_util.crColor(p_r => 0, p_g => 128, p_b => 0);
      l_text_idx16 := plpdf3.addText(p_paragraph  => v_paragraph23,
                                     p_text       => '$',
                                     p_font       => l_font1,
                                     p_text_color => l_color7);
      /* SDT CONTROL: COLUMN -> F_ORDER.ORDER_TOTAL * 1.2 */
      /* ADD TEXT */
      l_text_idx17  := plpdf3.addText(p_paragraph  => v_paragraph23,
                                      p_text       => F_ORDER.order_total * 1.2,
                                      p_font       => l_font1,
                                      p_text_color => l_color7);
      l_paragraph24 := plpdf3.addParagraph(p_TableCell => l_cell7,
                                           p_Paragraph => v_paragraph23);
      l_cell8       := plpdf3.addCell(p_TableRow  => l_row2,
                                      p_TableCell => l_cell7);
      /* TABLE BODY ROW */
      plpdf3.printBodyRow(p_parsed_table => l_parsedTable4,
                          p_TableRow     => l_row2);
    end loop;
    plpdf3.endTable(p_parsed_table => l_parsedTable4);
    /* PARAGRAPH */
    l_box15       := plpdf3.crBox();
    v_paragraph25 := plpdf3.crParagraph(p_box          => l_box15,
                                        p_spacing      => 1,
                                        p_widowControl => true);
    plpdf3.printParagraph(p_paragraph => v_paragraph25);
    /* PARAGRAPH */
    l_box16       := plpdf3.crBox();
    v_paragraph26 := plpdf3.crParagraph(p_box          => l_box16,
                                        p_spacing      => 1.500,
                                        p_widowControl => true);
    plpdf3.printParagraph(p_paragraph => v_paragraph26);
    /* TABLE */
    l_color8       := plpdf_util.crColor(p_r => 0, p_g => 0, p_b => 0);
    l_border_side1 := plpdf3.crBorder1(p_color => l_color8,
                                       p_width => 0.500,
                                       p_style => 'single');
    l_border2      := plpdf3.crBorder(p_top    => l_border_side1,
                                      p_bottom => l_border_side1,
                                      p_left   => l_border_side1,
                                      p_right  => l_border_side1);
    l_box17        := plpdf3.crBox(p_border => l_border2);
    l_tblGrid3     := plpdf3.v_TableGrid_empty;
    plpdf3.AddGridCol(p_tableGrid => l_tblGrid3, p_width => 229.250);
    plpdf3.AddGridCol(p_tableGrid => l_tblGrid3, p_width => 83.700);
    plpdf3.AddGridCol(p_tableGrid => l_tblGrid3, p_width => 76.850);
    plpdf3.AddGridCol(p_tableGrid => l_tblGrid3, p_width => 80.150);
    plpdf3.AddGridCol(p_tableGrid => l_tblGrid3, p_width => 70.100);
    l_table5 := plpdf3.crTable(p_box   => l_box17,
                               p_width => 540.050,
                               p_grid  => l_tblGrid3);
    /* SDT CONTROL: GHEADER -> ALL */
    /* TABLE ROW */
    l_row3 := plpdf3.crRow();
    /* TABLE CELL */
    l_padding2 := plpdf3.crPadding(p_top    => 0,
                                   p_bottom => 0,
                                   p_left   => 0,
                                   p_right  => 0);
    l_color9   := plpdf_util.crColor(p_r => 166, p_g => 166, p_b => 166);
    l_box18    := plpdf3.crBox(p_border           => l_border2,
                               p_padding          => l_padding2,
                               p_background_color => l_color9);
    l_cell9    := plpdf3.crCell(p_box    => l_box18,
                                p_Valign => 'center',
                                p_width  => 229.250);
    /* PARAGRAPH */
    l_box19       := plpdf3.crBox();
    v_paragraph27 := plpdf3.crParagraph(p_box          => l_box19,
                                        p_spacing      => 1,
                                        p_widowControl => true);
    /* ADD TEXT */
    l_text_idx18  := plpdf3.addText(p_paragraph  => v_paragraph27,
                                    p_text       => 'Item Name',
                                    p_font       => l_font3,
                                    p_text_color => l_color8);
    l_paragraph28 := plpdf3.addParagraph(p_TableCell => l_cell9,
                                         p_Paragraph => v_paragraph27);
    l_cell10      := plpdf3.addCell(p_TableRow  => l_row3,
                                    p_TableCell => l_cell9);
    /* TABLE CELL */
    l_cell11 := plpdf3.crCell(p_box    => l_box18,
                              p_Valign => 'center',
                              p_width  => 83.700);
    /* PARAGRAPH */
    l_box20       := plpdf3.crBox();
    v_paragraph29 := plpdf3.crParagraph(p_box          => l_box20,
                                        p_alignment    => 'center',
                                        p_spacing      => 1,
                                        p_widowControl => true);
    /* ADD TEXT */
    l_text_idx19  := plpdf3.addText(p_paragraph  => v_paragraph29,
                                    p_text       => 'Image',
                                    p_font       => l_font3,
                                    p_text_color => l_color8);
    l_paragraph30 := plpdf3.addParagraph(p_TableCell => l_cell11,
                                         p_Paragraph => v_paragraph29);
    l_cell12      := plpdf3.addCell(p_TableRow  => l_row3,
                                    p_TableCell => l_cell11);
    /* TABLE CELL */
    l_cell13 := plpdf3.crCell(p_box    => l_box18,
                              p_Valign => 'center',
                              p_width  => 76.850);
    /* PARAGRAPH */
    l_box21       := plpdf3.crBox();
    v_paragraph31 := plpdf3.crParagraph(p_box          => l_box21,
                                        p_alignment    => 'center',
                                        p_spacing      => 1,
                                        p_widowControl => true);
    /* ADD TEXT */
    l_text_idx20  := plpdf3.addText(p_paragraph  => v_paragraph31,
                                    p_text       => 'Quantity',
                                    p_font       => l_font3,
                                    p_text_color => l_color8);
    l_paragraph32 := plpdf3.addParagraph(p_TableCell => l_cell13,
                                         p_Paragraph => v_paragraph31);
    l_cell14      := plpdf3.addCell(p_TableRow  => l_row3,
                                    p_TableCell => l_cell13);
    /* TABLE CELL */
    l_cell15 := plpdf3.crCell(p_box    => l_box18,
                              p_Valign => 'center',
                              p_width  => 80.150);
    /* PARAGRAPH */
    l_box22       := plpdf3.crBox();
    v_paragraph33 := plpdf3.crParagraph(p_box          => l_box22,
                                        p_alignment    => 'center',
                                        p_spacing      => 1,
                                        p_widowControl => true);
    /* ADD TEXT */
    l_text_idx21  := plpdf3.addText(p_paragraph  => v_paragraph33,
                                    p_text       => 'Price Per',
                                    p_font       => l_font3,
                                    p_text_color => l_color8);
    l_paragraph34 := plpdf3.addParagraph(p_TableCell => l_cell15,
                                         p_Paragraph => v_paragraph33);
    l_cell16      := plpdf3.addCell(p_TableRow  => l_row3,
                                    p_TableCell => l_cell15);
    /* TABLE CELL */
    l_cell17 := plpdf3.crCell(p_box    => l_box18,
                              p_Valign => 'center',
                              p_width  => 70.100);
    /* PARAGRAPH */
    l_box23       := plpdf3.crBox();
    v_paragraph35 := plpdf3.crParagraph(p_box          => l_box23,
                                        p_alignment    => 'center',
                                        p_spacing      => 1,
                                        p_widowControl => true);
    /* ADD TEXT */
    l_text_idx22  := plpdf3.addText(p_paragraph  => v_paragraph35,
                                    p_text       => 'Total',
                                    p_font       => l_font3,
                                    p_text_color => l_color8);
    l_paragraph36 := plpdf3.addParagraph(p_TableCell => l_cell17,
                                         p_Paragraph => v_paragraph35);
    l_cell18      := plpdf3.addCell(p_TableRow  => l_row3,
                                    p_TableCell => l_cell17);
    /* TABLE HEADER ROW */
    l_row_idx4     := plpdf3.addHeaderRow(p_table    => l_table5,
                                          p_TableRow => l_row3,
                                          p_print    => 'all');
    l_parsedTable6 := plpdf3.InitParseTable(p_table => l_table5);
    plpdf3.startTable(p_parsed_table => l_parsedTable6);
    /* SDT CONTROL: GROUP -> F_ITEM IN C_ORDER_ITEMS(P_ORDER_ID) */
    for F_ITEM in C_ORDER_ITEMS(p_order_id) loop
    
      /* TABLE ROW */
      l_row5 := plpdf3.crRow(p_cantSplit => true, p_min_height => 85.050);
      /* TABLE CELL */
      l_box24  := plpdf3.crBox(p_border           => l_border2,
                               p_padding          => l_padding2,
                               p_background_color => l_color1);
      l_cell19 := plpdf3.crCell(p_box    => l_box24,
                                p_Valign => 'center',
                                p_width  => 229.250);
      /* SDT CONTROL: COLUMN -> F_ITEM.PRODUCT_NAME */
      /* PARAGRAPH */
      l_box25       := plpdf3.crBox();
      v_paragraph37 := plpdf3.crParagraph(p_box          => l_box25,
                                          p_spacing      => 1,
                                          p_widowControl => true);
      /* ADD TEXT */
      l_text_idx23  := plpdf3.addText(p_paragraph  => v_paragraph37,
                                      p_text       => F_ITEM.product_name,
                                      p_font       => l_font3,
                                      p_text_color => l_color8);
      l_paragraph38 := plpdf3.addParagraph(p_TableCell => l_cell19,
                                           p_Paragraph => v_paragraph37);
      l_cell20      := plpdf3.addCell(p_TableRow  => l_row5,
                                      p_TableCell => l_cell19);
      /* SDT CONTROL: COLUMN -> GET_PRODUCT_IMG(F_ITEM.PRODUCT_IMAGE_NAME) */
      /* TABLE CELL */
      l_cell21 := plpdf3.crCell(p_box    => l_box24,
                                p_Valign => 'center',
                                p_width  => 83.700);
      /* PARAGRAPH */
      l_box26       := plpdf3.crBox();
      v_paragraph39 := plpdf3.crParagraph(p_box          => l_box26,
                                          p_alignment    => 'center',
                                          p_spacing      => 1,
                                          p_widowControl => true);
      l_box27       := plpdf3.crBox();
      l_image1      := plpdf3.addInlineImage2(p_paragraph => v_paragraph39,
                                              p_data      => get_product_img(F_ITEM.product_image_name),
                                              p_width     => 70.866,
                                              p_height    => 70.866,
                                              p_box       => l_box27);
      l_paragraph40 := plpdf3.addParagraph(p_TableCell => l_cell21,
                                           p_Paragraph => v_paragraph39);
      l_cell22      := plpdf3.addCell(p_TableRow  => l_row5,
                                      p_TableCell => l_cell21);
      /* TABLE CELL */
      l_cell23 := plpdf3.crCell(p_box    => l_box24,
                                p_Valign => 'center',
                                p_width  => 76.850);
      /* SDT CONTROL: COLUMN -> F_ITEM.QUANTITY */
      /* PARAGRAPH */
      l_box28       := plpdf3.crBox();
      v_paragraph41 := plpdf3.crParagraph(p_box          => l_box28,
                                          p_alignment    => 'center',
                                          p_spacing      => 1,
                                          p_widowControl => true);
      /* ADD TEXT */
      l_text_idx24  := plpdf3.addText(p_paragraph  => v_paragraph41,
                                      p_text       => F_ITEM.quantity,
                                      p_font       => l_font3,
                                      p_text_color => l_color8);
      l_paragraph42 := plpdf3.addParagraph(p_TableCell => l_cell23,
                                           p_Paragraph => v_paragraph41);
      l_cell24      := plpdf3.addCell(p_TableRow  => l_row5,
                                      p_TableCell => l_cell23);
      /* TABLE CELL */
      l_cell25 := plpdf3.crCell(p_box    => l_box24,
                                p_Valign => 'center',
                                p_width  => 80.150);
      /* SDT CONTROL: COLUMN -> F_ITEM.UNIT_PRICE */
      /* PARAGRAPH */
      l_box29       := plpdf3.crBox();
      v_paragraph43 := plpdf3.crParagraph(p_box          => l_box29,
                                          p_alignment    => 'center',
                                          p_spacing      => 1,
                                          p_widowControl => true);
      /* ADD TEXT */
      l_text_idx25  := plpdf3.addText(p_paragraph  => v_paragraph43,
                                      p_text       => F_ITEM.unit_price,
                                      p_font       => l_font3,
                                      p_text_color => l_color8);
      l_paragraph44 := plpdf3.addParagraph(p_TableCell => l_cell25,
                                           p_Paragraph => v_paragraph43);
      l_cell26      := plpdf3.addCell(p_TableRow  => l_row5,
                                      p_TableCell => l_cell25);
      /* TABLE CELL */
      l_cell27 := plpdf3.crCell(p_box    => l_box24,
                                p_Valign => 'center',
                                p_width  => 70.100);
      /* SDT CONTROL: COLUMN -> F_ITEM.EXTENDED_PRICE */
      /* PARAGRAPH */
      l_box30       := plpdf3.crBox();
      v_paragraph45 := plpdf3.crParagraph(p_box          => l_box30,
                                          p_alignment    => 'center',
                                          p_spacing      => 1,
                                          p_widowControl => true);
      /* ADD TEXT */
      l_text_idx26  := plpdf3.addText(p_paragraph  => v_paragraph45,
                                      p_text       => F_ITEM.extended_price,
                                      p_font       => l_font3,
                                      p_text_color => l_color8);
      l_paragraph46 := plpdf3.addParagraph(p_TableCell => l_cell27,
                                           p_Paragraph => v_paragraph45);
      l_cell28      := plpdf3.addCell(p_TableRow  => l_row5,
                                      p_TableCell => l_cell27);
      /* TABLE BODY ROW */
      plpdf3.printBodyRow(p_parsed_table => l_parsedTable6,
                          p_TableRow     => l_row5);
    end loop;
    /* SDT CONTROL: GROUP -> F_ORDER IN C_ORDER(P_ORDER_ID) */
    for F_ORDER in C_ORDER(p_order_id) loop
    
      /* TABLE ROW */
      l_row6 := plpdf3.crRow();
      /* TABLE CELL */
      l_color10 := plpdf_util.crColor(p_r => 191, p_g => 191, p_b => 191);
      l_box31   := plpdf3.crBox(p_border           => l_border2,
                                p_padding          => l_padding2,
                                p_background_color => l_color10);
      l_cell29  := plpdf3.crCell(p_box => l_box31, p_width => 229.250);
      /* PARAGRAPH */
      l_box32       := plpdf3.crBox();
      v_paragraph47 := plpdf3.crParagraph(p_box          => l_box32,
                                          p_spacing      => 1,
                                          p_widowControl => true);
      l_text_idx27  := plpdf3.addText(p_paragraph => v_paragraph47,
                                      p_text      => ' ',
                                      p_font      => l_font3);
      l_paragraph48 := plpdf3.addParagraph(p_TableCell => l_cell29,
                                           p_Paragraph => v_paragraph47);
      l_cell30      := plpdf3.addCell(p_TableRow  => l_row6,
                                      p_TableCell => l_cell29);
      /* TABLE CELL */
      l_cell31 := plpdf3.crCell(p_box => l_box31, p_width => 83.700);
      /* PARAGRAPH */
      l_box33       := plpdf3.crBox();
      v_paragraph49 := plpdf3.crParagraph(p_box          => l_box33,
                                          p_alignment    => 'right',
                                          p_spacing      => 1,
                                          p_widowControl => true);
      l_text_idx28  := plpdf3.addText(p_paragraph => v_paragraph49,
                                      p_text      => ' ',
                                      p_font      => l_font3);
      l_paragraph50 := plpdf3.addParagraph(p_TableCell => l_cell31,
                                           p_Paragraph => v_paragraph49);
      l_cell32      := plpdf3.addCell(p_TableRow  => l_row6,
                                      p_TableCell => l_cell31);
      /* TABLE CELL */
      l_cell33 := plpdf3.crCell(p_box => l_box31, p_width => 76.850);
      /* PARAGRAPH */
      l_box34       := plpdf3.crBox();
      v_paragraph51 := plpdf3.crParagraph(p_box          => l_box34,
                                          p_alignment    => 'right',
                                          p_spacing      => 1,
                                          p_widowControl => true);
      l_text_idx29  := plpdf3.addText(p_paragraph => v_paragraph51,
                                      p_text      => ' ',
                                      p_font      => l_font3);
      l_paragraph52 := plpdf3.addParagraph(p_TableCell => l_cell33,
                                           p_Paragraph => v_paragraph51);
      l_cell34      := plpdf3.addCell(p_TableRow  => l_row6,
                                      p_TableCell => l_cell33);
      /* TABLE CELL */
      l_cell35 := plpdf3.crCell(p_box => l_box31, p_width => 80.150);
      /* PARAGRAPH */
      l_box35       := plpdf3.crBox();
      v_paragraph53 := plpdf3.crParagraph(p_box          => l_box35,
                                          p_alignment    => 'right',
                                          p_spacing      => 1,
                                          p_widowControl => true);
      /* ADD TEXT */
      l_text_idx30  := plpdf3.addText(p_paragraph  => v_paragraph53,
                                      p_text       => 'Subtotal',
                                      p_font       => l_font3,
                                      p_text_color => l_color8);
      l_paragraph54 := plpdf3.addParagraph(p_TableCell => l_cell35,
                                           p_Paragraph => v_paragraph53);
      l_cell36      := plpdf3.addCell(p_TableRow  => l_row6,
                                      p_TableCell => l_cell35);
      /* TABLE CELL */
      l_cell37 := plpdf3.crCell(p_box => l_box31, p_width => 70.100);
      /* PARAGRAPH */
      l_box36       := plpdf3.crBox();
      v_paragraph55 := plpdf3.crParagraph(p_box          => l_box36,
                                          p_alignment    => 'right',
                                          p_spacing      => 1,
                                          p_widowControl => true);
      /* ADD TEXT */
      l_text_idx31 := plpdf3.addText(p_paragraph  => v_paragraph55,
                                     p_text       => '$',
                                     p_font       => l_font3,
                                     p_text_color => l_color8);
      /* SDT CONTROL: COLUMN -> F_ORDER.ORDER_TOTAL */
      /* ADD TEXT */
      l_text_idx32  := plpdf3.addText(p_paragraph  => v_paragraph55,
                                      p_text       => F_ORDER.order_total,
                                      p_font       => l_font3,
                                      p_text_color => l_color8);
      l_paragraph56 := plpdf3.addParagraph(p_TableCell => l_cell37,
                                           p_Paragraph => v_paragraph55);
      l_cell38      := plpdf3.addCell(p_TableRow  => l_row6,
                                      p_TableCell => l_cell37);
      /* TABLE BODY ROW */
      plpdf3.printBodyRow(p_parsed_table => l_parsedTable6,
                          p_TableRow     => l_row6);
    end loop;
    /* SDT CONTROL: GROUP -> F_ORDER IN C_ORDER(P_ORDER_ID) */
    for F_ORDER in C_ORDER(p_order_id) loop
    
      /* TABLE ROW */
      l_row7 := plpdf3.crRow();
      /* TABLE CELL */
      l_cell39 := plpdf3.crCell(p_box => l_box31, p_width => 229.250);
      /* PARAGRAPH */
      l_box37       := plpdf3.crBox();
      v_paragraph57 := plpdf3.crParagraph(p_box          => l_box37,
                                          p_spacing      => 1,
                                          p_widowControl => true);
      l_text_idx33  := plpdf3.addText(p_paragraph => v_paragraph57,
                                      p_text      => ' ',
                                      p_font      => l_font3);
      l_paragraph58 := plpdf3.addParagraph(p_TableCell => l_cell39,
                                           p_Paragraph => v_paragraph57);
      l_cell40      := plpdf3.addCell(p_TableRow  => l_row7,
                                      p_TableCell => l_cell39);
      /* TABLE CELL */
      l_cell41 := plpdf3.crCell(p_box => l_box31, p_width => 83.700);
      /* PARAGRAPH */
      l_box38       := plpdf3.crBox();
      v_paragraph59 := plpdf3.crParagraph(p_box          => l_box38,
                                          p_alignment    => 'right',
                                          p_spacing      => 1,
                                          p_widowControl => true);
      l_text_idx34  := plpdf3.addText(p_paragraph => v_paragraph59,
                                      p_text      => ' ',
                                      p_font      => l_font3);
      l_paragraph60 := plpdf3.addParagraph(p_TableCell => l_cell41,
                                           p_Paragraph => v_paragraph59);
      l_cell42      := plpdf3.addCell(p_TableRow  => l_row7,
                                      p_TableCell => l_cell41);
      /* TABLE CELL */
      l_cell43 := plpdf3.crCell(p_box => l_box31, p_width => 76.850);
      /* PARAGRAPH */
      l_box39       := plpdf3.crBox();
      v_paragraph61 := plpdf3.crParagraph(p_box          => l_box39,
                                          p_alignment    => 'right',
                                          p_spacing      => 1,
                                          p_widowControl => true);
      l_text_idx35  := plpdf3.addText(p_paragraph => v_paragraph61,
                                      p_text      => ' ',
                                      p_font      => l_font3);
      l_paragraph62 := plpdf3.addParagraph(p_TableCell => l_cell43,
                                           p_Paragraph => v_paragraph61);
      l_cell44      := plpdf3.addCell(p_TableRow  => l_row7,
                                      p_TableCell => l_cell43);
      /* TABLE CELL */
      l_cell45 := plpdf3.crCell(p_box => l_box31, p_width => 80.150);
      /* PARAGRAPH */
      l_box40       := plpdf3.crBox();
      v_paragraph63 := plpdf3.crParagraph(p_box          => l_box40,
                                          p_alignment    => 'right',
                                          p_spacing      => 1,
                                          p_widowControl => true);
      /* ADD TEXT */
      l_text_idx36  := plpdf3.addText(p_paragraph  => v_paragraph63,
                                      p_text       => 'Tax – 20%',
                                      p_font       => l_font3,
                                      p_text_color => l_color8);
      l_paragraph64 := plpdf3.addParagraph(p_TableCell => l_cell45,
                                           p_Paragraph => v_paragraph63);
      l_cell46      := plpdf3.addCell(p_TableRow  => l_row7,
                                      p_TableCell => l_cell45);
      /* TABLE CELL */
      l_cell47 := plpdf3.crCell(p_box => l_box31, p_width => 70.100);
      /* PARAGRAPH */
      l_box41       := plpdf3.crBox();
      v_paragraph65 := plpdf3.crParagraph(p_box          => l_box41,
                                          p_alignment    => 'right',
                                          p_spacing      => 1,
                                          p_widowControl => true);
      /* ADD TEXT */
      l_text_idx37 := plpdf3.addText(p_paragraph  => v_paragraph65,
                                     p_text       => '$',
                                     p_font       => l_font3,
                                     p_text_color => l_color8);
      /* SDT CONTROL: COLUMN -> F_ORDER.ORDER_TOTAL * 0.2 */
      /* ADD TEXT */
      l_text_idx38  := plpdf3.addText(p_paragraph  => v_paragraph65,
                                      p_text       => F_ORDER.order_total * 0.2,
                                      p_font       => l_font3,
                                      p_text_color => l_color8);
      l_paragraph66 := plpdf3.addParagraph(p_TableCell => l_cell47,
                                           p_Paragraph => v_paragraph65);
      l_cell48      := plpdf3.addCell(p_TableRow  => l_row7,
                                      p_TableCell => l_cell47);
      /* TABLE BODY ROW */
      plpdf3.printBodyRow(p_parsed_table => l_parsedTable6,
                          p_TableRow     => l_row7);
    end loop;
    /* SDT CONTROL: GROUP -> F_ORDER IN C_ORDER(P_ORDER_ID) */
    for F_ORDER in C_ORDER(p_order_id) loop
    
      /* TABLE ROW */
      l_row8 := plpdf3.crRow();
      /* TABLE CELL */
      l_cell49 := plpdf3.crCell(p_box => l_box18, p_width => 229.250);
      /* PARAGRAPH */
      l_box42       := plpdf3.crBox();
      v_paragraph67 := plpdf3.crParagraph(p_box          => l_box42,
                                          p_spacing      => 1,
                                          p_widowControl => true);
      l_text_idx39  := plpdf3.addText(p_paragraph => v_paragraph67,
                                      p_text      => ' ',
                                      p_font      => l_font3);
      l_paragraph68 := plpdf3.addParagraph(p_TableCell => l_cell49,
                                           p_Paragraph => v_paragraph67);
      l_cell50      := plpdf3.addCell(p_TableRow  => l_row8,
                                      p_TableCell => l_cell49);
      /* TABLE CELL */
      l_cell51 := plpdf3.crCell(p_box => l_box18, p_width => 83.700);
      /* PARAGRAPH */
      l_box43       := plpdf3.crBox();
      v_paragraph69 := plpdf3.crParagraph(p_box          => l_box43,
                                          p_alignment    => 'right',
                                          p_spacing      => 1,
                                          p_widowControl => true);
      l_text_idx40  := plpdf3.addText(p_paragraph => v_paragraph69,
                                      p_text      => ' ',
                                      p_font      => l_font3);
      l_paragraph70 := plpdf3.addParagraph(p_TableCell => l_cell51,
                                           p_Paragraph => v_paragraph69);
      l_cell52      := plpdf3.addCell(p_TableRow  => l_row8,
                                      p_TableCell => l_cell51);
      /* TABLE CELL */
      l_cell53 := plpdf3.crCell(p_box => l_box18, p_width => 76.850);
      /* PARAGRAPH */
      l_box44       := plpdf3.crBox();
      v_paragraph71 := plpdf3.crParagraph(p_box          => l_box44,
                                          p_alignment    => 'right',
                                          p_spacing      => 1,
                                          p_widowControl => true);
      l_text_idx41  := plpdf3.addText(p_paragraph => v_paragraph71,
                                      p_text      => ' ',
                                      p_font      => l_font3);
      l_paragraph72 := plpdf3.addParagraph(p_TableCell => l_cell53,
                                           p_Paragraph => v_paragraph71);
      l_cell54      := plpdf3.addCell(p_TableRow  => l_row8,
                                      p_TableCell => l_cell53);
      /* TABLE CELL */
      l_cell55 := plpdf3.crCell(p_box => l_box18, p_width => 80.150);
      /* PARAGRAPH */
      l_box45       := plpdf3.crBox();
      v_paragraph73 := plpdf3.crParagraph(p_box          => l_box45,
                                          p_alignment    => 'right',
                                          p_spacing      => 1,
                                          p_widowControl => true);
      /* ADD TEXT */
      l_text_idx42  := plpdf3.addText(p_paragraph  => v_paragraph73,
                                      p_text       => 'TOTAL',
                                      p_font       => l_font3,
                                      p_text_color => l_color8);
      l_paragraph74 := plpdf3.addParagraph(p_TableCell => l_cell55,
                                           p_Paragraph => v_paragraph73);
      l_cell56      := plpdf3.addCell(p_TableRow  => l_row8,
                                      p_TableCell => l_cell55);
      /* TABLE CELL */
      l_cell57 := plpdf3.crCell(p_box => l_box18, p_width => 70.100);
      /* PARAGRAPH */
      l_box46       := plpdf3.crBox();
      v_paragraph75 := plpdf3.crParagraph(p_box          => l_box46,
                                          p_alignment    => 'right',
                                          p_spacing      => 1,
                                          p_widowControl => true);
      /* ADD TEXT */
      l_text_idx43 := plpdf3.addText(p_paragraph  => v_paragraph75,
                                     p_text       => '$',
                                     p_font       => l_font3,
                                     p_text_color => l_color8);
      /* SDT CONTROL: COLUMN -> F_ORDER.ORDER_TOTAL * 1.2 */
      /* ADD TEXT */
      l_text_idx44  := plpdf3.addText(p_paragraph  => v_paragraph75,
                                      p_text       => F_ORDER.order_total * 1.2,
                                      p_font       => l_font3,
                                      p_text_color => l_color8);
      l_paragraph76 := plpdf3.addParagraph(p_TableCell => l_cell57,
                                           p_Paragraph => v_paragraph75);
      l_cell58      := plpdf3.addCell(p_TableRow  => l_row8,
                                      p_TableCell => l_cell57);
      /* TABLE BODY ROW */
      plpdf3.printBodyRow(p_parsed_table => l_parsedTable6,
                          p_TableRow     => l_row8);
    end loop;
    plpdf3.endTable(p_parsed_table => l_parsedTable6);
    /* PARAGRAPH */
    l_box47       := plpdf3.crBox();
    v_paragraph77 := plpdf3.crParagraph(p_box          => l_box47,
                                        p_spacing      => 1.500,
                                        p_widowControl => true);
    plpdf3.printParagraph(p_paragraph => v_paragraph77);
    plpdf.SendDoc(p_blob => v_pdf);
  end;
end PLPDF_INVOICE_EXAMPLE_1;
