Thursday, 22 May 2014

How to Add XML TEMPLATE and Printing through

PL/SQL in Oracle Apps

DECLARE 
L_XML_LAYOUT BOOLEAN; 
L_PNR_OUPTIONS BOOLEAN; 
For Adding XML TEMPLATE 
BEGIN 
L_XML_LAYOUT := 
FND_REQUEST.ADD_LAYOUT (TEMPLATE_APPL_NAME => 'XXXX', 
TEMPLATE_CODE => 'XXXX', 
TEMPLATE_LANGUAGE => 'EN', 
TEMPLATE_TERRITORY => 'US', 
OUTPUT_FORMAT => 'PDF' 
); 
END; 

For Printing 

BEGIN 
L_PNR_OUPTIONS := 
FND_REQUEST.SET_PRINT_OPTIONS (PRINTER => PRINTER_NAME, 
COPIES => 1 
); 

END;

1 comment:

  1. Regards,
    Harish
    Oracle technical and fusion cloud SCM online classes, if you are interested please whatsapp to this number +91 7382582893, thank you.

    ReplyDelete