[Home] [Help]
3339: l_soln_visibility_id := 0;
3340: End If;
3341:
3342: l_category_group_id :=
3343: CS_KB_SECURITY_PVT.Get_Category_Group_Id();
3344: l_catgrp_vis := TO_CHAR(l_category_group_id) || 'a'
3345: ||to_char(l_soln_visibility_id);
3346:
3347: --1. Clean up the p_raw_text.
3660: l_soln_visibility_id := 0;
3661: End If;
3662:
3663: l_category_group_id :=
3664: CS_KB_SECURITY_PVT.Get_Category_Group_Id();
3665: l_catgrp_vis := TO_CHAR(l_category_group_id) || 'a'
3666: ||to_char(l_soln_visibility_id)||
3667: ' within CATEGORYGROUPS ';
3668:
3728: l_query_filter := l_query_filter || l_type_cond;
3729: End if;
3730:
3731: l_stmt_visibility :=
3732: CS_KB_SECURITY_PVT.Get_Stmt_Visibility_Position();
3733: l_access_level_filter := '(a'||to_char(l_stmt_visibility)
3734: ||'a within ACCESS)';
3735: l_query_filter := l_query_filter ||' & '||
3736: l_access_level_filter;
4358: l_soln_visibility_id := 0;
4359: End If;
4360:
4361: l_category_group_id :=
4362: CS_KB_SECURITY_PVT.Get_Category_Group_Id();
4363: l_catgrp_vis := '('||TO_CHAR(l_category_group_id) || 'a'
4364: ||to_char(l_soln_visibility_id)||' within CATEGORYGROUPS )';
4365: l_stmt_visibility := CS_KB_SECURITY_PVT.Get_Stmt_Visibility_Position();
4366:
4361: l_category_group_id :=
4362: CS_KB_SECURITY_PVT.Get_Category_Group_Id();
4363: l_catgrp_vis := '('||TO_CHAR(l_category_group_id) || 'a'
4364: ||to_char(l_soln_visibility_id)||' within CATEGORYGROUPS )';
4365: l_stmt_visibility := CS_KB_SECURITY_PVT.Get_Stmt_Visibility_Position();
4366:
4367: If (p_statement_id_tbl is not null
4368: and p_statement_id_tbl.COUNT > 0)
4369: then