APPS.CSK_DIAG_SOLUTION_PVT SQL Statements

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

Line: 104

    CSK_SETUP_UTILITY_PKG.delete_solution(
        p_api_version        => 1.0,
        x_return_status      => l_return_status,
        x_msg_count          => l_msg_count,
        x_msg_data           => l_msg_data,
        P_set_ID        => g_move_solutions_test_s1_aID);

Line: 110

    CSK_SETUP_UTILITY_PKG.delete_solution(
        p_api_version        => 1.0,
        x_return_status      => l_return_status,
        x_msg_count          => l_msg_count,
        x_msg_data           => l_msg_data,
        P_set_ID        => g_move_solutions_test_s1_bID);

Line: 116

    CSK_SETUP_UTILITY_PKG.Delete_Category (
        p_api_version        => 1.0,
        x_return_status      => l_return_status,
        x_msg_count          => l_msg_count,
        x_msg_data           => l_msg_data,
        P_CATEGORY_ID        => g_move_solutions_test_c1ID);

Line: 122

    CSK_SETUP_UTILITY_PKG.Delete_Category (
        p_api_version        => 1.0,
        x_return_status      => l_return_status,
        x_msg_count          => l_msg_count,
        x_msg_data           => l_msg_data,
        P_CATEGORY_ID        => g_move_solutions_test_c2ID);

Line: 189

 sqltxt := ' select fnd_global.user_id, fnd_global.USER_NAME '||
           ' , fnd_global.APPLICATION_SHORT_NAME '||
           ' , fnd_global.APPLICATION_NAME '||
           ' , fnd_global.RESP_NAME '||
           ' from dual ';

Line: 242

        select count(1) into l_count_1
        from cs_kb_set_categories
        where set_id = g_move_solutions_test_s1_aID and category_id = g_move_solutions_test_c2ID;

Line: 245

        select count(1) into l_count_2
        from cs_kb_set_categories
        where set_id = g_move_solutions_test_s1_bID and category_id = g_move_solutions_test_c2ID;

Line: 251

            select count(1) into l_count_1
            from cs_kb_set_categories
            where set_id = g_move_solutions_test_s1_aID and category_id = g_move_solutions_test_c1ID;

Line: 254

            select count(1) into l_count_2
            from cs_kb_set_categories
            where set_id = g_move_solutions_test_s1_bID and category_id = g_move_solutions_test_c1ID;

Line: 261

                select INSTR(l_index_content,'') into l_end_tag from dual;

Line: 263

                    select INSTR(l_index_content,'') into l_start_tag from dual;

Line: 265

                    select INSTR(l_categories_section,'a'||g_move_solutions_test_c2ID||'a') into l_count from dual;

Line: 267

                        JTF_DIAGNOSTIC_COREAPI.line_out('
' ||'SUCCESS: [ 40] text index of child solution updated. ');

Line: 270

                        JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('
' ||'FAILED : [ 40] text index of child solution updated. ');

Line: 272

                        l_errStr := l_errStr||'
 text index of child solution was not updated correctly';

Line: 320

 JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;