The following lines contain the word 'select', 'insert', 'update' or 'delete':
INSERT INTO qa_chart_control(
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
chart_id,
line,
x_value,
top_y_value,
top_ucl_value,
top_mean_value,
top_lcl_value,
bottom_y_value,
bottom_ucl_value,
bottom_mean_value,
bottom_lcl_value)
SELECT
/* Small amount of data from one session only. */
/* FTS expected and reviewed by bso 1/13/2006. */
fnd_global.user_id,
sysdate,
fnd_global.user_id,
sysdate,
fnd_global.login_id,
p_chart_id,
rownum,
subgroup_number,
average,
p_top_ucl,
p_top_mean,
p_top_lcl,
nvl(range, 0), -- range can be NULL for XmR
p_bottom_ucl,
p_bottom_mean,
p_bottom_lcl
FROM
qa_chart_data;
DELETE
/* Small amount of data from one session only. */
/* FTS expected and reviewed by bso 1/13/2006. */
FROM qa_chart_data;
PROCEDURE delete_data(p_chart_id NUMBER) IS
BEGIN
DELETE FROM qa_chart_control
WHERE chart_id = p_chart_id;
END delete_data;
PROCEDURE delete_data_autonomous(p_chart_id NUMBER) IS
--
-- This is a wrapper to delete_data and performs
-- autonomous commit.
--
PRAGMA autonomous_transaction;
delete_data(p_chart_id);
END delete_data_autonomous;