1 PACKAGE IBU_Knowledge_Grp AS
2 /* $Header: ibugkbs.pls 120.0 2005/09/12 10:17:12 ktma noship $ */
3
4
5
6 --
7 -- CONSTANTS
8 --
9
10 G_PKG_NAME CONSTANT VARCHAR2(50) := 'IBU_Knowledge_GRP';
11
12 -- This api is called by java.
13 -- It takes object params, convert to amv record types and call
14 -- the record type api.
15 --
16 PROCEDURE Specific_Search(
17 p_api_version IN NUMBER,
18 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
19 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
20 x_return_status OUT NOCOPY VARCHAR2,
21 x_msg_count OUT NOCOPY NUMBER,
22 x_msg_data OUT NOCOPY VARCHAR2,
23 p_repository_tbl IN cs_kb_varchar100_tbl_type,
24 p_search_string IN VARCHAR2 := NULL,
25 p_updated_in_days IN NUMBER := NULL,
26 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
27 p_application_id IN NUMBER,
28 p_area_array IN JTF_VARCHAR2_TABLE_4000 := null,
29 p_content_array IN JTF_VARCHAR2_TABLE_4000 := null,
30 p_param_operator_array IN JTF_VARCHAR2_TABLE_100 := null,
31 p_param_searchstring_array IN JTF_VARCHAR2_TABLE_400 := null,
32 p_user_id IN NUMBER := NULL,
33 p_category_id IN JTF_NUMBER_TABLE,
34 p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
35 p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
36 p_rows_requested_tbl IN cs_kb_number_tbl_type,
37 p_start_row_pos_tbl IN cs_kb_number_tbl_type,
38 p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
39 x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,
40 x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,
41 x_total_row_cnt_tbl OUT NOCOPY cs_kb_number_tbl_type,
42 x_result_array OUT NOCOPY cs_kb_result_varray_type
43 );
44
45 --
46 -- Main Specific search
47 -- Same as above. With x_amv_result_array out parameter returned from Amv.
48 --
49 PROCEDURE Specific_Search(
50 p_api_version IN NUMBER,
51 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
52 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
53 x_return_status OUT NOCOPY VARCHAR2,
54 x_msg_count OUT NOCOPY NUMBER,
55 x_msg_data OUT NOCOPY VARCHAR2,
56 p_repository_tbl IN cs_kb_varchar100_tbl_type,
57 p_search_string IN VARCHAR2 := NULL,
58 p_updated_in_days IN NUMBER := NULL,
59 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
60 p_application_id IN NUMBER,
61 p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type
62 := AMV_SEARCH_PVT.amv_char_varray_type(),
63 p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type
64 := AMV_SEARCH_PVT.amv_char_varray_type(),
65 p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type
66 := AMV_SEARCH_PVT.amv_searchpar_varray_type(),
67 p_user_id IN NUMBER := NULL,
68 p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type
69 := AMV_SEARCH_PVT.amv_number_varray_type(),
70 p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
71 p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
72 p_rows_requested_tbl IN cs_kb_number_tbl_type,
73 p_start_row_pos_tbl IN cs_kb_number_tbl_type,
74 p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
75 x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,
76 x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,
77 x_total_row_cnt_tbl OUT NOCOPY cs_kb_number_tbl_type,
78 x_result_array OUT NOCOPY cs_kb_result_varray_type,
79 x_amv_result_array OUT NOCOPY AMV_SEARCH_PVT.amv_searchres_varray_type
80 );
81
82
83 end IBU_Knowledge_Grp;