50.2 CLEAR Procedure Signature 2

This procedure clears region settings (classic report and interactive report pagination, interactive report report settings) using the region static ID.

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_static_id       IN  VARCHAR2,
    p_component_id    IN  NUMBER DEFAULT NULL );

Parameters

Parameter	Description
p_application_id	ID of the application that the region is on.
p_page_id	ID of the page that the region is on.
p_static_id	Static 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_static_id      => 'group-region',
         p_component_id   => 880629800374638220);
END;