DBA Data[Home] [Help]

APPS.IEM_TEXT_PVT dependencies on AMV_SEARCH_PVT

Line 430: l_area_array AMV_SEARCH_PVT.amv_char_varray_type:=null;

426: l_class NUMBER;
427: l_count NUMBER;
428: l_next_row_tbl cs_kb_number_tbl_type:=cs_kb_number_tbl_type();
429: l_total_row_tbl cs_kb_number_tbl_type:=cs_kb_number_tbl_type();
430: l_area_array AMV_SEARCH_PVT.amv_char_varray_type:=null;
431: l_result_array cs_kb_result_varray_type;
432: l_amv_result_array AMV_SEARCH_PVT.amv_searchres_varray_type;
433: l_content_array AMV_SEARCH_PVT.amv_char_varray_type:=null;
434: l_param_array AMV_SEARCH_PVT.amv_searchpar_varray_type;

Line 432: l_amv_result_array AMV_SEARCH_PVT.amv_searchres_varray_type;

428: l_next_row_tbl cs_kb_number_tbl_type:=cs_kb_number_tbl_type();
429: l_total_row_tbl cs_kb_number_tbl_type:=cs_kb_number_tbl_type();
430: l_area_array AMV_SEARCH_PVT.amv_char_varray_type:=null;
431: l_result_array cs_kb_result_varray_type;
432: l_amv_result_array AMV_SEARCH_PVT.amv_searchres_varray_type;
433: l_content_array AMV_SEARCH_PVT.amv_char_varray_type:=null;
434: l_param_array AMV_SEARCH_PVT.amv_searchpar_varray_type;
435: l_rep cs_kb_varchar100_tbl_type ;
436: l_category_id AMV_SEARCH_PVT.amv_number_varray_type:=AMV_SEARCH_PVT.amv_number_varray_type();

Line 433: l_content_array AMV_SEARCH_PVT.amv_char_varray_type:=null;

429: l_total_row_tbl cs_kb_number_tbl_type:=cs_kb_number_tbl_type();
430: l_area_array AMV_SEARCH_PVT.amv_char_varray_type:=null;
431: l_result_array cs_kb_result_varray_type;
432: l_amv_result_array AMV_SEARCH_PVT.amv_searchres_varray_type;
433: l_content_array AMV_SEARCH_PVT.amv_char_varray_type:=null;
434: l_param_array AMV_SEARCH_PVT.amv_searchpar_varray_type;
435: l_rep cs_kb_varchar100_tbl_type ;
436: l_category_id AMV_SEARCH_PVT.amv_number_varray_type:=AMV_SEARCH_PVT.amv_number_varray_type();
437: l_tag1 number;

Line 434: l_param_array AMV_SEARCH_PVT.amv_searchpar_varray_type;

430: l_area_array AMV_SEARCH_PVT.amv_char_varray_type:=null;
431: l_result_array cs_kb_result_varray_type;
432: l_amv_result_array AMV_SEARCH_PVT.amv_searchres_varray_type;
433: l_content_array AMV_SEARCH_PVT.amv_char_varray_type:=null;
434: l_param_array AMV_SEARCH_PVT.amv_searchpar_varray_type;
435: l_rep cs_kb_varchar100_tbl_type ;
436: l_category_id AMV_SEARCH_PVT.amv_number_varray_type:=AMV_SEARCH_PVT.amv_number_varray_type();
437: l_tag1 number;
438: l_cnt number;

Line 436: l_category_id AMV_SEARCH_PVT.amv_number_varray_type:=AMV_SEARCH_PVT.amv_number_varray_type();

432: l_amv_result_array AMV_SEARCH_PVT.amv_searchres_varray_type;
433: l_content_array AMV_SEARCH_PVT.amv_char_varray_type:=null;
434: l_param_array AMV_SEARCH_PVT.amv_searchpar_varray_type;
435: l_rep cs_kb_varchar100_tbl_type ;
436: l_category_id AMV_SEARCH_PVT.amv_number_varray_type:=AMV_SEARCH_PVT.amv_number_varray_type();
437: l_tag1 number;
438: l_cnt number;
439: l_res1 varchar2(10);
440: l_res2 varchar2(10);

Line 467: l_area_array := AMV_SEARCH_PVT.amv_char_varray_type();

463: l_search_repos:='ALL';
464: l_rows:=10; -- Number of Document Retrieved...
465: l_rows_req :=cs_kb_number_tbl_type(l_rows,l_rows);
466: G_APP_ID:=520;
467: l_area_array := AMV_SEARCH_PVT.amv_char_varray_type();
468: l_area_array.extend;
469: l_area_array(1) := 'ITEM';
470: l_content_array := AMV_SEARCH_PVT.amv_char_varray_type();
471: l_content_array.extend;

Line 470: l_content_array := AMV_SEARCH_PVT.amv_char_varray_type();

466: G_APP_ID:=520;
467: l_area_array := AMV_SEARCH_PVT.amv_char_varray_type();
468: l_area_array.extend;
469: l_area_array(1) := 'ITEM';
470: l_content_array := AMV_SEARCH_PVT.amv_char_varray_type();
471: l_content_array.extend;
472: l_content_array(1) := 'CONTENT';
473: l_content_array.extend;
474: l_param_array := AMV_SEARCH_PVT.amv_searchpar_varray_type();

Line 474: l_param_array := AMV_SEARCH_PVT.amv_searchpar_varray_type();

470: l_content_array := AMV_SEARCH_PVT.amv_char_varray_type();
471: l_content_array.extend;
472: l_content_array(1) := 'CONTENT';
473: l_content_array.extend;
474: l_param_array := AMV_SEARCH_PVT.amv_searchpar_varray_type();
475: l_rep :=cs_kb_varchar100_tbl_type() ;
476: l_rep :=cs_kb_varchar100_tbl_type('MES') ;
477: cs_knowledge_grp.Specific_Search(
478: p_api_version => 1.0,