RESET_REPORT Procedure Signature 1

33.8 RESET_REPORT Procedure Signature 1

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

Syntax

APEX_IG.RESET_REPORT (
    p_page_id   IN NUMBER,
    p_region_id IN NUMBER,
    p_report_id IN NUMBER DEFAULT NULL );

Parameters

Parameter	Description
`p_page_id`	Page of the current Oracle APEX application that contains an interactive grid.
`p_region_id`	The interactive grid region ID.
`p_report_name`	The saved report name within the current application page. If `p_report_id` is NULL, it resets the last viewed report settings.

Example

The following example shows how to use the RESET_REPORT procedure signature 1 to reset interactive grid settings with report ID of 901029800374639010 in page 1, region 3335704029884222 of the current application.

BEGIN     
    APEX_IG.RESET_REPORT(
        p_page_id      => 1,
        p_region_id    => 3335704029884222,
        p_report_id    => 901029800374639010);
END;

Parent topic: APEX_IG