36.15 GET_LAST_VIEWED_REPORT_ID Function

This function returns the last viewed base report ID of the specified page and region.

Syntax

APEX_IR.GET_LAST_VIEWED_REPORT_ID (
    p_page_id   IN NUMBER,
    p_region_id IN VARCHAR2 )
    RETURN NUMBER;

Parameters

Parameter	Description
p_page_id	Page of the current Oracle APEX application that contains an interactive report.
p_region_id	The interactive report static ID or region ID.

Example

The following example shows how to use the GET_LAST_VIEWED_REPORT_ID function to retrieve the last viewed report ID in page 1, region group-region of the current application.

DECLARE
    l_report_id number;
BEGIN     
    l_report_id := APEX_IR.GET_LAST_VIEWED_REPORT_ID (                       
        p_page_id          => 1,
        p_region_id => 'group-region' );
    sys.htp.p('Last Viewed Report ID = ' || l_report_id);
END;