APPS.CSK_DIAG_SOLUTION_PVT dependencies on CS_KB_SET_CATEGORIES

Line 243: from cs_kb_set_categories

239: IF l_success = 'Y' THEN
240: JTF_DIAGNOSTIC_COREAPI.line_out('
' ||'SUCCESS: [ 10] moveSolutions() execution ');
241: --Step 20
242: select count(1) into l_count_1
243: from cs_kb_set_categories
244: where set_id = g_move_solutions_test_s1_aID and category_id = g_move_solutions_test_c2ID;
245: select count(1) into l_count_2
246: from cs_kb_set_categories
247: where set_id = g_move_solutions_test_s1_bID and category_id = g_move_solutions_test_c2ID;

Line 246: from cs_kb_set_categories

242: select count(1) into l_count_1
243: from cs_kb_set_categories
244: where set_id = g_move_solutions_test_s1_aID and category_id = g_move_solutions_test_c2ID;
245: select count(1) into l_count_2
246: from cs_kb_set_categories
247: where set_id = g_move_solutions_test_s1_bID and category_id = g_move_solutions_test_c2ID;
248: if l_count_1 = 1 and l_count_2 = 1 then
249: JTF_DIAGNOSTIC_COREAPI.line_out('
' ||'SUCCESS: [ 20] solutions have been moved into c2');
250: --step 30

Line 252: from cs_kb_set_categories

248: if l_count_1 = 1 and l_count_2 = 1 then
249: JTF_DIAGNOSTIC_COREAPI.line_out('
' ||'SUCCESS: [ 20] solutions have been moved into c2');
250: --step 30
251: select count(1) into l_count_1
252: from cs_kb_set_categories
253: where set_id = g_move_solutions_test_s1_aID and category_id = g_move_solutions_test_c1ID;
254: select count(1) into l_count_2
255: from cs_kb_set_categories
256: where set_id = g_move_solutions_test_s1_bID and category_id = g_move_solutions_test_c1ID;

Line 255: from cs_kb_set_categories

251: select count(1) into l_count_1
252: from cs_kb_set_categories
253: where set_id = g_move_solutions_test_s1_aID and category_id = g_move_solutions_test_c1ID;
254: select count(1) into l_count_2
255: from cs_kb_set_categories
256: where set_id = g_move_solutions_test_s1_bID and category_id = g_move_solutions_test_c1ID;
257: if l_count_1 = 0 and l_count_2 = 0 then
258: JTF_DIAGNOSTIC_COREAPI.line_out('
' ||'SUCCESS: [ 30] solutions have been moved out of c1');
259: --step 40