FUNCTION render_region (
p_region IN apex_plugin.t_region,
p_plugin IN apex_plugin.t_plugin,
p_is_printer_friendly IN BOOLEAN)
RETURN apex_plugin.t_region_render_result
IS
i number;
l_value_list1 apex_plugin_util.t_column_value_list;
l_value_list2 apex_plugin_util.t_column_value_list;
BEGIN
l_value_list1 := apex_plugin_util.get_data (
p_sql_statement => p_region.source,
p_min_columns => 2,
p_max_columns => 50,
p_component_name => p_region.name
);
FOR i IN 1..l_value_list1(1).count
LOOP
sys.htp.p (' Title: ' || l_value_list1(1)(i) || ' <br> ');
l_value_list2 := apex_plugin_util.get_data (
p_sql_statement =>p_region.attribute_01,
p_min_columns => 2,
p_max_columns => 50,
p_component_name => p_region.name
-- Here it is necessary to substitute value from l_value_list1 (i) (2) in Where request from p_region.attribute_01
);
FOR j IN 1..l_value_list2(1).count
LOOP
sys.htp.p (' Detailed parameters from l_value_list2 ');
END LOOP;
END LOOP;
RETURN NULL;
END;