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

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;