Saturday 8 September 2012

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;

No comments:

Post a Comment