48.1 CLEAR Procedure
This procedure clears region settings (CR and IR pagination, IR report settings).
For interactive report regions, this procedure clears the following settings: control break, aggregate, flashback, chart, number of rows to display, filter, highlight, computation, and group by. However, it does not clear the following: display column list, sorting, report preference (such as view mode, display nulls in detail view, expand/collapse of report settings).
Syntax
APEX_REGION.CLEAR (
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 48-1 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, this is the saved report ID within the current application page.
|
Example
This example clears the given saved report on application 100
, page 1
.
BEGIN
APEX_REGION.CLEAR (
p_application_id => 100,
p_page_id => 1,
p_region_id => 2505704029884282,
p_component_id => 880629800374638220);
END;
Parent topic: APEX_REGION