APPS.IEM_EMAIL_PROC_PVT dependencies on CS_KB_VARCHAR100_TBL_TYPE

Line 5497: l_rep cs_kb_varchar100_tbl_type ;

5493: l_result_array cs_kb_result_varray_type;
5494: l_amv_result_array AMV_SEARCH_PVT.amv_searchres_varray_type;
5495: l_content_array AMV_SEARCH_PVT.amv_char_varray_type:=null;
5496: l_param_array AMV_SEARCH_PVT.amv_searchpar_varray_type;
5497: l_rep cs_kb_varchar100_tbl_type ;
5498: l_imt_string varchar2(4000);
5499: r_imt_string varchar2(4000);
5500: l_proc_name varchar2(30):='IEM_WF_SPECIFICSEARCH';
5501: --l_category_id AMV_SEARCH_PVT.amv_number_varray_type:=AMV_SEARCH_PVT.amv_number_varray_type();

Line 5554: l_rep :=cs_kb_varchar100_tbl_type() ;

5550: l_content_array.extend;
5551: l_content_array(1) := 'CONTENT';
5552: l_content_array.extend;
5553: l_param_array := AMV_SEARCH_PVT.amv_searchpar_varray_type();
5554: l_rep :=cs_kb_varchar100_tbl_type() ;
5555: begin
5556: select classification_string into l_imt_string
5557: from IEM_EMAIL_CLASSIFICATIONS
5558: WHERE MESSAGE_ID=l_msg_id AND EMAIL_ACCOUNT_ID=l_email_account_id

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

5569: if g_statement_log then
5570: l_logmessage:= 'Calling the MES Specific Search For Message Id '||l_msg_id;
5571: iem_logger(l_logmessage);
5572: end if;
5573: l_rep :=cs_kb_varchar100_tbl_type('MES') ;
5574: cs_knowledge_grp.Specific_Search(
5575: p_api_version => 1.0,
5576: p_init_msg_list => fnd_api.g_true,
5577: --p_validation_level => p_validation_level,

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

5723: if g_statement_log then
5724: l_logmessage:= 'Calling the SMS Specific Search For Message Id '||l_msg_id;
5725: iem_logger(l_logmessage);
5726: end if;
5727: l_rep :=cs_kb_varchar100_tbl_type('SMS') ;
5728: -- Currently SMS has 255 character limitations . So we have to
5729: --truncate the SMS search string to 255 character length which
5730: --will removed later
5731: IF length(l_imt_string)>255 THEN