DBA Data[Home] [Help]

APPS.BIS_BUSINESS_VIEWS_CATALOG_OA dependencies on BIS_SEARCH_RESULTS

Line 135: insert into bis_search_results ( eul

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

Line 296: EXECUTE IMMEDIATE 'DELETE FROM bis_search_results';

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: