RESET Procedure

This procedure resets region settings (such as CR and IR pagination, CR sort, IR and IG report settings). 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_region_id       IN  NUMBER,
    p_component_id    IN  NUMBER  DEFAULT NULL );

Parameters

Table 38-4 RESET 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;