APPS.CS_KNOWLEDGE_AUDIT_PVT dependencies on CS_KB_SOLUTION_PVT

Line 485: AND s.set_id = CS_KB_SOLUTION_PVT.Get_Latest_Version_Id(p_set_number)

481: CURSOR cur_ele_types IS
482: SELECT t.element_type_id
483: FROM CS_KB_SET_ELE_TYPES t, CS_KB_SETS_B s
484: WHERE t.set_type_id = s.set_type_id
485: AND s.set_id = CS_KB_SOLUTION_PVT.Get_Latest_Version_Id(p_set_number)
486: ORDER BY t.element_type_order;
487:
488: CURSOR cur_eles(ele_type_id IN NUMBER) IS
489: SELECT se.set_id, se.element_id

Line 491: WHERE se.set_id = CS_KB_SOLUTION_PVT.Get_Latest_Version_Id(p_set_number)

487:
488: CURSOR cur_eles(ele_type_id IN NUMBER) IS
489: SELECT se.set_id, se.element_id
490: FROM CS_KB_SET_ELES se, CS_KB_ELEMENTS_B el
491: WHERE se.set_id = CS_KB_SOLUTION_PVT.Get_Latest_Version_Id(p_set_number)
492: AND se.element_id = el.element_id
493: AND el.element_type_id = ele_type_id
494: ORDER BY se.element_order;
495:

Line 1489: CS_KB_SOLUTION_PVT.Create_Solution

1485: RAISE VALIDATION_ERROR;
1486: END IF;
1487:
1488: -- Start Creation at this point
1489: CS_KB_SOLUTION_PVT.Create_Solution
1490: ( p_set_type_id => l_set_type_id,
1491: p_name => p_set_title,
1492: p_visibility_id => l_set_visibility_id,
1493: x_set_id => l_set_id,

Line 1535: --l_set_id := CS_KB_SOLUTION_PVT.clone_solution(x_set_number,

1531:
1532: -- update set with flow info and status.
1533: IF (l_flow_details_id IS NOT NULL) THEN
1534: if( Get_Missing_Ele_Type( l_set_id ) = 'N' ) then
1535: --l_set_id := CS_KB_SOLUTION_PVT.clone_solution(x_set_number,
1536: -- 'PUB', l_flow_details_id, null);
1537: null ;
1538: --bug fix 6034639 commented the above code.
1539: else

Line 1800: CS_KB_SOLUTION_PVT.Update_Solution

1796:
1797: -- dbms_output.put_line('done all validations.');
1798:
1799: -- update set
1800: CS_KB_SOLUTION_PVT.Update_Solution
1801: ( p_set_id => x_set_id,
1802: p_set_number => p_set_number,
1803: p_set_type_id => l_set_type_id,
1804: p_name => p_set_title,

Line 4479: l_set_id := CS_KB_SOLUTION_PVT.clone_solution(p_set_number,

4475: THEN RAISE INVALID_FLOW;
4476: END IF;
4477: END IF;
4478: IF (l_flow_details_id IS NOT NULL) THEN
4479: l_set_id := CS_KB_SOLUTION_PVT.clone_solution(p_set_number,
4480: 'PUB',
4481: l_flow_details_id,
4482: null);
4483: END IF;