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.IEM_EMAIL_PROC_PVT dependencies on AMV_SEARCH_PVT

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

146: l_contact_id number;
147: l_party_id number;
148: l_party_type varchar2(100);
149: l_id number;
150: l_category_id AMV_SEARCH_PVT.amv_number_varray_type:=AMV_SEARCH_PVT.amv_number_varray_type();
151: l_repos varchar2(100); -- MES/KM search repository
152: l_ext_address varchar2(250); --external email address for redirecting
153: l_ext_temp_id number; -- template id created to be used for redirecting external
154: l_ext_subject varchar2(500); -- prefix for redirect email subject

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

3743: l_msg_count number;
3744: l_msg_data varchar2(500);
3745: l_uid number;
3746: l_status varchar2(100);
3747: l_category_id AMV_SEARCH_PVT.amv_number_varray_type:=AMV_SEARCH_PVT.amv_number_varray_type();
3748: CUSTOM_WF_EXCEP EXCEPTION;
3749: MOVE_MSG_EXCEP EXCEPTION;
3750: PROC_ERROR EXCEPTION;
3751: PROCESS_BEFORE EXCEPTION;

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

4923: l_rule_id number;
4924: l_search_type varchar2(100);
4925: l_repos varchar2(100);
4926: l_cm_cat_id number; -- store the category for MES category based mapping
4927: l_category_id AMV_SEARCH_PVT.amv_number_varray_type:=AMV_SEARCH_PVT.amv_number_varray_type();
4928: l_cat_counter number;
4929: l_group_id number;
4930: l_status varchar2(10);
4931: l_out_text varchar2(255);

Line 5464: l_category_id AMV_SEARCH_PVT.amv_number_varray_type,

5460: procedure IEM_WF_SPECIFICSEARCH(
5461: l_msg_id in number,
5462: l_email_account_id in number,
5463: l_classification_id in number,
5464: l_category_id AMV_SEARCH_PVT.amv_number_varray_type,
5465: l_repos in varchar2,
5466: l_stat out nocopy varchar2,
5467: l_out_text out nocopy varchar2)
5468: is

Line 5492: l_area_array AMV_SEARCH_PVT.amv_char_varray_type:=null;

5488: l_class NUMBER;
5489: l_count NUMBER;
5490: l_next_row_tbl cs_kb_number_tbl_type:=cs_kb_number_tbl_type();
5491: l_total_row_tbl cs_kb_number_tbl_type:=cs_kb_number_tbl_type();
5492: l_area_array AMV_SEARCH_PVT.amv_char_varray_type:=null;
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;

Line 5494: l_amv_result_array AMV_SEARCH_PVT.amv_searchres_varray_type;

5490: l_next_row_tbl cs_kb_number_tbl_type:=cs_kb_number_tbl_type();
5491: l_total_row_tbl cs_kb_number_tbl_type:=cs_kb_number_tbl_type();
5492: l_area_array AMV_SEARCH_PVT.amv_char_varray_type:=null;
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);

Line 5495: l_content_array AMV_SEARCH_PVT.amv_char_varray_type:=null;

5491: l_total_row_tbl cs_kb_number_tbl_type:=cs_kb_number_tbl_type();
5492: l_area_array AMV_SEARCH_PVT.amv_char_varray_type:=null;
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);

Line 5496: l_param_array AMV_SEARCH_PVT.amv_searchpar_varray_type;

5492: l_area_array AMV_SEARCH_PVT.amv_char_varray_type:=null;
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';

Line 5501: --l_category_id AMV_SEARCH_PVT.amv_number_varray_type:=AMV_SEARCH_PVT.amv_number_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();
5502: l_tag1 number;
5503: l_cnt number;
5504: l_res1 varchar2(10);
5505: l_res2 varchar2(10);

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

5542:
5543: l_rows:=10; -- Number of Document Retrieved...
5544: l_rows_req :=cs_kb_number_tbl_type(l_rows,l_rows);
5545: G_APP_ID:=520;
5546: l_area_array := AMV_SEARCH_PVT.amv_char_varray_type();
5547: l_area_array.extend;
5548: l_area_array(1) := 'ITEM';
5549: l_content_array := AMV_SEARCH_PVT.amv_char_varray_type();
5550: l_content_array.extend;

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

5545: G_APP_ID:=520;
5546: l_area_array := AMV_SEARCH_PVT.amv_char_varray_type();
5547: l_area_array.extend;
5548: l_area_array(1) := 'ITEM';
5549: l_content_array := AMV_SEARCH_PVT.amv_char_varray_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();

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

5549: l_content_array := AMV_SEARCH_PVT.amv_char_varray_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