Quick Filter Selections on p2 don't respect the selected report

[rimblas]

The "Totals" report on p2 and reports on p10 pass a filter to the "Sessions" IR on p2. When this happens the user selected/saved report is lost.

Enhance ALL links that pass filter to obtain the "last_viewed_report" and provide it as part of the link.

Use

apex_ir.get_last_viewed_report_id (
    p_page_id       in number,
    p_region_id     in number)
    return number;

Use this SQL to obtain a p_region_id from a Static ID

select region_id
  from apex_application_page_regions
 where application_id = :APP_ID
   and page_id = :APP_PAGE_ID
   and static_id = 'STATIC_ID'

[jwall-insum]

Links to p2 on p2 and p10 were corrected this way:

If the last viewed IR Sessions was an Alternative IR, the report alias is added to the request on the link. Otherwise, the link will point to the Primary Report.

Also, when the user changes the IR Session to a Saved Report (Alternative or Default), the IR Totals is refreshed and its links regenerated.