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 36-4 CLEAR 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_applicatoin_id => 100,
         p_page_id        => 1,
         p_region_id      => 2505704029884282,
         p_component_id   => 880629800374638220);
END;