DBA Data[Home] [Help]

APPS.IBU_KNOWLEDGE_GRP dependencies on CS_KB_NUMBER_TBL_TYPE

Line 136: p_rows_requested_tbl IN cs_kb_number_tbl_type,

132: p_user_id IN NUMBER := NULL,
133: p_category_id IN JTF_NUMBER_TABLE,
134: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
135: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
136: p_rows_requested_tbl IN cs_kb_number_tbl_type,
137: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
138: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
139: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,
140: x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,

Line 137: p_start_row_pos_tbl IN cs_kb_number_tbl_type,

133: p_category_id IN JTF_NUMBER_TABLE,
134: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
135: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
136: p_rows_requested_tbl IN cs_kb_number_tbl_type,
137: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
138: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
139: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,
140: x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,
141: x_total_row_cnt_tbl OUT NOCOPY cs_kb_number_tbl_type,

Line 139: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,

135: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
136: p_rows_requested_tbl IN cs_kb_number_tbl_type,
137: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
138: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
139: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,
140: x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,
141: x_total_row_cnt_tbl OUT NOCOPY cs_kb_number_tbl_type,
142: x_result_array OUT NOCOPY cs_kb_result_varray_type
143: )is

Line 140: x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,

136: p_rows_requested_tbl IN cs_kb_number_tbl_type,
137: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
138: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
139: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,
140: x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,
141: x_total_row_cnt_tbl OUT NOCOPY cs_kb_number_tbl_type,
142: x_result_array OUT NOCOPY cs_kb_result_varray_type
143: )is
144: l_param_array AMV_SEARCH_PVT.amv_searchpar_varray_type

Line 141: x_total_row_cnt_tbl OUT NOCOPY cs_kb_number_tbl_type,

137: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
138: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
139: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,
140: x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,
141: x_total_row_cnt_tbl OUT NOCOPY cs_kb_number_tbl_type,
142: x_result_array OUT NOCOPY cs_kb_result_varray_type
143: )is
144: l_param_array AMV_SEARCH_PVT.amv_searchpar_varray_type
145: := AMV_SEARCH_PVT.amv_searchpar_varray_type();

Line 266: p_rows_requested_tbl IN cs_kb_number_tbl_type,

262: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type
263: :=AMV_SEARCH_PVT.amv_number_varray_type(),
264: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
265: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
266: p_rows_requested_tbl IN cs_kb_number_tbl_type,
267: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
268: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
269: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,
270: x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,

Line 267: p_start_row_pos_tbl IN cs_kb_number_tbl_type,

263: :=AMV_SEARCH_PVT.amv_number_varray_type(),
264: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
265: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
266: p_rows_requested_tbl IN cs_kb_number_tbl_type,
267: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
268: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
269: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,
270: x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,
271: x_total_row_cnt_tbl OUT NOCOPY cs_kb_number_tbl_type,

Line 269: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,

265: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
266: p_rows_requested_tbl IN cs_kb_number_tbl_type,
267: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
268: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
269: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,
270: x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,
271: x_total_row_cnt_tbl OUT NOCOPY cs_kb_number_tbl_type,
272: x_result_array OUT NOCOPY cs_kb_result_varray_type,
273: x_amv_result_array OUT NOCOPY AMV_SEARCH_PVT.amv_searchres_varray_type

Line 270: x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,

266: p_rows_requested_tbl IN cs_kb_number_tbl_type,
267: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
268: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
269: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,
270: x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,
271: x_total_row_cnt_tbl OUT NOCOPY cs_kb_number_tbl_type,
272: x_result_array OUT NOCOPY cs_kb_result_varray_type,
273: x_amv_result_array OUT NOCOPY AMV_SEARCH_PVT.amv_searchres_varray_type
274: )is

Line 271: x_total_row_cnt_tbl OUT NOCOPY cs_kb_number_tbl_type,

267: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
268: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
269: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,
270: x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,
271: x_total_row_cnt_tbl OUT NOCOPY cs_kb_number_tbl_type,
272: x_result_array OUT NOCOPY cs_kb_result_varray_type,
273: x_amv_result_array OUT NOCOPY AMV_SEARCH_PVT.amv_searchres_varray_type
274: )is
275: l_api_name CONSTANT varchar2(30) := 'Specific_Search';

Line 314: x_rows_returned_tbl := cs_kb_number_tbl_type();

310: -- x_row_return_obj := cs_kb_rowret_obj_type(0, 0, 0);
311:
312: -- this same array can be wrtten by both sms and mes search in out.
313: x_result_array := cs_kb_result_varray_type();
314: x_rows_returned_tbl := cs_kb_number_tbl_type();
315: x_next_row_pos_tbl :=cs_kb_number_tbl_type();
316: x_total_row_cnt_tbl :=cs_kb_number_tbl_type();
317:
318:

Line 315: x_next_row_pos_tbl :=cs_kb_number_tbl_type();

311:
312: -- this same array can be wrtten by both sms and mes search in out.
313: x_result_array := cs_kb_result_varray_type();
314: x_rows_returned_tbl := cs_kb_number_tbl_type();
315: x_next_row_pos_tbl :=cs_kb_number_tbl_type();
316: x_total_row_cnt_tbl :=cs_kb_number_tbl_type();
317:
318:
319: if(p_repository_tbl is null) then

Line 316: x_total_row_cnt_tbl :=cs_kb_number_tbl_type();

312: -- this same array can be wrtten by both sms and mes search in out.
313: x_result_array := cs_kb_result_varray_type();
314: x_rows_returned_tbl := cs_kb_number_tbl_type();
315: x_next_row_pos_tbl :=cs_kb_number_tbl_type();
316: x_total_row_cnt_tbl :=cs_kb_number_tbl_type();
317:
318:
319: if(p_repository_tbl is null) then
320: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then