eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.CS_KNOWLEDGE_AUDIT_PVT dependencies on CS_KB_SET_ELES

Line 25: FROM CS_KB_SET_ELES se,

21: WHERE element_number = p_element_number;
22:
23: CURSOR cur_set(c_element_id IN NUMBER) IS
24: SELECT DISTINCT s.set_number
25: FROM CS_KB_SET_ELES se,
26: CS_KB_SETS_B s
27: WHERE se.element_id = c_element_id
28: AND se.set_id = s.set_id;
29:

Line 37: FROM CS_KB_SET_ELES se,

33: IF p_set_number IS NULL THEN
34:
35: SELECT COUNT(se.set_id)
36: INTO l_count
37: FROM CS_KB_SET_ELES se,
38: CS_KB_ELEMENTS_B e
39: WHERE e.element_number = p_element_number
40: AND se.element_id = e.element_id;
41:

Line 108: CS_KB_SET_ELES se

104:
105: SELECT count(*)
106: INTO l_count
107: FROM CS_KB_ELEMENTS_B e,
108: CS_KB_SET_ELES se
109: WHERE se.set_id = p_set_id
110: AND se.element_id = e.element_id
111: AND e.element_type_id = rec.element_type_id;
112:

Line 225: FROM CS_KB_SET_ELES

221: l_login NUMBER;
222:
223: CURSOR cur_eles( c_sid IN NUMBER) IS
224: SELECT element_id
225: FROM CS_KB_SET_ELES
226: WHERE set_id = c_sid;
227:
228: CURSOR cur_set IS
229: SELECT set_type_id

Line 243: DELETE FROM CS_KB_SET_ELES

239: GOTO ERROR_FOUND;
240: END IF;
241:
242: --delete a row IN set_eles_audit
243: DELETE FROM CS_KB_SET_ELES
244: WHERE element_id = p_element_id
245: AND set_id = p_set_id;
246:
247: -- change UPDATE DATE of set_audit

Line 310: FROM CS_KB_SET_ELES se, CS_KB_ELEMENTS_B eb

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
311: WHERE se.set_id = p_set_id
312: AND se.element_id = eb.element_id
313: AND eb.element_number = p_element_number;
314: IF(l_count>0) THEN

Line 341: FROM CS_KB_SET_ELES

337: -- prepare data to insert
338: Get_Who(l_date, l_created_by, l_login);
339:
340: SELECT MAX(element_order) INTO l_order
341: FROM CS_KB_SET_ELES
342: WHERE set_id = p_set_id;
343:
344: -- order IS important, need to consider l_order may be NULL
345: IF( l_order > 0) THEN

Line 352: INSERT INTO CS_KB_SET_ELES (

348: l_order :=1;
349: END IF;
350:
351: -- insert INTO set_ele
352: INSERT INTO CS_KB_SET_ELES (
353: set_id, element_id, element_order, assoc_degree,
354: creation_date, created_by,
355: last_update_date, last_updated_by, last_update_login)
356: VALUES(

Line 481: FROM CS_KB_SET_ELES se, CS_KB_ELEMENTS_B el

477: ORDER BY t.element_type_order;
478:
479: CURSOR cur_eles(ele_type_id IN NUMBER) IS
480: SELECT se.set_id, se.element_id
481: FROM CS_KB_SET_ELES se, CS_KB_ELEMENTS_B el
482: WHERE se.set_id = CS_KB_SOLUTION_PVT.Get_Latest_Version_Id(p_set_number)
483: AND se.element_id = el.element_id
484: AND el.element_type_id = ele_type_id
485: ORDER BY se.element_order;

Line 497: UPDATE CS_KB_SET_ELES

493: FOR rec_i IN cur_eles(rec_o.element_type_id) LOOP
494:
495: l_counter := l_counter + 1;
496:
497: UPDATE CS_KB_SET_ELES
498: SET element_order = l_counter
499: WHERE element_id = rec_i.element_id
500: AND set_id = rec_i.set_id;
501:

Line 536: SELECT B.element_id from cs_kb_set_eles A, cs_kb_elements_b B, cs_kb_elements_tl C

532:
533: CURSOR get_elem_info(c_set_id IN NUMBER)
534: IS
535:
536: SELECT B.element_id from cs_kb_set_eles A, cs_kb_elements_b B, cs_kb_elements_tl C
537: WHERE A.set_id = c_set_id
538: AND B.element_id = A.element_id
539: AND B.element_id = C.element_id
540: AND B.status = 'DRAFT'

Line 643: SELECT element_id from cs_kb_set_eles

639:
640: CURSOR get_elem_info(c_set_id IN NUMBER)
641: IS
642:
643: SELECT element_id from cs_kb_set_eles
644:
645: WHERE set_id = c_set_id;
646:
647:

Line 652: SELECT DISTINCT element_id from cs_kb_set_eles

648:
649: CURSOR get_elem_details(c_set_number IN VARCHAR2, c_set_id IN NUMBER)
650: IS
651:
652: SELECT DISTINCT element_id from cs_kb_set_eles
653:
654: WHERE set_id in
655: (select set_id from cs_kb_sets_b where set_number = c_set_number
656: and set_id < c_set_id);

Line 724: FROM CS_KB_SET_ELES se

720: RETURN NUMBER IS
721:
722: CURSOR Get_solns IS
723: SELECT count(se.Set_id)
724: FROM CS_KB_SET_ELES se
725: WHERE se.ELEMENT_ID = p_element_id
726: AND EXISTS (Select 'x'
727: From CS_KB_SETS_B s
728: WHERE s.Set_id = se.set_id

Line 763: SELECT element_id from cs_kb_set_eles

759:
760: CURSOR get_elem_info(c_set_id IN NUMBER)
761: IS
762:
763: SELECT element_id from cs_kb_set_eles
764:
765: WHERE set_id = c_set_id;
766:
767:

Line 862: SELECT description from cs_kb_elements_tl, cs_kb_set_eles

858: l_clob_loc CLOB;
859: l_temp_clob_loc CLOB;
860:
861: CURSOR C1(c_set_id IN NUMBER) IS
862: SELECT description from cs_kb_elements_tl, cs_kb_set_eles
863: where cs_kb_set_eles.set_id = c_set_id
864: AND cs_kb_set_eles.element_id = cs_kb_elements_tl.element_id
865: and cs_kb_elements_tl.language = USERENV('LANG');
866:

Line 863: where cs_kb_set_eles.set_id = c_set_id

859: l_temp_clob_loc CLOB;
860:
861: CURSOR C1(c_set_id IN NUMBER) IS
862: SELECT description from cs_kb_elements_tl, cs_kb_set_eles
863: where cs_kb_set_eles.set_id = c_set_id
864: AND cs_kb_set_eles.element_id = cs_kb_elements_tl.element_id
865: and cs_kb_elements_tl.language = USERENV('LANG');
866:
867: BEGIN

Line 864: AND cs_kb_set_eles.element_id = cs_kb_elements_tl.element_id

860:
861: CURSOR C1(c_set_id IN NUMBER) IS
862: SELECT description from cs_kb_elements_tl, cs_kb_set_eles
863: where cs_kb_set_eles.set_id = c_set_id
864: AND cs_kb_set_eles.element_id = cs_kb_elements_tl.element_id
865: and cs_kb_elements_tl.language = USERENV('LANG');
866:
867: BEGIN
868: dbms_lob.CREATETEMPORARY(l_clob_loc, TRUE, DBMS_LOB.session);

Line 1681: from cs_kb_set_eles

1677: counter number := 1;
1678:
1679: cursor element_ids_cur (p_set_id IN NUMBER) IS
1680: select element_id
1681: from cs_kb_set_eles
1682: where set_id = p_set_id;
1683:
1684: cursor product_ids_cur (p_set_id IN NUMBER) IS
1685: select product_id, product_org_id

Line 3963: from cs_kb_elements_b a , cs_kb_elements_tl b, cs_kb_set_eles c,

3959: -- Fetch info for all statements for a solution
3960: CURSOR get_element_info(c_set_id IN NUMBER) IS
3961: select a.element_number, d.name, e.meaning,
3962: NVL(a.content_type, 'TEXT/HTML'), b.name, b.description, a.status
3963: from cs_kb_elements_b a , cs_kb_elements_tl b, cs_kb_set_eles c,
3964: cs_kb_element_types_vl d, cs_lookups e
3965: where a.element_id = c.element_id and c.set_id = c_set_id
3966: and a.element_id = b.element_id and b.language = userenv('LANG')
3967: and a.element_type_id = d.element_type_id

Line 4091: CS_KB_SET_ELES se

4087: , '''','&'||'apos;')
4088: , '"' ,'&'||'quot;') stmt
4089: FROM CS_KB_ELEMENTS_TL et,
4090: CS_KB_ELEMENTS_B eb,
4091: CS_KB_SET_ELES se
4092: WHERE et.language = userenv('LANG')
4093: AND eb.Element_Id = et.Element_Id
4094: AND eb.element_id = se.element_id
4095: AND se.set_id = v_set_id;