[Home] [Help]
PACKAGE: APPS.IEM_SPV_MONITORING_PVT
Source
1 package IEM_SPV_MONITORING_PVT AUTHID CURRENT_USER as
2 /* $Header: iemvspms.pls 115.4 2003/09/08 23:47:08 chtang noship $*/
3 TYPE email_activity IS RECORD (
4 email_account_id iem_post_mdts.email_account_id%type,
5 classification_id iem_route_classifications.route_classification_id%type,
6 account_classification_name varchar2(256),
7 queue_count number,
8 total_count number,
9 queue_wait_time number,
10 agent_count number,
11 inbox_count number,
12 inbox_wait_time number,
13 queue_average_time number,
14 inbox_average_time number,
15 queue_zero_flag varchar2(10),
16 inbox_zero_flag varchar2(10));
17
18 TYPE email_activity_tbl IS TABLE OF email_activity
19 INDEX BY BINARY_INTEGER;
20
21 TYPE agent_activity IS RECORD (
22 resource_id iem_post_mdts.agent_id%type,
23 email_account_id iem_email_accounts.email_account_id%type,
24 resource_account_name varchar2(750),
25 email_count number,
26 assigned_email_count number,
27 average_age number,
28 oldest_age number,
29 last_login_time varchar2(500),
30 account_count number,
31 zero_flag varchar2(10),
32 requeue_all_flag varchar2(10));
33
34 TYPE agent_activity_tbl IS TABLE OF agent_activity
35 INDEX BY BINARY_INTEGER;
36
37 PROCEDURE get_email_activity (p_api_version_number IN NUMBER,
38 p_init_msg_list IN VARCHAR2,
39 p_commit IN VARCHAR2,
40 x_email_activity_tbl OUT NOCOPY email_activity_tbl,
41 x_return_status OUT NOCOPY VARCHAR2,
42 x_msg_count OUT NOCOPY NUMBER,
43 x_msg_data OUT NOCOPY VARCHAR2);
44
45 PROCEDURE get_agent_activity (p_api_version_number IN NUMBER,
46 p_init_msg_list IN VARCHAR2,
47 p_commit IN VARCHAR2,
48 p_resource_role IN NUMBER:=1,
49 p_resource_name IN VARCHAR2:=null,
50 x_agent_activity_tbl OUT NOCOPY agent_activity_tbl,
51 x_return_status OUT NOCOPY VARCHAR2,
52 x_msg_count OUT NOCOPY NUMBER,
53 x_msg_data OUT NOCOPY VARCHAR2);
54
55
56 end IEM_SPV_MONITORING_PVT;