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_PVT dependencies on CS_KB_SETS_B

Line 280: cs_kb_sets_b s,

276: if(p_set_id > 0) then
277: if(p_ele_id > 0) then
278: select count(*) into l_count
279: from cs_kb_set_ele_types se,
280: cs_kb_sets_b s,
281: cs_kb_elements_b e
282: where se.set_type_id = s.set_type_id
283: and se.element_type_id = e.element_type_id
284: and s.set_id = p_set_id

Line 290: cs_kb_sets_b s

286:
287: elsif(p_ele_type_id > 0) then
288: select count(*) into l_count
289: from cs_kb_set_ele_types se,
290: cs_kb_sets_b s
291: where se.set_type_id = s.set_type_id
292: and s.set_id = p_set_id
293: and se.element_type_id = p_ele_type_id;
294: end if;

Line 875: from cs_kb_sets_b

871:
872: if(p_link_id_tbl(i1) is not null) then
873: if(l_set_id is not null and l_set_id>0) then
874: select count(*) into l_count
875: from cs_kb_sets_b
876: where set_id = l_set_id;
877: if(l_count<1) then
878:
879: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then

Line 1305: update cs_kb_sets_b set

1301: Get_Who(l_date, l_user, l_login);
1302:
1303: if(p_update_sets_b = 'T') then
1304:
1305: update cs_kb_sets_b set
1306: last_update_date = l_date,
1307: last_updated_by = l_user,
1308: last_update_login = l_login
1309: where set_id = p_set_id;

Line 1403: update cs_kb_sets_b set

1399:
1400:
1401: if(p_update_sets_b = 'T') then
1402:
1403: update cs_kb_sets_b set
1404: last_update_date = l_date,
1405: last_updated_by = l_created_by,
1406: last_update_login = l_login
1407: where set_id = p_set_id;

Line 3804: ' select /+ FIRST_ROWS / cs_kb_sets_tl.set_id id, score(10) score, cs_kb_sets_b.set_type_id,'||

3800: l_sql_srows varchar2(30) :=
3801: ' select count(*) ';
3802:
3803: l_sql_s varchar2(500) :=
3804: ' select /*+ FIRST_ROWS */ cs_kb_sets_tl.set_id id, score(10) score, cs_kb_sets_b.set_type_id,'||
3805: ' cs_kb_sets_tl.name, cs_kb_sets_tl.description, '||
3806: ' cs_kb_sets_b.creation_date, cs_kb_sets_b.created_by,'||
3807: ' cs_kb_sets_b.last_update_date, cs_kb_sets_b.last_updated_by, '||
3808: ' cs_kb_sets_b.last_update_login, cs_kb_set_types_tl.name, '||

Line 3806: ' cs_kb_sets_b.creation_date, cs_kb_sets_b.created_by,'||

3802:
3803: l_sql_s varchar2(500) :=
3804: ' select /*+ FIRST_ROWS */ cs_kb_sets_tl.set_id id, score(10) score, cs_kb_sets_b.set_type_id,'||
3805: ' cs_kb_sets_tl.name, cs_kb_sets_tl.description, '||
3806: ' cs_kb_sets_b.creation_date, cs_kb_sets_b.created_by,'||
3807: ' cs_kb_sets_b.last_update_date, cs_kb_sets_b.last_updated_by, '||
3808: ' cs_kb_sets_b.last_update_login, cs_kb_set_types_tl.name, '||
3809: ' cs_kb_sets_b.set_number ';
3810: l_sql_f1 varchar2(100) :=

Line 3807: ' cs_kb_sets_b.last_update_date, cs_kb_sets_b.last_updated_by, '||

3803: l_sql_s varchar2(500) :=
3804: ' select /*+ FIRST_ROWS */ cs_kb_sets_tl.set_id id, score(10) score, cs_kb_sets_b.set_type_id,'||
3805: ' cs_kb_sets_tl.name, cs_kb_sets_tl.description, '||
3806: ' cs_kb_sets_b.creation_date, cs_kb_sets_b.created_by,'||
3807: ' cs_kb_sets_b.last_update_date, cs_kb_sets_b.last_updated_by, '||
3808: ' cs_kb_sets_b.last_update_login, cs_kb_set_types_tl.name, '||
3809: ' cs_kb_sets_b.set_number ';
3810: l_sql_f1 varchar2(100) :=
3811: ' from cs_kb_sets_tl, cs_kb_sets_b, cs_kb_set_types_tl ';

Line 3808: ' cs_kb_sets_b.last_update_login, cs_kb_set_types_tl.name, '||

3804: ' select /*+ FIRST_ROWS */ cs_kb_sets_tl.set_id id, score(10) score, cs_kb_sets_b.set_type_id,'||
3805: ' cs_kb_sets_tl.name, cs_kb_sets_tl.description, '||
3806: ' cs_kb_sets_b.creation_date, cs_kb_sets_b.created_by,'||
3807: ' cs_kb_sets_b.last_update_date, cs_kb_sets_b.last_updated_by, '||
3808: ' cs_kb_sets_b.last_update_login, cs_kb_set_types_tl.name, '||
3809: ' cs_kb_sets_b.set_number ';
3810: l_sql_f1 varchar2(100) :=
3811: ' from cs_kb_sets_tl, cs_kb_sets_b, cs_kb_set_types_tl ';
3812:

Line 3809: ' cs_kb_sets_b.set_number ';

3805: ' cs_kb_sets_tl.name, cs_kb_sets_tl.description, '||
3806: ' cs_kb_sets_b.creation_date, cs_kb_sets_b.created_by,'||
3807: ' cs_kb_sets_b.last_update_date, cs_kb_sets_b.last_updated_by, '||
3808: ' cs_kb_sets_b.last_update_login, cs_kb_set_types_tl.name, '||
3809: ' cs_kb_sets_b.set_number ';
3810: l_sql_f1 varchar2(100) :=
3811: ' from cs_kb_sets_tl, cs_kb_sets_b, cs_kb_set_types_tl ';
3812:
3813: l_sql_w1 varchar2(200) :=

Line 3811: ' from cs_kb_sets_tl, cs_kb_sets_b, cs_kb_set_types_tl ';

3807: ' cs_kb_sets_b.last_update_date, cs_kb_sets_b.last_updated_by, '||
3808: ' cs_kb_sets_b.last_update_login, cs_kb_set_types_tl.name, '||
3809: ' cs_kb_sets_b.set_number ';
3810: l_sql_f1 varchar2(100) :=
3811: ' from cs_kb_sets_tl, cs_kb_sets_b, cs_kb_set_types_tl ';
3812:
3813: l_sql_w1 varchar2(200) :=
3814: ' where contains(cs_kb_sets_tl.composite_assoc_index, :a1, 10)>0 ';
3815: l_sql_wrows varchar2(200) :=

Line 3819: ' and cs_kb_sets_tl.set_id = cs_kb_sets_b.set_id '||

3815: l_sql_wrows varchar2(200) :=
3816: ' where contains(cs_kb_sets_tl.composite_assoc_index, :a1)>0 ';
3817: l_sql_w varchar2(500) :=
3818: -- 3398078
3819: ' and cs_kb_sets_tl.set_id = cs_kb_sets_b.set_id '||
3820: -- ' and cs_kb_sets_tl.language=userenv(''LANG'') ' ||
3821: ' and cs_kb_set_types_tl.set_type_id = cs_kb_sets_b.set_type_id '||
3822: ' and cs_kb_set_types_tl.language=userenv(''LANG'') '; -- ||
3823:

Line 3821: ' and cs_kb_set_types_tl.set_type_id = cs_kb_sets_b.set_type_id '||

3817: l_sql_w varchar2(500) :=
3818: -- 3398078
3819: ' and cs_kb_sets_tl.set_id = cs_kb_sets_b.set_id '||
3820: -- ' and cs_kb_sets_tl.language=userenv(''LANG'') ' ||
3821: ' and cs_kb_set_types_tl.set_type_id = cs_kb_sets_b.set_type_id '||
3822: ' and cs_kb_set_types_tl.language=userenv(''LANG'') '; -- ||
3823:
3824: l_sql_o varchar2(100) := ' order by score desc ';
3825:

Line 4013: ' select /+ FIRST_ROWS / cs_kb_sets_tl.set_id id, score(10) score, cs_kb_sets_b.set_type_id,'||

4009: l_sql_srows varchar2(30) :=
4010: ' select count(*) ';
4011:
4012: l_sql_s varchar2(500) :=
4013: ' select /*+ FIRST_ROWS */ cs_kb_sets_tl.set_id id, score(10) score, cs_kb_sets_b.set_type_id,'||
4014: ' cs_kb_sets_tl.name, cs_kb_sets_tl.description, '||
4015: ' cs_kb_sets_b.creation_date, cs_kb_sets_b.created_by,'||
4016: ' cs_kb_sets_b.last_update_date, cs_kb_sets_b.last_updated_by, '||
4017: ' cs_kb_sets_b.last_update_login, cs_kb_set_types_tl.name ' ||

Line 4015: ' cs_kb_sets_b.creation_date, cs_kb_sets_b.created_by,'||

4011:
4012: l_sql_s varchar2(500) :=
4013: ' select /*+ FIRST_ROWS */ cs_kb_sets_tl.set_id id, score(10) score, cs_kb_sets_b.set_type_id,'||
4014: ' cs_kb_sets_tl.name, cs_kb_sets_tl.description, '||
4015: ' cs_kb_sets_b.creation_date, cs_kb_sets_b.created_by,'||
4016: ' cs_kb_sets_b.last_update_date, cs_kb_sets_b.last_updated_by, '||
4017: ' cs_kb_sets_b.last_update_login, cs_kb_set_types_tl.name ' ||
4018: ' cs_kb_sets_b.set_number ';
4019: l_sql_f1 varchar2(100) :=

Line 4016: ' cs_kb_sets_b.last_update_date, cs_kb_sets_b.last_updated_by, '||

4012: l_sql_s varchar2(500) :=
4013: ' select /*+ FIRST_ROWS */ cs_kb_sets_tl.set_id id, score(10) score, cs_kb_sets_b.set_type_id,'||
4014: ' cs_kb_sets_tl.name, cs_kb_sets_tl.description, '||
4015: ' cs_kb_sets_b.creation_date, cs_kb_sets_b.created_by,'||
4016: ' cs_kb_sets_b.last_update_date, cs_kb_sets_b.last_updated_by, '||
4017: ' cs_kb_sets_b.last_update_login, cs_kb_set_types_tl.name ' ||
4018: ' cs_kb_sets_b.set_number ';
4019: l_sql_f1 varchar2(100) :=
4020: ' from cs_kb_sets_tl, cs_kb_sets_b, cs_kb_set_types_tl ';

Line 4017: ' cs_kb_sets_b.last_update_login, cs_kb_set_types_tl.name ' ||

4013: ' select /*+ FIRST_ROWS */ cs_kb_sets_tl.set_id id, score(10) score, cs_kb_sets_b.set_type_id,'||
4014: ' cs_kb_sets_tl.name, cs_kb_sets_tl.description, '||
4015: ' cs_kb_sets_b.creation_date, cs_kb_sets_b.created_by,'||
4016: ' cs_kb_sets_b.last_update_date, cs_kb_sets_b.last_updated_by, '||
4017: ' cs_kb_sets_b.last_update_login, cs_kb_set_types_tl.name ' ||
4018: ' cs_kb_sets_b.set_number ';
4019: l_sql_f1 varchar2(100) :=
4020: ' from cs_kb_sets_tl, cs_kb_sets_b, cs_kb_set_types_tl ';
4021:

Line 4018: ' cs_kb_sets_b.set_number ';

4014: ' cs_kb_sets_tl.name, cs_kb_sets_tl.description, '||
4015: ' cs_kb_sets_b.creation_date, cs_kb_sets_b.created_by,'||
4016: ' cs_kb_sets_b.last_update_date, cs_kb_sets_b.last_updated_by, '||
4017: ' cs_kb_sets_b.last_update_login, cs_kb_set_types_tl.name ' ||
4018: ' cs_kb_sets_b.set_number ';
4019: l_sql_f1 varchar2(100) :=
4020: ' from cs_kb_sets_tl, cs_kb_sets_b, cs_kb_set_types_tl ';
4021:
4022: l_sql_w1 varchar2(200) :=

Line 4020: ' from cs_kb_sets_tl, cs_kb_sets_b, cs_kb_set_types_tl ';

4016: ' cs_kb_sets_b.last_update_date, cs_kb_sets_b.last_updated_by, '||
4017: ' cs_kb_sets_b.last_update_login, cs_kb_set_types_tl.name ' ||
4018: ' cs_kb_sets_b.set_number ';
4019: l_sql_f1 varchar2(100) :=
4020: ' from cs_kb_sets_tl, cs_kb_sets_b, cs_kb_set_types_tl ';
4021:
4022: l_sql_w1 varchar2(200) :=
4023: ' where contains(cs_kb_sets_tl.composite_assoc_index, :1, 10)>0 ';
4024: l_sql_w varchar2(500) :=

Line 4026: ' and cs_kb_sets_tl.set_id = cs_kb_sets_b.set_id '||

4022: l_sql_w1 varchar2(200) :=
4023: ' where contains(cs_kb_sets_tl.composite_assoc_index, :1, 10)>0 ';
4024: l_sql_w varchar2(500) :=
4025: -- 3398078
4026: ' and cs_kb_sets_tl.set_id = cs_kb_sets_b.set_id '||
4027: ' and cs_kb_set_types_tl.set_type_id = cs_kb_sets_b.set_type_id '||
4028: ' and cs_kb_set_types_tl.language=userenv(''LANG'') ';
4029:
4030: l_sql_o varchar2(100) := ' order by score desc ';

Line 4027: ' and cs_kb_set_types_tl.set_type_id = cs_kb_sets_b.set_type_id '||

4023: ' where contains(cs_kb_sets_tl.composite_assoc_index, :1, 10)>0 ';
4024: l_sql_w varchar2(500) :=
4025: -- 3398078
4026: ' and cs_kb_sets_tl.set_id = cs_kb_sets_b.set_id '||
4027: ' and cs_kb_set_types_tl.set_type_id = cs_kb_sets_b.set_type_id '||
4028: ' and cs_kb_set_types_tl.language=userenv(''LANG'') ';
4029:
4030: l_sql_o varchar2(100) := ' order by score desc ';
4031: