50.13 RESET Procedure Signature 2

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) using static ID. Only report 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_static_id       IN  VARCHAR2,
    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_static_id	Static 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_static_id      => 'group-region',
         p_component_id   => 880629800374638220);
END;