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.

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 234: FROM CS_KB_SET_ELES

230: l_login NUMBER;
231:
232: CURSOR cur_eles( c_sid IN NUMBER) IS
233: SELECT element_id
234: FROM CS_KB_SET_ELES
235: WHERE set_id = c_sid;
236:
237: CURSOR cur_set IS
238: SELECT set_type_id

Line 252: DELETE FROM CS_KB_SET_ELES

248: GOTO ERROR_FOUND;
249: END IF;
250:
251: --delete a row IN set_eles_audit
252: DELETE FROM CS_KB_SET_ELES
253: WHERE element_id = p_element_id
254: AND set_id = p_set_id;
255:
256: -- change UPDATE DATE of set_audit

Line 319: FROM CS_KB_SET_ELES se, CS_KB_ELEMENTS_B eb

315: l_element_id := CS_KB_ELEMENTS_AUDIT_PKG.Get_Latest_Version_Id(p_element_number);
316:
317: -- check IF element already exists
318: SELECT count(se.element_id) INTO l_count
319: FROM CS_KB_SET_ELES se, CS_KB_ELEMENTS_B eb
320: WHERE se.set_id = p_set_id
321: AND se.element_id = eb.element_id
322: AND eb.element_number = p_element_number;
323: IF(l_count>0) THEN

Line 350: FROM CS_KB_SET_ELES

346: -- prepare data to insert
347: Get_Who(l_date, l_created_by, l_login);
348:
349: SELECT MAX(element_order) INTO l_order
350: FROM CS_KB_SET_ELES
351: WHERE set_id = p_set_id;
352:
353: -- order IS important, need to consider l_order may be NULL
354: IF( l_order > 0) THEN

Line 361: INSERT INTO CS_KB_SET_ELES (

357: l_order :=1;
358: END IF;
359:
360: -- insert INTO set_ele
361: INSERT INTO CS_KB_SET_ELES (
362: set_id, element_id, element_order, assoc_degree,
363: creation_date, created_by,
364: last_update_date, last_updated_by, last_update_login)
365: VALUES(

Line 490: FROM CS_KB_SET_ELES se, CS_KB_ELEMENTS_B el

486: ORDER BY t.element_type_order;
487:
488: CURSOR cur_eles(ele_type_id IN NUMBER) IS
489: SELECT se.set_id, se.element_id
490: FROM CS_KB_SET_ELES se, CS_KB_ELEMENTS_B el
491: WHERE se.set_id = CS_KB_SOLUTION_PVT.Get_Latest_Version_Id(p_set_number)
492: AND se.element_id = el.element_id
493: AND el.element_type_id = ele_type_id
494: ORDER BY se.element_order;

Line 506: UPDATE CS_KB_SET_ELES

502: FOR rec_i IN cur_eles(rec_o.element_type_id) LOOP
503:
504: l_counter := l_counter + 1;
505:
506: UPDATE CS_KB_SET_ELES
507: SET element_order = l_counter
508: WHERE element_id = rec_i.element_id
509: AND set_id = rec_i.set_id;
510:

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

541:
542: CURSOR get_elem_info(c_set_id IN NUMBER)
543: IS
544:
545: SELECT B.element_id from cs_kb_set_eles A, cs_kb_elements_b B, cs_kb_elements_tl C
546: WHERE A.set_id = c_set_id
547: AND B.element_id = A.element_id
548: AND B.element_id = C.element_id
549: AND B.status = 'DRAFT'

Line 652: SELECT element_id from cs_kb_set_eles

648:
649: CURSOR get_elem_info(c_set_id IN NUMBER)
650: IS
651:
652: SELECT element_id from cs_kb_set_eles
653:
654: WHERE set_id = c_set_id;
655:
656:

Line 661: SELECT DISTINCT element_id from cs_kb_set_eles

657:
658: CURSOR get_elem_details(c_set_number IN VARCHAR2, c_set_id IN NUMBER)
659: IS
660:
661: SELECT DISTINCT element_id from cs_kb_set_eles
662:
663: WHERE set_id in
664: (select set_id from cs_kb_sets_b where set_number = c_set_number
665: and set_id < c_set_id);

Line 733: FROM CS_KB_SET_ELES se

729: RETURN NUMBER IS
730:
731: CURSOR Get_solns IS
732: SELECT count(se.Set_id)
733: FROM CS_KB_SET_ELES se
734: WHERE se.ELEMENT_ID = p_element_id
735: AND EXISTS (Select 'x'
736: From CS_KB_SETS_B s
737: WHERE s.Set_id = se.set_id

Line 772: SELECT element_id from cs_kb_set_eles

768:
769: CURSOR get_elem_info(c_set_id IN NUMBER)
770: IS
771:
772: SELECT element_id from cs_kb_set_eles
773:
774: WHERE set_id = c_set_id;
775:
776:

Line 871: SELECT description from cs_kb_elements_tl, cs_kb_set_eles

867: l_clob_loc CLOB;
868: l_temp_clob_loc CLOB;
869:
870: CURSOR C1(c_set_id IN NUMBER) IS
871: SELECT description from cs_kb_elements_tl, cs_kb_set_eles
872: where cs_kb_set_eles.set_id = c_set_id
873: AND cs_kb_set_eles.element_id = cs_kb_elements_tl.element_id
874: and cs_kb_elements_tl.language = USERENV('LANG');
875:

Line 872: where cs_kb_set_eles.set_id = c_set_id

868: l_temp_clob_loc CLOB;
869:
870: CURSOR C1(c_set_id IN NUMBER) IS
871: SELECT description from cs_kb_elements_tl, cs_kb_set_eles
872: where cs_kb_set_eles.set_id = c_set_id
873: AND cs_kb_set_eles.element_id = cs_kb_elements_tl.element_id
874: and cs_kb_elements_tl.language = USERENV('LANG');
875:
876: BEGIN

Line 873: AND cs_kb_set_eles.element_id = cs_kb_elements_tl.element_id

869:
870: CURSOR C1(c_set_id IN NUMBER) IS
871: SELECT description from cs_kb_elements_tl, cs_kb_set_eles
872: where cs_kb_set_eles.set_id = c_set_id
873: AND cs_kb_set_eles.element_id = cs_kb_elements_tl.element_id
874: and cs_kb_elements_tl.language = USERENV('LANG');
875:
876: BEGIN
877: dbms_lob.CREATETEMPORARY(l_clob_loc, TRUE, DBMS_LOB.session);

Line 1690: from cs_kb_set_eles

1686: counter number := 1;
1687:
1688: cursor element_ids_cur (p_set_id IN NUMBER) IS
1689: select element_id
1690: from cs_kb_set_eles
1691: where set_id = p_set_id;
1692:
1693: cursor product_ids_cur (p_set_id IN NUMBER) IS
1694: select product_id, product_org_id

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

3969: -- Fetch info for all statements for a solution
3970: CURSOR get_element_info(c_set_id IN NUMBER) IS
3971: select a.element_number, d.name, e.meaning,
3972: NVL(a.content_type, 'TEXT/HTML'), b.name, b.description, a.status
3973: from cs_kb_elements_b a , cs_kb_elements_tl b, cs_kb_set_eles c,
3974: cs_kb_element_types_vl d, cs_lookups e
3975: where a.element_id = c.element_id and c.set_id = c_set_id
3976: and a.element_id = b.element_id and b.language = userenv('LANG')
3977: and a.element_type_id = d.element_type_id

Line 4101: CS_KB_SET_ELES se

4097: , '''','&'||'apos;')
4098: , '"' ,'&'||'quot;') stmt
4099: FROM CS_KB_ELEMENTS_TL et,
4100: CS_KB_ELEMENTS_B eb,
4101: CS_KB_SET_ELES se
4102: WHERE et.language = userenv('LANG')
4103: AND eb.Element_Id = et.Element_Id
4104: AND eb.element_id = se.element_id
4105: AND se.set_id = v_set_id;