APPS.QA_CHART_HEADERS_PKG SQL Statements

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

Line: 24

        INSERT INTO qa_chart_headers(
            created_by,
            creation_date,
            last_updated_by,
            last_update_date,
            last_update_login,
            chart_id,
            criteria_id,
            title,
            description,
            x_label,
            y_label)
        VALUES(
            fnd_global.user_id,
            sysdate,
            fnd_global.user_id,
            sysdate,
            fnd_global.login_id,
            qa_chart_headers_s.nextval,
            p_criteria_id,
            p_title,
            p_description,
            p_x_label,
            p_y_label)
        RETURNING
            chart_id
        INTO
            x_chart_id;

Line: 56

    PROCEDURE delete_chart(p_chart_id NUMBER) IS
    --
    -- This procedure deletes a chart (header and detail
    -- data points will be deleted together).
    --
    -- bso Mon Jan  9 15:24:20 PST 2006
    --

        l_criteria_id NUMBER;

Line: 73

        DELETE
        FROM        qa_chart_headers
        WHERE       chart_id = p_chart_id
        RETURNING   criteria_id
        INTO        l_criteria_id;

Line: 92

            SELECT output_type
            INTO   l_output_type
            FROM   qa_criteria_headers
            WHERE  criteria_id = l_criteria_id;

Line: 109

            qa_chart_histogram_pkg.delete_data(p_chart_id);

Line: 112

            qa_chart_pareto_pkg.delete_data(p_chart_id);

Line: 115

            qa_chart_trend_pkg.delete_data(p_chart_id);

Line: 118

            qa_chart_control_pkg.delete_data(p_chart_id);

Line: 130

            qa_chart_generic_pkg.delete_data(p_chart_id);

Line: 131

            qa_chart_control_pkg.delete_data(p_chart_id);

Line: 135

    END delete_chart;

Line: 160

    PROCEDURE delete_chart_autonomous(p_chart_id NUMBER) IS
    PRAGMA autonomous_transaction;

Line: 163

        delete_chart(p_chart_id);

Line: 165

    END delete_chart_autonomous;

Line: 170

        UPDATE qa_chart_headers
        SET    x_label = p_label
        WHERE  chart_id = p_chart_id;

Line: 178

        UPDATE qa_chart_headers
        SET    y_label = p_label
        WHERE  chart_id = p_chart_id;