38.6 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;
Parent topic: APEX_REGION