APPS.CS_KNOWLEDGE_AUDIT_PVT dependencies on CS_KB_ELEMENTS_AUDIT_PKG

Line 315: l_element_id := CS_KB_ELEMENTS_AUDIT_PKG.Get_Latest_Version_Id(p_element_number);

311: FND_MESSAGE.set_name('CS', 'CS_KB_C_INVALID_ELE_ID');
312: GOTO ERROR_FOUND;
313: END IF;
314:
315: l_element_id := CS_KB_ELEMENTS_AUDIT_PKG.Get_Latest_Version_Id(p_element_number);
316:
317: -- check IF element already exists
318: SELECT count(se.element_id) INTO l_count
319: FROM CS_KB_SET_ELES se, CS_KB_ELEMENTS_B eb

Line 430: l_element_id := CS_KB_ELEMENTS_AUDIT_PKG.Create_Element(

426: l_element_id NUMBER;
427: l_element_number VARCHAR2(30);
428: l_ret NUMBER;
429: BEGIN
430: l_element_id := CS_KB_ELEMENTS_AUDIT_PKG.Create_Element(
431: p_element_type_id => p_element_type_id,
432: p_desc => p_desc,
433: p_name => p_name,
434: p_status => p_status,

Line 2429: x_created_element_ids(i) := CS_KB_ELEMENTS_AUDIT_PKG.Create_Element_CLOB(

2425: -- Creating new elements
2426: x_created_element_ids := JTF_NUMBER_TABLE();
2427: x_created_element_ids.extend(p_element_type_ids.count);
2428: for i in 1..p_element_type_ids.count loop
2429: x_created_element_ids(i) := CS_KB_ELEMENTS_AUDIT_PKG.Create_Element_CLOB(
2430: p_element_type_id => p_element_type_ids(i),
2431: p_name => p_element_summaries(i),
2432: p_desc => p_element_dummy_detail,
2433: p_status => l_elmt_status,

Line 2448: l_temp_element_no := cs_kb_elements_audit_pkg.Get_Element_Number(

2444: end loop;
2445:
2446: -- link The Created element ids to set id;
2447: for i in 1..x_created_element_ids.count loop
2448: l_temp_element_no := cs_kb_elements_audit_pkg.Get_Element_Number(
2449: x_created_element_ids(i));
2450:
2451: l_return_val := cs_knowledge_audit_pvt.Add_Element_To_Set(
2452: p_element_number => l_temp_element_no,

Line 2462: l_temp_element_no := cs_kb_elements_audit_pkg.Get_Element_Number(

2458: end loop;
2459:
2460: -- link The provided element ids to set id;
2461: for i in 1..p_element_ids.count loop
2462: l_temp_element_no := cs_kb_elements_audit_pkg.Get_Element_Number(
2463: p_element_ids(i));
2464: l_return_val := cs_knowledge_audit_pvt.Add_Element_To_Set(
2465: p_element_number => l_temp_element_no,
2466: p_set_id => p_set_id);

Line 2475: l_temp_update_return := CS_KB_ELEMENTS_AUDIT_PKG.Update_Element_CLOB(

2471: end loop;
2472:
2473: -- global updating given elements
2474: for i in 1..p_given_ele_type_ids.count loop
2475: l_temp_update_return := CS_KB_ELEMENTS_AUDIT_PKG.Update_Element_CLOB(
2476: p_element_id => p_given_element_ids(i),
2477: p_element_number => p_given_ele_nums(i),
2478: p_element_type_id => p_given_ele_type_ids(i),
2479: p_name => p_given_ele_summaryies(i),