APPS.CS_KNOWLEDGE_PVT dependencies on CS_KB_ELEMENTS_B

Line 161: from cs_kb_elements_b

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

Line 283: cs_kb_elements_b e

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

Line 302: cs_kb_elements_b e

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

Line 1001: from cs_kb_elements_b

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

Line 1160: from cs_kb_elements_b

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

Line 1258: from cs_kb_elements_b

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

Line 1284: from cs_kb_set_eles se, cs_kb_elements_b e

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

Line 1355: from cs_kb_elements_b

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

Line 1801: FROM CS_KB_ELEMENTS_B

1797:
1798:
1799: CURSOR Check_Element (v_ele_id NUMBER) IS
1800: SELECT count(*)
1801: FROM CS_KB_ELEMENTS_B
1802: WHERE Element_Id = v_ele_id
1803: AND status = 'PUBLISHED';
1804:
1805: l_ele_check NUMBER;