Localize reports

A report definition may include several report templates. Each template may have its own layout of fields and regions. Or it may have its content translated to a foreign language. Once all templates are uploaded into Report Designer, each of them must be assigned a Prerequisite condition. It is an anonymous PL/SQL block with the following structure:

DECLARE 
v_param1          NUMBER;
v_lang            VARCHAR2(32767);
v_dummy3          VARCHAR2(32767);
v_dummy4          VARCHAR2(32767);
v_dummy5          VARCHAR2(32767);
v_result  	      BOOLEAN;

BEGIN
-- Receive IN parameters :param_1, :param_2, :param_3, :param_4, :param_5
v_param1  := to_number(:report_input_parameter_1);  -- parameter #1 transmitted into the report or entered by a user
v_lang    := nvl(:report_input_parameter_2, 'n/a'); -- language code as a 2nd parameter  
v_dummy3  := :report_input_parameter_3; -- don’t delete the line even if param3 is not used
v_dummy4  := :report_input_parameter_4; -- don’t delete the line even if param4 is not used
v_dummy5  := :report_input_parameter_5; -- don’t delete the line even if param5 is not used

-- Put your code here to define if this template must be used.
-- Possible example to select localized version
IF v_lang = 'en' THEN v_condition_result := TRUE;
ELSE v_result := FALSE;
END IF;

-- Return OUT parameter :v_result
:v_result := v_result;
END;

Given report parameters, the prerequisite condition of only 1 report template must return TRUE. All other must return FALSE;

If your report definition has only 1 report template, its Prerequisite condition may be left empty.