APPS.QA_CHAR_INDEXES_PKG SQL Statements

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

Line: 30

        SELECT enabled_flag
        FROM   qa_char_indexes
        WHERE  char_id = p_char_id;

Line: 98

            SELECT default_result_column
            FROM   qa_char_indexes
            WHERE  char_id = p_char_id AND enabled_flag = 1;

Line: 124

        UPDATE qa_char_indexes
        SET enabled_flag = 2
        WHERE char_id = p_char_id;

Line: 198

            SELECT qpc.result_column_name
            FROM   qa_plan_chars qpc, qa_plans qp
            WHERE  qpc.plan_id = qp.plan_id AND
                   qpc.char_id = p_char_id AND
                   qp.organization_id <> 0
            GROUP BY result_column_name
            ORDER BY count(result_column_name) desc;

Line: 216

            SELECT qpc.plan_id, qpc.result_column_name
            FROM   qa_plan_chars qpc, qa_plans qp
            WHERE  qpc.plan_id = qp.plan_id AND
                   qpc.char_id = p_char_id AND
                   qp.organization_id <> 0 AND
                   qpc.result_column_name <> p_col;

Line: 228

            SELECT qpc.plan_id, qpc.result_column_name
            FROM   qa_plan_chars qpc, qa_plans qp
            WHERE  qpc.plan_id = qp.plan_id AND
                   qpc.char_id = p_char_id AND
                   qp.organization_id <> 0;

Line: 501

        insert_row(
            x_rowid                     => l_rowid,
            p_created_by                => who_user_id,
            p_creation_date             => sysdate,
            p_last_updated_by           => who_user_id,
            p_last_update_date          => sysdate,
            p_last_update_login         => who_user_id,
            p_request_id                => who_request_id,
            p_program_application_id    => who_program_application_id,
            p_program_id                => who_program_id,
            p_program_update_date       => sysdate,
            p_char_id                   => p_char_id,
            p_enabled_flag              => 1,
            p_index_name                => p_index_name,
            p_default_result_column     => l_most_common,
            p_text                      => l_ddl,
            p_additional_parameters     => p_additional_parameters);

Line: 571

    PROCEDURE insert_row(
        x_rowid                     OUT NOCOPY VARCHAR2,
        p_created_by                NUMBER,
        p_creation_date             DATE,
        p_last_updated_by           NUMBER,
        p_last_update_date          DATE,
        p_last_update_login         NUMBER,
        p_request_id                NUMBER,
        p_program_application_id    NUMBER,
        p_program_id                NUMBER,
        p_program_update_date       DATE,
        p_char_id                   NUMBER,
        p_enabled_flag              NUMBER,
        p_index_name                VARCHAR2,
        p_default_result_column     VARCHAR2,
        p_text                      VARCHAR2,
        p_additional_parameters     VARCHAR2) IS

        CURSOR c IS
             SELECT rowid
             FROM   qa_char_indexes
             WHERE  char_id = p_char_id;

Line: 595

        INSERT INTO qa_char_indexes(
            created_by,
            creation_date,
            last_updated_by,
            last_update_date,
            last_update_login,
            request_id,
            program_application_id,
            program_id,
            program_update_date,
            char_id,
            enabled_flag,
            index_name,
            default_result_column,
            text,
            additional_parameters)
        VALUES(
            p_created_by,
            p_creation_date,
            p_last_updated_by,
            p_last_update_date,
            p_last_update_login,
            p_request_id,
            p_program_application_id,
            p_program_id,
            p_program_update_date,
            p_char_id,
            p_enabled_flag,
            p_index_name,
            p_default_result_column,
            p_text,
            p_additional_parameters);

Line: 636

    END insert_row;

Line: 639

    PROCEDURE delete_row(p_char_id NUMBER) IS
    --
    -- The delete_row handler differs from the normal standard
    -- a little because this procedure is not designed to be used
    -- by Forms, so it is more efficient to pass in the primary key
    -- than to pass in the rowid.
    -- bso
    --
    BEGIN

        DELETE
        FROM  qa_char_indexes
        WHERE char_id = p_char_id;

Line: 657

    END delete_row;

Line: 675

            SELECT index_name
            FROM   qa_char_indexes
            WHERE  char_id = p_char_id;

Line: 680

        SELECT index_name from all_indexes
            WHERE TABLE_NAME = 'QA_RESULTS'
              AND INDEX_NAME = 'QA_'|| p_char_id || '_INT'
              AND OWNER      = g_qa;

Line: 702

            delete_row(p_char_id);

Line: 706

                    RETURN err_delete_row;

Line: 811

                RETURN err_insert_row;

Line: 830

            SELECT dbms_lob.substr(text, dbms_lob.getlength(text), 1)
            FROM   qa_char_indexes
            WHERE  char_id = p_char_id AND enabled_flag = 1;