DBA Data[Home] [Help]

APPS.IEM_QUEUE_MANAGEMENT_PVT dependencies on IEM_RT_PROC_EMAILS

Line 4: message_id iem_rt_proc_emails.message_id%type,

1: package IEM_QUEUE_MANAGEMENT_PVT AUTHID CURRENT_USER as
2: /* $Header: iemvqums.pls 120.1 2006/02/13 14:33:40 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_QUEUE_MANAGEMENT_PVT AUTHID CURRENT_USER as
2: /* $Header: iemvqums.pls 120.1 2006/02/13 14:33:40 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: iemvqums.pls 120.1 2006/02/13 14:33:40 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_agents.agent_id%type,
13: group_name jtf_rs_groups_tl.group_name%type,
14: real_received_date iem_rt_proc_emails.received_date%type);
15:

Line 14: real_received_date iem_rt_proc_emails.received_date%type);

10: sent_date varchar2(500),
11: message_uid iem_rt_proc_emails.message_id%type,
12: agent_account_id iem_agents.agent_id%type,
13: group_name jtf_rs_groups_tl.group_name%type,
14: real_received_date iem_rt_proc_emails.received_date%type);
15:
16: TYPE message_tbl IS TABLE OF message_type
17: INDEX BY BINARY_INTEGER;
18:

Line 20: message_id iem_rt_proc_emails.message_id%type,

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

Line 21: email_account_id iem_rt_proc_emails.email_account_id%type,

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

Line 22: sender_name iem_rt_proc_emails.from_address%type,

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

Line 23: subject iem_rt_proc_emails.subject%type,

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

Line 27: real_sent_date iem_rt_proc_emails.sent_date%type,

23: subject iem_rt_proc_emails.subject%type,
24: classification_name iem_route_classifications.name%type,
25: customer_name hz_parties.party_name%type,
26: sent_date varchar2(500),
27: real_sent_date iem_rt_proc_emails.sent_date%type,
28: message_uid iem_rt_proc_emails.message_id%type,
29: group_name jtf_rs_groups_tl.group_name%type);
30:
31: TYPE temp_message_tbl IS TABLE OF temp_message_type

Line 28: message_uid iem_rt_proc_emails.message_id%type,

24: classification_name iem_route_classifications.name%type,
25: customer_name hz_parties.party_name%type,
26: sent_date varchar2(500),
27: real_sent_date iem_rt_proc_emails.sent_date%type,
28: message_uid iem_rt_proc_emails.message_id%type,
29: group_name jtf_rs_groups_tl.group_name%type);
30:
31: TYPE temp_message_tbl IS TABLE OF temp_message_type
32: INDEX BY BINARY_INTEGER;