APPS.CS_KNOWLEDGE_AUDIT_PVT dependencies on CS_KB_ELEMENTS_TL

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

836: and language = USERENV('LANG');
837:
838: select description
839: into l_clob2
840: from cs_kb_elements_tl
841: where element_id = p_element_id
842: and language = USERENV('LANG')
843: for update;
844:

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

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

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

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

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

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

Line 4089: FROM CS_KB_ELEMENTS_TL et,

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