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