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 176: cs_kb_sets_b s,

172: IF p_set_number IS NOT NULL THEN
173: IF p_element_number IS NOT NULL THEN
174: SELECT count(*) INTO l_count
175: FROM cs_kb_set_ele_types se,
176: cs_kb_sets_b s,
177: cs_kb_elements_b e
178: WHERE se.set_type_id = s.set_type_id
179: AND se.element_type_id = e.element_type_id
180: AND s.set_number = p_set_number

Line 186: CS_KB_SETS_B s

182:
183: ELSIF(p_ele_type_id > 0) THEN
184: SELECT count(*) INTO l_count
185: FROM CS_KB_SET_ELE_TYPES se,
186: CS_KB_SETS_B s
187: WHERE se.set_type_id = s.set_type_id
188: AND s.set_number = p_set_number
189: AND se.element_type_id = p_ele_type_id;
190: END IF;

Line 230: FROM CS_KB_SETS_B

226: WHERE set_id = c_sid;
227:
228: CURSOR cur_set IS
229: SELECT set_type_id
230: FROM CS_KB_SETS_B
231: WHERE set_id = p_set_id;
232:
233: l_set_rec cur_set%ROWTYPE;
234:

Line 251: UPDATE CS_KB_SETS_B SET

247: -- change UPDATE DATE of set_audit
248: -- -- AND UPDATE change_history of set
249:
250: Get_Who(l_date, l_user, l_login);
251: UPDATE CS_KB_SETS_B SET
252: last_update_date = l_date,
253: last_updated_by = l_user,
254: last_update_login = l_login
255: WHERE set_id = p_set_id;

Line 322: FROM CS_KB_SETS_B

318:
319: --check set ele type match
320:
321: SELECT set_type_id INTO l_set_type_id
322: FROM CS_KB_SETS_B
323: WHERE set_id = p_set_id;
324:
325: SELECT element_type_id INTO l_ele_type_id
326: FROM CS_KB_ELEMENTS_B

Line 362: UPDATE CS_KB_SETS_B SET

358: l_date, l_created_by, l_date, l_created_by, l_login);
359:
360: -- change UPDATE DATE of set
361: -- AND UPDATE history
362: UPDATE CS_KB_SETS_B SET
363: last_update_date = l_date,
364: last_updated_by = l_created_by,
365: last_update_login = l_login
366: WHERE set_id = p_set_id;

Line 370: FROM CS_KB_SETS_B

366: WHERE set_id = p_set_id;
367:
368: SELECT set_number
369: INTO l_set_number
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

Line 474: FROM CS_KB_SET_ELE_TYPES t, CS_KB_SETS_B s

470: RETURN NUMBER IS--RETURN OKAY_STATUS IF success, or ERROR_STATUS IF fail
471:
472: CURSOR cur_ele_types IS
473: SELECT t.element_type_id
474: FROM CS_KB_SET_ELE_TYPES t, CS_KB_SETS_B s
475: WHERE t.set_type_id = s.set_type_id
476: AND s.set_id = CS_KB_SOLUTION_PVT.Get_Latest_Version_Id(p_set_number)
477: ORDER BY t.element_type_order;
478:

Line 546: from cs_kb_sets_b

542:
543:
544: CURSOR get_prev_set_id IS
545: select set_id
546: from cs_kb_sets_b
547: where set_id <> p_max_set_id
548: and set_number = p_set_number
549: order by creation_date desc;
550:

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

651:
652: SELECT DISTINCT element_id from cs_kb_set_eles
653:
654: WHERE set_id in
655: (select set_id from cs_kb_sets_b where set_number = c_set_number
656: and set_id < c_set_id);
657:
658: BEGIN
659:

Line 727: From CS_KB_SETS_B s

723: SELECT count(se.Set_id)
724: FROM CS_KB_SET_ELES se
725: WHERE se.ELEMENT_ID = p_element_id
726: AND EXISTS (Select 'x'
727: From CS_KB_SETS_B s
728: WHERE s.Set_id = se.set_id
729: AND (s.latest_version_flag = 'Y'
730: OR s.viewable_version_flag = 'Y')
731: );

Line 2659: cs_kb_sets_b sets

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

Line 2724: from cs_kb_sets_b a

2720: ) RETURN NUMBER IS
2721: BEGIN
2722: select set_id
2723: into x_set_id
2724: from cs_kb_sets_b a
2725: where a.set_number = p_set_number
2726: and a.status = 'PUB'
2727: and a.latest_version_flag = 'Y';
2728:

Line 3443: from cs_kb_sets_b

3439:
3440: -- Bug 32170161, replace sum with avg.
3441: CURSOR Get_Avg_Score_Csr(p_time_usge_span NUMBER) IS
3442: select avg(usage_score)/p_time_usge_span
3443: from cs_kb_sets_b
3444: where status = 'PUB';
3445:
3446: CURSOR Get_Lower_Limit_Csr(p_coefficient NUMBER, p_time_usage_span NUMBER) IS
3447: select avg(usage_score) - (p_coefficient*stddev(usage_score)/sqrt(count(set_id)))

Line 3448: from cs_kb_sets_b

3444: where status = 'PUB';
3445:
3446: CURSOR Get_Lower_Limit_Csr(p_coefficient NUMBER, p_time_usage_span NUMBER) IS
3447: select avg(usage_score) - (p_coefficient*stddev(usage_score)/sqrt(count(set_id)))
3448: from cs_kb_sets_b
3449: where status = 'PUB'
3450: and last_update_date > (sysdate - p_time_usage_span);
3451:
3452: CURSOR Get_Upper_Limit_Csr(p_coefficient NUMBER, p_time_usage_span NUMBER) IS

Line 3454: from cs_kb_sets_b

3450: and last_update_date > (sysdate - p_time_usage_span);
3451:
3452: CURSOR Get_Upper_Limit_Csr(p_coefficient NUMBER, p_time_usage_span NUMBER) IS
3453: select avg(usage_score) + (p_coefficient*stddev(usage_score)/sqrt(count(set_id)))
3454: from cs_kb_sets_b
3455: where status = 'PUB'
3456: and last_update_date > (sysdate - p_time_usage_span);
3457:
3458: CURSOR Get_Coefficient_Csr IS

Line 3464: FROM cs_kb_sets_b

3460:
3461: -- (4740480)
3462: CURSOR Get_Set_Count(p_time_usage_span NUMBER) IS
3463: SELECT 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: l_set_count NUMBER;

Line 3505: update cs_kb_sets_b c set usage_score =

3501:
3502: -- 1. Update usage scores of solutions that were published AFTER
3503: -- (sysadate - l_time_usage) based on the used history.
3504: -- 1.1 Get score from used history
3505: update cs_kb_sets_b c set usage_score =
3506: (
3507: select
3508: round(
3509: sum(to_number(cl.meaning)*(1-(sysdate-a.creation_date)/l_time_usage))

Line 3537: update cs_kb_sets_b c set usage_score =

3533: );
3534:
3535: --1.2 Update usage scores of solutions that were published AFTER
3536: -- sysdate - l_time_usage based on the solution linkage.
3537: update cs_kb_sets_b c set usage_score =
3538: (
3539: select
3540: round(
3541: sum(to_number(cl.meaning)*(1-(sysdate-a.creation_date)/l_time_usage))

Line 3570: update cs_kb_sets_b c set usage_score =

3566:
3567: -- 2. Update usage scores of solutions that were published BEFORE
3568: -- sysdate - l_time_usage based on the used history. Aging factor
3569: -- compensation will not be added in this update.
3570: update cs_kb_sets_b c set usage_score =
3571: (
3572: select round(sum(to_number(cl.meaning)*(1-(sysdate-a.creation_date)/l_time_usage))
3573: )
3574: from cs_kb_set_used_hists a, cs_lookups cl

Line 3598: update cs_kb_sets_b c set usage_score =

3594: );
3595:
3596: -- 2.1 Update usage scores of solutions that were published BEFORE
3597: -- sysdate - l_time_usage based on the solution linkage.
3598: update cs_kb_sets_b c set usage_score =
3599: (
3600: select round(sum(to_number(cl.meaning)*(1-(sysdate-a.creation_date)/l_time_usage))
3601: ) + c.usage_score
3602: from cs_kb_set_links a, cs_lookups cl

Line 3644: update cs_kb_sets_b set norm_usage_score = (

3640: Close Get_Upper_Limit_Csr;
3641:
3642: -- update norm_usage_score
3643: If (l_higher - l_lower) <> 0 Then --5705547
3644: update cs_kb_sets_b set norm_usage_score = (
3645: ( decode(sign(decode(sign(usage_score - l_lower),
3646: -1, l_lower,
3647: usage_score) - l_higher),
3648: -1, decode(sign(usage_score - l_lower),

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

4014:
4015: l_cat_index NUMBER(15);
4016:
4017: Type set_id_tab_type
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;

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

4016:
4017: Type set_id_tab_type
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;

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

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;
4029: Type cat_id_tab_type
4030: is TABLE OF CS_KB_SOLN_CATEGORIES_VL.CATEGORY_ID%TYPE INDEX BY BINARY_INTEGER;
4031:
4032: l_set_ids set_id_tab_type;

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