RESET Procedure

This procedure resets region settings (such as classic report and interactive report pagination, classic report sort, interactive report and interactive grid report settings, and Region Display Selector tab selection). Only report and Region Display Selector regions are supported at this time.

Syntax

APEX_REGION.RESET (
    p_application_id  IN  NUMBER  DEFAULT apex_application.g_flow_id,
    p_page_id         IN  NUMBER,
    p_region_id       IN  NUMBER,
    p_component_id    IN  NUMBER  DEFAULT NULL );

Parameters

Parameter	Description
`p_application_id`	`ID` of the application where the region is on.
`p_page_id`	`ID` of the page where the region is on.
`p_region_id`	`ID` of a specific region.
`p_component_id`	Region component `ID` to use. For interactive reports and interactive grids, this is the saved report `ID` within the current application page.

Example

This example resets the given saved report on application 100, page 1.

BEGIN
     APEX_REGION.RESET (
         p_application_id => 100,
         p_page_id        => 1,
         p_region_id      => 2505704029884282,
         p_component_id   => 880629800374638220);
END;