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 177: cs_kb_elements_b e

173: IF p_element_number IS NOT NULL THEN
174: SELECT count(*) INTO l_count
175: FROM cs_kb_set_ele_types se,
176: cs_kb_sets_b s,
177: cs_kb_elements_b e
178: WHERE se.set_type_id = s.set_type_id
179: AND se.element_type_id = e.element_type_id
180: AND s.set_number = p_set_number
181: AND e.element_number = p_element_number;

Line 196: CS_KB_ELEMENTS_B e

192: ELSIF(p_set_type_id >0) THEN
193: IF p_element_number IS NOT NULL THEN
194: SELECT count(*) INTO l_count
195: FROM CS_KB_SET_ELE_TYPES se,
196: CS_KB_ELEMENTS_B e
197: WHERE se.set_type_id = p_set_type_id
198: AND e.element_number = p_element_number
199: AND se.element_type_id = e.element_type_id;
200:

Line 299: FROM CS_KB_ELEMENTS_B

295: END IF;
296:
297: -- check IF element exists
298: SELECT COUNT(*) INTO l_count
299: FROM CS_KB_ELEMENTS_B
300: WHERE element_number = p_element_number;
301: IF(l_count=0) THEN
302: FND_MESSAGE.set_name('CS', 'CS_KB_C_INVALID_ELE_ID');
303: GOTO ERROR_FOUND;

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

322: FROM CS_KB_SETS_B
323: WHERE set_id = p_set_id;
324:
325: SELECT element_type_id INTO l_ele_type_id
326: FROM CS_KB_ELEMENTS_B
327: WHERE element_id = l_element_id;
328:
329: IF( Is_Set_Ele_Type_Valid(
330: p_set_type_id => l_set_type_id,

Line 453: FROM CS_KB_ELEMENTS_B

449: RETURN l_element_id;
450: END IF;
451:
452: SELECT element_number INTO l_element_number
453: FROM CS_KB_ELEMENTS_B
454: WHERE element_id = l_element_id;
455:
456: l_ret := Add_Element_To_Set(
457: p_element_number => l_element_number,

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

520: l_count NUMBER(15);
521: l_prior_set_id NUMBER(15);
522: l_exists BOOLEAN;
523:
524: Type element_id_tab_type is TABLE OF CS_KB_ELEMENTS_B.ELEMENT_ID%TYPE INDEX BY BINARY_INTEGER;
525: Type element_status_tab_type is TABLE OF CS_KB_ELEMENTS_B.STATUS%TYPE INDEX BY BINARY_INTEGER;
526:
527: l_prev_ver_elem_ids element_id_tab_type;
528:

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

521: l_prior_set_id NUMBER(15);
522: l_exists BOOLEAN;
523:
524: Type element_id_tab_type is TABLE OF CS_KB_ELEMENTS_B.ELEMENT_ID%TYPE INDEX BY BINARY_INTEGER;
525: Type element_status_tab_type is TABLE OF CS_KB_ELEMENTS_B.STATUS%TYPE INDEX BY BINARY_INTEGER;
526:
527: l_prev_ver_elem_ids element_id_tab_type;
528:
529: l_max_ver_elem_ids element_id_tab_type;

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

598:
599: end loop;
600: IF (l_exists = FALSE)
601: THEN
602: UPDATE CS_KB_ELEMENTS_B
603: SET status = 'OBS'
604: WHERE element_id = l_prev_ver_elem_ids(j);
605:
606: END IF;

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

615:
616: PROCEDURE Auto_Obsolete_For_Solution_Pub(p_set_number IN VARCHAR2,
617: p_max_set_id IN NUMBER) IS
618:
619: Type element_id_tab_type is TABLE OF CS_KB_ELEMENTS_B.ELEMENT_ID%TYPE INDEX BY BINARY_INTEGER;
620: Type element_status_tab_type is TABLE OF CS_KB_ELEMENTS_B.STATUS%TYPE INDEX BY BINARY_INTEGER;
621:
622: l_max_set_id NUMBER(15);
623: l_temp_set_id NUMBER(15);

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

616: PROCEDURE Auto_Obsolete_For_Solution_Pub(p_set_number IN VARCHAR2,
617: p_max_set_id IN NUMBER) IS
618:
619: Type element_id_tab_type is TABLE OF CS_KB_ELEMENTS_B.ELEMENT_ID%TYPE INDEX BY BINARY_INTEGER;
620: Type element_status_tab_type is TABLE OF CS_KB_ELEMENTS_B.STATUS%TYPE INDEX BY BINARY_INTEGER;
621:
622: l_max_set_id NUMBER(15);
623: l_temp_set_id NUMBER(15);
624: l_exists BOOLEAN;

Line 805: from cs_kb_elements_b

801:
802: BEGIN
803:
804: select status INTO l_status
805: from cs_kb_elements_b
806: where element_id = p_element_id;
807:
808: IF (l_status = 'DRAFT')
809: THEN

Line 810: UPDATE CS_KB_ELEMENTS_B

806: where element_id = p_element_id;
807:
808: IF (l_status = 'DRAFT')
809: THEN
810: UPDATE CS_KB_ELEMENTS_B
811: SET status = 'OBS'
812: WHERE element_id = p_element_id;
813: ELSIF (l_status = 'PUBLISHED')
814: THEN

Line 817: UPDATE CS_KB_ELEMENTS_B

813: ELSIF (l_status = 'PUBLISHED')
814: THEN
815: IF (Is_Pub_Element_Obsoletable(p_element_id) = 1)
816: THEN
817: UPDATE CS_KB_ELEMENTS_B
818: SET status = 'OBS'
819: WHERE element_id = p_element_id;
820:
821: END IF;

Line 2771: from cs_kb_elements_b

2767: BEGIN
2768:
2769: select element_type_id
2770: into x_element_type_id
2771: from cs_kb_elements_b
2772: where element_number = p_element_number;
2773:
2774: RETURN OKAY_STATUS;
2775:

Line 2953: from cs_kb_elements_b

2949:
2950: BEGIN
2951:
2952: select element_id INTO x_latest_id
2953: from cs_kb_elements_b
2954: where element_number = p_ele_no
2955: and status = 'PUBLISHED';
2956:
2957: RETURN OKAY_STATUS;

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

4037: l_set_status set_status_tab_type;
4038: l_cat_ids cat_id_tab_type;
4039:
4040: Type elmt_number_tab_type
4041: is TABLE OF CS_KB_ELEMENTS_B.ELEMENT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
4042: Type elmt_type_name_tab_type
4043: is TABLE OF CS_KB_ELEMENT_TYPES_TL.NAME%TYPE INDEX BY BINARY_INTEGER;
4044: Type elmt_name_tab_type
4045: is TABLE OF CS_KB_ELEMENTS_TL.NAME%TYPE INDEX BY BINARY_INTEGER;

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

4047: is TABLE OF CS_KB_ELEMENTS_TL.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
4048: Type elmt_dist_tab_type
4049: is TABLE OF CS_LOOKUPS.MEANING%TYPE INDEX BY BINARY_INTEGER;
4050: Type elmt_status_tab_type
4051: is TABLE OF CS_KB_ELEMENTS_B.STATUS%TYPE INDEX BY BINARY_INTEGER;
4052: Type elmt_ct_tab_type
4053: is TABLE OF CS_KB_ELEMENTS_B.CONTENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
4054:
4055: l_elmt_nos elmt_number_tab_type;

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

4049: is TABLE OF CS_LOOKUPS.MEANING%TYPE INDEX BY BINARY_INTEGER;
4050: Type elmt_status_tab_type
4051: is TABLE OF CS_KB_ELEMENTS_B.STATUS%TYPE INDEX BY BINARY_INTEGER;
4052: Type elmt_ct_tab_type
4053: is TABLE OF CS_KB_ELEMENTS_B.CONTENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
4054:
4055: l_elmt_nos elmt_number_tab_type;
4056: l_elmt_type_names elmt_type_name_tab_type;
4057: l_elmt_names elmt_name_tab_type;

Line 4090: CS_KB_ELEMENTS_B eb,

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