APPS.BIS_RG_FIX_AKFLEX_DATA dependencies on AK_REGION_ITEMS

Line 34: UPDATE ak_region_items

30: WHERE upper(web_html_call) like 'BISVIEWER.SHOWREPORT%';
31: l_count NUMBER := 0;
32: BEGIN
33: FOR c_rec IN c_repregions LOOP
34: UPDATE ak_region_items
35: SET attribute_category='BIS PM Viewer'
36: WHERE region_code=c_rec.region_code;
37: l_Count := l_count+1;
38: END LOOP;

Line 39: --x_return_Status := to_char(l_Count) || ' records updated in ak_region_items table ';

35: SET attribute_category='BIS PM Viewer'
36: WHERE region_code=c_rec.region_code;
37: l_Count := l_count+1;
38: END LOOP;
39: --x_return_Status := to_char(l_Count) || ' records updated in ak_region_items table ';
40: EXCEPTION
41: WHEN OTHERS THEN
42: x_return_code := SQLCODE;
43: x_return_status := SQLERRM;