eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_KNOWLEDGE_AUDIT_PVT dependencies on CS_KB_SETS_B

Line 26: CS_KB_SETS_B s

22:
23: CURSOR cur_set(c_element_id IN NUMBER) IS
24: SELECT DISTINCT s.set_number
25: FROM CS_KB_SET_ELES se,
26: CS_KB_SETS_B s
27: WHERE se.element_id = c_element_id
28: AND se.set_id = s.set_id;
29:
30: BEGIN

Line 100: FROM CS_KB_SETS_B

96: BEGIN
97:
98: SELECT set_type_id
99: INTO l_set_type_id
100: FROM CS_KB_SETS_B
101: WHERE set_id = p_set_id;
102:
103: FOR rec IN cur_ele_type(l_set_type_id) LOOP
104:

Line 185: cs_kb_sets_b s,

181: IF p_set_number IS NOT NULL THEN
182: IF p_element_number IS NOT NULL THEN
183: SELECT count(*) INTO l_count
184: FROM cs_kb_set_ele_types se,
185: cs_kb_sets_b s,
186: cs_kb_elements_b e
187: WHERE se.set_type_id = s.set_type_id
188: AND se.element_type_id = e.element_type_id
189: AND s.set_number = p_set_number

Line 195: CS_KB_SETS_B s

191:
192: ELSIF(p_ele_type_id > 0) THEN
193: SELECT count(*) INTO l_count
194: FROM CS_KB_SET_ELE_TYPES se,
195: CS_KB_SETS_B s
196: WHERE se.set_type_id = s.set_type_id
197: AND s.set_number = p_set_number
198: AND se.element_type_id = p_ele_type_id;
199: END IF;

Line 239: FROM CS_KB_SETS_B

235: WHERE set_id = c_sid;
236:
237: CURSOR cur_set IS
238: SELECT set_type_id
239: FROM CS_KB_SETS_B
240: WHERE set_id = p_set_id;
241:
242: l_set_rec cur_set%ROWTYPE;
243:

Line 260: UPDATE CS_KB_SETS_B SET

256: -- change UPDATE DATE of set_audit
257: -- -- AND UPDATE change_history of set
258:
259: Get_Who(l_date, l_user, l_login);
260: UPDATE CS_KB_SETS_B SET
261: last_update_date = l_date,
262: last_updated_by = l_user,
263: last_update_login = l_login
264: WHERE set_id = p_set_id;

Line 331: FROM CS_KB_SETS_B

327:
328: --check set ele type match
329:
330: SELECT set_type_id INTO l_set_type_id
331: FROM CS_KB_SETS_B
332: WHERE set_id = p_set_id;
333:
334: SELECT element_type_id INTO l_ele_type_id
335: FROM CS_KB_ELEMENTS_B

Line 371: UPDATE CS_KB_SETS_B SET

367: l_date, l_created_by, l_date, l_created_by, l_login);
368:
369: -- change UPDATE DATE of set
370: -- AND UPDATE history
371: UPDATE CS_KB_SETS_B SET
372: last_update_date = l_date,
373: last_updated_by = l_created_by,
374: last_update_login = l_login
375: WHERE set_id = p_set_id;

Line 379: FROM CS_KB_SETS_B

375: WHERE set_id = p_set_id;
376:
377: SELECT set_number
378: INTO l_set_number
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

Line 483: FROM CS_KB_SET_ELE_TYPES t, CS_KB_SETS_B s

479: RETURN NUMBER IS--RETURN OKAY_STATUS IF success, or ERROR_STATUS IF fail
480:
481: CURSOR cur_ele_types IS
482: SELECT t.element_type_id
483: FROM CS_KB_SET_ELE_TYPES t, CS_KB_SETS_B s
484: WHERE t.set_type_id = s.set_type_id
485: AND s.set_id = CS_KB_SOLUTION_PVT.Get_Latest_Version_Id(p_set_number)
486: ORDER BY t.element_type_order;
487:

Line 555: from cs_kb_sets_b

551:
552:
553: CURSOR get_prev_set_id IS
554: select set_id
555: from cs_kb_sets_b
556: where set_id <> p_max_set_id
557: and set_number = p_set_number
558: order by creation_date desc;
559:

Line 664: (select set_id from cs_kb_sets_b where set_number = c_set_number

660:
661: SELECT DISTINCT element_id from cs_kb_set_eles
662:
663: WHERE set_id in
664: (select set_id from cs_kb_sets_b where set_number = c_set_number
665: and set_id < c_set_id);
666:
667: BEGIN
668:

Line 736: From CS_KB_SETS_B s

732: SELECT count(se.Set_id)
733: FROM CS_KB_SET_ELES se
734: WHERE se.ELEMENT_ID = p_element_id
735: AND EXISTS (Select 'x'
736: From CS_KB_SETS_B s
737: WHERE s.Set_id = se.set_id
738: AND (s.latest_version_flag = 'Y'
739: OR s.viewable_version_flag = 'Y')
740: );

Line 2669: cs_kb_sets_b sets

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
2673: and sets.set_id = p_set_id;

Line 2734: from cs_kb_sets_b a

2730: ) RETURN NUMBER IS
2731: BEGIN
2732: select set_id
2733: into x_set_id
2734: from cs_kb_sets_b a
2735: where a.set_number = p_set_number
2736: and a.status = 'PUB'
2737: and a.latest_version_flag = 'Y';
2738:

Line 3453: from cs_kb_sets_b

3449:
3450: -- Bug 32170161, replace sum with avg.
3451: CURSOR Get_Avg_Score_Csr(p_time_usge_span NUMBER) IS
3452: select avg(usage_score)/p_time_usge_span
3453: from cs_kb_sets_b
3454: where status = 'PUB';
3455:
3456: CURSOR Get_Lower_Limit_Csr(p_coefficient NUMBER, p_time_usage_span NUMBER) IS
3457: select avg(usage_score) - (p_coefficient*stddev(usage_score)/sqrt(count(set_id)))

Line 3458: from cs_kb_sets_b

3454: where status = 'PUB';
3455:
3456: CURSOR Get_Lower_Limit_Csr(p_coefficient NUMBER, p_time_usage_span NUMBER) IS
3457: select avg(usage_score) - (p_coefficient*stddev(usage_score)/sqrt(count(set_id)))
3458: from cs_kb_sets_b
3459: where status = 'PUB'
3460: and last_update_date > (sysdate - p_time_usage_span);
3461:
3462: CURSOR Get_Upper_Limit_Csr(p_coefficient NUMBER, p_time_usage_span NUMBER) IS

Line 3464: from cs_kb_sets_b

3460: and last_update_date > (sysdate - p_time_usage_span);
3461:
3462: CURSOR Get_Upper_Limit_Csr(p_coefficient NUMBER, p_time_usage_span NUMBER) IS
3463: select avg(usage_score) + (p_coefficient*stddev(usage_score)/sqrt(count(set_id)))
3464: from cs_kb_sets_b
3465: where status = 'PUB'
3466: and last_update_date > (sysdate - p_time_usage_span);
3467:
3468: CURSOR Get_Coefficient_Csr IS

Line 3474: FROM cs_kb_sets_b

3470:
3471: -- (4740480)
3472: CURSOR Get_Set_Count(p_time_usage_span NUMBER) IS
3473: SELECT count(set_id)
3474: FROM cs_kb_sets_b
3475: WHERE status = 'PUB'
3476: AND last_update_date > (SYSDATE - p_time_usage_span);
3477:
3478: l_set_count NUMBER;

Line 3515: update cs_kb_sets_b c set usage_score =

3511:
3512: -- 1. Update usage scores of solutions that were published AFTER
3513: -- (sysadate - l_time_usage) based on the used history.
3514: -- 1.1 Get score from used history
3515: update cs_kb_sets_b c set usage_score =
3516: (
3517: select
3518: round(
3519: sum(to_number(cl.meaning)*(1-(sysdate-a.creation_date)/l_time_usage))

Line 3547: update cs_kb_sets_b c set usage_score =

3543: );
3544:
3545: --1.2 Update usage scores of solutions that were published AFTER
3546: -- sysdate - l_time_usage based on the solution linkage.
3547: update cs_kb_sets_b c set usage_score =
3548: (
3549: select
3550: round(
3551: sum(to_number(cl.meaning)*(1-(sysdate-a.creation_date)/l_time_usage))

Line 3580: update cs_kb_sets_b c set usage_score =

3576:
3577: -- 2. Update usage scores of solutions that were published BEFORE
3578: -- sysdate - l_time_usage based on the used history. Aging factor
3579: -- compensation will not be added in this update.
3580: update cs_kb_sets_b c set usage_score =
3581: (
3582: select round(sum(to_number(cl.meaning)*(1-(sysdate-a.creation_date)/l_time_usage))
3583: )
3584: from cs_kb_set_used_hists a, cs_lookups cl

Line 3608: update cs_kb_sets_b c set usage_score =

3604: );
3605:
3606: -- 2.1 Update usage scores of solutions that were published BEFORE
3607: -- sysdate - l_time_usage based on the solution linkage.
3608: update cs_kb_sets_b c set usage_score =
3609: (
3610: select round(sum(to_number(cl.meaning)*(1-(sysdate-a.creation_date)/l_time_usage))
3611: ) + c.usage_score
3612: from cs_kb_set_links a, cs_lookups cl

Line 3654: update cs_kb_sets_b set norm_usage_score = (

3650: Close Get_Upper_Limit_Csr;
3651:
3652: -- update norm_usage_score
3653: If (l_higher - l_lower) <> 0 Then --5705547
3654: update cs_kb_sets_b set norm_usage_score = (
3655: ( decode(sign(decode(sign(usage_score - l_lower),
3656: -1, l_lower,
3657: usage_score) - l_higher),
3658: -1, decode(sign(usage_score - l_lower),

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

4024:
4025: l_cat_index NUMBER(15);
4026:
4027: Type set_id_tab_type
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;

Line 4030: is TABLE OF CS_KB_SETS_B.SET_NUMBER%TYPE INDEX BY BINARY_INTEGER;

4026:
4027: Type set_id_tab_type
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;

Line 4038: is TABLE OF CS_KB_SETS_B.STATUS%TYPE INDEX BY BINARY_INTEGER;

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;
4039: Type cat_id_tab_type
4040: is TABLE OF CS_KB_SOLN_CATEGORIES_VL.CATEGORY_ID%TYPE INDEX BY BINARY_INTEGER;
4041:
4042: l_set_ids set_id_tab_type;

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')