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_TL

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 849: from cs_kb_elements_tl

845: and language = USERENV('LANG');
846:
847: select description
848: into l_clob2
849: from cs_kb_elements_tl
850: where element_id = p_element_id
851: and language = USERENV('LANG')
852: for update;
853:

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 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 874: and cs_kb_elements_tl.language = USERENV('LANG');

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);
878: DBMS_LOB.TRIM(l_clob_loc, 0);

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 4055: is TABLE OF CS_KB_ELEMENTS_TL.NAME%TYPE INDEX BY BINARY_INTEGER;

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;
4056: Type elmt_desc_tab_type
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;

Line 4057: is TABLE OF CS_KB_ELEMENTS_TL.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

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;
4056: Type elmt_desc_tab_type
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;

Line 4099: FROM CS_KB_ELEMENTS_TL et,

4095: , '>','&'||'gt;')
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