Emailing a Report in Release 12 by passing desname and destype as parameters
Hello,
We are using Oracle Apps R12 on a Linux OS.
I am replicating a process we do in another system that uses Oracle APPS R11.
I have a Concurrent Program that calls a Package Procedure to identify orders. This procedure will then call a Report defined with PDF style format output. I also pass an email address and MAIL as destype. by using this:
req_id := FND_REQUEST.SUBMIT_REQUEST ('HJ', 'XXJY_JLY_ACK_RECPT_PDF', 'XXJY Jewelry Acknowledge Receipt Report - PDF',
sysdate, FALSE,p_sort_by, -- sort byv_from_date, --'2012/02/20 00:00:00', --null, -- from date