Calling BI Publisher Template Dynamically.
--------------------------------------------------------
In After Parameter Form Trigger code the logic to update the Layout picked by the concurrent program.
if nvl(:P_FORMAT, 'PDF') = 'EXCEL' then
UPDATE fnd_conc_pp_actions t
SET t.argument2 = 'DSDPO_BDOC_ANALYSIS_XLS', t.argument5 = 'EXCEL'
where t.concurrent_request_id = FND_GLOBAL.CONC_REQUEST_ID
and t.action_type = 6;
else
UPDATE fnd_conc_pp_actions t
SET t.argument2 = 'DSDPO_BDOC_ANALYSIS', t.argument5 = 'PDF'
where t.concurrent_request_id = FND_GLOBAL.CONC_REQUEST_ID
and t.action_type = 6;
end if;