The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT *
INTO l_interface_rec
FROM ams_adi_media_planner
WHERE operation_type = 'IMPORT'
AND object_type = p_object_type
AND object_name = p_object_name
AND parent_type = p_parent_type
AND parent_id = p_parent_id;
SELECT activity_metric_id, object_version_number
FROM ams_act_metrics_all
WHERE metric_id = p_metric_id
AND act_metric_used_by_id = p_act_metric_used_by_id
AND arc_act_metric_used_by = p_arc_act_metric_used_by
ORDER BY activity_metric_id;
SELECT display_type FROM ams_metrics_all_b
WHERE metric_id = p_metric_id;
Ams_Actmetric_Pvt.update_actmetric (
p_api_version => 1.0,
p_init_msg_list => FND_API.G_FALSE,
p_commit => FND_API.G_FALSE,
p_act_metric_rec => l_table_of_metrics(i),
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data);
': Return Status update_actmetric '||l_return_status);
SELECT *
FROM ams_adi_media_planner
WHERE upload_batch_id = p_upload_batch_id;
x_actmetric_table.delete;
DELETE FROM ams_adi_media_planner
WHERE operation_type = 'IMPORT'
AND object_type = p_object_type
AND object_name = p_object_name
AND parent_type = p_parent_type
AND parent_id = p_parent_id;