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_KB_SECURITY_PVT dependencies on CS_KB_VISIBILITIES_B

Line 161: FROM CS_KB_VISIBILITIES_B

157: l_return_status VARCHAR2(1);
158:
159: CURSOR Check_Insert (v_vis_id NUMBER) IS
160: SELECT COUNT(*)
161: FROM CS_KB_VISIBILITIES_B
162: WHERE VISIBILITY_ID = v_vis_id;
163:
164: CURSOR Get_Max_Position IS
165: SELECT nvl(max(position),0)+1

Line 166: FROM CS_KB_VISIBILITIES_B;

162: WHERE VISIBILITY_ID = v_vis_id;
163:
164: CURSOR Get_Max_Position IS
165: SELECT nvl(max(position),0)+1
166: FROM CS_KB_VISIBILITIES_B;
167:
168: CURSOR Check_Position (v_position NUMBER) IS
169: SELECT COUNT(*)
170: FROM CS_KB_VISIBILITIES_B

Line 170: FROM CS_KB_VISIBILITIES_B

166: FROM CS_KB_VISIBILITIES_B;
167:
168: CURSOR Check_Position (v_position NUMBER) IS
169: SELECT COUNT(*)
170: FROM CS_KB_VISIBILITIES_B
171: WHERE position = v_position;
172:
173: CURSOR Get_Position (v_vis NUMBER) IS
174: SELECT position

Line 175: FROM CS_KB_VISIBILITIES_B

171: WHERE position = v_position;
172:
173: CURSOR Get_Position (v_vis NUMBER) IS
174: SELECT position
175: FROM CS_KB_VISIBILITIES_B
176: WHERE visibility_id = v_vis;
177:
178: BEGIN
179:

Line 200: SELECT CS_KB_VISIBILITIES_B_S.nextval INTO l_seq from dual;

196:
197: -- If Visibility is null (Not called from OA) then generate from
198: -- the sequence.
199: IF P_VISIBILITY_ID IS NULL THEN
200: SELECT CS_KB_VISIBILITIES_B_S.nextval INTO l_seq from dual;
201: ELSE
202: l_seq := P_VISIBILITY_ID;
203: END IF;
204: --dbms_output.put_line('Sequence is ='||l_seq);

Line 256: UPDATE CS_KB_VISIBILITIES_B

252: -- from that position onwards down the list by one.
253: -- i.e. Update their positions by Adding 1
254: --dbms_output.put_line('Else Upd');
255:
256: UPDATE CS_KB_VISIBILITIES_B
257: SET Position = Position + 1
258: WHERE Position >= l_new_position;
259:
260: UPDATE CS_KB_CAT_GROUP_DENORM

Line 661: FROM CS_KB_VISIBILITIES_B

657: WHERE visibility_id = P_VISIBILITY_ID;
658:
659: CURSOR CHECK_VISIBILITY IS
660: SELECT count(*)
661: FROM CS_KB_VISIBILITIES_B
662: WHERE visibility_id = P_VISIBILITY_ID
663: AND sysdate between nvl(Start_Date_Active, sysdate -1)
664: and nvl(End_Date_Active, sysdate +1);
665:

Line 668: FROM CS_KB_VISIBILITIES_B

664: and nvl(End_Date_Active, sysdate +1);
665:
666: CURSOR GET_POSITION IS
667: SELECT Position
668: FROM CS_KB_VISIBILITIES_B
669: WHERE visibility_id = P_VISIBILITY_ID;
670:
671:
672: l_cat_count NUMBER;

Line 712: UPDATE CS_KB_VISIBILITIES_B

708: RAISE UNABLE_TO_DELETE_VIS;
709: ELSE
710:
711: -- We will nolonger Delete the Visibility - We will End Date it instead
712: UPDATE CS_KB_VISIBILITIES_B
713: SET End_Date_Active = sysdate - 0.001,
714: Last_Update_date = sysdate,
715: Last_updated_By = FND_GLOBAL.User_id
716: WHERE Visibility_Id = P_VISIBILITY_ID;

Line 1997: CS_KB_VISIBILITIES_b v

1993: SELECT b.category_id, b.visibility_id
1994: FROM cs_kb_soln_categories_b b
1995: WHERE b.category_id = P_CATEGORY_ID
1996: ) New_Members ,
1997: CS_KB_VISIBILITIES_b v
1998: WHERE New_Members.visibility_id = v.visibility_id
1999: AND NOT EXISTS (SELECT 'x'
2000: FROM CS_KB_CAT_GROUP_DENORM Denorm
2001: WHERE Denorm.Category_Group_id = P_CATEGORY_GROUP_ID

Line 2152: FROM CS_KB_VISIBILITIES_B

2148: AND Parent_Category_Id = P_PARENT_CATEGORY_ID;
2149:
2150: CURSOR Get_Visibility_Position IS
2151: SELECT Position
2152: FROM CS_KB_VISIBILITIES_B
2153: WHERE Visibility_Id = P_VISIBILITY_ID
2154: AND sysdate BETWEEN nvl(Start_Date_Active, sysdate-1)
2155: AND nvl(End_Date_Active, sysdate+1);
2156:

Line 2301: FROM CS_KB_VISIBILITIES_B

2297: WHERE Category_id = P_CATEGORY_ID;
2298:
2299: CURSOR Get_Position IS
2300: SELECT Position
2301: FROM CS_KB_VISIBILITIES_B
2302: WHERE Visibility_id = P_VISIBILITY_ID;
2303:
2304: l_cat_id NUMBER;
2305: l_vis_id NUMBER;

Line 2496: FROM cs_kb_soln_categories_b b , CS_KB_VISIBILITIES_b v

2492: ) RETURN VARCHAR2 IS
2493:
2494: CURSOR GET_CHILD_CATEGORIES ( v_cg NUMBER) IS
2495: SELECT b.category_id, b.visibility_id , v.position
2496: FROM cs_kb_soln_categories_b b , CS_KB_VISIBILITIES_b v
2497: WHERE b.visibility_id = v.visibility_id
2498: START WITH b.parent_category_id in (select m.category_id
2499: FROM CS_KB_CAT_GROUP_MEMBERS m
2500: where m.category_group_id = v_cg)

Line 2504: FROM cs_kb_soln_categories_b b, CS_KB_VISIBILITIES_b v

2500: where m.category_group_id = v_cg)
2501: CONNECT BY PRIOR b.category_id = b.parent_category_id
2502: UNION
2503: SELECT b.category_id, b.visibility_id, v.position
2504: FROM cs_kb_soln_categories_b b, CS_KB_VISIBILITIES_b v
2505: WHERE b.category_id in (select m.category_id
2506: FROM CS_KB_CAT_GROUP_MEMBERS m
2507: where m.category_group_id = v_cg)
2508: AND b.visibility_id = v.visibility_id;

Line 2577: FROM cs_kb_soln_categories_b b , CS_KB_VISIBILITIES_b v

2573: RETURN VARCHAR2 IS
2574:
2575: CURSOR GET_CHILD_CATEGORIES ( v_cg NUMBER) IS
2576: SELECT b.category_id, b.visibility_id , v.position
2577: FROM cs_kb_soln_categories_b b , CS_KB_VISIBILITIES_b v
2578: WHERE b.visibility_id = v.visibility_id
2579: START WITH b.parent_category_id in (select m.category_id
2580: FROM CS_KB_CAT_GROUP_MEMBERS m
2581: where m.category_group_id = v_cg)

Line 2585: FROM cs_kb_soln_categories_b b, CS_KB_VISIBILITIES_b v

2581: where m.category_group_id = v_cg)
2582: CONNECT BY PRIOR b.category_id = b.parent_category_id
2583: UNION
2584: SELECT b.category_id, b.visibility_id, v.position
2585: FROM cs_kb_soln_categories_b b, CS_KB_VISIBILITIES_b v
2586: WHERE b.category_id in (select m.category_id
2587: FROM CS_KB_CAT_GROUP_MEMBERS m
2588: where m.category_group_id = v_cg)
2589: AND b.visibility_id = v.visibility_id;

Line 2739: FROM CS_KB_VISIBILITIES_B

2735: RETURN NUMBER IS
2736:
2737: CURSOR GET_POSITION IS
2738: SELECT Position
2739: FROM CS_KB_VISIBILITIES_B
2740: WHERE VISIBILITY_ID = fnd_profile.value('CS_KB_ASSIGNED_SOLUTION_VISIBILITY_LEVEL')
2741: AND sysdate BETWEEN nvl(Start_Date_Active, sysdate-1)
2742: AND nvl(End_Date_Active, sysdate+1);
2743:

Line 2965: CS_KB_VISIBILITIES_B V

2961: v_soln_vis NUMBER) IS
2962: --v_stmt_vis NUMBER) IS
2963: SELECT count(*)
2964: FROM CS_KB_SETS_B S,
2965: CS_KB_VISIBILITIES_B V
2966: WHERE S.Set_Id = P_SET_ID
2967: AND S.Visibility_id = V.Visibility_id
2968: AND V.Position >= (SELECT Vis.Position
2969: FROM CS_KB_VISIBILITIES_B Vis

Line 2969: FROM CS_KB_VISIBILITIES_B Vis

2965: CS_KB_VISIBILITIES_B V
2966: WHERE S.Set_Id = P_SET_ID
2967: AND S.Visibility_id = V.Visibility_id
2968: AND V.Position >= (SELECT Vis.Position
2969: FROM CS_KB_VISIBILITIES_B Vis
2970: WHere Vis.Visibility_id = v_soln_vis
2971: AND sysdate BETWEEN nvl(Vis.Start_Date_Active, sysdate-1)
2972: AND nvl(Vis.End_Date_Active , sysdate+1)
2973: )

Line 2981: FROM CS_KB_VISIBILITIES_B Vis

2977: WHERE SC.Set_id = S.Set_id
2978: AND D.Category_Group_Id = v_cat_grp
2979: AND SC.Category_id = D.Child_Category_id
2980: AND D.Visibility_Position >= (SELECT Vis.Position
2981: FROM CS_KB_VISIBILITIES_B Vis
2982: WHERE Vis.Visibility_id = v_soln_vis
2983: AND sysdate BETWEEN nvl(Vis.Start_Date_Active, sysdate-1)
2984: AND nvl(Vis.End_Date_Active , sysdate+1)
2985: )