APPS.CS_KNOWLEDGE_PVT dependencies on CS_KB_SETS_B

Line 282: cs_kb_sets_b s,

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

Line 292: cs_kb_sets_b s

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

Line 877: from cs_kb_sets_b

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

Line 1307: update cs_kb_sets_b set

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

Line 1406: update cs_kb_sets_b set

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

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

3825: l_sql_srows varchar2(30) :=
3826: ' select count(*) ';
3827:
3828: l_sql_s varchar2(500) :=
3829: ' select /*+ FIRST_ROWS */ cs_kb_sets_tl.set_id id, score(10) score, cs_kb_sets_b.set_type_id,'||
3830: ' cs_kb_sets_tl.name, cs_kb_sets_tl.description, '||
3831: ' cs_kb_sets_b.creation_date, cs_kb_sets_b.created_by,'||
3832: ' cs_kb_sets_b.last_update_date, cs_kb_sets_b.last_updated_by, '||
3833: ' cs_kb_sets_b.last_update_login, cs_kb_set_types_tl.name, '||

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

3827:
3828: l_sql_s varchar2(500) :=
3829: ' select /*+ FIRST_ROWS */ cs_kb_sets_tl.set_id id, score(10) score, cs_kb_sets_b.set_type_id,'||
3830: ' cs_kb_sets_tl.name, cs_kb_sets_tl.description, '||
3831: ' cs_kb_sets_b.creation_date, cs_kb_sets_b.created_by,'||
3832: ' cs_kb_sets_b.last_update_date, cs_kb_sets_b.last_updated_by, '||
3833: ' cs_kb_sets_b.last_update_login, cs_kb_set_types_tl.name, '||
3834: ' cs_kb_sets_b.set_number ';
3835: l_sql_f1 varchar2(100) :=

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

3828: l_sql_s varchar2(500) :=
3829: ' select /*+ FIRST_ROWS */ cs_kb_sets_tl.set_id id, score(10) score, cs_kb_sets_b.set_type_id,'||
3830: ' cs_kb_sets_tl.name, cs_kb_sets_tl.description, '||
3831: ' cs_kb_sets_b.creation_date, cs_kb_sets_b.created_by,'||
3832: ' cs_kb_sets_b.last_update_date, cs_kb_sets_b.last_updated_by, '||
3833: ' cs_kb_sets_b.last_update_login, cs_kb_set_types_tl.name, '||
3834: ' cs_kb_sets_b.set_number ';
3835: l_sql_f1 varchar2(100) :=
3836: ' from cs_kb_sets_tl, cs_kb_sets_b, cs_kb_set_types_tl ';

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

3829: ' select /*+ FIRST_ROWS */ cs_kb_sets_tl.set_id id, score(10) score, cs_kb_sets_b.set_type_id,'||
3830: ' cs_kb_sets_tl.name, cs_kb_sets_tl.description, '||
3831: ' cs_kb_sets_b.creation_date, cs_kb_sets_b.created_by,'||
3832: ' cs_kb_sets_b.last_update_date, cs_kb_sets_b.last_updated_by, '||
3833: ' cs_kb_sets_b.last_update_login, cs_kb_set_types_tl.name, '||
3834: ' cs_kb_sets_b.set_number ';
3835: l_sql_f1 varchar2(100) :=
3836: ' from cs_kb_sets_tl, cs_kb_sets_b, cs_kb_set_types_tl ';
3837:

Line 3834: ' cs_kb_sets_b.set_number ';

3830: ' cs_kb_sets_tl.name, cs_kb_sets_tl.description, '||
3831: ' cs_kb_sets_b.creation_date, cs_kb_sets_b.created_by,'||
3832: ' cs_kb_sets_b.last_update_date, cs_kb_sets_b.last_updated_by, '||
3833: ' cs_kb_sets_b.last_update_login, cs_kb_set_types_tl.name, '||
3834: ' cs_kb_sets_b.set_number ';
3835: l_sql_f1 varchar2(100) :=
3836: ' from cs_kb_sets_tl, cs_kb_sets_b, cs_kb_set_types_tl ';
3837:
3838: l_sql_w1 varchar2(200) :=

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

3832: ' cs_kb_sets_b.last_update_date, cs_kb_sets_b.last_updated_by, '||
3833: ' cs_kb_sets_b.last_update_login, cs_kb_set_types_tl.name, '||
3834: ' cs_kb_sets_b.set_number ';
3835: l_sql_f1 varchar2(100) :=
3836: ' from cs_kb_sets_tl, cs_kb_sets_b, cs_kb_set_types_tl ';
3837:
3838: l_sql_w1 varchar2(200) :=
3839: ' where contains(cs_kb_sets_tl.composite_assoc_index, :a1, 10)>0 ';
3840: l_sql_wrows varchar2(200) :=

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

3840: l_sql_wrows varchar2(200) :=
3841: ' where contains(cs_kb_sets_tl.composite_assoc_index, :a1)>0 ';
3842: l_sql_w varchar2(500) :=
3843: -- 3398078
3844: ' and cs_kb_sets_tl.set_id = cs_kb_sets_b.set_id '||
3845: -- ' and cs_kb_sets_tl.language=userenv(''LANG'') ' ||
3846: ' and cs_kb_set_types_tl.set_type_id = cs_kb_sets_b.set_type_id '||
3847: ' and cs_kb_set_types_tl.language=userenv(''LANG'') '; -- ||
3848:

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

3842: l_sql_w varchar2(500) :=
3843: -- 3398078
3844: ' and cs_kb_sets_tl.set_id = cs_kb_sets_b.set_id '||
3845: -- ' and cs_kb_sets_tl.language=userenv(''LANG'') ' ||
3846: ' and cs_kb_set_types_tl.set_type_id = cs_kb_sets_b.set_type_id '||
3847: ' and cs_kb_set_types_tl.language=userenv(''LANG'') '; -- ||
3848:
3849: l_sql_o varchar2(100) := ' order by score desc ';
3850:

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

4034: l_sql_srows varchar2(30) :=
4035: ' select count(*) ';
4036:
4037: l_sql_s varchar2(500) :=
4038: ' select /*+ FIRST_ROWS */ cs_kb_sets_tl.set_id id, score(10) score, cs_kb_sets_b.set_type_id,'||
4039: ' cs_kb_sets_tl.name, cs_kb_sets_tl.description, '||
4040: ' cs_kb_sets_b.creation_date, cs_kb_sets_b.created_by,'||
4041: ' cs_kb_sets_b.last_update_date, cs_kb_sets_b.last_updated_by, '||
4042: ' cs_kb_sets_b.last_update_login, cs_kb_set_types_tl.name ' ||

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

4036:
4037: l_sql_s varchar2(500) :=
4038: ' select /*+ FIRST_ROWS */ cs_kb_sets_tl.set_id id, score(10) score, cs_kb_sets_b.set_type_id,'||
4039: ' cs_kb_sets_tl.name, cs_kb_sets_tl.description, '||
4040: ' cs_kb_sets_b.creation_date, cs_kb_sets_b.created_by,'||
4041: ' cs_kb_sets_b.last_update_date, cs_kb_sets_b.last_updated_by, '||
4042: ' cs_kb_sets_b.last_update_login, cs_kb_set_types_tl.name ' ||
4043: ' cs_kb_sets_b.set_number ';
4044: l_sql_f1 varchar2(100) :=

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

4037: l_sql_s varchar2(500) :=
4038: ' select /*+ FIRST_ROWS */ cs_kb_sets_tl.set_id id, score(10) score, cs_kb_sets_b.set_type_id,'||
4039: ' cs_kb_sets_tl.name, cs_kb_sets_tl.description, '||
4040: ' cs_kb_sets_b.creation_date, cs_kb_sets_b.created_by,'||
4041: ' cs_kb_sets_b.last_update_date, cs_kb_sets_b.last_updated_by, '||
4042: ' cs_kb_sets_b.last_update_login, cs_kb_set_types_tl.name ' ||
4043: ' cs_kb_sets_b.set_number ';
4044: l_sql_f1 varchar2(100) :=
4045: ' from cs_kb_sets_tl, cs_kb_sets_b, cs_kb_set_types_tl ';

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

4038: ' select /*+ FIRST_ROWS */ cs_kb_sets_tl.set_id id, score(10) score, cs_kb_sets_b.set_type_id,'||
4039: ' cs_kb_sets_tl.name, cs_kb_sets_tl.description, '||
4040: ' cs_kb_sets_b.creation_date, cs_kb_sets_b.created_by,'||
4041: ' cs_kb_sets_b.last_update_date, cs_kb_sets_b.last_updated_by, '||
4042: ' cs_kb_sets_b.last_update_login, cs_kb_set_types_tl.name ' ||
4043: ' cs_kb_sets_b.set_number ';
4044: l_sql_f1 varchar2(100) :=
4045: ' from cs_kb_sets_tl, cs_kb_sets_b, cs_kb_set_types_tl ';
4046:

Line 4043: ' cs_kb_sets_b.set_number ';

4039: ' cs_kb_sets_tl.name, cs_kb_sets_tl.description, '||
4040: ' cs_kb_sets_b.creation_date, cs_kb_sets_b.created_by,'||
4041: ' cs_kb_sets_b.last_update_date, cs_kb_sets_b.last_updated_by, '||
4042: ' cs_kb_sets_b.last_update_login, cs_kb_set_types_tl.name ' ||
4043: ' cs_kb_sets_b.set_number ';
4044: l_sql_f1 varchar2(100) :=
4045: ' from cs_kb_sets_tl, cs_kb_sets_b, cs_kb_set_types_tl ';
4046:
4047: l_sql_w1 varchar2(200) :=

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

4041: ' cs_kb_sets_b.last_update_date, cs_kb_sets_b.last_updated_by, '||
4042: ' cs_kb_sets_b.last_update_login, cs_kb_set_types_tl.name ' ||
4043: ' cs_kb_sets_b.set_number ';
4044: l_sql_f1 varchar2(100) :=
4045: ' from cs_kb_sets_tl, cs_kb_sets_b, cs_kb_set_types_tl ';
4046:
4047: l_sql_w1 varchar2(200) :=
4048: ' where contains(cs_kb_sets_tl.composite_assoc_index, :1, 10)>0 ';
4049: l_sql_w varchar2(500) :=

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

4047: l_sql_w1 varchar2(200) :=
4048: ' where contains(cs_kb_sets_tl.composite_assoc_index, :1, 10)>0 ';
4049: l_sql_w varchar2(500) :=
4050: -- 3398078
4051: ' and cs_kb_sets_tl.set_id = cs_kb_sets_b.set_id '||
4052: ' and cs_kb_set_types_tl.set_type_id = cs_kb_sets_b.set_type_id '||
4053: ' and cs_kb_set_types_tl.language=userenv(''LANG'') ';
4054:
4055: l_sql_o varchar2(100) := ' order by score desc ';

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

4048: ' where contains(cs_kb_sets_tl.composite_assoc_index, :1, 10)>0 ';
4049: l_sql_w varchar2(500) :=
4050: -- 3398078
4051: ' and cs_kb_sets_tl.set_id = cs_kb_sets_b.set_id '||
4052: ' and cs_kb_set_types_tl.set_type_id = cs_kb_sets_b.set_type_id '||
4053: ' and cs_kb_set_types_tl.language=userenv(''LANG'') ';
4054:
4055: l_sql_o varchar2(100) := ' order by score desc ';
4056: