APPS.BIS_RG_FIX_AKFLEX_DATA SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 25

   SELECT substr(web_html_call,
                 instr(web_html_call, '''',1,1) + 1,
                 instr(web_html_call, '''',1,2) -
                 instr(web_html_call, '''',1,1) - 1) region_code
   FROM  fnd_form_functions
   WHERE upper(web_html_call) like 'BISVIEWER.SHOWREPORT%';

Line: 34

       UPDATE ak_region_items
       SET attribute_category='BIS PM Viewer'
       WHERE region_code=c_rec.region_code;

Line: 52

   SELECT substr(web_html_call,
                 instr(web_html_call, '''',1,1) + 1,
                 instr(web_html_call, '''',1,2) -
                 instr(web_html_call, '''',1,1) - 1) region_code
   FROM  fnd_form_functions
   WHERE upper(web_html_call) like 'BISVIEWER.SHOWREPORT%';

Line: 61

       UPDATE ak_regions
       SET attribute_category='BIS PM Viewer'
       WHERE region_code=c_rec.region_code;

Line: 66

   x_return_status := l_count || ' records updated in ak_regions table  ';