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_CAT_GROUP_DENORM

Line 260: UPDATE CS_KB_CAT_GROUP_DENORM

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
261: SET Visibility_Position = Visibility_Position + 1
262: WHERE Visibility_Position >= l_new_position;
263:
264: l_position := l_new_position;

Line 1859: --Remove FK records for Member + Children from CS_KB_CAT_GROUP_DENORM

1855: OPEN CHECK_DELETE;
1856: FETCH CHECK_DELETE INTO l_valid;
1857: CLOSE CHECK_DELETE;
1858: IF l_valid = 0 THEN
1859: --Remove FK records for Member + Children from CS_KB_CAT_GROUP_DENORM
1860: REMOVE_CG_MEMBER_FROM_DENORM ( P_CATEGORY_GROUP_ID, P_CATEGORY_ID);
1861:
1862: --X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1863: CS_KB_SYNC_INDEX_PKG.request_mark_idx_on_sec_change

Line 2000: FROM CS_KB_CAT_GROUP_DENORM Denorm

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
2002: AND Denorm.Child_Category_Id = New_Members.Category_Id);
2003:
2004: --Type NumTabType is VARRAY(10000) of NUMBER;

Line 2025: INSERT INTO CS_KB_CAT_GROUP_DENORM (

2021: --dbms_output.put_line ('Cat count:'||position_list.count );
2022:
2023: FORALL i in 1..child_cat_id_list.count
2024:
2025: INSERT INTO CS_KB_CAT_GROUP_DENORM (
2026: CATEGORY_GROUP_ID,
2027: CHILD_CATEGORY_ID,
2028: VISIBILITY_ID,
2029: VISIBILITY_POSITION,

Line 2102: DELETE FROM CS_KB_CAT_GROUP_DENORM

2098: --dbms_output.put_line ('Cat count:'||child_cat_id_list.count );
2099:
2100: FORALL i in 1..child_cat_id_list.count
2101:
2102: DELETE FROM CS_KB_CAT_GROUP_DENORM
2103: WHERE Category_Group_id = P_CATEGORY_GROUP_ID
2104: AND Child_Category_Id = child_cat_id_list(i);
2105:
2106: END REMOVE_CG_MEMBER_FROM_DENORM;

Line 2159: FROM CS_KB_CAT_GROUP_DENORM

2155: AND nvl(End_Date_Active, sysdate+1);
2156:
2157: CURSOR GET_GROUPS IS
2158: SELECT Distinct Category_Group_Id
2159: FROM CS_KB_CAT_GROUP_DENORM
2160: WHERE CHILD_CATEGORY_ID = P_PARENT_CATEGORY_ID;
2161:
2162: --Type NumTabType is VARRAY(10000) of NUMBER;
2163: Type NumTabType IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 2199: INSERT INTO CS_KB_CAT_GROUP_DENORM

2195:
2196: --FOR x IN Get_Groups LOOP
2197: FORALL i in 1..cat_grp_id_list.count
2198:
2199: INSERT INTO CS_KB_CAT_GROUP_DENORM
2200: ( CATEGORY_GROUP_ID,
2201: CHILD_CATEGORY_ID,
2202: VISIBILITY_ID,
2203: VISIBILITY_POSITION,

Line 2280: -- information in CS_KB_CAT_GROUP_DENORM if a Categories associated

2276: --
2277: --
2278: -- Notes :
2279: -- 1) This api is required to update the denormalized Visibility
2280: -- information in CS_KB_CAT_GROUP_DENORM if a Categories associated
2281: -- Visibility changes
2282: --
2283: -- Used By:
2284: -- 1) CS_KB_SOLN_CATEGORIES_PVT.updateCategory

Line 2328: UPDATE CS_KB_CAT_GROUP_DENORM

2324: CLOSE Get_Position;
2325:
2326: IF l_position IS NOT NULL THEN
2327:
2328: UPDATE CS_KB_CAT_GROUP_DENORM
2329: SET Visibility_id = P_VISIBILITY_ID,
2330: Visibility_Position = l_position,
2331: Last_Update_Date = l_date,
2332: Last_Updated_By = l_current_user,

Line 2393: -- CS_KB_CAT_GROUP_MEMBERS and CS_KB_CAT_GROUP_DENORM

2389: --
2390: --
2391: -- Notes :
2392: -- 1) If a Category is deleted this api will remove the FK links in
2393: -- CS_KB_CAT_GROUP_MEMBERS and CS_KB_CAT_GROUP_DENORM
2394: --
2395: --
2396: -- Used By:
2397: -- 1) CS_KB_SOLN_CATEGORIES_PVT.removeCategory

Line 2413: FROM CS_KB_CAT_GROUP_DENORM

2409: WHERE Category_id = P_CATEGORY_ID;
2410:
2411: CURSOR Check_Delete_Denorm IS
2412: SELECT count(*)
2413: FROM CS_KB_CAT_GROUP_DENORM
2414: WHERE Child_Category_id = P_CATEGORY_ID;
2415:
2416: l_denorm_count NUMBER;
2417: l_member_count NUMBER;

Line 2428: DELETE FROM CS_KB_CAT_GROUP_DENORM

2424: -- 1. Removes Category from Members table if the Category Exists
2425: DELETE FROM CS_KB_CAT_GROUP_MEMBERS
2426: WHERE Category_Id = P_CATEGORY_ID;
2427: -- 2. Removes Category from Denorm table if the Category Exists
2428: DELETE FROM CS_KB_CAT_GROUP_DENORM
2429: WHERE Child_Category_Id = P_CATEGORY_ID;
2430:
2431: OPEN Check_Delete_Member;
2432: FETCH Check_Delete_Member INTO l_member_count;

Line 2526: DELETE FROM CS_KB_CAT_GROUP_DENORM

2522: l_return VARCHAR2(10) := 'TRUE';
2523:
2524: BEGIN
2525: --dbms_output.put_line('In pop denorm');
2526: DELETE FROM CS_KB_CAT_GROUP_DENORM
2527: WHERE category_group_id = P_CATEGORY_GROUP_ID;
2528: --dbms_output.put_line('After Delete');
2529:
2530:

Line 2542: INSERT INTO CS_KB_CAT_GROUP_DENORM (

2538: --dbms_output.put_line ('Cat count:'||position_list.count );
2539:
2540: FORALL i in 1..child_cat_id_list.count --LOOP
2541:
2542: INSERT INTO CS_KB_CAT_GROUP_DENORM (
2543: CATEGORY_GROUP_ID,
2544: CHILD_CATEGORY_ID,
2545: VISIBILITY_ID,
2546: VISIBILITY_POSITION,

Line 2613: DELETE FROM CS_KB_CAT_GROUP_DENORM;

2609: l_return VARCHAR2(10) := 'TRUE';
2610:
2611: BEGIN
2612: --dbms_output.put_line('In pop denorm');
2613: DELETE FROM CS_KB_CAT_GROUP_DENORM;
2614: --dbms_output.put_line('After Delete');
2615:
2616: FOR x IN GET_CATEGORY_GROUPS LOOP
2617:

Line 2629: INSERT INTO CS_KB_CAT_GROUP_DENORM (

2625: --dbms_output.put_line ('Cat count:'||position_list.count );
2626:
2627: FORALL i in 1..child_cat_id_list.count --LOOP
2628:
2629: INSERT INTO CS_KB_CAT_GROUP_DENORM (
2630: CATEGORY_GROUP_ID,
2631: CHILD_CATEGORY_ID,
2632: VISIBILITY_ID,
2633: VISIBILITY_POSITION,

Line 2976: CS_KB_CAT_GROUP_DENORM D

2972: AND nvl(Vis.End_Date_Active , sysdate+1)
2973: )
2974: AND EXISTS (SELECT 'x'
2975: FROM CS_KB_SET_CATEGORIES SC,
2976: CS_KB_CAT_GROUP_DENORM D
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

Line 3103: DELETE FROM cs_kb_cat_group_denorm d

3099:
3100: -- Firstly Delete all the Records in the Denorm Table For the Moved
3101: -- Catageory and its Children except where this Category has been directly
3102: -- associated to a Category Group (via a link in CS_KB_CAT_GROUP_MEMBERS)
3103: DELETE FROM cs_kb_cat_group_denorm d
3104: WHERE d.child_category_id IN (SELECT b.category_id
3105: FROM cs_kb_soln_categories_b b
3106: START WITH b.category_id = P_CATEGORY_ID
3107: CONNECT BY PRIOR b.category_id =