APPS.QA_CHART_HISTOGRAM_PKG SQL Statements

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

Line: 39

            INSERT INTO qa_chart_generic(
                created_by,
                creation_date,
                last_updated_by,
                last_update_date,
                last_update_login,
                chart_id,
                line,
                x_value,
                y_value)
            SELECT
                /* Small amount of data from one session only. */
                /* FTS expected and reviewed by bso 1/11/2006. */
                fnd_global.user_id,
                sysdate,
                fnd_global.user_id,
                sysdate,
                fnd_global.login_id,
                p_chart_id,
                bar_number,
                hist_range,
                num_occurrences
            FROM
                qa_chart_data;

Line: 163

        UPDATE qa_chart_headers
        SET    last_update_date = sysdate,
               upper_spec_limit = p_usl,
               lower_spec_limit = p_lsl,
               target_value = p_target_value,
               cp = x_cp,
               cpk = x_cpk,
               uom_code = (
                   SELECT uom_code
                   FROM   qa_spec_chars
                   WHERE  spec_id = p_spec_id AND
                          char_id = p_element_id)
        WHERE  chart_id = x_chart_id;

Line: 179

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

Line: 235

    PROCEDURE delete_data(p_chart_id NUMBER) IS
    --
    -- This is a simple wrapper to qa_chart_generic_pkg
    -- since Histogram uses generic charting architecture.
    --
    BEGIN
        qa_chart_generic_pkg.delete_data(p_chart_id);

Line: 242

    END delete_data;

Line: 245

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

Line: 252

        delete_data(p_chart_id);

Line: 254

    END delete_data_autonomous;