The use of this procedure is not recommended. This procedure has been replaced by the procedure in APEX_IR.
This procedure resets report settings back to the default report settings. Resetting a report removes any customizations you have made.
This procedure should be used only in a page submit process.
APEX_UTIL.IR_RESET( p_page_id IN NUMBER, p_report_alias IN VARCHAR2 DEFAULT NULL);
Table 28-70 IR_RESET Parameters
Page of the current Application Express application that contains an interactive report.
Identifies the saved report alias within the current application page. To reset a Primary report,
The following example shows how to use the IR_RESET procedure to reset Interactive report settings with alias of '8101021' in page 1 of the current application.
BEGIN APEX_UTIL.IR_RESET( p_page_id => 1, p_report_alias => '8101021' ); END;