APPS.CS_KNOWLEDGE_PVT dependencies on CS_KB_SET_ELES

Line 411: ' select set_id, count(*) count from cs_kb_set_eles c '||

407: l_sid number(15);
408: l_total pls_integer :=0;
409: l_count pls_integer := 0;
410: l_sqlstr1 varchar2(100) :=
411: ' select set_id, count(*) count from cs_kb_set_eles c '||
412: ' where element_id in (';
413: l_eids varchar2(1000);
414: l_sqlstr2 varchar2(100) := ') group by set_id ';
415: l_bind_ids varchar2(1000) := null;

Line 1013: from cs_kb_set_eles

1009: end if;
1010:
1011: -- new ele and old ele cannot be in same set
1012: select count(*) into l_count
1013: from cs_kb_set_eles
1014: where set_id = p_set_id_tbl(i1)
1015: and element_id = l_element_id;
1016: if(l_count>0) then
1017: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then

Line 1045: --update cs_kb_set_eles set

1041: end if;
1042:
1043:
1044: -- update
1045: --update cs_kb_set_eles set
1046: -- element_id = l_element_id
1047: -- where set_id = p_set_id_tbl(i1);
1048: else
1049: l_retnum := CS_Knowledge_Pvt.Del_Element_From_Set(

Line 1238: from cs_kb_set_eles

1234: l_count pls_integer;
1235:
1236: cursor cur_eles( c_sid in number) is
1237: select element_id
1238: from cs_kb_set_eles
1239: where set_id = c_sid;
1240:
1241: cursor cur_set is
1242: select s.set_type_id

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 1295: delete from cs_kb_set_eles

1291: end if;
1292: end if;
1293:
1294: --delete a row in set_eles
1295: delete from cs_kb_set_eles
1296: where element_id = p_ele_id
1297: and set_id = p_set_id;
1298:
1299: -- change update date of set

Line 1343: from cs_kb_set_eles

1339: l_login number;
1340: l_order number(15);
1341: cursor cur_eles( c_sid in number) is
1342: select element_id
1343: from cs_kb_set_eles
1344: where set_id = c_sid; /* can add: and element_id <> p_ele_id */
1345: begin
1346:
1347: -- Check params

Line 1364: from cs_kb_set_eles

1360: end if;
1361:
1362: -- check if row already exists
1363: select count(*) into l_count
1364: from cs_kb_set_eles
1365: where set_id = p_set_id
1366: and element_id = p_ele_id;
1367: if(l_count>0) then
1368: fnd_message.set_name('CS', 'CS_KB_C_ELE_EXIST_ERR');

Line 1385: from cs_kb_set_eles

1381: -- prepare data to insert
1382: Get_Who(l_date, l_created_by, l_login);
1383:
1384: select max(element_order) into l_order
1385: from cs_kb_set_eles
1386: where set_id = p_set_id;
1387: if( not l_order > 0) then
1388: l_order :=1;
1389: else

Line 1395: insert into cs_kb_set_eles (

1391: end if;
1392:
1393:
1394: -- insert into set_ele
1395: insert into cs_kb_set_eles (
1396: set_id, element_id, element_order, assoc_degree,
1397: creation_date, created_by,
1398: last_update_date, last_updated_by, last_update_login)
1399: values(

Line 2144: FROM CS_KB_SET_ELES

2140:
2141: CURSOR Check_Dup_Ele_Insert (v_set_id NUMBER,
2142: v_ele_id NUMBER ) IS
2143: SELECT count(*)
2144: FROM CS_KB_SET_ELES
2145: WHERE set_id = v_set_id
2146: AND element_id = v_ele_id;
2147:
2148: l_set_ele_count NUMBER;

Line 2305: insert into cs_kb_set_eles (

2301: CLOSE Check_Dup_Ele_Insert;
2302:
2303: IF l_set_ele_count = 0 THEN
2304:
2305: insert into cs_kb_set_eles (
2306: set_id, element_id, element_order, assoc_degree,
2307: creation_date, created_by,
2308: last_update_date, last_updated_by, last_update_login)
2309: values(