APPS.CS_KNOWLEDGE_PVT dependencies on CS_KB_SET_ELES

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

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

Line 1011: from cs_kb_set_eles

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

Line 1043: --update cs_kb_set_eles set

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

Line 1236: from cs_kb_set_eles

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

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

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

Line 1340: from cs_kb_set_eles

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

Line 1361: from cs_kb_set_eles

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

Line 1382: from cs_kb_set_eles

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

Line 1392: insert into cs_kb_set_eles (

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

Line 2140: FROM CS_KB_SET_ELES

2136:
2137: CURSOR Check_Dup_Ele_Insert (v_set_id NUMBER,
2138: v_ele_id NUMBER ) IS
2139: SELECT count(*)
2140: FROM CS_KB_SET_ELES
2141: WHERE set_id = v_set_id
2142: AND element_id = v_ele_id;
2143:
2144: l_set_ele_count NUMBER;

Line 2301: insert into cs_kb_set_eles (

2297: CLOSE Check_Dup_Ele_Insert;
2298:
2299: IF l_set_ele_count = 0 THEN
2300:
2301: insert into cs_kb_set_eles (
2302: set_id, element_id, element_order, assoc_degree,
2303: creation_date, created_by,
2304: last_update_date, last_updated_by, last_update_login)
2305: values(