Concurrent Program delivery options to Email

DECLARE

l_conc_id NUMBER;

l_user_id NUMBER := xxx ; -- you can assign it from profile option value

l_resp_id NUMBER := xxx ; -- you can assign it from profile option value

l_resp_ppl_id NUMBER := xxx; -- you can assign it from profile option value

l_boolean BOOLEAN;

BEGIN

l_boolean :=

fnd_request.add_delivery_option (TYPE => 'E', -- this one to speciy the delivery option as Email

p_argument1 => 'Testing the Email option from back end', -- subject for the mail

p_argument2 => 'abx@xyz.com', -- from address

p_argument3 => 'xyz@abc.com','adf@abc.com', -- to address

p_argument4 => '', -- cc address to be specified here.

nls_language => ''); -- language option);

IF l_boolean = TRUE THEN

FND_GLOBAL.APPS_INITIALIZE (l_user_id, l_resp_id, l_resp_ppl_id); -- intialize the apps.

l_conc_id :=

fnd_request.submit_request (application => 'FND',program => 'XXXXXXX', -- you concurrent program.

start_time => SYSDATE,sub_request => FALSE);

END IF;

END;