DBA Data[Home] [Help]

APPS.IEM_EMAIL_PROC_PVT dependencies on IEM_TEXT_PVT

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

1200:
1201: end if;
1202: IF l_party_id is not null then -- Go ahead with creating service request
1203: -- Retrieve the note for the email
1204: iem_text_pvt.RETRIEVE_TEXT(p_message_id=>l_message_id,
1205: x_text=>l_text,
1206: x_status=>l_status);
1207: if l_status<>'S' then
1208: l_logmessage:='Error Encountered while Retrieving Notes';

Line 3614: l_theme_buf IEM_TEXT_PVT.theme_tAble;

3610: l_level varchar2(20):='STATEMENT';
3611: l_tweight number:=0;
3612: l_rms number;
3613: l_class_count number;
3614: l_theme_buf IEM_TEXT_PVT.theme_tAble;
3615: l_token_buf IEM_TEXT_PVT.token_table;
3616: cursor c1 is
3617: SELECT a.intent_id, a.keyword,a.weight
3618: from iem_intent_dtls a,iem_account_intents b

Line 3615: l_token_buf IEM_TEXT_PVT.token_table;

3611: l_tweight number:=0;
3612: l_rms number;
3613: l_class_count number;
3614: l_theme_buf IEM_TEXT_PVT.theme_tAble;
3615: l_token_buf IEM_TEXT_PVT.token_table;
3616: cursor c1 is
3617: SELECT a.intent_id, a.keyword,a.weight
3618: from iem_intent_dtls a,iem_account_intents b
3619: WHERE b.email_account_id=l_email_account_id

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

3635: WHERE EMAIL_ACCOUNT_ID=l_email_account_id;
3636: l_theme_buf.delete;
3637: l_token_buf.delete;
3638: IF l_theme_code=1 then -- Theme processing
3639: iem_text_pvt.getthemes(l_msg_id,null,l_theme_buf,l_errmsg);
3640: ELSIF l_theme_code=2 then -- Token Processing
3641: iem_text_pvt.gettokens(l_msg_id,null,l_lang,l_token_buf,l_errmsg);
3642: IF l_token_buf.count>0 THEN
3643: l_counter:=1;

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

3637: l_token_buf.delete;
3638: IF l_theme_code=1 then -- Theme processing
3639: iem_text_pvt.getthemes(l_msg_id,null,l_theme_buf,l_errmsg);
3640: ELSIF l_theme_code=2 then -- Token Processing
3641: iem_text_pvt.gettokens(l_msg_id,null,l_lang,l_token_buf,l_errmsg);
3642: IF l_token_buf.count>0 THEN
3643: l_counter:=1;
3644: FOR i in l_token_buf.FIRST..l_token_buf.LAST LOOP
3645: l_theme_buf(l_counter).theme:=l_token_buf(i).token;