-- Module     :  Generate Report Button - Parameter Passing - Integrating Forms & Reports
-- Written by :  Stephen Corey
-- Written on :  October 10, 2004

declare
		v_pl paramlist;
begin
	v_pl := create_parameter_list('paramlist');

	-- Add the parameters to the list
	ADD_PARAMETER(v_pl, 'P_FILTER_BY', TEXT_PARAMETER, :PARAMETER.P_FILTER_BY);
	ADD_PARAMETER(v_pl, 'P_USE_QUERY', TEXT_PARAMETER, :PARAMETER.P_USE_QUERY);
	ADD_PARAMETER(v_pl, 'P_GROUP_BY',  TEXT_PARAMETER, :PARAMETER.P_GROUP_BY);
	ADD_PARAMETER(v_pl, 'p_ORDER_BY',  TEXT_PARAMETER, :PARAMETER.P_ORDER_BY);
	
	-- Suppress the Reports default parameter form to avoid double-entry nuisance
	ADD_PARAMETER(v_pl, 'PARAMFORM', TEXT_PARAMETER, 'NO');
	
	-- Make the call to Reports and pass the values to specificied report path
	RUN_PRODUCT(reports, 'c:\DOCUMENTS AND SETTINGS\scorey\My Documents\Oracle Reports\HR Reports\Flexible_Termast_Base.rdf', ASYNCHRONOUS, RUNTIME, FILESYSTEM, v_pl);
	--RUN_PRODUCT(reports, 'm:\oraclefhwa\fhwaappl\ridot\reports\US\scorey\TERMAST_FLEXIBLE_BASE.rdf', SYNCHRONOUS, RUNTIME, FILESYSTEM, v_pl);
	
	-- Destroy the existing parameter list to remove it from memory
	destroy_parameter_list(v_pl);
	
END;