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;