[Home] [Help]
PACKAGE: APPS.IEM_QUEUE_MANAGEMENT_PVT
Source
1 package IEM_QUEUE_MANAGEMENT_PVT 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,
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
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,
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;
33
34 TYPE resource_count_type IS RECORD (
35 resource_id number,
36 resource_name varchar2(200),
37 email_count number,
38 last_login_time varchar2(500));
39
40 TYPE resource_count_tbl IS TABLE OF resource_count_type
41 INDEX BY BINARY_INTEGER;
42
43 TYPE resource_group_count_type IS RECORD (
44 group_id number,
45 group_name varchar2(200),
46 agent_count number,
47 email_count number);
48
49 TYPE resource_group_count_tbl IS TABLE OF resource_group_count_type
50 INDEX BY BINARY_INTEGER;
51
52
53
54 PROCEDURE search_messages_in_queue (p_api_version_number IN NUMBER,
55 p_init_msg_list IN VARCHAR2:=NULL,
56 p_commit IN VARCHAR2:=NULL,
57 p_email_account_id in number,
58 p_classification_id in number,
59 p_subject in varchar2 :=NULL,
60 p_customer_name in varchar2 :=NULL,
61 p_sender_name in varchar2 :=NULL,
62 p_sent_date_from in varchar2 :=NULL,
63 p_sent_date_to in varchar2 :=NULL,
64 p_sent_date_format in varchar2 :=NULL,
65 p_group_id in number,
66 p_sort_column IN number:=5,
67 p_sort_state IN varchar2 :=NULL,
68 x_message_tbl out nocopy message_tbl,
69 x_return_status OUT NOCOPY VARCHAR2,
70 x_msg_count OUT NOCOPY NUMBER,
71 x_msg_data OUT NOCOPY VARCHAR2);
72
73 PROCEDURE get_total_count_in_queue (p_api_version_number IN NUMBER,
74 p_init_msg_list IN VARCHAR2 := NULL,
75 p_commit IN VARCHAR2 := NULL,
76 p_email_account_id in number,
77 p_classification_id in number,
78 p_subject in varchar2 :=NULL,
79 p_customer_name in varchar2 :=NULL,
80 p_sender_name in varchar2 :=NULL,
81 p_sent_date_from in varchar2 :=NULL,
82 p_sent_date_to in varchar2 :=NULL,
83 p_sent_date_format in varchar2 :=NULL,
84 p_group_id in number,
85 x_message_count out nocopy number,
86 x_return_status OUT NOCOPY VARCHAR2,
87 x_msg_count OUT NOCOPY NUMBER,
88 x_msg_data OUT NOCOPY VARCHAR2);
89
90 PROCEDURE show_agent_list (p_api_version_number IN NUMBER,
91 p_init_msg_list IN VARCHAR2 := NULL,
92 p_commit IN VARCHAR2 := NULL,
93 p_email_account_id in number,
94 p_sort_column IN number,
95 p_sort_state IN varchar2,
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 PROCEDURE show_resource_group_list (p_api_version_number IN NUMBER,
102 p_init_msg_list IN VARCHAR2 := NULL,
103 p_commit IN VARCHAR2 := NULL,
104 p_email_account_id in number,
105 p_sort_column IN number,
106 p_sort_state IN varchar2,
107 x_resource_group_count out nocopy resource_group_count_tbl,
108 x_return_status OUT NOCOPY VARCHAR2,
109 x_msg_count OUT NOCOPY NUMBER,
110 x_msg_data OUT NOCOPY VARCHAR2);
111
112 end IEM_QUEUE_MANAGEMENT_PVT;