eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBU_KNOWLEDGE_GRP dependencies on AMV_SEARCH_PVT

Line 16: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type

12: p_search_string IN VARCHAR2 := NULL,
13: p_updated_in_days IN NUMBER := NULL,
14: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
15: p_application_id IN NUMBER,
16: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type
17: := null, --amv_search_grp.Default_AreaArray,
18: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type
19: := null, --amv_search_grp.Default_ContentArray,
20: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type,

Line 18: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type

14: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
15: p_application_id IN NUMBER,
16: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type
17: := null, --amv_search_grp.Default_AreaArray,
18: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type
19: := null, --amv_search_grp.Default_ContentArray,
20: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type,
21: p_user_id IN NUMBER := NULL,
22: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type,

Line 20: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type,

16: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type
17: := null, --amv_search_grp.Default_AreaArray,
18: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type
19: := null, --amv_search_grp.Default_ContentArray,
20: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type,
21: p_user_id IN NUMBER := NULL,
22: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type,
23: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
24: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,

Line 22: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type,

18: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type
19: := null, --amv_search_grp.Default_ContentArray,
20: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type,
21: p_user_id IN NUMBER := NULL,
22: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type,
23: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
24: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
25: p_rows_requested IN NUMBER,
26: p_start_row_pos IN NUMBER := 1,

Line 32: x_amv_result_array OUT NOCOPY AMV_SEARCH_PVT.amv_searchres_varray_type

28: x_rows_returned OUT NOCOPY NUMBER,
29: x_next_row_pos OUT NOCOPY NUMBER,
30: x_total_row_cnt OUT NOCOPY NUMBER,
31: x_result_array IN OUT NOCOPY cs_kb_result_varray_type,
32: x_amv_result_array OUT NOCOPY AMV_SEARCH_PVT.amv_searchres_varray_type
33: ) is
34: l_amv_req_obj AMV_SEARCH_PVT.amv_request_obj_type;
35: l_amv_ret_obj AMV_SEARCH_PVT.amv_return_obj_type;
36: l_amv_res_array AMV_SEARCH_PVT.amv_searchres_varray_type;

Line 34: l_amv_req_obj AMV_SEARCH_PVT.amv_request_obj_type;

30: x_total_row_cnt OUT NOCOPY NUMBER,
31: x_result_array IN OUT NOCOPY cs_kb_result_varray_type,
32: x_amv_result_array OUT NOCOPY AMV_SEARCH_PVT.amv_searchres_varray_type
33: ) is
34: l_amv_req_obj AMV_SEARCH_PVT.amv_request_obj_type;
35: l_amv_ret_obj AMV_SEARCH_PVT.amv_return_obj_type;
36: l_amv_res_array AMV_SEARCH_PVT.amv_searchres_varray_type;
37: l_ret_cnt pls_integer :=0;
38: l_search_string VARCHAR2(150) := p_search_string;

Line 35: l_amv_ret_obj AMV_SEARCH_PVT.amv_return_obj_type;

31: x_result_array IN OUT NOCOPY cs_kb_result_varray_type,
32: x_amv_result_array OUT NOCOPY AMV_SEARCH_PVT.amv_searchres_varray_type
33: ) is
34: l_amv_req_obj AMV_SEARCH_PVT.amv_request_obj_type;
35: l_amv_ret_obj AMV_SEARCH_PVT.amv_return_obj_type;
36: l_amv_res_array AMV_SEARCH_PVT.amv_searchres_varray_type;
37: l_ret_cnt pls_integer :=0;
38: l_search_string VARCHAR2(150) := p_search_string;
39: l_updated_in_days NUMBER := p_updated_in_days;

Line 36: l_amv_res_array AMV_SEARCH_PVT.amv_searchres_varray_type;

32: x_amv_result_array OUT NOCOPY AMV_SEARCH_PVT.amv_searchres_varray_type
33: ) is
34: l_amv_req_obj AMV_SEARCH_PVT.amv_request_obj_type;
35: l_amv_ret_obj AMV_SEARCH_PVT.amv_return_obj_type;
36: l_amv_res_array AMV_SEARCH_PVT.amv_searchres_varray_type;
37: l_ret_cnt pls_integer :=0;
38: l_search_string VARCHAR2(150) := p_search_string;
39: l_updated_in_days NUMBER := p_updated_in_days;
40: l_user_id NUMBER := p_user_id;

Line 144: l_param_array AMV_SEARCH_PVT.amv_searchpar_varray_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();
146: l_area_array AMV_SEARCH_PVT.amv_char_varray_type
147: := AMV_SEARCH_PVT.amv_char_varray_type();
148: l_content_array AMV_SEARCH_PVT.amv_char_varray_type

Line 145: := AMV_SEARCH_PVT.amv_searchpar_varray_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();
146: l_area_array AMV_SEARCH_PVT.amv_char_varray_type
147: := AMV_SEARCH_PVT.amv_char_varray_type();
148: l_content_array AMV_SEARCH_PVT.amv_char_varray_type
149: := AMV_SEARCH_PVT.amv_char_varray_type();

Line 146: l_area_array AMV_SEARCH_PVT.amv_char_varray_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();
146: l_area_array AMV_SEARCH_PVT.amv_char_varray_type
147: := AMV_SEARCH_PVT.amv_char_varray_type();
148: l_content_array AMV_SEARCH_PVT.amv_char_varray_type
149: := AMV_SEARCH_PVT.amv_char_varray_type();
150: l_category_id AMV_SEARCH_PVT.amv_number_varray_type

Line 147: := AMV_SEARCH_PVT.amv_char_varray_type();

143: )is
144: l_param_array AMV_SEARCH_PVT.amv_searchpar_varray_type
145: := AMV_SEARCH_PVT.amv_searchpar_varray_type();
146: l_area_array AMV_SEARCH_PVT.amv_char_varray_type
147: := AMV_SEARCH_PVT.amv_char_varray_type();
148: l_content_array AMV_SEARCH_PVT.amv_char_varray_type
149: := AMV_SEARCH_PVT.amv_char_varray_type();
150: l_category_id AMV_SEARCH_PVT.amv_number_varray_type
151: := AMV_SEARCH_PVT.amv_number_varray_type();

Line 148: l_content_array AMV_SEARCH_PVT.amv_char_varray_type

144: l_param_array AMV_SEARCH_PVT.amv_searchpar_varray_type
145: := AMV_SEARCH_PVT.amv_searchpar_varray_type();
146: l_area_array AMV_SEARCH_PVT.amv_char_varray_type
147: := AMV_SEARCH_PVT.amv_char_varray_type();
148: l_content_array AMV_SEARCH_PVT.amv_char_varray_type
149: := AMV_SEARCH_PVT.amv_char_varray_type();
150: l_category_id AMV_SEARCH_PVT.amv_number_varray_type
151: := AMV_SEARCH_PVT.amv_number_varray_type();
152: l_amv_result_array AMV_SEARCH_PVT.amv_searchres_varray_type;

Line 149: := AMV_SEARCH_PVT.amv_char_varray_type();

145: := AMV_SEARCH_PVT.amv_searchpar_varray_type();
146: l_area_array AMV_SEARCH_PVT.amv_char_varray_type
147: := AMV_SEARCH_PVT.amv_char_varray_type();
148: l_content_array AMV_SEARCH_PVT.amv_char_varray_type
149: := AMV_SEARCH_PVT.amv_char_varray_type();
150: l_category_id AMV_SEARCH_PVT.amv_number_varray_type
151: := AMV_SEARCH_PVT.amv_number_varray_type();
152: l_amv_result_array AMV_SEARCH_PVT.amv_searchres_varray_type;
153: i1 pls_integer;

Line 150: l_category_id AMV_SEARCH_PVT.amv_number_varray_type

146: l_area_array AMV_SEARCH_PVT.amv_char_varray_type
147: := AMV_SEARCH_PVT.amv_char_varray_type();
148: l_content_array AMV_SEARCH_PVT.amv_char_varray_type
149: := AMV_SEARCH_PVT.amv_char_varray_type();
150: l_category_id AMV_SEARCH_PVT.amv_number_varray_type
151: := AMV_SEARCH_PVT.amv_number_varray_type();
152: l_amv_result_array AMV_SEARCH_PVT.amv_searchres_varray_type;
153: i1 pls_integer;
154: l_search_string VARCHAR2(150) := p_search_string;

Line 151: := AMV_SEARCH_PVT.amv_number_varray_type();

147: := AMV_SEARCH_PVT.amv_char_varray_type();
148: l_content_array AMV_SEARCH_PVT.amv_char_varray_type
149: := AMV_SEARCH_PVT.amv_char_varray_type();
150: l_category_id AMV_SEARCH_PVT.amv_number_varray_type
151: := AMV_SEARCH_PVT.amv_number_varray_type();
152: l_amv_result_array AMV_SEARCH_PVT.amv_searchres_varray_type;
153: i1 pls_integer;
154: l_search_string VARCHAR2(150) := p_search_string;
155: l_updated_in_days NUMBER := p_updated_in_days;

Line 152: l_amv_result_array AMV_SEARCH_PVT.amv_searchres_varray_type;

148: l_content_array AMV_SEARCH_PVT.amv_char_varray_type
149: := AMV_SEARCH_PVT.amv_char_varray_type();
150: l_category_id AMV_SEARCH_PVT.amv_number_varray_type
151: := AMV_SEARCH_PVT.amv_number_varray_type();
152: l_amv_result_array AMV_SEARCH_PVT.amv_searchres_varray_type;
153: i1 pls_integer;
154: l_search_string VARCHAR2(150) := p_search_string;
155: l_updated_in_days NUMBER := p_updated_in_days;
156: l_user_id NUMBER := p_user_id;

Line 255: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type

251: p_search_string IN VARCHAR2 := NULL,
252: p_updated_in_days IN NUMBER := NULL,
253: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
254: p_application_id IN NUMBER,
255: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type
256: := AMV_SEARCH_PVT.amv_char_varray_type(),
257: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type
258: := AMV_SEARCH_PVT.amv_char_varray_type(),
259: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type

Line 256: := AMV_SEARCH_PVT.amv_char_varray_type(),

252: p_updated_in_days IN NUMBER := NULL,
253: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
254: p_application_id IN NUMBER,
255: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type
256: := AMV_SEARCH_PVT.amv_char_varray_type(),
257: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type
258: := AMV_SEARCH_PVT.amv_char_varray_type(),
259: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type
260: := AMV_SEARCH_PVT.amv_searchpar_varray_type(),

Line 257: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type

253: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
254: p_application_id IN NUMBER,
255: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type
256: := AMV_SEARCH_PVT.amv_char_varray_type(),
257: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type
258: := AMV_SEARCH_PVT.amv_char_varray_type(),
259: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type
260: := AMV_SEARCH_PVT.amv_searchpar_varray_type(),
261: p_user_id IN NUMBER := NULL,

Line 258: := AMV_SEARCH_PVT.amv_char_varray_type(),

254: p_application_id IN NUMBER,
255: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type
256: := AMV_SEARCH_PVT.amv_char_varray_type(),
257: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type
258: := AMV_SEARCH_PVT.amv_char_varray_type(),
259: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type
260: := AMV_SEARCH_PVT.amv_searchpar_varray_type(),
261: p_user_id IN NUMBER := NULL,
262: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type

Line 259: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type

255: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type
256: := AMV_SEARCH_PVT.amv_char_varray_type(),
257: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type
258: := AMV_SEARCH_PVT.amv_char_varray_type(),
259: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type
260: := AMV_SEARCH_PVT.amv_searchpar_varray_type(),
261: p_user_id IN NUMBER := NULL,
262: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type
263: :=AMV_SEARCH_PVT.amv_number_varray_type(),

Line 260: := AMV_SEARCH_PVT.amv_searchpar_varray_type(),

256: := AMV_SEARCH_PVT.amv_char_varray_type(),
257: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type
258: := AMV_SEARCH_PVT.amv_char_varray_type(),
259: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type
260: := AMV_SEARCH_PVT.amv_searchpar_varray_type(),
261: p_user_id IN NUMBER := NULL,
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,

Line 262: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type

258: := AMV_SEARCH_PVT.amv_char_varray_type(),
259: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type
260: := AMV_SEARCH_PVT.amv_searchpar_varray_type(),
261: p_user_id IN NUMBER := NULL,
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,

Line 263: :=AMV_SEARCH_PVT.amv_number_varray_type(),

259: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type
260: := AMV_SEARCH_PVT.amv_searchpar_varray_type(),
261: p_user_id IN NUMBER := NULL,
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,

Line 273: x_amv_result_array OUT NOCOPY AMV_SEARCH_PVT.amv_searchres_varray_type

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';
276: l_api_version CONSTANT number := 1.0;
277: ind pls_integer; --index number