APPS.CS_KNOWLEDGE_AUDIT_PVT dependencies on CS_KB_SET_TYPES_TL

Line 2636: into x_set_type_id from cs_kb_set_types_tl

2632: x_set_type_id OUT NOCOPY NUMBER
2633: ) RETURN NUMBER IS
2634: BEGIN
2635: select set_type_id
2636: into x_set_type_id from cs_kb_set_types_tl
2637: where language = userenv('LANG')
2638: and upper(name) = upper(p_set_type_name);
2639: RETURN OKAY_STATUS;
2640: EXCEPTION

Line 2658: from cs_kb_set_types_tl type,

2654:
2655: BEGIN
2656: select sets.set_type_id
2657: into x_set_type_id
2658: from cs_kb_set_types_tl type,
2659: cs_kb_sets_b sets
2660: where type.language = userenv('LANG')
2661: and upper(type.name) = upper(p_set_type_name)
2662: and sets.set_type_id = type.set_type_id

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

4018: is TABLE OF CS_KB_SETS_B.SET_ID%TYPE INDEX BY BINARY_INTEGER;
4019: Type set_number_tab_type
4020: is TABLE OF CS_KB_SETS_B.SET_NUMBER%TYPE INDEX BY BINARY_INTEGER;
4021: Type set_type_name_tab_type
4022: is TABLE OF CS_KB_SET_TYPES_TL.NAME%TYPE INDEX BY BINARY_INTEGER;
4023: Type set_name_tab_type
4024: is TABLE OF CS_KB_SETS_TL.NAME%TYPE INDEX BY BINARY_INTEGER;
4025: Type set_vis_tab_type
4026: is TABLE OF CS_LOOKUPS.MEANING%TYPE INDEX BY BINARY_INTEGER;