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 131: l_category_id AMV_SEARCH_PVT.amv_number_varray_type:=AMV_SEARCH_PVT.amv_number_varray_type();

127: l_contact_id number;
128: l_party_id number;
129: l_party_type varchar2(100);
130: l_id number;
131: l_category_id AMV_SEARCH_PVT.amv_number_varray_type:=AMV_SEARCH_PVT.amv_number_varray_type();
132: l_repos varchar2(100); -- MES/KM search repository
133: l_ext_address varchar2(250); --external email address for redirecting
134: l_ext_temp_id number; -- template id created to be used for redirecting external
135: l_ext_subject varchar2(500); -- prefix for redirect email subject

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

2648: l_msg_count number;
2649: l_msg_data varchar2(500);
2650: l_uid number;
2651: l_status varchar2(100);
2652: l_category_id AMV_SEARCH_PVT.amv_number_varray_type:=AMV_SEARCH_PVT.amv_number_varray_type();
2653: CUSTOM_WF_EXCEP EXCEPTION;
2654: MOVE_MSG_EXCEP EXCEPTION;
2655: PROC_ERROR EXCEPTION;
2656: PROCESS_BEFORE EXCEPTION;

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

3828: l_rule_id number;
3829: l_search_type varchar2(100);
3830: l_repos varchar2(100);
3831: l_cm_cat_id number; -- store the category for MES category based mapping
3832: l_category_id AMV_SEARCH_PVT.amv_number_varray_type:=AMV_SEARCH_PVT.amv_number_varray_type();
3833: l_cat_counter number;
3834: l_group_id number;
3835: l_status varchar2(10);
3836: l_out_text varchar2(255);

Line 4369: l_category_id AMV_SEARCH_PVT.amv_number_varray_type,

4365: procedure IEM_WF_SPECIFICSEARCH(
4366: l_msg_id in number,
4367: l_email_account_id in number,
4368: l_classification_id in number,
4369: l_category_id AMV_SEARCH_PVT.amv_number_varray_type,
4370: l_repos in varchar2,
4371: l_stat out nocopy varchar2,
4372: l_out_text out nocopy varchar2)
4373: is

Line 4397: l_area_array AMV_SEARCH_PVT.amv_char_varray_type:=null;

4393: l_class NUMBER;
4394: l_count NUMBER;
4395: l_next_row_tbl cs_kb_number_tbl_type:=cs_kb_number_tbl_type();
4396: l_total_row_tbl cs_kb_number_tbl_type:=cs_kb_number_tbl_type();
4397: l_area_array AMV_SEARCH_PVT.amv_char_varray_type:=null;
4398: l_result_array cs_kb_result_varray_type;
4399: l_amv_result_array AMV_SEARCH_PVT.amv_searchres_varray_type;
4400: l_content_array AMV_SEARCH_PVT.amv_char_varray_type:=null;
4401: l_param_array AMV_SEARCH_PVT.amv_searchpar_varray_type;

Line 4399: l_amv_result_array AMV_SEARCH_PVT.amv_searchres_varray_type;

4395: l_next_row_tbl cs_kb_number_tbl_type:=cs_kb_number_tbl_type();
4396: l_total_row_tbl cs_kb_number_tbl_type:=cs_kb_number_tbl_type();
4397: l_area_array AMV_SEARCH_PVT.amv_char_varray_type:=null;
4398: l_result_array cs_kb_result_varray_type;
4399: l_amv_result_array AMV_SEARCH_PVT.amv_searchres_varray_type;
4400: l_content_array AMV_SEARCH_PVT.amv_char_varray_type:=null;
4401: l_param_array AMV_SEARCH_PVT.amv_searchpar_varray_type;
4402: l_rep cs_kb_varchar100_tbl_type ;
4403: l_imt_string varchar2(4000);

Line 4400: l_content_array AMV_SEARCH_PVT.amv_char_varray_type:=null;

4396: l_total_row_tbl cs_kb_number_tbl_type:=cs_kb_number_tbl_type();
4397: l_area_array AMV_SEARCH_PVT.amv_char_varray_type:=null;
4398: l_result_array cs_kb_result_varray_type;
4399: l_amv_result_array AMV_SEARCH_PVT.amv_searchres_varray_type;
4400: l_content_array AMV_SEARCH_PVT.amv_char_varray_type:=null;
4401: l_param_array AMV_SEARCH_PVT.amv_searchpar_varray_type;
4402: l_rep cs_kb_varchar100_tbl_type ;
4403: l_imt_string varchar2(4000);
4404: r_imt_string varchar2(4000);

Line 4401: l_param_array AMV_SEARCH_PVT.amv_searchpar_varray_type;

4397: l_area_array AMV_SEARCH_PVT.amv_char_varray_type:=null;
4398: l_result_array cs_kb_result_varray_type;
4399: l_amv_result_array AMV_SEARCH_PVT.amv_searchres_varray_type;
4400: l_content_array AMV_SEARCH_PVT.amv_char_varray_type:=null;
4401: l_param_array AMV_SEARCH_PVT.amv_searchpar_varray_type;
4402: l_rep cs_kb_varchar100_tbl_type ;
4403: l_imt_string varchar2(4000);
4404: r_imt_string varchar2(4000);
4405: l_proc_name varchar2(30):='IEM_WF_SPECIFICSEARCH';

Line 4406: --l_category_id AMV_SEARCH_PVT.amv_number_varray_type:=AMV_SEARCH_PVT.amv_number_varray_type();

4402: l_rep cs_kb_varchar100_tbl_type ;
4403: l_imt_string varchar2(4000);
4404: r_imt_string varchar2(4000);
4405: l_proc_name varchar2(30):='IEM_WF_SPECIFICSEARCH';
4406: --l_category_id AMV_SEARCH_PVT.amv_number_varray_type:=AMV_SEARCH_PVT.amv_number_varray_type();
4407: l_tag1 number;
4408: l_cnt number;
4409: l_res1 varchar2(10);
4410: l_res2 varchar2(10);

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

4447:
4448: l_rows:=10; -- Number of Document Retrieved...
4449: l_rows_req :=cs_kb_number_tbl_type(l_rows,l_rows);
4450: G_APP_ID:=520;
4451: l_area_array := AMV_SEARCH_PVT.amv_char_varray_type();
4452: l_area_array.extend;
4453: l_area_array(1) := 'ITEM';
4454: l_content_array := AMV_SEARCH_PVT.amv_char_varray_type();
4455: l_content_array.extend;

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

4450: G_APP_ID:=520;
4451: l_area_array := AMV_SEARCH_PVT.amv_char_varray_type();
4452: l_area_array.extend;
4453: l_area_array(1) := 'ITEM';
4454: l_content_array := AMV_SEARCH_PVT.amv_char_varray_type();
4455: l_content_array.extend;
4456: l_content_array(1) := 'CONTENT';
4457: l_content_array.extend;
4458: l_param_array := AMV_SEARCH_PVT.amv_searchpar_varray_type();

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

4454: l_content_array := AMV_SEARCH_PVT.amv_char_varray_type();
4455: l_content_array.extend;
4456: l_content_array(1) := 'CONTENT';
4457: l_content_array.extend;
4458: l_param_array := AMV_SEARCH_PVT.amv_searchpar_varray_type();
4459: l_rep :=cs_kb_varchar100_tbl_type() ;
4460: begin
4461: select classification_string into l_imt_string
4462: from IEM_EMAIL_CLASSIFICATIONS