[Home] [Help]
PACKAGE BODY: APPS.BIX_SERVER_PUB
Source
1 package body BIX_SERVER_PUB AS
2 /* $Header: BIXSERSB.pls 115.6 2003/01/10 02:46:55 achanda ship $: */
3 procedure POPULATE_BIX_SERVER_SUM_CP
4 IS
5 CURSOR POP_BIX_SERVER_SUM_CP
6 IS
7 SELECT SUM(busy_counts) busy_counts,
8 SUM(connect_counts) connect_counts,
9 SUM(answering_machine_counts) answering_machine_counts,
10 SUM(modem_counts) modem_counts,
11 SUM(sit_counts) sit_counts,
12 SUM(rna_counts) rna_counts,
13 SUM(other_counts) other_counts,
14 SUM(withdrawn_dials) withdrawn_dials,
15 SUM(average_wait_time) average_wait_time,
16 SUM(std_dev_wait_time) std_dev_wait_time,
17 SUM(minimum_wait_time) minimum_wait_time,
18 SUM(maximum_wait_time) maximum_wait_time,
19 SUM(total_wait_time) total_wait_time,
20 SUM(number_agents_predictive) number_agents_predictive,
21 SUM(number_working_dialers) number_working_dialers,
22 SUM(number_abandons) number_abandons,
23 SUM(abandon_percentage) abandon_percentage,
24 SUM(dials_per_minute) dials_per_minute,
25 SUM(number_agents_outbound) number_agents_outbound,
26 SUM(number_calls_outcome_1) number_calls_outcome_1,
27 SUM(number_calls_outcome_2) number_calls_outcome_2,
28 SUM(number_calls_outcome_3) number_calls_outcome_3,
29 SUM(number_records_remaining) number_records_remaining,
30 SUM(number_records_start_of_day) number_records_start_of_day,
31 SUM(num_recs_to_be_released_next_1) num_recs_to_be_released_next_1,
32 site_id site_id,
33 campaign_id campaign_id,
34 list_id list_id,
35 to_char(minute, 'DD-Mon-YY HH') hour
36 FROM BIX_SERVER_CP
37 GROUP BY site_id, campaign_id, list_id, to_char(minute, 'DD-Mon-YY HH');
38 BEGIN
39
40 FOR recs in POP_BIX_SERVER_SUM_CP LOOP
41
42 INSERT INTO BIX_SERVER_SUM_CP
43 (
44 server_sum_cp_id,
45 site,
46 campaign_id,
47 list_id,
48 hour,
49 busy_counts,
50 connect_counts,
51 answering_machine_counts,
52 modem_counts,
53 sit_counts,
54 rna_counts,
55 other_counts,
56 withdrawn_dials,
57 average_wait_time,
58 std_dev_wait_time,
59 minimum_wait_time,
60 maximum_wait_time,
61 total_wait_time,
62 number_agents_predictive,
63 number_working_dialers,
64 number_abandons,
65 abandon_percentage,
66 dials_per_minute,
67 number_agents_outbound,
68 number_calls_outcome_1,
69 number_calls_outcome_2,
70 number_calls_outcome_3,
71 number_records_remaining,
72 number_records_start_of_day,
73 number_records_to_be_released)
74 VALUES(
75 bix_server_sum_cp_s.nextval,
76 recs.site_id,
77 recs.campaign_id,
78 recs.list_id,
79 recs.hour,
80 recs.busy_counts,
81 recs.connect_counts,
82 recs.answering_machine_counts,
83 recs.modem_counts,
84 recs.sit_counts,
85 recs.rna_counts,
86 recs.other_counts,
87 recs.withdrawn_dials,
88 recs.average_wait_time,
89 recs.std_dev_wait_time,
90 recs.minimum_wait_time,
91 recs.maximum_wait_time,
92 recs.total_wait_time,
93 recs.number_agents_predictive,
94 recs.number_working_dialers,
95 recs.number_abandons,
96 recs.abandon_percentage,
97 recs.dials_per_minute,
98 recs.number_agents_outbound,
99 recs.number_calls_outcome_1,
100 recs.number_calls_outcome_2,
101 recs.number_calls_outcome_3,
102 recs.number_records_remaining,
103 recs.number_records_start_of_day,
104 recs.num_recs_to_be_released_next_1);
105 END LOOP;
106 END POPULATE_BIX_SERVER_SUM_CP;
107 procedure POPULATE_BIX_SERVER_X
108 IS
109 BEGIN
110 populate_bix_server_sum_cp;
111 exception
112 when others then null;
113 END POPULATE_BIX_SERVER_X;
114
115 procedure POPULATE_BIX_SERVER_X(errbuf out nocopy varchar2,
116 retcode out nocopy varchar2)
117 IS
118 BEGIN
119 declare
120 l_message varchar2(2000);
121 begin
122 BIX_SERVER_PUB.POPULATE_BIX_SERVER_X;
123 exception
124 WHEN OTHERS THEN
125 errbuf := sqlerrm;
126 retcode := '-20001';
127 l_message := errbuf;
128 FND_FILE.put_line(FND_FILE.log,l_message);
129 raise;
130 end;
131 END POPULATE_BIX_SERVER_X; /* end of conc mgr for POPULATE_BIX_SERVER_X */
132
133 END BIX_SERVER_PUB;