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,
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,
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: );
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:
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: --
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,
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,
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
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: );
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: