APPS.QA_CHART_CONTROL_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 101

            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;

Line: 248

        DELETE
            /* Small amount of data from one session only. */
            /* FTS expected and reviewed by bso 1/13/2006. */
            FROM qa_chart_data;

Line: 304

    PROCEDURE delete_data(p_chart_id NUMBER) IS
    BEGIN
        DELETE FROM qa_chart_control
        WHERE chart_id = p_chart_id;

Line: 308

    END delete_data;

Line: 311

    PROCEDURE delete_data_autonomous(p_chart_id NUMBER) IS
    --
    -- This is a wrapper to delete_data and performs
    -- autonomous commit.
    --
    PRAGMA autonomous_transaction;

Line: 318

        delete_data(p_chart_id);

Line: 320

    END delete_data_autonomous;