DBA Data[Home] [Help]

APPS.IEM_TEXT_PVT dependencies on CS_KB_VARCHAR100_TBL_TYPE

Line 435: l_rep cs_kb_varchar100_tbl_type ;

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;
439: l_res1 varchar2(10);

Line 475: l_rep :=cs_kb_varchar100_tbl_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,
479: p_init_msg_list => fnd_api.g_true,

Line 476: l_rep :=cs_kb_varchar100_tbl_type('MES') ;

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,
479: p_init_msg_list => fnd_api.g_true,
480: --p_validation_level => p_validation_level,

Line 525: l_rep :=cs_kb_varchar100_tbl_type('SMS') ;

521: l_result_array(l_count).score);
522: END LOOP;
523: end if;
524:
525: l_rep :=cs_kb_varchar100_tbl_type('SMS') ;
526: IF length(l_imt_string)>255 THEN
527: l_sms_string:=substr(l_imt_string,1,255);
528: l_sms_count:=instr(l_sms_string,',about',-1,1);
529: l_imt_string:=substr(l_sms_string,1,l_sms_count-1);