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,
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,
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),
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,
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:
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:
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,
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,
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),
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,
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
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;