APPS.IEM_TEXT_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 14

 cursor c_weight is select keyword,weight from iem_imt_keywords
 where message_id=p_message_id and message_type=1 and message_part=l_part_id and message_format=1 ;

Line: 16

cursor c1 is select rowid from iem_imt_texts
 where message_id=p_message_id and message_type=1 and message_part=l_part_id and message_format=1 ;

Line: 41

		-- Insert Into iem_imt_keywords Table for Future Use
		IF l_theme_buf.count>0 THEN
		for i in l_theme_buf.first..l_theme_buf.last LOOP
			xbuf(i).theme:=l_theme_buf(i).theme;

Line: 52

	insert into iem_imt_keywords(message_id,message_type,message_part,message_format,keyword,weight)
	values(p_message_id,1,l_part_id,1,theme_tbl(j),score_tbl(j));

Line: 66

 cursor c_weight is select keyword  from iem_imt_keywords
 where message_id=p_message_id and message_type=1 and message_part=l_part_id and message_format=2
 order by 1;

Line: 69

cursor c1 is select rowid from iem_imt_texts where
	message_id=p_message_id and message_type=1 and message_part=l_part_id and message_format=2;

Line: 98

		-- Insert Into iem_imt_keywords Table for Future Use
		IF l_token_buf.count>0 THEN
			for i in l_token_buf.first..l_token_buf.last LOOP
			theme_tbl.extend;

Line: 107

	insert into iem_imt_keywords(message_id,message_type,message_part,message_format,keyword,weight)
	values(p_message_id,1,l_part_id,2,theme_tbl(j),null);

Line: 116

		theme_tbl.delete;

Line: 133

PROCEDURE IEM_INSERT_TEXTS(p_clob in clob,
					  p_lang  in varchar2,
					  x_id	OUT NOCOPY NUMBER,
					  x_status out nocopy varchar2) IS
l_seq		number;

Line: 147

	select  nvl(max(message_id),0)+1 into l_Seq
	from iem_imt_texts where message_type=2;

Line: 149

		insert into iem_imt_texts
		(
		message_ID,
 		message_TYPE,
 		message_PART,
		message_format,
 		IMT_FORMAT,
 		IMT_CHARSET,
 		IMT_LANG,
		message_text)
 VALUES
		(l_seq
		,2
		,9999
		,l_msgformat
		,l_imt_format
		,null		-- May be defaulted to database char set.
		,p_lang
		,p_clob);

Line: 188

	cursor c_query is select keyword,weight from iem_intent_dtls
	where intent_id=p_intent_id
	and query_Response='Q';

Line: 191

	cursor c_resp is select keyword,weight from iem_intent_dtls
	where intent_id=p_intent_id
	and query_Response='R';

Line: 196

		select decode(p_type,1,'Y','N') into l_theme_enabled from dual;

Line: 197

			l_kw_tbl.delete;

Line: 219

			l_kw_tbl.delete;

Line: 264

cursor c1 is select rowid from iem_imt_texts
 where message_id=l_seq  and message_type=2 ;

Line: 266

 cursor c_Weight is select keyword from iem_imt_keywords where message_id=l_message_id;

Line: 269

	iem_insert_texts(p_text,p_lang,l_seq,l_status);

Line: 288

	select nvl(max(message_id),0)+1 into l_message_id from iem_imt_keywords;

Line: 296

	insert into iem_imt_keywords(message_id,message_type,message_part,message_format,keyword,weight)
	values(l_message_id,1,0,2,theme_tbl(j),null);

Line: 305

		theme_tbl.delete;

Line: 317

	delete from iem_imt_keywords where message_id=l_message_id;

Line: 338

 cursor c1 is select mime_msg from iem_ms_mimemsgs where
 message_id=p_message_id;

Line: 340

cursor c2 is select part_type,part_id,part_charset,part_data from iem_ms_msgparts
where message_id=p_message_id
and part_id=p_part_id;

Line: 358

		insert into iem_imt_texts
		(
		message_ID,
 		message_TYPE,
 		message_PART,
		message_format,
 		IMT_FORMAT,
 		IMT_LANG,
		message_text)
 VALUES
		(p_message_id
		,p_message_type
		,9999
		,l_msgformat
		,'TEXT'
		,p_lang
		,l_text
		);

Line: 380

		insert into iem_imt_texts
		(
		message_ID,
 		message_TYPE,
 		message_PART,
		message_format,
 		IMT_FORMAT,
 		IMT_LANG,
		message_text)
 VALUES
		(p_message_id
		,p_message_type
		,v2.part_id
		,l_msgformat
		,l_imt_format
		,p_lang
		,l_text);

Line: 406

 select keyword,weight from iem_intent_dtls where intent_id=p_intent_id
 and query_response='R';

Line: 486

      p_updated_in_days => l_days,
      p_check_login_user => FND_API.G_FALSE,
      p_application_id => G_APP_ID,
        p_area_array => l_area_array,
        p_content_array => l_content_array,
        p_param_array => l_param_array,
        p_user_id => l_user_id,
        p_category_id => l_category_id,
        p_include_subcats   => FND_API.G_FALSE,
        p_external_contents => FND_API.G_TRUE,
      p_rows_requested_tbl => l_rows_req,
      p_start_row_pos_tbl  => l_start_row,
      p_get_total_cnt_flag => 'T',
      x_rows_returned_tbl => l_rows_returned,
      x_next_row_pos_tbl => l_next_row_pos,
      x_total_row_cnt_tbl => l_total_row_cnt,
      x_result_array  => l_result_array);

Line: 505

	delete from iem_intent_documents where intent_id=l_intent_id;

Line: 508

	insert into iem_intent_documents
	(intent_id,
	docname,
	repos_id,
	doc_id,
	url_string,
	score)
	values
	(l_intent_id,
	l_result_array(l_count).title,
	1,							-- 1 for MES and 2 for SMS
	l_result_array(l_count).id,
	l_result_array(l_count).url_string,
	l_result_array(l_count).score);

Line: 540

      p_updated_in_days => l_days,
      p_check_login_user => FND_API.G_FALSE,
      p_application_id => G_APP_ID,
        p_area_array => l_area_array,
        p_content_array => l_content_array,
        p_param_array => l_param_array,
        p_user_id => l_user_id,
        p_category_id => l_category_id,
        p_include_subcats   => FND_API.G_TRUE,
        p_external_contents => FND_API.G_TRUE,
      p_rows_requested_tbl => l_rows_req,
      p_start_row_pos_tbl  => l_start_row,
      p_get_total_cnt_flag => 'T',
      x_rows_returned_tbl => l_rows_returned,
      x_next_row_pos_tbl => l_next_row_pos,
      x_total_row_cnt_tbl => l_total_row_cnt,
      x_result_array  => l_result_array);

Line: 561

	insert into iem_intent_documents
	(intent_id,
	docname,
	repos_id,
	doc_id,
	url_string,
	score)
	values
	(l_intent_id,
	l_result_array(l_count).title,
	2,							-- 1 for MES and 2 for SMS
	l_result_array(l_count).document_number,
--	l_number,
	l_result_array(l_count).url_string,
	l_result_array(l_count).score);

Line: 586

cursor c1 is select value,type from iem_ms_msgbodys
where message_id=p_message_id
order by order_id;