Databases Reference
In-Depth Information
345 p_plugin IN apex_plugin.t_plugin,
346 p_is_printer_friendly IN boolean )
347 RETURN apex_plugin.t_region_render_result
348 AS
349 -- Region Plugin Attributes
350 v_rss_type apex_application_page_regions.attribute_01%type := p_region.attribute_01; --
blogger (can add more types)
351 v_rss_url apex_application_page_regions.attribute_01%type := p_region.attribute_02;
352 v_max_row_nums pls_integer := to_number(p_region.attribute_03);
353 v_dialog_width apex_application_page_regions.attribute_01%type := p_region.attribute_04;
354 v_dialog_height apex_application_page_regions.attribute_01%type :=
p_region.attribute_05;
355
356 -- Other
357 v_html VARCHAR2(4000); -- Used for temp HTML
358 v_div_id VARCHAR2(255) := 'clarifitRSSReader_' || p_region.id; -- Used for dialog window
placeholder
359 v_rss_xml_namespace VARCHAR2(255);
360
361 -- Return
362 v_return apex_plugin.t_region_render_result;
363
364 -- Procedures
365 PROCEDURE sp_display_rss_title(
366 p_rss_id IN VARCHAR2,
367 p_rss_title IN VARCHAR2,
368 p_rn IN pls_integer, -- Current row number
369 p_row_cnt IN pls_integer -- Total number of rows in the query
370 )
371 AS
372 BEGIN
373 -- Handle first row items
374 IF p_rn = 1 THEN
375 sys.htp.p('<table>');
376 END IF; -- First row
377
378 v_html := ('<tr><td><a
href="javascript:$.clarifitRssReader.showContentModal(''%RSS_ID%'',
clarifitRssReaderVals.R%REGION_ID%);">%TITLE%</a></td></tr>');
379 v_html := REPLACE(v_html, '%TITLE%', p_rss_title);
380 v_html := replace(v_html, '%RSS_ID%', p_rss_id);
381 v_html := REPLACE(v_html, '%REGION_ID%', p_region.id);
382
383 sys.htp.p(v_html);
384
385 -- If Last row close table
386 IF p_rn = p_row_cnt THEN
387 sys.htp.p('</table>');
388 END IF;
389
390 END sp_display_rss_title;
391
