APPS.IEM_TEXT_PVT dependencies on IEM_IMT_TEXTS

Line 16: cursor c1 is select rowid from iem_imt_texts

12: score_tbl score_type:=score_type();
13: -- Below cursor will check for existing data for the message
14: cursor c_weight is select keyword,weight from iem_imt_keywords
15: where message_id=p_message_id and message_type=1 and message_part=l_part_id and message_format=1 ;
16: cursor c1 is select rowid from iem_imt_texts
17: where message_id=p_message_id and message_type=1 and message_part=l_part_id and message_format=1 ;
18: l_theme_buf THEME_TABLE;
19: l_count number:=0;
20: l_status varchar2(10);

Line 69: cursor c1 is select rowid from iem_imt_texts where

65: theme_tbl theme_type:=theme_type();
66: cursor c_weight is select keyword from iem_imt_keywords
67: where message_id=p_message_id and message_type=1 and message_part=l_part_id and message_format=2
68: order by 1;
69: cursor c1 is select rowid from iem_imt_texts where
70: message_id=p_message_id and message_type=1 and message_part=l_part_id and message_format=2;
71: l_token_buf TOKEN_TABLE;
72: l_count number:=0;
73: l_status varchar2(10);

Line 148: from iem_imt_texts where message_type=2;

144: ELSE
145: l_msgformat:=2;
146: END IF;
147: select nvl(max(message_id),0)+1 into l_Seq
148: from iem_imt_texts where message_type=2;
149: insert into iem_imt_texts
150: (
151: message_ID,
152: message_TYPE,

Line 149: insert into iem_imt_texts

145: l_msgformat:=2;
146: END IF;
147: select nvl(max(message_id),0)+1 into l_Seq
148: from iem_imt_texts where message_type=2;
149: insert into iem_imt_texts
150: (
151: message_ID,
152: message_TYPE,
153: message_PART,

Line 264: cursor c1 is select rowid from iem_imt_texts

260: l_counter number;
261: TYPE theme_type is TABLE OF iem_imt_keywords.keyword%type;
262: theme_tbl theme_type:=theme_type();
263: l_start number:=1;
264: cursor c1 is select rowid from iem_imt_texts
265: where message_id=l_seq and message_type=2 ;
266: cursor c_Weight is select keyword from iem_imt_keywords where message_id=l_message_id;
267: begin
268: -- Insert the content into IEM_IMT_TEXTS

Line 268: -- Insert the content into IEM_IMT_TEXTS

264: cursor c1 is select rowid from iem_imt_texts
265: where message_id=l_seq and message_type=2 ;
266: cursor c_Weight is select keyword from iem_imt_keywords where message_id=l_message_id;
267: begin
268: -- Insert the content into IEM_IMT_TEXTS
269: iem_insert_texts(p_text,p_lang,l_seq,l_status);
270: l_schema:='IEM';
271: if p_type=1 then
272: for v1 in c1 LOOP

Line 358: insert into iem_imt_texts

354: IF p_part_id is null then -- For all parts
355: -- Create an entry for all parts
356: for v1 in c1 Loop
357: ctx_doc.policy_filter( 'IEM_MAIL_FILTER_POLICY', v1.mime_msg, l_text, false );
358: insert into iem_imt_texts
359: (
360: message_ID,
361: message_TYPE,
362: message_PART,

Line 380: insert into iem_imt_texts

376: end loop;
377: ELSE
378: for v2 in c2 Loop
379: ctx_doc.policy_filter( 'my_policy', v2.part_data, l_text, false );
380: insert into iem_imt_texts
381: (
382: message_ID,
383: message_TYPE,
384: message_PART,