The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT server_group_id
FROM ieo_svr_groups
WHERE UPPER (group_name) = UPPER (v_site_name)
ORDER BY server_group_id;
SELECT campaign_id
FROM ams_campaigns_all_tl
WHERE UPPER (campaign_name) = UPPER (v_campaign_name)
ORDER BY campaign_id;
SELECT list_header_id
FROM ams_list_headers_all
WHERE UPPER (list_name) = UPPER (v_list_name)
ORDER BY list_header_id;
INSERT INTO bix_server_cp
(server_cp_id, minute, site_id, campaign_id, list_id,
busy_counts, connect_counts, answering_machine_counts,
modem_counts, sit_counts, rna_counts, other_counts,
predictive_dials, progressive_dials, preview_dials,
preview_time, withdrawn_dials,
average_wait_time, std_dev_wait_time,
average_cumulative_wait_time, std_dev_cumulative_wait_time,
minimum_wait_time, maximum_wait_time, total_wait_time,
number_agents_predictive, number_agents_outbound,
number_working_dialers, number_abandons, abandon_percentage,
number_callbacks, callback_percentage, dials_per_minute,
number_calls_outcome_1, number_calls_outcome_2,
number_calls_outcome_3,
number_records_start_of_day, number_records_remaining,
predicted_exhaustion_date, num_recs_to_be_released_next_1,
num_rec_to_be_released_next_5, num_rec_to_be_released_next_15,
num_rec_to_be_released_next_60)
SELECT bix_server_cp_s.nextval, trunc (p_time, 'MI'), l_site_id,
l_campaign_id, l_list_id,
p_busy_count, p_connect_count, p_answering_machine_count,
p_modem_count, p_sit_count, p_rna_count, p_other_count,
p_predictive_dials, p_progressive_dials, p_preview_dials,
p_preview_time, p_withdrawn_dials,
p_wait_time_average, p_wait_time_std_dev,
p_wait_time_cumulative_avg, p_wait_time_cumulative_stddev,
p_wait_time_minimum, p_wait_time_maximum, p_wait_time_total,
p_number_agents_predictive, p_number_agents_outbound,
p_number_working_dialers, p_abandon_count, p_abandon_percentage,
p_callback_count, p_callback_percentage,
p_predictive_dials + p_progressive_dials + p_preview_dials,
p_outcome_1_count, p_outcome_2_count, p_outcome_3_count,
p_records_start_of_day, p_records_remaining,
p_predicted_exhaustion_date,
p_recs_to_be_released_in_1, p_recs_to_be_released_in_5,
p_recs_to_be_released_in_15, p_recs_to_be_released_in_60
FROM dual;
FND_MESSAGE.SET_NAME('CCT', 'CCT_SDI_AO_IN_INSERT_ERROR');
FND_MESSAGE.SET_NAME('CCT', 'CCT_SDI_AO_IN_RECORD_INSERTED');
SELECT server_group_id
FROM ieo_svr_groups
WHERE UPPER (group_name) = UPPER (v_site_name)
ORDER BY server_group_id;
SELECT wbsc_id
FROM ieb_wb_svc_cats
WHERE UPPER (service_category_name) = UPPER (v_los_name)
ORDER BY wbsc_id;
SELECT covs.quota
FROM ieb_outb_svc_coverages covs,
ieb_service_plans plan,
ieb_wb_svc_cats cats
WHERE cats.wbsc_id = v_los_id
AND cats.svcpln_svcpln_id = plan.svcpln_id
AND covs.svcpln_svcpln_id = plan.svcpln_id
-- Get weekday match (for regular) or date match (for specific)
AND (covs.regular_schd_day = (TO_NUMBER (TO_CHAR (v_time, 'd')) - 1)
OR TRUNC (covs.spec_schd_date, 'dd') = TRUNC (v_time, 'dd'))
AND covs.begin_time_hhmm <= TO_NUMBER (TO_CHAR (v_time, 'hh24mi'))
AND covs.end_time_hhmm >= TO_NUMBER (TO_CHAR (v_time, 'hh24mi'))
-- will get two records if there is a specific match
ORDER BY schedule_type DESC;
INSERT INTO bix_server_ib
(server_ib_id, minute, site_id, media_item_type,
los_category_id, los_category_direction,
number_of_items_queued, number_of_items_serviced,
items_serviced_within_los, items_not_serviced_within_los,
number_agents_working, minimum_number_of_agents_req,
items_left_to_be_serviced, items_serviced_today)
SELECT bix_server_ib_s.nextval, trunc (p_time, 'MI'), l_site_id,
l_media_type, l_los_id, p_direction,
p_items_queued_count, p_items_serviced_count,
l_items_serviced_within_LOS, l_items_not_serv_within_LOS,
p_number_agents_working, p_minimum_agents_required,
p_items_left_to_be_serviced, p_items_serviced_today
FROM dual;
FND_MESSAGE.SET_NAME('CCT', 'CCT_SDI_IB_IN_INSERT_ERROR');
FND_MESSAGE.SET_NAME('CCT', 'CCT_SDI_IB_IN_RECORD_INSERTED');
SELECT server_group_id
FROM ieo_svr_groups
WHERE UPPER (group_name) = UPPER (v_interaction_center_name)
ORDER BY server_group_id;
SELECT classification
FROM cct_classifications
WHERE classification_id = v_interaction_class_id
ORDER BY classification;
INSERT INTO bix_server_mcm
(server_mcm_id, minute,
interaction_center_id, interaction_classification,
interactions_received, interactions_offered,
interactions_answered, interactions_transferred,
interactions_handled, interactions_abandoned,
average_speed_to_answer, std_dev_speed_to_answer,
total_speed_to_answer,
average_wait_to_abandoned, std_dev_wait_to_abandoned,
total_wait_to_abandoned,
percent_occupancy_rate, percent_utilization_rate,
percent_transfer_rate,
talk_time, hold_time, idle_time, wrap_time, log_time)
SELECT bix_server_cp_s.nextval, trunc (p_time, 'MI'),
l_interaction_center_id, l_interaction_class_name,
p_interactions_received, p_interactions_offered,
p_interactions_answered, p_interactions_transferred,
p_interactions_handled, p_interactions_abandoned,
p_speed_to_answer_avg, p_speed_to_answer_std_dev,
p_speed_to_answer_total,
p_wait_to_abandon_avg, p_wait_to_abandon_std_dev,
p_wait_to_abandon_total,
p_percent_occupancy_rate, p_percent_utilization_rate,
p_percent_transfer_rate,
p_total_talk_time, p_total_hold_time, p_total_idle_time,
p_total_wrap_time, p_total_log_time
FROM dual;
FND_MESSAGE.SET_NAME('CCT', 'CCT_SDI_MCM_IN_INSERT_ERROR');
FND_MESSAGE.SET_NAME('CCT', 'CCT_SDI_MCM_IN_RECORD_INSERTED');