1 PACKAGE bis_business_views_catalog AUTHID CURRENT_USER AS
2 /* $Header: BISPBVCS.pls 115.3 99/09/17 19:17:08 porting ship $ */
3 --Constants declarations
4 c_title CONSTANT varchar2(400) := ICX_UTIL.getPrompt(191, 'BIS_BVC_PROMPTS', 191, 'BIS_BVC_TITLE');
5 c_submit CONSTANT varchar2(100) := ICX_UTIL.getPrompt(191, 'BIS_BVC_PROMPTS', 191, 'BIS_BVC_SEARCH_BUTTON');
6 c_busarea CONSTANT varchar2(400) := ICX_UTIL.getPrompt(191, 'BIS_BVC_PROMPTS', 191, 'BIS_BVC_BUSINESS_AREA');
7 c_folder CONSTANT varchar2(80) := ICX_UTIL.getPrompt(191, 'BIS_BVC_PROMPTS', 191, 'BIS_BVC_FOLDER');
8 c_desc CONSTANT varchar2(400) := ICX_UTIL.getPrompt(191, 'BIS_BVC_PROMPTS', 191, 'BIS_BVC_DESCRIPTION');
9
10 C_MAX_HITS CONSTANT PLS_INTEGER := 200; -- To be used in case I need to stop searching after this
11 C_ROW_COUNT CONSTANT PLS_INTEGER := 40; -- To be used in case I need to show only so many at a time
12
13 -- ********************************************************
14 -- Procedure that paints the search form as a plug
15 -- *********************************************************
16 PROCEDURE enter_query_page_plug
17 ( p_session_id IN pls_integer
18 , p_plug_id IN pls_integer
19 , p_display_name IN VARCHAR2 DEFAULT NULL
20 , p_delete IN VARCHAR2 DEFAULT 'N'
21 );
22
23 -- *******************************************************
24 -- Procedure that paints the search form again for second try
25 -- *******************************************************
26 PROCEDURE enter_query_page
27 ( p_keywords in varchar2
28 , p_lang in varchar2
29 );
30
31 -- ********************************************************
32 -- Procedure that goes throught the plsql table containing
33 -- the query hits and paints them as a html table structure
34 -- *********************************************************
35 PROCEDURE results_page
36 ( p_results_tbl IN BIS_GNRL_SEARCH_ENGINE_PVT.results_tbl_typ
37 , p_lang IN VARCHAR2
38 );
39
40 -- ********************************************************
41 -- Main procedure which cleans / validates the search words
42 -- and transfers them into a plsql table to be sent to the
43 -- package that runs the InterMedia query BIS_GNRL_SEARCH_ENGINE_PVT
44 -- **********************************************************
45 PROCEDURE query
46 ( p_keywords IN varchar2
47 , p_lang IN varchar2
48 );
49
50 -- ********************************************************
51 -- Function to get a Business Area the folder belongs to.
52 -- A folder might belong to multiple BUS areas, but this
53 -- picks the first one it finds.
54 -- ********************************************************
55 FUNCTION get_a_business_area
56 ( p_folder_id IN PLS_INTEGER
57 , p_eul IN VARCHAR2
58 )
59 RETURN VARCHAR2;
60
61 -- ********************************************************
62 -- Procedures to paint parts of HTML table/table heading
63 -- ********************************************************
64 PROCEDURE insert_heading_cell (p_text in varchar2);
65
66 PROCEDURE insert_blank_heading_cell;
67
68 PROCEDURE insert_blank_cell;
69
70
71
72 -- ******************************************************
73 END bis_business_views_catalog;