APPS.QA_MQA_RESULTS SQL Statements

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

Line: 164

        qa_results_pub.insert_row(
            p_api_version => 1.0,
            p_org_id => x_org_id,
            p_plan_id => x_plan_id,
            p_spec_id => y_spec_id,
            p_transaction_number => null,
            p_transaction_id => null,
            p_enabled_flag => x_enabled,
            p_commit => y_committed,
            x_collection_id => y_collection_id,
            x_occurrence => x_occurrence,
            x_row_elements => elements,
            x_msg_count => msg_count,
            x_msg_data  => msg_data,
            x_error_array => error_array,
            x_message_array => message_array,
            x_return_status => return_status,
            x_action_result => action_result,
            p_txn_header_id => p_txn_header_id);

Line: 250

    PROCEDURE delete_result(
        x_plan_id IN NUMBER,
        x_collection_id IN NUMBER,
        x_occurrence IN NUMBER) IS
    BEGIN
        qa_ss_results.delete_result(
            x_plan_id => x_plan_id,
            x_collection_id => x_collection_id,
            x_occurrence => x_occurrence);

Line: 259

    END delete_result;

Line: 265

    PROCEDURE delete_results(
        x_plan_id IN NUMBER,
        x_collection_id IN NUMBER,
        x_occurrences IN VARCHAR2) IS

    BEGIN
        qa_ss_results.delete_results(
            x_plan_id => x_plan_id,
            x_collection_id => x_collection_id,
            x_occurrences => x_occurrences);

Line: 275

    END delete_results;