APPS.BIS_BUSINESS_VIEWS_CATALOG dependencies on BIS_GNRL_SEARCH_ENGINE_PVT

Line 196: ( p_results_tbl IN BIS_GNRL_SEARCH_ENGINE_PVT.results_tbl_typ

192: -- *************************************************************
193: -- Paint the results table
194: -- *************************************************************
195: PROCEDURE results_page
196: ( p_results_tbl IN BIS_GNRL_SEARCH_ENGINE_PVT.results_tbl_typ
197: , p_lang IN VARCHAR2
198: )
199:
200: IS

Line 242: l_eul := BIS_GNRL_SEARCH_ENGINE_PVT.get_a_index_owner

238: htp.p(' ');
239: htp.p(' ');
240: -- ******************** Headers end **********************
241:
242: l_eul := BIS_GNRL_SEARCH_ENGINE_PVT.get_a_index_owner
243: ( 'BIS_BV_FOLDER_NAMES_' || p_lang );
244:
245: IF (l_eul IS NULL) THEN RAISE BIS_GNRL_SEARCH_ENGINE_PVT.e_noIndexDefined;
246: END IF;

Line 245: IF (l_eul IS NULL) THEN RAISE BIS_GNRL_SEARCH_ENGINE_PVT.e_noIndexDefined;

241:
242: l_eul := BIS_GNRL_SEARCH_ENGINE_PVT.get_a_index_owner
243: ( 'BIS_BV_FOLDER_NAMES_' || p_lang );
244:
245: IF (l_eul IS NULL) THEN RAISE BIS_GNRL_SEARCH_ENGINE_PVT.e_noIndexDefined;
246: END IF;
247:
248: -- **************************************************
249: -- Begin painting the query results

Line 287: WHEN BIS_GNRL_SEARCH_ENGINE_PVT.e_noIndexDefined THEN RAISE;

283:
284: htp.bodyClose;
285: htp.htmlClose;
286: EXCEPTION
287: WHEN BIS_GNRL_SEARCH_ENGINE_PVT.e_noIndexDefined THEN RAISE;
288: WHEN OTHERS THEN htp.p(SQLERRM);
289:
290: END results_page;
291:

Line 406: l_keywords_tbl BIS_GNRL_SEARCH_ENGINE_PVT.keywords_tbl_typ;

402: l_lang VARCHAR2(100);
403: l_length pls_integer;
404: l_startpoint pls_integer;
405: l_separator pls_integer;
406: l_keywords_tbl BIS_GNRL_SEARCH_ENGINE_PVT.keywords_tbl_typ;
407: l_results_tbl BIS_GNRL_SEARCH_ENGINE_PVT.results_tbl_typ;
408: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
409: l_prompts ICX_UTIL.g_prompts_table;
410: v_keywords varchar2(32000);

Line 407: l_results_tbl BIS_GNRL_SEARCH_ENGINE_PVT.results_tbl_typ;

403: l_length pls_integer;
404: l_startpoint pls_integer;
405: l_separator pls_integer;
406: l_keywords_tbl BIS_GNRL_SEARCH_ENGINE_PVT.keywords_tbl_typ;
407: l_results_tbl BIS_GNRL_SEARCH_ENGINE_PVT.results_tbl_typ;
408: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
409: l_prompts ICX_UTIL.g_prompts_table;
410: v_keywords varchar2(32000);
411:

Line 467: l_eul := BIS_GNRL_SEARCH_ENGINE_PVT.get_a_index_owner( 'BIS_BV_FOLDER_NAMES_' || l_lang );

463:
464: -- if Business Views InterMedia Indexes have been installed in
465: -- several schemas, some schema is chosen, arbitrarily.
466:
467: l_eul := BIS_GNRL_SEARCH_ENGINE_PVT.get_a_index_owner( 'BIS_BV_FOLDER_NAMES_' || l_lang );
468:
469: IF (l_eul IS NULL) THEN RAISE BIS_GNRL_SEARCH_ENGINE_PVT.e_noIndexDefined;
470: END IF;
471:

Line 469: IF (l_eul IS NULL) THEN RAISE BIS_GNRL_SEARCH_ENGINE_PVT.e_noIndexDefined;

465: -- several schemas, some schema is chosen, arbitrarily.
466:
467: l_eul := BIS_GNRL_SEARCH_ENGINE_PVT.get_a_index_owner( 'BIS_BV_FOLDER_NAMES_' || l_lang );
468:
469: IF (l_eul IS NULL) THEN RAISE BIS_GNRL_SEARCH_ENGINE_PVT.e_noIndexDefined;
470: END IF;
471:
472: /************* FOR DEBUGGING *************************
473: htp.p('11111111111111111111111111111111111111111'||'
');

Line 490: BIS_GNRL_SEARCH_ENGINE_PVT.build_query

486:
487: BEGIN
488: -- Now call the package to build and run the InterMedia
489: -- query and obtain the best row hits
490: BIS_GNRL_SEARCH_ENGINE_PVT.build_query
491: ( p_api_version => 1.0
492: ,p_eul => l_eul
493: ,p_keywords_tbl => l_keywords_tbl
494: ,x_results_tbl => l_results_tbl

Line 528: WHEN BIS_GNRL_SEARCH_ENGINE_PVT.e_noIndexDefined THEN

524:
525: END IF; -- ICX_SEC.validatesession()
526:
527: EXCEPTION
528: WHEN BIS_GNRL_SEARCH_ENGINE_PVT.e_noIndexDefined THEN
529: -- The following message need not be translated since this is a propagated error
530: -- due to undefined InterMedia domain Index. The Preferences and Indexes must
531: -- be created first, for the Business Views Catalog Search region to work !!
532: htp.p('

');