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_ELEMENTS_B

Line 20: FROM CS_KB_ELEMENTS_B

16: l_count NUMBER;
17:
18: CURSOR cur_ele IS
19: SELECT element_id
20: FROM CS_KB_ELEMENTS_B
21: WHERE element_number = p_element_number;
22:
23: CURSOR cur_set(c_element_id IN NUMBER) IS
24: SELECT DISTINCT s.set_number

Line 38: CS_KB_ELEMENTS_B e

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:
42: IF l_count < 1 THEN

Line 107: FROM CS_KB_ELEMENTS_B e,

103: FOR rec IN cur_ele_type(l_set_type_id) LOOP
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;

Line 186: cs_kb_elements_b e

182: IF p_element_number IS NOT NULL THEN
183: SELECT count(*) INTO l_count
184: FROM cs_kb_set_ele_types se,
185: cs_kb_sets_b s,
186: cs_kb_elements_b e
187: WHERE se.set_type_id = s.set_type_id
188: AND se.element_type_id = e.element_type_id
189: AND s.set_number = p_set_number
190: AND e.element_number = p_element_number;

Line 205: CS_KB_ELEMENTS_B e

201: ELSIF(p_set_type_id >0) THEN
202: IF p_element_number IS NOT NULL THEN
203: SELECT count(*) INTO l_count
204: FROM CS_KB_SET_ELE_TYPES se,
205: CS_KB_ELEMENTS_B e
206: WHERE se.set_type_id = p_set_type_id
207: AND e.element_number = p_element_number
208: AND se.element_type_id = e.element_type_id;
209:

Line 308: FROM CS_KB_ELEMENTS_B

304: END IF;
305:
306: -- check IF element exists
307: SELECT COUNT(*) INTO l_count
308: FROM CS_KB_ELEMENTS_B
309: WHERE element_number = p_element_number;
310: IF(l_count=0) THEN
311: FND_MESSAGE.set_name('CS', 'CS_KB_C_INVALID_ELE_ID');
312: GOTO ERROR_FOUND;

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 335: FROM CS_KB_ELEMENTS_B

331: FROM CS_KB_SETS_B
332: WHERE set_id = p_set_id;
333:
334: SELECT element_type_id INTO l_ele_type_id
335: FROM CS_KB_ELEMENTS_B
336: WHERE element_id = l_element_id;
337:
338: IF( Is_Set_Ele_Type_Valid(
339: p_set_type_id => l_set_type_id,

Line 462: FROM CS_KB_ELEMENTS_B

458: RETURN l_element_id;
459: END IF;
460:
461: SELECT element_number INTO l_element_number
462: FROM CS_KB_ELEMENTS_B
463: WHERE element_id = l_element_id;
464:
465: l_ret := Add_Element_To_Set(
466: p_element_number => l_element_number,

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 533: Type element_id_tab_type is TABLE OF CS_KB_ELEMENTS_B.ELEMENT_ID%TYPE INDEX BY BINARY_INTEGER;

529: l_count NUMBER(15);
530: l_prior_set_id NUMBER(15);
531: l_exists BOOLEAN;
532:
533: Type element_id_tab_type is TABLE OF CS_KB_ELEMENTS_B.ELEMENT_ID%TYPE INDEX BY BINARY_INTEGER;
534: Type element_status_tab_type is TABLE OF CS_KB_ELEMENTS_B.STATUS%TYPE INDEX BY BINARY_INTEGER;
535:
536: l_prev_ver_elem_ids element_id_tab_type;
537:

Line 534: Type element_status_tab_type is TABLE OF CS_KB_ELEMENTS_B.STATUS%TYPE INDEX BY BINARY_INTEGER;

530: l_prior_set_id NUMBER(15);
531: l_exists BOOLEAN;
532:
533: Type element_id_tab_type is TABLE OF CS_KB_ELEMENTS_B.ELEMENT_ID%TYPE INDEX BY BINARY_INTEGER;
534: Type element_status_tab_type is TABLE OF CS_KB_ELEMENTS_B.STATUS%TYPE INDEX BY BINARY_INTEGER;
535:
536: l_prev_ver_elem_ids element_id_tab_type;
537:
538: l_max_ver_elem_ids element_id_tab_type;

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 611: UPDATE CS_KB_ELEMENTS_B

607:
608: end loop;
609: IF (l_exists = FALSE)
610: THEN
611: UPDATE CS_KB_ELEMENTS_B
612: SET status = 'OBS'
613: WHERE element_id = l_prev_ver_elem_ids(j);
614:
615: END IF;

Line 628: Type element_id_tab_type is TABLE OF CS_KB_ELEMENTS_B.ELEMENT_ID%TYPE INDEX BY BINARY_INTEGER;

624:
625: PROCEDURE Auto_Obsolete_For_Solution_Pub(p_set_number IN VARCHAR2,
626: p_max_set_id IN NUMBER) IS
627:
628: Type element_id_tab_type is TABLE OF CS_KB_ELEMENTS_B.ELEMENT_ID%TYPE INDEX BY BINARY_INTEGER;
629: Type element_status_tab_type is TABLE OF CS_KB_ELEMENTS_B.STATUS%TYPE INDEX BY BINARY_INTEGER;
630:
631: l_max_set_id NUMBER(15);
632: l_temp_set_id NUMBER(15);

Line 629: Type element_status_tab_type is TABLE OF CS_KB_ELEMENTS_B.STATUS%TYPE INDEX BY BINARY_INTEGER;

625: PROCEDURE Auto_Obsolete_For_Solution_Pub(p_set_number IN VARCHAR2,
626: p_max_set_id IN NUMBER) IS
627:
628: Type element_id_tab_type is TABLE OF CS_KB_ELEMENTS_B.ELEMENT_ID%TYPE INDEX BY BINARY_INTEGER;
629: Type element_status_tab_type is TABLE OF CS_KB_ELEMENTS_B.STATUS%TYPE INDEX BY BINARY_INTEGER;
630:
631: l_max_set_id NUMBER(15);
632: l_temp_set_id NUMBER(15);
633: l_exists BOOLEAN;

Line 814: from cs_kb_elements_b

810:
811: BEGIN
812:
813: select status INTO l_status
814: from cs_kb_elements_b
815: where element_id = p_element_id;
816:
817: IF (l_status = 'DRAFT')
818: THEN

Line 819: UPDATE CS_KB_ELEMENTS_B

815: where element_id = p_element_id;
816:
817: IF (l_status = 'DRAFT')
818: THEN
819: UPDATE CS_KB_ELEMENTS_B
820: SET status = 'OBS'
821: WHERE element_id = p_element_id;
822: ELSIF (l_status = 'PUBLISHED')
823: THEN

Line 826: UPDATE CS_KB_ELEMENTS_B

822: ELSIF (l_status = 'PUBLISHED')
823: THEN
824: IF (Is_Pub_Element_Obsoletable(p_element_id) = 1)
825: THEN
826: UPDATE CS_KB_ELEMENTS_B
827: SET status = 'OBS'
828: WHERE element_id = p_element_id;
829:
830: END IF;

Line 2781: from cs_kb_elements_b

2777: BEGIN
2778:
2779: select element_type_id
2780: into x_element_type_id
2781: from cs_kb_elements_b
2782: where element_number = p_element_number;
2783:
2784: RETURN OKAY_STATUS;
2785:

Line 2963: from cs_kb_elements_b

2959:
2960: BEGIN
2961:
2962: select element_id INTO x_latest_id
2963: from cs_kb_elements_b
2964: where element_number = p_ele_no
2965: and status = 'PUBLISHED';
2966:
2967: RETURN OKAY_STATUS;

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 4051: is TABLE OF CS_KB_ELEMENTS_B.ELEMENT_NUMBER%TYPE INDEX BY BINARY_INTEGER;

4047: l_set_status set_status_tab_type;
4048: l_cat_ids cat_id_tab_type;
4049:
4050: Type elmt_number_tab_type
4051: is TABLE OF CS_KB_ELEMENTS_B.ELEMENT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
4052: Type elmt_type_name_tab_type
4053: is TABLE OF CS_KB_ELEMENT_TYPES_TL.NAME%TYPE INDEX BY BINARY_INTEGER;
4054: Type elmt_name_tab_type
4055: is TABLE OF CS_KB_ELEMENTS_TL.NAME%TYPE INDEX BY BINARY_INTEGER;

Line 4061: is TABLE OF CS_KB_ELEMENTS_B.STATUS%TYPE INDEX BY BINARY_INTEGER;

4057: is TABLE OF CS_KB_ELEMENTS_TL.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
4058: Type elmt_dist_tab_type
4059: is TABLE OF CS_LOOKUPS.MEANING%TYPE INDEX BY BINARY_INTEGER;
4060: Type elmt_status_tab_type
4061: is TABLE OF CS_KB_ELEMENTS_B.STATUS%TYPE INDEX BY BINARY_INTEGER;
4062: Type elmt_ct_tab_type
4063: is TABLE OF CS_KB_ELEMENTS_B.CONTENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
4064:
4065: l_elmt_nos elmt_number_tab_type;

Line 4063: is TABLE OF CS_KB_ELEMENTS_B.CONTENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

4059: is TABLE OF CS_LOOKUPS.MEANING%TYPE INDEX BY BINARY_INTEGER;
4060: Type elmt_status_tab_type
4061: is TABLE OF CS_KB_ELEMENTS_B.STATUS%TYPE INDEX BY BINARY_INTEGER;
4062: Type elmt_ct_tab_type
4063: is TABLE OF CS_KB_ELEMENTS_B.CONTENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
4064:
4065: l_elmt_nos elmt_number_tab_type;
4066: l_elmt_type_names elmt_type_name_tab_type;
4067: l_elmt_names elmt_name_tab_type;

Line 4100: CS_KB_ELEMENTS_B eb,

4096: , '<','&'||'lt;')
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