1 PACKAGE IEC_REPORTS_UTIL_PVT AS
2 /* $Header: IECVREPS.pls 120.1 2006/05/05 07:07:39 minwang noship $ */
3
4
5 -- Update the agent-state table.
6
7 PROCEDURE UPDATE_AGENT_STATE
8 (P_RESOURCE_ID IN NUMBER
9 ,P_DIAL_SERVER_ID IN NUMBER
10 ,P_CAMPAIGN_ID IN NUMBER
11 ,P_CPN_SCHEDULE_ID IN NUMBER
12 ,P_STATUS IN VARCHAR2
13 ,P_STATUS_REASON IN VARCHAR2
14 ,P_START_TIME IN VARCHAR2
15 );
16
17 PROCEDURE UPDATE_AGENT_OUTCOME_DETAILS
18 ( P_RESOURCE_ID IN NUMBER
19 ,P_DIAL_SERVER_ID IN NUMBER
20 ,P_CAMPAIGN_ID IN NUMBER
21 ,P_CAMPAIGN_SCHEDULE_ID IN NUMBER
22 ,P_OUTCOME_ID IN NUMBER
23 ,P_RESULT_ID IN NUMBER
24 ,P_RESULT_COUNT IN NUMBER
25 ,P_FTC_ABANDON_COUNT IN NUMBER
26 ,P_MESSAGE_PLAYED_COUNT IN NUMBER
27 ,P_POSITIVE_RESPONSE_FLAG IN VARCHAR2
28 ,P_CONTACT_FLAG IN VARCHAR2
29 ,P_TOTAL_IDLE_TIME IN NUMBER
30 ,P_TOTAL_WAIT_TIME IN NUMBER
31 ,P_TOTAL_TALK_TIME IN NUMBER
32 ,P_TOTAL_WRAPUP_TIME IN NUMBER
33 ,P_TOTAL_BREAK_TIME IN NUMBER
34 ,P_CALLS_OFFERED IN NUMBER
35 ,P_PRED_CALLS_OFFERED IN NUMBER
36 ,P_LOGIN_AGENT_COUNT IN NUMBER
37 );
38
39 PROCEDURE UPDATE_AGENT_CURRENT_STATE
40 ( P_RESOURCE_ID IN NUMBER
41 ,P_DIAL_SERVER_ID IN NUMBER
42 ,P_CAMPAIGN_SCHEDULE_ID IN NUMBER
43 ,P_CURRENT_STATUS IN VARCHAR2
44 ,P_CURRENT_STATUS_BEGIN_TIME IN VARCHAR2
45 );
46
47 PROCEDURE UPDATE_CPN_AGT_OUTCOME_DETAILS
48 ( P_DIAL_SERVER_ID IN NUMBER
49 ,P_CAMPAIGN_ID IN NUMBER
50 ,P_CAMPAIGN_SCHEDULE_ID IN NUMBER
51 ,P_OUTCOME_ID IN NUMBER
52 ,P_RESULT_ID IN NUMBER
53 ,P_RESULT_COUNT IN NUMBER
54 ,P_FTC_ABANDON_COUNT IN NUMBER
55 ,P_MESSAGE_PLAYED_COUNT IN NUMBER
56 ,P_POSITIVE_RESPONSE_FLAG IN VARCHAR2
57 ,P_CONTACT_FLAG IN VARCHAR2
58 ,P_TOTAL_IDLE_TIME IN NUMBER
59 ,P_TOTAL_WAIT_TIME IN NUMBER
60 ,P_TOTAL_TALK_TIME IN NUMBER
61 ,P_TOTAL_WRAPUP_TIME IN NUMBER
62 ,P_TOTAL_BREAK_TIME IN NUMBER
63 ,P_CALLS_OFFERED IN NUMBER
64 ,P_PRED_CALLS_OFFERED IN NUMBER
65 );
66
67 PROCEDURE UPDATE_CPN_AGENT_STATS
68 ( P_DIAL_SERVER_ID IN NUMBER
69 ,P_CAMPAIGN_ID IN NUMBER
70 ,P_CAMPAIGN_SCHEDULE_ID IN NUMBER
71 ,P_NUM_LOGIN_AGENTS IN NUMBER
72 ,P_NUM_CPN_LOGIN_AGENTS IN NUMBER
73 ,P_PREVIEW_DIALS IN NUMBER
74 ,P_TIMED_PREVIEW_DIALS IN NUMBER
75 ,P_PROGRESSIVE_DIALS IN NUMBER
76 ,P_PREDICTIVE_DIALS IN NUMBER
77 ,P_MANUAL_DIALS IN NUMBER
78 ,P_PREDICTIVE_DIAL_FHQ_COUNT IN NUMBER
79 ,P_CURRENT_IN_FHQ IN NUMBER
80 ,P_NUM_AGENTS_ON_CALL IN NUMBER
81 ,P_NUM_AGENTS_IN_WRAPUP IN NUMBER
82 ,P_NUM_AGENTS_AVAILABLE IN NUMBER
83 ,P_NUM_AGENTS_IDLE IN NUMBER
84 ,P_NUM_AGENTS_ON_BREAK IN NUMBER
85 ,P_NUM_VOICE_DETECTED IN NUMBER
86 ,P_CALLS_OFFERED IN NUMBER
87 ,P_PRED_CALLS_OFFERED IN NUMBER
88 );
89
90 PROCEDURE UPDATE_CPN_DIAL_STATS
91 ( P_DIAL_SERVER_ID IN NUMBER
92 ,P_CAMPAIGN_ID IN NUMBER
93 ,P_CAMPAIGN_SCHEDULE_ID IN NUMBER
94 ,P_OUTCOME_ID IN NUMBER
95 ,P_RESULT_ID IN NUMBER
96 ,P_RESULT_COUNT IN NUMBER
97 ,P_FTC_ABANDON_COUNT IN NUMBER
98 ,P_MESSAGE_PLAYED_COUNT IN NUMBER
99 ,P_POSITIVE_RESPONSE_FLAG IN VARCHAR2
100 ,P_CONTACT_FLAG IN VARCHAR2
101 ,P_TOTAL_DIALS IN NUMBER
102 );
103
104 PROCEDURE UPDATE_CPN_SYS_OUTCOME_DETAILS
105 ( P_DIAL_SERVER_ID IN NUMBER
106 ,P_CAMPAIGN_ID IN NUMBER
107 ,P_CAMPAIGN_SCHEDULE_ID IN NUMBER
108 ,P_PREDICTIVE_OUTCOME_ID IN NUMBER
109 ,P_PREDICTIVE_RESULT_ID IN NUMBER
110 ,P_PREDICTIVE_RESULT_COUNT IN NUMBER
111 ,P_FTC_ABANDON_COUNT IN NUMBER
112 ,P_MESSAGE_PLAYED_COUNT IN NUMBER
113 ,P_POSITIVE_RESPONSE_FLAG IN VARCHAR2
114 ,P_CONTACT_FLAG IN VARCHAR2
115 ,P_TOTAL_DIALS IN NUMBER
116 );
117
118 PROCEDURE ADD_DUMMY_AGENT_RECORD
119 ( P_DIAL_SERVER_ID IN NUMBER
120 ,P_CAMPAIGN_ID IN NUMBER
121 ,P_CAMPAIGN_SCHEDULE_ID IN NUMBER
122 ,P_OUTCOME_ID IN NUMBER
123 ,P_RESULT_ID IN NUMBER
124 ,P_RESULT_COUNT IN NUMBER
125 ,P_FTC_ABANDON_COUNT IN NUMBER
126 ,P_MESSAGE_PLAYED_COUNT IN NUMBER
127 ,P_POSITIVE_RESPONSE_FLAG IN VARCHAR2
128 ,P_CONTACT_FLAG IN VARCHAR2
129 );
130
131 PROCEDURE ADD_DUMMY_SYS_RECORD
132 ( P_DIAL_SERVER_ID IN NUMBER
133 ,P_CAMPAIGN_ID IN NUMBER
134 ,P_CAMPAIGN_SCHEDULE_ID IN NUMBER
135 ,P_PREDICTIVE_OUTCOME_ID IN NUMBER
136 ,P_PREDICTIVE_RESULT_ID IN NUMBER
137 ,P_PREDICTIVE_RESULT_COUNT IN NUMBER
138 ,P_FTC_ABANDON_COUNT IN NUMBER
139 ,P_MESSAGE_PLAYED_COUNT IN NUMBER
140 ,P_POSITIVE_RESPONSE_FLAG IN VARCHAR2
141 ,P_CONTACT_FLAG IN VARCHAR2
142 ,P_DIALING_METHOD IN VARCHAR2
143 );
144
145
146 PROCEDURE UPDATE_ITEM_CC_TZS_COUNTS (
147 X_ITM_CC_TZ_ID IN NUMBER,
148 X_STATUS OUT NOCOPY VARCHAR2
149 );
150
151 PROCEDURE CHECK_ALL_CAMPAIGN_CC_TZS
152 (
153 X_CAMPAIGN_ID IN NUMBER
154 );
155
156 PROCEDURE CHECK_ONE_CAMPAIGN_CC_TZS
157 (
158 X_CAMPAIGN_ID IN NUMBER
159 );
160
161 PROCEDURE CHECK_SCHEDULE_CC_TZS
162 (
163 X_SCHEDULE_ID IN NUMBER
164 );
165
166
167 END IEC_REPORTS_UTIL_PVT;