34.1 CLEAR Procedure

This procedure clears region settings (that is, 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 34-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_applicatoin_id => 100,
         p_page_id        => 1,
         p_region_id      => 2505704029884282,
         p_component_id   => 880629800374638220);
END;