APPS.CS_KNOWLEDGE_AUDIT_PVT dependencies on CS_KB_ELEMENTS_AUDIT_PKG

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

302: FND_MESSAGE.set_name('CS', 'CS_KB_C_INVALID_ELE_ID');
303: GOTO ERROR_FOUND;
304: END IF;
305:
306: l_element_id := CS_KB_ELEMENTS_AUDIT_PKG.Get_Latest_Version_Id(p_element_number);
307:
308: -- check IF element already exists
309: SELECT count(se.element_id) INTO l_count
310: FROM CS_KB_SET_ELES se, CS_KB_ELEMENTS_B eb

Line 421: l_element_id := CS_KB_ELEMENTS_AUDIT_PKG.Create_Element(

417: l_element_id NUMBER;
418: l_element_number VARCHAR2(30);
419: l_ret NUMBER;
420: BEGIN
421: l_element_id := CS_KB_ELEMENTS_AUDIT_PKG.Create_Element(
422: p_element_type_id => p_element_type_id,
423: p_desc => p_desc,
424: p_name => p_name,
425: p_status => p_status,

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

2415: -- Creating new elements
2416: x_created_element_ids := JTF_NUMBER_TABLE();
2417: x_created_element_ids.extend(p_element_type_ids.count);
2418: for i in 1..p_element_type_ids.count loop
2419: x_created_element_ids(i) := CS_KB_ELEMENTS_AUDIT_PKG.Create_Element_CLOB(
2420: p_element_type_id => p_element_type_ids(i),
2421: p_name => p_element_summaries(i),
2422: p_desc => p_element_dummy_detail,
2423: p_status => l_elmt_status,

Line 2438: l_temp_element_no := cs_kb_elements_audit_pkg.Get_Element_Number(

2434: end loop;
2435:
2436: -- link The Created element ids to set id;
2437: for i in 1..x_created_element_ids.count loop
2438: l_temp_element_no := cs_kb_elements_audit_pkg.Get_Element_Number(
2439: x_created_element_ids(i));
2440:
2441: l_return_val := cs_knowledge_audit_pvt.Add_Element_To_Set(
2442: p_element_number => l_temp_element_no,

Line 2452: l_temp_element_no := cs_kb_elements_audit_pkg.Get_Element_Number(

2448: end loop;
2449:
2450: -- link The provided element ids to set id;
2451: for i in 1..p_element_ids.count loop
2452: l_temp_element_no := cs_kb_elements_audit_pkg.Get_Element_Number(
2453: p_element_ids(i));
2454: l_return_val := cs_knowledge_audit_pvt.Add_Element_To_Set(
2455: p_element_number => l_temp_element_no,
2456: p_set_id => p_set_id);

Line 2465: l_temp_update_return := CS_KB_ELEMENTS_AUDIT_PKG.Update_Element_CLOB(

2461: end loop;
2462:
2463: -- global updating given elements
2464: for i in 1..p_given_ele_type_ids.count loop
2465: l_temp_update_return := CS_KB_ELEMENTS_AUDIT_PKG.Update_Element_CLOB(
2466: p_element_id => p_given_element_ids(i),
2467: p_element_number => p_given_ele_nums(i),
2468: p_element_type_id => p_given_ele_type_ids(i),
2469: p_name => p_given_ele_summaryies(i),