APPS.CS_KNOWLEDGE_PVT dependencies on CS_KB_ELEMENTS_B

Line 159: from cs_kb_elements_b

155: while i1 is not null loop
156:
157: if(p_ele_def_tbl(i1).element_id is not null) then
158: select element_type_id into l_type_id
159: from cs_kb_elements_b
160: where element_id = p_ele_def_tbl(i1).element_id;
161: if(l_types_tbl(i2)=l_type_id) then
162: l_count := 1;
163: end if;

Line 281: cs_kb_elements_b e

277: if(p_ele_id > 0) then
278: select count(*) into l_count
279: from cs_kb_set_ele_types se,
280: cs_kb_sets_b s,
281: cs_kb_elements_b e
282: where se.set_type_id = s.set_type_id
283: and se.element_type_id = e.element_type_id
284: and s.set_id = p_set_id
285: and e.element_id = p_ele_id;

Line 300: cs_kb_elements_b e

296: elsif(p_set_type_id >0) then
297: if(p_ele_id >0) then
298: select count(*) into l_count
299: from cs_kb_set_ele_types se,
300: cs_kb_elements_b e
301: where se.set_type_id = p_set_type_id
302: and e.element_id = p_ele_id
303: and se.element_type_id = e.element_type_id;
304:

Line 999: from cs_kb_elements_b

995: if(l_element_id is not null and l_element_id>0) then
996:
997: --valid new element id
998: select count(*) into l_count
999: from cs_kb_elements_b
1000: where element_id = l_element_id;
1001: if(l_count<1) then
1002: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1003: fnd_message.set_name('CS', 'CS_KB_C_INVALID_ELE_ID');

Line 1158: from cs_kb_elements_b

1154: if( p_link_id_tbl(i1) is not null) then
1155: if(l_element_id is not null and l_element_id>0) then
1156:
1157: select count(*) into l_count
1158: from cs_kb_elements_b
1159: where element_id = l_element_id;
1160: if(l_count<1) then
1161: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1162: fnd_message.set_name('CS', 'CS_KB_C_INVALID_ELE_ID');

Line 1256: from cs_kb_elements_b

1252:
1253: --if ele is the only required type in set, cannot delete
1254:
1255: select element_type_id into l_ele_type_id
1256: from cs_kb_elements_b
1257: where element_id = p_ele_id;
1258:
1259: open cur_set;
1260: fetch cur_set into l_set_rec;

Line 1282: from cs_kb_set_eles se, cs_kb_elements_b e

1278:
1279:
1280: if(l_optional_flag = 'N') then
1281: select count(*) into l_count
1282: from cs_kb_set_eles se, cs_kb_elements_b e
1283: where se.set_id = p_set_id
1284: and se.element_id = e.element_id
1285: and e.element_type_id = l_ele_type_id;
1286: if(l_count <=1) then

Line 1352: from cs_kb_elements_b

1348: end if;
1349:
1350: -- check if element exists
1351: select count(*) into l_count
1352: from cs_kb_elements_b
1353: where element_id = p_ele_id;
1354: if(l_count=0) then
1355: fnd_message.set_name('CS', 'CS_KB_C_INVALID_ELE_ID');
1356: goto error_found;

Line 1797: FROM CS_KB_ELEMENTS_B

1793:
1794:
1795: CURSOR Check_Element (v_ele_id NUMBER) IS
1796: SELECT count(*)
1797: FROM CS_KB_ELEMENTS_B
1798: WHERE Element_Id = v_ele_id
1799: AND status = 'PUBLISHED';
1800:
1801: l_ele_check NUMBER;