eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIS_BUSINESS_VIEWS_CATALOG_OA dependencies on BIS_GNRL_SEARCH_ENGINE_PVT_OA

Line 15: return bis_gnrl_search_engine_pvt_oa.results_tbl_typ

11: FUNCTION get_a_business_area
12: ( p_folder_id IN PLS_INTEGER
13: , p_eul IN VARCHAR2
14: )
15: return bis_gnrl_search_engine_pvt_oa.results_tbl_typ
16: --RETURN VARCHAR2
17: IS
18:
19: l_sql varchar2(1000);

Line 21: l_ba_name bis_gnrl_search_engine_pvt_oa.results_tbl_typ;

17: IS
18:
19: l_sql varchar2(1000);
20: --l_ba_name varchar2(256);
21: l_ba_name bis_gnrl_search_engine_pvt_oa.results_tbl_typ;
22:
23: TYPE Recdc_ba IS REF CURSOR;
24: dc_ba Recdc_ba;
25:

Line 34: l_disco_table_version := BIS_GNRL_SEARCH_ENGINE_PVT_OA.get_eul_table_version;

30: pv_cntr number;
31: l_disco_table_version varchar2(10);
32: BEGIN
33:
34: l_disco_table_version := BIS_GNRL_SEARCH_ENGINE_PVT_OA.get_eul_table_version;
35: pv_dc_query := 'select distinct ' ||
36: ' ba_name ' ||
37: ' ,ba_id ' ||
38: ' from ' ||

Line 89: ( p_results_tbl IN BIS_GNRL_SEARCH_ENGINE_PVT_OA.results_tbl_typ

85: -- *************************************************************
86: -- Paint the results table
87: -- *************************************************************
88: PROCEDURE results_page
89: ( p_results_tbl IN BIS_GNRL_SEARCH_ENGINE_PVT_OA.results_tbl_typ
90: , p_lang IN VARCHAR2
91: )
92:
93: IS

Line 98: JAIRl_eul BIS_GNRL_SEARCH_ENGINE_PVT_OA.EUL_results;

94:
95: l_prompts ICX_UTIL.g_prompts_table;
96: l_region_name varchar2(256);
97: l_eul VARCHAR2(256);
98: JAIRl_eul BIS_GNRL_SEARCH_ENGINE_PVT_OA.EUL_results;
99: i PLS_INTEGER;
100: --l_ba varchar2(240);
101: l_ba bis_gnrl_search_engine_pvt_oa.results_tbl_typ;
102:

Line 101: l_ba bis_gnrl_search_engine_pvt_oa.results_tbl_typ;

97: l_eul VARCHAR2(256);
98: JAIRl_eul BIS_GNRL_SEARCH_ENGINE_PVT_OA.EUL_results;
99: i PLS_INTEGER;
100: --l_ba varchar2(240);
101: l_ba bis_gnrl_search_engine_pvt_oa.results_tbl_typ;
102:
103: pv_is_accessible varchar2(10);
104:
105: BEGIN

Line 114: JAIRl_eul := BIS_GNRL_SEARCH_ENGINE_PVT_OA.get_a_index_owner

110: IF (p_results_tbl.COUNT = 0) THEN NULL;
111:
112: ELSE
113:
114: JAIRl_eul := BIS_GNRL_SEARCH_ENGINE_PVT_OA.get_a_index_owner
115: ( 'BIS_BV_FOLDER_NAMES_' || p_lang );
116:
117: IF (JAIRl_eul IS NULL) THEN RAISE BIS_GNRL_SEARCH_ENGINE_PVT_OA.e_noIndexDefined;
118: END IF;

Line 117: IF (JAIRl_eul IS NULL) THEN RAISE BIS_GNRL_SEARCH_ENGINE_PVT_OA.e_noIndexDefined;

113:
114: JAIRl_eul := BIS_GNRL_SEARCH_ENGINE_PVT_OA.get_a_index_owner
115: ( 'BIS_BV_FOLDER_NAMES_' || p_lang );
116:
117: IF (JAIRl_eul IS NULL) THEN RAISE BIS_GNRL_SEARCH_ENGINE_PVT_OA.e_noIndexDefined;
118: END IF;
119:
120: -- **************************************************
121: -- Begin painting the query results

Line 160: WHEN BIS_GNRL_SEARCH_ENGINE_PVT_OA.e_noIndexDefined THEN RAISE;

156:
157: end if; -- if p_results_tbl.count is zero
158:
159: EXCEPTION
160: WHEN BIS_GNRL_SEARCH_ENGINE_PVT_OA.e_noIndexDefined THEN RAISE;
161: WHEN OTHERS THEN htp.p(SQLERRM);
162:
163: END results_page;
164:

Line 276: JAIRl_eul BIS_GNRL_SEARCH_ENGINE_PVT_OA.eul_results;

272: l_plug_id pls_integer;
273: l_user_id pls_integer;
274: l_return_status VARCHAR2(100);
275: l_eul VARCHAR2(256);
276: JAIRl_eul BIS_GNRL_SEARCH_ENGINE_PVT_OA.eul_results;
277: l_lang VARCHAR2(100);
278: l_length pls_integer;
279: l_startpoint pls_integer;
280: l_separator pls_integer;

Line 281: l_keywords_tbl BIS_GNRL_SEARCH_ENGINE_PVT_OA.keywords_tbl_typ;

277: l_lang VARCHAR2(100);
278: l_length pls_integer;
279: l_startpoint pls_integer;
280: l_separator pls_integer;
281: l_keywords_tbl BIS_GNRL_SEARCH_ENGINE_PVT_OA.keywords_tbl_typ;
282: l_results_tbl BIS_GNRL_SEARCH_ENGINE_PVT_OA.results_tbl_typ;
283: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
284: l_prompts ICX_UTIL.g_prompts_table;
285: l_current_key_word varchar2(2000); -- to hold the current key word

Line 282: l_results_tbl BIS_GNRL_SEARCH_ENGINE_PVT_OA.results_tbl_typ;

278: l_length pls_integer;
279: l_startpoint pls_integer;
280: l_separator pls_integer;
281: l_keywords_tbl BIS_GNRL_SEARCH_ENGINE_PVT_OA.keywords_tbl_typ;
282: l_results_tbl BIS_GNRL_SEARCH_ENGINE_PVT_OA.results_tbl_typ;
283: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
284: l_prompts ICX_UTIL.g_prompts_table;
285: l_current_key_word varchar2(2000); -- to hold the current key word
286: v_keywords varchar2(32000);

Line 288: p_jair_results_tbl BIS_GNRL_SEARCH_ENGINE_PVT_OA.results_tbl_typ;

284: l_prompts ICX_UTIL.g_prompts_table;
285: l_current_key_word varchar2(2000); -- to hold the current key word
286: v_keywords varchar2(32000);
287:
288: p_jair_results_tbl BIS_GNRL_SEARCH_ENGINE_PVT_OA.results_tbl_typ;
289: pv_cnt number := 0;
290:
291:
292: BEGIN

Line 369: JAIRl_eul := BIS_GNRL_SEARCH_ENGINE_PVT_OA.get_a_index_owner( 'BIS_BV_FOLDER_NAMES_' || l_lang );

365:
366:
367: -- if Business Views InterMedia Indexes have been installed in
368: -- several schemas, some schema is chosen, arbitrarily.
369: JAIRl_eul := BIS_GNRL_SEARCH_ENGINE_PVT_OA.get_a_index_owner( 'BIS_BV_FOLDER_NAMES_' || l_lang );
370:
371:
372: IF (JAIRl_eul IS NULL) THEN RAISE BIS_GNRL_SEARCH_ENGINE_PVT_OA.e_noIndexDefined;
373: END IF;

Line 372: IF (JAIRl_eul IS NULL) THEN RAISE BIS_GNRL_SEARCH_ENGINE_PVT_OA.e_noIndexDefined;

368: -- several schemas, some schema is chosen, arbitrarily.
369: JAIRl_eul := BIS_GNRL_SEARCH_ENGINE_PVT_OA.get_a_index_owner( 'BIS_BV_FOLDER_NAMES_' || l_lang );
370:
371:
372: IF (JAIRl_eul IS NULL) THEN RAISE BIS_GNRL_SEARCH_ENGINE_PVT_OA.e_noIndexDefined;
373: END IF;
374:
375: for i in 1..JAIRl_eul.count loop
376: BEGIN

Line 379: BIS_GNRL_SEARCH_ENGINE_PVT_OA.build_query

375: for i in 1..JAIRl_eul.count loop
376: BEGIN
377: -- Now call the package to build and run the InterMedia
378: -- query and obtain the best row hits
379: BIS_GNRL_SEARCH_ENGINE_PVT_OA.build_query
380: ( p_api_version => 1.0
381: ,p_eul => JAIRl_eul(i).eul_schema
382: ,p_keywords_tbl => l_keywords_tbl
383: ,x_results_tbl => l_results_tbl

Line 518: l_disco_table_version := BIS_GNRL_SEARCH_ENGINE_PVT_OA.get_eul_table_version;

514: pv_dc_query varchar2(2000);
515: l_disco_table_version varchar2(10);
516: begin
517:
518: l_disco_table_version := BIS_GNRL_SEARCH_ENGINE_PVT_OA.get_eul_table_version;
519: pv_dc_query := 'select ' ||
520: ' count (distinct ap.gba_ba_id) ' ||
521: ' from ' ||
522: x_eul || '.' || l_disco_table_version ||'_bas ba, ' ||