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_EMAIL_PROC_PVT dependencies on IEM_RT_PREPROC_EMAILS

Line 19: l_post_rec iem_rt_preproc_emails%rowtype;

15: p_init_msg_list IN VARCHAR2 ,
16: p_commit IN VARCHAR2 ,
17: p_count IN NUMBER
18: ) IS
19: l_post_rec iem_rt_preproc_emails%rowtype;
20: l_count number:=1;
21: l_index number:=0;
22: l_class number;
23: l_ret_status varchar2(10);

Line 47: l_email_rec iem_rt_preproc_emails%ROWTYPE;

43: l_media_lc_rec JTF_IH_PUB.media_lc_rec_type;
44: l_milcs_id NUMBER;
45: l_mp_milcs_id NUMBER; -- MLCS ID for MAIL PROCESSINGS
46: l_message_id number;
47: l_email_rec iem_rt_preproc_emails%ROWTYPE;
48: x_stat varchar2(10);
49: l_status varchar2(10);
50: l_text varchar2(32767);
51: l_cust_stat varchar2(10);

Line 193: /* Get the message in FIFO order to process from iem_rt_preproc_emails */

189: LOOP
190: SAVEPOINT process_emails_pvt;
191: BEGIN
192:
193: /* Get the message in FIFO order to process from iem_rt_preproc_emails */
194:
195: IEM_EMAIL_PROC_PVT.iem_returned_msg_rec(l_post_rec);
196: IF l_post_rec.message_id is null then
197: raise NO_RECORD_TO_PROCESS ;

Line 1836: update iem_rt_preproc_emails

1832: -- Need new code to complete this .
1833: -- Create a Record for New Email Accounts in PREPROC Tables and Stop Processing for the
1834: -- Current One
1835: delete from iem_email_classifications where message_id=l_post_rec.message_id;
1836: update iem_rt_preproc_emails
1837: set email_account_id=l_redirect_id,
1838: msg_status='REDIRECT',
1839: ih_media_item_id=l_media_id
1840: where message_id=l_post_rec.message_id;

Line 2149: delete from iem_rt_preproc_emails

2145: IF l_stat<>'S' THEN
2146: l_logmessage:=l_out_text;
2147: raise ABORT_PROCESSING;
2148: END IF;
2149: delete from iem_rt_preproc_emails
2150: where message_id=l_post_rec.message_id;
2151: -- Calling the specific search at the End
2152: if g_statement_log then
2153: l_logmessage:='Calling Specific Search API ' ;

Line 2247: update iem_rt_preproc_emails

2243: iem_logger(l_Error_Message);
2244: end if;
2245: ROLLBACK TO process_emails_pvt;
2246: -- Timestamp the message to sent it to back of queue
2247: update iem_rt_preproc_emails
2248: set creation_date=sysdate
2249: where message_id=l_post_rec.message_id;
2250: commit;
2251: ELSE

Line 2290: update iem_rt_preproc_emails

2286: iem_logger(l_Error_Message);
2287: end if;
2288: ROLLBACK TO process_emails_pvt;
2289: -- Timestamp the message to sent it to back of queue
2290: update iem_rt_preproc_emails
2291: set creation_date=sysdate
2292: where message_id=l_post_rec.message_id;
2293: commit;
2294: ELSE

Line 2295: delete from iem_rt_preproc_emails where message_id=l_post_rec.message_id;

2291: set creation_date=sysdate
2292: where message_id=l_post_rec.message_id;
2293: commit;
2294: ELSE
2295: delete from iem_rt_preproc_emails where message_id=l_post_rec.message_id;
2296: commit;
2297: END IF;
2298: END IF;
2299: WHEN STOP_PROCESSING THEN

Line 2300: delete from iem_rt_preproc_emails

2296: commit;
2297: END IF;
2298: END IF;
2299: WHEN STOP_PROCESSING THEN
2300: delete from iem_rt_preproc_emails
2301: where message_id=l_post_rec.message_id;
2302: -- Check for autoack Flag if set then send autoack.
2303: IF l_autoack_flag='Y' then
2304: if g_statement_log then

Line 2376: update iem_rt_preproc_emails

2372: iem_logger(l_Error_Message);
2373: end if;
2374: ROLLBACK TO process_emails_pvt;
2375: -- Timestamp the message to sent it to back of queue
2376: update iem_rt_preproc_emails
2377: set creation_date=sysdate
2378: where message_id=l_post_rec.message_id;
2379: commit;
2380:

Line 2387: update iem_rt_preproc_emails

2383: l_logmessage := 'Unable To insert Record in Post MDT '||sqlerrm;
2384: iem_logger(l_logmessage);
2385: end if;
2386: ROLLBACK TO process_emails_pvt;
2387: update iem_rt_preproc_emails
2388: set creation_date=sysdate
2389: where message_id=l_post_rec.message_id;
2390: commit;
2391: WHEN NO_RECORD_TO_PROCESS THEN

Line 2402: update iem_rt_preproc_emails

2398: l_logmessage:='Oracle Error Encountered in Processing'||sqlerrm;
2399: iem_logger(l_logmessage);
2400: end if;
2401: ROLLBACK TO process_emails_pvt;
2402: update iem_rt_preproc_emails
2403: set creation_date=sysdate
2404: where message_id=l_post_rec.message_id;
2405: commit;
2406: null;

Line 2456: Procedure iem_returned_msg_rec(x_msg_rec out nocopy iem_rt_preproc_emails%ROWTYPE) is

2452: end if;
2453: end if;
2454: end iem_logger;
2455:
2456: Procedure iem_returned_msg_rec(x_msg_rec out nocopy iem_rt_preproc_emails%ROWTYPE) is
2457: e_nowait EXCEPTION;
2458: PRAGMA EXCEPTION_INIT(e_nowait, -54);
2459: l_post_rec iem_rt_preproc_emails%rowtype;
2460: l_folder_name varchar2(20):='/Inbox';

Line 2459: l_post_rec iem_rt_preproc_emails%rowtype;

2455:
2456: Procedure iem_returned_msg_rec(x_msg_rec out nocopy iem_rt_preproc_emails%ROWTYPE) is
2457: e_nowait EXCEPTION;
2458: PRAGMA EXCEPTION_INIT(e_nowait, -54);
2459: l_post_rec iem_rt_preproc_emails%rowtype;
2460: l_folder_name varchar2(20):='/Inbox';
2461: l_uid number;
2462: l_status varchar2(10);
2463: l_out_text varchar2(1000);

Line 2466: from iem_rt_preproc_emails

2462: l_status varchar2(10);
2463: l_out_text varchar2(1000);
2464: BEGIN
2465: for x in ( select message_id
2466: from iem_rt_preproc_emails
2467: order by priority,creation_date)
2468: LOOP
2469: BEGIN
2470: select * into x_msg_rec from iem_rt_preproc_emails

Line 2470: select * into x_msg_rec from iem_rt_preproc_emails

2466: from iem_rt_preproc_emails
2467: order by priority,creation_date)
2468: LOOP
2469: BEGIN
2470: select * into x_msg_rec from iem_rt_preproc_emails
2471: where message_id=x.message_id FOR UPDATE NOWAIT;
2472: exit;
2473: EXCEPTION when e_nowait then
2474: null;

Line 2758: p_email_rec in iem_rt_preproc_emails%rowtype,

2754: END;
2755:
2756: PROCEDURE IEM_SRSTATUS_UPDATE(p_sr_id in number,
2757: p_status_id in number,
2758: p_email_rec in iem_rt_preproc_emails%rowtype,
2759: x_status out NOCOPY varchar2,
2760: x_out_text out NOCOPY varchar2) IS
2761:
2762: l_service_request_rec CS_ServiceRequest_PUB.service_request_rec_type;

Line 3131: p_email_rec in iem_rt_preproc_emails%rowtype,

3127: PROCEDURE IEM_WRAPUP(p_interaction_id in number,
3128: p_media_id in number,
3129: p_milcs_id in number,
3130: p_action in varchar2,
3131: p_email_rec in iem_rt_preproc_emails%rowtype,
3132: p_action_id in number,
3133: x_out_text out NOCOPY varchar2,
3134: x_status out NOCOPY varchar2) IS
3135:

Line 3238: p_post_rec in iem_rt_preproc_emails%rowtype,

3234: end IEM_WRAPUP;
3235:
3236: PROCEDURE IEM_AUTOREPLY(p_interaction_id in number,
3237: p_media_id in number,
3238: p_post_rec in iem_rt_preproc_emails%rowtype,
3239: p_doc_tbl in email_doc_tbl,
3240: p_subject in varchar2,
3241: P_TAG_KEY_VALUE_TBL in IEM_OUTBOX_PROC_PUB.keyVals_tbl_type,
3242: P_CUSTOMER_ID in number,