DBA Data[Home] [Help]

APPS.IEM_AGENT_INBOX_MGMT_PVT dependencies on IEM_RT_PROC_EMAILS

Line 4: message_id iem_rt_proc_emails.message_id%type,

1: package IEM_AGENT_INBOX_MGMT_PVT as
2: /* $Header: iemvaims.pls 120.1 2006/02/14 15:16:44 chtang noship $*/
3: TYPE message_type IS RECORD (
4: message_id iem_rt_proc_emails.message_id%type,
5: email_account_id iem_rt_proc_emails.email_account_id%type,
6: sender_name iem_rt_proc_emails.from_address%type,
7: subject iem_rt_proc_emails.subject%type,
8: classification_name iem_route_classifications.name%type,

Line 5: email_account_id iem_rt_proc_emails.email_account_id%type,

1: package IEM_AGENT_INBOX_MGMT_PVT as
2: /* $Header: iemvaims.pls 120.1 2006/02/14 15:16:44 chtang noship $*/
3: TYPE message_type IS RECORD (
4: message_id iem_rt_proc_emails.message_id%type,
5: email_account_id iem_rt_proc_emails.email_account_id%type,
6: sender_name iem_rt_proc_emails.from_address%type,
7: subject iem_rt_proc_emails.subject%type,
8: classification_name iem_route_classifications.name%type,
9: customer_name hz_parties.party_name%type,

Line 6: sender_name iem_rt_proc_emails.from_address%type,

2: /* $Header: iemvaims.pls 120.1 2006/02/14 15:16:44 chtang noship $*/
3: TYPE message_type IS RECORD (
4: message_id iem_rt_proc_emails.message_id%type,
5: email_account_id iem_rt_proc_emails.email_account_id%type,
6: sender_name iem_rt_proc_emails.from_address%type,
7: subject iem_rt_proc_emails.subject%type,
8: classification_name iem_route_classifications.name%type,
9: customer_name hz_parties.party_name%type,
10: sent_date varchar2(500),

Line 7: subject iem_rt_proc_emails.subject%type,

3: TYPE message_type IS RECORD (
4: message_id iem_rt_proc_emails.message_id%type,
5: email_account_id iem_rt_proc_emails.email_account_id%type,
6: sender_name iem_rt_proc_emails.from_address%type,
7: subject iem_rt_proc_emails.subject%type,
8: classification_name iem_route_classifications.name%type,
9: customer_name hz_parties.party_name%type,
10: sent_date varchar2(500),
11: message_uid iem_rt_proc_emails.message_id%type,

Line 11: message_uid iem_rt_proc_emails.message_id%type,

7: subject iem_rt_proc_emails.subject%type,
8: classification_name iem_route_classifications.name%type,
9: customer_name hz_parties.party_name%type,
10: sent_date varchar2(500),
11: message_uid iem_rt_proc_emails.message_id%type,
12: agent_account_id iem_agent_accounts.agent_account_id%type,
13: resource_name jtf_rs_resource_extns_vl.resource_name%type,
14: rt_media_item_id iem_rt_media_items.rt_media_item_id%type,
15: agent_id iem_rt_proc_emails.resource_id%type,

Line 15: agent_id iem_rt_proc_emails.resource_id%type,

11: message_uid iem_rt_proc_emails.message_id%type,
12: agent_account_id iem_agent_accounts.agent_account_id%type,
13: resource_name jtf_rs_resource_extns_vl.resource_name%type,
14: rt_media_item_id iem_rt_media_items.rt_media_item_id%type,
15: agent_id iem_rt_proc_emails.resource_id%type,
16: real_received_date iem_rt_proc_emails.received_date%type);
17:
18: TYPE message_tbl IS TABLE OF message_type
19: INDEX BY BINARY_INTEGER;

Line 16: real_received_date iem_rt_proc_emails.received_date%type);

12: agent_account_id iem_agent_accounts.agent_account_id%type,
13: resource_name jtf_rs_resource_extns_vl.resource_name%type,
14: rt_media_item_id iem_rt_media_items.rt_media_item_id%type,
15: agent_id iem_rt_proc_emails.resource_id%type,
16: real_received_date iem_rt_proc_emails.received_date%type);
17:
18: TYPE message_tbl IS TABLE OF message_type
19: INDEX BY BINARY_INTEGER;
20:

Line 22: message_id iem_rt_proc_emails.message_id%type,

18: TYPE message_tbl IS TABLE OF message_type
19: INDEX BY BINARY_INTEGER;
20:
21: TYPE temp_message_type IS RECORD (
22: message_id iem_rt_proc_emails.message_id%type,
23: email_account_id iem_rt_proc_emails.email_account_id%type,
24: sender_name iem_rt_proc_emails.from_address%type,
25: subject iem_rt_proc_emails.subject%type,
26: classification_name iem_route_classifications.name%type,

Line 23: email_account_id iem_rt_proc_emails.email_account_id%type,

19: INDEX BY BINARY_INTEGER;
20:
21: TYPE temp_message_type IS RECORD (
22: message_id iem_rt_proc_emails.message_id%type,
23: email_account_id iem_rt_proc_emails.email_account_id%type,
24: sender_name iem_rt_proc_emails.from_address%type,
25: subject iem_rt_proc_emails.subject%type,
26: classification_name iem_route_classifications.name%type,
27: customer_name hz_parties.party_name%type,

Line 24: sender_name iem_rt_proc_emails.from_address%type,

20:
21: TYPE temp_message_type IS RECORD (
22: message_id iem_rt_proc_emails.message_id%type,
23: email_account_id iem_rt_proc_emails.email_account_id%type,
24: sender_name iem_rt_proc_emails.from_address%type,
25: subject iem_rt_proc_emails.subject%type,
26: classification_name iem_route_classifications.name%type,
27: customer_name hz_parties.party_name%type,
28: sent_date varchar2(500),

Line 25: subject iem_rt_proc_emails.subject%type,

21: TYPE temp_message_type IS RECORD (
22: message_id iem_rt_proc_emails.message_id%type,
23: email_account_id iem_rt_proc_emails.email_account_id%type,
24: sender_name iem_rt_proc_emails.from_address%type,
25: subject iem_rt_proc_emails.subject%type,
26: classification_name iem_route_classifications.name%type,
27: customer_name hz_parties.party_name%type,
28: sent_date varchar2(500),
29: real_sent_date iem_rt_proc_emails.sent_date%type,

Line 29: real_sent_date iem_rt_proc_emails.sent_date%type,

25: subject iem_rt_proc_emails.subject%type,
26: classification_name iem_route_classifications.name%type,
27: customer_name hz_parties.party_name%type,
28: sent_date varchar2(500),
29: real_sent_date iem_rt_proc_emails.sent_date%type,
30: message_uid iem_rt_proc_emails.message_id%type,
31: resource_name jtf_rs_resource_extns_vl.resource_name%type,
32: rt_media_item_id iem_rt_media_items.rt_media_item_id%type,
33: agent_id iem_rt_proc_emails.resource_id%type);

Line 30: message_uid iem_rt_proc_emails.message_id%type,

26: classification_name iem_route_classifications.name%type,
27: customer_name hz_parties.party_name%type,
28: sent_date varchar2(500),
29: real_sent_date iem_rt_proc_emails.sent_date%type,
30: message_uid iem_rt_proc_emails.message_id%type,
31: resource_name jtf_rs_resource_extns_vl.resource_name%type,
32: rt_media_item_id iem_rt_media_items.rt_media_item_id%type,
33: agent_id iem_rt_proc_emails.resource_id%type);
34:

Line 33: agent_id iem_rt_proc_emails.resource_id%type);

29: real_sent_date iem_rt_proc_emails.sent_date%type,
30: message_uid iem_rt_proc_emails.message_id%type,
31: resource_name jtf_rs_resource_extns_vl.resource_name%type,
32: rt_media_item_id iem_rt_media_items.rt_media_item_id%type,
33: agent_id iem_rt_proc_emails.resource_id%type);
34:
35: TYPE temp_message_tbl IS TABLE OF temp_message_type
36: INDEX BY BINARY_INTEGER;
37: