APPS.CS_KNOWLEDGE_AUDIT_PVT dependencies on CS_KB_ELEMENT_TYPES_TL

Line 81: l_element_type_name CS_KB_ELEMENT_TYPES_TL.name%TYPE;

77:
78: -- count of matching element type
79: l_count NUMBER;
80: l_set_type_id NUMBER;
81: l_element_type_name CS_KB_ELEMENT_TYPES_TL.name%TYPE;
82:
83: -- Counter variable.
84: counter NUMBER := 0;
85:

Line 117: FROM CS_KB_ELEMENT_TYPES_TL

113: IF l_count < 1 THEN
114:
115: SELECT name
116: INTO l_element_type_name
117: FROM CS_KB_ELEMENT_TYPES_TL
118: WHERE element_type_id = rec.element_type_id
119: AND language = USERENV('LANG');
120:
121: -- Extending tables one.

Line 2756: into x_element_type_id from cs_kb_element_types_tl

2752:
2753: BEGIN
2754:
2755: select element_type_id
2756: into x_element_type_id from cs_kb_element_types_tl
2757: where language = userenv('LANG')
2758: and upper(name) = upper(p_element_type_name);
2759:
2760: RETURN OKAY_STATUS;

Line 4053: is TABLE OF CS_KB_ELEMENT_TYPES_TL.NAME%TYPE INDEX BY BINARY_INTEGER;

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;
4056: Type elmt_desc_tab_type
4057: is TABLE OF CS_KB_ELEMENTS_TL.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;