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,
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,
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,
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,
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,
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
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,
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,
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
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,
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,
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,