APPS.IEM_EMAIL_PROC_PVT dependencies on IEM_TEXT_PVT

Line 1823: iem_text_pvt.RETRIEVE_TEXT(p_message_id=>l_message_id,

1819: --but there is a parser_id there is a possibility that the user trying to create an SR via advanced email SR.
1820:
1821: IF ((l_party_id is not null) OR (l_parser_id IS NOT NULL)) then -- Go ahead with creating service request
1822: -- Retrieve the note for the email
1823: iem_text_pvt.RETRIEVE_TEXT(p_message_id=>l_message_id,
1824: x_text=>l_text,
1825: x_status=>l_status);
1826:
1827: if g_statement_log then

Line 1828: l_logmessage:='after call to iem_text_pvt.RETRIEVE_TEXT l_status : '||l_status;

1824: x_text=>l_text,
1825: x_status=>l_status);
1826:
1827: if g_statement_log then
1828: l_logmessage:='after call to iem_text_pvt.RETRIEVE_TEXT l_status : '||l_status;
1829: iem_logger(l_logmessage);
1830: END if;
1831:
1832: if l_status<>'S' then

Line 4709: l_theme_buf IEM_TEXT_PVT.theme_tAble;

4705: l_level varchar2(20):='STATEMENT';
4706: l_tweight number:=0;
4707: l_rms number;
4708: l_class_count number;
4709: l_theme_buf IEM_TEXT_PVT.theme_tAble;
4710: l_token_buf IEM_TEXT_PVT.token_table;
4711: cursor c1 is
4712: SELECT a.intent_id, a.keyword,a.weight
4713: from iem_intent_dtls a,iem_account_intents b

Line 4710: l_token_buf IEM_TEXT_PVT.token_table;

4706: l_tweight number:=0;
4707: l_rms number;
4708: l_class_count number;
4709: l_theme_buf IEM_TEXT_PVT.theme_tAble;
4710: l_token_buf IEM_TEXT_PVT.token_table;
4711: cursor c1 is
4712: SELECT a.intent_id, a.keyword,a.weight
4713: from iem_intent_dtls a,iem_account_intents b
4714: WHERE b.email_account_id=l_email_account_id

Line 4734: iem_text_pvt.getthemes(l_msg_id,null,l_theme_buf,l_errmsg);

4730: WHERE EMAIL_ACCOUNT_ID=l_email_account_id;
4731: l_theme_buf.delete;
4732: l_token_buf.delete;
4733: IF l_theme_code=1 then -- Theme processing
4734: iem_text_pvt.getthemes(l_msg_id,null,l_theme_buf,l_errmsg);
4735: ELSIF l_theme_code=2 then -- Token Processing
4736: iem_text_pvt.gettokens(l_msg_id,null,l_lang,l_token_buf,l_errmsg);
4737: IF l_token_buf.count>0 THEN
4738: l_counter:=1;

Line 4736: iem_text_pvt.gettokens(l_msg_id,null,l_lang,l_token_buf,l_errmsg);

4732: l_token_buf.delete;
4733: IF l_theme_code=1 then -- Theme processing
4734: iem_text_pvt.getthemes(l_msg_id,null,l_theme_buf,l_errmsg);
4735: ELSIF l_theme_code=2 then -- Token Processing
4736: iem_text_pvt.gettokens(l_msg_id,null,l_lang,l_token_buf,l_errmsg);
4737: IF l_token_buf.count>0 THEN
4738: l_counter:=1;
4739: FOR i in l_token_buf.FIRST..l_token_buf.LAST LOOP
4740: l_theme_buf(l_counter).theme:=l_token_buf(i).token;