APPS.QA_CHART_GENERIC_PKG SQL Statements

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

Line: 94

            l_sql := 'SELECT * FROM (' || p_sql ||
                     ') WHERE rownum <= :1';

Line: 116

                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)
                VALUES (
                    fnd_global.user_id,  -- created_by
                    sysdate,             -- creation_date
                    fnd_global.user_id,  -- last_updated_by
                    sysdate,             -- last_update_date
                    fnd_global.login_id, -- last_update_login
                    p_chart_id,          -- chart_id
                    l_line_values(i),    -- line
                    l_x_values(i),       -- x_value
                    l_y_values(i));      -- y_value

Line: 161

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

Line: 165

    END delete_data;

Line: 168

    PROCEDURE delete_data_autonomous(p_chart_id NUMBER) IS
    PRAGMA autonomous_transaction;

Line: 171

        delete_data(p_chart_id);

Line: 173

    END delete_data_autonomous;