[Home] [Help]
377: CLOSE list_header_id_cur;
378: END;
379: END IF;
380:
381: INSERT INTO bix_server_cp
382: (server_cp_id, minute, site_id, campaign_id, list_id,
383: busy_counts, connect_counts, answering_machine_counts,
384: modem_counts, sit_counts, rna_counts, other_counts,
385: predictive_dials, progressive_dials, preview_dials,
395: number_records_start_of_day, number_records_remaining,
396: predicted_exhaustion_date, num_recs_to_be_released_next_1,
397: num_rec_to_be_released_next_5, num_rec_to_be_released_next_15,
398: num_rec_to_be_released_next_60)
399: SELECT bix_server_cp_s.nextval, trunc (p_time, 'MI'), l_site_id,
400: l_campaign_id, l_list_id,
401: p_busy_count, p_connect_count, p_answering_machine_count,
402: p_modem_count, p_sit_count, p_rna_count, p_other_count,
403: p_predictive_dials, p_progressive_dials, p_preview_dials,
1151: total_wait_to_abandoned,
1152: percent_occupancy_rate, percent_utilization_rate,
1153: percent_transfer_rate,
1154: talk_time, hold_time, idle_time, wrap_time, log_time)
1155: SELECT bix_server_cp_s.nextval, trunc (p_time, 'MI'),
1156: l_interaction_center_id, l_interaction_class_name,
1157: p_interactions_received, p_interactions_offered,
1158: p_interactions_answered, p_interactions_transferred,
1159: p_interactions_handled, p_interactions_abandoned,