title: Oracle APEX filter change dynamically in saved reports
body: <p>I have an IR with <strong>saved reports</strong> where filters has been added to the column Year = 2015. I need to write a plsql procedure to update the Year filter to Year = 2016.
  How can i achieve such a scenario. I looked in to the API and it didn't give me any thing. the only option i can come up with is changing data manually in the DB.
  below is the query i used to get the saved private reports.</p>
  
  <pre><code>SELECT  a.flow_id,a.page_id,a.status,a.application_user,a.name, b.interactive_report_id, c.condition_type,c.column_name,c.operator,c.expr
  FROM apex_040000.wwv_flow_worksheet_rpts a, apex_application_page_ir b, apex_040000.WWV_FLOW_WORKSHEET_CONDITIONS c
  WHERE a.flow_id = :APP_ID
  AND a.page_id = b.page_id
  AND b.application_id = a.flow_id
  AND a.worksheet_id = b.interactive_report_id
  AND a.status = 'PRIVATE'
  AND c.report_id = a.id
  AND c.column_name='YEAR'
  and a.page_id= :APP_PAGE_ID
  </code></pre>
  
  <p>Would i be able to succeed wth this approach. Is there any other solution for this.
  ?</p>