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_SEARCHMESSAGE_PVT dependencies on IEM_ARCH_MSGDTLS

Line 38: l_message_id iem_arch_msgdtls.message_id%type;

34: Type get_data is REF CURSOR;-- RETURN acq_email_info_tbl;
35: email_cur get_data;
36: l_temp_tbl message_rec_tbl;
37: l_counter number:=1;
38: l_message_id iem_arch_msgdtls.message_id%type;
39: l_ih_media_item_id iem_arch_msgdtls.ih_media_item_id%type;
40: l_from_str iem_arch_msgdtls.from_str%type;
41: l_from_str1 iem_arch_msgdtls.from_str%type;
42: l_to_str iem_arch_msgdtls.to_str%type;

Line 39: l_ih_media_item_id iem_arch_msgdtls.ih_media_item_id%type;

35: email_cur get_data;
36: l_temp_tbl message_rec_tbl;
37: l_counter number:=1;
38: l_message_id iem_arch_msgdtls.message_id%type;
39: l_ih_media_item_id iem_arch_msgdtls.ih_media_item_id%type;
40: l_from_str iem_arch_msgdtls.from_str%type;
41: l_from_str1 iem_arch_msgdtls.from_str%type;
42: l_to_str iem_arch_msgdtls.to_str%type;
43: l_to_str1 iem_arch_msgdtls.to_str%type;

Line 40: l_from_str iem_arch_msgdtls.from_str%type;

36: l_temp_tbl message_rec_tbl;
37: l_counter number:=1;
38: l_message_id iem_arch_msgdtls.message_id%type;
39: l_ih_media_item_id iem_arch_msgdtls.ih_media_item_id%type;
40: l_from_str iem_arch_msgdtls.from_str%type;
41: l_from_str1 iem_arch_msgdtls.from_str%type;
42: l_to_str iem_arch_msgdtls.to_str%type;
43: l_to_str1 iem_arch_msgdtls.to_str%type;
44: l_subject iem_arch_msgdtls.subject%type;

Line 41: l_from_str1 iem_arch_msgdtls.from_str%type;

37: l_counter number:=1;
38: l_message_id iem_arch_msgdtls.message_id%type;
39: l_ih_media_item_id iem_arch_msgdtls.ih_media_item_id%type;
40: l_from_str iem_arch_msgdtls.from_str%type;
41: l_from_str1 iem_arch_msgdtls.from_str%type;
42: l_to_str iem_arch_msgdtls.to_str%type;
43: l_to_str1 iem_arch_msgdtls.to_str%type;
44: l_subject iem_arch_msgdtls.subject%type;
45: l_subject1 iem_arch_msgdtls.subject%type;

Line 42: l_to_str iem_arch_msgdtls.to_str%type;

38: l_message_id iem_arch_msgdtls.message_id%type;
39: l_ih_media_item_id iem_arch_msgdtls.ih_media_item_id%type;
40: l_from_str iem_arch_msgdtls.from_str%type;
41: l_from_str1 iem_arch_msgdtls.from_str%type;
42: l_to_str iem_arch_msgdtls.to_str%type;
43: l_to_str1 iem_arch_msgdtls.to_str%type;
44: l_subject iem_arch_msgdtls.subject%type;
45: l_subject1 iem_arch_msgdtls.subject%type;
46: l_sent_date iem_arch_msgdtls.sent_date%type;

Line 43: l_to_str1 iem_arch_msgdtls.to_str%type;

39: l_ih_media_item_id iem_arch_msgdtls.ih_media_item_id%type;
40: l_from_str iem_arch_msgdtls.from_str%type;
41: l_from_str1 iem_arch_msgdtls.from_str%type;
42: l_to_str iem_arch_msgdtls.to_str%type;
43: l_to_str1 iem_arch_msgdtls.to_str%type;
44: l_subject iem_arch_msgdtls.subject%type;
45: l_subject1 iem_arch_msgdtls.subject%type;
46: l_sent_date iem_arch_msgdtls.sent_date%type;
47: l_Str1 varchar2(500);

Line 44: l_subject iem_arch_msgdtls.subject%type;

40: l_from_str iem_arch_msgdtls.from_str%type;
41: l_from_str1 iem_arch_msgdtls.from_str%type;
42: l_to_str iem_arch_msgdtls.to_str%type;
43: l_to_str1 iem_arch_msgdtls.to_str%type;
44: l_subject iem_arch_msgdtls.subject%type;
45: l_subject1 iem_arch_msgdtls.subject%type;
46: l_sent_date iem_arch_msgdtls.sent_date%type;
47: l_Str1 varchar2(500);
48: BEGIN

Line 45: l_subject1 iem_arch_msgdtls.subject%type;

41: l_from_str1 iem_arch_msgdtls.from_str%type;
42: l_to_str iem_arch_msgdtls.to_str%type;
43: l_to_str1 iem_arch_msgdtls.to_str%type;
44: l_subject iem_arch_msgdtls.subject%type;
45: l_subject1 iem_arch_msgdtls.subject%type;
46: l_sent_date iem_arch_msgdtls.sent_date%type;
47: l_Str1 varchar2(500);
48: BEGIN
49: -- Standard call to check for call compatibility.

Line 46: l_sent_date iem_arch_msgdtls.sent_date%type;

42: l_to_str iem_arch_msgdtls.to_str%type;
43: l_to_str1 iem_arch_msgdtls.to_str%type;
44: l_subject iem_arch_msgdtls.subject%type;
45: l_subject1 iem_arch_msgdtls.subject%type;
46: l_sent_date iem_arch_msgdtls.sent_date%type;
47: l_Str1 varchar2(500);
48: BEGIN
49: -- Standard call to check for call compatibility.
50: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

Line 61: l_str1:=' from iem_arch_msgdtls where email_account_id=:id and mailproc_status=:q_status';

57: SAVEPOINT select_mail_count_pvt;
58: IF p_email_queue <> 'I' THEN -- Search non draft message
59:
60: l_str:='select message_id,ih_media_item_id,from_str,to_str,subject, to_char(to_date(substr(sent_Date,1,20),''DD-MON-YYYY HH24:MI:SS'',''NLS_DATE_LANGUAGE=ENGLISH''),''MM/DD/RRRR HH24:MI:SS'')';
61: l_str1:=' from iem_arch_msgdtls where email_account_id=:id and mailproc_status=:q_status';
62: l_str:=l_str||l_str1;
63:
64: If p_sent_date_from is not null then
65: l_str:=l_str||' AND to_date(substr(sent_Date,1,20),''DD-MON-YYYY HH24:MI:SS'',''NLS_DATE_LANGUAGE=ENGLISH'') >= to_date(:f_dt,''mm-dd-rrrr hh24:mi:ss'',''NLS_DATE_LANGUAGE=ENGLISH'')';