create or replace procedure i9_tpl
  is
  l_tpl_1 plpdf_type.tr_tpl_data;
  l_tpl_2 plpdf_type.tr_tpl_data;
  l_tpl_3 plpdf_type.tr_tpl_data;
    
  l_tpl_id_1 number;
  l_tpl_id_2 number;
  l_tpl_id_3 number;
  
  l_blob blob;
 begin
   l_tpl_1 := plpdf_parser.LoadTemplate(7);
   l_tpl_2 := plpdf_parser.LoadTemplate(8);
   l_tpl_3 := plpdf_parser.LoadTemplate(9);
   
   plpdf.init;
   
   l_tpl_id_1 := plpdf.InsTemplate(l_tpl_1);
   l_tpl_id_2 := plpdf.InsTemplate(l_tpl_2);
   l_tpl_id_3 := plpdf.InsTemplate(l_tpl_3);
   
   -- 1
   plpdf.NewPage;
   plpdf.useTemplate(l_tpl_id_1);
     
   -- 2  
   plpdf.NewPage;
   plpdf.useTemplate(l_tpl_id_2);
   plpdf.SetPrintFont('Arial',null,10);
   plpdf.SetColor4Text(plpdf_const.Blue);   
   --   
   --lastname   
	 plpdf.PrintText(28,53,'lastname');  
   --firstname   
	 plpdf.PrintText(78,53,'firstname'); 
   -- middlename   
   plpdf.PrintText(121,53,'middlename'); 
   -- maidenname   
   plpdf.PrintText(145,53,'maidenname'); 
   -- address   
   plpdf.PrintText(11,62,'address'); 
   -- apartmentnumber
   plpdf.PrintText(121,62,'apt#'); 
   -- dateofbirth
   plpdf.PrintText(145,62,'dateofbirth'); 
   -- city
   plpdf.PrintText(11,71,'city'); 
   -- state
   plpdf.PrintText(72,71,'state'); 
   -- zipcode
   plpdf.PrintText(121,71,'zipcode'); 
   -- ssnum
   plpdf.PrintText(145,71,'ssnum'); 
   
   plpdf.SetPrintFont('ZapfDingBats',null,10);
   -- citizen
   plpdf.PrintText(104.5,80,'5'); 
   -- lawfulperm1
   plpdf.PrintText(104.5,84.5,'5'); 
   -- alienauthorizeds1
   plpdf.PrintText(104.5,89,'5'); 
   
   plpdf.SetPrintFont('Arial',null,10);
   -- aliennumber
   plpdf.PrintText(163,84.5,'aliennumber');
   -- aliendate
   plpdf.PrintText(149,89,'aliendate');
   -- employeessig
   plpdf.PrintText(11,104,'employeessig'); 
   -- signaturedate
   plpdf.PrintText(145,104,'signaturedate'); 
   
   -- prepareressignature
   plpdf.PrintText(24,125.5,'prepareressignature'); 
   -- printname
   plpdf.PrintText(110,125.5,'printname'); 
   -- address2
   plpdf.PrintText(24,135,'address2');
   -- middledate
   plpdf.PrintText(145,135,'address2');
   
   -- documanttitle
   plpdf.PrintText(30,158,'documanttitle');
   -- issuing_authority
   plpdf.PrintText(32.5,164.5,'issuing_authority');
   -- docnumber
   plpdf.PrintText(27.5,171.5,'docnumber');
   -- expirationdate
   plpdf.PrintText(48,178,'expirationdate');
   -- documanrt2
   plpdf.PrintText(27,185,'documanrt2');
   -- expirationdate2
   plpdf.PrintText(48,191,'expirationdate2');
   
   -- listb1
   plpdf.PrintText(80.5,158,'listb1');
   -- listb2
   plpdf.PrintText(80.5,164.5,'listb2');
   -- listb3
   plpdf.PrintText(80.5,171.5,'listb3');
   -- listb4
   plpdf.PrintText(80.5,178,'listb4');
   
   -- listc1
   plpdf.PrintText(145,158,'listc1');
   -- listc2
   plpdf.PrintText(145,164.5,'listc2');
   -- listc3
   plpdf.PrintText(145,171.5,'listc3');
   -- listc4
   plpdf.PrintText(145,178,'listc4');
   
   -- certsignture
   plpdf.PrintText(10,222,'certsignture');
   -- certprintname
   plpdf.PrintText(82,222,'certprintname');
   -- certtitle
   plpdf.PrintText(146,222,'certtitle');
   
   -- businessnameaddress
   plpdf.PrintText(10,231.5,'businessnameaddress');
   -- businessdate
   plpdf.PrintText(146,231.5,'businessnameaddress');
   
   -- newname
   plpdf.PrintText(10,247,'newname');
   -- dateofrehire
   plpdf.PrintText(133,247,'dateofrehire');
   -- doctitle
   plpdf.PrintText(47,258,'doctitle');
   -- documentnumber
   plpdf.PrintText(98,258,'documentnumber');
   -- cexpirationdate
   plpdf.PrintText(159,258,'cexpirationdate');
   -- lastsignature
   plpdf.PrintText(10,276,'lastsignature');
   -- lstdate
   plpdf.PrintText(146,276,'lstdate');
   
   -- 3
   plpdf.NewPage;
   plpdf.useTemplate(l_tpl_id_3);
     
   plpdf.SendDoc(l_blob);

	-- print
	/*
	owa_util.mime_header('application/pdf',false);
        htp.p('Content-Length: ' || dbms_lob.getlength(l_blob));
        owa_util.http_header_close;
        wpg_docload.download_file(l_blob);
        */

	-- or store
	insert into STORE_BLOB (blob_file, created_date) values (l_blob, sysdate);
	commit;
 end;
/