-- Function returns last viewed base report_id for specified page and region
function get_last_viewed_report_id
( p_page_id in number
, p_region_id in number
)
return number;
-- Function validates whether the report_id belongs to the region ID
function validate_report_id
( p_ig_id in number
, p_page_id in number
, p_report_id in number
)
return number;
-- Procedure adds Interactive Grid column filter using report_id.
-- If p_report_id is null, it adds filter to the last viewed report.
procedure add_filter
( p_page_id in number
, p_region_id in number
, p_filter_value in varchar2
, p_column_name in varchar2 default null
, p_operator_abbr in varchar2 default null
, p_is_case_sensitive boolean default false
, p_report_id in number default null
);
-- Procedure resets Interactive Grid to the factory default settings using report_id.
-- If p_report_id is null, it resets the last viewed report.
procedure reset_report
( p_page_id in number
, p_region_id in number
, p_report_id in number default null
);
-- Procedure resets Interactive report to the factory default settings using report_alias.
-- If p_report_name is null, it resets the last viewed report.
procedure reset_report
( p_page_id in number
, p_region_id in number
, p_report_name in varchar2 default null
);
-- Procedure clears Interactive Grid filter(s) from all view for the given report ID
-- If p_report_id is null, it resets the last viewed report.
procedure clear_report
( p_page_id in number
, p_region_id in number
, p_report_id in number default null
);
-- Procedure clears Interactive Grid filter(s) from all view for the given report ID
-- If p_report_name is null, it resets the last viewed report.
procedure clear_report
( p_page_id in number
, p_region_id in number
, p_report_name in varchar2 default null
);
-- Procedure deletes a saved report.
-- It deletes a given saved report (public, private, alternative) except the Primary Default.
procedure delete_report
( p_application_id in number default wwv_flow.g_flow_id
, p_report_id in number
);
-- Procedure changes owner of a non-primary saved report (public, private, alternative) for the current application.
procedure change_report_owner
( p_application_id in number default wwv_flow.g_flow_id
, p_report_id in number
, p_old_owner in varchar2
, p_new_owner in varchar2
);