select "ROWID",
       apex_item.select_list_from_query(1, :sl1, 'select distinct name1 as sl1 from reports.REPORT_INDICATORS') as INDICATOR,
       apex_item.select_list_from_query(2, :sl2, 'select distinct name2 as sl2 from reports.REPORT_INDICATORS') as TYPEOFPLAN
from REPORTS_PLAN

begin
   for i in 1..apex_application.g_f50.count
      loop
         delete UGDT_TABLE_LOADING t
         where t.RowID = apex_application.g_f50(i);
 
         commit;
      end loop;
end;

begin
   for i in 1..apex_application.g_f01.count
      loop
         update Reports_Plan t set t.indicator = apex_application.g_f47(i), t.typeofplan = apex_application.g_f48(i)
         where t.RowID = apex_application.g_f49(i);
      end loop;
end;

t = event.target;

if (t.name == 'f02')
   {
      n = document.getElementById("P200_TEXT");
      n.value = t.value;

      var ajaxRequest = new htmldb_Get(null, $v('pFlowId'), 'APPLICATION_PROCESS=', $v('pFlowStepId'));
      ajaxRequest.add('P200_TEXT',$v('P200_TEXT'));
      var ajaxResponse = ajaxRequest.GetAsync(function()
         {
            if (p.readyState == 4 && p.status == 200)
               {
                  $('#Report_plan').trigger('apexrefresh');
               }
         });

      ajaxRequest = null;

      n = document.getElementById("P200_STR");
      n.value = t.id.substr(4,4);

      var ajaxRequest = new htmldb_Get(null, $v('pFlowId'), 'APPLICATION_PROCESS=', $v('pFlowStepId'));
      ajaxRequest.add('P200_STR',$v('P200_STR'));
      var ajaxResponse = ajaxRequest.GetAsync(function()
         {
            if (p.readyState == 4 && p.status == 200)
               {
                  $('#Report_plan').trigger('apexrefresh');
               }
         });

      ajaxRequest = null;

      b = 'f03_'+t.id.substr(4,4);
      tp = document.getElementById(b);
   }

t = event.target;

if (t.name == 'f02')
   {
      str = document.getElementById("P200_STR");
      b = 'f03_'+ str.value;
      tfsl = document.getElementById(b);

      sl = document.getElementById("P200_SL");

      for (var i = 1; i < sl.options.length; i++)
         {
            tfsl.options[i].value = sl.options[i].value;
            tfsl.options[i].text = sl.options[i].text;
         }
   }

var ajaxRequest = new htmldb_Get(null, $v('pFlowId'), 'APPLICATION_PROCESS=', $v('pFlowStepId'));

ajaxRequest.add('P200_STR',$v('P200_STR'));