35.12 RESET_REPORT Procedure Signature 3

This procedure resets report settings to the developer defined default settings using the report Static ID.

Syntax

APEX_IG.RESET_REPORT (
    p_page_id            IN   NUMBER,
    p_region_static_id   IN   VARCHAR2,
    p_report_static_id   IN   VARCHAR2     DEFAULT NULL );

Parameters

Parameter	Description
p_page_id	Page of the current Oracle APEX application that contains an interactive grid.
p_region_static_id	The interactive grid region Static ID.
p_report_static_id	The saved interactive grid report Static ID within the current application page. If p_report_static_id is NULL, it resets the last viewed report's settings.

Example

The following example shows how to use the RESET_REPORT procedure to reset interactive grid settings with report Static ID of statistics in page 1 and region Static ID analysis of the current application.

BEGIN     
    APEX_IG.RESET_REPORT(
        p_page_id          =>1,
        p_region_static_id =>'analysis',
        p_report_static_id =>'statistics');
END;