APPS.CS_KNOWLEDGE_AUDIT_PVT dependencies on CS_KB_SOLUTION_PVT

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

472: CURSOR cur_ele_types IS
473: SELECT t.element_type_id
474: FROM CS_KB_SET_ELE_TYPES t, CS_KB_SETS_B s
475: WHERE t.set_type_id = s.set_type_id
476: AND s.set_id = CS_KB_SOLUTION_PVT.Get_Latest_Version_Id(p_set_number)
477: ORDER BY t.element_type_order;
478:
479: CURSOR cur_eles(ele_type_id IN NUMBER) IS
480: SELECT se.set_id, se.element_id

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

478:
479: CURSOR cur_eles(ele_type_id IN NUMBER) IS
480: SELECT se.set_id, se.element_id
481: FROM CS_KB_SET_ELES se, CS_KB_ELEMENTS_B el
482: WHERE se.set_id = CS_KB_SOLUTION_PVT.Get_Latest_Version_Id(p_set_number)
483: AND se.element_id = el.element_id
484: AND el.element_type_id = ele_type_id
485: ORDER BY se.element_order;
486:

Line 1480: CS_KB_SOLUTION_PVT.Create_Solution

1476: RAISE VALIDATION_ERROR;
1477: END IF;
1478:
1479: -- Start Creation at this point
1480: CS_KB_SOLUTION_PVT.Create_Solution
1481: ( p_set_type_id => l_set_type_id,
1482: p_name => p_set_title,
1483: p_visibility_id => l_set_visibility_id,
1484: x_set_id => l_set_id,

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

1522:
1523: -- update set with flow info and status.
1524: IF (l_flow_details_id IS NOT NULL) THEN
1525: if( Get_Missing_Ele_Type( l_set_id ) = 'N' ) then
1526: --l_set_id := CS_KB_SOLUTION_PVT.clone_solution(x_set_number,
1527: -- 'PUB', l_flow_details_id, null);
1528: null ;
1529: --bug fix 6034639 commented the above code.
1530: else

Line 1791: CS_KB_SOLUTION_PVT.Update_Solution

1787:
1788: -- dbms_output.put_line('done all validations.');
1789:
1790: -- update set
1791: CS_KB_SOLUTION_PVT.Update_Solution
1792: ( p_set_id => x_set_id,
1793: p_set_number => p_set_number,
1794: p_set_type_id => l_set_type_id,
1795: p_name => p_set_title,

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

4465: THEN RAISE INVALID_FLOW;
4466: END IF;
4467: END IF;
4468: IF (l_flow_details_id IS NOT NULL) THEN
4469: l_set_id := CS_KB_SOLUTION_PVT.clone_solution(p_set_number,
4470: 'PUB',
4471: l_flow_details_id,
4472: null);
4473: END IF;