[Home] [Help]
PACKAGE: APPS.IEM_AGENT_INBOX_MGMT_PVT
Source
1 package IEM_AGENT_INBOX_MGMT_PVT AUTHID CURRENT_USER 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,
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,
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
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,
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
38 TYPE resource_count_type IS RECORD (
39 resource_id number,
40 resource_name varchar2(200),
41 email_count number,
42 last_login_time varchar2(500));
43
44 TYPE resource_count_tbl IS TABLE OF resource_count_type
45 INDEX BY BINARY_INTEGER;
46
47
48 PROCEDURE search_messages_in_inbox (p_api_version_number IN NUMBER,
49 p_init_msg_list IN VARCHAR2:=NULL,
50 p_commit IN VARCHAR2:=NULL,
51 p_email_account_id in number,
52 p_classification_id in number,
53 p_subject in varchar2 :=NULL,
54 p_customer_name in varchar2 :=NULL,
55 p_sender_name in varchar2 :=NULL,
56 p_sent_date_from in varchar2 :=NULL,
57 p_sent_date_to in varchar2 :=NULL,
58 p_sent_date_format in varchar2 :=NULL,
59 p_resource_name in varchar2 :=NULL,
60 p_resource_id in number,
61 p_page_flag in number,
62 p_sort_column IN number:=5,
63 p_sort_state IN varchar2 :=NULL,
64 x_message_tbl out nocopy message_tbl,
65 x_return_status OUT NOCOPY VARCHAR2,
66 x_msg_count OUT NOCOPY NUMBER,
67 x_msg_data OUT NOCOPY VARCHAR2);
68
69 PROCEDURE get_total_count_in_inbox (p_api_version_number IN NUMBER,
70 p_init_msg_list IN VARCHAR2:=NULL,
71 p_commit IN VARCHAR2:=NULL,
72 p_email_account_id in number,
73 p_classification_id in number,
74 p_subject in varchar2 :=NULL,
75 p_customer_name in varchar2 :=NULL,
76 p_sender_name in varchar2 :=NULL,
77 p_sent_date_from in varchar2 :=NULL,
78 p_sent_date_to in varchar2 :=NULL,
79 p_sent_date_format in varchar2 :=NULL,
80 p_resource_name in varchar2 :=NULL,
81 p_resource_id in number,
82 x_message_count out NOCOPY number,
83 x_return_status OUT NOCOPY VARCHAR2,
84 x_msg_count OUT NOCOPY NUMBER,
85 x_msg_data OUT NOCOPY VARCHAR2);
86
87 PROCEDURE show_agent_list (p_api_version_number IN NUMBER,
88 p_init_msg_list IN VARCHAR2 := NULL,
89 p_commit IN VARCHAR2 := NULL,
90 p_email_account_id in number,
91 p_sort_column IN number,
92 p_sort_state IN varchar2,
93 p_resource_role IN number :=1,
94 p_resource_name IN varchar2 := null,
95 p_transferrer_id IN number :=-1,
96 x_resource_count out nocopy resource_count_tbl,
97 x_return_status OUT NOCOPY VARCHAR2,
98 x_msg_count OUT NOCOPY NUMBER,
99 x_msg_data OUT NOCOPY VARCHAR2);
100
101 end IEM_AGENT_INBOX_MGMT_PVT;