APPS.CS_KNOWLEDGE_AUDIT_PVT dependencies on CS_KB_SETS_TL

Line 267: UPDATE CS_KB_SETS_TL SET

263: last_update_login = l_login
264: WHERE set_id = p_set_id;
265:
266: -- touch related sets to UPDATE interMedia index
267: UPDATE CS_KB_SETS_TL SET
268: last_update_date = l_date,
269: last_updated_by = l_user,
270: last_update_login = l_login
271: WHERE set_id = p_set_id;

Line 383: UPDATE CS_KB_SETS_TL SET

379: FROM CS_KB_SETS_B
380: WHERE set_id = p_set_id;
381:
382: -- touch related sets to UPDATE interMedia index
383: UPDATE CS_KB_SETS_TL SET
384: last_update_date = l_date,
385: last_updated_by = l_created_by,
386: last_update_login = l_login
387: WHERE set_id = p_set_id;

Line 3946: from cs_kb_sets_b a, cs_kb_sets_tl b, cs_kb_set_types_vl c,

3942: -- in a category
3943: CURSOR get_solution_info_pub(c_category_id IN NUMBER)
3944: IS
3945: select /*+ index(sc) */a.set_id, a.set_number, c.name, v.name, b.name, a.status
3946: from cs_kb_sets_b a, cs_kb_sets_tl b, cs_kb_set_types_vl c,
3947: cs_kb_visibilities_vl v, cs_kb_set_categories sc
3948: where a.set_type_id = c.set_type_id
3949: and a.set_id = sc.set_id and sc.category_id = c_category_id
3950: and a.set_id = b.set_id and b.language = userenv('LANG')

Line 3959: from cs_kb_sets_b a, cs_kb_sets_tl b, cs_kb_set_types_vl c,

3955: -- in a category
3956: CURSOR get_solution_info_all(c_category_id IN NUMBER)
3957: IS
3958: select /*+ index(sc) */ a.set_id, a.set_number, c.name, v.name, b.name, a.status
3959: from cs_kb_sets_b a, cs_kb_sets_tl b, cs_kb_set_types_vl c,
3960: cs_kb_visibilities_vl v, cs_kb_set_categories sc
3961: where a.set_type_id = c.set_type_id
3962: and a.set_id = sc.set_id and sc.category_id = c_category_id
3963: and a.set_id = b.set_id and b.language = userenv('LANG')

Line 4034: is TABLE OF CS_KB_SETS_TL.NAME%TYPE INDEX BY BINARY_INTEGER;

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;
4037: Type set_status_tab_type
4038: is TABLE OF CS_KB_SETS_B.STATUS%TYPE INDEX BY BINARY_INTEGER;

Line 4155: from cs_kb_sets_b a, cs_kb_sets_tl b, cs_kb_set_types_vl c,

4151:
4152: IF (p_sol_status = 'ALL')
4153: THEN
4154: SELECT /*+ index(sc) */ count(a.set_number) INTO l_soln_count
4155: from cs_kb_sets_b a, cs_kb_sets_tl b, cs_kb_set_types_vl c,
4156: cs_kb_visibilities_vl v, cs_kb_set_categories sc
4157: where a.set_type_id = c.set_type_id
4158: and a.set_id = sc.set_id and sc.category_id = l_category_id
4159: and a.set_id = b.set_id and b.language = userenv('LANG')

Line 4165: from cs_kb_sets_b a, cs_kb_sets_tl b, cs_kb_set_types_vl c,

4161: and a.status <> 'OBS'
4162: and a.latest_version_flag = 'Y';
4163: ELSE
4164: SELECT count(a.set_number) INTO l_soln_count
4165: from cs_kb_sets_b a, cs_kb_sets_tl b, cs_kb_set_types_vl c,
4166: cs_kb_visibilities_vl v, cs_kb_set_categories sc
4167: where a.set_type_id = c.set_type_id
4168: and a.set_id = sc.set_id and sc.category_id = l_category_id
4169: and a.set_id = b.set_id and b.language = userenv('LANG')