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_TEXT_PVT dependencies on CS_KB_NUMBER_TBL_TYPE

Line 412: l_rows_returned cs_kb_number_tbl_type :=cs_kb_number_tbl_type();

408: l_imt_string varchar2(32767):=' ';
409: l_return_status VARCHAR2(20);
410: l_msg_count NUMBER;
411: l_msg_data VARCHAR2(400);
412: l_rows_returned cs_kb_number_tbl_type :=cs_kb_number_tbl_type();
413: l_next_row_pos cs_kb_number_tbl_type :=cs_kb_number_tbl_type();
414: l_total_row_cnt cs_kb_number_tbl_type :=cs_kb_number_tbl_type();
415: l_logmessage varchar2(500);
416: l_level varchar2(20):='STATEMENT';

Line 413: l_next_row_pos cs_kb_number_tbl_type :=cs_kb_number_tbl_type();

409: l_return_status VARCHAR2(20);
410: l_msg_count NUMBER;
411: l_msg_data VARCHAR2(400);
412: l_rows_returned cs_kb_number_tbl_type :=cs_kb_number_tbl_type();
413: l_next_row_pos cs_kb_number_tbl_type :=cs_kb_number_tbl_type();
414: l_total_row_cnt cs_kb_number_tbl_type :=cs_kb_number_tbl_type();
415: l_logmessage varchar2(500);
416: l_level varchar2(20):='STATEMENT';
417: l_app_id number;

Line 414: l_total_row_cnt cs_kb_number_tbl_type :=cs_kb_number_tbl_type();

410: l_msg_count NUMBER;
411: l_msg_data VARCHAR2(400);
412: l_rows_returned cs_kb_number_tbl_type :=cs_kb_number_tbl_type();
413: l_next_row_pos cs_kb_number_tbl_type :=cs_kb_number_tbl_type();
414: l_total_row_cnt cs_kb_number_tbl_type :=cs_kb_number_tbl_type();
415: l_logmessage varchar2(500);
416: l_level varchar2(20):='STATEMENT';
417: l_app_id number;
418: l_part number;

Line 428: l_next_row_tbl cs_kb_number_tbl_type:=cs_kb_number_tbl_type();

424: l_errtext varchar2(200);
425: l_score number;
426: l_class NUMBER;
427: l_count NUMBER;
428: l_next_row_tbl cs_kb_number_tbl_type:=cs_kb_number_tbl_type();
429: l_total_row_tbl cs_kb_number_tbl_type:=cs_kb_number_tbl_type();
430: l_area_array AMV_SEARCH_PVT.amv_char_varray_type:=null;
431: l_result_array cs_kb_result_varray_type;
432: l_amv_result_array AMV_SEARCH_PVT.amv_searchres_varray_type;

Line 429: l_total_row_tbl cs_kb_number_tbl_type:=cs_kb_number_tbl_type();

425: l_score number;
426: l_class NUMBER;
427: l_count NUMBER;
428: l_next_row_tbl cs_kb_number_tbl_type:=cs_kb_number_tbl_type();
429: l_total_row_tbl cs_kb_number_tbl_type:=cs_kb_number_tbl_type();
430: l_area_array AMV_SEARCH_PVT.amv_char_varray_type:=null;
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;

Line 444: l_rows_req cs_kb_number_tbl_type ;

440: l_res2 varchar2(10);
441: l_search_repos varchar2(10);
442: l_days number ;
443: l_user_id number ;
444: l_rows_req cs_kb_number_tbl_type ;
445: l_rows number;
446: l_start_row cs_kb_number_tbl_type:=cs_kb_number_tbl_type(1,1);
447: l_sms_string varchar2(255);
448: l_sms_count number;

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

442: l_days number ;
443: l_user_id number ;
444: l_rows_req cs_kb_number_tbl_type ;
445: l_rows number;
446: l_start_row cs_kb_number_tbl_type:=cs_kb_number_tbl_type(1,1);
447: l_sms_string varchar2(255);
448: l_sms_count number;
449: l_counter number:=1;
450: l_cat_map_id number;

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

461:
462: l_imt_string:=substr(l_imt_string,1,length(l_imt_string)-1);
463: l_search_repos:='ALL';
464: l_rows:=10; -- Number of Document Retrieved...
465: l_rows_req :=cs_kb_number_tbl_type(l_rows,l_rows);
466: G_APP_ID:=520;
467: l_area_array := AMV_SEARCH_PVT.amv_char_varray_type();
468: l_area_array.extend;
469: l_area_array(1) := 'ITEM';