APPS.CS_KNOWLEDGE_AUDIT_PVT dependencies on CS_KB_SET_TYPES_TL

Line 2646: into x_set_type_id from cs_kb_set_types_tl

2642: x_set_type_id OUT NOCOPY NUMBER
2643: ) RETURN NUMBER IS
2644: BEGIN
2645: select set_type_id
2646: into x_set_type_id from cs_kb_set_types_tl
2647: where language = userenv('LANG')
2648: and upper(name) = upper(p_set_type_name);
2649: RETURN OKAY_STATUS;
2650: EXCEPTION

Line 2668: from cs_kb_set_types_tl type,

2664:
2665: BEGIN
2666: select sets.set_type_id
2667: into x_set_type_id
2668: from cs_kb_set_types_tl type,
2669: cs_kb_sets_b sets
2670: where type.language = userenv('LANG')
2671: and upper(type.name) = upper(p_set_type_name)
2672: and sets.set_type_id = type.set_type_id

Line 4032: is TABLE OF CS_KB_SET_TYPES_TL.NAME%TYPE INDEX BY BINARY_INTEGER;

4028: is TABLE OF CS_KB_SETS_B.SET_ID%TYPE INDEX BY BINARY_INTEGER;
4029: Type set_number_tab_type
4030: is TABLE OF CS_KB_SETS_B.SET_NUMBER%TYPE INDEX BY BINARY_INTEGER;
4031: Type set_type_name_tab_type
4032: is TABLE OF CS_KB_SET_TYPES_TL.NAME%TYPE INDEX BY BINARY_INTEGER;
4033: Type set_name_tab_type
4034: is TABLE OF CS_KB_SETS_TL.NAME%TYPE INDEX BY BINARY_INTEGER;
4035: Type set_vis_tab_type
4036: is TABLE OF CS_LOOKUPS.MEANING%TYPE INDEX BY BINARY_INTEGER;