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 CS_KB_NUMBER_TBL_TYPE

Line 4379: l_rows_returned cs_kb_number_tbl_type :=cs_kb_number_tbl_type();

4375: l_msg_count NUMBER;
4376: l_msg_data VARCHAR2(400);
4377: l_doc_id number;
4378: l_kb_repos iem_kb_results.kb_repository_name%type;
4379: l_rows_returned cs_kb_number_tbl_type :=cs_kb_number_tbl_type();
4380: l_next_row_pos cs_kb_number_tbl_type :=cs_kb_number_tbl_type();
4381: l_total_row_cnt cs_kb_number_tbl_type :=cs_kb_number_tbl_type();
4382: l_logmessage varchar2(500);
4383: l_level varchar2(20):='STATEMENT';

Line 4380: l_next_row_pos cs_kb_number_tbl_type :=cs_kb_number_tbl_type();

4376: l_msg_data VARCHAR2(400);
4377: l_doc_id number;
4378: l_kb_repos iem_kb_results.kb_repository_name%type;
4379: l_rows_returned cs_kb_number_tbl_type :=cs_kb_number_tbl_type();
4380: l_next_row_pos cs_kb_number_tbl_type :=cs_kb_number_tbl_type();
4381: l_total_row_cnt cs_kb_number_tbl_type :=cs_kb_number_tbl_type();
4382: l_logmessage varchar2(500);
4383: l_level varchar2(20):='STATEMENT';
4384: l_app_id number;

Line 4381: l_total_row_cnt cs_kb_number_tbl_type :=cs_kb_number_tbl_type();

4377: l_doc_id number;
4378: l_kb_repos iem_kb_results.kb_repository_name%type;
4379: l_rows_returned cs_kb_number_tbl_type :=cs_kb_number_tbl_type();
4380: l_next_row_pos cs_kb_number_tbl_type :=cs_kb_number_tbl_type();
4381: l_total_row_cnt cs_kb_number_tbl_type :=cs_kb_number_tbl_type();
4382: l_logmessage varchar2(500);
4383: l_level varchar2(20):='STATEMENT';
4384: l_app_id number;
4385: l_part number;

Line 4395: l_next_row_tbl cs_kb_number_tbl_type:=cs_kb_number_tbl_type();

4391: l_errtext varchar2(200);
4392: l_score number;
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;

Line 4396: l_total_row_tbl cs_kb_number_tbl_type:=cs_kb_number_tbl_type();

4392: l_score number;
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;

Line 4414: l_rows_req cs_kb_number_tbl_type ;

4410: l_res2 varchar2(10);
4411: l_search_repos varchar2(10);
4412: l_days number ;
4413: l_user_id number ;
4414: l_rows_req cs_kb_number_tbl_type ;
4415: l_rows number;
4416: l_start_row cs_kb_number_tbl_type:=cs_kb_number_tbl_type(1,1);
4417: l_sms_string varchar2(255);
4418: l_sms_count number;

Line 4416: l_start_row cs_kb_number_tbl_type:=cs_kb_number_tbl_type(1,1);

4412: l_days number ;
4413: l_user_id number ;
4414: l_rows_req cs_kb_number_tbl_type ;
4415: l_rows number;
4416: l_start_row cs_kb_number_tbl_type:=cs_kb_number_tbl_type(1,1);
4417: l_sms_string varchar2(255);
4418: l_sms_count number;
4419: l_counter number:=1;
4420: g_app_id number;

Line 4449: l_rows_req :=cs_kb_number_tbl_type(l_rows,l_rows);

4445: r_imt_string:=substr(r_imt_string,1,length(r_imt_string)-1);
4446: end if;
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';