APPS.CS_KNOWLEDGE_AUDIT_PVT dependencies on CS_KB_SETS_TL

Line 258: UPDATE CS_KB_SETS_TL SET

254: last_update_login = l_login
255: WHERE set_id = p_set_id;
256:
257: -- touch related sets to UPDATE interMedia index
258: UPDATE CS_KB_SETS_TL SET
259: last_update_date = l_date,
260: last_updated_by = l_user,
261: last_update_login = l_login
262: WHERE set_id = p_set_id;

Line 374: UPDATE CS_KB_SETS_TL SET

370: FROM CS_KB_SETS_B
371: WHERE set_id = p_set_id;
372:
373: -- touch related sets to UPDATE interMedia index
374: UPDATE CS_KB_SETS_TL SET
375: last_update_date = l_date,
376: last_updated_by = l_created_by,
377: last_update_login = l_login
378: WHERE set_id = p_set_id;

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

3932: -- in a category
3933: CURSOR get_solution_info_pub(c_category_id IN NUMBER)
3934: IS
3935: select /*+ index(sc) */a.set_id, a.set_number, c.name, v.name, b.name, a.status
3936: from cs_kb_sets_b a, cs_kb_sets_tl b, cs_kb_set_types_vl c,
3937: cs_kb_visibilities_vl v, cs_kb_set_categories sc
3938: where a.set_type_id = c.set_type_id
3939: and a.set_id = sc.set_id and sc.category_id = c_category_id
3940: and a.set_id = b.set_id and b.language = userenv('LANG')

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

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

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

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

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

4141:
4142: IF (p_sol_status = 'ALL')
4143: THEN
4144: SELECT /*+ index(sc) */ count(a.set_number) INTO l_soln_count
4145: from cs_kb_sets_b a, cs_kb_sets_tl b, cs_kb_set_types_vl c,
4146: cs_kb_visibilities_vl v, cs_kb_set_categories sc
4147: where a.set_type_id = c.set_type_id
4148: and a.set_id = sc.set_id and sc.category_id = l_category_id
4149: and a.set_id = b.set_id and b.language = userenv('LANG')

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

4151: and a.status <> 'OBS'
4152: and a.latest_version_flag = 'Y';
4153: ELSE
4154: SELECT 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')