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 2746: into x_element_type_id from cs_kb_element_types_tl

2742:
2743: BEGIN
2744:
2745: select element_type_id
2746: into x_element_type_id from cs_kb_element_types_tl
2747: where language = userenv('LANG')
2748: and upper(name) = upper(p_element_type_name);
2749:
2750: RETURN OKAY_STATUS;

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

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