131: pv_is_accessible := Is_Business_Area_Accessible( l_ba(j).folder_id
132: ,gv_user_id
133: ,p_results_tbl(i).folder_eul);
134:
135: insert into bis_search_results ( eul
136: ,eul_id
137: ,folder_name
138: ,ba_id
139: ,business_area
292: BEGIN
293:
294: -- Delete all the previous results from the table.
295: -- Changed from Truncate to Delete as truncate will not work on synonym.
296: EXECUTE IMMEDIATE 'DELETE FROM bis_search_results';
297:
298: -- Will ensure that the previous results from the search table will be deleted permanatly
299: COMMIT;
300: